{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Скания","Ман","Лист3"],"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":18,"n_cols":58,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,57,5,57],[4,52,5,52],[4,53,5,53],[4,54,5,54],[4,55,5,55],[4,56,5,56],[4,47,5,47],[4,48,5,48],[4,49,5,49],[4,50,5,50],[4,51,5,51],[4,42,5,42],[4,43,5,43],[4,44,5,44],[4,45,5,45],[4,46,5,46],[4,37,5,37],[4,38,5,38],[4,39,5,39],[4,40,5,40],[4,41,5,41],[4,32,5,32],[4,33,5,33],[4,34,5,34],[4,35,5,35],[4,36,5,36],[4,27,5,27],[4,28,5,28],[4,29,5,29],[4,30,5,30],[4,31,5,31],[4,22,5,22],[4,23,5,23],[4,24,5,24],[4,25,5,25],[4,26,5,26],[4,17,5,17],[4,18,5,18],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[7,0,7,11],[4,0,5,0],[4,3,5,3],[4,4,5,4],[4,5,4,6],[4,7,5,7],[4,1,5,1],[4,2,5,2],[4,9,4,10],[4,8,5,8],[4,11,5,11]]}
[]
["Г Р А Ф И К"]
["техобслуживания автотранспорта"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45]
["№  п.п.","Марка авто","Гар. №","Гос.№ авто","Средний пробег","Последнее ТО",null,"Пробег на момент проведения ТО","Фактический пробег на сегодня","Следующее ТО",null,"Пробег после последнего ТО",{"$f":" TODAY()+M4","v":"2020-04-15"},{"$f":" TODAY()+N4","v":"2020-04-16"},"2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09","2020-05-10","2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30"]
[null,null,null,null,null,"Вид","Дата",null,null,"Вид","Дата"]
[1,2,3,4,5,6,7,8,9,10,11,12]
["Грузовой парк автотранспорта    L то-1 =7000км, L то-2=14000км",null,null,null,null,null,null,null,null,null,null,null,{"$f":"FutureRepear($F8,$G8,M$5,$E8)","v":""},{"$f":"FutureRepear($F8,$G8,N$5,$E8)","v":""},"","","","","","","","","","","","","","","",{"$f":"FutureRepear($F8,$G8,AD$5,$E8)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[1,"КАМАЗ  с КМУ",3908,"Е 917 РН 777",{"$f":"(I9-H9)/(TODAY()-G9)","v":0.77611940298507465},"ТО-1","2020-02-08",126521,126573,{"$f":"NextRepear(F9,0)","v":"ТО-2"},{"$f":"IFERROR(ROUND(7000/E9,0)+G9,\"\")","v":"2044-10-18"},{"$f":"I9-H9","v":52},{"$f":"FutureRepear($F9,$G9,M$5,$E9)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,"КАМАЗ  с КМУ",4283,"М 971 ТА 777",{"$f":"(I10-H10)/(TODAY()-G10)","v":53.526315789473685},"ТО-2","2020-01-11",111463,116548,{"$f":"NextRepear(F10,0)","v":"ТО-1"},{"$f":"IFERROR(ROUND(7000/E10,0)+G10,\"\")","v":"2020-05-21"},{"$f":"I10-H10","v":5085},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","ТО-1","","","","","","","","",""]
[3,"КАМАЗ  с КМУ",4284,"С 042 ТМ 777",36.603448275862071,"ТО-2","2020-02-17",113367,115490,"ТО-1","2020-08-26",{"$f":"I11-H11","v":2123},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[4,"КАМАЗ  с КМУ",4285,"С 012 ТМ 777",80.8,"ТО-2","2020-02-25",111751,115791,{"$f":"NextRepear(F12,0)","v":"ТО-1"},"2020-05-22",4040,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","ТО-1","","","","","","","",""]
[5,"КАМАЗ  с КМУ",4286,"С 024 ТМ 777",0,"ТО-1","2020-02-19",114201,114201,"ТО-2","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[6,"КАМАЗ  с КМУ",4287,"С 059 ТМ 777",47.516129032258064,"ТО-1","2020-02-13",106059,109005,{"$f":"NextRepear(F14,0)","v":"ТО-2"},"2020-07-09",2946,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[7,"КАМАЗ  с КМУ",4288,"М 990 ТА 777",204.60655737704917,"ТО-1","2020-02-14",106059,118540,"ТО-2","2020-03-19",12481,"","","","","","","","","ТО-1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","ТО-2","","",""]
[8,"КАМАЗ  с КМУ",4289,"С 017 ТМ 777",104.63333333333334,"ТО-2","2020-02-15",70059,76337,"ТО-1","2020-04-22",6278,"","","","","","","","ТО-1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"FutureRepear($F16,$G16,BA$5,$E16)","v":""},"","","","",""]
[9,"КАМАЗ  с КМУ",4290,"С 051ТМ 777",68.592592592592595,"ТО-2","2020-02-21",111818,115522,"ТО-1","2020-06-02",3704,"","","","","","","","","","","","","","","","","",{"$f":"FutureRepear($F17,$G17,AD$5,$E17)","v":""},"","","","","","","","","","","","","","","",{"$f":"FutureRepear($F17,$G17,AT$5,$E17)","v":""},"","","","","","","","","","","",""]
[10,"КАМАЗ  с КМУ",4291,"С 371 ТМ 777",0,"ТО-2","2020-02-28",null,null,"ТО-1","",0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Ман","index":1,"n_rows":14,"n_cols":58,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,56,5,56],[4,57,5,57],[6,0,6,57],[4,50,5,50],[4,51,5,51],[4,52,5,52],[4,53,5,53],[4,54,5,54],[4,55,5,55],[4,44,5,44],[4,45,5,45],[4,46,5,46],[4,47,5,47],[4,48,5,48],[4,49,5,49],[4,38,5,38],[4,39,5,39],[4,40,5,40],[4,41,5,41],[4,42,5,42],[4,43,5,43],[4,37,5,37],[4,26,5,26],[4,27,5,27],[4,28,5,28],[4,29,5,29],[4,30,5,30],[4,31,5,31],[4,32,5,32],[4,33,5,33],[4,34,5,34],[4,35,5,35],[4,36,5,36],[4,25,5,25],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,22,5,22],[4,23,5,23],[4,24,5,24],[4,13,5,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,6],[4,7,5,7],[4,8,5,8],[4,9,4,10],[4,11,5,11],[4,12,5,12]]}
[]
["Г Р А Ф И К"]
["техобслуживания автотранспорта"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45]
["№  п.п.","Марка авто","Тоннаж","Гос.№ авто","Средний пробег","Последнее ТО",null,"Пробег на момент проведения ТО","Фактический пробег на сегодня","Следующее ТО",null,"Пробег после последнего ТО",{"$f":" TODAY()+M4","v":"2020-04-15"},{"$f":" TODAY()+N4","v":"2020-04-16"},"2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09","2020-05-10","2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30"]
[null,null,null,null,null,"Вид","Дата",null,null,"Вид","Дата"]
["Грузовой парк автотранспорта    L то-1 =2430км, L то-2=9720км"]
[1,"КАМАЗ  с КМУ",3908,"Е 917 РН 777",{"$f":"(I8-H8)/(TODAY()-G8)","v":90.328358208955223},"ТО-1","2020-02-08",126521,132573,{"$f":"IF(F8=\"\",\"\",NextRepear(F8,0))","v":"ТО-2"},{"$f":"IFERROR(ROUND(7000/E8,0)+G8,\"\")","v":"2020-04-25"},{"$f":"I8-H8","v":6052},{"$f":"FutureRepear($F8,$G8,M$5,$E8)","v":""},{"$f":"FutureRepear($F8,$G8,N$5,$E8)","v":""},"","","","","","","","","","ТО-2","","","","",{"$f":"FutureRepear($F8,$G8,AC$5,$E8)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,"КАМАЗ  с КМУ",4283,"М 971 ТА 777",{"$f":"(I9-H9)/(TODAY()-G9)","v":53.526315789473685},"ТО-2","2020-01-11",111463,116548,{"$f":"IF(F9=\"\",\"\",NextRepear(F9,0))","v":"ТО-1"},{"$f":"IFERROR(ROUND(7000/E9,0)+G9,\"\")","v":"2020-05-21"},5085,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","ТО-1","","","","","","","","",""]
[3,"КАМАЗ  с КМУ",4284,"С 042 ТМ 777",{"$f":"(I10-H10)/(TODAY()-G10)","v":36.603448275862071},"ТО-2","2020-02-17",113367,115490,"ТО-1","2020-08-26",2123,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[4,"MAN TGS",20,"АІ 1404 ЕІ",100.33774834437087,"ТО-2","2019-11-16",81347,96498,"ТО-1","2020-01-25",15151,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[5,"КАМАЗ",3908,"Е 917 РН 777",135.1044776119403,"ТО-1","2020-02-08",126521,135573,"ТО-2",{"$f":"IFERROR(ROUND(7000/E12,0)+G12,\"\")","v":"2020-03-31"},null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","ТО-1","","","","","","","",""]
[6,"MAN TGS",20,"АІ 1406 ЕІ",0,null,null,null,null,"","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[7,"MAN TGS",20,"АІ 1407 ЕІ",0,null,null,null,null,"","",null,"",{"$f":"FutureRepear($F14,$G14,N$5,$E14)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}