Docstoc

DA FORM 5500 and DA Form 5501

Document Sample
DA FORM 5500 and DA Form 5501 Powered By Docstoc
					Table 3-1
Weight for height table (screening table weight)
   Height          Minimum                                     Male                                   Height                                    Female
 (in inches)         weight                                    Age                                   (in inches)                                  Age
                   in inches*           17              21              28              40                                17              21              28
      58               91               —               —               —               —                58              119             121             122
      59               94               —               —               —               —                59              124             125             126
      60               97              132             136             139             141               60              128             129             131
      61              100              136             140             144             146               61              132             134             135
      62              104              141             144             148             150               62              136             138             140
      63              107              145             149             153             155               63              141             143             144
      64              110              150             154             158             160               64              145             147             149
      65              114              155             159             163             165               65              150             152             154
      66              117              160             163             168             170               66              155             156             158
      67              121              165             169             174             176               67              159             161             163
      68              125              170             174             179             181               68              164             166             168
      69              128              175             179             184             186               69              169             171             173
      70              132              180             185             189             192               70              174             176             178
      71              136              185             189             194             197               71              179             181             183
      72              140              190             195             200             203               72              184             186             188
      73              144              195             200             205             208               73              189             191             194
      74              148              201             206             211             214               74              194             197             199
      75              152              206             212             217             220               75              200             202             204
      76              156              212             217             223             226               76              205             207             210
      77              160              218             223             229             232               77              210             213             215
      78              164              223             229             235             238               78              216             218             221
      79              168              229             235             241             244               79              221             224             227
      80              173              234             240             247             250               80              227             230             233
Notes:
* Male and female Soldiers who fall below the minimum weights shown in table 3–1 will be referred for immediate medical evaluation.
1 The height will be measured in stocking feet (without shoes), standing on a flat surface with the chin parallel to the floor. The body should be straight but
not rigid, similar to the position of attention. The measurement will be rounded to the nearest inch with the following guidelines:
a If the height fraction is less than 1/2 inch, round down to the nearest whole number in inches.
b If the height fraction is 1/2 inch or greater, round up to the next highest whole number in inches.
2 The weight should be measured and recorded to the nearest pound within the following guidelines.
a If the weight fraction is less than 1/2 pound, round down to the nearest pound.
b If the weight fraction is 1/2 pound or greater, round up to the next highest pound.
3 All measurements will be in a standard PT uniform (gym shorts and T-shirt, without shoes).
4 If the circumstances preclude weighing soldiers during the APFT, they will be weighed within 30 days of the APFT.
5 Add 6 pounds per inch for males over 80 inches and 5 pounds for females for each inch over 80 inches.
emale
Age
         40
        124
        128
        133
        137
        142
        146
        151
        156
        161
        166
        171
        176
        181
        186
        191
        197
        202
        208
        213
        219
        225
        230
        236
                                           BODY FAT CONTENT WORKSHEET - (Male)
                                     For use of this form, see AR 600-9; the proponent agency is DCS, G-1


NAME (Last, First, Middle Initial)                      SSN                                           RANK                              Note:
DOE, JOHN                                               198-00-0000                                   SGT                             1/4" = .25
HEIGHT (to nearest 0.50 inch)                           WEIGHT (to nearest pound)                     AGE                             1/2" = .50
                                                                                                                                      3/4" = .75
72.00                                                   200                                           21
                                       STEP                                                   FIRST    SECOND             THIRD   AVERAGE            (to
                                                                                                                                    nearest 0.50 in.)

1. Measure abdomen at the level of the navel (belly button) Round down to the
nearest 0.50 inch. (Repeat 3 times.)
                                                                                             36.00         36.50          36.00         36.00

