{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Calculator","Log","DSR2.0","Volume Calc","PPM>ml","S-calc","Fe dosing","CarbonVS3","CSR v5","Saltalc","SG2","EZCalc2","CompactCalc"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":"Calculator","index":0,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,11,9,11],[14,1,14,2],[6,9,7,9],[6,10,7,10],[16,1,16,2],[5,9,5,10],[17,1,17,2],[18,9,18,10],[26,1,26,8],[18,1,18,2],[21,1,21,2],[25,1,25,8],[1,5,1,7],[5,3,5,7],[22,6,22,8],[22,1,23,5],[23,6,23,8],[3,3,3,4],[3,5,3,7],[4,3,4,4],[4,5,4,7]]}
[null,null,null,null,null,"English","Nederlands"]
[null,null,null,null,null,{"$f":"IF($I$2=\"Nederlands\",\"Gekozen Taal\",\"Choosen Language\")","v":"Choosen Language"},null,null,"English"]
[]
[null,{"$f":"IF($I$2=\"Nederlands\",\"***  Dutch Synthetic Reefing  ***  ( de DSR Methode )  ***\",\"***  Dutch Synthetic Reefing  ***  ( The DSR Method )  ***\")","v":"***  Dutch Synthetic Reefing  ***  ( The DSR Method )  ***"},null,{"$f":"IF($I$2=\"Nederlands\",\"Gebruikers naam:\",\"Name user :\")","v":"Name user :"},null,"New tank",null,null,"vers.190304 compact"]
[null,{"$f":"IF($I$2=\"Nederlands\",\"DSR Mineralen Calculator by GlennF\",\"DSR Minerals Calculator by GlennF\")","v":"DSR Minerals Calculator by GlennF"},null,{"$f":"IF($I$2=\"Nederlands\",\"welke handeling ? \",\"What action ? \")","v":"What action ? "},null,"Correction",null,null,{"$f":"IF($I$2=\"Nederlands\",\"Laatste aanpassing\",\"Last saved date\")","v":"Last saved date"}]
[null,{"$f":"IF($I$2=\"Nederlands\",\" Water volume voor Calculaties ( in liters )\",\"Water volume for Calculations ( in liters )\")","v":"Water volume for Calculations ( in liters )"},100,null,null,null,null,null,{"$f":"TODAY()","v":"2021-07-18"},{"$f":"IF($I$2=\"Nederlands\",\"Maximale dag correcties\",\"Maximum day corrections\")","v":"Maximum day corrections"},null,{"$f":"IF($I$2=\"Nederlands\",\"Auto doseer oplossingen\",\"Auto dosing Solutions\")","v":"Auto dosing Solutions"}]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Meting / Range / max. Verhoging/dag / Test set / interval\",\"Measurement / Range / max.TopUp/day  / Used test / Test interval\")","v":"Measurement / Range / max.TopUp/day  / Used test / Test interval"},null,{"$f":"IF($I$2=\"Nederlands\",\"gemeten waarde\",\"Measured value\")","v":"Measured value"},{"$f":"IF($I$2=\"Nederlands\",\"Target waarde\",\"Target  value\")","v":"Target  value"},{"$f":"IF($I$2=\"Nederlands\",\"Correctie waarden\",\"Correction\")","v":"Correction"},{"$f":"IF($I$2=\"Nederlands\",\"Nieuwe aanmaak\",\"New water\")","v":"New water"},null,{"$f":"IF($I$2=\"Nederlands\",\"eenheid / Grondstof\",\"Units /  Product\")","v":"Units /  Product"},{"$f":"IF($I$2=\"Nederlands\",\"Aantal dagen te doseringen\",\"Total days to dose\")","v":"Total days to dose"},{"$f":"IF($I$2=\"Nederlands\",\"Dag dosering \",\"Single day dosing \")","v":"Single day dosing "},{"$f":"IF($I$2=\"Nederlands\",\" (extra) verbruik deze periode (ml) \",\"(additional) consumption this period (ml)\")","v":"(additional) consumption this period (ml)"},"Default target"]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Osmose water vereiste bij nieuwe aanmaak\",\"RO water required when mixing new water\")","v":"RO water required when mixing new water"},null,null,null,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$9=\"x\"),\"No Data\",IF(OR($F$5=\"Correctie Waarden\",$F$5=\"Correction\"),\"\",\"\"))","v":""},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6)*(1-0.0166))","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"Liters / Osmose water\",\"Liters / RO Water\")","v":"Liters / RO Water"}]
[null,{"$f":"IF($I$2=\"Nederlands\",\"PH: (Target 7,95-8,2) Gebruik bij voorkeur 24/7 een electronische meter.\",\"PH: (Target 7,95-8,2) preferably 24/7 electronic measurement \")","v":"PH: (Target 7,95-8,2) preferably 24/7 electronic measurement "},"10:40:00",7.8,8.3000000000000007,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$9=\"x\"),\"No Data\",IF(OR($F$5=\"Correctie Waarden\",$F$5=\"Correction\"),\"\",\"\"))","v":""},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",\"---------\")","v":""},null,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$9=\"x\"),\"No Data\",IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$9>7.69),\" \",\"Use PH+ for Autodosing\"))","v":" "},"-","auto",null,8.3000000000000007]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Saliniteit: (Target 33-34ppt) – (max. 2ppt/dag) - Refractometer - 4wkn.\",\"Salinity: (Target 33-34ppt) – (max. 2ppt/day) – Refractometer - 4wks\")","v":"Salinity: (Target 33-34ppt) – (max. 2ppt/day) – Refractometer - 4wks"},null,33.200000000000003,33,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$10=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E10-$D10)*100,\"\"))","v":-20.000000000000284},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E10-0)*100*(27.2656/35))","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"g / NaCl+ . pure zout\",\"g / NaCl+ . pure Salt\")","v":"g / NaCl+ . pure Salt"},{"$f":"ROUNDUP((E10-D10)/2,0)","v":-1},{"$f":"IF(F10=\"\",0,F10/J10)","v":20.000000000000284},null,33]
[null,{"$f":"IF($I$2=\"Nederlands\",\"KH: (Target 7-9) – (max. 1dKH/dag) - Salifert KH - wekelijks!\",\"KH: (Target 7-9) – (max. 1dKH/day) - Salifert KH - weekly!\")","v":"KH: (Target 7-9) – (max. 1dKH/day) - Salifert KH - weekly!"},null,7.6,9,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$11=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E11-$D11)*3,\"\"))","v":4.2000000000000011},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E11-0)*3)","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"g / KH+ ... NaHCO3*\",\"g / KH+ . SodiumBicarbonate*\")","v":"g / KH+ . SodiumBicarbonate*"},{"$f":"ROUNDUP((E11-D11)/1,0)","v":2},{"$f":"IF(F11=\"\",0,F11/J11)","v":2.1000000000000005},{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$11=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E11-$D11)*3*11.1,\"\"))","v":46.620000000000012},8]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Ca: (Target 420-460) – (max. 20ppm/dag) - Salifert Ca - wekelijks!\",\"Ca: (Target 420-460) – (max. 20ppm/day) - Salifert Ca - weekly!\")","v":"Ca: (Target 420-460) – (max. 20ppm/day) - Salifert Ca - weekly!"},null,415,440,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$12=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E12-$D12)*0.3668,\"\"))","v":9.17},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E12-0)*0.3668)","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"g / Ca+ ... CaCl2*2H2O\",\"g / Ca+ . CalciumChloride\")","v":"g / Ca+ . CalciumChloride"},{"$f":"ROUNDUP((E12-D12)/20,0)","v":2},{"$f":"IF(F12=\"\",0,F12/J12)","v":4.585},{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$12=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E12-$D12)*0.3668*1.429,\"\"))","v":13.10393},440]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Mg: (Target 1300-1400) – (max. 50ppm/dag) - Salifert Mg - 4wkn\",\"Mg: (Target 1300-1400) – (max. 50ppm/day) - Salifert Mg - 4wks\")","v":"Mg: (Target 1300-1400) – (max. 50ppm/day) - Salifert Mg - 4wks"},null,"x",1350,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$13=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E13-$D13)*0.836,\"\"))","v":"No Data"},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",(($C$6/1000)*($E13-($G$14/$C$6)*1000*(24.31/246.482))*(203.306/24.31)))","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"g / Mg+ ... MgCl2*6H2O\",\"g / Mg+ . MagnesiumChloride\")","v":"g / Mg+ . MagnesiumChloride"},{"$f":"ROUNDUP((E13-D13)/50,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F13=\"\",0,F13/J13)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$13=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E13-$D13)*0.836*1.33,\"\"))","v":"No Data"},1350]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Mg+Sulfaat: (alleen bij nieuw aanmaak gewenst)\",\"Mg+Sulfate: (only to be used when mixing new water)\")","v":"Mg+Sulfate: (only to be used when mixing new water)"},null,"x",904,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$13=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E13-$D13)*0.836*0,\"\"))","v":"No Data"},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/1000)*($E14-0)*(246.482/32.06))","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"g / ....... MgSO4\",\"g / ....... MagnesiumSulphate\")","v":"g / ....... MagnesiumSulphate"},null," ",null,904]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Kalium: (Target 380-420) – (20ppm/d) - RedSea Potass. - 8wkn\",\"Potassium: (Target 380-420) – (20ppm/d) - RedSea Potass. - 8wks\")","v":"Potassium: (Target 380-420) – (20ppm/d) - RedSea Potass. - 8wks"},null,"x",390,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$15=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E15-$D15)*0.667,\"\"))","v":"No Data"},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E15-0)*0.667*1)","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"ml / K+... Vloeistof\",\"ml / K+... Liquid\")","v":"ml / K+... Liquid"},{"$f":"ROUNDUP((E15-D15)/20,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F15=\"\",0,F15/J15)","v":{"$error":"#VALUE!"}},null,390]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Strontium: (Target 3-10) – (3ppm/dag) - Salifert Sr - (50:1 CaSr=12wkn)\",\"Strontium: (Target 3-10) – (3ppm/day) - Salifert Sr - (50:1 CaSr=12wks)\")","v":"Strontium: (Target 3-10) – (3ppm/day) - Salifert Sr - (50:1 CaSr=12wks)"},null,"x",8,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$16=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E16-$D16)*3.04,\"\"))","v":"No Data"},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E16-0)*3.04)","v":""},null,"ml / Sr+ .... Strontium",{"$f":"ROUNDUP((E16-D16)/3,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F16=\"\",0,F16/J16)","v":{"$error":"#VALUE!"}},null,8]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Boor: (Target 3,5-4,4)  (2ppm/dag) - Salifert Borium - 12wkn\",\"Boron: (Target 3,5-4,4)  (2ppm/day) - Salifert Borium - 12wks\")","v":"Boron: (Target 3,5-4,4)  (2ppm/day) - Salifert Borium - 12wks"},null,"x",4,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$17=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E17-$D17)*12.68,\"\"))","v":"No Data"},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E17-0)*12.68)","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"ml / B+ ..... Boor\",\"ml / B+ ..... Boron\")","v":"ml / B+ ..... Boron"},{"$f":"ROUNDUP((E17-D17)/2,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F17=\"\",0,F17/J17)","v":{"$error":"#VALUE!"}},null,4]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Jodide: (Target 0,06) – (0,03ppm/dag)  - Salifert I - (0,006ppm/d=8wkn)\",\"Iodide: (Target 0,06) – (0,03ppm/day)  - Salifert I - (0,006ppm/d=8wks)\")","v":"Iodide: (Target 0,06) – (0,03ppm/day)  - Salifert I - (0,006ppm/d=8wks)"},null,"x",0.06,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$18=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E18-$D18)*100*0.26,\"\"))","v":"No Data"},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E18-0)*100*0.26)","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"ml / I+ ...... Jodide\",\"ml / I+ ...... Iodide\")","v":"ml / I+ ...... Iodide"},{"$f":"ROUNDUP((E18-D18)/0.03,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(F18=\"\",0,F18/J18)","v":{"$error":"#VALUE!"}},null,0.06]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Mangaan (ppb): (Target 0,4ppb) – (doseren 0,1ppb/dag)  - \",\"Manganese (ppb): (Target 0,4ppb) – (dosing 0,1ppb/day)  - \")","v":"Manganese (ppb): (Target 0,4ppb) – (dosing 0,1ppb/day)  - "},null,"x",0.4,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$19=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*($E19-$D19)*10*0.1,\"\"))","v":"No Data"},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E19-0)*10*0.1*0)","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"ml / Mn+ ( ppb ).. Mangaan\",\"ml / Mn+  ( ppb ) .. Manganese\")","v":"ml / Mn+  ( ppb ) .. Manganese"},null,null,null,0.4]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Fosfaat: (Target 0,04-0,08) (0,04ppm/d) - RedSea PO4 - wekelijks!\",\"Phosphate: (Target 0,04-0,08) (0,04ppm/d) -  RedSea PO4 - weekly!\")","v":"Phosphate: (Target 0,04-0,08) (0,04ppm/d) -  RedSea PO4 - weekly!"},null,0,0.08,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\",$F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$20=\"x\"),\"No Data\",IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\",$F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$20>$E$20),($C$6/100)*(0.15)*10*0.4975,($C$6/100)*($E20-$D20)*100*0.1))","v":0.8},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E20-0)*100*0.1*0)","v":""},null,{"$f":"IF(AND(OR($F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$20=\"x\"),\"No Data\",IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\",$F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$20>$E20),\"ml / Fe+** 0,15ppm max.dosing.\",\"ml / PO4+ .. Phosphate**\"))","v":"ml / PO4+ .. Phosphate**"},1,{"$f":"IF($I$2=\"Nederlands\",\"tabel\",\"table\")","v":"table"},{"$f":"IF(AND(OR($F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$20=\"x\"),\"\",IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\",$F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$20<0.11,$D$20>0.01),\"\",\"< Alarm!\"))","v":"< Alarm!"},0.04]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Nitraat (rev.2019): (Target 1-3) (2ppm/d)  - Salifert NO3 - 3wkn\",\"Nitrate (rev.2019): (Target 1-3)  (2ppm/d) - Salifert NO3 - 3wks\")","v":"Nitrate (rev.2019): (Target 1-3)  (2ppm/d) - Salifert NO3 - 3wks"},"2xNO3+",0,2.5,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\",$F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$21=\"x\"),\"No Data\",IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$21>$E$21),\"-----\",($C$6/100)*($E21-$D21)*(0.8)))","v":2},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*($E21-0)*(0.8)*0)","v":""},null,{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$21=\"x\"),\"No Data\",IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$21>$E$21),\". use CarbonVS table to reduce***.\",\"ml / 2xNO3+ . Nitrate NEW!!!\"))","v":"ml / 2xNO3+ . Nitrate NEW!!!"},1,{"$f":"IF($I$2=\"Nederlands\",\"tabel\",\"table\")","v":"table"},{"$f":"IF(AND(OR($F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$21=\"x\"),\"\",IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\",$F$5=\"New water\",$F$5=\"Nieuwe aanmaak\"),$D$21<6,$D$21>0.4),\"\",\"< Alarm!\"))","v":"< Alarm!"},2.5]
[null,{"$f":"IF($I$2=\"Nederlands\",\"Ijzer: (Piek waarde, geen streefwaarde)  - Sera Fe - 8wkn\",\"Iron: (Peek value, not target  value) - Sera Fe - 8wks\")","v":"Iron: (Peek value, not target  value) - Sera Fe - 8wks"},null,0,{"$f":"IF($D$20>$E$20,\"0,15\",\"0,02\")","v":"0,02"},{"$f":"IF(AND(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),$D$22=\"x\"),\"No Data\",IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),($C$6/100)*(VALUE($E22)-$D22)*10*0.4975,\"\"))","v":9.9500000000000005E-2},{"$f":"IF(OR($F$5=\"Correction\",$F$5=\"Correctie Waarden\"),\"\",($C$6/100)*(VALUE($E22)-0)*10*0.4975)","v":""},null,{"$f":"IF($I$2=\"Nederlands\",\"ml / Fe+ .... Ijzer** \",\"ml / Fe+ .... Iron**\")","v":"ml / Fe+ .... Iron**"},1,{"$f":"IF($I$2=\"Nederlands\",\"geleidelijk\",\"gradually\")","v":"gradually"},null,{"$f":"IF($D$20>$E$20,\"0,15\",\"0,02\")","v":"0,02"}]
[null,"first measurement after start of tank",null,null,null,null,{"$f":"IF($I$2=\"Nederlands\",\"Verlichtings type en samenstelling:\",\"Lighting type and composition:\")","v":"Lighting type and composition:"}]
[null,null,null,null,null,null,{"$f":"IF($I$2=\"Nederlands\",\"geef aan wanneer de lampen  zijn aangebracht en/of vervangen:\",\"please mention when the fixture/lamps were placed or renewed:\")","v":"please mention when the fixture/lamps were placed or renewed:"}]
[]
[null,{"$f":"IF($I$2=\"Nederlands\",\"- Beveiliging: Het werkblad is beveiligd om onbedoeld overschijven van de velden en formules te voorkomen. De gele cellen dienen nagelopen en eventueel aangepast te worden. \"&\" Wanneer je  een waarde niet gemeten hebt, plaats een 'x' dit geef een melding 'No Data'. Dit voorkomt fouten bij het toedienen en verschaft duidelijkheid als je een screenprint maakt voor support.\",\"- Protection: The worksheet is protected against accidental  deleting of the formulas. Only the yellow fields are editable. \"&\" To prevent misinterpretation fill in a 'x' when you did not measure the value. This wil show the messsage 'No Data'. This prevent mistakes when dosing and is useful when making a screenprint for support purpose.\")","v":"- Protection: The worksheet is protected against accidental  deleting of the formulas. Only the yellow fields are editable.  To prevent misinterpretation fill in a 'x' when you did not measure the value. This wil show the messsage 'No Data'. This prevent mistakes when dosing and is useful when making a screenprint for support purpose."}]
[null,{"$f":"IF($I$2=\"Nederlands\",\"* KH+ nooit gelijktijdig met andere zouten (Ca,Mg,K,Sr) toevoegen ter voorkoming van neerslag . Toevoegen als alle zouten volledig zijn opgelost.\",\"* KH+ may only be added after all salts are fully dissolved (Ca,Mg,K,Sr). This is to prevent precipitation of chalk.\")","v":"* KH+ may only be added after all salts are fully dissolved (Ca,Mg,K,Sr). This is to prevent precipitation of chalk."}]
[]
[null,"free edit area  >>>>>"]

