Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-20-2012, 08:25 AM
Geza59 Geza59 is offline Windows XP Office 2003
Novice
 
Join Date: May 2012
Location: Budapest, Hungary
Posts: 20
Geza59 is on a distinguished road
Question 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?
Attached Files
File Type: xls test1.xls (97.5 KB, 3 views)

Last edited by Geza59; 07-21-2012 at 03:42 AM. Reason: Deleted irrelevant text
Reply With Quote
  #2  
Old 07-20-2012, 10:46 AM
Geza59 Geza59 is offline Windows XP Office 2003
Novice
 
Join Date: May 2012
Location: Budapest, Hungary
Posts: 20
Geza59 is on a distinguished road
Question

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.
Attached Files
File Type: xls test1.xls (104.5 KB, 3 views)
Reply With Quote
  #3  
Old 07-20-2012, 02:08 PM
Geza59 Geza59 is offline Windows XP Office 2003
Novice
 
Join Date: May 2012
Location: Budapest, Hungary
Posts: 20
Geza59 is on a distinguished road
Lightbulb

Well, I solved the problem.
Attached Files
File Type: xls test1.xls (125.0 KB, 8 views)

Last edited by Geza59; 07-21-2012 at 03:42 AM.
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

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


All times are GMT -7. The time now is 05:41 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft