<div dir="ltr"><div dir="ltr">Thanks Rick,<div><br>this looks like a great start, we really appreciate the help.</div><div><br></div><div>Ken</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 24 Jul 2020 at 01:52, Rick Walsh <<a href="mailto:marshallscreek@gmail.com">marshallscreek@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>I might be off, this was real quick.</div><div><br></div><div>::r=""; declare datacount ,datasum, meansqu, meancount, std:<br>::datacount="0":<br>:':'Generate the mean:<br>lcount::lookup set = set k=r i=A -ng:<br>:not set:goto donec:<br>::datacount=datacount+"1":<br>::datasum=datasum+set(1):<br>::getnext set; goto lcount:<br>donec:':'Subtract the mean from the values and square the result:<br>::mu=datasum/datacount:<br>::lookup muset = set k=r i=a -ng:<br>lmuset:not muset:goto donemu:<br>::meansqu=meansqu+sqrt(set(1)-mu):<br>::meancount=meancount+"1":<br>::getnext muset; goto lmuset:<br>donemu:':'Mean of the squared differences:<br>::mu=meansqu/meancount:<br>:':'result:<br>::std=sqrt(mu):<br>::msgbox std:<br>::end:</div><div><br></div><div><br></div></div><div id="gmail-m_700645213611007666DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid rgb(211,212,222)">
<tbody><tr>
<td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link" style="color:rgb(68,83,234)" target="_blank">www.avast.com</a>
</td>
</tr>
</tbody></table><a href="#m_700645213611007666_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 23, 2020 at 12:00 AM Ken Cole via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi everyone,<br>
<br>
I hope you are all doing well during covid.<br>
<br>
Not being someone who likes to reinvent the wheel, has anyone<br>
implemented a standard deviation function in filePro?<br>
<br>
We have to implement a very detailed algorithm to calculate reorder<br>
points for stock and the algorithm requires the use of the StdDev of<br>
certain data sets like lead time and usage over time.<br>
<br>
We run on RHEL servers so it may be an option to pass the data off to<br>
a user function written in say Perl to do this and get it to return<br>
the StdDev if we cannot do it within standard filePro.<br>
<br>
Perl is not foreign to us as we use it liberally and I see we can use<br>
a module Statistics::Basic::StdDev.<br>
<br>
Thanks<br>
<br>
Ken<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div>
</blockquote></div></div>