NAME: University of Hartford College of Engineering, Technology, and Architecture Department of Civil, Environmental & Biomedical Engineering CE 591 - Applied Wastewater Treatment Spring Semester 2024 1. (75 pts) You recently graduated and began working for a general contractor. Your company is bidding on the construction of the Southington Plant upgrade. The estimating department asks for your help in preparing their bid. They want you to complete a spreadsheet “take-off” of all the pumping, piping and equipment (valves, gates, meters, instruments, drives, etc.) associated with the Nitrification Settling Gallery. Also include safety instrumentation. Do not include HVAC equipment, seal water piping or coagulant piping. Submit a spreadsheet with your quantity take-off. Most of the information you need is found on drawings M-403, PI-402, E-403 and in the technical specifications. Include quantities, sizes and types of fittings (T's, elbows, couplings), valves, pumps, flow meters, instruments, drives, etc. I have provided a blank spreadsheet for you to complete. You complete columns B-F; I have added notes to the headings of these columns to help you understand what I'm looking for. You may need to add rows under some of the item types. You may attach data sheets/schedules from the specifications with the specific equipment for this area highlighted. If you have any questions, please ask in class or send me an email. 2. (25 pts) Please write a 1-2 page reflection of what you learned in this course that you think might benefit you in the future. Try to be specific and provide examples. 1