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.
 

SDE in one giant Google Sheet
Author
Previous Topic Next Topic
salacious necrosis
Garoun Investment Bank
Gallente Federation
#1 - 2015-01-15 04:36:31 UTC
File this under stupid Google Sheet tricks...

I've imported the entire SDE as exported by Fuzzysteve into a single Google Sheet. Why, you ask? So that I can cross reference SDE data in my other Google sheets when I don't have convenient access to a database. This is overkill if you don't need much SDE data (e.g. only one table) as you can just import the page you need. It's more useful if you need to cross reference multiple tables (e.g. complicated industry plans).

Anyway, relevant links:

Blog post with more detail and "how it's made"
Short video showing how to setup a cross reference between Google sheets
Proteus SDE as a Google Sheet
Rhea SDE as a Google Sheet
Reference post on EveKit

Use EveKit ! - Tools for EVE Online 3rd party development
salacious necrosis
Garoun Investment Bank
Gallente Federation
#2 - 2015-02-18 04:14:13 UTC
Tiamat version has been added here.

Other interesting links (as shown in previous post):

Short video demonstrating how to setup a cross reference between Google sheets
Blog post with "How it's made"

Use EveKit ! - Tools for EVE Online 3rd party development