{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Tabel","Sheet3"],"not_rendered":{"charts":1,"images":9,"macros":0,"external_links":1,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["T",273,null,null,"RH16-3H103FB"]
["Ta",298]
["Vref",1.263]
["Beta",3450]
[]
[]
[]
[]
["ADC"]
[800,0.9876832844574779,62.76789838309452]
{"$rows_empty":24}
["Ro = takistus temperatuuril To, näiteks 25 ˚C."]
[]
["B = koefitsent, mis muutub sõltuvalt temperatuurist. Mõnedes temperatuurivahemikes on see muutuja konstantse suurusega. B väärtused leiate andmetabelist vastavalt vahemikele, näiteks 25–50 ˚C või 25–85 ˚C. Kui temperatuurivahemik on suurem, siis kasutage andmetabeli valemit nr. 2."]
[]
[{"$nulls":9},"I was hoping that the words would suffice... Here is the idea:"]
[]
[{"$nulls":9},"For the (10-=bit) ADC, the following proportion holds, where N is the number produced by the analog-digital conversion:"]
[]
[{"$nulls":9},"Vin/Vref = N/1023"]
[]
[{"$nulls":9},"For a simple voltage divider with R1 fixed and R2 variable and connected between Vcc and ground:"]
[]
[{"$nulls":9},"Vout/Vcc = R2/(R1+R2)."]
[]
[{"$nulls":9},"If Vref = Vcc, and Vout (divider) equal to Vin (ADC), then"]
[]
[{"$nulls":9},"Vcc*R2/(R1+R2) = Vcc*N/1023"]
[]
[{"$nulls":9},"R2/(R1+r2) = N/1023"]
[]
[{"$nulls":9},"This is why this circuit arrangment is \"ratiometric\". Vcc drops out. Given a value for one resistor, you can determine, uniquely, the value of the other from the value of N and never need to know what Vcc is. Simple, no?"]
[]
[{"$nulls":9},"This is why, for at least basic cases where the sensor is not too far from the ADC and resolution is sufficient, you don't need an amplifier. Just a resistor and the sensor is all you need. Resolution is the highest, I believe, at the point where the two resistors are about equal."]
[]
[{"$nulls":9},"You DO have to be careful about self heating of the temperature sensor, as well as noise and other such nasties."]

{"sheet":"Tabel","index":1,"n_rows":113,"n_cols":9,"rows_kept":113,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Temperature","Resitance","Voltage","ADC value"]
[-10,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-9,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-8,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-5,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-4,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-3,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-2,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[-1,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[1,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[2,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[3,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[4,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[5,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[8,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[9,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[10,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[11,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[12,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$nulls":4},"T = 1 / (ln(Rn/R0) / B + 1/T0) – 273"]
[13,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[14,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[15,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[16,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[17,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[18,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[19,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[20,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[21,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[22,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[23,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[24,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[25,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[26,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[27,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[28,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[29,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[30,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[31,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[32,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[33,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[34,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[35,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[36,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[37,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[38,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[39,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[40,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[41,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[42,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[43,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[44,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[45,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[46,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[47,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[48,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[49,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[50,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[51,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[52,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[53,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[54,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[55,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[56,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[57,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[58,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[59,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[60,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[61,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[62,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[63,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[64,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[65,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[66,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[67,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[68,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[69,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[70,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[71,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[72,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[73,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[74,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[75,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[76,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[77,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[78,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[79,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[80,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[81,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[82,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[83,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[84,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[85,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[86,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[87,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[88,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[89,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[90,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[91,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[92,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[93,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[94,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[95,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[96,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[97,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[98,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[99,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[100,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Sheet3","index":2,"n_rows":128,"n_cols":9,"rows_kept":128,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":6},"T0",298.15,"K"]
[{"$nulls":6},"R0",10000,"Ω"]
[{"$nulls":6},"B",3900]
[{"$nulls":6},"Rdiv",10000,"Ω"]
[{"$nulls":6},"V",5,"V"]
[]
["Temperature","Resitance","Voltage","ADC value","ADC comma"]
[-20,102289.48033812574,0.4452776862929648,91,"91,"]
[-19,96273.15733709522,0.4704856922750636,96,"96,"]
[-18,90653.7581347007,0.4967524405108361,102,"102,"]
[-17,85402.45379832106,0.5240955343318425,107,"107,"]
[-16,80492.69056061901,0.5525308142595907,113,"113,"]
[-15,75899.99661538824,0.5820721998846148,119,"119,"]
[-14,71601.80643314571,0.61273153359618,125,"125,"]
[-13,67577.30091038063,0.6445184275972857,132,"132,"]
[-12,63807.26183771844,0.6774401157156601,139,"139,"]
[-11,60273.939325293366,0.711501311582283,146,"146,"]
[-10,56960.930960404345,0.7467040747920044,153,"153,"]
[-9,53853.071594854206,0.7830476866837116,160,"160,"]
[-8,50936.33276885585,0.8205285373778625,168,"168,"]
[-7,48197.730876426875,0.8591400256853076,176,"176,"]
[-6,45625.243265060315,0.8988724734513893,184,"184,"]
[-5,43207.73154124023,0.939713055822461,192,"192,"]
[-4,40934.871424066274,0.9816457488174879,201,"201,"]
[-3,38797.088552724825,1.0246512954553721,210,"210,"]
[-2,36785.499710567936,1.0687071915298143,219,"219,"]
[-1,34891.8589798271,1.1137876919391627,228,"228,"]
[0,33108.50838710373,1.1598638382709134,238,"238,"]
[1,31428.33264128362,1.2069035081120947,247,"247,"]
[2,29844.71760290698,1.2548714863109511,257,"257,"]
[3,28351.51215771138,1.3037295581563255,267,"267,"]
[4,26942.99319744156,1.3534366241732325,277,"277,"]
[5,25613.833438427002,1.4039488359613221,288,"288,"]
[6,24359.07183316741,1.455219752232484,298,"298,"]
[7,23174.0863525156,1.507200513939956,309,"309,"]
[8,22054.568936242707,1.559840037139516,319,"319,"]
[9,20996.502428037664,1.6130852219885576,330,"330,"]
[10,19996.1393275159,1.6668811760763582,341,"341,"]
[11,19049.98220677394,1.721171450092692,352,"352,"]
[12,18154.765652578673,1.7758982836861417,364,"364,"]
[13,17307.439607559038,1.8310028592413103,375,"375,"]
[14,16505.153994906603,1.8864255612175773,386,"386,"]
[15,15745.244521193072,1.9421062386430552,398,"398,"]
[16,15025.219561085038,1.9979844683461434,409,"409,"]
[17,14342.748036065532,2.0539998165335076,421,"421,"]
[18,13695.648206840073,2.110092096386155,432,"432,"]
[19,13081.877305986685,2.166201619442437,444,"444,"]
[20,12499.521943668005,2.2222694386656245,455,"455,"]
[21,11946.789224919601,2.278237581250711,467,"467,"]
[22,11421.998522215437,2.3340492694063104,478,"478,"]
[23,10923.573851735571,2.389649127548666,489,"489,"]
[24,10450.036806067646,2.4449833745611986,501,"501,"]
[25,10000,2.5,512,"512,"]
[26,9572.160989646576,2.5546489233585072,523,"523,"]
[27,9165.296628413225,2.608882135738679,534,"534,"]
[28,8778.257826300365,2.6626538235070574,545,"545,"]
[29,8409.964681765203,2.715920473738022,556,"556,"]
[30,8059.401957858942,2.768640961460045,567,"567,"]
[31,7725.614876634669,2.820776618920475,578,"578,"]
[32,7407.705207907225,2.8722912872679016,588,"588,"]
[33,7104.827630354745,2.9231513512166867,599,"599,"]
[34,6816.18634469992,2.9733257574038996,609,"609,"]
[35,6541.03192031013,3.0227860172742194,619,"619,"]
[36,6278.658358022674,3.071506195432765,629,"629,"]
[37,6028.400353347452,3.11946288448914,639,"639,"]
[38,5789.630745432992,3.166635167479268,649,"649,"]
[39,5561.758138314693,3.213004568994985,658,"658,"]
[40,5344.224682003816,3.2585549961766107,667,"667,"]
[41,5136.504001930542,3.303272670731821,677,"677,"]
[42,4938.099266132097,3.3471460531368153,685,"685,"]
[43,4748.541380383348,3.3901657601546757,694,"694,"]
[44,4567.387302209064,3.4323244767727,703,"703,"]
[45,4394.2184653992235,3.473616863617142,711,"711,"]
[46,4228.639307276879,3.5140394608519427,720,"720,"]
[47,4070.2758915461645,3.5535905895094406,728,"728,"]
[48,3918.7746200805764,3.592270251137277,736,"736,"]
[49,3773.8010275024158,3.6300800265782867,743,"743,"]
[50,3635.038652856408,3.6670229746305476,751,"751,"]
[51,3502.1879830979287,3.7031035312639786,758,"758,"]
[52,3374.9654635006436,3.7383274099994157,766,"766,"]
[53,3253.102570443849,3.7727015039864353,773,"773,"]
[54,3136.3449423672914,3.8062337902486245,780,"780,"]
[55,3024.4515649841956,3.838933236499826,786,"786,"]
[56,2917.1940071228482,3.870809710872873,793,"793,"]
[57,2814.3557038256417,3.9018738948437983,799,"799,"]
[58,2715.731283573467,3.932137199579814,805,"805,"]
[59,2621.125936724431,3.9616116858886623,811,"811,"]
[60,2530.354822460361,3.990309987900438,817,"817,"]
[61,2443.2425117239386,4.018245240570562,823,"823,"]
[62,2359.6224638045474,4.04543101105444,829,"829,"]
[63,2279.336534393258,4.071881233970153,834,"834,"]
[64,2202.234513077783,4.097610150535326,839,"839,"]
[65,2128.173688387753,4.122632251537841,844,"844,"]
[66,2057.0184386297638,4.146962224077209,849,"849,"]
[67,1988.6398468716832,4.170614901993824,854,"854,"]
[68,1922.91533854689,4.193605219886915,859,"859,"]
[69,1859.7283402523374,4.215948170608447,863,"863,"]
[70,1798.9679584102078,4.23765876610932,868,"868,"]
[71,1740.5286765519656,4.258752001505636,872,"872,"]
[72,1684.3100700662865,4.279242822226502,876,"876,"]
[73,1630.2165373291941,4.299146094100341,880,"880,"]
[74,1578.1570462062175,4.318476576233984,884,"884,"]
[75,1528.0448949828333,4.337248896537583,888,"888,"]
[76,1479.7974868411864,4.355477529748493,892,"892,"]
[77,1433.336117058719,4.373176777808466,896,"896,"]
[78,1388.5857721577454,4.390360752450716,899,"899,"]
[79,1345.474940284972,4.407043359856393,903,"903,"]
[80,1303.9354321462854,4.423238287243691,906,"906,"]
[81,1263.902211865473,4.438958991257014,909,"909,"]
[82,1225.3132371757708,4.4542186880283205,912,"912,"]
[83,1188.1093083907813,4.469030344787688,915,"915,"]
[84,1152.2339256362961,4.4834066729054225,918,"918,"]
[85,1117.6331538572788,4.497360122253397,921,"921,"]
[86,1084.2554951447319,4.510902876778838,924,"924,"]
[87,1052.0517679556665,4.524046851189213,927,"927,"]
[88,1020.9749928259587,4.536803688652521,929,"929,"]
[89,990.9802842006612,4.549184759422607,932,"932,"]
[90,962.0247480296118,4.561201160304563,934,"934,"]
[91,934.067384797722,4.5728637148805165,937,"937,"]
[92,907.068997679688,4.584182974421152,939,"939,"]
[93,880.992105527718,4.595169219413292,941,"941,"]
[94,855.800860418629,4.605832461638567,943,"943,"]
[95,831.4609695031752,4.616182446742771,945,"945,"]
[96,807.9396209160119,4.626228657239882,947,"947,"]
[97,785.2054135191851,4.635980315898789,949,"949,"]
[98,763.2282902655846,4.645446389464833,951,"951,"]
[99,741.9794749815779,4.654635592671876,953,"953,"]
[100,721.4314123798952,4.663556392504238,955,"955,"]