Science & Industry

https://docs.google.com/spreadsheet/ccc?key=0AiteSCKmfdrddGZKdGdFLXJKZDRxUXl3QlRURDBFMEE
A multipurpose spread sheet so that you can calculate your profits by selling your refined minerals. Includes refinery tax + cuts option.

Credit goes to Aidan Patrick, who originally put this out. My only contribution is the self updating market prices for the jita system. The imported market prices only work on google docs. You will need to download and re-upload this for personal / corporation uses.

How to use and change the importXML for this and other spread sheets.

Example, =importXml("http://api.eve-central.com/api/marketstat?&hours=6&typeid=11549&usesystem=30000142&minQ=5000","//buy/max")

hours Statistics from the last X specified hours.
typeid Can be specified more than once
minQ minimum quantity in an order to consider it for the statistics
regionlimit Restrict statistics to a region.
usesystem Restrict statistics to a system.

Each "typeid=xxxx" calls a specific market item.
"usesystem=xxxx" narrows to a specific system (30000142 is Jita)
"regionlimit=xxxx" requests a specific region (10000002 is Forge)
The last set of information is the specific data request (/evec_api/marketstat/type/sell/min)
Change "sell" to "buy" and/or change "min" to either "max" or "median"

hours=6 (Last six hours)
typeid=11549 (antimatter reactor)
usesystem=30000142 (Jita)
minQ=5000 (Min quantity 5k)

buy/max (Max buy order)

This will drop in the pricing for the buy order greater than 5k in Jita, within the last six hours.

List of Typeids
List of Regionids
List of Systemids: unable to find atm.

Credit for the XML walkthrough goes to UfoTRADER.