Im confused on how to enter the data i re did ans calculated for this question into the Taguchi Loss Function spread sheet in excel. i re-did the calculations with help on my calculator and by hand. is there anyway i can get help on what to place where on the Taguchi loss function spread sheet?

Calculation of k for the Loss Function \begin{tabular}{r|c|} \hline Deviation from target & 0 \\ \cline { 2 - 3 } Loss associated with deviation & $0.00 \\ \hlinek & \#DIV/0! \\ \hline \end{tabular} Loss Calculation for a Specific x \begin{tabular}{|lrr|} \hline 0 & Target specification, & 10 \\ 1 & Dimensional value, x & 10.04 \\ \hline 2 & k & $100.00 \\ \hline 3 & Loss & $0.16 \\ \hline \end{tabular} Economic Design Specifications economic design specifications if the cost of inspection and adjustment is $7.50 ? 53. Suppose that the design specifications for a hydraulic cylinder are 10.000.10 centimeters and that the Taguchi loss function is estimated to be L(x)=1,400(xT)2. Use the Excel template Taguchi to answer the following questions: a. Determine the estimated loss for a production order if the quality characteristic under study takes on a value of 10.04 and 100 parts are produced. b. Assume the production process is recalibrated weekly and a new sample of cylinders after recalibration reveals an x-bar of 9.789. What action, if any, is need in this situation? Explain. \begin{tabular}{l|r|r|} \hline 3 & Calculation of k for the Loss Function \\ \hline 5 & Deviation from target & 0.15 \\ \cline { 2 - 3 } & Loss associated with deviation & $20.00 \\ \hline 7 & k & $888.89 \\ \hline \end{tabular} Loss Calculation for a Specific x \begin{tabular}{l|r|r|} \hline 10 & Target specification, T & 1.875 \\ \cline { 3 - 4 } 11 & Dimensional value, x & 1.925 \\ \hline 12 & k & $888.89 \\ \hline 13 & Loss & $2.22 \\ \hline 14 & & \end{tabular} Economic Design Specifications Calculation of k for the Loss Function \begin{tabular}{r|c|} \hline Deviation from target & 0 \\ \cline { 2 - 3 } Loss associated with deviation & $0.00 \\ \hlinek & \#DIV/0! \\ \hline \end{tabular} Loss Calculation for a Specific x \begin{tabular}{|lrr|} \hline 0 & Target specification, & 10 \\ 1 & Dimensional value, x & 10.04 \\ \hline 2 & k & $100.00 \\ \hline 3 & Loss & $0.16 \\ \hline \end{tabular} Economic Design Specifications economic design specifications if the cost of inspection and adjustment is $7.50 ? 53. Suppose that the design specifications for a hydraulic cylinder are 10.000.10 centimeters and that the Taguchi loss function is estimated to be L(x)=1,400(xT)2. Use the Excel template Taguchi to answer the following questions: a. Determine the estimated loss for a production order if the quality characteristic under study takes on a value of 10.04 and 100 parts are produced. b. Assume the production process is recalibrated weekly and a new sample of cylinders after recalibration reveals an x-bar of 9.789. What action, if any, is need in this situation? Explain. \begin{tabular}{l|r|r|} \hline 3 & Calculation of k for the Loss Function \\ \hline 5 & Deviation from target & 0.15 \\ \cline { 2 - 3 } & Loss associated with deviation & $20.00 \\ \hline 7 & k & $888.89 \\ \hline \end{tabular} Loss Calculation for a Specific x \begin{tabular}{l|r|r|} \hline 10 & Target specification, T & 1.875 \\ \cline { 3 - 4 } 11 & Dimensional value, x & 1.925 \\ \hline 12 & k & $888.89 \\ \hline 13 & Loss & $2.22 \\ \hline 14 & & \end{tabular} Economic Design Specifications