Battrick Line Up tool

ProPain · 21-10-2005, 21:36

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

ProPain · 21-10-2005, 22:28

removed a bug, uploaded correct sheet

Dell19 · 22-12-2005, 19:59

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.

21-10-2005, 21:36	#1
ProPain Customized Admin :) Join Date: Mar 2003 Location: sailing the seas of cheese. Posts: 5,852	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 __________________ I fed my Dog the American Dream Well, he rolled over and he started to scream He said, I dig the taste of salt but it don't keep me alive yeah, yeah

21-10-2005, 22:28	#2
ProPain Customized Admin :) Join Date: Mar 2003 Location: sailing the seas of cheese. Posts: 5,852	removed a bug, uploaded correct sheet __________________ I fed my Dog the American Dream Well, he rolled over and he started to scream He said, I dig the taste of salt but it don't keep me alive yeah, yeah

22-12-2005, 19:59	#3
Dell19 King Join Date: Apr 2004 Location: Grantham. Posts: 1,359	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.