Ballistics

01-29-2008, 07:42 AM

Lets say I have the following weight plates for my home gym:

4x 10 kg

6x 2 kg

8x 1kg

2x 20 kg

I want to make a calculator in Excel where I say I want a total of 12 kg (for example), and it automatically assigns the available plates for each side of my weight lifting bar (so 6 kg per side).

It has to consider that I only have those available plates. And if it can't find a perfect match, it has to find the nearest weight.

Any ways this can be done in Excel?

Yes, I know it's easy so work out the weights on your own but I have a lot more weights than that and it would be quite helpful to plan my periodization routine more quickly. I'm sure it could come in helpful for others too.

4x 10 kg

6x 2 kg

8x 1kg

2x 20 kg

I want to make a calculator in Excel where I say I want a total of 12 kg (for example), and it automatically assigns the available plates for each side of my weight lifting bar (so 6 kg per side).

It has to consider that I only have those available plates. And if it can't find a perfect match, it has to find the nearest weight.

Any ways this can be done in Excel?

Yes, I know it's easy so work out the weights on your own but I have a lot more weights than that and it would be quite helpful to plan my periodization routine more quickly. I'm sure it could come in helpful for others too.