Gear List Spreadsheets

“Who has their gear list in spreadsheet form?
I'd like to see the different formats you guys have. Anyone have it set up with formulas that lets you check or sort gear and add the weights up for a current trip?”

“That is a sweet idea OPIE. I usually keep my lists in word.”

“Opie, go to Phils photo page and scroll down. He has an excel gear list posted there”

“I used to be that anal about it.
Now, I know what I need and just toss it into the pack and go.”

“i do.

it's nothing too special, just lists my gear and weights, then totals my baseweight, consumables and adds them up for a total.”

“what is a good but cheap scale to use to weigh everything”

“Hello SS
I agree........
Heck isn't it fun forgetting something now and then and try to improvise on replacing or getting along without it.....Or just bumming it off someone else...”

“i got one from wally world.

small, digital. i think it costed me about 20 bucks?
last edited: 11/18/04 3:05:39 PM”

“Sacco simple nd easy yet you told me that you number and weigh your stove cannisters and keep a spreasd sheet on how many more minutes of fuel they have left.”

“Gear list? WTF?

Just stuff all that #&%!$ in your pack. Hike 20 miles. When you get home jettison the #&%!$ you didn't use.

Repack. Go again hike 25 miles. Repeat step one.

Sooner or later you are down to the things you need.”

“My gear lists are on excel spreadsheets depending on the type and length of the trip, and the time of year.

I don't weigh every little thing though, so I don't have that data.”

“I just keep a text list and modify it a little for each trip. Add stuff or remove stuff based on the time of year, length of trip, location, etc.”

“LOL, that's a seperate spreadsheet rob.

i've got a bunch. i'm an excel-aholic
last edited: 11/18/04 3:21:35 PM”

“LOL so do I I have mine based on season and duration. I can go through and check off the things that I want to take and it calculates the weight. It even does my food down to the coffee single.”

“I have my list on a SS. The main tab lists all the gear I own. I have different tabs for different type trips. It pulls in the different gear and weights and gives totals. Now I usually just print it out before a trip and use it as a checklist. Sort of a starting point.”

“I have a spreadsheet somewhere, but can't help you with the formula. I have no clue on how to write them for excel.”

“Dang it! Dayhiker does not have a list on me! ;-)”

“I used a cheap diet scale from walmart that measures to the ounce for the heavy stuff, and use a hand held clip postage scale for the light stuff.
I just want to keep my list organized and it'd be neat to look at and play with.

Sacco/dayhiker..you have any of yours posted online or mind e-mailing them to opie1979@yahoo.com ?..I'm bored at work and wanna look at some..i'll check phils out later tonight..damn filters
last edited: 11/18/04 3:38:29 PM”

“Stovie posted a link to the Backpacking Gear Weight Calculator quite some time ago, and I have been using it since that time.

http://www.chrisibbeson.com/pages/GearWeightCalculator.html

Great program!”

“OPIE - I'll try emailing you. I've emailed you probably a dozen times over the years and never received a reply. I've assumed that my office account and yahoo don't talk. I know I have that trouble with stikmon's email. I can email him from my free account, but not my work one.

Email sent.”

“Dang backpacking nerds! Okay, I have an excel sheet, too. I e-mailed mine to you Opie. I also have a gear list on my website.”

“I don't use a spread sheet. I do have a few lists in word. I forget stuff, so its useful to have something in writing.

Also, its great to see four gear threads at the top of TT. I think for a while, I won't post on a non-backpacking thread if I see a gear, or clearly on topic thread at the top.”

“sorry opie, mine's at work and i won't be back until mon.”

“ARBN...Join if you're worth...NAH, not going there...just gonna go home an pack my sixty pounds approx and go bping this weekend...LMAO.....”

“OK, let's see if this will work. Click here to (hopefully) download my most current spreadsheet. I'm always changing stuff, so sometimes it's not really up to date, but whatever....

OK, just tried it; seems to work OK. This is for a 2-night winter trip, BTW, with no gear sharing....
last edited: 11/18/04 3:55:19 PM”

