Fleet and Defense Calculator
Posted: Thu Jan 14, 2010 3:52 am
This Excel Workbook consists of two tabs. One tab is for fleets, the other is for defenses. Both work by the user, you, entering in a quantity of ships or defenses and having the cost displayed to you. It's very simple to read and is easy use. Certain cells, or fields, have been locked so there is no accidental changing of functions, making it fool proof. I've even added a debris field calculator to the fleet tab to instantly calculate what the debris field would be if said ships were destroyed! Here are a few screens of what it looks like and how it works:
-Ships-
After input of quantities:
-Defenses-
After input of quantities:
----------
Not very flashy, but very straight forward. I plan on updating this with more calculations in the future, but I will wait and see on how popular this becomes. I will try to keep everything as simple as possible to avoid confusion so that even the novice player can use and understand my spreadsheets.
Please feel free to ask questions and make suggestions!
Downloads:
http://h1.ripway.com/DTze/ShipDefensesCalcv2.xlsx
http://h1.ripway.com/DTze/ShipDefensesCalcv203.xls - 97-2003 Excel
-Ships-




Not very flashy, but very straight forward. I plan on updating this with more calculations in the future, but I will wait and see on how popular this becomes. I will try to keep everything as simple as possible to avoid confusion so that even the novice player can use and understand my spreadsheets.
Please feel free to ask questions and make suggestions!
Downloads:
http://h1.ripway.com/DTze/ShipDefensesCalcv2.xlsx
http://h1.ripway.com/DTze/ShipDefensesCalcv203.xls - 97-2003 Excel