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 Pro sheet should list the ability bonus to damage for each power. If it doesn't then it's a bug we will fix!
At least on the sheet that was split onto 2, it is doing that. I had to do the fix listed above to clear up the damage problem on the Pro Sheet.
With the Damage on the pro sheet, could it be listed like this:
2d8+5(20+1d6)
(person with an 18 attribute using a +1 item)
The damage block on the pro sheet seems to have a lot of room, and filling in the crit detail seems like something that will speed up combat - especially for the people who want to use the pro sheet even if they can't calculate numbers quickly in their head...
Perhaps a simple true/false field could be used somewhere to indicate a preference: see values / see [W] on pro sheet. (Meanwhile, the Wizards and Warlocks are laughing at the silly people with their shiny metal bits.)
The good news is that the .zip file contains both the combined (Excel 2007 only) spreadsheet and the split (Excel XP/2003 compatible) sheets.
The bad news is that the split sheets appear to be the previous v1.14.0 version, not the new v1.14.1 -- which presumably has patches for the recently-reported bugs.
Charles, who is playing an LFR game this weekend and needs a fixed compatible version...
Doh, we used "Spellsword" instead of "Swordmage" in some places as terms. No wonder he doesn't work properly. Consider it fixed!
Is it fixed for version 14.1 'cause I can't get the powers in the drop down menu to work in the powers tab.
Something doesn't seem right with the attack bonuses.
It's giving me the correct bonus with simple melee and military ranged weapons, but only the ability bonus (no proficiency bonus) with military melee and simple ranged weapons.
Last edited by Superboy; 14th August 2008 at 11:22 AM..
The bad news is that the split sheets appear to be the previous v1.14.0 version, not the new v1.14.1 -- which presumably has patches for the recently-reported bugs.
No worrys. There's no difference in the versions. All bug fixes will appear in v1.15 which we will publish today or friday so you guys can start playing LFR!
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
No worrys. There's no difference in the versions. All bug fixes will appear in v1.15 which we will publish today or friday so you guys can start playing LFR!
Great, thanks! I'll be clicking "Reload" every couple of minutes...
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.
Perfect. Thanks!
Last edited by dburras; 14th August 2008 at 05:06 PM..
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.
Sorry been trying to post for a couple of days now, I'm sure some of these have been reported or addressed by now:
Swordmage powers do not appear on drop downs.
Staff of Defense AC bonus does not appear on character sheet.
Drop tab for gender is locked on the initiative card tab.
Brew Potion is now a Level 1 Ritual.
Last edited by Rerednaw; 14th August 2008 at 08:00 PM..
Staff of Defense is bugged in 1.14.1. The formula on CharSheetI!BA18 references a cell AJ14 on Class Overview (which is also named "Implement") but which is blank even after selecting Staff of Defense on Character Basics. Workaround is to just give yourself +1 (additional) on your armor, even if you're only wearing cloth.
Additional bugs: Actionpoint not one word in English (Initiative card). InitiativeCard does not use OrRace correctly.
Additional additional bug: Jack of all Trades is bugged. Change skills!AA10 to =MAX(S10:Z10) and fill the formula down. (This is in a hidden column if you're doing this at home ).
Additional gripe: It's still practically impossible to add a complete new custom race, even if that race is 90% recycled from an existing race. This could be fixed, but it would require a massive amount of work. I plan to do this as soon as you stop releasing new versions every other day, but it's going to take a week or two and will probably have a ton of bugs. I had hoped you would fix it yourselves for this version because you know the sheet far better than I do, despite all my hacking. This sheet is just going to implode sooner or later if you keep the current format for race/class and keep adding them with every splat... you won't be able to read the formulas you have to debug when a feat doesn't work, etc.
Last edited by infocynic; 14th August 2008 at 10:10 PM..
Reason: Finding more bugs
My Excel hacking is pretty limited, but I do know some basic stuff about it. I got to thinking about the "import/export" problem (the lack of being able to do it), and thought that maybe there should be an import export tab at the bottom.
The export tab would basically be a single column which would include all the basics:
Elf
Warlord
Tactical Pressence
18
14
16
ECT...
Which you could then just highlight the entire column and place it into the "import" tab of the new updated Version XX.X sheet. I'm not sure if you'd have to use a macro to pull all the data back into the sheet, but it seems that this would be a very quick and easy way for an end user to import and export data. If i'm wrong and this is a huge pain in the a$$, then i apologize for not doing my due research. ;-)
As far as the sheet goes, I'm extremly impressed with it despite known bugs. I'm starting a campaign with 5 of my friends (2 girls who have never played before!), and I think this sheet with "power" features will make things much easier for the newbs to understand how the game works. As soon as funds become available I'll try to drop a small donation your way, but as it stands now i'm poor and I would rather eat dinner. Keep up the good work!
Version 1.15: RELEASED 08-15-08 New features:
- Added "Alchimist" feat option
- Added "Formula" tab for alchimists
- Added Rituals from FRCS (they are evil, but hey, you never know where your path will lead you to...) Design changes:
- To make it work for Excel users with version older than 2007 we seperated the main file into two smaller ones
- removed gender selection
- Errata: Brew Potion is now a level 1 ritual Bug fixes:
- Spelling issues
- Feat: "Jack of all trades" fixed
- class features show correctly on char sheet 2 again
- Armor check penalty is not transported correcty to the pro sheet for the custom skill
- Swordmage class fixed
- Eladrins get their racial bonus to dex again
- Wizards have their correct weapon proficiency shown on charsheet 2
- Warlord weapon prof. fixed
- Wizard's "Staff of Defense" now works as intended
- Race Override is now shown correctly on the Inicard
- Damage on the Pro sheet now works as intended: Write ydx (i.e. "2d6" or "1d8" if you want it to show the exact dice, or write y[W] (i.e. "1[W]) if you want to be flexible to use different weapons with your powers, which is the recommended method)
- fixed Misc Bonuses for attacks
- the Power Time selection is no longer locked on the Prosheet
Download now on the heroforge site...
__________________ Matthias Schäfer
Living Forgotten Realms Regional Admin Northern Europe (Dalelands)
Wiesbaden Charsheet Team
Last edited by Amurayi; 15th August 2008 at 04:36 PM..
How about adding a set of custom class and race fields to the custom tab. That way any home brew material would be playable. I like the custom power/feat/class features/race featues entries on the custom tab, but you have to select a class and race in the character basics tab, and that comes with a whole bunch of game mechanics that you may not want. Adding custom races and classes fields to the custom tab could be a solution.
Great work. This is the best sheet there is, and so far seems to be getting a ton of support from you guys.
__________________
Sig
The Wisdom of Hong
I am starting to think that I should apprentice to Hong. Then some day I could be a Disciple of Hong!
"3E philosophy: the rules are a framework for building the world. Where this conflicts with gaming needs, houserule or handwave.
4E philosophy: the rules are a framework for running the game. Where this conflicts with world building needs, houserule or handwave.
If you spend more time running a game than world building, this is a net gain." - Hong
3E simulates the model of reality that 3E players have built in their heads. 4E fails to do this. Therefore, 3E is more realistic than 4E.-Hong
One small bug so far, just a typo probably. On the pro sheet, the damage for the 3rd power is wrong (the first one after the basic attacks). You have to replace J with I everywhere in the formula. This is in the XPversion at least, I can't check the full version right now.
if you pick genasi, watersoul as your race, then all the language selections become "#NA"
Note: this is for the split sheet, and I'm using Excel 2003. Your mileage may vary.
Unprotect the Basics sheet. On the Tools -> Options menu, check the "Row and Column Headers" checkbox. Now unhide the columns between Y and BI. In cells AH2 through AH11, change $Z$21 to $AE$21. Now hide columns Z through BH, uncheck the checkbox, and protect the sheet.
I've built a human fighter, takeing Tide of Iron as the bonus At-Will power. This power is not offered in the Choose Power drop-down on the Attacks sheet.
Charles, who is playing an LFR game this weekend and needs a fixed compatible version...
Charles, with bated breath...
I had hoped you would fix it yourselves for this version because you know the sheet far better than I do, despite all my hacking. This sheet is just going to implode sooner or later if you keep the current format for race/class and keep adding them with every splat... you won't be able to read the formulas you have to debug when a feat doesn't work, etc.
Version 1.15: RELEASED 08-15-08
Linear Mode
And yet another word from our sponsors
