{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","REPT Function","Combined Functions","VBA Code","Tally Chart","LEN Function","frequency, rept","Count Cells"],"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":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Candidate","Count of Votes"]
[null,"Ruth",22]
[null,"Hardy",19]
[null,"Steve",14]
[null,"Leonardo",15]
[null,"Lilly",20]
[null,"Jaime",13]
[null,"Sara",17]

{"sheet":"REPT Function","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using REPT Function"]
[]
[null,"Groups","||||-"]
[null,"Singles","|"]
[]
[null,"Candidate","Count of Votes","Groups ","Singles","Tally Marks"]
[null,"Ruth",22,{"$f":"_xlfn.FLOOR.MATH(C8,5)/5","v":4},{"$f":"MOD(C8,5)","v":2},{"$f":"REPT($C$4,D8)&REPT($C$5,E8)","v":"||||-||||-||||-||||-||"}]
[null,"Hardy",19,{"$f":"_xlfn.FLOOR.MATH(C9,5)/5","v":3},4,"||||-||||-||||-||||"]
[null,"Steve",14,2,4,"||||-||||-||||"]
[null,"Leonardo",15,3,0,"||||-||||-||||-"]
[null,"Lilly",20,4,0,"||||-||||-||||-||||-"]
[null,"Jaime",13,2,3,"||||-||||-|||"]
[null,"Sara",17,3,2,"||||-||||-||||-||"]

{"sheet":"Combined Functions","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using REPT, QUOTIENT and MOD Functions"]
[]
[null,"Candidate","Count of Votes","Tally Marks"]
[null,"Ruth",22,{"$f":"REPT(\"tttt \",QUOTIENT(C5,5))&REPT(\"I\",MOD(C5,5))","v":"tttt tttt tttt tttt II"}]
[null,"Hardy",19,{"$f":"REPT(\"tttt \",QUOTIENT(C6,5))&REPT(\"I\",MOD(C6,5))","v":"tttt tttt tttt IIII"}]
[null,"Steve",14,"tttt tttt IIII"]
[null,"Leonardo",15,"tttt tttt tttt "]
[null,"Lilly",20,"tttt tttt tttt tttt "]
[null,"Jaime",13,"tttt tttt III"]
[null,"Sara",17,"tttt tttt tttt II"]

{"sheet":"VBA Code","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA"]
[]
[null,"Candidate","Votes (Tally)","Count of Votes"]
[null,"Ruth","//// /",{"$f":"LEN(C5)","v":6}]
[null,"Hardy","////",{"$f":"LEN(C6)","v":4}]
[null,"Steve","////",4]
[null,"Leonardo","//// ",5]
[null,"Lilly","///",3]
[null,"Jaime","//// ",5]
[null,"Sara","//// //",7]

{"sheet":"Tally Chart","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,8],[6,5,6,8]]}
[]
[null,"Creating Tally Chart"]
[]
[null,"Groups","||||"]
[null,"Singles","|"]
[]
[null,"Candidate","Count of Votes","Groups","Singles","Tally Marks"]
[null,"Ruth",22,{"$f":"_xlfn.FLOOR.MATH(C8,5)","v":20},{"$f":"MOD(C8,5)","v":2}]
[null,"Hardy",19,{"$f":"_xlfn.FLOOR.MATH(C9,5)","v":15},{"$f":"MOD(C9,5)","v":4}]
[null,"Steve",14,10,4]
[null,"Leonardo",15,15,0]
[null,"Lilly",20,20,0]
[null,"Jaime",13,10,3]
[null,"Sara",17,15,2]

{"sheet":"LEN Function","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of LEN Function"]
[]
[null,"Candidate","Tally","Total Votes"]
[null,"Ruth","//////////",{"$f":"LEN(C5)","v":10}]
[null,"Hardy","/////",{"$f":"LEN(C6)","v":5}]
[null,"Steve","/////",5]
[null,"Leonardo","///",3]
[null,"Lilly","//",2]
[null,"Jaime","///////",7]
[null,"Sara","/////",5]

{"sheet":"frequency, rept","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Using FREQUENCY and REPT Functions"]
[]
[null,"Name","Scores out of 120"]
[null,"Ruth",79,null,"Range","Bin","Frequency","Tally Marks"]
[null,"Hardy",55,null,"0-30",30,{"$f":"FREQUENCY(C5:C12,F6:F8)","v":1},{"$f":"REPT(\"/\",G6)","v":"/"}]
[null,"Steve",110,null,"31-60",60,2,{"$f":"REPT(\"/\",G7)","v":"//"}]
[null,"Leonardo",88,null,"61-90",90,3,"///"]
[null,"Lilly",67,null,"91-120",120,2,"//"]
[null,"Jaime",42]
[null,"Sara",19]
[null,"Tom",101]

{"sheet":"Count Cells","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Counting Cells"]
[]
[null,"Candidate","Count of Votes"]
[null,"Ruth",22]
[null,"Hardy",19]
[null,"Steve",14]
[null,"Leonardo",15]
[null,"Lilly",20]
[null,"Jaime",13]
[null,"Sara",17]
[]
[null,"Count of Cells Containing Votes",{"$f":"COUNT(C5:C11)","v":7}]