Electrical Engineering With Excel - Foolproofing Excel Engineering Workbooks

Welcome to electrical engineering with Excel. Can you really make an Excel workbook foolproof? Well, not entirely. But we can do our best, at insuring that the formulas are protected, and that Excel’s data validation tool is used, to make sure the user is restricted to inputs, that are within the allowable limits. This video applies data validation to the previously developed workbook for the LM117 amd LM317 voltage regulator calculator. Download the Excel workbook: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/11ee3c94e44660b12ae5e7f6668a9836fc139f4e/LM117%20Voltage%20Regulator%20Calculator.xlsm 00:00 Intro 00:30 Evolution of the Electrical Engineering with Excel Workbooks 03:16 Restrictions of Input and Output Voltages 04:24 Basics of Data Validation 07:50 Using Logic Functions for Multi-Level Data Validation on Input and Output Voltages 10:34 Making a Meaningful Error Alert 11:38 Resistor Set Current Data Validation 13:08 Load Current Data Validation 14:18 Correcting VBA Code for E-Series with a Zero Input 15:57 Pasting Into Input Cell Wipes Out Data Validation 16:25 Cell Notes 17:47 Worksheet Protection