{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Реестр отгрузок","ввод данных","За день"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"comments":1,"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":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,13,1,13],[0,12,1,12],[0,15,1,15],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,5],[0,10,1,10],[0,11,1,11],[0,14,1,14],[16,0,17,0],[14,0,15,0],[11,0,13,0],[8,0,10,0],[24,0,27,0],[22,0,23,0],[18,0,19,0],[4,0,5,0],[2,0,3,0],[20,0,21,0]]}
["Дата отгрузки","Грузоотправитель","Направление","номер ГМ",null,null,null,"Длинна","Ширина","Высота","Пломба","Перевозчик"]
[null,null,null,null,"кг","м3"]
["2022-05-20","Ессентуки","Ростов","G3340",39.984000000000002,{"$f":"H3*I3*J3","v":0.31185000000000002},null,0.63,0.55000000000000004,0.9]
[null,"Ессентуки","Ростов","G3341",0.67,9.9900000000000006E-3,null,0.3,0.37,0.09]
["2022-05-21","Ессентуки","Ростов","G3346",20.556000000000001,0.17539799999999997,null,0.69,0.62,0.41]
[null,"Ессентуки","Ростов","G3347",1.607,2.0832E-2,null,0.31,0.28000000000000003,0.24]
["2022-05-22","Ессентуки","Ростов","G3354",1.1499999999999999,2.8799999999999999E-2,null,0.4,0.3,0.24]
["2022-05-23","Ессентуки","Ростов","G3362",17.96,0.15000000000000002,null,0.5,0.4,0.75]
["2022-05-24","Ессентуки","Ставрополь","G3367",0.184,1.4400000000000001E-2,null,0.4,0.08,0.45]
[null,"Ессентуки","Ростов","G3368",28.875,0.18559999999999999,null,0.57999999999999996,0.4,0.8]
[null,"Ессентуки","Ростов","G3369",6.0179999999999998,2.1419999999999998E-2,null,0.35,0.34,0.18]
["2022-05-25","Ессентуки","Ростов","G3372",69.38,0.61439999999999995,null,1.2,0.8,0.64]
[null,"Ессентуки","Махачкала","G3374",1.4830000000000001,1.2236000000000002E-2,null,0.38,0.23,0.14000000000000001]
[null,"Ессентуки","Ставрополь","G3375",0.36,6.3839999999999999E-3,null,0.38,0.21,0.08]
["2022-05-26","Ессентуки","Ростов","G3381",78.400000000000006,0.64319999999999999,null,1.2,0.8,0.67]
[null,"Ессентуки","Ростов","G3384",0.08,8.0000000000000019E-3,null,0.05,0.4,0.4]
["2022-05-27","Ессентуки","Ростов","G3392",28.209,0.216,null,0.6,0.6,0.6]
[null,"Ессентуки","Ростов","G3393",1.92,3.2000000000000001E-2,null,0.4,0.16,0.5]
["2022-05-28","Ессентуки","Ростов","G3401",32.874000000000002,0.432,null,1.2,0.8,0.45]
[null,"Ессентуки","Ростов","G3402",0.40500000000000003,1.5E-3,null,0.25,0.2,0.03]
["2022-05-29","Ессентуки","Ростов","G3409",44.304000000000002,0.51839999999999997,null,1.2,0.8,0.54]
[null,"Ессентуки","Ростов","G3411",0.08,3.5700000000000003E-3,null,0.34,0.21,0.05]
["2022-05-30","Ессентуки","Ростов","G3415",3,5.5E-2,null,0.5,0.44,0.25]
[null,"Ессентуки","Ростов","G3418",4.95,4.6920000000000003E-2,null,0.46,0.17,0.6]
["2022-05-31","Ессентуки","Ростов","G3424",29.292999999999999,0.255,null,0.6,0.5,0.85]
[null,"Ессентуки","Ростов","G3425",0.36,7.559999999999999E-3,null,0.05,0.36,0.42]
[null,"Ессентуки","Махачкала","G3426",12.7,0.25,null,0.5,0.5,1]
[null,"Ессентуки","Ставрополь","G3427",7.65,0.10640000000000001,null,0.4,0.38,0.7]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,{"$f":"H30*I30*J30","v":0}]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,{"$f":"H94*I94*J94","v":0}]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]
[null,"Ессентуки",null,"G",null,0]

{"sheet":"ввод данных","index":1,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,2,5,2],[4,3,4,8],[4,9,5,9],[4,10,4,13],[7,0,8,0],[10,0,11,0]]}
[]
[]
[]
[]
["дата",null,"номер паллеты","ВГХ один из показателей",null,null,null,null,null,"пломба","итого"]
[null,"вид упаковки",null,"Вес","Объем","Стоимость","Длинна","Ширина","Высота",null,"мест/паллет","вес нетто","Объем","Стоимость"]
["2022-05-31","Мешок","G3415",3,{"$f":"G7*H7*I7","v":5.5E-2},null,0.5,0.44,0.25,null,{"$f":"COUNT(D7:D13)","v":2},{"$f":"SUM(D7:D13)","v":7.95},{"$f":"SUM(E7:E13)","v":0.10192000000000001},{"$f":"SUM(F7:F13)","v":0}]
["время прибытия","Мешок","G3418",4.95,4.6920000000000003E-2,null,0.46,0.17,0.6]
[]
["07:50:00"]
["время убытия"]
[]
["08:10:00"]

{"sheet":"За день","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Дата отгрузки",{"$f":"'ввод данных'!$A$7","v":"2022-05-31"}]
[null,null,null,"Направление","КГ.","Обьем м3"]
[null,null,null,"Ростов",29.292999999999999,0.26256000000000002]
[null,null,null,"Ставрополь",12.7,0.25]
[null,null,null,"Махачкала",7.65,0.10640000000000001]