Statistics for your campaign

[fetmun]

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 [:)]

[morvael]

Two more posts and you will be able to put links in your posts (after a week).

[ledo]

That's really cool. I'll send a PM, as I'd like to use this.

[fetmun]

PM anytime you want

[fetmun]

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.

[Twigster]

Spasiba! [8D]

[EwaldvonKleist]

Here is the link to the document: https://drive.google.com/open?id=1EDndR ... D9Z5bd6NKG
Another impressive spreadsheet

[terry1040]

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

[fetmun]

Yep, great and full explanation how you should import and process your data, thank you. I am glad that you like my stuff

[rjohn37752]

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?

[fetmun]

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.

[rjohn37752]

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

[thedoctorking]

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.

[fetmun]

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.

[thedoctorking]

OK, thanks, that was my question.

[thedoctorking]

The little pull-down is not obvious. Am I doing something wrong?

Using Office 2016, the '365" version.

[HardLuckYetAgain]

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.

[thedoctorking]

So what happens when you run out of rows on the "Global Stat" page?

[AFV]

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!

[fetmun]

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