How can use a script to separate data into separate sheets?

[FuelCellWhisperer]

For example sake, I have three columns: Food Eaten (lbs), Date, and Pet (Fido, Penny, Whiskers). I'd like to tease the data apart such that the data for the first two columns for Penny, Fido, and Whiskers all appear on different sheets.

Thanks in advance

[Brad_Turpin]

Hi FCW,

You have two options, both of which start by sorting all columns by pet name (if they aren't already), then

1)  Configure the table on each sheet to start and stop at the corresponding channel rows for that pet

2)  Send the channel rows for each pet (all channels) to a new set of channels in a new Group

I can show you how to do either.  Will this be a static report with the same pet names or a dynamic report with a varying number of pet names and/or measurements per pet?

If you are willing to post a sample data set, I can send you a VBScript that does this automatically.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[FuelCellWhisperer]

Brad- I like the approach. The tables are relatively dynamic...as to say that the number of pet names will vary as well the number of measurements for a given data set.

Sample set in xls format is attached. As it turns out, the pet names are actually test segment numbers and food consumed is a flow rate.

[Brad_Turpin · Accepted solution]

Hi FCW,

I created a DataPlugin to read in your Excel data file-- if you happen to have DIAdem 2010 (11.2) or later you'll be able to use it.  Otherwise just load the file however you were loading it before so that your 4 data channels are the only ones in the Data Portal, then run the "DataFileWhisperer.VBS" script in DIAdem SCRIPT.

Brad Turpin

DIAdem Product Support Engineer

National Instruments