{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main Dataset","Special Characters","MOD Function","MOD and ROW","ISEVEN","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Deleting Every nth Row in Excel"]
[]
[null,"Name","Position","Nationality","Special Characters"]
[null,"Messi","CAM","Argentina","$"]
[null,"Dybala","CAM","Argentina","*"]
[null,"Di Maria","RW","Argentina","@"]
[null,"Haaland","ST","Norway","$"]
[null,"Reus","LW","Germany","*"]
[null,"Neymar","LW","Brazil","@"]
[null,"Jamal","LM","Germany","$"]
[null,"Kane","ST","England","*"]
[null,"Dembele","RW","France","@"]

{"sheet":"Special Characters","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,8,1,11],[2,1,2,4]]}
[]
[null,null,null,null,null,null,null,null,"Practice"]
[null,"Deleting Every nth Row in Excel"]
[null,null,null,null,null,null,null,null,"Product","Size","Price","Delete"]
[null,"Name","Position","Nationality","Special Characters",null,null,null,"Shirt 1","L",1750]
[null,"Messi","CAM","Argentina","$",null,null,null,"Shirt 2","XXL",1870]
[null,"Dybala","CAM","Argentina","*",null,null,null,"Shoe 1",6.5,1750]
[null,"Haaland","ST","Norway","$",null,null,null,"Jacket 2","XL",3500]
[null,"Reus","LW","Germany","*",null,null,null,"Shoe 2",7,5500]
[null,"Jamal","LM","Germany","$",null,null,null,"Pant 2","XXL",1230]
[null,"Kane","ST","England","*",null,null,null,"Shoe 3",7.5,1100]

{"sheet":"MOD Function","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,8,1,11],[2,1,2,5]]}
[]
[null,null,null,null,null,null,null,null,"Practice"]
[null,"Deleting Every nth Row in Excel"]
[null,null,null,null,null,null,null,null,"Product","Size","Price","Delete"]
[null,"Name","Position","Nationality","Counter","MOD",null,null,"Shirt 1","L",1750]
[null,"Messi","CAM","Argentina",{"$f":"ROW(A1)","v":1},{"$f":"MOD(E6,4)","v":1},null,null,"Shirt 2","XXL",1870]
[null,"Dybala","CAM","Argentina",{"$f":"ROW(A2)","v":2},{"$f":"MOD(E7,4)","v":2},null,null,"Shoe 1",6.5,1750]
[null,"Di Maria","RW","Argentina",3,3,null,null,"Jacket 1","L",4500]
[null,"Haaland","ST","Norway",4,0,null,null,"Jacket 2","XL",3500]
[null,"Reus","LW","Germany",5,1,null,null,"Shoe 2",7,5500]
[null,"Neymar","LW","Brazil",6,2,null,null,"Pant 1","XL",1200]
[null,"Jamal","LM","Germany",7,3,null,null,"Pant 2","XXL",1230]
[null,"Kane","ST","England",8,0,null,null,"Shoe 3",7.5,1100]
[null,"Dembele","RW","France",9,1]

{"sheet":"MOD and ROW","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,4],[1,8,1,11]]}
[]
[null,null,null,null,null,null,null,null,"Practice"]
[null,"Deleting Every nth Row in Excel"]
[null,null,null,null,null,null,null,null,"Product","Size","Price","Delete"]
[null,"Name","Position","Nationality","MOD",null,null,null,"Shirt 1","L",1750]
[null,"Messi","CAM","Argentina",{"$f":"MOD(ROW(A6)-5,4)","v":1},null,null,null,"Shirt 2","XXL",1870]
[null,"Dybala","CAM","Argentina",{"$f":"MOD(ROW(A7)-5,4)","v":2},null,null,null,"Shoe 1",6.5,1750]
[null,"Di Maria","RW","Argentina",3,null,null,null,"Jacket 1","L",4500]
[null,"Haaland","ST","Norway",0,null,null,null,"Jacket 2","XL",3500]
[null,"Reus","LW","Germany",1,null,null,null,"Shoe 2",7,5500]
[null,"Neymar","LW","Brazil",2,null,null,null,"Pant 1","XL",1200]
[null,"Jamal","LM","Germany",3,null,null,null,"Pant 2","XXL",1230]
[null,"Kane","ST","England",0,null,null,null,"Shoe 3",7.5,1100]
[null,"Dembele","RW","France",1]

{"sheet":"ISEVEN","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,4],[1,10,1,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Practice"]
[null,"Deleting Every nth Row in Excel"]
[null,null,null,null,null,null,null,null,null,null,"Product","Size","Price","Delete"]
[null,"Name","Position","Nationality","Even",null,null,null,null,null,"Shirt 1","L",1750]
[null,"Messi","CAM","Argentina",{"$f":"ISEVEN(ROW())","v":true},null,null,null,null,null,"Shoe 1",6.5,1750]
[null,"Dybala","CAM","Argentina",{"$f":"ISEVEN(ROW())","v":false},null,null,null,null,null,"Shirt 2","XXL",1870]
[null,"Di Maria","RW","Argentina",true,null,null,null,null,null,"Shoe 2",7,5500]
[null,"Haaland","ST","Norway",false,null,null,null,null,null,"Jacket 1","XL",3500]
[null,"Reus","LW","Germany",true,null,null,null,null,null,"Shoe 3",7.5,1100]
[null,"Neymar","LW","Brazil",false,null,null,null,null,null,"Pant 1","XL",1200]
[null,"Jamal","LM","Germany",true]
[null,"Kane","ST","England",false]
[null,"Dembele","RW","France",true]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,9,1,11],[2,1,2,4]]}
[]
[null,null,null,null,null,null,null,null,null,"Practice"]
[null,"Deleting Every nth Row in Excel"]
[null,null,null,null,null,null,null,null,null,"Product","Size","Price"]
[null,"Serial","Name","Position","Nationality",null,null,null,null,"Shirt 1","L",1750]
[null,1,"Messi","CAM","Argentina",null,null,null,null,"Shirt 2","XXL",1870]
[null,2,"Dybala","CAM","Argentina",null,null,null,null,"Shoe 1",6.5,1750]
[null,4,"Haaland","ST","Norway",null,null,null,null,"Jacket 1","L",4500]
[null,5,"Reus","LW","Germany",null,null,null,null,"Jacket 2","XL",3500]
[null,7,"Jamal","LM","Germany",null,null,null,null,"Shoe 2",7,5500]
[null,8,"Kane","ST","England",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]