{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Working Capital>>","Simple Example","Monthly Calculations","Second Monthly Example","Error Checks"],"not_rendered":{"charts":1,"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":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,2,17,9],[18,2,18,9],[21,6,21,8],[22,6,22,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct Pty Limited"}]
[null,null,{"$f":"Model_Name","v":"Working Capital Adjustment.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[null,null,"Revisions: Hanh Tran"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Example to develop a dashboard."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"Working Capital Adjustment.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,"Working Capital>>"]
[null,null,null,null,null,"Simple Example"]
[null,null,null,null,null,"Monthly Calculations"]
[null,null,null,null,null,"Second Monthly Example"]
[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":"Working Capital Adjustment.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":"2020-12-17"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2020-12-17"},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":"Working Capital Adjustment.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":"Working Capital Adjustment.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":"Working Capital>>","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Navigator"]

{"sheet":"Simple Example","index":5,"n_rows":52,"n_cols":11,"rows_kept":52,"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":"Simple Example"}]
[{"$f":"Model_Name","v":"Working Capital Adjustment.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,0]
[]
[]
[null,null,"Simple Example"]
[]
[null,null,null,null,"This assumes that the number of days in the period exceeds the "]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"Type of Example",null,null,"Debtor"]
[]
[null,null,null,null,{"$f":"\"Days \"&IF($H$13=\"Creditor\",\"Payable\",\"Receivable\")","v":"Days Receivable"},null,null,128]
[]
[null,null,null,null,{"$f":"IF($H$13=\"Creditor\",\"Costs\",\"Sales\")&\" in Period\"","v":"Sales in Period"},null,null,1000]
[]
[null,null,null,null,"Days in Year",null,null,{"$f":"Days_in_Year","v":365}]
[]
[]
[]
[null,null,null,"Control Account"]
[]
[null,null,null,null,{"$f":"\"Opening \"&PROPER($H$13)&\"s\"","v":"Opening Debtors"},null,null,0,null,"Prior BS"]
[null,null,null,null,{"$f":"E17","v":"Sales in Period"},null,null,{"$f":"H17","v":1000},null,"IS"]
[null,null,null,null,{"$f":"\"Cash \"&IF($H$13=\"Creditor\",\"Payments\",\"Receipts\")","v":"Cash Receipts"},null,null,{"$f":"H28-SUM(H25:H26)","v":-649.31506849315065},{"$f":"-H27","v":649.31506849315065},"CFS"]
[null,null,null,null,{"$f":"\"Closing \"&PROPER($H$13)&\"s\"","v":"Closing Debtors"},null,null,{"$f":"IF(Days_in_Year,$H$15/Days_in_Year*H26)","v":350.6849315068493},null,"Current BS"]
[]
[]
[null,null,null,"Chart Data"]
[]
[null,null,null,null,null,null,null,{"$f":"Days_in_Year","v":365},0.1,null,0]
[null,null,null,null,{"$f":"E26","v":"Sales in Period"},null,null,{"$f":"Days_in_Year","v":365}]
[null,null,null,null,null,null,null,{"$f":"Days_in_Year","v":365},0.1,null,0]
[null,null,null,null,{"$f":"E27","v":"Cash Receipts"},null,null,{"$f":"IF(H26,H28/H26*Days_in_Year,)","v":128},{"$f":"Days_in_Year-H36","v":237},null,{"$f":"H36","v":128}]
[null,null,null,null,null,null,null,{"$f":"Days_in_Year","v":365},0.1,null,0]
[]
[null,null,null,null,null,null,null,0,3]
[null,null,null,null,null,null,null,{"$f":"H36","v":128},2]
[]
[null,null,null,null,null,null,null,{"$f":"Days_in_Year/4","v":91.25},3]
[null,null,null,null,null,null,null,{"$f":"H40+H42","v":219.25},2]
[]
[null,null,null,null,null,null,null,{"$f":"Days_in_Year/2","v":182.5},3]
[null,null,null,null,null,null,null,{"$f":"H45+H40","v":310.5},2]
[]
[null,null,null,null,null,null,null,{"$f":"H42+H45","v":273.75},3]
[null,null,null,null,null,null,null,{"$f":"H48+H40","v":401.75},2]
[]
[null,null,null,null,null,null,null,{"$f":"Days_in_Year","v":365},3]
[null,null,null,null,null,null,null,{"$f":"H51+H40","v":493},2]

{"sheet":"Monthly Calculations","index":6,"n_rows":28,"n_cols":24,"rows_kept":28,"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":"Monthly Calculations"}]
[{"$f":"Model_Name","v":"Working Capital Adjustment.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,0]
[]
[]
[null,null,"Monthly Calculations Example"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"Days in an Average Month"]
[]
[null,null,null,null,null,"Required for calculations",null,null,30,"days"]
[]
[]
[null,null,null,null,"Days Receivable"]
[null,null,null,null,null,null,null,null,null,null,"Complete Mths","Partial Mth"]
[null,null,null,null,null,{"$f":"'Simple Example'!E15","v":"Days Receivable"},null,75,null,null,{"$f":"IF(Average_Days_in_Month,INT(H18/Average_Days_in_Month),)","v":2},{"$f":"IF(Average_Days_in_Month,MOD(H18,Average_Days_in_Month)/Average_Days_in_Month,)","v":0.5}]
[]
[]
[null,null,null,"Calculations"]
[]
[null,null,null,null,null,"Month Number",null,null,null,null,{"$f":"N(J23)+1","v":1},{"$f":"N(K23)+1","v":2},3,4,5,6,7,8,9,10,{"$f":"N(T23)+1","v":11},12]
[]
[null,null,null,null,null,{"$f":"'Simple Example'!E25","v":"Opening Debtors"},null,null,null,null,{"$f":"IF(K$23=1,,J28)","v":0},{"$f":"IF(L$23=1,,K28)","v":100},300,550,800,1050,1300,1550,1800,2050,2300,2550,null,{"$f":"'Simple Example'!J25","v":"Prior BS"}]
[null,null,null,null,null,{"$f":"'Simple Example'!E26","v":"Sales in Period"},null,null,null,null,100,200,300,400,500,600,700,800,900,1000,1100,1200,null,{"$f":"'Simple Example'!J26","v":"IS"}]
[null,null,null,null,null,{"$f":"'Simple Example'!E27","v":"Cash Receipts"},null,null,null,null,{"$f":"K28-SUM(K25:K26)","v":0},{"$f":"L28-SUM(L25:L26)","v":0},-50,-150,-250,-350,-450,-550,-650,-750,-850,-950,null,{"$f":"'Simple Example'!J27","v":"CFS"}]
[null,null,null,null,null,{"$f":"'Simple Example'!E28","v":"Closing Debtors"},null,null,null,null,{"$f":"IF($K$18,SUM(OFFSET(K26,,,1,-MIN($K$18,K$23))),)+IF(K$23-$K$18<=0,,OFFSET(K26,,-$K$18)*$L$18)","v":100},{"$f":"IF($K$18,SUM(OFFSET(L26,,,1,-MIN($K$18,L$23))),)+IF(L$23-$K$18<=0,,OFFSET(L26,,-$K$18)*$L$18)","v":300},550,800,1050,1300,1550,1800,2050,2300,2550,2800,null,{"$f":"'Simple Example'!J28","v":"Current BS"}]

{"sheet":"Second Monthly Example","index":7,"n_rows":62,"n_cols":24,"rows_kept":62,"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":"Second Monthly Example"}]
[{"$f":"Model_Name","v":"Working Capital Adjustment.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,0]
[]
[]
[null,null,"More Sophisticated Montly Calculations"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,null,"Month Number",null,null,null,null,{"$f":"N(J11)+1","v":1},{"$f":"N(K11)+1","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[null,null,null,null,null,"Forecast Sales Revenue",null,null,null,null,100,200,300,400,500,600,700,800,900,1000,1100,1200]
[]
[null,null,null,null,null,"Cash Receipt Profile",null,null,null,null,0.4,0.25,0.15,0.1,0.05]
[]
[null,null,null,null,null,"Bad Debt",null,{"$f":"MAX(1-SUM(K15:V15),)","v":4.9999999999999933E-2}]
[null,null,null,null,null,"Month Written Off",null,6]
[]
[null,null,null,null,null,"Amount Written Off",null,null,null,null,{"$f":"IF(K$11-$H$18<0,,OFFSET(K$13,,1-$H$18))*$H$17","v":0},{"$f":"IF(L$11-$H$18<0,,OFFSET(L$13,,1-$H$18))*$H$17","v":0},0,0,0,4.9999999999999929,9.9999999999999858,14.99999999999998,19.999999999999972,24.999999999999968,29.999999999999961,34.99999999999995]
[]
[]
[null,null,null,"Calculations"]
[]
[null,null,null,null,"Simple Grid Method"]
[]
[null,null,null,null,null,{"$f":"F11","v":"Month Number"},null,null,null,null,{"$f":"K11","v":1},2,3,4,5,6,7,8,9,10,11,12]
[]
[null,null,null,null,null,null,{"$f":"N(G28)+1","v":1},{"$f":"OFFSET($J$13,,$G29)","v":100},null,null,{"$f":"IF(K$27-$G29>=0,OFFSET(K$15,,1-$G29),)*$H29","v":40},25,15,10,5,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"N(G29)+1","v":2},{"$f":"OFFSET($J$13,,$G30)","v":200},null,null,0,80,50,30,20,10,0,0,0,0,0,0]
[null,null,null,null,null,null,3,300,null,null,0,0,120,75,45,30,15,0,0,0,0,0]
[null,null,null,null,null,null,4,400,null,null,0,0,0,160,100,60,40,20,0,0,0,0]
[null,null,null,null,null,null,5,500,null,null,0,0,0,0,200,125,75,50,25,0,0,0]
[null,null,null,null,null,null,6,600,null,null,0,0,0,0,0,240,150,90,60,30,0,0]
[null,null,null,null,null,null,7,700,null,null,0,0,0,0,0,0,280,175,105,70,35,0]
[null,null,null,null,null,null,8,800,null,null,0,0,0,0,0,0,0,320,200,120,80,40]
[null,null,null,null,null,null,9,900,null,null,0,0,0,0,0,0,0,0,360,225,135,90]
[null,null,null,null,null,null,10,1000,null,null,0,0,0,0,0,0,0,0,0,400,250,150]
[null,null,null,null,null,null,{"$f":"N(G38)+1","v":11},1100,null,null,0,0,0,0,0,0,0,0,0,0,440,275]
[null,null,null,null,null,null,12,1200,null,null,0,0,0,0,0,0,0,0,0,0,0,480]
[null,null,null,null,null,null,"Cash Receipts",null,null,null,{"$f":"SUM(K29:K40)","v":40},{"$f":"SUM(L29:L40)","v":105},185,275,370,465,560,655,750,845,940,1035]
[]
[]
[null,null,null,null,"Reverse Ticker Method"]
[]
[null,null,null,null,null,{"$f":"F27","v":"Month Number"},null,null,null,null,{"$f":"K27","v":1},2,3,4,5,6,7,8,9,10,11,12]
[]
[null,null,null,null,null,null,{"$f":"\"Reverse \"&F15","v":"Reverse Cash Receipt Profile"},null,null,null,{"$f":"INDEX($K$15:$V$15,MAX($K$46:$V$46)-K$46+1)","v":0},{"$f":"INDEX($K$15:$V$15,MAX($K$46:$V$46)-L$46+1)","v":0},0,0,0,0,0,0.05,0.1,0.15,0.25,0.4]
[null,null,null,null,null,null,{"$f":"F13","v":"Forecast Sales Revenue"},null,null,null,{"$f":"K13","v":100},{"$f":"L13","v":200},300,400,500,600,700,800,900,1000,1100,1200]
[]
[null,null,null,null,null,null,{"$f":"G41","v":"Cash Receipts"},null,null,null,{"$f":"SUMPRODUCT(OFFSET($V$48,,,1,-K$46)*OFFSET($K$49,,,1,K$46))","v":40},{"$f":"SUMPRODUCT(OFFSET($V$48,,,1,-L$46)*OFFSET($K$49,,,1,L$46))","v":105},185,275,370,465,560,655,750,845,940,1035]
[]
[]
[null,null,null,"Control Account"]
[]
[null,null,null,null,null,{"$f":"F46","v":"Month Number"},null,null,null,null,{"$f":"K46","v":1},{"$f":"L46","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[null,null,null,null,null,null,"Opening Debtors",null,null,null,{"$f":"IF(K$56=1,,J62)","v":0},{"$f":"IF(L$56=1,,K62)","v":60},155,270,395,525,655,785,915,1045,1175,1305,null,{"$f":"'Simple Example'!J25","v":"Prior BS"}]
[null,null,null,null,null,null,"Sales in Period",null,null,null,{"$f":"K13","v":100},{"$f":"L13","v":200},300,400,500,600,700,800,900,1000,1100,1200,null,{"$f":"'Simple Example'!J26","v":"IS"}]
[null,null,null,null,null,null,"Bad Debts Written Off",null,null,null,{"$f":"-K20","v":0},{"$f":"-L20","v":0},0,0,0,-4.9999999999999929,-9.9999999999999858,-14.99999999999998,-19.999999999999972,-24.999999999999968,-29.999999999999961,-34.99999999999995,null,{"$f":"'Simple Example'!J26","v":"IS"}]
[null,null,null,null,null,null,{"$f":"G51","v":"Cash Receipts"},null,null,null,{"$f":"-K51","v":-40},{"$f":"-L51","v":-105},-185,-275,-370,-465,-560,-655,-750,-845,-940,-1035,null,{"$f":"'Simple Example'!J27","v":"CFS"}]
[null,null,null,null,null,null,"Closing Debtors",null,null,null,{"$f":"SUM(K58:K61)","v":60},{"$f":"SUM(L58:L61)","v":155},270,395,525,655,785,915,1045,1175,1305,1435,null,{"$f":"'Simple Example'!J28","v":"Current BS"}]

{"sheet":"Error Checks","index":8,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Error Checks"}]
[{"$f":"Model_Name","v":"Working Capital Adjustment.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}]