| Author |
Topic |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.11 00:50:00 - [ 1]
Edited by: Azia Burgi on 14/06/2008 23:48:01Hello Everyone I have finally updated my Blueprint Profit Calculator to take into account Trinity data. When I came to post the new version I found the old thread had auto-locked  . I have been working on a calculator that lets me work out the cost of producing any given item. This is the result. Feel free to use this how you see fit and as always I am open to suggestions/ideas/comments on future improvements. You will require MS Office 2000 or later to open the spreadsheet or the latest version of OpenOffice.org. I have made this version in Excel 2007 so if there are any weird things that appear, please let me know and I'll try to fix them. There are still no T2 or COSMOS items and I still have to load in some data on the lookup table. I will get the missing data loaded in ASAP (maybe Tuesday at this rate). Blueprint Profit Calculator (v1.1.2) Features * All Tech 1 Blueprints (as of Trinity export) * Total Margin Per Unit * Estimated Completion Time * Recommended ME Level * Recommended PE Level * Stocklevel Calculator - now updates with sorting! * Accurate Required Materials Listings (based on the inputed skill levels) |
Anticide
Decorum Inc
Tygris Alliance |
Posted - 2008.05.11 00:54:00 - [ 2]
|
Geordy
Caldari
EtE Clan
Sc0rched Earth |
Posted - 2008.05.11 09:39:00 - [ 3]
That looks great..
When I open the excel sheet though, it has automatic links to another workbook called BP_Profit_calc
but I cannot find it, or am I missing something?
Cannot wait for you to finish it though. it is great.. |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.11 17:37:00 - [ 4]
 Originally by: Geordy
