Heya everyone, I've seen a lot of nice autocalculating character spreadsheets for Excel around, but none of them are compatible with OpenOffice, and since I don't feel like paying Microsoft a couple hundred dollars for Excel, well...I'm left to make my own!
So...what would you want to see in an autocalculating character sheet? I'm not super good with Calc, but so far I've been able to figure most things out. But if I'm gonna do this anyway, I may as well do it right and in a way other people will get some use out of it! So, thoughts? Opinions? Requests? Let me hear them!
Heya everyone, I've seen a lot of nice autocalculating character spreadsheets for Excel around, but none of them are compatible with OpenOffice, and since I don't feel like paying Microsoft a couple hundred dollars for Excel, well...I'm left to make my own!
So...what would you want to see in an autocalculating character sheet? I'm not super good with Calc, but so far I've been able to figure most things out. But if I'm gonna do this anyway, I may as well do it right and in a way other people will get some use out of it! So, thoughts? Opinions? Requests? Let me hear them!
This suggestion might be too much but here it goes...to have all the Feats, Variants (class/racial), etc. from ALL books of PF (Core, AC, UM, APG,Bestiary if something applies).
I am using an EXCEL sheet I found online and somethings does not calculate...so make sure you have all your formulas, IF statements, and macros correct...Something nice could be to add an auto-dice roller for Stats and HP
If you'd like a starting point, check my profile. I supported the Character Excelerator up to the point when APG cam out and I lost the time for upkeep. One of my design goals was keeping it OpenOffice compatible. You're welcome to whatever use/help it might provide!
This suggestion might be too much but here it goes...to have all the Feats, Variants (class/racial), etc. from ALL books of PF (Core, AC, UM, APG,Bestiary if something applies).
I am using an EXCEL sheet I found online and somethings does not calculate...so make sure you have all your formulas, IF statements, and macros correct...
Something nice could be to add an auto-dice roller for Stats and HP
I don't know where to even begin for making any sort of rolling device. >_> <_< But I'm not really setting out to make a character creator, just an autocalculating character sheet, so the rolling doesn't really seem necessary.
My initial idea is to make a separate sheet for each class, and if I can figure out how to do it (I've never worked with the dropdown type stuff in it, only formulas), build into each one the various options for that class, but keep it easy enough still to support multiclassing either via copying the relevant bits from the other class's sheet or if I can make it do it automatically. I'll definitely make sure the calculations are correct though (but when I release it if they're not, feel free to tell me, lol).
If you'd like a starting point, check my profile. I supported the Character Excelerator up to the point when APG cam out and I lost the time for upkeep. One of my design goals was keeping it OpenOffice compatible. You're welcome to whatever use/help it might provide!
Oh wow, really? I'll definitely take a look at that then - I haven't seen any of them that actually work with OpenOffice thus far, so I'm sure that'll be a big help!
No problem. Note that it is focused on actual character creation, so there's lots of internal functionality. I refined my techniques over time and ended up with some pretty slick approaches to things like dynamic drop-down selectors and text block displays.
For a dice roller, you could use something like
=RANDBETWEEN(1,6)
to return a value for a 1d6 roll. You could create four of these in separate cells (say A1:A4) then use the following to simulate a "roll 4d6, keep the highest" roll:
=SUM(A1:A4)-MIN(A1:A4)
You could take this base and build out some selectors for die type, number to roll, etc. and make a whole "choose your own rolls" section.
Heya everyone, I've seen a lot of nice autocalculating character spreadsheets for Excel around, but none of them are compatible with OpenOffice, and since I don't feel like paying Microsoft a couple hundred dollars for Excel, well...I'm left to make my own!
So...what would you want to see in an autocalculating character sheet? I'm not super good with Calc, but so far I've been able to figure most things out. But if I'm gonna do this anyway, I may as well do it right and in a way other people will get some use out of it! So, thoughts? Opinions? Requests? Let me hear them!
This suggestion might be too much but here it goes...to have all the Feats, Variants (class/racial), etc. from ALL books of PF (Core, AC, UM, APG,Bestiary if something applies).
I am using an EXCEL sheet I found online and somethings does not calculate...so make sure you have all your formulas, IF statements, and macros correct...
Something nice could be to add an auto-dice roller for Stats and HP
That's not a character sheet. That's a character builder program.
I have a character sheet template built for open office. You have to enter data yourself, which is why it is a character sheet. But it calculates data here and there. If you want some of the fancier stuff to happen on the spell sheets (like auto-calculating the effect of the spell based on level), you have to be able provide it yourself
That's not a character sheet. That's a character builder program.
I have a character sheet template built for open office. You have to enter data yourself, which is why it is a character sheet. But it calculates data here and there. If you want some of the fancier stuff to happen on the spell sheets (like auto-calculating the effect of the spell based on level), you have to be able provide it yourself
That's more what I've got going so far. I've been working on it for a barbarian I made and have yet to play, and have it so it's autocalculating her DR, BAB, rage rounds, skill bonuses, attack bonuses, etc. based on the inputs I give it...but to do things like add in or change a stat (if you have Intimidating Prowess or Weapon Finesse or whatnot) you hafta actually alter the code, which probably won't help for people that just want a sheet and don't want to dig into how to make it work. I'm trying to figure out how to automate those things too...
A lot of stuff you can't auto-calculate for various reasons in a character sheet instead of character generator, even if it seems you can. I just let the sheet do the math and put in the feeder values.
I could put up my sheet later and I'm sure some ideas would improve it more for general use.
I think I need to add a combat sheet and do with classes what I did with skill points to make it easier and more correct to use for, well combat, and multi-classing.
I have the current (alpha) version of the barbarian sheet ready (this is what I'm actually using in game at the moment) if anyone would like to see it. I don't know where to upload it is the only thing. >_> <_< So yeah...if anyone's interested, let me know (and if you have a place to suggest for uploading that'd be great) and I'll put it out there for your critique.
I have the current (alpha) version of the barbarian sheet ready (this is what I'm actually using in game at the moment) if anyone would like to see it. I don't know where to upload it is the only thing. >_> <_< So yeah...if anyone's interested, let me know (and if you have a place to suggest for uploading that'd be great) and I'll put it out there for your critique.
u could send to my email: foram3438@yahoo.com
Google docs makes sharing documents really easy. Just make sure it doesn't convert your sheet to Google Docs sheet style - they use different formulas and half of everything gets FUBAR.
Huh...so they do. Weeeelll...here it is then.
This is the alpha, filled in for my current character - it does require changing formula things for some things (like whether a weapon bases off strength or dex) but it does a lot of autocalcing for you. Anyway, take a look if you feel like it and lemme know what you think!
Huh...so they do. Weeeelll...here it is then.
This is the alpha, filled in for my current character - it does require changing formula things for some things (like whether a weapon bases off strength or dex) but it does a lot of autocalcing for you. Anyway, take a look if you feel like it and lemme know what you think!
It does no show any autocalculations...just input of data...
It does no show any autocalculations...just input of data...Huh...so they do. Weeeelll...here it is then.
This is the alpha, filled in for my current character - it does require changing formula things for some things (like whether a weapon bases off strength or dex) but it does a lot of autocalcing for you. Anyway, take a look if you feel like it and lemme know what you think!
You do have to input something, but the sample there has it already entered. But if, for example, you change the level to one where rage goes up, you'll see that automatically change. Rage rounds will go up when you level up. If you change the stats, they'll automatically switch to the correct bonus, and that will be applied to skills, attacks, CMB, saves, etc. Is it not doing that?
This is the alpha, filled in for my current character - it does require changing formula things for some things (like whether a weapon bases off strength or dex)
Add an option to record whether a weapon is ranged then have it auto-calc based on a weapon being ranged. You could use a validity restriction to make it changeable from Yes to No and autocalculate easier for weapons that can be both.
Add an option to record whether a weapon is ranged then have it auto-calc based on a weapon being ranged. You could use a validity restriction to make it changeable from Yes to No and autocalculate easier for weapons that can be both.
This is the alpha, filled in for my current character - it does require changing formula things for some things (like whether a weapon bases off strength or dex)
I could do that I suppose, yeah. I might end up making it so if range has a...well, range in it, it'll go based off dex, and if not off strength. The problem would be if you have finesse or something that changes that...I suppose I could do like with skills and just put the stat you use next to it and it can grab from there though.
I could do that I suppose, yeah. I might end up making it so if range has a...well, range in it, it'll go based off dex, and if not off strength. The problem would be if you have finesse or something that changes that...I suppose I could do like with skills and just put the stat you use next to it and it can grab from there though.Add an option to record whether a weapon is ranged then have it auto-calc based on a weapon being ranged. You could use a validity restriction to make it changeable from Yes to No and autocalculate easier for weapons that can be both.
This is the alpha, filled in for my current character - it does require changing formula things for some things (like whether a weapon bases off strength or dex)
Weapons have a lot of details.
Ranged: Yes/NoFinessable: Yes/No (Only Yes if Yes AND have Weapon Finesse)
Thrown Ranged: Yes/No
Then there are Disarm and Trip properties (Reach too, but it won't factor in anywhere else)
Weapons have a lot of details.
Ranged: Yes/No
Finessable: Yes/No (Only Yes if Yes AND have Weapon Finesse)
Thrown Ranged: Yes/No
Then there are Disarm and Trip properties (Reach too, but it won't factor in anywhere else)
Tell me about it, lol. Thankfully not all of those need to be worked in (reach, disarm, etc. can be noted in the notes box). I think I'll put a thing next to them where you can put in the stat it draws from, that way it'll cover things like the Guided and Agile properties, and anything else like that that may be released in the future.
Ok, I added a stat column for the weapons - it works just like skills, so switch str to dex or wis or whatever and it'll automatically go for it. The damage I've kept always based on strength for now - even though there are properties that change that too, they're not always the case and a whole column for the damage stat too seems excessive (and also it would mess with the layout >_> <_<).
Anyway, new version!
That's what I'm using.
Nice. That looks like it pretty much covers everything. I'm trying to keep it down to 4 sheets at max, just for ease of use, and keep everything on the viewable area of a given sheet at once, which has been the hardest bit for me...will hafta see if I can work some of the stuff from yours in though.
I had added some new things from what I was thinking in this thread (like making "Ranged" a "Yes/No" validity cell instead of being empty or not). So to be completely correct, it needs to be OR(ISBLANK($G39),$G39="No"). Actually, it would probably just be easier to tell the validity limiter to not allow blank cells.
Mine's 4, maybe 5, sheets if you toss out the spell recording pages. And if you toss those out, there is several other things you can toss out too.
One thing you probably definitely want to copy if you want to record stuff about spells is my automatic bonus spells logic. Man that was a nonsensical pain in the ass to get correct (I am reasonably sure it is correct). Unless you have one that is also correct and logically simpler, in which case I need it.
One thing you probably definitely want to copy if you want to record stuff about spells is my automatic bonus spells logic. Man that was a nonsensical pain in the ass to get correct (I am reasonably sure it is correct). Unless you have one that is also correct and logically simpler, in which case I need it.
For that kind of thing I've basically been using if/then formulae, but I'll see if I can figure out how to do it without having to use if/then for every 2 ability points...
One thing you probably definitely want to copy if you want to record stuff about spells is my automatic bonus spells logic. Man that was a nonsensical pain in the ass to get correct (I am reasonably sure it is correct). Unless you have one that is also correct and logically simpler, in which case I need it.For that kind of thing I've basically been using if/then formulae, but I'll see if I can figure out how to do it without having to use if/then for every 2 ability points...
Look at my formula then. There are if thens because you can't avoid them, but I use some completely nonsense math.
Ok, I figured one out - I don't know if it's logically simpler, but here it is:
=IF($D$17>(G46-1);INT(($D$17-G46)*0.25)+1;0)
where D17 is casting stat modifier and row 46 starting with G is spell level *G46 is 1, H46 is 2, and so on). So the above is for first level spells, second would be:
=IF($D$17>(H46-1);INT(($D$17-H46)*0.25)+1;0)
third is:
=IF($D$17>(I46-1);INT(($D$17-I46)*0.25)+1;0)
and so on.
That's effectively what mine does, but less complicated.
I modified it to this (to take advantage of following it in the function window easier):
=IF($X$31>SUM($T17,-1),SUM(QUOTIENT(SUM($X$31,PRODUCT(-1,$T17)),4),1),0)
Where $X$31 is the modifier for the relevant casting stat and $T17 is the spell level.
That's effectively what mine does, but less complicated.
I modified it to this (to take advantage of following it in the function window easier):
=IF($X$31>SUM($T17,-1),SUM(QUOTIENT(SUM($X$31,PRODUCT(-1,$T17)),4),1),0)Where $X$31 is the modifier for the relevant casting stat and $T17 is the spell level.
*nods* I'm messing around with it still and got it a little smaller:
=MAX(INT(($D$17-G$46)*0.25)+1;0)
Trying now to get it to figure out bonus spells and class-given spells together so it'd just display it all in one cell per spell level.
I'm beginning to think I can't make a formula for that since they don't follow a regular progression though... -_-
Max doesn't work. The If-Then and numerical calculation are different logic.
Class given spells don't factor into spells/day. Unless you mean the individual class spell lists. If you mean that, then it's beyond the scope of a character sheet.
Actually the max formula there is displaying the exact same results as the if/then one I put earlier when I'm messing with it (I have them one on top of the other on rows), so I'm not sure what you mean there...
When I said class given spells I coulda worded it better, lol. I mean the standard spells per day that you get just for being, say, a wizard, or a bard, or whatever, as opposed to the bonus spells for a high stat. I'm fairly sure I can do it for sorcs and oracles because they -do- have a simple progression, but the others don't so not sure how I could even make that work...
Actually the max formula there is displaying the exact same results as the if/then one I put earlier when I'm messing with it (I have them one on top of the other on rows), so I'm not sure what you mean there...
I tried it and didn't. What number did you try.
You are also going to have to take into account Int isn't the only casting stat. I have mine pull the modifier from the relevant stat by picking the casting stat in a drop-down.When I said class given spells I coulda worded it better, lol. I mean the standard spells per day that you get just for being, say, a wizard, or a bard, or whatever, as opposed to the bonus spells for a high stat. I'm fairly sure I can do it for sorcs and oracles because they -do- have a simple progression, but the others don't so not sure how I could even make that work...
Beyond the scope of a character sheet. The player should just put that in themselves based on their level.
I tried it and didn't. What number did you try.
You are also going to have to take into account Int isn't the only casting stat. I have mine pull the modifier from the relevant stat by picking the casting stat in a drop-down.
I tried a bunch of numbers, from 10 up through 150, including every number from 10-50, and it always came out the same. I uploaded it if you wanna take a look though - maybe it's a cell-referencing issue?
It's only drawing on int right now, yeah, but I can put a box in to pick casting stat (since these are sheets for each class I'd make it so it draws from the default one of course anyway, but I know some of them have archetypes that change it).
I tried a bunch of numbers, from 10 up through 150, including every number from 10-50, and it always came out the same. I uploaded it if you wanna take a look though - maybe it's a cell-referencing issue?I tried it and didn't. What number did you try.
You are also going to have to take into account Int isn't the only casting stat. I have mine pull the modifier from the relevant stat by picking the casting stat in a drop-down.
Ah, I see. You have to use the fractional product and can't use quotient.
I think I got it for sorcs and oracles! Ok, I uploaded the same one with the formulae for sorcs and oracles here. It's currently using int as the casting stat still (despite being for sorcs and oracles) because I want to make sure I've got the formulae working right before I go and mess with that.
Note that the spell per day boxes, bonus, base, and total, all operate independently of each other - they're all on the sheet right now, but the only one you need is total - it doesn't refer to the others at all.