{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SOW Checklist","Sheet1"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"SOW Checklist","index":0,"n_rows":120,"n_cols":7,"rows_kept":120,"cut":false,"hidden":false,"merged":[[45,1,45,7],[67,1,67,7],[18,4,18,7],[18,0,18,2],[19,0,20,2],[19,3,20,7],[28,6,28,7],[26,1,26,5],[27,1,27,5],[28,1,28,5],[23,6,23,7],[23,1,23,5],[24,6,24,7],[24,1,24,5],[25,6,25,7],[25,1,25,5],[47,1,47,5],[61,1,61,7],[66,1,66,7],[63,1,63,7],[70,1,70,7],[117,1,117,7],[118,1,118,7],[119,1,119,7],[108,1,108,7],[109,1,109,7],[101,1,101,7],[33,1,33,5],[34,6,34,7],[34,1,34,5],[56,0,56,7],[51,6,51,7],[57,1,57,7],[58,1,58,7],[59,1,59,7],[62,1,62,7],[64,1,64,7],[65,1,65,7],[52,1,52,5],[52,6,52,7],[53,1,53,7],[38,1,38,5],[39,1,39,5],[37,6,37,7],[0,0,0,7],[6,0,6,7],[32,0,32,6],[36,0,36,6],[43,0,43,6],[7,0,7,2],[8,0,8,2],[17,0,17,2],[7,3,7,7],[8,3,8,7],[17,3,17,7],[9,0,13,2],[4,2,4,7],[37,1,37,5],[40,1,40,5],[41,1,41,7],[33,6,33,7],[29,6,29,7],[29,1,29,5],[30,1,30,7],[26,6,26,7],[27,6,27,7],[115,1,115,7],[48,1,48,5],[49,1,49,5],[50,1,50,5],[48,6,48,7],[49,6,49,7],[50,6,50,7],[51,1,51,5],[71,1,71,7],[82,2,82,7],[83,2,83,7],[84,2,84,7],[85,2,85,7],[89,1,89,7],[75,1,75,7],[76,1,76,7],[74,1,74,7],[60,1,60,7],[80,0,80,7],[72,1,72,7],[93,1,93,7],[96,1,96,7],[98,1,98,7],[110,1,110,7],[111,1,111,7],[114,1,114,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[46,1,46,7],[44,1,44,7],[100,1,100,7],[107,1,107,7],[97,1,97,7],[106,1,106,7],[102,1,102,7],[105,1,105,7],[103,1,103,7],[86,1,86,7],[95,0,95,6],[87,1,87,7],[68,1,68,7],[90,1,90,7],[91,1,91,7],[73,1,73,7],[69,1,69,7],[78,1,78,7],[99,1,99,7],[116,1,116,7],[2,1,2,3],[4,0,4,1],[2,4,2,5],[2,6,2,7],[22,0,22,7],[14,0,14,2],[15,0,15,2],[16,0,16,2],[9,3,13,7],[21,0,21,7],[55,0,55,7],[54,0,54,7],[77,1,77,7],[104,1,104,7],[88,1,88,7],[81,1,81,7],[14,3,14,7],[15,3,15,7],[16,3,16,7],[92,1,92,7],[47,6,47,7],[113,0,113,7],[76,0,77,0]]}
["SOW Checklist"]
[]
["SPI #:",null,null,null,"Date Entered in STCM:"]
[]
["Site Manager:"]
[]
[" FACILITY INFORMATION"]
["Facility ID Number:\n(9 digit)"]
["Facility Name: "]
["Discharge/Program(s):\n(That this PO will be under)"]
[]
[]
[]
[]
["Funding Cap (Y/N):"]
["Deductible Paid (Y/N):"]
["Cost Share Agreement (Y/N): "]
["Current Real Property Owner or Responsible Party:\n(Check Property Appraiser)"]
["Assignment Type:",null,null,null,{"$f":"IF(D19=\"\",\"\",\"(\"&VLOOKUP(D19,Sheet1!A2:B9,2,FALSE)&\")\")","v":""}]
["ATC Name & CID#:\n(If Assignment Type not CSF)",null,null,{"$f":"IF(D19=\"\", \"\", IF(D19=\"CSF\",\"NA\",\"\"))","v":""}]
[]
[" \nFILE REVIEW:"]
[" SITE ACCESS AGREEMENT (SAA)"]
[null,"Is there a fully executed SAA in Oculus?\nIt should be located under “Administrative” as a stand-alone document."]
[null,"Does facility address on SAA match the address in STCM?\n Verify  the address match,  if not,  email tankregistration@floridadep.gov to update the address in STCM."]
[null,"Is the SAA with the current Property Owner?\nAny executed version between current Owner and the Department is acceptable. Ifneeded new site access, email Grace Rivera with facility ID #."]
[null,"Does the current Property Owner want to provide input in the rehabilitation of the site?"]
[null,"Does the current Property Owner want to retain the right to reject one ATC contractor?"]
[null,"Does the current Property Owner want a separate agreement with the contractor?"]
[null,"Are there any additional owner requirements (such as “Attachment B”)?\nWhat are the requirements?"]
[]
[]
[" DEDUCTIBLES"]
[null,"Has the deductible been paid? \nCheck STCM to verify. (STCM → Discharge → Facility → Cap deductible)"]
[null,"Is deductible required to be paid before PO issued?\nIf LSA , SCS, or LSSI, deductible payment not required during assessment phase."]
[]
[" FUNDING CAPS"]
[null,"What is the cap amount?\nCheck STCM to verify. (STCM → Discharge → Facility → Cap deductible)"]
[null,"What has been spent to date?\nCheck “Cap to Date” report (avalible on FDEP website)."]
[null,"How much cap remaining?",null,null,null,null,{"$f":"IF(OR(ISBLANK(G38),ISBLANK(G39)),\"\",G38-G39)","v":""}]
[null,"If encumbered amount (including new PO) is close to the cap amount, is a Funding Cap Transition  agreement needed? Explain."]
[]
[]
[" COST SHARE AGREEMENTS (PCPP, SRFA & AC)/CONSENT ORDERS Tracking (Bobby Scarborough) - PCPP Coordinator (Grace Rivera), SRFA Coordinator (Bill Newmeyer) & AC Coordinator (Grant Willis)"]
[null,"Verify that all pages of executed Cost Share Agreement are in Oculus (with all signatures)."]
[null,"Verify Agreement is with the current owner/responsible party (RP).\n If ownership changes at ANYTIME (even in the middle of a PO), a new Agreement may be needed, please contact the PCPP, SRFA & AC coordinator, or Bobby Scarborough (if cleanup is under Consent Order). If agreement with new owner is needed. "]
[null,"Verify that the expiration date, if any, has not passed.\nIf expired, a new Agreement will be needed."]
[null,"How many amendments are there?\nVerify all pages of the Amendment(s) are in Oculus. "]
[null,"Does the facility address on Cost Share Agreement match STCM? \nVerify  old address in STCM, if not, contact coordinator to verify if the adress is correct (send the most recent SAA with request)."]
[null,"Is a valid Cost Share Contractor Selection Sheet in Oculus?\n(Not applicable if the property owner/RP pays less than a 25% copayment of costs or  not paying at all.)"]
[null,"What is the owner/RP cost share percentage in the Agreement?\n(Sometimes cost share amount can be 25% or 0%  for PCPP if owner indigent.)"]
[null,"If Consent Order, must Owner/RP pay fees before work starts?\nVerify requirements of the Order in Oculus. If you any questions, please contact Bobby Scarborough"]
[null,"Are there any other “TERMS & CONDITIONS” in the Agreement? Explain."]
[]
[]
["SOW CREATION:"]
[" VERIFY SOW, SPI, TABLES, FIGURES & TECHNICAL APPROACH IS APPROPRIATE"]
[null,"Download a new SOW workbook from the website every time."]
[null,"Facility ID & Name on SOW must match STCM exactly. If not,  please email tankregistration@floridadep.gov to update the address."]
[null,"Sub phase listed in the SOW must match the sub phase listed in the name of the workbook exactly.\n(Ex: \"LSA\" selected in dropdown in the SOW, so the workbook must be named \"Attachment A - Scope of Work - LSA - FACID\")"]
[null,"Ensure sub phase is correct (table for sub phase is located in the ATC Contract)."]
[null,"Ensure that applicable Tables are checked on first tab of SOW workbook."]
[null," Use Action verbs at the beginning of each task description."]
[null,"If applicable, verify pre-drilling/direct push technology meeting included in the SOW/SPI"]
[null,"Refer to all applicable figures in the corresponding task descriptions."]
[null,"Verify all figures have the correct Facility ID written somewhere."]
[null,"Any previous reports referenced in task descriptions must include the date received and the date approved (RAPs, PTs, etc)."]
[null,"If the owner requested a separate SAA with the contractor, include the following statement in task description. No additional costs are associated with this request.\n\"Please note that per the DEP site access agreement, a separate site access agreement between the owner and the ATC has been requested by the property owner or tenant. Submit an email or letter (copying the owner or tenant) indicating either that this separate site access agreement has been executed or that the owner no longer wants such an agreement with the contractor (the owner is content with the current DEP site access agreement). The DEP does not need a copy of this agreement.\""]
[null,"If Interim Assessment or if RA Interim Reports are included as a deliverable on the SOW, a list of items to be submitted for invoicing must be included (field notes, lab reports, GW sampling logs, boring logs, etc)."]
[null,"If an updated HASP is needed, then SOW task description must include “Updated” and the $0.00 SPI line item must be used."]
[null,"Verify that report names in the SOW task deliverable sections exactly match the SPI buildup and the STCM SPI names (Level 1 LSRAP, etc.)."]
[null,"Verify the units in the SOW tables match the units in the SPI buildup document. Verify each task description has corresponding pay items in the SPI."]
[null,"If direct assign, verify the SOW/SPI includes lab costs for disposal (if necessary)."]
[null,"Verify one (1) Encore sampler for each possible BTEX/MTBE SPLP Extraction for each SPLP collected."]
[null,"Verify SPI line item 19-17 (Construction Drawings & Specs Report) is included if doing a RAP."]
[null,"Do not include line item 19-18 (As-Built Drawings) if a Startup Report is being submitted (already included)."]
[null,"Verify SPI line item 8-11 (EDD) is included for each sampling event/mobilization. Do not give multiple units for multi-day sampling events. Can allow a separate unit for 24hr TAT samples. Not needed for backfill sampling"]
[null,"Examples: (1) unit allowed if sampling existing wells and doing soil samples in the same task. (2) units allowed if installing wells with soil samples and then sampling GW a week later."]
[null,"If using Contingent Funding, include the following language in the final task of the SOW.\n\"Contingent Funding in this task is only to be used to offset the cost for pay items associated with a Field request for Change for any open task.\""]
[]
[" SPI IN STCM"]
[null,"Verify that the SPI Description Field includes the following... "]
[null,null,"If Direct Assign, state the name and CID# of the Contractor."]
[null,null,"State the execution date and any additional requrements included in the SAA in Oculus.\n(Example: \"SAA dated 7/31/16 is in Oculus; Additional requirements are […]\")"]
[null,null,"If applicable, include the date of Cost Share Agreement (PCPP, SRFA& AC) located in Oculus.\n(Example: \"PCPP Agreement executed 7/31/16 is in Oculus.\")"]
[null,null,"Indicate if the Owner wishes to provide input on site rehabilitation and/or retain right to reject a contractor.\n(Example: \"Per SAA, Owner does not wish to provide input nor retain right to reject one contractor.\")"]
[null,"Verify cost share amounts are correct."]
[null,"Verify RCI Exclusion box is checked if Owner selected a contractor.\n(If cost share ≥ 25%, PAC/AC, LSSI, PBC, etc.)"]
[null,"Verify SPI is linked to the correct discharge(s)."]
[null,"Verify line items in STCM SPI match draft SPI that was previously reviewed/approved."]
[null,"Do not mark STCM SPI line item 1-7 in STCM. It will automatically populate when the SPI is downloaded to excel."]
[null,"Verify the average cost in STCM. If amount is close to or over $325K, then you may put a note in the STCM SPI Description box indicating that ATC will negotiate cost to direct assign or go with an eQuote. "]
[null,"If the contractor does modify their rates, an email with the specific items to be modified must be sent via email with the SOW to PRP site manager."]
[null,"Verify the correct contingent amount is applied to SPI in Section 23-1 based on scope phase (i.e., $1,000 or $7,000)."]
[]
["REVIEW THE QUOTES (If direct assign,quotes maybe provided prior to scope offer; If CSF, qutoes are provided after scope offer)"]
[null,"Verify all quotes are dated."]
[null,"Verify expiration dates, if any, on all quotes to ensure they will not expire before the PO is issued."]
[null,"Verify there are (3) responsive quotes for items >$2,500."]
[null,"Verify all pages to each quote are included."]
[null,"Verify that site manager was copied on request to subcontractors for quotes."]
[null,"Verify the quote is for the assigned ATC and correct facility ID # and site address."]
[null,"Verify quotes are on subcontractor letterhead or email. "]
[null,"Email quotes are acceptable if they are directly from the vendor (and not from the consultant speaking for the vendor). The consultant can attach or forward an email from the vendor."]
[null,"Make sure the confidential clause is removed from quotes and emails."]
[null,"Verify a breakdown of items is provided and quotes are for the same work (comparing “apples to apples”).\nIf needed, you may handwrite notes to clarify that the quotes are acceptable and are for the same items."]
[null,"Verify quotes contain enough detail to complete the work (materials, size, volume, etc)."]
[null,"If the quote is an in-house quote, there must also be either one additional subcontractor quote (if amount <$2,500) OR two additional subcontractor quotes (if amount >$2,500)."]
[null,"Verify quotes appear to be reasonable. You can request additional quotes if it does not appear to be reasonable to you (even if cost is <$2,500)."]
[null,"Read the Terms & Conditions section (usually includes expiration date)."]
[null,"Verify no insurance is included on all quotes."]
[null,"Verify tax is included on all quotes if applicable."]
[]
[" EMAILING SOW"]
[null,"When the SOW and tables are finalized, use the “Hide Rows” buttons and save the workbook with the appropriate name. "]
[null,"Attach the SOW in Excel format."]
[null,"Attach Cost Share Agreement and Amendments, if applicable.\n(E.g. SRFA, PCPP, PAC/AC)"]
[null,"Attach Figure(s) in pdf format, verify  Facility ID # or figures /maps."]
[null,"Attach Executed Site Access Agreement (SAA)"]
[null,"Any additional specifications or attachments for the SOW."]

{"sheet":"Sheet1","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["ID","Description","CSF"]
["BUNDL","Advanced Cleanup PBC Bundle","No"]
["COND","Conditional Closure Agreement Executed","No"]
["CSF","Contractor Selection Formula","Yes"]
["QUOT2","Equote for > $325K","No"]
["REPLA","Replacement","No"]
["SCOPE","Direct Assign for Continuing Scope","No"]
["SECUR","Homeland or Transportation Security","No"]
["SHARE","Direct Assign For Cost Share Of 25% Or More","No"]