Electrical Engineering With Excel - Best Fit Voltage Divider (4k Video)

5.0 (4)

46 learners

What you'll learn

This course includes

5.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Voltage Divider Best Fit Voltage Divider Visual Basic for Applications Excel User Defined Function

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