{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fee Calculator ","Application Types"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Fee Calculator ","index":0,"n_rows":135,"n_cols":6,"rows_kept":135,"cut":false,"hidden":false,"merged":[[84,2,84,5],[90,2,90,5],[115,2,115,5],[121,2,121,5],[127,2,127,5],[5,4,5,5],[7,2,7,3],[7,4,7,5],[8,4,8,5],[8,2,8,3],[18,2,18,5],[25,2,25,5],[33,2,33,5],[39,2,39,5],[45,2,45,5],[51,2,51,5],[57,2,58,5],[64,2,64,5],[71,2,71,5],[78,2,78,5]]}
[null,"UDA Online Application Portal "]
[null,"PROCESSING FEES, SERVICE CHARGES FOR OBTAINING DEVELOPMENT PERMITS"]
[null,"Prepared By"]
[null,"Research & Development Unit "]
[]
[null,null,"Application Type",null,"PPC- Special Projects"]
[null,null,"Distance from nearest UDA Office to Site (Km)"]
[null,null,"Transport Cost (LKR) @ 35 LKR Per Km",null,{"$f":"$F$7*35","v":0}]
[]
[null,null,"Processing Fee for Issue a Development Permit for Land Subdivision "]
[null,null,"No of Lots (Between 150-300 Sq.m)"]
[null,null,"No of Lots (Between 301-600 Sq.m)"]
[null,null,"No of Lots (Between 601-900 Sq.m)"]
[null,null,"No of Lots (Above 900 Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"$F$11*500+$F$12*400+$F$13*300+$F$14*200","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F$15*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F$15+$F$16)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F$15:$F$17)","v":0}]
[null,null,"Processing Fee for Issue a Development Permit for Erection of Building "]
[null,null,"Residential -Floor Area (Sq.m)"]
[null,null,"Commercial or Other Use -Floor Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"(IF($F$20=0,0,IF($F$20<45,500,IF($F$20<=90,1500,IF($F$20<=180,2500,IF($F$20<=270,3500,IF($F$20<=450,4500,IF($F$20<=675,5500,IF($F$20<=900,6500,IF($F$20<=1225,7500,IF($F$20>1225,(($F$20-1225)*(1000/90))+7500)))))))))))+(IF($F$21=0,0,IF($F$21<45,1000,IF($F$21<=90,2000,IF($F$21<=180,3000,IF($F$21<=270,4000,IF($F$21<=450,6000,IF($F$21<=675,8000,IF($F$21<=900,10000,IF($F$21<=1225,12000,IF($F$21>1225,(($F$21-1225)*(1250/90))+12000)))))))))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F$22*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F$22+$F$23)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F$22:$F$24)","v":0}]
[null,null,"Processing Fee for Issue a Development Permit for Erection Parapet Walls"]
[null,null,"Use of Development ",null,null,"Residential Uses"]
[null,null,"Sitting of Parapet Wall relation to Building Line ",null,null,"With in"]
[null,null,"Length (m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF((AND($F$27=\"Residential Uses\",$F$28=\"Outside\")),($F$29*300),IF((AND($F$27=\"Residential Uses\",$F$28=\"With in\")),($F$29*500),IF((AND($F$27=\"Commercial or Other Uses\",$F$28=\"Outside\")),($F$29*400),IF((AND($F$27=\"Commercial or Other Uses\",$F$28=\"With in\")),($F$29*600)))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F30*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F30+$F31)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F30:$F32)","v":0}]
[null,null,"Processing Fee for Issue a Development Permit for Reclamation of Low Lying Lands "]
[null,null,"Land Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F35=0,0,IF($F35<=150,1500,IF($F35>150,(($F35-150)*(1000/150)+1500))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F36*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F36+$F37)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F36:$F38)","v":0}]
[null,null,"Processing Fee for Issue a Development Permit for Erection of Telecommunication Towers"]
[null,null,"Height of the Tower (m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F41=0,0,IF($F41<=20,20000,IF($F41>20,($F41-20)*100+20000)))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F42*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F42+$F43)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F42:$F44)","v":0}]
[null,null,"Processing Fee for Issue a Development Permit for Special Development Project "]
[null,null,"Floor Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F$47=0,0,IF($F$47<45,1000,IF($F$47<=90,2000,IF($F$47<=180,3000,IF($F$47<=270,4000,IF($F$47<=450,6000,IF($F$47<=675,8000,IF($F$47<=900,10000,IF($F$47<=1225,12000,IF($F$47>1225,(($F$47-1225)*(1250/90)+12000)))))))))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F48*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F48+$F49)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F48:$F50)","v":0}]
[null,null,"Processing Fee for Issue a Change of Use Approval of Residential Development "]
[null,null,"Floor Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F$53=0,0,IF($F$53<45,500,IF($F$53<=90,1000,IF($F$53<=180,1250,IF($F$53<=270,1500,IF($F$53<=450,1750,IF($F$53<=675,2000,IF($F$53<=900,2250,IF($F$53>900,(($F$53-900)*(500/90)+2250))))))))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F$54*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F$54+$F$55)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F$54:$F$56)","v":0}]
[null,null,"Processing Fee for Issue a Preliminary Planning Clearence for Sub division of Land"]
[]
[null,null,"Land Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F$60=0,0,IF($F$60<=1000,2000,IF($F$60<=5000,5000,IF($F$60<=10000,10000,IF($F$60>10000,(($F$60-10000)*(1000/1000)+10000))))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F$61*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F$61+$F$62)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F$61:$F$63)","v":0}]
[null,null,"Processing Fee for Issue a Preliminary Planning Clearence for Erection of Building "]
[null,null,"Proposed Use",null,null,"Commercial or Other Uses"]
[]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F66=\"Residential Uses\",2000,IF($F66=\"Commercial or Other Uses\",5000,0))","v":5000}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F$68*0.0204","v":102.00000000000001}]
[null,null,"VAT (15%)",null,null,{"$f":"($F$68+$F$69)*0.15","v":765.3}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F$68:$F$70)","v":5867.3}]
[null,null,"Processing Fee for Issue a Preliminary Planning Clearence for Erection Parapet Walls"]
[null,null,"Type of Use",null,null,"Commercial or Other Uses"]
[]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F73=\"Residential Uses\",1500,IF($F73=\"Commercial or Other Uses\",3000,0))","v":3000}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F75*0.0204","v":61.2}]
[null,null,"VAT (15%)",null,null,{"$f":"($F75+$F76)*0.15","v":459.17999999999995}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F75:$F77)","v":3520.3799999999997}]
[null,null,"Processing Fee for Issue a Preliminary Planning Clearence for Reclamation of Low Lying Areas"]
[null,null,"Land Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F80=0,0,IF($F80<=150,2500,IF($F80<=300,5000,IF($F80>300,(($F80-300)*(3000/150)+5000)))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F81*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F81+$F82)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F81:$F83)","v":0}]
[null,null,"Processing Fee for Issue a Preliminary Planning Clearence for Erection of Telecommunication Towers"]
[null,null,"Height of the Tower (m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F86=0,0,IF($F86<=20,50000,IF($F86>20,($F86-20)*500+50000)))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F87*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F87+$F88)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F87:$F89)","v":0}]
[null,null,"Processing Fee for Issue a Preliminary Planning Clearence for Special Development Project "]
[null,null,"Project Investment (LKR Mn)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F92=0,0,IF($F92<=5,10000,IF($F92<=50,50000,IF($F92>50,150000))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F93*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F93+$F94)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F93:$F95)","v":0}]
[null,null,"Processing Fee for Issue a Certificate of Conformity for Land Subdivision  "]
[null,null,"No of Lots "]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F98=1,1000,IF($F98>1,(ROUNDUP(VALUE($F98-1),0)*500+1000)))","v":false}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F99*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F99+$F100)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F99:$F101)","v":0}]
[null,null,"Processing Fee for Issue a Certificate of Conformity for Building Construction "]
[null,null,"Residential -Floor Area (Sq.m)"]
[null,null,"Commercial or Other Use -Floor Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F105=0,0,IF($F105<=100,3000,IF($F105>100,($F105-100)*20+3000)))+IF($F104=0,0,IF($F104<=300,3000,IF($F104>300,($F104-300)*10+3000)))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F106*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F106+$F107)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F106:$F108)","v":0}]
[null,null,"Processing Fee for Issue a Certificate of Conformity for Erection Parapet Walls"]
[null,null,"Length (m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F111=0,0,IF($F111<=100,1000,IF($F111>100,($F111-100)*10+1000)))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F112*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F112+$F113)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F112:$F114)","v":0}]
[null,null,"Processing Fee for Issue a Certificate of Conformity for Reclamation of Low Lying Lands "]
[null,null,"Land Area (Sq.m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F117=0,0,IF($F117<=150,3000,IF($F117>150,($F117-150)*20+3000)))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F118*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F118+$F119)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F118:$F120)","v":0}]
[null,null,"Processing Fee for Issue a Certificate of Conformity for Erection of Telecommunication Towers"]
[null,null,"Height of the Tower (m)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F123=0,0,IF($F123<=20,2000,IF($F123>20,($F123-20)*100+2000)))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F124*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F124+$F125)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F124:$F126)","v":0}]
[null,null,"Processing Fee for Issue a Certificate of Conformity for Special Development Project "]
[null,null,"Project Investment (LKR Mn)"]
[null,null,"Amount to be paid (LKR) (Excluding Taxes)",null,null,{"$f":"IF($F129=0,0,IF($F129<=5,5000,IF($F129<=50,10000,IF($F129>50,20000))))","v":0}]
[null,null,"NBT (2.04%)",null,null,{"$f":"$F130*0.0204","v":0}]
[null,null,"VAT (15%)",null,null,{"$f":"($F130+$F131)*0.15","v":0}]
[null,null,"Total Processing Fee (LKR)",null,null,{"$f":"SUM($F130:$F132)","v":0}]
[null,null,"Total Payable Amount (LKR)",null,null,{"$f":"IF($E$6=\"DP- Land Subdivision (BOP)\",(E8+F18),IF($E$6=\"DP- Building Application  (BA)\",(E8+F25),IF($E$6=\"DP- Erection of Parapet Walls\",(E8+F33),IF($E$6=\"DP- Reclamation of Low Lying Lands\",(E8+F39),IF($E$6=\"DP- Erection of Telecommunication Towers\",(E8+F45),IF($E$6=\"DP- Special Projects\",(E8+F51),IF($E$6=\"Change of Use of Residential Units (CoU)\",(E8+F57),IF($E$6=\"PPC- Land Subdivision\",(E8+F64),IF($E$6=\"PPC- Building Application\",(E8+F71),IF($E$6=\"PPC- Erection of Parapet Walls\",(E8+F78),IF($E$6=\"PPC- Reclamation of Low Lying Lands\",(E8+F84),IF($E$6=\"PPC- Erection of Telecommunication Towers\",(E8+F90),IF($E$6=\"PPC- Special Projects\",(E8+F96),IF($E$6=\"CoC- Land Subdivision\",(E8+F102),IF($E$6=\"CoC- Building Application\",(E8+F109),IF($E$6=\"CoC- Erection of Parapet Walls\",(E8+F115),IF($E$6=\"CoC- Reclamation of Low Lying Lands\",(E8+F121),IF($E$6=\"CoC- Erection of Telecommunication Towers\",(E8+F127),IF($E$6=\"CoC- Special Projects\",(E8+F133),0)))))))))))))))))))","v":0}]
[null,"Note: The Total Payable Amount = Transport Cost+ Processing Fee"]

