Topic

Excel Gear Spreadsheet

  • This topic is empty.
Viewing 25 posts - 1 through 25 (of 54 total)
PostedJun 4, 2005 at 7:28 am

I built an excel spreadsheet that can track my pack weight depending on what gear I choose to pack on any given trip. It breaks down the weight of each category and gives subtotals for gear only prior to food and water.

Anyway if anyone’s interested I can e-mail as an attachment. It’s set up for (2) people and a dog. It also has an area for what is worn on your body.

PostedJun 4, 2005 at 9:27 am

Hi Carol:

Yes, I’m interested. It’s funny…I was just sitting down to re-weigh all my gear in variations for different seasons and was going to put together a gear list, so this would be great!

My email is: free.in8@verizon.net

Thanks Carol,

Jim

PostedJun 4, 2005 at 7:58 pm

Hi Carol,
If you wouldn’t mind, could you send me a copy as well. I have done the same thing with the 3 different packs I have to keep up with. I’d like to see how you designed yours to get some improvement ideas on tracking the items.
Thanks,
Janet
kira2167@ccol.net

PostedJul 19, 2005 at 8:24 am

Dear Carol,

If it’s not too late to jump on the bandwagon, would you please your spreadsheet to me?

Thank you for taking to the time to create it and for your generosity in sharing it.

trconroy@earthlink.net

PostedJul 21, 2005 at 4:57 am

I left my name back on 7/7/05 and haven’t seen the excel sheet come through…

Carol, are you still checking this thread?

If you still are, I am still interested.

Thanks a bunch!
Ben Thompson

studiofluid@@@@@gmail.com
(remove 4 @ symbols)

Einstein X BPL Member
PostedJul 21, 2005 at 1:14 pm

Uhm, let’s hope Ms/Msr Corbridge is sincere and will not start to spam all of you’re email accounts.

Eins

-is a bit sceptic about giving his email adress on the www and also doesn’t like cookies.-

No offence though, Ms/Msr Corbridge. Just want to advice people about being cautious on the web.

David Lewis BPL Member
PostedJul 22, 2005 at 3:22 pm

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.

PostedJul 22, 2005 at 4:11 pm

David,

If you are considering the Nunatak Arc Alpinist or the Gosamer Gear Sleeplight sleeping bags consider the Feathered Friends (FF) Vireo, optional Volant Hood, and FF jacket.

Rather than go through these discussions again review the discussions here on BPL in the down quilt thread at:

http://www.backpackinglight.com/cgi-bin/backpackinglight/forums/thread_display.html?mv_session_id=IHUnAGDu&mv_pc=99&forum_thread_id=576

and the multiple use sleeping bag thread at:

http://www.backpackinglight.com/cgi-bin/backpackinglight/forums/thread_display.html?mv_session_id=Gioht95L&mv_pc=91&forum_thread_id=542

Rich

David Lewis BPL Member
PostedJul 22, 2005 at 4:58 pm

Thanks for the thread pointers Richard.

Did you check out the spreadsheet? It’s nothing revolutionary or anything… but I do like the ability to turn line items on and off. I thank Google for helping me figure out that one :) I’m not an excel person by any means!

Viewing 25 posts - 1 through 25 (of 54 total)
Loading...