4e Fan Creations and House RulesWorking on variant powers? Statting up a PC race or your version of a monster? Creating or converting an adventure? Put it here!
Gamers Online Now: 1,098
164 members and 934 guests
Most users ever online was 4,029, 8th April 2009 at 05:04 PM.
This product is 56 pages long and free. Cover, credits, intro and ToC take up 4 pages. I counted 17 pages of adds many of them for other Rite... [Read More]
Evocative City Sites Lorn's Entrepot (Abandoned Warehouse) by Rite Publishing. I was given this product for the purposes of this review. This product is 47 pages long. Cover, Credits, two pages of... [Read More]
Feats 101 by Rite Publishing. I was given this product for the purposes of this review. I have not yet played using these feats my review is based on reading the feats and checking a few against... [Read More]
The Plane Below: Secrets of the Elemental Chaos is a 4e D&D product describing some of the different planes in the 4e Cosmology. The book is a typical hard bound book that Wizards of the Coast... [Read More]
did it fast so there could be mistakes but it shows how to use the sheet
Indeed it does show, thanks. Let me make a few comments and ask a couple of questions while at it:
1) As mentioned, heavy thrown = use Str for javelin even though ranged.
2) Notice on the Attacks tab you used attack bonus 1 for ranged basic and attack bonus 2 for melee basic, which is swapped. I only mention it because the first time I tried using the sheet I made the same mistake. I believe that most people will intuitively tend to think of their primary melee weapon first and their ranged next, although that may only be for defenders while rangers and wizards, for instance, may have the opposite. The KotS pregens show melee before ranged for basic attacks. I just wonder if the incidence of mistakes would be less if melee basic came first (column E) and ranged second (column G). Maybe there is some other creative way to facilitate getting the correct attack bonus chosen on favorites/basic.
3) I notice you overrode the attack bonus for the powers, using straight-up Str rather than the BAB, which includes weapon proficiency bonus. Those bonuses do apply to powers so there's no need for the override. I looked back at the PHB and unfortunately it is not even mentioned in the Attack section of Powers in the Classes chapter that you should include it, but weapon proficiencies (Equipment chapter, how to read weapon table) says they apply to attack rolls, which is a broad category including powers. Still, I think they could/should have made this more explicit and I hope it doesn't confuse too many people.
4) So if I want to account for using something like a dagger in melee and ranged I should use 2 attack bonus columns in the Attacks tab, one entering Str and the other Dex, right?
5) I like the way that I can just change the attack bonus # (1-5) for a power and have it update the character sheet accordingly, rather than needing a separate entry.
6) Probably too much to ask, but it would be awesome if under Base attack bonuses you could just specify a weapon and based on a lookup of its properties it could determine whether it is usable for melee, ranged, or both, and accordingly calculate cell values indicating the relevant ability. Instead of having one Ability and BAB per entry it would have two, one for melee and one for ranged. If the weapon is only applicable for one or the other, an N/A could appear in the relevant cells (not to be confused with Excel's #N/A). It would use the light vs. heavy thrown properties to determine whether ranged should use Str or Dex, etc.
7) Edit: noticed something else. The Attacks tab row with drop downs to select the weapon/implement type (row 8) is called "weapon/implement type" and the one where you entered the damage die (row 10) is called weapon/implement name. I think row 8 is name, and I'm not sure either what type means or why you entered the damage die. If you do mean to put the damage then in the future you could consider letting the damage field for the favorite powers automatically calculate that based on whether it's 1[W], 2[W], 0, etc. base damage and which attack bonus (i.e. which weapon) was chosen, where appropriate. Just a thought.
Again, thanks for your hard work!!!
__________________ --Magus Coeruleus.
Last edited by Magus Coeruleus; 11th June 2008 at 08:57 AM..
Could you make Attack/power backgrounds change color based on what you pick from the power type drop down? So if you picked at-will the background would be greenish.
Encounter it would be redish and Daily would be grayish. Or maybe just the border?
Would make it easy to see what powers were what type.
1) As mentioned, heavy thrown = use Str for javelin even though ranged.
Yea I didn't pay attention to that sorry
Quote:
Originally Posted by Magus Coeruleus
2) Notice on the Attacks tab you used attack bonus 1 for ranged basic and attack bonus 2 for melee basic, which is swapped. I only mention it because the first time I tried using the sheet I made the same mistake. I believe that most people will intuitively tend to think of their primary melee weapon first and their ranged next, although that may only be for defenders while rangers and wizards, for instance, may have the opposite. The KotS pregens show melee before ranged for basic attacks. I just wonder if the incidence of mistakes would be less if melee basic came first (column E) and ranged second (column G). Maybe there is some other creative way to facilitate getting the correct attack bonus chosen on favorites/basic.
I was moving fast and didn't realize I had switched them. You do have a point about how it could get confused and it probably should be more like the WOTC character sheet in that way.
Quote:
Originally Posted by Magus Coeruleus
3) I notice you overrode the attack bonus for the powers, using straight-up Str rather than the BAB, which includes weapon proficiency bonus. Those bonuses do apply to powers so there's no need for the override. I looked back at the PHB and unfortunately it is not even mentioned in the Attack section of Powers in the Classes chapter that you should include it, but weapon proficiencies (Equipment chapter, how to read weapon table) says they apply to attack rolls, which is a broad category including powers. Still, I think they could/should have made this more explicit and I hope it doesn't confuse too many people.
I was under the impression that if it said Str vs AC then it was a straight Str stat mod (with level adj). While it did make sense to use your weapon prof bonus and any other bonuses based on weapon it wasn't clear.
Quote:
Originally Posted by Magus Coeruleus
4) So if I want to account for using something like a dagger in melee and ranged I should use 2 attack bonus columns in the Attacks tab, one entering Str and the other Dex, right?
That would be the best way I can think of.
Quote:
Originally Posted by Magus Coeruleus
6) Probably too much to ask, but it would be awesome if under Base attack bonuses you could just specify a weapon and based on a lookup of its properties it could determine whether it is usable for melee, ranged, or both, and accordingly calculate cell values indicating the relevant ability. Instead of having one Ability and BAB per entry it would have two, one for melee and one for ranged. If the weapon is only applicable for one or the other, an N/A could appear in the relevant cells (not to be confused with Excel's #N/A). It would use the light vs. heavy thrown properties to determine whether ranged should use Str or Dex, etc.
The problem is that I am sure it will not always be that way. If we were allowed to use macros we could have the "usual" stat be placed in the box and then let you change it if you need but that doesn't work with OO. Personally I hate the way OO works and would love to say the hell with OO but that is me.
Quote:
Originally Posted by Magus Coeruleus
7) Edit: noticed something else. The Attacks tab row with drop downs to select the weapon/implement type (row 8) is called "weapon/implement type" and the one where you entered the damage die (row 10) is called weapon/implement name. I think row 8 is name, and I'm not sure either what type means or why you entered the damage die. If you do mean to put the damage then in the future you could consider letting the damage field for the favorite powers automatically calculate that based on whether it's 1[W], 2[W], 0, etc. base damage and which attack bonus (i.e. which weapon) was chosen, where appropriate. Just a thought.
I put those there only for my info while filling the sheet. One of the improvements I am working on is having a place to put the damage die into the attack slot at the top so that when you are filling out the favorite powers section you don't have to flip in the book.
Could you make Attack/power backgrounds change color based on what you pick from the power type drop down? So if you picked at-will the background would be greenish.
Encounter it would be redish and Daily would be grayish. Or maybe just the border?
Would make it easy to see what powers were what type.
This is a good idea, I just hope they don't add more types as the conditional formatting only handles up to three options.
Great job so far on the Spreadsheet. I did notice one issue on the attacks tab. Only attack bonus 2 seems to work properly. The other attack bonuses don't seem to calculate the proper BAB based on Ability Score (it shows as a blank), and on the character sheet the selected ability bonus and BAB both show as blank.
From my site. THANKS for using our sheet and supporting us with bugs
Quote:
Originally Posted by Amurayi
Anna, the Excel guru of our team, didn't work a lot with Open Office so far but yesterday I saw her playing around with it. There are some functions OpenOffice hates like SVERWEIS and DVERWEIS (german excel lingo). Maybe we'll find a workaround. As we have no macros whatsoever, which is a great boon, it would be really great to have it working for Open Office, too.
I looked it up and I think that there is a way of easy correction so I will try to make the sheet completly usable to OOcalc. I hope that the open office version is ready to download next week (had a lot of trouble and work around). so please exercise patience and wait till day you can use our sheet with OOcalc.
Wow, this is was a wonderful surprise. I had no idea how much good stuff there was going to be in this spreadsheet. And I'm thrilled with the way the first page of the character sheet works. Here are some suggestions for you guys (I went left to right through the sheets).
1) An override column for attributes. Twice I've wanted to break the rules (e.g. make someone with a 6 STR) and I have to go up and turn off the protection, and then turn it back on.
2) Put an X in the 'Trained' column when its a preset or from skill training. It's weird to have 5 skills and only 4 X's.
3) Feats. Gray out all three columns when not available.
4) Link/Pulldown Weapons from Attack sheet to Armor&Equip sheet
5) The "If you start at Level N>1" table seems wrong for Level 2 (at least) but maybe it's a problem with the DMG. I'll check later.
6) For powers 6-N can't they be entered on the same chart and then just display #6 on using the same format on the 2nd character sheet? That way you can track them all in the same format.
7) Even better. Have check boxes above the N power listings, pick five or less, and have those be reported on the first page of the sheet.
8) Keywords as a pulldown, checkmark, list
9) Auto populate weapon ranges and damage.
10) On the second character sheet, I really don't care about the sell price of my equipment. I'd rather have a column for "Daily Power" that could be checked to indicate it has one, and to make a mark showing that it's been used. The page number is very useful.
11) For my ranger with TWF Toughness is being included in the HP calc, but not showing up on the Feats list.
12) Finally, I'd shrink the box for Racial Features as it seems too large, and slide feats to the top, so that Utility powers are next to the rest.
Again, awesome job, this sped things up SO MUCH while typing in 4 characters.
You should change the Power Attack text to account for two-handed weapon damage. Something like:
"+2 damage (+3 for two handed) for -2 to attack, bonus increases with level"
Or something similar as this is a very popular feat for those who fight with two handed weapons and it's one of those easy to forget things in the middle of combat.
the soccer European championship is on so I hardly get Anna off the TV. So here's a minor update for you. Still working on the Open Office issues and some other design possibilities you requested.
Version 1.10: RELEASED 06-12-08 Bug fixes:
- Linebreak for text on Charsheet page 3
- Feats: "Arcane Initaite" fixed (can be selecetd if trained in Arcana
- Feats: "Initiate of the Faith" description fixed
- Paragon Path: Pit fighter adds 1/2 level to damage now
- Half-Elf extra power now appears on charsheet, too
- Fighter's "Sweeping Blow" added
- Wizard: Proficieny bonus of staff and dagger now shows correctly on attack page
- Backpack Item cells can be edited again
- LFR: East Rift can be selected as Region as well
- Halfling Bonus now listed correctly
to be continued...
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
Found this thread today just in time for your latest version. Great stuff.
The biggest hole I found in functionality that I wish it had would be calculating damage bonuses. The official character sheet has a "damage workspace" which is similar to what you guys have for the attack bonuses section, except specifically for damage.
Would it be possible to have fields for all the things that could add to a particular ability for damage bonuses? For instance, individual fields for the user to type in bonuses from feats, from enhancements, and then a couple of miscellaneous fields (with a comment section so you remember where a particular bonus comes from).
Seems like you could pull the damage dice from the weapon being referenced from the attack bonus assigned, then add up all the manually listed damage bonuses for a single +N on the actual character sheet. That way you can be sure you are putting in the right numbers.
Other than that, I really can't find any fault in it. I'm blasting out a bunch of pre-gen level 1 characters for friends to play with next week... I don't even care if they use them or not it is so easy!
Expect a dollar (possibly more than one) from me shortly.
I do have 1 problem I've noticed. The Eldadrin Bonus Skill doesn't show up on the skill tab.
Also as a ranger (so far), and this is probable a me thing, but the powers did not show up on the attack tab for to choose any @will, encounter or Daily powers.
Other than minor things, this sheet is impressive and over all very thorough.
Keep up the great job!
Anyone found a good way to upgrade? Seems like it would be a real pain to have to redo your level 30 characters. Even redoing a level 1 character takes some time with copy & paste. HeroForge used an external file with character metadata, but that probably requires macros. Macros to update the sheet are a possibility too--you can still use the entire sheet without macros but if you can use them, you gain the ability to upgrade quickly...
Gamers Online Now: 1,098
In that order.
Version 1.10: RELEASED 06-12-08
Linear Mode