{"sheet":"Application Types","index":1,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
["APPLICATION TYPE"]
["- Select the Application Type- "]
["DP- Land Subdivision (BOP)"]
["DP- Building Application  (BA)"]
["DP- Erection of Parapet Walls"]
["DP- Reclamation of Low Lying Lands"]
["DP- Erection of Telecommunication Towers"]
["DP- Special Projects"]
["Change of Use of Residential Units (CoU)"]
["PPC- Land Subdivision"]
["PPC- Building Application"]
["PPC- Erection of Parapet Walls"]
["PPC- Reclamation of Low Lying Lands"]
["PPC- Erection of Telecommunication Towers"]
["PPC- Special Projects"]
["CoC- Land Subdivision"]
["CoC- Building Application"]
["CoC- Erection of Parapet Walls"]
["CoC- Reclamation of Low Lying Lands"]
["CoC- Erection of Telecommunication Towers"]
["CoC- Special Projects"]
[]
["Development Permit Types"]
["- Select the Proposed Use- "]
["Residential Uses"]
["Commercial or Other Uses"]
[]
["PPC Application Type"]
["- Select the Sub Category- "]
["Sub division of lands "]
["Building Permit "]
["Parapet Walls & Retaining Walls"]
["Reclamation of Low Lying Lands/ Paddy Lands"]
["Telecommunication Antenna Towers"]
["Special Projects"]
[]
["- Select the Location - "]
["Outside"]
["With in"]
[]
["Erection of Parapet Walls","Residential ","Commercial or Other Uses "]
["Outside ",300,400]
["Within ",500,600]