Defect Ratios - Part #2

In part 1 - you will notice that we use TEXT and not NUMBERS for the part number --that helps you keep LEADING ZERO's in part #'s - a tip that is handy

We found it easier to get TOTAL SALES from a 6-3 report and not add up every invoice here ...you use a similar method - but use your Ethernet line if you have one and go thru Acconnex --WAY FASTER ( 20 to 50 times faster )

The 6-3 report is a GREAT REPORT that we do every month to see where we are on select accounts (salesmen accounts and key other accounts )

I am sure I have written on how to take TWO DIFFERENT spreadsheets and take data from one into the other using something we thing is way better than VLOOKUP or HLOOKUP ( =INDEX( range , MATCH ( part #, range of part #'s, 0 ), x is the column you bring back ) --this is trickey at first - but very very handy

Use sub totals from your 6-9 report and get the values for the warranty returns by customer #.

NOW - great tip we found -- how do you get the SUB RTOTAL ONLY data .... use EDIT ... GO TO .... SPECIAL ..... VISIBLE CELLS ONLY ..... and copy the data. The PASTE SPECIAL for VALUES ONLY into a new spreadsheet. From here - import into your 6-3 report (or a clone of it ) and calculate defect ratio's

So - what steps might I have skipped - one is the reverse the negative sign ( older Excel programs like I use do not have it - so get the www.asap-utilities.com add on ( come on--make this for the MAC !! - so far only PC only )

There you have it --data that you can USE -- but with care & caution -- since habits take time to improve - and there might be valid reasons for specific warranty ratio's

Better data makes better decisions