How to import Airfoil coordinates from Excel to CATIA V5?

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 พ.ย. 2024

ความคิดเห็น • 59

  • @MechStuff
    @MechStuff  3 ปีที่แล้ว

    Link for downloading airfoil coordinates - airfoiltools.com/
    Link for downloading the special file for importing the coordinates - mechstuff.com/how-to-import-airfoil-coordinates-from-excel-to-catia/
    Keep learning ;)

  • @manelaero7709
    @manelaero7709 3 ปีที่แล้ว +10

    Thank you very much. There is a very important detail not precise in the video: THE Generative Xls file MUST BE in the same emplacement as the CATIA file. If not, the macro will display an error and fail to import points to CATIA. This happened to me, I have understood the problem later. I share the idea with whose are concerned by this problem.

    • @duartepereira9400
      @duartepereira9400 2 ปีที่แล้ว

      Hi , and how do i do that ?

    • @sathishecs2001
      @sathishecs2001 2 ปีที่แล้ว

      Can you please elaborate on the location of the file?

  • @mariomeca1952
    @mariomeca1952 ปีที่แล้ว +3

    This tutorial is great and it worked for my R21 catia release, but in R28 version is not working. After i click "ok" in macro, it shows up a table writing:
    "Microsoft Visual Basic for Aplication
    License information for this component not found. You do not have an appropriate license to use this functionality in the design environment."
    Please do you know which license is required for this operation ?

  • @yuriymarikus7951
    @yuriymarikus7951 ปีที่แล้ว

    WOW ! You are monster ! Awesome work , Thanks a lot ! I have CATIA v5 R30. All works perfect !!!

  • @soryegetun529
    @soryegetun529 2 ปีที่แล้ว

    thx so much awesome explanation! I was using spline and linking all of the points before watching this video :D

  • @sathya4015
    @sathya4015 3 ปีที่แล้ว +7

    I m getting object doesn't support this property or method,what to do?

    • @karnirathore9853
      @karnirathore9853 3 ปีที่แล้ว

      same here

    • @astafzciba
      @astafzciba 2 ปีที่แล้ว

      @@karnirathore9853 something is off about this tutorial. some steps were skipped

    • @sjjerome8706
      @sjjerome8706 17 วันที่ผ่านมา +1

      I got the same error.
      I closed the product file and opened a part file and then it worked fine for me...

  • @carlojonathanbramasco8358
    @carlojonathanbramasco8358 3 หลายเดือนก่อน

    is there a way to commect all the points with lines instead of sp;ine?

  • @ajaygopal7709
    @ajaygopal7709 ปีที่แล้ว

    I want to trim a specified portion of the imported airfoil in Catia but the trim option seems not working(nor the eraser)....any idea what to do as I need to put a stepping on the aerofoil for analysis

  • @HaNguyen-if7sy
    @HaNguyen-if7sy ปีที่แล้ว

    Can you show me how to create a marco and then put the command into CATIA, please?

  • @luiscicerone410
    @luiscicerone410 4 หลายเดือนก่อน

    Dear Jay, I have a problem: on the aforementioned website to have the coordinates of the airfoils, the X and Y coordinates are coming together, in the same cell (example: 100.957,-0.9587). How do you make the coordinates come in different cells? Thanks in advance for your time.

    • @MechStuff
      @MechStuff  หลายเดือนก่อน

      You can check how to split values in Excel

  • @Rican459
    @Rican459 หลายเดือนก่อน

    Is there a way to modify the script and allow for more than just 500 points to import at once? I am looking to import around 350,000 points

    • @MechStuff
      @MechStuff  หลายเดือนก่อน

      Perhaps. I am not sure. You can try and let us all know:)

  • @abhilashm6711
    @abhilashm6711 3 ปีที่แล้ว +2

    Sir how can I important the airfoil as an angle with respect to y axis?

    • @thongtongeamsaard7589
      @thongtongeamsaard7589 2 ปีที่แล้ว

      you can use airfoil plotter in airfoiltools for define twist angle

  • @frankstinson1949
    @frankstinson1949 2 ปีที่แล้ว

    I am trying to import this airfoil to ansys from catia after did some modification, should I fill the profile and import these as an surface to ansys to do make cfd analysis??

    • @MechStuff
      @MechStuff  2 ปีที่แล้ว +1

      Yes.. Exactly! Extrude the profile and export it to ANSYS if you want to simulate a 3D wing OR just the fill the profile to make it as surface for carrying out a 2D simulation.

  • @evansmichelo883
    @evansmichelo883 2 ปีที่แล้ว

    How do you get to see these points after running macros?

  • @englishhsilgne3451
    @englishhsilgne3451 3 ปีที่แล้ว

    Sir I am create a part in part design but this part I want to transfer to DMU kinematics but the part are not transfer . when I open DMU kinematics New Page are open and I see the windows options that time this part are see but that part I am not worked

  • @duartepereira9400
    @duartepereira9400 2 ปีที่แล้ว +1

    I have been getting a "type mismatch" error in the exel , no idea What's refering to

    • @РусланПагоня
      @РусланПагоня ปีที่แล้ว

      Hi! Now you now the solution?

    • @mastertiti2759
      @mastertiti2759 ปีที่แล้ว +1

      @@РусланПагоня Hi, I found out that "type mismatch" error is linked to the fact that the "." operator in the numbers impact the fact that the cells are considered as text and not as numbers. To avoid that just select all the list and click on the warning sign + click on convert to number. Then launch the macro, it now shoul dbe working. Hope i helped you.

    • @РусланПагоня
      @РусланПагоня ปีที่แล้ว

      @@mastertiti2759 I can't check it now, but I really thankful to you!

  • @sathishecs2001
    @sathishecs2001 2 ปีที่แล้ว +1

    When I run Macros, a 'Microsoft Visual Basic' dialog box with a message "Object doesn't support this property or method". Can anyone help???

    • @РусланПагоня
      @РусланПагоня ปีที่แล้ว

      Hi! I had this problem too, i make some movement like the: reopen Catia file na save him, after that i convert text to columns wizard. After that i have another problem with "type mismatch".

    • @phildieudonne5038
      @phildieudonne5038 ปีที่แล้ว

      @@РусланПагоня Did you manage to solve it finally?

    • @manosorfeas
      @manosorfeas 9 หลายเดือนก่อน

      I know I'm late, I leave this here for the future.
      Just found the solution to that. You probably are not inside the part. You have to have the part open in catia. Check if for example you have the product open (instead of the part).

    • @sjjerome8706
      @sjjerome8706 17 วันที่ผ่านมา

      I had the same issue.
      Closed the product file and opened a product file. Then it worked fine for me...

  • @Yelon724
    @Yelon724 ปีที่แล้ว

    hello, im face an issue. I am able to import the geometry to catia V5 but not the points along with spline. pls help

    • @meryemtemiz2151
      @meryemtemiz2151 8 หลายเดือนก่อน

      Me too. I solved by viewing Macros again and choosing CreationSpline instead of Main

    • @amogh3195
      @amogh3195 หลายเดือนก่อน

      @@meryemtemiz2151 it says object doesnot support this property...im in part design

    • @amogh3195
      @amogh3195 หลายเดือนก่อน

      @@meryemtemiz2151 it says object doesnot support this property...im in part design

  • @riadelhamoud4823
    @riadelhamoud4823 4 ปีที่แล้ว

    i would like to know how you do a solid in the last part of the video ???

    • @MechStuff
      @MechStuff  4 ปีที่แล้ว +1

      Hello Riad, you asked & here it is - th-cam.com/video/8nNGjFvoQK8/w-d-xo.html :)

    • @riadelhamoud4823
      @riadelhamoud4823 4 ปีที่แล้ว

      @@MechStuff thank u very much. U're the best

  • @Hoooked_On_Hiking_Nomad_Style
    @Hoooked_On_Hiking_Nomad_Style 3 ปีที่แล้ว

    In naca profile tools where is the option to download the coordinates

    • @MechStuff
      @MechStuff  3 ปีที่แล้ว

      Hello, when you click on any airfoil, you'll see an option named - "Send to airfoil plotter" on the right side.
      After that, click on download "CSV file of coordinates"
      There you go :D

    • @jongeunpark247
      @jongeunpark247 5 หลายเดือนก่อน

      @@MechStuff that was big help for me thanks bro

  • @shuvekshasapkota5574
    @shuvekshasapkota5574 3 ปีที่แล้ว

    How to export 3d coordinates?

    • @MechStuff
      @MechStuff  3 ปีที่แล้ว

      Hello, I don't think that its quite possible.
      You will have to extract coordinates at multiple locations/sections.

  • @pavankumarpc5066
    @pavankumarpc5066 3 ปีที่แล้ว

    How to get coordinate

    • @MultiSamer11
      @MultiSamer11 3 ปีที่แล้ว +1

      airfoiltools com

    • @MechStuff
      @MechStuff  3 ปีที่แล้ว +1

      Here is the one I used in the video - airfoiltools.com/airfoil/details?airfoil=naca2411-il

  • @MegaMirza75
    @MegaMirza75 2 ปีที่แล้ว +1

    sir can you help me please, for the "2" option i cant put curve in catia, it says "System Error & H80004005 (-2147467259). Unspecified error"

    • @MechStuff
      @MechStuff  2 ปีที่แล้ว

      Hello, that's an error related to Excel/MS Office. I am sorry, but I haven't come across it ever. Try re-installing your MS Office (if you have downloaded it or using pirated version). Else you can look about it here -
      stackoverflow.com/questions/30539623/excel-giving-system-error-h80004005-2147467259-unspecified-error-message#:~:text=I%27m%20almost%20100,think%20it%20worked!

    • @MegaMirza75
      @MegaMirza75 2 ปีที่แล้ว

      @@MechStuff i have found the solution sir,its cuzc of the point is like in the same line, i just need to lessen the number of coordinates

  • @ratnapatel21
    @ratnapatel21 3 ปีที่แล้ว +1

    I do not have any macron code written in my excel then what should i do

    • @MechStuff
      @MechStuff  3 ปีที่แล้ว

      Sorry, I didn't quite exactly get your problem :(

    • @farhansadique4463
      @farhansadique4463 3 ปีที่แล้ว

      @@MechStuff How to get the codes? that you used, same question

    • @MechStuff
      @MechStuff  3 ปีที่แล้ว

      @Farhan @Ratna The macro code you are talking about is a separate Excel file you need to download. You can download it from my blog, I have given the link in the description.

  • @yamrajoli3834
    @yamrajoli3834 3 ปีที่แล้ว

    sir in my excel it is shoing subscript out of range in excel and my program is not running in catia ? what to do sir

    • @vishwasshetty4858
      @vishwasshetty4858 2 ปีที่แล้ว

      Bro did you get any solution

    • @yamrajoli3834
      @yamrajoli3834 2 ปีที่แล้ว

      @@vishwasshetty4858 yes bro i had generated using macro in catia see my video