{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Model","RFA Codes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"Model","index":0,"n_rows":47,"n_cols":28,"rows_kept":47,"cut":false,"hidden":false,"merged":[[23,1,23,27]]}
["FPP Fee Estimator - 1 July 2022 to 30 June 2023"]
[null,null,null,null,null,null,null,null,"myDAS: D22-242098"]
["Instructions"]
["Input total areas (hectares) into the RFA Group x Operation Prescription table below"]
["See sheet RFA Codes to determine what communities fall into the RFA groups"]
["The Operation Prescriptions are the standard ones utilised on the FPP cover page"]
["The total area included in the table should equal the Total Area of Operation on the FPP cover page"]
[]
["FPP N0:",null,null,null,null,null,null,null,"Input Cell"]
[]
["Estimate Prepared By:"]
[]
["Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 new codes added Jan 2021"]
["One fee unit",1.7]
[]
[null,"Fee units/ha",null,"Minimum fee units/plan"]
["Ranking 0",0,null,52]
["Ranking 1",6,null,52]
["Ranking 2",16,null,77]
["Ranking 3",25,null,129]
["Ranking 4",30,null,513]
[]
["FPP Hectares"]
[null,"Operation Prescription from FPP cover page"]
["RFA Group","AGR","ARN","CF-CLR","CF-HP","CF-NF","CF-SP","OVS","PAR","PLA-HP","PLA-SP","Q","RC","RES","SAL","SED","SEL","GRP","SIT","SLF","SLR","SWF","SWS","THN","USR","NVR","DRN","CF-GS"]
["Non forest"]
["Plantation",null,null,null,null,null,null,null,54.9]
["Native Forest"]
[]
["Total Area"," (Should equal Total Area of Operation from FPP Cover Page)",null,null,null,null,null,null,{"$f":"SUM(B26:AB28)","v":54.9},"Ha"]
[]
["Ranking"]
["Non forest",2,1,0,2,3,2,2,1,2,2,3,3,0,2,3,2,2,2,2,2,2,3,2,2,0,1,3]
["Plantation",1,1,2,2,2,2,1,1,2,2,3,3,0,1,1,1,1,1,1,1,1,1,1,2,0,1,2]
["Native Forest",3,2,4,4,3,4,3,2,3,3,3,3,0,2,3,2,2,2,2,2,2,3,2,2,0,3,3]
[]
["Costs","Area (ha)",null,"Cost"]
["Ranking 0",{"$f":"D26+SUM(N26:N28)+SUM(Z26:Z28)","v":0},null,{"$f":"CEILING(B38,1)*B17*$B$14","v":0}]
["Ranking 1",{"$f":"B27+C26+C27+H27+I27+I26+SUM(O27:X27)+AA26+AA27","v":54.9},null,{"$f":"CEILING(B39,1)*B18*$B$14","v":561}]
["Ranking 2",{"$f":"B26+C28+SUM(D27:G27)+E26+G26+H26+I28+SUM(J26:K27)+O26+O28+SUM(Q26:V26)+SUM(Q28:V28)+X26+X28+SUM(Y26:Y28)+AB27","v":0},null,{"$f":"CEILING(B40,1)*B19*$B$14","v":0}]
["Ranking 3",{"$f":"B28+F26+F28+H28+J28+K28+SUM(L26:M28)+P26+P28+W26+W28+AA28+AB26+AB28","v":0},null,{"$f":"CEILING(B41,1)*B20*$B$14","v":0}]
["Ranking 4",{"$f":"D28+E28+G28","v":0},null,{"$f":"CEILING(B42,1)*B21*$B$14","v":0}]
["Total ",{"$f":"SUM(B38:B42)","v":54.9},null,{"$f":"SUM(D38:D42)","v":561}]
[]
["Minimum fee",null,null,{"$f":"IF(B42>0,D21*B14,IF(B41>0,D20*B14,IF(B40>0,D19*B14,D18*B14)))","v":88.399999999999991}]
[]
["Final Estimated Fee",null,null,{"$f":"IF(D43>D45,D43,D45)","v":561}]

