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: 15
Joined: 11/19/2011
From: Moscow
Status: offline 		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


Attachment (1)

< Message edited by fetmun -- 4/19/2019 11:22:31 AM >
Post #: 1
RE: Statistics for your campaign - 11/12/2017 6:24:16 AM   
morvael


Posts: 11762
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: 59
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: 15
Joined: 11/19/2011
From: Moscow
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: 15
Joined: 11/19/2011
From: Moscow
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: 1023
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: 2038
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: 139
Joined: 10/11/2000
From: The bright side of life
Status: offline 		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: 15
Joined: 11/19/2011
From: Moscow
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: 15
Joined: 11/19/2011
From: Moscow
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: 2297
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: 15
Joined: 11/19/2011
From: Moscow
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: 2297
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: 2297
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: 6987
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.

_____________________________


(in reply to thedoctorking)
Post #: 17
RE: Statistics for your campaign - 3/18/2019 4:05:17 PM   
thedoctorking


Posts: 2297
Joined: 4/29/2017
Status: offline 		So what happens when you run out of rows on the "Global Stat" page?

(in reply to HardLuckYetAgain)
Post #: 18
RE: Statistics for your campaign - 3/20/2019 2:57:37 AM   
AFV


Posts: 435
Joined: 12/24/2011
From: Dallas, Texas
Status: offline 		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!

(in reply to thedoctorking)
Post #: 19
RE: Statistics for your campaign - 4/19/2019 11:06:17 AM   
fetmun


Posts: 15
Joined: 11/19/2011
From: Moscow
Status: offline 		^^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 :)

(in reply to thedoctorking)
Post #: 20
RE: Statistics for your campaign - 4/19/2019 11:16:20 AM   
fetmun


Posts: 15
Joined: 11/19/2011
From: Moscow
Status: offline 		^^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!^^

Yep, kind of a nerdish things to do. But, wanna a real challenge? Try to quickly learn full ASL in a little room with 2 periodically yelling little kids and cat (!). Also, don’t forget you should feed your bear, or he will become angry.

< Message edited by fetmun -- 4/19/2019 11:17:47 AM >

(in reply to AFV)
Post #: 21
RE: Statistics for your campaign - 4/19/2019 6:01:23 PM   
thedoctorking


Posts: 2297
Joined: 4/29/2017
Status: offline 		Thanks, Fetmun, worked just fine. There is a funny error message when you add lines on the losses side but if you click through it works just fine. And "fill down" works with no problem.

Another question, how do I select the Soviets on the Production sheet?

(in reply to fetmun)
Post #: 22
RE: Statistics for your campaign - 4/27/2019 3:04:04 PM   
AFV


Posts: 435
Joined: 12/24/2011
From: Dallas, Texas
Status: offline 		Fetnum- incredible spreadsheet. I have one question/comment.

On the dropdown "choose type of display", between Accumulative or This turn, I get the same numbers (it does not display the turn, only the accumulative. I have Office 2016.

(in reply to thedoctorking)
Post #: 23
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.688