[Pansophy] VTRF traveler issue

[Liang Zhao]

Hi Valerie,

I don't think the older version of spreadsheets are giving wrong results, so it is probably not urgent to spend a lot of time on correcting them. As long as the blank files are captured (the file you attached did a good job on that), and now the link in the traveler is fixed, we are in good shape.

Thanks for your help,
Liang

________________________________
From: Valerie Bookwalter <bookwalt at jlab.org>
Sent: Thursday, September 5, 2019 9:24 AM
To: Liang Zhao <lzhao at jlab.org>; pansophy <pansophy at jlab.org>
Cc: Peter Owen <powen at jlab.org>; Christiana Wilson <grenoble at jlab.org>; Kirk Davis <kdavis at jlab.org>; Tom Powers <powers at jlab.org>; Tony Reilly <areilly at jlab.org>
Subject: RE: VTRF traveler issue


I have re-opened the L2PRD-CAV-VTRF travelers from sequence number 298 on. You can now upload your data.



Valerie Bookwalter



From: Pansophy <pansophy-bounces at jlab.org> On Behalf Of Valerie Bookwalter
Sent: Wednesday, September 4, 2019 4:32 PM
To: Liang Zhao <lzhao at jlab.org>; pansophy <pansophy at jlab.org>
Cc: Peter Owen <powen at jlab.org>; Christiana Wilson <grenoble at jlab.org>; Kirk Davis <kdavis at jlab.org>; Tom Powers <powers at jlab.org>; Tony Reilly <areilly at jlab.org>
Subject: Re: [Pansophy] VTRF traveler issue



Hello,



I am working on finding 0-size spreadsheets and collecting data to be reprocessed in the updated spreadsheet template.

I have create a directory where I have saved the data from the L2PRD area and started processing the data. Unfortunately I don’t know the start/stop rows and other parameters to complete processing. The data and *xlsm files can be found in the directory:



M:\asd\asddata\VTRF_PansophyData



You can either reprocess your data and upload new spreadsheet, or send us the parameters and we can reprocess and upload files. Some travelers have been closed and will need to be reopened to upload information.



In the directory I have included a file MissingVTRFdata.xlsx. This has the know list of L2PRD R4 files.

And some files included from Christiana. Please help me to complete the list and reprocess this data.

I am very sorry for this problem and I am working to correct as soon as possible.



Thank You.



Valerie Bookwalter



From: Pansophy <pansophy-bounces at jlab.org<mailto:pansophy-bounces at jlab.org>> On Behalf Of Valerie Bookwalter
Sent: Wednesday, September 4, 2019 3:09 PM
To: Liang Zhao <lzhao at jlab.org<mailto:lzhao at jlab.org>>; pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Cc: Kirk Davis <kdavis at jlab.org<mailto:kdavis at jlab.org>>; Christiana Wilson <grenoble at jlab.org<mailto:grenoble at jlab.org>>; Peter Owen <powen at jlab.org<mailto:powen at jlab.org>>; Tom Powers <powers at jlab.org<mailto:powers at jlab.org>>
Subject: Re: [Pansophy] VTRF traveler issue



Thank You!



I have updated the link to the VTRF Spreadsheet in L2PRD-CAV-VTRF-R4 to be the same as it was in R3.

I have also added the link to the Testing Procedure (Thank You Liang!).



I apologize for this mistake.

I will look for possible files that may have been made with the old spreadsheet and let you know what I find.

Please let me know if there are data sets that need to be re-processed with the updated Template.



Valerie Bookwalter



From: Pansophy <pansophy-bounces at jlab.org<mailto:pansophy-bounces at jlab.org>> On Behalf Of Liang Zhao
Sent: Wednesday, September 4, 2019 2:25 PM
To: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Cc: Peter Owen <powen at jlab.org<mailto:powen at jlab.org>>; Christiana Wilson <grenoble at jlab.org<mailto:grenoble at jlab.org>>; Kirk Davis <kdavis at jlab.org<mailto:kdavis at jlab.org>>; Tom Powers <powers at jlab.org<mailto:powers at jlab.org>>
Subject: [Pansophy] VTRF traveler issue



Hi Pansophy Team,



There is some issue with the "Excel spreadsheet template for VTA RF measurements" (page 0) in the traveler "L2PRD-CAV-VTRF  Rev: R4 (LCLSII (Production Cryomodule) Vertical cavity Testing, currently in use)". Looks like when the travler was updated last time, the link rolled back to an earlier version of the spreadsheet.



Critical issues about the spreadsheet:

1) It is not the latest version, to my knowledge the latest version should be "27Sept2018" version. It generates incomplete file name and the horizontal error bars in the Q0-Eacc plot are wrong, but these could be manually adjusted with more time.

2) The "Copy Workbook without Macros" function does not work properly, depending on which version of the spreadsheet, it may generate a blank file with/without an error message. The tester either need to save the file with Macro in it or somehow find a version that has this function working properly.



I have the latest spreadsheet saved on my desktop to use, but not all people using the traveler know these issues.



In addition, the link to "LCLSII VTA RF Testing Procedure" is missing. Here is the link to the latest version:

https://jlabdoc.jlab.org/docushare/dsweb/Get/Document-188884/CP-L2PRD-CAV-VTRF_R2.docx



Thanks,

Liang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20190905/497ebb6d/attachment-0001.html>