Hi Ken, I do not know if digital multipliers an dividers can divide by more complex schemes than N/R ! But this would be a nice enhancement to identify any possibilities. However, by specifying both N and R to range from 1-10 you get 100 possible results (with some duplicates), so the tool will lose usefulness for larger values of N and R. I think that a matrix will give best results, together with a 2 -dimensional lookup function comparing the results in the matrix with a large array of common crystal frequencies....? A second array with the present crystal frequencies to be put in (4-5) ?
Note that a offending crystal can easily be identified with a receiver using SSB demodulation (and a speaker) and a cold spray.... Upon cooling the offending crystal oscillator the drift will be heard very clearly. Hey, now I got you something to do ;<))) Regards, Ing. Gert Gremmen, BSc [email protected] www.cetest.nl Kiotoweg 363 3047 BG Rotterdam T 31(0)104152426 F 31(0)104154953 Before printing, think about the environment. Van: Ken Wyatt [mailto:[email protected]] Verzonden: Thursday, February 20, 2014 4:18 PM Aan: ce-test, qualified testing bv - Gert Gremmen Onderwerp: Re: [PSES] Harmonic analyzer tool Hi Gert, that's a good idea. Is the equation always "N/R"? If so, it might be easiest to create a second spreadsheet with a calculated column of divisors (=N/R). Thanks for the idea. Cheers, Ken _______________________ Kenneth Wyatt Wyatt Technical Services LLC 56 Aspen Dr. Woodland Park, CO Phone: (719) 310-5418 Email Me! | Web Site | Blog The EMC Blog (EDN) Subscribe to Newsletter Connect with me on LinkedIn On Feb 20, 2014, at 2:03 AM, ce-test, qualified testing bv - Gert Gremmen <[email protected]> wrote: Hi Ken, Nice tool, but i am missing something. More an more often microprocessors can multiply external oscillators with an arbitrary number for internal operation, and sometimes even with N/R where N and R are arbitrary integers. Have you thought of that in your sheet ? May I invite you to enhancing your sheet with N and R ??? Regards, Ing. Gert Gremmen, BSc Van: Ken Wyatt [mailto:[email protected]] Verzonden: Thursday, February 20, 2014 12:53 AM Aan: [email protected] Onderwerp: [PSES] Harmonic analyzer tool Hi All, I just posted details on a simple crystal oscillator harmonic analyzer tool: http://www.edn.com/electronics-blogs/the-emc-blog/4428570/Harmonic-analyzer-tool The blog posting has a link to download the spreadsheet. Cheers, Ken _______________________ Kenneth Wyatt Wyatt Technical Services LLC 56 Aspen Dr. Woodland Park, CO Phone: (719) 310-5418 Email Me! | Web Site | Blog The EMC Blog (EDN) Subscribe to Newsletter Connect with me on LinkedIn - ---------------------------------------------------------------- This message is from the IEEE Product Safety Engineering Society emc-pstc discussion list. To post a message to the list, send your e-mail to <[email protected]> All emc-pstc postings are archived and searchable on the web at: http://www.ieee-pses.org/emc-pstc.html Attachments are not permitted but the IEEE PSES Online Communities site at http://product-compliance.oc.ieee.org/ can be used for graphics (in well-used formats), large files, etc. Website: http://www.ieee-pses.org/ Instructions: http://www.ieee-pses.org/list.html (including how to unsubscribe) List rules: http://www.ieee-pses.org/listrules.html For help, send mail to the list administrators: Scott Douglas <[email protected]> Mike Cantwell <[email protected]> For policy questions, send mail to: Jim Bacher <[email protected]> David Heald <[email protected]> - ---------------------------------------------------------------- This message is from the IEEE Product Safety Engineering Society emc-pstc discussion list. To post a message to the list, send your e-mail to <[email protected]> All emc-pstc postings are archived and searchable on the web at: http://www.ieee-pses.org/emc-pstc.html Attachments are not permitted but the IEEE PSES Online Communities site at http://product-compliance.oc.ieee.org/ can be used for graphics (in well-used formats), large files, etc. Website: http://www.ieee-pses.org/ Instructions: http://www.ieee-pses.org/list.html (including how to unsubscribe) List rules: http://www.ieee-pses.org/listrules.html For help, send mail to the list administrators: Scott Douglas <[email protected]> Mike Cantwell <[email protected]> For policy questions, send mail to: Jim Bacher: <[email protected]> David Heald: <[email protected]>
