Author Topic: Excel UG Mining Tool  (Read 907 times)

Offline Laur "Zmeu" Coco

  • Survival closed test group
  • Newbie
  • *
  • Posts: 10
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Excel UG Mining Tool
« 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:


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


- filter the map chart by resource


- filter the map chart by area


- manually add a marker (like a city or a good hunting spot)


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



Hope you like it, and hit me back with your feedback (bugs, ideas for improving, and so on)
« Last Edit: August 01, 2014, 07:58:19 pm by Laur "Zmeu" Coco »
  • Citizenship: Regular citizen
  • Last seen in Saransk, Town at Outpost / Storages, accessing Market Terminal
  • Member of corporation: test
  • Member of society: Pleasure and Power

Offline Jarod "Brickwit" McBrickerton

  • Survival closed test group
  • Hero Member
  • *****
  • Posts: 1948
  • AfterWiki admin & Computer Engineer
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #1 on: July 31, 2014, 08:43:46 pm »
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.
  • Citizenship: Regular citizen
  • Last seen in Saransk West at Outpost / Storages
  • Member of corporation: Consolidators
  • Member of society: Shadow Corpse
Proud Officer in Shadow Corpse society and Consolidators corporation.

Offline Johnny "atslash" Luck

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #2 on: July 31, 2014, 10:44:46 pm »
 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.
  • Citizenship: Regular citizen
  • Last seen in New Urengoy [Q] at Outpost / Storages
  • Member of corporation: Alpha Unlimited
  • Member of society: Alpha

Offline Johnny "atslash" Luck

  • Jr. Member
  • **
  • Posts: 87
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #3 on: August 01, 2014, 05:22:46 pm »
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
« Last Edit: August 01, 2014, 05:40:06 pm by Johnny "atslash" Luck »
  • Citizenship: Regular citizen
  • Last seen in New Urengoy [Q] at Outpost / Storages
  • Member of corporation: Alpha Unlimited
  • Member of society: Alpha

Offline Laur "Zmeu" Coco

  • Survival closed test group
  • Newbie
  • *
  • Posts: 10
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #4 on: August 01, 2014, 07:52:59 pm »
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 , 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.


  • Citizenship: Regular citizen
  • Last seen in Saransk, Town at Outpost / Storages, accessing Market Terminal
  • Member of corporation: test
  • Member of society: Pleasure and Power

Offline zero "zero911" quod

  • Survival closed test group
  • Jr. Member
  • **
  • Posts: 59
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #5 on: August 02, 2014, 05:18:15 am »
how to disable alerts?
  • Citizenship: Regular citizen
  • Last seen in New Urengoy [Q]
  • Member of corporation: DILLIGAF
  • Member of society: Irken Invaders
RAM:        4.0 GB
OS:          Win7 Ultimate SP1 x64
CPU:        QuadCore Intel Core 2 Quad Q8200, 2333 MHz GPU:        ATI Radeon HD 4800 Series (Asus EAH4830) GPU RAM: 1.0 GB max 1919 MB DirectX:    11.0
Download Project Ion : https://sites.google.com/site/testbuilt/project-ion-info

Offline Famous "Gig" Gigolo

  • Full Member
  • ***
  • Posts: 101
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #6 on: August 02, 2014, 05:26:38 am »
Zmeu, this looks amazing! I wil try it  out asap.. But gotta say, it looks like great work!
  • Citizenship: Regular citizen
  • Last seen in New Urengoy [Q] at Outpost / Storages
  • Member of corporation: test
  • Member of society: Pleasure and Power

Offline The "Loneliness" Wolf

  • Newbie
  • *
  • Posts: 25
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #7 on: August 02, 2014, 12:50:38 pm »
best UG tool around here :D
  • Citizenship: Regular citizen
  • Last seen in New Urengoy [Q]
  • Member of corporation: test
  • Member of society: Pleasure and Power

Offline Laur "Zmeu" Coco

  • Survival closed test group
  • Newbie
  • *
  • Posts: 10
    • View Profile
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #8 on: August 02, 2014, 02:39:39 pm »
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?

  • Citizenship: Regular citizen
  • Last seen in Saransk, Town at Outpost / Storages, accessing Market Terminal
  • Member of corporation: test
  • Member of society: Pleasure and Power

Offline dale "dalewj" ofj

  • Survival closed test group
  • Hero Member
  • *****
  • Posts: 1103
  • Leader of Hunters Unlimited, Admin of Wiki, Author
    • View Profile
    • Author - Diaries of Afterworld
  • Gender: Male [Male]
  • In game: No
  • State: Human
Re: Excel UG Mining Tool
« Reply #9 on: August 25, 2014, 05:48:05 pm »
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..
« Last Edit: August 25, 2014, 05:53:09 pm by dale "dalewj" ofj »
  • Citizenship: Regular citizen
  • Last seen in Saransk, Town at Weaponry & Tools craft building, accessing Storage
  • Member of corporation: Alpha Unlimited
  • Member of society: Hunters Unlimited
Its been fun everyone will miss you all.   I'm at  dalewj.com and in every social network im dalewj. 

Playing the 'The Repopulation' a giant MMO has lots of EU and AW in it.  Come join us.  Im on east coast server and guess what my name in the game is.....