These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

EVE Exploration Google spreadsheet

Author
Grunschlck
Stupid Tax Evasion Corporation
#1 - 2016-05-08 19:55:33 UTC  |  Edited by: Grunschlck
Hi there fellow EVE Online players!

I've made a Google spreadsheet for recording where, when and what cosmic signatures you've scanned out with a high degree of automation and some pretty cool features if I say so myself. Included are an Adobe Reader file with step-by-step instructions on how to make your own spreadsheet and a file showing you how to upgrade your spreadsheet whenever there's a new version.

The latest version (0.6.0) has finally implemented the signature IDs and system names of Thera and Drifters w-space (I hope I've got them all, otherwise just let me know). I took my sweet time doing that, sorry for that. Furthermore, the website and API have moved to Google App Engine, so it should be faster and more robust (especially important since my server has been acting up lately).

If you're interested, head on over to https://eve-explo.appspot.com/.

Feel free to use it for your own exploratory endeavours.

Regards,
Grunschlck

League Of Misfit Pilots
Grunschlck
Stupid Tax Evasion Corporation
#2 - 2016-06-05 22:35:31 UTC
Bump
KaarBaak
Squirrel Team
#3 - 2016-06-07 18:54:23 UTC  |  Edited by: KaarBaak
I always like trying new data manipulators.

For some reason the code does not seem to be executing to fix the formatting issues.

Followed instructions in attached pdf.

Running in Chrome/Win10

KB

http://imgur.com/vhbT2us

Dum Spiro Spero

Grunschlck
Stupid Tax Evasion Corporation
#4 - 2016-06-11 07:38:03 UTC  |  Edited by: Grunschlck
KaarBaak wrote:
I always like trying new data manipulators.

For some reason the code does not seem to be executing to fix the formatting issues.

Followed instructions in attached pdf.

Running in Chrome/Win10

KB

http://imgur.com/vhbT2us


Hmm, weird I didn't get a notification about your post. But anyway, I'm using this spreadsheet in Chrome myself, only on Win7 instead of 10, but I doubt that makes a difference, as the code is executed on Google's servers and not locally.

In order to execute the function behind the menu item Spreadsheet → (Re-)initialize manually, please try the following:

  1. Use Tools -> Script Editor… in the menu. The code is then opened in a new tab.
  2. In the Code Editor tab, use Run -> initializeSpreadsheet and wait until the yellow bar with the text "Running function initializeSpreadsheet…" has disappeared.
  3. Then use View -> Execution transcript.
  4. In the execution transcript window, scroll to the bottom. If you see "Execution succeeded", then the function has run successfully. Do you see this?

Also a possibility would be that you share your spreadsheet with me (as editor) and I can have a look at the cause of the problem. Please send an EveMail to me in order to set that up.
Grunschlck
Stupid Tax Evasion Corporation
#5 - 2016-06-20 02:18:07 UTC
New version 0.6.1, thanks to KaarBaak!
KaarBaak
Squirrel Team
#6 - 2016-06-20 16:17:02 UTC
Grunschlck wrote:
New version 0.6.1, thanks to KaarBaak!

Thanks for the fixes! Pretty slick for tracking WH travels.

KB

Dum Spiro Spero