RFN Formulation Sheet

logo-white-background

Click here to purchase

 

gears

Suggest a Feature

Quick Overview and Tour of Features

If you are already familiar with NRC based formulation, this video goes over the features of this tool. Further videos are below with specific instructions on how to use each feature.

 

Current Version: v1.1

* Recommended Allowances edited for cats, which now calculate per 1000kcal/ME.
* Pet profiles now include lean cats and overweight cats.
* Now comes with 4 pet profiles
* Note added for Chloride
* Process for authorization edited so that you can an error message if your receipt code is incorrect
* Minor bugs fixed

 

How to Purchase and Install

1. Go to rawfedandnerdy.com/purchase/formulation to purchase.

2. When purchasing, enter a gmail as the billing email address. If you did not enter a gmail, please contact jenny@sitstaybeyond.com or savannah@feedthydog.com to update your order.

3. It takes up to 24 hours to complete your purchase.

4. You will then be added to 2 google documents: Authorization Access and the RFN Formulation Tool.

5. The RFN Formulation Tool will be “view only”. Create a copy of it into your Google Drive in order to edit it.

6. Once you have your own copy to edit, enter your receipt number, then click on the green box and click “allow access.”

7. That’s it! You can start using the spreadsheet!

 

How to Fill In Your Pet Profile

1. Fill in your pet’s species.

2. Fill in your pet’s weight, either in pounds or kilograms. (Pounds will automatically convert to kilograms)

3. Fill in your pet’s energy number (using the chart provided) or enter the amount of calories you want to feed per day.

4. Optional – fill in your pet’s age.

5. Optional – fill in your desired macro-nutrient breakdown of calories. (How many calories come from protein/fat/carbs).

6. Optional – fill in your goal for grams of total fiber per day.

7. Decide on how bio-available minerals are in plant matter–cooked starches (rice, quinoa, buckwheat, sweet potato, oatmeal) and other plants.

 

How to Use the Recipe Sheet

1. Find ingredients in the first row by using the drop down menu or by typing to search for an ingredient.

2. Enter the quantity of the ingredient you want to add in grams (for food items) or in servings (for supplements).

3. Check the box to add the ingredient to your recipe.

4. To see all nutrients, click on the arrows in the far left (by the row numbers) to see hidden nutrients.

5. The “% of Goal” column measures the total amount of the nutrient against the RA or the goal you set in your pet profile. If you have not met your goal yet, it will be yellow. When you meet your goal, it will turn green. When you pass SUL, it will turn red. If you do not need to completely meet the RA, it will be gray.

 

Get a Batch Ingredient List and Save a Recipe

Get a Batch Ingredient List

1. When you’re done with your recipe, scroll down to the next section of the recipe sheet labelled “Batch Ingredient List.”

2. Fill in the number of servings you want and what units you what the numbers in.

3. You will see a list of ingredients and the quantity per ingredient you need for your food prep.

Save a Recipe

1. Scroll down to the last section of your recipe sheet, labelled “Save a Recipe (per 100g)”.

2. Copy the entire purple area.

3. Go to the Foods sheet, to a new column.

4. Enter a name for your new recipe and categorize is as “Recipe.”

5. In the very next row, paste values only.

6. You can now use this recipe as a food entry. To find out how many grams the original recipe was, look in the “Original Weight” row in the food entry. This allows you to look at all the previous values and percentages of the original recipe.

8. You can also use the Saved Recipe Ingredients sheet to look up the batch ingredient list for that recipe. On that sheet, select the recipe you want to look up.

9. Enter either a total weight of the batch you want, or the total calories you want. Choose a unit of measurement.

 

The Food Database and Adding New Foods

1. The foods database categorizes foods in 5 different groups:

  • Animal: any animal derived product with very high bioavailability
  • Cooked Starches: energy dense, starchy plants, such as rice, quinoa, buckwheat, rice and oats
  • Other Plants: other plant matter, cooked or raw
  • Supplements: non-food items with special serving sizes (not by grams)
  • Recipe: Saved recipes using a “Save This Recipe” feature

2. Serving size is 100g for all food items (animal, plant and recipes), and for supplements, it is the type of serving (tablets, mg, mL, etc.)

3. Original weight only applies to saved recipes.

Importing New Foods

1. Manually enter new foods by typing it in.

2. You can also use the Import sheet to quickly add foods from the USDA food database.

3. Go to the USDA food database at: https://ndb.nal.usda.gov/ndb/search/list

4. Search for a food item, using “standard references.”

5. When you’ve selected a food, to to “full report” and download the report. If you do not have Excel, you can upload the .csv file to Google Drive to convert it to Google Sheets.

6. Copy the first three columns and paste it into the yellow area in the Import sheet.

7. Copy the entire blue column to the right.

8. Go to the Foods sheet. Enter the name of the new food, as well as the category.

