FAQ Overview

General Usage

I am on a Mac but not sure which file to download, OSX Intel Zip or OSX PowerPC Zip?

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.

Author: Paul
Last update: 2009-11-23 19:13


I used to indicate .1 for a 1/3 inning in the older software. I am getting some weird numbers if I use .3 or .7. How can I go back to using .1 and .2 for 1/3, and 2/3 innings?

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

Author: Statbook
Last update: 2009-11-24 19:06


The only choices for innings are 6 or 9. I've changed the ERA to reflect calculations for 7 innings, but I need to add an inning for the "position by inning". How do I do that?

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).

Author: Statbook
Last update: 2010-03-08 19:22


There seems to be a bug in the Average (AVG) and On-Base Pct. (OBP) report calculations as they do not account for Sacrafice Flys (Sac Fly). Is there a way to fix this?

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

Author: Statbook
Last update: 2010-04-28 16:56


How do I create games so that the batting order is in the same order as a previous game?

  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.)

Author: Statbook
Last update: 2010-04-28 16:43


I am trying to find a stat tool for my men's softball team and I want it accessible via the web. What are the basic steps in using Statbook? Do I need to set up a database?

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.

Author: Statbook
Last update: 2010-04-28 17:22


I would like the order in my basketball stats to be by player number. How do I get it set to their number. I have entered the numbers in my roster and have the roster showing up in numeric order but can't get the stat input page to be in that order.

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.)

Author: Statbook
Last update: 2010-04-28 17:26


statbook mac version 3.2.2 mac os 10.5.8, intel based processor baseball ERROR: database error 19 Stat.Batted may not be NULL I entered my team of 17 players and was 'playing' with the software before my season starts. I added a new player to my roster, then I tried to add him to a game. This is when the error occurred. Any ideas? Mark

This has been fixed in version 3.3.

Author: Statbook
Last update: 2010-04-28 18:52


What does APP (pitching stat) mean and where does the filed populate from?

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

Author: Statbook
Last update: 2010-05-03 18:51


When looking at the game stat entry/input page, the pitching area has disappeared. How do I get that back?

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.

Author: Statbook
Last update: 2010-06-07 22:13


I am a varsity basketball coach who has been searching for years to find a basketball stat program that runs on a Mac OS. Your program seems to be what I am looking for. However, I can find nothing on your web site that supports the basketball side of your program. It is dominated by baseball. Are you as committed to the basketball part of your program as you are the baseball part?

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.

Author: Statbook
Last update: 2010-06-19 17:59


I keep trying to enter my serial number into Statbook and it keeps telling me it not valid. I've tried manual entry and copy/paste.

Author: Statbook
Last update: 2011-02-21 17:16


Where can I download previous versions of Statbook and Baseball Statbook?

Author: Statbook
Last update: 2012-02-03 18:02


Can I sync to iPhone version? Create a roster and export it the iPhone (actually an iPad)?

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.

Author: Statbook
Last update: 2010-09-18 15:47


How do you create a .plist file on the iphone and then import it in the desktop application and print the report off? Also if I bought the Statbook app for the iphone do I have to also buy the desktop application?

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

Author: Statbook
Last update: 2010-09-23 20:21


How can I add a player to the roster and have them show up in previous games. Right now the new player only shows up in newly created games.

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

Author: Statbook
Last update: 2010-11-05 00:09


Is Statbook compatible with Mac OS X 10.7 Lion?

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

Author: Statbook
Last update: 2012-02-03 18:09


How come you don't respond to my emails?

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.

Author: Statbook
Last update: 2012-09-28 15:42


I downloaded your software and can't figure out how to imput game data. I put in my roster info, made a file for our first game, but can't figure out how to add stats. Can you help?

Author: Statbook
Last update: 2012-09-28 15:47


How To's

How do you create an Input Statistic?

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

Author: Paul
Last update: 2009-11-24 18:26


How do you add a statistic to a report?

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.

 

 

Author: Statbook
Last update: 2009-11-24 18:24


You calculate ERAs for 6 or 9 innings. My ERA is based on 7 innings (or another number). How do I change this?

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.

Author: Statbook
Last update: 2009-11-24 18:42


How do I add OPS (On-base percentage + Slugging) to an overall report?

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

Author: Statbook
Last update: 2009-11-24 18:31


When I add a new player they do not appear in the game data entry forms or in the reports. How do I add a new player during the season?

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.

Author: Statbook
Last update: 2009-11-24 18:34


I just purchased Statbook 3.2 in the hopes that it would be better than 2.0. I'm pretty experienced with 2.0, but just how do I add positions?

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.

Author: Statbook
Last update: 2009-11-24 18:40


Love the new report builder. Can it do conditionals? For example, Can I create a custom report to read: Mickey Mantle (1-3, 2 2B, 3 RBIs, Run); Roger Maris (2-3, RBI)?

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)

 