That looks great..
When I open the excel sheet though, it has automatic links to another workbook called BP_Profit_calc
but I cannot find it, or am I missing something?
Cannot wait for you to finish it though. it is great..
no you aren't missing anything. its from me forgetting to unlink the old table which i looked up off for some of the data. you can safely ignore that. |
NeoSmith
Rex Corp
|
Posted - 2008.05.12 05:20:00 - [ 5]
Great stuff, Azia Burgi. Keep up the good work!
I found something's missing in Sheet "New Front End" cell F16 , where you label as "Runs needed to pay for the BP:"
What's missing in the formula is "divide by numbers of unit / manufacturing run".
It is supposed to be "=ROUNDUP(BPCost/Margin/B7,0)"
Correct me if i'm wrong.
Thanks. |
Battlecheese
Caldari
SiN. Corp
Sons of Tangra |
Posted - 2008.05.13 13:28:00 - [ 6]
For the record, this new version does not work correctly in Excel 2000.
In particular, it is not correctly loading data from the Lookup tab. |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.13 23:04:00 - [ 7]
sorry I haven't replied earlier but my interwebs have been brokeded.
NeoSmith, thats a well spotted mistake. thanks for pointing it out, its corrected in the new version.
Battlecheese, can you give an example?
Thanks
|
Becki
Caldari |
Posted - 2008.05.17 11:04:00 - [ 8]
Hi there and thx for this great tool, but i got a little komfort problem with it.
Is it possible to make the 8 minerals the first 8 entrys in the bill o materials, as those are immo the most used mats ?
i tryed to edit it myself, but it seems i mees it up to much by doing so ;p |
ironwool
THE IRIS
Intrepid Crossing |
Posted - 2008.05.17 11:27:00 - [ 9]
Is the site down ?
I'm trying to get it and getting errors. |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.17 17:48:00 - [ 10]
Originally by: Becki
Hi there and thx for this great tool, but i got a little komfort problem with it.
Is it possible to make the 8 minerals the first 8 entrys in the bill o materials, as those are immo the most used mats ?
i tryed to edit it myself, but it seems i mees it up to much by doing so ;p
if you click in column B then click on the Z->A icon on the toolbar it will bring the relevant materials for that blueprint to the top. if you are still having issues contact me ingame and i'll talk you through it. ironwool, no problems here. |
Becki
Caldari |
Posted - 2008.05.17 20:56:00 - [ 11]
Edited by: Becki on 17/05/2008 21:17:54Uhm btw i just noticed, the material infos for the small tractor beem I are wrong. According to the Eve-Database, the Mat bill should read: Tritanium 100,000 Pyerite 25,000 Mexallon 9,000 Isogen 2,500 Nocxium 350 Zydrine 20 Megacyte 40 Not sure about more entrys, and the sorting worked ^^ So ar a dam good thing you put together there  LG Becks |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.17 22:08:00 - [ 12]
Originally by: Becki
Edited by: Becki on 17/05/2008 21:17:54
Uhm btw i just noticed, the material infos for the small tractor beem I are wrong. According to the Eve-Database, the Mat bill should read:
Tritanium 100,000
Pyerite 25,000
Mexallon 9,000
Isogen 2,500
Nocxium 350
Zydrine 20
Megacyte 40
Not sure about more entrys, and the sorting worked ^^ So ar a dam good thing you put together there
LG Becks
yes the database lists the materials required as perfect (no wastage) if you have a look on the lookup sheet you will see it lists the requires the same as the database. i have to add the wastage factor on to the base requirements then take it off depending on the skill levels and blueprint ME. |
Becki
Caldari |
Posted - 2008.05.17 22:17:00 - [ 13]
Edited by: Becki on 17/05/2008 22:40:22Edited by: Becki on 17/05/2008 22:32:36darn NM on the STB I mat reqs, the Database on the eve HP is outdatet ;p just checked the BPO ingame. And some items in the lookup seem to miss infos one em (Warp Disruption Field Generator I for instance). Changing em or myself right now with ingame infos. oh and i guess that only hits german users of this tool, in the formula for the Estimatet TTC needs the dd changed to tt to show correctly. Just checked your 1.1.1. nice done. I like the warning selling for loss  just still some missing inos in the lookup^^ go on that way MyLord |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.17 22:39:00 - [ 14]
v1.1.1 is the latest version. yeah i know about the Warp Disruption Field Generator I and a few others. these items didn't pull out of the database cleanly i'm having to manually lookup the data and input it. Its on the back burner until after my exams on wednesday 28th may. well the dd thing works if you have your regional settings set to british  . if i change it to tt on my computer it puts in "tt", i guess this is just one of those things that people using non-english software are just going to have to change themselves. sowwie  |
Becki
Caldari |
Posted - 2008.05.17 22:44:00 - [ 15]
A thing ive done to my version was, coloring all fields i am allowed to change (insert data or drop down) removing the locked tag on those fields, and locking the workpage, so i dont overwrite accidently an invisible formula.
and GL on your examen^^ |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.17 23:25:00 - [ 16]
thanks  if i didn't make so many changes to it i'd lock the sheet. |
ironwool
THE IRIS
Intrepid Crossing |
Posted - 2008.05.17 23:44:00 - [ 17]
Yeah, sorry must have been a web glitch. Anyways thanks for this, very useful |
Becki
Caldari |
Posted - 2008.05.18 00:42:00 - [ 18]
hm just readed the 1st thread about your Omnipotent Spreadsheet ^^, well or COSMOS or T2 Items, wouldnt it be possible to make a 2ed or a third lookup page, one or each section?
Or would that be again to much or excel? Dont know that much about it. thx and fly safe |
Sir Substance
Minmatar
The Empire Nation
Dead Mans Hand |
Posted - 2008.05.18 06:37:00 - [ 19]
the units able to produce field doesnt work for mexallon, other then that, good work. |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.05.18 16:48:00 - [ 20]
Originally by: Sir Substance
the units able to produce field doesnt work for mexallon, other then that, good work.
it works fine here. can you provide a screenshot? |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.06.12 22:31:00 - [ 21]
I will release a new version as soon as CCP make the EA data dump available.
|
Mazzarins Demise
Profit Development and Research Association |
Posted - 2008.06.13 01:50:00 - [ 22]
Thank you Azia. |
Logain Del'Tirith |
Posted - 2008.06.13 06:10:00 - [ 23]
Does this need to be updated for the rounding change in the new patch with runs?
Is there a way to make it so that the data sort also sorts the stock as well, so that if I put in current stock it keeps the current stock figures next to the item after a sort is done? |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.06.13 09:40:00 - [ 24]
Originally by: Logain Del'Tirith
Does this need to be updated for the rounding change in the new patch with runs?
Is there a way to make it so that the data sort also sorts the stock as well, so that if I put in current stock it keeps the current stock figures next to the item after a sort is done?
I will have to check the rounding thing after I get the new data. I know the stocklevel is annoying but it has to be separate otherwise when you sort it the headers are sorted too. But I have an Idea, let me see what i can do. |
degini
Perkone |
Posted - 2008.06.13 21:03:00 - [ 25]
Excellent work. However, this seems to be a profit calculator for manufacturing, not for blueprints. The title led me to believe it was a calculator for blueprint research. |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.06.13 22:12:00 - [ 26]
Originally by: degini
Excellent work. However, this seems to be a profit calculator for manufacturing, not for blueprints. The title led me to believe it was a calculator for blueprint research.
just researching a blueprint won't make it profitable. You have to do manufacturing to recoup the loss of buying and researching the blueprint. I'm not certain what you expected. |
Mia Morningstar |
Posted - 2008.06.13 22:36:00 - [ 27]
Originally by: Azia Burgi
Originally by: degini
Excellent work. However, this seems to be a profit calculator for manufacturing, not for blueprints. The title led me to believe it was a calculator for blueprint research.
just researching a blueprint won't make it profitable.
well, you can buy a BPO ME0, PE0, research it to ME20, PE10 (or w/e) and sell it for profit. Variables like installation cost of research job, cost of research per hour would be needed taken in account while determining the profitability. |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.06.13 22:41:00 - [ 28]
thats true i suppose. not something i plan to add to my spreadsheet.
|
Rawblin
Caldari
Perkone |
Posted - 2008.06.14 04:05:00 - [ 29]
Just a quick question:
Ideal ME is reporting "Err:502" for me, is there some field I am missing, or is there a broken link somewhere?
Currently running the latest version of OpenOffice.
Sorry, very new to manufacturing, not to mention OpenOffice :P |
Azia Burgi
Caldari
Science and Trade Institute
|
Posted - 2008.06.14 16:03:00 - [ 30]
Originally by: Rawblin
Just a quick question:
Ideal ME is reporting "Err:502" for me, is there some field I am missing, or is there a broken link somewhere?
Currently running the latest version of OpenOffice.
Sorry, very new to manufacturing, not to mention OpenOffice :P
It sounds like an openoffice error. What blueprint are you looking at? |
All Channels
Blueprint Profit Calculator v1.1.2
Please visit your user settings to re-enable images.
Screenshots & Art
