open All Channels
seplocked Science and Industry
blankseplocked Blueprint Profit Calculator - v1.0.3
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: 1 [2] 3

Author Topic

Andrahkon
UNITED STARS ORGANISATION
Sternhagel
Posted - 2007.09.16 09:06:00 - [31]
 

Nice work so far...but the materials/stock list is a bit confusing when showing all the unused ones
With a little vba-code should be easily changeable..feel free to contact me about this

On ship calculation theres always a NV in cost per hour

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.09.18 15:57:00 - [32]
 

Originally by: Andrahkon
Nice work so far...but the materials/stock list is a bit confusing when showing all the unused ones
With a little vba-code should be easily changeable..feel free to contact me about this

On ship calculation theres always a NV in cost per hour


with regards to the #N/A in cost per hour with ships, thats because all ships take over an hour to produce. the first hour will be 1333 ISK plus mineral costs. the next full hour will be 333 ISK plus mineral cost. because the hourly cost is then different in that next hour i felt that having a figure in here for runs over an hour would be misleading.

not sure what you mean about the stocklist. if i implemented VBA code, would it still work in OpenOffice.org?

Azia


Andrahkon
UNITED STARS ORGANISATION
Sternhagel
Posted - 2007.09.18 18:51:00 - [33]
 

Originally by: Azia Burgi

not sure what you mean about the stocklist. if i implemented VBA code, would it still work in OpenOffice.org?



The clearness isnt that gd because you have to scroll always around in the material-list to see all used lines/values

Would be better to hide all lines in the materials list
Dunno if its running in open-office with vba, maybe theres a way without vba to hide the unused lines


Kazuo Ishiguro
House of Marbles
Posted - 2007.09.18 19:28:00 - [34]
 

I don't think macros made in Excel work in openoffice, so I doubt VBA would be much better.

Jab Ader
Posted - 2007.09.18 22:10:00 - [35]
 

Great tool, I will defiantly use this.

The only suggestion I could make is to include a profit cell.

I see it already calculates batch cost and margin, but it would be nice to see how much profit you will make.

Thanks. Great work.

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.09.18 22:16:00 - [36]
 

you could sort the required minerals (column B) in descending order (the Z-A button). this groups the materials used towards the top. admittedly it doesn't sort the stock level table but this is because i have merged some cells.


Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.09.18 22:41:00 - [37]
 

added total profit. the formula i have used is Margin*RequiredRuns.

i think i will have to add a features list on the front page. maybe a version number too Smile

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.09.23 20:10:00 - [38]
 

I have updated the Ideal ME calculation to read as follows:
ROUNDDOWN(MIN(MaterialList)*Wastage*2,0)

I believe this gives a more accurate figure. It isn't 100% still so should only be used as a guide. To be able to implement the above calculation I have had to change how the materials list works.

If you want group the required materials together you now must sort column B by A-Z and NOT Z-A as previously stated. For some reason Excel thinks blanks are higher in value than actual figures.

If anyone has any suggestions on how to figure out ideal PE please let me know.

Blue Binary
Polychoron
Posted - 2007.09.24 17:52:00 - [39]
 

Originally by: Azia Burgi
I have updated the Ideal ME calculation to read as follows:
ROUNDDOWN(MIN(MaterialList)*Wastage*2,0)

....

If anyone has any suggestions on how to figure out ideal PE please let me know.



Perfect Productivity Efficiency Level equation

BPBase.ProductionTime / ((0.25 + 1) * 2) (Note: This isn't fully verified on all BP's, but 0.25 seems to be a constant)


Perfect Material Level equation

I'm not sure about your perfect ME equation, it doesn't look right using MIN.

Create this equation for each material to get a range:

ROUND (BaseMineral * BaseWastage * 2)

Then use this equation to get the perfect level for the BP:

MAX(PerfectME.range)

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.09.25 01:34:00 - [40]
 

Originally by: Blue Binary
Originally by: Azia Burgi
I have updated the Ideal ME calculation to read as follows:
ROUNDDOWN(MIN(MaterialList)*Wastage*2,0)

....

If anyone has any suggestions on how to figure out ideal PE please let me know.



Perfect Productivity Efficiency Level equation

BPBase.ProductionTime / ((0.25 + 1) * 2) (Note: This isn't fully verified on all BP's, but 0.25 seems to be a constant)


Perfect Material Level equation

I'm not sure about your perfect ME equation, it doesn't look right using MIN.

Create this equation for each material to get a range:

ROUND (BaseMineral * BaseWastage * 2)

Then use this equation to get the perfect level for the BP:

MAX(PerfectME.range)



Thanks very much for this, it does give slightly saner results than previously. i still say that anyone using this spreadsheet should take the Ideal ME and Ideal PE as advisory figures only.

please keep your comments and suggestions coming. i am working on version 2 which will hopefully contain COSMOS and T2.

Vicrry
Posted - 2007.09.25 03:41:00 - [41]
 

