Electrical Engineering With Excel - Thermal Materials Selector

Welcome to electrical engineering with Excel. In this video, we will take the spreadsheet we made, for semiconductor thermal calculations, a step further. Instead of manual inputs for the heatsink, and thermal interface material resistances, we will make a drop-down list selector, that calculates or selects the resistances from tables. It uses the powerful features of Excel tables. 00:00 Intro 00:38 Heatsink Specification Graph 01:22 Forced Air Kinear Temperature Rise 02:39 Excel Table Basics - Structured References 04:00 Making a Table 04:25 Table Design Tab 04:55 Expanding the Table 05:35 Selecting Columns and Datasets 06:15 Heasink Coefficients Table 06:48 Making a Dynamic Drop-Down Selector 08:07 Using the INDIRECT Function in Data Validation 08:31 Polynomial Formula for Heatsink Thermal Resistance 11:25 Device Thermal Surfaces Calculation - TO-3 & TO-220 13:46 Thermal Interface Materials Table 18:22 Thermal Interface Materials Drop-Down Selector 20:35 Hyperlinks to Manufacturer's Datasheets 21:27 Protecting the Sheet