Meal planner spreadsheet (not user-friendly but extensive)

[PaulBC]

I just remembered working on this a few years ago when my daughter was on dialysis and thought it might be worth sharing. I started playing by ear after working out a few weeks of meal plans with this, and I imagine that's where most of you are. But for anyone with an OCD streak who hasn't done this already...

This link is read-only but you should be able to copy it.
https://docs.google.com/spreadsheets/d/1zMfel7TiV9lnRiCQHrENRy1LHmBW2mfq5jqZytDja7E/edit?usp=sharing

The first sheet consists of thousands of entries of USDA data covering most foods. I forget my primary source for that, but probably usda.gov. The second sheet, called "selected" consists of entries in the master sheet mapped to shorthand keys like "egg" and "tuna". There are other sheets with specific meal plans. You can start with one of those and extend it. The easiest way to add a new food is to go to one of the rows with "-" in the "name" column and change the key.

You enter the portion in the "portion" column terms of the quantity given in the "reference" column. So if the reference is "1 cup" and you enter 0.333 you have about 1/3 cup.

There is a summary that looks like this:
calories      691.35
sodium      714.12
potassium      802.64
phosphorus      517.57
protein      37.76

That's about all the time I have to document it right now, but if there are questions, I will try to help, time-permitting.

[iolaire]

Quite extensive, good job.

Also I like the final items on the ABBREV tab...
80200   FROG LEGS,RAW
83110   MACKEREL,SALTED
90240   SCALLOP,(BAY&SEA),CKD,STMD
90480   SYRUP,CANE
90560   SNAIL,RAW
93600   TURTLE,GREEN,RAW

[PaulBC]

Some pretty interesting ones in the game meat category too, especially under "Alaska native".

CARIBOU,BONE MARROW,RAW (ALASKA NATIVE)
CARIBOU,EYE,RAW (ALASKA NATIVE)
CARIBOU,LIVER,RAW (ALASKA NATIVE)

At one point I had a script that was erroneously suggesting things like this as low phosphorous. Most likely the data was just missing.

[smartcookie]

This is incredible!  I am going to share this with my dietician.  Great work!

[PaulBC]

This is incredible!  I am going to share this with my dietician.  Great work!

Thanks! I don't know why I never shared this before. My daughter is coming up on two years post-transplant (doing wonderfully) so I don't think about it much anymore, but remember obsessing over phosphorous in particular when she was on dialysis.

[smartcookie]

Any father would worry and obsess.  I have a patient who controls his phosphorus through diet alone and he would love this spreadsheet!  I need to give it to him as well!

[PrimeTimer]

Thanks for sharing, PaulBC! This will be a great reference! Would also be great for traveling. Could print it out, maybe laminate it and carry it on trips.

Glad to hear your daughter is doing well after transplant. Keep on keeping on!