Formula for General Election Database
Budget: £250 – £750 GBP
I ust need people to come up with the most suitable formula for my General Election Database.
Total candidates are 945 for 212 parliaments seat. The database are all in 1 worksheet and
have identical data.
What I need is the following:
1) After hardcoded all the votes for each parliament the formula will calculate the numbers of
candidate at each parliamentary seats, majority the winner got, voters turnout, winner of that
parliament seat and the party he/she represented.
2) The formula will be dynamically updated in the dashboard sheet for the summary of the
election.
3) The formula need to be applied at all relevant cells and steps have been taken to ensure it is
errors free.
This is quite an easy project for somebody who are well versed with Microsoft Excel and the
timeline set for this project is 24 hours from the time you agreed to accept the job.
Total candidates are 945 for 212 parliaments seat. The database are all in 1 worksheet and
have identical data.
What I need is the following:
1) After hardcoded all the votes for each parliament the formula will calculate the numbers of
candidate at each parliamentary seats, majority the winner got, voters turnout, winner of that
parliament seat and the party he/she represented.
2) The formula will be dynamically updated in the dashboard sheet for the summary of the
election.
3) The formula need to be applied at all relevant cells and steps have been taken to ensure it is
errors free.
This is quite an easy project for somebody who are well versed with Microsoft Excel and the
timeline set for this project is 24 hours from the time you agreed to accept the job.