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: icon_paperclip.gif Bat_lineup2.zip (http://www.civ3duelzone.com/forum/uploaded/ProPain/20051021222712_Bat_lineup2.zip)
41.39KB
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: icon_paperclip.gif Bat_lineup2.zip (http://www.civ3duelzone.com/forum/uploaded/ProPain/20051021222712_Bat_lineup2.zip)
41.39KB