POLL INFO COLLECTION

The main problem with using UserInfo to store the scores is that only the contestant will have access to the userinfo data for their scenario. So, there is no way to collect the data for multiple scenarios into one database. What you may be able to do is write a seperate scenario for people to vote within (since it is your scenario, you will have access to all the data for it). There should probably be a limit as to how many scenarios a person can vote on. You would have to maintain the database of scenarios entered into each contest. Then people can score on the scenarios listed. It might also be a good idea to create a scenario collection for each category for each month. To enter a scenario into a contest, the contestant would just ask to have their scenario added to the specific collection. You can remove each collection some time after that contest has ended, so as not to get overwhelmed with collections. When you get the data from the voting scenario, you can sort it by the scenario, copy/paste the data into a pre-made spreadsheet with a macro to create individual lines for each entry, sort the data, and create the score table for the spreadsheet. The macro should also weed out any double votes on the same scenario by the same person. If more explanation is needed on the voting scenario or the pre-made spreadsheet, do not hesitate to ask here.

As far as the website for free polling, what kind of restriction can you impose on the voting process? can it limit the number of times a person can vote on a specific scenario? can it seperate the scenarios for each individual contest into a group? etc. I have often found that writing the program to do something oneself is better than using some general program open to the public. You can impose more specific restrictions to the process as well as categorize everything in a much more precise way. Also, people are much more apt to open a seperate scenario on the site than to go to a website that they may be unfamiliar with.

Good Idea

This part

Have the spreadsheet macro compute that also. Steps involved: - get UserInfo data from the site (using the 'get data' link) - open your macro spreadsheet for working with this data - copy/paste the data from the site data to your macro spreadsheet (you may be able to program this step into your macro) The macro should do the following: - break the data up on a seperate sheet with scenario names and scores eliminating any double scorings by the same person - sort the data by scenario name - fill in a table with scenario names and sum of scores for each scenario - highlight scores greater than a certain number (or create a seperate list of those scenarios with a score greater than a certain number) - it can also count the number of scenario on that list and supply that in a separate field

I wrote a voting scenario that you can use, if you want. But you must plainly show that I wrote it and refer all votes to my upload of the scenario. It allows each person to choose what that person thinks are the best (up to) five scenarios and stores the order of those scenarios chosen starting with the best.

Game/maniac 1 0 0 0 0 0 0 0 0 0 0 danpost 3 0 0 0 0 0 0 0 0 0 0 Gevater_Tod4711 3 0 0 0 0 0 0 0 0 0 0 Poli 3 0 0 0 0 0 0 0 0 0 0 welleid 1 0 0 0 0 0 0 0 0 0 0 JetLennit 1 0 0 0 0 0 0 0 0 0 0 This is what the data looks like, how do I cycle through the scores and count how many people have a score of 1

That is what the spreadsheet macrro is for (so you do no have to). Also, it might be easier for people to remember the names of the scenarios over the names of the people who created them. The voting scenario I wrote could be done either way, however. You would create a simple text file with either the names of the contestants or the names of the scnearios entered in that challenge. The chosen names are placed in the UserInfo Strings so that the best (up to) five scenarios chosen are listed starting with what the person thinks is the best and decreasing in order. Also, by using the names instead of numbers, there is no cross-referencing needed.

1 would be the ID that I have assigned to the scenario, I want to count how many people got a score of 1 so I can make a chart showing how many people voted for that scenario