{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Шапка","Заполнение шапки","Данные для заполнения"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":279,"n_cols":4,"rows_kept":279,"cut":false,"hidden":false,"merged":[[0,0,18,3],[20,0,20,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'Заполнение шапки'!G9","v":"Технический акт № XX-27-XX-XX-2017"}]
["№пп","KKS","оборудование","вид обслуживания"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"WW11D001","ЭД","т"]
[2,"WW11D002","ЭД","т"]
[3,"WW11D003","ЭД","т"]
[4,"WW11D004","ЭД","т"]
[5,"WW11D005","ЭД","т"]
[6,"WW11D006","ЭД","т"]
[7,"WW11D007","ЭД","т"]
[8,"WW11D008","ЭД","т"]
[9,"WW11D009","ЭД","т"]
[10,"WW11D010","ЭД","т"]
[11,"WW11D011","ЭД","т"]
[12,"WW11D012","ЭД","т"]
[13,"WW11D013","ЭД","т"]
[14,"WW11D014","ЭД","т"]
[15,"WW11D015","ЭД","т"]
[16,"WW11D016","Шкаф","т"]
[17,"WW11D017","ЭД","т"]
[18,"WW11D018","Шкаф","т"]
[19,"WW11D019","ЭД","т"]
[20,"WW11D020","Шкаф","т"]
[21,"WW11D021","ЭД","т"]
[22,"WW11D022","ЭД","т"]
[23,"WW11D023","ЭД","т"]
[24,"WW11D024","ЭД","т"]
[25,"WW11D025","Шкаф","т"]
[26,"WW11D026","ЭД","т"]
[27,"WW11D027","Шкаф","т"]
[28,"WW11D028","ЭД","т"]
[29,"WW11D029","Шкаф","т"]
[30,"WW11D030","ЭД","т"]
[31,"WW11D031","Шкаф","т"]
[32,"WW11D032","ЭД","т"]
[33,"WW11D033","Шкаф","т"]
[34,"WW11D034","ЭД","т"]
[35,"WW11D035","Шкаф","т"]
[36,"WW11D036","ЭД","т"]
[37,"WW11D037","Шкаф","т"]
[38,"WW11D038","ЭД","т"]
[39,"WW11D039","Шкаф","т"]
[40,"WW11D040","ЭД","т"]
[41,"WW11D041","ЭД","т"]
[42,"WW11D042","ЭД","т"]
[43,"WW11D043","ЭД","т"]
[44,"WW11D044","ЭД","т"]
[45,"WW11D045","Шкаф","т"]
[46,"WW11D046","ЭД","т"]
[47,"WW11D047","Шкаф","т"]
[48,"WW11D048","ЭД","т"]
[49,"WW11D049","Шкаф","т"]
[50,"WW11D050","ЭД","т"]
[51,"WW11D051","Шкаф","т"]
[52,"WW11D052","ЭД","т"]
[53,"WW11D053",22,"т"]
[54,"WW11D054","Шкаф","т"]
[55,"WW11D055","ЭД","т"]
[56,"WW11D056","Шкаф","т"]
[57,"WW11D057","ЭД","т"]
[58,"WW11D058","Шкаф","т"]
[59,"WW11D059","ЭД","т"]
[60,"WW11D060","ЭД","т"]
[61,"WW11D061","Шкаф","т"]
[62,"WW11D062","ЭД","т"]
[63,"WW11D063","Шкаф","т"]
[64,"WW11D064","ЭД","т"]
[65,"WW11D065","Шкаф","т"]
[66,"WW11D066","ЭД","т"]
[67,"WW11D067","Шкаф","т"]
[68,"WW11D068","ЭД","т"]
[69,"WW11D069","Шкаф","т"]
[70,"WW11D070","ЭД","т"]
[71,"WW11D071","Шкаф","т"]
[72,"WW11D072","ЭД","т"]
[73,"WW11D073","Шкаф","т"]
[74,"WW11D074","ЭД","т"]
[75,"WW11D075","Шкаф","т"]
[76,"WW11D076","ЭД","т"]
[77,"WW11D077","Шкаф","т"]
[78,"WW11D078","ЭД","т"]
[79,"WW11D079","Шкаф","т"]
[80,"WW11D080","ЭД","т"]
[81,"WW11D081","Шкаф","т"]
[82,"WW11D082","ЭД","т"]
[83,"WW11D083","Шкаф","т"]
[84,"WW11D084","ЭД","т"]
[85,"WW11D085","ЭД","т"]
[86,"WW11D086","ЭД","т"]
[87,"WW11D087","ЭД","т"]
[88,"WW11D088","ЭД","т"]
[89,"WW11D089","ЭД","т"]
[90,"WW11D090","ЭД","т"]
[91,"WW11D091","ЭД","т"]
[92,"WW11D092","ЭД","т"]
[93,"WW11D093","ЭД","т"]
[94,"WW11D094","ЭД","т"]
[95,"WW11D095","ЭД","т"]
[96,"WW11D096","ЭД","т"]
[97,"WW11D097","ЭД","т"]
[98,"WW11D098","ЭД","т"]
[99,"WW11D099","ЭД","т"]
[100,"WW11D100","ЭД","т"]
[101,"WW11D101","ЭД","т"]
[102,"WW11D102","ЭД","т"]
[103,"WW11D103","ЭД","т"]
[104,"WW11D104","ЭД","т"]
[105,"WW11D105","ЭД","т"]
[106,"WW11D106","ЭД","т"]
[107,"WW11D107","ЭД","т"]
[108,"WW11D108","ЭД","т"]
[109,"WW11D109","ЭД","т"]
[110,"WW11D110","ЭД","т"]
[111,"WW11D111","ЭД","т"]
[112,"WW11D112","ЭД","т"]
[113,"WW11D113","ЭД","т"]
[114,"WW11D114","ЭД","т"]
[115,"WW11D115","ЭД","т"]
[116,"WW11D116","ЭД","т"]
[117,"WW11D117","ЭД","т"]
[118,"WW11D118","ЭД","т"]
[119,"WW11D119","ЭД","т"]
[120,"WW11D120","ЭД","т"]
[121,"WW11D121","ЭД","т"]
[122,"WW11D122","ЭД","т"]
[123,"WW11D123","ЭД","т"]
[124,"WW11D124","ЭД","т"]
[125,"WW11D125","ЭД","т"]
[126,"WW11D126","ЭД","т"]
[127,"WW11D127","ЭД","т"]
[128,"WW11D128","ЭД","т"]
[129,"WW11D129","ЭД","т"]
[130,"WW11D130","ЭД","т"]
[131,"WW11D131","ЭД","т"]
[132,"WW11D132","ЭД","т"]
[133,"WW11D133","ЭД","т"]
[134,"WW11D134","ЭД","т"]
[135,"WW11D135","ЭД","т"]
[136,"WW11D136","ЭД","т"]
[137,"WW11D137","ЭД","т"]
[138,"WW11D138","ЭД","т"]
[139,"WW11D139","ЭД","т"]
[140,"WW11D140","ЭД","т"]
[141,"WW11D141","ЭД","т"]
[142,"WW11D142","ЭД","т"]
[143,"WW11D143","ЭД","т"]
[144,"WW11D144","ЭД","т"]
[145,"WW11D145","ЭД","т"]
[146,"WW11D146","машина","т"]
[147,"WW11D147","пресс","т"]
[148,"WW11D148","пресс","т"]
[149,"WW11D149","вытяжной","т"]
[150,"WW11D150","стиральная","т"]
[151,"WW11D151","стиральная","т"]
[152,"WW11D152","сушильная","т"]
[153,"WW11D153","сушильная","т"]
[154,"WW11D154","швейная","т"]
[155,"WW11D155","швейная","т"]
[156,"WW11D156","швейная","т"]
[157,"WW11D157","швейная","т"]
[158,"WW11D158","швейная","т"]
[159,"WW11D159","швейная","т"]
[160,"WW11D160","швейная","т"]
[161,"WW11D161","швейная","т"]
[162,"WW11D162","ЭД","т"]
[163,"WW11D163","Шкаф","т"]
[164,"WW11D164","ЭД","к"]
[165,"WW11D165","ЭД","к"]

{"sheet":"Заполнение шапки","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Согласовано:",null,"Утверждаю:",null,"Год"]
[null,"В.В. Туполев",null,"В.В. Важный",null,2017]
[]
[null,"Должность согласователя",null,"Должность утверждающего"]
[null,{"$f":"INDEX('Данные для заполнения'!B2:B6,MATCH('Заполнение шапки'!B3,'Данные для заполнения'!A2:A6,0))","v":"Главный инженер "},null,{"$f":"INDEX('Данные для заполнения'!E2:E6,MATCH(D3,'Данные для заполнения'!D2:D6,0))","v":"Зам.главного главной конторы"}]
[null,null,null,null,null,null,{"$f":"Sheet_Page_Count(\"Шапка\")","v":7}]
[null,"Название документа (вводить здесь)",null,"Номер акта (вводить здесь)"]
[null,"Технический акт №",null,"XX-27-XX-XX-2017",null,null,{"$f":"B9&\" \"&D9","v":"Технический акт № XX-27-XX-XX-2017"}]
[]
[]
[null,"Комиссия в составе:"]
[null,"Мечтатель В.Е.",null,{"$f":"IFERROR(INDEX('Данные для заполнения'!B$10:B$24,MATCH(B13,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"Начальник заказчика"},null,null,{"$f":"IFERROR(INDEX('Данные для заполнения'!I$10:I$24,MATCH(B13,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"В.Е. Мечтатель"}]
[null,"Корнильцев А.Г.",null,{"$f":"IFERROR(INDEX('Данные для заполнения'!B$10:B$24,MATCH(B14,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"Мастер исполнитель"},null,null,{"$f":"IFERROR(INDEX('Данные для заполнения'!I$10:I$24,MATCH(B14,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"А.Г. Корнильцев"}]
[null,"Колянин К.К.",null,{"$f":"IFERROR(INDEX('Данные для заполнения'!B$10:B$24,MATCH(B15,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"Начальник исполнителя"},null,null,{"$f":"IFERROR(INDEX('Данные для заполнения'!I$10:I$24,MATCH(B15,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"К.К. Колянин"}]
[null,"Кострогин Е.Е",null,{"$f":"IFERROR(INDEX('Данные для заполнения'!B$10:B$24,MATCH(B16,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"Главный специалист участка заказчика"},null,null,{"$f":"IFERROR(INDEX('Данные для заполнения'!I$10:I$24,MATCH(B16,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"Е.Е. Кострогин"}]
[null,"Царевич А.А.",null,{"$f":"IFERROR(INDEX('Данные для заполнения'!B$10:B$24,MATCH(B17,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"Главный специалист участка заказчика"},null,null,{"$f":"IFERROR(INDEX('Данные для заполнения'!I$10:I$24,MATCH(B17,'Данные для заполнения'!A$10:A$24,0)),\"\")","v":"А.А. Царевич"}]

{"sheet":"Данные для заполнения","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Согласовано (ФИО)","Должность",null,"Утверждаю (ФИО)","Должность",null,"Год"]
["В.В. Туполев","Главный инженер ",null,"В.В. Важный","Зам.главного главной конторы",null,2017]
["С.С. Чукча","Руководитель службы ",null,null,null,null,2018]
["Е.Е.Егоренко","Руководитель службы ",null,null,null,null,2019]
[null,null,null,null,null,null,2020]
[null,null,null,null,null,null,2021]
[]
[]
["Состав комиссии","Должности"]
["Колянин К.К.","Начальник исполнителя",1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A10)","v":1},{"$f":"IF(C10-D10>0,A10,\"\")","v":""},null,null,null,"К.К. Колянин"]
["Кострогин Е.Е","Главный специалист участка заказчика",1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A11)","v":1},{"$f":"IF(C11-D11>0,A11,\"\")","v":""},null,null,null,"Е.Е. Кострогин"]
["Корнильцев А.Г.","Мастер исполнитель",1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A12)","v":1},"",null,null,null,"А.Г. Корнильцев"]
["Царевич А.А.","Главный специалист участка заказчика",1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A13)","v":1},"",null,null,null,"А.А. Царевич"]
["Мечтатель В.Е.","Начальник заказчика",1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A14)","v":1},"",null,null,null,"В.Е. Мечтатель"]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A15)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A16)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A17)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A18)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A19)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A20)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A21)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A22)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A23)","v":0},0]
[null,null,1,{"$f":"COUNTIF('Заполнение шапки'!B$13:B$17,'Данные для заполнения'!A24)","v":0},0]