Allocation Pivot Sample.xls - at www.WenzelAnalytics.com

Document Sample
Allocation Pivot Sample.xls - at www.WenzelAnalytics.com Powered By Docstoc
					                                             Cash      Money    Buying   Liquidation
Account ID   Description
                                          Balance Market Fund   Power     Value »


240068111    J DAVID MCINTOSH IRA            3.00      249.60     0.00     26,249.71
240088507    JOYCE A JOHNSON IRA             0.00        0.00     0.00          0.00
240087866    LILIAN H C KINGSTON TR FBO      0.00        9.62     9.62          9.62
240074351    MARK G BRECHEISEN ROTH IRA      0.00      297.94     0.00     58,337.44
240065342    TIMOTHY P KINGSTON              0.00        0.75     0.75          0.75
240063552    WENZEL ANALYTICS INC            0.00        0.00     0.00          0.00
240063594    WENZEL ANALYTICS INC            0.00        0.00     0.00          0.00
       No longer have to remove empty characters from columns C & D.
                      Margin      Balance

3.00           249.60 3.00                  252.60                     252.60
0.00             0.00                                                     -
0.00             9.62
0.00           297.94                                                     -
Tax Own        Owner
           Broker         Account   Symbol Investment Name            Inv TypeStrategy   Portfolio     Incptn
Post Own   ST Sara        7654321   AAUK     Anglo American           Stock Rationale    Global Investor 11/2/07
Post Own   ST Sara        7654321   ABB      ABB Ltd.'s               Stock Rationale    Global Investor 11/2/07
IRA Own    ST Sara IRA    1234567   AE       Adams Resources & Energy Stock Rationale                    7/20/06
                                                                                         Resource Scarcity
     Own
IRA-Roth   ST Sara Roth   1348923   AMX      America Movil            Stock Rationale    Global Investor 11/2/07
Post Own   ST Sara        7654321   ANDE     Andersons Inc (The)      Stock Rationale    Ag              11/1/07
Post Own   ST Sara        7654321   ASFI     Asta Funding, Inc.       Stock Statistical fgb              2/27/07
IRA Own    ST Sara IRA    1234567   AYE      Allegheny Energy, Inc. Stock Statistical fg                10/25/07
Post Own   ST Sara        7654321   BG       Bunge Ltd                Stock Rationale    Ag              11/1/07
Post Own   ST Sara        7654321   BHP      BHP Billiton Ltd         Stock Rationale                    11/1/07
                                                                                         Global Bull Market
Post Own   ST Sara        7654321   CALM     Cal-Maine Foods Inc      Stock Rationale    Ag              11/1/07
IRA Own    ST Sara IRA    1234567            Cash-Clare
                                    Cash Clare IRA ST IRA             Cash    Cash       Cash
     Own
IRA-Roth   ST Sara Roth   1348923   Cash Clare RothClare Roth
                                             Cash ST                  Cash    Cash       Cash
Post Own   ST Sara        7654321            Cash
                                    Cash Clare ST -Clare ST           Cash    Cash       Cash
Post Own   ST Sara        7654321   CCJ      Cameco Corp              Stock Tested SourceOI              4/27/06
IRA Own    ST Sara IRA    1234567   CEO      CNOOC, Ltd               Stock Rationale    Resource Scarcity3/1/07
IRA Own    ST Sara IRA    1234567   CIVVX    CIVVX - Casueway Intl Val Investor ationale
                                                                      Fund-ETFR          Intl            4/13/06
Post Own   ST Sara        7654321   CNH      CNH Global Nv            Stock Rationale    Ag              11/1/07
IRA Own    ST Sara IRA    1234567   CSX      CSX Corp                 Stock Tested SourceCyclicals       7/27/07
IRA Own    ST Sara IRA    1234567   DE       Deere & Co               Stock Tested SourceCyclicals       7/27/07
Post Own   ST Sara        7654321   DF       Dean Foods Co            Stock Rationale    Ag              11/1/07
IRA Own    ST Sara IRA    1234567   DVN      Devon Energy Corp        Stock Rationale    Resource Scarcity3/1/07
Post Own   ST Sara        7654321   ECA      Encana Corp              Stock Tested SourceOI              4/27/06
Post Own   ST Sara        7654321   EEM                                       R
                                             iShares MSCI Emerg MktFund-ETF ationale     Intl           12/21/06
