{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Заявка","Лист 1","Лист 2","Лист 3","Обобщенка","Данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[11,1,11,5],[13,1,13,5],[15,1,15,5],[1,8,1,12],[3,8,3,12],[5,8,5,12],[11,8,11,12],[13,8,13,12],[7,8,7,12],[9,8,9,12],[15,8,15,12],[1,1,1,5],[3,1,3,5],[5,1,5,5],[7,1,7,5],[9,1,9,5],[17,8,17,12],[19,8,19,12],[21,8,21,12],[23,1,23,5],[23,8,23,12],[17,1,17,5],[19,1,19,5],[21,1,21,5]]}
[]
[{"$f":"(C3<>\"\")*COUNTA($C$3:C3)","v":1},{"$f":"IF(ISBLANK(Заявка!$C3),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C3,Таблица1[3],0)))","v":"Авт. выкл."},null,null,null,null,null,{"$f":"A2","v":1},{"$f":"B2","v":"Авт. выкл."},null,null,null,{"$f":"F2","v":0}]
[{"$f":"(C4<>\"\")*COUNTA($C$3:C4)","v":0},{"$f":"IF(ISBLANK(Заявка!$C3),\"\",\"№\"&SUBSTITUTE(G3,\"\",\"№\"))","v":"№"},669,{"$f":"IF(ISBLANK(Заявка!$C3),\"\",\"-\"&SUBSTITUTE(G3,\"\",\"-\"))","v":"-"},null,{"$f":"IF(ISBLANK(Заявка!$C3),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C3,Таблица1[3],0)))","v":"шт."},null,{"$f":"A3","v":0},{"$f":"B3","v":"№"},{"$f":"C3","v":669},{"$f":"D3","v":"-"},{"$f":"E3","v":0},{"$f":"F3","v":"шт."}]
[{"$f":"(C5<>\"\")*COUNTA($C$3:C5)","v":0},{"$f":"IF(ISBLANK(Заявка!$C5),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C5,Таблица1[3],0)))","v":""},null,null,null,null,null,{"$f":"A4","v":0},{"$f":"B4","v":""},null,null,{"$f":"E4","v":0},0]
[{"$f":"(C6<>\"\")*COUNTA($C$3:C6)","v":0},{"$f":"IF(ISBLANK(Заявка!$C5),\"\",\"№\"&SUBSTITUTE(G5,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C5),\"\",\"-\"&SUBSTITUTE(G5,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C5),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C5,Таблица1[3],0)))","v":""},null,0,{"$f":"B5","v":""},{"$f":"C5","v":0},{"$f":"D5","v":""},0,""]
[{"$f":"(C7<>\"\")*COUNTA($C$3:C7)","v":0},{"$f":"IF(ISBLANK(Заявка!$C7),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C7,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C8<>\"\")*COUNTA($C$3:C8)","v":0},{"$f":"IF(ISBLANK(Заявка!$C7),\"\",\"№\"&SUBSTITUTE(G7,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C7),\"\",\"-\"&SUBSTITUTE(G7,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C7),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C7,Таблица1[3],0)))","v":""},null,0,{"$f":"B7","v":""},{"$f":"C7","v":0},"",0,""]
[{"$f":"(C9<>\"\")*COUNTA($C$3:C9)","v":0},{"$f":"IF(ISBLANK(Заявка!$C9),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C9,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C10<>\"\")*COUNTA($C$3:C10)","v":0},{"$f":"IF(ISBLANK(Заявка!$C9),\"\",\"№\"&SUBSTITUTE(G9,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C9),\"\",\"-\"&SUBSTITUTE(G9,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C9),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C9,Таблица1[3],0)))","v":""},null,0,{"$f":"B9","v":""},{"$f":"C9","v":0},"",0,""]
[{"$f":"(C11<>\"\")*COUNTA($C$3:C11)","v":0},{"$f":"IF(ISBLANK(Заявка!$C11),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C11,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C12<>\"\")*COUNTA($C$3:C12)","v":0},{"$f":"IF(ISBLANK(Заявка!$C11),\"\",\"№\"&SUBSTITUTE(G11,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C11),\"\",\"-\"&SUBSTITUTE(G11,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C11),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C11,Таблица1[3],0)))","v":""},null,0,{"$f":"B11","v":""},{"$f":"C11","v":0},"",0,""]
[{"$f":"(C13<>\"\")*COUNTA($C$3:C13)","v":0},{"$f":"IF(ISBLANK(Заявка!$C13),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C13,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C14<>\"\")*COUNTA($C$3:C14)","v":0},{"$f":"IF(ISBLANK(Заявка!$C13),\"\",\"№\"&SUBSTITUTE(G13,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C13),\"\",\"-\"&SUBSTITUTE(G13,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C13),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C13,Таблица1[3],0)))","v":""},null,0,{"$f":"B13","v":""},{"$f":"C13","v":0},"",0,""]
[{"$f":"(C15<>\"\")*COUNTA($C$3:C15)","v":0},{"$f":"IF(ISBLANK(Заявка!$C15),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C15,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C16<>\"\")*COUNTA($C$3:C16)","v":0},{"$f":"IF(ISBLANK(Заявка!$C15),\"\",\"№\"&SUBSTITUTE(G15,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C15),\"\",\"-\"&SUBSTITUTE(G15,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C15),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C15,Таблица1[3],0)))","v":""},null,0,{"$f":"B15","v":""},{"$f":"C15","v":0},"",0,""]
[{"$f":"(C17<>\"\")*COUNTA($C$3:C17)","v":0},{"$f":"IF(ISBLANK(Заявка!$C17),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C17,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C18<>\"\")*COUNTA($C$3:C18)","v":0},{"$f":"IF(ISBLANK(Заявка!$C17),\"\",\"№\"&SUBSTITUTE(G17,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C17),\"\",\"-\"&SUBSTITUTE(G17,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C17),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C17,Таблица1[3],0)))","v":""},null,0,{"$f":"B17","v":""},{"$f":"C17","v":0},"",0,""]
[{"$f":"(C19<>\"\")*COUNTA($C$3:C19)","v":0},{"$f":"IF(ISBLANK(Заявка!$C19),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C19,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C20<>\"\")*COUNTA($C$3:C20)","v":0},{"$f":"IF(ISBLANK(Заявка!$C19),\"\",\"№\"&SUBSTITUTE(G19,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C19),\"\",\"-\"&SUBSTITUTE(G19,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C19),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C19,Таблица1[3],0)))","v":""},null,0,{"$f":"B19","v":""},{"$f":"C19","v":0},"",0,""]
[{"$f":"(C21<>\"\")*COUNTA($C$3:C21)","v":0},{"$f":"IF(ISBLANK(Заявка!$C21),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C21,Таблица1[3],0)))","v":""},null,null,null,null,null,0,"",null,null,0,0]
[{"$f":"(C22<>\"\")*COUNTA($C$3:C22)","v":0},{"$f":"IF(ISBLANK(Заявка!$C21),\"\",\"№\"&SUBSTITUTE(G21,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C21),\"\",\"-\"&SUBSTITUTE(G21,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C21),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C21,Таблица1[3],0)))","v":""},null,0,{"$f":"B21","v":""},{"$f":"C21","v":0},"",0,""]
[{"$f":"(C23<>\"\")*COUNTA($C$3:C23)","v":0},{"$f":"IF(ISBLANK(Заявка!$C23),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C23,Таблица1[3],0)))","v":""},null,null,null,null,null,0,{"$f":"B22","v":""},null,null,0,0]
[{"$f":"(C24<>\"\")*COUNTA($C$3:C24)","v":0},{"$f":"IF(ISBLANK(Заявка!$C23),\"\",\"№\"&SUBSTITUTE(G23,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C23),\"\",\"-\"&SUBSTITUTE(G23,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C23),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C23,Таблица1[3],0)))","v":""},null,0,"",{"$f":"C23","v":0},"",0,""]
[{"$f":"(C25<>\"\")*COUNTA($C$3:C25)","v":0},{"$f":"IF(ISBLANK(Заявка!$C25),\"\",INDEX(Таблица1[2],MATCH(Заявка!$C25,Таблица1[3],0)))","v":""},null,null,null,null,null,{"$f":"A24","v":0},"",null,null,{"$f":"E24","v":0},{"$f":"F24","v":0}]
[{"$f":"(C26<>\"\")*COUNTA($C$3:C26)","v":0},{"$f":"IF(ISBLANK(Заявка!$C25),\"\",\"№\"&SUBSTITUTE(G25,\"\",\"№\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C25),\"\",\"-\"&SUBSTITUTE(G25,\"\",\"-\"))","v":""},null,{"$f":"IF(ISBLANK(Заявка!$C25),\"\",INDEX(Таблица1[4],MATCH(Заявка!$C25,Таблица1[3],0)))","v":""},null,0,"",{"$f":"C25","v":0},{"$f":"D25","v":""},0,""]

