If you purchased your Mac in 2006 or later you are probably using an Intel processor. To be sure, select "About This Mac" from the Apple menu and look at the Processor being used.

As long as you have Statbook version 3.2 (or higher), this is now possible. Be sure to check out the Videos Page for a short tutorial on how to do this. The basic steps are as follows:

1. Go to the Games Input and change all your partial innings to .1 or .2
2. For every report and every statistic which uses Innings Pitched (i.e. IP, ERA, WHIP) you will need to select that field and use the corresponding "Favorites" formula

You would add a statistic and call it "PosInn7", for example. See the short video which shows how to add a statistic from this link: http://statbook.pachysoft.com/helpvideos.html

After you add the stat, you will need to then add it to the report (video shows this as well).

Yes, this was an oversight and , yes, this can be fixed. All reports and fields can be edited by selecting a report and selecting the Reports -> Edit Reports menu item (or by double-clicking on a report or field).

To fix this particular problem, do the following steps:

1. Make sure you are using version 3.3 or higher of Statbook
2. Select the report which has the AVG or OBP field
3. Double-click this field (not the report)
4. With the field selected (e.g. AVG), from the 'Favorites' list, select the appropriate item (e.g. Average).
5. Repeat steps 2-4 for each field (and report) which needs updating

1. Select the game where you like the order
2. With the game highlighted, add a new game.
3. The new game will take on attributes of the selected game. (order, played, game type, start time, location, opponent, etc.)

The process would go something like this:

1. Input the data into Statbook
2. Setup the reports and fields the way you like
3. Don't forget to Save the file ;)
4. Build the website (either to your hard drive or you can use the built-in FTP option)
5. If saving to your hard drive, copy the files to your web server (via another FTP program or some other mechanism)

After each game, you would repeat this process. There is no database involved. Just more files are created after each game and some pages (i.e. Reports) are updated.

You can re-order the input by selecting the row and then dragging it to the position you like.

After you set it up how you want it for for one game, simply select that game and then, with the game selected, add a new game (e.g. select the '+' button). This will add a new game with the same order (among other attributes.)

This has been fixed in version 3.3.

APP stands for appearances or number of times a pitcher appears in a game.

This sounds like you may have unknowingly "collapsed" the pitching area. If this is true, here's how to fix:

If you hold you mouse near the bottom-middle of the window, the mouse cursor will change to a "cross with top/bottom arrows". Once it does, click and drag it up to show the stats.

While baseball appears to be the primary focus on the website, all the information from the videos and FAQs could be applied to basketball or soccer. In fact, the way Statbook is structured, you could customize a file to keep track of any sport. The templates provided are merely starting points, where most users customize reports, input statistics and roster information to their liking.

Bottom line is support for Statbook is identical across all sports. Please feel free to keep using Statbook in trial mode until you are completely satisfied Statbook is the right choice.

First check that you are using version 3.0 or higher (About Statbook menu item). If it's 2.x, a 3.0 serial number will not work as this was not a free upgrade. If you need a 2.x serial number, please use the following form: http://statbook.pachysoft.com/php/LostRegistrationNumber.php

Baseball Statbook 2.0.4:

• Mac OS X: http://statbook.pachysoft.com/downloads/BBStatbook_OSX_2.0.4.dmg
• Mac OS 9: http://statbook.pachysoft.com/downloads/BBStatbook_OS9_2.0.4.zip
• Windows: http://statbook.pachysoft.com/downloads/BBStatbook_Win_2.0.4.dmg
• Linux: http://statbook.pachysoft.com/downloads/BBStatbook_Linux_2.0.4.zip

Baseball Statbook 1.5:

• Mac: http://statbook.pachysoft.com/downloads/BBStatbook_Mac_1.5.dmg

I'm not sure "sync" is the right word but you can take desktop Statbook created plist files (see the iPhone tab, "Save..." button) and then copy this file to the iPhone app using iTunes.

To get the data from the iPhone back into the desktop Statbook application, this can be done via email ("Share" tab). Once you download the plist attachment, simply use the "Load File" button from within the desktop Statbook application.

