{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["BidSchedule"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"BidSchedule","index":0,"n_rows":43,"n_cols":7,"rows_kept":43,"merged":[[0,1,0,6],[2,2,2,4],[5,0,5,6],[8,0,8,4],[16,1,16,6],[21,1,21,6],[28,0,28,4],[31,0,31,4],[34,0,34,4],[42,2,42,4]]}
[null,"Appendix E Price Proposal/ Bidding Schedule - RFP # 2223-07AR"]
[]
[null,"Vendor Name"]
[]
[null,"INSTRUCTIONS:"]
["Enter Unit Prices in the highlighted (yellow) cells below.  The annual price and grand total will calculate automatically.  Once this sheet is complete, save this file as an excel file and name the file: (your companyname Appendix E Bidding Schedule), and attach in the online bidding system with you onlinie bid. This file must be seperate from your response to the bid. Do not include pricin in your technical proposal. Enter the Grand Total price on line 1 in the online bidding system.  Failure to attach this file may result in rejection of bid."]
[]
["Item","Description","Units","Quantity","Enter Unit Price per Item",null,"Total Extended Price (Quantity x Unit Price)"]
["Construction Rates - new construction or renovation work where a turnkey job is quoted including equipment, installation, project management, etc."]
["1a","Electrical Labor (Normal)","hourly rate",1,null,null,{"$f":"E10*D10","v":0}]
["1b","Electrical Labor (Overtime)","hourly rate",1,null,null,0]
["2a","Engineering Labor (Normal) - Includes drawings, database & programming, system graphic creation, and project management","hourly rate",1,null,null,0]
["2b","Engineering Labor (Overtime) - Includes drawings, database & programming, system graphic creation, and project management","hourly rate",1,null,null,0]
["3a","Technician / On-Site Start Up (Normal) - Includes onsite technician and PXC/DXR startup","hourly rate",1,null,null,0]
["3b","Technician / On-Site Start Up (Overtime) - Includes onsite technician and PXC/DXR startup","hourly rate",1,null,null,0]
[]
[null,"Service Rates - Spot service repair (repair, programming assistance, system upgrades, etc.) as opposed to a complete construction project; technical service only"]
["4a","Standard Working Hours","hourly rate",1,null,null,{"$f":"D18*E18","v":0}]
["4b","Overtime Hours","hourly rate",1,null,null,{"$f":"D19*E19","v":0}]
["4c","Sunday / Holiday Hours","hourly rate",1,null,null,0]
[]
[null,"Other"]
[5,"Mileage / Travel","mile",1,null,null,{"$f":"E23*D23","v":0}]
[6,"Onsite Operator's Training I -  Maximum of 18 people","days",1,null,null,{"$f":"E24*D24","v":0}]
[7,"Onsite Operator's Training II -  Maximum of 18 people","days",1,null,null,0]
[8,"Onsite Maintenance Personnel Training","days",0.5,null,null,0]
[9,"System Administration Training","days",1,null,null,0]
[]
["APPENDIX A"]
[10,"Controls work associated with the replacement of 4 existing MAUs with 4 new Trane MAUs with gas heat. Lump Sum Bid shall include all work described within the specifications provided in Appendix A.  For the purpose of this sceneraio, include sales tax in total lump sum bid amount.","Lump Sum Bid",1,null,null,0]
[]
["APPENDIX B"]
[11,"Replacement of bad VFD on Cooling Tower. Lump Sum Bid shall include all work described within the specifications provided in Appendix B.                  For the purpose of this sceneraio, include sales tax in total lump sum bid amount.","Lump Sum Bid",1,null,null,0]
[]
["APPENDIX C"]
[12,"Changeover from existing Siemens Apogee to Siemens Apogee Desigo system. Lump Sum Bid shall include all work described within the specifications provided in Appendix C.                           For the purpose of this sceneraio, include sales tax in total lump sum bid amount.","Lump Sum Bid",1,null,null,0]
[]
[{"$nulls":4},"Mark-up % "]
[13,"Mark-up Percent on actual cost for third-party material and components","% Percentage",{"v":10000,"d":"$10,000"},null,null,{"$f":"IF(E39>0,(D39*(1+E39)),(D39-(D39*F39)))","v":{"v":10000,"d":"$10,000.00"}}]
[]
[{"$nulls":4},"Discount %"]
[14,"Discount Percent/multiplier on manufacturer's equipment/material and components","% Percentage",{"v":200000,"d":"$200,000"},null,null,{"$f":"IF(E42>0,(D42*(1-E42)),(D42-(D42*F42)))","v":{"v":200000,"d":"$200,000.00"}}]
[null," ","GRAND TOTAL:",null,null," ",{"$f":"SUM(G10:G42)","v":{"v":210000,"d":"$210,000.00"}}]