{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Tabel","Sheet3"],"not_rendered":{"charts":0,"images":8,"macros":0,"external_links":1,"defined_names":8,"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":114,"n_cols":10,"rows_kept":114,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B:",3450,"Tzero:",273.15,"R0",5500,"Rdiv",10000,"Vin",5]
[]
["Temperature","Resitance","Voltage","ADC value"]
[-10,8888.146716400755,2.647162834487331,542]
[-9,8457.775357541468,2.708885498466695,555]
[-8,8051.256534738713,2.769890279038336,567]
[-7,7667.114314001279,2.830116968246181,580]
[-6,7303.973051349232,2.889509816712375,592]
[-5,6960.549998275302,2.9480176058609207,604]
[-4,6635.648493429727,3.0055936815296125,616]
[-3,6328.151690917881,3.0621959512913657,627]
[-2,6037.016780055431,3.1177868481239552,639]
[-1,5761.269655458627,3.1723332633093686,650]
[0,5500,3.225806451612903,661]
[1,5252.356746469248,3.2781819118920392,671]
[2,5017.54388678042,3.3294392463213502,682]
[3,4794.816600288614,3.3795620013988286,692]
[4,4583.477675250583,3.428537493827985,702]
[5,4382.874199707976,3.4763566242563106,712]
[6,4192.394500110813,3.523013681701816,722]
[7,4011.4653078529896,3.568506141322461,731]
[8,3839.549135577596,3.6128344579856315,740]
[9,3676.141846644925,3.6560018578826132,749]
[10,3520.770402553107,3.6980141302124747,757]
[11,3372.990774374548,3.7388794207358966,766]
[12,3232.386005431868,3.7786080287769037,774]
[13,3098.5644134949125,3.817212209033156,782]
[14,2971.1579217462518,3.854705979346269,789]
[15,2849.820508643634,3.8911049353854175,797]
[16,2734.2267676129213,3.9264260730117884,804]
[17,2624.070568240465,3.9606876189198115,811]
[18,2519.0638113061286,3.9939088699942844,818]
[19,2418.935270613139,4.026110041680846,825]
[20,2323.4295151335755,4.057312125540895,831]
[21,2232.3059055033104,4.087536756050633,837]
[22,2145.3376593720473,4.116806086606995,843]
[23,2062.310980546226,4.145142674620034,849]
[24,1983.0242472588955,4.1725693755011335,855]
[25,1907.2872552639542,4.199109245298175,860]
[26,1834.9205117856454,4.224785451681587,865]
[27,1765.7545766601813,4.2496211929479975,870]
[28,1699.6294472874033,4.273639624679965,875]
[29,1636.3939842686857,4.296863793680011,880]
[30,1575.9053748444612,4.319316578783957,885]
[31,1518.0286314630475,4.3410206381514165,889]
[32,1462.6361230131956,4.361998362629385,893]
[33,1409.607136437407,4.38227183478749,897]
[34,1358.8274666132286,4.40186279322967,902]
[35,1310.189032546342,4.42079260179643,905]
[36,1263.589518063526,4.4390822232836635,909]
[37,1218.9320353267206,4.456752197317673,913]
[38,1176.124809611971,4.473822622041385,916]
[39,1135.0808839102897,4.49031313928288,920]
[40,1095.717842011887,4.506242922894473,923]
[41,1057.9575488316036,4.521630669967896,926]
[42,1021.7259068225012,4.536494594648717,929]
[43,986.9526274067858,4.550852424290587,932]
[44,953.5710164293345,4.564721397707165,935]
[45,921.5177727093744,4.578118265296396,938]
[46,890.7327988309383,4.591059290828182,940]
[47,861.1590233728953,4.603560254702234,943]
[48,832.7422338350565,4.615636458497986,945]
[49,805.4309195684812,4.627302730652852,948]
[50,779.176124065832,4.6385734331187765,950]
[51,753.9313060120026,4.649462468859869,952]
[52,729.6522085361981,4.659983290066146,954]
[53,706.2967361447998,4.670148906969709,956]
[54,683.8248388495958,4.679971897160367,958]
[55,662.198403038771,4.689464415307615,960]
[56,641.3811486684439,4.698638203205088,962]
[57,621.338532380808,4.707504600062148,964]
[58,602.0376561811538,4.716074552975128,966]
[59,583.4471813304478,4.724358627518042,968]
[60,565.5372471327975,4.732367018399245,969]
[61,548.2793943182162,4.74010956013663,971]
[62,531.6464927407017,4.747595737709599,972]
[63,515.6126731298754,4.754834697151123,974]
[64,500.15326265141266,4.761835256047911,975]
[65,485.2447240473056,4.7686059139209105,977]
[66,470.86459814170354,4.775154862462232,978]
[67,456.9914495118079,4.781489995608085,979]
[68,443.6048151360746,4.78761891943041,981]
[69,430.6851558438848,4.793548961832776,982]
[70,418.2138104019627,4.799287182038633,983]
[71,406.17295208318274,4.804840379862285,984]
[72,394.54554757307767,4.810215104755015,985]
[73,383.31531807837877,4.815417664620572,986]
[74,372.46670251035545,4.820454134395915,987]
[75,361.98482262359255,4.8253303643944445,988]
[76,351.85544999817705,4.83005198841033,989]
[77,342.0649747601659,4.834624431583549,990]
[78,332.6003759415956,4.839052918026317,991]
[79,323.4491933873289,4.843342478212362,992]
[80,314.59950112162363,4.8474979561313,993]
[81,306.0398820925826,4.851524016210948,994]
[82,297.7594042175435,4.855425150010984,994]
[83,289.74759765708006,4.85920568269184,995]
[84,281.9944332495925,4.862869779263016,996]
[85,274.4903020424952,4.866421450615449,997]
[86,267.2259958597962,4.869864559342731,997]
[87,260.1926888494034,4.873202825356206,998]
[88,253.38191995681285,4.876439831299154,999]
[89,246.7855762749445,4.879579027765379,999]
[90,240.39587722282099,4.8826237383275775,1000]
[91,234.205359508508,4.88557716438096,1001]
[92,228.20686283431994,4.888442389807571,1001]
[93,222.39351630469736,4.891222385466779,1002]
[94,216.75872549943065,4.8939200135173815,1002]
[95,211.29616017702912,4.896538031576705,1003]
[96,205.99974257503368,4.899079096722053,1003]
[97,200.86363627595006,4.901545769339743,1004]
[98,195.88223560923274,4.903940516826925,1004]
[99,191.05015556142254,4.906265717151258,1005]
[100,186.3622221680883,4.908523662273408,1005]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}