It's more of a manual sync at this point. There are more specific steps in the Help area of the iPhone App if you need more information.

The iPhone app is free but does not allow for reports and managing your stats.

Here is a link which may help you understand the iPhone App and desktop App interact as well as the steps to import and export.

Link: http://statbook.pachysoft.com/iphone_help.html

Please see this FAQ on how to add a player to a previous game:

http://statbook.pachysoft.com/faq/index.php?action=artikel&cat=3&id=7&artlang=en

Yes, Statbook is compatible with Mac OS X 10.7 (AKA Lion) and is also available from the Mac App Store.

We try to respond to every email but most times you don't get a response is because you are using (through some service like Barracuda) or the response is filtered by your ISP or our response is sent to your SPAM account. If you send two or more emails without a response then try using a service like Yahoo! Mail or Google Mail.

From the documentation pages, please see this link: http://statbook.pachysoft.com/Documentation/Help/inputLists.html

NOTE: These steps are for the Baseball template. For other sports, the menu items may have different names but the method is identical.

1. Select the "Games" toolbar item
2. Select "Modify Offensive Statistics" from the Games menu
3. Select the '+' button
4. Enter in unique Field and Name values.
5. Select the "Save" button

Follow these steps to add a statistic to a report.

1. Select the "Reports" toolbar item
2. Select the report you want to edit (e.g. Overall (AllGames) )
3. Select "Edit Reports" from the Reports menu
4. Select the '+' button (bottom-left on the window)
5. Choose a field from the "Favorites" list or, if you created a custom statistic, select from the "Stats" list.
6. Name, format, align and change the width of the added statistic under the "Field Attributes" group
7. Select the "Save" button
8. Save the file to keep these changes

Be sure to check out the video on how to add a statistic in the Videos Section.

Follow these steps to change the ERA innings pitched setting:

1. Select the "Reports" toolbar item
2. Select the report you want to edit (e.g. Overall (All Games) )
3. Select "Edit Reports" from the Reports menu
4. Select the 'ERA' field
5. In the "Result" field you will see the number "6.0". Change this to your preferred setting (i.e. '7.0')
6. Select the "Save" button
7. Save the file to keep these changes

Repeat this procdure for all reports which use an ERA calculation.

NOTE: OPS = OBP + SLG

For an overall report, the following would be put in the Result field (edit report mode, add new field):

(sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)) + ((sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice))

 You also want to make sure the Format is: #0.000

After you add the new player (Players -> Add Player menu item), follow these steps:

1. Select this player in the Roster list.
2. Go to the "Games" area and select the games you want that player (or players) to show up in.
3. Select the "Games -> Add Players to Selected Games..." menu item.

You may also want to take a look at the sample file from the Statbook Downloads Page. From this file:

1. Select on "Games" from the toolbar. Then
2. Select Games -> Next Set until you see the "Positions" set selected. This shows an example of how you would enter positions.

From a new (default) file, the "Positions" set is not a saved set but can be created using the following procedure:

1. Select Games -> Modify Batting/Fielding Stats... menu item
2. Check/Uncheck the fields you wish to show (e.g. Stats.PosInn1, etc)
3. Select the "Save" button
4. Click and hold the "Default" set (popup menu) and then select the "Save Set" item
5. Give the set a name (e.g. "Positions") and select "Save"
6. Save the file to keep these changes.

Yes, but it can get complicated. If you are familiar with SQL this will come naturally. If not, then feel free to make a request.

For the problem above, this will create what you are looking for (The Result field when editing a report):

