Weezl's phase 1- recipe testing and frugalisation- come one, come all!

vandanfc

vanda, please can you add a kilo of sugar and 3 more litres of oil to the asda list and let me know the bad news price-wise?

Would add £3.46 to the bill = £102.55

artybear

Thanks spotdog. I have adjusted it now.

I think thats everything but shout if not.

artybearxxx

weezl74

many many thanks to vanda, arty and murrell :T:T:T

Aless thanks for the calcium info. It is very confusing when google shows conflicting info isn't it?

Are you still in researching mood?

Is anyone?

I could really do with knowing: If Bob, Shirley (both aged 47) and Jason (15) and Jenny (13) are all average heights for uk men/women and teens and all have a middle range BMI (22.5)

What their weight maintenance calorie requirement is in a day?

Now that's some piece of maths!

Alternatively maybe we each research one part of it, like I could do heights, post that and then someone else take it on a bit further?

xxx

weezl74

Allegra wrote: »

They were lovely ) Light, puffy, golden, just the right "bite" of herb and bacony saltiness. I guess I should have served them with potato salad, really, but although it turned out I had enough potatoes, they were a bit past their best, so while good enough for wedges, not really up to standard for a salad 8/10 from OH, 10/10 from me

I made a full batch - using one rasher of bacon - which meant we each had two, but with the spuds and beans or veg, it could have happily stretched to feed 4 at one each. Plus there is also the option of making smaller rounds, which could mean everyone in a family of 4 could have 2 each of the small ones, which might be an important psychological plus. Will definitely have again, thanks for the recipe !

A bit reluctant to post the photos, as I am so inept a photographer I could end up putting people off rather than enticing them in, but as I made the effort to snap away, I think I'll risk it

:T:T:T:T:T

hurrah for this Allegra that's amazing

1 rasher feeds a family of 4!

can't believe it :D:D:D:D:D

Bob can have meat at every meal :rotfl:

weezl74

murrell I was thinking of doing the vegan shop at tesco, since asda don't have cornmeal which is an excellent source of calcium.

Here is a list I'm thinking of. Would you mind giving it the once over and seeing if there are any vegan no-nos on it?

Thanks loads

aless02

weezl74 wrote: »

I could really do with knowing: If Bob, Shirley (both aged 47) and Jason (15) and Jenny (13) are all average heights for uk men/women and teens and all have a middle range BMI (22.5)

What their weight maintenance calorie requirement is in a day?

average heights; weights
Bob - 69.5in; 11st1 = 2391 calories
Shirley - 64.5in; 9st10 = 1959 calories
Jason - 67in; 8st12 = 2141 calories
Jenny - 61in; 7st3 = 1652 calories

These seem low to me, so someone else might want to do another calc with fresh research.

Lesley_Gaye

weezl74 wrote: »

oooh yes please! Firstly I noticed that I only want to bake 4 batches of carrot cake and cereal bars, but in the new improved spreadsheet this makes it look like we're baking it 128 times which throws our stock out! Can we express number of portions seperately from number of batches somehow, as both are useful to us tell me if that's too tricky...

weezl74 wrote: »

Also Lesley I notice you've integrated the veggie and meat versions in the new spreadsheet. That's a great idea from a functionality point of view, but I'm currently feeling like I still need 2 versions because some items are available to one planner but not the other IYSWIM?

Ie mince for planner 1, walnuts for planner 2, but not vice versa.

Is there a way we can work round that?

I may not have noticed a way you've already worked round that though, your sheet is very sophisticated compared to mine

What I did was to take your spreadsheet and apply the calculations that you were already doing more consistently; make those calculations automatic where they could be; and try to make it so that you only had to add limited data to apply any changes

I haven't added anything like amalgamating the veggie and meat plans, it must have been where you were at the time.

I can certainly add the number of portions, I'll have a look to see how best to do it

What I am trying to give you Weezl is a spreadsheet that can have any or all items of food set up in it, whatever you want, but only feeding through to the stock calculations if you actually use it. So if you have a 500g pk of chickpeas, but no dishes use it, enter '0' in number of packages and the stock check will not show it as left over stock, but will flag up that you still have a dish that uses some by saying that there are minus xg of stock left. Eg you have chickpea fritters in, but decide not to use them but to have lentil croquettes instead. What you would need to do is change the number of uses from, for instance, 2, to 0, and add the lentil croquettes by putting in the number of uses and the amount of ingredients they use.

My aim was to enable you to flip dishes in and out with ease and have the stock check done automatically.

To add any new dishes, you would need to add the 3 column 'set'

ie the name of the dish and then the 2 columns headed 'number of uses' and 'amount of ingredient remaining'. Colour the 'dish' column green to indicate this is a column in which to enter data, and copy and paste the formula for the remaining 2 columns

If you aren't familiar enough with Excel to do this, or haven't the time, I am quite happy to do it, I will give you a sheet with several empty 'dish' columns to use to start with anyway.

Or you could change eg Delias Tart to Lentil Croquettes, or whatever, and enter the amount of ingredients it uses and number of times it will be used

If you want to have completely separate planners with different lists of ingredients, just use a copy, it will still work

Oh dear, reading that back, it sounds quite complicated. If I have confused you, I will try and be clearer when we get to work through them

taka

I used this and came up with
Bob (47, 5ft 9, 11st 22.4BMI)
1899 sedentary (little or no exercise)
2175 lightly active (light exercise/sports 1-3 days/week)
2452 moderatetely active (moderate exercise/sports 3-5 days/week)
2729 very active (hard exercise/sports 6-7 days a week)
3006 extra active (very hard exercise/sports & physical job or 2x training)

Shirley (47, 5ft 3, 9st 2 22.6BMI)
1544 sedentary (little or no exercise)
1770 lightly active (light exercise/sports 1-3 days/week)
1995 moderatetely active (moderate exercise/sports 3-5 days/week)
2269 very active (hard exercise/sports 6-7 days a week)
2499 extra active (very hard exercise/sports & physical job or 2x training)

I got stuck on Jenny and Jason's heights/weights though!

Now... how much exercise do the family do... :eek: :rotfl:

Lesley_Gaye

aless02 wrote: »

average heights; weights
Bob - 69.5in; 11st1 = 2391 calories
Shirley - 64.5in; 9st10 = 1959 calories
Jason - 67in; 8st12 = 2141 calories
Jenny - 61in; 7st3 = 1652 calories

These seem low to me, so someone else might want to do another calc with fresh research.

from my many dieting forays I know that the daily maintenance requirement given for women is 2000 calories, and for men 2500. Avg height for women is 5'4", don't know mens.

2000 cals is near enough what you found Alless

taka

I think 2000 calories is what most nutritional guides on ready meals etc state for the average woman.