21-10-2005, 21:36 | #1 |
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 |
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 |
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. |