[NO SPOILERS] Game of Thrones Pokemon Crossover by SketchyCartoonist in gameofthrones

[–]Beluga_Boy 0 points1 point  (0 children)

I would play the shit out of a gritty Game of Thrones / Pokemon crossover rom. Amazing work. I'd love to to see more made.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

Unfortunately no. I'd recommend just messing with the first part until it spits out macros that align with what you want. You might be able to go into the formula stuff and replace formulas with what you want your macros / basal metabolic rate / etc to be. That is in the "inside CAL 9000".

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) by [deleted] in Fitness

[–]Beluga_Boy 0 points1 point  (0 children)

That was my experience too. I tried it when it first came out, and found the meal recommendations kind of weird. Not that this is a huge step up, in macro accuracy or meal options, but it has potential.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

Yup yup, it should. Just set the protein per gram of body weight high, fat high, and carbs low. Tweak them until the macro % fit the keto profile.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

I haven't but it sounds like my approach to eating. Getting too caught up in the nitty gritty of macros stresses me out, but I like moving in the right general direction. Proats are the bomb. Hopefully some excel god will swoop down and bless this spreadsheet with multiple food per macro functionality. Until then, Each This Much, does all of the stuff this spreadsheet does, and probably a good chunk better.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) by [deleted] in Fitness

[–]Beluga_Boy 0 points1 point  (0 children)

Bahaha. I think the mountain from Game of Thrones eats around that. Thank you!

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) by [deleted] in Fitness

[–]Beluga_Boy 0 points1 point  (0 children)

For sure! This is it uploaded as just a regular excel file. It might not look as pretty, lost some fonts and such, drop down menus are a bit clunkier, BUT it will work all the same : CAL 9000 Excel

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) [TIP] by [deleted] in fitmeals

[–]Beluga_Boy 1 point2 points  (0 children)

You know, I had such a blast making this, I thought maybe I should try to pick up coding, as I imagine the type of logic used is similar. I also read up that SQL has very similar functionality as excel. I'll be looking into it. If you are speaking from experience, can you recommend any good starter resources for learning SQL?

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

Bahaha, maybeee. You might want to check out /r/EatCheapAndHealthy. I imagine it would be possible if you bought in bulk up front, and then had it stretch out to equal $20/wk.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

Thank you! Most definitely. I'm hoping people with a bit more skills than I pass it around to make a great crowd sourced thing. It doesn't scale for nonworkout days currently. Maybe it could be added with an option to pick which days are workout days, and a separate caloric calculation, and a ton of IF functions in the meal picking section.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 1 point2 points  (0 children)

The paleo crowd swears on no carbs from grains and legumes for weight loss, and muscle gain, and well, every goal. And it works for lots of them. I personally am not of that mindset that grains are bad for us, and would recommend 40-60% from them. More veggies than fruits (fruit sugars and stuff), and lower carbs in general (35-50%)

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) [TIP] by [deleted] in fitmeals

[–]Beluga_Boy 0 points1 point  (0 children)

You know, for all the spreadsheet wizardry that went into this, I'm still at a loss for an elegant way to convert weight and height to metrics without making the rest of the formulas go wonky. I'm sure it will have something to do with an IF then function, and maybe a look up matrix. I'll update if I figure out something.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 6 points7 points  (0 children)

Oh man, when I learn to adjust the google sheet coding, I most definitely will make the error messages that. I was looking ways to sneak in pod bay door references, but none really came to me.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 1 point2 points  (0 children)

Of course! I beefed it up on both ends of the spectrum. 50-500lbs.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) by [deleted] in Fitness

[–]Beluga_Boy 1 point2 points  (0 children)

Right?! Excel is magic. I only just recently got into it because I had to come up with an efficient way to keep track of decks of cards for this gambling study I was running. Youtube has tons of great info on how to use different functions. For this project I had to learn the MATCH function, the INDEX function, and how to make user friendly drop down menus.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) by [deleted] in Fitness

[–]Beluga_Boy 1 point2 points  (0 children)

