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

Author	Thread Statistics \| Show CCP posts - 0 post(s)
TekRa	Posted - 2003.09.06 14:33:00 - [1] Excellent work Dirus' > With the lights out it's less dangerous.
TekRa Brutor tribe	Posted - 2003.09.06 14:33:00 - [2] Excellent work Dirus' sig.
TekRa	Posted - 2003.09.06 14:35:00 - [3] 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 - [4] 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.
TekRa	Posted - 2003.09.06 15:00:00 - [5] 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 - [6] 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.

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.