Electrical Engineering With Excel - Intro to Electrical Engineering With Excel - LM117 Voltage Regulator Calculator

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

Electrical Engineering Excel Microsoft Excel LM117 LM317 Engineering Notation Cell Names Cell styles Cell protection Circuit Calculator engineering with excel excel cell protection

Full Transcript

Welcome to electrical engineering - with Excel. This is the first in a series of videos, to help you make excel workbooks, for electrical engineering tasks, and circuit calculators. This video is intended to be, a very simple basic circuit calculator, that will calculate the set resistors for the ubiquitous LM117 3-terminal positive series linear voltage regulator. In later videos, we will add functions to this workbook, to expand its capability. Excel electrical engineering 00:00 Intro 00:57 Maze of Cell References 01:36 Excel Engineering Calculator Workbooks 04:33 Keyboard Shortcuts 04:56 Engineering Notation 06:27 LM117 LM317 Datasheet and Equations 09:24 Initial Spreadsheet 10:09 Enter Notation & Subscripts 11:30 Cell Naming With Create From Selection 12:56 Inputs & Writing Formulas 14:11 Cell Styles 16:27 Engineering Notation and Insert Special Characters 17:19 What's Next?