{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gen BOQ","Yearly Service Rates Generators"],"not_rendered":{"external_links":23,"defined_names":1916},"read":"whole","date_system":"1900"}

{"sheet":"Gen BOQ","index":0,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[8,1,8,4],[16,1,16,2],[16,3,16,4],[36,0,36,1],[36,2,36,4]]}
["Item no.","Activity Description","Frequency","Quantity (per year)","Amount (per single item)","Total (per year)"]
[1,"Contract Management and administration (including required reporting such as Annual service reports, spares inventory management reports, parking, etc.).","Annually",1,0,{"$f":"E2*D2","v":0}]
[2,"Insurance (All ACSA required insurance)","Annually",1,0,0]
[3,"Permits, Induction, Medicals (Permits valid for 2 years)","2 yearly",1,0,0]
[null,"OHS Act Safety Plan and environmental compliance (safety file preparations)","Once-off",1,0,{"$f":"E5*D5","v":0}]
[4,"Annual Service Kit ","Annually",1,0,0]
[5,"Travelling to Site (reimbursable with proof of spend)","Annually",1,0,0]
[6,"Yearly Diesel Generator Preventative Maintenance (BFN)","Annually",1,{"$f":"'Yearly Service Rates Generators'!G2","v":0},0]
[null,"Preventative Maintenance Sub-Total A (per year)",{"$nulls":3},{"$f":"SUM(F2:F8)","v":0}]
[]
[]
[null,"Description","Qty","Call out fee","Total / year"]
[null,"Call-out fee: Includes first hour on site and travelling fee",2,0,{"$f":"D13*C13","v":0}]
[null,"Electrician (Saturday Rate)",18,0,{"$f":"D14*C14","v":0}]
[null,"Diesel Mechanic (Saturday Rate)",18,0,0]
[null,"Assistant / Labourer (Saturday Rate)",18,0,0]
[null,"Labour Sub-Total B (per year)",null,{"$f":"SUM(E13:E16)","v":0}]
[]
[]
["Number","Description","Quantity","Cost Per Item","TOTAL PRICE"]
[1,"Main Controller\n(priced once over the 5-year period)",1,0,{"$f":"D21*C21","v":0}]
[2,"Starter Batteries",1,0,{"$f":"D22*C22","v":0}]
[3,"Batteries",7,0,0]
[4,"Temperature Switch",1,0,0]
[5,"Emergency fuel cut-off fuse",1,0,0]
[6,"Pressure Switch",1,0,0]
[7,"Coolant heaters + hoses",1,0,0]
[8,"Fuel hoses",1,0,0]
[9,"Solenoids",1,0,0]
[10,"Relays",1,0,0]
[11,"Fuses",1,0,0]
[12,"Lamps",1,0,0]
[13,"Gaskets",1,0,0]
[14,"Injectors (sets)",1,0,0]
[15,"Coolant - Fuel Pump ",1,0,0]
[16,"Fuel Pump ",1,0,0]
["Sub-Total C (per year)",null,{"$f":"SUM(E21:E36)","v":0}]
[]
[]
[]
[null,"Description","Total (excluding VAT)"]
[null,"Preventative maintenance Sub-Total A",{"$f":"F9","v":0}]
[null,"Call Outs cost Sub-Total B        ",{"$f":"D17","v":0}]
[null,"Spares & Consumables - Sub-Total C",{"$f":"C37","v":0}]
[null,"1 Year estimated contract value",{"$f":"SUM(C42:C44)","v":0}]
[]
[]
[null,"Description","Total \n(excl VAT)"]
[null,"Escalation Rate (CPI)"]
[null,"Year 1 Contract Amount",{"$f":"C45","v":0}]
[null,"Year 2 Contract Amount",{"$f":"C50*(1+C49)","v":0}]
[null,"Year 3 Contract Amount",{"$f":"C51*(1+C49)","v":0}]
[null,"Year 4 Contract Amount",{"$f":"C52*(1+C49)","v":0}]
[null,"Year 5 Contract Amount",{"$f":"C53*(1+C49)","v":0}]
[null,"Grand Total = Year 1 + Year 2 + Year 3 + Year 4 + Year 5     ",{"$f":"SUM(C50:C54)","v":0}]

{"sheet":"Yearly Service Rates Generators","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"merged":[[1,1,2,1],[1,6,5,6],[8,1,8,3],[9,1,11,3]]}
["Airport","AREA SUPPLIED","MAKE","KVA","FUEL STORAGE CAPACITY(Lt.)","Annual Service Rate","Total per Site"]
["Bram Fischer","Terminal building, AGL, Car rentals, Substation A, Chiller plant, Apron","Perkins",500,5500,0,{"$f":"SUM(F2:F6)","v":0}]
["Bram Fischer",null,"Perkins",500,5500,0]
["Bram Fischer","Fire station, Pump station,Engen & Depot ","VOLVO PENTA",150,2800,0]
["Bram Fischer","Standby Generator","JOHN DEERE",200,340,0]
["Bram Fischer","Fire Simulator Generator","FAW",15,50,0]
[]
[]
[null,"Annual Service:"]
[null,"Annual Servicing of Diesel Engine\nCleaning and Pressure Testing of Bulk Tank\nAnnual Servicing of the breakers"]