{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["leesme","omrekenen","functies"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"leesme","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Werkblad omrekenen"]
[null,"In dit werkblad kun je vanuit een gegeven waarde voor een meeteenheid de andere waarden berekenen."]
[null,"In deze gekleurde cellen kun je een getal invoeren."]
[null,"In deze gekleurde cellen wordt een waarde berekend."]
[null,"De gebruikte formules staan in de cel rechts van de berekeningscel. Een toelichting op deze formules vind je in het artikel \"SG-BRIX_PLATO\"op de website."]
[]
[null,"Werkblad functies"]
[null,"Voor gebruik in een brouwprogramma in Excel zijn voor een aantal omrekeningen eigen gedefinieerde formules gemaakt. In dit werkblad wordt het gebruik van deze formules gedemonstreerd. Deze functies zijn:"]
[null,"Plato2Brix(plato)"]
[null,"Zet de meegegeven waarde voor plato om naar Brix via factor 1,04."]
[null,"Brix2Plato(brix)"]
[null,"Zet de meegegeven waarde voor brix om naar Plato via factor 1,04."]
[null,"SG2Plato(sg; methode)"]
[null,"Zet de meegegeven waarde voor sg om naar Plato. Optioneel kan de berekeingsmethode, \"simpel\" (default) of \"clerck\" worden meegegeven."]
[null,"Plato2SG(plato;methode)"]
[null,"Zet de meegegeven waarde voor plato om naar SG. Optioneel kan de berekeingsmethode, \"simpel\" (default) of \"clerck\" worden meegegeven."]
[]
[null,"Algemeen"]
[null,"De werkbladen zijn beveiligd zonder wachtwoord."]

{"sheet":"omrekenen","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,5,14,8],[14,1,14,4]]}
[null,"Dichtheid (gr/lit)",null,"SG",null,"SG_punten"]
["Invoeren:",1050,null,1.05,null,50]
[]
["Dichtheid (gr/lit)",{"$f":"B2","v":1050},null,{"$f":"D2*1000","v":1050},{"$f":"_xlfn.FORMULATEXT(D4)","v":"=D2*1000"},{"$f":"F2+1000","v":1050},{"$f":"_xlfn.FORMULATEXT(F4)","v":"=F2+1000"}]
["SG",{"$f":"B2/1000","v":1.05},{"$f":"_xlfn.FORMULATEXT(B5)","v":"=B2/1000"},{"$f":"D2","v":1.05},null,{"$f":"(F2+1000)/1000","v":1.05},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=(F2+1000)/1000"}]
["SG_punten",{"$f":"B2-1000","v":50},"=B2-1000",{"$f":"1000*(D2-1)","v":50.000000000000043},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=1000*(D2-1)"},{"$f":"F2","v":50}]
["Plato (eenvoudig)",{"$f":"250*(B5-1)","v":12.500000000000011},"=250*(B5-1)",{"$f":"250*(D2-1)","v":12.500000000000011},{"$f":"_xlfn.FORMULATEXT(D7)","v":"=250*(D2-1)"},{"$f":"F2/4","v":12.5},{"$f":"_xlfn.FORMULATEXT(F7)","v":"=F2/4"}]
["Brix",{"$f":"PlatoBrixFactor*B7","v":13.000000000000011},"=PlatoBrixFactor*B7",{"$f":"PlatoBrixFactor*D7","v":13.000000000000011},{"$f":"_xlfn.FORMULATEXT(D8)","v":"=PlatoBrixFactor*D7"},{"$f":"PlatoBrixFactor*F7","v":13},{"$f":"_xlfn.FORMULATEXT(F8)","v":"=PlatoBrixFactor*F7"}]
[]
["Plato (Clerck)",{"$f":"259-259/B5","v":12.333333333333343},"=259-259/B5",{"$f":"259-259/D2","v":12.333333333333343},{"$f":"_xlfn.FORMULATEXT(D10)","v":"=259-259/D2"},{"$f":"259-259/F5","v":12.333333333333343},{"$f":"_xlfn.FORMULATEXT(F10)","v":"=259-259/F5"}]
["Brix",{"$f":"PlatoBrixFactor*B10","v":12.826666666666677},"=PlatoBrixFactor*B10",{"$f":"PlatoBrixFactor*D10","v":12.826666666666677},"=PlatoBrixFactor*D10",{"$f":"PlatoBrixFactor*F10","v":12.826666666666677},"=PlatoBrixFactor*F10"]
[]
[]
["Plato2Brix factor"]
[1.04,"Plato-SG via eenvoudige benaderingsformule",null,null,null,"Plato-SG via formule Clerck"]
[null,"Plato",null,"Brix",null,"Plato",null,"Brix"]
["Invoeren:",12.5,null,13,null,12.5,null,13]
[]
["Dichtheid (gr/lit)",{"$f":"B20*1000","v":1050},{"$f":"_xlfn.FORMULATEXT(B19)","v":"=B20*1000"},{"$f":"D20*1000","v":1050},{"$f":"_xlfn.FORMULATEXT(D19)","v":"=D20*1000"},{"$f":"F20*1000","v":1050.7099391480731},{"$f":"_xlfn.FORMULATEXT(F19)","v":"=F20*1000"},{"$f":"H20*1000","v":1050.7099391480731},{"$f":"_xlfn.FORMULATEXT(H19)","v":"=H20*1000"}]
["SG",{"$f":"1+B22/250","v":1.05},{"$f":"_xlfn.FORMULATEXT(B20)","v":"=1+B22/250"},{"$f":"1+D22/250","v":1.05},{"$f":"_xlfn.FORMULATEXT(D20)","v":"=1+D22/250"},{"$f":"259/(259-F22)","v":1.050709939148073},{"$f":"_xlfn.FORMULATEXT(F20)","v":"=259/(259-F22)"},{"$f":"259/(259-H22)","v":1.050709939148073},"=259/(259-H22)"]
["SG_punten",{"$f":"4*B22","v":50},{"$f":"_xlfn.FORMULATEXT(B21)","v":"=4*B22"},{"$f":"4*D22","v":50},"=4*D22",{"$f":"4*F22","v":50},{"$f":"_xlfn.FORMULATEXT(F21)","v":"=4*F22"},{"$f":"4*H22","v":50},"=4*H22"]
["Plato",{"$f":"B17","v":12.5},null,{"$f":"D17/PlatoBrixFactor","v":12.5},{"$f":"_xlfn.FORMULATEXT(D22)","v":"=D17/PlatoBrixFactor"},{"$f":"F17","v":12.5},null,{"$f":"H17/PlatoBrixFactor","v":12.5},{"$f":"_xlfn.FORMULATEXT(H22)","v":"=H17/PlatoBrixFactor"}]
["Brix",{"$f":"PlatoBrixFactor*B17","v":13},{"$f":"_xlfn.FORMULATEXT(B23)","v":"=PlatoBrixFactor*B17"},{"$f":"D17","v":13},null,{"$f":"PlatoBrixFactor*F17","v":13},{"$f":"_xlfn.FORMULATEXT(F23)","v":"=PlatoBrixFactor*F17"},{"$f":"H17","v":13}]

{"sheet":"functies","index":2,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"SG"]
["Invoeren:",1.05]
["Plato (eenvoudig)",{"$f":"SG2Plato(B2)","v":12.499988555908203},{"$f":"_xlfn.FORMULATEXT(B3)","v":"=SG2Plato(B2)"}]
["Plato (eenvoudig)",{"$f":"SG2Plato(B2,\"simpel\")","v":12.499988555908203},{"$f":"_xlfn.FORMULATEXT(B4)","v":"=SG2Plato(B2;\"simpel\")"}]
["Plato (clerck)",{"$f":"SG2Plato(B2,\"clerck\")","v":12.333322525024414},{"$f":"_xlfn.FORMULATEXT(B5)","v":"=SG2Plato(B2;\"clerck\")"}]
["Brix (Plato eenvoudig)",{"$f":"Plato2Brix(B3)","v":12.999988555908203},{"$f":"_xlfn.FORMULATEXT(B6)","v":"=Plato2Brix(B3)"}]
[]
[null,"Plato"]
["Invoeren:",12.5]
["SG (eenvoudig)",{"$f":"Plato2SG(B9)","v":1.0499999523162842},{"$f":"_xlfn.FORMULATEXT(B10)","v":"=Plato2SG(B9)"}]
["SG (eenvoudig)",{"$f":"Plato2SG(B9,\"simpel\")","v":1.0499999523162842},{"$f":"_xlfn.FORMULATEXT(B11)","v":"=Plato2SG(B9;\"simpel\")"}]
["SG (clerck)",{"$f":"Plato2SG(B9,\"clerck\")","v":1.0507099628448486},{"$f":"_xlfn.FORMULATEXT(B12)","v":"=Plato2SG(B9;\"clerck\")"}]
["Brix",{"$f":"Plato2Brix(B9)","v":13},{"$f":"_xlfn.FORMULATEXT(B13)","v":"=Plato2Brix(B9)"}]
[]
[null,"Brix"]
["Invoeren:",13]
["Plato",{"$f":"Brix2Plato(B16)","v":12.5},{"$f":"_xlfn.FORMULATEXT(B17)","v":"=Brix2Plato(B16)"}]
["SG (eenvoudig)",{"$f":"Plato2SG(B17)","v":1.0499999523162842},{"$f":"_xlfn.FORMULATEXT(B18)","v":"=Plato2SG(B17)"}]
["SG (eenvoudig)",{"$f":"Plato2SG(B17,\"simpel\")","v":1.0499999523162842},{"$f":"_xlfn.FORMULATEXT(B19)","v":"=Plato2SG(B17;\"simpel\")"}]
["SG (clerck)",{"$f":"Plato2SG(B17,\"clerck\")","v":1.0507099628448486},{"$f":"_xlfn.FORMULATEXT(B20)","v":"=Plato2SG(B17;\"clerck\")"}]
[]
["Voorbeeld geneste functies:"]
["SG (eenvoudig)",{"$f":"Plato2SG(Brix2Plato(B16))","v":1.0499999523162842},{"$f":"_xlfn.FORMULATEXT(B23)","v":"=Plato2SG(Brix2Plato(B16))"}]