I am doing some simple trend forecasting. I will have to change the range of the known_x's and known-y's often. And, I'll have to do this in a number of spreadsheets forecasting different trends.
Being lazy, I don't want to manually change the range in each trend formula. I want to type "First" and "Last" in a column indicating where the range of the known_x's and known_y's in each trend formula is to start and end.
I uploaded a simple spreadsheet that better illustrates what I'm working with. It is at http://www.rogert.us/Trend.xls.
Any help will be appreciated. Thanks
Being lazy, I don't want to manually change the range in each trend formula. I want to type "First" and "Last" in a column indicating where the range of the known_x's and known_y's in each trend formula is to start and end.
I uploaded a simple spreadsheet that better illustrates what I'm working with. It is at http://www.rogert.us/Trend.xls.
Any help will be appreciated. Thanks