#1
|
|||
|
|||
How to create a vote counter for a home owners' assoc. assembly?
First, what I am trying to figure out is, that how should an Excel based voting system work.
With my limited Excel knowledge and the help of Google I already created an Assembly Sign Up sheet (see the 1st sheet tab in the attached Excel file.) and it works! Now, I am stuck with the Vote counting part when it comes to counting the votes on issues, that come up during the assembly. (See the 2nd sheet in the attached file.) Initially I thought, that I'd use the letter "y" for yes, "n" for no and "a" for absent and figure out how to count them, but then I realized, that during counting the votes, entering y, or n, or a would slow down the counting process tremendously and the home owners would start loosing their patient. So, then I figured, that I'd maybe use the same check box method that I used on the sign up sheet, but then I realized, that I would have to create too many check boxes 3 for each owner and vote, (y,n,a x 27 x 10 or 15), so then I thought that maybe I should have three check box or a button for each type of vote on the top of each column, and click the one that received the most vote for that specific issue, that click would fill the column with that vote and manually change the ones that was different. For example, if 20 folks voted Yes on an issue out of 27, I would hit the Yes button above the specific column, that would enter "y" or "yes" in all cells, and then manually change the remaining 7 to no or abstain. So, what do you think? If you have any or better idea, would you please, share it with me? Last edited by Geza59; 07-21-2012 at 03:42 AM. Reason: Deleted irrelevant text |
#2
|
|||
|
|||
Well, in the past few hours I managed to come up with a solution (see uploaded excel file), the part that I got stuck at is...
...how do you add up the % numbers in column D, so that numbers that belong to the Yes votes totaled in cell E18, the No votes in E19 and so on? Probably you can see, that my overall solution isn't on the Phd level, probably there is a more elegant way to change a range of cells to a certain value than how I did, but this works for me. |
#3
|
|||
|
|||
Well, I solved the problem.
Last edited by Geza59; 07-21-2012 at 03:42 AM. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Make add-in tab the home tab | shameerau | Word | 2 | 05-18-2011 10:58 PM |
outlook on two home computers | dan.myers2229 | Outlook | 2 | 09-25-2010 04:10 PM |
Outlook Inbox - Email Items Productivty Counter | Nobby Norris | Outlook | 0 | 03-13-2010 01:26 AM |
Visitor counter on my webpage in Word | jwhbos | Word | 0 | 02-13-2010 04:21 AM |
After vote is cast - original message is hidden away | ben80 | Outlook | 0 | 11-13-2005 05:52 AM |