Alarm Sorting Plan

Hi bstack10 - welcome to the forum.

It would help if you were to upload a sample worksheet that includes your source data before any work is done on it.

Copy your csv file and paste it into A1 and then save. It sounds as if a macro could be built to do the rest (I'm thinking text to columns) and c/f for flagging the high priority cases.

Cheers

Russell

Hi Russell,
Thanks for the quick reply, I have pasted a link of the of the worksheet couldn't seem to find out where to upload excel file?

Included is all the columns of the worksheet:
The Tag Name is unique and does not appear anywhere else.
Element Number, Alarm Message, Priority, Action, Responsibility and Comments are not unique.

Not all alarms will occur in a daily process (i.e. maybe only 3000 and some may never alarm) thus what I need is a template type file, where by the alarms that occur on a specific date can be copied from the DCS into this file.

Once copied they will then flag each appropriate Tag Name and also if possible to have a counter for the amount of time an alarm has being processed.

Shown here is a link to Dropbox with the Excel file attached

https://www.dropbox.com/s/j52xnwt6fn...ll%20List.xlsx

Cant Seem to find Attachment button Any ideas??

Go Advanced - select attachment icon or Manage Attachments.

Are you adding to the list on a daily basis? Do you simply paste it at the bottom off existing range of data? Or are you having to select certain data from the DCS.

alarms that occur on a specific date

There is no column with a date.

Which is higher priority 1 or 5?

Is "Full list" the end result? What do you see as being the end result if not?

a counter for the amount of time an alarm has being processed.

How is this measured? Where is the data?

Clearly you have something in mind but that is missing in my mind at the moment so bear with me if I don't understand at first. You are familiar with the processes you are using but I have never seen it before and I will need some guidance on what you may consider trivial.

To my untrained eye, it appears that there will be many occurances. Is that right.

I hope I can get a better understanding once you have answered the above. Apologies if you think you already have is your explanations.

Cheers

Russell

Am I correct in thinking then that the workbook you have uploaded is the Master and will not change other than being added to I suppose when new alarms are introduced?

A daily process takes place whereby sheet2 is populated with new data (alarms that have been initiated (is that "set off"?)) and sheet1 (currently "Full list") is compared against it and any matches are highlighted on sheet1 depending on the priority level. Am I right?

What does the new data for sheet2 look like or is it exactly the same as on sheet1 but presumably much shorter?

You've added a link to your cross post at Ozgrid, why not here

Sheet2 - please show us how it looks.