IRA Own    ST Sara IRA    1234567   EGO      Eldorado Gold Corp       Stock Rationale    Resource Scarcity3/1/07
IRA Own    ST Sara IRA    1234567   ELP                               Stock Statistical fg
                                             Companhia Paranaense de Energi                             10/25/07
IRA Own    ST Sara IRA    1234567   EOC                               Stock
                                             Empresa Nacional de Electricid Statistical fg              10/25/07
     Own
IRA-Roth   ST Sara Roth   1348923   EWD                                       R
                                             iShares MSCI Sweden Fund-ETF ationale       Intl             3/1/07
Post Own   ST Sara        7654321   EWZ      iShares MSCI Brazil              R
                                                                      Fund-ETF ationale  Intl           12/21/06
Post Own   ST Sara        7654321   EXM      Excel Maritime Carriers Stock Rationale                     7/20/06
                                                                                         Resource Scarcity
IRA Own    ST Sara IRA    1234567   FCX      Freeport McMoran         Stock Tested SourceCyclicals       7/27/07
Post Own   ST Sara        7654321   FDG                               Stock Rationale
                                             Fording Canadian Coal Trust                 Resource Scarcity3/1/07
IRA Own    ST Sara IRA    1234567   FUL      H.B. Fuller Co           Stock Tested SourceMairs           9/25/06
Post Own   ST Sara        7654321   FXY      Japanese Yen Trust       Stock Rationale    Global Investor 11/2/07
Post Own   ST Sara        7654321   GLD      streetTRACKS Gold ETFStock Tested Source    OI              4/27/06
IRA Own    ST Sara IRA    1234567   GLW      Corning Inc              Stock Tested SourceMairs           9/25/06
Post Own   ST Sara        7654321   GMK      Gruma SAB De Cv          Stock Rationale    Ag              11/1/07
Post Own   ST Sara        7654321   HDB      HDFC Bank Ltd.           Stock Rationale                    11/1/07
                                                                                         Global Bull Market
Post Own   ST Sara        7654321   HOC      Holly Corporation        Stock Statistical fgb              2/27/07
IRA Own    ST Sara IRA    1234567   HON      Honeywell Intl           Stock Tested SourceCyclicals       7/27/07
Post Own   ST Sara        7654321   IBA      Industria Bachoco SA DeStock Rationale      Ag              11/1/07
Post Own   ST Sara        7654321   IEZ                               Fund-ETF
                                             iShares DJ US Oil Equip Index Rationale                     5/25/07
                                                                                         Resource Scarcity
Post Own   ST Sara        7654321   ILF      iShares S&P Latin America 40
                                                                      Fund-ETF ationale
                                                                              R          Intl           12/21/06
IRA Own    ST Sara IRA    1234567   IMO                               S
                                             Imperial Oil Limited (USA) tock Statistical fg             10/25/07
IRA Own    ST Sara IRA    1234567   JCI      Johnson Controls         Stock Tested SourceCyclicals       7/27/07
IRA Own    ST Sara IRA    1234567   JEC                               S
                                             Jacobs Engineering Group tock Rationale                     5/25/07
                                                                                         Resource Scarcity
Post Own   ST Sara        7654321   MGAFF.PK Mega Uranium             Stock Rationale    Uranium         1/24/07
Post Own   ST Sara        7654321   MGPI     MGP Ingredients Inc      Stock Rationale    Ag              11/1/07
IRA Own    ST Sara IRA    1234567   MMM      3M Company               Stock Tested SourceCyclicals       7/27/07
     Own
IRA-Roth   ST Sara Roth   1348923   MT       Arcelor Mittal           Stock Rationale    Global Investor 11/2/07
Post Own   ST Sara        7654321   MTL      Mechel Steel Group       Stock Rationale                    11/1/07
                                                                                         Global Bull Market
Post Own   ST Sara        7654321   MTW      Manitowoc Co Inc         Stock Rationale    Ag              11/1/07
Post Own   ST Sara        7654321   MVV                                       R
                                             ProShares Ultra Midcap Fund-ETF ationale    Timing Passive11/27/07
IRA Own    ST Sara IRA    1234567   MVV                                       R
                                             ProShares Ultra Midcap Fund-ETF ationale    Timing Passive11/27/07