{"sheet":"Log","index":1,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,11,0,17]]}
[" ",null,"DATA LOG  (information copied from the DSR Calculator)",null,null,null,null,null,null,null,null,{"$f":"+Calculator!F4","v":"New tank"},null,null,null,null,null,null,"Never delete all data above Row 5, or the graphics will not work anymore!  Just wait till you have your own first 5 datarows, than you can delete the \"dummy\" ones."]
["Date","Action","liters","Time","PH","Sal","KH","Ca","Mg","SO4","K","Sr","B","I","Mn (ppb)","PO4","2xNO3","Fe","Short Comment on the tank"]
[]
["2018-11-17","CarbonDos.",700,"17:24:32",null,null,null,null,null,null,null,null,null,null,null,null,"... ml  ",null,"CarbonVS or EZ Carbon in milliliters ,Daily Dosing  "]
["2018-11-17","FeDosing",700,"17:24:32",null,null,null,null,null,null,null,null,null,null,null,"... ml  ",null,null,"Fe or FeTrace Dosing in milliliters, Daily Dosing  "]
["2018-11-17","Ca Dosing",700,"17:24:30",null,null,null,2.9781659090909098,null,null,null,null,null,null,null,null,null,null,"CaSr in milliliters - New Daily Dosing (by DSR2.0). Mix 1L = 700gr Ca+ / 120gr Sr+ "]
["2018-11-17","KH Dosing",700,"17:24:29",null,null,5.2977272727272737,null,null,null,null,null,null,null,null,null,null,null,"PH+/EZBuffer in milliliters - New Daily Dosing (by DSR2.0). if KH+(90gr/L) is used than ml x2"]
[]
["2018-11-12","Ca Dosing",700,"19:34:58",null,null,null,2.9781659090909098,null,null,null,null,null,null,null,null,null,null,"CaSr in milliliters - New Daily Dosing (by DSR2.0). Mix 1L = 700gr Ca+ / 120gr Sr+ "]
["2018-11-12","KH Dosing",700,"19:34:55",null,null,5.2977272727272737,null,null,null,null,null,null,null,null,null,null,null,"PH+/EZBuffer in milliliters - New Daily Dosing (by DSR2.0). if KH+(90gr/L) is used than ml x2"]
["2018-11-12","CarbonDos.",700,"19:34:53",null,null,null,null,null,null,null,null,null,null,null,null,3.5,null,"CarbonVS or EZ Carbon in milliliters ,Daily Dosing  "]
["2018-11-12","FeDosing",700,"19:34:51",null,null,null,null,null,null,null,null,null,null,null,0.7,null,null,"Fe or FeTrace Dosing in milliliters, Daily Dosing  "]
["2018-11-12","Corrections",700,"19:32:44","",-140.00000000000199,29.400000000000006,64.19,"No Data","No Data","No Data","No Data","No Data","No Data","No Data",0,"-----",0.69650000000000001,"Comments:"]
["2018-11-12","Measurement",700,"10:40:00",7.8,33.200000000000003,7.6,415,"x","x","x","x","x","x","x",0.08,6,0,"first measurement after start of tank"]
["2018-11-12","Setpoint",700,"19:32:28",8.3000000000000007,33,9,440,1350,904,390,8,4,0.06,0.4,0.08,2.5,"0,02","Adjust if neccesary"]
["2018-11-12","Saltmix / Start",700,"19:31:45","---------",17995.295999999998,189,1129.7440000000001,3890.2400907492206,4865.0595633187768,1820.91,170.24,355.03999999999996,10.92,0,0,0,0.69650000000000001,"RO water required: 688,38 Liters, Only use the elements required (for correction)"]

