Backpacking Light Trip Planning Spreadsheet Contest Winners

The winners of the Backpacking Light Trip Planning Spreadsheet Contest are a diverse group.

Print Jump to Reader Comments

by Backpacking Light Staff | 2006-06-06 03:00:00-06

2005 Backpacking Light Trip Planning Spreadsheet Contest Winners - 1

Introduction

The winners of the Backpacking Light Trip Planning Spreadsheet Contest have been selected. Readers responded with gusto to our call for entries and not only created spreadsheets to analyze gear lists, but also assist in other aspects of trip planning including meal preparation and gear selection. Eighteen entries were submitted for the contest covering a wide gamut of capabilities and needs. The wide assortment of features and design goals made for interesting discussions among the Backpacking Light staff. Determining the winners proved to be quite a challenge as we tried to weigh attributes of each entry.

The contest rules were simple. Create a spreadsheet "template" or "application" compatible with either OpenOffice or Microsoft Excel that could be easily adapted for any season, any trip, and any person. Given this rather open premise, determining a winner was difficult. We judged spreadsheets based on their ease of use, overall feature set, and how effectively the spreadsheet serves as a trip planning tool.

While each of the 18 entries had something worthwhile to offer in its approach to developing a gear list and helping to plan a trip, we were eventually able to narrow the field down to our final selections for first, second, and third place winners. While only three spreadsheets will receive prizes, Backpacking Light heartily congratulates everyone who submitted a spreadsheet for this contest.

2005 Trip Planning Spreadsheet Contest Prizes

First Place$100 gift certificate to BackpackingLight.com
Second Place$50 gift certificate to BackpackingLight.com
Third Place$25 gift certificate to BackpackingLight.com

Click screen shot thumbnails to enlarge.

First Place

Backpacking Light Trip Planning Spreadsheet Contest Winners - 2
A screenshot of Meir Gottleib's first-place winning spreadsheet.

Backpacking Light Trip Planning Spreadsheet Contest Winners - 3
Meir Gottleib, the creator of the first-place winning spreadsheet, standing on top of Mt. Whitney after completing a hike of the John Muir Trail last year.

Download this spreadsheet, Zip file of Meir's spreadsheet

Meir Gottleib's spreadsheet receives the first place prize. Meir has crafted a spreadsheet that provides comprehensive tools for organizing gear and creating food plans. The Backpacking Light staff was particularly impressed with both his "gear closet" and "pantry" sheets. The latter takes meal planning to heights we had never seen in such tools.

About the Winner

Meir Gottlieb lives in Baltimore, Maryland. He is a graduate of Cornell University College of Engineering and co-founder of Salar, Inc., a healthcare computer software company. Meir started lightweight backpacking in 2004 and walks year-round in the hills of Virginia, West Virginia, and Pennsylvania. He has also completed the 211 mile John Muir Trail in California's Sierra Nevada Mountains.

Second Place

Backpacking Light Trip Planning Spreadsheet Contest Winners - 4
A screenshot of Jim Wood's second-place winning spreadsheet.

Backpacking Light Trip Planning Spreadsheet Contest Winners - 5
Jim Wood in the Dolly Sods Wilderness of West Virginia in October 2003.

Download this spreadsheet

Jim Wood has designed a spreadsheet that (once you understand how to take full advantage of its reporting capabilities) lets you create detailed reports to help you plan your trip.

About the Winner

Paraphrasing Jim's own words from his website.

I am a mid-50s corporate finance executive temporarily living in Virginia but hoping to return to California soon. For as long as I can remember, I've held a deep and abiding passion for the wilderness. I began actually backpacking in 1988 and my only regret is that I didn't start sooner.

Third Place

Backpacking Light Trip Planning Spreadsheet Contest Winners - 6
A screenshot of Ben Tomsky's third-place winning spreadsheet.

2005 Backpacking Light Trip Planning Spreadsheet Contest Winners - 7
Ben Tomsky at the start of a hike in the Big Basin Redwoods State Park, California in May 2006.

Download this spreadsheet

Ben Tomsky receives the third place award. While his spreadsheet does not sport quite as sophisticated an interface as some of the other entrants, Ben has created a tool that allows you to quickly create gear lists and meal plans for trips quite effectively.

About the Winner

After growing up in flat, boring Midwest suburbia, Ben was enchanted by the wonders of the West Coast. He now calls San Mateo, California his home, and hikes and backpacks the nearby Santa Cruz, Santa Lucia, and Sierra Nevada ranges. Other hobbies/interests include: wine, espresso, cooking, music, travel, fly fishing, snowboarding, snowshoeing, and making ultralight alcohol stoves. He supports these habits by working as a User Experience Designer at a large software company.

Honorable Mention

Download spreadsheet #1, Download spreadsheet #2, Zip file containing all David's spreadsheets

