¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io

Re: spreadsheet for importing snp files, Excel 2010


 

Hello Rich:

As a kid in the 50s, I was K1CJO, one end of whose single wire fed windom was actually suspended by a tree that eventually fell into the Piscataqua River in Eliot, Maine, to the delight of the neighbors, with whom I had WATV sets.

In any event, rainy day in Sausalito led me back into your spread sheet, and noticed an errata I pass along.

Your cell ¡°M4¡± states value of RLdB = 35.9176dB

Formula for cell ¡°M4¡± shows = 20 x log10 (0.16), which actually calculates to 20 x (-0.79588) = -15.917 dB

If you were trying to show Return Loss, that would be calculated by:

RL dB = 20 log10(1/rho) or 20log10(1/ Is11I)

using your cells

RL dB = 20 log10(1/G4 or 1/M4)
= 20 x log10( 1/.33735) = 20 x log10(2.9643)= 9.438 dB

Small fix.

Plants like the rain.

73

Ed McCann
AG6CX

Join [email protected] to automatically receive all group messages.