Level indicator

[Greg Truby]

...I have won a lot of free lunches from IT guys who told me I couldn't do something in Excel.
-lenze

How do you ****** them into taking the bet? Obviously they don't know you're a MrExcel MVP!

 

[lenze]

How do you ****** them into taking the bet? Obviously they don't know you're a MrExcel MVP!

This was when I was working for the MT DOT (I'm semi retired now) and you can only imagine the egos of most state employees. And of course, none of them have even heard of MrExcel. I used to tell them, "If you can think it, I can do it". Drove them crazy

lenze

Edit in bold

 

[Greg Truby]

...I used to tell them, "If you can think, I can do it"...
-lenze

Perhaps you meant to write "...I used to tell them, "If you can think it, I can do it"..."? Or then again, maybe you didn't

 

[hatman]

Learn pivots. They are amazingly powerful. Once you get the knack, you'll wonder how you ever lived without them.

Okay Greg, you've got my attention: I've been at this for a while now. If you can dream it, I can do it in Excel. But I have never built a pivot table. Ever. I always saw them as a lame attempt to emulate some limited Access functionality within a spreadsheet. And quite frankly, my data is typically so sparse that Access would be too big of a hammer for the problem. Am I missing something?

 

[Greg Truby]

Paul,Perhaps I should have qualified that remark. If you work with any significant data extracts then you'll find Pivot Tables are fantastic. In my particular case we run all of our core transactions on a mainframe. Since I hate having to go hat-in-hand to IS and await for the Steering Committee to prioritize my project and then wait for our IS guys to design, code, document and now jump through all the Sarbanes Oxley BS, I long ago learned how to extract data sets extracted from the VSAM files and FTP them to my PC. So I frequently have thousands or tens of thousands of transactions to sort through. Here are a few columns and rows from something I'm working on today.<table width="400" border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2"> <tr valign="top" style="white-space:nowrap;"> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"CUST PO</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"XMIT ID</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"CUST NAME</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"ACCT NBR</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"INVC NO</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"INVC LN</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"ORDER NO</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"ORDER LN</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"TPM NBR</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"TPM LN </font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"1ST ALLOCATION DATE</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"QTY</font></th> <th bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Monospace" size="1"CARRIER</font></th> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="center" valign="bottom"><font face="Monospace" size="1">7DZ-27953A0224DK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00010</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00010</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00010</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-27955A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00020</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00020</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00020</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7SZ-27959A0224SK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00030</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00030</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00030</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">12</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7CZ-27961A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00040</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00040</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00040</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-27962A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00050</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00050</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00050</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-27963A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00060</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00060</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00060</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7CZ-27966A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00070</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00070</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00070</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7CZ-27967A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00080</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00080</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00080</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7AZ-27973A0224AK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-27982A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00130</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00130</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00130</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-27989A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00140</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00140</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00140</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-27990A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00150</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00150</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00150</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-27991A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00160</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00160</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00160</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7CZ-27994A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00170</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00170</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00170</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">7NZ-28000A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">482</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPU</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840014000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN445</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00180</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS27</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00180</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV96</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00180</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">FX</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">PNZ-60538A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">430</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPA</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840002000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN462</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00140</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS34</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00040</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTW03</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00020</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">PNZ-60541A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">430</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPA</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840002000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN462</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00180</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS34</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00070</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTW03</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00060</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">PNZ-60543A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">430</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPA</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840002000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN462</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00200</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS34</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTW03</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00080</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">PEZ-60544A0224EK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">430</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPA</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840002000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN462</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00210</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS34</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00100</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTW03</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">PHZ-60596A0224HK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">431</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPA</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840002000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN462</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00220</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS34</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00110</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTW03</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00100</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">4</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">PHZ-60597A0224HK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">431</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPA</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840002000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN462</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00230</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS34</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00120</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTW03</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00110</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">PNZ-60598A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">431</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SPA</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840002000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN462</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00240</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS34</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00130</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTW03</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00120</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Sat 02/25/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5BZ-90289A0224BK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00060</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00010</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00010</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5CZ-90291A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00070</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00020</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00020</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5CZ-90294A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00080</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00030</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00030</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5CZ-90296A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00040</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00040</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5DZ-90300A0224DK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00100</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00050</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00050</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5BZ-90301A0224BK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00110</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00060</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00060</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5AZ-90302A0224AK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00120</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00070</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00070</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5AZ-90303A0224AK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00130</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00080</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00080</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5DZ-90304A0224DK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00140</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00090</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5SZ-90305A0224SK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00150</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00100</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00100</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5BZ-90307A0224BK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00160</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00110</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00110</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5NZ-90308A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00170</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00120</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00120</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5NZ-90309A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00180</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00130</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00130</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5NZ-90311A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00190</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00140</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00140</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5AZ-90312A0224AK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00200</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00150</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00150</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5SZ-90313A0224SK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00210</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00160</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00160</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5SZ-90314A0224SK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00220</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00170</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00170</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5SZ-90315A0224SK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00230</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00180</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00180</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">2</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5NZ-90316A0224NK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00240</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00190</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00190</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5SZ-90317A0224SK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00250</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00200</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00200</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">8</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5BZ-90318A0224BK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00260</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00210</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00210</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5CZ-90320A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00270</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00220</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00220</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5CZ-90322A0224CK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00280</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00230</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00230</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5AZ-90325A0224AK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00300</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00250</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00250</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5BZ-90326A0224BK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00310</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00260</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00260</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5AZ-90327A0224AK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00320</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00270</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00270</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5SZ-90328A0224SK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00330</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00280</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00280</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5BZ-90329A0224BK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00340</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">S01PQS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00290</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00290</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr> <tr valign="top" style="white-space:nowrap;"> <td align="right" valign="bottom"><font face="Monospace" size="1">5BZ-90330A0224BK </font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">001</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">SCI</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">0840013000</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">I01WN508</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00350</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">QS24</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00360</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">VTV93</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">00360</font></td> <td align="center" valign="bottom"><font face="Monospace" size="1">Mon 02/27/06</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">1</font></td> <td align="right" valign="bottom"><font face="Monospace" size="1">5X</font></td> </tr></table>

 

[Greg Truby]

Say I wanted to know how many lines each customer ordered. It took me 27 seconds to create this...

Book10.xls
	A	B	C	D
3	Count of CUST PO
4	CUST NAME	Total
5	SPA	7
6	SPU	15
7	SCI	35
8	Grand Total	57
Sheet4

Maybe I want to know how many pieces each customer ordered...

Book10.xls
	A	B	C	D
3	Sum of QTY
4	CUST NAME	Total
5	SPA	15
6	SPU	34
7	SCI	55
8	Grand Total	104
Sheet4

That took eleven seconds to do...

Or how about pieces shipped on each carrier by day...

Book10.xls
	A	B	C	D
3	Sum of QTY	CARRIER
4	1ST ALLOCATION DATE	5X	FX	Grand Total
5	Sat 02/25/06	15	34	49
6	Mon 02/27/06	55		55
7	Grand Total	70	34	104
Sheet4

Nineteen seconds to do that.

By carrier by customer? Nine seconds later...

Book10.xls
	A	B	C	D	E	F	G
3	Sum of QTY	CARRIER	CUST NAME
4		5X		5X Total	FX	FX Total	Grand Total
5	1ST ALLOCATION DATE	SPA	SCI		SPU
6	Sat 02/25/06	15		15	34	34	49
7	Mon 02/27/06		55	55			55
8	Grand Total	15	55	70	34	34	104
Sheet4

As you can see, very quick to get whatever you want. And this just scratches the surface...

 

[hatman]

Okay, you are showing me just about what I was expecting: lots of data ==>> concise summaries/reports. In my life as an engineer, I rarely see data like, and when I do, my required manipulations don't really lend themselves to that type of drill-down.

Thanx for the insight, I will definitely keep it in my back pocket and try my hand at applying it if I ever see anything like that.

 

[lenze]

Bill agrees:

Pivot tables are the most powerful feature in Excel. A basic pivot table will allow you to summarize 50,000 rows of transactional data in seconds with just a few mouse clicks. White collar productivity would skyrocket if everyone knew how to use pivot tables.

lenze

 

[Greg Truby]

Bill agrees...
-lenze

Just a wee clarification -- that'd be our Bill; Bill Jelen not M$' Mr. Gates. And for those that don't know where that quote came from but now think pivots might be worth learning more about...some additional reading material can be purchased here.

 

[Domski]

I couldn't manage without pivot tables!!!

Maybe I'm doing something wrong but I tried summarising some pretty extensive data (50,000 employees worth of pay data for a year) on Monday using SUMPRODUCT and the formula took all afternoon to calculate for just one month (actually I went home and left it going so not sure how long it took).

I then had a moment of clarity during the night and realised how to do it using pivots and I had the other eleven months summarised an hour and a half after getting to work the following morning.

Learn them, they're legendary :wink: !!!