{"sheet":"DSR2.0","index":2,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,24,4,25],[21,1,21,5],[21,7,21,11],[22,4,22,5],[22,9,22,11],[36,1,36,19],[38,1,38,19],[40,1,40,19],[31,1,31,19],[4,12,4,19],[23,4,23,5],[23,9,23,11],[24,2,24,5],[24,8,24,11],[25,1,25,2],[25,8,25,11],[0,3,0,12],[26,7,26,11],[0,14,0,18],[4,6,4,8],[32,1,34,19]]}
[null," ",null,"DSR Verbruiks Calculator v.190304 ( DSR 2.0 )",null,null,null,null,null,null,null,null,null,null,{"$f":"+Calculator!F4","v":"New tank"}]
[null,"Date","Action","liters","Time","PH","Sal","KH","Ca","Mg","SO4","K","Sr","B","I","Mn (ppb)","PO4","NO3","Fe"]
[null,"2018-11-03","Measurement",100,"10:40:00",7.94,0,0,0,0,"x",0,0,0,0,0,0,0,0,"< laatste"]
[null,"2018-11-01","Setpoint",100,"17:22:54",8.3000000000000007,33,9,440,1350,904,390,8,4,0.06,0.4,0.08,2.5,"0,02","< Target",null,"start !"]
[null,null,"Extra  p/dag","Eenheid","Vast (gram)","Vloeib. (ml)","Product",null,null,"Dag. start "," dosering (ml)","Nieuw (ml)","Advies meet intervallen, (bij stabiel waarden).  Na de start doseringen met de metingen bijsturen.",null,null,null,null,null,null,null,"T.verbr. p/d"," dosering (ml)",null,null,"Converter ml > gr"]
[null,"Saliniteit",{"$f":"($G$4-$G$3)/($B$3-$B$4)","v":16.5},"ppt",{"$f":"($C$31/100)*(C6)*100","v":1650},null,"DSR NaCl+,  pure Salt",null,null,null,null,{"$f":"K6+F6","v":0},"1x per 4 weken",null,null,null,null,null,null,null,null,null,null,null,"vloeistof (ml)","Vloeistof (gram)"]
[null,"KH  & PH",{"$f":"($H$4-$H$3)/($B$3-$B$4)","v":4.5},"dKH",null,{"$f":"IF(F3<8.4,($C$31/100)*($C$7)*16.65,\"\")","v":74.924999999999997},"DSR PH+, KH+PH verhoger",null,null,"0,3dKH",0,{"$f":"IF(F3 <8.4,K7+F7,\"\")","v":74.924999999999997},"PH 24/7 controleren d.m.v. PH meter. 12x/dag doseren",null,null,null,null,null,null,null,{"$f":"$L$7/(($C$31/100)*16.65)","v":4.5},{"$f":"IF(Q3<8.11,($C$31/100)*16.65*0.4,\"\")","v":6.66},null,null,null,null,"EZ Ratio"]
[null,"KH",{"$f":"($H$4-$H$3)/($B$3-$B$4)","v":4.5},"dKH",{"$f":"($C$31/100)*(C8)*3","v":13.5},{"$f":"IF(F3>=8,($C$31/100)*($C$8)*3*11.1,\"\")","v":""},"DSR KH+, Bicarbonaat",null,null,"0,3dKH",0,{"$f":"IF(F3>=8,K8+F8,\"\")","v":""},"1x per week - 1x per 2 weken (indien stabiel) ",null,null,null,null,null,null,null,{"$f":"$L$8/(($C$31/100)*3*11.1)","v":{"$error":"#VALUE!"}},{"$f":"IF(Q3>=7.81,($C$31/100)*3*11.1*0.4,\"\")","v":""},null,"PH",10860,{"$f":"$Y$8*1.091","v":11848.26},{"$f":"L7/L9","v":0.64974435497248118}]
[null,"Ca",{"$f":"($I$4-$I$3)/($B$3-$B$4)","v":220},"PPM",{"$f":"($C$31/100)*(C9)*0.3668","v":80.695999999999998},{"$f":"($C$31/100)*($C$9)*0.3668*1.429","v":115.314584},"DSR Ca+, Calcium",null,null,"1,45ppm",0,{"$f":"(K9+F9)","v":115.314584},"1x per week - 1x per 2 weken (indien stabiel) ",null,null,null,null,null,null,null,{"$f":"$L$9/(($C$31/100)*0.3668*1.429)","v":220},{"$f":"($C$31/100)*0.3668*1.429*1.45","v":0.76002793999999996},null,"KH",10]
[null,"Mg",{"$f":"($J$4-$J$3)/($B$3-$B$4)","v":675},"PPM",{"$f":"($C$31/100)*(C10)*0.836","v":564.29999999999995},{"$f":"($C$31/100)*($C$10)*0.836*1.33","v":750.51900000000001},"DSR Mg+, Magnesium",null,null,"0,35ppm",0,{"$f":"K10+F10","v":750.51900000000001},"1x per 4 weken",null,null,null,null,null,null,null,{"$f":"$L$10/(($C$31/100)*0.836*1.33)","v":675},{"$f":"($C$31/100)*0.836*1.33*0.35","v":0.38915799999999995},null,"CarbonVS",10]
[null,"SO4",{"$f":"($K$4-$K$3)/($B$3-$B$4)","v":{"$error":"#VALUE!"}},"PPM","-","-","DSR MgSO4, Mg+ Sulfaat",null,null,null,0,"-","1x per kwartaal (labtest).   gebruik  de sulfaat calculator",null,null,null,null,null,null,null,null,0,null,"Mg",10]
[null,"Kalium",{"$f":"($L$4-$L$3)/($B$3-$B$4)","v":195},"PPM",{"$f":"($C$31/100)*(C12)*0.190476","v":37.14282},null,"DSR K+, Kalium",null,null,"n.t.b.",0,0,"1x per 4 weken, 1x per 8 weken (indien stabiel)",null,null,null,null,null,null,null,null,0,null,null,"-"]
[null,"Strontium",{"$f":"($M$4-$M$3)/($B$3-$B$4)","v":4},"PPM",null,{"$f":"($C$31/100)*($C$13)*3.04","v":12.16},"DSR Sr+, Strontium",null,null,"CaSr Mix","-","- ","doseren op Ca/Sr ratio 50:1, 1x per 6 weken  ",null,null,null,null,null,null,null,null,"-",null,null,"-"]
[null,"Boor",{"$f":"($N$4-$N$3)/($B$3-$B$4)","v":2},"PPM",null,{"$f":"($C$31/100)*($C$14)*12.68","v":25.36},"DSR B+, Boor",null,null,"n.t.b.",{"$f":"($C$31/100)*(0)*12.68","v":0},25.36,"op peil brengen en daarna 1x per kwartaal meten",null,null,null,null,null,null,null,null,{"$f":"($C$31/100)*(0)*12.68","v":0},null,"Sr",170.24,{"$f":"$Y$14*1.0525","v":179.17760000000001}]
[null,"Jodide",{"$f":"($O$4-$O$3)/($B$3-$B$4)","v":0.03},"PPM",null,{"$f":"($C$31/100)*($C$15)*100*0.26","v":0.78},"DSR I+,  Jodide",null,null,"0,006ppm",{"$f":"($C$31/100)*(0.006)*100*0.26","v":0.156},0.93600000000000005,"per 4 weken meten en corrigeren",null,null,null,null,null,null,null,null,{"$f":"($C$31/100)*(0.006)*100*0.26","v":0.156},null,"B",355.04,{"$f":"$Y$15*1.0175","v":361.25320000000005}]
[null,"Mangaan",{"$f":"($P$4-$P$3)/($B$3-$B$4)","v":0.2},"ppb",null,{"$f":"($C$31/100)*($C$16)*10*0.1","v":0.2},"DSR  Mn+, Mangaan",null,null,"0,4ppb",{"$f":"($C$31/100)*(0.4)*10*0.1","v":0.4},0.60000000000000009,"1x per kwartaal (labtest)",null,null,null,null,null,null,null,null,{"$f":"($C$31/100)*(0.4)*10*0.1","v":0.4},null,"I2",10,{"$f":"$Y$16*1.001","v":10.009999999999998}]
[null,"Fosfaat",{"$f":"($Q$4-$Q$3)/($B$3-$B$4)","v":0.04},"PPM",null,{"$f":"($C$31/100)*($C$17)*100*0.1","v":0.4},"DSR PO4+, Fosfaat",null,null,"n.t.b.",{"$f":"($C$31/100)*(0)*100*0.1","v":0},0.4,"1x per week - 1x per 2 weken (indien stabiel) ",null,null,null,null,null,null,null,null,{"$f":"($C$31/100)*(0)*100*0.1","v":0},null,"Mn",10,{"$f":"$Y$17*1.001","v":10.009999999999998}]
[null,"Nitraat",{"$f":"($R$4-$R$3)/($B$3-$B$4)","v":1.25},"PPM",null,{"$f":"($C$31/100)*($C$18)*0.8","v":1},"DSR 2xNO3+(rev.2019), Nitraat",null,null,"n.t.b.",{"$f":"($C$31/100)*(0)*1.44","v":0},1,"1x 2-3 weken (indien stabiel) ",null,null,null,null,null,null,null,null,{"$f":"($C$31/100)*(0)*1.44","v":0},null,"PO4",10,{"$f":"$Y$18*1.001","v":10.009999999999998}]
[null,null,null,null,null,null,"DSR CabonVS",null,null,"n.t.b.",{"$f":"($C$31/100)*(0)*1.44","v":0},0,"1x 2-3 weken (indien stabiel) ",null,null,null,null,null,null,null,null,{"$f":"($C$31/100)*(0)*1.44","v":0},null,"NO3",10,{"$f":"$Y$19*1.03528","v":10.3528}]
[null,"Fe",{"$f":"($S$4-$S$3)/($B$3-$B$4)","v":0.01},"PPM",null,{"$f":"($C$31/100)*($C$20)*10*0.4975","v":4.9750000000000003E-2},"DSR Fe+ / DSR FeTrace",null,null,"0,02ppm",{"$f":"($C$31/100)*(0.02)*10*0.4975","v":9.9500000000000005E-2},0.14924999999999999,"1x per 4-8 weken een controle meting tegen overdoseren ",null,null,null,null,null,null,null,null,{"$f":"($C$31/100)*(0.02)*10*0.4975","v":9.9500000000000005E-2},null,"CarbonVS",482,{"$f":"$Y$20*1.03528","v":499.00495999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fe+",10]
[null,"DSR Calcium/Strontium mix  (50:1ppm)",null,null,null,null,null,"DSR KH+ oplossing  (90gr/L)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fe-Trace",10,{"$f":"$Y$22*1.183","v":11.83}]
[null,"Fles (L)","Ca+ (gr)","Sr+ (ml)","RO water (ml)",null,null,"Fles (L)","KH+ (gr)","RO water (ml)",null,null,null,null,null,null,null,null,null,null,null,null,null,"CaSr+",10,{"$f":"$Y$23*1.395","v":13.95}]
[null,1,{"$f":"B24*700","v":700},{"$f":"C24*(3/18.34)","v":114.50381679389314},{"$f":"B24*(1000-419)","v":581},null,null,20,{"$f":"H24*90","v":1800},"aanvullen tot gewenste volume",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluor+",1,{"$f":"$Y$24*1.025","v":1.0249999999999999}]
[null,{"$f":"$C$31/300","v":0.33333333333333331},"advies bij 30 dgn gemiddeld verbruik",null,null,null,null,{"$f":"$C$31/37.5","v":2.6666666666666665},"KH+ advies  bij  30 dgn gemiddeld verbruik"]
[null,"DSR Sr+   gewicht =",null,{"$f":"D24*1.05","v":120.2290076335878},"gram",null,null,{"$f":"H25/2","v":1.3333333333333333},"PH+  container = 50% (elk 2 uur doseren)"]
[]
[null,"vorig",{"$f":"+$B$4","v":"2018-11-01"},"cell B4"]
[null,"laatste",{"$f":"+$B$3","v":"2018-11-03"},"cell B3"]
[null,"dagen",{"$f":"$B$3-$B$4","v":2}," inden stuurwaarden (voor correctie) gewenst, het aantal dagen tussen start en eindwaarde \"1\" maken door de datums aan te passen"]
[null,"Volume (L)",{"$f":"+$D$3","v":100},"cell D3","(laatse meting)"]
[null,"Copieer de te vergelijken waarden  vanuit de log naar regel 3 en 4,  of vul de waarden hierboven zelf in. Regel 4 = Target (of setpoint) & regel 3 = laatste meting. Bij geen meting \"x\" invullen. Indien bij de vorige meting de mineralen zijn aangevuld, dient dit met \"Setpoint\" aangeduid te worden. "]
[null,"De verbruiks calculator berekent het dagelijks verbruik (tekort) van stoffen in het aquarium, door 2 meting te verrichten gedurende een zelf ter bepalen periode. Het meest logische is om een termijn van 1 week aan te houden voor de meeste stoffen.  In het gele geaccentueerd gedeelte zijn de start- en eind waarden in te vullen. Op rij 4 komt de zogenaamde \"setpoint\" en  op rij 3 van de laatste meting. De setpoint is de waarde na de uitgevoerde correcties. Bij het copieren vanuit de log uitsluitend de kolomen tussen datum t/m Fe copieren en plakken !"]
[]
[]
[]
[null,"in het resultaat veld staan: De verbruiken per dag omgerekend in ppt/PPM/ppb, een kolom in grammen per dag, een kolom in vloeistoffen per dag, de te gebruiken producten,  de advies testintervallen en doseerwijze. Nog te bepalen (n.t.b.) betekend dat het verbruik per aquarium kan verschillen en er dus naar behoefte moet worden gedoseerd. "]
[]
[null,"Bij een gemeten PH < 8,11 word het advies verstrekt om het PH+ product van DSR te gebruiken (i.p.v KH+). Dit product stuurt de PH omhoog en is 2x geconcentreerd als de KH+. Ideaal om de KH container klein te houden. Bij een PH tussen 7,80-8,1 kan er gekozen worden tussen KH+ of PH+. Bij een PH boven de 8,11  wordt het gebruik van KH+ geadviseerd."]
[]
[null,"Bij het eerste in gebruiksname van de DSR2.0 calculator staat er een  berekende  baseline dosering (K10), die overeenkomt met de basline dosering. Hier dient het laatst bekend verbruik ingevuld te werden. Baseline doseringen zijn dosering om gelijk mee te starten, op basis van minimaal beschikbaarheid. Natuurlijk is het bij een overschot vanzelfsprekend dat de baseline dosering voor die betreffende stof weggelaten  word."]

{"sheet":"Volume Calc","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,5,26,7],[20,2,20,7],[16,2,17,2],[18,4,18,7],[25,5,25,7],[7,0,13,1],[14,0,17,1],[16,5,17,7],[21,5,21,7],[23,5,23,7],[22,5,22,7],[23,0,24,0],[24,5,24,7]]}
[null,null,null,null,"English","Nederlands"]
[]
["US Galons > Liters Converter","US Galons","Liters",null,null,{"$f":"IF($H$3=\"Nederlands\",\"Gekozen Taal\",\"Choosen Language\")","v":"Choosen Language"},null,"English"]
[null,1,{"$f":"B4*3.78541178","v":3.78541178}]
[]
["***  Water volume  Calculator  ***",{"$f":"IF($H$3=\"Nederlands\",\"Total Berekende Liters\",\"Total Calculated Liters\")","v":"Total Calculated Liters"},"Result (dm3) = (L)",{"$f":"IF($H$3=\"Nederlands\",\"Lengte (cm)\",\"Length (cm)\")","v":"Length (cm)"},{"$f":"IF($H$3=\"Nederlands\",\"Breedte (cm)\",\"Width   (cm)\")","v":"Width   (cm)"},{"$f":"IF($H$3=\"Nederlands\",\" Water Hoogte (cm)\",\"Water Heigth (cm)\")","v":"Water Heigth (cm)"},null,"vers.160314"]
[{"$f":"IF($H$3=\"Nederlands\",\"Totaal berekend  water volume >>>\",\"Total Calculated water Volume >>>\")","v":"Total Calculated water Volume >>>"},{"$f":"SUM(C7:C19)","v":688.58399999999995},{"$f":"(D7*E7*F7)/1000","v":688.64639999999997},248,78,35.6,null,{"$f":"IF($H$3=\"Nederlands\",\"Showbak\",\"Show Tank\")","v":"Show Tank"}]
["....................................................................",null,11.544,39,37,8,null,"Sump"]
[null,null,0,0,76,42,null,"Refugium"]
[null,null,0,0,40,29,null,"Qt1"]
[null,null,0,0,28,61,null,"Qt2"]
[null,null,0,0,28,61,null,"Qt3"]
[null,null,0,248,78,0,null,"Hoogteverval = sump capaciteit (2cm)"]
[null,null,-11.606399999999999,248,78,-0.6,null,"30kg sand"]
[{"$f":"IF($H$3=\"Nederlands\",\"De water volume calculator is een hulpmiddel voor het berekenen van de totale water volume. Deze waarde worden NIET overgenomen naar de DSR Calculator ! \",\"The water volume calculator is a tool to calculate the total water volume. This value is NOT transfered to the DSR Calculator!\")","v":"The water volume calculator is a tool to calculate the total water volume. This value is NOT transfered to the DSR Calculator!"},null,{"$f":"-(((D15*E15*F7)/1000)-((D15*E15*F15)/1000))","v":0},0,32,30,null,{"$f":"IF($H$3=\"Nederlands\",\"overloop kamer (buitenmaat)\",\"Skimmer compartment\")","v":"Skimmer compartment"}]
[null,null,{"$f":"-(D16*E16*F16)/1000","v":0},0,0,{"$f":"+F7","v":35.6},null,{"$f":"IF($H$3=\"Nederlands\",\"Droog kamer (buitenmaat)\",\"Cable compartment\")","v":"Cable compartment"}]
[null,null,{"$f":"-(D18*E18)","v":0},{"$f":"IF($H$3=\"Nederlands\",\"Gewicht (Kg)\",\"Weight (Kg)\")","v":"Weight (Kg)"},"factor",{"$f":"IF($H$3=\"Nederlands\",\"Opbouwen (opgeven gewicht en omreken factor)\",\"Rock formations ( provide weight and factor )\")","v":"Rock formations ( provide weight and factor )"}]
[null,null,null,0,0.75]
[null,null,0,"<<<<<",{"$f":"IF($H$3=\"Nederlands\",\"zelf op te geven volume aftrek\",\"Provide  own volume to substract from total \")","v":"Provide  own volume to substract from total "}]
[]
[null,null,"kilo > liter omreken factor voor verschillende materialen"]
[null,null,{"$f":"-(D22*E22)","v":-8.3651162790697668},10,{"$f":"35.97/43","v":0.83651162790697675},"factor voor koraal zand 0,5-1mm (droog gewicht)"]
[null,null,-5.7037037037037042,10,{"$f":"15.4/27","v":0.57037037037037042},"factor voor koraal zand 0,5-1mm (nat gewicht)"]
[{"$f":"IF($H$3=\"Nederlands\",\"Alleen de GELE velden zijn te bewerken. Het werkblad is beveiligd om overschrijven van formules te  voorkomen\",\"Only the YELLOW fields are editable. The calculation sheet is protected to prevent overwriting of formula's\")","v":"Only the YELLOW fields are editable. The calculation sheet is protected to prevent overwriting of formula's"},null,-7.1578947368421053,10,{"$f":"27.2/38","v":0.71578947368421053},"factor voor dymico filtermassa (dolemiet)"]
[null,null,-4.7659574468085104,10,{"$f":"11.2/23.5","v":0.47659574468085103},"factor voor poreus  levend steen  (luchtig)"]
[null,null,-4.541666666666667,10,{"$f":"10.9/24","v":0.45416666666666666},"factor voor massief  levend steen  (zwaar)"]
[null,null,-3.7844036697247709,10,{"$f":"8.25/21.8","v":0.37844036697247707},"factor voor  massief cement/beton"]
[null,null,{"$f":"SUM(C22:C27)","v":-34.318742502815525},"totaal"]
[]
[]
["free edit area  >>>>>"]

{"sheet":"PPM>ml","index":4,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,1,24,3],[4,1,4,6],[5,1,5,7],[23,1,23,3],[25,1,25,6]]}
[null,"***  Dutch Synthetic Reefing  ***  ( de DSR Methode )  ***","Result (Res) (dm3) = (L)","Lengte (cm)","Breedte (cm)"," W-Hoogte (cm)","Vers.130721"]
[null,"DSR Mineralen Calculator by GlennF",{"$f":"(D2*E2*F2)/1000","v":1180},250,80,59,"Bak (binnemaat)"]
[null,null,{"$f":"(D3*E3*F3)/1000","v":67.2},80,70,12,"Sump (binnenmaat)"]
[null,null,{"$f":"(D4*E4*F4)/1000","v":0},0,70,45,"Refugium"]
[]
[null,"PPM > Grams/Milliliters Convertor v.190304"]
[null,"Dosing Liquid ?",null,"Y"]
[null,"Tank volume (Liters)",null,{"$f":"+Calculator!$C$6","v":100}]
[null,"DSR Products","Start"," ppm","dosing","100% aanmaak","Units","Opm./Check"]
[null,"Salinity/ NaCl: (ppt)",0,33,{"$f":"($D$8/100)*(D10-C10)*100","v":3300},{"$f":"$E10*0.87","v":2871},"gram","1ppt = 100gr/100L",null,null,"Y"]
[null,"PH+ (liquid only)",0,1,{"$f":"($D$8/100)*(D11-C11)*3*11.1/2","v":16.649999999999999},{"$f":"+E11","v":16.649999999999999},"ml"]
[null,"KH+",0,9,{"$f":"IF($D$7=\"Y\",($D$8/100)*(D12-C12)*3*11.1,($D$8/100)*(D12-C12)*3)","v":299.7},{"$f":"+E12","v":299.7},{"$f":"IF($D$7=\"Y\", \"ml\",\"gram\")","v":"ml"},"1KH = 3gr/100L",null,null,"N"]
[null,"Ca+ ",0,440,{"$f":"IF($D$7=\"Y\", ($D$8/100)*(D13-C13)*0.3668*1.429,($D$8/100)*(D13-C13)*0.3668)","v":230.62916799999999},{"$f":"+E13","v":230.62916799999999},{"$f":"IF($D$7=\"Y\", \"ml\",\"gram\")","v":"ml"},"1mg/l = 0,3668gr/100L"]
[null,"Mg+",0,"x",{"$f":"IF($D$7=\"Y\", ($D$8/100)*(D14-C14)*0.836*1.33,($D$8/100)*(D14-C14)*0.836)","v":{"$error":"#VALUE!"}},{"$f":"($E$14/7)*6","v":{"$error":"#VALUE!"}},{"$f":"IF($D$7=\"Y\", \"ml\",\"gram\")","v":"ml"},"1mg/l = 0,836gr/100L"]
[null,"Mg (by MgSO4+)\n",null,"x",{"$f":"IF($D$7=\"Y\", ($D$8/100)*(D15-C15)*0.836*1.33,($D$8/100)*(D15-C15)*1.01389)","v":{"$error":"#VALUE!"}},{"$f":"($E$14/7)*6","v":{"$error":"#VALUE!"}},{"$f":"IF($D$7=\"Y\", \"ml\",\"gram\")","v":"ml"}]
[null,"K+",0,390,{"$f":"IF($D$7=\"Y\",($D$8/100)*(D16-C16)*0.667,($D$8/100)*(D16-C16)*0.190476)","v":260.13},{"$f":"$E16*0.81","v":210.70530000000002},{"$f":"IF($D$7=\"Y\", \"ml\",\"gram\")","v":"ml"},"1mg/l  =0,190476gr/100L"]
[null,"Sr+",0,8,{"$f":"($D$8/100)*(D17-C17)*3","v":24},{"$f":"+E17","v":24},"ml","1mg/l = 3,04ml/100L"]
[null,"B+ ",0,4,{"$f":"($D$8/100)*(D18-C18)*12.68","v":50.72},{"$f":"+E18","v":50.72},"ml","1mg/l = 12,68ml/100L"]
[null,"I2+",0,0.06,{"$f":"($D$8/100)*(D19-C19)*100*0.26","v":1.56},{"$f":"+E19","v":1.56},"ml","0,01mg/l = 0,26ml/100L"]
[null,"Mn+ (ppb)",0,0.4,{"$f":"($D$8/100)*(D20-C20)*10*0.1","v":0.4},null,"ml"]
[null,"PO4+",0,0.02,{"$f":"($D$8/100)*(D21-C21)*100*0.1","v":0.2},{"$f":"+E21","v":0.2},"ml","0,01mg/l = 0,1ml/100L"]
[null,"2xNO3+ (rev.2019)",0,1,{"$f":"($D$8/100)*(D22-C22)*(0.8)","v":0.8},{"$f":"+E22","v":0.8},"ml","1mg/l = 1,44ml/100L"]
[null,"Fe Trace / Fe+",0,0.15,{"$f":"($D$8/100)*(D23-C23)*10*0.4975","v":0.74624999999999997},{"$f":"+E23","v":0.74624999999999997},"ml","0,1mg/l = 0,4975ml/100L"]
[null,"CarbonVS (average daily dose)",null,null,{"$f":"(D8/100)*0.5","v":0.5},{"$f":"+E24","v":0.5},"ml"]
[null,"Amino/C (weekly dose)",null,null,{"$f":"(D8/100)*1","v":1},{"$f":"+E25","v":1},"ml"]
[null,"mobilescreen: tap on yellow fields until keyboard appear"]

{"sheet":"S-calc","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3],[12,0,12,4],[1,4,10,4],[11,0,11,2],[3,1,3,2],[4,1,4,2],[2,1,2,2],[1,1,1,3],[5,0,5,2]]}
["Sulfaat calculator v.210715"]
[null,"auto calculator",null,null,"auto calculator: hiermee wordt berekend wat, je van MgCl2 en MgSO4 nodig heb om de target Mg en S waarden te bereiken "]
[null,"Volume (L)",null,100]
[null,"target Mg",null,1350]
[null,"target S",null,904]
["manual adjustment"]
["stof","grams","Mg Ions","grams"]
["Mg+",555.70000000000005,{"$f":"($B$8/$D$3)*1000*(24.31/203.306)","v":664.46966641417362},{"$f":"(($D$3/1000)*($D$4-($D$9/$D$3)*1000*(24.31/246.482))*(203.306/24.31))","v":555.74858439274578}]
["MgSO4",695,{"$f":"($B$9/$D$3)*1000*(24.31/246.482)","v":685.46384725862333},{"$f":"($D$3/1000)*($D$5)*(246.482/32.06)","v":695.00850904553965}]
["MgTotal",null,{"$f":"SUM(C8:C9)","v":1349.9335136727968}]
["S total",null,{"$f":"($B$9/$D$3)*1000*(32.06/246.482)","v":903.98893225468805}]
["manual adjustment: na invullen van  het aantal liters kan je experimenteren en zien wat het effect is van diverse mix verhoudingen op het Mg en S gehalte."]
["Het bepalen van S toevoegen d.m.v. MgSO4 kan, door  het tekort (bij target) en het aantal liters (watervolume) in te vullen. Daarmee wordt aangeven hoeveel MgSO4 aangevuld dient te worden om S op peil te brengen. Het MgSO4 weegt men af en  legt dit apart. Dit dient geleidelijk gebruikt te worden i.p.v. Mg+ (MgCl2) om je Mg op peil te houden, totdat het aangegeven hoeveelheid MgSO4 verbruikt is. Omdat de DSR calculator Mg+ berekend, dient   het aangeven gewicht met 1,21  vermenigvuldigen te worden bij het toepassen van MgSO4."]

{"sheet":"Fe dosing","index":6,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,6,3,7],[13,0,13,7],[14,0,14,7],[15,0,15,7],[2,4,2,7],[4,5,5,6],[4,7,5,7],[10,0,10,7],[11,0,11,7],[12,0,12,7]]}
[]
["Fe+ daily dosing table,  to be used as PO4 remover"]
["maximum Single dosing",1,{"$f":"+Calculator!$F$22","v":9.9500000000000005E-2},"ml","<<< data taken from fe dosing field in  DSR Calculator"]
[null,null,null,null,null,"name:",{"$f":"+Calculator!F4","v":"New tank"}]
["day1",0.2,{"$f":"$C$3*B5","v":1.9900000000000001E-2},"ml",null,"total netto volume in liters",null,{"$f":"Calculator!C6","v":100}]
["day2",0.4,{"$f":"$C$3*B6","v":3.9800000000000002E-2},"ml"]
["day3",0.6,{"$f":"$C$3*B7","v":5.9700000000000003E-2},"ml"]
["day4",0.8,{"$f":"$C$3*B8","v":7.9600000000000004E-2},"ml"]
["day5",1,{"$f":"$C$3*B9","v":9.9500000000000005E-2},"ml"]
[]
[{"$f":"IF(Calculator!$I$2=\"Nederlands\",\"in  't geval van een extreem hoog fosfaat  kan de maximale dosering van 2x per dag Fe+ worden toegedient\",\"** in case  of extreme high  PO4, the daily dose of Fe+ may be given every 12 hours \")","v":"** in case  of extreme high  PO4, the daily dose of Fe+ may be given every 12 hours "}]
[{"$f":"IF(Calculator!$I$2=\"Nederlands\",\"** DSR Fe+ word als een effectief PO4 verwijderaar gebruikt. Over doseren kan gevaarlijk zijn voor de vissen. Dosering geleidelijk opbouwen\",\"** DSR Fe+ is being used as a very efficient PO4 remover. Overdosing can be dangerous for the fishes. Gradualy build up the dosing\")","v":"** DSR Fe+ is being used as a very efficient PO4 remover. Overdosing can be dangerous for the fishes. Gradualy build up the dosing"}]
[{"$f":"IF(Calculator!$I$2=\"Nederlands\",\"Fe+ (de PO4 verwjderaar) mag worden ingezet bij een  PO4 bereik vanaf > 0,04ppm.\",\"Fe+ (the PO4 remover) can be applied from PO4 range > 0,04ppm\")","v":"Fe+ (the PO4 remover) can be applied from PO4 range > 0,04ppm"}]
[{"$f":"IF(Calculator!$I$2=\"Nederlands\",\"Fe trace mag worden ingezet bij een  PO4 bereik van 0,01ppm-0,08ppm.\",\"Fe Trace can be applied in de PO4 range 0,01ppm-0,08ppm\")","v":"Fe Trace can be applied in de PO4 range 0,01ppm-0,08ppm"}]
[{"$f":"IF(Calculator!$I$2=\"Nederlands\",\"Er is dus een overgangs gebied waarbij je zelf mag kiezen welke ijzer beter voor jou werkt.\",\"There is an overlapping range where you can choose which iron suits your needs best\")","v":"There is an overlapping range where you can choose which iron suits your needs best"}]
[{"$f":"IF(Calculator!$I$2=\"Nederlands\",\"Hoeveel ppm ijzer er gedoseerd word is een eigen keuze. De richtlijn is dat bij hoog PO4 je naar de maximale dosering Fe+ gaat\",\"How much ppm iron is being dosed is up to you. The guideline is, if you have high PO4 you should apply the maximum dosing Fe+\")","v":"How much ppm iron is being dosed is up to you. The guideline is, if you have high PO4 you should apply the maximum dosing Fe+"}]

{"sheet":"CarbonVS3","index":7,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,3],[20,1,20,4],[3,10,4,10],[3,11,4,11]]}
[]
[null,"CarbonVS dosing sheduler  3.0 "]
[null,"Quick or Normal Dosing?",null,null,"Normal",null,"Quick"]
[null,"volume (L)",{"$f":"+Calculator!$C$6","v":100},null,"v.210504",null,"Normal"]
[null,null,"Startdate","step","dosing (ml)",null,"percentage"]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-1\",\"Day 1-3\")","v":"Day 1-3"},"2016-11-20","S1",{"$f":"($C$4/100)*0.5*G6","v":0.5},null,1,null,"D1",1]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-2\",\"Day 4-6\")","v":"Day 4-6"},{"$f":"IF($E$3=\"Quick\", C6+1,C6+3)","v":"2016-11-23"},"S2",0.6,null,{"$f":"G6+20%","v":1.2},null,"D2",{"$f":"J6+3","v":4}]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-3\",\"Day -7-9\")","v":"Day -7-9"},{"$f":"IF($E$3=\"Quick\", C7+1,C7+3)","v":"2016-11-26"},"S3",0.7,null,{"$f":"G7+20%","v":1.4},null,"D3",{"$f":"J7+3","v":7}]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-4\",\"Day 10-12\")","v":"Day 10-12"},"2016-11-29","S4",0.84,null,{"$f":"G8*1.2","v":1.68},null,"D4",10]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-5\",\"Day 13-15\")","v":"Day 13-15"},"2016-12-02","S5",1.008,null,2.016,null,"D5",13]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-6\",\"Day 16-18\")","v":"Day 16-18"},"2016-12-05","S6",1.2096,null,2.4192,null,"D6",16]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-7\",\"Day 19-21\")","v":"Day 19-21"},"2016-12-08","S7",1.4515199999999999,null,2.9030399999999998,null,"D7",19]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-8\",\"Day 22-24\")","v":"Day 22-24"},"2016-12-11","S8",1.7418239999999998,null,3.4836479999999996,null,"D8",22]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-9\",\"Day 25-27\")","v":"Day 25-27"},"2016-12-14","S9",2.0901887999999995,null,4.180377599999999,null,"D9",25]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-10\",\"Day 28-30\")","v":"Day 28-30"},"2016-12-17","S10",2.5082265599999993,null,5.0164531199999987,null,"D10",28]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-11\",\"Day 31-33\")","v":"Day 31-33"},"2016-12-20","S11",3.0098718719999993,null,6.0197437439999986,null,"D11",31]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-12\",\"Day 34-36\")","v":"Day 34-36"},"2016-12-23","S12",3.611846246399999,null,7.2236924927999979,null,"D12",34]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-13\",\"Day 37-39\")","v":"Day 37-39"},"2016-12-26","S13",4.3342154956799988,null,8.6684309913599975,null,"D13",37]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-14\",\"Day 40-42\")","v":"Day 40-42"},"2016-12-29","S14",5.201058594815998,null,10.402117189631996,null,"D14",40]
[null,{"$f":"IF($E$3=\"Quick\", \"Day-15\",\"Day 43=max\")","v":"Day 43=max"},"2017-01-01","S15",6.2412703137791974,null,12.482540627558395,null,"D15",43]
[null," Only use quickdosing after the sandbed was cleaned and powerfilter  applied., otherwise select \"Normal\""]

