Node - Red and Influx build

Shift Uploader
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)
2. Influx
 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