Go Back   EN World D&D / RPG News > D&D 4th Edition Discussion > 4e Fan Creations and House Rules

4e Fan Creations and House Rules Working on variant powers? Statting up a PC race or your version of a monster? Creating or converting an adventure? Put it here!

 
Share LinkBack (3) Thread Tools Display Modes
Old 10th November 2008, 06:06 AM   #261 (permalink)
Registered User
 
Join Date: Jun 2008
Posts: 8
Callindril Goblin Sharpshooter (Lvl 2)
Quote:
Originally Posted by Amurayi View Post

We are currently finetuning the Prosheet again. We want it to work like this:
If you enter [W] as damage in the attacks tab it ignores the weapon specfifc damage and only lists damage the power gives (thus ignoring magic enhancement bonuses etc.)
If you enter a damage dice (i.e. 1d12) as damage in teh attacks tab the power adds up all bonuses from the weapon you designated as well (incl. magic enhancement bonuses etc.)
While this sounds like an excellent way of handling the ProSheet for everyone, in the 1.17_Full version, it isnt doing it...

If I have a power with damage of 1d8 in the attack set, it stil does not add the Weapon Focus bonus and the magic weapon bonus to the ProSheet as in the Regular sheet.

Regular sheet shows 1d8+7 (+4 Str, +1 Weapon Focus, +2 Long Sword).
Pro Sheet shows 1d8 + 4 (+4 Str, ignoring the Weapon Focus and +2 Long Sword).

Last edited by Callindril; 10th November 2008 at 06:21 AM..
Callindril is offline   Reply With Quote
Old 10th November 2008, 06:14 AM   #262 (permalink)
Registered User
 
Join Date: Jun 2008
Posts: 8
Callindril Goblin Sharpshooter (Lvl 2)
Powers 6-12 Dont calculate damage correctly

Using 1.17_Full, and when entering data into the extra Power slots (6-12), they dont seem to be calculating the damage right...

I can enter the same data in say Power 5 and Power 6 as a test, and get different final Damage values...

Seems to be 1 off...

For example, my paladin has Holy Strike...

In power Slot 1, Damage ends up being 1d8+7, Crit damage is 15+2d6
In power Slot 6, Damage ends up being 1d8+6, Crit damage is 14+2d6

Seems slots 7-12 have the same issue as Slot 6....

Same result if I use 1[W] instead of 1d8 as well...
Callindril is offline   Reply With Quote
Old 10th November 2008, 01:03 PM   #263 (permalink)
Registered User
 
elandy's Avatar
 
Join Date: Jun 2008
Posts: 19
elandy Goblin Sharpshooter (Lvl 2)
Quote:
Originally Posted by Callindril View Post
While this sounds like an excellent way of handling the ProSheet for everyone, in the 1.17_Full version, it isnt doing it...

If I have a power with damage of 1d8 in the attack set, it stil does not add the Weapon Focus bonus and the magic weapon bonus to the ProSheet as in the Regular sheet.

