Trend Function

I want to create formula that shows optimistic, most likely, and pessimistic. What type a formula would this be?

The data is 5 categories over 3 years.

I tried using this template but I couldn't figure out to play with the data and categories
http://office.microsoft.com/en-us/te...104035491.aspx

Anyone have any insight?