David Johnston designed a spreadsheet that brings a flexible and sophisticated user interface to gear selection and trip planning. His use of individual sheets for each class of gear is a novel approach for crafting complex gear lists.

Acknowledgments

We were impressed with the response we received in our Trip Planning Spreadsheet Contest, and regret that we could only choose three winners. We consider all of the passionate lightweight backpackers who made the effort to develop a trip planning spreadsheet to be winners. The wealth of ideas and ways to accomplish design goals was inspiring. Once again, we wish to thank everyone who entered the contest.


Citation

"Backpacking Light Trip Planning Spreadsheet Contest Winners," by Backpacking Light Staff. BackpackingLight.com (ISSN 1537-0364).
http://backpackinglight.com/cgi-bin/backpackinglight/2005_trip_planning_spreadsheet_contest_winners.html, 2006-06-06 03:00:00-06.

Print

Reader Comments

You must login to post comments.

New Visitors: Create a new account
Username:
Password:
Remember my login info.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries
Display Avatars
Sort By:
Ryan Jordan
(ryan) - BPL Staff - MLife

Locale: Greater Yellowstone
2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 12/14/2005 00:03:41 MST Print View

Companion forum thread to:

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries

Use this thread for open discussion and evaluation of contest entries.

Edited by ryan on 12/14/2005 00:05:27 MST.

Ryan Faulkner
(ryanf) - F

Locale: Mid atlantic, No. Cal
Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 12/14/2005 04:54:11 MST Print View

after skimming the entries, I see that many people included their gear. Were we suposed to do this? I thought it was ment to help people to plan their lists?

everyone did a nice job, good luck.

P.S. this was my first experience with this software so I dont really expect to win :-) so good luck to all...again

John S.
(jshann) - F
? on 12/14/2005 07:17:57 MST Print View

Meir Gottleib and Ben Tomsky links seem wrong?

Edited by jshann on 12/14/2005 07:54:19 MST.

Carol Corbridge
(ccorbridge) - F

Locale: Southern Oregon
Spreadsheets on 12/14/2005 09:43:01 MST Print View

Wow! Lots of work went into these. On first review I really like David Lewis's sheet. It's simple elegance appeals to me. And I am appreciate the nod from Alice P. Neuhauser. I'm glad my sheet was of use.

One thing I like to see in a gear spreadsheet is the ability to do (2) people side by side. The one I currently use can do this. I often backpack with a partner and so we share cooking and safety items.

Anyway, impressive work by all. I'm sure 100's of hours were put into this task.

David Johnston
(dsjtecserv) - MLife
Spreadsheets on 12/14/2005 10:19:04 MST Print View

Ryan F:

I had the same question as I was preparing my spreadsheet. So I cheated and submitted both a blank one and an example one with my gear filled in.

Yes, there does seem to be a problem with the links to the last two entries. Some great ideas to borrow from, and some very skilled execution went into these. Kudos to everybody!

Dave

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
have you fed your Spreadsheet today? on 12/14/2005 10:38:34 MST Print View

I also like the David Lewis submission for it's simplicity
and easy metric to imperial conversion. Works well in NeoOffice which is rapidly becoming my favorite alternative to MicroSquash.

The Jim Woods submission isn't opening properly from the link but do have it from another source.

John Shannon's isn't downloading at all--I get a screen full of code.

update--Alles schön, at this point all links work.

Edited by kdesign on 12/14/2005 16:05:35 MST.

John S.
(jshann) - F
Kevin on 12/14/2005 14:01:53 MST Print View

Kevin, are you using a mac? If so, try dragging the file onto the icon instead of double clicking the file. See if that works.

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
re.Kevin on 12/14/2005 14:13:40 MST Print View

John--it won't download at all. Same as the 2 entries below you. I can't bring it to the desktop. Nothing to drag.

Yes--on a Mac running Tiger.

John S.
(jshann) - F
I see on 12/14/2005 14:29:01 MST Print View

I see what you mean. It does the same thing on mine if I click the file name. Try right clicking and saving or press the option key before clicking to force a download to the hard drive.

Edited by jshann on 12/14/2005 14:31:03 MST.

Kenneth Knight
(kenknight) - MLife

Locale: SE Michigan
Download troubles on 12/14/2005 14:43:01 MST Print View

