|
Title: Advanced Data Logger to Excel Post by: Delrin5 on April 27, 2009, 06:13:24 PM I am trying to get data from a gram scale into an excel spreadsheet, but I am running into problems.
When I launch the data logger it open Excel like I would expect but when the scale sends data over to it I only get the date into A1 them moving to A2 and so on. What I need to get is the actual weight with a Date/Time stamp in another column say B1 and the weight in A1. I think this may have something to do with my parsing, but I only think this from reading other posts. Please correct me if I am wrong on this assumption, considering I am a total newbie to the Advanced Data Serial Logger tool as I am using the trial version to test if the product will work on the production floor. Here is a snippet of the output from the data logging screen: <20090427094451.645> ST,+00061.55 g#0D#0A <20090427103755.957> ST,+00061.57 g#0D#0A <20090427103758.347> ST,+00061.57 g#0D#0A <20090427103802.238> ST,+00061.57 g#0D#0A Can someone help me out or point me in the right direction on some documentation on how to use the parsing tool? Title: Re: Advanced Data Logger to Excel Post by: Delrin5 on April 27, 2009, 11:23:16 PM To answer my own question.. Thanks for the Demos and Tutorials BTW
Packet beginning = #53#54 Packet Ending = #67 Filter = ASCII 44|',' Remove Character Excel Bind: ASCII Data Packet (w/o framing characters) = A1 Date Date Time Stamp B1 The only problem left is why when the Excel spreadsheet is accidentally closed it does not prompt the user to save or anything, it just closes and when you open it back up the spreadsheet is blank. Anyone have a solution to this issue or is it something more to do with the Excel Version (2000)? Title: Re: Advanced Data Logger to Excel Post by: Arthur Grasin on April 30, 2009, 08:58:23 AM The data export plug-im has corresponding options. Please, look at the attached image.
|