Another great rev of this excellent character sheet! Let me say again how much I appreciate your efforts. I note that most of displayed "+" signs have been accomplished through the use of the "+#0;-#" custom cell formatting. This goes a long way to making the sheet compatible with OOC!
When I first opened the 1.16b sheet up, none of the drop downs on the 'Powers' sheet worked correctly. This was caused by some blank entries in a table on the 'At Will' sheet. (My suggested fix below, item 1.)
There was also one place where the "+#0;-#" was not used that caused a problem. (Suggested fix item 2 below.)
Code:
1) $'At Will'.C2:C4 ==> Set to zero instead of blank.
2) $'ExportSheet'.O36:O41
OLD template: =IF(VLOOKUP(Dexterity;A2:B51;2;FALSE())>0;"+"&VLOOKUP(Dexterity;A2:B51;2;FALSE());VLOOKUP(Dexterity;A2:B51;2;FALSE()))
NEW template: =IF(VLOOKUP(Dexterity;A2:B51;2;FALSE())>0;VLOOKUP(Dexterity;A2:B51;2;FALSE());VLOOKUP(Dexterity;A2:B51;2;FALSE()))
Change Cell Format to: +#0;-#
It appears that the pro sheet does not reflect the damage bonus for magical weapons. (Example: Cell $'Attacks'.E56 reflects the damage bonus from cell $'Attacks'.E10, but cell $'Pro Sheet'.BG38 does not reflect the damage plus from $'Attacks'.E10. Maybe this is your intent (?), to allow different weapons to be easily used with the Pro Sheet, but the Enhc box in the DEX block ($'Pro Sheet'.BH18) does reflect weapon enhancement. Otherwise, I think this is a logic error unrelated to OOC, but I do not have Excel, so I cannot confirm. If so, I believe the value needs to come from looking up based on the chosen attack bonus selection. It might help to have this value as an intermediate calculation to easily support the check for non-zero before displaying it on the Pro Sheet. Perhaps cell $'Attacks'.E69 could have code like...
=HLOOKUP(E31;$E$5:$M$10;6;FALSE()) The resulting value could then be used in $'Pro Sheet'.BG38 to check non-zero to determine if it needs to be displayed?
Thanks!
And yet another word from our sponsors
