DKRbella0814
Board Regular
- Joined
- Aug 10, 2008
- Messages
- 155
I have a spreadsheet which contains raw data of vendor/supplier performance by month (aug 2010-jan 2011) and on-time delivery
I have created a pivot table that looks like the following: Is there a way to calculate the % on-time deliveries and % late for each vendor within the pivot table. So, for example:
ACA Corporation should display 100% for on-time delivery (1/1) (ontime/total).
Akron Steel should display (7/12) = 58% on-time delivery and (5/12) = 42% late.
There has to be a way to do this, but I can't figure it out. Please help!
<table width="348" border="0" cellpadding="0" cellspacing="0"><col style="width: 122pt;" width="162"> <col style="width: 52pt;" width="69"> <col style="width: 62pt;" width="82"> <col style="width: 26pt;" width="35"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 122pt;" width="162" height="17">Count of ON TIME?2</td> <td class="xl26" style="width: 52pt;" width="69"> </td> <td class="xl26" style="width: 62pt;" width="82"> </td> <td class="xl28" style="width: 26pt;" width="35"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">VENDOR</td> <td class="xl25">MONTH</td> <td class="xl25">ON TIME?</td> <td class="xl28">Total</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ACA CORPORATION</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ACA CORPORATION Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AIRCRAFT WELDING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">AIRCRAFT WELDING Total</td> <td class="xl26"> </td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AKRON STEEL TREAT.</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">On Time</td> <td class="xl32" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">AKRON STEEL TREAT. Total</td> <td class="xl26"> </td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALLEN AIRCRAFT</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALLEN AIRCRAFT Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALT. METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">#REF!</td> <td class="xl32" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALT. METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMANDA BENT BOLT</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">AMANDA BENT BOLT Total</td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. BRAZING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. BRAZING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. JAPANNING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. JAPANNING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AVALON</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AVALON Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BAY STATE</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BAY STATE Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BODYCOAT</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BODYCOAT Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CLEVE. POLYMER</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">On Time</td> <td class="xl32" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CLEVE. POLYMER Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">COMM. ANOD.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">COMM. ANOD. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CONNECTICUT SPRING</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">CONNECTICUT SPRING Total</td> <td class="xl26"> </td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CURBELL</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CURBELL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">DIE-CUT PRODUCTS</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">DIE-CUT PRODUCTS Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">FLAME TREATING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">FLAME TREATING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">GEN. METAL H.T.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">GEN. METAL H.T. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">H&M METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">H&M METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HARBOR CAST</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HARBOR CAST Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HYPROLAP</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HYPROLAP Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">IMAGINEERING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">IMAGINEERING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">INDUCTION SERVICE</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">INDUCTION SERVICE Total</td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">J.S. AUTO</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">J.S. AUTO Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JERRY'S GRINDING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JERRY'S GRINDING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JFP TECH.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JFP TECH. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">M.T. HEAT TREAT</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">On Time</td> <td class="xl32" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">M.T. HEAT TREAT Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">MICROSHEEN</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">MICROSHEEN Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">PLANO MACHINE</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">PLANO MACHINE Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SABIC PLASTIC</td> <td class="xl25">Dec-10</td> <td class="xl25">#VALUE!</td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SABIC PLASTIC Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SPEE-D-METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SPEE-D-METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TABLOX</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TABLOX Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TAPER TOOL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TAPER TOOL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TECH HOUSE</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TECH HOUSE Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ULTRA LABS</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ULTRA LABS Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">UNITED PERFORM.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">UNITED PERFORM. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">WEBER TOOL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">WEBER TOOL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">YARDE METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">YARDE METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">(blank)</td> <td class="xl25"> </td> <td class="xl25">(blank)</td> <td class="xl28"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25"> Total</td> <td class="xl26"> </td> <td class="xl28"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">(blank) Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">Grand Total</td> <td class="xl33"> </td> <td class="xl33"> </td> <td class="xl30" align="right">219</td> </tr> </tbody></table>
I have created a pivot table that looks like the following: Is there a way to calculate the % on-time deliveries and % late for each vendor within the pivot table. So, for example:
ACA Corporation should display 100% for on-time delivery (1/1) (ontime/total).
Akron Steel should display (7/12) = 58% on-time delivery and (5/12) = 42% late.
There has to be a way to do this, but I can't figure it out. Please help!
<table width="348" border="0" cellpadding="0" cellspacing="0"><col style="width: 122pt;" width="162"> <col style="width: 52pt;" width="69"> <col style="width: 62pt;" width="82"> <col style="width: 26pt;" width="35"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 122pt;" width="162" height="17">Count of ON TIME?2</td> <td class="xl26" style="width: 52pt;" width="69"> </td> <td class="xl26" style="width: 62pt;" width="82"> </td> <td class="xl28" style="width: 26pt;" width="35"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">VENDOR</td> <td class="xl25">MONTH</td> <td class="xl25">ON TIME?</td> <td class="xl28">Total</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ACA CORPORATION</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ACA CORPORATION Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AIRCRAFT WELDING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">AIRCRAFT WELDING Total</td> <td class="xl26"> </td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AKRON STEEL TREAT.</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">On Time</td> <td class="xl32" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">AKRON STEEL TREAT. Total</td> <td class="xl26"> </td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALLEN AIRCRAFT</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALLEN AIRCRAFT Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">16</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALT. METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">#REF!</td> <td class="xl32" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ALT. METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMANDA BENT BOLT</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">AMANDA BENT BOLT Total</td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. BRAZING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. BRAZING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. JAPANNING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AMER. JAPANNING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">26</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AVALON</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">AVALON Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BAY STATE</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BAY STATE Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BODYCOAT</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">BODYCOAT Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CLEVE. POLYMER</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">On Time</td> <td class="xl32" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CLEVE. POLYMER Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">23</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">COMM. ANOD.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">COMM. ANOD. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CONNECTICUT SPRING</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">CONNECTICUT SPRING Total</td> <td class="xl26"> </td> <td class="xl28" align="right">4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CURBELL</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">CURBELL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">DIE-CUT PRODUCTS</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">DIE-CUT PRODUCTS Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">FLAME TREATING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">FLAME TREATING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">GEN. METAL H.T.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">GEN. METAL H.T. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">H&M METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">H&M METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HARBOR CAST</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HARBOR CAST Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HYPROLAP</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">HYPROLAP Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">IMAGINEERING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">IMAGINEERING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">INDUCTION SERVICE</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" colspan="2" style="height: 12.75pt;" height="17">INDUCTION SERVICE Total</td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">J.S. AUTO</td> <td class="xl25">Dec-10</td> <td class="xl25">On Time</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">J.S. AUTO Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JERRY'S GRINDING</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JERRY'S GRINDING Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JFP TECH.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">JFP TECH. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">M.T. HEAT TREAT</td> <td class="xl25">Dec-10</td> <td class="xl25">Late</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl31">On Time</td> <td class="xl32" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">M.T. HEAT TREAT Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">MICROSHEEN</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">MICROSHEEN Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">PLANO MACHINE</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">PLANO MACHINE Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SABIC PLASTIC</td> <td class="xl25">Dec-10</td> <td class="xl25">#VALUE!</td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SABIC PLASTIC Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SPEE-D-METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">SPEE-D-METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TABLOX</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TABLOX Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TAPER TOOL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TAPER TOOL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TECH HOUSE</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">TECH HOUSE Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ULTRA LABS</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">ULTRA LABS Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">UNITED PERFORM.</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">UNITED PERFORM. Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">WEBER TOOL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">WEBER TOOL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">YARDE METAL</td> <td class="xl25">Dec-10</td> <td class="xl25">#REF!</td> <td class="xl28" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25" colspan="2" style="">Dec-10 Total</td> <td class="xl28" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">YARDE METAL Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">(blank)</td> <td class="xl25"> </td> <td class="xl25">(blank)</td> <td class="xl28"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl25"> Total</td> <td class="xl26"> </td> <td class="xl28"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" height="17">(blank) Total</td> <td class="xl26"> </td> <td class="xl26"> </td> <td class="xl28"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17">Grand Total</td> <td class="xl33"> </td> <td class="xl33"> </td> <td class="xl30" align="right">219</td> </tr> </tbody></table>