Electrical Engineering With Excel Creating Excel User Defined Functions - American Wire Gauge
Creating Excel User Defined Functions - American Wire Gauge Transcript and Lesson Notes
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
Quick Summary
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
Key Takeaways
- Review the core idea: 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
- Understand how electrical engineering fits into Creating Excel User Defined Functions - American Wire Gauge.
- Understand how excel fits into Creating Excel User Defined Functions - American Wire Gauge.
- Understand how user defined functions fits into Creating Excel User Defined Functions - American Wire Gauge.
- Understand how american wire gauge fits into Creating Excel User Defined Functions - American Wire Gauge.
Key Concepts
Full Transcript
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
Lesson FAQs
What is Creating Excel User Defined Functions - American Wire Gauge about?
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
What key concepts are covered in this lesson?
The lesson covers electrical engineering, excel, user defined functions, american wire gauge.
What should I learn before Creating Excel User Defined Functions - American Wire Gauge?
Review the previous lessons in Electrical Engineering With Excel, then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: electrical engineering, excel, user defined functions, american wire gauge.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
Continue Learning
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
