Simplicity at it's best. This logic helped me draw an oil well with known survey stations. I did not need to install any matlab or 3D scatter plot. Thanks again for this tutorial !!
Hi. I've been looking way to design well directional or vertical in excel in which it would show different densities fluid in different color w.r.t volume pumped. Is it possible?
@@Cristian-bk3wu i don't have file but concept. There is a pipe" A". Inside "A" there is pipe "B". Fluid is flowing from Pipe A to to B. Suppose 20bbls pumped 9ppg, 50bbls pumped 9.5ppg , 60bbls pumped 10ppg. Total conduit capacity are 120bbls. It should display position of different fluid in pipe with different colours. Pipe A can be a1 a2 and Pipe B can be b1, b2.
It took me some time to figure it out. If you want to rotate single object within this excel app, then connect object points to the following rotation matrix. =-COS(A)*SIN(B)*COS(C)+SIN(A)*SIN(C) =COS(A)*SIN(B)*SIN(C)+SIN(A)*COS(C) =COS(A)*COS(C) =SIN(A)*SIN(B)*COS(C)+COS(A)*SIN(C) =-SIN(A)*SIN(B)*SIN(C)+COS(A)*COS(C) =-SIN(A)*COS(B) =COS(B)*COS(C) =-COS(B)*SIN(C) =SIN(B) Make alpha, beta and gamma values negative and they will behave in same manner as in video.
I got it. The z coordinates must be equal to zero and h and k coordinates of circle = 0 as well. If the h & k of circle are = 1 then x & y are = h & k.
@@mihapavsic5842 You must use parametric equations of circle: x=cos(angle) and y=sin(angle), when Excel use angle in radians. The center of circle will be in [0,0].
@@macmatej Thanks for posting this video. I have just started to explore vector 3D algebra and your xls post is a great tool for visualizing and checking if the calculated results are correct.
The cylinder is not a simple curve but it is a surface area. It's more complicated. You must use 3 parameters as variables. Many lines are spaced along the circle. Next, you must draw the top and down of the base as the area of the circle.
Congratulations for sharing your knowledge
I've been looking for a way to create this graph for a long time.
Simply amazing
Simplicity at it's best. This logic helped me draw an oil well with known survey stations. I did not need to install any matlab or 3D scatter plot. Thanks again for this tutorial !!
Hi. I've been looking way to design well directional or vertical in excel in which it would show different densities fluid in different color w.r.t volume pumped. Is it possible?
Disculpa. Lo podría mostrar?
@@Clepsydrisdisculpa, tienes el archivo?
@@Cristian-bk3wu i don't have file but concept.
There is a pipe" A". Inside "A" there is pipe "B". Fluid is flowing from Pipe A to to B. Suppose 20bbls pumped 9ppg, 50bbls pumped 9.5ppg , 60bbls pumped 10ppg. Total conduit capacity are 120bbls. It should display position of different fluid in pipe with different colours.
Pipe A can be a1 a2 and Pipe B can be b1, b2.
It took me some time to figure it out. If you want to rotate single object within this excel app, then connect object points to the following rotation matrix.
=-COS(A)*SIN(B)*COS(C)+SIN(A)*SIN(C) =COS(A)*SIN(B)*SIN(C)+SIN(A)*COS(C) =COS(A)*COS(C)
=SIN(A)*SIN(B)*COS(C)+COS(A)*SIN(C) =-SIN(A)*SIN(B)*SIN(C)+COS(A)*COS(C) =-SIN(A)*COS(B)
=COS(B)*COS(C) =-COS(B)*SIN(C) =SIN(B)
Make alpha, beta and gamma values negative and they will behave in same manner as in video.
For rotation of object check my second video about rotation: th-cam.com/video/a8QsqW3DvsE/w-d-xo.html&t
This is a neat trick 👌 definitely going to try this out. Interesting what I bit of clever math can do 🙌
Thanks a lot for that one !!
Can we use excel as autocad.. Excell draw plz make a vedio on it
Excel is only graphic calculator. You can draw shape, if you know its coordinates.
can you make also for 3d rotating cylinder?
This is rotation for all objects, including cylinder. Principe is same, but you must use equations of circles.
@@macmatej Oh... thank you i got it.. thanks again..
how did u colour code the x y and z values ?
Colour or values? What do you mean?
@@macmatej colour
Pozdravljen Matej. I drew a circle with circle equations. The circle revolves nice, but not around it’s center coordinate. What might be wrong?
I got it. The z coordinates must be equal to zero and h and k coordinates of circle = 0 as well. If the h & k of circle are = 1 then x & y are = h & k.
@@mihapavsic5842 You must use parametric equations of circle: x=cos(angle) and y=sin(angle), when Excel use angle in radians. The center of circle will be in [0,0].
@@macmatej Thanks for posting this video. I have just started to explore vector 3D algebra and your xls post is a great tool for visualizing and checking if the calculated results are correct.
Alguien sabe cómo sería para poder graficar un cilindro??
It is necessary to first draw a circle in the x,y plane using parametric equations.
x=cos(t)
y=sin(t)
How to create cylinder 3D on excel??
The cylinder is not a simple curve but it is a surface area. It's more complicated. You must use 3 parameters as variables. Many lines are spaced along the circle. Next, you must draw the top and down of the base as the area of the circle.
@@macmatejno tienes un ejemplo de cómo poder hacer un cilindro?
How to draw 3d tetrahedron shape in excel chart
At first, you must calculate coordinates of base triangle points and coordinates of top point. After That insert this numbers in Excel. Check Wiki.
@@macmatej need to plot in 3d...all coordinates are known, plotting in 2d is easy, however plotting in 3d with 3 coordinates is the required result
@@sunnybaggu785 See my video about 3D rotation. Is about plot of four sided pyramid.
Thanks
Master, gracias
This was helpful. Thanks
Valuable tutorial
wow... that was interesting. Thank you so much
THANK YOU!
nice guidance, thanks
Great
nee dagaara passa leedhu antaa gaaa
NOT A 3D graph dude. it's like drawing a cube on a 2D surface
Yes, it is axonometric projection from 3D to 2D, because everything monitor have 2D output. But, input data are x,y,z from 3D.
th-cam.com/video/jDOXllsXFy4/w-d-xo.html
@@ardadoank 3D rotation: th-cam.com/video/a8QsqW3DvsE/w-d-xo.html
All 3d graphs are just 3d objects represented on a 2d surface...