Electrical Engineering With Excel - [OBSOLETE] Computing Standard Component Values - Closest 1% Resistor Value

OBSOLETE See: https://youtu.be/CJQd5WBZfd8 Update 12/13/2022 Welcome to electrical engineering with Excel. In this video we will review the E-series preferred numbers for standard component values. We will also develop a user defined function, to return the closest standard 1% component value, to the value of its input. In a later video, we will develop a function to return the closest component value for any of the e-series preferred values. Excel Electrical Engineering Visual Basic for Applications (VBA) Code for Returning Closest 1% Resistor Value VBA Code https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/dd64b5db0d3b5e2a66fb6fbaacf1b678c68541cb/Closest%201%25%20Standard%20Value%20VBA%20User%20Defined%20Function%20Code.txt 0:00 Intro 0:39 Standardization of Electronic Component Values 1:33 Compute Standard Component Values 2:05 E-Series of Preferred Numbers 2:54 E12 Series of Preferred Numbers 3:31 E96 Series of Preferred Number Math 4:54 Finding Closest Value - Going Backwards 5:58 Get the Base Number Using the Mantissa 7:26 Writing the Code 8:58 What's Next Correction: 8:22 Unmatched parenthesis. Code should be n = Round(Log(rx) / Log(k), 0)