====== EXCEL Projections====== ==== Description ==== The TREND function in Excel calculates values along a linear trend. It fits a straight line to the given data, and based on that line, calculates future (or unknown) values based on new specified x-values. It is useful for predicting future values based on historical data. \\ **Specific number of previous observations** Number of years in the historical series to be observed.. **Initial Projection Year ** Initial Projection Year. ** Final Projection Year ** Final Projection Year. ** Initial Historical Series Year ** Initial Historical Series Year. ** Final Historical Series Year ** Final Historical Series Year. ** Input Table Key ** Name of the key column in the historical series table. **Historical Series Entry Table** Historical Series Entry Table. \\ === Outputs=== Table with predictions.