craig.oates
/
overhaul2024
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
Code to help with the re-arranging of my life in 2024.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
114 Commits
1 Branch
0 Tags
2.3 MiB
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
overhaul2024/meal-planner.org

614 lines
30 KiB
Raw Permalink Normal View History Unescape

create meal-planner.org file.
3 months ago
#+options: ':nil *:t -:t ::t <:t H:3 \n:nil ^:t arch:headline author:t
#+options: broken-links:nil c:nil creator:nil d:(not "LOGBOOK") date:t e:t
#+options: email:nil f:t inline:t num:t p:nil pri:nil prop:nil stat:t tags:t
#+options: tasks:t tex:t timestamp:t title:t toc:t todo:t |:t
#+title: Meal Planner
#+date: \today
#+author: Craig Oates
#+email: craig@craigoates.net
#+language: en
#+select_tags: export
#+exclude_tags: noexport
#+creator: Emacs 29.1.90 (Org mode 9.6.10)
#+cite_export:
* Setup Common Lisp Environment
I’ve copied the following code block over from other files. Run it if this is
your first file open in the session.
#+begin_src lisp :session :results silent
(ql:quickload :com.inuoe.jzon) ; JSON parser.
(ql:quickload :dexador) ; HTTP requests.
(ql:quickload :plump) ; HTML/XML parser.
(ql:quickload :lquery) ; HTML/DOM manipulation.
(ql:quickload :lparallel) ; Parallel programming.
(ql:quickload :cl-ppcre) ; RegEx. library.
(ql:quickload :plot/vega) ; Vega plotting library.
(ql:quickload :lisp-stat) ; Stat's library.
(ql:quickload :data-frame) ; Data frame library eqv. to Python's Numpy.
(ql:quickload :str) ; String library, expands on 'string' library.
#+end_src
* Seven Day Meal Planner (AI Generated)
The plan below was formed using [[https://www.bing.com/][Bing Copilot]], and copied verbatim. I've decided
to go this route because I don't know enough about nutrition and I don't really
want to spend the time looking into the various websites/resources and what they
recommend. I did give Copilot my height and weight when it built out this
plan. I don't know if that changes things too much. The thing I'm most concerned
with it how much it'll cost.
:drawer:
#+begin_quote
Day 1:
Breakfast: Scrambled eggs with smoked salmon and a slice of whole grain toast.
Lunch: Grilled chicken salad with lots of mixed vegetables.
Dinner: Steak with quinoa and steamed broccoli.
Snacks: Greek yogurt, a handful of almonds.
Day 2:
Breakfast: Protein smoothie with banana, spinach, and a scoop of protein powder.
Lunch: Tuna salad with a side of whole grain crackers.
Dinner: Baked salmon with sweet potato and asparagus.
Snacks: Cottage cheese, a piece of fruit.
Day 3:
Breakfast: Oatmeal with a scoop of protein powder and a handful of berries.
Lunch: Turkey wrap with whole grain tortilla and lots of veggies.
Dinner: Grilled shrimp with brown rice and green beans.
Snacks: Hard-boiled eggs, a handful of walnuts.
Day 4:
Breakfast: Greek yogurt with granola and a handful of berries.
Lunch: Chicken stir-fry with lots of mixed vegetables.
Dinner: Baked cod with quinoa and steamed zucchini.
Snacks: Protein shake, a piece of fruit.
Day 5:
Breakfast: Scrambled eggs with turkey bacon and a slice of whole grain toast.
Lunch: Quinoa salad with grilled chicken and lots of mixed vegetables.
Dinner: Steak with sweet potato and steamed Brussels sprouts.
Snacks: Greek yogurt, a handful of almonds.
Day 6:
Breakfast: Protein smoothie with banana, spinach, and a scoop of protein powder.
Lunch: Tuna salad with a side of whole grain crackers.
Dinner: Baked salmon with brown rice and asparagus.
Snacks: Cottage cheese, a piece of fruit.
Day 7:
Breakfast: Oatmeal with a scoop of protein powder and a handful of berries.
Lunch: Turkey wrap with whole grain tortilla and lots of veggies.
Dinner: Grilled shrimp with quinoa and green beans.
Snacks: Hard-boiled eggs, a handful of walnuts.
#+end_quote
:END:
* Breakdown of Meal Planner
Below is a list of each item in the meal planner.
#+begin_src shell :results silent
DATA="Eggs
Salmon
Whole Grain Toast
Chicken
Vegetables
Steak
Quinoa
Broccoli
Greek Yogurt
Almonds
Banana Protein Smoothie
Spinach
Scoop Protein Powder
Tuna
Salad
Whole Grain Crackers
Salmon
Sweet Potato
Asparagus
Cottage Cheese
Fruit
Oatmeal
Protein Powder
Berries
Turkey
Whole Grain Tortilla
Vegetables
Prawns
Brown Rice
Green Beans
Eggs
Walnuts
Greek Yogurt
Granola
Berries
Chicken
Vegetables
Cod
Quinoa
Courgette
Protein Shake
Fruit
Eggs
Turkey
Bacon
Whole Grain Toast
Quinoa
Salad
Chicken
Vegetables
Steak
Sweet Potato
Brussels Sprouts
Greek Yogurt
Almonds
Protein Smoothie
Banana
Spinach
Protein Powder
Tuna
Salad
Whole Grain Crackers
Salmon
Brown Rice
Asparagus
Cottage Cheese
Fruit
Oatmeal
Protein Powder
Berries
Turkey
Whole Grain Tortilla
Vegetables
Prawns
Quinoa
Green Beans
Eggs
Walnuts"
echo "$DATA" > working-data/meal-planner-ingredients.txt
sort working-data/meal-planner-ingredients.txt \
| uniq -c > working-data/meal-planner-servings.txt
#+end_src
Having written that out to a file, I can see have many times each item was
listed. /Note/, this quantity value represents the number of serving in a given
week. It doesn't specify the quantity of the serving for each item. For example,
~1 Bacon~ doesn't mean /one strip of bacon/, it means /one serving/ of bacon in the
week.
#+begin_src shell :results output
head working-data/meal-planner-servings.txt
#+end_src
#+RESULTS:
#+begin_example
2 Almonds
2 Asparagus
1 Bacon
1 Banana
1 Banana Protein Smoothie
3 Berries
1 Broccoli
2 Brown Rice
1 Brussels Sprouts
3 Chicken
#+end_example
#+begin_src shell :results output raw
echo "SERVING,INGREDIENT" > working-data/meal-planner-servings.csv
while IFS= read -r line
do
csv_line=$(echo "$line" | awk '{$1=$1; print $1 "," substr($0, index($0,$2))}')
echo "$csv_line"
done < working-data/meal-planner-servings.txt >> working-data/meal-planner-servings.csv
echo "[[file:./working-data/meal-planner-servings.csv]]"
#+end_src
#+RESULTS:
[[file:./working-data/meal-planner-servings.csv]]
update meal-planner.org file.
3 months ago
* Manually Adjust Serving Quantities
The original version of this file has /semantically duplicated/ data in it, which
the code isn't really great at detecting. So, I've made minor adjustments, like
bundling up the ’Protein’ entries into one. I, also, replace ’Whole Grain’ with
’Wholemeal’ because I don't think I've ever seen anything labelled as ’Whole
Grain’ in the UK, making it harder to search for these types of items on the
various shopping websites.
#+NAME: servings-adjusted
| INGREDIENT | SERVING |
|-------------------------+---------|
| Almonds | 2 |
| Asparagus | 2 |
| Bacon | 1 |
| Banana | 1 |
| Banana Protein Smoothie | 1 |
| Berries | 3 |
| Broccoli | 1 |
| Brown Rice | 2 |
| Brussels Sprouts | 1 |
| Chicken | 3 |
| Cod | 1 |
| Cottage Cheese | 2 |
| Courgette | 1 |
| Eggs | 4 |
| Fruit | 3 |
| Granola | 1 |
| Greek Yogurt | 3 |
| Green Beans | 2 |
| Porridge | 2 |
| Prawns | 2 |
| Protein Powder | 6 |
| Quinoa | 4 |
| Salad | 3 |
| Salmon | 3 |
| Spinach | 2 |
| Steak | 2 |
| Sweet Potato | 2 |
| Tuna | 2 |
| Turkey | 3 |
| Vegetables | 5 |
| Walnuts | 2 |
| Wholemeal Crackers | 2 |
| Wholemeal Bread | 2 |
| Wholemeal Tortilla | 2 |
#+begin_src lisp :var table=servings-adjusted :results output raw
(let ((filepath #P"working-data/meal-planner-servings-adjusted.csv"))
(with-open-file (stream filepath :direction :output :if-exists :supersede)
(format stream "INGREDIENT,SERVING~%")
(dolist (row table)
(format stream "~{~a~^,~}~%" row)))
(format t "[[file:./~a]]" filepath))
#+end_src
#+RESULTS:
[[file:./working-data/meal-planner-servings-adjusted.csv]]
#+begin_src lisp :session
(lisp-stat:defdf *ingredient-servings*
(lisp-stat:read-csv #P"working-data/meal-planner-servings-adjusted.csv"))
#+end_src
#+RESULTS:
: #<DATA-FRAME:DATA-FRAME (34 observations of 2 variables)>
#+begin_src lisp :session :results output
(format t "~d servings of ~d ingredients."
(lisp-stat:sum *ingredient-servings*:serving)
(lisp-stat:length *ingredient-servings*:ingredient))
#+end_src
#+RESULTS:
: 78 servings of 34 ingredients.
#+begin_src calc :results output
78 / 7
#+end_src
#+RESULTS:
: 11.1428571429
I can't tell if 11 items a day is a lot or not (2024-03-04 Mon).
#+begin_src lisp :session :results file
(vega:defplot ing-serv
`(:title "Weekly Ingredient Servings"
:description "Percentage of how much each ingredient is served in a week."
:data ,*ingredient-servings*
:width 600
:height 300
:mark (:type :bar)
:encoding (:x (:field :serving :title "No. of Servings in Week." :type :quantitative)
:color (:field :ingredient :type :nominal :title "Ingredient" :legend (:symbol-limit 100))
:tooltip (:field :ingredient))))
(vega:write-html ing-serv "renders/ingredient-servings.html")
#+end_src
#+RESULTS:
[[file:renders/ingredient-servings.html]]
#+begin_src shell :results silent
mv ~/Downloads/visualization.png ./renders/ingredient-servings.png
#+end_src
[[file:./renders/ingredient-servings.png]]
The chart above shows the diet is fairly well balanced. With that said, the
chicken and vegetable servings are noticeably bigger than the others – followed
by eggs.
* Ingredients Availability
create meal-planner.org file.
3 months ago
I'm going to use ~csvlook~ to output the data into a org-mode table, which I will
then manipulate manually. The ~csvlook~ snippet is to just get me started.
#+begin_src shell :results output drawer
csvlook working-data/meal-planner-servings.csv
#+end_src
update meal-planner.org file.
3 months ago
- Merged ~Scoop Protein Powder~, ~Protein Powder~, ~Protein Shake~ and ~Protein
Smoothie~ into one ingredient.
- I replaced ~Whole Grain Toast~ with ~Wholemeal Bread~, I think this is a UK
branding issue (I’ve only ever seen ’wholemeal’, never ’wholegrain’).
- Replaced ~Whole Grain Tortilla~ with ~Wholemeal Tortilla~, for the same reason
as the bread.
create meal-planner.org file.
3 months ago
- ~0~ = ~False~ (i.e. Not sold by that supermarket)
- ~1~ = ~True~
update meal-planner.org file.
3 months ago
- Used =C-c +=, =C-y= to provide the column totals (instead of using formulas).
#+NAME: food-availability
| INGREDIENT | TESCO | SAINSBURYS | MARKS-AND-SPENCER | ASDA | CO-OP | WAITROSE | BOOTHS | MORRISONS |
|---------------------------+-------+------------+-------------------+------+-------+----------+--------+-----------|
| Almonds | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Asparagus | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 |
| Bacon | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Banana | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Berries | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Broccoli | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 |
| Brown Rice | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Brussels Sprouts | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 |
| Chicken | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Cod | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 |
| Cottage Cheese | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Courgette | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Eggs | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Fruit | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Granola | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Greek Yogurt | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Green Beans | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 |
| Oatmeal (Porridge) | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Prawns | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Protein Powder | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 |
| Quinoa | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 |
| Salad (in mixed bag) | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Salmon | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Spinach | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Steak | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Sweet Potato | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Tuna | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Turkey | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 |
| Vegetables (in mixed bag) | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 |
| Walnuts | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Wholegrain Crackers | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |
| Wholemeal Bread | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 |
| Wholemeal Tortilla | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 |
|---------------------------+-------+------------+-------------------+------+-------+----------+--------+-----------|
| Total | 33 | 32 | 0 | 32 | 23 | 31 | 0 | 32 |
*Looks like Tesco is the only one selling all the ingredients.* Sainsburys, Asda
and Morrisons are viable alternatives.
Marks and Spencer uses [[https://www.ocado.com/][Ocado]] to provide it online shopping service. Having a
quick look on their website, I noticed it say there is a ’Minimum spend of
£40’. For now, I'm going to not include them in the availability table
above. The reason why is because their prices seem more expensive than the
others in the table. If the totals for the shops listed above are above £40,
I'll come back to Ocado and see how much their prices differ.
Booths just seems to sell recipes or fully prepared /stuff/ from what I can
gather on their website… and lots of wine.
* Ingredients Quantity Breakdown
I expect I will need to use these values as base values and come back to this
file after I've got an idea about what quantities are good and what need
changing.
- ~0.25~ like values refer to using 1/4 of a pack, of said item (i.e. 0.25 of a
packet of nuts).
- ~CHICKEN~ and ~TURKEY~ like ingredients refer to chicken breasts, I don’t like
cooking whole chickens.
- ~EGGS~ refers to the number of eggs in the serving, not the number of
boxes/packs.
#+NAME: ingredient-quantities
| DAY | ALMONDS | ASPARAGUS | BACON | BANANA | BERRIES | BROCCOLI | BROWN RICE | BRUSSELS SPROUTS | CHICKEN | COD | COTTAGE CHEESE | COURGETTE | EGGS | FRUIT | GRANOLA | GREEK YOGURT | GREEN BEANS | OATMEAL (PORRIDGE) | PRAWNS | PROTEIN POWDER | QUINOA | SALAD (IN MIXED BAG) | SALMON | SPINACH | STEAK | SWEET POTATO | TUNA | TURKEY | VEGETABLES (IN MIXED BAG) | WALNUTS | WHOLEGRAIN CRACKERS | WHOLEMEAL BREAD (TOAST) | WHOLEMEAL TORTILLA |
|-----------+---------+-----------+-------+--------+---------+----------+------------+------------------+---------+-----+----------------+-----------+------+-------+---------+--------------+-------------+--------------------+--------+----------------+--------+----------------------+--------+---------+-------+--------------+------+--------+---------------------------+---------+---------------------+-------------------------+--------------------|
| Monday | 0.25 | 0 | 0 | 0 | 0 | 0.25 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0.25 | 0.25 | 1 | 0 | 1 | 0 | 0 | 0 | 0.25 | 0 | 0 | 2 | 0 |
| Tuesday | 0 | 0.25 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0 | 0.25 | 1 | 0.25 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 2 | 0 |
| Wednesday | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0.25 | 0.2 | 0.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0.25 | 0.25 | 0 | 0 | 2 |
| Thursday | 0 | 0 | 0 | 0 | 0.25 | 0 | 0 | 0 | 2 | 1 | 0 | 0.5 | 0 | 1 | 0.25 | 0.25 | 0 | 0 | 0 | 0.1 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 |
| Friday | 0.25 | 0 | 4 | 0 | 0 | 0 | 0 | 0.25 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0.25 | 0.25 | 0 | 0 | 1 | 1 | 0 | 2 | 0.25 | 0 | 0 | 2 | 0 |
| Saturday | 0 | 0.25 | 0 | 1 | 0 | 0 | 0.5 | 0 | 0 | 0 | 0.25 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0 | 0.25 | 1 | 0.25 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 |
| Sunday | 0 | 0 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0.25 | 0.2 | 0.5 | 0.1 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0.25 | 0.25 | 0 | 0 | 2 |
|-----------+---------+-----------+-------+--------+---------+----------+------------+------------------+---------+-----+----------------+-----------+------+-------+---------+--------------+-------------+--------------------+--------+----------------+--------+----------------------+--------+---------+-------+--------------+------+--------+---------------------------+---------+---------------------+-------------------------+--------------------|
| Total | 0.5 | 0.5 | 4 | 2 | 0.5 | 0.25 | 1. | 0.25 | 6 | 1 | 0.5 | 0.5 | 8 | 3 | 0.25 | 0.75 | 0.5 | 0.4 | 1. | 0.4 | 1. | 1. | 3 | 0.5 | 2 | 2 | 2 | 6 | 1.25 | 0.5 | 2 | 6 | 4 |
#+TBLFM: @>$2..$34=vsum(@I..@II)
#+begin_quote
*2024-03-04 Mon:* Going to write this file to disk and work with the CSV file
going forward. This table is a bit unwieldy in this ORG file. *I've kept this
table for reference. Do not expect it to be accurate as I will not update it.*
All updates will be in the CSV file moving forward.
#+end_quote
#+begin_src lisp :var table=ingredient-quantities :results output raw
(let ((filepath #P"working-data/meal-planner-quantities.csv"))
(with-open-file (stream filepath :direction :output :if-exists :supersede)
(dolist (row table)
(format stream "~{~a~^,~}~%" row)))
(format t "[[file:./~a]]" filepath))
#+end_src
#+RESULTS:
[[file:./working-data/meal-planner-quantities.csv]]
I need to transform the =meal-planner-quantities.csv= file so I can work out how
many of each item I need to buy. For example, the ~almonds~ total is ~0.5~ (at
time of writing), this means the nearest package quantity is ~1~. I can do it
using the file above, but I can transform it and build a template, of sorts, so
I can quickly run through various shopping websites and compare prices (if I
need to).
#+begin_src shell :results output raw
# Input CSV file path
input_csv_file="working-data/meal-planner-quantities.csv"
# Output CSV file path
output_csv_file="working-data/meal-planner-quantities-adj.csv"
# Extract header (first row) and footer (last row)
header=$(head -n 1 "$input_csv_file")
footer=$(tail -n 1 "$input_csv_file")
# Split header and footer into arrays
IFS=',' read -ra header_array <<< "$header"
IFS=',' read -ra footer_array <<< "$footer"
# Create a new CSV file with rows containing header and footer entries
echo "INGREDIENT,QUANTITY" > "$output_csv_file"
for ((i = 0; i < ${#header_array[@]}; i++)); do
echo "${header_array[i]},${footer_array[i]}" >> "$output_csv_file"
done
# Remove the 'Total' and 'Day' parts from the CSV file.
sed -i '2d' "$output_csv_file"
# Print out link to the CSV file.
echo "[[file:./$output_csv_file]]"
#+end_src
#+RESULTS:
[[file:./working-data/meal-planner-quantities-adj.csv]]
Having transformed the data, you should see something along the lines of the
table below.
#+begin_src shell :results output raw
# The output will need minor adjustments to its formatting, for org-mode.
head -n 4 working-data/meal-planner-quantities-adj.csv | csvlook
#+end_src
#+RESULTS:
| INGREDIENT | QUANTITY |
|------------+----------|
| ALMONDS | 0.5 |
| ASPARAGUS | 0.5 |
| BACON | 4.0 |
* Explore Data and Total Costs for Tesco
I'm going to build out the CSV file outside of this file. The reason why is it
requires quite a number of function cells to calculate totals, and quite
frankly, using org-mode table-formulas can get unwieldy quickly.
[[file:./working-data/meal-planner-totals-tesco.csv]]
#+begin_src shell :results output raw
csvlook working-data/meal-planner-totals-tesco.csv
#+end_src
The table below was derived from =working-data/meal-planner-totals-tesco.csv=. I
used ~csvlook~ to output the table and I've worked on it since then.
#+RESULTS:
| INGREDIENT | QUANTITY | PACKET-QUANTITY | TOTAL-PACKETS | PRICE-PER-PACKET | ITEM-TOTAL |
|---------------------------+----------+-----------------+---------------+------------------+------------|
| ALMONDS | 0.50 | 250 g | 1 | 3.1 | 3.10 |
| ASPARAGUS | 0.50 | 180 g | 1 | 1.6 | 1.60 |
| BACON | 4.00 | 10 | 1 | 2.25 | 2.25 |
| BANANA | 2.00 | 5 | 1 | 0.78 | 0.78 |
| BERRIES | 0.50 | 200 g | 1 | 2.75 | 2.75 |
| BROCCOLI | 0.25 | 1 | 1 | 0.82 | 0.82 |
| BROWN RICE | 1.00 | 1 kg | 1 | 1.85 | 1.85 |
| BRUSSELS SPROUTS | 0.25 | 300 g | 1 | 0.58 | 0.58 |
| CHICKEN | 6.00 | 2 | 3 | 2.6 | 7.80 |
| COD | 1.00 | 2 | 1 | 5.6 | 5.60 |
| COTTAGE CHEESE | 0.50 | 300 g | 1 | 1.55 | 1.55 |
| COURGETTE | 0.50 | 1 | 1 | 0.56 | 0.56 |
| EGGS | 8.00 | 10 | 1 | 2.9 | 2.90 |
| FRUIT | 3.00 | 6 | 1 | 0.95 | 0.95 |
| GRANOLA | 0.25 | 1 kg | 1 | 2.5 | 2.50 |
| GREEK YOGURT | 0.75 | 500 g | 1 | 1.1 | 1.10 |
| GREEN BEANS | 0.50 | 220 g | 1 | 0.89 | 0.89 |
| OATMEAL (PORRIDGE) | 0.40 | 1 kg | 1 | 0.9 | 0.90 |
| PRAWNS | 1.00 | 250 g | 1 | 2.69 | 2.69 |
| PROTEIN POWDER | 0.40 | 500 g | 1 | 18 | 18.00 |
| QUINOA | 1.00 | 300 g | 1 | 2.8 | 2.80 |
| SALAD (IN MIXED BAG) | 1.00 | 90 g | 1 | 1.35 | 1.35 |
| SALMON | 3.00 | 4 | 1 | 4 | 4.00 |
| SPINACH | 0.50 | 250 g | 1 | 1.15 | 1.15 |
| STEAK | 2.00 | 2 | 1 | 4.15 | 4.15 |
| SWEET POTATO | 2.00 | 1 | 2 | 0.42 | 0.84 |
| TUNA | 2.00 | 1 | 2 | 0.55 | 1.10 |
| TURKEY | 6.00 | 3 | 2 | 4.5 | 9.00 |
| VEGETABLES (IN MIXED BAG) | 1.25 | 1 kg | 1 | 1.65 | 1.65 |
| WALNUTS | 0.50 | 200 g | 1 | 2.75 | 2.75 |
| WHOLEGRAIN CRACKERS | 2.00 | 160 g | 1 | 2 | 2.00 |
| WHOLEMEAL BREAD (TOAST) | 6.00 | 400 g | 1 | 1 | 1.00 |
| WHOLEMEAL TORTILLA | 4.00 | 8 | 1 | 1.4 | 1.40 |
|---------------------------+----------+-----------------+---------------+------------------+------------|
| | | | | TOTAL | 92.36 |
£92.36 is way too high for my liking. £92.36 to feed a single person? I know
it's 2024 in the UK but that seems excessive.
#+begin_src calc :results output
92.36 / 7
#+end_src
#+RESULTS:
: 13.1942857143
Saying that, £13.19/day, on food, doesn't seem that unrealistic. On top of that,
the £13.19/day covers all three meals. Looks like I haven't been paying
attention, or I’m naturally finding ways to keep my food costs down.
#+begin_src calc :results output
92.36 - 18
#+end_src
#+RESULTS:
: 74.36
Taking away the protein powder (£18 is the cheapest) leaves the total still to
high. The quantities the protein powder was listed at suggests this is not a
weekly item. On top of that, there are quite a few items which will produce
excess waste at the end of the week, if sticking to the meal planner. +So, maybe+
+the next step is to work out how much is weekly, fortnightly and monthly?+ The
quantities are accounted for on a weekly basis. The amount of waste isn't
enough to carry me into the next week.
#+begin_src calc :results output
74.36 / 7
#+end_src
#+RESULTS:
: 10.6228571429
Removing the protein powder from the day spent, brings it down to
£10.62/day. Because of how likely I would be buying protein powder, maybe this
is a more realistic figure than the £13.92 one above?
#+begin_src calc :results output
92.36 * 4
#+end_src
#+RESULTS:
: 369.44
The total spend on food for the month (including weekly protein powder) is going
to be around £369.44/month, give-or-take a few days for the uneven amount of
days in each month.
#+begin_src calc :results output
74.36 * 4
#+end_src
#+RESULTS:
: 297.44
The monthly spend without the weekly protein powder is £297.44, give-or-take a
few days. I would still need to buy at least one protein powder a month,
though.
#+begin_src calc :results output
297.44 + 18
#+end_src
#+RESULTS:
: 315.44
create meal-planner.org file.
3 months ago
update meal-planner.org file.
3 months ago
That brings the total (with monthly purchase of protein powder) to £315.44,
give-or-take a few days.