[time-nuts] Plotting csv files
Ulrich Bangert
df6jb at ulrich-bangert.de
Sun May 11 07:00:35 EDT 2008
Said,
Plotter tries to detect a number of numerical formats on its own. For
that purposes it uses a predeclared set of possible delimiters and
possible decimal separators. And it uses the presence of a
delimiter/separator as well as the absence of a delimiter/separator to
do its job. In your case the absence of anything that smells like a
decimal seperator makes Plotter believe it is an integer to convert and
the integer conversion routine fails due to the "E".
Simple exchange "* u" with".0E-06" and Plotter will understand it. I
know this (terrible) Agilent notation of the 53131/2 very well. The
microcontroller of my GPSDO generates serial messages of that kind on a
second to second basis and also the time interval statistics on a 100
second interval basis to mimic the existence of a HP53132 so that my
GPSDO can be used in conjunction with the TAC32+ version (external TIC
version) for long time analysis without even owning the Agilent counter.
Best regards
Ulrich
> -----Ursprungliche Nachricht-----
> Von: time-nuts-bounces at febo.com
> [mailto:time-nuts-bounces at febo.com] Im Auftrag von SAIDJACK at aol.com
> Gesendet: Freitag, 9. Mai 2008 17:13
> An: time-nuts at febo.com
> Betreff: Re: [time-nuts] Plotting csv files
>
>
> Hi Martyn, Ulrich,
>
> the Plotter utility works really nicely for CSV data.
>
> Ulrich, one question: how can I get plotter to interpret
> scientific notation
> such as 100E-06 etc correctly?
>
> I get data from my 53132A's serial port that looks like this:
>
> 5* u
> 10* u
>
> "10* u" means 100E-06 (the star means not a significant
> digit, the u means
> Micro).
>
> I format this with Wordpad (auto-replace "* u" with 0E-06)
> and the data can
> be used by Excel that way.
>
> But plotter does not seem to recognize "-100E-06" correctly.
>
> How can I make this work?
>
> thanks,
> Said
>
>
> In a message dated 5/8/2008 21:29:05 Pacific Daylight Time,
> df6jb at ulrich-bangert.de writes:
>
> Martyn,
>
> you may consider this:
>
> http://www.ulrich-bangert.de/plotter.zip
>
> Best regards
> Ulrich Bangert
>
> > -----Ursprungliche Nachricht-----
> > Von: time-nuts-bounces at febo.com
> > [mailto:time-nuts-bounces at febo.com] Im Auftrag von Martyn Smith
> > Gesendet: Donnerstag, 8. Mai 2008 10:54
> > An: time-nuts at febo.com
> > Betreff: [?? Probable Spam] [time-nuts] Plotting csv files
> >
> >
> > Hi All,
> >
> > I have an ongoing problem and realized why don't I ask the time
> > nuts!!
> >
> > My frequency and temperature data is usually plotted in a
> > comma separator value (csv) file.
> >
> > I use excel to import and plot the results.
> >
> > Excel only lets me plot 32000 points at a time. I often have
> > over a million samples.
> >
> > Does anyone has some nice software that will easily plot a
> > csv file. I do need to be able to change the vertical scale
> > rather than have it autorange.
> >
> > It doesn't have to be free, but it has to be easy to use.
> > I've never got
> > the time to "learn" how to use new software.
> > Said jackson kindly sent me some software, but I could never
> > get it going.
> >
> > Best Regards
> >
> > Martyn
> >
> >
> >
> >
> > _______________________________________________
> > time-nuts mailing list -- time-nuts at febo.com
> > To unsubscribe, go to
> > https://www.febo.com/cgi-> bin/mailman/listinfo/time-nuts
> > and
> > follow the instructions there.
> >
>
>
> _______________________________________________
> time-nuts mailing list -- time-nuts at febo.com
> To unsubscribe, go to
> https://www.febo.com/cgi-> bin/mailman/listinfo/time-nuts
> and
> follow the instructions there.
>
>
>
>
>
> **************Wondering what's for Dinner Tonight? Get new
> twists on family
> favorites at AOL Food.
> (http://food.aol.com/dinner-tonight?NCID=aolfod00030000000001)
> _______________________________________________
> time-nuts mailing list -- time-nuts at febo.com
> To unsubscribe, go to
> https://www.febo.com/cgi-> bin/mailman/listinfo/time-nuts
> and
> follow the instructions there.
>
More information about the time-nuts
mailing list