{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Totals","Democratic","Republican","Nonpartisan","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":10,"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":"Summary","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[3,0,3,1],[12,0,12,1]]}
["Ballot Reconciliation"]
["<Insert Election Date and Type>"]
[]
["General Information"]
["Total Number of Precincts",{"$f":"COUNT(IF((Totals[City/Ward/Precinct]<>\"\") * (Totals[City/Ward/Precinct]<>\" - \"), 1))","v":0}]
["Number of Precincts Reconciled",{"$f":"COUNTIF(Totals[Reconciled?], \"YES\")","v":0}]
["Number of Precincts with Discrepancies",{"$f":"COUNTIF(Totals[Reconciled?], \"NO\")","v":0}]
["Percentage of Precincts with Discrepancies",{"$f":" $B$7/IF($B$5 = 0, 1, $B$5)","v":0}]
["Total Number of Ballots Ordered",{"$f":"SUM(Totals[Ballots Ordered])","v":0}]
["Total Number of Ballot Discrepancies",{"$f":"Totals[[#Totals],[Differences]]","v":0}]
["Percentage of Ballot Discrepancies",{"$f":"$B$10/IF($B$9 = 0, 1, $B$9)","v":0}]
[]
["Explanation of Discrepancies"]
["Precinct Name","Explanation"]
[{"$f":"IF($B$7>=ROW()-ROW($A$14),INDEX(Totals[City/Ward/Precinct],SMALL(IF(Totals[Reconciled?]=\"NO\",ROW(Totals[Reconciled?]) - ROW(Totals[[#Headers],[Reconciled?]]),\"\"),ROW()-ROW(Discrepancies[#Headers]))),\"END\")","v":"END"},{"$f":"IF($B$7>=ROW()-ROW($A$14),\"(\" & INDEX(Totals[Differences],SMALL(IF(Totals[Reconciled?]=\"NO\",ROW(Totals[Reconciled?]) - ROW(Totals[[#Headers],[Reconciled?]]),\"\"),ROW()-ROW($A$14))) & \") \" & INDEX(Totals[Comments / Explanations],SMALL(IF(Totals[Reconciled?]=\"NO\",ROW(Totals[Reconciled?]) - ROW(Totals[[#Headers],[Reconciled?]]),\"\"),ROW()-ROW(Discrepancies[[#Headers],[Precinct Name]]))),\"END\")","v":"END"}]

