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...
This is the link to my public OneDrive which contains the excel sheet explaining the problem.
Vittorio
And yet this line of code {=TABLE(;$B$10)} works, but I can't find any references to it
Vittorio
For what it's worth, opening your spreadsheet reveals almost nothing. Here's an image of what one sees. I think you need to do a better job of "explaining the problem" -- or at the very least, making it visible. It looks like a big blank sheet except for the cryptic presence that you see below.
vifacc44 The array formula you are referring to was created by going to Data > What-If Analysis > Data Table... on the Ribbon. As mentioned by mathetes, it's difficult to provide any further explanation because all of the data on which it was built has been removed from your sample file. For more information, please see Calculate multiple results by using a data table or Google search "data tables excel" and see what comes up. Cheers!
- Thanks Mathetes and Djclements for your kind reply.
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.
VittorioHello 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
