Loan-Pivot-Table-Test-Macro-Need

Document Sample
Loan-Pivot-Table-Test-Macro-Need Powered By Docstoc
					REG LOANS TAG         Acct Nbr     Acct Short Nm   Bank Balance
PART LOANS                   80    NAME 1          x
PART LOANS                  500    NAME 2          x
PART LOANS                23481    NAME 3          x
Sum of All PART LOANS                              xx
REG LOANS                      2   NAME 4          x
REG LOANS                      4   NAME 5          x
REG LOANS                      5   NAME 6          x
REG LOANS                      6   NAME 7          x
REG LOANS                      8   NAME 8          x
REG LOANS                      9   NAME 9          x
Sum of All REG LOANS                               xx
Sum of All Bank Balance                            xxxx
       PIVOT TABLE INFORMATION
                                                                                                                      Total Code
                                                                                                                       Including
        REG LOANS TAG Acct Nbr       Note Nbr    Acct Short Nm                    Orig Note Amt      Bank Balance     Exceptions
        PART LOANS              80   6900001090 NAME 1                                          -               -          50
        PART LOANS              80   6900001660 NAME 1                                          -               -          50
        PART LOANS              80   6900001820 NAME 1                                          -               -          50
        PART LOANS              80   6900002080 NAME 1                                          -               -          50
        PART LOANS             500   6510357160 NAME 2                                          -          3,203.50        51
        PART LOANS             500   6513529620 NAME 2                                          -         22,051.09        51
        PART LOANS             500   6513529880 NAME 2                                          -          5,147.85        51
        PART LOANS             500   6513538040 NAME 2                                          -         37,733.20        51
        PART LOANS             500   6513548850 NAME 2                                          -         11,618.91        51
        PART LOANS             500   6513554450 NAME 2                                          -         32,060.17        51
        PART LOANS             500   6513554600 NAME 2                                          -         28,160.96        51
        PART LOANS             500   6513572430 NAME 2                                          -          6,462.68        51
        PART LOANS             500   6513593060 NAME 2                                          -         13,925.95        51
        PART LOANS             500   6513598010 NAME 2                                          -         15,870.41        51
        PART LOANS             500   6513598270 NAME 2                                          -          2,527.96        51
        PART LOANS             500   6513603870 NAME 2                                          -         13,573.94        51
        PART LOANS             500   6513627890 NAME 2                                          -         29,093.23        51
        PART LOANS             500   6513684300 NAME 2                                          -         83,250.00        51
        PART LOANS             500   6513687030 NAME 2                                          -         75,285.00        51
        PART LOANS             500   6513688770 NAME 2                                          -         21,150.00        51
        PART LOANS             500   6513691720 NAME 2                                          -         98,460.00        51
        PART LOANS             500   6700028320 NAME 2                                          -         17,451.96        51
        PART LOANS             500   6700028400 NAME 2                                          -          8,619.32        51
        PART LOANS             500   6700030530 NAME 2                                          -         61,874.11        51
        PART LOANS             500   6700031370 NAME 2                                          -          7,801.51        51
        PART LOANS             500   6700031520 NAME 2                                          -         31,260.94        51
        PART LOANS             500   6700032440 NAME 2                                          -         61,062.65        51
        PART LOANS             500   6700033760 NAME 2                                          -         56,465.12        51
        PART LOANS             500   6700035330 NAME 2                                          -          7,224.75        51
        PART LOANS             500   6700035900 NAME 2                                          -          7,726.97        51
        PART LOANS             500   6700037230 NAME 2                                          -         12,943.27        51
        PART LOANS             500   6700039210 NAME 2                                          -         13,403.71        51
        PART LOANS             500   6700040770 NAME 2                                          -         22,203.85        51
        PART LOANS             500   6700043090 NAME 2                                          -          8,020.67        51
        PART LOANS             500   6700043580 NAME 2                                          -         13,132.66        51
        PART LOANS             500   6700049600 NAME 2                                          -         29,400.98        51
        PART LOANS             500   6700049940 NAME 2                                          -         19,187.46        51
        PART LOANS             500   6700050250 NAME 2                                          -         13,205.40        51
        PART LOANS             500   6700051080 NAME 2                                          -         22,205.34        51
11/24/2011 8:26 AM                    30f66693-f5ba-468a-a1c8-f56597a430b0.xls   Master - Modified                             Page 2 of 6
        PART LOANS          500   6700053140 NAME 2                                          -      79,469.04   51
        PART LOANS          500   6700053550 NAME 2                                          -      44,425.43   51
        PART LOANS          500   6700054050 NAME 2                                          -      23,645.05   51
        PART LOANS          500   6700054880 NAME 2                                          -      73,620.57   51
        PART LOANS          500   6700056520 NAME 2                                          -       8,380.62   51
        PART LOANS          500   6700056780 NAME 2                                          -      28,198.48   51
        PART LOANS          500   6700056860 NAME 2                                          -      44,183.56   51
        PART LOANS          500   6700057100 NAME 2                                          -      68,856.35   51
        PART LOANS          500   6700061300 NAME 2                                          -      45,575.38   51
        PART LOANS          500   6700062700 NAME 2                                          -      42,300.00   51
        PART LOANS          500   6700064780 NAME 2                                          -      17,436.59   51
        PART LOANS          500   6700070470 NAME 2                                          -      60,750.00   51
        PART LOANS          500   6700070880 NAME 2                                          -      26,076.60   51
        PART LOANS        23481     20002089 NAME 3                                          -            -     53
        PART LOANS        23481    250001586 NAME 3                                          -            -     58
        PART LOANS        23481   5072357104 NAME 3                                          -      14,808.77   58
        PART LOANS        24141    390000067 NAME 4                                          -            -     58
        PART LOANS        24141    390000083 NAME 4                                          -            -     58
        PART LOANS        24141    390000109 NAME 4                                          -            -     58
        PART LOANS        24141    390000125 NAME 4                                          -            -     58
        PART LOANS        24141    390000141 NAME 4                                          -            -     58
        PART LOANS        24141    390000166 NAME 4                                          -            -     58
        PART LOANS        24141    390000182 NAME 4                                          -            -     58
        PART LOANS        24141    390000208 NAME 4                                          -            -     58
        PART LOANS        24141    390000224 NAME 4                                          -            -     58
        PART LOANS        24141   3900000421 NAME 4                                          -            -     58
        PART LOANS      8100615        20521 NAME 5                                          -      42,794.57   58
        PART LOANS   7057700001       111861 NAME 6                                          -            -     58
        REG LOANS             2   6600315000 NAME 7                                  350,000.00           -     20
        REG LOANS             2   6700063870 NAME 7                                  600,000.00    559,955.50   10
        REG LOANS             4   6513590580 NAME 8                                    18,000.00    11,366.15   10
        REG LOANS             4   6513666400 NAME 8                                     6,500.00     6,500.00   10
        REG LOANS             4   6513675070 NAME 8                                     4,404.22     4,404.22   10
        REG LOANS             4   6513677880 NAME 8                                    15,800.00    15,800.00   10
        REG LOANS             4   6513679290 NAME 8                                     3,000.00     3,000.00   10
        REG LOANS             4   6513680830 NAME 8                                     3,300.00     3,300.00   10
        REG LOANS             4   6513692300 NAME 8                                    36,900.00    36,900.00   10
        REG LOANS             4   6700064600 NAME 8                                  178,000.00    172,429.82   30
        REG LOANS             5   6513692970 NAME 9                                  427,500.00    427,500.00   10
        REG LOANS             5   6600266410 NAME 9                                    69,123.04          -     20
        REG LOANS             5   6600292230 NAME 9                                  270,000.00           -     20
        REG LOANS             5   6600314680 NAME 9                                2,500,000.00    109,161.68   20
        REG LOANS             6   6513681900 NAME 10                                 201,855.48    195,264.99   10
