{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Timing","Revenues","COGS","Capex","Export Sheet","Export Sheet (2)","Error Checks","Template","Change Log"],"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":"SumProduct Pty Limited"}]
[null,null,{"$f":"Model_Name","v":"SP Example Export Model.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple template to agree layouts, formats and styles."]
[]
[]
[]
[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 Example Export Model.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,"Error Checks"]
[null,null,null,null,null,"Change Log"]

{"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 Example Export Model.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":"Example"},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-02-25"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2018-02-25"},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 Example Export Model.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 Example Export Model.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":14,"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 Example Export Model.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":"2018-03-31"},{"$f":"K$7","v":"2018-06-30"},{"$f":"L$7","v":"2018-09-30"},{"$f":"M$7","v":"2018-12-31"},{"$f":"N$7","v":"2019-03-31"}]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2018-02-25"},{"$f":"IF(K$9=1,Model_Start_Date,J$7+1)","v":"2018-04-01"},{"$f":"IF(L$9=1,Model_Start_Date,K$7+1)","v":"2018-07-01"},{"$f":"IF(M$9=1,Model_Start_Date,L$7+1)","v":"2018-10-01"},{"$f":"IF(N$9=1,Model_Start_Date,M$7+1)","v":"2019-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":"2018-03-31"},{"$f":"EOMONTH(K$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(K$6),Periodicity))","v":"2018-06-30"},{"$f":"EOMONTH(L$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(L$6),Periodicity))","v":"2018-09-30"},{"$f":"EOMONTH(M$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(M$6),Periodicity))","v":"2018-12-31"},{"$f":"EOMONTH(N$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(N$6),Periodicity))","v":"2019-03-31"}]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":35},{"$f":"K7-K6+1","v":91},92,92,90]
[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]
[]
[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":"2018-02-25"}]
[]
[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-18"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":3}]
[]
[null,null,null,"Months per Year",null,null,null,12]

{"sheet":"Revenues","index":5,"n_rows":28,"n_cols":14,"rows_kept":28,"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":"Revenues"}]
[{"$f":"Model_Name","v":"SP Example Export Model.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":"2018-03-31"},{"$f":"Timing!K5","v":"2018-06-30"},{"$f":"Timing!L5","v":"2018-09-30"},{"$f":"Timing!M5","v":"2018-12-31"},{"$f":"Timing!N5","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2018-02-25"},{"$f":"Timing!K6","v":"2018-04-01"},{"$f":"Timing!L6","v":"2018-07-01"},{"$f":"Timing!M6","v":"2018-10-01"},{"$f":"Timing!N6","v":"2019-01-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2018-03-31"},{"$f":"Timing!K7","v":"2018-06-30"},{"$f":"Timing!L7","v":"2018-09-30"},{"$f":"Timing!M7","v":"2018-12-31"},{"$f":"Timing!N7","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":35},{"$f":"Timing!K8","v":91},{"$f":"Timing!L8","v":92},{"$f":"Timing!M8","v":92},{"$f":"Timing!N8","v":90}]
[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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Revenues"}]
[]
[null,null,"Heading"]
[]
[null,null,null,"Sub Heading"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Guns","$'000",null,null,183,780,866,355,797]
[null,null,null,null,null,"Drugs","$'000",null,null,685,131,998,203,333]
[null,null,null,null,null,"Roses","$'000",null,null,514,452,368,897,418]
[null,null,null,null,null,null,"$'000",null,null,{"$f":"SUM(J25:J27)","v":1382},{"$f":"SUM(K25:K27)","v":1363},2232,1455,1548]

{"sheet":"COGS","index":6,"n_rows":72,"n_cols":14,"rows_kept":72,"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":"COGS"}]
[{"$f":"Model_Name","v":"SP Example Export Model.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":"2018-03-31"},{"$f":"Timing!K5","v":"2018-06-30"},{"$f":"Timing!L5","v":"2018-09-30"},{"$f":"Timing!M5","v":"2018-12-31"},{"$f":"Timing!N5","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2018-02-25"},{"$f":"Timing!K6","v":"2018-04-01"},{"$f":"Timing!L6","v":"2018-07-01"},{"$f":"Timing!M6","v":"2018-10-01"},{"$f":"Timing!N6","v":"2019-01-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2018-03-31"},{"$f":"Timing!K7","v":"2018-06-30"},{"$f":"Timing!L7","v":"2018-09-30"},{"$f":"Timing!M7","v":"2018-12-31"},{"$f":"Timing!N7","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":35},{"$f":"Timing!K8","v":91},{"$f":"Timing!L8","v":92},{"$f":"Timing!M8","v":92},{"$f":"Timing!N8","v":90}]
[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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"COGS"}]
[]
[null,null,"Heading"]
[]
[null,null,null,"Sub Heading"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Direct Materials","$'000",null,null,54,560,447,434,165]
[null,null,null,null,null,"Direct Labour","$'000",null,null,393,457,484,329,95]
[null,null,null,null,null,"Other","$'000",null,null,180,471,519,430,75]
[null,null,null,null,null,null,"$'000",null,null,{"$f":"SUM(J69:J71)","v":627},{"$f":"SUM(K69:K71)","v":1488},{"$f":"SUM(L69:L71)","v":1450},{"$f":"SUM(M69:M71)","v":1193},{"$f":"SUM(N69:N71)","v":335}]

{"sheet":"Capex","index":7,"n_rows":125,"n_cols":14,"rows_kept":125,"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":"Capex"}]
[{"$f":"Model_Name","v":"SP Example Export Model.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":"2018-03-31"},{"$f":"Timing!K5","v":"2018-06-30"},{"$f":"Timing!L5","v":"2018-09-30"},{"$f":"Timing!M5","v":"2018-12-31"},{"$f":"Timing!N5","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2018-02-25"},{"$f":"Timing!K6","v":"2018-04-01"},{"$f":"Timing!L6","v":"2018-07-01"},{"$f":"Timing!M6","v":"2018-10-01"},{"$f":"Timing!N6","v":"2019-01-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2018-03-31"},{"$f":"Timing!K7","v":"2018-06-30"},{"$f":"Timing!L7","v":"2018-09-30"},{"$f":"Timing!M7","v":"2018-12-31"},{"$f":"Timing!N7","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":35},{"$f":"Timing!K8","v":91},{"$f":"Timing!L8","v":92},{"$f":"Timing!M8","v":92},{"$f":"Timing!N8","v":90}]
[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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Capex"}]
[]
[null,null,"Heading"]
[]
[null,null,null,"Sub Heading"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Office Furniture","$'000",null,null,549,383,596,638,655]
[null,null,null,null,null,"Laptops","$'000",null,null,556,321,434,537,248]
[null,null,null,null,null,"All Terrain Vehicles","$'000",null,null,299,172,537,445,558]
[null,null,null,null,null,"Bullet Proof Shielding","$'000",null,null,551,143,337,189,460]
[null,null,null,null,null,null,"$'000",null,null,{"$f":"SUM(J121:J124)","v":1955},{"$f":"SUM(K122:K124)","v":636},{"$f":"SUM(L122:L124)","v":1308},{"$f":"SUM(M122:M124)","v":1171},{"$f":"SUM(N122:N124)","v":1266}]

{"sheet":"Export Sheet","index":8,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
[{"$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":"Export Sheet"}]
[{"$f":"Model_Name","v":"SP Example Export Model.xlsm"}]
[]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2018-03-31"},{"$f":"Timing!K5","v":"2018-06-30"},{"$f":"Timing!L5","v":"2018-09-30"},{"$f":"Timing!M5","v":"2018-12-31"},{"$f":"Timing!N5","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2018-02-25"},{"$f":"Timing!K6","v":"2018-04-01"},{"$f":"Timing!L6","v":"2018-07-01"},{"$f":"Timing!M6","v":"2018-10-01"},{"$f":"Timing!N6","v":"2019-01-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2018-03-31"},{"$f":"Timing!K7","v":"2018-06-30"},{"$f":"Timing!L7","v":"2018-09-30"},{"$f":"Timing!M7","v":"2018-12-31"},{"$f":"Timing!N7","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":35},{"$f":"Timing!K8","v":91},{"$f":"Timing!L8","v":92},{"$f":"Timing!M8","v":92},{"$f":"Timing!N8","v":90}]
[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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"Revenues!C11","v":"Revenues"}]
[]
[null,null,"Summary Data"]
[]
[null,null,null,"International Sales"]
[]
[null,null,null,null,null,{"$f":"Revenues!F25","v":"Guns"},{"$f":"Revenues!G25","v":"$'000"},null,null,{"$f":"Revenues!J25","v":183},{"$f":"Revenues!K25","v":780},{"$f":"Revenues!L25","v":866},{"$f":"Revenues!M25","v":355},{"$f":"Revenues!N25","v":797}]
[null,null,null,null,null,{"$f":"Revenues!F26","v":"Drugs"},{"$f":"Revenues!G26","v":"$'000"},null,null,{"$f":"Revenues!J26","v":685},{"$f":"Revenues!K26","v":131},{"$f":"Revenues!L26","v":998},{"$f":"Revenues!M26","v":203},{"$f":"Revenues!N26","v":333}]
[null,null,null,null,null,{"$f":"Revenues!F27","v":"Roses"},{"$f":"Revenues!G27","v":"$'000"},null,null,{"$f":"Revenues!J27","v":514},{"$f":"Revenues!K27","v":452},{"$f":"Revenues!L27","v":368},{"$f":"Revenues!M27","v":897},{"$f":"Revenues!N27","v":418}]
[null,null,null,null,null,null,{"$f":"Revenues!G28","v":"$'000"},null,null,{"$f":"SUM(J17:J19)","v":1382},{"$f":"SUM(K17:K19)","v":1363},2232,1455,1548]
[]
[]
[null,{"$f":"MAX($B$10:$B22)+1","v":2},{"$f":"COGS!A1","v":"COGS"}]
[]
[null,null,"Summary Data"]
[]
[null,null,null,"Variable Costs"]
[]
[null,null,null,null,null,{"$f":"COGS!F69","v":"Direct Materials"},{"$f":"COGS!G69","v":"$'000"},null,null,{"$f":"COGS!J69","v":54},{"$f":"COGS!K69","v":560},{"$f":"COGS!L69","v":447},{"$f":"COGS!M69","v":434},{"$f":"COGS!N69","v":165}]
[null,null,null,null,null,{"$f":"COGS!F70","v":"Direct Labour"},{"$f":"COGS!G70","v":"$'000"},null,null,{"$f":"COGS!J70","v":393},{"$f":"COGS!K70","v":457},{"$f":"COGS!L70","v":484},{"$f":"COGS!M70","v":329},{"$f":"COGS!N70","v":95}]
[null,null,null,null,null,{"$f":"COGS!F71","v":"Other"},{"$f":"COGS!G71","v":"$'000"},null,null,{"$f":"COGS!J71","v":180},{"$f":"COGS!K71","v":471},{"$f":"COGS!L71","v":519},{"$f":"COGS!M71","v":430},{"$f":"COGS!N71","v":75}]
[null,null,null,null,null,null,{"$f":"COGS!G72","v":"$'000"},null,null,{"$f":"SUM(J29:J31)","v":627},{"$f":"SUM(K29:K31)","v":1488},{"$f":"SUM(L29:L31)","v":1450},{"$f":"SUM(M29:M31)","v":1193},{"$f":"SUM(N29:N31)","v":335}]
[]
[]
[null,{"$f":"MAX($B$10:$B34)+1","v":3},{"$f":"Capex!A1","v":"Capex"}]
[]
[null,null,"Summary Data"]
[]
[null,null,null,"Capitalised Expenditure"]
[]
[null,null,null,null,null,{"$f":"Capex!F121","v":"Office Furniture"},{"$f":"Capex!G121","v":"$'000"},null,null,{"$f":"Capex!J121","v":549},{"$f":"Capex!K121","v":383},{"$f":"Capex!L121","v":596},{"$f":"Capex!M121","v":638},{"$f":"Capex!N121","v":655}]
[null,null,null,null,null,{"$f":"Capex!F122","v":"Laptops"},{"$f":"Capex!G122","v":"$'000"},null,null,{"$f":"Capex!J122","v":556},{"$f":"Capex!K122","v":321},{"$f":"Capex!L122","v":434},{"$f":"Capex!M122","v":537},{"$f":"Capex!N122","v":248}]
[null,null,null,null,null,{"$f":"Capex!F123","v":"All Terrain Vehicles"},{"$f":"Capex!G123","v":"$'000"},null,null,{"$f":"Capex!J123","v":299},{"$f":"Capex!K123","v":172},{"$f":"Capex!L123","v":537},{"$f":"Capex!M123","v":445},{"$f":"Capex!N123","v":558}]
[null,null,null,null,null,{"$f":"Capex!F124","v":"Bullet Proof Shielding"},{"$f":"Capex!G124","v":"$'000"},null,null,{"$f":"Capex!J124","v":551},{"$f":"Capex!K124","v":143},{"$f":"Capex!L124","v":337},{"$f":"Capex!M124","v":189},{"$f":"Capex!N124","v":460}]
[null,null,null,null,null,null,{"$f":"Capex!G125","v":"$'000"},null,null,{"$f":"SUM(J41:J44)","v":1955},{"$f":"SUM(K41:K44)","v":1019},{"$f":"SUM(L41:L44)","v":1904},{"$f":"SUM(M41:M44)","v":1809},{"$f":"SUM(N41:N44)","v":1921}]

{"sheet":"Export Sheet (2)","index":9,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
[{"$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":"Export Sheet (2)"}]
[{"$f":"Model_Name","v":"SP Example Export Model.xlsm"}]
[]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Timing!J5","v":"2018-03-31"},{"$f":"Timing!K5","v":"2018-06-30"},{"$f":"Timing!L5","v":"2018-09-30"},{"$f":"Timing!M5","v":"2018-12-31"},{"$f":"Timing!N5","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2018-02-25"},{"$f":"Timing!K6","v":"2018-04-01"},{"$f":"Timing!L6","v":"2018-07-01"},{"$f":"Timing!M6","v":"2018-10-01"},{"$f":"Timing!N6","v":"2019-01-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2018-03-31"},{"$f":"Timing!K7","v":"2018-06-30"},{"$f":"Timing!L7","v":"2018-09-30"},{"$f":"Timing!M7","v":"2018-12-31"},{"$f":"Timing!N7","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":35},{"$f":"Timing!K8","v":91},{"$f":"Timing!L8","v":92},{"$f":"Timing!M8","v":92},{"$f":"Timing!N8","v":90}]
[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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"Revenues!C11","v":"Revenues"}]
[]
[null,null,"Summary Data"]
[]
[null,null,null,"International Sales"]
[]
[null,null,null,null,null,{"$f":"Revenues!F25","v":"Guns"},{"$f":"Revenues!G25","v":"$'000"},null,null,{"$f":"Revenues!J25","v":183},{"$f":"Revenues!K25","v":780},{"$f":"Revenues!L25","v":866},{"$f":"Revenues!M25","v":355},{"$f":"Revenues!N25","v":797},null,{"$f":"_xlfn.FORMULATEXT(J17)","v":"=Revenues!J25"}]
[null,null,null,null,null,{"$f":"Revenues!F26","v":"Drugs"},{"$f":"Revenues!G26","v":"$'000"},null,null,{"$f":"Revenues!J26","v":685},{"$f":"Revenues!K26","v":131},{"$f":"Revenues!L26","v":998},{"$f":"Revenues!M26","v":203},{"$f":"Revenues!N26","v":333},null,{"$f":"_xlfn.FORMULATEXT(J18)","v":"=Revenues!J26"}]
[null,null,null,null,null,{"$f":"Revenues!F27","v":"Roses"},{"$f":"Revenues!G27","v":"$'000"},null,null,{"$f":"Revenues!J27","v":514},{"$f":"Revenues!K27","v":452},{"$f":"Revenues!L27","v":368},{"$f":"Revenues!M27","v":897},{"$f":"Revenues!N27","v":418},null,"=Revenues!J27"]
[null,null,null,null,null,null,{"$f":"Revenues!G28","v":"$'000"},null,null,{"$f":"SUM(J17:J19)","v":1382},{"$f":"SUM(K17:K19)","v":1363},2232,1455,1548,null,"=SUM(J17:J19)"]
[]
[]
[null,{"$f":"MAX($B$10:$B22)+1","v":2},{"$f":"COGS!A1","v":"COGS"}]
[]
[null,null,"Summary Data"]
[]
[null,null,null,"Variable Costs"]
[]
[null,null,null,null,null,{"$f":"COGS!F69","v":"Direct Materials"},{"$f":"COGS!G69","v":"$'000"},null,null,{"$f":"COGS!J69","v":54},{"$f":"COGS!K69","v":560},{"$f":"COGS!L69","v":447},{"$f":"COGS!M69","v":434},{"$f":"COGS!N69","v":165},null,{"$f":"_xlfn.FORMULATEXT(J29)","v":"=COGS!J69"}]
[null,null,null,null,null,{"$f":"COGS!F70","v":"Direct Labour"},{"$f":"COGS!G70","v":"$'000"},null,null,{"$f":"COGS!J70","v":393},{"$f":"COGS!K70","v":457},{"$f":"COGS!L70","v":484},{"$f":"COGS!M70","v":329},{"$f":"COGS!N70","v":95},null,{"$f":"_xlfn.FORMULATEXT(J30)","v":"=COGS!J70"}]
[null,null,null,null,null,{"$f":"COGS!F71","v":"Other"},{"$f":"COGS!G71","v":"$'000"},null,null,{"$f":"COGS!J71","v":180},{"$f":"COGS!K71","v":471},{"$f":"COGS!L71","v":519},{"$f":"COGS!M71","v":430},{"$f":"COGS!N71","v":75},null,"=COGS!J71"]
[null,null,null,null,null,null,{"$f":"COGS!G72","v":"$'000"},null,null,{"$f":"SUM(J29:J31)","v":627},{"$f":"SUM(K29:K31)","v":1488},1450,1193,335,null,"=SUM(J29:J31)"]
[]
[]
[null,{"$f":"MAX($B$10:$B34)+1","v":3},{"$f":"Capex!A1","v":"Capex"}]
[]
[null,null,"Summary Data"]
[]
[null,null,null,"Capitalised Expenditure"]
[]
[null,null,null,null,null,{"$f":"Capex!F121","v":"Office Furniture"},{"$f":"Capex!G121","v":"$'000"},null,null,{"$f":"Capex!J121","v":549},{"$f":"Capex!K121","v":383},{"$f":"Capex!L121","v":596},{"$f":"Capex!M121","v":638},{"$f":"Capex!N121","v":655},null,{"$f":"_xlfn.FORMULATEXT(J41)","v":"=Capex!J121"}]
[null,null,null,null,null,{"$f":"Capex!F122","v":"Laptops"},{"$f":"Capex!G122","v":"$'000"},null,null,{"$f":"Capex!J122","v":556},{"$f":"Capex!K122","v":321},{"$f":"Capex!L122","v":434},{"$f":"Capex!M122","v":537},{"$f":"Capex!N122","v":248},null,{"$f":"_xlfn.FORMULATEXT(J42)","v":"=Capex!J122"}]
[null,null,null,null,null,{"$f":"Capex!F123","v":"All Terrain Vehicles"},{"$f":"Capex!G123","v":"$'000"},null,null,{"$f":"Capex!J123","v":299},{"$f":"Capex!K123","v":172},{"$f":"Capex!L123","v":537},{"$f":"Capex!M123","v":445},{"$f":"Capex!N123","v":558},null,{"$f":"_xlfn.FORMULATEXT(J43)","v":"=Capex!J123"}]
[null,null,null,null,null,{"$f":"Capex!F124","v":"Bullet Proof Shielding"},{"$f":"Capex!G124","v":"$'000"},null,null,{"$f":"Capex!J124","v":551},{"$f":"Capex!K124","v":143},{"$f":"Capex!L124","v":337},{"$f":"Capex!M124","v":189},{"$f":"Capex!N124","v":460},null,"=Capex!J124"]
[null,null,null,null,null,null,{"$f":"Capex!G125","v":"$'000"},null,null,{"$f":"SUM(J41:J44)","v":1955},{"$f":"SUM(K41:K44)","v":1019},1904,1809,1921,null,"=SUM(J41:J44)"]

{"sheet":"Error Checks","index":10,"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 Example Export Model.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,"Example"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]

{"sheet":"Template","index":11,"n_rows":15,"n_cols":14,"rows_kept":15,"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":"Template"}]
[{"$f":"Model_Name","v":"SP Example Export Model.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":"2018-03-31"},{"$f":"Timing!K5","v":"2018-06-30"},{"$f":"Timing!L5","v":"2018-09-30"},{"$f":"Timing!M5","v":"2018-12-31"},{"$f":"Timing!N5","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C6","v":"Start Date"},null,null,null,null,null,null,{"$f":"Timing!J6","v":"2018-02-25"},{"$f":"Timing!K6","v":"2018-04-01"},{"$f":"Timing!L6","v":"2018-07-01"},{"$f":"Timing!M6","v":"2018-10-01"},{"$f":"Timing!N6","v":"2019-01-01"}]
[null,null,{"$f":"Timing!C7","v":"End Date"},null,null,null,null,null,null,{"$f":"Timing!J7","v":"2018-03-31"},{"$f":"Timing!K7","v":"2018-06-30"},{"$f":"Timing!L7","v":"2018-09-30"},{"$f":"Timing!M7","v":"2018-12-31"},{"$f":"Timing!N7","v":"2019-03-31"}]
[null,null,{"$f":"Timing!C8","v":"Number of Days"},null,null,null,null,null,null,{"$f":"Timing!J8","v":35},{"$f":"Timing!K8","v":91},{"$f":"Timing!L8","v":92},{"$f":"Timing!M8","v":92},{"$f":"Timing!N8","v":90}]
[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}]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},{"$f":"A1","v":"Template"}]
[]
[null,null,"Heading"]
[]
[null,null,null,"Sub Heading"]

{"sheet":"Change Log","index":12,"n_rows":13,"n_cols":11,"rows_kept":13,"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":"Change Log"}]
[{"$f":"Model_Name","v":"SP Example Export Model.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Change Log"}]
[]
[null,null,"Summary"]
[]
[null,null,null,null,null,"Date","Model Version ","Details of change","Worksheet Reference","Row, column, cell reference","Author"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","I changed it","Change Log","F11","LB"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","So did I.","Timing","A4","LB"]
[null,null,null,null,null,"2013-05-21","Untitled attachment 00059.xlsm","And me.","Navigator","B9","Dave"]