Forum Discussion
Using arrays calculations in Excel.
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...
I apologize for my superficiality, I thought that the outline was not important because it seemed to me that the only cells involved were those indicated by me.
I thank Djclements in particular for the references that he kindly wanted to indicate to me and that I am about to study.
When I have sufficiently mastered the problem, I will also be able to develop a more precise worksheet.
Vittorio
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:
https://1drv.ms/f/s!ArE7UagGehaigotFow3JVXP_NVG7AQ?e=Oob9eb
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