hexagon logo

excel report of textual analysis

I did a textual analysis for each hit point. The deviation of each hit point can be seen in the report window with pdf type. Since the data need to be analyzed in JMP, I hope to export excel/txt version. Does anyone know if there is a method to export textual analysis results for each hit point? Thanks.
Parents
  • I would do it the long way with individual hit points being reported and collected via csv.
    If you have the naming conventions setup well, you could handle it with a DoUntil so you don't have to have an individual output for each hit point.

    it would look something like this:
    ASSIGN/COUNTR=0
    ASSIGN/PNT_NAM="PNT_"
    DO/
    ASSIGN/COUNTR=COUNTR+1
    ASSIGN/FEAT_NAM=PNT_NAM + COUNTR
    DIM "REPT_"+COUNTR= LOCATION OF POINT FEAT_NAM UNITS=IN ,$
    GRAPH=OFF TEXT=OFF MULT=10.00 OUTPUT=BOTH HALF ANGLE=NO
    AX MEAS NOMINAL +TOL -TOL DEV OUTTOL
    T 0.0000 0.0000 0.0020 0.0020 0.0000 0.0000 -#--
    END OF DIMENSION "REPT_"+COUNTR
    UNTIL/COUNTR==50​
    
Reply
  • I would do it the long way with individual hit points being reported and collected via csv.
    If you have the naming conventions setup well, you could handle it with a DoUntil so you don't have to have an individual output for each hit point.

    it would look something like this:
    ASSIGN/COUNTR=0
    ASSIGN/PNT_NAM="PNT_"
    DO/
    ASSIGN/COUNTR=COUNTR+1
    ASSIGN/FEAT_NAM=PNT_NAM + COUNTR
    DIM "REPT_"+COUNTR= LOCATION OF POINT FEAT_NAM UNITS=IN ,$
    GRAPH=OFF TEXT=OFF MULT=10.00 OUTPUT=BOTH HALF ANGLE=NO
    AX MEAS NOMINAL +TOL -TOL DEV OUTTOL
    T 0.0000 0.0000 0.0020 0.0020 0.0000 0.0000 -#--
    END OF DIMENSION "REPT_"+COUNTR
    UNTIL/COUNTR==50​
    
Children
No Data