{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Ungroup_1","Ungroup_2","Ungroup_3","Delete Formula","Query Remove","Disabling Formula Replication","Cell Mirroring "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Informations"]
[]
[null,"Product Id","Quantity","Cost","Revenue","Profit"]
[null,"A-051456",35,27475,29000,{"$f":"E5-D5","v":1525}]
[null,"A-021547",54,355428,356890,{"$f":"E6-D6","v":1462}]
[null,"A-031021",45,7020,7500,480]
[null,"C-012145",73,9500,10000,500]
[null,"B-000154",85,3825,4825,1000]
[null,"A-032145",15,4265,5500,1235]
[null,"C-001458",95,24130,32520,8390]
[null,"D-562314",82,21730,23000,1270]
[null,"F-652154",25,625,725,100]

{"sheet":"Ungroup_1","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Preventing Cell Mirroring"]
[]
[null,"Product Id","Quantity","Cost","Revenue","Profit"]
[null,"A-051456",35,27475,29000,{"$f":"E5-D5","v":1525}]
[null,"A-021547",54,355428,356890,{"$f":"E6-D6","v":1462}]
[null,"A-031021",45,7020,7500,480]
[null,"C-012145",73,9500,10000,500]
[null,"B-000154",85,3825,4825,1000]
[null,"A-032145",15,4265,5500,1235]
[null,"C-001458",95,24130,32520,8390]
[null,"D-562314",82,21730,23000,1270]
[null,"F-652154",25,625,725,100]

{"sheet":"Ungroup_2","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Preventing Cell Mirroring"]
[]
[null,"Product Id","Quantity","Cost","Revenue","Profit"]
[null,"A-051456",35,27475,29000,{"$f":"E5-D5","v":1525}]
[null,"A-021547",54,355428,356890,{"$f":"E6-D6","v":1462}]
[null,"A-031021",45,7020,7500,480]
[null,"C-012145",73,9500,10000,500]
[null,"B-000154",85,3825,4825,1000]
[null,"A-032145",15,4265,5500,1235]
[null,"C-001458",95,24130,32520,8390]
[null,"D-562314",82,21730,23000,1270]
[null,"F-652154",25,625,725,100]

{"sheet":"Ungroup_3","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Preventing Cell Mirroring"]
[]
[null,"Product Id","Quantity","Cost","Revenue","Profit"]
[null,"A-051456",35,27475,29000,{"$f":"E5-D5","v":1525}]
[null,"A-021547",54,355428,356890,{"$f":"E6-D6","v":1462}]
[null,"A-031021",45,7020,7500,480]
[null,"C-012145",73,9500,10000,500]
[null,"B-000154",85,3825,4825,1000]
[null,"A-032145",15,4265,5500,1235]
[null,"C-001458",95,24130,32520,8390]
[null,"D-562314",82,21730,23000,1270]
[null,"F-652154",25,625,725,100]

