[Pansophy] Data format example from Vector

[Valerie Bookwalter]

Just chatted with John and I think Megan has some "marching orders" to start with.
So we are good to go.
Will keep you posted on progress.
Thanks!

Valerie

From: Katherine Wilson <kwilson at jlab.org>
Sent: Thursday, July 1, 2021 3:48 PM
To: Valerie Bookwalter <bookwalt at jlab.org>; pansophy <pansophy at jlab.org>
Cc: Tiffany Ganey <ganey at jlab.org>; John Vennekate <hannesv at jlab.org>
Subject: Re: Data format example from Vector

Why don't we go ahead and introduce them to the Projects area when you're ready, and then set up a meeting to talk through what they really want after they understand how the process will work.

Thanks,
Katherine


________________________________
From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Thursday, July 1, 2021 3:27 PM
To: Katherine Wilson <kwilson at jlab.org<mailto:kwilson at jlab.org>>; pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Cc: Tiffany Ganey <ganey at jlab.org<mailto:ganey at jlab.org>>; John Vennekate <hannesv at jlab.org<mailto:hannesv at jlab.org>>
Subject: RE: Data format example from Vector


That just looks like a dump of the data from their traveler (like our vargrid).

I don't see how that is helpful to SLAC.

It looks like Jamie said 'here is all the data, you figure it out'.

But that's just my opinion.

We can do that, but does SLAC have specific performance indicators they want to be sure to have?



Valerie



From: Pansophy <pansophy-bounces at mailman.jlab.org<mailto:pansophy-bounces at mailman.jlab.org>> On Behalf Of Katherine Wilson
Sent: Thursday, July 1, 2021 3:09 PM
To: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Cc: Tiffany Ganey <ganey at jlab.org<mailto:ganey at jlab.org>>; John Vennekate <hannesv at jlab.org<mailto:hannesv at jlab.org>>
Subject: [Pansophy] Fw: Data format example from Vector



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<mailto:jamesm at slac.stanford.edu>>
Sent: Tuesday, June 29, 2021 11:25 AM
To: Katherine Wilson <kwilson at jlab.org<mailto:kwilson at jlab.org>>; John Vennekate <hannesv at jlab.org<mailto:hannesv at jlab.org>>
Cc: Gonnella, Dan A <gonnella at slac.stanford.edu<mailto: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/99fe138d/attachment.html>