Yeah, although shouldn’t it be MTW = 3RM*(.875)? The only reason I left that out was because the “off” numbers bothered me. I didn’t like seeing a 274 bench press…So after I calculated the few lifts out by hand, I rounded to the nearest 5 pounds so it looked better…lol.[/quote]
You’re right - for the upper body exercises it’s .875 and for the lower it’s .8.
As for the rounding, Excel doesn’t seem to like to round to the nearest 5 - you’re forced to either go up to the next 5 or down or down. That means if you choose to go down, 294 will go down to 290. Conversely, going up means 291 will go to 295. But if you don’t mind that, then use the CEILING function. Otherwise, just enter by hand as you’ve been doing. It doesn’t take terribly long to enter some of this stuff manually. I’m a computer programmer at heart (but not by profession) and like to have my spreadsheets as automated as possible.[/quote]
I haven’t seen the sheets, I have my own log–but you could take care of this with IF statements.
That should round to the nearest five. Clumsy code but works.
Essentially, if you have a 293lb MTW, it will check to see whether your MTW is closer to 290 or 295, then respond appropriately