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?