Subscribe Contribute Advertise Facebook Twitter Instagram Forums Newsletter

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries

Reader submissions of spreadsheet files used for trip planning and gear lists.

Print Jump to Reader Comments

by BPL Staff | 2005-12-15 03:00:00-07

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries


How do you use a spreadsheet program to plan for a trip?

What follows are the reader entries for the contest to crown THE BEST GEAR LIST SPREADSHEET.

Rules are simple:

Using a spreadsheet compatible with either OpenOffice or Microsoft Excel, create a spreadsheet "template" or "application" that can be adapted for any season, any trip, that anyone can use to help plan their gear and supplies.

All submissions will be juried by their peers in the forums (forum thread below). Winners will be selected by the staff.

1st Prize: $100 Gift Certificate to

2nd Prize: $50 GC

3rd Prize: $25 GC

Official Entries

Click the thumbnail screen shots to see larger versions.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 1
Screen shot of Thomas R. Conroy & Alice P. Neuhauser’s entry.

Alice P. Neuhauser
Download spreadhseet
Attached you'll find our version of a Gear Spreadsheet. Please note that this is a modified version of work done previously by Carol Corbridge and others (our sincere thanks goes out to them for their generosity in sharing their spreadsheets...). Also note that this is in no way an ultralight list -- it is a simply a template. As "newbies," we have a loooong way to go to reach our load-reducing goals, but we realize it is both a journey and a process; we'll make progress each & every trip. Hope that this template is of help to others, as Ms. Corbridge's was to us.

Happy trails

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 2
Screen shot of Garen Szablewski’s entry.

Garen Szablewski
Download spreadhseet
Attached is my submittal for " THE BEST GEAR LIST SPREADSHEET " contest.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 3
Screen shot of Channing Sze’s entry.

Channing Sze
Download spreadhseet
The attached spreadsheet is quite rough, but I don't have time to pretty it up. I'm not intending to win, just thought I'd share some ideas that others may not have thought of.
  • The checklist is the sole input area.
  • The checklist is complete, and, if prudent, broken down by discretionary/optional components (for example, tent fly, tent pegs)
  • The checklist is broken down between what's in the pack, what's worn, what's shared, etc.
  • The checklist has a section to record reoccurring packing arrangements (for example, canoe trips, winter trips, etc.).
  • A packing list is automatically generated from the gear selected. the packing list is ordered by packing order/section.
  • The weight is broken down by categories. there's a table and chart comparing these weights to other "norms" (lightweight, ultralight, etc.). (this helps locate areas for possible weight reduction.)
  • A temperature analysis is also automatically generated from the gear selected. i've determined for myself what are the insulative values of my clothing and sleeping bags. (this helps me bring enough clothes!)
  • My previous spreadsheet had a section to record the amount of use a particular piece of gear got on a particular trip. i've since gotten rid of this, but i think it may be useful (and enlightening) for some people to track this information.
kind regards

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 4
Screen shot of Kim Clements’s entry.

Kim Clements
Download spreadhseet
(no text)

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 4
Screen shot of Marc Valley’s entry.

Marc Valley
Download spreadhseet
Attached is my submission.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 5
Screen shot of David King’s entry.

David King
Download spreadhseet #1, Download spreadhseet #2, Zip file containing David's spreadsheets
Here's the equipment list I've developed for my own use. I can dump everything I own (or want) into the list and the subtotal it for specific trips and uses. I've included one with all my stuff in it and one with most things removed so that it can serve as a template. Weights where shown are real. It utilizes several features hardwired into Excel:

AutoFilter - menu is Data/Filter/Autofilter - These are the little drop down arrows in row 7, the title column. This allows the user to restrain a multi-colum list based the contents of one column. It's a cheap and cheerful way of making the worksheet behave as a database.

You can customize the filter (select Custom) but a limitation of the autofilter function is that you can only use two values at a time.

Subtotal - The subtotal formula is used in Column 5, Rows C and D to calculate weight. Subtotal works in conjunction with the Autofilter feature. It calculates only those rows that are visible. These two cells calculate the total weight of the rows below in pounds and ounces.

Select "Bpl" from the drop down list in cell B7 of "BackpackList01", for instance, and it calculates my winter weight list.

