Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Qoi
Exert Force
102
|
Posted - 2014.08.01 15:35:01 -
[1] - Quote
I noticed that some people were unhappy about the process of importing the CREST industry data required for industry calculations into their spreadsheets, so i made an API for the system cost indices as well as the base job installation costs of blueprints.
I also included an API for my Compressed Ore calculator since Spreadsheets are probably not the right place for solving quadratic/linear optimization problems.
http://api.eve-industry.org
http://eve-industry.org
|
Richard Strohker
Brave Newbies Inc. Brave Collective
1
|
Posted - 2014.08.02 05:12:00 -
[2] - Quote
I'm very new to this spreadsheet stuff, so bear with my noobishness. I'm attempting to test pulling from your Mineral Compression API by simply copying your example URL into an importxml function, but I'm getting an "Import Internal Error" when using the xpath "//highsec-compression". Am I just being a noob and using the wrong xpath? |
Qoi
Exert Force
102
|
Posted - 2014.08.02 09:36:02 -
[3] - Quote
Richard Strohker wrote:I'm very new to this spreadsheet stuff, so bear with my noobishness. I'm attempting to test pulling from your Mineral Compression API by simply copying your example URL into an importxml function, but I'm getting an "Import Internal Error" when using the xpath "//highsec-compression". Am I just being a noob and using the wrong xpath?
EDIT: Nevermind, my friend corrected me on proper xpath usage (I could've just looked it up myself I guess). Got it working using "//eve-industry-api". Thank you very much for your feedback, i added that as an example usage box.
http://eve-industry.org
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4069
|
Posted - 2014.08.02 17:05:14 -
[4] - Quote
muhahahah! tread hijack
https://www.fuzzwork.co.uk/blueprint/api/xml.php?typeid=1320 https://www.fuzzwork.co.uk/blueprint/api/xml.php?typeid=1320&type=attribute (this link works, but the forum screws it up. C&P it.)
Away!
Woo! CSM 9!
http://fuzzwork.enterprises/
Twitter: @fuzzysteve on Twitter
|
Richard Strohker
Brave Newbies Inc. Brave Collective
1
|
Posted - 2014.08.02 17:27:48 -
[5] - Quote
The Compressed Ore calculator is quite nice to have in my spreadsheet (I'd been trying to figure out how to do the math myself, but you're probably right in that a spreadsheet isn't a great place to be attempting optimization solutions).
I am curious if you're planning on adding new features to it, though? Perhaps expanding it to include low/null ores, or the ability to take into account different specific ore reprocessing skill levels?
Either way, I thank you for the tool as it exists currently. It saves me a lot of time and headache trying to manually input different compressed ore quantities into a table to figure out the optimal combination for my blueprints. |
Qoi
Exert Force
63
|
Posted - 2014.08.02 20:02:00 -
[6] - Quote
Grrrrr!!
Didn't even link to a documentation, you must be working for CCP! Furthermore, i respectfully request these forums to be upgraded to support preformatted text. |
Qoi
Exert Force
102
|
Posted - 2014.08.02 20:02:03 -
[7] - Quote
Grrrrr!!
Didn't even link to a documentation, you must be working for CCP!
Richard Strohker wrote:The Compressed Ore calculator is quite nice to have in my spreadsheet (I'd been trying to figure out how to do the math myself, but you're probably right in that a spreadsheet isn't a great place to be attempting optimization solutions).
I am curious if you're planning on adding new features to it, though? Perhaps expanding it to include low/null ores, or the ability to take into account different specific ore reprocessing skill levels?
Either way, I thank you for the tool as it exists currently. It saves me a lot of time and headache trying to manually input different compressed ore quantities into a table to figure out the optimal combination for my blueprints. I'm more comfortable keeping it as simple as possible. I don't think there is a big reason to add compressed high-end minerals, the volumes involves are fairly negligible compared to the low-ends and you are probably much better off buying the minerals themselves that someone reprocessed for you in a shiny 60% outpost.
If you have already imported it into your spreadsheet you can retroactively account for different skill levels and even the +5% and +10% versions. You can probably just set the rate to 100% and then divide the results you get by the actual reprocessing rates.
Basically every time i think about adding all these options i go to https://www.fuzzwork.co.uk/compression/ and click on "Things affecting reprocessing" and i end up having many unhappy thoughts.
http://eve-industry.org
|
Angie Chatter
18
|
Posted - 2014.08.02 20:47:37 -
[8] - Quote
Any plans to add T3 support? I don't get any numbers for any of the T3 BPC or components. |
Qoi
Exert Force
102
|
Posted - 2014.08.02 21:38:44 -
[9] - Quote
Angie Chatter wrote:Any plans to add T3 support? I don't get any numbers for any of the T3 BPC or components.
Hmm, the API is currently case-sensitive, so searching for tengu instead of Tengu would not work, but apart from that i'm not sure what is wrong. What URL are you requesting?
It works fine for me: https://c.1tau.de/public.php?service=files&t=1194e93b3a9c44b22c7e5afebc1597f7
http://eve-industry.org
|
Angie Chatter
18
|
Posted - 2014.08.02 21:55:54 -
[10] - Quote
Silly me i used the final product typeID's instead of the BPC id's. Just tested again and its working, i can also confirm that the results match my own calculated adjPrice based values.
Btw thx for the xml Api, all the new crest stuff with nested json tables is a nightmare to import/work with excel, so this helps a lot. |
|
Richard Strohker
Brave Newbies Inc. Brave Collective
1
|
Posted - 2014.08.02 23:20:43 -
[11] - Quote
Qoi wrote:I'm more comfortable keeping it as simple as possible. I don't think there is a big reason to add compressed high-end minerals, the volumes involves are fairly negligible compared to the low-ends and you are probably much better off buying the minerals themselves that someone reprocessed for you in a shiny 60% outpost. If you have already imported it into your spreadsheet you can retroactively account for different skill levels and even the +5% and +10% versions. You can probably just set the rate to 100% and then divide the results you get by the actual reprocessing rates. Basically every time i think about adding all these options i go to https://www.fuzzwork.co.uk/compression/ and click on "Things affecting reprocessing" and i end up having many unhappy thoughts.
I suppose you're right on both counts. Honestly it's working just fine for me in its current iteration, so thanks again for making the API for it. |
minx1
Salamander Researches And Industries
0
|
Posted - 2014.08.10 10:57:12 -
[12] - Quote
Firstly thnks very much for ure XML notes on ure site :)
Got a few question for you or anyone
RE calculations or more specific job cost,
Currently Trying these lines
IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost") ( can't get this one to work )
IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost[@name='Aeon Blueprint']")
( this one works for me )
What am I not doing correctly to get the first one to work ?
2nd question :)
I'm using google docs so with the 50 XML clamp down how do I add multiples to the formula to auto fill the colum? I use the "&" after each item usualy for pricing ect?
Last one honestly
The job price for RE work how do you now pull the job based cost for example intact hull ?
Thank you in advance for any replys |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4069
|
Posted - 2014.08.10 18:03:31 -
[13] - Quote
Qoi wrote:Basically every time i think about adding all these options i go to https://www.fuzzwork.co.uk/compression/ and click on "Things affecting reprocessing" and i end up having many unhappy thoughts.
One option:
With the CORS header now added on TQ, you could have a 'load character sheet into a cookie' option.
Woo! CSM 9!
http://fuzzwork.enterprises/
Twitter: @fuzzysteve on Twitter
|
Qoi
Exert Force
102
|
Posted - 2014.08.10 22:41:21 -
[14] - Quote
minx1 wrote:Firstly thnks very much for ure XML notes on ure site :)
Got a few question for you or anyone
RE calculations or more specific job cost,
Currently Trying these lines
IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost") ( can't get this one to work )
IMPORTXML("http://api.eve-industry.org/job-base-cost.xml?names=Avatar","//job-base-cost[@name='Aeon Blueprint']")
( this one works for me )
What am I not doing correctly to get the first one to work ?
2nd question :)
I'm using google docs so with the 50 XML clamp down how do I add multiples to the formula to auto fill the colum? I use the "&" after each item usualy for pricing ect?
Last one honestly
The job price for RE work how do you now pull the job based cost for example intact hull ?
Thank you in advance for any replys
1. The first one definitely worked for me before, but google docs has been rather broken for me when i tested my API. I find spreadsheets too hard to use so i don't really have much experience here.
2. You can use comma separated names, like ?names=Avatar,Aeon,Expanded Cargohold II
3. The job base cost for invention and reverse engineering is linked to the blueprint you are producing, so if you are trying to reverse engineeer a defensive subsystem you can probably just use the job base cost from any defensive subsystem blueprint, i think they are all the same because they require the same materials to build.
If they should be different, you have to request the job base cost for all potential outcomes and calculate their arithmetic mean.
http://eve-industry.org
|
Katla Mikla
Shiloh Technologies
1
|
Posted - 2014.09.08 02:22:45 -
[15] - Quote
Is the site down, and if so, will it be back up? |
Qoi
Exert Force
102
|
Posted - 2014.09.09 12:00:24 -
[16] - Quote
There had been some hardware issues yesterday during the night, it should be working normally now.
http://eve-industry.org
|
Angie Chatter
18
|
Posted - 2014.10.03 13:22:46 -
[17] - Quote
Hi,
for some reason i don't see updated indexes? If i compare your returned values to Fuzzworks or in-game, they are off by quite a bit, are u sure your server is still updating? |
Sheri Angela
18
|
Posted - 2014.10.03 20:29:25 -
[18] - Quote
It was off last night and this morning (US CST) both on Index and Adjusted Price.
TIDI = Increasing profit while decreasing service level to the customer disguised a nicely marketed benefit. What would Amazon have done here.
|
Angie Chatter
16
|
Posted - 2014.10.05 11:09:00 -
[19] - Quote
The cost index database is still out of date and seems to display values from 2-4 days ago? Is there any eta when this may be fixed?
thx |
Angie Chatter
18
|
Posted - 2014.10.05 11:09:54 -
[20] - Quote
The cost index database is still out of date and seems to display values from 2-4 days ago? Would be great to get this fixed, so i can import instead of manually editing my sheet.
thx |
|
Nalha Saldana
Shattered Void Spaceship Samurai
857
|
Posted - 2014.10.06 13:53:17 -
[21] - Quote
I don't got how i get the invention cost for a item, is that just supposed to be the base job installation cost of the t1 item multiplied by the invention system cost index? |
Angie Chatter
18
|
Posted - 2014.10.06 14:04:09 -
[22] - Quote
Nalha Saldana wrote:I don't got how i get the invention cost for a item, is that just supposed to be the base job installation cost of the t1 item multiplied by the invention system cost index?
Basically yes, but multiplied also by 0.02. Just check this pdf: IndustryFormulas.pdf |
Angie Chatter
19
|
Posted - 2014.10.07 08:27:44 -
[23] - Quote
Seems the index values are back to current values, so thx for whatever you did or not did :p |
Soldarius
Deadman W0nderland The 99 Percent
856
|
Posted - 2014.10.28 19:25:12 -
[24] - Quote
This thread led me to several useful things and an excellent blog. Many thanks.
"Remember remember the 4th of November!"
Phoebe. Coming soon to Eve Online.
|
Neugeniko
Insight Securities
45
|
Posted - 2014.10.29 09:53:42 -
[25] - Quote
Thanks for this tool. I've used it instead of eve market data for my mining simulator spreadsheet. Do you know if the average volume function uses 'good' data? When I cache scrapped my own data I ignored todays data (partial days volume data) and yesterday's data for 12 hours (give the eve market server some time to do yesterday's aggregates I guess, sometimes 0 values would show up for a few hrs after DT).
Cheers, Neug
Mining Simulator V2.91
Neug's Prime Industrial Real Estate V1.0
Daily Forge Mineral Sales Summary V1.1
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |