{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","REPT","REPT,QUOTIENT,MOD","Bar Chart","VBA"],"not_rendered":{"charts":1,"images":2,"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":"Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Vote Count"]
[]
[null,"S.L No","Name","Votes"]
[null,1,"Tom",22]
[null,2,"Hardy",19]
[null,3,"Hanks",14]
[null,4,"Leonardo",15]
[null,5,"Bale",20]
[null,6,"Jaime",13]
[null,7,"Maria",17]

{"sheet":"REPT","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[4,10,4,15]]}
[]
[null,"Using REPT Function"]
[]
[null,"Groups","||||-"]
[null,"Singles","|",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"S.L No","Name","Votes","Groups ","Singles","Tally Marks",null,null,null,"S.L No","Name","Votes","Groups ","Singles","Tally Marks"]
[null,1,"Tom",22,{"$f":"_xlfn.FLOOR.MATH(D8,5)/5","v":4},{"$f":"MOD(D8,5)","v":2},{"$f":"REPT($C$4,E8)&REPT($C$5,F8)","v":"||||-||||-||||-||||-||"},null,null,null,1,"Tom",22]
[null,2,"Hardy",19,{"$f":"_xlfn.FLOOR.MATH(D9,5)/5","v":3},4,"||||-||||-||||-||||",null,null,null,2,"Hardy",19]
[null,3,"Hanks",14,2,4,"||||-||||-||||",null,null,null,3,"Hanks",14]
[null,4,"Leonardo",15,3,0,"||||-||||-||||-",null,null,null,4,"Leonardo",15]
[null,5,"Bale",20,4,0,"||||-||||-||||-||||-",null,null,null,5,"Bale",20]
[null,6,"Jaime",13,2,3,"||||-||||-|||",null,null,null,6,"Jaime",13]
[null,7,"Maria",17,3,2,"||||-||||-||||-||",null,null,null,7,"Maria",17]

{"sheet":"REPT,QUOTIENT,MOD","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using REPT, QUOTIENT and MOD Functions",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"S.L No","Name","Votes","Tally Marks",null,null,null,null,null,"S.L No","Name","Votes","Tally Marks"]
[null,1,"Tom",22,{"$f":"REPT(\"tttt \",QUOTIENT(D5,5))&REPT(\"I\",MOD(D5,5))","v":"tttt tttt tttt tttt II"},null,null,null,null,null,1,"Tom",22]
[null,2,"Hardy",19,{"$f":"REPT(\"tttt \",QUOTIENT(D6,5))&REPT(\"I\",MOD(D6,5))","v":"tttt tttt tttt IIII"},null,null,null,null,null,2,"Hardy",19]
[null,3,"Hanks",14,"tttt tttt IIII",null,null,null,null,null,3,"Hanks",14]
[null,4,"Leonardo",15,"tttt tttt tttt ",null,null,null,null,null,4,"Leonardo",15]
[null,5,"Bale",20,"tttt tttt tttt tttt ",null,null,null,null,null,5,"Bale",20]
[null,6,"Jaime",13,"tttt tttt III",null,null,null,null,null,6,"Jaime",13]
[null,7,"Maria",17,"tttt tttt tttt II",null,null,null,null,null,7,"Maria",17]

{"sheet":"Bar Chart","index":3,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,6,6,9],[1,1,1,9],[6,18,6,21],[4,13,4,21]]}
[]
[null,"Using Bar Chart"]
[]
[null,"Groups","||||"]
[null,"Singles","|",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"S.L No","Name","Votes","Groups","Singles","Tally Marks",null,null,null,null,null,null,"S.L No","Name","Votes","Groups","Singles","Tally Marks"]
[null,1,"Tom",22,{"$f":"_xlfn.FLOOR.MATH(D8,5)","v":20},{"$f":"MOD(D8,5)","v":2},null,null,null,null,null,null,null,1,"Tom",22]
[null,2,"Hardy",19,{"$f":"_xlfn.FLOOR.MATH(D9,5)","v":15},{"$f":"MOD(D9,5)","v":4},null,null,null,null,null,null,null,2,"Hardy",19]
[null,3,"Hanks",14,10,4,null,null,null,null,null,null,null,3,"Hanks",14]
[null,4,"Leonardo",15,15,0,null,null,null,null,null,null,null,4,"Leonardo",15]
[null,5,"Bale",20,20,0,null,null,null,null,null,null,null,5,"Bale",20]
[null,6,"Jaime",13,10,3,null,null,null,null,null,null,null,6,"Jaime",13]
[null,7,"Maria",17,15,2,null,null,null,null,null,null,null,7,"Maria",17]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA Code"]
[]
[null,"S.L No","Name","Votes (Tally)","Votes"]
[null,1,"Tom","//// //// /",{"$f":"LEN(D5)","v":11}]
[null,2,"Hardy","//// /",6]
[null,3,"Hanks","////",4]
[null,4,"Leonardo","//",2]
[null,5,"Bale","//// //",7]
[null,6,"Jaime","///",3]
[null,7,"Maria","//// ////",9]