If you just get code on a page (e.g., John Shannon's files) try right-clicking (control-clicking) on the link and downloading directly to a file. The "problem" some of you are having is that your browsers don't recognize the file extension and so get confused.

The broken links for Meir Gottleib and Ben Tomsky should work now.

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
spreedsheet downloading blues on 12/14/2005 15:18:04 MST Print View

Thanks John and Kenneth. Got it.
Nice SS, John.

Mark Cooper
(Coop) - F
No Entry for Coop? on 12/14/2005 18:53:48 MST Print View

Thanks for the hard work guys. There are some great ideas in these spreadsheets.

I don't see my entry listed here. Did I miss the cutoff or is it for members only?

Kenneth Knight
(kenknight) - MLife

Locale: SE Michigan
New links on 12/14/2005 23:33:04 MST Print View

We've added zip files (.zip) versions for the larger spreadsheets and those that came in bunches.

Bob Gabbart
(bobg) - F
Re: New links on 12/15/2005 06:10:02 MST Print View

Thanks Ken! That's a big help.

Bob

John S.
(jshann) - F
Re: spreedsheet downloading blues on 12/15/2005 18:12:55 MST Print View

Thanks Kevin.

---------
Kevin said,

Thanks John and Kenneth. Got it.
Nice SS, John.

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
NeoOffice and Analysis ToolPak on 12/15/2005 21:28:53 MST Print View

Is there a NeoOffice equivalent to the Excel feature--
"Analysis ToolPak"?

The Gottlieb spreadsheet has some very desirable features but I really want a spreadsheet that works in the NeoOffice environment. I have not been able to take advantage of the best parts of Meir's entry.

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
John Shannon's Spreadsheet on 12/15/2005 22:56:41 MST Print View

John, working in NeoOffice, how do I add additional rows and maintain full functionality in the cells? Such as weight conversion and adding?

John S.
(jshann) - F
Re: John Shannon's Spreadsheet on 12/16/2005 05:12:03 MST Print View

Adding a row:

1. Insert row- Place cursor (highlites the cell) in area you want to add a row. The row will be added above where you place the cursor. Then go to insert menu and select row.
2. Copy correct format- Since the added row won't have the appropriate formatting, choose a nearby row (preferably blank), select that row from columns B through K, and copy using either the edit menu or command-C on the keyboard.
3. Paste correct format- Paste the copied cells into the newly added row by selecting the new row from columns B through K and using either the edit menu or command-V on the keyboard.

That should automatically update the the unit conversion and total formulas. Make sure it does though.

Edited by jshann on 12/16/2005 08:04:47 MST.

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
Input on John Shannon's entry on 12/16/2005 14:03:10 MST Print View

John--I really like how straight forward your spreadsheet is. But with useful metric/imperial abilities and displays of the various weight summaries
we UL'ers are most concerned about.

One improvement I would like to see is the ability to see quick subtotals for each individual category (cooking, xtra clothing,etc.). How hard would that be to implement?
Also, the weight summary would be better expressed in exact lbs.-oz./ kg-g. units. I prefer measures more exact than rounded to nearest tenth of the larger unit of measurement.

Edited by kdesign on 12/16/2005 14:57:45 MST.

Meir Gottlieb
(mcg11)
CONVER in NeoOffice on 12/16/2005 20:58:23 MST Print View

Kevin,

I don't have NeoOffice, but this thread might help:

http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=2141

Looks like the CONVERT_ADD function may do the trick.

Edited by mcg11 on 12/16/2005 20:58:54 MST.

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
re.CONVER in NeoOffice on 12/16/2005 23:22:18 MST Print View

Meir, thanks. I'll give it a try but I think the Excel add-in acts more like a filter and CONVERT_ADD more like
a specific operation. Well, there's always using Excel (sigh).

David Lewis
(davidlewis) - MLife

Locale: Nova Scotia, Canada
Re: Spreadsheets on 12/17/2005 10:45:42 MST Print View

Thanks for the comments guys :) I haven't had a chance to look at any of the other entries... but I must say... I'm blown away by the number of entries?!?! Wow! I thought there'd only be a handful of entires. Looking forward to checking them all out.

Just a couple of things...

1. I did include my gear... just as sample content. Nice to have some actual weights to play with to see how the sheet works. I figured it's easy enough to overwrite my gear... delete rows... add rows... etc.

2. I did NOT test my sheet in NeoOffice. It's only guaranteed to work in Excel. As I recall... there were one or two errors in NeoOffice. I was originally trying to install Open Office and unless you're some kind of UNIX geek it seems pretty daunting... so I gave up :) By the time I heard about and downloaded NeoOffice... the deadline was a day away... so I didn't have time to test it. If I win any of the three prizes... I'd be happy to try and fix and NeoOffice bugs.

3. Carol... the shared idea is neat. But someone still had to carry it right? So it has to be added to either your pack or your partners? I guess the solution would be to double up my columns (so like two lists side by side) and add a "Shared" total? The shared total would still count to your pack weight... but you would know what's shared and what's not. You could use an "S" much like I use a "P" for pack and a "W" for wear/consume.

BTW... I like the "database" like approach as well... but it was just a little too much work for me I think... plus I wanted a sheet that was super simple to modify. That was one of my main goals. It works fine for someone like me who's fairly new to backpacking and doesn't have a room full of gear :) I don't really need an "inventory" system.

