Complex equations with multiple input values

I’ll break it down clearly and step by step so it’s easy to follow.

Step 1: Set up your input sheet

1. Open Excel and create a new sheet called Calculator.
2. In column A, put your input labels:

    3. In column B, these will be your inputs:

Step 2: Calculate RER

The standard RER formula for mammals is:

In Excel, in cell B5, type:

=70*(B2^0.75)*B3

• B2 = ideal weight
• B3 = illness factor

Label A5 as RER (kcal/day). This will now automatically calculate the resting energy requirement.

Step 3: Preprogram diets

1. Make a new sheet called Diets.
2. In column A, enter Diet Code, column B Diet Name, column C kcal per can:

You can add as many as you like.

Step 4: Pull kcal per can automatically

Back in the Calculator sheet, in cell B6 (label A6 = kcal per can), use a VLOOKUP formula:

=VLOOKUP(B4, Diets!A:C, 3, FALSE)

• B4 = Diet Code input
• Diets!A:C = range of diet data on the Diets sheet
• 3 = column number for kcal/can
• FALSE = exact match

Now, when you type D1, D2, etc., the kcal per can will automatically populate.

Step 5: Calculate cans per day

In cell B7 (label A7 = Cans per Day), type:

=B5/B6

• This divides the calculated RER by kcal per can to give the number of cans needed per day.

How it works

1. Enter the patient’s ideal weight, illness factor, and diet code.
2. Excel calculates the RER.
3. It automatically pulls kcal per can based on diet code.
4. It calculates how many cans/day the patient needs.

You can expand this:

• Add multiple patients in rows.
• Add more diets.
• Format numbers to 1 decimal place for neatness.

General Free Excel Template Libraries

These sites have tons of templates; most are not veterinary, but you can adapt them easily:

Food / Nutrition Templates (Closer to your needs)

Templates that include calories, food logs, or meal tracking — these are the best base for your RER/can calculations:

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.