CAC W7D3: The Frugal Fitness Geek’s Budget Spreadsheet

For anyone interested in trying out the spreadsheet I use to track my Cheapass Challenge expenses, I’ve uploaded the file here:

Frugal Fitness Geek Budget Spreadsheet

Instructions:
1. All of the authorized healthy foods from the Body-For-Life food list are already pre-filled in the spreadsheet for your convenience since most recurring expenses will be grocery-related.

2. Enter quantities of each item you need for the week in the Qty column and the price of each item if you know it. (I like to check the ads of 1-3 of the local grocery stores or visit the stores to make notes on prices before I start to get this data.) You can also just put in an estimated price per unit for now.

3. Also enter any unit and notes information you might have if you like, though this is optional.

4. You can also add your own custom items if they are not already included on the sheet.

5. When you are finished marking the quantities of the items you plan to purchase, click the dropdown arrow at the top of the Qty column and select “Nonblanks” to filter out all of the items you don’t need for the week, leaving just a (hopefully) short shopping list you can print out and take with you.

6. After you finish your shopping trip, enter the actual market prices you paid on everything and let the spreadsheet total up your expenses for the week.

7. The first tab in the workbook tracks your totals for all 12 weeks and gives you a grand total for the entire challenge. You don’t need to edit this page; the formulas will automatically pull in the values from the other sheets.

Enjoy, and let me know if you run into any problems using the sheet!

You will need Microsoft Excel, Corel Quattro Pro, or any other spreadsheet application capable of opening Excel format (.XLS) files in order to use this spreadsheet. A free office suite that includes a spreadsheet app is available for download at Openoffice.org.

==============
YESTERDAY’S EATS

1. 1/3 c. oatmeal, 3 T. raisins, 1 whole egg, 3 egg whites
2. 1 peach, 1 scoop whey
3: 4 oz. chicken breast, 1/3 c. (dry) oatmeal, 1 c. mixed Mandrain vegetables
4. 1 plain rice cake, 1/2 T. all natural peanut butter, 1 Instone High Protein chocolate pudding
5. 4 oz. chicken breast, 4 c. Romaine lettuce, 2 T. Kraft Free Zesty Italian dressing, 4 oz. potato
6. 1 c. light soy milk, 1 scoop whey

Water: 16 cups

Supplements: multivitamin, calcium 600+D, EAS l-glutamine

Calories: 1474 calories (52.2% carb/36.9% pro/15.6% fat)

==============
YESTERDAY’S WORKOUT

* YF Cardio (15 min)
* LISS Walk (4 mph / 30 min)

Calories burned: 211 calories

==============
DEFICIT: -402 cal (Target: -632 cal/day)

BUDGET NOTES: None

7 thoughts on “CAC W7D3: The Frugal Fitness Geek’s Budget Spreadsheet

  1. Maggie, you’re awesome, thanks for posting your spreadsheet! I’ll definitely use it for my 6 week cut! :claphigh:

  2. Hi maggie,

    I’ve been following your progress and you are doing awesome. I tried to get your file on your cheapass challenge, and this is what I got when I clicked on it.
    If you could email it to me that would be great.
    Thanks so much.
    Cheri

  3. cheri–Try right-clicking on the spreadsheet link and saving the file to your computer. I’ve fixed the link now. 🙂

  4. Just started p90x and am very excited. I want to do everything to make this work. Interesting website.

  5. Very well done! I know how important it is to track your daily nutrition and food intake. When you hold yourself accountable for what you eat as well as keep yourself commited to a good workout program or regime like P90X and P90X PLUS, it all comes together very nicely and good results will follow! Thanks for this!

  6. Just a suggestion:

    You probably should look into reasons “not to shop at Wal-Mart”. There are many reasons for Not shopping there. For one, they are like a monopoly shutting down “small-locally owned” shops. We should support our fellow humans in having a business of their own. Another simple reason, they have crappy items. Things are taken back to Wal-Mart more than anywhere else…they purchase crappy stuff so it can be sold cheap.

    And, we should all be buying organic produce, because it’s a way of supporting our environment, we only have one…

    Thanks! And, good luck with your endeavors, I hope you will look for the reasons not to shop there. I think you’ll agree once you read all the reasons.

  7. Thanks a bunch! I have been looking for something similar to this and I’m going to give it a try. Any tool that can help me “get organized” I welcome.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word