{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Navigator","Style Guide","Model Parameters","S-Curve Assumptions","Error Checks","Change Log"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":43,"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":[[20,6,20,8],[21,6,21,8],[16,2,17,9]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct Pty Limited"}]
[null,null,{"$f":"Model_Name","v":"SP S-Curve Example.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple example to highlight how an S-curve might calculate (e.g. for the construction industry)."]
[]
[]
[]
[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 S-Curve Example.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,"S-Curve Assumptions"]
[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":[[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[16,2,16,6],[2,0,2,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"SP S-Curve Example.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":"Unused"},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":"2021-08-02"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2021-08-02"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Model Parameters","index":3,"n_rows":34,"n_cols":9,"rows_kept":34,"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 S-Curve Example.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 S-Curve Example.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]
[]
[null,null,null,null,"Currency",null,"$'000"]
[null,null,null,null,"Percent",null,"%"]

{"sheet":"S-Curve Assumptions","index":4,"n_rows":44,"n_cols":57,"rows_kept":44,"cut":false,"hidden":false,"merged":[[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":"S-Curve Assumptions"}]
[{"$f":"Model_Name","v":"SP S-Curve Example.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},"S-Curve Data"]
[]
[null,null,"Assumptions"]
[]
[null,null,null,"Costs",null,null,null,null,null,null,null,null,null,{"$f":"\"S-Curve Data for the Breakdown of \"&TEXT(Total_Costs,\"$#,##0k\")&\" Costs for the \"&TEXT(No_of_Periods,\"#,##0\")&\" Months Beginning \"&TEXT(Start_Date,\"mmm yy\")","v":"S-Curve Data for the Breakdown of $10,000k Costs for the 48 Months Beginning Aug 21"}]
[]
[null,null,null,null,"Total Cost",null,null,{"$f":"Currency","v":"$'000"},10000]
[]
[null,null,null,"Percentages"]
[]
[null,null,null,null,"Initial Percentage Completed",null,null,{"$f":"Percent","v":"%"},0.2]
[null,null,null,null,"Target Percentage",null,null,{"$f":"Percent","v":"%"},0.8]
[]
[null,null,null,"Other Factors"]
[]
[null,null,null,null,null,null,null,null,"Date","Date Used"]
[null,null,null,null,"Start Date",null,null,"#",{"$f":"TODAY()","v":"2021-08-02"},{"$f":"EOMONTH($I$22,0)","v":"2021-08-31"}]
[]
[null,null,null,null,null,null,null,null,"No. of Mths",{"$f":"J21","v":"Date Used"}]
[null,null,null,null,"Exponential Growth Start",null,null,"# Mths",13,{"$f":"EOMONTH(Start_Date,Exp_Growth_Start_Month_No-1)","v":"2022-08-31"}]
[null,null,null,null,"Exponential Duration",null,null,"# Mths",24,{"$f":"EOMONTH(Exp_Growth_Start,Exp_Duration_in_Months-1)","v":"2024-07-31"}]
[]
[null,null,null,null,"Exponential Factor",null,null,"#",30]
[]
[null,null,null,null,null,null,null,null,"No. of Mths",{"$f":"J21","v":"Date Used"}]
[null,null,null,null,"Total No. of Periods",null,null,"# Mths",48,{"$f":"EOMONTH(Start_Date,No_of_Periods-1)","v":"2025-07-31"}]
[]
[]
[null,{"$f":"MAX($B$5:$B33)+1","v":2},"Chart Data"]
[]
[null,null,"Calculations"]
[]
[null,null,null,"Summary"]
[]
[null,null,null,null,"Counter",null,null,"#",null,{"$f":"_xlfn.SEQUENCE(1,No_of_Periods)","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48]
[null,null,null,null,"Date",null,null,"Date",null,{"$f":"EOMONTH(Start_Date,_xlfn.ANCHORARRAY(J40)-1)","v":"2021-08-31"},"2021-09-30","2021-10-31","2021-11-30","2021-12-31","2022-01-31","2022-02-28","2022-03-31","2022-04-30","2022-05-31","2022-06-30","2022-07-31","2022-08-31","2022-09-30","2022-10-31","2022-11-30","2022-12-31","2023-01-31","2023-02-28","2023-03-31","2023-04-30","2023-05-31","2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31"]
[null,null,null,null,"Cost %",null,null,{"$f":"Percent","v":"%"},null,{"$f":"Initial_Percentage_Completed+(Target_Percentage-Initial_Percentage_Completed)/(1+Exp_Factor^((Exp_Growth_Start_Month_No+Exp_Duration_in_Months/2-_xlfn.ANCHORARRAY(J$40))/Exp_Duration_in_Months))","v":0.21935483870967742},0.2221926186165083,0.22542824886694796,0.22911185801392997,0.23329816058020897,0.23804633667556796,0.24341970658903625,0.24948514219202489,0.25631215183078326,0.26397157407228145,0.27253382049298103,0.2820666213538463,0.29263225327693093,0.30428426728496377,0.3170637899007423,0.33099553826465555,0.34608376787295048,0.36230844980122912,0.37962204005840161,0.39794724071654075,0.41717614390796126,0.43717108264394378,0.45776738232957481,0.47877802226028671,0.5,0.52122197773971335,0.5422326176704253,0.56282891735605634,0.58282385609203891,0.60205275928345925,0.6203779599415985,0.637691550198771,0.65391623212704963,0.66900446173534456,0.68293621009925776,0.69571573271503628,0.70736774672306924,0.7179333786461537,0.72746617950701919,0.73602842592771878,0.74368784816921685,0.75051485780797522,0.75658029341096378,0.76195366332443215,0.76670183941979109,0.77088814198607003,0.7745717511330521,0.77780738138349181]
[null,null,null,null,"Exponential Marker",null,null,{"$f":"Percent","v":"%"},null,{"$f":"IF((_xlfn.ANCHORARRAY(J41)>=Exp_Growth_Start)*(_xlfn.ANCHORARRAY(J41)<=Exp_Growth_End),Target_Percentage,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"\"Cost (\"&Currency&\")\"","v":"Cost ($'000)"},null,null,{"$f":"Currency","v":"$'000"},null,{"$f":"Total_Costs*_xlfn.ANCHORARRAY(J42)","v":2193.5483870967741},2221.926186165083,2254.2824886694793,2291.1185801392999,2332.9816058020897,2380.4633667556795,2434.1970658903624,2494.8514219202489,2563.1215183078325,2639.7157407228146,2725.3382049298102,2820.6662135384631,2926.3225327693094,3042.8426728496379,3170.6378990074231,3309.9553826465553,3460.8376787295047,3623.0844980122911,3796.2204005840163,3979.4724071654077,4171.7614390796125,4371.7108264394374,4577.6738232957478,4787.7802226028671,5000,5212.2197773971338,5422.3261767042532,5628.2891735605635,5828.2385609203893,6020.5275928345927,6203.7795994159851,6376.9155019877098,6539.1623212704962,6690.0446173534456,6829.3621009925773,6957.157327150363,7073.6774672306919,7179.3337864615369,7274.6617950701921,7360.2842592771876,7436.8784816921689,7505.148578079752,7565.802934109638,7619.5366332443218,7667.0183941979112,7708.8814198607006,7745.7175113305211,7778.0738138349179]

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

{"sheet":"Change Log","index":6,"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 S-Curve Example.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"]