Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

Statistics for your campaign

 
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 >> Statistics for your campaign Page: [1]
Login
Message << Older Topic   Newer Topic >>
Statistics for your campaign - 11/11/2017 9:45:44 PM   
fetmun


Posts: 13
Joined: 11/19/2011
Status: offline
I was not very happy that WiTe1 engine cannot provide some overall dynamic statistics. But it can generate some raw date 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 date 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


Attachment (1)

< Message edited by fetmun -- 11/15/2017 4:55:01 PM >
Post #: 1
RE: Statistics for your campaign - 11/12/2017 6:24:16 AM   
morvael


Posts: 10909
Joined: 9/8/2006
From: Poland
Status: offline
Two more posts and you will be able to put links in your posts (after a week).

(in reply to fetmun)
Post #: 2
RE: Statistics for your campaign - 11/13/2017 12:28:51 AM   
ledo

 

Posts: 33
Joined: 11/6/2017
Status: offline
That's really cool. I'll send a PM, as I'd like to use this.

(in reply to morvael)
Post #: 3
RE: Statistics for your campaign - 11/13/2017 4:59:58 PM   
fetmun


Posts: 13
Joined: 11/19/2011
Status: offline
PM anytime you want :)

(in reply to ledo)
Post #: 4
RE: Statistics for your campaign - 11/13/2017 5:16:51 PM   
fetmun


Posts: 13
Joined: 11/19/2011
Status: offline
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.




Attachment (1)

(in reply to fetmun)
Post #: 5
RE: Statistics for your campaign - 11/13/2017 5:43:41 PM   
Twigster

 

Posts: 1008
Joined: 1/13/2015
Status: offline
Spasiba!

< Message edited by Twigster -- 11/13/2017 5:46:36 PM >

(in reply to fetmun)
Post #: 6
RE: Statistics for your campaign - 11/13/2017 8:24:51 PM   
EwaldvonKleist


Posts: 1073
Joined: 4/14/2016
From: Berlin, Germany
Status: offline
Here is the link to the document: https://drive.google.com/open?id=1EDndRRyQOXQu_ImrTEv5sKD9Z5bd6NKG
Another impressive spreadsheet :)

(in reply to Twigster)
Post #: 7
RE: Statistics for your campaign - 11/15/2017 2:33:56 PM   
terry1040

 

Posts: 85
Joined: 10/11/2000
From: The bright side of life
Status: online
Good Stuff. Thank you very much for your contribution.

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


(in reply to EwaldvonKleist)
Post #: 8
RE: Statistics for your campaign - 11/15/2017 4:46:58 PM   
fetmun


Posts: 13
Joined: 11/19/2011
Status: offline
Yep, great and full explanation how you should import and process your data, thank you. I am glad that you like my stuff :)

< Message edited by fetmun -- 11/15/2017 4:50:13 PM >

(in reply to terry1040)
Post #: 9
RE: Statistics for your campaign - 11/16/2017 1:01:31 AM   
rjohn37752

 

Posts: 16
Joined: 3/5/2017
Status: offline
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?


< Message edited by rjohn37752 -- 11/16/2017 1:23:35 AM >

(in reply to fetmun)
Post #: 10
RE: Statistics for your campaign - 11/16/2017 6:06:13 AM   
fetmun


Posts: 13
Joined: 11/19/2011
Status: offline
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.

(in reply to rjohn37752)
Post #: 11
RE: Statistics for your campaign - 11/17/2017 12:47:12 AM   
rjohn37752

 

Posts: 16
Joined: 3/5/2017
Status: offline
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.

http://www.matrixgames.com/forums/tm.asp?m=4082649&mpage=1&key=event%2Clog

< Message edited by rjohn37752 -- 11/17/2017 1:05:42 AM >

(in reply to fetmun)
Post #: 12
RE: Statistics for your campaign - 2/14/2018 2:10:33 AM   
thedoctorking

 

Posts: 581
Joined: 4/29/2017
Status: offline
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.

(in reply to rjohn37752)
Post #: 13
RE: Statistics for your campaign - 2/14/2018 6:49:34 AM   
fetmun


Posts: 13
Joined: 11/19/2011
Status: offline
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.




Attachment (1)

(in reply to thedoctorking)
Post #: 14
RE: Statistics for your campaign - 2/14/2018 2:53:54 PM   
thedoctorking

 

Posts: 581
Joined: 4/29/2017
Status: offline
OK, thanks, that was my question.

(in reply to fetmun)
Post #: 15
RE: Statistics for your campaign - 2/15/2018 3:09:40 AM   
thedoctorking

 

Posts: 581
Joined: 4/29/2017
Status: offline
The little pull-down is not obvious. Am I doing something wrong?

Using Office 2016, the '365" version.






Attachment (1)

(in reply to thedoctorking)
Post #: 16
RE: Statistics for your campaign - 2/17/2018 3:29:39 PM   
HardLuckYetAgain


Posts: 2090
Joined: 2/5/2016
Status: offline
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.

_____________________________

“If you teach a man anything, he will never learn.”;

Bernard Shaw

(in reply to thedoctorking)
Post #: 17
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's War in the East Series >> Statistics for your campaign 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.134