EVE Search - The old UES thread (from beta to 1.12)

Author	Thread Statistics \| Show CCP posts - 2 post(s)
Gasparde	Posted - 2004.09.13 12:58:00 - [1] Edited by: Gasparde on 13/09/2004 14:56:03 Edited by: Gasparde on 13/09/2004 13:14:29 I just downloaded the beta of this and started to take a look at it but have 1 question on a calc that i cant figure out. Im on the mining calculator tab with ingredients entered for an Apoc. I have all my resources entered. For Noc on line 8 it shows I still need 29,757 in cell I8. The ore picked is Jaspet (tried all ores there, no change) and in D24 it says I need no batches of Jaspet. Its the only line that doesnt appear to work. Its a great page and Ill probably buy it once I figure out this error im getting :). Edit Did some checking and I must be doing something wrong. This is what I come up with: It shows remaining trit to get as 3,028,057 which is correct based on mineral I have in mineral and ore form. On the basic stats with my skills it shows I get 852 trit per 333 batch of Veldspar. With 3,028,057 remaining divided by 852 per batch that would be 3554 batches but the sheet shows 1067 batches to go. What am I doing wrong? Thanks! EDIT 2 Ahh brainfart. I forgot that other ores will also give trit so its only showing me how much veld I have to mine after mining scordite (which will give me pyrite and trit). The one that shows no batches must be getting enuff minerals from one of the other ores I have to mine. Neat feature! Thanks :)
Gasparde	Posted - 2004.09.13 12:58:00 - [2] Edited by: Gasparde on 13/09/2004 14:56:03 Edited by: Gasparde on 13/09/2004 13:14:29 I just downloaded the beta of this and started to take a look at it but have 1 question on a calc that i cant figure out. Im on the mining calculator tab with ingredients entered for an Apoc. I have all my resources entered. For Noc on line 8 it shows I still need 29,757 in cell I8. The ore picked is Jaspet (tried all ores there, no change) and in D24 it says I need no batches of Jaspet. Its the only line that doesnt appear to work. Its a great page and Ill probably buy it once I figure out this error im getting :). Edit Did some checking and I must be doing something wrong. This is what I come up with: It shows remaining trit to get as 3,028,057 which is correct based on mineral I have in mineral and ore form. On the basic stats with my skills it shows I get 852 trit per 333 batch of Veldspar. With 3,028,057 remaining divided by 852 per batch that would be 3554 batches but the sheet shows 1067 batches to go. What am I doing wrong? Thanks! EDIT 2 Ahh brainfart. I forgot that other ores will also give trit so its only showing me how much veld I have to mine after mining scordite (which will give me pyrite and trit). The one that shows no batches must be getting enuff minerals from one of the other ores I have to mine. Neat feature! Thanks :)
Gasparde Gallente Old Farts	Posted - 2004.09.13 12:58:00 - [3] Edited by: Gasparde on 13/09/2004 14:56:03 Edited by: Gasparde on 13/09/2004 13:14:29 I just downloaded the beta of this and started to take a look at it but have 1 question on a calc that i cant figure out. Im on the mining calculator tab with ingredients entered for an Apoc. I have all my resources entered. For Noc on line 8 it shows I still need 29,757 in cell I8. The ore picked is Jaspet (tried all ores there, no change) and in D24 it says I need no batches of Jaspet. Its the only line that doesnt appear to work. Its a great page and Ill probably buy it once I figure out this error im getting :). Edit Did some checking and I must be doing something wrong. This is what I come up with: It shows remaining trit to get as 3,028,057 which is correct based on mineral I have in mineral and ore form. On the basic stats with my skills it shows I get 852 trit per 333 batch of Veldspar. With 3,028,057 remaining divided by 852 per batch that would be 3554 batches but the sheet shows 1067 batches to go. What am I doing wrong? Thanks! EDIT 2 Ahh brainfart. I forgot that other ores will also give trit so its only showing me how much veld I have to mine after mining scordite (which will give me pyrite and trit). The one that shows no batches must be getting enuff minerals from one of the other ores I have to mine. Neat feature! Thanks :)
Gasparde	Posted - 2004.09.13 18:09:00 - [4] Ok I did a little further checking during lunch and my original hunch was not the case, maybe I got a bum sheet here. For a test of the calcs here is what i did (it may be me not the sheet :) ): Entered the resources for an Apoc in the mining calc tab and entered all my ore/minerals on hand on the inventory tab. Checked the column for amt yet needed on the mining calc tab and it was correct. I needed about 3 mill more trit and thats what it showed. I also noted the number of batches it showed of all the ores I needed to mine. I then added 200,000 veld to my inventory (on inventory tab) and did verify that the amt still needed did drop accordingly as my minerals on hand went up (mining calc page). But what is odd is under that nothing changed. It still said I had to mine the exact same batches of all the ore as before I updated the quantities. Even the amt of veld ore needed didnt change by one after adding 200,000 veld to inventory. The page also comes up with a circular reference which usually isnt good (although sometimes it does work correctly) So for me Im doing something wrong because right now it wont work for me :(.
Gasparde	Posted - 2004.09.13 18:09:00 - [5] Ok I did a little further checking during lunch and my original hunch was not the case, maybe I got a bum sheet here. For a test of the calcs here is what i did (it may be me not the sheet :) ): Entered the resources for an Apoc in the mining calc tab and entered all my ore/minerals on hand on the inventory tab. Checked the column for amt yet needed on the mining calc tab and it was correct. I needed about 3 mill more trit and thats what it showed. I also noted the number of batches it showed of all the ores I needed to mine. I then added 200,000 veld to my inventory (on inventory tab) and did verify that the amt still needed did drop accordingly as my minerals on hand went up (mining calc page). But what is odd is under that nothing changed. It still said I had to mine the exact same batches of all the ore as before I updated the quantities. Even the amt of veld ore needed didnt change by one after adding 200,000 veld to inventory. The page also comes up with a circular reference which usually isnt good (although sometimes it does work correctly) So for me Im doing something wrong because right now it wont work for me :(.
Gasparde Gallente Old Farts	Posted - 2004.09.13 18:09:00 - [6] Ok I did a little further checking during lunch and my original hunch was not the case, maybe I got a bum sheet here. For a test of the calcs here is what i did (it may be me not the sheet :) ): Entered the resources for an Apoc in the mining calc tab and entered all my ore/minerals on hand on the inventory tab. Checked the column for amt yet needed on the mining calc tab and it was correct. I needed about 3 mill more trit and thats what it showed. I also noted the number of batches it showed of all the ores I needed to mine. I then added 200,000 veld to my inventory (on inventory tab) and did verify that the amt still needed did drop accordingly as my minerals on hand went up (mining calc page). But what is odd is under that nothing changed. It still said I had to mine the exact same batches of all the ore as before I updated the quantities. Even the amt of veld ore needed didnt change by one after adding 200,000 veld to inventory. The page also comes up with a circular reference which usually isnt good (although sometimes it does work correctly) So for me Im doing something wrong because right now it wont work for me :(.
Gasparde	Posted - 2004.09.14 02:18:00 - [7] Woot that was it! I clicked iterations and set to 100 in options and now it works! Thank you! (great spreadsheet btw, when i get some cash ill be sending your way :) )
Gasparde	Posted - 2004.09.14 02:18:00 - [8] Woot that was it! I clicked iterations and set to 100 in options and now it works! Thank you! (great spreadsheet btw, when i get some cash ill be sending your way :) )
Gasparde Gallente Old Farts	Posted - 2004.09.14 02:18:00 - [9] Woot that was it! I clicked iterations and set to 100 in options and now it works! Thank you! (great spreadsheet btw, when i get some cash ill be sending your way :) )

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.