{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Part 1- Once off ","P2 -6 monhlty","P3- P's & G's","Total Summary Pricing for Secti","Labout rates & Travel "],"read":"whole","date_system":"1900"}

{"sheet":"Part 1- Once off ","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"merged":[[0,0,0,4],[1,0,1,4],[10,0,10,3]]}
["Part 1 – Once Off Initial Work "]
["SECTION A.  Once Of Initial work "]
["Line Item","Description","Quantity","Unit price","Total"]
["P1.1","Uninstall/configure the current  installed Billing Software ","Sum"]
["P1.2","Implement a server for BMS Factory that will Talk BMS server to receive billing data","Sum"]
["P1.3","Move PNPSCADA to a newly updated Scada, with all hardware and software that would be compatible with ACSA IT ","Sum"]
["P1.4","Spin up another virtual machine with relevant software on it/or any compatible and move the data across from one server to the other","Sum"]
["P1.5","Supply and operate Optical Eye to draw history of up to 6-12 months for tenants with queries","Sum"]
["P1.6","Do Tariff Optimization","Sum"]
["P1.7","Configure ACSA BMS Contractor to configure Rockwell BMS to read the new tags. (This cost will be claimed at proven cost)","Sum",null,{"$f":"D10","v":{"v":0,"d":"R0.00"}}]
[" Sub-total-Part 1 Excl. VAT                                                                                                                      ",{"$nulls":3},{"$f":"SUM(E4:E10)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"P2 -6 monhlty","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[0,0,0,4],[2,0,2,4],[15,0,15,3]]}
["Part 2 – Billing and Maintenance for a period of 6 Months"]
[]
[" Service level agreement to maintain service generate the monthly billing report and attend to all call outs for a period of six  mnths:"]
["Line Item","Description","Quantity per year","Unit price","Total"]
["P2.1","Generate Electricity billing report",6]
["P2.2","Generate Water Billing Report",6]
["P2.3","Generate Electricity billing report (top 10 users on equipment)",6]
["P2.4","Database, software, field devices Maintenance cost (including travelling cost, consumables, accommodation, and Labor where applicable)",6]
["P2.5","Call Outs (Including travel cost and first hour Labor) – This will be claimed on proven cost",6]
["P2.6","Provisional annual sum for Permit Cost","Sum",{"v":10000,"d":"R10,000.00"}]
["P2.7","Annual tariff adjustments, assign and/or remove tenants billing information, license update and patches,",1]
["P2.8","Usage billing reports (graphic hi-end report, high usage customers, ACSA usage report etc.)",6]
["P2.9","Attend to customers/tenants billing queries",6]
["P2.10","Perform tariff optimization","sum"]
["P2.11","Yearly/according to the Period of updating system sofware ","sum"]
["Sub-total-P2 Excl. VAT                                                                                                                                   ",{"$nulls":3},{"$f":"SUM(E5:E15)","v":0}]

{"sheet":"P3- P's & G's","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"merged":[[0,0,0,4],[7,0,7,3]]}
["Part 3- Preliminary and General"]
["Line Item","Description","Quantity","Unit price","Total Excl. VAT."]
["P3.1","Travelling Cost ",6]
["P3.2","Safety File",1,{"v":10000,"d":"R10,000.00"},{"$f":"C4*D4","v":{"v":10000,"d":"R10,000.00"}}]
["P3.3","Provisional sum for spares",1,{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"}]
["P3.4 ","Provisional site Vehicle ",6,{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
["P3.4","Airport Training (AIT &AVOP)",1,{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"}]
["Sub-total-Part 3 Excl. VAT                                                  ",{"$nulls":3},{"$f":"SUM(E3:E9)","v":0}]

{"sheet":"Total Summary Pricing for Secti","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[0,0,0,1],[1,0,1,1]]}
["Total Summary Pricing for Section A and Section B "]
["PRICE SUMMARY FOR A PROJECT and MAINTENANCE"]
["Description","Price"]
["Part 1 – Once Off Initial Work "]
["Part 2 – Billing and Maintenance for a period of 6 Months "]
["Part 3- Preliminary and General"]
["Sub-Total"]
["VAT@ 15%"]
["Total Price Offer to be Carried to the Form of Offer","R "]

{"sheet":"Labout rates & Travel ","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,0,0,4],[1,0,2,0],[1,1,2,1],[1,2,1,4],[8,0,8,4],[10,2,10,4]]}
["Labour Rates -Bidder to Complete "]
["Skill","Normal Hourly Rate","After Hours Hourly Rates"]
[null,null,"Weekdays ","Sartuday ","Sundays /Public holidays "]
["Site Manager "]
["Electrician "]
["Assistant Electrician"]
[]
[]
["Travel Rate Schedule"]
["Rate /Km","Distance in km (retrun trip)","Total /Trip Excluding VAT"]