Each week the spot electricity prices are reported for every hour. Assume that data is unsorted and build a model that identifies top five and bottom five prices and the corresponding date/time values. Please note that empty cells may be provided as input. All "Date and Time" cells in columns A and G must be custom-formatted: YYYY-MM-DD HH:MM:SS (e.g. 2020-01-01 12:24:23) 115 pts. 2 3 4 S G 7 Date and Time Price B 24 18 19 AAAAA22222222 26 30 Top five prices and date/time Price Date and Time 1 2 3 4 5 Bottom five prices and date/time Price 1 2 3 4 S Date and Time You can make up the airfares for the purpose of developing the model Postpone deleting input data from orange cells until you have completed P4 NOTE: You may NOT change the structure of the worksheet (e.g. by adding columns) Therefore, VLOOKUP will not work here. FORMULAS: Some formulas need to be copied and they will not work with named ranges which use absolute addresses. Use the cell addresses not names if you need to copy formulas with relative addressing (e.g., AS instead of P3inp1)