[done] Developing a spreadsheet based loaf pan

Post here for help on using FreeCAD's graphical user interface (GUI).
Forum rules
and Helpful information
IMPORTANT: Please click here and read this first, before asking for help

Also, be nice to others! Read the FreeCAD code of conduct!
User avatar
thomas-neemann
Veteran
Posts: 11801
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: Developing a spreadsheet based loaf pan

Post by thomas-neemann »

Ulicad wrote: Sun May 28, 2023 8:49 pm
In my opinion, alias still has problems. i don't use them, but the cell names e.g. <<Spreadsheet>>.A1
Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
Ulicad
Posts: 311
Joined: Tue Aug 16, 2022 10:35 am
Location: de_DE

Re: Developing a spreadsheet based loaf pan

Post by Ulicad »

chrisb wrote: Sun May 28, 2023 11:42 pm...
You should reduce the file yourself as far as possible - which BTW often leads to a solution anyway.
Thanks a lot!
Very far down the spreadsheet (row 423 ...) I now could find a completely neglected and forgotten section... :oops:
It was the user to be blamed...
thomas-neemann wrote: Mon May 29, 2023 4:04 am...
In my opinion, alias still has problems. i don't use them, but the cell names e.g. <<Spreadsheet>>.A1
Just FYI:
Using and relying on aliases heavily since the start with spreadsheets, I did not encounter a serious problem with them yet.

Thanks for your valuable replies!
Regards, Ulicad / Uli
---
en: New FC-user, virgin to previous CAD-work, labouring on his new hobby Ulis Blog
de: Neuer FC-Nutzer, ohne vorhergehende CAD-Erfahrung, beschäftigt mit seinem neuen Hobby Ulis Blog
User avatar
thomas-neemann
Veteran
Posts: 11801
Joined: Wed Jan 22, 2020 6:03 pm
Location: Osnabrück DE 🇩🇪
Contact:

Re: Developing a spreadsheet based loaf pan

Post by thomas-neemann »

Gruß Dipl.-Ing. (FH) Thomas Neemann

https://www.youtube.com/@thomasneemann5 ... ry=freecad
Ulicad
Posts: 311
Joined: Tue Aug 16, 2022 10:35 am
Location: de_DE

Re: Developing a spreadsheet based loaf pan

Post by Ulicad »

thomas-neemann wrote: Mon May 29, 2023 9:24 am ...
I see, thank you!

When I have got more than a handful of values in a spreadsheet, I personally would not want to dispense with aliases, as long as the technical functionality is given.

Until now, I only can recommmend them - they are great helpers IMO.

Regards
Uli
Regards, Ulicad / Uli
---
en: New FC-user, virgin to previous CAD-work, labouring on his new hobby Ulis Blog
de: Neuer FC-Nutzer, ohne vorhergehende CAD-Erfahrung, beschäftigt mit seinem neuen Hobby Ulis Blog
Ulicad
Posts: 311
Joined: Tue Aug 16, 2022 10:35 am
Location: de_DE

Re: Developing a spreadsheet based loaf pan

Post by Ulicad »

Could someone kindly help out?

I am at correcting some errors now in the dependencies / spreadsheets, which control the sketches and object-offsets.

Regarding the 'Insertion part', FC says 1DOFs, and I could not find it. Also have tried 'wiggling' -without success.

1DOF.png
1DOF.png (122.61 KiB) Viewed 1366 times

Please disregard everything else for the moment.
Attachments
tmp365-1DOF.loafpan.model2.0.1.base-14.FCStd
(338.91 KiB) Downloaded 16 times
Regards, Ulicad / Uli
---
en: New FC-user, virgin to previous CAD-work, labouring on his new hobby Ulis Blog
de: Neuer FC-Nutzer, ohne vorhergehende CAD-Erfahrung, beschäftigt mit seinem neuen Hobby Ulis Blog
User avatar
Shalmeneser
Veteran
Posts: 9474
Joined: Wed Dec 23, 2020 12:04 am
Location: Fr

Re: Developing a spreadsheet based loaf pan

Post by Shalmeneser »

When you have 5 times the same dimension, it's a problem : You must try to use geometrical constraints before dimensional constraints.
If you cannot manage with this sketch, try more simple sketches : 1 for the global form, 1 for the details.

Sometimes, it's better to redo everything from scratch for a better solution.

https://en.wikipedia.org/wiki/KISS_principle
Attachments
tmp365-1DOF.loafpan.model2.0.1.base-14_SHALM.FCStd
(30.79 KiB) Downloaded 10 times
Annotation 2023-06-06 132533.jpg
Annotation 2023-06-06 132533.jpg (14.56 KiB) Viewed 1321 times
Ulicad
Posts: 311
Joined: Tue Aug 16, 2022 10:35 am
Location: de_DE

Re: Developing a spreadsheet based loaf pan

Post by Ulicad »

Shalmeneser wrote: Tue Jun 06, 2023 11:24 am... If you cannot manage with this sketch, try more simple sketches : 1 for the global form, 1 for the details.

Sometimes, it's better to redo everything from scratch for a better solution. ...
For a beginner, to follow the KISS-principle is not so easy - even if I am very fond of it...

Anyway, I now understand most of what is said and it helps greatly! 8-) :D

Having two sketches, how could you avoid the 'multiple solids' error when padding both? (Was not able to understand this from your sample :( )

multiple-solids.png
multiple-solids.png (4.18 KiB) Viewed 1269 times

Redoing from scratch most, if not all, is for a future work - if I find the time..

Regarrds
Uli
Regards, Ulicad / Uli
---
en: New FC-user, virgin to previous CAD-work, labouring on his new hobby Ulis Blog
de: Neuer FC-Nutzer, ohne vorhergehende CAD-Erfahrung, beschäftigt mit seinem neuen Hobby Ulis Blog
User avatar
Shalmeneser
Veteran
Posts: 9474
Joined: Wed Dec 23, 2020 12:04 am
Location: Fr

Re: Developing a spreadsheet based loaf pan

Post by Shalmeneser »

Ulicad wrote: Tue Jun 06, 2023 8:36 pm Having two sketches, how could you avoid the 'multiple solids' error when padding both? (Was not able to understand this from your sample :( )
The 2 sketches need to create solids in contact :
* sketches here are tangent
* padding is in the same direction
* linearPattern is along the side of the 1st sketch

caveat : this LinearPattern will need to be inside a PartDesign_MultiTransform with its own PartDesign_Mirrored.
chrisb
Veteran
Posts: 53922
Joined: Tue Mar 17, 2015 9:14 am

Re: Developing a spreadsheet based loaf pan

Post by chrisb »

Shalmeneser wrote: Tue Jun 06, 2023 9:40 pm * sketches here are tangent
To add to this: A single point of touching is not enough.
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.
User avatar
Shalmeneser
Veteran
Posts: 9474
Joined: Wed Dec 23, 2020 12:04 am
Location: Fr

Re: Developing a spreadsheet based loaf pan

Post by Shalmeneser »

A single line neither.
Post Reply