Forensicator
2009-11-05, 12:02 PM
So, I'm working on a project involving digitizing all of the DnD checks and information system. I've uploaded a portion of the monster manual to excel, and there's a bit of entry to be placed for the party in my file. However, I currently have a pretty cool DM screen on excel which shows at a glance what has taken damage where, how much damage that is proportional to maximum HP, and tracks most buffs and group damage.
I have, however, hit a snag and was wondering if anybody could help me.
On one page of my DM screen, I have a table for entering saves against WIL, FORT, and REF. 4th ed rules apply. The idea works like this:
For a set of saves, you can either enter a DC arbitrarily or calculate a caster DC by putting the caster's name into a slot. Afterward, you put the name of whoever or whatever is making a save into a cell, as well as their dice roll. Excel should, hypothetically, be able to determine what type of save is necessary (via the IF function), look it up on the character's status (via the VLOOKUP function), and add it to their roll (via the SUM function) to determine whether they pass or fail the save (via another IF function).
However, in order to do this, because the name of who makes the save change, I have to make the entry and input all in the table format, and when I do so, the function that I use comes back as "#NAME." I have made many relatively similar formulas, and I know what "#NAME" means, but I have no idea how to fix this bug.
Has anybody else made a DM screen in excel that could help me out with saving rolls? Much thanks in advance.
-Forensicator
I have, however, hit a snag and was wondering if anybody could help me.
On one page of my DM screen, I have a table for entering saves against WIL, FORT, and REF. 4th ed rules apply. The idea works like this:
For a set of saves, you can either enter a DC arbitrarily or calculate a caster DC by putting the caster's name into a slot. Afterward, you put the name of whoever or whatever is making a save into a cell, as well as their dice roll. Excel should, hypothetically, be able to determine what type of save is necessary (via the IF function), look it up on the character's status (via the VLOOKUP function), and add it to their roll (via the SUM function) to determine whether they pass or fail the save (via another IF function).
However, in order to do this, because the name of who makes the save change, I have to make the entry and input all in the table format, and when I do so, the function that I use comes back as "#NAME." I have made many relatively similar formulas, and I know what "#NAME" means, but I have no idea how to fix this bug.
Has anybody else made a DM screen in excel that could help me out with saving rolls? Much thanks in advance.
-Forensicator