Link to home
Start Free TrialLog in
Avatar of Frank .S
Frank .SFlag for Australia

asked on

excel 2016 formula - angle of repose

hi experts, i need a formula to be calculated in my attached excel worksheet cell D3
- all the info is in the worksheet
Avatar of byundt
Flag of United States of America image


Open in new window

It returns a negative number for the problem at hand.

For the dimensions as shown, even if b = 0, the bin bottom wouldn't be covered all the way across. You need a much taller hopper for that bin width.
Avatar of Frank .S


hi byundt, the formula in 'b' is dependant on all the other manual entered data,
- note, cell D5 although is 22 degrees and 47 minutes, entered as 22.47, this = a rise to run ratio of 42:100, which means that for every 100mm in distance 'e', the height rises 42mm, so the formula needs to calculate the gradient back into a rise to run ratio, then this height can be deducted from 'c' minus 'a'
- i hope you can understand
For a 5000 mm wide bin, the rise for the specified angle of repose is 2068 mm. Compare this to the overall height c of 1400 mm. It is therefore obvious that the numbers in this problem are poorly chosen if you were expecting a meaningful (positive) result for dimension b.

hi brad, they are not poorly chosen numbers they are actual number taken from a building project
ill try explain again so it can help you understand my requirement
- lets use 3000 instead of 1400 and leave the 300 as is,
- so if we now take the 3000-2068 (rise to run ratio of 42:100) = 932-300 (standard concrete depth)= 632
- therefore the formula needs to be able to calculate 'b' as 632mm

does that make sense?
- if the result = negative qty that just means there is no requirement for 'b' so only 'a' would apply
Avatar of byundt
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thankyou, was a little hard to explain at my end...but we got there