These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Spreadsheet, simple production

First post
Author
Previous Topic Next Topic
Elinara Yamamoto
Latex Entosis
#1 - 2015-08-16 11:43:13 UTC
Is there one that someone has made that is easily available for download? My spreadsheet skills are a tad rusty so it would take me many hours I think. Or maybe I can get some advice how best to reach my manufacturing goal?

What I want is just something where I can choose my blueprint item (just T1 for quite some time), only using maxed out BPCs copied from my own perfect BPOs, and then manufacture the max amount of runs from 10 copies (Advanced mass production IV) and I plug in ISK price manually from when I buy the input materials. And it then calculates total ISK cost of all items from the 10 runs, and maybe in another field divide total ISK cost by total item number to give me price by item from the ISK prices of input materials that I bought. (I then still have to add manufacture cost manually I think.)

Then I can head to eve-central and check where I should sell it, and start hauling.

At the moment I make little tables in a paper book and calculate it manually, as total number of Input materials for one blueprint item at 10 runs of 300 never changes. But then I have to manually multiply it with the ISK prices, and then add all the totals for each input material together by hand (calculator) and then divide by total item number.

Then I choose the station I m selling at, and check difference of sale price compared to price I am producing at, this times number of items gives me the total profit for that run. (I know prices change etc but just want to follow my manufacturing process better)

Anyone can help me in any way, I d be very glad :)
Bad Bobby
Bring Me Sunshine
In Tea We Trust
#2 - 2015-08-16 11:48:43 UTC  |  Edited by: Bad Bobby
You can do all that with EVE Isk Per Hour, without having to re-learn your spreadsheet fu.

http://eveiph.github.io/
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2015-08-16 16:23:26 UTC
Plleasure Hub
Municorn
#4 - 2015-08-16 21:24:15 UTC
The tools above are awesome. Another one to throw in the pot is
http://eve-industry.org/calc/

I was working on a spreadsheet calculator last year. I had the calculations perfected, including invention, me/te and # of run adjustments, etc. I even had data coming from EVE-Central and CCP's APIs for the post-Crius job cost calculation.

Eventually, it broke horribly, because when it tried to update prices, it was re-calculating hundreds of thousands of cells at a time. I think a task of this size requires much more advanced spreadsheet fu, because you need batch processing for it to be stable.

I may write a new version in Lisp soon (for learning purposes). I would love to create a publicly available web app that you can customize to your own blueprint library, business practices, selected markets, etc. I'm not sure such a thing exists with the amount of customization I want.

"There's no meaningful difference between a real and a virtual world. It's pointless to ask anyone who they really are. All you can do is accept and believe in them, because whoever they are in your mind, is their true identity." — Kazuto Kirigaya
Elinara Yamamoto
Latex Entosis
#5 - 2015-08-16 21:37:44 UTC
The Eve Industry one looks best so far, EVE isk per hour has way too much stuff for me I think, but will look into it more. In the Eve Industry one I can enter my own prices in the fuzzworks one I dont think you can, the one I looked at, but will spend more time on them when I come home from work today. Thanks so much and for understanding my convoluted english, its not my first language :)
Star Killer14
Core World Imperium
#6 - 2015-08-16 22:08:29 UTC
My problem with all of these tools is they do not seem to account for bulk building of components in arrays. I have found, by using the test server, that I would save close to 10m/hull using a component array to mass build components for ships which none of these programs seem to account for.

The programs allow you to build your components yourself but only in the amounts you need for one ship which is not the optimal amount for mass production of many items. This is because of how the formulas work, building large numbers of items will save you more usually.

For example, lets say a ship uses 5 units of Component X. These programs will let you build 5 units of Component X but if you built 500 units of Component X you will actually save much more but I have not found anyway to tell the program to build the items in these volumes.

I hope this makes sense, if not I will try to reword it. Overall these programs are good for getting a rough idea of what an item costs to build and will probably work well for building in stations but they do not work the best for building many things in a POS.
Plleasure Hub
Municorn
#7 - 2015-08-16 22:17:30 UTC  |  Edited by: Plleasure Hub
That makes perfect sense, Star Killer. I had never really thought of that before. On EVE-Industry.org you can specify that you are building components yourself, but you are right about the fact that it will misrepresent the true cost of components you build in bulk. I will have to keep that in mind when I'm building my new program. Maybe it could allow you to select a component and specify the batch size you build it in. Or even more simply, have a general setting labeled "Build components in bulk, optimized for low cost." When selected, it will calculate the cost of components in small jobs using the bulk cost value.

Edit: I believe many of these tools calculate with the philosophy that components and materials in general should be valued at their market price rather than the production cost. The idea is that you should evaluate a finished product's costs against the alternative opportunity of selling the components on the market. I agree that you should be able to customize this kind of calculation, though.

"There's no meaningful difference between a real and a virtual world. It's pointless to ask anyone who they really are. All you can do is accept and believe in them, because whoever they are in your mind, is their true identity." — Kazuto Kirigaya
Star Killer14
Core World Imperium
#8 - 2015-08-16 22:27:51 UTC
If you ever do please let me know PIIeasure Hub. I have been working on my own program to account for it but I have ran into several issues with it and haven't been able to finish it.

I have he meat of it working, it will calculate costs correctly but I haven't gotten it to work that I can import/export data from a java program to an Excel spreadsheet. Once I get that too work it is pretty much done besides checking that it does it all correctly and making it pleasant to the eye and making it so that you do not have to use command prompts to run/get data.
Star Killer14
Core World Imperium
#9 - 2015-08-16 22:40:46 UTC
Plleasure Hub wrote:


Edit: I believe many of these tools calculate with the philosophy that components and materials in general should be valued at their market price rather than the production cost. The idea is that you should evaluate a finished product's costs against the alternative opportunity of selling the components on the market. I agree that you should be able to customize this kind of calculation, though.


That is probably the most correct way to see your manufacturing profits. Profit from building the parts + profit from building the ship. However, the problem with it is it makes calculating the final profit more complex.
Plleasure Hub
Municorn
#10 - 2015-08-16 22:41:11 UTC
I will! Don't get your hopes up for anything happening soon, though (sorry!). I'm doing things the crazy way, because I am trying to learn new programming languages. If I build something decent enough for desktop or on a website, I will definitely release it to the community!

"There's no meaningful difference between a real and a virtual world. It's pointless to ask anyone who they really are. All you can do is accept and believe in them, because whoever they are in your mind, is their true identity." — Kazuto Kirigaya
goodlady Smith
TheCrazy88s
#11 - 2015-08-17 00:58:49 UTC
Steve Ronuken wrote:
https://www.fuzzwork.co.uk/blueprint/
https://www.fuzzwork.co.uk/market/marketdisplay.php
https://www.fuzzwork.co.uk/market/viewer/

may be of interest.


These are really good and also for the newer players coming into the building process there is a PH podcast on youtube by Steve Ronuken: https://www.youtube.com/watch?v=q6DCEVWXpLo

Please like my posts it makes me feel better about the time I spend on the forums WTS... Smiles