Spreadsheet: 219118d1362670672-producing-a-table-of-monthly-values-based-on-a-monthly-growth-rate-and-yearly-total-xlf-example-for-mister-excel
Sheet: My data

Year | $ billion Nominal |  |  | Monthl | % Change each month
2000 | 311.58 |  |  | 2000-01-01 00:00:00 |  | 25.847
2001 | 321.22 |  |  | 2000-02-01 00:00:00
2002 | 370.78 |  |  | 2000-03-01 00:00:00
2003 | 425.94 |  |  | 2000-04-01 00:00:00
2004 | 482.7 |  |  | 2000-05-01 00:00:00
2005 | 529.88 |  |  | 2000-06-01 00:00:00
2006 | 551.33 |  |  | 2000-07-01 00:00:00
2007 | 579.75 |  |  | 2000-08-01 00:00:00
2008 | 644.9300000000001 |  |  | 2000-09-01 00:00:00
2009 | 698.5799999999999 |  |  | 2000-10-01 00:00:00
2010 | 738.7800000000001 |  |  | 2000-11-01 00:00:00
2011 | 751.31 |  |  | 2000-12-01 00:00:00 |  |  |  | SUM
2012 | 772.55 |  |  | 2001-01-01 00:00:00 |  | 26.648
2013 | 761.3299999999999 |  |  | 2001-02-01 00:00:00
2014 | 653.05 |  |  | 2001-03-01 00:00:00
2015 | 624.1000000000001 |  |  | 2001-04-01 00:00:00
2016 | 628.7299999999999 |  |  | 2001-05-01 00:00:00
2017 | 639.8800000000001 |  |  | 2001-06-01 00:00:00
 |  |  |  | 2001-07-01 00:00:00
 |  |  |  | 2001-08-01 00:00:00
 |  |  |  | 2001-09-01 00:00:00
 |  |  |  | 2001-10-01 00:00:00
 |  |  |  | 2001-11-01 00:00:00
 |  |  |  | 2001-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2002-01-01 00:00:00
 |  |  |  | 2002-02-01 00:00:00
 |  |  |  | 2002-03-01 00:00:00
 |  |  |  | 2002-04-01 00:00:00
 |  |  |  | 2002-05-01 00:00:00
 |  |  |  | 2002-06-01 00:00:00
 |  |  |  | 2002-07-01 00:00:00
 |  |  |  | 2002-08-01 00:00:00
 |  |  |  | 2002-09-01 00:00:00
 |  |  |  | 2002-10-01 00:00:00
 |  |  |  | 2002-11-01 00:00:00
 |  |  |  | 2002-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2003-01-01 00:00:00
 |  |  |  | 2003-02-01 00:00:00
 |  |  |  | 2003-03-01 00:00:00
 |  |  |  | 2003-04-01 00:00:00
 |  |  |  | 2003-05-01 00:00:00
 |  |  |  | 2003-06-01 00:00:00
 |  |  |  | 2003-07-01 00:00:00
 |  |  |  | 2003-08-01 00:00:00
 |  |  |  | 2003-09-01 00:00:00
 |  |  |  | 2003-10-01 00:00:00
 |  |  |  | 2003-11-01 00:00:00
 |  |  |  | 2003-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2004-01-01 00:00:00
 |  |  |  | 2004-02-01 00:00:00
 |  |  |  | 2004-03-01 00:00:00
 |  |  |  | 2004-04-01 00:00:00
 |  |  |  | 2004-05-01 00:00:00
 |  |  |  | 2004-06-01 00:00:00
 |  |  |  | 2004-07-01 00:00:00
 |  |  |  | 2004-08-01 00:00:00
 |  |  |  | 2004-09-01 00:00:00
 |  |  |  | 2004-10-01 00:00:00
 |  |  |  | 2004-11-01 00:00:00
 |  |  |  | 2004-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2005-01-01 00:00:00
 |  |  |  | 2005-02-01 00:00:00
 |  |  |  | 2005-03-01 00:00:00
 |  |  |  | 2005-04-01 00:00:00
 |  |  |  | 2005-05-01 00:00:00
 |  |  |  | 2005-06-01 00:00:00
 |  |  |  | 2005-07-01 00:00:00
 |  |  |  | 2005-08-01 00:00:00
 |  |  |  | 2005-09-01 00:00:00
 |  |  |  | 2005-10-01 00:00:00
 |  |  |  | 2005-11-01 00:00:00
 |  |  |  | 2005-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2006-01-01 00:00:00
 |  |  |  | 2006-02-01 00:00:00
 |  |  |  | 2006-03-01 00:00:00
 |  |  |  | 2006-04-01 00:00:00
 |  |  |  | 2006-05-01 00:00:00
 |  |  |  | 2006-06-01 00:00:00
 |  |  |  | 2006-07-01 00:00:00
 |  |  |  | 2006-08-01 00:00:00
 |  |  |  | 2006-09-01 00:00:00
 |  |  |  | 2006-10-01 00:00:00
 |  |  |  | 2006-11-01 00:00:00
 |  |  |  | 2006-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2007-01-01 00:00:00
 |  |  |  | 2007-02-01 00:00:00
 |  |  |  | 2007-03-01 00:00:00
 |  |  |  | 2007-04-01 00:00:00
 |  |  |  | 2007-05-01 00:00:00
 |  |  |  | 2007-06-01 00:00:00
 |  |  |  | 2007-07-01 00:00:00
 |  |  |  | 2007-08-01 00:00:00
 |  |  |  | 2007-09-01 00:00:00
 |  |  |  | 2007-10-01 00:00:00
 |  |  |  | 2007-11-01 00:00:00
 |  |  |  | 2007-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2008-01-01 00:00:00
 |  |  |  | 2008-02-01 00:00:00
 |  |  |  | 2008-03-01 00:00:00
 |  |  |  | 2008-04-01 00:00:00
 |  |  |  | 2008-05-01 00:00:00
 |  |  |  | 2008-06-01 00:00:00
 |  |  |  | 2008-07-01 00:00:00
 |  |  |  | 2008-08-01 00:00:00
 |  |  |  | 2008-09-01 00:00:00
 |  |  |  | 2008-10-01 00:00:00
 |  |  |  | 2008-11-01 00:00:00
 |  |  |  | 2008-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2009-01-01 00:00:00
 |  |  |  | 2009-02-01 00:00:00
 |  |  |  | 2009-03-01 00:00:00
 |  |  |  | 2009-04-01 00:00:00
 |  |  |  | 2009-05-01 00:00:00
 |  |  |  | 2009-06-01 00:00:00
 |  |  |  | 2009-07-01 00:00:00
 |  |  |  | 2009-08-01 00:00:00
 |  |  |  | 2009-09-01 00:00:00
 |  |  |  | 2009-10-01 00:00:00
 |  |  |  | 2009-11-01 00:00:00
 |  |  |  | 2009-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2010-01-01 00:00:00
 |  |  |  | 2010-02-01 00:00:00
 |  |  |  | 2010-03-01 00:00:00
 |  |  |  | 2010-04-01 00:00:00
 |  |  |  | 2010-05-01 00:00:00
 |  |  |  | 2010-06-01 00:00:00
 |  |  |  | 2010-07-01 00:00:00
 |  |  |  | 2010-08-01 00:00:00
 |  |  |  | 2010-09-01 00:00:00
 |  |  |  | 2010-10-01 00:00:00
 |  |  |  | 2010-11-01 00:00:00
 |  |  |  | 2010-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2011-01-01 00:00:00
 |  |  |  | 2011-02-01 00:00:00
 |  |  |  | 2011-03-01 00:00:00
 |  |  |  | 2011-04-01 00:00:00
 |  |  |  | 2011-05-01 00:00:00
 |  |  |  | 2011-06-01 00:00:00
 |  |  |  | 2011-07-01 00:00:00
 |  |  |  | 2011-08-01 00:00:00
 |  |  |  | 2011-09-01 00:00:00
 |  |  |  | 2011-10-01 00:00:00
 |  |  |  | 2011-11-01 00:00:00
 |  |  |  | 2011-12-01 00:00:00 |  |  |  | SUM
 |  |  |  | 2012-01-01 00:00:00
 |  |  |  | 2012-02-01 00:00:00
 |  |  |  | 2012-03-01 00:00:00
 |  |  |  | 2012-04-01 00:00:00
 |  |  |  | 2012-05-01 00:00:00
 |  |  |  | 2012-06-01 00:00:00
 |  |  |  | 2012-07-01 00:00:00
 |  |  |  | 2012-08-01 00:00:00
 |  |  |  | 2012-09-01 00:00:00
 |  |  |  | 2012-10-01 00:00:00
 |  |  |  | 2012-11-01 00:00:00
 |  |  |  | 2012-12-01 00:00:00 |  |  |  | SUM