{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["MsgBox","Variables in MsgBox","Adding Ampersand","Using Add Operator","Variables in Multiple Lines","Do Until Loop","Multiple Corresponding Values","Buttons","Icon","Modal","Two Values from Different Cells","User Input Value as Variable"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":36,"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":"MsgBox","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,15]]}
[]
[null,"Using Do Until Loop",null,null,null,null,null,null,null,null,null,null,"Creating MsgBox"]
[]
[null,"ID No","Name","Age",null,null,null,null,null,null,null,null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,null,null,null,null,null,null,null,null,1101,"Ron",12,90]
[null,1102,"Harry",11,null,null,null,null,null,null,null,null,1102,"Harry",11,85]
[null,1103,"Edward",13,null,null,null,null,null,null,null,null,1103,"Edward",13,100]
[null,1104,"Emma",12,null,null,null,null,null,null,null,null,1104,"Emma",12,120]
[null,1105,"Jack",12,null,null,null,null,null,null,null,null,1105,"Jack",12,105]
[null,1106,"Smith",13,null,null,null,null,null,null,null,null,1106,"Smith",13,95]

{"sheet":"Variables in MsgBox","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Showing Variables in MsgBox"]
[]
[null,"Product","Sales (Jan)","Sales (Feb)"]
[null,"Shirt",100,65]
[null,"Pant",160,100]
[null,"Jacket",140,200]
[null,"Trouser",120,160]
[null,"Shoes",200,210]
[]
[null,"Total Sales in Jan",{"$f":"SUM(C5:C9)","v":720}]
[null,"Total Sales in Feb",{"$f":"SUM(D5:D9)","v":735}]

{"sheet":"Adding Ampersand","index":2,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,15]]}
[]
[null,"Using Do Until Loop",null,null,null,null,null,null,null,null,null,null,"Adding Ampersand"]
[]
[null,"ID No","Name","Age",null,null,null,null,null,null,null,null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,null,null,null,null,null,null,null,null,1101,"Ron",12,90]
[null,1102,"Harry",11,null,null,null,null,null,null,null,null,1102,"Harry",11,85]
[null,1103,"Edward",13,null,null,null,null,null,null,null,null,1103,"Edward",13,100]
[null,1104,"Emma",12,null,null,null,null,null,null,null,null,1104,"Emma",12,120]
[null,1105,"Jack",12,null,null,null,null,null,null,null,null,1105,"Jack",12,105]
[null,1106,"Smith",13,null,null,null,null,null,null,null,null,1106,"Smith",13,95]

{"sheet":"Using Add Operator","index":3,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,15]]}
[]
[null,"Using Do Until Loop",null,null,null,null,null,null,null,null,null,null,"Using Add Operator"]
[]
[null,"ID No","Name","Age",null,null,null,null,null,null,null,null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,null,null,null,null,null,null,null,null,1101,"Ron",12,90]
[null,1102,"Harry",11,null,null,null,null,null,null,null,null,1102,"Harry",11,85]
[null,1103,"Edward",13,null,null,null,null,null,null,null,null,1103,"Edward",13,100]
[null,1104,"Emma",12,null,null,null,null,null,null,null,null,1104,"Emma",12,120]
[null,1105,"Jack",12,null,null,null,null,null,null,null,null,1105,"Jack",12,105]
[null,1106,"Smith",13,null,null,null,null,null,null,null,null,1106,"Smith",13,95]

{"sheet":"Variables in Multiple Lines","index":4,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,15]]}
[]
[null,"Using Do Until Loop",null,null,null,null,null,null,null,null,null,null,"Showing Variables in Multiple Lines"]
[]
[null,"ID No","Name","Age",null,null,null,null,null,null,null,null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,null,null,null,null,null,null,null,null,1101,"Ron",12,90]
[null,1102,"Harry",11,null,null,null,null,null,null,null,null,1102,"Harry",11,85]
[null,1103,"Edward",13,null,null,null,null,null,null,null,null,1103,"Edward",13,100]
[null,1104,"Emma",12,null,null,null,null,null,null,null,null,1104,"Emma",12,120]
[null,1105,"Jack",12,null,null,null,null,null,null,null,null,1105,"Jack",12,105]
[null,1106,"Smith",13,null,null,null,null,null,null,null,null,1106,"Smith",13,95]

{"sheet":"Do Until Loop","index":5,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,15]]}
[]
[null,"Using Do Until Loop",null,null,null,null,null,null,null,null,null,null,"Using Do Until Loop"]
[]
[null,"ID No","Name","Age",null,null,null,null,null,null,null,null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,null,null,null,null,null,null,null,null,1101,"Ron",12,90]
[null,1102,"Harry",11,null,null,null,null,null,null,null,null,1102,"Harry",11,85]
[null,1103,"Edward",13,null,null,null,null,null,null,null,null,1103,"Edward",13,100]
[null,1104,"Emma",12,null,null,null,null,null,null,null,null,1104,"Emma",12,120]
[null,1105,"Jack",12,null,null,null,null,null,null,null,null,1105,"Jack",12,105]
[null,1106,"Smith",13,null,null,null,null,null,null,null,null,1106,"Smith",13,95]

{"sheet":"Multiple Corresponding Values","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Returning Multiple Corresponding Variables"]
[]
[null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,90]
[null,1102,"Harry",11,85]
[null,1103,"Edward",13,100]
[null,1104,"Emma",12,120]
[null,1105,"Jack",12,105]
[null,1106,"Smith",13,95]

{"sheet":"Buttons","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating MsgBox with Buttons"]
[]
[null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,90]
[null,1102,"Harry",11,85]
[null,1103,"Edward",13,100]
[null,1104,"Emma",12,120]
[null,1105,"Jack",12,105]
[null,1106,"Smith",13,95]

{"sheet":"Icon","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating MsgBox with Icon"]
[]
[null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,90]
[null,1102,"Harry",11,85]
[null,1103,"Edward",13,100]
[null,1104,"Emma",12,120]
[null,1105,"Jack",12,105]
[null,1106,"Smith",13,95]

{"sheet":"Modal","index":9,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating Application & System Modal MsgBox"]
[]
[null,"ID No","Name","Age","Weight(lb)"]
[null,1101,"Ron",12,90]
[null,1102,"Harry",11,85]
[null,1103,"Edward",13,100]
[null,1104,"Emma",12,120]
[null,1105,"Jack",12,105]
[null,1106,"Smith",13,95]

{"sheet":"Two Values from Different Cells","index":10,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Displaying Two Values from Different Cells"]
[]
[null,"Product","Sales (Jan)","Sales (Feb)"]
[null,"Shirt",100,65]
[null,"Pant",150,100]
[null,"Jacket",360,200]
[null,"Trouser",200,160]
[null,"Shoes",300,210]
[]
[null,"Total Sales in Jan",{"$f":"SUM(C5:C9)","v":1110}]
[null,"Total Sales in Feb",{"$f":"SUM(D5:D9)","v":735}]

{"sheet":"User Input Value as Variable","index":11,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Returning User Input Value as Variable"]
[]
[null,"Product","Sales (Jan)","Sales (Feb)"]
[null,"Shirt",100,65]
[null,"Pant",150,100]
[null,"Jacket",360,200]
[null,"Trouser",200,160]
[null,"Shoes",300,210]
[]
[null,"Total Sales in Jan",{"$f":"SUM(C5:C9)","v":1110}]
[null,"Total Sales in Feb",{"$f":"SUM(D5:D9)","v":735}]