Here's my extensive WFRP 4e Google Sheets character sheet!
docs.google.com/spreadsheets/d/11kVdeKdQCq99B...
docs.google.comPosted Aug 15, 2018, 12:13 AM UTC
2825
docs.google.comFantastic! Not that familiar with Google Docs; is the best way for me to use it to "File->Make a copy" and place the copy in my own Drive?
Also, if you make revisions to yours, how do I migrate my data to the new version?
3
You'll want to go to File > Add to my Drive, that way it saves a link to the master version in your Drive and is easily accessible (and then you always copy the most recent version). Then you make a copy for any new character, yes.
To migrate to a new version (in the near future you'll probably only want to do this when the rulebook is finalised and released) you'll just have to make a new copy and input everything.
2
Nice! Trying to figure out how to save it and export some of the functionality to excel!
3
Unfortunately, since I used custom functions, that won't be easy. AFAIK, you would have to copy over the Google Sheets script (which is JavaScript) and convert it to Visual Basic for Excel.
You could just use the sheet without the custom functions (if you like the layout, for example), but you'd have to do some editing to remove all of the custom functions (I think the cells with them will show up as "###" in Excel).
Edit: Then again, I don't have Office 365 (and that apparently has JavaScript functions?), so if you download it as an .xlsx and everything works, then let me know!
2
Yeah they don’t copy across directly. Getting a lot of NAME? Might be easier just to use google sheets!
2
Ok, it's working out so much better in Sheets, but I can't figure out why Art, Entertain, Melee, Ride, and Stealth are blocked under "advances" on the Skills/Talents tab.
2
That's because those are grouped skills, so when you advance them you need to advance a Specialisation (for Melee, things like Basic or Polearm) -- you'd be putting those under Grouped & Advanced Skills to the right. It talks about them on pg118 in the pre-release PDF.
2
Oh dear. Thanks!
2
Ok, minor minor correction to Encumbrance calculation.
On the "Tables" tab, , S17:S24, the last expression that says Gear!S12 through Gear!S19, I think the S needs to be changed to Q.
2
No, it's right. Gear!S12-S19 is for the total Enc that the container is carrying (ie the # / # under Carrying, which is totalled from things that have that Container selected).
2
huh. i wonder why my numbers are appearing weird
2
Weird as in too high? Too low? Keep in mind things that are worn have their Enc reduced by 1.
2
Too high by one I think
2
And when I uncheck "worn" for backpack or put the axe in the backpack, enc goes UP one instead of down
2
[removed]
1
Are you still working on this? I've got a couple of fields that refuse to load no matter how many times I reload the page.
1
I am. What isn't loading?
1
WS. I did some more digging, and it appears that there's an issue in the Mutations area. In order to get the issue to go away, I had to set and delete a mutation. K52 and L52 appear to be erroring, but I can't tell if it's by design, tbh. All of the other errors I'm seeing seem to be related to the fact that WS (and therefore WSB) isn't calculating.
1
It's not by design, for some reason the mutations list wanted to be stuck in a cycle or never loading (and as you found, that would mess with WS and all the associated cells). This is now fixed on the base sheet.
To fix your own mutations list just delete the lists on the Tables page in the ranges K52:K70 and L52:L71, then reenter the formulae in the first cell for each ("=getPhysicalMutations()" in K52 and "=getMentalMutations()" in L52).
1
Thank you!
1
Holy crap this is awesome. I'm at work, and on mobile, but from first glance this blows my interactive PDF out of the water lol.
Thanks a bunch!
Thanks! An interactive PDF is nice for printability, but when you're like me and will probably be playing solely online / at a computer, having much more space and functionality is great.
I've had a lot of practice with a D&D 3.5e sheet I've crafted over the years, so I was already probably going to make this for myself and my friends. Might as well share it since WFRP 4e is so new!
Indeed. I hadn't tried my hand at anything quite like this before. But I got frustrated trying to edit the PDF to make an easy character sheet so I made it interactive.
I will be playing online as well mostly, so your tool will be incredibly more useful.
Glad to hear it!