I mentioned that I track my wins using an Excel Spreadsheet I created using simple formulas. Since there seems to be some interest among my readers for this spreadsheet I decided to post it for you to download and use. I have included some instructions to help you decipher my system.
What’s In Sweeties Tracking Wins Spreadsheet?
If you can’t see the picture below CLICK HERE to download the spreadsheet.
Step 1: When you open the spreadsheet you will see the summary sheet. To actually enter your sweepstakes wins you will need to click on the tab at the bottom that is entitled, List of Wins.
Step 2: To get help in figuring out what should be put in each column click on the tab that is entitled, Notes.
Step 3: Make sure ONLY edit the List of Wins tab. The first tab entitled Summary will automatically update with the information you put in the List of Wins sheet.
NOTICE: You should not add a new row in between rows or rearrange rows in the “List of Wins” tab or the formulas will not work and will not give you accurate numbers on the Summary tab
The Summary tab is formula-based, pulling from the “List of Wins” tab. This tab will update automatically and should not be changed.
Column Explanation:
RCVD: Specify whether prize has been received. Drop down option of either Yes or No
DATE WON: Input date you received notification of your winning.
MONTH: Type the number that corresponds with the month so your calculations will be correct on the summary page. This must not be left blank or your totals will be off.
Example: January = 1, February = 2, March = 3, April = 4, May = 5, June = 6, July = 7, August = 8, September = 9, October = 10, November = 11, December = 112
PRIZE DESCRIPTION: Type a description of the prize.
SWEEPSTAKES NAME: Type the name of the contest or sweepstakes.
VALUE: Estimated value of the prize.
TYPE OF SWEEPS: Specify what type of sweepstakes or contest it was like Blog, Facebook Mail-in, Twitter, etc. Drop down options are specified to select. You cannot type in this box. You can only select an entry from the list.
WHO WON: The name of the person who won the prize. You, your husband, wife, child, etc.
NOTES: Any additional notes you would like to type to help you remember something about the prize or sweepstakes
The Summary Tab is formula-based, pulling from the “List of Wins” tab. This tab will update automatically and should not be changed.
Don’t buy Microsoft Office To Use This. Use these Free programs to view your Excel spreadsheet:
If you don’t own Excel you can download and install the FREE Microsoft Excel Viewer. The Excel Viewer let’s you open, view, and print Excel workbooks, even if you don’t have Excel installed.
Another Free option for viewing and printing Excel spreadsheet is to use Google Docs. With Google Docs you can setup a free account or use your existing Google or Gmail account to sign in. Google Docs let’s you setup documents that are very similar to Word, Powerpoint, and Excel documents and can be read, opened, and printed by anyone who has Word, Powerpoint, Excel, or similar programs. The beauty of Google Docs is that all of the documents are stored on the Google site. You just log into your account and click on Docs to use them. You can also download them to your computer for use with other programs or to store them in another location.
If you can’t see the picture below CLICK HERE to download the spreadsheet.
Well, that’s about it. I hope you are able to use my spreadsheet to track and record your wins. I enjoy statistics as you have seen and because I am a visual person and learn better that way I like to “see” my wins all in one place.
Please feel free to share your system with me and the readers of this site. We can help each other as we share. Thanks!
It is not recognizing the wins from facebook or IWG on the summary tab. Facebook is not even listed in the summary tab. So the number of wins and totals are off if you chose IWG or facebook on the List of Wins tab. I have treid to correct the formulas but can’t figure out the formulas.
Thanks. I will tell Chad who updated it for me and see if he can fix it.
it seems that the summary page is not updating… it is not calculating any of my wins from october or november so far. is there something i am doing wrong?
Ok, back a long time ago this spreadsheet used to print out so that humans could read it..lol I have tried everything in my power to tweak it and make it printable for human eyes. I cant get it! I have also tried to make my own and for some reason I cant get mine to either print with lines or it is again, too small. I am very frustrated..any ideas?? :/
You can tweak the font when under the Print options I believe (File | Print). The only thing we changed was the formulas.
as I expected, too complicated for my little brain, lol! I downloaded it and the viewer, but can’t figure it out at all….oh well, back to my folder it is!
Has anyone got this to work with Google Docs? That’s the best way to do this as you can use it from any PC. However, not all the formulas work. I’m going to work on fixing it up but if anyone already has, let me know what you had to do.
Thanks so much for the Google Docs version Mike! I was just about to make my own.
It is 08/20,2012 and I have purchased 16 yogurts in a four pack holder. They are great. No purchase necessary as stated. There are many dates for this contest. Please let me know how I can submit the numbers that are on the aluminum covers. In one place it says the contest is over, yet they print other dates for a continuation. Please advise me to the proper process to follow. I thank you for the support given to our people at the Olympics. I must say we did make a splendid showing. You have to give our team credit for the effort they gave in performance of their talents. We have shown the world that when it comes to competition, we are at our best. God bless America and each of the those who attended and those who competed, and the Judges who gave of their time and expertise. See you in four years! ED VAL
Thank you for sharing! I just want to say I’ve been doing this for about 2 weeks and I’ve already won over $60 worth of stuff!
I have a question. Could someone tell me how I can add pinterest to one of the types of contests and how to make a formula so the pinterest wins will show up under the summary?
Thanks! Going to start using this this year. I’ve always just kept a “prizes” folder in my e-mail, then deleted once received, but this will be fun to keep track of all year long!
Thanks so much for this spread sheet! That was one of my resolutions to keep track of my wins to make sure I remember them all and receive them. One goal started this year!
Thank you for the download!
Just wanting to know if this will work with a mac?
Thanks for the download!! I had started a notepad doc but this is definitely better
Love the spread sheet so much!
I wish I won that many times to have a need for this 🙁
I needed this form last year –I used Excel but I just had a plain sheet..this sheet is MUCH better..can’t wait to fill it up!
I use this every year! Thank you!!
Were you able to edit it to make it work for 2015?
how do I update the spreadsheet to add 2015?
I am not sure what you mean. I usually start a whole new spreadsheet for a new year and give it a new name when I save it and then start adding the dates I win the prizes in the date column making sure to add the date like 1/1/15
THANKS !!!!! Love it!
On the summary page, it is not listing the “value of wins” for each month in 2015 like it did for 2014. Was there an update that I need to do? I am using the same form that I did the previous year.
track wins ha-ha-ha-ha
I would love to ge t a chance at the sweetstakes
Hi there mates, how is all, and what you wish for to say about this piece oof writing,
in my view its genuinely awesome in favor of me.
I really like this spreadsheet. Only problem, I listed my first win, and in the summary, it does show up in total prize count, but not in the top Monthly Count Number of Wins. It has the value of wins correct, but does not have the count…