When I enter values in INPUT Formulas calculate in OutPut

**AaruJaan** · 02-01-2017, 12:19 PM

Hi,

I have received a screenshot, I want to know when I put values in INPUT, how value come in OUTPUT, I mean what is the formula, please check the screenshot.

**CK76** · 02-01-2017, 12:34 PM

Probably using Brzycki formula for calculating 1RM.

1RM ≈ w/(1.0278-0.0278*r)

Where...
w is the amount of weight used (factor for the formula and unit does not matter).
r is the number of repetition performed.

So...
1RM ≈ 100/(1.0278-0.0278*10)
1RM ≈ 133.3689

Edit: See wiki for more details on 1RM calculation formulas.
https://en.wikipedia.org/wiki/One-repetition_maximum

Also if you want more accurate result use...
1RM =w/(37/36-(1/36*r))

**AaruJaan** · 02-01-2017, 12:54 PM

Thank you Mr CK76, you are genius.

When I enter values in INPUT Formulas calculate in OutPut

LinkBack

Thread Tools

Rate This Thread

Display

When I enter values in INPUT Formulas calculate in OutPut

Re: When I enter values in INPUT Formulas calculate in OutPut

Re: When I enter values in INPUT Formulas calculate in OutPut

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Display values based on input / output table

Need to enter symbol, run macro, then paste output as values

[SOLVED] VBA to enter various formulas every 10 rows and show dynamic formulas not values

[SOLVED] Look for values in sheet1 (input) and paste output in dedicated cells in sheet2

Need macro to loop through input cell values and copy output value

Input/output values into/from an array

Calculate output for the logic in the attached spreadhseet based on user input

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions