Hey all
One thing I thought was missing from Cliffs was a career tracker for my pilots, so i made one using excel and thought I'd share it with the community. Very keen to hear your thoughts re any enhancements/modifications etc.
This is an excel file that you run outside of cliffs, with the idea being that you enter the results of your flight sessions after each gaming session online (could be used for single player i guess but intended for online). Key criteria which you enter include the number of sorties you flew, your start and finish times, how many kills you achieved, and the outcome of your sorties - ie did you land safely at the end.
This is designed to be one pilot for one life - ie if you die, your pilot is then killed and you would start again with a new pilot and a new tracker file.
So far it's really changed the way i fly - once you have a pilot with 25 kills and 10 hours flight experience, you really start to care about the outcome of every sortie!
(I should note that i tend to fly more tactical sorties with my squad as opposed to "air-quake").
Features:
- Dynamic career tracker based on excel database which tracks your flights/kills etc.
- Commendations/medals/rank progression as you gain experience.
- A tool for generating random outcomes should your pilot bail out over the channel or over France so you can work out whether your precious pilot lived to fight another day!
- drop down menus and auto-fill forms to speed up data entry.
- RAF ranks and medals awarded based on your achievements.
KNOWN LIMITATIONS
This is based on RAF (actually RAAF as I'm in Aussie) but i could easily adapt for German pilots as well if there is any interest?
DOWNLOAD LINK: http://www.savefile.com/dl/HGV8A95L
EDIT: - V1.1 uploaded (link above updated to new file) - found a few bugs caused by the protection on some of the worksheets - FIXED.
NOTES: You need to enable content and Macros on your excel in order for this to work. Also I have entered a first entry into the log as an example as to how to fill out the log - of course you will want to delete this entry before starting your pilot's career!
It has been designed so that you fill in a log entry after each game session (rather than each sortie) but you do need to keep track of how many sorties you fly. I keep a pen and paper next to me when i fly and just jot down the start time of my game session, the finish time, and how many kills i get as it can be tough to remember these things after an hour or so of intense dogfighting!
I also recommend only recording kills you can confirm like in WW2 - I dont trust the stat tracker in Cliffs! I assign half kills if i share it - so if my wingman and i both shoot down a HE111, I will give myself 0.5 kills.
All feedback welcome!
-