11/24/2011 8:26 AM                 30f66693-f5ba-468a-a1c8-f56597a430b0.xls   Master - Modified                      Page 3 of 6
        REG LOANS     6   6513687110 NAME 10                                   24,162.00      24,162.00   10
        REG LOANS     8   6513637040 NAME 11                                 124,659.80       97,055.23   10
        REG LOANS     8   6513657740 NAME 11                                 170,000.00      138,131.18   10
        REG LOANS     8   6513665740 NAME 11                                   80,000.00      69,574.44   10
        REG LOANS     8   6600311610 NAME 11                                 200,000.00             -     20
        REG LOANS     8   6700028650 NAME 11                                 123,760.00       96,193.68   30
        REG LOANS     8   6700057440 NAME 11                                   62,988.37      22,956.19   30
        REG LOANS     8   6700060800 NAME 11                                 250,000.00      240,000.00   30
        REG LOANS     8   6700060980 NAME 11                                 250,000.00      240,580.92   30
        REG LOANS     8   6700068900 NAME 11                                 284,000.00      284,000.00   30
        REG LOANS     9   6700042000 NAME 12                                 120,000.00      113,317.67   30
        REG LOANS     9   6700042260 NAME 12                                   92,500.00      88,530.47   30
        REG LOANS    10   6600303200 NAME 13                                 100,000.00             -     20
        REG LOANS    10   6600303460 NAME 13                                 100,000.00             -     20
        REG LOANS    10   6700030950 NAME 13                                 178,000.00       24,956.05   30
        REG LOANS    12   6513554600 NAME 14                                 650,000.00       31,289.95   10
        REG LOANS    12   6513688360 NAME 14                                 498,242.00      498,242.00   30
        REG LOANS    12   6600314500 NAME 14                                 825,000.00      279,065.68   32
        REG LOANS    12   6700062620 NAME 14                               1,350,000.00    1,320,681.75   30
        REG LOANS    15   6513665900 NAME 15                                 139,869.00      139,869.00   10
        REG LOANS    15   6513676480 NAME 15                                   11,000.00      11,000.00   10
        REG LOANS    15   6600300800 NAME 15                                   45,000.00       1,700.00   20
        REG LOANS    15   6600305930 NAME 15                                   42,600.00      41,724.09   20
        REG LOANS    15   6700060150 NAME 15                                   77,100.00      73,659.13   30
        REG LOANS    16   6600311460 NAME 16                                 300,000.00             -     20
        REG LOANS    16   6700048120 NAME 16                                 375,000.00      241,790.32   30
        REG LOANS    17   6513678610 NAME 17                                   13,000.00      13,000.00   10
        REG LOANS    17   6600299000 NAME 17                                   30,000.00      30,000.00   20
        REG LOANS    17   6700048460 NAME 17                                 236,287.00      201,991.58   30
        REG LOANS    17   6700053140 NAME 17                                 852,000.00       88,164.07   30
        REG LOANS    19   6700035900 NAME 18                                   95,980.00       8,585.52   30
        REG LOANS    20   6700048610 NAME 19                                 164,000.00      150,347.55   30
        REG LOANS    23   6700000590 NAME 20                                   30,425.36         742.78   30
        REG LOANS    25   6700039470 NAME 21                                   34,815.93      13,288.24   30
        REG LOANS    26   6513575320 NAME 22                                   15,750.00       7,746.57   10
        REG LOANS    26   6600311950 NAME 22                                 120,000.00      105,735.08   20
        REG LOANS    28   6513684140 NAME 23                                 743,000.00      552,000.00   10
        REG LOANS    28   6513684300 NAME 23                                 925,000.00       92,500.00   10
        REG LOANS    28   6600312780 NAME 23                                 700,000.00             -     20
        REG LOANS    30   6513685210 NAME 24                                   28,500.00      28,500.00   10
        REG LOANS    30   6600309990 NAME 24                                   15,000.00       7,500.00   20
        REG LOANS    32   6513691720 NAME 25                               1,094,000.00      109,400.00   10
        REG LOANS    32   6600313510 NAME 25                                 700,000.00      642,000.00   20
