HF Transmitter: RF Preamp version 4C
OK, here are the files that I mentioned in the YouTube episode. The PowerPoint should be straight-forward to follow, as it essentially is in narrative format. The spreadsheet, however, will require you to examine the formulas, but hopefully you can deduce how the calcuations work. Having a copy of Experimental Methods in RF Design (EMRFD) will help, too. Enjoy! Excel Spreadsheet PPT file Schematic