From: Berlin, Germany
A lot of good resources on this forum are scattered over many threads. Here I would like to share a collection of the ones I have found to be the most helpful, next to some I have made for my own use.
Documents were uploaded to my GDrive account and I will link them here.
If you know any WitE-documents not yet uploaded here (or would like to share some documents you have made for your own use), please PM or E-Mail me over my userpage here!
1.1 WitE Operational Boot Camp (by dlazov66): A boot camp for new players to complement the manual.
1.2 WitE Best of Forum Posts (by governato): A collection of many good forum posts. Somewhat outdated, but still helpful.
1.3 How Supply works (by EwaldvonKleist): A document about HQ build ups, supply optimisation, the leader roll system and some more stuff. It is a comprehension of information from the manual, own tests and forum posts.
1.4 German OOB as a Word document (by SuluSea): A document summarizing the OOB for the 1941GC with division's morale and all leaders.
1.5 The supply system in WitE 1-an in detail explanation. (by EwaldvonKleist) A document that explains the supply system of WitE in detail with all important formulas.
1.6 Basic player's guide (by thedoctorking) Play tips for people doing their first steps into the game.
1.7 Checklist/turn processing order (by EwaldvonKleist) A checklist I made for my own use to streamline my play of Axis turns. Note that the checklist only concerns the early Axis turns, for defensive play, changeds are in order.
1.8 Axis team protocol (by Telemecus) Protocol of the Axis turn handling for team (more than one player per side) games.
2.1 Planning map (by ?): The complete WitE map as a high resolution image.
2.2 Historical frontlines map (by Goranw): The frontlines of 1941 and 1942 drawn on the planning map to compare your results with history.
2.3 Railway map (by EwaldvonKleist): A map showing an optimised rail strategy step by step. Thanks to HLYA making me look into this. The coloured arrows show the final position of each FBD at the end of the turn. The rail repair in the South will slightly speed up witht he extra Romanian FBD. The railway path is shown up to turn 5. After this point, the railway construction has to be adapted to the situation.
3. AARs: Some AARs I have found to be especially interesting from a teaching point of view.
3.1 Dinglir: Lessons on the airwar: Soviet side I and II.
3.2 Hardluckyetagain: Strategy AARs for the Axis and the Soviet side.
3.3 MichealT: Axis and Soviet side.
3.4 Pelton: Pelton has written an AAR-guide for German players which can be downloaded here.
Descriptions for the spreadsheets can be found below.
4.1 Axis air groups tracker and Soviet aircraft tracker v2.0 (by Telemecus) Trackers for the axis air groups and the soviet overall aircraft numbers. Feedback/reports on possible inaccuracies will be appreciated by Telemecus, please PM or E-Mail him if you have found something!
4.2 OOB tracker for the Axis side (by ledo) A spreadsheet to track the Axis OOB in detail.
4.3 Statistics tracker (by fetmun) detailed and highly automatised statistics tracker, generating lovely charts.
4.4 Soviet vehicle tracker (by Telemecus) Detailed tracker for Soviet ground vehicle (AFC, SP guns, Rocket launchers, trucks etc.) production. Feedback/reports on possible inaccuracies will be appreciated by Telemecus, please PM or E-Mail him if you have found something!
4.5 Leader selection aid for the Axis and Soviet side.
5.1 Red Army 2.0: Would be a good title for a horror movie.
5.2 Evolution of the Ants
If you know the authors of some of the documents please PM me so everyone gets the credit he deserves.
Here you can find further explanations for some of the spreadsheets.
re 4.2: (by ledo)
Things that need to be changed manually:
Make sure to change the date in the the basic setup. Currently this is the check to see which air models are out of date. If you keep mine (Jun-41) you might not get an accurate reading for your own data.
You need to import the unit tables from the commander's report and then copy paste them into the raw data worksheets in exactly the same format. Also copy paste the unit data into the Ground Force OOB Support Calc work sheet exactly the same way, including only "Type" "Name and "HQ Name" columns in the exact same order.
Moving units around in your OOB. You have remove and add rows to make room and then drag down all the formula columns. Remember that there are hidden columns so expand those if something isn't working. This includes breaking down and building back up a division. If you see an error next to a division try adding 1/ in front of it and it will probably fix it. You'll then have to add two rows and input 2/ and 3/. Eventually I'll try automate this as is done in the Air Force worksheet. Ground force leaders and support levels will change automatically. OKH sometimes bugs out though, if it does copy paste the word OKH from the raw data and replace every mention of OKH in the Ground Force OOB sheet (including hidden cells), there should be 5, i think.
One of the hidden columns in the Ground OOB is the Support Level Modifier this includes the chance of commitment as per the manual. This is always 1 for a division. At the corps level you will see a denominator of 10, 20 for army level, 40 for army group and 80 for O.K.H. If uncertain always copy a formula from the exact same type of HQ or unit.
If you have more than 8 air wings in an air base you will have to unhide all cells, add additional rows to the air base and make sure the 1-8 numbers in cells A:A extend down to however many number of air wings you wish the worksheet to find.
re 4.3: (by terry1040)
I struggled a little bit making it work for me.
So here is my detailed way how I got it running with my CG.
Start with Downloading the Excel-Sheet via the Link provided.
#### Open and Understand the file structure####
1) Open the File in Excel. The first 2 Tabs "Production" and "Global Stat" are for the analytics. Here you will do your interactive reporting.However to prepare this for your game, you first need to import the data onto Tab 3.
2) Switch to Tab 3 "raw date"
3) Zoom In !!! (:-)
4) The first column A is the turn number. Do not touch this column.
5) The first line contains headers. Do not touch the first line.
6) The file already come with 5 Turn of sample data (about 14000+Lines!!!). You do not need that and must delete it to make things work for your game.
#### Deleting the current data sample ####
7) Select Field B2. Mark the row across until you reach AK2, just before the orange column. Do not mark the orange part or beyond. Do not touch anything beyond AK2.
8) Continue to mark all fields downwards until you reach Line 14036 (orange).
9) Delete the content of all marked fields, i.e. all the data samples.
#### Entering your data ####
10) Export the file from WitE from the commanders report
11) You will find the resulting file in the Save-Folder in your local WitE-Installation-Folder (../dat/save/)
12) Open the resulting CSV-File (e.g. "Stats(Turn 001 1941-07-10 Ax).csv") with your Text-Editor (in my case Notepad).
13) Select all data and copy it within the Text-Editor into your Clipboard.
14) Switch to your Excel-Sheet again. On Tab3 select Field B2.
15) Past the clipboard data into the Excel-Sheet
#### Cleaning the Excel-Sheet ####
16) Scroll down until you see the end of your inserted data.
17) Select the Last row of your data and mark the whole row with a color of choice (I used green).
18) Check Column A. All your data must be preceeded by the right turnnumber. If this is not the case, correct the turnnumber so that it is consistent in column A for all your inserted data, e.g. 1.
19) Select the next Row below your last dataset. It should start with the next turn number, e.g. 2. This is where you will past your next export file. For example for Turn 2.
20) The Excel-File currently contain enough lines for about 5 Turns. If you run out of line, you need to insert additional ones for turns 6 and beyond.
21) Make sure you do not touch the bottom part of the file. It also contains some formulars to ensure the analytics work. You easily recognize this as it has a different structure.
< Message edited by EwaldvonKleist -- 6/22/2018 4:12:44 PM >