IRA Own    ST Sara IRA    1234567   NRP      Natural Resource PartnersStock Rationale    Resource Scarcity3/1/07
IRA Own    ST Sara IRA    1234567   PCU      Southern Copper Corp Stock Rationale        Resource Scarcity3/1/07
Post Own   ST Sara        7654321   PKX      Posco                    Stock Rationale                    11/1/07
                                                                                         Global Bull Market
     Own
IRA-Roth   ST Sara Roth   1348923   POT      Potash Cp Saskatchewan   Stock Rationale    Global Investor 11/2/07
Post Own   ST Sara        7654321   PTG                               S
                                             Paragon Technologies Inc tock Rationale     Ag              11/1/07
Post Own   ST Sara        7654321   RIO                               Stock Rationale
                                             Companhia Vale Do Rio Doce                                  5/25/07
                                                                                         Resource Scarcity
Post Own   ST Sara        7654321   RRC      Range Resources Corp. Stock Statistical fgb                 2/27/07
IRA    Own   ST   Sara IRA   1234567                                  Stock Statistical fg
                                       RYAAY Ryanair Holdings plc (ADR)                                 10/25/07
Post   Own   ST   Sara       7654321   SBAC                           Stock
                                               SBA Communications CorporationStatistical fgb              2/27/07
Post   Own   ST   Sara       7654321   SFY     Swift Energy Company Stock Statistical fgb                 2/27/07
IRA    Own   ST   Sara IRA   1234567   SNP                            Stock Rationale
                                               China Petroleum & Chemical Corp            Resource Scarcity3/1/07
IRA    Own   ST   Sara IRA   1234567   SPIR    Spire Corp             Stock Rationale                     5/25/07
                                                                                          Resource Scarcity
