{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Convert","OFFSET","IFERROR","VBA","Sheet1"],"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":"Convert","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[[2,1,2,3]]}
[]
[]
[null,"Vaccination Record"]
[]
[null,"Name","Age","Status"]
[null,"Lisa Hawking",23,"Vaccinated"]
[null,"Paul Miles",31,"Vaccinated"]
[null,"Betty Smith",27,"Not Vaccinated"]

{"sheet":"OFFSET","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":true,"merged":[[2,10,2,12],[2,1,2,5]]}
[]
[]
[null,"Vaccination Record",null,null,null,null,null,null,null,null,"Practice Sheet"]
[]
[null,"Name","Age","Status",null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:1)/3,0)-1,MOD(ROWS($1:1)-1,3))","v":"Name"},null,null,null,null,"Name","Age","Status"]
[null,"Lisa Hawking",23,"Vaccinated",null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:2)/3,0)-1,MOD(ROWS($1:2)-1,3))","v":"Age"},null,null,null,null,"Lisa Hawking",23,"Vaccinated"]
[null,"Paul Miles",31,"Vaccinated",null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:3)/3,0)-1,MOD(ROWS($1:3)-1,3))","v":"Status"},null,null,null,null,"Paul Miles",31,"Vaccinated"]
[null,"Betty Smith",27,"Not Vaccinated",null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:4)/3,0)-1,MOD(ROWS($1:4)-1,3))","v":"Lisa Hawking"},null,null,null,null,"Betty Smith",27,"Not Vaccinated"]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:5)/3,0)-1,MOD(ROWS($1:5)-1,3))","v":23}]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:6)/3,0)-1,MOD(ROWS($1:6)-1,3))","v":"Vaccinated"}]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:7)/3,0)-1,MOD(ROWS($1:7)-1,3))","v":"Paul Miles"}]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:8)/3,0)-1,MOD(ROWS($1:8)-1,3))","v":31}]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:9)/3,0)-1,MOD(ROWS($1:9)-1,3))","v":"Vaccinated"}]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:10)/3,0)-1,MOD(ROWS($1:10)-1,3))","v":"Betty Smith"}]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:11)/3,0)-1,MOD(ROWS($1:11)-1,3))","v":27}]
[null,null,null,null,null,{"$f":"OFFSET($B$5,ROUNDUP(ROWS($1:12)/3,0)-1,MOD(ROWS($1:12)-1,3))","v":"Not Vaccinated"}]

{"sheet":"IFERROR","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":true,"merged":[[2,10,2,12],[2,1,2,5]]}
[]
[]
[null,"Vaccination Record",null,null,null,null,null,null,null,null,"Practice Sheet"]
[]
[null,"Name","Age","Status",null,{"$f":"IFERROR(INDEX(B$5:D$8,INT((ROW(A1)-1)/COLUMNS(B$5:D$8))+1,MOD(ROW(A1)-1,COLUMNS(B$5:D$8))+1),\"\")","v":"Name"},null,null,null,null,"Name","Age","Status"]
[null,"Lisa Hawking",23,"Vaccinated",null,"Age",null,null,null,null,"Lisa Hawking",23,"Vaccinated"]
[null,"Paul Miles",31,"Vaccinated",null,"Status",null,null,null,null,"Paul Miles",31,"Vaccinated"]
[null,"Betty Smith",27,"Not Vaccinated",null,"Lisa Hawking",null,null,null,null,"Betty Smith",27,"Not Vaccinated"]
[null,null,null,null,null,23]
[null,null,null,null,null,"Vaccinated"]
[null,null,null,null,null,"Paul Miles"]
[null,null,null,null,null,31]
[null,null,null,null,null,"Vaccinated"]
[null,null,null,null,null,"Betty Smith"]
[null,null,null,null,null,27]
[null,null,null,null,null,"Not Vaccinated"]
[]
[]
[]
[]
[]
[null,{"$f":"IFERROR(INDEX(B$5:D$8,INT((ROW(A13)-1)/COLUMNS(B$5:D$8))+1,MOD(ROW(A13)-1,COLUMNS(B$5:D$8))+1),\"\")","v":""}]
[null,""]
[null,""]

{"sheet":"VBA","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Vaccination Record"]
[]
[null,"Name","Age","Status"]
[null,"Lisa Hawking",23,"Vaccinated"]
[null,"Paul Miles",31,"Vaccinated"]
[null,"Betty Smith",27,"Not Vaccinated"]

{"sheet":"Sheet1","index":4,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["Name"]
["Lisa Hawking"]
["Paul Miles"]
["Betty Smith"]
["Age"]
[23]
[31]
[27]
["Status"]
["Vaccinated"]
["Vaccinated"]
["Not Vaccinated"]