Dave

Edited by davidlewis on 12/17/2005 10:56:59 MST.

John S.
(jshann) - F
Re: Input on John Shannon's entry on 12/17/2005 18:25:31 MST Print View

Kevin, I added in the subtotals for ounces/grams in an updated spreadsheet that is a bit better than my contest submission. Is that what units you wanted for it? As for the lbs-oz thing, that would need a more complicated (for my abilities) formula that would take a while for me to figure out. Others might hack it out in no time. Email me at rhd101 at aol dot com for that file. Maybe we need to make another thread for comments on updated files not included in the contest?

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
Entry input on Spreadsheet Submissions on 12/17/2005 18:41:09 MST Print View

>>Maybe we need to make another thread for comments on updated files not included in the contest?

And add a user support hotline.... ;-)>
Thanks, John, will do.
K.

Edited by kdesign on 12/17/2005 18:49:26 MST.

marc valley
(marcv) - F
Grams-Ounces-Pounds on 12/19/2005 09:28:16 MST Print View

David Johnston, Your spreadsheet looks great. One this I noticed is that you use a complex formula to convert from grams to ounces, etc. Check out mine I used the CONVERT function, so much easier. I think your will be the winner. Great job.

Marc Valley

David Johnston
(dsjtecserv) - MLife
I converted from CONVERT! on 12/19/2005 20:56:48 MST Print View

Marc:

Thanks for your nice comments. I appreciate your feedback. Ironically, I used the CONVERT function in my previous version, and then decided to take it out for the version I submitted to the contest. I was tired of having to make sure that the right Toolpack was loaded, and explaining how to load it to other people who were less familiar with add-ins. And you are right, the formula in those cells is complex, but the conversion is only part of it. Most of the overhead in those cells has to do with deciding whether grams or ounces is in effect for the entry weight. And I don't think (but I could be wrong) that CONVERT has a means of displaying either decimal pounds or lb/oz. So, even though it took more programming initially, I'm now pleased that I took out CONVERT -- it opened up some other possiblities.

