- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Anyone an excel guru who knows how to add plate math to a spreadsheet
Posted on 6/15/20 at 5:56 pm
Posted on 6/15/20 at 5:56 pm
I have a pretty good 5/3/1 spreadsheet that I’ve developed. The only thing it’s missing is the plate math like is found on black iron beast.
Can someone break down what formulas or macros I need to have it show up for 245 such as [45, 45, 10] or something along those lines?
TIA
Can someone break down what formulas or macros I need to have it show up for 245 such as [45, 45, 10] or something along those lines?
TIA
Posted on 6/15/20 at 7:27 pm to OleWarSkuleAlum
You hate doing the math that badly huh?
Posted on 6/15/20 at 8:08 pm to GeorgeTheGreek
I learned plate math in kindergarten
Posted on 6/15/20 at 8:40 pm to GeorgeTheGreek
quote:
You hate doing the math that badly huh?
Yeah dude when I’m all jacked up at the gym I don’t want to be doing math.
Posted on 6/15/20 at 9:28 pm to OleWarSkuleAlum
tdniceandeasy@gmail.com
Send me your spreadsheet, and if I have some time tomorrow, I’ll give it a shot. If someone beats me to it, I won’t be offended.
And if you got something you can link me to or how you want it to look, let me know.
Send me your spreadsheet, and if I have some time tomorrow, I’ll give it a shot. If someone beats me to it, I won’t be offended.
And if you got something you can link me to or how you want it to look, let me know.
Posted on 6/15/20 at 9:40 pm to niceandeasy
Thanks I sent the spreadsheet to your email. If you could just put it in the notes section that would be perfect.
Posted on 6/16/20 at 9:20 am to OleWarSkuleAlum
I bit off more than I was expecting. I gave it a start, but I’m not willing to put any more time into it, haha
Feel free to take what I started and build off of it or scrap it and start from scratch.
The major two limitations on my version are
1. It doesn’t take multiple plates into account (if you have 4 10 lb plates, it only treats it like you have 2)
2. There’s cheat cells and then there’s cheat tabs. This has a complete cheat tab. It’s very...inelegant
Sorry, man. I even searched around on some excel forums and on Reddit to try to get a different perspective on it.
Feel free to take what I started and build off of it or scrap it and start from scratch.
The major two limitations on my version are
1. It doesn’t take multiple plates into account (if you have 4 10 lb plates, it only treats it like you have 2)
2. There’s cheat cells and then there’s cheat tabs. This has a complete cheat tab. It’s very...inelegant
Sorry, man. I even searched around on some excel forums and on Reddit to try to get a different perspective on it.
Posted on 6/16/20 at 10:57 am to niceandeasy
Here's how I do it. I have a sheet called weights that has 3 columns. TotalWeight, Plates, PerSide. TotalWeight is pretty self explanatory. PerSide is (TotalWeight - 45)/2. Plates is my plates to total the PerSide amount. Note: my gym does not have 35s, so you won't see them in mine. Here you go, though.
50 2.5 2.5
55 5 5
60 5+2.5 7.5
65 10 10
70 10+2.5 12.5
75 10+5 15
80 10+5+2.5 17.5
85 10+10 20
90 10+10+2.5 22.5
95 25 25
100 25+2.5 27.5
105 25+5 30
110 25+5+2.5 32.5
115 25+10 35
120 25+10+2.5 37.5
125 25+10+5 40
130 25+10+5+2.5 42.5
135 45 45
140 45+2.5 47.5
145 45+5 50
150 45+5+2.5 52.5
155 45+10 55
160 45+10+2.5 57.5
165 45+10+5 60
170 45+10+5+2.5 62.5
175 45+10+10 65
180 45+10+10+2.5 67.5
185 45+25 70
190 45+25+2.5 72.5
195 45+25+5 75
200 45+25+5+2.5 77.5
205 45+25+10 80
210 45+25+10+2.5 82.5
215 45+25+10+5 85
220 45+25+10+5+2.5 87.5
225 45+45 90
230 45+45+2.5 92.5
235 45+45+5 95
240 45+45+5+2.5 97.5
245 45+45+10 100
250 45+45+10+2.5 102.5
255 45+45+10+5 105
260 45+45+10+5+2.5 107.5
265 45+45+10+10 110
270 45+45+10+10+2.5 112.5
275 45+45+25 115
280 45+45+25+2.5 117.5
285 45+45+25+5 120
290 45+45+25+5+2.5 122.5
295 45+45+25+10 125
300 45+45+25+10+2.5 127.5
305 45+45+25+10+5 130
310 45+45+25+10+5+2.5 132.5
315 45+45+45 135
320 45+45+45+2.5 137.5
325 45+45+45+5 140
330 45+45+45+5+2.5 142.5
335 45+45+45+10 145
340 45+45+45+10+2.5 147.5
345 45+45+45+10+5 150
350 45+45+45+10+5+2.5 152.5
355 45+45+45+10+10 155
360 45+45+45+10+10+2.5 157.5
365 45+45+45+25 160
370 45+45+45+25+2.5 162.5
375 45+45+45+25+5 165
380 45+45+45+25+5+2.5 167.5
385 45+45+45+25+10 170
390 45+45+45+25+10+2.5 172.5
395 45+45+45+25+10+5 175
400 45+45+45+25+10+5+2.5 177.5
405 45+45+45+45 180
410 45+45+45+45+2.5 182.5
415 45+45+45+45+5 185
420 45+45+45+45+5+2.5 187.5
425 45+45+45+45+10 190
430 45+45+45+45+10+2.5 192.5
435 45+45+45+45+10+5 195
440 45+45+45+45+10+5+2.5 197.5
445 45+45+45+45+10+10 200
450 45+45+45+45+10+10+2.5 202.5
455 45+45+45+45+25 205
460 45+45+45+45+25+2.5 207.5
465 45+45+45+45+25+5 210
470 45+45+45+45+25+5+2.5 212.5
475 45+45+45+45+25+10 215
480 45+45+45+45+25+10+2.5 217.5
485 45+45+45+45+25+10+5 220
490 45+45+45+45+25+10+5+2.5 222.5
495 45+45+45+45+45 225
500 45+45+45+45+45+2.5 227.5
50 2.5 2.5
55 5 5
60 5+2.5 7.5
65 10 10
70 10+2.5 12.5
75 10+5 15
80 10+5+2.5 17.5
85 10+10 20
90 10+10+2.5 22.5
95 25 25
100 25+2.5 27.5
105 25+5 30
110 25+5+2.5 32.5
115 25+10 35
120 25+10+2.5 37.5
125 25+10+5 40
130 25+10+5+2.5 42.5
135 45 45
140 45+2.5 47.5
145 45+5 50
150 45+5+2.5 52.5
155 45+10 55
160 45+10+2.5 57.5
165 45+10+5 60
170 45+10+5+2.5 62.5
175 45+10+10 65
180 45+10+10+2.5 67.5
185 45+25 70
190 45+25+2.5 72.5
195 45+25+5 75
200 45+25+5+2.5 77.5
205 45+25+10 80
210 45+25+10+2.5 82.5
215 45+25+10+5 85
220 45+25+10+5+2.5 87.5
225 45+45 90
230 45+45+2.5 92.5
235 45+45+5 95
240 45+45+5+2.5 97.5
245 45+45+10 100
250 45+45+10+2.5 102.5
255 45+45+10+5 105
260 45+45+10+5+2.5 107.5
265 45+45+10+10 110
270 45+45+10+10+2.5 112.5
275 45+45+25 115
280 45+45+25+2.5 117.5
285 45+45+25+5 120
290 45+45+25+5+2.5 122.5
295 45+45+25+10 125
300 45+45+25+10+2.5 127.5
305 45+45+25+10+5 130
310 45+45+25+10+5+2.5 132.5
315 45+45+45 135
320 45+45+45+2.5 137.5
325 45+45+45+5 140
330 45+45+45+5+2.5 142.5
335 45+45+45+10 145
340 45+45+45+10+2.5 147.5
345 45+45+45+10+5 150
350 45+45+45+10+5+2.5 152.5
355 45+45+45+10+10 155
360 45+45+45+10+10+2.5 157.5
365 45+45+45+25 160
370 45+45+45+25+2.5 162.5
375 45+45+45+25+5 165
380 45+45+45+25+5+2.5 167.5
385 45+45+45+25+10 170
390 45+45+45+25+10+2.5 172.5
395 45+45+45+25+10+5 175
400 45+45+45+25+10+5+2.5 177.5
405 45+45+45+45 180
410 45+45+45+45+2.5 182.5
415 45+45+45+45+5 185
420 45+45+45+45+5+2.5 187.5
425 45+45+45+45+10 190
430 45+45+45+45+10+2.5 192.5
435 45+45+45+45+10+5 195
440 45+45+45+45+10+5+2.5 197.5
445 45+45+45+45+10+10 200
450 45+45+45+45+10+10+2.5 202.5
455 45+45+45+45+25 205
460 45+45+45+45+25+2.5 207.5
465 45+45+45+45+25+5 210
470 45+45+45+45+25+5+2.5 212.5
475 45+45+45+45+25+10 215
480 45+45+45+45+25+10+2.5 217.5
485 45+45+45+45+25+10+5 220
490 45+45+45+45+25+10+5+2.5 222.5
495 45+45+45+45+45 225
500 45+45+45+45+45+2.5 227.5
Posted on 6/16/20 at 10:59 am to niceandeasy
Thanks man appreciate it
ETA: holy hell thanks man. You put a lot of time into that. I appreciate it. I’m looking at the formulas and cel references now and trying to duplicate it across all the tabs
ETA: holy hell thanks man. You put a lot of time into that. I appreciate it. I’m looking at the formulas and cel references now and trying to duplicate it across all the tabs
This post was edited on 6/16/20 at 12:02 pm
Posted on 6/16/20 at 11:02 am to MyNameIsInigoMontoya
quote:
MyNameIsInigoMontoya
What’s the formula you have set up to look to that reference?
Posted on 6/16/20 at 12:27 pm to OleWarSkuleAlum
=VLOOKUP(B10,Weights!$A$1:$B$100,2,FALSE)
In this example, B10 would be the weight amount I was trying to hit.
In this example, B10 would be the weight amount I was trying to hit.
Posted on 6/16/20 at 2:29 pm to MyNameIsInigoMontoya
That worked exactly as I was conceptualizing in my head...
Posted on 6/17/20 at 7:15 am to OleWarSkuleAlum
Awesome, man. Glad it helped.
Popular
Back to top
Follow TigerDroppings for LSU Football News