Electrical Engineering With Excel Best Fit Voltage Divider (4k Video)
Best Fit Voltage Divider (4k Video) Transcript and Lesson Notes
Welcome to electrical engineering with Excel. In this video, we will look at some Visual Basic for Applications user defined code in Excel, to select the best fit resistor values for a voltage divider. This is only for t
Quick Summary
Welcome to electrical engineering with Excel. In this video, we will look at some Visual Basic for Applications user defined code in Excel, to select the best fit resistor values for a voltage divider. This is only for t
Key Takeaways
- Review the core idea: Welcome to electrical engineering with Excel. In this video, we will look at some Visual Basic for Applications user defined code in Excel, to select the best fit resistor values for a voltage divider. This is only for t
- Understand how Voltage Divider fits into Best Fit Voltage Divider (4k Video).
- Understand how Best Fit Voltage Divider fits into Best Fit Voltage Divider (4k Video).
- Understand how Visual Basic for Applications fits into Best Fit Voltage Divider (4k Video).
- Understand how Excel User Defined Function fits into Best Fit Voltage Divider (4k Video).
Key Concepts
Full Transcript
Welcome to electrical engineering with Excel. In this video, we will look at some Visual Basic for Applications user defined code in Excel, to select the best fit resistor values for a voltage divider. This is only for the selection of 1% tolerance resistors. Although 1% tolerance is good, arbitrary selection of values can result in the divider’s output being less precise than it could be. Let me show you an example. Link to spreadsheet on Github https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/bf59e721a6ed7855480cf1572ab5eadb77a68db2/Best%20Fit%20Voltage%20Divider.xlsm 00:00 Intro 00:39 Divider Example 02:38 E96 Series Math Review 04:37 Scanning of Resistor Values 05:21 The Code 12:20 Spreadsheet Demo
Lesson FAQs
What is Best Fit Voltage Divider (4k Video) about?
Welcome to electrical engineering with Excel. In this video, we will look at some Visual Basic for Applications user defined code in Excel, to select the best fit resistor values for a voltage divider. This is only for t
What key concepts are covered in this lesson?
The lesson covers Voltage Divider, Best Fit Voltage Divider, Visual Basic for Applications, Excel User Defined Function.
What should I learn before Best Fit Voltage Divider (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: Voltage Divider, Best Fit Voltage Divider, Visual Basic for Applications, Excel User Defined Function.
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.
