Addon for CloD - Pilot career tracker with ranks/medals etc

[ReconNZ]

EDIT: 28 September: RAF Pilot Career Tracker Version 2.0 uploaded

Change Log:

- Completely redesigned the 'Downed Pilot Outcome Generator' - it now dynamically generates outcomes for you. (same as the version with the luftwaffe pilot tracker)
- Added support for custom Squadrons - you can now enter your own virtual or historic squadrons
- improved examples on the log book page and added a button to easily delete all the examples when you are ready to use the tracker. (please not some fields in the examples such as "start" and "finish" times are intentionally left blank so they wouldn't trigger any of the ranks/medals - you should of course fill these in when you log your own flights)

New download locations:


RAF Pilot Tracker Version 2.0: http://www.savefile.com/dl/LHSQRBKV or http://airwarfare.com/sow/index.php?...tid=18&cid=151

Luftwaffe Pilot Tracker Version 2.0: http://www.savefile.com/dl/26W4FG9Q or http://airwarfare.com/sow/index.php?...tid=18&cid=148



Royal Australian Airforce Version 1.0: http://www.savefile.com/dl/HGV8A95L




__________________________________________________ __________________________________________________ __________________________________________________ ____________


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). It's designed to be very quick and easy to enter the data with key criteria including 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 virtual "life" - ie if you die in game, 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 dynamically throughout your career based on your achievements.

- RAF, RAAF and Luftwaffe versions



NOTES: You need to enable content and Macros on your excel in order for this to work. Also I have entered a couple of initial entries into the log as an example as to how to fill out the log - of course you will want to delete these entries 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), or when you change aircraft. You will need to keep track of how many sorties you fly in each gaming session. 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!


PS - A huge thanks to JG54Spookie for his medals images for the Luftwaffe version from Mission4today.com (great site) - thanks also to Gamekeeper for suggesting them - that saved me heaps of time!
-

[ReconNZ]

Yeah it's an outside the game thing - you need a copy of Excel to run it.

(I'd love to be smart enough to build a mod to incorporate it into the game, that is though rather far beyond my skill set!)

[adonys]

[Foo'bar]

Originally Posted by ReconNZ

Yeah it's an outside the game thing - you need a copy of Excel to run it.

Wouldn't be a copy of Open Office Calc enough?

[ReconNZ]

I'm not familiar with open office sorry - I know though that if you dont have excel Microsoft are doing free 60 day trials of Office which includes Excel, so you can at least get it for 60 days to give it a go.

[ReconNZ]

Hey all, I've been asked if there is any chance of doing a German version of this. Happy to do so if there is any interest, so perhaps post here or pm me if you'd be interested in a German career/stat tracker.

[kiwikillemoff]

Do it. Loving your RAF (RAAF) one. Totaly changed the way I approach each flight. I fly better, land better and most of all I survive more.

Good job there mate

[_RAAF_Furball]

I can attest to the random number generator is now working after enabling the "Analysis ToolPak" Add-in as now included in 1st post.
@Foo'bar - Open Office should work.
__________

Very impressive work, mate - thank you for sharing it - love the background "parchment".

[bw_wolverine]

I'm having trouble getting that site to send me the file. Maybe cause I'm using Internet Explorer 9. Any other way to grab it?

[Foo'bar]

Originally Posted by _RAAF_Furball

@Foo'bar - Open Office should work.

Thanks