Forum Index » Philosophy & Technique » Problem with BPL contest spreadsheet


Display Avatars Sort By:
Jesse H.
(tacedeous) - MLife

Locale: East Bay, CA
Problem with BPL contest spreadsheet on 05/24/2009 04:53:18 MDT Print View

so i downloaded this awesome looking spreadsheet:

http://www.backpackinglight.com/cgi-bin/backpackinglight/2005_trip_planning_spreadsheet_contest_winners.html

the problem i have is modifying items in the "gear list" to "yes" doesn't change anything in the "packing list" Ive installed the necessary add-ons but nothing... what am i doing wrong?

also weights on "pack list" are list as "N/A" on their totals...??

im sure its simple... im just not understanding how to filter i think...

BTW, im using excel '07

Edited by tacedeous on 05/24/2009 05:09:06 MDT.

Mark Mendell
(mmendell) - M

Locale: Midwest
Re: Spreadsheet on 05/24/2009 07:32:47 MDT Print View

It sounds like you don't have the analysis toolpack up and running. Double check to see that you do. Make sure on the options page that you have the options selected that you want.

When you add rows to the gear list, don't forget to "drag" the formatting of the rows above down.

Lastly, make certain that you "select all" and "sort" after you've made changes to the gear lists.

It's a great spreadsheet, but can be a bit fiddly at first.

Hike Ultralight
(HikeUltralight) - M

Locale: Southeast
Options Tab on 06/02/2009 08:39:05 MDT Print View

There is an option on the options tab that you have to change to NO to make it so that whatever is set to NO in the gear closet doenst show in the drop down.