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.
 

Production Sheet - Calc Taxes

First post
Author
Previous Topic Next Topic
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#1 - 2016-12-31 18:50:01 UTC
Hello

I'm trying to make my own sheet to talc the profit in each ship i build

I'm missing a way to calc the taxes because i'm found that i need a value that CCP give but i dont know which one nor how to get it

And to calc the taxes, after i'm able to get the value for each item

It's just add all cost and multiply by the system index?
Do Little
Bluenose Trading
#2 - 2016-12-31 20:14:28 UTC
There is a "base price" for each product - it is a moving average calculated using a formula CCP hasn't published.

Your "Job Cost" will be the system cost index times the base price. Tax will be a percentage of the job cost. All the data is available from the API https://developers.eveonline.com/ but it is dynamic - static spreadsheets aren't particularly useful.
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#3 - 2017-01-01 02:34:37 UTC
Atm i'm pulling market data automaticly

Is there any way to get the "base price" from CCP?

So it's not static but automatic.
Atm i use Gdocs
Zifrian
The Frog Pond
Ribbit.
#4 - 2017-01-01 05:54:42 UTC
See this thread for info: https://forums.eveonline.com/default.aspx?g=posts&t=432695

Or use my application below and you don't need to do any programming/ spreadsheets.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2017-01-01 18:02:11 UTC
The one thing to add is that the url has changed. It's now https://crest-tq.eveonline.com/market/prices/

If you're using Excel, you want to use powerquery to pull it into a sheet (I have an example of how to use powerquery on https://market.fuzzwork.co.uk/api/ It's not for this one, but the concept is the same)

If you're using google docs, you'd need to write a little javascript to handle the load. (If you have trouble here, give me a yell and I'll see what I can do)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#6 - 2017-01-02 00:02:36 UTC  |  Edited by: Timcanpy Yvormes
I tried to get the data from CCP to excel, but i can't get it at all

EDIT: i was also able to get it into google doc the data from the market using your website example. But the CCP data i can't get it at all. Neither using excel nor google docs

I'm getting info from your site but not from CCP

http://prntscr.com/dqgaa0

i set the table to Json in excel

That the table i get, i put the URL u said. Because after this i just need to find a way to get the data automaticly from an cell in the sheet and i have all the data i need.

After i have everything working just need to find a way to get the data every hour