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!
Bah, my enworld subscription to this thread isn't working properly. I missed that 1.16 beta was out. I'll see what I can do about finishing up import/export in a few days. It's a busy week so no promises but maybe.
Paragon pit fighter powers show when char less than level 11
$'Charsheet I'.BA18 (race/class adjustment to armor) picks up $Paragon.J11 (pit fighter armor optimization) and adds 1 to all fighter heavy armor even when the character level is less than 11.
Suggested fix: Change each truth check of the Paragon sheet, column P (Labeled: Prerequisites for Path fulfilled?) to the form:
"=AND(Level>10; IF(blah blah blah) ) "
The change confirms a character is at least level 11 before allowing paragon powers to be enabled.
When entering an Ranger - Archer character, I noted that for the first encounter power on Charsheet I, the Defence was listed as 8 even though the Attacks tab shows that this should be shown as AC. 8 happens to be equal to the BAB for this character. The Pro Sheet shows AC.
Bral, I have only used the full version in OOCalc. It takes a while to open, but you do get full functionality. I open in xls and save back, despite the warning, to the same format. Note that a few bugs exist when using OOC (refer back to page 4+ of this thread for my posts) I believe those fixes will be included in the next release.
As reported elsewhere, two small issues with the Swordmage using Excel 2007:
- The Escalating Assult feat isn't 'selectable' even though I do meet the requirements (I'm a Swordmage with aegis of assault). Remains light grey. [Later: Sorry, didn't see that xone01 already posted this a page back.]
- Hit Points aren't calculating correctly. A 4th level Swordmage with a 16 Con is getting only 43 HP on your sheet, when it should be 49 (15 + 16 [Con] + 6 [x3 for 2nd, 3rd, and 4th levels] = 31 + 18 = 49).
Aside from these issues, I love this sheet (and showed my love the PayPal way ).
Last edited by Wraith Form; 5th October 2008 at 01:49 AM..
- Hit Points aren't calculating correctly. A 4th level Swordmage with a 16 Con is getting only 43 HP on your sheet, when it should be 49 (15 + 16 [Con] + 6 [x3 for 2nd, 3rd, and 4th levels] = 31 + 18 = 49).
We couldn't recreate this problem. The sheet seems to work fine. Shows 49 for us.
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
We leav ethis link up for our trsuted fans to have a look at it. If we don't get any serious bugreports in the next days it will go live on the heroforge server and I will take down this link again.
Thanks for all your input.
Enjoy!
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
There is a problem in the version 1.16 (xp version) calculating de HP. It dosen't increse your HP if you increase your Constitution score with the score modifier by level (lvl 4, 8, etc). Probably it is referring to the wrong cell, but my excel is very very basic, and I don't know how to change it.
Great job!
Andy
Edit: The problem with the HP was in the ExportSheet tab, cell N48 was pointing to cell "Basics!J68" and should be "Basics!K68" for the calculation to be correct.
Also discovered another problems in the Attack tab:
- The "Damage Bonus, Weapon" lines seems to be not considering Eladrin Soldier feat.
- The "Damage" lines have a big problem, and I don't know exactly what it's the problem yet. The one in row 58 seems to be considering twice the magic item bonus, and the one in row 105 seems to be ignoreing the Weapon Focus and the like.
Last edited by elandy; 5th October 2008 at 08:25 PM..
Mini power 1, melee basic attack, 1[w] str vs AC Shows damage as 2d6 +7
Should be 3 (str) + 1 (magic) + 2 (feat) = 6. I think it is adding the magic bonus twice
Mini power 2, ranged basic attack gets the damage correct at 1d6+5 (str + feat)
all other powers that use the Mordendrad have +7 damage instead of +6
Power 3, Channel divinity: Turn undead, has damage as 1d10+4, should be +3
2 (cha) + 1 (magic)...
Power 5 Sacred flame, is also off by 1 (1d6+5 instead of +4, 3 (wis)+1(magic)
now to power 6 and 8 which are also using attack 1.
their damage is listed as 4d6+4, and should be 4d6+6...3 (str) + 1 (magic) + 2 (feat)
I note that the weapon damage bonus line appears to be correct in all of these cells (magic + feat if applicable).
on to the pro sheet. Damage here is consistantly listed as +3 (str). no magic or feat bonus added-- I can't remember if that should be the case or not.
Except for sacred flame, which has a +4 damage somehow.
I have found that the damage bonus being calculated incorrectly is directly related to the magic item bonus. It is giving a +X to hit but is giving +X+1 for the magic weapon. i.e +1 weapon is +2 dmg, +2 weapon is +3 dmg etc.
Not sure where to fix that one.
Also please add Gnoll Claws or just Claws as weapons somewhere for the Gnoll feat please.
__________________ "Ná Eru veria le, ná elenath dín síla erin rád o chuil lín."
Last edited by Mithreinmaethor; 7th October 2008 at 03:51 AM..
All right, I think i've isolated the problem with adding enhancement damage twice. On the Transport Attack sheet, the "modifiers sign" formula (in row 12) should be "=IF(C11>=0,"+"&C11,C11)"
obviously, this formula needs to be translated for each power to the corresponding cells
Also, I've noticed that Eladrin Soldier was still not granting proficiency with all spears or bonus damage with any of the weapons. The fixes were easy...
For bonus damage: On the Proficiency tab, in column J replace "$S$36" with "$S$37" (it was accidentally referring to Dwarven Weapon Training instead of Eladrin Soldier)
For weapon proficiencies: Copy the formula in cell E28 on the Proficiency tab into the cells in column E corresponding to the spear weapons. You'll also want to use the same formula for the axes and hammers, replacing "$S$37" with "$S$36" so that Dwarven Weapon Training gives the proper proficiencies as well
I did have one question, while I was throwing together a swordmage, I noticed a couple powers that weren't in the FRPG (specifically Frigid Blade and Dimensional Thunder). Can anyone tell me where these powers come from?
I did have one question, while I was throwing together a swordmage, I noticed a couple powers that weren't in the FRPG (specifically Frigid Blade and Dimensional Thunder). Can anyone tell me where these powers come from?
Found a minor error that would make weapon focus not work properly with dwarven weapon training or eladrin soldier...
on the Proficiency tab, column G (which returns the total bonus damage from feats), you need to replace all the "MAX"es with "SUM"s. This should allow you to get the benefits of your racial training and weapon focus
Found a minor error that would make weapon focus not work properly with dwarven weapon training or eladrin soldier...
on the Proficiency tab, column G (which returns the total bonus damage from feats), you need to replace all the "MAX"es with "SUM"s. This should allow you to get the benefits of your racial training and weapon focus
They are all feat bonus, so they don't stack, so it's working as it should (except for the attack tab, in the "Damage" line on row 105, that is not counting any feat bonus to damage, although they are showing correctly on the "Damage Bonus, Weapon" line on row 99, except for eladrin soldier feat, but that was already explained by you how to fix it)
They are all feat bonus, so they don't stack, so it's working as it should (except for the attack tab, in the "Damage" line on row 105, that is not counting any feat bonus to damage, although they are showing correctly on the "Damage Bonus, Weapon" line on row 99, except for eladrin soldier feat, but that was already explained by you how to fix it)
Andy
ah, i was mistaken. must've missed that section before. thanks for clearing it up
I'm brand new here; in fact, this is my first post! I want to first say how much I love this excel-based sheet. It makes character creation 100% easier and, in my opinion, more fun! So, hats off to the creators. This is a wonderful program and works perfectly on my OS X 10.5.5.
I think I might have found a bug, which might or might not have been discussed already. This is in Version 1.15 of the program. When one selects Fighter as their class, there is not "Mace" in the options for the Melee Weapon Group. It's available in the PHB but not in the sheet.
My next question is that I'm wondering if there will be an update to the character sheet program to include the newly released Barbarian Playtest available here: Dragon 368: Barbarian Playtest
I'm sure this has already been asked; and if it's in the works then I'll continue to wait patiently for the next version to come out.
I hope I posted these in the right place! Again, despite the bug I found, I love the excel program and will always continue to use it!
).
Linear Mode
And yet another word from our sponsors
