Spreadsheet: 50508d1249968573-vlookup-sum-up-all-the-data-final-ur
Sheet: Format

Bid Pattern for T-bill Auction for SBP Auction -30July09 |  |  |  |  |  | Target amount | PKR 45MMM | Date:
 |  |  |  |  |  | Accepted | 0 | 1000
 |  |  |  |  |  | maturity | 19000
 |  |  |  |  |  | Citi Accepted
Bank | Tenor | Amount | Cumm | Price | Rate
MCB | 3mnth | 50 | 50 | 0.1118735010672652 | 97.49
MCB | 3mnth | 50 | 100 | 0.1123307345096425 | 97.48 |  | HBL
MCB | 3mnth | 50 | 150 | 0.1127880617723648 | 97.47 |  | CITI
MCB | 3mnth | 50 | 200 | 0.1132454828843098 | 97.46 |  | JSBL
MCB | 3mnth | 50 | 250 | 0.1137029978743673 | 97.45 |  | MCB
HBL | 3mnth | 300 | 550 | 0.1150761064023226 | 97.42 |  | NBP
HBL | 3mnth | 25 | 575 | 0.1159919820084087 | 97.4 |  | STC
HBL | 3mnth | 75 | 650 | 0.1164500608745397 | 97.39 |  | UBL
HBL | 3mnth | 75 | 725 | 0.1169082338213576 | 97.38 | 17700 |  | 0
HBL | 3mnth | 50 | 775 | 0.117366500877849 | 97.37
SCB | 3mnth | 500 | 1275 | 0.117366500877849 | 97.37
SCB | 3mnth | 500 | 1775 | 0.121954353860389 | 97.27
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A |  |  | 1000
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 | 3mnth |  | 1775 | #N/A
 |  |  | 1775
 |  | 1775
Bank | Tenor | Amount | Cumm | Price | Rate
HBL | 6mnth | 25 | 25 | 0.1142544697665723 | 94.61
HBL | 6mnth | 25 | 50 | 0.1151510538736934 | 94.57
HBL | 6mnth | 25 | 75 | 0.1169464993679197 | 94.49 |  | HBL | 1500
HBL | 6mnth | 2550 | 2625 | 0.1173958358778937 | 94.47 |  | CITI | 1000
UBL | 6mnth | 1000 | 3625 | 0.1176205754863387 | 94.46 |  | JSBL | 8100
NBP | 6mnth | 2000 | 5625 | 0.1176205754863387 | 94.46 |  | MCB | 4325
HBL | 6mnth | 2500 | 8125 | 0.1178453626839013 | 94.45 |  | NBP | 0
NIB | 6mnth | 50 | 8175 | 0.1178453626839013 | 94.45 |  | POI | 0
UBL | 6mnth | 1000 | 9175 | 0.1180701974856994 | 94.44 |  | STC | 0
NIB | 6mnth | 1000 | 10175 | 0.1185200099625008 | 94.42 |  | UBL | 1000
UBL | 6mnth | 1000 | 11175 | 0.1189700130378093 | 94.4 |  |  | 15925
NIB | 6mnth | 1000 | 12175 | 0.1189700130378093 | 94.4
CITI | 6mnth | 750 | 12925 | 0.1191950860877654 | 94.39
UBL | 6mnth | 1500 | 14425 | 0.1194202068327943 | 94.38
UBL | 6mnth | 1000 | 15425 | 0.1198705914687262 | 94.36
SCB | 6mnth | 500 | 15925 | 0.1223511236773838 | 94.25
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
 | 6mnth |  | 15925 | #N/A
Total |  | 15925