Q3 FY2009 Observatory Metrics

April 1, 2009 through June 30, 2009

Collected Data

Charts

  • Chart 1 Image:
    Q309-CH1.jpg

  • Chart 2 Image:
    Q309-CH2.jpg

  • Chart 3 Image:
    Q309-CH3.jpg

  • Chart 4A:
    Q309-4A.jpg

  • Chart 4A map:
    projects states all telescopes.png

  • Chart 4B:
    Q309-4B.jpg

  • Chart 4B map:
    projects countries all telescopes.png

  • Chart 4C:
    Q309-4C.jpg

  • Chart 4C map:
    projects countries foreign all telescopes.png

  • Chart 5:
    Q309-CH5.jpg

  • Chart 7:
    Q309-CH7.jpg

Observing Statistics "Registry"

Idea

We would like to keep track of what observing statistical data are available, who keeps track of / "owns" / maintains that data, what reports and charts we generate each quarter, and how to build those reports and charts from the available data. In other words, we would like to build a registry -- a system to track this process, help understand who's involved, allow staff to present the data they maintain, support continuity of reporting, promote a continuous improvement process, and allow everyone involved to note findings along the way.

Such a registry would contain at least 3 types of records:

Type Basic Description
data a record of available observing statistics data, who keeps track of it, and how to get it
report a record of a target report and/or chart which condenses or illustrates observing summaries
workflow a recipe for building reports from available data

We would also like to be able to add notes to records stored in the registry, as needed.

Status

At the moment, we have:

  • structured a few examples of observing statistics data, reports, and workflows
  • put those examples into a very simple demo search index for keeping track of our process to produce quarterly reports
  • published early results here (you are reading it)

Things are still in a demo/pilot phase. We'd all like to understand how to keep track of and improve the process of observing statistics. We are far from any type of deployment for such a system, but with everyone's help and input, we can better understand how to proceed. Ask Nicole and Ron for a demo, or see the examples below.

Example Content

To demonstrate the type of information we'd like to collect:

VLA Operations Statement (data)

  • owner: Peggy Perley
  • description: Spreadsheet containing project code (legacy ID), total observing time attempted, real outage hours, calculated hours observed, and dates. Summary table shows astronomy time, maintenance time, test time, shutdown time, and unscheduled time. Downtime summary table indicates causes of problems that led to outages.
  • frequency: monthly
  • input:
    • email to Nicole Radziwill
  • output:


Quarterly Telescope Utilization Charts (report)


Produce Quarterly Telescope Utilization Reports (workflow)

  • input:
    • VLA Operations Statement
    • VLBA Operations Statement
    • GBT Operations Statement
  • output:
    • Quarterly Telescope Utilization Charts
  • recipe:
    • Copy summary table information from the input data sources and plot as bar charts and pie charts.
    • scheduled = (actual astronomy) + downtime
    • scheduled VLA = (astronomy actual hours) / (1 - downtime% as decimal); example: downtime 8.85% is 0.0885.
    • actual VLA = astronomy actual hours
    • scheduled GBT = astronomical observations total hours column
    • actual GBT = (astronomical observations total hours) - (astronomical observations lost hours)
  • flow chart: Error: can't fetch image from 'http://example.com/path/to/flow/chart.jpg': 404 Not Found

Demonstrating the Idea

Screenshots to demonstrate the idea:

  • Example of how the registry might look.:
    registry-list-example.jpg


  • Example of showing a recipe for generating reports, linking to info on data and results.:
    registry-workflow-example.jpg


  • Example of tracking available observing statistics data in a registry.:
    registry-data-source-example.jpg

-- NicoleRadziwill - 2009-07-21
-- RonDuPlain - 2009-07-21

