Exporting Airfoil Analysis Data to a Spreadsheet Using Control X

When working with Control X, you often find yourself needing the data that is generated by the software to be exported in a usable form rather than just a static report. In this post, we are going to show you how we analyzed a machined airfoil. Using this machined airfoil below as an example, suppose we wanted to analyze its contour directly at the end face.

Exporting Control X Data to a Spreadsheet

We first would need to complete a deviation check at random points along the outer perimeter. We could use the Comparison Point tool in Control X to select random points along the area of interest to generate the required data.

The color coding allows us to see where the airfoil contour is “full” from the nominal CAD model as well as where it is “undersized.” The Yellow/Orange/Red colors exported from Control X indicate full conditions whereas the light blue – dark blue colors show that the scan is undersized, as compared to the nominal CAD model.

Exporting Control X Data to a Spreadsheet

We can then select the tool to export the data to a text or CSV file.

Exporting Control X Data to a Spreadsheet

Control X will generate a datasheet with all the information required regarding each randomly selected point with regards to both the selected point on the airfoil surface, as well as the deviation of the airfoil scan from that point.

  • Ref Pos values are the randomly selected points, directly on the nominal CAD model.
  • Meas Pos is the same point, projected using a normal vector from the Ref Pos.
  • Dev Value is the length of that deviation vector showing the actual deviation distance.

Exporting Control X Data to a Spreadsheet
Now let’s look at the custom analysis capabilities of the Airfoil analysis tool and export specific data relative to the airfoil’s key dimensional characteristics.

Leading and Trailing Edge Radii at our chosen section.

Exporting Control X Data to a Spreadsheet

Leading Edge Position

Exporting Control X Data to a Spreadsheet

Maximum Chord Height

Exporting Control X Data to a Spreadsheet

Leading and Trailing Edge Maximum Thickness

Exporting Control X Data to a Spreadsheet

Axial Chord Length

Exporting Control X Data to a Spreadsheet

In our Control X Model, we represent each of these as a Custom Section.

Exporting Control X Data to a Spreadsheet

We can now highlight each of those sections and export their data to a CSV file as well.

Exporting Control X Data to a Spreadsheet

Exporting Control X Data to a Spreadsheet

Please contact Joel Pollet for additional information.