Complete the ETL overview case, which covers the fundamental considerations in the ETL process.

In the same Excel data file, on the tab labeled Case $1\mathrm{.}5$ solution, you should create your answer.

Extract the data from the Case $1\mathrm{.}5$ data worksheet and load it into the Case $1\mathrm{.}5$ Solution worksheet using only formulas $($i$.$e$.,$ do not copy and paste$).$ Or if using R code paste in your R code.

Separate each part of the code into the four different fields $($as defined above$)$ and add a final field that combines the Location with the PlantID. Again, you will do this using only formulas $($i$.$e$.,$ do not hard code any values or cut and paste$).$

Submit as your final deliverable your updated Excel file that has the correct data in each of the columns from A through H$.$ As an example of your final deliverable, the first four rows should look like the table below.

Hint: These extractions can be performed using a combination of the following formulas: MID, MIN, FIND, LEFT, RIGHT, IF$,$ ISNUMBER, VALUE and CONCATENATE $($or just use the ampersand symbol $($&$)$ to concatenate$).$