{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Diody","GA202","Teplota","Teplota - regrese"],"not_rendered":{"charts":10,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"Diody","index":0,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[2,2,2,8],[2,0,3,1],[4,1,15,1]],"flags":["formulas_cached_only"]}
["Měření vybranýh diod v propustném směru"]
[]
["Dioda",null,"Proud [mA]"]
[null,null,0.1,0.23,0.6,1.4,4,10.2,20]
["SCHOTTKY","Napětí [V]",0.12,0.14,0.16,0.19,0.21,0.24,0.26]
["OA9",null,0.17,0.2,0.23,0.26,0.3,0.35,0.4]
["GA201",null,0.18,0.23,0.28,0.39,0.58,0.88,1.21]
["1N4148",null,0.48,0.52,0.56,0.6,0.66,0.71,0.75]
["LED Infra",null,1.05,1.09,1.13,1.16,1.2,1.24,1.3]
["LED Červená",null,1.45,1.49,1.52,1.57,1.62,1.68,1.76]
["LED Žlutá",null,1.66,1.7,1.74,1.8,1.88,2,2.17]
["LED Zelená",null,1.74,1.77,1.8,1.86,1.93,2.04,2.18]
["LED Modrá",null,2.67,2.7,2.8,2.82,2.9,2.99,3.1]
["LED Bílá",null,2.44,2.52,2.58,2.62,2.7,2.82,2.96]
["LED Oranžová",null,1.48,1.76,2.67,{"$nulls":5},"Tato dioda je poškozená"]
["LED Bílá X",null,0.17,0.34,0.67,2.65,2.72,2.93,3.1,null,"Tato dioda je poškozená"]
{"$rows_empty":50}
[null,null,"Grafy bez poškozených diod"]

{"sheet":"GA202","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Didoa GA202 při teplotě +19DEGC"]
[]
["I [uA]","U [V]","Log(I)",null,"Io [uA]"]
[-18,-20.8,-10.92513880006811,0.5252470576955822,18]
[-8.7,-13.7,-11.652187532303737,0.8505246373944334,8.7]
[-6.9,-11.8,-11.88398914636106,1.0071177242678864,6.9]
[-5.1,-10.8,-12.186270018233994,1.1283583350216662,5.1]
[-4.2,-8.28,-12.380426032674952,1.4952205353472166,4.2]
[-3.4,-6.81,-12.591735126342158,1.8490066264819616,3.4]
[-2.5,-5.1,-12.89921982609012,2.529258789429435,2.5]
[-1.7,-3.19,-13.284882306902103,4.164539908119782,1.7]
[-0.9,-1.05,-13.9208710736221,13.257972451068666,0.9]
[0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[5,0.08,-12.206072645530174,-152.57590806912717,0.21968445695036048]
[10,0.1,-11.512925464970229,-115.12925464970228,0.1943357882586412]
[20,0.125,-10.819778284410283,-86.55822627528227,0.14267883108715185]
[30,0.135,-10.41431317630212,-77.14306056520088,0.143700495543357]
[40,0.146,-10.126631103850338,-69.36048701267354,0.12373266058547899]
[60,0.161,-9.721165995742174,-60.37991301703214,0.10233010285226572]
[80,0.172,-9.433483923290392,-54.84583676331624,0.08820678531583649]
[100,0.181,-9.210340371976184,-50.885858408708195,0.07717664873883798]
[150,0.199,-8.804875263868018,-44.245604341045315,0.05673371905844982]
[200,0.216,-8.517193191416238,-39.43144996026036,0.03857735760124699]
[400,0.26,-7.824046010856292,-30.092484657139583,0.01350761491988335]
[600,0.293,-7.418580902748128,-25.319388746580643,0.005484325282130833]
[800,0.322,-7.1308988302963465,-22.145648541293,0.0023190784930329114]
[1000,0.347,-6.907755278982137,-19.907075731936995,0.0010771424285925784]
[1500,0.4,-6.502290170873972,-16.25572542718493,0.0001980919025132841]
[2000,0.454,-6.214608098422191,-13.68856409344095,3.112505223663365e-05]
[4000,0.631,-5.521460917862246,-8.750334259686602,5.624490600443066e-08]
[6000,0.781,-5.115995809754082,-6.550570819147352,2.2205739048005327e-10]
[8000,0.917,-4.8283137373023015,-5.265336681900002,1.3566493364516204e-12]
[10000,1.04,-4.605170185988091,-4.42804825575778,1.3002176504707864e-14]

{"sheet":"Teplota","index":2,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Dioda 1N4148 při 1mA"]
[]
[]
["t [DEG]","Uf [mV]"]
[22.5,598]
[26,591]
[27,589]
[29,585]
[30,583]
[31,581]
[34,575]
[36,571]
[38,567]
[39,565]
[40,563]
[41,561]
[42,559]
[43,557]
[44,555]
[45,553]
[46,551]
[47,549]
[48,547]
[49,545]
[50,542]
[51,540]
[52,538]
[53,536]
[54,534]
[55,532]
[56,530]
[57,529,"X"]
[58,526]
[59,524]
[60,522]
[61,520]
[62,519,"X"]
[63,516]
[64,514]
[65,512]
[66,510]
[67,508]
[68,506]
[69,504]
[70,502]
[71,500]
[72,498]
[73,496]
[74,493]
[75,491]
[76,489]
[77,487]
[78,485]
[79,483]
[80,481]
[81,480]
[82,478]
[83,476]
[84,474]
[85,472]
[86,469]
[89,462]

{"sheet":"Teplota - regrese","index":3,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["VÝSLEDEK"]
[]
["Regresní statistika"]
["Násobné R",0.9999354600299823]
["Hodnota spolehlivosti R",0.9998709242253725]
["Nastavená hodnota spolehlivosti R",0.9998684888333984]
["Chyba stř. hodnoty",0.396102015827367]
["Pozorování",55]
[]
["ANOVA"]
[null,"Rozdíl","SS","MS","F","Významnost F"]
["Regrese",1,64415.3208328684,64415.3208328684,410558.519884181,9.444224717074979e-105]
["Rezidua",53,8.315530767952694,0.15689680694250366]
["Celkem",54,64423.63636363635]
[]
[null,"Koeficienty","Chyba stř. hodnoty","t stat","Hodnota P","Dolní 95%","Horní 95%","Dolní 95,0%","Horní 95,0%"]
["Hranice",644.1129960962436,0.18674536091581845,3449.1512556855346,1.7071244352946459e-143,643.7384325137964,644.4875596786908,643.7384325137964,644.4875596786908]
["Soubor X 1",-2.0326236213677347,0.003172264811125285,-640.7484060722882,9.444224717076495e-105,-2.0389863757960054,-2.026260866939464,-2.0389863757960054,-2.026260866939464]
[]
[]
[]
["REZIDUA"]
[]
["Pozorování","Očekávaná Y","Rezidua"]
[1,598.3789646154696,-0.3789646154696129]
[2,591.2647819406825,-0.2647819406824965]
[3,589.2321583193147,-0.23215831931474895]
[4,585.1669110765793,-0.16691107657925386]
[5,583.1342874552115,-0.1342874552115063]
[6,581.1016638338438,-0.10166383384375877]
[7,575.0037929697406,-0.0037929697406298146]
[8,570.9385457270051,0.06145427299486528]
[9,566.8732984842696,0.12670151573036037]
[10,564.8406748629019,0.15932513709810792]
[11,562.8080512415343,0.19194875846574178]
[12,560.7754276201665,0.22457237983348932]
[13,558.7428039987988,0.25719600120123687]
[14,556.710180377431,0.2898196225689844]
[15,554.6775567560633,0.32244324393673196]
[16,552.6449331346955,0.3550668653044795]
[17,550.6123095133278,0.38769048667222705]
[18,548.57968589196,0.4203141080399746]
[19,546.5470622705923,0.45293772940772214]
[20,544.5144386492245,0.4855613507754697]
[21,542.4818150278569,-0.48181502785689645]
[22,540.4491914064891,-0.4491914064891489]
[23,538.4165677851214,-0.41656778512140136]
[24,536.3839441637537,-0.3839441637536538]
[25,534.3513205423859,-0.35132054238590626]
[26,532.3186969210182,-0.3186969210181587]
[27,530.2860732996504,-0.2860732996504112]
[28,528.2534496782828,0.7465503217172227]
[29,526.220826056915,-0.22082605691502977]
[30,524.1882024355473,-0.18820243554728222]
[31,522.1555788141795,-0.15557881417953467]
[32,520.1229551928118,-0.12295519281178713]
[33,518.090331571444,0.9096684285559604]
[34,516.0577079500763,-0.057707950076292036]
[35,514.0250843287085,-0.02508432870854449]
[36,511.9924607073408,0.007539292659203056]
[37,509.9598370859731,0.04016291402689376]
[38,507.92721346460536,0.0727865353946413]
[39,505.89458984323767,0.10541015676233201]
[40,503.8619662218699,0.13803377813007955]
[41,501.8293426005022,0.1706573994978271]
[42,499.7967189791344,0.20328102086557465]
[43,497.7640953577667,0.2359046422333222]
[44,495.73147173639893,0.26852826360106974]
[45,493.69884811503124,-0.6988481150312396]
[46,491.6662244936635,-0.666224493663492]
[47,489.63360087229574,-0.6336008722957445]
[48,487.60097725092805,-0.6009772509280538]
[49,485.5683536295603,-0.5683536295603062]
[50,483.53573000819256,-0.5357300081925587]
[51,481.5031063868248,-0.5031063868248111]
[52,479.47048276545706,0.5295172345429364]
[53,477.4378591440893,0.562140855910684]
[54,475.4052355227216,0.5947644772783747]
[55,473.3726119013539,0.6273880986461222]