Skip to content

{ Tag Archives } Battrick-Helper

Battrick Developments

As it’s now officially been made public that I’ve been made in to a developer for Battrick, I can now share my thoughts on developments for my own spreadsheets and tools.

Due to the obvious conflict of interest, unfortunately I will have to stop any further development of the tools that I have created. I may do the odd bug-fix to keep them working the way they were originally intended, but I won’t be updating any formulae and here’s why: if I’ve seen a formula in the Battrick code and I know the version in my spreadsheet is wrong, then a) I can’t update the spreadsheet because that would give the formulae away, and b) I can’t release new versions of the spreadsheet knowing that the formulae are incorrect, as I would feel that is also wrong.

I hope that the tools and spreadsheets that have been created are stable enough not to need any critical fixes, and I will continue to host them on this site until such time that they are no longer being downloaded.

In terms of my role at Battrick, my focus will be on the quality of the front-end code, which means most of the stuff I do, you shouldn’t really notice, unless it’s a new feature. I aim to improve the accessibility and usability of the site, and generally make it a nicer experience. The easier it is to use the site, the less it gets in the way of playing the game. I won’t have much, if any, role of developing the “game”, only the “site” which serves the game.

In terms of game development ideas, reporting of bugs etc, I ask that you use the existing features within Battrick to do so, rather than posting them here.

Also tagged , , , , ,
2008 02 19 Battrick Comments (0)

Jargon’s Battrick Resources

Introduction

Battrick is an online cricket management game. Through playing it, I have found it useful to develop some tools to assist me in making decisions, and I’ve decided to share them so others can use them too.

I try to make the tools as user-friendly, intuitive and as easy to use as possible - the end user should be spending more time playing Battrick than working out how my resources work!

These tools will always be free to use. If you consider them worthy of a donation, however small, then it will be gratefully accepted, using the Donation link in the sidebar.

Everything you find here is under a Creative Commons License.

And finally, this site was also referred to as Gazza’s Battrick Resources - don’t worry, you’re at the right place.

Regards,
Gary aka Jargon.

Also tagged , , , , , ,
2008 01 29 Me Comments (0)

Battrick-Helper

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 979 times since 2008-01-29.

Option 2

Download the spreadsheets individually:

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
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!
FA-Helper screenshot

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.
PR-Helper screenshot

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.
Timetable-Helper screenshot

(Click to see the full size screenshot)

Also tagged , , ,
2008 01 29 Me Comments (0)