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.
Previous page12
 

T2 Invention / Production with just a spreadsheet

First post
Author
Previous Topic Next Topic
Lateralus
War Supplies Inc
#21 - 2014-09-29 22:07:07 UTC
Qoi wrote:
If you do not use external APIs, there are two problems you will run into.

* Calculating the Base Job Price (based on the adjusted prices published via CREST)
* Calculating the System Cost Index (published via CREST)

If you use Google Spreadsheets you can use =IMPORTXML() together with the API i published today ( http://api.eve-industry.org ), it does not really require programming expertise. I am sure Excel can do something similar. Or you just copy&paste the values from the API pages.

If you really want to do this with only ingame information, the system cost index can be gathered in game if you go to the star map and select the system cost index overlay. The precision is unfortunately only one significant digit for many systems, at least last time i checked.

The following is more a rube-goldberg machine than a real workflow.
If you have the system cost index, you can go to the industry window and get a quote for a manufacturing job in that system. You then divide by 1.1 to remove the NPC tax and divide again by the system cost index to get the base job price. Now you can calculate the manufacturing fee for other systems/facilities with a spreadsheet.


Qoi, you were right, this is exactly the problem I have run into.
Tinu Moorhsum
Random Events
#22 - 2014-09-30 22:04:25 UTC
Lateralus wrote:


It seems there is two modes of doing T2 production:
1) Simple, GUI based, and hope it's profitable for people that are new to manufacturing, or...
2) Computer Programming required API usage with custom tools.



Or use a caluculator and work out a rough approximation of the worst case scenario.

spreadsheets are important if you want to answer the question, "what should I be doing" very precisely. However, it's not the only question that you could be asking.

T-
Lateralus
War Supplies Inc
#23 - 2014-10-03 16:24:48 UTC
So, to wrap up my own thread...

Yes, you can do T2 Invention / Production with an Excel Spreadsheet, but you need to learn a few things.

API calls to get:
System Cost Index from here: http://api.eve-industry.org/system-cost-index.xml?name=Osmon
Adjusted Price from here http://api.eve-industry.org/

I personally use a Google Doc spreadsheet to pull prices from eve-central

Most of this can be researched on these forums, especially thanks to Qoi with this thread & that site/PDF linked in it as mentioned above, give Qoi an upvote/like on that thread:
https://forums.eveonline.com/default.aspx?g=posts&t=362493&find=unread

Thanks to everyone for their help in getting me up to date with Crius stuff. I'm scared of the changes coming to different outputs to invention though, that adds a crazy amount of complexity to T2 BPC outputs. It'll be very hard to figure out what you're going to get, in my view, it's already a hard enough thing to figure out, and a barrier to entry. The proposed new changes will be ridiculous to code into a spreadsheet or tool.
Lateralus
War Supplies Inc
#24 - 2014-10-03 16:27:30 UTC
Oh, and to add, to make it a dynamic spreadsheet that doesn't have everything manually entered, I pulled a pile of things from fuzzwork's website static data dump:

https://www.fuzzwork.co.uk/dump/

Props to you fuzz, keep kicking ass in that CSM spot.
Sheri Angela
#25 - 2014-10-03 19:58:47 UTC
You can use xml functions in Excel 2010+ to access the nice API service Qoi built. I used it for a short bit in my validation spreadsheets that I used when updating my web application. I'd recommend using it for a short bit, but since this is a game don't leave yourself dependent on other's service when RL hits them. Fuzz linked a possible solution for parsing JSON in Excel and there are several other solutions out there just for Excel.

TIDI = Increasing profit while decreasing service level to the customer disguised a nicely marketed benefit. What would Amazon have done here.
Rumbaldi
Tannhauser C-Beam
Seker Academy
#26 - 2014-10-03 22:39:58 UTC
Some of the stuf fon here makes me think i am readign a foreign language, kudos to all you people who code/program/write up these spreadsheets, be it a website or google docs or excel.
Previous page12