{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["база","спидометр"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["дата выезда","д/н","борт","гос. номер авто","спидометр на начало смены","спидометр на конец смены"]
["2017-09-01",{"$f":"A2","v":"2017-09-01"},2,"Р 736 ОС 777",138476]
["2017-09-01","2017-09-01",3,"К 055 ОУ 777",60441]
["2017-09-01","2017-09-01",11,"К 050 ОУ 777",52866]
["2017-09-01","2017-09-01",34,"В 734 ХА 777",19040]
["2017-09-01","2017-09-01",24,"М 231 УЕ 777",16896]
["2017-09-01","2017-09-01",34,"В 734 ХА 777",19158]
["2017-09-01","2017-09-01",8,"Р 877 РМ 777",128939]
["2017-09-02","2017-09-02",2,"Р 736 ОС 777",138609]
["2017-09-02","2017-09-02",33,"Е 467 НТ 777",21236]
["2017-09-02","2017-09-02",15,"С 826 РА 777",39929]
["2017-09-02","2017-09-02",14,"С 860 РА 777",50726]
["2017-09-02","2017-09-02",1,"Р 711 ОС 777 ",108812]
["2017-09-02","2017-09-02",8,"Р 877 РМ 777",129044]
["2017-09-02","2017-09-02",9,"Е 471 НТ 777",118987]
["2017-09-03","2017-09-03",21,"В 509 НР 777",64746]
["2017-09-03","2017-09-03",2,"Р 736 ОС 777",138914]
["2017-09-03","2017-09-03",4,"Е 473 НТ 777",122672]
["2017-09-03","2017-09-03",9,"Е 471 НТ 777",119206]
["2017-09-03","2017-09-03",2,"Р 736 ОС 777",139161]
["2017-09-03","2017-09-03",1,"Р 711 ОС 777 ",109003]
["2017-09-03","2017-09-03",10,"С 486 РА 777",30084]
["2017-09-04","2017-09-04",7,"Р 881 РМ 777",125394]
["2017-09-04","2017-09-04",32,"Р 742 ОС 777",50070]
["2017-09-04","2017-09-04",5,"С 057 ОУ 777",131838]
["2017-09-04","2017-09-04",27,"О 902 УК 777",17728]
["2017-09-04","2017-09-04",33,"Е 467 НТ 777",21353]
["2017-09-04","2017-09-04",14,"С 860 РА 777",51012]
["2017-09-04","2017-09-04",29,"О 909 УК 777",8912]
["2017-09-04","2017-09-04",28,"О 907 УК 777",13609]
["2017-09-04","2017-09-03",1,"Р 711 ОС 777 ",109103]

{"sheet":"спидометр","index":1,"n_rows":22,"n_cols":38,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,0,1,0],[0,1,1,1],[0,6,0,37]]}
["№","рег-номер","Последние данные",null,null,null,"ЯНВАРЬ"]
[null,null,"ПРОБЕГ             на начало дня","ПРОБЕГ             на конец дня","Общий пробег","прошлый месяц","2017-09-01","2017-09-02","2017-09-03","2017-09-04","2017-09-05","2017-09-06","2017-09-07","2017-09-08","2017-09-09","2017-09-10","2017-09-11","2017-09-12","2017-09-13","2017-09-14","2017-09-15","2017-09-16","2017-09-17","2017-09-18","2017-09-19","2017-09-20","2017-09-21","2017-09-22","2017-09-23","2017-09-24","2017-09-25","2017-09-26","2017-09-27","2017-09-28","2017-09-29","2017-09-30",{"$f":"AJ2+1","v":"2017-10-01"},"переход на след.мес."]
[1,"Р 711 ОС 777 ",{"$f":"IFERROR(LARGE(F3:AK3,2),0)","v":0},{"$f":"IFERROR(LARGE(F3:AK3,1),0)","v":111},{"$f":"SUM(G3:AK3)","v":0},111,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,{"$f":"LARGE(G3:AK3,1)","v":{"$error":"#NUM!"}}]
[2,"Р 736 ОС 777",{"$f":"IFERROR(LARGE(F4:AK4,2),0)","v":0},{"$f":"IFERROR(LARGE(F4:AK4,1),0)","v":222},0,222,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,{"$error":"#NUM!"}]
[3,"К 055 ОУ 777",0,333,0,333,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,{"$error":"#NUM!"}]
[4,"Е 473 НТ 777",0,444,0,444,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,{"$error":"#NUM!"}]
[5,"С 057 ОУ 777",0,55555,0,55555,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,{"$error":"#NUM!"}]
[7,"Р 881 РМ 777",0,666,0,666,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,{"$error":"#NUM!"}]
[8,"Р 877 РМ 777",0,44,0,44,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,{"$error":"#NUM!"}]
[9,"Е 471 НТ 777",0,155,0,155,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,{"$error":"#NUM!"}]
[10,"С 486 РА 777",0,0,0,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,{"$error":"#NUM!"}]
[11,"К 050 ОУ 777",0,0,0,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,{"$error":"#NUM!"}]
[14,"С 860 РА 777",0,0,0,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,{"$error":"#NUM!"}]
[15,"С 826 РА 777",0,0,0,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,{"$error":"#NUM!"}]
[21,"В 509 НР 777",0,0,0,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,{"$error":"#NUM!"}]
[24,"М 231 УЕ 777",0,0,0,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,{"$error":"#NUM!"}]
[27,"О 902 УК 777",0,0,0,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,{"$error":"#NUM!"}]
[28,"О 907 УК 777",0,0,0,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,{"$error":"#NUM!"}]
[29,"О 909 УК 777",0,0,0,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,{"$error":"#NUM!"}]
[32,"Р 742 ОС 777",0,0,0,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,{"$error":"#NUM!"}]
[33,"Е 467 НТ 777",0,0,0,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,{"$error":"#NUM!"}]
[34,"В 734 ХА 777",0,0,0,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,{"$error":"#NUM!"}]