{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["COVER","Page 1 - Introduction","Page 2 - User Instructions","Page 3 - Front Page Letter","Page 4 - NOCC Detail","Lookups","Temp","Customer List","Template"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":8,"defined_names":759,"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":"COVER","index":0,"n_rows":785,"n_cols":2,"rows_kept":785,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This page was left intentionally blank."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Rate Code"]

{"sheet":"Page 1 - Introduction","index":1,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,0,18,1]]}
[]
["Public Lighting Design"]
[{"$f":"'Page 3 - Front Page Letter'!A6","v":"Version: July 2023"}]
[]
["Notification of change in charges (NOCC)"]
[]
[]
[]
["Brief guide to the Excel document:"]
[]
[1,"This document is provided to enable Project Managers and Accredited Service Providers with a means to:"]
[]
[2,"Calculate the change in SLUoS charges to end customers of Public Lighting assets;"]
[]
[3,"Calculate the TARIFF CLASS 5 charges applicable to assets removed; and,"]
[]
[4,"Provide printable schedules that can be published to end customers for sign and return."]
[]
["The first page also contains a link to Published Public Lighting Schedules on Endeavour Energy’s website (Our Network / Streetlights & Nightwatch)"]
[]
[]
[]
["The document contains seven (6) pages:"]
[]
["Page 1","Introduction"]
[]
["Page 2","User instructions"]
[]
["Page 3","Front page letter"]
[]
["Page 4","Tariff class details"]
[]
["Page 7","HYBRID Rates"]

