![]() ![]() ![]() Enter it once and then pick from the list as required. I don’t want to have to enter my gear over and over again. I was looking for more database type functions, though. Erik The Black – I liked the fact that he added cost (not sure how that helps me backpack, but I felt it was nice to keep track of) and the graphs. It is very simple to download and very simple to ![]() wonderful tool is this premade spreadsheet created by thru-hiker Erik the Black on his blog. The Logistics of Hitting Life's Pause Button to Thru-Hike the A.T.You have to go to File>Make a copy to be able to edit this. There’s a reason google Sheets is free… But I really wish they’d add some of these features. So the google sheet just shows everything. – There isn’t a way to easily switch back and forth from the sheet that shows just the summary to the one that shows everything. – There isn’t a way to toggle off rows from data like you have (to remove certain gear from the pie charts or whatever) as far as I know on Google Sheets. – I couldn’t figure out how to freeze rows (so that the pie charts and title remain on the entire sheet) because Google wouldn’t let me keep the charts inside the frozen rows. – Your formatting looks much better because Excel has much stronger formatting. I created a Google Sheets version of this! I rewatched your tutorial to figure out exactly what I couldn’t recreate… (I just left a comment below and then missed this…) If you have any more questions feel free to ask. Your total pack weight is 15 pounds and you are skipping and whistling as you walk □ In your pack is half a day of food (1 pound), 1 liter of water (2 pounds) and 12 pounds of gear. Scenario #3: You just hiked five days and are almost to the next town. A bit hefty, but still manageable (and it will lighten up as you go). In your pack is 5 days of food (10 pounds), 6 liters of water (12 pounds) and 12 pounds of gear. Scenario #2: You find yourself just coming out of town with a fresh resupply on a hot day. Your total pack weight is 21 pounds (lightweight and comfy). In your pack is 2.5 days of food (5 pounds), 2 liters of water (4 pounds) and 12 pounds of gear. Scenario #1: You find yourself mid-way between resupply points on a nice day. Here are a couple of theoretical examples of how your pack weight will vary throughout the trip: If you are a really big eater like me you may venture into the 3 lb territory, but anything more than that is usually too heavy. 2 – 2.5 pounds of food a day is pretty standard. So we hike at a calorie deficit and then pig out in towns to make up the difference. But in practice most thru-hikers don’t hit the mark. The section where hikers usually carry the most weight is the Sierras, due to carrying extra gear (like ice axe, bear canister, some warmer clothes, etc.) The other part where you will find yourself carrying a lot of weight is a few places in SoCal where you have to do big water carries of 6-8 liters.īut, for the majority of the trail most hikers pack 4-5 days of food between resupply stops and carry 2-4 liters of water at a time.ġ00 calories an ounce is a good theoretical goal to shoot for when planning trail food. It is only necessary when the towns are more than 100 miles apart and the water sources are more than 30 miles apart (which only happens a few times). Thanks and have a blessed Kaiser: On the PCT you won’t need to carry seven days of food or eight liters of water that often. Being a programmer myself, I know how much work goes into these things. Other than that, it is working great and I really appreciate all of you efforts and allowing others to enjoy the fruits of your labors. I am now on my third version and am very careful anytime I am moving anything around. It took me several times before I discovered what I was doing to corrupt the spreadsheet. It also corrupts where the little arrow boxes are displayed. I noticed whenever I try to do a cut and paste of the contents of a cell (if I am trying to move something from one section to another), it corrupts the weight totals (changes to #REF) and if I accidentally save this I cannot get it and have to start over. It gives me an error saying “you cannot use this command on a protected sheet”.ģ. I have the Mac version and cannot get the 1 and 2 click option (top left-hand side of spread sheet to work. There appears to be an incompatibility with the Excel version for Mac and the Excel version for Windows. Is there a way to add a column for just manufacturer and then the other column would be the item description.Ģ. Love the spreadsheet and everyone I show it to really likes it as well and some have even downloaded it after I showed it to them.ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |