2012 BASIC COST PER FISH CALCULATOR:  (Something you didn't want to know.)
Update the fields in blue and it will automatically calculate. If you think of something else use the add item to insert it.
Cost = What it cost - Years = years you've had it.
Fields in black are locked.
(--- Al ---) (--- Augie ---) (--- Chester ---) (--- Mike ---)
Cost Years Annual Cost Years Annual Cost Years Annual Cost Years Annual
Rod $30.00 2 $15.00 $375.00 25 $15.00 $150.00 5 $30.00 $45.00 1 $45.00
Reel/Line $40.00 2 $20.00 $220.00 25 $8.80 $50.00 5 $10.00 $45.00 1 $45.00
Leader/Tiplet $21.00 1 $21.00 $500.00 25 $20.00 $100.00 5 $20.00 $0.00 1 $0.00
Waders/Boots $110.00 1 $110.00 $189.00 25 $7.56 $175.00 5 $35.00 $60.00 1 $60.00
Vest $20.00 2 $10.00 $60.00 12 $5.00 $40.00 4 $10.00 $50.00 1 $50.00
Gizmos $11.00 1 $11.00 $0.00 1 $0.00 $100.00 5 $20.00 $0.00 1 $0.00
Fly box $30.00 1 $30.00 $12.99 25 $0.52 $100.00 5 $20.00 $15.00 1 $15.00
Flies $50.00 1 $50.00 $447.89 25 $17.92 $200.00 5 $40.00 $60.00 1 $60.00
Fly floatant $5.95 2 $2.98 $6.99 2 $3.50 $0.00 1 $0.00 $2.00 1 $2.00
Wading staff $10.00 2 $5.00 $90.00 1 $90.00 $20.00 4 $5.00 $15.00 1 $15.00
Net $15.00 2 $7.50 $50.00 1 $50.00 $77.00 5 $15.40 $20.00 1 $20.00
Net magnet $15.00 2 $7.50 $15.00 2 $7.50 $15.00 5 $3.00 $15.00 1 $15.00
Stream thermometer $0.00 1 $0.00 $10.00 9 $1.11 $0.00 1 $0.00 $0.00 1 $0.00
Long underwear $0.00 1 $0.00 $80.00 11 $7.27 $0.00 1 $0.00 $0.00 1 $0.00
Drink bag $0.00 1 $0.00 $5.99 13 $0.46 $0.00 1 $0.00 $0.00 1 $0.00
Camera $50.00 1 $50.00 $0.00 1 $0.00 $0.00 1 $0.00 $0.00 1 $0.00
Orvis book $25.95 2 $12.98 $15.00 22 $0.68 $0.00 1 $0.00 $0.00 1 $0.00
Walkie talkies $0.00 1 $0.00 $0.00 1 $0.00 $0.00 1 $0.00 $50.00 1 $50.00
I-Phone apps $0.00 1 $0.00 $0.00 1 $0.00 $0.00 1 $0.00 $10.00 1 $10.00
Hat eyes $0.00 1 $0.00 $0.00 1 $0.00 $0.00 1 $0.00 $20.00 1 $20.00
Ridiculous fishing hat $0.00 1 $0.00 $0.00 1 $0.00 $0.00 1 $0.00 $0.00 1 $0.00
Fly Fishing Show $0.00 1 $0.00 $0.00 1 $0.00 $60.00 1 $60.00 $0.00 1 $0.00
Float tube $180.00 1 $180.00 $0.00 1 $0.00 $0.00 1 $0.00 $0.00 1 $0.00
Frying Pan $190.00 1 $190.00 $190.00 1 $190.00 $190.00 1 $190.00 $190.00 1 $190.00
Lunch ($13.00 X Trips) $13.00 26 $338.50 $13.00 27 $351.48 $13.00 18 $234.72 $13.00 16 $208.81
Total Cost $1,061.45 $776.80 $693.12 $805.81
Number of Fish Caught 79 80 18 17
Cost per fish $13.44 $9.71 $38.51 $47.40
Cost per pound @ 3/4 lb per fish $17.87 $12.91 $51.21 $63.04
Fun factor
Assuming a trip is average 8 hours (3.0 hr drive - 4 hr fish - 1 hr lunch)
# Trips (excluding Frying Pan) 25 26 17 15
Cost per fun trip $34.86 $22.57 $29.60 $41.05
Cost per hour of fun $4.36 $2.82 $3.70 $5.13
Adjusted and balanced
Adjusted Total cost (no tube/show) $881.45 $776.80 $633.12 $805.81
Cost per trip If we all took 27 trips $32.65 $28.77 $23.45 $29.84