Pneumatic Actuator Design Matrix: The range of actuator design parameters have been provisionally assessed and are presented in Table. You are required to determine the following parameters:
Your design tasks are:
(i) Prepare a suitable hand-written matrix based on an Excel Worksheet as a planning guide to show the cell locations of all the formulae you consider necessary to determine the specified design parameters.
(ii) Using the planning information from (i) and the associated Design Data presented in Table (2), develop an Excel Worksheet capable of determining the design parameters within the specified ranges and test as appropriate to show all intermediate calculations and associated worksheet OUTPUT DATA.
(iii) Using appropriate INPUT DATA, check the correlation between the Excel Worksheet OUTPUTs and those obtained by manual calculation. Check for errors (if required) either in the worksheet or manual calculations until appropriate correlation is obtained.
(iv) Submit the planning matrix from (i), an operational Excel Worksheet from (ii) showing all the data together with all supporting calculations from (iii).