When i finally put together my tree survey form i will need to be able to calculate the total value of 3 fields to give a final result which will be the risk factor for the tree surveyed (FAILURE SCORE X TARGET SCORE X IMPACT SCORE). I would also need to then auto populate another field giving priority for works. The higher the risk value given the quicker the works have to be done. Could any tell me how to code this. the 3values are multiplied to give a risk factor
4000+ 7??? Extreme Evacuate/prevent access to impact site, emergency call???out of contractors
2001???3999 6??? Serious Close site if practical; arrange for work to be completed within 7 days
1000???2000 5??? Significant Arrange for work to be completed within four weeks maximum
330???999 4??? Moderate Remediate within 13 weeks, reinspect after SWE meantime (inc. gales to Force 7+)
160???329 3??? Slight Reinspect annually /after storms (Force 10+), expect to schedule work within 2 yrs
50???159 2??? Minimal Reinspect within 3 yrs if public access, schedule work as required
0???49 1??? Insignificant Reinspect within 5 yrs if general public access or 3 yrs if child???specific access & TS ???20
If anyone could help it would be highly useful to me as i have no idea what i am doing.
(Data taken from Julian Forbes Laird web site and is open source 2010)
Nick Burke
