Hi!
Fire Weather Index project still eat all of my time with its formula orgy!
Things became more concrete with a validation spreadsheet I've created
with Environment Canada Official documentation. More than 20,000 lines
of table contents has been entered to have a clear portrait about what numbers
supposed to be the thruth!
Source documentation (included) is an explanation guide for Official weather
observers who maintained a daily weather diary on paper, 9 tables was the
reference to establish all Canadian FWI indexes, "in the field".
So, I include in this post, a result of past weeks work on
Smockey Bear project!
This MsExcel spreadsheet need some informations to be entered on sheet
Diary- Cell D3: Month number (eg. 8 for august)
- Identification line to identify your station/location
- At line #10, starting numbers for DC / DMC / FFMC has to be find from official sites (or guessed??)
- For daily observations are mandatory:
- Dry bulb temperature
- Humidity
- Wind speed
- Rain last 24h
+ These are optional (for now)
- Wet bulb temperature
- Wind Direction
All "beige" cells will calculate automaticly!
So, now, I'll be able to verify Smokey's numbers!
,,, to be followed!
Regards,
Jacques