Get instant live expert help on I need help with excel contains operator

I need help with a formula to determine if the person is a pilot or an operator. I have highlighted the column I am trying to formulate. So william duncan should be an operator, Shelton Fisher should be a pilot.

Need a extremely capable Excel computer operator to sort and complete a digital data reports. I need the computer specialist for a day. 11/13/2018.

A permanent operator can process 16 claims per day, whereas a temporary operator can process 12 per day, and on average the company processes at least 450 claims each day. The company has 40 computer workstations. A permanent operator averages about 0.5 claims with errors each day, whereas a temporary operator averages about 1.4 defective claims per day. The company wants to limit claims with errors to 25 per day. A permanent operator is paid $64 per day., and a temporary operator is paid $42 per day. The company wants to determine the number of permanent and temporary operators to hire in order to minimize costs. 1.Formulate a linear programming model for this problem. List the objective function (minimize or maximize) and all model constraints. 2. Solve this model graphically. Identify the following: each constraint line, feasible solution area, x1, x2 and Z for each point, and clearly identify the optimal solution. 3. Solve the problem using MS Excel’s Solver. Answres must be highlighted in yellow

I need to have this tracker apply an hourly rate to the equipment and operator type in the data tab

I want to create a pivot table that will summarize for the total records & total time for each operator.