Spreadsheet: 149525d1334001415-if-formula-and-blank-cell-issues-inventory-analysis-report
Sheet: April 2012

PART | [NAME] | ON HAND | COUNT | RESULT | RECOUNT | ACTION | ADJ. COST | TOTAL COUNTED
96400307 | 10/10 Dbl Open End Wrench Set | 3 | 3 |  |  |  |  | ERRORS
96400313 | 10/11 Dbl Open End Wrench Set | 1 | 1 |  |  |  |  | ACCURACY PCT.
96400306 | 10/12 Dbl Open End Wrench Set | 0 | 0 |  |  |  |  | ADJ. COST TOTAL
96838130 | 10/5.5-24  Open End Wrench Set | 0 | 0
96400311 | 10/7 Dbl Open End Wrench Set | 2 | 2
96400305 | 10/8 Dbl Open End Wrench Set | 1 | 1
96400312 | 10/9 Dbl Open End Wrench Set | 1 | 1
70010010 | 100/10 250mm Ribbed ColdChisel | 0 | 0
70010012 | 100/12 300mm Ribbed ColdChisel | 0 | 0
70010004 | 100/4 100mm Ribbed Cold Chisel | 13 | 13
70010005 | 100/5 125mm Ribbed Cold Chisel | 0 | 0
70010006 | 100/6 150mm Ribbed Cold Chisel | 1 | 1
70010008 | 100/8 200mm Ribbed Cold Chisel | 1 | 1
97840011 | 1000N 94Pc Tool Set for VW | 0 | 0
40701010 | 1003 10mm Bi-Square Wrench | 12 | 12
3840022 | 1007 1/2Dr Diesel Inj Skt 22mm | 1 | 1
8520001 | 1009S 10mm Bit For 1009DC | 5 | 0 |  | 0 |  | -24.4 | No history of sales or receipt dating to 7.1.10
70030006 | 101/6 150mm Ribbed CrossCut Ch | 2 | 2
70030008 | 101/8 200mm Ribbed CrossCut Ch | 0 | 0
40031011 | 10-10X11Double Open End Wrench | 4 | 4
40031012 | 10-10X12 Double Open End Wrenc | 4 | 4
40031013 | 10-10X13 Double Open End Wrenc | 28 | 28
40031113 | 10-11X13 Double Open End Wrenc | 9 | 9
40031213 | 10-12X13 Double Open End Wrenc | 3 | 2 |  | 3
40031214 | 10-12X14 Double Open End Wrenc | 9 | 9
40031314 | 10-13X14 Double Open End Wrenc | 5 | 5
40031315 | 10-13X15 Double Open End Wrenc | 10 | 10
40031316 | 10-13X16 Double Open End Wrenc | 3 | 3
40031317 | 10-13X17 Double Open End Wrenc | 9 | 9
40031415 | 10-14X15 Double Open End Wrenc | 11 | 11
40031417 | 10-14X17 Double Open End Wrenc | 3 | 2 |  | 3
74620002 | 1015    Oil Filter Claw | 1 | 1
40031617 | 10-16X17 Double Open End Wrenc | 6 | 6
40031618 | 10-16X18 Double Open End Wrenc | 2 | 2
40031719 | 10-17X19 Double Open End Wrenc | 13 | 13
40031819 | 10-18X19 Double Open End Wrenc | 4 | 4
40031821 | 10-18X21 Double Open End Wrenc | 11 | 11
40031922 | 10-19X22 Double Open End Wrenc | 3 | 3
40031924 | 10-19X24 Double Open End Wrenc | 7 | 7
70020002 | 102/125 Cold Chisel | 14 | 14
70020003 | 102/150 Cold Chisel | 15 | 15
70020004 | 102/175 Cold Chisel | 5 | 5
70020005 | 102/200 Cold Chisel | 0 | 0
70020007 | 102/250 Cold Chisel | 3 | 3
70020008 | 102/300 Cold Chisel | 2 | 2
97842011 | 1020N 58Pc VW Body Tool Set | 0 | 0
40032022 | 10-20X22 Double Open End Wrenc | 13 | 13
40032123 | 10-21X23 Double Open End Wrenc | 3 | 3
40032124 | 10-21X24 Double Open End Wrenc | 5 | 5
40032224 | 10-22X24 Double Open End Wrenc | 0 | 0
41110013 | 1023 13mm Inject Pump Wrench | 2 | 2
40032426 | 10-24X26 Double Open End Wrenc | 8 | 8
40032427 | 10-24X27 Double Open End Wrenc | 5 | 5
98812201 | 102-5/6D Chisels-Pins-PunchSet | 1 | 1
98812202 | 102-5/6PC Chisels-Pin-PunchSet | 0 | 0
40032528 | 10-25X28 Double Open End Wrenc | 17 | 17
76500013 | 1026/3 Belt/Pulley BracingTool | 0 | 0
40032730 | 10-27X30 Double Open End Wrenc | 0 | 0
40032732 | 10-27X32 Double Open End Wrenc | 5 | 5
74030000 | 1029  Brake Adjusting Lever | 0 | 0
70040003 | 103/150 Cross Cut Chisel | 4 | 4
70040004 | 103/175 Cross Cut Chisel | 6 | 6
70040005 | 103/200 Cross Cut Chisel | 6 | 6
70040007 | 103/250 Cross Cut Chisel | 0 | 0
40033032 | 10-30X32 Double Open End Wrenc | 14 | 14
40033034 | 10-30X34 Double Open End Wrenc | 8 | 8
40033036 | 10-30X36 Double Open End Wrenc | 0 | 17 |  | 0
40033236 | 10-32X36  Double Open End Wren | 17 | 17
40033436 | 10-34X36  Double Open End Wren | 3 | 3
98742711 | 10350N [NAME] | 2 | 2
74270001 | 10351/1 Draw Handle | 1 | 1
74270002 | 10351/2 Guide Handle | 5 | 5
74270006 | 10351/3 Guide Handle | 0 | 0
96742711 | 10351N Windshield Removal Set | 2 | 2
74280005 | 10352-1  Double Suction Lifer | 1 | 1
74280001 | 10352-2 Double | 0 | 0
74270003 | 10354 Tension Strap w/ Ratchet | 2 | 2
74270004 | 10355 Wire Insert Probe | 1 | 1
74270005 | 10356 [NAME] | 1 | 1
79270015 | 10356R SingleEdge Razor Blades | 11 | 11
40033641 | 10-36X41  Double Open End Wren | 5 | 5
70060007 | 104/120X2 Drift Pin | 6 | 6
70060010 | 104/120X3 Drift Pin | 7 | 7
70060002 | 104/120X4 Drift Pin | 3 | 3
70060008 | 104/120X5 Drift Pin | 6 | 6
70060003 | 104/120X6 Drift Pin | 3 | 3
70060009 | 104/120X8 Drift Pin | 3 | 3
70060006 | 104/175X8 Drift Pin | 0 | 0
3140208 | 1040  1/2Dr Univ SPlug Skt | 3 | 3
74410001 | 1041 Lube Service Wrench | 3 | 3
40034146 | 10-41X46  Double Open End Wren | 17 | 17
2230016 | 1042 3/8Dr Tube SPlug Skt 5/8 | 11 | 11
2230014 | 1043 3/8Dr Tube SPlug Skt 12mm | 0 | 0
2231014 | 1043/1 3/8Dr Tube SPlug S 12mm | 0 | 0
44041721 | 1044-17 X 21 Oil Service Wrenc | 0 | 0
96700601 | 104-5/6D Pin And Punch Set | 1 | 1
96700602 | 104-5/6Pc Pin And Punch Set | 0 | 0
74400001 | 1046-10 Oil Service Wrench | 1 | 1
2151204 | 1049/4 3/8Dr [NAME] Hex 4mm | 3 | 3
2151007 | 1049/7 3/8Dr [NAME] Hex 7mm | 6 | 6
2151009 | 1049/9  3/8 Dr 9mm Inhex Skt | 1 | 1
2160008 | 1049X-M8  3/8Dr XZN Skt | 0 | 0
40030405 | 10-4X5 Double Open End Wrench | 28 | 28
40035507 | 10-5.5X7 Double Open End Wrenc | 33 | 33
70050001 | 105/100X10 Center Punch | 8 | 8
70050005 | 105/120X10 Center Punch | 4 | 4
70050002 | 105/120X12 Center Punch | 11 | 11
70050003 | 105/130X12 Center Punch | 8 | 8
70050004 | 105/150X14 Center Punch | 3 | 3
73210001 | 10503 345mm Slot Screwdriver | 1 | 1
73010001 | 10506 350mm Slot Screwdriver | 5 | 5
73101003 | 10507N KK-3 Extra Long Ball E | 3 | 3
73101005 | 10507N KK-5 Extra Long Ball En | 7 | 7
3120022 | 1051-22 1/2Dr Cutaway Skt 22mm | 0 | 0
73210102 | 10518 515mm Slot Screwdriver | 4 | 4
3151410 | 1054/10 1/2Dr Lng Hex Skt 10mm | 0 | 0
3151412 | 1054/12 1/2Dr Lng Hex Skt 12mm | 3 | 3
3150713 | 1054/13  1/2Dr Long Hex 13mm | 1 | 1
96838164 | 1054/2054/6 1/2 Dr Lg Hex Set | 2 | 1 |  | 2
96838163 | 1054/2054TX 1/2 Dr [NAME] | 0 | 0
3151805 | 1054/5  1/2Dr Ex Long Hex 5mm | 1 | 1
3150706 | 1054/6  1/2Dr Long Hex 6mm | 2 | 2
3152206 | 1054/6L  1/2Dr Ex Long Hex 6mm | 3 | 3
3151007 | 1054/7 1/2Dr Med Long Hex Skt | 5 | 5
3151408 | 1054/8 1/2Dr Long Hex Skt 8mm | 5 | 5
3151208 | 1054/8K 1/2Dr Long Hex Skt 8mm | 2 | 2
73113001 | 10541-1 Eng Wood Screwdriver | 0 | 0
73113002 | 10541-2 Eng Wood Screwdriver | 5 | 5
73113003 | 10541-3 Eng Wood Screwdriver | 3 | 3
73113004 | 10541-4 Eng Wood Screwdriver | 2 | 2
73113005 | 10541-5 Eng Wood Screwdriver | 0 | 0
73113006 | 10541-6 Eng Wood Screwdriver | 0 | 0
73272001 | 10546-1 Offset SlotScrewdriver | 8 | 8
73272002 | 10546-2 Offset SlotScrewdriver | 11 | 2 |  | 11
73272003 | 10546-3 Offset SlotScrewdriver | 10 | 10
73272004 | 10546-4 Offset SlotScrewdriver | 6 | 6
73272005 | 10546-5 Offset SlotScrewdriver | 2 | 2
73272006 | 10546-6 Offset SlotScrewdriver | 4 | 4
3310005 | 1054KK-5 1/2Dr BallTip Hex 5mm | 3 | 3
3310008 | 1054KK-8 1/2Dr BallTip Hex 8mm | 1 | 1
3200030 | 1054KKTX-T30 1/2Dr BallTip Trx | 0 | 0
3200040 | 1054KKTX-T40 1/2Dr BallTip Trx | 0 | 0
3200045 | 1054KKTX-T45 1/2Dr BallTip Trx | 0 | 0
3200050 | 1054KKTX-T50 1/2Dr BallTip Trx | 3 | 3
3361410 | 1054KKX-M10 1/2Dr Lg Ball XZN | 0 | 0
3361412 | 1054KKX-M12 1/2Dr Lg Ball XZN | 0 | 0
3361408 | 1054KKX-M8  1/2Dr Lg  Ball XZN | 0 | 0
96031301 | 1054TX/4PC 1/2Dr Long Torx Set | 0 | 0
3131230 | 1054TX-T30  1/2Dr Long Torx | 4 | 4
3131240 | 1054TX-T40  1/2Dr Long Torx | 2 | 2
3131245 | 1054TX-T45  1/2Dr Long Torx | 6 | 6
3131455 | 1054TX-T55  1/2Dr Long Torx | 3 | 3
3131070 | 1054TX-T70  1/2Dr Long Torx | 4 | 4
3160808 | 1054X-M8 1/2 Dr Long XZN Skt | 7 | 6 |  | 7
73282012 | 10551-1X2 Offset PhilScrewdvr | 4 | 4
73282023 | 10551-2X3 Offset PhilScrewdvr | 4 | 4
73282034 | 10551-3X4 Offset PhilScrewdvr | 9 | 9
77450001 | 10554 EURO Voltage Tester | 1 | 1
74170000 | 10556 Circuit Tester 6-24 V | 3 | 3
3320010 | 1056-10  1/2Dr Square Skt 10mm | 4 | 4
3320008 | 1056-8  1/2Dr Square Skt 8mm | 4 | 4
44730810 | 1058 8X10Sq Oil Service Wrench | 5 | 5
96700711 | 105-8/6K Pin And Punch Set | 1 | 1
76294003 | 10599/2 Wheel Weight Pliers | 0 | 0
96582601 | 1060/4 Accessory Set for 730/2 | 0 | 0
3820017 | 1061-17  1/2 Dr [NAME] | 0 | 0
76413021 | 10613/1 Brake Spring Pliers | 0 | 0
76413022 | 10613/2 Brake Spring Pliers | 0 | 0
76413001 | 10613-210 Brake Spring Pliers | 12 | 12
76413002 | 10613-330 Brake Spring Pliers | 2 | 2
76460000 | 10614 Hose Clip Pliers | 3 | 3
76460013 | 10615/1 [NAME] CLIC | 6 | 6
3830027 | 1062-27 1/2Dr Cutaway Skt 27mm | 3 | 3
76460012 | 10623/1 Hose Clip Pliers | 1 | 1
76540001 | 10623-2 Remote [NAME] Plier | 1 | 1
76414001 | 10624 Brake Spring Pliers | 1 | 1
76540002 | 10625 Ear Clamp Pincers | 1 | 1
76540003 | 10625/2 Hose Clamp Pliers | 2 | 2
76530001 | 10626 Spark Plug Boot Pliers | 0 | 0
76530004 | 10627 Heater Plug Skt Pliers | 3 | 3
40810017 | 1063/17 Valve Adjustment Wrenc | 0 | 0
76490001 | 10642-1 Set Off Pliers | 1 | 1
76490002 | 10642-2 Set Off Pliers | 1 | 1
76590001 | 10643-1 Punch Pliers | 1 | 1
76590002 | 10643-2 Punch Pliers | 2 | 2
76590003 | 10643-3 Punch Pliers | 2 | 2
76472000 | 10652 Door Spring Pliers | 4 | 4
43190001 | 10667 Oil Service Wrench | 1 | 1
72060001 | 10670/215 3 Square Eng Scraper | 0 | 0
72060002 | 10670/230 3 Square Eng Scraper | 0 | 0
72060003 | 10670/255 3 Square Eng Scraper | 0 | 0
72060004 | 10670/275 3 Square Eng Scraper | 0 | 0
72060005 | 10670/300 3 Square Eng Scraper | 2 | 1 |  | 2
72060101 | 10670-2K 215mm Square Eng. Scr | 1 | 1
72050004 | 10672/20X305 Flat Eng Scraper | 0 | 2 |  | 2 |  | 6.14 | No history of sales or receipt dating to 7.1.10
72050005 | 10672/25X365 [NAME] | 5 | 5
72080001 | 10676/56X10X230 3 Side Scraper | 0 | 0
72080002 | 10676/69X11X255 3Side Scraper | 0 | 0
72080003 | 10676/85X12X305 3Side Scraper | 3 | 3
74620011 | 1068 Air Brake Filter Claw | 2 | 2
43330011 | 1069-11 No Longer Available | 0 | 0
43330007 | 1069-7 Brake Bleeding Wrench | 0 | 0
40030607 | 10-6X7 Double Open End Wrench | 7 | 7
43910045 | 1070 VW Door Hinge Torx Tool | 1 | 1
96431204 | 10750/11 [NAME] | 0 | 0
96431201 | 10750/7 [NAME] | 0 | 0
96838168 | 10750/8ES Tubular Wrench Set | 0 | 0
48010006 | 10750-1/2-6 Tommy Bar | 1 | 1
48010007 | 10750-1/2-7 Tommy Bar | 1 | 1
48010008 | 10750-1/2-8 Tommy Bar | 1 | 1
43321011 | 10750-10X11 Tubular Box Wrench | 1 | 1
43321213 | 10750-12X13 [NAME] | 7 | 7
43321415 | 10750-14X15 Tubular Box Wrench | 9 | 9
43321617 | 10750-16X17 Tubular Box Wrench | 54 | 54
43321719 | 10750-17X19 [NAME] | 64 | 64
43321819 | 10750-18X19 [NAME] | 1 | 1
43322022 | 10750-20X22 Tubular Box Wrench | 0 | 0
43322123 | 10750-21X23 Tubular Box Wrench | 3 | 3
43322426 | 10750-24X26 Tubular Box Wrench | 0 | 0
43322427 | 10750-24X27 [NAME] | 5 | 5
43323032 | 10750-30X32 [NAME] | 2 | 2
43323236 | 10750-32X36 [NAME] | 0 | 0
43323641 | 10750-36X41 Tubular Box Wrench | 0 | 0
43324146 | 10750-41X46 Tubular Box Wrench | 0 | 0
43324650 | 10750-46X50 [NAME] | 0 | 0
43325560 | 10750-55X60 Tubular Box Wrench | 0 | 0
43320607 | 10750-6X7 Tubular Box Wrench | 0 | 0
43320809 | 10750-8X9 Tubular Box Wrench | 0 | 0
96838169 | 10751/8ES Tubular Wrench Set | 0 | 0
43201011 | 10751-10X11 Tubular Box Wrench | 8 | 8
43201213 | 10751-12X13 [NAME] | 4 | 4
43201415 | 10751-14X15 Tubular Box Wrench | 0 | 0
43201617 | 10751-16X17 Tubular Box Wrench | 0 | 0
43201819 | 10751-18X19 [NAME] | 0 | 0
43202022 | 10751-20X22 Tubular Box Wrench | 0 | 0
43202123 | 10751-21X23 Tubular Box Wrench | 0 | 0
43202427 | 10751-24X27 [NAME] | 0 | 0
43203032 | 10751-30X32 [NAME] | 1 | 1
43200607 | 10751-6X7 Tubular Box Wrench | 0 | 0
43200809 | 10751-8X9 Tubular Box Wrench | 0 | 0
77590000 | 10757 Four Sided Bradawl | 4 | 4
43060150 | 10759/10-1.5 Offset Screwdrive | 5 | 5
43060002 | 10759/10-2 Offset Screwdriver | 0 | 0
43060250 | 10759/10-2.5 Offset Screwdrive | 4 | 4
43062150 | 10759/2-1.5 Offset Screwdriver | 5 | 4 |  | 4 |  | 1.73 | No history of sales or receipt dating to 7.1.10
43062250 | 10759/2-2.5 Offset Screwdriver | 4 | 4
43064150 | 10759/4-1.5 Offset Screwdriver | 5 | 5
43064250 | 10759/4-2.5 Offset Screwdriver | 5 | 5
43066150 | 10759/6-1.5 Offset Screwdriver | 5 | 5
43066002 | 10759/6-2 Offset Screwdriver | 4 | 4
43066250 | 10759/6-2.5 Offset Screwdriver | 4 | 4
43068150 | 10759/8-1.5 Offset Screwdriver | 5 | 5
43068002 | 10759/8-2 Offset Screwdriver | 5 | 5
43068250 | 10759/8-2.5 Offset Screwdriver | 5 | 5
43062002 | 10759-1 Offset Screwdriver | 5 | 5
43064002 | 10759-2 Offset Screwdriver | 6 | 6
43560004 | 10759A-1 (1/16) SAE Offset Scr | 3 | 3
43560006 | 10759A-1 (3/32)  SAE Offset Sc | 2 | 2
43560005 | 10759A-1 (5/64)  SAE Offset Sc | 2 | 2
43564004 | 10759A-2 (1/16 )SAE Offset Scr | 1 | 1
43564006 | 10759A-2 (3/32) SAE Offset Scr | 5 | 5
43564005 | 10759A-2 (5/64) SAE Offset Scr | 4 | 4
96435501 | 10760ACV/10P SAE Hex Key WrSet | 2 | 2
96435502 | 10760ACV/13 SAE Hex Key Wr Set | 4 | 4
43550004 | 10760ACV-1/16 SAE Hex Key Wren | 1 | 1
43550032 | 10760ACV-1/2 SAE Hex Key Wrenc | 5 | 5
43550016 | 10760ACV-1/4 SAE Hex Key Wrenc | 2 | 2
43550008 | 10760ACV-1/8 SAE Hex Key Wrenc | 7 | 7
43550022 | 10760ACV-11/32 SAE Hex Key Wre | 3 | 3
43550012 | 10760ACV-3/16 SAE Hex Key Wren | 1 | 1
43550006 | 10760ACV-3/32 SAE Hex Key Wren | 9 | 9