WTB Autocount Developed
Not sure where to put this thread... but yeh, I've created a fairly simple spreadsheet that will automatically total all votes, calculate the averages, multiply these averages by the number of times no vote has been entered and add it to the total.
In other words, all YOU have to do is enter in the value of the votes.
I've posted it up here to allow you to test for errors, give feedback and to allow you to keep a personal track of what is going on in the wtb. Hopefully it could help with the counting too Enjoy.
Excel 1997 - 2003 version:
http://www.filedropper.com/worldteambattlevotesheets
Excel 2007 onwards:
http://www.filedropper.com/worldteambattlevotesheets_1
Enjoy And please provide feedback.
Please Note:
You can switch divisions across the bottom. Insert a "." for a blank vote.
In other words, all YOU have to do is enter in the value of the votes.
I've posted it up here to allow you to test for errors, give feedback and to allow you to keep a personal track of what is going on in the wtb. Hopefully it could help with the counting too Enjoy.
Excel 1997 - 2003 version:
http://www.filedropper.com/worldteambattlevotesheets
Excel 2007 onwards:
http://www.filedropper.com/worldteambattlevotesheets_1
Enjoy And please provide feedback.
Please Note:
You can switch divisions across the bottom. Insert a "." for a blank vote.
Post edited May 08, 2011 at 09:16:22 PM by ATC Design