{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["НАРЯД (2)","заявка","свод за день"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"НАРЯД (2)","index":0,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":true,"merged":[[12,0,12,8],[13,0,13,8],[14,0,14,8],[7,0,7,3],[7,5,7,8],[8,0,8,3],[8,5,8,8],[10,0,10,8],[11,0,11,8],[4,0,4,3],[4,5,4,8],[5,0,5,3],[5,5,5,8],[6,0,6,3],[6,5,6,8],[0,0,0,3],[0,5,0,8],[1,5,1,8],[2,0,2,1],[3,0,3,3],[3,5,3,8]]}
[]
[]
[]
["СОГЛАСОВАНО",null,null,null,null,"УТВЕРЖДАЮ"]
["Заместитель директора  УСЦ ДОСААФ",null,null,null,null,"Директор НОУ УСЦ ДОСААФ"]
["России ЮАО г. Москвы",null,null,null,null,"России ЮАО г. Москвы               "]
["____________________Ю.С. САХАРУК",null,null,null,null," _______________С. Н. КАРЕЛЬСКИЙ"]
["(воинское звание, подпись, инициал имени, фамилия)",null,null,null,null,"(воинское звание, подпись, инициал имени, фамилия)"]
["(____) НОЯБРЯ 2013 г.",null,null,null,null,"(____) НОЯБРЯ 2013 г."]
[]
["Наряд № _____"]
["на использование машин"]
[" УСЦ ДОСААФ РОССИИ ЮАО г. Москвы"]
["  (наименование воинской части, учреждения, организации)"]
["2013-11-02"]
[]
["Марка машины","Государственный регистрационный знак","Группа эксплуатации","Для каких целей назначается машина","Маршрут движения","В чье распоряжение","Время выезда","Время возвращения","Примечание"]
[1,2,3,4,5,6,7,8,9]
["ГАЗ 3302","1413ам77","уч","Служ. обесп.","г. Москва","ЛЕВШИН А.И.","8-00","18-30",23169]
["ТОЙОТА","3272ам77","уч","Служ. обесп.","г. Москва","ЛЕВШИН А.И.","8-00","18-00",23170]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["УРАЛ-4320-31","3340ам77","уч","Учеб. езда","г. Москва","ДЕМЕШКИН М.И.","8-00","18-30",22954]
["УРАЛ-4320-31","3341ам77","уч","Учеб. езда","г. Москва","ТАБАК О.Г.","8-00","18-30",{"$f":"IF(C50=0,I49,I49+1)","v":22955}]
["УРАЛ-4320-31","3344ам77","уч","Учеб. езда","г. Москва","САРКИСЯН Т.К.","8-00","18-30",22366]
["ЛАЗ 695Н","3435ам77","уч","Учеб. езда","г. Москва","ОРЛЕНКО В.Б.","8-00","18-30",21467]
["УАЗ 31519","3352ам77","уч","Служ. обесп.","г. Москва","КУЗНЕЦОВ А.Г.","8-00","18-30",22955]
[]
[]
[]
[]
[]
["УАЗ 31519","3352ам77","уч","Служ. обесп.","г. Москва","КУЗНЕЦОВ А.Г.","8-00","18-30",23024]
[]
[]
[]
[null,null,"(       )","ноября 2013г."]
[]
["КАМАЗ-4350","3527ам77     ","уч","Учеб. езда","г. Москва","КОНОВАЛОВ В.В.","8-00","18-30",22285]

{"sheet":"заявка","index":1,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[14,3,14,5],[0,0,0,2],[0,5,0,8],[1,5,1,8],[2,0,2,1],[3,0,3,2],[3,5,3,8],[12,0,12,8],[13,0,13,8],[11,0,11,8],[4,5,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[10,0,10,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Номер приема",null,null,null,null," "]
[]
[null,"УЗИ",null,null,null,"Иванов","8-00","17-00",2]
[null,"Травматолог-ортопед",null,null,null,"Петров","8-00","17-00",22]
[null,"психолог",null,null,null,"Сидоров","8-00","17-00",25]
[null,"Офтальмолог",null,null,null,"Иванов","7-00","15-00",47]
[null,"Рентгенолог",null,null,null,null,"8-00","17-00",16]
[null,"….",null,null,null,null,"8-00","17-00",84]
[null,"…..",null,null,null,"Пучков",null,null,88]
[null,null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,312,null,null,null,null,null,"                                                                                                                                                        "]
[null,null,null,null,null,null,null,null,46]
[null,"Терапевт",null,null,null,"Пупкин","16-00","21-00",58]

{"sheet":"свод за день","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,6,10,6],[0,0,2,0],[0,1,2,1],[0,2,0,3],[1,2,2,2],[1,3,2,3],[0,4,2,4],[0,5,0,6],[1,5,2,5],[1,6,2,6]]}
["Номер приема",null,"Врач"]
[null,null,"фамилия, имя, отчество","табельный номер"]
[]
[1,2,3,4,5,6,7]
[{"$f":"IF(заявка!I19=0,\" \",заявка!I19)","v":2},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E1)))&\"\"","v":"Иванов"},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E1)))&\"\"","v":"УЗИ"}]
[{"$f":"IF(заявка!I20=0,\" \",заявка!I20)","v":22},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E2)))&\"\"","v":"Петров"},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E2)))&\"\"","v":"Травматолог-ортопед"}]
[{"$f":"IF(заявка!I21=0,\" \",заявка!I21)","v":25},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E3)))&\"\"","v":"Сидоров"},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E3)))&\"\"","v":"психолог"},null,"Как сделать так, чтобы в эту таблицу (свод за день) попадали все врачи из заявки, НО  попорядку!!!!     Чтобы рентген, например, вообще не попадал в эту таблицу. "]
[{"$f":"IF(заявка!I22=0,\" \",заявка!I22)","v":47},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E4)))&\"\"","v":"Иванов"},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E4)))&\"\"","v":"Офтальмолог"}]
[{"$f":"IF(заявка!I23=0,\" \",заявка!I23)","v":16},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E5)))&\"\"","v":"Пучков"},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E5)))&\"\"","v":"….."}]
[{"$f":"IF(заявка!I24=0,\" \",заявка!I24)","v":84},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E6)))&\"\"","v":"Пупкин"},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E6)))&\"\"","v":"Терапевт"}]
[{"$f":"IF(заявка!I25=0,\" \",заявка!I25)","v":88},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E7)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E7)))&\"\"","v":""}]
[{"$f":"IF(заявка!I26=0,\" \",заявка!I26)","v":95},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E8)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E8)))&\"\"","v":""}]
[{"$f":"IF(заявка!I27=0,\" \",заявка!I27)","v":312},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E9)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E9)))&\"\"","v":""}]
[{"$f":"IF(заявка!I28=0,\" \",заявка!I28)","v":46},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E10)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E10)))&\"\"","v":""}]
[{"$f":"IF(заявка!I29=0,\" \",заявка!I29)","v":58},null,{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E11)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E11)))&\"\"","v":""}]
[{"$f":"IF(заявка!I30=0,\" \",заявка!I30)","v":" "},{"$f":"IF(заявка!I30=0,\" \",заявка!$D$15)","v":" "},{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E12)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E12)))&\"\"","v":""}]
[{"$f":"IF(заявка!I31=0,\" \",заявка!I31)","v":" "},{"$f":"IF(заявка!I31=0,\" \",заявка!$D$15)","v":" "},{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E13)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E13)))&\"\"","v":""}]
[{"$f":"IF(заявка!I32=0,\" \",заявка!I32)","v":" "},{"$f":"IF(заявка!I32=0,\" \",заявка!$D$15)","v":" "},{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E14)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E14)))&\"\"","v":""}]
[{"$f":"IF(заявка!I33=0,\" \",заявка!I33)","v":" "},{"$f":"IF(заявка!I33=0,\" \",заявка!$D$15)","v":" "},{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E15)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E15)))&\"\"","v":""}]
[{"$f":"IF(заявка!I34=0,\" \",заявка!I34)","v":" "},{"$f":"IF(заявка!I34=0,\" \",заявка!$D$15)","v":" "},{"$f":"INDEX(заявка!F:F,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E16)))&\"\"","v":""},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E16)))&\"\"","v":""}]
[{"$f":"IF(заявка!I35=0,\" \",заявка!I35)","v":" "},{"$f":"IF(заявка!I35=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I35=0,\" \",заявка!F35)","v":" "},null,{"$f":"INDEX(заявка!B:B,SMALL(IF(заявка!$F$19:$F$99=\"\",99,ROW(заявка!F$19:F$99)),ROW(E17)))&\"\"","v":""}]
[{"$f":"IF(заявка!I36=0,\" \",заявка!I36)","v":" "},{"$f":"IF(заявка!I36=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I36=0,\" \",заявка!F36)","v":" "},null,{"$f":"IF(заявка!I36=0,\" \",заявка!B36)","v":" "}]
[{"$f":"IF(заявка!I37=0,\" \",заявка!I37)","v":" "},{"$f":"IF(заявка!I37=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I37=0,\" \",заявка!F37)","v":" "},null,{"$f":"IF(заявка!I37=0,\" \",заявка!B37)","v":" "}]
[{"$f":"IF(заявка!I38=0,\" \",заявка!I38)","v":" "},{"$f":"IF(заявка!I38=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I38=0,\" \",заявка!F38)","v":" "},null,{"$f":"IF(заявка!I38=0,\" \",заявка!B38)","v":" "}]
[{"$f":"IF(заявка!I39=0,\" \",заявка!I39)","v":" "},{"$f":"IF(заявка!I39=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I39=0,\" \",заявка!F39)","v":" "},null,{"$f":"IF(заявка!I39=0,\" \",заявка!B39)","v":" "}]
[{"$f":"IF(заявка!I40=0,\" \",заявка!I40)","v":" "},{"$f":"IF(заявка!I40=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I40=0,\" \",заявка!F40)","v":" "},null,{"$f":"IF(заявка!I40=0,\" \",заявка!B40)","v":" "}]
[{"$f":"IF(заявка!I41=0,\" \",заявка!I41)","v":" "},{"$f":"IF(заявка!I41=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I41=0,\" \",заявка!F41)","v":" "},null,{"$f":"IF(заявка!I41=0,\" \",заявка!B41)","v":" "}]
[{"$f":"IF(заявка!I42=0,\" \",заявка!I42)","v":" "},{"$f":"IF(заявка!I42=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I42=0,\" \",заявка!F42)","v":" "},null,{"$f":"IF(заявка!I42=0,\" \",заявка!B42)","v":" "}]
[{"$f":"IF(заявка!I43=0,\" \",заявка!I43)","v":" "},{"$f":"IF(заявка!I43=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I43=0,\" \",заявка!F43)","v":" "},null,{"$f":"IF(заявка!I43=0,\" \",заявка!B43)","v":" "}]
[{"$f":"IF(заявка!I44=0,\" \",заявка!I44)","v":" "},{"$f":"IF(заявка!I44=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I44=0,\" \",заявка!F44)","v":" "},null,{"$f":"IF(заявка!I44=0,\" \",заявка!B44)","v":" "}]
[{"$f":"IF(заявка!I45=0,\" \",заявка!I45)","v":" "},{"$f":"IF(заявка!I45=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I45=0,\" \",заявка!F45)","v":" "},null,{"$f":"IF(заявка!I45=0,\" \",заявка!B45)","v":" "}]
[{"$f":"IF(заявка!I46=0,\" \",заявка!I46)","v":" "},{"$f":"IF(заявка!I46=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I46=0,\" \",заявка!F46)","v":" "},null,{"$f":"IF(заявка!I46=0,\" \",заявка!B46)","v":" "}]
[{"$f":"IF(заявка!I47=0,\" \",заявка!I47)","v":" "},{"$f":"IF(заявка!I47=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I47=0,\" \",заявка!F47)","v":" "},null,{"$f":"IF(заявка!I47=0,\" \",заявка!B47)","v":" "}]
[{"$f":"IF(заявка!I48=0,\" \",заявка!I48)","v":" "},{"$f":"IF(заявка!I48=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I48=0,\" \",заявка!F48)","v":" "},null,{"$f":"IF(заявка!I48=0,\" \",заявка!B48)","v":" "}]
[{"$f":"IF(заявка!I49=0,\" \",заявка!I49)","v":" "},{"$f":"IF(заявка!I49=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I49=0,\" \",заявка!F49)","v":" "},null,{"$f":"IF(заявка!I49=0,\" \",заявка!B49)","v":" "}]
[{"$f":"IF(заявка!I50=0,\" \",заявка!I50)","v":" "},{"$f":"IF(заявка!I50=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I50=0,\" \",заявка!F50)","v":" "},null,{"$f":"IF(заявка!I50=0,\" \",заявка!B50)","v":" "}]
[{"$f":"IF(заявка!I51=0,\" \",заявка!I51)","v":" "},{"$f":"IF(заявка!I51=0,\" \",заявка!$D$15)","v":" "},{"$f":"IF(заявка!I51=0,\" \",заявка!F51)","v":" "},null,{"$f":"IF(заявка!I51=0,\" \",заявка!B51)","v":" "}]