Summary

Keywords

Wire Temperature Rise Calculation American Wire Gauge Wire Bundle Factors

Full Transcript

This video takes a paper chart for the estimated temperature rise of a wire, digitizes it, and generates trendlines in Excel charts. Those trendlines are used to create a formula that can be used to calculate the wire gauge for a specified current and allowable temperature rise. An Excel worksheet is constructed to do the calculation. At timestamp 15:16, I should have already made a table out of the bundle factors. This caused the bundle factor XLOOKUP arrays to be relative cell references instead of table structured references. Download the Excel workbook that calculates the recommended AWG of a wire based on the inputs of current, allowable temperature rise, and number of wires in the bundle. https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/a40b82223e0bdcc1fc62c0e14047ef9afa1d5c94/Wire%20Temperature%20Rise%20-%20Final.xlsx 00:00 Intro 00:41 Chart-to-Equation-to-Excel 01:22 Wire Gauge Calculation for Negligible Heat Rise 03:14 Wire Temperature Heat Rise Chart 04:40 Digitizing Plots 05:23 Digitized Data With Trendlines 06:40 Formula to Return Gauge 07:43 Comparison of Calculated vs. Graph 08:19 Bundle Factor 08:48 Returning Next Lowest Even Wire Gauges 09:39 Construction of Spreadsheet 10:46 Merge Cell Styles 11:08 Make Table and Assign Cell Styles 11:49 Data Validation of Inputs 14:35 Bundle Count Table & Bundle Factor Calculation 15:58 Wire Gauge Calculation 17:30 Wire Temperature Calculation & Suggested Insulation Types 19:16 Numerical Reference for Aught Gauges and Conditional Formatting for Gauge Cells 20:47 Protecting Worksheet