FreeCAD 0.20 For Beginners | 21 | : Spreadsheet Configuration Tables | Dimensions from a Dropdown

Тәжірибелік нұсқаулар және стиль

Using a spreadsheet in FreeCAD to control the dimension and configuration of your part is all well and good but you don't want to be changing the values all the time. FreeCAD allows you to set up multiple rows in your spreadsheet and label these as configurations which will appear as a drop down on your part allow you to select which one you want without updating your spreadsheet.
In this course we teach the fundamentals of freeCAD using the basics but delivering via teaching you different workflows. In one lesson you may be learning how to sketch and build a model but will also be following a workflow that will take through the part design workbench all the way to exporting it out in STL format. In another lesson you may be learning how to model in the part workbench to see the differences between it and the part workbench but you will be following a workflow that will allow you to create 2D plans of your model to laser / paper cut.
We aim to teach you freeCAD in a practical way.
Please follow the playlist at: • FreeCAD 0.20 / 0.21 Fo...
to keep up to date with the video releases.
#FreeCAD , #CAD , 3DPrinting
Journey with me and
Patreon
/ mangojellysolutions
Donate:
ko-fi.com/mang0
Subscribe:
/ @mangojellysolutions
Browse my Redbubble Shop:
MangojellyLabs.redbubble.com

