{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SPb","Price"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"SPb","index":0,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Грузополучатель","№ \nнакладной","Экспедитор","Тип а/т\nкуб.м","Фактическая отгрузка","Month","1:00:00","Погрузка начало","Погрузка конец","Общее время","Разгрузка начало","Разгрузка конец","Общее время2","Min. Время","Время к оплате","Расчетный тариф","Сумма, руб","Сумма \nбез НДС, руб","Сумма \nНДС, руб"]
["ТЦ1",1111,"ФККТ","А82","2025-01-06",{"$f":"MONTH(SPb[[#This Row],[Фактическая отгрузка]])","v":1},"01:00:00","2025-01-06T16:30:00",null,{"$f":"SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]","v":"01:30:00"},null,"2025-01-06T18:00:00",{"$f":"SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]","v":"01:30:00"},{"$f":"IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А10\",Price!$B$6,IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А15\",Price!$B$5,IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А50\",Price!$B$4,IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А82\",Price!$B$3))))","v":"08:00:00"},{"$f":"IF(SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]+SPb[[#This Row],[1:00:00]]<SPb[[#This Row],[Min. Время]],SPb[[#This Row],[Min. Время]],SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]+SPb[[#This Row],[1:00:00]])","v":"08:00:00"},{"$f":"IF(D2=Price!$A$6,Price!$C$6,IF(D2=Price!$A$5,Price!$C$5,IF(D2=Price!$A$4,Price!$C$4,IF(D2=Price!$A$3,Price!$C$3))))*(HOUR(O2)+MINUTE(O2)/60)","v":11600},{"$f":"SPb[[#This Row],[Сумма \nбез НДС, руб]]*1.2","v":13920},{"$f":"SPb[[#This Row],[Расчетный тариф]]","v":11600},{"$f":"SPb[[#This Row],[Сумма, руб]]-SPb[[#This Row],[Сумма \nбез НДС, руб]]","v":2320}]
["ТЦ2",2222,"ОРТ","А50","2025-01-06",{"$f":"MONTH(SPb[[#This Row],[Фактическая отгрузка]])","v":1},"01:00:00","2025-01-06T09:30:00",null,{"$f":"SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]","v":"02:30:00"},null,"2025-01-06T12:00:00",{"$f":"SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]","v":"02:30:00"},{"$f":"IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А10\",Price!$B$6,IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А15\",Price!$B$5,IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А50\",Price!$B$4,IF(SPb[[#This Row],[Тип а/т\nкуб.м]]=\"А82\",Price!$B$3))))","v":"07:00:00"},{"$f":"IF(SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]+SPb[[#This Row],[1:00:00]]<SPb[[#This Row],[Min. Время]],SPb[[#This Row],[Min. Время]],SPb[[#This Row],[Разгрузка конец]]-SPb[[#This Row],[Погрузка начало]]+SPb[[#This Row],[1:00:00]])","v":"07:00:00"},{"$f":"IF(D3=Price!$A$6,Price!$C$6,IF(D3=Price!$A$5,Price!$C$5,IF(D3=Price!$A$4,Price!$C$4,IF(D3=Price!$A$3,Price!$C$3))))*(HOUR(O3)+MINUTE(O3)/60)","v":8750},{"$f":"SPb[[#This Row],[Сумма \nбез НДС, руб]]*1.2","v":10500},{"$f":"SPb[[#This Row],[Расчетный тариф]]","v":8750},{"$f":"SPb[[#This Row],[Сумма, руб]]-SPb[[#This Row],[Сумма \nбез НДС, руб]]","v":1750}]

{"sheet":"Price","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"ОРТ"]
["Тип ТС","min время работы","Ставка руб\\час","Стоимость смены","Переработка руб/час","Ставка руб\\час2","Стоимость смены3","Переработка руб/час4"]
["А82","08:00:00",1450,11600,1450,1650,13200,1650]
["А50","07:00:00",1250,8750,1250,1450,10150,1450]
["А15","07:00:00",1000,7000,1000,1150,8050,1150]
["А10","06:00:00",750,4500,750,900,5400,900]