{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Rental Calculator","Printable Quote","Application","Sibonile School-Rev0","Study Data_Rev0","Sibonile School","Study Data","SloanLED Breakdown","Data Summary","Luca Breakdown","Print Quote","Sheet2"],"not_rendered":{"images":7,"external_links":2,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Rental Calculator","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"hidden":true,"merged":[[1,1,1,4],[1,15,17,20],[3,2,3,4],[4,2,4,4],[5,2,5,4],[5,7,5,9],[5,11,5,13],[6,2,6,4],[7,2,7,4],[7,7,7,9],[7,11,7,13],[8,2,8,4],[9,2,9,4],[9,7,9,9],[9,11,9,13],[11,2,11,4],[11,7,12,13],[13,2,13,4],[14,7,16,13],[15,2,15,4],[17,2,17,4],[21,7,21,9],[21,11,21,13]]}
[]
[null,"CLIENT DATA INPUT SHEET"]
[]
[null,"COMPANY NAME","Clover City Deep"]
[]
[null,"CONTACT PERSON",{"$nulls":5},"CAPITAL",{"$nulls":3},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"ADDRESS",{"$nulls":5},"TERM IN MONTHS",{"$nulls":3},60]
[]
[null,"ADDRESS LINE 2",{"$nulls":5},"TERM IN YEARS",{"$nulls":3},{"$f":"L8/12& \" YEARS\"","v":"5 YEARS"}]
[]
[null,"ADDRESS LINE 3",{"$nulls":5},"RENTAL AMOUNT"]
[]
[null,"CONTACT NUMBER"]
[{"$nulls":7},{"$f":"-PMT(L22/12,L8,L6,,1)","v":{"$error":"#REF!"}}]
[null,"E-MAIL ADDRESS"]
[]
[null,"ASSET DESCRIPTION"]
[]
[]
[]
[{"$nulls":7},"INTEREST RATE",{"$nulls":3},{"$f":"15.25%","v":{"v":0.1525,"d":"15.25%"}}]

{"sheet":"Printable Quote","index":1,"n_rows":55,"n_cols":10,"rows_kept":55,"hidden":true,"merged":[[7,9,7,10],[9,2,9,10],[10,2,10,5],[10,7,10,10],[11,2,11,5],[11,7,11,10],[13,2,13,5],[13,7,13,10],[14,2,14,5],[14,7,14,10],[15,2,15,5],[15,7,15,10],[17,2,17,5],[17,7,17,10],[18,2,18,5],[18,7,18,10],[20,2,20,10],[21,2,21,10],[23,2,23,5],[23,7,23,10],[25,2,25,5],[25,7,25,10],[27,2,27,5],[27,7,27,10],[29,2,29,5],[29,7,29,10],[31,2,31,5],[31,7,31,10],[33,2,33,10],[34,3,34,9],[35,3,35,9],[36,3,36,9],[37,3,37,9],[38,3,38,9],[39,3,39,9],[40,3,40,9],[41,3,41,9],[42,3,42,9],[43,3,43,9],[44,3,44,9],[45,2,47,10],[45,57,47,57],[48,2,48,10],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9]]}
{"$rows_empty":7}
[{"$nulls":9},{"$f":"TODAY()","v":"2022-02-24"}]
[]
[null,null,"C L I E N T   D E T A I L S"]
[null,null,"COMPANY NAME",{"$nulls":3},":",{"$f":"'Rental Calculator'!C4","v":"Clover City Deep"}]
[null,null,"CONTACT PERSON",{"$nulls":3},":",{"$f":"'Rental Calculator'!C6","v":0}]
[]
[null,null,"ADDRESS",{"$nulls":3},":",{"$f":"'Rental Calculator'!C8","v":0}]
[null,null,"ADDRESS LINE 2",{"$nulls":4},{"$f":"'Rental Calculator'!C10","v":0}]
[null,null,"ADDRESS LINE 3",{"$nulls":4},{"$f":"'Rental Calculator'!C12","v":0}]
[]
[null,null,"CONTACT NUMBER",{"$nulls":3},":",{"$f":"'Rental Calculator'!C14","v":{"v":0,"d":"(000) 000-0000"}}]
[null,null,"E-MAIL ADDRESS",{"$nulls":3},":",{"$f":"'Rental Calculator'!C16","v":0}]
[]
[null,null,"A S S E T   D E S C R I P T I O N"]
[null,null,{"$f":"'Rental Calculator'!C18","v":0}]
[]
[null,null,"CAPITAL EX VAT",{"$nulls":4},{"$f":"'Rental Calculator'!L6","v":{"$error":"#REF!"}}]
[]
[null,null,"TERM",{"$nulls":4},{"$f":"'Rental Calculator'!L8& \" MONTHS\"","v":"60 MONTHS"}]
[]
[null,null,"RENTAL AMOUNT EX VAT",{"$nulls":4},{"$f":"'Rental Calculator'!H15","v":{"$error":"#REF!"}}]
[]
[null,null,"DOCUMENTATION FEE EX VAT",{"$nulls":4},{"$f":"H24*0.75%","v":{"$error":"#REF!"}}]
[]
[null,null,"OPTIONAL INSURANCE EX VAT",{"$nulls":4},{"$f":"H24*0.5%","v":{"$error":"#REF!"}}]
[]
[null,null,"TERMS AND CONDITIONS"]
[null,null,"• ","Factors exclude VAT"]
[null,null,"• ","Factors are linked to prime"]
[null,null,"• ","Calculations are done in advance taking current rental costing factors(including risk) into consideration & are subject to change"]
[null,null,"• ","Factors exclude insurance and proof of insurance required. Insurance is available though Merchant West, quoted as above at 0.5% of the capital value"]
[null,null,"• ","A once-off Documentation Fee is charged at a fixed 0.75% of the capital value"]
[null,null,"• ","Rentals including a settlement / trade-in / second-hand of refurbished equipment need to be disclosed and require written approval."]
[null,null,"• ","Merchant West reserves the right to cancel any approvals upon knowledge of undisclosed items"]
[null,null,"• ","Debit orders are mandatory (R30 excl. VAT need be added to the rental in the event of no debit order being signed)"]
[null,null,"• ","Special structures ad factors are available upon request and written approval"]
[null,null,"• ","Merchant West reserves the right to amend all errors arising out of a miscalculation"]
[null,null,"• ","Ownership available at one additional rental (not calculated in quote)"]
[null,null,"Merchant West or its cessionary may also give this information to any person who in its opinion, needs it to carry out any of Merchant West or its cessionary's rights or duties in terms of the contract or any law pertaining to the products I/we have requested."]
[]
[]
[null,null,"I certify that the above quote, terms and conditions have been explained to me in full."]
[]
[]
[null,null,"SIGNATURE:",{"$nulls":3},"FULL NAME:"]
[]
[]
[null,null,"DATE:",{"$nulls":3},"CAPACITY:"]

{"sheet":"Application","index":2,"n_rows":52,"n_cols":58,"rows_kept":52,"hidden":true,"merged":[[2,3,2,58],[3,3,3,58],[4,3,4,58],[5,3,5,58],[6,3,17,4],[6,5,6,9],[6,10,6,42],[6,43,6,46],[6,47,6,58],[7,5,7,9],[7,10,7,42],[7,43,7,46],[7,47,7,58],[8,5,8,9],[8,10,8,11],[8,12,8,14],[8,15,8,16],[8,17,8,19],[8,20,8,21],[8,22,8,26],[8,27,8,28],[8,29,8,36],[8,37,8,38],[8,39,8,58],[9,5,9,7],[9,8,9,22],[9,23,9,26],[9,27,9,40],[9,41,9,48],[9,49,9,58],[10,5,10,18],[10,19,10,28],[10,29,10,33],[10,34,10,58],[11,5,11,11],[11,12,11,32],[11,33,11,36],[11,37,11,58],[12,5,12,8],[12,9,12,22],[12,23,12,26],[12,27,12,37],[12,38,12,43],[12,44,12,58],[13,5,13,10],[13,11,13,20],[13,21,13,29],[13,30,13,37],[13,38,13,49],[13,50,13,58],[14,5,14,10],[14,11,14,31],[14,32,14,37],[14,38,14,58],[15,5,15,31],[15,32,15,58],[16,5,16,31],[16,32,16,58],[17,5,17,22],[17,23,17,27],[17,28,17,31],[17,32,17,49],[17,50,17,54],[17,55,17,58],[18,3,18,58],[19,3,27,4],[19,5,20,20],[19,21,20,27],[19,28,20,31],[19,32,20,46],[19,47,19,50],[19,51,19,58],[20,47,20,48],[20,49,20,50],[20,51,20,52],[20,53,20,54],[20,55,20,58],[21,5,21,20],[21,21,21,27],[21,28,21,31],[21,32,21,46],[21,47,21,48],[21,49,21,50],[21,51,21,52],[21,53,21,54],[21,55,21,58],[22,5,22,20],[22,21,22,27],[22,28,22,31],[22,32,22,46],[22,47,22,48],[22,49,22,50],[22,51,22,52],[22,53,22,54],[22,55,22,58],[23,5,23,20],[23,21,23,27],[23,28,23,31],[23,32,23,46],[23,47,23,48],[23,49,23,50],[23,51,23,52],[23,53,23,54],[23,55,23,58],[24,5,24,21],[24,22,24,25],[24,26,24,58],[25,5,25,8],[25,9,25,21],[25,22,25,25],[25,26,25,38],[25,39,25,42],[25,43,25,58],[26,5,26,21],[26,22,26,25],[26,26,26,58],[27,5,27,8],[27,9,27,21],[27,22,27,25],[27,26,27,38],[27,39,27,42],[27,43,27,58],[28,3,28,58],[29,3,31,4],[29,5,29,11],[29,12,29,28],[29,29,29,33],[29,34,29,42],[29,43,29,47],[29,48,29,58],[30,5,30,11],[30,12,30,28],[30,29,30,33],[30,34,30,42],[30,43,30,47],[30,48,30,58],[31,5,31,11],[31,12,31,28],[31,29,31,33],[31,34,31,42],[31,43,31,47],[31,48,31,58],[32,3,32,58],[33,3,41,4],[33,5,33,26],[33,27,33,42],[33,43,33,48],[33,49,33,58],[34,5,34,26],[34,27,34,42],[34,43,34,48],[34,49,34,58],[35,5,35,26],[35,27,35,42],[35,43,35,48],[35,49,35,58],[36,5,36,26],[36,27,36,42],[36,43,36,48],[36,49,36,58],[37,5,37,26],[37,27,37,42],[37,43,37,48],[37,49,37,58],[38,5,38,26],[38,27,38,42],[38,43,38,48],[38,49,38,58],[39,5,39,8],[39,9,39,58],[40,5,40,8],[40,9,40,20],[40,21,40,24],[40,25,40,29],[40,30,40,39],[40,40,40,44],[40,45,40,49],[40,50,40,51],[40,52,40,56],[40,57,40,58],[41,5,41,8],[41,9,41,19],[41,20,41,23],[41,24,41,25],[41,26,41,31],[41,32,41,33],[41,34,41,37],[41,38,41,39],[41,40,41,50],[41,51,41,56],[41,57,41,58],[42,3,42,58],[43,3,48,3],[43,4,48,57],[43,58,48,58],[49,3,49,58],[50,3,50,58],[51,3,51,8],[51,9,51,18],[51,19,51,24],[51,25,51,35],[51,36,51,40],[51,41,51,49],[51,50,51,52],[51,53,51,58]]}
[]
[]
[]
[{"$nulls":3},"Please provide attached information: GL - Requirements for Credit Application"]
[]
[{"$nulls":3},"CREDIT APPLICATION FORM"]
[{"$nulls":3},"COMPANY",null,"APPLICANT",{"$nulls":37},"REG NR"]
[{"$nulls":5},"TRADING AS",{"$nulls":37},"VAT REG NR"]
[{"$nulls":5},"(PTY) LTD",{"$nulls":6},"LTD",{"$nulls":4},"CC",{"$nulls":4},"SOLE PROP",{"$nulls":6},"OTHER (Specify)"]
[{"$nulls":5},"TEL NR",{"$nulls":17},"FAX NR",{"$nulls":17},"DATE ESTABLISHED"]
[{"$nulls":5},"HOW LONG UNDER CURRENT MANAGEMENT",{"$nulls":23},"WEB ADDRESS"]
[{"$nulls":5},"NATURE OF BUSINESS",{"$nulls":27},"INDUSTRY"]
[{"$nulls":5},"BANKERS",{"$nulls":17},"BRANCH",{"$nulls":14},"CHEQUE ACC NR"]
[{"$nulls":5},"DATE ACC OPENED",{"$nulls":15},"FINANCIAL YEAR END MONTH",{"$nulls":16},"LATEST FINANCIALS AVAILABLE (YR)"]
[{"$nulls":5},"STREET ADDRESS",{"$nulls":26},"POSTAL ADDRESS"]
[]
[]
[{"$nulls":23},"POSTAL CODE",{"$nulls":26},"POSTAL CODE"]
[]
[{"$nulls":3},"SHAREHOLDERS",null,"FULL NAME",{"$nulls":15},"ID NUMBER / \nREG NR",{"$nulls":6},"% \nSHARE",{"$nulls":3},"RESIDENTIAL ADDRESS",{"$nulls":14},"OWNER",{"$nulls":3},"MARITAL STATUS"]
[{"$nulls":47},"YES",null,"NO",null,"ANC",null,"COP",null,"OTHER"]
[]
[]
[]
[{"$nulls":5},"CONTACT FOR INSTALLATION CONFIRMATION",{"$nulls":16},"NAME"]
[{"$nulls":5},"TEL NR",{"$nulls":16},"CELL NR",{"$nulls":16},"EMAIL"]
[{"$nulls":5},"CONTACT FOR IINVOICING",{"$nulls":16},"NAME"]
[{"$nulls":5},"TEL NR",{"$nulls":16},"CELL NR",{"$nulls":16},"EMAIL"]
[]
[{"$nulls":3},"OTHER",null,"LANDLORD NAME",{"$nulls":23},"CONTACT",{"$nulls":13},"TEL NR"]
[{"$nulls":5},"INSURANCE NAME",{"$nulls":23},"CONTACT",{"$nulls":13},"POLICY NR"]
[{"$nulls":5},"AUDITOR NAME",{"$nulls":23},"CONTACT",{"$nulls":13},"TEL NR"]
[]
[{"$nulls":3},"EQUIPMENT",null,"MAKE",{"$nulls":21},"MODEL",{"$nulls":15},"QUANTITY",{"$nulls":5},"VALUE"]
[]
[]
[]
[]
[]
[{"$nulls":5},"SUPPLIER",{"$nulls":3},"LIGHT KINETICS (PTY) LTD"]
[{"$nulls":5},"VALUE",{"$nulls":15},"INCL VAT",{"$nulls":3},"RENTAL",{"$nulls":14},"EXCL VAT",{"$nulls":4},"LINKED"]
[{"$nulls":5},"TERM",{"$nulls":14},"MONTHS",{"$nulls":5},"QUARTERS",{"$nulls":7},"YEARS",{"$nulls":5},"ANNUAL ESCALATION",{"$nulls":10},0,{"$nulls":5},"%"]
[]
[{"$nulls":4},"I/we consent to Merchant West (Pty) Ltd (\"Merchant West\") or its cessionary making enquiries about my/our credit record with any credit reference agency and any other party to confirm the details on this application.  Merchant West or its cessionary may also provide credit reference agencies with regular updates regarding how I/we manage my/our account, including my/our failure to meet agreed terms and conditions.  I/we consent that credit reference agencies may, in turn, make the records and details available to other credit grantors.  Merchant West or its cessionary may also give this information to any person who in its opinion, needs it to carry out any of Merchant West or its cessionary's rights or duties in terms of the contract or any law pertaining to the products I/we have requested."]
[]
[]
[]
[]
[]
[{"$nulls":3},"I certify that the above details are true and correct"]
[]
[{"$nulls":3},"SIGNATURE",{"$nulls":15},"FULL NAMES",{"$nulls":16},"CAPACITY",{"$nulls":13},"DATE:"]

