{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["One-Page Tracking Sheet","Valid Lists","ENERGY_STAR_FailureReport","Sheet1"],"not_rendered":{"macros":1,"defined_names":41,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"One-Page Tracking Sheet","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"hidden":true,"merged":[[0,0,0,4],[0,5,0,6],[2,1,2,2],[2,5,2,7],[4,1,4,2],[4,5,4,7],[6,1,6,2],[6,5,6,7],[7,1,7,2],[7,5,7,7],[8,1,8,2],[8,5,8,7],[9,1,9,2],[9,5,9,7],[10,1,10,2],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[17,1,17,2],[17,3,17,4],[17,5,17,7],[18,1,18,2],[18,3,18,4],[18,5,18,7],[19,1,19,2],[19,3,19,4],[19,5,19,7],[21,3,21,7],[22,2,22,3],[22,4,22,5],[23,4,23,5],[23,6,23,7],[24,4,24,5],[24,6,24,7],[26,0,26,7],[28,1,29,1],[28,2,29,7],[30,2,30,7]]}
[{"$f":"MRF_CompanyName","v":0},{"$nulls":4},"Resolved?"]
[]
["Verification Effort?",null,null,"Administrator:"]
[]
["ES Program:",{"$f":"MRF_ProdcutCategory","v":0}]
[]
["Date Testing Began:",null,null,"EPA Case Number:",null,{"$f":"MRF_Case_Number","v":{"$error":"#REF!"}}]
["Test Report Date:",null,null,"OEM of Tested Product:",null,{"$f":"MRF_OEM","v":0}]
["Manufacturer of Tested Product:",null,null,"OEM Model Number:"]
["Brand Name of Tested Product:",{"$f":"MRF_Brand","v":0},null,"# of Affected Labelers:"]
["Model Number of Tested Product:",{"$f":"MRF_Model_Number","v":0}]
["Contact Information"]
["Responsible Party\n (ES Partner):",{"$f":"MRF_POC_Partner","v":0},"OEM Contact:",{"$f":"MRF_OEM_Contact","v":0},null,"Contractor\n POC: \n","Stephen Bickel"]
["Title:",{"$f":"MRF_POC_Company_Title","v":0},"Title:",{"$f":"MRF_OEM_Title","v":0},null,"Company:",{"$f":"IF(ISBLANK($G$13),\"\",VLOOKUP($G$13,'Valid Lists'!$A$5:$D$11,2))","v":"D&R"}]
["E-mail:",{"$f":"MRF_POC_Company_email","v":0},"E-mail:",{"$f":"MRF_OEM_Email","v":0},null,"E-mail:",{"$f":"IF(ISBLANK($G$13),\"\",VLOOKUP($G$13,'Valid Lists'!$A$5:$D$11,3))","v":"sbickel@drintl.com"}]
["Phone:",{"$f":"MRF_POC_Company_Phone","v":0},"Phone:",{"$f":"MRF_OEM_Phone","v":0},null,"Phone:",{"$f":"IF(ISBLANK($G$13),\"\",VLOOKUP($G$13,'Valid Lists'!$A$5:$D$11,4))","v":"301-628-2040 "}]
["Status Determination"]
["Tests Failed:",null,null,"Date Removed from QPL:"]
["Deviation from Test Requirement:",null,null,"Disqualification Letter Sent:"]
["Basis:",null,null,"Product Status Determination:"]
["Product Control Measures (PCM) Details"]
["PCM required?",null,"PCM Issues:","See Manufacturer Response Form worksheet. "]
["PCM Due Date:",null,"Date Last Manufactured:",null,{"$f":"MRF_DateLastManuf","v":"00:00:00"}]
["PCM Received:",null,null,"Date","Quantity",null,"Destination"]
["PCM Implementation Confirmation Date:",null,"Last Shipment:",{"$f":"MRF_DateLastShipment","v":"00:00:00"},{"$f":"MRF_QuantityShipment","v":0},null,{"$f":"MRF_LastShipmentDest","v":{"$error":"#REF!"}}]
["Additional Notes"]
[]
["Manufacturer Challenge Description"]
["Manufacturer Dispute? ","Manufacturer's Explanation:",{"$f":"MRF_Dispuste_Basis","v":{"$error":"#REF!"}}]
[{"$f":"MRF_Dispute","v":{"$error":"#REF!"}}]
["Basis of Dispute:\n(describe at right) ","Additional Info (entered by EPA/Contractor):"]

{"sheet":"Valid Lists","index":1,"n_rows":27,"n_cols":55,"rows_kept":27,"hidden":true,"merged":[[0,0,0,7],[2,0,2,7]]}
["Product Status "]
["Yes No","Y","N"]
["Contractor POC"]
["Contractor POC: \n","Company:","E-mail:","Phone:"]
["Jeffrey Clark","ICF","jclark@icfi.com","202-862-2976"]
["Josh Forgotson","ICF","jforgotson@icfi.com","202-862-2955"]
["Kate Buck","ICF","kbuck@icfi.com","919-293-1652"]
["Mikah McCabe ","D&R","mmccabe@drintl.com","301-628-2084"]
["Monica Andrews","ICF","mandrews@icfi.com","703-218-2590"]
["Shannon Christie","D&R","schristie@drintl.com","301-588-9387 "]
["Stephen Bickel","D&R","sbickel@drintl.com","301-628-2040 "]
["Product count",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,null,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53]
["  Product Category","Audio/Video","Boilers","Ceiling Fans","CAC ASHP","Certified Lighting Subcomponent Database","Clothes Dryers","Clothes Washers","Commercial Boilers","Commercial Coffee Brewers","Commercial Dishwashers","Commercial Fryers","Commercial Griddles","Commercial Hot Food Holding Cabinets","Commercial Ice Machines","Commercial Ovens","Commercial Refrigerators and Freezers","Commercial Steam Cookers","Commercial Water Heaters","Compact Fluorescent Lamps","Computers","Connected Thermostats","Data Center Storage","Decorative Light Strings","Dehumidifiers","Dishwashers","Displays ","Electric Vehicle Supply Equipment","Enterprise Servers","Furnaces","Geothermal Heat Pumps","Imaging Equipment ","Integral LED Lamps","Lab Grade Refrigerators and Freezers","Lamps","Large Network Equipment","Light Commercial HVAC","Luminaires","Pool Pumps","Refrigerators and Freezers","Roof Products","Room Air Cleaners and Purifiers","Room Air Conditioners","Set-top Boxes and Cable Boxes","Small Networking Equipment","Solid-state Lighting Luminaires","Storm Windows","Telephony","Televisions","Uninterruptible Power Supplies","Vending Machines","Ventilating Fans","Water Coolers","Water Heaters","Windows, Doors, and Skylights"]
[]
["Y_N_N/A","Y","N","ES Partner listed is the OEM"]
[]
["Source Testing","Cycle 1","Cycle 2","Cycle 3","DOE Verification Testing","Other (describe in Notes)","QA4 - Round 4","QA4 - Round 5","QA4 - Round 6","QA4 - Round 7","Recog. CB or Lab","Self-Testing/Reporting","Verification Testing"]
["CB Count",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["Name of CB","Advanced Compliance Solutions, Inc.","Air-Conditioning, Heating, and Refrigeration Institute (AHRI)","AMCA International, Inc.","American Certification Body, Inc. (ACB, Inc.)","Applied Research Laboratories of South Florida, LLC","Association of Home Appliance Manufacturers (AHAM)","Bay Area Compliance Laboratories Corp. (BACL)","China Quality Certification Center","Cool Roof Rating Council (CRRC)","CSA International","Curtis-Straus LLC, a Bureau Veritas Company","Home Ventilating Institute (HVI)","IAPMO R&T, Inc.","ICC Evaluation Service, LLC","Intertek Testing Services NA Inc","Keystone Certifications, Inc.","MET Laboratories, Inc.","National Fenestration Rating Council (NFRC)","Nemko Canada Inc","NSF International","SGS North America Inc.","Solar Rating and Certification Corporation (SRCC)","TUV Rheinland of North America, Inc.","TUV SUD America, Inc.","UL Verification Services, Inc."]
[]
["Verification Testing Result","Passed; met specification requirements","Passed; 1 or more requirement within 5% of meeting specification requirement","Failed; reported to EPA"]
[]
["Where unit was obtained","Off-the-shelf (Retail store)","Off-the-shelf (Online)","Warehouse or other distribution center","Off-the-Line (from manufacturing facility); provide reason","Other; provide reason"]
["Reasons why unit was obtained off-the-line (from manufacturing facility)","Eligible Product Category-Commercial Food Service","Eligible Product Category-Imaging Equipment with speed greater than 50 ipm ","Eligible Product Category-Servers","Eligible Product Category-Workstations","Eligible Product Category-Light Commercial HVAC","Other; confirmed with EPA","NA; product was obtained off-the-shelf (retail or online) or from warehouse"]
["Type of Product Failure:","Verification Testing Failure","Certification Error","Full lifetime testing failure \n(Compact Fluorescent Lamps, Integral LED Lamps and Luminaires only)"]
[]
["Verification Testing Round:",2011,2012,2013,2014,2015,2016,2017,2018,2019,"N/A; not a verification testing failure"]

{"sheet":"ENERGY_STAR_FailureReport","index":2,"n_rows":55,"n_cols":7,"rows_kept":55,"merged":[[4,1,4,6],[5,1,5,6],[6,1,6,6],[8,1,8,6],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[12,1,13,1],[12,2,13,3],[12,5,12,6],[13,5,13,6],[14,2,14,3],[14,5,14,6],[15,2,15,3],[15,5,15,6],[16,2,16,3],[16,5,16,6],[17,2,17,3],[17,5,17,6],[18,2,18,3],[18,5,18,6],[19,2,19,3],[19,5,19,6],[20,2,20,3],[20,5,20,6],[21,2,21,3],[21,5,21,6],[22,2,22,3],[22,5,22,6],[23,2,23,3],[23,5,23,6],[24,1,24,6],[25,2,25,3],[25,5,25,6],[26,2,26,3],[26,5,26,6],[27,2,27,3],[27,5,27,6],[28,2,28,3],[28,5,28,6],[29,2,30,6],[32,1,32,6],[33,1,33,6],[34,1,34,6],[36,1,36,6],[37,1,37,6],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,6],[50,1,50,2],[54,1,65,6]]}
[]
[]
[]
[]
[null,"ENERGY STAR® Failure Report"]
[null,"Instructions "]
[null,"Certification bodies shall report verification testing failures within 2 business days of observation of the failure to Enforcement@energystar.gov using the subject line \"FAILURE\" followed by the ENERGY STAR manufacturing partner name(s) and model number(s). CBs must complete and submit this document along with the laboratory test report and any supporting documentation. Example subject line: \"FAILURE ENERGY STAR Manufacturing Partner Name X Model #######.\""]
[]
[null,"Section I: Product and Shipping Information "]
[null,"Name of Certification Body:",null,null,"Date Model Available on Market:"]
[null,"Product Specification: ",null,null,"Type of Product Failure:"]
[null,"ENERGY STAR Manufacturing Partner:",null,null,"Date Certification Body Determined Failure:"]
[null,"Original Equipment Manufacturer (OEM): \n(if Partner listed is not OEM)",null,null,"Date(s) of Initial Testing:"]
[{"$nulls":4},"Year Model Was Selected for Verification Testing:"]
[null,"OEM Model Number:\n(if Partner listed is not OEM)",null,null,"Name of Lab that performed Certification Testing:"]
[null,"Is OEM Model qualified?\n(under OEM's brand/org name)",null,null,"Lab EPA-issued Org ID:"]
[null,"Brand Name:",null,null,"Verification Testing-Date(s) for single unit testing or spot-check test:"]
[null,"Certified Model Name:",null,null,"Verification Testing-Date(s) for remaining samples where multiple test sample (approach two) is used:"]
[null,"Certified Model Number:",null,null,"Name of Lab that performed Verification Testing:"]
[null,"ENERGY STAR Model Identifier:",null,null,"Lab EPA-issued Org ID:"]
[null,"Product Type:",null,null,"Where unit was obtained:"]
[null,"Tested Model Name:",null,null,"If product was obtained off-the-line or other; provide reason"]
[null,"Tested Model Number: ",null,null,"Tested Model Date(s) of Manufacturer: \n(if available)"]
[null,"Tested Serial Number(s):",null,null,"Date(s) Unit was Obtained:"]
[null,"Section II: Contact Information"]
[null,"Point of Contact\n at the Certification Body:",null,null,"Partner Contact:"]
[null,"Job Title:",null,null,"Job Title:"]
[null,"Email:",null,null,"Email:"]
[null,"Phone Number:",null,null,"Phone Number:"]
[null,"Additional  Contacts?"]
[null,"Name (e-mail)"]
[]
[null,"Section III: Verification Testing Results"]
[null,"Describe all the relevant testing results. If reporting a verification testing failure, please include the verification testing results, ENERGY STAR specification requirement(s) for the performance criteria that the product failed, and initial testing results."]
[]
[]
[null,"Section IV: Additional Model Numbers"]
[null,"List the identifying information for any private label models, family models, or other related models qualified on the same basis as the product that failed testing. \nPlease attach additional pages, if necessary."]
[null,"ENERGY STAR Manufacturing Partner:",null,"Brand Name:","Model Name:","Model Number","ENERGY STAR Model Identifier:"]
{"$rows_empty":10}
[null,"United States ENVIRONMENTAL PROTECTION AGENCY Washington, DC 20460 Office of Atmospheric Programs"]
[null,"OMB Control No. 2060-0528"]
[null,"Approval expires: Pending Approval"]
[null,"EPA  Form No. 5900-252"]
[]
[null,"This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-0528). Responses to this collection of information are voluntary (Section103(g) of the Clean Air Act). An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The public reporting and recordkeeping burden for this collection of information is estimated to 6.3 hours per response. Send comments on the Agency’s need for this information, the accuracy of the provided burden estimates and any suggested methods for minimizing respondent burden to the Regulatory Support Division Director, U.S. Environmental Protection Agency (2821T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed form to this address."]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}