{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Скания","Мерседес","Ман","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":58,"n_cols":57,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,15,5,15],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,23,5,23],[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],[4,19,5,19],[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,40,5,40],[4,20,5,20],[4,24,5,24],[4,21,5,21],[4,22,5,22],[4,46,5,46],[4,25,5,25],[4,26,5,26],[4,27,5,27],[4,28,5,28],[4,29,5,29],[4,41,5,41],[4,31,5,31],[4,32,5,32],[4,33,5,33],[4,34,5,34],[4,35,5,35],[4,37,5,37],[4,36,5,36],[4,38,5,38],[4,39,5,39],[4,47,5,47],[4,30,5,30],[7,0,7,56],[4,54,5,54],[4,55,5,55],[4,56,5,56],[4,48,5,48],[4,49,5,49],[4,50,5,50],[4,51,5,51],[4,52,5,52],[4,53,5,53],[4,42,5,42],[4,43,5,43],[4,44,5,44],[4,45,5,45]]}
[]
["Г Р А Ф И К"]
["техобслуживания автотранспорта"]
[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()+L4","v":"2016-02-21"},{"$f":" TODAY()+M4","v":"2016-02-22"},"2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","2016-03-01","2016-03-02","2016-03-03","2016-03-04","2016-03-05","2016-03-06","2016-03-07","2016-03-08","2016-03-09","2016-03-10","2016-03-11","2016-03-12","2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19","2016-03-20","2016-03-21","2016-03-22",{"$f":" TODAY()+AQ4","v":"2016-03-23"},"2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2016-04-01","2016-04-02","2016-04-03","2016-04-04","2016-04-05","2016-04-06"]
[null,null,null,null,null,"Вид","Дата",null,null,"Вид","Дата"]
[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,46,47,48,49,50,51,52,53,54,55,56,57]
["Грузовой парк автотранспорта    L то-1 =2430км, L то-2=9720км"]
[1,"Scania P 380",20,"АА 0653 НН",{"$f":"(I9-H9)/(TODAY()-G9)","v":1000},"ТО-X","2016-02-20",157500,158500,{"$f":"NextRepear(F9,0)","v":"ТО-S"},{"$f":"ROUND(22500/E9,0)+G9","v":"2016-03-14"},{"$f":"IF(QUOTIENT((L$5-$G9)*$E9,180000)<>QUOTIENT((L$5-1-$G9)*$E9,180000),\"ТО-L\",IF(QUOTIENT((L$5-$G9)*$E9,45000)<>QUOTIENT((L$5-1-$G9)*$E9,45000),\"ТО-S\",IF(QUOTIENT((L$5-$G9)*$E9,22500)<>QUOTIENT((L$5-1-$G9)*$E9,22500),\"ТО-X\",\"\")))","v":""},{"$f":"IF(QUOTIENT((M$5-$G9)*$E9,180000)<>QUOTIENT((M$5-1-$G9)*$E9,180000),\"ТО-L\",IF(QUOTIENT((M$5-$G9)*$E9,45000)<>QUOTIENT((M$5-1-$G9)*$E9,45000),\"ТО-S\",IF(QUOTIENT((M$5-$G9)*$E9,22500)<>QUOTIENT((M$5-1-$G9)*$E9,22500),\"ТО-X\",\"\")))","v":""},"","","","","","","","","","","","","","","","","","","","","ТО-X","","","","","","","","","","","","","","","","","","","","","","ТО-S",""]
[2,"Scania P 380",20,"АА 0656 НН"]
[3,"Scania P 380",20,"АА 0657 НН"]
[4,"Scania P 380",20,"АА 0667 НН"]
[5,"Scania P 380",20,"АА 1706 МЕ"]
[6,"Scania P 380",20,"АА 3799 МС "]
[7,"Scania P 380",20,"АА 5803 МС "]
[8,"Scania P 380",20,"АА 5807 МС"]
[9,"Scania P 380",20,"АА 5812 МС "]
[10,"Scania P 380",20,"АА 5822 МС"]
[11,"Scania P 380",20,"АА 6092 МА"]
[12,"Scania P 380",20,"АА 6093 МА"]
[13,"Scania P 380",20,"АА 6094 МА"]
[14,"Scania P 380",20,"АІ 8667 ЕН"]
[15,"Scania P 380",20,"АІ 7984 ЕІ"]
[16,"Scania P 380",20,"АІ 7981 ЕІ"]
[17,"Scania P 380",20,"АІ 1437 ЕІ"]
[18,"Scania P 380",20,"АІ 6873 ЕН"]
[19,"Scania P 380",20,"АІ 1390 ЕІ"]
[20,"Scania P 380",20,"АІ 1391 ЕІ"]
[21,"Scania P 380",20,"АІ 3193 ЕІ"]
[22,"Scania P 380",20,"АІ 3194 ЕІ"]
[23,"Scania P 380",20,"АІ 7411 ЕН"]
[24,"Scania P 380",20,"АІ 6899 ЕН"]
[25,"Scania P 380",20,"АІ 6862 ЕН"]
[26,"Scania P 380",20,"АІ 7471 ЕН"]
[27,"Scania P 380",20,"АІ 7494 АЕ"]
[28,"Scania P 340",12,"АІ 9387 ВА"]
[29,"Scania P 340",12,"АІ 8395 ЕМ"]
[30,"Scania P 340",12,"АА 8462 МС"]
[31,"Scania P 340",12,"АА 8463 МС"]
[32,"Scania P 340",12,"АА 8464 МС"]
[33,"Scania P 340",12,"АА 8465 МС"]
[34,"Scania P 230",9,"AI 7450 AC"]
[35,"Scania P 230",9,"АІ 3530 ВІ"]
[36,"Scania P 230",9,"АІ 4561 СВ"]
[37,"Scania P 230",9,"АІ 2693 СК"]
[38,"Scania P 230",9,"AI 6843 BH"]
[39,"Scania P 230",9,"АІ 6637 АМ"]
[40,"Scania P 230",9,"AI 9973 CA"]
[41,"Scania P 230",9,"АІ 5681 СІ"]
[42,"Scania P 230",9,"AI 7076 BE"]
[43,"Scania P 230",9,"АІ 4896 ВС"]
[44,"Scania P 230",9,"AI 5648 BT"]
[45,"Scania P 230",9,"АА 2802 МЕ"]
[46,"Scania P 230",9,"АА 2803 МЕ"]
[47,"Scania P 230",9,"АА 2813 МЕ"]
[48,"Scania P 230",9,"АА 2814 МЕ"]
[49,"Scania P 230",9,"АА 2815 МЕ"]
[50,"Scania P 230",9,"AA 4612 MB"]

{"sheet":"Мерседес","index":1,"n_rows":21,"n_cols":58,"rows_kept":21,"cut":false,"hidden":false,"merged":[[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],[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,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,39,5,39],[4,40,5,40],[4,41,5,41],[4,42,5,42],[4,43,5,43],[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]]}
[]
["Г Р А Ф И К"]
["техобслуживания автотранспорта"]
[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":"2016-02-21"},{"$f":" TODAY()+N4","v":"2016-02-22"},"2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","2016-03-01","2016-03-02","2016-03-03","2016-03-04","2016-03-05","2016-03-06","2016-03-07","2016-03-08","2016-03-09","2016-03-10","2016-03-11","2016-03-12","2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19","2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2016-04-01","2016-04-02","2016-04-03","2016-04-04","2016-04-05","2016-04-06"]
[null,null,null,null,null,"Вид","Дата",null,null,"Вид","Дата"]
["Грузовой парк автотранспорта    L то-1 =2430км, L то-2=9720км"]
[1,"M-B  Actros 1836LS",20,"АІ 1592 ВР",{"$f":"(I8-H8)/(TODAY()-G8)","v":8.1015801354401802},"1ТО-1","2014-12-05",76534,80123,{"$f":"NextRepear(F8,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(2430/E8,0)+G8","v":"2015-10-01"},{"$f":"I8-H8","v":3589},{"$f":"FutureRepear(F8,G8,$M$5,E8)","v":""},{"$f":"FutureRepear($F$8,$G$8,N5,$E$8)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,"M-B  Actros 1836LS",20,"АІ 5765 СН",4.7782805429864252,"2ТО-1Ф","2014-12-06",4678,6790,{"$error":"#VALUE!"},{"$f":"ROUND(2430/E9,0)+G9","v":"2016-04-28"},2112,{"$f":"FutureRepear(F9,G9,$M$5,E9)","v":""},{"$f":"FutureRepear($F$9,$G$9,N5,$E$9)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,"M-B  Actros 1836LS",20,"АІ 4881 ЕА",8.1383219954648531,"3ТО-1","2014-12-07",76534,80123,{"$error":"#VALUE!"},{"$f":"ROUND(2430/E10,0)+G10","v":"2015-10-02"},3589,{"$f":"FutureRepear(F10,G10,$M$5,E10)","v":""},{"$f":"FutureRepear($F$10,$G$10,N5,$E$10)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[4,"M-B  Actros 1836LS",20,"АІ 6180 СВ",8.1568181818181813,"ТО-2","2014-12-08",76534,80123,{"$error":"#VALUE!"},{"$f":"ROUND(2430/E11,0)+G11","v":"2015-10-02"},3589,{"$f":"FutureRepear(F11,G11,$M$5,E11)","v":""},{"$f":"FutureRepear($F$11,$G$11,N5,$E$11)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[5,"M-B  Actros 1836LS",20,"АІ 4815 ЕА"]
[6,"M-B  Actros 1836LS",20,"АІ 0943 ЕА"]
[7,"M-B  Actros 1836LS",20,"АІ 0942 ЕА"]
[8,"M-B  Actros 1836LS",20,"АІ 0940 ЕА"]
[9,"M-B  Actros 2532L",12,"АІ 0947 ЕА"]
[10,"M-B  Actros 2532L",12,"АІ 0948 ЕА"]
[11,"M-B  Actros 2532L",12,"АІ 2615 СК"]
[12,"M-B  Actros 2532L",12,"АІ 4879 ЕА"]
[13,"M-B  Actros 2532L",12,"АІ 8459 СІ"]
[14,"M-B  Actros 2532L",12,"АІ 6550 СК"]

{"sheet":"Ман","index":2,"n_rows":14,"n_cols":58,"rows_kept":14,"cut":false,"hidden":false,"merged":[[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],[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,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,39,5,39],[4,40,5,40],[4,41,5,41],[4,42,5,42],[4,43,5,43],[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]]}
[]
["Г Р А Ф И К"]
["техобслуживания автотранспорта"]
[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":"2016-02-21"},{"$f":" TODAY()+N4","v":"2016-02-22"},"2016-02-23","2016-02-24","2016-02-25","2016-02-26","2016-02-27","2016-02-28","2016-02-29","2016-03-01","2016-03-02","2016-03-03","2016-03-04","2016-03-05","2016-03-06","2016-03-07","2016-03-08","2016-03-09","2016-03-10","2016-03-11","2016-03-12","2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19","2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2016-04-01","2016-04-02","2016-04-03","2016-04-04","2016-04-05","2016-04-06"]
[null,null,null,null,null,"Вид","Дата",null,null,"Вид","Дата"]
["Грузовой парк автотранспорта    L то-1 =2430км, L то-2=9720км"]
[1,"MAN TGS",20,"АІ 1401 ЕІ",{"$f":"(I8-H8)/(TODAY()-G8)","v":8.1015801354401802},"1ТО-1","2014-12-05",76534,80123,{"$f":"NextRepear(F8,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(2430/E8,0)+G8","v":"2015-10-01"},{"$f":"I8-H8","v":3589},{"$f":"FutureRepear(F8,G8,$M$5,E8)","v":""},{"$f":"FutureRepear($F$8,$G$8,N5,$E$8)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[2,"MAN TGS",20,"АІ 1402 ЕІ",4.7782805429864252,"2ТО-1Ф","2014-12-06",4678,6790,{"$error":"#VALUE!"},{"$f":"ROUND(2430/E9,0)+G9","v":"2016-04-28"},2112,{"$f":"FutureRepear(F9,G9,$M$5,E9)","v":""},{"$f":"FutureRepear($F$9,$G$9,N5,$E$9)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[3,"MAN TGS",20,"АІ 1403 ЕІ",8.1383219954648531,"3ТО-1","2014-12-07",76534,80123,{"$error":"#VALUE!"},{"$f":"ROUND(2430/E10,0)+G10","v":"2015-10-02"},3589,{"$f":"FutureRepear(F10,G10,$M$5,E10)","v":""},{"$f":"FutureRepear($F$10,$G$10,N5,$E$10)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[4,"MAN TGS",20,"АІ 1404 ЕІ",8.1568181818181813,"ТО-2","2014-12-08",76534,80123,{"$error":"#VALUE!"},{"$f":"ROUND(2430/E11,0)+G11","v":"2015-10-02"},3589,{"$f":"FutureRepear(F11,G11,$M$5,E11)","v":""},{"$f":"FutureRepear($F$11,$G$11,N5,$E$11)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[5,"MAN TGS",20,"АІ 1405 ЕІ"]
[6,"MAN TGS",20,"АІ 1406 ЕІ"]
[7,"MAN TGS",20,"АІ 1407 ЕІ"]

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