Facebook Twitter
HOME MARKET FORUM WIKI ABOUT SUPPORT DOWNLOAD
HomeHomeCommunity (Publ...Community (Publ...General Discuss...General Discuss...Extraction rateExtraction rate
Previous
 
Next
New Post
1/9/2012 6:40 PM
 
Anyone have the math on how extraction rate is figured? i'm working on my own private little excel sheet so i can compare things easier and i would like to know that math.. i figured out ONE way.. but then it was incorrect on OTHER options... There's a variable in there somewhere i'm missing. ANY help would be awesome! thanks!
New Post
1/10/2012 1:26 PM
 
I started looking at this as well, but ran into inconsistencies as well.  I attributed them to not fully understanding Morale, Efficiency and Environment.  I never really went back to the project.
New Post
1/11/2012 8:56 PM
 
Just quick copy from my calc sheet.

="-> "&ROUND((100+SUM(O3:R3))/IF(O2<0;("Too Little!");IF(O2<0;("Too Little!");IF(O2<4;(3/12);IF(O2<8;(7/12);IF(O2<12;(41/12);IF(O2<16;(73/12);IF(O2<20;(113/12);IF(O2<24;(161/12);IF(O2<28;(217/12);IF(O2<32;(281/12);IF(O2<36;(353/12);IF(O2<40;(433/12);IF(O2<44;(521/12);IF(O2<48;(617/12);IF(O2<52;(721/12);IF(O2<56;(833/12);IF(O2<60;(953/12);IF(O2<64;(1081/12);IF(O2<68;(1217/12);IF(O2<72;(1361/12);IF(O2<76;(1513/12);IF(O2<80;(1673/12);IF(O2<84;(1841/12);IF(O2<88;(2017/12);IF(O2<92;(2201/12);IF(O2<96;(2393/12);IF(O2<100;(2593/12);IF(O2=100;(2801/12);IF(O2<100;("Too Much!");"Error Error Red Alert Abort Save The Blueberrypies")))))))))))))))))))))))))))))*P1;0) & " per minute"

 o3 to r3 are outputs from different kinds of extractors (so I didn't have to make different row for different kinds)... and that +100 comes from colony capital.  o2 is rate of ore (quality 52 for example) where p1 is % modifier ( 25% trace, 50% light, 100% moderate 4/3 for heavy and 200% for abundant).

Don't want to give it *too* easily to you guys tho... (anyway, whole system is based on 5 second ticks; 12 of them give minute rate)
Previous
 
Next
HomeHomeCommunity (Publ...Community (Publ...General Discuss...General Discuss...Extraction rateExtraction rate