#### Rhythmdoctor

##### Footballguy

Let me back up a bit. In another thread, I was reading some interesting opinions/data from EBF regarding BMI. BMI has never been on my radar as far as potentially predictive indicator. Being an analyst by nature and by profession, last season (my 2nd year in a dynasty) I started a spreadsheet where I'm tracking WR combine/pro day metrics. Along with Name, height, weight, draft position, team and some other calculated metrics I came up with.

So, tonight I added a new column for BMI and created a formula for it. I figured some other stat geeks on here could use it. I started thinking about what thread to post it in but then figured it might be a good idea for excel equations to have it's own thread. I dunno.

That's a lot of words to post the formula I created for BMI in excel. I already have my sheet formatted where height reads as 6-3, for instance or 5-10 etc... Since the BMI formula requires height in the form of inches... I did the following (below). Cell column identifiers and matching names (per my sheet) below:

Column A - Player Name

Column B - Height

Column C - Weight

Formula - =703.06957964*(C2/((LEFT(B2,1)*12+IF(LEN(B2)=4,RIGHT(B2,2),RIGHT(B2,1)))^2))