{"sheet":"Лист 1","index":1,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,11,2,11],[1,12,2,12],[0,11,0,12],[0,5,2,5],[0,6,2,6],[0,7,1,8],[0,9,1,10],[0,0,2,0],[0,1,0,2],[1,1,2,1],[1,2,2,2],[0,3,0,4],[1,3,2,3],[1,4,2,4]]}
["№ п/п","Материалы",null,"Единица измерения",null,"Остаток на момент заполнения","Дата заполнения","Дебет",null,"Кредит",null,"Остаток на"]
[null,"наименование","код","наим.","код",null,null,null,null,null,null,"кол-во","текущая дата"]
[null,null,null,null,null,null,null,"кол-во\n(с учетом остатка)","номер и дата накладной","кол-во","номер и дата  документа"]
["1","2","3","4","5","6","7","8","9","10","11","12","13"]
[{"$f":"(C5<>\"\")*COUNTA($C$5:C5)","v":0},null,null,null,null,{"$f":"H6","v":0},{"$f":"IF(Таблица1[[#This Row],[2]]=\"\",\"\",IF(G5=\"\",IF(Таблица1[[#This Row],[2]]=\"\",\"\",NOW()),G5))","v":""}]
[{"$f":"(C6<>\"\")*COUNTA($C$5:C6)","v":0}]
[{"$f":"(C7<>\"\")*COUNTA($C$5:C7)","v":0}]
[{"$f":"(C8<>\"\")*COUNTA($C$5:C8)","v":0}]
[{"$f":"(C9<>\"\")*COUNTA($C$5:C9)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B5=B5),SUM(H6:H8))","v":0},null,{"$f":"IF(OR(B5=B5),SUM(J6:J8))","v":0},null,{"$f":"IF(OR(B5=B5),Таблица1[[#This Row],[8]]-SUM(J6:J8))","v":0},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]
[{"$f":"(C10<>\"\")*COUNTA($C$5:C10)","v":1},"Авт. выкл.",669,"шт.",112,{"$f":"H11","v":1},{"$f":"IF(Таблица1[[#This Row],[2]]=\"\",\"\",IF(G10=\"\",IF(Таблица1[[#This Row],[2]]=\"\",\"\",NOW()),G10))","v":"2022-09-13T15:28:08.150"}]
[{"$f":"(C11<>\"\")*COUNTA($C$5:C11)","v":0},null,null,null,null,null,null,1,"124 от 19.07.2022"]
[{"$f":"(C12<>\"\")*COUNTA($C$5:C12)","v":0},null,null,null,null,null,null,null,null,1,null,{"$f":"IF(OR(B10=B10),F10-SUM(Таблица1[[#This Row],[10]]))","v":0}]
[{"$f":"(C13<>\"\")*COUNTA($C$5:C13)","v":0}]
[{"$f":"(C14<>\"\")*COUNTA($C$5:C14)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B10=B10),SUM(H11:H13))","v":1},null,{"$f":"IF(OR(B10=B10),SUM(J11:J13))","v":1},null,{"$f":"IF(OR(B10=B10),Таблица1[[#This Row],[8]]-SUM(J11:J13))","v":0},"2022-10-08T23:52:59.750"]
[{"$f":"(C15<>\"\")*COUNTA($C$5:C15)","v":2},"Валик",158964,"шт.",89,{"$f":"H16","v":1},{"$f":"IF(Таблица1[[#This Row],[2]]=\"\",\"\",IF(G15=\"\",IF(Таблица1[[#This Row],[2]]=\"\",\"\",NOW()),G15))","v":"2022-09-13T15:28:08.150"}]
[{"$f":"(C16<>\"\")*COUNTA($C$5:C16)","v":0},null,null,null,null,null,null,1,"144 от 29.08.2022"]
[{"$f":"(C17<>\"\")*COUNTA($C$5:C17)","v":0}]
[{"$f":"(C18<>\"\")*COUNTA($C$5:C18)","v":0}]
[{"$f":"(C19<>\"\")*COUNTA($C$5:C19)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B15=B15),SUM(H16:H18))","v":1},null,{"$f":"IF(OR(B15=B15),SUM(J16:J18))","v":0},null,{"$f":"IF(OR(B15=B15),Таблица1[[#This Row],[8]]-SUM(J16:J18))","v":1},"2022-10-08T23:52:59.750"]