Regular sheet shows 1d8+7 (+4 Str, +1 Weapon Focus, +2 Long Sword).
Pro Sheet shows 1d8 + 4 (+4 Str, ignoring the Weapon Focus and +2 Long Sword).
Look at the "Base Attack Bonuses / Weapons" part. There it should be the damag you are missing, because it is damage associated with that specific weapon. It should be dispalying +X 1d8 + 3 in the "Base Attack Bonuses / Weapons" part, and 1[w] + 4 (or 1d8 + 4 in your case) in the "Powers" part. This was made like this, so you can add them toghether and calculate easily the damage of your powers with different weapons (that's why all damaga related to the weapon is appart form the damage related to the power).
Sure, if you only attack with one weapon, this isn't the best way to show damage, but with multiple-weapon characters it's a good thing.

Quote:
Originally Posted by Callindril
Using 1.17_Full, and when entering data into the extra Power slots (6-12), they dont seem to be calculating the damage right...

I can enter the same data in say Power 5 and Power 6 as a test, and get different final Damage values...

Seems to be 1 off...

For example, my paladin has Holy Strike...

In power Slot 1, Damage ends up being 1d8+7, Crit damage is 15+2d6
In power Slot 6, Damage ends up being 1d8+6, Crit damage is 14+2d6

Seems slots 7-12 have the same issue as Slot 6....

Same result if I use 1[W] instead of 1d8 as well...
I posted the solution here, some posts ago. Let me know if you need help with this.

Andy.-
elandy is offline   Reply With Quote
Old 11th November 2008, 05:05 AM   #264 (permalink)
Registered User
 
Join Date: Jun 2008
Posts: 8
Callindril Goblin Sharpshooter (Lvl 2)
Saw your post on how to fix that, but Im not an excel guy in any way shape or form....Running this in Excel 2007, but have no clue on where to even find the cells you were talking about, let alone change them...

I have no trouble waiting till an 'official' version is done with the fixes, just wanted to bring it to the attention of the authors of this great utility.

As far as the ProSheet, if the authors can make it work as they posted (1[w] vs 1d8) that would solve the issue for all concerned....Just hopping they can follow thru with that. In the midst of combat, its nice to see a list of all the powers avilabale (wel 12 of them anyway) and at a quick glance do the calucaltions for damamge instead of having to look multiple places on the sheet...
Callindril is offline   Reply With Quote
Old 11th November 2008, 12:51 PM   #265 (permalink)
Registered User
 
Join Date: Nov 2008
Location: Seattle, WA
Posts: 33
eleventh Kobold Slinger (Lvl 1)
My sheet is computing my hit points incorrectly. As a level 6 warlock, I should have [(12 hp)+(constitution score)]+[(5 hp)*(5 level ups)]. And since my constitution score is 18, it should be [30]+[25] = 55 hp. However, it is displaying it at 47 for some reason.

Doing a little more searching, I realized that this error is due to my using the ability override. If I set the ability buy box to 18 for constitution, it computes correctly. This should probably be recoded in the following fashion:

If constitution override is not null, compute total hp using constitution override.
Else, compute total hp using constitution buy.
eleventh is offline   Reply With Quote
Old 12th November 2008, 05:23 PM   #266 (permalink)
Registered User
 
Join Date: Jun 2008
Posts: 1
Phydorex Goblin Sharpshooter (Lvl 2)
Damage bugs?

I have been making test characters using the sheet and I keep getting odd damage numbers when it auto calculates, its kinda driving me crazy, because either I am missing a rule about damage somewhere or sometimes the sheet just flat out calculates damage wrong

Example

Wizard, Level 11, WoST paragon, 22 Int,
+3 Longsword
Eldarin Soldier feat

Magic Missle should be 2d4+11, but it comes out 2d4+12
+2 Feat, +3 Enhance, +6 Ability, +1 ??????

Another good example was a brutal rogue
level 11, 22 str, Weapon focus, +3 weapon
basic attack was 1d6+14
+2 feat, +3 enhance, +6 Ability, +3 ?????????

Anyone else noticed this?
Phydorex is offline   Reply With Quote
Old 13th November 2008, 12:12 AM   #267 (permalink)
Registered User
 
Join Date: Feb 2008
Posts: 7
trayburn Goblin Sharpshooter (Lvl 2)
Great Tool

I just wanted to say thank you to the team that created this wonderful tool. I'm looking forward to future updates, specifically the inclusion of Barbarian.

As a subscriber to D&D Insider, I've tried the Character Builder beta, but to me the flexibility of this Excel spreadsheet wins the day.
trayburn is offline   Reply With Quote
Old 13th November 2008, 02:37 AM   #268 (permalink)
Registered User
 
elandy's Avatar
 
Join Date: Jun 2008
Posts: 19
elandy Goblin Sharpshooter (Lvl 2)
Quote:
Originally Posted by Phydorex View Post
I have been making test characters using the sheet and I keep getting odd damage numbers when it auto calculates, its kinda driving me crazy, because either I am missing a rule about damage somewhere or sometimes the sheet just flat out calculates damage wrong

Example

Wizard, Level 11, WoST paragon, 22 Int,
+3 Longsword
Eldarin Soldier feat

Magic Missle should be 2d4+11, but it comes out 2d4+12
+2 Feat, +3 Enhance, +6 Ability, +1 ??????

Another good example was a brutal rogue
level 11, 22 str, Weapon focus, +3 weapon
basic attack was 1d6+14
+2 feat, +3 enhance, +6 Ability, +3 ?????????

Anyone else noticed this?
The problem you are having here, in both cases, is the double count of the enhancement bonus bug. A fix for this was posted by xone01 here.
I'm not sure if Eladrin Soldier feat should work for WotST powers or not, but in either case that feat wasn't working as intended. A fix can be found in the same post as above.

Andy.-

Edit: I forgot to say that the problem with the double counting of the enhancement bonus is solved on version 1.17 [here], but if you have office 2003 or previous you won't be able to open it.

Last edited by elandy; 14th November 2008 at 02:20 PM..
elandy is offline   Reply With Quote
Old 14th November 2008, 08:36 PM   #269 (permalink)
Registered User
 
Join Date: Feb 2008
Posts: 147
Darkthorne Goblin Sharpshooter (Lvl 2)
Damage Bug 1.16 XP Version

It appears that it is doubling the enhancement bonus in regards to damage, Attack appears to be accurate however. Tested by incrasing the magic item bonus by 1 and watchedthe damage increase by 2
Thanks
__________________
4E Encounter Calculator
Darkthorne is offline   Reply With Quote
Old 16th November 2008, 04:18 AM   #270 (permalink)
Registered User
 
Mithreinmaethor's Avatar
 
Join Date: Sep 2006
Location: Wichita, KS
Posts: 178
Mithreinmaethor Goblin Sharpshooter (Lvl 2)
Does anyone else have any problems printing the 2 character sheets?

I print them and it cuts the last power of the sheet off and onto a 2nd sheet of paper.
__________________
"Ná Eru veria le, ná elenath dín síla erin rád o chuil lín."
Mithreinmaethor is offline   Reply With Quote
Old 16th November 2008, 06:09 AM   #271 (permalink)
Registered User
 
Join Date: Apr 2003
Posts: 46
Alphastream Goblin Sharpshooter (Lvl 2)
Quote:
Originally Posted by Mithreinmaethor View Post
Does anyone else have any problems printing the 2 character sheets?

I print them and it cuts the last power of the sheet off and onto a 2nd sheet of paper.
You can use the Fit To Page option to keep it on one page. Also, make sure your paper type/size is correct. (This is a German sheet, so you will want to switch from A4 to Letter if you are in the US and a couple of other countries).

Teos
Alphastream is offline   Reply With Quote
Old 19th November 2008, 12:10 AM   #272 (permalink)
Registered User
 
Mithreinmaethor's Avatar
 
Join Date: Sep 2006
Location: Wichita, KS
Posts: 178
Mithreinmaethor Goblin Sharpshooter (Lvl 2)
OK I guess I will be the 1st to say it. Martial power and the galdiator and barbarian stuff is out (as well as Minotaur I guess). So the next obvious question is is do the programmers have their copies And when can we expect a Beta
__________________
"Ná Eru veria le, ná elenath dín síla erin rád o chuil lín."
Mithreinmaethor is offline   Reply With Quote
Old 19th November 2008, 12:12 AM   #273 (permalink)
Registered User
 
Mithreinmaethor's Avatar
 
Join Date: Sep 2006
Location: Wichita, KS
Posts: 178
Mithreinmaethor Goblin Sharpshooter (Lvl 2)
Quote:
Originally Posted by Alphastream View Post
You can use the Fit To Page option to keep it on one page. Also, make sure your paper type/size is correct. (This is a German sheet, so you will want to switch from A4 to Letter if you are in the US and a couple of other countries).

Teos
Yeah I changed it from A4 to Letter and am using open office 3.0. I have looked everywhere for the Fit to Page option. And the printer I used for some reason doesnt have that in its options either. Stupid printer
__________________
"Ná Eru veria le, ná elenath dín síla erin rád o chuil lín."
Mithreinmaethor is offline   Reply With Quote
Old 19th November 2008, 04:53 AM   #274 (permalink)
Registered User
 
Join Date: Oct 2008
Posts: 7
koesherbacon Kobold Slinger (Lvl 1)
Quote:
Originally Posted by Mithreinmaethor View Post
OK I guess I will be the 1st to say it. Martial power and the galdiator and barbarian stuff is out (as well as Minotaur I guess). So the next obvious question is is do the programmers have their copies And when can we expect a Beta
Second! The stuff in Martial Power is pretty awesome, especially the Pole-Arm Master! I'd love a HF4e excel program that has all that information!

Unfortunately, I'm using OS X and I doubt I'd be proficient enough to help program the sheet! But, if I can be of any help, I'd be more than happy to do whatever I can!
koesherbacon is offline   Reply With Quote
Old 19th November 2008, 07:12 AM   #275 (permalink)
Registered User
 
Join Date: Apr 2003
Posts: 46
Alphastream Goblin Sharpshooter (Lvl 2)
Quote:
Originally Posted by Mithreinmaethor View Post
I have looked everywhere for the Fit to Page option. And the printer I used for some reason doesnt have that in its options either. Stupid printer
Page Setup. You can get there via Print Preview, which works well.

Teos
Alphastream is offline   Reply With Quote
Old 23rd November 2008, 08:26 AM   #276 (permalink)
Registered User
 
Join Date: Oct 2008
Posts: 7
koesherbacon Kobold Slinger (Lvl 1)
If you use excel for OS X, the "fit to page" option is available right in the print dialogue box!
koesherbacon is offline   Reply With Quote
Old 25th November 2008, 06:13 AM   #277 (permalink)
Registered User
 
Join Date: Jun 2008
Posts: 7
PhantomAOJ Goblin Sharpshooter (Lvl 2)
The 1.17XP version and the 1.17 Full appear to be the same file, just named differently.

Hopefully the next version, which I hope includes martial powers, will have the bugs fixed (and like ANY good program, create new ones)

But it is an excellent product! Especially for free. So please keep up the good work!
PhantomAOJ is offline   Reply With Quote
Old 25th November 2008, 08:00 PM   #278 (permalink)
Registered User
 
TheMarko's Avatar
 
Join Date: Nov 2008
Location: Kragujevac, Serbia
Posts: 12
TheMarko Kobold Slinger (Lvl 1)
I have got another problem, after I finish creating character, When viewing Character page one, I see enlarged D&D logo (covering the name of player) and warlord initiative bonus not included. Any help on this?


I'm using Office 2007 on Win XP, and 1.17 sheet.

Thank You.
TheMarko is offline   Reply With Quote
Old 25th November 2008, 10:44 PM   #279 (permalink)
Registered User
 
Kralin Thornberry's Avatar
 
Join Date: Jun 2004
Location: Ft. Myers, FL
Posts: 292
Kralin Thornberry Goblin Sharpshooter (Lvl 2)
Send a message via AIM to Kralin Thornberry Send a message via MSN to Kralin Thornberry Send a message via Yahoo to Kralin Thornberry
Quote:
Originally Posted by TheMarko View Post
I have got another problem, after I finish creating character, When viewing Character page one, I see enlarged D&D logo (covering the name of player) and warlord initiative bonus not included. Any help on this?


I'm using Office 2007 on Win XP, and 1.17 sheet.

Thank You.
It all works out when you print it out.
__________________
Run when you have to, fight when you must, rest when you can.
Kralin Thornberry is offline   Reply With Quote
Old 26th November 2008, 09:29 PM   #280 (permalink)
Registered User
 
TheMarko's Avatar
 
Join Date: Nov 2008
Location: Kragujevac, Serbia
Posts: 12
TheMarko Kobold Slinger (Lvl 1)
Warlord Initiative bonus is still not included . . . even after I print it . . . I add Misc bonus +2, as a workaround, but this needs to be repaired.
TheMarko is offline   Reply With Quote


Bookmarks

Tags
"wiesbaden, charactersheet", dynamic, excel

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


LinkBacks (?)
LinkBack to this Thread: http://www.enworld.org/forum/4e-fan-creations-house-rules/238277-dynamic-excel-wiesbaden-charactersheet.html
Posted By For Type Date
D&D 4E Files Post #0 Refback 12th September 2008 08:47 PM
Alan’s Game » Electronic Resources This thread Refback 10th September 2008 04:53 AM
D&D 4E Files Post #0 Refback 3rd September 2008 12:44 AM

And yet another word from our sponsors
Visit Our Sponsors
Visit Our Sponsors... Again
Powered by vBadvanced CMPS v3.0.1

All times are GMT +1. The time now is 02:59 PM.


Site Contents © 2008 ENWorld
PHP Ajax Multimedia Web Framework © 2008 Digital Media Graphix
Powered by vBulletin® Version 3.8.0 Beta 1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0

"Vault Data" powered by VaultWiki v2.5.1.
Copyright © 2008 - 2009, Cracked Egg Studios.