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: none
  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]
Login
Message << Older Topic   Newer Topic >>
The library of WitE resources - 7/20/2017 1:17:28 PM   
EwaldvonKleist


Posts: 1189
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.

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. 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.
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. 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 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.

4. Spreadsheets
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. Miscellaneous:
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.

Explanations:
Here you can find further explanations for some of the spreadsheets.
re 4.2: (by ledo)
quote:

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)
quote:

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 -- 6/22/2018 4:12:44 PM >
Post #: 1
RE: Collection of good WitE resources - 7/20/2017 3:14:29 PM   
No idea

 

Posts: 446
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   
rocketboy

 

Posts: 250
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   
EwaldvonKleist


Posts: 1189
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   
Splatsch

 

Posts: 61
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   
Twigster

 

Posts: 1014
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   
EwaldvonKleist


Posts: 1189
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   
thedoctorking


Posts: 678
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   
EwaldvonKleist


Posts: 1189
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Hi,
this is the User page of fetten: http://www.matrixgames.com/forums/showProfile.asp?memid=40210
I am sure he is the best one to offer help, for his excel skills are beyond doubt.

(in reply to thedoctorking)
Post #: 9
RE: Collection of good WitE resources - 3/22/2018 6:45:12 PM   
EwaldvonKleist


Posts: 1189
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Updated with the basic players guide by Thedoctorking.

(in reply to EwaldvonKleist)
Post #: 10
RE: Collection of good WitE resources - 4/22/2018 8:39:26 AM   
EwaldvonKleist


Posts: 1189
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Telemecus' Soviet aircraft tracker has been updated to v2.0f, making it more user friendly while improving accuracy, he appreciates all kind of feedback!

(in reply to EwaldvonKleist)
Post #: 11
RE: Collection of good WitE resources - 5/10/2018 12:16:59 PM   
EwaldvonKleist


Posts: 1189
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Does someone has a collection of WitE art mods or links where to find them? Maybe they can be included here as well.

_____________________________

Visit the Library of Gary Grigsby's War in the East resources!

"When a wargamer is tired of invading the Soviet Union, he is tired of life."

(in reply to EwaldvonKleist)
Post #: 12
RE: Collection of good WitE resources - 5/22/2018 7:02:53 AM   
Icier


Posts: 567
Joined: 7/15/2014
From: a sunny beach nsw
Status: offline
have been away from the game for 12 months & lost most of my saved data on the game due to a computer crash.

YOU, SIR....are a life saver


do you know whether this strange rule of Soviet surrendered units before November 41 re-appear in the list?

On a side note....I miss Pelton!

< Message edited by Icier -- 5/22/2018 7:04:30 AM >


_____________________________

Those are my principles, and if you don't like them... well, I have others.

(in reply to EwaldvonKleist)
Post #: 13
RE: Collection of good WitE resources - 5/22/2018 2:29:42 PM   
EwaldvonKleist


Posts: 1189
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Glad you like it :)
If you know more documents that should be uploaded here, make sure to notify me.

_____________________________

Visit the Library of Gary Grigsby's War in the East resources!

"When a wargamer is tired of invading the Soviet Union, he is tired of life."

(in reply to Icier)
Post #: 14
RE: Collection of good WitE resources - 6/19/2018 2:45:37 PM   
EwaldvonKleist


Posts: 1189
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Updated with a checklist for Axis turns during the 1941 summer offensive, and a protocol for team games, as it is used in the 8MP game (currnetly 1.7 and 1.8)
@Ice: I missed to answer a part of your comment: What "strange rule with units before november 1941" do you mean?

< Message edited by EwaldvonKleist -- 6/19/2018 3:09:15 PM >


_____________________________

Visit the Library of Gary Grigsby's War in the East resources!

"When a wargamer is tired of invading the Soviet Union, he is tired of life."

(in reply to EwaldvonKleist)
Post #: 15
RE: Collection of good WitE resources - 6/20/2018 9:56:18 AM   
56ajax


Posts: 728
Joined: 12/3/2007
From: Carnegie, Australia
Status: offline

quote:

ORIGINAL: EwaldvonKleist

Updated with a checklist for Axis turns during the 1941 summer offensive, and a protocol for team games, as it is used in the 8MP game (currnetly 1.7 and 1.8)
@Ice: I missed to answer a part of your comment: What "strange rule with units before november 1941" do you mean?

Assume units that surrender before Nov 1941 return without Admin point expenditure. After that date they will consume any remaining Admin points, so Soviets should end their turn with 0 admin points??? That rule??

_____________________________

When you escape from the lions den, it is unwise to go back for your hat.

(in reply to EwaldvonKleist)
Post #: 16
RE: Collection of good WitE resources - 6/21/2018 9:15:54 PM   
Icier


Posts: 567
Joined: 7/15/2014
From: a sunny beach nsw
Status: offline
That is the one.

_____________________________

Those are my principles, and if you don't like them... well, I have others.

(in reply to 56ajax)
Post #: 17
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

0.125