Contact   Imprint   Advertising   Guidelines

Excel Workbook for twintip design - Board-off design tool.

here you can exchange your experience and datas about your home build boards


mattma
Rare Poster
Posts: 32
Joined: Thu Mar 24, 2011 3:44 am
Kiting since: 4
Local Beach: Long Reef in Sydney Australia
Favorite Beaches: Old Bar on Central Coast NSW. The most perfect freestyle lagoon with worldclass waves over the dunes!!
Style: Freestyle
Gear: 9m Fuel and 12 m RPM. 132x41 CrazyFly Raptor+ homebuilt board
Brand Affiliation: None

Excel Workbook for twintip design - Board-off design tool.

Postby mattma » Wed May 04, 2011 1:18 pm

I've been putting together an MS Excel workbook for designing twintips up to 140cm. Its not exactly slick but it gets the job done and has a decent number of parameters you can play with. Its still a work in progress but it produces the outlines and the rocker/ concave jigs templates that can be printed off 1:1 scale.

Image

Some more pictures here:
http://myvirtualshed.blogspot.com/2011/05/off-table.html

I'v christened it 'BoardOff' design tool. If you want a copy of it (including the very beta flex profiling model) there is a link on this page where you can download it off google docs.

http://myvirtualshed.blogspot.com/2011/05/my-first-plagarism-free-board.html

Cheers
Matt

BWD
Very Frequent Poster
Posts: 2765
Joined: Thu Jun 05, 2003 3:37 am

Re: Excel Workbook for twintip design - Board-off design too

Postby BWD » Wed May 04, 2011 5:17 pm

Thanks for sharing this spreadsheet.
Look forward to playing with it and will let you know if it "fits" boards I've built...

mattma
Rare Poster
Posts: 32
Joined: Thu Mar 24, 2011 3:44 am
Kiting since: 4
Local Beach: Long Reef in Sydney Australia
Favorite Beaches: Old Bar on Central Coast NSW. The most perfect freestyle lagoon with worldclass waves over the dunes!!
Style: Freestyle
Gear: 9m Fuel and 12 m RPM. 132x41 CrazyFly Raptor+ homebuilt board
Brand Affiliation: None

Re: Excel Workbook for twintip design - Board-off design too

Postby mattma » Sat May 07, 2011 4:21 am

Your welcome. I'll be looking forward to hear if you find it useful.

Also, any tips on why the flex modelling is so far off the mark would be very welcomed

Matt

JMF
Frequent Poster
Posts: 477
Joined: Mon Sep 02, 2002 1:00 am
Kiting since: 2000
Brand Affiliation: None
Location: Teahupo'o, Tahiti

Re: Excel Workbook for twintip design - Board-off design too

Postby JMF » Sat May 07, 2011 11:26 am

mattma wrote:Also, any tips on why the flex modelling is so far off the mark would be very welcomed

Matt


Epoxy systems, cure rates, fiber saturation, material density, material orientation. As you can see there are so many variables at play I don't think our meger home setups allow for much consistancy. Our homemade boards are literally one of a kind items which is good I think :D

mattma
Rare Poster
Posts: 32
Joined: Thu Mar 24, 2011 3:44 am
Kiting since: 4
Local Beach: Long Reef in Sydney Australia
Favorite Beaches: Old Bar on Central Coast NSW. The most perfect freestyle lagoon with worldclass waves over the dunes!!
Style: Freestyle
Gear: 9m Fuel and 12 m RPM. 132x41 CrazyFly Raptor+ homebuilt board
Brand Affiliation: None

Re: Excel Workbook for twintip design - Board-off design too

Postby mattma » Mon May 09, 2011 3:10 am

JMF wrote:Epoxy systems, cure rates, fiber saturation, material density, material orientation. As you can see there are so many variables at play I don't think our meger home setups allow for much consistancy. Our homemade boards are literally one of a kind items which is good I think :D


The real goal of developing a model for the flex etc is to be able to put a bit of rigour around what changing a particular parameter will do to the board 'all else being equal'. For example, if you add x mm of concave what could you expect to happen to the stiffness, if I reduce the core thinkness by 10% what is the impact, is having a step profile at the tips better than graded and why, if I use thinner s-glass in place of e-glass what is the impact flex and strenght.

I'm with you on the issue of there being a few variables at play but all the ones you've mentioned and more have been modelled pretty extensively in the analysis of beams and composites that is pretty plentiful on the web. I think that the thing that will make it make it v. difficult to predict the actual flex of the board in advance (rather that the 'all else being equal what happens if I change ....' ) is how variable the properties of the materials are from batch to batch. If I calibrate the existing simple model to a test point on my current boards and take into account that I squeezed all the concave out of it by clamping the b'jesus out of it to test then the agreement when placed under other loads is not too bad. Already its helped me get my head around the issue of reducing core thickness vs reducing the amount of glass.

The thing that I'm not sure about because its been a long time since I did any continuum mechanics (20 years+) is whether there are affects that I have left out of the model that will have a significant impact.

Cheers
Matt


Return to “Board Builders”

Who is online

Users browsing this forum: No registered users and 2 guests