- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi, I've been trying to create a stringer stair assembly which is automated in terms of a platform height is entered and then the optimum sizes for stair tread and rise are calculated where certain conditions are met according to the specification.
My criteria is the Step Rise is to be between 170 - 220mm, tread depth between 250-400mm, stair angle between 38 - 42. there's also a tread overhang criteria which needs to be between 16 - 40mm and i want my overall tread depth to be a constant at 283mm as this works with the flooring type we use.
The attached model regenerates for given inputs and flags up warnings when outside the criteria but what i'd like is to use some programming to find the values which work. Does that require loops..? Started to look at excel solver but can't quite get my data set to work. Any assistance would be appreciated.
Solved! Go to Solution.