[Pansophy] FW: VTRF traveler issue

Fri Sep 6 10:59:12 EDT 2019

From: Christiana Wilson <grenoble at jlab.org>
Sent: Friday, September 6, 2019 10:55 AM
To: Valerie Bookwalter <bookwalt at jlab.org>
Subject: Re: VTRF traveler issue

Yes. I saw the message too. I saved the macro enabled spreadsheet as an xlsx file. Not sure why we get the message.
________________________________
From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Friday, September 6, 2019 10:51 AM
To: Christiana Wilson <grenoble at jlab.org<mailto:grenoble at jlab.org>>
Subject: RE: VTRF traveler issue

Christiana,

When I click on the link, the excel file opens and gives me a warning

[cid:image001.png at 01D564A0.F88469B0]

When I click ok (twice) then the file opens with data. Are you seeing this error?

Valerie

From: Christiana Wilson <grenoble at jlab.org<mailto:grenoble at jlab.org>>
Sent: Friday, September 6, 2019 9:52 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Subject: Re: VTRF traveler issue

Hi Again,

I deleted the empty spreadsheet and tried to upload the attached file to L2PRD-CAV-VTRF sequence number 317. I clicked on the link in the traveler and an empty spreadsheet opened. Not sure what is going on?

Christiana

________________________________

From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Wednesday, September 4, 2019 4:32 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>>; Tony Reilly <areilly at jlab.org<mailto:areilly at jlab.org>>
Subject: RE: 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/20190906/cbc0b069/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 7520 bytes
Desc: image001.png
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20190906/cbc0b069/attachment-0001.png>