Forum Discussion
Solved
Using arrays calculations in Excel.
In a rather complex Excel spreadsheet that I am studying to apply it, I came across a calculation step that uses arrays in such a synthetic way that I cannot decipher. I looked on the internet and...
vifacc44 Thank you for providing a complete sample file. The header cell for the "Safety Factor" column of the output table needs to be linked to the final result that is dependent on the "Shape" selection in cell B8 (the final result appears to be in cell D28, "Factor of Safety"). Then, select the entire 2-column output range, go to Data > What-If Analysis > Data Table... on the ribbon and set the Column input cell to $B$8.
I've outlined the setup process in the attached file for your convenience...
Hello everyone,
I have prepared a real example of what I want to achieve.
Inside the calculation of the moment of inertia for a given steel composite profile, I want to have the situation of the various safety factors, for all the tabulated profiles, with the same bending moment and admissible bending stress.
These values must be generated next to the relative profiles in the prepared table: "Shape / Safety Factors".
I must admit that I tried to do it myself using your suggestions, but I failed due to various errors in establishing the "constraints" and the cells involved.
Any suggestion and solution is welcome and I will be grateful to anyone who kindly wants to suggest it to me.
This is the link to my OneDrive public folder that contains the example excel file:
Vittorio
vifacc44 Thank you for providing a complete sample file. The header cell for the "Safety Factor" column of the output table needs to be linked to the final result that is dependent on the "Shape" selection in cell B8 (the final result appears to be in cell D28, "Factor of Safety"). Then, select the entire 2-column output range, go to Data > What-If Analysis > Data Table... on the ribbon and set the Column input cell to $B$8.
I've outlined the setup process in the attached file for your convenience...
- Hi djclemens,
I applied your welcome suggestions and the table I was looking for was correctly created on the first try.
Thank you very much for the time you dedicated to me and for your correct step-by-step procedure.
I am very happy to mark your procedure as the best answer.
Best regards,
Vittorio