{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["с трендом","Data","Report","Лист2"],"not_rendered":{"charts":3,"images":6,"macros":1,"external_links":0,"defined_names":14,"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":"с трендом","index":0,"n_rows":58,"n_cols":22,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(L1)/L2","v":21.66350463877799},{"$f":"LINEST(E24:INDIRECT(CONCATENATE(\"e\",$P$22+25)),B24:INDIRECT(CONCATENATE(\"b\",$P$22+25)),1,1)","v":5.1089303509265042E-2},999.94604581392332]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(_xlfn.T.INV.2T(0.05,M4)<K1,\"нет тренда\",\"есть тренд\")","v":"нет тренда"},2.3583120257381828E-3,1.9695098071969775E-2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"FINV(0.05,1,M4)","v":5.3176550715787174},0.98323931402913634,4.2956583662369596E-2]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(FINV(0.05,1,M4)>L4,\"нет тренда\",\"есть тренд\")","v":"есть тренд"},469.30743323435536,8]
[null,null,null,null,null,null,null,null,null,null,null,0.86599802622694166,1.4762144639537268E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L3/(1-L3)*M4","v":469.30743323435507}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"FINV(0.05,M4+2,2)","v":19.395896723571752}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"e\",$P$22+25)","v":"e33"},null,null,"Θ",{"$f":"ABS(L1)*Q18","v":1.226143284222361}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",{"$f":"P24","v":4.4464506756511549E-2},null,null,null,"Δ/√3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ustab",{"$f":"IF(P9/P10<4/3,SQRT(SUMSQ(P9,P10)),P9/SQRT(3)+P10)","v":0.7523786619673436},null,{"$f":"P11/$E$24","v":7.5237866196734362E-4},null,{"$f":"P16/SQRT(3)","v":0.7671129593118784},{"$f":"ABS(L1)*Q18/SQRT(3)+P24","v":0.7523786619673436},{"$f":"SQRT(SUMSQ(L1*Q18/SQRT(3),P24))","v":0.70930920162434508}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ustab-",{"$f":"IF(P9/P10<4/3,SQRT(SUMSQ(P9,P10)),P9/SQRT(3)+P10)","v":0.7523786619673436},null,{"$f":"P12/$E$24","v":7.5237866196734362E-4},null,{"$f":"T11+1000","v":1000.7671129593119},{"$f":"U11+1000","v":1000.7523786619673},{"$f":"V11+1000","v":1000.7093092016244}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ustab+",{"$f":"G24/P23+(MAX(E24,M1)-MIN(E24,M1))/SQRT(3)","v":5.0845561927248685E-2},null,5.0845561927248688E-5]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"неопределенность от стабильности",null,null,null,{"$f":"ABS(L1)*Q18+P23*P24","v":1.3286786206726902},null,{"$f":"P16/E24","v":1.3286786206726901E-3}]
[null,null,null,null,null,null,null,null,null,null,null,"целевая неопределенность от нестабильности",null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,"Предполагаемый срок годности",null,null,null,2,24,{"$f":"P18*365","v":730}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q18*L1+E24","v":1001.2261432842224},{"$f":"P23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(Q18-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":0.10253533645032925}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"СКО погрешностей измерений S(ε) ",null,null,null,{"$f":"SQRT((1/(COUNT(E23:E50)-2))*SUMXMY2(E23:E50,C23:C50))","v":4.2956583662370366E-2}]
[null,null,null,"Период","результат","прогноз","ПГ"," +пг"," -пг",null,null,"число степеней свободы N-2",null,null,null,{"$f":"COUNT(E23:E49)-2","v":8},{"$f":"COUNT(E23:E50)","v":10}]
[{"$f":"IF(ISNUMBER(E23),AVERAGE($B$23:$B$42),\"\")","v":""},{"$f":"IF(ISNUMBER(E23),D23,\"\")","v":""},{"$f":"IF(ISNUMBER(E23),D23*$L$1+$M$1,\"\")","v":""},{"$f":"-D29","v":-5.2520547945205482},null,{"$f":"$E$24+$L$1*D23","v":999.7316761785554},{"$f":"$P$23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(D23-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":6.8971395425199838E-2},{"$f":"F23+G23","v":999.80064757398065},{"$f":"F23-G23","v":999.66270478313015},{"$f":"$F$24+$P$17","v":1001.5},null,"коэффициент Стьюдента t",null,null,null,{"$f":"_xlfn.T.INV.2T(0.05,COUNT($E$23:$E$45)-2)","v":2.3060041352041671},{"$f":"P23*P21","v":9.9058059559669828E-2},{"$f":"COUNT($E$23:$E$45)-2","v":8}]
[{"$f":"IF(ISNUMBER(E24),AVERAGE($B$23:$B$42),\"\")","v":6.0470319634703165},{"$f":"IF(ISNUMBER(E24),D24,\"\")","v":0},{"$f":"IF(ISNUMBER(E24),D24*$L$1+$M$1,\"\")","v":999.94604581392332},0,1000,{"$f":"$E$24+$L$1*D24","v":1000},{"$f":"$P$23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(D24-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":4.541697759721474E-2},{"$f":"F24+G24","v":1000.0454169775973},{"$f":"F24-G24","v":999.95458302240274},{"$f":"$F$24+$P$17","v":1001.5},null,"СКО построенной зависимости S(X)",null,null,null,{"$f":"$P$21*SQRT(1/COUNT($E$24:$E$42)+(Q18-AVERAGE($B$24:$B$42))^2/SUMXMY2($B$24:$B$42,$A$24:$A$42))","v":4.4464506756511549E-2},null,null,null,{"$f":"SUMXMY2($B$24:$B$42,$A$24:$A$42)","v":331.78514543066143}]
[6.0470319634703165,0.44977168949769031,999.96902433627793,0.44977168949769031,999.99584476024268,{"$f":"$E$24+$L$1*D25","v":1000.0229785223546},{"$f":"$P$23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(D25-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":4.3678487147711727E-2},1000.0666570095024,999.97930003520685,1001.5,null,null,null,null,"Σ",{"$f":"SUMXMY2($B$24:$B$42,$A$24:$A$42)","v":331.78514543066143}]
[6.0470319634703165,0.91232876712328781,999.99265605520714,0.91232876712328781,1000.0303113805458,{"$f":"$E$24+$L$1*D26","v":1000.0466102412838},4.1964226759620304E-2,1000.0885744680435,1000.0046460145242,1001.5,null,"Целевой срок годности",null,null,null,{"$f":"(SQRT(P21^2*P25*Q22^2*P23^2*P17^2-2*P21^2*P25*A24*Q22^2*ABS(L1)*P23^2*P17+((P21^2*P25*A24^2*Q22^2+P21^2*P25^2*Q22)*L1^2*P23^2-P21^4*P25*Q22*P23^4))+(P21^2*A24*Q22*P23^2-P25*Q22*ABS(L1)*P17))/(P21^2*Q22*P23^2-P25*Q22*L1^2)","v":27.042842731691138},{"$f":"P26*L1+E24","v":1001.3816000000727},{"$f":"P23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(P26-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":0.1183999999273094}]
[6.0470319634703165,2.3917808219178083,1000.0682402302619,2.3917808219178083,1000.0491338876569,1000.1221944163386,3.7099804644843755E-2,1000.1592942209835,1000.0850946116938,1001.5]
[6.0470319634703165,2.8849315068493153,1000.0934349552801,2.8849315068493153,1000.0658277456292,1000.1473891413568,3.5734652228313027E-2,1000.1831237935851,1000.1116544891286,1001.5]
[6.0470319634703165,5.2520547945205482,1000.2143696353679,5.2520547945205482,1000.1434651200428,1000.2683238214446,3.1621842032884664E-2,1000.2999456634775,1000.2367019794117,1001.5]
[6.0470319634703165,8.8356164383561637,1000.3974513038339,8.8356164383561637,1000.3803137862106,1000.4514054899106,3.4802730367223964E-2,1000.4862082202778,1000.4166027595434,1001.5]
[6.0470319634703165,9.3452054794520549,1000.4234858530195,9.3452054794520549,1000.407432193048,1000.4774400390962,3.6096588751951375E-2,1000.5135366278482,1000.4413434503442,1001.5]
[6.0470319634703165,11.501369863013778,1000.5336427896272,11.501369863013778,1000.5145936394214,1000.5875969757038,4.3140423475603332E-2,1000.6307373991795,1000.5444565522282,1001.5]
[6.0470319634703165,{"$f":"IF(ISNUMBER(E33),D33,\"\")","v":18.89726027397252},1000.9114936795539,18.89726027397252,1000.9629221395548,1000.9654478656306,7.6582623616785903E-2,1001.0420304892474,1000.8888652420138,1001.5]
["","","",26.298630136986223,null,1001.3435786969463,0.11450198778469529,1001.458080684731,1001.2290767091616,1001.5]
["","","",31.887671232876635,null,1001.6291189138201,0.14397752089027829,1001.7730964347104,1001.4851413929298,1001.5]
["",{"$f":"IF(ISNUMBER(E36),D36,\"\")","v":""},{"$f":"IF(ISNUMBER(E36),D36*$L$1+$M$1,\"\")","v":""},null,null,{"$f":"$E$24+$L$1*D36","v":1000},{"$f":"$P$23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(D36-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":4.541697759721474E-2},1000.0454169775973,999.95458302240274,1001.5]
["",{"$f":"IF(ISNUMBER(E37),D37,\"\")","v":""},{"$f":"IF(ISNUMBER(E37),D37*$L$1+$M$1,\"\")","v":""},null,null,{"$f":"$E$24+$L$1*D37","v":1000},{"$f":"$P$23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(D37-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":4.541697759721474E-2},1000.0454169775973,999.95458302240274,1001.5]
["","","",null,null,1000,4.541697759721474E-2,1000.0454169775973,999.95458302240274,1001.5]
["","","",null,null,1000,4.541697759721474E-2,1000.0454169775973,999.95458302240274,1001.5]
["","","",null,null,1000,4.541697759721474E-2,1000.0454169775973,999.95458302240274,1001.5]
["",{"$f":"IF(ISNUMBER(E41),D41,\"\")","v":""},{"$f":"IF(ISNUMBER(E41),D41*$L$1+$M$1,\"\")","v":""},null,null,{"$f":"$E$24+$L$1*D41","v":1000},{"$f":"$P$23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(D41-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":4.541697759721474E-2},{"$f":"F41+G41","v":1000.0454169775973},{"$f":"F41-G41","v":999.95458302240274},1001.5]
["",{"$f":"IF(ISNUMBER(E42),D42,\"\")","v":""},{"$f":"IF(ISNUMBER(E42),D42*$L$1+$M$1,\"\")","v":""},null,null,{"$f":"$E$24+$L$1*D42","v":1000},{"$f":"$P$23*$P$21*SQRT(1/COUNT($E$23:$E$42)+(D42-AVERAGE($B$23:$B$42))^2/SUMXMY2($B$23:$B$42,$A$23:$A$42))","v":4.541697759721474E-2},{"$f":"F42+G42","v":1000.0454169775973},{"$f":"F42-G42","v":999.95458302240274},1001.5]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$U$44-L44","v":18.89726027397252},18.37876712328751,17.984931506849232,16.505479452054711,16.012328767123204,13.645205479451972,10.06164383561636,9.5520547945204655,7.3958904109587422,{"$f":"$U$44-U44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0.51849315068501123,0.91232876712328781,2.3917808219178083,2.8849315068493153,5.2520547945205482,8.8356164383561602,9.3452054794520549,11.501369863013778,18.89726027397252]
[null,null,null,null,null,null,null,null,null,null,null,1000.15,1000.08,1000.09,999.95086611234308,999.97,999.85653487995717,999.61968621378935,999.59256780695205,999.48540636057862,999.03707786044515]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,1000,null,null,null,null,null,null,0,999.03707786044515]
[null,null,null,null,null,null,null,null,null,null,null,0.44977168949769031,999.99584476024268,null,null,null,null,null,null,7.3958904109587422,999.48540636057862]
[null,null,null,null,null,null,null,null,null,null,null,0.91232876712328781,1000.0303113805458,null,null,null,null,null,null,9.5520547945204655,999.59256780695205]
[null,null,null,null,null,null,null,null,null,null,null,2.3917808219178083,1000.0491338876569,null,null,null,null,null,null,10.06164383561636,999.61968621378935]
[null,null,null,null,null,null,null,null,null,null,null,2.8849315068493153,1000.0658277456292,null,null,null,null,null,null,13.645205479451972,999.85653487995717]
[null,null,null,null,null,null,null,null,null,null,null,5.2520547945205482,1000.1434651200428,null,null,null,null,null,null,16.012328767123204,999.97]
[null,null,null,null,null,null,null,null,null,null,null,8.8356164383561637,1000.3803137862106,null,null,null,null,null,null,16.505479452054711,999.95086611234308]
[null,null,null,null,null,null,null,null,null,null,null,9.3452054794520549,1000.407432193048,null,null,null,null,null,null,17.984931506849232,1000.09]
[null,null,null,null,null,null,null,null,null,null,null,11.501369863013778,1000.5145936394214,null,null,null,null,null,null,18.37876712328751,1000.08]
[null,null,null,null,null,null,null,null,null,null,null,18.89726027397252,1000.9629221395548,null,null,null,null,null,null,18.89726027397252,1000.15]
[null,null,null,null,null,null,null,null,null,null,null,22.678082191780742,1001.1610614669308]
[null,null,null,null,null,null,null,null,null,null,null,23.832876712328687,1001.2227339728028]

