###### meta data for this page

# CHARTING DATA (CHARTS VISITS REPORT DETAILS)

AccuSQL/AccuTrack provides you with a powerful view of your center’s usage pattern via informative and colorful charts. AccuSQL/AccuTrack uses Microsoft *Excel* for creating 10 charts and 6 pivot tables that provide a wealth of information on how your center is used. This includes usage per hour, day, and week, usage per class, and the number of returns. To see these charts click on the “**Chart Visits**” button in the Reports screen. AccuSQL/AccuTrack will generate the needed data and start *Excel* automatically. It will then pass commands to *Excel* to create the pivot tables and graph the charts. When done, it will display an *Excel Workbook* with the charts and tables.

**Important:** Let the Chart Visits report finish completely in Excel before you close the Excel program, or AccuSQL/AccuTrack will display a warning message indicating it did not complete the report building process successfully.

**Note:**You will need MS Excel 97 or higher installed on your computer for the charting module to work.

**Note:**All the charts and tables reflect attendance data for the selected

*reporting period*.

**Note:**The charts show cumulative data. For example, if the reporting period is four weeks long and you select the

*Sign-ins by Day*chart, the chart will reflect the

*total*sign-ins for each day of the week for the four-week period.

**Tip:**You can view the different charts in Excel by simply clicking on the tabs at the bottom of the screen. To see all the tabs, click on the arrow buttons next to the tabs.

**Tip:**If you hold the mouse pointer on a segment of the chart for a few seconds, Excel will display the name and value of that segment:

**Tip:**Once in Excel, you can apply any Excel functions including saving the workbook, changing chart type, typing your center’s name or notes on the chart, and printing.

The following pages describe the available charts and data.

### WEEKLY SIGN-INS

This chart depicts the number of visits per week. On the vertical axis you will notice the week number. On the horizontal axis you will see the number of sign-ins. Each horizontal line represents one week, and is composed of several colored segments that represent the days of the week. You can see which days the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents and its numeric value.

**Tip:**If you run this chart over the past year or past semester, you will be able to quickly find out your busiest weeks of the year or semester.

### DAILY SIGN-INS

This chart depicts the number of visits by day of the week. The vertical axis shows the number of sign-ins, while the horizontal axis shows the day of the week. Each vertical bar represents one day of the week. If the selected reporting period is larger than one week, the visits will be added for each day. Thus the chart represents the *cumulative* number of visits for each day.

**Tip:**This chart is good for finding out your busiest day of the week.

### SIGN-INS BY DAY (DAILY SIGN-INS 2 TAB)

Like the previous chart, this chart also depicts the number of visits by day of the week. However, each vertical bar is composed of segments representing the hours of the day. You can see which hours the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents.
Note that this chart also represents the *cumulative* number of visits for each day and period of the day.

**Tip:**This chart is good for finding out your busiest day of the week and gives clues on the busiest time periods in each day.

### SIGN-INS BY HOUR (HOURLY SIGN-INS TAB)

This chart depicts the number of visits by hour of the day. The vertical axis shows the number of visits, while the horizontal axis shows the hours of the day. Each vertical bar shows the number of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment.

The number of visits shown in this chart is *cumulative* for each hourly period.

**Tip:**This chart is good for finding out your busiest hours of the day and also shows which days are busiest during these hourly periods.

### NUMBER OF VISITORS BY HOUR (PEAK HOURS TAB)

This chart depicts the number of visits by hour of the day. The vertical axis shows the number of visits, while the horizontal axis shows the hours of the day. Each vertical bar shows the number of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment. This chart shows a summary of guest sign-ins in addition to student sign-ins, unlike the ‘Number of Sign-Ins by Hour’ chart, which merely shows student sign-ins.

The number of visits shown in this chart is *cumulative* for each hourly period.

**Tip:**This chart is good for finding out your busiest hours of the day and also shows which days are busiest during these hourly periods.

### WEEKLY SIGN-IN TABLE

This table shows the number of sign-ins for each week of the year split by week of the day. The rows are summed up to show the total number of sign-ins per week, and the columns are summed up to show the total number of sign-ins per day for all the weeks.

### DAILY SIGN-IN TABLE

This table shows the number of sign-ins for each period of the day distributed per day of the week. The rows are summed up to show the total number of sign-ins per period, and the columns are summed up to show the total number of sign-ins per day for all the periods.

### DAILY PEAK HOURS TABLE

This table shows the number of visitors for each period of the day distributed per day of the week. The rows are summed up to show the total number of visitors per period, and the columns are summed up to show the total number of visitors per day for all the periods. This chart is similar to the ‘Number of Sign-Ins’ table, except that it shows the guest sign-ins in addition to student sign-ins. This enables you to determine what the peak hours are for visitors during each day individually or throughout the week as a whole.

### SESSION TIME DISTRIBUTION BY WEEK (WEEKLY SESSION TIMES TAB)

This chart depicts the length of the sign-in visit for each week of the year. On the vertical axis you will notice the week number, and on the horizontal axis you will see the total session times in hours. Each horizontal line represents one week, and is composed of several colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents and its numeric value.

### SESSION TIME OF SIGN-INS BY DAY (DAILY SESSION TIMES TAB)

This chart depicts the length of visits by day of the week. The vertical axis shows the length of sign-in sessions, while the horizontal axis shows the day of the week. Each vertical bar represents one day of the week. If the selected reporting period is larger than one week, the length of visits will be added for each day. Thus the chart represents the *cumulative* session length for each day.

### SESSION TIME OF SIGN-IN BY HOUR (HOURLY SESSION TIMES TAB)

This chart depicts length of the session for students signing in during that hour. The vertical axis shows the length of visits in hours, while the horizontal axis shows the hourly periods of the day. Each vertical bar shows the total length of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment.

The number of visits shown in this chart is *cumulative* for each hourly period.

### WEEKLY SESSIONS TABLE

This table shows the length of sign-in periods for each week of the year split by week day. The rows are summed up to show the total hours of sign-ins per week, and the columns are summed up to show the total hours of sign-ins per day for all the weeks.

### DAILY SESSIONS TABLE

This table shows the length of sign-in periods for visitors signing in during each hour of the day distributed by the days of the week. The rows are summed up to show the total hours of sign-ins periods per hour, and the columns are summed up to show the total sign-in hours per day for all the hourly periods.

### NUMBER OF VISITS PER CLASS (VISITS PER ACTIVITY TAB)

This chart shows the number of sign-ins per activity (class/service). The activities are grouped by their categories. The vertical axis shows the number of visits, while the horizontal axis shows the category of activities (subject area…). Each vertical bar shows the number of visits per activity. You can see which activity the bar represents by reading the conversion block above the chart or by holding the mouse pointer steady over the segment.

**Tip:**This chart is good for finding out usage patterns for each activity and which activities are mostly utilized.

### VISITS PER ACTIVITY TABLE

This table shows the number of sign-ins for each activity (class /service) during the reporting period.

### RETURN TIMES (RETURNS TAB)

This chart shows the number of repeat visits for your visitors. The vertical axis shows the number of students returning, while the horizontal axis shows the number of times these students returned. Each vertical bar shows the number of students that returned that many times.

**Tip:**This chart is good for finding out the frequency distribution of returning students.

### RETURNS TABLE

This table shows the returning visits distribution during the reporting period. Each row shows the number of visits in the first column and the number of students who visited that many times in the second column.

Previous - SUCCESS PLAN REPORTS | Back to TABLE OF CONTENTS | Next - EXPORTING REPORT DATA