{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Approach 1","Approach 2","Approach 3","Approach 4","Approach 5","Increase From 0"],"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":"Dataset","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Revenue Comparison"]
[]
[null,"Name ","Revenue (Last Year)","Revenue (This Year)","Change","% Change"]
[null,"James",-2000,-1500,{"$f":"D6-C6","v":500}]
[null,"Christina",5000,-3950,{"$f":"D7-C7","v":-8950}]
[null,"Bell",-4500,-4300,200]
[null,"John",4350,3500,-850]
[null,"Nox",-2500,2135,4635]
[null,"Patty",3000,-1800,-4800]

{"sheet":"Approach 1","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Revenue Comparison"]
[]
[null,"Name ","Revenue (Last Year)","Revenue (This Year)","Change","% Change"]
[null,"James",2000,-1500,{"$f":"D6-C6","v":-3500},{"$f":"(D6-C6)/C6","v":-1.75}]
[null,"Christina",5000,-3950,{"$f":"D7-C7","v":-8950},{"$f":"(D7-C7)/C7","v":-1.79}]
[null,"Bell",4500,-4300,-8800,-1.9555555555555555]
[null,"John",4350,-3500,-7850,-1.8045977011494252]
[null,"Nox",2500,-2135,-4635,-1.8540000000000001]
[null,"Patty",3000,-1800,-4800,-1.6]

{"sheet":"Approach 2","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Revenue Comparison"]
[]
[null,"Name ","Revenue (Last Year)","Revenue (This Year)","Change","% Change"]
[null,"James",-2000,-1500,{"$f":"D6-C6","v":500},{"$f":"(D6-C6)/ABS(C6)","v":0.25}]
[null,"Christina",-5000,-3950,{"$f":"D7-C7","v":1050},{"$f":"(D7-C7)/ABS(C7)","v":0.21}]
[null,"Bell",-4500,-4300,200,4.4444444444444446E-2]
[null,"John",-4350,-3500,850,0.19540229885057472]
[null,"Nox",-2500,-2135,365,0.14599999999999999]
[null,"Patty",-3000,-1800,1200,0.4]

{"sheet":"Approach 3","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Revenue Comparison"]
[]
[null,"Name ","Revenue (Last Year)","Revenue (This Year)","Change","% Change"]
[null,"James",2000,-1500,{"$f":"D6-C6","v":-3500},{"$f":"IF(MIN(C6,D6)<=0,\"No Result\",(D6/C6)-1)","v":"No Result"}]
[null,"Christina",5000,3950,{"$f":"D7-C7","v":-1050},{"$f":"IF(MIN(C7,D7)<=0,\"No Result\",(D7/C7)-1)","v":-0.20999999999999996}]
[null,"Bell",-4500,-4300,200,"No Result"]
[null,"John",4350,3500,-850,-0.1954022988505747]
[null,"Nox",-2500,-2135,365,"No Result"]
[null,"Patty",3000,-1800,-4800,"No Result"]

{"sheet":"Approach 4","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Revenue Comparison"]
[]
[null,"Name ","Revenue (Last Year)","Revenue (This Year)","Change","% Change"]
[null,"James",-2000,-1500,{"$f":"D6-C6","v":500},{"$f":"IF(MIN(C6,D6)<=0,IF((D6-C6)>0,\"Positive\",\"Negative\"),(D6/C6)-1)","v":"Positive"}]
[null,"Christina",5000,-3950,{"$f":"D7-C7","v":-8950},{"$f":"IF(MIN(C7,D7)<=0,IF((D7-C7)>0,\"Positive\",\"Negative\"),(D7/C7)-1)","v":"Negative"}]
[null,"Bell",-4500,-4300,200,"Positive"]
[null,"John",4350,3500,-850,-0.1954022988505747]
[null,"Nox",-2500,2135,4635,"Positive"]
[null,"Patty",3000,-1800,-4800,"Negative"]

{"sheet":"Approach 5","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Revenue Comparison"]
[]
[null,"Name ","Revenue (Last Year)","Revenue (This Year)","Change","% Change"]
[null,"James",-2000,-1500,{"$f":"D6-C6","v":500}]
[null,"Christina",5000,-3950,{"$f":"D7-C7","v":-8950}]
[null,"Bell",-4500,-4300,200]
[null,"John",4350,3500,-850]
[null,"Nox",-2500,2135,4635]
[null,"Patty",3000,-1800,-4800]

{"sheet":"Increase From 0","index":6,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Bell's Yearly Profit"]
[]
[null,"Year","Profit","Change (%)"]
[null,2010,1503]
[null,2011,0,{"$f":"IF(C6=0,SIGN(C7),C7/C6-1)","v":-1}]
[null,2012,1600,{"$f":"IF(C7=0,SIGN(C8),C8/C7-1)","v":1}]
[null,2013,1400,-0.125]
[null,2014,1325,-5.3571428571428603E-2]
[null,2015,1873,0.41358490566037731]
[null,2016,2000,6.780565936999472E-2]
[null,2017,1900,-5.0000000000000044E-2]
[null,2018,1832,-3.5789473684210482E-2]
[null,2019,1500,-0.18122270742358082]
[null,2020,950,-0.3666666666666667]
[null,2021,1005,5.7894736842105221E-2]