{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Changing Forecast Periods (x>y)","Changing Forecast Periods (x<y)","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":39,"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":[[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct Pty Limited"}]
[null,null,{"$f":"Model_Name","v":"SP Changing Forecast Periods with Two Scenarios.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"High level example to show how forecasts may be modified when period start, end and / or duration change(s)."]
[]
[]
[]
[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":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP Changing Forecast Periods with Two Scenarios.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,"Model Parameters"]
[null,null,null,null,null,"Changing Forecast Periods (x>y)"]
[null,null,null,null,null,"Changing Forecast Periods (x<y)"]
[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 Changing Forecast Periods with Two Scenarios.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":"Periods Chosen Correctly (x<y)"},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":"2019-09-19"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2019-09-19"},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":"Model Parameters","index":3,"n_rows":38,"n_cols":9,"rows_kept":38,"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 Changing Forecast Periods with Two Scenarios.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 Changing Forecast Periods with Two Scenarios.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Pty Limited"]
[]
[]
[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,"Rounding Adjustment",null,{"$f":"LEN(MAX(LU_Periods))","v":2}]
[]
[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]
[]
[null,null,null,null,"Number",null,"#"]
[null,null,null,null,"Currency",null,"$"]
[null,null,null,null,"Multiple",null,"x"]
[null,null,null,null,"Boolean",null,"[1,0]"]
[null,null,null,null,"Percentage",null,"%"]

{"sheet":"Changing Forecast Periods (x>y)","index":4,"n_rows":123,"n_cols":25,"rows_kept":123,"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":"Changing Forecast Periods (x>y)"}]
[{"$f":"Model_Name","v":"SP Changing Forecast Periods with Two Scenarios.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Original Forecast"]
[]
[null,null,{"$f":"C6","v":"Original Forecast"}]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"Period",{"$f":"Number","v":"#"},null,null,"Total",{"$f":"N(I12)+1","v":1},{"$f":"N(J12)+1","v":2},3,4,5,6,7,8,9,10,11,12,13,{"$f":"N(V12)+1","v":14},15]
[null,null,null,null,"Forecast",{"$f":"Currency","v":"$"},null,null,{"$f":"SUM(J13:X13)","v":36},1,2,3,4,5,6,7,8]
[]
[null,null,null,null,null,null,"Period"]
[null,null,null,null,"Start Period",{"$f":"Number","v":"#"},{"$f":"MIN(IF(LU_Original_Forecast_Data<>0,LU_Periods))","v":1},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(G16),\"\")","v":"{=MIN(IF(LU_Original_Forecast_Data<>0,LU_Periods))}"}]
[null,null,null,null,"End Period",{"$f":"Number","v":"#"},{"$f":"MAX(IF(LU_Original_Forecast_Data<>0,LU_Periods))","v":8},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(G17),\"\")","v":"{=MAX(IF(LU_Original_Forecast_Data<>0,LU_Periods))}"}]
[]
[]
[null,{"$f":"MAX($B$5:$B19)+1","v":2},"Revised Forecast"]
[]
[null,null,{"$f":"C20","v":"Revised Forecast"}]
[]
[null,null,null,{"$f":"D10","v":"Assumptions"}]
[]
[null,null,null,null,null,null,"Period","Check"]
[null,null,null,null,{"$f":"E16","v":"Start Period"},{"$f":"Number","v":"#"},4]
[null,null,null,null,{"$f":"E17","v":"End Period"},{"$f":"Number","v":"#"},6,{"$f":"(N(G28)<N(G27))*1","v":0}]
[]
[]
[null,null,null,{"$f":"C22","v":"Revised Forecast"}]
[]
[null,null,null,null,{"$f":"E12","v":"Period"},{"$f":"Number","v":"#"},null,null,"Total",{"$f":"N(I33)+1","v":1},{"$f":"N(J33)+1","v":2},3,4,5,6,7,8,9,10,11,12,13,{"$f":"N(V33)+1","v":14},{"$f":"N(W33)+1","v":15}]
[null,null,null,null,{"$f":"E13","v":"Forecast"},{"$f":"Currency","v":"$"},null,null,{"$f":"SUM(J34:X34)","v":36.000029999999995},{"$f":"J77","v":0},{"$f":"K77","v":0},0,5,12.00001,19.000019999999999,0,0,0,0,0,0,0,0,0]
[]
[]
[null,{"$f":"MAX($B$5:$B36)+1","v":3},"Calculations"]
[]
[null,null,"Referred Values"]
[]
[null,null,null,{"$f":"C6","v":"Original Forecast"}]
[]
[null,null,null,null,{"$f":"E12","v":"Period"},{"$f":"Number","v":"#"},null,null,{"$f":"I12","v":"Total"},{"$f":"J$12","v":1},{"$f":"K$12","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,{"$f":"E13","v":"Forecast"},{"$f":"Currency","v":"$"},null,null,{"$f":"I13","v":36},{"$f":"J13","v":1},{"$f":"K13","v":2},3,4,5,6,7,8,0,0,0,0,0,0,0]
[]
[]
[null,null,null,"Other Key Data"]
[]
[null,null,null,null,null,null,"Original","Revised"]
[null,null,null,null,{"$f":"E16","v":"Start Period"},{"$f":"Number","v":"#"},{"$f":"G16","v":1},{"$f":"G27","v":4}]
[null,null,null,null,{"$f":"E17","v":"End Period"},{"$f":"Number","v":"#"},{"$f":"G17","v":8},{"$f":"G28","v":6}]
[]
[null,null,null,null,"No. of Periods",{"$f":"Number","v":"#"},{"$f":"G51-G50+1","v":8},{"$f":"H51-H50+1","v":3}]
[]
[null,null,null,null,"Period Factor",{"$f":"Multiple","v":"x"},null,{"$f":"IF(H53,G53/H53,)","v":2.6666666666666665}]
[]
[]
[null,null,{"$f":"C37","v":"Calculations"}]
[]
[null,null,null,"Forecast Allocation"]
[]
[null,null,null,null,{"$f":"E12","v":"Period"},{"$f":"Number","v":"#"},null,null,null,{"$f":"J$12","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,"Revised Flag",{"$f":"Boolean","v":"[1,0]"},null,null,null,{"$f":"AND(J$62>=$H$50,J$62<=$H$51)*1","v":0},0,0,1,1,1,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(_xlfn.FORMULATEXT(J63),\"\")","v":"=AND(J$62>=$H$50,J$62<=$H$51)*1"}]
[null,null,null,null,"Start",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(J$63,I65+($G$50-1)*(J$62=$H$50),)","v":0},{"$f":"IF(K$63,J65+($G$50-1)*(K$62=$H$50),)","v":0},0,0,2.6666666666666665,5.333333333333333,0,0,0,0,0,0,0,0,0,"=IF(J$63,I65+($G$50-1)*(J$62=$H$50),)"]
[null,null,null,null,"End",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(J$63,J64+Period_Factor,)","v":0},0,0,2.6666666666666665,5.333333333333333,8,0,0,0,0,0,0,0,0,0,"=IF(J$63,J64+Period_Factor,)"]
[]
[null,null,null,null,"Start Part Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(ROUNDUP(J$64,0)-J64,ROUNDUP(J$64,0),)","v":0},{"$f":"IF(ROUNDUP(K$64,0)-K64,ROUNDUP(K$64,0),)","v":0},0,0,3,6,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(_xlfn.FORMULATEXT(J67),\"\")","v":"=IF(ROUNDUP(J$64,0)-J64,ROUNDUP(J$64,0),)"}]
[null,null,null,null,"Start Full Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(J$64,ROUNDUP(J$64,0)+1,)","v":0},{"$f":"IF(K$64,ROUNDUP(K$64,0)+1,)","v":0},0,0,4,7,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(_xlfn.FORMULATEXT(J68),\"\")","v":"=IF(J$64,ROUNDUP(J$64,0)+1,)"}]
[null,null,null,null,"End Full Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"ROUNDDOWN(J$65,0)","v":0},{"$f":"ROUNDDOWN(K$65,0)","v":0},0,2,5,8,0,0,0,0,0,0,0,0,0,"=ROUNDDOWN(J$65,0)"]
[null,null,null,null,"End Part Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(ROUNDUP(J$65,0)-J65,ROUNDUP(J$65,0),)","v":0},{"$f":"IF(ROUNDUP(K$65,0)-K65,ROUNDUP(K$65,0),)","v":0},0,3,6,0,0,0,0,0,0,0,0,0,0,"=IF(ROUNDUP(J$65,0)-J65,ROUNDUP(J$65,0),)"]
[]
[null,null,null,null,"Start Part %",{"$f":"Percentage","v":"%"},null,null,null,{"$f":"MIN(MOD(ROUND(J67-J64,Rounding_Accuracy),1),Period_Factor)*J$63","v":0},0,0,0,0.33333000000000002,0.66666999999999998,0,0,0,0,0,0,0,0,0,"=MIN(MOD(ROUND(J67-J64,Rounding_Accuracy),1),Period_Factor)*J$63"]
[null,null,null,null,"Full Part %",{"$f":"Percentage","v":"%"},null,null,null,{"$f":"MIN(IF(AND(J$69>=J$68,J$68*J$69<>0),MIN(Period_Factor,1)*(J$69-J$68+1),),Period_Factor-J$72)","v":0},0,0,0,2,1.9999966666666666,0,0,0,0,0,0,0,0,0,"=MIN(IF(AND(J$69>=J$68,J$68*J$69<>0),MIN(Period_Factor,1)*(J$69-J$68+1),),Period_Factor-J$72)"]
[null,null,null,null,"End Part %",{"$f":"Percentage","v":"%"},null,null,null,{"$f":"MOD((Period_Factor-SUM(J72:J73))*J$63,1)","v":0},0,0,0.66666666666666652,0.33333666666666639,0,0,0,0,0,0,0,0,0,0,"=MOD((Period_Factor-SUM(J72:J73))*J$63,1)"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J$12","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,{"$f":"C20","v":"Revised Forecast"},{"$f":"Currency","v":"$"},null,null,null,{"$f":"(SUMIF(LU_Periods,J$67,LU_Original_Forecast_Data)*J$72)\n+(SUMIFS(LU_Original_Forecast_Data,LU_Periods,\">=\"&J$68,LU_Periods,\"<=\"&J$69)*MIN(Period_Factor,1))\n+(SUMIF(LU_Periods,J$70,LU_Original_Forecast_Data)*J$74)","v":0},0,0,5,12.00001,19.000019999999999,0,0,0,0,0,0,0,0,0,"=(SUMIF(LU_Periods,J$67,LU_Original_Forecast_Data)*J$72)\n+(SUMIFS(LU_Original_Forecast_Data,LU_Periods,\">=\"&J$68,LU_Periods,\"<=\"&J$69)*MIN(Period_Factor,1))\n+(SUMIF(LU_Periods,J$70,LU_Original_Forecast_Data)*J$74)"]
[]
[]
[null,{"$f":"MAX($B$5:$B79)+1","v":4},"Error Checks"]
[]
[null,null,"Scenario Reconciliation"]
[]
[null,null,null,"Raw Data"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I34","v":36.000029999999995},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,null,1,36,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2,36,36,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,3,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,4,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,5,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,6,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,7,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,8,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,9,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,10,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0]
[null,null,null,null,null,null,null,null,11,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0]
[null,null,null,null,null,null,null,null,12,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0]
[null,null,null,null,null,null,null,null,13,35.999996153846155,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0]
[null,null,null,null,null,null,null,null,14,36.000005714285713,35.999996153846155,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0]
[null,null,null,null,null,null,null,null,15,35.999996666666668,36.000005714285713,35.999996153846155,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36]
[]
[]
[null,null,null,{"$f":"C80","v":"Error Checks"}]
[]
[null,null,null,null,"Overall",{"$f":"MIN(SUM(J109:X123),1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,null,1,{"$f":"J87*(ROUND($I$13-J87,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Changing Forecast Periods (x<y)","index":5,"n_rows":123,"n_cols":25,"rows_kept":123,"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":"Changing Forecast Periods (x<y)"}]
[{"$f":"Model_Name","v":"SP Changing Forecast Periods with Two Scenarios.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Original Forecast"]
[]
[null,null,{"$f":"C6","v":"Original Forecast"}]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"Period",{"$f":"Number","v":"#"},null,null,"Total",{"$f":"N(I12)+1","v":1},{"$f":"N(J12)+1","v":2},3,4,5,6,7,8,9,10,11,12,13,{"$f":"N(V12)+1","v":14},15]
[null,null,null,null,"Forecast",{"$f":"Currency","v":"$"},null,null,{"$f":"SUM(J13:X13)","v":36},1,2,3,4,5,6,7,8]
[]
[null,null,null,null,null,null,"Period"]
[null,null,null,null,"Start Period",{"$f":"Number","v":"#"},{"$f":"MIN(IF(LU_Original_Forecast_Data<>0,LU_Periods))","v":1},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(G16),\"\")","v":"{=MIN(IF(LU_Original_Forecast_Data<>0,LU_Periods))}"}]
[null,null,null,null,"End Period",{"$f":"Number","v":"#"},{"$f":"MAX(IF(LU_Original_Forecast_Data<>0,LU_Periods))","v":8},null,{"$f":"IFERROR(_xlfn.FORMULATEXT(G17),\"\")","v":"{=MAX(IF(LU_Original_Forecast_Data<>0,LU_Periods))}"}]
[]
[]
[null,{"$f":"MAX($B$5:$B19)+1","v":2},"Revised Forecast"]
[]
[null,null,{"$f":"C20","v":"Revised Forecast"}]
[]
[null,null,null,{"$f":"D10","v":"Assumptions"}]
[]
[null,null,null,null,null,null,"Period","Check"]
[null,null,null,null,{"$f":"E16","v":"Start Period"},{"$f":"Number","v":"#"},1]
[null,null,null,null,{"$f":"E17","v":"End Period"},{"$f":"Number","v":"#"},15,{"$f":"(N(G28)<N(G27))*1","v":0}]
[]
[]
[null,null,null,{"$f":"C22","v":"Revised Forecast"}]
[]
[null,null,null,null,{"$f":"E12","v":"Period"},{"$f":"Number","v":"#"},null,null,"Total",{"$f":"N(I33)+1","v":1},{"$f":"N(J33)+1","v":2},3,4,5,6,7,8,9,10,11,12,13,{"$f":"N(V33)+1","v":14},{"$f":"N(W33)+1","v":15}]
[null,null,null,null,{"$f":"E13","v":"Forecast"},{"$f":"Currency","v":"$"},null,null,{"$f":"SUM(J34:X34)","v":35.999996666666668},{"$f":"J77","v":0.53333333333333333},{"$f":"K77","v":0.59999666666666673},1.0666666666666667,1.2,1.6,1.8000033333333332,2.1333333333333333,2.3999966666666666,2.6666666666666665,3,3.2,3.6000033333333334,3.7333333333333334,4.1999966666666664,4.2666666666666666]
[]
[]
[null,{"$f":"MAX($B$5:$B36)+1","v":3},"Calculations"]
[]
[null,null,"Referred Values"]
[]
[null,null,null,{"$f":"C6","v":"Original Forecast"}]
[]
[null,null,null,null,{"$f":"E12","v":"Period"},{"$f":"Number","v":"#"},null,null,{"$f":"I12","v":"Total"},{"$f":"J$12","v":1},{"$f":"K$12","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,{"$f":"E13","v":"Forecast"},{"$f":"Currency","v":"$"},null,null,{"$f":"I13","v":36},{"$f":"J13","v":1},{"$f":"K13","v":2},3,4,5,6,7,8,0,0,0,0,0,0,0]
[]
[]
[null,null,null,"Other Key Data"]
[]
[null,null,null,null,null,null,"Original","Revised"]
[null,null,null,null,{"$f":"E16","v":"Start Period"},{"$f":"Number","v":"#"},{"$f":"G16","v":1},{"$f":"G27","v":1}]
[null,null,null,null,{"$f":"E17","v":"End Period"},{"$f":"Number","v":"#"},{"$f":"G17","v":8},{"$f":"G28","v":15}]
[]
[null,null,null,null,"No. of Periods",{"$f":"Number","v":"#"},{"$f":"G51-G50+1","v":8},{"$f":"H51-H50+1","v":15}]
[]
[null,null,null,null,"Period Factor",{"$f":"Multiple","v":"x"},null,{"$f":"IF(H53,G53/H53,)","v":0.53333333333333333}]
[]
[]
[null,null,{"$f":"C37","v":"Calculations"}]
[]
[null,null,null,"Forecast Allocation"]
[]
[null,null,null,null,{"$f":"E12","v":"Period"},{"$f":"Number","v":"#"},null,null,null,{"$f":"J$12","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,"Revised Flag",{"$f":"Boolean","v":"[1,0]"},null,null,null,{"$f":"AND(J$62>=$H$50,J$62<=$H$51)*1","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IFERROR(_xlfn.FORMULATEXT(J63),\"\")","v":"=AND(J$62>=$H$50,J$62<=$H$51)*1"}]
[null,null,null,null,"Start",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(J$63,I65+($G$50-1)*(J$62=$H$50),)","v":0},{"$f":"IF(K$63,J65+($G$50-1)*(K$62=$H$50),)","v":0.53333333333333333},1.0666666666666667,1.6,2.1333333333333333,2.6666666666666665,3.1999999999999997,3.7333333333333329,4.2666666666666666,4.8,5.333333333333333,5.8666666666666663,6.3999999999999995,6.9333333333333327,7.4666666666666659,"=IF(J$63,I65+($G$50-1)*(J$62=$H$50),)"]
[null,null,null,null,"End",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(J$63,J64+Period_Factor,)","v":0.53333333333333333},1.0666666666666667,1.6,2.1333333333333333,2.6666666666666665,3.1999999999999997,3.7333333333333329,4.2666666666666666,4.8,5.333333333333333,5.8666666666666663,6.3999999999999995,6.9333333333333327,7.4666666666666659,7.9999999999999991,"=IF(J$63,J64+Period_Factor,)"]
[]
[null,null,null,null,"Start Part Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(ROUNDUP(J$64,0)-J64,ROUNDUP(J$64,0),)","v":0},{"$f":"IF(ROUNDUP(K$64,0)-K64,ROUNDUP(K$64,0),)","v":1},2,2,3,3,4,4,5,5,6,6,7,7,8,{"$f":"IFERROR(_xlfn.FORMULATEXT(J67),\"\")","v":"=IF(ROUNDUP(J$64,0)-J64,ROUNDUP(J$64,0),)"}]
[null,null,null,null,"Start Full Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(J$64,ROUNDUP(J$64,0)+1,)","v":0},{"$f":"IF(K$64,ROUNDUP(K$64,0)+1,)","v":2},3,3,4,4,5,5,6,6,7,7,8,8,9,{"$f":"IFERROR(_xlfn.FORMULATEXT(J68),\"\")","v":"=IF(J$64,ROUNDUP(J$64,0)+1,)"}]
[null,null,null,null,"End Full Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"ROUNDDOWN(J$65,0)","v":0},{"$f":"ROUNDDOWN(K$65,0)","v":1},1,2,2,3,3,4,4,5,5,6,6,7,8,"=ROUNDDOWN(J$65,0)"]
[null,null,null,null,"End Part Period",{"$f":"Number","v":"#"},null,null,null,{"$f":"IF(ROUNDUP(J$65,0)-J65,ROUNDUP(J$65,0),)","v":1},{"$f":"IF(ROUNDUP(K$65,0)-K65,ROUNDUP(K$65,0),)","v":2},2,3,3,4,4,5,5,6,6,7,7,8,8,"=IF(ROUNDUP(J$65,0)-J65,ROUNDUP(J$65,0),)"]
[]
[null,null,null,null,"Start Part %",{"$f":"Percentage","v":"%"},null,null,null,{"$f":"MIN(MOD(ROUND(J67-J64,Rounding_Accuracy),1),Period_Factor)*J$63","v":0},0.46666999999999997,0.53333333333333333,0.4,0.53333333333333333,0.33333000000000002,0.53333333333333333,0.26667000000000002,0.53333333333333333,0.2,0.53333333333333333,0.13333,0.53333333333333333,6.6669999999999993E-2,0.53332999999999997,"=MIN(MOD(ROUND(J67-J64,Rounding_Accuracy),1),Period_Factor)*J$63"]
[null,null,null,null,"Full Part %",{"$f":"Percentage","v":"%"},null,null,null,{"$f":"MIN(IF(AND(J$69>=J$68,J$68*J$69<>0),MIN(Period_Factor,1)*(J$69-J$68+1),),Period_Factor-J$72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,"=MIN(IF(AND(J$69>=J$68,J$68*J$69<>0),MIN(Period_Factor,1)*(J$69-J$68+1),),Period_Factor-J$72)"]
[null,null,null,null,"End Part %",{"$f":"Percentage","v":"%"},null,null,null,{"$f":"MOD((Period_Factor-SUM(J72:J73))*J$63,1)","v":0.53333333333333333},6.6663333333333352E-2,0,0.1333333333333333,0,0.20000333333333331,0,0.26666333333333331,0,0.33333333333333331,0,0.40000333333333332,0,0.46666333333333332,3.3333333333551707E-6,"=MOD((Period_Factor-SUM(J72:J73))*J$63,1)"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J$12","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,{"$f":"C20","v":"Revised Forecast"},{"$f":"Currency","v":"$"},null,null,null,{"$f":"(SUMIF(LU_Periods,J$67,LU_Original_Forecast_Data)*J$72)\n+(SUMIFS(LU_Original_Forecast_Data,LU_Periods,\">=\"&J$68,LU_Periods,\"<=\"&J$69)*MIN(Period_Factor,1))\n+(SUMIF(LU_Periods,J$70,LU_Original_Forecast_Data)*J$74)","v":0.53333333333333333},0.59999666666666673,1.0666666666666667,1.2,1.6,1.8000033333333332,2.1333333333333333,2.3999966666666666,2.6666666666666665,3,3.2,3.6000033333333334,3.7333333333333334,4.1999966666666664,4.2666666666666666,"=(SUMIF(LU_Periods,J$67,LU_Original_Forecast_Data)*J$72)\n+(SUMIFS(LU_Original_Forecast_Data,LU_Periods,\">=\"&J$68,LU_Periods,\"<=\"&J$69)*MIN(Period_Factor,1))\n+(SUMIF(LU_Periods,J$70,LU_Original_Forecast_Data)*J$74)"]
[]
[]
[null,{"$f":"MAX($B$5:$B79)+1","v":4},"Error Checks"]
[]
[null,null,"Scenario Reconciliation"]
[]
[null,null,null,"Raw Data"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I34","v":35.999996666666668},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,null,1,36,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2,36,36,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,3,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,4,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,5,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,6,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,7,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,8,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,9,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,10,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0,0]
[null,null,null,null,null,null,null,null,11,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0,0]
[null,null,null,null,null,null,null,null,12,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0,0]
[null,null,null,null,null,null,null,null,13,35.999996153846155,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0,0]
[null,null,null,null,null,null,null,null,14,36.000005714285713,35.999996153846155,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36,0]
[null,null,null,null,null,null,null,null,15,35.999996666666668,36.000005714285713,35.999996153846155,36.000013333333335,35.999994545454548,36.000000000000007,36.000001111111104,36,36.000022857142852,35.999986666666665,36,36,36.000029999999995,36,36]
[]
[]
[null,null,null,{"$f":"C80","v":"Error Checks"}]
[]
[null,null,null,null,"Overall",{"$f":"MIN(SUM(J109:X123),1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,null,null,1,{"$f":"J87*(ROUND($I$13-J87,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,2,{"$f":"J88*(ROUND($I$13-J88,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,3,{"$f":"J89*(ROUND($I$13-J89,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,4,{"$f":"J90*(ROUND($I$13-J90,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,5,{"$f":"J91*(ROUND($I$13-J91,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,6,{"$f":"J92*(ROUND($I$13-J92,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,7,{"$f":"J93*(ROUND($I$13-J93,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,8,{"$f":"J94*(ROUND($I$13-J94,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,9,{"$f":"J95*(ROUND($I$13-J95,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,10,{"$f":"J96*(ROUND($I$13-J96,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,11,{"$f":"J97*(ROUND($I$13-J97,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,12,{"$f":"J98*(ROUND($I$13-J98,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,13,{"$f":"J99*(ROUND($I$13-J99,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,14,{"$f":"J100*(ROUND($I$13-J100,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,15,{"$f":"J101*(ROUND($I$13-J101,Rounding_Accuracy-Rounding_Adjustment)<>0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Error Checks","index":6,"n_rows":18,"n_cols":9,"rows_kept":18,"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 Changing Forecast Periods with Two Scenarios.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,"Periods Chosen Correctly (x<y)",null,null,null,{"$f":"HL_Period_Check","v":0}]
[null,null,null,null,"Alternative Scenarios Reconcile (x<y)",null,null,null,{"$f":"HL_Reconciliation_Check","v":0}]
[null,null,null,null,"Periods Chosen Correctly (x>y)",null,null,null,{"$f":"HL_Period_Check2","v":0}]
[null,null,null,null,"Alternative Scenarios Reconcile (x>y)",null,null,null,{"$f":"HL_Reconciliation_Check2","v":0}]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I16))","v":0}]