Electrical Engineering With Excel Thermal Materials Selector
Thermal Materials Selector Transcript and Lesson Notes
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
Quick Summary
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
Key Takeaways
- Review the core idea: 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
- Understand how Thermal Interface Materials fits into Thermal Materials Selector.
- Understand how Excel Tables fits into Thermal Materials Selector.
Key Concepts
Full Transcript
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
Lesson FAQs
What is Thermal Materials Selector about?
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
What key concepts are covered in this lesson?
The lesson covers Thermal Interface Materials, Excel Tables.
What should I learn before Thermal Materials Selector?
Review the previous lessons in Electrical Engineering With Excel, then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: Thermal Interface Materials, Excel Tables.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
Continue Learning
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
