{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["IDC UDF","Colouring Transferred and Dep","Transfererd Sheet","New Sheet","Other Sheet","Colours"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"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":"IDC UDF","index":0,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["IDC Circular Reference"]
[]
[]
[null,"Uses of Funds"]
[null,null,null,"Cap Exp",{"$f":"SUM(G5:K5)","v":660},null,100,200,300,50,10]
[null,null,null,"IDC",{"$f":"SUM(G6:K6)","v":61.372161561600009},null,{"$f":"G17","v":0},{"$f":"H17","v":3.6000000000000005},{"$f":"I17","v":10.929600000000001},{"$f":"J17","v":22.1230656},{"$f":"K17","v":24.7194959616}]
[null,null,null,"Total",{"$f":"SUM(G7:K7)","v":721.37216156160014},null,{"$f":"SUM(G5:G6)","v":100},{"$f":"SUM(H5:H6)","v":203.6},{"$f":"SUM(I5:I6)","v":310.92959999999999},{"$f":"SUM(J5:J6)","v":72.123065600000004},{"$f":"SUM(K5:K6)","v":34.719495961600003}]
[]
[null,null,null,"Total Debt",0.9,{"$f":"E9*E7","v":649.23494540544016}]
[null,null,null,"Pro-Rata Percent",{"$f":"E7","v":721.37216156160014},null,{"$f":"G7/$E$7","v":0.13862470071415517},{"$f":"H7/$E$7","v":0.28223989065401989},{"$f":"I7/$E$7","v":0.43102522743171978},{"$f":"J7/$E$7","v":9.9980383833873795E-2},{"$f":"K7/$E$7","v":4.8129797366231193E-2}]
[null,null,null,"Debt Draws",{"$f":"F9","v":649.23494540544016},null,{"$f":"G10*$E$11","v":90.000000000000014},{"$f":"H10*$E$11","v":183.24},{"$f":"I10*$E$11","v":279.83664000000005},{"$f":"J10*$E$11","v":64.910759040000002},{"$f":"K10*$E$11","v":31.247546365440005}]
[]
[null,"Debt Balance"]
[null,null,null,"Opening Balance",null,null,{"$f":"F16","v":0},{"$f":"G16","v":90.000000000000014},{"$f":"H16","v":273.24},{"$f":"I16","v":553.07664},{"$f":"J16","v":617.98739904000001}]
[null,null,null,"Add: Debt",null,null,{"$f":"G11","v":90.000000000000014},{"$f":"H11","v":183.24},{"$f":"I11","v":279.83664000000005},{"$f":"J11","v":64.910759040000002},{"$f":"K11","v":31.247546365440005}]
[null,null,null,"Closing Balance",null,null,{"$f":"G14+G15","v":90.000000000000014},{"$f":"H14+H15","v":273.24},{"$f":"I14+I15","v":553.07664},{"$f":"J14+J15","v":617.98739904000001},{"$f":"K14+K15","v":649.23494540544004}]
[null,null,null,"IDC",0.04,null,{"$f":"G19","v":0},{"$f":"H19","v":3.6000000000000005},10.929600000000001,22.1230656,24.7194959616]
[]
[null,"UDF Function",null,null,null,null,{"$f":"idc_result($E$17,$E$9,G5:K5)","v":0},3.6000000000000005,10.929600000000001,22.1230656,24.7194959616]
[null,null,null,null,null,null,{"$f":"G14*$E$17","v":0},0,0,0,0]
[null,null,null,"Verification",null,null,{"$f":"G14*$E$17","v":0},{"$f":"H14*$E$17","v":3.6000000000000005},{"$f":"I14*$E$17","v":10.929600000000001},{"$f":"J14*$E$17","v":22.1230656},{"$f":"K14*$E$17","v":24.7194959616}]
[null,null,null,"Difference",{"$f":"SUM(G22:K22)","v":0},{"$f":"E22=0","v":true},{"$f":"G21-G19","v":0},{"$f":"H21-H19","v":0},{"$f":"I21-I19","v":0},{"$f":"J21-J19","v":0},{"$f":"K21-K19","v":0}]
[]
[null,null,null,"Test No Dependent",100]
[null,null,null,"Test No Dependent",200]

{"sheet":"Colouring Transferred and Dep","index":1,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Column",30]
[null,"Row",10]
[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]
[4,null,"Input 1",100]
[5,null,"Input 2",200,null,"From Input",100,100,100,100,100,{"$f":"$D$4","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[6,null,"Input 3",400,null,"From Input",{"$f":"$D$8","v":500},{"$f":"$D$8","v":500},500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500]
[7,null,"Input 4",600,null,"Calculation",{"$f":"G6","v":500},{"$f":"SUM(H5:H6)","v":600},{"$f":"I6","v":500},600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600]
[8,null,"Input 5",500,null,"Input",{"$f":"$D$10","v":100},{"$f":"$D$10","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[9,null,"Input 6",1000,null,"Total",440,{"$f":"SUM(H5:H8)","v":1300},{"$f":"I7","v":500},1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300,1300]
[10,null,"Total",{"$f":"D4","v":100}]
[]
[null,null,"Output",{"$f":"D7","v":600}]
[null,null,"Output"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt, M, A","Remove"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt, M, D Dependents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt, M, P Precedents"]
[]
[null,null,null,null,null,"Red",{"$f":"Colours!B2","v":246},{"$f":"Colours!B2","v":246},"red1",null,"Row Start",4]
[null,null,null,null,null,"Green",{"$f":"Colours!B3","v":51},{"$f":"Colours!B3","v":51},"green1",null,"Row End",10]
[null,null,null,null,null,"Blue",{"$f":"Colours!B4","v":255},{"$f":"Colours!B4","v":255},"blue1",null,"Col Start",3]
[null,null,null,null,null,null,null,null,null,null,"Col End",30]
[null,null,null,null,null,null,"Slow",false]

{"sheet":"Transfererd Sheet","index":2,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Fee Percent",1.7500000000000002E-2]
[null,null,null,null,null,null,null,"Debt Percent",0.6]
[]
[null,"Fee Circular Reference",null,null,null,null,null,"Cap Exp",1000]
[null,null,null,null,null,null,null,"Fees",{"$f":"K6","v":10.68702290076336},null,{"$f":"I5*I3*I2/(1-I2)","v":10.68702290076336}]
[null,"Fees = Debt * Fee Percent",null,null,null,null,null,"Total Cost",{"$f":"SUM(I5:I6)","v":1010.6870229007634}]
[null,"Debt = Total Project Cost * Debt Perent"]
[null,"Project Cost = Other Cost + Fees",null,null,null,null,null,"Debt",{"$f":"I7*I3","v":606.41221374045801},{"$f":"I9/I7","v":0.6}]
[null,"Other Cost = Project Cost - Fees"]
[]
[null,"Other Cost = Project Cost - Debt * Fee Percent"]
[null,"Other Cost = Project Cost - Project Cost * Debt Percent"]
[null,"Other Cost = Project Cost * (1-Debt Percent)"]

{"sheet":"New Sheet","index":3,"n_rows":17,"n_cols":37,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Alt, M, A Remove"]
[{"$f":"'Colouring Transferred and Dep'!A3","v":1},null,"Alt, M, D Dependents"]
[{"$f":"'Colouring Transferred and Dep'!A4","v":4},null,"Alt, M, P Precedents"]
[{"$f":"'Colouring Transferred and Dep'!A5","v":5}]
[{"$f":"'Colouring Transferred and Dep'!A6","v":6}]
[{"$f":"'Colouring Transferred and Dep'!A7","v":7}]
[{"$f":"'Colouring Transferred and Dep'!A8","v":8},null,"From Other Sheet",null,{"$f":"'Colouring Transferred and Dep'!G8","v":100},{"$f":"'Colouring Transferred and Dep'!H8","v":100},{"$f":"'Colouring Transferred and Dep'!I8","v":100},{"$f":"'Colouring Transferred and Dep'!J8","v":100},{"$f":"'Colouring Transferred and Dep'!K8","v":100},{"$f":"'Colouring Transferred and Dep'!L8","v":100},{"$f":"'Colouring Transferred and Dep'!M8","v":100}]
[{"$f":"'Colouring Transferred and Dep'!A9","v":9}]
[{"$f":"'Colouring Transferred and Dep'!A10","v":10},null,"From Other Sheet",null,{"$f":"'Colouring Transferred and Dep'!H9","v":1300},{"$f":"'Colouring Transferred and Dep'!H9","v":1300},{"$f":"'Colouring Transferred and Dep'!I9","v":500},{"$f":"'Colouring Transferred and Dep'!J9","v":1300},{"$f":"'Colouring Transferred and Dep'!K9","v":1300},{"$f":"'Colouring Transferred and Dep'!L9","v":1300},{"$f":"'Colouring Transferred and Dep'!M9","v":1300}]
[{"$f":"'Colouring Transferred and Dep'!A11","v":0}]
[{"$f":"'Colouring Transferred and Dep'!A12","v":0}]
[{"$f":"'Colouring Transferred and Dep'!A13","v":0},null,"From Other Page"]
[{"$f":"'Colouring Transferred and Dep'!A14","v":0}]
[{"$f":"'Colouring Transferred and Dep'!A15","v":0}]
[{"$f":"'Colouring Transferred and Dep'!A16","v":0}]
[{"$f":"'Colouring Transferred and Dep'!A17","v":0},{"$f":"'Colouring Transferred and Dep'!B3","v":2},{"$f":"'Colouring Transferred and Dep'!C3","v":3},{"$f":"'Colouring Transferred and Dep'!D3","v":4},{"$f":"'Colouring Transferred and Dep'!E3","v":5},{"$f":"'Colouring Transferred and Dep'!F3","v":6},{"$f":"'Colouring Transferred and Dep'!G3","v":7},{"$f":"'Colouring Transferred and Dep'!H3","v":8},{"$f":"'Colouring Transferred and Dep'!I3","v":9},{"$f":"'Colouring Transferred and Dep'!J3","v":10},{"$f":"'Colouring Transferred and Dep'!K3","v":11},{"$f":"'Colouring Transferred and Dep'!L3","v":12},{"$f":"'Colouring Transferred and Dep'!M3","v":13},{"$f":"'Colouring Transferred and Dep'!N3","v":14},{"$f":"'Colouring Transferred and Dep'!O3","v":15},{"$f":"'Colouring Transferred and Dep'!P3","v":16},{"$f":"'Colouring Transferred and Dep'!Q3","v":17},{"$f":"'Colouring Transferred and Dep'!R3","v":18},{"$f":"'Colouring Transferred and Dep'!S3","v":19},{"$f":"'Colouring Transferred and Dep'!T3","v":20},{"$f":"'Colouring Transferred and Dep'!U3","v":21},{"$f":"'Colouring Transferred and Dep'!V3","v":22},{"$f":"'Colouring Transferred and Dep'!W3","v":23},{"$f":"'Colouring Transferred and Dep'!X3","v":24},{"$f":"'Colouring Transferred and Dep'!Y3","v":25},{"$f":"'Colouring Transferred and Dep'!Z3","v":26},{"$f":"'Colouring Transferred and Dep'!AA3","v":0},{"$f":"'Colouring Transferred and Dep'!AB3","v":0},{"$f":"'Colouring Transferred and Dep'!AC3","v":0},{"$f":"'Colouring Transferred and Dep'!AD3","v":0},{"$f":"'Colouring Transferred and Dep'!AE3","v":0},{"$f":"'Colouring Transferred and Dep'!AF3","v":0},{"$f":"'Colouring Transferred and Dep'!AG3","v":0},{"$f":"'Colouring Transferred and Dep'!AH3","v":0},{"$f":"'Colouring Transferred and Dep'!AI3","v":0},{"$f":"'Colouring Transferred and Dep'!AJ3","v":0},{"$f":"'Colouring Transferred and Dep'!AK3","v":0}]

{"sheet":"Other Sheet","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Colours","index":5,"n_rows":4,"n_cols":22,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,1,null,null,null,null,null,null,1,null,null,null,2,null,null,null,null,null,null,null,null,3]
["R",{"$f":"CHOOSE($B$1,I2,M2,V2)","v":246},null,null,null,null,null,null,246,null,null,null,132,null,null,null,null,null,null,null,null,255]
["G",{"$f":"CHOOSE($B$1,I3,M3,V3)","v":51},null,"https://htmlcolorcodes.com/",null,null,null,null,51,null,null,null,255,null,null,null,null,null,null,null,null,221]
["B",255,null,null,null,null,null,null,255,null,null,null,51,null,null,null,null,null,null,null,null,51]