p.first || " " || p.last || " " || "(" || (s.Single+s.Double+s.Triple+s.HomeRun) || "-" || (s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) || (CASE WHEN s.Double=1 THEN ", 2B" ELSE (CASE WHEN s.Double>1 THEN ", " || s.Double || " 2B" ELSE "" END) END) || (CASE WHEN s.Triple=1 THEN ", 3B" ELSE (CASE WHEN s.Triple>1 THEN ", " || s.Triple || " 3B" ELSE "" END) END) || (CASE WHEN s.HomeRun=1 THEN ", HR" ELSE (CASE WHEN s.HomeRun>1 THEN ", " || s.HomeRun || " HR" ELSE "" END) END) || (CASE WHEN s.RBI=1 THEN ", RBI" ELSE (CASE WHEN s.RBI>1 THEN ", " || s.RBI || " RBIs" ELSE "" END) END) || (CASE WHEN s.Runs=1 THEN ", Run" ELSE (CASE WHEN s.Runs>1 THEN ", " || s.Runs || " Runs" ELSE "" END) END) || ")"

You can also go to the Statbook Downloads Page and import a similar example report (See the More Reports download link)

Yes, you can get the 'Totals' line in the correct format by following these steps:

1. Edit the report and select the added field.
2. Choose a 'Format' for the field. If it's a number, choose one of the number formats ( e.g. '#0', '#0.0', etc) and it will sum the totals. If it's text, leave it blank or choose '-'.

Yes, this was an oversight and , yes, this can be fixed. All reports and fields can be edited by selecting a report and selecting the Reports -> Edit Reports menu item (or by double-clicking on a report or field).

To fix this particular problem, do the following steps:

1. Make sure you are using version 3.3 or higher of Statbook
2. Select the report which has the AVG or OBP field
3. Double-click this field (not the report)
4. With the field selected (e.g. AVG), from the 'Favorites' list, select the appropriate item (e.g. Average).
5. Repeat steps 2-4 for each field (and report) which needs updating

1. Select the game where you like the order
2. With the game highlighted, add a new game.
3. The new game will take on attributes of the selected game. (order, played, game type, start time, location, opponent, etc.)

There was a problem with rounding  in earlier formulas for the teriary IP favorites. This is now fixed in versions 3.3 or higher.

To fix this problem is files created in versions 3.2.2 or less, do the following steps:

1. Make sure you are using version 3.3 or higher of Statbook
2. Select the report which has the IP, ERA or WHIP fields
3. Double-click this field (not the report)
4. With the field selected (e.g. IP), from the 'Favorites' list, select the appropriate item ( e.g. IP (.1, .2) ).
5. Repeat steps 2-4 for each field (and report) which needs updating

From the "Preferences" panel, under "Report Popup Menu Options", you will need to modify the "Filter" option under the "Game (Boxscore) Type column. The default is "<none>" which shows boxscores for all games. To allow for only League and Post-season game types, select:

WHERE GameType = 'League' OR GameType = 'Post-Season'

To allow for a custom Game Type, you can type in the combination box something like:

WHERE GameType = 'League' OR GameType = 'Tournament'

I'm not sure "sync" is the right word but you can take desktop Statbook created plist files (see the iPhone tab, "Save..." button) and then copy this file to the iPhone app using iTunes.

To get the data from the iPhone back into the desktop Statbook application, this can be done via email ("Share" tab). Once you download the plist attachment, simply use the "Load File" button from within the desktop Statbook application.

It's more of a manual sync at this point. There are more specific steps in the Help area of the iPhone App if you need more information.

The iPhone app is free but does not allow for reports and managing your stats.

Here is a link which may help you understand the iPhone App and desktop App interact as well as the steps to import and export.

Link: http://statbook.pachysoft.com/iphone_help.html

Please see this FAQ on how to add a player to a previous game:

http://statbook.pachysoft.com/faq/index.php?action=artikel&cat=3&id=7&artlang=en

Yes. There are multiple ways to do this but the easiest is to update the Additional Instructions area of a duplicated report. Here's how to do this:

1. Duplicate the "Overall - Exhibition" and/or "Overall - Pitching (Exhib)" reports (Reports -> Duplicate Report)
2. Edit the new report (Reports -> Edit Reports... menu item or double click on the report)
3. Under the "Additional Instructions" section (left-side) change Where g.GameType="Exhibition" to Where g.GameType="League". (You should also change the title above)
4. Select the "Save & Return" toolbar menu
5. Save the file