(PS. If you want to see some complex cells, look at the Print page. I'm not very good with pivot tables, so I used the brute force method of compiling the report for printing. Not very elegant, but it works!)

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
My picks of the cream (spreadsheets) on 12/20/2005 13:08:41 MST Print View

The love child of Dave Johnston and Meir Gottlieb's spreadsheets would share the best aspects of both----Mier's Gear Closet (love the built-in gear library), Pantry, and Menu(Nutritional info!) organization (and some clever data entry aspects)-----Dave's aesthetic presentation, separate sheets for each intelligently chosen category, and separate summary and print sheets.
I only wish they would work easily in NeoOffice.

For "just the facts, mamn" gearlist purposes, it's hard to beat John Shannon's. Simple, easy to use, and it works great in NeoOffice (for we Mac using, allergic to Microsoft types) .

Edited by kdesign on 12/20/2005 15:07:43 MST.

David Johnston
(dsjtecserv) - MLife
Love Child? on 12/20/2005 17:33:55 MST Print View

Love child! I'd like to see that!

I agree; Meir's Gear Closet, coupled with the drop down combo boxes to choose gear for each row is a great idea. Wish I'd thought of that. I have a separate spreadsheet, still under development, where I enter data on all the foods I use and use that to build a trip menu, complete with daily weights, calories, averages etc. Someday when I finish that it would be a great idea to incorporate that into the gearlist. It looks like Meir already has that nailed.

Ken! Why does a duplicate of my latest message get posted every time I visit this page?

Dave

David Johnston
(dsjtecserv) - MLife
Bug fix on 12/28/2005 15:38:08 MST Print View

A bug on the Print page of my spreadsheets has been pointed out and I have now fixed it. The bug made the 10th item of any group appear in Bold Italic, which should be reserved for group subheads. I tracked that down and fixed it. There is still a limit 20 items under each group subhead that can show up in the printed report.

If anyone would like a copy of the corrected version of the spreadsheet, I'd be happy to email it. Send me a message at dsjohnston 'at' cox.net.

Dave

Glen Van Peski
(gvanpeski) - F - M

Locale: San Diego
Wow on 01/09/2006 08:03:51 MST Print View

I knew I wasn't using the full capabilities of Excel, but yikes! Looking at the entries, I'm a babe in the Excel woods! I'm glad I didn't bother to submit anything. I'm a big fan of pull-down items, so I like that in Meir Gottlieb's entry... and what great food data! I've never gotten more sophisticated with food than how much weight of it to bring, but if I ever get more interested, this is a great springboard! I love Dave Johnston's spreadsheet, and so far that would be the one I would most likely adopt and tweak. I forget which one, but the one with the graphs was intruiging, especially the analysis of where gear was packed based on when you needed to access it...
Nicely done, everyone who submitted! There isn't a single entry that doesn't have something in it I like better than my own gear list.

Jeff Brown
(jbrown15) - F
Can I use these spreadsheets on 01/11/2006 20:47:30 MST Print View

Hi. I am really impressed with some of the spreadsheets in the contest. I was wondering if people are actually using the downloaded files. I especially like Kim Clements' work and would like to use it for my own gear planning, however, I think I should try to ask for her permission or get an okay from BPL first? Does anyone have a suggestions?

Thanks.

Mark Larson
(mlarson) - MLife

Locale: Southeast USA
Re: Can I use these spreadsheets on 01/12/2006 17:43:04 MST Print View

I'm really glad for the spreadsheets, too. Lots of great ideas there. Jeff, if they're useful, of course you should use them. The corresponding rule is that if you come up with good modifications, let us know!
-Mark

Vick Hines
(vickrhines) - F

Locale: Central Texas
Re: Can I use these spreadsheets on 01/12/2006 17:52:10 MST Print View

Jeff,
Everyone who entered the spreadsheet contest did so with the understanding that their work would be shared in the public domain. They are posted in downloadable formats to make them easier to access. Feel free.

Jeff Brown
(jbrown15) - F
Re: Can I use these spreadsheets on 01/13/2006 15:26:24 MST Print View

Thanks Mark and Vick for your help. It's nice knowing that the BPL police won't be knocking on my door. These spreadsheets are great tools and I appreciate the opportunity to use them. Thanks again. Regards, Jeff

Vick Hines
(vickrhines) - F

Locale: Central Texas
Re: Re: Can I use these spreadsheets on 01/13/2006 16:50:55 MST Print View

Jeff,
If I may plug my own favorite, take a look at the one Josh Mitchell and I posted. It isn't a spreadsheet, but a tool for making decisions about which gear will meet your needs, based on your own experience. It's pretty slick.

Richard Matthews
(food) - F

Locale: Colorado Rockies
When will the winners be announced? on 01/16/2006 16:06:15 MST Print View

I remember 1/15/06, but the memory isn't what it used to be.

Jeff Brown
(jbrown15) - F
Re: Re: Can I use these spreadsheets on 02/06/2006 15:02:00 MST Print View

Hi Vick, Thanks for the heads up on your spreadsheet. I'm going to check out. Jeff


(Anonymous)
That BPL Spreadsheet Contest on 02/20/2006 18:22:30 MST Print View

And the winner is.......drumroll...........
.......Who?

Jeffrey Goodwin
(Hedonist)

Locale: Northern California
Contest on 04/18/2006 00:25:50 MDT Print View

Who won?

Daniel Goldenberg
(dag4643)

Locale: Pacific Northwet
Trip planning spreadsheet. on 04/25/2006 20:21:01 MDT Print View

Has there been a winner?

Thanks
Dan

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Contest winner on 05/07/2006 16:04:34 MDT Print View

Come on, the suspense is killing me. I just had to restudy the entries because it has been soooo long. Any chance an announcement will be made by Memorial Day?


(Anonymous)
Re: Contest winner on 05/08/2006 00:37:23 MDT Print View

I wouldn't expect a response any time soon. Follow through seems to be lacking on these projects.


(Anonymous)
Contest Winner on 05/08/2006 01:16:59 MDT Print View

How do we know contest winners have not already been selected? The winners may have been notified and already received their award. The spreadsheets were only to be "juried" by the Forum, but winners selected by BPL. Nothing stated that the Forum was to be notified of who the winners were. Perhaps the winners also wanted to keep it a private matter?

Roger Caffin
(rcaffin) - BPL Staff - MLife

Locale: Wollemi & Kosciusko NPs, Europe
Re: Re: Contest winner on 05/08/2006 04:58:13 MDT Print View

Patience, grasshopper.
Sorting through all the entries has taken time, just to create a short list.
Judging is in progress now.

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Contest entries/winner on 05/08/2006 06:22:30 MDT Print View

Thanks Roger for the update.

Carol Crooker
(cmcrooker) - MLife

Locale: Desert Southwest, USA
Winners will be announced June 7 on 05/26/2006 10:31:30 MDT Print View

Hi all,
We'll be announcing the winners June 7th. I apologize about the long wait! We're getting the gift certificates ready for the winners now - at least there won't be a long delay between the announcement and getting the "booty."

Edited by cmcrooker on 06/07/2006 09:11:27 MDT.

kevin davidson
(kdesign) - F

Locale: Mythical State of Jefferson
Spreadsheet winner on 06/06/2006 23:06:12 MDT Print View

Congrats, Meir. Well deserved 1st place in a very competative field. Thank you for allowing my physical gear closet to reside so conveniently on a spreedsheet.

Benjamin Tomsky
(btomsky) - F

Locale: San Francisco Bay Area
Congrats to Meir on 06/07/2006 11:37:41 MDT Print View

I also want to say "Congrats" to Meir, who definitely deserved 1st place in my opinion.

I learned much from his entry and have since revised my personal gearlist to incorporate many of his database lookup techniques.

paul johnson
(pj) - F

Locale: LazyBoy in my Den - miss the forest
Re: Congrats to Meir on 06/07/2006 11:40:49 MDT Print View

How did y'all find out who the winner was? Did i miss something? Was it in a Forum Post that i missed?

Douglas Frick
(Otter) - MLife

Locale: Wyoming
Re: Re: Congrats to Meir on 06/07/2006 14:01:34 MDT Print View

>How did y'all find out who the winner was?

Backpacking Light Trip Planning Spreadsheet Contest Winners

paul johnson
(pj) - F

Locale: LazyBoy in my Den - miss the forest
Re: Re: Re: Congrats to Meir on 06/07/2006 16:01:14 MDT Print View

Douglas,

Thanks for the link. I just checked the BPL home page and saw a link there also.

I almost never go to the home page and just wait for an email from BPL telling me of the new articles and then use the links in the email. Haven't received an email yet, so I didn't realize that the winner was announced. I guess it makes sense that the home page would have links before the emails are sent out.

Thanks again and congrats to the winners.

Edited by pj on 06/07/2006 16:23:02 MDT.

David Johnston
(dsjtecserv) - MLife
Congrats to all on 06/07/2006 17:53:17 MDT Print View

Congratulations to Meir, Jim and Ben. Excellent entries from everyone; I'm sure we all picked up ideas from each others' sheets to play around with for our entries in next year's contest...right?

John S.
(jshann) - F
Congratulations winners! on 06/09/2006 06:28:26 MDT Print View

nm

Gene Kinney
(carl_kinney) - F

Locale: Southwest
Meir Gottleib's Gear List on 06/13/2006 22:25:38 MDT Print View

This is for talented Mr. Gottleib (preferred) or any person that understands well his spreadsheet:
Is there a way to enter food for a dog in a way that won't contribute to my FOOD weight under the consumable category in the PACK LIST? I don't mind it factored into the grand total for CONSUMABLES: food, water, fuel. I just what to keep the "two types of foods" seperate so I can see my food weight total vs the dog's.
Right now I've got the dog food listed under PANTRY and then added to the MENU.

Gene Kinney
(carl_kinney) - F

Locale: Southwest
Answering Mine Own Spreadsheet Question on 06/13/2006 22:45:52 MDT Print View

I guess I treat my dog, Boomer, like a human backpacking partner. All I needed to do was to list the dog food and Zuke's snacks under the GEAR CLOSET then listed them under CONSUMABLES in the GEAR LIST.
Hey, Mr Gottleib, muchas gracias for a great way to list my gear. Sure beats the word doc I started a year ago and then manually calcaluting pack weights.
--Carl

Johnny Gish
(jtgish) - F

Locale: Coppell, Texas
Printing Blank Spreadsheet? on 07/08/2006 09:03:17 MDT Print View

How do I print the spreadsheets so that I can write in my own gear? I like the ones that are on here but when I save them it has all their gear listed.

Tom Casperite
(tcasperite) - F
Meir Gottleib's Gear List on 09/14/2006 10:03:45 MDT Print View

I recently downloaded this spreadsheet, but everytime I change one of the selections the calculations of grams, lbs, and kilograms comes up as an error. " #NAME?" Does anyone have any information on this?

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
"2005 Backpacking Light Trip Planning Spreadsheet Contest Entries" on 07/20/2008 22:10:05 MDT Print View

Anyone out there have a new version of any of these that works with mac that you would like to share? I'm still keeping my lists on handwritten paper. Please help!

Christopher Holden
(back2basics) - F - MLife

Locale: Southeast USA
Re: "2005 Backpacking Light Trip Planning Spreadsheet Contest Entries" on 07/21/2008 02:08:47 MDT Print View

Go back and look for David Lewis' submission. I recall seeing a "MAC OS X" folder in the zip archive file along with the one I used.

Colin D.
(colbeans) - F

Locale: Northern British Columbia
Meir Gottleib's Gear List on 03/04/2009 00:57:41 MST Print View

I just downloaded this spreadsheet and when I try to switch the Ounces/Grams option to Grams
the cells in the Gear Closet don't properly convert..
The Ounces values just move into the cells that should be Grams and that throws off the entire calculation.

Can someone help me fix this please :)
I'm using Office 2007

