Tag Archives: it seems to have stopped precipitating but they’re saying it might start up again

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.