Spreadsheet: 46317d1245232456-named-formulas-to-reference-relative-rows-weight-chart_new2
Sheet: Weight Chart (2009)

 |  |  |  |  |  | YMCA | NAVY
 |  | Weight | Neck | Abs/Waist | Hips | Body Fat | Body Fat | BMI | Hip/Waist
 | Starting
 | Current
 | Loss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (M or F) ? | *need these for drop down list … do NOT delete
 | % wt Loss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MALE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEMALE
 | Height |  | Gender | Age | Month | Day | Year
 | Feet | Inches | MALE | 30 | 12 | 31 | 2008 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | *test … do not delete
 | 5 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
week | Date | Weight | Neck | Abs/Waist | Hips | BMI | [NAME] | BMR | Body Fat
0 |  | 239 | 18 | 44 | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTH | DAY | YEAR
 |  | 237 | 18 | 44 | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (month) | (day) | (year)
 |  | 235 | 18 | 44 | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 2008
 |  | 234 | 17.5 | 44 | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2009
 |  | 232 | 17.5 | 44 | 47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 2010
 |  | 230.5 | 17 | 44 | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 2011
 |  | 230 | 17 | 44 | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 2012
1 |  | 228.5 | 17 | 43.5 | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 2013
 |  | 228 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 7 | 2014
 |  | 226.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 2015
 |  | 225.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 9 | 2016
 |  | 224 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 2017
 |  | 225 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 11 | 2018
 |  | 224 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 12 | 2019
2 |  | 225 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 2020
 |  | 224 | 17 | 43.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  | 225 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  | 224 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  | 226 | 2 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  | 224 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  | 225 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
3 |  | 224 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  | 225 | 16.25 | 43.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  | 226 |  |  |  |  |  |  |  |  |  |  |  |  | BMI INDEX |  |  |  |  |  | 22
 |  | 224 |  |  |  |  |  |  |  |  |  |  |  |  | Morbidly Obese |  | > 40.0 |  |  |  | 23
 |  | 225 |  |  |  |  |  |  |  |  |  |  |  |  | Obese II |  | 35.0 - 39.9 |  |  |  | 24
 |  | 225 |  |  |  |  |  |  |  |  |  |  |  |  | Obese I |  | 30.0 - 34.9 |  |  |  | 25
 |  | 223 |  |  |  |  |  |  |  |  |  |  |  |  | Over Weight |  | 25.0 - 29.9 |  |  |  | 26
4 |  | 225 | 17 | 43 |  |  |  |  |  |  |  |  |  |  | Normal Range |  | 18.5 - 24.9 |  |  |  | 27
 |  | 223 |  |  |  |  |  |  |  |  |  |  |  |  | Underweight |  | 17.6 - 18.4 |  |  |  | 28
 |  | 221 |  |  |  |  |  |  |  |  |  |  |  |  | Anorexia |  | < 17.5 |  |  |  | 29
 |  | 223.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  | 221.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  | 225.5 |  |  |  |  |  |  |  |  |  |  |  |  | HIP to WAIST RATIO INDEX
 |  | 223 |  |  |  |  |  |  |  |  |  |  |  |  | men | women | Health Risk
5 |  | 222 | 17 | 43.5 |  |  |  |  |  |  |  |  |  |  | < 0.95 | < 0.80 | low
 |  | 221.5 |  |  |  |  |  |  |  |  |  |  |  |  | 0.96 - 9.99 | 0.81 - 0.84 | moderate
 |  | 221 |  |  |  |  |  |  |  |  |  |  |  |  | > 1.00 | > 0.85 | high
 |  | 221.5
 |  | 224
 |  | 224
 |  | 220 |  |  |  |  |  |  |  |  |  |  |  |  | BODY FAT INDEX  *general
