[Pansophy] SNS-2000 NCR Data

[Mike Dickey]

Anne,

Here is what I managed to get from the SNS(2000) travelers.  I deleted about 20 records as useless (null data in both fields).  There are only about 150 records with potentially useful information, many of the records have null data in the description or refer to the traveler for details.

I made a pivot table to get a count of NCRs per Traveler, which may be useful.  However, since SNS(2000) NCRs did not have any category data, and many of the descriptions are not helpful, trying to figure out problem counts will be difficult at best.

I also found only one record in the D3 table which I included.

Let me know if there are any other questions.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200117/46afe8c6/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SNS-2000 NCR Descriptions 17-Jan-2020.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 43791 bytes
Desc: SNS-2000 NCR Descriptions 17-Jan-2020.xlsx
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200117/46afe8c6/attachment-0001.xlsx>