Pages: 1 2 3 4 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Lore Varan
Caltech Shipyards
|
Posted - 2010.04.30 02:54:00 -
[1]
UNDER CONSTRUCTION... goddam forums ate my post
Caltech Shipyards
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.04.30 03:00:00 -
[2]
Edited by: Lore Varan on 30/04/2010 03:00:36 reserved
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.04.30 03:19:00 -
[3]
reserved
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.04.30 03:37:00 -
[4]
reserved
|
Ghanid
|
Posted - 2010.04.30 08:32:00 -
[5]
Errr, do you really mean OpenOffice 3.3? I have the latest version which is only 3.2
|
Dav Varan
|
Posted - 2010.04.30 13:09:00 -
[6]
Originally by: Ghanid Errr, do you really mean OpenOffice 3.3? I have the latest version which is only 3.2
Fixed typo , thanks.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.04.30 20:48:00 -
[7]
Edited by: Lore Varan on 30/04/2010 20:53:17
The Summary Sheet & Macro Functionality
The summary sheet The four buttons on the left. a.k.a. Show me the money buttons.
Lists all the inventions jobs in the invent sheet and sorts them by Profit or Profitability
Non Macro Workaround.
1.Copy the entire Invention sheet. 2.Paste into a new spreedsheet or subsheet. 3.Sort away to your hearts content.
Do not sort the invention sheet itself , this will almost certainly stop the sheet from working.
Either way remember that the profitability column assumes that you can sell all the items you build. For low sales volume items - this value is missleading.
Purchase and build summary Button
Simply lists all the materials you need to buy. Followed by the amount of each subcomponent you need to build. Followed by the amount of each finished product you need to build.
Includes the build cost - for subcomponents and finished products.
Copy and paste this into eve notepad.
Non Macro Workaround.
Copy and paste into a new sheet , the "make" and "buy" sheets deleted columns / rows as neccesaary.
Apply Button
This repaints the spreadsheet with the colours / borders / background colours / fonts and number formats you specify.
The 7 boxes to the right of the button are where you specify fonts/colors/borders etc. Just use the standard spreadsheet format cell options to alter these cells.
The 4 boxes to the left of the button are where you specify number formats.
Iskcolumns > the number format of all *(except buysheet.value) columns that contain isk values These isk values are usually quite large and dont need isk cents by default and negative values in red.
Intcolumns > the number format of most non isk columns , no decimal places by default and negative values in black.
Floating point columns > isk cents included in format , only used in the buy sheet value column and the download sheets.
Percentage columns > How to display a percentage , only applied to chance column in Invent sheet.
Non Macro Workaround.
Apply any formats you want manually.
Other Macro Buttons
"Optimise columns" - Makes all the columns on the sheet the optimal width. This is a shortcut for - unprotect sheet > apply optimal column width > reprotect sheet.
"Copy best to make sheet" on the Invention Sheet.
This goes through each best method in the sheet and copys the values for ( m.e. , p.e. and Invention costs ) to the make sheet. These values can of course be copied manually if you are just interested in a few items.
Note.
If you want to build some t2 items from a BPO you have and you do not want your values for m.e. , p.e. , misc cost overwritten for that item do the following.
unprotect the make sheet. Place a #Mark or "." in front of the items name in the first column reprotect the make sheet.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.04.30 22:25:00 -
[8]
Edited by: Lore Varan on 30/04/2010 22:29:41
The Download Sheets
Eve-Metrics and Eve-Central download sheets both work the same way. Eve-Central has a volumes column whereas Eve-Metrics doesnt but it does have a simulated value , which is imo the besst value to take.
Reset Button Clears the sheet and builds a fresh list of every item that a price can be obtained for.
Drop down Select the region you want prices for.
Eve-Metrics / Eve-Central Button This fetches the pricing data from the relevant websites. This will cause the sheet to lag out while the prices are downloaded.
Apply Prices Applys the value in the formula column for each item to the rest of the spreadsheet.
Formula to Apply Enter into the box the formula you would like to apply to the download data or leave blank for the default formula. Any cells selected in the formula should be on the line above the header. This gets altered as the formula is copied down the sheet in the same manner as regular copy and paste of spreadsheet formula's
By default Eve-Central sheet uses the highest value of Average Buy orders or minimum sell orders. By default Eve-Metrics sheet uses the highest of the Simulated prices ( buy or cell )
Clicking reset copys your new formula into the formula box for each item.
Optimising
Its not neccessary to download a full list each time. Once a full download has been performed and those prices applied you can cut out rows you dont want to upate each time you download.
Maybe just have the minerals and moon goo as regular downloads. You can alter the formula for individual items if you wish. Beware that pressing reset will remove these customisations.
Copy and paste your optimised download list into a spare sheet. That way when you do need to do a full download refresh , you can paste you optimised list back in afterwards.
Questions or bug reports
Please post any queries about the sheet in here rather than in-game mail.
Regards Lore Varan.
|
Stafen
Killer Koalas
|
Posted - 2010.05.01 19:13:00 -
[9]
This topic deserves a reply, especially as I have been thinking of making similar spreadsheets myself. They look very complete, with a nice at a glance list of the most profitable items.
Making the spreadsheets in openoffice is nice as it's free, no need to acquire a version of excel. (even though using excel's xml import functions makes importing data trivial)
The macros are visual basic, and you can inspect the source code, so someone can easily verify nothing is amiss. It takes a bit of time to import the prices though, CPU is not at 100% and it does fetch them in batches of 19, so the bottle neck is probably the server.
|
Emporer Norton
|
Posted - 2010.05.01 20:47:00 -
[10]
Nice set of sheets thank you
|
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.05.02 16:11:00 -
[11]
Originally by: Stafen This topic deserves a reply, especially as I have been thinking of making similar spreadsheets myself. They look very complete, with a nice at a glance list of the most profitable items.
Making the spreadsheets in openoffice is nice as it's free, no need to acquire a version of excel. (even though using excel's xml import functions makes importing data trivial)
The macros are visual basic, and you can inspect the source code, so someone can easily verify nothing is amiss. It takes a bit of time to import the prices though, CPU is not at 100% and it does fetch them in batches of 19, so the bottle neck is probably the server.
Yeah the download is not great. On my quad core cpu runs at 25% while downloading which leads me to believe that OO only supports single core operation.
I decided to use OO basic ( very similar to VB :) ) to do the macros as the macro code can travel with the spreadsheets. Anyone with OO Basic or Visual basic experiance will find it easy to check out the code before running it.
The other way to do XML imports in OO is to use XML Filters, but they need to be installed independantly by the user afaik.
Basically what happens is the XML returned by the server is opened as a new CSV spreadsheet ( invisible ) then the macro code parses the the spreadsheet to extract the required info.
Not the most efficient way to do it , But it works.
There is a 3rd method of getting XML into OO using a component known as the SAX parser. I am going to have a play around with it these next couple of weeks to see if I can get the download working more smoothly.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.05.07 15:48:00 -
[12]
Bumpage
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.05.17 13:10:00 -
[13]
Bumpage
|
Jobby
Minmatar Sebiestor tribe
|
Posted - 2010.05.17 14:33:00 -
[14]
Looks quite useful, will certainly be checking this out. :-)
Thanks.
|
Kordel Trask
|
Posted - 2010.05.17 23:51:00 -
[15]
Very Nice,
I too appreciate the open office format and the open visual basic.
Thanks for the open office docs on behalf of those who don't have MS office. (I have both installed)
The Visual Basic. That's a big benefit for those of us trying to figure out how everything works for ourselves.
Thanks for all of the work and sharing it.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.07.21 13:55:00 -
[16]
Bump before the lock
|
Bad Princess
Minmatar
|
Posted - 2010.08.05 13:26:00 -
[17]
Black on dark blue is impossible to read.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.08.05 13:36:00 -
[18]
Originally by: Bad Princess Black on dark blue is impossible to read.
Theres should be no black on dark blue in the sheet by default!
Are you using Open Office 3.2 or another version ?
That said you can apply whatever colours you like by pressing the apply button on the summary sheet. Apply your own colours to the input cells next to that button.
If that does not work then you can allways apply colours with the standard format tools of the spreed sheet.
The headers are dark blue and the text color in them is automatic. If this is not working properly then try making the text color white and hitting the aply button.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.08.25 15:17:00 -
[19]
Bumpage
|
Jeddeita
Lead Farmers
|
Posted - 2010.08.26 09:13:00 -
[20]
Many thanks for the work you have put into this. Just one question - does the invention profit/day take into account the % chance of a invention job working? Just need to know so I don't mess up my maths :) ---------- EVEStuff.net - High Quality Corp & Alliance Web Hosting |
|
Cerrano
Caldari
|
Posted - 2010.08.26 09:24:00 -
[21]
This sheet looks promising, I'll take a closer look when I'm home from work. But it looks like it covers what I've been looking for. Thanks.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.08.26 19:09:00 -
[22]
Originally by: Jeddeita Many thanks for the work you have put into this. Just one question - does the invention profit/day take into account the % chance of a invention job working? Just need to know so I don't mess up my maths :)
Yes percentage chance is taken into account.
Of course this makes it an averaged value that can be expected over many runs.
Specifically.
( Invent Costs / Percentage Chance / Output runs ) = Invent costs per run ( Manufacturing cost is calculated on the me of the output bpc of the invention )
Then Total Build Cost per finished item = Invention costs per run + Manufacturing Costs.
Profitability = ( Product Value - Total Build Cost per finished Item ) / Manufacturing Time.
So the profitability relates to the time taken up in the manufacturing slots. This beacause invention is a much quicker process than manufacturing and is rarelly the bottleneck.
|
JASON W0RTHING
The Devolved
|
Posted - 2010.08.26 21:24:00 -
[23]
Hi,
I just had a question about the cost calculations that you are using. You said you use the higher of the values for calculating build cost. I find this to be somewhat inaccurate. When using invention programs and such with market aggregating tools such EVE-central or EVE Metrics I find the best way to approximate the profitability of an item at a glance is to use minimum sell price, for both buying and selling items. This way you are essentially calculating revenue for an item off what you would sell it for 0.01 isking, and what you would buy materials for from the cheapest jita-market supplier. I have found these calculations to be reasonably reliable in determining profitability.
I just wanted to know your rationale behind the method you chose for cost calculations.
Originally by: CCP Shadow What is thy bidd -- Wait. This thread, I have an irresistible urge to lock it for "being related to neither crime nor punishment."
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.08.26 23:32:00 -
[24]
Originally by: JASON W0RTHING Hi,
I just had a question about the cost calculations that you are using. You said you use the higher of the values for calculating build cost. I find this to be somewhat inaccurate. When using invention programs and such with market aggregating tools such EVE-central or EVE Metrics I find the best way to approximate the profitability of an item at a glance is to use minimum sell price, for both buying and selling items. This way you are essentially calculating revenue for an item off what you would sell it for 0.01 isking, and what you would buy materials for from the cheapest jita-market supplier. I have found these calculations to be reasonably reliable in determining profitability.
I just wanted to know your rationale behind the method you chose for cost calculations.
Subcomponents.
A subsomponent's value is assesed as the higher of build cost or market price.
Initially before i released the sheets the subcomponent price was just taken to be the build cost due to the me of the print being used.
When I added the profitibility column , the sheet showed for example. Building a charon. A nice profit build the subs. And a nice profit building the charon.
When added togethor the total profit made no sense and was out of whack with what i was making.
I realised I had the same profit showing in 2 rows. Both in the subcomponent row and the final product row.
So I changed the formula to take the higher of buildcost | market value as the value of the sub.
This then shows the profit correctly. Some of the profit is on the subcomponent. Some of the profit is on the final build.
If you want to see all the profit on the final build , zero out the market value of the subcomponent and hash out the typeid so that the download sheets dont overwrite the zerod out price.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.08.26 23:51:00 -
[25]
Originally by: JASON W0RTHING Hi,
I just had a question about the cost calculations that you are using. You said you use the higher of the values for calculating build cost. I find this to be somewhat inaccurate. When using invention programs and such with market aggregating tools such EVE-central or EVE Metrics I find the best way to approximate the profitability of an item at a glance is to use minimum sell price, for both buying and selling items. This way you are essentially calculating revenue for an item off what you would sell it for 0.01 isking, and what you would buy materials for from the cheapest jita-market supplier. I have found these calculations to be reasonably reliable in determining profitability.
I just wanted to know your rationale behind the method you chose for cost calculations.
Market prices from download sheets.
These are customisable.
I take simulated from eve-metrics ( the price required to sell/buy 5% of the entire market iirc ) and higer of ( average buy | minimum sell ) from eve-central.
The prices downloaded are for a region. minimum sell can be misleading on a region level. e.g. The forge. There may be a sell order for 27 trit in Friggi @1.9isk. Whereas buyers are buying in jita for 2.3isk.
What is the value of trit ?
I tried to find a formula that is a good fit for a lot of different products.
raw materials , subs , finished products.
Its perfectly possible to set up the sheet to always take minimum sell price.
In the download formula box create a formula that simple links to the cell on the same row as itself in the minumum sell column.
Press reset. Press download.
You may find minimum sell works well for some items. For other items it wont be accurate.
Each item can have its own different formula if you want to make the sheet really accurate.
e.g. For trit you could use average buy price. And for Absolution you could use minimum sell price.
just change the formula in the yellow box in each items row.
These customised formula stay in place when you next download as long as you dont press reset.
pressing reset will use the formula in the default formula box for each row. If there is no formula there . ie it has been cleared by teh user then the sheet substitutes my default formula.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.08.27 01:50:00 -
[26]
Originally by: JASON W0RTHING Hi,
I just had a question about the cost calculations that you are using. You said you use the higher of the values for calculating build cost. I find this to be somewhat inaccurate. When using invention programs and such with market aggregating tools such EVE-central or EVE Metrics I find the best way to approximate the profitability of an item at a glance is to use minimum sell price, for both buying and selling items. This way you are essentially calculating revenue for an item off what you would sell it for 0.01 isking, and what you would buy materials for from the cheapest jita-market supplier. I have found these calculations to be reasonably reliable in determining profitability.
I just wanted to know your rationale behind the method you chose for cost calculations.
The sheet has 2 major functional area's
Calculating material requirements ( purchases ).
In this the sheet should be 100% spot on accurate at all times.
When you have run all your builds and inventions you should have a nice empty input hangar.
Profit Evaluation.
Is a somewhat greyer area.
This sheet is not a ledger system , it is not calculating profit after the fact with accurate inputs.
The purchases total should be fairly accurate to within a percent. Assuming prices are not fluctuating wildly.
As far as the profit per item columns go in both the make sheet and inventions sheets.
These are predicted values based on the assumption that market prices are relativelly stable over the build time.
In making these predictions and setting aside market price fluctuations the rationale has allways been to make a cautous assesment.
|
Val Ashir
|
Posted - 2010.08.27 08:28:00 -
[27]
Edited by: Val Ashir on 27/08/2010 08:35:30 Awesome spreadsheet
Ive been using the modules spreadsheet and i get macro errors when i changed the formula in the eve-central sheet to eliminate non-buyable items. atm it sits as =IF(sellmin=0;999999999; IF(RIGHT(TRIM(item name);2)="II";MAX(buymax;sellmin);MAX(AVERAGE(buymax;MIN(sellmed;sellavg));AVERAGE(I18;MIN(K18;L18))))) which works what i wanted to do was return it as N/A in the first IF condition if the item lacked sell orders.
I also added a new column in the make sheet. It shows the magnitude of the average of of sell/buy orders as a log function and the ratio between sell and buy orders.
Oh i also messed with your bpc names, i put the 1run/300run at the front instead of the back so its easier to see and allows me to shrink the column width.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.08.27 13:36:00 -
[28]
Edited by: Lore Varan on 27/08/2010 13:45:14
Originally by: Val Ashir Edited by: Val Ashir on 27/08/2010 08:35:30 Awesome spreadsheet
Ive been using the modules spreadsheet and i get macro errors when i changed the formula in the eve-central sheet to eliminate non-buyable items. atm it sits as =IF(sellmin=0;999999999; IF(RIGHT(TRIM(item name);2)="II";MAX(buymax;sellmin);MAX(AVERAGE(buymax;MIN(sellmed;sellavg));AVERAGE(I18;MIN(K18;L18))))) which works what i wanted to do was return it as N/A in the first IF condition if the item lacked sell orders.
I also added a new column in the make sheet. It shows the magnitude of the average of of sell/buy orders as a log function and the ratio between sell and buy orders.
Oh i also messed with your bpc names, i put the 1run/300run at the front instead of the back so its easier to see and allows me to shrink the column width.
Use
=IF(I2=0;NA(); IF(RIGHT(TRIM(A2);2)="II";MAX(E2;I2);MAX(AVERAGE(E2;MIN(K2;L2));AVERAGE(I2;MIN(K2;L2)))))
How did you get the volume information into the make sheet ? LOOKUP are are you diddling with the macros as well ?? :)
Glad you getting good use out of it.
Good idea on the bpc names. If I ever manage to get around to v1.1 I'll make that the default.
|
Val Ashir
|
Posted - 2010.08.27 17:02:00 -
[29]
Edited by: Val Ashir on 27/08/2010 17:06:11 The volume column i made uses uses 2 additional columns to look everything up. They fetch the buy/sell volumes using =VLOOKUP(TypeID;'Eve-Central'.$B$4:$M$1314;12) for the sell volume and =VLOOKUP(Typeid;'Eve-Central'.$B$4:$M$1314;7) for the buyvolume. then its just =LEFT(LOG(AVERAGE(buyvol;sellvol));4)&", "&LEFT(sellvol/buyvol;3) in a visible column beside the other stuff
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.09.14 16:34:00 -
[30]
Bumpage |
|
PDJames
|
Posted - 2010.09.23 17:44:00 -
[31]
Nice work. Very useful and comprehensive. |
Lore Varan
Caltech Shipyards
|
Posted - 2010.09.28 19:15:00 -
[32]
V1.1 Inbound
Added A HTML export for the purchase/build list that can be viewed in the IGB with autosexxylinkies for view market details.
Not quite there yet, but if your using this sheet then check back here occasionally for the update.
|
Taesith
|
Posted - 2010.09.28 20:10:00 -
[33]
There's an error in the build material/cost for co-processor IIs. It's missing the tech 2 components.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.09.28 20:45:00 -
[34]
Originally by: Taesith There's an error in the build material/cost for co-processor IIs. It's missing the tech 2 components.
Thanks. I'll get that sorted in 1.1
|
Daldia
|
Posted - 2010.11.05 18:53:00 -
[35]
Excellent tool Lord Varan! Thanks for all of your work. |
Proton Power
Amarr Kaira Innovations
|
Posted - 2010.11.06 15:48:00 -
[36]
Edited by: Proton Power on 06/11/2010 15:54:22 Very nice tool. I do have a few questions though:
How does it calculate build price for invention. Does it go off if I build all mats myself or if I buy them?
Seems to me T2 Sentry Drones have a very high build cost compared to actual build cost which is why I am asking.
---
Double checked, under the make colum it has correct build cost for a Garde T2, but under invention build cost it is like 3 times higher, showing that you make little to no isk to produce them via invention. Kinda confused on that.
|
L'Implacabile
|
Posted - 2010.11.06 20:12:00 -
[37]
very very useful and easy to use thanks Lore you did a nice job here!
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.07 02:36:00 -
[38]
Originally by: Proton Power Edited by: Proton Power on 06/11/2010 15:54:22 Very nice tool. I do have a few questions though:
How does it calculate build price for invention. Does it go off if I build all mats myself or if I buy them?
Seems to me T2 Sentry Drones have a very high build cost compared to actual build cost which is why I am asking.
---
Double checked, under the make colum it has correct build cost for a Garde T2, but under invention build cost it is like 3 times higher, showing that you make little to no isk to produce them via invention. Kinda confused on that.
The price it uses for all sub components is the higher of value or build cost.
If you dont want it to use market value of subs then delete all the entrys in the value field for subcomponents.
The build cost in the invention sheet also includes the cost of the invention attempts.
The make sheet does not have the invention cost unless you press the "copy best to make sheet" button, At which point the miscellaneous cost fields in the make sheet is populated with the invention cost per run, also the me and pe are setup by this.
You can copy the values manually if you want to.
After pressing "copy best to make" then the price shown in the invention sheet and make sheet should match.
Sorry for hld up in v1.1 I have been really busy, but hopefully will find some time to get it done soon.
|
Proton Power
Amarr Kaira Innovations
|
Posted - 2010.11.07 05:11:00 -
[39]
Originally by: Lore Varan
Originally by: Proton Power Edited by: Proton Power on 06/11/2010 15:54:22 Very nice tool. I do have a few questions though:
How does it calculate build price for invention. Does it go off if I build all mats myself or if I buy them?
Seems to me T2 Sentry Drones have a very high build cost compared to actual build cost which is why I am asking.
---
Double checked, under the make colum it has correct build cost for a Garde T2, but under invention build cost it is like 3 times higher, showing that you make little to no isk to produce them via invention. Kinda confused on that.
The price it uses for all sub components is the higher of value or build cost.
If you dont want it to use market value of subs then delete all the entrys in the value field for subcomponents.
The build cost in the invention sheet also includes the cost of the invention attempts.
The make sheet does not have the invention cost unless you press the "copy best to make sheet" button, At which point the miscellaneous cost fields in the make sheet is populated with the invention cost per run, also the me and pe are setup by this.
You can copy the values manually if you want to.
After pressing "copy best to make" then the price shown in the invention sheet and make sheet should match.
Sorry for hld up in v1.1 I have been really busy, but hopefully will find some time to get it done soon.
I am probably not grasping somthing. When looking at build cost in the first sheet it says about 260k which is just about perfect. Then I goto invention sheet, costs about 1.4mil per invention with about 50%, so 2.8mil for 1 10 run bpc = about 280k per run cost, which so far adds up
So you add the build cost 260k + 280k = 540k, they sell for about 900k so should be about 4mil profit per bpc. But shows a loss. All the prices for build materials and sell price of the t2 drone is correct. The only thing that is off is the build cost, shows 850k. Not sure how it even comes close to that number, that is 3 times the build cost, and if that included inventino costs still 2 times. And its the same problem with ammo and a few other items. Somethign is way off with your build costs.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.08 01:46:00 -
[40]
I just check Garde II on the Drone Sheet
I got recent prices from Eve Metric Using the default price for The 1500 input bpc of 1,000,000
All skills at 5
Invention Cost of 2,907,414 for 50% chance of me-4 pe-4 10 run
Cost per run shows 576,868 Item Build Cost shows 870,027
This is 293,159 for the Manufacturing.
293,159 Manu + 576,868 Invention = 870,027
Garde II value ( on make sheet from Eve metrics ) = 932,682
932,682 - 870,027 = 62655 profit per unit.
This is the same as what it shows on Invention sheet
I checked make sheet with me -4 and that shows 293,159 for manu alone
So all the numbers add up.
It might be that you have acciedntally broken the sheet?
Avoid sorting or cutting and pasting rows Avoid dragging input values from 1 input to another if the sheet is unprotected Copy and paste of values should be ok.
Try a fresh sheet just for garde and see if you get the right price.
|
|
Proton Power
Amarr Kaira Innovations
|
Posted - 2010.11.08 13:51:00 -
[41]
Originally by: Lore Varan I just check Garde II on the Drone Sheet
I got recent prices from Eve Metric Using the default price for The 1500 input bpc of 1,000,000
All skills at 5
Invention Cost of 2,907,414 for 50% chance of me-4 pe-4 10 run
Cost per run shows 576,868 Item Build Cost shows 870,027
This is 293,159 for the Manufacturing.
293,159 Manu + 576,868 Invention = 870,027
Garde II value ( on make sheet from Eve metrics ) = 932,682
932,682 - 870,027 = 62655 profit per unit.
This is the same as what it shows on Invention sheet
I checked make sheet with me -4 and that shows 293,159 for manu alone
So all the numbers add up.
It might be that you have acciedntally broken the sheet?
Avoid sorting or cutting and pasting rows Avoid dragging input values from 1 input to another if the sheet is unprotected Copy and paste of values should be ok.
Try a fresh sheet just for garde and see if you get the right price.
Okay bolded what I was missing, did not realize it used 1mil per bpc, that is the same problem I am having with the ammo as well.
Is it possible to change that 1mil to 100k?
|
Dav Varan
|
Posted - 2010.11.08 16:02:00 -
[42]
The values for input bpc values are held in Input cells.
You can change them to be whatever you think is best.
You have to do them manually though because Eve-Metrics / Eve-Central can not download prices for these items as they are not sold on the market.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.08 21:44:00 -
[43]
Edited by: Lore Varan on 08/11/2010 21:44:38
Version 1.1 Released
Fixes
Fixed Co-processor II
There were some T2 components missing from the T2 Co-Pro build. This I traced back to the datadump I have been using to generate the sheets. ( The data in these sheets is generated by a SQL script against a MySQL Database )
I downloaded the latest dump and this seems to have cleared up the issue with co-pro II.
Alterations
Replaced the "In Production" column with a "Purchase" column in the make sheet. These cells are used to tell the spreadsheet to include purchases of choosen items in the purchase and build summary. subcomponents needed or raw materials needed are reduced accordingly.
Changed Input BPc Names from xxxxxxx 1 run | xxxxxx 30 runs to 1 run xxxxxxx | 30 run xxxxxxx
etc.
New Feature
Added a new button "Purchase and Build HTML"
This generates the same output as the Purchase and Build Summary Button.
But instead of displaying on screen the Summary is generated as a HTML ( Web Browser ) File.
The folder of files created will be
Windows = <My Documents>\EveIMMS\
Mac = <Home Directory>/EveIMMS/
An index of all files is also created.
Both URLs ( On the Local File System ) are displayed in the Summary sheet output area.
I recommend copying the Index URL and Pasting it into the IGB. Then Bookmark.
This way you never have to copy and paste again to locate your Purchase and Build Summaries.
Why use the IGB ?
The Purchase and build summary is displayed as a table.
The first column is Quantity of item required for your builds. .Double click this to select the value .Right click and select copy
The second column contains the item name. Clicking on the name opens the market screen at the selected item.
Its then simply a job of starting a buy order and pasting the quantity into it.
The only thing you have to set manually is the price you want to pay.
I find this simplyfies the purchasing process greatly.
|
Proton Power
Amarr Kaira Innovations
|
Posted - 2010.11.08 22:36:00 -
[44]
Edited by: Proton Power on 08/11/2010 22:42:32 Sorry to keep asking questions just trying to use this great tool
Does your ammo for total profit show that you get 5000 per run or 4 per run? Seems to me its a bit lower
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.09 11:23:00 -
[45]
Batch size is taken into account.
On the make sheet. You enter the quantity of an item you want. The sheet tells you how many runs on a bp you will need to do to get at least that many. All subsequent calcs for expendeture , mat reqs are based of the number of runs.
So you put in I want to make 3000 barrage small. This requires 1 run on a small barrage bp.
All calcs are based off doing 1 run on a barrage bp.
Of course you end up ingame with 5000 units , not 3000 because 5000 is the batch size.
On the invent sheet.
Invention cost is cost to make 1 attempt at invention ( batch size irrelevant ) Cost per run is ( Invention cost per output run recieved ) again batch size irrelevant
Item build cost is the cost for a single finished item ( batch size is relevant here )
Formula for calc is Item build cost = ( Invent cost [per output bpc run] + build cost [for a batch of items] ) / Batch size
Profit per Item ( This is for a single item ) its the value specified in the make sheet ( for a single item ) - Item build cost ( also single item )
Profitablity takes into account batch size.
It is Profit per item / time taken to produce 1 run * batch size.
|
Proton Power
Amarr Kaira Innovations
|
Posted - 2010.11.09 13:02:00 -
[46]
Perfect!
One suggestion as an add on for the next version maybe, make a colum next to the 1 day profit, and put a Total BPC Profit colum as well.
Basicly take runs*build profit should come out right.
|
freshspree
|
Posted - 2010.11.14 17:14:00 -
[47]
I have a question, does training d caldari starship skill and mech engineering increase ur chances of getting an invention done? thx
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.14 23:57:00 -
[48]
Originally by: freshspree I have a question, does training d caldari starship skill and mech engineering increase ur chances of getting an invention done? thx
For Inventing Caldari Ships yes |
Waeb LongFellow
|
Posted - 2010.11.17 18:23:00 -
[49]
Wanted to first say thanks for this excellent tool. As a new inventor this has helped in learning how its done and making the math alot easier.
I was curious though the spreadsheet under the buy sheet doesnt show datacores that are needed. Is this intended? Does it still take the cost of those into account?
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.17 22:45:00 -
[50]
Originally by: Waeb LongFellow Wanted to first say thanks for this excellent tool. As a new inventor this has helped in learning how its done and making the math alot easier.
I was curious though the spreadsheet under the buy sheet doesnt show datacores that are needed. Is this intended? Does it still take the cost of those into account?
Datacores are in the spreadsheet. There in the buy sheet , scroll down a bit They only appear as purchase requirements if you signify you are making an invention attempt in the invent sheet "All methods" table.
|
|
Waeb LongFellow
|
Posted - 2010.11.17 23:08:00 -
[51]
Thanks i was missing the all methods spot.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.24 18:14:00 -
[52]
Bumpage
|
Pound Cakeee
|
Posted - 2010.11.30 07:06:00 -
[53]
Hey there, in the "make" section I have some questions about a few columns that do nothing. Maybe I don't know what they are for. Insight would be great. The Columns are the following Quantity( doesn't change the profit per day??? Why) In Stock Purchase #BPO Cheers!
|
Barbicane
TGUN Industries
|
Posted - 2010.11.30 08:48:00 -
[54]
Edited by: Barbicane on 30/11/2010 08:48:32 This looks very promising. I've been searching for an invention aid which checks for the most profitable combination of decryptor and meta item.
I did get a runtime error while importing prices from Eve Central. See here: http://eve-files.com/dl/233374
This happened just after I had opened my own OpenOffice spreadsheet while doing the Eve Central import from your spreadsheet. I don't know if that had anything to do with it. My own production spreadsheet is fairly simple and doesn't contain any macros.
(I will retry the Eve Central import later)
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.30 16:13:00 -
[55]
Originally by: Pound Cakeee Hey there, in the "make" section I have some questions about a few columns that do nothing. Maybe I don't know what they are for. Insight would be great. The Columns are the following Quantity( doesn't change the profit per day??? Why) In Stock Purchase #BPO Cheers!
Quantity( doesn't change the profit per day??? Why)
Profit per day is a estimated value based on me/pe of blueprint. It the amount of money you can potentially make if you run 1 production line for 1 day with the BP.
Quantity ( that you want to make ) does not affect this estimation.
In Stock
Here you signify to the sheet if you allready have a number of the item in your hangar. Anything you specify here will be removed from purchase or build requirement and hense minerals or moon goo you need to buy.
Purchase
Similar to instock , except if you use this column the amount specified appear in purchase and build summaries.
#BPO
The number of BPO's of this type that you own. ALters the number of days to complete build calculation.
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.11.30 16:18:00 -
[56]
Originally by: Barbicane Edited by: Barbicane on 30/11/2010 08:48:32 This looks very promising. I've been searching for an invention aid which checks for the most profitable combination of decryptor and meta item.
I did get a runtime error while importing prices from Eve Central. See here: http://eve-files.com/dl/233374
This happened just after I had opened my own OpenOffice spreadsheet while doing the Eve Central import from your spreadsheet. I don't know if that had anything to do with it. My own production spreadsheet is fairly simple and doesn't contain any macros.
(I will retry the Eve Central import later)
Yes I have seen this error too. Happens if the macro is stopped before completion at any point and then run again.
Not sure why it happens yet. If you get this.
.Save the sheet .Close and reopen the sheet. .run the import again.
Allow the import to complete before doing other stuff with oo.
|
Barbicane
TGUN Industries
|
Posted - 2010.12.03 18:19:00 -
[57]
Originally by: Lore Varan
Yes I have seen this error too. Happens if the macro is stopped before completion at any point and then run again.
Not sure why it happens yet. If you get this.
.Save the sheet .Close and reopen the sheet. .run the import again.
Allow the import to complete before doing other stuff with oo.
Cheers. I will give that a try. Thanks for sharing your work!
|
Heralda Zorn
|
Posted - 2010.12.07 19:40:00 -
[58]
I'm looking greedly foreward for the next updated Version of you Sheets
|
Lore Varan
Caltech Shipyards
|
Posted - 2010.12.10 13:00:00 -
[59]
Originally by: Heralda Zorn I'm looking greedly foreward for the next updated Version of you Sheets
I think I'll be doing a minor release before Chrimbo to add
1.Noctis to the manufacture section 2.A markup modifier to the purchase / build summary
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.01.28 17:31:00 -
[60]
bump
|
|
NanoVolt
|
Posted - 2011.02.01 22:36:00 -
[61]
bump
|
Saphir Grey
|
Posted - 2011.02.15 16:31:00 -
[62]
Thanks for a nice and useful production sheet.
Have a little question. Was looking at a cell in the make sheet. The cost of building a carrier didn't add up with my other calc on the same thing. The ore amount was the same. But not the cost. So i removed protection of the table and got this: =(F142+SUM(B.C1826:C1837))
Can't figure out what sum() is looking at. What is the B.C1826:C1837.
I have managed to get the sheet to get the same price by removing market cost of the components. But i cant let go of the fact that i don't have a clue how the cell work
|
Lorisa Varan
|
Posted - 2011.02.16 16:08:00 -
[63]
Originally by: Saphir Grey Thanks for a nice and useful production sheet.
Have a little question. Was looking at a cell in the make sheet. The cost of building a carrier didn't add up with my other calc on the same thing. The ore amount was the same. But not the cost. So i removed protection of the table and got this: =(F142+SUM(B.C1826:C1837))
Can't figure out what sum() is looking at. What is the B.C1826:C1837.
I have managed to get the sheet to get the same price by removing market cost of the components. But i cant let go of the fact that i don't have a clue how the cell work
There is a hidden sheet called "B"
B.C1826:C1837 is a range of cells in that sheet. SUM() tells the spreadsheet to add all the values together.
The "B" sheet is a work sheet generated by a SQL script.
It contains the lines for each item that goes into the manufacturing of a thing.
In this case it will be all the capital components that go into the contruction of a carrier.
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.02.25 18:39:00 -
[64]
Version 1.2 Released
Fixes
Fixed the issue with download failing if other 00 component was used while downloading.
Alterations
Removed the Eve-Metrics Download sheet bye bye Eve-Metrics and thanks for all the fish
New Feature
Added Noctis Added Starbase Structures
Added new columns in Invention Sheet
Batch size ( The batch size of the output Blueprint ). Profit per BPc ( The total profit for manufacturing from an output BPc )
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.03.07 19:07:00 -
[65]
Bump.
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.03.12 20:30:00 -
[66]
Version 1.21 Released.
Fixes.
Found a weird bug that caused certain values ( in the range 250,000 - 350,000 ) to become massive values when written into Either of the Purchase and Build Summaries.
This was down to a Maths error in the Open Office Currency Maths Routines.
Fixed the bug by changing the Buildup Modifier from a Currency Datatype to a Double ( Floating point ) datatype.
1.21 is linked as Version 1.2 in the Original Post.
Self Fix
If you dont wanna download the new version and copy all your data across you can fix the bug by doing the following.
Open Spreadsheet. Select Tools > Macros > Organise Macros > OpenOffice.org Basic
Click in the left hand panel Your spreadsheet name > Standard > module1
Click the Edit button on the right The Macro code window will open
In the Macro Window Select Edit > Find and Replace
In the Search for Box put Dim Markup as Currency
In the Replace with box put Dim Markup as Double
Then click replace all
You should get a message saying 2 replacements were made.
Close the macro code window Save the spreadsheet
|
Odor Spice
|
Posted - 2011.03.13 21:10:00 -
[67]
Edited by: Odor Spice on 13/03/2011 21:15:32 If I update prices it will **** up the spreadsheet so hard it's unuseable.. Don't really know how to make work, i waited like half and our and still super laggy.
Okay for some reason it now worked, but i cannot figure out how to make the prices right. (yes i suck i know)
Picture of the Spreadsheet
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.03.14 01:05:00 -
[68]
Originally by: Odor Spice Edited by: Odor Spice on 13/03/2011 21:15:32 If I update prices it will **** up the spreadsheet so hard it's unuseable.. Don't really know how to make work, i waited like half and our and still super laggy.
Okay for some reason it now worked, but i cannot figure out how to make the prices right. (yes i suck i know)
Picture of the Spreadsheet
Looks like the formula to apply is broken.
Clear the Formula to apply and hit reset.
As far as it taking ages to download and lagging out I know its fairly bad. OO doesnt come with nice built in functions to download XML so its a bit hashed together but it gets the values eventually.
Be careful with prices from eve central they are not as accurate as eve metrics used to be.
|
Odor Spice
|
Posted - 2011.03.14 15:25:00 -
[69]
Originally by: Lore Varan
Originally by: Odor Spice Edited by: Odor Spice on 13/03/2011 21:15:32 If I update prices it will **** up the spreadsheet so hard it's unuseable.. Don't really know how to make work, i waited like half and our and still super laggy.
Okay for some reason it now worked, but i cannot figure out how to make the prices right. (yes i suck i know)
Picture of the Spreadsheet
Looks like the formula to apply is broken.
Clear the Formula to apply and hit reset.
As far as it taking ages to download and lagging out I know its fairly bad. OO doesnt come with nice built in functions to download XML so its a bit hashed together but it gets the values eventually.
Be careful with prices from eve central they are not as accurate as eve metrics used to be.
well the only reason i use OO is because the spreadsheet is completely bugged in excel, the buttons isnt there and more..
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.03.14 16:50:00 -
[70]
Originally by: Odor Spice
well the only reason i use OO is because the spreadsheet is completely bugged in excel, the buttons isnt there and more..
OO is the spreadsheet to use.
What I was trying to say is You're not doing anything wrong.
The laggyness of the download affects everyone using the sheet. The download is not very good. You dont have to use it , but even as crap as it is its still better than typeing it 5,000 differenct prices.
Check the first few post for tips on optimizing the download.
You can alter the list of downloaded items so there not so much to do each time.
For instance once you have prices for all the meta items in you dont need to download these each time.
So make the list reflect only the items you are interested in building and there sub components and materials there made off.
|
|
Odor Spice
|
Posted - 2011.03.15 16:26:00 -
[71]
Originally by: Lore Varan
Originally by: Odor Spice
well the only reason i use OO is because the spreadsheet is completely bugged in excel, the buttons isnt there and more..
OO is the spreadsheet to use.
What I was trying to say is You're not doing anything wrong.
The laggyness of the download affects everyone using the sheet. The download is not very good. You dont have to use it , but even as crap as it is its still better than typeing it 5,000 differenct prices.
Check the first few post for tips on optimizing the download.
You can alter the list of downloaded items so there not so much to do each time.
For instance once you have prices for all the meta items in you dont need to download these each time.
So make the list reflect only the items you are interested in building and there sub components and materials there made off.
since im pretty noob at Excel/OO i can't figure out how to optimize it :D
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.03.16 11:17:00 -
[72]
Originally by: Odor Spice Edited by: Odor Spice on 15/03/2011 19:21:13 Fail
Please tell me how the sheet can get prices so off! :D
some of them are like 900 million per slot or something stupidly off. even prices for normal items are off :( I checked most prices and all seem normal.
The sheet is like any spreadsheet, It does the maths for you. It does the maths based on the values you give it to work on. Bad values in = Bad values out.
Eve-Central is not a reliable source of information like Eve-Metrics used to be. A lot of the values coming back from eve-central are garbage.
YOU need to check them.
|
UfoTRADER
Relentless Technologies Quod Erat Demonstrandum
|
Posted - 2011.03.17 04:39:00 -
[73]
Edited by: UfoTRADER on 17/03/2011 04:39:44
Originally by: Odor Spice
Fail
Please tell me how the sheet can get prices so off! :D
some of them are like 900 million per slot or something stupidly off. even prices for normal items are off :( I checked most prices and all seem normal.
In the prior comment about the inaccurate values, the problem pricing was invul field ii's. They were priced several hundred billion, which once fixed caused all of the incorrect pricing to appear normal. Granted normal may be 5-10% off, but it's a good starting point to see what may be good to sell in the next few hours. If you are expecting a spreadsheet to do all of work, you're going to be sorely disappointed.
Notice I didn't reference lazy, whiny or unappreciative at all in my comments.
|
Hanna Magiliska
|
Posted - 2011.03.18 16:31:00 -
[74]
Lots of love for this set of spreadsheets.
A small (!) request: What are the chances of getting the Outpost Platform blueprints handled? If Isk would lubricate the wheels, then let me know how much.
Cheers
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.03.19 14:38:00 -
[75]
Originally by: Hanna Magiliska Lots of love for this set of spreadsheets.
A small (!) request: What are the chances of getting the Outpost Platform blueprints handled? If Isk would lubricate the wheels, then let me know how much.
Cheers
Try this
Outposts dont have a market group ( cant be sold on the market ) so they are excluded from the spreadsheet by default as the script used to build the sheet needs a marketgroup id to complete succesfully.
I wedged the outposts in by giving them a pretend marketgroup called "outposts".
stuck them in the starbase spreadsheet as this seems like the most logical place to put them.
Let me know if it works ok as I have no clue about building these things and dont know if it all makes sense.
As far as isk goes. The sheets are provided free with no guarantee of fitness for purpose or any guarantee.
However having said that any isk donations are allways welcome :)
Whatever it is worth to you.
|
UfoTRADER
Relentless Technologies Quod Erat Demonstrandum
|
Posted - 2011.04.14 15:59:00 -
[76]
Don't lock me bro
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.04.25 16:20:00 -
[77]
Bump.
|
Minarete
Amarr
|
Posted - 2011.04.26 13:20:00 -
[78]
These might be nice... but when I opened them and ran in to the black on dark blue row that did not allow me to see whats what and it was locked... I closed them and moved on, they may be something useful, but I dont know, cant see crap.
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.05.03 14:01:00 -
[79]
Originally by: Minarete
These might be nice... but when I opened them and ran in to the black on dark blue row that did not allow me to see whats what and it was locked... I closed them and moved on, they may be something useful, but I dont know, cant see crap.
Can you post a screenie of what you have?
There should be no black on dark blue. Colors should be as seen in the screenshot ( Original post ).
Which version of O.O. are you using ?
|
Raven Ballhammer
|
Posted - 2011.05.12 16:31:00 -
[80]
Thanks for your all your hard work. These spreadsheets work really well. One question-is it possible to import from our market logs, rather than the unreliable eve-central?
|
|
LuckyQuarter
Gallente Lucky Galactic Expeditions
|
Posted - 2011.05.12 23:19:00 -
[81]
something wrong w/ the eve-files hosting site (at least today)...always stops download partially through...please consider hosting files somewhere else.
|
Samuel Miner
Caldari Perilous Expedition
|
Posted - 2011.05.26 04:49:00 -
[82]
Does your profit per day not take into account how many BPO's you enter? I don't see how the profit can remain unchanged if you increase throughput. Also, you should factor in volume traded in jita in your profit per day. It does no good to be able to build 1000 gizmo's in a day if only 10 are actually being sold each day.
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.05.26 13:40:00 -
[83]
Edited by: Lore Varan on 26/05/2011 13:44:41
Originally by: Samuel Miner Does your profit per day not take into account how many BPO's you enter? I don't see how the profit can remain unchanged if you increase throughput. Also, you should factor in volume traded in jita in your profit per day. It does no good to be able to build 1000 gizmo's in a day if only 10 are actually being sold each day.
The profit per day column is intended as a guide to compare one product to another at a glance, In order to help people decide what to build.
It is an estimation of the total profit available at current prices ( purchases and sales ) for commiting one manufacturing line to the task for 1 day.
It is like this because manu slots are a limited resource for any player and showing most profitable constuction enables player to max out the money they make from munufacturing.
It could be that you spend 1 day building X ( slow seller ) and 9 days building Y ( fast seller ) and sell all products made in 10 days.
It is not meant to be an accurate prediction of how much money you will end up with.
Sorry that too complicated to predict.
As you say volumn comes into the equation. So does sales stratergy. Sell as fast as you build / build differing items and trickle sell etc etc. So do price fluctuations over the total constuction time due to supply and demand.
|
Samuel Miner
Caldari Perilous Expedition
|
Posted - 2011.05.26 16:24:00 -
[84]
Originally by: Lore Varan Edited by: Lore Varan on 26/05/2011 13:44:41
Originally by: Samuel Miner Does your profit per day not take into account how many BPO's you enter? I don't see how the profit can remain unchanged if you increase throughput. Also, you should factor in volume traded in jita in your profit per day. It does no good to be able to build 1000 gizmo's in a day if only 10 are actually being sold each day.
The profit per day column is intended as a guide to compare one product to another at a glance, In order to help people decide what to build.
It is an estimation of the total profit available at current prices ( purchases and sales ) for commiting one manufacturing line to the task for 1 day.
It is like this because manu slots are a limited resource for any player and showing most profitable constuction enables player to max out the money they make from munufacturing.
It could be that you spend 1 day building X ( slow seller ) and 9 days building Y ( fast seller ) and sell all products made in 10 days.
It is not meant to be an accurate prediction of how much money you will end up with.
Sorry that too complicated to predict.
As you say volumn comes into the equation. So does sales stratergy. Sell as fast as you build / build differing items and trickle sell etc etc. So do price fluctuations over the total constuction time due to supply and demand.
Yeah, I know there is a lot too it. Don't get me wrong, I love these sheets. They are very clean and organized. It would be handy though if we could at least see the volume traded somewhere on the sheet and also a page for sorting profitable t1 production (with volume). I think the information is there, it just needs sorted and moved around. I suck with excel ^.^ Anyway, good stuff.
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.05.26 19:50:00 -
[85]
Originally by: Samuel Miner
Originally by: Lore Varan Edited by: Lore Varan on 26/05/2011 13:44:41
Originally by: Samuel Miner Does your profit per day not take into account how many BPO's you enter? I don't see how the profit can remain unchanged if you increase throughput. Also, you should factor in volume traded in jita in your profit per day. It does no good to be able to build 1000 gizmo's in a day if only 10 are actually being sold each day.
The profit per day column is intended as a guide to compare one product to another at a glance, In order to help people decide what to build.
It is an estimation of the total profit available at current prices ( purchases and sales ) for commiting one manufacturing line to the task for 1 day.
It is like this because manu slots are a limited resource for any player and showing most profitable constuction enables player to max out the money they make from munufacturing.
It could be that you spend 1 day building X ( slow seller ) and 9 days building Y ( fast seller ) and sell all products made in 10 days.
It is not meant to be an accurate prediction of how much money you will end up with.
Sorry that too complicated to predict.
As you say volumn comes into the equation. So does sales stratergy. Sell as fast as you build / build differing items and trickle sell etc etc. So do price fluctuations over the total constuction time due to supply and demand.
Yeah, I know there is a lot too it. Don't get me wrong, I love these sheets. They are very clean and organized. It would be handy though if we could at least see the volume traded somewhere on the sheet and also a page for sorting profitable t1 production (with volume). I think the information is there, it just needs sorted and moved around. I suck with excel ^.^ Anyway, good stuff.
I will take a look into it. Though this may take some time.
L4D2 > Eve Battles > Eve Industry > Eve spreadsheets atm :P
|
Mikal Tash
|
Posted - 2011.05.27 05:29:00 -
[86]
Does this work in Excel or only open office? I downloaded, but I don't see buttons to update or any source code.
hrm, let me keep working it over...
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.05.27 13:49:00 -
[87]
Originally by: Mikal Tash Does this work in Excel or only open office? I downloaded, but I don't see buttons to update or any source code.
hrm, let me keep working it over...
Excel will open it , but bad colors and no macro support.
Use 0O.
|
Saratonias
|
Posted - 2011.06.07 23:56:00 -
[88]
Thank you for this excellent spreadsheet.
I have one question, is there a formula that I can use to update the current stock on each item from another sheet?
I want to export my assets (typeID, Count) from jEveAssets and import them into a new sheet. typeIDs may be repeated so the counts should be summed for each typeID in the new sheet.
|
Dav Varan
|
Posted - 2011.06.08 14:16:00 -
[89]
Edited by: Dav Varan on 08/06/2011 14:21:07
Originally by: Saratonias Thank you for this excellent spreadsheet.
I have one question, is there a formula that I can use to update the current stock on each item from another sheet?
I want to export my assets (typeID, Count) from jEveAssets and import them into a new sheet. typeIDs may be repeated so the counts should be summed for each typeID in the new sheet.
You need the SUMIF Function
SUMIF(test_range; condition; sum_range)
put the function in the first stocklevel row
test_range should point to the column of typeid's in your sheet and should use absolute addressing.
test_range would be something along the lines of YourSheetName.$A$1:$A$1000 assuming typeid is the first col in your sheet
condition would point to the type id col in the buy sheet with a relative reference Something like H3
sum_range should point to the quantity column in your sheet and should use absolute addressing.
so sum_range would be something along the lines of YourSheetName.$B$1:$B$1000 assuming quantity is the second col in your sheet
After putting the function in the first stock level row you should be able to copy and paste it into the rest of the stock level rows
|
Saratonias
|
Posted - 2011.06.08 20:27:00 -
[90]
Originally by: Dav Varan Edited by: Dav Varan on 08/06/2011 14:21:07
You need the SUMIF Function
SUMIF(test_range; condition; sum_range)
put the function in the first stocklevel row
test_range should point to the column of typeid's in your sheet and should use absolute addressing.
test_range would be something along the lines of YourSheetName.$A$1:$A$1000 assuming typeid is the first col in your sheet
condition would point to the type id col in the buy sheet with a relative reference Something like H3
sum_range should point to the quantity column in your sheet and should use absolute addressing.
so sum_range would be something along the lines of YourSheetName.$B$1:$B$1000 assuming quantity is the second col in your sheet
After putting the function in the first stock level row you should be able to copy and paste it into the rest of the stock level rows
Thanks! Worked like a charm!
|
|
Commander Kulkov
The Drake Project Drake Directorate
|
Posted - 2011.06.09 03:40:00 -
[91]
I will definitely check this out! Thanks! |
Tax Investigator
Interstellar Trading Company
|
Posted - 2011.07.08 21:54:00 -
[92]
Well done. really like it, specialy because i can check the formulas and adjust prices if needed.
Thank you very much |
raukosen
|
Posted - 2011.07.09 19:58:00 -
[93]
I must be missing something here because I don't get any of the numbers to add up.
When I take the cost of the datacores, multiply by how many I need for one invention attempt and then divide by the invention chance I don't get the exact number that's listed under "cost per run" (not using decryptors or meta x items). Worse, when I check the "cost per item" on a higher BPC run it's not a multiple of the first number.
A 1 run BPC gives a 1 run T2 BPC and a 300 run BPC gives a 10 run T2 BPC, invention chance is the same. The "cost per item" should exactly ten times less because I get ten more runs per successful attempt. Instead it's approx. five times less, but still a bit more than that!
AFAIK the sheet doesn't take the BPC cost into account either so that can't be it. |
Lore Varan
Caltech Shipyards
|
Posted - 2011.07.11 09:54:00 -
[94]
Originally by: raukosen I must be missing something here because I don't get any of the numbers to add up.
When I take the cost of the datacores, multiply by how many I need for one invention attempt and then divide by the invention chance I don't get the exact number that's listed under "cost per run" (not using decryptors or meta x items). Worse, when I check the "cost per item" on a higher BPC run it's not a multiple of the first number.
A 1 run BPC gives a 1 run T2 BPC and a 300 run BPC gives a 10 run T2 BPC, invention chance is the same. The "cost per item" should exactly ten times less because I get ten more runs per successful attempt. Instead it's approx. five times less, but still a bit more than that!
AFAIK the sheet doesn't take the BPC cost into account either so that can't be it.
The BPC cost are taken into account. You will find there valuations in the Buy sheet ( Scroll down )
There are some very rough approximate guesses in place for BPC values.
Put in your own values for more accurate results.
|
raukosen
|
Posted - 2011.07.11 23:24:00 -
[95]
Ah ok thnx Now it makes sense
|
Lore Varan
Caltech Shipyards
|
Posted - 2011.09.06 19:59:00 -
[96]
Bump |
|
|
|
Pages: 1 2 3 4 :: [one page] |