Tres desplegables pero que se comuniquen entre si ( Three related ListPickers)

Would the voting be anonymous?

Would you also collect the individual votes of the teachers on the individual issues?

If so, here is a sample layout for how to do this in a single sheet, column by column:

  • municipality
  • parish within that municipality
  • school within that parish
  • proposal
  • teacher casting vote on that proposal
  • vote of that teacher on that proposal (1 = yes, -1 = no, 0 = no vote)

The total number of rows would equal the number of teachers multiplied by the number of proposals, based on the assumption that each teacher works only at one school.

For data entry purposes, this would be supplemented with a lookup table mapping each teacher name into the first three columns.

Once the table is filled, you could use the spreadsheet functions that group, filter, and sum votes by whatever combination interests you.