{"sheet":"Totals","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10]]}
["Ballot Reconciliation - Totals"]
["Calculated Columns (Do Not Edit)"]
["City/Ward/Precinct","Ballots Ordered","Ballots Used\n(Physically Counted)","Ballots Cast (from Tabulation System)","Unused Ballots","Soiled/ Defaced","Provisional Ballots","Reconciled?","Differences","Absolute Differences","Comments / Explanations"]
[{"$f":"IF(ISBLANK(Democratic!A4), \" - \", Democratic!A4)","v":" - "},{"$f":"SumData()","v":0},0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},{"$f":"SumData()","v":0},0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},{"$f":"SumData()","v":0},0]
[{"$f":"IF(ISBLANK(Democratic!A5), \" - \", Democratic!A5)","v":" - "},{"$f":"SumData()","v":0},0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},{"$f":"SumData()","v":0},0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},{"$f":"SumData()","v":0},0]
[{"$f":"IF(ISBLANK(Democratic!A6), \" - \", Democratic!A6)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A7), \" - \", Democratic!A7)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A8), \" - \", Democratic!A8)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A9), \" - \", Democratic!A9)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A10), \" - \", Democratic!A10)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A11), \" - \", Democratic!A11)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A12), \" - \", Democratic!A12)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A13), \" - \", Democratic!A13)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A14), \" - \", Democratic!A14)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A15), \" - \", Democratic!A15)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A16), \" - \", Democratic!A16)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A17), \" - \", Democratic!A17)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A18), \" - \", Democratic!A18)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A19), \" - \", Democratic!A19)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A20), \" - \", Democratic!A20)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A21), \" - \", Democratic!A21)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A22), \" - \", Democratic!A22)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A23), \" - \", Democratic!A23)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A24), \" - \", Democratic!A24)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A25), \" - \", Democratic!A25)","v":" - "},{"$f":"SumData()","v":0},0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},{"$f":"SumData()","v":0},0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},{"$f":"SumData()","v":0},0]
[{"$f":"IF(ISBLANK(Democratic!A26), \" - \", Democratic!A26)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A27), \" - \", Democratic!A27)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A28), \" - \", Democratic!A28)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A29), \" - \", Democratic!A29)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A30), \" - \", Democratic!A30)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A31), \" - \", Democratic!A31)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A32), \" - \", Democratic!A32)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A33), \" - \", Democratic!A33)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A34), \" - \", Democratic!A34)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A35), \" - \", Democratic!A35)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A36), \" - \", Democratic!A36)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A37), \" - \", Democratic!A37)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A38), \" - \", Democratic!A38)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A39), \" - \", Democratic!A39)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
[{"$f":"IF(ISBLANK(Democratic!A40), \" - \", Democratic!A40)","v":" - "},0,0,0,{"$f":"Totals[[#This Row],[Ballots Ordered]]-Totals[[#This Row],[Ballots Used\n(Physically Counted)]]","v":0},0,0,{"$f":"IF(Totals[[#This Row],[City/Ward/Precinct]]=\" - \", \" - \", IF(Totals[[#This Row],[Differences]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Totals[[#This Row],[Ballots Ordered]]-(Totals[[#This Row],[Ballots Cast (from Tabulation System)]]+Totals[[#This Row],[Unused Ballots]]+Totals[[#This Row],[Soiled/ Defaced]]+Totals[[#This Row],[Provisional Ballots]])","v":0},0,0]
["Total",{"$f":"SUBTOTAL(109,[Ballots Ordered])","v":0},{"$f":"SUBTOTAL(109,[Ballots Used\n(Physically Counted)])","v":0},{"$f":"SUBTOTAL(109,[Ballots Cast (from Tabulation System)])","v":0},{"$f":"SUBTOTAL(109,[Unused Ballots])","v":0},{"$f":"SUBTOTAL(109,[Soiled/ Defaced])","v":0},{"$f":"SUBTOTAL(109,[Provisional Ballots])","v":0},{"$f":"COUNTIF([Reconciled?], \"YES\")","v":0},{"$f":"SUBTOTAL(109,[Differences])","v":0},{"$f":"SUBTOTAL(109,[Absolute Differences])","v":0},{"$f":"COUNT(IF([Comments / Explanations]<>\"\", 1))","v":37}]

{"sheet":"Democratic","index":2,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,3],[1,5,1,6],[1,7,1,9]]}
[{"$f":"\"Ballot Reconciliation - \" & MID(CELL(\"filename\",Party1[[#Headers],[City/Ward/Precinct]]),FIND(\"]\",CELL(\"filename\",Party1[[#Headers],[City/Ward/Precinct]]))+1,256)","v":"Ballot Reconciliation - Democratic"}]
["User Editable Columns",null,null,null,"Calculated Columns","User Editable Columns",null,"Calculated Columns (Do Not Edit)",null,null,"User Editable Columns"]
["City/Ward/Precinct","Ballots Ordered","Ballots Used (Physically Counted)","Ballots Cast (from Tabulation System)","Unused Ballots","Soiled/ Defaced","Provisional Ballots","Reconciled?","Difference","Absolute Differences","Comments / Explanations"]
[null,null,null,null,{"$f":"B4-C4","v":0},null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party1[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party1[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party1[[#This Row],[Ballots Ordered]]-(Party1[[#This Row],[Ballots Cast (from Tabulation System)]]+Party1[[#This Row],[Unused Ballots]]+Party1[[#This Row],[Soiled/ Defaced]]+Party1[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party1[[#This Row],[Difference]])","v":0}]
["Total",{"$f":"SUBTOTAL(109,[Ballots Ordered])","v":0},{"$f":"SUBTOTAL(109,[Ballots Used (Physically Counted)])","v":0},{"$f":"SUBTOTAL(109,[Ballots Cast (from Tabulation System)])","v":0},{"$f":"SUBTOTAL(109,[Unused Ballots])","v":0},{"$f":"SUBTOTAL(109,[Soiled/ Defaced])","v":0},{"$f":"SUBTOTAL(109,[Provisional Ballots])","v":0},{"$f":"COUNTIF([Reconciled?], \"YES\")","v":0},{"$f":"SUBTOTAL(109,[Difference])","v":0},{"$f":"SUBTOTAL(109,[Absolute Differences])","v":0},{"$f":"SUBTOTAL(103,[Comments / Explanations])","v":0}]

{"sheet":"Republican","index":3,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,7,1,9],[1,0,1,3],[1,5,1,6]]}
[{"$f":"\"Ballot Reconciliation - \" & MID(CELL(\"filename\",Party2[[#Headers],[City/Ward/Precinct]]),FIND(\"]\",CELL(\"filename\",Party2[[#Headers],[City/Ward/Precinct]]))+1,256)","v":"Ballot Reconciliation - Republican"}]
["User Editable Columns",null,null,null,"Calculated Columns","User Editable Columns",null,"Calculated Columns (Do Not Edit)",null,null,"User Editable Columns"]
["City/Ward/Precinct","Ballots Ordered","Ballots Used (Physically Counted)","Ballots Cast (from Tabulation System)","Unused Ballots","Soiled/ Defaced","Provisional Ballots","Reconciled?","Difference","Absolute Differences","Comments / Explanations"]
[null,null,null,null,{"$f":"B4-C4","v":0},null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party2[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party2[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party2[[#This Row],[Ballots Ordered]]-(Party2[[#This Row],[Ballots Cast (from Tabulation System)]]+Party2[[#This Row],[Unused Ballots]]+Party2[[#This Row],[Soiled/ Defaced]]+Party2[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party2[[#This Row],[Difference]])","v":0}]
["Total",{"$f":"SUBTOTAL(109,[Ballots Ordered])","v":0},{"$f":"SUBTOTAL(109,[Ballots Used (Physically Counted)])","v":0},{"$f":"SUBTOTAL(109,[Ballots Cast (from Tabulation System)])","v":0},{"$f":"SUBTOTAL(109,[Unused Ballots])","v":0},{"$f":"SUBTOTAL(109,[Soiled/ Defaced])","v":0},{"$f":"SUBTOTAL(109,[Provisional Ballots])","v":0},{"$f":"COUNTIF([Reconciled?], \"YES\")","v":0},{"$f":"SUBTOTAL(109,[Difference])","v":0},{"$f":"SUBTOTAL(109,[Absolute Differences])","v":0},{"$f":"SUBTOTAL(109,[Comments / Explanations])","v":0}]

{"sheet":"Nonpartisan","index":4,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,7,1,9],[1,0,1,3],[1,5,1,6]]}
[{"$f":"\"Ballot Reconciliation - \" & MID(CELL(\"filename\",Party3[[#Headers],[City/Ward/Precinct]]),FIND(\"]\",CELL(\"filename\",Party3[[#Headers],[City/Ward/Precinct]]))+1,256)","v":"Ballot Reconciliation - Nonpartisan"}]
["User Editable Columns",null,null,null,"Calculated Columns","User Editable Columns",null,"Calculated Columns (Do Not Edit)",null,null,"User Editable Columns"]
["City/Ward/Precinct","Ballots Ordered","Ballots Used (Physically Counted)","Ballots Cast (from Tabulation System)","Unused Ballots","Soiled/ Defaced","Provisional Ballots","Reconciled?","Difference","Absolute Differences","Comments / Explanations"]
[null,null,null,null,{"$f":"B4-C4","v":0},null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,{"$f":"B5-C5","v":0},null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,{"$f":"B31-C31","v":0},null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,0,null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
[null,null,null,null,{"$f":"B40-C40","v":0},null,null,{"$f":"IF(ISBLANK(Party3[[#This Row],[City/Ward/Precinct]]), \" - \", IF(Party3[[#This Row],[Difference]]=0,\"YES\",\"NO\"))","v":" - "},{"$f":"Party3[[#This Row],[Ballots Ordered]]-(Party3[[#This Row],[Ballots Cast (from Tabulation System)]]+Party3[[#This Row],[Unused Ballots]]+Party3[[#This Row],[Soiled/ Defaced]]+Party3[[#This Row],[Provisional Ballots]])","v":0},{"$f":"ABS(Party3[[#This Row],[Difference]])","v":0}]
["Total",{"$f":"SUBTOTAL(109,[Ballots Ordered])","v":0},{"$f":"SUBTOTAL(109,[Ballots Used (Physically Counted)])","v":0},{"$f":"SUBTOTAL(109,[Ballots Cast (from Tabulation System)])","v":0},{"$f":"SUBTOTAL(109,[Unused Ballots])","v":0},{"$f":"SUBTOTAL(109,[Soiled/ Defaced])","v":0},{"$f":"SUBTOTAL(109,[Provisional Ballots])","v":0},{"$f":"COUNTIF([Reconciled?], \"YES\")","v":0},{"$f":"SUBTOTAL(109,[Difference])","v":0},{"$f":"SUBTOTAL(109,[Absolute Differences])","v":0},{"$f":"SUBTOTAL(103,[Comments / Explanations])","v":0}]

{"sheet":"Instructions","index":5,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[[44,1,44,2],[21,1,21,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[6,1,6,2],[12,0,19,0],[12,1,12,2],[21,0,25,0],[26,0,34,0],[5,1,5,2],[11,1,11,2],[53,0,56,0],[53,1,53,2],[57,0,61,0],[57,1,57,2],[26,1,26,2],[48,0,52,0],[48,1,48,2],[35,0,36,0],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,0,38,2],[39,0,39,2],[40,0,43,0],[40,1,40,2],[44,0,47,0]]}
[{"$f":"MID(CELL(\"filename\",$A$2), FIND(\"]\", CELL(\"filename\",$A$2)) + 1, 255)","v":"Instructions"}]
["Note: The columns that can be safely edited are marked in the header as \"User Editable Columns\" and are shaded in a lighter blue."]
["Note: Do not remove/overwrite the header rows or the total row."]
["Note: Paste data as values only (see item S1 below)."]
["Note: Many columns contain calculation fields and are hidden from view."]
[1,"Save a new copy to work from using the 'Save As' option in the menu. Do not modify the original \nspreadsheet."]
[2,"If a Security Warning appears, macros must be enabled."]
[null,null,"Note: This spreadsheet will not work if macros are not enabled."]
[null,"a.","Excel may state \"Macros have been disabled.\""]
[null,"b.","Click \"Options…\""]
[null,"c.","Click \"Enable this Content\" and \"OK\""]
[3,"In the spreadsheet titled 'Summary', enter the Election Date and Election Type in cell A2."]
[4,"Review and modify ballot type spreadsheets, if necessary."]
[null,null,"Note: Spreadsheets for Democratic, Republican and Nonpartisan ballots are initially present."]
[null,"a.","Right click on the spreadsheet titled 'Democratic' and select \"Move or Copy…\""]
[null,"b.","Select \"Create a Copy\""]
[null,"c.","Select where the new spreadsheet should be placed."]
[null,"c.","Right click on the new tab and rename the spreadsheet the name of the new party."]
[null,"d.","You may change the color of the table by selecting the Table Style of your choice from 'Table Tools - Design'."]
[null,"e.","Repeat for any remaining ballot types."]
[null,"f.","If any must be deleted, right click on the spreadsheet and select delete."]
[5,"Enter/Import election data into each spreadsheet."]
[null,"a.","Enter (or copy/paste as values) the precinct names in the first column."]
[null,null,"Note: The precincts listed in the 'Democratic' spreadsheet are copied to the 'Totals' spreadsheet.  Therefore, all unique precincts must be listed on this spreadsheet."]
[null,"b.","Determine the total number of rows needed and extend or shrink the table by the necessary\namount (see items S4, S5 below)."]
[null,null,"Note: This table will automatically grow to fit the data pasted."]
[6,"In the following columns, enter (or copy/paste as values) the values for:"]
[null,"a.","Ballots Ordered."]
[null,"b.","Ballots Used, which is determined by finding out how many ballots are missing from the unused ballot stock."]
[null,"c.","Ballots Cast, which does not include any numbers for ballots that were not pulled from the Election Day ballot stock (e.g. vote by mail ballots)."]
[null,"d.","Soiled / Defaced, which are used ballots that are not counted."]
[null,"e.","Election Day Provisional Ballots (Valid and Invalid), which does not include any numbers for ballots that were not pulled from the Election Day ballot stock (e.g. absentee provisionals)."]
[null,"f.","The 'Difference' column will show the number of Election Day ballots that are not accounted for.\nNOTE: There is also a Absolute Difference column which can be used to determine the absolute differences."]
[null,"g.","The 'Reconciled' column will show \"NO\" if there are differences. If it does show \"NO,\" further investigation is required."]
[null,"h.","If there are any differences, enter the reason for it in the column labeled: \n'Comments / Explanations'."]
[7,"Once the data has been entered, return to spreadsheet 'Summary' and adjust the size of \ntable 'Explanation of Discrepancies' until all of the reasons are displayed (see item S4 below)."]
[null,"Note: The precinct name will change to 'END' when there are no more discrepancies to report."]
[8,"Save results"]
["Supplemental Instructions:"]
["Note: These steps may differ slightly depending on your Excel settings and version."]
["S1","To paste as values: "]
[null,"a.","On the Office Ribbon click on the tab titled: 'Home'."]
[null,"b.","Locate on the left of the 'Home' tab an image of a clipboard with word 'Paste' and a down arrow \nbelow it."]
[null,"c.","Click on the down arrow, then click on 'Paste Values'."]
["S2","To hide rows/columns:"]
[null,"a.","Select row/column identifier (i.e. Letter 'A' at the top of the spreadsheet for first column, \nNumber '1' at the left of the spreadsheet for the first row)."]
[null,"b.","With the entire row/column selected, right click on the identifier to bring up the popup menu."]
[null,"c.","Click on 'Hide' in the popup menu."]
["S3","To show hidden rows/columns:"]
[null,"a.","Select the first row/column before the row/column you wish to unhide using the method \noutlined in S2 above."]
[null,"b.","While holding down the 'Shift' key, select the row/column after the row/column you wish to \nunhide (refer to S2 above)."]
[null,"c.","With the rows/columns selected, right click on the identifier to bring up the popup menu."]
[null,"d.","Click on 'Unhide' in the popup menu."]
["S4","To extend a table:"]
[null,"a.","Locate the bottom right cell in the table."]
[null,"b.","On the bottom, right corner of the cell there is a handle, click and hold this handle, dragging \ndown to the number of additional rows needed."]
[null,"c.","Remember to take into consideration the header rows at the top as well as the totals row at the \nbottom. i.e. If you need 100 rows for your data, then you must drag the handle down to row \n104. Four (4) rows are designated for the header."]
["S5","To shrink a table: "]
[null,"a.","Locate the bottom right cell in the table."]
[null,"b.","On the bottom, right corner of the cell there is a handle, click and hold this handle, dragging up \nto the number of rows needing to be removed."]
[null,"c.","Remember to take into consideration the header rows at the top as well as the totals row at the \nbottom. i.e. If you need 50 rows for your data, you must drag the handle up to row 54. Four (4) rows are designated for the header."]
[null,"d.","Select and delete any leftover data that is below the table."]