AfterWorld Survival Forum
Discussions => Knowledge Database => Topic started by: Laur "Zmeu" Coco on July 31, 2014, 06:40:14 pm
-
Hello m8s,
I have created a new topic and added some print screens
Inspired by wolf, dale and jane I managed to do a little bit of excel coding and came up with something that a new miner can use in order to track his/hers claims. - you can find it in the attachment.
The tool is free to use, all you need is office excel and it can do the following:
(http://s21.postimg.org/xutumeafr/Overview.jpg)
- Import logs (one time) - it will go in the folder Afterworld Survival/Chat logs/ look in all the global_log* files and take out only the line where "Claimed" is found
This process is done in the background and takes less than a minute
- Import logs multiple times at a time interval - same as above only that will be done from time to time (you set the time interval)
(http://s28.postimg.org/4tb6d8vdp/Import_Logs_Multiple_Times.jpg)
- filter the map chart by resource
(http://s27.postimg.org/assczj6jn/Filter_By_Resource.jpg)
- filter the map chart by area
(http://s29.postimg.org/quogmavav/Filter_By_Area.jpg)
- manually add a marker (like a city or a good hunting spot)
(http://s30.postimg.org/rkmv9eb6p/Manualy_Add_New_Marker.jpg)
- the pink options are under development:
* marker design (as workaround: you can copy and paste a picture found in the Markers sheet on a data series and the marker will be changed)
* for the language I'll be needing some help with the translation of different messages and buttons name - I hope some of you will help, PM me if you would like to
* the tool is made to help us all, so if you have any good ideas to improve it, please don't be shy and share them.
Of course if you really like the tool you can always donate:
(https://www.paypalobjects.com/en_US/i/btn/btn_donateCC_LG.gif) (https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=XZAAMCWPG5QSN)
Hope you like it, and hit me back with your feedback (bugs, ideas for improving, and so on)
-
Cool UI and nice features. 8-)
I do my mining markers on the in-game map so that I don't have to turn to an external tool, but I'm sure there will be people that will love this.
-
8) WOW!!! I Cant wait to try this out. Thanks so much for this contribution to the community. Love the features can't wait to see what is next on your list of features.
-
I found 2 claims, verified they were in the log and tried clicking on import and it does nothing. any ideas?
figured it out... filter by area > select all areas
-
Thanks for your feedback and also thanks to atslash, because of whom we now have a new version of the tool - in attachment
What is new:
- the "Import logs multiple times at a time interval" doesn't throw the message 0 and stops after one execution.
- A new option appeared: in column C1 of the sheet MAP (http://s28.postimg.org/nhnm97co9/Select_All.jpg), if you have the value True, the filters (by area and by resource) will have all the claims displayed by default - please use it with caution, it might slow down the tool if there are many claims.
-
how to disable alerts?
-
Zmeu, this looks amazing! I wil try it out asap.. But gotta say, it looks like great work!
-
best UG tool around here :D
-
Thanks guys for the appraisals!
@ Zero, at the moment there is no option to disable alerts, but most of them are there to help (or did you find one that should not be there?).
Can you give me an example of an alert that you would like to disable?
-
Ok so its your turn for a test :) ok I use excel 2013 (win 7) and maybe my problems lie there :) "MicroSoft we are the leaders in innovation, wait for us!"
but when I click on the import logs (one time) I get nada. I am watching excel processes and there a quick blip of action then nothing. my files are in C:\Users\dale.JC2009\Documents\AfterWorld Survival\Chat logs as I expected they are suppose to be. I'm not a macro guy and you hid the lovelys in vbs passworded anyways. so I am not sure exactly what it is trying to do.
if possibly u can show me what the DataFromTxt should look like from an ore I might be able to make the data myself..