[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