[Pansophy] AUP and HE NCR data (New Report for QC NCR Lists)

[Jacob Harris]

Followup. The table displays the SN as a text string, but when copyinjg into excel it always changes to a number value and strips the leading zeros. I tried 'paste special' and it always stripped the leading zeros.

From: Jacob Harris
Sent: Tuesday, December 7, 2021 3:30 PM
To: pansophy at jlab.org
Cc: E. Anne McEwen <mcewen at JLAB.ORG>
Subject: RE: AUP and HE NCR data (New Report for QC NCR Lists)

Thanks Valerie,

Can you change the SN to be a text field? Megan had to do the same thing, and I forgot to mention that. Currently it's a number field and strips off the leading zeros.

From: Valerie Bookwalter
Sent: Tuesday, December 7, 2021 2:21 PM
To: Jacob Harris <jharris at jlab.org<mailto:jharris at jlab.org>>
Cc: E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>; pansophy at jlab.org<mailto:pansophy at jlab.org>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>
Subject: RE: AUP and HE NCR data (New Report for QC NCR Lists)

Jacob,

Sorry for the delay. I have been trying to put this together between meetings.
I created a quick report for you so that you can get the data whenever you need it.
This will display in "table" format. Currently there is not an export to excel,
but this display will allow for you to copy and paste into excel for your status reports.

https://pansophy.jlab.org/pansophy/DataMine/Reports/QC_Project_NCRS.cfm

Hope this helps. Let me know if you need some modifications.


Valerie Bookwalter
Jefferson Lab, SRF Department
Pansophy Team
1-757-269-5802 (OFFICE - currently working offsite)




From: Pansophy <pansophy-bounces at mailman.jlab.org<mailto:pansophy-bounces at mailman.jlab.org>> On Behalf Of Jacob Harris
Sent: Tuesday, December 7, 2021 8:53 AM
To: pansophy at jlab.org<mailto:pansophy at jlab.org>
Cc: E. Anne McEwen <mcewen at jlab.org<mailto:mcewen at jlab.org>>
Subject: [Pansophy] AUP and HE NCR data

Hello Pansophy team,

Last month Meagan was able to generate the attached two reports for the HE and AUP projects. Can someone do the same and send me the files?

For future reference only... this is the report I would like to make available in the project space for HE, SNS, and AUP - even if it's just the excel export without any onscreen display of the data table.

_______________________________________________________________________________
Jacob Harris
SRF Operations Quality Engineer
Jefferson Lab
Newport News, VA 23606
Office: +1 (757) 269-7193
Cell: +1 (334) 345-3248
Email:   jharris at jlab.org<mailto:jharris at jlab.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20211208/04ae9494/attachment.html>