Nick Gatel
(ngatel) - MLife

Locale: Southern California
Analysis Toolpack on 03/04/2009 03:59:27 MST Print View

Colin,

Similar issues with earlier versions of Excel. This should work.

First of all make sure you have the 'Analysis Toolpack' Add-in installed. Thes instructions work on 2000 and 2003, and probably on 2007.

Click the Tools Menu, Click Add-ins... and then Check 'Analysis Toolpack.'

If the Add-in is not installed, then Excel will ask you to insert the CD, and install it. Once installed, make sure the Analysis Toolpack is checked in the Add-in menu.

If it is still not working, go to the Options page and change the Primary weight units cell to the other choice. From here it should work and switch back and forth.

I had expected to see some program in VBA (Visual Basic for Applications), when was playing with this. But the author didn't. He has put together some very complex formulas to do some of this stuff. Very impressive advanced use of formulas!

Roger Caffin
(rcaffin) - BPL Staff - MLife

Locale: Wollemi & Kosciusko NPs, Europe
Re: Analysis Toolpack on 03/04/2009 14:01:47 MST Print View

Excel 2007, Tools menu - what tools menu?
They screwed the entire layout in 2007!

Cheers

James Dubendorf
(dubendorf)

Locale: CO, UT, MA, ME, NH, VT
Excel Tools Menu on 03/04/2009 14:04:03 MST Print View

Roger,

Turns out you click on the circular logo, top left, then select "Excel Options" at the bottom right of the window that appears. Should be pretty clear from there.

James

Colin D.
(colbeans) - F

Locale: Northern British Columbia
Thankyou :) on 03/04/2009 19:08:23 MST Print View

Thankyou for the replies guys
I found the excel options menu and added the Analysis Tookpack; however, the conversion still isn't working for me for some reason :(

Edited by colbeans on 03/04/2009 20:16:42 MST.

Nick Gatel
(ngatel) - MLife

Locale: Southern California
Change the option on 03/05/2009 01:35:11 MST Print View

Colin,

Go to the Option page in the workbook and change to the weight option from whatever it is set at. I found that after I added the toolpack, it would not work until I changed the weight option. After that, it kept working when I made subsequent changes to the weight option.

I am using Excel 2000. I buils a lot of Excel-VBA applications for my company using 2000, which is our corporate load. Many of these applications are faily sophisticated. We are migrating to Office 2007, and I have no reported compatililty issues with 2007 from our users.

Colin D.
(colbeans) - F

Locale: Northern British Columbia
hmm on 03/05/2009 15:23:49 MST Print View

So I gather previously added weights wont convert properly when the option is changed... but all new additions will?
Or was the spreadsheet designed to go back and forth between the two options converting them each time it's changed?

Nick Gatel
(ngatel) - MLife

Locale: Southern California
Back and forth on 03/05/2009 18:57:38 MST Print View

Colin,

I only looked at it for a couple minutes, just to help out. It appears the the purpose of the option is to let you calculate base, consumables, FSO, etc at the bottom of the sheet. I would imagine there is no need to re-input data.

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/09/2012 08:05:28 MDT Print View

What do people like to use these days? I'm still on paper. 7 years of technology has offered up other choices. Geargrams and what not. Me, I still like having it all on my own computer. Not so sure about posting it.

Eric Lundquist
(cobberman) - F - M

Locale: Northern Colorado
Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/17/2012 21:39:23 MDT Print View

I've made my own Excel document that has gone through more iterations than my gear closet has. Google Doc's has an online spreadsheet which has many of the same features.

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/17/2012 22:02:19 MDT Print View

I see no need or reason to have it online. Just remembered that I have Gram Weenie on Renee's computer. Man I need to upgrade this classic Emac.


You guys aren't going to talk tech all night again are you?

Matthew Black
(mtblack)
Re: Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/17/2012 22:04:23 MDT Print View

Mmmmmmmmmmm. Maybe.

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Re:Fortran on 09/17/2012 22:16:51 MDT Print View

Well you can build and maintain your own fire this time.

Matthew Black
(mtblack)
Re: Re:Fortran on 09/17/2012 22:31:51 MDT Print View

Ugh. OK, no talk about computers or anything related to them.

Bob Gross
(--B.G.--) - F

Locale: Silicon Valley
Re: Re: Re:Fortran on 09/17/2012 22:41:40 MDT Print View

Geez, the last time that I ran a Fortran program it was on an IBM System 360 mainframe.

There is probably a new model by now.

--B.G.--

Mary D
(hikinggranny) - MLife

Locale: Gateway to Columbia River Gorge
Fortran? on 09/17/2012 22:51:32 MDT Print View

I learned Fortran back in the 1980's; had to punch my own cards! Who in the world uses that now?

Nick Gatel
(ngatel) - MLife

Locale: Southern California
Re: Fortran? on 09/17/2012 23:34:36 MDT Print View

"I learned Fortran back in the 1980's; had to punch my own cards! Who in the world uses that now?"

People used punch cards in the 80's? Geez the PC was available in 81. We were using mini-main frames in the 80s and could write code on terminals.