{"sheet":"CSR v5","index":8,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,2,5,3],[1,1,1,2],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3],[6,5,6,6],[7,10,7,12],[11,5,11,6],[12,10,12,12],[13,3,17,3],[16,8,16,13],[17,8,17,13],[18,0,18,3],[19,0,19,3],[35,1,35,6],[47,11,48,12],[50,11,51,12]]}
[null,null,"Nederlands","English"]
[null,{"$f":"IF($D$2=\"Nederlands\",\"Gekozen Taal\",\"Choosen Language\")","v":"Gekozen Taal"},null,"Nederlands"]
[]
[{"$f":"IF($D$2=\"Nederlands\",\"***  Dutch Synthetic Reefing  *** \",\"***  Dutch Synthetic Reefing ***\")","v":"***  Dutch Synthetic Reefing  *** "},null,"vers.170405(v5) "]
[{"$f":"IF($D$2=\"Nederlands\",\"CRS - Custom Reef Salt calculator\",\"CRS - Custom Reef Salt calculator\")","v":"CRS - Custom Reef Salt calculator"},null,{"$f":"IF($D$2=\"Nederlands\",\"Laatste aanpassing\",\"Last saved date\")","v":"Laatste aanpassing"}]
[{"$f":"IF($D$2=\"Nederlands\",\" Water volume\",\"Water volume\")","v":" Water volume"},{"$f":"+Calculator!$C$6","v":100},"2017-04-05"]
["Parameter / range","\\",{"$f":"IF($D$2=\"Nederlands\",\"Nieuwe aanmaak\",\"New water\")","v":"Nieuwe aanmaak"},{"$f":"IF($D$2=\"Nederlands\",\"eenheid / Grondstof\",\"Units /  Product\")","v":"eenheid / Grondstof"},null,{"$f":"IF($D$2=\"Nederlands\",\"Osmose water meten voor aanmaak\",\"Measure RO water before applying\")","v":"Osmose water meten voor aanmaak"},null,"gemeten ",null,"correctie ratio"]
[{"$f":"IF($D$2=\"Nederlands\",\"Osmose water\",\"RO water\")","v":"Osmose water"},null,{"$f":"($B$6)*(1-0.0166)","v":98.34},"Liters",null,"TDS RO =",0,null,null,null,"foutmarge KH+ door werkelijke metingen"]
[{"$f":"IF($D$2=\"Nederlands\",\"Saliniteit: (33-34ppt)  (+1,5)*\",\"Salinity: (33-34ppt)\")","v":"Saliniteit: (33-34ppt)  (+1,5)*"},33,{"$f":"($B$6/100)*($B9+1.5)*100*(27.2656/35)","v":2687.6091428571426},{"$f":"IF($D$2=\"Nederlands\",\"g / NaCl+\",\"g / NaCl+\")","v":"g / NaCl+"},null,"KH RO =",0,null,null,null,"kh 4,1","KH 9,6","kh 10,2"]
[{"$f":"IF($D$2=\"Nederlands\",\"KH: (7-9dKH) (x0,97)*\",\"KH: ( 7-9dKH)*\")","v":"KH: (7-9dKH) (x0,97)*"},5,{"$f":"($B$6/100)*($B10-0)*3*0.97","v":14.549999999999999},{"$f":"IF($D$2=\"Nederlands\",\"g / KH+\",\"g / KH+\")","v":"g / KH+"},null,null,null,null,null,0.8]
[{"$f":"IF($D$2=\"Nederlands\",\"Calcium: ( 420-460ppm) (x0.96)*\",\"Calcium: (420-460ppm)* \")","v":"Calcium: ( 420-460ppm) (x0.96)*"},400,{"$f":"($B$6/100)*($B11-0)*0.3668*0.96","v":140.85120000000001},{"$f":"IF($D$2=\"Nederlands\",\"g / Ca+\",\"g / Ca+\")","v":"g / Ca+"},null,null,null,null,null,0.96]
[{"$f":"IF($D$2=\"Nederlands\",\"Magnesium: (1250-1400ppm)\",\"Magnesium: (1250-1400ppm)\")","v":"Magnesium: (1250-1400ppm)"},1350,{"$f":"($B$6/1000)*($B12-($C$13/$B$6)*1000*(24.31/246.482))*(203.306/24.31)","v":555.74858439274578},{"$f":"IF($D$2=\"Nederlands\",\"g / Mg+\",\"g / Mg+\")","v":"g / Mg+"},null,{"$f":"IF($D$2=\"Nederlands\",\"Gewicht\",\"(Weight\")","v":"Gewicht"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Mg+Sulfaat:\",\"Mg+Sulphate:\")","v":"Mg+Sulfaat:"},904,{"$f":"($B$6/1000)*($B13-0)*(246.482/32.06)","v":695.00850904553965},{"$f":"IF($D$2=\"Nederlands\",\"g / MgSO4\",\"g / MgSO4\")","v":"g / MgSO4"},null,{"$f":"SUM(C9:C13)","v":4093.7674362954281},"poeders",null,null,null,"foutmarge Ca+ door werkelijke metingen"]
[{"$f":"IF($D$2=\"Nederlands\",\"Kalium: (380-420ppm)\",\"Potassium: (380-420ppm)\")","v":"Kalium: (380-420ppm)"},390,{"$f":"(B14/390)*($B$6/250)*1000","v":400},{"$f":"IF($D$2=\"Nederlands\",\"ml / CRS  oplossing. Inclusief: Sr, B, I, Mn\",\"ml / CRS solution. Includes: Sr, B, I, Mn\")","v":"ml / CRS  oplossing. Inclusief: Sr, B, I, Mn"},null,{"$f":"C14*1.115","v":446},"vloeistof",null,null,null,"Ca 225","Ca 425","Ca 505"]
[{"$f":"IF($D$2=\"Nederlands\",\"Strontium: (3-10ppm)\",\"Strontium: (3-10ppm)\")","v":"Strontium: (3-10ppm)"},{"$f":"8/390*$B$14","v":8},"-",{"$f":"IF($D$2=\"Nederlands\",\"g / Ca+\",\"g / Ca+\")","v":"g / Ca+"},null,{"$f":"SUM(F13:F14)","v":4539.7674362954276}]
[{"$f":"IF($D$2=\"Nederlands\",\"Boor: ( 3,5-4,4ppm)\",\"Boron: (3,5-4,4ppm)\")","v":"Boor: ( 3,5-4,4ppm)"},{"$f":"4/390*$B$14","v":4},"-",{"$f":"IF($D$2=\"Nederlands\",\"g / Ca+\",\"g / Ca+\")","v":"g / Ca+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Jodide: (0,06ppm)\",\"Iodide: (0,06ppm)\")","v":"Jodide: (0,06ppm)"},{"$f":"0.06/390*$B$14","v":6.0000000000000005E-2},"-",{"$f":"IF($D$2=\"Nederlands\",\"g / Ca+\",\"g / Ca+\")","v":"g / Ca+"},null,null,null,null,"alle zouten (inclusief KH en MgSO4) in 1 keer erin gegooid, zonder NaCl: lost goed op!"]
[{"$f":"IF($D$2=\"Nederlands\",\"Mangaan: (0,4ppb)\",\"Manganese: (0,4ppb)\")","v":"Mangaan: (0,4ppb)"},{"$f":"0.4/390*$B$14","v":0.4},"-",{"$f":"IF($D$2=\"Nederlands\",\"g / Ca+\",\"g / Ca+\")","v":"g / Ca+"},null,null,null,null,"KH & Ca meting gedaan met en zonder NaCl : geen invloed op waarde bepaling"]
[{"$f":"IF($D$2=\"Nederlands\",\"KH+ nooit gelijktijdig met andere zouten (Ca,Mg,K) toevoegen ter voorkoming van neerslag . Toevoegen als alle zouten volledig zijn opgelost.\",\"KH+ may only be added after all salts are fully dissolved (Ca,Mg,K). This is to prevent precipitation of chalk\")","v":"KH+ nooit gelijktijdig met andere zouten (Ca,Mg,K) toevoegen ter voorkoming van neerslag . Toevoegen als alle zouten volledig zijn opgelost."}]
[{"$f":"IF($D$2=\"Nederlands\",\"( 1ml CRS Kalium+ vloeistof weegt 1.115gram )\",\"( 1ml CRS Kalium+ liquid Weight 1.115gram )\")","v":"( 1ml CRS Kalium+ vloeistof weegt 1.115gram )"}]
[]
["Calcium recalculation","recalc target","dosing","result (ppm)",null,"recalc","dosing V4 factor 0,96",null,null,"Ca"]
["v1 Ca (org)",440,32.28,480,null,{"$f":"440/480*C23","v":29.59},null,null,null,"real"]
["v2 Ca (-55abs)",220,14.1,200,null,{"$f":"B24/D24*C24","v":15.510000000000002},null,null,null,"calc"]
["v2 Ca (-55abs)",440,28.24,400,null,{"$f":"B25/D25*C25","v":31.064},null,null,null,"verschil"]
["v3 Ca (factor 0,91)",505,33.71,480,null,{"$f":"B26/D26*C26","v":35.465729166666662}]
["v4 Ca (factor 0,96)",440,30.99,440,null,{"$f":"B27/D27*C27","v":30.99},30.99,null,null,"Ca ppm"]
[]
["KH recalculation","recalc target","dosing","result (dkh)",null,"recalc","dosing V4 factor 0,8",null,null,"real"]
["v1 KH (org)",9,5.4,10.199999999999999,null,{"$f":"B30/D30*C30","v":4.764705882352942},null,null,null,"calc"]
["v2 KH ( -1,2 abs)",4.5,2.35,4.0999999999999996,null,{"$f":"B31/D31*C31","v":2.5792682926829271},null,{"$f":"2.35+0.24","v":2.59},null,"verschil"]
["v2 KH ( -1,2 abs)",9,4.68,9.6,null,{"$f":"B32/D32*C32","v":4.3874999999999993},null,{"$f":"4.68-0.36","v":4.3199999999999994},null,"dhk units"]
["v3 KH (factor 0,8)",10.199999999999999,4.9000000000000004,8.1999999999999993,null,{"$f":"B33/D33*C33","v":6.0951219512195127},null,{"$f":"4.9+0.48","v":5.3800000000000008}]
["v5 KH (factor 0,97)",9,4.32,7.6,null,{"$f":"B34/D34*C34","v":5.1157894736842113},5.24,{"$f":"4.32+0.9","v":5.2200000000000006}]
[]
["CaCl2 bevat KH!","65ppm Ca extra, levert een stijging van KH op"]
["kh correctie= ","Ca (ppm)","Kh deviatie"]
["originele formule",480,1.2]
["v4 (Ca=440)",440,0.26]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,10300,33.5]
[null,null,null,null,null,null,null,null,null,10700,{"$f":"J46/J45*K45","v":34.800970873786405}]
[]
[null,null,null,null,null,null,null,null,null,421,{"$f":"J48/J49","v":0.95681818181818179},"ati calcium = raw"]
[null,null,null,null,null,null,null,null,null,440,{"$f":"J49*0.96","v":422.4}]
[]
[null,null,null,null,null,null,null,null,null,9,{"$f":"J51*0.97","v":8.73},"KH"]
[null,null,null,null,null,null,null,null,null,8.8699999999999992,{"$f":"J52/J51","v":0.98555555555555552}]

{"sheet":"Saltalc","index":9,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,0,7,1],[21,0,21,3],[22,0,22,3],[23,0,23,3],[1,1,1,2],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3],[5,2,5,3]]}
[null,null,"Nederlands","English"]
[null,{"$f":"IF($D$2=\"Nederlands\",\"Gekozen Taal\",\"Choosen Language\")","v":"Choosen Language"},null,"English"]
[]
[{"$f":"IF($D$2=\"Nederlands\",\"***  Dutch Synthetic Reefing  *** \",\"***  Dutch Synthetic Reefing ***\")","v":"***  Dutch Synthetic Reefing ***"},null,"vers.180601 - compact"]
[{"$f":"IF($D$2=\"Nederlands\",\"Zout water calculator\",\"Salt water calculator\")","v":"Salt water calculator"},null,{"$f":"IF($D$2=\"Nederlands\",\"Laatste aanpassing\",\"Last modification\")","v":"Last modification"}]
[{"$f":"IF($D$2=\"Nederlands\",\" Water volume\",\"Water volume\")","v":"Water volume"},{"$f":"+Calculator!$C$6","v":100},{"$f":"TODAY()","v":"2021-07-18"}]
["Parameter / range",{"$f":"IF($D$2=\"Nederlands\",\"Target waarde\",\"Target  value\")","v":"Target  value"},{"$f":"IF($D$2=\"Nederlands\",\"Nieuwe aanmaak\",\"New water\")","v":"New water"},{"$f":"IF($D$2=\"Nederlands\",\"eenheid / Grondstof\",\"Units /  Product\")","v":"Units /  Product"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Puur osmose water (0ppt) - geen silicaat!\",\"Pure RO water (0ppt) - No silicate!\")","v":"Pure RO water (0ppt) - No silicate!"},null,{"$f":"($B$6)*(1-0.0166)","v":98.34},"Liters"]
[{"$f":"IF($D$2=\"Nederlands\",\"Saliniteit: (33-34ppt) \",\"Salinity: (33-34ppt)\")","v":"Salinity: (33-34ppt)"},33,{"$f":"($B$6/100)*($B9-0)*100*(27.2656/35)","v":2570.7565714285715},{"$f":"IF($D$2=\"Nederlands\",\"g / NaCl+\",\"g / NaCl+\")","v":"g / NaCl+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"KH: (7-9dKH)\",\"KH: ( 7-9dKH)\")","v":"KH: ( 7-9dKH)"},9,{"$f":"($B$6/100)*($B10-0)*3","v":27},{"$f":"IF($D$2=\"Nederlands\",\"g / KH+\",\"g / KH+\")","v":"g / KH+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Calcium: ( 420-460ppm)\",\"Calcium: (420-460ppm) \")","v":"Calcium: (420-460ppm) "},440,{"$f":"($B$6/100)*($B11-0)*0.3668","v":161.392},{"$f":"IF($D$2=\"Nederlands\",\"g / Ca+\",\"g / Ca+\")","v":"g / Ca+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Magnesium:(1250-1400ppm)\",\"Magnesium: (1250-1400ppm)\")","v":"Magnesium: (1250-1400ppm)"},1350,{"$f":"($B$6/1000)*($B12-($C$13/$B$6)*1000*(24.31/246.482))*(203.306/24.31)","v":555.74858439274578},{"$f":"IF($D$2=\"Nederlands\",\"g / Mg+\",\"g / Mg+\")","v":"g / Mg+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Mg+Sulfaat:\",\"Mg+Sulphate:\")","v":"Mg+Sulphate:"},904,{"$f":"($B$6/1000)*($B13-0)*(246.482/32.06)","v":695.00850904553965},{"$f":"IF($D$2=\"Nederlands\",\"g / MgSO4\",\"g / MgSO4\")","v":"g / MgSO4"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Kalium - vloeibaar: (380-420ppm)\",\"Potassium- liquid: (380-420ppm)\")","v":"Potassium- liquid: (380-420ppm)"},390,{"$f":"($B$6/100)*($B14-0)*0.667*1","v":260.13},{"$f":"IF($D$2=\"Nederlands\",\"ml / K+\",\"ml / K+\")","v":"ml / K+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Strontium: (3-10ppm)\",\"Strontium: (3-10ppm)\")","v":"Strontium: (3-10ppm)"},8,{"$f":"($B$6/100)*($B15-0)*3.04","v":24.32},"ml / Sr+"]
[{"$f":"IF($D$2=\"Nederlands\",\"Boor: ( 3,5-4,4ppm)\",\"Boron: (3,5-4,4ppm)\")","v":"Boron: (3,5-4,4ppm)"},4,{"$f":"($B$6/100)*($B16-0)*12.68","v":50.72},{"$f":"IF($D$2=\"Nederlands\",\"ml / B+\",\"ml / B+\")","v":"ml / B+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Jodide: (0,06ppm)\",\"Iodide: (0,06ppm)\")","v":"Iodide: (0,06ppm)"},0.06,{"$f":"($B$6/100)*($B17-0)*100*0.26","v":1.56},{"$f":"IF($D$2=\"Nederlands\",\"ml / I+ \",\"ml / I+\")","v":"ml / I+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Mangaan: (0,4ppb)\",\"Manganese: (0,4ppb)\")","v":"Manganese: (0,4ppb)"},0.4,{"$f":"($B$6/100)*($B18-0)*10*0.1","v":0.4},{"$f":"IF($D$2=\"Nederlands\",\"ml / Mn+\",\"ml / Mn+\")","v":"ml / Mn+"}]
[{"$f":"IF($D$2=\"Nederlands\",\"Fosfaat: ( 0,04-0,08ppm)\",\"Phosphate: (0,04-0,08ppm)\")","v":"Phosphate: (0,04-0,08ppm)"},0.04,{"$f":"($B$6/100)*($B19-0)*100*0.1*0","v":0},"ml / PO4+"]
[{"$f":"IF($D$2=\"Nederlands\",\"Nitraat: (1-3ppm)\",\"Nitrate: (1-3ppm)\")","v":"Nitrate: (1-3ppm)"},2.5,{"$f":"($B$6/100)*($B20-0)*0.8*0","v":0},"ml / NO3+"]
[{"$f":"IF($D$2=\"Nederlands\",\"Ijzer: (0,02-0,15ppm)\",\"Iron: (0,02-0,15ppm)\")","v":"Iron: (0,02-0,15ppm)"},0.02,{"$f":"($B$6/100)*(VALUE($B21)-0)*10*0.4975*0","v":0},"ml / Fe+"]
[{"$f":"IF($D$2=\"Nederlands\",\"KH+ nooit gelijktijdig met andere zouten (Ca,Mg,K,Sr) toevoegen ter voorkoming van neerslag . Toevoegen als alle zouten volledig zijn opgelost.\",\"KH+ may only be added after all salts are fully dissolved (Ca,Mg,K,Sr). This is to prevent precipitation of chalk.\")","v":"KH+ may only be added after all salts are fully dissolved (Ca,Mg,K,Sr). This is to prevent precipitation of chalk."}]
[{"$f":"IF($D$2=\"Nederlands\",\"Alleen de macro elementen t/m boor zijn vereist voor correcties. Spore elementen  kunnen in het aquarium zelf worden aangevuld.\",\"only the macro elements down to boron are neccessary when mixing a batch of water for corrections. Trace elements can be added into the tank.\")","v":"only the macro elements down to boron are neccessary when mixing a batch of water for corrections. Trace elements can be added into the tank."}]
[{"$f":"IF($D$2=\"Nederlands\",\"Alleen puur osmose water gebruiken met  nihil slicaat. Gebruik een TDS meter op de in- en uitgang van de DI filter, of meet de TDS waarde voor het gebruik.\",\"Only use pure RO water with  zero silicate. Use a TDS meter to monitor DI filter in- and output or measure TDS of the RO water before use.\")","v":"Only use pure RO water with  zero silicate. Use a TDS meter to monitor DI filter in- and output or measure TDS of the RO water before use."}]

{"sheet":"SG2","index":10,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[]
["SG Converter (for DSR solutions)",null," v.210507",null,null,null,null,null,"ORIGINEEL"]
["Choose Container","500ml",{"$f":"IF($B$3=\"use cup\",B4,IF($B$3=\"500ml\",J13,IF($B$3=\"1000ml\",J14,IF($B$3=\"Can 5L\",J15,IF($B$3=\"Can 10L\",J16,IF($B$3=\"x\",\"0\",IF($B$3=\"X\",\"0\")))))))","v":28},null,null,"(gram)","(ml)"]
["measuring cup (optional) ",0,"grams"]
["Choose conversion ","(ml's)",{"$f":"IF($B$5=\"(ml's)\",\"(grams) incl. container\",IF($B$5=\"(grams) incl. container\",\"(ml's)\"))","v":"(grams) incl. container"},null,"sg"]
["EZCarbon",1,{"$f":"IF($B$5=\"(ml's)\",(B6*E6)+$C$3,IF($B$5=\"(grams) incl. container\",(B6-$C$3)/E6))","v":29.0227},null,1.0226999999999999,1,{"$f":"F6/1.0227","v":0.97780385254717905},null,"(ml's)"]
["EZBuffer",1,29.091000000000001,null,1.091,10860,{"$f":"F7/1.091","v":9954.1704857928507},null,"(grams) incl. container"]
["EZCalcium",1,29.364999999999998,null,1.365,7050,{"$f":"F8/1.365","v":5164.8351648351645}]
["EZTrace",1,29.193999999999999,null,1.194,1,{"$f":"F9/1.194","v":0.83752093802345062},null,null,"normal","un"]
["EZ2Go",1,29.08,null,1.08,1,{"$f":"F10/1.194","v":0.83752093802345062},null,null,"normal","un"]
["PH+",1,29.091000000000001,null,1.091,1,{"$f":"F11/1.091","v":0.91659028414298815}]
["KH+",1,29.056999999999999,null,1.0569999999999999,1,{"$f":"F12/1.057","v":0.94607379375591305},null,"use cup",0]
["Ca+",1,29.381,null,1.381,1,{"$f":"F13/1.381","v":0.724112961622013},null,"500ml",28]
["CaSr+",1,29.395,null,1.395,1,{"$f":"F14/1.395","v":0.71684587813620071},null,"1000ml",50]
["Mg+",1,29.257000000000001,null,1.2569999999999999,1,{"$f":"F15/1.257","v":0.79554494828957845},null,"Can 5L",215,280]
["K+",1,29.156199999999998,null,1.1561999999999999,1,{"$f":"F16/1.16","v":0.86206896551724144},null,"Can 10L",380,430]
["Sr+",1,29.052499999999998,null,1.0525,1,{"$f":"F17/1.0525","v":0.95011876484560576},null,"JC cap",19]
["B+",1,29.017499999999998,null,1.0175000000000001,1,{"$f":"F18/1.0175","v":0.98280098280098271},null,"KV cap",6.4]
["I2+",1,29.004999999999999,null,1.0049999999999999,1,{"$f":"F19/1.001","v":0.99900099900099915}]
["Mn+",1,29.0031,null,1.0031000000000001,1,{"$f":"F20/1.001","v":0.99900099900099915}]
["PO4+",1,29.013999999999999,null,1.014,1,{"$f":"F21/1.001","v":0.99900099900099915}]
["2xNO3+ rev 2019",1,29.135999999999999,null,1.1359999999999999,1,{"$f":"F22/1.136","v":0.88028169014084512}]
["CarbonVS",1,29.035699999999999,null,1.0357000000000001,1,{"$f":"F23/1.0357","v":0.96553055904219365}]
["Fe+",1,29.146999999999998,null,1.147,1,{"$f":"F24/1.147","v":0.87183958151700081}]
["Fe-Trace",1,29.183,null,1.1830000000000001,1,{"$f":"F25/1.183","v":0.84530853761622993}]
["Fluor+",1,{"$f":"IF($B$5=\"(ml's)\",B26*E26,IF($B$5=\"(grams)\",B26/E26))","v":1.0249999999999999},null,1.0249999999999999,1,{"$f":"F26/1.025","v":0.97560975609756106}]

{"sheet":"EZCalc2","index":11,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,0,21,6],[22,0,22,6],[16,0,16,6],[17,0,17,6],[18,0,18,6],[19,0,19,6],[20,0,20,6],[4,10,5,10],[7,8,8,8],[12,0,12,3],[0,0,0,6],[2,0,2,1],[2,2,2,3],[2,4,2,5],[4,3,4,4],[4,6,5,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[4,7,5,7],[4,8,5,8]]}
["original"]
["Nederlands","English","Deutsch","Français","Español","Português","Slovenščina"]
[{"$f":"IF($E$3=\"Nederlands\",\"EZ-DSR Calculator\",IF($E$3=\"English\",\"EZ-DSR Calculator\",IF($E$3=\"Deutsch\",\"EZ-DSR Calculator\",IF($E$3=\"Français\",\"EZ-DSR Calculator\",IF($E$3=\"Español\",\"EZ-DSR Calculator\",IF($E$3=\"Português\",\"Calculadora EZ-DSR\",IF($E$3=\"Slovenščina\",\"EZ-DSR Kalkulator\")))))))","v":"EZ-DSR Calculator"},null,"v.200406",null,"English"]
[{"$f":"IF($E$3=\"Nederlands\",\"Calibration ratio\",IF($E$3=\"English\",\"Calibration ratio\",IF($E$3=\"Deutsch\",\"Calibration ratio\",IF($E$3=\"Français\",\"Calibration ratio\",IF($E$3=\"Español\",\"Calibration ratio\",IF($E$3=\"Português\",\"Rácio de Calibração\",IF($E$3=\"Slovenščina\",\"Kalibracijsko razmerje\")))))))","v":"Calibration ratio"},null,null,1,"(ml/sec)","(ml/ml)"]
[{"$f":"IF($E$3=\"Nederlands\",\"Volume (L)\",IF($E$3=\"English\",\"Volume (L)\",IF($E$3=\"Deutsch\",\"Volumen (L)\",IF($E$3=\"Français\",\"Volume (L)\",IF($E$3=\"Español\",\"Volumen (L)\",IF($E$3=\"Português\",\"Volume (L)\",IF($E$3=\"Slovenščina\",\"Volumen (L)\")))))))","v":"Volume (L)"},100,null,{"$f":"IF($E$3=\"Nederlands\",\"Aantal dagen tussen metingen\",IF($E$3=\"English\",\"Days between measurements\",IF($E$3=\"Deutsch\",\"Tage zwischen den Messungen\",IF($E$3=\"Français\",\"Jours entre les mesures\",IF($E$3=\"Español\",\"Días entre mediciones\",IF($E$3=\"Português\",\"Dias entre Medições\",IF($E$3=\"Slovenščina\",\"Dni med merjanjem\")))))))","v":"Days between measurements"},null,1,{"$f":"IF($E$3=\"Nederlands\",\"pump setting\",IF($E$3=\"English\",\"pump setting\",IF($E$3=\"Deutsch\",\"pump setting\",IF($E$3=\"Français\",\"pump setting\",IF($E$3=\"Español\",\"pump setting\",IF($E$3=\"Português\",\"Definições Bomba Dosagem\"))))))","v":"pump setting"},{"$f":"IF($E$3=\"Nederlands\",\"Cor. Gewicht (gr)\",IF($E$3=\"English\",\"Cor. Weight (gr)\",IF($E$3=\"Deutsch\",\"Kor. Gewicht (gr)\",IF($E$3=\"Français\",\"Cor. Poids (gr)\",IF($E$3=\"Español\",\"Cor. Peso (gr)\",IF($E$3=\"Português\",\"Peso de Correcção (gr)\",IF($E$3=\"Slovenščina\",\"Popra-vek teža (gr)\")))))))","v":"Cor. Weight (gr)"},"Ca/Kh ratio (native)",null,"SG"]
[{"$f":"IF($E$3=\"Nederlands\",\"Produkt\",IF($E$3=\"English\",\"Product\",IF($E$3=\"Deutsch\",\"Product\",IF($E$3=\"Français\",\"Product\",IF($E$3=\"Español\",\"Product\",IF($E$3=\"Português\",\"Produto\",IF($E$3=\"Slovenščina\",\"Izdelek\")))))))","v":"Product"},{"$f":"IF($E$3=\"Nederlands\",\"Waarde\",IF($E$3=\"English\",\"Value\",IF($E$3=\"Deutsch\",\"Wert\",IF($E$3=\"Français\",\"Valeur\",IF($E$3=\"Español\",\"Valor\",IF($E$3=\"Português\",\"Valor\",IF($E$3=\"Slovenščina\",\"Vred-nost\")))))))","v":"Value"},{"$f":"IF($E$3=\"Nederlands\",\"Doel\",IF($E$3=\"English\",\"Setpoint\",IF($E$3=\"Deutsch\",\"SollWert\",IF($E$3=\"Français\",\"But\",IF($E$3=\"Español\",\"punto fijo\",IF($E$3=\"Português\",\"Objec-tivo\",IF($E$3=\"Slovenščina\",\"Končna vrednost\")))))))","v":"Setpoint"}," dkh / ppm",{"$f":"IF($E$3=\"Nederlands\",\"Correctie / start (ml)\",IF($E$3=\"English\",\"Correction (ml)\",IF($E$3=\"Deutsch\",\"Korrektur (ml)\",IF($E$3=\"Français\",\"Correction (ml)\",IF($E$3=\"Español\",\"Corrección (ml)\",IF($E$3=\"Português\",\"Correcção (ml)\",IF($E$3=\"Slovenščina\",\"Popravek (ml)\")))))))","v":"Correction (ml)"},{"$f":"IF($E$3=\"Nederlands\",\"Dagelijks (ml)\",IF($E$3=\"English\",\"Daily (ml)\",IF($E$3=\"Deutsch\",\"Täglich (ml)\",IF($E$3=\"Français\",\"Quotidien (ml)\",IF($E$3=\"Español\",\"Diario (ml)\",IF($E$3=\"Português\",\"Consumo Diário (ml)\",IF($E$3=\"Slovenščina\",\"Dnevno (ml)\")))))))","v":"Daily (ml)"},null,{"$f":"IF($E$3=\"Nederlands\",\"Liters\",IF($E$3=\"English\",\"Liters\",IF($E$3=\"Deutsch\",\"Liter\",IF($E$3=\"Français\",\"litres\",IF($E$3=\"Español\",\"Litros\")))))","v":"Liters"}]
["EZ-Buffer","x",9,{"$f":"IF($B$7=\"x\",0.24,C7-B7)","v":0.24},{"$f":"($B$5/100)*$D$7*16.7","v":4.008},{"$f":"+$E$7/$F$5","v":4.008},{"$f":"F7/$D$4","v":4.008},{"$f":"E7*K7","v":4.3727279999999995},{"$f":"D8/D7","v":5.8},null,1.091]
["EZ-Calcium","x",440,{"$f":"IF($B$8=\"x\",(5.8*D7),C8-B8)","v":1.3919999999999999},{"$f":"($B$5/100)*$D$8*0.578","v":0.80457599999999985},{"$f":"+$E$8/$F$5","v":0.80457599999999985},{"$f":"F8/$D$4","v":0.80457599999999985},1.0982462399999997,"Buf/Cal ratio",null,1.365]
["EZ-Trace","max.",{"$f":"6*(B5/100)","v":6},"-",{"$f":"E8/2","v":0.40228799999999992},{"$f":"F8/2","v":0.40228799999999992},0.40228799999999992,0.48033187199999988,null,null,1.194]
["PO4+",0,null,7.0000000000000001E-3,{"$f":"($B$5/100)*(D10-B10)*100*0.1","v":7.0000000000000007E-2},{"$f":"+E10","v":7.0000000000000007E-2},7.0000000000000007E-2,0]
["NO3+ ",0,null,0.1,{"$f":"($B$5/100)*(D11-B11)*1.44","v":0.14399999999999999},{"$f":"+E11","v":0.14399999999999999},0.14399999999999999,0]
["EZ-Carbon ","max.",{"$f":"($B$5/100)*$E$39","v":12.383472844799998},"D3",{"$f":"IF(D12=\"D1\",($B$5/100)*E25,IF(D12=\"D2\",($B$5/100)*E26,IF(D12=\"D3\",($B$5/100)*E27,IF(D12=\"D4\",($B$5/100)*E28,IF(D12=\"D5\",($B$5/100)*E29,IF(D12=\"D6\",($B$5/100)*E30,IF(D12=\"D7\",($B$5/100)*E31,IF(D12=\"D8\",($B$5/100)*E32,IF(D12=\"D9\",($B$5/100)*E33,IF(D12=\"D10\",($B$5/100)*E34,IF(D12=\"D11\",($B$5/100)*E35,IF(D12=\"D12\",($B$5/100)*E36,IF(D12=\"D13\",($B$5/100)*E37,IF(D12=\"D14\",($B$5/100)*E38,IF(D12=\"D15\",($B$5/100)*E39)))))))))))))))","v":1.44},{"$f":"+E12","v":1.44},1.44,1.4726879999999998,{"$f":"E7/E8","v":4.9815057868989392},null,1.0226999999999999]
["Amino/C (weekly dose)",null,null,null,{"$f":"(B5/100)*1","v":1},{"$f":"+E13","v":1},"ml"]
[{"$f":"IF($E$3=\"Nederlands\",\"indien nodig, start dosering berekenen door bij waarde * in te vullen. Correcties en (dagelijks)verbruik berekenen door de gemeten waarde en het aantal dagen vanaf de laatste meting in te vullen. \",IF($E$3=\"English\",\"When required, calculate startdosing by typing x  at Value. Corrections and (daily) consumption can be calculated by submitting the measured value and the day between measurements.\",IF($E$3=\"Deutsch\",\"Berechnen Sie bei Bedarf die Startdosierung, indem Sie x bei Wert eingeben. Korrekturen und (Tages-) Verbrauch können berechnet werden, indem der Messwert und der Tag zwischen den Messungen übermittelt werden.\",IF($E$3=\"Français\",\"Au besoin, calculez le début de la dose en tapant x comme valeur. Les corrections et la consommation (journalière) peuvent être calculées en soumettant la valeur mesurée et le jour entre les mesures.\",IF($E$3=\"Español\",\"Cuando sea necesario, calcule la dosificación inicial escribiendo x en Value. Las correcciones y el consumo (diario) pueden calcularse enviando el valor medido y el día entre mediciones.\",IF($E$3=\"Português\",\"Quando necessário, calcule a dose inicial digitando x em Valor. Valores de correcção e consumo diário, podem ser calculados usando os valores medidos(resultado do teste de água) e os dias entre medições.\",IF($E$3=\"Slovenščina\",\"Po potrebi izračunajte začetno odmerjanje tako, da vtipkate x pri vrednosti. Popravke in (dnevno) porabo lahko izračunate tako, da dodate izmerjeno vrednost in dan med meritvami.\")))))))","v":"When required, calculate startdosing by typing x  at Value. Corrections and (daily) consumption can be calculated by submitting the measured value and the day between measurements."}]
[{"$f":"IF($E$3=\"Nederlands\",\"EZ Buffer/EZCalcium ratio = 5:1 (ml). Deze verhouding kan aangepast worden aan het werkelijk verbruik.\",IF($E$3=\"English\",\"EZ Buffer / EZCalcium ratio = 5:1 (ml). This ratio can be adjusted to the actual consumption.\",IF($E$3=\"Deutsch\",\"EZ-Buffer / EZCalcium Verhältnis = 5:1 (ml). Dieses Verhältnis kann an den tatsächlichen Verbrauch angepasst werden.\",IF($E$3=\"Français\",\"Rapport tampon EZ / EZCalcium = 5:1 (ml). Ce ratio peut être ajusté à la consommation réelle.\",IF($E$3=\"Español\",\"EZ Buffer / EZCalcium ratio = 5:1 (ml). Esta relación se puede ajustar al consumo real.\",IF($E$3=\"Português\",\"EZ Buffer / EZ Calcium ratio = 5:1(ml). Este rácio pode ser ajustado tendo em conta o atual consumo. \",IF($E$3=\"Slovenščina\",\"Razmerje EZ Buffer / EZ Calcium = 5: 1 (ml). To razmerje je mogoče prilagoditi dejanski porabi.\")))))))","v":"EZ Buffer / EZCalcium ratio = 5:1 (ml). This ratio can be adjusted to the actual consumption."}]
[{"$f":"IF($E$3=\"Nederlands\",\"EZ-Trace = 50% van EZ-Calcium. (of werkelijk verbruik) \",IF($E$3=\"English\",\"EZ-Trace = 50% of EZ-Calcium. (or actual consumption)\",IF($E$3=\"Deutsch\",\"EZ-Trace = 50% oder EZ-Calcium. (oder tatsächlicher Verbrauch)\",IF($E$3=\"Français\",\"EZ-Trace = 50% ou EZ-Calcium. (ou consommation réelle)\",IF($E$3=\"Español\",\"EZ-Trace = 50% o EZ-Calcium. (o consumo real)\",IF($E$3=\"Português\",\"EZ-Trace = 50% ou EZ-Cálcio. (ou consumo real)\",IF($E$3=\"Slovenščina\",\"EZ-sled = 50% ali EZ-kalcij. (ali dejanska poraba)\")))))))","v":"EZ-Trace = 50% of EZ-Calcium. (or actual consumption)"}]
[{"$f":"IF($E$3=\"Nederlands\",\"(1) Verspreid de geadviseerde correcties over meerdere dagen. (2) Vermeerdert de huidige dosering met de berekende dagelijks dosering.\",IF($E$3=\"English\",\"(1) Spread the recommended corrections over several days. (2) Increase the current dose by the calculated daily dose.\",IF($E$3=\"Deutsch\",\"(1) Verteilen Sie die empfohlenen Korrekturen auf mehrere Tage. (2) Erhöhen Sie die aktuelle Dosis um die berechnete Tagesdosis.\",IF($E$3=\"Français\",\"(1) Répartissez les corrections recommandées sur plusieurs jours. (2) Augmentez la dose actuelle de la dose quotidienne calculée.\",IF($E$3=\"Español\",\"(1) Extienda las correcciones recomendadas durante varios días. (2) Aumente la dosis actual en la dosis diaria calculada.\",IF($E$3=\"Português\",\"(1) Espalhe as correções recomendadas por vários dias. (2) Aumente a dose atual pela dose diária calculada.\",IF($E$3=\"Slovenščina\",\"(1) Priporočljive popravke razmažite po več dneh. (2) Povečajte trenutni odmerek za izračunani dnevni odmerek.\")))))))","v":"(1) Spread the recommended corrections over several days. (2) Increase the current dose by the calculated daily dose."}]
[{"$f":"IF($E$3=\"Nederlands\",\"Correcties brengen de waarden op peil en kunnen het eenvoudigst met FullDSR producten worden uitgevoerd.\",IF($E$3=\"English\",\"Corrections bring the values up to date and are easiest to do with FullDSR products.\",IF($E$3=\"Deutsch\",\"Korrekturen bringen die Werte auf den neuesten Stand und sind mit FullDSR-Produkten am einfachsten durchzuführen.\",IF($E$3=\"Français\",\"Les corrections apportent les valeurs à jour et sont plus faciles à faire avec les produits FullDSR.\",IF($E$3=\"Español\",\"Las correcciones actualizan los valores y son más fáciles de hacer con los productos FullDSR.\",IF($E$3=\"Português\",\"As correções atualizam os valores e são mais fáceis de fazer com os produtos FullDSR.\",IF($E$3=\"Slovenščina\",\"Popravki posodabljajo vrednosti in jih je najlažje narediti pri izdelkih FullDSR.\")))))))","v":"Corrections bring the values up to date and are easiest to do with FullDSR products."}]
[{"$f":"IF($E$3=\"Nederlands\",\"EZ-Carbon dosering opvoeren (D1-15), totdat PO4 en NO3 onder controle zijn. Verlaagd de dosering als het doel bereikt is. (Maak gebruik CarbonVS indien PO4 onmeetbaar is).\",IF($E$3=\"English\",\"Increase EZ-Carbon dosage (D1-15) until PO4 and NO3 are under control. Decrease when target is reached. (Use CarbonVS if PO4 is immeasurable).\",IF($E$3=\"Deutsch\",\"Erhöhen Sie die EZ-Carbon Dosierung (D1-15), bis PO4 und NO3 unter Kontrolle sind. (Verwenden Sie CarbonVS, wenn PO4 nicht messbar ist).\",IF($E$3=\"Français\",\"Augmentez la dose de EZ-Carbon (D1-15) jusqu'à ce que PO4 et NO3 soient sous contrôle. (Utilisez CarbonVS si PO4 est incommensurable).\",IF($E$3=\"Español\",\"Aumente la dosis de EZ-Carbon (D1-15) hasta que PO4 y NO3 estén bajo control. (Use CarbonVS si PO4 no se puede medir).\",IF($E$3=\"Português\",\"Incremente a dosagem de EZ-Carbon (D1-15) até PO4 e NO3 estarem sob controlo. Decremente o valor da dosagem assim que atingir o objectivo. (Use CarbonVS se PO4 for incomensurável). \",IF($E$3=\"Slovenščina\",\"Povečajte odmerek EZ-Carbon (D1-15), dokler nista PO4 in NO3 pod nadzorom. Zmanjšajte, ko je cilj dosežen. (Uporabite CarbonVS, če je PO4 neizmerljiv).\")))))))","v":"Increase EZ-Carbon dosage (D1-15) until PO4 and NO3 are under control. Decrease when target is reached. (Use CarbonVS if PO4 is immeasurable)."}]
[{"$f":"IF($E$3=\"Nederlands\",\"Calibration ratio is om instelling te berekenen die afwijken van de 1:1 ml/ml of ml/s verhouding.\",IF($E$3=\"English\",\"Calibration ratio is to calculate setting that deviate from the 1:1 ml /ml or ml /s ratio.\",IF($E$3=\"Deutsch\",\"Das 'Calibration ratio' dient zur Berechnung der Einstellung, die von dem Verhältnis 1:1 ml / ml oder ml /s abweicht.\",IF($E$3=\"Français\",\"Le 'Calibration ratio' consiste à calculer un réglage qui s'écarte du rapport 1:1 ml / ml ou ml /s.\",IF($E$3=\"Español\",\"'Calibration ratio' es calcular una configuración que se desvía de la relación 1:1 ml /ml o ml /s.\",IF($E$3=\"Português\",\"O rácio de calibração é calculado através do relação 1:1 ml/ml ou ml/s \",IF($E$3=\"Slovenščina\",\"Kalibracijsko razmerje je izračunavanjedoziranj, ki odstopajo od razmerja 1:1 ml/ml ali ml/s.\")))))))","v":"Calibration ratio is to calculate setting that deviate from the 1:1 ml /ml or ml /s ratio."}]
[{"$f":"IF($E$3=\"Nederlands\",\"De EZ calculator is niet noodzakelijk, maar kan gebruikt worden om  (start) doseringen  te berekenen\",IF($E$3=\"English\",\"The EZ calculator is not necessary, but can be used to calculate (start) dosages\",IF($E$3=\"Deutsch\",\"Der EZ-Rechner ist nicht notwendig, kann aber zur Berechnung von (Start-) Dosierungen verwendet werden\",IF($E$3=\"Français\",\"La calculatrice EZ n'est pas nécessaire, mais peut être utilisée pour calculer (démarrer) des dosages\",IF($E$3=\"Español\",\"La calculadora EZ no es necesaria, pero se puede usar para calcular (comenzar) las dosis\",IF($E$3=\"Português\",\"A calculadora EZ não é extritamente necessária, mas poderá ser utilizada para calcular as dosagens de arranque. \",IF($E$3=\"Slovenščina\",\"EZ Kalkulator ni potreben, vendar ga je mogoče uporabiti za izračun (začetnih) odmerkov\")))))))","v":"The EZ calculator is not necessary, but can be used to calculate (start) dosages"}]
[{"$f":"IF($E$3=\"Nederlands\",\"Verplicht lezen\",IF($E$3=\"English\",\"Mandatory reading\",IF($E$3=\"Deutsch\",\"Pflichtlektüre\",IF($E$3=\"Français\",\"Lecture obligatoire\",IF($E$3=\"Español\",\"Lectura obligatoria\",IF($E$3=\"Português\",\"Leitura obrigatória\",IF($E$3=\"Slovenščina\",\"Obvezno branje\")))))))","v":"Mandatory reading"}]
[{"$f":"IF($E$3=\"Nederlands\",\"EZ Calculator 2.0 discussie topic\",IF($E$3=\"English\",\"EZ Calculator 2.0 discussion topic\",IF($E$3=\"Deutsch\",\"Diskussionsthema zu EZ Calculator 2.0\",IF($E$3=\"Français\",\"Sujet de discussion EZ Calculator 2.0\",IF($E$3=\"Español\",\"Tema de discusión de EZ Calculator 2.0\",IF($E$3=\"Português\",\"EZ Calculator 2.0 Forúm de Discussão\",IF($E$3=\"Slovenščina\",\"EZ Kalkulator 2.0 tema na Forumu\")))))))","v":"EZ Calculator 2.0 discussion topic"}]
[]
[null,null,null,"D1",1]
[null,null,null,"D2",{"$f":"E25*1.2","v":1.2}]
[null,null,null,"D3",{"$f":"E26*1.2","v":1.44}]
[null,null,null,"D4",1.728]
[null,null,null,"D5",2]
[null,null,null,"D6",2.4]
[null,null,null,"D7",2.88]
[null,null,null,"D8",3.456]
[null,null,null,"D9",4.1471999999999998]
[null,null,null,"D10",4.9766399999999997]
[null,null,null,"D11",5.9719679999999995]
[null,null,null,"D12",7.1663615999999992]
[null,null,null,"D13",8.5996339199999987]
[null,null,null,"D14",10.319560703999999]
[null,null,null,"D15",12.383472844799998]

{"sheet":"CompactCalc","index":12,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,5],[0,1,0,5],[1,3,2,5],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3]]}
[]
[null,"Liquid ?","Y","DSR Compact  v.200713",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$2=\"Y\",\"EZCalcium\",\"Ca+ / 420-460\")","v":"EZCalcium"}]
[null,"Volume (L)",100]
[null,"Product / range","Value","Target","Dosing","Unit",null,null,null,"liquid","solid","ratio"]
[null,"NaCl / 32-35 (ppt)",34,33,{"$f":"($C$3/100)*(D5-C5)*100","v":-100},"gram",null,null,"Y"]
[null,"PH+ (2x) / 7-9",7,9,{"$f":"($C$3/100)*(D6-C6)*3*11.1/2","v":33.299999999999997},"ml",null,null,"N"]
[null,"KH+ / 7-9",7,9,{"$f":"IF($C$2=\"Y\",($C$3/100)*(D7-C7)*3*11.1,($C$3/100)*(D7-C7)*3)","v":66.599999999999994},{"$f":"IF($C$2=\"Y\", \"ml\",\"gram\")","v":"ml"}]
[null,{"$f":"IF($C$2=\"Y\",\"EZCalcium\",\"Ca+ / 420-460\")","v":"EZCalcium"},420,440,{"$f":"IF($C$2=\"Y\", ($C$3/100)*(D8-C8)*0.578,($C$3/100)*(D8-C8)*0.3668)","v":11.559999999999999},{"$f":"IF($C$2=\"Y\", \"ml\",\"gram\")","v":"ml"}]
[null,"Mg+ / 1250-1400",1250,1350,{"$f":"IF($C$2=\"Y\", ($C$3/100)*(D9-C9)*0.836*1.33,($C$3/100)*(D9-C9)*0.836)","v":111.188},{"$f":"IF($C$2=\"Y\", \"ml\",\"gram\")","v":"ml"}]
[null,"MgSO4+  \n",1250,1350,{"$f":"IF($C$2=\"Y\", ($C$3/100)*(D10-C10)*0.836*1.33,($C$3/100)*(D10-C10)*1.01389)","v":111.188},{"$f":"IF($C$2=\"Y\", \"ml\",\"gram\")","v":"ml"}]
[null,"K+ rev1 / 380-420",380,390,{"$f":"IF($C$2=\"Y\",($C$3/100)*(D11-C11)*0.7,($C$3/100)*(D11-C11)*0.190476)","v":7},{"$f":"IF($C$2=\"Y\", \"ml\",\"gram\")","v":"ml"},null,null,null,{"$f":"($C$3/100)*(D11-C11)*0.7","v":7},{"$f":"($C$3/100)*(D11-C11)*0.190476","v":1.90476},{"$f":"J11/K11","v":3.675003675003675}]
[null,"Sr+ / 3-10",3,10,{"$f":"($C$3/100)*(D12-C12)*3","v":21},"ml"]
[null,"B+ / 3-5",3,5,{"$f":"($C$3/100)*(D13-C13)*12.68","v":25.36},"ml"]
[null,"I2+ / 0,03-0,06",0.03,0.06,{"$f":"($C$3/100)*(D14-C14)*100*0.26","v":0.78},"ml"]
[null,"Mn+ (<0,1ppb/d) ",0,0.1,{"$f":"($C$3/100)*(D15-C15)*10*0.1","v":0.1},"ml"]
[null,"PO4+ / 0,04-0,08",0.01,0.06,{"$f":"($C$3/100)*(D16-C16)*100*0.1","v":0.5},"ml"]
[null,"2xNO3+ rev2 / 1-3",1.5,2.5,{"$f":"($C$3/100)*(D17-C17)*(0.8)","v":0.8},"ml"]
[null,"Fe (< 0,15ppm/d)",0,0.15,{"$f":"($C$3/100)*(D18-C18)*10*0.4975","v":0.74624999999999997},"ml"]
[null,"CarbonVS (average daily dose)",null,null,{"$f":"(C3/100)*0.5","v":0.5},"ml"]
[null,"Amino/C (weekly dose)",null,null,{"$f":"(C3/100)*1","v":1},"ml"]
[null,"NaCl surplus correction rate (%)",null,null,35,{"$f":"100+E21","v":135}]
[null,"Saltwater to be removed",null,null,{"$f":"-(E5/(D5*F21)*100)","v":2.244668911335578},"liters"]
[null,"mobilescreen: tap on yellow fields until keyboard appear"]