{"sheet":"Лист 2","index":2,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,9,1,10],[0,11,0,12],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,11,2,11],[1,12,2,12],[0,7,1,8],[0,0,2,0],[0,1,0,2],[0,3,0,4],[0,5,2,5],[0,6,2,6]]}
["№ п/п","Материалы",null,"Единица измерения",null,"Остаток на момент заполнения","Дата заполнения","Дебет",null,"Кредит",null,"Остаток на"]
[null,"наименование","код","наим.","код",null,null,null,null,null,null,"кол-во","текущая дата"]
[null,null,null,null,null,null,null,"кол-во\n(с учетом остатка)","номер и дата накладной","кол-во","номер и дата  документа"]
["1","2","3","4","5","6","7","8","9","10","11","12","13"]
[{"$f":"(C5<>\"\")*COUNTA($C$5:C5)","v":0},null,null,null,null,{"$f":"H6","v":0},{"$f":"IF(Таблица14[[#This Row],[2]]=\"\",\"\",IF(G5=\"\",IF(Таблица14[[#This Row],[2]]=\"\",\"\",NOW()),G5))","v":""}]
[{"$f":"(C6<>\"\")*COUNTA($C$5:C6)","v":0}]
[{"$f":"(C7<>\"\")*COUNTA($C$5:C7)","v":0}]
[{"$f":"(C8<>\"\")*COUNTA($C$5:C8)","v":0}]
[{"$f":"(C9<>\"\")*COUNTA($C$5:C9)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B5=B5),SUM(H6:H8))","v":0},null,{"$f":"IF(OR(B5=B5),SUM(J6:J8))","v":0},null,{"$f":"IF(OR(B5=B5),Таблица14[[#This Row],[8]]-SUM(J6:J8))","v":0},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]
[{"$f":"(C10<>\"\")*COUNTA($C$5:C10)","v":1},"Набор",16232,"шт.",111,{"$f":"H11","v":1},{"$f":"IF(Таблица14[[#This Row],[2]]=\"\",\"\",IF(G10=\"\",IF(Таблица14[[#This Row],[2]]=\"\",\"\",NOW()),G10))","v":"2022-09-13T15:28:08.150"}]
[{"$f":"(C11<>\"\")*COUNTA($C$5:C11)","v":0},null,null,null,null,null,null,1,"129 от 22.07.2022"]
[{"$f":"(C12<>\"\")*COUNTA($C$5:C12)","v":0},null,null,null,null,null,null,null,null,1,null,{"$f":"IF(OR(B10=B10),H11-SUM(Таблица14[[#This Row],[10]]))","v":0}]
[{"$f":"(C13<>\"\")*COUNTA($C$5:C13)","v":0}]
[{"$f":"(C14<>\"\")*COUNTA($C$5:C14)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B10=B10),SUM(H11:H13))","v":1},null,{"$f":"IF(OR(B10=B10),SUM(J11:J13))","v":1},null,{"$f":"IF(OR(B10=B10),Таблица14[[#This Row],[8]]-SUM(J11:J13))","v":0},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]
[{"$f":"(C15<>\"\")*COUNTA($C$5:C15)","v":2},"Обои",11223,"кв.м.",1,{"$f":"H16","v":20.5},{"$f":"IF(Таблица14[[#This Row],[2]]=\"\",\"\",IF(G15=\"\",IF(Таблица14[[#This Row],[2]]=\"\",\"\",NOW()),G15))","v":"2022-09-13T15:28:08.150"}]
[{"$f":"(C16<>\"\")*COUNTA($C$5:C16)","v":0},null,null,null,null,null,null,20.5,"124 от 19.07.2022"]
[{"$f":"(C17<>\"\")*COUNTA($C$5:C17)","v":0},null,null,null,null,null,null,null,null,20.5,null,{"$f":"IF(OR(B15=B15),H16-SUM(Таблица14[[#This Row],[10]]))","v":0}]
[{"$f":"(C18<>\"\")*COUNTA($C$5:C18)","v":0},null,null,null,null,null,null,79.5,"120 от 14.07.2022"]
[{"$f":"(C19<>\"\")*COUNTA($C$5:C19)","v":0},null,null,null,null,null,null,null,null,78.41,null,{"$f":"IF(OR(B15=B15),H18-SUM(Таблица14[[#This Row],[10]]))","v":1.0900000000000034}]
[{"$f":"(C20<>\"\")*COUNTA($C$5:C20)","v":0},null,null,null,null,null,null,null,null,1.0900000000000001,null,{"$f":"IF(OR(B15=B15),L19-SUM(Таблица14[[#This Row],[10]]))","v":3.3306690738754696E-15}]
[{"$f":"(C21<>\"\")*COUNTA($C$5:C21)","v":0}]
[{"$f":"(C22<>\"\")*COUNTA($C$5:C22)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B15=B15),SUM(H16:H21))","v":100},null,{"$f":"IF(OR(B15=B15),SUM(J16:J21))","v":100},null,{"$f":"IF(OR(B15=B15),Таблица14[[#This Row],[8]]-SUM(J16:J21))","v":0},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]
[{"$f":"(C23<>\"\")*COUNTA($C$5:C23)","v":3},"Обои 405",66,"кв.м.",2,{"$f":"H24","v":165.54},{"$f":"IF(Таблица14[[#This Row],[2]]=\"\",\"\",IF(G23=\"\",IF(Таблица14[[#This Row],[2]]=\"\",\"\",NOW()),G23))","v":"2022-09-13T15:28:08.150"}]
[{"$f":"(C24<>\"\")*COUNTA($C$5:C24)","v":0},null,null,null,null,null,null,165.54,"094 от 07.06.2022"]
[{"$f":"(C25<>\"\")*COUNTA($C$5:C25)","v":0},null,null,null,null,null,null,null,null,59.92,null,{"$f":"IF(OR(B23=B23),H24-SUM(Таблица14[[#This Row],[10]]))","v":105.61999999999999}]
[{"$f":"(C26<>\"\")*COUNTA($C$5:C26)","v":0},null,null,null,null,null,null,null,null,55.39,null,{"$f":"IF(OR(B23=B23),L25-SUM(Таблица14[[#This Row],[10]]))","v":50.22999999999999}]
[{"$f":"(C27<>\"\")*COUNTA($C$5:C27)","v":0},null,null,null,null,null,null,null,null,50.23,null,{"$f":"IF(OR(B23=B23),L26-SUM(Таблица14[[#This Row],[10]]))","v":-7.1054273576010019E-15}]
[{"$f":"(C28<>\"\")*COUNTA($C$5:C28)","v":0}]
[{"$f":"(C29<>\"\")*COUNTA($C$5:C29)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B23=B23),SUM(H24:H28))","v":165.54},null,{"$f":"IF(OR(B23=B23),SUM(J24:J28))","v":165.54},null,{"$f":"IF(OR(B23=B23),Таблица14[[#This Row],[8]]-SUM(J24:J28))","v":0},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]
[{"$f":"(C30<>\"\")*COUNTA($C$5:C30)","v":4},"Покр. Напольное",1132458,"кв.м.",3,{"$f":"H31","v":14.31},{"$f":"IF(Таблица14[[#This Row],[2]]=\"\",\"\",IF(G30=\"\",IF(Таблица14[[#This Row],[2]]=\"\",\"\",NOW()),G30))","v":"2022-09-13T15:28:08.150"}]
[{"$f":"(C31<>\"\")*COUNTA($C$5:C31)","v":0},null,null,null,null,null,null,14.31,"087 от 26.05.2022"]
[{"$f":"(C32<>\"\")*COUNTA($C$5:C32)","v":0},null,null,null,null,null,null,null,null,14.31,null,{"$f":"IF(OR(B30=B30),H31-SUM(Таблица14[[#This Row],[10]]))","v":0}]
[{"$f":"(C33<>\"\")*COUNTA($C$5:C33)","v":0},null,null,null,null,null,null,2.09,"130 от 22.07.2022"]
[{"$f":"(C34<>\"\")*COUNTA($C$5:C34)","v":0},null,null,null,null,null,null,null,null,2.09,null,{"$f":"IF(OR(B30=B30),H33-SUM(Таблица14[[#This Row],[10]]))","v":0}]
[{"$f":"(C35<>\"\")*COUNTA($C$5:C35)","v":0}]
[{"$f":"(C36<>\"\")*COUNTA($C$5:C36)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B30=B30),SUM(H31:H35))","v":16.399999999999999},null,{"$f":"IF(OR(B30=B30),SUM(J31:J35))","v":16.399999999999999},null,{"$f":"IF(OR(B30=B30),Таблица14[[#This Row],[8]]-SUM(J31:J35))","v":0},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]

