hexagon logo

Help with Excel

Very new to PC Dmis, I used Open Dmis for 8 years. I would like my Excel Report to reflect the Open Dmis output style. While I am trying to figure this out, I noticed that the command mode text is exactly what I am looking for as an output. Is there a simple way for a beginner to do this? This is what I have, versus what I want, (AX, Nom, +Tol, -Tol, Meas, Dev, OUTTOL, --+----)

Parents
  • The Excel output can be formatted any way you want it. My audit programs are set up to measure one or two parts. Operator is prompted to enter 1 or 2. Results are output to a .csv file, each type of feature is targeted to a specific cell in the .csv report.
    Here is an example. The code - FILE/WRITELINE,FPTR,"" - skips a row while the code +","+ advances to the next column.

    FPTR       =FILE/OPEN,(File_Path.csv),WRITE
                FILE/WRITELINE,FPTR,V_PRT+","+","+","+","+","+VCMM
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,"Lot #"+","+","+","+"Operator"+","+","+"Date"+","+"Time (24 Hr)"
                FILE/WRITELINE,FPTR,V10+","+","+","+V_OP+","+","+DAT+","+TIM
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,"TW"+","+"TW"+","+"TW_A"+","+"TW_A"+","+"TW_B"+","+"TW_B"+","+"THICK"+","+"THICK"+","+"PARA"+","+"PARA"+","+"LEW"+","+"LEW"+","+"REW"+","+"REW"
                FILE/WRITELINE,FPTR,TW[1].MEAS+","+TW[2].MEAS+","+","+","+","+","+THK[1].MEAS+","+THK[2].MEAS+","+PAR[1].MEAS+","+PAR[2].MEAS+","+LEW[1].MEAS+","+LEW[2].MEAS+","+REW[1].MEAS+","+REW[2].MEAS
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,"LF"+","+"LF"+","+"PF"+","+"PF"+","+"PF A"+","+"PF A"+","+"PF B"+","+"PF B"+","+"PF BL"+","+"FP BL"+","+"PF BL"+","+"PF BR"+","+"PF BR"
                FILE/WRITELINE,FPTR,LF[1].MEAS+","+LF[2].MEAS+","+PF[1].MEAS+","+PF[2].MEAS
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,""
                FILE/WRITELINE,FPTR,"LIN CAM"+","+"LIN CAM"+","+"PLT CAM"+","+"PLT CAM"+","+"RAD DIR"+","+"RAD DIR"+","+"RAD THK"+","+"RAD THK"
                FILE/WRITELINE,FPTR,L_CAM[1].Z.MEAS+","+L_CAM[2].Z.MEAS+","+P_CAM[1].Z.MEAS+","+P_CAM[2].Z.MEAS+","+RD[1].Z.MEAS+","+RD[2].Z.MEAS+","+RT[1].Z.MEAS+","+RT[2].Z.MEAS
                IF/A_GRP.INPUT=="YES"
                  FILE/WRITELINE,FPTR,""
                  FILE/WRITELINE,FPTR,"A-Group Features"
                  FILE/WRITELINE,FPTR,""
                  FILE/WRITELINE,FPTR,"LW"+","+"LW"+","+"LH"+","+"LH"+","+"LT"+","+"LT"+","+"LS"+","+"LS"+","+"LP"+","+"LP"
                  FILE/WRITELINE,FPTR,LW[1].MEAS+","+LW[2].MEAS+","+LH[1].MEAS+","+LH[2].MEAS+","+LT[1].MEAS+","+LT[2].MEAS
                END_IF/​
                FILE/CLOSE,FPTR,KEEP


    The characters within quotes appear as text in the output and the next line sends the measured value of the feature. This particular form allows for reporting of features not measured on this part and skips over the destination cells for those features.
  • Thanks Don, I have never used .csv files and not even sure what they accompany. Do you know if it is possible to just simply put a script in the excel form cell I created, and that could change the font color. I would really just like to the form on the left and have the text turn red when it is out of the tolerance band.
Reply Children
No Data