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!
exotic1 says
Thanks for the download. This will help keep me more organized. With my busy schedule I forget a lot of things and I need all the help I can get lol
Liza767 says
thanks i downloaded
Liza767 says
i downloded thanks 🙂
Kaila Pooh says
I herd 12 aloha’s though the whole show. I really hope I win, I’m a big fan and I liked the show.
Courtenay says
Thanks again for making this available. Plus, I just want to add another free Excel alternative: OpenOffice.org. It’s basically an open source alternative to the entire Office suite.
cameo says
thanks,Courtenay,now how do I get the worksheet from excel to this onenoffice. I cannot save as
templarlady says
i tried to save to my computer and it asked for a password-what to do. Jane
Julie D says
Thank you! I was working on creating one of these, but I just hadn’t had time to figure it out. This is perfect!
cameo says
Thank you so much. This saves me making my own!
Anonymous says
Open Office is free to download also, and does everything that MS Office does (I think! LOL). I simply have a folder on my email account labeled "Winning" and put confirmation emails in there.
Anything that I'd spend money on a stamp to win is too valuable to lose track of winning, but I keep a daily activities journal and note my wins there as well.
Cher says
Hi Wendy,
I downloaded the sheet however I am unable to type anything in the cells. Any sugguestions?
Anonymous says
Thank You for this!
Kathy K says
I created my own Excel sheet.. however, should I really put in a column for who I won the Sweeps through and if it was IWG, I, R, M or so on??? I’ve already had to track down a FMV info for prizes won…
Sweetie says
it depends on if you want to see where you win from the most. At the end of the year I can see where I win the most and that way it helps me figure out where I should be entering the most the next year.
krissy says
Thank you SOO much for posting this,I had started my own excel spreadsheet, but this one is WAY nicer!!!
pontowd says
Can you believe that I still kept all my wins in a 3 ring binder.. I feel like I am much more organized.. Thanks so much Wendy.. this is a lifesaver
Sweetie says
I keep my big wins letters in a 3-ring binder to look at every once and a while. Whatever works for you is fine in my opinion
David ferrandino says
Dave01568 says
Thank great spread sheet. Good thing you use this when YouTube deleted your video and all the comments
Heather says
Thanks Sweetie! This is wonderful! I have been trying to figure out a good way to keep up with my wins…perfect!
tracy says
thanks i was just wandering where one was so i could start the new year off right!
Lynne says
Thank you for the spreadsheet. I used it last year and it was so helpful. My question is: When I am ready for a new month, is there a way to figure out where to enter the next month’s wins on the sheet so that it will start over in tabulating the wins just for that month. I haven’t used Excel much so I’m not sure how the formulas work or how to see where they are on the forms. My first four months worked last year and then after that it was a continuous total so I ended up tabulating manually for the remaining months. The end of the year tabulated itself so it was still a great summary sheet. Thanks in advance!
Sweetie says
I believe that it has been updated so when you change the date it knows to update formulas automatically but I haven’t completely played around with it yet.
Sweetie says
Yes, I just tested it out and if you put in a new date like 1/3 and then 2/3 it knows the difference and updated the summary page for the right month.
Lynne says
Thank you! I appreciate your willingness to check it out and respond! Lynne
Ashley says
Sweetie,
I am interested in downloading the excel sheet to track my wins, but I don’t see a link to download your spreadsheet.. just a link to create my own. Can you send me the link pretty please?
Ashley says
Nevermind.. I found it.. sorry!!
Sweetie says
The link is in the post above. Also, if you click the picture of the spreadsheet you can download it
Tammy says
I am having a problem with the summary page. My totals for the month of April are off by $10. I cannot figure out where the difference is coming in. I have looked at the wins for the month and none are $10. The formatting seems to be correct on the summary page so I am assuming the problem is coming in on the list of win page. Any ideas on what I should check?
Tammy says
I figured it out. I had added a row as and it threw everything off.
Debra Spencer says
I was informed on may 18th that I had won a T-Shirt, however I have not recied anything. What do I need to do?
Melissa Curran says
none of the links are working to download the spreadsheet – I’ve tried each of them, including the picture
Stephanie says
Thanks Sweetie!! This is great.
Park says
This is an excellent organizer for the sweepies. Thanks!!
Cheryl says
Thanks I download, great way to keep track