Spreadsheet object timing in Lookout 6.6

[vtiu]

I have Lookout 6.6 (200 IO) communicating with two NI-9178 CompactDAQ systems. Roughly 50 I/O points are read into a single process. I am using a spreadsheet object to log the data with the time interval set using a text entry object (format hh:mm:ss). In DAQmx, I read the NI-9178's using virtual channels. I cannot get the spreadsheet object to save the data any quicker than 1 second. I need 0.1 seconds or faster. I start with a slow interval and during the process I need to save the data faster. Am I missing something? I have tried to set the interval to hh:mm:ss.s with no effect. I know there are timers in the cDaq but can I set them from Lookout?

[Mike@Forshock]

I would suggest using the SQL database driver (ODBC) or the built in Citadel database and exporting the data later. These are designed for high-speed logging.

The spreadsheet object would be delayed with having to access the file, append data and close the file. SQL will write to a memory buffer and write in blocks. 

Mike