Author: Statbook
Last update: 2009-11-24 18:58


Any way to for me to access the Totals line on reports? My added fields sometimes don't have totals.

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 '-'.

Author: Statbook
Last update: 2009-11-24 19:01


There seems to be a bug in the Average (AVG) and On-Base Pct. (OBP) report calculations as they do not account for Sacrafice Flys (Sac Fly). Is there a way to fix this?

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

Author: Statbook
Last update: 2010-04-28 16:56


How do I create games so that the batting order is in the same order as a previous game?

  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.)

Author: Statbook
Last update: 2010-04-28 16:43


I am using the tertiary point (dot notation) for Innings Pitched (i.e. .1, .2) but I am seeing, under totals in some reports, with .3( e.g. 11.3), which is not correct and should be 12. How do I fix this?

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

 

Author: Statbook
Last update: 2011-06-02 17:31


I have a Boxscore Report but it shows boxscores for all games. How do I show boxscores for only "League" and "Post-Season" (or some other type)?

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'

Report Popup Menu Options

Author: Statbook
Last update: 2010-06-19 18:04


Can I sync to iPhone version? Create a roster and export it the iPhone (actually an iPad)?

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.

Author: Statbook
Last update: 2010-09-18 15:47


How do you create a .plist file on the iphone and then import it in the desktop application and print the report off? Also if I bought the Statbook app for the iphone do I have to also buy the desktop application?

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

Author: Statbook
Last update: 2010-09-23 20:21


How can I add a player to the roster and have them show up in previous games. Right now the new player only shows up in newly created games.

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

Author: Statbook
Last update: 2010-11-05 00:09


Is there a way to run a report filtered for just overall league games?

 

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

 

Author: Statbook
Last update: 2011-04-09 16:39


I made a set for positions (by inning) and batting order under the "Games" section for my first game. Is there a way to copy that game roster to my next game?

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.

Author: Statbook
Last update: 2011-04-09 16:37


Where is the "Additional Instructions" field? Also, I'd like to be able to have access to the last 2,3,4,and 5 games for both league and non league

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".

Author: Statbook
Last update: 2011-04-22 19:07


Reports & Statistics

How do you add a statistic to a report?

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.

 

 

Author: Statbook
Last update: 2009-11-24 18:24


You calculate ERAs for 6 or 9 innings. My ERA is based on 7 innings (or another number). How do I change this?

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.

Author: Statbook
Last update: 2009-11-24 18:42


How do I add OPS (On-base percentage + Slugging) to an overall report?

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

Author: Statbook
Last update: 2009-11-24 18:31


When I add a new player they do not appear in the game data entry forms or in the reports. How do I add a new player during the season?

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.

Author: Statbook
Last update: 2009-11-24 18:34


I don't understand the statistic Catcher's Interference (CI)? How would a catcher interfere and with what would the catcher interfere.

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.

 

Author: Statbook
Last update: 2009-11-24 18:45


Love the new report builder. Can it do conditionals? For example, Can I create a custom report to read: Mickey Mantle (1-3, 2 2B, 3 RBIs, Run); Roger Maris (2-3, RBI)?

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)

 

Author: Statbook
Last update: 2009-11-24 18:58


Any way to for me to access the Totals line on reports? My added fields sometimes don't have totals.

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 '-'.

Author: Statbook
Last update: 2009-11-24 19:01


The only choices for innings are 6 or 9. I've changed the ERA to reflect calculations for 7 innings, but I need to add an inning for the "position by inning". How do I do that?

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).

Author: Statbook
Last update: 2010-03-08 19:21


The only choices for innings are 6 or 9. I've changed the ERA to reflect calculations for 7 innings, but I need to add an inning for the "position by inning". How do I do that?

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).

Author: Statbook
Last update: 2010-03-08 19:22


There seems to be a bug in the Average (AVG) and On-Base Pct. (OBP) report calculations as they do not account for Sacrafice Flys (Sac Fly). Is there a way to fix this?

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

Author: Statbook
Last update: 2010-04-28 16:56


How do I create games so that the batting order is in the same order as a previous game?

  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.)

Author: Statbook
Last update: 2010-04-28 16:43


After ordering players ALL the games go back to a certain pre-formed order. I have no idea where it gets the info for the order it is in, but... it's not in the order that I chose?

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.

Author: Statbook
Last update: 2010-04-28 16:47


I am using the tertiary point (dot notation) for Innings Pitched (i.e. .1, .2) but I am seeing, under totals in some reports, with .3( e.g. 11.3), which is not correct and should be 12. How do I fix this?

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

 

Author: Statbook
Last update: 2011-06-02 17:31


