{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["EI Transformer WorkSheet","EI Core Selector"],"read":"whole","date_system":"1900"}

{"sheet":"EI Transformer WorkSheet","index":0,"n_rows":48,"n_cols":7,"rows_kept":48}
["EI Transformer work sheet",null,null,"UM Inch",null,"Instructions: Enter transformer specifications into cells B3-B8"]
[{"$nulls":5},"Enter Secondary full load voltage in B30"]
["Freq Low",60,"Hz","Lowest Working Frequency"]
["Freq Hi",60,"Hz","Info only"]
["Primary Volts",120,"Vrns","Input voltage"]
["Output VA",75,"VA","Sum VA’s of all secondaries"]
["Core Bmax Tesla's",{"v":1,"d":"1.00"},"T","From Material spec"]
["Efficiency %",85,"%","85% typical unless you have better est."]
["Core",{"$f":"INDEX('EI Core Selector'!A1:I12,(MATCH(B6,'EI Core Selector'!F2:F12,1)+1),2)","v":"EI 100 (1 inch tongue)"},null,"EI core designation",null,"Core selecton based on VA @ 60 Hz"]
["Tongue Width in. (TW)",{"$f":"INDEX('EI Core Selector'!A1:I12,(MATCH(B6,'EI Core Selector'!F2:F12,1)+1),3)","v":1},"in","EI Tongue Width in inches"]
["Stack  height Mult Factor",{"$f":"INDEX('EI Core Selector'!A1:I12,(MATCH(B6,'EI Core Selector'!F2:F12,1)+1),4)","v":{"v":2,"d":"2.000"}},null,"0.5, 1, 1.5 2 Multipliers X Tongue width"]
["Stack Height inches",{"$f":"B10*B11","v":{"v":2,"d":"2.000"}},"in"]
["Input VA",{"$f":"(B6 / (B8/100))","v":{"v":88.23529411764706,"d":"88"}},"VA",null,null,"For mutiple secondaries: Enter each secondary voltage one at a time."]
["Average VA",{"$f":"(B6+B13) / 2","v":{"v":81.61764705882354,"d":"82"}},"VA",null,null,"record the number of turns. The cmil's shown in B18 must be  > 3 * the total for"]
["Input Amps",{"$f":"B13 / B5","v":{"v":0.7352941176470588,"d":"0.74"}},"A",null,null,"all the windings cmil requirements totaled together. (each is turns * wire cmil"]
["Tongue  Area in², M²",{"$f":"B10 * (B10 *B11)","v":2},"in²",{"$f":"B16 * 0.0006452","v":0.0012904},"M²","from table) So, you must decide the correct wire size for each secondary based on "]
["Avg Len / Turn in.",{"$f":"2*((1.25 * B10) + ((B11 * B10)+ 0.25 * B10))","v":7},"in",null,null,"it's current requirement. I use 500 cmil/amp as a resonable vaue to select wire size"]
["Winding Area cmil",{"$f":" (1500 * B10) * (500 * B10)","v":750000},"cmil",null,null,"Make sure the sum of cmil's for all secondaries + Primary does not exceed"]
["Primary turns",{"$f":" B5 / (4.44 * B3 * D16 * B7)","v":{"v":349.07815440983444,"d":"349"}},"Turns",null,null,"33% of the value in B18"]
["Pri wire size cmil, Ga, %Fill",{"$f":"B15*500","v":{"v":367.6470588235294,"d":"368"}},"cmil",{"$f":"ROUND(-39*((LOG(B21/5) /LOG(92)))+ 36, 0)","v":24},"Ga",{"$f":"(B20*B19)/B18","v":{"v":0.17111674235776198,"d":"17.11%"}},"Fill"]
["Pri Wire Dia Mils",{"$f":"ROUNDDOWN((B20^0.5), 0)","v":19},"mil"]
["Pri wire len Feet",{"$f":"(B19 * B17 /12)","v":{"v":203.62892340573674,"d":"204"}},"Ft",null,{"$f":"(B18 / 6) / B19","v":358.08600000000007}]
["Ohms / 1000ft",{"$f":"1000 * 10.4/B21^2","v":{"v":28.808864265927976,"d":"28.809"}},"Ω/1000Ft",null,{"$f":"600*(B13/ B5)","v":441.17647058823525}]
["Primary Resistance",{"$f":"(B19*B23) *( B17 /12) / 1000","v":{"v":5.866318015012915,"d":"5.87"}},"Ω","`"]
["Input Voltage Drop",{"$f":"B15*B24","v":{"v":4.313469128685966,"d":"4.31"}},"V"]
["Effective input voltage",{"$f":"B5-B25","v":{"v":115.68653087131403,"d":"115.69"}},"V"]
["Primary wire current rating",{"$f":"B20 / 500","v":{"v":0.7352941176470588,"d":"0.74"}},"A"]
["Pri wire Lbs/1000 ft",{"$f":"0.003028 * B21^2","v":{"v":1.093108,"d":"1.09"}},"Lbs/1000Ft"]
["Pri wire Lbs rqd.",{"$f":"(B28 *B22) /1000","v":{"v":0.22258840520619808,"d":"0.22"}},"Lbs."]
[]
["Secondary FL voltage",15,"Vrms","Desired full load output voltage"]
["Open circuit Sec voltage",{"$f":"B5 * (B41 / B19)","v":{"v":16.122464064000003,"d":"16.12"}},"Vrms","Open circuit voltage: No load output = Input voltage * final turns ratio"]
["Pre Estimate Secondary Turns",{"$f":"B31 / (B26 / B19)","v":{"v":45.26172819523879,"d":"45.26"}},"DO NOT USE, INTERNAL VALUE BEFORE Vdrop CALCULATION"]
["Sec Wire Size cmil, Ga, %Fill",{"$f":"B39*500","v":2500},"cmil",{"$f":"ROUND(-39*((LOG(B35/5) /LOG(92)))+ 36, 0)","v":16},"Ga",{"$f":" (B34*B33)/B18","v":{"v":0.15087242731746262,"d":"15.09%"}},"Fill"]
["Secondary wire Dia.",{"$f":"ROUNDDOWN((B34^0.5), 0)","v":50},"mils"]
["Sec wire Len Feet",{"$f":"(B33*B17) / 12","v":{"v":26.40267478055596,"d":"26"}},"Ft"]
["Sec wire Ohms / 1000ft",{"$f":"1000 * 10.4/B35^2","v":{"v":4.16,"d":"4.160"}},"Ω/1000Ft"]
["Secondary Resistance",{"$f":"(B33*B37) *( B17 /12) / 1000","v":{"v":0.10983512708711281,"d":"0.110"}},"Ω"]
["Secondary Amps",{"$f":"B6 / B31","v":{"v":5,"d":"5.00"}},"A"]
["Secondary Voltage Drop",{"$f":"B39*B38","v":{"v":0.549175635435564,"d":"0.55"}},"V"]
["Final Sec Turns",{"$f":"ROUND((B31 + B40)/ (B26 / B19), 1 )","v":46.9},"Turns ","Corrected for Primary and Secondary voltage drop under full load"]
["Sec wire current rating",{"$f":"B34/500","v":{"v":5,"d":"5.00"}},"A"]
["Sec wire Lbs/1000 ft",{"$f":"0.003028 * B35^2","v":{"v":7.569999999999999,"d":"7.570"}},"Lbs/1000Ft"]
["Sec wire Lbs rqd.",{"$f":"(B36 * B43) /1000","v":{"v":0.1998682480888086,"d":"0.20"}},"Lbs"]
["Total Fill Pri and Sec",{"$f":"F34+F20","v":{"v":0.3219891696752246,"d":"32.20%"}},"Fill, Best to keep less than 33%"]
["Total I²R power loss at full load",{"$f":"(B39^2*B38)+(B15^2*B2)","v":{"v":2.7458781771778202,"d":"2.7"}},"Watts"]
["Estimated Core loss",{"$f":"INDEX('EI Core Selector'!A1:M12,(MATCH(B6,'EI Core Selector'!F2:F12,1)+1),13)","v":6},"Watts @ 60 Hz"]
["Estimated Total Loss",{"$f":"B46+B47","v":{"v":8.74587817717782,"d":"8.7"}},"Watts @ 60 Hz"]