6 |  | 220.4 | 16.5 | 42.5 |  |  |  |  |  |  |  |  |  |  |  | men | women
 |  | 221.6 |  |  |  |  |  |  |  |  |  |  |  |  | essential fat | 2-4% | 10-12%
 |  | 219.2 |  |  |  |  |  |  |  |  |  |  |  |  | athletes | 6-13% | 14-20%
 |  | 219.8 |  |  |  |  |  |  |  |  |  |  |  |  | fitness | 14-17% | 21-24%
 |  | 219.4 |  |  |  |  |  |  |  |  |  |  |  |  | overweight | 18-25% | 25-31%
 |  | 218.6 |  |  |  |  |  |  |  |  |  |  |  |  | obese | > 25% | > 32%
 |  | 218.8
7 |  | 218 | 16 | 42 | 43.25
 |  | 216.2
 |  | 217.4
 |  | 216.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (choose)
 |  | 217.6 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | old |  |  |  |  | old
 |  | 216 |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  | new
 |  | 216.4 |  |  |  |  |  |  |  |  |  |  |  |  | 3
8 |  | 217.4 | 16.5 | 42.75 | 43.75 |  |  |  |  |  |  |  |  |  | 3.9
 |  | 217.2 |  |  |  |  |  |  |  |  |  |  |  |  | 5.001
 |  | 217 |  |  |  |  |  |  |  |  |  |  |  |  | 6.1
 |  | 217.8
 |  | 216.6
 |  | 215 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(ISNUMBER(SEARCH("FEMALE",$D$9)),U9-U10,IF(ISNUMBER(SEARCH("MALE",$D$9)),U9+U10,"--"))
 |  | 215
9 |  | 214.4
 |  | 213.8
 |  | 211.8
 |  | 212.4
 |  | 212.4
 |  | 214
 |  | 214
10 |  | 214.4 | 16.75 | 41 | 43.5
 |  | 213.6
 |  | 214
 |  | 212
 |  | 212.6
 |  | 213.2
 |  | 213.8
11 |  | 212.6
 |  | 210.8
 |  | 211.8
 |  | 210.4
 |  | 210.2
 |  | 211.8
 |  | 211
12 |  | 210 | 16.5 | 41 | 42.5
 |  | 210.6
 |  | 210.8
 |  | 209.2
 |  | 208
 |  | 207.6
 |  | 208.4
13 |  | 208
 |  | 207.2
 |  | 207
 |  | 207
 |  | 207.8
 |  | 208.6
 |  | 207.8
14 |  | 207
 |  | 206
 |  | 206.4
 |  | 206.6
 |  | 206.6
 |  | 207.8
 |  | 208
15 |  | 209 | 16.5 | 40 | 41.5
 |  | 206.8
 |  | 207.6
 |  | 205
 |  | 205.8
 |  | 206.2
 |  | 206.4
16 |  | 206 | 16.5 | 39.5 | 42.25
 |  | 204
 |  | 203.8
 |  | 202.8
 |  | 205.4
 |  | 206.8
 |  | 206
17 |  | 205.6 | 16.75 | 40 | 41.5
 |  | 206
 |  | 204.6
 |  | 205.2
 |  | 205.2
 |  | 204.2
 |  | 204.4
18 |  | 204.4
 |  | 204
 |  | 204
 |  | 203.2
 |  | 203
 |  | 202.4
 |  | 202
19 |  | 202.4 | 16.5 | 39.5 | 41.5
 |  | 202
 |  | 200.8
 |  | 199.8
 |  | 199.4
 |  | 200
 |  | 200.4
20 |  | 202
 |  | 202
 |  | 202
 |  | 202
 |  | 203
 |  | 203
 |  | 203.6
21 |  | 202 | 16.5 | 39.5 | 41.5
 |  | 200.6
 |  | 199.2
 |  | 200
 |  | 201.6
 |  | 200.4
 |  | 198.4
22 |  | 199.6
 |  | 200.2
 |  | 198
 |  | 197.6
 |  | 197.4
 |  | 196.2
 |  | 196.6
23 |  | 195
 |  | 198
 |  | 199
 |  | 200
 |  | 199
 |  | 198.2
 |  | 198.4
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52