{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fee calculator","version record"],"not_rendered":{"charts":0,"images":3,"macros":1,"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":"Fee calculator","index":0,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["BASIX® off-line fee calculator",null,null,null,null,null,{"$f":"'version record'!B1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October 2023"]
[]
[]
[null,"INPUT - Project details",null,null,null,null,null,null,null,null,null,null,null,"OUTPUT - Fee information"]
[]
[null,null,"Project type",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"please select"]
[null,null,null,null,"New dwelling project or Alterations and additions*? ",null,null,null,null,null,null,"Single-dwelling",null,null,"Single-dwelling project :",null,null,null,null,null,null,{"$f":"IF(L6=2,50,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Multiple-dwelling"]
[null,null,"* Alterations and additions over $50,000, or a pool > 40,000L",null,null,null,null,null,null,null,null,"Alterations and additions*",null,null,"Multi-dwelling project :"]
[]
[null,null,"Dwelling type (Multiple-dwelling projects only)",null,null,null,null,null,null,null,null,null,null,null,null,"Single detached dwelling(s)",null,null,null,null,null,{"$f":"IF(L6=3,50*G14,0)","v":0}]
[]
[null,null,null,null,"Single detached dwelling(s)",null,0,null,null,null,null,null,null,null,null,"Dual occupancies, multi-dwelling and attached dwellings",null,null,null,null,null,{"$f":"IF(L6=3,IF(G20=0,0,IF(G20=1,50,80+(G20-2)*35)),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential flat dwellings",null,null,null,null,null,{"$f":"IF(L6=3,IF(G26=0,0,IF(OR(G26=1,G26=2),50*G26,120+(G26-3)*20)),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alterations and additions :",null,null,null,null,null,null,{"$f":"IF($L$6=4,25,0)","v":0}]
[]
[null,null,null,null,"Dual occupancies, multi-dwelling housing",null,0,null,null,null,null,null,null,null,"Additional fee for alternative assessment :",null,null,null,null,null,null,{"$f":"IF(AND(L34=1,L6=2),0.5*V8,IF(AND(L34=1,L6=3),MIN(250,0.5*SUM(V12,V14,V16)),IF(AND(L34=1,L6=4),0.5*V18,0)))","v":0}]
[null,null,null,null,"and attached dwellings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning portal fee : ",null,null,null,null,null,null,{"$f":"IF(OR(L6=2,L6=3,L6=4),5,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total fee :",null,{"$f":"SUM(V8,V12,V14,V16,V18,V20,V22)","v":0}]
[null,null,null,null,"Residential flat dwellings (NOT buildings)",null,0]
[]
[]
[]
[]
[]
[null,"INPUT - Alternative assessment"]
[]
[null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"Applying for alternative assessment?",null,null,null,"YES"]
[]
[null,null,null,null,null,null,"NO"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The defintion of a BASIX building and the prescribed fee payable are set out in the Environmental Planning and Assessment (Development Certification and Fire Safety) Regulation."]

{"sheet":"version record","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["BASIX multi",{"$f":"MAX(B11:B51)","v":2}]
["CHANGE RECORD"]
[]
[]
[]
[]
[]
[]
[]
["brief description of modification (red => will change score, blue => MM significant)","new version nr.","date","approx cell, row or column ref","who?"]
[]
["Updating date of the calculator",2,"2023-05-02","V1","KY"]
["Revising the disclaimer to include merchant fee",null,null,"Text box"]
["Inserting the item \"Planning Portal fee\"",null,null,"O22 - V22"]
["Updating total fee calculations",null,null,"V25"]
["Updating contents",null,null,"row 47"]
[]
["EP&A 'Regulation', not 'Regulations'",1.3,"2011-06-07","B47","KY"]
[]
["EXCEL 2007 version",1.2,"2011-05-21",null,"KY"]
[]
["Removal of custom view info and all name info",null,"2011-05-05",null,"KY"]
["Including ownership and copyright statements"]
[]
["Alterations and additions added as an option",1.1000000000000001,"2011-04-14","K10, N18","KY"]
["Disclaimer modified",null,null,"N28"]
["Bottom text on referring to EP&A regulations added",null,null,"row 45"]
[]
[null,1]
["Calculator developed",null,"2011-03-23",null,"KY"]