I Hate Dialysis Message Board
Welcome, Guest. Please login or register.
November 21, 2019, 11:25:12 AM

Login with username, password and session length
Search:     Advanced search
529194 Posts in 33290 Topics by 12355 Members
Latest Member: Di Girl
* Home Help Search Login Register
+  I Hate Dialysis Message Board
|-+  Dialysis Discussion
| |-+  Dialysis: Diet and Recipes (Moderator: amanda100wilson)
| | |-+  Meal planner spreadsheet (not user-friendly but extensive)
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: Meal planner spreadsheet (not user-friendly but extensive)  (Read 2161 times)
PaulBC
Full Member
***
Offline Offline

Gender: Male
Posts: 204


« on: June 06, 2017, 10:52:20 AM »

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.

Logged
iolaire
Elite Member
*****
Offline Offline

Gender: Male
Posts: 1735


« Reply #1 on: June 06, 2017, 11:26:23 AM »

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
« Last Edit: June 06, 2017, 11:28:31 AM by iolaire » Logged

Transplant July 2017 from out of state deceased donor, waited three weeks the creatine to fall into expected range, dialysis December 2013 - July 2017.

Well on dialysis I traveled a lot and posted about international trips in the Dialysis: Traveling Tips and Stories section.
PaulBC
Full Member
***
Offline Offline

Gender: Male
Posts: 204


« Reply #2 on: June 06, 2017, 11:46:03 AM »

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.
Logged
smartcookie
Full Member
***
Offline Offline

Gender: Female
Posts: 484


LMSW

« Reply #3 on: June 06, 2017, 12:01:01 PM »

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

I am a renal social worker.  I am happy to help answer questions, but please talk to your clinic social worker for specifics on your particular situation.
PaulBC
Full Member
***
Offline Offline

Gender: Male
Posts: 204


« Reply #4 on: June 06, 2017, 12:35:41 PM »

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.
Logged
smartcookie
Full Member
***
Offline Offline

Gender: Female
Posts: 484


LMSW

« Reply #5 on: June 06, 2017, 01:12:42 PM »

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!
Logged

I am a renal social worker.  I am happy to help answer questions, but please talk to your clinic social worker for specifics on your particular situation.
PrimeTimer
Elite Member
*****
Offline Offline

Gender: Female
Posts: 2214


« Reply #6 on: June 06, 2017, 01:55:55 PM »

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!
Logged

Husband has ESRD with Type I Diabetes -Insulin Dependent.
I was his carepartner for home hemodialysis using Nxstage December 2013-July 2016.
He went back to doing in-center July 2016.
Pages: [1] Go Up Print 
« previous next »
 

Powered by MySQL Powered by PHP SMF 2.0.15 | SMF © 2017, Simple Machines Valid XHTML 1.0! Valid CSS!