To copy Batting Order: If you first select any game and then add a new game, the batting order is used from the selected game.

To Copy all other data, including positions, you simple create a Duplicate of the game (Reports -> Duplicate Reports menu item). To keep only positions, you would zero out/clear the other statistics.

You can quickly to this by entering 0's or blanks in the top row and then entering into "Selection Mode" (Edit -> Selection Mode menu item). Drag to select all the top row and then choose the Edit -> Fill Down menu item.

So, the "Additional Instructions" field in near the top-left of the Edit Reports window (right below the two check-boxes, "Show Totals" and "Group With Next".

To get to the Edit Reports window, either double-click on a report (or a report field) or select a report and then choose the Reports -> Edit Reports... menu item.

To have a "League" only report, you would put this text in the "Additional Instructions" field (making sure "GROUP BY p.ID" is a separate line):

Where g.GameType="League"
GROUP BY p.ID

The Pitching report would look like this:

WHERE s.pitched='1' AND g.GameType="League"
GROUP BY p.ID 

Let's go one step further and say you want a League report but only show the "Active" players on your roster. This would look like:

Where g.GameType="League" AND p.Active='1'
GROUP BY p.ID

The Pitching report would not need to change since an inactive player should not have pitched.

Now let's say you want to a report that shows the last 5 games, for League games only:

Where g.GameType="League" AND p.Active='1' AND s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5)
GROUP BY p.ID

Last 2 games would look like:

Where g.GameType="League" AND p.Active='1' AND s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,2)
GROUP BY p.ID

Changed the '5' to a '2'

For Non-League reports, simply replace "League" in the above examples with "Non-League".

Follow these steps to add a statistic to a report.

1. Select the "Reports" toolbar item
2. Select the report you want to edit (e.g. Overall (AllGames) )
3. Select "Edit Reports" from the Reports menu
4. Select the '+' button (bottom-left on the window)
5. Choose a field from the "Favorites" list or, if you created a custom statistic, select from the "Stats" list.
6. Name, format, align and change the width of the added statistic under the "Field Attributes" group
7. Select the "Save" button
8. Save the file to keep these changes

Be sure to check out the video on how to add a statistic in the Videos Section.

Follow these steps to change the ERA innings pitched setting:

1. Select the "Reports" toolbar item
2. Select the report you want to edit (e.g. Overall (All Games) )
3. Select "Edit Reports" from the Reports menu
4. Select the 'ERA' field
5. In the "Result" field you will see the number "6.0". Change this to your preferred setting (i.e. '7.0')
6. Select the "Save" button
7. Save the file to keep these changes

Repeat this procdure for all reports which use an ERA calculation.

NOTE: OPS = OBP + SLG

For an overall report, the following would be put in the Result field (edit report mode, add new field):

(sum(s.Single+s.Double+s.Triple+s.HomeRun+s.Walks+s.HitByPitch)*1.0/sum(s.Plate)) + ((sum(s.Single)+2*sum(s.Double)+3*sum(s.Triple)+4*sum(s.HomeRun))*1.0/sum(s.Plate-s.Walks-s.HitByPitch-s.Sacrifice))

 You also want to make sure the Format is: #0.000

After you add the new player (Players -> Add Player menu item), follow these steps:

1. Select this player in the Roster list.
2. Go to the "Games" area and select the games you want that player (or players) to show up in.
3. Select the "Games -> Add Players to Selected Games..." menu item.

Catchers interference can happen when a batter swings and the bat strikes the catchers glove or helmet. It does not count as an official at-bat but does count as an error on the catcher. Here is the full description from Wikipedia:

Catcher's interference is called when the catcher physically hinders the batter's opportunity to legally swing at a pitched ball. This occurs most often when a catcher squats too close to home plate, so that the batter's bat touches the catcher's glove as the batter swings. This is most likely to happen on attempted steals where the catcher is anxious to catch the ball as soon as possible and may move his entire body or glove forward a bit.

