Hey All,
I hate to be yet another person asking for this… so I made my own and posted it on my website so anyone can download it if they want…
http://www.davidlewis.ca/GearList.zip
I don’t know how it compares to Carol’s spreadsheet… but it works well enough. I also don’t mean to step on any toes… just figured it was easier to make my own.
The main thing I wanted was to be able to turn items on and off and have the totals all update.
I used checkboxes at first to do this… but they are a huge pain since they do not occupy a cell… they float above everything. So if you want to add new rows, delete rows, move rows, sort rows… etc… the data all moves around the page… but the checkboxes stay put… making it very confusing. Plus you have to add checkboxes one at a time and associate them with a new cell… etc. They are just really cumbersome.
So… instead… I just used a column with a character in it. I used the letter x to indicate that an item is “checked” or “turned on”. To turn an item off… just delete the x or type any other characer BUT x. The formula that looks for the x and makes this work is in column F. I made the text white in that column so it wouldn’t show up when values are being populated (either 0 or the weight in grams).
Also… all of the weights are based on grams and everything in the spreadsheet (formulas, etc.) is keyed off what you enter in the grams column. I did this since my scale can measure in 1 gram increments and a gram is a smaller unit than 0.1 oz… so I figured this would be the most accurate measure… esp. for tiny items. It would be easy enough to change the formulas tho’ to key off ounces instead.
And before anyone says so… yes… I know… my sleeping bag is INSANELY heavy. That’s my one last big lightweight purchase. I’m debating between an Arc Alpinist (worried about drafts) or the GG Sleeplight.