{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","Quick guide","TFD Calculator","Table for BSA","DO NOT USE","Example","CP_EG","TFD_EG","Explanation of PV"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":3,"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":"Introduction","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"What is the Credit pricing spreadsheet for?"]
[]
[null,"How the TFD calculation works? "]
[]
[null,null,"What types of costs can be included (see Reg) / reference to the mgt actions"]
[null,null,"Why 20 year period has been adopted?"]
[null,null,"Calculation of the PV of the management costs using Gazzetted discount rates "]
[null,null,"(Note: PV calculaitn is based on the payments made from the TF to the landowenrat the beginning of the period)"]
[null,null,"Reference to the adopted discount rates and the lengths of the investment periods."]
[null,null,"(Note: There is an implicid risk marigin incorporated in the TFD calcautions derived from assuming a real discount rate that is less than the expected real investment rate.)"]

{"sheet":"Quick guide","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TFD Calculator","index":2,"n_rows":114,"n_cols":31,"rows_kept":114,"cut":false,"hidden":false,"merged":[[11,1,12,1],[11,2,12,2],[4,1,4,3],[5,1,5,3],[11,4,11,6],[11,30,12,30],[38,30,39,30],[38,29,39,29],[38,8,38,27],[11,29,12,29],[24,8,24,27],[38,28,39,28],[11,28,12,28],[43,3,43,7],[44,3,44,7],[4,26,5,26],[41,3,41,7],[40,3,40,7],[42,3,42,7],[4,4,4,6],[5,4,5,6],[11,3,12,3],[11,8,11,27],[8,16,8,25],[8,8,8,9],[7,8,7,9],[11,7,12,7],[7,16,7,25],[6,16,6,25]]}
[]
[null,"Total Fund Deposit Calculator "]
[]
[]
[null,"Site name"]
[null,"Site location (Lot/DP or address)"]
[]
[null,null,null,null,null,null,null,null,"Discount rate"]
[null,null,null,null,null,null,null,null,3.2000000000000001E-2]
[]
[]
[null,"Management plan section","TFD item #","Management action item","Timing",null,null,"Estimated annual cost ($)","Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present value of payments for first 20 yrs","Present value of  payments after 20 yrs","Present value of all payments"]
[null,null,null,null,"Start year","End year","Frequency ",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($E14),$E14>I$13),0,IF(AND(NOT(ISBLANK($F14)),I$13>$F14),0,IF(MOD((I$13-$E14),MAX($G14,1))=0,$H14,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(OR(ISBLANK($E14),$E14>S$13),0,IF(AND(NOT(ISBLANK($F14)),S$13>$F14),0,IF(MOD((S$13-$E14),MAX($G14,1))=0,$H14,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMPRODUCT(I14:AB14,$I$37:$AB$37)","v":0},{"$f":"(IF(ISBLANK(E14),0,IF(F14,0,((1+$I$9)^MOD($AB$13-E14,MAX(G14,1)))*((1+$I$9)^-$AB$13)*H14/((1+$I$9)^(MAX(G14,1))-1))))*(1+$I$9)","v":0},{"$f":"+AC14+AD14","v":0}]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(IF(ISBLANK(E15),0,IF(F15,0,((1+$I$9)^MOD($AB$13-E15,MAX(G15,1)))*((1+$I$9)^-$AB$13)*H15/((1+$I$9)^(MAX(G15,1))-1))))*(1+$I$9)","v":0},{"$f":"+AC15+AD15","v":0}]
[null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,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,null,null,null,null,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(IF(ISBLANK(E19),0,IF(F19,0,((1+$I$9)^MOD($AB$13-E19,MAX(G19,1)))*((1+$I$9)^-$AB$13)*H19/((1+$I$9)^(MAX(G19,1))-1))))*(1+$I$9)","v":0},0]
[null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(IF(ISBLANK(E22),0,IF(F22,0,((1+$I$9)^MOD($AB$13-E22,MAX(G22,1)))*((1+$I$9)^-$AB$13)*H22/((1+$I$9)^(MAX(G22,1))-1))))*(1+$I$9)","v":0},{"$f":"+AC22+AD22","v":0}]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(IF(ISBLANK(E23),0,IF(F23,0,((1+$I$9)^MOD($AB$13-E23,MAX(G23,1)))*((1+$I$9)^-$AB$13)*H23/((1+$I$9)^(MAX(G23,1))-1))))*(1+$I$9)","v":0},{"$f":"+AC23+AD23","v":0}]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Management plan section","TFD item #","Other recurring management items and costs",null,null,null,"Estimated annual cost ($)"]
[null,null,null,"Annual reporting fee (2023/24 financial year)",1,null,1,1785,{"$f":"IF(OR(ISBLANK($E26),$E26>I$13),0,IF(AND(NOT(ISBLANK($F26)),I$13>$F26),0,IF(MOD((I$13-$E26),MAX($G26,1))=0,$H26,0)))","v":1785},1785,1785,1785,1785,1785,1785,1785,1785,1785,{"$f":"IF(OR(ISBLANK($E26),$E26>S$13),0,IF(AND(NOT(ISBLANK($F26)),S$13>$F26),0,IF(MOD((S$13-$E26),MAX($G26,1))=0,$H26,0)))","v":1785},1785,1785,1785,1785,1785,1785,1785,1785,1785,{"$f":"+SUMPRODUCT(I26:AB26,$I$37:$AB$37)","v":26906.11988351911},{"$f":"(IF(ISBLANK(E26),0,IF(F26,0,((1+$I$9)^MOD($AB$13-E26,MAX(G26,1)))*((1+$I$9)^-$AB$13)*H26/((1+$I$9)^(MAX(G26,1))-1))))*(1+$I$9)","v":30660.130116480868},{"$f":"+AC26+AD26","v":57566.249999999978}]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($E27),$E27>I$13),0,IF(AND(NOT(ISBLANK($F27)),I$13>$F27),0,IF(MOD((I$13-$E27),MAX($G27,1))=0,$H27,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(IF(ISBLANK(E27),0,IF(F27,0,((1+$I$9)^MOD($AB$13-E27,MAX(G27,1)))*((1+$I$9)^-$AB$13)*H27/((1+$I$9)^(MAX(G27,1))-1))))*(1+$I$9)","v":0},0]
[null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK($E29),$E29>I$13),0,IF(AND(NOT(ISBLANK($F29)),I$13>$F29),0,IF(MOD((I$13-$E29),MAX($G29,1))=0,$H29,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(IF(ISBLANK(E29),0,IF(F29,0,((1+$I$9)^MOD($AB$13-E29,MAX(G29,1)))*((1+$I$9)^-$AB$13)*H29/((1+$I$9)^(MAX(G29,1))-1))))*(1+$I$9)","v":0},{"$f":"+AC29+AD29","v":0}]
[null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(IF(ISBLANK(E30),0,IF(F30,0,((1+$I$9)^MOD($AB$13-E30,MAX(G30,1)))*((1+$I$9)^-$AB$13)*H30/((1+$I$9)^(MAX(G30,1))-1))))*(1+$I$9)","v":0},{"$f":"+AC30+AD30","v":0}]
[null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,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,null,null,null,null,null,null,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,null,null,null,null,null,"Site management cost in today's value",{"$f":"SUM(I26:I33)+SUM(I14:I24)","v":1785},1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,null,null,"Total Trust Fund Deposit"]
[null,null,null,null,null,null,null,"Present Value (PV) of the site management cost",{"$f":"I34*(1+$I$9)^-(I13-1)","v":1785},1729.6511627906975,1676.0185685956374,1624.049000577168,1573.6908920321396,1524.8942752249411,1477.6107318071138,1431.7933447743353,1387.3966519131154,1344.3766006910032,1302.6905045455458,1262.2970005286297,1223.1560082641761,1185.2286901784651,1148.4774129636291,1112.8657102360748,1078.3582463527855,1044.9207813495984,1012.5201369666651,981.12416372738892,{"$f":"SUM(AC26:AC33)+SUM(AC14:AC24)","v":26906.11988351911},{"$f":"SUM(AD26:AD33)+SUM(AD14:AD24)","v":30660.130116480868},{"$f":"+AC35+AD35","v":57566.249999999978}]
[]
[null,null,null,null,null,null,"Discount factor",null,{"$f":"+(1+$I$9)^-(I13-1)","v":1},0.96899224806201545,0.9389459768042786,0.90983137287236304,0.88161954735694092,0.85428250712881859,0.82779312706280883,0.80212512312287687,0.77725302628185733,0.75315215724986173,0.7297986019863002,0.70716918797122119,0.68524146121242357,0.66399366396552661,0.64340471314489034,0.62345417940396353,0.60412226686430559,0.58538979347316433,0.5672381719701205,0.54964939144391534]
[]
[null,null,null,null,null,null,null,null,"Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present value of payments during first 20 yrs","Present value of  payments after 20 yrs","Present value of all payments"]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,"Annual site management costs in today's values",null,null,null,null,{"$f":"I34","v":1785},1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,{"$f":"AC35","v":26906.11988351911},{"$f":"AD35","v":30660.130116480868},{"$f":"AE35","v":57566.249999999978}]
[null,null,null,"Annual reporting fee  ",null,null,null,null,{"$f":"I26","v":1785},1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,1785,26906.11988351911,30660.130116480868,57566.249999999978]
[null,null,null,"Total amount payable to landowner (excluding GST)",null,null,null,null,{"$f":"I41-I42","v":0},{"$f":"J41-J42","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"GST payable to landowner",null,null,null,null,{"$f":"I43*0.1","v":0},{"$f":"J43*0.1","v":0},{"$f":"K43*0.1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AC43*0.1","v":0},{"$f":"AD43*0.1","v":0},{"$f":"AE43*0.1","v":0}]
[null,null,null,"Total amount payable to landowner (including GST)",null,null,null,null,{"$f":"I43*1.1","v":0},{"$f":"J43*1.1","v":0},{"$f":"K43*1.1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AC43*1.1","v":0},{"$f":"AD43*1.1","v":0},{"$f":"AE43*1.1","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Data for spreadsheet function use only"]
[]
[null,null,null,null,1]
[null,null,null,null,{"$f":"+E95+1","v":2},null,null,null,"Mand","Rec"]
[null,null,null,null,{"$f":"+E96+1","v":3},null,null,"cell",{"$f":"+ADDRESS(13+$I$99,1)","v":"$A$24"},{"$f":"+ADDRESS($I$99+$J$99+15,1)","v":"$A$33"}]
[null,null,null,null,4,null,null,"row num",{"$f":"RIGHT($I$97,LEN($I$97)-FIND(\"$\",$I$97,3))","v":"24"},{"$f":"RIGHT($J$97,LEN($J$97)-FIND(\"$\",$J$97,3))","v":"33"}]
[null,null,null,null,5,null,null,"mand count",{"$f":"+COUNT(I14:I24)","v":11},{"$f":"+COUNT(I27:I33)","v":7}]
[null,null,null,null,6]
[null,null,null,null,7]
[null,null,null,null,8,null,null,"Yes"]
[null,null,null,null,9,null,null,"No"]
[null,null,null,null,10]
[null,null,null,null,11]
[null,null,null,null,12]
[null,null,null,null,13]
[null,null,null,null,14]
[null,null,null,null,15]
[null,null,null,null,16]
[null,null,null,null,17]
[null,null,null,null,18]
[null,null,null,null,19]
[null,null,null,null,20]

{"sheet":"Table for BSA","index":3,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":true,"merged":[[22,2,22,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[1,1,1,4],[23,1,23,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[17,2,17,4],[18,2,18,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[19,2,19,4],[20,2,20,4],[21,2,21,4]]}
[]
[null,"Years 1 to 20 "]
[null,"Payment to be made at the beginning of:","Payment Amount (excluding GST)"]
[null,"First Payment Year",{"$f":"'TFD Calculator'!I$43","v":0}]
[null,"Second Payment Year",{"$f":"'TFD Calculator'!J$43","v":0}]
[null,"Third Payment Year",{"$f":"'TFD Calculator'!K$43","v":0}]
[null,"Fourth Payment Year",{"$f":"'TFD Calculator'!L$43","v":0}]
[null,"Fifth Payment Year",{"$f":"'TFD Calculator'!M$43","v":0}]
[null,"Sixth Payment Year",{"$f":"'TFD Calculator'!N$43","v":0}]
[null,"Seventh Payment Year",{"$f":"'TFD Calculator'!O$43","v":0}]
[null,"Eighth Payment Year",{"$f":"'TFD Calculator'!P$43","v":0}]
[null,"Ninth Payment Year",{"$f":"'TFD Calculator'!Q$43","v":0}]
[null,"Tenth Payment Year",{"$f":"'TFD Calculator'!R$43","v":0}]
[null,"Eleventh Payment Year",{"$f":"'TFD Calculator'!S$43","v":0}]
[null,"Twelfth Payment Year",{"$f":"'TFD Calculator'!T$43","v":0}]
[null,"Thirteenth Payment Year",{"$f":"'TFD Calculator'!U$43","v":0}]
[null,"Fourteenth Payment Year",{"$f":"'TFD Calculator'!V$43","v":0}]
[null,"Fifteenth Payment Year",{"$f":"'TFD Calculator'!W$43","v":0}]
[null,"Sixteenth Payment Year",{"$f":"'TFD Calculator'!X$43","v":0}]
[null,"Seventeenth Payment Year",{"$f":"'TFD Calculator'!Y$43","v":0}]
[null,"Eighteenth Payment Year",{"$f":"'TFD Calculator'!Z$43","v":0}]
[null,"Nineteenth Payment Year",{"$f":"'TFD Calculator'!AA$43","v":0}]
[null,"Twentieth Payment Year",{"$f":"'TFD Calculator'!AB$43","v":0}]
[null,"Ongoing (year 21 and beyond)"]
[null,"Description","Next instance","Frequency thereafter","Amount"]
[null,{"$f":"_xlfn._xlws.FILTER(INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!J98),INDIRECT(\"'TFD Calculator'!AD14:AD\"&'TFD Calculator'!J98)>0,\"No costs after year 20\")","v":"Annual reporting fee (2023/24 financial year)"},{"$f":"IFERROR(IF(MOD(20-H26,D26)=0,\"Year \"&MOD(20-H26,D26)+20+D26,\"Year \"&20-MOD(20-H26,D26)+D26),\"\")","v":"Year 21"},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B26,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":1},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B26,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":1785},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B26,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":1}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B27,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B27,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B27,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B28,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B28,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B28,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B29,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B29,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B29,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B30,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B30,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B30,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B31,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B31,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B31,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B32,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B32,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B32,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B33,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B33,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B33,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B34,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B34,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B34,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B35,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B35,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B35,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B36,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B36,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B36,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B37,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B37,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B37,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B38,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B38,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B38,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B39,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B39,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B39,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B40,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B40,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B40,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B41,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B41,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B41,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B42,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B42,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B42,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B43,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B43,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B43,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B44,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B44,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B44,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B45,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B45,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B45,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B46,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B46,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B46,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B47,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B47,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B47,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B48,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B48,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B48,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B49,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B49,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B49,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B50,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B50,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B50,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B51,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B51,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B51,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B52,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B52,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B52,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B53,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B53,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B53,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B54,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B54,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B54,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B55,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B55,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B55,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B56,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B56,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B56,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B57,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B57,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B57,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(MOD(20-H58,D58)=0,\"Year \"&MOD(20-H58,D58)+20+D58,\"Year \"&20-MOD(20-H58,D58)+D58),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B58,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B58,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B58,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B59,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B59,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B59,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B60,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B60,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B60,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B61,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B61,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B61,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B62,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B62,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B62,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B63,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B63,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B63,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B64,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B64,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B64,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B65,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B65,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B65,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B66,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B66,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B66,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B67,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B67,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B67,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B68,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B68,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B68,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B69,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B69,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B69,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B70,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B70,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B70,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B71,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B71,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B71,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B72,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B72,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B72,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B73,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B73,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B73,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B74,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B74,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B74,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B75,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B75,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B75,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B76,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B76,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B76,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B77,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B77,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B77,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B78,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B78,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B78,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B79,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B79,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B79,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B80,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B80,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B80,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B81,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B81,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B81,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B82,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B82,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B82,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B83,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B83,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B83,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B84,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B84,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B84,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B85,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B85,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B85,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B86,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B86,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B86,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B87,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B87,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B87,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B88,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B88,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B88,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B89,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B89,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B89,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(MOD(20-H90,D90)=0,\"Year \"&MOD(20-H90,D90)+20+D90,\"Year \"&20-MOD(20-H90,D90)+D90),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B90,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B90,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B90,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B91,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B91,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B91,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B92,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B92,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B92,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B93,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B93,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B93,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B94,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B94,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B94,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B95,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B95,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B95,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B96,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B96,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B96,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B97,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B97,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B97,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B98,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B98,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B98,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B99,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B99,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B99,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B100,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),4),\"\")","v":""},{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B100,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),5),\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(INDIRECT(\"'TFD Calculator'!D14:H\"&'TFD Calculator'!$J$98),MATCH(B100,INDIRECT(\"'TFD Calculator'!D14:D\"&'TFD Calculator'!$J$98),0),2),\"\")","v":""}]

{"sheet":"DO NOT USE","index":4,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
["2 Disturbance and infrastructure "]
["3 Weed management and control "]
["4 Pest animal controls "]
["5 PCTs and TECs"]
["6 Threatened species habitat "]
["7 Grazing management "]
["8 Fire management "]
["9 Monitoring and adaptive management "]

{"sheet":"Example","index":5,"n_rows":142,"n_cols":32,"rows_kept":142,"cut":false,"hidden":true,"merged":[[11,1,11,4],[18,1,18,4],[28,1,28,4],[17,1,17,4],[101,1,101,2],[102,1,102,2],[103,1,103,2],[91,1,91,2],[92,1,92,2],[96,1,96,2],[97,1,97,2],[98,1,98,2],[99,1,99,2],[100,1,100,2],[47,1,48,1],[47,2,48,2],[47,3,47,5],[93,1,93,2],[4,1,4,4],[31,1,31,4],[5,1,5,4],[8,1,8,4],[9,1,9,4],[30,1,30,4],[29,1,29,4],[12,1,12,4],[16,1,16,4],[6,1,6,4],[23,1,23,4],[21,1,21,4],[19,1,19,4],[20,1,20,4],[24,1,24,4],[22,1,22,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[7,1,7,4],[10,1,10,4],[15,1,15,4],[13,1,13,4],[14,1,14,4],[115,0,120,0],[115,1,115,2],[127,1,128,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[111,0,113,0],[111,1,111,2],[112,1,112,2],[95,0,109,0],[125,0,137,0],[125,1,126,1],[134,1,134,2],[136,1,137,2],[135,1,135,2],[132,1,132,2],[130,1,130,2],[131,1,131,2],[113,1,113,2],[95,1,95,2],[114,1,114,2],[104,1,104,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[127,3,128,3],[129,1,129,2],[129,5,134,11],[135,5,140,11],[122,5,125,11],[126,5,126,11],[127,5,127,11],[128,5,128,11],[141,5,141,11],[136,3,137,3],[91,5,91,11],[92,5,96,11],[97,5,97,11],[98,5,98,11],[99,5,105,11],[106,5,106,11],[120,5,120,11],[121,5,121,11],[118,5,119,11],[114,5,117,11],[35,9,35,10],[68,9,68,28],[68,29,69,29],[68,30,69,30],[107,5,113,11],[68,31,69,31],[47,31,48,31],[56,3,56,5],[56,6,56,8],[56,9,56,28],[47,6,47,8],[47,9,47,28],[47,29,48,29],[47,30,48,30]]}
[null,"Example - estimating Trust Fund Deposit and calculating credit price"]
[]
[]
[]
[null,"About the Site "]
[null,"A 200ha area of land with native vegetation is considered for establishing a BioBank site. The landowner is committed to permanent protection and management of the site for conservation but is also keen to derive economic benefit and obtain financial resources to pay for site management that would improve the condition of vegetation and habitat of species present on their site."]
[null,"Based on research of the potential market demand and preliminary advice obtained from the local environmental consultancy, the landowner has determined that the vegetation type present on the site is under a lot of development pressure and in limited supply. The biodiversity credits that can therefore be generated on the property are expected to be in high demand and attract a good price on the market. After considering the implications of establishing a BioBank site (obligations and some potential risks are listed in the Guide to establishing a BioBank site) and discussing this opportunity with people involved or affected by his decision, the landowner hired a BioBanking Assessor to perform a site assessment. The results were used by the assessor to calculate the number and type of biodiversity credits and produce a credit report that the landowner will submit with his application for a BioBanking agreement. "]
[null,"Before the completed application could be sent to DECC, the landowner had to develop a draft Management Plan for the BioBank site. The landowner sought expert advice for some management actions that required specific knowledge and experience the landowner did not have. The landowner then used the Biodiversity Pricing Spreadsheet to determine the minimum amount, in perpetuity, that would cover the costs of managing the BioBank site. The Biodiversity Pricing Spreadsheet therefore allowed the landowner to determine the asking price for the biodiversity credits generated by his BioBank land."]
[]
[null,"Mandatory BioBank Site Management Costs"]
[null,"In the first table of the Total Fund Amount calculation (or Part A Mandatory Costs), the landowner lists all management actions he commits to undertake on the site as proposed in the Management Plan. Each \"Item\" in the table should correspond to a different management action. Details of how the management action will be implemented on the BioBank site are recorded in the \"Description\" column of the table. Where there is a need to separate tasks associated with one management action, for example where the frequency varied or several tasks were required to implement a specific management action, it should be recorded as different tasks in separate lines of the table. "]
[null,"In the \"Timing\" column, the landowner records the year of implementation for each management action. Important points to indicate here include if any action is expected to stop after a certain time (e.g. intensive weed control and intensive vertebrate pest control will stop in year 5); if costs are periodic (e.g. Fence maintenance will take place every 20 years) or continue on an annual basis (e.g. reporting fees)."]
[null,"The landowner enters costs of all mandatory site management actions, based on a conservative estimation of materials and labor, into the table. The costs should be calculated in today's dollar value as the table will determine any future increase in costs and provide a discounted current value. In order to provide a conservative estimate the cost of hiring labour should be included even if the landowner is planning to complete any tasks themselves in case the landowner is not able to perform the task in the future. A conservative estimate ensures that the Trust Fund Account will have sufficient money to comply with the agreement regardless of the circumstances but will also increase the price of credits and make the site more attractive to prospective future buyers."]
[null,"One particular management action required for this landowners BioBank site is the erection and maintenance of fences. It is expected to cost the landowner $40,000 after deduction for the neighbour's obligation to pay half. Fence maintenance costs are included in the budget for fence replacement which can be done in phases. The landowner has also insured the fence in case of fire or other unexpected damage and the insurance premium payments are recorded as \"Other Reoccurring Costs\". "]
[null,"Another management action required for this BioBank site is pest control. The landowner will undertake intensive vertebrate pest control between years 1 and 5. The estimated annual cost of the intensive pest management is $10,000. It will be followed by ongoing vertebrate pest control starting in year 6. The annual cost of the ongoing pest management is estimated by the landowner to be $5,000."]
[null,"The landowner understands that if threatened species which qualify for 'species credits' are found on his BioBank site during the survey then additional management may be required. At the time of the site assessment there were no such species found, however some threatened species are present in the neighbouring area and the landowner hopes that with the proposed protection and management of his BioBank site some of these species may find a suitable habitat on his property. The detection of threatened species at a later date will make the landowner eligible to apply for the credits at that later date. The landowner is only required to implement management procedures specific to the biodiversity of his site and as such other BioBank sites may required different management actions."]
[]
[null,"Other Annual Costs to be Considered"]
[null,"The landowner has included all remaining costs related to the ongoing management of the BioBank site under the \"Other Reoccurring Costs\" heading in the second table entitled 'Recommended'. These costs include: rates of $3,000 annually; insurance premiums of $5,000 annually; BioBank site administration costs. The landowner is planning to prepare annual reports himself, but in order to ensure that the Trust Account is calculated conservatively the cost of preparing reports is included in the Total Fund Deposit calculation. A conservative calculation ensures that the Trust Account will have sufficient funds to complete all management if the landowner is no longer able to complete the tasks they previously intended to."]
[null,"The landowner has only included long-term viability cost categories in this table conscious that additional non-essential costs would increase price of their credits. "]
[]
[null,"Calculation of the Total Annual Site Management Cost and Total Fund Deposit "]
[null,"In order to complete the calculation enter the required data in the yellow cells in the tables below. The formula works as follows: the average cost for each line where \"high\" and \"low\" cost levels are entered is calculated. Secondly, the formulae contained in the table distributes these costs between future years depending on the start and end date and specified frequency. Finally, gray cells sum up yearly cost, in today's value, for the first 20 years of the BioBank site operation. The yearly costs will vary depending on the payment frequency (input in the \"Timing\" section of the table) of each cost item included by the landowner. A summary of the total cost for each year is included in the gray \"Cost in today's value\" cells and a summary of what the landowner can expect to input into the Trust Fund Account to cover costs associated with the BioBank site is included in the blue \"Trust Fund Deposit\" cells."]
[null,"The \"Total Fund Deposit\" is the total amount that needs to be paid into the Trust Fund Account at the time of establishment of a BioBank site (after the sale of first credit/s) to cover site management costs in the future. It is calculated by translating yearly costs expressed in today's value (in gray) to their present value equivalent (in blue). The translation of future costs to their present value is calculated by financial discunting using the real interest rate. A discount rate of 3.5% throughout is applied to the \"costs in today's value\" amounts. The consumer Price Index (CPI) rate is included in this calculation to account for inflation."]
[null,"The landowner can include a risk margin on top of the outlined management costs, in this case 10%, to ensure that any unexpected or increases in costs can still be paid for by the Trust Fund Account. This will however increase Total Fund Deposit amount and therefore the credit price."]
[null,"Subtotals of the BioBank site management costs and other reoccurring costs are calculated automatically in the respective tables.  The \"Total Trust Fund Deposit\" is in purple and is displayed excluding and including the risk margin. The landowner's Trust Fund Deposit for this example, to be paid into the Trust Fund Account, as a result of proceeds from the first sale of credits is equal to $818,862 including a 10% risk margin. Once the full Trust Fund Deposit amount is satisfied, there should be sufficient funds for the BioBank site management into the future. This amount should be considered the lowest price (or \"floor\" price) for selling their credits on the market. "]
[null,"Total Fund Deposit amount is incorporated into the BioBanking agreement. BioBanking agreement also includes a Schedule of Payments which is based on the estimated annual total site management costs as displayed in gray line labeled \"Total annual site management cost in today's value\" (in Trust Fund Deposit calculation tables)."]
[]
[null,"Payments from the BioBanking Trust Fund account"]
[null,"Once the landowner enters into a BioBanking agreement and sells their credits, the portion of the profit equal to the approved Total Fund Deposit is invested into their individual BioBank site account. The release of yearly management payments from that account to the landowner depends on a demonstration of compliance with the terms of the BioBanking agreement. This is done by annual reporting on performed management actions to DECC."]
[null,"The amount the BioBank site owner can expect to receive in a given year is based on the projected total site management cost for that year.  This is recorded in the schedule of future payments to the landholder annexure in the BioBanking agreement. Calculated in present dollar value at the time of entering into the agreement, it will be adjusted for inflation experienced during the years leading up to the payment. The payments from the Trust Fund will be made after the Total Fund Deposit amount is satisfied from the sale of credits and annual reports submitted to DECC demonstrate compliance with the BioBanking agreement. Release of the payment is also dependant on funds availability and can be suspended if the funds are low, or increased if there is a surplus in the account."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Real discount rate"]
[null,"BioBank Site Location:",null,null,null,null,null,null,null,"(%)",3.5000000000000003E-2]
[null,"BioBank Site Owner:"]
[null,"Are you registered for GST/do you have an ABN?","Yes"]
[null,"ABN:"]
[null,"(OFFICE USE ONLY: BIMS REFERENCE NUMBER):"]
[null,"(OFFICE USE ONLY: SAP BTF WBS):"]
[]
[]
[]
[]
[]
[null,"Management Actions Cost Items (mandatory)","Description to Estimate Timing & Costs","Timing",null,null,"Cost (per year)",null,null,"Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present value of payments during first 20 yrs","Present value of  payments after 20 yrs","Present value of all payments"]
[null,null,null,"Begin","End (<=20yrs)","Ongoing frequency      (if not annual)","Low","High","Average",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[{"$f":"+B50&\" - \"&C50","v":"Intensive weed control - Expected to occur over the first 5 years"},"Intensive weed control","Expected to occur over the first 5 years",4,5,null,20000,20000,{"$f":"IF(ISERROR(AVERAGE(G50:H50)),0,AVERAGE(G50:H50))","v":20000},{"$f":"IF(OR(ISBLANK($D50),$D50>J$49),0,IF(AND(NOT(ISBLANK($E50)),J$49>$E50),0,IF(MOD((J$49-$D50),MAX($F50,1))=0,$I50,0)))","v":0},{"$f":"IF(OR(ISBLANK($D50),$D50>K$49),0,IF(AND(NOT(ISBLANK($E50)),K$49>$E50),0,IF(MOD((K$49-$D50),MAX($F50,1))=0,$I50,0)))","v":0},0,20000,20000,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(OR(ISBLANK($D50),$D50>AA$49),0,IF(AND(NOT(ISBLANK($E50)),AA$49>$E50),0,IF(MOD((AA$49-$D50),MAX($F50,1))=0,$I50,0)))","v":0},0,0,{"$f":"+SUMPRODUCT(J50:AC50,$J$66:$AC$66)","v":35467.698667331897},{"$f":"(IF(ISBLANK(D50),0,IF(E50,0,((1+$K$37)^MOD($AC$49-D50,MAX(F50,1)))*((1+$K$37)^-$AC$49)*I50/((1+$K$37)^(MAX(F50,1))-1))))*(1+$K$37)","v":0},{"$f":"+AD50+AE50","v":35467.698667331897}]
[{"$f":"+B51&\" - \"&C51","v":"Ongoing weed control - Estimated annual figure to control weeds from year 6 onwards"},"Ongoing weed control","Estimated annual figure to control weeds from year 6 onwards",6,7,null,1000,5000,3000,0,0,0,0,0,3000,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,4966.4214334988319,0,{"$f":"+AD51+AE51","v":4966.4214334988319}]
["Intensive vertebrate pest control - Expected to occur over the first 5 years","Intensive vertebrate pest control","Expected to occur over the first 5 years",1,5,null,50000,null,50000,50000,50000,50000,50000,50000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,233653.96043061127,0,233653.96043061127]
["Ongoing vertebrate pest control - Estimated annual figure to control pests from year 6 onwards","Ongoing vertebrate pest control","Estimated annual figure to control pests from year 6 onwards",6,null,1,null,5000,5000,0,0,0,0,0,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,50183.791044542028,74307.955769540029,124491.74681408206]
["Ecological fire management - Expected to occur every 10 years, starting at year 10","Ecological fire management","Expected to occur every 10 years, starting at year 10",10,null,10,1,2,1.5,0,0,0,0,0,0,0,0,0,1.5,0,0,0,0,0,0,0,0,0,1.5,1.8808299938645898,1.9002335379675612,3.7810635318321513]
["Firebreak / track maintenance - Expected to occur every 4 years, starting at year 4","Firebreak / track maintenance","Expected to occur every 4 years, starting at year 4",4,null,4,null,4000,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,13959.702756370696,14103.717743892796,28063.420500263492]
["Fence erection and maintenance - Fence erection in year 1 and replacement every 20 years, starting at year 20","Fence erection and maintenance","Fence erection in year 1 and replacement every 20 years, starting at year 20",1,null,20,40000,null,40000,40000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,40000,40412.659180601484,80412.659180601477]
["Other Recurring BioBank Site Management Cost Items - Description to Estimate Timing & Costs","Other Recurring BioBank Site Management Cost Items",{"$f":"C48","v":"Description to Estimate Timing & Costs"},{"$f":"D48","v":"Timing"},null,null,{"$f":"G48","v":"Cost (per year)"}]
["Annual management report compliance fee - Annual fee on submission of the report. Payment made directly from the BioBanking Trust Fund to DECC.","Annual management report compliance fee","Annual fee on submission of the report. Payment made directly from the BioBanking Trust Fund to DECC.",1,null,null,1225,1225,{"$f":"IF(ISERROR(AVERAGE(G58:H58)),0,AVERAGE(G58:H58))","v":1225},{"$f":"IF(OR(ISBLANK($D58),$D58>J$49),0,IF(AND(NOT(ISBLANK($E58)),J$49>$E58),0,IF(MOD((J$49-$D58),MAX($F58,1))=0,$I58,0)))","v":1225},1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,{"$f":"+SUMPRODUCT(J58:AC58,$J$66:$AC$66)","v":18019.550836462771},{"$f":"(IF(ISBLANK(D58),0,IF(E58,0,((1+$K$37)^MOD($AC$49-D58,MAX(F58,1)))*((1+$K$37)^-$AC$49)*I58/((1+$K$37)^(MAX(F58,1))-1))))*(1+$K$37)","v":18205.449163537305},{"$f":"+AD58+AE58","v":36225.000000000073}]
["Rates (e.g. Council) - Annual amount ","Rates (e.g. Council)","Annual amount ",1,null,null,3000,3000,{"$f":"IF(ISERROR(AVERAGE(G59:H59)),0,AVERAGE(G59:H59))","v":3000},{"$f":"IF(OR(ISBLANK($D59),$D59>J$49),0,IF(AND(NOT(ISBLANK($E59)),J$49>$E59),0,IF(MOD((J$49-$D59),MAX($F59,1))=0,$I59,0)))","v":3000},3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,{"$f":"+SUMPRODUCT(J59:AC59,$J$66:$AC$66)","v":44129.512252561894},{"$f":"(IF(ISBLANK(D59),0,IF(E59,0,((1+$K$37)^MOD($AC$49-D59,MAX(F59,1)))*((1+$K$37)^-$AC$49)*I59/((1+$K$37)^(MAX(F59,1))-1))))*(1+$K$37)","v":44584.77346172402},{"$f":"+AD59+AE59","v":88714.285714285914}]
["Insurance (e.g. fences, public liability) - Annual amount ","Insurance (e.g. fences, public liability)","Annual amount ",1,null,null,5000,5000,{"$f":"IF(ISERROR(AVERAGE(G60:H60)),0,AVERAGE(G60:H60))","v":5000},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,{"$f":"+SUMPRODUCT(J60:AC60,$J$66:$AC$66)","v":73549.187087603146},{"$f":"(IF(ISBLANK(D60),0,IF(E60,0,((1+$K$37)^MOD($AC$49-D60,MAX(F60,1)))*((1+$K$37)^-$AC$49)*I60/((1+$K$37)^(MAX(F60,1))-1))))*(1+$K$37)","v":74307.955769540029},{"$f":"+AD60+AE60","v":147857.14285714319}]
["Business management/ Administration costs - Estimated business management costs associated with biobank site","Business management/ Administration costs","Estimated business management costs associated with biobank site",1,null,null,5000,5000,{"$f":"IF(ISERROR(AVERAGE(G61:H61)),0,AVERAGE(G61:H61))","v":5000},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,{"$f":"+SUMPRODUCT(J61:AC61,$J$66:$AC$66)","v":73549.187087603146},{"$f":"(IF(ISBLANK(D61),0,IF(E61,0,((1+$K$37)^MOD($AC$49-D61,MAX(F61,1)))*((1+$K$37)^-$AC$49)*I61/((1+$K$37)^(MAX(F61,1))-1))))*(1+$K$37)","v":74307.955769540029},{"$f":"+AD61+AE61","v":147857.14285714319}]
["Annual monitoring & reporting requirements per biobanking agreement - Annual expected landowner time to complete annual reporting requirements","Annual monitoring & reporting requirements per biobanking agreement","Annual expected landowner time to complete annual reporting requirements",1,null,null,500,500,{"$f":"IF(ISERROR(AVERAGE(G62:H62)),0,AVERAGE(G62:H62))","v":500},500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,{"$f":"+SUMPRODUCT(J62:AC62,$J$66:$AC$66)","v":7354.9187087603141},{"$f":"(IF(ISBLANK(D62),0,IF(E62,0,((1+$K$37)^MOD($AC$49-D62,MAX(F62,1)))*((1+$K$37)^-$AC$49)*I62/((1+$K$37)^(MAX(F62,1))-1))))*(1+$K$37)","v":7430.795576954004},{"$f":"+AD62+AE62","v":14785.714285714319}]
[null,null,null,null,null,null,null,null,"BioBank site management cost in today's value",{"$f":"SUM(J58:J62)+SUM(J50:J56)","v":104725},64725,64725,88725,84725,22725,22725,23725,19725,19726.5,19725,23725,19725,19725,19725,23725,19725,19725,19725,23726.5,null,null,"Grand Total"]
[null,null,null,null,null,null,null,null,"Present Value (PV) of the biobank site management cost",{"$f":"J63*(1+$K$37)^-(J49-1)","v":104725},62536.231884057976,60421.480081215435,80024.866560395283,73832.942741761552,19133.84021685996,18486.802141893684,18647.635542223608,14979.392946365542,14473.944022898424,13983.423600425256,16250.337058226422,13053.675558753068,12612.246916669636,12185.745813207375,14161.229926873499,11375.524108574184,10990.844549347037,10619.173477629989,12341.473987961914,{"$f":"SUM(AD58:AD62)+SUM(AD50:AD56)","v":594835.8111353399},{"$f":"SUM(AE58:AE62)+SUM(AE49:AE56)","v":347663.16266886762},{"$f":"+AD64+AE64","v":942498.97380420752}]
[]
[null,null,null,null,null,null,null,"Discount Factors",null,{"$f":"+(1+$K$37)^-(J49-1)","v":1},{"$f":"+(1+$K$37)^-(K49-1)","v":0.96618357487922713},0.93351070036640305,0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217,0.68494571372924851,0.66178329828912896,0.63940415293635666,0.61778179027667302,0.59689061862480497,0.57670591171478747,0.55720377943457733,0.53836113955031628,0.52015569038677911]
[]
[]
[null,null,null,null,null,null,null,null,null,"Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present value of payments during first 20 yrs","Present value of  payments after 20 yrs","Present value of all payments"]
[null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,null,"Annual BioBank site management costs in today's values",{"$f":"J63","v":104725},{"$f":"K63","v":64725},64725,88725,84725,22725,22725,23725,19725,{"$f":"S63","v":19726.5},19725,23725,19725,19725,19725,23725,19725,19725,19725,23726.5,{"$f":"+SUM(AD47:AD62)","v":594835.8111353399},{"$f":"AE64","v":347663.16266886762},{"$f":"+AD71+AE71","v":942498.97380420752}]
[null,null,null,null,null,null,null,null,"Gross Proposed Annual Payment Schedule from BioBank Trust Fund (including GST if applicable)",{"$f":"IF($C$39=\"Yes\",(J71-J58)*1.1+J58,J71)","v":115075.00000000001},{"$f":"IF($C$39=\"Yes\",(K71-K58)*1.1+K58,K71)","v":71075},71075,97475.000000000015,93075.000000000015,24875.000000000004,24875.000000000004,25975.000000000004,21575,21576.65,21575,25975.000000000004,21575,21575,21575,25975.000000000004,21575,21575,21575,25976.65,652517.43716522772,380608.93401940068,1033126.3711846283]
[null,null,null,null,null,null,null,null,"Comprising:"]
[null,null,null,null,null,null,null,null,"Proposed Payment Schedule from BTF to Site Landowner for management action costs",{"$f":"+J71-J58","v":103500},{"$f":"+K71-K58","v":63500},63500,87500,83500,21500,21500,22500,18500,18501.5,18500,22500,18500,18500,18500,22500,18500,18500,18500,22501.5,576816.26029887714,329457.71350533032,906273.9738042074]
[null,null,null,null,null,null,null,null,"Proposed Payment Schedule from BTF to DECC for annual compliance",{"$f":"J58","v":1225},{"$f":"K58","v":1225},1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,18019.550836462771,18205.449163537305,36225.000000000073]
[null,"Yes",null,null,null,null,null,null,"GST (to be remitted to the ATO by Site Landowner)",{"$f":"IF($C$39=\"Yes\",(J71-J58)*0.1,0)","v":10350},{"$f":"IF($C$39=\"Yes\",(K71-K58)*0.1,0)","v":6350},6350,8750,8350,2150,2150,2250,1850,1850.15,1850,2250,1850,1850,1850,2250,1850,1850,1850,2250.15,57681.626029887717,32945.771350533032,90627.397380420749]
[]
[null,null,null,null,null,null,null,null,"GST (Input tax credit to be claimed from the ATO by BTF)",{"$f":"-J76","v":-10350},{"$f":"-K76","v":-6350},-6350,-8750,-8350,-2150,-2150,-2250,-1850,-1850.15,-1850,-2250,-1850,-1850,-1850,-2250,-1850,-1850,-1850,-2250.15,-57681.626029887717,-32945.771350533032,-90627.397380420749]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Part B - Calculating Biodiversity Credits Price"]
[]
[]
[null,"BioBank Site Description",null,"Example"]
[null,"Area of the proposed BioBank site (ha)",null,200,null,"In the above section, the landowner recorded the area of the proposed BioBank site at 200ha and expected the biodiversity credits to be issued after entering into the BioBanking Agreement (the number of biodiversity credits is obtained from the BioBanking Assessor in the Credit Calculator Report). This information will assist in the calculation of a credit price per ha or per credit basis."]
[null,"No. of biodiversity credits issued",null,450]
[]
["PART B","Opportunity Cost to Landholder (optional)                                     ",null,"Example"]
[null,"Market Value of land ($ per ha)",null,10000]
[null,"Total market value of land ($ per ha x area)",null,{"$f":"D97*D93","v":2000000}]
[null,"Stamp Duty (Not applicable if property already owned)",null,0,null,"Part B Costs"]
[null,"Total opportunity cost to landowner ",null,{"$f":"D98+D99","v":2000000},null,"The landowner may account for one-time costs associated with entering into a BioBanking agreement as well as opportunity costs. Including opportunity costs in the credit price is optional and may decrease the competitiveness of the price on the open market however, it allows the landowner to recover land value and/or potential decrease in the future release land (estimated to be $10,000 per ha or $2M for entire BioBank site area of 200ha) and to include a desired profit margin of 20%."]
[]
[null,"Costs of Enter into a BioBanking Agreement",null,"Example"]
[null,"Site assessment (incl. vegetation mapping, flora & fauna surveys)",null,4000]
[null,"Preparation of a Management Plan",null,1500]
[null,"BioBanking Agreement application fee",null,600]
[null,"Legal Fees",null,500]
[null,"Other (eg annual Council/RLPB/Dept. Lands Rates for year(s) prior to expected first sale of credits)",null,1000]
[null,"Total costs to enter into a BioBanking Agreement (excluding interest repayments)",null,{"$f":"SUM(D103:D107)","v":7600},null,"The landowner engaged an accredited BioBanking Assessor to perform site assessment and credit calculation of the site at an agreed price of $4,000. The landowner used expert advice in prepairing the Management Plan, where he did not have sufficient knowledge, with costs amounting to $1,500. Finally, the landowner included the application fee of $600 for the Credit Cost Calculation. "]
[null,"Interest repayments (if funds borrowed as an investment) at 10% ",null,{"$f":"D108*0.1","v":760}]
[null,"Total costs to enter into a BioBanking Agreement (including interest incurred)",null,{"$f":"SUM(D108:D109)","v":8360}]
[]
[" PART A","\n Trust Fund Deposit (from the Total Fund Deposit worksheet)",null,"Example"]
[null,"Total Fund Deposit for BioBank site management (mandatory)",null,{"$f":"+AF71","v":942498.97380420752}]
[null,"Total ongoing BioBank site management costs (including risk margin)",null,{"$f":"D113","v":942498.97380420752}]
[null,null,null,null,null,"If the landowner sought legal or financial advice related to entering into a BioBanking agreement, the cost of this advice would be included in this section. It is noted that for this example not all cost lines in the Part B table were applicable and were therefore not used."]
[" TOTAL COSTS","Total Costs",null,"Example"]
[null,"Trust Fund Deposit ",null,{"$f":"D114","v":942498.97380420752}]
[null,"Total cost to enter into a biobanking Agreement",null,{"$f":"D110","v":8360}]
[null,"Total opportunity cost to landowner",null,{"$f":"D100","v":2000000},null,"As the landowner used borrowed funds to pay for the costs associated with the preparation of the application for a BioBanking agreement the cost must also be included in this section. In this example the funds were borrowed at 10% interest rate."]
[null,"Total cost ",null,{"$f":"D117+D118+D119","v":2950858.9738042075}]
[null,"Profit margin (enter %) ",null,0.1]
[null,"Profit margin ($) ",null,{"$f":"D121*D120","v":295085.89738042076},null,"Part A costs"]
[null,"Total price of credits (profit margin included)",null,{"$f":"SUM(D120,D122)","v":3245944.8711846285},null,"This section is populated automatically using outcomes of the calculations of the Total Fund Deposit in the above tables. Therefore, the cost of the ongoing biobank site management is included in the credit price calculation. "]
[]
[]
["CREDIT PRICE","Potential credit price "]
[]
[null,"Trust Fund Deposit amount per credit ",null,{"$f":"D117/D94","v":2094.4421640093501},null,"Total Credit Price (Part A + Part B)"]
[]
[null,"Cost to enter into a biokanking agreement per credit",null,{"$f":"D118/D94","v":18.577777777777779},null,"The total credit price reflects all the costs and returns the landowner included in their calculations. It helps to determine what is a desired minimum asking price for the biodiversity credits established by a proposed BioBank site on their property and managing it into the future. The total amount required for this site is $3,201,246 (including risk margin).  When this amount is divided by the number of hectares, the landowner can estimate total cost of establishing a BioBank site on a per hectare basis. "]
[null,"Cost to enter into a biokanking agreement per credit",null,{"$f":"D119/D94","v":4444.4444444444443}]
[null,"Profit margin per credit",null,{"$f":"D122/D94","v":655.74643862315725}]
[null,"Individual credit price   (total price / number of credits)",null,{"$f":"D123/D94","v":7213.2108248547302}]
[]
[null,"Proportion of biodiversity credits likely to be sold (enter %)",null,0.75]
[null,"Total amount based on the % of credits estimated to be sold ",null,{"$f":"D123*D135","v":2434458.6533884713},null,"This table allows the landowner to see what his minimum asking price per credit should be, in this example the individual credit price is $7,114 (including risk margin). Another useful function is estimating what percentage of the credits they are likely to sell on the market and therefore adjusting the per credit price to recover the full cost of establishing a BioBank site. For example the landowner can see how much they would need to charge per credit if they were only able to sell 75% of the total credits held. The asking price in this situation should be at least $9,485 per credit (including risk margin). And finally, the landowner can determine the amount of return, which is $5,348 per credit (including risk margin). "]
[null,"Individual credit price   (Price of credit calculated on the total amount of deposit required and the % of credits estimated to be sold i.e. Where it is assumed that less than 100% of credits will be sold, the individual credit price will need to be higher in order to recoup costs)",null,{"$f":"D123/(D94*D135)","v":9617.614433139639}]
[]
[]
[]
[]
[null,null,null,null,null,"NOTE: This table should be used as a checklist to guide the landholder’s credit price consideration and help inform their decision making when entering into a BioBanking Agreement. "]

{"sheet":"CP_EG","index":6,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":true,"merged":[[37,1,47,1],[28,1,35,1],[1,1,1,7],[8,1,23,1],[25,1,26,1],[4,1,6,1]]}
[]
[null,"Credit Pricing worksheet"]
[]
[]
[null,"SITE","Biobank site description","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
[null,null,"Area of the proposed biobank site (ha)",200]
[null,null,"No. of biodiversity credits issued",450,1,1,1,1]
[]
[null,"PART B","Costs to enter into a biobanking agreement","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
[null,null,"Site assessment and Biobanking Agreement Credit Report preparation ",4000]
[null,null,"Preparation of management actions",1500]
[null,null,"Biobanking agreement application fee",612,612,612,612,612]
[null,null,"Legal fees",500]
[null,null,"Other ",1000]
[null,null,"Total cost to enter into a biobanking agreement (excluding interest)",{"$f":"SUM(D10:D14)","v":7612},{"$f":"SUM(E10:E14)","v":612},{"$f":"SUM(F10:F14)","v":612},{"$f":"SUM(G10:G14)","v":612},{"$f":"SUM(H10:H14)","v":612}]
[null,null,"Interest repayments (enter %) per annum",0.1]
[null,null,"Interest repayments (if funds borrowed as an investment)",{"$f":"D15*D16","v":761.2},{"$f":"E15*E16","v":0},{"$f":"F15*F16","v":0},{"$f":"G15*G16","v":0},{"$f":"H15*H16","v":0}]
[null,null,"Total cost to enter into a biobanking agreement (including interest incurred)",{"$f":"SUM(D15+D17)","v":8373.2000000000007},{"$f":"SUM(E15+E17)","v":612},{"$f":"SUM(F15+F17)","v":612},{"$f":"SUM(G15+G17)","v":612},{"$f":"SUM(H15+H17)","v":612}]
[]
[null,null,"Opportunity cost to landowner (optional)                                     ","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
[null,null,"Market value of land ($ per ha)",10000]
[null,null,"Total market value of land ($ per ha x area)",{"$f":"D21*D6","v":2000000},{"$f":"E21*E6","v":0},{"$f":"F21*F6","v":0},{"$f":"G21*G6","v":0},{"$f":"H21*H6","v":0}]
[null,null,"Stamp duty (not applicable if property already owned)",0]
[null,null,"Total opportunity cost to landowner",{"$f":"D22+D23","v":2000000},{"$f":"E22+E23","v":0},{"$f":"F22+F23","v":0},{"$f":"G22+G23","v":0},{"$f":"H22+H23","v":0}]
[]
[null,"PART A","Total Fund Deposit ","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5",null,"From previous worksheet"]
[null,null,"Total Fund Deposit",722864.25099943287,null,null,null,null,null,{"$f":"+'TFD Calculator'!$AE$35","v":57566.249999999978}]
[]
[null,"TOTAL","Total costs","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
[null,null,"Total Fund Deposit ",{"$f":"D27","v":722864.25099943287},{"$f":"E27","v":0},{"$f":"F27","v":0},{"$f":"G27","v":0},{"$f":"H27","v":0}]
[null,null,"Total cost to enter into a biobanking agreement",{"$f":"D18","v":8373.2000000000007},{"$f":"E18","v":612},{"$f":"F18","v":612},{"$f":"G18","v":612},{"$f":"H18","v":612}]
[null,null,"Total opportunity cost to landowner",{"$f":"D24","v":2000000},{"$f":"E24","v":0},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"H24","v":0}]
[null,null,"Total cost",{"$f":"D30+D31+D32","v":2731237.4509994327},{"$f":"E30+E31+E32","v":612},{"$f":"F30+F31+F32","v":612},{"$f":"G30+G31+G32","v":612},{"$f":"H30+H31+H32","v":612}]
[null,null,"Profit margin (enter %)",0.1]
[null,null,"Profit or risk margin ($)",{"$f":"D33*D34","v":273123.74509994331},{"$f":"E33*E34","v":0},{"$f":"F33*F34","v":0},{"$f":"G33*G34","v":0},{"$f":"H33*H34","v":0}]
[null,null,"Desired total price of credits (including profit or risk margin)",{"$f":"D33+D35","v":3004361.1960993758},{"$f":"E33+E35","v":612},{"$f":"F33+F35","v":612},{"$f":"G33+G35","v":612},{"$f":"H33+H35","v":612}]
[]
[null,"CREDIT PRICE","Potential credit price","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
[null,null,"Trust Fund Deposit amount per credit ",{"$f":"D30/D$7","v":1606.365002220962},0,0,0,0]
[null,null,"Cost to enter into a biokanking agreement per credit",18.607111111111113,612,612,612,612]
[null,null,"Opportunity cost to landholder per credit ",4444.4444444444443,0,0,0,0]
[null,null,"Profit margin per credit",{"$f":"D35/D$7","v":606.94165577765182},0,0,0,0]
[null,null,"Individual credit price (total price / number of credits)",6676.3582135541683,612,612,612,612]
[]
[null,null,"Proportion of biodiversity credits likely to be sold (enter %)",0.75,1,1,1,1]
[null,null,"Total amount to be received given the % of credits likely to be sold ",{"$f":"D36*D45","v":2253270.8970745318},{"$f":"E36*E45","v":612},{"$f":"F36*F45","v":612},{"$f":"G36*G45","v":612},{"$f":"H36*H45","v":612}]
[null,null,"Individual credit price to acheive the desired total price of credits given the % likely to be sold   ",{"$f":"D36/(D45*D7)","v":8901.8109514055577},{"$f":"E36/(E45*E7)","v":612},{"$f":"F36/(F45*F7)","v":612},{"$f":"G36/(G45*G7)","v":612},{"$f":"H36/(H45*H7)","v":612}]
[null,null,"Individual credit price to achieve 80% of the Total Fund Deposit given the % likely to be sold",{"$f":"D36/(0.8*D7)","v":8345.4477669427106},{"$f":"E36/(0.8*E7)","v":765},{"$f":"F36/(0.8*F7)","v":765},{"$f":"G36/(0.8*G7)","v":765},{"$f":"H36/(0.8*H7)","v":765}]

{"sheet":"TFD_EG","index":7,"n_rows":113,"n_cols":29,"rows_kept":113,"cut":false,"hidden":true,"merged":[[42,1,42,5],[43,1,43,5],[5,24,6,24],[7,14,7,23],[40,1,40,5],[39,1,39,5],[41,1,41,5],[8,14,8,23],[5,2,5,4],[6,2,6,4],[16,1,17,1],[16,6,16,25],[12,14,12,23],[13,14,13,23],[13,6,13,7],[12,6,12,7],[16,28,17,28],[37,28,38,28],[37,27,38,27],[37,6,37,25],[16,27,17,27],[25,6,25,25],[37,26,38,26],[16,26,17,26],[3,14,3,25],[16,2,16,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[16,5,17,5],[10,14,10,23],[7,2,7,4],[11,14,11,23]]}
[]
[null,"Total Fund Deposit worksheet (Part A costs)"]
[]
[null,"This template should be used for estimating the Total Fund Deposit and preparation of the Payment Schedule "]
[]
[null,"Biobank site location"]
[null,"Biobank site owner"]
[null,"Are you registered for GST/do you have an ABN?","Yes"]
[null,"ABN",null,null,null,null,null,"row num"]
[null,"(OFFICE USE ONLY: BIMS REFERENCE NUMBER):",null,null,null,null,null,"mand count"]
[null,"(OFFICE USE ONLY: SAP BTF WBS):"]
[]
[null,null,null,null,null,null,"Real discount rate"]
[null,null,null,null,null,null,3.5000000000000003E-2]
[]
[]
[null,"Management action costs","Timing",null,null,"Estimated annual cost   ($)","Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present value of payments for first 20 yrs","Present value of  payments after 20 yrs","Present value of all payments"]
[null,null,"Start year","End year","Frequency ",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Intensive weed control - Expected to occur over the first 5 years",4,5,null,20000,{"$f":"IF(OR(ISBLANK($C19),$C19>G$18),0,IF(AND(NOT(ISBLANK($D19)),G$18>$D19),0,IF(MOD((G$18-$C19),MAX($E19,1))=0,$F19,0)))","v":0},0,0,20000,20000,0,0,0,0,0,{"$f":"IF(OR(ISBLANK($C19),$C19>Q$18),0,IF(AND(NOT(ISBLANK($D19)),Q$18>$D19),0,IF(MOD((Q$18-$C19),MAX($E19,1))=0,$F19,0)))","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+SUMPRODUCT(G19:Z19,$G$35:$Z$35)","v":35467.698667331897},{"$f":"(IF(ISBLANK(C19),0,IF(D19,0,((1+$G$14)^MOD($Z$18-C19,MAX(E19,1)))*((1+$G$14)^-$Z$18)*F19/((1+$G$14)^(MAX(E19,1))-1))))*(1+$G$14)","v":0},{"$f":"+AA19+AB19","v":35467.698667331897}]
[null,"Ongoing weed control - Estimated annual figure to control weeds from year 6 onwards",6,7,null,3000,0,0,0,0,0,3000,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,4966.4214334988319,0,4966.4214334988319]
[null,"Intensive vertebrate pest control - Expected to occur over the first 5 years",1,5,null,50000,50000,50000,50000,50000,50000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,233653.96043061127,0,233653.96043061127]
[null,"Ongoing vertebrate pest control - Estimated annual figure to control pests from year 6 onwards",6,null,1,5000,0,0,0,0,0,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,50183.791044542028,74307.955769540029,124491.74681408206]
[null,"Ecological fire management - Expected to occur every 10 years, starting at year 10",10,null,10,1.5,0,0,0,0,0,0,0,0,0,1.5,0,0,0,0,0,0,0,0,0,1.5,1.8808299938645898,1.9002335379675612,3.7810635318321513]
[null,"Firebreak / track maintenance - Expected to occur every 4 years, starting at year 4",4,null,4,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,13959.702756370696,14103.717743892796,28063.420500263492]
[null,"Fence erection and maintenance - Fence erection in year 1 and replacement every 20 years, starting at year 20",1,null,20,40000,40000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,40000,40412.659180601484,80412.659180601477]
[null,"Other recurring costs"]
[null,"Annual management report compliance fee",1,null,1,1225,{"$f":"IF(OR(ISBLANK($C27),$C27>G$18),0,IF(AND(NOT(ISBLANK($D27)),G$18>$D27),0,IF(MOD((G$18-$C27),MAX($E27,1))=0,$F27,0)))","v":1225},1225,1225,1225,1225,1225,1225,1225,1225,1225,{"$f":"IF(OR(ISBLANK($C27),$C27>Q$18),0,IF(AND(NOT(ISBLANK($D27)),Q$18>$D27),0,IF(MOD((Q$18-$C27),MAX($E27,1))=0,$F27,0)))","v":1225},1225,1225,1225,1225,1225,1225,1225,1225,1225,{"$f":"+SUMPRODUCT(G27:Z27,$G$35:$Z$35)","v":18019.550836462771},{"$f":"(IF(ISBLANK(C27),0,IF(D27,0,((1+$G$14)^MOD($Z$18-C27,MAX(E27,1)))*((1+$G$14)^-$Z$18)*F27/((1+$G$14)^(MAX(E27,1))-1))))*(1+$G$14)","v":18205.449163537305},{"$f":"+AA27+AB27","v":36225.000000000073}]
[null,"Rates (e.g. Council) - Annual amount ",1,null,null,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,{"$f":"+SUMPRODUCT(G28:Z28,$G$35:$Z$35)","v":44129.512252561894},{"$f":"(IF(ISBLANK(C28),0,IF(D28,0,((1+$G$14)^MOD($Z$18-C28,MAX(E28,1)))*((1+$G$14)^-$Z$18)*F28/((1+$G$14)^(MAX(E28,1))-1))))*(1+$G$14)","v":44584.77346172402},{"$f":"+AA28+AB28","v":88714.285714285914}]
[null,"Insurance (e.g. fences, public liability) - Annual amount ",1,null,null,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,{"$f":"+SUMPRODUCT(G29:Z29,$G$35:$Z$35)","v":73549.187087603146},{"$f":"(IF(ISBLANK(C29),0,IF(D29,0,((1+$G$14)^MOD($Z$18-C29,MAX(E29,1)))*((1+$G$14)^-$Z$18)*F29/((1+$G$14)^(MAX(E29,1))-1))))*(1+$G$14)","v":74307.955769540029},{"$f":"+AA29+AB29","v":147857.14285714319}]
[null,"Business management/ Administration costs - Estimated business management costs associated with biobank site",1,null,null,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,{"$f":"+SUMPRODUCT(G30:Z30,$G$35:$Z$35)","v":73549.187087603146},{"$f":"(IF(ISBLANK(C30),0,IF(D30,0,((1+$G$14)^MOD($Z$18-C30,MAX(E30,1)))*((1+$G$14)^-$Z$18)*F30/((1+$G$14)^(MAX(E30,1))-1))))*(1+$G$14)","v":74307.955769540029},{"$f":"+AA30+AB30","v":147857.14285714319}]
[null,"Annual monitoring & reporting requirements per biobanking agreement - Annual expected landowner time to complete annual reporting requirements",1,null,null,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,{"$f":"+SUMPRODUCT(G31:Z31,$G$35:$Z$35)","v":7354.9187087603141},{"$f":"(IF(ISBLANK(C31),0,IF(D31,0,((1+$G$14)^MOD($Z$18-C31,MAX(E31,1)))*((1+$G$14)^-$Z$18)*F31/((1+$G$14)^(MAX(E31,1))-1))))*(1+$G$14)","v":7430.795576954004},{"$f":"+AA31+AB31","v":14785.714285714319}]
[null,null,null,null,null,"Biobank site management cost in today's value",{"$f":"SUM(G27:G31)+SUM(G19:G25)","v":104725},64725,64725,88725,84725,22725,22725,23725,19725,19726.5,19725,23725,19725,19725,19725,23725,19725,19725,19725,23726.5,null,null,"Total Trust Fund Deposit"]
[null,null,null,null,null,"Present Value (PV) of the biobank site management cost",{"$f":"G32*(1+$G$14)^-(G18-1)","v":104725},62536.231884057976,60421.480081215435,80024.866560395283,73832.942741761552,19133.84021685996,18486.802141893684,18647.635542223608,14979.392946365542,14473.944022898424,13983.423600425256,16250.337058226422,13053.675558753068,12612.246916669636,12185.745813207375,14161.229926873499,11375.524108574184,10990.844549347037,10619.173477629989,12341.473987961914,{"$f":"SUM(AA27:AA31)+SUM(AA19:AA25)","v":594835.8111353399},{"$f":"SUM(AB27:AB31)+SUM(AB19:AB25)","v":347663.16266886762},{"$f":"+AA33+AB33","v":942498.97380420752}]
[]
[null,null,null,null,"Discount factors",null,{"$f":"+(1+$G$14)^-(G18-1)","v":1},0.96618357487922713,0.93351070036640305,0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217,0.68494571372924851,0.66178329828912896,0.63940415293635666,0.61778179027667302,0.59689061862480497,0.57670591171478747,0.55720377943457733,0.53836113955031628,0.52015569038677911]
[]
[]
[null,null,null,null,null,null,"Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Present value of payments during first 20 yrs","Present value of  payments after 20 yrs","Present value of all payments"]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,"Annual biobank site management costs in today's values",null,null,null,null,{"$f":"G32","v":104725},64725,64725,88725,84725,22725,22725,23725,19725,19726.5,19725,23725,19725,19725,19725,23725,19725,19725,19725,23726.5,{"$f":"AA33","v":594835.8111353399},{"$f":"AB33","v":347663.16266886762},{"$f":"AC33","v":942498.97380420752}]
[null,"Proposed  payment schedule for annual compliance",null,null,null,null,{"$f":"G27","v":1225},1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,1225,18019.550836462771,18205.449163537305,36225.000000000073]
[null,{"$f":"\"Total amount payable to landowner\"&IF($C$8=\"yes\", \" (excluding GST)\",\"\")","v":"Total amount payable to landowner (excluding GST)"},null,null,null,null,{"$f":"G40-G41","v":103500},63500,63500,87500,83500,21500,21500,22500,18500,18501.5,18500,22500,18500,18500,18500,22500,18500,18500,18500,22501.5,576816.26029887714,329457.71350533032,906273.9738042074]
[null,{"$f":"IF($C$8=\"yes\",\"GST payable to landowner\",\"\")","v":"GST payable to landowner"},null,null,null,null,{"$f":"IF($C$8=\"Yes\",G42*0.1,\"\")","v":10350},6350,6350,8750,8350,2150,2150,2250,1850,1850.15,1850,2250,1850,1850,1850,2250,1850,1850,1850,2250.15,57681.626029887717,32945.771350533032,90627.397380420749]
[null,{"$f":"IF($C$8=\"yes\",\"Total amount payable to landowner (including GST)\",\"\")","v":"Total amount payable to landowner (including GST)"},null,null,null,null,{"$f":"IF($C$8=\"Yes\",G42*1.1,\"\")","v":113850.00000000001},69850,69850,96250.000000000015,91850.000000000015,23650.000000000004,23650.000000000004,24750.000000000004,20350,20351.650000000001,20350,24750.000000000004,20350,20350,20350,24750.000000000004,20350,20350,20350,24751.65,634497.88632876496,362403.48485586338,996901.37118462822]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Data for spreadsheet function use only"]
[]
[null,null,1]
[null,null,{"$f":"+C94+1","v":2},null,null,null,"Mand","Rec"]
[null,null,3,null,null,"cell",{"$f":"+ADDRESS(18+$G$98,1)","v":"$A$25"},{"$f":"+ADDRESS($G$98+$H$98+20,1)","v":"$A$31"}]
[null,null,4,null,null,"row num",{"$f":"RIGHT($G$96,LEN($G$96)-FIND(\"$\",$G$96,3))","v":"25"},{"$f":"RIGHT($H$96,LEN($H$96)-FIND(\"$\",$H$96,3))","v":"31"}]
[null,null,5,null,null,"mand count",{"$f":"+COUNT(G19:G25)","v":7},{"$f":"+COUNT(G28:G31)","v":4}]
[null,null,6]
[null,null,7]
[null,null,8,null,null,"Yes"]
[null,null,9,null,null,"No"]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]

{"sheet":"Explanation of PV","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}