BUFFALO RIVER EXCEL SPREAD SHEET -Updated Sep 22 2009
Posted: Fri Sep 04, 2009 10:23 am
Thank you Terry (GutIt) for showing me how to do this.
This is a work in progress spread sheet for the Buffalo River.
There are three sheets. I may add more later on.
Mileage - The Yellow CELLS with Blue lettering at the top are linked to the gages and other info.
Click on the desired CELL to access the described link.
In the Light Blue column, under the heading "Trip Miles", you can place a zero in the Cell next to where you plan to put on the Buffalo. It will then recalculate all points below that one. So if you were putting on at Woolum you would enter a zero next to Woolum. If you were taking out at Baker Ford, it would tell you how far you would travel from Woolum to Baker Ford. A word of Caution! Don't save the worksheet. To change the Cell value back to where it was copy the cell above to the changed cell.
Hyperlinks & Phone - The Hyperlinks are redundant to the ones contained at the top of "Mileage" page. I will be adding some in the future. Phone numbers are for the most part NPS numbers
Campgrounds - Is taken from "Currents" and expanded to include unpublished campgrounds. I will add White River campgrounds later
If you have suggestions, let me know and I may incorporated them.
This is a work in progress spread sheet for the Buffalo River.
There are three sheets. I may add more later on.
Mileage - The Yellow CELLS with Blue lettering at the top are linked to the gages and other info.
Click on the desired CELL to access the described link.
In the Light Blue column, under the heading "Trip Miles", you can place a zero in the Cell next to where you plan to put on the Buffalo. It will then recalculate all points below that one. So if you were putting on at Woolum you would enter a zero next to Woolum. If you were taking out at Baker Ford, it would tell you how far you would travel from Woolum to Baker Ford. A word of Caution! Don't save the worksheet. To change the Cell value back to where it was copy the cell above to the changed cell.
Hyperlinks & Phone - The Hyperlinks are redundant to the ones contained at the top of "Mileage" page. I will be adding some in the future. Phone numbers are for the most part NPS numbers
Campgrounds - Is taken from "Currents" and expanded to include unpublished campgrounds. I will add White River campgrounds later
If you have suggestions, let me know and I may incorporated them.
