Pages: 1 2 3 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.26 02:09:00 -
[1]
Hello everyone
Over the past few months I have been working on a calculator that lets me work out the cost of producing any given item. This is the result. Currently there aren't any Tech 2 or COSMOS items included until I can figure out a way of storing the information in the spreadsheet without running out of cells (suggestions on a postcard!).
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.
Blueprint Profit Calculator
Thanks!
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Jei'son Bladesmith
Bladesmith Mining and Development Consortium
|
Posted - 2007.08.27 00:03:00 -
[2]
niiiiiiice, obviously put alotta work into it, looks very handy
question....I've played around with a few Excel spreadsheets for EVE so I know the basics but not the advanced stuff...how do you lock the top section so its stays put while you scroll through the materials list? Thats a handy lil trick, makes it look all uber and professional
☼☼☼ Don't even THINK about it rookie...I have all my capacitor and more hit points than you can POSSIBLY imagine. ☼☼☼
|
Auralis
|
Posted - 2007.08.27 02:53:00 -
[3]
Nice indeed.
No more scribbling on small notes to calculate cost and profit. Yeah, too lazy to make an excel sheet of my own and wouldn't even come close to this one.
Must've taken a lot of effort.
*bows*
|
Ishina Fel
Caldari Synergy. Imperial Republic Of the North
|
Posted - 2007.08.27 06:58:00 -
[4]
Originally by: Jei'son Bladesmith
question....I've played around with a few Excel spreadsheets for EVE so I know the basics but not the advanced stuff...how do you lock the top section so its stays put while you scroll through the materials list? Thats a handy lil trick, makes it look all uber and professional
Click on the line below the line you want to fixate -> menu Window -> fixate window
or thereabouts. My Excel is German :)
|
Kazuo Ishiguro
House of Marbles Zzz
|
Posted - 2007.08.27 10:45:00 -
[5]
The cells used to calculate the build cost of items only seem to take into account the costs of basic minerals. The costs of Morphite, T2 components and other stuff are not included (yes, there are some T1 items that cannot be built without them). My research services Spreadsheets: Top speed calculation - Halo Implant stats |
Shinhan
Phoenix Knights Dark Nebula Galactic Empire
|
Posted - 2007.08.27 10:53:00 -
[6]
Originally by: Ishina Fel
Originally by: Jei'son Bladesmith
question....I've played around with a few Excel spreadsheets for EVE so I know the basics but not the advanced stuff...how do you lock the top section so its stays put while you scroll through the materials list? Thats a handy lil trick, makes it look all uber and professional
Click on the line below the line you want to fixate -> menu Window -> fixate window
or thereabouts. My Excel is German :)
In English Excel its "Freeze Panes".
-- Selling apples, 1 signature each. ѼѼѼѼѼѼѼ |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.27 11:49:00 -
[7]
Originally by: Kazuo Ishiguro The cells used to calculate the build cost of items only seem to take into account the costs of basic minerals. The costs of Morphite, T2 components and other stuff are not included (yes, there are some T1 items that cannot be built without them).
can you give an example please and i'll try and look into it.
Thanks for all your comments, please keep them coming. Its taken me roughly 4 months to get it into the state its in now. i haven't worked on it solidly for all that time, few hours here, a few hours there...
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.27 11:54:00 -
[8]
Originally by: Azia Burgi
Originally by: Kazuo Ishiguro The cells used to calculate the build cost of items only seem to take into account the costs of basic minerals. The costs of Morphite, T2 components and other stuff are not included (yes, there are some T1 items that cannot be built without them).
can you give an example please and i'll try and look into it.
fixed it
new version is now uploaded. i still have a lot of work to do on it.
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Jon Asus
|
Posted - 2007.08.27 16:47:00 -
[9]
For me, a lowly PE 0 manufacturer it seems to be displaying the minerals needed as far too low.
BPO calc pic
|
Jei'son Bladesmith
Bladesmith Mining and Development Consortium
|
Posted - 2007.08.27 17:15:00 -
[10]
Originally by: Shinhan
Originally by: Ishina Fel
Originally by: Jei'son Bladesmith
question....I've played around with a few Excel spreadsheets for EVE so I know the basics but not the advanced stuff...how do you lock the top section so its stays put while you scroll through the materials list? Thats a handy lil trick, makes it look all uber and professional
Click on the line below the line you want to fixate -> menu Window -> fixate window
or thereabouts. My Excel is German :)
In English Excel its "Freeze Panes".
Kewl thanx guys....may your expensive implants be safely stowed in a jumpclone when you next are podded...
☼☼☼ Don't even THINK about it rookie...I have all my capacitor and more hit points than you can POSSIBLY imagine. ☼☼☼
|
|
Zakgram
Atomic Heroes The OSS
|
Posted - 2007.08.27 20:22:00 -
[11]
Edited by: Zakgram on 27/08/2007 20:22:07 I don't see items like Esoteric Data Interface. It's not T2 but I guess it's Cosmos, so I'll pwn myself with a "doh...".
|
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.27 20:58:00 -
[12]
Originally by: Jon Asus For me, a lowly PE 0 manufacturer it seems to be displaying the minerals needed as far too low.
BPO calc pic
thats just plain weird. the data is straight from the REV2 data export. i will look into it for you. thanks for spotting it!
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.27 23:09:00 -
[13]
Edited by: Azia Burgi on 27/08/2007 23:10:17 ok its fixed now, with thanks to Corwin Aren for his uber maths skills and not having a hangover.
i still have to go through it and reimport the production times that got missed in the original transfer.
Azia
edit: spelling --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.28 02:13:00 -
[14]
I've just uploaded new version with the correct production times loaded in. I also tidied up a few other things, added in the Ideal ME calculation. i'm not 100% happy with the formula but its the best i can get it unless someone else has any ideas.
as always, comments are welcome.
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Artemdorius
Gallente Puzzleball Industries
|
Posted - 2007.08.28 12:56:00 -
[15]
Nice looking spreadsheet. I love how you've tracked even rigs and probes, something I haven't been able to find elsewhere!
A noticable problem when opening it in OpenOffice 2.2. Namely that if there is no value for a given component in the Lookup sheet, Calc throws an Error 502 instead of assuming a value of zero. I don't know if you typed in that lookup sheet by hand or imported it from the SQL exports. If the latter, it might not be difficult to massage the SQL export slightly to put zeros in for null values.
As for your ideal ME formula, I personally use one I found over a year ago (don't remember where) that is as follows (I have changed it slightly to fit your sheet):
ROUNDDOWN(MAX(B19:B157)*BPWasteFactor*2;0)
where BPWasteFactor is the waste of the BPO at 0 ME. This is .1 for most BPOs, but some start at 0.05.
This will give you the "perfect" ME. That is, the point where any more ME research will have no effect on the build requirements.
Thanks again for all your hard work!
|
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.28 14:02:00 -
[16]
Edited by: Azia Burgi on 28/08/2007 14:03:11 I've now put in the missing zeros. it was a simple matter of highlighting the data and doing find [ blank ] replace with 0. i personally don't use openoffice so i wasn't aware of that problem.
thanks for the ME formula. i've set it to be 0.1 by default. when they do the next major database change (rev3) i'll include wastage factor in my queries. i am sick of the sight of that damned database . hopefully by then i'll have figured out a way to include COSMOS and T2 without running out of cells.
please keep the comments and suggestions coming!
Azia
edit: spelling --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Therese Law
Gallente
|
Posted - 2007.08.28 15:37:00 -
[17]
Very nice tool Good Job!
But to be a bit greedy and tell you what i miss. Option to t2 material construction, t2 modules and ships.
Then it would be nice to se what a total batch profit will be both % and numbers. You can now se it per unit only.
Giving some kind of "print/copy" section where a overview of the info that you have gatherd. Like you have a sum up in a diffrent sheet and you can just select and copy and then paste it into forums etc.
--
Ofc i am an alt of a shy alliance leader. |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.28 16:23:00 -
[18]
Originally by: Therese Law Very nice tool Good Job!
But to be a bit greedy and tell you what i miss. Option to t2 material construction, t2 modules and ships.
Then it would be nice to se what a total batch profit will be both % and numbers. You can now se it per unit only.
Giving some kind of "print/copy" section where a overview of the info that you have gatherd. Like you have a sum up in a diffrent sheet and you can just select and copy and then paste it into forums etc.
i'm not sure what you mean about a "print/copy" sheet, you can copy and paste the data already. can you explain what you'd like to see with regards to this in a little more detail, please?
the t2 items aren't listed due to physical limitations within excel. all the solutions i can currently think of are very messy and require the user to do a bit of their own manipulation. i want to keep it simple as possible.
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Therese Law
Gallente
|
Posted - 2007.08.28 20:09:00 -
[19]
Originally by: Azia Burgi
Originally by: Therese Law Very nice tool Good Job!
But to be a bit greedy and tell you what i miss. Option to t2 material construction, t2 modules and ships.
Then it would be nice to se what a total batch profit will be both % and numbers. You can now se it per unit only.
Giving some kind of "print/copy" section where a overview of the info that you have gatherd. Like you have a sum up in a diffrent sheet and you can just select and copy and then paste it into forums etc.
i'm not sure what you mean about a "print/copy" sheet, you can copy and paste the data already. can you explain what you'd like to see with regards to this in a little more detail, please?
the t2 items aren't listed due to physical limitations within excel. all the solutions i can currently think of are very messy and require the user to do a bit of their own manipulation. i want to keep it simple as possible.
Azia
Yes i can understand that t2 stuff make things a bit more complicated.
About the "print/copy" option that i had in mind is... You set up a bpo and all the info that is specefic to you. Then you want to share this info with someone els, on a forum or in ingame chat channel. Insteed of writing down all numbers and info it would be easier if you could mark it and copy it and paste it and still get a good overview. When you do it now it looks like this...
Quote:
BPO/BPC InformationYour Skills BP Name:DominixIndustry:0 BP Cost:Production Eff:5 Number Of Runs: Current ME:65Your BPO should be researched to ME783156 to be fully effective. Current PE:
Manufacturing InformationCosting Information Time per run (seconds):180005Cost For 1 Unit:46 350 012 Installation Cost:1000Cost Per Hour:#N/A Cost Per Hour:333Cost Using Current Stock:1 000 No. Runs/Hour:00,2Batch Cost:1 000 Ideal ME:783156Sale Price:50 000 000 Ideal PE:Margin Per Unit:3 649 988 Required Runs:Margin %:8%
Material Information Bill Of MaterialsUnitsCost/UnitCost of 1 ItemMaterial ReqTotal Cost Trit43073562,3310036139,4800 Pyerite10775247,888490889,1200 Mexallon27131524,356606520,2500 Isogen6750183,475634308,4700 Nocxium16815223,843763869,600 Zydrine38501600,156160577,500 Megacyte14094014,465656374,1400
A bit to mutch info and a bit messy to really make something out of it fast and get the fast overview over a bpo. So some kind of copy friendly sum up on the info that is calculated after your settings... But i dont know if this can be done or how :P That is what i meant.
But now when writing this i se that it might not be that needed. Must have been a impulse idea i hade when i tested your sheet out.
But anyway on a diffrent thing the total profit that can be made on x amount of built units would be nice. And tak into account if you use bpc and need to buy them for a price and how that effect the price etc.
--
Ofc i am an alt of a shy alliance leader. |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.08.30 01:38:00 -
[20]
i can't do anything about how it pastes into chat, unfortunately. you'll just have to paste it in little sections. i've added something close to what you asked for, tell me if its not quite what you want.
i also fixed the way it works out ProdTime. i had typo'd the formula.
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
|
Reviera
|
Posted - 2007.08.30 15:46:00 -
[21]
bump for a good thing! more needs to se this and hopefully more updates to improve even more :)
|
Pwett
Minmatar QUANT Corp.
|
Posted - 2007.08.30 16:16:00 -
[22]
Edited by: Pwett on 30/08/2007 16:16:26 Edited by: Pwett on 30/08/2007 16:16:13 I wholly endorse this spp. :)
Really great work - I don't know how excel deals with XML, but if you can figure that out, here's an option for importing current mineral / salvage / datacore / other random prices:
http://www.starvingpoet.net/feeds/mmi.xml
_______________ Pwett CEO and Founder [QTC]QUANT Corp.
|
Azia Burgi
Science and Trade Institute
|
Posted - 2007.09.03 17:07:00 -
[23]
I'm still playing about with the XML feed, not sure excel can cope with it (if anyone has any experience with importing XML into excel please contact me ingame). In the meantime i've added a link to the MMI on the credits page.
not much done on this update, just tided up my formulas ready for when i do an IGB version.
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Vrizuh
Caldari
|
Posted - 2007.09.03 19:17:00 -
[24]
Go ahead. Burn a few orphanages down. You've earned such good karma that nothing can keep you out of the happy bright places now.
|
Azia Burgi
Science and Trade Institute
|
Posted - 2007.09.05 20:37:00 -
[25]
I have added in the two implants that effect manufacturing time. These are the only ones that directly effect the manufacturing process all the other "industrial" implants refer to blueprint research.
I have also added in an estimated TTC section based on the required number of runs.
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Brubeck
|
Posted - 2007.09.07 00:00:00 -
[26]
Edited by: Brubeck on 07/09/2007 00:00:41 Impressive work!
I found an error in the "Cost for 1 Unit" cell though - the formula is:
Mineral Cost + Install Cost + Hourly Run Cost
For items such as ammo that produce multiple runs per hour, this generates a much higher production cost than it actually is.
Mineral Cost + Install Cost/Number of Runs + Hourly Run Cost/Runs per Hour
Should give the correct production cost.
Thanks for putting the spreadsheet together though - it's an extremely useful tool.
|
Azia Burgi
Science and Trade Institute
|
Posted - 2007.09.07 02:19:00 -
[27]
Edited by: Azia Burgi on 07/09/2007 02:21:13 Thanks for pointing this out, sometimes its handy to have a fresh set of eyes look over your work. you can become blind to its shortcoming after you've stared at it for several hours. i've fixed it now, i had to modify your formula otherwise it returned division errors for items with production times over 1 hour.
the formula i have used is as follows: MaterialCost+installcost+(HourlyRunCost*((ProdTime/60)/60))
this converts the ProdTime from whole seconds to decimal hours (1.33333 using the example of a shuttle BPO) then multiplies it by the base HourlyRunCost before adding on the fixed costs.
i still have a few things i want to add to it: * T2/COSMOS items * base wastage factor - not appearing until the next major DB update * proper ammo building calculations (currently it assumes that each run produces 1 unit of ammo where as its 100 units per run) - i have just thought of a solution to this which i might implemented tomorrow when its not 3am * standings and their effects on fixed costs. * ideal PE * ideal ME that doesn't look like i used a random number generator to work it out
thanks for your comments and suggestions, please keep them coming!
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Brubeck
|
Posted - 2007.09.15 02:55:00 -
[28]
Thanks again for the work on the spreadsheet!
Shouldn't the install cost be divided by the total number of runs? As a one time cost per production run, the amount added to each unit would be just a fraction of the full installation cost (unless you were producing just one item).
I produce a lot of ammo and drones, so the difference is noticeable. With larger items, it would be minimal.
|
Azia Burgi
Science and Trade Institute
|
Posted - 2007.09.15 18:16:00 -
[29]
The install cost is fixed no matter now many runs you produce. if you do 700 runs the install cost is still 1000 isk.
i'm aware of the fact it isn't calculating ammo correctly, i'm working on a solution for this.
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
Azia Burgi
Science and Trade Institute
|
Posted - 2007.09.15 22:22:00 -
[30]
I have implemented the fix so it calculates ammo production correctly and included base wastage on the lookup table.
Please keep your comments coming!
Azia --------------------------------------------------
Azia Burgi
http://azia.geekandproud.co.uk |
|
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 Margin*RequiredRuns.
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)*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.
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)*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)
____________ Blue Binary |
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.
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-.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 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 "=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.
|
|
Azia Burgi
Caldari Science and Trade Institute
|
Posted - 2008.01.29 21:39:00 -
[61]
Thank you for spotting this. I will include that change in the next version. I hope to have the next version out sometime this weekend, hopefully saturday but more likely on sunday. It will include the updated export from the Trinity patch. I may also have a solution for the inclusion of T2 and COSMOS items.
There is a web version also bubbling away on the pot.
Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery |
Shonishan
|
Posted - 2008.01.31 13:34:00 -
[62]
no vagabond bpo on the bpo list ?
|
Azia Burgi
Caldari Science and Trade Institute
|
Posted - 2008.01.31 16:13:00 -
[63]
Originally by: Shonishan no vagabond bpo on the bpo list ?
The vagabond is a T2 ship therefore not included along with all T2 items because of size limitations imposed within excel.
Azia Burgi http://azia.geekandproud.co.uk BP Profit Calculator EVE Cemetery |
|
|
|
Pages: 1 2 3 :: [one page] |