{"sheet":"Sibonile School-Rev0","index":3,"n_rows":171,"n_cols":19,"rows_kept":171,"merged":[[0,0,0,14]]}
["Audit Report Sheet for Sibonile School for the Blind"]
[]
["Client_Name","Site_ID","Site_Name","Area","Sub Area","Lighting_Technology","Fixture_Type","Mount_Type","Number_Lights_Per_Fixture","Total_Number_of_Fixtures","Number_Of_Faulty_Lights","Lamp_Estimated_Capacity","Light_Fixture_Estimated_Capacity","Light_Measured_Capacity","Estimated_Operating_Hours","Measured_Operating_Hours","Estimated_Baseline_kWh","Measured_Baseline_kWh","Optimal_Operating_Hours"]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A2","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I4*L4)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A2","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I5*L5)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A3","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I6*L6)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A3","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I7*L7)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A4","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I8*L8)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A4","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I9*L9)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A5","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,80,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A6","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foundation Block","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foundation Block","Compact Fluorescent","Bowl Fitting","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Passage","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A8","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I15*L15)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A8","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I16*L16)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A10","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,40,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A11","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I18*L18)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A11","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I19*L19)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Admin / Computer","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Admin / Computer","Halogen","Downlight","Recessed",1,15,null,50,50,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Ladies Toilet","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Gents Toilet","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I24*L24)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Finance","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,80,{"$f":"SUM(I25*L25)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Finance","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I26*L26)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I27*L27)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",1,2,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","LTSM Store","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,80,80,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Office","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Staffroom","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Staffroom","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Principal's Office","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",1,2,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B1","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B2","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B3","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B4","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B5","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Computer","Tubular Fluorescent","LBR Fitting","Surface Mount",2,7,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH1","Tubular Fluorescent","Deco Fitting","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH2A","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH2B","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH3","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH4","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH5 - Bathroom","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH5 - Bathroom","Halogen","Downlight","Recessed",1,7,null,50,50,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH6","Tubular Fluorescent","Deco Fitting","Surface Mount",2,9,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH6 Passage","Compact Fluorescent","Bulkhead","Surface Mount",1,3,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH7 - Not Open","Tubular Fluorescent","Deco Fitting","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH8","Tubular Fluorescent","Deco Fitting","Surface Mount",2,10,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH9","Tubular Fluorescent","Deco Fitting","Surface Mount",2,7,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH9","Halogen","Downlight","Recessed",1,2,null,50,50,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH10","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH11","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH12","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH13","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH14A","Tubular Fluorescent","Open Channel","Surface Mount",2,9,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH14B","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH15","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH15","Halogen","Downlight","Recessed",1,10,null,50,50,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH16","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH17A","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH17B","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH Passage","Tubular Fluorescent","Deco Fitting","Surface Mount",2,14,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH Outside Passage","Tubular Fluorescent","Deco Fitting","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH Foyer","Tubular Fluorescent - LED","Open Channel","Surface Mount",2,3,null,20,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH18 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH18 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH19 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH19 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH17","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH17","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,80,80,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH17","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent - LED","Open Channel","Surface Mount",2,2,null,20,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Dressing Room","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","TV Room","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Boys Room1","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Boys Room1","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Boys Room2","Tubular Fluorescent","Open Channel","Surface Mount",1,2,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH24","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH23","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH22","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH21","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH20","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,{"$f":"SUM(I91*L91)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Kitchen","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH15","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH15","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH14","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH14","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH13","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH12","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH11","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH7","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH6","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH5","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH4","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH3","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH2","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH1","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Ladies Toilet","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Ladies Toilet","Compact Fluorescent","Downlight","Recessed",2,1,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Gents Toilet","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Gents Toilet","Compact Fluorescent","Downlight","Recessed",2,1,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Paraplegic Toilet","Compact Fluorescent","Downlight","Recessed",2,1,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Foyer","Compact Fluorescent","Downlight","Recessed",2,3,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Passage","Compact Fluorescent","Bulkhead","Surface Mount",2,10,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Dining Hall 1","Compact Fluorescent","Pendant","Suspended",1,12,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Dining Hall 2","Compact Fluorescent","Pendant","Suspended",1,12,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Dining Hall 3","Compact Fluorescent","Pendant","Suspended",1,12,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Tuckshop","Compact Fluorescent","Downlight","Recessed",2,8,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Cleaning Store","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Store 1","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Store 2","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Store 3","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Changing Room","Compact Fluorescent","Bulkhead","Surface Mount",2,4,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",1,11,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent - LED","Open Channel","Surface Mount",1,1,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block C","C1","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block C","C2","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block C","C3","Tubular Fluorescent","Deco Fitting","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block D","D1","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block D","D2","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block D","D3","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E1","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E2","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E3","Tubular Fluorescent","Open Channel","Surface Mount",1,6,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E4","Tubular Fluorescent","Open Channel","Surface Mount",1,6,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Therapy House","All","Compact Fluorescent","Bowl Fitting","Surface Mount",1,14,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Entrance","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Foyer","Compact Fluorescent","Bowl Fitting","Surface Mount",1,4,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Ladies Toilet","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Gents Toilet","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,40,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","F2","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Admin Brain","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Passage Upstairs","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Stores Upstairs","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Stores Downstairs","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Kitchen","Tubular Fluorescent","Deco Fitting","Surface Mount",2,1,null,40,80,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Incandescent","High Bay","Recessed",1,12,null,500,500,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Reflector Lamps","Downlight","Recessed",1,6,null,250,250,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Behind Stage","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,{"$f":"SUM(I155*L155)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Behind Stage","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Under Stage","Compact Fluorescent","Bowl Fitting","Surface Mount",1,6,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Metal Halide","Floodlight","Wall Mount",1,17,null,400,400,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Mercury Vapour","Floodlight","Wall Mount",1,6,null,125,125,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Floodlight","Wall Mount",1,2,null,85,85,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Halogen","Floodlight","Wall Mount",1,9,null,500,500,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Bulkhead","Wall Mount",1,27,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Bulkhead","Wall Mount",2,21,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Bowl Fitting","Wall Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","Garage","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","Garage","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","Tuckshop","Tubular Fluorescent","Open Channel","Surface Mount",1,3,null,40,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Metal Halide","Floodlight","Wall Mount",1,16,null,400,400,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Metal Halide","Floodlight","Wall Mount",1,16,null,400,400,null,6]

