|
Post by resonance378 on Dec 5, 2006 22:37:32 GMT
Kneverwynter:
I still suggest we work to get rid of null values and this might start to remove problems. IE: Put 0's in where they should be (such as the no-change values in the abilities page).
|
|
|
Post by resonance378 on Dec 6, 2006 18:32:01 GMT
Ok some more information:
W4 - AB4 refer to this formula: =IF(Race!$A$1>0,VALUE(INDEX(Race!$A$24:$HN$24,1,Race!$A$1)),0)
For the appropriate Ability column. Believe HN should be IV as HN is Malephant (Elf)
Errant formula in Race W35. Know what it's for?
If you have Excel 2003 Pro, run the bugger through the error trace, it certainly is helping me find a lot of stuff referring to empty cells etc.
|
|
|
Post by terroken on Dec 11, 2006 14:20:37 GMT
Phal pointed out the bonus feat for humans wasnt there on subraces lol oooops, and fixed, thanx bud. Here is new link www.box.net/public/d7l68nctoo
|
|
|
Post by resonance378 on Dec 11, 2006 18:49:10 GMT
1) You can have 33k selections in a drop down but only 256 columns? could that be the issue... given that IV is 256 = 9 * 26 + position of V ??
In an earlier post you stated that when adding a race don't use parenthesis, but when you added the new races you used parenthesis.
Race!(B:HN) = 221 selections (dont know if that # helps at all)
Could this be your issue?
2) Favored class selections are not wrong in the race sheet, they should refer to a formula (see original races that have favored classes )
3) Hidden Columns on Character!AS1-24 updated from Race!...:$HN reference to Race!...:$IU reference
[Am updating to HN references to IU with little luck]
|
|
|
Post by terroken2 on Mar 12, 2007 13:08:38 GMT
Please delete this Post too starting a fresh one with the Newest CBC and hopefully will only have to tweak in future.
TYTY
|
|