{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["обработка","Лист2","вставка"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Журнал учета и хранения диагностических карт"]
["Дата проведения\n ТО","Регистрационный\n номер диагностической\n карты","Марка и модель ТС","Рег. номер","Ф.И.О сотр-ка оператора ТО отв. за хранение д. карт","Подпись сотр-ка оператора ТО отв. за хранение д. карт"]
[{"$f":"IF(вставка!B3>0,CONCATENATE(MID(вставка!B3,5,2),\".\",VLOOKUP(MID(вставка!B3,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B3,13,4)),\"\")","v":"10.11.2019"},{"$f":"MID(вставка!J3,1,20)","v":"9235001191370010"},{"$f":"IF(вставка!F3>0,вставка!F3,\"\")","v":"ВАЗ 21041-30"},{"$f":"IF(вставка!I3>0,вставка!I3,\"\")","v":"к876ак99"},{"$f":"IF(C3=\"\",\"\",\"Рунов В. Н.\")","v":"Рунов В. Н."}]
[{"$f":"IF(вставка!B4>0,CONCATENATE(MID(вставка!B4,5,2),\".\",VLOOKUP(MID(вставка!B4,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B4,13,4)),\"\")","v":"10.11.2019"},{"$f":"MID(вставка!J4,1,20)","v":"9235001191369950"},{"$f":"IF(вставка!F4>0,вставка!F4,\"\")","v":"Volkswagen Passat"},{"$f":"IF(вставка!I4>0,вставка!I4,\"\")","v":"к876ак100"},"Рунов В. Н."]
[{"$f":"IF(вставка!B5>0,CONCATENATE(MID(вставка!B5,5,2),\".\",VLOOKUP(MID(вставка!B5,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B5,13,4)),\"\")","v":"10.11.2019"},{"$f":"MID(вставка!J5,1,20)","v":"9235001191369860"},{"$f":"IF(вставка!F5>0,вставка!F5,\"\")","v":"Opel Astra"},{"$f":"IF(вставка!I5>0,вставка!I5,\"\")","v":"к876ак101"},"Рунов В. Н."]
[{"$f":"IF(вставка!B6>0,CONCATENATE(MID(вставка!B6,5,2),\".\",VLOOKUP(MID(вставка!B6,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B6,13,4)),\"\")","v":"10.11.2019"},{"$f":"MID(вставка!J6,1,20)","v":"9235001191369750"},{"$f":"IF(вставка!F6>0,вставка!F6,\"\")","v":"Citroen C3"},{"$f":"IF(вставка!I6>0,вставка!I6,\"\")","v":"к876ак102"},"Рунов В. Н."]
[{"$f":"IF(вставка!B7>0,CONCATENATE(MID(вставка!B7,5,2),\".\",VLOOKUP(MID(вставка!B7,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B7,13,4)),\"\")","v":"10.11.2019"},{"$f":"MID(вставка!J7,1,20)","v":"9235001191369650"},{"$f":"IF(вставка!F7>0,вставка!F7,\"\")","v":"Mercedes E280"},{"$f":"IF(вставка!I7>0,вставка!I7,\"\")","v":"к876ак103"},"Рунов В. Н."]
[{"$f":"IF(вставка!B8>0,CONCATENATE(MID(вставка!B8,5,2),\".\",VLOOKUP(MID(вставка!B8,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B8,13,4)),\"\")","v":"10.11.2019"},{"$f":"MID(вставка!J8,1,20)","v":"9446001190776370"},{"$f":"IF(вставка!F8>0,вставка!F8,\"\")","v":"Cadillac CTS Coup"},{"$f":"IF(вставка!I8>0,вставка!I8,\"\")","v":"к876ак104"},{"$f":"IF(C8=\"\",\"\",\"Рунов В. Н.\")","v":"Рунов В. Н."}]
[{"$f":"IF(вставка!B549>0,CONCATENATE(MID(вставка!B549,5,2),\".\",VLOOKUP(MID(вставка!B549,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B549,13,4)),\"\")","v":""},{"$f":"MID(вставка!J549,1,20)","v":""},{"$f":"IF(вставка!F549>0,вставка!F549,\"\")","v":""},{"$f":"IF(вставка!I549>0,вставка!I549,\"\")","v":""},{"$f":"IF(C9=\"\",\"\",\"Рубанов В. Н.\")","v":""}]
[{"$f":"IF(вставка!B550>0,CONCATENATE(MID(вставка!B550,5,2),\".\",VLOOKUP(MID(вставка!B550,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B550,13,4)),\"\")","v":""},{"$f":"MID(вставка!J550,1,20)","v":""},{"$f":"IF(вставка!F550>0,вставка!F550,\"\")","v":""},{"$f":"IF(вставка!I550>0,вставка!I550,\"\")","v":""},{"$f":"IF(C10=\"\",\"\",\"Рубанов В. Н.\")","v":""}]
[{"$f":"IF(вставка!B551>0,CONCATENATE(MID(вставка!B551,5,2),\".\",VLOOKUP(MID(вставка!B551,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B551,13,4)),\"\")","v":""},{"$f":"MID(вставка!J551,1,20)","v":""},{"$f":"IF(вставка!F551>0,вставка!F551,\"\")","v":""},{"$f":"IF(вставка!I551>0,вставка!I551,\"\")","v":""},""]
[{"$f":"IF(вставка!B552>0,CONCATENATE(MID(вставка!B552,5,2),\".\",VLOOKUP(MID(вставка!B552,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B552,13,4)),\"\")","v":""},{"$f":"MID(вставка!J552,1,20)","v":""},{"$f":"IF(вставка!F552>0,вставка!F552,\"\")","v":""},{"$f":"IF(вставка!I552>0,вставка!I552,\"\")","v":""},""]
[{"$f":"IF(вставка!B553>0,CONCATENATE(MID(вставка!B553,5,2),\".\",VLOOKUP(MID(вставка!B553,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B553,13,4)),\"\")","v":""},{"$f":"MID(вставка!J553,1,20)","v":""},{"$f":"IF(вставка!F553>0,вставка!F553,\"\")","v":""},{"$f":"IF(вставка!I553>0,вставка!I553,\"\")","v":""},""]
[{"$f":"IF(вставка!B554>0,CONCATENATE(MID(вставка!B554,5,2),\".\",VLOOKUP(MID(вставка!B554,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B554,13,4)),\"\")","v":""},{"$f":"MID(вставка!J554,1,20)","v":""},{"$f":"IF(вставка!F554>0,вставка!F554,\"\")","v":""},{"$f":"IF(вставка!I554>0,вставка!I554,\"\")","v":""},""]
[{"$f":"IF(вставка!B555>0,CONCATENATE(MID(вставка!B555,5,2),\".\",VLOOKUP(MID(вставка!B555,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B555,13,4)),\"\")","v":""},{"$f":"MID(вставка!J555,1,20)","v":""},{"$f":"IF(вставка!F555>0,вставка!F555,\"\")","v":""},{"$f":"IF(вставка!I555>0,вставка!I555,\"\")","v":""},""]
[{"$f":"IF(вставка!B556>0,CONCATENATE(MID(вставка!B556,5,2),\".\",VLOOKUP(MID(вставка!B556,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B556,13,4)),\"\")","v":""},{"$f":"MID(вставка!J556,1,20)","v":""},{"$f":"IF(вставка!F556>0,вставка!F556,\"\")","v":""},{"$f":"IF(вставка!I556>0,вставка!I556,\"\")","v":""},""]
[{"$f":"IF(вставка!B557>0,CONCATENATE(MID(вставка!B557,5,2),\".\",VLOOKUP(MID(вставка!B557,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B557,13,4)),\"\")","v":""},{"$f":"MID(вставка!J557,1,20)","v":""},{"$f":"IF(вставка!F557>0,вставка!F557,\"\")","v":""},{"$f":"IF(вставка!I557>0,вставка!I557,\"\")","v":""},""]
[{"$f":"IF(вставка!B558>0,CONCATENATE(MID(вставка!B558,5,2),\".\",VLOOKUP(MID(вставка!B558,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B558,13,4)),\"\")","v":""},{"$f":"MID(вставка!J558,1,20)","v":""},{"$f":"IF(вставка!F558>0,вставка!F558,\"\")","v":""},{"$f":"IF(вставка!I558>0,вставка!I558,\"\")","v":""},""]
[{"$f":"IF(вставка!B559>0,CONCATENATE(MID(вставка!B559,5,2),\".\",VLOOKUP(MID(вставка!B559,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B559,13,4)),\"\")","v":""},{"$f":"MID(вставка!J559,1,20)","v":""},{"$f":"IF(вставка!F559>0,вставка!F559,\"\")","v":""},{"$f":"IF(вставка!I559>0,вставка!I559,\"\")","v":""},""]
[{"$f":"IF(вставка!B560>0,CONCATENATE(MID(вставка!B560,5,2),\".\",VLOOKUP(MID(вставка!B560,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B560,13,4)),\"\")","v":""},{"$f":"MID(вставка!J560,1,20)","v":""},{"$f":"IF(вставка!F560>0,вставка!F560,\"\")","v":""},{"$f":"IF(вставка!I560>0,вставка!I560,\"\")","v":""},""]
[{"$f":"IF(вставка!B561>0,CONCATENATE(MID(вставка!B561,5,2),\".\",VLOOKUP(MID(вставка!B561,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B561,13,4)),\"\")","v":""},{"$f":"MID(вставка!J561,1,20)","v":""},{"$f":"IF(вставка!F561>0,вставка!F561,\"\")","v":""},{"$f":"IF(вставка!I561>0,вставка!I561,\"\")","v":""},""]
[{"$f":"IF(вставка!B562>0,CONCATENATE(MID(вставка!B562,5,2),\".\",VLOOKUP(MID(вставка!B562,8,3),Лист2!A:B,2,0),\".\",MID(вставка!B562,13,4)),\"\")","v":""},{"$f":"MID(вставка!J562,1,20)","v":""},{"$f":"IF(вставка!F562>0,вставка!F562,\"\")","v":""},{"$f":"IF(вставка!I562>0,вставка!I562,\"\")","v":""},""]

{"sheet":"Лист2","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["янв","01"]
["фев",2]
["мар",3]
["апр",4]
["май",5]
["июн",6]
["июл",7]
["авг",8]
["сен",9]
["окт",10]
["ноя",11]
["дек",12]

{"sheet":"вставка","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"вс, 10 ноя. 2019&nbsp;г.<br><i class=\"fa fa-clock-o\"></i> 22:56:31",null,null,"ДК на Бурцева","ВАЗ 21041-30","B",null,"к876ак99",9235001191370010,"Завершена"]
[null,"вс, 10 ноя. 2019&nbsp;г.<br><i class=\"fa fa-clock-o\"></i> 22:53:40",null,null,"ДК на Бурцева","Volkswagen Passat","B",null,"к876ак100",9235001191369950,"Завершена"]
[null,"вс, 10 ноя. 2019&nbsp;г.<br><i class=\"fa fa-clock-o\"></i> 22:50:48",null,null,"ДК на Бурцева","Opel Astra","B",null,"к876ак101",9235001191369860,"Завершена"]
[null,"вс, 10 ноя. 2019&nbsp;г.<br><i class=\"fa fa-clock-o\"></i> 22:47:38",null,null,"ДК на Бурцева","Citroen C3","B",null,"к876ак102",9235001191369750,"Завершена"]
[null,"вс, 10 ноя. 2019&nbsp;г.<br><i class=\"fa fa-clock-o\"></i> 22:44:37",null,null,"ДК на Бурцева","Mercedes E280","B",null,"к876ак103",9235001191369650,"Завершена"]
[null,"вс, 10 ноя. 2019&nbsp;г.<br><i class=\"fa fa-clock-o\"></i> 22:41:50",null,null,"ОПТИМА","Cadillac CTS Coup","B",null,"к876ак104",9446001190776370,"Завершена"]