Rectangular Hollow Section Calculator - Spreadsheet Workbench

[Laurie Hartley]

I knocked this little file up to design rectangular hollow sections for my project because I need Australian Standards which don't seem to be in the BOLTS addon?
I think it works Ok but would be happy to receive feedback.

OS: Windows 8.1
Word size of OS: 64-bit
Word size of FreeCAD: 64-bit
Version: 0.18.16131 (Git)
Build type: Release
Branch: releases/FreeCAD-0-18
Hash: 3129ae4296e40ed20e7b3d460b86e6969acbe1c3
Python version: 3.6.6
Qt version: 5.6.2
Coin version: 4.0.0a
OCC version: 7.3.0
Locale: English/UnitedStates (en_US)

[fmluizao]

I think you could have done with just one pad

[Kunda1]

Hi @Laurie Hartley
Do you mind adding screenshots to the OP so users who browse this forum can see what you're sharing (without having to d/l) ?
Thanks!

[Laurie Hartley]

I think you could have done with just one pad

Thank you very much fmluizao - simpler is almost always better. I will be using your file from now on

[Laurie Hartley]

Hi @Laurie Hartley
Do you mind adding screenshots to the OP so users who browse this forum can see what you're sharing (without having to d/l) ?
Thanks!

No problem Kunda1 - here they are (using fmluizao's improved file) I think the spreadsheet workbench has terrific potential.

[bernd]

would you make the date available for adding them to BOLTS? Only this file would be needed to extended: https://github.com/boltsparts/BOLTS/blo ... hollow.blt

[Kunda1]

Do you mind adding screenshots to the OP so users who browse this forum can see what you're sharing (without having to d/l) ?

No problem Kunda1 - here they are (using fmluizao's improved file)

Thanks, just to clarify, OP means both Original Poster and Original Post. What I asked if you could do was add the screenshots to the Original Post (the first post in the thread) so users see it first thing when the click the thread. Cheers

[Laurie Hartley]

would you make the date available for adding them to BOLTS? Only this file would be needed to extended: https://github.com/boltsparts/BOLTS/blo ... hollow.blt

bernd, if you meant the data tables, here is a link to the Australian Tube Mills download page that I got the sizes from.

https://www.austubemills.com.au/en-au/ ... el-hollow/


I am hoping you didn’t mean for me to edit the file because that is way beyond my capabilities

[bernd]

how about if we would do it together ...

Would you provide the following three text files for australian profiles. As an example I include some of the european ones. These should be deleted ...

Circular Hollow Sections, wheras D: outside diameter, t: thickness

Code: Select all

#type       [  D      t   ]
21.3-2.3:   [  21.3,  2.3 ]
21.3-2.6:   [  21.3,  2.6 ]
...

Square Hollow Section, whereas b: outside dimension, t: web thickness

Code: Select all

#type     [  b    t   ]
40-2.6:   [  40,  2.6 ]
40-3.2:   [  40,  3.2 ]
...

Rectangular Hollow Section, whereas h: outside dimension height, b: outside dimension width, t: web thickness

Code: Select all

#type        [  h    b    t   ]
50-30-2.6:   [  50,  30,  2.6 ]
50-30-3.2:   [  50,  30,  3.2 ]
...

cheers bernd

[Laurie Hartley]

how about if we would do it together ...

Would you provide the following three text files for australian profiles. As an example I include some of the european ones. These should be deleted ...

OK Bernd I will have a go at it. I am quite busy the next few days but will try to get the files back to you next week.