{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Лист1","Данные","Отчет","Грузоотправители","Грузополучатели","Как должно быть"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Лист1","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Месяцы","(Все)"]
[]
["Дата","№ п/п","№ ТТН.","Отправитель","Получатель","Сумма по полю Объём, м³"]
["01.июн",1,100,"База-507","Пункт М.",16.986999999999998]
["01.июн Итог за сутки",null,null,null,null,16.986999999999998]
["04.июн",2,103,"База-520","Пункт Ц.",16.997]
[null,3,102,"База-106","Пункт Ц.",16.98]
[null,4,101,"База-520","Пункт М.",16.986999999999998]
["04.июн Итог за сутки",null,null,null,null,50.963999999999999]
["09.авг",5,104,"База-106","Пункт М.",16.975999999999999]
["09.авг Итог за сутки",null,null,null,null,16.975999999999999]
["02.дек",6,105,"База-520","Пункт М.",16.992000000000001]
["02.дек Итог за сутки",null,null,null,null,16.992000000000001]
["03.дек",7,107,"База-501","Пункт М.",16.946000000000002]
[null,9,108,"База-520","Пункт М.",16.986000000000001]
[null,10,106,"База-501","Пункт Ц.",16.992999999999999]
[null,12,109,"База-507","Пункт М.",16.981999999999999]
["03.дек Итог за сутки",null,null,null,null,67.906999999999996]
["15.дек",11,110,"База-106","Пункт Ц.",16.989999999999998]
["15.дек Итог за сутки",null,null,null,null,16.989999999999998]
["26.дек",8,111,"База-106","Пункт М.",16.984999999999999]
[null,13,112,"База-1","Пункт Ц.",16.949000000000002]
["26.дек Итог за сутки",null,null,null,null,33.933999999999997]
["30.дек",14,113,"База-501","Пункт Ц.",16.986999999999998]
["30.дек Итог за сутки",null,null,null,null,16.986999999999998]
["Общий итог",null,null,null,null,237.73699999999999]

{"sheet":"Данные","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["№ п/п","Дата","№ ТТН.","Отправитель","Получатель","Объём, м³"]
[1,"2011-06-01",100,"База-507","Пункт М.",16.986999999999998]
[4,"2011-06-04",101,"База-520","Пункт М.",16.986999999999998]
[5,"2012-08-09",104,"База-106","Пункт М.",16.975999999999999]
[6,"2012-12-02",105,"База-520","Пункт М.",16.992000000000001]
[2,"2011-06-04",103,"База-520","Пункт Ц.",16.997]
[7,"2012-12-03",107,"База-501","Пункт М.",16.946000000000002]
[3,"2011-06-04",102,"База-106","Пункт Ц.",16.98]
[8,"2012-12-26",111,"База-106","Пункт М.",16.984999999999999]
[9,"2012-12-03",108,"База-520","Пункт М.",16.986000000000001]
[10,"2012-12-03",106,"База-501","Пункт Ц.",16.992999999999999]
[11,"2012-12-15",110,"База-106","Пункт Ц.",16.989999999999998]
[12,"2012-12-03",109,"База-507","Пункт М.",16.981999999999999]
[13,"2012-12-26",112,"База-1","Пункт Ц.",16.949000000000002]
[14,"2012-12-30",113,"База-501","Пункт Ц.",16.986999999999998]

{"sheet":"Отчет","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["№ п/п","Дата","№ ТТН.","Отправитель","Получатель","Объём"]
[1,"2011-06-01",100,"База-507","Пункт М.",16.986999999999998]
[2,"2011-06-04",101,"База-520","Пункт М.",16.986999999999998]
[3,"2011-06-04",103,"База-520","Пункт Ц.",16.997]
[4,"2011-06-04",102,"База-106","Пункт Ц.",16.98]
[5,"2012-08-09",104,"База-106","Пункт М.",16.975999999999999]
[6,"2012-12-02",105,"База-520","Пункт М.",16.992000000000001]
[7,"2012-12-03",107,"База-501","Пункт М.",16.946000000000002]
[8,"2012-12-03",108,"База-520","Пункт М.",16.986000000000001]
[9,"2012-12-03",106,"База-501","Пункт Ц.",16.992999999999999]
[10,"2012-12-03",109,"База-507","Пункт М.",16.981999999999999]
[11,"2012-12-15",110,"База-106","Пункт Ц.",16.989999999999998]
[12,"2012-12-26",111,"База-106","Пункт М.",16.984999999999999]
[13,"2012-12-26",112,"База-1","Пункт Ц.",16.949000000000002]
[14,"2012-12-30",113,"База-501","Пункт Ц.",16.986999999999998]

{"sheet":"Грузоотправители","index":3,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Грузоотправитель"]
["База-1"]
["База-501"]
["База-507"]
["База-520"]
["База-106"]

{"sheet":"Грузополучатели","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Грузополучатель"]
["Пункт М."]
["Пункт Ц."]

{"sheet":"Как должно быть","index":5,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[29,0,29,5],[31,0,31,4],[32,0,32,4],[16,0,16,5],[21,0,21,4],[22,0,22,5],[24,0,24,4],[25,0,25,5],[28,0,28,4],[15,0,15,4],[2,0,2,5],[4,0,4,4],[5,0,5,5],[9,0,9,4],[10,0,10,5],[12,0,12,4],[13,0,13,5]]}
[]
["№ п/п","Дата","№ ТТН.","Отправитель","Получатель","Объём"]
["2011-06-01"]
[1,"2011-06-01",100,"База-507","Пункт М.",16.986999999999998]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F4:F4)","v":16.986999999999998}]
["2011-06-04"]
[2,"2011-06-04",101,"База-520","Пункт М.",16.986999999999998]
[3,"2011-06-04",102,"База-106","Пункт Ц.",16.98]
[4,"2011-06-04",103,"База-520","Пункт Ц.",16.997]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F7:F9)","v":50.963999999999999}]
["2012-06-09"]
[5,"2012-08-09",104,"База-106","Пункт М.",16.975999999999999]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F12:F12)","v":16.975999999999999}]
["2012-12-02"]
[6,"2012-12-02",105,"База-520","Пункт М.",16.992000000000001]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F15:F15)","v":16.992000000000001}]
["2012-12-03"]
[7,"2012-12-03",107,"База-501","Пункт М.",16.946000000000002]
[8,"2012-12-03",109,"База-106","Пункт М.",16.984999999999999]
[9,"2012-12-03",108,"База-520","Пункт М.",16.986000000000001]
[10,"2012-12-03",106,"База-501","Пункт Ц.",16.992999999999999]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F18:F21)","v":67.91}]
["2012-12-15"]
[11,"2012-12-15",110,"База-106","Пункт Ц.",16.989999999999998]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F24:F24)","v":16.989999999999998}]
["2012-12-26"]
[12,"2012-12-26",111,"База-507","Пункт М.",16.981999999999999]
[13,"2012-12-26",112,"База-1","Пункт Ц.",16.949000000000002]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F27:F28)","v":33.930999999999997}]
["2012-12-30"]
[14,"2012-12-30",113,"База-501","Пункт Ц.",16.986999999999998]
["Итого засутки:",null,null,null,null,{"$f":"SUBTOTAL(9,F31:F31)","v":16.986999999999998}]
["Общий итог:",null,null,null,null,{"$f":"SUBTOTAL(9,F4:F31)","v":237.73699999999999}]