Yes, but it can get complicated. If you are familiar with SQL this will come naturally. If not, then feel free to make a request.

For the problem above, this will create what you are looking for (The Result field when editing a report):

p.first || " " || p.last || " " || "(" || (s.Single+s.Double+s.Triple+s.HomeRun) || "-" || (s.Plate-s.Walks-s.HitByPitch-s.Sacrifice) || (CASE WHEN s.Double=1 THEN ", 2B" ELSE (CASE WHEN s.Double>1 THEN ", " || s.Double || " 2B" ELSE "" END) END) || (CASE WHEN s.Triple=1 THEN ", 3B" ELSE (CASE WHEN s.Triple>1 THEN ", " || s.Triple || " 3B" ELSE "" END) END) || (CASE WHEN s.HomeRun=1 THEN ", HR" ELSE (CASE WHEN s.HomeRun>1 THEN ", " || s.HomeRun || " HR" ELSE "" END) END) || (CASE WHEN s.RBI=1 THEN ", RBI" ELSE (CASE WHEN s.RBI>1 THEN ", " || s.RBI || " RBIs" ELSE "" END) END) || (CASE WHEN s.Runs=1 THEN ", Run" ELSE (CASE WHEN s.Runs>1 THEN ", " || s.Runs || " Runs" ELSE "" END) END) || ")"

You can also go to the Statbook Downloads Page and import a similar example report (See the More Reports download link)

Yes, you can get the 'Totals' line in the correct format by following these steps:

1. Edit the report and select the added field.
2. Choose a 'Format' for the field. If it's a number, choose one of the number formats ( e.g. '#0', '#0.0', etc) and it will sum the totals. If it's text, leave it blank or choose '-'.

You would add a statistic and call it "PosInn7", for example. See the short video which shows how to add a statistic from this link: http://statbook.pachysoft.com/helpvideos.html

After you add the stat, you will need to then add it to the report (video shows this as well).

You would add a statistic and call it "PosInn7", for example. See the short video which shows how to add a statistic from this link: http://statbook.pachysoft.com/helpvideos.html

After you add the stat, you will need to then add it to the report (video shows this as well).

Yes, this was an oversight and , yes, this can be fixed. All reports and fields can be edited by selecting a report and selecting the Reports -> Edit Reports menu item (or by double-clicking on a report or field).

To fix this particular problem, do the following steps:

1. Make sure you are using version 3.3 or higher of Statbook
2. Select the report which has the AVG or OBP field
3. Double-click this field (not the report)
4. With the field selected (e.g. AVG), from the 'Favorites' list, select the appropriate item (e.g. Average).
5. Repeat steps 2-4 for each field (and report) which needs updating

1. Select the game where you like the order
2. With the game highlighted, add a new game.
3. The new game will take on attributes of the selected game. (order, played, game type, start time, location, opponent, etc.)

You need to show the "Order" field before you can move players around. There was an alert message that warned about this but it also gave an option of not showing the message again (which I am assuming was selected)

So, to fix:

1. Select the "Modify Batting/Fielding Statistics" menu item from the Games menu
2. Select the "Stats.BatOrder" show field
3. Select save.

The order field will now be shown and moving players around will now stick.

There was a problem with rounding  in earlier formulas for the teriary IP favorites. This is now fixed in versions 3.3 or higher.

To fix this problem is files created in versions 3.2.2 or less, do the following steps:

1. Make sure you are using version 3.3 or higher of Statbook
2. Select the report which has the IP, ERA or WHIP fields
3. Double-click this field (not the report)
4. With the field selected (e.g. IP), from the 'Favorites' list, select the appropriate item ( e.g. IP (.1, .2) ).
5. Repeat steps 2-4 for each field (and report) which needs updating

Yes. Select the report (e.g., Game Results) and check the "Record wTies" field in the Fields list. If you have removed this field, then you will need to edit the report and select "Record" from the field list and then enter in the following for the 'Result' field:

