{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Voorblad","Afgewerkte mengers","Tankstalen eindstalen","Vloeibare beladingen","Ontvangen grondstoffen","Extra metingen","Lijsten","Visco","Chart1"],"not_rendered":{"charts":2,"images":6,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart1","index":8,"reason":"not_a_worksheet"}],"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":"Voorblad","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[" "]
[9154700]
[]
[" "]

{"sheet":"Afgewerkte mengers","index":1,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Nr","Datum","Laborant","Materiaalnummer","Batchnummer","Soort","Dynamische viscositeit","Casson","Yield val","Vet %","Suiker %","Kleur","Fijnheid","Smaak","Meter","SAP OK/NOK","Menger","Ploeg ","Extra boter toegevoegd","Vloeibare belading: Ja/Nee","NC/Extra info","Klant","Spoelboter verwerkt Ja/Nee","Spoelboter  Kgr","RTP verwerkt: Ja/Nee","RTP data"]

{"sheet":"Tankstalen eindstalen","index":2,"n_rows":1,"n_cols":18,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Nr","Datum","Laborant","Materiaalnummer","Batchnummer","Soort","Dynamische viscositeit","Casson","Yield val","Vet %","Suiker %","Kleur","Staal","Smaak","Meter","SAP OK/NOK","NC/Extra info","Ploeg"]

{"sheet":"Vloeibare beladingen","index":3,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Nr","Datum","Laborant","Materiaalnummer","Batchnummer","Soort","Dynamische viscositeit","Casson","Yield val","Vet %","Suiker %","Kleur","Fijnheid","Smaak","Meter","SAP OK/NOK","Menger","ploeg","Extra boter toegevoegd","Vloeibare belading: Ja/Nee","NC/Extra info","Klant","Spoelboter verwerkt: Ja/Nee","Aantal Kg's:","RTP Verwerkt Ja/Nee","RTP Soort:"]

{"sheet":"Ontvangen grondstoffen","index":4,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Nr","Datum","Materiaal-nummer","Soort","Batch","Leverancier","Ploeg","Certificaat","NC/Extra info","Laborant","Vet Nir:","Vet Supplier:","Smaak:             Ok/Nok","Kleur Boter: Licht/Donker","Product Type:"]
[1,"2025-05-03"]
[2,"2025-05-03"]
[3,"2025-05-03"]
[4,"2025-05-03"]
[5,"2025-05-03",null,null,null,null,null,"OK",null,null,null,null,null,null,"RFA"]

{"sheet":"Extra metingen","index":5,"n_rows":1,"n_cols":19,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Nr","Datum","Laborant","Materiaalnummer","Batchnummer","Soort","Dynamische viscositeit","Casson","Yield val","Vet %","Suiker %","Kleur","Fijnheid","Smaak","Meter","SAP OK/NOK","Menger","NC/Extra info","Ploeg"]

{"sheet":"Lijsten","index":6,"n_rows":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Lab",null,"Klant",null,"Leverancier",null,"Meter",null,"Menger",null,"MN","Soort",null,"Team",null,"Tank","Kolom1","Lijn",null,"Certificaat"]
["A",null,"AA",null,1,null,"A",null,"1B",null,4002042,"Test1",null,"Laat ",null,1,null,1,null,"OK"]
["B",null,"BB",null,2,null,"B",null,"2B",null,4007980,"Test2",null,"Vroeg",null,2,null,2,null,"NOK"]
["C",null,"CC",null,3,null,"C",null,"3B",null,4012728,"Test3",null,"Nacht",null,3,null,3]
[null,null,"DD",null,4,null,"D",null,"4B",null,3001287,"Test4",null,null,null,4,null,4]
[null,null,null,null,null,null,null,null,"5B",null,4006406,"Test5",null,null,null,5,null,5]
[null,null,null,null,null,null,null,null,null,null,3002704,"Test6",null,null,null,6,null,6]
[null,null,null,null,null,null,null,null,null,null,4006512,"Test7",null,null,null,7,null,7]
[null,null,null,null,null,null,null,null,null,null,1100953,"Test8",null,null,null,8,null,8]
[null,null,null,null,null,null,null,null,null,null,4011986,"Test9",null,null,null,null,null,9]

{"sheet":"Visco","index":7,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,5,8,5],[6,6,8,6],[12,5,13,6],[19,5,19,6],[20,5,20,6]]}
[]
["CB Calculator vanuit de dynamische viscositeit"]
[]
["Volgorde","Visco letter","Ref (mPas)",null,null,"Geef de dynamische viscositeit in:",null,null,null,4562,"mPas"]
[1,"Z2",25118,{"$f":"IF(B5=$F$7,\"<=\",\"\")","v":""},null,"Geef het aantal kilo's af te werken chocolade in:",null,null,null,7265,"kg"]
[2,"Z1",20931,{"$f":"IF(B6=$F$7,\"<=\",\"\")","v":""}]
[3,"Z",17443,"",null,{"$f":"INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1),2)","v":"S"},{"$f":"((INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1),3)-$J$4)/(INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1),3)-INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1)+1,3)))*-1","v":-0.25714285714285712}]
[4,"Y",14536,"",null,"S",{"$f":"((INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1),3)-$J$4)/(INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1),3)-INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1)+1,3)))*-1","v":-0.25714285714285712}]
[5,"X",12113,"",null,"S",{"$f":"((INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1),3)-$J$4)/(INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1),3)-INDEX($A$5:$C$32,MATCH($J$4,$C$5:$C$32,-1)+1,3)))*-1","v":-0.25714285714285712}]
[6,"W",10094,""]
[7,"V",8705,""]
[8,"U",7010,""]
[9,"T",5740,"",null,"Afwerken op visco ==>"]
[10,"S",4760,"<=",null,null,null,22]
[11,"R",3990,""]
[12,"Q",3390,""]
[13,"P",2905,""]
[14,"O",2515,""]
[15,"N",2197,""]
[16,"M",1935,"",null,"Boter toe te voegen ==>",null,{"$f":"$J$5*$H$21/100","v":853.1185714285715}]
[17,"L",1719,"",null,"Verhouding tot choc ==>",null,{"$f":"$H$14+$G$7-MATCH($F$7,$B$5:$B$32,0)","v":11.742857142857144}]
[18,"K",1540,""]
[19,"J",1388,"",null,{"$f":"INDEX($A$5:$C$32,MATCH($F$7,$B$5:$B$32,0),3)","v":4760},{"$f":"INDEX($A$5:$C$32,MATCH($F$7,$B$5:$B$32,0)+1,3)","v":3990}]
[20,"I",1261,"",null,{"$f":"$J$5*($H$14-MATCH($F$7,$B$5:$B$32,0))/100","v":871.8},{"$f":"$J$5*($H$14-(MATCH($F$7,$B$5:$B$32,0)+1))/100","v":799.15},{"$f":"$G$24/$F$24","v":0.91666666666666674}]
[21,"H",1152,""]
[22,"G",1059,""]
[23,"F",979,""]
[24,"E",906.48148148148141,""]
[25,"D",839.33470507544564,""]
[26,"C",777.16176395874595,""]
[27,"B",719.5942258877277,""]
[28,"A",666.29094989604414,""]