{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["25% cost-savings rate reduction","25% cost-savings RMO II","25% copayment","25% combination","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"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":"25% cost-savings rate reduction","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,2],[8,0,8,2],[0,0,0,2],[5,1,5,2],[4,1,4,2],[3,1,3,2],[2,1,2,2],[6,1,6,2],[22,0,22,2]]}
["PCPP Scope of Work (SOW) and Cost Estimate for 25% Cost Savings via Rate Reduction"]
[]
["Facility Name"]
["Facility Address"]
["FDEP Facility #"]
["PCPP Eligibility Discharge Date(s)"]
["Priority Score"]
[]
["Based on the results of the __________________________  report submitted by ___________________________, the scope of work and estimated cost to complete cleanup is described below:"]
[]
["SOW/Phase",null,"Estimated Cost"]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["Well Abandonment/Site Restoration",null,0]
[null,"Subtotal",{"$f":"C17+C16+C15+C14+C13+C12","v":0}]
[]
["25% cost savings in the form of reduced rates",null,{"$f":"0.25*C18","v":0}]
[]
["FDEP Estimated total cost to closure",null,{"$f":"C18-C20","v":0}]
["Any cost above the discharge(s) funding cap (and auxiliary funding, if applicable) will be the responsibility of the responsible party/owner"]
["Estimated timetable and endpoint"]
[]
[]
["Scope and Estimate provided by",null,"Date"]
[]
[]
["Company Name"]
[]
["Once the form is complete, please click print to PDF and include with PCPP Agreement as backup documentation   Cost Estimate Form template 2/15/24. "]

{"sheet":"25% cost-savings RMO II","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,0,8,2],[22,0,22,2],[31,0,31,2],[0,0,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
["PCPP Scope of Work (SOW) and Cost Estimate for 25% Cost Savings via RMO II"]
[]
["Facility Name"]
["Facility Address"]
["FDEP Facility #"]
["PCPP Eligibility Discharge Date(s)"]
["Priority Score"]
[]
["Based on the results of the __________________________  report submitted by ___________________________, the scope of work and estimated cost to complete cleanup is described below:"]
[]
["SOW/Phase","Estimated Cost for RMO I","Estimated Cost for RMO II"]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
[null,0,0]
["Well Abandonment/Site Restoration",0,0]
["subtotal ",{"$f":"B12+B13+B14+B15+B16+B17","v":0},{"$f":"C17+C16+C15+C14+C13+C12","v":0}]
[]
["Percentage savings of RMO II (minimum of 25% required)",null,{"$f":"(B18-C18)/B18","v":{"$error":"#DIV/0!"}}]
[]
["FDEP Estimated total cost to closure",null,{"$f":"C18","v":0}]
["Any cost above the discharge(s) funding cap (and auxiliary funding, if applicable) will be the responsibility of the responsible party/owner"]
["Estimated timetable and endpoint"]
[]
[]
["Scope and Estimate provided by",null,"Date"]
[]
[]
["Company Name"]
[]
["Once the form is complete, please click print to PDF and include with PCPP Agreement as backup documentation   Cost Estimate Form template 2/15/24. "]

{"sheet":"25% copayment","index":2,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,0,8,2],[31,0,31,2],[0,0,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[22,0,22,2]]}
["PCPP Scope of Work (SOW) and Cost Estimate for 25% Copayment (cost share)"]
[]
["Facility Name"]
["Facility Address"]
["FDEP Facility #"]
["PCPP Eligibility Discharge Date(s)"]
["Priority Score"]
[]
["Based on the results of the __________________________  report submitted by ___________________________, the scope of work and estimated cost to complete cleanup is described below:"]
[]
["SOW/Phase",null,"Estimated Cost"]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
["Well Abandonment/Site Restoration",null,0]
[null,"Subtotal",{"$f":"C17+C16+C15+C14+C13+C12","v":0}]
[]
["Owner/RP 25% copayment",null,{"$f":"0.25*C18","v":0}]
[]
["FDEP Estimated total cost to closure",null,{"$f":"C18-C20","v":0}]
["Any cost above the discharge(s) funding cap (and auxiliary funding, if applicable) will be the responsibility of the responsible party/owner"]
["Estimated timetable and endpoint"]
[]
[]
["Scope and Estimate provided by",null,"Date"]
[]
[]
[]
[]
["Once the form is complete, please click print to PDF and include with PCPP Agreement as backup documentation   Cost Estimate Form template 2/15/24. "]