9. Paste, values only.

 

Estimations – What They Are, What’s Included and How to Do Your Own

Any item marked with a * means that some of the values included in the food nutrient profile have been estimated or extrapolated from commercial sources, research studies and the USDA food database.

If you are interested in adding your own estimations:

  • Search online for commercial or research analysis of the ingredient
  • Use a close substitution
  • Check the Raw Fed and Nerdy facebook group, in the files and previous posts
  • Check on Lauren Bay’s video on the RFN group on how to extrapolate your own data

 

Submitting Your Recipe for Feedback

Screenshots to Post:

  • Your pet’s full profile
  • All relevant nutrients, along with the “total” column and “% of goal” column.
  • Your Batch Ingredients List and 2 pie charts (set the Batch Ingredients to 1 serving in grams)
  • Optional: If there is a specific nutrient you are concerned about, you can use the “Nutrient Contributors” to post which ingredients are contributing the most and least to the specific nutrient you are concerned about.

 

Adding More Pets

There are a couple workaround methods if you need more than 2 pet profiles.

    1. Make a second (or third, etc.) copy of your spreadsheet. Downside: you have to have multiple formulation spreadsheets.
    2. Formulate for 4 pets at a time. Save completed recipes using the “Save This Recipe” feature in order to have recipes for multiple pets. Downside: tedious to switch between pets.
    3. Add more pet profiles by following the instructions below (video will be added at a later date).

Add More Pet Profiles and Recipes:

  1. Make as many duplicates of pet profiles that you need. Now make 1 recipe sheet per new pet profile by duplicating a previous recipe sheet.
  2. Go one of the new recipe sheets. For this example, we’re going to say that you are making Pet #5 from a Pet #1 duplicated sheet.
  3. Now we’re going to change some formulas. On the ‘RA’ column, anytime there is the phrase “Pet 1 Profile” in the formula, you are going to change it to “Pet 5 Profile”. Some formulas have multiple references, be sure to change them all.
  4. Do the same in the SUL column.
  5. Finally, do the same in the “% of Goal” column. (There are only a few to change here!)
Instructions for v1.0

There are a couple workaround methods if you need more than 2 pet profiles.

  1. Make a second (or third, etc.) copy of your spreadsheet. Downside: you have to have multiple formulation spreadsheets.
  2. Formulate for 2 pets at a time. Save completed recipes using the “Save This Recipe” feature in order to have recipes for multiple pets. Downside: tedious to switch between pets.
  3. Add more pet profiles by following the instructions below. Warning: This WILL slow a spreadsheet down and is tedious to set up.

Add more pet profiles:

  1. If you have both cats and dogs, decide which species is Pet 1 and which species is Pet 2. For this example, I will use Pet 1 = Dog and Pet 2 = Cat.
  2. For all your dogs, make a copy of Pet 1 Profile. Rename these Dog 1 Profile, Dog 2 Profile, etc. (Pet 1 Profile becomes Dog 1 Profile) Do the same for the cats. Make a copy of the Pet 2 Profile and rename them Cat 1 Profile, Cat 2 Profile, etc.
  3. Rename Pet 1 Recipe 1 to Dog 1 Recipe.
  4. Go to Pet 2 Recipe 2. Rename it to Dog 2 Recipe. Now we’re going to change some formulas. On the ‘RA’ column, anytime there is the phrase “Dog 1 Profile” in the formula, you are going to change it to “Dog 2 Profile”. Some formulas have multiple references, be sure to change them all. Do NOT change the “Pet 1 Calculations.”
  5. Do the same in the SUL column.
  6. Finally, do the same in the “% of Goal” column. (There are only a few to change here!)
  7. If needed, duplicate the last recipe sheet and repeat the same process (#4-6) for the other recipe pages for the same species.
  8. If you added more recipes sheets for dogs (if you have more than 2 dogs), follow steps #9-13.
  9. Click on the “all sheets” icon on the bottom bar. It is four rows of lines on the bottom left corner.
  10. Find the hidden sheet “Pet 1 Calculations” and open it.
  11. On the right hand side, there are two sets of tables marked “Recipe 1” and “Recipe 2.” Rename those as “Dog 1 Recipe” and “Dog 2 Recipe.”
  12. Copy one of the tables and paste it to an empty area (repeat for as many extra profiles you made.)
  13. In the table, for the numeric values, change the references to “Dog x Recipe” (changing the number to be what you need.) Double check that the references are still to the right row number.
    • Originally, protein was C9, fat was C33, carbs were C57 and fiber was C58. So your formula should reference “‘Dog 3 Recipe!’C9” for protein, for example.
  14. Repeat #2-13 for cats!

Note: same species pets will need to the same values for both sets of plant matter bio-availability. I recommend copying and pasting sets so that values remain exactly the same!

Questions?