Need help with figuring out what formula to use for these!!! Attached is excel assignment for reference

String Manipulations:

1) Cells B2-B15=> Calculate the four digit year using the same relative formula in all cells base on the data in

cells A2-A15 (DO NOT TOUCH/CHANGE THE DATA in cells A2-A15; use formulas in B2-B15).

2) Cells C2-C15 => Calculate the name (e.g., January for 01, February for 02, etc.) based on the data in cells

A2-A15 (Hint: this is tougher; this can be done without using logic like if Value = 01 then January else if

Value = 02 then February else...; make sure to use formulas in C2-C15)

1 YY-MM 2 2014-01 3 2014-02 4 2014-03 5 2014-04 6 2014-05 7 2014-06 8 2014-07 9 2014-08 10 2014-09 11 2014-10 12 2014-11 13 2014-12 14 2015-01 15 2015-02 Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Calc Year Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Calc Month Inspection Cost $35,378.00 $36,700.00 $26,250.00 $56,000.00 $61,120.00 $63,510.00 $81,500.00 $59,000.00 $95,140.00 $73,480.00 $87,000.00 $53,560.00 $57,000.00 $34,000.00 Inspection Hrs 400 480 240 1,280 960 800 1,120 920 1,400 1,080 1,400 800 560 640 #of Batches Cost @ Min Hrs Cost @ Max Hrs 20 Blank if > Min hrs, $$$ otherwise Blank if Maxx hrs, $$$ otherwise 40 Blank if Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise 30 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise 60 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise 50 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise 80 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise 70 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise 44 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise 100 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $S$ otherwise 90 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $S$ otherwise 76 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $S$ otherwise 36 Blank if Min hrs, $$$ otherwise Blank if o Maxx hrs, $S$ otherwise 56 Blank if Min hrs, $$$ otherwise Blank if o Maxx hrs, $S$ otherwise 28 Blank if > Min hrs, $$$ otherwise Blank if o Maxx hrs, $$$ otherwise COUNT 17 TOTALS 18 Average (Fn) 19 Average (Calc) 20 Minimum 21 Maximum TOTAL Avg (fn) Avg (calc) Min Max TOTAL Avg (fr) Avg (copycalc) Min Max TOTAL Avg (fr) Avg (copycalc) Min Max Avg (fn) Avg (fn) 23 HIGH LOW (Insp Hrs) 24 Total Cost 25 Calc = FC Calc + VC/Insp Hr Calc x # of Inspect Hrs Test: INPUT HRS HERE 27 Regr #1: Cost Function for InspHrs 28 Total Cost 29 Calc = FC Reference + VC/Insp Hr Reference x # of Inspect Hrs Test: INPUT HRS HERE 30 Data Scatterplot Regr-InspHrs Regr-NumBatches Regr-Mult TDist +