{"sheet":"Data","index":1,"n_rows":73,"n_cols":20,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,4,1,7]]}
["Исходные данные",null,null,null,"Предполагаемый срок годности",null,null,null,null,null,{"$f":"IF(OR(A3=\"\",B3=\"\",I1=\"\",I2=\"\"),\"Введите данные в ячейки выделенные цветом\",\"\")","v":"Введите данные в ячейки выделенные цветом"}]
["Период","Результат",null,null,"Допускаемые границы погрешности от нестабильности"]
[]
[]
[]
[null,null,null,null,"* Использованные формулы проверены на совместимость в Microsoft® Excel® для Microsoft 365 в сентябре 2022 г. Динамические массивы поддерживаются в Microsoft® Excel® c сентября 2018 г."]
[null,null,null,null,"Об оценке стабильности стандартных образцов / П.В. Мигаль [и др.] // Эталоны. Стандартные образцы. 2023. Т. 19, № 3. С. 65–75",null,null,null,null,null,null,null,null,null,null,"https://doi.org/10.20915/2077‑1177‑2023‑19‑3-65-75"]
[]
[null,null,null,null,"Примеры",null,null,"Инструкция"]
[null,null,null,null,null,null,null,"Книга состоит из трех основных листов. При запуске доступен только лист Data в котором синим выделены поля для заполнения данными:"]
[null,null,null,null,null,null,null,"А3:А100 - момент времени в котором получен результат измерений (желательно заполнять в месяцах от 0)"]
[null,null,null,null,null,null,null,"B3:B100 - результаты измерений значения аттестуемой характеристики в соответсвующие моменты времени"]
[null,null,null,null,null,null,null,"I1 - предполагаемый срок годности (в тех же единицах времени что и  данные а A2:A100)"]
[null,null,null,null,null,null,null,"I2 - допускаемые границы погрешности или целевая неопределенность от нестабильности  (в тех же единицах что и  данные в B3:B100) - выбрать из выпадающего списка"]
[null,null,null,null,null,null,null,"На листе Data приведены три основные конпки:"]
[null,null,null,null,null,null,null,"Рассчет - производит расчет характеристик стабильности СО и выводит результаты на лист Report"]
[null,null,null,null,null,null,null,"Сброс - удаляет введенные данные"]
[null,null,null,null,null,null,null,"Проверка - проверяет алгоритмы на предмет ошибок в расчетах"]
[null,null,null,null,null,null,null,"и кнопки с примерами по нажатии на которые проводится обработка данных из различных примеров"]
[null,null,null,null,null,null,null,"На листе Report продублированы указанные кнопки и добавлена еще одна:"]
[null,null,null,null,null,null,null,"Копировать диаграмму - копирует диаграмму на незащищенный лист для редактирования"]
[]
[null,null,null,null,null,null,null,"При запуске файла происходит проверка алгоритмов путем сравнения результатов расчета в этом файле с опорным набором данных полученных в PTC Mathcad"]
[null,null,null,null,null,null,null,"Если проверка не пройдена рекомендуется загрузить оригинальный файл по адресу:"]
[null,null,null,null,null,null,null,"https://uniim.ru/calculations/"]
[]
[null,null,null,null,null,null,null,"Авторы планируют наполнять этот файл другими примерами и будут благодарны за предоставленные данные экспериментов по оценке стабильности СО по адресу "]
[null,null,null,null,null,null,null,"mig@uniim.ru"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Тестовые данные "]
[null,null,null,null,null,null,null,null,"Период","Результат",24,"Период","Результат",24,"Период","Результат",24,"Период","Результат",24]
[null,null,null,null,null,null,null,null,0,8.1999999999999993,0.3,0,1000,1.5,0,0,0.2,0,0,0.2]
[null,null,null,null,null,null,null,null,1,8.34,null,0.44977168949769031,999.99584476024268,null,1,2.8000000000000004E-2,null,1,0.19]
[null,null,null,null,null,null,null,null,2,7.97,null,0.91232876712328781,1000.0303113805458,null,2,-2.3600000000000003E-2,null,2,-0.19]
[null,null,null,null,null,null,null,null,3,8.2899999999999991,null,2.3917808219178083,1000.0491338876569,null,3,-8.8000000000000578E-4,null,3,0]
[null,null,null,null,null,null,null,null,4,8.02,null,2.8849315068493153,1000.0658277456292,null,4,-3.6704000000000001E-2,null,4,0.19]
[null,null,null,null,null,null,null,null,5,8,null,5.2520547945205482,1000.1434651200428,null,5,-6.9363200000000014E-2,null,5,-0.19]
[null,null,null,null,null,null,null,null,6,8.18,null,8.8356164383561637,1000.3803137862106,null,6,-5.9490560000000012E-2,null,6,0]
[null,null,null,null,null,null,null,null,7,8.24,null,9.3452054794520549,1000.407432193048,null,7,-3.9592448000000009E-2,null,7,0.19]
[null,null,null,null,null,null,null,null,8,8.02,null,11.501369863013778,1000.5145936394214,null,8,-6.7673958400000012E-2,null,8,-0.19]
[null,null,null,null,null,null,null,null,9,8.2799999999999994,null,18.89726027397252,1000.9629221395548,null,9,-3.8139166720000013E-2,null,9,0]
[null,null,null,null,null,null,null,null,10,8.07,null,null,null,null,10,-5.6511333376000013E-2,null,10,0.19]
[null,null,null,null,null,null,null,null,11,8.1999999999999993,null,null,null,null,11,-4.5209066700800014E-2,null,11,-0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,-5.0167253360640013E-2,null,12,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,-9.2133802688512012E-2,null,13,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,-0.12970704215080964,null,14,-0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,-0.14776563372064772,null,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,-0.2482125069765182,null,16,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,-0.31657000558121456,null,17,-0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,-0.33525600446497167,null,18,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,-0.31820480357197733,null,19,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,-0.26656384285758189,null,20,-0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,-0.27725107428606555,null,21,0.12666666666666693]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,-0.25580085942885245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,-0.21664068754308197]

