<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle21
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1699577811;
mso-list-template-ids:495384822;}
@list l1
{mso-list-id:2064677463;
mso-list-type:hybrid;
mso-list-template-ids:333496344 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Naeem,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you for the information and the suggestions.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l1 level1 lfo2">Yes, to creating a report for CERN. I have already spoken with Megan; she is most familiar with writing to/from excel.<o:p></o:p></li></ol>
<p class="MsoNormal"><o:p> </o:p></p>
<ol style="margin-top:0in" start="2" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l1 level1 lfo2">Additionally, she is the lead for the “PROJECTS” area of Pansophy and can help with generating reports/status boards/etc. I also understand that Jamie Blowers has requested access,
so he would be granted access to the AUPCAV Projects area.<o:p></o:p></li></ol>
<p class="MsoListParagraph"><o:p> </o:p></p>
<ol style="margin-top:0in" start="3" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l1 level1 lfo2">Travelers can do calculations. In the traveler put a [[describe calculations here ]]<<NOTE>>. If we can’t do a calculation in the traveler, then we can generate an excel spreadsheet
with Macros that could do the calculations.<o:p></o:p></li></ol>
<p class="MsoListParagraph"><o:p> </o:p></p>
<ol style="margin-top:0in" start="4" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l1 level1 lfo2">We can provide a mechanism to export the traveler data to the generated report (and have that available in the projects area, if desired).<o:p></o:p></li></ol>
<p class="MsoListParagraph"><o:p> </o:p></p>
<p class="MsoNormal">It would be helpful to us if we know what is “required” in each report as travelers are generated. This way we can ensure all data is being collected in the traveler and get a list of the variable names to ensure a smooth export.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If you have any questions or additional suggestions, please feel free to reach out to us again.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">At some point I would like to “brainstorm” with you about possible future improvements to our “project” / “management” / “overview” reports and status boards. The team has been working on ideas and have taken into account information we
gathered in our initial Data Mining Meetings. Also, include fabrication type projects in that brainstorming session.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank You for your help!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;mso-ligatures:standardcontextual">Valerie Bookwalter<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Jefferson Lab, Accelerator Dept. SRFOPS<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">Software Systems Group<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual"><a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:standardcontextual">757-269-5802<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Naeem Huque <huque@jlab.org> <br>
<b>Sent:</b> Tuesday, April 9, 2024 12:37 PM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Cc:</b> pansophy <pansophy@jlab.org>; Tony Reilly <areilly@jlab.org>; Alex Castilla Loeza <acastill@jlab.org>; Subashini De Silva <sdesilva@jlab.org>; Kirk Davis <kdavis@jlab.org>; Danny Forehand <forehand@jlab.org><br>
<b>Subject:</b> AUPCAV Leak Test Report<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black">Hi Valerie,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black">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. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black">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).<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<ol start="1" type="1">
<li class="MsoNormal" style="color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span style="font-size:12.0pt;font-family:"Aptos",sans-serif">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<o:p></o:p></span></li></ol>
</div>
<div>
<ol start="2" type="1">
<li class="MsoNormal" style="color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span style="font-size:12.0pt;font-family:"Aptos",sans-serif">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<o:p></o:p></span></li></ol>
</div>
<div>
<ol start="3" type="1">
<li class="MsoNormal" style="color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1">
<span style="font-size:12.0pt;font-family:"Aptos",sans-serif">Create a spreadsheet report and manually transfer the data to create the report.<o:p></o:p></span></li></ol>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black">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?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black">Thanks,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black">Naeem<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Aptos",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="Signature">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Naeem Huque<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Staff Engineer<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Superconducting Radiofrequency (SRF)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Jefferson Lab<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">12000 Jefferson Ave<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Newport News<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">VA, 23606<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Cell: 217-721-5422<o:p></o:p></span></p>
</div>
</div>
</div>
</body>
</html>