Problem with DM Buddy

[maxxrox]

DM Buddy is a great program, but I'm having a problem with the combat tracker. Cells S36, U36, and W36 (the output cells for the third player's saves) has some kind of error and will not desplay any numbers, instead showing "####". The codes are "=Work!AU5+K36+R36", "=Work!AV5+I36+T36", and "=Work!AW5+O36+V36", respectively. Excel tells me that there is an #VALUE! error on all three.
You can find the program here:
http://www.enworld.org/downloads/fileinfo.php?id=191&jump=48#cmnt48

 

[Rodrigo Istalindir]

The #Value error usually means you have a non-numeric value in one of the fields you're trying to do a calculation on.

 

[maxxrox]

I understand that, and I noticed if any of the characters don't have any levels, it does the same thing to their save cells. I think that is because there is some kind of database I can't access that has each class' base saves at each level. Therefore I can only reason that there is a problem with the slot in H23's database.

I still don't know how to fix the problem. Someone please help!

 

[maxxrox]

Also, I redownloaded DM Buddy and had the same problem. So it has to be something in the code, not something I did.

 

[Gorok]

I understand that, and I noticed if any of the characters don't have any levels, it does the same thing to their save cells. I think that is because there is some kind of database I can't access that has each class' base saves at each level. Therefore I can only reason that there is a problem with the slot in H23's database.

I still don't know how to fix the problem. Someone please help!

The problem is that that particular character has levels of a prestige class. The spreadsheet is not able to locate the save data for that prestige class (arcane archer, in this case). If I remove the levels of arcane archer, the cells calculate just fine. If I select any level of prestige class, the cell does not calculate properly. Where the data is located for prestige classes is not obvious to me.

 

[maxxrox]

I actually changed the prestige class slot to "none" before I posted but forgot to mention it. I posted this question on another site and someone there found the solution.

It turns out I was right. The problem is in the database, specifically a hidden sheet named "Work". Cells AO43, AP43, and AQ43 in that worksheet all contain references to cell AO56. If you change those references to AO57, the program works fine.