Statistics for your campaign
Moderators: Joel Billings, elmo3, Sabre21
Statistics for your campaign
I was not very happy that WiTe1 engine cannot provide some overall dynamic statistics. But it can generate some raw data which can be used in Excel for making that dynamic statistic. I made something for myself, and if you are interesting you can use it for your purposes. Its almost 95% automatic. All you need to do is:
- generate data through Commanders Reports at the beginning of each turn. Files can be found at your save folder.
- copy paste data from that to my Excel file (sheet “Raw Data”).
- make sure to fill 1st column with turn numbers
Cannot share links yet after 6 years [:)]
- generate data through Commanders Reports at the beginning of each turn. Files can be found at your save folder.
- copy paste data from that to my Excel file (sheet “Raw Data”).
- make sure to fill 1st column with turn numbers
Cannot share links yet after 6 years [:)]
- Attachments
-
- 1.jpg (147.95 KiB) Viewed 614 times
RE: Statistics for your campaign
Two more posts and you will be able to put links in your posts (after a week).
RE: Statistics for your campaign
That's really cool. I'll send a PM, as I'd like to use this.
RE: Statistics for your campaign
PM anytime you want
RE: Statistics for your campaign
Another samples from the table can be found in attachment. Cannot uppload Excel yet due to 4 mb size. Should be able after a week, since I have now 10 messages.
You can also dynamically track not only your current forces but also losses, production by Axis nations and some important pools and trucks situation. All data is configuring automatically from your exports through Commanders Report.
You can also dynamically track not only your current forces but also losses, production by Axis nations and some important pools and trucks situation. All data is configuring automatically from your exports through Commanders Report.
- Attachments
-
- sample.jpg (437.78 KiB) Viewed 501 times
RE: Statistics for your campaign
Spasiba! [8D]
- EwaldvonKleist
- Posts: 2374
- Joined: Thu Apr 14, 2016 3:58 pm
- Location: Berlin, Germany
RE: Statistics for your campaign
Here is the link to the document: https://drive.google.com/open?id=1EDndR ... D9Z5bd6NKG
Another impressive spreadsheet
Another impressive spreadsheet
The Library of Gary Grigsby's War in the East resources.
Do you want total war? Guide for WitE players
WitE2&RtW3 tester
Do you want total war? Guide for WitE players
WitE2&RtW3 tester
RE: Statistics for your campaign
Good Stuff. Thank you very much for your contribution. [&o]
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.
Hope this helps.
Cheers
Terry
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.
Hope this helps.
Cheers
Terry
RE: Statistics for your campaign
Yep, great and full explanation how you should import and process your data, thank you. I am glad that you like my stuff
-
- Posts: 16
- Joined: Sun Mar 05, 2017 6:02 pm
RE: Statistics for your campaign
Great spreadsheet!
I'm converting it over for the Soviet side. It's working out pretty good except for the manpower pool. It looks to me that the production tab is only picking up column 5 (Transfer) from the data sheet. Where as the pool should be the sum of column 4 (Active) and column 5. Would you please take a look and let me know what you think?
I'm converting it over for the Soviet side. It's working out pretty good except for the manpower pool. It looks to me that the production tab is only picking up column 5 (Transfer) from the data sheet. Where as the pool should be the sum of column 4 (Active) and column 5. Would you please take a look and let me know what you think?
RE: Statistics for your campaign
Nope, it is working like I wanted. I am deliberately taking only "Transfer" column, so it could correlate with appropriate column in the Production ingame screen. May be its wrong. But you could of course unite 4 and 5 columns if you like it better, and it may be better for your purposes in terms of game statistic. I am not sure Can you please explain what exactly means "Active" and "Transfer" in your understanding? I can’t find detailed explanations in the manual. Thank you.
-
- Posts: 16
- Joined: Sun Mar 05, 2017 6:02 pm
RE: Statistics for your campaign
This link explains it pretty well. Also note that there is a filter at bottom right of the in-game Production Screen that switches between Active, Transfer and All Pools.
tm.asp?m=4082649&mpage=1&key=event%2Clog
tm.asp?m=4082649&mpage=1&key=event%2Clog
- thedoctorking
- Posts: 2775
- Joined: Sat Apr 29, 2017 12:00 am
RE: Statistics for your campaign
I've been messing around with the statistics Excel spreadsheet you designed. How do you change what the line graphs on the first two tabs show? Is there some button to press or should I go into the table settings and try to change things?
Any newer versions of this I ought to be looking at?
Thanks for all your work on this.
Any newer versions of this I ought to be looking at?
Thanks for all your work on this.
RE: Statistics for your campaign
No, there is no updated version yet. Not sure if I understand your question right. But if you will follow with great explanation by terry1040, which you can find in this topic, all you need to do for changing graphs (after applying according instructions) is to push small buttons like in the picture bellow and choosing what statistics do you like to appear.
- Attachments
-
- ex..jpg (383.96 KiB) Viewed 500 times
- thedoctorking
- Posts: 2775
- Joined: Sat Apr 29, 2017 12:00 am
RE: Statistics for your campaign
OK, thanks, that was my question.
- thedoctorking
- Posts: 2775
- Joined: Sat Apr 29, 2017 12:00 am
RE: Statistics for your campaign
The little pull-down is not obvious. Am I doing something wrong?
Using Office 2016, the '365" version.
Using Office 2016, the '365" version.
- Attachments
-
- Stats.jpg (416.82 KiB) Viewed 500 times
- HardLuckYetAgain
- Posts: 8855
- Joined: Fri Feb 05, 2016 12:26 am
RE: Statistics for your campaign
So WITE is actually two games ;-P. One is the game itself and then we have the game of WITE SPREADSHEETS! You spreadsheet people amaze me with the time and effort that goes into this data collection. Awesome job & keep it up.
German Turn 1 opening moves. The post that keeps on giving https://www.matrixgames.com/forums/view ... 1&t=390004
- thedoctorking
- Posts: 2775
- Joined: Sat Apr 29, 2017 12:00 am
RE: Statistics for your campaign
So what happens when you run out of rows on the "Global Stat" page?
RE: Statistics for your campaign
I seriously can't wait to use this!
Good grief- playing WITE already puts me in the top 0.1% of nerdy, but being into spreadsheets about WITE is such a small percent it's almost immeasureable!
Good grief- playing WITE already puts me in the top 0.1% of nerdy, but being into spreadsheets about WITE is such a small percent it's almost immeasureable!
RE: Statistics for your campaign
^^So what happens when you run out of rows on the "Global Stat" page?^^
Why should you? You must conquer / defend the Red Colossus by the end of December 1941 at max! Or give it another try from the beginning if you not succeeded, comrade.
If seriously, I am struggling a little with English Excel terms (since my Excel is working in Russian language), but you should be able to:
1. Right click on your current last row in each of the sub-tables.
2. Find command "add a row" or something like this.
All those scary-looking formulas will appear automatically. I hope
Why should you? You must conquer / defend the Red Colossus by the end of December 1941 at max! Or give it another try from the beginning if you not succeeded, comrade.
If seriously, I am struggling a little with English Excel terms (since my Excel is working in Russian language), but you should be able to:
1. Right click on your current last row in each of the sub-tables.
2. Find command "add a row" or something like this.
All those scary-looking formulas will appear automatically. I hope