My apologies. I didn't realize that I was able to get in because I have a google account. Here is the link to Erik the Black's webpage and the process on how to access the spreadsheet:
Create Your Own Backpacking Gear List With My Custom Google Spreadsheet
139 COMMENTS
Pin134
Share552
Tweet
Email
686SHARES
The new cloud-based version of my Gear Calculator Spreadsheet is available now! You can use this free tool to design your own custom backpacking and hiking gear list, automatically calculate weight and costs and see how different gear will affect your pack weight and budget.
The new version is designed to work with Google Sheets, so you no longer need Excel or any special software (and it’s even easier to use.) Here’s how to get your copy of my spreadsheet and start creating your own custom gear list…
Step 1: GET YOUR COPY OF THE SPREADSHEET
The new spreadsheet is designed to work with Google Sheets, a free cloud-based program. You will need a
Google Account to use the spreadsheet. Click the link below (you may have to log in to Google first), then follow the prompt to to copy the file. The spreadsheet will be copied to your Google Drive, where you you can use it to design your own custom gear list.
CLICK HERE TO COPY THE SPREADSHEET TO YOUR GOOGLE DRIVE
Step 2: FILL IN YOUR GEAR DATA
The spreadsheet comes pre-filled with the most common types of backpacking gear items, divided into seven categories. All you have to do is enter a description for each of the items you plan to use, along with it’s weight and price. The spreadsheet does the rest automatically, calculating the total weight for each item along with weight/cost subtotals for each category.
Step 3: ANALYZE YOUR GEAR LIST
As you enter data, the spreadsheet will generate a summary of the weight and cost of each category, your base weight, full pack weight and skin-out weight, and pie charts showing the relative impact of each of the seven categories. Use this data to evaluate what you are currently packing and see how changes will affect the overall weight and cost of your gear.
Step 4: CUSTOMIZE YOUR GEAR LIST
There are several ways you can customize the spreadsheet to your own specifications. To the left of each item is a drop-down menu containing a check and an X. The check activates an item. The X deactivates an item and removes it from all calculations (without requiring you to delete the data, so you can easily turn it back on later.) If you are not satisfied with the pre-filled item subcategories, you can rename them to whatever you like. At the bottom of each category are three blank rows (labeled “custom”), which you can use to add additional items.
Step 5: SAVE AND PRINT YOUR GEAR LIST
As you work, your gear list will be automatically saved to your Google Drive every time you make a modification, and you will be able to access it from all of your web-connected devices. When it’s time to go gear shopping, or create a pre-hike packing checklist, click the Print icon to make a hard copy. In portrait mode, the entire list will print on three 8.5×11 letter-size pages.
