BUFFALO RIVER EXCEL SPREAD SHEET -Updated Sep 22 2009

Recreational and touring boaters
Post Reply
       
User avatar
Richard
.....
.....
Posts: 1428
Joined: Sat Jul 02, 2005 8:41 am
Location: Conway, AR

BUFFALO RIVER EXCEL SPREAD SHEET -Updated Sep 22 2009

Post by Richard » Fri Sep 04, 2009 10:23 am

Buffalo River 97-2000.xls
BUFFALO RIVER UPDATED SEP 22 2009 11AM
(126 KiB) Downloaded 120 times
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.
Last edited by Richard on Tue Sep 22, 2009 11:10 am, edited 10 times in total.
We are all afflicted with Cognitive Dissonance. The greater our religious, social, financial or political affiliation, the greater the affliction. We hear what we want to hear. We believe what we want to believe. Truth becomes irrelevant.

User avatar
GutIt
...
...
Posts: 306
Joined: Sun Jul 24, 2005 8:59 pm
Name: Terry P.
Location: Sprangfield, MO

Re: BUFFALO RIVER EXCEL SPREAD SHEET

Post by GutIt » Fri Sep 04, 2009 4:56 pm

Very cool, Richard.

At first glance I can see you have put a lot of thought and effort into this thing. And it looks good, too. Thank you for sharing it with us.

It now resides in my River Beta Master Folder in the Buffalo sub folder. Played with it a little I am liking it. Everything you really need on one spread. And I'm not really much of an Excel guy. But my Lovely & Charming is. I can see now why you needed it to be posted as an Excel file.

Thank you again, Richard.

Very cool indeed.
Keep Your Stick in the Water!
-Terry-

RespiratoryMan
.
.
Posts: 41
Joined: Wed Aug 20, 2008 10:00 pm
Location: Jonesboro

Re: BUFFALO RIVER EXCEL SPREAD SHEET

Post by RespiratoryMan » Sat Sep 05, 2009 11:19 am

Yes, I like it!
Good Job Richard!
Brett
Bell Alaskan (green)

OldBlueHoleDude
.
.
Posts: 17
Joined: Wed Apr 25, 2007 10:35 pm
Name: Don Stephens
Location: Hot Springs

Re: BUFFALO RIVER EXCEL SPREAD SHEET

Post by OldBlueHoleDude » Wed Sep 09, 2009 10:16 pm

Richard,

Evidently you are using a newer version of Excel & Vista operating system.

What are the chances of you opening your spreadsheet and saving it as Excel 2000??? I have office 2000 on my pc with XP operating system.

Would love to have your spreadsheet!!

User avatar
Richard
.....
.....
Posts: 1428
Joined: Sat Jul 02, 2005 8:41 am
Location: Conway, AR

Post by Richard » Thu Sep 10, 2009 1:54 am

******
Last edited by Richard on Wed Sep 16, 2009 12:16 pm, edited 1 time in total.
We are all afflicted with Cognitive Dissonance. The greater our religious, social, financial or political affiliation, the greater the affliction. We hear what we want to hear. We believe what we want to believe. Truth becomes irrelevant.

User avatar
GutIt
...
...
Posts: 306
Joined: Sun Jul 24, 2005 8:59 pm
Name: Terry P.
Location: Sprangfield, MO

Re: BUFFALO RIVER EXCEL SPREAD SHEET

Post by GutIt » Thu Sep 10, 2009 3:32 pm

A friend of mine told me he downloaded a compatibility pack from Microsoft. Free.

I think there are of couple of these since 2000. Try Microsoft's website. This buddy of mine had trouble with my 2007 files.

Just a theory!
Keep Your Stick in the Water!
-Terry-

User avatar
martinm
.
.
Posts: 41
Joined: Mon Jul 28, 2008 6:21 am
Name: martin

Re: BUFFALO RIVER EXCEL SPREAD SHEET

Post by martinm » Sun Sep 13, 2009 1:24 pm

Thank you Richard, very nice. Now I won't have to hunt down my Ozark Society Buffalo River guide.

Much appreciated!

Martin

User avatar
dai479
.
.
Posts: 21
Joined: Sun May 17, 2009 8:12 pm

Re: BUFFALO RIVER EXCEL SPREAD SHEET -Updated Sep 16 2009

Post by dai479 » Wed Sep 16, 2009 9:17 pm

That is awesome! Thanks!! :clap:

Post Reply

Social Media

       

Who is online

Users browsing this forum: No registered users and 0 guests