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

Author	Thread Statistics \| Show CCP posts - 2 post(s)
Fubar	Posted - 2004.03.31 22:32:00 - [1] Edited by: Fubar on 21/04/2004 16:26:31 Edited by: Fubar on 31/03/2004 22:33:27 Tel, most of the cells with red backgrounds are protected. Only page that appears ok List of Productions. Edit: Link removed
Fubar	Posted - 2004.04.01 18:02:00 - [2] Quote: If anything else, just lemme know. Your results would be more accurate on the mineral-ore owned page if your calculations were: =floor(<number_of_refines><base_mineral_value>(<base_yield>/100)*(1-(<station_fee>/100)),1) Rounding is a problem if done before the final calculation. Is there a circular reference on the production-estimates page?
Fubar	Posted - 2004.04.02 20:18:00 - [3] Edited by: Fubar on 05/05/2004 23:36:54 Quote: "Your results would be more accurate on the mineral-ore owned page if your calculations were: =floor(<number_of_refines><base_mineral_value>(<base_yield>/100)(1-(<station_fee>/100)),1)" - Hmm, I'm not totally sure what you're talking about.. What column/row are you referring to? Here is an example of what I mean: 'Basic Stats'!e18 = 1000 'mineral-ore owned'!e15=floor($D15'basic stats'!E18('basic stats'!$N22/100)(1-('basic stats'!$L$13/100)),1) Quote: "Is there a circular reference on the production-estimates page?" Edit:link removed. A minor correction:scordite has a density of 0.15 m3 Spudomain Density:16 Batch:250 Tritanium:700 Pyerite:140 Megacyte:140 Morphite:7 ** I am not trying to be overly critical but am just trying to help.
Fubar	Posted - 2004.04.04 17:24:00 - [4] Quote: I checked the ore owned columns, and it doesn't make any difference if I multiply the total batches with a floored calculation or if I first multiply the whole thing and then floor it. Consider these examples: floor((10000.912510),1) = 9125 floor((10000.9125),1) = 912 10 = 9120 Your formulas will work if you have a perfect refining percentage.
Fubar	Posted - 2004.04.05 20:31:00 - [5] Edited by: Fubar on 05/04/2004 20:38:09 Quote: You absolutely sure that EVE doesn't floor it first, and then multiply it with number of batches? 100%? Scordite Refining Quote Screenshot <number_of_refines> = 709993/333 = 2132.111 floored = 2132 <base_mineral_value> = 833 (Tritanium) <base_yield> = (50+(37.5(1+(50.02)(1+(50.04))(1+(20.05)))/100 = 1.00445 = 1 <base_yield> has a maximum of 1 <station_fee>= 1-0.049962335 = 0.950037665 Example #1 =<number_of_refines>floor(<base_mineral_value><base_yield><station_fee>),1) =2132 * floor(83310.950037665,1) = 2132 * 791 = 1686412 Example #2 =floor(<number_of_refines><base_mineral_value><base_yield><station_fee>),1) =floor(213283310.950037665,1) = floor(1687225.09138274,1) = 1687225 So, yes I am absolutely sure. Edit: Provided a link to the screenshot instead of posting the screenshot.
Fubar	Posted - 2004.04.16 22:07:00 - [6] Quote: The problem with the Floor() function is on the basic stats sheet with the main table. If you can fix this I'll stick some decent ISK your way... the bigbrowncow the bigbrowncow, do you know if 602tab supports the rounddown function? roundown({number},0) = floor({number},1)
Fubar	Posted - 2004.04.22 14:59:00 - [7] Edited by: Fubar on 23/04/2004 06:18:39 Originally by: Joran Nexus Anyway when I mine with miner 2's, having mining 4 and astrogeology 3 I get 81.6m¦/laser, your sheet calculates 82m¦/laser, this may be due to rounding and truncation, though I'm not sure. Are you sure you don't mean 82.6m¦/laser? Anyway, when calculating ore received per minute per laser anything right of the decimal point is dropped. So if mining Veldspar (volume 0.1) you should get 820 veldspar per laser per minute. If the decimals were not dropped you would get 826 veldspar per laser per minute.
Fubar	Posted - 2004.04.22 21:52:00 - [8] Originally by: Satoyo Akuiro could someone tell me how i make a listbox like in this document i have often needed to make a list to choose from like that. - Thank you, Satoyo Akuiro This site has the info you are looking for.
Fubar	Posted - 2005.02.15 03:23:00 - [9] Originally by: HighlanderUK T'el, I will list here the BP's which no longer display correct info on the Factory page. You get lots and lots of REF's in the cells. Heavy Missile Launcher I Medium Remote Armor Repairer I Tachyon Beam Laser Wasp I have also donated another 1 mill ISK to you (total of 4mill now), to ensure of the new Exodus release. It appears the last update made to the blueprint lists changed the numbering from 1 to I. So for any blueprint that doesn't work properly in the factory sheet re-select that blueprint in the owned BPs list then select again on the factory sheet. That should take care of the problem.
Fubar Amarr Eagle Eye Inc.	Posted - 2005.02.15 03:23:00 - [10] Originally by: HighlanderUK T'el, I will list here the BP's which no longer display correct info on the Factory page. You get lots and lots of REF's in the cells. Heavy Missile Launcher I Medium Remote Armor Repairer I Tachyon Beam Laser Wasp I have also donated another 1 mill ISK to you (total of 4mill now), to ensure of the new Exodus release. It appears the last update made to the blueprint lists changed the numbering from 1 to I. So for any blueprint that doesn't work properly in the factory sheet re-select that blueprint in the owned BPs list then select again on the factory sheet. That should take care of the problem.
Fubar Amarr Eagle Eye Inc.	Posted - 2005.02.15 03:23:00 - [11] Originally by: HighlanderUK T'el, I will list here the BP's which no longer display correct info on the Factory page. You get lots and lots of REF's in the cells. Heavy Missile Launcher I Medium Remote Armor Repairer I Tachyon Beam Laser Wasp I have also donated another 1 mill ISK to you (total of 4mill now), to ensure of the new Exodus release. It appears the last update made to the blueprint lists changed the numbering from 1 to I. So for any blueprint that doesn't work properly in the factory sheet re-select that blueprint in the owned BPs list then select again on the factory sheet. That should take care of the problem.

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.