Gary Jones

Abstract

The Battrick-Helper suite of spreadsheets is composed of the FA-Helper, the PR-Helper and the Timetable-Helper. It is 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

Option 1 (Recommended)

Download the full Battrick-Helper.xls (72KB) suite, which contains the FA-Helper, PR-Helper, and Timetable-Helper spreadsheets. Downloaded 972 times since 2008-01-29.

Option 2

Download the spreadsheets individually:

• FA-Helper.xls (36KB). Downloaded 738 times since 2008-01-29.
• PR-Helper.xls (26KB). Downloaded 447 times since 2008-01-29.
• Timetable-Helper.xls (52KB). Downloaded 169 times since 2008-01-29.

Changelog

FA-Helper

Version 1.2.0

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

PR-Helper

Version 1.0.3

• Removed macros to ensure it worked with Open Office.

Timetable-Helper

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.

About

Version 0.2.1

• Tweaked answers so I could copy them to individual spreadsheets, and them still make sense.

Version 0.2.0

• Updated questions and answers.
• Renamed from Instructions to About.

Version 0.1.0

• First release.

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!

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.

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.

(Click to see the full size screenshot)