Post   Own   ST   Sara       7654321   STP     Suntech Pwr Hldgs      Stock Tested Source OI               1/3/07
IRA    Own   ST   Sara IRA   1234567   TECH    Techne Corp            Stock Rationale     Original        9/25/06
Post   Own   ST   Sara       7654321   TEX     Terex Corp             Stock Rationale     Ag              11/1/07
IRA    Own   ST   Sara IRA   1234567   TLK                            Stock
                                               PT Telekomunikasi Indonesia (A Statistical fg            10/25/07
IRA    Own   ST   Sara IRA   1234567   TTC     Toro Co                Stock Tested Source Mairs           9/25/06
Post   Own   ST   Sara       7654321   TVCZF.PKTournigan Gold         Stock Rationale     Uranium         1/24/07
Post   Own   ST   Sara       7654321   UBB                            Stock Rationale
                                               Unibanco Uniao De Bancos                                   11/1/07
                                                                                          Global Bull Market
Post   Own   ST   Sara       7654321   UREGF.PK Energy Inc.
                                               UR                     Stock Rationale     Uranium         1/24/07
Post   Own   ST   Sara       7654321   URZ     Uranerz                Stock Rationale     Uranium         1/24/07
Post   Own   ST   Sara       7654321   VIP     Vimpel-Communications Stock Rationale                      11/1/07
                                                                                          Global Bull Market
Post   Own   ST   Sara       7654321   VLO     Valero Energy Corp     Stock Tested Source OI              4/27/06
Post   Own   ST   Sara       7654321   WBD                            Stock Rationale
                                               Wimm Bill Dann Foods OJSC                  Ag              11/1/07
Post   Own   ST   Sara       7654321   WLT     Walter Industries Inc  Stock Tested Source OI              12/5/06
IRA    Own   ST   Sara IRA   1234567   X       US Steel Corp          Stock Tested Source Cyclicals       7/27/07
Basis        Price     Shares SoldDate   Action    Sell Pr             Buy
                                                             Trial Shares Pr Trial Cost Cur Value Gain/Loss
  4,927.00    26.350     150                                      150      32.8 4,927.00  3,952.50    -975
  4,604.49    23.860     150                                      150 30.6499   4,604.49  3,579.00  -1,025
  7,830.95    27.650     200                                             39.10  7,820.00  5,530.00  -2,301
  5,309.30    54.940      85                                        85    62.38 5,309.30  4,669.90    -639
  3,839.87    45.540      80                                       80    47.91  3,839.87  3,643.20    -197
  6,634.83    20.400     200                                           33.1392      7.00  4,080.00  -2,555
  5,708.50    60.850     100                                      100     56.91 5,698.00  6,085.00     377
  3,822.18   118.730      35                                       35 109.01    3,822.18  4,155.55     333
  6,318.63    63.620      75                                        75   84.16  6,318.63  4,771.50  -1,547
  4,030.88    22.370     170                                     170     23.67  4,030.88  3,802.90    -228
  3,359.21                                                                                  3,359
    264.00                                                                                    264
 58,212.81                                                                                 58,213
  5,027.20    36.200     125                                             40.13     10.95  4,525.00    -502
  3,983.00   154.840      50                                              80.57     7.00  7,742.00   3,759
  3,345.50    15.560   250.54                                                             3,898.40     553
  3,959.19    61.410      60                                       60    65.87  3,959.19  3,684.60    -275
  4,635.60    43.710     100                                      100     46.03    4,610  4,371.00    -265
  4,207.00    87.860      70                                        35 119.55      4,191  6,150.20   1,943
  4,136.25    26.500     150                                     150     27.53  4,136.25  3,975.00    -161
  3,953.80    84.080      60                                              65.26     7.00  5,044.80   1,091
  5,077.95    63.370     100                                             50.67     10.95  6,337.00   1,259
 22,260.43   136.350     200                                            111.27      7.00 27,270.00   5,010
  4,080.93     5.980     700                                               5.84     7.00  4,186.00     105
  6,293.93    14.640     400                                      400     15.91 6,371.00  5,856.00    -438
  6,016.25    33.930     130                                      130     46.39 6,037.70  4,410.90  -1,605
  7,758.71    27.530     250             Off Ltr                          30.60     7.00  6,882.50    -876
 13,509.64    72.780     300                                             45.01      7.00 21,834.00   8,324
    497.55    27.100      50                                             10.05    513.45  1,355.00     857
  4,463.50    88.630      50                                        50    88.43    4,429  4,431.50     -32
  4,948.98    37.000     200                                              24.69     7.00  7,400.00   2,451
  5,079.50    19.570     250              Sell                           20.29      7.00  4,892.50    -187
  4,369.50    92.850      50                                        50    87.25 4,369.50  4,642.50     273
  4,741.95    86.700      75                                             63.08     10.95  6,502.50   1,761
  4,781.00    22.260     200              Sell                           23.87      7.00  4,452.00    -329
  3,911.80    11.980     275                                     275     14.20  3,911.80  3,294.50    -617
  4,747.05   123.460      35                                   35.00 135.43     4,747.05  4,321.10    -426
  5,500.80    43.750     100             Watch                           54.938     7.00  4,375.00  -1,126
  4,422.25    57.530      75                                        75    58.94    4,428  4,314.75    -108
  3,891.99    33.000     150                                     150     25.90  3,891.99  4,950.00   1,058
  4,406.19    58.701      80                                        80 54.9899  4,406.19  4,696.10     290
 16,391.99   225.630     100                                            163.85      7.00 22,563.00   6,171
  5,974.50    49.650     120                                      120     49.71 5,972.20  5,958.00     -17
  4,429.40    32.880     120                                        40 110.25      4,417  3,945.60    -484
  5,506.99    76.740     100                                      100 54.9999   5,506.99  7,674.00   2,167
  2,179.20     2.519     400                                              5.38            1,007.60  -1,172
  3,582.80     8.810     400                                     400      8.94  3,582.80  3,524.00     -59
  4,543.00    77.300      50                                        50    90.55    4,535  3,865.00    -678
  5,299.00    63.290      70                                        70     75.6 5,299.00  4,430.30    -869
  4,882.00    83.740      60                                        60   81.25  4,882.00  5,024.40     142
  3,772.49    38.210      85                                       85    44.30  3,772.49  3,247.85    -525
 31,062.88    65.200     400                                     400 77.6397 31,062.88 26,080.00    -4,983
 38,826.85    65.200     500                                     500 77.6397 38,826.85 32,600.00    -6,227
  4,414.20    28.500     140                                              63.04     7.00  3,990.00    -424
  4,193.20    88.030      60                                              70.54     7.00  5,281.80   1,089
  5,122.30   135.450      30                                        30 170.51   5,122.30  4,063.50  -1,059
  5,465.05   134.690      45                                        45 121.29   5,465.05  6,061.05     596
  3,831.95     7.240     500                                     500      7.65  3,831.95  3,620.00    -212
  4,341.43    29.000     200                                      100 43.3443   4,341.43  5,800.00   1,459
  6,308.60    50.290     200                                             31.508     7.00 10,058.00   3,749
6,142.71    33.160     130                 130     47.22    6,145.60    4,310.80   -1,832
5,570.67    27.770     200                       27.8184        7.00    5,554.00      -17
5,913.29    41.860     150                       39.3753        7.00    6,279.00      366
2,333.30   113.580      30   Watch   170           76.89        7.00    3,407.40    1,074
2,917.00    19.970     300                 300        9.7   2,917.00    5,991.00    3,074
6,952.93    56.450     200                       34.835                11,290.00    4,337
5,077.00    66.100     100                        50.70         7.00    6,610.00    1,533
3,674.75    54.270      50                 50     73.36     3,674.75    2,713.50     -961
5,091.59    37.950     100                 100     51.53    5,160.00    3,795.00   -1,297
5,018.20    45.500     120    Sell                41.76         7.00    5,460.00      442
1,553.40     1.160     600                          2.54                  696.00     -857
5,356.10   129.560      35                 35    152.83     5,356.10    4,534.60     -822
3,601.01     2.661   1,000                          3.57                2,660.70     -940
3,307.00     2.200   1,000                          3.30                2,200.00   -1,107
4,687.00    35.040     150                 150    31.20     4,687.00    5,256.00      569
4,820.70    53.660      75                        64.13        10.95    4,024.50     -796
3,427.30   118.500      30                 30    114.01     3,427.30    3,555.00      128
2,542.80    37.130     100                        46.55                 3,713.00    1,170
4,435.00   106.800      45                 45        97.6     4,399     4,806.00      371
                                                                                                             Wenzel
                                                                                                             Analytics
                                                                                                             Inc


Inv Type       (Multiple Items)
Own            (Multiple Items)                                  To create a pivot table, first create the source data sheet (see Master Workshe
Broker         (All)                                             Then go to Data, Pivot Table and Chart Report. Skip through the other option
Account        (All)                                             Drag the column labels to the data area, row area or column area and adjust t
Owner          (All)
Symbol         (All)
Investment Name(All)

                                     Data
Strategy          Portfolio          Shares Value    Percent
Rationale         Ag                   1,985 44,166 15.8%
                  Global Bull Market     385 27,971    7.9%
                  Global Investor        550 27,335    7.9%
                  Intl                 1,101 82,448    6.6%
                  Original               100   6,610   1.3%
                  Resource Scarcity    2,170 68,098 17.1%
                  Timing Passive         900 58,680    2.6%
                  Uranium              3,000   6,564   5.3%
Rationale Total                       10,191 321,873 64.5%
Statistical       fg                     980 30,416    7.9%
                  fgb                    850 30,346    6.6%
Statistical Total                      1,830 60,762 14.5%
Tested Source Cyclicals                  510 31,884    9.2%
                  Mairs                  570 14,805    3.9%
                  OI                     675 36,392    7.9%
Tested Source Total                    1,755 83,081 21.1%
Grand Total                           13,776 465,715 100.0%




                                                              Lee Wenzel
                                                              Wenzel Analytics, Inc.            Registered Investment Adviser
                                                              (952) 944-2699                     8666 Westwind Circle
                                                              Lee@WenzelAnalytics.com            Eden Prairie, MN 55344
                                                              www.wenzelanalytics.com          “An alternative to mutual funds.”
  C:\Docstoc\Working\pdf\7e56d321-d93e-4eea-8011-0b8a5faa8960.xls, Pivot, 12/29/2011. Page 7 of 8
                                                                                                                          Wenzel
                                                                                                                          Analytics
                                                                                                                          Inc



 a sheet (see Master Worksheet below).
Skip through the other options.
a or column area and adjust the fields for count, sum, average, etc.




                                                                           Lee Wenzel
                                                                           Wenzel Analytics, Inc.            Registered Investment Adviser
                                                                           (952) 944-2699                     8666 Westwind Circle
                                                                           Lee@WenzelAnalytics.com            Eden Prairie, MN 55344
                                                                           www.wenzelanalytics.com          “An alternative to mutual funds.”
               C:\Docstoc\Working\pdf\7e56d321-d93e-4eea-8011-0b8a5faa8960.xls, Pivot, 12/29/2011. Page 8 of 8

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:12/29/2011
language:
pages:8