Spreadsheet: louise_kitchen__22626__Power Mid Market 9-01 sent B
Sheet: Data

Mid-Marketer | Date Closed | Value | Month |  |  | Half deal
 |  |  | 2001-01-01 00:00:00 | 3410552 |  | Intra month- transaction does not count
 |  |  | 2001-02-01 00:00:00 | 6059835 |  | Orig counted---- transaction is not
 |  |  | 2001-03-01 00:00:00 | 7912146 |  | One third of a deal
 |  |  | 2001-04-01 00:00:00 | 3054171 | Bold | Deal needs to be booked
 |  |  | 2001-05-01 00:00:00 | 12936760
 |  |  | 2001-06-01 00:00:00 | 6397537
 |  |  | 2001-07-01 00:00:00
 |  |  | 2001-08-01 00:00:00
 |  |  | 2001-09-01 00:00:00
 |  |  | 2001-10-01 00:00:00
 |  |  | 2001-11-01 00:00:00
 |  |  | 2001-12-01 00:00:00
 |  |  | YTD Total
Northeast
Bernstein | 2001-01-04 00:00:00 | 50000
Bernstein | 2001-03-30 00:00:00 | 0
Bernstein | May | 125000
Hammond | 2001-02-01 00:00:00 | 70000
Hammond | 2001-03-30 00:00:00 | 500000
[NAME] | 2001-01-23 00:00:00 | 20000
[NAME] | 2001-01-30 00:00:00 | 0
[NAME] | 2001-02-07 00:00:00 | 2500000
[NAME] | 2001-03-28 00:00:00 | 3000000
[NAME] | 2001-07-02 00:00:00
[NAME] | 2001-08-27 00:00:00 | 60000
[NAME] | 2001-05-21 00:00:00 | 4000
[NAME] | 2001-05-29 00:00:00 | 3000
[NAME] | 2001-05-29 00:00:00 | 2500
[NAME] | 2001-05-29 00:00:00 | 2500
[NAME] | 2001-05-04 00:00:00 | 49899
[NAME] | 2001-06-13 00:00:00 | 21120
[NAME] | 2001-07-17 00:00:00
[NAME] | July | 10000
[NAME] | July | 10000
[NAME] | 2001-08-03 00:00:00 | 800
[NAME] | 2001-03-27 00:00:00 | 50000
[NAME] | 2001-04-17 00:00:00
[NAME] | April | 10000
Scheuer | 2001-01-04 00:00:00 | 85000
Scheuer | 2001-01-09 00:00:00 | 20000
Scheuer | 2001-01-12 00:00:00 | 0
Scheuer | 2001-01-31 00:00:00
Scheuer | 2001-01-31 00:00:00
Scheuer | 2001-02-05 00:00:00 | 211000
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-02-05 00:00:00
Scheuer | 2001-03-19 00:00:00 | 2500
Scheuer | 2001-03-19 00:00:00
Scheuer | 2001-03-19 00:00:00
Scheuer | 2001-03-19 00:00:00
Scheuer | 2001-03-19 00:00:00
Scheuer | June | 50000
Wheeler | 2001-05-21 00:00:00 | 4000
Wheeler | 2001-05-29 00:00:00 | 3000
Wheeler | 2001-05-29 00:00:00 | 2500
Wheeler | 2001-05-29 00:00:00 | 2500
Wheeler | 2001-05-31 00:00:00 | 6000
Wheeler | 2001-07-17 00:00:00
Wheeler | 2001-07-25 00:00:00 | 2000
Wheeler | 2001-07-25 00:00:00 | 2000
Wheeler | 2001-07-25 00:00:00 | 2000
Wheeler | 2001-07-25 00:00:00 | 2000
Wheeler | 2001-07-25 00:00:00 | 2000
Wood | 2001-01-17 00:00:00 | 0
Wood | 2001-01-17 00:00:00 | 0
Wood | 2001-01-29 00:00:00 | 0
Wood | 2001-02-07 00:00:00 | 2500000
Wood | 2001-03-15 00:00:00 | 75000
Wood | 2001-03-15 00:00:00 | 0
Wood | 2001-03-19 00:00:00 | 0
Wood | 2001-03-19 00:00:00 | 0
Wood | 2001-03-19 00:00:00 | 0
Wood | 2001-03-19 00:00:00 | 0
Wood | 2001-05-31 00:00:00 | 10000
Wood | 2001-06-14 00:00:00 | 0
Wood | 2001-06-14 00:00:00 | 15000
Wood | 2001-06-18 00:00:00 | 40000
Wood | 2001-06-26 00:00:00 | 200000
Wood | 2001-06-26 00:00:00 | 0
Wood | 2001-07-02 00:00:00
Wood | 2001-07-10 00:00:00 | 5000
Wood | 2001-07-10 00:00:00 | 0
Wood | 2001-08-07 00:00:00 | 25000
Wood | 2001-08-07 00:00:00 | 25000
Wood | 2001-08-17 00:00:00 | 4000
Wood | 2001-09-06 00:00:00 | 500
Wood | 2001-09-06 00:00:00 | 1000
Wood | 2001-09-09 00:00:00 | 15000
Wood | 2001-09-19 00:00:00 | 6000
Midwest
Compean | 2001-01-09 00:00:00 | 117112
Clynes | 2001-01-01 00:00:00 | 0
Clynes | 2001-01-09 00:00:00 | 117112
Clynes | 2001-04-01 00:00:00 | 134421
Clynes | 2001-04-01 00:00:00 | 134421
Clynes | 2001-04-01 00:00:00 | 134421
Clynes | 2001-03-29 00:00:00 | 600000
Clynes | 2001-04-04 00:00:00 | 32500
Clynes | 2001-05-30 00:00:00 | 0
Clynes | 2001-06-08 00:00:00 | 1499639
Clynes | 2001-07-16 00:00:00 | TBD
[NAME] | 2001-01-10 00:00:00 | 392500
[NAME] | 2001-01-10 00:00:00 | 0
[NAME] | 2001-02-22 00:00:00 | 102573
[NAME] | 2001-03-29 00:00:00 | 55183
[NAME] | 2001-04-11 00:00:00 | 11424
[NAME] | April | 28556
[NAME] | 2001-05-04 00:00:00 | 149698
[NAME] | June | 10000
[NAME] | 2001-07-17 00:00:00
Justice | 2001-05-01 00:00:00
Justice | 2001-05-01 00:00:00 | 45932
Kelly | 2001-01-08 00:00:00 | 30240
Kelly | 2001-01-08 00:00:00 | 0
Kelly | 2001-01-16 00:00:00
Kelly | April | 15000
Kelly | 2001-05-17 00:00:00 | 20000
Kelly | June | 10000
Kelly | June | 166667
Kelly | June | 333333
Sewell | 2001-01-18 00:00:00 | 4000
Sewell | January | 8000
Sewell | 2001-01-25 00:00:00 | 8000
Sewell | 2001-02-02 00:00:00 | 8800
Sewell | 2001-02-27 00:00:00 | 8660
Sewell | 2001-03-05 00:00:00 | 5500
Sewell | 2001-03-05 00:00:00
Sewell | 2001-03-05 00:00:00
Sewell | 2001-03-05 00:00:00
Sewell | 2001-03-05 00:00:00
Sewell | 2001-03-05 00:00:00
Sewell | 2001-03-09 00:00:00 | 8000
Sewell | 2001-03-15 00:00:00 | 8800
Sewell | 2001-03-29 00:00:00
Sewell | 2001-04-04 00:00:00 | 0
Sewell | 2001-04-05 00:00:00 | 4400
Sewell | 2001-04-05 00:00:00 | 82200
Sewell | 2001-04-26 00:00:00 | 0
Sewell | 2001-05-01 00:00:00 | 0
Sewell | 2001-05-01 00:00:00 | 68898
Sewell | 2001-05-09 00:00:00 | 48407
Sewell | 2001-05-15 00:00:00 | 0
Sewell | 2001-05-25 00:00:00 | 24384
Sewell | 2001-05-29 00:00:00 | 46800
Sewell | 2001-05-30 00:00:00 | 0
Sewell | 2001-06-01 00:00:00 | 0
Sewell | 2001-06-01 00:00:00 | 0
Sewell | 2001-06-01 00:00:00 | 0
Sewell | 2001-06-01 00:00:00 | 0
Sewell | 2001-06-01 00:00:00 | 0
Sewell | 2001-06-04 00:00:00 | 0
Sewell | 2001-06-04 00:00:00 | 0
Sewell | 2001-06-08 00:00:00 | 0
Sewell | 2001-06-18 00:00:00
Sewell | 2001-06-18 00:00:00
Sewell | 2001-06-19 00:00:00
Sewell | 2001-06-19 00:00:00
Sewell | 2001-06-19 00:00:00 | 5000
Sewell | 2001-07-03 00:00:00 | 0
Sewell | 2001-07-12 00:00:00 | 51000
Sewell | 2001-07-13 00:00:00
Sewell | 2001-07-13 00:00:00 | 5920
Sewell | 2001-07-25 00:00:00 | 5000
Sewell | 2001-08-13 00:00:00 | 3500
Sewell | 2001-08-13 00:00:00 | 0
Sewell | 2001-08-13 00:00:00 | 0
Sewell | 2001-08-14 00:00:00 | 0
Sewell | 2001-09-21 00:00:00 | 0
Sewell | 2001-09-21 00:00:00 | 0
Sewell | 2001-09-26 00:00:00 | 0
Simpson* | 2001-09-07 00:00:00 | 0
[NAME] | 2001-01-03 00:00:00 | 0
[NAME] | 2001-01-10 00:00:00 | 0
[NAME] | 2001-01-19 00:00:00 | 0
[NAME] | 2001-01-25 00:00:00 | 0
[NAME] | 2001-01-29 00:00:00 | 0
[NAME] | 2001-01-29 00:00:00 | 0
[NAME] | 2001-02-09 00:00:00 | 0
[NAME] | 2001-02-15 00:00:00 | 0
[NAME] | 2001-02-20 00:00:00 | 0
[NAME] | 2001-02-20 00:00:00 | 0
[NAME] | 2001-02-27 00:00:00 | 0
[NAME] | 2001-02-28 00:00:00 | 17600
[NAME] | 2001-03-07 00:00:00 | 4200
[NAME] | 2001-03-09 00:00:00 | 17600
[NAME] | 2001-03-09 00:00:00 | 12600
[NAME] | 2001-03-15 00:00:00
[NAME] | 2001-03-15 00:00:00 | 420
[NAME] | 2001-03-16 00:00:00
[NAME] | 2001-03-19 00:00:00
[NAME] | 2001-03-19 00:00:00 | 8000
[NAME] | 2001-03-20 00:00:00 | 17000
[NAME] | 2001-03-20 00:00:00 | 0
[NAME] | 2001-03-20 00:00:00 | 15702
[NAME] | 2001-03-22 00:00:00
[NAME] | 2001-03-22 00:00:00
[NAME] | 2001-03-22 00:00:00 | 8000
[NAME] | 2001-03-22 00:00:00
[NAME] | 2001-03-22 00:00:00
[NAME] | 2001-03-26 00:00:00 | 800
[NAME] | 2001-03-28 00:00:00 | 160
[NAME] | 2001-03-29 00:00:00 | 500
[NAME] | 2001-03-29 00:00:00
[NAME] | 2001-03-29 00:00:00 | 1080
[NAME] | 2001-03-29 00:00:00
[NAME] | 2001-03-29 00:00:00 | 4650
[NAME] | 2001-03-29 00:00:00
[NAME] | 2001-03-30 00:00:00 | 300
[NAME] | 2001-04-05 00:00:00
[NAME] | 2001-04-05 00:00:00 | 12600
[NAME] | 2001-04-06 00:00:00 | 18400
[NAME] | 2001-04-16 00:00:00 | 3280
[NAME] | 2001-04-17 00:00:00 | 13248
[NAME] | 2001-04-17 00:00:00 | 0
[NAME] | 2001-04-19 00:00:00 | 0
[NAME] | 2001-04-19 00:00:00 | 0
[NAME] | 2001-04-24 00:00:00 | 3500
[NAME] | 2001-04-03 00:00:00 | 100
[NAME] | 2001-04-23 00:00:00
[NAME] | 2001-04-23 00:00:00
[NAME] | 2001-04-26 00:00:00 | 0
[NAME] | 2001-04-26 00:00:00 | 3700
[NAME] | 2001-05-04 00:00:00 | 4200
[NAME] | 2001-05-15 00:00:00 | 0
[NAME] | 2001-05-15 00:00:00 | 64800
[NAME] | 2001-05-16 00:00:00 | 0
[NAME] | 2001-05-16 00:00:00 | 5200
[NAME] | 2001-05-18 00:00:00 | 5400
[NAME] | 2001-05-21 00:00:00 | 500
[NAME] | 2001-05-30 00:00:00
[NAME] | 2001-05-31 00:00:00 | 4000
[NAME] | 2001-05-31 00:00:00 | 0
[NAME] | 2001-05-31 00:00:00 | 1176
[NAME] | 2001-06-01 00:00:00 | 36868
[NAME] | 2001-06-01 00:00:00 | 1528
[NAME] | 2001-06-01 00:00:00 | 4850
[NAME] | 2001-06-01 00:00:00 | 0
[NAME] | 2001-06-01 00:00:00 | 4790
[NAME] | 2001-06-04 00:00:00 | 5010
[NAME] | 2001-06-04 00:00:00 | 1497
[NAME] | 2001-06-05 00:00:00 | 8800
[NAME] | 2001-06-07 00:00:00 | 3800
[NAME] | 2001-06-08 00:00:00 | 1667
[NAME] | 2001-06-08 00:00:00 | 600
[NAME] | 2001-06-12 00:00:00 | 3680
[NAME] | 2001-06-27 00:00:00 | 2080
[NAME] | 2001-06-27 00:00:00 | 5920
[NAME] | 2001-06-28 00:00:00 | 3600
[NAME] | 2001-06-28 00:00:00 | 17400
[NAME] | 2001-07-05 00:00:00
[NAME] | 2001-07-05 00:00:00
[NAME] | 2001-07-09 00:00:00 | 8200
[NAME] | 2001-07-11 00:00:00 | 3100
[NAME] | 2001-07-17 00:00:00
[NAME] | 2001-07-17 00:00:00 | 4600
[NAME] | 2001-07-17 00:00:00 | 23400
[NAME] | 2001-07-25 00:00:00
[NAME] | 2001-07-25 00:00:00 | 9400
[NAME] | 2001-07-25 00:00:00 | 5300
[NAME] | 2001-07-20 00:00:00 | 2200
[NAME] | 2001-07-20 00:00:00 | 0
[NAME] | 2001-08-01 00:00:00 | 0
[NAME] | 2001-08-01 00:00:00 | 0
[NAME] | 2001-08-01 00:00:00 | 5210
[NAME] | 2001-08-13 00:00:00 | 3000
[NAME] | 2001-08-14 00:00:00 | 0
[NAME] | 2001-08-15 00:00:00 | 5100
[NAME] | 2001-08-15 00:00:00 | 5100
[NAME] | 2001-08-15 00:00:00 | 0
[NAME] | 2001-08-20 00:00:00 | 2520
[NAME] | 2001-08-21 00:00:00 | 3100
[NAME] | 2001-08-21 00:00:00 | 0
[NAME] | 2001-08-22 00:00:00 | 0
[NAME] | 2001-08-23 00:00:00 | 3360
[NAME] | 2001-08-23 00:00:00 | 2100
[NAME] | 2001-08-28 00:00:00 | 3000
[NAME] | 2001-08-30 00:00:00 | 0
[NAME] | 2001-08-31 00:00:00 | 900
[NAME] | 2001-09-14 00:00:00 | 0
[NAME] | 2001-09-17 00:00:00 | 0
[NAME] | 2001-09-18 00:00:00 | 0
[NAME] | 2001-09-27 00:00:00 | 8800
Wang | 2001-03-28 00:00:00 | 50000
Valdes* | 2001-02-27 00:00:00 | 0
Valdes* | 2001-03-19 00:00:00 | 0
Valdes* | 2001-05-15 00:00:00 | 0
Valdes* | 2001-05-31 00:00:00 | 0
Valdes* | 2001-07-26 00:00:00 | 0
Valdes* | 2001-08-14 00:00:00 | 0
Valdes* | 2001-08-14 00:00:00 | 0
Valdes* | 2001-09-18 00:00:00 | 0
[NAME]* | 2001-01-30 00:00:00 | 0
[NAME]* | 2001-02-07 00:00:00 | 0
[NAME]* | 2001-02-21 00:00:00 | 0
[NAME]* | 2001-02-22 00:00:00 | 0
[NAME]* | 2001-04-01 00:00:00 | 0
[NAME]* | 2001-04-10 00:00:00 | 0
ERCOT
Ahn | 2001-03-30 00:00:00 | 3482
Ahn | 2001-03-30 00:00:00 | 8669
Curry | 2001-01-12 00:00:00
Curry | 2001-02-02 00:00:00 | 8195
Curry | 2001-02-02 00:00:00 | 8195
Curry | 2001-02-09 00:00:00 | 2500
Curry | 2001-02-14 00:00:00 | 8712
Curry | 2001-02-23 00:00:00 | 0
Curry | 2001-03-06 00:00:00 | 175000
Curry | April | 0
Curry | May | 2000000
Curry | May | 176866
Curry | May | 0
Curry | July | 0
Curry | July | 10000
Curry | 2001-07-25 00:00:00 | 40000
Curry | 2001-08-29 00:00:00 | 18000000
[NAME] | May | 0
Jester | July | 10000
Southeast
Acevedo | 2001-05-04 00:00:00 | 3000
Acevedo | June | 2200
Acevedo | July
Acevedo | 2001-08-20 00:00:00 | 2280
Acevedo | 2001-08-20 00:00:00 | 1520
Kroll | 2001-01-31 00:00:00
Kroll | Q2 | 7260000
Kroll | 2001-07-16 00:00:00 | 1689520
Schultz | 2001-01-30 00:00:00 | 50000
Braddock | 2001-04-09 00:00:00 | 100000
Braddock | 2001-04-09 00:00:00 | 20000
Braddock | 2001-04-11 00:00:00 | 40000
Braddock | 2001-05-15 00:00:00 | 10000
Braddock | 2001-06-19 00:00:00 | 13200
Braddock | 2001-06-20 00:00:00 | 5000
Braddock | June | 15288
Braddock | 2001-07-03 00:00:00 | 23632
Braddock | July | 3500
Braddock | 2001-09-19 00:00:00 | 12600
Braddock | 2001-09-21 00:00:00 | 1000
[NAME] | 2001-02-27 00:00:00 | 0
[NAME] | 2001-03-26 00:00:00
[NAME] | May | 0
Rorschach | 2001-03-23 00:00:00 | 95000
Rorschach | 2001-04-17 00:00:00 | 16800
Rorschach | 2001-04-17 00:00:00 | 35200
Rorschach | May | 87600
Rorschach | July
Wagner | 2001-02-14 00:00:00 | 156800
Wagner | 2001-02-14 00:00:00 | 156800
Wagner | 2001-03-25 00:00:00
Johnston | 2001-08-13 00:00:00 | 5000
Piazze | 2001-08-13 00:00:00 | 5000
Development
Booth | January | 836196
Booth | March | 333334
Booth | March | 250000
Booth | April | 50000
Booth | May | 1367000
Booth | May | 97500
Booth | June | 1750000
Booth | June | 112500
Booth | 2001-07-24 00:00:00
Booth | 2001-07-31 00:00:00 | 2000000
Booth | July | 550000
Healy | May | 1367000
[NAME] | March | 384000
[NAME] | April | 2100000
Mitro | January | 836196
Mitro | February | 150000
Mitro | March | 333333
Mitro | March | 250000
Mitro | April | 50000
Mitro | June | 1750000
[NAME] | February | 150000
Tapscott | March | 1300000
Walker | January | 836196
Walker | March | 333333
Virgo | May | 97500
Virgo | June | 112500
Virgo | 2001-07-24 00:00:00
 |  |  |  |  |  | Development No. of Transactions
 |  |  |  |  | Jan | 1 | 2508588