Validation - Validation (Data/Validation/Allow:List is applied to all the cells in colum B. This constrains the contents of the cells in that column to the items in the list B1 - B4. It prevents the user from incorrect entries in collumn C (leading space, space at end, etc.) It supplies a drop down list of correct choices whenever you're in a cell in the column. You can, of course, have a much longer list of allowable entries.

Outlining - I use outlining to simplify navigation and to make small corrections to weight calculations. Some headings have total calculations in column F. After I weigh the individual items that go into a stuff sack, for instance I weight the total and, if there's a difference between the total weight and the weight calculated in column F for that heading I enter a correction in Row D for that stuff sack.

Got that? Outlining is not essential for this worksheet because I don't subtotal on outlines.

Freeze Panes - menu Window/FreezePanes - keeps the upper part of the worksheet visible at all times.

Other notes - Some items are in the list twice on purpose. I might, for instance wear a pair of socks and take an extra pair so one is part of personal clothing and other is basic pack weight.

Column E, like column B, is used to label items. But unlike column B it is not constrained to certain values. You can use any label you want. I use it to compare the weight of alternative kits - like raingear that uses a poncho compared to using a rain jacket, for instance.

Users will have to know how to insert and delete rows in excel and use outlining. Don't insert rows at the top or at the end of the list because they might end up outside the calculalation range of the subtotal function.

Pretty geeky, but I use it every trip to generate a checklist. I mull over the gear I'm going to take and then use the autofilter function and print it up. I'm 56. If I don't use it I forget stuff. I also print and fill out the worksheet entitled Meals for meal planning for the same reason.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 6
Screen shot of David Lewis’s entry.

David Lewis
Download spreadhseet #1, Download spreadhseet #2, Download spreadhseet #3, Zip file containing all David's spreadsheets
Here are my entries for the spreadsheet contest. There are 3 excel files included...

Sheet 1
This one uses some Excel-specific features. There is a drop down menu which allows you to select one of four options for viewing your totals, Metric, Imperial (decimals), Imperial (pounds and ounces) and Imperial (Ounces). There is also a "list managed" sheet which allows things like filtering, sorting and hiding unchecked items. This file will mostly likely work ONLY in Excel.

Sheet 2
This is a gram-based version (i.e. enter weights in grams) that doesn't use anything Excel-specific... so hopefully it will work in other applications... although I have not tested it in anything other than Excel. This one shows all the same info as the "fancy" sheet... but it shows it all at once. Item totals are in ounces only.

Sheet 3
Same as above, but ounce-based.

I'm attaching both the loose files and a ZIP archive of the files in case the loose files don't come through properly. There is more I would have liked to do, but any further improvements would have involved using macros which would have a) taken a lot of time for me to learn and b) might make users uncomfortable... i.e. afraid of malicious code.

May the best list win :)


2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 7
Screen shot of Dave Johnston’s entry.

Dave Johnston
Download spreadhseet #1, Download spreadhseet #2, Zip file containing all David's spreadsheets
Attached is a copy of the gear list spreadsheet I have developed for my own use and as an entry in the contest. Two files are attached: one is blank (except for some sample data in the Pack tab) and ready to be downloaded and used by someone else. The other one is already populated with my own gear data and most recent selections. This should serve as a sample of how anyone can fill in the blanks with their own gear and weight data, make selections, create a printed report, etc.

When the file is loaded into Excel you will proably get a warning about macros, depending on the security level you have set in Excel.

Ironically, the spreadsheet doesn't actually contain any macros, but it does contain radio buttons, which Excel apparently considers to be using code. If your security level is set at medium, you can go ahead and let it enable the "macros". Even if the security level is set to high, which disables macros, the radio buttons still seem to work. If they don't work, change the security level to medium. As far as I can tell, this is a classic Microsoft bug embedded in Excel.

Both files include a page with instructions on using the spreadsheet. They provide a method to allow weight entry in either grams or ounces, selectable by the user.

Even though this approaches the level of an "application" that you have in mind, it is still pretty easy to pick up and start getting useful results; but of course I'd appreciate any feedback on how to make it as user friendly as possible.

I'm looking forward to seeing the comments and suggestions from the forum. Please let me know if anything else is needed.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 8
Screen shot of Luke Ludwig’s entry.

Luke Ludwig
Download spreadhseet
Attached is my submission for the BPL Gear List Spreadsheet CONTEST.


2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 9
Screen shot of Al Tong’s entry.

Al Tong
Download spreadhseet
Attached is my entry for the gear list contest. This is a simple Excel spreadsheet that utilizes the Excel pivot table function to summarize and tabulate the gear data.

As sent, the spreadsheet contains 3 tabs; pack list, gear inventory and BPL data. The 3rd tab is not necessary. I only used it to populate the gear inventory tab with data from the BPL web site.

This spreadsheet is designed to inventory your gear AND create pack lists. It is trip specific and allows you to select gear from your inventory.

