{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Navigator","Style Guide","Depreciation Calculation","Model Parameters","Timing","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":34,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"ICAEW"}]
[null,null,{"$f":"Model_Name","v":"SP - Using OFFSET for Depreciation.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"How OFFSET can make depreciation calculations easier"]
[null,null,"(and assist you in transposing data)."]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP - Using OFFSET for Depreciation.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,"Depreciation Calculation"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"Timing"]
[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 - Using OFFSET for Depreciation.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":"Depreciation Reconciles"},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":"2016-06-12"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2016-06-12"},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":"Depreciation Calculation","index":3,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4],[29,4,29,5],[30,4,30,5],[31,4,31,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5]]}
[{"$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":"Depreciation Calculation"}]
[{"$f":"Model_Name","v":"SP - Using OFFSET for Depreciation.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":"2017-12-31"},{"$f":"Timing!K5","v":"2018-12-31"},{"$f":"Timing!L5","v":"2019-12-31"},{"$f":"Timing!M5","v":"2020-12-31"},{"$f":"Timing!N5","v":"2021-12-31"},{"$f":"Timing!O5","v":"2022-12-31"},{"$f":"Timing!P5","v":"2023-12-31"},{"$f":"Timing!Q5","v":"2024-12-31"},{"$f":"Timing!R5","v":"2025-12-31"},{"$f":"Timing!S5","v":"2026-12-31"},{"$f":"Timing!T5","v":"2027-12-31"},{"$f":"Timing!U5","v":"2028-12-31"}]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"Timing!J6","v":"2017-01-01"},{"$f":"Timing!K6","v":"2018-01-01"},{"$f":"Timing!L6","v":"2019-01-01"},{"$f":"Timing!M6","v":"2020-01-01"},{"$f":"Timing!N6","v":"2021-01-01"},{"$f":"Timing!O6","v":"2022-01-01"},{"$f":"Timing!P6","v":"2023-01-01"},{"$f":"Timing!Q6","v":"2024-01-01"},{"$f":"Timing!R6","v":"2025-01-01"},{"$f":"Timing!S6","v":"2026-01-01"},{"$f":"Timing!T6","v":"2027-01-01"},{"$f":"Timing!U6","v":"2028-01-01"}]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"Timing!J7","v":"2017-12-31"},{"$f":"Timing!K7","v":"2018-12-31"},{"$f":"Timing!L7","v":"2019-12-31"},{"$f":"Timing!M7","v":"2020-12-31"},{"$f":"Timing!N7","v":"2021-12-31"},{"$f":"Timing!O7","v":"2022-12-31"},{"$f":"Timing!P7","v":"2023-12-31"},{"$f":"Timing!Q7","v":"2024-12-31"},{"$f":"Timing!R7","v":"2025-12-31"},{"$f":"Timing!S7","v":"2026-12-31"},{"$f":"Timing!T7","v":"2027-12-31"},{"$f":"Timing!U7","v":"2028-12-31"}]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"Timing!J8","v":365},{"$f":"Timing!K8","v":365},{"$f":"Timing!L8","v":365},{"$f":"Timing!M8","v":366},{"$f":"Timing!N8","v":365},{"$f":"Timing!O8","v":365},{"$f":"Timing!P8","v":365},{"$f":"Timing!Q8","v":366},{"$f":"Timing!R8","v":365},{"$f":"Timing!S8","v":365},{"$f":"Timing!T8","v":365},{"$f":"Timing!U8","v":366}]
[null,null,"Counter",null,null,null,null,null,null,{"$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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Depreciation Calculation"}]
[]
[null,null,"Assumptions"]
[]
[null,null,null,null,"Economic Life",null,"Years",5]
[]
[null,null,null,null,"Annual Depreciation Rate",null,"%",{"$f":"IF(Economic_Life,1/Economic_Life,)","v":0.2}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"N(I19)+1","v":1},{"$f":"N(J19)+1","v":2},{"$f":"N(K19)+1","v":3},{"$f":"N(L19)+1","v":4},{"$f":"N(M19)+1","v":5},{"$f":"N(N19)+1","v":6},{"$f":"N(O19)+1","v":7},{"$f":"N(P19)+1","v":8},{"$f":"N(Q19)+1","v":9},{"$f":"N(R19)+1","v":10},{"$f":"N(S19)+1","v":11},{"$f":"N(T19)+1","v":12}]
[]
[null,null,null,null,"Capital Expenditure",null,"£'000",null,null,100,200,300,400,500,600,700,800,900,1000,1100,1200]
[]
[]
[null,null,"Depreciation Calculations"]
[]
[null,null,null,"Typical"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"N(I28)+1","v":1},{"$f":"N(J28)+1","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[null,null,null,null,{"$f":"ROWS($D$30:$D30)","v":1},null,"£'000",{"$f":"OFFSET(BC_Capex,,$E30)","v":100},null,{"$f":"IF(J$28>=$E30,MIN($H30-SUM($I30:I30),$H30*Depn_Rate),)","v":20},{"$f":"IF(K$28>=$E30,MIN($H30-SUM($I30:J30),$H30*Depn_Rate),)","v":20},{"$f":"IF(L$28>=$E30,MIN($H30-SUM($I30:K30),$H30*Depn_Rate),)","v":20},{"$f":"IF(M$28>=$E30,MIN($H30-SUM($I30:L30),$H30*Depn_Rate),)","v":20},{"$f":"IF(N$28>=$E30,MIN($H30-SUM($I30:M30),$H30*Depn_Rate),)","v":20},{"$f":"IF(O$28>=$E30,MIN($H30-SUM($I30:N30),$H30*Depn_Rate),)","v":0},{"$f":"IF(P$28>=$E30,MIN($H30-SUM($I30:O30),$H30*Depn_Rate),)","v":0},{"$f":"IF(Q$28>=$E30,MIN($H30-SUM($I30:P30),$H30*Depn_Rate),)","v":0},{"$f":"IF(R$28>=$E30,MIN($H30-SUM($I30:Q30),$H30*Depn_Rate),)","v":0},{"$f":"IF(S$28>=$E30,MIN($H30-SUM($I30:R30),$H30*Depn_Rate),)","v":0},{"$f":"IF(T$28>=$E30,MIN($H30-SUM($I30:S30),$H30*Depn_Rate),)","v":0},{"$f":"IF(U$28>=$E30,MIN($H30-SUM($I30:T30),$H30*Depn_Rate),)","v":0}]
[null,null,null,null,{"$f":"ROWS($D$30:$D31)","v":2},null,"£'000",200,null,{"$f":"IF(J$28>=$E31,MIN($H31-SUM($I31:I31),$H31*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E31,MIN($H31-SUM($I31:J31),$H31*Depn_Rate),)","v":40},{"$f":"IF(L$28>=$E31,MIN($H31-SUM($I31:K31),$H31*Depn_Rate),)","v":40},{"$f":"IF(M$28>=$E31,MIN($H31-SUM($I31:L31),$H31*Depn_Rate),)","v":40},{"$f":"IF(N$28>=$E31,MIN($H31-SUM($I31:M31),$H31*Depn_Rate),)","v":40},{"$f":"IF(O$28>=$E31,MIN($H31-SUM($I31:N31),$H31*Depn_Rate),)","v":40},{"$f":"IF(P$28>=$E31,MIN($H31-SUM($I31:O31),$H31*Depn_Rate),)","v":0},{"$f":"IF(Q$28>=$E31,MIN($H31-SUM($I31:P31),$H31*Depn_Rate),)","v":0},{"$f":"IF(R$28>=$E31,MIN($H31-SUM($I31:Q31),$H31*Depn_Rate),)","v":0},{"$f":"IF(S$28>=$E31,MIN($H31-SUM($I31:R31),$H31*Depn_Rate),)","v":0},{"$f":"IF(T$28>=$E31,MIN($H31-SUM($I31:S31),$H31*Depn_Rate),)","v":0},{"$f":"IF(U$28>=$E31,MIN($H31-SUM($I31:T31),$H31*Depn_Rate),)","v":0}]
[null,null,null,null,{"$f":"ROWS($D$30:$D32)","v":3},null,"£'000",300,null,{"$f":"IF(J$28>=$E32,MIN($H32-SUM($I32:I32),$H32*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E32,MIN($H32-SUM($I32:J32),$H32*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E32,MIN($H32-SUM($I32:K32),$H32*Depn_Rate),)","v":60},{"$f":"IF(M$28>=$E32,MIN($H32-SUM($I32:L32),$H32*Depn_Rate),)","v":60},{"$f":"IF(N$28>=$E32,MIN($H32-SUM($I32:M32),$H32*Depn_Rate),)","v":60},{"$f":"IF(O$28>=$E32,MIN($H32-SUM($I32:N32),$H32*Depn_Rate),)","v":60},{"$f":"IF(P$28>=$E32,MIN($H32-SUM($I32:O32),$H32*Depn_Rate),)","v":60},{"$f":"IF(Q$28>=$E32,MIN($H32-SUM($I32:P32),$H32*Depn_Rate),)","v":0},{"$f":"IF(R$28>=$E32,MIN($H32-SUM($I32:Q32),$H32*Depn_Rate),)","v":0},{"$f":"IF(S$28>=$E32,MIN($H32-SUM($I32:R32),$H32*Depn_Rate),)","v":0},{"$f":"IF(T$28>=$E32,MIN($H32-SUM($I32:S32),$H32*Depn_Rate),)","v":0},{"$f":"IF(U$28>=$E32,MIN($H32-SUM($I32:T32),$H32*Depn_Rate),)","v":0}]
[null,null,null,null,{"$f":"ROWS($D$30:$D33)","v":4},null,"£'000",400,null,{"$f":"IF(J$28>=$E33,MIN($H33-SUM($I33:I33),$H33*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E33,MIN($H33-SUM($I33:J33),$H33*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E33,MIN($H33-SUM($I33:K33),$H33*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E33,MIN($H33-SUM($I33:L33),$H33*Depn_Rate),)","v":80},{"$f":"IF(N$28>=$E33,MIN($H33-SUM($I33:M33),$H33*Depn_Rate),)","v":80},{"$f":"IF(O$28>=$E33,MIN($H33-SUM($I33:N33),$H33*Depn_Rate),)","v":80},{"$f":"IF(P$28>=$E33,MIN($H33-SUM($I33:O33),$H33*Depn_Rate),)","v":80},{"$f":"IF(Q$28>=$E33,MIN($H33-SUM($I33:P33),$H33*Depn_Rate),)","v":80},{"$f":"IF(R$28>=$E33,MIN($H33-SUM($I33:Q33),$H33*Depn_Rate),)","v":0},{"$f":"IF(S$28>=$E33,MIN($H33-SUM($I33:R33),$H33*Depn_Rate),)","v":0},{"$f":"IF(T$28>=$E33,MIN($H33-SUM($I33:S33),$H33*Depn_Rate),)","v":0},{"$f":"IF(U$28>=$E33,MIN($H33-SUM($I33:T33),$H33*Depn_Rate),)","v":0}]
[null,null,null,null,{"$f":"ROWS($D$30:$D34)","v":5},null,"£'000",500,null,{"$f":"IF(J$28>=$E34,MIN($H34-SUM($I34:I34),$H34*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E34,MIN($H34-SUM($I34:J34),$H34*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E34,MIN($H34-SUM($I34:K34),$H34*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E34,MIN($H34-SUM($I34:L34),$H34*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E34,MIN($H34-SUM($I34:M34),$H34*Depn_Rate),)","v":100},{"$f":"IF(O$28>=$E34,MIN($H34-SUM($I34:N34),$H34*Depn_Rate),)","v":100},{"$f":"IF(P$28>=$E34,MIN($H34-SUM($I34:O34),$H34*Depn_Rate),)","v":100},{"$f":"IF(Q$28>=$E34,MIN($H34-SUM($I34:P34),$H34*Depn_Rate),)","v":100},{"$f":"IF(R$28>=$E34,MIN($H34-SUM($I34:Q34),$H34*Depn_Rate),)","v":100},{"$f":"IF(S$28>=$E34,MIN($H34-SUM($I34:R34),$H34*Depn_Rate),)","v":0},{"$f":"IF(T$28>=$E34,MIN($H34-SUM($I34:S34),$H34*Depn_Rate),)","v":0},{"$f":"IF(U$28>=$E34,MIN($H34-SUM($I34:T34),$H34*Depn_Rate),)","v":0}]
[null,null,null,null,{"$f":"ROWS($D$30:$D35)","v":6},null,"£'000",600,null,{"$f":"IF(J$28>=$E35,MIN($H35-SUM($I35:I35),$H35*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E35,MIN($H35-SUM($I35:J35),$H35*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E35,MIN($H35-SUM($I35:K35),$H35*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E35,MIN($H35-SUM($I35:L35),$H35*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E35,MIN($H35-SUM($I35:M35),$H35*Depn_Rate),)","v":0},{"$f":"IF(O$28>=$E35,MIN($H35-SUM($I35:N35),$H35*Depn_Rate),)","v":120},{"$f":"IF(P$28>=$E35,MIN($H35-SUM($I35:O35),$H35*Depn_Rate),)","v":120},{"$f":"IF(Q$28>=$E35,MIN($H35-SUM($I35:P35),$H35*Depn_Rate),)","v":120},{"$f":"IF(R$28>=$E35,MIN($H35-SUM($I35:Q35),$H35*Depn_Rate),)","v":120},{"$f":"IF(S$28>=$E35,MIN($H35-SUM($I35:R35),$H35*Depn_Rate),)","v":120},{"$f":"IF(T$28>=$E35,MIN($H35-SUM($I35:S35),$H35*Depn_Rate),)","v":0},{"$f":"IF(U$28>=$E35,MIN($H35-SUM($I35:T35),$H35*Depn_Rate),)","v":0}]
[null,null,null,null,{"$f":"ROWS($D$30:$D36)","v":7},null,"£'000",700,null,{"$f":"IF(J$28>=$E36,MIN($H36-SUM($I36:I36),$H36*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E36,MIN($H36-SUM($I36:J36),$H36*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E36,MIN($H36-SUM($I36:K36),$H36*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E36,MIN($H36-SUM($I36:L36),$H36*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E36,MIN($H36-SUM($I36:M36),$H36*Depn_Rate),)","v":0},{"$f":"IF(O$28>=$E36,MIN($H36-SUM($I36:N36),$H36*Depn_Rate),)","v":0},{"$f":"IF(P$28>=$E36,MIN($H36-SUM($I36:O36),$H36*Depn_Rate),)","v":140},{"$f":"IF(Q$28>=$E36,MIN($H36-SUM($I36:P36),$H36*Depn_Rate),)","v":140},{"$f":"IF(R$28>=$E36,MIN($H36-SUM($I36:Q36),$H36*Depn_Rate),)","v":140},{"$f":"IF(S$28>=$E36,MIN($H36-SUM($I36:R36),$H36*Depn_Rate),)","v":140},{"$f":"IF(T$28>=$E36,MIN($H36-SUM($I36:S36),$H36*Depn_Rate),)","v":140},{"$f":"IF(U$28>=$E36,MIN($H36-SUM($I36:T36),$H36*Depn_Rate),)","v":0}]
[null,null,null,null,{"$f":"ROWS($D$30:$D37)","v":8},null,"£'000",800,null,{"$f":"IF(J$28>=$E37,MIN($H37-SUM($I37:I37),$H37*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E37,MIN($H37-SUM($I37:J37),$H37*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E37,MIN($H37-SUM($I37:K37),$H37*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E37,MIN($H37-SUM($I37:L37),$H37*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E37,MIN($H37-SUM($I37:M37),$H37*Depn_Rate),)","v":0},{"$f":"IF(O$28>=$E37,MIN($H37-SUM($I37:N37),$H37*Depn_Rate),)","v":0},{"$f":"IF(P$28>=$E37,MIN($H37-SUM($I37:O37),$H37*Depn_Rate),)","v":0},{"$f":"IF(Q$28>=$E37,MIN($H37-SUM($I37:P37),$H37*Depn_Rate),)","v":160},{"$f":"IF(R$28>=$E37,MIN($H37-SUM($I37:Q37),$H37*Depn_Rate),)","v":160},{"$f":"IF(S$28>=$E37,MIN($H37-SUM($I37:R37),$H37*Depn_Rate),)","v":160},{"$f":"IF(T$28>=$E37,MIN($H37-SUM($I37:S37),$H37*Depn_Rate),)","v":160},{"$f":"IF(U$28>=$E37,MIN($H37-SUM($I37:T37),$H37*Depn_Rate),)","v":160}]
[null,null,null,null,{"$f":"ROWS($D$30:$D38)","v":9},null,"£'000",900,null,{"$f":"IF(J$28>=$E38,MIN($H38-SUM($I38:I38),$H38*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E38,MIN($H38-SUM($I38:J38),$H38*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E38,MIN($H38-SUM($I38:K38),$H38*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E38,MIN($H38-SUM($I38:L38),$H38*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E38,MIN($H38-SUM($I38:M38),$H38*Depn_Rate),)","v":0},{"$f":"IF(O$28>=$E38,MIN($H38-SUM($I38:N38),$H38*Depn_Rate),)","v":0},{"$f":"IF(P$28>=$E38,MIN($H38-SUM($I38:O38),$H38*Depn_Rate),)","v":0},{"$f":"IF(Q$28>=$E38,MIN($H38-SUM($I38:P38),$H38*Depn_Rate),)","v":0},{"$f":"IF(R$28>=$E38,MIN($H38-SUM($I38:Q38),$H38*Depn_Rate),)","v":180},{"$f":"IF(S$28>=$E38,MIN($H38-SUM($I38:R38),$H38*Depn_Rate),)","v":180},{"$f":"IF(T$28>=$E38,MIN($H38-SUM($I38:S38),$H38*Depn_Rate),)","v":180},{"$f":"IF(U$28>=$E38,MIN($H38-SUM($I38:T38),$H38*Depn_Rate),)","v":180}]
[null,null,null,null,{"$f":"ROWS($D$30:$D39)","v":10},null,"£'000",1000,null,{"$f":"IF(J$28>=$E39,MIN($H39-SUM($I39:I39),$H39*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E39,MIN($H39-SUM($I39:J39),$H39*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E39,MIN($H39-SUM($I39:K39),$H39*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E39,MIN($H39-SUM($I39:L39),$H39*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E39,MIN($H39-SUM($I39:M39),$H39*Depn_Rate),)","v":0},{"$f":"IF(O$28>=$E39,MIN($H39-SUM($I39:N39),$H39*Depn_Rate),)","v":0},{"$f":"IF(P$28>=$E39,MIN($H39-SUM($I39:O39),$H39*Depn_Rate),)","v":0},{"$f":"IF(Q$28>=$E39,MIN($H39-SUM($I39:P39),$H39*Depn_Rate),)","v":0},{"$f":"IF(R$28>=$E39,MIN($H39-SUM($I39:Q39),$H39*Depn_Rate),)","v":0},{"$f":"IF(S$28>=$E39,MIN($H39-SUM($I39:R39),$H39*Depn_Rate),)","v":200},{"$f":"IF(T$28>=$E39,MIN($H39-SUM($I39:S39),$H39*Depn_Rate),)","v":200},{"$f":"IF(U$28>=$E39,MIN($H39-SUM($I39:T39),$H39*Depn_Rate),)","v":200}]
[null,null,null,null,{"$f":"ROWS($D$30:$D40)","v":11},null,"£'000",1100,null,{"$f":"IF(J$28>=$E40,MIN($H40-SUM($I40:I40),$H40*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E40,MIN($H40-SUM($I40:J40),$H40*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E40,MIN($H40-SUM($I40:K40),$H40*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E40,MIN($H40-SUM($I40:L40),$H40*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E40,MIN($H40-SUM($I40:M40),$H40*Depn_Rate),)","v":0},{"$f":"IF(O$28>=$E40,MIN($H40-SUM($I40:N40),$H40*Depn_Rate),)","v":0},{"$f":"IF(P$28>=$E40,MIN($H40-SUM($I40:O40),$H40*Depn_Rate),)","v":0},{"$f":"IF(Q$28>=$E40,MIN($H40-SUM($I40:P40),$H40*Depn_Rate),)","v":0},{"$f":"IF(R$28>=$E40,MIN($H40-SUM($I40:Q40),$H40*Depn_Rate),)","v":0},{"$f":"IF(S$28>=$E40,MIN($H40-SUM($I40:R40),$H40*Depn_Rate),)","v":0},{"$f":"IF(T$28>=$E40,MIN($H40-SUM($I40:S40),$H40*Depn_Rate),)","v":220},{"$f":"IF(U$28>=$E40,MIN($H40-SUM($I40:T40),$H40*Depn_Rate),)","v":220}]
[null,null,null,null,{"$f":"ROWS($D$30:$D41)","v":12},null,"£'000",1200,null,{"$f":"IF(J$28>=$E41,MIN($H41-SUM($I41:I41),$H41*Depn_Rate),)","v":0},{"$f":"IF(K$28>=$E41,MIN($H41-SUM($I41:J41),$H41*Depn_Rate),)","v":0},{"$f":"IF(L$28>=$E41,MIN($H41-SUM($I41:K41),$H41*Depn_Rate),)","v":0},{"$f":"IF(M$28>=$E41,MIN($H41-SUM($I41:L41),$H41*Depn_Rate),)","v":0},{"$f":"IF(N$28>=$E41,MIN($H41-SUM($I41:M41),$H41*Depn_Rate),)","v":0},{"$f":"IF(O$28>=$E41,MIN($H41-SUM($I41:N41),$H41*Depn_Rate),)","v":0},{"$f":"IF(P$28>=$E41,MIN($H41-SUM($I41:O41),$H41*Depn_Rate),)","v":0},{"$f":"IF(Q$28>=$E41,MIN($H41-SUM($I41:P41),$H41*Depn_Rate),)","v":0},{"$f":"IF(R$28>=$E41,MIN($H41-SUM($I41:Q41),$H41*Depn_Rate),)","v":0},{"$f":"IF(S$28>=$E41,MIN($H41-SUM($I41:R41),$H41*Depn_Rate),)","v":0},{"$f":"IF(T$28>=$E41,MIN($H41-SUM($I41:S41),$H41*Depn_Rate),)","v":0},{"$f":"IF(U$28>=$E41,MIN($H41-SUM($I41:T41),$H41*Depn_Rate),)","v":240}]
[]
[null,null,null,null,"Depreciation Charge",null,"£'000",null,null,{"$f":"SUM(J30:J41)","v":20},{"$f":"SUM(K30:K41)","v":60},120,200,300,400,500,600,700,800,900,1000]
[]
[]
[null,null,null,"SUM(OFFSET) Method"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"N(I48)+1","v":1},{"$f":"N(J48)+1","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[null,null,null,null,"Depreciation Counter",null,"#",null,null,{"$f":"MIN(J48,Economic_Life)","v":1},2,3,4,5,5,5,5,5,5,5,5]
[]
[null,null,null,null,{"$f":"E21","v":"Capital Expenditure"},null,"£'000",null,null,{"$f":"J21","v":100},{"$f":"K21","v":200},300,400,500,600,700,800,900,1000,1100,1200]
[]
[null,null,null,null,"Annual Depreciation",null,"£'000",{"$f":"Depn_Rate","v":0.2},null,{"$f":"J52*Depn_Rate","v":20},40,60,80,100,120,140,160,180,200,220,240]
[]
[null,null,null,null,"Depreciation Charge",null,"£'000",null,null,{"$f":"SUM(OFFSET(J$54,,,,-J50))","v":20},{"$f":"SUM(OFFSET(K$54,,,,-K50))","v":60},120,200,300,400,500,600,700,800,900,1000]
[]
[]
[null,null,null,null,"Error Check",null,"[1,0]",null,{"$f":"MIN(SUM(J59:U59),1)","v":0},{"$f":"(ROUND(J43-J56,Rounding_Accuracy)<>0)*1","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Model Parameters","index":4,"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 - Using OFFSET for Depreciation.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 - Using OFFSET for Depreciation.xlsm"}]
[null,null,null,null,"Client Name",null,"ICAEW"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]

{"sheet":"Timing","index":5,"n_rows":23,"n_cols":21,"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 - Using OFFSET for Depreciation.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":"2017-12-31"},{"$f":"K$7","v":"2018-12-31"},{"$f":"L$7","v":"2019-12-31"},{"$f":"M$7","v":"2020-12-31"},{"$f":"N$7","v":"2021-12-31"},{"$f":"O$7","v":"2022-12-31"},"2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2017-01-01"},"2018-01-01","2019-01-01","2020-01-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-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":"2017-12-31"},"2018-12-31","2019-12-31","2020-12-31","2021-12-31","2022-12-31","2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":365},{"$f":"K7-K6+1","v":365},365,366,365,{"$f":"O7-O6+1","v":365},365,366,365,365,365,366]
[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}]
[]
[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":"2017-01-01"}]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,12]
[]
[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-17"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":12}]
[]
[null,null,null,"Months per Year",null,null,null,12]

{"sheet":"Error Checks","index":6,"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 - Using OFFSET for Depreciation.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,"Depreciation Reconciles",null,null,null,{"$f":"HL_Depn_Check","v":0}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]