{"sheet":"Лист 3","index":3,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,9,1,10],[0,11,0,12],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,11,2,11],[1,12,2,12],[0,7,1,8],[0,0,2,0],[0,1,0,2],[0,3,0,4],[0,5,2,5],[0,6,2,6]]}
["№ п/п","Материалы",null,"Единица измерения",null,"Остаток на момент заполнения","Дата заполнения","Дебет",null,"Кредит",null,"Остаток на"]
[null,"наименование","код","наим.","код",null,null,null,null,null,null,"кол-во","текущая дата"]
[null,null,null,null,null,null,null,"кол-во\n(с учетом остатка)","номер и дата накладной","кол-во","номер и дата  документа"]
["1","2","3","4","5","6","7","8","9","10","11","12","13"]
[{"$f":"(C5<>\"\")*COUNTA($C$5:C5)","v":0},null,null,null,null,{"$f":"H6","v":0},{"$f":"IF(Таблица145[[#This Row],[2]]=\"\",\"\",IF(G5=\"\",IF(Таблица145[[#This Row],[2]]=\"\",\"\",NOW()),G5))","v":""}]
[{"$f":"(C6<>\"\")*COUNTA($C$5:C6)","v":0}]
[{"$f":"(C7<>\"\")*COUNTA($C$5:C7)","v":0}]
[{"$f":"(C8<>\"\")*COUNTA($C$5:C8)","v":0}]
[{"$f":"(C9<>\"\")*COUNTA($C$5:C9)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B5=B5),SUM(H6:H8))","v":0},null,{"$f":"IF(OR(B5=B5),SUM(J6:J8))","v":0},null,{"$f":"IF(OR(B5=B5),Таблица145[[#This Row],[8]]-SUM(J6:J8))","v":0},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]
[{"$f":"(C10<>\"\")*COUNTA($C$5:C10)","v":1},"Эмаль",56,"кг.",999,{"$f":"H11","v":2},{"$f":"IF(Таблица145[[#This Row],[2]]=\"\",\"\",IF(G10=\"\",IF(Таблица145[[#This Row],[2]]=\"\",\"\",NOW()),G10))","v":"2022-09-13T15:28:08.150"}]
[{"$f":"(C11<>\"\")*COUNTA($C$5:C11)","v":0},null,null,null,null,null,null,2,"120 от 14.07.2022"]
[{"$f":"(C12<>\"\")*COUNTA($C$5:C12)","v":0}]
[{"$f":"(C13<>\"\")*COUNTA($C$5:C13)","v":0}]
[{"$f":"(C14<>\"\")*COUNTA($C$5:C14)","v":0},"ИТОГО:",null,null,null,null,null,{"$f":"IF(OR(B10=B10),SUM(H11:H13))","v":2},null,{"$f":"IF(OR(B10=B10),SUM(J11:J13))","v":0},null,{"$f":"IF(OR(B10=B10),Таблица145[[#This Row],[8]]-SUM(J11:J13))","v":2},{"$f":"NOW()","v":"2022-10-08T23:52:59.750"}]

{"sheet":"Обобщенка","index":4,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,9,1,10],[0,11,0,12],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,11,2,11],[1,12,2,12],[0,7,1,8],[0,0,2,0],[0,1,0,2],[0,3,0,4],[0,5,2,5],[0,6,2,6]]}
["№ п/п","Материалы",null,"Единица измерения",null,"Остаток на момент заполнения","Дата заполнения","Дебет",null,"Кредит",null,"Остаток на"]
[null,"наименование","код","наим.","код",null,null,null,null,null,null,"кол-во","текущая дата"]
[null,null,null,null,null,null,null,"кол-во\n(с учетом остатка)","номер и дата накладной","кол-во","номер и дата  документа"]
["1","2","3","4","5","6","7","8","9","10","11","12","13"]

{"sheet":"Данные","index":5,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Единица_измерения"]
["кг."]
["шт."]
["к-т."]
["гр."]
["л."]
["рул."]
["пач."]
["пара"]
["экз."]
["пог.м."]
["м."]
["кв.м."]
["бабина"]
["лист"]
["мл."]
["г"]