Mid-Marketer | No. of transactions | Value |  |  | Feb | 1 | 300000
Bernstein | 2 | 175000 |  |  | Mar | 4
[NAME] | 3 | 60000 |  |  | Apr | 2
Hammond | 2 |  |  |  | May | 2
[NAME] | 5 |  |  |  | Jun | 2 | 3725000
Marks | 0 | 0 |  |  | Jul | 3
[NAME] | 5 |  |  |  | Aug | 0 | 0
Scheuer | 22 |  |  |  | Sep | 0 | 0
Wheeler | 8.5 |  |  |  | Oct
Wood | 25 |  |  |  | Nov
Northeast Total |  |  |  |  | Dec
 |  |  |  |  | Total
Clynes | 9
Compean | 0.5 | 117112
[NAME] | 6
Justice | 1
Kelly | 7
[NAME] | 6 | 0
Sewell | 44.5
Simpson | 1 | 0
[NAME] | 92.5
Valdes | 8 | 0
Wang | 1 | 50000
Midwest Total
Acevedo | 3
Braddock | 11
[NAME] | 0 | 0
Kroll | 3
Podurgiel | 3 | 0
Rorschach | 4
Schultz | 1 | 50000
Wagner | 3 | 313600
Johnston | 0.5 | 5000
Piazze | 0.5 | 5000
Southeast Total
Ahn | 2
Curry | 12.5
[NAME] | 0.5 | 0
Tingleaf | 0 | 0
Jester | 0 | 10000
ERCOT Total
Booth | 6.16
Healy | 0.5
[NAME] | 2
Mitro | 2.66
[NAME] | 0.5
Tapscott | 1
Virgo | 1.5
Walker | 0.66
Development Total
 | YTD
 |  |  | Quarterly Transactions
Month | No. of Transactions | Quarter
2001-01-01 00:00:00 | 32
2001-02-01 00:00:00 | 36
2001-03-01 00:00:00 | 57 | Q1-01
2001-04-01 00:00:00 | 32
2001-05-01 00:00:00 | 34
2001-06-01 00:00:00 | 37 | Q2-01
2001-07-01 00:00:00 | 35
2001-08-01 00:00:00 | 30
2001-09-01 00:00:00 | 15 | Q3-01
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00 |  | Q4-01
YTD Total