Spreadsheet: 718236d1613055899-calculation-with-sumproduct-based-on-date-matching-sumproduct
Sheet: BSL FO

DATE | RAKE NO | COMBINED QUALITY OF  FINES ORE
 |  | QNTY(MT) | Fe% | [NAME] | Al2O3% | Phos% | TiO2% | K2O% | MOIST | +10mm | [NAME] | [NAME] | [NAME] | +1mm | [NAME] | +0.25mm | [NAME] | [NAME] | LOI
2021-01-01 00:00:00 | By road | 599.1500000000001 | 65.62818181818182 | 1.648181818181818 | 2.215454545454545 | 0.04781818181818182 | 0.1144545454545454 | 0.01890909090909091 | 5.972727272727272 | 4.581818181818182 | 9.818181818181817 | 18.62727272727273 | 9.063636363636363 | 32.97272727272727 | 12.91818181818182 | 5.954545454545455 | 3.727272727272727 | 2.336363636363636 | 2.465
2021-01-01 00:00:00 | TSBL-JRLI-1 | 3882.74 | 64.705 | 2.312939560439561 | 2.640384615384615 | 0.05654395604395604 | 0.1443708791208791 | 0.05878296703296704 | 5.255219780219781 | 4.285714285714286 | 10.68159340659341 | 21.25329670329671 | 11.07802197802198 | 29.51978021978022 | 11.48791208791209 | 5.948351648351649 | 3.603571428571429 | 2.141758241758242 | 2.38
2021-01-01 00:00:00 | TSBL-BSPX-1 | 3894.75 | 63.82585231394168 | 2.799932540258233 | 2.81641302770927 | 0.06254468301175106 | 0.1612266067024518 | 0.05709364572754969 | 7.346438415784129 | 4.563606557377049 | 9.295534013598898 | 18.79259128247149 | 11.04638102974496 | 34.49852081042908 | 10.73991878767828 | 5.84613200935308 | 3.43501146585385 | 1.784064046222789
2021-01-01 00:00:00 | TSBL-BSPX-2 | 3899.69 | 62.67989010989012 | 2.682362637362638 | 3.787637362637362 | 0.07845879120879122 | 0.2246950549450549 | 0.07860439560439561 | 5.095054945054945 | 4.508190939021884 | 11.31899037163484 | 20.85752928254199 | 11.49792946017596 | 30.17499099542098 | 10.44969577030105 | 6.167031002802836 | 3.203005040725535 | 1.82435218533276 | 2.8
2021-01-01 00:00:00 | By road | 337.85 | 65.45 | 1.61 | 2.3 | 0.029 | 0.103 | 0.033 | 5.3 | 4.71 | 8.071748878923767 | 18.94618834080718 | 8.968609865470853 | 38.45291479820628 | 9.417040358744394 | 6.726457399103138 | 2.914798206278027 | 1.79372197309417
2021-01-01 00:00:00 | By road | 1314 | 62.27208333333332 | 3.105416666666667 | 3.898333333333333 | 0.06454166666666668 | 0.2287083333333333 | 0.1319166666666667 | 4.929166666666666 | 6.382083333333332 | 10.375 | 19.76458333333333 | 12.77708333333333 | 29.06874999999999 | 10.0625 | 6.175000000000001 | 3.729166666666667 | 1.664583333333333 | 2.26
2021-01-01 00:00:00 | By road | 1219.84 | 62.88888888888889 | 2.939333333333333 | 3.644222222222222 | 0.05657777777777777 | 0.07704444444444446 | 0.1045111111111111 | 5.964444444444444 | 6.26 | 8.382222222222222 | 19.86444444444444 | 10.25555555555555 | 30.45999999999999 | 11.81333333333333 | 6.584444444444444 | 4.191111111111112 | 2.188888888888889
2021-01-01 00:00:00 | TSBL-JRLI-2 | 3898.07 | 63.24673076923077 | 2.969835164835165 | 3.270137362637362 | 0.06609890109890111 | 0.1931703296703297 | 0.09717032967032967 | 5.111263736263736 | 4.645768557180983 | 12.52520750373804 | 20.47199423950601 | 11.58695701513827 | 29.05595922588644 | 11.01800976054493 | 5.329193303002195 | 3.430466527921898 | 1.936443867081234 | 2.556666666666667
2021-01-02 00:00:00 | By road | 4230.74 | 63.8260931872229 | 2.646109634298016 | 3.125130093863784 | 0.05926993610349927 | 0.173420380143273 | 0.0950734174562188 | 6.534155828039266 | 3.242908187043653 | 8.632116048767617 | 19.6872393236954 | 12.35925991838971 | 31.62807066763616 | 12.03670790079174 | 6.315926692301257 | 3.925179964572419 | 2.184191154503412 | 2.73
2021-01-02 00:00:00 | By road | 4233.88 | 62.69508275908066 | 3.350155600586916 | 3.496477727399065 | 0.05593939129509918 | 0.1918331652737109 | 0.06821537325395748 | 6.549946864365895 | 3.236062751789947 | 7.947631112652672 | 19.07897664026073 | 11.78478852071371 | 33.40306526999998 | 12.88870619835375 | 5.925036288090556 | 3.626580090963311 | 2.089238297913846 | 3.305
2021-01-02 00:00:00 | TSBL-JRLI-3 | 3893.74 | 63.28133514986376 | 2.813133514986376 | 3.183378746594006 | 0.06073024523160763 | 0.182024523160763 | 0.1154005449591281 | 5.065940054495913 | 4.086103542234333 | 12.49618528610354 | 21.03079019073569 | 11.35885558583106 | 28.72888283378747 | 11.98119891008174 | 5.73133514986376 | 2.823705722070845 | 1.762942779291553 | 2.906666666666667
2021-01-02 00:00:00 | By road | 2857.41 | 62.92193587973616 | 3.933137367694433 | 3.010831032366927 | 0.04832255714066575 | 0.1498643580303727 | 0.06952485043718361 | 7.850322135296825 | 5.01056603773585 | 9.044665592882343 | 18.20779260622795 | 11.61884491486424 | 31.67096947384568 | 12.22178248197576 | 6.202891547783401 | 3.791655161834637 | 2.18403129314312