BAB and base saves not being pulled into formulas
Pathfinder Character Creation Project
Brought to you by:
thebluecanary
Menu
▾
▴
#609 BAB and base saves not being pulled into formulas
No forumals are pulling the BAB, Base Save, or other level specific numbers. Boxes populated with BAB and Base Save are throwing the "#N/A" causing every calculation related to the 2 prior mentioned numbers to not calculate (attack bonus, CMD, CMB, all saves etc.).
Discussion
Anonymous
View and moderate all "tooltickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Need to point out that this happens when importing a character from 7.1
View and moderate all "tooltickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Repeated this by exporting a PC from 7.2 into 7.4. Same issue but also seeing weapons damage throwing an #N/A
Check all your selections. Go to CP tab, and look for anything in the Q column that says #N/A or #REF!. The look at your selections in that error. What has happened, is one of your selections has changed/move when new content was added. (I'll take a guess and say it was Magic Items). Look over all the release information on the Splash Page. Any of the indicated tabs MIGHT cause an issue with a load. 99% of all import/load issues are from selection shifting.
View and moderate all "tooltickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Yeah I understand that. I always go through and fix the selections that have shifted. However, that doesn't explain why there is no value for BASE ATTACK BONUS, BASE SAVE, CMD and CMB, as these are only related to CLASS and LEVEL (ability modifier is being pulled in correctly). Correcting my selections does not fix the problem. There must be an error in the formula for BAB, base save, etc. I just confirmed again by importing again, the selections are correct. However, still no BAB, base save, and thus no CMD, CMB etc as described above.
View and moderate all "tooltickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
I'm still trying to figure this out, though I don't know much about Excel. The problem appears to stem from this formula in Character Sheet I
=IF(RaceIndex=1,"",BAB)
The box with this formula is throwing the #N/A causing everything dependent on BAB or Base Save to not pull a value.
The problem is level and/or race.
Do you have a race selected? Have you tried just entering in everything by hand? Can you upload a copy of your file to me? RaceIndex is set on the Race Tab.
View and moderate all "tooltickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Resetting level sheet and weapon sheet did not fix either.
View and moderate all "tooltickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
that is the sheet. I imported a half orc and didn't have a problem. But then imported a gnoll, had an error. I've tried changing races, clean copies, importing other versions etc.
Yes I have had a race selected. That never changed.
Last edit: Anonymous 2014-08-12
Head over to the Customization tab. Scroll down to C99. Delete the value there. That should fix you right up.
View and moderate all "tooltickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Thank you. Any clue how it happened? Is it an import problem? I don't mess around in that tab.