Electrical Engineering With Excel Engineering Prefix Function for Excel NEW (4k Video)
Engineering Prefix Function for Excel NEW (4k Video) Transcript and Lesson Notes
Welcome to Electrical Engineering with Excel. Several years ago, I developed some Visual Basic for Applications Code, for a User Defined Function, that would take in a number, and return a text version, scaled to the app
Quick Summary
Welcome to Electrical Engineering with Excel. Several years ago, I developed some Visual Basic for Applications Code, for a User Defined Function, that would take in a number, and return a text version, scaled to the app
Key Takeaways
- Review the core idea: Welcome to Electrical Engineering with Excel. Several years ago, I developed some Visual Basic for Applications Code, for a User Defined Function, that would take in a number, and return a text version, scaled to the app
- Understand how Electrical Engineeering fits into Engineering Prefix Function for Excel NEW (4k Video).
- Understand how SI Units fits into Engineering Prefix Function for Excel NEW (4k Video).
- Understand how SI Prefixes fits into Engineering Prefix Function for Excel NEW (4k Video).
- Understand how Excel User Defined Functions fits into Engineering Prefix Function for Excel NEW (4k Video).
Key Concepts
Full Transcript
Welcome to Electrical Engineering with Excel. Several years ago, I developed some Visual Basic for Applications Code, for a User Defined Function, that would take in a number, and return a text version, scaled to the appropriate engineering prefix level, with the SI prefix appended. I then wrote similar code, to do the same for capacitor values, since they rarely use the SI prefixes nano and milli. I have now decided to consolidate both of those features, into one User Defined Function. The VBA Code is available with a link in the description. Link to VBA Code https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/c05174caf75cf1e4d97e00c071c801b6684abeea/VBA%20Code%20-%20ENGPREFIX%20Function.txt Syntax https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/c05174caf75cf1e4d97e00c071c801b6684abeea/ENGPREFIX%20Syntax.pdf 00:00 Intro 02:40 SI Units 06:24 Using Log Base 1000 09:36 Visual Basic LOG Function is Base "e"!! 12:12 Capacitors Rarely Nano Rarely Milli 13:12 Syntax 15:30 Spaces & Rounding 17:17 Arguments 21:02 Visual Basic Coding Correction: 8:58 Should be 1.432 not 1.434
Lesson FAQs
What is Engineering Prefix Function for Excel NEW (4k Video) about?
Welcome to Electrical Engineering with Excel. Several years ago, I developed some Visual Basic for Applications Code, for a User Defined Function, that would take in a number, and return a text version, scaled to the app
What key concepts are covered in this lesson?
The lesson covers Electrical Engineeering, SI Units, SI Prefixes, Excel User Defined Functions.
What should I learn before Engineering Prefix Function for Excel NEW (4k Video)?
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 Engineeering, SI Units, SI Prefixes, Excel User Defined Functions.
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.
