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)
|
|