[Pansophy] AUPCAV Leak Test Report

[Naeem Huque]

Hi Valerie,

CERN would like a report similar to the one attached for our leak test results (a lot of it isn't applicable). The report is proprietary so please don't share it.

You mentioned that we have extracted data into a spreadsheet in the past, and that may be a good way to do this. Can entries from travelers be input directly into specific cells in the spreadsheet? I recall that travelers couldn't do math/calculations on entries; is this still the case? I have a following suggestions on how to go about this, and am open to other ones (or combinations of those below).


  1.
Create a report template spreadsheet with cells connected by formulas. Include an export button on the traveler which would put values entered into the traveler into particular cells in the report spreadsheet (names, times, values etc.). Excel would do the math to create the final report to submit to CERN
  2.
Format the traveler with all the information required in the report and have it do the calculations to get the final values (leak rate etc.). The traveler could then be exported as a PDF (or any other format) and submitted to CERN
  3.
Create a spreadsheet report and manually transfer the data to create the report.

Option 3 is the least desirable, but it may be what we have to do at the start until something automated is available. Regarding options 1 and 3, would someone at pansophy be able to create a report template similar to what is attached?

Thanks,
Naeem

Naeem Huque
Staff Engineer
Superconducting Radiofrequency (SRF)
Jefferson Lab
12000 Jefferson Ave
Newport News
VA, 23606
Cell: 217-721-5422
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20240409/0fb49a8e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 332612212100_BBF008_H001(2).xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 61954 bytes
Desc: 332612212100_BBF008_H001(2).xlsx
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20240409/0fb49a8e/attachment-0001.xlsx>