Daily Construction Record and Weekly Dashboard
This template is an Excel sheet with a pivot table utility report that retrieves data from data tables. By keeping a record of construction project data and information on data tables—and by using pivot tables—we can get back many forms and dashboards, such as a daily and weekly construction report. This zip file contains a sample record and a blank record.
- From the data tables pages, fill out the project data and various logs as it occurs.
- Go to the daily report page tab and select the fields of the inserted pivot tables that you want show in the daily report, and select the report date from the date field.
- Format the report and hide unnecessary cells and rows; prepare it for printing.
- Go to the weekly report page and select the fields of the inserted pivot tables that you want show in the weekly report; the pivot table will retrieve info from the data table without repeating and will summarize automatically.
- Prepare the format report for printing.
- Now we have all project data stored in data tables, which we can use and reprocess by inserting pivot tables and pivot charts to show information in reports.