I am trying to bring a calculation that works out the risk of Grass fires.

The original equation is as follows:

=2*EXP(-23.6+5.01*LN(B45+0.001)+0.0281*B42-0.266*SQRT(B43)+0.633*SQRT(B44))

where B45 is Curing (how dry the grass is)

B44 is Wind Speed

B43 is Relative Humitity of the air

and B42 is Temperature.

The calculation I got was:

2*Exp(-23.6+(5.01*Ln(Curing)+.001)+(.0281*Temperature)-.266*Sqrt(Relative Humidity+.633*Sqrt(Wind Speed)))

The results are all wrong. What is my mistake?

Captain Peter Baxter

The order of operations appears to be quite different in your second calc compared to your first. Should it be like this:

2 *

( Exp

( -23.6 +

( 5.01 * Ln ( Curing + 0.001 ) +

( 0.0281 * Temperature ) -

( 0.266 * Sqrt ( Relative Humidity ) +

( 0.633 * Sqrt ( Wind Speed ) )

)