{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Лист1","index":0,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,7,0,8],[0,10,0,11],[0,13,0,14]]}
[null,null,null,null,"Вариант 1",null,null,"Вариант 2",null,null,"Вариант 3",null,null,"Вариант 4"]
["Наименование","Запланировано количество",null,null,"Названия строк","Сумма по полю Запланировано количество",null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N1,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":0}]
[null,null,null,null,"Балка",7,null,{"$f":"Уник_по_критер(A3:A1001,,,,,1,1)","v":"Балка"},{"$f":"SUMIF($A$2:$A$100,H3,$B$2:$B$100)","v":7},null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Песок"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N2,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Песок"},{"$f":"SUMIF($A$2:$A$100,N3,$B$2:$B$100)","v":33}]
["Песок",25,null,null,"Вентиль",58,null,"Вентиль",{"$f":"SUMIF($A$2:$A$100,H4,$B$2:$B$100)","v":58},null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Цемент"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N3,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Цемент"},{"$f":"SUMIF($A$2:$A$100,N4,$B$2:$B$100)","v":12}]
["Цемент",4,null,null,"Гайка",18,null,"Гайка",18,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Щебень"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N4,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Щебень"},128]
["Щебень",15,null,null,"Гвозди",14,null,"Гвозди",14,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Гравий"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N5,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Гравий"},15]
[null,null,null,null,"Гравий",15,null,"Гравий",15,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Кирпич"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N6,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Кирпич"},10]
[null,null,null,null,"Дюбель",9,null,"Дюбель",9,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Гвозди"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N7,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Гвозди"},14]
["Гравий",8,null,null,"Известь",17,null,"Известь",17,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Дюбель"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N8,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Дюбель"},9]
[null,null,null,null,"Кирпич",10,null,"Кирпич",10,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Гайка"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N9,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Гайка"},18]
["Кирпич",1,null,null,"Кран",7,null,"Кран",7,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Кран"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N10,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Кран"},7]
["Гвозди",5,null,null,"Муфта",6,null,"Муфта",6,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Вентиль"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N11,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Вентиль"},58]
["Дюбель",4,null,null,"Песок",33,null,"Песок",33,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Балка"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N12,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Балка"},7]
[null,null,null,null,"Цемент",12,null,"Цемент",12,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Известь"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N13,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Известь"},17]
["Песок",8,null,null,"Щебень",128,null,"Щебень",128,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Электроды"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N14,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Электроды"},105]
["Гайка",9,null,null,"Электроды",105,null,"Электроды",105,null,{"$f":"IFERROR(INDEX($A$2:$A$100,SMALL(IF(IFERROR(MATCH($A$2:$A$100,$A$2:$A$100,0),\"\")=ROW($1:$99),MATCH($A$2:$A$100,$A$2:$A$100,0),\"\"),ROW()-1),1),\"\")","v":"Муфта"},null,null,{"$f":"IFERROR(INDEX($A$3:$A$51,SMALL(IF(COUNTIF($N$1:N15,$A$3:$A$51)=0,ROW($A$1:$A$49)),1)),\"\")","v":"Муфта"},6]
[null,null,null,null,"(пусто)",null,null,"",0]
[null,null,null,null,"Общий итог",439,null,""]
["Кран",2,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
["Вентиль",45,null,null,null,null,null,""]
["Балка",2,null,null,null,null,null,""]
["Известь",14,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
["Электроды",98,null,null,null,null,null,""]
["Муфта",2,null,null,null,null,null,""]
["Гвозди",4,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[]
["Электроды",7]
["Кирпич",9]
[]
[]
[]
["Щебень",5]
["Вентиль",6]
["Муфта",4]
[]
["Цемент",8]
["Щебень",98]
[]
[]
["Вентиль",7]
["Дюбель",5]
[]
[]
["Гайка",9]
[]
[]
["Щебень",10]
["Гвозди",5]
[]
[]
[]
["Гравий",7]
["Кран",5]
[]
[]
[]
["Известь",3]
["Балка",5]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}