Capstone: Logbook Statistics – Contacts per Band, Evening Openings, the Longest Contact and a Chart
This lesson is part of the course
In this lesson
You summarise Nell's 20 October contacts by band, count the evening contacts per band with COUNTIFS, find the station of the longest contact with INDEX/MATCH and chart the contacts per band.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Frequency and Wavelength: λ = c ÷ f, Half Waves and a Practice Channel Plan Locked
- Antenna Lengths: Half-Wave Dipoles, Quarter-Wave Verticals, End Effect and Trimming Locked
- SWR from the Load: Reflection Coefficient, ABS and the Meter Reading Backwards Locked
- Mismatch Loss: Reflected Power, Decibels with LOG10 and Watts Accepted Locked
- Feedline Loss: dB per 100 m from a Cable Table, Connectors and the Watts That Arrive Locked
- Power Budget: Watts to dBm, dBi vs dBd, Net Gain and Effective Radiated Power Locked
- Grid Locators: Letters and Digits to Longitude and Latitude, and the Distance Between Stations Locked
- Capstone: Logbook Statistics – Contacts per Band, Evening Openings, the Longest Contact and a Chart Locked