Exhibit_A-_WIN_Requirement.pdf
PDF 266 KB Posted
- Attached to
- Analytical Lab Services
- Solicitation number
- IFB23-0336
- Issued by
- Orange County, Orlando City, Florida
About this file
This document is an Exhibit A detailing WIN (Watershed Information Network) Requirement Fields for the City of Orlando's Analytical Lab Services procurement. The exhibit specifies technical requirements for surface water sample reporting, mandating that contractors generate reports in both PDF and Excel formats, strictly adhering to the Florida Department of Environmental Protection's (FDEP) Watershed Information Network data standards. Contractors must provide comprehensive sample information, including analysis and activity details, with the Excel files to be used by the City's third-party consultant for uploading data into the WIN data management platform.
The document emphasizes the contractor's responsibility to meet precise technical specifications, including generating Excel files that exactly match the format outlined in multiple referenced links and guidelines. Contractors must certify their capability to produce reports meeting these exact specifications by submitting their bid package. The exhibit includes multiple web links to detailed technical resources, such as WIN standard values, data merge tools, and approved methods. Additionally, the document stipulates that contractors must promptly correct any work rejected by the City, bearing all costs associated with such corrections, which underscores the stringent quality expectations for this analytical lab services contract.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Procurement and Contracts Division Page: 1
EXHIBIT“A”
WIN REQUIREMENT FIELDS
Reports being generated for surface water samples may need to be delivered in both pdf format and in Excel. The Excel file shall follow all Florida Department of Environmental Protection (FDEP)’s Watershed Information Network (WIN) data requirements (see links below), or its successors. The format shall include identical script listed in the various links or script provided from City of Orlando and/or FDEP staff. The City has established stations and metadata for routine sample sites; the Contractor’s Work shall provide all required information for each sample, including analysis and activity details. Once the Excel file is delivered, the City will utilize our third-party consultant for uploading/importing data into the WIN data management platform.
https://prodenv.dep.state.fl.us/DearWin/public/welcomeGeneralPublic?calledBy=GENERALPUBLIC Reports & Extracts [tab] > WIN Standard Values [within dropdown] http://publicfiles.dep.state.fl.us/DEAR/WIN/FAQs/WIN_FAQs.pdf http://publicfiles.dep.state.fl.us/DEAR/WIN/Deliverables/WIN_MIGRATED.pdf http://publicfiles.dep.state.fl.us/DEAR/WIN/Data_Merge_Tool/ mdqs_advanced_rule_codes_DMT_LAB_Consult.xlsx http://publicfiles.dep.state.fl.us/DEAR/WIN/Data_Merge_Tool/WQAP_DMT-
WIN_Help_Guide_v2.0_FINAL_11-1-2022.pdf http://publicfiles.dep.state.fl.us/DEAR/WIN/Example_Files/WIN_Example_Files.xlsx http://publicfiles.dep.state.fl.us/DEAR/WIN/MDQS/4_Activity_Result_WIN_Standards.xlsx http://publicfiles.dep.state.fl.us/DEAR/WIN/MDQS/Approved_Methods/
Upon request, the Contractor shall promptly correct all Work rejected by the City as faulty, defective, or failing to conform to the contract whether observed before or after substantial completion of the Work, and whether or not fabricated, installed or completed. The Contractor shall bear all costs of correcting such rejected Work.
By submission of the bid package, the Contractor is confirming that appropriate personnel have read all of the attached links and is certifying the Contractor is fully capable of generating an Excel file in the exact format provided within the links, or its successors.
https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fprodenv.dep.state.fl.us%2FDearWin%2Fpublic%2FwelcomeGeneralPublic%3FcalledBy%3DGENERALPUBLIC&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=DEAuR2wZlx54O2khdJex9a4XSPYFkLBNqsPi4kEScfw%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FFAQs%2FWIN_FAQs.pdf&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=drJAjrCXu3j7pYHP9Xf1sTbISqJpFr%2BGLdARPIafa%2Fo%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FDeliverables%2FWIN_MIGRATED.pdf&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uwSKXlgfJBQ9toNHMUqkZj4LuaBCGG6HT%2Bwmw%2Brq7DA%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FData_Merge_Tool%2F&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2FNC5apT14MAn8fWkkBTG5cZYrKsc9QBoH7kiU4WcIqs%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FData_Merge_Tool%2FWQAP_DMT-WIN_Help_Guide_v2.0_FINAL_11-1-2022.pdf&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=RzIKGqpMc0Y3FFeGW1GHkZDd6nNiSm3QZwtMX6esBKs%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FData_Merge_Tool%2FWQAP_DMT-WIN_Help_Guide_v2.0_FINAL_11-1-2022.pdf&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=RzIKGqpMc0Y3FFeGW1GHkZDd6nNiSm3QZwtMX6esBKs%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FExample_Files%2FWIN_Example_Files.xlsx&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=iXQHwPk8ud7pEfpDkAJp0VibkBLM8uzRuMvjEPAp0NM%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FMDQS%2F4_Activity_Result_WIN_Standards.xlsx&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=YfgvcU%2BS3CACitq%2BQiBcF6IKfBIzXcWrkmi9StxYQKg%3D&reserved=0 https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpublicfiles.dep.state.fl.us%2FDEAR%2FWIN%2FMDQS%2FApproved_Methods%2F&data=05%7C01%7Cvarun.desai%40orlando.gov%7C3170eb02d16f4b74588508db44b046b6%7C7594da9b294b4acf913bd159ae921564%7C0%7C0%7C638179296145274854%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ekEXJ5FL4GowlbfGCAhhfROSeYG9NqgQ%2BNRjKhkQVXQ%3D&reserved=0
File details come from the government source that posted it. Updated .