{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ReadMe!","Materials","Rawmix Optimizer","Rawmix Modifier"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":162,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ReadMe!","index":0,"n_rows":89,"n_cols":17,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Rawmix Optimizer"]
["Version V7, M. Fisch / (U. Eggenberger), IfG, Uni Bern"]
[]
["This Rawmix Optimizer has been designed as part of the UTF project 559.17.17 "]
[]
["Das Verwertungspotenzial von Kieswaschschlämmen in der Klinkerporduktion"]
[]
["which supported by the Federal Office of Environment, 3063 Ittingen, Switzerland, and carried out by"]
["Jura-Cement Fabriken AG, 5103 Wildegg, Switzerland, and the"]
["Institute of Geological Sciences, University of Bern, 3012 Bern, Switzerland."]
[]
["Purpose:"]
[]
[null,"The goal of Rawmix Optimizer is to find cost-efficient rawmixes that include gravel wash mud as replacements"]
[null,"of conventional rawmaterial (i.e. as secondary raw materials) for the production of cement clinker. "]
[]
[null,"Rawmix Optimizer can also be used for adding any type of secondary raw materials to e.g. brick raw materials, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 1. The Rawmix Optimizer part in the \"Rawmix Optimizer\" sheet. "]
[]
[null,"In a first step (sheet \"Rawmix Optimizer\"), the mixture of available materials is optimized, so that chemical constraints"]
[null,"(i.e. chemical composition range) are met and the cost of the resulting mix is minimized. "]
[]
[null,"In a second step (sheet \"Rawmix Modifier\"), the resulting mixture can be manually adjusted to specific needs. "]
[null,"The user is responsible that the desired chemical composition is met."]
[]
["Requirements:"]
[]
[null,"Rawmix Optimizer has been written and tested in Excel of Microsoft Office Professional Plus 2013."]
[null,"The Solver Add-In must be installed and correclty referenced in the Visual Basic Editor:"]
[null,"Install the Solver Add-In: File -> Options -> Add-Ins -> Manage Excel Add-Ins -> Select the Solver."]
[null,"Reference: Switch on the Developer Ribbon (File -> Options -> Customize Ribbon), then open the VBA Editor"]
[null,"(Developer Ribbon -> Visual Basic) and in the Tools menu -> References, check the Solver Add-In."]
[null,"Make sure Automatic Workbook Calculation is switched on (File -> Options -> Formulas)."]
[null,"(Installing on a Mac the ActiveX package is needed - on your own risc! Not recommended)"]
[]
["How to use Rawmix Optimizer:"]
[]
["Rawmix Optimizer consists of three Excel Sheets in one Workbook: \"Materials\", \"Rawmix Optimizer\" and \"Rawmix Modifier\"."]
["In general, yellow fields can be modified by the user. "]
[]
[null,"Sheet \"Materials\":"]
[]
[null,null,"This sheet contains the list of available materials that may be used to compute the rawmix."]
[null,null,"At the bottom of this sheet, four material types can be defined. They can later be used for calculation of mixing proportions."]
[]
[null,null,"All parameters marked with asterisk (*) are mandatory. Total cost and Clinker Composition parameters are calculated"]
[null,null,"and cannot be modified by the user. All entries of non-mandatory fileds must be filled in order that these values can be"]
[null,null,"used in the optimization process!"]
[]
[null,"Sheet \"Rawmix Optimizer\":"]
[]
[null,null,"This sheet consists of two parts: \"Rawmix Optimizer\" (left) and \"Rawmix Requirements and Optimized Result\" (right)."]
[]
[null,null,"In the left part, up to twelve materials from the \"Materials\" sheet can be selected (1 in Fig. 1). "]
[null,null,"For each material, the Material Type is shown and the minimum and maximum quantity that should be used for the "]
[null,null,"optimization can be restricted. "]
[null,null,"Parameters of each material can be reset by clicking the reset button below the selected material. "]
[null,null,"All minimum and maximum values can be reset by clicking the reset buttons on the left.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 2. The Requirements and Results part in the \"Rawmix Optimizer\" sheet. "]
[]
[null,null,"By clicking Optimize Rawmix button, amounts of the selected materials are optimized in order that the constraints"]
[null,null,"set on the right side (Fig. 2) are met as good as possible. "]
[]
[null,null,"For process optimization purposes, the percentages of each material type and the total percentage and amount per day"]
[null,null,"are shown in the lower part (2 in Fig. 1). "]
[]
[]
[null,null,"In the right part (Fig. 2), target values of the optimized material must be entered in the yellow cells (1 in Fig. 2). Amount and"]
[null,null,"Chemical Composition must be filled in, other values are optional, but in this case, lower limits must be set to 0 and maximum "]
[null,null,"values must be set to 100. "]
[null,null,"Size Distribution and Clinker Composition parameters are not used during the optimization. They are derived from the"]
[null,null,"resulting raw material mix. Nevertheless, corresponding result cells will be highlighted in yellow if the limits are exceeded. "]
[]
[null,null,"The composition of the resulting raw mix is shown on the right (2 in Fig. 2). Cells exceeding the limits will be highlighted in red. "]
[null,null,"At the bottom right, the optimized material costs are shown. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 3. The Manual Rawmix Optimizer."]
[null,null,"For process optimization purposes, the sum percentages od the different material types can be summed in 3 in Fig. 2. "]
[null,null,"In the example shown, the sum of \"Primary High Calcium\" and \"Secondary High Calcium\" (i.e. limestone), as well as the "]
[null,null,"sum of \"Primary Low Calcium\" and \"Secondary Low Calcium\" (i.e. claystone) can be calculated. These two parameters can be"]
[null,null,"changed in order to show e.g. the sum of all \"Primary\" and all \"Secondary\" material types, as defined in the Materials sheet. "]
[]
[null,"Sheet \"Rawmix Modifier\""]
[]
[null,null,"This sheet works the same way as the Rawmix Optimizer, but all values can be manually changed. "]
[]
[null,null,"By clicking the Get Solution From Rawmix Optimizer, the results from the Rawmix Optimizer are copied to the Manual Optimizer."]
[null,null,"By clicking the Remove/Add buttons, the amount of each material can be changed. It is up to the user to make sure that the target"]
[null,null,"amount of material is satisfied (cf. 2 in Fig. 2). All minimum and maximum values are only used to highlight when a target value "]
[null,null,"exceeds the range. "]
[]
[null,null,"Of course, materials can be changed. When done so, their proportion (in tonnes) are reset. "]

