Current Version: Beta1.1
This is a spreadsheet that is designed for KM BB users. With this, you can easily calculate the true ability of your entire crew. It also has a function where you can compare your crew to basically any combination of Elite reps/engis.
A few things: -You only need to make changes in the yellow/light yellow shaded cells on the "Entry" page. -There is no option for a restorer -There are 14 sailor slots, if you are making a sheet for an H44, then leave the last support slot on the page empty...if the sheet is for an H39, then leave the last 2 support slots blank. -Changing the name of a sailor in column B changes how the stats are calculated! For example, Row 5 by default is for AAW gunners. However, if you change cell B5 to "Repairer" - then it calculates a repairer in your T slot. I've added notes to help. -This sheet assumes that all sailors are boosted (for now) -It is very important to enter the correct numbers related to when your sailors were classed. If the number of recruits/vets/experts does not agree with the maximum number of sailors - then there is a problem (either with the sheet or your entries)
Try it out, if you find something that is broken; send me a PM and I'll fix it for the next version. This is a really early version and there are bound to be problems
Comments appreciated
Link (go to file => download as => excel file (version update 10/11/11 https://docs.google.com/spreadsheet/ccc?key=0AitnTo3KGUSpdFM4bEctSWM0cWIxMjAxNEh2cTFvZlE#gid=0
Edit - New link available via megaupload. Downloading from this source should ensure that the restrictions/drop down boxes remain intact. Google docs has some limitations that can't be worked around.
https://www.megaupload.com/?d=00PHQMTP
|