|
|
Post by Pete Whitehead on Oct 10, 2016 8:05:58 GMT
While I was crunching some of my numbers I found that a way of speeding up the calculations is as follows; Firstly get the results from Andrew Teales site Starting with the seat made of the fewest wards copy and paste the results table into an Excel spreadsheet Then simply re order the vote totals in rows by party (so put all IND candidates votes in a row, all the Labour candidates votes in a row etc) And finally AUTO-SUM (FORMULAS BUTTON) for each row, aligning the answers in a column and you have the total votes for each party in the seat. Then AUTO-SUM (FORMULAS BUTTON) the column with total votes per party to get the total number of votes for the seat Then just divide all the total party votes by total number of votes to get the vote percentage for each party Using this formula it takes me approximately 1 minute per ward + 2 minutes at the end for total figures I hope this will speed things up for you! No I don't think that would be quicker than what I do and in any case the next set of results I need to do for Wales is those for 2004 for which Andrew Teale hasn't provided a download. The efficiency of my processes is not the issue - I just have quite a few other fish to fry at the moment, both psephological (eg. The boundary review) and 'real life' |
|
|
|
Post by AdminSTB on Oct 11, 2016 5:36:53 GMT
Here's a little welcome back present for AustralianSwingVoter Wales 2012 | | | | Change | seats | change | | Lab | 310158 | 35.3% | +8.6 | 78 | +32 | | Ind | 212519 | 24.2% | +0.1 | 36 | -5 | | PC | 143732 | 16.3% | -0.6 | 18 | -2 | | Con | 111648 | 12.7% | -3.0 | 13 | -14 | | LD | 70979 | 8.1% | -5.0 | 5 | -9 | | Oth | 30722 | 3.5% | +0.1 | | -2 |
 A huge number of seats changing hands here - 41 of a total of 150 Lab Gain from Con Barry North Bridgend East Caerleon Caldicot Dinas Powys Llanwern Mumbles Newport West Penarth Prestatyn Lab Gain from LD Bridgend West Cardiff Bay Cardiff Splott Mold Newport North Swansea Penderry Wrexham East Wrexham West Lab Gain from Ind Bedwas Blackwood Blaenavon Broughton Gower Merthyr South Swansea St Thomas Treharris Lab Gain from PC Abercarn Aberdare Barry South Cardiff Llandaff Hengoed Lab Gain from PV Ebbw Vale Ind Gain from Con Cardiff Rhiwbina Conwy Llantrit Major Ind Gain from LD Brecon East Ind Gain from PC Aberaeron PC Gain from Ind Beaumaris Dolgellau Newcastle Emlyn PC Gain from LG Lleyn So, when do we get the rest of them? This post has been reported for breaching the conditions I set out for your continued use of this forum (ie. being impatient and pushing for more). Now, considering this is a personal welcome back present from the last time you were banned, and I'm in a generous mood, I'm going to pretend you didn't ask that question and assume it's some sort of antipodean custom of which I'm unaware not to show gratitude. You've got off lightly with this one - just think before you press "create post". |
|
johnloony
Conservative
Posts: 24,561
Member is Online
|
Post by johnloony on Oct 11, 2016 14:14:59 GMT
So, when do we get the rest of them? If and when other people choose to provide them. They are under no obligation to do so within a particular timescale, or indeed ever. You need to learn to be patient. If you expect everybody else to be as enthusiastic as you, you will be disappointed. If you are bore or impatient waiting, go and play with planes or read a book or whatever else. This forum is not the only thing in your life. |
|
|
|
Post by andrewteale on Oct 11, 2016 16:20:18 GMT
While I was crunching some of my numbers I found that a way of speeding up the calculations is as follows; Firstly get the results from Andrew Teales site Starting with the seat made of the fewest wards copy and paste the results table into an Excel spreadsheet Then simply re order the vote totals in rows by party (so put all IND candidates votes in a row, all the Labour candidates votes in a row etc) And finally AUTO-SUM (FORMULAS BUTTON) for each row, aligning the answers in a column and you have the total votes for each party in the seat. Then AUTO-SUM (FORMULAS BUTTON) the column with total votes per party to get the total number of votes for the seat Then just divide all the total party votes by total number of votes to get the vote percentage for each party Using this formula it takes me approximately 1 minute per ward + 2 minutes at the end for total figures I hope this will speed things up for you! No I don't think that would be quicker than what I do and in any case the next set of results I need to do for Wales is those for 2004 for which Andrew Teale hasn't provided a download. The efficiency of my processes is not the issue - I just have quite a few other fish to fry at the moment, both psephological (eg. The boundary review) and 'real life' I can do a download for Wales 2004 if (a) I'm asked nicely (I'm talking to you, ASV) and (b) I get the time to put it together. |
|
|
|
Post by AustralianSwingVoter on Oct 28, 2016 7:49:50 GMT
|
|
