[time-nuts] Plotting csv files

[SAIDJACK at aol.com]

Thanks for the hint Ulrich, I will try that!

Said
 
 
In a message dated 5/11/2008 04:03:29 Pacific Daylight Time,  
df6jb at ulrich-bangert.de writes:

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.
>  


_______________________________________________
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)