Announcing the latest, and hopefully best, version of the crew calculator to date.
As old timers here know long ago I created a crew size calculator for the members here. It was conceived because many on here did not realize just how big the crews of their ships needed to be. It was well received but had several issues, all of which I have since worked out over the various iterations. This latest version features fully function circular references and notes on how to use it embedded into it. It also has several generic size charts based on ship class to give you an idea of where to start. Anyway enjoy, and you will need excel in order to run it, or use the spreadsheet program in open office. If you have any questions on how to use it feel free to ask.
This latest version adds the following enhancements:
1) Two mini-calculators have been added to each page. These are to allow more accurate numbers to be generated for the air wing and gunners, and to provide a better breakdown of said groups.
2) A new example/usage tab has been added for Cutters, small craft that do not stay out for long durations, this might also be helpful for near future in system type craft.
3) The corvette tab example has been cleaned up and had numerous crew position removed/consolidated.
I offer this for free and hope it is as well recieved as it has been in the past. I only ask that credit be given when it is used and that you post any comments, suggestions, or changes you make to it here so that I can incorporate them in a future version.
I am also working on strictly civilian, transport, and scientific tab for future versions, but those will require major revisions.
To use, simply unzip, open in excel or open office, and follow the instructions on the manual tab to determine the number of crew to add. Several spots are autofilled, and can be adjusted if you so desire.
Newest revision is now attached, changes notes below.