(SELECT SUM(CASE WHEN g2.Result like 'W%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'L%' THEN 1 ELSE 0 END) || "-" || SUM(CASE WHEN g2.Result like 'T%' THEN 1 ELSE 0 END) FROM Games g2 WHERE g2.GameNo <= g.GameNo)

And then make sure you save the report. You can also simply select 'Record (with Ties) from the Favorites list.

I don't think so. But you can easily create one:

For example, duplicate an "Overall - Exhibition" report, edit the report and modify the "Additional Instructions" to have:

g.GameType="League"
GROUP BY p.ID 

instead of:

g.GameType="Exhibition"
GROUP BY p.ID 

For a non-league game, you could do something like this:

You can also view other examples from the following default reports:

Overall - Exhibition
Overall - Pitching (Exhib)
Overall - Post-Season
Overall - Pitching (Post)

Currently this is not an option. But you can simply save the file as a new file, then remove all the games, and now you have all the custom stats (and reports) set up like you want.

The roster report is actually a roster for a game. Therefore, it requires at least one game to be entered.

You would simply show them as not playing that game (Played checkbox) in the statistics input area (under Games input).

Here are the steps:

1. Duplicate the "Overall (Last 5 Games)" report and select the duplicated report
2. Go to the Reports -> Edit Reports... menu item (or just double-click the newly created report)
3. For games 1 through 4, Replace the "Additional Instructions" field with the following text:
   
   WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo LIMIT 0,4)  
   GROUP BY p.ID
    
4. For games 3 through 6, Replace the "Additional Instructions" field with the following text:
   
   WHERE s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo LIMIT 2,4)
   GROUP BY p.ID

NOTE: This is assuming the GameNo fields for the Games are consecutive and correctly named.

You can re-order the input by selecting the row and then dragging it to the position you like.

After you set it up how you want it for for one game, simply select that game and then, with the game selected, add a new game (e.g. select the '+' button). This will add a new game with the same order (among other attributes.)

First, duplicate a report, for example one of the Overall reports. Then you would add something like the following to the 'Additional Instructions' field, assuming a game with the date exists:

WHERE g.GameDate = '2008-03-08'
GROUP BY p.ID

Or you could pick all games in March of 2008 with the following:

WHERE g.GameDate >= '2008-03-01' AND g.GameDate <= '2008-03-31'
GROUP BY p.ID

Or, selected games, like:

WHERE g.GameDate = '2008-03-01' AND g.GameDate = '2008-03-08' AND g.GameDate = '2008-03-10'
GROUP BY p.ID

This issue has been fixed in version 3.3.

APP stands for appearances or number of times a pitcher appears in a game.

From the "Preferences" panel, under "Report Popup Menu Options", you will need to modify the "Filter" option under the "Game (Boxscore) Type column. The default is "<none>" which shows boxscores for all games. To allow for only League and Post-season game types, select:

WHERE GameType = 'League' OR GameType = 'Post-Season'

To allow for a custom Game Type, you can type in the combination box something like:

WHERE GameType = 'League' OR GameType = 'Tournament'

You are confusing Plate Appearances (PA) with At Bats (AB). AB's are calculated from PA's.

From this Wikipedia Article:

AB—At bat: Batting appearances, not including bases on balls, hit by pitch, sacrifices, interference, or obstruction.

PA—Plate appearance: number of completed batting appearances.

Yes, but it would be best to create a new field and use something like this in the 'Result' field:

s.minutes || ':' || s.seconds

This also means you have created a stat called 'seconds'.

To view/print lineup reports or rosters you must first create at least one game. the thinking here is that each game may have a different lineup.

Yes. There are multiple ways to do this but the easiest is to update the Additional Instructions area of a duplicated report. Here's how to do this:

1. Duplicate the "Overall - Exhibition" and/or "Overall - Pitching (Exhib)" reports (Reports -> Duplicate Report)
2. Edit the new report (Reports -> Edit Reports... menu item or double click on the report)
3. Under the "Additional Instructions" section (left-side) change Where g.GameType="Exhibition" to Where g.GameType="League". (You should also change the title above)
4. Select the "Save & Return" toolbar menu
5. Save the file

