{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Timing","Assumptions","Outputs","Lookup Data","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":41,"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":"SumProduct Pty Limited"}]
[null,null,{"$f":"Model_Name","v":"SP Aggregating Time Periods.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple example showing how to sum up multiple periods in an output sheet."]
[]
[]
[]
[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":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP Aggregating Time Periods.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,"Timing"]
[null,null,null,null,null,"Assumptions"]
[null,null,null,null,null,"Outputs"]
[null,null,null,null,null,"Lookup Data"]
[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":[[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],[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],[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],[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],[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],[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]]}
[{"$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 Aggregating Time Periods.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":"Not Used"},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":"2018-09-02"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2018-09-02"},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":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 Aggregating Time Periods.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 Aggregating Time Periods.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,"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":"Timing","index":4,"n_rows":23,"n_cols":69,"rows_kept":23,"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":"Timing"}]
[{"$f":"Model_Name","v":"SP Aggregating Time Periods.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J$7","v":"2019-01-31"},{"$f":"K$7","v":"2019-02-28"},{"$f":"L$7","v":"2019-03-31"},{"$f":"M$7","v":"2019-04-30"},{"$f":"N$7","v":"2019-05-31"},{"$f":"O$7","v":"2019-06-30"},"2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31","2021-11-30","2021-12-31","2022-01-31","2022-02-28","2022-03-31","2022-04-30","2022-05-31","2022-06-30","2022-07-31","2022-08-31","2022-09-30","2022-10-31","2022-11-30","2022-12-31","2023-01-31","2023-02-28","2023-03-31","2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2019-01-01"},"2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01",{"$f":"IF(AP$9=1,Model_Start_Date,AO$7+1)","v":"2021-09-01"},"2021-10-01","2021-11-01","2021-12-01","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01"]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"EOMONTH(J$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(J$6),Periodicity))","v":"2019-01-31"},"2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-01-31","2020-02-29","2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31",{"$f":"EOMONTH(AP$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(AP$6),Periodicity))","v":"2021-09-30"},"2021-10-31","2021-11-30","2021-12-31","2022-01-31","2022-02-28","2022-03-31","2022-04-30","2022-05-31","2022-06-30","2022-07-31","2022-08-31","2022-09-30","2022-10-31","2022-11-30","2022-12-31","2023-01-31","2023-02-28","2023-03-31","2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":31},{"$f":"K7-K6+1","v":28},31,30,31,{"$f":"O7-O6+1","v":30},31,31,30,31,30,31,31,29,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,{"$f":"AO7-AO6+1","v":31},30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"N(I$9)+1","v":1},{"$f":"N(J$9)+1","v":2},3,4,5,{"$f":"N(N$9)+1","v":6},{"$f":"N(O$9)+1","v":7},{"$f":"N(P$9)+1","v":8},{"$f":"N(Q$9)+1","v":9},{"$f":"N(R$9)+1","v":10},{"$f":"N(S$9)+1","v":11},{"$f":"N(T$9)+1","v":12},{"$f":"N(U$9)+1","v":13},{"$f":"N(V$9)+1","v":14},{"$f":"N(W$9)+1","v":15},{"$f":"N(X$9)+1","v":16},{"$f":"N(Y$9)+1","v":17},{"$f":"N(Z$9)+1","v":18},{"$f":"N(AA$9)+1","v":19},{"$f":"N(AB$9)+1","v":20},{"$f":"N(AC$9)+1","v":21},{"$f":"N(AD$9)+1","v":22},{"$f":"N(AE$9)+1","v":23},{"$f":"N(AF$9)+1","v":24},{"$f":"N(AG$9)+1","v":25},{"$f":"N(AH$9)+1","v":26},{"$f":"N(AI$9)+1","v":27},{"$f":"N(AJ$9)+1","v":28},{"$f":"N(AK$9)+1","v":29},{"$f":"N(AL$9)+1","v":30},{"$f":"N(AM$9)+1","v":31},{"$f":"N(AN$9)+1","v":32},{"$f":"N(AO$9)+1","v":33},{"$f":"N(AP$9)+1","v":34},{"$f":"N(AQ$9)+1","v":35},{"$f":"N(AR$9)+1","v":36},{"$f":"N(AS$9)+1","v":37},{"$f":"N(AT$9)+1","v":38},{"$f":"N(AU$9)+1","v":39},{"$f":"N(AV$9)+1","v":40},{"$f":"N(AW$9)+1","v":41},{"$f":"N(AX$9)+1","v":42},{"$f":"N(AY$9)+1","v":43},{"$f":"N(AZ$9)+1","v":44},{"$f":"N(BA$9)+1","v":45},{"$f":"N(BB$9)+1","v":46},{"$f":"N(BC$9)+1","v":47},{"$f":"N(BD$9)+1","v":48},{"$f":"N(BE$9)+1","v":49},{"$f":"N(BF$9)+1","v":50},{"$f":"N(BG$9)+1","v":51},{"$f":"N(BH$9)+1","v":52},{"$f":"N(BI$9)+1","v":53},{"$f":"N(BJ$9)+1","v":54},{"$f":"N(BK$9)+1","v":55},{"$f":"N(BL$9)+1","v":56},{"$f":"N(BM$9)+1","v":57},{"$f":"N(BN$9)+1","v":58},{"$f":"N(BO$9)+1","v":59},{"$f":"N(BP$9)+1","v":60}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Timing Assumptions"]
[]
[null,null,"Data (do not change once modelling has commenced)"]
[]
[null,null,null,"Model Start Date",null,null,null,{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2019-01-01"}]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,1]
[]
[null,null,null,"Example Reporting Month",null,null,null,12,{"$f":"\"e.g. \"&TEXT(DATE(YEAR(Model_Start_Date)+IF(Example_Reporting_Month<MONTH(Model_Start_Date),1,0),Example_Reporting_Month+1,1)-1,\"dd-Mmm-yy\")","v":"e.g. 31-Dec-19"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":1}]
[]
[null,null,null,"Months per Year",null,null,null,12]

{"sheet":"Assumptions","index":5,"n_rows":46,"n_cols":69,"rows_kept":46,"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":"Assumptions"}]
[{"$f":"Model_Name","v":"SP Aggregating Time Periods.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2019-01-31"},{"$f":"Timing!K5","v":"2019-02-28"},{"$f":"Timing!L5","v":"2019-03-31"},{"$f":"Timing!M5","v":"2019-04-30"},{"$f":"Timing!N5","v":"2019-05-31"},{"$f":"Timing!O5","v":"2019-06-30"},{"$f":"Timing!P5","v":"2019-07-31"},{"$f":"Timing!Q5","v":"2019-08-31"},{"$f":"Timing!R5","v":"2019-09-30"},{"$f":"Timing!S5","v":"2019-10-31"},{"$f":"Timing!T5","v":"2019-11-30"},{"$f":"Timing!U5","v":"2019-12-31"},{"$f":"Timing!V5","v":"2020-01-31"},{"$f":"Timing!W5","v":"2020-02-29"},{"$f":"Timing!X5","v":"2020-03-31"},{"$f":"Timing!Y5","v":"2020-04-30"},{"$f":"Timing!Z5","v":"2020-05-31"},{"$f":"Timing!AA5","v":"2020-06-30"},{"$f":"Timing!AB5","v":"2020-07-31"},{"$f":"Timing!AC5","v":"2020-08-31"},{"$f":"Timing!AD5","v":"2020-09-30"},{"$f":"Timing!AE5","v":"2020-10-31"},{"$f":"Timing!AF5","v":"2020-11-30"},{"$f":"Timing!AG5","v":"2020-12-31"},{"$f":"Timing!AH5","v":"2021-01-31"},{"$f":"Timing!AI5","v":"2021-02-28"},{"$f":"Timing!AJ5","v":"2021-03-31"},{"$f":"Timing!AK5","v":"2021-04-30"},{"$f":"Timing!AL5","v":"2021-05-31"},{"$f":"Timing!AM5","v":"2021-06-30"},{"$f":"Timing!AN5","v":"2021-07-31"},{"$f":"Timing!AO5","v":"2021-08-31"},{"$f":"Timing!AP5","v":"2021-09-30"},{"$f":"Timing!AQ5","v":"2021-10-31"},{"$f":"Timing!AR5","v":"2021-11-30"},{"$f":"Timing!AS5","v":"2021-12-31"},{"$f":"Timing!AT5","v":"2022-01-31"},{"$f":"Timing!AU5","v":"2022-02-28"},{"$f":"Timing!AV5","v":"2022-03-31"},{"$f":"Timing!AW5","v":"2022-04-30"},{"$f":"Timing!AX5","v":"2022-05-31"},{"$f":"Timing!AY5","v":"2022-06-30"},{"$f":"Timing!AZ5","v":"2022-07-31"},{"$f":"Timing!BA5","v":"2022-08-31"},{"$f":"Timing!BB5","v":"2022-09-30"},{"$f":"Timing!BC5","v":"2022-10-31"},{"$f":"Timing!BD5","v":"2022-11-30"},{"$f":"Timing!BE5","v":"2022-12-31"},{"$f":"Timing!BF5","v":"2023-01-31"},{"$f":"Timing!BG5","v":"2023-02-28"},{"$f":"Timing!BH5","v":"2023-03-31"},{"$f":"Timing!BI5","v":"2023-04-30"},{"$f":"Timing!BJ5","v":"2023-05-31"},{"$f":"Timing!BK5","v":"2023-06-30"},{"$f":"Timing!BL5","v":"2023-07-31"},{"$f":"Timing!BM5","v":"2023-08-31"},{"$f":"Timing!BN5","v":"2023-09-30"},{"$f":"Timing!BO5","v":"2023-10-31"},{"$f":"Timing!BP5","v":"2023-11-30"},{"$f":"Timing!BQ5","v":"2023-12-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2019-01-01"},{"$f":"Timing!K6","v":"2019-02-01"},{"$f":"Timing!L6","v":"2019-03-01"},{"$f":"Timing!M6","v":"2019-04-01"},{"$f":"Timing!N6","v":"2019-05-01"},{"$f":"Timing!O6","v":"2019-06-01"},{"$f":"Timing!P6","v":"2019-07-01"},{"$f":"Timing!Q6","v":"2019-08-01"},{"$f":"Timing!R6","v":"2019-09-01"},{"$f":"Timing!S6","v":"2019-10-01"},{"$f":"Timing!T6","v":"2019-11-01"},{"$f":"Timing!U6","v":"2019-12-01"},{"$f":"Timing!V6","v":"2020-01-01"},{"$f":"Timing!W6","v":"2020-02-01"},{"$f":"Timing!X6","v":"2020-03-01"},{"$f":"Timing!Y6","v":"2020-04-01"},{"$f":"Timing!Z6","v":"2020-05-01"},{"$f":"Timing!AA6","v":"2020-06-01"},{"$f":"Timing!AB6","v":"2020-07-01"},{"$f":"Timing!AC6","v":"2020-08-01"},{"$f":"Timing!AD6","v":"2020-09-01"},{"$f":"Timing!AE6","v":"2020-10-01"},{"$f":"Timing!AF6","v":"2020-11-01"},{"$f":"Timing!AG6","v":"2020-12-01"},{"$f":"Timing!AH6","v":"2021-01-01"},{"$f":"Timing!AI6","v":"2021-02-01"},{"$f":"Timing!AJ6","v":"2021-03-01"},{"$f":"Timing!AK6","v":"2021-04-01"},{"$f":"Timing!AL6","v":"2021-05-01"},{"$f":"Timing!AM6","v":"2021-06-01"},{"$f":"Timing!AN6","v":"2021-07-01"},{"$f":"Timing!AO6","v":"2021-08-01"},{"$f":"Timing!AP6","v":"2021-09-01"},{"$f":"Timing!AQ6","v":"2021-10-01"},{"$f":"Timing!AR6","v":"2021-11-01"},{"$f":"Timing!AS6","v":"2021-12-01"},{"$f":"Timing!AT6","v":"2022-01-01"},{"$f":"Timing!AU6","v":"2022-02-01"},{"$f":"Timing!AV6","v":"2022-03-01"},{"$f":"Timing!AW6","v":"2022-04-01"},{"$f":"Timing!AX6","v":"2022-05-01"},{"$f":"Timing!AY6","v":"2022-06-01"},{"$f":"Timing!AZ6","v":"2022-07-01"},{"$f":"Timing!BA6","v":"2022-08-01"},{"$f":"Timing!BB6","v":"2022-09-01"},{"$f":"Timing!BC6","v":"2022-10-01"},{"$f":"Timing!BD6","v":"2022-11-01"},{"$f":"Timing!BE6","v":"2022-12-01"},{"$f":"Timing!BF6","v":"2023-01-01"},{"$f":"Timing!BG6","v":"2023-02-01"},{"$f":"Timing!BH6","v":"2023-03-01"},{"$f":"Timing!BI6","v":"2023-04-01"},{"$f":"Timing!BJ6","v":"2023-05-01"},{"$f":"Timing!BK6","v":"2023-06-01"},{"$f":"Timing!BL6","v":"2023-07-01"},{"$f":"Timing!BM6","v":"2023-08-01"},{"$f":"Timing!BN6","v":"2023-09-01"},{"$f":"Timing!BO6","v":"2023-10-01"},{"$f":"Timing!BP6","v":"2023-11-01"},{"$f":"Timing!BQ6","v":"2023-12-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2019-01-31"},{"$f":"Timing!K7","v":"2019-02-28"},{"$f":"Timing!L7","v":"2019-03-31"},{"$f":"Timing!M7","v":"2019-04-30"},{"$f":"Timing!N7","v":"2019-05-31"},{"$f":"Timing!O7","v":"2019-06-30"},{"$f":"Timing!P7","v":"2019-07-31"},{"$f":"Timing!Q7","v":"2019-08-31"},{"$f":"Timing!R7","v":"2019-09-30"},{"$f":"Timing!S7","v":"2019-10-31"},{"$f":"Timing!T7","v":"2019-11-30"},{"$f":"Timing!U7","v":"2019-12-31"},{"$f":"Timing!V7","v":"2020-01-31"},{"$f":"Timing!W7","v":"2020-02-29"},{"$f":"Timing!X7","v":"2020-03-31"},{"$f":"Timing!Y7","v":"2020-04-30"},{"$f":"Timing!Z7","v":"2020-05-31"},{"$f":"Timing!AA7","v":"2020-06-30"},{"$f":"Timing!AB7","v":"2020-07-31"},{"$f":"Timing!AC7","v":"2020-08-31"},{"$f":"Timing!AD7","v":"2020-09-30"},{"$f":"Timing!AE7","v":"2020-10-31"},{"$f":"Timing!AF7","v":"2020-11-30"},{"$f":"Timing!AG7","v":"2020-12-31"},{"$f":"Timing!AH7","v":"2021-01-31"},{"$f":"Timing!AI7","v":"2021-02-28"},{"$f":"Timing!AJ7","v":"2021-03-31"},{"$f":"Timing!AK7","v":"2021-04-30"},{"$f":"Timing!AL7","v":"2021-05-31"},{"$f":"Timing!AM7","v":"2021-06-30"},{"$f":"Timing!AN7","v":"2021-07-31"},{"$f":"Timing!AO7","v":"2021-08-31"},{"$f":"Timing!AP7","v":"2021-09-30"},{"$f":"Timing!AQ7","v":"2021-10-31"},{"$f":"Timing!AR7","v":"2021-11-30"},{"$f":"Timing!AS7","v":"2021-12-31"},{"$f":"Timing!AT7","v":"2022-01-31"},{"$f":"Timing!AU7","v":"2022-02-28"},{"$f":"Timing!AV7","v":"2022-03-31"},{"$f":"Timing!AW7","v":"2022-04-30"},{"$f":"Timing!AX7","v":"2022-05-31"},{"$f":"Timing!AY7","v":"2022-06-30"},{"$f":"Timing!AZ7","v":"2022-07-31"},{"$f":"Timing!BA7","v":"2022-08-31"},{"$f":"Timing!BB7","v":"2022-09-30"},{"$f":"Timing!BC7","v":"2022-10-31"},{"$f":"Timing!BD7","v":"2022-11-30"},{"$f":"Timing!BE7","v":"2022-12-31"},{"$f":"Timing!BF7","v":"2023-01-31"},{"$f":"Timing!BG7","v":"2023-02-28"},{"$f":"Timing!BH7","v":"2023-03-31"},{"$f":"Timing!BI7","v":"2023-04-30"},{"$f":"Timing!BJ7","v":"2023-05-31"},{"$f":"Timing!BK7","v":"2023-06-30"},{"$f":"Timing!BL7","v":"2023-07-31"},{"$f":"Timing!BM7","v":"2023-08-31"},{"$f":"Timing!BN7","v":"2023-09-30"},{"$f":"Timing!BO7","v":"2023-10-31"},{"$f":"Timing!BP7","v":"2023-11-30"},{"$f":"Timing!BQ7","v":"2023-12-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":31},{"$f":"Timing!K8","v":28},{"$f":"Timing!L8","v":31},{"$f":"Timing!M8","v":30},{"$f":"Timing!N8","v":31},{"$f":"Timing!O8","v":30},{"$f":"Timing!P8","v":31},{"$f":"Timing!Q8","v":31},{"$f":"Timing!R8","v":30},{"$f":"Timing!S8","v":31},{"$f":"Timing!T8","v":30},{"$f":"Timing!U8","v":31},{"$f":"Timing!V8","v":31},{"$f":"Timing!W8","v":29},{"$f":"Timing!X8","v":31},{"$f":"Timing!Y8","v":30},{"$f":"Timing!Z8","v":31},{"$f":"Timing!AA8","v":30},{"$f":"Timing!AB8","v":31},{"$f":"Timing!AC8","v":31},{"$f":"Timing!AD8","v":30},{"$f":"Timing!AE8","v":31},{"$f":"Timing!AF8","v":30},{"$f":"Timing!AG8","v":31},{"$f":"Timing!AH8","v":31},{"$f":"Timing!AI8","v":28},{"$f":"Timing!AJ8","v":31},{"$f":"Timing!AK8","v":30},{"$f":"Timing!AL8","v":31},{"$f":"Timing!AM8","v":30},{"$f":"Timing!AN8","v":31},{"$f":"Timing!AO8","v":31},{"$f":"Timing!AP8","v":30},{"$f":"Timing!AQ8","v":31},{"$f":"Timing!AR8","v":30},{"$f":"Timing!AS8","v":31},{"$f":"Timing!AT8","v":31},{"$f":"Timing!AU8","v":28},{"$f":"Timing!AV8","v":31},{"$f":"Timing!AW8","v":30},{"$f":"Timing!AX8","v":31},{"$f":"Timing!AY8","v":30},{"$f":"Timing!AZ8","v":31},{"$f":"Timing!BA8","v":31},{"$f":"Timing!BB8","v":30},{"$f":"Timing!BC8","v":31},{"$f":"Timing!BD8","v":30},{"$f":"Timing!BE8","v":31},{"$f":"Timing!BF8","v":31},{"$f":"Timing!BG8","v":28},{"$f":"Timing!BH8","v":31},{"$f":"Timing!BI8","v":30},{"$f":"Timing!BJ8","v":31},{"$f":"Timing!BK8","v":30},{"$f":"Timing!BL8","v":31},{"$f":"Timing!BM8","v":31},{"$f":"Timing!BN8","v":30},{"$f":"Timing!BO8","v":31},{"$f":"Timing!BP8","v":30},{"$f":"Timing!BQ8","v":31}]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,"None",{"$f":"Timing!J9","v":1},{"$f":"Timing!K9","v":2},{"$f":"Timing!L9","v":3},{"$f":"Timing!M9","v":4},{"$f":"Timing!N9","v":5},{"$f":"Timing!O9","v":6},{"$f":"Timing!P9","v":7},{"$f":"Timing!Q9","v":8},{"$f":"Timing!R9","v":9},{"$f":"Timing!S9","v":10},{"$f":"Timing!T9","v":11},{"$f":"Timing!U9","v":12},{"$f":"Timing!V9","v":13},{"$f":"Timing!W9","v":14},{"$f":"Timing!X9","v":15},{"$f":"Timing!Y9","v":16},{"$f":"Timing!Z9","v":17},{"$f":"Timing!AA9","v":18},{"$f":"Timing!AB9","v":19},{"$f":"Timing!AC9","v":20},{"$f":"Timing!AD9","v":21},{"$f":"Timing!AE9","v":22},{"$f":"Timing!AF9","v":23},{"$f":"Timing!AG9","v":24},{"$f":"Timing!AH9","v":25},{"$f":"Timing!AI9","v":26},{"$f":"Timing!AJ9","v":27},{"$f":"Timing!AK9","v":28},{"$f":"Timing!AL9","v":29},{"$f":"Timing!AM9","v":30},{"$f":"Timing!AN9","v":31},{"$f":"Timing!AO9","v":32},{"$f":"Timing!AP9","v":33},{"$f":"Timing!AQ9","v":34},{"$f":"Timing!AR9","v":35},{"$f":"Timing!AS9","v":36},{"$f":"Timing!AT9","v":37},{"$f":"Timing!AU9","v":38},{"$f":"Timing!AV9","v":39},{"$f":"Timing!AW9","v":40},{"$f":"Timing!AX9","v":41},{"$f":"Timing!AY9","v":42},{"$f":"Timing!AZ9","v":43},{"$f":"Timing!BA9","v":44},{"$f":"Timing!BB9","v":45},{"$f":"Timing!BC9","v":46},{"$f":"Timing!BD9","v":47},{"$f":"Timing!BE9","v":48},{"$f":"Timing!BF9","v":49},{"$f":"Timing!BG9","v":50},{"$f":"Timing!BH9","v":51},{"$f":"Timing!BI9","v":52},{"$f":"Timing!BJ9","v":53},{"$f":"Timing!BK9","v":54},{"$f":"Timing!BL9","v":55},{"$f":"Timing!BM9","v":56},{"$f":"Timing!BN9","v":57},{"$f":"Timing!BO9","v":58},{"$f":"Timing!BP9","v":59},{"$f":"Timing!BQ9","v":60}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Timing Assumptions"]
[]
[null,null,"Periodicity Assumptions"]
[]
[null,null,null,"Inputs"]
[]
[null,null,null,null,null,"# Periods","From","To"]
[null,null,null,null,"Monthly",12,{"$f":"IF(OR($F18=\"None\",$F18=\"\"),\"None\",1)","v":1},{"$f":"IF(OR($F18=\"None\",$F18=\"\"),\"None\",MIN($F18,MAX(LU_Number_of_Periods)))","v":12},null,{"$f":"IF(AND(J$9>=N($G18),J$9<=N($H18)),J$7,\"\")","v":"2019-01-31"},{"$f":"IF(AND(K$9>=N($G18),K$9<=N($H18)),K$7,\"\")","v":"2019-02-28"},"2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,"Quarterly",4,{"$f":"IF(OR($F19=\"None\",$F19=\"\",$H18=MAX(LU_Number_of_Periods)),\"None\",MAX(H18)+1)","v":13},{"$f":"IF(OR($F19=\"None\",$F19=\"\",$H18=MAX(LU_Number_of_Periods)),\"None\",MIN($F19*Months_in_Quarter+$G19-1,MAX(LU_Number_of_Periods)))","v":24},null,{"$f":"IF(AND(J$9>=N($G19),J$9<=N($H19)),EOMONTH(J$7,Months_in_Quarter-MOD(J$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(K$9>=N($G19),K$9<=N($H19)),EOMONTH(K$7,Months_in_Quarter-MOD(K$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(L$9>=N($G19),L$9<=N($H19)),EOMONTH(L$7,Months_in_Quarter-MOD(L$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(M$9>=N($G19),M$9<=N($H19)),EOMONTH(M$7,Months_in_Quarter-MOD(M$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(N$9>=N($G19),N$9<=N($H19)),EOMONTH(N$7,Months_in_Quarter-MOD(N$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(O$9>=N($G19),O$9<=N($H19)),EOMONTH(O$7,Months_in_Quarter-MOD(O$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(P$9>=N($G19),P$9<=N($H19)),EOMONTH(P$7,Months_in_Quarter-MOD(P$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(Q$9>=N($G19),Q$9<=N($H19)),EOMONTH(Q$7,Months_in_Quarter-MOD(Q$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(R$9>=N($G19),R$9<=N($H19)),EOMONTH(R$7,Months_in_Quarter-MOD(R$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(S$9>=N($G19),S$9<=N($H19)),EOMONTH(S$7,Months_in_Quarter-MOD(S$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(T$9>=N($G19),T$9<=N($H19)),EOMONTH(T$7,Months_in_Quarter-MOD(T$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(U$9>=N($G19),U$9<=N($H19)),EOMONTH(U$7,Months_in_Quarter-MOD(U$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(V$9>=N($G19),V$9<=N($H19)),EOMONTH(V$7,Months_in_Quarter-MOD(V$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-03-31"},{"$f":"IF(AND(W$9>=N($G19),W$9<=N($H19)),EOMONTH(W$7,Months_in_Quarter-MOD(W$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-03-31"},{"$f":"IF(AND(X$9>=N($G19),X$9<=N($H19)),EOMONTH(X$7,Months_in_Quarter-MOD(X$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-03-31"},{"$f":"IF(AND(Y$9>=N($G19),Y$9<=N($H19)),EOMONTH(Y$7,Months_in_Quarter-MOD(Y$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-06-30"},{"$f":"IF(AND(Z$9>=N($G19),Z$9<=N($H19)),EOMONTH(Z$7,Months_in_Quarter-MOD(Z$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-06-30"},{"$f":"IF(AND(AA$9>=N($G19),AA$9<=N($H19)),EOMONTH(AA$7,Months_in_Quarter-MOD(AA$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-06-30"},{"$f":"IF(AND(AB$9>=N($G19),AB$9<=N($H19)),EOMONTH(AB$7,Months_in_Quarter-MOD(AB$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-09-30"},{"$f":"IF(AND(AC$9>=N($G19),AC$9<=N($H19)),EOMONTH(AC$7,Months_in_Quarter-MOD(AC$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-09-30"},{"$f":"IF(AND(AD$9>=N($G19),AD$9<=N($H19)),EOMONTH(AD$7,Months_in_Quarter-MOD(AD$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-09-30"},{"$f":"IF(AND(AE$9>=N($G19),AE$9<=N($H19)),EOMONTH(AE$7,Months_in_Quarter-MOD(AE$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-12-31"},{"$f":"IF(AND(AF$9>=N($G19),AF$9<=N($H19)),EOMONTH(AF$7,Months_in_Quarter-MOD(AF$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-12-31"},{"$f":"IF(AND(AG$9>=N($G19),AG$9<=N($H19)),EOMONTH(AG$7,Months_in_Quarter-MOD(AG$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":"2020-12-31"},{"$f":"IF(AND(AH$9>=N($G19),AH$9<=N($H19)),EOMONTH(AH$7,Months_in_Quarter-MOD(AH$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AI$9>=N($G19),AI$9<=N($H19)),EOMONTH(AI$7,Months_in_Quarter-MOD(AI$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AJ$9>=N($G19),AJ$9<=N($H19)),EOMONTH(AJ$7,Months_in_Quarter-MOD(AJ$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AK$9>=N($G19),AK$9<=N($H19)),EOMONTH(AK$7,Months_in_Quarter-MOD(AK$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AL$9>=N($G19),AL$9<=N($H19)),EOMONTH(AL$7,Months_in_Quarter-MOD(AL$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AM$9>=N($G19),AM$9<=N($H19)),EOMONTH(AM$7,Months_in_Quarter-MOD(AM$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AN$9>=N($G19),AN$9<=N($H19)),EOMONTH(AN$7,Months_in_Quarter-MOD(AN$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AO$9>=N($G19),AO$9<=N($H19)),EOMONTH(AO$7,Months_in_Quarter-MOD(AO$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AP$9>=N($G19),AP$9<=N($H19)),EOMONTH(AP$7,Months_in_Quarter-MOD(AP$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AQ$9>=N($G19),AQ$9<=N($H19)),EOMONTH(AQ$7,Months_in_Quarter-MOD(AQ$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AR$9>=N($G19),AR$9<=N($H19)),EOMONTH(AR$7,Months_in_Quarter-MOD(AR$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AS$9>=N($G19),AS$9<=N($H19)),EOMONTH(AS$7,Months_in_Quarter-MOD(AS$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AT$9>=N($G19),AT$9<=N($H19)),EOMONTH(AT$7,Months_in_Quarter-MOD(AT$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AU$9>=N($G19),AU$9<=N($H19)),EOMONTH(AU$7,Months_in_Quarter-MOD(AU$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AV$9>=N($G19),AV$9<=N($H19)),EOMONTH(AV$7,Months_in_Quarter-MOD(AV$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AW$9>=N($G19),AW$9<=N($H19)),EOMONTH(AW$7,Months_in_Quarter-MOD(AW$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AX$9>=N($G19),AX$9<=N($H19)),EOMONTH(AX$7,Months_in_Quarter-MOD(AX$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AY$9>=N($G19),AY$9<=N($H19)),EOMONTH(AY$7,Months_in_Quarter-MOD(AY$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(AZ$9>=N($G19),AZ$9<=N($H19)),EOMONTH(AZ$7,Months_in_Quarter-MOD(AZ$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BA$9>=N($G19),BA$9<=N($H19)),EOMONTH(BA$7,Months_in_Quarter-MOD(BA$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BB$9>=N($G19),BB$9<=N($H19)),EOMONTH(BB$7,Months_in_Quarter-MOD(BB$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BC$9>=N($G19),BC$9<=N($H19)),EOMONTH(BC$7,Months_in_Quarter-MOD(BC$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BD$9>=N($G19),BD$9<=N($H19)),EOMONTH(BD$7,Months_in_Quarter-MOD(BD$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BE$9>=N($G19),BE$9<=N($H19)),EOMONTH(BE$7,Months_in_Quarter-MOD(BE$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BF$9>=N($G19),BF$9<=N($H19)),EOMONTH(BF$7,Months_in_Quarter-MOD(BF$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BG$9>=N($G19),BG$9<=N($H19)),EOMONTH(BG$7,Months_in_Quarter-MOD(BG$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BH$9>=N($G19),BH$9<=N($H19)),EOMONTH(BH$7,Months_in_Quarter-MOD(BH$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BI$9>=N($G19),BI$9<=N($H19)),EOMONTH(BI$7,Months_in_Quarter-MOD(BI$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BJ$9>=N($G19),BJ$9<=N($H19)),EOMONTH(BJ$7,Months_in_Quarter-MOD(BJ$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BK$9>=N($G19),BK$9<=N($H19)),EOMONTH(BK$7,Months_in_Quarter-MOD(BK$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BL$9>=N($G19),BL$9<=N($H19)),EOMONTH(BL$7,Months_in_Quarter-MOD(BL$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BM$9>=N($G19),BM$9<=N($H19)),EOMONTH(BM$7,Months_in_Quarter-MOD(BM$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BN$9>=N($G19),BN$9<=N($H19)),EOMONTH(BN$7,Months_in_Quarter-MOD(BN$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BO$9>=N($G19),BO$9<=N($H19)),EOMONTH(BO$7,Months_in_Quarter-MOD(BO$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BP$9>=N($G19),BP$9<=N($H19)),EOMONTH(BP$7,Months_in_Quarter-MOD(BP$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""},{"$f":"IF(AND(BQ$9>=N($G19),BQ$9<=N($H19)),EOMONTH(BQ$7,Months_in_Quarter-MOD(BQ$9-MAX($H$18:$H18)-1,Months_in_Quarter)-1),\"\")","v":""}]
[null,null,null,null,"Half-Yearly",2,{"$f":"IF(OR($F20=\"None\",$F20=\"\",MAX($H$18:$H19)=MAX(LU_Number_of_Periods)),\"None\",MAX($H$18:$H19)+1)","v":25},{"$f":"IF(OR($F20=\"None\",$F20=\"\",MAX($H$18:$H19)=MAX(LU_Number_of_Periods)),\"None\",MIN($F20*Months_in_Half_Yr+$G20-1,MAX(LU_Number_of_Periods)))","v":36},null,{"$f":"IF(AND(J$9>=N($G20),J$9<=N($H20)),EOMONTH(J$7,Months_in_Half_Yr-MOD(J$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(K$9>=N($G20),K$9<=N($H20)),EOMONTH(K$7,Months_in_Half_Yr-MOD(K$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(L$9>=N($G20),L$9<=N($H20)),EOMONTH(L$7,Months_in_Half_Yr-MOD(L$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(M$9>=N($G20),M$9<=N($H20)),EOMONTH(M$7,Months_in_Half_Yr-MOD(M$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(N$9>=N($G20),N$9<=N($H20)),EOMONTH(N$7,Months_in_Half_Yr-MOD(N$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(O$9>=N($G20),O$9<=N($H20)),EOMONTH(O$7,Months_in_Half_Yr-MOD(O$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(P$9>=N($G20),P$9<=N($H20)),EOMONTH(P$7,Months_in_Half_Yr-MOD(P$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(Q$9>=N($G20),Q$9<=N($H20)),EOMONTH(Q$7,Months_in_Half_Yr-MOD(Q$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(R$9>=N($G20),R$9<=N($H20)),EOMONTH(R$7,Months_in_Half_Yr-MOD(R$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(S$9>=N($G20),S$9<=N($H20)),EOMONTH(S$7,Months_in_Half_Yr-MOD(S$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(T$9>=N($G20),T$9<=N($H20)),EOMONTH(T$7,Months_in_Half_Yr-MOD(T$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(U$9>=N($G20),U$9<=N($H20)),EOMONTH(U$7,Months_in_Half_Yr-MOD(U$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(V$9>=N($G20),V$9<=N($H20)),EOMONTH(V$7,Months_in_Half_Yr-MOD(V$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(W$9>=N($G20),W$9<=N($H20)),EOMONTH(W$7,Months_in_Half_Yr-MOD(W$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(X$9>=N($G20),X$9<=N($H20)),EOMONTH(X$7,Months_in_Half_Yr-MOD(X$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(Y$9>=N($G20),Y$9<=N($H20)),EOMONTH(Y$7,Months_in_Half_Yr-MOD(Y$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(Z$9>=N($G20),Z$9<=N($H20)),EOMONTH(Z$7,Months_in_Half_Yr-MOD(Z$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AA$9>=N($G20),AA$9<=N($H20)),EOMONTH(AA$7,Months_in_Half_Yr-MOD(AA$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AB$9>=N($G20),AB$9<=N($H20)),EOMONTH(AB$7,Months_in_Half_Yr-MOD(AB$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AC$9>=N($G20),AC$9<=N($H20)),EOMONTH(AC$7,Months_in_Half_Yr-MOD(AC$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AD$9>=N($G20),AD$9<=N($H20)),EOMONTH(AD$7,Months_in_Half_Yr-MOD(AD$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AE$9>=N($G20),AE$9<=N($H20)),EOMONTH(AE$7,Months_in_Half_Yr-MOD(AE$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AF$9>=N($G20),AF$9<=N($H20)),EOMONTH(AF$7,Months_in_Half_Yr-MOD(AF$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AG$9>=N($G20),AG$9<=N($H20)),EOMONTH(AG$7,Months_in_Half_Yr-MOD(AG$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AH$9>=N($G20),AH$9<=N($H20)),EOMONTH(AH$7,Months_in_Half_Yr-MOD(AH$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-06-30"},{"$f":"IF(AND(AI$9>=N($G20),AI$9<=N($H20)),EOMONTH(AI$7,Months_in_Half_Yr-MOD(AI$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-06-30"},{"$f":"IF(AND(AJ$9>=N($G20),AJ$9<=N($H20)),EOMONTH(AJ$7,Months_in_Half_Yr-MOD(AJ$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-06-30"},{"$f":"IF(AND(AK$9>=N($G20),AK$9<=N($H20)),EOMONTH(AK$7,Months_in_Half_Yr-MOD(AK$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-06-30"},{"$f":"IF(AND(AL$9>=N($G20),AL$9<=N($H20)),EOMONTH(AL$7,Months_in_Half_Yr-MOD(AL$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-06-30"},{"$f":"IF(AND(AM$9>=N($G20),AM$9<=N($H20)),EOMONTH(AM$7,Months_in_Half_Yr-MOD(AM$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-06-30"},{"$f":"IF(AND(AN$9>=N($G20),AN$9<=N($H20)),EOMONTH(AN$7,Months_in_Half_Yr-MOD(AN$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-12-31"},{"$f":"IF(AND(AO$9>=N($G20),AO$9<=N($H20)),EOMONTH(AO$7,Months_in_Half_Yr-MOD(AO$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-12-31"},{"$f":"IF(AND(AP$9>=N($G20),AP$9<=N($H20)),EOMONTH(AP$7,Months_in_Half_Yr-MOD(AP$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-12-31"},{"$f":"IF(AND(AQ$9>=N($G20),AQ$9<=N($H20)),EOMONTH(AQ$7,Months_in_Half_Yr-MOD(AQ$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-12-31"},{"$f":"IF(AND(AR$9>=N($G20),AR$9<=N($H20)),EOMONTH(AR$7,Months_in_Half_Yr-MOD(AR$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-12-31"},{"$f":"IF(AND(AS$9>=N($G20),AS$9<=N($H20)),EOMONTH(AS$7,Months_in_Half_Yr-MOD(AS$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":"2021-12-31"},{"$f":"IF(AND(AT$9>=N($G20),AT$9<=N($H20)),EOMONTH(AT$7,Months_in_Half_Yr-MOD(AT$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AU$9>=N($G20),AU$9<=N($H20)),EOMONTH(AU$7,Months_in_Half_Yr-MOD(AU$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AV$9>=N($G20),AV$9<=N($H20)),EOMONTH(AV$7,Months_in_Half_Yr-MOD(AV$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AW$9>=N($G20),AW$9<=N($H20)),EOMONTH(AW$7,Months_in_Half_Yr-MOD(AW$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AX$9>=N($G20),AX$9<=N($H20)),EOMONTH(AX$7,Months_in_Half_Yr-MOD(AX$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AY$9>=N($G20),AY$9<=N($H20)),EOMONTH(AY$7,Months_in_Half_Yr-MOD(AY$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(AZ$9>=N($G20),AZ$9<=N($H20)),EOMONTH(AZ$7,Months_in_Half_Yr-MOD(AZ$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BA$9>=N($G20),BA$9<=N($H20)),EOMONTH(BA$7,Months_in_Half_Yr-MOD(BA$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BB$9>=N($G20),BB$9<=N($H20)),EOMONTH(BB$7,Months_in_Half_Yr-MOD(BB$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BC$9>=N($G20),BC$9<=N($H20)),EOMONTH(BC$7,Months_in_Half_Yr-MOD(BC$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BD$9>=N($G20),BD$9<=N($H20)),EOMONTH(BD$7,Months_in_Half_Yr-MOD(BD$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BE$9>=N($G20),BE$9<=N($H20)),EOMONTH(BE$7,Months_in_Half_Yr-MOD(BE$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BF$9>=N($G20),BF$9<=N($H20)),EOMONTH(BF$7,Months_in_Half_Yr-MOD(BF$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BG$9>=N($G20),BG$9<=N($H20)),EOMONTH(BG$7,Months_in_Half_Yr-MOD(BG$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BH$9>=N($G20),BH$9<=N($H20)),EOMONTH(BH$7,Months_in_Half_Yr-MOD(BH$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BI$9>=N($G20),BI$9<=N($H20)),EOMONTH(BI$7,Months_in_Half_Yr-MOD(BI$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BJ$9>=N($G20),BJ$9<=N($H20)),EOMONTH(BJ$7,Months_in_Half_Yr-MOD(BJ$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BK$9>=N($G20),BK$9<=N($H20)),EOMONTH(BK$7,Months_in_Half_Yr-MOD(BK$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BL$9>=N($G20),BL$9<=N($H20)),EOMONTH(BL$7,Months_in_Half_Yr-MOD(BL$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BM$9>=N($G20),BM$9<=N($H20)),EOMONTH(BM$7,Months_in_Half_Yr-MOD(BM$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BN$9>=N($G20),BN$9<=N($H20)),EOMONTH(BN$7,Months_in_Half_Yr-MOD(BN$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BO$9>=N($G20),BO$9<=N($H20)),EOMONTH(BO$7,Months_in_Half_Yr-MOD(BO$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BP$9>=N($G20),BP$9<=N($H20)),EOMONTH(BP$7,Months_in_Half_Yr-MOD(BP$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""},{"$f":"IF(AND(BQ$9>=N($G20),BQ$9<=N($H20)),EOMONTH(BQ$7,Months_in_Half_Yr-MOD(BQ$9-MAX($H$18:$H19)-1,Months_in_Half_Yr)-1),\"\")","v":""}]
[null,null,null,null,"Annually","Remainder",{"$f":"IF(OR($F21=\"None\",$F21=\"\",MAX($H$18:$H20)=MAX(LU_Number_of_Periods)),\"None\",MAX($H$18:$H20)+1)","v":37},{"$f":"IF(OR($F21=\"None\",$F21=\"\",MAX($H$18:$H20)=MAX(LU_Number_of_Periods)),\"None\",MAX(LU_Number_of_Periods))","v":60},null,{"$f":"IF(AND(J$9>=N($G21),J$9<=N($H21)),EOMONTH(J$7,Months_in_Year-MOD(J$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(K$9>=N($G21),K$9<=N($H21)),EOMONTH(K$7,Months_in_Year-MOD(K$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(L$9>=N($G21),L$9<=N($H21)),EOMONTH(L$7,Months_in_Year-MOD(L$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(M$9>=N($G21),M$9<=N($H21)),EOMONTH(M$7,Months_in_Year-MOD(M$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(N$9>=N($G21),N$9<=N($H21)),EOMONTH(N$7,Months_in_Year-MOD(N$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(O$9>=N($G21),O$9<=N($H21)),EOMONTH(O$7,Months_in_Year-MOD(O$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(P$9>=N($G21),P$9<=N($H21)),EOMONTH(P$7,Months_in_Year-MOD(P$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(Q$9>=N($G21),Q$9<=N($H21)),EOMONTH(Q$7,Months_in_Year-MOD(Q$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(R$9>=N($G21),R$9<=N($H21)),EOMONTH(R$7,Months_in_Year-MOD(R$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(S$9>=N($G21),S$9<=N($H21)),EOMONTH(S$7,Months_in_Year-MOD(S$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(T$9>=N($G21),T$9<=N($H21)),EOMONTH(T$7,Months_in_Year-MOD(T$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(U$9>=N($G21),U$9<=N($H21)),EOMONTH(U$7,Months_in_Year-MOD(U$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(V$9>=N($G21),V$9<=N($H21)),EOMONTH(V$7,Months_in_Year-MOD(V$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(W$9>=N($G21),W$9<=N($H21)),EOMONTH(W$7,Months_in_Year-MOD(W$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(X$9>=N($G21),X$9<=N($H21)),EOMONTH(X$7,Months_in_Year-MOD(X$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(Y$9>=N($G21),Y$9<=N($H21)),EOMONTH(Y$7,Months_in_Year-MOD(Y$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(Z$9>=N($G21),Z$9<=N($H21)),EOMONTH(Z$7,Months_in_Year-MOD(Z$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AA$9>=N($G21),AA$9<=N($H21)),EOMONTH(AA$7,Months_in_Year-MOD(AA$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AB$9>=N($G21),AB$9<=N($H21)),EOMONTH(AB$7,Months_in_Year-MOD(AB$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AC$9>=N($G21),AC$9<=N($H21)),EOMONTH(AC$7,Months_in_Year-MOD(AC$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AD$9>=N($G21),AD$9<=N($H21)),EOMONTH(AD$7,Months_in_Year-MOD(AD$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AE$9>=N($G21),AE$9<=N($H21)),EOMONTH(AE$7,Months_in_Year-MOD(AE$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AF$9>=N($G21),AF$9<=N($H21)),EOMONTH(AF$7,Months_in_Year-MOD(AF$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AG$9>=N($G21),AG$9<=N($H21)),EOMONTH(AG$7,Months_in_Year-MOD(AG$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AH$9>=N($G21),AH$9<=N($H21)),EOMONTH(AH$7,Months_in_Year-MOD(AH$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AI$9>=N($G21),AI$9<=N($H21)),EOMONTH(AI$7,Months_in_Year-MOD(AI$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AJ$9>=N($G21),AJ$9<=N($H21)),EOMONTH(AJ$7,Months_in_Year-MOD(AJ$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AK$9>=N($G21),AK$9<=N($H21)),EOMONTH(AK$7,Months_in_Year-MOD(AK$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AL$9>=N($G21),AL$9<=N($H21)),EOMONTH(AL$7,Months_in_Year-MOD(AL$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AM$9>=N($G21),AM$9<=N($H21)),EOMONTH(AM$7,Months_in_Year-MOD(AM$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AN$9>=N($G21),AN$9<=N($H21)),EOMONTH(AN$7,Months_in_Year-MOD(AN$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AO$9>=N($G21),AO$9<=N($H21)),EOMONTH(AO$7,Months_in_Year-MOD(AO$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AP$9>=N($G21),AP$9<=N($H21)),EOMONTH(AP$7,Months_in_Year-MOD(AP$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AQ$9>=N($G21),AQ$9<=N($H21)),EOMONTH(AQ$7,Months_in_Year-MOD(AQ$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AR$9>=N($G21),AR$9<=N($H21)),EOMONTH(AR$7,Months_in_Year-MOD(AR$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AS$9>=N($G21),AS$9<=N($H21)),EOMONTH(AS$7,Months_in_Year-MOD(AS$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":""},{"$f":"IF(AND(AT$9>=N($G21),AT$9<=N($H21)),EOMONTH(AT$7,Months_in_Year-MOD(AT$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(AU$9>=N($G21),AU$9<=N($H21)),EOMONTH(AU$7,Months_in_Year-MOD(AU$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(AV$9>=N($G21),AV$9<=N($H21)),EOMONTH(AV$7,Months_in_Year-MOD(AV$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(AW$9>=N($G21),AW$9<=N($H21)),EOMONTH(AW$7,Months_in_Year-MOD(AW$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(AX$9>=N($G21),AX$9<=N($H21)),EOMONTH(AX$7,Months_in_Year-MOD(AX$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(AY$9>=N($G21),AY$9<=N($H21)),EOMONTH(AY$7,Months_in_Year-MOD(AY$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(AZ$9>=N($G21),AZ$9<=N($H21)),EOMONTH(AZ$7,Months_in_Year-MOD(AZ$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(BA$9>=N($G21),BA$9<=N($H21)),EOMONTH(BA$7,Months_in_Year-MOD(BA$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(BB$9>=N($G21),BB$9<=N($H21)),EOMONTH(BB$7,Months_in_Year-MOD(BB$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(BC$9>=N($G21),BC$9<=N($H21)),EOMONTH(BC$7,Months_in_Year-MOD(BC$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(BD$9>=N($G21),BD$9<=N($H21)),EOMONTH(BD$7,Months_in_Year-MOD(BD$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(BE$9>=N($G21),BE$9<=N($H21)),EOMONTH(BE$7,Months_in_Year-MOD(BE$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2022-12-31"},{"$f":"IF(AND(BF$9>=N($G21),BF$9<=N($H21)),EOMONTH(BF$7,Months_in_Year-MOD(BF$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BG$9>=N($G21),BG$9<=N($H21)),EOMONTH(BG$7,Months_in_Year-MOD(BG$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BH$9>=N($G21),BH$9<=N($H21)),EOMONTH(BH$7,Months_in_Year-MOD(BH$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BI$9>=N($G21),BI$9<=N($H21)),EOMONTH(BI$7,Months_in_Year-MOD(BI$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BJ$9>=N($G21),BJ$9<=N($H21)),EOMONTH(BJ$7,Months_in_Year-MOD(BJ$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BK$9>=N($G21),BK$9<=N($H21)),EOMONTH(BK$7,Months_in_Year-MOD(BK$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BL$9>=N($G21),BL$9<=N($H21)),EOMONTH(BL$7,Months_in_Year-MOD(BL$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BM$9>=N($G21),BM$9<=N($H21)),EOMONTH(BM$7,Months_in_Year-MOD(BM$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BN$9>=N($G21),BN$9<=N($H21)),EOMONTH(BN$7,Months_in_Year-MOD(BN$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BO$9>=N($G21),BO$9<=N($H21)),EOMONTH(BO$7,Months_in_Year-MOD(BO$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BP$9>=N($G21),BP$9<=N($H21)),EOMONTH(BP$7,Months_in_Year-MOD(BP$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"},{"$f":"IF(AND(BQ$9>=N($G21),BQ$9<=N($H21)),EOMONTH(BQ$7,Months_in_Year-MOD(BQ$9-MAX($H$18:$H20)-1,Months_in_Year)-1),\"\")","v":"2023-12-31"}]
[]
[null,null,null,null,"Periodicity",null,null,null,null,{"$f":"INDEX($E$18:$E$21,MATCH(TRUE,INDEX(J$18:J$21<>\"\",),0))","v":"Monthly"},{"$f":"INDEX($E$18:$E$21,MATCH(TRUE,INDEX(K$18:K$21<>\"\",),0))","v":"Monthly"},"Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Monthly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Quarterly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Half-Yearly","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually","Annually"]
[null,null,null,null,"Reporting Month",null,null,null,null,{"$f":"MAX(J$18:J$21)","v":"2019-01-31"},{"$f":"MAX(K$18:K$21)","v":"2019-02-28"},"2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-03-31","2020-03-31","2020-03-31","2020-06-30","2020-06-30","2020-06-30","2020-09-30","2020-09-30","2020-09-30","2020-12-31","2020-12-31","2020-12-31","2021-06-30","2021-06-30","2021-06-30","2021-06-30","2021-06-30","2021-06-30","2021-12-31","2021-12-31","2021-12-31","2021-12-31","2021-12-31","2021-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2022-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31","2023-12-31"]
[null,null,null,null,"Reporting Period Number",null,null,null,null,{"$f":"I25+(COUNTIF($I$24:I$24,J$24)=0)*1","v":1},{"$f":"J25+(COUNTIF($I$24:J$24,K$24)=0)*1","v":2},{"$f":"K25+(COUNTIF($I$24:K$24,L$24)=0)*1","v":3},{"$f":"L25+(COUNTIF($I$24:L$24,M$24)=0)*1","v":4},{"$f":"M25+(COUNTIF($I$24:M$24,N$24)=0)*1","v":5},{"$f":"N25+(COUNTIF($I$24:N$24,O$24)=0)*1","v":6},{"$f":"O25+(COUNTIF($I$24:O$24,P$24)=0)*1","v":7},{"$f":"P25+(COUNTIF($I$24:P$24,Q$24)=0)*1","v":8},{"$f":"Q25+(COUNTIF($I$24:Q$24,R$24)=0)*1","v":9},{"$f":"R25+(COUNTIF($I$24:R$24,S$24)=0)*1","v":10},{"$f":"S25+(COUNTIF($I$24:S$24,T$24)=0)*1","v":11},{"$f":"T25+(COUNTIF($I$24:T$24,U$24)=0)*1","v":12},{"$f":"U25+(COUNTIF($I$24:U$24,V$24)=0)*1","v":13},{"$f":"V25+(COUNTIF($I$24:V$24,W$24)=0)*1","v":13},{"$f":"W25+(COUNTIF($I$24:W$24,X$24)=0)*1","v":13},{"$f":"X25+(COUNTIF($I$24:X$24,Y$24)=0)*1","v":14},{"$f":"Y25+(COUNTIF($I$24:Y$24,Z$24)=0)*1","v":14},{"$f":"Z25+(COUNTIF($I$24:Z$24,AA$24)=0)*1","v":14},{"$f":"AA25+(COUNTIF($I$24:AA$24,AB$24)=0)*1","v":15},{"$f":"AB25+(COUNTIF($I$24:AB$24,AC$24)=0)*1","v":15},{"$f":"AC25+(COUNTIF($I$24:AC$24,AD$24)=0)*1","v":15},{"$f":"AD25+(COUNTIF($I$24:AD$24,AE$24)=0)*1","v":16},{"$f":"AE25+(COUNTIF($I$24:AE$24,AF$24)=0)*1","v":16},{"$f":"AF25+(COUNTIF($I$24:AF$24,AG$24)=0)*1","v":16},{"$f":"AG25+(COUNTIF($I$24:AG$24,AH$24)=0)*1","v":17},{"$f":"AH25+(COUNTIF($I$24:AH$24,AI$24)=0)*1","v":17},{"$f":"AI25+(COUNTIF($I$24:AI$24,AJ$24)=0)*1","v":17},{"$f":"AJ25+(COUNTIF($I$24:AJ$24,AK$24)=0)*1","v":17},{"$f":"AK25+(COUNTIF($I$24:AK$24,AL$24)=0)*1","v":17},{"$f":"AL25+(COUNTIF($I$24:AL$24,AM$24)=0)*1","v":17},{"$f":"AM25+(COUNTIF($I$24:AM$24,AN$24)=0)*1","v":18},{"$f":"AN25+(COUNTIF($I$24:AN$24,AO$24)=0)*1","v":18},{"$f":"AO25+(COUNTIF($I$24:AO$24,AP$24)=0)*1","v":18},{"$f":"AP25+(COUNTIF($I$24:AP$24,AQ$24)=0)*1","v":18},{"$f":"AQ25+(COUNTIF($I$24:AQ$24,AR$24)=0)*1","v":18},{"$f":"AR25+(COUNTIF($I$24:AR$24,AS$24)=0)*1","v":18},{"$f":"AS25+(COUNTIF($I$24:AS$24,AT$24)=0)*1","v":19},{"$f":"AT25+(COUNTIF($I$24:AT$24,AU$24)=0)*1","v":19},{"$f":"AU25+(COUNTIF($I$24:AU$24,AV$24)=0)*1","v":19},{"$f":"AV25+(COUNTIF($I$24:AV$24,AW$24)=0)*1","v":19},{"$f":"AW25+(COUNTIF($I$24:AW$24,AX$24)=0)*1","v":19},{"$f":"AX25+(COUNTIF($I$24:AX$24,AY$24)=0)*1","v":19},{"$f":"AY25+(COUNTIF($I$24:AY$24,AZ$24)=0)*1","v":19},{"$f":"AZ25+(COUNTIF($I$24:AZ$24,BA$24)=0)*1","v":19},{"$f":"BA25+(COUNTIF($I$24:BA$24,BB$24)=0)*1","v":19},{"$f":"BB25+(COUNTIF($I$24:BB$24,BC$24)=0)*1","v":19},{"$f":"BC25+(COUNTIF($I$24:BC$24,BD$24)=0)*1","v":19},{"$f":"BD25+(COUNTIF($I$24:BD$24,BE$24)=0)*1","v":19},{"$f":"BE25+(COUNTIF($I$24:BE$24,BF$24)=0)*1","v":20},{"$f":"BF25+(COUNTIF($I$24:BF$24,BG$24)=0)*1","v":20},{"$f":"BG25+(COUNTIF($I$24:BG$24,BH$24)=0)*1","v":20},{"$f":"BH25+(COUNTIF($I$24:BH$24,BI$24)=0)*1","v":20},{"$f":"BI25+(COUNTIF($I$24:BI$24,BJ$24)=0)*1","v":20},{"$f":"BJ25+(COUNTIF($I$24:BJ$24,BK$24)=0)*1","v":20},{"$f":"BK25+(COUNTIF($I$24:BK$24,BL$24)=0)*1","v":20},{"$f":"BL25+(COUNTIF($I$24:BL$24,BM$24)=0)*1","v":20},{"$f":"BM25+(COUNTIF($I$24:BM$24,BN$24)=0)*1","v":20},{"$f":"BN25+(COUNTIF($I$24:BN$24,BO$24)=0)*1","v":20},{"$f":"BO25+(COUNTIF($I$24:BO$24,BP$24)=0)*1","v":20},{"$f":"BP25+(COUNTIF($I$24:BP$24,BQ$24)=0)*1","v":20}]
[null,null,null,null,"Number of Months in Full Period",null,null,null,null,{"$f":"CHOOSE(MATCH(J23,$E$18:$E$21,0),Months_in_Month,Months_in_Quarter,Months_in_Half_Yr,Months_in_Year)","v":1},1,1,1,1,1,1,1,1,1,1,1,3,3,3,3,3,3,3,3,3,3,3,3,6,6,6,6,6,6,6,6,{"$f":"CHOOSE(MATCH(AP23,$E$18:$E$21,0),Months_in_Month,Months_in_Quarter,Months_in_Half_Yr,Months_in_Year)","v":6},6,6,6,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12]
[null,null,null,null,"Number of Months in Reporting Period",null,null,null,null,{"$f":"COUNTIF(LU_Reporting_Period_No,J25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,K25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,L25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,M25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,N25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,O25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,P25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,Q25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,R25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,S25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,T25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,U25)","v":1},{"$f":"COUNTIF(LU_Reporting_Period_No,V25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,W25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,X25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,Y25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,Z25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AA25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AB25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AC25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AD25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AE25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AF25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AG25)","v":3},{"$f":"COUNTIF(LU_Reporting_Period_No,AH25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AI25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AJ25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AK25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AL25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AM25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AN25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AO25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AP25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AQ25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AR25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AS25)","v":6},{"$f":"COUNTIF(LU_Reporting_Period_No,AT25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,AU25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,AV25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,AW25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,AX25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,AY25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,AZ25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BA25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BB25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BC25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BD25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BE25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BF25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BG25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BH25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BI25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BJ25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BK25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BL25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BM25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BN25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BO25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BP25)","v":12},{"$f":"COUNTIF(LU_Reporting_Period_No,BQ25)","v":12}]
[null,null,null,null,"Scale-up Factor",null,null,null,null,{"$f":"J27/J26","v":1},{"$f":"K27/K26","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,null,null,"Number of Reporting Periods Required",null,null,null,{"$f":"MAX(LU_Reporting_Period_No)","v":20}]
[]
[]
[null,{"$f":"MAX($B$10:$B32)+1","v":2},"Monthly Data"]
[]
[null,null,"Example Monthly Outputs"]
[]
[null,null,null,{"$f":"C33","v":"Monthly Data"}]
[]
[null,null,null,null,"Net Assets",null,"$'000",null,null,195,358,466,575,728,900,1000,1171,1276,1420,1554,1727,1882,2022,2138,2262,2413,2585,2721,2850,3026,3143,3244,3378,3563,3705,3891,4039,4194,4361,4482,4644,4746,4874,5007,5160,5260,5416,5566,5666,5785,5886,6068,6187,6321,6460,6627,6789,6891,7040,7175,7323,7439,7608,7718,7911,8058,8254,8411,8582]
[]
[null,null,null,null,"Revenue",null,"$'000",null,null,343,234,114,212,377,147,151,290,328,327,270,196,281,290,282,391,244,142,154,120,176,297,238,105,143,233,386,283,235,322,231,256,195,179,177,382,400,203,142,326,374,218,154,389,280,269,209,267,109,301,224,112,198,264,396,248,200,142,336,331]
[null,null,null,null,"COGS",null,"$'000",null,null,-135,-243,-156,-181,-117,-140,-199,-181,-230,-119,-184,-114,-148,-177,-132,-184,-140,-221,-159,-124,-224,-228,-155,-151,-133,-193,-225,-128,-135,-217,-149,-247,-195,-152,-137,-192,-123,-175,-155,-188,-109,-225,-240,-212,-203,-173,-196,-196,-213,-109,-164,-118,-203,-154,-195,-200,-200,-245,-171,-221]
[]
[null,null,null,null,"Gross Profit",null,"$'000",null,null,{"$f":"SUM(J41:J42)","v":208},{"$f":"SUM(K41:K42)","v":-9},-42,31,260,7,-48,109,98,208,86,82,133,113,150,207,104,-79,-5,-4,-48,69,83,-46,10,40,161,155,100,105,82,9,0,27,40,190,277,28,-13,138,265,-7,-86,177,77,96,13,71,-104,192,60,-6,-5,110,201,48,0,-103,165,110]
[]
[null,null,null,null,"Gross Margin",null,"%",null,null,{"$f":"IF(J41,J44/J41,\"\")","v":0.60641399416909625},-3.8461538461538464E-2,-0.36842105263157893,0.14622641509433962,0.68965517241379315,4.7619047619047616E-2,-0.31788079470198677,0.37586206896551722,0.29878048780487804,0.63608562691131498,0.31851851851851853,0.41836734693877553,0.47330960854092524,0.3896551724137931,0.53191489361702127,0.52941176470588236,0.42622950819672129,-0.55633802816901412,-3.2467532467532464E-2,-3.3333333333333333E-2,-0.27272727272727271,0.23232323232323232,0.34873949579831931,-0.43809523809523809,6.9930069930069935E-2,0.17167381974248927,0.41709844559585491,0.54770318021201414,0.42553191489361702,0.32608695652173914,0.354978354978355,3.515625E-2,{"$f":"IF(AP41,AP44/AP41,\"\")","v":0},0.15083798882681565,0.22598870056497175,0.49738219895287961,0.6925,0.13793103448275862,-9.154929577464789E-2,0.42331288343558282,0.70855614973262027,-3.2110091743119268E-2,-0.55844155844155841,0.45501285347043702,0.27500000000000002,0.35687732342007433,6.2200956937799042E-2,0.26591760299625467,-0.95412844036697253,0.63787375415282388,0.26785714285714285,-5.3571428571428568E-2,-2.5252525252525252E-2,0.41666666666666669,0.50757575757575757,0.19354838709677419,0,-0.72535211267605637,0.49107142857142855,0.33232628398791542]

{"sheet":"Outputs","index":6,"n_rows":31,"n_cols":69,"rows_kept":31,"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":"Outputs"}]
[{"$f":"Model_Name","v":"SP Aggregating Time Periods.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J$7=\"\",\"\",J$7)","v":"2019-01-31"},{"$f":"IF(K$7=\"\",\"\",K$7)","v":"2019-02-28"},"2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-03-31","2020-06-30","2020-09-30","2020-12-31","2021-06-30","2021-12-31","2022-12-31","2023-12-31","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"IF(J$11=\"\",\"\",IF(J$11=1,Model_Start_Date,I$7+1))","v":"2019-01-01"},"2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-04-01","2020-07-01","2020-10-01","2021-01-01","2021-07-01","2022-01-01","2023-01-01","","","","","","","","","","","","",{"$f":"IF(AP$11=\"\",\"\",IF(AP$11=1,Model_Start_Date,AO$7+1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"IF(J$11=\"\",\"\",LOOKUP(J$11,LU_Reporting_Period_No,LU_Reporting_Month))","v":"2019-01-31"},"2019-02-28","2019-03-31","2019-04-30","2019-05-31","2019-06-30","2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31","2020-03-31","2020-06-30","2020-09-30","2020-12-31","2021-06-30","2021-12-31","2022-12-31","2023-12-31","","","","","","","","","","","","",{"$f":"IF(AP$11=\"\",\"\",LOOKUP(AP$11,LU_Reporting_Period_No,LU_Reporting_Month))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"IF(J$11=\"\",\"\",J$7-J$6+1)","v":31},{"$f":"IF(K$11=\"\",\"\",K$7-K$6+1)","v":28},31,30,31,30,31,31,30,31,30,31,91,91,92,92,181,184,365,365,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"Assumptions!E28","v":"Scale-up Factor"},null,null,null,null,null,null,{"$f":"IF(J$11=\"\",\"\",LOOKUP(J$11,LU_Reporting_Period_No,LU_Scale_Up_Factor))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"","","","","","","","","","","","",{"$f":"IF(AP$11=\"\",\"\",LOOKUP(AP$11,LU_Reporting_Period_No,LU_Scale_Up_Factor))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"Periodicity",null,null,null,null,null,null,{"$f":"IF(J$11=\"\",\"\",SUBSTITUTE(LOOKUP(J$11,LU_Reporting_Period_No,LU_Periodicity),\"ly\",\"\"))","v":"Month"},"Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Month","Quarter","Quarter","Quarter","Quarter","Half-Year","Half-Year","Annual","Annual","","","","","","","","","","","","",{"$f":"IF(AP$11=\"\",\"\",SUBSTITUTE(LOOKUP(AP$11,LU_Reporting_Period_No,LU_Periodicity),\"ly\",\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"Timing!C9","v":"Counter"},null,null,null,null,null,"None",{"$f":"IF(Assumptions!J$9>Max_No_of_Reporting_Periods,\"\",Assumptions!J$9)","v":1},{"$f":"IF(Assumptions!K$9>Max_No_of_Reporting_Periods,\"\",Assumptions!K$9)","v":2},{"$f":"IF(Assumptions!L$9>Max_No_of_Reporting_Periods,\"\",Assumptions!L$9)","v":3},{"$f":"IF(Assumptions!M$9>Max_No_of_Reporting_Periods,\"\",Assumptions!M$9)","v":4},{"$f":"IF(Assumptions!N$9>Max_No_of_Reporting_Periods,\"\",Assumptions!N$9)","v":5},{"$f":"IF(Assumptions!O$9>Max_No_of_Reporting_Periods,\"\",Assumptions!O$9)","v":6},{"$f":"IF(Assumptions!P$9>Max_No_of_Reporting_Periods,\"\",Assumptions!P$9)","v":7},{"$f":"IF(Assumptions!Q$9>Max_No_of_Reporting_Periods,\"\",Assumptions!Q$9)","v":8},{"$f":"IF(Assumptions!R$9>Max_No_of_Reporting_Periods,\"\",Assumptions!R$9)","v":9},{"$f":"IF(Assumptions!S$9>Max_No_of_Reporting_Periods,\"\",Assumptions!S$9)","v":10},{"$f":"IF(Assumptions!T$9>Max_No_of_Reporting_Periods,\"\",Assumptions!T$9)","v":11},{"$f":"IF(Assumptions!U$9>Max_No_of_Reporting_Periods,\"\",Assumptions!U$9)","v":12},{"$f":"IF(Assumptions!V$9>Max_No_of_Reporting_Periods,\"\",Assumptions!V$9)","v":13},{"$f":"IF(Assumptions!W$9>Max_No_of_Reporting_Periods,\"\",Assumptions!W$9)","v":14},{"$f":"IF(Assumptions!X$9>Max_No_of_Reporting_Periods,\"\",Assumptions!X$9)","v":15},{"$f":"IF(Assumptions!Y$9>Max_No_of_Reporting_Periods,\"\",Assumptions!Y$9)","v":16},{"$f":"IF(Assumptions!Z$9>Max_No_of_Reporting_Periods,\"\",Assumptions!Z$9)","v":17},{"$f":"IF(Assumptions!AA$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AA$9)","v":18},{"$f":"IF(Assumptions!AB$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AB$9)","v":19},{"$f":"IF(Assumptions!AC$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AC$9)","v":20},{"$f":"IF(Assumptions!AD$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AD$9)","v":""},{"$f":"IF(Assumptions!AE$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AE$9)","v":""},{"$f":"IF(Assumptions!AF$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AF$9)","v":""},{"$f":"IF(Assumptions!AG$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AG$9)","v":""},{"$f":"IF(Assumptions!AH$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AH$9)","v":""},{"$f":"IF(Assumptions!AI$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AI$9)","v":""},{"$f":"IF(Assumptions!AJ$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AJ$9)","v":""},{"$f":"IF(Assumptions!AK$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AK$9)","v":""},{"$f":"IF(Assumptions!AL$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AL$9)","v":""},{"$f":"IF(Assumptions!AM$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AM$9)","v":""},{"$f":"IF(Assumptions!AN$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AN$9)","v":""},{"$f":"IF(Assumptions!AO$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AO$9)","v":""},{"$f":"IF(Assumptions!AP$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AP$9)","v":""},{"$f":"IF(Assumptions!AQ$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AQ$9)","v":""},{"$f":"IF(Assumptions!AR$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AR$9)","v":""},{"$f":"IF(Assumptions!AS$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AS$9)","v":""},{"$f":"IF(Assumptions!AT$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AT$9)","v":""},{"$f":"IF(Assumptions!AU$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AU$9)","v":""},{"$f":"IF(Assumptions!AV$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AV$9)","v":""},{"$f":"IF(Assumptions!AW$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AW$9)","v":""},{"$f":"IF(Assumptions!AX$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AX$9)","v":""},{"$f":"IF(Assumptions!AY$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AY$9)","v":""},{"$f":"IF(Assumptions!AZ$9>Max_No_of_Reporting_Periods,\"\",Assumptions!AZ$9)","v":""},{"$f":"IF(Assumptions!BA$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BA$9)","v":""},{"$f":"IF(Assumptions!BB$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BB$9)","v":""},{"$f":"IF(Assumptions!BC$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BC$9)","v":""},{"$f":"IF(Assumptions!BD$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BD$9)","v":""},{"$f":"IF(Assumptions!BE$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BE$9)","v":""},{"$f":"IF(Assumptions!BF$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BF$9)","v":""},{"$f":"IF(Assumptions!BG$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BG$9)","v":""},{"$f":"IF(Assumptions!BH$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BH$9)","v":""},{"$f":"IF(Assumptions!BI$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BI$9)","v":""},{"$f":"IF(Assumptions!BJ$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BJ$9)","v":""},{"$f":"IF(Assumptions!BK$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BK$9)","v":""},{"$f":"IF(Assumptions!BL$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BL$9)","v":""},{"$f":"IF(Assumptions!BM$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BM$9)","v":""},{"$f":"IF(Assumptions!BN$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BN$9)","v":""},{"$f":"IF(Assumptions!BO$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BO$9)","v":""},{"$f":"IF(Assumptions!BP$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BP$9)","v":""},{"$f":"IF(Assumptions!BQ$9>Max_No_of_Reporting_Periods,\"\",Assumptions!BQ$9)","v":""}]
[]
[null,{"$f":"MAX($B$12:$B12)+1","v":1},"Example Outputs"]
[]
[null,null,"Example Aggregation"]
[]
[null,null,null,"Summary"]
[]
[null,null,null,null,"Scale Up Factor",null,"[1,0]","Off"]
[]
[]
[null,null,null,{"$f":"\"Summarised \"&Assumptions!D37","v":"Summarised Monthly Data"}]
[]
[null,null,null,null,{"$f":"Assumptions!E39","v":"Net Assets"},null,{"$f":"Assumptions!G39","v":"$'000"},null,null,{"$f":"IF(J$11=\"\",\"\",LOOKUP(J$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,J$9,1))","v":195},{"$f":"IF(K$11=\"\",\"\",LOOKUP(K$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,K$9,1))","v":358},{"$f":"IF(L$11=\"\",\"\",LOOKUP(L$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,L$9,1))","v":466},{"$f":"IF(M$11=\"\",\"\",LOOKUP(M$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,M$9,1))","v":575},{"$f":"IF(N$11=\"\",\"\",LOOKUP(N$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,N$9,1))","v":728},{"$f":"IF(O$11=\"\",\"\",LOOKUP(O$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,O$9,1))","v":900},{"$f":"IF(P$11=\"\",\"\",LOOKUP(P$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,P$9,1))","v":1000},{"$f":"IF(Q$11=\"\",\"\",LOOKUP(Q$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,Q$9,1))","v":1171},{"$f":"IF(R$11=\"\",\"\",LOOKUP(R$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,R$9,1))","v":1276},{"$f":"IF(S$11=\"\",\"\",LOOKUP(S$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,S$9,1))","v":1420},{"$f":"IF(T$11=\"\",\"\",LOOKUP(T$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,T$9,1))","v":1554},{"$f":"IF(U$11=\"\",\"\",LOOKUP(U$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,U$9,1))","v":1727},{"$f":"IF(V$11=\"\",\"\",LOOKUP(V$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,V$9,1))","v":2138},{"$f":"IF(W$11=\"\",\"\",LOOKUP(W$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,W$9,1))","v":2585},{"$f":"IF(X$11=\"\",\"\",LOOKUP(X$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,X$9,1))","v":3026},{"$f":"IF(Y$11=\"\",\"\",LOOKUP(Y$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,Y$9,1))","v":3378},{"$f":"IF(Z$11=\"\",\"\",LOOKUP(Z$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,Z$9,1))","v":4361},{"$f":"IF(AA$11=\"\",\"\",LOOKUP(AA$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AA$9,1))","v":5160},{"$f":"IF(AB$11=\"\",\"\",LOOKUP(AB$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AB$9,1))","v":6789},{"$f":"IF(AC$11=\"\",\"\",LOOKUP(AC$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AC$9,1))","v":8582},{"$f":"IF(AD$11=\"\",\"\",LOOKUP(AD$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AD$9,1))","v":""},{"$f":"IF(AE$11=\"\",\"\",LOOKUP(AE$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AE$9,1))","v":""},{"$f":"IF(AF$11=\"\",\"\",LOOKUP(AF$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AF$9,1))","v":""},{"$f":"IF(AG$11=\"\",\"\",LOOKUP(AG$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AG$9,1))","v":""},{"$f":"IF(AH$11=\"\",\"\",LOOKUP(AH$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AH$9,1))","v":""},{"$f":"IF(AI$11=\"\",\"\",LOOKUP(AI$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AI$9,1))","v":""},{"$f":"IF(AJ$11=\"\",\"\",LOOKUP(AJ$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AJ$9,1))","v":""},{"$f":"IF(AK$11=\"\",\"\",LOOKUP(AK$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AK$9,1))","v":""},{"$f":"IF(AL$11=\"\",\"\",LOOKUP(AL$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AL$9,1))","v":""},{"$f":"IF(AM$11=\"\",\"\",LOOKUP(AM$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AM$9,1))","v":""},{"$f":"IF(AN$11=\"\",\"\",LOOKUP(AN$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AN$9,1))","v":""},{"$f":"IF(AO$11=\"\",\"\",LOOKUP(AO$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AO$9,1))","v":""},{"$f":"IF(AP$11=\"\",\"\",LOOKUP(AP$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AP$9,1))","v":""},{"$f":"IF(AQ$11=\"\",\"\",LOOKUP(AQ$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AQ$9,1))","v":""},{"$f":"IF(AR$11=\"\",\"\",LOOKUP(AR$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AR$9,1))","v":""},{"$f":"IF(AS$11=\"\",\"\",LOOKUP(AS$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AS$9,1))","v":""},{"$f":"IF(AT$11=\"\",\"\",LOOKUP(AT$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AT$9,1))","v":""},{"$f":"IF(AU$11=\"\",\"\",LOOKUP(AU$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AU$9,1))","v":""},{"$f":"IF(AV$11=\"\",\"\",LOOKUP(AV$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AV$9,1))","v":""},{"$f":"IF(AW$11=\"\",\"\",LOOKUP(AW$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AW$9,1))","v":""},{"$f":"IF(AX$11=\"\",\"\",LOOKUP(AX$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AX$9,1))","v":""},{"$f":"IF(AY$11=\"\",\"\",LOOKUP(AY$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AY$9,1))","v":""},{"$f":"IF(AZ$11=\"\",\"\",LOOKUP(AZ$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,AZ$9,1))","v":""},{"$f":"IF(BA$11=\"\",\"\",LOOKUP(BA$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BA$9,1))","v":""},{"$f":"IF(BB$11=\"\",\"\",LOOKUP(BB$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BB$9,1))","v":""},{"$f":"IF(BC$11=\"\",\"\",LOOKUP(BC$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BC$9,1))","v":""},{"$f":"IF(BD$11=\"\",\"\",LOOKUP(BD$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BD$9,1))","v":""},{"$f":"IF(BE$11=\"\",\"\",LOOKUP(BE$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BE$9,1))","v":""},{"$f":"IF(BF$11=\"\",\"\",LOOKUP(BF$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BF$9,1))","v":""},{"$f":"IF(BG$11=\"\",\"\",LOOKUP(BG$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BG$9,1))","v":""},{"$f":"IF(BH$11=\"\",\"\",LOOKUP(BH$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BH$9,1))","v":""},{"$f":"IF(BI$11=\"\",\"\",LOOKUP(BI$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BI$9,1))","v":""},{"$f":"IF(BJ$11=\"\",\"\",LOOKUP(BJ$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BJ$9,1))","v":""},{"$f":"IF(BK$11=\"\",\"\",LOOKUP(BK$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BK$9,1))","v":""},{"$f":"IF(BL$11=\"\",\"\",LOOKUP(BL$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BL$9,1))","v":""},{"$f":"IF(BM$11=\"\",\"\",LOOKUP(BM$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BM$9,1))","v":""},{"$f":"IF(BN$11=\"\",\"\",LOOKUP(BN$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BN$9,1))","v":""},{"$f":"IF(BO$11=\"\",\"\",LOOKUP(BO$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BO$9,1))","v":""},{"$f":"IF(BP$11=\"\",\"\",LOOKUP(BP$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BP$9,1))","v":""},{"$f":"IF(BQ$11=\"\",\"\",LOOKUP(BQ$11,LU_Reporting_Period_No,Assumptions!$J39:$BQ39)/IF(Scale_Up_Factor_Switch=On,BQ$9,1))","v":""}]
[]
[null,null,null,null,{"$f":"Assumptions!E41","v":"Revenue"},null,{"$f":"Assumptions!G41","v":"$'000"},null,null,{"$f":"IF(J$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,J$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,J$9,1))","v":343},{"$f":"IF(K$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,K$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,K$9,1))","v":234},{"$f":"IF(L$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,L$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,L$9,1))","v":114},{"$f":"IF(M$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,M$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,M$9,1))","v":212},{"$f":"IF(N$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,N$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,N$9,1))","v":377},{"$f":"IF(O$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,O$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,O$9,1))","v":147},{"$f":"IF(P$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,P$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,P$9,1))","v":151},{"$f":"IF(Q$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,Q$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,Q$9,1))","v":290},{"$f":"IF(R$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,R$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,R$9,1))","v":328},{"$f":"IF(S$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,S$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,S$9,1))","v":327},{"$f":"IF(T$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,T$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,T$9,1))","v":270},{"$f":"IF(U$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,U$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,U$9,1))","v":196},{"$f":"IF(V$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,V$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,V$9,1))","v":853},{"$f":"IF(W$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,W$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,W$9,1))","v":777},{"$f":"IF(X$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,X$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,X$9,1))","v":450},{"$f":"IF(Y$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,Y$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,Y$9,1))","v":640},{"$f":"IF(Z$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,Z$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,Z$9,1))","v":1602},{"$f":"IF(AA$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AA$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AA$9,1))","v":1420},{"$f":"IF(AB$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AB$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AB$9,1))","v":3231},{"$f":"IF(AC$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AC$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AC$9,1))","v":2861},{"$f":"IF(AD$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AD$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AD$9,1))","v":""},{"$f":"IF(AE$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AE$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AE$9,1))","v":""},{"$f":"IF(AF$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AF$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AF$9,1))","v":""},{"$f":"IF(AG$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AG$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AG$9,1))","v":""},{"$f":"IF(AH$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AH$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AH$9,1))","v":""},{"$f":"IF(AI$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AI$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AI$9,1))","v":""},{"$f":"IF(AJ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AJ$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AJ$9,1))","v":""},{"$f":"IF(AK$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AK$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AK$9,1))","v":""},{"$f":"IF(AL$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AL$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AL$9,1))","v":""},{"$f":"IF(AM$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AM$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AM$9,1))","v":""},{"$f":"IF(AN$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AN$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AN$9,1))","v":""},{"$f":"IF(AO$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AO$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AO$9,1))","v":""},{"$f":"IF(AP$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AP$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AP$9,1))","v":""},{"$f":"IF(AQ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AQ$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AQ$9,1))","v":""},{"$f":"IF(AR$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AR$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AR$9,1))","v":""},{"$f":"IF(AS$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AS$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AS$9,1))","v":""},{"$f":"IF(AT$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AT$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AT$9,1))","v":""},{"$f":"IF(AU$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AU$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AU$9,1))","v":""},{"$f":"IF(AV$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AV$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AV$9,1))","v":""},{"$f":"IF(AW$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AW$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AW$9,1))","v":""},{"$f":"IF(AX$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AX$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AX$9,1))","v":""},{"$f":"IF(AY$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AY$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AY$9,1))","v":""},{"$f":"IF(AZ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AZ$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,AZ$9,1))","v":""},{"$f":"IF(BA$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BA$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BA$9,1))","v":""},{"$f":"IF(BB$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BB$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BB$9,1))","v":""},{"$f":"IF(BC$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BC$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BC$9,1))","v":""},{"$f":"IF(BD$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BD$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BD$9,1))","v":""},{"$f":"IF(BE$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BE$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BE$9,1))","v":""},{"$f":"IF(BF$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BF$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BF$9,1))","v":""},{"$f":"IF(BG$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BG$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BG$9,1))","v":""},{"$f":"IF(BH$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BH$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BH$9,1))","v":""},{"$f":"IF(BI$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BI$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BI$9,1))","v":""},{"$f":"IF(BJ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BJ$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BJ$9,1))","v":""},{"$f":"IF(BK$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BK$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BK$9,1))","v":""},{"$f":"IF(BL$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BL$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BL$9,1))","v":""},{"$f":"IF(BM$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BM$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BM$9,1))","v":""},{"$f":"IF(BN$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BN$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BN$9,1))","v":""},{"$f":"IF(BO$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BO$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BO$9,1))","v":""},{"$f":"IF(BP$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BP$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BP$9,1))","v":""},{"$f":"IF(BQ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BQ$11,Assumptions!$J41:$BQ41)/IF(Scale_Up_Factor_Switch=On,BQ$9,1))","v":""}]
[null,null,null,null,{"$f":"Assumptions!E42","v":"COGS"},null,{"$f":"Assumptions!G42","v":"$'000"},null,null,{"$f":"IF(J$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,J$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,J$9,1))","v":-135},{"$f":"IF(K$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,K$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,K$9,1))","v":-243},{"$f":"IF(L$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,L$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,L$9,1))","v":-156},{"$f":"IF(M$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,M$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,M$9,1))","v":-181},{"$f":"IF(N$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,N$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,N$9,1))","v":-117},{"$f":"IF(O$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,O$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,O$9,1))","v":-140},{"$f":"IF(P$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,P$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,P$9,1))","v":-199},{"$f":"IF(Q$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,Q$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,Q$9,1))","v":-181},{"$f":"IF(R$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,R$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,R$9,1))","v":-230},{"$f":"IF(S$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,S$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,S$9,1))","v":-119},{"$f":"IF(T$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,T$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,T$9,1))","v":-184},{"$f":"IF(U$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,U$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,U$9,1))","v":-114},{"$f":"IF(V$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,V$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,V$9,1))","v":-457},{"$f":"IF(W$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,W$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,W$9,1))","v":-545},{"$f":"IF(X$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,X$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,X$9,1))","v":-507},{"$f":"IF(Y$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,Y$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,Y$9,1))","v":-534},{"$f":"IF(Z$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,Z$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,Z$9,1))","v":-1031},{"$f":"IF(AA$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AA$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AA$9,1))","v":-1072},{"$f":"IF(AB$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AB$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AB$9,1))","v":-2195},{"$f":"IF(AC$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AC$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AC$9,1))","v":-2193},{"$f":"IF(AD$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AD$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AD$9,1))","v":""},{"$f":"IF(AE$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AE$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AE$9,1))","v":""},{"$f":"IF(AF$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AF$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AF$9,1))","v":""},{"$f":"IF(AG$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AG$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AG$9,1))","v":""},{"$f":"IF(AH$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AH$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AH$9,1))","v":""},{"$f":"IF(AI$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AI$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AI$9,1))","v":""},{"$f":"IF(AJ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AJ$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AJ$9,1))","v":""},{"$f":"IF(AK$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AK$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AK$9,1))","v":""},{"$f":"IF(AL$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AL$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AL$9,1))","v":""},{"$f":"IF(AM$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AM$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AM$9,1))","v":""},{"$f":"IF(AN$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AN$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AN$9,1))","v":""},{"$f":"IF(AO$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AO$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AO$9,1))","v":""},{"$f":"IF(AP$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AP$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AP$9,1))","v":""},{"$f":"IF(AQ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AQ$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AQ$9,1))","v":""},{"$f":"IF(AR$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AR$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AR$9,1))","v":""},{"$f":"IF(AS$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AS$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AS$9,1))","v":""},{"$f":"IF(AT$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AT$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AT$9,1))","v":""},{"$f":"IF(AU$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AU$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AU$9,1))","v":""},{"$f":"IF(AV$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AV$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AV$9,1))","v":""},{"$f":"IF(AW$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AW$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AW$9,1))","v":""},{"$f":"IF(AX$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AX$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AX$9,1))","v":""},{"$f":"IF(AY$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AY$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AY$9,1))","v":""},{"$f":"IF(AZ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,AZ$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,AZ$9,1))","v":""},{"$f":"IF(BA$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BA$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BA$9,1))","v":""},{"$f":"IF(BB$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BB$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BB$9,1))","v":""},{"$f":"IF(BC$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BC$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BC$9,1))","v":""},{"$f":"IF(BD$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BD$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BD$9,1))","v":""},{"$f":"IF(BE$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BE$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BE$9,1))","v":""},{"$f":"IF(BF$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BF$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BF$9,1))","v":""},{"$f":"IF(BG$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BG$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BG$9,1))","v":""},{"$f":"IF(BH$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BH$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BH$9,1))","v":""},{"$f":"IF(BI$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BI$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BI$9,1))","v":""},{"$f":"IF(BJ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BJ$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BJ$9,1))","v":""},{"$f":"IF(BK$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BK$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BK$9,1))","v":""},{"$f":"IF(BL$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BL$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BL$9,1))","v":""},{"$f":"IF(BM$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BM$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BM$9,1))","v":""},{"$f":"IF(BN$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BN$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BN$9,1))","v":""},{"$f":"IF(BO$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BO$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BO$9,1))","v":""},{"$f":"IF(BP$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BP$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BP$9,1))","v":""},{"$f":"IF(BQ$11=\"\",\"\",SUMIF(LU_Reporting_Period_No,BQ$11,Assumptions!$J42:$BQ42)/IF(Scale_Up_Factor_Switch=On,BQ$9,1))","v":""}]
[]
[null,null,null,null,{"$f":"Assumptions!E44","v":"Gross Profit"},null,{"$f":"Assumptions!G44","v":"$'000"},null,null,{"$f":"IF(J$11=\"\",\"\",SUM(J26:J27))","v":208},{"$f":"IF(K$11=\"\",\"\",SUM(K26:K27))","v":-9},-42,31,260,7,-48,109,98,208,86,82,396,232,-57,106,571,348,1036,668,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,null,{"$f":"Assumptions!E46","v":"Gross Margin"},null,{"$f":"Assumptions!G46","v":"%"},null,null,{"$f":"IF(J$11=\"\",\"\",IF(J26,J29/J26,\"\"))","v":0.60641399416909625},{"$f":"IF(K$11=\"\",\"\",IF(K26,K29/K26,\"\"))","v":-3.8461538461538464E-2},-0.36842105263157893,0.14622641509433962,0.68965517241379315,4.7619047619047616E-2,-0.31788079470198677,0.37586206896551722,0.29878048780487804,0.63608562691131498,0.31851851851851853,0.41836734693877553,0.46424384525205159,0.29858429858429858,-0.12666666666666668,0.16562499999999999,0.35642946317103619,0.24507042253521127,0.32064376354069946,0.23348479552603985,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Lookup Data","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"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":"Lookup Data"}]
[{"$f":"Model_Name","v":"SP Aggregating Time Periods.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"On or Off"]
[]
[null,null,{"$f":"\"LU_\"&SUBSTITUTE(C6,\" \",\"_\")","v":"LU_On_or_Off"}]
[]
[null,null,null,null,null,{"$f":"C6","v":"On or Off"}]
[null,null,null,null,null,"On",null,{"$f":"C8","v":"LU_On_or_Off"}]
[null,null,null,null,null,"Off"]

{"sheet":"Error Checks","index":8,"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 Aggregating Time Periods.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,"Not Used"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]