Lets say I have the following weight plates for my home gym:
4x 10 kg
6x 2 kg
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.