Results 1 to 11 of 11

D'Hondt Voting Method

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2008
    Location
    Skopje, Macedonia
    Posts
    4

    D'Hondt Voting Method

    Hello.
    I have a little problem. I havent work with excel for years and now I have to do this as soon as possible:
    There is a Donto's formula for calculating votes.
    This is how it looks like.
    	TotalVotes      1	            2	           3	            4	            5	
    А	80,000	80,000	40,000	26,667	20,000	16,000	
    B	60,000	60,000	30,000	20,000	15,000	12,000	
    C	50,000	50,000	25,000	16,667	12,500	10,000
    I have to make sorting like this:
    Place	 Party	   Result/votes
    1.	  А	             80,000
    2.	  B	             60,000
    3.	  C	             50,000
    4.	  А	             40,000
    5.	  B	             30,000
    6.	  А	             26,667
    7.	  C	             25,000
    8.	  А	             20,000
    9.	  B	             20,000
    10.	  C	             16,667
    It says party A has 4 places (1,4,6 and 8),party B has 3 places (2,5 and 9) and so on.

    I know this is a quite simple but i can't find out how to make it.

    Is it possible to give me help as soon as possible ???

    I must say that in real these are not 10 places, but 22, and there is more than 3 parties.

    With regards,
    Last edited by VBA Noob; 03-21-2009 at 03:27 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1