{"sheet":"RFA Codes","index":1,"n_rows":66,"n_cols":4,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Community ID","RFA Group","Description","Abbreviation"]
[1,"Native Forest","Coastal E. amygdalina dry sclerophyll forest","AC"]
[2,"Native Forest","E. amygdalina forest on dolerite","AD"]
[3,"Native Forest","Inland E. amygdalina forest","AI"]
[4,"Native Forest","E. amygdalina forest on sandstone","AS"]
[5,"Native Forest","Allocasuarina verticillata forest","AV"]
[6,"Native Forest","E. brookeriana wet forest","BA"]
[7,"Native Forest","Acacia melanoxylon forest on flats","BF"]
[8,"Native Forest","Acacia melanoxylon forest on rises","BR"]
[9,"Native Forest","Banksia serrata woodland","BS"]
[10,"Native Forest","E. coccifera dry forest","C"]
[11,"Native Forest","Callitris rhomboidea forest","CR"]
[12,"Native Forest","Dry E. delegatensis forest","D"]
[13,"Native Forest","E. viminalis / E. ovata / E. amygdalina / E. obliqua damp sclerophyll forest","DSC"]
[14,"Native Forest","Tall E. delegatensis forest","DT"]
[15,"Native Forest","King Billy Pine with deciduous beech forest","F"]
[16,"Native Forest","E. viminalis and/or E. globulus coastal shrubby forest","G"]
[17,"Native Forest","Grassy E. globulus forest","GG"]
[18,"Native Forest","Huon Pine forest","H"]
[19,"Native Forest","King Island E. globulus / E. brookeriana / E. viminalis forest","KG"]
[20,"Native Forest","Leptospermum sp. / Melaleuca squarrosa swamp forest","L"]
[21,"Native Forest","Callidendrous and thamnic rainforest on fertile sites","M+"]
[22,"Native Forest","Thamnic rainforest on less fertile sites","M-"]
[23,"Native Forest","Melaleuca ericifolia forest","ME"]
[24,"Native Forest","E. morrisbyi forest","MO"]
[25,"Native Forest","Dry E. nitida forest","N"]
[26,"Native Forest","Furneaux E. nitida forest","NF"]
[27,"Native Forest","Notelaea ligustrina / Pomaderris apetala forest","NP"]
[28,"Native Forest","Tall E. nitida forest","NT"]
[29,"Native Forest","Dry E. obliqua forest","O"]
[30,"Native Forest","Tall E. obliqua forest","OT"]
[31,"Native Forest","Shrubby E. ovata forest","OV"]
[32,"Native Forest","E. pulchella / E. globulus / E. viminalis grassy shrubby dry sclerophyll forest","P"]
[33,"Native Forest","Pencil Pine with deciduous beech forest","PD"]
[34,"Native Forest","E. pauciflora forest on Jurassic dolerite","PJ"]
[35,"Native Forest","Pencil Pine forest","PP"]
[36,"Native Forest","E. pauciflora forest on sediments","PS"]
[37,"Native Forest","E. regnans forest","R"]
[38,"Native Forest","E. risdoni forest","RI"]
[39,"Native Forest","E. rodwayi forest","RO"]
[40,"Native Forest","E. sieberi forest on granite","SG"]
[41,"Native Forest","Silver wattle (Acacia dealbata) forest","SI"]
[42,"Native Forest","E. sieberi forest on other substrates","SO"]
[43,"Native Forest","E. subcrenulata forest","SU"]
[44,"Native Forest","E. tenuiramis forest on granite","T"]
[45,"Native Forest","E. tenuiramis forest on dolerite","TD"]
[46,"Native Forest","Inland E. tenuiramis forest","TI"]
[47,"Native Forest","E. viminalis grassy forest","V"]
[48,"Native Forest","Furneaux E. viminalis forest","VF"]
[49,"Native Forest","Wet E. viminalis forest on basalt","VW"]
[50,"Native Forest","King Billy Pine forest","X"]
[51,"Non Forest","Non forest – Bracken field","NFB"]
[52,"Non Forest","Non forest – Native grassland","NFG"]
[53,"Non Forest","Non forest – Heath/scrub","NFH"]
[54,"Non Forest","Non forest – Moorland/sedgeland","NFM"]
[55,"Non Forest","Non forest – Other non forest","NFO"]
[56,"Non Forest","Non forest – Pasture","NFP"]
[57,"Plantation","Plantation – A. melanoxylon","PAM"]
[58,"Plantation","Plantation – E. globulus","PEG"]
[59,"Plantation","Plantation – E. nitens","PEN"]
[60,"Plantation","Plantation – E. regnans","PER"]
[61,"Plantation","Plantation – Other hardwood","POH"]
[62,"Plantation","Plantation – Other softwood","POS"]
[63,"Plantation","Plantation – P. radiata","PPR"]
[64,"Native Forest","Inland E.amygdalina / E.viminalis / E.pauciflora on Cainozoic deposits","AIC"]
[65,"Native Forest","E.amygdalina forest on mudstone","AM"]