Excel Character Sheet

[samwise7]

I was messing around with the new Excel Character Sheet, and I noticed that it didn't auto calculate the stat bonuses in the skill.  Am I doing something wrong?  I made sure to pick my race and class at the top, and that filled in the stat bonuses and such, and after I put in the stats the bonuses were there.  They just didn't fill in below in the skills section.

It shouldn't be too hard to modify it to do that though.

[imported_Rasyr]

The sheet's description says

This is a rudimentary Excel character sheet for Novus I'd like to share. It has almost no formulas at the moment, but feel free to add them along with macros and to post this sheet back on the forum so that we may build a common auto-calculating character sheet.

That would seem to say it all...

[samwise7]

Gotcha.

[Fidoric]

Yes. At the moment, it calculates almost nothing. It's more a blank form to fill in. I am considering making a first page to enter datas and make choices (stats, races, backgrounds...) and to have it fill the CS. Something like the most famous J. Dale spreadsheet for other games.
Best regards.

[samwise7]

Thanks for making the sheet.  It's cool that it fills in the racial bonuses and it looks good.

[Fidoric]

It should make much more within 15 days. If there are some Excel specialists around, maybe they could make it a more functional thing. I usually use formulas but I am no good with macros.

[imported_Rasyr]

Helpful little tidbits.....

DEF

The cell where the  level number goes should be named "lvl"
Then the formula in the cell O12, which autocalcs the base DEF should be changed from

Code:

=IF(spd>=0,15+spd,15)

To

Code:

=IF(spd>=0,15+spd+ROUNDDOWN(lvl/2,0),15+ROUNDDOWN(lvl/2,0))

This will have the Base DEF include the level modifier into that calculation in the manner in which the rules current say to do it.


Skills - Stat Bonuses

For the skills if you put the following formula into the Stat Bonus column for the skill, it will automatically pull the stat bonus from the stats section

Code:

=INDIRECT(LOWER(H53),TRUE)

Lower -- This transforms the text from a given cell to all lowercase (i.e. changes "Dex" to "dex").
Indirect -- This basically takes the text that it is fed and  tries to look to see if there a cell with the same name, and thus pull the data from
H53 -- this is simply the location of the cell that holds the Stat name for a give skill (i.e. H53 is the stat name for Acrobatics, H54 is the stat name for Athletics, etc) The best way is to put the formula in the first cell, then just copy/paste it into the rest of the column (the M column, since that is where the stat bonus goes.

[Fidoric]

Thanks for your help. I will look into all this stuff next WE. I think the nicest part will be to enter datas and to arrange them to properly give the right bonus and talents from races, ranks from BG... I am almost sure to be able to do all this, not necessarily in the smartest way, but a working spreadsheet nonetheless.

[Fidoric]

One minor difficulty, formulas in Excel do not use the same words in English and French... Only a minor nuisance though, trying to upgrade the spreadsheet this WE.

[Fidoric]

Hi guys,
I have made some (few) progresses in my rare spare time. I have put it on Google Docs so that anybody can access and edit it. Don't hesitate to do it directly if you see things to better.

https://spreadsheets.google.com/ccc?key=0Ak5vxd_8okjvdFZhNFdYWDB1cnYzaWtVbThkWkU0Ymc&hl=en&authkey=CIby2bAC

I expect to be spending the next week in French Antillas, in holidays with my beloved family at last !
Best regards,
Fidoric

[gamewizard]

I expect to be spending the next week in French Antillas, in holidays with my beloved family at last !

Man, that sucks. Any time you need a little help with that, let me know. I am always willing to make a sacrifice to go to some tropical isle.

 Seriously, be safe and have fun, Fidoric!

[Fidoric]

Thanks for your kind offer gamewizard. But I think we will do it all by ourselves ! 

[Fidoric]

I have updated the spreadsheet.
Now it allows to choose race, background, profession and armor. I am wondering if it should be better to suppress the "data sheet" currently used to enter character's choices and to enter the datas directly on the character sheet. Any idea ?

The current link is : https://docs.google.com/leaf?id=0B05vxd_8okjvZGYxMWFhNWMtNDRiOC00ZTA4LWIwOTAtOGYyZjlmYmM2ZDNm&hl=en&authkey=CKWa1O4O

BTW, is this link satisfying or would it be better to upload the document in the downloads section ?

Fidoric

[Fidoric]

You can find below a link to the latest version of my Excel Character sheet for Novus.
It's all on one page now and does many things. You still have to choose your talents, combat moves, spells and weapons and to implement your stats. Also, you have to put any bonus from chosen talents manually.

https://docs.google.com/leaf?id=0B05vxd_8okjvOGM2Yzg2ZDEtNDliZi00N2JhLWEwYTItMmE2YTcyMGYwNWQy&hl=en_US&authkey=CJv8rbEN

[imported_Rasyr]

Umm.. that link goes to that spell base doc you sent me, not to the excel character sheet.