{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Расшифровка","Исходные данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"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":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["№ п/п","Наименование","элемент","Ед.изм.","Кол-во","Фактическая стоимость",null,"ВСЕГО","Стоимость 1","Стоимость 2"]
[1,"2",null,3,4,5,null,6,7,8]
[null,"Дом",545,"шт",1,{"$f":"H4","v":13172193.26},null,{"$f":"SUM(I4:J4)","v":13172193.26},{"$f":"818854.79+9738913.32+495800.64+1327073.02+110000-301.56+681853.05","v":13172193.26}]
[null,"Гараж",897,"шт",1,{"$f":"H5","v":4776961.25},null,{"$f":"SUM(I5:J5)","v":4776961.25},{"$f":"321053.97+1987165.36+56482.16+59135.92+1535975.6+47274.5+20537.48+17647.23+50000+223562.67","v":4318834.8899999997},458126.36]
[null,"Бочка",7,"шт",1,330968.19,null,{"$f":"SUM(I6:J6)","v":330968.19},{"$f":"51654+197342.06+20975.26+20000+22418.1+17053.47","v":329442.89},1525.3]
[null,null,null,null,null,null,null,{"$f":"SUM(I7:J7)","v":0}]
[null,"ВСЕГО",null,null,null,{"$f":"SUM(F4:F7)","v":18280122.699999999},null,{"$f":"SUM(I8:J8)","v":18280122.699999999},{"$f":"SUM(I4:I7)","v":17820471.039999999},{"$f":"SUM(J4:J7)","v":459651.66}]

{"sheet":"Исходные данные","index":1,"n_rows":14,"n_cols":21,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Заголовок1","Заголовок2","Заголовок3","Заголовок4","Заголовок5","Заголовок6","Заголовок7","Количество","ЕИ запаса","Цена","За","Краткий текст","Заголовок13","Счет","Заголовок15","Заголовок16","элемент","Заголовок18","Заголовок19","Заголовок20","Заголовок21"]
[null,null,null,null,null,null,null,null,null,13172193.26,null,"Дом",null,null,null,null,545]
[null,null,null,null,null,null,null,null,null,4318834.8899999997,null,"Гараж",null,null,null,null,897]
[null,null,null,null,null,null,null,null,null,329442.89,null,"Бочка",null,null,null,null,7]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Необходимо чтобы получилось так:"]
[null,null,null,null,null,null,null,null,null,13172193.26,null,"Дом",null,null,null,null,545]
[null,null,null,null,null,null,null,null,null,4318834.8899999997,null,"Гараж",null,null,null,null,897]
[null,null,null,null,null,null,null,null,null,458126.36,null,"Гараж",null,1234567,null,null,897]
[null,null,null,null,null,null,null,null,null,329442.89,null,"Бочка",null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,1525.3,null,"Бочка",null,1234567,null,null,7]