|4 people marked this as a favorite.|
Good evening people.
I have a bit of an obsession with excel nesting. Did you know that you can nest a maximum of 64 "IF" statements in 1 cell?
Any who... I have created a few auto calculating excel sheets for touch screens and this one here is my max effort.
It is designed specifically for a 1920x1080 touch screen, though a laptop will work just fine as well. Obviously, that's a specific, if growing, group of gamers.
Regardless, I have spent about 3 weeks and many, many hours creating it and I wanted to share it for those that think they might be able to use it.
Some more details:
-If you use the sheet, set "auto-calculate" off (google can show you how)
-The sheet uses 1 macro, so you will get a security wanting most likely, this is the macro:
Application.Calculation = xlManual
For Each sh In ActiveWorkbook.Sheets
(it basically recreates pressing F9 to force the sheet to calculate)
-The Macro is activated by buttons on the sheet.
-Check boxes are used to swicth variables off and on, such as feat effects, condition effects, spell and class buffs...
-I have tested the sheet exhaustively, but its pretty friggin complicated with all the formulas, so something might be off... I dont think so though.
-the sheet is set up to be as flexible as possible, and includes natural weapons, 2 weapon fighting (.5x STR), flurry, 2 handed weapon (1.5x STR).
-If your making an archer, you can delete the sections for 2 weapon fighting, for instance, without effecting the other calculations. (save a back up first... just in case)
-It includes an Instruction tab for helpful hints.
-Generally, to avoid errors in the attack calculations, be sure to check the correct weapon(s) and feats/effects. For instance, if you have 1 or more of the 3 two-weapon fighting feats checked AND Flurry checked, the attacks wont calc correctly.
Here is the link to the shared google drive where the sheets are located. Google drive sheet location. I included a filled in sheet as well as an example.
Let me know what you think! If you find any errors, I will try to fix them, but I can't promise it will be very quick, I have 2 kids and not a lot of time... also, will entertain requests, but again, 2 kids...
It seems to not work in Google Drive. I hope to be getting excel soon so I will look at it then.
Yeah, Drive wont process the macro enabled excel sheet, and even if it would open it, the formulas wouldn't work.
Any of the free excel versions out in the webs should work. Student version, free trial running outside of the trial period (with the red bar and notice that your time is up...)
pretty cool just one thing i noted is your stat section calculates the number as the bonus so you need to put 4 not 18 for example
Yeah, should have noted that. Sorry.
You put the actual stat in on the data sheet tab. The character sheet only shows the modifier, since that's what really matters. the blue box on the character sheet is also for misc. modifier + / -.
Found a minor error in the AC calculation. It was not adding the armor enhancement bonus from the character sheet screen. Fixed.
Found a minor error in the CMB and CMD calculations. It is not calculating in weapon enhancement for CMB and CMD is not correctly adding any relevant buffs to AC, such as deflection bonuses from thing like SoF. NOT fixed yet, later today...
Do you know anything about getting an excel spreadsheet like this to work in Calc?
I just plain do not use Microsoft, other than things like this I have absolutely no reason to buy Microsoft Office.
Is there any magic bullet to get it to work?
I feel your pain. I have looked quite a bit but have not found anything. Its the Macro I think that prevents it from working in alt programs. that and the specific "IF" statements that link to different tabs in the sheet.
I know Apple is working on a program and updating it frequently to work with excel sheet as much as possible so people can use excel at full capacity on iPads.
I know this sheet does not have a lot of application to most players, but for those of us who like to game with tablets, and use Windows tabs, this is an optimised excel sheet
Much of the sheet is auto calculating based on input in a data tab, and carried over to the character sheet tab.
Just fill in the light blue shaded areas and use the buttons on the character sheet tab to caclulate the relevant areas.
- the skills area of the data sheet requires a Yes or No answer to be input in the trained and class skill collumns.
- Some areas require you to input a stat to use (those that do already have a stat input), always use this format: STR, DEX, CON, INT, WIS, CHR.
- Eventually I will get around to making a better instructions tab, ignore the one already included.
- This should fit about perfect at 100% zoom on 1080.
- Shared on Google Drive Here:
- This IS an Excel sheet and uses various simple marcros to allow calculating using a touch screen. Because of the complicated formulas, most or all of the non-windows excel programs probably will not work with this.
Forgot to mention, the sheet has many check boxes, which you much check to activate. Some of the check boxes activate die rolling and result formulas on the sheet, other activate modifying variables for calculations.
When you check a box or boxes, you need to hit the "Calculate All" button (bottom center) to propagate all of the changes, then you can use the relavent "Roll" button with the new modifiers calculated in.
two more things I should mentions: the weapons section to the right of the sheet might be somewhat less than obvious in regards to how to use it.
First, fill in the blue shaded info boxes with the relavent details, such as Stats to use, bonuses to hit and damage.
Second, in the right section of the 4 weapon areas, check the "Equiped" box to use that weapon in an attack when you click the attack and damage button.