Hi, I have started a spreadsheet to use for personal use for an RPG game I play (D&D).
I'm not very formula savvy and I'm stuck trying to get the last bit of functionality to work.
Is there anyone willing to take a look at my sheet and figure this out for me? I have colored the text red for each box that I need help on.
1. [% XP] box - If H7 is set to % other than 100%, decreases/increases F7 accordingly. Do the same for cells F9-F25.
2. [Encounter Level] box - K29 should calculate the appropriate level based on the Encounter Numbers chart in AE25 which is determined by whatever CR a user enters in cells M7-M25
3. [% of this EL to use] box - K31 should display the correct percentage based on the Encounter Difficulty chart in T17 which is determined by comparing the Effective Party Level in D29 to the Rules in Z17-Z25.
4. [Difficulty] box - Q29 should display the appropriate text from U17-U25 based on the % displayed in K31. This is determined by comparing the Effective Party Level in D29 to the Rules in Z17-Z25.
5. [Advice to Party] box - Q31 should work exactly like rule #4 except it is referencing cells W17-W25.
http://www.rpglocker.com/DnD/Experience_Calculator.xlsx
EDIT:
I realized that I forgot to include the link to an online calculator that this sheet is based off of. I don't see an edit button to edit my original post, so here is a reply with the link:
http://www.d20srd.org/extras/d20encountercalculator/
I'm not very formula savvy and I'm stuck trying to get the last bit of functionality to work.
Is there anyone willing to take a look at my sheet and figure this out for me? I have colored the text red for each box that I need help on.
1. [% XP] box - If H7 is set to % other than 100%, decreases/increases F7 accordingly. Do the same for cells F9-F25.
2. [Encounter Level] box - K29 should calculate the appropriate level based on the Encounter Numbers chart in AE25 which is determined by whatever CR a user enters in cells M7-M25
3. [% of this EL to use] box - K31 should display the correct percentage based on the Encounter Difficulty chart in T17 which is determined by comparing the Effective Party Level in D29 to the Rules in Z17-Z25.
4. [Difficulty] box - Q29 should display the appropriate text from U17-U25 based on the % displayed in K31. This is determined by comparing the Effective Party Level in D29 to the Rules in Z17-Z25.
5. [Advice to Party] box - Q31 should work exactly like rule #4 except it is referencing cells W17-W25.
http://www.rpglocker.com/DnD/Experience_Calculator.xlsx
EDIT:
I realized that I forgot to include the link to an online calculator that this sheet is based off of. I don't see an edit button to edit my original post, so here is a reply with the link:
http://www.d20srd.org/extras/d20encountercalculator/
Last edited by a moderator:
