Beams Document 2790-v4
- Document #:
- Document type:
- Submitted by:
- Brian E. Drendel
- Updated by:
- Brian E. Drendel
- Document Created:
- 24 May 2007, 13:59
- Contents Revised:
- 23 Jul 2007, 15:11
- Metadata Revised:
- 09 Oct 2007, 14:08
- 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 Moores http://www-bdnew.fnal.gov/tevatron/TevStoreSummary_ST4.xls , 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 (http://www-runco.fnal.gov), 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 Version 8.8.10, contact
Beams Document Database Administrators