In my baseball league the game result can be a tie. Is it possible to add a game result as a tie? Then the overall team record can be 5-2-1?

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.

Author: Statbook
Last update: 2011-06-02 17:30


I don't see a stat report for just "league" stats in the newest edition. How do i add this? And what about a "Non-League" report?

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:

Where g.GameType<>"League
GROUP BY p.ID  


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

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

Author: Statbook
Last update: 2011-04-22 18:56


How do I add to the Favorites list so I don't have to add all my custom categories one by one to a new season?

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.

Author: Statbook
Last update: 2010-04-28 17:06


I created a new bsb file, added 11 players, I am having trouble creating a roster report. When I select reports and check the roster no data shows in the report. Can you help?

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

Author: Statbook
Last update: 2010-04-28 17:08


How can I remove 3 players from a specific game but not from the central roster?

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

Author: Statbook
Last update: 2010-04-28 17:09


If I have a team that's played 10 games, how would I create a report to show the overall stats for games 1-4 or games 3-6.

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.

Author: Statbook
Last update: 2011-04-22 18:53


I would like the order in my basketball stats to be by player number. How do I get it set to their number. I have entered the numbers in my roster and have the roster showing up in numeric order but can't get the stat input page to be in that order.

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.)

Author: Statbook
Last update: 2010-04-28 17:26


Hey there, How do I make a report by certain games? Say all Saturday games (certain games by date)?

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

Author: Statbook
Last update: 2010-04-28 18:48


I've entered game data for five games and then look at reports, e.g., pitching, and it comes back with a great report. I then save and re-open and get nothing in the report, although all the data is still there, as it calculates, e.g., ERA for each game - just no individual stats. Same goes for box scores - data is there but it won't produce a box score for game(s).

This issue has been fixed in version 3.3.

Author: Statbook
Last update: 2010-04-28 18:52


What does APP (pitching stat) mean and where does the filed populate from?

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

Author: Statbook
Last update: 2010-05-03 18:51


I have a Boxscore Report but it shows boxscores for all games. How do I show boxscores for only "League" and "Post-Season" (or some other type)?

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'

Report Popup Menu Options

Author: Statbook
Last update: 2010-06-19 18:04


I think your calculations are incorrect. PA = plate appearances. In baseball a Plate Appearance happens only on a hit, or an out. If he walks a PA is not recorded. Your software seems to want PA’s to include walks.

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.

Author: Statbook
Last update: 2010-06-19 19:42


Can I see in records Field "Min" in format min:sec?

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'.

Author: Serg
Last update: 2011-02-06 18:16


I am having problems printing my roster. All I get are three headings and no names or numbers. What is the secret to printing/viewing a soccer (or any sport) roster?

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.

Author: Statbook
Last update: 2011-03-10 19:23


Is there a way to run a report filtered for just overall league games?

 

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

 

Author: Statbook
Last update: 2011-04-09 16:39


Where is the "Additional Instructions" field? Also, I'd like to be able to have access to the last 2,3,4,and 5 games for both league and non league

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".

Author: Statbook
Last update: 2011-04-22 19:07


I am trialling this software for potential use. I have entered 13 games worth of data and am having as problem with 1 data field. If I look at BOXSCORE report it shows all of my players 'singles' per game. However when I look at Overall Games report, it reports '0' singles for all players. Any new game I enter from now, shows the singles. IS there a way of 'fixing' the previous 13 games so the singles appear in the overall games report

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)

Author: Statbook
Last update: 2012-02-03 18:06


Games Input

How do you create an Input Statistic?

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

Author: Paul
Last update: 2009-11-24 18:26


Can you explain how to use Sets? I am having trouble making the transition from 2.0 to 3.0.

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

Author: Statbook
Last update: 2009-11-24 18:19


I just purchased Statbook 3.2 in the hopes that it would be better than 2.0. I'm pretty experienced with 2.0, but just how do I add positions?

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.

Author: Statbook
Last update: 2009-11-24 18:40


How can I add a player to the roster and have them show up in previous games. Right now the new player only shows up in newly created games.

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

Author: Statbook
Last update: 2010-11-05 00:09


I made a set for positions (by inning) and batting order under the "Games" section for my first game. Is there a way to copy that game roster to my next game?

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.

Author: Statbook
Last update: 2011-04-09 16:37


I downloaded your software and can't figure out how to imput game data. I put in my roster info, made a file for our first game, but can't figure out how to add stats. Can you help?

Author: Statbook
Last update: 2012-09-28 15:47


Players and Roster

When I add a new player they do not appear in the game data entry forms or in the reports. How do I add a new player during the season?

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.

Author: Statbook
Last update: 2009-11-24 18:34


How can I add a player to the roster and have them show up in previous games. Right now the new player only shows up in newly created games.

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

Author: Statbook
Last update: 2010-11-05 00:09