Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing data only when a column "Value" changes
What I need to accomplish is to get three items; tag, time, and value,
automatically copied into a clean worksheet every time the Widgets value changes -- ON/OFF. As you can see from my mess below, I aint got the faintest cue what Im doing. Phase 1 I retrieve history on Tag, Time, and Value every minute during a startup/shutdown process event I may have to go back 30 days. Raw data is exported from a large db. I probably have 90 columns with around 1000 rows Tag Time Value Tag Time Value Widget A 09/30/2008 11:55:00 ON Widget B 09/30/2008 11:55:00 ON Widget A 09/30/2008 11:56:00 ON Widget B 09/30/2008 11:56:00 ON Widget A 09/30/2008 11:57:00 OFF Widget B 09/30/2008 11:57:00 ON Widget A 09/30/2008 11:58:00 OFF Widget B 09/30/2008 11:58:00 OFF Widget A 09/30/2008 11:59:00 OFF Widget B 09/30/2008 11:59:00 OFF Widget A 10/01/2008 00:00:00 OFF Widget B 10/01/2008 00:00:00 Widget A 10/01/2008 00:01:00 ON Widget B 10/01/2008 00:01:00 Widget A 10/01/2008 00:02:00 OFF Widget B 10/01/2008 00:02:00 ON Widget A 10/01/2008 00:03:00 ON Widget B 10/01/2008 00:03:00 ON Widget A 10/01/2008 00:04:00 ON Widget B 10/01/2008 00:04:00 ON Widget A 10/01/2008 00:05:00 OFF Widget B 10/01/2008 00:05:00 OFF Widget A 10/01/2008 00:06:00 ON Widget B 10/01/2008 00:06:00 ON Widget A 10/01/2008 00:07:00 ON Widget B 10/01/2008 00:07:00 ON Widget A 10/01/2008 00:08:00 Widget B 10/01/2008 00:08:00 Widget A 10/01/2008 00:09:00 Widget B 10/01/2008 00:09:00 Widget A 10/01/2008 00:10:00 ON Widget B 10/01/2008 00:10:00 ON Widget A 10/01/2008 00:11:00 OFF Widget B 10/01/2008 00:11:00 OFF Widget A 10/01/2008 00:12:00 ON Widget B 10/01/2008 00:12:00 OFF Widget A 10/01/2008 00:13:00 ON Widget B 10/01/2008 00:13:00 OFF Widget A 10/01/2008 00:14:00 OFF Widget B 10/01/2008 00:14:00 ON Widget A 10/01/2008 00:15:00 OFF Widget B 10/01/2008 00:15:00 OFF Widget A 10/01/2008 00:16:00 ON Widget B 10/01/2008 00:16:00 ON ----------------------------------------------------------------------------------------------------------------------------------------------- Phase 2 Tag Time Value Tag Time Value Widget A 09/30/2008 11:55:00 ON Widget B 09/30/2008 11:55:00 ON Widget A 09/30/2008 11:57:00 OFF Widget B 09/30/2008 11:58:00 OFF Widget A 10/01/2008 00:01:00 ON Widget A 10/01/2008 00:02:00 OFF Widget B 10/01/2008 00:02:00 ON Widget A 10/01/2008 00:03:00 ON Widget A 10/01/2008 00:05:00 OFF Widget B 10/01/2008 00:05:00 OFF Widget A 10/01/2008 00:06:00 ON Widget B 10/01/2008 00:06:00 ON Widget A 10/01/2008 00:11:00 OFF Widget B 10/01/2008 00:11:00 OFF Widget A 10/01/2008 00:12:00 ON Widget A 10/01/2008 00:14:00 OFF Widget B 10/01/2008 00:14:00 ON Widget A 10/01/2008 00:16:00 ON Widget B 10/01/2008 00:16:00 ON ----------------------------------------------------------------------------------------------------------------------------------------------------- Phase 3 This is what I need to have at the end of the day -- but slowly getting here, however using a few manual tasks. Tag Time Value Tag Time Value Widget A 09/30/2008 11:55:00 ON Widget B 09/30/2008 11:55:00 ON Widget A 09/30/2008 11:57:00 OFF Widget B 09/30/2008 11:58:00 OFF Widget A 10/01/2008 00:01:00 ON Widget B 10/01/2008 00:02:00 ON Widget A 10/01/2008 00:02:00 OFF Widget B 10/01/2008 00:05:00 OFF Widget A 10/01/2008 00:03:00 ON Widget B 10/01/2008 00:06:00 ON Widget A 10/01/2008 00:05:00 OFF Widget B 10/01/2008 00:11:00 OFF Widget A 10/01/2008 00:06:00 ON Widget B 10/01/2008 00:14:00 ON Widget A 10/01/2008 00:11:00 OFF Widget B 10/01/2008 00:16:00 OFF Widget A 10/01/2008 00:12:00 ON Widget A 10/01/2008 00:14:00 OFF Widget A 10/01/2008 00:16:00 ON |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet | Excel Programming | |||
Change data in a single column from "last, first" to "first last" | Excel Discussion (Misc queries) | |||
Please add a "sheet" function like "row" and "column" functions | Excel Programming | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |