Backpacking Weight Calculator

Nick

-
.
Joined
Aug 9, 2007
Messages
12,949
I thought I'd share this old tool of mine. I haven't used it much lately although I did just go through and add some of my newer equipment to see how it adds up.

Here's how it works.

I've added most of the items I would carry in my backpack to this spreadsheet as well as their weights. If I own 4 sleeping bags, I put all of them on the list. When it's time to pack for a trip, I just go down the list and change quantities. If I want to bring my freestanding tent rather than my stake-out tent, I just change the quantity to zero for one and 1 for the other. Or perhaps we're trying to figure the best way to split weight between two packs. Add the tent to Pack 2, add the stove to pack 1. The list even calculates how much water weight you will carry depending on how many liters of water you pack.

It's far from perfect and if you don't know Microsoft Excel, it might not be super user friendly. But it's generally pretty easy to customize for yourself. Just replace the description and weights with those for each item that you own. Only edit the green cels, the descriptions and weights will automatically change on the second packs list when you edit them in the first.

To delete an item, delete the entire row. To insert an item (if you can't just overwrite an existing one), insert a row and copy all of the cels from another line so that the formulas copy over.

If you have a lot of time on your hands, I always thought it would be fun to really add EVERYTHING that might be brought, including food items.

Image of the spreadsheet is below, download the Excel document at the bottom of this post.

And now you can all say this out loud. "Nick is craaaaazy" :)

weightcalculator.jpg
 

Attachments

  • BackpackWeightCalc.xlsx
    28.4 KB · Views: 324
and I thought I was anal.... :twothumbs:
 
Seriously, I LOVE time-wasters like this (but the wife hates them). I just went through and organized all 17k+ pictures I have. She wasn't very happy, but in the process I deleted over 2k photos that had no business taking space on my external HD.

I've been wanting to come up with a list of my gear like this. Looks like I'll be busy. Thanks!
 
Seriously, I LOVE time-wasters like this (but the wife hates them). I just went through and organized all 17k+ pictures I have. She wasn't very happy, but in the process I deleted over 2k photos that had no business taking space on my external HD.

I've been wanting to come up with a list of my gear like this. Looks like I'll be busy. Thanks!

OK, so how do I stop the "I am here" link from popping up??
 
You mean the one that used to be your signature? Looks like it's gone now. :)

Yes, I deleted it myself, but I'm curious how it's happening. Is it in the settings on my cell phone??
 
Similar threads
Thread starter Title Forum Replies Date
mikejones3 New Backpacking / Hiking Weight Calculator App Gear 0
B 3P Backpacking Tent Recommendation and Nemo Aurora feedback Gear 3
TrailScot Capitol Reef NP - 5 Day Backpacking Adventure from Chimney Rock to Burro Wash - October 2023 Backpacking 10
Mikjik86 Backpacking Indian Peaks Wilderness - King Lake - August, 2023 Backpacking 0
J Backpacking in the UK Backpacking 1
2eez4life Suggestions: Uintas Backpacking with some rock climbing routes Trip Planning 0
M Backpacking 50 miles in the Uinta Mountains for 5 days with ~50 pound pack Backpacking 4
forest dweller What do you think are the most essential nutrients while backpacking? General Discussion 17
B 2P Backpacking Tent Recommendation Gear 13
forest dweller Favorite backpacking foods...convenient, easy, delicious, nutritious? General Discussion 20
forest dweller You guys keep a backpacking gear checklist in Microsoft Word you don't mind sharing? General Discussion 13
forest dweller I have tons of backpacking food past it's expired by date... General Discussion 10
maisweh Backpacking Maze - Please Critique Trip Planning 11
DrNed Backpacking Light Memberships Resource Discussions 6
ANelson Backpacking with a 600MM Lens General Discussion 13
E Weeklong+ backpacking recs in Yellowstone NP? Trip Planning 11
R Backpacking in the Pacific Northwest Trip Planning 7
NorthwestWanderer Backpacking Grand Teton National Park : Fossil Pass,Fox Creek Pass,Indian Lake,Alaska Basin,Hurricane Pass,Ice Floe Lake,& Snowdrift Lake Backpacking 19
Mikjik86 Backpacking The Wind River Range - Wyoming, September 2022 Trip Reports 3
norwegianxplorer 6 days Backpacking Norway in the Fall (Part 2) Backpacking 4
V four day backpacking trip in southern Utah starting this weekend Trip Planning 4
norwegianxplorer 6 days backpacking Jotunheimen in the fall Trip Reports 4
Desertratgal Backpacking/Packrafting Needles and Maze Districts of Canyonlands Trip Planning 3
BJett Amazing Appalachians - Backpacking/Packrafting the AT and Nantahala River Backpacking 5
kwc Backpacking on the Northville Placid Trail (NPT) Backpacking 13
norwegianxplorer 7 days backpacking Breheimen/Glacier Home National Park in Norway Backpacking 2
SeanIsADesertRat Old guys backpacking in Dark Canyon Backpacking 17
norwegianxplorer Backpacking the Lofoten archipelago in arctic Norway Backpacking 6
Mikjik86 4 Days Backpacking Grand Teton Wilderness/Teton Crest Trail - Wyoming, July, 2021 Backpacking 0
T Southern Utah Backpacking ideas for MLK Weekend? Trip Planning 21
norwegianxplorer Backpacking SAREK NATIONAL PARK, Arctic Sweden, Camping Above RAPADALEN delta. Backpacking 7
TrailScot Canyonlands NP Needles backpacking permit in winter General Discussion 5
ghsmith76 Looking for best multi-day Backpacking Trips near Livingston, MT Trip Planning 6
norwegianxplorer Finding Hidden Glacier, 9 days backpacking Jotunheimen National Park Pt3, Norway. Trip Reports 0
norwegianxplorer Highest Mountain in Norway, Galdhøpiggen, the start of a 9 day backpacking trip in Jotunheimen national park Backpacking 0
montanaclimber Americans: where was your favorite international backpacking trip? Trip Planning 25
norwegianxplorer 5 days Backpacking Rondane National Park, Norway Backpacking 3
norwegianxplorer Backpacking Norway, Femundsmarka National Park Pt 3, Grand Scandinavian Hiking & Backpacking Tour Ep4 Backpacking 0
norwegianxplorer Backpacking Rogen Nature Reserve, Sweden & Femundsmarka National Park, Norway Pt2 Backpacking 2
norwegianxplorer 10 days Backpacking Femundsmarka National Park and Rogen Nature Reserve, Norway and Sweden Backpacking 8
norwegianxplorer Backpacking Scandinavia, Norway & Sweden June-September Backpacking 4
andyjaggy A couple of Backpacking Trip Report Videos Backpacking 0
NorthwestWanderer Backpacking Idaho's Cecil D. Andrus-White Clouds Wilderness : O'Calkens Lake & Bighorn Basin Backpacking 2
forest dweller How did you meet most of your backpacking companions? General Discussion 83
LarryBoy World's Wimpiest Backpacking Trip Trip Planning 19
Jamesoutside life Looking for backpacking buddy montana aug/sept Noobs: Introduce yourself! 0
RyanP Snowy Range (WY) easy backpacking recommendations? Trip Planning 4
norwegianxplorer How a Reindeer herd w/calves invaded my camp & started fighting over turf, backpacking Femundsmarka NP Norway Backpacking 2
D Backpacking Advice in the Winds, Teton Wilderness and the Washakie Wilderness Trip Planning 8
JuddOutdoors What is a good backpacking single person tent? 4 Season Gear 14

Similar threads

Back
Top