Experience Awards.xls
ver 1.0
Jim Morris
11/27/2003



Instructions:

Party Members
These entries can be setup in the first encounter and copied over from encounter to encounter, chaning particpation level as needed for individual characters. Ensure that you enter their levels, as it is possible to enter a name, and set particpant equal to "yes", thus counting them for Xp division, but they will not receive an award until their level is entered.


Enemy Groups
Each row should represent a single type of monster, enemy, etc.. Use the Qty column to indicate more than one of that type. The CR entered should reflect the CR listed for one of that type. Besure to select normal from the Circumstance drop down if no difficulty modifier is needed. Xp will not calculate until one of the values from that list is selected.


Making New Encounters
Simply copy the worksheet to make a new encounter. Note that the name of the worksheet has been selected so that Excel will increment the next encounter number to one higher than the sheet selected. A shortcut to copying the worksheet can be used by holding down the [Ctrl] key while dragging the sheet either right or left from its current position. Right-clicking and selecting "Move or copy..." will result in the same effect but with more steps.




Hidden Areas:


Total Columns
Scroll to the right until you see the gap in column names. Highlight both columns on either side of the gap and select Column.Unhide from the Format menu. The revealed columns represent a transposed and formatted version of the calculation required to generate the final award numbers. You should not need to change these unless you wish to alter the formulas used.


Core Rule Tables
There are two hidden sheets that contain the data taken from the DnD DMG ver 3.5. Worksheet "3-3" contains the Level to CR award matric from page 36 of the DMG. Worksheet "Circumstance" contains the table for situational multipliers from page 39 of the DMG. 

You should not need to modify these sheets unless the rules change.



Rules:

The overall implementation of the DnD 3.5 experience award rules takes into account two main factors.

One - Xp is calculated for individual characters separately

Two - Not all party members may participate in every encounter



Note - Table 3-1: "Encounter Numbers" is not used in this calculator. Since I viewed this mainly a tool for designing encounter number relative to party level and number. Also, the step by step process listed on page 37 seemed to conflict with this table, "2. For each monster defeated, determine that single monster's challenge rating." I would like to eventually integrate a system for rating the overall encounter CR based on average party level and numbers, but for now this was the only apparent right answer. I would welcome input on this issue for future versions.
