Rectangular Hollow Section Calculator - Spreadsheet Workbench

Show off your FreeCAD projects here!
Laurie Hartley
Posts: 76
Joined: Mon Feb 27, 2017 5:33 am

Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby Laurie Hartley » Thu Jan 23, 2020 6:53 am

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)
Attachments
Rectangular Hollow Sections Spreadsheet.FCStd
(21.28 KiB) Downloaded 31 times
fmluizao
Posts: 44
Joined: Tue Nov 19, 2019 7:16 pm

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby fmluizao » Thu Jan 23, 2020 10:55 am

I think you could have done with just one pad ;)
Attachments
Rectangular Hollow Sections Spreadsheet.FCStd
(15.31 KiB) Downloaded 13 times
User avatar
Kunda1
Posts: 6452
Joined: Thu Jan 05, 2017 9:03 pm

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby Kunda1 » Thu Jan 23, 2020 1:21 pm

Laurie Hartley wrote:
Thu Jan 23, 2020 6:53 am
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!
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
Laurie Hartley
Posts: 76
Joined: Mon Feb 27, 2017 5:33 am

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby Laurie Hartley » Fri Jan 24, 2020 5:03 am

fmluizao wrote:
Thu Jan 23, 2020 10:55 am
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
Posts: 76
Joined: Mon Feb 27, 2017 5:33 am

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby Laurie Hartley » Fri Jan 24, 2020 5:27 am

Kunda1 wrote:
Thu Jan 23, 2020 1:21 pm
Laurie Hartley wrote:
Thu Jan 23, 2020 6:53 am
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.
Attachments
Part.JPG
Part.JPG (41.01 KiB) Viewed 696 times
Sketch.JPG
Sketch.JPG (52.15 KiB) Viewed 696 times
Spreadsheet.JPG
Spreadsheet.JPG (55.16 KiB) Viewed 696 times
User avatar
bernd
Posts: 9036
Joined: Sun Sep 08, 2013 8:07 pm
Location: Zürich, Switzerland

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby bernd » Fri Jan 24, 2020 10:42 am

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
User avatar
Kunda1
Posts: 6452
Joined: Thu Jan 05, 2017 9:03 pm

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby Kunda1 » Fri Jan 24, 2020 12:18 pm

Laurie Hartley wrote:
Fri Jan 24, 2020 5:27 am
Kunda1 wrote:
Thu Jan 23, 2020 1:21 pm
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 😉
Want to contribute back to FC? Checkout:
#lowhangingfruit | Use the Source, Luke. | How to Help FreeCAD | How to report FC bugs and features
Laurie Hartley
Posts: 76
Joined: Mon Feb 27, 2017 5:33 am

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby Laurie Hartley » Sun Jan 26, 2020 9:48 pm

bernd wrote:
Fri Jan 24, 2020 10:42 am
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 :D
User avatar
bernd
Posts: 9036
Joined: Sun Sep 08, 2013 8:07 pm
Location: Zürich, Switzerland

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby bernd » Mon Jan 27, 2020 9:44 am

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
Posts: 76
Joined: Mon Feb 27, 2017 5:33 am

Re: Rectangular Hollow Section Calculator - Spreadsheet Workbench

Postby Laurie Hartley » Mon Jan 27, 2020 8:43 pm

bernd wrote:
Mon Jan 27, 2020 9:44 am
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.
cron