The Gulf Shore Blue Crabs minor league baseball team wants to create a new identification system for its season ticket holders using information in the file bluecrabs. The file contains the first and last name of the ticket holder and the following information on the ticket holder’s seats:

● Section

● Level (f for field, l for loge, or b for bleacher)

● Row

● Seat (lowest numbered seat in the block held by the season ticket holder)

The file also includes

● a field named NumSeats that indicates how many seats the season ticket holder has purchased

● a field named Seasons that indicates how many consecutive seasons the season ticket holder has purchased season tickets

● a field named Upgrade that indicates how many seasons have passed since these season tickets have been upgraded

● a field named Request that has a value of Y if the season ticket holder has requested an upgrade for the upcoming season.

The field Upgrade is blank if the season ticket holder’s seats have never been upgraded, and the field Request is blank if the season ticket holder has not requested an upgrade for the upcoming season.

Blue Crabs management wants to assign each season ticket holder a unique ID code that comprises the Section, Level, Row, Seat, NumSeats, Seasons, and Upgrade fields with no space between the values. For example, the ID Code for Evander Perez

(the first season ticket holder listed in the file bluecrabs) should be 3l091496. Blue Crabs management also wants information on all season ticket holders who have requested an upgrade for the upcoming season sorted in descending order by the number of seasons the individual has held season tickets (which is the first criteria for deciding which season ticket holders will receive upgrades).

a. Create a new field named ID Code in the file bluecrabs that combines the value of Section, Level, Row, Seat, NumSeats, Seasons, and Upgrade fields with no space between the values for each record as described in the problem. Save your file under the name bluecrabs_idcodes.xlsx.

b. Produce a subset of the records in the file bluecrabs_idcodes that includes only season ticket holders who have requested upgrades for the upcoming season. Sort these data in descending order by the field Seasons, then provide a list of these season ticket holders and the corresponding values for Season and ID Code in this order.