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!
The class-based options (such as the Warlord's "Inspiring Presence", the Rogue's "Rogue Tactics", the Fighter's "Weapon Talent", etc.) are not properly checked when populating Character Sheet II.
Some changes to the Class Features sheet were not transferred from the v1.12 Class Overview sheet: several of the =IF statements in column W of Class Features refer to other cells on the sheet, but these are unformatted.
In v1.12, the referenced cells (such as AJ125 for the Warlord) contain references to cells on the Charakter Basics Transport sheet, which in turn reference the selections on the Character Basics sheet.
In 1.14, however, the equivalent cell on Class Features is W26, which tests AJ11 -- but this cell does not contain a reference to Charakter Basics Transport, but is instead blank.
I believe the column W tests ought to check some new cells to the right of AM2:AM4, which then would contain the necessary references to Charakter Basics Transport. See v1.12 Class Overview sheet, cells AD124:AJ130 for examples of what's needed. (Not to mention the new class features for Swordmage...)
I like the changes! I like having the bonuses for LFR regions and the main PC sheet looks great.
I noticed the table tent shows gender, but I don't know where this is selected by the user.
The ProSheet looks good on Letter, but the original two worksheets still do not print correctly on Letter (they look great on A4). It would be excellent to have the option of printing this style on Letter.
The class-based options (such as the Warlord's "Inspiring Presence", the Rogue's "Rogue Tactics", the Fighter's "Weapon Talent", etc.) are not properly checked when populating Character Sheet II.
You are right. Thanks for pointing it out. Consider it fixed in the next version.
Quote:
Originally Posted by Dane
I just have to say that the Pro Character sheet is absolutely outstanding! Thank you, thank you.
It's those kind words which keep us going. Thanks! We are very glad to hear you guys like what we have created!
Quote:
Originally Posted by pat512
Has Jack of All Trades broken since 1.12? It doesn't seem to be having any effect in 1.14.
Thanks for pointing it out. Fixed in upcoming version!
Quote:
Originally Posted by Alphastream
I noticed the table tent shows gender, but I don't know where this is selected by the user.
.... It would be excellent to have the option of printing this style on Letter.
Hmm yeah. We took the gender out again on the table tent. Meanwhile you can change the gender directly as a dropdown on the table tent in 1.14.
We're considering make the sheet 1 and 2 fit in height for US letter. But it's not a priority for now.
1.14 is now online on heroforge. I will take down the link for our own page. 1.15 is already in the works. But we are waiting a bit longer for input ands bug reports so people don't have to rebuild their char every second day.
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
Last edited by Amurayi; 13th August 2008 at 01:15 PM..
His hp and +2 will class defense bonus are calculated correctly, however I can't select powers and the skill sheet only shows #NV in both skill training at level 1 and trainable skills left
PS: I really like the landscape format sheet
Last edited by Mirtek; 13th August 2008 at 01:41 PM..
Firstly, I wanted to say - great work on the sheet. I love it and use it with all my 4e stuff.
But I think I may have found a bug.
I made a dwarven fighter with 16 str and one-handed weapon talent.
This should give him a total of +6 to hit with a warhammer (+3 str, +2 prof, +1 for weapon talent) but for some reason, the sheet is giving him a +2 misc bonus instead of a +1 and giving him a +7 to hit. (it did the same thing with the throwing hammer).
I looked through the PHB for that additional plus one (hoping I was wrong, actually), but can't find it.
Wanted to bring it up, just in case. Looks like the sheet might be giving my dwarf more credit than is deserved
First off, love the updated sheet--it's a great piece of work. And I love the addition of the Pro Charsheet, that'll make my life especially much easier. One thing I did notice, however, it that it doesn't appear that the damage translates properly into the pro sheet, although they do appear properly on charsheet I.
For example, when I configure my Melee Basic Attack with a longsword using either 1[w] or 1d8, the charsheet shows the proper STR ability with a +6 vs AC and damage of 1d8+3. However, the pro charsheet shows STR vs AC with a damage of 1[w]+0 or 1d8+0. The weapon damage copying directly isn't any issue (I can deal with changing that by weapon I'm using--not a big deal at all) but it might be a good improvement if the damage bonuses copied properly or even just came in at, for example, 1d8+STRmod rather than 1d8+0. It's probably just a matter of adjusting a couple of formulas, but I suck at Excel.
Any thoughts on how to fix this would be greatly appreciated...
If you pick Pact Initiate, the power it gives you shows up as the Pact picked. In other words, if you pick Fey Pact, in the attack section it shows Fey Pact, not Eyebite - and there doesn't seem to be an easy way to replace this.
If you go Paragon Multiclass, it lets you pick the half-elf dilettante power as well as the regular at-wills as one of the at-wills you can replace.
Just want to inform that there is a free official compatibility package released by Mircrosoft itself which enables Office XP and Office 2003 to open and save Office 2007 files.
So maybe you should just release your file in the original Office 2007 version and we people with older Office versions download the compatibility upgrade direclty from Microsoft (it's only 27.5 MB)
Downloaded this, applied it to my Office 2003 install, and still get the same error about cell formats...
So guessing the split-into-2 format is the way to go...
First off, love the updated sheet--it's a great piece of work. And I love the addition of the Pro Charsheet, that'll make my life especially much easier. One thing I did notice, however, it that it doesn't appear that the damage translates properly into the pro sheet, although they do appear properly on charsheet I.
Just wanted to confirm Im seeing the same thing on the 'XP 1.14' version...
The idea behind the Pro Sheet is that you shouldn't have the damage listed. It all depends on the weapon you are using. We made this so it's easy for people with multiple weapons to quickly see what damage it does. So instead of 1d8+X it's better to have it appear as 1[W]+X. So look up your attack bonus depending on the weapon an then look down what power you want to use and adjust the damage according to the weapon you use it with.
The actual damage properly written out should work on the normal sheet as this is easier for beginners.
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
The idea behind the Pro Sheet is that you shouldn't have the damage listed. It all depends on the weapon you are using. We made this so it's easy for people with multiple weapons to quickly see what damage it does. So instead of 1d8+X it's better to have it appear as 1[W]+X. So look up your attack bonus depending on the weapon an then look down what power you want to use and adjust the damage according to the weapon you use it with.
The actual damage properly written out should work on the normal sheet as this is easier for beginners.
Which is exactly what I said I was having the problem with. The issue isn't that it shows as 1d8+x or 1[w]+x, but the fact that it shows as 1d8+0 or 1[w]+0 instead of 1[w]+x
Having the damage box read 1[w] + modifier would be perfect. The way it shows now as 1[w] + 0 implies that there is no damage bonus and that it's straight weapon damage no matter what.
As I stated previously, I like the look and layout. I like the simplicity of the pro-sheet and I agree that it makes it much easier for people with multiple weapons (like me). However, I would think that it should include damage bonuses either in the form of straight number (because that's not likely to change based on your weapon) or at least by including the damage modifier category...
Last edited by dburras; 13th August 2008 at 07:27 PM..
Have you given any thought to adding more drop-downs for the available magical items/weapons/armor that are in the PHB? Allowing for people to equip this stuff in the weapon/armor area and adding the bonuses to the correlating areas on the character sheets? I've seen a few other Excel version character sheets which do this and thought it would be pretty cool if you incorporated this feature as well.
Okay, I discovered there is a problem with the Multiclassing stuff on the sheet. It appears that the formulas for the feats Acolyte Power (utility) and Adept Power (daily) are referenced in the Powers Known sheet backward, i.e. Acolyte = daily and Adept = utility. This is causing problems on the final sheet.
Additionally, I am not seeing how we should replace a pawer as we go up in level with a power from our multiclass. For instance, if I was a fighter multiclassed as a wizard with Novice Power as one of my feats, at level 7, I should be able to swap say Sweeping Blow for Color Spray. The only way I have found to do it is to delete Sweeping Blow in my powers list and use the Custom tab. But shouldn't we simply be able to switch the power in our powers list?
Bugwise (at least on the XP version) there seems to be a problem on the TransportAttack sheet. If I'm reading it right, cells C46, E46, etc. should read...
=IF(C47=0,SUM(C48:C50),C47)
Right now, the first column only counts down C48:C49, thus missing the Class Bonus. The second column counts E48:E51, thus double-counting the Fighter Weapon Talent.
This made my dwarf fighter work out okay.
EDIT: Also, the Eladrin is missing their Dex bonus in the Race Overview sheet.
Quote:
Originally Posted by Amurayi
The idea behind the Pro Sheet is that you shouldn't have the damage listed. It all depends on the weapon you are using. We made this so it's easy for people with multiple weapons to quickly see what damage it does. So instead of 1d8+X it's better to have it appear as 1[W]+X. So look up your attack bonus depending on the weapon an then look down what power you want to use and adjust the damage according to the weapon you use it with.
The actual damage properly written out should work on the normal sheet as this is easier for beginners.
Ahhh, gotcha.
I went ahead and edited those cells so that it calculated like the regular sheet, since I like that convenience. It's a simple enough edit if anyone else does, too. Just Unprotect (Tools --> Protection --> Unprotect Sheet) the sheet, make the first cell (BG38)...
=IF(AQ34="","",Attacks!E48)
And so on down the road, just deleting most of the middle section of each formula and replacing the final 46 with a 48.
I hope that helps!
-O
Last edited by Obryn; 13th August 2008 at 10:23 PM..
This is great work. Here are a few minor issues that you may want to fix:
-Orb Mastery cannot be chosen as an Wizard's Implement.
-On CharsheetI Character Name is misspelled with a k.
-Eldarin is missing his racial Bonus to Dex
Moreover, I would redisign the character sheets somewhat to make it look less cluttered:
-4ed has no magic items that increase attributes, so having an item bonus box for attributes is unnecessary.
-Can the critical damage box be shrunk to allow for more space in the effect box?
-I'm not sure the 2 Base attack Bonus Boxes need to be on the sheet, as all those calculations should have been done elsewhere. This room could be used to put one more Favorite power on.
-Maybe we can also rethink putting the powers as the last thing on the sheet. After all, nothing defines a PC like his powers.
Anyway, hope some of this helps. Thanks.
Last edited by Harlekin; 14th August 2008 at 12:32 AM..
Reason: found more
Which is exactly what I said I was having the problem with. The issue isn't that it shows as 1d8+x or 1[w]+x, but the fact that it shows as 1d8+0 or 1[w]+0 instead of 1[w]+x
Having the damage box read 1[w] + modifier would be perfect. The way it shows now as 1[w] + 0 implies that there is no damage bonus and that it's straight weapon damage no matter what.
As I stated previously, I like the look and layout. I like the simplicity of the pro-sheet and I agree that it makes it much easier for people with multiple weapons (like me). However, I would think that it should include damage bonuses either in the form of straight number (because that's not likely to change based on your weapon) or at least by including the damage modifier category...
Please, I beg you, list the damage on the pro sheet like it is on the character sheet. Thanks again for the awesome work.
Moreover, I would redisign the character sheets somewhat to make it look less cluttered:
-4ed has no magic items that increase attributes, so having an item bonus box for attributes is unnecessary.
Yes there are. Look at Gauntlets of Ogre Power p. 247. The bonus is added to ability checks, not the ability itself.
-Can the critical damage box be shrunk to allow for more space in the effect box?
Actually with higher level you will see that the critical damage fields needs a lot of space. This might not be apparent on lower levels.
-I'm not sure the 2 Base attack Bonus Boxes need to be on the sheet...
Well it's only one more than a regular sheet. And if you are a ranger you actually want more if you have different magic weapons (melee and ranged). Other classes indeed only need one indeed.
-Maybe we can also rethink putting the powers as the last thing on the sheet. After all, nothing defines a PC like his powers.
I don't see the powers as the first thing on any sheet. If you want powers to be more dominant I suggest using our Pro sheet which is the most dominant thing. Also use a sheet where there are powers only.
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
Last edited by Amurayi; 14th August 2008 at 12:32 AM..
Please, I beg you, list the damage on the pro sheet like it is on the character sheet. Thanks again for the awesome work.
The Pro sheet should list the ability bonus to damage for each power. If it doesn't then it's a bug we will fix!
We will stick to listing the damage with [W] as there is no indication which base attack or weapon you are using it with. It's designed to be more flexible. If you want the damage written out completely use 1d8 for example. Then this is your weapon damage.
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
Linear Mode
And yet another word from our sponsors
