Beams Document 2790-v1

DocDB Home ]  [ Search ] [ Last 20 Days ] [ List Authors ] [ List Topics ] [ List Events ]

Excel Run Coordinator Coolider Plots using SuperTableIV

Document #:
Document type:
Submitted by:
Brian E. Drendel
Updated by:
Brian E. Drendel
Document Created:
24 May 2007, 13:59
Contents Revised:
24 May 2007, 13:59
Metadata Revised:
24 May 2007, 13:59
Viewable by:
  • Public document
Modifiable by:

Quick Links:
Latest Version

Other Versions:
09 Oct 2007, 14:08
05 Jul 2007, 14:51
11 Jun 2007, 12:31
The SuperTableIV-ShotAnalysis.xls Excel spreadsheet uses the web query feature to update the spreadsheet calculations and plots automatically based on the most recent version of the SuperTableIV on the SDA website. We never have to get the latest version of SuperTableIV, as the spreadsheet does it for us.

The resulting plots and data are used by the Run Coordinator team in our daily planning meeting. This spreadsheet is functionality similar to Ron Moore’s , with different content and additional web publishing functionality.

The first three tabs of the spreadsheet mirror the full SuperTableIV, the “Top 10” initial luminosity version of SuperTableIV and the “Top 10” delivered luminosity version of SuperTableIV. In Excel 2003, opening the spreadsheet automatically updates all of this data, but in Excel 2007 we have to do a right-click -> refresh in order to update the data.

The next three tabs complete simple calculations based on the SuperTableIV data from the first three tabs. This includes all of the data that the Run Coordinator team typically uses to label our Friday weekly summary plot. These tabs also have a “stash override” column that allow us to substitute a different stash size on our plots, since our lack of RR DCCT results in stash sizes that are not correct.

There is also a tab called “PlotInputs” that provide a number of items used to build the plots, including number of stores to include in the plots, plot labels, and resonance lines for the Tevatron tune plot.

Most of the remaining tabs contain the summary plots. The spreadsheet is configured to automatically save a webpage copy of each of the plots on the Run Coordinator website (, assuming that the user has privileges to write there. In addition, a batch script (Brians-Shot-Analysis-Archive-Script.bat) copies each of the plots generated on the web and makes a copy in an archive folder with the date attached to the file name for convenient sorting. The archive for each plot is also published on the Run Coordinator website.

DocDB Home ]  [ Search ] [ Last 20 Days ] [ List Authors ] [ List Topics ] [ List Events ]

DocDB Version 8.8.10, contact Beams Document Database Administrators