Electrical Engineering With Excel - Creating Excel User Defined Functions - American Wire Gauge

Welcome to electrical engineering - with Excel. This is a series of videos, to help you make Excel workbooks, for various electrical engineering problems, and circuit calculators. This is an introduction to creating user defined functions. The first one will be very simple, and in later videos, we will develop more complicated user defined functions. This covers the development of functions that returns the diamter and resistance of a specific wire gauge input. Excel Electrical Engineering American Wire Gauge Download VBA Code https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/main/American-Wire-Gauge-VBA-code.txt 0:00 Intro 0:39 What is a User Defined Function? 1:24 The American Gauge (AWG) 2:15 Characteristics of the American Wire Gauge (AWG) 3:38 Add Developer Tab, Visual Basic Editor, and Inserting a VBA Module 4:17 Write the VBA for the Unser Defined Function is AWG Diameter 6:30 Paste Code in Editor 7:19 Resistivity 9:10 Circular Mils 11:45 Resistance Calculation Using Circular Mils and Feet 12:26 VBA Code for the AWG Resistance 12:55 Using the AWG Resistance Function 13:22 Stranded Wire