hexagon logo
Register Sign in
  • Replies 10 replies
  • Subscribers 222 subscribers
  • Views 186 views
  • Users 0 members are here
Options
Related

Customizing Excel sheets

1_PLAYER_9
I am trying to output the data into an excel sheet but there are a few things that i need to make it work for what i am trying to do. We run three parts per hour and we have about 15 measurements per part. How can i create an excel sheet that will have left column as the dimension id, then the measured values for each dimensions on the second column and continues for every part there after.

3/22/2016 6:00A 3/22/2016 7:00A 3/22/2016 8:00A 3/22/2016 9:00A 3/22/2016 10:00A ETC…
HEIGHT A 0.153 0.155 0.156 0.154 0.153 ETC…
HEIGHT B 2.65 2.66 2.64 2.6 2.63 ETC…
HEIGHT C 1.35 1.36 1.33 1.35 1.33 ETC…
DIAMETER A 0.296 0.302 0.301 0.299 0.264 ETC…
DIAMETER B 0.034 0.034 0.036 0.033 0.033 ETC…
DIAMETER C 0.0296 0.024 0.026 0.025 0.024 ETC…

PLEASE HELP....
Parents
  • Yes. This is what I would do. I typically use CSV's for stuff like this.

    Create a CSV file from Excel, save it into a location where you know it will be. Within each cell create these as your headers:

    Date | Time | Height A | Height B | Height C | Diameter A | Diameter B | Diameter C

    Save the CSV and Close it.

    Then in your program do this: 

    FPTR       =FILE/OPEN,M:\Quality\CMM - Plex Data Import\Blank CSV Template.csv,APPEND
CIR1       =FEAT/CONTACT/CIRCLE/DEFAULT,CARTESIAN,IN,LEAST_SQR
            THEO/<0,0,0.1>,<0,0,1>,0.25
            ACTL/<0,0,0.1>,<0,0,1>,0.25
            TARG/<0,0,0.1>,<0,0,1>
            START ANG=0,END ANG=360
            ANGLE VEC=<0,1,0>
            DIRECTION=CCW
            SHOW FEATURE PARAMETERS=NO
            SHOW CONTACT PARAMETERS=NO
CIR2       =FEAT/CONTACT/CIRCLE/DEFAULT,CARTESIAN,IN,LEAST_SQR
            THEO/<0,0,0.2>,<0,0,1>,0.3
            ACTL/<0,0,0.2>,<0,0,1>,0.3
            TARG/<0,0,0.2>,<0,0,1>
            START ANG=0,END ANG=360
            ANGLE VEC=<0,1,0>
            DIRECTION=CCW
            SHOW FEATURE PARAMETERS=NO
            SHOW CONTACT PARAMETERS=NO
CIR3       =FEAT/CONTACT/CIRCLE/DEFAULT,CARTESIAN,IN,LEAST_SQR
            THEO/<0,0,0.3>,<0,0,1>,0.35
            ACTL/<0,0,0.3>,<0,0,1>,0.35
            TARG/<0,0,0.3>,<0,0,1>
            START ANG=0,END ANG=360
            ANGLE VEC=<0,1,0>
            DIRECTION=CCW
            SHOW FEATURE PARAMETERS=NO
            SHOW CONTACT PARAMETERS=NO
DIM LOC1= LOCATION OF CIRCLE CIR1  UNITS=IN ,$
GRAPH=OFF  TEXT=OFF  MULT=10.00  OUTPUT=BOTH  HALF ANGLE=NO
AX    NOMINAL       MEAS       +TOL       -TOL        DEV     OUTTOL
Z       0.1000     0.1000     0.1000     0.1000     0.0000     0.0000 ---#----
D       0.2500     0.2500     0.1000     0.1000     0.0000     0.0000 ---#----
END OF DIMENSION LOC1
DIM LOC2= LOCATION OF CIRCLE CIR2  UNITS=IN ,$
GRAPH=OFF  TEXT=OFF  MULT=10.00  OUTPUT=BOTH  HALF ANGLE=NO
AX    NOMINAL       MEAS       +TOL       -TOL        DEV     OUTTOL
Z       0.2000     0.2000     0.1000     0.1000     0.0000     0.0000 ---#----
D       0.3000     0.3000     0.1000     0.1000     0.0000     0.0000 ---#----
END OF DIMENSION LOC2
DIM LOC3= LOCATION OF CIRCLE CIR3  UNITS=IN ,$
GRAPH=OFF  TEXT=OFF  MULT=10.00  OUTPUT=BOTH  HALF ANGLE=NO
AX    NOMINAL       MEAS       +TOL       -TOL        DEV     OUTTOL
Z       0.3000     0.3000     0.1000     0.1000     0.0000     0.0000 ---#----
D       0.3500     0.3500     0.1000     0.1000     0.0000     0.0000 ---#----
END OF DIMENSION LOC3
            ASSIGN/SYSDAT=SYSTEMDATE("MMMM dd yyyy")
            ASSIGN/SYSTIM=SYSTEMTIME("HH:mm:ss")
            ASSIGN/V1=SYSDAT+","+SYSTIM
            ASSIGN/V2=LOC1.Z.MEAS+","+LOC2.Z.MEAS+","+LOC3.Z.MEAS
            ASSIGN/V3=LOC1.D.MEAS+","+LOC2.D.MEAS+","+LOC3.D.MEAS
            ASSIGN/V4=V1+","+V2+","+V3
            FILE/WRITELINE,FPTR,V4
            FILE/CLOSE,FPTR,KEEP


    Your FILE I/O commands are in Insert - FILE I/O Command... this is where the File Open, File Close, Write Line, etc are located. Hope this helps.
