Carbs and Fats are cheap. Here's a Guide to getting your PROTEIN's worth. Fiber also...

13567

Replies

  • MJFSH
    MJFSH Posts: 7,252 Member
    Wish i could download the spreadsheet! have to log in from home to try.
  • MJFSH
    MJFSH Posts: 7,252 Member
    bump
  • diannethegeek
    diannethegeek Posts: 14,776 Member
    Just giving this a bump so more people see it.
  • cerise_noir
    cerise_noir Posts: 5,468 Member
    Awesome post! :)
  • ddveedub
    ddveedub Posts: 140 Member
    I do admire a good spreadsheet! Well done.
  • MJFSH
    MJFSH Posts: 7,252 Member
    .
  • BABYLILAC
    BABYLILAC Posts: 148 Member
    Thank you so much <3
  • U2R2
    U2R2 Posts: 260 Member
    Great work. Thanks for sharing it.
  • MJFSH
    MJFSH Posts: 7,252 Member
    time for another bump
  • Need2Exerc1se
    Need2Exerc1se Posts: 13,575 Member
    Protein is cheap too if you have chickens and guns.
  • amusedmonkey
    amusedmonkey Posts: 10,330 Member
    Saved a copy of your sheet if you don't mind. Amazing work. I'm shocked that sweet cherries have protein quality that surpasses some meats, but too bad they don't have enough of it to matter.
  • MJFSH
    MJFSH Posts: 7,252 Member
    Time to bump this
  • diannethegeek
    diannethegeek Posts: 14,776 Member
    Love this chart. Could use a bump.
  • AnnPT77
    AnnPT77 Posts: 34,204 Member
    Too many "how do I get protein" questions lately. This needs a bump again, IMO.
  • shaneozouf
    shaneozouf Posts: 59 Member
    OK, I know this is an antiquated post by now. But you know that if you save a copy of the spreadsheet into google drive I can see all your other sheets. I see some sort of Budget on Sheet 3, a sheet called "run", and a fourth sheet called "copy_20150904". Just letting you know that there is some personal information here.
  • AnnPT77
    AnnPT77 Posts: 34,204 Member
    Time for a new bump.
  • MsHarryWinston
    MsHarryWinston Posts: 1,027 Member
    Bump
  • Ironandwine69
    Ironandwine69 Posts: 2,432 Member
    Wow. Another person in the world that has a thing for Excel just like me.
  • CaitiBurts
    CaitiBurts Posts: 1 Member
    How do I download this file? I would like to use it but it will not open other than to view......

    Btw this is mmus than amazing!!!!!
  • Penthesilea514
    Penthesilea514 Posts: 1,189 Member
    Bumping again- I love spreadsheets! :lol:
  • amusedmonkey
    amusedmonkey Posts: 10,330 Member
    CaitiBurts wrote: »
    How do I download this file? I would like to use it but it will not open other than to view......

    Btw this is mmus than amazing!!!!!

    tm86f4msyz7j.png


    Or use the "save a copy" option to save to your google sheets.
  • stephbarber2012
    stephbarber2012 Posts: 1 Member
    This looks quite impressive!! Thanks so very much!!!
  • AnnPT77
    AnnPT77 Posts: 34,204 Member
    So many "need protein" threads lately . . . must be time to bump this puppy back to the 1st page, eh?
  • edyates81
    edyates81 Posts: 7 Member
    Yes!!
  • LynnJ9
    LynnJ9 Posts: 414 Member
    andrikosDE wrote: »
    Below you can see the link to the Google Spreadsheet that I created containing 318 foods (as of 5th Sept. 2015) which shows the following:

    Column Title Meaning
    A P%Cal Rank Ranking of food by Protein Kcal / Total Cals (Highest is ranked 1st)
    B Food Food Name
    C Food Category 1 of 12 food categories
    D Kcal Caloric content of 100g of food (EU standard)
    E Protein Protein content per 100g of food (also doubles as a percentage)
    F Carb Carb content per 100g of food (also doubles as a percentage)
    G Fat Fat content per 100g of food (also doubles as a percentage)
    H Fiber Fiber content per 100g of food (also doubles as a percentage)
    I Grams Fiber/100kcal This is the fiber bang for your caloric buck information. Especially good for calorie restricted diets

    J Protein Quality This info is taken from the nutritiondata.self.com site. More info here: http://nutritiondata.self.com/help/analysis-help#protein-quality
    17fspk2prn99.jpg


    K Nutrient Completeness info
    This info is taken from the nutritiondata.self.com site. More info here: http://nutritiondata.self.com/help/analysis-help#nutrient-balance-indicator
    uvs366ipki5d.jpg

    L P%Cal Percentage of how many calories of protein as compared to the total calories of the food. In essence this is the reason this spreadsheet exists.

    M-U Hidden columns. They contain all the ranking of columns B-K above and are used to calculate the overall ranking of the foodlist.

    V Rank of Rankings Takes all the rankings above (M-U) and averages the rankings. Highest average ranking (lowest number) is the top food based on the above criteria (Seafood, tuna) and bottom has the lowest (Food, Chocolate Dark 45-59% cacao). It doesn't mean that the bottom ranked food is "bad", it just means that it's not best bank for the buck in regards to the above criteria.

    There you have it.
    Have fun browsing the list.


    https://docs.google.com/spreadsheets/d/12LrMGp8HiWl2FW-odoexKBMxeDTMUhwd4ooT6VoolJk/edit#gid=0


    PS If anyone wants to add more info, please let me know and I can provide you with editing privileges.

    This is such great information. Thanks
  • juliet3455
    juliet3455 Posts: 3,015 Member
    @andrikosDE Not sure if you noticed this so thought I should alert you.
    shaneozouf wrote: »
    OK, I know this is an antiquated post by now. But you know that if you save a copy of the spreadsheet into google drive I can see all your other sheets. I see some sort of Budget on Sheet 3, a sheet called "run", and a fourth sheet called "copy_20150904". Just letting you know that there is some personal information here.
  • amusedmonkey
    amusedmonkey Posts: 10,330 Member
    Time for a bump.
  • joinn68
    joinn68 Posts: 480 Member
    Thanks @amusedmonkey for the bump.
    I am reading the list and remember that grains are a source of protein! What with trying to limit carbs - not on a low carb diet just trying to consume more protein proportionnally without eating meats - I completely forgot that gluten IS a protein!
  • AnnPT77
    AnnPT77 Posts: 34,204 Member
    Another week, more protein questions on the site ==> another bump.
  • AnnPT77
    AnnPT77 Posts: 34,204 Member
    More bumping - lotsa protein questions lately.

Categories