Battrick Line Up tool
 

Made an excel sheet to assist with lineups

You can import your squad in it and the excel sheet calculates best line ups for batters, bowlers and fielders.

Some instructions:
- Do not leave more than 5 empty lines at the top of the player import sheet
- If you copy the 'squad details' line make sure that it start with the entire word 'Squad' otherwise the sheet will think its a player name.
- Export button exports data to other excel sheets.
- On the 'prefs' tab you can adjust the formula for the dif positions and calculate by pressing the line up button.

Working on several more features, after that I'll rewrite it to a stand alone app, but for now excel is the easiest way to do this for me, lacking dr. A's 1337 progging skill ;)



Download Attachment: [img]icon_paperclip.gif[/img] Bat_lineup2.zip
41.39KB

removed a bug, uploaded correct sheet

You might want to check out this spreadsheet:

http://virtualdesigns.co.uk/battrick/index.htm

:)

I don't actually use it anymore since I'm too used to hattrick programs where everything is done for you and training doesn't seem to be quite so important in battrick.