Go Back   EN World D&D / RPG News

View Single Post
Old 13th August 2008, 10:19 PM   #55 (permalink)
Obryn
Registered User
 
Obryn's Avatar
 
Join Date: May 2003
Location: Normal, IL
Posts: 2,995
Obryn Bugbear Strangler (Lvl 6)
Send a message via ICQ to Obryn Send a message via AIM to Obryn
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 View Post
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..
Obryn is offline   Reply With Quote
 

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 10:03 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.

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