{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Using Mathematical Formula","Specific Value","Using VBA","Both Values Negative","New Values Negative","Determine Values after Change","Percentage Decrease","Percentage Increase"],"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":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Percentage Decrease"]
[]
[null,"Brand","Device","Old Price","New Price"]
[null,"Omicron","Desktop",980,900]
[null,"Codemy","Notebook",650,500]
[null,"Gamind","Desktop",870,860]
[null,"Inchip","Desktop",1020,700]
[null,"Bytec","Notebook",1100,750]
[null,"Omicron","Notebook",860,690]
[null,"Codemy","Desktop",490,270]
[null,"Gamind","Notebook",620,500]
[null,"Bytec","Desktop",780,700]
[null,"Omicron","Desktop",880,800]
[null,"Inchip","Notebook",670,500]
[null,"Omicron","Notebook",1200,1000]

{"sheet":"Using Mathematical Formula","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Mathematical Formula",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Brand","Device","Old Price","New Price","% Change",null,null,null,null,null,"Brand","Device","Old Price","New Price","% Change"]
[null,"Omicron","Desktop",980,900,{"$f":"(E5-D5)/D5","v":-8.1632653061224483E-2},null,null,null,null,null,"Omicron","Desktop",980,900]
[null,"Codemy","Notebook",650,500,{"$f":"(E6-D6)/D6","v":-0.23076923076923078},null,null,null,null,null,"Codemy","Notebook",650,500]
[null,"Gamind","Desktop",870,860,-1.1494252873563218E-2,null,null,null,null,null,"Gamind","Desktop",870,860]
[null,"Inchip","Desktop",1020,700,-0.31372549019607843,null,null,null,null,null,"Inchip","Desktop",1020,700]
[null,"Bytec","Notebook",1100,750,-0.31818181818181818,null,null,null,null,null,"Bytec","Notebook",1100,750]
[null,"Omicron","Notebook",860,690,-0.19767441860465115,null,null,null,null,null,"Omicron","Notebook",860,690]
[null,"Codemy","Desktop",490,270,-0.44897959183673469,null,null,null,null,null,"Codemy","Desktop",490,270]
[null,"Gamind","Notebook",620,500,-0.19354838709677419,null,null,null,null,null,"Gamind","Notebook",620,500]
[null,"Bytec","Desktop",780,700,-0.10256410256410256,null,null,null,null,null,"Bytec","Desktop",780,700]
[null,"Omicron","Desktop",880,800,-9.0909090909090912E-2,null,null,null,null,null,"Omicron","Desktop",880,800]
[null,"Inchip","Notebook",670,500,-0.2537313432835821,null,null,null,null,null,"Inchip","Notebook",670,500]
[null,"Omicron","Notebook",1200,1000,-0.16666666666666666,null,null,null,null,null,"Omicron","Notebook",1200,1000]

{"sheet":"Specific Value","index":2,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using Mathematical Formula",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Brand","Device","Old Price","New Price","% Change",null,null,null,null,null,"Brand","Device","Old Price","New Price","% Change"]
[null,"Omicron","Desktop",980,900,-8.1600000000000006E-2,null,null,null,null,null,"Omicron","Desktop",980,900]
[null,"Codemy","Notebook",650,500,-0.23080000000000001,null,null,null,null,null,"Codemy","Notebook",650,500]
[null,"Gamind","Desktop",870,860,-1.15E-2,null,null,null,null,null,"Gamind","Desktop",870,860]
[null,"Inchip","Desktop",1020,700,-0.31369999999999998,null,null,null,null,null,"Inchip","Desktop",1020,700]
[null,"Bytec","Notebook",1100,750,-0.31819999999999998,null,null,null,null,null,"Bytec","Notebook",1100,750]
[null,"Omicron","Notebook",860,690,-0.19769999999999999,null,null,null,null,null,"Omicron","Notebook",860,690]
[null,"Codemy","Desktop",490,270,-0.44900000000000001,null,null,null,null,null,"Codemy","Desktop",490,270]
[null,"Gamind","Notebook",620,500,-0.19350000000000001,null,null,null,null,null,"Gamind","Notebook",620,500]
[null,"Bytec","Desktop",780,700,-0.1026,null,null,null,null,null,"Bytec","Desktop",780,700]
[null,"Omicron","Desktop",880,800,-9.0899999999999995E-2,null,null,null,null,null,"Omicron","Desktop",880,800]
[null,"Inchip","Notebook",670,500,-0.25369999999999998,null,null,null,null,null,"Inchip","Notebook",670,500]
[null,"Omicron","Notebook",1200,1000,-0.16669999999999999,null,null,null,null,null,"Omicron","Notebook",1200,1000]
[]
[null,"Maximum Price",{"$f":"MAX(D5:D16)","v":1200}]

{"sheet":"Using VBA","index":3,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using VBA",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Brand","Device","Old Price","New Price","% Change",null,null,null,null,null,"Brand","Device","Old Price","New Price","% Change"]
[null,"Omicron","Desktop",980,900,-8.1600000000000006E-2,null,null,null,null,null,"Omicron","Desktop",980,900]
[null,"Codemy","Notebook",650,500,-0.23080000000000001,null,null,null,null,null,"Codemy","Notebook",650,500]
[null,"Gamind","Desktop",870,860,-1.15E-2,null,null,null,null,null,"Gamind","Desktop",870,860]
[null,"Inchip","Desktop",1020,700,-0.31369999999999998,null,null,null,null,null,"Inchip","Desktop",1020,700]
[null,"Bytec","Notebook",1100,750,-0.31819999999999998,null,null,null,null,null,"Bytec","Notebook",1100,750]
[null,"Omicron","Notebook",860,690,-0.19769999999999999,null,null,null,null,null,"Omicron","Notebook",860,690]
[null,"Codemy","Desktop",490,270,-0.44900000000000001,null,null,null,null,null,"Codemy","Desktop",490,270]
[null,"Gamind","Notebook",620,500,-0.19350000000000001,null,null,null,null,null,"Gamind","Notebook",620,500]
[null,"Bytec","Desktop",780,700,-0.1026,null,null,null,null,null,"Bytec","Desktop",780,700]
[null,"Omicron","Desktop",880,800,-9.0899999999999995E-2,null,null,null,null,null,"Omicron","Desktop",880,800]
[null,"Inchip","Notebook",670,500,-0.25369999999999998,null,null,null,null,null,"Inchip","Notebook",670,500]
[null,"Omicron","Notebook",1200,1000,-0.16669999999999999,null,null,null,null,null,"Omicron","Notebook",1200,1000]

{"sheet":"Both Values Negative","index":4,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Calculate Percentage Change for Negative Values",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"City","State","Old Temp","New Temp","% Change",null,null,null,null,null,null,"City","State","Old Temp","New Temp","% Change"]
[null,"New York","New York",-5.2,-6.4,{"$f":"(D5-E5)/D5","v":-0.23076923076923078},null,null,null,null,null,null,"New York","New York",-5.2,-6.4]
[null,"Los Angeles","California",-2.6,-3,{"$f":"(D6-E6)/D6","v":-0.1538461538461538},null,null,null,null,null,null,"Los Angeles","California",-2.6,-3]
[null,"Chicago","Illinois",-8.9,-9.5,-6.7415730337078608E-2,null,null,null,null,null,null,"Chicago","Illinois",-8.9,-9.5]
[null,"Miami","Florida",-1,-1.4,-0.39999999999999991,null,null,null,null,null,null,"Miami","Florida",-1,-1.4]
[null,"Seattle","Washington",-3.8,-4,-5.2631578947368474E-2,null,null,null,null,null,null,"Seattle","Washington",-3.8,-4]
[null,"Dallas","Texas",-1,-1.5,-0.5,null,null,null,null,null,null,"Dallas","Texas",-1,-1.5]

{"sheet":"New Values Negative","index":5,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Calculate Percentage Change for Negative Values",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"City","State","Old Temp","New Temp","% Change",null,null,null,null,null,null,"City","State","Old Temp","New Temp","% Change"]
[null,"New York","New York",3,-0.4,{"$f":"(E5-D5)/D5","v":-1.1333333333333333},null,null,null,null,null,null,"New York","New York",3,-0.4]
[null,"Los Angeles","California",2.6,-1,{"$f":"(E6-D6)/D6","v":-1.3846153846153846},null,null,null,null,null,null,"Los Angeles","California",2.6,-1]
[null,"Chicago","Illinois",8,-2.5,-1.3125,null,null,null,null,null,null,"Chicago","Illinois",8,-2.5]
[null,"Miami","Florida",10,-1.5,-1.1499999999999999,null,null,null,null,null,null,"Miami","Florida",10,-1.5]
[null,"Seattle","Washington",3.8,-2,-1.5263157894736843,null,null,null,null,null,null,"Seattle","Washington",3.8,-2]
[null,"Dallas","Texas",1,-1,-2,null,null,null,null,null,null,"Dallas","Texas",1,-1]

{"sheet":"Determine Values after Change","index":6,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,13,1,17]]}
[]
[null,"Determining Values after Percentage Increase or Decrease",null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Brand","Device","Old Price","% Change","New Price",null,null,null,null,null,null,null,"Brand","Device","Old Price","% Change","New Price"]
[null,"Omicron","Desktop",980,-0.1,{"$f":"D5*(1+E5)","v":882},null,null,null,null,null,null,null,"Omicron","Desktop",980,-0.1]
[null,"Codemy","Notebook",650,-0.15,{"$f":"D6*(1+E6)","v":552.5},null,null,null,null,null,null,null,"Codemy","Notebook",650,-0.15]
[null,"Gamind","Desktop",870,-0.05,826.5,null,null,null,null,null,null,null,"Gamind","Desktop",870,-0.05]
[null,"Inchip","Desktop",1020,-0.12,897.6,null,null,null,null,null,null,null,"Inchip","Desktop",1020,-0.12]
[null,"Bytec","Notebook",1100,-7.0000000000000007E-2,1022.9999999999999,null,null,null,null,null,null,null,"Bytec","Notebook",1100,-7.0000000000000007E-2]
[null,"Omicron","Notebook",860,-0.1,774,null,null,null,null,null,null,null,"Omicron","Notebook",860,-0.1]
[null,"Codemy","Desktop",490,-0.05,465.5,null,null,null,null,null,null,null,"Codemy","Desktop",490,-0.05]
[null,"Gamind","Notebook",620,-0.13,539.4,null,null,null,null,null,null,null,"Gamind","Notebook",620,-0.13]
[null,"Bytec","Desktop",780,-0.03,756.6,null,null,null,null,null,null,null,"Bytec","Desktop",780,-0.03]
[null,"Omicron","Desktop",880,-0.06,827.19999999999993,null,null,null,null,null,null,null,"Omicron","Desktop",880,-0.06]
[null,"Inchip","Notebook",670,-0.14000000000000001,576.20000000000005,null,null,null,null,null,null,null,"Inchip","Notebook",670,-0.14000000000000001]
[null,"Omicron","Notebook",1000,-0.1,900,null,null,null,null,null,null,null,"Omicron","Notebook",1000,-0.1]

{"sheet":"Percentage Decrease","index":7,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,14,1,17]]}
[]
[null,"Using Specific Percentage Decrease",null,null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Discount",0.12,null,null,null,null,null,null,null,null,null,null,null,"Discount",0.12]
[]
[null,"Brand","Device","Old Price","New Price",null,null,null,null,null,null,null,null,null,"Brand","Device","Old Price","New Price"]
[null,"Omicron","Desktop",980,{"$f":"D7*(1-$C$4)","v":862.4},null,null,null,null,null,null,null,null,null,"Omicron","Desktop",980]
[null,"Codemy","Notebook",650,{"$f":"D8*(1-$C$4)","v":572},null,null,null,null,null,null,null,null,null,"Codemy","Notebook",650]
[null,"Gamind","Desktop",870,765.6,null,null,null,null,null,null,null,null,null,"Gamind","Desktop",870]
[null,"Inchip","Desktop",1020,897.6,null,null,null,null,null,null,null,null,null,"Inchip","Desktop",1020]
[null,"Bytec","Notebook",1100,968,null,null,null,null,null,null,null,null,null,"Bytec","Notebook",1100]
[null,"Omicron","Notebook",860,756.8,null,null,null,null,null,null,null,null,null,"Omicron","Notebook",860]
[null,"Codemy","Desktop",490,431.2,null,null,null,null,null,null,null,null,null,"Codemy","Desktop",490]
[null,"Gamind","Notebook",620,545.6,null,null,null,null,null,null,null,null,null,"Gamind","Notebook",620]
[null,"Bytec","Desktop",780,686.4,null,null,null,null,null,null,null,null,null,"Bytec","Desktop",780]
[null,"Omicron","Desktop",880,774.4,null,null,null,null,null,null,null,null,null,"Omicron","Desktop",880]
[null,"Inchip","Notebook",670,589.6,null,null,null,null,null,null,null,null,null,"Inchip","Notebook",670]
[null,"Omicron","Notebook",1000,880,null,null,null,null,null,null,null,null,null,"Omicron","Notebook",1000]

{"sheet":"Percentage Increase","index":8,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Calculating Percentage Increase",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Brand","Device","Old Price","New Price","% Change",null,null,null,null,null,"Brand","Device","Old Price","New Price","% Change"]
[null,"Omicron","Desktop",980,1000,{"$f":"(E5-D5)/D5","v":2.0408163265306121E-2},null,null,null,null,null,"Omicron","Desktop",980,1000]
[null,"Codemy","Notebook",650,800,{"$f":"(E6-D6)/D6","v":0.23076923076923078},null,null,null,null,null,"Codemy","Notebook",650,800]
[null,"Gamind","Desktop",870,1000,0.14942528735632185,null,null,null,null,null,"Gamind","Desktop",870,1000]
[null,"Inchip","Desktop",1020,1200,0.17647058823529413,null,null,null,null,null,"Inchip","Desktop",1020,1200]
[null,"Bytec","Notebook",1100,1300,0.18181818181818182,null,null,null,null,null,"Bytec","Notebook",1100,1300]
[null,"Omicron","Notebook",860,900,4.6511627906976744E-2,null,null,null,null,null,"Omicron","Notebook",860,900]
[null,"Codemy","Desktop",490,550,0.12244897959183673,null,null,null,null,null,"Codemy","Desktop",490,550]
[null,"Gamind","Notebook",620,740,0.19354838709677419,null,null,null,null,null,"Gamind","Notebook",620,740]
[null,"Bytec","Desktop",780,870,0.11538461538461539,null,null,null,null,null,"Bytec","Desktop",780,870]
[null,"Omicron","Desktop",880,1200,0.36363636363636365,null,null,null,null,null,"Omicron","Desktop",880,1200]
[null,"Inchip","Notebook",670,850,0.26865671641791045,null,null,null,null,null,"Inchip","Notebook",670,850]
[null,"Omicron","Notebook",1200,1380,0.15,null,null,null,null,null,"Omicron","Notebook",1200,1380]