Thanks. 2 more things if I may.
1. As I do not have a scientific calculator with the ^ key I ran the programme tonight and at the end was warned against running it as there is no valid signature against which it can be verified. I found this surprising. I'd have thought that a signature would have bee added as such warnings must put potential users of which is not in the interests of Open Office.
Can you comment on this? Should I be concerned?
2. My maths ended many years ago and I may not be able to follow whatever explanation you care to give but is it possible to give me a little background to how the numbers such as 2148.484 and -1.872 were arrived at? I am presuming that that these numbers are only applicable to Xtol and Fuji Acros.
Many thanks
pentaxuser
If you're on a computer, the built in calculator program should have a scientific mode. Look for a key with an 'x' with a superscript 'y' and it will do the exponential function identically to '^'. Unfortunately most forum software won't format mathematical expressions well.
With regard to question #1:
I haven't seen openoffice throw a 'signature' warning in linux. That sounds like it might be your OS. Are you running a Microsoft or Apple OS? I haven't run Windows in years and never ran an Apple OS, so I can't help you much with those kinds of warnings. Unfortunately Windows allows applications and even things like spreadsheets so much operating system privilege that it has to watch for trojans, viruses, and worms embedded in things like spreadsheets, and so will get frightened and throw warnings if it doesn't see a 'signature' that says 'no virus here' in WindowsSpeak. Can't help you with Microsoft stuff, or most of Apple, even though OS-X is a custom version of BSD Unix, which is operationally very close to linux, but Apple uses a locked-down custom graphical interface and other proprietary modifications for hardware, etc.
I found the exponent and coefficients through fitting against a general formula of the form y=a*x^b, which provides an excellent fit for this particular data. I do this with openoffice and a 'trend line' from clicking on a data point or line in a graph of the data and choosing the form of equation to use for fitting a line. You can choose whether or not to show the equation for the fit and a number for the quality of the fit.
The other program I use for this is SciDAVis, and the data taken from manufacturers' technical publications. SciDAVis is "Scientific Data Analysis and Visualization", and is open source and GPL license (free to use, modify, and redistribute as long as you give back modifications to the public and provide your modified source code), and is available for Windows, Mac, and linux. You can find it with google and download it. SciDAVis is fundamentally a spreadsheet into which you enter your data, then test the fit and find parameters for the variables using built-in or user-defined mathematical formulae. Doing that is called regression analysis. (My last math class was first semester calculus at university in 1973.)
And yes, you're correct that these numbers apply specifically to the combination of Xtol and Acros.
Lee