BOOM.
Spreadsheet done. decided cheapest titan was too cheap so upped the cost and rejigged the weapons.
If you want to play around with it, go ahead. green squares are ok to edit. (if you change the weapons too much, the bonuses like ignore cover might cease to be optimal.
Again: this is only a guidline, actual playtesting will trump this heavily. Likewise, CCW will get 1/2 the number of attacks they do in the sheet to account for the devasting effects of losing an assault.
....
Drat - it's too big. I'll try and sort out some sort of file hosting. I should probably actually write the list up aswell...
EDIT: sod it - if you want the excel file email me at
madd0ct0r@yahoo.co.uki'll try and get the actual army list up over the next few days.