Abstract

The spreadsheets are the FA-Helper and the PR-Helper (the all-in-one Battrick-Helper is no longer available). They are designed to help play the Battrick cricket management game. Although they are in a Microsoft Excel format, they should open and run correctly with Open Office (a free open source replacement for Microsoft Office applications).

Download

• FA-Helper.xls (36KB). Downloaded times since .
• PR-Helper.xls (26KB). Downloaded times since .

FA-Helper

This spreadsheet is for maximising your interest income, based on your current balance, and the number of Financial Assistants (FAs) you have. It also works for negative balances, although we’re still not quite sure of the percentage values for interest expenditure. Contact me (Jargon) in game if you have some values you wish to share. Insert your current balance, insert the number of FAs you currently have, and read the result from the blue box. Everything else is just extra information!

Version 1.2.0

• Removed macros and use of INDIRECT with named ranges, to ensure it worked with Open Office.

PR-Helper

This spreadsheet can help you maximise you profit from Sponsors’ Income. Simply enter the number of members you had at the last update, and this will tell you the number of PRs you should have. The spreadsheet only currently works for ecstatic sponsors’ confidence.

Version 1.0.3

• Removed macros to ensure it worked with Open Office.

The following are no longer available and are kept here for historical reference only.

Timetable-Helper

This spreadsheet can help you plan ahead for lots of aspects of Battrick. By entering your correct starting positions for each league, it will display a calendar showing whether each game is home or away, as well as giving the days of the regular weekly events, and highlighting the current day. Knowing what’s coming up, further ahead than the two weeks that Battrick shows, allows you to plan more effectively with your finances and Player Fitness Levels.

Version 1.1.1

• Added notice regarding correct FC league position. See http://garyjones.co.uk/blog/fc-fixtures/.

Version 1.1.0

• Bugfix for FC Match 14 Day 1.
• Minor formatting changes.
• Allowed timetable to be shown, even without league positions being entered. If they are entered, then the Home/Away data is added.

Version 1.0.0

• First official release.
• Updated overal schedule for Season 9, including mis-season BT20 matches.
• Simplified by removing World Cup data.
• Reformatted to match Wombat’s calendar, to make it easier for end-users to switch between the two.
• Confirmed FC Home/Away data.

It was downloaded 827 times between 2008-01-29 and 2009-10-19.

Battrick-Helper

The Battrick-Helper was a suite of spreadsheets composed of the FA-Helper, the PR-Helper and the Timetable-Helper. It was downloaded 4397 times between 2008-01-29 and 2009-10-19.