trustmeasfrnd
New Member
- Joined
- Oct 19, 2008
- Messages
- 32
i ve a circle with 18 nodes and i want to plot it in excel may be using chart.it can be done.
now suppose i plotted a circle of diameter 2m then i have 18 nodes equally divided on its perimeter.what if i want to reduce the circle diameter to 1.8m how to generate its coordinate any easy way to do this?
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]-0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.342[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]-0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.6428[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]-0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.866[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]-0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.9848[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.9848[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.866[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.6428[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.342[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]109[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.342[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.6428[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.866[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.9848[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]-0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.9848[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]-0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.866[/TD]
[TD="align: center"]18[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]-0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.6428[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]-0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.342[/TD]
</tbody>
thanks and regards,
abhisekh
now suppose i plotted a circle of diameter 2m then i have 18 nodes equally divided on its perimeter.what if i want to reduce the circle diameter to 1.8m how to generate its coordinate any easy way to do this?
A | B | C | D | |
---|---|---|---|---|
node number | x | y | z | |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]-0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.342[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]-0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.6428[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]-0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.866[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]-0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.9848[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.9848[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.866[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.6428[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-0.342[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]109[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"]110[/TD]
[TD="align: right"]0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.342[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.6428[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.866[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.9848[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"]-0.1736[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.9848[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]-0.5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.866[/TD]
[TD="align: center"]18[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]-0.766[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.6428[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]-0.9397[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.342[/TD]
</tbody>
Sheet1
thanks and regards,
abhisekh