{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Planning","Food and fuel","Food and fuel-canmping","Food and fuel-backpacking","Gear","Needs","Nutrition for hiking","Meds","Health"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Planning","index":0,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Preparation"]
[null,null,null,"hiking list","(html)"]
[]
[null,null,null,"Total pack weight for backpacking and travel",null,null,null,"=",{"$f":"Gear!M183","v":555},{"$f":"ROUNDUP(I6/16,0)","v":35}]
[null,null,null,null,null,null,null,null,"oz","lb"]

{"sheet":"Food and fuel","index":1,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[[20,10,20,11],[20,13,20,14]]}
["USE"]
[null,"red items are to be entered for each trip",null,null,null,null,"This page is generic for camping and backpacking"]
[null,"food cal/oz from","https://www.myfooddiary.com/",null,null,null,null,"Food and fuel-canmping",null,null,"is for camping, obtained from here by selecting the number of days, calories, and whether to take ramen / peanut butter"]
[null,"review for improvement"]
[]
["TRIP LENGTH"]
["TYPE","Enter trip type","(hiking, camping, backpacking…)"]
[]
[null,"cal (days @)",1500,7,{"$f":"C9*D9","v":10500},"cal"]
[null,"cal (days @)",2000,0,{"$f":"C10*D10","v":0},"cal"]
[null,"cal (days @)",3000,0,{"$f":"C11*D11","v":0},"cal"]
[null,"cal (days @)",4000,0,0,"cal"]
[null,"cal (days @)",5000,0,0,"cal"]
[null,"cal (days @)",6000,0,0,"cal"]
[null,null,null,null,{"$f":"SUM(E9:E14)","v":10500},"sum"]
[null,"days",null,{"$f":"SUM(D9:D14)","v":7}]
[null,"weeks",null,{"$f":"D16/7","v":1}]
[null,"cal factor r/t 1500",null,{"$f":"E15/(1500*D16)","v":1}]
[null,{"$f":"D16","v":7},"days",{"$f":"B7","v":"Enter trip type"}]
["FOOD",null,"food","packets etc","unit","# /wk","#/trip","oz/item","#","cal/oz","oz/day","cal/day","take","cal/day","oz/day","days","pack","pack","pack","have","buy","buy"]
[null,null,null,null,null,"nominal",null,null,null,null,"for nominal 1,500 cal/day",null,"y=1, n=0","actual",null,null,"oz","lb","#","oz","oz","lb"]
[null,null,"bold = staples (main calorie foods)"]
[null,null,null,"experiment with staples amounts, new spices and seasonings, sugar v stevia"]
[null,"BREAKFAST"]
[null,null,"Granola",null,"oz",null,null,null,null,116,2,{"$f":"J25*K25","v":232},1,{"$f":"L25*M25*D18","v":232},{"$f":"K25*M25*D18","v":2},{"$f":"D16","v":7},{"$f":"O25*P25","v":14},{"$f":"Q25/16","v":0.875},null,0,{"$f":"MAX(Q25-T25,0)","v":14},{"$f":"U25/16","v":0.875}]
[null,null,"Milkman","pkt","oz",2,null,3.44,{"$f":"ROUNDUP(F26*D16/7,0)","v":2},111,{"$f":"I26*H26/D16","v":0.98285714285714287},{"$f":"J26*K26","v":109.09714285714286},1,{"$f":"L26*M26","v":109.09714285714286},{"$f":"K26*M26","v":0.98285714285714287},{"$f":"D16","v":7},{"$f":"O26*P26","v":6.88},0.43,{"$f":"I26*M26","v":2},0,{"$f":"MAX(I26-T26,0)*M26","v":2},{"$f":"U26","v":2},"pkts"]
[null,null,"Coffee",null,"oz",null,null,null,null,0,1.4,{"$f":"J27*K27","v":0},1,0,1.4,{"$f":"D16","v":7},{"$f":"O27*P27","v":9.7999999999999989},0.61249999999999993,null,0,{"$f":"MAX(Q27-T27,0)","v":9.7999999999999989},{"$f":"U27/16","v":0.61249999999999993}]
[null,null,"Coffee filters (pack for one a day)",null,"oz",7,null,4.0000000000000001E-3,{"$f":"ROUNDUP(F28*D16/7,0)","v":7},0,{"$f":"I28*H28/D16","v":4.0000000000000001E-3},{"$f":"J28*K28","v":0},1,0,4.0000000000000001E-3,{"$f":"D16","v":7},{"$f":"O28*P28","v":2.8000000000000001E-2},1.75E-3,{"$f":"I28*M28","v":7},0,{"$f":"MAX(I28-T28,0)*M28","v":7},{"$f":"U28","v":7},"filters"]
[null,null,"Teas","tea bag","oz",7,null,6.25E-2,{"$f":"ROUNDUP(F29*D16/7,0)","v":7},0,{"$f":"I29*H29/D16","v":6.25E-2},0,1,0,6.25E-2,{"$f":"D16","v":7},{"$f":"O29*P29","v":0.4375},2.734375E-2,{"$f":"I29*M29","v":7},0,{"$f":"MAX(I29-T29,0)*M29","v":7},{"$f":"U29","v":7},"pkts"]
[null,null,"Inst coffee-Starbucks","pkt","oz",7,null,0.11600000000000001,{"$f":"ROUNDUP(F30*D16/7,0)","v":7},0,{"$f":"I30*H30/D16","v":0.11600000000000001},{"$f":"J30*K30","v":0},1,0,0.11600000000000001,{"$f":"D16","v":7},{"$f":"O30*P30","v":0.81200000000000006},5.0750000000000003E-2,{"$f":"I30*M30","v":7},0,{"$f":"MAX(I30-T30,0)*M30","v":7},{"$f":"U30","v":7},"pkts"]
[null,null,"Condensed milk","can","oz",1,null,14,{"$f":"ROUNDUP(F31*D16/7,0)","v":1},100,{"$f":"I31*H31/D16","v":2},{"$f":"J31*K31","v":200},0,0,0,{"$f":"D16","v":7},{"$f":"O31*P31","v":0},0,{"$f":"I31*M31","v":0},0,{"$f":"MAX(I31-T31,0)*M31","v":0},{"$f":"U31","v":0},"cans"]
[null,null,"Sugar",null,"oz",null,null,null,null,110,0.5,{"$f":"J32*K32","v":55},1,55,0.5,{"$f":"D16","v":7},{"$f":"O32*P32","v":3.5},0.21875,{"$f":"I32*M32","v":0},0,{"$f":"MAX(Q32-T32,0)","v":3.5},{"$f":"U32/16","v":0.21875}]
[null,null,"Collagen - consider for camping"]
[null,null,"Protein - consider for camping"]
[null,"LUNCH, TRAIL"]
[null,null,"Sesame sticks",null,"oz",null,null,null,null,155,2,310,1,{"$f":"L36*M36*D18","v":310},{"$f":"K36*M36*D18","v":2},{"$f":"D16","v":7},{"$f":"O36*P36","v":14},{"$f":"Q36/16","v":0.875},null,0,{"$f":"MAX(Q36-T36,0)","v":14},{"$f":"U36/16","v":0.875}]
[null,null,"Nuts",null,"oz",null,null,null,null,160,2.25,360,1,{"$f":"L37*M37*D18","v":360},{"$f":"K37*M37*D18","v":2.25},{"$f":"D16","v":7},15.75,{"$f":"Q37/16","v":0.984375},null,0,{"$f":"MAX(Q37-T37,0)","v":15.75},{"$f":"U37/16","v":0.984375}]
[null,null,"Dried fruit",null,"oz",null,null,null,null,100,1.5,{"$f":"J38*K38","v":150},1,{"$f":"MAX(L38*M38*D18-N39,0)","v":150},{"$f":"N38/J38","v":1.5},{"$f":"D16","v":7},{"$f":"O38*P38","v":10.5},{"$f":"Q38/16","v":0.65625},null,0,{"$f":"MAX(Q38-T38,0)","v":10.5},{"$f":"U38/16","v":0.65625}]
[null,null,"Bread Oroweat whole grain- for camping",null,"slice",14,null,1.52,null,72.39,{"$f":"F39*H39/D16","v":3.04},{"$f":"J39*K39","v":220.06560000000002},0,{"$f":"L39*M39","v":0},{"$f":"K39*M39","v":0},{"$f":"D16","v":7}]
[null,null,"(16 slices per loaf)",null,null,null,null,null,null,null,null,null,"may set to 1 if camping"]
[null,null,"Peanut butter - for camping",null,null,null,null,null,null,null,null,null,{"$f":"M39","v":0}]
[null,null,"Jelly - for camping",null,null,null,null,null,null,null,null,null,{"$f":"M39","v":0}]
[]
[null,"DINNER"]
[null,null,"Rice",null,"oz",null,null,null,null,115,1,115,1,{"$f":"L45*M45*((1+0.4*(1-M48))+(D18-1))","v":161},{"$f":"K45*M45*((1+0.4*(1-M48))+(D18-1))","v":1.4},{"$f":"D16","v":7},9.7999999999999989,{"$f":"Q45/16","v":0.61249999999999993},null,0,{"$f":"MAX(Q45-T45,0)","v":9.7999999999999989},0.61249999999999993]
[null,null,"Beans",null,"oz",null,null,null,null,102,1,102,1,{"$f":"L46*M46*((1+0.4*(1-M48))+(D18-1))","v":142.79999999999998},{"$f":"K46*M46*((1+0.4*(1-M48))+(D18-1))","v":1.4},{"$f":"D16","v":7},9.7999999999999989,{"$f":"Q46/16","v":0.61249999999999993},null,0,{"$f":"MAX(Q46-T46,0)","v":9.7999999999999989},0.61249999999999993]
[null,null,"TVP - textured vegetable protein (complete protein)"]
[null,null,"Ramen","pkt","oz",2,null,2.5,{"$f":"ROUNDUP(F48*D16/7,0)","v":2},102,{"$f":"I48*2.5/D16","v":0.7142857142857143},72.857142857142861,0,{"$f":"L48*M48","v":0},{"$f":"K48*M48","v":0},{"$f":"D16","v":7},0,{"$f":"Q48/16","v":0},{"$f":"I48*M48","v":0},0,{"$f":"MAX(I48-T48,0)*M48","v":0},{"$f":"U48","v":0},"pkts"]
[null,null,"Broths","pkt","oz",5,null,0.5,{"$f":"ROUNDUP(F49*D16/7,0)","v":5},70,{"$f":"I49*H49/D16","v":0.35714285714285715},25,1,25,0.35714285714285715,{"$f":"D16","v":7},2.5,0.15625,{"$f":"I49*M49","v":5},0,{"$f":"MAX(I49-T49,0)*M49","v":5},5,"pkts"]
[null,null,"Jerky 3oz","pkt","oz",1,null,3,{"$f":"ROUNDUP(F50*D16/7,0)","v":1},116,{"$f":"I50*H50/D16","v":0.42857142857142855},49.714285714285708,1,49.714285714285708,0.42857142857142855,{"$f":"D16","v":7},3,0.1875,{"$f":"I50*M50","v":1},0,{"$f":"MAX(I50-T50,0)*M50","v":1},1,"pkts"]
[null,null,"Jerky 7oz","pkt","oz",1,null,7,{"$f":"ROUNDUP(F51*D16/7,0)","v":1},116,{"$f":"I51*H51/D16","v":1},116,0,0,0,{"$f":"D16","v":7},0,0,{"$f":"I51*M51","v":0},0,{"$f":"MAX(I51-T51,0)*M51","v":0},0,"pkts"]
[null,null,"Cheese, cheddar",null,"oz",null,null,null,null,120,1,120,0,0,0,{"$f":"D16","v":7},0,0,null,0,{"$f":"MAX(Q52-T52,0)","v":0},0]
[null,null,"Drinks, kool-aid","pkt","oz",3,null,0.13,{"$f":"ROUNDUP(F53*D16/7,0)","v":3},0,{"$f":"I53*H53/D16","v":5.5714285714285716E-2},0,1,0,5.5714285714285716E-2,{"$f":"D16","v":7},0.39,2.4375000000000001E-2,{"$f":"I53*M53","v":3},0,{"$f":"MAX(I53-T53,0)","v":3},3,"pkts"]
[null,null,"Fruit bars","bar","oz",7,null,1.2,{"$f":"ROUNDUP(F54*D16/7,0)","v":7},100,{"$f":"I54*H54/D16","v":1.2},120,0,{"$f":"L54*M54*D18","v":0},{"$f":"K54*M54","v":0},{"$f":"D16","v":7},0,0,null,0,{"$f":"MAX(Q54-T54,0)","v":0},0]
[null,null,"Energy nuggets",null,"oz",null,null,null,null,135,1.2,162,1,{"$f":"L55*M55","v":162},{"$f":"K55*M55","v":1.2},{"$f":"D16","v":7},8.4,0.52500000000000002,null,0,{"$f":"MAX(Q55-T55,0)","v":8.4},0.52500000000000002]
[null,null,"Dessert (to enter)",null,"oz",null,null,null,null,0,0,0,0,{"$f":"L56*M56","v":0},{"$f":"K56*M56","v":0},{"$f":"D17","v":1},{"$f":"O56*P56","v":0},{"$f":"Q56/16","v":0},null,0,{"$f":"MAX(Q56-T56,0)","v":0},{"$f":"U56/16","v":0}]
[null,null,"Spices and salt","collection","oz",1,null,3,{"$f":"F57*D16/7","v":1},{"$f":"0","v":0},{"$f":"I57*H57/D16","v":0.42857142857142855},0,1,{"$f":"L57*M57","v":0},{"$f":"K57*M57","v":0.42857142857142855},{"$f":"D16","v":7},{"$f":"O57*P57","v":3},0.1875,null,0,{"$f":"MAX(Q57-T57,0)","v":3},{"$f":"U57/16","v":0.1875}]
[null,null,"Sun dried tomatoes","bulk","oz",1,null,2,{"$f":"F58*D16/7","v":1},{"$f":"0","v":0},{"$f":"I58*H58/D16","v":0.2857142857142857},0,1,{"$f":"L58*M58","v":0},{"$f":"K58*M58","v":0.2857142857142857},{"$f":"D16","v":7},{"$f":"O58*P58","v":2},0.125,null,0,{"$f":"MAX(Q58-T58,0)","v":2},0.125]
[null,null,"Powdered tomatoes",null,null,null,null,null,null,null,null,null,0]
[null,null,"Food cans etc (camp)",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"review this for spices adequate for three weeks… except salt, for which extra should be taken for trips over a week"]
[null,null,null,null,"unit","# items/wk","#/trip","oz/item","# items","cal/oz","oz/day","cal/day","take","cal/day","oz/day","days","oz","lb",null,"have","need","need"]
[null,null,null,null,null,"nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oz","lb"]
[null,null,"Olive oil","container","oz",2,null,1,{"$f":"ROUNDUP(F64*D16/7,0)","v":2},240,{"$f":"I64*H64/D16","v":0.2857142857142857},68.571428571428569,1,{"$f":"L64*M64*D18","v":68.571428571428569},0.2857142857142857,{"$f":"D16","v":7},2,{"$f":"Q64/16","v":0.125},null,0,{"$f":"Q64-T64","v":2},{"$f":"U64/16","v":0.125}]
[null,null,"Vitamins and meds","container system","oz",1,null,3.15,null,0,{"$f":"H65/7","v":0.45},0,1,0,0.45,{"$f":"D16","v":7},3.15,{"$f":"Q65/16","v":0.19687499999999999},null,0,{"$f":"(Q65/4.5)-T65","v":0.7},{"$f":"U65","v":0.7},"system(s)"]
[null,null,"Emergency meds","container system","oz",1,null,2.5,null,0,{"$f":"H66/7","v":0.35714285714285715},0,1,0,0.35714285714285715,{"$f":"D16","v":7},{"$f":"H66","v":2.5},{"$f":"Q66/16","v":0.15625},null,1,{"$f":"(Q66/2.5)-T66","v":0},{"$f":"U66","v":0},"system(s)"]
[null,null,"   See","Meds!A1"]
[null,"Fresh veg","Jalapenos","oz","oz",2,null,0.5,{"$f":"ROUNDUP(F68*D16/7,0)","v":2},0,{"$f":"I68*H68/D16","v":0.14285714285714285},0,1,0,0.14285714285714285,{"$f":"D16","v":7},1,{"$f":"Q68/16","v":6.25E-2},null,0,{"$f":"Q68-T68","v":1},{"$f":"U68/16","v":6.25E-2}]
[null,null,"Garlic, pre-peeled","pkt","oz",1,null,1.5,{"$f":"ROUNDUP(F69*D16/7,0)","v":1},0,{"$f":"I69*H69/D16","v":0.21428571428571427},0,0,0,0,{"$f":"D16","v":7},0,{"$f":"Q69/16","v":0},null,0,{"$f":"Q69-T69","v":0},0]
[null,null,"Garlic, fresh peeled","head","oz",1,1,1.75,1,0,{"$f":"I70*H70/7","v":0.25},0,1,0,0.25,{"$f":"D16","v":7},1.75,{"$f":"Q70/16","v":0.109375},{"$f":"F70*D17","v":1},0,{"$f":"MAX(S70-T70,0)","v":1},{"$f":"U70","v":1},"heads"]
[null,null,"Onion","oz","oz",1,null,8,{"$f":"ROUNDUP(F71*D16/7,0)","v":1},0,{"$f":"I71*H71/D16","v":1.1428571428571428},0,1,0,1.1428571428571428,{"$f":"D16","v":7},8,{"$f":"Q71/16","v":0.5},null,0,{"$f":"(Q71-T71)/8","v":1},{"$f":"U71","v":1},"onions"]
[null,null,"Pre-sautéed vegetables"]
[null,null,"Lime","oz","oz",1,null,2,{"$f":"ROUNDUP(F73*D16/7,0)","v":1},0,{"$f":"I73*H73/D16","v":0.2857142857142857},0,1,0,0.2857142857142857,{"$f":"D16","v":7},2,{"$f":"Q73/16","v":0.125},null,0,{"$f":"(Q73-T73)/2","v":1},{"$f":"U73","v":1},"limes"]
[null,"Freeze dried veg (to be entered)"]
[null,"DRY DINNER","comment - rice and beans are ~ 107 and nuts and sesame stix are ~ 155 cal / oz; so, can substitute 2/3 of rice-beans by nuts-stix for 0 to 3 days / wk at time of purchase"]
[]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N25:N65)","v":1825.1828571428573},{"$f":"SUM(O25:O73)","v":19.285357142857137},null,{"$f":"SUM(Q25:Q73)","v":134.9975},{"$f":"Q77/16","v":8.4373437500000001}]
[]
["BEAR VAULT",null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,41,{"$f":"Q79/16","v":2.5625}]
[]
["FUEL",null,null,"item","unit","# items/wk",null,"oz/item","# items",null,null,null,"take",null,null,"days","oz","lb"]
[null,null,null,null,null,"nominal 1.4 - 2.0"]
[null,null,"MSR ISOPRO","13.1 oz cannister","oz",2,null,{"$f":"13.1","v":13.1},{"$f":"INT(F83*D17)*M83","v":2},"cannisters",null,null,1,null,null,{"$f":"D16","v":7},{"$f":"H83*I83*M83","v":26.2},{"$f":"Q83/16","v":1.6375}]
[null,null,"MSR ISOPRO","7.4 oz cannister","oz","N/A",null,{"$f":"7.4","v":7.4},{"$f":"ROUNDUP((F83*D17-INT(F83*D17))*(8/3.9),0)","v":0},"cannisters",null,null,{"$f":"M83","v":1},null,null,{"$f":"D16","v":7},{"$f":"H84*I84*M84","v":0},{"$f":"Q84/16","v":0}]
[]
[null,null,"White Gas",null,"unit",null,null,"oz/item","# items",null,null,null,"take",null,null,"days","oz","lb"]
[null,null,"(24 oz/wk)",null,null,null,null,null,null,null,null,null,0,null,{"$f":"24/7","v":3.4285714285714284},{"$f":"D16","v":7},{"$f":"O87*P87*M87","v":0},{"$f":"Q87/16","v":0}]
[null,null,null,"fuel bottle","oz",null,null,{"$f":"33","v":33},{"$f":"INT(O87*D16/33)","v":0}]
[null,null,null,"fuel bottle","oz",null,null,20,{"$f":"ROUNDUP((O87*D16/33-INT(O87*D16/33))*33/22,0)","v":2}]
[null,null,null,"fuel bottle","oz",null,null,11]
[null,null,"Total fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q83+Q84+Q87","v":26.2},{"$f":"Q91/16","v":1.6375}]
["Total food, fuel, and bear vault",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q77+Q79+Q91","v":202.19749999999999},{"$f":"Q92/16","v":12.637343749999999}]

{"sheet":"Food and fuel-canmping","index":2,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[[20,10,20,11],[20,13,20,14]]}
["USE"]
[null,"red items are to be entered for each trip",null,null,null,null,"This is for camping, obtained from generic page",null,null,null,null,"Food and fuel"]
[null,"food cal/oz from","https://www.myfooddiary.com/",null,null,null,null,"by setting 1,500 cal days = 5, 2000 cal days = 2, taking pbj and ramen; may take heavier items (cans, deserts…) and adjusting the other items"]
[null,"review for improvement",null,null,null,null,null,"note that these numbers and items can all be varied"]
[null,null,null,null,null,null,null,"an improved way of doing this is needed (e.g., referring to the generic page)"]
["TRIP LENGTH"]
["TYPE","Enter trip type","(hiking, camping, backpacking…)"]
[]
[null,"cal (days @)",1500,5,{"$f":"C9*D9","v":7500},"cal"]
[null,"cal (days @)",2000,2,{"$f":"C10*D10","v":4000},"cal"]
[null,"cal (days @)",3000,0,0,"cal"]
[null,"cal (days @)",4000,0,0,"cal"]
[null,"cal (days @)",5000,0,0,"cal"]
[null,"cal (days @)",6000,0,0,"cal"]
[null,null,null,null,{"$f":"SUM(E9:E14)","v":11500},"sum"]
[null,"days",null,{"$f":"SUM(D9:D14)","v":7}]
[null,"weeks",null,{"$f":"D16/7","v":1}]
[null,"cal factor r/t 1500",null,{"$f":"E15/(1500*D16)","v":1.0952380952380953}]
[null,{"$f":"D16","v":7},"days",{"$f":"B7","v":"Enter trip type"}]
["FOOD",null,"food","packets etc","unit","# /wk","#/trip","oz/item","#","cal/oz","oz/day","cal/day","take","cal/day","oz/day","days","pack","pack","pack","have","buy","buy"]
[null,null,null,null,null,"nominal",null,null,null,null,"for nominal 1,500 cal/day",null,"y=1, n=0","actual",null,null,"oz","lb","#","oz","oz","lb"]
[null,null,"bold = staples (main calorie foods)"]
[null,null,null,"experiment with staples amounts, new spices and seasonings, sugar v stevia"]
[null,"BREAKFAST"]
[null,null,"Granola",null,"oz",null,null,null,null,116,2,{"$f":"J25*K25","v":232},1,{"$f":"L25*M25*D18","v":254.09523809523813},{"$f":"K25*M25*D18","v":2.1904761904761907},{"$f":"D16","v":7},{"$f":"O25*P25","v":15.333333333333336},{"$f":"Q25/16","v":0.95833333333333348},null,0,{"$f":"MAX(Q25-T25,0)","v":15.333333333333336},{"$f":"U25/16","v":0.95833333333333348}]
[null,null,"Milkman","pkt","oz",2,null,3.44,{"$f":"ROUNDUP(F26*D16/7,0)","v":2},111,{"$f":"I26*H26/D16","v":0.98285714285714287},{"$f":"J26*K26","v":109.09714285714286},1,{"$f":"L26*M26","v":109.09714285714286},{"$f":"K26*M26","v":0.98285714285714287},{"$f":"D16","v":7},{"$f":"O26*P26","v":6.88},0.43,{"$f":"I26*M26","v":2},0,{"$f":"MAX(I26-T26,0)*M26","v":2},{"$f":"U26","v":2},"pkts"]
[null,null,"Coffee",null,"oz",null,null,null,null,0,1.4,{"$f":"J27*K27","v":0},1,0,1.4,{"$f":"D16","v":7},{"$f":"O27*P27","v":9.7999999999999989},0.61249999999999993,null,0,{"$f":"MAX(Q27-T27,0)","v":9.7999999999999989},{"$f":"U27/16","v":0.61249999999999993}]
[null,null,"Coffee filters (pack for one a day)",null,"oz",7,null,4.0000000000000001E-3,{"$f":"ROUNDUP(F28*D16/7,0)","v":7},0,{"$f":"I28*H28/D16","v":4.0000000000000001E-3},{"$f":"J28*K28","v":0},1,0,4.0000000000000001E-3,{"$f":"D16","v":7},{"$f":"O28*P28","v":2.8000000000000001E-2},1.75E-3,{"$f":"I28*M28","v":7},0,{"$f":"MAX(I28-T28,0)*M28","v":7},{"$f":"U28","v":7},"filters"]
[null,null,"Teas","tea bag","oz",7,null,6.25E-2,{"$f":"ROUNDUP(F29*D16/7,0)","v":7},0,{"$f":"I29*H29/D16","v":6.25E-2},0,1,0,6.25E-2,{"$f":"D16","v":7},{"$f":"O29*P29","v":0.4375},2.734375E-2,{"$f":"I29*M29","v":7},0,{"$f":"MAX(I29-T29,0)*M29","v":7},{"$f":"U29","v":7},"pkts"]
[null,null,"Inst coffee-Starbucks","pkt","oz",7,null,0.11600000000000001,{"$f":"ROUNDUP(F30*D16/7,0)","v":7},0,{"$f":"I30*H30/D16","v":0.11600000000000001},{"$f":"J30*K30","v":0},1,0,0.11600000000000001,{"$f":"D16","v":7},{"$f":"O30*P30","v":0.81200000000000006},5.0750000000000003E-2,{"$f":"I30*M30","v":7},0,{"$f":"MAX(I30-T30,0)*M30","v":7},{"$f":"U30","v":7},"pkts"]
[null,null,"Condensed milk","can","oz",1,null,14,{"$f":"ROUNDUP(F31*D16/7,0)","v":1},100,{"$f":"I31*H31/D16","v":2},{"$f":"J31*K31","v":200},0,0,0,{"$f":"D16","v":7},{"$f":"O31*P31","v":0},0,{"$f":"I31*M31","v":0},0,{"$f":"MAX(I31-T31,0)*M31","v":0},{"$f":"U31","v":0},"cans"]
[null,null,"Sugar",null,"oz",null,null,null,null,110,0.5,{"$f":"J32*K32","v":55},1,55,0.5,{"$f":"D16","v":7},{"$f":"O32*P32","v":3.5},0.21875,{"$f":"I32*M32","v":0},0,{"$f":"MAX(Q32-T32,0)","v":3.5},{"$f":"U32/16","v":0.21875}]
[null,null,"Collagen - consider for camping"]
[null,null,"Protein - consider for camping"]
[null,"LUNCH, TRAIL"]
[null,null,"Sesame sticks",null,"oz",null,null,null,null,155,2,310,1,{"$f":"L36*M36*D18","v":339.52380952380958},{"$f":"K36*M36*D18","v":2.1904761904761907},{"$f":"D16","v":7},{"$f":"O36*P36","v":15.333333333333336},{"$f":"Q36/16","v":0.95833333333333348},null,0,{"$f":"MAX(Q36-T36,0)","v":15.333333333333336},{"$f":"U36/16","v":0.95833333333333348}]
[null,null,"Nuts",null,"oz",null,null,null,null,160,2.25,360,1,{"$f":"L37*M37*D18","v":394.28571428571433},{"$f":"K37*M37*D18","v":2.4642857142857144},{"$f":"D16","v":7},17.25,{"$f":"Q37/16","v":1.078125},null,0,{"$f":"MAX(Q37-T37,0)","v":17.25},{"$f":"U37/16","v":1.078125}]
[null,null,"Dried fruit",null,"oz",null,null,null,null,100,1.5,{"$f":"J38*K38","v":150},1,{"$f":"MAX(L38*M38*D18-N39,0)","v":0},{"$f":"N38/J38","v":0},{"$f":"D16","v":7},{"$f":"O38*P38","v":0},{"$f":"Q38/16","v":0},null,0,{"$f":"MAX(Q38-T38,0)","v":0},{"$f":"U38/16","v":0}]
[null,null,"Bread Oroweat whole grain- for camping",null,"slice",14,null,1.52,null,72.39,{"$f":"F39*H39/D16","v":3.04},{"$f":"J39*K39","v":220.06560000000002},1,{"$f":"L39*M39","v":220.06560000000002},{"$f":"K39*M39","v":3.04},{"$f":"D16","v":7}]
[null,null,"(16 slices per loaf)",null,null,null,null,null,null,null,null,null,"may set to 1 if camping"]
[null,null,"Peanut butter - for camping",null,null,null,null,null,null,null,null,null,{"$f":"M39","v":1}]
[null,null,"Jelly - for camping",null,null,null,null,null,null,null,null,null,{"$f":"M39","v":1}]
[]
[null,"DINNER"]
[null,null,"Rice",null,"oz",null,null,null,null,115,1,115,1,{"$f":"L45*M45*((1+0.4*(1-M48))+(D18-1))","v":125.95238095238096},{"$f":"K45*M45*((1+0.4*(1-M48))+(D18-1))","v":1.0952380952380953},{"$f":"D16","v":7},7.6666666666666679,{"$f":"Q45/16","v":0.47916666666666674},null,0,{"$f":"MAX(Q45-T45,0)","v":7.6666666666666679},0.47916666666666674]
[null,null,"Beans",null,"oz",null,null,null,null,102,1,102,1,{"$f":"L46*M46*((1+0.4*(1-M48))+(D18-1))","v":111.71428571428572},{"$f":"K46*M46*((1+0.4*(1-M48))+(D18-1))","v":1.0952380952380953},{"$f":"D16","v":7},7.6666666666666679,{"$f":"Q46/16","v":0.47916666666666674},null,0,{"$f":"MAX(Q46-T46,0)","v":7.6666666666666679},0.47916666666666674]
[null,null,"TVP - textured vegetable protein (complete protein)"]
[null,null,"Ramen","pkt","oz",2,null,2.5,{"$f":"ROUNDUP(F48*D16/7,0)","v":2},102,{"$f":"I48*2.5/D16","v":0.7142857142857143},72.857142857142861,1,{"$f":"L48*M48","v":72.857142857142861},{"$f":"K48*M48","v":0.7142857142857143},{"$f":"D16","v":7},5,{"$f":"Q48/16","v":0.3125},{"$f":"I48*M48","v":2},0,{"$f":"MAX(I48-T48,0)*M48","v":2},{"$f":"U48","v":2},"pkts"]
[null,null,"Broths","pkt","oz",5,null,0.5,{"$f":"ROUNDUP(F49*D16/7,0)","v":5},70,{"$f":"I49*H49/D16","v":0.35714285714285715},25,1,25,0.35714285714285715,{"$f":"D16","v":7},2.5,0.15625,{"$f":"I49*M49","v":5},0,{"$f":"MAX(I49-T49,0)*M49","v":5},5,"pkts"]
[null,null,"Jerky 3oz","pkt","oz",1,null,3,{"$f":"ROUNDUP(F50*D16/7,0)","v":1},116,{"$f":"I50*H50/D16","v":0.42857142857142855},49.714285714285708,1,49.714285714285708,0.42857142857142855,{"$f":"D16","v":7},3,0.1875,{"$f":"I50*M50","v":1},0,{"$f":"MAX(I50-T50,0)*M50","v":1},1,"pkts"]
[null,null,"Jerky 7oz","pkt","oz",1,null,7,{"$f":"ROUNDUP(F51*D16/7,0)","v":1},116,{"$f":"I51*H51/D16","v":1},116,0,0,0,{"$f":"D16","v":7},0,0,{"$f":"I51*M51","v":0},0,{"$f":"MAX(I51-T51,0)*M51","v":0},0,"pkts"]
[null,null,"Cheese, cheddar",null,"oz",null,null,null,null,120,1,120,0,0,0,{"$f":"D16","v":7},0,0,null,0,{"$f":"MAX(Q52-T52,0)","v":0},0]
[null,null,"Drinks, kool-aid","pkt","oz",3,null,0.13,{"$f":"ROUNDUP(F53*D16/7,0)","v":3},0,{"$f":"I53*H53/D16","v":5.5714285714285716E-2},0,1,0,5.5714285714285716E-2,{"$f":"D16","v":7},0.39,2.4375000000000001E-2,{"$f":"I53*M53","v":3},0,{"$f":"MAX(I53-T53,0)","v":3},3,"pkts"]
[null,null,"Fruit bars","bar","oz",7,null,1.2,{"$f":"ROUNDUP(F54*D16/7,0)","v":7},100,{"$f":"I54*H54/D16","v":1.2},120,0,{"$f":"L54*M54*D18","v":0},{"$f":"K54*M54","v":0},{"$f":"D16","v":7},0,0,null,0,{"$f":"MAX(Q54-T54,0)","v":0},0]
[null,null,"Energy nuggets",null,"oz",null,null,null,null,135,1.2,162,1,{"$f":"L55*M55","v":162},{"$f":"K55*M55","v":1.2},{"$f":"D16","v":7},8.4,0.52500000000000002,null,0,{"$f":"MAX(Q55-T55,0)","v":8.4},0.52500000000000002]
[null,null,"Dessert (to enter)",null,"oz",null,null,null,null,0,0,0,0,{"$f":"L56*M56","v":0},{"$f":"K56*M56","v":0},{"$f":"D17","v":1},0,0,null,0,{"$f":"MAX(Q56-T56,0)","v":0},0]
[null,null,"Spices and salt","collection","oz",1,null,3,{"$f":"F57*D16/7","v":1},{"$f":"0","v":0},{"$f":"I57*H57/D16","v":0.42857142857142855},0,1,{"$f":"L57*M57","v":0},{"$f":"K57*M57","v":0.42857142857142855},{"$f":"D16","v":7},3,0.1875,null,0,{"$f":"MAX(Q57-T57,0)","v":3},0.1875]
[null,null,"Sun dried tomatoes","bulk","oz",1,null,2,{"$f":"F58*D16/7","v":1},{"$f":"0","v":0},{"$f":"I58*H58/D16","v":0.2857142857142857},0,1,0,{"$f":"K58*M58","v":0.2857142857142857},{"$f":"D16","v":7},2,0.125,null,0,{"$f":"MAX(Q58-T58,0)","v":2},0.125]
[null,null,"Powdered tomatoes",null,null,null,null,null,null,null,null,null,0]
[null,null,"Food cans etc (camp)",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"review this for spices adequate for three weeks… except salt, for which extra should be taken for trips over a week"]
[null,null,null,null,"unit","# items/wk","#/trip","oz/item","# items","cal/oz","oz/day","cal/day","take","cal/day","oz/day","days","oz","lb",null,"have","need","need"]
[null,null,null,null,null,"nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oz","lb"]
[null,null,"Olive oil","container","oz",2,null,1,{"$f":"ROUNDUP(F64*D16/7,0)","v":2},240,{"$f":"I64*H64/D16","v":0.2857142857142857},68.571428571428569,1,{"$f":"L64*M64*D18","v":75.102040816326536},0.2857142857142857,{"$f":"D16","v":7},2,{"$f":"Q64/16","v":0.125},null,0,{"$f":"Q64-T64","v":2},{"$f":"U64/16","v":0.125}]
[null,null,"Vitamins and meds","container system","oz",1,null,3.15,null,0,{"$f":"H65/7","v":0.45},0,1,0,0.45,{"$f":"D16","v":7},3.15,{"$f":"Q65/16","v":0.19687499999999999},null,0,{"$f":"(Q65/4.5)-T65","v":0.7},{"$f":"U65","v":0.7},"system(s)"]
[null,null,"Emergency meds","container system","oz",1,null,2.5,null,0,{"$f":"H66/7","v":0.35714285714285715},0,1,0,0.35714285714285715,{"$f":"D16","v":7},{"$f":"H66","v":2.5},{"$f":"Q66/16","v":0.15625},null,1,{"$f":"(Q66/2.5)-T66","v":0},{"$f":"U66","v":0},"system(s)"]
[null,null,"   See","Meds!A1"]
[null,"Fresh veg","Jalapenos","oz","oz",2,null,0.5,{"$f":"ROUNDUP(F68*D16/7,0)","v":2},0,{"$f":"I68*H68/D16","v":0.14285714285714285},0,1,0,0.14285714285714285,{"$f":"D16","v":7},1,{"$f":"Q68/16","v":6.25E-2},null,0,{"$f":"Q68-T68","v":1},{"$f":"U68/16","v":6.25E-2}]
[null,null,"Garlic, pre-peeled","pkt","oz",1,null,1.5,{"$f":"ROUNDUP(F69*D16/7,0)","v":1},0,{"$f":"I69*H69/D16","v":0.21428571428571427},0,0,0,0,{"$f":"D16","v":7},0,{"$f":"Q69/16","v":0},null,0,{"$f":"Q69-T69","v":0},0]
[null,null,"Garlic, fresh peeled","head","oz",1,1,1.75,1,0,{"$f":"I70*H70/7","v":0.25},0,1,0,0.25,{"$f":"D16","v":7},1.75,{"$f":"Q70/16","v":0.109375},{"$f":"F70*D17","v":1},0,{"$f":"MAX(S70-T70,0)","v":1},{"$f":"U70","v":1},"heads"]
[null,null,"Onion","oz","oz",1,null,8,{"$f":"ROUNDUP(F71*D16/7,0)","v":1},0,{"$f":"I71*H71/D16","v":1.1428571428571428},0,1,0,1.1428571428571428,{"$f":"D16","v":7},8,{"$f":"Q71/16","v":0.5},null,0,{"$f":"(Q71-T71)/8","v":1},{"$f":"U71","v":1},"onions"]
[null,null,"Pre-sautéed vegetables"]
[null,null,"Lime","oz","oz",1,null,2,{"$f":"ROUNDUP(F73*D16/7,0)","v":1},0,{"$f":"I73*H73/D16","v":0.2857142857142857},0,1,0,0.2857142857142857,{"$f":"D16","v":7},2,{"$f":"Q73/16","v":0.125},null,0,{"$f":"(Q73-T73)/2","v":1},{"$f":"U73","v":1},"limes"]
[null,"Freeze dried veg (to be entered)"]
[null,"DRY DINNER","comment - rice and beans are ~ 107 and nuts and sesame stix are ~ 155 cal / oz; so, can substitute 2/3 of rice-beans by nuts-stix for 0 to 3 days / wk at time of purchase"]
[]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N25:N65)","v":1994.4076408163266},{"$f":"SUM(O25:O73)","v":21.525357142857132},null,{"$f":"SUM(Q25:Q73)","v":129.39750000000004},{"$f":"Q77/16","v":8.0873437500000023}]
[]
["BEAR VAULT",null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,41,{"$f":"Q79/16","v":2.5625}]
[]
["FUEL",null,null,"item","unit","# items/wk",null,"oz/item","# items",null,null,null,"take",null,null,"days","oz","lb"]
[null,null,null,null,null,"nominal 1.4 - 2.0"]
[null,null,"MSR ISOPRO","13.1 oz cannister","oz",2,null,{"$f":"13.1","v":13.1},{"$f":"INT(F83*D17)*M83","v":2},"cannisters",null,null,1,null,null,{"$f":"D16","v":7},{"$f":"H83*I83*M83","v":26.2},{"$f":"Q83/16","v":1.6375}]
[null,null,"MSR ISOPRO","7.4 oz cannister","oz","N/A",null,{"$f":"7.4","v":7.4},{"$f":"ROUNDUP((F83*D17-INT(F83*D17))*(8/3.9),0)","v":0},"cannisters",null,null,{"$f":"M83","v":1},null,null,{"$f":"D16","v":7},{"$f":"H84*I84*M84","v":0},{"$f":"Q84/16","v":0}]
[]
[null,null,"White Gas",null,"unit",null,null,"oz/item","# items",null,null,null,"take",null,null,"days","oz","lb"]
[null,null,"(24 oz/wk)",null,null,null,null,null,null,null,null,null,0,null,{"$f":"24/7","v":3.4285714285714284},{"$f":"D16","v":7},{"$f":"O87*P87*M87","v":0},{"$f":"Q87/16","v":0}]
[null,null,null,"fuel bottle","oz",null,null,{"$f":"33","v":33},{"$f":"INT(O87*D16/33)","v":0}]
[null,null,null,"fuel bottle","oz",null,null,20,{"$f":"ROUNDUP((O87*D16/33-INT(O87*D16/33))*33/22,0)","v":2}]
[null,null,null,"fuel bottle","oz",null,null,11]
[null,null,"Total fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q83+Q84+Q87","v":26.2},{"$f":"Q91/16","v":1.6375}]
["Total food, fuel, and bear vault",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q77+Q79+Q91","v":196.59750000000003},{"$f":"Q92/16","v":12.287343750000002}]

{"sheet":"Food and fuel-backpacking","index":3,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[[20,10,20,11],[20,13,20,14]]}
["USE"]
[null,"red items are to be entered for each trip",null,null,null,null,"This is for backpacking, obtained from generic page",null,null,null,null,"Food and fuel"]
[null,"food cal/oz from","https://www.myfooddiary.com/",null,null,null,null,"by setting 1,500 cal days = 5, 2000 cal days = 3, and changing nominal amounts for the main calorie items"]
[null,"review for improvement",null,null,null,null,null,"note that these numbers and items can all be varied"]
[null,null,null,null,null,null,null,"an improved way of doing this is needed (e.g., referring to the generic page)"]
["TRIP LENGTH"]
["TYPE","Backpacking","(hiking, camping, backpacking…)"]
[]
[null,"cal (days @)",1500,4,{"$f":"C9*D9","v":6000},"cal"]
[null,"cal (days @)",2000,3,{"$f":"C10*D10","v":6000},"cal"]
[null,"cal (days @)",3000,0,0,"cal"]
[null,"cal (days @)",4000,0,0,"cal"]
[null,"cal (days @)",5000,0,0,"cal"]
[null,"cal (days @)",6000,0,0,"cal"]
[null,null,null,null,{"$f":"SUM(E9:E14)","v":12000},"sum"]
[null,"days",null,{"$f":"SUM(D9:D14)","v":7}]
[null,"weeks",null,{"$f":"D16/7","v":1}]
[null,"cal factor r/t 1500",null,{"$f":"E15/(1500*D16)","v":1.1428571428571428}]
[null,{"$f":"D16","v":7},"days",{"$f":"B7","v":"Backpacking"}]
["FOOD",null,"food","packets etc","unit","# /wk","#/trip","oz/item","#","cal/oz","oz/day","cal/day","take","cal/day","oz/day","days","pack","pack","pack","have","buy","buy"]
[null,null,null,null,null,"nominal",null,null,null,null,"for nominal 1,500 cal/day",null,"y=1, n=0","actual",null,null,"oz","lb","#","oz","oz","lb"]
[null,null,"bold = staples (main calorie foods)"]
[null,null,null,"experiment with staples amounts, new spices and seasonings, sugar v stevia"]
[null,"BREAKFAST"]
[null,null,"Granola",null,"oz",null,null,null,null,116,3,{"$f":"J25*K25","v":348},1,{"$f":"L25*M25*D18","v":397.71428571428567},{"$f":"K25*M25*D18","v":3.4285714285714284},{"$f":"D16","v":7},{"$f":"O25*P25","v":24},{"$f":"Q25/16","v":1.5},null,0,{"$f":"MAX(Q25-T25,0)","v":24},{"$f":"U25/16","v":1.5}]
[null,null,"Milkman","pkt","oz",2,null,3.44,{"$f":"ROUNDUP(F26*D16/7,0)","v":2},111,{"$f":"I26*H26/D16","v":0.98285714285714287},{"$f":"J26*K26","v":109.09714285714286},1,{"$f":"L26*M26","v":109.09714285714286},{"$f":"K26*M26","v":0.98285714285714287},{"$f":"D16","v":7},{"$f":"O26*P26","v":6.88},0.43,2,3,{"$f":"MAX(I26-T26,0)*M26","v":0},{"$f":"U26","v":0},"pkts"]
[null,null,"Coffee",null,"oz",null,null,null,null,0,1.4,{"$f":"J27*K27","v":0},1,0,1.4,{"$f":"D16","v":7},{"$f":"O27*P27","v":9.7999999999999989},0.61249999999999993,null,0,{"$f":"MAX(Q27-T27,0)","v":9.7999999999999989},{"$f":"U27/16","v":0.61249999999999993}]
[null,null,"Coffee filters (pack for one a day)",null,"oz",7,null,4.0000000000000001E-3,{"$f":"ROUNDUP(F28*D16/7,0)","v":7},0,{"$f":"I28*H28/D16","v":4.0000000000000001E-3},{"$f":"J28*K28","v":0},1,0,4.0000000000000001E-3,{"$f":"D16","v":7},{"$f":"O28*P28","v":2.8000000000000001E-2},1.75E-3,0,0,0,{"$f":"U28","v":0},"filters"]
[null,null,"Teas","tea bag","oz",7,null,6.25E-2,{"$f":"ROUNDUP(F29*D16/7,0)","v":7},0,{"$f":"I29*H29/D16","v":6.25E-2},0,1,0,6.25E-2,{"$f":"D16","v":7},{"$f":"O29*P29","v":0.4375},2.734375E-2,{"$f":"I29*M29","v":7},8,{"$f":"MAX(I29-T29,0)*M29","v":0},{"$f":"U29","v":0},"pkts"]
[null,null,"Inst coffee-Starbucks","pkt","oz",7,null,0.11600000000000001,{"$f":"ROUNDUP(F30*D16/7,0)","v":7},0,{"$f":"I30*H30/D16","v":0.11600000000000001},{"$f":"J30*K30","v":0},1,0,0.11600000000000001,{"$f":"D16","v":7},{"$f":"O30*P30","v":0.81200000000000006},5.0750000000000003E-2,{"$f":"I30*M30","v":7},8,{"$f":"MAX(I30-T30,0)*M30","v":0},{"$f":"U30","v":0},"pkts"]
[null,null,"Condensed milk","can","oz",1,null,14,{"$f":"ROUNDUP(F31*D16/7,0)","v":1},100,{"$f":"I31*H31/D16","v":2},{"$f":"J31*K31","v":200},0,0,0,{"$f":"D16","v":7},{"$f":"O31*P31","v":0},0,{"$f":"I31*M31","v":0},0,{"$f":"MAX(I31-T31,0)*M31","v":0},{"$f":"U31","v":0},"cans"]
[null,null,"Sugar",null,"oz",null,null,null,null,110,0.5,{"$f":"J32*K32","v":55},1,55,0.5,{"$f":"D16","v":7},{"$f":"O32*P32","v":3.5},0.21875,{"$f":"I32*M32","v":0},4,{"$f":"MAX(Q32-T32,0)","v":0},{"$f":"U32/16","v":0}]
[null,null,"Collagen - consider for camping"]
[null,null,"Protein - consider for camping"]
[null,"LUNCH, TRAIL"]
[null,null,"Sesame sticks",null,"oz",null,null,null,null,155,3,465,1,{"$f":"L36*M36*D18","v":531.42857142857144},{"$f":"K36*M36*D18","v":3.4285714285714284},{"$f":"D16","v":7},{"$f":"O36*P36","v":24},{"$f":"Q36/16","v":1.5},null,0,{"$f":"MAX(Q36-T36,0)","v":24},{"$f":"U36/16","v":1.5}]
[null,null,"Nuts",null,"oz",null,null,null,null,160,3.5,560,1,{"$f":"L37*M37*D18","v":640},{"$f":"K37*M37*D18","v":4},{"$f":"D16","v":7},28,{"$f":"Q37/16","v":1.75},null,0,{"$f":"MAX(Q37-T37,0)","v":28},{"$f":"U37/16","v":1.75}]
[null,null,"Dried fruit",null,"oz",null,null,null,null,100,1.5,{"$f":"J38*K38","v":150},1,{"$f":"MAX(L38*M38*D18-N39,0)","v":171.42857142857142},{"$f":"N38/J38","v":1.7142857142857142},{"$f":"D16","v":7},{"$f":"O38*P38","v":12},{"$f":"Q38/16","v":0.75},null,0,{"$f":"MAX(Q38-T38,0)","v":12},{"$f":"U38/16","v":0.75}]
[null,null,"Bread Oroweat whole grain- for camping",null,"slice",14,null,1.52,null,72.39,{"$f":"F39*H39/D16","v":3.04},{"$f":"J39*K39","v":220.06560000000002},0,{"$f":"L39*M39","v":0},{"$f":"K39*M39","v":0},{"$f":"D16","v":7}]
[null,null,"(16 slices per loaf)",null,null,null,null,null,null,null,null,null,"may set to 1 if camping"]
[null,null,"Peanut butter - for camping",null,null,null,null,null,null,null,null,null,{"$f":"M39","v":0}]
[null,null,"Jelly - for camping",null,null,null,null,null,null,null,null,null,{"$f":"M39","v":0}]
[]
[null,"DINNER"]
[null,null,"Rice",null,"oz",null,null,null,null,115,1.5,172.5,1,{"$f":"L45*M45*((1+0.4*(1-M48))+(D18-1))","v":266.14285714285711},{"$f":"K45*M45*((1+0.4*(1-M48))+(D18-1))","v":2.3142857142857141},{"$f":"D16","v":7},16.2,{"$f":"Q45/16","v":1.0125},null,20,{"$f":"MAX(Q45-T45,0)","v":0},0]
[null,null,"Beans",null,"oz",null,null,null,null,102,1.5,153,1,{"$f":"L46*M46*((1+0.4*(1-M48))+(D18-1))","v":236.05714285714282},{"$f":"K46*M46*((1+0.4*(1-M48))+(D18-1))","v":2.3142857142857141},{"$f":"D16","v":7},16.2,{"$f":"Q46/16","v":1.0125},null,20,{"$f":"MAX(Q46-T46,0)","v":0},0]
[null,null,"TVP - textured vegetable protein (complete protein)"]
[null,null,"Ramen","pkt","oz",2,null,2.5,{"$f":"ROUNDUP(F48*D16/7,0)","v":2},102,{"$f":"I48*2.5/D16","v":0.7142857142857143},72.857142857142861,0,{"$f":"L48*M48","v":0},{"$f":"K48*M48","v":0},{"$f":"D16","v":7},0,{"$f":"Q48/16","v":0},{"$f":"I48*M48","v":0},0,{"$f":"MAX(I48-T48,0)*M48","v":0},{"$f":"U48","v":0},"pkts"]
[null,null,"Broths","pkt","oz",5,null,0.5,{"$f":"ROUNDUP(F49*D16/7,0)","v":5},70,{"$f":"I49*H49/D16","v":0.35714285714285715},25,1,25,0.35714285714285715,{"$f":"D16","v":7},2.5,0.15625,{"$f":"I49*M49","v":5},0,{"$f":"MAX(I49-T49,0)*M49","v":5},5,"pkts"]
[null,null,"Jerky 3oz","pkt","oz",1,null,3,{"$f":"ROUNDUP(F50*D16/7,0)","v":1},116,{"$f":"I50*H50/D16","v":0.42857142857142855},49.714285714285708,1,49.714285714285708,0.42857142857142855,{"$f":"D16","v":7},3,0.1875,{"$f":"I50*M50","v":1},0,{"$f":"MAX(I50-T50,0)*M50","v":1},1,"pkts"]
[null,null,"Jerky 7oz","pkt","oz",1,null,7,{"$f":"ROUNDUP(F51*D16/7,0)","v":1},116,{"$f":"I51*H51/D16","v":1},116,0,0,0,{"$f":"D16","v":7},0,0,{"$f":"I51*M51","v":0},0,{"$f":"MAX(I51-T51,0)*M51","v":0},0,"pkts"]
[null,null,"Cheese, cheddar",null,"oz",null,null,null,null,120,1,120,0,0,0,{"$f":"D16","v":7},0,0,null,0,{"$f":"MAX(Q52-T52,0)","v":0},0]
[null,null,"Drinks, kool-aid","pkt","oz",3,null,0.13,{"$f":"ROUNDUP(F53*D16/7,0)","v":3},0,{"$f":"I53*H53/D16","v":5.5714285714285716E-2},0,1,0,5.5714285714285716E-2,{"$f":"D16","v":7},0.39,2.4375000000000001E-2,{"$f":"I53*M53","v":3},0,{"$f":"MAX(I53-T53,0)","v":3},3,"pkts"]
[null,null,"Fruit bars","bar","oz",7,null,1.2,{"$f":"ROUNDUP(F54*D16/7,0)","v":7},100,{"$f":"I54*H54/D16","v":1.2},120,0,{"$f":"L54*M54*D18","v":0},{"$f":"K54*M54","v":0},{"$f":"D16","v":7},0,0,null,0,{"$f":"MAX(Q54-T54,0)","v":0},0]
[null,null,"Energy nuggets",null,"oz",null,null,null,null,135,1.2,162,1,{"$f":"L55*M55","v":162},{"$f":"K55*M55","v":1.2},{"$f":"D16","v":7},8.4,0.52500000000000002,null,0,{"$f":"MAX(Q55-T55,0)","v":8.4},0.52500000000000002]
[null,null,"Dessert (to enter)",null,"oz",null,null,null,null,0,0,0,0,{"$f":"L56*M56","v":0},{"$f":"K56*M56","v":0},{"$f":"D17","v":1},0,0,null,0,{"$f":"MAX(Q56-T56,0)","v":0},0]
[null,null,"Spices and salt","collection","oz",1,null,3,{"$f":"F57*D16/7","v":1},{"$f":"0","v":0},{"$f":"I57*H57/D16","v":0.42857142857142855},0,1,{"$f":"L57*M57","v":0},{"$f":"K57*M57","v":0.42857142857142855},{"$f":"D16","v":7},3,0.1875,null,0,{"$f":"MAX(Q57-T57,0)","v":3},0.1875]
[null,null,"Sun dried tomatoes","bulk","oz",1,null,2,{"$f":"F58*D16/7","v":1},{"$f":"0","v":0},{"$f":"I58*H58/D16","v":0.2857142857142857},0,1,0,{"$f":"K58*M58","v":0.2857142857142857},{"$f":"D16","v":7},2,0.125,null,0,{"$f":"MAX(Q58-T58,0)","v":2},0.125]
[null,null,"Powdered tomatoes",null,null,null,null,null,null,null,null,null,0]
[null,null,"Food cans etc (camp)",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,"review this for spices adequate for three weeks… except salt, for which extra should be taken for trips over a week"]
[null,null,null,null,"unit","# items/wk","#/trip","oz/item","# items","cal/oz","oz/day","cal/day","take","cal/day","oz/day","days","oz","lb",null,"have","need","need"]
[null,null,null,null,null,"nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oz","lb"]
[null,null,"Olive oil","container","oz",2,null,1,{"$f":"ROUNDUP(F64*D16/7,0)","v":2},240,{"$f":"I64*H64/D16","v":0.2857142857142857},68.571428571428569,1,{"$f":"L64*M64*D18","v":78.367346938775498},0.2857142857142857,{"$f":"D16","v":7},2,{"$f":"Q64/16","v":0.125},null,0,{"$f":"Q64-T64","v":2},{"$f":"U64/16","v":0.125}]
[null,null,"Vitamins and meds","container system","oz",1,null,3.15,null,0,{"$f":"H65/7","v":0.45},0,1,0,0.45,{"$f":"D16","v":7},3.15,{"$f":"Q65/16","v":0.19687499999999999},null,0,{"$f":"(Q65/4.5)-T65","v":0.7},{"$f":"U65","v":0.7},"system(s)"]
[null,null,"Emergency meds","container system","oz",1,null,2.5,null,0,{"$f":"H66/7","v":0.35714285714285715},0,1,0,0.35714285714285715,{"$f":"D16","v":7},{"$f":"H66","v":2.5},{"$f":"Q66/16","v":0.15625},null,1,{"$f":"(Q66/2.5)-T66","v":0},{"$f":"U66","v":0},"system(s)"]
[null,null,"   See","Meds!A1"]
[null,"Fresh veg","Jalapenos","oz","oz",2,null,0.5,{"$f":"ROUNDUP(F68*D16/7,0)","v":2},0,{"$f":"I68*H68/D16","v":0.14285714285714285},0,1,0,0.14285714285714285,{"$f":"D16","v":7},1,{"$f":"Q68/16","v":6.25E-2},null,0,{"$f":"Q68-T68","v":1},{"$f":"U68/16","v":6.25E-2}]
[null,null,"Garlic, pre-peeled","pkt","oz",1,null,1.5,{"$f":"ROUNDUP(F69*D16/7,0)","v":1},0,{"$f":"I69*H69/D16","v":0.21428571428571427},0,0,0,0,{"$f":"D16","v":7},0,{"$f":"Q69/16","v":0},null,0,{"$f":"Q69-T69","v":0},0]
[null,null,"Garlic, fresh peeled","head","oz",1,1,1.75,1,0,{"$f":"I70*H70/7","v":0.25},0,1,0,0.25,{"$f":"D16","v":7},1.75,{"$f":"Q70/16","v":0.109375},{"$f":"F70*D17","v":1},0,{"$f":"MAX(S70-T70,0)","v":1},{"$f":"U70","v":1},"heads"]
[null,null,"Onion","oz","oz",1,null,8,{"$f":"ROUNDUP(F71*D16/7,0)","v":1},0,{"$f":"I71*H71/D16","v":1.1428571428571428},0,1,0,1.1428571428571428,{"$f":"D16","v":7},8,{"$f":"Q71/16","v":0.5},null,0,{"$f":"(Q71-T71)/8","v":1},{"$f":"U71","v":1},"onions"]
[null,null,"Pre-sautéed vegetables"]
[null,null,"Lime","oz","oz",1,null,2,{"$f":"ROUNDUP(F73*D16/7,0)","v":1},0,{"$f":"I73*H73/D16","v":0.2857142857142857},0,1,0,0.2857142857142857,{"$f":"D16","v":7},2,{"$f":"Q73/16","v":0.125},null,0,{"$f":"(Q73-T73)/2","v":1},{"$f":"U73","v":1},"limes"]
[null,"Freeze dried veg (to be entered)"]
[null,"DRY DINNER","comment - rice and beans are ~ 107 and nuts and sesame stix are ~ 155 cal / oz; so, can substitute 2/3 of rice-beans by nuts-stix for 0 to 3 days / wk at time of purchase"]
[]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N25:N65)","v":2721.9502040816324},{"$f":"SUM(O25:O73)","v":25.935357142857132},null,{"$f":"SUM(Q25:Q73)","v":181.54749999999999},{"$f":"Q77/16","v":11.346718749999999}]
[]
["BEAR VAULT",null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,41,{"$f":"Q79/16","v":2.5625}]
[]
["FUEL",null,null,"item","unit","# items/wk",null,"oz/item","# items",null,null,null,"take",null,null,"days","oz","lb"]
[null,null,null,null,null,"nominal 1.4 - 2.0"]
[null,null,"MSR ISOPRO","13.1 oz cannister","oz",2,null,{"$f":"13.1","v":13.1},{"$f":"INT(F83*D17)*M83","v":2},"cannisters",null,null,1,null,null,{"$f":"D16","v":7},{"$f":"H83*I83*M83","v":26.2},{"$f":"Q83/16","v":1.6375}]
[null,null,"MSR ISOPRO","7.4 oz cannister","oz","N/A",null,{"$f":"7.4","v":7.4},{"$f":"ROUNDUP((F83*D17-INT(F83*D17))*(8/3.9),0)","v":0},"cannisters",null,null,{"$f":"M83","v":1},null,null,{"$f":"D16","v":7},{"$f":"H84*I84*M84","v":0},{"$f":"Q84/16","v":0}]
[]
[null,null,"White Gas",null,"unit",null,null,"oz/item","# items",null,null,null,"take",null,null,"days","oz","lb"]
[null,null,"(24 oz/wk)",null,null,null,null,null,null,null,null,null,0,null,{"$f":"24/7","v":3.4285714285714284},{"$f":"D16","v":7},{"$f":"O87*P87*M87","v":0},{"$f":"Q87/16","v":0}]
[null,null,null,"fuel bottle","oz",null,null,{"$f":"33","v":33},{"$f":"INT(O87*D16/33)","v":0}]
[null,null,null,"fuel bottle","oz",null,null,20,{"$f":"ROUNDUP((O87*D16/33-INT(O87*D16/33))*33/22,0)","v":2}]
[null,null,null,"fuel bottle","oz",null,null,11]
[null,null,"Total fuel",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q83+Q84+Q87","v":26.2},{"$f":"Q91/16","v":1.6375}]
["Total food, fuel, and bear vault",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q77+Q79+Q91","v":248.74749999999997},{"$f":"Q92/16","v":15.546718749999998}]

{"sheet":"Gear","index":4,"n_rows":183,"n_cols":24,"rows_kept":183,"cut":false,"hidden":false,"merged":[[9,14,9,15]]}
[]
["Trip length","Days=",7,null,"items in red to be entered per trip"]
[null,"Weeks =",{"$f":"C2/7","v":1}]
[null,"Months =",{"$f":"C2*12/365","v":0.23013698630136986}]
[null,null,null,null,"eliminate much of this junk",null,null,"some items depend on length of trip"]
[null,"#people=",1,"one or two"]
[]
["Travel-camping material is in a blue font"]
[]
[null,null,null,null,null,null,null,null,null,null,"all weights are per person",null,null,null,null,null,null,null,null,null,null,"Modifications to consider"]
[null,null,null,"1=take, 0=no","unit","oz/unit","units/day","units /week","units/month","weeks","/trip","units (total)","oz (total)","lb",null,null,null,"cal/week","cal/day","cal/lb",null,null,"Simplification"]
[]
[{"$f":"K2/C2","v":0},"Breakfast",null,null,null,null,null,null,null,null,null,"needed","needed",null,null,null,null,null,null,null,null,null,"More than one person, assuming similar personal gear…"]
["target",null,"Granola (~116 cal/oz)",1,"cup",3.5,null,3.5,null,{"$f":"C3","v":1},null,{"$f":"M14/F14","v":{"$error":"#REF!"}},{"$f":"D14*F14*H14*J14*#REF!","v":{"$error":"#REF!"}},{"$f":"M14/16","v":{"$error":"#REF!"}},null,null,null,{"$f":"H14*F14*Q14*D14","v":0},{"$f":"R14/7","v":0},{"$f":"Q14*16","v":0},null,null,null,"… and shared gear, e.g., one stove / four people"]
["mean cal/day",null,"Milk powder",0,"cup",6.5,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"C3","v":1},null,{"$f":"M15/F15","v":{"$error":"#REF!"}},{"$f":"D15*F15*H15*J15","v":{"$error":"#REF!"}},{"$f":"M15/16","v":{"$error":"#REF!"}},null,null,null,{"$f":"H15*F15*Q15*D15","v":{"$error":"#REF!"}},{"$f":"R15/7","v":{"$error":"#REF!"}},{"$f":"Q15*16","v":0},null,null,"Automated entry of new items"]
[null,null,"Milkman",1,"packet",3.44,null,{"$f":"ROUNDUP((#REF!+#REF!+#REF!+#REF!+#REF!)/4,0)","v":{"$error":"#REF!"}},null,null,null,{"$f":"H16*C3*D16","v":{"$error":"#REF!"}},{"$f":"D16*H16*3.44","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$f":"Q16*M16","v":{"$error":"#REF!"}},{"$f":"R16/7","v":{"$error":"#REF!"}},0]
[{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,"Coffee",1,"oz",1,1.2,{"$f":"G17*7","v":8.4},null,{"$f":"C3","v":1},null,8.4,{"$f":"D17*F17*H17*J17","v":8.4},0.52500000000000002,null,null,null,{"$f":"H17*F17*Q17*D17","v":0},0,0]
["days",null,null,null,null,null,"5 heaping tbsp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N180","v":19.084375000000001}]
[null,null,"Coffee, freeze dried, consider"]
[null,null,"Sugar (~110 cal/oz)",1,"oz",1,null,3.5,null,{"$f":"C3","v":1},null,{"$f":"M20/F20","v":3.5},{"$f":"D20*F20*H20*J20","v":3.5},0.21875,null,null,null,{"$f":"H20*F20*Q20*D20","v":0},0,0]
[null,null,"Vitamins, meds, ibuprofen",1,"oz",1,null,1,null,{"$f":"C3","v":1},null,{"$f":"M21/F21","v":1},{"$f":"D21*F21*H21*J21","v":1},{"$f":"M21/16","v":6.25E-2},null,null,null,{"$f":"H21*F21*Q21*D21","v":0},0,0,null,"qd-4 ibu 1 allegra 100mg losartan 25 mg hctz 1(b,C,D,E,Glucosamine, Multi)"]
["may sustitute ",null,"Teas",1,"pkt",6.25E-2,null,7,null,{"$f":"C3","v":1},null,7,{"$f":"D22*F22*H22*J22","v":0.4375},{"$f":"M22/16","v":2.734375E-2},null,null,null,{"$f":"H22*F22*Q22*D22","v":0},0,0]
[null,null,"Drinks, KoolAid",1,"pkt",0.13,null,3,null,{"$f":"C3","v":1},null,{"$f":"ROUND(H23*J23,0)","v":3},{"$f":"L23*F23","v":0.39},{"$f":"M23/16","v":2.4375000000000001E-2},null,null,null,{"$f":"H23*F23*Q23*D23","v":0},{"$f":"R23/7","v":0},{"$f":"Q23*16","v":0}]
["amounts",null,"Condensed milk",0,"can",14,null,1,null,{"$f":"C3","v":1},1,0,{"$f":"D24*F24*H24*J24","v":0},{"$f":"M24/16","v":0},null,null,null,{"$f":"D24*Q24*F24/J24","v":0},0,0]
[null,"Trail"]
[null,null,"Sesame sticks",1,"oz",1,null,7,null,{"$f":"C3","v":1},null,{"$f":"M26/F26","v":{"$error":"#REF!"}},{"$f":"D26*F26*H26*J26*#REF!","v":{"$error":"#REF!"}},{"$f":"M26/16","v":{"$error":"#REF!"}},null,null,null,{"$f":"H26*F26*Q26*D26","v":0},0,0]
["1 cup = 2 2/3 fist",null,"Nuts (Peanuts, Cashews ~160 cal/oz)",1,"oz",1,null,10.5,null,{"$f":"C3","v":1},null,{"$f":"M27/F27","v":{"$error":"#REF!"}},{"$f":"D27*F27*H27*J27*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$f":"H27*F27*Q27*D27","v":0},0,0]
[null,null,"Dried fruit",1,"oz",1,null,14,null,{"$f":"C3","v":1},null,{"$error":"#REF!"},{"$f":"D28*F28*H28*J28*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$f":"H28*F28*Q28*D28","v":0},0,0]
[null,"Dinner"]
[null,null,"Rice, instant",1,"oz",1,null,7,null,{"$f":"C3","v":1},null,{"$f":"M30/F30","v":{"$error":"#REF!"}},{"$f":"D30*F30*H30*J30*#REF!","v":{"$error":"#REF!"}},{"$f":"M30/16","v":{"$error":"#REF!"}},null,null,null,{"$f":"H30*F30*Q30*D30","v":0},0,0]
[null,null,"Rice, regular, to work on"]
[null,null,"Beans",1,"oz",1,null,7,null,{"$f":"C3","v":1},null,{"$f":"M32/F32","v":{"$error":"#REF!"}},{"$f":"D32*F32*H32*J32*#REF!","v":{"$error":"#REF!"}},{"$f":"M32/16","v":{"$error":"#REF!"}},null,null,null,{"$f":"H32*F32*Q32*D32","v":0},0,0]
[null,null,"Ramen",1,"packet",2.5,null,{"$f":"ROUNDUP(2*#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"C3","v":1},null,{"$f":"ROUND(H33*J33,0)","v":{"$error":"#REF!"}},{"$f":"L33*F33","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},0]
[null,null,"Broths",1,"packet",0.5,null,4,null,{"$f":"C3","v":1},null,5,{"$f":"L34*F34","v":2.5},0.15625,null,null,null,0,0,0]
[null,null,"Jerky",1,"packet",3,null,1,null,{"$f":"C3","v":1},null,{"$f":"ROUNDUP(H35*J35,0)","v":1},3,0.1875,null,null,null,0,0,0]
[null,null,"Fruit bars",1,"bar",1.2,null,7,null,{"$f":"C3","v":1},null,{"$f":"ROUNDUP(H36*J36*#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,0,0,0]
[null,null,"Turmeric",0,"oz",1,null,1,null,{"$f":"C3","v":1},null,{"$f":"M37/F37","v":0},{"$f":"D37*F37*H37*J37","v":0},0,null,null,null,0,0,0]
[null,null,"Jalapenos",1,"jalapeno",0.5,null,2,null,{"$f":"C3","v":1},null,{"$f":"ROUND(H38*J38,0)","v":2},{"$f":"L38*F38","v":1},6.25E-2,null,null,null,0,0,0]
[null,null,"Garlic, packets",1,"packet",1.5,null,1,null,{"$f":"C3","v":1},null,{"$f":"ROUND(H39*J39,0)","v":1},{"$f":"L39*F39","v":1.5},9.375E-2,null,null,null,0,0,0]
[null,null,"Onion, thumb dia",1,"onion",6,null,1,null,{"$f":"C3","v":1},null,1,6,0.375,null,null,null,0,0,0]
[null,null,"Lime",1,"lime",2,null,1,null,{"$f":"C3","v":1},null,1,2,0.125,null,null,null,0,0,0]
[null,null,"Spice collection(review)",1,"oz",1,null,3,null,{"$f":"C3","v":1},null,3,3,0.1875,null,null,null,0,0,0]
[null,null,"Cajun seasoning etc",null,null,null,null,null,null,null,null,0,0]
[null,null,"Salt",1,"oz",1,null,2,null,{"$f":"C3","v":1},null,2,2,0.125,null,null,null,0,0,0]
[null,null,"Olive oil (~240 cal/oz)",1,"oz",1.5,null,{"$f":"2*#REF!","v":{"$error":"#REF!"}},null,{"$f":"C3","v":1},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,{"$f":"H45*F45*Q45*D46","v":{"$error":"#REF!"}},{"$error":"#REF!"},0]
[null,"Stuff sacks",null,0,"sack",4.5,null,null,null,null,{"$f":"J7","v":0},{"$f":"K46","v":0},{"$f":"D46*F46*L46","v":0},0]
[null,"Bearvault",null,1,"vault",41,null,null,null,null,1,{"$f":"K47","v":1},{"$f":"D47*F47*L47","v":41},{"$f":"M47/16","v":2.5625}]
["Food, total (one person)",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"M48/16","v":0},null,null,null,0,0,0]
[null,null,"Backpacker’s food—am = granola and/or alt | trail = nuts & fruits | pm = rice, beans, dry/fresh veg | and variety—try out soups | crackers and more | Kool-Aid"]
[null,null,"Granola alternates and supplements—Cream of wheat savory | and with sugar and blueberries | and made-up mixes from co-op bulk"]
["Cooking",null,"Bold = current use"]
[null,null,"Utensils",1,"item(s)",6,null,null,null,null,1,null,{"$f":"D52*F52","v":6},{"$f":"M52/16","v":0.375}]
[null,null,"Coffee filters",1,"item(s)",0.05,1,null,null,null,null,{"$f":"C2","v":7},{"$f":"D53*F53*G53*L53","v":0.35000000000000003},{"$f":"M53/16","v":2.1875000000000002E-2}]
[null,null,"Stove-MSR Dragonfly",0,"item(s)",14.5,null,null,null,null,1,null,{"$f":"D54*F54*K54/C6","v":0},{"$f":"M54/16","v":0}]
[null,null,"Stove-Pocket rocket with base",1,"item(s)",4,null,null,null,null,1,null,{"$f":"D55*F55*K55/C6","v":4},{"$f":"M55/16","v":0.25}]
[null,null,"Heat shield",0,"item(s)",2.5,null,null,null,null,1,null,{"$f":"D56*F56*K56/C6","v":0},0]
[null,null,"Pot, titanium",1,"item(s)",6,null,null,null,null,1,null,{"$f":"D57*F57*K57/C6","v":6},0.375]
[null,null,"Pot, stainless, 0.50 gal",0,"item(s)",20,null,null,null,null,1,null,{"$f":"D58*F58*K58/C6","v":0},0]
[null,null,"Pot, stainless, 0.25 gal",0,"item(s)",13,null,null,null,null,1,null,{"$f":"D59*F59*K59/C6","v":0},0]
[null,null,"Fuel bottle, 1 l tr/ 33oz",0,"item(s)",7.6,null,null,null,null,{"$f":"ROUNDUP(H64*C6/32,0)","v":1},null,{"$f":"D60*F60*K60/C6","v":0},{"$f":"M60/16","v":0}]
[null,null,"Fuel bottle, 591 ml / 20oz",{"$f":"0","v":0},"item(s)",6,null,null,null,null,1,null,0,{"$f":"M61/16","v":0}]
[null,null,"Fuel bottle, 325 ml / 11oz",0,"item(s)",4,null,null,null,null,1,null,0,{"$f":"M62/16","v":0}]
[]
[null,null,"Fuel",null,"fl oz",0.7,null,{"$f":"(32*(1+(C6-1)*0.5)*C3)/C6","v":32},null,null,null,null,0,{"$f":"M64/16","v":0}]
[]
[null,null,null,"1=take, 0=no","unit","oz/unit","units/day","units /week","units/month","weeks","/trip","units (total)","oz (total)","lb"]
[null,null,"MSR Pocket Rocket Deluxe",0,"item(s)",2.9,"currently, a one person item",null,null,null,1,null,{"$f":"D67*F67","v":0},{"$f":"M67/16","v":0}]
[null,null,"MSR cannisters 7.4 oz",0,"item(s)",7.4,null,null,null,{"$f":"C3","v":1},null,{"$f":"ROUNDUP((J69*H69)-INT(J69*H69),0)","v":1},0,0]
[null,null,"MSR cannisters 13.1 oz",1,"item(s)",13.1,null,1.4,null,{"$f":"C3","v":1},null,{"$f":"INT(J69*H69)","v":1},0,{"$f":"M69/16","v":0}]
["Cooking… total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M52:M69)","v":16.350000000000001},1.0218750000000001]
[]
["Hiking, travel",null,null,null,null,null,null,null,"include in pack weight 1 = yes, 0 = no"]
[null,null,"Backpack, Osprey, Exos 58",1,"item(s)",36,null,null,1,null,null,null,{"$f":"D73*F73*I73","v":36},{"$f":"M73/16","v":2.25}]
[null,null,"Pack Cover, Osprey, Large",0,"item(s)",3,null,null,1,null,null,null,0,{"$f":"M74/16","v":0}]
[null,null,"Backpack, Osprey, Argon 85M",0,"item(s)",104,null,null,1,null,null,null,0,{"$f":"M75/16","v":0}]
[null,null,"Olive Jansport daypack",0,"item(s)",17,null,null,1,null,null,null,0,{"$f":"M76/16","v":0}]
[null,null,"Sea to Summit light daypack",1,"item(s)",2.5,null,null,1,null,null,null,{"$f":"D77*F77*I77","v":2.5},{"$f":"M77/16","v":0.15625}]
[null,null,"Binoculars",0,"item(s)",8.5,null,null,1,null,null,null,0,{"$f":"M78/16","v":0}]
[null,null,"Rifle, .30-06",0,"item(s)",144,null,null,1,null,null,null,0,{"$f":"M79/16","v":0}]
[null,null,"Shoes, ankle high (new)",0,"item(s)",32,null,null,0,null,null,null,{"$f":"D80*F80*I80","v":0},0]
[null,null,"Shoes, ankle high",0,"item(s)",48,null,null,0,null,null,null,0,0]
[null,null,"Shoes, running",0,"item(s)",30,null,null,0,null,null,null,0,0]
[null,null,"Sneakers",0,"item(s)",29,null,null,1,null,null,null,0,0]
[null,null,"Sandals, Keen",1,"item(s)",27,null,null,1,null,null,null,{"$f":"D84*F84*I84","v":27},{"$f":"M84/16","v":1.6875}]
[null,null,"Sandals for water crossing",1,"item(s)",18,null,null,1,null,null,null,18,1.125]
[null,null,"Sandals, Teva",0,"item(s)",24,null,null,1,null,null,null,{"$f":"D86*F86*I86","v":0},{"$f":"M86/16","v":0}]
[null,null,"Shoes, dress",0,"item(s)",26,null,null,1,null,null,null,0,{"$f":"M87/16","v":0}]
[null,null,"MSR Snowshoes",0,"item(s)",59,null,null,1,null,null,null,0,0]
[null,null,"… MSR Snowshoe extebsuibs",0,"item(s)",17,null,null,1,null,null,null,0,0]
[null,null,"Cross-country skis and poles",0,"item(s)",118,null,null,1,null,null,null,0,0]
[null,null,"Crampons",0,"item(s)",40.75,null,null,1,null,null,null,0,0]
[null,null,"Trekking poles, Leki",1,"item(s)",20,null,null,0,null,null,null,0,{"$f":"M92/16","v":0}]
[null,null,"Insect netting (head)",1,"item(s)",1.5,null,null,1,null,null,null,1.5,9.375E-2]
[null,null,"Pouch-misc items",1,"item(s)",14,null,null,1,null,null,null,14,0.875]
[null,null,"Albuterol",0,"item(s)",1.5,null,null,1,null,null,null,0,0]
[null,null,"Advair",0,"item(s)",2,null,null,1,null,null,null,{"$f":"D96*F96*I96","v":0},{"$f":"M96/16","v":0}]
[null,null,"Maps, paper",1,"item(s)",5,null,null,1,null,null,null,5,0.3125]
[null,null,"Simple manual",0,"item(s)",1.5,"(included in maps, paper)",null,1,null,null,null,0,0]
[null,null,"Camera",0,"item(s)",6.5,null,null,1,null,null,null,0,0]
[null,null,"Phone with charger",1,"item(s)",12,null,null,1,null,null,null,12,0.75]
[null,null,"Battery pack",1,"item(s)",7,"(two if more than a week)",null,1,null,null,{"$f":"ROUNDUP(C2/7,0)","v":1},{"$f":"D101*F101*L101","v":7},{"$f":"M101/16","v":0.4375}]
[null,null,"Cards, check, cash, key",1,"item(s)",2,"(included in pouch)",null,1,null,null,null,2,0.125]
[null,null,"Batteries",0,"item(s)",4.5,null,null,1,null,null,null,0,{"$f":"M103/16","v":0}]
[null,null,"Watch",1,"item(s)",1,null,null,1,null,null,null,1,6.25E-2]
[null,null,"Plastic bags - storage, waterproofing",0,"item(s)",0.5,"(included in med sack, below)",null,1,null,null,null,0,0]
[]
[null,null,"H2O filter straw",1,"item(s)",2.5,null,null,1,null,null,null,{"$f":"D107*F107*I107","v":2.5},0.15625]
[null,null,"64 oz Platypus H2O bladder",0,"item(s)",6,null,null,1,null,null,null,{"$f":"D108*F108*I108","v":0},0]
[null,null,"32 oz Nalgene  H2O bottle",1,"item(s)",7,null,null,1,null,null,null,{"$f":"D109*F109*I109","v":7},0.4375]
[null,null,"32 oz Body Armor  H2O",1,"item(s)",2,null,null,1,null,null,null,{"$f":"D110*F110*I110","v":2},{"$f":"M110/16","v":0.125}]
[null,null,"Consider pre-prepped b'fast cont'r"]
[null,null,"H2O for platypus",0,"oz",1,64,null,1,null,null,null,{"$f":"D112*F112*G112*I112","v":0},0]
[null,null,"H2O for nalgene",0,"oz",1,32,null,1,null,null,null,{"$f":"D113*F113*G113*I113","v":0},0]
["Hiking, total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M73:M113)","v":137.5},8.59375]
[]
["Camping"]
[null,null,"Tent (Nemo, Elite 1p) + footprint",1,"items(s)",32,null,null,null,null,null,{"$f":"ABS(C6-2)","v":1},{"$f":"D117*F117*L117","v":32},{"$f":"M117/16","v":2},"(one person)"]
[null,null,"Tent (Sierra Designs, Flashlight)",0,"items(s)",78,null,null,null,null,null,{"$f":"ABS(C6-1)","v":0},{"$f":"D118*F118*L118/2","v":0},0,"(two people)"]
[null,null,"Bivvy",0,"items(s)",17,null,null,null,null,null,null,{"$f":"D119*F119","v":0},0]
[null,null,"Bivvy - OR",0,"items(s)",21,null,null,null,null,null,null,{"$f":"D120*F120","v":0},0]
[null,null,"Tarp 9'x9'",0,"items(s)",33,null,null,null,null,null,null,{"$f":"D121*F121","v":0},0]
[null,null,"Tarp 8'x6'",0,"items(s)",25,null,null,null,null,null,null,{"$f":"D122*F122","v":0},0]
[null,null,"Hyperlite tarp",0,"items(s)",20,null,null,null,null,null,null,{"$f":"D123*F123","v":0},{"$f":"M123/16","v":0}]
[null,null,"Ridge 10 stakes, lines 10 - 12', guys 4 -6'"]
[null,null,"Ground sheet (separate)",0,"items(s)",13,null,null,null,null,null,null,{"$f":"D125*F125","v":0},0]
[null,null,"Footprint - MSR"]
[null,null,"Sleeping bag, Western Mountaineering",1,"items(s)",18,null,null,null,null,null,null,{"$f":"D127*F127","v":18},{"$f":"M127/16","v":1.125}]
[null,null,"Sleeping bag, Marmot",0,"items(s)",34,null,null,null,null,null,null,0,{"$f":"M128/16","v":0}]
[null,null,"Sea to Summit Liner 'reactor'",0,"items(s)",11,null,null,null,null,null,null,{"$f":"D129*F129","v":0},{"$f":"M129/16","v":0}]
[null,null,"Sea to Summit Liner 'reactor - extreme'",0,"items(s)",15,null,null,null,null,null,null,{"$f":"D130*F130","v":0},{"$f":"M130/16","v":0}]
[null,null,"Ground pad",1,"items(s)",7.5,null,null,null,null,null,null,7.5,0.46875]
[null,null,"Rope, straps",0,"items(s)",3.5,"(included in med sack, below)",null,null,null,null,null,0,0]
[null,null,"Med sack",1,"items(s)",20,null,null,null,null,null,null,20,1.25]
[null,null,"Toilet with mouthwash, bug spray",1,"items(s)",10,"(3.5 oz without mouthwash and bug spray)",null,null,null,null,null,10,0.625]
["Camping, total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M117:M134)","v":87.5},5.46875]
[]
["Clothes","* summer, general",null,"Count",null,null,"1=take, 0=no",null,"include in pk wt, 0=no"]
[null,null,"Lite cap shirt*",1,"item(s)",5.5,0,null,1,null,null,null,{"$f":"D138*F138*G138*I138","v":0},{"$f":"M138/16","v":0}]
[null,null,"Lite silk shirt",1,"item(s)",3.5,1,null,1,null,null,null,{"$f":"D139*F139*G139*I139","v":3.5},{"$f":"M139/16","v":0.21875}]
[null,null,"Lite cap shirt, tee / long sleeve*",1,"item(s)",3.5,0,null,1,null,null,null,0,{"$f":"M140/16","v":0}]
[null,null,"Cap shirt, grey, hooded (OR)*",1,"item(s)",4.5,1,null,1,null,null,null,4.5,0.28125]
[null,null,"Cap shirt, naval blue, hooded (OR)*",1,"item(s)",4.5,0,null,1,null,null,null,{"$f":"D142*F142*G142*I142","v":0},{"$f":"M142/16","v":0}]
[null,null,"Arcteryx Lightweight Hoodie",1,"item(s)",11,1,null,1,null,null,null,{"$f":"D143*F143*G143*I143","v":11},{"$f":"M143/16","v":0.6875}]
[null,null,"Steel grey warm shirt*",1,"item(s)",10,0,null,1,null,null,null,0,0]
[null,null,"Mid wt cap z-neck",1,"item(s)",9,0,null,1,null,null,null,0,0]
[null,null,"Collared shirt / dress",1,"item(s)",8,0,null,1,null,null,null,0,0]
[null,null,"Blk wind wall jacket, N Face",1,"item(s)",26.5,0,null,1,null,null,null,0,0]
[null,null,"Blk lined jacket, N Face",1,"item(s)",18,0,null,1,null,null,null,0,0]
[null,null,"Red wind wall jacket, Marmot",1,"item(s)",23.5,0,null,1,null,null,null,0,0]
[null,null,"Rain jacket, Marmot*",1,"item(s)",12.25,0,null,1,null,null,null,0,0]
[null,null,"Rain jacket, Northace*",1,"item(s)",12,1,null,1,null,null,null,{"$f":"D151*F151*G151*I151","v":12},{"$f":"M151/16","v":0.75}]
[null,null,"Rain jacket, Columbia",1,"item(s)",18,0,null,1,null,null,null,0,0]
[null,null,"Down jacket, blue",1,"item(s)",24,0,null,1,null,null,null,0,{"$f":"M153/16","v":0}]
[null,null,"Dress jacket",1,"item(s)",26.5,0,null,1,null,null,null,0,0]
[null,null,"Gloves, lite",1,"item(s)",1,1,null,1,null,null,null,1,6.25E-2]
[null,null,"Sun-visor*",1,"item(s)",2,1,null,1,null,null,null,2,{"$f":"M156/16","v":0.125}]
[null,null,"Hat",1,"item(s)",5,0,null,1,null,null,null,0,0]
[null,null,"Lite cap long u'wear*",1,"item(s)",4,0,null,0,null,null,null,0,0]
[null,null,"Lite cap long u'wear, spare*",1,"item(s)",4,0,null,1,null,null,null,{"$f":"D159*F159*G159*I159","v":0},0]
[null,null,"Lite silk long u'wear*",1,"item(s)",4.5,1,null,1,null,null,null,4.5,{"$f":"M160/16","v":0.28125}]
[null,null,"Mid wt cap u'wear",1,"item(s)",8,0,null,1,null,null,null,{"$f":"D161*F161*G161*I161","v":0},0]
[null,null,"Short u'wear*",1,"item(s)",4,0,null,1,null,null,null,{"$f":"D162*F162*G162*I162","v":0},0]
[null,null,"Shorts*",1,"item(s)",10,0,null,1,null,null,null,{"$f":"D163*F163*G163*I163","v":0},{"$f":"M163/16","v":0}]
[null,null,"Shorts (swim)*",1,"item(s)",7,1,null,1,null,null,null,7,0.4375]
[null,null,"Hiking pants*",1,"item(s)",15,0,null,1,null,null,null,0,0]
[null,null,"Belt*",1,"item(s)",2,0,null,0,null,null,null,0,0]
[null,null,"Jeans",1,"item(s)",24,0,null,1,null,null,null,0,0]
[null,null,"Rain pants Northface*",1,"item(s)",9,0,null,1,null,null,null,0,0]
[null,null,"Heavy socks*",2,"item(s)",4.5,1,null,1,null,null,null,{"$f":"D169*F169*G169*I169","v":9},0.5625]
[null,null,"Intermediate sox",1,"item(s)",3,0,null,1,null,null,null,{"$f":"D170*F170*G170*I170","v":0},0]
[null,null,"Lite sox*",1,"item(s)",2,0,null,1,null,null,null,0,0]
[null,null,"Bandana*",1,"item(s)",1.5,1,null,1,null,null,null,1.5,9.375E-2]
[null,null,"MSR Towel*",1,"item(s)",2,0,null,1,null,null,null,0,0]
[null,null,"Spade",1,"item(s)",3,1,null,1,null,null,null,{"$f":"D174*F174*G174*I174","v":3},{"$f":"M174/16","v":0.1875}]
[null,null,"Stuff sacks with straps and liners (2)*",1,"item(s)",5,1,null,1,null,null,null,5,0.3125]
[null,null,"… sack liner*",1,"item(s)",1,0,"incl above",1,null,null,null,0,0]
[null,null,"… sack straps*",1,"item(s)",1,0,"incl above",1,null,null,null,0,0]
["Clothes, total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M138:M177)","v":64},4]
[]
["Total pack",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M48+M70+M114+M135+M178","v":305.35000000000002},{"$f":"M180/16","v":19.084375000000001}]
[]
["Total with food, fuel, and bear vault",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M180+'Food and fuel-backpacking'!Q92","v":554.09749999999997},{"$f":"M182/16","v":34.631093749999998}]
["Total with food, fuel, and bear vault",null,null,null,null,null,null,null,null,null,"Rounded",null,{"$f":"ROUNDUP(M182,0)","v":555},{"$f":"ROUNDUP(N182,0)","v":35}]

{"sheet":"Needs","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"ultralight backpacking, minimize all gear and supplies"]
[]
[null,"replenish toilet-spices-pens-paper-batteries, garbage bag for wet items, powdered tomatoes, lite cook-sack, instant coffee"]
[]
[null,"head-lamp, fire, lite air mattress, mosquito net, sandals only, Gore-Tex boots, flip phone, shorten tooth brush"]
[]
[null,"skills—expedition planning, wilderness apps"]

{"sheet":"Nutrition for hiking","index":6,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Nutrient needs—protein, carbs, fats, vitamins, minerals, roughage, and water"]
[null,null,null,"Also see nutrition:",null,"diet and exercise.xlsm"]
[]
[null,null,null,"Hydration"]
[null,null,null,"¾ liters of water before hiking; ¼ liter frequently during; and 1 – 2 liters after"]
[]
[null,null,null,"Vitamins and meds",null,null,"Meds sheet"]
[null,null,null,"With supper (to save morning time) or breakfast"]
[]
[null,null,null,"Meals"]
[null,null,null,null,"Breakfast","(the higher figures are for 4000 cal / day)"]
[null,null,null,null,null,"About 500 - 800 cal; some protein, low fat and fiber"]
[null,null,null,null,null,"On a rest day, eat less calories, more fiber"]
[null,null,null,null,null,"Protein and collagen supplements"]
[]
[null,null,null,null,"Trail"]
[null,null,null,null,null," About 180 - 270 cal (45 - 67 g) per hour - 1440 cal for 6 hours of hiking"]
[null,null,null,null,"While hiking, 70% carbs, 30% protein and fat"]
[null,null,null,null,"Eat grains and legumes regularly, in small amounts for energy and muscle rebuilding"]
[null,null,null,null,"Replenish electrolytes—salty snacks, salt tabs, electrolyte drinks / supplements"]
[]
[null,null,null,null,"Supper"]
[null,null,null,null,"Eat 30 – 45 minutes after hiking—when the body is receptive to replenishment"]
[null,null,null,null,null," Higher fat content than breakfast and trail - for digestive ease and sleeping warmth"]
[null,null,null,null,null," Aim for 500 - 1600 cal (2500 - 4000 cal / day)"]
[null,null,null,null,null," Backpacker.com recommends - carb:protein = 4:1"]
[]
[null,null,null,null,"Before sleep"]
[null,null,null,null,"Dessert of not too concentrated sugar and fluids with the evening meal"]
[null,null,null,null,"Examples: fruit bars, energy nuggets, granola …"]
[null,null,null,null,"Sugar free alternative to dessert—nuts, sesame sticks …"]

{"sheet":"Meds","index":7,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Emergency meds for a week"]
[null,null,null,"Allergy 1 week"]
[null,null,null,null,"Benadryl 25 mg, 14 tabs"]
[null,null,null,null,"Allegra 180 mg, 7 tabs"]
[null,null,null,"Pain management"]
[null,null,null,null,"Tylenol 500 mg, 42 tabs"]
[null,null,null,null,null,"1000 mg TID"]
[null,null,null,null,"Ibuprofen 200 mg, 42 tabs"]
[null,null,null,null,null,"400 mg TID"]
[]
[null,null,"Meds and vitamins for a week - consider spares to allow trip extension"]
[null,null,null,"Vitamins and meds – all 1 tab a day"]
[null,null,null,"Glucosamine, Multi"]
[null,null,null,"A, B, B12, D, E,"]
[null,null,null,"Fish oil"]
[null,null,null,"Losartan 100 mg"]
[null,null,null,"Ibuprofen 200 mg, up to 4 tabs a day"]
[]
[null,null,"Vitamins for a short trip"]
[null,null,null,"Glucosamine - 1 a day"]
[null,null,null,"Multivitamines - 2 a day"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"G"]

{"sheet":"Health","index":8,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Nutrition"]
[null,null,null,"Quality","fluids early, whole grains, legumes, fresh vegetables and some fruit, leafy greens (especially cabbage) for calcium"]
[null,null,null,null,"olive oil, occasional fish, eggs, and infrequent lean meats, roughage, herbs, spices, supplements"]
[null,null,null,null,"Eliminate or minimize"]
[null,null,null,null,"added sugar, added salt, over processed foods (read labels, allow occasional white rice), alcohol"]
[null,null,null,null,"most animal fat and oils (except olive), dairy (except non-fat), coffee, excess snacking and eating out"]
[]
[null,null,null,"Amount","No excess; experiment with portions, minimize snacks and eating out",null,null,null,null,null,null,"Fast—whole day or till evening—Sat"]
[]
[null,null,null,"Routine","begin the day with food before coffee, eat lunch and small evening snack early"]
[]
[null,null,"Exercise"]
[null,null,null,"aerobic—walk and bike",null,null,"hiit","plyometrics"]
[null,null,null,"flexibility—stretch",null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,"weights"]
[null,null,null,"self-defense"]
[]
[null,null,"Sleep plan"]
[null,null,null,"Aim - 7 to eight hours a night"]
[null,null,null,null,"Allow more to ensure 7 - 8 hours; more for restorative sleep"]
[null,null,null,null,"When sleep is regular, may allow 7 hours"]
[null,null,null,null,"Experiment with (i) amount (ii) time (iii) multiple sleep periods"]
[null,null,null,null,"Sleep and rise early, aim for the same time every day, e.g.,  7pm ro 2am"]
[]
[null,null,"Medical"]
[null,null,null,"Meds",null,"Reduce losartan if bp < 120 / 80; consider beta-blocker; consider synthroid; consider other hormone"]
[null,null,null,"Appointment",null,"Moles, feet, joint-bone-muscle health, mental health evaluation"]
[null,null,null,"Cancer",null,"cancers.html"]