|
| 1 person marked this as a favorite. |
Hey everyone
I have been working on this off an on for a while, and made a final push recently to get it mostly done. This character sheet is made to be used with tablets, as the title says, and has 1 macro button in it to "roll" so to speak. (essentially, it calculates the sheet each time it is pressed.)
It does not work well with Ipads/phones or even Android b/c they dont yet have full excel. =( which sux, but for those of use with windows tablets and phones, this is pretty rad I think.
Check it out and let me know what you think. It has multiple tabs, and the last 2 are instructions sheets. I wont say too much, b/c I want to know if the instructions are clear enough to make sense of the thing.
Lastly, if you want to see the scripting, its mostly IF statements within IF statements galore, and its all recolored to be invisible to the right of the "data sheet" and small amount below the character sheet.
Here is the Google Drive shared link, it will look funny online, since its excel, just DL it to and open with excel.
https://drive.google.com/file/d/0BzPPLvYQtQDGSU5pbWt0akZMc0U/edit?usp=shari ng
https://drive.google.com/file/d/0BzPPLvYQtQDGSU5pbWt0akZMc0U/edit?usp =sharing
-> Link
|
|
https://drive.google.com/file/d/0BzPPLvYQtQDGSU5pbWt0akZMc0U/edit?usp =sharing-> Link
Fine, fine. I got lazy. it was all the excel scripting I didnt want to do any more! here is a new, shiny link.
This doesn't work for me though.
Updating my base stats doesn't change any other cell. I assume that's supposed to be immediate looking at the equations.
EDIT: That was already a link, I put it in the formatting for you :P
EDIT 2: What version of excel did you do this in? :S I have 2010 so that might be too old.
|
|
This doesn't work for me though.
Updating my base stats doesn't change any other cell. I assume that's supposed to be immediate looking at the equations.
EDIT: That was already a link, I put it in the formatting for you :P
EDIT 2: What version of excel did you do this in? :S I have 2010 so that might be too old.
I actually work on it in 2010 at work, 2013 at home. and though some of the formatting gets wonky (like fonts and sizing) all the calculations seem to work fine.
I did have some issues with the calculations on the datasheet not updating right away. This may be something you already tried, but once you input data, go to the Formula Tab and hit "calculate now" to be sure it updates everything.
This doesn't work for me though.
Updating my base stats doesn't change any other cell. I assume that's supposed to be immediate looking at the equations.
EDIT: That was already a link, I put it in the formatting for you :P
EDIT 2: What version of excel did you do this in? :S I have 2010 so that might be too old.
I actually work on it in 2010 at work, 2013 at home. and though some of the formatting gets wonky (like fonts and sizing) all the calculations seem to work fine.
I did have some issues with the calculations on the datasheet not updating right away. This may be something you already tried, but once you input data, go to the Formula Tab and hit "calculate now" to be sure it updates everything.
Ah, right. Works perfectly now that I know to press that. Thanks :D
|
|
Ah, right. Works perfectly now that I know to press that. Thanks :DThis doesn't work for me though.
Updating my base stats doesn't change any other cell. I assume that's supposed to be immediate looking at the equations.
EDIT: That was already a link, I put it in the formatting for you :P
EDIT 2: What version of excel did you do this in? :S I have 2010 so that might be too old.
I actually work on it in 2010 at work, 2013 at home. and though some of the formatting gets wonky (like fonts and sizing) all the calculations seem to work fine.
I did have some issues with the calculations on the datasheet not updating right away. This may be something you already tried, but once you input data, go to the Formula Tab and hit "calculate now" to be sure it updates everything.
Fantastic. That is essentially what the button does on the character sheet (emulates clicking calculate now). Once you have used it some, let me know what you think or if you find any errors.
I won't be able to use it for a while (skip weeks and alternating games etc) but I'll definitely let you know how it goes :o
So I looked at your character sheet on my PC and it looks very good. However, like most character sheets it does not take into account the Monk.
I know you can't do EVERYTHING, no one can. There were important things missing. Take the CMB. The Monk replaces BAB with his level. He also adds Wisdom bonus.
There isn't a KI pool that I can see.
If I was building a magus (like for my next game) there would be no place for the Arcane Pool.
Also there is the Ninja's Arcane Pool.
Which Classes is this sheet for?
|
|
So I looked at your character sheet on my PC and it looks very good. However, like most character sheets it does not take into account the Monk.
I know you can't do EVERYTHING, no one can. There were important things missing. Take the CMB. The Monk replaces BAB with his level. He also adds Wisdom bonus.
There isn't a KI pool that I can see.If I was building a magus (like for my next game) there would be no place for the Arcane Pool.
Also there is the Ninja's Arcane Pool.Which Classes is this sheet for?
Thanks for checking the sheet out. I actually began this sheet with just that in mind, that I can't take everything into account. Not without making it very, very complicate.
First off, when I say auto calculating, I mean your die rolls. I am actually using it very successfully with a Magus/Monk right now. How? First, for flurry, on the character sheet tab, when you click the it on, you need to enter your adjusted flurry BAB in the box to the right (which has a little note on it to do so).
For "pools" of various kinds, I placed little check boxes to the right of the condition track boxes to be copy/pasted into the class ability section. So, you would type in "Arcane Pool" and copy/paste in a number of appropriate check boxes to track your pool.
For more difficult to calculate things, like monks CMB bonus and other wonky class abilities like INT to melee attack I left those selections as user input. You'll notice that on the attack matrix on the character sheet, the far left and right have boxes for Attack and Damage Stat as well as generic attack and damage bonuses (or penalties).
For CMB and CMD, on the Data Sheet, the Stats also get input manually, as well as sections for misc. bonuses or penalties (like size). Same goes for the Armor Class section on the Data sheet.
As I write this, I realize I may not have included the size modifiers for CMB/CMD for the spell/condition mod check boxes... anyway, fix that later.
Last, for skills that use an alternate stat, I decided to leave them auto populating the stat bonus as normal, and the user can adjust the difference in the misc. bonus/penalty box on the data sheet's skill tracker. The idea is that all the various bonuses that add up to your total are input and visible on the Data Sheet, but only the final product is visible on the Character Sheet.