Electrical Engineering With Excel - New Excel Tips and Tricks - Waveguide Workbook (4k Video)

Welcome to electrical engineering with Excel. This is my 20th video about Excel, and its amazing use in electrical engineering. If you have watched the previous videos in this playlist, you would find various methods of use. This video features some new tips and tricks, you may find useful in your spreadsheets. Since I just finished up 2 videos on waveguides, I decided to use these tips and tricks in a spreadsheet, for waveguide attenuation and power handling. Most of the workbook is already built, and I will preview some of its features first. Then I will introduce some new features. One is about a pesky issue, with a chart’s axis autoscaling, which we will create some visual basic for applications code, to remedy. Another will be the creation of a gauge, that will display the operating frequency range overlaid on the usable waveguide bandwidth. This will use a modified version of the 2D bar chart. Its axis bounds will also be adjusted, with some visual basic code. I’ll also make use of the new Excel FILTER, spill array function. Download workbook https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/01b1e192ea994928053c32458302df05b0dbe76d/Waveguide%20Loss%20%26%20Power%20Handling.xlsm 00:00 Intro 01:19 Waveguide Frequency Range 01:59 Excel Chart Axis Scaling Quirk 04:10 Workbook Overview 11:14 Formatting Attenuation Chart and Apply VBA 12:00 Making A Bandwidth Gauge 19:23 Apply VBA to Bandwidth Gauge 20:00 Filtering Usable Waveguide Sizes and Using FILTER Spill Array