Dec 13, 2005 at 11:03 pm #1217351
@ryanLocale: Northern Rockies
Companion forum thread to:
Use this thread for open discussion and evaluation of contest entries.Dec 14, 2005 at 3:54 am #1346919
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…againDec 14, 2005 at 6:17 am #1346922
Meir Gottleib and Ben Tomsky links seem wrong?Dec 14, 2005 at 8:43 am #1346928
@ccorbridgeLocale: Southern Oregon
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.Dec 14, 2005 at 9:19 am #1346932
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!
DaveDec 14, 2005 at 9:38 am #1346934
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.Dec 14, 2005 at 1:01 pm #1346949
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.Dec 14, 2005 at 1:13 pm #1346952
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.Dec 14, 2005 at 1:29 pm #1346954
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.Dec 14, 2005 at 1:43 pm #1346956
@kenknightLocale: SE Michigan
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.Dec 14, 2005 at 2:18 pm #1346958
Thanks John and Kenneth. Got it.
Nice SS, John.Dec 14, 2005 at 5:53 pm #1346970
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?Dec 14, 2005 at 10:33 pm #1346975
@kenknightLocale: SE Michigan
We’ve added zip files (.zip) versions for the larger spreadsheets and those that came in bunches.Dec 15, 2005 at 5:10 am #1346977
Thanks Ken! That’s a big help.
BobDec 15, 2005 at 5:12 pm #1347020
Thanks John and Kenneth. Got it.
Nice SS, John.Dec 15, 2005 at 8:28 pm #1347032
Is there a NeoOffice equivalent to the Excel feature–
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.Dec 15, 2005 at 9:56 pm #1347033
John, working in NeoOffice, how do I add additional rows and maintain full functionality in the cells? Such as weight conversion and adding?Dec 16, 2005 at 4:12 am #1347037
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.Dec 16, 2005 at 1:03 pm #1347047
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.Dec 16, 2005 at 7:58 pm #1347063
I don’t have NeoOffice, but this thread might help:
Looks like the CONVERT_ADD function may do the trick.Dec 16, 2005 at 10:22 pm #1347065
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).Dec 17, 2005 at 9:45 am #1347087
@davidlewisLocale: Nova Scotia, Canada
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.
DaveDec 17, 2005 at 5:25 pm #1347119
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?Dec 17, 2005 at 5:41 pm #1347121
>>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.Dec 19, 2005 at 8:28 am #1347197
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.
You must be logged in to reply to this topic.