Zain Saeed

The load combination file u have uploaded is missing on 4shared , the link u mentioned kindly mention it once again

Piles can be designed using a very popular software PCACOL 

Basement wall design spread sheet

BasementRetainingWall.xlsx

U can design the retaining walls easily with a software named as QuickRwall Or u can use the spreadsheet as attached

BasementRetainingWall.xlsx

For interpreting the ETABs Results see the 1st picture in Attaachment

As far as choosing a torsional constant for a member see the second doc. in attachmetns

Torsional Constant for Beams in ETABs .docx

WaoOO Its near my Town

Yup the Bridge undergone Servicebility Failure long time ago and the middle pier is settling from time to time as the scour is happening, when there  is good amount of water flowing around its pier.