4E: Macroless sheet with autocalculating combat tracker

Show off your RPG maps, campaigns, and tokens. Share your gaming experiences and stories under General Discussion and save this forum for things you've created that may help others run their own games. Use the subforums when appropriate.

Moderators: dorpond, trevor, Azhrei, Gamerdude

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

4E: Macroless sheet with autocalculating combat tracker

Post 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.
Last edited by James McMurray on Sun Aug 10, 2008 1:38 pm, edited 6 times in total.

User avatar
Full Bleed
Demigod
Posts: 4736
Joined: Sun Feb 25, 2007 11:53 am
Location: FL

Post by Full Bleed »

This a 4e thing?

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

Post by James McMurray »

Yeah, sorry about that. Subject line edited.

User avatar
UntoldGlory
Great Wyrm
Posts: 1649
Joined: Sun Mar 16, 2008 8:12 pm

Post by UntoldGlory »

Cool, I'll check it out soon!

User avatar
Jector
Great Wyrm
Posts: 1164
Joined: Sun Aug 27, 2006 9:19 pm
Location: Atlanta

Post 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.
I cast firecube! ~4E

User avatar
Hawke
Great Wyrm
Posts: 2261
Joined: Sat Apr 21, 2007 12:12 am
Location: Albuquerque, NM

Post 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.

User avatar
hennebeck
Dragon
Posts: 394
Joined: Sun Jun 01, 2008 12:06 am
Location: THe City of Roses

Post by hennebeck »

Is there a way to add a race?
I'm thinking of playing a FR Genasi.

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

Post 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.

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

Post 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.

User avatar
Hawke
Great Wyrm
Posts: 2261
Joined: Sat Apr 21, 2007 12:12 am
Location: Albuquerque, NM

Post by Hawke »

Cool work, James. Anything we can do to help you with the project? Any major issues you know of?

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

Post 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.

User avatar
Sir Flak
Dragon
Posts: 344
Joined: Thu Sep 28, 2006 4:20 pm
Location: Oklahoma, US

Post by Sir Flak »

i noticed the cleric class powers show up no matter what class i pick

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

Post 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

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

Post 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 can be found here.

James McMurray
Kobold
Posts: 22
Joined: Mon Jul 28, 2008 9:39 pm

Post 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

Post Reply

Return to “User Creations”