{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Data","Use of For Next Loop","Deleting Empty Row","Inserting ID","Finding Extension","Color Alternate Row","Square Number","Use of Exit For","Use of For Each Loop","Practice Section"],"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":"Data","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset"]
[]
[null,"ID","Full Name","Email Address","Gender","Age"]
[null,"E03637","Landon Thao","Landon25@gmail.com","Male",25]
[null,"E03455","Hadley Ford","Hadley2012@gmail.com","Female",52]
[null,"E03354","Austin Brown","Austin@outlook.com","Male",48]
[null,"E03362","Lily Henderson",null,"Female",61]
[null,"E02135","John Delgado",null,"Male",30]
[null,"E02274","Isabella Bailey","isabella.bailey@outlook.com","Female",36]
[null,"E02848","Lincoln Huynh","huynh.1997@yahoo.com ","Male",55]
[null,"E00480","Hadley Yee","hadley-yee@outlook.com","Female",31]
[null,"E00203","Julia Doan","julia10@gmail.com","Female",53]
[null,"E03902","Madison Hunter",null,"Female",40]
[null,"E01225","Christian Fong","christian.fong@hotmail.com","Male",49]
[null,"E01264","Hazel Alvarez","hazel@yahoo.com","Female",62]

{"sheet":"Use of For Next Loop","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of For Next Loop"]
[]
[null,"ID","Full Name","Email Address","Gender","Age"]
[null,"E03637","Landon Thao","Landon25@gmail.com","Male",25]
[null,"E03455","Hadley Ford","Hadley2012@gmail.com","Female",52]
[null,"E03354","Austin Brown","Austin@outlook.com","Male",48]
[null,"E03362","Lily Henderson",null,"Female",61]
[null,"E02135","John Delgado",null,"Male",30]
[null,"E02274","Isabella Bailey","isabella.bailey@outlook.com","Female",36]
[null,"E02848","Lincoln Huynh","huynh.1997@yahoo.com ","Male",55]
[null,"E00480","Hadley Yee","hadley-yee@outlook.com","Female",31]
[null,"E00203","Julia Doan","julia10@gmail.com","Female",53]
[null,"E03902","Madison Hunter",null,"Female",40]
[null,"E01225","Christian Fong","christian.fong@hotmail.com","Male",49]
[null,"E01264","Hazel Alvarez","hazel@yahoo.com","Female",62]

{"sheet":"Deleting Empty Row","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Removing Empty Rows with Reverse For Next Loop"]
[]
[null,"ID","Full Name","Email Address","Gender","Age"]
[null,"E03637","Landon Thao","Landon25@gmail.com","Male",25]
[null,"E03455","Hadley Ford","Hadley2012@gmail.com","Female",52]
[null,"E03354","Austin Brown","Austin@outlook.com","Male",48]
[null,"E02274","Isabella Bailey","isabella.bailey@outlook.com","Female",36]
[null,"E02848","Lincoln Huynh","huynh.1997@yahoo.com ","Male",55]
[null,"E00480","Hadley Yee","hadley-yee@outlook.com","Female",31]
[null,"E00203","Julia Doan","julia10@gmail.com","Female",53]
[null,"E01225","Christian Fong","christian.fong@hotmail.com","Male",49]
[null,"E01264","Hazel Alvarez","hazel@yahoo.com","Female",62]

{"sheet":"Inserting ID","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting ID from Bottom to Top Through For Next Loop"]
[]
[null,"Full Name","Email Address","Gender","ID"]
[null,"Landon Thao","Landon25@gmail.com","Male","OGR1"]
[null,"Hadley Ford","Hadley2012@gmail.com","Female","OGR2"]
[null,"Austin Brown","Austin@outlook.com","Male","OGR3"]
[null,"Isabella Bailey","isabella.bailey@outlook.com","Female","OGR4"]
[null,"Lincoln Huynh","huynh.1997@yahoo.com ","Male","OGR5"]
[null,"Hadley Yee","hadley-yee@outlook.com","Female","OGR6"]
[null,"Julia Doan","julia10@gmail.com","Female","OGR7"]
[null,"Christian Fong","christian.fong@hotmail.com","Male","OGR8"]
[null,"Hazel Alvarez","hazel@yahoo.com","Female","OGR9"]

{"sheet":"Finding Extension","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding Extension of Address from User Input "]
[]
[null,"Full Name","Email Address","Gender","Age"]
[null,"Landon Thao","Landon25@gmail.com","Male",25]
[null,"Hadley Ford","Hadley2012@gmail.com","Female",52]
[null,"Austin Brown","Austin@outlook.com","Male",48]
[null,"Isabella Bailey","isabella.bailey@outlook.com","Female",36]
[null,"Lincoln Huynh","huynh.1997@yahoo.com ","Male",55]
[null,"Hadley Yee","hadley-yee@outlook.com","Female",31]
[null,"Julia Doan","julia10@gmail.com","Female",53]
[null,"Christian Fong","christian.fong@hotmail.com","Male",49]
[null,"Hazel Alvarez","hazel@yahoo.com","Female",62]

{"sheet":"Color Alternate Row","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using For Next Loop with Step Backwards to Color Alternate Rows"]
[]
[null,"ID","Full Name","Email Address","Gender","Age"]
[null,"E03637","Landon Thao","Landon25@gmail.com","Male",25]
[null,"E03455","Hadley Ford","Hadley2012@gmail.com","Female",52]
[null,"E03354","Austin Brown","Austin@outlook.com","Male",48]
[null,"E02274","Isabella Bailey","isabella.bailey@outlook.com","Female",36]
[null,"E02848","Lincoln Huynh","huynh.1997@yahoo.com ","Male",55]
[null,"E00480","Hadley Yee","hadley-yee@outlook.com","Female",31]
[null,"E00203","Julia Doan","julia10@gmail.com","Female",53]
[null,"E01225","Christian Fong","christian.fong@hotmail.com","Male",49]
[null,"E01264","Hazel Alvarez","hazel@yahoo.com","Female",62]

{"sheet":"Square Number","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Non-Integer Step in For Loop to Find Square of Number "]
[]
[null,"Numbers","Squares"]
[null,7,49]
[null,6.5,42.25]
[null,6,36]
[null,5.5,30.25]
[null,5,25]
[null,4.5,20.25]
[null,4,16]
[null,3.5,12.25]
[null,3,9]
[null,2.5,6.25]
[null,2,4]
[null,1.5,2.25]
[null,1,1]

{"sheet":"Use of Exit For","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Exiting For Next Loop"]
[]
[null,"ID","Full Name","Email Address","Extension"]
[null,"E03637","Landon Thao","Landon25@gmail.com","gmail.com"]
[null,"E03455","Hadley Ford","Hadley2012@gmail.com","gmail.com"]
[null,"E03354","Austin Brown","Austin@outlook.com","outlook.com"]
[null,"E02274","Isabella Bailey","isabella.bailey@outlook.com","outlook.com"]
[null,"E02848","Lincoln Huynh","huynh.1997@yahoo.com ","yahoo.com "]
[null,"E03902","Madison Hunter"]
[null,"E00480","Hadley Yee","hadley-yee@outlook.com","outlook.com"]
[null,"E00203","Julia Doan","julia10@gmail.com","gmail.com"]
[null,"E01225","Christian Fong","christian.fong@hotmail.com","hotmail.com"]
[null,"E01264","Hazel Alvarez","hazel@yahoo.com","yahoo.com"]

{"sheet":"Use of For Each Loop","index":8,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of For Each Loop"]
[]
[null,"ID","Full Name","Email Address","Gender"]
[null,"E03637","Landon Thao","Landon25@gmail.com","Male"]
[null,"E03455","Hadley Ford","Hadley2012@gmail.com","Female"]
[null,"E03354","Austin Brown","Austin@outlook.com","Male"]
[null,"E03362","Lily Henderson",null,"Female"]
[null,"E02135","John Delgado",null,"Male"]
[null,"E02274","Isabella Bailey","isabella.bailey@outlook.com","Female"]
[null,"E02848","Lincoln Huynh","huynh.1997@yahoo.com ","Male"]
[null,"E00480","Hadley Yee","hadley-yee@outlook.com","Female"]
[null,"E00203","Julia Doan","julia10@gmail.com","Female"]
[null,"E03902","Madison Hunter",null,"Female"]
[null,"E01225","Christian Fong","christian.fong@hotmail.com","Male"]
[null,"E01264","Hazel Alvarez","hazel@yahoo.com","Female"]

{"sheet":"Practice Section","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Do It Yourself"]
[]
[null,"ID","Full Name","Email Address","Gender","Age"]
[null,"E03637","Landon Thao","Landon25@gmail.com","Male",25]
[null,"E03455","Hadley Ford","Hadley2012@gmail.com","Female",52]
[null,"E03354","Austin Brown","Austin@outlook.com","Male",48]
[null,"E03362","Lily Henderson",null,"Female",61]
[null,"E02135","John Delgado",null,"Male",30]
[null,"E02274","Isabella Bailey","isabella.bailey@outlook.com","Female",36]
[null,"E02848","Lincoln Huynh","huynh.1997@yahoo.com ","Male",55]
[null,"E00480","Hadley Yee","hadley-yee@outlook.com","Female",31]
[null,"E00203","Julia Doan","julia10@gmail.com","Female",53]
[null,"E03902","Madison Hunter",null,"Female",40]
[null,"E01225","Christian Fong","christian.fong@hotmail.com","Male",49]
[null,"E01264","Hazel Alvarez","hazel@yahoo.com","Female",62]