{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Min pipe size","Case Delivery","Guide","WSC List","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Min pipe size","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,1,49,8],[22,1,22,4],[24,1,24,8],[30,1,30,4],[32,1,32,8],[44,1,44,4],[46,1,46,4],[8,1,8,8],[0,5,0,8],[4,1,5,1],[2,2,2,6],[3,2,3,6],[4,2,5,6]]}
[null,"PRE-TENDER FORM V5 FOR SYDNEY WATER SHARE OF WORKS",null,null,null,"Completed form to be zipped with the Developer Works Deed and attached to the Submit Agreement e-Developer work item"]
[]
[null,"PROJECT NAME AND LOCATION",null,null,null,null,null,"CASE NUMBER"]
[null,"WATER SERVICE COORDINATOR (Company)",null,null,null,null,null,"PROJECT TYPE"]
[null,"CASE DESCRIPTION","Adjustment / Deviation / Upsizing / Extension of xxx (length of pipe)",null,null,null,null,"PREPARED BY"]
[null,null,null,null,null,null,null,"DATE"]
[]
[null,"NOTE - ALL COSTS EXCLUDE GST","No. of Units","Per Unit","Unit Rate","Total Amount","SW SOW %","SW SOW  $","DEV SOW $"]
[null,"Category A - Professional Services for:"]
[null,"Water Servicing Coordination (Process/Quality Assurance)",null,"m / hr / etc",null,{"$f":"C10*E10","v":0},0,{"$f":"F10*G10","v":0},{"$f":"F10-H10","v":0}]
[null,"Design",null,"m / hr / etc",null,{"$f":"C11*E11","v":0},0,{"$f":"F11*G11","v":0},{"$f":"F11-H11","v":0}]
[null,"Project Management",null,"m / hr / etc",null,0,0,{"$f":"F12*G12","v":0},0]
[null,"Modelling*",null,"m / hr / etc",null,0,0,0,0]
[null,"Geotechnical Assessment",null,"m / hr / etc",null,0,0,0,0]
[null,"Environmental Assessment",null,"m / hr / etc",null,0,0,0,0]
[null,"Heritage Assessment",null,"m / hr / etc",null,0,0,0,0]
[null,"Option Studies",null,"m / hr / etc",null,0,0,0,0]
[null,"Procurement (fee only required if this is a separate engagement to the WSC)",null,"m / hr / etc",null,0,0,0,0]
[null,"Survey",null,"m / hr / etc",null,0,0,0,0]
[null,"Workshop studies e.g. RBCE, CHAIR etc.*",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Sub-Total A",null,null,null,{"$f":"SUM(F10:F22)","v":0},null,{"$f":"SUM(H10:H22)","v":0},{"$f":"SUM(I10:I22)","v":0}]
[]
[null,"Category B - Delivery:"]
[null,"Construction (including testing, flow management, commissioning)",null,"m / hr / etc",null,{"$f":"C26*E26","v":0},0,{"$f":"F26*G26","v":0},{"$f":"F26-H26","v":0}]
[null,"Supervision*",null,"m / hr / etc",null,{"$f":"C27*E27","v":0},0,{"$f":"F27*G27","v":0},{"$f":"F27-H27","v":0}]
[null,"Commissioning Engineer (Facility Assets)*",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Sub-Total B",null,null,null,{"$f":"SUM(F26:F30)","v":0},null,{"$f":"SUM(H26:H30)","v":0},{"$f":"SUM(I26:I30)","v":0}]
[]
[null,"Category C - Contingency:"]
[null,"Rock",null,"m / hr / etc",null,{"$f":"C34*E34","v":0},0,{"$f":"F34*G34","v":0},{"$f":"F34-H34","v":0}]
[null,"Traffic Control",null,"m / hr / etc",null,{"$f":"C35*E35","v":0},0,{"$f":"F35*G35","v":0},{"$f":"F35-H35","v":0}]
[null,"Road Restoration – temporary",null,"m / hr / etc",null,0,0,0,0]
[null,"Road Restoration",null,"m / hr / etc",null,0,0,0,0]
[null,"Deep Excavations",null,"m / hr / etc",null,0,0,0,0]
[null,"NOE/Valuation/Compensation",null,"m / hr / etc",null,0,0,0,0]
[null,"Miscellaneous",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Sub-Total C",null,null,null,{"$f":"SUM(F34:F44)","v":0},null,0,0]
[]
[null,"TOTAL",null,null,null,{"$f":"F45+F31+F23","v":0},null,{"$f":"H45+H31+H23","v":0},{"$f":"I45+I31+I23","v":0}]
[null,null,null,null,null,"Total Amount",null,"SW SOW  $","DEV SOW $"]
[]
[null,"General Notes:"]

{"sheet":"Case Delivery","index":1,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,5,0,8],[49,1,49,8],[4,1,5,1],[30,1,30,4],[44,1,44,4],[24,1,24,8],[32,1,32,8],[46,1,46,4],[8,1,8,8],[22,1,22,4],[2,2,2,6],[3,2,3,6],[4,2,5,6]]}
[null,"PRE-TENDER FORM V5 FOR SYDNEY WATER SHARE OF WORKS",null,null,null,"Completed form to be zipped with the Developer Works Deed and attached to the Submit Agreement e-Developer work item"]
[]
[null,"PROJECT NAME AND LOCATION",null,null,null,null,null,"CASE NUMBER"]
[null,"WATER SERVICE COORDINATOR (Company)",null,null,null,null,null,"PROJECT TYPE"]
[null,"CASE DESCRIPTION","Adjustment / Deviation / Upsizing / Extension of xxx (length of pipe)",null,null,null,null,"PREPARED BY"]
[null,null,null,null,null,null,null,"DATE"]
[]
[null,"NOTE - ALL COSTS EXCLUDE GST","No. of Units","Per Unit","Unit Rate","Total Amount","SW SOW %","SW SOW  $","DEV SOW $"]
[null,"Category A - Professional Services for:"]
[null,"Water Servicing Coordination (Process/Quality Assurance)",null,"m / hr / etc",null,{"$f":"C10*E10","v":0},0,{"$f":"F10*G10","v":0},{"$f":"F10-H10","v":0}]
[null,"Design",null,"m / hr / etc",null,{"$f":"C11*E11","v":0},0,{"$f":"F11*G11","v":0},{"$f":"F11-H11","v":0}]
[null,"Project Management",null,"m / hr / etc",null,0,0,{"$f":"F12*G12","v":0},0]
[null,"Modelling*",null,"m / hr / etc",null,0,0,0,0]
[null,"Geotechnical Assessment",null,"m / hr / etc",null,0,0,0,0]
[null,"Environmental Assessment",null,"m / hr / etc",null,0,0,0,0]
[null,"Heritage Assessment",null,"m / hr / etc",null,0,0,0,0]
[null,"Option Studies",null,"m / hr / etc",null,0,0,0,0]
[null,"Procurement (fee only required if this is a separate engagement to the WSC)",null,"m / hr / etc",null,0,0,0,0]
[null,"Survey",null,"m / hr / etc",null,0,0,0,0]
[null,"Workshop studies e.g. RBCE, CHAIR etc.*",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,{"$f":"C22*E22","v":0},0,0,0]
[null,"Sub-Total A",null,null,null,{"$f":"SUM(F10:F22)","v":0},null,{"$f":"SUM(H10:H22)","v":0},{"$f":"SUM(I10:I22)","v":0}]
[]
[null,"Category B - Delivery:"]
[null,"Construction (including testing, flow management, commissioning)",null,"m / hr / etc",null,{"$f":"C26*E26","v":0},0,{"$f":"F26*G26","v":0},{"$f":"F26-H26","v":0}]
[null,"Supervision*",null,"m / hr / etc",null,{"$f":"C27*E27","v":0},0,{"$f":"F27*G27","v":0},{"$f":"F27-H27","v":0}]
[null,"Commissioning Engineer (Facility Assets)*",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,{"$f":"C29*E29","v":0},0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Sub-Total B",null,null,null,{"$f":"SUM(F26:F30)","v":0},null,{"$f":"SUM(H26:H30)","v":0},{"$f":"SUM(I26:I30)","v":0}]
[]
[null,"Category C - Contingency:"]
[null,"Rock",null,"m / hr / etc",null,{"$f":"C34*E34","v":0},0,{"$f":"F34*G34","v":0},{"$f":"F34-H34","v":0}]
[null,"Traffic Control",null,"m / hr / etc",null,{"$f":"C35*E35","v":0},0,{"$f":"F35*G35","v":0},{"$f":"F35-H35","v":0}]
[null,"Road Restoration – temporary",null,"m / hr / etc",null,{"$f":"C36*E36","v":0},0,0,0]
[null,"Road Restoration",null,"m / hr / etc",null,0,0,0,0]
[null,"Deep Excavations",null,"m / hr / etc",null,0,0,0,0]
[null,"NOE/Valuation/Compensation",null,"m / hr / etc",null,0,0,0,0]
[null,"Miscellaneous",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Other (specify):",null,"m / hr / etc",null,0,0,0,0]
[null,"Sub-Total C",null,null,null,{"$f":"SUM(F34:F44)","v":0},null,0,0]
[]
[null,"TOTAL",null,null,null,{"$f":"F45+F31+F23","v":0},null,{"$f":"H45+H31+H23","v":0},{"$f":"I45+I31+I23","v":0}]
[null,null,null,null,null,"Total Amount",null,"SW SOW  $","DEV SOW $"]
[]
[null,"General Notes:"]

{"sheet":"Guide","index":2,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[11,1,12,1],[16,1,16,8],[17,6,29,6],[17,7,29,7],[17,8,29,8],[9,2,9,6],[10,2,10,6],[11,2,12,6],[17,9,29,9],[17,2,29,2],[17,3,29,3],[17,4,29,4],[17,5,29,5],[30,1,30,4],[33,5,37,5],[33,6,37,6],[33,7,37,7],[33,9,37,9],[32,1,32,8],[52,1,52,4],[54,1,54,4],[57,1,57,8],[41,8,51,8],[33,2,37,2],[33,3,37,3],[33,4,37,4],[33,8,37,8],[41,7,51,7],[41,2,51,2],[41,3,51,3],[41,4,51,4],[41,5,51,5],[41,6,51,6],[38,1,38,4],[40,1,40,8]]}
[null,"Instructions"]
[null,"1. The 'Case Delivery' worksheet must be completed for all cases requesting funding from Sydney Water as per  the 'Funding for Growth Infrastructure Policy'."]
[null,"2. If a request is to be made for upsizing the Min Pipe Size worksheet needs to be also completed"]
[null,"3. Completed form to be zipped with the Developer Works Deed and attached to the Submit Agreement e-Developer work item"]
[]
[]
[]
[null,"PRE-TENDER FORM V4 FOR SYDNEY WATER SHARE OF WORKS - READ THE GREEN TEXT FOR GUIDES"]
[]
[null,"PROJECT NAME AND LOCATION","SW Project title / Location of the development (primary asset location)",null,null,null,null,"CASE NUMBER","e-Developer Case Number"]
[null,"WATER SERVICE COORDINATOR (Company)","Click the drop down box and select your WSC Company Name",null,null,null,null,"PROJECT TYPE","Select from drop down list (PW, RW, WW or SW)"]
[null,"CASE DESCRIPTION","Delete case descriptions that do not apply, or if Extension of an existing service type the length of pipe details",null,null,null,null,"PREPARED BY"," WSC Personnell Name who has completed this form"]
[null,null,null,null,null,null,null,"DATE","Date the form has been completed"]
[]
[]
[null,"NOTE - ALL COSTS EXCLUDE GST","No. of Units","Per Unit","Unit Rate","Total Amount","SW SOW %","SW SOW  $","DEV SOW $","* = Facility or large assets"]
[null,"Category A - Professional Services for:"]
[null,"Water Servicing Coordination (Process/Quality Assurance/project management) = A quotation for the time taken to complete the quality assurance for works subject to Sydney Water funding.","\nAny number","\nCan be hours, meters, days etc"," $ value per unit"," Automatically populates"," Insert percentage value (10, 22.5, 50 etc) as per Sydney Water's Funding Policy"," Automatically populates"," Automatically populates","* = Facility or large assets"]
[null,"Design = A quotation for the time taken to complete the design plan and associated documents for works subject to Sydney Water funding."]
[null,"Project Management = A quotation for the time taken for an independent Project Manager to manage the works subject to Sydney Water funding. Do not complete this field if the project management role is to be carried out by the WSC."]
[null,"Modelling* = A quotation for the time taken by a Specialist Professional Service Contractor to carry out hydraulic modelling of the works subject to Sydney Water fundng. (servicing options)."]
[null,"Geotechnical Assessment = A quotation for the cost of a Professional Service Contractor to carry out a geotechnical assessment for works subject to Sydney Water funding "]
[null,"Environmental Assessment = A quotation for the cost of a Professional Service Contractor to prepare an REF."]
[null,"Heritage Assessment = A quotation for the cost of a Professional Service Contractor to prepare heritage study."]
[null,"Option Studies =  A quotation for the cost of a Professional Service Contractor to prepare an options (preferred servicing strategy) report."]
[null,"Procurement = A quotation for the cost of a Professional Service Contractor to prepare a procurement/tender package for Sydney Water approval (for any type of service provider e.g. constructor, designer etc)"]
[null,"Survey = A quotation for the cost of a Surveyor to carry out survey of works subject to Sydney Water funding."]
[null,"Workshop studies e.g. RBCE, CHAIR etc.* = A quotation for the cost of a Facilitator to conduct a workshop(s) and prepare a report for Sydney Water approval."]
[null,"Other (specify): = Any other items related to works being funded by Sydney Water."]
[null,"Other (specify):"]
[null,"Sub-Total A",null,null,null,{"$f":"SUM(F18:F30)","v":0},null,{"$f":"SUM(H18:H30)","v":0},{"$f":"SUM(I18:I30)","v":0}]
[]
[null,"Category B - Delivery:"]
[null,"Construction (including testing, flow management, commissioning) = A quotation for the cost of the works subject to Sydney Water funding.","Any number","Can be hours, meters, days etc"," $ value per unit"," Automatically populates"," Insert percentage value (10, 22.5, 50 etc) as per Sydney Water's Funding Policy"," Automatically populates"," Automatically populates","* = Facility or large assets"]
[null,"Supervision* = A quotation for the cost of the Superintendent to manage any construction issues/variations/contracts management of works subject to Sydney Water funding."]
[null,"Commissioning Engineer (Facility Assets)* = A quotation for the cost of the Commissioning Engineer to facilitate the commissioning of works subject to Sydney Water funding."]
[null,"Other (specify): = Any other items related to works being funded by Sydney Water. "]
[null,"Other (specify):"]
[null,"Sub-Total B",null,null,null,{"$f":"SUM(F34:F38)","v":0},null,{"$f":"SUM(H34:H38)","v":0},{"$f":"SUM(I34:I38)","v":0}]
[]
[null,"Category C - Contingency:"]
[null,"Rock","Any number","Can be hours, meters, days etc"," $ value per unit"," Automatically populates"," Insert percentage value (10, 22.5, 50 etc) as per Sydney Water's Funding Policy"," Automatically populates"," Automatically populates"]
[null,"Traffic Control"]
[null,"Road Restoration – temporary"]
[null,"Road Restoration"]
[null,"Deep Excavations"]
[null,"NOE/Valuation/Compensation"]
[null,"Miscellaneous"]
[null,"Other (specify):"]
[null,"Other (specify):"]
[null,"Other (specify):"]
[null,"Other (specify):"]
[null,"Sub-Total C",null,null,null,{"$f":"SUM(F42:F52)","v":0},null,0,0]
[]
[null,"TOTAL",null,null,null,{"$f":"F53+F39+F31","v":0},null,{"$f":"H53+H39+H31","v":0},{"$f":"I53+I39+I31","v":0}]
[null,null,null,null,null,"Total Amount",null,"SW SOW  $","DEV SOW $"]
[]
[null,"General Notes: Place information to explain any above decisions "]

{"sheet":"WSC List","index":3,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"WSC Company Name",null,"Services"]
[null,"ACOR Consultants Pty Ltd",null,"PW"]
[null,"AECOM Australia Pty Ltd",null,"RW"]
[null,"Arcadis Australia Pacific Pty Ltd",null,"SW"]
[null,"AT&L and Associates Pty Ltd",null,"WW"]
[null,"Ausflow Pty Ltd"]
[null,"AWPM Australian Water Project Management"]
[null,"Billbergia Pty Ltd "]
[null,"Burton & Field Pty Ltd "]
[null,"Calibre Professional Services Pty Ltd"]
[null,"Cardno (NSW/ACT) Pty Ltd"]
[null,"Frawley Design Services Pty Ltd"]
[null,"GHD Pty Ltd"]
[null,"Greg Houston Plumbing Pty Ltd"]
[null,"Harrison Friedmann & Associates Pty Ltd"]
[null,"Hills Consulting Engineers Pty Ltd"]
[null,"John M Daly & Associates Pty Ltd"]
[null,"K F Williams Environmental Services Pty Ltd"]
[null,"K.R. Stubbs & Associates Pty Ltd"]
[null,"Kellogg Brown & Root Pty Ltd"]
[null,"L P Consulting Australia Pty Ltd"]
[null,"LandPartners Pty Ltd"]
[null,"MetroWater Management"]
[null,"MGP Building & Infrastructure Services"]
[null,"Mott MacDonald Australia Pty Ltd"]
[null,"North Western Surveys Pty Ltd"]
[null,"Olsen Infrastructure Pty Ltd"]
[null,"P.R. & C.M. Drafting Pty Limited"]
[null,"Qalchek Pty Ltd"]
[null,"RMA Infrastructure Pty Ltd"]
[null,"Rose Atkins Rimmer (Infrastructure) Pty Ltd"]
[null,"Simply Water and Sewer Pty Ltd"]
[null,"SMEC Australia Pty Ltd"]
[null,"Sydney Wide Coordinators"]
[null,"Warren Smith  & Partners Pty Ltd"]
[null,"WSP Australia Pty Ltd"]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}