Current Version 3.3 - 8/10/08
Can be found here (http://www.colugo.org/jmcmurra/CharacterSheet_3_3.zip).
Changes
- Fixed attack bonuses and damages
- Fixed ranges
- Fixed Attacks sheet to allow all the slots to be used as favorites
- Rearranged ongoing damage section to increase readability
- On the quick view sheet, hid weapons that you don't have
- Fixed wizard proficiencies
Wiesbaden http://www.enworld.org/forum/showthread.php?t=229672
sircedric4 http://www.enworld.org/forum/showthread.php?t=229430
A great character sheet and database, combined into an auto-calculating powers extravaganza!
This is an update to the excellent Wiesenbad sheet. It adds power text and auto-calculation for a quick view / combat tracker sheet. [W] is calculated for primary, ranged, and off hand weapons. To hits and damage for powers is also figured up, as is anything tied to a stat.
Unlike prior versions, this is a single file.
Please let me know if you find any bugs.
Todo:
- Auto-figure changes based on class choices, such as Tactical vs. Inspiring Warlords. Currently the added benefits are listed at the end of the power's text.
- Properly handle powers from feats and the half-elf racial ability. They are currently listed as they would be for the appropriate class.
The link to the zip file is broken from over here.
Quote from: James McMurray;226700At 345kb it's just a little too big to put on EnWorld, so I've uploaded it to here (http://www.colugo.org/jmcmurra/Power%20Database.zip).
Sounds good but I get:
The requested URL /jmcmurra/Power Database.zip was not found on this server.
This link (http://www.colugo.org/jmcmurra/Power%20Database.xls) takes me to the excel file.
Repeated: http://www.colugo.org/jmcmurra/Power%20Database.xls
Sorry about that. The link should have pointed to the excel file dar found. It's fixed now.
One thing I forgot to mention is that the sheet will also recognize "level" and "1/2 level" in the effect, for things that depend on that (like the wizard power Resistance for instance).
I updated the opening post with version 1.0 of the database and sheet. Included are the sheet, database, and a readme (quoted here).
QuoteContents
--------
- 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 (james.t.mcmurray@gmail.com) (posting in a thread is preferred, if it's an option for you)
Enjoy!
James McMurray
Hawke at RPG.net pointed me to this thread at RPGtools.net (http://forums.rptools.net/viewtopic.php?t=4476). It has a database with the text already in it. My next project is converting that information into this database's format, so we don't have to enter anything. :D
I've got everything but the text of the powers converted from their format to mine, and will hopefully have powers done by Monday.
Their DB even had some homebrew stuff for a druid and wizard class, as well as stuff from Dragon magazine. Unfortunately, without a major overhaul tot he character sheet's front end, those will be kinda hard to use.
Current Version 2.0 - 8/04/08
Can be found here (http://www.colugo.org/jmcmurra/AutofillingSheet.zip)
Wiesbaden http://www.enworld.org/forum/showthread.php?t=229672
sircedric4 http://www.enworld.org/forum/showthread.php?t=229430
A great character sheet and database, combined into an auto-calculating powers extravaganza!
This is an update to the excellet Wiesenbad sheet. It adds power text and auto-calculation for a quick view / combat tracker sheet. [W] is calculated for primary, ranged, and off hand weapons. To hits and damage for powers is also figured up, as is anything tied to a stat.
Unlike prior versions, this is a single file. I'll be putting up a database version, but as this one includes almost all of the currently released material, I figured a quick drop of a smaller file would be welcome.
Please let me know if you find any bugs.
Todo:
- Auto-figure changes based on class choices, such as Tactical vs. Inspiring Warlords. Currently the added benefits are listed at the end of the power's text.
- Properly handle powers from feats and the half-elf racial ability. They are currently listed as they would be for the appropriate class.
Fixed:
- Blinding Barrage attack bonus
- Class features showing up as #N/A on CharSheet II
- Added Genasi as a race. The backend for the races is kinda funky right now, so their encounter power doesn't show up properly. But the team that does the sheet portion has promised a release soon that has better support for adding new races.
Uploaded here. (http://www.colugo.org/jmcmurra/AutofillingSheet.zip)
Last update for a while. I pulled all of the macros out of it, so the Quick View page should now work with Macs and Open Office, as well as those running Excel at higher security levels.
I don't own a Mac, and haven't had a chance to test with Open Office yet, so please let me know if you find any bugs.
I do have mac, and after a quick look it seems to be working fine. I'll try to spend some time with it over the next couple of days and give you a more comprehensive review.
Thanks!
Current Version 3.1 - 8/07/08
Can be found here (http://www.colugo.org/jmcmurra/MacrolessSheet_3_1.zip).
The version with macros is still here (http://www.colugo.org/jmcmurra/AutofillingSheet.zip).
Changes
- Auto-figures powers according to class choices (i.e. Tactical vs. Inspiring Warlords).
- Auto-figures power changes from paragon paths.
- Adds extra damage from feats like Astral Fire.
- Adds feat text to powers, such as "Push 1" for a tiefling's hellish rebuke if they have the feat.
- Moved Second Wind to the encounter powers section and gave it's full description, action type based on race (for dwarves), and extra effects for 16th level Blood Mages.
- Added Genasi to the races and powers
- Changed the magic items section of the quick view page to Text format so it doesn't complain if you try to start a line with a + sign.
- Fixed a bug where multiclass powers were not showing up.
- Lots of minor typo changes.
- Now handles the half-elf Dilettante ability properly
I'm confused about how to enter my weapon choices.
On the attacks tab there's a drop down under each label. Select the type of weapon in it. In the box under that you can give the weapon a name if you want. Add a magic item bonus (if any) and select the attribute used. This should fill out the Base Attack Bonus for that weapon, and also calculate the damage for a basic attack if you're adding a melee, ranged, or off-hand weapon.
The slots for Implement, Melee, Ranged, and Off Hand will all be used to calculate the bonuses for powers. Weapon 5 is for if you've got anything else you want to have show up on the sheet, but don't use frequently, like a backup weapon.
If you don't use one of the options, like fighters who ignore Implements, you can leave that column blank. Anything you put in Power 1, 2, or 3 will show up on the front page of the character sheet.
Does that help? I can see about uploading a screenshot if it'll be useful.
I think that'll do it, actually. Thanks!
There was some trouble with the old version being cached by some browsers because I didn't change the file name. The link above should now get the most recent version, or it can be found here (http://www.colugo.org/jmcmurra/MacrolessSheet_3_1.zip).
Current Version 3.2 - 8/10/08
Can be found here (http://www.colugo.org/jmcmurra/CharacterSheet_3_2.zip).
Changes
- Fixed attack bonuses and damages
- Fixed ranges
- Fixed Attacks sheet to allow all the slots to be used as favorites
- Rearranged ongoing damage section to increase readability
- On the quick view sheet, hid weapons that you don't have
- Fixed wizard proficiencies
Looks nice. As soon as I get a chance to read the rules I'll play around with it.
--------------
Overall
--------------
This is the most comprehensive character creation tool I've encountered for 4th edition. You've managed to consider and package everything that might concern a player. Congratulations on a great project. This is leaps and bounds beyond the next best option.
--------------
Criticism
--------------
I must also say, though, that this sheet is extremely complicated to update. Perhaps I need more familiarity with its inner workings, but I found the use of intra-sheet tables for selection list population frustrating and redundant. The data groups for selection lists are a loosely organized mess hidden in a string of columns that have been smushed together on the relevant pages. Some of these lists are redundant and could be fashioned using references to information in the hidden sheets. Would this impact the speed of the spreadsheet to a fault?
My criticisms aren't entirely valid due the nature of this project. The spreadsheet isn't intended for people to snoop around in. This is an end product and isn't really made for "hacking" by do-it-yourselfers. My comments here are geared more toward the development side. I don't know if this is an open project or not, but if it is then it begs some serious clean-up. Streamlining will reduce future time spent on updates and might even make the spreadsheet more internally efficient.
edit: I was using ver 3.4
--------------
Final Note
--------------
Thanks for a great project. You managed to produce an all-encompassing character creation tool and that really is a feat all its own. I look forward to your future work and will gladly recommend this around the net.
Glad you like it, and I agree completely on the troublesome nature of the data storage. I inherited that from a previous sheet (the Wiesbaden sheet in the first post). That team has gone on to make a more customizable version of the spreadsheet, though it doesn't have the power database in it.
Given the nature of the Character Database from WotC, and the speed at which they release material that would have to be updated, all of my development on this sheet has ceased.