{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":19,"n_cols":51,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,5,21,17]]}
[]
[null,1,2,3,4,5,6,7,8,null,null,null,"цена",1,2,3,4,5,6,7,8,null,"курс",1,2,3,4,5,6,7,8,null,"продажа",1,2,3,4,5,6,7,8,null,"инвестиции",1,2,3,4,5,6,7,8]
["цена",13,13,13,13,13,13,13,13,null,null,null,1,9,9,9,9,9,9,9,9,null,1,4.5,4.5,4.5,4.5,4.5,4.5,4.5,4.5,null,1,4,4,4,4,4,4,4,4,null,1,-7,-7,-7,-7,-7,-7,-7,-7]
["курс",7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,null,null,null,2,8,8,8,8,8,8,8,8,null,2,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5,null,2,5,5,5,5,5,5,5,5,null,2,-8,-8,-8,-8,-8,-8,-8,-8]
["продажа",9,9,9,9,9,9,9,9,null,null,null,3,7,7,7,7,7,7,7,7,null,3,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,null,3,6,6,6,6,6,6,6,6,null,3,-9,-9,-9,-9,-9,-9,-9,-9]
["инвестиции",-12,-12,-12,-12,-12,-12,-12,-12,null,null,null,4,11,11,11,11,11,11,11,11,null,4,5.5,5.5,5.5,5.5,5.5,5.5,5.5,5.5,null,4,7,7,7,7,7,7,7,7,null,4,-10,-10,-10,-10,-10,-10,-10,-10]
["итого",{"$f":"B3*B4*B5+B6","v":865.5},{"$f":"C3*C4*C5+C6","v":865.5},865.5,865.5,865.5,865.5,865.5,865.5,null,null,null,5,12,12,12,12,12,12,12,12,null,5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,null,5,8,8,8,8,8,8,8,8,null,5,-11,-11,-11,-11,-11,-11,-11,-11]
["дисконт",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,null,null,null,6,13,13,13,13,13,13,13,13,null,6,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,null,6,9,9,9,9,9,9,9,9,null,6,-12,-12,-12,-12,-12,-12,-12,-12]
[null,{"$f":"B7*B8","v":432.75},{"$f":"C7*C8","v":432.75},432.75,432.75,432.75,432.75,432.75,432.75]
[]
["итого",{"$f":"SUM(B9:I9)","v":3462}]
[]
[null,"Итого"]
[1]
[2]
[3]
[4]
[5]
[6,null,null,null,null,"Чтобы было более понятно прилагаю файл с примером. Надо чтобы значения в строчках 3-6, подменялись значениями в диапазонах, расположены правее. И для каждого сценария (1-6) считался итоговый показатель, который потом вытаскивался на лист в ячейки B14-B19."]