[Pansophy] Fw: Data format example from Vector

[Katherine Wilson]

Hi Pansophy team,

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?

Thanks,
Katherine


________________________________
From: Maniscalco, James <jamesm at slac.stanford.edu>
Sent: Tuesday, June 29, 2021 11:25 AM
To: Katherine Wilson <kwilson at jlab.org>; John Vennekate <hannesv at jlab.org>
Cc: Gonnella, Dan A <gonnella at slac.stanford.edu>
Subject: [EXTERNAL] Data format example from Vector


Hi Katherine & John,



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:



FNAL VTRF Traveler Report<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=>



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.



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.



Thank you,

James



---------------------------------------------------------------

James Maniscalco

SRF Engineer

LCLS-II HE Project

SLAC National Accelerator Laboratory

Bldg. 52, Rm. 248-B

Office: (650) 926-2157

Cell: (973) 518-0393


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210701/38e2ad2f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: VectorReport(3).xls
Type: application/vnd.ms-excel
Size: 491196 bytes
Desc: VectorReport(3).xls
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20210701/38e2ad2f/attachment-0001.xls>