{"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":34,"n_cols":15,"rows_kept":34,"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(I7:I1000)","v":0},null,null,{"$f":"SUM(M7:M1000)","v":0},{"$f":"SUM(N7:N1000)","v":0}]
["Номер наряд заказа","Дата заказа","Контрагент","Сумма заказа","Сделать  к  Дате ","Отгрузка номер","Дата отгрузки","НЕ ГОТОВЫ (руб.)","ГОТОВЫ (руб.)","Остатки С ПРЕД. МЕС И ПОКУПНОЕ","Сумма отгрузки (руб.)","Отгружено по факту (руб.)","На складе зд ОСТАЛОСЬ (руб.)","Реализ-я из офиса и прочее","Наименование изделий"]
["12.1","01.12.2024","ООО \"Смирнов\"",500000,"20.12.2024",null,null,null,null,null,null,{"$f":"IF((K7=\"\")*ISNUMBER(K8),SUM(K8:INDEX(K8:$K$21,MATCH(TRUE,INDEX(ISBLANK(K8:$K$21),),0))),\"\")","v":500000},null,null,"ШЖЭ-3 - 9 шт"]
[null,null,"ООО \"Смирнов\"",null,null,"3-12.1","21.12.2024",null,null,null,200000,{"$f":"IF((K8=\"\")*ISNUMBER(K10),SUM(K10:INDEX(K10:$K$21,MATCH(TRUE,INDEX(ISBLANK(K10:$K$21),),0))),\"\")","v":""},null,null,"ШЖЭ-3 - 3 шт"]
["12.4","04.12.2024","ООО \"Смирнов\"",50000,"23.12.2024","4-12.1","23.12.2024",null,null,null,300000,null,null,null,"ПЭ-4 - 1 шт"]
["12.2","02.12.2024","ИП Пупкин",50000,"21.12.2024",null,null,null,null,null,null,{"$f":"IF((K10=\"\")*ISNUMBER(K11),SUM(K11:INDEX(K11:$K$21,MATCH(TRUE,INDEX(ISBLANK(K11:$K$21),),0))),\"\")","v":150000},null,null,"ПЭ-4 - 1 шт"]
[null,null,"ИП Пупкин",null,null,"1-12.2","22.12.2024",null,null,null,50000,{"$f":"IF((K11=\"\")*ISNUMBER(K12),SUM(K12:INDEX(K12:$K$21,MATCH(TRUE,INDEX(ISBLANK(K12:$K$21),),0))),\"\")","v":""},null,null,"ПЭ-4 - 1 шт"]
[null,null,"ИП Иванов",null,null,"2-12.3","23.12.2024",null,null,null,100000,{"$f":"IF((K12=\"\")*ISNUMBER(K13),SUM(K13:INDEX(K13:$K$21,MATCH(TRUE,INDEX(ISBLANK(K13:$K$21),),0))),\"\")","v":""},null,null,"ПЭ-4 - 2 шт"]
["12.3","03.12.2024","ИП Иванов",100000,"22.12.2024",null,null,null,null,null,null,{"$f":"IF((K13=\"\")*ISNUMBER(K14),SUM(K14:INDEX(K14:$K$21,MATCH(TRUE,INDEX(ISBLANK(K14:$K$21),),0))),\"\")","v":""},null,null,"ПЭ-4 - 2 шт"]
["12.7","07.12.2024","ИП Фомин",3000,"08.12.2024",null,null,null,null,null,null,{"$f":"IF((K14=\"\")*ISNUMBER(K15),SUM(K15:INDEX(K15:$K$21,MATCH(TRUE,INDEX(ISBLANK(K15:$K$21),),0))),\"\")","v":3000},null,null,"Контр петля - 5 шт"]
[null,null,"ИП Фомин",null,null,"5-12.7","07.12.2024",null,null,null,3000,null,null,null,"Контр петля - 5 шт"]
[null,null,null,{"$f":"SUBTOTAL(109,Сводная_tb[Сумма заказа])","v":703000},null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Сводная_tb[Отгружено по факту (руб.)])","v":653000}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K17=\"\")*ISNUMBER(K18),SUM(K18:INDEX(K18:$K$21,MATCH(TRUE,INDEX(ISBLANK(K18:$K$21),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K18=\"\")*ISNUMBER(K19),SUM(K19:INDEX(K19:$K$21,MATCH(TRUE,INDEX(ISBLANK(K19:$K$21),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K19=\"\")*ISNUMBER(K20),SUM(K20:INDEX(K20:$K$21,MATCH(TRUE,INDEX(ISBLANK(K20:$K$21),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K20=\"\")*ISNUMBER(K21),SUM(K21:INDEX(K21:$K$21,MATCH(TRUE,INDEX(ISBLANK(K21:$K$21),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K21=\"\")*ISNUMBER(K22),SUM(K22:INDEX(K$21:$K22,MATCH(TRUE,INDEX(ISBLANK(K$21:$K22),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K22=\"\")*ISNUMBER(K23),SUM(K23:INDEX(K$21:$K23,MATCH(TRUE,INDEX(ISBLANK(K$21:$K23),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K23=\"\")*ISNUMBER(K24),SUM(K24:INDEX(K$21:$K24,MATCH(TRUE,INDEX(ISBLANK(K$21:$K24),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K24=\"\")*ISNUMBER(K25),SUM(K25:INDEX(K$21:$K25,MATCH(TRUE,INDEX(ISBLANK(K$21:$K25),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K25=\"\")*ISNUMBER(K26),SUM(K26:INDEX(K$21:$K26,MATCH(TRUE,INDEX(ISBLANK(K$21:$K26),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K26=\"\")*ISNUMBER(K27),SUM(K27:INDEX(K$21:$K27,MATCH(TRUE,INDEX(ISBLANK(K$21:$K27),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K27=\"\")*ISNUMBER(K28),SUM(K28:INDEX(K$21:$K28,MATCH(TRUE,INDEX(ISBLANK(K$21:$K28),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K28=\"\")*ISNUMBER(K29),SUM(K29:INDEX(K$21:$K29,MATCH(TRUE,INDEX(ISBLANK(K$21:$K29),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K29=\"\")*ISNUMBER(K30),SUM(K30:INDEX(K$21:$K30,MATCH(TRUE,INDEX(ISBLANK(K$21:$K30),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K30=\"\")*ISNUMBER(K31),SUM(K31:INDEX(K$21:$K31,MATCH(TRUE,INDEX(ISBLANK(K$21:$K31),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K31=\"\")*ISNUMBER(K32),SUM(K32:INDEX(K$21:$K32,MATCH(TRUE,INDEX(ISBLANK(K$21:$K32),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K32=\"\")*ISNUMBER(K33),SUM(K33:INDEX(K$21:$K33,MATCH(TRUE,INDEX(ISBLANK(K$21:$K33),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K33=\"\")*ISNUMBER(K34),SUM(K34:INDEX(K$21:$K34,MATCH(TRUE,INDEX(ISBLANK(K$21:$K34),),0))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((K34=\"\")*ISNUMBER(K35),SUM(K35:INDEX(K$21:$K35,MATCH(TRUE,INDEX(ISBLANK(K$21:$K35),),0))),\"\")","v":""}]

{"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}]