I've looked at the equations for Ideal ME, and given them my "Bored out of my mind at an engineering school" treatment. (Algebra Alert!! Skip to bottom if math hurts your head)

First, we define a few variables..
  • R - Minimum minerals required as listed on bill of materials
  • W - waste minerals
  • M - Material Efficency of BPO
  • and finally PE, your Production Efficency skill


First off, the minerals required to make a run is R+W,
with W=R*(.1/(M+1)+(.25-.05*PE)). Assuming a PE of 5, W becomes R*.1/(M+1). Now, for W to be rounded to 0 it must be less than .5 so solving R*.1/(M+1)<.5..
  • R*.1/(M+1)<.5
  • R*.1/.5<M+1
  • M>(2*(R*.1))-1

This suggests that the spreadsheet should use (Round((BaseMineral * BaseWastage * 2))-1 for each mineral.

Long story short: I think you missed a -1 in your formula for ideal ME.

MrRx7
Amarr
Cutting Edge Incorporated
RAZOR Alliance
Posted - 2007.09.25 03:56:00 - [42]
 

Azia please pull the file off your host and virus scan it, after downloading it my AV went nuts and started deleteing files in my evefolder siting virus "Pwstealer.ODM". no less than 5 seconds after the download finshed.

Ofc I am not saying its something you added, prob a bug your host picked up somewhere. please check into it

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.09.25 09:43:00 - [43]
 

Originally by: MrRx7
Azia please pull the file off your host and virus scan it, after downloading it my AV went nuts and started deleteing files in my evefolder siting virus "Pwstealer.ODM". no less than 5 seconds after the download finshed.

Ofc I am not saying its something you added, prob a bug your host picked up somewhere. please check into it


i've scanned the file and my PC fully with both McAfee and nod32 both pieces of software give my PC a clean bill of health. i have contacted my host providers (www.oneandone.co.uk), i expect to here from them within the next 24 hours.

I find it strange that out of the 547 downloads you are the only person to receive this problem. What anti-virus software are you using? have you run a full sweep on your system?

i can assure everyone that this file is virus free.

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.09.25 09:53:00 - [44]
 

Originally by: Vicrry
hard maths


if i am totally honest you are pushing the boundaries of my maths knowledge Embarassed. however i appreciate your help and your suggestion has been included in the latest version.

when i've had a couple of mugs of tea and dug out my calculator i might be able to follow what you are getting at marginally better Smile


Devlin Fox
Mercury Nation
House of Mercury
Posted - 2007.09.25 10:46:00 - [45]
 

Originally by: MrRx7
Azia please pull the file off your host and virus scan it, after downloading it my AV went nuts and started deleteing files in my evefolder siting virus "Pwstealer.ODM". no less than 5 seconds after the download finshed.

Ofc I am not saying its something you added, prob a bug your host picked up somewhere. please check into it


The AVG (database dated 25th Sept - release 269.13.30/1030) on my computer detects no threats for the file.

What AV do you use?

I find it unusual that a piece of malware with a generic name of "pwstealer" is carefully aimed at your EVE files, 5 seconds after downloading (did you open the file?), and google has never heard of "pwstealer.odm"...

Are there any more details?

Anticide
Controlled Substance
Republic Exploration Collective
Posted - 2007.10.02 00:51:00 - [46]
 

excellent work azia, wonderful spreadsheet!

A++++ CoolCoolCoolCool

Helevorn Feanaro
Gene Works
AKA-AHN KINGDOM
Posted - 2007.10.03 12:38:00 - [47]
 

Thanks for making this avaialable. I use it all the time.

Lei Marginale
Ex Coelis
The Bantam Menace
Posted - 2007.10.06 07:34:00 - [48]
 

This spreadsheet is awesome, that's a very good work, and you deserve a tip.

As a feature request, could you please add support for negative PE and ME if possible? That would help us inventors when you add T2 items in V2.

And the compatibility with OpenOffice is definitely a plus in my book Wink.

Mallinthas
Amarr
Black Thorne Corporation
Black Thorne Alliance
Posted - 2007.10.07 00:14:00 - [49]
 

Exceptional spreadsheet that i use on a daily basis...thx for making it available.
Look forward to a T2 version.

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.10.09 16:37:00 - [50]
 

Originally by: Lei Marginale
This spreadsheet is awesome, that's a very good work, and you deserve a tip.

As a feature request, could you please add support for negative PE and ME if possible? That would help us inventors when you add T2 items in V2.

And the compatibility with OpenOffice is definitely a plus in my book Wink.


thanks for your comments Smile

negative ME/PE should work already, I will check that though and get back to you.

Eleme
Guardian Angels Corp 1
The Final Stand.
Posted - 2007.10.23 03:34:00 - [51]
 

Very nice spreadsheet, makes a nice complement to the dragonol one. Well designed and very useful.

Thanks Azia

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.12.13 02:40:00 - [52]
 

Just a quick update: as soon as CCP make the Trinity data export available I will produce an updated version of the spreadsheet.

Fubar
Posted - 2007.12.13 11:13:00 - [53]
 

Originally by: Azia Burgi
Just a quick update: as soon as CCP make the Trinity data export available I will produce an updated version of the spreadsheet.


Trinity 1.0 Static Data Export

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.12.13 14:52:00 - [54]
 

Originally by: Fubar
Originally by: Azia Burgi
Just a quick update: as soon as CCP make the Trinity data export available I will produce an updated version of the spreadsheet.


Trinity 1.0 Static Data Export
they usually do a devblog about it... Embarassed

thanks anyway!

Drako Krakin
Okkelen Defense Force
Posted - 2007.12.30 10:28:00 - [55]
 

This guy has loaded up an Access version if you would like that.

http://myeve.eve-online.com/ingameboard.asp?a=topic&threadID=650828&page=2#42

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2007.12.30 11:00:00 - [56]
 

Originally by: Drako Krakin
This guy has loaded up an Access version if you would like that.

http://myeve.eve-online.com/ingameboard.asp?a=topic&threadID=650828&page=2#42
yup! i snagged it last night not got round to running my queries yet. thanks anyway Very Happy

Kevonski
Posted - 2007.12.30 11:26:00 - [57]
 

Very cool! Appreciate the effort!

Talullah Mae
Posted - 2008.01.29 14:03:00 - [58]
 

Azia is very proud of his knowledge of the game and he takes his time to pass it onto newbies.

He wanted me to post this chatlog in here for you all, pardon the colourful language, we are both very passionate people.

Quote:
Grakx > What would get you into warp faster... I Stabs or Nano fibers?
Azia Burgi > istabs
Azia Burgi > they let you align faster
Grakx > but what about accelerate to warp speed?
Azia Burgi > doesn't matter
Grakx > ok kewl thanks
Grakx > What are nanos good for then? :O)
Black Garius > weight reduction
Talullah Mae > nanos lower your mass, not your weight
Black Garius > the ship become faster
Talullah Mae > they help you align a little faster and you get more out of any afterburner or microwarpdrive
Talullah Mae > the ship IS NOT any faster without those mods tho
Grakx > ah nanos faster speed. IStab better acceleration and manuverability
Talullah Mae > no, nanos don't make you go faster unless you are using a prop mod
Azia Burgi > yes they do
Grakx > ya like AB of MWD
Grakx > ok kewl thanks
Talullah Mae > overdrives increase your base speed, nanos don't
Azia Burgi > <url=showinfo:2603>nanofiber</url>
Talullah Mae > oh look, mass reduction and structure loss
Azia Burgi > they reduce your mass which lgives you a higher velocity
Talullah Mae > NOT UNLESS YOU USE A PROP MOD
Azia Burgi > i have 3 on a badger
Talullah Mae > congratulations
Azia Burgi > it speeds me up slightly without a propulsion mod
Talullah Mae > fine, believe what you like, but don't pass that **** onto newbies
Azia Burgi > don't like it, theres the door
Talullah Mae > base speed of a badger II with all level V skills is 180m/s (no prop mod)
Talullah Mae > guess what it is if you slap on 3x Nanofibre IIs?
Talullah Mae > that's right, 180m/s
Talullah Mae > if you want to be dumb, that's your lookout, but don't pass on your bull**** to the newbies
Talullah Mae > this game is complicated enough without you
Azia Burgi > if you want to smack come to nakregde and smacktalk to the business end of my launchers
Talullah Mae > haha
Azia Burgi > otherwise be polite
Azia Burgi > http://myeve.eve-online.com/ingameboard.asp?a=topic&threadID=582478
Talullah Mae > that's not smack you dumbass, that's me "stating the obvious"
Azia Burgi > i think you will find that i understand the complexcity of this game
Talullah Mae > clearly not, if you think nanofibers increase your base speed



Remember this when taking his advice.

Azia Burgi
Caldari
Science and Trade Institute
Posted - 2008.01.29 14:15:00 - [59]
 

relevance?

Aja Crimeathin
Posted - 2008.01.29 20:14:00 - [60]
 

This is a great spreadsheet!!!! I found one more small problem with ammunition. If you set it up for a single run of say Scourge heavy Missile and set the Sale price to 1ISK above the cost for 1 unit it gives you a total profit of 1ISK for the entire run. The problem here is that your taking the cost of the run and dividing it by the 100 units of ammo (cell B7) to get the cost per missile.

The solution is to change the total profit formula from "=Margin*ReqRuns" to "=Margin*ReqRuns*B7" this causes the total profit to be adjusted by the total number of products produced by the set number of runs. So for the above case it correctly comes out to a total profit of 100ISK as 100 units were produced from the single run. Also this woks if you broduce say a Battleship and set the Sale Price to 1ISK above cost you get a 1ISK profit.


Pages: 1 [2] 3

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only