I need to create a data logging program that can take up to 18 individual analog inputs into a paperless data recorder and store the values as read at the concurrent times as defined by me (One minute intervals).
I am currently attempting to create a very simple (in theory) spreadsheet.
I am getting data streamed to my PC using a DDE file
I need to capture individual cells value at a start time and save that value into another sheet to populate.
Once the previous value has been saved into the new row, a minute will go by and a new row will show the next value and so on.
Example of one value:
Oxygen is reading 12.0% over an hour period with variations during that time of 4 points (11.8-12.2)
the readings change continuously
at 1:00 pm I wish to record what the value of that cell is reading in the DDE, then every minute, read and log that new value in a cell below the last.
Start and stop would be initiated with a button control
example :
Current Value: 11/15/2024 1:06 P.M. 12.0 <<From DDE Cell
New Spreadsheet
11/15/2024 1:00 P.M. 11.9
11/15/2024 1:01 P.M. 12.1
11/15/2024 1:02 P.M. 11.9
11/15/2024 1:03 P.M. 12.2
I am currently attempting to create a very simple (in theory) spreadsheet.
I am getting data streamed to my PC using a DDE file
I need to capture individual cells value at a start time and save that value into another sheet to populate.
Once the previous value has been saved into the new row, a minute will go by and a new row will show the next value and so on.
Example of one value:
Oxygen is reading 12.0% over an hour period with variations during that time of 4 points (11.8-12.2)
the readings change continuously
at 1:00 pm I wish to record what the value of that cell is reading in the DDE, then every minute, read and log that new value in a cell below the last.
Start and stop would be initiated with a button control
example :
Current Value: 11/15/2024 1:06 P.M. 12.0 <<From DDE Cell
New Spreadsheet
11/15/2024 1:00 P.M. 11.9
11/15/2024 1:01 P.M. 12.1
11/15/2024 1:02 P.M. 11.9
11/15/2024 1:03 P.M. 12.2
