Instructions for adding content to the 4e character sheet
=========================================================

General:
The workbook is protected.  In order to see the sheets that are referred on these instructions, unprotect the workbook (menu Tools->Protection on Excel 2003)
The place to post requests for programming is the forum located at http://www.dnd4.com

Source books:
Before adding content, check if the book is on the available book list.  The list is on the sheet Lists, starting on range E2.  The formula on column F checks the status of the selections on the Filters page.  
If your book is there, use that code on the book column for all the content that you enter.  If not, you can add it there following these steps:
- Unprotect the filters sheet, copy the last entry on the source section, and insert the copied cells as a new row.  This way the format will be preserved
- On the list sheet, enter a unique code for your book in the first available row on column E, and copy and paste the formula on column F.  Check that the cell reference on column F corresponds to the new row on sources that you have just entered
- Redefine the name Filtered Books to include the new row

Races:
Follow these steps to insert a new race:
- Insert a new row above the row with ZZZ End of Races on column A
- Enter the name of the race on column A, the source book code on column C, and copy the formulas on column B and D from the row above
- On columns E to AF, enter the corresponding information to the race.  Leave blanks when the field is not applicable.  The only fields that should always have a value are speed and vision
- On columns AG to AL, enter the race features.  You can split one feature description on two or more cells to make it look better on the character sheet.  The current limit of features is 6, if you need more post in the forum as it will require extra coding in more places

Classes:
Follow these steps to insert a new class:
- Insert a new row above the row with ZZZ End of Classes on column A
- Enter the name of the class on column A, the source book code on column B, and copy the formulas on column C and D from the row above
- On columns E to N, enter the corresponding information to the class. The column H is a calculated field, so copy the formula from the row above
- On columns O to Z, enter the weapon and armor proficiencies, using 1 to mark the proficiency and blank otherwise.  If the class has an specific proficiency not listed there, post it on the forum as it will require extra coding
- On column AA to AQ, enter the skills available.  For trained skills, use an "X", for available skills, use "-".
- On column AR to AU, enter the choices available for the class.  Almost all the choices will require some extra coding to make them functional, so post it on the forum.  If you need to enter more than 4 available choices, post it too.
- On column AV to BB, enter the features.  Same as with the races, you can split the description on two or more cells.  There are 7 class features spaces available, if you need more post on the forum.

Feats:
Follow these steps to insert a new feat:
- Locate the empty spaces between the list of feats and the weapon proficiency feats, and insert a row below the last feat
- Enter the name of the feat on column F, the description on column G, the source book code on column H, and copy the formulas on columns C and I from the row above
- On columns J to P, enter the requirements on terms of abilities or level, if any.  If you enter at least one requirement, copy the formula on column Q from any feat that has it; if not, leave it blank
- On columns R to T, enter the requirements on terms of race and class.  You can enter two races, and the feat will be available for each of them.  If you enter at least one requirement, copy the formula on column U from any feat that has it; if not, leave it blank
- Column W can contain a custom formula, that has to evaluate to TRUE or FALSE.  Column V is that formula in text format, it has no effect but it can facilitate the reading.  If you are unsure on how to make the custom formula for the feat, leave it blank and post in the forum.
- Copy the formula for column X from the row above

Paragon paths:
Follow these steps to insert a new paragon path:
- Insert a new row above the row with ZZZ End on column D
- Enter the name of the paragon path on column D, the source book code on column E, and copy the formulas on columns A and F from the row above
- On columns G to L, enter the conditions for the paragon path.  If it is a class, enter it on column G and copy the formula from column H.  If it is a race, enter it on column I and copy the formula from column J.  If it is a custom formula, enter it on column L and copy the text of the formula on column K for clarity.
- On columns M to R, enter the paragon powers and the paragon features
- Column S is used for the options that some paragon paths have, and it will normally require custom code to be effective.  If you need to use it, post it on the forum.

At will powers:
Follow these steps to insert a new at will power:
- Insert a new row above the row with ZZZ End on column C
- Enter the name of the at will power on column C, the source book code on column D, and copy the formulas on column B from the row above
- On columns E to L, enter the characteristics on the power.  The class and level are mandatory.  Copy the formula on columns M and S from the row above.
- If you are entering wizard powers, copy also the formulas on column P

Encounter, Utility and Daily powers:
Follow these steps to insert a new power on any of those sheets:
- Insert a new row above the row with ZZZ End on column C
- Enter the name of the power on column C, the source book code on column D, class on column E, level on column F, and copy the formulas on columns B, G and I from the row above
- For daily and utility powers, if you are entering wizard powers, copy the formulas on column K