“MM..your website is one of the things prompting me to do this, and prob gonna make me get a z-rest.
I got your mail MM and dayhiker. Sacco, no prob, if you remember it, great and thanks. Ped...i like that posting rule..i'll follow it also...lets get out and hike, or at least sit home and fondle our gear”

“where ya going super troll...i'm thinking of heading out this weekend...kinda hope it rains also...but the iron bowl may keep me home...ah hell..i have a fm radio”

“Fondle my gear?..uh, back in 5 mins.”

“If I was OPIE, I sure as heck wouldn't be fondling my gear...”

“bit, bit, bit....

Miss Opie will soon be MRS OPIE.
Show some respect. ;-)”

“When did I mention Miss Opie? lol...”

“LOL, OPIE has allready classed me as a DirtyOldMan.
You are next.
last edited: 11/18/04 4:16:06 PM”

“I told Miss opie that if any tt'ers show up at the wedding she could toss her pink sportsbra or hiking thong instead of a garter *goes to hide*”

“OOh, I'm there...”

“weak pathetic humans. gotta have everything laid out in a special detailed manner. bring this, how much does that weigh...Since when do we need lists. Are we so weak that we can't carry the things that we want? silly humans you are weak and feeble and certainly not even worth our attention. You shall all be assimilated...resistence is FUTILE!”

“sorry for that last post, but I was possessed by a borg for a short time. Opie, that is a wonderful idea, I think you are one of the smartest personages in the realm and your leadership inspires the rest of us with such intensity. We should all follow your lead. Thank you for being you.”

“*POKES STIKKY IN THE EYE*”

“I have a list of gear and weights, and it's on PAPER! Yes, PAPER. Nerds.”

“Nerd and proud!”

“MINES ON PAPER IN A NOTEBOOK NOW...TO THE GRAM”

“Super troll...I'm with you...

I have found that those that worry about pack weight are simply out of shape. If you worked out regularly and werein tip top fitness, then you'd be able to carry your pack without even thinking about it. load your pack up, put it on, and hit the stair master and so some pushups...get strong and forget the weight...excercise!!!!”

“Opie...how come your not coming on the t-giving hike in the Irish...Ewker and Davinity are going and they live in the same vacinity as you...Oh wait...I know why...your too busy weighing your gear, making lists...silly human...hehehe...Hope to see you in Jerico! (putz)”

“I got violently sick friday night as i was packing my bag for a trip to savage gulf or the smokies (was to be determined when i got in the car that morning) good thing i wasn't in camp...I'm thinking about skipping T-giving at home...but i may succumb to wanting to see my mommy...lol”

“also stikmon..think of the weight shaving as a way for me to buy more and new gear.”

“wow. bowlderman, you put me and my pathetic little spreadsheet to shame.

i can't even look at mine anymore.
i'm now throwing it onto a floppy. then i'm gonna delete mine off my hard drive. then i'm gonna reformat my hard drive to remove all traces of the file.
i will then take the floppy, burn it and scatter the ashes over the adirondacks.”

“Stik,

Your theroy doesn't hold water. I check my pack weight because I want to be comfortable. I've carried 55# packs on 6 day trips before. 37# on a 9 day trip is much preferred. It doesn't have anything to do with my fitness level, I can do both. It has to do with being more comfortable. And don't think it's because opf my fitness level, I'm fitter now than when I carried heavy packs regularly.”

“i'm with sass.

you can carry 50# for 10 miles a day or 25# and do 15 miles a day.

choice is pretty simple for me.”

“I have lists not for the weight, but for the stuff...lots of times I'm packing at the last minute and don't want to have to fret about forgetting something.

Plus my trips are varied...if it's backpacking, there's kids vs no kids, one night vs many, winter vs the other seasons...if it's winter, is it a sled trip, a backpack trip or a drive up cabin trip...if it's car camping, is it with or without yaks, with or without kids...and many more variations!
LOL...
I'd drive myself crazy trying to remember it all!”

“MileMonster is a big time weight hound. For those of you that've hiked with him, stik included, you know just how out of shape that fat ass is. I wish I had 6 pack abs like him.”