
First things first: Thanks for posting this Ralph. I'm sure a number of people will find it very useful, as will I after figuring out the syntax error.
As for the results opening an excel spreadsheet in openoffice, it's an equation syntax problem.

Error: 502
Invalid argument
Function argument is not valid, for example, a negative number for the root function.

It can be done in openoffice, just not with excel's exact syntax. I'm not a spreadsheet matrix wiz, but the attachment will show that just by right clicking on a data point in the graphs and choosing to insert either a log or exponential (appropriated to the case) trendline, openoffice will give the same curves as Ralph's sheet. I inserted curves for both the proposed and adjusted data, equations matching the line color.
I may have some time to explore the matrix math syntax, but I'll have to learn it for excel (which I haven't used for about 5 years) and then learn to make the necessary changes for correct openoffice syntax. One of the reasons I quit using excel is evident in Ralph's post including two versions of the spreadsheet for two versions of excel. If I get to this (I'm currently rather busy with a number of other projects), I'll report back to this thread. Just be assured that openoffice is capable of this with correct syntax, and that purchasing excel is optional, as is learning how to use either excel or openoffice to their full capacities.
Lee
Last edited by Lee L; 01032011 at 11:10 PM. Click to view previous post history.