11-18-2016 12:22 PM
I am writing a worksheet that collects an analog voltage measurement and converts it to feet per minute (Volts * 400 = fpm) at multiple locations. I am outputting the result to a text file along with the time (in seconds).
So the flow goes like this…
Output looks like this:
Measurement time[s],Face Velocity [fpm],
0,64,
1,64,
2,65,
3,63,
4,63,
Here’s where I’m having difficulties…
I need to be able to collect this data for 20 seconds, pause, collect for 20, pause, collect for 20, etc. until I have 12 sets of 20. I know that I can put in a “STOP” control and stop after either 20 seconds or 20 data points and then press collect again to append data to the file. This also works fine. However, I would like to record which data set is being collected (Let’s call it Location, since I am collecting data from multiple locations) in the output file. Like this:
Location, Measurement time[s],Face Velocity [fpm],
1,0,64,
1,1,64,
1,2,65,
1,3,63,
1,4,63,
1,5,64,
1,6,64,
1,7,65,
1,8,63,
1,9,63,
1,10,64,
1,11,64,
1,12,65,
1,13,63,
1,14,63,
1,15,64,
1,16,64,
1,17,65,
1,18,63,
1,19,63,
2,0,64,
2,1,64,
2,2,65,
2,3,63,
2,4,63,
2,5,64,
2,6,64,
2,7,65,
2,8,63,
2,9,63,
2,10,64,
2,11,64,
2,12,65,
2,13,63,
2,14,63,
2,15,64,
2,16,64,
2,17,65,
2,18,63,
2,19,63,
Etc….
I would appreciate any help I can get.
11-21-2016 05:23 PM
how do you identify the location?
Maybe a coded switch that you can save to the file? that gives you up to 16 locations, and you can label the buttons ( I would use buttons or a drop down) with words, while saving the number. The numbers don't have to be 0-15 - you can put any value for each switch position.