{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset-1","Dataset-2","Dataset-3","Percent Range","Percent Relative Range(Formula)","Percent Relative Range(VBA)","Cell Range Percentage"],"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-1","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"ID","Name","Marks out of 120"]
[null,1,"Adam",79]
[null,2,"Lily",55]
[null,3,"Ramona",110]
[null,4,"Smith",88]
[null,5,"Will",67]
[null,6,"Alex",42]
[null,7,"Jerry",19]
[null,8,"Tom",101]

{"sheet":"Dataset-2","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Company","High Price","Low Price"]
[null,"Amazon.com Inc",188.65,101.26]
[null,"Meta Platforms Inc",384.33,169]
[null,"Microsoft Corp",349.67,246.44]
[null,"Apple Inc",182.94,124.83]
[null,"Sony Group Corp",133.75,79.94]

{"sheet":"Dataset-3","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"ID","Employee Name","Status"]
[null,1,"Adam","Active"]
[null,2,"Chris","Active"]
[null,3,"Joana","Inactive"]
[null,4,"Wanda","Active"]
[null,5,"Scarlet","Active"]
[null,6,"Will","Inactive"]
[null,7,"Tom","Active"]
[null,8,"Sylvia","Active"]
[null,9,"Serena","Active"]
[null,10,"Helen","Inactive"]

{"sheet":"Percent Range","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,3,3,4],[3,1,4,1],[3,2,4,2],[1,1,1,4]]}
[]
[null,"Calculating Percent Range Using IF Function"]
[]
[null,"ID","Name","Result "]
[null,null,null,"Marks out of 120","Percentage Range"]
[null,1,"Adam",79,{"$f":"IF((D6/120)*100=100,\"A\",IF(AND((D6/120)*100>=80,(D6/120)*100<100),\"80%-100%\",IF(AND((D6/120)*100>=33,(D6/120)*100<80),\"33%-79%\",IF(AND((D6/120)*100>=0,(D6/120)*100<33),\"F\"))))","v":"33%-79%"}]
[null,2,"Lily",55,{"$f":"IF((D7/120)*100=100,\"A\",IF(AND((D7/120)*100>=80,(D7/120)*100<100),\"80%-100%\",IF(AND((D7/120)*100>=33,(D7/120)*100<80),\"33%-79%\",IF(AND((D7/120)*100>=0,(D7/120)*100<33),\"F\"))))","v":"33%-79%"}]
[null,3,"Ramona",110,"80%-100%"]
[null,4,"Smith",88,"33%-79%"]
[null,5,"Will",67,"33%-79%"]
[null,6,"Alex",42,"33%-79%"]
[null,7,"Jerry",19,{"$f":"IF((D12/120)*100=100,\"A\",IF(AND((D12/120)*100>=80,(D12/120)*100<100),\"80%-100%\",IF(AND((D12/120)*100>=33,(D12/120)*100<80),\"33%-79%\",IF(AND((D12/120)*100>=0,(D12/120)*100<33),\"0%-32%\"))))","v":"0%-32%"}]
[null,8,"Tom",101,"80%-100%"]

{"sheet":"Percent Relative Range(Formula)","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Arithmetic Formula to Calculate Percent Relative Change"]
[]
[null,"Company","High Price","Low Price","Percentage Relative Range (%)"]
[null,"Amazon.com Inc",188.65,101.26,{"$f":"((C5-D5)/((C5+D5)/2))*100","v":60.287675485495498}]
[null,"Meta Platforms Inc",384.33,169,{"$f":"((C6-D6)/((C6+D6)/2))*100","v":77.83058934089965}]
[null,"Microsoft Corp",349.67,246.44,34.63454731509286]
[null,"Apple Inc",182.94,124.83,37.761965103811292]
[null,"Sony Group Corp",133.75,79.94,50.362674902896721]

{"sheet":"Percent Relative Range(VBA)","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA Code to Calculate Percent Relative Change"]
[]
[null,"Company","High Price","Low Price","Percentage Relative Range (%)"]
[null,"Amazon.com Inc",188.65,101.26,{"$f":"PercentRelativeRng(C5,D5)","v":60.287675485495498}]
[null,"Meta Platforms Inc",384.33,169,{"$f":"PercentRelativeRng(C6,D6)","v":77.83058934089965}]
[null,"Microsoft Corp",349.67,246.44,34.63454731509286]
[null,"Apple Inc",182.94,124.83,37.761965103811292]
[null,"Sony Group Corp",133.75,79.94,50.362674902896721]

{"sheet":"Cell Range Percentage","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Calculation of Cell Range Percentage"]
[]
[null,"ID","Employee Name","Status"]
[null,1,"Adam","Active"]
[null,2,"Chris","Active"]
[null,3,"Joana","Inactive",null,"Active Percentage",{"$f":"((COUNTIFS(D5:D14,\"Active\"))/(COUNTA(D5:D14)))*100 & \"%\"","v":"70%"}]
[null,4,"Wanda","Active",null,"Inactive Percentage",{"$f":"((COUNTIFS(D5:D14,\"Inactive\"))/(COUNTA(D5:D14)))*100 & \"%\"","v":"30%"}]
[null,5,"Scarlet","Active"]
[null,6,"Will","Inactive"]
[null,7,"Tom","Active"]
[null,8,"Sylvia","Active"]
[null,9,"Serena","Active"]
[null,10,"Helen","Inactive"]