11/24/2011 8:26 AM         30f66693-f5ba-468a-a1c8-f56597a430b0.xls   Master - Modified                        Page 4 of 6
        REG LOANS    32   6700042910 NAME 25                                 212,075.93      172,337.49   30
        REG LOANS    32   6700066270 NAME 25                                 222,000.00      222,000.00   30
        REG LOANS    33   6600307260 NAME 26                                   60,000.00      34,456.41   20
        REG LOANS    33   6700064110 NAME 26                                   22,805.35      16,451.88   30
        REG LOANS    34   6700063610 NAME 27                                 129,773.59      124,588.74   30
        REG LOANS    36   6600311950 NAME 28                                 250,000.00       79,000.00   20
        REG LOANS    36   6700029640 NAME 28                                 265,000.00      205,023.26   30
        REG LOANS    38   6513671920 NAME 29                                   56,000.00      56,000.00   10
        REG LOANS    38   6513689500 NAME 29                                    5,000.00       5,000.00   10
        REG LOANS    39   6513591570 NAME 30                                   23,912.38       6,001.54   10
        REG LOANS    39   6600296030 NAME 30                                   50,000.00      23,217.90   20
        REG LOANS    39   6700067830 NAME 30                                    9,482.40       6,746.06   30
        REG LOANS    41   6513665580 NAME 31                                 142,014.97      142,014.97   10
        REG LOANS    41   6600300230 NAME 31                                 340,000.00      335,020.00   20
        REG LOANS    41   6600310050 NAME 31                                   25,000.00      25,000.00   20
        REG LOANS    41   6700050900 NAME 31                               2,429,000.00    2,289,626.89   30
        REG LOANS    42   6513557590 NAME 32                                   73,000.00      17,372.35   10
        REG LOANS    42   6513607830 NAME 32                                   50,000.00      15,040.94   10
        REG LOANS    42   6513684710 NAME 32                                 194,625.00      194,625.00   10
        REG LOANS    42   6600313100 NAME 32                                 200,000.00      187,176.55   20
        REG LOANS    42   6700031370 NAME 32                                 270,000.00        8,668.34   30
        REG LOANS    42   6700031520 NAME 32                                 390,000.00       34,734.38   30
        REG LOANS    44   6510357160 NAME 33                                 103,000.00        1,657.68   10
        REG LOANS    44   6513662360 NAME 33                                   91,508.41      86,566.79   10
        REG LOANS    44   6600247030 NAME 33                                 250,000.00      191,547.60   20
        REG LOANS    44   6600298270 NAME 33                                 115,407.59      104,275.06   20
        REG LOANS    47   6513572430 NAME 34                                 150,000.00        7,180.76   10
        REG LOANS    47   6513622920 NAME 34                                   18,000.00       4,903.36   10
        REG LOANS    47   6513632090 NAME 34                                   45,000.00      24,525.00   10
        REG LOANS    47   6513673090 NAME 34                                   50,000.00      43,264.58   10
        REG LOANS    47   6513686120 NAME 34                                 156,113.86      115,113.86   10
        REG LOANS    47   6600313930 NAME 34                                   30,000.00      25,000.00   20
        REG LOANS    47   6600314190 NAME 34                                 200,000.00      123,513.58   20
        REG LOANS    47   6700043090 NAME 34                                 100,000.00        8,911.86   30
        REG LOANS    47   6700058430 NAME 34                                 117,312.86      117,312.86   30
        REG LOANS    47   6700062880 NAME 34                                   80,000.00      80,000.00   30
        REG LOANS    48   6500067670 NAME 35                                   17,016.00       1,317.18   10
        REG LOANS    48   6513580840 NAME 35                                 287,784.00      136,674.42   10
        REG LOANS    48   6513585970 NAME 35                                   60,675.00      26,682.96   10
        REG LOANS    48   6513660950 NAME 35                                   83,798.62      76,465.09   10
        REG LOANS    48   6513674730 NAME 35                                   32,500.00      28,691.65   10
        REG LOANS    48   6513689190 NAME 35                                 351,400.00      351,400.00   10
        REG LOANS    48   6600315340 NAME 35                                 700,000.00      692,535.52   20
11/24/2011 8:26 AM         30f66693-f5ba-468a-a1c8-f56597a430b0.xls   Master - Modified                        Page 5 of 6
       REG LOANS       48   6700044160   NAME 35                                62,644.63          49,727.32    30
       REG LOANS       48   6700063530   NAME 35                               110,000.00         110,000.00    30
       REG LOANS       48   6700063790   NAME 35                               240,000.00         240,000.00    30
       REG LOANS       48   6700066500   NAME 35                               297,660.35         283,855.01    30
       REG LOANS       48   6700066760   NAME 35                                78,152.76          74,528.07    30
       REG LOANS       48   6700066920   NAME 35                                95,158.85          95,158.85    30
       REG LOANS       48   6900001090   NAME 35                                13,921.00                -      10
       REG LOANS       50   6600311790   NAME 36                               120,000.00         120,000.00    20
       REG LOANS       51   6513656000   NAME 37                               810,021.00         744,526.43    10
       REG LOANS       51   6513686380   NAME 37                               500,000.00         470,000.00    10
       REG LOANS       51   6600312110   NAME 37                               675,000.00         529,000.00    20
       REG LOANS       52   6700047960   NAME 38                               400,000.00         370,802.23    30
       REG LOANS       53   6513585480   NAME 39                                31,000.00           6,680.41    10
       REG LOANS       53   6513595870   NAME 39                                54,531.00          34,040.85    10
       REG LOANS       53   6513631750   NAME 39                                27,000.00          17,362.40    10
       REG LOANS       53   6513687860   NAME 39                                12,000.00          12,000.00    10
       REG LOANS       53   6600312520   NAME 39                               190,000.00         180,097.09    20
       REG LOANS       53   6700056110   NAME 39                                67,942.39          58,524.45    30
       REG LOANS       54   6700043820   NAME 40                               200,000.00         190,122.16    30

                                                                        $   29,400,260.14   $   19,242,917.79




11/24/2011   8:26 AM         30f66693-f5ba-468a-a1c8-f56597a430b0.xls   Master - Modified                            Page 6 of 6

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:11/24/2011
language:English
pages:6