{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Calculating on a FIFO Basis","Timing","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":31,"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 Calculating Inventory on a FIFO Basis.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple example to demonstrate how calculating inventory"]
[null,null,"on a FIFO (First In, First Out) basis might work."]
[]
[]
[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 Calculating Inventory on a FIFO Basis.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,"Calculating on a FIFO Basis"]
[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 Calculating Inventory on a FIFO Basis.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":"Movement in Shares is not net negative"},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":"2020-09-06"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2020-09-06"},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 Calculating Inventory on a FIFO Basis.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 Calculating Inventory on a FIFO Basis.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":"Calculating on a FIFO Basis","index":4,"n_rows":66,"n_cols":33,"rows_kept":66,"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":"Calculating on a FIFO Basis"}]
[{"$f":"Model_Name","v":"SP Calculating Inventory on a FIFO Basis.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":"2020-09-30"},{"$f":"Timing!K5","v":"2020-12-31"},{"$f":"Timing!L5","v":"2021-03-31"},{"$f":"Timing!M5","v":"2021-06-30"},{"$f":"Timing!N5","v":"2021-09-30"},{"$f":"Timing!O5","v":"2021-12-31"},{"$f":"Timing!P5","v":"2022-03-31"},{"$f":"Timing!Q5","v":"2022-06-30"},{"$f":"Timing!R5","v":"2022-09-30"},{"$f":"Timing!S5","v":"2022-12-31"},{"$f":"Timing!T5","v":"2023-03-31"},{"$f":"Timing!U5","v":"2023-06-30"},{"$f":"Timing!V5","v":"2023-09-30"},{"$f":"Timing!W5","v":"2023-12-31"},{"$f":"Timing!X5","v":"2024-03-31"},{"$f":"Timing!Y5","v":"2024-06-30"},{"$f":"Timing!Z5","v":"2024-09-30"},{"$f":"Timing!AA5","v":"2024-12-31"},{"$f":"Timing!AB5","v":"2025-03-31"},{"$f":"Timing!AC5","v":"2025-06-30"},{"$f":"Timing!AD5","v":"2025-09-30"},{"$f":"Timing!AE5","v":"2025-12-31"},{"$f":"Timing!AF5","v":"2026-03-31"},{"$f":"Timing!AG5","v":"2026-06-30"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2020-09-06"},{"$f":"Timing!K6","v":"2020-10-01"},{"$f":"Timing!L6","v":"2021-01-01"},{"$f":"Timing!M6","v":"2021-04-01"},{"$f":"Timing!N6","v":"2021-07-01"},{"$f":"Timing!O6","v":"2021-10-01"},{"$f":"Timing!P6","v":"2022-01-01"},{"$f":"Timing!Q6","v":"2022-04-01"},{"$f":"Timing!R6","v":"2022-07-01"},{"$f":"Timing!S6","v":"2022-10-01"},{"$f":"Timing!T6","v":"2023-01-01"},{"$f":"Timing!U6","v":"2023-04-01"},{"$f":"Timing!V6","v":"2023-07-01"},{"$f":"Timing!W6","v":"2023-10-01"},{"$f":"Timing!X6","v":"2024-01-01"},{"$f":"Timing!Y6","v":"2024-04-01"},{"$f":"Timing!Z6","v":"2024-07-01"},{"$f":"Timing!AA6","v":"2024-10-01"},{"$f":"Timing!AB6","v":"2025-01-01"},{"$f":"Timing!AC6","v":"2025-04-01"},{"$f":"Timing!AD6","v":"2025-07-01"},{"$f":"Timing!AE6","v":"2025-10-01"},{"$f":"Timing!AF6","v":"2026-01-01"},{"$f":"Timing!AG6","v":"2026-04-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2020-09-30"},{"$f":"Timing!K7","v":"2020-12-31"},{"$f":"Timing!L7","v":"2021-03-31"},{"$f":"Timing!M7","v":"2021-06-30"},{"$f":"Timing!N7","v":"2021-09-30"},{"$f":"Timing!O7","v":"2021-12-31"},{"$f":"Timing!P7","v":"2022-03-31"},{"$f":"Timing!Q7","v":"2022-06-30"},{"$f":"Timing!R7","v":"2022-09-30"},{"$f":"Timing!S7","v":"2022-12-31"},{"$f":"Timing!T7","v":"2023-03-31"},{"$f":"Timing!U7","v":"2023-06-30"},{"$f":"Timing!V7","v":"2023-09-30"},{"$f":"Timing!W7","v":"2023-12-31"},{"$f":"Timing!X7","v":"2024-03-31"},{"$f":"Timing!Y7","v":"2024-06-30"},{"$f":"Timing!Z7","v":"2024-09-30"},{"$f":"Timing!AA7","v":"2024-12-31"},{"$f":"Timing!AB7","v":"2025-03-31"},{"$f":"Timing!AC7","v":"2025-06-30"},{"$f":"Timing!AD7","v":"2025-09-30"},{"$f":"Timing!AE7","v":"2025-12-31"},{"$f":"Timing!AF7","v":"2026-03-31"},{"$f":"Timing!AG7","v":"2026-06-30"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":25},{"$f":"Timing!K8","v":92},{"$f":"Timing!L8","v":90},{"$f":"Timing!M8","v":91},{"$f":"Timing!N8","v":92},{"$f":"Timing!O8","v":92},{"$f":"Timing!P8","v":90},{"$f":"Timing!Q8","v":91},{"$f":"Timing!R8","v":92},{"$f":"Timing!S8","v":92},{"$f":"Timing!T8","v":90},{"$f":"Timing!U8","v":91},{"$f":"Timing!V8","v":92},{"$f":"Timing!W8","v":92},{"$f":"Timing!X8","v":91},{"$f":"Timing!Y8","v":91},{"$f":"Timing!Z8","v":92},{"$f":"Timing!AA8","v":92},{"$f":"Timing!AB8","v":90},{"$f":"Timing!AC8","v":91},{"$f":"Timing!AD8","v":92},{"$f":"Timing!AE8","v":92},{"$f":"Timing!AF8","v":90},{"$f":"Timing!AG8","v":91}]
[null,null,{"$f":"Timing!C9","v":"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},{"$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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Acquisition and Disposal of Shares"]
[]
[null,null,"Assumptions"]
[]
[null,null,null,"Share Price"]
[]
[null,null,null,null,"Opening Price",null,null,"$",100]
[null,null,null,null,"Periodic Growth Rate",null,null,"%",0.02]
[]
[null,null,null,null,"Opening Price",null,null,"$",null,{"$f":"IF(J$9=1,$I$17,I$21)","v":100},{"$f":"IF(K$9=1,$I$17,J$21)","v":102},104.04,106.1208,108.243216,110.40808032000001,112.61624192640001,114.868566764928,117.16593810022657,119.5092568622311,121.89944199947573,124.33743083946524,126.82417945625456,129.36066304537965,131.94787630628724,134.58683383241299,137.27857050906127,140.02414191924251,142.82462475762736,145.6811172527799,148.59473959783551,151.56663438979223,154.59796707758807,157.68992641913982]
[null,null,null,null,"Closing Price",null,null,"$",null,{"$f":"J20*(1+$I$18)","v":102},104.04,106.1208,108.243216,110.40808032000001,112.61624192640001,114.868566764928,117.16593810022657,119.5092568622311,121.89944199947573,124.33743083946524,126.82417945625456,129.36066304537965,131.94787630628724,134.58683383241299,137.27857050906127,140.02414191924251,142.82462475762736,145.6811172527799,148.59473959783551,151.56663438979223,154.59796707758807,157.68992641913982,160.84372494752262]
[]
[null,null,null,"Movements"]
[]
[null,null,null,null,"Acquisitions",null,null,"#",null,3,null,2,null,2,null,1,1]
[null,null,null,null,"Disposals",null,null,"#",null,null,1,null,3,null,2,null,null,3]
[]
[null,null,null,null,{"$f":"\"Cum. \"&E25","v":"Cum. Acquisitions"},null,null,"#",null,{"$f":"SUM($J25:J25)","v":3},{"$f":"SUM($J25:K25)","v":3},{"$f":"SUM($J25:L25)","v":5},{"$f":"SUM($J25:M25)","v":5},{"$f":"SUM($J25:N25)","v":7},{"$f":"SUM($J25:O25)","v":7},{"$f":"SUM($J25:P25)","v":8},{"$f":"SUM($J25:Q25)","v":9},{"$f":"SUM($J25:R25)","v":9},{"$f":"SUM($J25:S25)","v":9},{"$f":"SUM($J25:T25)","v":9},{"$f":"SUM($J25:U25)","v":9},{"$f":"SUM($J25:V25)","v":9},{"$f":"SUM($J25:W25)","v":9},{"$f":"SUM($J25:X25)","v":9},{"$f":"SUM($J25:Y25)","v":9},{"$f":"SUM($J25:Z25)","v":9},{"$f":"SUM($J25:AA25)","v":9},{"$f":"SUM($J25:AB25)","v":9},{"$f":"SUM($J25:AC25)","v":9},{"$f":"SUM($J25:AD25)","v":9},{"$f":"SUM($J25:AE25)","v":9},{"$f":"SUM($J25:AF25)","v":9},{"$f":"SUM($J25:AG25)","v":9}]
[null,null,null,null,{"$f":"\"Cum. \"&E26","v":"Cum. Disposals"},null,null,"#",null,{"$f":"SUM($J26:J26)","v":0},{"$f":"SUM($J26:K26)","v":1},{"$f":"SUM($J26:L26)","v":1},{"$f":"SUM($J26:M26)","v":4},{"$f":"SUM($J26:N26)","v":4},{"$f":"SUM($J26:O26)","v":6},{"$f":"SUM($J26:P26)","v":6},{"$f":"SUM($J26:Q26)","v":6},{"$f":"SUM($J26:R26)","v":9},{"$f":"SUM($J26:S26)","v":9},{"$f":"SUM($J26:T26)","v":9},{"$f":"SUM($J26:U26)","v":9},{"$f":"SUM($J26:V26)","v":9},{"$f":"SUM($J26:W26)","v":9},{"$f":"SUM($J26:X26)","v":9},{"$f":"SUM($J26:Y26)","v":9},{"$f":"SUM($J26:Z26)","v":9},{"$f":"SUM($J26:AA26)","v":9},{"$f":"SUM($J26:AB26)","v":9},{"$f":"SUM($J26:AC26)","v":9},{"$f":"SUM($J26:AD26)","v":9},{"$f":"SUM($J26:AE26)","v":9},{"$f":"SUM($J26:AF26)","v":9},{"$f":"SUM($J26:AG26)","v":9}]
[null,null,null,null,"Net",null,null,"#",null,{"$f":"J28-J29","v":3},{"$f":"K28-K29","v":2},4,1,3,1,2,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Checks:",null,null,"[1,0]",{"$f":"MAX(J32:AG32)","v":0},{"$f":"(J30<0)*1","v":0},{"$f":"(K30<0)*1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Summary"]
[]
[null,null,null,"Shares Acquired"]
[]
[null,null,null,null,"Opening Balance",null,null,"$",null,{"$f":"I43","v":0},{"$f":"J43","v":306},208.07999999999998,424.48320000000001,108.24321600000002,331.22424096000003,112.61624192640002,229.73713352985601,351.49781430067969,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E25","v":"Acquisitions"},null,null,"$",null,{"$f":"J25*J20","v":300},{"$f":"K25*K20","v":0},208.08,0,216.48643200000001,0,112.61624192640001,114.868566764928,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Gain / (Loss)",null,null,"$",null,{"$f":"SUM(J26,J30)*J$21-SUM(J$39:J$40)","v":6},{"$f":"SUM(K26,K30)*K$21-SUM(K$39:K$40)","v":6.1200000000000045},8.3232000000000426,8.4896640000000048,6.4945929600000341,6.6244848192000063,4.5046496770559656,6.892114005895678,7.0299562860136007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E26","v":"Disposals"},null,null,"$",null,{"$f":"-J26*J21","v":0},-104.04,0,-324.729648,0,-225.23248385280002,0,0,-358.52777058669329,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Closing Balance",null,null,"$",null,{"$f":"SUM(J39:J42)","v":306},208.07999999999998,424.48320000000001,108.24321600000002,331.22424096000003,112.61624192640002,229.73713352985601,351.49781430067969,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,{"$f":"MAX($B$10:$B45)+1","v":2},"Cost Base"]
[]
[null,null,"Calculations"]
[]
[null,null,null,{"$f":"C46","v":"Cost Base"}]
[]
[null,null,null,null,"Payback Period",null,null,"#",null,{"$f":"IF(J26,_xlfn.IFNA(IF(J$9=1,(J$28>=J$29)*1,MATCH(TRUE,$J28:J28>=J$29,0)),),)","v":0},{"$f":"IF(K26,_xlfn.IFNA(IF(K$9=1,(K$28>=K$29)*1,MATCH(TRUE,$J28:K28>=K$29,0)),),)","v":1},{"$f":"IF(L26,_xlfn.IFNA(IF(L$9=1,(L$28>=L$29)*1,MATCH(TRUE,$J28:L28>=L$29,0)),),)","v":0},{"$f":"IF(M26,_xlfn.IFNA(IF(M$9=1,(M$28>=M$29)*1,MATCH(TRUE,$J28:M28>=M$29,0)),),)","v":3},{"$f":"IF(N26,_xlfn.IFNA(IF(N$9=1,(N$28>=N$29)*1,MATCH(TRUE,$J28:N28>=N$29,0)),),)","v":0},{"$f":"IF(O26,_xlfn.IFNA(IF(O$9=1,(O$28>=O$29)*1,MATCH(TRUE,$J28:O28>=O$29,0)),),)","v":5},{"$f":"IF(P26,_xlfn.IFNA(IF(P$9=1,(P$28>=P$29)*1,MATCH(TRUE,$J28:P28>=P$29,0)),),)","v":0},{"$f":"IF(Q26,_xlfn.IFNA(IF(Q$9=1,(Q$28>=Q$29)*1,MATCH(TRUE,$J28:Q28>=Q$29,0)),),)","v":0},{"$f":"IF(R26,_xlfn.IFNA(IF(R$9=1,(R$28>=R$29)*1,MATCH(TRUE,$J28:R28>=R$29,0)),),)","v":8},{"$f":"IF(S26,_xlfn.IFNA(IF(S$9=1,(S$28>=S$29)*1,MATCH(TRUE,$J28:S28>=S$29,0)),),)","v":0},{"$f":"IF(T26,_xlfn.IFNA(IF(T$9=1,(T$28>=T$29)*1,MATCH(TRUE,$J28:T28>=T$29,0)),),)","v":0},{"$f":"IF(U26,_xlfn.IFNA(IF(U$9=1,(U$28>=U$29)*1,MATCH(TRUE,$J28:U28>=U$29,0)),),)","v":0},{"$f":"IF(V26,_xlfn.IFNA(IF(V$9=1,(V$28>=V$29)*1,MATCH(TRUE,$J28:V28>=V$29,0)),),)","v":0},{"$f":"IF(W26,_xlfn.IFNA(IF(W$9=1,(W$28>=W$29)*1,MATCH(TRUE,$J28:W28>=W$29,0)),),)","v":0},{"$f":"IF(X26,_xlfn.IFNA(IF(X$9=1,(X$28>=X$29)*1,MATCH(TRUE,$J28:X28>=X$29,0)),),)","v":0},{"$f":"IF(Y26,_xlfn.IFNA(IF(Y$9=1,(Y$28>=Y$29)*1,MATCH(TRUE,$J28:Y28>=Y$29,0)),),)","v":0},{"$f":"IF(Z26,_xlfn.IFNA(IF(Z$9=1,(Z$28>=Z$29)*1,MATCH(TRUE,$J28:Z28>=Z$29,0)),),)","v":0},{"$f":"IF(AA26,_xlfn.IFNA(IF(AA$9=1,(AA$28>=AA$29)*1,MATCH(TRUE,$J28:AA28>=AA$29,0)),),)","v":0},{"$f":"IF(AB26,_xlfn.IFNA(IF(AB$9=1,(AB$28>=AB$29)*1,MATCH(TRUE,$J28:AB28>=AB$29,0)),),)","v":0},{"$f":"IF(AC26,_xlfn.IFNA(IF(AC$9=1,(AC$28>=AC$29)*1,MATCH(TRUE,$J28:AC28>=AC$29,0)),),)","v":0},{"$f":"IF(AD26,_xlfn.IFNA(IF(AD$9=1,(AD$28>=AD$29)*1,MATCH(TRUE,$J28:AD28>=AD$29,0)),),)","v":0},{"$f":"IF(AE26,_xlfn.IFNA(IF(AE$9=1,(AE$28>=AE$29)*1,MATCH(TRUE,$J28:AE28>=AE$29,0)),),)","v":0},{"$f":"IF(AF26,_xlfn.IFNA(IF(AF$9=1,(AF$28>=AF$29)*1,MATCH(TRUE,$J28:AF28>=AF$29,0)),),)","v":0},{"$f":"IF(AG26,_xlfn.IFNA(IF(AG$9=1,(AG$28>=AG$29)*1,MATCH(TRUE,$J28:AG28>=AG$29,0)),),)","v":0}]
[null,null,null,null,"Proportion of Final Period",null,null,"%",null,{"$f":"IF(J$26*J$52,MOD((J$29-OFFSET($I$28,,J$52))/OFFSET($I$25,,J$52),1),)","v":0},{"$f":"IF(K$26*K$52,MOD((K$29-OFFSET($I$28,,K$52))/OFFSET($I$25,,K$52),1),)","v":0.33333333333333337},0,0.5,0,0.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Cost Base (Long)",null,null,"$",null,{"$f":"IF(J$26*J$52,SUM(OFFSET($J$40,,,,J$52))-SUM(OFFSET($I$40,,,,J$52))-OFFSET($I$40,,J$52)*(1-J$53)+SUM(OFFSET($I$40,,,,J$52+(J$53=0)*1))-SUM($I$54:I$54),)","v":0},{"$f":"IF(K$26*K$52,SUM(OFFSET($J$40,,,,K$52))-SUM(OFFSET($I$40,,,,K$52))-OFFSET($I$40,,K$52)*(1-K$53)+SUM(OFFSET($I$40,,,,K$52+(K$53=0)*1))-SUM($I$54:J$54),)","v":100},{"$f":"IF(L$26*L$52,SUM(OFFSET($J$40,,,,L$52))-SUM(OFFSET($I$40,,,,L$52))-OFFSET($I$40,,L$52)*(1-L$53)+SUM(OFFSET($I$40,,,,L$52+(L$53=0)*1))-SUM($I$54:K$54),)","v":0},{"$f":"IF(M$26*M$52,SUM(OFFSET($J$40,,,,M$52))-SUM(OFFSET($I$40,,,,M$52))-OFFSET($I$40,,M$52)*(1-M$53)+SUM(OFFSET($I$40,,,,M$52+(M$53=0)*1))-SUM($I$54:L$54),)","v":304.04000000000002},{"$f":"IF(N$26*N$52,SUM(OFFSET($J$40,,,,N$52))-SUM(OFFSET($I$40,,,,N$52))-OFFSET($I$40,,N$52)*(1-N$53)+SUM(OFFSET($I$40,,,,N$52+(N$53=0)*1))-SUM($I$54:M$54),)","v":0},{"$f":"IF(O$26*O$52,SUM(OFFSET($J$40,,,,O$52))-SUM(OFFSET($I$40,,,,O$52))-OFFSET($I$40,,O$52)*(1-O$53)+SUM(OFFSET($I$40,,,,O$52+(O$53=0)*1))-SUM($I$54:N$54),)","v":212.2832160000001},{"$f":"IF(P$26*P$52,SUM(OFFSET($J$40,,,,P$52))-SUM(OFFSET($I$40,,,,P$52))-OFFSET($I$40,,P$52)*(1-P$53)+SUM(OFFSET($I$40,,,,P$52+(P$53=0)*1))-SUM($I$54:O$54),)","v":0},{"$f":"IF(Q$26*Q$52,SUM(OFFSET($J$40,,,,Q$52))-SUM(OFFSET($I$40,,,,Q$52))-OFFSET($I$40,,Q$52)*(1-Q$53)+SUM(OFFSET($I$40,,,,Q$52+(Q$53=0)*1))-SUM($I$54:P$54),)","v":0},{"$f":"IF(R$26*R$52,SUM(OFFSET($J$40,,,,R$52))-SUM(OFFSET($I$40,,,,R$52))-OFFSET($I$40,,R$52)*(1-R$53)+SUM(OFFSET($I$40,,,,R$52+(R$53=0)*1))-SUM($I$54:Q$54),)","v":335.72802469132796},{"$f":"IF(S$26*S$52,SUM(OFFSET($J$40,,,,S$52))-SUM(OFFSET($I$40,,,,S$52))-OFFSET($I$40,,S$52)*(1-S$53)+SUM(OFFSET($I$40,,,,S$52+(S$53=0)*1))-SUM($I$54:R$54),)","v":0},{"$f":"IF(T$26*T$52,SUM(OFFSET($J$40,,,,T$52))-SUM(OFFSET($I$40,,,,T$52))-OFFSET($I$40,,T$52)*(1-T$53)+SUM(OFFSET($I$40,,,,T$52+(T$53=0)*1))-SUM($I$54:S$54),)","v":0},{"$f":"IF(U$26*U$52,SUM(OFFSET($J$40,,,,U$52))-SUM(OFFSET($I$40,,,,U$52))-OFFSET($I$40,,U$52)*(1-U$53)+SUM(OFFSET($I$40,,,,U$52+(U$53=0)*1))-SUM($I$54:T$54),)","v":0},{"$f":"IF(V$26*V$52,SUM(OFFSET($J$40,,,,V$52))-SUM(OFFSET($I$40,,,,V$52))-OFFSET($I$40,,V$52)*(1-V$53)+SUM(OFFSET($I$40,,,,V$52+(V$53=0)*1))-SUM($I$54:U$54),)","v":0},{"$f":"IF(W$26*W$52,SUM(OFFSET($J$40,,,,W$52))-SUM(OFFSET($I$40,,,,W$52))-OFFSET($I$40,,W$52)*(1-W$53)+SUM(OFFSET($I$40,,,,W$52+(W$53=0)*1))-SUM($I$54:V$54),)","v":0},{"$f":"IF(X$26*X$52,SUM(OFFSET($J$40,,,,X$52))-SUM(OFFSET($I$40,,,,X$52))-OFFSET($I$40,,X$52)*(1-X$53)+SUM(OFFSET($I$40,,,,X$52+(X$53=0)*1))-SUM($I$54:W$54),)","v":0},{"$f":"IF(Y$26*Y$52,SUM(OFFSET($J$40,,,,Y$52))-SUM(OFFSET($I$40,,,,Y$52))-OFFSET($I$40,,Y$52)*(1-Y$53)+SUM(OFFSET($I$40,,,,Y$52+(Y$53=0)*1))-SUM($I$54:X$54),)","v":0},{"$f":"IF(Z$26*Z$52,SUM(OFFSET($J$40,,,,Z$52))-SUM(OFFSET($I$40,,,,Z$52))-OFFSET($I$40,,Z$52)*(1-Z$53)+SUM(OFFSET($I$40,,,,Z$52+(Z$53=0)*1))-SUM($I$54:Y$54),)","v":0},{"$f":"IF(AA$26*AA$52,SUM(OFFSET($J$40,,,,AA$52))-SUM(OFFSET($I$40,,,,AA$52))-OFFSET($I$40,,AA$52)*(1-AA$53)+SUM(OFFSET($I$40,,,,AA$52+(AA$53=0)*1))-SUM($I$54:Z$54),)","v":0},{"$f":"IF(AB$26*AB$52,SUM(OFFSET($J$40,,,,AB$52))-SUM(OFFSET($I$40,,,,AB$52))-OFFSET($I$40,,AB$52)*(1-AB$53)+SUM(OFFSET($I$40,,,,AB$52+(AB$53=0)*1))-SUM($I$54:AA$54),)","v":0},{"$f":"IF(AC$26*AC$52,SUM(OFFSET($J$40,,,,AC$52))-SUM(OFFSET($I$40,,,,AC$52))-OFFSET($I$40,,AC$52)*(1-AC$53)+SUM(OFFSET($I$40,,,,AC$52+(AC$53=0)*1))-SUM($I$54:AB$54),)","v":0},{"$f":"IF(AD$26*AD$52,SUM(OFFSET($J$40,,,,AD$52))-SUM(OFFSET($I$40,,,,AD$52))-OFFSET($I$40,,AD$52)*(1-AD$53)+SUM(OFFSET($I$40,,,,AD$52+(AD$53=0)*1))-SUM($I$54:AC$54),)","v":0},{"$f":"IF(AE$26*AE$52,SUM(OFFSET($J$40,,,,AE$52))-SUM(OFFSET($I$40,,,,AE$52))-OFFSET($I$40,,AE$52)*(1-AE$53)+SUM(OFFSET($I$40,,,,AE$52+(AE$53=0)*1))-SUM($I$54:AD$54),)","v":0},{"$f":"IF(AF$26*AF$52,SUM(OFFSET($J$40,,,,AF$52))-SUM(OFFSET($I$40,,,,AF$52))-OFFSET($I$40,,AF$52)*(1-AF$53)+SUM(OFFSET($I$40,,,,AF$52+(AF$53=0)*1))-SUM($I$54:AE$54),)","v":0},{"$f":"IF(AG$26*AG$52,SUM(OFFSET($J$40,,,,AG$52))-SUM(OFFSET($I$40,,,,AG$52))-OFFSET($I$40,,AG$52)*(1-AG$53)+SUM(OFFSET($I$40,,,,AG$52+(AG$53=0)*1))-SUM($I$54:AF$54),)","v":0}]
[null,null,null,null,"Cost Base (Short)",null,null,"$",null,{"$f":"IF(J$26*J$52,OFFSET($I$40,,J$52)*J$53+SUM(OFFSET($I$40,,,,J$52+(J$53=0)*1))-SUM($I$55:I$55),)","v":0},{"$f":"IF(K$26*K$52,OFFSET($I$40,,K$52)*K$53+SUM(OFFSET($I$40,,,,K$52+(K$53=0)*1))-SUM($I$55:J$55),)","v":100.00000000000001},{"$f":"IF(L$26*L$52,OFFSET($I$40,,L$52)*L$53+SUM(OFFSET($I$40,,,,L$52+(L$53=0)*1))-SUM($I$55:K$55),)","v":0},{"$f":"IF(M$26*M$52,OFFSET($I$40,,M$52)*M$53+SUM(OFFSET($I$40,,,,M$52+(M$53=0)*1))-SUM($I$55:L$55),)","v":304.04000000000002},{"$f":"IF(N$26*N$52,OFFSET($I$40,,N$52)*N$53+SUM(OFFSET($I$40,,,,N$52+(N$53=0)*1))-SUM($I$55:M$55),)","v":0},{"$f":"IF(O$26*O$52,OFFSET($I$40,,O$52)*O$53+SUM(OFFSET($I$40,,,,O$52+(O$53=0)*1))-SUM($I$55:N$55),)","v":212.28321599999998},{"$f":"IF(P$26*P$52,OFFSET($I$40,,P$52)*P$53+SUM(OFFSET($I$40,,,,P$52+(P$53=0)*1))-SUM($I$55:O$55),)","v":0},{"$f":"IF(Q$26*Q$52,OFFSET($I$40,,Q$52)*Q$53+SUM(OFFSET($I$40,,,,Q$52+(Q$53=0)*1))-SUM($I$55:P$55),)","v":0},{"$f":"IF(R$26*R$52,OFFSET($I$40,,R$52)*R$53+SUM(OFFSET($I$40,,,,R$52+(R$53=0)*1))-SUM($I$55:Q$55),)","v":335.72802469132807},{"$f":"IF(S$26*S$52,OFFSET($I$40,,S$52)*S$53+SUM(OFFSET($I$40,,,,S$52+(S$53=0)*1))-SUM($I$55:R$55),)","v":0},{"$f":"IF(T$26*T$52,OFFSET($I$40,,T$52)*T$53+SUM(OFFSET($I$40,,,,T$52+(T$53=0)*1))-SUM($I$55:S$55),)","v":0},{"$f":"IF(U$26*U$52,OFFSET($I$40,,U$52)*U$53+SUM(OFFSET($I$40,,,,U$52+(U$53=0)*1))-SUM($I$55:T$55),)","v":0},{"$f":"IF(V$26*V$52,OFFSET($I$40,,V$52)*V$53+SUM(OFFSET($I$40,,,,V$52+(V$53=0)*1))-SUM($I$55:U$55),)","v":0},{"$f":"IF(W$26*W$52,OFFSET($I$40,,W$52)*W$53+SUM(OFFSET($I$40,,,,W$52+(W$53=0)*1))-SUM($I$55:V$55),)","v":0},{"$f":"IF(X$26*X$52,OFFSET($I$40,,X$52)*X$53+SUM(OFFSET($I$40,,,,X$52+(X$53=0)*1))-SUM($I$55:W$55),)","v":0},{"$f":"IF(Y$26*Y$52,OFFSET($I$40,,Y$52)*Y$53+SUM(OFFSET($I$40,,,,Y$52+(Y$53=0)*1))-SUM($I$55:X$55),)","v":0},{"$f":"IF(Z$26*Z$52,OFFSET($I$40,,Z$52)*Z$53+SUM(OFFSET($I$40,,,,Z$52+(Z$53=0)*1))-SUM($I$55:Y$55),)","v":0},{"$f":"IF(AA$26*AA$52,OFFSET($I$40,,AA$52)*AA$53+SUM(OFFSET($I$40,,,,AA$52+(AA$53=0)*1))-SUM($I$55:Z$55),)","v":0},{"$f":"IF(AB$26*AB$52,OFFSET($I$40,,AB$52)*AB$53+SUM(OFFSET($I$40,,,,AB$52+(AB$53=0)*1))-SUM($I$55:AA$55),)","v":0},{"$f":"IF(AC$26*AC$52,OFFSET($I$40,,AC$52)*AC$53+SUM(OFFSET($I$40,,,,AC$52+(AC$53=0)*1))-SUM($I$55:AB$55),)","v":0},{"$f":"IF(AD$26*AD$52,OFFSET($I$40,,AD$52)*AD$53+SUM(OFFSET($I$40,,,,AD$52+(AD$53=0)*1))-SUM($I$55:AC$55),)","v":0},{"$f":"IF(AE$26*AE$52,OFFSET($I$40,,AE$52)*AE$53+SUM(OFFSET($I$40,,,,AE$52+(AE$53=0)*1))-SUM($I$55:AD$55),)","v":0},{"$f":"IF(AF$26*AF$52,OFFSET($I$40,,AF$52)*AF$53+SUM(OFFSET($I$40,,,,AF$52+(AF$53=0)*1))-SUM($I$55:AE$55),)","v":0},{"$f":"IF(AG$26*AG$52,OFFSET($I$40,,AG$52)*AG$53+SUM(OFFSET($I$40,,,,AG$52+(AG$53=0)*1))-SUM($I$55:AF$55),)","v":0}]
[]
[]
[null,{"$f":"MAX($B$10:$B57)+1","v":3},"Profit or Loss"]
[]
[null,null,"Summary"]
[]
[null,null,null,"Profit / (Loss) on Sale of Shares"]
[]
[null,null,null,null,"Disposal Proceeds",null,null,"$",null,{"$f":"-J42","v":0},{"$f":"-K42","v":104.04},0,324.729648,0,225.23248385280002,0,0,358.52777058669329,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Cost Base",null,null,"$",null,{"$f":"-J55","v":0},{"$f":"-K55","v":-100.00000000000001},0,-304.04000000000002,0,-212.28321599999998,0,0,-335.72802469132807,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Profit / (Loss)",null,null,"$",null,{"$f":"SUM(J64:J65)","v":0},{"$f":"SUM(K64:K65)","v":4.039999999999992},0,20.689647999999977,0,12.949267852800034,0,0,22.79974589536522,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Timing","index":5,"n_rows":21,"n_cols":33,"rows_kept":21,"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 Calculating Inventory on a FIFO Basis.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":"2020-09-30"},{"$f":"K$7","v":"2020-12-31"},{"$f":"L$7","v":"2021-03-31"},{"$f":"M$7","v":"2021-06-30"},{"$f":"N$7","v":"2021-09-30"},{"$f":"O$7","v":"2021-12-31"},"2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30",{"$f":"AA$7","v":"2024-12-31"},"2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30"]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2020-09-06"},"2020-10-01","2021-01-01","2021-04-01","2021-07-01","2021-10-01","2022-01-01","2022-04-01","2022-07-01","2022-10-01","2023-01-01","2023-04-01","2023-07-01","2023-10-01","2024-01-01","2024-04-01","2024-07-01","2024-10-01","2025-01-01","2025-04-01","2025-07-01","2025-10-01","2026-01-01","2026-04-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":"2020-09-30"},"2020-12-31","2021-03-31","2021-06-30","2021-09-30","2021-12-31","2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30","2024-12-31","2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30"]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":25},{"$f":"K7-K6+1","v":92},90,91,92,{"$f":"O7-O6+1","v":92},90,91,92,92,90,91,92,92,91,91,92,92,{"$f":"AB7-AB6+1","v":90},91,{"$f":"AD7-AD6+1","v":92},92,90,91]
[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}]
[]
[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":"TODAY()","v":"2020-09-06"}]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,3]
[]
[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-20"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":3}]

{"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 Calculating Inventory on a FIFO Basis.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,"Movement in Shares is not net negative",null,null,null,{"$f":"HL_Movements","v":0}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]