Phil's Pack Weight Estimator


Below is a copy of the EXCEL spreadsheet I use to estimate my packweight prior to a trip. You can download the EXCEL spreadsheet by clicking here. On the EXCEL spreadsheet, just change the information in the cells and it should automatically calculate the total weight. (If you add lines, you may need to drag the formula down the total weight column again and redo the total.)

Location in Pack Item Weight Select? (0=no,1=yes) Total Weight
Top/Bottom Timberlite 3 Tent (vestibule & GC) 8 0 0
  Zephyr solo tent (with groundcloth) 3.9 1 3.9
  Sleeping Pad 2.3 1 2.3
  Ext. Frame Pack 5.5 1 5.5
  David's Pack 4 0 0
  Down Bag 2.5 1 2.5
  Synthetic Bag 4 0 0
         
Middle inside Apex stove 1 1 1
  Apex fuel 1.5 1 1.5
  GAZ Bluet 1 0 0
  Zip Stove 1 0 0
  Pot 0.5 1 0.5
  Lid 0.25 1 0.25
  Grippers/utensils 0.15 1 0.15
  Candle lantern 0.6 1 0.6
  Cellular phone 0.75 0 0
  GPS 0.6 0 0
  Insulated mug 0.2 1 0.2
         
Back pocket First aid kit 1 1 1
  Ropes 0.25 1 0.25
  Mag lite 0.25 1 0.25
  Leatherman 0.3 1 0.3
  bandana 0.1 1 0.1
         
Bottom inside Backpack cover 0.5 0 0
  Rainsuit 0.1 1 0.1
  hiking socks 0.25 1 0.25
  polypro socks 0.2 1 0.2
  underwear 0.2 2 0.4
  t-shirt 0.3 1 0.3
  cap 0.2 1 0.2
  fleece gloves 0.25 1 0.25
  light jacket/fleece 1 1 1
  sweatshirt 1 1 1
         
Top left pocket quart bottle 2.1 2 4.2
         
         
Lower left pocket camera 0.5 1 0.5
         
Top right pocket work gloves 0.25 1 0.25
  trowel 0.2 1 0.2
  toiletries/bags 0.4 1 0.4
         
Bottom Right Water filter 0.7 1 0.7
         
  Food 3 1 3
         
Total Weight       33.25



Last Updated on 3/15/2000
By Phil
Email: prrosenkrant@csupomona.edu