The report macro when active will create or ask for a separate workbook containing worksheets that are named "Sunday" through "Saturday" and "January" through "December". Each worksheet will have a common set of column headers containing the names of report items and the corresponding engineering unit labels.
Summary formulas for Totals, Average, Minimum, and Maximum are included in the header for each column.
The Daily sheets will have data inserted at specified intervals from a worksheet file called "ReportsMac.xls". Likewise, the monthly sheets will have data inserted at the monthly interval specified.
A single data workbook can contain an entire years worth of monthly data plus the current week's daily data. The daily reports can be printed weekly or copied to a separate file on a weekly basis for permanent daily records.
The workbook file, DailyReportGr.XLS, can be loaded to automatically transfer daily worksheet data to a separate sheet and print the data at a specified time. It also allows the report data to be selected based on a specified "start time" each day. If a graph is placed on the data worksheet, it can also be printed each day.
Historical Database Reporter
The Historical Database Reporter software is an effective way to query time tagged field data for a specific station or point and then move the data into a powerful Microsoft Access database for analysis and reporting. This software is available in a DDE version or serial version to fit your specific needs. The DDE version allows the operator to poll a site on demand. The serial version must wait for the site to call the operator. The data is displayed in columns starting with date, time, station, point, value, and point type.
Top of page
© 2009, Nota Bene Technology,
19900 County Rd. 81, Maple Grove, MN 55311