Description: Create an excel uploader within Node-Red to be able to upload shift information. Generate a table within Influx which uses the latest uploaded shift information for each time period.
1. Excel Uploader to handle the following columns
Supervisor Name (string, free text)
Shift Start (Datetime)
Shift End (Datetime)
Shift ID (String, Dropdown list A,B,C,D)
Number of people on shift (Int)
The shift data should be added as a new Data_Type in Influx called ‘Shift_Data’
A query should be created to pull the last uploaded shift data for each time period – for example if yesterday I uploaded shift data for 22/07/21 and the shift ID was ‘A’, then today I reuploaded for the same time period and the shift ID was ‘B’, then the query should identify the shift ID as ‘B’.
Write a query to map the shift ID to the continuous data so that all data points can be attributed to a shift – e.g. for each timestamp in the continuous data there will be a field tag ‘Shift’ and ‘_value’ is set to the corresponding shift