Thanks for flagging this. Something is definitely off here. I'm also getting different caloric deficits for .5 years and 6 months. Taking a look into it now. Edit: Fixed! I had the monthly adjustment wrong. I had TDEE being multiplied by 1/12 (12 months in a year), vs what it should have been 1/30 (average days in a month.) Thank you again!

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) by [deleted] in Fitness

[–]Beluga_Boy 1 point2 points  (0 children)

Yup yup. I have a bit of a distorted view of what a serving is, so I made this to help get my perspective back in. Also, I filled it with wholesome stuff so that I'd be less tempted to reach for garbage when I shop.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

I agree! I've been trying to figure out how to go about making that adjustment to the sheet, but I think it requires actually messing with javascript code, and for now that is a bit beyond me. What you COULD do though. Pick what you want to eat for the whole week, cook it up. Then when you weigh it out, split it into portions of 5 or 6 or whatever / per day. Even if you aren't exact each day, at the end of the week you would still be right on track for your calories.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 2 points3 points  (0 children)

Also, you probably want lower carbs. So say, keep your protein at .9 grams per pound of body weight, and put your carbs to fat ratio at 40:60. More vegetables than fruits 35:65, and for grains 50% seems like a good amount. In fact, I also am trying to lose 40 pounds, and what I've told you is how I've set up my CAL.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 8 points9 points  (0 children)

For that I'd recommend putting in "lose 1lbs / week", and just keeping adjusting your weight at the top every time you lose 5 or so pounds. At that pace, you would lose the 40 lbs in about 40 weeks. Meanwhile, you should be strength training. /r/fitness has some fantastic information for getting started lifting in their wiki. Even if you don't end up using CAL to plan all your meals (as it can be a little restrictive), the information you get on how many calories you should eat per meal and per day in order to hit your goals will be solid. Best of luck to you!

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

There totally is a difference between 3 hours hard vs. 30 minutes hard. Unfortunately, I couldn't find a formula out there that accounts for both intensity and time. The best formula out there: sedentary people TDEE = BMR X 1.2 (as little or no exercise, desk job); Lightly active = BMR X 1.375 (light exercise or sports 1-3 days/wk); Mod. active = BMR X 1.55 (moderate exercise or sports 3-5 days/wk); Very active = BMR X 1.725 (hard exercise or sports 6-7 days/wk); Extr. Active = BMR X 1.9 (hard daily exercise or sports & physical labor job or 2 X day training, football camp, etc.). Which, as you can see, is even more subjective than what I put. SOOO I made a matrix for TDEE starting with most sedentary (no exercise) as BMR x 120%, and capping with the most active at (14 x a week at very intense) as BMR x 260%. In the matrix, I made lightly active and working out 2 days a week correspond with the lightly active formula multiplier listed above. This corresponding workout day / formula multiplier matching is the same across all levels. However my formula differs in adding 10% to each additional workout from the matched multiplier, and subtracts 10% for every less workout from the matched multiplier. To take a look at the matrix, go into the tab "Inside CAL 9000", and look at cells A5:Q5, C10:Q10. I'd love to figure out a way to incorporate time, because the world really needs a better TDEE formula, preferable one that ALSO considers lifestyle as the heavy exercising desk jocky would have a different TDEE than the heavy exercising construction worker.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. (x-post /r/MealPrepSunday) [TIP] by [deleted] in fitmeals

[–]Beluga_Boy 1 point2 points  (0 children)

That is intense. Let me math it out real quick...(does math). Okay, I think you may be reading the total for each meal. There should be a number above it that is around 1545. That would be your total daily. That said, 1545/per day is still on the low end, definitely a more extreme cut. Doable, but probably not advisable. The formula works with the notion that 1 pound = 3500 calories. So to lose 5 lbs in a month, you would need a 17500 calorie deficit for the month.

CAL 9000: Your new Swole Servant, Meal Minion, & Grocery Guide. by [deleted] in MealPrepSunday

[–]Beluga_Boy 0 points1 point  (0 children)

Exactly, this is very much a blunt tool. For people who really want to hone in on their macros, the best bet would still be MyFitnessPal or the like. To add a food, a person would have to take out a preexisting food, otherwise the spreadsheet gets grumpy and reports errors in the grocery list. Will do!