2. Measure neck just below the level of larynx (Adam's apple) Round up to the
nearest 0.50 inch. (Repeat 3 times.)
                                                                                             16.50         16.00          16.50         16.50


3. Enter the average abdominal circumference.                                                                                           36.00


4. Enter the average neck circumference.                                                                                                16.50


5. Enter circumference value (step 3 - step 4).                                                                                         19.50


6. Find the height in Table 3-1 (Height Factor). Enter height in inches.                                                                72.00

7. Find the Soldier's circumference value (step 5) and height (step 6) in figure B-5 (Percent Fat Estimation for Men) . Enter
the percent body fat value that intercepts with the circumference value and height. This is the Soldier's Percent Body Fat.             18.00

REMARKS


Soldier's Actual Weight                           200
Screening Table Weight                            195
Over/Under                                          5

Soldier's Actual Body Fat %                 18.00%
Authorized Body Fat %                       22.00%
Over/Under                                  -4.00%




CHECK ONE

  X     Individual is in compliance with Army Standards;                        is not in compliance with the standards

        Recommended monthly weight loss is 3-8 lbs.

PREPARED BY (Signature)                 RANK            DATE           APPROVED BY SUPERVISOR                       RANK          DATE
                                                        (YYYYMMDD)     (Printed Name and Signature)                               (YYYYMMDD)




DA FORM 5500, AUG 2006                                     Previous Editions are Obsolete.                                               APD v1.00
                                          BODY FAT CONTENT WORKSHEET - (Female)
                                     For use of this form, see AR 600-9; the proponent agency is DCS, G-1.


NAME (Last, First, Middle Initial)                              SSN                                            RANK                     Note:
DOE, JANE                                                       432-00-0000                                    SGT                    1/4" = .25
HEIGHT (to nearest 0.50 inch)                                   WEIGHT (to nearest pound)                      AGE                    1/2" = .50
                                                                                                                                      3/4" = .75
63.00                                                           150                                            21
                             STEP                                     FIRST                  SECOND                   THIRD          AVERAGE
                                                                                                                                   (to nearest 0.50 in.)


1. Measure neck just below level of larynx (Adam's apple) to
nearest 0.50 inch. Repeat three times, then average.
                                                                      13.00                    13.00                  13.50             13.00


2. Measure waist (abdomen) at the point of minimal
abdominal circumference. Round down to the nearest 0.50               26.00                    26.50                  26.50             26.50
inch. Repeat three times, then average.

3. Measure hips at point where the gluteus muscles
(buttocks) protrude backward the most. Round down to                  40.50                    41.00                  41.00             41.00
nearest 0.50 inch. Repeat three times, then average.

4. CALCULATIONS                                                                        REMARKS
A. Enter average waist circumference
                                                  26.50

B. Enter average hip circumference                41.00
                                                                                                     Soldier's Actual Weight                        150
C. TOTAL (4A + 4B)                                                    67.50
                                                                                                    Screening Table Weight                          143
D. Enter average neck circumference               13.00
                                                                                                                     Over/Under                            7
E. Enter circumference value
                                                                      54.50
(4C - 4D)                                                                                                 Soldier's Body Fat %               29.00%
F. Find the height in Table 3-1 (Height
                                                  63.00
Factor). Enter height in inches.                                                                         Authorized Body Fat %               32.00%

                                                                                                                     Over/Under               -3.00%
G. Find the Soldier's circumference value
(line 4E) and height (line 4F) in Figure B-6
(Percentage Fat Estimation for Women).
Enter the body fat value that intercepts
                                                                      29.00
with the circumference value and height.
This is the Soldier's Percent Body Fat.




CHECK ONE

  X     Individual is in compliance with Army Standards;                               is not in compliance with the standards

        Recommended monthly weight loss is 3-8 lbs.

PREPARED BY (Signature)                        RANK   DATE   (YYYYMMDD)   APPROVED BY SUPERVISOR                        RANK      DATE (YYYYMMDD)
                                                                          (Printed Name and Signature)




DA FORM 5501, AUG 2006                                         Previous Editions are Obsolete                                              APD v1.00
                                                                     AR 600-9 dated 01 SEPTEMBER 2006 Figure
       60   60.5    61   61.5 62   62.5 63   63.5 64   64.5 65   65.5 66   66.5 67    67.5 68
13.5   9    9
14.0   11   11      10   10   10   10   9    9
14.5   12   12      12   11   11   11   11   10   10   10   10   9    9
15.0   13   13      13   13   12   12   12   12   11   11   11   11   10   10   10   10   10
15.5   15   14      14   14   14   13   13   13   13   12   12   12   12   11   11   11   11
16.0   16   16      15   15   15   15   14   14   14   14   13   13   13   13   12   12   12
16.5   17   17      16   16   16   16   15   15   15   15   14   14   14   14   14   13   13
17.0   18   18      18   17   17   17   17   16   16   16   16   15   15   15   15   14   14
17.5   19   19      19   18   18   18   18   17   17   17   17   16   16   16   16   16   15
18.0   20   20      20   19   19   19   19   18   18   18   18   18   17   17   17   17   16
18.5   21   21      21   20   20   20   20   19   19   19   19   19   18   18   18   18   17
19.0   22   22      22   21   21   21   21   20   20   20   20   20   19   19   19   19   18
19.5   23   23      23   22   22   22   22   21   21   21   21   21   20   20   20   20   19
20.0   24   24      24   23   23   23   23   22   22   22   22   21   21   21   21   21   20
20.5   25   25      25   24   24   24   24   23   23   23   23   22   22   22   22   21   21
21.0   26   26      25   25   25   25   24   24   24   24   24   23   23   23   23   22   22
21.5   27   27      26   26   26   26   25   25   25   25   24   24   24   24   23   23   23
22.0   28   27      27   27   27   26   26   26   26   25   25   25   25   25   24   24   24
22.5   29   28      28   28   28   27   27   27   27   26   26   26   26   25   25   25   25
23.0   29   29      29   29   28   28   28   28   27   27   27   27   26   26   26   26   26
23.5   30   30      30   29   29   29   29   28   28   28   28   27   27   27   27   27   26
24.0   31   31      30   30   30   30   29   29   29   29   28   28   28   28   28   27   27
24.5   32   31      31   31   31   30   30   30   30   29   29   29   29   29   28   28   28
25.0   32   32      32   32   31   31   31   31   30   30   30   30   30   29   29   29   29
25.5   33   33      33   32   32   32   32   31   31   31   31   31   30   30   30   30   29
26.0   34   34      33   33   33   33   32   32   32   32   31   31   31   31   31   30   30
26.5   35   34      34   34   34   33   33   33   33   32   32   32   32   32   31   31   31
27.0   35   35      35   35   34   34   34   34   33   33   33   33   32   32   32   32   32
27.5   36   36      36   35   35   35   35   34   34   34   34   33   33   33   33   32   32
28.0   37   36      36   36   36   35   35   35   35   34   34   34   34   34   33   33   33
28.5                37   37   36   36   36   36   35   35   35   35   34   34   34   34   34
29.0                          37   37   37   36   36   36   36   35   35   35   35   34   34
29.5                                         37   37   36   36   36   36   36   35   35   35
30.0                                                        37   37   36   36   36   36   35
30.5                                                                  37   37   37   36   36
31.0                                                                                 37   37
31.5
32.0
32.5
33.0
33.5
34.0
34.5
35.0



Authorized Body Fat

Age    Authorized
17   20%
18   20%
19   20%
20   20%
21   22%
22   22%
23   22%
24   22%
25   22%
26   22%
27   22%
28   24%
29   24%
30   24%
31   24%
32   24%
33   24%
34   24%
35   24%
36   24%
37   24%
38   24%
39   24%
40   26%
01 SEPTEMBER 2006 Figure B-5. Percent fat estimates for males
          68.5 69  69.5 70    70.5 71     71.5 72    72.5 73    73.5 74   74.5 75   75.5 76   76.5 77   77.5



           9     9
           11    10   10   10   10   9    9    9
           12    12   11   11   11   11   10   10   10   10     10   9    9
           13    13   12   12   12   12   12   11   11   11     11   11   10   10   10   10   10   9    9
           14    14   14   13   13   13   13   13   12   12     12   12   11   11   11   11   11   10   10
           15    15   15   14   14   14   14   14   13   13     13   13   13   12   12   12   12   12   11
           16    16   16   15   15   15   15   15   14   14     14   14   14   13   13   13   13   13   12
           17    17   17   17   16   16   16   16   15   15     15   15   15   14   14   14   14   14   13
           18    18   18   18   17   17   17   17   16   16     16   16   16   15   15   15   15   15   14
           19    19   19   18   18   18   18   18   17   17     17   17   17   16   16   16   16   16   15
           20    20   20   19   19   19   19   19   18   18     18   18   18   17   17   17   17   17   16
           21    21   21   20   20   20   20   19   19   19     19   19   18   18   18   18   18   17   17
           22    22   21   21   21   21   21   20   20   20     20   20   19   19   19   19   19   18   18
           23    23   22   22   22   22   21   21   21   21     21   20   20   20   20   20   19   19   19
           24    23   23   23   23   23   22   22   22   22     22   21   21   21   21   20   20   20   20
           24    24   24   24   24   23   23   23   23   23     22   22   22   22   22   21   21   21   21
           25    25   25   25   24   24   24   24   24   23     23   23   23   23   22   22   22   22   22
           26    26   26   25   25   25   25   25   24   24     24   24   24   23   23   23   23   23   22
           27    27   26   26   26   26   26   25   25   25     25   25   24   24   24   24   24   23   23
           28    27   27   27   27   27   26   26   26   26     26   25   25   25   25   25   24   24   24
           28    28   28   28   28   27   27   27   27   26     26   26   26   26   25   25   25   25   25
           29    29   29   29   28   28   28   28   28   27     27   27   27   26   26   26   26   26   25
           30    30   29   29   29   29   29   28   28   28     28   28   27   27   27   27   27   26   26
           31    30   30   30   30   30   29   29   29   29     28   28   28   28   28   27   27   27   27
           31    31   31   31   30   30   30   30   30   29     29   29   29   29   28   28   28   28   28
           32    32   32   31   31   31   31   30   30   30     30   30   29   29   29   29   29   28   28
           33    32   32   32   32   32   31   31   31   31     31   30   30   30   30   29   29   29   29
           33    33   33   33   32   32   32   32   32   31     31   31   31   31   30   30   30   30   30
           34    34   34   33   33   33   33   32   32   32     32   32   31   31   31   31   31   30   30
           35    34   34   34   34   34   33   33   33   33     32   32   32   32   32   31   31   31   31
           35    35   35   35   34   34   34   34   34   33     33   33   33   32   32   32   32   32   31
           36    36   35   35   35   35   35   34   34   34     34   34   33   33   33   33   32   32   32
           36    36   36   36   36   35   35   35   35   35     34   34   34   34   33   33   33   33   33
                 37   37   36   36   36   36   36   35   35     35   35   34   34   34   34   34   33   33
                           37   37   37   36   36   36   36     36   35   35   35   35   34   34   34   34
                                          37   37   36   36     36   36   36   35   35   35   35   35   34
                                                         37     37   36   36   36   36   36   35   35   35
                                                                          37   37   36   36   36   36   36
                                                                                    37   37   37   36   36
                                                                                                   37   37
78   78.5 79   79.5




10   10   10   9
11   11   11   11
12   12   12   12
13   13   13   13
14   14   14   14
15   15   15   15
16   16   16   16
17   17   17   16
18   18   18   17
19   19   18   18
20   20   19   19
21   20   20   20
21   21   21   21
22   22   22   22
23   23   23   22
24   24   23   23
24   24   24   24
25   25   25   25
26   26   26   25
27   26   26   26
27   27   27   27
28   28   28   27
29   29   28   28
29   29   29   29
30   30   30   29
31   30   30   30
31   31   31   31
32   32   32   31
33   32   32   32
33   33   33   33
34   33   33   33
34   34   34   34
35   35   34   34
35   35   35   35
36   36   36   35
37   36   36   36
     37   37   36
                                                                   AR 600-9 dated 01 SEPTEMBER 2006 Figure B
       58.0   58.5 59.0 59.5 60.0 60.5 61.0 61.5 62.0 62.5 63.0 63.5 64.0 64.5 65.0 65.5 66.0
45.0   19
45.5   20     20   19
46.0   21     20   20   20   19
46.5   21     21   21   20   20   20   19   19
47.0   22     22   22   21   21   20   20   20   19   19
47.5   23     23   22   22   22   21   21   21   20   20   19   19
48.0   24     23   23   23   22   22   22   21   21   21   20   20   20   19
48.5   24     24   24   23   23   23   22   22   22   21   21   21   20   20   20   19
49.0   25     25   24   24   24   23   23   23   22   22   22   21   21   21   20   20   20
49.5   26     26   25   25   24   24   24   23   23   23   22   22   22   21   21   21   20
50.0   27     26   26   26   25   25   24   24   24   23   23   23   22   22   22   21   21
50.5   27     27   27   26   26   26   25   25   25   24   24   23   23   23   23   22   22
51.0   28     28   27   27   27   26   26   26   25   25   25   24   24   24   23   23   23
51.5   29     28   28   28   27   27   27   26   26   26   25   25   25   24   24   24   23
52.0   29     29   29   28   28   28   27   27   27   26   26   26   25   25   25   24   24
52.5   30     30   29   29   29   28   28   28   27   27   27   26   26   26   25   25   25
53.0   31     30   30   30   29   29   29   28   28   28   27   27   27   26   26   26   25
53.5   31     31   31   30   30   30   29   29   29   28   28   28   27   27   27   26   26
54.0   32     32   31   31   31   30   30   30   29   29   29   28   28   28   27   27   27
54.5   33     32   32   32   31   31   31   30   30   30   29   29   29   28   28   28   27
55.0   33     33   33   32   32   32   31   31   31   30   30   30   29   29   29   28   28
55.5   34     34   33   33   33   32   32   32   31   31   31   30   30   30   29   29   29
56.0   35     34   34   34   33   33   33   32   32   31   31   31   30   30   30   30   29
56.5   35     35   35   34   34   34   33   33   32   32   32   31   31   31   30   30   30
57.0   36     36   35   35   34   34   34   33   33   33   32   32   32   31   31   31   30
57.5   37     36   36   35   35   35   34   34   34   33   33   33   32   32   32   31   31
58.0   37     37   36   36   36   35   35   35   34   34   34   33   33   33   32   32   32
58.5   38     37   37   37   36   36   36   35   35   35   34   34   34   33   33   33   32
59.0   38     38   38   37   37   37   36   36   36   35   35   35   34   34   34   33   33
59.5   39     39   38   38   38   37   37   36   36   36   35   35   35   34   34   34   33
60.0   40     39   39   38   38   38   37   37   37   36   36   36   35   35   35   34   34
60.5   40     40   39   39   39   38   38   38   37   37   37   36   36   36   35   35   35
61.0   41     40   40   40   39   39   39   38   38   38   37   37   37   36   36   36   35
61.5   41     41   41   40   40   40   39   39   38   38   38   37   37   37   36   36   36
62.0   42     42   41   41   40   40   40   39   39   39   38   38   38   37   37   37   36
62.5   42     42   42   41   41   41   40   40   40   39   39   39   38   38   38   37   37
63.0   43     43   42   42   42   41   41   41   40   40   40   39   39   39   38   38   38
63.5   44     43   43   42   42   42   41   41   41   40   40   40   39   39   39   38   38
64.0   44     44   43   43   43   42   42   42   41   41   41   40   40   40   39   39   39
64.5   45     44   44   44   43   43   43   42   42   42   41   41   41   40   40   40   39
65.0   45     45   45   44   44   43   43   43   42   42   42   41   41   41   40   40   40
65.5   46     45   45   45   44   44   44   43   43   43   42   42   42   41   41   41   40
66.0   46     46   46   45   45   45   44   44   43   43   43   42   42   42   41   41   41
66.5   47     46   46   46   45   45   45   44   44   44   43   43   43   42   42   42   41
67.0               47   46   46   46   45   45   45   44   44   44   43   43   43   42   42
67.5                    47   46   46   46   45   45   45   44   44   44   43   43   43   42
68.0                         47   47   46   46   46   45   45   45   44   44   44   43   43
68.5                                   47   46   46   46   45   45   45   44   44   44   43
69.0                                        47   47   46   46   46   45   45   45   44   44
69.5                                                  47   46   46   46   45   45   45   44
70.0                  47   47   46   46   46   45   45
70.5                            47   46   46   46   46
71.0                                 47   47   46   46
71.5                                           47   47
72.0                                                47
72.5
73.0
73.5
74.0
74.5
75.0
75.5
76.0
76.5
77.0
77.5
78.0
78.5
79.0
79.5


Authorized Body Fat

Age    Authorized
17     30%
18     30%
19     30%
20     30%
21     32%
22     32%
23     32%
24     32%
25     32%
26     32%
27     32%
28     34%
29     34%
30     34%
31     34%
32     34%
33     34%
34     34%
35     34%
36     34%
37     34%
38     34%
39     34%
40     36%
1 SEPTEMBER 2006 Figure B-6. Percent fat estimates for females
         66.5 67.0 67.5 68.0 68.5 69.0 69.5 70.0 70.5 71.0 71.5 72.0 72.5 73.0 73.5 74.0 74.5 75.0 75.5




           19   19
           20   20   19   19
           21   21   20   20   20   19
           22   21   21   21   20   20   20   19   19
           22   22   22   21   21   21   20   20   20   19   19
           23   23   22   22   22   21   21   21   20   20   20   20   19
           24   23   23   23   22   22   22   21   21   21   21   20   20   20   19   19
           24   24   24   23   23   23   22   22   22   22   21   21   21   20   20   20   19   19
           25   25   24   24   24   23   23   23   22   22   22   22   21   21   21   20   20   20   20
           26   25   25   25   24   24   24   23   23   23   23   22   22   22   21   21   21   21   20
           26   26   26   25   25   25   24   24   24   24   23   23   23   22   22   22   21   21   21
           27   27   26   26   26   25   25   25   24   24   24   24   23   23   23   22   22   22   22
           28   27   27   27   26   26   26   25   25   25   25   24   24   24   23   23   23   22   22
           28   28   28   27   27   27   26   26   26   25   25   25   25   24   24   24   23   23   23
           29   29   28   28   28   27   27   27   26   26   26   25   25   25   25   24   24   24   23
           29   29   29   29   28   28   28   27   27   27   26   26   26   26   25   25   25   24   24
           30   30   29   29   29   29   28   28   28   27   27   27   26   26   26   26   25   25   25
           31   30   30   30   29   29   29   29   28   28   28   27   27   27   26   26   26   26   25
           31   31   31   30   30   30   29   29   29   29   28   28   28   27   27   27   27   26   26
           32   32   31   31   31   30   30   30   29   29   29   29   28   28   28   27   27   27   27
           33   32   32   32   31   31   31   30   30   30   29   29   29   29   28   28   28   27   27
           33   33   33   32   32   32   31   31   31   30   30   30   29   29   29   29   28   28   28
           34   33   33   33   32   32   32   32   31   31   31   30   30   30   30   29   29   29   28
           34   34   34   33   33   33   32   32   32   32   31   31   31   30   30   30   30   29   29
           35   35   34   34   34   33   33   33   32   32   32   32   31   31   31   30   30   30   30
           36   35   35   35   34   34   34   33   33   33   32   32   32   32   31   31   31   30   30
           36   36   35   35   35   35   34   34   34   33   33   33   32   32   32   32   31   31   31
           37   36   36   36   35   35   35   34   34   34   34   33   33   33   32   32   32   32   31
           37   37   37   36   36   36   35   35   35   34   34   34   34   33   33   33   32   32   32
           38   37   37   37   37   36   36   36   35   35   35   34   34   34   34   33   33   33   32
           38   38   38   37   37   37   36   36   36   36   35   35   35   34   34   34   34   33   33
           39   39   38   38   38   37   37   37   36   36   36   36   35   35   35   34   34   34   33
           39   39   39   38   38   38   38   37   37   37   36   36   36   35   35   35   35   34   34
           40   40   39   39   39   38   38   38   37   37   37   37   36   36   36   35   35   35   35
           41   40   40   40   39   39   39   38   38   38   37   37   37   37   36   36   36   35   35
           41   41   40   40   40   39   39   39   39   38   38   38   37   37   37   37   36   36   36
           42   41   41   41   40   40   40   39   39   39   39   38   38   38   37   37   37   36   36
           42   42   41   41   41   41   40   40   40   39   39   39   38   38   38   38   37   37   37
           43   42   42   42   41   41   41   40   40   40   40   39   39   39   38   38   38   38   37
           43   43   43   42   42   42   41   41   41   40   40   40   39   39   39   39   38   38   38
           44   43   43   43   42   42   42   41   41   41   41   40   40   40   39   39   39   39   38
           44   44   44   43   43   43   42   42   42   41   41   41   41   40   40   40   39   39   39
45   44   44   44   43   43   43   43   42   42   42   41   41   41   40   40   40   40   39
45   45   45   44   44   44   43   43   43   42   42   42   42   41   41   41   40   40   40
46   45   45   45   44   44   44   44   43   43   43   42   42   42   41   41   41   41   40
46   46   46   45   45   45   44   44   44   43   43   43   43   42   42   42   41   41   41
47   46   46   46   45   45   45   45   44   44   44   43   43   43   42   42   42   42   41
     47   47   46   46   46   45   45   45   44   44   44   44   43   43   43   42   42   42
               47   46   46   46   45   45   45   45   44   44   44   43   43   43   43   42
                    47   47   46   46   46   45   45   45   44   44   44   44   43   43   43
                              47   46   46   46   46   45   45   45   44   44   44   44   43
                                   47   47   46   46   46   45   45   45   45   44   44   44
                                             47   46   46   46   46   45   45   45   44   44
                                                  47   47   46   46   46   46   45   45   45
                                                            47   47   46   46   46   45   45
                                                                      47   46   46   46   46
                                                                           47   47   46   46
                                                                                     47   47
                                                                                          47
76.0 76.5 77.0 77.5




19   19
20   20   19   19
21   20   20   20
21   21   21   20
22   22   21   21
23   22   22   22
23   23   23   22
24   24   23   23
24   24   24   24
25   25   25   24
26   25   25   25
26   26   26   25
27   27   26   26
27   27   27   27
28   28   28   27
29   28   28   28
29   29   29   28
30   30   29   29
30   30   30   30
31   31   30   30
32   31   31   31
32   32   32   31
33   32   32   32
33   33   33   32
34   33   33   33
34   34   34   33
35   35   34   34
35   35   35   35
36   36   35   35
36   36   36   36
37   37   36   36
37   37   37   37
38   38   37   37
39   38   38   38
39   39   38   38
40   39   39   39
40   40   39   39
41   40   40   40
41   41   40   40
42   41   41   41
42   42   41   41
42   42   42   42
43   43   42   42
43   43   43   43
44   44   43   43
44   44   44   44
45   45   44   44
45   45   45   44
46   45   45   45
46   46   46   45
47   46   46   46
     47   47   46
               47
Automated Army Body Fat Worksheets
Ver 6.0 (25 May 2009)
First Released 6 Aug 01
John R. Jenkins
http://armybytes.com
webmaster@armybytes.com

Overview -
These Automated Army Body Fat Worksheets are the easiest, most complete solution to the hassle of looking up values from AR 600-9 when determining Body Fat
measurements for soldiers. Formflow is pretty, but it doesn't look up the values for you. With Formflow, you still need the manual for the tables, so I've
included the tables in this worksheet.

Requirements -
Body Fat Worksheet (this spreadsheet)
MS Excel (tested in 97, 2000 and XP)

How to Run -
Simply click on the filename on a computer running a version of Microsoft's Excel program. Most Army computers with Windows OS have MS Office, which
includes Excel. For home, you can purchase a Military Appreciation Edition of MS Office Standard for around $60 at the PX and you can get an Enterprise Edition of
MS Office through the Army's home use program for around $20 (links found on AKO).

Choose the Male (DA 5500) or Female (DA 5501) worksheets with the tabs at the bottom of the screen. You can also view the Screening Table Weight chart at
the left-most tab.

Tab through the documents. Comments and hints will popup in certain areas of the form to help you through.

Cost -
Free. If you really like the worksheet and would like to donate cash, you have a couple options. Find 'Breast Cancer Foundation, The Susan G. Komen' in
this year's CFC book and donate something to it. It would mean a lot to me. Please come to http://www.armybytes.com, sign the guestbook and let me know
what you think of the worksheet and where it's being used.

If you work for the Army Ideas of Excellence Program/BIC and like what I've done, please email me at webmaster@armybytes.com.

History -
Jan-July 2001 - I had an idea for this worksheet
July/August 2001 - Went to work on my idea. I can't remember how many hours I spent at the computer, but my wife forgot who I was for a while
V1.0 - 6 Aug 01 - Initial version
V2.0 - 14 Oct 01 - Fixed error in female allowable percentage - Thanks SFC Snowdeal
V3.0 - 19 Nov 01 - Used data validation to keep from entering incorrect measurements - Thanks COL Grimes
V3.1 - 10 Dec 01 - Added 16.00-20.75 inches to Female Neck Measurements Table per FACT SHEET by Mr. Palkoska (ATZB-PF/DSN 835-6330), dated 1 January 1994.
V3.2 - 29 Sep 02 - New version modified by SFC Rowley. Version adds automatic 'X' for whether the soldier is or is not in compliance with Army standards and
also fixed formatting for signature blocks. Thanks SFC Rowley
V3.3 - 2 Jun 03 - Corrected data validation in circumference measurements to allow .25 variation between previous and next, but not First AND Second for the
third measurement. This wouldn't have caused any incorrect body fat percentages, but would have caused measurements to be taken too many times, because it
was too strict, due to a misinterpretation of AR 600-9, Appendix B, paragraph B-2b. Clarification for this is found in AR 600-9, Appendix B, paragraph B-3a.
 Thanks to 1SG George Joell for pointing this one out!
V3.4 - 26 Jan 04 - Added table/actual weight and body fat percentage in remarks block by request from SFC Woodards. Also, fixed spelling error in line 1 of
male worksheet (naval to navel). Can't believe noone pointed that out in 2 1/2 yrs!
V4.0 - 28 Jun 04 - Linked table weight to Screening Table Weight sheet so that you no longer have to enter that data. It automatically fills. Thanks,
Colin.
v5.0 - 1 Oct 06 - Compiled updated versions from CSM Michael W. Roberts and 1SG Barry L. Sell to create this version. They did most of the hard work and
deserve most of the credit. I just added some comments, added the data validation to force measurements within 1/2" of the previous, and added this readme to the
worksheet. I've found a couple websites offerring the worksheets for download, but not providing any credit for our hard work. I've also had one person claim they had
created this version when they clearly did not, as you can see in this history. Thanks CSM Roberts and 1SG Sell.
v5.1 - 2 Oct 06 - Corrected Screening Table Weight lookup in Female Body Fat Worksheet (DA 5501). This error did not affect body fat percentages, only what it showed in
the remarks block as the soldier's Table Weight. Thanks to SSG Mcclin for finding this error.
v5.2 - 3 Oct 06 - Corrected Table Lookup error to account for circumference values larger than 66.5. In cases where this error occurred, it returned #N/A prior to this
fix. Thanks to SFC Scott Woods for catching the error.
v6.0 - 25 May 09 - Corrected measurement rounding rules IAW ALARACT 237/2008, dated 301456Z SEP 08.

These worksheets are not individually password protected. If you modify it, please send me a copy and if I like it I'll put it online as a new version. Please distribute it freely
within your office, units, or among friends, but do not put online for downloading. I want armybytes.com to be the only download site so I can keep track of the number of
downloads. Keep this readme with it when you share it. Thank You.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:168
posted:8/23/2011
language:English
pages:16