<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: SPC scripting - Why writing information back into a database is important in JMP Scripters Club Discussions</title>
    <link>https://community.jmp.com/t5/JMP-Scripters-Club-Discussions/SPC-scripting-Why-writing-information-back-into-a-database-is/m-p/580082#M81</link>
    <description>&lt;P&gt;Great demo Mauro, thanks for sharing the script !&lt;/P&gt;</description>
    <pubDate>Mon, 12 Dec 2022 08:31:00 GMT</pubDate>
    <dc:creator>Emmanuel_Romeu</dc:creator>
    <dc:date>2022-12-12T08:31:00Z</dc:date>
    <item>
      <title>SPC scripting - Why writing information back into a database is important</title>
      <link>https://community.jmp.com/t5/JMP-Scripters-Club-Discussions/SPC-scripting-Why-writing-information-back-into-a-database-is/m-p/579353#M79</link>
      <description>&lt;P&gt;&lt;STRONG&gt;Problem description -&amp;nbsp;&lt;/STRONG&gt;Process is unstable:&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Influence of time or unknown variable&lt;/LI&gt;
&lt;LI&gt;Process moves slowly towards out of spec&lt;/LI&gt;
&lt;LI&gt;An incident shift the process&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;STRONG&gt;Overview SPC:&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;SPC is like telling a dog to “stay”. Wherever the process is, it should remain in that place.&lt;/LI&gt;
&lt;LI&gt;A stable phase should be defined and notify the operator when the process is out of control limits before it’s out of spec.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;STRONG&gt;Problems with SPC:&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Process screening platform gives a lot of false positives and is therefore not always useable for prioritizing improvements&lt;/LI&gt;
&lt;LI&gt;Default SPC control limits on our data are often too strict:&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mauro_Gerber_0-1670596708136.png" style="width: 400px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/48085i73ED78282FAA15D2/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mauro_Gerber_0-1670596708136.png" alt="Mauro_Gerber_0-1670596708136.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;When new data are analyzed, the control limits shifts automatically.&lt;/LI&gt;
&lt;LI&gt;A change in the process can be overlooked.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mauro_Gerber_1-1670596754575.png" style="width: 400px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/48086i6664436CCDE85FAF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mauro_Gerber_1-1670596754575.png" alt="Mauro_Gerber_1-1670596754575.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;The solution should:&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;Generate, store and update individual control limits.&lt;/LI&gt;
&lt;LI&gt;Help in setting limits for multiple variables.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Mauro_Gerber_2-1670596879130.png" style="width: 400px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/48087iFFDDDECD5F2929A1/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Mauro_Gerber_2-1670596879130.png" alt="Mauro_Gerber_2-1670596879130.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;SPC scripts&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;The Script generates a table with each variable that contains spec limits.&lt;/LI&gt;
&lt;LI&gt;It tries to load existing control limits into the table from the DB&lt;/LI&gt;
&lt;LI&gt;It adds scripts to store and set the limits.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Slides and Demo are available on the attachment.&lt;/P&gt;</description>
      <pubDate>Fri, 09 Dec 2022 14:59:11 GMT</pubDate>
      <guid>https://community.jmp.com/t5/JMP-Scripters-Club-Discussions/SPC-scripting-Why-writing-information-back-into-a-database-is/m-p/579353#M79</guid>
      <dc:creator>Mauro_Gerber</dc:creator>
      <dc:date>2022-12-09T14:59:11Z</dc:date>
    </item>
    <item>
      <title>Re: SPC scripting - Why writing information back into a database is important</title>
      <link>https://community.jmp.com/t5/JMP-Scripters-Club-Discussions/SPC-scripting-Why-writing-information-back-into-a-database-is/m-p/580082#M81</link>
      <description>&lt;P&gt;Great demo Mauro, thanks for sharing the script !&lt;/P&gt;</description>
      <pubDate>Mon, 12 Dec 2022 08:31:00 GMT</pubDate>
      <guid>https://community.jmp.com/t5/JMP-Scripters-Club-Discussions/SPC-scripting-Why-writing-information-back-into-a-database-is/m-p/580082#M81</guid>
      <dc:creator>Emmanuel_Romeu</dc:creator>
      <dc:date>2022-12-12T08:31:00Z</dc:date>
    </item>
  </channel>
</rss>

