{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","6-party Calculator","12-party Calculator","Sample Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"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":"Instructions","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Simple 1 region constituency Webster / Sainte-Laguë method","Multi-region constituency Webster/Sainte-Laguë method (for Mixed-Member/Additional Member systems)"]
[]
["1.  (Optional) Enter the party names in row 2 of the calculator","1.  (Optional) Enter the party names in row 2 of the calculator"]
["2.  Enter the votes earned for each party in row 3 of the calculator","2.  (Optional) Enter the region names in column A of the calculator"]
["3.  Enter the number of seats to award in cell O5/U5","3.  Enter the votes earned for each party in each region into the calculator"]
["4. (Optional) Set the threshold and total votes in election in cells O6,7/U6,7","4.  (Optional) For Additional Member systems, enter the number of seats already won by each party in each region into the bottom left"]
["5.  Click the Calculate button","5.  Set the number of regions in cell O4/U4"]
["6.  Get the number of seats in row 18 on the right hand side","6.  Set the number of seats to award per region in cell O5/U5"]
[null,"7. (Optional) Set the threshold and total votes in election in cells O6,7/U6,7"]
[null,"8. (Optional) Choose to award a different number of seats to a region by entering a value in column I - default is set in cell O5."]
[null,"9.  Click the Calculate button"]
[null,"10.  Check the Prop. row (31) for the total number of proportional seats earned"]
[null,"11.  Check the TOTAL row (33) for the total number of seats earned including constituency and proportional seats"]

{"sheet":"6-party Calculator","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Votes earned"]
[null,"Party 1","Party 2","Party 3","Party 4","Party 5","Party 6",null,null,"Seats to award (Optional)"]
["Region 1",null,null,null,null,null,null,null,null,null,null,null,"Configure Here"]
["Region 2",null,null,null,null,null,null,null,null,null,null,null,"Regions",null,4]
["Region 3",null,null,null,null,null,null,null,null,null,null,null,"Seats per Region",null,7]
["Region 4",null,null,null,null,null,null,null,null,null,null,null,"Threshold",null,0.05]
["Region 5",null,null,null,null,null,null,null,null,null,null,null,"Total Votes"]
["Region 6"]
["Region 7",null,null,null,null,null,null,null,null,null,null,null,null,null,"*Calculate button automatically clears table below when clicked"]
["Region 8"]
["Region 9"]
["Region 10"]
["Region 11"]
["Region 12"]
[]
["Constituency seats earned (Optional)",null,null,null,null,null,null,null,null,"Proportional seats earned"]
[null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"Party 2"},{"$f":"D2","v":"Party 3"},{"$f":"E2","v":"Party 4"},{"$f":"F2","v":"Party 5"},{"$f":"G2","v":"Party 6"},null,null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"Party 2"},{"$f":"D2","v":"Party 3"},{"$f":"E2","v":"Party 4"},{"$f":"F2","v":"Party 5"},{"$f":"G2","v":"Party 6"}]
[{"$f":"A3","v":"Region 1"},null,null,null,null,null,null,null,{"$f":"A3","v":"Region 1"}]
[{"$f":"A4","v":"Region 2"},null,null,null,null,null,null,null,{"$f":"A4","v":"Region 2"}]
[{"$f":"A5","v":"Region 3"},null,null,null,null,null,null,null,{"$f":"A5","v":"Region 3"}]
[{"$f":"A6","v":"Region 4"},null,null,null,null,null,null,null,{"$f":"A6","v":"Region 4"}]
[{"$f":"A7","v":"Region 5"},null,null,null,null,null,null,null,{"$f":"A7","v":"Region 5"}]
[{"$f":"A8","v":"Region 6"},null,null,null,null,null,null,null,{"$f":"A8","v":"Region 6"}]
[{"$f":"A9","v":"Region 7"},null,null,null,null,null,null,null,{"$f":"A9","v":"Region 7"}]
[{"$f":"A10","v":"Region 8"},null,null,null,null,null,null,null,{"$f":"A10","v":"Region 8"}]
[{"$f":"A11","v":"Region 9"},null,null,null,null,null,null,null,{"$f":"A11","v":"Region 9"}]
["Region 10",null,null,null,null,null,null,null,{"$f":"A12","v":"Region 10"}]
["Region 11",null,null,null,null,null,null,null,{"$f":"A13","v":"Region 11"}]
["Region 12",null,null,null,null,null,null,null,{"$f":"A14","v":"Region 12"}]
[]
["Const.",{"$f":"SUM(B18:B25)","v":0},{"$f":"SUM(C18:C25)","v":0},{"$f":"SUM(D18:D25)","v":0},{"$f":"SUM(E18:E25)","v":0},{"$f":"SUM(F18:F25)","v":0},{"$f":"SUM(G18:G25)","v":0},null,"Prop.",{"$f":"SUM(J18:J25)","v":0},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":0},{"$f":"SUM(M18:M25)","v":0},{"$f":"SUM(N18:N25)","v":0},{"$f":"SUM(O18:O25)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"B31+J31","v":0},0,0,0,0,0]

{"sheet":"12-party Calculator","index":2,"n_rows":33,"n_cols":27,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Votes earned"]
[null,"Party 1","Party 2","Party 3","Party 4","Party 5","Party 6","Party 7","Party 8","Party 9","Party 10","Party 11","Party 12",null,"Seats to award (Optional)",null,null,null,"Configure Here"]
["Region 1"]
["Region 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regions",null,12]
["Region 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seats per Region",null,7]
["Region 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Threshold",null,0]
["Region 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Votes",null,{"$f":"SUM(B3:M10)","v":0}]
["Region 6"]
["Region 7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Calculate button automatically clears table below when clicked"]
["Region 8"]
["Region 9"]
["Region 10"]
["Region 11"]
["Region 12"]
[]
["Constituency seats earned (Optional)"]
[null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"Party 2"},{"$f":"D2","v":"Party 3"},{"$f":"E2","v":"Party 4"},{"$f":"F2","v":"Party 5"},{"$f":"G2","v":"Party 6"},{"$f":"H2","v":"Party 7"},{"$f":"I2","v":"Party 8"},{"$f":"J2","v":"Party 9"},{"$f":"K2","v":"Party 10"},{"$f":"L2","v":"Party 11"},{"$f":"M2","v":"Party 12"},null,null,{"$f":"B17","v":"Party 1"},"Party 2","Party 3","Party 4","Party 5","Party 6","Party 7","Party 8","Party 9","Party 10","Party 11","Party 12"]
[{"$f":"A3","v":"Region 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A18","v":"Region 1"}]
[{"$f":"A4","v":"Region 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 2"]
[{"$f":"A5","v":"Region 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 3"]
[{"$f":"A6","v":"Region 4"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 4"]
[{"$f":"A7","v":"Region 5"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 5"]
[{"$f":"A8","v":"Region 6"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 6"]
[{"$f":"A9","v":"Region 7"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 7"]
[{"$f":"A10","v":"Region 8"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 8"]
[{"$f":"A11","v":"Region 9"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 9"]
[{"$f":"A12","v":"Region 10"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 10"]
[{"$f":"A13","v":"Region 11"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 11"]
[{"$f":"A14","v":"Region 12"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 12"]
[]
["Const.",{"$f":"SUM(B18:B25)","v":0},{"$f":"SUM(C18:C25)","v":0},{"$f":"SUM(D18:D25)","v":0},{"$f":"SUM(E18:E25)","v":0},{"$f":"SUM(F18:F25)","v":0},{"$f":"SUM(G18:G25)","v":0},{"$f":"SUM(H18:H25)","v":0},{"$f":"SUM(I18:I25)","v":0},{"$f":"SUM(J18:J25)","v":0},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":0},{"$f":"SUM(M18:M25)","v":0},null,"Prop.",{"$f":"SUM(P18:P25)","v":0},{"$f":"SUM(Q18:Q25)","v":0},{"$f":"SUM(R18:R25)","v":0},{"$f":"SUM(S18:S25)","v":0},{"$f":"SUM(T18:T25)","v":0},{"$f":"SUM(U18:U25)","v":0},{"$f":"SUM(V18:V25)","v":0},{"$f":"SUM(W18:W25)","v":0},{"$f":"SUM(X18:X25)","v":0},{"$f":"SUM(Y18:Y25)","v":0},{"$f":"SUM(Z18:Z25)","v":0},{"$f":"SUM(AA18:AA25)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"B31+P31","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Sample Data","index":3,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Votes earned"]
["CDU","SPD","Die Linke","GRUNE","CSU","FDP","AfD"]
[14921877,11252215,3755699,3694057,3243569,2083533,2056985,null,null,"This sample data is from the 2013 German Federal Election"]
[]
["Constituency seats earned"]
["CDU","SPD","Die Linke","GRUNE","CSU","FDP","AfD",null,"Threshold",0.05]
[191,58,4,1,45,0,0,null,"Total Votes",43726856]