The Election Commission has mandated that you design a spreadsheet that will accept pertinent datd on constituencies and candidates votes and generate information that would enable the outcome of the elections to be divulged to the population in the shortest possible time. Four parties contest the elections: the (DAP), the Workers National Alliance (WNA), the United Progressive Movement (UPM) and the People Democratic Revolution (PDR). Elections are contested to determine representatives in eight constituencies. The representative being the candidate who gets the most votes in his/her constituency. The parties filed candidates in every constituency except for the PDR, which fields candidates in just six of the eight constituencies.

For each of the constituency you are required to:
1. Create a table in your spreadsheet that records the number of Electors, percentage voter turnout , Number of votes cast, the percentage of spoilt ballots and the number of general votes

The number of electors registered in each constituency ranges from 6,250 to 10,795. The percentage voter turnout in each constituency is projected to be from a low of 45% to a high of 85%. Number of votes cast is determined by the number of electors *% voter turnout. The percentage of spoil ballots varies from one constituency to another, but never exceeds 2.5% in any one constituency. General votes are calculated as the votes cast – spoilt votes.

For each constituency, design a spreadsheet that accepts the candidate’s name, party acronym, rating, percentage of votes and number of votes received. The rating is a value from 1 to 4 and is determined by the results of a recent poll conducted in each constituency by a noted pollster. Apart from the candidate’s rating, the pollster also supplies the percentage of votes each candidates is likely to receive, based on the popularity rating. The actual number of votes received is that of the general votes

You must enter data for each candidate in each of the eight constituencies.

Save spreadsheet as Election 01

What kind of HELP do you need? You need to be specific when asking questions here.

If all you do is post your entire assignment, nothing will happen since no one here will do your work for you. But if you are specific about what you don't understand about the assignment or exactly what help you need, someone might be able to assist you.

I just need guidance in setting up the spead sheet for the first part of the assignment Party vs contituencies. Which I set to use for row and which I set up for column

To design the spreadsheet as per the requirements, follow the steps below:

1. Open a new spreadsheet in a software like Microsoft Excel or Google Sheets.
2. Rename the spreadsheet as "Election 01" and save it.
3. Create a new sheet/tab for each constituency.
4. In each sheet, create a table with the following columns:
- Candidate's Name
- Party Acronym
- Rating
- Percentage of Votes
- Number of Votes Received

5. Enter the data for each candidate in each constituency, as provided.
6. Calculate the values for the column "Number of Votes Received" by multiplying the general votes (votes cast - spoilt votes) with the percentage of votes for each candidate.

For the first part, where you need to create a table in the spreadsheet recording information about the constituencies, follow the steps below:

1. Go to the first sheet of the "Election 01" spreadsheet.
2. Create a table with the following columns:
- Constituency
- Number of Electors
- Percentage Voter Turnout
- Number of Votes Cast
- Percentage of Spoilt Ballots
- Number of General Votes

3. Enter the data for each constituency as provided, ensuring to follow the ranges and projections mentioned.
4. Calculate the values for the columns "Number of Votes Cast" and "Number of General Votes" as per the given formulas.

Remember to save the spreadsheet regularly to ensure your progress is not lost.