[Elecraft] XG1 and Excel

Rick Hampton [email protected]
Sat Jan 17 23:55:01 2004


Hi, Tom.

According to the manual for the XG1, if cell B1 contains the S+N value, and cell B2
contains the N value, then the MDS value will be:

=-107-20*LOG10(B1/B2)

Hope that helps.

Rick Hampton, WD8KEL

Tom Mc wrote:

> Hi gang,
>
>  I received my XG1 the  7.040 MHz Test Oscillator in today's mail!  Although
> I haven't had a chance to start building it yet, I have been reading the
> instructions and it looks pretty neat.
>
> Problem is, and I'll be the first to admit this, that I spent most of my
> time in high school trigonometry class staring at Annmarie Sullivan and
> didn't learn a whole lot when they were explaining logarithms.
>
> So I thought I'd write up a simple Excel routine that would allow me to
> input the "S+N" and the "N" values and walla! Excel would calculate the MDS.
>
> Well, Annmarie notwithstanding, it ain't working.  So I was hoping that some
> of you guys (either those who went to all male high school's or those with
> better willpower than me) could write up a short Excel file and either post
> it someplace or e-mail it to me.
>
> Thanks,
> Tom McCulloch
>     WB2QDG
> K2 s/n 1103