{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Сводная","Заказы","Отгрузка","Поиск"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Сводная_tb[[#Totals],[Сумма заказа]]-Сводная_tb[[#Totals],[Отгружено по факту (руб.)]]","v":50000},{"$f":"Сводная_tb[[#Totals],[Отгружено по факту (руб.)]]","v":653000},{"$f":"SUM(Сводная_tb[ГОТОВЫ (руб.)])","v":0},null,null,{"$f":"SUM(Сводная_tb[На складе зд ОСТАЛОСЬ (руб.)])","v":0},{"$f":"SUM(Сводная_tb[Реализ-я из офиса и прочее])","v":0}]
["Номер наряд заказа","Дата заказа","Контрагент","Сумма заказа","Сделать  к  Дате ","Отгрузка номер","Дата отгрузки","НЕ ГОТОВЫ (руб.)","ГОТОВЫ (руб.)","Остатки С ПРЕД. МЕС И ПОКУПНОЕ","Сумма отгрузки (руб.)","Отгружено по факту (руб.)","На складе зд ОСТАЛОСЬ (руб.)","Реализ-я из офиса и прочее","Наименование изделий"]
["12.1","01.12.2024","ООО \"Смирнов\"",500000,"20.12.2024",null,null,null,null,null,null,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":500000},null,null,"ШЖЭ-3 - 9 шт"]
[null,null,"ООО \"Смирнов\"",null,null,"3-12.1","21.12.2024",null,null,null,200000,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":""},null,null,"ШЖЭ-3 - 3 шт"]
[null,null,"ООО \"Смирнов\"",null,null,"4-12.1","23.12.2024",null,null,null,300000,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":""}]
["12.4","04.12.2024","ООО \"Смирнов\"",50000,"23.12.2024",null,null,null,null,null,null,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":""},null,null,"ПЭ-4 - 1 шт"]
["12.2","02.12.2024","ИП Пупкин",50000,"21.12.2024",null,null,null,null,null,null,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":50000},null,null,"ПЭ-4 - 1 шт"]
[null,null,"ИП Пупкин",null,null,"1-12.2","22.12.2024",null,null,null,50000,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":""},null,null,"ПЭ-4 - 1 шт"]
["12.3","03.12.2024","ИП Иванов",100000,"22.12.2024",null,null,null,null,null,null,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":100000},null,null,"ПЭ-4 - 2 шт"]
[null,null,"ИП Иванов",null,null,"2-12.3","23.12.2024",null,null,null,100000,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":""},null,null,"ПЭ-4 - 2 шт"]
["12.7","07.12.2024","ИП Фомин",3000,"08.12.2024",null,null,null,null,null,null,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":3000},null,null,"Контр петля - 5 шт"]
[null,null,"ИП Фомин",null,null,"5-12.7","07.12.2024",null,null,null,3000,{"$f":"IF(AND(INDEX(K:K,ROW()+1)<>\"\",Сводная_tb[[#This Row],[Сумма отгрузки (руб.)]]=\"\"),SUM(INDEX(K:K,ROW()+1):INDEX(K:K,MATCH(\"*\",INDEX(A:A,ROW()+1):INDEX(A:A,ROW(Сводная_tb[#Totals])),)+ROW()-1)),\"\")","v":""},null,null,"Контр петля - 5 шт"]
["Итог",null,null,{"$f":"SUBTOTAL(109,Сводная_tb[Сумма заказа])","v":703000},null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Сводная_tb[Отгружено по факту (руб.)])","v":653000},null,null,{"$f":"SUBTOTAL(103,Сводная_tb[Наименование изделий])","v":9}]

{"sheet":"Заказы","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Номер наряд заказа","Дата заказа","Контрагент","Сумма заказа","Сделать  к  Дате ","НЕ ГОТОВЫ (руб.)","ГОТОВЫ (руб.)","Наименование изделий"]
["12.1","01.12.2024","ООО \"Смирнов\"",500000,"20.12.2024",null,null,"ШЖЭ-3 - 9 шт"]
["12.2","02.12.2024","ИП Пупкин",50000,"21.12.2024",null,null,"ПЭ-4 - 1 шт"]
["12.3","03.12.2024","ИП Иванов",100000,"22.12.2024",null,null,"ПЭ-4 - 2 шт"]
["12.4","04.12.2024","ООО \"Смирнов\"",50000,"23.12.2024",null,null,"ПЭ-4 - 1 шт"]
["12.5","05.12.2024","ИП Иванов",50000,"25.12.2024",null,null,"ПЭ-6 - 1 шт"]
["12.6","06.12.2024","ИП Пупкин",100000,"26.12.2024",null,null,"ШЖЭ-3 - 2 шт"]
["12.7","07.12.2024","ИП Фомин",3000,"08.12.2024",null,null,"Контр петля - 5 шт"]
["Итог",null,null,{"$f":"SUBTOTAL(109,Заказы_tb[Сумма заказа])","v":853000},null,null,null,{"$f":"SUBTOTAL(103,Заказы_tb[Наименование изделий])","v":7}]

{"sheet":"Отгрузка","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Отгрузка номер","Дата отгрузки","Контрагент","ОТГУЖЕНО ","Реализ-я из офиса и прочее","Наименование изделий","Столбец1","Столбец2"]
["1-12.2","22.12.2024","ИП Пупкин",50000,null,"ПЭ-4 - 1 шт"]
["2-12.3","23.12.2024","ИП Иванов",100000,null,"ПЭ-4 - 2 шт"]
["3-12.1","21.12.2024","ООО \"Смирнов\"",200000,null,"ШЖЭ-3 - 3 шт"]
["4-12.1","23.12.2024","ООО \"Смирнов\"",300000,null,"ШЖЭ-3 - 6 шт"]
["5-12.7","07.12.2024","ИП Фомин",3000,null,"Контр петля - 5 шт"]
["Итог",null,null,null,null,{"$f":"SUBTOTAL(103,Отгрузки_tb[Наименование изделий])","v":5}]

{"sheet":"Поиск","index":3,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Номер наряд заказа","Дата заказа","Контрагент","Сумма заказа","Сделать  к  Дате ","Отгрузка номер","Дата отгрузки","НЕ ГОТОВЫ (руб.)","ГОТОВЫ (руб.)","Остатки С ПРЕД. МЕС И ПОКУПНОЕ","Сумма отгрузки (руб.)","Отгружено по факту (руб.)","На складе зд ОСТАЛОСЬ (руб.)","Реализ-я из офиса и прочее","Наименование изделий"]
["12.1","01.12.2024","ООО \"Смирнов\"",100000,"15.12.2024",null,null,null,null,null,null,null,null,null,"ШПЭ3-2 шт, ПЭ4-5 шт"]
["Итог",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(103,Поиск[Наименование изделий])","v":1}]