{"sheet":"Delete Formula","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Modifying Formulas Across Worksheet"]
[]
[null,"Product Id","Quantity","Cost","Revenue","Profit","Formula Used"]
[null,"A-051456",35,27475,29000,{"$f":"E5-D5","v":1525},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=E5-D5"}]
[null,"A-021547",54,355428,356890,{"$f":"E6-D6","v":1462},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=E6-D6"}]
[null,"A-031021",45,7020,7500,480,{"$f":"_xlfn.FORMULATEXT(F7)","v":"=E7-D7"}]
[null,"C-012145",73,9500,10000,500,"=E8-D8"]
[null,"B-000154",85,3825,4825,1000,"=E9-D9"]
[null,"A-032145",15,4265,5500,1235,"=E10-D10"]
[null,"C-001458",95,24130,32520,8390,"=E11-D11"]
[null,"D-562314",82,21730,23000,1270,"=E12-D12"]
[null,"F-652154",25,625,725,100,"=E13-D13"]

{"sheet":"Query Remove","index":5,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Deleting External Data Link "]
[]
[null,"Creating Thermometer Chart","F2","F3","F4","F5",null,null,"Creating Thermometer Chart","F2","F3","F4","F5"]
[]
[null,"Product Id",null,null,null,null,null,null,"Product Id"]
[null,"A-051456",35,27475,29000,1525,null,null,"A-051456",35,27475,29000,1525]
[null,"A-021547",54,355428,356890,1462,null,null,"A-021547",54,355428,356890,1462]
[null,"A-031021",45,7020,7500,480,null,null,"A-031021",45,7020,7500,480]
[null,"C-012145",73,10585,10595,10,null,null,"C-012145",73,10585,10595,10]
[null,"B-000154",85,3825,3550,3525,null,null,"B-000154",85,3825,3550,3525]
[null,"A-032145",15,5265,6500,1235,null,null,"A-032145",15,5265,6500,1235]
[null,"C-001458",95,24130,32520,8390,null,null,"C-001458",95,24130,32520,8390]
[null,"D-562314",82,21730,23000,1270,null,null,"D-562314",82,21730,23000,1270]
[null,"F-652154",25,625,725,100,null,null,"F-652154",25,625,725,100]
[null,null,null,null,null,17997,null,null,null,null,null,null,17997]
[null,null,null,null,null,20000,null,null,null,null,null,null,20000]
[]
[null,"Achieved",0.89985000000000004,null,null,null,null,null,"Achieved",0.89985000000000004]
[null,"Completion Target",1,null,null,null,null,null,"Completion Target",1]

{"sheet":"Disabling Formula Replication","index":6,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Preventing Cell Mirroring in Excel Table"]
[]
[null,"Product Id","Quantity","Cost","Revenue","Profit","Bonus","Formula Used"]
[null,"A-051456",35,27475,29000,{"$f":"E5-D5","v":1525},{"$f":"0.05*F5","v":76.25},{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F5"}]
[null,"A-021547",54,355428,356890,{"$f":"E6-D6","v":1462},73.100000000000009,{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F6"}]
[null,"A-031021",45,7020,7500,480,24,{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F7"}]
[null,"C-012145",73,9500,10000,500,25,{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F8"}]
[null,"B-000154",85,3825,4825,1000,{"$f":"0.02*F9","v":20},{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.02*F9"}]
[null,"A-032145",15,4265,5500,1235,61.75,{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F10"}]
[null,"C-001458",95,24130,32520,8390,419.5,{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F11"}]
[null,"D-562314",82,21730,23000,1270,63.5,{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F12"}]
[null,"F-652154",25,625,725,100,5,{"$f":"_xlfn.FORMULATEXT(Table7[[#This Row],[Bonus]])","v":"=0.05*F13"}]

{"sheet":"Cell Mirroring ","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using User Defined Function"]
[]
[null,"Product Id","Mirrored Text","Original Text"]
[null,"A-051456",{"$f":"Stop_Cell_Mirror(B5)","v":"654150-A"},{"$f":"Stop_Cell_Mirror(C5)","v":"A-051456"}]
[null,"A-021547",{"$f":"Stop_Cell_Mirror(B6)","v":"745120-A"},{"$f":"Stop_Cell_Mirror(C6)","v":"A-021547"}]
[null,"A-031021",{"$f":"Stop_Cell_Mirror(B7)","v":"120130-A"},{"$f":"Stop_Cell_Mirror(C7)","v":"A-031021"}]
[null,"C-012145",{"$f":"Stop_Cell_Mirror(B8)","v":"541210-C"},{"$f":"Stop_Cell_Mirror(C8)","v":"C-012145"}]
[null,"B-000154",{"$f":"Stop_Cell_Mirror(B9)","v":"451000-B"},{"$f":"Stop_Cell_Mirror(C9)","v":"B-000154"}]
[null,"A-032145",{"$f":"Stop_Cell_Mirror(B10)","v":"541230-A"},{"$f":"Stop_Cell_Mirror(C10)","v":"A-032145"}]
[null,"C-001458",{"$f":"Stop_Cell_Mirror(B11)","v":"854100-C"},{"$f":"Stop_Cell_Mirror(C11)","v":"C-001458"}]
[null,"D-562314",{"$f":"Stop_Cell_Mirror(B12)","v":"413265-D"},{"$f":"Stop_Cell_Mirror(C12)","v":"D-562314"}]
[null,"F-652154",{"$f":"Stop_Cell_Mirror(B13)","v":"451256-F"},{"$f":"Stop_Cell_Mirror(C13)","v":"F-652154"}]