excel 2016 formula - angle of repose

Frank .S
Frank .S used Ask the Experts™
on
hi experts, i need a formula to be calculated in my attached excel worksheet cell D3
- all the info is in the worksheet
angle-of-repose_1.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
=D4-D2-D6*TAN(D5*PI()/180)

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.
Frank .SBuilding Estimator

Author

Commented:
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
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
Frank,
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.

Brad
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Frank .SBuilding Estimator

Author

Commented:
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?
Frank .SBuilding Estimator

Author

Commented:
- if the result = negative qty that just means there is no requirement for 'b' so only 'a' would apply
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
And 632 is exactly what my suggested formula calculates.
angle-of-repose_1.xlsx
Frank .SBuilding Estimator

Author

Commented:
thankyou, was a little hard to explain at my end...but we got there

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial