=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================
Anyways I created a new version today and even created a Beginner Guide for people to get a better understanding of how PLX DAQ v2 works and how they can start using it. It also lists all commands that are available for Arduino thus even the more experienced users might benefit from that guide
What's new in "Version 2.10" aka Change log:
I wrote a 9 pages long Beginners Guide to PLX DAQ v2 for newbies to get started with the tool.
Extended the CELL,SET command to be able to set cells on other sheets as well (after CELL,GET with version 2.9 )
Syntax is Serial.println("CELL,SET,ONSHEET,SheetName,Column,Row,Value"); ==> e.g., Serial.println("CELL,SET,ONSHEET,Simple Data,E,4,My Test String");
Modified CLEARSHEET command. It will now clear data starting at row 1. So it will clear the whole sheet as its name suggests. To clear only the data I added a new command CLEARDATA . I think the names are less ambiguous now
Updated the default sketch to include the new commands
Backlog for next version(s):
find a solution for Excel crashing when moving the window around while logging. Priority: low ; Workaround: don't move window while logging ; Status: clueless...
solve get cell / set cell mix up reported by jl1cny here . Priority: medium; Workaround: use baud rates smaller 25.000; Status: in contact with Sam SASv directly via email to identify issue. Best guess is an issue in Arduino code with Serial.ParseInt not getting values out of buffer correctly
Double check if both issues above existed in PLX DAQ v1 as well. In case yes => we are screwed
Image-Link: http://www.freebie-base.de/Pics/PLX_DAQ_v2.10.png
(hosted on my server, no traffic hijack)
What's new in "version 2.9" aka Change log:
Extended the CELL,GET command to read cells from other sheets as well.
Syntax is Serial.println("CELL,GET,FROMSHEET,SheetName,Column,Row"); ==> e.g., Serial.println("CELL,GET,FROMSHEET,Simple Data,E,4");
Updated the default sketch to include the new command
What's new in "version 2.8" aka Change log:
fixed an issue with the LABEL command. Columns that should labeled either TIME, TIMER or DATE where translated as well thus the column was not labeled with e.g., DATE but accidentally resolved to current system date (e.g., 21.02.2017)
fixed in issue with 32 bit Office versions and sleep function. Should be working on 64 bit and 32 bit versions again. Issue was reported by ankoo here
removed two deprecated commands from PLX DAQ v1 (RESET and CMD?) as they were of no use anymore
realigned source code for better readability, reused functions more often to reduce redundancy, commented out old checkbox calls from PLX DAQ v1 that are deprecated within commands
corrected a mistake in the comments of the default sketch (column naming)
What's new in "version 2.7" aka Change log:
Added a new command: ClearRange that allows for a range to be cleared in the sheet.
Syntax is Serial.println("ClearRange,StartColumn,StartRow,EndColumn,EndRow"); ==> e.g., Serial.println("ClearRange,B,2,D,50");
fixed a bug when closing the form while still logging. The macro was not paused correctly but will do so now
What's new in "version 2.6" aka Change log:
Fixed the reset timer button (there was a useless message box implemented somehow)
Formatted the timer to always have 6 trailing digits
removed the old fashioned limit to 27 columns - now supports the thousands of columns that Excel supports (although it is getting pretty slow with too many columns)
Set the columns all to be aligned centrally on default and column captions to be written in bold by default
and well yeah - added the warning remark not to play around too much with the window during logging
What's new in "version 2.5" aka Change log:
Added a "Pause logging" / "Resume logging" button that can (well no surprise) stop the logging of the data without disconnecting the Arduino. The Button is enabled when connected
Removed the old 4 checkboxes as the functions are useless without Stamp nowadays and replaced with 3 custom checkboxes . As with old PLX DAQ v1 these checkboxes can be controlled by Arduino code: change text, check/uncheck box, read status of boxed (if checked or not). Codes changed from "DOWNLOAD" / "STORED" / "USER1" to CUSTOMBOX1 / CUSTOMBOX2 / CUSTOMBOX3. "USER2" was removed completely.
Moved "Reset on Connect" around a bit for better UI layout
Re-implemented the code for "Reset Timer" button. I don't know why I removed that anyways in version 2.1 ....
I added a new example sketch that demonstrates the new functions and how one can use them
I also rework the example codes in the custom dev points for not crashing Excel anymore - hopefully
Added new functions to call in Excel by Arduino:
Beep : makes a simple beep
Pauselogging : stops printing logged data to the Excel sheet
Resumelogging: continues pasting data again
Stoplogging : disconnects the Arduino
Saveworkbook : simply saves the workbook
SaveworkbookAs,Filename : saves the workbook as a new copy in the same folder by the name Filename.xlsm
ForcequitExcel: forces Excel to close. Note: the workbook will not be saved by this!
What's new in "version 2.4" aka Change log:
Fixed a UI problem with Office 365
Implemented 2 "custom dev points" ("new line was read" and "new data row recognized") which get called by the system automatically and where custom code can be pasted and used (example included in code)
What's new in "version 2.3" aka Change log:
Port and baud rate not drop down box anymore but free text fields
Port number bug fixed thus ports > 10 can be used (max set to 256 as of modern Windows OS limit)
What's new in "version 2.2" aka Change log:
Enhanced 64 bit support (even better stability now)
Added a dropdown box to select with sheet to post to (got rid of the radio buttons)
Minor adjustment for faster startup of logging
What's new in "version 2":
Support for both Office versions 64 bit as well as Office 32 bit
No more installation needed! All within the workbook
I got rid of the selmaDAQ_Ver2.ocx and use API calls now
Fully compatible to all previous PLX-DAQ commands in your code!
Got rid of some old stuff like "Max row size of 65000" (Office limit is 1048576 rows with 64 bit) or Baud rate only up to 128000 (now supports 230400 and 250000 as well)
Added a direct debugging window for better testing as well as a VBA code module for testing and debugging
Setting for selecting where to post data (first most left sheet or currently active sheet)
Disabled the control boxes as Stamp object is no more in use
=============================================================
This version is already outdated !! Link to always most recent version of PLX DAQ v2 here:
==> PLX-DAQ version 2 - now with 64 bit support! (and further new features) - Interfacing w/ Software on the Computer - Arduino Forum <==
=============================================================
Beginners Guide to PLX DAQ v2.doc (168 KB)
PLX-DAQ-v2.10.zip (284 KB)
PLX-DAQ-v2-DefaultSketch.ino (2.97 KB)