{"sheet":"Study Data_Rev0","index":4,"n_rows":47,"n_cols":29,"rows_kept":47,"merged":[[0,1,0,19],[0,21,0,27],[3,3,3,8],[4,3,4,9],[5,1,6,1],[5,21,5,27],[8,21,8,27],[33,1,34,1]]}
[null,"Audit Report Sheet for Sibonile School for the Blind",{"$nulls":19},"Audit Report Sheet for Sibonile School for the Blind"]
[]
[]
[null,"Survey information","Date:","Site:"]
[null,null,"2021-09-26","Sibonile School for the Blind",{"$nulls":24},1.07]
[null,"Current Installation",{"$nulls":19},"QUOTATION"]
[]
[null,null,"Light Type","Qty","#Lamps","Lamp W","Loss Fact.","Indiv. Load","Total Load","Ops. Hrs.","kWh per month","kWh per Annum","Lamp Lifespan","Avg. Group Re-lamp in years","Cost of Lamp*","Cost of Ballast","Labour cost of Re-lamp*","Combined maintenance cost","Annual Maintenance Factor","Annual Maintenance Costs",null,"Luminaire Description ","Qty","Fixture Unit Price","Fixture Unit Price Total","Installation Unit Price","Installation Unit Price Total","Total"]
[{"$nulls":21},{"$f":"B9","v":0}]
[null,null,"Bulkhead / Bowl Fitting (1 Lamp)",70,1,26,{"v":1.1,"d":"1.10"},{"$f":"G10*F10*E10","v":28.6},{"$f":"H10*D10","v":{"v":2002,"d":"2,002"}},6,{"$f":"(I10*J10)/1000*30.5","v":{"v":366.366,"d":"366.37"}},{"$f":"(I10*J10)/1000*365","v":{"v":4384.38,"d":"4,384.38"}},{"v":10000,"d":"10,000.00"},{"$f":"M10/(J10*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":55,"d":"R 55.00"},0,{"v":50,"d":"R 50.00"},{"$f":"(O10*E10)+(P10/5)+Q10","v":{"v":105,"d":"R 105.00"}},{"$f":"1/N10","v":{"v":0.27375,"d":"27.38%"}},{"$f":"D10*R10*S10","v":{"v":2012.0625,"d":"R 2,012"}},null,"Titan Bulkhead 21W",0,{"$f":"740*AC$5","v":{"v":791.8000000000001,"d":"R791.80"}},{"$f":"X10*W10","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(W10*Z10)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y10,AA10)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Bulkhead / Bowl Fitting (2 Lamp)",39,2,26,{"v":1.1,"d":"1.10"},57.2,{"v":2230.8,"d":"2,231"},6,{"v":408.2364,"d":"408.24"},{"$f":"(I11*J11)/1000*365","v":{"v":4885.452,"d":"4,885.45"}},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":55,"d":"R 55.00"},0,{"v":50,"d":"R 50.00"},{"v":160,"d":"R 160.00"},{"v":0.27375,"d":"27.38%"},{"v":1708.2,"d":"R 1,708"},null,"Titan Bulkhead 21W",0,{"$f":"740*AC$5","v":{"v":791.8000000000001,"d":"R791.80"}},{"$f":"X11*W11","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(W11*Z11)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y11,AA11)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Downlight CFL",14,2,18,{"v":1.1,"d":"1.10"},39.6,{"v":554.4,"d":"554"},6,{"v":101.45519999999999,"d":"101.46"},{"v":1214.1359999999997,"d":"1,214.14"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":55,"d":"R 55.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":205.8,"d":"R 205.80"},{"v":0.27375,"d":"27.38%"},{"v":788.7285,"d":"R 789"},null,"DLV-R 6\" 17W",0,{"$f":"930*AC$5","v":{"v":995.1,"d":"R995.10"}},{"$f":"X12*W12","v":{"v":0,"d":"R0.00"}},null,{"$f":"SUM(W12*Z12)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y12,AA12)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Lamps",36,1,20,{"v":1.1,"d":"1.10"},22,792,6,{"v":144.936,"d":"144.94"},{"v":1734.48,"d":"1,734.48"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":85,"d":"R 85.00"},0,{"v":50,"d":"R 50.00"},{"v":135,"d":"R 135.00"},{"v":0.27375,"d":"27.38%"},{"v":1330.425,"d":"R 1,330"},null,"LED Lamp 10W",0,{"$f":"150*AC$5","v":{"v":160.5,"d":"R160.50"}},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Downlight Halogen",34,1,50,{"v":1.1,"d":"1.10"},55.00000000000001,{"v":1870.0000000000002,"d":"1,870"},6,{"v":342.2100000000001,"d":"342.21"},{"v":4095.300000000001,"d":"4,095.30"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":55,"d":"R 55.00"},{"v":200,"d":"R 200.00"},{"v":50,"d":"R 50.00"},{"v":145,"d":"R 145.00"},{"v":0.27375,"d":"27.38%"},{"v":1349.5874999999999,"d":"R 1,350"},null,"DLV GU10 6W Splash",{"$f":"D14","v":34},{"$f":"300*AC$5","v":{"v":321,"d":"R321.00"}},{"v":10914,"d":"R10,914.00"},null,{"v":0,"d":"R0.00"},{"v":10914,"d":"R10,914.00"}]
[null,null,"Downlight Reflector Lamps",6,1,250,{"v":1.1,"d":"1.10"},275,{"v":1650,"d":"1,650"},6,301.95,{"v":3613.5,"d":"3,613.50"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":500,"d":"R 500.00"},0,{"v":450,"d":"R 450.00"},{"v":950,"d":"R 950.00"},{"v":0.27375,"d":"27.38%"},{"v":1560.375,"d":"R 1,560"},null,"DLV-R 8\" 49W",6,{"$f":"1100*AC$5","v":{"v":1177,"d":"R1,177.00"}},{"v":7062,"d":"R7,062.00"},null,{"v":0,"d":"R0.00"},{"v":7062,"d":"R7,062.00"}]
[null,null,"Open Channel / Deco",41,1,36,{"v":1.1,"d":"1.10"},39.6,{"v":1623.6000000000001,"d":"1,624"},6,{"v":297.1188,"d":"297.12"},{"v":3555.684,"d":"3,555.68"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":135.8,"d":"R 135.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":1016.1234999999998,"d":"R 1,016"},null,"E-Batten 32W / Marea",0,{"$f":"950*AC$5","v":{"v":1016.5000000000001,"d":"R1,016.50"}},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Open Channel / Deco",5,1,58,{"v":1.1,"d":"1.10"},63.800000000000004,319,6,{"v":58.376999999999995,"d":"58.38"},698.61,{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":135.8,"d":"R 135.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":123.91749999999998,"d":"R 124"},null,"E-Batten 32W / Marea",5,{"v":1016.5000000000001,"d":"R1,016.50"},{"v":5082.500000000001,"d":"R5,082.50"},null,{"v":0,"d":"R0.00"},{"v":5082.500000000001,"d":"R5,082.50"}]
[null,null,"Open Channel / Deco",15,1,80,{"v":1.1,"d":"1.10"},88,{"v":1320,"d":"1,320"},6,241.56,{"v":2890.8,"d":"2,890.80"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":300,"d":"R 300.00"},{"v":800,"d":"R 800.00"},{"v":50,"d":"R 50.00"},{"v":510,"d":"R 510.00"},{"v":0.18249999999999997,"d":"18.25%"},{"v":1396.1249999999998,"d":"R 1,396"},null,"E-Batten 32W / Marea",15,{"v":1016.5000000000001,"d":"R1,016.50"},{"v":15247.500000000002,"d":"R15,247.50"},null,{"v":0,"d":"R0.00"},{"v":15247.500000000002,"d":"R15,247.50"}]
[null,null,"Open Channel / Deco",266,2,36,{"v":1.1,"d":"1.10"},79.2,{"v":21067.2,"d":"21,067"},6,{"v":3855.2976000000003,"d":"3,855.30"},{"v":46137.168000000005,"d":"46,137.17"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":175.8,"d":"R 175.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":8534.211,"d":"R 8,534"},null,"E-Batten 32W / Marea",0,{"v":1016.5000000000001,"d":"R1,016.50"},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,null,"Open Channel / Deco",14,2,58,{"v":1.1,"d":"1.10"},127.60000000000001,{"v":1786.4,"d":"1,786"},6,{"v":326.9112,"d":"326.91"},{"v":3912.2160000000003,"d":"3,912.22"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":175.8,"d":"R 175.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":449.169,"d":"R 449"},null,"E-Batten 32W / Marea",14,{"v":1016.5000000000001,"d":"R1,016.50"},{"v":14231.000000000002,"d":"R14,231.00"},null,{"v":0,"d":"R0.00"},{"v":14231.000000000002,"d":"R14,231.00"}]
[null,null,"Open Channel / Deco",5,2,80,{"v":1.1,"d":"1.10"},176,880,6,{"v":161.04000000000002,"d":"161.04"},{"v":1927.2,"d":"1,927.20"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":300,"d":"R 300.00"},{"v":800,"d":"R 800.00"},{"v":50,"d":"R 50.00"},{"v":810,"d":"R 810.00"},{"v":0.18249999999999997,"d":"18.25%"},{"v":739.1249999999999,"d":"R 739"},null,"E-Batten 32W / Marea",5,{"v":1016.5000000000001,"d":"R1,016.50"},{"v":5082.500000000001,"d":"R5,082.50"},null,{"v":0,"d":"R0.00"},{"v":5082.500000000001,"d":"R5,082.50"}]
[null,null,"Surface LBR Fitting",7,2,58,{"v":1.1,"d":"1.10"},127.60000000000001,{"v":893.2,"d":"893"},6,{"v":163.4556,"d":"163.46"},{"v":1956.1080000000002,"d":"1,956.11"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":175.8,"d":"R 175.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":224.5845,"d":"R 225"},null,"EOS 600x600 LED Panel",7,{"$f":"800*AC$5","v":{"v":856,"d":"R856.00"}},{"v":5992,"d":"R5,992.00"},null,{"v":0,"d":"R0.00"},{"v":5992,"d":"R5,992.00"}]
[null,null,"Open Channel / Deco LED 1 Lamp",1,1,20,{"v":1.1,"d":"1.10"},22,22,6,{"v":4.026,"d":"4.03"},48.18,{"v":8000,"d":"8,000.00"},{"v":2.922374429223744,"d":"2.92"},{"v":100,"d":"R 100.00"},null,{"v":50,"d":"R 50.00"},{"v":150,"d":"R 150.00"},{"v":0.34218750000000003,"d":"34.22%"},{"v":51.32812500000001,"d":"R 51"},null,"E-Batten 32W / Marea",1,{"$f":"950*AC$5","v":{"v":1016.5000000000001,"d":"R1,016.50"}},{"v":1016.5000000000001,"d":"R1,016.50"},null,{"v":0,"d":"R0.00"},{"v":1016.5000000000001,"d":"R1,016.50"}]
[null,null,"Open Channel / Deco LED 2 Lamp",5,2,20,{"v":1.1,"d":"1.10"},44,220,6,{"v":40.260000000000005,"d":"40.26"},{"v":481.8,"d":"481.80"},{"v":8000,"d":"8,000.00"},{"v":2.922374429223744,"d":"2.92"},{"v":100,"d":"R 100.00"},null,{"v":50,"d":"R 50.00"},{"v":250,"d":"R 250.00"},{"v":0.34218750000000003,"d":"34.22%"},{"v":427.73437500000006,"d":"R 428"},null,"E-Batten 32W / Marea",5,{"$f":"950*AC$5","v":{"v":1016.5000000000001,"d":"R1,016.50"}},{"v":5082.500000000001,"d":"R5,082.50"},null,{"v":0,"d":"R0.00"},{"v":5082.500000000001,"d":"R5,082.50"}]
[null,null,"High Bay Incandescent",12,1,500,{"v":1.1,"d":"1.10"},550,{"v":6600,"d":"6,600"},6,{"v":1207.8,"d":"1,207.80"},{"v":14454,"d":"14,454.00"},{"v":8000,"d":"8,000.00"},{"v":2.922374429223744,"d":"2.92"},{"v":500,"d":"R 500.00"},null,{"v":450,"d":"R 450.00"},{"v":950,"d":"R 950.00"},{"v":0.34218750000000003,"d":"34.22%"},{"v":3900.9375000000005,"d":"R 3,901"},null,"O-Bay 200W",12,{"$f":"1750*AC$5","v":{"v":1872.5,"d":"R1,872.50"}},{"v":22470,"d":"R22,470.00"},null,{"v":0,"d":"R0.00"},{"v":22470,"d":"R22,470.00"}]
[null,null,"Floodlight CFL",2,1,85,{"v":1.1,"d":"1.10"},93.50000000000001,{"v":187.00000000000003,"d":"187"},6,{"v":34.22100000000001,"d":"34.22"},{"v":409.53000000000014,"d":"409.53"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":300,"d":"R 300.00"},{"v":600,"d":"R 600.00"},{"v":150,"d":"R 150.00"},{"v":570,"d":"R 570.00"},{"v":0.27375,"d":"27.38%"},{"v":312.075,"d":"R 312"},null,"Larvik 100W Floodlight",2,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"v":5457,"d":"R5,457.00"},null,{"v":0,"d":"R0.00"},{"v":5457,"d":"R5,457.00"}]
[null,null,"Floodlight Mercury Vapour",6,1,125,{"v":1.1,"d":"1.10"},137.5,825,6,{"v":150.975,"d":"150.98"},{"v":1806.75,"d":"1,806.75"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":300,"d":"R 300.00"},{"v":600,"d":"R 600.00"},{"v":150,"d":"R 150.00"},{"v":570,"d":"R 570.00"},{"v":0.27375,"d":"27.38%"},{"v":936.225,"d":"R 936"},null,"Larvik 100W Floodlight",6,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"v":16371,"d":"R16,371.00"},null,{"v":0,"d":"R0.00"},{"v":16371,"d":"R16,371.00"}]
[null,null,"Floodlight Metal Halide",49,1,125,{"v":1.1,"d":"1.10"},137.5,{"v":6737.5,"d":"6,738"},6,{"v":1232.9624999999999,"d":"1,232.96"},{"v":14755.124999999998,"d":"14,755.13"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":600,"d":"R 600.00"},{"v":1300,"d":"R 1,300.00"},{"v":150,"d":"R 150.00"},{"v":1010,"d":"R 1,010.00"},{"v":0.27375,"d":"27.38%"},{"v":13547.887499999999,"d":"R 13,548"},null,"Larvik 100W Floodlight",49,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"v":133696.5,"d":"R133,696.50"},null,{"v":0,"d":"R0.00"},{"v":133696.5,"d":"R133,696.50"}]
[null,null,"Floodlight Halogen",9,1,500,{"v":1.1,"d":"1.10"},550,{"v":4950,"d":"4,950"},6,905.85,{"v":10840.5,"d":"10,840.50"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":300,"d":"R 300.00"},0,{"v":150,"d":"R 150.00"},{"v":450,"d":"R 450.00"},{"v":0.27375,"d":"27.38%"},{"v":1108.6875,"d":"R 1,109"},null,"Larvik 100W Floodlight",9,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"v":24556.5,"d":"R24,556.50"},null,{"v":0,"d":"R0.00"},{"v":24556.5,"d":"R24,556.50"}]
[null,"Grand Total Fixtures",null,{"$f":"SUM(D9:D29)","v":636},{"$nulls":4},{"$f":"SUM(I10:I29)","v":{"v":56530.1,"d":"56,530"}},null,null,{"$f":"SUM(L10:L29)","v":{"v":123800.91900000001,"d":"123,801"}},{"$nulls":7},{"$f":"SUM(T10:T29)","v":{"v":41517.509,"d":"R 41,518"}},null,"Contingency for Extra Lighting in certain areas",0,{"$f":"1200*AC$5","v":{"v":1284,"d":"R1,284.00"}},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":21},"Contingency for Emergency Fittings",0,{"$f":"1200*AC$5","v":{"v":1284,"d":"R1,284.00"}},{"v":0,"d":"R0.00"},null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[{"$nulls":24},{"$f":"SUM(Y10:Y31)","v":{"v":272261.5,"d":"R272,261.50"}},null,{"$f":"SUM(AA10:AA31)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":19},{"$f":"T30/D30","v":{"v":65.27910220125786,"d":"65.28"}},null,null," ",null,"Sub Total",null,"Sub Total",{"$f":"SUM(AB10:AB31)","v":{"v":272261.5,"d":"R272,261.50"}}]
[null,"Energy Efficient Installation "]
[{"$nulls":24},"Total Excluding Vat",null,"Total Excluding VAT",{"$f":"SUM(AB33)","v":{"v":272261.5,"d":"R272,261.50"}}]
[null,null,"Light Type","Qty","#Lamps","Lamp W","Loss Fact.","Indiv. Load","Total Load","Op. Hours ","kWh per month","kWh per Annum","Expected Lifespan to L80","Avg. Re-lamp in years","Cost of Lamp",null,"Labour cost of Re-lamp","Combined maintenance cost","Annual Maintenance Factor","Annual Maintenance Costs",{"$nulls":4},"Vat",null,"VAT 15%",{"$f":"AB35*15%","v":{"v":40839.225,"d":"R40,839.23"}}]
[null,null,"Titan Bulkhead 21W",109,1,136,{"v":1.1,"d":"1.10"},{"$f":"G37*F37*E37","v":149.60000000000002},{"$f":"H37*D37","v":16306.400000000003},6,{"$f":"(I37*J37)/1000*30.5","v":{"v":2984.0712000000008,"d":"2,984.07"}},{"$f":"(I37*J37)/1000*365","v":{"v":35711.01600000001,"d":"35,711.02"}},{"v":50000,"d":"50,000.00"},{"$f":"M37/(J37*365)*0.8","v":{"v":18.264840182648403,"d":"18.26"}},0,0,0,{"$f":"(O37*E37)+(P37/5)+Q37","v":0},{"$f":"1/N37","v":{"v":0.05475,"d":"5.48%"}},{"$f":"D37*R37*S37","v":0},{"$nulls":4},"Total Including Vat",null,"Total Including VAT",{"$f":"AB36+AB35","v":{"v":313100.725,"d":"R313,100.73"}}]
[null,null,"DLV-R 6\"17W",14,1,6,{"v":1.1,"d":"1.10"},{"$f":"G38*F38*E38","v":6.6000000000000005},92.4,6,{"v":16.909200000000002,"d":"16.91"},{"v":202.35600000000005,"d":"202.36"},{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"$f":"1/N38","v":{"v":0.05475,"d":"5.48%"}},0]
[null,null,"LED Lamp 10W",36,1,16,{"v":1.1,"d":"1.10"},{"$f":"G39*F39*E39","v":17.6},633.6,6,{"v":115.94880000000002,"d":"115.95"},{"v":1387.5840000000003,"d":"1,387.58"},{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"DLV GU10 6W Splash",34,1,32,{"v":1.1,"d":"1.10"},{"$f":"G40*F40*E40","v":35.2},1196.8000000000002,6,{"v":219.01440000000005,"d":"219.01"},{"v":2620.9920000000006,"d":"2,620.99"},{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"DLV-R 8\" 49W",6,1,30,{"v":1.1,"d":"1.10"},33,198,6,{"v":36.234,"d":"36.23"},433.62,{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"E-Batten 32W / Marea",352,1,42,{"v":1.1,"d":"1.10"},46.2,16262.400000000001,6,{"v":2976.0192,"d":"2,976.02"},{"v":35614.656,"d":"35,614.66"},{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"EOS 600x600 LED Panel",7,1,10,{"v":1.1,"d":"1.10"},11,77,6,{"v":14.091000000000001,"d":"14.09"},168.63,{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"O-Bay 200W",12,1,100,{"v":1.1,"d":"1.10"},110.00000000000001,1320.0000000000002,6,{"v":241.56000000000006,"d":"241.56"},{"v":2890.8000000000006,"d":"2,890.80"},{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"Larvik 100W Floodlight",66,{"$nulls":4},0,6,0,0,{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,{"$f":"(O45*E45)+(P45/5)+Q45","v":0},{"v":0.05475,"d":"5.48%"},0]
[{"$nulls":3},636,{"$nulls":4},{"$f":"SUM(I37:I45)","v":36086.600000000006},null,null,{"$f":"SUM(L37:L45)","v":{"v":79029.65400000002,"d":"79,029.65"}}]
[null,"Totals",null," ",{"$nulls":4}," ",null,null," "]

{"sheet":"Sibonile School","index":5,"n_rows":171,"n_cols":19,"rows_kept":171,"merged":[[0,0,0,14]]}
["Audit Report Sheet for Sibonile School for the Blind"]
[]
["Client_Name","Site_ID","Site_Name","Area","Sub Area","Lighting_Technology","Fixture_Type","Mount_Type","Number_Lights_Per_Fixture","Total_Number_of_Fixtures","Number_Of_Faulty_Lights","Lamp_Estimated_Capacity","Light_Fixture_Estimated_Capacity","Light_Measured_Capacity","Estimated_Operating_Hours","Measured_Operating_Hours","Estimated_Baseline_kWh","Measured_Baseline_kWh","Optimal_Operating_Hours"]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A2","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I4*L4)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A2","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I5*L5)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A3","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I6*L6)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A3","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I7*L7)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A4","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I8*L8)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A4","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I9*L9)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A5","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I10*L10)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A6","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foundation Block","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foundation Block","Compact Fluorescent","Bowl Fitting","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Passage","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I14*L14)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A8","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I15*L15)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A8","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I16*L16)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A10","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,40,{"$f":"SUM(I17*L17)","v":40},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A11","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,80,{"$f":"SUM(I18*L18)","v":160},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","A11","Tubular Fluorescent","Open Channel","Suspended",1,2,null,80,{"$f":"SUM(I19*L19)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Admin / Computer","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,{"$f":"SUM(I20*L20)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Admin / Computer","Halogen","Downlight","Recessed",1,15,null,50,50,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Ladies Toilet","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,{"$f":"SUM(I22*L22)","v":36},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Gents Toilet","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,{"$f":"SUM(I23*L23)","v":36},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I24*L24)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Finance","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,80,{"$f":"SUM(I25*L25)","v":80},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Finance","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I26*L26)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I27*L27)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",1,2,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","LTSM Store","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,80,80,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Office","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,58,{"$f":"SUM(I30*L30)","v":116},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Staffroom","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,58,{"$f":"SUM(I31*L31)","v":116},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Staffroom","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block A","Principal's Office","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I33*L33)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,{"$f":"SUM(I34*L34)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",1,2,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Foyer","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,{"$f":"SUM(I36*L36)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B1","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B2","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B3","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B4","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","B5","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block B","Computer","Tubular Fluorescent","LBR Fitting","Surface Mount",2,7,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH1","Tubular Fluorescent","Deco Fitting","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH2A","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH2B","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH3","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH4","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH5 - Bathroom","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH5 - Bathroom","Halogen","Downlight","Recessed",1,7,null,50,50,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH6","Tubular Fluorescent","Deco Fitting","Surface Mount",2,9,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH6 Passage","Compact Fluorescent","Bulkhead","Surface Mount",1,3,null,26,{"$f":"SUM(I51*L51)","v":26},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH7 - Not Open","Tubular Fluorescent","Deco Fitting","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH8","Tubular Fluorescent","Deco Fitting","Surface Mount",2,10,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH9","Tubular Fluorescent","Deco Fitting","Surface Mount",2,7,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH9","Halogen","Downlight","Recessed",1,2,null,50,{"$f":"SUM(I55*L55)","v":50},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH10","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH11","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,{"$f":"SUM(I57*L57)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH12","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH13","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH14A","Tubular Fluorescent","Open Channel","Surface Mount",2,9,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH14B","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH15","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH15","Halogen","Downlight","Recessed",1,10,null,50,50,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH16","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,{"$f":"SUM(I64*L64)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH17A","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,{"$f":"SUM(I65*L65)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH17B","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,{"$f":"SUM(I66*L66)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH Passage","Tubular Fluorescent","Deco Fitting","Surface Mount",2,14,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block AH - Girls Hostel","AH Outside Passage","Tubular Fluorescent","Deco Fitting","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH Foyer","Tubular Fluorescent - LED","Open Channel","Surface Mount",2,3,null,20,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH18 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,{"$f":"SUM(I70*L70)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH18 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH19 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,{"$f":"SUM(I72*L72)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH19 - Toilets","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH17","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH17","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,80,80,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH17","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent - LED","Open Channel","Surface Mount",2,2,null,20,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Dressing Room","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","TV Room","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Boys Room1","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Boys Room1","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Boys Room2","Tubular Fluorescent","Open Channel","Surface Mount",1,2,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH24","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH23","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH22","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH21","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH20","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Passage","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,{"$f":"SUM(I92*L92)","v":26},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,6,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","Kitchen","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH15","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH15","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH14","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH14","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH13","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH12","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH11","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH7","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH6","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH5","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH4","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH3","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH2","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block GH - Boys Hostel","GH1","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Ladies Toilet","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Ladies Toilet","Compact Fluorescent","Downlight","Recessed",2,1,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Gents Toilet","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,{"$f":"SUM(I111*L111)","v":72},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Gents Toilet","Compact Fluorescent","Downlight","Recessed",2,1,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Paraplegic Toilet","Compact Fluorescent","Downlight","Recessed",2,1,null,18,{"$f":"SUM(I113*L113)","v":36},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Foyer","Compact Fluorescent","Downlight","Recessed",2,3,null,18,{"$f":"SUM(I114*L114)","v":36},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Passage","Compact Fluorescent","Bulkhead","Surface Mount",2,10,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Dining Hall 1","Compact Fluorescent","Pendant","Suspended",1,12,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Dining Hall 2","Compact Fluorescent","Pendant","Suspended",1,12,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Dining Hall 3","Compact Fluorescent","Pendant","Suspended",1,12,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Tuckshop","Compact Fluorescent","Downlight","Recessed",2,8,null,18,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Cleaning Store","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,{"$f":"SUM(I120*L120)","v":52},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Store 1","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,{"$f":"SUM(I121*L121)","v":52},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Store 2","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Store 3","Compact Fluorescent","Bulkhead","Surface Mount",2,1,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Changing Room","Compact Fluorescent","Bulkhead","Surface Mount",2,4,null,26,52,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",1,11,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Dining Hall","Kitchen","Tubular Fluorescent - LED","Open Channel","Surface Mount",1,1,null,20,20,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block C","C1","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block C","C2","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block C","C3","Tubular Fluorescent","Deco Fitting","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block D","D1","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block D","D2","Tubular Fluorescent","Deco Fitting","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block D","D3","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E1","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E2","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E3","Tubular Fluorescent","Open Channel","Surface Mount",1,6,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block E","E4","Tubular Fluorescent","Open Channel","Surface Mount",1,6,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Therapy House","All","Compact Fluorescent","Bowl Fitting","Surface Mount",1,14,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Entrance","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Foyer","Compact Fluorescent","Bowl Fitting","Surface Mount",1,4,null,26,{"$f":"SUM(I142*L142)","v":26},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Ladies Toilet","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Gents Toilet","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,40,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","F2","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,58,58,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Admin Brain","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Passage Upstairs","Compact Fluorescent","Bulkhead","Surface Mount",1,2,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Stores Upstairs","Tubular Fluorescent","Open Channel","Surface Mount",2,3,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Stores Downstairs","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Kitchen","Tubular Fluorescent","Deco Fitting","Surface Mount",2,1,null,40,80,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Tubular Fluorescent","Open Channel","Surface Mount",2,5,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Incandescent","High Bay","Recessed",1,12,null,500,500,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Hall","Reflector Lamps","Downlight","Recessed",1,6,null,250,250,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Behind Stage","Tubular Fluorescent","Open Channel","Surface Mount",2,2,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Behind Stage","Compact Fluorescent","Bowl Fitting","Surface Mount",1,1,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Block F - Hall","Under Stage","Compact Fluorescent","Bowl Fitting","Surface Mount",1,6,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Metal Halide","Floodlight","Wall Mount",1,17,null,400,{"$f":"SUM(I158*L158)","v":400},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Mercury Vapour","Floodlight","Wall Mount",1,6,null,125,{"$f":"SUM(I159*L159)","v":125},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Floodlight","Wall Mount",1,2,null,85,85,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Halogen","Floodlight","Wall Mount",1,9,null,500,{"$f":"SUM(I161*L161)","v":500},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Bulkhead","Wall Mount",1,27,null,26,26,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Bulkhead","Wall Mount",2,21,null,26,{"$f":"SUM(I163*L163)","v":52},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Compact Fluorescent","Bowl Fitting","Wall Mount",1,2,null,26,{"$f":"SUM(I164*L164)","v":26},null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Tubular Fluorescent","Open Channel","Surface Mount",1,1,null,36,36,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Tubular Fluorescent","Open Channel","Surface Mount",2,4,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","Garage","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,36,72,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","Garage","Tubular Fluorescent","Open Channel","Surface Mount",2,1,null,58,116,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","Tuckshop","Tubular Fluorescent","Open Channel","Surface Mount",1,3,null,40,40,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Metal Halide","Floodlight","Wall Mount",1,16,null,400,400,null,6]
["Sibonile School for the Blind","Garthdale AH",null,"Outside","All","Metal Halide","Floodlight","Wall Mount",1,16,null,400,400,null,6]

{"sheet":"Study Data","index":6,"n_rows":47,"n_cols":29,"rows_kept":47,"merged":[[0,1,0,19],[0,21,0,27],[3,3,3,8],[4,3,4,9],[5,1,6,1],[5,21,5,27],[8,21,8,27],[33,1,34,1]]}
[null,"Audit Report Sheet for Sibonile School for the Blind",{"$nulls":19},"Audit Report Sheet for Sibonile School for the Blind"]
[]
[]
[null,"Survey information","Date:","Site:"]
[null,null,"2021-09-26","Sibonile School for the Blind",{"$nulls":24},1.07]
[null,"Current Installation",{"$nulls":19},"QUOTATION"]
[]
[null,null,"Light Type","Qty","#Lamps","Lamp W","Loss Fact.","Indiv. Load","Total Load","Ops. Hrs.","kWh per month","kWh per Annum","Lamp Lifespan","Avg. Group Re-lamp in years","Cost of Lamp*","Cost of Ballast","Labour cost of Re-lamp*","Combined maintenance cost","Annual Maintenance Factor","Annual Maintenance Costs",null,"Luminaire Description ","Qty","Fixture Unit Price","Fixture Unit Price Total","Installation Unit Price","Installation Unit Price Total","Total"]
[{"$nulls":21},{"$f":"B9","v":0}]
[null,null,"Bulkhead / Bowl Fitting (1 Lamp)",70,1,26,{"v":1.1,"d":"1.10"},{"$f":"G10*F10*E10","v":28.6},{"$f":"H10*D10","v":{"v":2002,"d":"2,002"}},6,{"$f":"(I10*J10)/1000*30.5","v":{"v":366.366,"d":"366.37"}},{"$f":"(I10*J10)/1000*365","v":{"v":4384.38,"d":"4,384.38"}},{"v":10000,"d":"10,000.00"},{"$f":"M10/(J10*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":55,"d":"R 55.00"},0,{"v":50,"d":"R 50.00"},{"$f":"(O10*E10)+(P10/5)+Q10","v":{"v":105,"d":"R 105.00"}},{"$f":"1/N10","v":{"v":0.27375,"d":"27.38%"}},{"$f":"D10*R10*S10","v":{"v":2012.0625,"d":"R 2,012"}},null,"Titan Bulkhead 21W",{"$f":"D10","v":70},{"$f":"740*AC$5","v":{"v":791.8000000000001,"d":"R791.80"}},{"$f":"X10*W10","v":{"v":55426.00000000001,"d":"R55,426.00"}},null,{"$f":"SUM(W10*Z10)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y10,AA10)","v":{"v":55426.00000000001,"d":"R55,426.00"}}]
[null,null,"Bulkhead / Bowl Fitting (2 Lamp)",39,2,26,{"v":1.1,"d":"1.10"},{"$f":"G11*F11*E11","v":57.2},{"v":2230.8,"d":"2,231"},6,{"$f":"(I11*J11)/1000*30.5","v":{"v":408.2364,"d":"408.24"}},{"$f":"(I11*J11)/1000*365","v":{"v":4885.452,"d":"4,885.45"}},{"v":10000,"d":"10,000.00"},{"$f":"M11/(J11*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":55,"d":"R 55.00"},0,{"v":50,"d":"R 50.00"},{"$f":"(O11*E11)+(P11/5)+Q11","v":{"v":160,"d":"R 160.00"}},{"$f":"1/N11","v":{"v":0.27375,"d":"27.38%"}},{"v":1708.2,"d":"R 1,708"},null,"Titan Bulkhead 21W",39,{"$f":"740*AC$5","v":{"v":791.8000000000001,"d":"R791.80"}},{"$f":"X11*W11","v":{"v":30880.200000000004,"d":"R30,880.20"}},null,{"$f":"SUM(W11*Z11)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y11,AA11)","v":{"v":30880.200000000004,"d":"R30,880.20"}}]
[null,null,"Downlight CFL",14,2,18,{"v":1.1,"d":"1.10"},{"$f":"G12*F12*E12","v":39.6},{"v":554.4,"d":"554"},6,{"$f":"(I12*J12)/1000*30.5","v":{"v":101.45519999999999,"d":"101.46"}},{"$f":"(I12*J12)/1000*365","v":{"v":1214.1359999999997,"d":"1,214.14"}},{"v":10000,"d":"10,000.00"},{"$f":"M12/(J12*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":55,"d":"R 55.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"$f":"(O12*E12)+(P12/5)+Q12","v":{"v":205.8,"d":"R 205.80"}},{"$f":"1/N12","v":{"v":0.27375,"d":"27.38%"}},{"v":788.7285,"d":"R 789"},null,"DLV-R 6\" 17W",14,{"$f":"930*AC$5","v":{"v":995.1,"d":"R995.10"}},{"$f":"X12*W12","v":{"v":13931.4,"d":"R13,931.40"}},null,{"$f":"SUM(W12*Z12)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y12,AA12)","v":{"v":13931.4,"d":"R13,931.40"}}]
[null,null,"Lamps",36,1,20,{"v":1.1,"d":"1.10"},{"$f":"G13*F13*E13","v":22},792,6,{"$f":"(I13*J13)/1000*30.5","v":{"v":144.936,"d":"144.94"}},{"$f":"(I13*J13)/1000*365","v":{"v":1734.48,"d":"1,734.48"}},{"v":10000,"d":"10,000.00"},{"$f":"M13/(J13*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":85,"d":"R 85.00"},0,{"v":50,"d":"R 50.00"},{"$f":"(O13*E13)+(P13/5)+Q13","v":{"v":135,"d":"R 135.00"}},{"$f":"1/N13","v":{"v":0.27375,"d":"27.38%"}},{"v":1330.425,"d":"R 1,330"},null,"LED Lamp 10W",36,{"$f":"150*AC$5","v":{"v":160.5,"d":"R160.50"}},{"v":5778,"d":"R5,778.00"},null,{"v":0,"d":"R0.00"},{"v":5778,"d":"R5,778.00"}]
[null,null,"Downlight Halogen",34,1,50,{"v":1.1,"d":"1.10"},55.00000000000001,{"v":1870.0000000000002,"d":"1,870"},6,{"v":342.2100000000001,"d":"342.21"},{"v":4095.300000000001,"d":"4,095.30"},{"v":10000,"d":"10,000.00"},{"v":3.6529680365296806,"d":"3.65"},{"v":55,"d":"R 55.00"},{"v":200,"d":"R 200.00"},{"v":50,"d":"R 50.00"},{"v":145,"d":"R 145.00"},{"v":0.27375,"d":"27.38%"},{"v":1349.5874999999999,"d":"R 1,350"},null,"DLV GU10 6W Splash",34,{"$f":"300*AC$5","v":{"v":321,"d":"R321.00"}},{"$f":"X14*W14","v":{"v":10914,"d":"R10,914.00"}},null,{"$f":"SUM(W14*Z14)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y14,AA14)","v":{"v":10914,"d":"R10,914.00"}}]
[null,null,"Downlight Reflector Lamps",6,1,250,{"v":1.1,"d":"1.10"},{"$f":"G15*F15*E15","v":275},{"v":1650,"d":"1,650"},6,{"$f":"(I15*J15)/1000*30.5","v":301.95},{"$f":"(I15*J15)/1000*365","v":{"v":3613.5,"d":"3,613.50"}},{"v":10000,"d":"10,000.00"},{"$f":"M15/(J15*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":500,"d":"R 500.00"},0,{"v":450,"d":"R 450.00"},{"$f":"(O15*E15)+(P15/5)+Q15","v":{"v":950,"d":"R 950.00"}},{"$f":"1/N15","v":{"v":0.27375,"d":"27.38%"}},{"v":1560.375,"d":"R 1,560"},null,"DLV-R 8\" 49W",6,{"$f":"1100*AC$5","v":{"v":1177,"d":"R1,177.00"}},{"$f":"X15*W15","v":{"v":7062,"d":"R7,062.00"}},null,{"$f":"SUM(W15*Z15)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y15,AA15)","v":{"v":7062,"d":"R7,062.00"}}]
[null,null,"Open Channel / Deco",41,1,36,{"v":1.1,"d":"1.10"},39.6,{"v":1623.6000000000001,"d":"1,624"},6,{"v":297.1188,"d":"297.12"},{"v":3555.684,"d":"3,555.68"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":135.8,"d":"R 135.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":1016.1234999999998,"d":"R 1,016"},null,"E-Batten 32W / Marea",41,{"$f":"950*AC$5","v":{"v":1016.5000000000001,"d":"R1,016.50"}},{"v":41676.50000000001,"d":"R41,676.50"},null,{"v":0,"d":"R0.00"},{"v":41676.50000000001,"d":"R41,676.50"}]
[null,null,"Open Channel / Deco",5,1,58,{"v":1.1,"d":"1.10"},{"$f":"G17*F17*E17","v":63.800000000000004},319,6,{"$f":"(I17*J17)/1000*30.5","v":{"v":58.376999999999995,"d":"58.38"}},{"$f":"(I17*J17)/1000*365","v":698.61},{"v":15000,"d":"15,000.00"},{"$f":"M17/(J17*365)*0.8","v":{"v":5.479452054794521,"d":"5.48"}},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"$f":"(O17*E17)+(P17/5)+Q17","v":{"v":135.8,"d":"R 135.80"}},{"$f":"1/N17","v":{"v":0.18249999999999997,"d":"18.25%"}},{"v":123.91749999999998,"d":"R 124"},null,"E-Batten 32W / Marea",5,{"v":1016.5000000000001,"d":"R1,016.50"},{"$f":"X17*W17","v":{"v":5082.500000000001,"d":"R5,082.50"}},null,{"$f":"SUM(W17*Z17)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y17,AA17)","v":{"v":5082.500000000001,"d":"R5,082.50"}}]
[null,null,"Open Channel / Deco",15,1,80,{"v":1.1,"d":"1.10"},{"$f":"G18*F18*E18","v":88},{"v":1320,"d":"1,320"},6,{"$f":"(I18*J18)/1000*30.5","v":241.56},{"$f":"(I18*J18)/1000*365","v":{"v":2890.8,"d":"2,890.80"}},{"v":15000,"d":"15,000.00"},{"$f":"M18/(J18*365)*0.8","v":{"v":5.479452054794521,"d":"5.48"}},{"v":300,"d":"R 300.00"},{"v":800,"d":"R 800.00"},{"v":50,"d":"R 50.00"},{"$f":"(O18*E18)+(P18/5)+Q18","v":{"v":510,"d":"R 510.00"}},{"$f":"1/N18","v":{"v":0.18249999999999997,"d":"18.25%"}},{"v":1396.1249999999998,"d":"R 1,396"},null,"E-Batten 32W / Marea",15,{"v":1016.5000000000001,"d":"R1,016.50"},{"$f":"X18*W18","v":{"v":15247.500000000002,"d":"R15,247.50"}},null,{"$f":"SUM(W18*Z18)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y18,AA18)","v":{"v":15247.500000000002,"d":"R15,247.50"}}]
[null,null,"Open Channel / Deco",266,2,36,{"v":1.1,"d":"1.10"},79.2,{"v":21067.2,"d":"21,067"},6,{"v":3855.2976000000003,"d":"3,855.30"},{"v":46137.168000000005,"d":"46,137.17"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":175.8,"d":"R 175.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":8534.211,"d":"R 8,534"},null,"E-Batten 32W / Marea",266,{"v":1016.5000000000001,"d":"R1,016.50"},{"v":270389.00000000006,"d":"R270,389.00"},null,{"v":0,"d":"R0.00"},{"v":270389.00000000006,"d":"R270,389.00"}]
[null,null,"Open Channel / Deco",14,2,58,{"v":1.1,"d":"1.10"},127.60000000000001,{"v":1786.4,"d":"1,786"},6,{"v":326.9112,"d":"326.91"},{"v":3912.2160000000003,"d":"3,912.22"},{"v":15000,"d":"15,000.00"},{"v":5.479452054794521,"d":"5.48"},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"v":175.8,"d":"R 175.80"},{"v":0.18249999999999997,"d":"18.25%"},{"v":449.169,"d":"R 449"},null,"E-Batten 32W / Marea",14,{"v":1016.5000000000001,"d":"R1,016.50"},{"v":14231.000000000002,"d":"R14,231.00"},null,{"v":0,"d":"R0.00"},{"v":14231.000000000002,"d":"R14,231.00"}]
[null,null,"Open Channel / Deco",5,2,80,{"v":1.1,"d":"1.10"},{"$f":"G21*F21*E21","v":176},880,6,{"$f":"(I21*J21)/1000*30.5","v":{"v":161.04000000000002,"d":"161.04"}},{"$f":"(I21*J21)/1000*365","v":{"v":1927.2,"d":"1,927.20"}},{"v":15000,"d":"15,000.00"},{"$f":"M21/(J21*365)*0.8","v":{"v":5.479452054794521,"d":"5.48"}},{"v":300,"d":"R 300.00"},{"v":800,"d":"R 800.00"},{"v":50,"d":"R 50.00"},{"$f":"(O21*E21)+(P21/5)+Q21","v":{"v":810,"d":"R 810.00"}},{"$f":"1/N21","v":{"v":0.18249999999999997,"d":"18.25%"}},{"v":739.1249999999999,"d":"R 739"},null,"E-Batten 32W / Marea",5,{"v":1016.5000000000001,"d":"R1,016.50"},{"$f":"X21*W21","v":{"v":5082.500000000001,"d":"R5,082.50"}},null,{"$f":"SUM(W21*Z21)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y21,AA21)","v":{"v":5082.500000000001,"d":"R5,082.50"}}]
[null,null,"Surface LBR Fitting",7,2,58,{"v":1.1,"d":"1.10"},{"$f":"G22*F22*E22","v":127.60000000000001},{"v":893.2,"d":"893"},6,{"$f":"(I22*J22)/1000*30.5","v":{"v":163.4556,"d":"163.46"}},{"$f":"(I22*J22)/1000*365","v":{"v":1956.1080000000002,"d":"1,956.11"}},{"v":15000,"d":"15,000.00"},{"$f":"M22/(J22*365)*0.8","v":{"v":5.479452054794521,"d":"5.48"}},{"v":40,"d":"R 40.00"},{"v":229,"d":"R 229.00"},{"v":50,"d":"R 50.00"},{"$f":"(O22*E22)+(P22/5)+Q22","v":{"v":175.8,"d":"R 175.80"}},{"$f":"1/N22","v":{"v":0.18249999999999997,"d":"18.25%"}},{"v":224.5845,"d":"R 225"},null,"EOS 600x600 LED Panel",7,{"$f":"800*AC$5","v":{"v":856,"d":"R856.00"}},{"v":5992,"d":"R5,992.00"},null,{"v":0,"d":"R0.00"},{"v":5992,"d":"R5,992.00"}]
[null,null,"Open Channel / Deco LED 1 Lamp",1,1,20,{"v":1.1,"d":"1.10"},22,22,6,{"v":4.026,"d":"4.03"},48.18,{"v":8000,"d":"8,000.00"},{"v":2.922374429223744,"d":"2.92"},{"v":100,"d":"R 100.00"},null,{"v":50,"d":"R 50.00"},{"v":150,"d":"R 150.00"},{"v":0.34218750000000003,"d":"34.22%"},{"v":51.32812500000001,"d":"R 51"},null,"E-Batten 32W / Marea",1,{"$f":"950*AC$5","v":{"v":1016.5000000000001,"d":"R1,016.50"}},{"v":1016.5000000000001,"d":"R1,016.50"},null,{"v":0,"d":"R0.00"},{"v":1016.5000000000001,"d":"R1,016.50"}]
[null,null,"Open Channel / Deco LED 2 Lamp",5,2,20,{"v":1.1,"d":"1.10"},{"$f":"G24*F24*E24","v":44},220,6,{"$f":"(I24*J24)/1000*30.5","v":{"v":40.260000000000005,"d":"40.26"}},{"$f":"(I24*J24)/1000*365","v":{"v":481.8,"d":"481.80"}},{"v":8000,"d":"8,000.00"},{"$f":"M24/(J24*365)*0.8","v":{"v":2.922374429223744,"d":"2.92"}},{"v":100,"d":"R 100.00"},null,{"v":50,"d":"R 50.00"},{"$f":"(O24*E24)+(P24/5)+Q24","v":{"v":250,"d":"R 250.00"}},{"$f":"1/N24","v":{"v":0.34218750000000003,"d":"34.22%"}},{"v":427.73437500000006,"d":"R 428"},null,"E-Batten 32W / Marea",5,{"$f":"950*AC$5","v":{"v":1016.5000000000001,"d":"R1,016.50"}},{"$f":"X24*W24","v":{"v":5082.500000000001,"d":"R5,082.50"}},null,{"$f":"SUM(W24*Z24)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y24,AA24)","v":{"v":5082.500000000001,"d":"R5,082.50"}}]
[null,null,"High Bay Incandescent",12,1,500,{"v":1.1,"d":"1.10"},{"$f":"G25*F25*E25","v":550},{"v":6600,"d":"6,600"},6,{"$f":"(I25*J25)/1000*30.5","v":{"v":1207.8,"d":"1,207.80"}},{"$f":"(I25*J25)/1000*365","v":{"v":14454,"d":"14,454.00"}},{"v":8000,"d":"8,000.00"},{"$f":"M25/(J25*365)*0.8","v":{"v":2.922374429223744,"d":"2.92"}},{"v":500,"d":"R 500.00"},null,{"v":450,"d":"R 450.00"},{"$f":"(O25*E25)+(P25/5)+Q25","v":{"v":950,"d":"R 950.00"}},{"$f":"1/N25","v":{"v":0.34218750000000003,"d":"34.22%"}},{"v":3900.9375000000005,"d":"R 3,901"},null,"O-Bay 200W",12,{"$f":"1750*AC$5","v":{"v":1872.5,"d":"R1,872.50"}},{"$f":"X25*W25","v":{"v":22470,"d":"R22,470.00"}},null,{"$f":"SUM(W25*Z25)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y25,AA25)","v":{"v":22470,"d":"R22,470.00"}}]
[null,null,"Floodlight CFL",2,1,85,{"v":1.1,"d":"1.10"},{"$f":"G26*F26*E26","v":93.50000000000001},{"v":187.00000000000003,"d":"187"},6,{"$f":"(I26*J26)/1000*30.5","v":{"v":34.22100000000001,"d":"34.22"}},{"$f":"(I26*J26)/1000*365","v":{"v":409.53000000000014,"d":"409.53"}},{"v":10000,"d":"10,000.00"},{"$f":"M26/(J26*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":300,"d":"R 300.00"},{"v":600,"d":"R 600.00"},{"v":150,"d":"R 150.00"},{"$f":"(O26*E26)+(P26/5)+Q26","v":{"v":570,"d":"R 570.00"}},{"$f":"1/N26","v":{"v":0.27375,"d":"27.38%"}},{"v":312.075,"d":"R 312"},null,"Larvik 100W Floodlight",2,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"$f":"X26*W26","v":{"v":5457,"d":"R5,457.00"}},null,{"$f":"SUM(W26*Z26)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y26,AA26)","v":{"v":5457,"d":"R5,457.00"}}]
[null,null,"Floodlight Mercury Vapour",6,1,125,{"v":1.1,"d":"1.10"},{"$f":"G27*F27*E27","v":137.5},825,6,{"$f":"(I27*J27)/1000*30.5","v":{"v":150.975,"d":"150.98"}},{"$f":"(I27*J27)/1000*365","v":{"v":1806.75,"d":"1,806.75"}},{"v":10000,"d":"10,000.00"},{"$f":"M27/(J27*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":300,"d":"R 300.00"},{"v":600,"d":"R 600.00"},{"v":150,"d":"R 150.00"},{"$f":"(O27*E27)+(P27/5)+Q27","v":{"v":570,"d":"R 570.00"}},{"$f":"1/N27","v":{"v":0.27375,"d":"27.38%"}},{"v":936.225,"d":"R 936"},null,"Larvik 100W Floodlight",6,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"$f":"X27*W27","v":{"v":16371,"d":"R16,371.00"}},null,{"$f":"SUM(W27*Z27)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y27,AA27)","v":{"v":16371,"d":"R16,371.00"}}]
[null,null,"Floodlight Metal Halide",49,1,125,{"v":1.1,"d":"1.10"},{"$f":"G28*F28*E28","v":137.5},{"v":6737.5,"d":"6,738"},6,{"$f":"(I28*J28)/1000*30.5","v":{"v":1232.9624999999999,"d":"1,232.96"}},{"$f":"(I28*J28)/1000*365","v":{"v":14755.124999999998,"d":"14,755.13"}},{"v":10000,"d":"10,000.00"},{"$f":"M28/(J28*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":600,"d":"R 600.00"},{"v":1300,"d":"R 1,300.00"},{"v":150,"d":"R 150.00"},{"$f":"(O28*E28)+(P28/5)+Q28","v":{"v":1010,"d":"R 1,010.00"}},{"$f":"1/N28","v":{"v":0.27375,"d":"27.38%"}},{"v":13547.887499999999,"d":"R 13,548"},null,"Larvik 100W Floodlight",49,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"$f":"X28*W28","v":{"v":133696.5,"d":"R133,696.50"}},null,{"$f":"SUM(W28*Z28)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y28,AA28)","v":{"v":133696.5,"d":"R133,696.50"}}]
[null,null,"Floodlight Halogen",9,1,500,{"v":1.1,"d":"1.10"},{"$f":"G29*F29*E29","v":550},{"v":4950,"d":"4,950"},6,{"$f":"(I29*J29)/1000*30.5","v":905.85},{"$f":"(I29*J29)/1000*365","v":{"v":10840.5,"d":"10,840.50"}},{"v":10000,"d":"10,000.00"},{"$f":"M29/(J29*365)*0.8","v":{"v":3.6529680365296806,"d":"3.65"}},{"v":300,"d":"R 300.00"},0,{"v":150,"d":"R 150.00"},{"$f":"(O29*E29)+(P29/5)+Q29","v":{"v":450,"d":"R 450.00"}},{"$f":"1/N29","v":{"v":0.27375,"d":"27.38%"}},{"v":1108.6875,"d":"R 1,109"},null,"Larvik 100W Floodlight",9,{"$f":"2550*AC$5","v":{"v":2728.5,"d":"R2,728.50"}},{"$f":"X29*W29","v":{"v":24556.5,"d":"R24,556.50"}},null,{"$f":"SUM(W29*Z29)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y29,AA29)","v":{"v":24556.5,"d":"R24,556.50"}}]
[null,"Grand Total Fixtures",null,{"$f":"SUM(D9:D29)","v":636},{"$nulls":4},{"$f":"SUM(I10:I29)","v":{"v":56530.1,"d":"56,530"}},null,null,{"$f":"SUM(L10:L29)","v":{"v":123800.91900000001,"d":"123,801"}},{"$nulls":7},{"$f":"SUM(T10:T29)","v":{"v":41517.509,"d":"R 41,518"}},null,"Contingency for Extra Lighting in certain areas",64,{"$f":"1200*AC$5","v":{"v":1284,"d":"R1,284.00"}},{"$f":"X30*W30","v":{"v":82176,"d":"R82,176.00"}},null,{"$f":"SUM(W30*Z30)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(Y30,AA30)","v":{"v":82176,"d":"R82,176.00"}}]
[{"$nulls":21},"Contingency for Emergency Fittings",64,{"$f":"1200*AC$5","v":{"v":1284,"d":"R1,284.00"}},{"v":82176,"d":"R82,176.00"},null,{"v":0,"d":"R0.00"},{"v":82176,"d":"R82,176.00"}]
[{"$nulls":24},{"$f":"SUM(Y10:Y31)","v":{"v":854694.6000000001,"d":"R854,694.60"}},null,{"$f":"SUM(AA10:AA31)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":19},{"$f":"T30/D30","v":{"v":65.27910220125786,"d":"65.28"}},null,null," ",null,"Sub Total",null,"Sub Total",{"$f":"SUM(AB10:AB31)","v":{"v":854694.6000000001,"d":"R854,694.60"}}]
[null,"Energy Efficient Installation "]
[{"$nulls":24},"Total Excluding Vat",null,"Total Excluding VAT",{"$f":"SUM(AB33)","v":{"v":854694.6000000001,"d":"R854,694.60"}}]
[null,null,"Light Type","Qty","#Lamps","Lamp W","Loss Fact.","Indiv. Load","Total Load","Op. Hours ","kWh per month","kWh per Annum","Expected Lifespan to L80","Avg. Re-lamp in years","Cost of Lamp",null,"Labour cost of Re-lamp","Combined maintenance cost","Annual Maintenance Factor","Annual Maintenance Costs",{"$nulls":4},"Vat",null,"VAT 15%",{"$f":"AB35*15%","v":{"v":128204.19,"d":"R128,204.19"}}]
[null,null,"Titan Bulkhead 21W",109,1,136,{"v":1.1,"d":"1.10"},{"$f":"G37*F37*E37","v":149.60000000000002},{"$f":"H37*D37","v":16306.400000000003},6,{"$f":"(I37*J37)/1000*30.5","v":{"v":2984.0712000000008,"d":"2,984.07"}},{"$f":"(I37*J37)/1000*365","v":{"v":35711.01600000001,"d":"35,711.02"}},{"v":50000,"d":"50,000.00"},{"$f":"M37/(J37*365)*0.8","v":{"v":18.264840182648403,"d":"18.26"}},0,0,0,{"$f":"(O37*E37)+(P37/5)+Q37","v":0},{"$f":"1/N37","v":{"v":0.05475,"d":"5.48%"}},{"$f":"D37*R37*S37","v":0},{"$nulls":4},"Total Including Vat",null,"Total Including VAT",{"$f":"AB36+AB35","v":{"v":982898.79,"d":"R982,898.79"}}]
[null,null,"DLV-R 6\"17W",14,1,6,{"v":1.1,"d":"1.10"},{"$f":"G38*F38*E38","v":6.6000000000000005},92.4,6,{"$f":"(I38*J38)/1000*30.5","v":{"v":16.909200000000002,"d":"16.91"}},{"$f":"(I38*J38)/1000*365","v":{"v":202.35600000000005,"d":"202.36"}},{"v":50000,"d":"50,000.00"},{"$f":"M38/(J38*365)*0.8","v":{"v":18.264840182648403,"d":"18.26"}},0,0,0,{"$f":"(O38*E38)+(P38/5)+Q38","v":0},{"$f":"1/N38","v":{"v":0.05475,"d":"5.48%"}},0]
[null,null,"LED Lamp 10W",36,1,16,{"v":1.1,"d":"1.10"},{"$f":"G39*F39*E39","v":17.6},633.6,6,{"v":115.94880000000002,"d":"115.95"},{"v":1387.5840000000003,"d":"1,387.58"},{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"DLV GU10 6W Splash",34,1,32,{"v":1.1,"d":"1.10"},{"$f":"G40*F40*E40","v":35.2},1196.8000000000002,6,{"v":219.01440000000005,"d":"219.01"},{"v":2620.9920000000006,"d":"2,620.99"},{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"DLV-R 8\" 49W",6,1,30,{"v":1.1,"d":"1.10"},33,198,6,{"v":36.234,"d":"36.23"},433.62,{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"E-Batten 32W / Marea",352,1,42,{"v":1.1,"d":"1.10"},46.2,16262.400000000001,6,{"$f":"(I42*J42)/1000*30.5","v":{"v":2976.0192,"d":"2,976.02"}},{"$f":"(I42*J42)/1000*365","v":{"v":35614.656,"d":"35,614.66"}},{"v":50000,"d":"50,000.00"},{"$f":"M42/(J42*365)*0.8","v":{"v":18.264840182648403,"d":"18.26"}},0,0,0,{"$f":"(O42*E42)+(P42/5)+Q42","v":0},{"$f":"1/N42","v":{"v":0.05475,"d":"5.48%"}},0]
[null,null,"EOS 600x600 LED Panel",7,1,10,{"v":1.1,"d":"1.10"},11,77,6,{"v":14.091000000000001,"d":"14.09"},168.63,{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,0,{"v":0.05475,"d":"5.48%"},0]
[null,null,"O-Bay 200W",12,1,100,{"v":1.1,"d":"1.10"},{"$f":"G44*F44*E44","v":110.00000000000001},1320.0000000000002,6,{"$f":"(I44*J44)/1000*30.5","v":{"v":241.56000000000006,"d":"241.56"}},{"$f":"(I44*J44)/1000*365","v":{"v":2890.8000000000006,"d":"2,890.80"}},{"v":50000,"d":"50,000.00"},{"$f":"M44/(J44*365)*0.8","v":{"v":18.264840182648403,"d":"18.26"}},0,0,0,{"$f":"(O44*E44)+(P44/5)+Q44","v":0},{"$f":"1/N44","v":{"v":0.05475,"d":"5.48%"}},0]
[null,null,"Larvik 100W Floodlight",66,{"$nulls":4},0,6,0,0,{"v":50000,"d":"50,000.00"},{"v":18.264840182648403,"d":"18.26"},0,0,0,{"$f":"(O45*E45)+(P45/5)+Q45","v":0},{"v":0.05475,"d":"5.48%"},0]
[{"$nulls":3},636,{"$nulls":4},{"$f":"SUM(I37:I45)","v":36086.600000000006},null,null,{"$f":"SUM(L37:L45)","v":{"v":79029.65400000002,"d":"79,029.65"}}]
[null,"Totals",null," ",{"$nulls":4}," ",null,null," "]

{"sheet":"SloanLED Breakdown","index":7,"n_rows":26,"n_cols":31,"rows_kept":26,"hidden":true,"merged":[[0,23,0,24],[1,26,2,26]]}
[{"$nulls":23},"Price Source",null,null," "]
[{"$nulls":23},"Cool L","Hans",null,"Sell Price","Sell"]
[{"$nulls":21},"Product Description","Qty","USD$","USD$","Total $",null,"Total"]
[{"$nulls":3},"21W Medium Lentgh & thin",8,1,21,{"v":1.1,"d":"1.10"},23.1,{"v":184.8,"d":"185"},24,{"v":135.27360000000002,"d":"135"},{"v":1618.8480000000004,"d":"1619"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":372.3,"d":"R 372"},"Large Branded Circular LED Retrofit",9,"Unknown",null,{"$f":"Y4*W4","v":0},{"v":7500,"d":"7500.00"},{"v":67500,"d":"67500.00"},{"v":388.5,"d":"388.50"},{"v":3496.5,"d":"3496.50"},{"v":70996.5,"d":"70996.50"}]
[null,null,"Room 1","Fluorescent 36W 1.2",1,4,36,{"v":1.1,"d":"1.10"},158.4,{"v":158.4,"d":"158"},24,{"v":115.94880000000002,"d":"116"},{"v":1387.5840000000003,"d":"1388"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":235,"d":"R 235.00"},{"v":0.5475,"d":"54.75%"},{"v":128.6625,"d":"R 129"},"SloanLED Vista 600 x 1200 50W 4000K",1,null,{"v":45,"d":"$45.00"},{"$f":"Y5*W5","v":{"v":45,"d":"$45.00"}},{"v":1215,"d":"R 1,215.00"},{"v":1062.5,"d":"R 1,062.50"},{"v":233.1,"d":"233.10"},{"v":233.1,"d":"233.10"},{"v":1295.6,"d":"1295.60"}]
[null,null,"Room 2","Fluorescent 36W 1.2",8,4,36,{"v":1.1,"d":"1.10"},158.4,{"v":1267.2,"d":"1267"},24,{"v":927.5904000000002,"d":"928"},{"v":11100.672000000002,"d":"11101"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":235,"d":"R 235.00"},{"v":0.5475,"d":"54.75%"},{"v":1029.3,"d":"R 1,029"},"SloanLED Vista 600 x 1200 50W 4000K",8,null,{"v":45,"d":"$45.00"},{"v":360,"d":"$360.00"},{"v":1215,"d":"R 1,215.00"},{"v":8500,"d":"R 8,500.00"},{"v":233.1,"d":"233.10"},{"v":1864.8,"d":"1864.80"},{"v":10364.8,"d":"10364.80"}]
[null,null,"Room 3","Fluorescent 36W 1.2",3,4,36,{"v":1.1,"d":"1.10"},158.4,{"v":475.20000000000005,"d":"475"},24,{"v":347.8464000000001,"d":"348"},{"v":4162.752,"d":"4163"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":235,"d":"R 235.00"},{"v":0.5475,"d":"54.75%"},{"v":385.9875,"d":"R 386"},"SloanLED Vista 600 x 1200 50W 4000K",3,null,{"v":45,"d":"$45.00"},{"v":135,"d":"$135.00"},{"v":1215,"d":"R 1,215.00"},{"v":3187.5,"d":"R 3,187.50"},{"v":233.1,"d":"233.10"},{"v":699.3,"d":"699.30"},{"v":3886.8,"d":"3886.80"}]
[null,null,"Room 4","Fluorescent 36W 1.2",4,4,36,{"v":1.1,"d":"1.10"},158.4,{"v":633.6,"d":"634"},24,{"v":463.7952000000001,"d":"464"},{"v":5550.336000000001,"d":"5550"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":235,"d":"R 235.00"},{"v":0.5475,"d":"54.75%"},{"v":514.65,"d":"R 515"},"SloanLED Vista 600 x 1200 50W 4000K",4,null,{"v":45,"d":"$45.00"},{"v":180,"d":"$180.00"},{"v":1215,"d":"R 1,215.00"},{"v":4250,"d":"R 4,250.00"},{"v":233.1,"d":"233.10"},{"v":932.4,"d":"932.40"},{"v":5182.4,"d":"5182.40"}]
[null,null,"Control Room","Fluorescent 36W 1.2",4,4,36,{"v":1.1,"d":"1.10"},158.4,{"v":633.6,"d":"634"},24,{"v":463.7952000000001,"d":"464"},{"v":5550.336000000001,"d":"5550"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":235,"d":"R 235.00"},{"v":0.5475,"d":"54.75%"},{"v":514.65,"d":"R 515"},"SloanLED Vista 600 x 1200 50W 4000K",4,null,{"v":45,"d":"$45.00"},{"v":180,"d":"$180.00"},{"v":1215,"d":"R 1,215.00"},{"v":4860,"d":"R 4,860.00"},{"v":233.1,"d":"233.10"},{"v":932.4,"d":"932.40"},{"v":5792.4,"d":"5792.40"}]
[null,"Open Parking Entrance 1","Round Head","Globe 125W (screw)",10,1,125,{"v":1.1,"d":"1.10"},137.5,1375,24,{"v":1006.5,"d":"1007"},12045,20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":465.375,"d":"R 465"},"SloanLED Optimus 100W",25,null,{"v":117.93,"d":"$117.93"},{"v":2948.25,"d":"$2,948.25"},{"v":2985,"d":"R 2,985.00"},{"v":29850,"d":"R 29,850.00"},352.98,{"v":3529.8,"d":"3529.80"},{"v":33379.8,"d":"33379.80"}]
[null,null,"TANGA","Floodlights",2,1,400,{"v":1.1,"d":"1.10"},440.00000000000006,{"v":880.0000000000001,"d":"880"},24,{"v":644.1600000000001,"d":"644"},{"v":7708.800000000002,"d":"7709"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":93.075,"d":"R 93"},"SloanLED Solarta Flood 70W",2,null,{"v":75,"d":"$75.00"},{"v":150,"d":"$150.00"},{"v":1900,"d":"R 1,900.00"},{"v":3800,"d":"R 3,800.00"},352.98,705.96,4505.96]
[null,"Perimeter Lights","Round Head","Globe 125W (screw)",39,1,125,{"v":1.1,"d":"1.10"},137.5,{"v":5362.5,"d":"5363"},24,{"v":3925.3499999999995,"d":"3925"},{"v":46975.49999999999,"d":"46976"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":1814.9624999999999,"d":"R 1,815"},"SloanLED Optimus 100W",39,null,{"v":117.93,"d":"$117.93"},{"v":4599.27,"d":"$4,599.27"},{"v":2985,"d":"R 2,985.00"},{"v":116415,"d":"R 116,415.00"},352.98,{"v":13766.220000000001,"d":"13766.22"},130181.22]
[null,"Open Parking Entrance 2","Round Head","Globe 125W (screw)",20,1,125,{"v":1.1,"d":"1.10"},137.5,2750,24,2013,24090,20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":930.75,"d":"R 931"},"SloanLED Optimus 100W",20,null,{"v":117.93,"d":"$117.93"},{"v":2358.6000000000004,"d":"$2,358.60"},{"v":2985,"d":"R 2,985.00"},{"v":59700,"d":"R 59,700.00"},352.98,{"v":7059.6,"d":"7059.60"},{"v":66759.6,"d":"66759.60"}]
[null,"Rooftop Parking","Round Head","Globe 125W (screw)",25,1,125,{"v":1.1,"d":"1.10"},137.5,{"v":3437.5,"d":"3438"},24,{"v":2516.25,"d":"2516"},{"v":30112.5,"d":"30113"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":1163.4375,"d":"R 1,163"},"SloanLED Optimus 100W",25,null,{"v":117.93,"d":"$117.93"},{"v":2948.25,"d":"$2,948.25"},{"v":2985,"d":"R 2,985.00"},{"v":74625,"d":"R 74,625.00"},352.98,{"v":8824.5,"d":"8824.50"},{"v":83449.5,"d":"83449.50"}]
[{"$nulls":3},"Floodlights",6,1,400,{"v":1.1,"d":"1.10"},440.00000000000006,{"v":2640.0000000000005,"d":"2640"},24,{"v":1932.4800000000005,"d":"1932"},{"v":23126.400000000005,"d":"23126"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":279.22499999999997,"d":"R 279"},"SloanLED Solarta Flood 70W",6,null,{"v":75,"d":"$75.00"},{"v":450,"d":"$450.00"},{"v":1900,"d":"R 1,900.00"},{"v":11400,"d":"R 11,400.00"},352.98,2117.88,{"v":13517.880000000001,"d":"13517.88"}]
[null,"Generator / Receiving Area","TANGA","Floodlight",1,1,400,{"v":1.1,"d":"1.10"},440.00000000000006,{"v":1320.0000000000002,"d":"1320"},24,{"v":966.2400000000002,"d":"966"},{"v":11563.200000000003,"d":"11563"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":135,"d":"R 135.00"},{"v":0.5475,"d":"54.75%"},{"v":221.73749999999998,"d":"R 222"},"SloanLED Solarta Flood 70W",1,null,{"v":75,"d":"$75.00"},{"v":75,"d":"$75.00"},{"v":1900,"d":"R 1,900.00"},{"v":1900,"d":"R 1,900.00"},352.98,352.98,2252.98]
[null,null,"TANGA","Floodlight (Big)",1,1,400,{"v":1.1,"d":"1.10"},440.00000000000006,{"v":440.00000000000006,"d":"440"},24,{"v":322.08000000000004,"d":"322"},{"v":3854.400000000001,"d":"3854"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":46.5375,"d":"R 47"},"SloanLED Solarta Flood 70W",1,null,{"v":75,"d":"$75.00"},{"v":75,"d":"$75.00"},{"v":1900,"d":"R 1,900.00"},{"v":2025,"d":"R 2,025.00"},352.98,352.98,2377.98]
[null,"Floodlights Various Areas",null,"Floodlights",15,1,400,{"v":1.1,"d":"1.10"},440.00000000000006,{"v":6600.000000000001,"d":"6600"},24,{"v":4831.200000000001,"d":"4831"},{"v":57816.000000000015,"d":"57816"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":698.0625,"d":"R 698"},"SloanLED Solarta Flood 70W",15,null,{"v":75,"d":"$75.00"},{"v":1125,"d":"$1,125.00"},{"v":1900,"d":"R 1,900.00"},{"v":28500,"d":"R 28,500.00"},352.98,{"v":5294.700000000001,"d":"5294.70"},{"v":33794.7,"d":"33794.70"}]
[{"$nulls":3},"Floodlights (Big) Assume 4 on 1 pole",4,1,400,{"v":1.1,"d":"1.10"},440.00000000000006,{"v":1760.0000000000002,"d":"1760"},24,{"v":1288.3200000000002,"d":"1288"},{"v":15417.600000000004,"d":"15418"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":186.15,"d":"R 186"},"SloanLED Optimus 150W",4,null,{"v":172,"d":"$172.00"},{"v":688,"d":"$688.00"},{"v":4350,"d":"R 4,350.00"},{"v":17400,"d":"R 17,400.00"},352.98,1411.92,18811.92]
[{"$nulls":3},"Fluorescent 58W 1.5",1,2,58,{"v":1.1,"d":"1.10"},127.60000000000001,{"v":127.60000000000001,"d":"128"},{"$nulls":5},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"$nulls":4},"SloanLED SurfLite1 45W 4000K",1,null,{"v":80,"d":"$80.00"},{"v":80,"d":"$80.00"},{"v":2160,"d":"R 2,160.00"},{"v":2160,"d":"R 2,160.00"},{"v":255.3,"d":"255.30"},{"v":255.3,"d":"255.30"},{"v":2415.3,"d":"2415.30"}]
[{"$nulls":3},"Globe 26W 4 Pin",8,2,26,{"v":1.1,"d":"1.10"},57.2,{"v":457.6,"d":"458"},24,{"v":334.9632000000001,"d":"335"},{"v":4008.576000000001,"d":"4009"},20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":135,"d":"R 135.00"},{"v":0.5475,"d":"54.75%"},{"v":591.3,"d":"R 591"},"SloanLED Detroit 45W Wall Pack",17,null,{"v":70,"d":"$70.00"},{"v":1190,"d":"$1,190.00"},{"v":1798.99,"d":"R 1,798.99"},{"v":14391.92,"d":"R 14,391.92"},138.75,{"v":1110,"d":"1110.00"},15501.92]
[{"$nulls":3},"Globe 125W Screw",4,1,125,{"v":1.1,"d":"1.10"},137.5,550,24,{"v":402.59999999999997,"d":"403"},4818,20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":186.15,"d":"R 186"},"SloanLED Optimus 100W",4,null,{"v":117.93,"d":"$117.93"},{"v":471.72,"d":"$471.72"},{"v":2985,"d":"R 2,985.00"},{"v":11940,"d":"R 11,940.00"},352.98,1411.92,13351.92]
[{"$nulls":3},"Globe 250W Screw",4,1,250,{"v":1.1,"d":"1.10"},275,1100,24,{"v":805.1999999999999,"d":"805"},9636,20000,{"v":1.8264840182648403,"d":"1.83"},{"v":50,"d":"R 50.00"},{"v":50,"d":"R 50.00"},{"v":25,"d":"R 25.00"},{"v":85,"d":"R 85.00"},{"v":0.5475,"d":"54.75%"},{"v":186.15,"d":"R 186"},"SloanLED Optimus 100W",4,null,{"v":117.93,"d":"$117.93"},{"v":471.72,"d":"$471.72"},{"v":2985,"d":"R 2,985.00"},{"v":11940,"d":"R 11,940.00"},352.98,1411.92,13351.92]
[{"$nulls":21},"SloanLED Twilight 40W4000K Black IP65",3,null,{"v":205,"d":"$205.00"},{"v":615,"d":"$615.00"},{"v":5535,"d":"R 5,535.00"},{"$f":"AA24*W24","v":{"v":16605,"d":"R 16,605.00"}}]
[{"$nulls":21},"Total Potential Order",{"$nulls":3},{"$f":"SUM(Z4:Z24)","v":{"v":19145.810000000005,"d":"$19,145.81"}},null,{"$f":"SUM(AB4:AB24)","v":{"v":492011.92,"d":"R 492,011.92"}}]
[{"$nulls":26},{"v":15,"d":"R 15.00"},{"v":1.35,"d":"R 1.35"}]

{"sheet":"Data Summary","index":8,"n_rows":17,"n_cols":8,"rows_kept":17,"hidden":true}
[]
[]
[]
[null,null,"Total Load","kWatts per day","kWatts per month","Daily Energy Cost","Monthly Energy Cost","P.A Ave. Maintenace"]
[null,"Old ",{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}}]
[null,"New",{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}}]
[null,"Demand saved",{"$f":"C5-C6","v":{"$error":"#REF!"}}]
[]
[null,"Power charge",{"v":1,"d":"R 1.00"},"average"]
[null,"Est Annual Maintenance Old ",{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}}]
[null,"Est Annual Maintenance New",{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}}]
[null,"Capital ",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"kWh/m","kWh/yr","Annual Energy Cost"]
[null,"Existing Consumption",{"$f":"30.5*C5*12/1000","v":{"$error":"#REF!"}},{"$f":"C5*(1-0%)*23*365/1000","v":{"$error":"#REF!"}},{"$f":"C9*D16","v":{"$error":"#REF!"}},{"$f":"E16/12","v":{"$error":"#REF!"}}]
[null,"Proposed Consumption",{"$f":"30.5*C6*12/1000","v":{"$error":"#REF!"}},{"$f":"C6*(1-68%)*23*365/1000","v":{"$error":"#REF!"}},{"$f":"D17*C9","v":{"$error":"#REF!"}},{"$f":"E17/12","v":{"$error":"#REF!"}}]

{"sheet":"Luca Breakdown","index":9,"n_rows":47,"n_cols":21,"rows_kept":47,"hidden":true,"merged":[[15,1,15,8]]}
[]
[]
[null,"Description","Qty",{"$nulls":5},"Unit Price ","Total Price"]
[null,"DLE-12-ST-N-750-High Bay 14650Lm 5000K",90,{"$nulls":5},{"v":11980,"d":"R 11,980.00"},{"$f":"C4*I4","v":{"v":1078200,"d":"1,078,200"}}]
[null,"DLE-12-ST-W-750-High Bay 14650Lm 5000K",16,{"$nulls":5},{"v":11980,"d":"R 11,980.00"},{"$f":"C5*I5","v":{"v":191680,"d":"191,680"}}]
[null,"DLE Fixed Mount Hanging Hardware for 5 Fixtures ",{"$f":"(C4+C5)/5+1","v":{"v":22.2,"d":"22"}},{"$nulls":5},{"v":392,"d":"R 392.00"},{"$f":"I6*C6","v":{"v":8702.4,"d":"8,702"}}]
[null,"DLE Wago Connector 3m",106,{"$nulls":5},{"v":392,"d":"392.00"},{"$f":"I7*C7","v":{"v":41552,"d":"41,552"}}]
[null,"Delivery to Site",1,{"$nulls":5},{"v":7500,"d":"7,500"},{"$f":"I8*C8","v":{"v":7500,"d":"7,500"}}]
[{"$nulls":8},"Total for Luminaires, ex VAT",{"$f":"SUM(J4:J8)","v":{"v":1327634.4,"d":"1,327,634"}}]
[null,"Project Management",{"$nulls":6},{"$f":"(J9+J16)*0.025","v":{"v":36638.034999999996,"d":"36,638"}},{"$f":"I10","v":{"v":36638.034999999996,"d":"36,638"}},null,null,"Total Fixtures"]
[null,"Light Rules","Qty",{"$nulls":5},"Unit  ","Total ",null,null,"DLE 12",{"$f":"C27+C28+C29+C30","v":133},null,null,"PM",{"$f":"(#REF!+#REF!+J38+#REF!+J39)*0.02","v":{"$error":"#REF!"}}]
[null,"DL Gateways",3,{"$nulls":5},{"v":15008,"d":"15,008"},{"$f":"I12*C12","v":{"v":45024,"d":"45,024"}},null,null,"DLE 18",{"$f":"C31","v":106}]
[null,"LightRules Installation & Commissioning",1,{"$nulls":5},{"v":37100,"d":"37,100"},{"$f":"I13*C13","v":{"v":37100,"d":"37,100"}},null,null,"Total",{"$f":"N11+N12","v":239}]
[null,"PoE Switch, eight ports",1,{"$nulls":5},{"v":7700,"d":"7,700"},{"$f":"I14*C14","v":{"v":7700,"d":"7,700"}}]
[null,"LightRules up to 250 Nodes (Desktop)",1,{"$nulls":5},{"v":48063,"d":"48,063"},{"$f":"I15*C15","v":{"v":48063,"d":"48,063"}},null,null,"Installation"]
[null,"Total for LightRules, ex VAT",{"$nulls":7},{"$f":"SUM(J12:J15)","v":{"v":137887,"d":"137,887"}},null,null,350,{"$f":"M16*N13","v":83650}]
[{"$nulls":12},"Cherry",37458]
[null,{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}},{"$nulls":5},"Cash Purchase",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"Cable",10200,null,"Rounded off"]
[{"$nulls":8},"Rental per month",{"$f":"'Rental Calculator'!H15","v":{"$error":"#REF!"}},{"$nulls":3},{"$f":"SUM(N16:N18)","v":131308},{"$f":"N19/0.65","v":202012.3076923077},205000]
[{"$nulls":8},"Annualised Rental",{"$f":"J19*12","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,"Clover City Deep",{"$nulls":4},"Sell",{"$nulls":6},"Less","Less","Tot Discount","Less","Less","Tot Disc"]
[null,"Description","Qty","DL $",{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},"Price","Total Order","Unit  ","Total ",null,"DLE12","List Price",{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"}]
[null,"DLE-12-ST-W-840-High Bay 12600lm 4000k 20-20",72,467.7,46.77,23.39,{"$f":"D27-E27-F27","v":397.54},{"$f":"G27*C27","v":28622.88},{"v":11037,"d":"11,037.00"},{"$f":"C27*I27","v":{"v":794664,"d":"794,664"}},null,135,11037,9934,10485,9382,{"$f":"M27-N27","v":1103},{"$f":"M27-O27","v":552},{"$f":"M27-P27","v":1655},{"$f":"N11*S27","v":220115},{"$f":"Q27*N11","v":146699}]
[null,"DLE-12-ST-W-840-High Bay 12600lm 4000k 0-0",9,467.7,46.77,23.39,{"$f":"D28-E28-F28","v":397.54},3577.86,{"v":11037,"d":"11,037.00"},{"$f":"C28*I28","v":{"v":99333,"d":"99,333"}}]
[null,"DLE-12-ST-N-840-High Bay 12600lm 4000k 20-20",42,467.7,46.77,23.39,{"$f":"D29-E29-F29","v":397.54},16696.68,{"v":11037,"d":"11,037.00"},{"$f":"C29*I29","v":{"v":463554,"d":"463,554"}}]
[null,"DLE-12-ST-W-840-High Bay 12600lm 4000k 20-20",10,467.7,46.77,23.39,{"$f":"D30-E30-F30","v":397.54},3975.4,{"v":11037,"d":"11,037.00"},{"$f":"C30*I30","v":{"v":110370,"d":"110,370"}},null,"DLE18"]
[null,"DLE-18-ST-N-840-High Bay 19100lm 4000k 20-20",106,593.28,59.33,29.66,{"$f":"D31-E31-F31","v":504.2899999999999},53454.73999999999,{"v":14127,"d":"14,127.00"},{"$f":"C31*I31","v":{"v":1497462,"d":"1,497,462"}},null,106,14127,{"$f":"+M31*(1-N26)","v":{"v":12714.300000000001,"d":"12714"}},{"$f":"+M31*(1-O26)","v":{"v":13420.65,"d":"13421"}},{"$f":"+M31*(1-P26)","v":{"v":12007.949999999999,"d":"12008"}},{"$f":"M31-N31","v":{"v":1412.699999999999,"d":"1413"}},{"$f":"M31-O31","v":{"v":706.3500000000004,"d":"706"}},{"$f":"M31-P31","v":{"v":2119.050000000001,"d":"2119"}},{"$f":"S31*N12","v":224619.3000000001},{"$f":"Q31*N12","v":149746.1999999999}]
[null,"DLE Fixed Mount Hanging Hardware for 5 Fixtures ",49,15,0,0,15,735,{"v":11037,"d":"11,037.00"},{"$f":"#REF!*I32","v":{"$error":"#REF!"}},null,{"$f":"L31+L27","v":241},{"$nulls":7},{"$f":"T27+T31","v":444734.3000000001},{"$f":"U27+U31","v":296445.1999999999}]
[null,"DLE Wago Connector 3m",{"$f":"SUM(C27:C31)","v":239},15,0,0,15,3585,{"v":346,"d":"346.00"},{"$f":"I33*C32","v":{"v":16954,"d":"16,954"}},null,{"$f":"L32/50","v":4.82}]
[null,"Total Fixtures & Accessories",{"$nulls":5},{"$f":"SUM(H27:H33)","v":110647.56},{"v":346,"d":"346.00"},{"$f":"I34*C33","v":{"v":82694,"d":"82,694"}}]
[]
[]
[null,"Light Rules","Qty","$",null,null,"$",null,"Rands","Rands"]
[null,"DL Gateways",5,575,0,0,575,{"$f":"G38*C38","v":{"v":2875,"d":"2,875"}},{"v":13253,"d":"13,253"},{"$f":"I38*C38","v":{"v":66265,"d":"66,265"}}]
[null,"PoE Switch, eight ports",2,295,0,0,295,{"$f":"G39*C39","v":590},{"v":6799,"d":"6,799"},{"$f":"I39*C39","v":{"v":13598,"d":"13,598"}}]
[null,"Total",{"$nulls":5},{"$f":"SUM(H38:H39)","v":{"v":3465,"d":"3,465"}}]
[]
[null,"Total Order",{"$nulls":5},{"$f":"H34+H40","v":{"v":114112.56,"d":"114,113"}}]
[]
[]
[null,"Siteworx Options","Nodes","$/node",null,null,"$/node"]
[null,"Siteworx (Tune Pro)Paid to Digial Lumens per year",{"$f":"C33","v":239},5,0,0,5,{"$f":"G46*C46","v":{"v":1195,"d":"1,195"}},67,{"$f":"I46*C46","v":{"v":16013,"d":"16,013"}}]
[null,"Siteworx (Tune Basic)Paid to Digial Lumens per year",{"$f":"C33","v":239},1,0,0,1,{"$f":"G47*C47","v":239},{"v":13.4,"d":"13"},{"$f":"I47*C47","v":{"v":3202.6,"d":"3,203"}}]

{"sheet":"Print Quote","index":10,"n_rows":71,"n_cols":9,"rows_kept":71,"hidden":true,"merged":[[1,1,1,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[8,1,8,5],[10,1,10,5],[12,1,13,5],[15,1,15,5],[17,1,18,5],[37,1,40,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5],[46,1,47,5],[48,1,48,5],[49,1,49,5],[51,1,52,5],[55,4,55,5],[58,1,58,2],[69,1,69,2],[70,1,70,2]]}
[]
[null,"Tuesday 13 October 2015"]
[]
[null,"Engen – Jack Street"]
[null,"Mr. Macintyre"]
[]
[]
[]
[null,"Re: Quotation for Cree LED Site & Forecourt lighting"]
[]
[null,"Dear Partners"]
[]
[null,"It is with great pleasure that we present this quotation to you for the supply of new Engen specification LED lighting for your canopy, forecourt and interior. "]
[]
[]
[null,"We have performed a lighting analysis, the quotation based on the results  are herewith attached for your perusal."]
[]
[null,"Please also keep in mind that there is a finance option available to you and that will carry the VAT benefits as well as keeping you liquid."]
[]
[]
[null,"Quote"]
[null,"Installed Area","Description","Qty","Unit Price ","Total Price"]
[null,"Main Canopy ","Cree CPY 250 Recessed Mount Canopy Luminaire, 60LED, 700mA, 6000K, complete with Mounting Bracket - No Sensor",14,"Main Canopy ","Cree CPY 250 Recessed Mount Canopy Luminaire, 60LED, 700mA, 6000K, complete with Mounting Bracket - No Sensor",14,{"v":8446,"d":"R 8,446.00"},{"$f":"SUM(G23*H23)","v":{"v":118244,"d":"R 118,244.00"}}]
[null,"Perimeter Sign","Cree Ledway Road 20 LED, QV optic, 700mA, 6000K (Mounted back to back, incl retrofit bracket)",1,"Perimeter Sign","Cree Ledway Road 20 LED, QV optic, 700mA, 6000K (Mounted back to back, incl retrofit bracket)",1,{"v":14801,"d":"R 14,801.00"},{"$f":"SUM(G24*H24)","v":{"v":14801,"d":"R 14,801.00"}}]
[null,"Bollards","Pathway 900mm Symmetrical Beam LED Bollard",3,"Bollards","Pathway 900mm Symmetrical Beam LED Bollard",10,{"v":8069,"d":"R 8,069.00"},{"v":80690,"d":"R 80,690.00"}]
[null,"Diesel Pump","Cree Ledway Road 20 LED, QV optic, 700mA, 6000K (Mounted back to back, incl retrofit bracket)",1,"Diesel Filler","Cree 1lt Ledway Road 20 LED, QV optic in white including Retrofit Spigot",2,{"v":7405,"d":"R 7,405.00"},{"v":14810,"d":"R 14,810.00"}]
[null,"Bulkheads on building","Edgelit LED Wall Mounted Bulkhead Assymetrical Optic 4000K  25W ",10,"Bulkheads on building","BetaLED Wall Pack with mounting bracket",10,{"v":8549,"d":"R 8,549.00"},{"v":85490,"d":"R 85,490.00"}]
[null,"Point of Sale","LK.GYRO2.3040840.WH Double Gyro Recessed Spotlight\n",2,"Point of Sale","LK.GYRO2.3040840.WH Double Gyro Recessed Spotlight\n",2,{"v":7695,"d":"R 7,695.00"},{"v":15390,"d":"R 15,390.00"}]
[null,"Spot Lights on Cable Tray","CLS Revo Basic 12 Degree Symmetrical Surface Mounted LED Spotlight",8,"Spot Lights on Cable Tray","CLS Revo Basic 12 Degree Symmetrical Surface Mounted LED Spotlight",8,{"v":3795,"d":"R 3,795.00"},{"v":30360,"d":"R 30,360.00"}]
[null,"Cable tray Lighting","54W Fluorescent Batton with Reflector",16,"Cable tray Lighting","54W Fluorescent Batton with Reflector",14,{"v":450,"d":"R 450.00"},{"$f":"SUM(G30*H30)","v":{"v":6300,"d":"R 6,300.00"}}]
[null,"Toilets","Cree CR 150 - 1000 Lumen 4000K 90+ CRI high efficacy LED downlight ",8,"Toilets","Cree CR 150 - 1000 Lumen 4000K 90+ CRI high efficacy LED downlight ",8,{"v":1590,"d":"R 1,590.00"},{"$f":"SUM(G29*H31)","v":{"v":12720,"d":"R 12,720.00"}}]
[null,"Store room","LED Weatherproof surface mounted luminaire",4,"Installation","Safety Files, Removal of old fixtures, Scaffolding and Labour/Travel",1,{"v":35000,"d":"R 35,000.00"},{"$f":"H32*G32","v":{"v":35000,"d":"R 35,000.00"}}]
[null,"Entrance","Cree Ledway Road 20 LED, QV optic, 700mA, 6000K ( incl retrofit bracket)",1,{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Study Data'!#REF!","v":{"$error":"#REF!"}},"Cash Purchase",{"$f":"SUM(I23:I32)","v":{"v":413805,"d":"R 413,805.00"}}]
[null,"5M Pole ","5m Surface Mounted Galvanized Pole and Powder Coated White with Base plate and Bolt cage Single or Double spigot",3,{"$nulls":3},"Rental per month",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Vents","Cree Ledway Road 20 LED, QV optic, 700mA, 6000K (Mounted back to back, incl retrofit bracket)",1,{"$nulls":3},"Annualised Rental",{"$f":"I34*12","v":{"$error":"#REF!"}}]
[null,"Diesel Dispenser Remote","Cree Ledway Road 20 LED, QV optic, 700mA, 6000K (Mounted back to back, incl retrofit bracket)",1]
[]
[null,"The Cree outdoor products carry a 10 year warranty (no serviceable parts) on the housing, internal electronics or components and excessive lumen depreciation. The rated fixture life is >150,000hrs to L70 @ 20⁰C. With maximum energy savings and the longest guaranteed maintenance free period, Cree is the global leader in Petroleum LED today."]
[]
[]
[]
[]
[null,"Term & Conditions:"]
[null,"•  This quotation is valid for 7 days and subject to change without notice"]
[null,"•  This quotation excludes VAT & Transport"]
[null,"•  All Cree outdoor products carry a 10 year warranty"]
[null,"•  Although the items in this quote are Engen Stock items,  stock availability is subject to change and lead times could apply. Please confirm at time of order."]
[]
[null,"•  Payment is due with order before delivery for non account holders."]
[null,"•  Errors & Omissions Excluded"]
[]
[null,"I hereby accept the terms and conditions of the quotation above and are authorized to sign this document. Please forward the Pro Forma for payment."]
[]
[]
[]
[null,"Signed:",null,"Date:"]
[]
[]
[null,"Purchase Order Number - _______________________"]
[]
[null,"Sincerley"]
{"$rows_empty":8}
[null,"Martin De La Rey"]
[null,"Petroleum Projects"]

{"sheet":"Sheet2","index":11,"n_rows":60,"n_cols":2,"rows_kept":60,"hidden":true}
[1,"Pv"]
[2,1000]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]