<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Pansophy team,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
We asked SLAC what kind of data format would be easiest for them. Please see attached. If this is a lot of work on your end, we can do something different. What do you think?</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks,<br>
Katherine</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Maniscalco, James <jamesm@slac.stanford.edu><br>
<b>Sent:</b> Tuesday, June 29, 2021 11:25 AM<br>
<b>To:</b> Katherine Wilson <kwilson@jlab.org>; John Vennekate <hannesv@jlab.org><br>
<b>Cc:</b> Gonnella, Dan A <gonnella@slac.stanford.edu><br>
<b>Subject:</b> [EXTERNAL] Data format example from Vector</font>
<div> </div>
</div>
<div lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Hi Katherine & John,</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Here is an example of the traveler data for the vertical test as I get it from Vector at FNAL. It comes out as a CSV file with one row for each traveler and one column for each field. My current workflow to get this is once a week I go to the following link
(requires logging into FNAL VPN) to check for any new cavities tested:</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__vector-2Donsite.fnal.gov_Tools_Reports_Include_DataSubmit.asp-3FqsCrosRefDataIDList-3D149442-2C149454-2C149491-2C149501-2C149513-2C149525-2C149537-2C149549-2C149550-2C149562-2C149511-2C149523-2C149535-2C149547-2C149560-2C149445-2C149457-2C149469-2C149494-2C149504-2C149516-2C149541-2C149553-2C149436-2C149461-2C149473-2C149485-2C149497-2C149507-2C149519-2C149544-2C149556-2C149437-2C149449-2C149450-2C149498-2C149508-2C149521-2C149533-2C149545-2C149557-2C149438-2C149451-2C149475-2C149487-2C149499-2C149509-2C149522-2C149558-2C149441-2C149453-2C149465-2C149500-2C149524-2C149561-2C149443-2C149455-2C149467-2C149492-2C149502-2C149514-2C149526-2C149551-2C149444-2C149456-2C149481-2C149493-2C149515-2C149539-2C149540-2C149447-2C149459-2C149460-2C149496-2C149506-2C149518-2C149531-2C149555-2C149458-2C149471-2C149483-2C149495-2C149505-2C149517-2C149529-2C149530-2C149542-2C149554&d=DwMFAg&c=CJqEzB1piLOyyvZjb8YUQw&r=2ExwasrV2SKRqrOjicWxog&m=kL-3w26V7QdX5B18JytHDnsWWnq2ZitYuAJlpjSMTaI&s=jKmk8lP8imK9tdF6XIvc0TLPmaysKvtd34V025Nv07Q&e=">FNAL
VTRF Traveler Report</a></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
At the bottom there is an Export to XLS link which generates an excel file of the data. Note that there is some glitch with the file format header (you might see an error message), but Excel and Matlab can still read it.</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
To get the RF data I typically follow the link given in the file to download. If it’s easier to email the RF data directly that’s OK too.</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Thank you,</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
James</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
---------------------------------------------------------------</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
James Maniscalco</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
SRF Engineer</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
LCLS-II HE Project</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
SLAC National Accelerator Laboratory</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Bldg. 52, Rm. 248-B</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Office: (650) 926-2157</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
Cell: (973) 518-0393</p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif;">
</p>
</div>
</div>
</div>
</body>
</html>