Aurora 4x
VB6 Aurora => Aurora Chat => Topic started by: ardem on March 20, 2011, 06:36:25 PM
-
Erik: I am not sure exactly what forum this should go into but if you feel you need to move it please do.
Log File Sifter: http://dl.dropbox.com/u/4316559/LogFileSifter.xlsm (http://dl.dropbox.com/u/4316559/LogFileSifter.xlsm)
Latest version v1.04
Hi Guys,
As some of you know I am one of the fiction writers in Aurora, and I am always struggling with historical data of my game, so I decided to use Aurora log files that it generates, combine and sift these into excel tables to help me analyse the data.
I decided to put it out there for anyone else that needs this sort of log file utility.
I am far from a gifted excel programmer or a programmer for that matter, I am open for anyone who wishes to improve the code or has some ideas about additional filters, or have found some bugs.
I would also later like to make some graphs out of the information, and some various other filters or data manipulation, but atleast at this point you can get a history of all your aurora events.
I am hoping Steve does not take offence at this utility if so please PM me and I will remove it from circulation.
Please note: I made the excel document in Excel 2010, it should work on 2007, I am unsure if it will work in Open Office.
-
A couple of changes and overwrote the link above.
Changes:
1/ The Date field is now a proper date column, the will be beneficial for sorting and in chart later.
2/ New Chart that displays ship building progress
3/ New Chart that show research breakdown
If there are any kind would who could test the excel spreadsheet and make sure the charts are displaying correctly with some feedback that would be great. i am using a large 27" inch screen so I want to make sure it displays right for others.
-
I was playing around with this a bit. It doesn't seem to import the log files. Is there a special name format you are using?
I've got 1 logfile, named Human1.txt
Get an error stating "The command could not be completed by using the range specified." and it highlights a blank B column on the Raw worksheet.
-
I am using Steve default output in the c:\logs section, which seems to be Y1,txt (note the , instead of the fullstop)
I am unsure if this is just particular to my computer, but when I play a game and after so many messages under c:\logs it creates a Y1,txt file etc etc. These are the files I use, there is no modifications need to be done to the files themselves.
The import looks for Y$,txt where $ is the log file number it will skip files that do not exist in your selection on the front page.
(http://dl.dropbox.com/u/4316559/Logfiles.jpg)
This is a screenshot of my c:\logs folder note there is only two files as I only just restarted my game in 5.42
The "Human" input on the front of the sheet is after the import to strip out all the alien races from the log files. If your race is other then human you need to change it here.
Thanks Eric for your help here,
-
Here are some screens of how things should look so I hope it helps pick up any mistakes
(http://dl.dropbox.com/u/4316559/Logfiles_frontpage.jpg)
This is the front page, note the reset button deletes all the sheets and puts the file back to the original(nothing ever changes or deletes the original log files), also import and race must be run prior to everything else, none of the other buttons will work anyway. I have a few error traps already in place
(http://dl.dropbox.com/u/4316559/Logfiles_racepage.jpg)
This is how the race sheet should look after the race button is clicked all the other alien races are stripped out.
(http://dl.dropbox.com/u/4316559/Logfiles_researchpage.jpg)
This is the Research sheet, with the chart built. Note: You need to build the research sheet before the chart
(http://dl.dropbox.com/u/4316559/Logfiles_shippage.jpg)
This is the ship sheet with the ship growth built
(http://dl.dropbox.com/u/4316559/Logfiles_maintenancepage.jpg)
This is the Maintenance page with yearly failure rate
-
Hmm. The only log files I've ever seen are generated from the Event Updates window with the "Text File" button. That gets output to the game install directory.
-
Well I have installed aurora on three different systems and each create a c:\logs folder, not sure if it is hidden on your computer as its not hidden for me. I be interested to know, if you can do a search on your computer for *,txt files.
My default install folder is c:\aurora, this is all very interesting I wonder if I am special <smile>
I will work on an additional input for those in game log file creations, problem with those files you got to remember to create them where the Y1,txt files are created automatically, when it needs too, atleast on my system. Is there any registry settings that Aurora makes that I may have you haven't.
Hmm perhaps steve can help here.
-
Updated once again
Changes
-I have added an extra style of import, which is from the Text File save of the log files. This file usual is saved to your aurora game directory and given the name raceeventlog.txt e.g. Humaneventlog.txt
Note: This does not work combined with the Y1,txt style import because, the text file save is missing the race field.
-
I am hoping Steve does not take offence at this utility if so please PM me and I will remove it from circulation.
No problem at all. It looks very useful!
Steve
-
Please note: I made the excel document in Excel 2010, it should work on 2007, I am unsure if it will work in Open Office.
Ardem,
I just tried it and Open Office is not compatible for some reason. :-[ Looks pretty awesome though :)
Adam.
-
Just downloaded Open Office, unfortunately I don't know it well enough to do a port at this stage, happy to work with anyone who does know open office macros, or perhaps, when I finished all the features for the excel version, I can try and dig my way through open office macros.
Other then myself has anyone got this excel file working as I am concerned, people do not have this y1,txt log files in the c:\logs folder, or it could be the folder called logs on the same level as your aurora game directory.
-
Ok, I downloaded it and it works fine in Office 2007, after I figured out how to enable the macros.
I have a totally stock install of aurora on winxp and it does create a log folder and Yx files on c:\. Win 7 users won't have it there though, if they have it at all, because of the way 7 does drive security.
Thanks for making this!
--Mav
-
I am a win 7 user and I have it, perhaps your right perhaps its also has to do with UAC (User Accounts Control) which I have turned off or always turn off.
Glad you got it working, I was starting to get worried I was slightly insane.
-
My install directory has the following subdirectories: Flags, Game Backups (created by me), Medals, Planetjpeg, Races, screenshots, Ships
-
Hi Eric
The log folder for me had never installed in the game directory always in c:\logs I am not sure why. my game directory is c:\aurora and got all the folders you have mentioned, except for game backup ofcourse.
-
I am a win 7 user and I have it, perhaps your right perhaps its also has to do with UAC (User Accounts Control) which I have turned off or always turn off.
Glad you got it working, I was starting to get worried I was slightly insane.
Maybe we can talk Steve into moving that to the installation directory.
-
I wanted to check if it was UAC stopping it, but it is not. So I ran a test.
1/ I created a new user (non administrator) on the computer and turned UAC on to full. I delete the C:\logs folder
2/ I then restarted, I then logged in as the user and started a new aurora game, I then proceed doing 30 day turns for about a year to generate some events logs, once I look into the windows directory there was a c:\logs folder created and a Y1,txt in the folder and another folder which was the name of the game I made.
This confirms that the folder creation is coming from the aurora .exe file somehow.
Eric I am not sure why your folder is not being created.
-
It's on my D drive. I've got Aurora installed in D:\Games\Aurora and I have a D:\Logs directory.
-
Mystery solved, well now you know about these logs I hope they help you in future. Wow you can learn something new about Aurora every day <wink>
-
Windows 7 excel 2010. Great utility. So far it works well. I am very early into this game, several years only. Charts worked great. Jumppoint and Unrest untested- no info in the log file to get. I've had no battles yet but the Battle listing produced the following:
A team on Earth led by Aletha Whitesell has completed research into Ion Engine E8
A team on Earth led by Aletha Whitesell has completed research into J5000(3-100) Military Jump Drive
A team on Earth led by Aletha Whitesell has completed research into Ion Engine E8
A team on Earth led by Aletha Whitesell has completed research into Ion Engine E0.8
A team on Earth led by Aletha Whitesell has completed research into J6250(3-50) Military Jump Drive
Scientist Aletha Whitesell has developed a medical problem that will affect his long term health. Current Assignment: Unassigned
A team on Earth led by Aletha Whitesell has completed research into Asteroid Mining Module
Ramiro Aune has joined your army officer corps. Ground Combat 5%: Promotion Score 25
A team on Earth led by Aletha Whitesell has completed research into Jump Gate Construction Module 150
Seemed kind of odd to me as I have 3 total scientists and several other army officers that have joined my army officer corps.
-
These are the search parameters for it to be put in the battle sheet.
hit, points of damage, points of damage, Nuclear Detonation, target, intercepted, shields, ECM, fire, missile, absorb, ram, salvo, missed, contact, signature, firing, reload.
Now what i did not do it add spaces either side of the word meaning the case of Whitesell, she has "hit" apart of her name. And in the case of Ramiro he has ram in his name.
DOH!
Will fix this and put a new version up shortly
-
Ver 1.03
Changes:
Tightened up search parameters for battles, although maintenance secondary explosions still are added to battles as there is no way to distinguish these from battle related damage.
-
Odd error. glad you got it fixed.
-
v1.04
Last one for the week, due to a specific request, although happy for them to keep coming, either PM me or add to these posts
Changes
- I have added maintenance sheet, which adds anything to do with maintenance
- New Chart which give an overall impressions of failure on ships per year.