{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","6-party D'hondt Calculator","12-party D'hondt 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":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,17,0]]}
["Simple 1 region constituency D'Hondt method","Multi-region constituency D'Hondt 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/S5","3.  Enter the votes earned for each party in each region into the calculator"]
["4.  Click the Calculate button","4.  (Optional) For Additional Member systems, enter the number of seats already won by each party in each region into the bottom left"]
["5.  Get the number of seats in row 14 on the right hand side","5.  Set the number of regions in cell O4/S4"]
[null,"6.  Set the number of seats to award per region in cell O5/S5"]
["About","7. (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-dhondt-proportional-representation-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/","8.  Click the Calculate button"]
[null,"9.  Check the Prop. row (23) for the total number of proportional seats earned"]
[null,"10.  Check the TOTAL row (25) for the total number of seats earned including constituency and proportional seats"]

{"sheet":"6-party D'hondt Calculator","index":1,"n_rows":47,"n_cols":15,"rows_kept":47,"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:B10)","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]
["Region 5",null,null,null,null,null,null,null,null,null,null,null,"Total Votes"]
["Region 6"]
["Region 7"]
["Region 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,"*Calculate button automatically clears table below when clicked"]
["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"},"Party 3","Party 4","Party 5","Party 6",null,null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"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"}]
[{"$f":"A4","v":"Region 2"},null,null,null,null,null,null,null,{"$f":"A4","v":"Region 2"}]
["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"]
[]
["Const.",{"$f":"SUM(B14:B21)","v":0},0,0,0,0,0,null,"Prop.",{"$f":"SUM(J14:J21)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"B23+J23","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Proportional seats earned (rounds earned)"]
[null,null,null,null,null,null,null,null,null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"Party 2"},"Party 3","Party 4","Party 5","Party 6"]
[null,null,null,null,null,null,null,null,{"$f":"A3","v":"Region 1"}]
[null,null,null,null,null,null,null,null,{"$f":"A4","v":"Region 2"}]
[null,null,null,null,null,null,null,null,"Region 3"]
[null,null,null,null,null,null,null,null,"Region 4"]
[null,null,null,null,null,null,null,null,"Region 5"]
[null,null,null,null,null,null,null,null,"Region 6"]
[null,null,null,null,null,null,null,null,"Region 7"]
[null,null,null,null,null,null,null,null,"Region 8"]
[]
[null,null,null,null,null,null,null,null,null,"Proportional seats coefficients per round"]
[null,null,null,null,null,null,null,null,null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"Party 2"},"Party 3","Party 4","Party 5","Party 6"]
[null,null,null,null,null,null,null,null,{"$f":"A3","v":"Region 1"}]
[null,null,null,null,null,null,null,null,{"$f":"A4","v":"Region 2"}]
[null,null,null,null,null,null,null,null,"Region 3"]
[null,null,null,null,null,null,null,null,"Region 4"]
[null,null,null,null,null,null,null,null,"Region 5"]
[null,null,null,null,null,null,null,null,"Region 6"]
[null,null,null,null,null,null,null,null,"Region 7"]
[null,null,null,null,null,null,null,null,"Region 8"]

{"sheet":"12-party D'hondt Calculator","index":2,"n_rows":47,"n_cols":27,"rows_kept":47,"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:B10)","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,6]
["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"]
["Region 6"]
["Region 7"]
["Region 8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Calculate button automatically clears tables below when clicked"]
["Constituency seats earned (Optional)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proportional seats earned"]
[null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"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":"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"]
[{"$f":"A3","v":"Region 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A3","v":"Region 1"}]
[{"$f":"A4","v":"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"]
[]
["Const.",{"$f":"SUM(B14:B21)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Prop.",{"$f":"SUM(P14:P21)","v":0},0,0,0,0,0,{"$f":"SUM(V14:V21)","v":0},0,0,0,{"$f":"SUM(Z14:Z21)","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"B23+P23","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proportional seats earned (rounds where the seats were earned)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"Party 2"},"Party 3","Party 4","Party 5","Party 6","Party 7","Party 8","Party 9","Party 10","Party 11","Party 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A3","v":"Region 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A4","v":"Region 2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 8"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proportional seats coefficients per round"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B2","v":"Party 1"},{"$f":"C2","v":"Party 2"},"Party 3","Party 4","Party 5","Party 6","Party 7","Party 8","Party 9","Party 10","Party 11","Party 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A3","v":"Region 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A4","v":"Region 2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region 8"]

{"sheet":"Sample Data","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Votes earned"]
[null,"SNP","Labour","Conservatives","Lib Dems","Green","UKIP"]
["Central Scotland",108261,82459,14870,3318,5634,1263]
["Glasgow",83109,73031,12749,5312,12454,null,null,null,"This sample data is from the 2011 Scottish Parliament election"]
["Highlands and Islands",85082,25884,20843,21729,9076,3372]
["Lothian",110953,70544,33019,15588,21505,1822]
["Mid Scotland & Fife",116691,64623,36458,15103,10914,2838]
["North-East Scotland",140749,43893,37681,18178,10407,2477]
["South Scotland",114270,70596,54352,15096,8656,3343]
["West Scotland",117306,92530,35995,9148,8414,2000]
[]
["Constituency seats earned"]
[null,{"$f":"B2","v":"SNP"},{"$f":"C2","v":"Labour"},"Conservatives","Lib Dems","Green","UKIP"]
[{"$f":"A3","v":"Central Scotland"},6,3,0,0,0,0]
[{"$f":"A4","v":"Glasgow"},5,4,0,0,0,0]
["Highlands and Islands",6,0,0,2,0,0]
["Lothian",8,1,0,0,0,0]
["Mid Scotland & Fife",8,1,0,0,0,0]
["North-East Scotland",10,0,0,0,0,0]
["South Scotland",3,2,4,0,0,0]
["West Scotland",6,4,0,0,0,0]