Cross File Parametric Modelling | Shared Spreadsheets and Technical Drawings | Mastering FreeCAD | 3

Поделиться
HTML-код
  • Опубликовано: 4 авг 2023
  • Using FreeCAD and a single spreadsheet we will learn how to model multiple parts in individual files where each shares the same spreadsheet. Updates to the spreadsheet will update all parts in the individual files. We will also learn how we can use the link tool to create a documentation project that holds a linked spreadsheet and technical drawing of the part that resides in a different file.
    This series run along side the learning FreeCAD for beginners series.
    #FreeCAD , #CAD , #3DPrinting
    Journey with me and
    Patreon
    / mangojellysolutions
    Donate:
    ko-fi.com/mang0
    Subscribe:
    / @mangojellysolutions
    Browse my Redbubble Shop:
    MangojellyLabs.redbubble.com
    Blog:
    mangojellysolutions.blogspot....

Комментарии • 33

  • @GCAT01Living
    @GCAT01Living 4 часа назад +2

    OH MY GOD I've been Googling for HOURS and trying to find the answer to this on the damn FreeCAD forum and wiki and FINALLY you tell me how to link a damn spreadsheet and show how it works. jfc dude you are amazing. This isn't the first video of yours I have referenced and I shouldn't be surprised you had the answer. You are a live (and sanity) saver! 🙇

  • @bmarvin6339

    I use sketches sometimes to solve geometry to extract a resulting dimension as a labeled reference dimension. This might involve lines tangent to an arc or circle then other perpendicular to that. It would require trigonometry calculations to arrive at the dimension I need. It is easier to let the solver do the math and let me use the results. I extract the need dimension using a reference distance that is given a label. I then use that calculated reference dimension in other sketches using the expression editor like <>.Constraints.DistBelowXYPlane. This works well within a single part file from sketch to sketch. But I cannot get it to access sketch constraints that are in a linked part file. In some cases, I have done the trigonometry calculations in the spreadsheet to create a sketch constraining dimension, so I can do the math, but it is easier to let the solver do the math for me and extract the resulting desired dimension. How do you use sketch constraints that are in a sketch from another part file?

  • @gregwoolley

    Excellent! Super helpful video. A big thank you!

  • @pytebyte

    Very helpful tutorial. One issue when working with Aliases from a linked Spreadsheet is that you have to type the complete name when using it inside the Sketch Editor for example. With a normal Spreadsheet it shows you some options when you start typing.

  • @philip_fletcher

    In Part Design I still use 'Part' - made up of multiple 'Body's to help manage complex designs.

  • @philb2334

    Brilliant video. I didn't know you could refer to a spreadsheet cell by Reference. Until now I've been doing it by Alias & if I have 20 or so cells Aliased it bogged FreeCAD down to a crawl.

  • @bjnobre

    Great tutorial!!! Best freecad channel. 👏🏻👏🏻👏🏻

  • @OhHeyTrevorFlowers

    Oh, interesting. I always use Links to Parts, even for parts that are created in the Part Design workbench.

  • @annacleto5193

    I've been following your videos, completed your latch assembly tutorials, but still can't get satisfactory results on an STP file I'm trying to edit. It is a cover for GPD Win Max 2's M.2 2230 with a hole to allow for an oculink connection. I need to move the hole to fit my adapter. Is there a way I can send you the STP file and a photo of an edited cover to pinpoint new location so that you can teach me or even make a new tuitorial on how to do this?

  • @BowenMarmot

    I am really enjoying this series! Learning lots about a tool I use a fair bit! Thanks!

  • @russellw5447

    Nice Tut as usual, linking files seems a good way to save time (especially if you have a lot of similar types of Parts). Export to Paper, SVG & DXF also. On to the next lot.

  • @sjn8099

    Wow. Great. Thank you 🙂

  • @KnotHead1008

    👍👍👍

  • @user-ho1px7im8r

    I think you have some of the best FreeCad tutorials on the internet. I have learned so much from watching them. Thank you.

  • @jorgepr13

    Thank you!

  • @tuesss
    @tuesss  +1

    Great tutorial as always, thank you!

  • @mordantly

    Can spreadsheet 2 cell a1 reference spreadsheet 1 cell a1? Spreadsheet 1 link in part clone to alter some specific dimensions only.

  • @clausziegler5720

    Hi, I have a question: You have several parts - Part A, Part B, Part C, etc. Now you would like to have a slight modification of Part B, but want to keep Part B as it is, so different Version of Part B, say Part B.1. Would it be possible just to duplicate the file Part B and rename it to Part B.1 and start working from there to modifiy it and create a different Version of Part B?

  • @fooballers7883

    Got to use this ... in my work flow...Could be dam good.... thanks....much appreciated.