Пікірлер: 67

  • @gerardstrik2555
    @gerardstrik2555 Жыл бұрын

    I've got a 3D printer for some time. Depended on models from others for printing. But since I picked up your videos I can do the models myself. The parametric capabilities of Freecad is just a bonus. Something I very much like and exploit to the fullest. :D

  • @stewartpalmer2456

    @stewartpalmer2456

    Жыл бұрын

    You found an awesome source for teaching. I went along time learning the hard way until a specific search landed a Mango Jelly result. Have fun.

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    Great to hear your learning how to do it yourself. I think even with the simple things it gives you more satisfaction to make it yourself rather than downloading, and with the extra bonus you gain the knowledge. Thanks for the comments.

  • @mikemissesthefairway
    @mikemissesthefairway Жыл бұрын

    Ah! This is so much easier than making a master sketch containing all my dimensions and then constantly referencing to the sketch. Using a spreadsheet makes this a breeze. Thank you for this!

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    Glad your finding it useful 😁. Freecad seems to be full of all these little secrets.

  • @carlbukowsky1931
    @carlbukowsky1931 Жыл бұрын

    I want to say thanks for explaining and sharing. I'm learning so much and these tutorials have allowed me to realize just how capable FC is for my modeling needs. And I also appreciate the comments; you take the opportunity to clarify and expound on the question or comment which adds even more value (now I have to back-track to the previous tutorials and read through the comments to see what else I may have overlooked!).

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    Your so welcome. You have a really valid point regarding the comments, not just from me but from all contributors. They really enrich the channel. I wish KZread had an in-depth search feature that people could use. I am trying to make an index into all these videos so the index can be hosted from my website. The index is aimed to allow a visual search so you can identify the video quickly that will be useful for your application. Question and answers are something to train the index on or connect to the video some way. I need to see if I can find a quick way to tag this into the video descriptions. It’s a huge project so it’s going to take some time

  • @kissingfrogs
    @kissingfrogs Жыл бұрын

    Very cool feature. Thanks for explaining and sharing. And centered rectangle - how did I miss that. Something I have wanted has been there all along. So many cool tips watching these videos.

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    I think the centered rectangle only appeared in 0.20. Glad you enjoy, a lot more to come 😁👍

  • Жыл бұрын

    Awesome. Infinity possibilities. Thanks!

  • @atabodur77
    @atabodur77 Жыл бұрын

    Than You! Great helpful video!

  • @azshark1942
    @azshark1942 Жыл бұрын

    Great video! Thanks for explaining these features of the Spreadsheet WB, this is an outstanding feature to be able to model dimensional modifications to an existing part. I would like to see some advanced features of the A2plus WB and the Exploded Assembly WB that you made a couple of weeks ago, this was an eye opener, and extremely simple to enact.

  • @AppliedMathematician
    @AppliedMathematician Жыл бұрын

    Thanks! That is very useful!

  • @loicnicolas5002
    @loicnicolas5002 Жыл бұрын

    I tried the config on the partDesign Workbench, for the sizing of the flanges for the piping, it's nickel 👍

  • @stewartpalmer2456
    @stewartpalmer2456 Жыл бұрын

    Just keep swimming. Just keep swimming...Great video. I need to remember to use this feature to keep track of measurements in the program rather then on paper. I thought it was enough to be starting with sketches, but now the sketches can be linked with spreadsheets. Got it. Thank you. I think I new this but have been not wanting to go this deep on prototyping. True parametric modeling.

  • @kissingfrogs

    @kissingfrogs

    Жыл бұрын

    I kick myself every time I start a new project without using a spreadsheet. So handy when time passes and I come back to previous project. Its more initial effort but often worth it.

  • @stewartpalmer2456

    @stewartpalmer2456

    Жыл бұрын

    @@kissingfrogs I know computer programming too, so you'd think I would setup the table array first. lol

  • @jakemartens6388
    @jakemartens6388 Жыл бұрын

    Thank You!!! I hope the next video is how to do a large work flow in Assembly4("some thing with like 100 parts" ), and file management and so on. Always love you videos.

  • @donstelfox2936
    @donstelfox2936 Жыл бұрын

    Thank you. Cheers

  • @chuckbenedict7235
    @chuckbenedict72356 ай бұрын

    Top quality content, masterfully explained.

  • @MangoJellySolutions

    @MangoJellySolutions

    6 ай бұрын

    Thank you so much. Glad you enjoyed it

  • @simonetrainito5749
    @simonetrainito5749 Жыл бұрын

    Thanks so much

  • @classic_sci_fi
    @classic_sci_fi7 ай бұрын

    It works much better when I don't confuse the order Length, Width, Height with Height, Width, Length...

  • @fooballers7883
    @fooballers7883 Жыл бұрын

    Again a nice one... handy tool , must start using. Thank you.

  • @michaelmerrell8540
    @michaelmerrell8540 Жыл бұрын

    What's driving crazy is the inflexibility of the bindings/configuration tables. Inserting or deleting columns does not update the binding (probably because of the programmatic " + propertyIndex + offset" construction of the binding targets). I've just started to separate out any configuration tables into their own spreadsheets so they remain undisturbed when I'm messing with things in my main spreadsheet. That doesn't help when I want to insert a column into an existing configuration table, though. I've gotten some practice manually creating and editing the bindings for configuration tables, so I'll call it a learning experience! I've managed to create multiple configuration bindings on a single table this way.

  • @rasechc1633
    @rasechc1633 Жыл бұрын

    Excellent videos. You may be able to rack-and-pinion for horizontal or vertical movement. I didn't find much information on this. I would be grateful

  • @ChristianDer3.
    @ChristianDer3. Жыл бұрын

    Danke!

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    Thank you 👍👍👍👍👍

  • @HK-uq9by
    @HK-uq9byАй бұрын

    Thanks, this was another great video. I wanted to suggest if you can make a video to compare Freecad with Autocad

  • @Just_An_Idea_For_Consideration
    @Just_An_Idea_For_Consideration Жыл бұрын

    REQUEST: At some point could you create a series of Tutorial Videos on the Beltrami Workbench? The only videos currently available are in French, but luckily with English Subtitles. I think it is very powerful, for creating Water Turbine Blades, or possibly Vertical Axis Wind Turbine Blades (VAWT). Thanks for considering.

  • @Just_An_Idea_For_Consideration

    @Just_An_Idea_For_Consideration

    Жыл бұрын

    There are a few links to what i have located on Beltrami Workbench, but hard for me to comprehend, and hoping you can study it and explain it more clearly. thx

  • @Pixelwaster
    @Pixelwaster Жыл бұрын

    Been watching your channel quite a bit lately. Mostly jumping around to figure things out as I need them. Good stuff and very helpful. I have been watching this series as it is being uploaded. Just one question - Why the Lattice2 workbench to make the part?

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    Great to see your finding the tutorials useful. In regards to the lattice 2 workbench. The example was originally from a patreon request. You can do it in the part design but you will find it's a) very slow when coming to calculating the transforms and b) you can only go as low as a 2x 3 brick as the lowest amount of tubes you can have is 2 not one as it errors. Lattice 2 you can make the dimensions quite large without loss of speed. You could use part and draft array tools but I decided to kill two birds with one stone as I hadn't done a lattice2 tutorial for a while. The actual tutorial of the lego will be released soon.

  • @Dilshad-gu7je
    @Dilshad-gu7je Жыл бұрын

    This is very helpful. So much easier than plugging in bunches of values each time. I can’t find your video on where you make the brick, can you direct me to it please.

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    It save so much time especially if you are using this for clients or your own business. So that video with the brick hasn't been released yet but it will be available in the coming weeks.

  • @EPaulIII

    @EPaulIII

    Жыл бұрын

    @@MangoJellySolutions Is this video on the "brick" where you explain how to create a model where the number of instances of a feature (the studs on top of the brick) is controlled by parameters (2x2, 2x3, 3x3, etc.)? In other words, is it on how to make the Lego-like block seen in this video? If so, when can we expect it? I want to learn how to use that feature or at least know what it is so I can look it up.

  • @KnotHead1008
    @KnotHead1008 Жыл бұрын

    I'm thinking the next bump is to be able to make the odd brick like the base brick at, 2x2x2, then for shape change add eg, base, 2x2c2x1x6 creating the odd brick. The 1 indicates the height and the 6 indicates length then a. I'm still trying to work out additional shape modifiers. 😩

  • @multiforc271
    @multiforc271 Жыл бұрын

    finally ! some video that i was looking for ! thanks alot !!!!!! THANK YOU !!!!!! please tell me abot using operation from spreadsheet: like activating or suppressing a pad, bolean operation or etc

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    So glad it helps, it's a video that I wasn't sure if I should create but looks like it's been quite popular. Regarding your question freecad doesn't have a way to suppress features unfortunately. But there are ways around that to an extent. Pockets can be reversed, pads can be made so small that they vanish. Patterns can be set to 1 occurance. Until freecad implements these then we have to use what work around we can find. But suppressing features is something I really want.

  • @multiforc271

    @multiforc271

    Жыл бұрын

    @@MangoJellySolutions Thanks, you saved my time again, reaing and looking into those options.

  • @multiforc271

    @multiforc271

    Жыл бұрын

    @@MangoJellySolutions Since you are a nice guys and answer coments, pleae let me ask an other question about FreeCAD: In Ansys there is a Symetry option, to cut the shape into the parts and reduce the amount of processing. (planar. nodal or radial) is there similar option in FreeCAD, OpenFOAM, Elmer or calculix ? I have a cube in middle of a room, and clearly the termal relation can be divided into 4 quarters, which will be similar, I hope to find a symetry option in freecad, I no longer have ansys.

  • @multiforc271

    @multiforc271

    Жыл бұрын

    @@MangoJellySolutions Two more question, how can i change the style of spreadsheets, instead of right clocking on cells and changing their properties; im using prodark them with DarkoverLay style, but when i change the font color to white black, it remains white. i don't know where can i find the setting regarding the spread sheet. second question, what does this field do: Prefference > MainWindow > View Menu Style Sheet

  • @JonnyD000
    @JonnyD000 Жыл бұрын

    Is it possible to get non-configuration table parameters to have an entry in the Data window?

  • @chenrushan219
    @chenrushan2192 ай бұрын

    Thanks for the great tutorial. Newbie question: at 12:59, why does the generated cut not sit under Part, instead, it seems at the same level of Part. I thought when a Part is created and it's active, the result of every following operation will stay in this Part, seems this is not the case

  • @aodhanloki
    @aodhanloki Жыл бұрын

    This is all well and good, but how do I assemble multiple bricks together in a separate file with the ability to select the configuration of each one? I'm trying to do this to save administrative time on A2Plus assemblies by avoiding making many, many different files for things like cabinet doors on a kitchen I'm designing.

  • @multiforc271
    @multiforc271 Жыл бұрын

    Btw, i don't know if it is a new update or not; but to setup the config table, we don't need to set alies in te first row, or even have any number in them, although in the nest steps, we will fill them .

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    Thank for the update and adding this to the comments for me and others to see. Really helps keep people in the loop. Thank you.

  • @supermomandj
    @supermomandjАй бұрын

    Hey Mango, Loving the content so far! Just a quick question. I noticed in my testing that the part cube seems to 'scale' about a corner whereas the body cube seems to 'scale' about the center. Is there a particular reason for this difference? or just a part vs body quirk? Thanks!

  • @supermomandj

    @supermomandj

    Ай бұрын

    Also if by some random chance you happen to see this I was also wondering why in episode 17 (Print in place chain) the interaction only worked once three links were added? Shouldn't movement like that only need one static point to rotate about?

  • @leroycasterline1122
    @leroycasterline1122 Жыл бұрын

    At about 25:10, what is the difference between Spreadsheet and ? In the first part of the exercise, I used Spreadsheet for the Width and for the Height and both (seemed) to work equally well.

  • @95_Nepentheses

    @95_Nepentheses

    Жыл бұрын

    I am pretty sure they're equivalent, but > quotes it so names with whitespace can be supported.

  • @gweliver
    @gweliver10 ай бұрын

    I have just started the second part 13:27, how did you keep the same spreadsheet? You mentioned you are starting a Parts Design workflow, so did you just delete everything other than the spreadsheet or is there a way to create a new project and in the Spreadsheet WB use the import Spreadsheet and choose the FreeCAD file I saved from the first part of this video, however this is not working for me? I will go back and open up my saved file and just delete everything except for the Spreadsheet for now... Thanks, Great video!!!

  • @MangoJellySolutions

    @MangoJellySolutions

    10 ай бұрын

    Sorry I should of explained that. I deleted everything but the spreadsheet. You can actual share spreadsheets across files using the link tool which I cover in the Mastering freecad series. I am not sure why it's failing for you. I need to run through the tutorial myself to make sure that it's not down to a big that's been introduced in the newer versions.

  • @garyweliver1870

    @garyweliver1870

    10 ай бұрын

    I jumped over to the parametricbrick part 1&2 series and this turned out awesome! I feel this lattex2 WB is what I need to use in design of a 2'x4' wall, right? I am just really impressed with your channel

  • @MangoJellySolutions

    @MangoJellySolutions

    10 ай бұрын

    @@garyweliver1870 glad your enjoying. Yes the lattice workbench is an amazing workbench and with creating the wall this would work well. You can even build a compound of bricks if you want then to alternate along the length. . I have a number of lattice 2 workbench tutorials as some of the features are pretty different from any other CAD package. There is even a tutorial for creating plant pot labels from a spreadsheet which creates a layout around each one as you add it to the spreadsheet.

  • @OhHeyTrevorFlowers
    @OhHeyTrevorFlowers Жыл бұрын

    Is it possible to clone a part and then make the new part use a different configuration? For example, the cube in the first part could be 2x3 and the cube in the second part could be 4x6.

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    I think you may be looking for the link tool on the toolbar that appears on each wb. You can link the part which will create a link copy. Then you can change the copy on change option. You have disabled, enabled, tracked and owner I believe. When I last experimented with it I think there was a bug and I couldn't figure out what was exactly happening. I have to have another look to see if I can understand it better. But you will get a copy of the part along with its own drop down.

  • @michaelmerrell8540

    @michaelmerrell8540

    Жыл бұрын

    I think a shape or sub-shape binding allows for this. The bound configuration value on the copy/binding can be set independently.

  • @ChazmillsADLT
    @ChazmillsADLT8 ай бұрын

    The thing is can I replace a number with a string (a name for instance)??

  • @MangoJellySolutions

    @MangoJellySolutions

    8 ай бұрын

    Yes you can as long as the text object you use allows you to replace the text with a formula. If you are interested in configurable text there is also a tool in the lattice workbench that you may be interested in called the paraseries which I created a video about it a while back, here is the link kzread.info/dash/bejne/n46HwcdvotjSpMo.html

  • @ChazmillsADLT

    @ChazmillsADLT

    8 ай бұрын

    Ok thanks, I watched that video, good. You mentioned 3D printing which is what I want it for therefore I would want them extruded to certain lengths! I’ll try it tomorrow but thinking it might not work with extruded names.

  • @Just_An_Idea_For_Consideration
    @Just_An_Idea_For_Consideration Жыл бұрын

    Mistake: when bind B12 and C12 they are reversed but tutorial is great

  • @MangoJellySolutions

    @MangoJellySolutions

    Жыл бұрын

    Ahhh that one got through, thanks for the heads up :)

  • @Just_An_Idea_For_Consideration

    @Just_An_Idea_For_Consideration

    Жыл бұрын

    We can not expect perfection! You are kind enough to produce these very informative videos, that help all of us move forward.

  • @brianprice7020

    @brianprice7020

    Жыл бұрын

    I believe we learn as much by mistakes as being correct. Somehow, the mistakes seem to be more memorable!

  • @Just_An_Idea_For_Consideration

    @Just_An_Idea_For_Consideration

    Жыл бұрын

    I agree, mistakes are my best leasons

Келесі