Electrical Engineering With Excel - Engineering Prefixes for Capacitors OBSOLETE

OBSOLETE Replaced by https://youtu.be/I2EbuI0_Zds Welcome to electrical engineering, with Excel. This video is about developing user defined Visual Basic for Applications (VBA) code, for returning the desired SI engineering prefix, for capacitors. In a previous video, I showed how to write VBA that takes in an number, and returns a text string with the number scaled to the applicable value and appended with the associated SI prefix letter. Since capacitors are rarely denoted or labeled as millifarad or nanofarad, the user defined function was not very useful for capacitors. The function generated in this video only returns pico or micro, in various ways that make be in line with the capacitor manufacturers you use. Link to code: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/c9f73b38e4279a098f782d52d714b95d53fd1a94/Engineering%20Prefixes%20for%20Capacitors%20CODE.txt 00:00 Intro 00:24 Previously Generated VBA for Engineering Prefixes 01:35 Capacitors are Usually in Picofarads or Microfarads. 01:55 Capacitor Datasheet Review 02:47 Why Only µF and pF? 04:08 Argument Definitions 05:21 Writing the Code 07:28 Use in the Spreadsheet