{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["СокращениеЗатрат"],"not_rendered":{"charts":1,"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":"СокращениеЗатрат","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Исходные данные"]
[null,"Продажи",1000,{"$f":"C5/$C$5","v":1},null,null,{"$f":"B4","v":"Исходные данные"},{"$f":"B9","v":"Увеличение продаж (%)"},{"$f":"B14","v":"Уменьшение затрат (%)"}]
[null,"Затраты",800,{"$f":"C6/$C$5","v":0.8},null,{"$f":"B5","v":"Продажи"},{"$f":"INDEX($C$4:$C$21,MATCH(G$5,$B$4:$B$14,)+MATCH($F6,$B$5:$B$7,))","v":1000},{"$f":"INDEX($C$4:$C$21,MATCH(H$5,$B$4:$B$14,)+MATCH($F6,$B$5:$B$7,))","v":1200},1000]
[null,"Прибыль",{"$f":"C5-C6","v":200},{"$f":"C7/$C$5","v":0.2},null,{"$f":"B6","v":"Затраты"},{"$f":"INDEX($C$4:$C$21,MATCH(G$5,$B$4:$B$14,)+MATCH($F7,$B$5:$B$7,))","v":800},960,760]
[null,null,null,null,null,"Прибыль",200,240,240]
[null,"Увеличение продаж (%)",0.2]
[null,"Продажи",{"$f":"C5*(1+C9)","v":1200},{"$f":"C10/$C$10","v":1}]
[null,"Затраты",{"$f":"C10*D6","v":960},{"$f":"C11/$C$10","v":0.8}]
[null,"Прибыль",{"$f":"C10-C11","v":240},{"$f":"C12/$C$10","v":0.2}]
[]
[null,"Уменьшение затрат (%)",0.05]
[null,"Продажи",{"$f":"C5","v":1000},{"$f":"C15/$C$15","v":1}]
[null,"Затраты",{"$f":"C6*(1-C14)","v":760},{"$f":"C16/$C$15","v":0.76}]
[null,"Прибыль",{"$f":"C15-C16","v":240},{"$f":"C17/$C$15","v":0.24}]
[]
[null,"Ув. прибыли при ув. продаж",{"$f":"C12-C7","v":40},{"$f":"C19/C7","v":0.2}]
[null,"Ув. прибыли при ум. издержек",{"$f":"C17-C7","v":40},{"$f":"C20/C7","v":0.2}]
[null,"Сравнение увеличения прибыли",{"$f":"C19-C20","v":0}]