{"sheet":"Report","index":2,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["СКО погрешностей измерений S(ε) ",{"$f":"Лист2!AL1","v":4.2999999999999997E-2}]
["Число степеней свободы N-2",{"$f":"Лист2!Z2","v":8}]
["Коэффициент Стьюдента t",{"$f":"Лист2!AL3","v":2.2999999999999998}]
["СКО построенной зависимости S(X)",{"$f":"Лист2!AL4","v":4.4999999999999998E-2}]
["Предполагаемый срок годности  τг",{"$f":"Лист2!Z5","v":24}]
["Границы погрешности от нестабильности Δ ̂T(τг)",{"$f":"Лист2!AL7","v":1.3}]
["Стандартная неопределенность от нестабильности u(τг)",{"$f":"Лист2!AL11","v":0.71}]
["Допускаемые границы погрешности от нестабильности",{"$f":"Лист2!Z6","v":1.5}]
["Максимальный срок годности τ ̂г",{"$f":"Лист2!AL8","v":27}]
["Границы погрешности от нестабильности Δ ̂T (τ ̂г)",{"$f":"Лист2!AL9","v":1.5}]
["Стандартная неопределенность от нестабильности u(τ ̂г)",{"$f":"Лист2!AL12","v":0.8}]
[]
["Количество значащих цифр",2]

{"sheet":"Лист2","index":3,"n_rows":100,"n_cols":38,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,{"$f":"-$E$3*0.1","v":-4.4977168949769032E-2},{"$f":"F2","v":1001.5},{"$f":"G2","v":998.5},null,null,null,null,null,null,null,null,null,null,{"$f":"LINEST(B2:INDIRECT(CONCATENATE(\"b\",COUNT(B:B)+1)),A2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1)),1,1)","v":5.1089303509265042E-2},999.94604581392332,"a","b","СКО погрешностей измерений S(ε) ",null,null,null,{"$f":"S3","v":4.2956583662369596E-2},null,null,null,null,null,null,null,"Область постоения",null,{"$f":"Report!B13","v":2},{"$f":"IF(INT(LOG(Z1))=LOG(Z1),IF(INT((LOG(Z1)-$AJ$1)*-1)-1<0,0,INT((LOG(Z1)-$AJ$1)*-1)-1),IF(INT((LOG(Z1)-$AJ$1)*-1)<0,0,INT((LOG(Z1)-$AJ$1)*-1)))","v":3},{"$f":"ROUND(Z1,AK1)","v":4.2999999999999997E-2}]
[0,1000,{"$f":"IF(ISNUMBER(B2),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,{"$f":"IF(A2=\"\",MAX(IF($Z$5>$Z$8,$Z$5+$Z$5*0.1,$Z$8+$Z$8*0.1),$Z$5+$Z$5*0.1),A2)","v":0},{"$f":"IF(ISNUMBER(B2),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B2),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,2.3583120257381828E-3,1.9695098071969775E-2,"sa","sb","Число степеней свободы N-2",null,null,null,{"$f":"S4","v":8},null,null,"t",null,null,null,null,{"$f":"MAX(IF($Z$5>$Z$8,$Z$5+$Z$5*0.1,$Z$8+$Z$8*0.1),$Z$5+$Z$5*0.1)","v":29.747127004860296}]
[0.44977168949769031,999.99584476024268,{"$f":"IF(ISNUMBER(B3),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,{"$f":"IF(AND(A3=\"\",A2=\"\"),MAX(IF($Z$5>$Z$8,$Z$5+$Z$5*0.1,$Z$8+$Z$8*0.1),$Z$5+$Z$5*0.1),IF(A3=\"\",MAX($Z$5,$Z$8),A3))","v":0.44977168949769031},{"$f":"IF(ISNUMBER(B3),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B3),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,0.98323931402913634,4.2956583662369596E-2,"R","sy","Коэффициент Стьюдента t",null,null,null,{"$f":"_xlfn.T.INV.2T(0.05,Z2)","v":2.3060041352041671},{"$f":"IF(Z3<ABS(R1)/R2,\"Тренд значим\",\"Тренд незначим\")","v":"Тренд значим"},null,{"$f":"ABS(R1)/R2","v":21.66350463877799},null,null,null,null,-0.1,null,null,{"$f":"IF(INT(LOG(Z3))=LOG(Z3),IF(INT((LOG(Z3)-$AJ$1)*-1)-1<0,0,INT((LOG(Z3)-$AJ$1)*-1)-1),IF(INT((LOG(Z3)-$AJ$1)*-1)<0,0,INT((LOG(Z3)-$AJ$1)*-1)))","v":1},{"$f":"ROUND(Z3,AK3)","v":2.2999999999999998}]
[0.91232876712328781,1000.0303113805458,{"$f":"IF(ISNUMBER(B4),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,{"$f":"IF(AND(A4=\"\",A3=\"\"),MAX(IF($Z$5>$Z$8,$Z$5+$Z$5*0.1,$Z$8+$Z$8*0.1),$Z$5+$Z$5*0.1),IF(A4=\"\",MAX($Z$5,$Z$8),A4))","v":0.91232876712328781},{"$f":"IF(ISNUMBER(B2),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B2),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,469.30743323435536,8,"F","N-2","СКО построенной зависимости S(X)",null,null,null,{"$f":"Z1*SQRT(1/Z2+(Z5-AVERAGE(X))^2/Syy)","v":4.498026303945258E-2},null,"t*S(X)","S(X)","S(a)","a*τ",null,null,null,null,null,{"$f":"IF(INT(LOG(Z4))=LOG(Z4),IF(INT((LOG(Z4)-$AJ$1)*-1)-1<0,0,INT((LOG(Z4)-$AJ$1)*-1)-1),IF(INT((LOG(Z4)-$AJ$1)*-1)<0,0,INT((LOG(Z4)-$AJ$1)*-1)))","v":3},{"$f":"ROUND(Z4,AK4)","v":4.4999999999999998E-2}]
[2.3917808219178083,1000.0491338876569,{"$f":"IF(ISNUMBER(B5),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,{"$f":"IF(AND(A5=\"\",A4=\"\"),MAX(IF($Z$5>$Z$8,$Z$5+$Z$5*0.1,$Z$8+$Z$8*0.1),$Z$5+$Z$5*0.1),IF(A5=\"\",MAX($Z$5,$Z$8),A5))","v":2.3917808219178083},{"$f":"IF(ISNUMBER(B3),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B3),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,0.86599802622694166,1.4762144639537268E-2,"ssreg","ssresid","Предполагаемый срок годности",null,null,null,24,{"$f":"Z5*$R$1+$B$2","v":1001.2261432842224},{"$f":"Z1*SQRT(1/(Z2+2)+(Z5-AVERAGE(X))^2/Syy)*Z3","v":0.10253533645032742},{"$f":"AB5/Z3","v":4.4464506756510751E-2},{"$f":"R2*Z5","v":5.6599488617716388E-2},{"$f":"ABS($R$1*Z5)","v":1.226143284222361}]
[2.8849315068493153,1000.0658277456292,{"$f":"IF(ISNUMBER(B6),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,{"$f":"IF(AND(A6=\"\",A5=\"\"),MAX(IF($Z$5>$Z$8,$Z$5+$Z$5*0.1,$Z$8+$Z$8*0.1),$Z$5+$Z$5*0.1),IF(A6=\"\",MAX($Z$5,$Z$8),A6))","v":2.8849315068493153},{"$f":"IF(ISNUMBER(B4),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B4),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!E2","v":"Допускаемые границы погрешности от нестабильности"},null,null,null,1.5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(LOG(Z6))=LOG(Z6),IF(INT((LOG(Z6)-$AJ$1)*-1)-1<0,0,INT((LOG(Z6)-$AJ$1)*-1)-1),IF(INT((LOG(Z6)-$AJ$1)*-1)<0,0,INT((LOG(Z6)-$AJ$1)*-1)))","v":1},{"$f":"ROUND(Z6,AK6)","v":1.5}]
[5.2520547945205482,1000.1434651200428,{"$f":"IF(ISNUMBER(B7),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,5.2520547945205482,{"$f":"IF(ISNUMBER(B5),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B5),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Границы погрешности от нестабильности",null,null,null,{"$f":"ABS(R1)*Z5+AB5","v":1.3286786206726884},null,"t*S(X)","S(X)","S(a)","a*τ",null,null,null,null,null,{"$f":"IF(INT(LOG(Z7))=LOG(Z7),IF(INT((LOG(Z7)-$AJ$1)*-1)-1<0,0,INT((LOG(Z7)-$AJ$1)*-1)-1),IF(INT((LOG(Z7)-$AJ$1)*-1)<0,0,INT((LOG(Z7)-$AJ$1)*-1)))","v":1},{"$f":"ROUND(Z7,AK7)","v":1.3}]
[8.8356164383561637,1000.3803137862106,{"$f":"IF(ISNUMBER(B8),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,8.8356164383561637,{"$f":"IF(ISNUMBER(B6),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B6),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Максимальный срок годности",null,null,null,{"$f":"IF(V6=V11,Z14,Z13)","v":27.042842731691177},{"$f":"Z8*R1+B2","v":1001.3816000000727},{"$f":"Z1*SQRT(1/(Z2+2)+(Z8-AVERAGE(X))^2/Syy)*Z3","v":0.1183999999273075},{"$f":"AB8/Z3","v":5.1344227063506415E-2},{"$f":"R2*Z8","v":6.3775461224293714E-2},{"$f":"ABS($R$1*Z8)","v":1.3816000000726927},null,null,null,null,null,{"$f":"IF(INT(LOG(Z8))=LOG(Z8),IF(INT((LOG(Z8)-$AJ$1)*-1)-1<0,0,INT((LOG(Z8)-$AJ$1)*-1)-1),IF(INT((LOG(Z8)-$AJ$1)*-1)<0,0,INT((LOG(Z8)-$AJ$1)*-1)))","v":0},{"$f":"ROUND(Z8,AK8)","v":27}]
[9.3452054794520549,1000.407432193048,{"$f":"IF(ISNUMBER(B9),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,9.3452054794520549,{"$f":"IF(ISNUMBER(B7),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B7),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Границы погрешности от нестабильности",null,null,null,{"$f":"ABS(R1)*Z8+AB8","v":1.5000000000000002},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(LOG(Z9))=LOG(Z9),IF(INT((LOG(Z9)-$AJ$1)*-1)-1<0,0,INT((LOG(Z9)-$AJ$1)*-1)-1),IF(INT((LOG(Z9)-$AJ$1)*-1)<0,0,INT((LOG(Z9)-$AJ$1)*-1)))","v":1},{"$f":"ROUND(Z9,AK9)","v":1.5}]
[11.501369863013778,1000.5145936394214,{"$f":"IF(ISNUMBER(B10),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,11.501369863013778,{"$f":"IF(ISNUMBER(B8),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B8),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,"τ","Допускаемые границы погрешности от нестабильности",null,null,null,"Δ/2√3"]
[18.89726027397252,1000.9629221395548,{"$f":"IF(ISNUMBER(B11),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":6.0470319634703165},null,18.89726027397252,{"$f":"IF(ISNUMBER(B9),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B9),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z5","v":24},"Целевая стандартная неопределенность от нестабильности",null,null,null,{"$f":"Z7/2/SQRT(3)","v":0.3835564796559387},{"$f":"SQRT(SUMSQ(AE5/SQRT(3),AC5))","v":0.70930920162434496},null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(LOG(AA11))=LOG(AA11),IF(INT((LOG(AA11)-$AJ$1)*-1)-1<0,0,INT((LOG(AA11)-$AJ$1)*-1)-1),IF(INT((LOG(AA11)-$AJ$1)*-1)<0,0,INT((LOG(AA11)-$AJ$1)*-1)))","v":2},{"$f":"ROUND(AA11,AK11)","v":0.71}]
[null,null,{"$f":"IF(ISNUMBER(B12),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,27.042842731691177,{"$f":"IF(ISNUMBER(B10),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B10),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z8","v":27.042842731691177},"Стандартная неопределенность от нестабильности",null,null,null,{"$f":"Z9/2/SQRT(3)","v":0.43301270189221941},{"$f":"SQRT(SUMSQ(AE8/SQRT(3),AC8))","v":0.79931788610854759},null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(LOG(AA12))=LOG(AA12),IF(INT((LOG(AA12)-$AJ$1)*-1)-1<0,0,INT((LOG(AA12)-$AJ$1)*-1)-1),IF(INT((LOG(AA12)-$AJ$1)*-1)<0,0,INT((LOG(AA12)-$AJ$1)*-1)))","v":2},{"$f":"ROUND(AA12,AK12)","v":0.8}]
[null,null,{"$f":"IF(ISNUMBER(B13),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B11),Лист2!$B$2+Лист2!$Z$9,\"\")","v":1001.5},{"$f":"IF(ISNUMBER(B11),Лист2!$B$2-Лист2!$Z$9,\"\")","v":998.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER((\nSQRT(Z1^2*Syy*(Z2+2)^2*Z3^2*Z6^2-2*Z1^2*Syy*C2*(Z2+2)^2*ABS(R1)*Z3^2*Z6+((Z1^2*Syy*C2^2*(Z2+2)^2+Z1^2*Syy^2*(Z2+2))*R1^2*Z3^2-Z1^4*Syy*(Z2+2)*Z3^4))+(Z1^2*C2*(Z2+2)*Z3^2-Syy*(Z2+2)*ABS(R1)*Z6))/(Z1^2*(Z2+2)*Z3^2-Syy*(Z2+2)*R1^2)),(\nSQRT(Z1^2*Syy*(Z2+2)^2*Z3^2*Z6^2-2*Z1^2*Syy*C2*(Z2+2)^2*ABS(R1)*Z3^2*Z6+((Z1^2*Syy*C2^2*(Z2+2)^2+Z1^2*Syy^2*(Z2+2))*R1^2*Z3^2-Z1^4*Syy*(Z2+2)*Z3^4))+(Z1^2*C2*(Z2+2)*Z3^2-Syy*(Z2+2)*ABS(R1)*Z6))/(Z1^2*(Z2+2)*Z3^2-Syy*(Z2+2)*R1^2),\"0\")","v":27.042842731691177}]
[null,null,{"$f":"IF(ISNUMBER(B14),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B12),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B12),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(((SQRT(3)*SQRT(-((N+2)*Syy*(((Sx^2-Z6^2*(N+2))*Syy+AVERAGE(A2:A13)^2*(N+2)*Sx^2)*R1^2+(3*Sx^4-3*Z6^2*(N+2)*Sx^2)))))+(3*AVERAGE(A2:A13)*(N+2)*Sx^2))/(N+2)/(Syy*R1^2+3*Sx^2)),((SQRT(3)*SQRT(-((N+2)*Syy*(((Sx^2-Z6^2*(N+2))*Syy+AVERAGE(A2:A13)^2*(N+2)*Sx^2)*R1^2+(3*Sx^4-3*Z6^2*(N+2)*Sx^2)))))+(3*AVERAGE(A2:A13)*(N+2)*Sx^2))/(N+2)/(Syy*R1^2+3*Sx^2),\"\")","v":50.725914705143566},{"$f":"Z14*R1+B8","v":1002.9718654383669},{"$f":"Z1*SQRT(1/(Z2+2)+(Z14-AVERAGE(X))^2/Syy)*Z3","v":0.24498706266703868},{"$f":"AB14/Z3","v":0.10623877855507324},{"$f":"R2*Z14","v":0.1196275346657094},{"$f":"ABS($R$1*Z14)","v":2.5915516521561703}]
[null,null,{"$f":"IF(ISNUMBER(B15),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B13),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B13),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(R1)*Z14+AB14","v":2.8365387148232091},null,null,null,null,null,null,null,null,"Округление",{"$f":"AJ1","v":2}]
[null,null,{"$f":"IF(ISNUMBER(B16),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B14),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B14),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A1","v":"СКО погрешностей измерений S(ε) "},{"$f":"Z1","v":4.2956583662369596E-2},null,4.2956583662369596E-2,{"$f":"AD16/AB16","v":1},null,null,null,"Макс Х",{"$f":"MAX(E:E)","v":29.747127004860296},{"$f":"ROUNDUP(AJ16,AL16)","v":30},{"$f":"IF(INT(LOG(AJ16))=LOG(AJ16),IF(INT((LOG(AJ16)-$AJ$15)*-1)-1<0,0,INT((LOG(AJ16)-$AJ$15)*-1)-1),IF(INT((LOG(AJ16)-$AJ$15)*-1)<0,0,INT((LOG(AJ16)-$AJ$15)*-1)))","v":0}]
[null,null,{"$f":"IF(ISNUMBER(B17),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B15),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B15),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A2","v":"Число степеней свободы N-2"},{"$f":"Z2","v":8},null,8,{"$f":"AD17/AB17","v":1},null,null,null,"Макс Y",{"$f":"IF(MAX(data2)<MAX(data2,delta1),MAX(data2),MAX(data2,delta1))","v":1001.6523996855361},{"$f":"ROUNDUP(AJ17,AL17)","v":1002},{"$f":"IF(INT(LOG(AJ17))=LOG(AJ17),IF(INT((LOG(AJ17)-$AJ$15)*-1)-1<0,0,INT((LOG(AJ17)-$AJ$15)*-1)-1),IF(INT((LOG(AJ17)-$AJ$15)*-1)<0,0,INT((LOG(AJ17)-$AJ$15)*-1)))","v":0}]
[null,null,{"$f":"IF(ISNUMBER(B18),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B16),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B16),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A3","v":"Коэффициент Стьюдента t"},{"$f":"Z3","v":2.3060041352041671},null,2.3060041352041671,1,null,null,null,"Мин Y",{"$f":"IF(MIN(data3)>MIN(data3,delta2),MIN(data3),MIN(data3,delta2))","v":999.95210774978386},{"$f":"ROUNDDOWN(AJ18,AL18)","v":999},{"$f":"IF(INT(LOG(ABS(AJ18)))=LOG(ABS(AJ18)),IF(INT((LOG(ABS(AJ18))-$AJ$15)*-1)-1<0,0,INT((LOG(ABS(AJ18))-$AJ$15)*-1)-1),IF(INT((LOG(ABS(AJ18))-$AJ$15)*-1)<0,0,INT((LOG(ABS(AJ18))-$AJ$15)*-1)))","v":0}]
[null,null,{"$f":"IF(ISNUMBER(B19),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B17),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B17),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A4","v":"СКО построенной зависимости S(X)"},{"$f":"Z4","v":4.498026303945258E-2},null,4.498026303945258E-2,1]
[null,null,{"$f":"IF(ISNUMBER(B20),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B18),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B18),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A5","v":"Предполагаемый срок годности  τг"},{"$f":"Z5","v":24},null,24,1]
[null,null,{"$f":"IF(ISNUMBER(B21),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B19),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B19),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A6","v":"Границы погрешности от нестабильности Δ ̂T(τг)"},{"$f":"Z7","v":1.3286786206726884},null,1.3286786206726884,1]
[null,null,{"$f":"IF(ISNUMBER(B22),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B20),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B20),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A7","v":"Стандартная неопределенность от нестабильности u(τг)"},{"$f":"AA11","v":0.70930920162434496},null,0.70930920162434496,1]
[null,null,{"$f":"IF(ISNUMBER(B23),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B21),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B21),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A8","v":"Допускаемые границы погрешности от нестабильности"},{"$f":"Z6","v":1.5},null,1.5,1]
[null,null,{"$f":"IF(ISNUMBER(B24),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B22),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B22),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A9","v":"Максимальный срок годности τ ̂г"},{"$f":"Z8","v":27.042842731691177},null,27.042842731691177,1]
[null,null,{"$f":"IF(ISNUMBER(B25),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B23),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B23),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A10","v":"Границы погрешности от нестабильности Δ ̂T (τ ̂г)"},{"$f":"Z6","v":1.5},null,1.5,1]
[null,null,{"$f":"IF(ISNUMBER(B26),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B24),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B24),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Report!A11","v":"Стандартная неопределенность от нестабильности u(τ ̂г)"},{"$f":"AA12","v":0.79931788610854759},null,0.79931788610854759,1]
[null,null,{"$f":"IF(ISNUMBER(B27),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B25),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B25),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE16:AE26)","v":11}]
[null,null,{"$f":"IF(ISNUMBER(B28),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B26),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B26),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B29),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B27),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B27),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B30),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B28),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B28),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Период","Результат",24]
[null,null,{"$f":"IF(ISNUMBER(B31),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B29),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B29),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1000,1.5]
[null,null,{"$f":"IF(ISNUMBER(B32),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B30),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B30),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44977168949769031,999.99584476024268]
[null,null,{"$f":"IF(ISNUMBER(B33),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B31),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B31),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91232876712328781,1000.0303113805458]
[null,null,{"$f":"IF(ISNUMBER(B34),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B32),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B32),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3917808219178083,1000.0491338876569]
[null,null,{"$f":"IF(ISNUMBER(B35),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B33),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B33),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8849315068493153,1000.0658277456292]
[null,null,{"$f":"IF(ISNUMBER(B36),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B34),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B34),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2520547945205482,1000.1434651200428]
[null,null,{"$f":"IF(ISNUMBER(B37),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B35),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B35),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.8356164383561637,1000.3803137862106]
[null,null,{"$f":"IF(ISNUMBER(B38),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B36),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B36),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.3452054794520549,1000.407432193048]
[null,null,{"$f":"IF(ISNUMBER(B39),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B37),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B37),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.501369863013778,1000.5145936394214]
[null,null,{"$f":"IF(ISNUMBER(B40),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B38),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B38),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.89726027397252,1000.9629221395548]
[null,null,{"$f":"IF(ISNUMBER(B41),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B39),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B39),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B42),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B40),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B40),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B43),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B41),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B41),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B44),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B42),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B42),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B45),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B43),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B43),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B46),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B44),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B44),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B47),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B45),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B45),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B48),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B46),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B46),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B49),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B47),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B47),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B50),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B48),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B48),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B51),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B49),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B49),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B52),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B50),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B50),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B53),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B51),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B51),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B54),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B52),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B52),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B55),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B53),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B53),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B56),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B54),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B54),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B57),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B55),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B55),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B58),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B56),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B56),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B59),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B57),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B57),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B60),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B58),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B58),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B61),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B59),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B59),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B62),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B60),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B60),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B63),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B61),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B61),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B64),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B62),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B62),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B65),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B63),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B63),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B66),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B64),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B64),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B67),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B65),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B65),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B68),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B66),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B66),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B69),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B67),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B67),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B70),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,{"$f":"IF(AND(A70=\"\",A69=\"\"),MAX(IF($Z$5>$Z$8,$Z$5+$Z$5*0.1,$Z$8+$Z$8*0.1),$Z$5+$Z$5*0.1),IF(A70=\"\",MAX($Z$5,$Z$8),A70))","v":29.747127004860296},{"$f":"IF(ISNUMBER(B68),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B68),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B71),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B69),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B69),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B72),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B70),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B70),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B73),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B71),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B71),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B74),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B72),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B72),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B75),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B73),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B73),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B76),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B74),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B74),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B77),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B75),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B75),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B78),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B76),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B76),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B79),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B77),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B77),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B80),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B78),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B78),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B81),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B79),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B79),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B82),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B80),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B80),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B83),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B81),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B81),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B84),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B82),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B82),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B85),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B83),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B83),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B86),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B84),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B84),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B87),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B85),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B85),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B88),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B86),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B86),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B89),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B87),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B87),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B90),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B88),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B88),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B91),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B89),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B89),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B92),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B90),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B90),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B93),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B91),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B91),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B94),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B92),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B92),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B95),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B93),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B93),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B96),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B94),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B94),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B97),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B95),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B95),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B98),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B96),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B96),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B99),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B97),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B97),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]
[null,null,{"$f":"IF(ISNUMBER(B100),AVERAGE($A$2:INDIRECT(CONCATENATE(\"a\",COUNT(A:A)+1))),\"\")","v":""},null,29.747127004860296,{"$f":"IF(ISNUMBER(B98),Лист2!$B$2+Лист2!$Z$9,\"\")","v":""},{"$f":"IF(ISNUMBER(B98),Лист2!$B$2-Лист2!$Z$9,\"\")","v":""}]