EVE Search - Blueprint Profit Calculator

Check My IP Information

All Channels

Science and Industry

Blueprint Profit Calculator

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 [2] 3 :: one page

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Andrahkon UNITED STARS ORGANISATION	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 ------------------------------------------------------------- Selling Carrier with fuel and Mods - preorders accepted
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 Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator
Andrahkon UNITED STARS ORGANISATION	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 ------------------------------------------------------------- Selling Carrier with fuel and Mods - preorders accepted
Kazuo Ishiguro House of Marbles Zzz	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. My research services Spreadsheets: Top speed calculation - Halo Implant stats
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 http://azia.geekandproud.co.uk BP Profit Calculator
Azia Burgi Caldari Science and Trade Institute	Posted - 2007.09.18 22:41:00 - [37] added total profit. the formula i have used is *MarginRequiredRuns**. i think i will have to add a features list on the front page. maybe a version number too Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator
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)Wastage2,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. Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator
Blue Binary	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)Wastage2,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) ____________ Blue B⁫⁫⁫⁫inary
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)Wastage2,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. Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator

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-.05PE)). 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 http://azia.geekandproud.co.uk BP Profit Calculator
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 . 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 Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator
Devlin Fox Occam's Razor Combine	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? -- "I worship barmaids; the Bringers of Beer"
Anticide Caldari The Knights Templar	Posted - 2007.10.02 00:51:00 - [46] excellent work azia, wonderful spreadsheet! A++++
Helevorn Feanaro	Posted - 2007.10.03 12:38:00 - [47] Thanks for making this avaialable. I use it all the time.
Lei Marginale Ex Coelis Hydra Alliance	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 . ---- --- -- - I don't use a signature...
Mallinthas Amarr Black Thorne Corporation Elemental Fusion	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 . thanks for your comments negative ME/PE should work already, I will check that though and get back to you. Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator

Eleme Guardian Angels Corp 1	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. Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery
Fubar Eagle Eye Inc.	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... thanks anyway! Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery
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://oldforums.eveonline.com/?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://oldforums.eveonline.com/?a=topic&threadID=650828&page=2#42 yup! i snagged it last night not got round to running my queries yet. thanks anyway Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery
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://oldforums.eveonline.com/?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? Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery
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 "=MarginReqRuns" to "=MarginReqRuns*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 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.