| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
ShatteredStone
   |
Posted - 2010.04.08 01:44:00 -
[1]
Heya :-)
I have been playing with Google Spreadsheets a bit recently, and one of the things that came out of that was http://bit.ly/oresheet. It tells you how much any ore is worth based on the current mineral prices in Jita 4-4 -- so if you are unsure what is currently the most profitable ore to mine, this might help.
The prices are calculated as mid-way between buy and sell-orders if 1% of the available market volume were bought or sold (i.e. lowball sell-orders and high buy orders get ignored unless they make up at least 1% of the total market volume for that mineral). Since it is based on Eve-Central orders, it is automatically updated, so unlike Grismar's excellent ore chart, the prices will stay current.
Let me know what you think if it's any use to you :-)
--ShatteredStone |
Ogwyn
|
Posted - 2010.04.08 08:44:00 -
[2]
Nice one !
Well and truly bookmarked!
|
ingenting
20th Legion
Sodalitas XX
|
Posted - 2010.04.08 13:03:00 -
[3]
so what differs from cerlestes?
|
Dana Mownhobbit
|
Posted - 2010.04.08 14:54:00 -
[4]
Hi, sry for noob question, but I must learn spreadsheet voodoo as well!
Where does this table get the current Jita Mineral Prices from?
I mean, ok there is eve central etc, but how can you send a certain data into that one table cell?
I have no clue of Excel either, but the longer I play Eve, the more I feel the urge to perceive that kind of stuff as neccessary player softskill. |
ShatteredStone
|
Posted - 2010.04.08 18:59:00 -
[5]
Edited by: ShatteredStone on 08/04/2010 19:00:58
 Originally by: ingenting
so what differs from cerlestes?
It orders by price so you don't have to. It also does not have history graphs for prices, including variants if you wish, and it's a spreadsheet in a WebApp, not a WebApp of its own.
Originally by: Dana Mownhobbit
Hi, sry for noob question, but I must learn spreadsheet voodoo as well!
Where does this table get the current Jita Mineral Prices from?
I mean, ok there is eve central etc, but how can you send a certain data into that one table cell?
I have no clue of Excel either, but the longer I play Eve, the more I feel the urge to perceive that kind of stuff as neccessary player softskill.
I'd recommend you make a copy of the sheet (in the File menu when you are logged in to google) and look at the formulas. Note that these prices are from a separate spreadsheet referenced in the "Price Sheet" sheet, which you also might want to study.
It's pretty much the same language as Excel, other than some Google-Specific eccentricities (like QUERY).
|
Jasdemi
Caldari
Deep Core Mining Inc.
|
Posted - 2010.04.08 19:41:00 -
[6]
Simple, user-friendly. <3 it.
Thanks! :D
---------------------------------------------
|
Dana Mownhobbit
|
Posted - 2010.04.09 07:17:00 -
[7]
Originally by: ShatteredStone
I'd recommend you make a copy of the sheet (in the File menu when you are logged in to google) and look at the formulas. Note that these prices are from a separate spreadsheet referenced in the "Price Sheet" sheet, which you also might want to study.
It's pretty much the same language as Excel, other than some Google-Specific eccentricities (like QUERY).
Ah good idea, thank you very much
|
Harry Braff
|
Posted - 2010.04.11 11:46:00 -
[8]
Very helpful, thanks
|
Siegante Windstalker
|
Posted - 2010.04.28 11:18:00 -
[9]
was planning to make something of the like so thank you!
bookmarked it
|
ShatteredStone
|
Posted - 2010.05.24 22:44:00 -
[10]
Updated for Tyrannis :-) (Changed ore compositions are highlighted in Cyan on the Calculation sheet)
|
|
|
captain foivos
|
Posted - 2010.05.25 02:07:00 -
[11]
Clearly someone has something wrong when one displays bistot as being worth much more than arkonor, and the other has arkonor worth more than bistot.
My money's on the one showing arkonor as most valuable.
Originally by: CCP Shadow
If you're going to quote me that's great, but it must be something I've actually said. Shadow.
You DID say this |
Heimer
Minmatar
Republic University
|
Posted - 2010.05.25 14:15:00 -
[12]
The quantities of Zydrine and Megacyte contained in the various flavors of Arkonor are wrong on this spreadsheet.
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |