{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Diagram","Beregning","New","Tabel"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Diagram","index":0,"n_rows":178,"n_cols":15,"rows_kept":178,"cut":false,"hidden":false,"merged":[[177,14,177,15],[177,12,177,13],[139,0,140,10],[169,0,170,10],[0,0,0,9],[1,0,1,6],[27,0,28,10],[55,0,56,10],[83,0,84,10],[111,0,112,10]]}
["Hysteresi beregninger for LM339 inverting comparator",null,null,null,null,null,null,null,null,null,null,null,"Indsæt fra 0 til 100 i celle H2 rødt tal"]
["Juster potentiometer P1 i % for Delta temperatur:",null,null,null,null,null,null,0.5,{"$f":"+New!J2/1000","v":1.1000000000000001},"M Ohm",null,null,"Aflæs værdien på potentiometer P1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"i celle I2  sort tal"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[null,null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Her er resultatet for \"Proto typen\" med standard Ohm værdier fra E96 rækken."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[null,null,null,null,null,null,null,null,null,null,null,null,"j@walter-lystfisker.dk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[null,null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Delta temperaturen for denne indstilling er 5,8 ºC omkring den valgte røgtemperatur."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[null,null,null,null,null,null,null,null,null,null,null,null,"j@walter-lystfisker.dk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[null,null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Delta temperaturen for denne indstilling er 3,3 ºC omkring den valgte røgtemperatur."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[null,null,null,null,null,null,null,null,null,null,null,null,"j@walter-lystfisker.dk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[null,null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Delta temperaturen for denne indstilling er 2,1 ºC omkring den valgte røgtemperatur."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[null,null,null,null,null,null,null,null,null,null,null,null,"j@walter-lystfisker.dk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[null,null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Delta temperaturen for denne indstilling er 1,6 ºC omkring den valgte røgtemperatur."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
[null,null,null,null,null,null,null,null,null,null,null,null,"j@walter-lystfisker.dk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[null,null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Delta temperaturen for denne indstilling er 1,3 ºC omkring den valgte røgtemperatur."]
[]
[]
[null,"Regnearket er Password beskyttet. Makro knapperne udskriver Diagrammerne. Regnearket har 4 ark: \"Beregning\" - \"New\" - \"Tabel\" disse er skjulte"]
[null,"Arket \"Diagram\", som er synligt\",  viser resultatet af potentiometerets P1 indsrilling. Regnearket er til min Temperature Controller, som ses herunder"]
[]
[]
[]
["walter",null,null,null,null,null,null,null,null,null,null,null,"walter",null,"Reg.No.1259"]

{"sheet":"Beregning","index":1,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,13,42,14],[0,0,0,9],[16,3,16,4],[3,3,3,4],[4,3,4,4],[1,0,1,6],[5,3,5,4],[6,3,6,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[28,3,28,4],[63,0,63,6],[17,3,17,4],[18,3,18,4],[22,3,22,4],[23,3,23,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[24,3,24,4],[56,0,56,6],[29,3,29,4],[30,3,30,4]]}
["Hysteresi beregninger for LM339 inverting comparator"]
["Juster potentiometer P1 i % for Delta temperatur:",null,null,null,null,null,null,{"$f":"+Diagram!H2","v":0.5},{"$f":"+New!J2","v":1100}," K Ohm"]
["Data"]
["Vcc",15,"V","Kalkuleret værdi",null,"Volt","Giver i °C","Standard værdier 1%","Volt","Giver i °C"]
["R1",{"$f":"+D5","v":125},"K Ohm",{"$f":"+New!F4","v":125},null,{"$f":"+($B$4*B6*(B5+B7))/((B5*B6)+(B5*B7)+(B6*B7))","v":8.7828947368421062},{"$f":"+F5*10","v":87.828947368421069},{"$f":"+New!G4","v":124},{"$f":"+($B$4*H6*(H5+H7))/((H5*H6)+(H5*H7)+(H6*H7))","v":8.7739097169089515},{"$f":"+ROUND(I5*10,0)","v":88}]
["R2",{"$f":"+D6","v":166.66666666666666},"K Ohm",{"$f":"+New!F5","v":166.66666666666666},null,{"$f":"+($B$4*B6*B7)/((B5*B6)+(B5*B7)+(B6*B7))","v":8.2894736842105274},{"$f":"+F6*10","v":82.894736842105274},{"$f":"+New!G5","v":165},{"$f":"+($B$4*H6*H7)/((H5*H6)+(H5*H7)+(H6*H7))","v":8.2847169089517987},{"$f":"+ROUND(I6*10,0)","v":83}]
["R3",{"$f":"+$D$7","v":2100},"K Ohm",{"$f":"+New!D6","v":2100},null,{"$f":"+F5-F6","v":0.49342105263157876},{"$f":"+G5-G6","v":4.9342105263157947},{"$f":"+$D$7","v":2100},{"$f":"+I5-I6","v":0.48919280795715281},{"$f":"+ROUND(I7*10,0)","v":5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
["R1",{"$f":"+D11","v":142.85714285714286},"K Ohm",{"$f":"+New!F15","v":142.85714285714286},null,{"$f":"+($B$4*B12*(B11+B13))/((B11*B12)+(B11*B13)+(B12*B13))","v":7.7467105263157894},{"$f":"+F11*10","v":77.46710526315789},{"$f":"+New!G15","v":140},{"$f":"+($B$4*H12*(H11+H13))/((H11*H12)+(H11*H13)+(H12*H13))","v":7.741935483870968},{"$f":"+ROUND(I11*10,0)","v":77}]
["R2",{"$f":"+D12","v":142.85714285714286},"K Ohm",{"$f":"+New!F16","v":142.85714285714286},null,{"$f":"+($B$4*B12*B13)/((B11*B12)+(B11*B13)+(B12*B13))","v":7.2532894736842115},{"$f":"+F12*10","v":72.53289473684211},{"$f":"+New!G16","v":140},{"$f":"+($B$4*H12*H13)/((H11*H12)+(H11*H13)+(H12*H13))","v":7.258064516129032},{"$f":"+ROUND(I12*10,0)","v":73}]
["R3",{"$f":"+$D$7","v":2100},"K Ohm",{"$f":"+$D$7","v":2100},null,{"$f":"+F11-F12","v":0.49342105263157787},{"$f":"+G11-G12","v":4.9342105263157805},{"$f":"+$D$7","v":2100},{"$f":"+I11-I12","v":0.48387096774193594},{"$f":"+ROUND(I13*10,0)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
["R1",{"$f":"+D17","v":166.66666666666666},"K Ohm",{"$f":"+New!F26","v":166.66666666666666},null,{"$f":"+($B$4*B18*(B17+B19))/((B17*B18)+(B17*B19)+(B18*B19))","v":6.7105263157894735},{"$f":"+F17*10","v":67.10526315789474},{"$f":"+New!G26","v":165},{"$f":"+($B$4*H18*(H17+H19))/((H17*H18)+(H17*H19)+(H18*H19))","v":6.7152830910482022},{"$f":"+ROUND(I17*10,0)","v":67}]
["R2",{"$f":"+D18","v":124.99999999999999},"K Ohm",{"$f":"+New!F27","v":124.99999999999999},null,{"$f":"+($B$4*B18*B19)/((B17*B18)+(B17*B19)+(B18*B19))","v":6.2171052631578947},{"$f":"+F18*10","v":62.171052631578945},{"$f":"+New!G27","v":124},{"$f":"+($B$4*H18*H19)/((H17*H18)+(H17*H19)+(H18*H19))","v":6.2260902830910485},{"$f":"+ROUND(I18*10,0)","v":62}]
["R3",{"$f":"+$D$7","v":2100},"K Ohm",{"$f":"+$D$7","v":2100},null,{"$f":"+F17-F18","v":0.49342105263157876},{"$f":"+G17-G18","v":4.9342105263157947},{"$f":"+$D$7","v":2100},{"$f":"+I17-I18","v":0.4891928079571537},{"$f":"+ROUND(I19*10,0)","v":5}]
[]
[]
[]
["R1",{"$f":"+D23","v":200},"K Ohm",{"$f":"+New!F37","v":200},null,{"$f":"+($B$4*B24*(B23+B25))/((B23*B24)+(B23*B25)+(B24*B25))","v":5.6743421052631575},{"$f":"+F23*10","v":56.743421052631575},{"$f":"+New!G37","v":200},{"$f":"+($B$4*H24*(H23+H25))/((H23*H24)+(H23*H25)+(H24*H25))","v":5.6389301634472515},{"$f":"+ROUND(I23*10,0)","v":56}]
["R2",{"$f":"+D24","v":111.1111111111111},"K Ohm",{"$f":"+New!F38","v":111.1111111111111},null,{"$f":"+($B$4*B24*B25)/((B23*B24)+(B23*B25)+(B24*B25))","v":5.1809210526315788},{"$f":"+F24*10","v":51.809210526315788},{"$f":"+New!G38","v":110},{"$f":"+($B$4*H24*H25)/((H23*H24)+(H23*H25)+(H24*H25))","v":5.1485884101040122},{"$f":"+ROUND(I24*10,0)","v":51}]
["R3",{"$f":"+$D$7","v":2100},"K Ohm",{"$f":"+$D$7","v":2100},null,{"$f":"+F23-F24","v":0.49342105263157876},{"$f":"+G23-G24","v":4.9342105263157876},{"$f":"+$D$7","v":2100},{"$f":"+I23-I24","v":0.49034175334323926},{"$f":"+ROUND(I25*10,0)","v":5}]
[]
[]
[]
["R1",{"$f":"+D29","v":250},"K Ohm",{"$f":"+New!F48","v":250},null,{"$f":"+($B$4*B30*(B29+B31))/((B29*B30)+(B29*B31)+(B30*B31))","v":4.6381578947368425},{"$f":"+F29*10","v":46.381578947368425},{"$f":"+New!G48","v":249},{"$f":"+($B$4*H30*(H29+H31))/((H29*H30)+(H29*H31)+(H30*H31))","v":4.6496437054631832},{"$f":"+ROUND(I29*10,0)","v":46}]
["R2",{"$f":"+D30","v":100},"K Ohm",{"$f":"+New!F49","v":100},null,{"$f":"+($B$4*B30*B31)/((B29*B30)+(B29*B31)+(B30*B31))","v":4.1447368421052628},{"$f":"+F30*10","v":41.44736842105263},{"$f":"+New!G49","v":100},{"$f":"+($B$4*H30*H31)/((H29*H30)+(H29*H31)+(H30*H31))","v":4.156769596199525},{"$f":"+ROUND(I30*10,0)","v":42}]
["R3",{"$f":"+$D$7","v":2100},"K Ohm",{"$f":"+$D$7","v":2100},null,{"$f":"+F29-F30","v":0.49342105263157965},{"$f":"+G29-G30","v":4.9342105263157947},{"$f":"+$D$7","v":2100},{"$f":"+I29-I30","v":0.49287410926365816},{"$f":"+ROUND(I31*10,0)","v":5}]
[]
[]
[]
["R1",{"$f":"+D35","v":333.33333333333331},"K Ohm",{"$f":"+New!F59","v":333.33333333333331},null,{"$f":"+($B$4*B36*(B35+B37))/((B35*B36)+(B35*B37)+(B36*B37))","v":3.6019736842105261},{"$f":"+F35*10","v":36.01973684210526},{"$f":"+New!G59","v":332},{"$f":"+($B$4*H36*(H35+H37))/((H35*H36)+(H35*H37)+(H36*H37))","v":3.6111779034635609},{"$f":"+ROUND(I35*10,0)","v":36}]
["R2",{"$f":"+D36","v":90.909090909090907},"K Ohm",{"$f":"+New!F60","v":90.909090909090907},null,{"$f":"+($B$4*B36*B37)/((B35*B36)+(B35*B37)+(B36*B37))","v":3.1085526315789469},{"$f":"+F36*10","v":31.085526315789469},{"$f":"+New!G60","v":90.9},{"$f":"+($B$4*H36*H37)/((H35*H36)+(H35*H37)+(H36*H37))","v":3.118204604142055},{"$f":"+ROUND(I36*10,0)","v":31}]
["R3",{"$f":"+$D$7","v":2100},"K Ohm",{"$f":"+$D$7","v":2100},null,{"$f":"+F35-F36","v":0.4934210526315792},{"$f":"+G35-G36","v":4.9342105263157912},{"$f":"+$D$7","v":2100},{"$f":"+I35-I36","v":0.49297329932150591},{"$f":"+ROUND(I37*10,0)","v":5}]
[]
[]
[]
[]
[]
["walter",null,null,null,null,null,null,null,null,null,null,null,null,"Reg.No.1259"]

{"sheet":"New","index":2,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,21,71,22],[2,12,2,17],[13,12,13,17],[24,12,24,17],[6,4,6,5],[25,11,33,11],[35,12,35,17],[3,11,11,11],[14,11,22,11],[68,12,68,17],[46,12,46,17],[57,12,57,17],[36,11,44,11],[47,11,55,11],[58,11,66,11],[0,0,0,7],[1,0,1,7],[66,0,67,2],[11,0,12,2],[22,0,23,2],[33,0,34,2],[44,0,45,2],[55,0,56,2],[2,6,2,7],[2,0,2,2]]}
["Hysteresi beregninger for LM339 inverting comparator"]
["Juster potentiometer P1 i % for Delta temperatur:",null,null,null,null,null,null,null,{"$f":"+Beregning!H2","v":0.5},{"$f":"G7*I2","v":1100}," K Ohm"]
["Data given",null,null,"Find data","Equation","Kalkuleret værdier","Standard værdier",null,"I alt",null,"Giver i °C",null,"Range 6"]
["Vcc",15,"Volt","R1","n * R3",{"$f":"+F13*B6","v":125},124,"K Ohm",null,null,null,"80 ºC","P1 Adjust.","Relay Off Volt","Relay Off Temp","Relay On Volt","Relay On Temp","Delta Temp"]
["Rload",100,"K Ohm","R2","(R1//R3) / ( (Vcc/VA1) -1 )",{"$f":"+F12/((B4/B9)-1)","v":166.66666666666666},165,"K Ohm",null,null,null,null,0,8.3000000000000007,{"$f":"+N5*10","v":83},7.7,{"$f":"+P5*10","v":77},{"$f":"+O5-Q5","v":6}]
["R3",1000,"K Ohm",{"$f":"+B6+$J$2","v":2100},null,null,null,null,null,null,null,null,0.25,8.25,82.5,7.89,{"$f":"+P6*10","v":78.899999999999991},{"$f":"+O6-Q6","v":3.6000000000000085}]
["Rpull up",3,"K Ohm",null,"Potentiometer P1",null,2200,"K Ohm",{"$f":"+G7/1000","v":2.2000000000000002},"M Ohm",null,null,0.5,8.1999999999999993,82,7.99,{"$f":"+P7*10","v":79.900000000000006},{"$f":"+O7-Q7","v":2.0999999999999943}]
["Rload",100,"K Ohm",null,null,null,null,null,null,null,null,null,0.75,8.1999999999999993,82,8,{"$f":"+P8*10","v":80},{"$f":"+O8-Q8","v":2}]
["VA1",9,"Volt",{"$f":"+B9*10","v":90},{"$f":"CONCATENATE($E$14,K9,$G$14)","v":"Slukker ved 87,74 ºC"},"Vcc*R2*(R1+R3) / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B4*G5*(G4+D6))/(G4*G5+G4*D6+G5*D6)","v":8.7739097169089515},null,{"$f":"ROUND(+I9*10,2)","v":87.74},null,1,8.1999999999999993,82,8.0399999999999991,{"$f":"+P9*10","v":80.399999999999991},{"$f":"+O9-Q9","v":1.6000000000000085}]
["VA2",8,"Volt",{"$f":"+B10*10","v":80},{"$f":"CONCATENATE($F$14,K10,$G$14)","v":"Tænder ved 82,85 ºC"},"Vcc*R2*R3 / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B4*G5*D6)/(G4*G5+G4*D6+G5*D6)","v":8.2847169089517987},null,{"$f":"ROUND(+I10*10,2)","v":82.85},null,"Average",{"$f":"AVERAGE(N5:N9)","v":8.23},82.300000000000011,{"$f":"AVERAGE(P5:P9)","v":7.9239999999999995},{"$f":"AVERAGE(Q5:Q9)","v":79.239999999999981},{"$f":"+(N10*10)-(P10*10)","v":3.0600000000000165},null,"Udarbejdet af Jørgen Walter ©"]
["Delta VA",{"$f":"+B9-B10","v":1},"Volt",{"$f":"+B11*10","v":10},{"$f":"CONCATENATE($H$14,K11,$G$14)","v":"Delta 4,89 ºC"},"Delta VA",null,null,{"$f":"+I9-I10","v":0.48919280795715281},null,{"$f":"ROUND(+I11*10,2)","v":4.8899999999999997}]
["Range 6",null,null,"R1 // R3","(R1 * R3) / ( (R1 + R3)",{"$f":"+(F4*B6)/(F4+B6)","v":111.11111111111111},null,"K Ohm",null,null,null,null,"Fan Volt",5.55,"Min",5.6,"Max",{"$f":"+P12-N12","v":4.9999999999999822E-2}]
[null,null,null,"n =","delta VA / VA2",{"$f":"+B11/B10","v":0.125}]
[null,null,null,null,"Slukker ved ","Tænder ved "," ºC","Delta ",null,null,null,null,"Range 5",null,null,null,null,null,null,"www.walter-lystfisker.dk "]
["Vcc",{"$f":"+$B$4","v":15},"Volt","R1","n * R3",{"$f":"+F24*B17","v":142.85714285714286},140,"K Ohm",null,null,null,"70 ºC","P1 Adjust.","Relay Off Volt","Relay Off Temp","Relay On Volt","Relay On Temp","Delta Temp"]
["Rload",{"$f":"+$B$5","v":100},"K Ohm","R2","(R1//R3) / ( (Vcc/VA1) -1 )",{"$f":"+F23/((B15/B20)-1)","v":142.85714285714286},140,"K Ohm",null,null,null,null,0,7.35,{"$f":"+ROUND(N16,1)*10","v":74},6.78,{"$f":"+ROUND(P16,1)*10","v":68},{"$f":"+(N16*10)-(P16*10)","v":5.7000000000000028},null,"COPYRIGHT © 2014"]
["R3",{"$f":"+$B$6","v":1000},"K Ohm",{"$f":"+B17+$J$2","v":2100},null,null,null,null,null,null,null,null,0.25,7.27,{"$f":"+ROUND(N17,1)*10","v":73},6.95,{"$f":"+ROUND(P17,1)*10","v":70},3.1999999999999886]
["Rpull up",{"$f":"+$B$7","v":3},"K Ohm",null,null,null,null,null,null,null,null,null,0.5,7.23,{"$f":"+ROUND(N18,1)*10","v":72},7,{"$f":"+ROUND(P18,1)*10","v":70},2.3000000000000114]
["Rload",{"$f":"+B8","v":100},"K Ohm",null,null,null,null,null,null,null,null,null,0.75,7.21,{"$f":"+ROUND(N19,1)*10","v":72},7.05,{"$f":"+ROUND(P19,1)*10","v":71},1.5999999999999943]
["VA1",{"$f":"+B9-1","v":8},"Volt",{"$f":"+B20*10","v":80},{"$f":"CONCATENATE($E$14,K20,$G$14)","v":"Slukker ved 77,42 ºC"},"Vcc*R2*(R1+R3) / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B15*G16*(G15+D17))/(G15*G16+G15*D17+G16*D17)","v":7.741935483870968},null,{"$f":"ROUND(+I20*10,2)","v":77.42},null,1,7.2,{"$f":"+ROUND(N20,1)*10","v":72},7.06,{"$f":"+ROUND(P20,1)*10","v":71},1.4000000000000057]
["VA2",{"$f":"+B10-1","v":7},"Volt",{"$f":"+B21*10","v":70},{"$f":"CONCATENATE($F$14,K21,$G$14)","v":"Tænder ved 72,58 ºC"},"Vcc*R2*R3 / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B15*G16*D17)/(G15*G16+G15*D17+G16*D17)","v":7.258064516129032},null,{"$f":"ROUND(+I21*10,2)","v":72.58},null,"Average",{"$f":"AVERAGE(N16:N20)","v":7.2520000000000007},{"$f":"AVERAGE(O16:O20)","v":72.599999999999994},{"$f":"AVERAGE(P16:P20)","v":6.9680000000000009},{"$f":"AVERAGE(Q16:Q20)","v":70},2.8400000000000034]
["Delta VA",{"$f":"+B20-B21","v":1},"Volt",{"$f":"+B22*10","v":10},{"$f":"CONCATENATE($H$14,K22,$G$14)","v":"Delta 4,84 ºC"},"Delta VA",null,null,{"$f":"+I20-I21","v":0.48387096774193594},null,{"$f":"ROUND(+I22*10,2)","v":4.84}]
["Range 5",null,null,"R1 // R3","(R1 * R3) / ( (R1 + R3)",{"$f":"+(F15*B17)/(F15+B17)","v":125.00000000000001},null,"K Ohm",null,null,null,null,"Fan Volt",5.8,"Min",5.9,"Max",{"$f":"+P23-N23","v":0.10000000000000053}]
[null,null,null,"n =","delta VA / VA2",{"$f":"+B22/B21","v":0.14285714285714285}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Range 4"]
["Vcc",{"$f":"+$B$4","v":15},"Volt","R1","n * R3",{"$f":"+F35*B28","v":166.66666666666666},165,"K Ohm",null,null,null,"60 ºC","P1 Adjust.","Relay Off Volt","Relay Off Temp","Relay On Volt","Relay On Temp","Delta Temp"]
["Rload",{"$f":"+$B$5","v":100},"K Ohm","R2","(R1//R3) / ( (Vcc/VA1) -1 )",{"$f":"+F34/((B26/B31)-1)","v":124.99999999999999},124,"K Ohm",null,null,null,null,0,6.42,{"$f":"+ROUND(N27,1)*10","v":64},5.84,{"$f":"+ROUND(P27,1)*10","v":58},{"$f":"+(N27*10)-(P27*10)","v":5.8000000000000043}]
["R3",{"$f":"+$B$6","v":1000},"K Ohm",{"$f":"+B28+$J$2","v":2100},null,null,null,null,null,null,null,null,0.25,6.3,{"$f":"+ROUND(N28,1)*10","v":63},5.97,{"$f":"+ROUND(P28,1)*10","v":60},3.3000000000000043]
["Rpull up",{"$f":"+$B$7","v":3},"K Ohm",null,null,null,null,null,null,null,null,null,0.5,6.25,{"$f":"+ROUND(N29,1)*10","v":63},6.03,{"$f":"+ROUND(P29,1)*10","v":60},2.1999999999999957]
["Rload",{"$f":"+B19","v":100},"K Ohm",null,null,null,null,null,null,null,null,null,0.75,6.23,{"$f":"+ROUND(N30,1)*10","v":62},6.06,{"$f":"+ROUND(P30,1)*10","v":61},1.7000000000000099]
["VA1",{"$f":"+B20-1","v":7},"Volt",{"$f":"+B31*10","v":70},{"$f":"CONCATENATE($E$14,K31,$G$14)","v":"Slukker ved 67,15 ºC"},"Vcc*R2*(R1+R3) / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B26*G27*(G26+D28))/(G26*G27+G26*D28+G27*D28)","v":6.7152830910482022},null,{"$f":"ROUND(+I31*10,2)","v":67.150000000000006},null,1,6.2,{"$f":"+ROUND(N31,1)*10","v":62},6.08,{"$f":"+ROUND(P31,1)*10","v":61},1.2000000000000028]
["VA2",{"$f":"+B21-1","v":6},"Volt",{"$f":"+B32*10","v":60},{"$f":"CONCATENATE($F$14,K32,$G$14)","v":"Tænder ved 62,26 ºC"},"Vcc*R2*R3 / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B26*G27*D28)/(G26*G27+G26*D28+G27*D28)","v":6.2260902830910485},null,{"$f":"ROUND(+I32*10,2)","v":62.26},null,"Average",{"$f":"AVERAGE(N27:N31)","v":6.2799999999999994},{"$f":"AVERAGE(O27:O31)","v":62.8},{"$f":"AVERAGE(P27:P31)","v":5.9959999999999996},{"$f":"AVERAGE(Q27:Q31)","v":60},2.8400000000000034]
["Delta VA",{"$f":"+B31-B32","v":1},"Volt",{"$f":"+B33*10","v":10},{"$f":"CONCATENATE($H$14,K33,$G$14)","v":"Delta 4,89 ºC"},"Delta VA",null,null,{"$f":"+I31-I32","v":0.4891928079571537},null,{"$f":"ROUND(+I33*10,2)","v":4.8899999999999997}]
["Range 4",null,null,"R1 // R3","(R1 * R3) / ( (R1 + R3)",{"$f":"+(F26*B28)/(F26+B28)","v":142.85714285714283},null,"K Ohm",null,null,null,null,"Fan Volt",6,"Min",6.15,"Max",{"$f":"+P34-N34","v":0.15000000000000036}]
[null,null,null,"n =","delta VA / VA2",{"$f":"+B33/B32","v":0.16666666666666666}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Range 3"]
["Vcc",{"$f":"+$B$4","v":15},"Volt","R1","n * R3",{"$f":"+F46*B39","v":200},200,"K Ohm",null,null,null,"50 ºC","P1 Adjust.","Relay Off Volt","Relay Off Temp","Relay On Volt","Relay On Temp","Delta Temp"]
["Rload",{"$f":"+$B$5","v":100},"K Ohm","R2","(R1//R3) / ( (Vcc/VA1) -1 )",{"$f":"+F45/((B37/B42)-1)","v":111.1111111111111},110,"K Ohm",null,null,null,null,0,5.4,{"$f":"+ROUND(N38,1)*10","v":54},4.83,{"$f":"+ROUND(P38,1)*10","v":48},{"$f":"+(N38*10)-(P38*10)","v":5.7000000000000028}]
["R3",{"$f":"+$B$6","v":1000},"K Ohm",{"$f":"+B39+$J$2","v":2100},null,null,null,null,null,null,null,null,0.25,5.28,{"$f":"+ROUND(N39,1)*10","v":53},4.95,{"$f":"+ROUND(P39,1)*10","v":50},3.3000000000000043]
["Rpull up",{"$f":"+$B$7","v":3},"K Ohm",null,null,null,null,null,null,null,null,null,0.5,5.21,{"$f":"+ROUND(N40,1)*10","v":52},5,{"$f":"+ROUND(P40,1)*10","v":50},2.1000000000000014]
["Rload",{"$f":"+B30","v":100},"K Ohm",null,null,null,null,null,null,null,null,null,0.75,5.18,{"$f":"+ROUND(N41,1)*10","v":52},5.03,{"$f":"+ROUND(P41,1)*10","v":50},1.4999999999999929]
["VA1",{"$f":"+B31-1","v":6},"Volt",{"$f":"+B42*10","v":60},{"$f":"CONCATENATE($E$14,K42,$G$14)","v":"Slukker ved 56,39 ºC"},"Vcc*R2*(R1+R3) / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B37*G38*(G37+D39))/(G37*G38+G37*D39+G38*D39)","v":5.6389301634472515},null,{"$f":"ROUND(+I42*10,2)","v":56.39},null,1,5.17,{"$f":"+ROUND(N42,1)*10","v":52},5.04,{"$f":"+ROUND(P42,1)*10","v":50},1.3000000000000043]
["VA2",{"$f":"+B32-1","v":5},"Volt",{"$f":"+B43*10","v":50},{"$f":"CONCATENATE($F$14,K43,$G$14)","v":"Tænder ved 51,49 ºC"},"Vcc*R2*R3 / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B37*G38*D39)/(G37*G38+G37*D39+G38*D39)","v":5.1485884101040122},null,{"$f":"ROUND(+I43*10,2)","v":51.49},null,"Average",{"$f":"AVERAGE(N38:N42)","v":5.2480000000000002},{"$f":"AVERAGE(O38:O42)","v":52.6},{"$f":"AVERAGE(P38:P42)","v":4.9700000000000006},{"$f":"AVERAGE(Q38:Q42)","v":49.6},2.7800000000000011]
["Delta VA",{"$f":"+B42-B43","v":1},"Volt",{"$f":"+B44*10","v":10},{"$f":"CONCATENATE($H$14,K44,$G$14)","v":"Delta 4,9 ºC"},"Delta VA",null,null,{"$f":"+I42-I43","v":0.49034175334323926},null,{"$f":"ROUND(+I44*10,2)","v":4.9000000000000004}]
["Range 3",null,null,"R1 // R3","(R1 * R3) / ( (R1 + R3)",{"$f":"+(F37*B39)/(F37+B39)","v":166.66666666666666},null,"K Ohm",null,null,null,null,"Fan Volt",6.4,"Min",6.6,"Max",{"$f":"+P45-N45","v":0.19999999999999929}]
[null,null,null,"n =","delta VA / VA2",{"$f":"+B44/B43","v":0.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Range 2"]
["Vcc",{"$f":"+$B$4","v":15},"Volt","R1","n * R3",{"$f":"+F57*B50","v":250},249,"K Ohm",null,null,null,"40 ºC","P1 Adjust.","Relay Off Volt","Relay Off Temp","Relay On Volt","Relay On Temp","Delta Temp"]
["Rload",{"$f":"+$B$5","v":100},"K Ohm","R2","(R1//R3) / ( (Vcc/VA1) -1 )",{"$f":"+F56/((B48/B53)-1)","v":100},100,"K Ohm",null,null,null,null,0,4.43,{"$f":"+ROUND(N49,1)*10","v":44},3.85,{"$f":"+ROUND(P49,1)*10","v":39},{"$f":"+(N49*10)-(P49*10)","v":5.7999999999999972}]
["R3",{"$f":"+$B$6","v":1000},"K Ohm",{"$f":"+B50+$J$2","v":2100},null,null,null,null,null,null,null,null,0.25,4.25,{"$f":"+ROUND(N50,1)*10","v":43},3.93,{"$f":"+ROUND(P50,1)*10","v":39},3.1999999999999957]
["Rpull up",{"$f":"+$B$7","v":3},"K Ohm",null,null,null,null,null,null,null,null,null,0.5,4.1500000000000004,{"$f":"+ROUND(N51,1)*10","v":42},3.97,{"$f":"+ROUND(P51,1)*10","v":40},1.7999999999999972]
["Rload",{"$f":"+B41","v":100},"K Ohm",null,null,null,null,null,null,null,null,null,0.75,4.1399999999999997,{"$f":"+ROUND(N52,1)*10","v":41},3.99,{"$f":"+ROUND(P52,1)*10","v":40},1.4999999999999929]
["VA1",{"$f":"+B42-1","v":5},"Volt",{"$f":"+B53*10","v":50},{"$f":"CONCATENATE($E$14,K53,$G$14)","v":"Slukker ved 46,5 ºC"},"Vcc*R2*(R1+R3) / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B48*G49*(G48+D50))/(G48*G49+G48*D50+G49*D50)","v":4.6496437054631832},null,{"$f":"ROUND(+I53*10,2)","v":46.5},null,1,4.12,{"$f":"+ROUND(N53,1)*10","v":41},4,{"$f":"+ROUND(P53,1)*10","v":40},1.2000000000000028]
["VA2",{"$f":"+B43-1","v":4},"Volt",{"$f":"+B54*10","v":40},{"$f":"CONCATENATE($F$14,K54,$G$14)","v":"Tænder ved 41,57 ºC"},"Vcc*R2*R3 / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B48*G49*D50)/(G48*G49+G48*D50+G49*D50)","v":4.156769596199525},null,{"$f":"ROUND(+I54*10,2)","v":41.57},null,"Average",{"$f":"AVERAGE(N49:N53)","v":4.218},{"$f":"AVERAGE(O49:O53)","v":42.2},{"$f":"AVERAGE(P49:P53)","v":3.9480000000000004},{"$f":"AVERAGE(Q49:Q53)","v":39.6},2.6999999999999957]
["Delta VA",{"$f":"+B53-B54","v":1},"Volt",{"$f":"+B55*10","v":10},{"$f":"CONCATENATE($H$14,K55,$G$14)","v":"Delta 4,93 ºC"},"Delta VA",null,null,{"$f":"+I53-I54","v":0.49287410926365816},null,{"$f":"ROUND(+I55*10,2)","v":4.93}]
["Range 2",null,null,"R1 // R3","(R1 * R3) / ( (R1 + R3)",{"$f":"+(F48*B50)/(F48+B50)","v":200},null,"K Ohm",null,null,null,null,"Fan Volt",7.25,"Min",9.3000000000000007,"Max",{"$f":"+P56-N56","v":2.0500000000000007}]
[null,null,null,"n =","delta VA / VA2",{"$f":"+B55/B54","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Range 1"]
["Vcc",{"$f":"+$B$4","v":15},"Volt","R1","n * R3",{"$f":"+F68*B61","v":333.33333333333331},332,"K Ohm",null,null,null,"30 ºC","P1 Adjust.","Relay Off Volt","Relay Off Temp","Relay On Volt","Relay On Temp","Delta Temp"]
["Rload",{"$f":"+$B$5","v":100},"K Ohm","R2","(R1//R3) / ( (Vcc/VA1) -1 )",{"$f":"+F67/((B59/B64)-1)","v":90.909090909090907},90.9,"K Ohm",null,null,null,null,0,3.47,{"$f":"+ROUND(N60,1)*10","v":35},2.91,{"$f":"+ROUND(P60,1)*10","v":29},{"$f":"+(N60*10)-(P60*10)","v":5.6000000000000014}]
["R3",{"$f":"+$B$6","v":1000},"K Ohm",{"$f":"+B61+$J$2","v":2100},null,null,null,null,null,null,null,null,0.25,3.3,{"$f":"+ROUND(N61,1)*10","v":33},2.98,{"$f":"+ROUND(P61,1)*10","v":30},3.1999999999999993]
["Rpull up",{"$f":"+$B$7","v":3},"K Ohm",null,null,null,null,null,null,null,null,null,0.5,3.21,{"$f":"+ROUND(N62,1)*10","v":32},3,{"$f":"+ROUND(P62,1)*10","v":30},2.1000000000000014]
["Rload",{"$f":"+B52","v":100},"K Ohm",null,null,null,null,null,null,null,null,null,0.75,3.16,{"$f":"+ROUND(N63,1)*10","v":32},3.01,{"$f":"+ROUND(P63,1)*10","v":30},1.5000000000000036]
["VA1",{"$f":"+B53-1","v":4},"Volt",{"$f":"+B64*10","v":40},{"$f":"CONCATENATE($E$14,K64,$G$14)","v":"Slukker ved 36,11 ºC"},"Vcc*R2*(R1+R3) / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B59*G60*(G59+D61))/(G59*G60+G59*D61+G60*D61)","v":3.6111779034635609},null,{"$f":"ROUND(+I64*10,2)","v":36.11},null,1,3.13,{"$f":"+ROUND(N64,1)*10","v":31},3.02,{"$f":"+ROUND(P64,1)*10","v":30},1.0999999999999979]
["VA2",{"$f":"+B54-1","v":3},"Volt",{"$f":"+B65*10","v":30},{"$f":"CONCATENATE($F$14,K65,$G$14)","v":"Tænder ved 31,18 ºC"},"Vcc*R2*R3 / (R1*R2+R1*R3+R2*R3)",null,null,{"$f":"+(B59*G60*D61)/(G59*G60+G59*D61+G60*D61)","v":3.118204604142055},null,{"$f":"ROUND(+I65*10,2)","v":31.18},null,"Average",{"$f":"AVERAGE(N60:N64)","v":3.254},{"$f":"AVERAGE(O60:O64)","v":32.6},{"$f":"AVERAGE(P60:P64)","v":2.984},{"$f":"AVERAGE(Q60:Q64)","v":29.8},2.6999999999999993]
["Delta VA",{"$f":"+B64-B65","v":1},"Volt",{"$f":"+B66*10","v":10},{"$f":"CONCATENATE($H$14,K66,$G$14)","v":"Delta 4,93 ºC"},"Delta VA",null,null,{"$f":"+I64-I65","v":0.49297329932150591},null,{"$f":"ROUND(+I66*10,2)","v":4.93}]
["Range 1",null,null,"R1 // R3","(R1 * R3) / ( (R1 + R3)",{"$f":"+(F59*B61)/(F59+B61)","v":250},null,"K Ohm",null,null,null,null,"Fan Volt",9.75,"Min",10.6,"Max",{"$f":"+P67-N67","v":0.84999999999999964}]
[null,null,null,"n =","delta VA / VA2",{"$f":"+B66/B65","v":0.33333333333333331}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Start temp 24 ºC og 13 Volt på Fan"]
[]
[]
["walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg.No.1259"]

{"sheet":"Tabel","index":3,"n_rows":134,"n_cols":19,"rows_kept":134,"cut":false,"hidden":false,"merged":[[133,18,133,19],[120,7,120,8],[120,9,120,10],[120,11,120,12],[54,11,54,12],[76,9,76,10],[76,11,76,12],[98,11,98,12],[120,1,120,2],[120,3,120,4],[120,5,120,6],[54,1,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[98,9,98,10],[76,1,76,2],[76,3,76,4],[76,5,76,6],[76,7,76,8],[98,1,98,2],[98,3,98,4],[98,5,98,6],[98,7,98,8],[54,9,54,10],[10,9,10,10],[10,11,10,12],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[32,9,32,10],[32,11,32,12],[32,1,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8]]}
["PC beregning"]
[{"$f":"CONCATENATE(A12,B2,$A$19,C2,$A$20)","v":"Range 1: 31 - 36 °C"},{"$f":"+Beregning!J36","v":31},{"$f":"+Beregning!J35","v":36}]
[{"$f":"CONCATENATE(A13,D3,$A$19,E3,$A$20)","v":"Range 2: 42 - 46 °C"},null,null,{"$f":"+Beregning!J30","v":42},{"$f":"+Beregning!J29","v":46}]
[{"$f":"CONCATENATE(A14,F4,$A$19,G4,$A$20)","v":"Range 3: 51 - 56 °C"},null,null,null,null,{"$f":"+Beregning!J24","v":51},{"$f":"+Beregning!J23","v":56}]
[{"$f":"CONCATENATE(A15,H5,$A$19,I5,$A$20)","v":"Range 4: 62 - 67 °C"},null,null,null,null,null,null,{"$f":"+Beregning!J18","v":62},{"$f":"+Beregning!J17","v":67}]
[{"$f":"CONCATENATE(A16,J6,$A$19,K6,$A$20)","v":"Range 5: 73 - 77 °C"},null,null,null,null,null,null,null,null,{"$f":"+Beregning!J12","v":73},{"$f":"+Beregning!J11","v":77}]
[{"$f":"CONCATENATE(A17,L7,$A$19,M7,$A$20)","v":"Range 6: 83 - 88 °C"},null,null,null,null,null,null,null,null,null,null,{"$f":"+Beregning!J6","v":83},{"$f":"+Beregning!J5","v":88}]
[{"$f":"CONCATENATE(A18,B8,$A$19,M8,$A$20)","v":"Total Range: 31 - 88 °C"},{"$f":"+B2","v":31},{"$f":"+C2","v":36},{"$f":"+D3","v":42},{"$f":"+E3","v":46},{"$f":"+F4","v":51},{"$f":"+G4","v":56},{"$f":"+H5","v":62},{"$f":"+I5","v":67},{"$f":"+J6","v":73},{"$f":"+K6","v":77},{"$f":"+L7","v":83},{"$f":"+M7","v":88}]
[{"$f":"CONCATENATE(A21,N9,$A$20)","v":"Delta temp:  5 °C"},0,{"$f":"+Beregning!J37","v":5},0,{"$f":"+Beregning!J31","v":5},0,{"$f":"+Beregning!J25","v":5},0,{"$f":"+Beregning!J19","v":5},0,{"$f":"+Beregning!J13","v":5},0,{"$f":"+Beregning!J7","v":5},{"$f":"ROUND((+C9+E9+G9+I9+K9+M9)/6,1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Udarbejdet af Jørgen Walter ©"]
["Range No.",{"$f":"+A2","v":"Range 1: 31 - 36 °C"},null,{"$f":"+A3","v":"Range 2: 42 - 46 °C"},null,{"$f":"+A4","v":"Range 3: 51 - 56 °C"},null,{"$f":"+A5","v":"Range 4: 62 - 67 °C"},null,{"$f":"+A6","v":"Range 5: 73 - 77 °C"},null,{"$f":"+A7","v":"Range 6: 83 - 88 °C"}]
["Range 1: "]
["Range 2: "]
["Range 3: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.walter-lystfisker.dk "]
["Range 4: "]
["Range 5: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COPYRIGHT © 2014"]
["Range 6: "]
["Total Range: "]
[" - "]
[" °C"]
["Delta temp:  "]
["Hard Ware Data"]
["P1 0%"]
[{"$f":"CONCATENATE(A34,B24,$A$19,C24,$A$20)","v":"Range 1: 29 - 35 °C"},{"$f":"+New!Q60","v":29},{"$f":"+New!O60","v":35}]
[{"$f":"CONCATENATE(A35,D25,$A$19,E25,$A$20)","v":"Range 2: 39 - 44 °C"},null,null,{"$f":"+New!Q49","v":39},{"$f":"+New!O49","v":44}]
[{"$f":"CONCATENATE(A36,F26,$A$19,G26,$A$20)","v":"Range 3: 48 - 54 °C"},null,null,null,null,{"$f":"+New!Q38","v":48},{"$f":"+New!O38","v":54}]
[{"$f":"CONCATENATE(A37,H27,$A$19,I27,$A$20)","v":"Range 4: 58 - 64 °C"},null,null,null,null,null,null,{"$f":"+New!Q27","v":58},{"$f":"+New!O27","v":64}]
[{"$f":"CONCATENATE(A38,J28,$A$19,K28,$A$20)","v":"Range 5: 68 - 74 °C"},null,null,null,null,null,null,null,null,{"$f":"+New!Q16","v":68},{"$f":"+New!O16","v":74}]
[{"$f":"CONCATENATE(A39,L29,$A$19,M29,$A$20)","v":"Range 6: 77 - 83 °C"},null,null,null,null,null,null,null,null,null,null,{"$f":"+New!Q5","v":77},{"$f":"+New!O5","v":83}]
[{"$f":"CONCATENATE(A40,B30,$A$19,M30,$A$20)","v":"Total Range: 29 - 83 °C"},{"$f":"+B24","v":29},{"$f":"+C24","v":35},{"$f":"+D25","v":39},{"$f":"+E25","v":44},{"$f":"+F26","v":48},{"$f":"+G26","v":54},{"$f":"+H27","v":58},{"$f":"+I27","v":64},{"$f":"+J28","v":68},{"$f":"+K28","v":74},{"$f":"+L29","v":77},{"$f":"+M29","v":83}]
[{"$f":"CONCATENATE(A43,N31,$A$20)","v":"Delta temp:  5,8 °C"},0,{"$f":"+New!R60","v":5.6000000000000014},0,{"$f":"+New!R49","v":5.7999999999999972},0,{"$f":"+New!R38","v":5.7000000000000028},0,{"$f":"+New!R27","v":5.8000000000000043},0,{"$f":"+New!R16","v":5.7000000000000028},0,{"$f":"+New!R5","v":6},{"$f":"ROUND((+C31+E31+G31+I31+K31+M31)/6,1)","v":5.8}]
[]
["Range No.",{"$f":"+A24","v":"Range 1: 29 - 35 °C"},null,{"$f":"+A25","v":"Range 2: 39 - 44 °C"},null,{"$f":"+A26","v":"Range 3: 48 - 54 °C"},null,{"$f":"+A27","v":"Range 4: 58 - 64 °C"},null,{"$f":"+A28","v":"Range 5: 68 - 74 °C"},null,{"$f":"+A29","v":"Range 6: 77 - 83 °C"}]
["Range 1: "]
["Range 2: "]
["Range 3: "]
["Range 4: "]
["Range 5: "]
["Range 6: "]
["Total Range: "]
[" - "]
[" °C"]
["Delta temp:  "]
["Hard Ware Data"]
["P1 25%"]
[{"$f":"CONCATENATE(A56,B46,$A$19,C46,$A$20)","v":"Range 1: 30 - 33 °C"},{"$f":"+New!Q61","v":30},{"$f":"+New!O61","v":33}]
[{"$f":"CONCATENATE(A57,D47,$A$19,E47,$A$20)","v":"Range 2: 39 - 43 °C"},null,null,{"$f":"+New!Q50","v":39},{"$f":"+New!O50","v":43}]
[{"$f":"CONCATENATE(A58,F48,$A$19,G48,$A$20)","v":"Range 3: 50 - 53 °C"},null,null,null,null,{"$f":"+New!Q39","v":50},{"$f":"+New!O39","v":53}]
[{"$f":"CONCATENATE(A59,H49,$A$19,I49,$A$20)","v":"Range 4: 60 - 63 °C"},null,null,null,null,null,null,{"$f":"+New!Q28","v":60},{"$f":"+New!O28","v":63}]
[{"$f":"CONCATENATE(A60,J50,$A$19,K50,$A$20)","v":"Range 5: 70 - 73 °C"},null,null,null,null,null,null,null,null,{"$f":"+New!Q17","v":70},{"$f":"+New!O17","v":73}]
[{"$f":"CONCATENATE(A61,L51,$A$19,M51,$A$20)","v":"Range 6: 78,9 - 82,5 °C"},null,null,null,null,null,null,null,null,null,null,{"$f":"+New!Q6","v":78.899999999999991},{"$f":"+New!O6","v":82.5}]
[{"$f":"CONCATENATE(A62,B52,$A$19,M52,$A$20)","v":"Total Range: 30 - 82,5 °C"},{"$f":"+B46","v":30},{"$f":"+C46","v":33},{"$f":"+D47","v":39},{"$f":"+E47","v":43},{"$f":"+F48","v":50},{"$f":"+G48","v":53},{"$f":"+H49","v":60},{"$f":"+I49","v":63},{"$f":"+J50","v":70},{"$f":"+K50","v":73},{"$f":"+L51","v":78.899999999999991},{"$f":"+M51","v":82.5}]
[{"$f":"CONCATENATE(A65,N53,$A$20)","v":"Delta temp:  3,3 °C"},0,{"$f":"+New!R61","v":3.1999999999999993},0,{"$f":"+New!R50","v":3.1999999999999957},0,{"$f":"+New!R39","v":3.3000000000000043},0,{"$f":"+New!R28","v":3.3000000000000043},0,{"$f":"+New!R17","v":3.1999999999999886},0,{"$f":"+New!R6","v":3.6000000000000085},{"$f":"ROUND((+C53+E53+G53+I53+K53+M53)/6,1)","v":3.3}]
[]
["Range No.",{"$f":"+A46","v":"Range 1: 30 - 33 °C"},null,{"$f":"+A47","v":"Range 2: 39 - 43 °C"},null,{"$f":"+A48","v":"Range 3: 50 - 53 °C"},null,{"$f":"+A49","v":"Range 4: 60 - 63 °C"},null,{"$f":"+A50","v":"Range 5: 70 - 73 °C"},null,{"$f":"+A51","v":"Range 6: 78,9 - 82,5 °C"}]
["Range 1: "]
["Range 2: "]
["Range 3: "]
["Range 4: "]
["Range 5: "]
["Range 6: "]
["Total Range: "]
[" - "]
[" °C"]
["Delta temp:  "]
["Hard Ware Data"]
["P1 50%"]
[{"$f":"CONCATENATE(A78,B68,$A$19,C68,$A$20)","v":"Range 1: 29 - 32 °C"},{"$f":"+New!Q60","v":29},{"$f":"+New!O62","v":32}]
[{"$f":"CONCATENATE(A79,D69,$A$19,E69,$A$20)","v":"Range 2: 40 - 42 °C"},null,null,{"$f":"+New!Q51","v":40},{"$f":"+New!O51","v":42}]
[{"$f":"CONCATENATE(A80,F70,$A$19,G70,$A$20)","v":"Range 3: 50 - 52 °C"},null,null,null,null,{"$f":"+New!Q40","v":50},{"$f":"+New!O40","v":52}]
[{"$f":"CONCATENATE(A81,H71,$A$19,I71,$A$20)","v":"Range 4: 60 - 63 °C"},null,null,null,null,null,null,{"$f":"+New!Q29","v":60},{"$f":"+New!O29","v":63}]
[{"$f":"CONCATENATE(A82,J72,$A$19,K72,$A$20)","v":"Range 5: 70 - 72 °C"},null,null,null,null,null,null,null,null,{"$f":"+New!Q18","v":70},{"$f":"+New!O18","v":72}]
[{"$f":"CONCATENATE(A83,L73,$A$19,M73,$A$20)","v":"Range 6: 79,9 - 82 °C"},null,null,null,null,null,null,null,null,null,null,{"$f":"+New!Q7","v":79.900000000000006},{"$f":"+New!O7","v":82}]
[{"$f":"CONCATENATE(A84,B74,$A$19,M74,$A$20)","v":"Total Range: 29 - 82 °C"},{"$f":"+B68","v":29},{"$f":"+C68","v":32},{"$f":"+D69","v":40},{"$f":"+E69","v":42},{"$f":"+F70","v":50},{"$f":"+G70","v":52},{"$f":"+H71","v":60},{"$f":"+I71","v":63},{"$f":"+J72","v":70},{"$f":"+K72","v":72},{"$f":"+L73","v":79.900000000000006},{"$f":"+M73","v":82}]
[{"$f":"CONCATENATE(A87,N75,$A$20)","v":"Delta temp:  2,1 °C"},0,{"$f":"+New!R62","v":2.1000000000000014},0,{"$f":"+New!R51","v":1.7999999999999972},0,{"$f":"+New!R40","v":2.1000000000000014},0,{"$f":"+New!R29","v":2.1999999999999957},0,{"$f":"+New!R18","v":2.3000000000000114},0,{"$f":"+New!R7","v":2.0999999999999943},{"$f":"ROUND((+C75+E75+G75+I75+K75+M75)/6,1)","v":2.1}]
[]
["Range No.",{"$f":"+A68","v":"Range 1: 29 - 32 °C"},null,{"$f":"+A69","v":"Range 2: 40 - 42 °C"},null,{"$f":"+A70","v":"Range 3: 50 - 52 °C"},null,{"$f":"+A71","v":"Range 4: 60 - 63 °C"},null,{"$f":"+A72","v":"Range 5: 70 - 72 °C"},null,{"$f":"+A73","v":"Range 6: 79,9 - 82 °C"}]
["Range 1: "]
["Range 2: "]
["Range 3: "]
["Range 4: "]
["Range 5: "]
["Range 6: "]
["Total Range: "]
[" - "]
[" °C"]
["Delta temp:  "]
["Hard Ware Data"]
["P1 75%"]
[{"$f":"CONCATENATE(A100,B90,$A$19,C90,$A$20)","v":"Range 1: 30 - 32 °C"},{"$f":"+New!Q63","v":30},{"$f":"+New!O63","v":32}]
[{"$f":"CONCATENATE(A101,D91,$A$19,E91,$A$20)","v":"Range 2: 40 - 41 °C"},null,null,{"$f":"+New!Q52","v":40},{"$f":"+New!O52","v":41}]
[{"$f":"CONCATENATE(A102,F92,$A$19,G92,$A$20)","v":"Range 3: 50 - 52 °C"},null,null,null,null,{"$f":"+New!Q41","v":50},{"$f":"+New!O41","v":52}]
[{"$f":"CONCATENATE(A103,H93,$A$19,I93,$A$20)","v":"Range 4: 61 - 62 °C"},null,null,null,null,null,null,{"$f":"+New!Q30","v":61},{"$f":"+New!O30","v":62}]
[{"$f":"CONCATENATE(A104,J94,$A$19,K94,$A$20)","v":"Range 5: 71 - 72 °C"},null,null,null,null,null,null,null,null,{"$f":"+New!Q19","v":71},{"$f":"+New!O19","v":72}]
[{"$f":"CONCATENATE(A105,L95,$A$19,M95,$A$20)","v":"Range 6: 80 - 82 °C"},null,null,null,null,null,null,null,null,null,null,{"$f":"+New!Q8","v":80},{"$f":"+New!O8","v":82}]
[{"$f":"CONCATENATE(A106,B96,$A$19,M96,$A$20)","v":"Total Range: 30 - 82 °C"},{"$f":"+B90","v":30},{"$f":"+C90","v":32},{"$f":"+D91","v":40},{"$f":"+E91","v":41},{"$f":"+F92","v":50},{"$f":"+G92","v":52},{"$f":"+H93","v":61},{"$f":"+I93","v":62},{"$f":"+J94","v":71},{"$f":"+K94","v":72},{"$f":"+L95","v":80},{"$f":"+M95","v":82}]
[{"$f":"CONCATENATE(A109,N97,$A$20)","v":"Delta temp:  1,6 °C"},0,{"$f":"+New!R63","v":1.5000000000000036},0,{"$f":"+New!R52","v":1.4999999999999929},0,{"$f":"+New!R41","v":1.4999999999999929},0,{"$f":"+New!R30","v":1.7000000000000099},0,{"$f":"+New!R19","v":1.5999999999999943},0,{"$f":"+New!R8","v":2},{"$f":"ROUND((+C97+E97+G97+I97+K97+M97)/6,1)","v":1.6}]
[]
["Range No.",{"$f":"+A90","v":"Range 1: 30 - 32 °C"},null,{"$f":"+A91","v":"Range 2: 40 - 41 °C"},null,{"$f":"+A92","v":"Range 3: 50 - 52 °C"},null,{"$f":"+A93","v":"Range 4: 61 - 62 °C"},null,{"$f":"+A94","v":"Range 5: 71 - 72 °C"},null,{"$f":"+A95","v":"Range 6: 80 - 82 °C"}]
["Range 1: "]
["Range 2: "]
["Range 3: "]
["Range 4: "]
["Range 5: "]
["Range 6: "]
["Total Range: "]
[" - "]
[" °C"]
["Delta temp:  "]
["Hard Ware Data"]
["P1 100%"]
[{"$f":"CONCATENATE(A122,B112,$A$19,C112,$A$20)","v":"Range 1: 30 - 31 °C"},{"$f":"+New!Q64","v":30},{"$f":"+New!O64","v":31}]
[{"$f":"CONCATENATE(A123,D113,$A$19,E113,$A$20)","v":"Range 2: 40 - 41 °C"},null,null,{"$f":"+New!Q53","v":40},{"$f":"+New!O53","v":41}]
[{"$f":"CONCATENATE(A124,F114,$A$19,G114,$A$20)","v":"Range 3: 50 - 52 °C"},null,null,null,null,{"$f":"+New!Q42","v":50},{"$f":"+New!O42","v":52}]
[{"$f":"CONCATENATE(A125,H115,$A$19,I115,$A$20)","v":"Range 4: 61 - 62 °C"},null,null,null,null,null,null,{"$f":"+New!Q31","v":61},{"$f":"+New!O31","v":62}]
[{"$f":"CONCATENATE(A126,J116,$A$19,K116,$A$20)","v":"Range 5: 71 - 72 °C"},null,null,null,null,null,null,null,null,{"$f":"+New!Q20","v":71},{"$f":"+New!O20","v":72}]
[{"$f":"CONCATENATE(A127,L117,$A$19,M117,$A$20)","v":"Range 6: 80,4 - 82 °C"},null,null,null,null,null,null,null,null,null,null,{"$f":"+New!Q9","v":80.399999999999991},{"$f":"+New!O9","v":82}]
[{"$f":"CONCATENATE(A128,B118,$A$19,M118,$A$20)","v":"Total Range: 30 - 82 °C"},{"$f":"+B112","v":30},{"$f":"+C112","v":31},{"$f":"+D113","v":40},{"$f":"+E113","v":41},{"$f":"+F114","v":50},{"$f":"+G114","v":52},{"$f":"+H115","v":61},{"$f":"+I115","v":62},{"$f":"+J116","v":71},{"$f":"+K116","v":72},{"$f":"+L117","v":80.399999999999991},{"$f":"+M117","v":82}]
[{"$f":"CONCATENATE(A131,N119,$A$20)","v":"Delta temp:  1,3 °C"},0,{"$f":"+New!R64","v":1.0999999999999979},0,{"$f":"+New!R53","v":1.2000000000000028},0,{"$f":"+New!R42","v":1.3000000000000043},0,{"$f":"+New!R31","v":1.2000000000000028},0,{"$f":"+New!R20","v":1.4000000000000057},0,{"$f":"+New!R9","v":1.6000000000000085},{"$f":"ROUND((+C119+E119+G119+I119+K119+M119)/6,1)","v":1.3}]
[]
["Range No.",{"$f":"+A112","v":"Range 1: 30 - 31 °C"},null,{"$f":"+A113","v":"Range 2: 40 - 41 °C"},null,{"$f":"+A114","v":"Range 3: 50 - 52 °C"},null,{"$f":"+A115","v":"Range 4: 61 - 62 °C"},null,{"$f":"+A116","v":"Range 5: 71 - 72 °C"},null,{"$f":"+A117","v":"Range 6: 80,4 - 82 °C"}]
["Range 1: "]
["Range 2: "]
["Range 3: "]
["Range 4: "]
["Range 5: "]
["Range 6: "]
["Total Range: "]
[" - "]
[" °C"]
["Delta temp:  "]
[]
[]
["walter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reg.No.1259"]