{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Delegate","Alt-Delegate","Chair","Alt-Chair","Secretary","Alt-Secretary","Treasurer","Alt-Treasurer","Registrar","Alt-Registrar","Literature","LaVina","Position a","Position b","Position c","12 POSITIONS","Instructions"],"not_rendered":{"charts":0,"images":1,"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":"Delegate","index":0,"n_rows":16,"n_cols":25,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,2,1]]}
[]
[]
["Position:",null,"DELEGATE","votes","percentage",null,{"$f":"MAX(F4:F12)","v":1},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":""},"","","","","","","","",{"$f":"IF(P3=\"\",\"\",IF(P3-1<=0,\"\",P3-1))","v":""},"","","","","","","",""]
[null,null,"Melissa R.",null,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":0},{"$f":"SUM(E4:E12)","v":0}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":0},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":0},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":0},0.66659999999999997]

{"sheet":"Alt-Delegate","index":1,"n_rows":16,"n_cols":25,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","ALT - DELEGATE","votes","percentage",null,{"$f":"MAX(F4:F12)","v":6},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":5},4,3,2,1,"","","","","","","","","","","","",""]
[null,null,"RON C.",79,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.73148148148148151},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":6},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":5},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":4},3,2,1,"","","","","","","","","","","","",""]
[null,null,"TROY B.",18,0.16666666666666666,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":6},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":5},4,3,2,"","","","","","","","","","","","","",""]
[null,null,"JIM K. ",2,1.8518518518518517E-2,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":6},5,4,"","","","","","","","","","","","","","","",""]
[null,null,"GARY S. ",6,5.5555555555555552E-2,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":4},6,5,4,3,"","","","","","","","","","","","","","",""]
[null,null,"KIM R. ",1,9.2592592592592587E-3,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":5},6,"","","","","","","","","","","","","","","","","",""]
[null,null,"TOM K. ",2,1.8518518518518517E-2,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":6},6,5,4,"","","","","","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":108},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":21.6},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":35.999999639999999},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":71.999999279999997},0.66659999999999997]

{"sheet":"Chair","index":2,"n_rows":16,"n_cols":25,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","CHAIR","votes","percentage",null,{"$f":"MAX(F4:F12)","v":7},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":6},5,4,3,2,1,"","","","","","","","","","","",""]
[null,null,"TROY B. ",76,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.73786407766990292},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":7},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":6},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":5},4,3,2,1,"","","","","","","","","","","",""]
[null,null,"KRIS H.",10,9.7087378640776698E-2,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":7},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":6},5,4,3,2,"","","","","","","","","","","","",""]
[null,null,"DANIEL S. ",4,3.8834951456310676E-2,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":7},6,5,4,"","","","","","","","","","","","","","",""]
[null,null,"JIM K. ",4,3.8834951456310676E-2,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":4},7,6,5,4,"","","","","","","","","","","","","","",""]
[null,null,"GARY S.",5,4.8543689320388349E-2,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":5},7,6,5,4,3,"","","","","","","","","","","","","",""]
[null,null,"KIM R. ",2,1.9417475728155338E-2,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":6},7,6,"","","","","","","","","","","","","","","","",""]
[null,null,"TOM K. ",2,1.9417475728155338E-2,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":7},7,6,"","","","","","","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":103},{"$f":"SUM(E4:E12)","v":0.99999999999999989}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":20.6},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":34.333332989999995},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":68.666665979999991},0.66659999999999997]

{"sheet":"Alt-Chair","index":3,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","ALT - CHAIR","votes","percentage",null,{"$f":"MAX(F4:F12)","v":7},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":6},5,4,3,2,1,"","","","",""]
[null,null,"MELANIE M.",22,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.2391304347826087},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":7},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":6},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":5},4,3,2,"","","","","",""]
[null,null,"KRIS H. ",39,0.42391304347826086,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":7},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":6},5,4,3,2,1,"","","","",""]
[null,null,"DANIEL S. ",11,0.11956521739130435,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":7},6,5,4,3,"","","","","","",""]
[null,null,"JIM K. ",11,0.11956521739130435,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":4},7,6,5,4,3,"","","","","","",""]
[null,null,"GARY S. ",5,5.434782608695652E-2,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":5},7,6,5,"","","","","","","","",""]
[null,null,"KIM R. ",4,4.3478260869565216E-2,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":6},7,6,"","","","","","","","","",""]
[null,null,"TOM K. ",null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":7},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":92},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":18.400000000000002},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":30.666666359999997},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":61.333332719999994},0.66659999999999997]

{"sheet":"Secretary","index":4,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","SECRETARY","votes","percentage",null,{"$f":"MAX(F4:F12)","v":2},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":1},"","","","","","","","","",""]
[null,null,"DANIEL S.",46,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.5679012345679012},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,"JIM K. (WINNER BY Hat)",35,0.43209876543209874,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":81},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":16.2},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":26.999999729999999},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":53.999999459999998},0.66659999999999997]

