{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,"A","B","C",null,"D",null,"E",null,"F"]
[null,null,null,null,null,null,1,10,0.8,2.2000000000000002,null,0.9,null,{"$f":"H4*IF(L4<=I4,J4,L4-I4)","v":0.99999999999999978},null,{"$f":"H4*IF(L4<=I4,J4,L4-I4)+H5*IF(L4<=I5,J5,L4-I5)","v":1.0759999999999998},{"$f":"SUMPRODUCT($H$4:$H$600*((L4<=$I$4:$I$600)*$J$4:$J$600+(L4>$I$4:$I$600)*(L4-$I$4:$I$600)))","v":16.475999999999999},{"$f":"SUMPRODUCT(($G$4:$G$600=1)*$H$4:$H$600*((L4<=$I$4:$I$600)*$J$4:$J$600+(L4>$I$4:$I$600)*(L4-$I$4:$I$600))+($G$4:$G$600=-1)*$H$4:$H$600*((L4>$I$4:$I$600)*$J$4:$J$600+(L4<=$I$4:$I$600)*($I$4:$I$600-L4)))","v":12.55}]
[null,null,null,null,null,null,-1,1,0.82399999999999995,2.2999999999999998,null,0.90010000000000001,null,null,null,null,{"$f":"SUMPRODUCT($H$4:$H$600*((L5<=$I$4:$I$600)*$J$4:$J$600+(L5>$I$4:$I$600)*(L5-$I$4:$I$600)))","v":16.4771},{"$f":"SUMPRODUCT(($G$4:$G$600=1)*$H$4:$H$600*((L5<=$I$4:$I$600)*$J$4:$J$600+(L5>$I$4:$I$600)*(L5-$I$4:$I$600))+($G$4:$G$600=-1)*$H$4:$H$600*((L5>$I$4:$I$600)*$J$4:$J$600+(L5<=$I$4:$I$600)*($I$4:$I$600-L5)))","v":12.55095}]
[null,null,null,null,null,null,1,2,1.2,2.1,null,0.9002,null,null,null,null,16.478200000000001,12.5519]
[null,null,null,null,null,null,-1,0.5,1.4,2,null,0.90029999999999999,null,null,null,null,16.479299999999999,12.552849999999999]
[null,null,null,null,null,null,0,3,1.23,1.8,null,0.90039999999999998,null,null,null,null,16.480399999999999,12.553799999999999]
[null,null,null,null,null,null,1,4,1.3,1.2,null,0.90049999999999997,null,null,null,null,16.4815,12.554749999999999]
[null,null,null,null,null,null,null,null,null,null,null,0.90059999999999996,null,null,null,null,16.482600000000001,12.555699999999998]
[null,null,null,null,null,null,null,null,null,null,null,0.90069999999999995,null,null,null,null,16.483699999999999,12.556649999999998]
[null,null,null,null,null,null,null,null,null,null,null,0.90080000000000005,null,null,null,null,16.4848,12.557600000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39.699999999999996,32.524000000000001]
[]
[]
[]
[null,null,null,null,"Суть такая: "]
[null,null,null,null," первые три строчки сравниваются оператором Если и значением 0,9000 "]
[null,null,null,null," сумма "]
[null,null,null,null," вторые три строчки сравниваются оператором Если и значением 0,9000 "]
[null,null,null,null," сумма "]
[null,null,null,null," и так далее пока не кончатся данные в первых трех строчках (всего столбцов более 600а) Записывается в ячейку напротив значения 0,9000. "]
[null,null,null,null," Далее повторяется то же самое но значение 0,9001 "]
[null,null,null,null," и результат в ячейку напротив 0,9001.. "]
[null,null,null,null," Заранее спасибо."]

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