{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","RFI 2017035C - Trucks","Definitions","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":65,"n_cols":3,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,null,"Click here to fill out the RFI response template."]
[]
[null,null,"RFI 2017035C, Volkswagen Mitigation Trust Fund Potential Mitigation Actions - Medium and Heavy Duty Trucks"]
[]
[null,null,"Background"]
[null,null,"On October 25, 2016, the United States entered into a Partial Consent Decree that partially resolves claims that Volkswagen (VW) violated the Clean"]
[null,null,"Air Act by selling more than 500,000 vehicles containing 2.0-liter diesel engines equipped with “defeat devices.” These defeat devices the vehicles to "]
[null,null,"meet emission limits during emissions tests while not meeting these limits during normal vehicle operation."]
[]
[null,null,"As part of the Partial Consent Decree, VW will provide $2.7 billion to establish a Mitigation Trust Fund which is intended to fully mitigate the excess "]
[null,null,"nitrogen oxide (NOx) emissions from the 2.0-liter diesel vehicles. Florida’s share of these funds is currently estimated to be approximately $152 million.\n\n"]
[]
[null,null,"In order for Florida to receive these funds, the state must first become a Beneficiary and then submit a Beneficiary Mitigation Plan to the designated "]
[null,null,"Trustee. Through this Request for Additional Information (RFI), the Department is requesting information to assist in determining the range and types of "]
[null,null,"diesel emission reduction and mitigation projects that potentially exist in the state to help inform Florida’s draft Beneficiary Mitigation Plan. This RFI is "]
[null,null,"also intended to identify Interested Entities that may be interested in participating in potential mitigation projects in the future.\n\n"]
[]
[null,null,"For additional background information on the Volkswagen Settlement and Consent Decree, please visit:"]
[null,null,"http://www.dep.state.fl.us/air/about_air/volkswagen-settlement.htm"]
[]
[null,null,"Click here to view definitions of key terms used in the spreadsheet"]
[]
[]
[null,null,"Instructions"]
[null,null,"The scope of this RFI is related to Medium and Heavy Duty Trucks, as detailed under Eligible Mitigation Actions numbers 1, 6, and 10 of Appendix D-2†"]
[null,null,"of the Partial Consent Decree, and as defined below:"]
[]
[null,null,"        • Replacing or repowering of model years 1992-2009 Class 4 through 8 Local Freight Trucks and Port Drayage Trucks, including"]
[null,null,"          commercial trucks, used to deliver cargo and freight (e.g., courier services, delivery trucks, box trucks moving freight, waste haulers, \n"]
[null,null,"          dump trucks, concrete mixers) with a Gross Vehicle Weight Rating above 14,001 pounds.\n"]
[null,null,"        • Replacing, repowering, or retrofitting of model years 1995-2009 Class 5 through 8 Local Trucks, Highway Trucks, and Port Drayage \n"]
[null,null,"          Trucks with a Gross Vehicle Weight Rating greater than 16,001 pounds. "]
[]
[null,null,"To complete the RFI response template, click here."]
[null,null,"The Department is requesting information from Interested Entities (including county and local governmental entities, non-governmental entities, and "]
[null,null,"private entities) that own and operate Medium or Heavy Duty Trucks consistent with the definitions provided above.\n"]
[]
[null,null,"While it is not necessary to complete all sections or all questions within a section to provide value, please answer as many questions as you can. "]
[null,null,"Please do your best to include information only on the units listed above.\n"]
[]
[null,null,"No entity is required to complete this form. This RFI is for informational purposes only. Failure to complete this form does not disqualify any entity from "]
[null,null,"participating in any future mitigation programs. Completing this form is not a guarantee of participation in any future potential mitigation programs."]
[]
[null,null,"The preferred method for submitting information is this spreadsheet. If you have supplemental information in other formats that you would also like to "]
[null,null,"submit, the Department can accept that in addition to this spreadsheet."]
[]
[null,null,"Instructions on how to submit information and submission deadlines is included in the RFI, which can be viewed on the State's Vendor Bid System "]
[null,null,"website at http://www.myflorida.com/apps/vbs/. Once at this site, the steps listed below should be followed to access the RFIs:"]
[null,null,"        • Click \"Search Advertisements\""]
[null,null,"        • Under the \"Agency\" search field, select the \"Department of Environmental Protection\" and click on \"Initiate Search\""]
[null,null,"        • Click on the applicable RFI number"]
[]
[null,null,"If you have any questions about the RFI, please direct them to:"]
[null,null,"   Fran Spivey, Procurement Officer"]
[null,null,"   Procurement Section, Room 215M\n"]
[null,null,"   Florida Department of Environmental Protection \n"]
[null,null,"   3800 Commonwealth Boulevard, MS 93\n"]
[null,null,"   Tallahassee, FL 32399-3000"]
[null,null,"   Email: Fran.Spivey@dep.state.fl.us "]
[null,null,"\n"]
[null,null,"† Link to Appendix D-2: http://www.dep.state.fl.us/air/about_air/Volkswagen/Appendix-D-2.pdf"]
[null,null,"* \"Local freight\" means trucks, including commercial trucks, used to deliver cargo and freight (e.g. courier services, delivery trucks, box trucks moving"]
[null,null,"freight, waste haulers, dump trucks, concrete mixers).\n"]
[null,null,"** \"Highway vehicles\" includes long-haul and local freight, drayage, delivery, bucket, beverage, refuse, furniture, dump, cement, and other highway"]
[null,null," vehicles."]

{"sheet":"RFI 2017035C - Trucks","index":1,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[null,null,"Click here to return to the Instructions."]
[]
[]
[null,null,"Contact Information for Entity Completing this Request for Information"]
[null,null,"Name:"]
[null,null,"Company:"]
[null,null,"Address Line 1:"]
[null,null,"Address Line 2:"]
[null,null,"Address Line 3:"]
[null,null,"Phone number:"]
[null,null,"Email address:"]
[]
[]
[null,null,"General Questions"]
[null,null,"How many trucks does the entity own?"]
[null,null,"What type of truck does the entity own?"]
[null,null,"Is the owner of the trucks a governmental or private entity?"]
[null,null,"How many counties do the trucks operate in?"]
[null,null,"In what counties are the trucks based?",null,null,"County","# of trucks"]
[]
[]
[null,null,"On average, how often does the entity replace each truck?"]
[null,null,"Please describe the process."]
[]
[]
[]
[null,null,"Class 4 - 5 Truck Details"]
[null,null,"Truck class","Model year","# of trucks of this type","Average annual usage (miles)","Average annual fuel usage (gallons)","Average annual idling hours","How much longer does the entity intend to use these trucks (years)?"]
[null,null,null,1992]
[null,null,null,1993]
[null,null,null,1994]
[null,null,null,1995]
[null,null,null,1996]
[null,null,null,1997]
[null,null,null,1998]
[null,null,null,1999]
[null,null,"Class 4 - 5 (GVWR ",2000]
[null,null,"14,001 to 19,500 lbs)",2001]
[null,null,null,2002]
[null,null,null,2003]
[null,null,null,2004]
[null,null,null,2005]
[null,null,null,2006]
[null,null,null,2007]
[null,null,null,2008]
[null,null,null,2009]
[]
[]
[null,null,"Class 6 - 7 Truck Details"]
[null,null,"Truck class","Model year","# of trucks of this type","Average annual usage (miles)","Average annual fuel usage (gallons)","Average annual idling hours","How much longer does the entity intend to use these trucks (years)?"]
[null,null,null,1992]
[null,null,null,1993]
[null,null,null,1994]
[null,null,null,1995]
[null,null,null,1996]
[null,null,null,1997]
[null,null,null,1998]
[null,null,null,1999]
[null,null,"Class 6 - 7 (GVWR ",2000]
[null,null,"19,501 to 33,000 lbs)",2001]
[null,null,null,2002]
[null,null,null,2003]
[null,null,null,2004]
[null,null,null,2005]
[null,null,null,2006]
[null,null,null,2007]
[null,null,null,2008]
[null,null,null,2009]
[]
[]
[null,null,"Class 8 Truck Details"]
[null,null,"Truck class","Model year","# of trucks of this type","Average annual usage (miles)","Average annual fuel usage (gallons)","Average annual idling hours","How much longer does the entity intend to use these trucks (years)?"]
[null,null,null,1992]
[null,null,null,1993]
[null,null,null,1994]
[null,null,null,1995]
[null,null,null,1996]
[null,null,null,1997]
[null,null,null,1998]
[null,null,null,1999]
[null,null,"Class 8 (GVWR ",2000]
[null,null,">33,000 lbs)",2001]
[null,null,null,2002]
[null,null,null,2003]
[null,null,null,2004]
[null,null,null,2005]
[null,null,null,2006]
[null,null,null,2007]
[null,null,null,2008]
[null,null,null,2009]
[]
[]
[null,null,"Trucks that the entity would consider retrofitting over the next 3 - 5 years"]
[null,null,"With Emission Control Device(s)",null,"# of trucks","Estimated cost to retrofit per truck"]
[null,null,null,"Diesel Oxidation Catalyst (DOC)"]
[null,null,null,"DOC + Closed Crankcase Ventilation"]
[null,null,null,"Diesel Particulate Filter (DPF)"]
[null,null,null,"Exhaust Gas Recirculation + DPF"]
[null,null,null,"Selective Catalytic Reduction + DPF"]
[null,null,null,"Other"]
[null,null,"With Idle Reduction Technology",null,"# of trucks","Estimated cost to retrofit per truck"]
[null,null,null,"Auxiliary Power Units and Generator Sets"]
[null,null,null,"Fuel Operated Heaters"]
[null,null,null,"Electrified Parking Spaces"]
[null,null,null,"Other"]
[null,null,"With Aerodynamic Devices",null,"# of trucks","Estimated cost to "]
[null,null," or Tire Technology",null,null,"retrofit per truck"]
[null,null,null,"Single-wide tires"]
[null,null,null,"Other fuel efficient tires"]
[null,null,null,"Trailer bubble/Tails"]
[null,null,null,"Trailer side skirts"]
[null,null,null,"Other aerodynamic device"]
[]
[]
[null,null,"Trucks that the entity would consider repowering over the next 3 - 5 years"]
[null,null,"Repowering with:",null,"# of trucks","Estimated cost to repower per truck"]
[null,null,null,"New diesel engine"]
[null,null,null,"New alternate-fueled engine"]
[null,null,null,"New all-electric engine"]
[]
[]
[null,null,"Trucks that the entity would consider replacing over the next 3 - 5 years"]
[null,null,"Replacing with:",null,"# of trucks","Estimated cost to replace per truck"]
[null,null,null,"New diesel vehicle"]
[null,null,null,"New alternate-fueled vehicle"]
[null,null,null,"New all-electric vehicle"]
[]
[]
[null,null,"Additional Comments"]
[null,null,"Provide any additional comments or information in the box below."]

{"sheet":"Definitions","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Click here to return to the Instructions"]
[]
[]
["Retrofit","Add component(s) to vehicle intended to reduce emissions"]
["Repower","Replace existing engine of vehicle with newer, cleaner engine or power source"]
["Replace","Replace entire vehicle"]
["GVWR","Gross vehicle weight rating"]
["Class 4 Truck","Has a GVWR of 14,001 - 16,000 lbs"]
["Class 5 Truck","Has a GVWR of 16,001 - 19,500 lbs"]
["Class 6 Truck","Has a GVWR of 19,501 - 26,000 lbs"]
["Class 7 Truck","Has a GVWR of 26,001 - 33,000 lbs"]
["Class 8 Truck","Has a GVWR of >33,000 lbs"]
["Local Freight","Trucks, including commercial trucks, used to deliver cargo and freight (e.g., courier services, delivery trucks, box trucks moving freight, waste haulers, dump trucks, concrete mixers)"]
["Highway Vehicles","Includes long-haul and local freight, drayage, delivery, bucket, beverage, refuse, furniture, dump, cement, and other highway vehicles"]

{"sheet":"Sheet2","index":3,"n_rows":106,"n_cols":3,"rows_kept":106,"cut":false,"hidden":true,"merged":[]}
["Data Tables for Dropdown Lists"]
[]
[]
[]
["Emission Control Device","Idle Reduction Technology","Other"]
["Diesel Oxidation Catalyst","Auxiliary Power Units and Generator Sets","Low rolling resistance tires"]
["Diesel Oxidation Catalyst + Closed Crankcase Ventilation","Fuel Operated Heaters","Aerodynamic technology"]
["Diesel Oxidation Catalyst + Diesel Particulate Filter","Battery Air Conditioning Systems"]
["Diesel Particulate Filter","Thermal Storage Systems"]
["Exhaust Gas Recirculation + Diesel Particulate Filter","Electrified Parking Spaces"]
["Selective Catalytic Reduction + Diesel Particulate Filter","Other"]
["Other"]
[]
["New alternate-fueled vehicle"]
["Biodiesel (B5)"]
["Biodiesel (B20)"]
["Other"]
[]
["Class"]
["Class 4 - 5"]
["Class 6 - 7"]
["Class 8"]
[]
[]
[]
["Truck Type","Local or Long-Haul?"]
["Local freight","Local"]
["Long-haul freight","Long-Haul"]
["Port drayage"]
["Other","Locations","Governmental or Private"]
[null,"Northeast","Governmental entity"]
[null,"Northwest","Private entity"]
[null,"Central"]
[null,"Central East"]
[null,"Central West"]
[null,"Southeast"]
[null,"Southwest"]
["Model Year"]
[1992,"County"]
[1993,"Alachua"]
[1994,"Baker"]
[1995,"Bay"]
[1996,"Bradford"]
[1997,"Brevard"]
[1998,"Broward"]
[1999,"Calhoun"]
[2000,"Charlotte"]
[2001,"Citrus"]
[2002,"Clay"]
[2003,"Collier"]
[2004,"Columbia"]
[2005,"DeSoto"]
[2006,"Dixie"]
[2007,"Duval"]
[2008,"Escambia"]
[2009,"Flagler"]
[null,"Franklin"]
["Counties of operation","Gadsden"]
[1,"Gilchrist"]
["2-3","Glades"]
["4+","Gulf"]
[null,"Hamilton"]
[null,"Hardee"]
[null,"Hendry"]
[null,"Hernando"]
[null,"Highlands"]
[null,"Hillsborough"]
[null,"Holmes"]
[null,"Indian River"]
[null,"Jackson"]
[null,"Jefferson"]
[null,"Lafayette"]
[null,"Lake"]
[null,"Lee"]
[null,"Leon"]
[null,"Levy"]
[null,"Liberty"]
[null,"Madison"]
[null,"Manatee"]
[null,"Marion"]
[null,"Martin"]
[null,"Miami-Dade"]
[null,"Monroe"]
[null,"Nassau"]
[null,"Okaloosa"]
[null,"Okeechobee"]
[null,"Orange"]
[null,"Osceola"]
[null,"Palm Beach"]
[null,"Pasco"]
[null,"Pinellas"]
[null,"Polk"]
[null,"Putnam"]
[null,"Santa Rosa"]
[null,"Sarasota"]
[null,"Seminole"]
[null,"St. Johns"]
[null,"St. Lucie"]
[null,"Sumter"]
[null,"Suwannee"]
[null,"Taylor"]
[null,"Union"]
[null,"Volusia"]
[null,"Wakulla"]
[null,"Walton"]
[null,"Washington"]