{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Energy-Only Specification","Full Specification","Dropdowns"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":24,"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":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[17,2,17,8],[18,2,18,8],[16,2,16,8],[14,1,14,8],[15,1,15,16383],[8,0,8,8],[0,0,0,8],[3,0,3,8],[4,0,4,16383],[5,0,5,8],[9,1,9,8],[10,1,10,8],[13,1,13,8],[1,0,1,8]]}
["Advanced Technology Specification: \nLow-Voltage Dry-Type \nDistribution Transformers\n"]
[]
["Summary"]
["The U.S. Department of Energy (DOE) and the Commercial Building Energy Alliances (CBEA) have developed this specification  for high-efficiency Low-Voltage Dry-Type Distribution Transformers (Dry-LVDT) with input from manufacturers and other stakeholder organizations.  This specification provides a description of required and recommended performance characteristics resulting in increased energy savings for Dry-LVDTs in commercial buildings. "]
["\nThrough the creation of high-performance specifications, the CBEA members signal their collective interest in more efficient equipment and challenge manufacturers to deliver competitively-priced, innovative products.\n"]
["\nMore on the DOE and CBEA activities, including other energy saving specifications, can be found at:  http://www1.eere.energy.gov/buildings/alliances/"]
[]
["Specification Contents"]
["This file contains two specifications, both of which include the same energy requirements."]
["i. ","The 'Energy-Only Specification' provides only the energy-related requirements and recommendations as a guide for CBEA purchasers to incorporate in their own specifications. "]
["ii. ","The 'Full Specification' provides an example of a comprehensive purchase specification including energy-related items and all other relevant elements. This specification can be customized by the CBEA purchaser to suit their specific needs. "]
[]
["Instructions for Using this Specification"]
["i.","Please fill in the appropriate project information in the header of each specification. "]
["ii.","For the 'Energy-Only Specification', please use energy-related requirements and recommendations as a guide during modifications to your own comprehensive purchase specification, or as an supplementary attachment. "]
["iii. ","For the 'Full Specification', fill in all input cells (shaded in light blue). Energy-related outputs (shaded in light red) will be automatically generated based on these inputs. "]
[null,"a. ","Use 'n/a' for information not required for your specific needs. "]
[null,"b.","If the purchaser requires additional items for the specification, use the customizable cells (shaded in light green)."]
[null,"c.","Once the purchaser has completed the form, select the \"Finalize\" icon. \nNote:  Internet access required for full functionality. "]
[]
[null,"Legend"]
[null,"Input Cell"]
[null,"Energy-Related Output Cell"]
[null,"User-Customizable Cell"]

