Talk:Damage Calculator/@comment-15871805-20130830135951/@comment-11753608-20130830150458

Had a thought about our conversation about the Hitscan, Projectile 1, Projectile 2, etc. issue. A way to do this without rewriting the whole weapon table would be to do the following:

1.  Create a 4th Sheet and name it w/e.

2.  Move the Weapon Attack Style Statistics table to that page.

3.  On that page create an separate attack styles list using the typical laymans nomenclature:  "Normal, Charged, Projectile AOE/OgrisAOE, Jump, SLide, Wall, Ground, Slam"  This could happen just in a column of cells anywhere on the sheet.

4.  Have the Attack Style Datavalidation in B3 reference the layman's nomenclature list rather than the first row of the table.

5.  Have the Base Damage (cell B3) do something like:

IF(B3="Normal", IF(HLOOKUP("Hitscan",$B$24:$L$29 ,MATCH(ʺBase Damageʺ,$A$24:$A$29 ,0),FALSE)>0, HLOOKUP("Hitscan",$B$24:$L$29 ,MATCH(ʺBase Damageʺ,$A$24:$A$29 ,0),FALSE), IF(HLOOKUP("Projectile 1",$B$24:$L$29 ,MATCH(ʺBase Damageʺ,$A$24:$A$29 ,0),FALSE)>0, HLOOKUP("Projectile 1",$B$24:$L$29 ,MATCH(ʺBase Damageʺ,$A$24:$A$29 ,0),FALSE) etc...

and daisy chain IF checks for it to find which of the 3 columns its "normal" attack occurs in - Hitscan, Projectile 1 or Melee.

You could then repeat this process for "Charged" attack and IF check "Projectile 2" and "Heavy."

This makes cell B3 a huge forumla, but it allows us to make the Attack Styles menu the way we wanted, remove the Weapon Atack Styles from the main page, and keep the database exactly as it is - which is much more of a pain in the ass to edit than cell B3.

I am going to test it on excel, and it if works update your calculator. If you don't like the result, I will leave a note here regarding the last previous update so you can reload it back the way you have it now.