Electrical Engineering With Excel - Comparator Hysteresis Spreadsheet (4k Video)

Welcome to electrical engineering with Excel. This video is about the development, of a spreadsheet, that does the calculations, of resistor values for comparators, with hysteresis. It uses the formulas we derived, in the Comprehensive Comparator Hysteresis Design video. Download at Github: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/b765e075e3aa054e0eb36ff15a403367012eea9b/Comparator%20Hysteresis%20Spreadsheet%20-%20Rev%20B.xlsm 00:00 Introduction 00:32 Comprehensive Hysteresis Design Review 01:24 Previous Spreadsheet Related Videos 03:08 E-Series Selector 03:27 Hyperlinks 04:23 Device Specs Tab 04:59 Various Data Validations For Input Cells 07:00 Resistor Series Selector Drop-Down Box 07:45 Pull-up Resistor Calculation 10:25 Hysteresis Resistor Calculation 11:45 R1 & R2 Calculation 12:43 Hyperlinks 14:52 Sheet Protection Corrections: 08:11 meant to say less than or equal to 1 not less than or equal to zero. 13:50 meant to say hovering over A2 not A1.