EVE Search - Ore/Mineral Spreadsheet for all you Miners and Refiners

Pages: [1] 2 :: one page
Author	Thread Statistics \| Show CCP posts - 0 post(s)
Dirus	Posted - 2003.09.06 02:50:00 - [1] Edited by: Dirus on 06/09/2003 02:53:40 Have you ever wondered what each ore is actually worth? Which ore actually gives you more money per minute? Wonder how much you're mining with all your Mining/Refining skills? Wonder how much all that ore is worth thats sitting in your hangar? Well, here is an Excel spreadsheet I first made in Beta to help me with all those questions. Its been updated for the new skills and stuff, and is almost perfectly accurate, from what I know of. Click here to see it, its fully customizable to fit your character and ship's stats. Note: Due to the Mining Drone skill not working properly ingame, leave it as level 0 in the spreadsheet to get the proper results. (Sticky? ) ********** Everyone deserves to die. You go first.
Dirus	Posted - 2003.09.06 02:50:00 - [2] Edited by: Dirus on 06/09/2003 02:53:40 Have you ever wondered what each ore is actually worth? Which ore actually gives you more money per minute? Wonder how much you're mining with all your Mining/Refining skills? Wonder how much all that ore is worth thats sitting in your hangar? Well, here is an Excel spreadsheet I first made in Beta to help me with all those questions. Its been updated for the new skills and stuff, and is almost perfectly accurate, from what I know of. Click here to see it, its fully customizable to fit your character and ship's stats. Note: Due to the Mining Drone skill not working properly ingame, leave it as level 0 in the spreadsheet to get the proper results. (Sticky? )
Azov	Posted - 2003.09.06 03:35:00 - [3] thx for the spreadsheet this is a nice tool
Azov The New Empire	Posted - 2003.09.06 03:35:00 - [4] thx for the spreadsheet this is a nice tool
Zarina	Posted - 2003.09.06 07:00:00 - [5] Very nice. I love it. I have to point out one mistake on your mining laser yield calculation. It should be the following... =IF(B22=0,0,(C22(1+0.05B6)(1+0.05B7))) That will come out with the same skill-adjusted mining amount shown in the game.
Zarina	Posted - 2003.09.06 07:00:00 - [6] Very nice. I love it. I have to point out one mistake on your mining laser yield calculation. It should be the following... =IF(B22=0,0,(C22(1+0.05B6)(1+0.05B7))) That will come out with the same skill-adjusted mining amount shown in the game.
RaBiDdoG	Posted - 2003.09.06 11:39:00 - [7] Crap now i have to put office back on.
RaBiDdoG Cskillzone	Posted - 2003.09.06 11:39:00 - [8] Crap now i have to put office back on.
Angelsfist	Posted - 2003.09.06 12:00:00 - [9] Thanks Dirus, I was setting up to make a speadsheet similer to yours. Thanks, for saving me the trouble. bluemonster.us is a good site in game for quick ore calculations as well.
Angelsfist Justice.	Posted - 2003.09.06 12:00:00 - [10] Thanks Dirus, I was setting up to make a speadsheet similer to yours. Thanks, for saving me the trouble. bluemonster.us is a good site in game for quick ore calculations as well.
Havoc1710	Posted - 2003.09.06 12:40:00 - [11] Its good, i like it, and its usefull as well. And to add a bit to Zarina's correction. it should be: =IF(B22=0,0,(C22(1+0.05B6)(1+0.05$B$7))) Ceo Aquitaine Space Conglomerate
Havoc1710 Caldari	Posted - 2003.09.06 12:40:00 - [12] Its good, i like it, and its usefull as well. And to add a bit to Zarina's correction. it should be: =IF(B22=0,0,(C22(1+0.05B6)(1+0.05$B$7)))
TekRa	Posted - 2003.09.06 14:33:00 - [13] Excellent work Dirus' > With the lights out it's less dangerous.
TekRa Brutor tribe	Posted - 2003.09.06 14:33:00 - [14] Excellent work Dirus' sig.
TekRa	Posted - 2003.09.06 14:35:00 - [15] Quote: Very nice. I love it. I have to point out one mistake on your mining laser yield calculation. It should be the following... =IF(B22=0,0,(C22(1+0.05B6)(1+0.05B7))) That will come out with the same skill-adjusted mining amount shown in the game. Quote: Its good, i like it, and its usefull as well. And to add a bit to Zarina's correction. it should be: =IF(B22=0,0,(C22(1+0.05B6)(1+0.05$B$7))) why just add the $'s ? they are only usefull fi you 'drag' to fill in formulae. (and going along those lines, you'd also want to make it: =IF(B22=0,0,(C22(1+0.05$B$6)(1+0.05$B$7))) > With the lights out it's less dangerous.
TekRa Brutor tribe	Posted - 2003.09.06 14:35:00 - [16] Quote: Very nice. I love it. I have to point out one mistake on your mining laser yield calculation. It should be the following... =IF(B22=0,0,(C22(1+0.05B6)(1+0.05B7))) That will come out with the same skill-adjusted mining amount shown in the game. Quote: Its good, i like it, and its usefull as well. And to add a bit to Zarina's correction. it should be: =IF(B22=0,0,(C22(1+0.05B6)(1+0.05$B$7))) why just add the $'s ? they are only usefull fi you 'drag' to fill in formulae. (and going along those lines, you'd also want to make it: =IF(B22=0,0,(C22(1+0.05$B$6)(1+0.05$B$7))) sig.
Dirus	Posted - 2003.09.06 14:49:00 - [17] Edited by: Dirus on 06/09/2003 15:01:33 what do those $ do again? i only know basic excel :P Thanks for the info tho, didnt know the astro and mining skill multiply edit: omg, noticed a massive bug with the drone info... gonna be fixed very soon :D ********** Everyone deserves to die. You go first.
Dirus	Posted - 2003.09.06 14:49:00 - [18] Edited by: Dirus on 06/09/2003 15:01:33 what do those $ do again? i only know basic excel :P Thanks for the info tho, didnt know the astro and mining skill multiply edit: omg, noticed a massive bug with the drone info... gonna be fixed very soon :D
TekRa	Posted - 2003.09.06 15:00:00 - [19] Edited by: TekRa on 06/09/2003 15:04:43 $'s are used when a formula is copied, eg =A1 the row and colomn may change (a relative reference) =A$1 row is constant, colomn may change =$A1 colomn is constant, row may change =$A$1 both row and colomn remain constant (an absolute reference) > With the lights out it's less dangerous.
TekRa Brutor tribe	Posted - 2003.09.06 15:00:00 - [20] Edited by: TekRa on 06/09/2003 15:04:43 $'s are used when a formula is copied, eg =A1 the row and colomn may change (a relative reference) =A$1 row is constant, colomn may change =$A1 colomn is constant, row may change =$A$1 both row and colomn remain constant (an absolute reference) sig.
Shock	Posted - 2003.09.06 15:01:00 - [21] Here is a very nice ingame calculator for ores, minerals and some other stuff. --- soonÖ
Shock Caldari	Posted - 2003.09.06 15:01:00 - [22] Here is a very nice ingame calculator for ores, minerals and some other stuff. --- soonÖ
Dirus	Posted - 2003.09.06 15:04:00 - [23] one reason i didnt want to convert this to PHP is because XLS saves the info you type in (if you save the file to your hard drive) ********** Everyone deserves to die. You go first.
Dirus	Posted - 2003.09.06 15:04:00 - [24] one reason i didnt want to convert this to PHP is because XLS saves the info you type in (if you save the file to your hard drive)
Dirus	Posted - 2003.09.06 15:27:00 - [25] Ok, updated it. Fixes: Mining/Astro skills properly add up. Drone info shown properly. Formulas updated with $ signs (jeez.. if i knew what those did, it would have saved me a lot of time...) ********** Everyone deserves to die. You go first.
Dirus	Posted - 2003.09.06 15:27:00 - [26] Ok, updated it. Fixes: Mining/Astro skills properly add up. Drone info shown properly. Formulas updated with $ signs (jeez.. if i knew what those did, it would have saved me a lot of time...)
Dirus	Posted - 2003.09.17 05:43:00 - [27] New Version! :) New layout, hopefully less confusing. Added a part to the Ore calculation chart, so you can set a mineral Demand, and see how much ore you need to satisfy it. (negative means you have excess minerals) Have fun :D ********** Everyone deserves to die. You go first.
Dirus	Posted - 2003.09.17 05:43:00 - [28] New Version! :) New layout, hopefully less confusing. Added a part to the Ore calculation chart, so you can set a mineral Demand, and see how much ore you need to satisfy it. (negative means you have excess minerals) Have fun :D
BlackIceWolf	Posted - 2007.03.08 00:22:00 - [29] Page is down, is there another place for the spreadsheet or a new up to date one?
Vivus Mors	Posted - 2007.03.08 02:48:00 - [30] Edited by: Vivus Mors on 08/03/2007 02:45:13 MEGA necro!!! ------------------------------------------------ Formal request for improvements to industrialism

Pages: [1] 2 :: one page
First page \| Previous page \| Next page \| Last page

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