Calculator in Excel

Thanks John!!!!!

Govind

Just out of curiosity, what is the formula for?

I've seen similar power series e.g to calculate oxygen solubility in water as function of temperature (though yours is clearly something different) which gives reasonable figures over about 5 - 30°C, but soon goes wildly out beyond that range. But a formula in the form A/(B + T) is equally accurate, simpler, less risk of getting a decimal point wrong in a coefficient, and works over a much bigger range.

Codey

Sorry Codey!!!! the formula is to calculate Specific Heat of Stainless Steel. I missed your first sentence earlier.

OK, from a quick check on Wiki, it looks like the theoretical formula for specific heat, which has Ø_a³ in it (assuming Ø_a is temperature). So I can't suggest any alternative.

Codey

You don't need the brackets, and more elegant using ^ for the powers, giving

=450+0.28*A1-0.000291*A1^2+0.000000134*A1^3

Codey

All agreed. Given that the OP didn't seem to have much of a clue^[1], I did it in the way that I though was the clearest & least prone to errors.

[1] No offence intended, Govind.

OK fair point, I think Govind needs a bit of practice, that's all

Codey

How about finding the most elegant in terms of machine efficiency (i.e. calculations performed)?

I used to use this form (when it mattered, e.g. assembler on a Z80):

=((0.000000134*A1-0.000291)*A1+0.28)*A1+450

You bet Codey!!!! I am 65yrs old and need quite a bit of practice to catch upon you

What do you mean by OP John?

OP is 'internet forum code' for Original Poster or Original Post, i.e. whoever started the thread or what they wrote in their first post, whichever applies in the context.

Dear John,

Just a wild thought, over the years, there has been a steady decline of the wonderful language of English with the advent of electronic medium. I am appalled to see the SMS language used by the youngsters be they in India or Britain. We as youngsters, were proud to read Shakespeare, Bernard Shaw and Kipling. It was said that, we Indians were second to Britons in usage of the English. Now, I believe, the British children are unaware of the hard cover red book of 'Wren & Martin', not that Indian children are better!!!. Don't we think that some sort of a movement should be started to save this Classic language?

Govind