Hi Paul
The "dome" comprises 36 triangles laid on straight purlins between the arched beams, so each triangle is only curved in one plane.
Hi Paul
The "dome" comprises 36 triangles laid on straight purlins between the arched beams, so each triangle is only curved in one plane.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Only an approximation using flat triangular segments, I get 3491.4 m2
1. 18 high x 31 base = 35.85 m length to peak
2. each of 36 panels has 62m x pi / 36 as base = 5.41 m as base
3. 1/2 of each panel = 5.41/2 m = 2.70 m as base (to make right triangle)
4. area of 1/2 panel = .5 x B x H = .5 x [2.70 x 35.85] = 48.49 m2
5. area of panel = 2 x 48.49 = 96.98 m2
6. area of 36 panels = 96.8 x 36 = 3491.4 m2
Capture.JPG
scan238.jpg
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3