{"sheet":"Alt-Secretary","index":5,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","ALT - SECRETARY","votes","percentage",null,{"$f":"MAX(F4:F12)","v":3},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":2},1,"","","","","","","","",""]
[null,null,"LINDA C.",34,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.4},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,"DANIEL S. ",44,0.51764705882352946,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":2},1,"","","","","","","","",""]
[null,null,"KIM R. ",7,8.2352941176470587E-2,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":85},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":17},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":28.33333305},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":56.6666661},0.66659999999999997]

{"sheet":"Treasurer","index":6,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","TREASURER","votes","percentage",null,{"$f":"MAX(F4:F12)","v":3},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":2},1,"","","","","","","","",""]
[null,null,"DAVE P.",66,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.80487804878048785},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":1},"","","","","","","","",""]
[null,null,"KIM R. ",15,0.18292682926829268,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":2},"","","","","","","","","",""]
[null,null,"TOM K. ",1,1.2195121951219513E-2,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":82},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":16.400000000000002},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":27.333333059999998},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":54.666666119999995},0.66659999999999997]

{"sheet":"Alt-Treasurer","index":7,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","ALT - TREASURER","votes","percentage",null,{"$f":"MAX(F4:F12)","v":2},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":1},"","","","","","","","","",""]
[null,null,"KIM R.",53,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.67088607594936711},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,"TOM K.",26,0.32911392405063289,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":79},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":15.8},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":26.333333069999998},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":52.666666139999997},0.66659999999999997]

{"sheet":"Registrar","index":8,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","REGISTRAR","votes","percentage",null,{"$f":"MAX(F4:F12)","v":3},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":2},1,"","","","","","","","",""]
[null,null,"TOM K.",2,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":2.5316455696202531E-2},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,"BRAD H.",19,0.24050632911392406,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":2},"","","","","","","","","",""]
[null,null,"DEBRA R.",58,0.73417721518987344,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":3},2,1,"","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":79},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":15.8},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":26.333333069999998},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":52.666666139999997},0.66659999999999997]

{"sheet":"Alt-Registrar","index":9,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","ALT - REGISTRAR","votes","percentage",null,{"$f":"MAX(F4:F12)","v":4},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":3},2,1,"","","","","","","",""]
[null,null,"BRAD H.",28,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.36842105263157893},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":4},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":3},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":2},1,"","","","","","","",""]
[null,null,"MELANIE M.",18,0.23684210526315788,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":4},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":3},2,"","","","","","","","",""]
[null,null,"STEVVI M.",12,0.15789473684210525,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":4},"","","","","","","","","","",""]
[null,null,"NANCY R.",18,0.23684210526315788,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":4},4,3,2,"","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":76},{"$f":"SUM(E4:E12)","v":0.99999999999999989}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":15.200000000000001},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":25.333333079999999},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":50.666666159999998},0.66659999999999997]

{"sheet":"Literature","index":10,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","LITERATURE","votes","percentage",null,{"$f":"MAX(F4:F12)","v":2},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":1},"","","","","","","","","",""]
[null,null,"KATHLEEN T.",44,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.66666666666666663},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,"BARBRA G.",22,0.33333333333333331,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":66},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":13.200000000000001},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":21.99999978},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":43.999999559999999},0.66659999999999997]

{"sheet":"LaVina","index":11,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","LA VINA","votes","percentage",null,{"$f":"MAX(F4:F12)","v":2},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":1},"","","","","","","","","",""]
[null,null,"LOUIS P.",40,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0.57971014492753625},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,"SEVERIANO M.",29,0.42028985507246375,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":69},{"$f":"SUM(E4:E12)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":13.8},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":22.999999769999999},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":45.999999539999997},0.66659999999999997]

{"sheet":"Position a","index":12,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","a","votes","percentage",null,{"$f":"MAX(F4:F12)","v":0},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0},{"$f":"IF(ISBLANK(C4),\"\",1)","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":0},{"$f":"SUM(E4:E12)","v":0}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":0},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":0},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":0},0.66659999999999997]

{"sheet":"Position b","index":13,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","b","votes","percentage",null,{"$f":"MAX(F4:F12)","v":0},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0},{"$f":"IF(ISBLANK(C4),\"\",1)","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":0},{"$f":"SUM(E4:E12)","v":0}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":0},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":0},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":0},0.66659999999999997]

{"sheet":"Position c","index":14,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Position:","c","votes","percentage",null,{"$f":"MAX(F4:F12)","v":0},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":""},"","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D4/D$13)","v":0},{"$f":"IF(ISBLANK(C4),\"\",1)","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$12,0)),\"\",IF(RANK($D4,$D$4:$D$12,0)<=I$3,I$3,\"\")))","v":""},"","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$12,0)),\"\",IF(RANK($D5,$D$4:$D$12,0)<=H$3,H$3,\"\")))","v":""},"","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":""},{"$f":"IF(ISBLANK($C6),\"\",IF(ISNA(RANK($D6,$D$4:$D$12,0)),\"\",IF(RANK($D6,$D$4:$D$12,0)<=G$3,G$3,\"\")))","v":""},"","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,0,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D11/D$13)","v":0},{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":""},"","","","","","","","","","","",""]
[null,null,null,null,{"$f":"IF(D$13 = 0, 0, D12/D$13)","v":0},{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":""},"","","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D12)","v":0},{"$f":"SUM(E4:E12)","v":0}]
[null,null,"1/5 of the vote =>",{"$f":"D13 * 0.2","v":0},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D13 * 0.33333333","v":0},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D13 * 0.66666666","v":0},0.66659999999999997]

{"sheet":"12 POSITIONS","index":15,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Twelve\nPositions","Position:","TWELFTH MAN","votes","percentage",null,{"$f":"MAX(F4:F15)","v":12},{"$f":"IF(G3=\"\",\"\",IF(G3-1<=0,\"\",G3-1))","v":11},10,9,8,7,6,5,4,3,2,1]
[null,null,"TEST01",2,{"$f":"IF(D$16 = 0, 0, D4/D$16)","v":1.6949152542372881E-2},{"$f":"IF(ISBLANK(C4),\"\",1)","v":1},{"$f":"IF(ISBLANK($C4),\"\",IF(ISNA(RANK($D4,$D$4:$D$15,0)),\"\",IF(RANK($D4,$D$4:$D$15,0)<=G$3,G$3,\"\")))","v":12},11,"","","","","","","","","",""]
[null,null,"TEST02",17,0.1440677966101695,{"$f":"IF(ISBLANK(C5),\"\",MAX(F$4:F4)+1)","v":2},{"$f":"IF(ISBLANK($C5),\"\",IF(ISNA(RANK($D5,$D$4:$D$15,0)),\"\",IF(RANK($D5,$D$4:$D$15,0)<=G$3,G$3,\"\")))","v":12},11,10,9,8,7,6,5,4,3,2,1]
[null,null,"TEST03",4,3.3898305084745763E-2,{"$f":"IF(ISBLANK(C6),\"\",MAX(F$4:F5)+1)","v":3},12,11,10,"","","","","","","","",""]
[null,null,"TEST04",16,0.13559322033898305,{"$f":"IF(ISBLANK(C7),\"\",MAX(F$4:F6)+1)","v":4},12,11,10,9,8,7,6,5,4,3,2,""]
[null,null,"TEST05",6,5.0847457627118647E-2,{"$f":"IF(ISBLANK(C8),\"\",MAX(F$4:F7)+1)","v":5},12,11,10,9,"","","","","","","",""]
[null,null,"TEST06",15,0.1271186440677966,{"$f":"IF(ISBLANK(C9),\"\",MAX(F$4:F8)+1)","v":6},12,11,10,9,8,7,6,5,4,3,"",""]
[null,null,"TEST07",8,6.7796610169491525E-2,{"$f":"IF(ISBLANK(C10),\"\",MAX(F$4:F9)+1)","v":7},12,11,10,9,8,"","","","","","",""]
[null,null,"TEST08",14,0.11864406779661017,{"$f":"IF(ISBLANK(C11),\"\",MAX(F$4:F10)+1)","v":8},12,11,10,9,8,7,6,5,4,"","",""]
[null,null,"TEST09",10,8.4745762711864403E-2,{"$f":"IF(ISBLANK(C12),\"\",MAX(F$4:F11)+1)","v":9},12,11,10,9,8,7,"","","","","",""]
[null,null,"TEST10",13,0.11016949152542373,{"$f":"IF(ISBLANK(C13),\"\",MAX(F$4:F12)+1)","v":10},12,11,10,9,8,7,6,5,"","","",""]
[null,null,"TEST11",12,0.10169491525423729,{"$f":"IF(ISBLANK(C14),\"\",MAX(F$4:F13)+1)","v":11},12,11,10,9,8,7,6,"","","","",""]
[null,null,"TEST12",1,8.4745762711864406E-3,{"$f":"IF(ISBLANK(C15),\"\",MAX(F$4:F14)+1)","v":12},12,"","","","","","","","","","",""]
[null,"Total:",null,{"$f":"SUM(D4:D15)","v":118},{"$f":"SUM(E4:E15)","v":1}]
[null,null,"1/5 of the vote =>",{"$f":"D16 * 0.2","v":23.6},0.2]
[null,null,"1/3 of the vote =>",{"$f":"D16 * 0.33333333","v":39.333332939999998},0.33329999999999999]
[null,null,"2/3 of the vote =>",{"$f":"D16 * 0.66666666","v":78.666665879999996},0.66659999999999997]

{"sheet":"Instructions","index":16,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,52],[3,2,3,25],[2,2,2,25],[4,2,4,25],[15,1,15,71],[13,2,13,25],[6,2,6,25],[7,2,7,25],[9,2,9,25],[11,2,11,25]]}
[null,"This spreadsheet is intended as a tool that may be used to track votes submitted during an election process.  It provides a means to display a graphical image for large group observation.  Several worksheets are available should you choose to individually track multiple positions being voted on.  Worksheet names and/or position titles may be changed as desired.  Vote tally and percentages are atomatically updated as information is added.\nHere is how it works..."]
[null,"BEFORE the vote tallying begins:"]
[null,1,"Select the desired position [Tab] OR type in a Position title (1) "]
[null,2,"Ensure pre-existing candidate names and votes are removed by clicking on [clear all] (2)"]
[null,3,"Type in each candidate's name - usually first name and last initial (3)"]
[null,"DURING the vote tallying:"]
[null,4,"As each candidate name is called out, click on the applicable \n[  +1  ] button (4).  IF you mistakenly add too many votes to a candidate, click on the applicable [Oops (-1)] button (5)"]
[null,5,"As votes are tallied, the votes, the percentage and the ranking chart automatically update.\nAlso, at the bottom, the total votes as well as the number of votes required to fullfill varous voting percentages is automatically updated"]
[null,"REPEAT VOTE tallying:"]
[null,6,"IF substantial unanimity is not achieved and another vote is required, click on the [clear votes] button (6).  If candidates are elliminated during the voting process, select the desired candidate's name and click the keyboard <Delete> key"]
[null,"AFTER the vote tallying:"]
[null,7,"Select the next applicable worksheet [Tab] (or stay with the same worksheet) and repeat the above process"]
[null,"Note:"]
[null,null,"Where more than 9 candidates are veing for a position, there is a 12 POSITIONS worksheet available"]
[]
[null,"The Third Legacy Procedure*:\ni.   A candidate must receive 2/3 of the total vote to be elected. The results of each ballot will be posted.\nii.  After the second ballot, any candidate who received less than 1/5 of the total vote will be withdrawn, except the top two candidates must remain; in the event of a tie, all candidates \n      tied for second place remain.\niii. After the third ballot, any candidate who received less than 1/3 of the total vote will be withdrawn, except the top two candidates must remain; in the event of a tie, all candidates tied \n      for second place remain.\niv. After the fourth ballot:\n      (1) The candidate with the smallest number of votes will be withdrawn, except the top two candidates must remain; in the event of a tie, all candidates tied for second place remain.\n      (2) The chair will ask if there is a motion to go to a fifth ballot.\n            (a) If such a motion is made and seconded, a simple majority will be needed to take the election to the fifth ballot.\n            (b) In the absence of such a motion passing, the election will be decided by lot, that is, it “goes to the hat.”\nv.  If no candidate receives 2/3 of the vote on the fifth ballot, the election will be decided by lot.\nvi. For example: If 100 votes are cast,\n      2/3 = 67 votes; 1/5 = 20 votes; 1/3 = 34 votes\n\n* from the AA Service Manual, pp. S20-S21.                                                                                                                                                                                 10/24/2014"]