Spreadsheet: 141878d1329493804-2nd-order-poly-trendline-using-equation-dash-board-charts-sample
Sheet: Linear Forecast

Month | Total Parts Bookings for Month | Month #
2007-03-01 00:00:00 |  | 1
2007-04-01 00:00:00 |  | 2
2007-05-01 00:00:00 |  | 3
2007-06-01 00:00:00 |  | 4
2007-07-01 00:00:00 |  | 5
2007-08-01 00:00:00 |  | 6
2007-09-01 00:00:00 |  | 7
2007-10-01 00:00:00 |  | 8
2007-11-01 00:00:00 |  | 9
2007-12-01 00:00:00 |  | 10
2008-01-01 00:00:00 |  | 11
2008-02-01 00:00:00 |  | 12
2008-03-01 00:00:00 |  | 13
2008-04-01 00:00:00 |  | 14
2008-05-01 00:00:00 |  | 15
2008-06-01 00:00:00 |  | 16
2008-07-01 00:00:00 |  | 17
2008-08-01 00:00:00 |  | 18
2008-09-01 00:00:00 |  | 19
2008-10-01 00:00:00 |  | 20
2008-11-01 00:00:00 |  | 21
2008-12-01 00:00:00 |  | 22
2009-01-01 00:00:00 |  | 23
2009-02-01 00:00:00 |  | 24
2009-03-01 00:00:00 |  | 25
2009-04-01 00:00:00 |  | 26
2009-05-01 00:00:00 |  | 27
2009-06-01 00:00:00 |  | 28
2009-07-01 00:00:00 |  | 29
2009-08-01 00:00:00 |  | 30
2009-09-01 00:00:00 |  | 31
2009-10-01 00:00:00 |  | 32
2009-11-01 00:00:00 |  | 33
2009-12-01 00:00:00 |  | 34
2010-01-01 00:00:00 |  | 35
2010-02-01 00:00:00 |  | 36
2010-03-01 00:00:00 |  | 37
2010-04-01 00:00:00 |  | 38
2010-05-01 00:00:00 |  | 39
2010-06-01 00:00:00 |  | 40
2010-07-01 00:00:00 |  | 41
2010-08-01 00:00:00 |  | 42
2010-09-01 00:00:00 |  | 43
2010-10-01 00:00:00 |  | 44
2010-11-01 00:00:00 |  | 45
2010-12-01 00:00:00 |  | 46
2011-01-01 00:00:00 |  | 47
2011-02-01 00:00:00 |  | 48
2011-03-01 00:00:00 |  | 49
2011-04-01 00:00:00 |  | 50
2011-05-01 00:00:00 |  | 51
2011-06-01 00:00:00 |  | 52
2011-07-01 00:00:00 |  | 53
2011-08-01 00:00:00 |  | 54
2011-09-01 00:00:00 |  | 55
2011-10-01 00:00:00 |  | 56
2011-11-01 00:00:00 |  | 57
2011-12-01 00:00:00 |  | 58
2012-01-01 00:00:00 |  | 59
Projections Begin Under Line Above |  |  | Projected Dollar Increase Month to Month | Projected Percentage Increase Month to Month | Year End Totals
2012-02-01 00:00:00 |  | 60
2012-03-01 00:00:00 |  | 61
2012-04-01 00:00:00 |  | 62
2012-05-01 00:00:00 |  | 63
2012-06-01 00:00:00 |  | 64
2012-07-01 00:00:00 |  | 65
2012-08-01 00:00:00 |  | 66
2012-09-01 00:00:00 |  | 67
2012-10-01 00:00:00 |  | 68
2012-11-01 00:00:00 |  | 69
2012-12-01 00:00:00 |  | 70
2013-01-01 00:00:00 |  | 71
2013-02-01 00:00:00 |  | 72
2013-03-01 00:00:00 |  | 73
2013-04-01 00:00:00 |  | 74
2013-05-01 00:00:00 |  | 75
2013-06-01 00:00:00 |  | 76
2013-07-01 00:00:00 |  | 77
2013-08-01 00:00:00 |  | 78
2013-09-01 00:00:00 |  | 79
2013-10-01 00:00:00 |  | 80
2013-11-01 00:00:00 |  | 81
2013-12-01 00:00:00 |  | 82
2014-01-01 00:00:00 |  | 83
2014-02-01 00:00:00 |  | 84
2014-03-01 00:00:00 |  | 85
2014-04-01 00:00:00 |  | 86
2014-05-01 00:00:00 |  | 87
2014-06-01 00:00:00 |  | 88
2014-07-01 00:00:00 |  | 89
2014-08-01 00:00:00 |  | 90
2014-09-01 00:00:00 |  | 91
2014-10-01 00:00:00 |  | 92
2014-11-01 00:00:00 |  | 93
2014-12-01 00:00:00 |  | 94
2015-01-01 00:00:00 |  | 95
2015-02-01 00:00:00 |  | 96
2015-03-01 00:00:00 |  | 97
2015-04-01 00:00:00 |  | 98
2015-05-01 00:00:00 |  | 99
2015-06-01 00:00:00 |  | 100
2015-07-01 00:00:00 |  | 101
2015-08-01 00:00:00 |  | 102
2015-09-01 00:00:00 |  | 103
2015-10-01 00:00:00 |  | 104
2015-11-01 00:00:00 |  | 105
2015-12-01 00:00:00 |  | 106
2016-01-01 00:00:00 |  | 107