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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Spreadsheetfoo: semi-auto price importing
Author
Previous Topic Next Topic
Ray Kyonhe
Aliastra
Gallente Federation
#1 - 2014-07-27 19:09:39 UTC  |  Edited by: Ray Kyonhe
Greetings. I'm trying to compose my first spreadsheet for manufacturing and currently tackling the problem of basic materials' price updating. I've came upon some guides describing methods to import them in xml format from eve-central, but what I'm getting as a result is a crap that cannot be used for serious estimations.

So what I would like to achieve is that upon clicking on a shpreadsheet's cell where some material's price should be stored, I would be presented with a table formated like "Material_name - Quantity - Price - Time left" with all its active orders fetched this instant from eve-central, and be allowed to choose the more suitable price myself.

But I'm not very skillfull with spreadsheetfoo yet, so just don't know from which angle I should approach the problem. May be there is some similar project already completed by someone?

Survey/voting system inbuilt to the game client: link_Reforming corp and taxation system: link_New PvE content (reward collective gameplay): link
Mackie Avelli
Reckless Cowards
#2 - 2014-07-27 19:47:42 UTC
Thank Lockefox if you see him around (his work, not mine):-

http://eve-prosper.blogspot.com/2012/10/everything-you-never-wanted-to-know_17.html

There's an "Example Spreadsheet" at the bottom of the article, I pretty much figured all of the simple things by starting with that.
Ray Kyonhe
Aliastra
Gallente Federation
#3 - 2014-07-27 20:22:42 UTC
Mackie Avelli, thank you for the link, very helpfull.

Survey/voting system inbuilt to the game client: link_Reforming corp and taxation system: link_New PvE content (reward collective gameplay): link
Solai
Doughfleet
Triglavian Outlaws and Sobornost Troika
#4 - 2014-07-27 23:59:43 UTC
This video, and it's sequel, are pretty solid for getting into it, though it's likely less in-depth than the prior link.
https://www.youtube.com/watch?v=bLm0FQD_cN4