Backpacking Weight Calculator

Nick

-
.
Joined
Aug 9, 2007
Messages
12,934
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: 321

DOSS

out
Joined
Jan 17, 2012
Messages
292
and I thought I was anal.... :twothumbs:
 

Tyler

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Joined
Jan 18, 2012
Messages
464
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!
 

Tyler

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Joined
Jan 18, 2012
Messages
464
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??
 

Tyler

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Joined
Jan 18, 2012
Messages
464
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
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 82
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
norwegianxplorer Backpacking Norway, Lysefjorden/Kjerag/Kjerag Waterfall/Kjeragbolten, 4 days Solo Hiking high above the Norwegian Fjords Trip Reports 2
norwegianxplorer Early Season Solo Backpacking during Snowmelt Runoff in Norway Backpacking 0
angeedraper Canyonlands - Needles 2 Night Backpacking (April 29-May1) Backpacking 0
TrailScot Zion backpacking permit changes General Discussion 3
fiber Off-trail backpacking partners Meet Up (Members Only) 7
norwegianxplorer WHITEOUT, Winter Backpacking Norway in a Snow Storm Trip Reports 0
forest dweller When backpacking, what do you bring a backup of, despite the ultralight backpacking community suggesting you may be crazy? Gear 49
NorthwestWanderer 4 Days Backpacking Capitol Reef : Spring Canyon & Various side canyons Backpacking 5
D Advice for short backpacking trip in Robbers Roost Trip Planning 2
M Overnight Backpacking Indian Peaks Wilderness or Similar Trip Planning 13
M Suggestions for a 10 day backpacking trip in early June Trip Planning 8
D Backpacking Ideas for an 8 year old Trip Planning 16
norwegianxplorer Backpacking Norway in the fog, trying out my new 4 season tent Trip Reports 3
norwegianxplorer Norway Backpacking in the fall, Western Norway Backpacking 5
Miya Beach Backpacking and Creek Bed Sleeping Backpacking 29
BJett Honeymoon Backpacking - An Intro to Canyon Country Backpacking 14
norwegianxplorer Summiting Mount Whitney from Guitar Lake, 6 Days backpacking the Sierra before the Creek Fire closed everything down. Backpacking 5
Eugene Backpacking the Sawtooths Backpacking 11
NorthwestWanderer Backpacking the Lost River Range in Idaho : Bear Creek Lake & Upper Basin Backpacking 7
NorthwestWanderer Backpacking Okanogan National Forest : Copper Glance Lake & failed attempt at No Dice Lake Backpacking 2
R Invite Yellowstone Backpacking Trip 7/29-8/3 Meet Up (Members Only) 2
norwegianxplorer Sequoia National Park, Backpacking Mt Silliman area, June 2020 Backpacking 8
norwegianxplorer Muddy Creek 6 day backpacking loop with My Own Frontier Backpacking 5
ridings82 Uintas Backpacking Loop Trip Reports 10
Mikjik86 FULL Video Part 2 Backpacking Glacier National Park "North Circle Route" Backpacking 0
NorthwestWanderer Backpacking Oregon's Cottonwood Canyon : Lost Corral Trail Backpacking 1
Mikjik86 Backpacking Glacier National Park (Part 2 Preview) "North Circle Route" Montana, August 2019 Backpacking 2
DouginGJCO Hiking &/or backpacking partner for Canyonlands Natl Park and nearby Noobs: Introduce yourself! 0
Ugly Gear Review New Backpacking Pack. Options Gear Reviews 16
NorthwestWanderer Backpacking Washington's Coulee Country : Barker Canyon Backpacking 5
M Non-technical 1-2 night backpacking w dogs and kids - Escalante-ish area in April? Trip Planning 14
McKee80 Yellowstone backpacking advice Trip Planning 15
yoseman backpacking Grand Teton NP Trip Planning 0
Yvonne first backpacking trip in the Beartooths, early August Trip Planning 13
JBPHXAZ Dark Canyon Backpacking Help Trip Planning 9
JBPHXAZ Suggestions for 4-5 days Backpacking in the Southwest Trip Planning 2
Bob Backpacking - Old School General Discussion 38
D Need suggestions for a backpacking trip with a base camp Trip Planning 10
Yvonne Backpacking the Winds: From Elkhart TH to Titcomb Basin, July 2018 Backpacking 20
M advice Grand Canyon backpacking Spring 2020 Trip Planning 16
Mikjik86 Backpacking Glacier National Park August 2019 Backpacking 3

Similar threads

Don't like ads? Become a BCP Supporting Member and kiss them all goodbye. Click here for more info.

Top