For some reason, I can't shake my head around this to build a simple spreadsheet where one just needs to enter the temperature and wind speed where:
Windchill Temperature = 0.045(5.2735SQROOT(W) + 10.45 - 0.2778W)(T - 33.0)+33 WCF = 1.1626(5.2735SQROOT(W) + 10.45 - 0.2778W)(33.0 - T)
ET = equivalent temperature (degrees Celsius)
WCF = wind chill factor (Watts per square metre)
SQROOT = square root function
W = wind speed (Km/hr)
T = air temperature (degrees Celsius)
Any help is greatly appreciated! Thank you.