- #1
TheGenericGeek
- 1
- 0
G'day Guys and Gals,
I'm working on trying to come up with a best-fit excel sheet for work.
Basically I'm trying to find out where dirt/rocks will peak if dropped down a pipe at any given angle.
As attached, my crude diagram - I'm trying to calculate the blue line.
The height of the container will vary, the angle of the pipe will vary, the length of the pipe will vary, and I'm trying to get a rough idea of what trajectory the dirt/rocks will follow, and turn this into an excel sheet (Just need assistance with the equations to calculate it all)
Currently the only assumption made is that the dirt/rocks will fall straight from wherever the pipe enters the container, straight down - Obviously this is not the case.
Any help you could offer is great appreciated.
Cheers,
TheGenericGeek
I'm working on trying to come up with a best-fit excel sheet for work.
Basically I'm trying to find out where dirt/rocks will peak if dropped down a pipe at any given angle.
As attached, my crude diagram - I'm trying to calculate the blue line.
The height of the container will vary, the angle of the pipe will vary, the length of the pipe will vary, and I'm trying to get a rough idea of what trajectory the dirt/rocks will follow, and turn this into an excel sheet (Just need assistance with the equations to calculate it all)
Currently the only assumption made is that the dirt/rocks will fall straight from wherever the pipe enters the container, straight down - Obviously this is not the case.
Any help you could offer is great appreciated.
Cheers,
TheGenericGeek