Forum Index » General Lightweight Backpacking Discussion » gear spreadsheet?


Display Avatars Sort By:
Dave T
(DaveT) - F
gear spreadsheet? on 06/02/2008 13:11:32 MDT Print View

hi there.

well, i'm finally joining the ranks of the gram weenies, and purchasing a digital scale. so that means it's time to input info into a gear spreadsheet. i've done a forum search and gotten some options (below, from a couple years ago), but wanted to check in here.
http://www.backpackinglight.com/cgi-bin/backpackinglight/2005_trip_planning_spreadsheet_contest_winners.html

does anyone have a clean and simple gear spreadsheet (Windows/Excel) that they can recommend? something that works well for you? it doesn't need too many bells and whistles.

thanks!

Edited by DaveT on 06/02/2008 13:15:48 MDT.

J W
(jhaura) - M

Locale: www.Trailability.com
Re: gear spreadsheet? on 06/02/2008 13:32:08 MDT Print View

Dave,

You might like this one:

http://spreadsheets.google.com/pub?key=pQcp2oIaRHRB_JeOcj4CPDg

I can give you a copy of it your interested, from which you could input your own gear. Email me if your interested. jhaura **at** gmail **dot** com

Edited by jhaura on 06/02/2008 13:32:59 MDT.

Michael Davis
(mad777) - F

Locale: South Florida
Re: gear spreadsheet? on 06/02/2008 14:33:47 MDT Print View

This one is not exactly simplistic, but if you ever want to put a little time into it, you could graduate to this one...

http://jwbasecamp.com/Articles/Spreadsheet/index.html

P.S. There is a lot of good info on Jim Wood's site!

Adam Rothermich
(aroth87) - F

Locale: Missouri Ozarks
Re: Re: gear spreadsheet? on 06/02/2008 14:35:11 MDT Print View

I just made a really simple one in OpenOffice. One sheet has all of my gear listed with the weight in grams and ounces (measured in grams then used spreadsheet to convert to ounces). The second sheet is where I copy and paste my gear selections for a trip. It has categories for shelter, sleeping, etc and it adds up weight in pack, weight worn, and total weight worn or carried (FSO). I even started work on a sheet for nutrition (calories, weight, cal/oz, etc).

If you're really interested, shoot me a PM or email (aroth87 at gmail dot com) and I'll send it to you. Its nothing too special but its functional.

Adam

Simon Wurster
(Einstein) - F

Locale: Big Apple
Re: gear spreadsheet? on 06/04/2008 11:30:31 MDT Print View

I have a spreadsheet that may be of use, although it has many bells and whistles. I use it for all types of traveling (business trips, car camping, vacations, etc.), so you may want to trim it down (a lot!) for pure backpacking use.

--You can store separate lists and recall them as needed (copy-and-paste).

--You can compare two similar lists and see the change in overall weight, and more usefully, see the difference as a percentage (Sure your new LMF Spork saves 3 oz., but the overall change is only 0.8% -- maybe it's time to take a hard look elsewhere on the list!).

--Weights are entered in lbs.-oz. format (2-4.25 or 0-36.25), and converted to dec. lbs., and g. Totals and Subtotals are displayed in lbs., oz., and g, and Grand Totals are displayed in lbs. and kg. (Sorry, there's no direct entry in kg or g.)

--Items change color when flagged: black when included (y), light blue when excluded (n), and orange when "maybe" (m).

--You can hide items globally that are excluded (n) and sort the items alphabetically (once your list is set) for compact printing and easier reading.

--The printed version uses two columns, Going and Coming, to act as checkboxes for items as they go into (or come out of when home) the pack (or suitcase).

--Subtotals are provided for each category, although the categories I've chosen don't necessary conform to a BPL standard (the spreadsheet predates my association with BPL by a few years).

--The XLS file works bidirectionally with Documents-to-Go, so you can edit the list on your PDA while hiking (just kidding) or daydreaming in airport lounges.

--You can export the finished list to BrainForest (an outliner for Palm OS) to create a nifty checklist, if that's your thing (and you have a Palm OS device with BrainForest).

--Pack weight, weight of consumables, weight worn, and total weight are always displayed at the top.

--Items within each category are graphed, but I admit this feature is mostly useless (and was replaced with the percentage comparison page).

--There's a primitive food calculator based on the no. of days, but you can edit the formulas (and of course delete or add rows) to your own requirements.

--And in a show of utter anal-retentiveness, there's a column where you can flag items as "Pack" (can go into the pack now), "Find" (run around on the morning of the trip and shove in the pack any-which-way), and "Carry-on" (for airplane trips). Note: these flags are not synched with the lists, so when you paste-in a list from the "library," you'll have to update these flags again.

PM me if interested (expect a response tonight, I'm on the East Coast). I think I have an older PDF version in my Profile if you want to take a look.

Regards,
Simon

Edited by Einstein on 06/04/2008 11:40:10 MDT.