{"sheet":"Energy-Only Specification","index":1,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[0,0,0,8],[5,1,5,16382],[7,1,7,8],[8,0,8,3],[8,4,8,7],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,6,9,7],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[10,2,10,3],[15,0,15,1],[15,2,15,3],[23,1,23,8],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[16,2,16,3],[17,2,17,3],[18,2,18,3],[16,0,16,1],[21,0,21,7],[17,0,17,1],[15,4,15,5],[18,0,18,1],[19,0,20,3],[26,1,26,8],[27,0,27,3],[27,4,27,7],[28,0,28,1],[28,2,28,3],[28,4,28,5],[28,6,28,7],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[30,6,30,7],[34,6,34,7],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,6,32,7],[33,2,33,3],[33,4,33,5],[34,0,34,1],[34,2,34,3],[34,4,34,5],[38,0,39,3],[38,4,38,5],[38,6,38,7],[39,4,39,5],[39,6,39,7],[24,1,24,8],[14,6,14,7],[33,6,33,7],[37,0,37,1],[37,2,37,3],[37,4,37,5],[37,6,37,7],[35,0,35,1],[35,2,35,3],[35,4,35,5],[35,6,35,7],[36,0,36,1],[36,2,36,3],[36,4,36,5],[36,6,36,7],[33,0,33,1],[30,0,30,1],[30,2,30,3],[30,4,30,5]]}
["Advanced Technology Specification: \nLow-Voltage Dry-Type \nDistribution Transformers\n"]
[]
["Energy-Efficiency Requirements & Recommendations"]
[]
["A.","Minimum Efficiency Requirements & Test Method"]
[null,"Products meeting this specification shall meet or exceed the efficiency levels of Table 1 when tested in accordance with DOE Test Procedure, Appendix A to Subpart K of Part 431 – Uniform Test Method for Measuring the Energy Consumption of Distribution Transformers [October 16, 2006]."]
[]
["Table 1: ","Minimum Efficiency Requirements (%) at 35% of Nameplate Capacity (kVA) for Dry-LVDTs Meeting this Specification"]
["Single Phase",null,null,null,"Three Phase"]
["Nameplate Capacity (kVA)",null,"Efficiency (%) at 35% of Nameplate Capacity (kVA)",null,"Nameplate Capacity (kVA)",null,"Efficiency (%)at 35% of Nameplate Capacity (kVA)"]
[15,null,0.9839,null,15,null,0.98399999999999999]
[25,null,0.98599999999999999,null,30,null,0.98650000000000004]
[37.5,null,0.98740000000000006,null,45,null,0.98780000000000001]
[50,null,0.98809999999999998,null,75,null,0.98929999999999996]
[75,null,0.98950000000000005,null,112.5,null,0.99029999999999996]
[100,null,0.99019999999999997,null,150,null,0.99099999999999999]
[167,null,0.9909,null,225,null,0.99399999999999999]
[250,null,0.99160000000000004,null,300,null,0.99439999999999995]
[333,null,0.99229999999999996,null,500,null,0.99509999999999998]
[null,null,null,null,750,null,0.99560000000000004]
[null,null,null,null,1000,null,0.99590000000000001]
["Note: Efficiency levels match CEE Tier 1 for single phase transformers and CEE Tier 2 for three phase transformers."]
[]
["B. ","Maximum No-Load Core Loss Recommendation for Buildings with Lower Loading Profiles & Test Method"]
[null,"Products intended for buildings with lower loading profiles* should have no-load core losses less than or equal to the maximum levels of Table 2, in addition to the minimum efficiency requirement of Table 1 above, when tested in accordance with DOE Test Procedure, Appendix A to Subpart K of Part 431 – Uniform Test Method for Measuring the Energy Consumption of Distribution Transformers [October 16, 2006]."]
[null,"* As determined by the specifying engineer or electrician."]
["Table 2: ","Minimum Efficiency Requirements (%) at 35% of Nameplate Capacity (kVA) for Dry-LVDTs Meeting this Specification"]
["Single Phase",null,null,null,"Three Phase"]
["Nameplate Capacity (kVA)",null,"Maximum No-Load Core Loss (W)",null,"Nameplate Capacity (kVA)",null,"Maximum No-Load Core Loss (W)"]
[15,null,40,null,15,null,35]
[25,null,55,null,30,null,60]
[37.5,null,75,null,45,null,80]
[50,null,90,null,75,null,120]
[75,null,120,null,112.5,null,160]
[100,null,150,null,150,null,190]
[167,null,230,null,225,null,200]
[250,null,315,null,300,null,230]
[333,null,385,null,500,null,330]
[null,null,null,null,750,null,450]
[null,null,null,null,1000,null,550]

{"sheet":"Full Specification","index":2,"n_rows":125,"n_cols":9,"rows_kept":125,"cut":false,"hidden":false,"merged":[[121,5,121,6],[120,5,120,6],[102,0,102,5],[103,0,103,5],[87,6,87,7],[120,1,122,4],[90,0,92,4],[86,0,88,4],[112,1,113,8],[116,1,117,8],[97,0,97,8],[104,0,104,5],[43,1,43,8],[105,0,105,5],[106,0,106,5],[107,0,107,5],[99,0,99,5],[100,0,100,5],[101,0,101,5],[58,2,58,3],[59,2,59,3],[62,2,62,3],[66,2,66,3],[74,0,75,4],[77,0,77,8],[86,6,86,7],[80,2,84,8],[33,2,33,8],[39,1,39,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[124,0,127,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[0,0,0,8],[70,2,72,8],[5,1,5,8],[47,1,47,8],[48,1,48,8],[49,1,49,8],[55,1,55,16383],[29,2,29,8],[36,2,36,8],[15,2,15,8],[31,2,31,8],[32,2,32,8]]}
["Advanced Technology Specification: \nLow-Voltage Dry-Type \nDistribution Transformers\n"]
[]
["1. General "]
[]
["1.1 Scope"]
["A. ","This specification defines dry-type single-phase distribution transformers rated between 15 kVA and 333 kVA, and dry-type three-phase distribution transformers rated between 15 kVA and 1000 kVA with the following characteristics:\n"]
[null,"i.","Input and output voltages less than or equal to 600 V."]
[null,"ii.","Air-cooled and do not use oil as a coolant."]
[]
["B. ","This specification does not cover transformers with the following characteristics:"]
[null,"i.","Liquid-filled transformers"]
[null,"ii.","Products excluded from NEMA TP 1-2002."]
[]
["1.2 Submittals"]
["A. ","Manufacturer shall provide product data and drawings stating the following:"]
[null,"i.","Dimensions including external enclosure and internal core & coil (in)"]
[null,"ii.","Weight (lbs)"]
[null,"iii.","Nameplate capacity (kVA)"]
[null,"iv.","Primary & secondary voltage (V)"]
[null,"v.","Impedance (%)"]
[null,"vi.","Reference temperature (˚C)"]
[null,"vii.","K-factor rating"]
[null,"viii.","Coil tap arrangement and tap voltage"]
[null,"ix.","Insulation class"]
[null,"x.","Sound level (dB)"]
[null,"xi.","Wiring diagram"]
[null,"xii.","Installation instructions"]
[null,"xiii.","UL rating label drawing"]
[null,"xiv.","No-load core loss @ 100% voltage"]
[null,"xv.","Impedance loss or coil loss @ rise + 20˚C reference temperature"]
[null,"xvi.","Total loss @ rise + 20˚C reference temperature"]
[null,"xvii.","Efficiency under linear load at:  5%, 15%, 25%, 35%, 50%, 75%, 100% of nameplate capacity"]
[null,"xviii.","Impedance at reference temperature of rise + 20˚C reference temperature i.e. %R, %X, %Z"]
[null,"xix.","Regulation at reference temperature of Rise + 20˚C reference temperature"]
[null,"xx.","Inrush current (A)"]
["B.","Operation and Maintenance Data"]
[null,"i. ","Manufacturer shall provide copies of installation, operation and maintenance procedures and manual with the transformer. "]
[]
["1.3 Related Standards"]
["A.","ANSI/IEEE C57.12.01 – Standard General Requirements for Dry-Type Distribution and Power Transformers"]
["B.","ANSI/IEEE C57.12.91 -  Standard Test Code for Dry-Type Distribution and Power Transformers"]
["C.","ANSI/IEEE C57.96 - Guide for Loading Dry-Type Distribution and Power Transformers"]
["D.","ANSI/IEEE C89.2 - Dry Type Transformers for General Applications"]
["E.","ANSI/NFPA 70 - National Electrical Code"]
["F.","DOE 10 CFR Appendix A to Subpart K of Part 431 – Uniform Test Method for Measuring the Energy Consumption of Distribution Transformers "]
["G.","NEMA ST 20 - Dry Type Transformers for General Applications"]
["H.","NEMA TP-1  - Guide for Determining Energy Efficiency for Distribution Transformers"]
["I.","NEMA TP-2 – Standard Test Method for Measuring the Energy Consumption of Distribution Transformers"]
["J.","NEMA TP-3 – Standard for the Labeling of Distribution Transformer Efficiency"]
["K.","UL 5085 – Low Voltage Transformers"]
[]
["2. Products"]
[]
["2.1 General Construction"]
["A.","Product shall be UL listed."]
["B.","Build to NEMA ST-20 and in accordance with all applicable UL, ANSI, IEEE, and NEMA standards."]
[]
["2.2 Transformer Parameters"]
[null,null,"Transformer Parameter",null,"Value","Value if 'Other'","Unit"]
[null,null,"Transformer Type",null,"Select a value",null,"Phase"]
[null,null,null,"Primary Voltage","Select a value",null,"V"]
[null,null,null,"Secondary Voltage","Select a value",null,"V"]
[null,null,"kVA Rating",null,"Select a value",null,"kVA"]
[null,null,null,"System Frequency","Select a value",null,"Hz"]
[null,null,null,"Insulation Class","Select a value",null,"˚C"]
[null,null,null,"Temperature Rise","Select a value",null,"˚C"]
[null,null,"Sound Rating",null,"Select a value",null,"dB"]
[null,null,null,"Ventilated Enclosure Type","Select a value",null,"-"]
["2.3 Energy-Related Requirements & Recommendations"]
["A.","Minimum Efficiency Requirements"]
[null,"i. ","Products meeting this specification shall meet or exceed the efficiency level below when tested in accordance with DOE Test Procedure, Appendix A to Subpart K of Part 431 – Uniform Test Method for Measuring the Energy Consumption of Distribution Transformers."]
[]
[]
[]
["Minimum Efficiency Requirement (%) at 35% of Nameplate Capacity (kVA)",null,null,null,null,null,"Value","Unit"]
[null,null,null,null,null,null,{"$f":"IF(Type=\"Single\",Dropdowns!K32,IF(Type=\"Three\",Dropdowns!O32,\"\"))","v":""},"%"]
[]
["Note: Efficiency levels match CEE Tier 1 for single phase transformers and CEE Tier 2 for three phase transformers."]
[]
["B.","Maximum No-Load Core Loss Recommendation "]
[null,"i. ","Products intended for buildings with lower loading profiles should have no-load core losses less than or equal to the maximum level below, in addition to the minimum efficiency requirement above, when tested in accordance with DOE Test Procedure, Appendix A to Subpart K of Part 431 – Uniform Test Method for Measuring the Energy Consumption of Distribution Transformers."]
[]
[]
[]
[]
[]
["Is this product(s) intended for building(s) with lower loading profiles, as determined by the specifying engineer or electrician?",null,null,null,null,null,"Yes/No"]
[null,null,null,null,null,null,"Select a response"]
[]
[]
["Maximum No-Load Core Loss (W) Recommendation for Dry-LVDTs Intended for Buildings with Lower Loading Profiles",null,null,null,null,null,"Value","Unit"]
[null,null,null,null,null,null,{"$f":"IF(Type<>\"Select a value\",IF(Loading_YN=\"Yes\",IF(Type=\"Single\",Dropdowns!L32, IF(Type=\"Three\",Dropdowns!P32)),\"n/a\"),\"\")","v":""},"W"]
[]
[]
[]
[]
[]
["2.4 Additional Specification Requirements"]
[]
["Transformer Parameter",null,null,null,null,null,"Value","Unit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. Execution"]
[]
["3.1 Installation"]
["A. ","Install transformers according to manufacturer’s instructions, in accordance with recognized industry practices and applicable NEC, NEMA, ANSI, and IEEE standards."]
[]
[]
["3.2 Testing"]
["A.","Upon installation, perform inspections and tests according to manufacturer’s written instructions. "]
[]
[]
["3.3 Warranty"]
["A. ","Products meeting this specification shall carry a warranty covering material and workmanship defect from the date of procurement for: ",null,null,null,"Value",null,"Value if 'Other'","Unit"]
[null,null,null,null,null,"Select a value",null,null,"Year(s)"]
[]
[]
["By clicking the \"Finalize Spec\" button, a print preview window will also appear, allowing you to print the specification.  Finally, a window will open listing the names of manufacturers that have agreed to create products that meet the CBEA specification."]

{"sheet":"Dropdowns","index":3,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Dropdowns Tab",null,null,"Yes_No","Phase","Insulation","Temp","Sound","Enclosure","Frequency","Warranty",null,"Primary Single","Primary Three","Secondary Single","Secondary Three",null,"kVA Single","kVA Three"]
[null,null,null,"Select a response","Select a value","Select a value","Select a value","Select a value","Select a value","Select a value","Select a value",null,"Select a value","Select a value","Select a value","Select a value",null,"Select a value","Select a value"]
[null,null,null,"Yes","Single",220,150,"NEMA ST-20","NEMA/UL - 1",60,1,null,208,208,"120/240","208Y/120",null,15,15]
[null,null,null,"No","Three",200,130,"Other","NEMA/UL - 2","Other",5,null,240,240,"Other","240 Delta",null,25,30]
[null,null,null,null,null,"Other",115,"n/a","NEMA/UL - 3","n/a","Other",null,277,480,"n/a","480Y/277",null,37.5,45]
[null,null,null,null,null,"n/a",80,null,"NEMA/UL - 3R",null,"n/a",null,416,600,null,"600Y/347",null,50,75]
[null,null,null,null,null,null,"Other",null,"NEMA/UL - 4",null,null,null,480,"Other",null,"Other",null,75,112.5]
[null,null,null,null,null,null,"n/a",null,"NEMA/UL - 4X",null,null,null,600,"n/a",null,"n/a",null,100,150]
[null,null,null,null,null,null,null,null,"Other",null,null,null,"Other",null,null,null,null,167,225]
[null,null,null,null,null,null,null,null,"n/a",null,null,null,"n/a",null,null,null,null,250,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,333,500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Single",null,null,null,"Three"]
["Conditionals",null,null,"Primary",null,"Secondary",null,"kVA",null,"kVA","Efficiency","NLL",null,"kVA","Efficiency","NLL"]
[null,null,null,"Select a value",null,"Select a value",null,"Select a value",null,15,98.39,40,null,15,98.4,35]
[null,null,null,{"$f":"IF(Type=\"Single\",M3,IF(Type=\"Three\",N3,\"\"))","v":""},null,{"$f":"IF(Type=\"Single\",O3,IF(Type=\"Three\",P3,\"\"))","v":""},null,{"$f":"IF(Type=\"Single\",R3,IF(Type=\"Three\",S3,\"\"))","v":""},null,25,98.6,55,null,30,98.65,60]
[null,null,null,"",null,{"$f":"IF(Type=\"Single\",O4,IF(Type=\"Three\",P4,\"\"))","v":""},null,"",null,37.5,98.74,75,null,45,98.78,80]
[null,null,null,"",null,{"$f":"IF(Type=\"Single\",O5,IF(Type=\"Three\",P5,\"\"))","v":""},null,"",null,50,98.81,90,null,75,98.93,120]
[null,null,null,"",null,{"$f":"IF(Type=\"Single\",\"\",IF(Type=\"Three\",P6,\"\"))","v":""},null,"",null,75,98.95,120,null,112.5,99.03,160]
[null,null,null,"",null,{"$f":"IF(Type=\"Single\",\"\",IF(Type=\"Three\",P7,\"\"))","v":""},null,"",null,100,99.02,150,null,150,99.1,190]
[null,null,null,"",null,{"$f":"IF(Type=\"Single\",\"\",IF(Type=\"Three\",P8,\"\"))","v":""},null,"",null,167,99.09,230,null,225,99.4,200]
[null,null,null,{"$f":"IF(Type=\"Single\",M9,IF(Type=\"Three\",\"\",\"\"))","v":""},null,null,null,{"$f":"IF(Type=\"Single\",R9,IF(Type=\"Three\",S10,\"\"))","v":""},null,250,99.16,315,null,300,99.44,230]
[null,null,null,{"$f":"IF(Type=\"Single\",M10,IF(Type=\"Three\",\"\",\"\"))","v":""},null,null,null,{"$f":"IF(Type=\"Single\",R10,IF(Type=\"Three\",S11,\"\"))","v":""},null,333,99.23,385,null,500,99.51,330]
[null,null,null,null,null,null,null,{"$f":"IF(Type=\"Single\",R11,IF(Type=\"Three\",S12,\"\"))","v":""},null,null,null,null,null,750,99.56,450]
[null,null,null,null,null,null,null,{"$f":"IF(Type=\"Single\",\"\",IF(Type=\"Three\",S13,\"\"))","v":""},null,null,null,null,null,1000,99.59,550]
[]
[null,null,null,null,null,null,null,null,null,"Size","Efficiency","NLL",null,"Size","Efficiency","NLL"]
[null,null,null,null,null,null,null,null,null,{"$f":"Capacity","v":"Select a value"},{"$f":"VLOOKUP(J32,J19:L27,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J32,J19:L27,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"Capacity","v":"Select a value"},{"$f":"VLOOKUP(N32,N19:P29,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N32,N19:P29,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,"No-Load Loss "]
[null,null,null,null,null,null,null,null,null,"Single","Three"]