{"text_format":"1","workbook":"xlsx","n_sheets":4,"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":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,4],[2,0,4,0],[2,1,2,3],[9,0,9,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Фамилия и инициалы","Табельный номер"]
[null,null,null,1]
[]
[]
[]
[null,null,"Иванов",2]
[null,null,"Петров",3]
[null,null,"Сидоров",4]
[null,null,null,5]
[null,null,null,6]
[null,null,"Пупкин В.И.","а5"]
[null,null,null,7]

{"sheet":"заявка","index":2,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,0,9,8],[0,0,0,2],[0,5,0,8],[1,0,1,2],[1,5,1,8],[2,5,2,8],[3,5,3,8],[4,6,4,8],[5,6,5,8],[6,5,6,8],[7,5,7,8],[8,0,8,8],[42,0,42,1],[42,3,42,4],[42,6,42,8],[43,0,43,1],[10,0,10,8],[11,0,11,8],[12,3,12,5],[41,0,41,1],[41,3,41,4],[41,6,41,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"\"31\" января 2019г."]
[]
[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,"                                                                                                                                                        "]

{"sheet":"свод за день","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"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],[6,0,11,1]]}
["Номер приема",null,"Врач"]
[null,null,"фамилия, имя, отчество","табельный номер"]
[]
[1,2,3,4,5,6,7]
[null,null,"Пупкин В.И.",{"$f":"IFERROR(VLOOKUP(C5,БАЗА!C$12:D$99,2,),\"\")","v":"а5"}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C6,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C7,БАЗА!C$12:D$99,2,),\"\")","v":""},null,null,"Как сделать так, чтобы в этой таблице (свод за день) в графу табельный номер попал номер именно этого врача"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C8,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C9,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C10,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C11,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C12,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C13,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C14,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C15,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C16,БАЗА!C$12:D$99,2,),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C17,БАЗА!C$12:D$99,2,),\"\")","v":""}]