![[OBSOLETE] Closest E-Series Preferred Number - User Defined Function](https://i.ytimg.com/vi/WvESH9DNRQU/hqdefault.jpg)
Electrical Engineering With Excel [OBSOLETE] Closest E-Series Preferred Number - User Defined Function
[OBSOLETE] Closest E-Series Preferred Number - User Defined Function Transcript and Lesson Notes
OBSOLETE See: https://youtu.be/XgbEajDoYTc Welcome to electrical engineering with Excel. In the previous video, we wrote some VBA code, to select the closest standard component value, from the E96 series. In this video,
Quick Summary
OBSOLETE See: https://youtu.be/XgbEajDoYTc Welcome to electrical engineering with Excel. In the previous video, we wrote some VBA code, to select the closest standard component value, from the E96 series. In this video,
Key Takeaways
- Review the core idea: OBSOLETE See: https://youtu.be/XgbEajDoYTc Welcome to electrical engineering with Excel. In the previous video, we wrote some VBA code, to select the closest standard component value, from the E96 series. In this video,
- Understand how Excel fits into [OBSOLETE] Closest E-Series Preferred Number - User Defined Function.
- Understand how E-series preferred numbers fits into [OBSOLETE] Closest E-Series Preferred Number - User Defined Function.
- Understand how Electrical Engineering fits into [OBSOLETE] Closest E-Series Preferred Number - User Defined Function.
- Understand how Component Values fits into [OBSOLETE] Closest E-Series Preferred Number - User Defined Function.
Key Concepts
Full Transcript
OBSOLETE See: https://youtu.be/XgbEajDoYTc Welcome to electrical engineering with Excel. In the previous video, we wrote some VBA code, to select the closest standard component value, from the E96 series. In this video, we will expand that code, to make it work for the entire group, of E-series preferred numbers, for standard component values. Electrical Engineering Excel E-series Components E series Components Standard Component Value Standard Components Value Download the VBA Code: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/fa21891f0472fbc0c4c85f2b5368210579e77679/E-Series%20User%20Defined%20Function%20Code.txt Download the Spreadsheet: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/fa21891f0472fbc0c4c85f2b5368210579e77679/E-series%20UDF.xlsm 0:00 Intro 0:33 E96 Code 1:01 Overview of E-Series Exceptions 2:33 E48 - E182 Series 3:04 Writing the Code 4:56 Use in Excel
Lesson FAQs
What is [OBSOLETE] Closest E-Series Preferred Number - User Defined Function about?
OBSOLETE See: https://youtu.be/XgbEajDoYTc Welcome to electrical engineering with Excel. In the previous video, we wrote some VBA code, to select the closest standard component value, from the E96 series. In this video,
What key concepts are covered in this lesson?
The lesson covers Excel, E-series preferred numbers, Electrical Engineering, Component Values.
What should I learn before [OBSOLETE] Closest E-Series Preferred Number - User Defined Function?
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: Excel, E-series preferred numbers, Electrical Engineering, Component Values.
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.
