Launch PerfQuery
From the Database tab click open and browse for the "MyBoat.mdb" access database file.
Check that there are multiple dates available.
Check that when changing the date selection the comments show you what is in that day.
See that some days have multiple ConfigNum. The configNum just means that the day was cut up in more than one part (eg: some days have a training session as ConfigNum0 then a Race in configNum1 and another race in ConfigNum2).

Click on the ReportsTab
Select "MyBoat" as the boat you wish to analyze.
Select FromDate='2010-07-01' and ToDate='2010-08-01'
Click on the GearUsage button. This will open up a GearUsage report giving you statistics of time and distance on port and starbord between the two dates previously selected.
Optionally you can add up to 2 sets of dates. This way you can report on the usage time of, for example, a cable, or a winch if you have a set of dates for which the piece of gear was on the boat.

Click on SailStatsReport. This will get all your sails statistics between the two dates initially specified.

Select some fields from the DailyComments and click on DailyComments Report.

Click on the Query tab.
In the "BasicFilter" tab leave everything option unchecked.
In the Sails tab, leave "Use a sail filter" unchecked. Check "Group phases", "Must have mainsail...", "Ignore mainsails", "Ignore reefs", "Ignore staysails".
In the PhaseFilter tabe leave everything unchecked.
Same for the Options tab.
Now go back to the BasicFilter tab and click on "Count"
It should show that your query, if run, would return 329 phases.
Click on "RunQuery"

The "PerfQUery - Phases" table should come up.
In the "Phases" tab select the variables you wish to see in the table.
Set and clear filters.
Trying exporting the results to Excel.
Export to Crossover.

Click on the Excel Bin Report tab.
Select the following reports:
- Bin Count
- SailsUp
- BSP_Bin + Targets
Click on "Select Variables" and select BSP_perf%, HEEL, AWA, AWS, FORESTAY, RUDDER
In the Options group, select Performance Criteria=BSP%
Check "Group phases by SailsUp", set Minimum per Group=2, Remove best=0, Average best=4
Set comments report to "My first report"
Click "Create Excel Bin Report"
Note: The filters that you may have set in the Phases table apply to all the other tabs. If you do not get data in the Bin Reports or graphs, go back to the "Phases" tab and click "Clear Filter"


Go to the XYGraph tab
Select X Variable=HEEL, Y Variable=Forestay
Click on Refresh

Go to the 3DGraph tab
Select X Variable=TWS, Y Variable=TWA, Z Variable=HEEL
Check "Mix Port/Stbd"
Click on Refresh
Click and drag the graph to rotate it around
SHIFT+Click and drag the graph to pan
ALT+Click and drag the graph to zoom

End of the beginner's tutorial