{"sheet":"25% combination","index":3,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[24,1,24,2],[8,0,8,5],[0,0,0,5],[5,1,5,4],[4,1,4,4],[3,1,3,4],[2,1,2,4],[6,1,6,4],[23,0,23,4]]}
["PCPP Scope of Work (SOW) and Cost Estimate for 25% Combination Cost Savings and Copayment"]
[]
["Facility Name"]
["Facility Address"]
["FDEP Facility #"]
["PCPP Eligibility Discharge Date(s)"]
["Priority Score"]
[]
["Based on the results of the _____________________________________________  report submitted by _________________________________ the scope of work and estimated cost to complete cleanup is described below:"]
[]
["Phase",null,null,"Estimated Cost"]
[]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Well Abandonment/Site Restoration",null,null,0]
[null,null,"Subtotal",{"$f":"D17+D16+D15+D14+D13+D12","v":0}]
[]
["ATC reduced rate percentage",null,null,{"$f":"D18*B20","v":0}]
["Participant co-pay percentage",null,null,{"$f":"(D18-D20)*B21","v":0}]
[]
["FDEP Estimated total cost to closure",null,null,{"$f":"D18-(D20+D21)","v":0}]
["Any cost above the discharge(s) funding cap (and auxiliary funding, if applicable) will be the responsibility of the responsible party/owner"]
["Estimated timetable and endpoint"]
[]
[]
[]
["Scope and Estimate provided by",null,null,"Date"]
[]
[]
["Company Name"]
[]
[]
["Participant Name"]
[]
["Once the form is complete, please click print to PDF and include with PCPP Agreement as backup documentation"]
["   Cost Estimate Form template 2/15/24. "]

{"sheet":"Instructions","index":4,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"GENERAL INSTRUCTIONS FOR SCOPE AND COST ESTIMATE FORMS"]
[]
[null,"As part of the Florida Department of Environmental Protection (FDEP) Petroleum Restoration Program (PRP) Petroleum Cleanup Participation Program (PCPP), back up documents of a scope and cost estimate to closure for each PCPP discharge are required. This workbook is provided to help demonstrate to the PRP the statutorily required 25% obligation is being met (whether via 25% cost savings [Agency Term Contractor (ATC) rate reduction or conditional closure RMO II], copayment, or combination). Genreal instructions for completing the tabs is outlined below."]
[]
[null,"There are four (4) tabs: 25% cost-savings via rate reduction, 25% cost-savings via RMO II, 25% copayment, and 25% combination. Whatever selection the owner/responsible party (RP) is opting for in the PCPP Agreement is the only tab that should be completed. Each form (labeled at the tab to indicate the 25% obligation being utilized) has cells that are locked for protection and cannot be altered, along with cells that are unlocked to input data."]
[]
[null,"1) Start by completing the facility information with the correct facility name, address, FDEP Facility ID, discharge date(s), and priority score."]
[]
[null,"2) Then, enter the report title and date that the scope and cost estimate is based from. This report and date MUST match the information entered on the PCPP Agreement."]
[]
[null,"3) Next, enter the phases of work or scope; the tabs already include well abandonment and site restoration as a phase, as the cost must be estimated all the way through closure. Next to each phase, enter the dollar amount estimated to complete that scope. The form will calculate the subtotal (total cost of all the phases entered)."]
[null,"The 25% cost savings via ATC rate reduction and the 25% copayment tabs automatically calculate and display the 25% costs directly below the subtotal."]
[null,"The 25% cost savings via RMO II compares a scope of work for RMO I versus RMO II and displays the cost savings as a percentage. The total cost of RMO II is also displayed as FDEP costs."]
[null,"The 25% combination tab requires the preparer to enter the cost savings and copayment split (the split MUST equal 25%). The percentages may be in halfs/quarters/etc (example: 12.25%)."]
[null,"Beneath that, the FDEP share (cost to closure) will automatically be calculated and displayed."]
[]
[null,"4) The form then requires the preparer to complete the closure endpoint and estimated timetable to closure (RMO I/RMO II etc, and years to complete)."]
[]
[null,"5) Finally, the preparer will enter their name, company (if aplicable) and the owner/RP name (if applicable), and date the form was completed."]
[]
[null,"6)Once the form has been reviewed for completeness, select the \"PRINT to PDF\" button to generate  in pdf format for submission with the other backup documents. (See PCPP Agreement Instructions for backup document requirements)."]