[Pansophy] Mircea - post Allen's Tidbits presentation ... Serial Number issues

[Mircea Stirbet]

Thanks Val. Mircea

________________________________
From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Monday, August 30, 2021 12:42
To: Mircea Stirbet <stirbet at jlab.org>
Cc: pansophy <pansophy at jlab.org>; Kirk Davis <kdavis at jlab.org>; Danny Forehand <forehand at jlab.org>; E. Anne McEwen <mcewen at jlab.org>
Subject: RE: Mircea - post Allen's Tidbits presentation ... Serial Number issues


Mircea,



Unfortunately MS Excel doesn’t always play nice with data. Because the serial number had an ‘E’, excel assumed an exponential number. We currently don’t have the resources to update our grids and export functions, but we hope to soon. Hopefully by changing the format of the cells it will come back to a serial number.



As for the duplication of the FPCSN’s between string 1 & 2... That is a question for Kirk/Danny.



Thanks for your help and understanding.





Valerie Bookwalter

Jefferson Lab, SRF Department

Pansophy Team

1-757-813-6716 (CELL)

1-767-269-5802 (OFFICE – currently working offsite)







From: Mircea Stirbet
Sent: Friday, August 27, 2021 5:56 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; Megan McDonald <megan at jlab.org>; Allen Samuels <samuels at jlab.org>; Mike Dickey <mdickey at jlab.org>
Cc: Mircea Stirbet <stirbet at jlab.org>
Subject: Mircea - post Allen's Tidbits presentation ... Serial Number issues



Dear Val, Megan,  Allen and Mike



Had a some surprises while data mining some SNS PPU data:  there are two strings and, on cavity 2, on both of them, the same coupler is recorded. The travelers are closed... anyhow we can solve this issue: the strings are no more in the clean room, we can read directly the SN, open the affected traveler and make the correction. See this screen copy and pay attention to Cav2 (19E004) or Cav1 (19E003):

[cid:image001.png at 01D79D9C.7346FC90]

OK, now lets open this data as an Excel 2001 file and check the readings for Serial Numbers:

[cid:image002.png at 01D79D9C.7346FC90]



Seems to be exported in Scientific Format and.. quite difficult to recognize the initial Japanese serial number stamped for these parts. Just wander how this issue can be fixed. You can also practice doing data mining on SNSPPU-INV-FP (please, please simle !):

[cid:image003.png at 01D79D9C.7346FC90]



Take care and be safe,

Mircea

P.S.Have a great weekend.










-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210830/7105a222/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 39677 bytes
Desc: image001.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210830/7105a222/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5384 bytes
Desc: image002.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210830/7105a222/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 9552 bytes
Desc: image003.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210830/7105a222/attachment-0005.png>