--- In

hammockcamping@yahoogroups.com, Bill Fornshell

<bfornshell@y...> wrote:

> Hi Ray, For those of us out here that use a Mac

> computer and can not open an Excel spreadsheet, is

> there a way to make something that a Mac can open?

I can create older versions of the sheet for excel, lotus and

quattro pro. Also, there is a program available that will import

excel spreadsheets into appleworks, but since you don't have it,,,

the spreadsheet is easy to make. Here's how:

1. Create an (input parameter) cell (over a bit ~row f) for your x

distance. This is your distance between the ends of the chain.

2. Create an (input parameter) cell for your sag distance. This is

the amount of sag you want in the middle of the chain.

3. Create a calculated cell to hold a (y value scaling factor).

The formula is of the form: (sag distance) / (cosh(.5)-1) Note:

cosh is the Excel name for the hyperbolic cosine function.

4. Create a column (e.g. column A) with values from -50 to 50.

These are your unscaled x values

5. Create a column next to the unscaled x values for your scaled x

values. The formula is of the form: (unscaled x value) / 100 * (x

distance) Replicate the formula for the entire column

6. Create a column next to the scaled X values for your scaled Y

values. The formula is of the form: (y scale factor)*cosh (x/100) -

(y scale factor) Replicate the formula for the entire column.

Note: the x value is from the unscaled x column (e.g. column A).

If you have a graph generating tool, just make an x,y scatter graph

using your scaled x and y values.