Addon to Titan/Weapon Table
Posted: Thu Sep 16, 2010 7:28 pm
Hi there!
I've used the titan excel sheet from Judge Omega a lot and added some functionality.
Also updated the data to build 60.
New features:
Skill Highlighter (Skills Tab)
Skill point calculator (Skills Tab)
Comparison numbers [dmg/sec; dmg/heat etc] (Weapons Tab)
Table with to hit modifier per range (Weapons Tab)
Defensive modifier per chassis (Chassis Tab)
I also added a sheet where you can assemble a Titan for design testing. It simulates the firing and recharging of energy weapons on a seperate sheet. This way you can get an estimate of the reduction (or increase) in firepower when changing the engine.
Yellow cells are input cells, don't change the rest or the formulas may stop working.
The macro in it is for the max button, which sets all armor to the max allowed for that specific chassis.
Armor calculations may sometimes be 1 pt off fr some reason.
Feel free to use it to optimize your titan designs.
Change the extension from .txt to .xlsm
I've used the titan excel sheet from Judge Omega a lot and added some functionality.
Also updated the data to build 60.
New features:
Skill Highlighter (Skills Tab)
Skill point calculator (Skills Tab)
Comparison numbers [dmg/sec; dmg/heat etc] (Weapons Tab)
Table with to hit modifier per range (Weapons Tab)
Defensive modifier per chassis (Chassis Tab)
I also added a sheet where you can assemble a Titan for design testing. It simulates the firing and recharging of energy weapons on a seperate sheet. This way you can get an estimate of the reduction (or increase) in firepower when changing the engine.
Yellow cells are input cells, don't change the rest or the formulas may stop working.
The macro in it is for the max button, which sets all armor to the max allowed for that specific chassis.
Armor calculations may sometimes be 1 pt off fr some reason.
Feel free to use it to optimize your titan designs.
Change the extension from .txt to .xlsm