Contents
--------
- Character Sheet: This is mostly the same as the Wiesenbad Sheet at
http://www.enworld.org/forum/showthread.php?t=229672. Changes include:
- Restructured Attacks page to make it easier to find the right bonuses for powers
- Added "Quick View" page to give a summary of stats, powers (auto-calculated), and combat tracking
- Power Database: This is a modification of sircedric4's database at
http://www.enworld.org/forum/showthread.php?t=229430
- Added fields to make the storage more comprehensive
- Added an import capability to allow easy sharing of the database
- Added the ability to put calculations into a power's description so the character
sheet can automatically generate the information
- Added lots of error checking to help protect against accidental data errors
- Added powers for a few characters to test it out.
Instructions
------------
- Installation:
- Put both files in the same directory. This should minimize the number of times Excel gets confused
and asks you where the data is.
- You can rename the character sheet, but if you rename the database the import function will break.
- Copy the Character Sheet to make a new PC.
- When you open the sheet, if it asks you to update values, double click on the Power Database file.
Sometimes Excel asks once, sometimes twice. Just double click the file both times. I'm sure there's
logic behind how many times it asks, but I can't figure it out.
- Depending on your security settings, you may need to click "Enable Macros" if prompted.
- Sheet:
- Fill in the sheet as normal. When you open the Quick View page it will automatically populate the fields
with the appropriate data. If any of your powers do not show up on the sheet, it means they are not in
the database.
- Database:
- Use the Add a Power button to open a form for entering new powers.
- Select your source (race, class, paragon path, etc.) from the drop down list. If the source doesn't exist
use the New button beside it to add it. Depending on your version of Excel you may need to close the form and
reopen it to see the new source (this is the same for all fields with a "New" option).
- Select the power type: At Will, Daily, Encounter, Etc. Utility powers are entered based on how often
they can be used.
- Select level, action type, attack type, and range from the drop down lists.
- Enter the area as the number of squares, or leave it blank.
- Select the target(s), attribute, and defense it goes against. If one of them doesn't exist, use the New buttons.
- Check the Implement box if the power uses an implement.
- Enter a short description of the power. If it includes a reference to a stat, use the drop down list to select it.
- If the stat you need doesn't exist, use the New button to create it. To find the right cells to reference,
check the sheet and find the right name. All named cells are listed in the drop down list on the formula bar
(Tools > Options > Show Formula Bar).
- If the effect requires a full calculation, use the Add Calc button.
- Select "Add Power" to add the power to the database.
- Add Calc
- Use the drop down boxes and add buttons to create the calculation.
- If division is involved, select whether to round up or down (down is the default)
- Variations of [W] are in the top drop down box. These will be converted to the appropriate damage
on the sheet.
- Press Ok to close the form and add the calculation to the effect.
- Tip: Anything between the {{ and }} will be turned into a calculation in the sheet. Any Excel functions can
be used.
- Tip: Don't forget to include your implement if the power uses it. For example, Divine Glow's damage bonus
should be Wisdom + Implement Bonus, not just Wisdom.
- Import new data
- Click the Import button
- Navigate to the database with the new data.
- Double click it or select Open.
- The data will be brought in automatically. Duplicate powers will not be imported.
- Don't forget to share!
Any comments, questions, requests, or bug reports please let me know:
Threads: Enworld,
http://www.enworld.org/forum/showthread.php?t=236663
RPG.net,
http://forum.rpg.net/showthread.php?t=405657
therpgsite,
http://www.therpgsite.com/showthread.php?t=11248
Email:
james.t.mcmurray@gmail.com (posting in a thread is preferred, if it's an option for you)
Enjoy!
James McMurray