Reply
  • Yes. This is what I would do. I typically use CSV's for stuff like this.

    Create a CSV file from Excel, save it into a location where you know it will be. Within each cell create these as your headers:

    Date | Time | Height A | Height B | Height C | Diameter A | Diameter B | Diameter C

    Save the CSV and Close it.

    Then in your program do this: 

    FPTR       =FILE/OPEN,M:\Quality\CMM - Plex Data Import\Blank CSV Template.csv,APPEND
CIR1       =FEAT/CONTACT/CIRCLE/DEFAULT,CARTESIAN,IN,LEAST_SQR
            THEO/<0,0,0.1>,<0,0,1>,0.25
            ACTL/<0,0,0.1>,<0,0,1>,0.25
            TARG/<0,0,0.1>,<0,0,1>
            START ANG=0,END ANG=360
            ANGLE VEC=<0,1,0>
            DIRECTION=CCW
            SHOW FEATURE PARAMETERS=NO
            SHOW CONTACT PARAMETERS=NO
CIR2       =FEAT/CONTACT/CIRCLE/DEFAULT,CARTESIAN,IN,LEAST_SQR
            THEO/<0,0,0.2>,<0,0,1>,0.3
            ACTL/<0,0,0.2>,<0,0,1>,0.3
            TARG/<0,0,0.2>,<0,0,1>
            START ANG=0,END ANG=360
            ANGLE VEC=<0,1,0>
            DIRECTION=CCW
            SHOW FEATURE PARAMETERS=NO
            SHOW CONTACT PARAMETERS=NO
CIR3       =FEAT/CONTACT/CIRCLE/DEFAULT,CARTESIAN,IN,LEAST_SQR
            THEO/<0,0,0.3>,<0,0,1>,0.35
            ACTL/<0,0,0.3>,<0,0,1>,0.35
            TARG/<0,0,0.3>,<0,0,1>
            START ANG=0,END ANG=360
            ANGLE VEC=<0,1,0>
            DIRECTION=CCW
            SHOW FEATURE PARAMETERS=NO
            SHOW CONTACT PARAMETERS=NO
DIM LOC1= LOCATION OF CIRCLE CIR1  UNITS=IN ,$
GRAPH=OFF  TEXT=OFF  MULT=10.00  OUTPUT=BOTH  HALF ANGLE=NO
AX    NOMINAL       MEAS       +TOL       -TOL        DEV     OUTTOL
Z       0.1000     0.1000     0.1000     0.1000     0.0000     0.0000 ---#----
D       0.2500     0.2500     0.1000     0.1000     0.0000     0.0000 ---#----
END OF DIMENSION LOC1
DIM LOC2= LOCATION OF CIRCLE CIR2  UNITS=IN ,$
GRAPH=OFF  TEXT=OFF  MULT=10.00  OUTPUT=BOTH  HALF ANGLE=NO
AX    NOMINAL       MEAS       +TOL       -TOL        DEV     OUTTOL
Z       0.2000     0.2000     0.1000     0.1000     0.0000     0.0000 ---#----
D       0.3000     0.3000     0.1000     0.1000     0.0000     0.0000 ---#----
END OF DIMENSION LOC2
DIM LOC3= LOCATION OF CIRCLE CIR3  UNITS=IN ,$
GRAPH=OFF  TEXT=OFF  MULT=10.00  OUTPUT=BOTH  HALF ANGLE=NO
AX    NOMINAL       MEAS       +TOL       -TOL        DEV     OUTTOL
Z       0.3000     0.3000     0.1000     0.1000     0.0000     0.0000 ---#----
D       0.3500     0.3500     0.1000     0.1000     0.0000     0.0000 ---#----
END OF DIMENSION LOC3
            ASSIGN/SYSDAT=SYSTEMDATE("MMMM dd yyyy")
            ASSIGN/SYSTIM=SYSTEMTIME("HH:mm:ss")
            ASSIGN/V1=SYSDAT+","+SYSTIM
            ASSIGN/V2=LOC1.Z.MEAS+","+LOC2.Z.MEAS+","+LOC3.Z.MEAS
            ASSIGN/V3=LOC1.D.MEAS+","+LOC2.D.MEAS+","+LOC3.D.MEAS
            ASSIGN/V4=V1+","+V2+","+V3
            FILE/WRITELINE,FPTR,V4
            FILE/CLOSE,FPTR,KEEP


    Your FILE I/O commands are in Insert - FILE I/O Command... this is where the File Open, File Close, Write Line, etc are located. Hope this helps.
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement