

If need be, you can do some shifting of data in the spread sheet if the object wasn't placed exactly where you need to be. It will give you the coordinates for each cell in a new sheet. The "Get Datapoints" button will then loop through and pull off the X and Y position of a cell that has a value in it (if you remove values, it will ignore the cell) It will take the value in the cell as Z1 and use the Z-thickness to get Z2. I do not believe I ever got the X-Shift and Y-Shift functions working, but the Z-thickness should be set to the size of one grid cell by default. On the sheet with shape, there are three options and a button. It will take you to the sheet where the shape is drawn (you may have to zoom out to see the full shape) If it is a point on the line, then it will insert a value equal to what is in the F(x,y) cell.

It will then loop through each cell in the domain and check if it fits along the line. How this works is that it will create a sheet and label the axis on the top row and first column with values as prescribed in the top of the setup sheet. Only edit the orange cells, but when you edit the F(X), F(Y), and F(x,y) cells, make them a function of the respective yellow cells. The other two option allow you to draw a line as a function of X or a function of Y. I believe the angle is from the positive x axis towards the positive y axis.

Then you can go back and edit the center points, radii, and angle of rotation (if it's an ellipse) to get what you want. To see the default example, just click the "Draw Ellipse" button. You can create an ellipse (or circle if you set the radii to the same distance) The outer ellipse will create a shape while the inner ellipse will hallow out part of the inner ellipse. From there, you can click the button that says "Blank Graph Paper" or you can continue down with one of the other three options. A friend had to model a circular atrium and the stairs were rounded as well.Īt the top, you have to set up the dimensions of the 'graph paper' to match what you have in your grid. Here is an excel workbook that I created a while back.
