Vote count formula

[excellicious]

Question #1. Attached are the number of ballots in each precinct for the week Nov 27. Ballots are placed in bags. If each bag contains a maximum of 500 ballots per bag and 1 person can service a maximum of 25 bags, how many people were required to process all the ballots for that week? Does this formula look correct? 70.13 person =(Sum(B6:L10)/500)/25

Question #2. Due to cut backs, the State is considering using a bag size that will be 20% smaller. When it does, we believe 1 person will be able to service 20% more bags. Using the same weekly sample, How many people would be needed state wide if the new bag size were implemented?

I would like to develop a formula where the percentage can be adjusted.

Thank you in advance.

[JBeaucaire]

I don't get 70.13, I get 5.33 using your formula.

And are you sure you can group all the ballots together in one large lot like that? Doesn't each cell represent a different "collection" point? So B6 with 1015 ballots would require 3 bags right there, no? Are the ballots collected together THEN put into bags?

Using my logic, that each cell represents its own secure collection point, I get 19 bags the first week, still only 1 person. Then 2 people every week following.

This dorky little chart I added lets you just change the number of ballots per bag and bags per person to get new results.

[excellicious]

It works..and .it takes a rocket scientist to figure this out

Thanks.