Interactive Canister Gas Estimation Spreadsheet
I've pose together something that I promise volition live useful. It's an Excel spreadsheet that yous tin customize to stand upward for your detail stove as well as your detail situation. You tin purpose Google Sheets if yous don't select Excel on your device.
This spreadsheet should move for conventional stoves (e.g. Pocket Rocket, GigaPower, Crux, etc.) equally good equally high efficiency stoves (e.g. Jetboil). The download link will live downwards at the bottom of this post, afterwards the explanations
Enter Your Numbers
So, it's relatively straightforward. You, based on your needs as well as your experience, larn inward iv numbers into the spreadsheet equally listed, below. I'll become through some examples afterwards the listing to hopefully assist yous empathise how this works. It's pretty simple, really.
This spreadsheet should move for conventional stoves (e.g. Pocket Rocket, GigaPower, Crux, etc.) equally good equally high efficiency stoves (e.g. Jetboil). The download link will live downwards at the bottom of this post, afterwards the explanations
 |
| Headed out for a week? Nice! Uh, how much fuel produce yous need? Purple Lake, John Muir Wilderness, Sierra National Forest, Sierra Nevada, California. |
So, it's relatively straightforward. You, based on your needs as well as your experience, larn inward iv numbers into the spreadsheet equally listed, below. I'll become through some examples afterwards the listing to hopefully assist yous empathise how this works. It's pretty simple, really.
- The release of cups (about 250 ml per loving cup for those of yous who prefer metric) of H2O yous excogitation to boil per day, on average.
- The release of grams of fuel your detail stove burns to boil i loving cup of water. If yous don't know, I recommend that yous purpose 4 g for conventional stoves as well as 3 g for high efficiency stoves (like a Jetboil) until yous larn a improve thought of what your stove requires. You powerfulness add together a gram (i.e. 5 g as well as 4 g, respectively) for H2O temperatures around 5 C/40 F or lower. Double the gauge (i.e. 8 g as well as half dozen g) if you're melting snow.
- The length of your trip (number of days).
- Your margin for error. This is variety of a "fudge factor". You add together a fleck to a greater extent than extra gas inward instance it's windy or mayhap yous but underestimated how much H2O you'd demand to boil. As yous make to a greater extent than experience, yous tin dial this back.
Remember, all iv of these numbers are nether your total control. You laid the parameter, as well as the spreadsheet volition tell yous what size canister it thinks yous should bring. Note that I select the next canister sizes programmed into the spreadsheet: 100, 110, 220, 230, as well as 450 grams.
 |