I learned my first computer language in the late 60's (ALGOL) and used punch cards on a Borroughs B5500. I re-wrote some of the programs in BASIC and ran them faster on an Apple ii in the late 70's :)

I thought everyone uses Excel (except Apple geeks). Maybe I'm mistaken. Spreadsheets have been the mainstay of PCs since the late 70's. Some I have used include VisiCalc, MS MultiPlan, AppleWorks, Lotus 123, Excel, and the new horrid Apple Numbers.

Bob Gross
(--B.G.--) - F

Locale: Silicon Valley
Re: Re: Fortran? on 09/17/2012 23:44:21 MDT Print View

"People used punch cards in the 80's?"

1968 maybe.

--B.G.--

Tad Englund
(bestbuilder) - F - MLife

Locale: Pacific Northwest
Re: Re: Re: Fortran? on 09/18/2012 00:43:09 MDT Print View

Hey, my first computer science class in '75 had me punching cards for a IBM 360. I was a terrible typist so I couldn't get the stupid thing to ever run right.

How come nobody has mentioned cobalt (should be Cobol) yet? Or the early 80's CPM ( I wish that would have been IMB's pick instead of DOS- we'd all be way further ahead of things then we are now)

Edited by bestbuilder on 09/18/2012 09:46:02 MDT.

Rex Sanders
(Rex) - M

Locale: Central California Coast
Re: Re: Re: Fortran? on 09/18/2012 00:48:49 MDT Print View

I was still shoveling a few punch cards around for mainframes in the early 1980s. Some stuff takes a long time to die.

Including Fortran. We still have some Fortran code from the 1970s in production at work. I wrote some of it. Luckily, it's someone else's job to deal with that problem!

Mary D
(hikinggranny) - MLife

Locale: Gateway to Columbia River Gorge
Fortran? on 09/18/2012 00:50:37 MDT Print View

Sorry, senior moment, that was the late 1970's when I was working on my accounting degree (kind of hard to make a living for a single mother with a degree in French and English literature and several kids to support). The firm I worked for in the 1980's was still using punch cards for their time cards and a couple of subordinate systems when I left in 1988, though. Not exactly cutting edge! I did get in on the cutting edge when our firm started using PC's in early 1981, though! We started with the Apple II and soon switched to the IBM PC. It took a long time, though, before most firms finally decided that desktop computers are not really capital equipment and should be upgraded if not replaced yearly. The firm I retired from (a different one) went to leasing, which turned out to be cheaper than buying and gave us new machines yearly.

I have Microsoft Office for Mac and make up my own Excel spreadsheets. I still tweak my gear list occasionally. Unfortunately, I can't afford to replace my own computer as often as I should, so mine is currently 6 years old--still holding up, though, although I can't use the latest operating systems on it. At least my O/S is now old enough that makers of computer viruses don't bother with it!

Edited by hikinggranny on 09/18/2012 00:56:25 MDT.

Bob Gross
(--B.G.--) - F

Locale: Silicon Valley
Re: Re: Re: Re: Fortran? on 09/18/2012 00:56:39 MDT Print View

"How come nobody has mentioned cobalt yet?"

At the last time that I checked, Cobalt is Element #27 on the Periodic Table. Cobol is a programming language.

--B.G.--

Ken Thompson
(kthompson) - MLife

Locale: Behind the Redwood Curtain
Re: Fortran? on 09/18/2012 06:10:58 MDT Print View

Don't even need a fire. You all are doing it already...

Tad Englund
(bestbuilder) - F - MLife

Locale: Pacific Northwest
Re: Re: Re: Re: Re: Fortran? on 09/18/2012 09:44:57 MDT Print View

Bob, you are so right- at midnight I was trying to dig too far back in the memory bank, or maybe I had a boat on my mind.

Cobol- computer programming lanuage

Cobalt- a very expensive boat, and an Element, Atomic Number: 27;
Atomic Weight: 58.933195; Melting Point: 1768 K (1495°C or 2723°F)
Boiling Point: 3200 K (2927°C or 5301°F); Density: 8.86 grams per cubic centimeter
Phase at Room Temperature: Solid; Element Classification: Metal; Period Number: 4 Group Number: 9 Group Name: none

Scott Chandler
(blueklister) - M

Locale: Northern California
Super Geeky Backpacking Database on 06/25/2013 22:46:41 MDT Print View

Can I throw a late entry into the contest. Actually, it doesn't even qualify since it's a Filemaker 12 database, not Excel. Regardless, I think it has to be the geekiest backpacking gear checklist ever made. I built lots of Filemaker databases for my company, and I built this one out of need, and over the years I've continually refined it. When Filemaker 12 came out, it jumped it to a new level.

If you don't have Filemaker 12, you can still run this on an iPad or iPhone by downloading the Filemaker GO app. You can download the database from my website at www.apexweb.com.

Enjoy.

Scott