Freggie Tracking Spreadsheet 🍀☘💚✨🤍

mkksemail · April 9

I finally have a copy to share! I'd love both to share it, and to get feedback on how it works, etc. :) It's built around my Hogwarts Unbreakable Vow, but that can be changed down the line.

Link !

https://docs.google.com/spreadsheets/d/1t8GqvAe90j5WmU4l7zTQ-xSF5UuxfjIhqxgSwVVnVwo/edit?usp=sharing

Note from the first tab:

🥦💚✨ Hi Guys! :) This is a cut-out from a Freggie Tracker I've been working on.

I have been playing with it for a couple Hogwarts terms, (still playing with it 🤍💚 )I can't promise there are no artifacts leftover from the larger sheet, or that every link works (but I gave it a good effort, trying to edit for those!). This is very much a work in progress, but Chat GPT was super helpful in automating large chunks of it, and in setting up filters for unique food lists, etc. I invite you to track along with me, by making a duplicate of the template, and using it for your own tracking :). - - - > (named 'Freggie Tracking Template') )

The notes sheet I'll use to keep track of bits and stragglers that still need updating.

The format is built around my 'Unbreakable Vow' (a 4-wk mini-challenge) in a Hogwarts Challenge that I participate in. The first two 'Unbreakable Vow' tables, scrolling down, are fully auto-mated (each spanning 4-weeks), pulling in the Green Freggies foods entered in the weekly , Freggie Tracking Tables (there are 8-weeks of Freggie Tracking Tables) - with an exception! The dates for the weeks are manually entered/updated in the first Unbreakable Vow table, along with any notes to yourself about the week (ie not usual routine, etc). After entering the dates in the first table, all other instances of Week #s and Dates update automatically.

The next two tables, scrolling down, are Summary Tables for the Weekly Freggie Tracking Tables. Each of the summary tables covers 4 weeks. These summary tables are also fully auto-mated, pulling in data from the Weekly Tracking tables.

On the Weekly Tracking tables, there are spaces for individual food servings, in four different categories of foods. Each day has 10 spaces for entries, in each of the first 2 categories, and 5 spaces for entries in the last 22 categories. The first space, in each instance, is a dropdown menu, where you select the day, if you have an entry for that food category, or you select 'no', if you didn't have an entry for that food category.

That's basically it! The Unbreakable Vow tables will sort by 'Goal Days' and 'Bonus Days' for each week (my goal is 4 days per week with a serving of Green Freggie). It will also summarize a list of unique foods consumed across the 4 days. The weekly tables will sort both a weekly list of unique foods for each category, as well as a list of days the relevant foods were consumed, for each category, along with the specific (unique) foods consumed each day.

The 4-week summary tables are just that, they summarize all the tracked foods (not just Green Freggies), across the 4-weeks. I'd both love to share what I've been working on with others, and get feedback on how it works for others, too. The nav bars etc are all leftovers from the sheet I pulled the trackers from. I left them in place (for now, anyway), in case they might be repurposed later.

Short version instructions!1.) Right-click on the Template, choose Duplicate2.) Right-click on the copy generated, choose Rename to make it yours3.) Enter the foods consumed, in each of four categories (my categories are Green Freggies, Other Freggies, Nuts/Seeds/Beans/Legumes, and Fermented Foods), in the Weekly Tracking Tables.4.) Enter the Dates you're tracking in the first Unbreakable Vow Tracking Table.5.) The rest should sort itself out. Hopefully! ;)

mkk Xx
04/09/25

mkksemail · April 10

Thu 04/10/25	- Migrated Unique Green Freggies list, and Goal Days / Bonus Days formulas for Unbreakable Vow #1 table from Break to Term; adapted formulas for Unbreakable Vow #2 table. - Fixed the Format on the Weekly Tables for the Term. - Updated the formula for the Day counts for the individual weeks, in the Weekly tables.
T54 Wk1

SafariGalNYC · April 11

@mkksemail - wow!! 🤩 so well thought out!

Inspiring!! 🥬

mkksemail · April 11

Thank you, Mary! 💚💚💚 Tracking them, and seeing my misses and scores, helps me. The first several versions were so clunky and repetitive, tho. I was determined to find a way to automate it, but lacked the knowledge. I used ChatGPT as my tutor the last week+, I really wanted to automate it before the next Hogwarts term :)

It's still very much a work in progress (I think I said that in the note heh), but I really wanted to share it, b/c I love it so much, and was so excited that it got auotmated!! The Unique Foods list was one of the last additions. I kinda love that bit.

mkksemail · April 11

Fri 04/11/25	- Fixed the Week 4 Fermented Foods cell references on the 4-wk Summary Table, in the Weekly Tables for the Term §. Fixed the text wrapping, too.
T54 Wk1

SafariGalNYC · April 19

hey @mkksemail - how is the veggie tracking going!? 🥑🍓🥦🥕

mkksemail · April 23

hey @SafariGalNYC ! thx for asking :)) I was just coming to update here. I was 'in the zone' with some ChatGPT tutoring on a different section of the larger sheet I pulled the Freggie tracker from the last couple weeks, so much so I didn't post my greens pix! I went to update Wk 2 yesterday, and noticed some glitches in the cut out sheets, so I did some repairing/fixing on the tracker yesterday. One of the BIG issues with the template, I noticed, was that the HYPERLINK formulas for the Freggie wks were all pointing at my sheet, instead of staying within the Template sheet! Fixed that, and added instructions on how to customize should anyone choose to duplicate a sheet and track with me :). Did you try it out? I absolutely love the way it auto-populated my Unbreakable Vow tracking table, and the Unique Foods lists it generates :D!

I met - barely! - my Unbreakable Vow goal for weeks 1 and 2. Doing great on Other Freggies and Nuts etc. Greens and Fermented Foods are still an area of opportunity for me ;-).