hexagon logo

Anybody have Excel Spreadsheet for Pc-Dmis

Has anyone created or know of someone who has an Excel spreadsheet for multi inspection results that works with Cad++ version 2013? A lot of our customers require that we do final inspection reports on multi parts. If the order was for 120pcs we would need to inspect 20pcs out of the lot. I didnt know if there was a spreadsheet that would capture theses results and consolidate them onto one final inspection report instead of Pc-Dmis report and having to print out 20 to 30 pages.
Parents
  • This is a bit delayed response, but we use file/writeline commands to output data into a CSV format.
    "C_PATH" as well as a handful of other data points below are assigned earlier in the program
    <code>
    FILE =FILE/OPEN,C_PATH,APPEND
    FILE/WRITELINE,C_FILE,"/PART NUMBER/" + "," + PART
    FILE/WRITELINE,C_FILE,"/ROUTINE NAME/" + "," + ROUTINE
    FILE/WRITELINE,C_FILE,"/LOT#/" + "," + RUN_ID
    FILE/WRITELINE,C_FILE,"/OPERATOR/" + "," + TRACE_FOLDER + "," + "Operator" + "," + OPERATOR
    FILE/WRITELINE,C_FILE,"/SCHEDULED TIME/" + "," + TRACE_FOLDER + "," + "Scheduled Time" + "," + TIME
    FILE/WRITELINE,C_FILE,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position 1" + "," + POS_1
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_1 + "1" + "," + AA_1.D.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_2 + "1" + "," + AC1_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_3 + "1" + "," + AC2_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_4 + "1" + "," + AC3_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_5 + "1" + "," + AD_1.D.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_6 + "1" + "," + AE_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_7 + "1" + "," + AF_1.M.MEAS
    </code>
Reply
  • This is a bit delayed response, but we use file/writeline commands to output data into a CSV format.
    "C_PATH" as well as a handful of other data points below are assigned earlier in the program
    <code>
    FILE =FILE/OPEN,C_PATH,APPEND
    FILE/WRITELINE,C_FILE,"/PART NUMBER/" + "," + PART
    FILE/WRITELINE,C_FILE,"/ROUTINE NAME/" + "," + ROUTINE
    FILE/WRITELINE,C_FILE,"/LOT#/" + "," + RUN_ID
    FILE/WRITELINE,C_FILE,"/OPERATOR/" + "," + TRACE_FOLDER + "," + "Operator" + "," + OPERATOR
    FILE/WRITELINE,C_FILE,"/SCHEDULED TIME/" + "," + TRACE_FOLDER + "," + "Scheduled Time" + "," + TIME
    FILE/WRITELINE,C_FILE,"/CAVITY ID/" + "," + TRACE_FOLDER + "," + "Position 1" + "," + POS_1
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_1 + "1" + "," + AA_1.D.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_2 + "1" + "," + AC1_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_3 + "1" + "," + AC2_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_4 + "1" + "," + AC3_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_5 + "1" + "," + AD_1.D.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_6 + "1" + "," + AE_1.M.MEAS
    FILE/WRITELINE,C_FILE,"/DATA/" + "," + CHAR_7 + "1" + "," + AF_1.M.MEAS
    </code>
Children
No Data