Topic: CSV Import in Excel with new level function in CSV Export 

• When you export data at the ProductionID level, the data field "Shift End Time" is not a date / time, but a counter.
• At the ProductionID level you have one row but only one counter indicating how many shifts the product has run. 
• At the ShiftEndTime level you have one row per product and shift.

Important Note: 

• The CSV file always has the time stamp 1/1/1970 1:00 even if you do not open it with Excel. 
• Change the date/time format in Senses under profiles from "Browser Standard" to "yyyy.mm.dd - hh:mm(24h)" and the CSV file has no longer the problem.

Topic: Idle Positions

What is number (No) of Last Idle Shifts?

No of Last Idle Shifts is a length of an uninterrupted series of the last shifts where the total production time for each shift was less than 15 min.

When to display the position?

• The position should be displayed if at least one of the following conditions apply
  • it is more than (or equal to) 1h continuously in idle (non-production) state
  • No of Last Idle Shifts > 0 ( uninterrupted series of last shifts with total prod time/shift < 15 min)
• The position should not be displayed in any other case

What to display?

Three data values should be displayed

• Position status (green hook icon /red x icon),  always current, according to the last registered message from the current data)
• Cumulative Shift Idle Time (in minutes)
• No of Last Idle Shifts

Back to Senses News