{"sheet":"EI Core Selector","index":1,"n_rows":16,"n_cols":13,"rows_kept":16}
["Index","US Lamination","Tongue Width","Height Mult","Stack Height in","40C° 60Hz VA Range","A Inch²","N for B = 1Tesla","N for B = 1.176 Tesla","VA/In³","Max %Fill","Core Wt LBS","Core Loss Watts"]
[1,"EI 100 (1 inch tongue)",1,0.5,{"v":0.5,"d":"0.500"},0,{"$f":"C2*E2","v":{"v":0.5,"d":"0.50"}},1513,1286,{"$f":"F3/((2.5*C2)*(3*C2)*(E2))","v":{"v":5.066666666666666,"d":"5"}},33,{"v":0.8,"d":"0.80"},1.5]
[2,"EI 100 (1 inch tongue)",1,1,{"v":1,"d":"1.000"},19,{"$f":"C3*E3","v":{"v":1,"d":"1.00"}},756,643,{"$f":"F4/((2.5*C3)*(3*C3)*(E3))","v":{"v":5.2,"d":"5"}},33.8,{"v":1.6,"d":"1.60"},{"v":3,"d":"3.0"}]
[3,"EI 100 (1 inch tongue)",1,1.5,{"v":1.5,"d":"1.500"},39,{"v":1.5,"d":"1.50"},504,429,{"v":5.2444444444444445,"d":"5"},33.6,{"v":2.4,"d":"2.40"},4.5]
[4,"EI 100 (1 inch tongue)",1,2,{"v":2,"d":"2.000"},59,{"v":2,"d":"2.00"},378,322,{"v":5.2,"d":"5"},33.3,{"v":3.2,"d":"3.20"},{"v":6,"d":"6.0"}]
[5,"EI 175 (1.75 in tongue)",1.75,1,{"v":1.75,"d":"1.750"},78,{"v":3.0625,"d":"3.06"},247,210,{"v":8.70748299319728,"d":"9"},31.85,8.67,6.5]
[6,"EI 175 (1.75 in tongue)",1.75,1.5,2.625,350,{"v":4.59375,"d":"4.59"},164,140,{"v":8.044055717525104,"d":"8"},30.27,{"v":13,"d":"13.00"},{"v":9.75,"d":"9.8"}]
[7,"EI 175 (1.75 in tongue)",1.75,2,{"v":3.5,"d":"3.500"},485,{"v":6.125,"d":"6.13"},124,105,{"v":8.956268221574344,"d":"9"},29.37,17.34,{"v":13,"d":"13.0"}]
[8,"EI 300 (3.00 in tongue)",3,1,{"v":3,"d":"3.000"},720,{"v":9,"d":"9.00"},{"$f":" 130 / (4.44 * 60 *(G9 * 0.0006452) * 1)","v":{"v":84.03733346903422,"d":"84"}},{"$f":" 130 / (4.44 * 60 *(G9 * 0.0006452) * 1.176)","v":{"v":71.46031757570937,"d":"71"}},{"v":13.333333333333334,"d":"13"},29.4,43.78,{"v":33,"d":"33.0"}]
[9,"EI 300 (3.00 in tongue)",3,1.5,{"v":4.5,"d":"4.500"},2700,{"v":13.5,"d":"13.50"},{"$f":" 130 / (4.44 * 60 *(G10 * 0.0006452) * 1)","v":{"v":56.02488897935615,"d":"56"}},{"$f":" 130 / (4.44 * 60 *(G10 * 0.0006452) * 1.176)","v":{"v":47.640211717139586,"d":"48"}},{"v":13.168724279835391,"d":"13"},28.35,65.68,{"v":50,"d":"50.0"}]
[10,"EI 300 (3.00 in tongue)",3,2,{"v":6,"d":"6.000"},4000,{"v":18,"d":"18.00"},{"$f":" 130 / (4.44 * 60 *(G11 * 0.0006452) * 1)","v":{"v":42.01866673451711,"d":"42"}},{"$f":" 130 / (4.44 * 60 *(G11 * 0.0006452) * 1.176)","v":{"v":35.730158787854684,"d":"36"}},{"v":12.345679012345679,"d":"12"},27.96,87.56,{"v":65,"d":"65.0"}]
[11,"Out Of Range","ERROR!",2,{"v":8,"d":"8.000"},5000,{"v":32,"d":"32.00"},0,0,{"$error":"#VALUE!"},26.19]
[]
[]
[]
[{"$nulls":5},"VA Range examples: 0 is 0 to < 19 VA, 19 is 19 to < 39 VA"]