#515 Weapon Size Chart

[Matthew 'Janack']

Not sure if this has been brought up, when selecting the weapon size from the drop down menue if you select Colossal you get a #Ref! error in the damage box as well as the Bonus box. I tried to trace the error, so far as I can tell its looking for a SizeIndex value of 5. If I'm reading formula right it is looking for a value outside of the table. I'm having a hard time trying to read all the different cell references and I can't make heads or tails of it yet.

Hope this doesn't create more of a headache then most bugs.

[thebluecanary]

Which weapon box did you try this on? I did not get it to repeat.

[Matthew 'Janack']

Level 18 Titan Mauler Barbarian : STR 24

Weapon Box 1:
Greataxe
Size: Colossal
Use: Two-Handed
Use: Auto
Weapon Quality: Normal
Ammo Quality: Normal
Special Material: None

Name: Greataxe
Bonus: #Ref!
Damage: #Ref!
Critical: 20/x3
Range: -
Weight: 144 lbs
Type: Slashing
Size: Colossal
Props: #Ref!
Cost: 320 gp

[thebluecanary]

How big are you? What is your size?

[Matthew 'Janack']

Half-Orc Medium size

[thebluecanary]

OK. You can't use a colossal weapon, but I'll see what I can do.

[Matthew 'Janack']

I was just trying to figure it out the damage if I were to Enlarge a Titan Mauler, give him an Impact Gargantuan Greataxe. Thanks for looking into it.

R/

Matt

[Philip]

Hey Adam,

to reproduce take a two-handed weapon and set size to colossal. I think this happens because the weapon size index calculated in LittleBox!AI287 is larger than 9.

FIX :

• Change LittleBox!AM287 to

  =IF(O287="Siege";"Two-handed";IF(AI287<1;"Weapon Too Small";IF(AI287>9;"Weapon Too Large";IF(INDEX(Engine!$P$783:$X$791;AI287;SizeIndex)="Light";"One-handed";INDEX(Engine!$P$783:$X$791;AI287;SizeIndex)))))

and dublicate for other weapons...

[thebluecanary]

I'll have this corrected in the next update.