hexagon logo

SPC results sent to PC-DMIS report

So as a new project, the management wants me to implement SPC collection that would be real time and not require any further operator interaction than they already have. This means that they want the SPC data (read X bar R chart; or process chart in DATAPAGE) to be sent to the report after each "in process" run of a part. They only want 1 feature to begin with but that seems daunting enough. Anyone have any ideas?
  • Bump

    I thought there were "GREAT PLANS A-FOOT" to have that part and parcel within Pcdmis for the 4.x or 2009+ releases. Don't tell me that they once again reneged on a "promise".
  • PDC2EXCEL and then output to Minitab?
    Not exactly what your management want cause it isn't a command driven operation, but it's what we do.
  • I thought there were "GREAT PLANS A-FOOT" to have that part and parcel within Pcdmis for the 4.x or 2009+ releases. Don't tell me that they once again reneged on a "promise".

    To what are you referring to?
    PDC2EXCEL and then output to Minitab?
    Not exactly what your management want cause it isn't a command driven operation, but it's what we do.

    No operator involvement.
  • To what are you referring to?

    No operator involvement.

    There was talk about making Datapage part of the internal workings of Pcdmis, at least to a limited extent. Something along the lines of running the program in a loop 30 times and getting the Pp/Cp & Ppk/Cpk to show at the end of the report. I don't remember exactly what all they talked about incorporating into Pcdmis, but there was talk about it, and from "official" sources as well.

    Is there a way to CODE it so that it places the data into an array, then simply do the calculations within Pcdmis itself? It would have to be an external data file of some kind that gets added to, not replaced, then import the entire data file into the array, then do the calcualtions. Can't tell you how to get charts, but the numbers can be calculated, the formulas are all available.
  • On our AVAIL/DATAPAGE machines we utilize "Hotkey Macros", this was an option in Unix Datapage. All operator has to do is hit Ctrl K and out spits the charts. I don't know if it can be done in Pc Dmis or not, may be something to look at and only takes a split second of operator time. It would be nice if they put this feature back into Datapage.
  • James, do they want a process chart in every PC-DMIS report, or do they want real time stats?

    For real time stats (nearly) use Datapage and Monitor mode, and setup the monitor right on the managers desk so he can click at any time and get the current chart.

    If he wants something where he doesn't even have to click once, QC-Calc integrates with PC-DMIS and will show live charts on screen.

    If they actually want that chart in the report every time (seems like a waste to me), I'd setup a macro in Datapage to create the chart and print it (easy) and then make sure it prints to PDF append to the report. This takes a little organization to setup. There is some integration that is going to happen with PC-DMIS and Datapage over time, but I don't know if I like it, because I want my stats separate from my part runs.
  • James, do they want a process chart in every PC-DMIS report, or do they want real time stats?

    For real time stats (nearly) use Datapage and Monitor mode, and setup the monitor right on the managers desk so he can click at any time and get the current chart.

    If he wants something where he doesn't even have to click once, QC-Calc integrates with PC-DMIS and will show live charts on screen.

    If they actually want that chart in the report every time (seems like a waste to me), I'd setup a macro in Datapage to create the chart and print it (easy) and then make sure it prints to PDF append to the report. This takes a little organization to setup. There is some integration that is going to happen with PC-DMIS and Datapage over time, but I don't know if I like it, because I want my stats separate from my part runs.

    SEE? I told you there was "talk" about adding at least some Datapage into Pcdmis! HA! So there! Naaaa! Stuck out tongue closed eyes
  • This post is resolved.

    The answer to the question of how to get an XBarR chart to be produced automagically in PC-DMIS is actually rather simple once shown how to do it.

    Within DATAPAGE you create a macro of your key strokes and then do an external command...


    EXTERNALCOMMAND/NO_DISPLAY, NO_WAIT ; C:\DataPage 3.33\datapage.exe Z:\JIMI_TEST.MAC


    Thanks to Doug Sjogren!!!
  • whats DataPage.............. Confused


    Are you serious??
  • Are you serious??


    no.......... Smiley

    my former bosshole was too cheap to get it, said we already had Minitab.

    easy to say when it isn't you having to export Demon data, KWIM? Neutral face



  • EXTERNALCOMMAND/NO_DISPLAY, NO_WAIT ; C:\DataPage 3.33\datapage.exe Z:\JIMI_TEST.MAC




    James, the "JIMI_TEST.MAC", is that the datapage file where the data is being sent? This is something we are looking at doing as well.
  • also Infinity qs also has a pc-dmis conveter straight to your data base which will spit out spc reports and even do gage R&R's if you would like very good software
  • James, the "JIMI_TEST.MAC", is that the datapage file where the data is being sent? This is something we are looking at doing as well.


    If I read it correctly that is the macro file name.