Topic

Ultra Light Backpacking Excel Sheet

  • This topic is empty.
Viewing 14 posts - 1 through 14 (of 14 total)
PostedApr 8, 2009 at 9:30 pm

I have created an ultra light packing tool in excel. It gives you a way to create your own master list for food, clothing, and equipment with weights and weight ratios. It will also let you know if you are meeting your calorie, protein, carb needs, and pack weight requirements. It will generate custom packing reports for each person and a daily menu sheet as well.
This started small, but soon became a very large project. But it is a very useful tool for planning your trips.
Email me if you want a copy. davepongw@yahoo.com

Joe Geib BPL Member
PostedApr 9, 2009 at 6:43 am

This sounds like SPAM. This is his first post on the forums.

FULL DISCLOSURE: I did request the spreadsheet myself.

Joe Clement BPL Member
PostedApr 9, 2009 at 6:53 am

I got it off a different forum yesterday. Looks like a nice spreadsheet, I just need to play with it more to figure it all out.

PostedApr 9, 2009 at 7:24 am

It doesn't work on Office 2008 for the Mac – oh well.

Joe, regarding the spam possibility, he sent it along with an interesting "if you find it useful, feel free to donate" comment, but otherwise I don't think it is intended as spam.

Sam Haraldson BPL Member
PostedApr 9, 2009 at 8:08 am

David asked me if BPL would like to distribute this spreadsheet and I suggested to him the best means of getting it into people's hands was via the forums.

PostedApr 9, 2009 at 11:08 am

I have seen a tremendous response on this spreadsheet.
I think I may post a link to the 2003 and 2007 file formats because some people can't open a 2007 file. However, Microsoft has a free download/plug-in, that will let you view 2007 files.
Please give me your feedback on the file and I will start working on some improvements for this one.
Also, let me know if it needs any clarifying.
I hope you find it useful, my brother in law searched relentlessly for this kind of a tool and so I spent the time programming it.

Steven Evans BPL Member
PostedApr 10, 2009 at 7:51 am

I remember a while ago BPL had a contest for backpacking spreadsheets. I downloaded a few but never really got into them. I probably should have. I e-mailed him for a copy but just wondering what peoples initial thoughts are. Too complicated (that's what I found with alot of the ones on BPL)? Not enough info? Just curious…

PostedApr 10, 2009 at 8:53 am

I just found a bug. When you have less than five people on the list, it generates an error on the blank people's packing list.
I will fix this, but for now, just put in a dummy name and it will run fine. More updates to come……

PostedApr 10, 2009 at 6:09 pm

Here are some links to the spreadsheets that you can download as I don't have the time to send out emails all day. I am happy that there is a great response.
Microsoft 2007 File
https://sites.google.com/site/lightbackpacking/ultra-light-packing-tool/UltraLightPacking.xlsm?attredirects=0

Microsoft 97-2003 File:
https://sites.google.com/site/lightbackpacking/ultra-light-packing-tool/UltraLightPacking.xls?attredirects=0

There are a few small fixes that I have made if I sent you an email of an old copy.

Let me know of any questions or feedback you may have.

Thanks,

Dave

Viewing 14 posts - 1 through 14 (of 14 total)
Loading...