Topic attachments
I Attachment Action Size Date Who Comment
Chart1_Final.xlsxls Chart1_Final.xls manage 110 K 2009-07-21 - 14:30 UnknownUser Chart 1
Chart2_Final.xlsxls Chart2_Final.xls manage 470 K 2009-07-21 - 14:33 UnknownUser Chart 2
Chart3_Final.xlsxls Chart3_Final.xls manage 137 K 2009-07-21 - 14:33 UnknownUser Chart 3
Chart4_Countries.csvcsv Chart4_Countries.csv manage 1 K 2009-07-21 - 15:51 UnknownUser Chart 4 Countries
Chart4_States.csvcsv Chart4_States.csv manage 2 K 2009-07-21 - 15:52 UnknownUser Chart 4 States
ProposalsSubmitted09C_June.xlsxls ProposalsSubmitted09C_June.xls manage 40 K 2009-07-31 - 10:51 UnknownUser Chart 5 Data
Q309-4A.jpgjpg Q309-4A.jpg manage 106 K 2009-07-21 - 16:19 UnknownUser Chart 4A
Q309-4B.jpgjpg Q309-4B.jpg manage 87 K 2009-07-21 - 16:19 UnknownUser Chart 4B
Q309-4C.jpgjpg Q309-4C.jpg manage 94 K 2009-07-21 - 16:20 UnknownUser Chart 4C
Q309-CH1.jpgjpg Q309-CH1.jpg manage 425 K 2009-07-21 - 14:46 UnknownUser Chart 1 Image
Q309-CH2.jpgjpg Q309-CH2.jpg manage 333 K 2009-07-21 - 14:49 UnknownUser Chart 2 Image
Q309-CH3.jpgjpg Q309-CH3.jpg manage 355 K 2009-07-21 - 14:52 UnknownUser Chart 3 Image
Q309-CH5.jpgjpg Q309-CH5.jpg manage 163 K 2009-07-31 - 10:51 UnknownUser Chart 5
Q309-CH7.jpgjpg Q309-CH7.jpg manage 446 K 2009-07-31 - 14:19 UnknownUser Chart 7
Q309-CHA.jpgjpg Q309-CHA.jpg manage 425 K 2009-07-21 - 14:43 UnknownUser Chart 1 Image
Q3FY09-vlaarchive-stats.xlsxls Q3FY09-vlaarchive-stats.xls manage 37 K 2009-07-31 - 14:18 UnknownUser VLA/VLBA Archive Stats
WebStatsNraoEdu_Q3FY09.pdfpdf WebStatsNraoEdu_Q3FY09.pdf manage 109 K 2009-07-31 - 10:53 UnknownUser Web Stats for http://www.nrao.edu Q3FY09
WebStatsScienceNrao_Q3FY09.pdfpdf WebStatsScienceNrao_Q3FY09.pdf manage 100 K 2009-07-31 - 10:53 UnknownUser Web Stats for http://science.nrao.edu Q3FY09
projects_countries_all_telescopes.pngpng projects_countries_all_telescopes.png manage 13 K 2009-07-21 - 17:28 UnknownUser Chart 4B map
projects_countries_foreign_all_telescopes.pngpng projects_countries_foreign_all_telescopes.png manage 13 K 2009-07-21 - 17:29 UnknownUser Chart 4C map
projects_states_all_telescopes.pngpng projects_states_all_telescopes.png manage 9 K 2009-07-21 - 17:28 UnknownUser Chart 4A map
registry-data-source-example.jpgjpg registry-data-source-example.jpg manage 52 K 2009-07-21 - 18:20 UnknownUser Example of tracking available observing statistics data in a registry.
registry-list-example.jpgjpg registry-list-example.jpg manage 27 K 2009-07-21 - 18:18 UnknownUser Example of how the registry might look.
registry-workflow-example.jpgjpg registry-workflow-example.jpg manage 58 K 2009-07-21 - 18:19 UnknownUser Example of showing a recipe for generating reports, linking to info on data and results.
Topic revision: r4 - 2009-07-31, NicoleRadziwill
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding NRAO Public Wiki? Send feedback