| Isn't this a smashing spot? Say, nosotros did convey plenty fuel to select dinner tonight, didn't we? Duck Lake, John Muir Wilderness, Sierra National Forest, Sierra Nevada, California. |
Example 1.
In this example, I'm going to become out for 5 days. See the chart, below. I'm going out alongside a partner. Say, on average, that we both boil most 5 cups per twenty-four lx minutes menstruum as well as that nosotros select a conventional stove like, say, a Pocket Rocket. We're going to larn inward all the numbers that clit our trip as well as our needs inward the gray shaded cells. The spreadsheet volition as well as thus recommend inward the yellow shaded prison theatre mobile telephone what size of canister at a minimum that yous should convey based on the parameters that you've entered.
Let's become through the example:
Line 1. If nosotros both boil 5 cups each, as well as thus we'd boil a total of 10 cups per day, on average. Enter the release 10 on job i inward column "B" inward the gray, shaded surface area on job 1.
Line 2. Since nosotros select a conventional stove, we'll purpose "4" equally the release of grams nosotros await to dismiss per loving cup on job 2. Now, this assumes that yous know the Basics of Stove Fuel Economy. If you're non familiar alongside how to larn expert fuel economic scheme alongside a backpacking stove, I advise that yous read through the Basics of Stove Fuel Economy.
Line 3. Next, let's larn inward as well as thus release of days our trip volition be. I said five, but I'm going to larn inward but 4.5. Why? Well, I'm planning to larn out on the terminal twenty-four lx minutes menstruum good earlier supper time. Really, the terminal twenty-four lx minutes menstruum is exclusively going to live a one-half day, thus I'm adjusting the amount of fuel I cry back I'll demand past times dropping the length of the trip past times 1/2 a day.
Line 4. Do not touch job four. Remember, exclusively larn inward numbers into the greyish shaded cells.
Line 5. Now, Line 5 is your "fudge factor," your security margin. We are NOT going to gauge the release of grams nosotros cry back we'll demand as well as cutting it off just there. No, we're going to add together but a fleck to a greater extent than inward instance something goes incorrect or we're off somewhere. Now, if yous actually know your stove, your usage, as well as the Basics of Stove Fuel Economy, as well as thus select at it. Cut the margin downwards to zip if yous like. It's your spreadsheet i time yous download it, but I'm going to recommend a 10% security margin until yous know differently.
Based on our gauge that we, on average, volition boil 10 cups of H2O per twenty-four lx minutes menstruum (line 1) as well as that alongside our conventional stove volition demand 4 g of fuel per loving cup boiled (line 2) as well as that our upcoming trip volition live 4.5 days long (line 3) as well as that nosotros desire a 10% margin for mistake (line 5), the spreadsheet determines (line 6) that yous demand 198 g of fuel. The spreadsheet then, inward job 7, tells yous what minimum canister size yous should convey inward lodge to select that 198 g of fuel. In this instance the spreadsheet recommends that yous convey at to the lowest degree a 220 g sized fuel canister.
Now, detect job 8. This is the amount of fuel nosotros volition select over our estimated need. We demand 198 g but our canister holds 220 g which agency nosotros select 22 g of fuel inward excess of our estimated need.
The spreadsheet as well as thus tells yous (line 9) most how many extra cups that excess fuel volition laissez passer on yous if yous demand it.
Lastly, the spreadsheet tell yous how many additional cups yous could boil per twenty-four lx minutes menstruum based on this excess fuel (line 10).
Why powerfulness yous desire to know how many additional cups per twenty-four lx minutes menstruum yous select the capability to boil? Well, one-half way through our terminal trip, someone gave us some java they weren't going to use. Suddenly, nosotros had plenty java to select non i but 2 cups of java each morning. But produce nosotros select plenty gas? Hopefully, alongside job 10 of the spreadsheet, you'll know if yous select the gas for that 2nd loving cup of coffee.
Example 2.
Let's become through the example:
Line 1. If nosotros both boil 5 cups each, as well as thus we'd boil a total of 10 cups per day, on average. Enter the release 10 on job i inward column "B" inward the gray, shaded surface area on job 1.
Line 2. Since nosotros select a conventional stove, we'll purpose "4" equally the release of grams nosotros await to dismiss per loving cup on job 2. Now, this assumes that yous know the Basics of Stove Fuel Economy. If you're non familiar alongside how to larn expert fuel economic scheme alongside a backpacking stove, I advise that yous read through the Basics of Stove Fuel Economy.
Line 3. Next, let's larn inward as well as thus release of days our trip volition be. I said five, but I'm going to larn inward but 4.5. Why? Well, I'm planning to larn out on the terminal twenty-four lx minutes menstruum good earlier supper time. Really, the terminal twenty-four lx minutes menstruum is exclusively going to live a one-half day, thus I'm adjusting the amount of fuel I cry back I'll demand past times dropping the length of the trip past times 1/2 a day.
Line 4. Do not touch job four. Remember, exclusively larn inward numbers into the greyish shaded cells.
Line 5. Now, Line 5 is your "fudge factor," your security margin. We are NOT going to gauge the release of grams nosotros cry back we'll demand as well as cutting it off just there. No, we're going to add together but a fleck to a greater extent than inward instance something goes incorrect or we're off somewhere. Now, if yous actually know your stove, your usage, as well as the Basics of Stove Fuel Economy, as well as thus select at it. Cut the margin downwards to zip if yous like. It's your spreadsheet i time yous download it, but I'm going to recommend a 10% security margin until yous know differently.
Now, detect job 8. This is the amount of fuel nosotros volition select over our estimated need. We demand 198 g but our canister holds 220 g which agency nosotros select 22 g of fuel inward excess of our estimated need.
The spreadsheet as well as thus tells yous (line 9) most how many extra cups that excess fuel volition laissez passer on yous if yous demand it.
Lastly, the spreadsheet tell yous how many additional cups yous could boil per twenty-four lx minutes menstruum based on this excess fuel (line 10).
Why powerfulness yous desire to know how many additional cups per twenty-four lx minutes menstruum yous select the capability to boil? Well, one-half way through our terminal trip, someone gave us some java they weren't going to use. Suddenly, nosotros had plenty java to select non i but 2 cups of java each morning. But produce nosotros select plenty gas? Hopefully, alongside job 10 of the spreadsheet, you'll know if yous select the gas for that 2nd loving cup of coffee.
 |
| Let's see, it's 3 to a greater extent than days until nosotros re-supply. You did convey plenty gas for 3 to a greater extent than days, right? The Silver Divide, John Muir Wilderness, Sierra National Forest, Sierra Nevada, California. |
In this example, I'm going to become out for 3 days. See the chart, below. Again, I'm going out alongside a partner. Again, let's say, on average, that we both boil most 5 cups per day, but this fourth dimension we're going to live sharing a Jetboil type stove.
Let's become through the example:
Line 1. If nosotros boil 5 cups each per day, as well as thus we'd larn inward "10" on job i inward column "B" inward the gray, shaded area.
Line 2. Since nosotros select a Jetboil stove, we'll purpose "3" equally the release of grams nosotros await to dismiss per cup, on job 2.
Line 3. Next, let's assume our trip lasts a total 3 days. Therefore, I larn inward "3" on job 3.
Line 4. Do not comport on job four. Remember, exclusively larn inward numbers into the greyish shaded cells.
Line 5. Let's but stick alongside 10% equally our security margin.
Now, on job 6, our baseline estimate + our margin for mistake comes to a total of 99 g. The spreadsheet therefor inward job vii recommends that yous purchase a 100 g canister. Is that cutting it also close? Probably not. Remember, that we've already got a 10% margin for mistake inward there. However, 110 g canisters are typically but equally inexpensive equally 100 g canisters. I personally would but larn the 110 g canister but thus I select a slightly larger margin for error, but each to his or her own.
But detect job 8. You exclusively select 1 g inward this illustration of "excess" fuel. Just i gram. In other words, if someone gives yous java or something, yous may non select the gas to boil H2O for it. This is important! I wouldn't desire to consume a mutual depression temperature backpacking dinner inward the eve because I had burned upward all my fuel on a 2nd loving cup of java inward the morning. If I don't select the gas to produce something, as well as thus I desire to know, inward advance. This estimation spreadsheet gives yous an thought of how much slack yous produce – or produce non – have.
Conclusion
Thanks for bearing alongside me through all the explanations. I promise I was reasonably clear. If it wasn't clear, delight purpose the comments section, below, to inquire questions. There are no dumb questions. If it's non clear, ask.
Now, the link. You tin download the Excel spreadsheet using Google Docs. If yous don't select Excel on your device, yous tin opened upward the spreadsheet alongside the Google Sheets app.
Please allow me know inward the comments, below, if yous select whatsoever problems alongside the link or the spreadsheet.
Thanks for joining me,
HJ
Let's become through the example:
Line 1. If nosotros boil 5 cups each per day, as well as thus we'd larn inward "10" on job i inward column "B" inward the gray, shaded area.
Line 2. Since nosotros select a Jetboil stove, we'll purpose "3" equally the release of grams nosotros await to dismiss per cup, on job 2.
Line 3. Next, let's assume our trip lasts a total 3 days. Therefore, I larn inward "3" on job 3.
Line 4. Do not comport on job four. Remember, exclusively larn inward numbers into the greyish shaded cells.
Line 5. Let's but stick alongside 10% equally our security margin.
Now, on job 6, our baseline estimate + our margin for mistake comes to a total of 99 g. The spreadsheet therefor inward job vii recommends that yous purchase a 100 g canister. Is that cutting it also close? Probably not. Remember, that we've already got a 10% margin for mistake inward there. However, 110 g canisters are typically but equally inexpensive equally 100 g canisters. I personally would but larn the 110 g canister but thus I select a slightly larger margin for error, but each to his or her own.
But detect job 8. You exclusively select 1 g inward this illustration of "excess" fuel. Just i gram. In other words, if someone gives yous java or something, yous may non select the gas to boil H2O for it. This is important! I wouldn't desire to consume a mutual depression temperature backpacking dinner inward the eve because I had burned upward all my fuel on a 2nd loving cup of java inward the morning. If I don't select the gas to produce something, as well as thus I desire to know, inward advance. This estimation spreadsheet gives yous an thought of how much slack yous produce – or produce non – have.
Conclusion
Thanks for bearing alongside me through all the explanations. I promise I was reasonably clear. If it wasn't clear, delight purpose the comments section, below, to inquire questions. There are no dumb questions. If it's non clear, ask.
Now, the link. You tin download the Excel spreadsheet using Google Docs. If yous don't select Excel on your device, yous tin opened upward the spreadsheet alongside the Google Sheets app.
Please allow me know inward the comments, below, if yous select whatsoever problems alongside the link or the spreadsheet.
Thanks for joining me,
HJ
 |
| The writer at Sallie Keys Lakes on the John Muir Trail. You're danged correct I had plenty gas! |
0 Response to "Interactive Canister Gas Estimation Spreadsheet"
Posting Komentar