Excel Task

  • Posted:
  • Proposals: 1
  • Remote
  • #694728
  • Awarded
Peter S. has already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Hi,

I'm working on a project where I need to manage results for local elections.
We have Local Governments (Column A2, tab computing value) which are made up of Wards (column B, tab computing value) and the wards are then split into numerous polling units (column D, tab computing value). Each polling unit has Agents username (column E2, tab computing value), surname (column F), firstname (column G, tab computing value) and phone number (column H, tab computing value).

1. There are pre-election questions to be filled in columns I, J, K and L. The Pre-checks 'has accreditation started' shown in (column I) and 'Is security around'(column J) should be a drop down with YES or NO value.


2. Column M will store registered voters per polling unit and the subtotal per ward will be populated in the sample subtotals shown in cell M10 for all polling units in ward1 and M27 for all polling units under ward 2.(Please note that Blank cells in column M should be colored YELLOW which should turn GREEN when filled with value)

3. Column N will store accredited voters per polling unit and the subtotal per ward will be populated in the sample subtotals shown in cell N10 for all polling units in Ward1 and cell N27 for all polling units under ward 2.

Please note the following :

Blank cells in columns N should be colored YELLOW which should turn GREEN when filled with value.

In a ROW, if the value of the Accredited Voters is greater than the value of the Registered Voters, then the color of both cells should turn RED else it should be GREEN

4. Column O will store Total votes recorded per polling unit for each party listed in columns
P,Q,R,S,T,U,V,W. Subtotals for the total votes per ward are stored in cells 010 and 027. Subtotals for each party per ward are stored in cells P10,Q10,R10,S10,T10,U10,V10,W10 and P27,Q27,R27,S27,T27,U27,V27,W27.

Please note the following :

Blank cells in column O,P,Q,R,S,T,U,V,W should be colored YELLOW which should turn GREEN when filled with value.

In a ROW, if the value of the Total Votes (Column O) is greater than Accredited Voter (column N)
then the color of both cells should turn RED else it should be GREEN

5. The 'Report Type' values are to be entered in columns X. Dropdowns should be used for the column with values: Pre-election, Accreditation, Election, Post-Election

6. The 'Incident Type' values are to be entered in columns Y. Dropdowns should be used for the column with values: intimidation/harassment, bribery, snatching of ballot box, under age voting.

7. Column Z for incident details should be a free text field.

8. Cells M98,N98,O98,P98,Q98,R98,S98,T98,U98,V98,W98 should be used to auto calculate Grand totals from all subtotals.

9. Please refer to tabs polling unit charts, ward charts and Local Government charts for charts that should be auto populated based on data entry on the main 'computing values' tab.

Best Regards,
'Niyi

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.