UPDATED! See THIS POST
So I finally got around to updating that spreadsheet I said I was going to make available like.. 7 months ago
Some folks mentioned it might be useful.
Edit: Was having problems with the Google links.. should be public now
I originally made it as an easy reference to see how many planes and of which type I had available for playing in any given era for solo games (with the added bonus of tracking what I actually own), but it could have other uses.
I divided each year into quarters (1916/Q1, 1916/Q2, etc.). The aircraft availability is based on when the airplane was used in combat roles (that is, deployed to active duty squadrons on the front or otherwise used in a combat capacity). I did not include time when the planes may have only been used for training or other non-combat related duties. Some aircraft also didn't have info available so there may be a bit of guesswork with the availability.
Also, at the moment, I've only included Ares models on here. The planes are listed in order by series.
There are 4 tabs at the bottom of the spreadsheet:
'Central' and 'Entente' are where you enter how many planes you have in the "Inventory" column:
You can also add whatever else you want to the "Notes" column or pretty much any other cell on these pages. Only column "B" is referenced.
On the "Availability Matrix" tab you can see the overlapping bars and numerical count of what's available for each given quarter. This sheet is entirely referenced, so you don't need to add anything on it.
Link to Google Docs file.
There was an earlier request for an .ods version -this is a direct export from Google Docs. It's functional but not pretty.
Let me know what you guys think, if it's useful or not, what changes you want to see, etc. Consider this one an "early version" work in progress.
Bookmarks