In the Gear Inventory tab, select your gear by insert a trip name next to the item. If you are not taking the item, leave it blank.

Once all your gear is selected, go to the Pack List tab and generate the new pack list. Right click inside the data and choose Refresh data. Check Cell B1 and make sure your Trip is selected. If not click in the drop down arrow, select your trip and click OK.

Try this out and have some fun with it. Writing instructions is not my forte, so contact me if you have any questions.


2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 10
Screen shot of Jim Wood’s entry.

Jim Wood
Download spreadsheet
Attached is an entry for your spreadsheet contest.

It's an updated version of an Excel model that I've used for several years.

To make it easier for others to try, I've cleaned it up a bit and added some instructions and usage notes on the first worksheet tab.

The model uses a simple flat file Excel database with each gear item recorded as a separate record (row) in the list. As you'll note, there's also backup data for some of the entries (those shown with blue hyperlinks).

From this database list, a variety of reports can then be generated using built-in Excel's Pivot Table functions. Aside from offering a lot of flexibility, this reporting approach also eliminates the need to manipulate live data when creating different views of the gear list.

A subset of my own gear collection is included in the model to serve as sample data. The file also includes two sample Pivot Table reports-one in English units (ounces and pounds), and one in metric units.

In addition, I've done a bit more testing with the new version of Open Office (V2.0) and have added a couple of comments on the "Instructions" page about that testing.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 11
Screen shot of Mike Moccia’s entry.

Mike Moccia
Download spreadhseet
Real basic but works well for me. I just rename in for the trip and edit away. I really like the bar chart to give me a visual of were the weight is going. The password to remove protection is, what else, backpack.

Cheers and thanks for the contest.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 12
Screen shot of Dick Matthews’s entry.

Dick Matthews
Download spreadhseet #1, Download spreadhseet #2, Zip file containings Dick's spreadsheets
Thank you the contest provided the incentive to update and add to my existing list.

I am looking forward to seeing new ideas.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 13
Screen shot of Vick Hines and Joshua Mitchell

Vick Hines and Joshua Mitchell
Download spreadhseet
We (Vick Hines and Joshua Mitchell) are submitting our "Gear Decision Matrix" spreadsheet for the spreadsheet contest.

Details / Introduction have been included in the first tab of the spreadsheet


2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 14
Screen shot of Don Ackley’s entry.

Don Ackley
Download spreadhseet #1, Download spreadhseet #2, Zip file containing all Don's Spreadsheets

Good afternoon. I hope I made it under the 12/1/05 wire for contest entries.

Attached are two Excel documents for your consideration.

(See attached file: my gear list template 120105.xls)(See attached file: my three season gear list 120105.xls)

The first, labeled "my gear list template 120105" is a blank spreadsheet ready for personal gear entry. Users simply enter each item of their own gear in the appropriate category and its weight in ounces. The spreadsheet then adds up the weight of the gear in each category, converts it to pounds, and add each category total to the successive subtotals and grand total. If a user doesn't have an entry for each type of gear, the line can be left blank or deleted.

Additional lines can also be inserted. This template may provide more built-in analysis than some users will want, but I find it useful to know my base weight for a particular outing or seasonal gear collection, the weight of my consumables (which vary with the length of the trip or the distance between resupply points), and my "skin out" weight.

The second, labeled "my three season gear list 120105" is a sample of the spreadsheet I prepared for a recent 9 day hike on the AT in North Carolina and Georgia, with one resupply point.

If you print out either document, you will see they are formatted to print as two pages side by side on a single landscape-oriented page. If the print is too small that way; you can reformat to print on two portrait oriented pages.

Hoping you find my spreadsheet interesting and that others might be able to use it.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 15
Screen shot of Ryan Faulkner’s entry.

Ryan Faulkner
Download spreadhseet
I dont know if this is what you are looking for, I have never used spreadsheet software before, but here you go.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 16
Screen shot of John Shannon’s entry.

