{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Exhibit D-Proposal Form"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Exhibit D-Proposal Form","index":0,"n_rows":71,"n_cols":14,"rows_kept":71,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[10,5,10,9],[21,5,21,9],[29,5,29,9],[36,5,36,9],[40,5,40,9],[46,5,46,9],[50,5,50,9],[52,0,52,5],[53,0,53,5],[55,0,55,5],[57,0,57,5],[59,0,59,5],[60,0,60,5],[61,0,61,5],[62,0,62,5],[62,6,62,9],[63,0,63,5],[64,0,64,5],[64,6,64,9],[65,0,65,5],[65,6,65,9],[66,0,66,5],[66,6,66,9],[67,0,67,5],[68,0,68,5],[69,0,69,5],[70,0,70,5]]}
["Exhibit D"]
["Engineer Proposal Form"]
["Stormwater System Improvements Project #4015"]
["EDA Grant #04-79-07494"]
[]
["No. ","TASKS","QTY.",null,"UNIT PRICE","UNIT ","FEE",null,null,"FEE"]
[1,"PRE-DESIGN "]
[1.1,"Conduct kickoff meeting with Owner ",1,"x",null,"LS",{"$f":"C8*E8","v":0},null,"=",{"$f":"IF(E8=0,\"  \",G8)","v":"  "}]
[1.2,"Survey for drainage easements and documentation ",1,"x",null,"LS",{"$f":"C9*E9","v":0},null,"=",{"$f":"IF(E9=0,\"  \",G9)","v":"  "}]
[1.3,"Complete EDA Site Certificate ",1,"x",null,"LS",0,null,"=","  "]
[null,"PRE-DESIGN SUBOTAL ",{"$nulls":3},{"$f":"SUM(J8:J10)","v":0}]
[2,"DESIGN "]
[2.1,"Project management, site visits, and design progress meetings.  Not-to-exceed 12 months.",1,"x",null,"LS",{"$f":"C13*E13","v":0},null,"=",{"$f":"IF(E13=0,\"  \",G13)","v":"  "}]
[2.2,"Coordinate, review and supervise geotechnical subsurface investigations",1,"x",null,"LS",0,null,"=","  "]
[2.3,"Site topographic and utility survey",1,"x",null,"LS",0,null,"=","  "]
[2.4,"Preliminary plans and specifications -30%",1,"x",null,"LS",0,null,"=","  "]
[2.5,"Preliminary plans and specifications -60%",1,"x",null,"LS",0,null,"=","  "]
[2.6,"Advanced plans and specificatons-90%",1,"x",null,"LS",0,null,"=","  "]
[2.7,"Perform QA/QC for final plans and specifications-100%",1,"x",null,"LS",0,null,"=","  "]
[2.8,"Prepare cost estimates for 60% and 100% plans.",1,"x",null,"LS",0,null,"=","  "]
[2.9,"Permits: SCDOT, SCDHEC, OCRM",1,"x",null,"LS",0,null,"=","  "]
[null,"DESIGN SUBTOTAL ",{"$nulls":3},{"$f":"SUM(J13:J21)","v":0}]
[3,"BIDDING & AWARD ",{"$nulls":8},12,"weeks",3,"months"]
[3.1,"Assist Owner in advertisement of construction bid",1,"x",null,"LS",{"$f":"C24*E24","v":0},null,"=",{"$f":"IF(E24=0,\"  \",G24)","v":"  "}]
[3.2,"Conduct one (1) pre-bid meeting",4,"x",null,"Hrs.",0,null,"=","  "]
[3.3,"Respond to bidder's RFIs and prepare any necessary Addenda ",1,"x",null,"LS",0,null,"=","  "]
[3.4,"Conduct one (1) bid opening meeting",4,"x",null,"Hrs.",0,null,"=","  "]
[3.5,"Review bids received, prepare and certify bid tabulation. Write recommendation of award letter.",1,"x",null,"LS",0,null,"=","  "]
[3.6,"Conduct one (1) pre-construction meeting ",4,"x",null,"Hrs.",0,null,"=","  "]
[null,"BIDDING & AWARD SUBTOTAL ",{"$nulls":3},{"$f":"SUM(J24:J29)","v":0}]
[4,"CONSTRUCTION ADMINISTRATION "]
[4.1,"Review submittals and RFIs",1,"x",null,"LS",{"$f":"C32*E32","v":0},null,"=",{"$f":"IF(E32=0,\"  \",G32)","v":"  "}]
[4.2,"Review Contractor Pay Applications ",1,"x",null,"LS",0,null,"=","  "]
[4.3,"Review Change Orders",1,"x",null,"LS",0,null,"=","  "]
[4.4,"Review Contractor Schedules, Monitor and Report Progress",1,"x",null,"LS",0,null,"=","  "]
[4.5,"Conduct Monthly Progress Meetings. Site visits, Write Agenda and Minutes. Not-to-exceed 24 months.   ",150,"x",null,"Hrs.",0,null,"=","  "]
[null,"CONSTRUCTION ADMINISTRATION SUBTOTAL ",{"$nulls":3},{"$f":"SUM(J32:J36)","v":0}]
[5,"CONSTRUCTION INSPECTIONS"]
[5.1,"Perform onsite material testing for soil compaction, concrete, and asphalt. ",1,"x",null,"LS",{"$f":"C39*E39","v":0},null,"=",{"$f":"IF(E39=0,\"  \",G39)","v":"  "}]
[5.2,"Conduct regular bi-weekly onsite inspections and submit weekly reports.  Not-to-exceed 24 months.",1500,"x",null,"Hrs.",0,null,"=","  "]
[null,"CONSTRUCTION INSPECTIONS SUBTOTAL ",{"$nulls":3},{"$f":"SUM(J39:J40)","v":0}]
[6,"CLOSEOUT ",{"$nulls":10},3,"months "]
[6.1,"Conduct preliminary and final punch list onsite inspections ",32,"x",null,"Hrs.",{"$f":"C43*E43","v":0},null,"=",{"$f":"IF(E43=0,\"  \",G43)","v":"  "}]
[6.2,"Prepare closeout documentation. ",1,"x",null,"LS",0,null,"=","  "]
[6.3,"Review contractor as-builts plans and certify.",1,"x",null,"LS",0,null,"=","  "]
[6.4,"Provide AutoCAD and PDF record drawings to Owner",1,"x",null,"LS",0,null,"=","  "]
[null,"CLOSEOUT SUBTOTAL ",{"$nulls":3},{"$f":"SUM(J43:J46)","v":0}]
[{"$nulls":9},{"$f":"IF(E48=0,\"  \",G48)","v":"  "}]
[7,"REIMBURSABLES (Mileage and document production only) ",1,"x",null,"LS",{"$f":"C49*E49","v":0},null,"=","  "]
[]
[null,"TOTAL FEE",{"$nulls":3},{"$f":"SUM(F11,F22,F30,F37,F41,F47,J49)","v":0}]
[]
[]
["The undersigned declares that his/her firm is (use as applicable): "]
[]
["A corporation organized and existing under the laws of the State of ___________________________________"]
[]
["A partnership consisting of: __________________________________________"]
[]
["An individual or sole proprietor: ______________________________________"]
["The undersigned declares that the person signing this proposal is fully authorized to sign the proposal on behalf of the firm listed and to fully bind the firm listed to all the conditions and provisions thereof."]
["It is agreed that no person or persons or company other than the firm listed below or as otherwise indicated hereinafter has any interest whatsoever in this proposal or the contract that may be entered into as a result thereof, and that in all respects the proposal is legal and fair, submitted in good faith, without collusion or fraud."]
["Respectfully Submitted By:"]
[]
["(Type/Print Name)"]
["(Title)"]
["Date:"]
["Street:"]
["City, State, Zip Code:"]
["Telephone:"]
["Email:"]