{"sheet":"Materials","index":1,"n_rows":60,"n_cols":34,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,8,1,16],[1,17,1,24],[1,25,1,29],[1,30,1,33],[1,5,1,7]]}
["List of Raw Materials"]
[null,null,null,null,"Available","Costs (/t)",null,null,"Chemical Composition",null,null,null,null,null,null,null,null,"Mineralogical Composition",null,null,null,null,null,null,null,null,null,null,null,null,"Clinker Composition"]
["No.","Material Name*","Type*","Comment","amount (t/day)*","Transport*","Material*","Total","Al2O3*","CaO*","Fe2O3*","K2O*","MgO*","Na2O*","SiO2*","SO3*","LOI*","Calcite","Dolomite","Quartz","Fspars","Illite","Chlorite","Smectites","Kaolinite","d10","d20","d50","d80","d90","LSF","SR","AR","Na_eq"]
[1,"KWS01","SecLowCa","Kieswaschschlamm",100,1.1200000000000001,2,{"$f":"IF(OR(F4>0,G4>0),SUM(F4:G4),\"\")","v":3.12},5.0595657733070949,33.579053631541619,2.4694654826239395,1.0218477859133543,2.1998112057856933,1.002688139927479,24.964309103077643,0.3122312679179694,29.07,50.789211467910683,5.1881878708274831,15.526065492096562,7.321436659268989,12.283154296874999,4.9551064948598604,2.6365356445312496,1.3002035637338889,1.077,2.0859999999999999,8.9710000000000001,37.700000000000003,60.241999999999997,{"$f":"IFERROR(((100*J4)/(2.8*O4+1.2*I4+0.65*K4)),\"\")","v":43.284974662007649},{"$f":"IFERROR((O4/(I4+K4)),\"\")","v":3.3157398680490102},{"$f":"IFERROR((I4/K4),\"\")","v":2.048850574712644},{"$f":"IF(OR(L4=\"\",N4=\"\"),\"\",(N4+0.658*L4))","v":1.6750639830584662}]
[2,"KWS02","SecLowCa","Kieswaschschlamm",50,6.4,1,7.4,7.1819305653763035,22.094577088167636,3.4199669358934779,1.344126539920925,2.4973712043501215,1.0832546434155623,41.46908745057813,0.13520799513997472,20.55,33.33295542152284,5.262799873021633,27.844542197632762,8.0098408235454173,16.173945605045329,5.2177253554814991,2.6184469846275125,1.5398820548456598,1.3029999999999999,2.6970000000000001,13.067,45.17,66.617999999999995,{"$f":"IFERROR(((100*J5)/(2.8*O5+1.2*I5+0.65*K5)),\"\")","v":17.403507013400326},{"$f":"IFERROR((O5/(I5+K5)),\"\")","v":3.9114778694673671},{"$f":"IFERROR((I5/K5),\"\")","v":2.1},{"$f":"IF(OR(L5=\"\",N5=\"\"),\"\",(N5+0.658*L5))","v":1.9676899066835309}]
[3,"KWS03","SecLowCa","Kieswaschschlamm",50,5.12,1,6.12,6.1147848929421089,19.084521213322763,1.7999504361617764,1.3794012688342585,1.0681948850118954,1.6435061459159397,53.207880650277559,0.12616475019825535,16.03,29.799101922447264,0.99396604144253686,39.401983254595628,13.992703119883997,11.49981502664042,2.5775447473504389,1.4374768783300524,0.29740900930966602,1.141,2.2850000000000001,15.968999999999999,150.81399999999999,242.91499999999999,12.11794299386359,6.7226354941551545,3.3971962616822426,2.5511521808088817]
[4,"KWS04","SecLowCa","Kieswaschschlamm",80,6.4,1,7.4,12.907952057586574,14.234052535817616,5.0116264826653678,2.2905371896718005,1.6877642450213264,1.2589343501128465,48.325168076835119,9.4721462730788727E-2,13.97,22.15215535638071,0.35958173282116945,23.16794707639778,11.580239009816477,31.861040742234771,3.0782081195186981,6.8963291649858798,0.90442197326064844,1.615,2.9969999999999999,7.8319999999999999,19.591000000000001,32.104999999999997,9.2394372495207016,2.6967803940413262,2.5756013745704465,2.7661078209168912]
[5,"KWS05","SecLowCa","Kieswaschschlamm",40,6.72,1,7.72,5.954252209650301,31.742910034264003,2.4690844122480002,1.2091399538368357,2.1642589089684541,0.36274198615105074,27.959624662880799,0.14767464019864063,27.460831822100761,53.709999999999994,5.66,18.78,7.4099999999999993,8.3573752711496763,3.3363748276726657,1.4182212581344906,0.8980286430431712,1.157,2.2730000000000001,8.702,25.248999999999999,37.128,36.470611201449103,3.3193051539924996,2.4115223360181512,1.1583560757756888]
[6,"KWS06","SecLowCa","Kieswaschschlamm",40,6.72,1,7.72,5.6497905544967413,31.988852689663425,2.3310832493489126,1.1401248291208077,2.0042958779448594,0.78937305048045736,28.183595298202899,0.26142989712324255,27.44,52.928012814472822,4.0151229624045985,18.70112126637143,6.9431357768774156,9.876377303340341,4.0028738635566858,2.3879055375581091,1.1454504754185972,0.996,1.9,7.4710000000000001,26.231000000000002,40.792999999999999,36.680669994712325,3.5313921747042771,2.4236760124610592,1.5395751880419488]
[7,"KWS07","SecLowCa","Kieswaschschlamm",40,7.2,1,8.1999999999999993,7.6926090252563544,24.597831065714399,3.5569636515979735,1.4196991581215337,2.7236619718309858,0.82172804532577903,35.816540717392172,0.11573634441208155,22.9,39.10050274016033,6.3408668870872775,21.577064178631279,6.2650029439739114,18.246982126058324,3.5323289025752578,3.7700376293508926,1.1676513420155217,1.157,2.1789999999999998,7.9580000000000002,27.535,42.628,21.995839557323382,3.1838134430727023,2.162689804772234,1.7558900913697482]
[8,"KWS08","SecLowCa","Kieswaschschlamm",40,7.68,1,8.68,7.6179571184798283,22.790227302803999,2.8791729769663803,1.4518930037573321,2.5004823953598496,0.50099270932120288,40.239600447151254,2.9318666936836296E-2,21.437829430571224,37.22,7.42,25.68,9.625,12.468853470437018,4.2162047121530151,2.4289974293059124,0.57094438810405423,1.163,2.2029999999999998,7.5190000000000001,23.001999999999999,34.874000000000002,18.426188642710333,3.8333906583293382,2.645883793514356,1.4563383057935275]
[9,"KWS09","SecLowCa","Kieswaschschlamm",50,7.68,1,8.68,6.9277749758419107,26.006239546144002,2.5881451981875001,1.2778504566770321,1.2139579338431807,0.40708664548425461,39.854530445531253,1.9602152985399579E-2,21.130601415094389,43.295000000000002,0.78500000000000003,29.91,8.4699999999999989,13.776506024096387,2.1174422460484141,1.0436746987951806,0.38737703106001992,1.407,3.024,10.29,26.619,39.704999999999998,21.388766430154639,4.1881951210878325,2.6767335081097805,1.2479122459777419]
[10,"KWS10","SecLowCa","Kieswaschschlamm",50,8,1,9,9.4095203135076151,16.323325561783818,4.2916181358202294,1.745314251698993,2.7655220993104814,1.4249183987300957,48.1436926434843,0.10960910759462275,15.81,26.225971909304441,4.5767221130338909,31.162216576386559,12.897272422223288,15.151671232876712,4.8051426844170031,4.6832438356164374,0.49794224708984486,1.639,3.1850000000000001,10.138,29.742999999999999,44.734000000000002,10.963838022884747,3.5138461538461536,2.1925343811394891,2.5733351763480332]
[11,"KWS11","SecLowCa","Kieswaschschlamm",50,8.8000000000000007,1,9.8000000000000007,9.7310457749620767,21.41795931114482,4.1129564855298772,1.7868421522262872,1.9558677612206656,1.2773506736860889,40.123460039856042,0.11268373932958568,19.68,34.531433210065842,3.0655271940110036,22.338098674122847,7.7996752953909994,23.907514640511486,4.3215812388302872,3.3589070156090517,0.67726273145847782,1.2829999999999999,2.4849999999999999,7.51,24.65,44.186,16.904951734171064,2.8982558139534884,2.3659491193737767,2.4530928098509861]
[12,"KWS12","SecLowCa","Kieswaschschlamm",10,9.6,1,10.6,9.8259220820930171,17.766294663208001,3.8588015097652799,1.8903028540829501,2.6391184774394816,0.64379879812970042,46.211288035252451,2.8733260878705744E-2,16.380532367301821,28.66,2.9850000000000003,29.175000000000001,11.945,15.641588785046725,5.8847962320294727,4.4610591900311514,0.86255579289264472,1.464,2.7120000000000002,8.2639999999999993,24.248999999999999,37.713000000000001,12.364241898419397,3.3768521318724902,2.5463662894365098,1.8876180761162815]
[13,"KWS13","SecLowCa","Kieswaschschlamm",20,9.6,1,10.6,10.699275672582697,17.256355277566762,4.4021314483588689,2.0710980337993155,2.5406587216242613,1.3290244467902488,45.840862148910354,0.10062014739105984,16.37,27.139074372553537,2.5708035919871057,24.691457517844807,10.926778724384066,21.054090264826556,6.6363288792389463,6.0782693024990673,0.90331155343542835,1.591,2.9670000000000001,8.26,22.913,36.975000000000001,11.97901053838609,3.0355358134369799,2.43047619047619,2.6918069530301985]
[14,"KWS14","SecLowCa","Kieswaschschlamm",50,9.76,1,10.76,8.2801855596526703,24.072130367550852,3.6068990127274887,1.5290115380040443,1.9445890329487332,0.82645033900321163,37.90380397287975,0.24307362911859165,21.78,37.530494566422703,1.9948990907074737,23.987580394766024,5.4213794632956311,22.631953674194964,6.7862652778920385,1.2974912016327989,0.34993633108835559,1.272,2.4089999999999998,7.6459999999999999,23.155999999999999,37.392000000000003,20.32924099752341,3.188654353562006,2.2956521739130435,1.8325399310098729]
[15,"KWS15","SecLowCa","Kieswaschschlamm",50,9.6,1,10.6,5.0798735288939065,29.978449262918001,2.2348465848719998,0.98536153197000453,2.0663892320924369,0.2372520970180205,31.731127909863201,4.3001559919843599E-2,27.152356852821725,48.86,9.3049999999999997,23.494999999999997,4.1550000000000002,10.161498708010337,2.4174697525449544,0.59216192937123169,0.57886961007347815,1.169,2.3199999999999998,9.7690000000000001,35.253999999999998,59.999000000000002,31.099377607740099,4.3379825087424653,2.2730300877385976,0.88561998505428352]
[16,"KWS16","SecLowCa","Kieswaschschlamm",50,9.6,1,10.6,6.0004275536815177,27.873432319820942,2.5737309779078945,1.1570663762352493,3.1374299817148112,0.62229403183421417,32.212431230703125,0.1409247509517291,25.85,42.88250787827478,9.3210573350265733,22.375476224072244,4.0626028879168423,15.726334908558968,3.5501793265203281,0.86646473325393758,1.2153767063763288,1.242,2.448,10.438000000000001,37.323,56.359000000000002,28.135586875549816,3.7569204152249132,2.3314121037463975,1.3836437073970083]
[17,"KWS17","SecLowCa","Kieswaschschlamm",50,11.200000000000001,1,12.200000000000001,9.2669882310984306,21.953648359486447,3.6696950784593434,1.766292796005706,1.6614443651925819,1.3388338088445078,41.027997503566333,0.1048484308131241,19.53,36.881557472604342,0.93844719048729319,24.816973653532294,10.338074143156913,20.560263324873102,5.6949907809974754,0.42869606598984772,0.34104982813958262,1.202,2.3069999999999999,7.95,27.251999999999999,45.555,17.099977070199742,3.1714463840399003,2.5252747252747256,2.5010544686162621]
[18,"KWS18","SecLowCa","Kieswaschschlamm",50,11.52,1,12.52,9.3061566358177608,15.762979726917818,4.1073726244030038,1.7829163116069837,3.4658560076098373,1.4230004954321158,47.363921642456553,0.13330215413883989,16.84,21.275021959225189,8.8680597290925061,29.317877120798851,11.778234940594515,17.604270546850014,5.6057628889497693,4.7827694275663566,0.76819713663385714,1.5649999999999999,2.98,9.3309999999999995,29.94,47.439,10.76293386654986,3.5310559006211184,2.2657200811359028,2.5961594284695111]
[19,"KWS19","SecLowCa","Kieswaschschlamm",50,12,1,13,8.4917719224871053,19.182673916074165,3.253394674473721,1.6061062317022166,2.2156029555276731,1.0180242576327896,46.255859473023833,9.8837306566290251E-2,17.71,29.61452335252719,4.1666666666666661,29.255781007220545,9.6072114066355905,15.208217860647697,4.010181801098283,7.7182041216879291,0.41939621656609544,1.9370000000000001,3.9489999999999998,19.812999999999999,77.019000000000005,122.08,13.525952813067152,3.9382889200560998,2.6101265822784812,2.0748421580928484]
[20,"KWS20","SecLowCa","Kieswaschschlamm",50,12.8,1,13.8,9.7166245514880139,19.278689610076,3.8322793619686206,1.7324924907841837,1.805825506267112,0.47849792602610791,45.456511362808051,2.2661991775166142E-2,16.907337198929529,32.650000000000006,0.69,30.52,9.67,16.300258665287114,4.096809942022535,4.8496637351267449,0.79326765756359918,1.9019999999999999,3.7440000000000002,10.742000000000001,27.303999999999998,43.933999999999997,13.631339689651407,3.3549954780962836,2.5354687468547801,1.6184779849621009]
[21,"Test21",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[22,"RAW1","PrimHighCa","Primäre Komponente1",5000,0,8.5,8.5,1.9333333333333336,44.53,1.6066666666666667,0.98536153197000453,0.76333333333333331,0.2372520970180205,9.2233333333333345,0.2372520970180205,40.48346760732727,34.531433210065842,3.0655271940110036,22.338098674122847,7.7996752953909994,23.907514640511486,4.3215812388302872,3.3589070156090517,0.67726273145847782,1.157,2.1789999999999998,7.9580000000000002,27.535,42.628,152.55398599961171,2.605461393596987,1.203319502074689,0.88561998505428352]
[23,"RAW2","PrimHighCa","Primäre Komponente2",5000,0,8.25,8.25,1.9744444444444442,43.115555555555552,1.5077777777777779,1.1570663762352493,1.2833333333333332,0.62229403183421417,10.208888888888891,0.62229403183421417,39.508345560096323,28.66,2.9850000000000003,29.175000000000001,11.945,15.641588785046725,5.8847962320294727,4.4610591900311514,0.86255579289264472,1.163,2.2029999999999998,7.5190000000000001,23.001999999999999,34.874000000000002,135.01340426605336,2.9317166560306327,1.3095062638172437,1.3836437073970083]
[24,"RAW3","PrimHighCa","Primäre Komponente3",5000,0,8.5,8.5,0.94135139573070625,50.218938970990699,0.6189780564263323,1.766292796005706,0.76309327262775528,1.3388338088445078,3.7623369408369398,1.3388338088445078,39.251340949692846,27.139074372553537,2.5708035919871057,24.691457517844807,10.926778724384066,21.054090264826556,6.6363288792389463,6.0782693024990673,0.90331155343542835,1.407,3.024,10.29,26.619,39.704999999999998,416.18477147884272,2.4112452249336132,1.5208154569575461,2.5010544686162621]
[25,"RAW4","PrimHighCa","Primäre Komponente4",5000,0,8,8,2.1572608695652171,40.93417391304348,0.92356159420289852,1.7829163116069837,5.0586413043478249,1.4230004954321158,8.3949963768115943,1.4230004954321158,37.902448639557768,37.530494566422703,1.9948990907074737,23.987580394766024,5.4213794632956311,22.631953674194964,6.7862652778920385,1.2974912016327989,0.34993633108835559,1.639,3.1850000000000001,10.138,29.742999999999999,44.734000000000002,153.34012516136121,2.7249205287031626,2.3358061694056169,2.5961594284695111]
[26,"RAW5","PrimHighCa","Primäre Komponente5",5000,0,8,8,1.0137916666666669,41.259083333333336,0.44887500000000002,1.6061062317022166,10.383812499999999,1.0180242576327896,4.1137083333333333,1.0180242576327896,39.13857441969887,48.86,9.3049999999999997,23.494999999999997,4.1550000000000002,10.161498708010337,2.4174697525449544,0.59216192937123169,0.57886961007347815,1.2829999999999999,2.4849999999999999,7.51,24.65,44.186,316.72700480439465,2.8124715132178668,2.2585166620254342,2.0748421580928484]
[27,"RAW6","PrimHighCa","Primäre Komponente6",5000,0,8,8,0.9507916666666667,43.896041666666669,0.42779166666666663,1.7324924907841837,7.5715833333333338,0.47849792602610791,3.7289583333333329,0.47849792602610791,40.735344990496934,42.88250787827478,9.3210573350265733,22.375476224072244,4.0626028879168423,15.726334908558968,3.5501793265203281,0.86646473325393758,1.2153767063763288,1.464,2.7120000000000002,8.2639999999999993,24.248999999999999,37.713000000000001,370.11533947776928,2.7049205101855769,2.2225577091652871,1.6184779849621009]
[28,"RAW7","PrimLowCa","Primäre Komponente7",5000,0,7.75,7.75,8.86,17.579999999999998,3.36,1.6061062317022166,2.38,1.0180242576327896,46.04,1.0180242576327896,18.137845253032211,37.530494566422703,1.9948990907074737,23.987580394766024,5.4213794632956311,22.631953674194964,6.7862652778920385,1.2974912016327989,0.34993633108835559,1.639,3.1850000000000001,10.138,29.742999999999999,44.734000000000002,12.404041544366674,3.7675941080196402,2.6369047619047619,2.0748421580928484]
[29,"RAW8","PrimLowCa","Primäre Komponente8",5000,0,7.8,7.8,11.12,15.72,11.12,1.7324924907841837,4.0199999999999996,0.47849792602610791,46.9,0.47849792602610791,8.4305116571636063,48.86,9.3049999999999997,23.494999999999997,4.1550000000000002,10.161498708010337,2.4174697525449544,0.59216192937123169,0.57886961007347815,1.2829999999999999,2.4849999999999999,7.51,24.65,44.186,10.349458826007954,2.1088129496402876,1,1.6184779849621009]
[30,"Test30",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[31,"RAW9","PrimLowCa","Primäre Komponente9 Clay",5000,0,7.8,7.8,11.5,13.9,5.5,2.2000000000000002,4.3,0.2,43.8,0,17.100000000000001,19.3,8.1,22,8.44,25.3,7.5,0,0,1.5,2.6,7.9,25.6,46.6,9.927507767024963,2.5764705882352938,2.0909090909090908,1.6476000000000002]
[32,"Test32",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[33,"Test33",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[34,"Test34",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[35,"Test35",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[36,"Test36",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[37,"Test37",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[38,"Test38",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[39,"Test39",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[40,"Test40",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[41,"Test41",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[42,"Test42",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[43,"Test43",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[44,"Test44",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[45,"Test45",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[46,"Test46",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[47,"Test47",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[48,"Test48",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[49,"Test49",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[50,"Test50",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[]
["Material Types"]
[]
["A","PrimHighCa"]
["B","PrimLowCa"]
["C","SecHighCa"]
["D","SecLowCa"]

{"sheet":"Rawmix Optimizer","index":2,"n_rows":75,"n_cols":30,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["Rawmix Optimizer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rawmix Requirements and Optimized Result"]
[]
["Material",null,"RAW1","RAW2","RAW3","RAW4","RAW5","RAW6","RAW7","RAW8","KWS01","KWS02","KWS04","KWS05",null,null,"Amount",null,1200,"t/d",null,{"$f":"C73*S3/100","v":1198.2000000000003},"t/d"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+/-",0.15,{"$f":"\"% (+/-\"&FIXED((C71-C68),1)&\" t)\"","v":"% (+/-1,8 t)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chemical Composition",null,"MIN","MAX",null,"RESULT"]
[null,null,{"$f":"IF((_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},null,null,null,"Al2O3",3.1,3.5,"%",{"$f":"IFERROR(SUMPRODUCT(C30:N30,$C$17:$N$17)/100,0)","v":3.1000000000000005},"%"]
["Minimum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CaO",41,41.69,"%",41.000000000000007,"%"]
[null,"%",{"$f":"C65/10","v":0},{"$f":"D65/10","v":0},0,0,0,0,0,0,{"$f":"K65/10","v":0},0,0,0,null,null,null,"Fe2O3",1.65,1.71,"%",1.6855011896147778,"%"]
[null,"t",{"$f":"IF((C8*$C$68/100)<C24,C8*$C$68/100,C24)","v":0},{"$f":"IF((D8*$C$68/100)<D24,D8*$C$68/100,D24)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"K2O",0.1,4,"%",1.7060454848058486,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MgO",0.1,2.8,"%",2.7004072414500917,"%"]
["Maximum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Na2O",0.1,4,"%",1.1684638361137656,"%"]
[null,"%",{"$f":"C66/10","v":100},{"$f":"D66/10","v":100},{"$f":"E66/10","v":100},{"$f":"F66/10","v":100},100,100,100,100,8.3000000000000007,4.2,6.7,3.3,null,null,null,"SiO2",12.9,13.1,"%",13.100000000000001,"%"]
[null,"t",{"$f":"IF((C12*$C$68/100)<C24,C12*$C$68/100,C24)","v":1200},1200,1200,1200,1200,1200,1200,1200,99.6,50,80,39.6,null,null,null,"SO3",0.1,1,"%",1.0000000000000007,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOI",33,36,"%",34.324605133521011,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",99.5,100.5,"%",{"$f":"SUM(V6:V14)","v":99.785022885505498},"%"]
["Rawmix"]
[null,"%",0,0,44.391208182053177,21.19335123513126,0,9.0809623657681975,0,4.1360449080596489,8.3000000000000007,2.7484333089877415,6.7,3.3,null,null,"Mineralogical Composition",null,"MIN","MAX",null,"RESULT"]
[null,"t",{"$f":"C17*$C$68/100","v":0},0,532.69449818463818,254.32021482157515,0,108.97154838921837,0,49.632538896715786,99.6,32.981199707852895,80.400000000000006,39.6,null,null,null,"Calcite",0,100,"%",{"$f":"IFERROR(SUMPRODUCT(C41:N41,$C$17:$N$17)/100,0)","v":34.304611491537223},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dolomite",0,100,"%",3.5814335470043521,"%"]
[null,null,{"$f":"Materials!B57&\" \"&FIXED(IF((SUMIF(C6:N6,Materials!B57,'Rawmix Optimizer'!C17:N17))>=100,100,(SUMIF(C6:N6,Materials!B57,'Rawmix Optimizer'!C17:N17))),1)&\" of \"&FIXED(IF((SUMIF(C6:N6,Materials!B57,'Rawmix Optimizer'!C12:N12))>=100,\"100\",(SUMIF(C6:N6,Materials!B57,'Rawmix Optimizer'!C12:N12))),1)&\" % used\"","v":"PrimHighCa 74,7 of 100,0 % used"},null,null,null,{"$f":"Materials!B59&\" \"&FIXED(IF((SUMIF(C6:N6,Materials!B59,'Rawmix Optimizer'!C17:N17))>=100,100,(SUMIF(C6:N6,Materials!B59,'Rawmix Optimizer'!C17:N17))),1)&\" of \"&FIXED(IF((SUMIF(C6:N6,Materials!B59,'Rawmix Optimizer'!C12:N12))>=100,\"100\",(SUMIF(C6:N6,Materials!B59,'Rawmix Optimizer'!C12:N12))),1)&\" % used\"","v":"SecHighCa 0,0 of 0,0 % used"},null,null,null,null,null,"Sum",{"$f":"FIXED(SUM(C17:N17),1)&\" %\"","v":"99,9 %"},null,null,null,"Quartz",0,100,"%",23.274225364477534,"%"]
[null,null,{"$f":"Materials!B58&\" \"&FIXED(IF((SUMIF(C6:N6,Materials!B58,'Rawmix Optimizer'!C17:N17))>=100,100,(SUMIF(C6:N6,Materials!B58,'Rawmix Optimizer'!C17:N17))),1)&\" of \"&FIXED(IF((SUMIF(C6:N6,Materials!B58,'Rawmix Optimizer'!C12:N12))>=100,100,(SUMIF(C6:N6,Materials!B58,'Rawmix Optimizer'!C12:N12))),1)&\" % used\"","v":"PrimLowCa 4,1 of 100,0 % used"},null,null,null,{"$f":"Materials!B60&\" \"&FIXED(IF((SUMIF(C6:N6,Materials!B60,'Rawmix Optimizer'!C17:N17))>=100,100,(SUMIF(C6:N6,Materials!B60,'Rawmix Optimizer'!C17:N17))),1)&\" of \"&FIXED(IF((SUMIF(C6:N6,Materials!B60,'Rawmix Optimizer'!C12:N12))>=100,100,(SUMIF(C6:N6,Materials!B60,'Rawmix Optimizer'!C12:N12))),1)&\" % used\"","v":"SecLowCa 21,0 of 22,5 % used"},null,null,null,null,null,"=",{"$f":"FIXED(V3,1)&\" t/d\"","v":"1.198,2 t/d"},null,null,null,"Fspars",0,100,"%",8.3885075773996132,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Illite",0,100,"%",19.865536207001913,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorite",0,100,"%",5.6775815417185758,"%"]
["Amount (t/d)",null,{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":100},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":50},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":80},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":40},null,null,null,"Smectites",0,100,"%",3.8760285503840999,"%"]
["Costs (/t)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kaolinite",0,100,"%",0.84993510083834667,"%"]
[null,"Transport",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":1.1200000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":6.4},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":6.4},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":6.72}]
[null,"Material",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8.25},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":7.75},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":7.8},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":1},null,null,"Material Type Amounts",null,"MIN","MAX",null,"RESULT"]
[null,"Total",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8.25},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.75},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.8},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":3.12},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.4},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.4},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.72},null,null,null,{"$f":"Materials!B57","v":"PrimHighCa"},0,100,"%",{"$f":"SUMIF($C$6:$N$6,R28,$C$17:$N$17)","v":74.665521782952638},"%"]
["Chemical Composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Materials!B58","v":"PrimLowCa"},0,100,"%",{"$f":"SUMIF($C$6:$N$6,R29,$C$17:$N$17)","v":4.1360449080596489},"%"]
[null,"Al2O3",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":1.9333333333333336},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":1.9744444444444442},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":0.94135139573070625},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":2.1572608695652171},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":1.0137916666666669},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":0.9507916666666667},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":8.86},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":11.12},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":5.0595657733070949},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":7.1819305653763035},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":12.907952057586574},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":5.954252209650301},null,null,null,{"$f":"Materials!B59","v":"SecHighCa"},0,100,"%",{"$f":"SUMIF($C$6:$N$6,R30,$C$17:$N$17)","v":0},"%"]
[null,"CaO",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":44.53},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":43.115555555555552},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":50.218938970990699},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":40.93417391304348},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":41.259083333333336},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":43.896041666666669},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":17.579999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":15.72},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":33.579053631541619},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":22.094577088167636},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":14.234052535817616},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":31.742910034264003},null,null,null,{"$f":"Materials!B60","v":"SecLowCa"},0,100,"%",{"$f":"SUMIF($C$6:$N$6,R31,$C$17:$N$17)","v":21.048433308987743},"%"]
[null,"Fe2O3",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":1.6066666666666667},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":1.5077777777777779},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.6189780564263323},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.92356159420289852},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.44887500000000002},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.42779166666666663},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":3.36},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":11.12},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":2.4694654826239395},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":3.4199669358934779},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":5.0116264826653678},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":2.4690844122480002}]
[null,"K2O",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":0.98536153197000453},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.1570663762352493},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.766292796005706},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.7829163116069837},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.6061062317022166},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.7324924907841837},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.6061062317022166},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.7324924907841837},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.0218477859133543},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.344126539920925},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":2.2905371896718005},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.2091399538368357},null,null,"=","PrimHighCa"]
[null,"MgO",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":0.76333333333333331},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":1.2833333333333332},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":0.76309327262775528},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":5.0586413043478249},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":10.383812499999999},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":7.5715833333333338},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.38},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":4.0199999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.1998112057856933},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.4973712043501215},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":1.6877642450213264},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.1642589089684541},null,null,"+","SecHighCa",70,100,"%",{"$f":"SUMIF(R28:R31,R33,V28:V31)+SUMIF(R28:R31,R34,V28:V31)","v":74.665521782952638},"%"]
[null,"Na2O",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.2372520970180205},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.62229403183421417},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.3388338088445078},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.4230004954321158},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.002688139927479},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.0832546434155623},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.2589343501128465},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.36274198615105074}]
[null,"SiO2",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":9.2233333333333345},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":10.208888888888891},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":3.7623369408369398},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":8.3949963768115943},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":4.1137083333333333},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":3.7289583333333329},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":46.04},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":46.9},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":24.964309103077643},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":41.46908745057813},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":48.325168076835119},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":27.959624662880799},null,null,"=","PrimLowCa"]
[null,"SO3",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.2372520970180205},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.62229403183421417},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.3388338088445078},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.4230004954321158},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.3122312679179694},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.13520799513997472},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":9.4721462730788727E-2},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.14767464019864063},null,null,"+","SecLowCa",0,30,"%",{"$f":"SUMIF(R28:R31,R36,V28:V31)+SUMIF(R28:R31,R37,V28:V31)","v":25.184478217047392},"%"]
[null,"LOI",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":40.48346760732727},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":39.508345560096323},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":39.251340949692846},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":37.902448639557768},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":39.13857441969887},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":40.735344990496934},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":18.137845253032211},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":8.4305116571636063},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":29.07},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":20.55},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":13.97},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":27.460831822100761}]
[null,"Sum",{"$f":"SUM(C30:C38)","v":100},{"$f":"SUM(D30:D38)","v":100},100,100,100,100,100,100,99.678972390094771,99.77552242284213,99.780756400441433,99.470518630298841,null,null,"Size Distribution",null,"MIN","MAX",null,"RESULT"]
["Mineralogical Composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d10",0,100,"um",{"$f":"IFERROR(SUMPRODUCT(C50:N50,$C$17:$N$17)/100,0)","v":1.4295431570866515},"um"]
[null,"Calcite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":34.531433210065842},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":28.66},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":27.139074372553537},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":37.530494566422703},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":48.86},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":42.88250787827478},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":37.530494566422703},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":48.86},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":50.789211467910683},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":33.33295542152284},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":22.15215535638071},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":53.709999999999994},null,null,null,"d20",0,100,"um",{"$f":"IFERROR(SUMPRODUCT(C51:N51,$C$17:$N$17)/100,0)","v":2.8895260339325342},"um"]
[null,"Dolomite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":3.0655271940110036},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":2.9850000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":2.5708035919871057},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":1.9948990907074737},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":9.3049999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":9.3210573350265733},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":1.9948990907074737},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":9.3049999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":5.1881878708274831},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":5.262799873021633},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":0.35958173282116945},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":5.66},null,null,null,"d50",0,100,"um",{"$f":"IFERROR(SUMPRODUCT(C52:N52,$C$17:$N$17)/100,0)","v":9.6931457531386691},"um"]
[null,"Quartz",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":22.338098674122847},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":29.175000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":24.691457517844807},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.987580394766024},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.494999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":22.375476224072244},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.987580394766024},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.494999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":15.526065492096562},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":27.844542197632762},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.16794707639778},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":18.78},null,null,null,"d80",0,100,"um",{"$f":"IFERROR(SUMPRODUCT(C53:N53,$C$17:$N$17)/100,0)","v":27.857993123427423},"um",null,null,null,null,null,null," "]
[null,"Fspars",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":7.7996752953909994},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":11.945},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":10.926778724384066},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":5.4213794632956311},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":4.1550000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":4.0626028879168423},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":5.4213794632956311},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":4.1550000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":7.321436659268989},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":8.0098408235454173},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":11.580239009816477},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":7.4099999999999993},null,null,null,"d90",0,100,"um",{"$f":"IFERROR(SUMPRODUCT(C54:N54,$C$17:$N$17)/100,0)","v":42.565715392066679},"um"]
[null,"Illite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":23.907514640511486},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":15.641588785046725},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":21.054090264826556},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":22.631953674194964},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":10.161498708010337},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":15.726334908558968},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":22.631953674194964},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":10.161498708010337},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":12.283154296874999},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":16.173945605045329},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":31.861040742234771},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":8.3573752711496763}]
[null,"Chlorite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":4.3215812388302872},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":5.8847962320294727},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":6.6363288792389463},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":6.7862652778920385},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":2.4174697525449544},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":3.5501793265203281},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":6.7862652778920385},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":2.4174697525449544},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":4.9551064948598604},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":5.2177253554814991},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":3.0782081195186981},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":3.3363748276726657},null,null,"Klinker Composition",null,"MIN","MAX",null,"RESULT"]
[null,"Smectites",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":3.3589070156090517},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":4.4610591900311514},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":6.0782693024990673},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":1.2974912016327989},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":0.59216192937123169},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":0.86646473325393758},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":1.2974912016327989},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":0.59216192937123169},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":2.6365356445312496},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":2.6184469846275125},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":6.8963291649858798},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":1.4182212581344906},null,null,null,"LSF",98,102,null,{"$f":"IFERROR((100*V7)/(2.8*V12+1.2*V6+0.65*V8),0)","v":98.805714189971368}]
[null,"Kaolinite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.67726273145847782},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.86255579289264472},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.90331155343542835},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.34993633108835559},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.57886961007347815},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":1.2153767063763288},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.34993633108835559},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.57886961007347815},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":1.3002035637338889},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":1.5398820548456598},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.90442197326064844},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.8980286430431712},null,null,null,"SR",2.4,2.8,null,{"$f":"IFERROR(V12/(V6+V8),0)","v":2.7374353241054195}]
["Size Distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR",1.7,2.1,null,{"$f":"IFERROR(V6/V8,0)","v":1.8392155514933259},null,null,null,null,null," "]
[null,"d10",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.157},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.163},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.407},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.639},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.2829999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.464},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.639},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.2829999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.077},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.3029999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.615},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.157},null,null,null,"Na_eq",0.1,5,null,{"$f":"IFERROR(SUMPRODUCT(C59:N59,$C$17:$N$17)/100,0)","v":2.2910417651160135}]
[null,"d20",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.1789999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.2029999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":3.024},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":3.1850000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.4849999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.7120000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":3.1850000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.4849999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.0859999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.6970000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.9969999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.2730000000000001}]
[null,"d50",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.9580000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.5190000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":10.29},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":10.138},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.51},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":8.2639999999999993},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":10.138},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.51},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":8.9710000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":13.067},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.8319999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":8.702},null,null,"Costs",null,null,null,null,"RESULT"]
[null,"d80",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":27.535},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":23.001999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":26.619},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":29.742999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":24.65},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":24.248999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":29.742999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":24.65},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":37.700000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":45.17},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":19.591000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":25.248999999999999},null,null,null,"Transport",null,null,null,{"$f":"IFERROR(SUMPRODUCT(C26:N26,C17:N17)/100,0)","v":0.91941973177521552},"CHF/t"]
[null,"d90",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":42.628},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":34.874000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":39.704999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.734000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.186},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":37.713000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.734000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.186},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":60.241999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":66.617999999999995},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":32.104999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":37.128},null,null,null,"Material",null,null,null,{"$f":"IFERROR(SUMPRODUCT(C27:N27,C17:N17)/100,0)","v":6.8112936194650073},"CHF/t"]
["Klinker Composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"IFERROR(SUMPRODUCT(C28:N28,C17:N17)/100,0)","v":7.7307133512402224},"CHF/t"]
[null,"LSF",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":152.55398599961171},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":135.01340426605336},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":416.18477147884272},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":153.34012516136121},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":316.72700480439465},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":370.11533947776928},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":12.404041544366674},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":10.349458826007954},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":43.284974662007649},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":17.403507013400326},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":9.2394372495207016},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":36.470611201449103},null,null,null,{"$f":"\"Total for \"&FIXED(V3,1,TRUE)&\" tons\"","v":"Total for 1198,2 tons"},null,null,null,{"$f":"V55*V3","v":9262.940737456036},"CHF"]
[null,"SR",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.605461393596987},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.9317166560306327},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.4112452249336132},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.7249205287031626},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.8124715132178668},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.7049205101855769},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.7675941080196402},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.1088129496402876},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.3157398680490102},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.9114778694673671},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.6967803940413262},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.3193051539924996}]
[null,"AR",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1.203319502074689},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1.3095062638172437},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1.5208154569575461},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.3358061694056169},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.2585166620254342},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.2225577091652871},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.6369047619047619},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.048850574712644},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.1},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.5756013745704465},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.4115223360181512}]
[null,"Na_eq",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":0.88561998505428352},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.3836437073970083},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.5010544686162621},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.5961594284695111},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.0748421580928484},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.6184779849621009},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.0748421580928484},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.6184779849621009},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.6750639830584662},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.9676899066835309},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.7661078209168912},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.1583560757756888}]
[]
["ButtonHelpers"]
[null,"MINposs",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MAXposs",{"$f":"IF((C24*100/$C$68)<100,(C24*100/$C$68),100)","v":100},100,100,100,100,100,100,{"$f":"IF((J24*100/$C$68)<100,(J24*100/$C$68),100)","v":100},{"$f":"IF((K24*100/$C$68)<100,(K24*100/$C$68),100)","v":8.3333333333333339},{"$f":"IF((L24*100/$C$68)<100,(L24*100/$C$68),100)","v":4.166666666666667},6.666666666666667,3.3333333333333335]
[null,"MAXpos10",{"$f":"ROUND(C63*10,0)","v":1000},{"$f":"ROUND(D63*10,0)","v":1000},{"$f":"ROUND(E63*10,0)","v":1000},{"$f":"ROUND(F63*10,0)","v":1000},{"$f":"ROUND(G63*10,0)","v":1000},{"$f":"ROUND(H63*10,0)","v":1000},{"$f":"ROUND(I63*10,0)","v":1000},{"$f":"ROUND(J63*10,0)","v":1000},{"$f":"ROUND(K63*10,0)","v":83},{"$f":"ROUND(L63*10,0)","v":42},{"$f":"ROUND(M63*10,0)","v":67},{"$f":"ROUND(N63*10,0)","v":33}]
[null,"ButtVMin",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ButtVMax",1000,1000,1000,1000,1000,1000,1000,1000,83,42,67,33]
[]
["TargetTons",null,{"$f":"S3","v":1200},"t"]
[null,"TTvar",{"$f":"S4","v":0.15},"%"]
[null,"TTmin",{"$f":"C68-(C69/100*C68)","v":1198.2},"t"]
[null,"TTmax",{"$f":"C68+(C69/100*C68)","v":1201.8},"t"]
[]
["AmountSum",null,{"$f":"SUM(C17:N17)","v":99.850000000000023}]
[null,"ASmin",{"$f":"C70*100/C68","v":99.85}]
[null,"ASmax",{"$f":"C71*100/C68","v":100.15}]

{"sheet":"Rawmix Modifier","index":3,"n_rows":75,"n_cols":28,"rows_kept":75,"cut":false,"hidden":false,"merged":[[19,9,20,11]]}
["Manually Optimize Proposed Rawmix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rawmix Requirements and Optimized Result"]
[]
["Material",null,"RAW1","RAW2","RAW3","RAW4","RAW5","RAW6","RAW7","RAW8","KWS01","KWS02","KWS04","KWS05",null,null,"Amount",null,{"$f":"'Rawmix Optimizer'!S3","v":1200},"t/d",null,{"$f":"SUM(C18:N18)","v":1198.2000000000005},"t/d"]
[null,null,{"$f":"IF((_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimHighCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"PrimLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},{"$f":"IF((_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,2,FALSE),0))=0,\"None\",(_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,2,FALSE),0)))","v":"SecLowCa"},null,null,null,"+/-",{"$f":"'Rawmix Optimizer'!S4","v":0.15},{"$f":"\"% (+/-\"&FIXED((C71-C68),1)&\" t)\"","v":"% (+/-1,8 t)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chemical Composition",null,"MIN","MAX",null,"RESULT"]
["Proposed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Al2O3",{"$f":"'Rawmix Optimizer'!S6","v":3.1},{"$f":"'Rawmix Optimizer'!T6","v":3.5},"%",{"$f":"IFERROR(SUMPRODUCT(C30:N30,$C$17:$N$17)/100,0)","v":3.1000000000000005},"%"]
[null,"%",0,0,44.391208182053177,21.19335123513126,0,9.0809623657681975,0,4.1360449080596489,8.3000000000000007,2.7484333089877415,6.7,3.3,null,null,null,"CaO",{"$f":"'Rawmix Optimizer'!S7","v":41},{"$f":"'Rawmix Optimizer'!T7","v":41.69},"%",41.000000000000021,"%"]
[null,"t",0,0,532.69449818463818,254.32021482157515,0,108.97154838921837,0,49.632538896715786,99.6,32.981199707852895,80.400000000000006,39.6,null,null,null,"Fe2O3",{"$f":"'Rawmix Optimizer'!S8","v":1.65},{"$f":"'Rawmix Optimizer'!T8","v":1.71},"%",1.6855011896147776,"%"]
[null,"Available t",{"$f":"C24","v":5000},{"$f":"D24","v":5000},5000,5000,5000,5000,5000,5000,100,50,80,40,null,null,null,"K2O",{"$f":"'Rawmix Optimizer'!S9","v":0.1},{"$f":"'Rawmix Optimizer'!T9","v":4},"%",1.7060454848058491,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MgO",{"$f":"'Rawmix Optimizer'!S10","v":0.1},{"$f":"'Rawmix Optimizer'!T10","v":2.8},"%",2.7004072414500921,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Na2O",{"$f":"'Rawmix Optimizer'!S11","v":0.1},{"$f":"'Rawmix Optimizer'!T11","v":4},"%",1.1684638361137656,"%"]
["Modify",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SiO2",{"$f":"'Rawmix Optimizer'!S12","v":12.9},{"$f":"'Rawmix Optimizer'!T12","v":13.1},"%",13.100000000000001,"%"]
[null,"Remove/add t",{"$f":"C65","v":0},{"$f":"D65","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,"SO3",{"$f":"'Rawmix Optimizer'!S13","v":0.1},{"$f":"'Rawmix Optimizer'!T13","v":1},"%",1.0000000000000007,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOI",{"$f":"'Rawmix Optimizer'!S14","v":33},{"$f":"'Rawmix Optimizer'!T14","v":36},"%",34.324605133521011,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"'Rawmix Optimizer'!S15","v":99.5},{"$f":"'Rawmix Optimizer'!T15","v":100.5},"%",{"$f":"SUM(V6:V14)","v":99.785022885505526},"%"]
["Final Rawmix"]
[null,"%",{"$f":"C18*100/$S$3","v":0},{"$f":"D18*100/$S$3","v":0},44.391208182053184,21.19335123513126,0,9.0809623657681975,0,4.1360449080596489,8.3000000000000007,2.7484333089877411,6.7000000000000011,3.3,null,null,"Mineralogical Composition",null,"MIN","MAX",null,"RESULT"]
[null,"t",{"$f":"C8+C13","v":0},{"$f":"D8+D13","v":0},532.69449818463818,254.32021482157515,0,108.97154838921837,0,49.632538896715786,99.6,32.981199707852895,80.400000000000006,39.6,null,null,null,"Calcite",{"$f":"'Rawmix Optimizer'!S18","v":0},{"$f":"'Rawmix Optimizer'!T18","v":100},"%",{"$f":"IFERROR(SUMPRODUCT(C41:N41,$C$17:$N$17)/100,0)","v":34.304611491537223},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dolomite",{"$f":"'Rawmix Optimizer'!S19","v":0},{"$f":"'Rawmix Optimizer'!T19","v":100},"%",3.5814335470043517,"%"]
[null,null,{"$f":"Materials!B57&\" \"&FIXED(IF((SUMIF(C4:N4,Materials!B57,'Rawmix Modifier'!C18:N18))>=S3,S3,(SUMIF(C4:N4,Materials!B57,'Rawmix Modifier'!C18:N18))),0)&\" of \"&FIXED(IF((SUMIF(C4:N4,Materials!B57,'Rawmix Modifier'!C9:N9))>=S3,S3,(SUMIF(C4:N4,Materials!B57,'Rawmix Modifier'!C9:N9))),0)&\" t/d used\"","v":"PrimHighCa 896 of 1.200 t/d used"},null,null,null,{"$f":"Materials!B59&\" \"&FIXED(IF((SUMIF(C4:N4,Materials!B59,'Rawmix Modifier'!C18:N18))>=S3,S3,(SUMIF(C4:N4,Materials!B59,'Rawmix Modifier'!C18:N18))),0)&\" of \"&FIXED(IF((SUMIF(C4:N4,Materials!B59,'Rawmix Modifier'!C9:N9))>=S3,S3,(SUMIF(C4:N4,Materials!B59,'Rawmix Modifier'!C9:N9))),0)&\" t/d used\"","v":"SecHighCa 0 of 0 t/d used"},null,null,{"$f":"IF(AND(V3>=C70,V3<=C71),\"Target Amount OK\",IF(V3<C70,\"Add \"&ROUND(C70-V3,0)&\" t!\",IF(V3>C70,\"Remove \"&ROUNDUP(V3-C71,0)&\" t!\",\"OK\")))","v":"Target Amount OK"},null,null,"Sum",{"$f":"FIXED(SUM(C17:N17),1)&\" %\"","v":"99,9 %"},null,null,null,"Quartz",{"$f":"'Rawmix Optimizer'!S20","v":0},{"$f":"'Rawmix Optimizer'!T20","v":100},"%",{"$f":"IFERROR(SUMPRODUCT(C43:N43,$C$17:$N$17)/100,0)","v":23.274225364477537},"%"]
[null,null,{"$f":"Materials!B58&\" \"&FIXED(IF((SUMIF(C4:N4,Materials!B58,'Rawmix Modifier'!C18:N18))>=S3,S3,(SUMIF(C4:N4,Materials!B58,'Rawmix Modifier'!C18:N18))),0)&\" of \"&FIXED(IF((SUMIF(C4:N4,Materials!B58,'Rawmix Modifier'!C9:N9))>=S3,S3,(SUMIF(C4:N4,Materials!B58,'Rawmix Modifier'!C9:N9))),0)&\" t/d used\"","v":"PrimLowCa 50 of 1.200 t/d used"},null,null,null,{"$f":"Materials!B60&\" \"&FIXED(IF((SUMIF(C4:N4,Materials!B60,'Rawmix Modifier'!C18:N18))>=S3,S3,(SUMIF(C4:N4,Materials!B60,'Rawmix Modifier'!C18:N18))),0)&\" of \"&FIXED(IF((SUMIF(C4:N4,Materials!B60,'Rawmix Modifier'!C9:N9))>=S3,S3,(SUMIF(C4:N4,Materials!B60,'Rawmix Modifier'!C9:N9))),0)&\" t/d used\"","v":"SecLowCa 253 of 270 t/d used"},null,null,null,null,null,"=",{"$f":"FIXED(V3,1)&\" t/d\"","v":"1.198,2 t/d"},null,null,null,"Fspars",{"$f":"'Rawmix Optimizer'!S21","v":0},{"$f":"'Rawmix Optimizer'!T21","v":100},"%",8.3885075773996132,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Illite",{"$f":"'Rawmix Optimizer'!S22","v":0},{"$f":"'Rawmix Optimizer'!T22","v":100},"%",19.865536207001913,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorite",{"$f":"'Rawmix Optimizer'!S23","v":0},{"$f":"'Rawmix Optimizer'!T23","v":100},"%",5.6775815417185758,"%"]
["Amount (t/d)",null,{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":5000},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":100},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":50},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":80},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,4,FALSE),0)","v":40},null,null,null,"Smectites",{"$f":"'Rawmix Optimizer'!S24","v":0},{"$f":"'Rawmix Optimizer'!T24","v":100},"%",3.8760285503841003,"%"]
["Costs (/t)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kaolinite",{"$f":"'Rawmix Optimizer'!S25","v":0},{"$f":"'Rawmix Optimizer'!T25","v":100},"%",0.84993510083834678,"%"]
[null,"Transport",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":1.1200000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":6.4},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":6.4},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,5,FALSE),0)","v":6.72}]
[null,"Material",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8.25},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":7.75},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":7.8},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,6,FALSE),0)","v":1},null,null,"Material Type Amounts",null,"MIN","MAX",null,"RESULT"]
[null,"Total",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8.25},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8.5},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":8},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.75},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.8},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":3.12},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.4},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.4},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,7,FALSE),0)","v":7.72},null,null,null,{"$f":"Materials!B57","v":"PrimHighCa"},{"$f":"'Rawmix Optimizer'!S28","v":0},{"$f":"'Rawmix Optimizer'!T28","v":100},"%",{"$f":"SUMIF($C$4:$N$4,R28,$C$17:$N$17)","v":74.665521782952638},"%"]
["Chemical Composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Materials!B58","v":"PrimLowCa"},{"$f":"'Rawmix Optimizer'!S29","v":0},{"$f":"'Rawmix Optimizer'!T29","v":100},"%",{"$f":"SUMIF($C$4:$N$4,R29,$C$17:$N$17)","v":4.1360449080596489},"%"]
[null,"Al2O3",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":1.9333333333333336},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":1.9744444444444442},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":0.94135139573070625},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":2.1572608695652171},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":1.0137916666666669},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":0.9507916666666667},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":8.86},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":11.12},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":5.0595657733070949},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":7.1819305653763035},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":12.907952057586574},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,8,FALSE),0)","v":5.954252209650301},null,null,null,{"$f":"Materials!B59","v":"SecHighCa"},{"$f":"'Rawmix Optimizer'!S30","v":0},{"$f":"'Rawmix Optimizer'!T30","v":100},"%",{"$f":"SUMIF($C$4:$N$4,R30,$C$17:$N$17)","v":0},"%"]
[null,"CaO",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":44.53},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":43.115555555555552},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":50.218938970990699},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":40.93417391304348},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":41.259083333333336},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":43.896041666666669},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":17.579999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":15.72},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":33.579053631541619},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":22.094577088167636},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":14.234052535817616},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,9,FALSE),0)","v":31.742910034264003},null,null,null,{"$f":"Materials!B60","v":"SecLowCa"},{"$f":"'Rawmix Optimizer'!S31","v":0},{"$f":"'Rawmix Optimizer'!T31","v":100},"%",{"$f":"SUMIF($C$4:$N$4,R31,$C$17:$N$17)","v":21.048433308987743},"%"]
[null,"Fe2O3",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":1.6066666666666667},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":1.5077777777777779},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.6189780564263323},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.92356159420289852},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.44887500000000002},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":0.42779166666666663},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":3.36},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":11.12},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":2.4694654826239395},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":3.4199669358934779},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":5.0116264826653678},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,10,FALSE),0)","v":2.4690844122480002}]
[null,"K2O",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":0.98536153197000453},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.1570663762352493},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.766292796005706},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.7829163116069837},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.6061062317022166},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.7324924907841837},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.6061062317022166},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.7324924907841837},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.0218477859133543},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.344126539920925},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":2.2905371896718005},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,11,FALSE),0)","v":1.2091399538368357},null,null,"=",{"$f":"'Rawmix Optimizer'!R33","v":"PrimHighCa"}]
[null,"MgO",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":0.76333333333333331},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":1.2833333333333332},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":0.76309327262775528},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":5.0586413043478249},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":10.383812499999999},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":7.5715833333333338},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.38},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":4.0199999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.1998112057856933},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.4973712043501215},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":1.6877642450213264},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,12,FALSE),0)","v":2.1642589089684541},null,null,"+",{"$f":"'Rawmix Optimizer'!R34","v":"SecHighCa"},{"$f":"'Rawmix Optimizer'!S34","v":70},{"$f":"'Rawmix Optimizer'!T34","v":100},"%",{"$f":"SUMIF(R28:R31,R33,V28:V31)+SUMIF(R28:R31,R34,V28:V31)","v":74.665521782952638},"%"]
[null,"Na2O",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.2372520970180205},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.62229403183421417},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.3388338088445078},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.4230004954321158},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.002688139927479},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.0832546434155623},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":1.2589343501128465},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,13,FALSE),0)","v":0.36274198615105074}]
[null,"SiO2",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":9.2233333333333345},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":10.208888888888891},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":3.7623369408369398},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":8.3949963768115943},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":4.1137083333333333},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":3.7289583333333329},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":46.04},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":46.9},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":24.964309103077643},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":41.46908745057813},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":48.325168076835119},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,14,FALSE),0)","v":27.959624662880799},null,null,"=",{"$f":"'Rawmix Optimizer'!R36","v":"PrimLowCa"}]
[null,"SO3",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.2372520970180205},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.62229403183421417},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.3388338088445078},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.4230004954321158},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":1.0180242576327896},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.47849792602610791},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.3122312679179694},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.13520799513997472},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":9.4721462730788727E-2},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,15,FALSE),0)","v":0.14767464019864063},null,null,"+",{"$f":"'Rawmix Optimizer'!R37","v":"SecLowCa"},{"$f":"'Rawmix Optimizer'!S37","v":0},{"$f":"'Rawmix Optimizer'!T37","v":30},"%",{"$f":"SUMIF(R28:R31,R36,V28:V31)+SUMIF(R28:R31,R37,V28:V31)","v":25.184478217047392},"%"]
[null,"LOI",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":40.48346760732727},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":39.508345560096323},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":39.251340949692846},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":37.902448639557768},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":39.13857441969887},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":40.735344990496934},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":18.137845253032211},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":8.4305116571636063},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":29.07},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":20.55},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":13.97},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,16,FALSE),0)","v":27.460831822100761}]
[null,"Sum",{"$f":"SUM(C30:C38)","v":100},{"$f":"SUM(D30:D38)","v":100},100,100,100,100,100,100,99.678972390094771,99.77552242284213,99.780756400441433,99.470518630298841,null,null,"Size Distribution",null,"MIN","MAX",null,"RESULT"]
["Mineralogical Composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d10",{"$f":"'Rawmix Optimizer'!S40","v":0},{"$f":"'Rawmix Optimizer'!T40","v":100},"um",{"$f":"IFERROR(SUMPRODUCT(C50:N50,$C$17:$N$17)/100,0)","v":1.4295431570866515},"um"]
[null,"Calcite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":34.531433210065842},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":28.66},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":27.139074372553537},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":37.530494566422703},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":48.86},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":42.88250787827478},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":37.530494566422703},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":48.86},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":50.789211467910683},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":33.33295542152284},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":22.15215535638071},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,17,FALSE),0)","v":53.709999999999994},null,null,null,"d20",{"$f":"'Rawmix Optimizer'!S41","v":0},{"$f":"'Rawmix Optimizer'!T41","v":100},"um",{"$f":"IFERROR(SUMPRODUCT(C51:N51,$C$17:$N$17)/100,0)","v":2.8895260339325342},"um"]
[null,"Dolomite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":3.0655271940110036},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":2.9850000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":2.5708035919871057},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":1.9948990907074737},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":9.3049999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":9.3210573350265733},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":1.9948990907074737},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":9.3049999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":5.1881878708274831},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":5.262799873021633},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":0.35958173282116945},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,18,FALSE),0)","v":5.66},null,null,null,"d50",{"$f":"'Rawmix Optimizer'!S42","v":0},{"$f":"'Rawmix Optimizer'!T42","v":100},"um",{"$f":"IFERROR(SUMPRODUCT(C52:N52,$C$17:$N$17)/100,0)","v":9.6931457531386709},"um"]
[null,"Quartz",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":22.338098674122847},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":29.175000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":24.691457517844807},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.987580394766024},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.494999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":22.375476224072244},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.987580394766024},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.494999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":15.526065492096562},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":27.844542197632762},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":23.16794707639778},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,19,FALSE),0)","v":18.78},null,null,null,"d80",{"$f":"'Rawmix Optimizer'!S43","v":0},{"$f":"'Rawmix Optimizer'!T43","v":100},"um",{"$f":"IFERROR(SUMPRODUCT(C53:N53,$C$17:$N$17)/100,0)","v":27.857993123427423},"um"]
[null,"Fspars",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":7.7996752953909994},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":11.945},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":10.926778724384066},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":5.4213794632956311},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":4.1550000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":4.0626028879168423},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":5.4213794632956311},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":4.1550000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":7.321436659268989},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":8.0098408235454173},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":11.580239009816477},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,20,FALSE),0)","v":7.4099999999999993},null,null,null,"d90",{"$f":"'Rawmix Optimizer'!S44","v":0},{"$f":"'Rawmix Optimizer'!T44","v":100},"um",{"$f":"IFERROR(SUMPRODUCT(C54:N54,$C$17:$N$17)/100,0)","v":42.565715392066686},"um"]
[null,"Illite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":23.907514640511486},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":15.641588785046725},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":21.054090264826556},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":22.631953674194964},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":10.161498708010337},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":15.726334908558968},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":22.631953674194964},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":10.161498708010337},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":12.283154296874999},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":16.173945605045329},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":31.861040742234771},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,21,FALSE),0)","v":8.3573752711496763}]
[null,"Chlorite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":4.3215812388302872},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":5.8847962320294727},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":6.6363288792389463},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":6.7862652778920385},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":2.4174697525449544},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":3.5501793265203281},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":6.7862652778920385},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":2.4174697525449544},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":4.9551064948598604},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":5.2177253554814991},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":3.0782081195186981},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,22,FALSE),0)","v":3.3363748276726657},null,null,"Klinker Composition",null,"MIN","MAX",null,"RESULT"]
[null,"Smectites",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":3.3589070156090517},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":4.4610591900311514},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":6.0782693024990673},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":1.2974912016327989},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":0.59216192937123169},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":0.86646473325393758},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":1.2974912016327989},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":0.59216192937123169},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":2.6365356445312496},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":2.6184469846275125},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":6.8963291649858798},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,23,FALSE),0)","v":1.4182212581344906},null,null,null,"LSF",{"$f":"'Rawmix Optimizer'!S47","v":98},{"$f":"'Rawmix Optimizer'!T47","v":102},null,{"$f":"IFERROR((100*V7)/(2.8*V12+1.2*V6+0.65*V8),0)","v":98.805714189971397}]
[null,"Kaolinite",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.67726273145847782},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.86255579289264472},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.90331155343542835},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.34993633108835559},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.57886961007347815},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":1.2153767063763288},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.34993633108835559},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.57886961007347815},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":1.3002035637338889},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":1.5398820548456598},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.90442197326064844},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,24,FALSE),0)","v":0.8980286430431712},null,null,null,"SR",{"$f":"'Rawmix Optimizer'!S48","v":2.4},{"$f":"'Rawmix Optimizer'!T48","v":2.8},null,{"$f":"IFERROR(V12/(V6+V8),0)","v":2.7374353241054195}]
["Size Distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR",{"$f":"'Rawmix Optimizer'!S49","v":1.7},{"$f":"'Rawmix Optimizer'!T49","v":2.1},null,{"$f":"IFERROR(V6/V8,0)","v":1.8392155514933262},null,null,null,null,null," "]
[null,"d10",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.157},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.163},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.407},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.639},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.2829999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.464},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.639},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.2829999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.077},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.3029999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.615},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,25,FALSE),0)","v":1.157},null,null,null,"Na_eq",{"$f":"'Rawmix Optimizer'!S50","v":0.1},{"$f":"'Rawmix Optimizer'!T50","v":5},null,{"$f":"IFERROR(SUMPRODUCT(C59:N59,$C$17:$N$17)/100,0)","v":2.2910417651160144}]
[null,"d20",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.1789999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.2029999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":3.024},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":3.1850000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.4849999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.7120000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":3.1850000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.4849999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.0859999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.6970000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.9969999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,26,FALSE),0)","v":2.2730000000000001}]
[null,"d50",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.9580000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.5190000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":10.29},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":10.138},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.51},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":8.2639999999999993},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":10.138},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.51},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":8.9710000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":13.067},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":7.8319999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,27,FALSE),0)","v":8.702},null,null,"Costs",null,null,null,null,"RESULT"]
[null,"d80",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":27.535},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":23.001999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":26.619},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":29.742999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":24.65},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":24.248999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":29.742999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":24.65},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":37.700000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":45.17},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":19.591000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,28,FALSE),0)","v":25.248999999999999},null,null,null,"Transport",null,null,null,{"$f":"IFERROR(SUMPRODUCT(C26:N26,C17:N17)/100,0)","v":0.91941973177521552},"CHF/t"]
[null,"d90",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":42.628},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":34.874000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":39.704999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.734000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.186},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":37.713000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.734000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":44.186},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":60.241999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":66.617999999999995},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":32.104999999999997},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,29,FALSE),0)","v":37.128},null,null,null,"Material",null,null,null,{"$f":"IFERROR(SUMPRODUCT(C27:N27,C17:N17)/100,0)","v":6.8112936194650082},"CHF/t"]
["Klinker Composition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"IFERROR(SUMPRODUCT(C28:N28,C17:N17)/100,0)","v":7.7307133512402233},"CHF/t"]
[null,"LSF",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":152.55398599961171},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":135.01340426605336},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":416.18477147884272},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":153.34012516136121},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":316.72700480439465},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":370.11533947776928},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":12.404041544366674},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":10.349458826007954},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":43.284974662007649},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":17.403507013400326},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":9.2394372495207016},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,30,FALSE),0)","v":36.470611201449103},null,null,null,{"$f":"\"Total for \"&FIXED(V3,1,TRUE)&\" tons\"","v":"Total for 1198,2 tons"},null,null,null,{"$f":"V55*V3","v":9262.9407374560396},"CHF"]
[null,"SR",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.605461393596987},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.9317166560306327},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.4112452249336132},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.7249205287031626},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.8124715132178668},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.7049205101855769},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.7675941080196402},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.1088129496402876},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.3157398680490102},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.9114778694673671},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":2.6967803940413262},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,31,FALSE),0)","v":3.3193051539924996}]
[null,"AR",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1.203319502074689},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1.3095062638172437},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1.5208154569575461},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.3358061694056169},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.2585166620254342},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.2225577091652871},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.6369047619047619},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.048850574712644},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.1},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.5756013745704465},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,32,FALSE),0)","v":2.4115223360181512}]
[null,"Na_eq",{"$f":"_xlfn.IFNA(VLOOKUP(C$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":0.88561998505428352},{"$f":"_xlfn.IFNA(VLOOKUP(D$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.3836437073970083},{"$f":"_xlfn.IFNA(VLOOKUP(E$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.5010544686162621},{"$f":"_xlfn.IFNA(VLOOKUP(F$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.5961594284695111},{"$f":"_xlfn.IFNA(VLOOKUP(G$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.0748421580928484},{"$f":"_xlfn.IFNA(VLOOKUP(H$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.6184779849621009},{"$f":"_xlfn.IFNA(VLOOKUP(I$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.0748421580928484},{"$f":"_xlfn.IFNA(VLOOKUP(J$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.6184779849621009},{"$f":"_xlfn.IFNA(VLOOKUP(K$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.6750639830584662},{"$f":"_xlfn.IFNA(VLOOKUP(L$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.9676899066835309},{"$f":"_xlfn.IFNA(VLOOKUP(M$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":2.7661078209168912},{"$f":"_xlfn.IFNA(VLOOKUP(N$3,Materials!$B$4:$AH$53,33,FALSE),0)","v":1.1583560757756888}]
[]
["ButtonHelpers"]
[null,"MINposs",{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,"MAXposs",{"$f":"C24","v":5000},{"$f":"D24","v":5000},5000,5000,5000,5000,5000,5000,100,50,80,40]
[null,"ButtV",0,0,532.69449818463818,254.32021482157515,0,108.97154838921837,0,49.632538896715786,99.6,33,80.400000000000006,39.6]
[null,"Value",{"$f":"ROUND((C64-C8),0)","v":0},{"$f":"ROUND((D64-D8),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
["TargetTons",null,{"$f":"S3","v":1200},"t"]
[null,"TTvar",{"$f":"S4","v":0.15},"%"]
[null,"TTmin",{"$f":"C68-(C69/100*C68)","v":1198.2},"t"]
[null,"TTmax",{"$f":"C68+(C69/100*C68)","v":1201.8},"t"]
[]
["AmountSum",null,{"$f":"SUM(C17:N17)","v":99.850000000000023}]
[null,"ASmin",{"$f":"C70*100/C68","v":99.85}]
[null,"ASmax",{"$f":"C71*100/C68","v":100.15}]