John Shannon
Download spreadsheet template #1, Download spreadsheet template #2, Zip file containing both John's files.
Attached is my submission for the contest in template files for Excel and NeoOffice (mac version of OpenOffice) [Editor's Note: An X-Windows implementation of OpenOffice also exists for the Mac OS X if you would rather the native X application instead of the NeoOffice Java counterpart]. I have no idea how it will act in Excel, but it works great in NeoOffice.

Instructions for Mac Users using NeoOffice:

1. Type in title, context of trip, items and comments. Type over the words items and comments as they are only there to remind you what those columns are for. Then save your gearlist. 2. Type in weights in red area. For example, if only grams are known, type the amount in the red area and press enter. When the ounces conversion appears in column H, type that amount in the red area of column J. This is done so the formulas of columns H and I are not deleted. 3. In the green area type a 1 for each item being taken on that particular trip. Leave the 1 for each category or they will not be seen after the filter is run. 4. Click on the drop down menu of cell A4 and click on 1 to show only the items being taken. 5. While holding down the command key, click on the A, J, and K to select those columns. Under the format menu, choose column and hide to hide those columns from final printing.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 17
Screen shot of Meir Gottleib

Meir Gottleib
Download spreadhseet, Zip file of Meir's spreadhseet

Pack List - Gear list based on the 3-season checklist at Includes a summary for base pack weight and full skin out weight. Food weight is carried forward from the Menu. The Categories column is a droplist of available categories from the Gear Closet. The Item column is a droplist based on the Category selection. Items in the droplists can optionally be filtered to include only items specially marked in the Gear Closet. Weights are automatically populated from the weights in the Gear Closet and adjusted for Quantity.

Menu - Tool to plan menu selection for backpacking trip. Includes summary of weight and nutritional information. Like in the Pack List, the Menu items are selectable based on Categories from the Pantry. Weight and nutritional information is automatically populated from the Pantry and adjusted for Servings. The Menu weight is carried onto the Pack List as a component of consumable weight. Additionally, there is an input box on the Menu for Food Days.

Gear Closet - Provides an inventory of all available gear for selection in the Pack List. All item descriptions and weights are entered in the Gear Closet page. Weight can be entered in grams or ounces as specified in the Options page. Pound and kilograms will calculate based on the weight entered. The Category column is a droplist of available gear categories which is configurable in the Options page. The Gear Closet has been seeded with about 600 items. Much of this data is from the Gear Guide. The Visible column specifies whether or not items are visible in the Pack List dropdown menus when filters are turned on in the Options page.

Pantry - Provides an inventory of all available food for selection in the Menu. All food descriptions, weights, and nutritional information are entered in the Pantry page. All weights entered in the Pantry are in grams regardless of the units specified in the Options page since that is the standard for Nutritional Information labels. Like in the Gear Closet, the Visible column specifies whether or not items are visible in the Menu droplists when filters are turned on in the Options page.

Options - Contains various parameters for the display of information in the spreadsheet. Weight and energy units are selectable. As is the format in which pounds and kilograms are presented. Options are available to limit the food and gear choices available to those specially marked in the Pantry and Gear Closet respectively. Additionally, available food and gear categories are configured in the Options page.

2005 Backpacking Light Trip Planning Spreadsheet Contest Entries - 18
Screen shot of Ben Tomsky’s entry.

Ben Tomsky
Download spreadhseet
Hello fellow backpacker,

Attached is my planning spreadsheet. As I am in Europe for business, unfortunatly I'm not sure if this is going to make it by the deadline. I tried to calculate the time for end of day in California, but then realized that maybe that's too late for your timezone. I hope you can accept it.

Some notes to consider: Comments on cells, named cells, and named lists are used extensively. All weights are in ounces unless stated otherwise. Macro Ctrl+ D formatts cell to number with three decimal places. That is the only custom macro.

Thanks for considering my submission,


"2005 Backpacking Light Trip Planning Spreadsheet Contest Entries," by BPL Staff. (ISSN 1537-0364)., 2005-12-15 03:00:00-07.


Reader Comments

You must login to post comments.

New Visitors: Create a new account
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!


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.


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
CONVER in NeoOffice on 12/16/2005 20:58:23 MST Print View


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

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.


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.

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


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?


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'


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?


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!

Vick Hines
(vickrhines) - F

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

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

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

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

And the winner is.......drumroll...........

Jeffrey Goodwin

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

Who won?


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

Has there been a winner?


Ken T.
(kthompson) - MLife

Locale: All up in there
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?

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.

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 T.
(kthompson) - MLife

Locale: All up in there
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


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


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.

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 T.
(kthompson) - MLife

Locale: All up in there
"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


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!


James Dubendorf
(dubendorf) - M

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


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.


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


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


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 T.
(kthompson) - MLife

Locale: All up in there
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 T.
(kthompson) - MLife

Locale: All up in there
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) - F
Re: Re: 2005 Backpacking Light Trip Planning Spreadsheet Contest Entries on 09/17/2012 22:04:23 MDT Print View

Mmmmmmmmmmm. Maybe.

Ken T.
(kthompson) - MLife

Locale: All up in there
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) - F
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.


Mary D
(hikinggranny) - MLife
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.


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
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.


Ken T.
(kthompson) - MLife

Locale: All up in there
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