Page 1 of 2

4E: Macroless sheet with autocalculating combat tracker

Posted: Mon Aug 04, 2008 2:58 pm
by James McMurray
Current Version 3.2 - 8/10/08

Can be found here.

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.

Please let me know if you find any bugs.

Posted: Mon Aug 04, 2008 3:47 pm
by Full Bleed
This a 4e thing?

Posted: Mon Aug 04, 2008 4:11 pm
by James McMurray
Yeah, sorry about that. Subject line edited.

Posted: Mon Aug 04, 2008 5:27 pm
by UntoldGlory
Cool, I'll check it out soon!

Posted: Mon Aug 04, 2008 10:38 pm
by Jector
That's exceedingly cool. Thanks, J McM. :)

EDIT: Hey, I don't know if it's my excel or not but the Powers tab starts out shifted off the window to the left. Had to scroll over for them.

Works like a charm, though.

Posted: Mon Aug 04, 2008 11:21 pm
by Hawke
Looks great! I'm eager to see this flesh out!

One question... I'm making a Rogue and he has the blinding barrage power... it's always showing up as +3 (raw dexterity bonus w/o the 1/2 level) vs AC as attack under the quick view tab. If I correctly setup blinding barrage on the attacks page it seems to correctly calculate the attack bonus including 1/2 level and the weapon prof.

I can't wait to see more stuff automatically filled in like power cards! This is great work.

Posted: Mon Aug 04, 2008 11:45 pm
by hennebeck
Is there a way to add a race?
I'm thinking of playing a FR Genasi.

Posted: Tue Aug 05, 2008 7:31 am
by James McMurray
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.

Posted: Tue Aug 05, 2008 7:54 pm
by James McMurray
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.

Posted: Tue Aug 05, 2008 9:06 pm
by Hawke
Cool work, James. Anything we can do to help you with the project? Any major issues you know of?

Posted: Tue Aug 05, 2008 9:15 pm
by James McMurray
All that's really left it the 2 todos in the first post, and getting the power cards to work as well. That last one might be tricky, as I'm not really sure what kind of control there is over cells with just functions. I'd like to automate the coloring rather than have there be a ton of blanks like there is for the quick view page. Hiding those for printing is pretty easy, but hiding 20 blank cards would probably be annoying.

That part is kinda on the back burner for now though. Now I'm looking at converting pdf to html to excel so I can make monster cards from the MM for an encounter creator.

Posted: Tue Aug 05, 2008 10:41 pm
by Sir Flak
i noticed the cleric class powers show up no matter what class i pick

Posted: Thu Aug 07, 2008 12:11 pm
by James McMurray
I'm not seeing that with this version. If it's still happening, let me know what you're using to view it (Office, Open Office, etc.) and I'll check it out.

Current Version 3.1 - 8/07/08

Can be found here.
The version with macros is still here.

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

Posted: Fri Aug 08, 2008 7:17 am
by James McMurray
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 [url="http://www.colugo.org/jmcmurra/MacrolessSheet_3_1.zip"]can be found here[/url].

Posted: Sun Aug 10, 2008 1:38 pm
by James McMurray
Current Version 3.2 - 8/10/08

Can be found here.

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