Spring Points Spreadsheet

In the midst of Bon Appetit’s “power of the spoon” campaign, I have updated the points spreadsheet for the spring semester.  Suprisingly, I found that it is theoretically possible to eat 14 meals a week at Usdan and not run out of points.  In fact, you’ll have a whopping $2.05 per week to spend on late night, cereal for breakfast at weshop, yummy drinks at pi cafe, and other essentials.

A disclaimer: I am a math major, so I’ve made this rather complicated, but I’ve tried to also make it super user-friendly.  Please, give me suggestions on how to improve it.

To do the magic 14-meals-at-usdan, you sign up for the 8-meals plan, pay for 7 dinners and 1 brunch a week with meals, and all the other lunches and one brunch with points.  This will require a lot of telling the cashier how you want to pay for your meal, because otherwise you’ll spend your meals early in the week on lunch and end up paying for the more expensive dinners with points.

As far as the spreadsheet, there are quite a few options, not all of which are necessary to use.  The only thing you really have to do is put in your starting number of points in the appropriate cell.  As last semester, the starting point values for each meal plan are listed on the right.

If you want to get into some fancier calculations, you can tell the spreadsheet that you want to keep spending points at the same rate over spring break (the default is to assume that you don’t spend any), or you can tell it how many meals per week you want to buy with points, and it’ll tell you how much you can afford to spend on each meal.  If it’s halfway through the semester and you want to figure out how to ration your remaining points, just change the date at the top of the spreadsheet.

At any rate, the only things you should edit are the cells that are outlined in black.  Everything else will adjust itself automagically.

And yes, I do realize that this is a bit early; I plan on re-posting it next semester.

PS: It’s really gross outside.  See tags.

PPS: already I’ve encountered a problem.  If you try to adjust the date and don’t specify a year, then it assumes that you’re talking about 2007, and then acts all weird.  So make sure to put in a year, until 2008 starts, when this will no longer be a problem.

26 thoughts on “Spring Points Spreadsheet

  1. Anonymous

    I’d like to point out that for brunch at least, and we can assume this will be the case for lunch next semester, meal users are refunded the points that they effectively lost by not using a meal on dinner. I am not certain people are refunded the full amount, but on saturday I noticed that the screen said it rebated some amount of points to whoever swiped.

  2. Anonymous

    I’d like to point out that for brunch at least, and we can assume this will be the case for lunch next semester, meal users are refunded the points that they effectively lost by not using a meal on dinner. I am not certain people are refunded the full amount, but on saturday I noticed that the screen said it rebated some amount of points to whoever swiped.

  3. Nina

    Anon 7:11, the S&C offers contracts of varying size; basically, you buy a lump sum of meals, for example 2 lunches and 2 dinners a week, at a discounted price. Then, whenever you eat at the S&C, you don’t have to pull out your card, the steward just marks you down. If you are interested or want more info, email star.and.crescent.restaurant@gmail.com.

  4. Nina

    Anon 7:11, the S&C offers contracts of varying size; basically, you buy a lump sum of meals, for example 2 lunches and 2 dinners a week, at a discounted price. Then, whenever you eat at the S&C, you don’t have to pull out your card, the steward just marks you down. If you are interested or want more info, email star.and.crescent.restaurant@gmail.com.

  5. Anonymous

    if you live near summerfields, id say the 8 meal plan is best, since being able to use meals for lunch (summerfield lunches are delicious, by the way) gives you a lot of flexibility anyway. I live in the Butts, am on the 8 meal plan, and have about 100 points left.However, it helped that I was pretty frugal during the first few weeks, and that I occasionally took advantage of S&C’s first three freshmen free deal.

  6. Anonymous

    if you live near summerfields, id say the 8 meal plan is best, since being able to use meals for lunch (summerfield lunches are delicious, by the way) gives you a lot of flexibility anyway. I live in the Butts, am on the 8 meal plan, and have about 100 points left.

    However, it helped that I was pretty frugal during the first few weeks, and that I occasionally took advantage of S&C’s first three freshmen free deal.

  7. Sam

    anon 2:32, I highly prefer the 5 meal plan over the 8 meal plan. I switched on the last possible day from 8 to 5 so I have a bit of experience being on both. The 5MP just feels a lot more flexible (although that has probably changed a bit since you can now use meals for lunches).

  8. Sam

    anon 2:32, I highly prefer the 5 meal plan over the 8 meal plan. I switched on the last possible day from 8 to 5 so I have a bit of experience being on both. The 5MP just feels a lot more flexible (although that has probably changed a bit since you can now use meals for lunches).

  9. Anonymous

    it says it here under important meal plan infohttp://www.cafebonappetit.com/wesleyan/downloads/wesleyandiningoverview.pdf

  10. Anonymous

    where are people getting the information that points roll over? sorry — I’m just paranoid that I’ll be thrifty in this last week only to have all my point cancelled when Spring semester starts.

  11. Anonymous

    where are people getting the information that points roll over? sorry — I’m just paranoid that I’ll be thrifty in this last week only to have all my point cancelled when Spring semester starts.

  12. Nina

    Points roll over from fall to spring, but not spring to fall. If you have points left over, add that to how many new points you have and enter that number into the “how many points do you have?” cell. Similarly, if you plan on buying an S&C contract, you can subtract the amount you spend on the contract from the total and be able to figure out how to spend the rest of your points.

  13. Nina

    Points roll over from fall to spring, but not spring to fall. If you have points left over, add that to how many new points you have and enter that number into the “how many points do you have?” cell. Similarly, if you plan on buying an S&C contract, you can subtract the amount you spend on the contract from the total and be able to figure out how to spend the rest of your points.

  14. Anonymous

    Yes, points roll over from fall to spring semester. But I’m not sure if points roll over from spring to fall.

  15. Anonymous

    Yes, points roll over from fall to spring semester. But I’m not sure if points roll over from spring to fall.

  16. Justin

    Wow. Excellent work on the spreadsheet, Matt. I’m glad we have a math major on the Wesleying crew. :-PP.S. Tags: yes!

  17. Justin

    Wow. Excellent work on the spreadsheet, Matt. I’m glad we have a math major on the Wesleying crew. :-P

    P.S. Tags: yes!

Comments are closed.