Pages: 1 [2] 3 4 5 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Miarmo Shimuro
|
Posted - 2009.02.16 15:49:00 -
[31]
MY EYES. they are blinded by the COLOR
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.02.16 18:31:00 -
[32]
Heh, not like you can't easily change it any way you see fit. I needed some "in your face" colours in there as a default, so that you wouldn't accidentally change something vital, not wanting to lock the sheet in any way though (not even temporarily).
_ Create a character || Fit a ship || Get some ISK |
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.02.19 21:30:00 -
[33]
NOTE :
T2 module manufacture quantities are a bit "off". T2 ships and T2 rigs are fine.
Apparently, for T2 module manufacture advanced materials and components are NOT affected by waste, since they are considered "extra materials", as opposed to "raw materials". However, I am unable to locate the proper attribute anywhere in the database dumps. Still, it's no BIG deal... since you will either be manufacturing off a BPO (in which case, you should get perfect build anyway) *or* you will be manufacturing from invented BPCs, in which case the price of the BPC run itself will be much, much higher than the difference in manufacture costs from listed and actual.
_ Create a character || Fit a ship || Get some ISK |
Daosus
Caldari
|
Posted - 2009.02.25 23:43:00 -
[34]
I might be blind or something, but is there a way to calculate profit for multiple runs? I tested Antimatter Charge S, and the install cost is killing the calculations.
Either way, this is a great sheet. Thank you for your hard work.
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.02.26 09:27:00 -
[35]
You can simply modify the install cost to zero (or to 1000 / number of runs) manually, it's on one of the yellow spaces
_ Create a character || Fit a ship || Get some ISK |
Daosus
Caldari
|
Posted - 2009.02.26 09:40:00 -
[36]
Originally by: Akita T You can simply modify the install cost to zero (or to 1000 / number of runs) manually, it's on one of the yellow spaces
Yeah, I knew that, I was just wondering if it was prebuilt. I didn't want to fiddle around in case I broke something. Kind of a complicated sheet ;) Nonetheless, easily the best calc I've seen. Thank you much!
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.02.26 11:05:00 -
[37]
That's why I picked those eye-hurting color codes in the first place... so you can easily determine what you can and can't touch and not risk breaking it
_ Create a character || Fit a ship || Get some ISK |
Pwnage Star
|
Posted - 2009.02.26 12:19:00 -
[38]
bump
|
Tekota
|
Posted - 2009.03.11 17:35:00 -
[39]
Originally by: Daosus I might be blind or something, but is there a way to calculate profit for multiple runs? I tested Antimatter Charge S, and the install cost is killing the calculations.
Either way, this is a great sheet. Thank you for your hard work.
Ahhhh, so that's why :) Thanks, was wondering how anyone made any profit on ammo :D
Already alluded to below, but just added another couple of cells, one for "Number of Runs", and one for "Base Install Cost" - this one is just what you'd ordinarily put in the "Install Cost" field. Then change the "Install Cost" cell (B23) from a free text entry to a formula of "=BaseInstallCost/NumberOfRuns" (ie. replace with whatever cells you're holding those figures in).
But anyway, huge props to Akita - this is v. v. handy :D
Oh, and if anyone was wondering, it works just fine in OpenOffice too.
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.03.19 22:03:00 -
[40]
It works even if you shove it in google spreadsheets apparently _ Create a character || Fit a ship || Get some ISK |
|
Tekota
|
Posted - 2009.03.20 08:59:00 -
[41]
Hey there,
I *think* that there maybe something a bit out on calculating required mineral quantities with a Prod Eff skill of less than 5. With Prod Eff at 5 everything checks out, but lower ranks in this skill don't seem to be as devastating in the spreadsheet as they are in game.
Example: Vexor Blueprint, ME0/PE0: Isogen required (game): Prod Eff IV - 6151, Prod Eff V - 5884 Isogen required (sheet): Prod Eff IV - 5911, Prod Eff V - 5884
Vexor Blueprint, ME25/PE0: Isogen required (game): Prod Eff IV - 5637, Prod Eff V - 5370 Isogen required (sheet): Prod Eff IV - 5371, Prod Eff V - 5370
I've run this with a handful of different prints and see the same sort of thing, Prod Eff settings in the sheet work fine at level V (which lets face it, is where it should be) but seem over optimistic at lower levels. Checked this on versions 1.03 and 1.04 of the sheet too.
There undoubtedly exists the possibility that I simply fail at driving spreadsheets of course :D
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.03.20 09:34:00 -
[42]
Nope, you are correct. Cell B26 (material waste percentage) had an incorrect formula, I have adjusted it now. Version 1.05 uploading in a couple of minutes.
_ Create a character || Fit a ship || Get some ISK |
Tekota
|
Posted - 2009.03.20 10:16:00 -
[43]
Talk about quick turnaround :o) Thank you :o) Small but heartfelt pressie in the Eve post.
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.04.20 14:20:00 -
[44]
One month keepalive bump !
EVE issues|Mining revamp|Build stuff|Make ISK |
Dav Varan
|
Posted - 2009.04.24 14:21:00 -
[45]
On the question of material that have waste applied versus extra materials that dont have waste.
Just a hunch but could it be related to the recycle of the t2 mod in question ?
looking at the item database I notice that some construction items you dont get back in a reprocess , could these be the "extra materials" that don't have the waste equation applied ?
|
HillAnt
Amarr HillAnt Corp
|
Posted - 2009.05.11 20:16:00 -
[46]
bump for a an excellent spreadsheet --- HillAnt corp website for entrepeneurs |
WhoKillingWho
|
Posted - 2009.05.11 20:39:00 -
[47]
First, I would like to say thank you for the work you have done. However, I have a few questions for you.
1. Is there a way to re-order the item list so its more friendly to item catagorys, similar to market file structure? or was there some reasoning for the current listing order that I am missing?
2. I noticed this sheet works well for doing 1 stage of production. Is there a way for this sheet to handle multi stage productions? If not can this be added in? Example: To make the T2 part you need to manu the T1 part, the construction componants, and one of the types of R.A.M.'s. Is there a way to adapte your sheet to use either the "Manufacture cost, buying mats from sell orders" OR "Manufacture cost, buying mats from buy orders" of say the T1 item in the T2 item production cost?
|
Sidrat Flush
Caldari Life is Experience
|
Posted - 2009.05.11 22:11:00 -
[48]
Originally by: WhoKillingWho First, I would like to say thank you for the work you have done. However, I have a few questions for you.
1. Is there a way to re-order the item list so its more friendly to item catagorys, similar to market file structure? or was there some reasoning for the current listing order that I am missing?
2. I noticed this sheet works well for doing 1 stage of production. Is there a way for this sheet to handle multi stage productions? If not can this be added in? Example: To make the T2 part you need to manu the T1 part, the construction componants, and one of the types of R.A.M.'s. Is there a way to adapte your sheet to use either the "Manufacture cost, buying mats from sell orders" OR "Manufacture cost, buying mats from buy orders" of say the T1 item in the T2 item production cost?
Hijacked thread, The last time I looked, akita used the vlookup, or merely lookup function which you can only do on alphabetically sorted lists.
The colours are hideous but at least you can change them and if you want to learn A way of creating a functioning spreadsheet, this is a good one.
EXP-L EIO ingame for industry, science, and 3rd party app discussion & EXP-L Eve Industrial Organiser |
Shawn Gallentino
|
Posted - 2009.05.15 00:56:00 -
[49]
Much thanks to you all. I can see the light again with this ME thingy. Negative ME's have a different eq.
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.05.15 02:22:00 -
[50]
Originally by: Sidrat Flush The colours are hideous but at least you can change them and if you want to learn a way of creating a functioning spreadsheet, this is a good one.
That was kind of the whole idea
EVE issues|Mining revamp|Build stuff|Make ISK |
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.06.09 19:18:00 -
[51]
Just a warning for Excel users of the later versions... if you want to update the "prices" sheet, it would be a good idea to disable auto-re-calculations first, otherwise there will be significant "lag" due to the whole sheet updating (especially the sorting according to profit, that's the most CPU-intensive section). HOW TO DO IT : IMAGE LINK (42kb GIF) Once you have finished updating prices, you can set it to auto-calc again in the same place. Depending on Excel version (or other spreadsheet program you prefer to use), location of option may vary.
|
Setkhan
|
Posted - 2009.06.15 15:31:00 -
[52]
Nice spreadsheet, keep it up |
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.07.19 22:58:00 -
[53]
Monthly keepalive bump !
EVE issues|Mining revamp|Build stuff|Make ISK |
Slave 2739FKZ
|
Posted - 2009.08.10 22:42:00 -
[54]
I'm not sure if you still update this or what, but in case you do... I think the numbers for T2 shield active hardeners are a bit off, probably a known issue?
Awesome tool anyway, thanks for this!
|
Akita T
Caldari Navy Volunteer Task Force
|
Posted - 2009.08.11 01:00:00 -
[55]
I'm waiting for the post-rigsize-patch to redo the datadump filtering and merger into the XLS, no point in doing it earlier (patch should be in a week or two tops, I hope).
EVE issues|Mining revamp|Build stuff|Make ISK |
Slave 2739FKZ
|
Posted - 2009.08.11 14:16:00 -
[56]
Allright.
May I suggest to include ME/PE columns in the price sheet in a future version? I guess if its not done is because of effort but never hurts asking
|
quygen
Minmatar Acting Neutral
|
Posted - 2009.09.06 14:05:00 -
[57]
Originally by: Akita T I'm waiting for the post-rigsize-patch to redo the datadump filtering and merger into the XLS, no point in doing it earlier (patch should be in a week or two tops, I hope).
Very nice, can't seem to get MySql working myself. Thx for converting it into a Excel sheet. How are you doing on the lage/med/small rig thingy?
Please resize your sig to a maximum of 400 x 120 - Mitnal
^ You seen it CCP =) Now go fix! |
Akita T
Caldari Caldari Navy Volunteer Task Force
|
Posted - 2009.09.06 22:46:00 -
[58]
Yeah, been caught up with other priorities, and was planning a rewrite/optimisation alongside this "data dump update", so I didn't get around to make it... yet. Soon™ ?
_
Info about our corp | Beginer's ISK making guide | Manufacturer's helper |
Kiay Stryx
Gallente Phoenix Mandate Phoenix Virtue
|
Posted - 2009.09.07 21:13:00 -
[59]
Originally by: Akita T NOTE :
T2 module manufacture quantities are a bit "off". T2 ships and T2 rigs are fine.
Apparently, for T2 module manufacture advanced materials and components are NOT affected by waste, since they are considered "extra materials", as opposed to "raw materials". However, I am unable to locate the proper attribute anywhere in the database dumps. Still, it's no BIG deal... since you will either be manufacturing off a BPO (in which case, you should get perfect build anyway) *or* you will be manufacturing from invented BPCs, in which case the price of the BPC run itself will be much, much higher than the difference in manufacture costs from listed and actual.
Well its nice after a long break from Eve to come back and see you're still developing your spreadsheet.
Heres some help. It can be done from invGroups.categoryID
Excuse the code... It was rough coded as I didnt relise I had the same problem until I read up. PHP
if (($BPTech == 2) && ($Itemcatagory == 7)) { // Negative waste calculation if ($BPML < 0) { // IF NONE ARE THESE THEN USE NO WASTE CALCULATION if ($build_category[$counter] != 4) { $build_qntMeQNT[$counter] = $build_qnt[$counter] * $BPRuns; } else if ($build_group[$counter] == 332) { $build_qntMeQNT[$counter] = $build_qnt[$counter] * $BPRuns; } else { $build_ProEff = $build_qnt[$counter] * (0.25 - (0.05 * $SkillProductionEfficiency)); $build_waste = $build_qnt[$counter] * (abs($BPML) + 1) * ($BPBaseWaste / 100); $build_qntMeQNT[$counter] = round(($build_qnt[$counter] + $build_waste + $build_ProEff )) * $BPRuns; } }
// Catagory // 4 All tier 1 materials // 6 ships // 7 Items rigs // 8 Ammo // 9 BP // 16 skills // 17 tier 2 matierals general tool datacore refinables // 18 drones // 23 pos stuff // 24 reactions // 25 ore // 32 subsystems // 34 sleeper stuff
|
Akita T
Caldari Caldari Navy Volunteer Task Force
|
Posted - 2009.09.07 22:31:00 -
[60]
It is a bit confusing, yes. That category list at the bottom, I suppose that's not the itemcategory but the build_category(x) ? Because if it's the former, that this would be the loop for T2 rigs negative ME waste only, if I read it right... so it must be the latter. And if it's the latter, what's build_group(332) ? Is that the "extra" material ? The one NOT affected by waste at all ? Yeah, confusing, a bit...
_
Info about our corp | Beginer's ISK making guide | Manufacturer's helper |
|
|
|
|
Pages: 1 [2] 3 4 5 :: one page |
First page | Previous page | Next page | Last page |