Plot XYZ values in Sheets / Excel

saor

Honorary Master
Joined
Feb 3, 2012
Messages
42,188
Reaction score
37,098
Location
CPT
Brain not working today, also don't want to do this manually.
I want to create XYZ values for a subdivided cube with the following basic format:
1.png

So a standard, non-divided cube would have 8 rows of XYZ values for the 8 corners / points / intersections:
1.png

But if I want to subdivide the cube at regular intervals, I need a lot more XYZ values. So for example the following cube was divided into a 4*4*4 grid which = 125 points which I'd like 125 rows of XYZ values for...
2.png

Suggestions for best way to achieve this? The subdivisions will always be along all 3 axis dividing the cube into equal sections. Ideally I'd like:

● An input where I can define the length/width/height of the cube
● input for required # of subdivisions

and have the rows populated by the necessary XYZ values. Feels like I'm missing a clean solution to this.
 
Last edited:
/Nevermind.
Found some non-excel ways to do it once brain woke up.
 
Top
Sign up to the MyBroadband newsletter
X