{"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":[[10,0,18,0]]}
["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"]
["About","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."]
["This calculcator was created by Steven Kellow, with more details available at: https://blog.stevenkellow.com/excel-webster-sainte-lague-calculator/\n\nThis work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, which allows you to share and adapt the material for non-commercial purposes as long as attribution is provided.  The license can be found here: http://creativecommons.org/licenses/by-nc-sa/4.0/","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":34,"n_cols":15,"rows_kept":34,"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,{"$f":"COUNTA(B3:B14)","v":0}]
["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",null,{"$f":"SUM(B15:G15)","v":0}]
["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"]
["Total",{"$f":"SUM(B3:B14)","v":0},0,0,0,0,0]
[]
["Constituency seats earned (Optional)",null,null,null,null,null,null,null,null,"Proportional seats earned"]
[null,{"$f":"B2","v":"Party 1"},"Party 2","Party 3","Party 4","Party 5","Party 6",null,null,{"$f":"B2","v":"Party 1"},"Party 2","Party 3","Party 4","Party 5","Party 6"]
[{"$f":"A3","v":"Region 1"},null,null,null,null,null,null,null,{"$f":"A3","v":"Region 1"},2,2,1,2,0,0]
["Region 2",null,null,null,null,null,null,null,"Region 2",0,3,4,0,0,0]
["Region 3",null,null,null,null,null,null,null,"Region 3"]
["Region 4",null,null,null,null,null,null,null,"Region 4"]
["Region 5",null,null,null,null,null,null,null,"Region 5"]
["Region 6",null,null,null,null,null,null,null,"Region 6"]
["Region 7",null,null,null,null,null,null,null,"Region 7"]
["Region 8",null,null,null,null,null,null,null,"Region 8"]
[{"$f":"A11","v":"Region 9"},null,null,null,null,null,null,null,"Region 9"]
[{"$f":"A12","v":"Region 10"},null,null,null,null,null,null,null,"Region 10"]
[{"$f":"A13","v":"Region 11"},null,null,null,null,null,null,null,"Region 11"]
[{"$f":"A14","v":"Region 12"},null,null,null,null,null,null,null,"Region 12"]
[]
["Const.",{"$f":"SUM(B19:B26)","v":0},0,0,0,0,0,null,"Prop.",{"$f":"SUM(J19:J26)","v":2},5,5,2,0,0]
[]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"B32+J32","v":2},5,5,2,0,0]

{"sheet":"12-party Calculator","index":2,"n_rows":34,"n_cols":27,"rows_kept":34,"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,{"$f":"COUNTA(B3:B14)","v":0}]
["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"]
["Total",{"$f":"SUM(B3:B14)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Constituency seats earned (Optional)"]
[null,{"$f":"B2","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",null,null,{"$f":"B18","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":"A19","v":"Region 1"},6,1,1,1,1,1,1,1,1,1,1,1]
["Region 2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 2"]
["Region 3",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 3"]
["Region 4",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 4"]
["Region 5",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 5"]
["Region 6",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 6"]
["Region 7",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 7"]
["Region 8",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 8"]
["Region 9",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 9"]
["Region 10",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 10"]
["Region 11",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 11"]
["Region 12",null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 12"]
[]
["Const.",{"$f":"SUM(B19:B26)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Prop.",{"$f":"SUM(P19:P26)","v":6},1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"B32+P32","v":6},1,1,1,1,1,1,1,1,1,1,1]

{"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]