Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

The library of WitE resources

View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: Texas D
  Printable Version
All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's War in the East Series >> The War Room >> The library of WitE resources Page: [1]
Message << Older Topic   Newer Topic >>
The library of WitE resources - 7/20/2017 1:17:28 PM   

Posts: 856
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
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.

1. Documents

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.

2. Maps:
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 for the inspiration. 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 mktours: Axis side I and II
3.5 Pelton: Pelton has written an AAR-guide for German players which can be downloaded here.

4. Spreadsheets
Descriptions for the spreadsheets can be found below.
4.1 Axis air groups tracker and Soviet aircraft tracker (by Telemecus) Trackers for the axis air groups and the soviet overall aircraft numbers.
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!

5. Other stuff:
5.1 Red Army 2.0: Would be a good title for a horror movie.
5.2 Evolution of the Ants
Due to some RL issues I will have to leave the WitE crowd for some time so if you don't want one of your documents uploaded here please contact the admins.
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.

Enjoy :)

< Message edited by EwaldvonKleist -- 2/12/2018 8:03:14 PM >
Post #: 1
RE: Collection of good WitE resources - 7/20/2017 3:14:29 PM   
No idea


Posts: 380
Joined: 6/24/2011
Status: offline
Some admin, please, stick this.

(in reply to EwaldvonKleist)
Post #: 2
RE: Collection of good WitE resources - 8/16/2017 6:19:56 PM   


Posts: 243
Joined: 2/20/2007
Status: offline

Excellent set of resources - much appreciated


aka rocketman elsewhere

(in reply to No idea)
Post #: 3
RE: Collection of good WitE resources - 11/28/2017 4:03:39 PM   

Posts: 856
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Updated with the spreadsheets that recently came up and my explanations on the logistics.
Edit: Waiting for your air force guide telemecus :)

< Message edited by EwaldvonKleist -- 11/28/2017 4:06:11 PM >

(in reply to rocketboy)
Post #: 4
RE: Collection of good WitE resources - 11/28/2017 4:30:51 PM   


Posts: 49
Joined: 12/27/2016
From: France
Status: offline
Thank you very much for that, very, very helpful

< Message edited by Splatsch -- 11/28/2017 4:31:38 PM >

(in reply to EwaldvonKleist)
Post #: 5
RE: Collection of good WitE resources - 11/28/2017 6:05:02 PM   


Posts: 1002
Joined: 1/13/2015
Status: offline

(in reply to Splatsch)
Post #: 6
RE: Collection of good WitE resources - 2/11/2018 9:58:01 PM   

Posts: 856
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Another spreadsheet by Telemecus added for the tracking afficionados. The Soviet vehicle tracker (4.4) is a tool to track and calculate soviet AFV numbers.

(in reply to Twigster)
Post #: 7
RE: Collection of good WitE resources - 2/13/2018 2:26:32 AM   


Posts: 406
Joined: 4/29/2017
Status: offline
Question about the fetmun statistics tracker. I'm no kind of expert in Excel. Making the charts work is difficult. How do I change the columns it is looking at for the data? Is there some button to push or must I figure out how to edit the table directly?

(in reply to EwaldvonKleist)
Post #: 8
RE: Collection of good WitE resources - 2/13/2018 8:47:42 AM   

Posts: 856
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
this is the User page of fetten:
I am sure he is the best one to offer help, for his excel skills are beyond doubt.

(in reply to thedoctorking)
Post #: 9
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's War in the East Series >> The War Room >> The library of WitE resources Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI