{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover","Navigator","Style Guide","Original Data","Method 1 - Using TREND","Method 2 - Using TREND + CAGR","Method 3 - Using FORECAST.ETS","Raw Data from FORECAST.ETS","Model Parameters","Error Checks"],"not_rendered":{"charts":5,"images":1,"macros":1,"external_links":0,"defined_names":35,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"ICAEW"}]
[null,null,{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Comparing forecasting objectively using TREND and cyclical growth rates with the Forecast Sheet functionality."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,{"$f":"Overall_Error_Check","v":0}]
[]
[]
[null,1,"Table of Contents"]
[]
[null,null,null,null,null,"Cover"]
[null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,"Original Data"]
[null,null,null,null,null,"Method 1 - Using TREND"]
[null,null,null,null,null,"Method 2 - Using TREND + CAGR"]
[null,null,null,null,null,"Method 3 - Using FORECAST.ETS"]
[null,null,null,null,null,"Raw Data from FORECAST.ETS"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"Error Checks"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[16,2,16,6],[2,0,2,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Formatting of Headers / Dividers"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Sheet Title",null,null,null,null,null,{"$f":"C10","v":"Sheet Title"},null,"Sheet Title"]
[null,null,"Model Name",null,null,null,null,null,{"$f":"C11","v":"Model Name"},null,"Model Name"]
[]
[null,null,"Header 1",null,null,null,null,null,{"$f":"C13","v":"Header 1"},null,"Header 1"]
[null,null,"Header 2",null,null,null,null,null,{"$f":"C14","v":"Header 2"},null,"Header 2"]
[null,null,"Header 3",null,null,null,null,null,{"$f":"C15","v":"Header 3"},null,"Header 3"]
[null,null,"Header 4",null,null,null,null,null,{"$f":"C16","v":"Header 4"},null,"Header 4"]
[]
[null,null,"Notes",null,null,null,null,null,{"$f":"C18","v":"Notes"},null,"Notes"]
[]
[null,null,"Table Heading",null,null,null,null,null,{"$f":"C20","v":"Table Heading"},null,"Table Heading"]
[]
[]
[null,{"$f":"MAX($B$5:$B22)+1","v":2},"Individual Cell Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Assumption",null,null,null,null,null,"Assumption",null,{"$f":"C27","v":"Assumption"}]
[]
[null,null,"Constraint",null,null,null,null,null,{"$f":"C29","v":"Constraint"},null,{"$f":"C29","v":"Constraint"}]
[]
[null,null,"Empty",null,null,null,null,null,null,null,{"$f":"C31","v":"Empty"}]
[]
[null,null,"Error Check",null,null,null,null,null,0,null,{"$f":"C33","v":"Error Check"}]
[]
[null,null,"Hyperlink",null,null,null,null,null,"Hyperlink",null,{"$f":"C35","v":"Hyperlink"}]
[]
[null,null,"Internal Reference",null,null,null,null,null,{"$f":"'Error Checks'!E12","v":"No checks in this model"},null,{"$f":"C37","v":"Internal Reference"}]
[]
[null,null,"Line Calculation",null,null,null,null,null,77,null,"Line Calc"]
[]
[null,null,"Line Total",null,null,null,null,null,{"$f":"I39","v":77},null,{"$f":"C41","v":"Line Total"}]
[]
[null,null,"Parameter",null,null,null,null,null,365,null,{"$f":"C43","v":"Parameter"}]
[]
[null,null,"Range Name Description",null,null,null,null,null,"Not_Named",null,{"$f":"C45","v":"Range Name Description"}]
[]
[null,null,"Row Reference",null,null,null,null,null,{"$f":"ROW(C47)","v":47},null,"Row Ref"]
[]
[null,null,"Row Summary",null,null,null,null,null,{"$f":"I41","v":77},null,{"$f":"C49","v":"Row Summary"}]
[]
[null,null,"Units",null,null,null,null,null,"A$",null,{"$f":"C51","v":"Units"}]
[]
[null,null,"WIP",null,null,null,null,null,null,null,{"$f":"C53","v":"WIP"}]
[]
[]
[null,{"$f":"MAX($B$5:$B55)+1","v":3},"Numerical Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Comma",null,null,null,null,null,123456.789,null,{"$f":"C60","v":"Comma"}]
[]
[null,null,"Comma [0]",null,null,null,null,null,-123456.789,null,"Comma [0]"]
[]
[null,null,"Currency",null,null,null,null,null,123456.789,null,"Currency"]
[]
[null,null,"Currency [0]",null,null,null,null,null,123456.789,null,"Currency [0]"]
[]
[null,null,"Date",null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-07"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-07"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Original Data","index":3,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Original Data"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Historical Information"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[]
[null,null,null,null,null,"Date","Sales"]
[null,null,null,null,null,"2012-09-30",2644539]
[null,null,null,null,null,{"$f":"EOMONTH(F13,1)","v":"2012-10-31"},2359800]
[null,null,null,null,null,{"$f":"EOMONTH(F14,1)","v":"2012-11-30"},2925918]
[null,null,null,null,null,"2012-12-31",3024973]
[null,null,null,null,null,"2013-01-31",3177100]
[null,null,null,null,null,"2013-02-28",3419595]
[null,null,null,null,null,"2013-03-31",3649702]
[null,null,null,null,null,"2013-04-30",3650668]
[null,null,null,null,null,"2013-05-31",3191526]
[null,null,null,null,null,"2013-06-30",3249428]
[null,null,null,null,null,"2013-07-31",2971484]
[null,null,null,null,null,"2013-08-31",3074209]
[null,null,null,null,null,"2013-09-30",2785466]
[null,null,null,null,null,"2013-10-31",2515361]
[null,null,null,null,null,"2013-11-30",3105958]
[null,null,null,null,null,"2013-12-31",3139059]
[null,null,null,null,null,"2014-01-31",3380355]
[null,null,null,null,null,"2014-02-28",3612886]
[null,null,null,null,null,"2014-03-31",3765824]
[null,null,null,null,null,"2014-04-30",3771842]
[null,null,null,null,null,"2014-05-31",3356365]
[null,null,null,null,null,"2014-06-30",3490100]
[null,null,null,null,null,"2014-07-31",3163659]
[null,null,null,null,null,"2014-08-31",3167124]
[null,null,null,null,null,"2014-09-30",2883810]
[null,null,null,null,null,"2014-10-31",2610667]
[null,null,null,null,null,"2014-11-30",3129205]
[null,null,null,null,null,"2014-12-31",3200527]
[null,null,null,null,null,"2015-01-31",3547804]
[null,null,null,null,null,"2015-02-28",3766323]
[null,null,null,null,null,"2015-03-31",3935589]
[null,null,null,null,null,"2015-04-30",3917884]
[null,null,null,null,null,"2015-05-31",3564970]
[null,null,null,null,null,"2015-06-30",3602455]
[null,null,null,null,null,"2015-07-31",3326859]
[null,null,null,null,null,"2015-08-31",3441693]
[null,null,null,null,null,"2015-09-30",3211600]
[null,null,null,null,null,"2015-10-31",2998119]
[null,null,null,null,null,"2015-11-30",3472440]
[null,null,null,null,null,"2015-12-31",3563007]
[null,null,null,null,null,"2016-01-31",3820570]
[null,null,null,null,null,"2016-02-29",4107195]
[null,null,null,null,null,"2016-03-31",4284443]
[null,null,null,null,null,"2016-04-30",4356216]
[null,null,null,null,null,"2016-05-31",3819379]
[null,null,null,null,null,"2016-06-30",3844987]
[null,null,null,null,null,"2016-07-31",3478890]
[null,null,null,null,null,"2016-08-31",3443039]
[null,null,null,null,null,"2016-09-30",3204637]
[null,null,null,null,null,"2016-10-31",2966477]
[null,null,null,null,null,"2016-11-30",3593364]
[null,null,null,null,null,{"$f":"EOMONTH(F63,1)","v":"2016-12-31"},3604104]
[null,null,null,null,null,"2017-01-31",3933016]
[null,null,null,null,null,"2017-02-28",4146797]
[null,null,null,null,null,"2017-03-31",4176486]
[null,null,null,null,null,"2017-04-30",4347059]
[null,null,null,null,null,"2017-05-31",3781168]
[null,null,null,null,null,"2017-06-30",3858196.3569040108]
[null,null,null,null,null,"2017-07-31",3562679.8147925721]
[null,null,null,null,null,"2017-08-31"]
[null,null,null,null,null,"2017-09-30"]
[null,null,null,null,null,"2017-10-31"]
[null,null,null,null,null,"2017-11-30"]
[null,null,null,null,null,"2017-12-31"]
[null,null,null,null,null,"2018-01-31"]
[null,null,null,null,null,"2018-02-28"]
[null,null,null,null,null,{"$f":"EOMONTH(F78,1)","v":"2018-03-31"}]
[null,null,null,null,null,"2018-04-30"]
[null,null,null,null,null,"2018-05-31"]
[null,null,null,null,null,"2018-06-30"]
[null,null,null,null,null,"2018-07-31"]
[null,null,null,null,null,"2018-08-31"]
[null,null,null,null,null,"2018-09-30"]
[null,null,null,null,null,"2018-10-31"]
[null,null,null,null,null,"2018-11-30"]
[null,null,null,null,null,"2018-12-31"]
[null,null,null,null,null,"2019-01-31"]
[null,null,null,null,null,"2019-02-28"]
[null,null,null,null,null,"2019-03-31"]
[null,null,null,null,null,"2019-04-30"]
[null,null,null,null,null,"2019-05-31"]
[null,null,null,null,null,"2019-06-30"]
[null,null,null,null,null,"2019-07-31"]
[null,null,null,null,null,"2019-08-31"]
[null,null,null,null,null,"2019-09-30"]
[null,null,null,null,null,"2019-10-31"]
[null,null,null,null,null,"2019-11-30"]
[null,null,null,null,null,"2019-12-31"]
[null,null,null,null,null,"2020-01-31"]
[null,null,null,null,null,"2020-02-29"]
[null,null,null,null,null,"2020-03-31"]
[null,null,null,null,null,"2020-04-30"]
[null,null,null,null,null,"2020-05-31"]
[null,null,null,null,null,"2020-06-30"]
[null,null,null,null,null,"2020-07-31"]
[null,null,null,null,null,"2020-08-31"]
[null,null,null,null,null,"2020-09-30"]
[null,null,null,null,null,"2020-10-31"]
[null,null,null,null,null,"2020-11-30"]
[null,null,null,null,null,"2020-12-31"]

{"sheet":"Method 1 - Using TREND","index":4,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Method 1 - Using TREND"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Historical Information"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[]
[null,null,null,null,null,"Date","Sales","TREND","Combined"]
[null,null,null,null,null,{"$f":"IF('Original Data'!F13=\"\",\"\",'Original Data'!F13)","v":"2012-09-30"},{"$f":"IF('Original Data'!G13=\"\",\"\",'Original Data'!G13)","v":2644539},null,{"$f":"N(G13)+N(H13)","v":2644539}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F14=\"\",\"\",'Original Data'!F14)","v":"2012-10-31"},{"$f":"IF('Original Data'!G14=\"\",\"\",'Original Data'!G14)","v":2359800},null,{"$f":"N(G14)+N(H14)","v":2359800}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F15=\"\",\"\",'Original Data'!F15)","v":"2012-11-30"},{"$f":"IF('Original Data'!G15=\"\",\"\",'Original Data'!G15)","v":2925918},null,2925918]
[null,null,null,null,null,{"$f":"IF('Original Data'!F16=\"\",\"\",'Original Data'!F16)","v":"2012-12-31"},{"$f":"IF('Original Data'!G16=\"\",\"\",'Original Data'!G16)","v":3024973},null,3024973]
[null,null,null,null,null,{"$f":"IF('Original Data'!F17=\"\",\"\",'Original Data'!F17)","v":"2013-01-31"},{"$f":"IF('Original Data'!G17=\"\",\"\",'Original Data'!G17)","v":3177100},null,3177100]
[null,null,null,null,null,{"$f":"IF('Original Data'!F18=\"\",\"\",'Original Data'!F18)","v":"2013-02-28"},{"$f":"IF('Original Data'!G18=\"\",\"\",'Original Data'!G18)","v":3419595},null,3419595]
[null,null,null,null,null,{"$f":"IF('Original Data'!F19=\"\",\"\",'Original Data'!F19)","v":"2013-03-31"},{"$f":"IF('Original Data'!G19=\"\",\"\",'Original Data'!G19)","v":3649702},null,3649702]
[null,null,null,null,null,{"$f":"IF('Original Data'!F20=\"\",\"\",'Original Data'!F20)","v":"2013-04-30"},{"$f":"IF('Original Data'!G20=\"\",\"\",'Original Data'!G20)","v":3650668},null,3650668]
[null,null,null,null,null,{"$f":"IF('Original Data'!F21=\"\",\"\",'Original Data'!F21)","v":"2013-05-31"},{"$f":"IF('Original Data'!G21=\"\",\"\",'Original Data'!G21)","v":3191526},null,3191526]
[null,null,null,null,null,{"$f":"IF('Original Data'!F22=\"\",\"\",'Original Data'!F22)","v":"2013-06-30"},{"$f":"IF('Original Data'!G22=\"\",\"\",'Original Data'!G22)","v":3249428},null,3249428]
[null,null,null,null,null,{"$f":"IF('Original Data'!F23=\"\",\"\",'Original Data'!F23)","v":"2013-07-31"},{"$f":"IF('Original Data'!G23=\"\",\"\",'Original Data'!G23)","v":2971484},null,2971484]
[null,null,null,null,null,{"$f":"IF('Original Data'!F24=\"\",\"\",'Original Data'!F24)","v":"2013-08-31"},{"$f":"IF('Original Data'!G24=\"\",\"\",'Original Data'!G24)","v":3074209},null,3074209]
[null,null,null,null,null,{"$f":"IF('Original Data'!F25=\"\",\"\",'Original Data'!F25)","v":"2013-09-30"},{"$f":"IF('Original Data'!G25=\"\",\"\",'Original Data'!G25)","v":2785466},null,2785466]
[null,null,null,null,null,{"$f":"IF('Original Data'!F26=\"\",\"\",'Original Data'!F26)","v":"2013-10-31"},{"$f":"IF('Original Data'!G26=\"\",\"\",'Original Data'!G26)","v":2515361},null,2515361]
[null,null,null,null,null,{"$f":"IF('Original Data'!F27=\"\",\"\",'Original Data'!F27)","v":"2013-11-30"},{"$f":"IF('Original Data'!G27=\"\",\"\",'Original Data'!G27)","v":3105958},null,3105958]
[null,null,null,null,null,{"$f":"IF('Original Data'!F28=\"\",\"\",'Original Data'!F28)","v":"2013-12-31"},{"$f":"IF('Original Data'!G28=\"\",\"\",'Original Data'!G28)","v":3139059},null,3139059]
[null,null,null,null,null,{"$f":"IF('Original Data'!F29=\"\",\"\",'Original Data'!F29)","v":"2014-01-31"},{"$f":"IF('Original Data'!G29=\"\",\"\",'Original Data'!G29)","v":3380355},null,3380355]
[null,null,null,null,null,{"$f":"IF('Original Data'!F30=\"\",\"\",'Original Data'!F30)","v":"2014-02-28"},{"$f":"IF('Original Data'!G30=\"\",\"\",'Original Data'!G30)","v":3612886},null,3612886]
[null,null,null,null,null,{"$f":"IF('Original Data'!F31=\"\",\"\",'Original Data'!F31)","v":"2014-03-31"},{"$f":"IF('Original Data'!G31=\"\",\"\",'Original Data'!G31)","v":3765824},null,3765824]
[null,null,null,null,null,{"$f":"IF('Original Data'!F32=\"\",\"\",'Original Data'!F32)","v":"2014-04-30"},{"$f":"IF('Original Data'!G32=\"\",\"\",'Original Data'!G32)","v":3771842},null,3771842]
[null,null,null,null,null,{"$f":"IF('Original Data'!F33=\"\",\"\",'Original Data'!F33)","v":"2014-05-31"},{"$f":"IF('Original Data'!G33=\"\",\"\",'Original Data'!G33)","v":3356365},null,3356365]
[null,null,null,null,null,{"$f":"IF('Original Data'!F34=\"\",\"\",'Original Data'!F34)","v":"2014-06-30"},{"$f":"IF('Original Data'!G34=\"\",\"\",'Original Data'!G34)","v":3490100},null,3490100]
[null,null,null,null,null,{"$f":"IF('Original Data'!F35=\"\",\"\",'Original Data'!F35)","v":"2014-07-31"},{"$f":"IF('Original Data'!G35=\"\",\"\",'Original Data'!G35)","v":3163659},null,3163659]
[null,null,null,null,null,{"$f":"IF('Original Data'!F36=\"\",\"\",'Original Data'!F36)","v":"2014-08-31"},{"$f":"IF('Original Data'!G36=\"\",\"\",'Original Data'!G36)","v":3167124},null,3167124]
[null,null,null,null,null,{"$f":"IF('Original Data'!F37=\"\",\"\",'Original Data'!F37)","v":"2014-09-30"},{"$f":"IF('Original Data'!G37=\"\",\"\",'Original Data'!G37)","v":2883810},null,2883810]
[null,null,null,null,null,{"$f":"IF('Original Data'!F38=\"\",\"\",'Original Data'!F38)","v":"2014-10-31"},{"$f":"IF('Original Data'!G38=\"\",\"\",'Original Data'!G38)","v":2610667},null,2610667]
[null,null,null,null,null,{"$f":"IF('Original Data'!F39=\"\",\"\",'Original Data'!F39)","v":"2014-11-30"},{"$f":"IF('Original Data'!G39=\"\",\"\",'Original Data'!G39)","v":3129205},null,3129205]
[null,null,null,null,null,{"$f":"IF('Original Data'!F40=\"\",\"\",'Original Data'!F40)","v":"2014-12-31"},{"$f":"IF('Original Data'!G40=\"\",\"\",'Original Data'!G40)","v":3200527},null,3200527]
[null,null,null,null,null,{"$f":"IF('Original Data'!F41=\"\",\"\",'Original Data'!F41)","v":"2015-01-31"},{"$f":"IF('Original Data'!G41=\"\",\"\",'Original Data'!G41)","v":3547804},null,3547804]
[null,null,null,null,null,{"$f":"IF('Original Data'!F42=\"\",\"\",'Original Data'!F42)","v":"2015-02-28"},{"$f":"IF('Original Data'!G42=\"\",\"\",'Original Data'!G42)","v":3766323},null,3766323]
[null,null,null,null,null,{"$f":"IF('Original Data'!F43=\"\",\"\",'Original Data'!F43)","v":"2015-03-31"},{"$f":"IF('Original Data'!G43=\"\",\"\",'Original Data'!G43)","v":3935589},null,3935589]
[null,null,null,null,null,{"$f":"IF('Original Data'!F44=\"\",\"\",'Original Data'!F44)","v":"2015-04-30"},{"$f":"IF('Original Data'!G44=\"\",\"\",'Original Data'!G44)","v":3917884},null,3917884]
[null,null,null,null,null,{"$f":"IF('Original Data'!F45=\"\",\"\",'Original Data'!F45)","v":"2015-05-31"},{"$f":"IF('Original Data'!G45=\"\",\"\",'Original Data'!G45)","v":3564970},null,3564970]
[null,null,null,null,null,{"$f":"IF('Original Data'!F46=\"\",\"\",'Original Data'!F46)","v":"2015-06-30"},{"$f":"IF('Original Data'!G46=\"\",\"\",'Original Data'!G46)","v":3602455},null,3602455]
[null,null,null,null,null,{"$f":"IF('Original Data'!F47=\"\",\"\",'Original Data'!F47)","v":"2015-07-31"},{"$f":"IF('Original Data'!G47=\"\",\"\",'Original Data'!G47)","v":3326859},null,3326859]
[null,null,null,null,null,{"$f":"IF('Original Data'!F48=\"\",\"\",'Original Data'!F48)","v":"2015-08-31"},{"$f":"IF('Original Data'!G48=\"\",\"\",'Original Data'!G48)","v":3441693},null,3441693]
[null,null,null,null,null,{"$f":"IF('Original Data'!F49=\"\",\"\",'Original Data'!F49)","v":"2015-09-30"},{"$f":"IF('Original Data'!G49=\"\",\"\",'Original Data'!G49)","v":3211600},null,3211600]
[null,null,null,null,null,{"$f":"IF('Original Data'!F50=\"\",\"\",'Original Data'!F50)","v":"2015-10-31"},{"$f":"IF('Original Data'!G50=\"\",\"\",'Original Data'!G50)","v":2998119},null,2998119]
[null,null,null,null,null,{"$f":"IF('Original Data'!F51=\"\",\"\",'Original Data'!F51)","v":"2015-11-30"},{"$f":"IF('Original Data'!G51=\"\",\"\",'Original Data'!G51)","v":3472440},null,3472440]
[null,null,null,null,null,{"$f":"IF('Original Data'!F52=\"\",\"\",'Original Data'!F52)","v":"2015-12-31"},{"$f":"IF('Original Data'!G52=\"\",\"\",'Original Data'!G52)","v":3563007},null,3563007]
[null,null,null,null,null,{"$f":"IF('Original Data'!F53=\"\",\"\",'Original Data'!F53)","v":"2016-01-31"},{"$f":"IF('Original Data'!G53=\"\",\"\",'Original Data'!G53)","v":3820570},null,3820570]
[null,null,null,null,null,{"$f":"IF('Original Data'!F54=\"\",\"\",'Original Data'!F54)","v":"2016-02-29"},{"$f":"IF('Original Data'!G54=\"\",\"\",'Original Data'!G54)","v":4107195},null,4107195]
[null,null,null,null,null,{"$f":"IF('Original Data'!F55=\"\",\"\",'Original Data'!F55)","v":"2016-03-31"},{"$f":"IF('Original Data'!G55=\"\",\"\",'Original Data'!G55)","v":4284443},null,4284443]
[null,null,null,null,null,{"$f":"IF('Original Data'!F56=\"\",\"\",'Original Data'!F56)","v":"2016-04-30"},{"$f":"IF('Original Data'!G56=\"\",\"\",'Original Data'!G56)","v":4356216},null,4356216]
[null,null,null,null,null,{"$f":"IF('Original Data'!F57=\"\",\"\",'Original Data'!F57)","v":"2016-05-31"},{"$f":"IF('Original Data'!G57=\"\",\"\",'Original Data'!G57)","v":3819379},null,3819379]
[null,null,null,null,null,{"$f":"IF('Original Data'!F58=\"\",\"\",'Original Data'!F58)","v":"2016-06-30"},{"$f":"IF('Original Data'!G58=\"\",\"\",'Original Data'!G58)","v":3844987},null,3844987]
[null,null,null,null,null,{"$f":"IF('Original Data'!F59=\"\",\"\",'Original Data'!F59)","v":"2016-07-31"},{"$f":"IF('Original Data'!G59=\"\",\"\",'Original Data'!G59)","v":3478890},null,3478890]
[null,null,null,null,null,{"$f":"IF('Original Data'!F60=\"\",\"\",'Original Data'!F60)","v":"2016-08-31"},{"$f":"IF('Original Data'!G60=\"\",\"\",'Original Data'!G60)","v":3443039},null,3443039]
[null,null,null,null,null,{"$f":"IF('Original Data'!F61=\"\",\"\",'Original Data'!F61)","v":"2016-09-30"},{"$f":"IF('Original Data'!G61=\"\",\"\",'Original Data'!G61)","v":3204637},null,3204637]
[null,null,null,null,null,{"$f":"IF('Original Data'!F62=\"\",\"\",'Original Data'!F62)","v":"2016-10-31"},{"$f":"IF('Original Data'!G62=\"\",\"\",'Original Data'!G62)","v":2966477},null,2966477]
[null,null,null,null,null,{"$f":"IF('Original Data'!F63=\"\",\"\",'Original Data'!F63)","v":"2016-11-30"},{"$f":"IF('Original Data'!G63=\"\",\"\",'Original Data'!G63)","v":3593364},null,3593364]
[null,null,null,null,null,{"$f":"IF('Original Data'!F64=\"\",\"\",'Original Data'!F64)","v":"2016-12-31"},{"$f":"IF('Original Data'!G64=\"\",\"\",'Original Data'!G64)","v":3604104},null,3604104]
[null,null,null,null,null,{"$f":"IF('Original Data'!F65=\"\",\"\",'Original Data'!F65)","v":"2017-01-31"},{"$f":"IF('Original Data'!G65=\"\",\"\",'Original Data'!G65)","v":3933016},null,3933016]
[null,null,null,null,null,{"$f":"IF('Original Data'!F66=\"\",\"\",'Original Data'!F66)","v":"2017-02-28"},{"$f":"IF('Original Data'!G66=\"\",\"\",'Original Data'!G66)","v":4146797},null,4146797]
[null,null,null,null,null,{"$f":"IF('Original Data'!F67=\"\",\"\",'Original Data'!F67)","v":"2017-03-31"},{"$f":"IF('Original Data'!G67=\"\",\"\",'Original Data'!G67)","v":4176486},null,4176486]
[null,null,null,null,null,{"$f":"IF('Original Data'!F68=\"\",\"\",'Original Data'!F68)","v":"2017-04-30"},{"$f":"IF('Original Data'!G68=\"\",\"\",'Original Data'!G68)","v":4347059},null,4347059]
[null,null,null,null,null,{"$f":"IF('Original Data'!F69=\"\",\"\",'Original Data'!F69)","v":"2017-05-31"},{"$f":"IF('Original Data'!G69=\"\",\"\",'Original Data'!G69)","v":3781168},null,3781168]
[null,null,null,null,null,{"$f":"IF('Original Data'!F70=\"\",\"\",'Original Data'!F70)","v":"2017-06-30"},{"$f":"IF('Original Data'!G70=\"\",\"\",'Original Data'!G70)","v":3858196.3569040108},null,3858196.3569040108]
[null,null,null,null,null,{"$f":"IF('Original Data'!F71=\"\",\"\",'Original Data'!F71)","v":"2017-07-31"},{"$f":"IF('Original Data'!G71=\"\",\"\",'Original Data'!G71)","v":3562679.8147925721},null,3562679.8147925721]
[null,null,null,null,null,{"$f":"IF('Original Data'!F72=\"\",\"\",'Original Data'!F72)","v":"2017-08-31"},null,{"$f":"TREND($G$13:$G$71,$F$13:$F$71,$F72)","v":3921269.5262332447},3921269.5262332447]
[null,null,null,null,null,{"$f":"IF('Original Data'!F73=\"\",\"\",'Original Data'!F73)","v":"2017-09-30"},null,{"$f":"TREND($G$13:$G$71,$F$13:$F$71,$F73)","v":3936997.0737471022},3936997.0737471022]
[null,null,null,null,null,{"$f":"IF('Original Data'!F74=\"\",\"\",'Original Data'!F74)","v":"2017-10-31"},null,3953248.8728447519,3953248.8728447519]
[null,null,null,null,null,{"$f":"IF('Original Data'!F75=\"\",\"\",'Original Data'!F75)","v":"2017-11-30"},null,3968976.4203586094,3968976.4203586094]
[null,null,null,null,null,{"$f":"IF('Original Data'!F76=\"\",\"\",'Original Data'!F76)","v":"2017-12-31"},null,3985228.2194562592,3985228.2194562592]
[null,null,null,null,null,{"$f":"IF('Original Data'!F77=\"\",\"\",'Original Data'!F77)","v":"2018-01-31"},null,4001480.0185539126,4001480.0185539126]
[null,null,null,null,null,{"$f":"IF('Original Data'!F78=\"\",\"\",'Original Data'!F78)","v":"2018-02-28"},null,4016159.0629001781,4016159.0629001781]
[null,null,null,null,null,{"$f":"IF('Original Data'!F79=\"\",\"\",'Original Data'!F79)","v":"2018-03-31"},null,4032410.8619978279,4032410.8619978279]
[null,null,null,null,null,{"$f":"IF('Original Data'!F80=\"\",\"\",'Original Data'!F80)","v":"2018-04-30"},null,4048138.4095116854,4048138.4095116854]
[null,null,null,null,null,{"$f":"IF('Original Data'!F81=\"\",\"\",'Original Data'!F81)","v":"2018-05-31"},null,4064390.2086093388,4064390.2086093388]
[null,null,null,null,null,{"$f":"IF('Original Data'!F82=\"\",\"\",'Original Data'!F82)","v":"2018-06-30"},null,4080117.7561231926,4080117.7561231926]
[null,null,null,null,null,{"$f":"IF('Original Data'!F83=\"\",\"\",'Original Data'!F83)","v":"2018-07-31"},null,4096369.5552208461,4096369.5552208461]
[null,null,null,null,null,{"$f":"IF('Original Data'!F84=\"\",\"\",'Original Data'!F84)","v":"2018-08-31"},null,4112621.3543184958,4112621.3543184958]
[null,null,null,null,null,{"$f":"IF('Original Data'!F85=\"\",\"\",'Original Data'!F85)","v":"2018-09-30"},null,4128348.9018323533,4128348.9018323533]
[null,null,null,null,null,{"$f":"IF('Original Data'!F86=\"\",\"\",'Original Data'!F86)","v":"2018-10-31"},null,4144600.7009300068,4144600.7009300068]
[null,null,null,null,null,{"$f":"IF('Original Data'!F87=\"\",\"\",'Original Data'!F87)","v":"2018-11-30"},null,4160328.2484438606,4160328.2484438606]
[null,null,null,null,null,{"$f":"IF('Original Data'!F88=\"\",\"\",'Original Data'!F88)","v":"2018-12-31"},null,4176580.047541514,4176580.047541514]
[null,null,null,null,null,{"$f":"IF('Original Data'!F89=\"\",\"\",'Original Data'!F89)","v":"2019-01-31"},null,4192831.8466391638,4192831.8466391638]
[null,null,null,null,null,{"$f":"IF('Original Data'!F90=\"\",\"\",'Original Data'!F90)","v":"2019-02-28"},null,4207510.8909854293,4207510.8909854293]
[null,null,null,null,null,{"$f":"IF('Original Data'!F91=\"\",\"\",'Original Data'!F91)","v":"2019-03-31"},null,4223762.6900830828,4223762.6900830828]
[null,null,null,null,null,{"$f":"IF('Original Data'!F92=\"\",\"\",'Original Data'!F92)","v":"2019-04-30"},null,4239490.2375969402,4239490.2375969402]
[null,null,null,null,null,{"$f":"IF('Original Data'!F93=\"\",\"\",'Original Data'!F93)","v":"2019-05-31"},null,4255742.03669459,4255742.03669459]
[null,null,null,null,null,{"$f":"IF('Original Data'!F94=\"\",\"\",'Original Data'!F94)","v":"2019-06-30"},null,4271469.5842084475,4271469.5842084475]
[null,null,null,null,null,{"$f":"IF('Original Data'!F95=\"\",\"\",'Original Data'!F95)","v":"2019-07-31"},null,4287721.3833060972,4287721.3833060972]
[null,null,null,null,null,{"$f":"IF('Original Data'!F96=\"\",\"\",'Original Data'!F96)","v":"2019-08-31"},null,4303973.1824037507,4303973.1824037507]
[null,null,null,null,null,{"$f":"IF('Original Data'!F97=\"\",\"\",'Original Data'!F97)","v":"2019-09-30"},null,4319700.7299176045,4319700.7299176045]
[null,null,null,null,null,{"$f":"IF('Original Data'!F98=\"\",\"\",'Original Data'!F98)","v":"2019-10-31"},null,4335952.529015258,4335952.529015258]
[null,null,null,null,null,{"$f":"IF('Original Data'!F99=\"\",\"\",'Original Data'!F99)","v":"2019-11-30"},null,4351680.0765291154,4351680.0765291154]
[null,null,null,null,null,{"$f":"IF('Original Data'!F100=\"\",\"\",'Original Data'!F100)","v":"2019-12-31"},null,4367931.8756267652,4367931.8756267652]
[null,null,null,null,null,{"$f":"IF('Original Data'!F101=\"\",\"\",'Original Data'!F101)","v":"2020-01-31"},null,4384183.6747244187,4384183.6747244187]
[null,null,null,null,null,{"$f":"IF('Original Data'!F102=\"\",\"\",'Original Data'!F102)","v":"2020-02-29"},null,4399386.9706544764,4399386.9706544764]
[null,null,null,null,null,{"$f":"IF('Original Data'!F103=\"\",\"\",'Original Data'!F103)","v":"2020-03-31"},null,4415638.7697521299,4415638.7697521299]
[null,null,null,null,null,{"$f":"IF('Original Data'!F104=\"\",\"\",'Original Data'!F104)","v":"2020-04-30"},null,4431366.3172659874,4431366.3172659874]
[null,null,null,null,null,{"$f":"IF('Original Data'!F105=\"\",\"\",'Original Data'!F105)","v":"2020-05-31"},null,4447618.1163636371,4447618.1163636371]
[null,null,null,null,null,{"$f":"IF('Original Data'!F106=\"\",\"\",'Original Data'!F106)","v":"2020-06-30"},null,4463345.6638774946,4463345.6638774946]
[null,null,null,null,null,{"$f":"IF('Original Data'!F107=\"\",\"\",'Original Data'!F107)","v":"2020-07-31"},null,4479597.4629751444,4479597.4629751444]
[null,null,null,null,null,{"$f":"IF('Original Data'!F108=\"\",\"\",'Original Data'!F108)","v":"2020-08-31"},null,4495849.2620727979,4495849.2620727979]
[null,null,null,null,null,{"$f":"IF('Original Data'!F109=\"\",\"\",'Original Data'!F109)","v":"2020-09-30"},null,4511576.8095866553,4511576.8095866553]
[null,null,null,null,null,{"$f":"IF('Original Data'!F110=\"\",\"\",'Original Data'!F110)","v":"2020-10-31"},null,4527828.6086843051,4527828.6086843051]
[null,null,null,null,null,{"$f":"IF('Original Data'!F111=\"\",\"\",'Original Data'!F111)","v":"2020-11-30"},null,4543556.1561981626,4543556.1561981626]
[null,null,null,null,null,{"$f":"IF('Original Data'!F112=\"\",\"\",'Original Data'!F112)","v":"2020-12-31"},{"$f":"IF('Original Data'!G112=\"\",\"\",'Original Data'!G112)","v":""},4559807.9552958123,4559807.9552958123]

{"sheet":"Method 2 - Using TREND + CAGR","index":5,"n_rows":112,"n_cols":16,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Method 2 - Using TREND + CAGR"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Historical Information"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[]
[null,null,null,null,null,"Date","Sales","TREND","Combined"]
[null,null,null,null,null,{"$f":"IF('Original Data'!F13=\"\",\"\",'Original Data'!F13)","v":"2012-09-30"},{"$f":"IF('Original Data'!G13=\"\",\"\",'Original Data'!G13)","v":2644539},null,{"$f":"IF($G13=\"\",OFFSET($I13,-$P$36,)*(1+$P$45),$G13)","v":2644539}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F14=\"\",\"\",'Original Data'!F14)","v":"2012-10-31"},{"$f":"IF('Original Data'!G14=\"\",\"\",'Original Data'!G14)","v":2359800},null,{"$f":"IF($G14=\"\",OFFSET($I14,-$P$36,)*(1+$P$45),$G14)","v":2359800}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F15=\"\",\"\",'Original Data'!F15)","v":"2012-11-30"},{"$f":"IF('Original Data'!G15=\"\",\"\",'Original Data'!G15)","v":2925918},null,2925918]
[null,null,null,null,null,{"$f":"IF('Original Data'!F16=\"\",\"\",'Original Data'!F16)","v":"2012-12-31"},{"$f":"IF('Original Data'!G16=\"\",\"\",'Original Data'!G16)","v":3024973},null,3024973]
[null,null,null,null,null,{"$f":"IF('Original Data'!F17=\"\",\"\",'Original Data'!F17)","v":"2013-01-31"},{"$f":"IF('Original Data'!G17=\"\",\"\",'Original Data'!G17)","v":3177100},null,3177100]
[null,null,null,null,null,{"$f":"IF('Original Data'!F18=\"\",\"\",'Original Data'!F18)","v":"2013-02-28"},{"$f":"IF('Original Data'!G18=\"\",\"\",'Original Data'!G18)","v":3419595},null,3419595]
[null,null,null,null,null,{"$f":"IF('Original Data'!F19=\"\",\"\",'Original Data'!F19)","v":"2013-03-31"},{"$f":"IF('Original Data'!G19=\"\",\"\",'Original Data'!G19)","v":3649702},null,3649702]
[null,null,null,null,null,{"$f":"IF('Original Data'!F20=\"\",\"\",'Original Data'!F20)","v":"2013-04-30"},{"$f":"IF('Original Data'!G20=\"\",\"\",'Original Data'!G20)","v":3650668},null,3650668]
[null,null,null,null,null,{"$f":"IF('Original Data'!F21=\"\",\"\",'Original Data'!F21)","v":"2013-05-31"},{"$f":"IF('Original Data'!G21=\"\",\"\",'Original Data'!G21)","v":3191526},null,3191526]
[null,null,null,null,null,{"$f":"IF('Original Data'!F22=\"\",\"\",'Original Data'!F22)","v":"2013-06-30"},{"$f":"IF('Original Data'!G22=\"\",\"\",'Original Data'!G22)","v":3249428},null,3249428]
[null,null,null,null,null,{"$f":"IF('Original Data'!F23=\"\",\"\",'Original Data'!F23)","v":"2013-07-31"},{"$f":"IF('Original Data'!G23=\"\",\"\",'Original Data'!G23)","v":2971484},null,2971484]
[null,null,null,null,null,{"$f":"IF('Original Data'!F24=\"\",\"\",'Original Data'!F24)","v":"2013-08-31"},{"$f":"IF('Original Data'!G24=\"\",\"\",'Original Data'!G24)","v":3074209},null,3074209]
[null,null,null,null,null,{"$f":"IF('Original Data'!F25=\"\",\"\",'Original Data'!F25)","v":"2013-09-30"},{"$f":"IF('Original Data'!G25=\"\",\"\",'Original Data'!G25)","v":2785466},null,2785466]
[null,null,null,null,null,{"$f":"IF('Original Data'!F26=\"\",\"\",'Original Data'!F26)","v":"2013-10-31"},{"$f":"IF('Original Data'!G26=\"\",\"\",'Original Data'!G26)","v":2515361},null,2515361]
[null,null,null,null,null,{"$f":"IF('Original Data'!F27=\"\",\"\",'Original Data'!F27)","v":"2013-11-30"},{"$f":"IF('Original Data'!G27=\"\",\"\",'Original Data'!G27)","v":3105958},null,3105958]
[null,null,null,null,null,{"$f":"IF('Original Data'!F28=\"\",\"\",'Original Data'!F28)","v":"2013-12-31"},{"$f":"IF('Original Data'!G28=\"\",\"\",'Original Data'!G28)","v":3139059},null,3139059]
[null,null,null,null,null,{"$f":"IF('Original Data'!F29=\"\",\"\",'Original Data'!F29)","v":"2014-01-31"},{"$f":"IF('Original Data'!G29=\"\",\"\",'Original Data'!G29)","v":3380355},null,3380355]
[null,null,null,null,null,{"$f":"IF('Original Data'!F30=\"\",\"\",'Original Data'!F30)","v":"2014-02-28"},{"$f":"IF('Original Data'!G30=\"\",\"\",'Original Data'!G30)","v":3612886},null,3612886]
[null,null,null,null,null,{"$f":"IF('Original Data'!F31=\"\",\"\",'Original Data'!F31)","v":"2014-03-31"},{"$f":"IF('Original Data'!G31=\"\",\"\",'Original Data'!G31)","v":3765824},null,3765824]
[null,null,null,null,null,{"$f":"IF('Original Data'!F32=\"\",\"\",'Original Data'!F32)","v":"2014-04-30"},{"$f":"IF('Original Data'!G32=\"\",\"\",'Original Data'!G32)","v":3771842},null,3771842]
[null,null,null,null,null,{"$f":"IF('Original Data'!F33=\"\",\"\",'Original Data'!F33)","v":"2014-05-31"},{"$f":"IF('Original Data'!G33=\"\",\"\",'Original Data'!G33)","v":3356365},null,3356365,null,"Compound Annual Growth Rate (CAGR)"]
[null,null,null,null,null,{"$f":"IF('Original Data'!F34=\"\",\"\",'Original Data'!F34)","v":"2014-06-30"},{"$f":"IF('Original Data'!G34=\"\",\"\",'Original Data'!G34)","v":3490100},null,3490100]
[null,null,null,null,null,{"$f":"IF('Original Data'!F35=\"\",\"\",'Original Data'!F35)","v":"2014-07-31"},{"$f":"IF('Original Data'!G35=\"\",\"\",'Original Data'!G35)","v":3163659},null,3163659,null,null,"Last date of actuals",null,null,null,{"$f":"MAX(IF(G13:G112<>\"\",F13:F112))","v":"2017-07-31"}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F36=\"\",\"\",'Original Data'!F36)","v":"2014-08-31"},{"$f":"IF('Original Data'!G36=\"\",\"\",'Original Data'!G36)","v":3167124},null,3167124,null,null,"Periodicity duration",null,null,null,12]
[null,null,null,null,null,{"$f":"IF('Original Data'!F37=\"\",\"\",'Original Data'!F37)","v":"2014-09-30"},{"$f":"IF('Original Data'!G37=\"\",\"\",'Original Data'!G37)","v":2883810},null,2883810]
[null,null,null,null,null,{"$f":"IF('Original Data'!F38=\"\",\"\",'Original Data'!F38)","v":"2014-10-31"},{"$f":"IF('Original Data'!G38=\"\",\"\",'Original Data'!G38)","v":2610667},null,2610667,null,null,"Last date of first cycle of forecasts",null,null,null,{"$f":"EOMONTH(P35,P36)","v":"2018-07-31"}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F39=\"\",\"\",'Original Data'!F39)","v":"2014-11-30"},{"$f":"IF('Original Data'!G39=\"\",\"\",'Original Data'!G39)","v":3129205},null,3129205]
[null,null,null,null,null,{"$f":"IF('Original Data'!F40=\"\",\"\",'Original Data'!F40)","v":"2014-12-31"},{"$f":"IF('Original Data'!G40=\"\",\"\",'Original Data'!G40)","v":3200527},null,3200527,null,null,{"$f":"\"Sum of last actual cycle ending \"&TEXT(P35,\"d mmm yy\")","v":"Sum of last actual cycle ending 31 Jul 17"},null,null,null,{"$f":"SUM(OFFSET($G$12,MATCH($P$35,$F$13:$F$112,0),,-$P$36,))","v":44617023.171696581}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F41=\"\",\"\",'Original Data'!F41)","v":"2015-01-31"},{"$f":"IF('Original Data'!G41=\"\",\"\",'Original Data'!G41)","v":3547804},null,3547804,null,null,{"$f":"\"Sum of first forecast cycle ending \"&TEXT(P38,\"d mmm yy\")","v":"Sum of first forecast cycle ending 31 Jul 18"},null,null,null,{"$f":"SUM(OFFSET($H$12,MATCH($P$38,$F$13:$F$112,0),,-$P$36,))","v":48104785.98555696}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F42=\"\",\"\",'Original Data'!F42)","v":"2015-02-28"},{"$f":"IF('Original Data'!G42=\"\",\"\",'Original Data'!G42)","v":3766323},null,3766323]
[null,null,null,null,null,{"$f":"IF('Original Data'!F43=\"\",\"\",'Original Data'!F43)","v":"2015-03-31"},{"$f":"IF('Original Data'!G43=\"\",\"\",'Original Data'!G43)","v":3935589},null,3935589,null,null,"Growth implicit (CAGR)",null,null,null,{"$f":"(P41/P40)^(Months_in_Year/$P$36)-1","v":7.8171123170603929E-2}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F44=\"\",\"\",'Original Data'!F44)","v":"2015-04-30"},{"$f":"IF('Original Data'!G44=\"\",\"\",'Original Data'!G44)","v":3917884},null,3917884]
[null,null,null,null,null,{"$f":"IF('Original Data'!F45=\"\",\"\",'Original Data'!F45)","v":"2015-05-31"},{"$f":"IF('Original Data'!G45=\"\",\"\",'Original Data'!G45)","v":3564970},null,3564970,null,null,"Growth factor per cycle",null,null,null,{"$f":"(1+P43)^($P$36/Months_in_Year)-1","v":7.8171123170603929E-2}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F46=\"\",\"\",'Original Data'!F46)","v":"2015-06-30"},{"$f":"IF('Original Data'!G46=\"\",\"\",'Original Data'!G46)","v":3602455},null,3602455]
[null,null,null,null,null,{"$f":"IF('Original Data'!F47=\"\",\"\",'Original Data'!F47)","v":"2015-07-31"},{"$f":"IF('Original Data'!G47=\"\",\"\",'Original Data'!G47)","v":3326859},null,3326859]
[null,null,null,null,null,{"$f":"IF('Original Data'!F48=\"\",\"\",'Original Data'!F48)","v":"2015-08-31"},{"$f":"IF('Original Data'!G48=\"\",\"\",'Original Data'!G48)","v":3441693},null,3441693]
[null,null,null,null,null,{"$f":"IF('Original Data'!F49=\"\",\"\",'Original Data'!F49)","v":"2015-09-30"},{"$f":"IF('Original Data'!G49=\"\",\"\",'Original Data'!G49)","v":3211600},null,3211600]
[null,null,null,null,null,{"$f":"IF('Original Data'!F50=\"\",\"\",'Original Data'!F50)","v":"2015-10-31"},{"$f":"IF('Original Data'!G50=\"\",\"\",'Original Data'!G50)","v":2998119},null,2998119]
[null,null,null,null,null,{"$f":"IF('Original Data'!F51=\"\",\"\",'Original Data'!F51)","v":"2015-11-30"},{"$f":"IF('Original Data'!G51=\"\",\"\",'Original Data'!G51)","v":3472440},null,3472440]
[null,null,null,null,null,{"$f":"IF('Original Data'!F52=\"\",\"\",'Original Data'!F52)","v":"2015-12-31"},{"$f":"IF('Original Data'!G52=\"\",\"\",'Original Data'!G52)","v":3563007},null,3563007]
[null,null,null,null,null,{"$f":"IF('Original Data'!F53=\"\",\"\",'Original Data'!F53)","v":"2016-01-31"},{"$f":"IF('Original Data'!G53=\"\",\"\",'Original Data'!G53)","v":3820570},null,3820570]
[null,null,null,null,null,{"$f":"IF('Original Data'!F54=\"\",\"\",'Original Data'!F54)","v":"2016-02-29"},{"$f":"IF('Original Data'!G54=\"\",\"\",'Original Data'!G54)","v":4107195},null,4107195]
[null,null,null,null,null,{"$f":"IF('Original Data'!F55=\"\",\"\",'Original Data'!F55)","v":"2016-03-31"},{"$f":"IF('Original Data'!G55=\"\",\"\",'Original Data'!G55)","v":4284443},null,4284443]
[null,null,null,null,null,{"$f":"IF('Original Data'!F56=\"\",\"\",'Original Data'!F56)","v":"2016-04-30"},{"$f":"IF('Original Data'!G56=\"\",\"\",'Original Data'!G56)","v":4356216},null,4356216]
[null,null,null,null,null,{"$f":"IF('Original Data'!F57=\"\",\"\",'Original Data'!F57)","v":"2016-05-31"},{"$f":"IF('Original Data'!G57=\"\",\"\",'Original Data'!G57)","v":3819379},null,3819379]
[null,null,null,null,null,{"$f":"IF('Original Data'!F58=\"\",\"\",'Original Data'!F58)","v":"2016-06-30"},{"$f":"IF('Original Data'!G58=\"\",\"\",'Original Data'!G58)","v":3844987},null,3844987]
[null,null,null,null,null,{"$f":"IF('Original Data'!F59=\"\",\"\",'Original Data'!F59)","v":"2016-07-31"},{"$f":"IF('Original Data'!G59=\"\",\"\",'Original Data'!G59)","v":3478890},null,3478890]
[null,null,null,null,null,{"$f":"IF('Original Data'!F60=\"\",\"\",'Original Data'!F60)","v":"2016-08-31"},{"$f":"IF('Original Data'!G60=\"\",\"\",'Original Data'!G60)","v":3443039},null,3443039]
[null,null,null,null,null,{"$f":"IF('Original Data'!F61=\"\",\"\",'Original Data'!F61)","v":"2016-09-30"},{"$f":"IF('Original Data'!G61=\"\",\"\",'Original Data'!G61)","v":3204637},null,3204637]
[null,null,null,null,null,{"$f":"IF('Original Data'!F62=\"\",\"\",'Original Data'!F62)","v":"2016-10-31"},{"$f":"IF('Original Data'!G62=\"\",\"\",'Original Data'!G62)","v":2966477},null,2966477]
[null,null,null,null,null,{"$f":"IF('Original Data'!F63=\"\",\"\",'Original Data'!F63)","v":"2016-11-30"},{"$f":"IF('Original Data'!G63=\"\",\"\",'Original Data'!G63)","v":3593364},null,3593364]
[null,null,null,null,null,{"$f":"IF('Original Data'!F64=\"\",\"\",'Original Data'!F64)","v":"2016-12-31"},{"$f":"IF('Original Data'!G64=\"\",\"\",'Original Data'!G64)","v":3604104},null,3604104]
[null,null,null,null,null,{"$f":"IF('Original Data'!F65=\"\",\"\",'Original Data'!F65)","v":"2017-01-31"},{"$f":"IF('Original Data'!G65=\"\",\"\",'Original Data'!G65)","v":3933016},null,3933016]
[null,null,null,null,null,{"$f":"IF('Original Data'!F66=\"\",\"\",'Original Data'!F66)","v":"2017-02-28"},{"$f":"IF('Original Data'!G66=\"\",\"\",'Original Data'!G66)","v":4146797},null,4146797]
[null,null,null,null,null,{"$f":"IF('Original Data'!F67=\"\",\"\",'Original Data'!F67)","v":"2017-03-31"},{"$f":"IF('Original Data'!G67=\"\",\"\",'Original Data'!G67)","v":4176486},null,4176486]
[null,null,null,null,null,{"$f":"IF('Original Data'!F68=\"\",\"\",'Original Data'!F68)","v":"2017-04-30"},{"$f":"IF('Original Data'!G68=\"\",\"\",'Original Data'!G68)","v":4347059},null,4347059]
[null,null,null,null,null,{"$f":"IF('Original Data'!F69=\"\",\"\",'Original Data'!F69)","v":"2017-05-31"},{"$f":"IF('Original Data'!G69=\"\",\"\",'Original Data'!G69)","v":3781168},null,3781168]
[null,null,null,null,null,{"$f":"IF('Original Data'!F70=\"\",\"\",'Original Data'!F70)","v":"2017-06-30"},{"$f":"IF('Original Data'!G70=\"\",\"\",'Original Data'!G70)","v":3858196.3569040108},null,3858196.3569040108]
[null,null,null,null,null,{"$f":"IF('Original Data'!F71=\"\",\"\",'Original Data'!F71)","v":"2017-07-31"},{"$f":"IF('Original Data'!G71=\"\",\"\",'Original Data'!G71)","v":3562679.8147925721},null,3562679.8147925721]
[null,null,null,null,null,{"$f":"IF('Original Data'!F72=\"\",\"\",'Original Data'!F72)","v":"2017-08-31"},{"$f":"IF('Original Data'!G72=\"\",\"\",'Original Data'!G72)","v":""},{"$f":"TREND($G$13:$G$71,$F$13:$F$71,$F72)","v":3921269.5262332447},{"$f":"IF($G72=\"\",OFFSET($I72,-$P$36,)*(1+$P$45),$G72)","v":3712185.225750193}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F73=\"\",\"\",'Original Data'!F73)","v":"2017-09-30"},{"$f":"IF('Original Data'!G73=\"\",\"\",'Original Data'!G73)","v":""},{"$f":"TREND($G$13:$G$71,$F$13:$F$71,$F73)","v":3936997.0737471022},3455147.0736440746]
[null,null,null,null,null,{"$f":"IF('Original Data'!F74=\"\",\"\",'Original Data'!F74)","v":"2017-10-31"},{"$f":"IF('Original Data'!G74=\"\",\"\",'Original Data'!G74)","v":""},3953248.8728447519,3198369.8389497637]
[null,null,null,null,null,{"$f":"IF('Original Data'!F75=\"\",\"\",'Original Data'!F75)","v":"2017-11-30"},{"$f":"IF('Original Data'!G75=\"\",\"\",'Original Data'!G75)","v":""},3968976.4203586094,3874261.299840814]
[null,null,null,null,null,{"$f":"IF('Original Data'!F76=\"\",\"\",'Original Data'!F76)","v":"2017-12-31"},{"$f":"IF('Original Data'!G76=\"\",\"\",'Original Data'!G76)","v":""},3985228.2194562592,3885840.8577036662]
[null,null,null,null,null,{"$f":"IF('Original Data'!F77=\"\",\"\",'Original Data'!F77)","v":"2018-01-31"},{"$f":"IF('Original Data'!G77=\"\",\"\",'Original Data'!G77)","v":""},4001480.0185539126,4240464.2781679556]
[null,null,null,null,null,{"$f":"IF('Original Data'!F78=\"\",\"\",'Original Data'!F78)","v":"2018-02-28"},{"$f":"IF('Original Data'!G78=\"\",\"\",'Original Data'!G78)","v":""},4016159.0629001781,{"$f":"IF($G78=\"\",OFFSET($I78,-$P$36,)*(1+$P$45),$G78)","v":4470956.7790504908}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F79=\"\",\"\",'Original Data'!F79)","v":"2018-03-31"},{"$f":"IF('Original Data'!G79=\"\",\"\",'Original Data'!G79)","v":""},4032410.8619978279,4502966.6015263032]
[null,null,null,null,null,{"$f":"IF('Original Data'!F80=\"\",\"\",'Original Data'!F80)","v":"2018-04-30"},{"$f":"IF('Original Data'!G80=\"\",\"\",'Original Data'!G80)","v":""},4048138.4095116854,4686873.4845188819]
[null,null,null,null,null,{"$f":"IF('Original Data'!F81=\"\",\"\",'Original Data'!F81)","v":"2018-05-31"},{"$f":"IF('Original Data'!G81=\"\",\"\",'Original Data'!G81)","v":""},4064390.2086093388,4076746.1494567459]
[null,null,null,null,null,{"$f":"IF('Original Data'!F82=\"\",\"\",'Original Data'!F82)","v":"2018-06-30"},{"$f":"IF('Original Data'!G82=\"\",\"\",'Original Data'!G82)","v":""},4080117.7561231926,4159795.8995359293]
[null,null,null,null,null,{"$f":"IF('Original Data'!F83=\"\",\"\",'Original Data'!F83)","v":"2018-07-31"},{"$f":"IF('Original Data'!G83=\"\",\"\",'Original Data'!G83)","v":""},4096369.5552208461,3841178.4974121465]
[null,null,null,null,null,{"$f":"IF('Original Data'!F84=\"\",\"\",'Original Data'!F84)","v":"2018-08-31"},{"$f":"IF('Original Data'!G84=\"\",\"\",'Original Data'!G84)","v":""},4112621.3543184958,4002370.9142644075]
[null,null,null,null,null,{"$f":"IF('Original Data'!F85=\"\",\"\",'Original Data'!F85)","v":"2018-09-30"},{"$f":"IF('Original Data'!G85=\"\",\"\",'Original Data'!G85)","v":""},4128348.9018323533,3725239.8011104572]
[null,null,null,null,null,{"$f":"IF('Original Data'!F86=\"\",\"\",'Original Data'!F86)","v":"2018-10-31"},{"$f":"IF('Original Data'!G86=\"\",\"\",'Original Data'!G86)","v":""},4144600.7009300068,3448390.0015754504]
[null,null,null,null,null,{"$f":"IF('Original Data'!F87=\"\",\"\",'Original Data'!F87)","v":"2018-11-30"},{"$f":"IF('Original Data'!G87=\"\",\"\",'Original Data'!G87)","v":""},4160328.2484438606,4177116.6571057742]
[null,null,null,null,null,{"$f":"IF('Original Data'!F88=\"\",\"\",'Original Data'!F88)","v":"2018-12-31"},{"$f":"IF('Original Data'!G88=\"\",\"\",'Original Data'!G88)","v":""},4176580.047541514,4189601.4020125847]
[null,null,null,null,null,{"$f":"IF('Original Data'!F89=\"\",\"\",'Original Data'!F89)","v":"2019-01-31"},{"$f":"IF('Original Data'!G89=\"\",\"\",'Original Data'!G89)","v":""},4192831.8466391638,4571946.1335571688]
[null,null,null,null,null,{"$f":"IF('Original Data'!F90=\"\",\"\",'Original Data'!F90)","v":"2019-02-28"},{"$f":"IF('Original Data'!G90=\"\",\"\",'Original Data'!G90)","v":""},4207510.8909854293,4820456.4921160936]
[null,null,null,null,null,{"$f":"IF('Original Data'!F91=\"\",\"\",'Original Data'!F91)","v":"2019-03-31"},{"$f":"IF('Original Data'!G91=\"\",\"\",'Original Data'!G91)","v":""},4223762.6900830828,4854968.5583673315]
[null,null,null,null,null,{"$f":"IF('Original Data'!F92=\"\",\"\",'Original Data'!F92)","v":"2019-04-30"},{"$f":"IF('Original Data'!G92=\"\",\"\",'Original Data'!G92)","v":""},4239490.2375969402,5053251.6489622453]
[null,null,null,null,null,{"$f":"IF('Original Data'!F93=\"\",\"\",'Original Data'!F93)","v":"2019-05-31"},{"$f":"IF('Original Data'!G93=\"\",\"\",'Original Data'!G93)","v":""},4255742.03669459,4395429.9748412147]
[null,null,null,null,null,{"$f":"IF('Original Data'!F94=\"\",\"\",'Original Data'!F94)","v":"2019-06-30"},{"$f":"IF('Original Data'!G94=\"\",\"\",'Original Data'!G94)","v":""},4271469.5842084475,4484971.8171631256]
[null,null,null,null,null,{"$f":"IF('Original Data'!F95=\"\",\"\",'Original Data'!F95)","v":"2019-07-31"},{"$f":"IF('Original Data'!G95=\"\",\"\",'Original Data'!G95)","v":""},4287721.3833060972,4141447.7348536267]
[null,null,null,null,null,{"$f":"IF('Original Data'!F96=\"\",\"\",'Original Data'!F96)","v":"2019-08-31"},{"$f":"IF('Original Data'!G96=\"\",\"\",'Original Data'!G96)","v":""},4303973.1824037507,4315240.7439778131]
[null,null,null,null,null,{"$f":"IF('Original Data'!F97=\"\",\"\",'Original Data'!F97)","v":"2019-09-30"},{"$f":"IF('Original Data'!G97=\"\",\"\",'Original Data'!G97)","v":""},4319700.7299176045,4016445.9804430986]
[null,null,null,null,null,{"$f":"IF('Original Data'!F98=\"\",\"\",'Original Data'!F98)","v":"2019-10-31"},{"$f":"IF('Original Data'!G98=\"\",\"\",'Original Data'!G98)","v":""},4335952.529015258,3717954.5211288841]
[null,null,null,null,null,{"$f":"IF('Original Data'!F99=\"\",\"\",'Original Data'!F99)","v":"2019-11-30"},{"$f":"IF('Original Data'!G99=\"\",\"\",'Original Data'!G99)","v":""},4351680.0765291154,4503646.5578063708]
[null,null,null,null,null,{"$f":"IF('Original Data'!F100=\"\",\"\",'Original Data'!F100)","v":"2019-12-31"},{"$f":"IF('Original Data'!G100=\"\",\"\",'Original Data'!G100)","v":""},4367931.8756267652,4517107.2492450457]
[null,null,null,null,null,{"$f":"IF('Original Data'!F101=\"\",\"\",'Original Data'!F101)","v":"2020-01-31"},{"$f":"IF('Original Data'!G101=\"\",\"\",'Original Data'!G101)","v":""},4384183.6747244187,4929340.2978928322]
[null,null,null,null,null,{"$f":"IF('Original Data'!F102=\"\",\"\",'Original Data'!F102)","v":"2020-02-29"},{"$f":"IF('Original Data'!G102=\"\",\"\",'Original Data'!G102)","v":""},4399386.9706544764,5197276.9902998386]
[null,null,null,null,null,{"$f":"IF('Original Data'!F103=\"\",\"\",'Original Data'!F103)","v":"2020-03-31"},{"$f":"IF('Original Data'!G103=\"\",\"\",'Original Data'!G103)","v":""},4415638.7697521299,5234486.9035328738]
[null,null,null,null,null,{"$f":"IF('Original Data'!F104=\"\",\"\",'Original Data'!F104)","v":"2020-04-30"},{"$f":"IF('Original Data'!G104=\"\",\"\",'Original Data'!G104)","v":""},4431366.3172659874,5448270.0060253302]
[null,null,null,null,null,{"$f":"IF('Original Data'!F105=\"\",\"\",'Original Data'!F105)","v":"2020-05-31"},{"$f":"IF('Original Data'!G105=\"\",\"\",'Original Data'!G105)","v":""},4447618.1163636371,4739025.6727922922]
[null,null,null,null,null,{"$f":"IF('Original Data'!F106=\"\",\"\",'Original Data'!F106)","v":"2020-06-30"},{"$f":"IF('Original Data'!G106=\"\",\"\",'Original Data'!G106)","v":""},4463345.6638774946,4835567.1014992716]
[null,null,null,null,null,{"$f":"IF('Original Data'!F107=\"\",\"\",'Original Data'!F107)","v":"2020-07-31"},{"$f":"IF('Original Data'!G107=\"\",\"\",'Original Data'!G107)","v":""},4479597.4629751444,4465189.3558394881]
[null,null,null,null,null,{"$f":"IF('Original Data'!F108=\"\",\"\",'Original Data'!F108)","v":"2020-08-31"},{"$f":"IF('Original Data'!G108=\"\",\"\",'Original Data'!G108)","v":""},4495849.2620727979,4652567.9596861117]
[null,null,null,null,null,{"$f":"IF('Original Data'!F109=\"\",\"\",'Original Data'!F109)","v":"2020-09-30"},{"$f":"IF('Original Data'!G109=\"\",\"\",'Original Data'!G109)","v":""},4511576.8095866553,4330416.0738883931]
[null,null,null,null,null,{"$f":"IF('Original Data'!F110=\"\",\"\",'Original Data'!F110)","v":"2020-10-31"},{"$f":"IF('Original Data'!G110=\"\",\"\",'Original Data'!G110)","v":""},4527828.6086843051,4008591.201942754]
[null,null,null,null,null,{"$f":"IF('Original Data'!F111=\"\",\"\",'Original Data'!F111)","v":"2020-11-30"},{"$f":"IF('Original Data'!G111=\"\",\"\",'Original Data'!G111)","v":""},4543556.1561981626,4855701.6675935192]
[null,null,null,null,null,{"$f":"IF('Original Data'!F112=\"\",\"\",'Original Data'!F112)","v":"2020-12-31"},{"$f":"IF('Original Data'!G112=\"\",\"\",'Original Data'!G112)","v":""},4559807.9552958123,4870214.5964006083]

{"sheet":"Method 3 - Using FORECAST.ETS","index":6,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Method 3 - Using FORECAST.ETS"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Historical Information"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[]
[null,null,null,null,null,"Date","Sales"]
[null,null,null,null,null,{"$f":"IF('Original Data'!F13=\"\",\"\",'Original Data'!F13)","v":"2012-09-30"},{"$f":"IF('Original Data'!G13=\"\",\"\",'Original Data'!G13)","v":2644539}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F14=\"\",\"\",'Original Data'!F14)","v":"2012-10-31"},{"$f":"IF('Original Data'!G14=\"\",\"\",'Original Data'!G14)","v":2359800}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F15=\"\",\"\",'Original Data'!F15)","v":"2012-11-30"},{"$f":"IF('Original Data'!G15=\"\",\"\",'Original Data'!G15)","v":2925918}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F16=\"\",\"\",'Original Data'!F16)","v":"2012-12-31"},{"$f":"IF('Original Data'!G16=\"\",\"\",'Original Data'!G16)","v":3024973}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F17=\"\",\"\",'Original Data'!F17)","v":"2013-01-31"},{"$f":"IF('Original Data'!G17=\"\",\"\",'Original Data'!G17)","v":3177100}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F18=\"\",\"\",'Original Data'!F18)","v":"2013-02-28"},{"$f":"IF('Original Data'!G18=\"\",\"\",'Original Data'!G18)","v":3419595}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F19=\"\",\"\",'Original Data'!F19)","v":"2013-03-31"},{"$f":"IF('Original Data'!G19=\"\",\"\",'Original Data'!G19)","v":3649702}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F20=\"\",\"\",'Original Data'!F20)","v":"2013-04-30"},{"$f":"IF('Original Data'!G20=\"\",\"\",'Original Data'!G20)","v":3650668}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F21=\"\",\"\",'Original Data'!F21)","v":"2013-05-31"},{"$f":"IF('Original Data'!G21=\"\",\"\",'Original Data'!G21)","v":3191526}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F22=\"\",\"\",'Original Data'!F22)","v":"2013-06-30"},{"$f":"IF('Original Data'!G22=\"\",\"\",'Original Data'!G22)","v":3249428}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F23=\"\",\"\",'Original Data'!F23)","v":"2013-07-31"},{"$f":"IF('Original Data'!G23=\"\",\"\",'Original Data'!G23)","v":2971484}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F24=\"\",\"\",'Original Data'!F24)","v":"2013-08-31"},{"$f":"IF('Original Data'!G24=\"\",\"\",'Original Data'!G24)","v":3074209}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F25=\"\",\"\",'Original Data'!F25)","v":"2013-09-30"},{"$f":"IF('Original Data'!G25=\"\",\"\",'Original Data'!G25)","v":2785466}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F26=\"\",\"\",'Original Data'!F26)","v":"2013-10-31"},{"$f":"IF('Original Data'!G26=\"\",\"\",'Original Data'!G26)","v":2515361}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F27=\"\",\"\",'Original Data'!F27)","v":"2013-11-30"},{"$f":"IF('Original Data'!G27=\"\",\"\",'Original Data'!G27)","v":3105958}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F28=\"\",\"\",'Original Data'!F28)","v":"2013-12-31"},{"$f":"IF('Original Data'!G28=\"\",\"\",'Original Data'!G28)","v":3139059}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F29=\"\",\"\",'Original Data'!F29)","v":"2014-01-31"},{"$f":"IF('Original Data'!G29=\"\",\"\",'Original Data'!G29)","v":3380355}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F30=\"\",\"\",'Original Data'!F30)","v":"2014-02-28"},{"$f":"IF('Original Data'!G30=\"\",\"\",'Original Data'!G30)","v":3612886}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F31=\"\",\"\",'Original Data'!F31)","v":"2014-03-31"},{"$f":"IF('Original Data'!G31=\"\",\"\",'Original Data'!G31)","v":3765824}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F32=\"\",\"\",'Original Data'!F32)","v":"2014-04-30"},{"$f":"IF('Original Data'!G32=\"\",\"\",'Original Data'!G32)","v":3771842}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F33=\"\",\"\",'Original Data'!F33)","v":"2014-05-31"},{"$f":"IF('Original Data'!G33=\"\",\"\",'Original Data'!G33)","v":3356365}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F34=\"\",\"\",'Original Data'!F34)","v":"2014-06-30"},{"$f":"IF('Original Data'!G34=\"\",\"\",'Original Data'!G34)","v":3490100}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F35=\"\",\"\",'Original Data'!F35)","v":"2014-07-31"},{"$f":"IF('Original Data'!G35=\"\",\"\",'Original Data'!G35)","v":3163659}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F36=\"\",\"\",'Original Data'!F36)","v":"2014-08-31"},{"$f":"IF('Original Data'!G36=\"\",\"\",'Original Data'!G36)","v":3167124}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F37=\"\",\"\",'Original Data'!F37)","v":"2014-09-30"},{"$f":"IF('Original Data'!G37=\"\",\"\",'Original Data'!G37)","v":2883810}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F38=\"\",\"\",'Original Data'!F38)","v":"2014-10-31"},{"$f":"IF('Original Data'!G38=\"\",\"\",'Original Data'!G38)","v":2610667}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F39=\"\",\"\",'Original Data'!F39)","v":"2014-11-30"},{"$f":"IF('Original Data'!G39=\"\",\"\",'Original Data'!G39)","v":3129205}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F40=\"\",\"\",'Original Data'!F40)","v":"2014-12-31"},{"$f":"IF('Original Data'!G40=\"\",\"\",'Original Data'!G40)","v":3200527}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F41=\"\",\"\",'Original Data'!F41)","v":"2015-01-31"},{"$f":"IF('Original Data'!G41=\"\",\"\",'Original Data'!G41)","v":3547804}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F42=\"\",\"\",'Original Data'!F42)","v":"2015-02-28"},{"$f":"IF('Original Data'!G42=\"\",\"\",'Original Data'!G42)","v":3766323}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F43=\"\",\"\",'Original Data'!F43)","v":"2015-03-31"},{"$f":"IF('Original Data'!G43=\"\",\"\",'Original Data'!G43)","v":3935589}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F44=\"\",\"\",'Original Data'!F44)","v":"2015-04-30"},{"$f":"IF('Original Data'!G44=\"\",\"\",'Original Data'!G44)","v":3917884}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F45=\"\",\"\",'Original Data'!F45)","v":"2015-05-31"},{"$f":"IF('Original Data'!G45=\"\",\"\",'Original Data'!G45)","v":3564970}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F46=\"\",\"\",'Original Data'!F46)","v":"2015-06-30"},{"$f":"IF('Original Data'!G46=\"\",\"\",'Original Data'!G46)","v":3602455}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F47=\"\",\"\",'Original Data'!F47)","v":"2015-07-31"},{"$f":"IF('Original Data'!G47=\"\",\"\",'Original Data'!G47)","v":3326859}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F48=\"\",\"\",'Original Data'!F48)","v":"2015-08-31"},{"$f":"IF('Original Data'!G48=\"\",\"\",'Original Data'!G48)","v":3441693}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F49=\"\",\"\",'Original Data'!F49)","v":"2015-09-30"},{"$f":"IF('Original Data'!G49=\"\",\"\",'Original Data'!G49)","v":3211600}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F50=\"\",\"\",'Original Data'!F50)","v":"2015-10-31"},{"$f":"IF('Original Data'!G50=\"\",\"\",'Original Data'!G50)","v":2998119}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F51=\"\",\"\",'Original Data'!F51)","v":"2015-11-30"},{"$f":"IF('Original Data'!G51=\"\",\"\",'Original Data'!G51)","v":3472440}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F52=\"\",\"\",'Original Data'!F52)","v":"2015-12-31"},{"$f":"IF('Original Data'!G52=\"\",\"\",'Original Data'!G52)","v":3563007}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F53=\"\",\"\",'Original Data'!F53)","v":"2016-01-31"},{"$f":"IF('Original Data'!G53=\"\",\"\",'Original Data'!G53)","v":3820570}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F54=\"\",\"\",'Original Data'!F54)","v":"2016-02-29"},{"$f":"IF('Original Data'!G54=\"\",\"\",'Original Data'!G54)","v":4107195}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F55=\"\",\"\",'Original Data'!F55)","v":"2016-03-31"},{"$f":"IF('Original Data'!G55=\"\",\"\",'Original Data'!G55)","v":4284443}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F56=\"\",\"\",'Original Data'!F56)","v":"2016-04-30"},{"$f":"IF('Original Data'!G56=\"\",\"\",'Original Data'!G56)","v":4356216}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F57=\"\",\"\",'Original Data'!F57)","v":"2016-05-31"},{"$f":"IF('Original Data'!G57=\"\",\"\",'Original Data'!G57)","v":3819379}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F58=\"\",\"\",'Original Data'!F58)","v":"2016-06-30"},{"$f":"IF('Original Data'!G58=\"\",\"\",'Original Data'!G58)","v":3844987}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F59=\"\",\"\",'Original Data'!F59)","v":"2016-07-31"},{"$f":"IF('Original Data'!G59=\"\",\"\",'Original Data'!G59)","v":3478890}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F60=\"\",\"\",'Original Data'!F60)","v":"2016-08-31"},{"$f":"IF('Original Data'!G60=\"\",\"\",'Original Data'!G60)","v":3443039}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F61=\"\",\"\",'Original Data'!F61)","v":"2016-09-30"},{"$f":"IF('Original Data'!G61=\"\",\"\",'Original Data'!G61)","v":3204637}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F62=\"\",\"\",'Original Data'!F62)","v":"2016-10-31"},{"$f":"IF('Original Data'!G62=\"\",\"\",'Original Data'!G62)","v":2966477}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F63=\"\",\"\",'Original Data'!F63)","v":"2016-11-30"},{"$f":"IF('Original Data'!G63=\"\",\"\",'Original Data'!G63)","v":3593364}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F64=\"\",\"\",'Original Data'!F64)","v":"2016-12-31"},{"$f":"IF('Original Data'!G64=\"\",\"\",'Original Data'!G64)","v":3604104}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F65=\"\",\"\",'Original Data'!F65)","v":"2017-01-31"},{"$f":"IF('Original Data'!G65=\"\",\"\",'Original Data'!G65)","v":3933016}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F66=\"\",\"\",'Original Data'!F66)","v":"2017-02-28"},{"$f":"IF('Original Data'!G66=\"\",\"\",'Original Data'!G66)","v":4146797}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F67=\"\",\"\",'Original Data'!F67)","v":"2017-03-31"},{"$f":"IF('Original Data'!G67=\"\",\"\",'Original Data'!G67)","v":4176486}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F68=\"\",\"\",'Original Data'!F68)","v":"2017-04-30"},{"$f":"IF('Original Data'!G68=\"\",\"\",'Original Data'!G68)","v":4347059}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F69=\"\",\"\",'Original Data'!F69)","v":"2017-05-31"},{"$f":"IF('Original Data'!G69=\"\",\"\",'Original Data'!G69)","v":3781168}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F70=\"\",\"\",'Original Data'!F70)","v":"2017-06-30"},{"$f":"IF('Original Data'!G70=\"\",\"\",'Original Data'!G70)","v":3858196.3569040108}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F71=\"\",\"\",'Original Data'!F71)","v":"2017-07-31"},{"$f":"IF('Original Data'!G71=\"\",\"\",'Original Data'!G71)","v":3562679.8147925721}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F72=\"\",\"\",'Original Data'!F72)","v":"2017-08-31"},{"$f":"'Raw Data from FORECAST.ETS'!C71","v":3645607.0770074413}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F73=\"\",\"\",'Original Data'!F73)","v":"2017-09-30"},{"$f":"'Raw Data from FORECAST.ETS'!C72","v":3377633.3103244333}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F74=\"\",\"\",'Original Data'!F74)","v":"2017-10-31"},{"$f":"'Raw Data from FORECAST.ETS'!C73","v":3121446.8870122023}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F75=\"\",\"\",'Original Data'!F75)","v":"2017-11-30"},{"$f":"'Raw Data from FORECAST.ETS'!C74","v":3648618.2922838}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F76=\"\",\"\",'Original Data'!F76)","v":"2017-12-31"},{"$f":"'Raw Data from FORECAST.ETS'!C75","v":3713964.7126519354}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F77=\"\",\"\",'Original Data'!F77)","v":"2018-01-31"},{"$f":"'Raw Data from FORECAST.ETS'!C76","v":3969863.2298377226}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F78=\"\",\"\",'Original Data'!F78)","v":"2018-02-28"},{"$f":"'Raw Data from FORECAST.ETS'!C77","v":4191434.3891396401}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F79=\"\",\"\",'Original Data'!F79)","v":"2018-03-31"},{"$f":"'Raw Data from FORECAST.ETS'!C78","v":4375439.8016566476}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F80=\"\",\"\",'Original Data'!F80)","v":"2018-04-30"},{"$f":"'Raw Data from FORECAST.ETS'!C79","v":4370864.0260059843}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F81=\"\",\"\",'Original Data'!F81)","v":"2018-05-31"},{"$f":"'Raw Data from FORECAST.ETS'!C80","v":3960763.8677016324}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F82=\"\",\"\",'Original Data'!F82)","v":"2018-06-30"},{"$f":"'Raw Data from FORECAST.ETS'!C81","v":4037068.375278627}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F83=\"\",\"\",'Original Data'!F83)","v":"2018-07-31"},{"$f":"'Raw Data from FORECAST.ETS'!C82","v":3740959.2437138385}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F84=\"\",\"\",'Original Data'!F84)","v":"2018-08-31"},{"$f":"'Raw Data from FORECAST.ETS'!C83","v":3811471.5156468856}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F85=\"\",\"\",'Original Data'!F85)","v":"2018-09-30"},{"$f":"'Raw Data from FORECAST.ETS'!C84","v":3543497.7489638776}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F86=\"\",\"\",'Original Data'!F86)","v":"2018-10-31"},{"$f":"'Raw Data from FORECAST.ETS'!C85","v":3287311.3256516466}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F87=\"\",\"\",'Original Data'!F87)","v":"2018-11-30"},{"$f":"'Raw Data from FORECAST.ETS'!C86","v":3814482.7309232438}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F88=\"\",\"\",'Original Data'!F88)","v":"2018-12-31"},{"$f":"'Raw Data from FORECAST.ETS'!C87","v":3879829.1512913792}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F89=\"\",\"\",'Original Data'!F89)","v":"2019-01-31"},{"$f":"'Raw Data from FORECAST.ETS'!C88","v":4135727.6684771669}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F90=\"\",\"\",'Original Data'!F90)","v":"2019-02-28"},{"$f":"'Raw Data from FORECAST.ETS'!C89","v":4357298.8277790844}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F91=\"\",\"\",'Original Data'!F91)","v":"2019-03-31"},{"$f":"'Raw Data from FORECAST.ETS'!C90","v":4541304.2402960919}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F92=\"\",\"\",'Original Data'!F92)","v":"2019-04-30"},{"$f":"'Raw Data from FORECAST.ETS'!C91","v":4536728.4646454286}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F93=\"\",\"\",'Original Data'!F93)","v":"2019-05-31"},{"$f":"'Raw Data from FORECAST.ETS'!C92","v":4126628.3063410767}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F94=\"\",\"\",'Original Data'!F94)","v":"2019-06-30"},{"$f":"'Raw Data from FORECAST.ETS'!C93","v":4202932.8139180709}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F95=\"\",\"\",'Original Data'!F95)","v":"2019-07-31"},{"$f":"'Raw Data from FORECAST.ETS'!C94","v":3906823.6823532823}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F96=\"\",\"\",'Original Data'!F96)","v":"2019-08-31"},{"$f":"'Raw Data from FORECAST.ETS'!C95","v":3977335.9542863299}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F97=\"\",\"\",'Original Data'!F97)","v":"2019-09-30"},{"$f":"'Raw Data from FORECAST.ETS'!C96","v":3709362.1876033219}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F98=\"\",\"\",'Original Data'!F98)","v":"2019-10-31"},{"$f":"'Raw Data from FORECAST.ETS'!C97","v":3453175.7642910909}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F99=\"\",\"\",'Original Data'!F99)","v":"2019-11-30"},{"$f":"'Raw Data from FORECAST.ETS'!C98","v":3980347.1695626881}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F100=\"\",\"\",'Original Data'!F100)","v":"2019-12-31"},{"$f":"'Raw Data from FORECAST.ETS'!C99","v":4045693.5899308235}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F101=\"\",\"\",'Original Data'!F101)","v":"2020-01-31"},{"$f":"'Raw Data from FORECAST.ETS'!C100","v":4301592.1071166107}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F102=\"\",\"\",'Original Data'!F102)","v":"2020-02-29"},{"$f":"'Raw Data from FORECAST.ETS'!C101","v":4523163.2664185287}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F103=\"\",\"\",'Original Data'!F103)","v":"2020-03-31"},{"$f":"'Raw Data from FORECAST.ETS'!C102","v":4707168.6789355362}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F104=\"\",\"\",'Original Data'!F104)","v":"2020-04-30"},{"$f":"'Raw Data from FORECAST.ETS'!C103","v":4702592.9032848729}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F105=\"\",\"\",'Original Data'!F105)","v":"2020-05-31"},{"$f":"'Raw Data from FORECAST.ETS'!C104","v":4292492.7449805215}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F106=\"\",\"\",'Original Data'!F106)","v":"2020-06-30"},{"$f":"'Raw Data from FORECAST.ETS'!C105","v":4368797.2525575152}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F107=\"\",\"\",'Original Data'!F107)","v":"2020-07-31"},{"$f":"'Raw Data from FORECAST.ETS'!C106","v":4072688.1209927266}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F108=\"\",\"\",'Original Data'!F108)","v":"2020-08-31"},{"$f":"'Raw Data from FORECAST.ETS'!C107","v":4143200.3929257737}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F109=\"\",\"\",'Original Data'!F109)","v":"2020-09-30"},{"$f":"'Raw Data from FORECAST.ETS'!C108","v":3875226.6262427657}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F110=\"\",\"\",'Original Data'!F110)","v":"2020-10-31"},{"$f":"'Raw Data from FORECAST.ETS'!C109","v":3619040.2029305347}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F111=\"\",\"\",'Original Data'!F111)","v":"2020-11-30"},{"$f":"'Raw Data from FORECAST.ETS'!C110","v":4146211.6082021319}]
[null,null,null,null,null,{"$f":"IF('Original Data'!F112=\"\",\"\",'Original Data'!F112)","v":"2020-12-31"},{"$f":"'Raw Data from FORECAST.ETS'!C111","v":4211558.0285702674}]

{"sheet":"Raw Data from FORECAST.ETS","index":7,"n_rows":111,"n_cols":6,"rows_kept":111,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Raw Data from FORECAST.ETS"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,"Error Checks:",null,{"$f":"Overall_Error_Check","v":0}]
[]
[{"$f":"MAX($B$5:$B5)+1","v":1},"Historical Information"]
[]
[null,"Key Inputs"]
[]
[]
["Date","Sales","Forecast(Sales)","Lower Confidence Bound(Sales)","Upper Confidence Bound(Sales)"]
["2012-09-30",2644539]
["2012-10-31",2359800]
["2012-11-30",2925918]
["2012-12-31",3024973]
["2013-01-31",3177100]
["2013-02-28",3419595]
["2013-03-31",3649702]
["2013-04-30",3650668]
["2013-05-31",3191526]
["2013-06-30",3249428]
["2013-07-31",2971484]
["2013-08-31",3074209]
["2013-09-30",2785466]
["2013-10-31",2515361]
["2013-11-30",3105958]
["2013-12-31",3139059]
["2014-01-31",3380355]
["2014-02-28",3612886]
["2014-03-31",3765824]
["2014-04-30",3771842]
["2014-05-31",3356365]
["2014-06-30",3490100]
["2014-07-31",3163659]
["2014-08-31",3167124]
["2014-09-30",2883810]
["2014-10-31",2610667]
["2014-11-30",3129205]
["2014-12-31",3200527]
["2015-01-31",3547804]
["2015-02-28",3766323]
["2015-03-31",3935589]
["2015-04-30",3917884]
["2015-05-31",3564970]
["2015-06-30",3602455]
["2015-07-31",3326859]
["2015-08-31",3441693]
["2015-09-30",3211600]
["2015-10-31",2998119]
["2015-11-30",3472440]
["2015-12-31",3563007]
["2016-01-31",3820570]
["2016-02-29",4107195]
["2016-03-31",4284443]
["2016-04-30",4356216]
["2016-05-31",3819379]
["2016-06-30",3844987]
["2016-07-31",3478890]
["2016-08-31",3443039]
["2016-09-30",3204637]
["2016-10-31",2966477]
["2016-11-30",3593364]
["2016-12-31",3604104]
["2017-01-31",3933016]
["2017-02-28",4146797]
["2017-03-31",4176486]
["2017-04-30",4347059]
["2017-05-31",3781168]
["2017-06-30",3858196.3569040108]
["2017-07-31",3562679.8147925721,3562679.8147925721,3562679.8147925721,3562679.8147925721]
["2017-08-31",null,{"$f":"_xlfn.FORECAST.ETS(A71,$B$12:$B$70,$A$12:$A$70,1,1)","v":3645607.0770074413},{"$f":"C71-_xlfn.FORECAST.ETS.CONFINT(A71,$B$12:$B$70,$A$12:$A$70,0.95,1,1)","v":3534039.2565370076},{"$f":"C71+_xlfn.FORECAST.ETS.CONFINT(A71,$B$12:$B$70,$A$12:$A$70,0.95,1,1)","v":3757174.897477875}]
["2017-10-01",null,3377633.3103244333,3252796.7461603354,3502469.8744885311]
["2017-10-31",null,3121446.8870122023,2984576.632553725,3258317.1414706795]
["2017-12-01",null,3648618.2922838,3500647.6875375388,3796588.8970300611]
["2017-12-31",null,3713964.7126519354,3555630.5957112345,3872298.8295926363]
["2018-01-31",null,3969863.2298377226,3801766.0269890795,4137960.4326863657]
["2018-03-03",null,4191434.3891396401,4014075.2737320303,4368793.5045472495]
["2018-03-31",null,4375439.8016566476,4189245.0753080077,4561634.5280052871]
["2018-05-01",null,4370864.0260059843,4176201.8689083089,4565526.1831036601]
["2018-05-31",null,3960763.8677016324,3757956.2776795812,4163571.4577236837]
["2018-07-01",null,4037068.375278627,3826399.9378972785,4247736.8126599761]
["2018-07-31",null,3740959.2437138385,3522683.738640279,3959234.748787398]
["2018-08-31",null,3811471.5156468856,3585788.6768169245,4037154.3544768468]
["2018-10-01",null,3543497.7489638776,3310643.0917856647,3776352.4061420904]
["2018-10-31",null,3287311.3256516466,3047472.5311471741,3527150.1201561191]
["2018-12-01",null,3814482.7309232438,3567831.4860927463,4061133.9757537413]
["2018-12-31",null,3879829.1512913792,3626523.2414796124,4133135.0611031461]
["2019-01-31",null,4135727.6684771669,3875912.7067226251,4395542.6302317083]
["2019-03-03",null,4357298.8277790844,4091109.698232004,4623487.9573261645]
["2019-03-31",null,4541304.2402960919,4268866.3136910042,4813742.1669011796]
["2019-05-01",null,4536728.4646454286,4258158.6300656376,4815298.2992252195]
["2019-05-31",null,4126628.3063410767,3842035.8534569787,4411220.7592251748]
["2019-07-01",null,4202932.8139180709,3912420.1924195155,4493445.4354166258]
["2019-07-31",null,3906823.6823532823,3610487.1596857323,4203160.2050208319]
["2019-08-31",null,3977335.9542863299,3675244.5350463698,4279427.3735262901]
["2019-10-01",null,3709362.1876033219,3401623.4729603129,4017100.9022463309]
["2019-10-31",null,3453175.7642910909,3139870.6183207803,3766480.9102614014]
["2019-12-01",null,3980347.1695626881,3661552.1814006884,4299142.1577246878]
["2019-12-31",null,4045693.5899308235,3721481.4196748566,4369905.7601867905]
["2020-01-31",null,4301592.1071166107,3972031.7940010009,4631152.4202322206]
["2020-03-02",null,4523163.2664185287,4188320.5043819421,4858006.0284551149]
["2020-03-31",null,4707168.6789355362,4367106.063878933,5047231.2939921394]
["2020-05-01",null,4702592.9032848729,4357370.1556448136,5047815.6509249322]
["2020-05-31",null,4292492.7449805215,3942166.9106917875,4642818.5792692555]
["2020-07-01",null,4368797.2525575152,4013422.8850241657,4724171.6200908646]
["2020-07-31",null,4072688.1209927266,3712317.446309282,4433058.7956761718]
["2020-08-31",null,4143200.3929257737,3777865.1465929965,4508535.6392585505]
["2020-10-01",null,3875226.6262427657,3504993.373746099,4245459.8787394324]
["2020-10-31",null,3619040.2029305347,3243955.0311065814,3994125.374754488]
["2020-12-01",null,4146211.6082021319,3766318.8052805453,4526104.4111237181]
["2020-12-31",null,4211558.0285702674,3826900.1898131943,4596215.8673273409]

{"sheet":"Model Parameters","index":8,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"General"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[null,null,null,null,"Model Name",null,{"$f":"IF(ISERROR(OR(FIND(\"[\",CELL(\"filename\",A1)),FIND(\"]\",CELL(\"filename\",A1)))),\"\",MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1))","v":"SP Forecasting Examples.xlsm"}]
[null,null,null,null,"Client Name",null,"ICAEW"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]

{"sheet":"Error Checks","index":9,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Error Checks"}]
[{"$f":"Model_Name","v":"SP Forecasting Examples.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Error Checks"]
[]
[null,null,"Summary of Errors"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"No checks in this model"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]