{"sheet":"Page 2 - User Instructions","index":2,"n_rows":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":false,"merged":[[42,0,42,7],[41,0,41,7],[38,0,38,7],[37,0,37,7],[1,0,1,8],[2,0,2,8],[43,0,43,7],[52,0,52,1],[51,0,51,7],[48,0,48,7],[47,0,47,7],[46,0,46,7]]}
[]
["NOTIFICATION of CHANGE in CHARGES (NOCC)"]
["User Instructions"]
["Purpose","This document is provided to enable:"]
[null,1,"Project Managers and Accredited Service Providers with a means to "]
[null,2,"Calculate the change in SLUOS charges to end customers of Public Lighting assets and"]
[null,3,"Calculate the TARIFF CLASS 5 charges applicable to assets removed and provide"]
[null,4,"Printable schedules that can be published to end customers for sign & return"]
[]
["Resources","Published Public Lighting Price Schedules"]
[]
["User Instruction Sheet"]
[]
[null,"Asset Removal / Replacement",null,null,"Asset Installations",null,null,"Completing the Letter"]
[]
["Tarriff Class Details","If assets are being removed / replaced",null,"Tarriff Class Details","If assets are being installed",null,"Front Page","Choose Council from pull down menu - cell A14"]
[null,"Click insert rows for the number of rows required",null,null,"Click insert rows for the number of rows required",null,null,"Council address and contact will populate automatically."]
[null,"Complete column A,C & D & E  - C = Removed, E = Commission date (or felled date if not known, or <1980 if not known), each component requires a separate row",null,null,"Complete column A,C & D & E  - C = Installed, E is year to be installed",null,"Optional","Otherwise overwrite manually"]
[null,"Annual charges removed calculates automatically - otherwise press F9.",null,null,"Annual charges removed calculates automatically - otherwise press F9.",null,"Optional","Choose macro \"restore Council auto-complete\" to reset formulas to auto-complete - this will overwrite existing data"]
[]
[null,"TARIFF CLASS 5 charges are calculated automatically - otherwise press F9",null,null,null,null,null,"Highlighted areas are editable - highlighting can be removed or restored using the macros provided."]
[null,"Sub-Totals will automatically transfer to:",null,null,"Sub-Totals will automatically transfer to:"]
[null,"Front Page",null,null,"Front Page",null,null,"Complete Project Number, Project Description, Drawing Number, Your Ref - if applicable"]
[]
[null,null,null,null,null,null,null,"Project Number and Project Description are transferred automatically to each of the detail sheets (TC 1 & 2, TC 3 & 4 and TC 6)"]
[]
[null,null,null,null,null,null,null,"Page 2 is a summary of data and provides for sign-off to be returned."]
[]
[null,null,null,null,null,null,null,"Note: if developer agrees to pay Tariff Class 5, they must complete the optional sign off box at the bottom of Page 3 - Front Page Letter."]
[]
[]
[]
[]
[]
[]
["TARIFF CLASSES"]
["LEGACY Rates – Tariff Class 1 & 2"]
["Assets constructed* up to (and including) 30 June 2009 will be charged in the same manner as the previous determination period, adjusted in accordance with the AER’s determination.  Adjustments have been made both for inflation and redistribution of the existing asset base across the asset classes in a way which more closely reflects the age of each asset class."]
["These rates are a continuation of rates previously listed under Schedule 1 & 2 and will no longer be available for assets constructed* from 1 July 2009."]
[]
["ANNUITY Rates – Tariff Class 3 & 4"]
["Applies to assets constructed* on or after 1 July 2009 and are cost reflective rates, recovered over the life of the asset."]
["Tariff Class 3 rates apply where IE provides installation capital."]
["Tariff Class 4 rates apply where IE does not fund the installation and the contestable assets are gifted to IE."]
[]
["RESIDUAL Capital Value – Tariff Class 5"]
["Applies where Endeavour has funded the capital, but the asset is replaced at the request of the customer before the end of its economic life. "]
["Using the AER’s approved method, the Tariff charge is calculated at the time of agreement using the replaced asset’s weighted average remaining life. "]
["The charge is paid at the time of replacement. "]
[]
["MAINTENANCE Only Rates – Unregulated Tariff Class"]
["In addition to the five (5) Tariff Classes detailed above, the Unregulated Tariff Class will apply where customers request limited maintenance only services to non-standard public lighting assets that they own and are responsible for. The rates are cost reflective for luminaire only requirements."]
["These rates were previously listed under Schedule 3."]
[]
["LEGEND"]
["INC","Incandescent"]
["FL","Flourescent"]
["CFL","Compact Flourescent"]
["M or MF","Mercury"]
["MH","Metal Halide"]
["SHP or HPS","High Pressure Sodium"]
["SLP or LPS","Low Pressure Sodium"]
["COL","Column (Steel)"]
["WP","Pole (Wood)"]
["F/L","Flood Light"]
["A/S","Aero Screen"]
["LEGACY","Applies to assets constructed prior to 1 July 2009 (Tariff Class 1 & 2)"]
["ANNUITY","Applies to assets constructed after 30 June 2009 (Tariff Class 3 & 4)"]
["IE","Endeavour Energy owns the asset (Tariff Class 1 & 3)"]
["Gifted","Customer buys asset and \"gifts\" it to Endeavour Energy (Tariff Class 2 & 4)"]
["CUST","Customer buys and owns asset (Tariff Class: Unregulated)"]

{"sheet":"Page 3 - Front Page Letter","index":3,"n_rows":242,"n_cols":8,"rows_kept":242,"cut":false,"hidden":false,"merged":[[112,1,112,4],[29,0,29,1],[36,0,48,5],[67,0,67,5],[84,0,84,1],[87,0,87,5],[88,0,88,5],[95,1,95,4],[98,1,98,4],[102,0,102,5],[103,0,103,5],[106,1,106,4]]}
[]
[]
[]
[]
[]
["Version: July 2023"]
[null,"Project Number",null,null,null,null,"Highlighted sections should be completed"]
["PROJECT DESCRIPTION:","(Project Description)"]
["Drawing No:",1234567]
["YOUR REF:",1234567]
[]
[]
[]
["City of Parramatta"]
[{"$f":"VLOOKUP(A14,'Customer List'!A:D,2,FALSE)","v":"PO Box 32"}]
[{"$f":"VLOOKUP(A14,'Customer List'!A:D,3,FALSE)","v":"PARRAMATTA   NSW   2150"}]
[]
[{"$f":"TODAY()","v":"2023-09-05"}]
[]
["CHANGE IN PUBLIC LIGHTING SLUOS CHARGES"]
[]
["Tariff Class",null,null,null,"Net Change in Annual Charges (incl GST)","TARIFF CLASS 5 Charges (Residual Asset Value)"]
["1. LEGACY - Capital funded by Endeavour","Removed / Replaced",null,null,{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A23,1,1),'Page 4 - NOCC Detail'!H:H)","v":0},{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A23,1,1),'Page 4 - NOCC Detail'!K:K)","v":0}]
["2. LEGACY - Capital NOT funded by Endeavour","Removed / Replaced",null,null,{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A24,1,1),'Page 4 - NOCC Detail'!H:H)","v":0},{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A24,1,1),'Page 4 - NOCC Detail'!K:K)","v":0}]
["3. ANNUITY - Capital funded by Endeavour","to be installed/(replaced)",null,null,{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A25,1,1),'Page 4 - NOCC Detail'!H:H)","v":0},{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A25,1,1),'Page 4 - NOCC Detail'!K:K)","v":0}]
["4. ANNUITY - Capital NOT funded by Endeavour","to be installed/(replaced)",null,null,{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A26,1,1),'Page 4 - NOCC Detail'!H:H)","v":0},{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A26,1,1),'Page 4 - NOCC Detail'!K:K)","v":0}]
["6. Unregulated:CUSTOMER OWNED","Net Installations",null,null,{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A27,1,1),'Page 4 - NOCC Detail'!H:H)","v":0},{"$f":"SUMIF('Page 4 - NOCC Detail'!B:B,MID(A27,1,1),'Page 4 - NOCC Detail'!K:K)","v":0}]
["NET CHANGE in ANNUAL TARIFFS (incl GST)",null,null,null,{"$f":"SUM(E23:E27)","v":0},null,{"$f":"E28*2-SUM('Page 4 - NOCC Detail'!H:H)","v":0},{"$f":"IF(G28<>0,\"Tariff Class 5 Total Charge error - please check worksheet\",\"\")","v":""}]
[]
["ADDITIONAL: TARIFF CLASS 5 CHARGES",null,null,null,null,{"$f":"SUM(F23:F27)","v":0},{"$f":"F30*2-SUM('Page 4 - NOCC Detail'!K:K)","v":0},{"$f":"IF(G30<>0,\"Tariff Class 5 Total Charge error - please check worksheet\",\"\")","v":""}]
["One off charge paid at time of asset removal / replacement"]
["Applies to assets removed prior to the end of their useful life - single charge paid on removal."]
[]
[]
[]
["NOTES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VALIDITY"]
["These rates will remain in force for 60 days."]
["At the expiry of 60 days from the date of this letter, rates may be amended to the rates in force at that time."]
[]
[]
["Yours faithfully,"]
[null,"Project / Manager - Designer"]
[null,"Title"]
[null,"Contact Details"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"signature page for customer"]
["NOTIFICATION of CHANGE in CHARGES"]
[]
[{"$f":"A7","v":0},{"$f":"B7","v":"Project Number"}]
["PROJECT DESCRIPTION:",{"$f":"$B$8","v":"(Project Description)"}]
["CUSTOMER:",{"$f":"Name","v":"City of Parramatta"}]
[{"$f":"A9","v":"Drawing No:"},1234567]
["YOUR REF:",1234567]
[]
[{"$f":"A20","v":"CHANGE IN PUBLIC LIGHTING SLUOS CHARGES"}]
[{"$f":"A22","v":"Tariff Class"},0,0,0,"Net Change in Annual Charges (incl GST)","TARIFF CLASS 5 Charges (Residual Asset Value)"]
["1. LEGACY - Capital funded by Endeavour","Removed / Replaced",0,0,0,0]
["2. LEGACY - Capital NOT funded by Endeavour","Removed / Replaced",0,0,0,0]
["3. ANNUITY - Capital funded by Endeavour","to be installed/(replaced)",0,0,0,0]
["4. ANNUITY - Capital NOT funded by Endeavour","to be installed/(replaced)",0,0,0,0]
["6. Unregulated:CUSTOMER OWNED","Net Installations",0,0,0,0]
[{"$f":"A28","v":"NET CHANGE in ANNUAL TARIFFS (incl GST)"},null,null,null,{"$f":"E28","v":0},{"$f":"F28","v":0}]
[{"$f":"A29","v":0},null,null,null,{"$f":"E29","v":0},{"$f":"F29","v":0}]
[{"$f":"A30","v":"ADDITIONAL: TARIFF CLASS 5 CHARGES"},null,null,null,null,{"$f":"F30","v":0}]
[{"$f":"A31","v":"One off charge paid at time of asset removal / replacement"},null,null,null,null,{"$f":"F31","v":0}]
[]
["The proposed change in Public Lighting charges described above are approved by:"]
["to be signed by duly authorised officer of the customer"]
[]
[]
[]
["Signed:"]
[]
[]
["Name:"]
[]
[]
["Date:"]
[]
[]
[]
["If payment of Tariff Class 5 charges is to be made by developer, please complete below:"]
[]
["Note: Please do not pay Tariff Class 5 charges until the design has been certified and Endeavour Energy issues a Payment Advice/"]
["           Pro Forma Invoice for the required amount after validation.  Payment is only required when you have decided to construct the works."]
["Developer Name"]
["Developer Address"]
["Street / PO Box"]
["City"]
["State"]
["Post Code"]
["Developer ABN"]
[]
[]
["Signed by Developer:"]
[]
[]
["Signatory Name:"]
[]
[]
["Date:"]
[]
["Note: Council remains liable for Tariff Class 5 charges, if developer fails to pay invoice will be recovered against council."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'Customer List'!A2","v":"Bankstown City Council                  "}]
[{"$f":"'Customer List'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Customer List'!A3","v":"Blacktown City Council                  "}]
[{"$f":"'Customer List'!A4","v":"Blue Mountains City Council             "}]
[{"$f":"'Customer List'!A6","v":"Campbelltown City Council               "}]
[{"$f":"'Customer List'!A7","v":"Council of the City of Shellharbour "}]
[{"$f":"'Customer List'!A8","v":"Bathurst Regional Council"}]
[{"$f":"'Customer List'!A9","v":"Fairfield City Council                  "}]
[{"$f":"'Customer List'!A10","v":"Hawkesbury City Council                 "}]
[{"$f":"'Customer List'!A11","v":"HMAS Albatross (Department of Defence)"}]
[{"$f":"'Customer List'!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Customer List'!A12","v":"Cumberland City Council"}]
[{"$f":"'Customer List'!A13","v":"Hornsby City Council"}]
[{"$f":"'Customer List'!A14","v":"Kiama Municipal Council                 "}]
[{"$f":"'Customer List'!A15","v":"Lithgow City Council"}]
[{"$f":"'Customer List'!A16","v":"Liverpool City Council                  "}]
[{"$f":"'Customer List'!A17","v":"Mid Western Regional Council"}]
[{"$f":"'Customer List'!A18","v":"NSW Maritime Property Divisions"}]
[{"$f":"'Customer List'!A19","v":"City of Parramatta"}]
[{"$f":"'Customer List'!A20","v":"Penrith City Council                    "}]
[{"$f":"'Customer List'!A21","v":"Port Kembla Operations Pty Ltd"}]
[{"$f":"'Customer List'!A22","v":"RTA, Traffic Asset Services (Corrimal)"}]
[{"$f":"'Customer List'!A23","v":"RTA, Traffic Asset Services\n(M7)"}]
[{"$f":"'Customer List'!A24","v":"RTA, Traffic Asset Services\n(Parkes)"}]
[{"$f":"'Customer List'!A25","v":"RTA, Traffic Asset Services\n(National Highway)"}]
[{"$f":"'Customer List'!A26","v":"RTA, Traffic Asset Services\n(State Roads)"}]
[{"$f":"'Customer List'!A27","v":"RTA (Unmetered Lighting)"}]
[{"$f":"'Customer List'!A28","v":"Ryde City Council                  "}]
[{"$f":"'Customer List'!A29","v":"Shoalhaven City Council                 "}]
[{"$f":"'Customer List'!A30","v":"Sydney Catchment Authority"}]
[{"$f":"'Customer List'!A5","v":"Camden Council"}]
[{"$f":"'Customer List'!A32","v":"The Department of Lands"}]
[{"$f":"'Customer List'!A33","v":"Wingecarribee Shire Council             "}]
[{"$f":"'Customer List'!A34","v":"Wollondilly Shire Council               "}]

{"sheet":"Page 4 - NOCC Detail","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,2,7],[4,2,4,4]]}
[]
["Endeavour Energy"]
["Public lighting tariffs effective from 1 July 2023",null,null,null,null,null,null,null,null,"Luminaire only"]
[]
["CUSTOMER: ",null,{"$f":"'Page 3 - Front Page Letter'!A14","v":"City of Parramatta"},"Bankstown City Council                  ","Bankstown City Council                  ",null,"PROJECT NUMBER:",{"$f":"'Page 3 - Front Page Letter'!B7","v":"Project Number"},null,"Luminaire & Support"]
[]
["Tariff Code: Description","Tariff Class","Installed/\nRemoved","Vertical Support Asset Number\n(Pole/Col/URD\n  If known )","Commisioned Date\n(select \"< 1986\" if unknown)","Annual\nCharges  \n$ Ex GST","GST $","Annual \nCharges  \n$ incl GST","Tariff Class 5 Charges\n$ ex GST","GST $","Tariff Class 5 Charges\n $ incl GST","Comments"]
[null,{"$f":"IF(ISBLANK(A8),\"\",VLOOKUP(A8,Lookups!$H$1:$I$371,2,FALSE))","v":""},null,null,null,{"$f":"IF(ISBLANK(A8),\"\",IF(C8=\"Removed\",-1,1)*SUMIF(Lookups!H:H,A8,Lookups!J:J))","v":""},{"$f":"IF(ISBLANK(A8),\"\",F8*0.1)","v":""},{"$f":"IF(ISBLANK(A8),\"\",G8+F8)","v":""},{"$f":"IF(OR(ISBLANK(A8),ISBLANK(C8),C8=\"Installed\"), \"\", VLOOKUP(A8, Lookups!H:BA, IF( OR(B8=1,B8=2), 4, VLOOKUP('Page 4 - NOCC Detail'!E8, Lookups!A:B, 2, FALSE) +3), FALSE))","v":""},{"$f":"IF(I8=\"\",\"\",I8*0.1)","v":""},{"$f":"IF(I8=\"\",\"\",J8+I8)","v":""}]
[]
["Total",null,null,null,null,null,null,{"$f":"SUM(H8:H9)","v":0},null,null,{"$f":"SUM(K8:K9)","v":0}]

{"sheet":"Lookups","index":5,"n_rows":371,"n_cols":52,"rows_kept":371,"cut":false,"hidden":false,"merged":[]}
["Year",null,null,null,"Installed/Removed",13,"1 x 20 W Fluorescent","13: 1 x 20 W Fluorescent",1,54.33,4]
[{"$f":"\"< \"&(A3-1)","v":"< 1986"},38,{"$f":"1","v":1},null,"Installed",14,"2 x 20 W Fluorescent","14: 2 x 20 W Fluorescent",1,57.19,0]
[1987,37,{"$f":"C2+1","v":2},null,"Removed",18,"1 x 40 W Fluorescent","18: 1 x 40 W Fluorescent",1,57.32,10.039999999999999]
[1988,36,3,null,null,19,"2 x 40 W Fluorescent","19: 2 x 40 W Fluorescent",1,61.14,0]
[1989,35,4,null,null,20,"2 x 40 W Fluorescent","20: 2 x 40 W Fluorescent",1,61.14,0]
[1990,34,5,null,null,25,"400 W Sodium","25: 400 W Sodium",1,61.71,0]
[1991,33,6,null,null,30,"250W Mercury","30: 250W Mercury",1,54.78,2]
[1992,32,7,null,null,31,"400 W Mercury","31: 400 W Mercury",1,54.75,2.29]
[1993,31,8,null,null,33,"100W Sodium","33: 100W Sodium",1,65.67,10.62]
[1994,30,9,null,null,34,"90W Sodium","34: 90W Sodium",1,63.59,0]
[1995,29,10,null,null,35,"250W Sodium","35: 250W Sodium",1,69.81,3.18]
[1996,28,11,null,null,36,"400 W Sodium","36: 400 W Sodium",1,61.71,0]
[1997,27,12,null,null,38,"250W Sodium","38: 250W Sodium",1,69.81,3.18]
[1998,26,13,null,null,39,"310W Sodium","39: 310W Sodium",1,69.11,0]
[1999,25,14,null,null,40,"400 W Sodium","40: 400 W Sodium",1,61.71,0]
[2000,24,15,null,null,45,"400 W Sodium","45: 400 W Sodium",1,61.71,0]
[2001,23,16,null,null,53,"250W Sodium","53: 250W Sodium",1,69.81,3.18]
[2002,22,17,null,null,55,"250W Sodium","55: 250W Sodium",1,69.81,3.18]
[2003,21,18,null,null,56,"310W Sodium","56: 310W Sodium",1,69.11,0]
[2004,20,19,null,null,57,"400 W Sodium","57: 400 W Sodium",1,61.71,0]
[2005,19,20,null,null,60,"2 x 250W Mercury","60: 2 x 250W Mercury",1,105.29,266.91000000000003]
[2006,18,21,null,null,63,"1 x 40 W Fluorescent","63: 1 x 40 W Fluorescent",1,57.32,10.039999999999999]
[2007,17,22,null,null,69,"4 x 20 W Fluorescent","69: 4 x 20 W Fluorescent",1,0,0]
[2008,16,23,null,null,70,"1 x 40 W Fluorescent","70: 1 x 40 W Fluorescent",1,57.32,10.039999999999999]
[2009,15,24,null,null,75,"2 x 40 W Fluorescent","75: 2 x 40 W Fluorescent",1,61.14,0]
[2010,14,25,null,null,88,"4 x 600W Sodium","88: 4 x 600W Sodium",1,96.4,0]
[2011,13,26,null,null,93,"80W Mercury","93: 80W Mercury",1,54.27,1.45]
[2012,12,27,null,null,94,"125W Mercury","94: 125W Mercury",1,54.64,1.87]
[2013,11,28,null,null,95,"250W Mercury","95: 250W Mercury",1,54.78,2]
[2014,10,29,null,null,96,"400 W Mercury","96: 400 W Mercury",1,54.75,2.29]
[2015,9,30,null,null,97,"125W Mercury","97: 125W Mercury",1,54.64,1.87]
[2016,8,31,null,null,98,"250W Mercury","98: 250W Mercury",1,54.78,2]
[2017,7,32,null,null,99,"400 W Mercury","99: 400 W Mercury",1,54.75,2.29]
[2018,6,33,null,null,100,"2 x 250W Mercury","100: 2 x 250W Mercury",1,105.29,266.91000000000003]
[2019,5,{"$f":"C34+1","v":34},null,null,101,"2 x 250W Mercury","101: 2 x 250W Mercury",1,105.29,266.91000000000003]
[2020,4,35,null,null,102,"2 x 400 W Sodium","102: 2 x 400 W Sodium",1,78.89,29.29]
[2021,3,36,null,null,103,"2 x 250W Sodium","103: 2 x 250W Sodium",1,90.03,10.029999999999999]
[2022,2,37,null,null,104,"80W Mercury","104: 80W Mercury",1,54.27,1.45]
[2023,1,38,null,null,112,"2 x 20 W Fluorescent","112: 2 x 20 W Fluorescent",1,57.19,0]
[2024,1,39,null,null,114,"250W Mercury","114: 250W Mercury",1,54.78,2]
[null,null,40,null,null,115,"400 W Mercury","115: 400 W Mercury",1,54.75,2.29]
[null,null,41,null,null,119,"250W Sodium","119: 250W Sodium",1,69.81,3.18]
[null,null,42,null,null,121,"400 W Mercury","121: 400 W Mercury",1,54.75,2.29]
[null,null,43,null,null,122,"400 W Mercury","122: 400 W Mercury",1,54.75,2.29]
[null,null,44,null,null,123,"400 W Sodium","123: 400 W Sodium",1,61.71,0]
[null,null,45,null,null,130,"400 W Sodium","130: 400 W Sodium",1,61.71,0]
[null,null,46,null,null,131,"125W Mercury","131: 125W Mercury",1,54.64,1.87]
[null,null,47,null,null,132,"250W Mercury","132: 250W Mercury",1,54.78,2]
[null,null,48,null,null,134,"250W Sodium","134: 250W Sodium",1,69.81,3.18]
[null,null,49,null,null,135,"2 x 400 W Sodium","135: 2 x 400 W Sodium",1,78.89,29.29]
[null,null,50,null,null,136,"2 x 400 W Sodium","136: 2 x 400 W Sodium",1,78.89,29.29]
[null,null,51,null,null,141,"250W Sodium","141: 250W Sodium",1,69.81,3.18]
[null,null,52,null,null,142,"150W Sodium","142: 150W Sodium",1,62.59,14.45]
[null,null,53,null,null,143,"150W Sodium","143: 150W Sodium",1,62.59,14.45]
[null,null,54,null,null,145,"4 x 600W Sodium","145: 4 x 600W Sodium",1,96.4,0]
[null,null,55,null,null,146,"2 x 400 W Sodium","146: 2 x 400 W Sodium",1,78.89,29.29]
[null,null,56,null,null,147,"80W Mercury","147: 80W Mercury",1,54.27,1.45]
[null,null,57,null,null,149,"80W Mercury","149: 80W Mercury",1,54.27,1.45]
[null,null,58,null,null,150,"120W Sodium","150: 120W Sodium",1,60.38,6.27]
[null,null,59,null,null,151,"2 x 400 W Sodium","151: 2 x 400 W Sodium",1,78.89,29.29]
[null,null,60,null,null,152,"2 x 400 W Sodium","152: 2 x 400 W Sodium",1,78.89,29.29]
[null,null,61,null,null,153,"2 x 400 W Sodium","153: 2 x 400 W Sodium",1,78.89,29.29]
[null,null,62,null,null,154,"250W Sodium","154: 250W Sodium",1,69.81,3.18]
[null,null,63,null,null,157,"120W Sodium","157: 120W Sodium",1,60.38,6.27]
[null,null,64,null,null,158,"125W Mercury","158: 125W Mercury",1,54.64,1.87]
[null,null,65,null,null,159,"2 x 400 W Sodium","159: 2 x 400 W Sodium",1,78.89,29.29]
[null,null,{"$f":"C66+1","v":66},null,null,162,"120W Sodium","162: 120W Sodium",1,60.38,6.27]
[null,null,67,null,null,163,"120W Sodium","163: 120W Sodium",1,60.38,6.27]
[null,null,68,null,null,167,"100W Sodium","167: 100W Sodium",1,65.67,10.62]
[null,null,69,null,null,168,"100W Sodium","168: 100W Sodium",1,65.67,10.62]
[null,null,70,null,null,169,"100W Sodium","169: 100W Sodium",1,65.67,10.62]
[null,null,71,null,null,170,"150W Sodium","170: 150W Sodium",1,62.59,14.45]
[null,null,72,null,null,171,"150W Sodium","171: 150W Sodium",1,62.59,14.45]
[null,null,73,null,null,173,"150W Sodium","173: 150W Sodium",1,62.59,14.45]
[null,null,74,null,null,177,"50W Mercury","177: 50W Mercury",1,57.4,2.46]
[null,null,75,null,null,182,"50W Sodium","182: 50W Sodium",1,67.760000000000005,47.15]
[null,null,76,null,null,183,"70W Sodium","183: 70W Sodium",1,60.92,8.27]
[null,null,77,null,null,184,"70W Sodium","184: 70W Sodium",1,60.92,8.27]
[null,null,78,null,null,185,"50W Mercury","185: 50W Mercury",1,57.4,2.46]
[null,null,79,null,null,186,"80W Mercury","186: 80W Mercury",1,54.27,1.45]
[null,null,80,null,null,187,"80W Mercury","187: 80W Mercury",1,54.27,1.45]
[null,null,81,null,null,188,"80W Mercury","188: 80W Mercury",1,54.27,1.45]
[null,null,82,null,null,190,"400 W Sodium","190: 400 W Sodium",1,61.71,0]
[null,null,83,null,null,193,"150W Sodium","193: 150W Sodium",1,62.59,14.45]
[null,null,84,null,null,194,"150W Sodium","194: 150W Sodium",1,62.59,14.45]
[null,null,85,null,null,195,"2 x 20 W Fluorescent","195: 2 x 20 W Fluorescent",1,57.19,0]
[null,null,86,null,null,196,"1000 W Metal Halide","196: 1000 W Metal Halide",1,68.55,0]
[null,null,87,null,null,197,"400 W Metal Halide","197: 400 W Metal Halide",1,72.61,12.61]
[null,null,88,null,null,198,"250 W Metal Halide","198: 250 W Metal Halide",1,82.3,60.19]
[null,null,89,null,null,199,"150 W Metal Halide","199: 150 W Metal Halide",1,137.16,346.35]
[null,null,90,null,null,211,"400 W Metal Halide","211: 400 W Metal Halide",1,72.61,12.61]
[null,null,91,null,null,212,"2 x 400 W Metal Halide","212: 2 x 400 W Metal Halide",1,195.33,547.36]
[null,null,92,null,null,213,"250 W Metal Halide","213: 250 W Metal Halide",1,82.3,60.19]
[null,null,93,null,null,214,"2 x 250 W Metal Halide","214: 2 x 250 W Metal Halide",1,147.09,285.92]
[null,null,94,null,null,215,"150 W Metal Halide","215: 150 W Metal Halide",1,137.16,346.35]
[null,null,95,null,null,216,"100 W Metal Halide","216: 100 W Metal Halide",1,90.93,44.59]
[null,null,96,null,null,217,"100 W Metal Halide","217: 100 W Metal Halide",1,90.93,44.59]
[null,null,97,null,null,218,"2 x 14 W Fluorescent","218: 2 x 14 W Fluorescent",1,64.41,48.65]
[null,null,{"$f":"C98+1","v":98},null,null,219,"2 x 24 W Fluorescent","219: 2 x 24 W Fluorescent",1,59.25,32.130000000000003]
[null,null,99,null,null,220,"2 x 14 W Fluorescent","220: 2 x 14 W Fluorescent",1,64.41,48.65]
[null,null,100,null,null,221,"2 x 24 W Fluorescent","221: 2 x 24 W Fluorescent",1,59.25,32.130000000000003]
[null,null,null,null,null,222,"1 x 42 W Fluorescent","222: 1 x 42 W Fluorescent",1,55.53,0]
[null,null,null,null,null,223,"1 x 42 W Fluorescent","223: 1 x 42 W Fluorescent",1,55.53,0]
[null,null,null,null,null,224,"Pole mounting bracket minor (<=3m)","224: Pole mounting bracket minor (<=3m)",1,15.82,0.36]
[null,null,null,null,null,225,"Pole mounting bracket major (>3m)","225: Pole mounting bracket major (>3m)",1,15.92,1.01]
[null,null,null,null,null,226,"Outreach Minor (<=2m)","226: Outreach Minor (<=2m)",1,16.37,0.16]
[null,null,null,null,null,227,"Outreach Major (>2m)","227: Outreach Major (>2m)",1,16.39,0.02]
[null,null,null,null,null,228,"Minor Column (<=9)","228: Minor Column (<=9)",1,27.83,63.44]
[null,null,null,null,null,229,"Major Column (>=9)","229: Major Column (>=9)",1,124.82,902.73]
[null,null,null,null,null,230,"Outreach Minor (<=2m)","230: Outreach Minor (<=2m)",1,16.37,0.16]
[null,null,null,null,null,231,"Minor Column (<=9)","231: Minor Column (<=9)",1,27.83,63.44]
[null,null,null,null,null,302,"1 x 20 W Fluorescent","302: 1 x 20 W Fluorescent",2,53.57,0]
[null,null,null,null,null,303,"1 x 40 W Fluorescent","303: 1 x 40 W Fluorescent",2,55.53,0]
[null,null,null,null,null,305,"1 x 40 W Fluorescent","305: 1 x 40 W Fluorescent",2,55.53,0]
[null,null,null,null,null,306,"2 x 40 W Fluorescent","306: 2 x 40 W Fluorescent",2,61.14,0]
[null,null,null,null,null,307,"50W Mercury","307: 50W Mercury",2,56.99,0]
[null,null,null,null,null,308,"50W Mercury","308: 50W Mercury",2,56.99,0]
[null,null,null,null,null,309,"80W Mercury","309: 80W Mercury",2,54.11,0]
[null,null,null,null,null,310,"80W Mercury","310: 80W Mercury",2,54.11,0]
[null,null,null,null,null,311,"80W Mercury","311: 80W Mercury",2,54.11,0]
[null,null,null,null,null,312,"80W Mercury","312: 80W Mercury",2,54.11,0]
[null,null,null,null,null,313,"80W Mercury","313: 80W Mercury",2,54.11,0]
[null,null,null,null,null,314,"80W Mercury","314: 80W Mercury",2,54.11,0]
[null,null,null,null,null,315,"80W Mercury","315: 80W Mercury",2,54.11,0]
[null,null,null,null,null,316,"125W Mercury","316: 125W Mercury",2,54.11,0]
[null,null,null,null,null,317,"125W Mercury","317: 125W Mercury",2,54.11,0]
[null,null,null,null,null,318,"125W Mercury","318: 125W Mercury",2,54.11,0]
[null,null,null,null,null,320,"250W Mercury","320: 250W Mercury",2,54.11,0]
[null,null,null,null,null,323,"250W Mercury","323: 250W Mercury",2,54.11,0]
[null,null,null,null,null,326,"400 W Mercury","326: 400 W Mercury",2,54.11,0]
[null,null,null,null,null,330,"400 W Mercury","330: 400 W Mercury",2,54.11,0]
[null,null,null,null,null,332,"70W Sodium","332: 70W Sodium",2,59.44,0]
[null,null,null,null,null,335,"50W Sodium","335: 50W Sodium",2,59.44,0]
[null,null,null,null,null,336,"70W Sodium","336: 70W Sodium",2,59.44,0]
[null,null,null,null,null,337,"70W Sodium","337: 70W Sodium",2,59.44,0]
[null,null,null,null,null,338,"150W Sodium","338: 150W Sodium",2,59.26,0]
[null,null,null,null,null,339,"150W Sodium","339: 150W Sodium",1,62.59,14.45]
[null,null,null,null,null,340,"150W Sodium","340: 150W Sodium",1,62.59,14.45]
[null,null,null,null,null,341,"150W Sodium","341: 150W Sodium",1,62.59,14.45]
[null,null,null,null,null,343,"250W Sodium","343: 250W Sodium",2,69.11,0]
[null,null,null,null,null,344,"250W Sodium","344: 250W Sodium",2,69.11,0]
[null,null,null,null,null,345,"250W Sodium","345: 250W Sodium",2,69.11,0]
[null,null,null,null,null,346,"250W Sodium","346: 250W Sodium",2,69.11,0]
[null,null,null,null,null,347,"250W Sodium","347: 250W Sodium",2,69.11,0]
[null,null,null,null,null,348,"250W Sodium","348: 250W Sodium",2,69.11,0]
[null,null,null,null,null,349,"250W Sodium","349: 250W Sodium",2,69.11,0]
[null,null,null,null,null,350,"2 x 250W Sodium","350: 2 x 250W Sodium",2,88.26,0]
[null,null,null,null,null,352,"400 W Sodium","352: 400 W Sodium",2,61.56,0]
[null,null,null,null,null,353,"400 W Sodium","353: 400 W Sodium",2,61.56,0]
[null,null,null,null,null,354,"400 W Sodium","354: 400 W Sodium",2,61.56,0]
[null,null,null,null,null,355,"400 W Sodium","355: 400 W Sodium",2,61.56,0]
[null,null,null,null,null,356,"400 W Sodium","356: 400 W Sodium",2,61.56,0]
[null,null,null,null,null,357,"400 W Sodium","357: 400 W Sodium",2,61.56,0]
[null,null,null,null,null,358,"2 x 400 W Sodium","358: 2 x 400 W Sodium",2,73.16,0]
[null,null,null,null,null,360,"2 x 400 W Sodium","360: 2 x 400 W Sodium",2,73.16,0]
[null,null,null,null,null,361,"2 x 400 W Sodium","361: 2 x 400 W Sodium",2,73.16,0]
[null,null,null,null,null,365,"150 W Metal Halide","365: 150 W Metal Halide",2,73.39,0]
[null,null,null,null,null,366,"250 W Metal Halide","366: 250 W Metal Halide",2,70.59,0]
[null,null,null,null,null,380,"100W Sodium","380: 100W Sodium",2,63.59,0]
[null,null,null,null,null,381,"100W Sodium","381: 100W Sodium",2,63.59,0]
[null,null,null,null,null,396,"400 W Metal Halide","396: 400 W Metal Halide",2,69.13,0]
[null,null,null,null,null,398,"2 x 20 W Fluorescent","398: 2 x 20 W Fluorescent",1,57.19,0]
[null,null,null,null,null,400,"150 W Metal Halide","400: 150 W Metal Halide",2,73.39,0]
[null,null,null,null,null,401,"125W Mercury","401: 125W Mercury",2,54.11,0]
[null,null,null,null,null,402,"250 W Metal Halide","402: 250 W Metal Halide",2,70.59,0]
[null,null,null,null,null,403,"2 x 250 W Metal Halide","403: 2 x 250 W Metal Halide",2,91.24,0]
[null,null,null,null,null,404,"400 W Metal Halide","404: 400 W Metal Halide",2,69.13,0]
[null,null,null,null,null,405,"2 x 400 W Metal Halide","405: 2 x 400 W Metal Halide",2,88.31,0]
[null,null,null,null,null,410,"150 W Metal Halide","410: 150 W Metal Halide",2,73.39,0]
[null,null,null,null,null,411,"100 W Metal Halide","411: 100 W Metal Halide",2,84.17,0]
[null,null,null,null,null,412,"100 W Metal Halide","412: 100 W Metal Halide",2,84.17,0]
[null,null,null,null,null,413,"2 x 14 W Fluorescent","413: 2 x 14 W Fluorescent",2,53.57,0]
[null,null,null,null,null,414,"2 x 24 W Fluorescent","414: 2 x 24 W Fluorescent",2,53.57,0]
[null,null,null,null,null,415,"2 x 14 W Fluorescent","415: 2 x 14 W Fluorescent",2,53.57,0]
[null,null,null,null,null,416,"2 x 24 W Fluorescent","416: 2 x 24 W Fluorescent",2,53.57,0]
[null,null,null,null,null,421,"1 x 42 W Fluorescent","421: 1 x 42 W Fluorescent",2,55.53,0]
[null,null,null,null,null,422,"1 x 42 W Fluorescent","422: 1 x 42 W Fluorescent",2,55.53,0]
[null,null,null,null,null,423,"Outreach Minor (<=2m)","423: Outreach Minor (<=2m)",2,15.78,0]
[null,null,null,null,null,424,"Outreach Major (>2m)","424: Outreach Major (>2m)",2,15.78,0]
[null,null,null,null,null,425,"Minor Column (<=9)","425: Minor Column (<=9)",2,20.62,0]
[null,null,null,null,null,426,"Major Column (>=9)","426: Major Column (>=9)",2,20.62,0]
[null,null,null,null,null,427,"Pole mounting bracket minor (<=3m)","427: Pole mounting bracket minor (<=3m)",2,15.78,0]
[null,null,null,null,null,428,"Pole mounting bracket major (>3m)","428: Pole mounting bracket major (>3m)",2,15.78,0]
[null,null,null,null,null,431,"24W LED STREETLED3 STD Visor S-S","431: 24W LED STREETLED3 STD Visor S-S",3,82.58,370.6,339.36,309.18,280.02,251.84,224.66,198.42,173.11,148.68,125.1,102.35,80.400000000000006,59.21,38.770000000000003,19.04,0,0,0,0,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,432,"17W LED STREETLED3 Aeroscreen S-S","432: 17W LED STREETLED3 Aeroscreen S-S",3,80.11,343.27,314.35000000000002,286.39999999999998,259.38,233.29,208.11,183.8,160.35,137.72,115.88,94.81,74.47,54.85,35.909999999999997,17.64,0,0,0,0,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,433,"13W LED STREETLED3 STD Visor S-S","433: 13W LED STREETLED3 STD Visor S-S",3,79.709999999999994,338.72,310.18,282.60000000000002,255.95,230.2,205.35,181.37,158.22999999999999,135.9,114.35,93.55,73.489999999999995,54.12,35.44,17.399999999999999,0,0,0,0,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,434,"9W LED STREETLED Aeroscreen S-S","434: 9W LED STREETLED Aeroscreen S-S",3,79.709999999999994,338.72,310.18,282.60000000000002,255.95,230.2,205.35,181.37,158.22999999999999,135.9,114.35,93.55,73.489999999999995,54.12,35.44,17.399999999999999,0,0,0,0,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,435,"17W LED Post Top B2001 S-S","435: 17W LED Post Top B2001 S-S",3,111.66,693.91,635.34,578.78,524.16999999999996,471.43,420.54,371.43,324.04000000000002,278.31,234.18,191.59,150.5,110.84,72.569999999999993,35.64,0,0,0,0,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,436,"28W LED Post Top B2001 S-S","436: 28W LED Post Top B2001 S-S",3,114.55,725.79,664.52,605.36,548.24,493.08,439.86,388.49,338.93,291.08999999999997,244.94,200.39,157.41,115.93,75.900000000000006,37.28,0,0,0,0,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,437,"18W LED Bourke Hill S-S","437: 18W LED Bourke Hill S-S",3,125.61,848.74,777.08,707.89,641.08000000000004,576.59,514.35,454.28,396.32,340.39,286.42,234.33,184.07,135.56,88.76,43.59,0,0,0,0,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,438,"24W LED Bourke Hill S-S","438: 24W LED Bourke Hill S-S",3,127.66,871.51,797.92,726.88,658.28,592.04999999999995,528.14,466.47,406.95,349.52,294.10000000000002,240.62,189,139.19999999999999,91.14,44.76,0,0,0,0,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,439,"37W LED 4K ROADLED MIDI STD Visor S-S","439: 37W LED 4K ROADLED MIDI STD Visor S-S",3,97.16,532.57000000000005,487.64,444.25,402.33,361.85,322.79000000000002,285.10000000000002,248.73,213.62,179.75,147.06,115.52,85.08,55.7,27.36,0,0,0,0,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,440,"40W LED 3K ROADLED MIDI STD Visor S-S","440: 40W LED 3K ROADLED MIDI STD Visor S-S",3,97.16,532.57000000000005,487.64,444.25,402.33,361.85,322.79000000000002,285.10000000000002,248.73,213.62,179.75,147.06,115.52,85.08,55.7,27.36,0,0,0,0,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,441,"36W LED 4K ROADLED MIDI Aeroscreen S-S","441: 36W LED 4K ROADLED MIDI Aeroscreen S-S",3,97.16,532.57000000000005,487.64,444.25,402.33,361.85,322.79000000000002,285.10000000000002,248.73,213.62,179.75,147.06,115.52,85.08,55.7,27.36,0,0,0,0,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,442,"39W LED 3K ROADLED MIDI Aeroscreen S-S","442: 39W LED 3K ROADLED MIDI Aeroscreen S-S",3,97.16,532.57000000000005,487.64,444.25,402.33,361.85,322.79000000000002,285.10000000000002,248.73,213.62,179.75,147.06,115.52,85.08,55.7,27.36,0,0,0,0,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,443,"55W LED 4K ROADLED MIDI STD Visor S-S","443: 55W LED 4K ROADLED MIDI STD Visor S-S",3,97.8,539.73,494.2,450.22,407.74,366.72,327.13,288.93,252.07,216.49,182.16,149.04,117.07,86.22,56.45,27.72,0,0,0,0,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,444,"61W LED 3K ROADLED MIDI STD Visor S-S","444: 61W LED 3K ROADLED MIDI STD Visor S-S",3,97.8,539.73,494.2,450.22,407.74,366.72,327.13,288.93,252.07,216.49,182.16,149.04,117.07,86.22,56.45,27.72,0,0,0,0,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,445,"57W LED 4K ROADLED MIDI Aeroscreen S-S","445: 57W LED 4K ROADLED MIDI Aeroscreen S-S",3,97.8,539.73,494.2,450.22,407.74,366.72,327.13,288.93,252.07,216.49,182.16,149.04,117.07,86.22,56.45,27.72,0,0,0,0,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,446,"63W LED 3K ROADLED MIDI Aerosreen S-S","446: 63W LED 3K ROADLED MIDI Aerosreen S-S",3,97.8,539.73,494.2,450.22,407.74,366.72,327.13,288.93,252.07,216.49,182.16,149.04,117.07,86.22,56.45,27.72,0,0,0,0,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,447,"113W LED ROADLED MIDI STD Visor S-S","447: 113W LED ROADLED MIDI STD Visor S-S",3,100.35,568.05999999999995,520.12,473.83,429.13,385.95,344.29,304.08999999999997,265.29000000000002,227.85,191.72,156.86000000000001,123.21,90.74,59.41,29.18,0,0,0,0,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,448,"120W LED 4K ROADLED MIDI Aeroscreen S-S","448: 120W LED 4K ROADLED MIDI Aeroscreen S-S",3,100.35,568.05999999999995,520.12,473.83,429.13,385.95,344.29,304.08999999999997,265.29000000000002,227.85,191.72,156.86000000000001,123.21,90.74,59.41,29.18,0,0,0,0,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,449,"121W LED 3K ROADLED MIDI Aeroscreen S-S","449: 121W LED 3K ROADLED MIDI Aeroscreen S-S",3,100.35,568.05999999999995,520.12,473.83,429.13,385.95,344.29,304.08999999999997,265.29000000000002,227.85,191.72,156.86000000000001,123.21,90.74,59.41,29.18,0,0,0,0,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,450,"275W LED ROADLED S-S","450: 275W LED ROADLED S-S",3,129.69999999999999,894.28,818.77,745.86,675.47,607.51,541.94000000000005,478.65,417.58,358.65,301.77999999999997,246.9,193.94,142.83000000000001,93.52,45.93,0,0,0,0,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,451,"254W LED 3K ROADLED MIDI STD Visor S-S","451: 254W LED 3K ROADLED MIDI STD Visor S-S",3,129.69999999999999,894.28,818.77,745.86,675.47,607.51,541.94000000000005,478.65,417.58,358.65,301.77999999999997,246.9,193.94,142.83000000000001,93.52,45.93,0,0,0,0,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,452,"230W LED Avento S-S","452: 230W LED Avento S-S",3,101.99,586.20000000000005,536.73,488.96,442.83,398.28,355.28,313.8,273.76,235.12,197.84,161.86000000000001,127.14,93.64,61.31,30.11,0,0,0,0,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,453,"205W LED 3K ROADLED MIDI Aeroscreen S-S","453: 205W LED 3K ROADLED MIDI Aeroscreen S-S",3,129.69999999999999,894.28,818.77,745.86,675.47,607.51,541.94000000000005,478.65,417.58,358.65,301.77999999999997,246.9,193.94,142.83000000000001,93.52,45.93,0,0,0,0,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,454,"30W LED ATS PLED MKII","454: 30W LED ATS PLED MKII",3,84.63,393.37,360.2,328.16,297.20999999999998,267.31,238.45,210.61,183.74,157.81,132.78,108.64,85.33,62.85,41.15,20.21,0,0,0,0,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,455,"20W LED ATS PLED MKII","455: 20W LED ATS PLED MKII",3,79.31,334.35,306.18,278.95,252.64,227.23,202.7,179.03,156.19,134.13999999999999,112.87,92.35,72.540000000000006,53.42,34.979999999999997,17.18,0,0,0,0,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,456,"13W LED ATS PLED MKII","456: 13W LED ATS PLED MKII",3,78.06,320.41000000000003,293.42,267.33,242.12,217.76,194.26,171.57,149.68,128.56,108.17,88.5,69.52,51.2,33.520000000000003,16.46,0,0,0,0,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,457,"74W LED ATS VLED","457: 74W LED ATS VLED",3,87.9,429.8,393.55,358.54,324.72000000000003,292.05,260.52999999999997,230.1,200.74,172.41,145.07,118.69,93.23,68.67,44.96,22.08,0,0,0,0,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,458,"155W LED ATS VLED","458: 155W LED ATS VLED",3,93.64,493.55,451.92,411.7,372.86,335.35,299.14999999999998,264.22000000000003,230.51,197.98,166.58,136.29,107.06,78.849999999999994,51.62,25.35,0,0,0,0,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,459,"290W LED ATS VLED","459: 290W LED ATS VLED",3,109.78,672.96,616.16,561.32000000000005,508.35,457.21,407.85,360.23,314.27,269.91000000000003,227.11,185.81,145.96,107.5,70.38,34.56,0,0,0,0,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,551,"2x14W Energy Efficient Fluro - STD","551: 2x14W Energy Efficient Fluro - STD",3,87.33,410.04,380.95,352.84,325.68,299.44,274.13,249.7,226.12,203.37,181.42,160.24,139.79,120.06,101.03,82.65,64.92,47.82,31.31,15.37,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,552,"2x24W Energy Efficient Fluro - STD","552: 2x24W Energy Efficient Fluro - STD",3,90.02,442.96,411.52,381.15,351.81,323.47000000000003,296.13,269.74,244.27,219.69,195.98,173.09,151.01,129.69999999999999,109.13,89.29,70.13,51.65,33.82,16.61,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,553,"1x42W Compact Fluorescent - STD","553: 1x42W Compact Fluorescent - STD",3,84.95,356.5,331.22,306.77999999999997,283.17,260.36,238.35,217.11,196.61,176.83,157.74,139.32,121.55,104.39,87.84,71.87,56.45,41.58,27.22,13.37,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,554,"50W Mercury - STANDARD","554: 50W Mercury - STANDARD",3,82.76,311.70999999999998,289.61,268.25,247.61,227.67,208.42,189.85,171.92,154.62,137.93,121.83,106.28,91.28,76.81,62.84,49.36,36.35,23.8,11.69,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,555,"80W Mercury - STANDARD","555: 80W Mercury - STANDARD",3,82.73,346.97,322.37,298.58999999999997,275.61,253.41,231.98,211.31,191.36,172.11,153.53,135.6,118.3,101.6,85.49,69.95,54.94,40.46,26.49,13.01,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,556,"70W Sodium - STANDARD","556: 70W Sodium - STANDARD",3,88.43,350.68,325.8,301.77,278.55,256.11,234.46,213.56,193.4,173.94,155.16999999999999,137.05000000000001,119.56,102.69,86.4,70.69,55.53,40.9,26.78,13.15,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,557,"100W Sodium - STANDARD","557: 100W Sodium - STANDARD",3,98.72,426.06,395.83,366.62,338.4,311.14,284.83,259.45,234.95,211.32,188.51,166.49,145.25,124.75,104.97,85.88,67.459999999999994,49.68,32.53,15.97,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,558,"100W Metal Halide - STANDARD","558: 100W Metal Halide - STANDARD",3,120.93,443.86,412.36,381.92,352.53,324.13,296.73,270.27999999999997,244.77,220.14,196.38,173.44,151.32,129.96,109.35,89.47,70.28,51.76,33.89,16.64,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,559,"150W Sodium - STANDARD","559: 150W Sodium - STANDARD",3,93.16,411,381.83,353.66,326.43,300.14,274.77,250.28,226.65,203.85,181.84,160.61000000000001,140.12,120.34,101.26,82.85,65.08,47.93,31.38,15.41,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,560,"150W Metal Halide - STANDARD","560: 150W Metal Halide - STANDARD",3,108.38,423.2,393.17,364.15,336.12,309.05,282.92,257.70999999999998,233.38,209.9,187.24,165.37,144.28,123.91,104.27,85.3,67.010000000000005,49.35,32.31,15.87,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,561,"250W Sodium - STANDARD","561: 250W Sodium - STANDARD",3,104.99,434.52,403.68,373.89,345.11,317.31,290.48,264.58999999999997,239.61,215.51,192.24,169.79,148.13,127.23,107.05,87.58,68.8,50.67,33.17,16.29,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,562,"250W Metal Halide - STANDARD","562: 250W Metal Halide - STANDARD",3,106.58,435.81,404.87,375,346.13,318.25,291.33999999999997,265.38,240.32,216.15,192.81,170.3,148.57,127.6,107.37,87.84,69,50.82,33.270000000000003,16.34,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,563,"400W Sodium - STANDARD","563: 400W Sodium - STANDARD",3,103.29,507.18,471.17,436.39,402.79,370.35,339.04,308.82,279.67,251.53,224.38,198.18,172.89,148.49,124.95,102.22,80.3,59.14,38.72,19.010000000000002,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,564,"80W Mercury - AEROSCREEN","564: 80W Mercury - AEROSCREEN",3,111.71,346.97,322.37,298.58999999999997,275.61,253.41,231.98,211.31,191.36,172.11,153.53,135.6,118.3,101.6,85.49,69.95,54.94,40.46,26.49,13.01,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,565,"150W Sodium - AEROSCREEN","565: 150W Sodium - AEROSCREEN",3,96.69,454.56,422.29,391.13,361.02,331.94,303.88,276.8,250.66,225.44,201.11,177.62,154.96,133.09,111.99,91.62,71.97,53,34.700000000000003,17.04,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,566,"150W Metal Halide - AEROSCREEN","566: 150W Metal Halide - AEROSCREEN",3,111.93,466.76,433.63,401.62,370.7,340.84,312.02999999999997,284.22000000000003,257.39,231.49,206.5,182.39,159.12,136.66,114.99,94.08,73.900000000000006,54.43,35.630000000000003,17.5,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,567,"25W LED P4 Gerard","567: 25W LED P4 Gerard",3,85.2,385.46,352.96,321.57,291.24,261.94,233.66,206.38,180.05,154.63999999999999,130.12,106.45,83.62,61.59,40.32,19.8,0,0,0,0,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,568,"250W Sodium (w/o PECB) - AEROSCREEN","568: 250W Sodium (w/o PECB) - AEROSCREEN",3,106.49,453.12,420.95,389.89,359.87,330.88,302.91000000000003,275.92,249.87,224.73,200.47,177.06,154.47,132.66999999999999,111.63,91.33,71.739999999999995,52.84,34.590000000000003,16.989999999999998,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,569,"250W Metal Halide - AEROSCREEN","569: 250W Metal Halide - AEROSCREEN",3,108.11,454.4,422.15,390.99,360.89,331.82,303.77,276.7,250.58,225.37,201.04,177.56,154.91,133.05000000000001,111.95,91.59,71.95,52.99,34.69,17.04,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,570,"400W Sodium - AEROSCREEN","570: 400W Sodium - AEROSCREEN",3,102.31,495.21,460.05,426.09,393.29,361.61,331.04,301.54000000000002,273.07,245.6,219.09,193.5,168.81,144.99,122,99.81,78.400000000000006,57.74,37.81,18.57,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,571,"400W Metal Halide - AEROSCREEN","571: 400W Metal Halide - AEROSCREEN",3,110.46,501.75,466.12,431.72,398.48,366.38,335.41,305.52,276.67,248.84,221.98,196.06,171.04,146.9,123.61,101.13,79.44,58.51,38.299999999999997,18.809999999999999,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,572,"80W Mercury - POST TOP","572: 80W Mercury - POST TOP",3,105.06,621.35,577.21,534.59,493.43,453.69,415.33,378.32,342.6,308.13,274.87,242.77,211.8,181.91,153.06,125.23,98.37,72.45,47.43,23.29,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,573,"250W Sodium - FLOODLIGHT","573: 250W Sodium - FLOODLIGHT",3,121.67,639.54,594.12,550.25,507.88,466.97,427.49,389.39,352.63,317.14999999999998,282.92,249.88,218,187.23,157.54,128.88999999999999,101.25,74.569999999999993,48.82,23.98,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,574,"250W Metal Halide - FLOODLIGHT","574: 250W Metal Halide - FLOODLIGHT",3,123.27,640.83000000000004,595.30999999999995,551.35,508.9,467.91,428.35,390.18,353.34,317.79000000000002,283.49,250.38,218.44,187.61,157.86000000000001,129.15,101.45,74.72,48.92,24.02,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,575,"400W Sodium - FLOODLIGHT","575: 400W Sodium - FLOODLIGHT",3,115.51,657.43,610.73,565.63,522.08000000000004,480.02,439.44,400.28,362.49,326.02,290.83,256.87,224.09,192.47,161.94999999999999,132.5,104.08,76.650000000000006,50.19,24.65,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,576,"400W Metal Halide - FLOODLIGHT","576: 400W Metal Halide - FLOODLIGHT",3,123.69,663.97,616.79999999999995,571.25,527.27,484.8,443.81,404.26,366.09,329.26,293.72000000000003,259.42,226.32,194.38,163.56,133.82,105.11,77.41,50.68,24.89,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,577,"Suburban 70W HPS c/w D2 PECB - STD","577: Suburban 70W HPS c/w D2 PECB - STD",3,88.43,350.68,325.8,301.77,278.55,256.11,234.46,213.56,193.4,173.94,155.16999999999999,137.05000000000001,119.56,102.69,86.4,70.69,55.53,40.9,26.78,13.15,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,578,"Urban A/Screen 42W CFL c/w D2 PECB","578: Urban A/Screen 42W CFL c/w D2 PECB",3,92.46,448.58,416.74,385.98,356.27,327.57,299.88,273.16000000000003,247.37,222.48,198.46,175.29,152.91999999999999,131.34,110.52,90.42,71.02,52.31,34.25,16.82,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,579,"Roadster A/Screen 100W HPS c/w PECB","579: Roadster A/Screen 100W HPS c/w PECB",3,98.72,426.06,395.83,366.62,338.4,311.14,284.83,259.45,234.95,211.32,188.51,166.49,145.25,124.75,104.97,85.88,67.459999999999994,49.68,32.53,15.97,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,580,"B2001 42WCFL c/w D2 PECB green - PT","580: B2001 42WCFL c/w D2 PECB green - PT",3,110.91,675.22,627.25,580.92999999999995,536.20000000000005,493.01,451.33,411.11,372.29,334.84,298.69,263.81,230.15,197.67,166.33,136.08000000000001,106.89,78.73,51.54,25.31,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,581,"150W Sodium - FLOODLIGHT","581: 150W Sodium - FLOODLIGHT",3,110.65,625.73,581.28,538.36,496.91,456.88,418.26,380.98,345.01,310.3,276.81,244.48,213.29,183.19,154.13999999999999,126.11,99.06,72.959999999999994,47.77,23.46,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,582,"150W Metal Halide - FLOODLIGHT","582: 150W Metal Halide - FLOODLIGHT",3,125.86,637.91999999999996,592.61,548.85,506.59,465.78,426.4,388.4,351.73,316.35000000000002,282.2,249.25,217.45,186.76,157.13999999999999,128.57,100.99,74.38,48.7,23.91,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,583,"1x42W Compact Fluorescent - STD","583: 1x42W Compact Fluorescent - STD",3,84.95,356.5,331.22,306.77999999999997,283.17,260.36,238.35,217.11,196.61,176.83,157.74,139.32,121.55,104.39,87.84,71.87,56.45,41.58,27.22,13.37,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,584,"250W Sodium - STANDARD","584: 250W Sodium - STANDARD",3,104.99,434.52,403.68,373.89,345.11,317.31,290.48,264.58999999999997,239.61,215.51,192.24,169.79,148.13,127.23,107.05,87.58,68.8,50.67,33.17,16.29,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,585,"18W LED P4 Gerard","585: 18W LED P4 Gerard",3,85.2,385.46,352.96,321.57,291.24,261.94,233.66,206.38,180.05,154.63999999999999,130.12,106.45,83.62,61.59,40.32,19.8,0,0,0,0,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,586,"42W LED P3 Gerard","586: 42W LED P3 Gerard",3,88.79,422.51,386.88,352.47,319.22000000000003,287.10000000000002,256.11,226.2,197.34,169.49,142.62,116.68,91.65,67.5,44.2,21.7,0,0,0,0,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,587,"33W LED P4 Pecan","587: 33W LED P4 Pecan",3,92.35,459.39,420.65,383.22,347.07,312.14999999999998,278.45999999999998,245.94,214.56,184.28,155.06,126.86,99.65,73.39,48.05,23.6,0,0,0,0,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,588,"25W LED P4 GE","588: 25W LED P4 GE",3,85.2,385.46,352.97,321.57,291.24,261.94,233.66,206.38,180.05,154.63999999999999,130.12,106.45,83.62,61.59,40.32,19.8,0,0,0,0,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,589,"17W LED Cat P Luminaire","589: 17W LED Cat P Luminaire",3,85.2,385.46,352.97,321.57,291.24,261.94,233.66,206.38,180.05,154.63999999999999,130.12,106.45,83.62,61.59,40.32,19.8,0,0,0,0,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,590,"Bracket - Minor <=3m","590: Bracket - Minor <=3m",3,21.71,101.63,96.57,91.69,86.98,82.43,78.03,73.790000000000006,69.7,65.75,61.94,58.27,54.72,51.29,47.99,44.8,41.72,38.76,35.89,33.119999999999997,30.46,27.88,25.4,23,20.69,18.45,16.3,14.22,12.21,10.28,8.41,6.6,4.8600000000000003,3.18,1.56,0,0,0,0,0,0,0,0]
[null,null,null,null,null,591,"Bracket - Major >3m","591: Bracket - Major >3m",3,51.75,628.91999999999996,597.6,567.38,538.19000000000005,510.02,482.84,456.6,431.29,406.86,383.28,360.53,338.58,317.39,296.95,277.22000000000003,258.18,239.81,222.08,204.97,188.46,172.52,157.15,142.31,127.99,114.18,100.85,87.98,75.56,63.58,52.02,40.86,30.09,19.7,9.68,0,0,0,0,0,0,0,0]
[null,null,null,null,null,595,"Pole (Wood) - Minor - DEDICATED SL <=11m","595: Pole (Wood) - Minor - DEDICATED SL <=11m",3,166.45,2563.96,2436.89,2314,2195.15,2080.25,1969.36,1862.36,1759.1,1659.46,1563.3,1470.51,1380.96,1294.55,1211.1600000000001,1130.69,1053.04,978.1,905.79,836,768.66,703.68,640.97,580.45000000000005,522.05999999999995,465.7,411.32,358.84,308.2,259.33,212.17,166.66,122.74,80.36,39.47,0,0,0,0,0,0,0,0]
[null,null,null,null,null,596,"Pole (Wood) - Major - DEDICATED SL >11m","596: Pole (Wood) - Major - DEDICATED SL >11m",3,291.33,4762.21,4526.21,4297.9799999999996,4077.23,3863.81,3657.86,3459.11,3267.32,3082.24,2903.64,2731.29,2564.9699999999998,2404.4699999999998,2249.59,2100.13,1955.89,1816.71,1682.39,1552.78,1427.7,1307,1190.53,1078.1300000000001,969.66,864.99,763.98,666.51,572.44000000000005,481.67,394.08,309.55,227.98,149.26,73.3,0,0,0,0,0,0,0,0]
[null,null,null,null,null,597,"Pole (Wood) - Minor   <=11m","597: Pole (Wood) - Minor   <=11m",3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,598,"Pole (Wood) - Major  >11m","598: Pole (Wood) - Major  >11m",3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,650,"82W LED Gerard V5 Cat Luminaire","650: 82W LED Gerard V5 Cat Luminaire",3,113.71,680.25,622.83000000000004,567.39,513.85,462.15,412.27,364.12,317.67,272.83999999999997,229.57,187.82,147.54,108.66,71.14,34.94,0,0,0,0,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,651,"100W LED Gerard V4 Cat Luminaire","651: 100W LED Gerard V4 Cat Luminaire",3,113.71,680.25,622.83000000000004,567.39,513.85,462.15,412.27,364.12,317.67,272.83999999999997,229.57,187.82,147.54,108.66,71.14,34.94,0,0,0,0,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,652,"198W LED Gerard V2/V3 Cat Luminaire","652: 198W LED Gerard V2/V3 Cat Luminaire",3,125.16,798.65,731.22,666.12,603.26,542.57000000000005,484,427.48,372.94,320.31,269.52,220.5,173.21,127.56,83.52,41.02,0,0,0,0,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,653,"33W LED P3 Gerard","653: 33W LED P3 Gerard",3,88.79,422.51,386.88,352.47,319.22000000000003,287.10000000000002,256.11,226.2,197.34,169.49,142.62,116.68,91.65,67.5,44.2,21.7,0,0,0,0,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,655,"75W LED Aglo Nilum Plus FLOODLIGHT","655: 75W LED Aglo Nilum Plus FLOODLIGHT",3,101.85,566.41,518.62,472.46,427.88,384.83,343.29,303.20999999999998,264.52,227.19,191.16,156.4,122.85,90.48,59.24,29.09,0,0,0,0,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,656,"100W LED Aglo Nilum Plus FLOODLIGHT","656: 100W LED Aglo Nilum Plus FLOODLIGHT",3,104,589.17999999999995,539.46,491.45,445.08,400.3,357.09,315.39,275.14999999999998,236.32,198.85,162.69,127.79,94.12,61.62,30.26,0,0,0,0,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,657,"150W LED Aglo Nilum Plus FLOODLIGHT","657: 150W LED Aglo Nilum Plus FLOODLIGHT",3,108.3,634.71,581.15,529.41999999999996,479.46,431.23,384.68,339.76,296.41000000000003,254.58,214.21,175.25,137.66,101.39,66.38,32.6,0,0,0,0,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,658,"300W LED Aglo Nilum Plus FLOODLIGHT","658: 300W LED Aglo Nilum Plus FLOODLIGHT",3,135.25,920.23,842.53,767.51,695.07,625.14,557.66,492.54,429.7,369.06,310.54000000000002,254.06,199.57,146.97999999999999,96.23,47.26,0,0,0,0,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,659,"60W LED RoadLED Midi Optic Tuner","659: 60W LED RoadLED Midi Optic Tuner",3,103.11,589.17999999999995,539.46,491.45,445.08,400.3,357.09,315.39,275.14999999999998,236.32,198.85,162.69,127.79,94.12,61.62,30.26,0,0,0,0,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,660,"80W LED RoadLED Midi Optic Tuner","660: 80W LED RoadLED Midi Optic Tuner",3,109.82,662.04,606.16,552.20000000000005,500.1,449.78,401.23,354.38,309.16000000000003,265.52999999999997,223.43,182.8,143.59,105.75,69.239999999999995,34,0,0,0,0,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,661,"70W LED RoadLED Midi","661: 70W LED RoadLED Midi",3,98.06,534.53,489.43,445.88,403.81,363.18,323.98,286.14999999999998,249.64,214.41,180.41,147.6,115.94,85.39,55.91,27.46,0,0,0,0,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,662,"80W LED RoadLED Midi","662: 80W LED RoadLED Midi",3,99.76,552.75,506.11,461.07,417.57,375.56,335.02,295.89,258.14,221.71,186.56,152.63,119.89,88.3,57.81,28.39,0,0,0,0,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,664,"165W LED RoadLED Midi","664: 165W LED RoadLED Midi",3,101.01,566.41,518.62,472.46,427.88,384.83,343.29,303.20999999999998,264.52,227.19,191.16,156.4,122.85,90.48,59.24,29.09,0,0,0,0,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,665,"17W LED B2001 NUWE Post Top","665: 17W LED B2001 NUWE Post Top",3,112.76,693.91,635.34,578.78,524.16999999999996,471.43,420.54,371.43,324.04000000000002,278.31,234.18,191.59,150.5,110.84,72.569999999999993,35.64,0,0,0,0,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,667,"150W LED SLED Maximus Pedestrian","667: 150W LED SLED Maximus Pedestrian",3,118.64,757.66,693.7,631.94000000000005,572.30999999999995,514.73,459.17,405.55,353.81,303.87,255.69,209.19,164.32,121.02,79.23,38.909999999999997,0,0,0,0,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,668,"175W LED SLED Maximus Pedestrian","668: 175W LED SLED Maximus Pedestrian",3,128.30000000000001,862.4,789.58,719.28,651.4,585.86,522.62,461.59,402.7,345.87,291.02999999999997,238.1,187.03,137.74,90.18,44.29,0,0,0,0,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,690,"Outreach - Minor <=2m","690: Outreach - Minor <=2m",3,23.14,126.85,120.54,114.44,108.56,102.88,97.39,92.1,86.99,82.07,77.31,72.72,68.290000000000006,64.02,59.9,55.92,52.08,48.37,44.79,41.34,38.01,34.799999999999997,31.7,28.71,25.82,23.03,20.34,17.75,15.24,12.82,10.49,8.24,6.07,3.97,1.95,0,0,0,0,0,0,0,0]
[null,null,null,null,null,691,"Outreach - Major >2m","691: Outreach - Major >2m",3,30.82,261.83,248.82,236.24,224.1,212.37,201.05,190.13,179.58,169.41,159.59,150.12,140.97999999999999,132.16,123.65,115.43,107.5,99.85,92.47,85.35,78.47,71.84,65.44,59.26,53.3,47.54,41.99,36.630000000000003,31.46,26.47,21.66,17.010000000000002,12.53,8.1999999999999993,4.03,0,0,0,0,0,0,0,0]
[null,null,null,null,null,695,"Column (Steel) - Minor <=9m","695: Column (Steel) - Minor <=9m",3,170.91,2642.17,2511.1999999999998,2384.5500000000002,2262.0700000000002,2143.66,2029.4,1919.13,1812.72,1710.04,1610.95,1515.33,1423.06,1334.01,1248.08,1165.1600000000001,1085.1400000000001,1007.92,933.4,861.49,792.1,725.13,660.51,598.15,537.97,479.9,423.86,369.78,317.58999999999997,267.23,218.64,171.74,126.48,82.81,40.67,0,0,0,0,0,0,0,0]
[null,null,null,null,null,696,"Column (Steel) - Major >9m","696: Column (Steel) - Major >9m",3,313.06,5143.32,4888.32,4641.76,4403.33,4172.83,3950.41,3735.77,3528.64,3328.76,3135.87,2949.74,2770.11,2596.7800000000002,2429.5100000000002,2268.09,2112.3200000000002,1962.01,1816.95,1676.97,1541.89,1411.53,1285.74,1164.3499999999999,1047.21,934.17,825.08,719.81,618.23,520.20000000000005,425.6,334.31,246.21,161.19999999999999,79.17,0,0,0,0,0,0,0,0]
[null,null,null,null,null,755,"24W LED STREETLED3 STD Visor S-S","755: 24W LED STREETLED3 STD Visor S-S",4,51.31,24.03,20.69,17.46,14.34,12.9,11.51,10.16,8.8699999999999992,7.62,6.41,5.24,4.12,3.03,1.99,0.98,0,0,0,0,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,756,"17W LED STREETLED3 Aeroscreen S-S","756: 17W LED STREETLED3 Aeroscreen S-S",4,51.05,21.11,18.010000000000002,15.03,12.14,10.92,9.74,8.6,7.5,6.44,5.42,4.4400000000000004,3.48,2.57,1.68,0.83,0,0,0,0,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,757,"13W LED STREETLED3 STD Visor S-S","757: 13W LED STREETLED3 STD Visor S-S",4,51,20.62,17.57,14.62,11.77,10.58,9.44,8.34,7.28,6.25,5.26,4.3,3.38,2.4900000000000002,1.63,0.8,0,0,0,0,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,758,"9W LED STREETLED Aeroscreen S-S","758: 9W LED STREETLED Aeroscreen S-S",4,51,20.62,17.57,14.62,11.77,10.58,9.44,8.34,7.28,6.25,5.26,4.3,3.38,2.4900000000000002,1.63,0.8,0,0,0,0,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,759,"17W LED Post Top B2001 S-S","759: 17W LED Post Top B2001 S-S",4,54.43,58.61,52.34,46.3,40.450000000000003,36.380000000000003,32.46,28.67,25.01,21.48,18.07,14.79,11.62,8.5500000000000007,5.6,2.75,0,0,0,0,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,760,"28W LED Post Top B2001 S-S","760: 28W LED Post Top B2001 S-S",4,54.74,62.02,55.47,49.14,43.03,38.700000000000003,34.520000000000003,30.49,26.6,22.85,19.22,15.73,12.35,9.1,5.96,2.93,0,0,0,0,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,761,"18W LED Bourke Hill S-S","761: 18W LED Bourke Hill S-S",4,55.92,75.17,67.5,60.1,52.96,47.63,42.49,37.53,32.74,28.12,23.66,19.36,15.21,11.2,7.33,3.6,0,0,0,0,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,762,"24W LED Bourke Hill S-S","762: 24W LED Bourke Hill S-S",4,56.14,77.599999999999994,69.73,62.13,54.8,49.28,43.96,38.83,33.880000000000003,29.1,24.48,20.03,15.73,11.59,7.59,3.73,0,0,0,0,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,763,"37W LED 4K ROADLED MIDI STD Visor S-S","763: 37W LED 4K ROADLED MIDI STD Visor S-S",4,52.87,41.35,36.549999999999997,31.91,27.42,24.67,22,19.43,16.95,14.56,12.25,10.02,7.87,5.8,3.8,1.86,0,0,0,0,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,764,"40W LED 3K ROADLED MIDI STD Visor S-S","764: 40W LED 3K ROADLED MIDI STD Visor S-S",4,52.87,41.35,36.549999999999997,31.91,27.42,24.67,22,19.43,16.95,14.56,12.25,10.02,7.87,5.8,3.8,1.86,0,0,0,0,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,765,"36W LED 4K ROADLED MIDI Aeroscreen S-S","765: 36W LED 4K ROADLED MIDI Aeroscreen S-S",4,52.87,41.35,36.549999999999997,31.91,27.42,24.67,22,19.43,16.95,14.56,12.25,10.02,7.87,5.8,3.8,1.86,0,0,0,0,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,766,"39W LED 3K ROADLED MIDI Aeroscreen S-S","766: 39W LED 3K ROADLED MIDI Aeroscreen S-S",4,52.87,41.35,36.549999999999997,31.91,27.42,24.67,22,19.43,16.95,14.56,12.25,10.02,7.87,5.8,3.8,1.86,0,0,0,0,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,767,"55W LED 4K ROADLED MIDI STD Visor S-S","767: 55W LED 4K ROADLED MIDI STD Visor S-S",4,52.93,42.12,37.25,32.549999999999997,28,25.19,22.47,19.84,17.309999999999999,14.87,12.51,10.24,8.0399999999999991,5.92,3.88,1.9,0,0,0,0,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,768,"61W LED 3K ROADLED MIDI STD Visor S-S","768: 61W LED 3K ROADLED MIDI STD Visor S-S",4,52.93,42.12,37.25,32.549999999999997,28,25.19,22.47,19.84,17.309999999999999,14.87,12.51,10.24,8.0399999999999991,5.92,3.88,1.9,0,0,0,0,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,769,"57W LED 4K ROADLED MIDI Aeroscreen S-S","769: 57W LED 4K ROADLED MIDI Aeroscreen S-S",4,52.93,42.12,37.25,32.549999999999997,28,25.19,22.47,19.84,17.309999999999999,14.87,12.51,10.24,8.0399999999999991,5.92,3.88,1.9,0,0,0,0,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,770,"63W LED 3K ROADLED MIDI Aerosreen S-S","770: 63W LED 3K ROADLED MIDI Aerosreen S-S",4,52.93,42.12,37.25,32.549999999999997,28,25.19,22.47,19.84,17.309999999999999,14.87,12.51,10.24,8.0399999999999991,5.92,3.88,1.9,0,0,0,0,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,771,"113W LED ROADLED MIDI STD Visor S-S","771: 113W LED ROADLED MIDI STD Visor S-S",4,53.22,45.15,40.020000000000003,35.07,30.29,27.24,24.3,21.46,18.73,16.079999999999998,13.53,11.07,8.6999999999999993,6.41,4.1900000000000004,2.06,0,0,0,0,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,772,"120W LED 4K ROADLED MIDI Aeroscreen S-S","772: 120W LED 4K ROADLED MIDI Aeroscreen S-S",4,53.22,45.15,40.020000000000003,35.07,30.29,27.24,24.3,21.46,18.73,16.079999999999998,13.53,11.07,8.6999999999999993,6.41,4.1900000000000004,2.06,0,0,0,0,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,773,"121W LED 3K ROADLED MIDI Aeroscreen S-S","773: 121W LED 3K ROADLED MIDI Aeroscreen S-S",4,53.22,45.15,40.020000000000003,35.07,30.29,27.24,24.3,21.46,18.73,16.079999999999998,13.53,11.07,8.6999999999999993,6.41,4.1900000000000004,2.06,0,0,0,0,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,774,"275W LED ROADLED S-S","774: 275W LED ROADLED S-S",4,56.35,80.040000000000006,71.959999999999994,64.17,56.64,50.94,45.44,40.130000000000003,35.01,30.07,25.3,20.7,16.260000000000002,11.98,7.84,3.85,0,0,0,0,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,775,"254W LED 3K ROADLED MIDI STD Visor S-S","775: 254W LED 3K ROADLED MIDI STD Visor S-S",4,56.35,80.040000000000006,71.959999999999994,64.17,56.64,50.94,45.44,40.130000000000003,35.01,30.07,25.3,20.7,16.260000000000002,11.98,7.84,3.85,0,0,0,0,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,776,"230W LED Avento S-S","776: 230W LED Avento S-S",4,53.39,47.09,41.8,36.69,31.76,28.56,25.48,22.5,19.63,16.86,14.19,11.61,9.1199999999999992,6.72,4.4000000000000004,2.16,0,0,0,0,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,777,"205W LED 3K ROADLED MIDI Aeroscreen S-S","777: 205W LED 3K ROADLED MIDI Aeroscreen S-S",4,56.35,80.040000000000006,71.959999999999994,64.17,56.64,50.94,45.44,40.130000000000003,35.01,30.07,25.3,20.7,16.260000000000002,11.98,7.84,3.85,0,0,0,0,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,778,"30W LED ATS PLED MKII","778: 30W LED ATS PLED MKII",4,51.53,26.47,22.92,19.489999999999998,16.18,14.55,12.98,11.47,10,8.59,7.23,5.91,4.6500000000000004,3.42,2.2400000000000002,1.1000000000000001,0,0,0,0,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,779,"20W LED ATS PLED MKII","779: 20W LED ATS PLED MKII",4,50.97,20.149999999999999,17.14,14.23,11.42,10.27,9.16,8.09,7.06,6.06,5.0999999999999996,4.17,3.28,2.41,1.58,0.78,0,0,0,0,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,780,"13W LED ATS PLED MKII","780: 13W LED ATS PLED MKII",4,50.83,18.66,15.78,12.99,10.29,9.25,8.26,7.29,6.36,5.46,4.5999999999999996,3.76,2.95,2.1800000000000002,1.42,0.7,0,0,0,0,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,781,"74W LED ATS VLED","781: 74W LED ATS VLED",4,51.89,30.36,26.49,22.74,19.12,17.2,15.34,13.55,11.82,10.15,8.5399999999999991,6.99,5.49,4.04,2.65,1.3,0,0,0,0,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,782,"155W LED ATS VLED","782: 155W LED ATS VLED",4,52.49,37.18,32.729999999999997,28.43,24.27,21.83,19.47,17.2,15.01,12.89,10.84,8.8699999999999992,6.97,5.13,3.36,1.65,0,0,0,0,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,783,"290W LED ATS VLED","783: 290W LED ATS VLED",4,54.22,56.37,50.29,44.43,38.76,34.86,31.1,27.47,23.96,20.58,17.32,14.17,11.13,8.1999999999999993,5.37,2.64,0,0,0,0,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,851,"2x14W Energy Efficient Fluro - STD","851: 2x14W Energy Efficient Fluro - STD",4,58.13,50.89,47.28,43.79,40.42,37.17,34.020000000000003,30.99,28.07,25.24,22.52,19.89,17.350000000000001,14.9,12.54,10.26,8.06,5.93,3.89,1.91,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,852,"2x24W Energy Efficient Fluro - STD","852: 2x24W Energy Efficient Fluro - STD",4,58.48,54.98,51.08,47.31,43.66,40.15,36.75,33.479999999999997,30.32,27.27,24.32,21.48,18.739999999999998,16.100000000000001,13.54,11.08,8.6999999999999993,6.41,4.2,2.06,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,853,"1x42W Compact Fluorescent - STD","853: 1x42W Compact Fluorescent - STD",4,59.6,44.25,41.11,38.08,35.15,32.31,29.58,26.95,24.4,21.95,19.579999999999998,17.29,15.09,12.96,10.9,8.92,7.01,5.16,3.38,1.66,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,854,"50W Mercury - STANDARD","854: 50W Mercury - STANDARD",4,60.58,38.69,35.94,33.29,30.73,28.26,25.87,23.56,21.34,19.190000000000001,17.12,15.12,13.19,11.33,9.5299999999999994,7.8,6.13,4.51,2.95,1.45,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,855,"80W Mercury - STANDARD","855: 80W Mercury - STANDARD",4,58.04,43.06,40.01,37.06,34.21,31.45,28.79,26.23,23.75,21.36,19.059999999999999,16.829999999999998,14.68,12.61,10.61,8.68,6.82,5.0199999999999996,3.29,1.61,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,856,"70W Sodium - STANDARD","856: 70W Sodium - STANDARD",4,63.48,43.52,40.44,37.450000000000003,34.57,31.79,29.1,26.51,24,21.59,19.260000000000002,17.010000000000002,14.84,12.75,10.72,8.77,6.89,5.08,3.32,1.63,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,857,"100W Sodium - STANDARD","857: 100W Sodium - STANDARD",4,68.400000000000006,52.88,49.13,45.5,42,38.619999999999997,35.35,32.200000000000003,29.16,26.23,23.4,20.66,18.03,15.48,13.03,10.66,8.3699999999999992,6.17,4.04,1.98,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,858,"100W Metal Halide - STANDARD","858: 100W Metal Halide - STANDARD",4,89.33,55.09,51.18,47.4,43.75,40.229999999999997,36.83,33.549999999999997,30.38,27.32,24.37,21.53,18.78,16.13,13.57,11.1,8.7200000000000006,6.42,4.21,2.0699999999999998,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,859,"150W Sodium - STANDARD","859: 150W Sodium - STANDARD",4,63.9,51.01,47.39,43.89,40.520000000000003,37.25,34.1,31.06,28.13,25.3,22.57,19.93,17.39,14.94,12.57,10.28,8.08,5.95,3.89,1.91,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,860,"150W Metal Halide - STANDARD","860: 150W Metal Halide - STANDARD",4,78.25,52.53,48.8,45.2,41.72,38.36,35.11,31.99,28.97,26.05,23.24,20.53,17.91,15.38,12.94,10.59,8.32,6.12,4.01,1.97,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,861,"250W Sodium - STANDARD","861: 250W Sodium - STANDARD",4,74.05,53.93,50.1,46.4,42.83,39.380000000000003,36.049999999999997,32.840000000000003,29.74,26.75,23.86,21.07,18.39,15.79,13.29,10.87,8.5399999999999991,6.29,4.12,2.02,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,862,"250W Metal Halide - STANDARD","862: 250W Metal Halide - STANDARD",4,75.569999999999993,54.09,50.25,46.54,42.96,39.5,36.159999999999997,32.94,29.83,26.83,23.93,21.14,18.440000000000001,15.84,13.33,10.9,8.56,6.31,4.13,2.0299999999999998,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,863,"400W Sodium - STANDARD","863: 400W Sodium - STANDARD",4,67.180000000000007,62.95,58.48,54.16,49.99,45.97,42.08,38.33,34.71,31.22,27.85,24.6,21.46,18.43,15.51,12.69,9.9700000000000006,7.34,4.8099999999999996,2.36,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,864,"80W Mercury - AEROSCREEN","864: 80W Mercury - AEROSCREEN",4,87.05,43.06,40.01,37.06,34.21,31.45,28.79,26.23,23.75,21.36,19.059999999999999,16.829999999999998,14.68,12.61,10.61,8.68,6.82,5.0199999999999996,3.29,1.61,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,865,"150W Sodium - AEROSCREEN","865: 150W Sodium - AEROSCREEN",4,64.33,56.42,52.41,48.54,44.81,41.2,37.72,34.35,31.11,27.98,24.96,22.05,19.23,16.52,13.9,11.37,8.93,6.58,4.3099999999999996,2.12,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,866,"150W Metal Halide - AEROSCREEN","866: 150W Metal Halide - AEROSCREEN",4,78.680000000000007,57.93,53.82,49.85,46.01,42.3,38.729999999999997,35.28,31.95,28.73,25.63,22.64,19.75,16.96,14.27,11.68,9.17,6.76,4.42,2.17,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,867,"25W LED P4 Gerard","867: 25W LED P4 Gerard",4,51.96,41.22,37.75,34.39,31.15,28.01,24.99,22.07,19.260000000000002,16.54,13.92,11.39,8.94,6.59,4.3099999999999996,2.12,0,0,0,0,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,868,"250W Sodium (w/o PECB) - AEROSCREEN","868: 250W Sodium (w/o PECB) - AEROSCREEN",4,74.239999999999995,56.24,52.25,48.39,44.67,41.07,37.6,34.25,31.01,27.89,24.88,21.98,19.170000000000002,16.47,13.86,11.34,8.9,6.56,4.29,2.11,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,869,"250W Metal Halide - AEROSCREEN","869: 250W Metal Halide - AEROSCREEN",4,75.75,56.4,52.39,48.53,44.79,41.18,37.700000000000003,34.340000000000003,31.1,27.97,24.95,22.04,19.23,16.510000000000002,13.89,11.37,8.93,6.58,4.3099999999999996,2.11,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,870,"400W Sodium - AEROSCREEN","870: 400W Sodium - AEROSCREEN",4,67.06,61.46,57.1,52.88,48.81,44.88,41.09,37.43,33.89,30.48,27.19,24.02,20.95,18,15.14,12.39,9.73,7.17,4.6900000000000004,2.2999999999999998,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,871,"400W Metal Halide - AEROSCREEN","871: 400W Metal Halide - AEROSCREEN",4,74.75,62.27,57.85,53.58,49.46,45.47,41.63,37.92,34.340000000000003,30.88,27.55,24.33,21.23,18.23,15.34,12.55,9.86,7.26,4.75,2.33,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,872,"80W Mercury - POST TOP","872: 80W Mercury - POST TOP",4,60.82,77.12,71.64,66.349999999999994,61.24,56.31,51.55,46.95,42.52,38.24,34.119999999999997,30.13,26.29,22.58,19,15.54,12.21,8.99,5.89,2.89,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,873,"250W Sodium - FLOODLIGHT","873: 250W Sodium - FLOODLIGHT",4,76.12,79.38,73.739999999999995,68.290000000000006,63.03,57.96,53.06,48.33,43.77,39.36,35.11,31.01,27.06,23.24,19.55,16,12.57,9.25,6.06,2.98,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,874,"250W Metal Halide - FLOODLIGHT","874: 250W Metal Halide - FLOODLIGHT",4,77.63,79.540000000000006,73.89,68.430000000000007,63.16,58.07,53.16,48.43,43.85,39.44,35.18,31.08,27.11,23.28,19.59,16.03,12.59,9.27,6.07,2.98,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,875,"400W Sodium - FLOODLIGHT","875: 400W Sodium - FLOODLIGHT",4,68.7,81.599999999999994,75.8,70.2,64.8,59.58,54.54,49.68,44.99,40.46,36.1,31.88,27.81,23.89,20.100000000000001,16.440000000000001,12.92,9.51,6.23,3.06,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,876,"400W Metal Halide - FLOODLIGHT","876: 400W Metal Halide - FLOODLIGHT",4,76.39,82.41,76.55,70.900000000000006,65.44,60.17,55.08,50.17,45.44,40.869999999999997,36.450000000000003,32.200000000000003,28.09,24.13,20.3,16.61,13.05,9.61,6.29,3.09,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,877,"Suburban 70W HPS c/w D2 PECB - STD","877: Suburban 70W HPS c/w D2 PECB - STD",4,63.48,43.52,40.44,37.450000000000003,34.57,31.79,29.1,26.51,24,21.59,19.260000000000002,17.010000000000002,14.84,12.75,10.72,8.77,6.89,5.08,3.32,1.63,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,878,"Urban A/Screen 42W CFL c/w D2 PECB","878: Urban A/Screen 42W CFL c/w D2 PECB",4,60.52,55.68,51.72,47.91,44.22,40.659999999999997,37.22,33.9,30.7,27.61,24.63,21.76,18.98,16.3,13.72,11.22,8.82,6.49,4.25,2.09,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,879,"Roadster A/Screen 100W HPS c/w PECB","879: Roadster A/Screen 100W HPS c/w PECB",4,68.400000000000006,52.88,49.13,45.5,42,38.619999999999997,35.35,32.200000000000003,29.16,26.23,23.4,20.66,18.03,15.48,13.03,10.66,8.3699999999999992,6.17,4.04,1.98,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,880,"B2001 42WCFL c/w D2 PECB green - PT","880: B2001 42WCFL c/w D2 PECB green - PT",4,62.81,83.8,77.849999999999994,72.099999999999994,66.55,61.19,56.02,51.02,46.21,41.56,37.07,32.74,28.57,24.53,20.64,16.89,13.27,9.77,6.4,3.14,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,881,"150W Sodium - FLOODLIGHT","881: 150W Sodium - FLOODLIGHT",4,66.069999999999993,77.66,72.150000000000006,66.819999999999993,61.67,56.71,51.91,47.29,42.82,38.51,34.36,30.34,26.47,22.74,19.13,15.65,12.29,9.0500000000000007,5.93,2.91,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,882,"150W Metal Halide - FLOODLIGHT","882: 150W Metal Halide - FLOODLIGHT",4,80.41,79.180000000000007,73.55,68.12,62.87,57.81,52.92,48.21,43.66,39.26,35.020000000000003,30.93,26.99,23.18,19.5,15.96,12.53,9.23,6.04,2.97,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,883,"1x42W Compact Fluorescent - STD","883: 1x42W Compact Fluorescent - STD",4,59.6,44.25,41.11,38.08,35.15,32.31,29.58,26.95,24.4,21.95,19.579999999999998,17.29,15.09,12.96,10.9,8.92,7.01,5.16,3.38,1.66,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,884,"250W Sodium - STANDARD","884: 250W Sodium - STANDARD",4,74.05,53.93,50.1,46.4,42.83,39.380000000000003,36.049999999999997,32.840000000000003,29.74,26.75,23.86,21.07,18.39,15.79,13.29,10.87,8.5399999999999991,6.29,4.12,2.02,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,885,"18W LED P4 Gerard","885: 18W LED P4 Gerard",4,51.96,41.22,37.75,34.39,31.15,28.01,24.99,22.07,19.260000000000002,16.54,13.92,11.39,8.94,6.59,4.3099999999999996,2.12,0,0,0,0,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,886,"42W LED P3 Gerard","886: 42W LED P3 Gerard",4,52.35,45.19,41.38,37.700000000000003,34.14,30.71,27.39,24.19,21.11,18.13,15.25,12.48,9.8000000000000007,7.22,4.7300000000000004,2.3199999999999998,0,0,0,0,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,887,"33W LED P4 Pecan","887: 33W LED P4 Pecan",4,52.73,49.13,44.99,40.99,37.119999999999997,33.380000000000003,29.78,26.3,22.95,19.71,16.579999999999998,13.57,10.66,7.85,5.14,2.52,0,0,0,0,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,888,"25W LED P4 GE","888: 25W LED P4 GE",4,51.96,41.22,37.75,34.39,31.15,28.01,24.99,22.07,19.260000000000002,16.54,13.92,11.39,8.94,6.59,4.3099999999999996,2.12,0,0,0,0,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,889,"17W LED Cat P Luminaire","889: 17W LED Cat P Luminaire",4,51.96,41.22,37.75,34.39,31.15,28.01,24.99,22.07,19.260000000000002,16.54,13.92,11.39,8.94,6.59,4.3099999999999996,2.12,0,0,0,0,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,890,"Bracket - Minor <=3m","890: Bracket - Minor <=3m",4,16.91,17.45,16.579999999999998,15.74,14.93,14.15,13.4,12.67,11.97,11.29,10.63,10,9.39,8.81,8.24,7.69,7.16,6.65,6.16,5.69,5.23,4.79,4.3600000000000003,3.95,3.55,3.17,2.8,2.44,2.1,1.76,1.44,1.1299999999999999,0.83,0.55000000000000004,0.27,0,0,0,0,0,0,0,0]
[null,null,null,null,null,891,"Bracket - Major >3m","891: Bracket - Major >3m",4,22.06,107.98,102.6,97.41,92.4,87.57,82.9,78.39,74.05,69.849999999999994,65.81,61.9,58.13,54.49,50.98,47.6,44.33,41.17,38.130000000000003,35.19,32.36,29.62,26.98,24.43,21.98,19.600000000000001,17.309999999999999,15.1,12.97,10.92,8.93,7.02,5.17,3.38,1.66,0,0,0,0,0,0,0,0]
[null,null,null,null,null,895,"Pole (Wood) - Minor - DEDICATED SL <=11m","895: Pole (Wood) - Minor - DEDICATED SL <=11m",4,45.8,440.21,418.39,397.29,376.88,357.16,338.12,319.75,302.02,284.91000000000003,268.39999999999998,252.47,237.1,222.26,207.94,194.13,180.8,167.93,155.51,143.53,131.97,120.81,110.05,99.66,89.63,79.959999999999994,70.62,61.61,52.91,44.52,36.43,28.61,21.07,13.8,6.78,0,0,0,0,0,0,0,0]
[null,null,null,null,null,896,"Pole (Wood) - Major - DEDICATED SL >11m","896: Pole (Wood) - Major - DEDICATED SL >11m",4,67.23,817.62,777.1,737.92,700.02,663.37,628.02,593.89,560.96,529.19000000000005,498.52,468.93,440.38,412.82,386.23,360.57,335.81,311.91000000000003,288.85000000000002,266.60000000000002,245.12,224.4,204.4,185.1,166.48,148.51,131.16999999999999,114.43,98.28,82.7,67.66,53.15,39.14,25.63,12.59,0,0,0,0,0,0,0,0]
[null,null,null,null,null,897,"Pole (Wood) - Minor   <=11m","897: Pole (Wood) - Minor   <=11m",4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,898,"Pole (Wood) - Major  >11m","898: Pole (Wood) - Major  >11m",4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,950,"82W LED Gerard V5 Cat Luminaire","950: 82W LED Gerard V5 Cat Luminaire",4,55.01,72.75,66.61,60.68,54.96,49.43,44.09,38.94,33.97,29.18,24.55,20.09,15.78,11.62,7.61,3.74,0,0,0,0,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,951,"100W LED Gerard V4 Cat Luminaire","951: 100W LED Gerard V4 Cat Luminaire",4,55.01,72.75,66.61,60.68,54.96,49.43,44.09,38.94,33.97,29.18,24.55,20.09,15.78,11.62,7.61,3.74,0,0,0,0,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,952,"198W LED Gerard V2/V3 Cat Luminaire","952: 198W LED Gerard V2/V3 Cat Luminaire",4,56.23,85.42,78.2,71.239999999999995,64.52,58.03,51.76,45.72,39.89,34.26,28.82,23.58,18.52,13.64,8.93,4.3899999999999997,0,0,0,0,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,953,"33W LED P3 Gerard","953: 33W LED P3 Gerard",4,52.35,45.19,41.38,37.700000000000003,34.14,30.71,27.39,24.19,21.11,18.13,15.25,12.48,9.8000000000000007,7.22,4.7300000000000004,2.3199999999999998,0,0,0,0,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,955,"75W LED Aglo Nilum Plus FLOODLIGHT","955: 75W LED Aglo Nilum Plus FLOODLIGHT",4,53.73,60.58,55.47,50.53,45.76,41.16,36.72,32.43,28.29,24.3,20.440000000000001,16.73,13.14,9.68,6.34,3.11,0,0,0,0,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,956,"100W LED Aglo Nilum Plus FLOODLIGHT","956: 100W LED Aglo Nilum Plus FLOODLIGHT",4,53.98,63.01,57.69,52.56,47.6,42.81,38.19,33.729999999999997,29.43,25.27,21.27,17.399999999999999,13.67,10.07,6.59,3.24,0,0,0,0,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,957,"150W LED Aglo Nilum Plus FLOODLIGHT","957: 150W LED Aglo Nilum Plus FLOODLIGHT",4,54.44,67.88,62.15,56.62,51.28,46.12,41.14,36.340000000000003,31.7,27.23,22.91,18.739999999999998,14.72,10.84,7.1,3.49,0,0,0,0,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,958,"300W LED Aglo Nilum Plus FLOODLIGHT","958: 300W LED Aglo Nilum Plus FLOODLIGHT",4,57.32,98.42,90.11,82.08,74.34,66.86,59.64,52.68,45.96,39.47,33.21,27.17,21.34,15.72,10.29,5.05,0,0,0,0,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,959,"60W LED RoadLED Midi Optic Tuner","959: 60W LED RoadLED Midi Optic Tuner",4,53.52,47.41,42.09,36.96,32,28.78,25.67,22.67,19.78,16.989999999999998,14.29,11.7,9.19,6.77,4.43,2.1800000000000002,0,0,0,0,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,960,"80W LED RoadLED Midi Optic Tuner","960: 80W LED RoadLED Midi Optic Tuner",4,54.22,55.2,49.22,43.45,37.880000000000003,34.07,30.39,26.84,23.42,20.11,16.920000000000002,13.85,10.88,8.01,5.24,2.58,0,0,0,0,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,961,"70W LED RoadLED Midi","961: 70W LED RoadLED Midi",4,52.97,41.56,36.74,32.08,27.58,24.81,22.13,19.55,17.05,14.65,12.32,10.08,7.92,5.83,3.82,1.88,0,0,0,0,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,962,"80W LED RoadLED Midi","962: 80W LED RoadLED Midi",4,53.15,43.51,38.520000000000003,33.71,29.05,26.13,23.31,20.59,17.96,15.43,12.98,10.62,8.34,6.14,4.0199999999999996,1.98,0,0,0,0,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,964,"165W LED RoadLED Midi","964: 165W LED RoadLED Midi",4,53.29,44.97,39.86,34.92,30.16,27.12,24.2,21.37,18.64,16.010000000000002,13.47,11.02,8.66,6.38,4.18,2.0499999999999998,0,0,0,0,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,965,"17W LED B2001 NUWE Post Top","965: 17W LED B2001 NUWE Post Top",4,54.55,58.61,52.34,46.3,40.450000000000003,36.380000000000003,32.46,28.67,25.01,21.48,18.07,14.79,11.62,8.5500000000000007,5.6,2.75,0,0,0,0,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,967,"150W LED SLED Maximus Pedestrian","967: 150W LED SLED Maximus Pedestrian",4,55.18,65.430000000000007,58.59,51.98,45.6,41.02,36.590000000000003,32.32,28.19,24.21,20.37,16.670000000000002,13.09,9.64,6.31,3.1,0,0,0,0,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,968,"175W LED SLED Maximus Pedestrian","968: 175W LED SLED Maximus Pedestrian",4,56.2,76.63,68.84,61.32,54.06,48.62,43.37,38.31,33.42,28.71,24.15,19.760000000000002,15.52,11.43,7.48,3.68,0,0,0,0,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,990,"Outreach - Minor <=2m","990: Outreach - Minor <=2m",4,17.16,21.78,20.7,19.649999999999999,18.64,17.66,16.72,15.81,14.94,14.09,13.27,12.49,11.73,10.99,10.28,9.6,8.94,8.3000000000000007,7.69,7.1,6.53,5.97,5.44,4.93,4.43,3.95,3.49,3.05,2.62,2.2000000000000002,1.8,1.42,1.04,0.68,0.34,0,0,0,0,0,0,0,0]
[null,null,null,null,null,991,"Outreach - Major >2m","991: Outreach - Major >2m",4,18.47,44.95,42.72,40.56,38.479999999999997,36.46,34.520000000000003,32.64,30.83,29.09,27.4,25.77,24.2,22.69,21.23,19.82,18.46,17.14,15.88,14.65,13.47,12.33,11.23,10.17,9.15,8.16,7.21,6.29,5.4,4.55,3.72,2.92,2.15,1.41,0.69,0,0,0,0,0,0,0,0]
[null,null,null,null,null,995,"Column (Steel) - Minor <=9m","995: Column (Steel) - Minor <=9m",4,30.86,176.9,168.1,159.6,151.4,143.47,135.82,128.44,121.32,114.45,107.82,101.42,95.24,89.28,83.53,77.98,72.63,67.459999999999994,62.47,57.66,53.01,48.53,44.21,40.03,36.01,32.119999999999997,28.37,24.75,21.26,17.89,14.63,11.49,8.4700000000000006,5.54,2.72,0,0,0,0,0,0,0,0]
[null,null,null,null,null,996,"Column (Steel) - Major >9m","996: Column (Steel) - Major >9m",4,34.83,247.25,235,223.14,211.68,200.6,189.91,179.59,169.63,160.02000000000001,150.75,141.80000000000001,133.16999999999999,124.83,116.79,109.03,101.55,94.32,87.35,80.62,74.12,67.86,61.81,55.97,50.34,44.91,39.659999999999997,34.6,29.72,25.01,20.46,16.07,11.84,7.75,3.81,0,0,0,0,0,0,0,0]

{"sheet":"Temp","index":6,"n_rows":343,"n_cols":4,"rows_kept":343,"cut":false,"hidden":true,"merged":[]}
["Current Code","Alternative Code(s)","Description","Charges FY22"]
[13,"-","1 x 20 W Fluorescent",48.68]
[14,null,"2 x 20 W Fluorescent",51.25]
[195,null,"2 x 20 W Fluorescent",51.25]
[398,null,"2 x 20 W Fluorescent",51.25]
[112,"14, 195, 398","2 x 20 W Fluorescent",51.25]
[69,"-","4 x 20 W Fluorescent",0]
[220,218,"2 x 14 W Fluorescent",57.71]
[218,null,"2 x 14 W Fluorescent",57.71]
[221,219,"2 x 24 W Fluorescent",53.09]
[219,null,"2 x 24 W Fluorescent",53.09]
[70,"18, 63","1 x 40 W Fluorescent",51.36]
[18,null,"1 x 40 W Fluorescent",51.36]
[63,null,"1 x 40 W Fluorescent",51.36]
[19,"20, 75","2 x 40 W Fluorescent",54.78]
[20,null,"2 x 40 W Fluorescent",54.78]
[75,null,"2 x 40 W Fluorescent",54.78]
[223,222,"1 x 42 W Fluorescent",49.76]
[222,null,"1 x 42 W Fluorescent",49.76]
[185,177,"50W Mercury",51.43]
[177,null,"50W Mercury",51.43]
[104,"93, 147, 149, 186, 187, 188","80W Mercury",48.63]
[93,null,"80W Mercury",48.63]
[147,null,"80W Mercury",48.63]
[149,null,"80W Mercury",48.63]
[186,null,"80W Mercury",48.63]
[187,null,"80W Mercury",48.63]
[188,null,"80W Mercury",48.63]
[97,"94, 131, 158","125W Mercury",48.96]
[94,null,"125W Mercury",48.96]
[131,null,"125W Mercury",48.96]
[158,null,"125W Mercury",48.96]
[30,"95, 98, 114, 132","250W Mercury",49.08]
[95,null,"250W Mercury",49.08]
[98,null,"250W Mercury",49.08]
[114,null,"250W Mercury",49.08]
[132,null,"250W Mercury",49.08]
[100,"60, 101","2 x 250W Mercury",94.34]
[60,null,"2 x 250W Mercury",94.34]
[101,null,"2 x 250W Mercury",94.34]
[31,"96, 99, 115, 121, 122","400 W Mercury",49.05]
[96,null,"400 W Mercury",49.05]
[99,null,"400 W Mercury",49.05]
[115,null,"400 W Mercury",49.05]
[121,null,"400 W Mercury",49.05]
[122,null,"400 W Mercury",49.05]
[182,"-","50W Sodium",60.72]
[183,184,"70W Sodium",54.59]
[184,null,"70W Sodium",54.59]
[34,"-","90W Sodium",56.98]
[167,"33, 168, 169","100W Sodium",58.84]
[33,null,"100W Sodium",58.84]
[168,null,"100W Sodium",58.84]
[169,null,"100W Sodium",58.84]
[150,"157, 162, 163","120W Sodium",54.1]
[157,null,"120W Sodium",54.1]
[162,null,"120W Sodium",54.1]
[163,null,"120W Sodium",54.1]
[142,"143, 170, 171, 173, 193, 194, 339, 340, 341","150W Sodium",56.08]
[143,null,"150W Sodium",56.08]
[170,null,"150W Sodium",56.08]
[171,null,"150W Sodium",56.08]
[173,null,"150W Sodium",56.08]
[193,null,"150W Sodium",56.08]
[194,null,"150W Sodium",56.08]
[339,null,"150W Sodium",56.08]
[340,null,"150W Sodium",56.08]
[341,null,"150W Sodium",56.08]
[38,"35, 53, 55, 119, 134, 140, 141, 154","250W Sodium",62.55]
[35,null,"250W Sodium",62.55]
[53,null,"250W Sodium",62.55]
[55,null,"250W Sodium",62.55]
[119,null,"250W Sodium",62.55]
[134,null,"250W Sodium",62.55]
[140,null,"250W Sodium",62.55]
[141,null,"250W Sodium",62.55]
[154,null,"250W Sodium",62.55]
[103,"-","2 x 250W Sodium",80.67]
[39,56,"310W Sodium",61.92]
[56,null,"310W Sodium",61.92]
[25,"36, 40, 45, 57, 123, 130, 190","400 W Sodium",55.3]
[36,null,"400 W Sodium",55.3]
[40,null,"400 W Sodium",55.3]
[45,null,"400 W Sodium",55.3]
[57,null,"400 W Sodium",55.3]
[123,null,"400 W Sodium",55.3]
[130,null,"400 W Sodium",55.3]
[190,null,"400 W Sodium",55.3]
[102,"135,136,146,152,153,151,159","2 x 400 W Sodium",70.69]
[135,null,"2 x 400 W Sodium",70.69]
[136,null,"2 x 400 W Sodium",70.69]
[146,null,"2 x 400 W Sodium",70.69]
[152,null,"2 x 400 W Sodium",70.69]
[153,null,"2 x 400 W Sodium",70.69]
[151,null,"2 x 400 W Sodium",70.69]
[159,null,"2 x 400 W Sodium",70.69]
[88,145,"4 x 600W Sodium",86.38]
[145,null,"4 x 600W Sodium",86.38]
[12,"-","1500 W Incandescent",65.760000000000005]
[216,217,"100 W Metal Halide",81.48]
[217,null,"100 W Metal Halide",81.48]
[199,215,"150 W Metal Halide",122.9]
[215,null,"150 W Metal Halide",122.9]
[198,213,"250 W Metal Halide",73.739999999999995]
[213,null,"250 W Metal Halide",73.739999999999995]
[214,"-","2 x 250 W Metal Halide",131.80000000000001]
[211,197,"400 W Metal Halide",65.06]
[197,null,"400 W Metal Halide",65.06]
[212,"-","2 x 400 W Metal Halide",175.02]
[196,"-","1000 W Metal Halide",61.42]
[224,"-","Pole mounting bracket minor (<=3m)",14.17]
[225,"-","Pole mounting bracket major (>3m)",14.26]
[226,230,"Outreach Minor (<=2m)",14.67]
[230,null,"Outreach Minor (<=2m)",14.67]
[227,"-","Outreach Major (>2m)",14.69]
[228,231,"Minor Column (<=9)",24.94]
[231,null,"Minor Column (<=9)",24.94]
[229,"-","Major Column (>=9)",111.84]
[302,"-","1 x 20 W Fluorescent",48]
[415,413,"2 x 14 W Fluorescent",48]
[413,null,"2 x 14 W Fluorescent",48]
[416,414,"2 x 24 W Fluorescent",48]
[414,null,"2 x 24 W Fluorescent",48]
[305,303,"1 x 40 W Fluorescent",49.76]
[303,null,"1 x 40 W Fluorescent",49.76]
[306,"-","2 x 40 W Fluorescent",54.78]
[421,422,"1 x 42 W Fluorescent",49.76]
[422,null,"1 x 42 W Fluorescent",49.76]
[308,307,"50W Mercury",51.06]
[307,null,"50W Mercury",51.06]
[309,"310, 311, 312, 313, 314, 315","80W Mercury",48.48]
[310,null,"80W Mercury",48.48]
[311,null,"80W Mercury",48.48]
[312,null,"80W Mercury",48.48]
[313,null,"80W Mercury",48.48]
[314,null,"80W Mercury",48.48]
[315,null,"80W Mercury",48.48]
[318,"316, 317, 401","125W Mercury",48.48]
[316,null,"125W Mercury",48.48]
[317,null,"125W Mercury",48.48]
[401,null,"125W Mercury",48.48]
[323,320,"250W Mercury",48.48]
[320,null,"250W Mercury",48.48]
[326,330,"400 W Mercury",48.48]
[330,null,"400 W Mercury",48.48]
[335,"-","50W Sodium",53.26]
[332,"336, 337","70W Sodium",53.26]
[336,null,"70W Sodium",53.26]
[337,null,"70W Sodium",53.26]
[380,381,"100W Sodium",56.98]
[381,null,"100W Sodium",56.98]
[338,null,"150W Sodium",53.1]
[343,"344, 345, 346, 347, 348, 349","250W Sodium",61.92]
[344,null,"250W Sodium",61.92]
[345,null,"250W Sodium",61.92]
[346,null,"250W Sodium",61.92]
[347,null,"250W Sodium",61.92]
[348,null,"250W Sodium",61.92]
[349,null,"250W Sodium",61.92]
[350,"-","2 x 250W Sodium",79.08]
[355,"352, 353, 354, 356, 357","400 W Sodium",55.16]
[352,null,"400 W Sodium",55.16]
[353,null,"400 W Sodium",55.16]
[354,null,"400 W Sodium",55.16]
[356,null,"400 W Sodium",55.16]
[357,null,"400 W Sodium",55.16]
[358,"360, 361","2 x 400 W Sodium",65.56]
[360,null,"2 x 400 W Sodium",65.56]
[361,null,"2 x 400 W Sodium",65.56]
[411,412,"100 W Metal Halide",75.42]
[412,null,"100 W Metal Halide",75.42]
[365,"400, 410","150 W Metal Halide",65.760000000000005]
[400,null,"150 W Metal Halide",65.760000000000005]
[410,null,"150 W Metal Halide",65.760000000000005]
[366,402,"250 W Metal Halide",63.25]
[402,null,"250 W Metal Halide",63.25]
[403,"-","2 x 250 W Metal Halide",81.75]
[396,404,"400 W Metal Halide",61.94]
[404,null,"400 W Metal Halide",61.94]
[405,"-","2 x 400 W Metal Halide",79.13]
[427,"-","Pole mounting bracket minor (<=3m)",14.14]
[428,"-","Pole mounting bracket major (>3m)",14.14]
[423,"-","Outreach Minor (<=2m)",14.14]
[424,"-","Outreach Major (>2m)",14.14]
[425,"-","Minor Column (<=9)",18.47]
[426,"-","Major Column (>=9)",18.47]
[551,"-","2x14W Energy Efficient Fluro - STD",78.25]
[552,"-","2x24W Energy Efficient Fluro - STD",80.66]
[553,583,"1x42W Compact Fluorescent - STD",76.12]
[583,null,"1x42W Compact Fluorescent - STD",76.12]
[554,"-","50W Mercury - STANDARD",74.16]
[555,"-","80W Mercury - STANDARD",74.13]
[556,"-","70W Sodium - STANDARD",79.239999999999995]
[557,"-","100W Sodium - STANDARD",88.46]
[558,"-","100W Metal Halide - STANDARD",108.36]
[577,"-","Suburban 70W HPS c/w D2 PECB - STD",79.239999999999995]
[589,"-","17W LED P4",76.34]
[585,"-","18W LED P4 Gerard",76.34]
[567,"-","25W LED P4 Gerard",76.34]
[588,"-","25W LED P4 GE",76.34]
[587,"-","33W LED P4 Pecan",82.75]
[653,"-","33W LED P3 Gerard",79.56]
[586,"-","42W LED P3 Gerard",79.56]
[650,"-","82W LED V5 Gerard",101.89]
[651,"-","100W LED V4 Gerard",101.89]
[652,"-","198W LED V2/V3 Gerard",112.15]
[559,"-","150W Sodium - STANDARD",83.47]
[560,"-","150W Metal Halide - STANDARD",97.11]
[561,584,"250W Sodium - STANDARD",94.07]
[584,null,"250W Sodium - STANDARD",94.07]
[562,"-","250W Metal Halide - STANDARD",95.5]
[563,"-","400W Sodium - STANDARD",92.55]
[659,"-","60W LED RoadLED Midi Optic Tuner",92.39]
[660,"-","80W LED RoadLED Midi Optic Tuner",98.4]
[661,"-","70W LED RoadLED Midi",87.87]
[662,"-","80W LED RoadLED Midi",89.38]
[664,"-","165W LED RoadLED Midi",90.5]
[565,"-","150W Sodium - AEROSCREEN",86.64]
[566,"-","150W Metal Halide - AEROSCREEN",100.29]
[568,"-","250W Sodium (w/o PECB) - AEROSCREEN",95.42]
[569,"-","250W Metal Halide - AEROSCREEN",96.87]
[570,"-","400W Sodium - AEROSCREEN",91.67]
[571,"-","400W Metal Halide - AEROSCREEN",98.98]
[579,"-","Roadster A/Screen 100W HPS c/w PECB",88.46]
[564,"-","80W Mercury - AEROSCREEN",100.1]
[578,"-","Urban A/Screen 42W CFL c/w D2 PECB",82.84]
[572,"-","80W Mercury - POST TOP",94.14]
[580,"-","B2001 42W CFL - POST TOP",99.37]
[665,"-","17W LED B2001 NUWE Post Top",101.04]
[573,"-","250W Sodium - FLOODLIGHT",109.02]
[574,"-","250W Metal Halide - FLOODLIGHT",110.46]
[575,"-","400W Sodium - FLOODLIGHT",103.5]
[576,"-","400W Metal Halide - FLOODLIGHT",110.83]
[581,"-","150W Sodium - FLOODLIGHT",99.14]
[582,"-","150W Metal Halide - FLOODLIGHT",112.77]
[655,"-","75W LED Aglo Nilum Plus FLOODLIGHT",91.26]
[656,"-","100W LED Aglo Nilum Plus FLOODLIGHT",93.19]
[657,"-","150W LED Aglo Nilum Plus FLOODLIGHT",97.04]
[658,"-","300W LED Aglo Nilum Plus FLOODLIGHT",121.19]
[667,"-","150W LED SLED Maximus Pedestrian",106.3]
[668,"-","175W LED SLED Maximus Pedestrian",114.96]
[590,"-","Bracket - Minor <=3m",19.45]
[591,"-","Bracket - Major >3m",46.37]
[690,"-","Outreach - Minor <=2m",20.73]
[691,"-","Outreach - Major >2m",27.61]
[595,"-","Pole (Wood) - Minor - DEDICATED SL <=11m",149.13999999999999]
[596,"-","Pole (Wood) - Major - DEDICATED SL >11m",261.04000000000002]
[695,"-","Column (Steel) - Minor <=9m",153.13999999999999]
[696,"-","Column (Steel) - Major >9m",280.51]
[597,"-","Pole (Wood) - Minor   <=11m",0]
[598,"-","Pole (Wood) - Major  >11m",0]
[851,"-","2x14W Energy Efficient Fluro - STD",52.09]
[852,"-","2x24W Energy Efficient Fluro - STD",52.4]
[853,883,"1x42W Compact Fluorescent - STD",53.4]
[883,null,"1x42W Compact Fluorescent - STD",53.4]
[854,"-","50W Mercury - STANDARD",54.28]
[855,"-","80W Mercury - STANDARD",52]
[856,"-","70W Sodium - STANDARD",56.88]
[857,"-","100W Sodium - STANDARD",61.29]
[858,"-","100W Metal Halide - STANDARD",80.040000000000006]
[877,"-","Suburban 70W HPS c/w D2 PECB - STD",56.88]
[889,"-","17W LED P4",46.56]
[885,"-","18W LED P4 Gerard",46.56]
[867,"-","25W LED P4 Gerard",46.56]
[888,"-","25W LED P4 GE",46.56]
[887,"-","33W LED P4 Pecan",47.25]
[953,"-","33W LED P3 Gerard",46.91]
[886,"-","42W LED P3 Gerard",46.91]
[950,"-","82W LED V5 Gerard",49.29]
[951,"-","100W LED V4 Gerard",49.29]
[952,"-","198W LED V2/V3 Gerard",50.39]
[859,"-","150W Sodium - STANDARD",57.26]
[860,"-","150W Metal Halide - STANDARD",70.12]
[861,884,"250W Sodium - STANDARD",66.349999999999994]
[884,null,"250W Sodium - STANDARD",66.349999999999994]
[862,"-","250W Metal Halide - STANDARD",67.709999999999994]
[863,"-","400W Sodium - STANDARD",60.19]
[959,"-","60W LED RoadLED Midi Optic Tuner",47.95]
[960,"-","80W LED RoadLED Midi Optic Tuner",48.58]
[961,"-","70W LED RoadLED Midi",47.46]
[962,"-","80W LED RoadLED Midi",47.62]
[964,"-","165W LED RoadLED Midi",47.75]
[865,"-","150W Sodium - AEROSCREEN",57.64]
[866,"-","150W Metal Halide - AEROSCREEN",70.5]
[868,"-","250W Sodium (w/o PECB) - AEROSCREEN",66.52]
[869,"-","250W Metal Halide - AEROSCREEN",67.88]
[870,"-","400W Sodium - AEROSCREEN",60.09]
[871,"-","400W Metal Halide - AEROSCREEN",66.98]
[879,"-","Roadster A/Screen 100W HPS c/w PECB",61.29]
[864,"-","80W Mercury - AEROSCREEN",78]
[878,"-","Urban A/Screen 42W CFL c/w D2 PECB",54.22]
[872,"-","80W Mercury - POST TOP",54.49]
[880,"-","B2001 42W CFL - POST TOP",56.28]
[965,"-","17W LED B2001 NUWE Post Top",48.88]
[873,"-","250W Sodium - FLOODLIGHT",68.2]
[874,"-","250W Metal Halide - FLOODLIGHT",69.56]
[875,"-","400W Sodium - FLOODLIGHT",61.56]
[876,"-","400W Metal Halide - FLOODLIGHT",68.45]
[881,"-","150W Sodium - FLOODLIGHT",59.2]
[882,"-","150W Metal Halide - FLOODLIGHT",72.05]
[955,"-","75W LED Aglo Nilum Plus FLOODLIGHT",48.15]
[956,"-","100W LED Aglo Nilum Plus FLOODLIGHT",48.37]
[957,"-","150W LED Aglo Nilum Plus FLOODLIGHT",48.78]
[958,"-","300W LED Aglo Nilum Plus FLOODLIGHT",51.36]
[967,"-","150W LED SLED Maximus Pedestrian",49.44]
[968,"-","175W LED SLED Maximus Pedestrian",50.36]
[890,"-","Bracket - Minor <=3m",15.15]
[891,"-","Bracket - Major >3m",19.77]
[990,"-","Outreach - Minor <=2m",15.37]
[991,"-","Outreach - Major >2m",16.55]
[895,"-","Pole (Wood) - Minor - DEDICATED SL <=11m",41.03]
[896,"-","Pole (Wood) - Major - DEDICATED SL >11m",60.24]
[995,"-","Column (Steel) - Minor <=9m",27.65]
[996,"-","Column (Steel) - Major >9m",31.21]
[897,"-","Pole (Wood) - Minor   <=11m",0]
[898,"-","Pole (Wood) - Major  >11m",0]
[716,"-","2x14W Energy Efficient Fluro - STD",48.39]
[717,"-","2x24W Energy Efficient Fluro - STD",48.39]
[718,"-","1x42W Compact Fluorescent - STD",50.18]
[725,"-","50W Mercury - STANDARD",51.47]
[710,"-","80W Mercury - STANDARD",48.88]
[726,"-","70W Sodium - STANDARD",53.7]
[727,"-","100W Sodium - STANDARD",57.44]
[728,"-","100W Metal Halide - STANDARD",76.040000000000006]
[729,"-","150W Sodium - STANDARD",53.54]
[721,"-","150W Metal Halide - STANDARD",66.3]
[720,"-","250W Sodium - STANDARD",62.42]
[722,"-","250W Metal Halide - STANDARD",63.76]
[731,"-","400W Sodium - STANDARD",55.61]
[732,"-","80W Mercury - AEROSCREEN",74.849999999999994]
[733,"-","150W Sodium - AEROSCREEN",53.54]
[734,"-","150W Metal Halide - AEROSCREEN",66.3]
[735,"-","250W Sodium (w/o PECB) - AEROSCREEN",62.42]
[736,"-","250W Metal Halide - AEROSCREEN",63.76]
[737,"-","400W Sodium - AEROSCREEN",55.61]
[715,"-","400W Metal Halide - AEROSCREEN",62.44]
[738,"-","80W Mercury - POST TOP",48.88]
[739,"-","250W Sodium - FLOODLIGHT",62.42]
[740,"-","250W Metal Halide - FLOODLIGHT",63.76]
[741,"-","400W Sodium - FLOODLIGHT",55.61]
[742,"-","400W Metal Halide - FLOODLIGHT",62.44]
[795,"-","Column (Steel) - Minor <=9m",18.62]
[796,"-","Column (Steel) - Major >9m",18.62]

{"sheet":"Customer List","index":7,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Customer","Address","Suburb","Attention"]
["Bankstown City Council                  ","PO Box 8","BANKSTOWN NSW 1885","Manager of Roads & Infratructure"]
["Blacktown City Council                  ","PO Box 63","BLACKTOWN   NSW   2148","Mr Andy Karklins"]
["Blue Mountains City Council             ","Locked Bag 1005","KATOOMBA   NSW   2780","Mr Alan Cattermole"]
["Camden Council","PO Box 183","CAMDEN   NSW   2570","Mr Adam Wilkinson"]
["Campbelltown City Council               ","PO Box 57","CAMPBELLTOWN   NSW   2560","Holly Sutherland"]
["Council of the City of Shellharbour ","PO Box 155","SHELLHARBOUR CITY CENTRE   NSW   2529","Mr Max Boenisch"]
["Bathurst Regional Council","Private Mail Bag 17","BATHURST NSW 2795","Mr David Sherley "]
["Fairfield City Council                  ","PO Box 21","FAIRFIELD NSW 1860","Mr David Niven"]
["Hawkesbury City Council                 ","PO Box 146","WINDSOR   NSW   2756","Accounts Payable"]
["HMAS Albatross (Department of Defence)","CP26157 Campbell Park Offices","CANBERRA ACT 2600","ENERGY SERVICES"]
["Cumberland City Council","PO Box 42","MERRYLANDS NSW 2160","Finance Manager"]
["Hornsby City Council","PO Box 37","HORNSBY NSW 2077","Mr Alan Boyd"]
["Kiama Municipal Council                 ","PO Box 75","KIAMA NSW 2533","Accounts Payable"]
["Lithgow City Council","PO Box 19","LITHGOW NSW 2790","Mr Iain Stewart"]
["Liverpool City Council                  ","PO Box 64","LIVERPOOL  NSW  2170","Bozenab Blasko"]
["Mid Western Regional Council","PO Box 156","MUDGEE   NSW   2850","Accounts Payable"]
["NSW Maritime Property Divisions","Locked Bag 5100","CAMPERDOWN   NSW   1450","Patrick McCallum\nPrincipal Engineer"]
["City of Parramatta","PO Box 32","PARRAMATTA   NSW   2150","Mr Andy Ling"]
["Penrith City Council                    ","PO Box 60","PENRITH NSW 2751","Mr Murray Halls"]
["Port Kembla Operations Pty Ltd","PO Box 89","PORT KEMBLA NSW 2505","Accounts Payable","changed 1/09/09 on e-mail from Navi"]
["RTA, Traffic Asset Services (Corrimal)","L9 Sydney Project Services. 27 Argyle St","PARRAMATTA NSW 2150","Mr Harbans Puria"]
["RTA, Traffic Asset Services\n(M7)","L9 Sydney Project Services. 27 Argyle St","PARRAMATTA NSW 2150","Mr Harbans Puria"]
["RTA, Traffic Asset Services\n(Parkes)","L9 Sydney Project Services. 27 Argyle St","PARRAMATTA NSW 2150","Mr Harbans Puria"]
["RTA, Traffic Asset Services\n(National Highway)","L9 Sydney Project Services. 27 Argyle St","PARRAMATTA NSW 2150","Mr Harbans Puria"]
["RTA, Traffic Asset Services\n(State Roads)","L9 Sydney Project Services. 27 Argyle St","PARRAMATTA NSW 2150","Mr Harbans Puria"]
["RTA (Unmetered Lighting)","L9 Sydney Project Services. 27 Argyle St","PARRAMATTA NSW 2150","Mr Harbans Puria"]
["Ryde City Council                  ","Locked Bag 2069","NORTH RYDE   NSW   1670","Accounts Payable"]
["Shoalhaven City Council                 ","PO Box 42","NOWRA NSW 2541","Mr Bill Galea"]
["Sydney Catchment Authority","PO Box 323","PENRITH NSW 2751","Mr Imran Bashir"]
["The Hills Shire Council","3 Columbia Court","BAULKHAM HILLS 2153","Ms Bev Osbourne"]
["The Department of Lands","PO Box 309","NOWRA NSW 2541","Ms Cindy Garner"]
["Wingecarribee Shire Council             ","PO Box 141","MOSS VALE   NSW   2577","Mr Rod Smith"]
["Wollondilly Shire Council               ","PO Box 21","PICTON   NSW   2571","Mr Charles Dunlop"]
["Wollongong City Council                 ","Locked Bag 8821","WOLLONGONG   NSW   2500","Ms Sonia Batziavalis"]

{"sheet":"Template","index":8,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IF(ISBLANK(A1),\"\",VLOOKUP(A1,Lookups!$H$1:$I$371,2,FALSE))","v":""},null,null,null,{"$f":"IF(ISBLANK(A1),\"\",IF(C1=\"Removed\",-1,1)*SUMIF(Lookups!H:H,A1, Lookups!J:J))","v":""},{"$f":"IF(ISBLANK(A1),\"\",F1*0.1)","v":""},{"$f":"IF(ISBLANK(A1),\"\",G1+F1)","v":""},{"$f":"IF(OR(ISBLANK(A1),ISBLANK(C1),C1=\"Installed\"), \"\", VLOOKUP(A1,Lookups!H:BA,IF(OR(B1=1, B1=2), 4,VLOOKUP('Page 4 - NOCC Detail'!E1,Lookups!A:B,2,FALSE)+3),FALSE))","v":""},{"$f":"IF(I1=\"\",\"\",I1*0.1)","v":""},{"$f":"IF(I1=\"\",\"\",J1+I1)","v":""}]