Hi.
I have a bit complicated question (yet not sure if excel vba is the right tool or better to work with SAS).
I have a list of machines with a time stamp for each time they are performing activity.
i.e.
07/31/2016 00:12:11 Machine-A Cup
07/31/2016 00:12:21 Machine-A Dish
07/31/2016 00:12:31 Machine-A Spoon
07/31/2016 00:12:41 Machine-A Cup
07/31/2016 00:12:51 Machine-A Cup
07/31/2016 00:14:11 Machine-A Knife
What I need is to add for each line few columns with how loaded the equipment was before this activity in the last hour.
i.e.
Time Eqp Prod Cup Dish Spoon
07/31/2016 00:12:11 Machine-A Cup 3 7 9
Any Idea?
Thank you.
Bookmarks