{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["шум"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":4,"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":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,6,0,8],[3,10,10,10],[21,14,21,16],[21,17,21,19]]}
["Время, час","Время, %","Уровень шума. дБ","шум с поправкой","разница","наибольшее из 2х","поправка",null,null,"Эквивалент","Эквивалентный уровень шума","время, часы","время, %"]
[0.4,{"$f":"IF(ISBLANK(A2),1,VLOOKUP(A2,$L$2:$M$21,2,0))","v":5},76,{"$f":"LOG($B2/100)*10+$C2","v":62.989700043360187},null,null,null,null,null,null,null,8,100]
[0.8,{"$f":"IF(ISBLANK(A3),1,VLOOKUP(A3,$L$2:$M$21,2,0))","v":10},87,{"$f":"LOG($B3/100)*10+$C3","v":77},{"$f":"ABS($D$2-$D$3)","v":14.010299956639813},{"$f":"MAX(D2:D3)","v":77},{"$f":"IF(AND(E3<=0.4,E3<=0.4),\"3\",IF(AND(E3<=1.4,E3<=1.4),\"2,5\",IF(AND(E3<=2.4,E3<=2.4),\"2,2\",IF(AND(E3<=3.4,E3<=3.4),\"1,8\",IF(AND(E3<=4.4,E3<=4.4),\"1,5\",IF(AND(E3<=5.4,E3<=5.4),\"1,2\",IF(AND(E3<=6.4,E3<=6.4),\"1\",\"0\")))))))","v":"0"},{"$f":"IF(AND(E3<=7.4,E3<=7.4),\"0,8\",IF(AND(E3<=8.4,E3<=8.4),\"0,6\",IF(AND(E3<=9.4,E3<=9.4),\"0,5\",IF(AND(E3=10,E3=10),\"0,4\",\"0\"))))","v":"0"},{"$f":"IF(AND(E3<=6,E3<=6),G3,H3)","v":"0"},{"$f":"F3+I3","v":77},null,7.6,95]
[4,50,85,81.989700043360187,{"$f":"ABS(J3-D4)","v":4.9897000433601875},{"$f":"MAX(J3,D4)","v":81.989700043360187},{"$f":"IF(AND(E4<=0.4,E4<=0.4),\"3\",IF(AND(E4<=1.4,E4<=1.4),\"2,5\",IF(AND(E4<=2.4,E4<=2.4),\"2,2\",IF(AND(E4<=3.4,E4<=3.4),\"1,8\",IF(AND(E4<=4.4,E4<=4.4),\"1,5\",IF(AND(E4<=5.4,E4<=5.4),\"1,2\",IF(AND(E4<=6.4,E4<=6.4),\"1\",\"0\")))))))","v":"1,2"},{"$f":"IF(AND(E4<=7.4,E4<=7.4),\"0,8\",IF(AND(E4<=8.4,E4<=8.4),\"0,6\",IF(AND(E4<=9.4,E4<=9.4),\"0,5\",IF(AND(E4=10,E4=10),\"0,4\",\"0\"))))","v":"0,8"},{"$f":"IF(AND(E4<=6,E4<=6),G4,H4)","v":"1,2"},{"$f":"F4+I4","v":83.18970004336019},{"$f":"MAX($J$3:$J$21)","v":83.18970004336019},7.2,90]
[null,1,null,-20,{"$f":"ABS(J4-D5)","v":103.18970004336019},{"$f":"MAX(J4,D5)","v":83.18970004336019},{"$f":"IF(AND(E5<=0.4,E5<=0.4),\"3\",IF(AND(E5<=1.4,E5<=1.4),\"2,5\",IF(AND(E5<=2.4,E5<=2.4),\"2,2\",IF(AND(E5<=3.4,E5<=3.4),\"1,8\",IF(AND(E5<=4.4,E5<=4.4),\"1,5\",IF(AND(E5<=5.4,E5<=5.4),\"1,2\",IF(AND(E5<=6.4,E5<=6.4),\"1\",\"0\")))))))","v":"0"},"0",{"$f":"IF(AND(E5<=6,E5<=6),G5,H5)","v":"0"},{"$f":"F5+I5","v":83.18970004336019},null,6.8,85]
[null,1,null,-20,{"$f":"ABS(J5-D6)","v":103.18970004336019},{"$f":"MAX(J5,D6)","v":83.18970004336019},{"$f":"IF(AND(E6<=0.4,E6<=0.4),\"3\",IF(AND(E6<=1.4,E6<=1.4),\"2,5\",IF(AND(E6<=2.4,E6<=2.4),\"2,2\",IF(AND(E6<=3.4,E6<=3.4),\"1,8\",IF(AND(E6<=4.4,E6<=4.4),\"1,5\",IF(AND(E6<=5.4,E6<=5.4),\"1,2\",IF(AND(E6<=6.4,E6<=6.4),\"1\",\"0\")))))))","v":"0"},"0",{"$f":"IF(AND(E6<=6,E6<=6),G6,H6)","v":"0"},{"$f":"F6+I6","v":83.18970004336019},null,6.4,80,{"$f":"K4","v":83.18970004336019}]
[null,1,null,-20,{"$f":"ABS(J6-D7)","v":103.18970004336019},{"$f":"MAX(J6,D7)","v":83.18970004336019},{"$f":"IF(AND(E7<=0.4,E7<=0.4),\"3\",IF(AND(E7<=1.4,E7<=1.4),\"2,5\",IF(AND(E7<=2.4,E7<=2.4),\"2,2\",IF(AND(E7<=3.4,E7<=3.4),\"1,8\",IF(AND(E7<=4.4,E7<=4.4),\"1,5\",IF(AND(E7<=5.4,E7<=5.4),\"1,2\",IF(AND(E7<=6.4,E7<=6.4),\"1\",\"0\")))))))","v":"0"},"0",{"$f":"IF(AND(E7<=6,E7<=6),G7,H7)","v":"0"},{"$f":"F7+I7","v":83.18970004336019},null,6,75]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,5.6,70]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,5.2,65]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,4.8,60]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,4.4000000000000004,55]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,4,50]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,3.6,45]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,3.2,40]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,2.8,35]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,2.4,30]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,2,25]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,1.6,20]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,1.2,15]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,0.8,10]
[null,1,null,-20,103.18970004336019,83.18970004336019,"0","0","0",83.18970004336019,null,0.4,5]
[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,null,null,null,null,76,87,85,0.4,0.8,4,83.18970004336019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,65,49,0.4,0.4,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,59,73,1.6,1.2,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,67,68,4,0.4,0.4]
[]
[]
[null,"ЕСЛИ(И(S9=S2;S9=S2);\" \";ЕСЛИ(И(S9<=80;S9<=80);\"2\";ЕСЛИ(И(S9<=85;S9<=85);\"3,1\";ЕСЛИ(И(S9<=95;S9<=95);\"3,2\";ЕСЛИ(И(S9<=105;S9<=105);\"3,3\";ЕСЛИ(И(S9<=115;S9<=115);\"3,4\";\"4\"))))))"]