{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Paste Special","SUM","VBA"],"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":"Overview","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,4,13,4]]}
[]
[null,"Divide a Group of Cells by a Number"]
[]
[null,"Sale Rep","Product","Rev Earned","Number"]
[null,"Emma","PC",738441,12]
[null,"Justin","Laptop",673954]
[null,"Bob","HeadPhone",610204]
[null,"Jenifar","Mouse",679657]
[null,"Alin","Mobile",572913]
[null,"Roy","Laptop",574871]
[null,"Liz","Keyboard",572413]
[null,"Smith","Laptop",583388]
[null,"Robert","Mouse",692345]
[null,"Alin","Desktop",742644]

{"sheet":"Paste Special","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Paste Special to Divide Group of Cells"]
[]
[null,"Sale Rep","Product","Rev Earned","Number"]
[null,"Emma","PC",61536.75,12]
[null,"Justin","Laptop",56162.833333333336]
[null,"Bob","HeadPhone",50850.333333333336]
[null,"Jenifar","Mouse",56638.083333333336]
[null,"Alin","Mobile",47742.75]
[null,"Roy","Laptop",47905.916666666664]
[null,"Liz","Keyboard",47701.083333333336]
[null,"Smith","Laptop",48615.666666666664]
[null,"Robert","Mouse",57695.416666666664]
[null,"Alin","Desktop",61887]

{"sheet":"SUM","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,1,15,2],[16,1,16,2],[17,1,17,2]]}
[]
[null,"SUM Function to Divide a Group of Cells "]
[]
[null,"Sale Rep","Product","Rev Earned"]
[null,"Emma","PC",738441]
[null,"Justin","Laptop",673954]
[null,"Bob","HeadPhone",610204]
[null,"Jenifar","Mouse",679657]
[null,"Alin","Mobile",572913]
[null,"Roy","Laptop",574871]
[null,"Liz","Keyboard",572413]
[null,"Smith","Laptop",583388]
[null,"Robert","Mouse",692345]
[null,"Alin","Desktop",742644]
[]
[null,"Total Rev Earned",null,{"$f":"SUM(D5:D14)","v":6440830}]
[null,"Divide By",null,25]
[null,"Result",null,{"$f":"D16/D17","v":257633.2}]

{"sheet":"VBA","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Run a VBA Code to Divide a Group of Cells"]
[]
[null,"Sale Rep","Product","Rev Earned"]
[null,"Emma","PC",36922.050000000003]
[null,"Justin","Laptop",33697.699999999997]
[null,"Bob","HeadPhone",30510.2]
[null,"Jenifar","Mouse",33982.85]
[null,"Alin","Mobile",28645.65]
[null,"Roy","Laptop",28743.55]
[null,"Liz","Keyboard",28620.65]
[null,"Smith","Laptop",29169.4]
[null,"Robert","Mouse",34617.25]
[null,"Alin","Desktop",37132.199999999997]