So, the "Additional Instructions" field in near the top-left of the Edit Reports window (right below the two check-boxes, "Show Totals" and "Group With Next".

To get to the Edit Reports window, either double-click on a report (or a report field) or select a report and then choose the Reports -> Edit Reports... menu item.

To have a "League" only report, you would put this text in the "Additional Instructions" field (making sure "GROUP BY p.ID" is a separate line):

Where g.GameType="League"
GROUP BY p.ID

The Pitching report would look like this:

WHERE s.pitched='1' AND g.GameType="League"
GROUP BY p.ID 

Let's go one step further and say you want a League report but only show the "Active" players on your roster. This would look like:

Where g.GameType="League" AND p.Active='1'
GROUP BY p.ID

The Pitching report would not need to change since an inactive player should not have pitched.

Now let's say you want to a report that shows the last 5 games, for League games only:

Where g.GameType="League" AND p.Active='1' AND s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,5)
GROUP BY p.ID

Last 2 games would look like:

Where g.GameType="League" AND p.Active='1' AND s.gameID IN (SELECT g.id FROM games g ORDER BY g.gameNo DESC LIMIT 0,2)
GROUP BY p.ID

Changed the '5' to a '2'

For Non-League reports, simply replace "League" in the above examples with "Non-League".

For overall reports, be sure SUM() is used for the formula in the 'Result' field (This is availabe when editing a field). So, from your example, the result field would look like:

sum(s.singles)

NOTE: These steps are for the Baseball template. For other sports, the menu items may have different names but the method is identical.

1. Select the "Games" toolbar item
2. Select "Modify Offensive Statistics" from the Games menu
3. Select the '+' button
4. Enter in unique Field and Name values.
5. Select the "Save" button

If you download the sample file, it shows three "sets" being used: Hitting, Fielding and Positions. Basically it allows you to organize your input variables.

For example, you may want to assign positions before the game is played. After it is played you would then enter in hitting and fielding stats. Sets allow you to quickly toggle between the different input groups instead of trying to jam in all the inputs onto one screen.

Link to sample file: http://statbook.pachysoft.com/download.html

You may also want to take a look at the sample file from the Statbook Downloads Page. From this file:

1. Select on "Games" from the toolbar. Then
2. Select Games -> Next Set until you see the "Positions" set selected. This shows an example of how you would enter positions.

From a new (default) file, the "Positions" set is not a saved set but can be created using the following procedure:

1. Select Games -> Modify Batting/Fielding Stats... menu item
2. Check/Uncheck the fields you wish to show (e.g. Stats.PosInn1, etc)
3. Select the "Save" button
4. Click and hold the "Default" set (popup menu) and then select the "Save Set" item
5. Give the set a name (e.g. "Positions") and select "Save"
6. Save the file to keep these changes.

Please see this FAQ on how to add a player to a previous game:

http://statbook.pachysoft.com/faq/index.php?action=artikel&cat=3&id=7&artlang=en

To copy Batting Order: If you first select any game and then add a new game, the batting order is used from the selected game.

To Copy all other data, including positions, you simple create a Duplicate of the game (Reports -> Duplicate Reports menu item). To keep only positions, you would zero out/clear the other statistics.

You can quickly to this by entering 0's or blanks in the top row and then entering into "Selection Mode" (Edit -> Selection Mode menu item). Drag to select all the top row and then choose the Edit -> Fill Down menu item.

From the documentation pages, please see this link: http://statbook.pachysoft.com/Documentation/Help/inputLists.html

After you add the new player (Players -> Add Player menu item), follow these steps:

1. Select this player in the Roster list.
2. Go to the "Games" area and select the games you want that player (or players) to show up in.
3. Select the "Games -> Add Players to Selected Games..." menu item.

Please see this FAQ on how to add a player to a previous game:

http://statbook.pachysoft.com/faq/index.php?action=artikel&cat=3&id=7&artlang=en