{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Main Dataset","Special Characters","MOD Function","MOD and ROW","ISEVEN","Every other row","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Main Dataset","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"XYZ\" Company"]
[]
[null,"Product","Size","Price"]
[null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870]
[null,"Shoe 1",6.5,1750]
[null,"Jacket 1","L",4500]
[null,"Jacket 2","XL",3500]
[null,"Shoe 2",7,5500]
[null,"Pant 1","XL",1200]
[null,"Pant 2","XXL",1230]
[null,"Shoe 3",7.5,1100]

{"sheet":"Special Characters","index":1,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,11]]}
[]
[null,"Using Special Characters",null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Size","Price",null,null,null,null,"Product","Size","Price","Delete"]
[null,"Shirt 1","L",1750,null,null,null,null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870,null,null,null,null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500,null,null,null,null,"Shoe 1",6.5,1750]
[null,"Jacket 2","XL",3500,null,null,null,null,"Jacket 1","L",4500]
[null,"Pant 1","XL",1200,null,null,null,null,"Jacket 2","XL",3500]
[null,"Pant 2","XXL",1230,null,null,null,null,"Shoe 2",7,5500]
[null,null,null,null,null,null,null,null,"Pant 1","XL",1200]
[null,null,null,null,null,null,null,null,"Pant 2","XXL",1230]
[null,null,null,null,null,null,null,null,"Shoe 3",7.5,1100]

{"sheet":"MOD Function","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,11]]}
[]
[null,"Using MOD function",null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Size","Price",null,null,null,null,"Product","Size","Price","Delete"]
[null,"Shirt 1","L",1750,null,null,null,null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870,null,null,null,null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500,null,null,null,null,"Shoe 1",6.5,1750]
[null,"Jacket 2","XL",3500,null,null,null,null,"Jacket 1","L",4500]
[null,"Pant 1","XL",1200,null,null,null,null,"Jacket 2","XL",3500]
[null,"Pant 2","XXL",1230,null,null,null,null,"Shoe 2",7,5500]
[null,null,null,null,null,null,null,null,"Pant 1","XL",1200]
[null,null,null,null,null,null,null,null,"Pant 2","XXL",1230]
[null,null,null,null,null,null,null,null,"Shoe 3",7.5,1100]

{"sheet":"MOD and ROW","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using MOD and ROW function",null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Size","Price","Delete",null,null,null,"Product","Size","Price","Delete"]
[null,"Shirt 1","L",1750,{"$f":"MOD(ROW()-4,3)","v":1},null,null,null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870,{"$f":"MOD(ROW()-4,3)","v":2},null,null,null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500,0,null,null,null,"Shoe 1",6.5,1750]
[null,"Jacket 2","XL",3500,1,null,null,null,"Jacket 1","L",4500]
[null,"Pant 1","XL",1200,2,null,null,null,"Jacket 2","XL",3500]
[null,"Pant 2","XXL",1230,0,null,null,null,"Shoe 2",7,5500]
[null,null,null,null,null,null,null,null,"Pant 1","XL",1200]
[null,null,null,null,null,null,null,null,"Pant 2","XXL",1230]
[null,null,null,null,null,null,null,null,"Shoe 3",7.5,1100]

{"sheet":"ISEVEN","index":4,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using ISEVEN function",null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Size","Price","Delete",null,null,null,null,null,"Product","Size","Price","Delete"]
[null,"Shirt 1","L",1750,{"$f":"ISEVEN(ROW())","v":false},null,null,null,null,null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870,{"$f":"ISEVEN(ROW())","v":true},null,null,null,null,null,"Shoe 1",6.5,1750]
[null,"Jacket 1","XL",3500,false,null,null,null,null,null,"Shirt 2","XXL",1870]
[null,"Pant 1","XL",1200,true,null,null,null,null,null,"Shoe 2",7,5500]
[null,null,null,null,null,null,null,null,null,null,"Jacket 1","XL",3500]
[null,null,null,null,null,null,null,null,null,null,"Shoe 3",7.5,1100]
[null,null,null,null,null,null,null,null,null,null,"Pant 1","XL",1200]

{"sheet":"Every other row","index":5,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using MOD and ROW function",null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Size","Price","Delete",null,null,null,"Product","Size","Price","Delete"]
[null,"Shirt 1","L",1750,{"$f":"MOD(ROW(),2)","v":1},null,null,null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870,{"$f":"MOD(ROW(),2)","v":0},null,null,null,"Shoe 1",6.5,1750]
[null,"Jacket 1","XL",3500,1,null,null,null,"Shirt 2","XXL",1870]
[null,"Pant 1","XL",1200,0,null,null,null,"Shoe 2",7,5500]
[null,null,null,null,null,null,null,null,"Jacket 1","XL",3500]
[null,null,null,null,null,null,null,null,"Shoe 3",7.5,1100]
[null,null,null,null,null,null,null,null,"Pant 1","XL",1200]

{"sheet":"VBA","index":6,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,null,"Practice"]
[]
[null,"Product","Size","Price",null,null,null,null,null,"Product","Size","Price"]
[null,"Shirt 1","L",1750,null,null,null,null,null,"Shirt 1","L",1750]
[null,"Shirt 2","XXL",1870,null,null,null,null,null,"Shirt 2","XXL",1870]
[null,"Jacket 1","L",4500,null,null,null,null,null,"Shoe 1",6.5,1750]
[null,"Jacket 2","XL",3500,null,null,null,null,null,"Jacket 1","L",4500]
[null,"Pant 1","XL",1200,null,null,null,null,null,"Jacket 2","XL",3500]
[null,"Pant 2","XXL",1230,null,null,null,null,null,"Shoe 2",7,5500]
[null,null,null,null,null,null,null,null,null,"Pant 1","XL",1200]
[null,null,null,null,null,null,null,null,null,"Pant 2","XXL",1230]
[null,null,null,null,null,null,null,null,null,"Shoe 3",7.5,1100]