Conference 7.286::digital

           For Std Cost & Desc, probably APPIX.  For MTBF, theoretically
           APPIX, too, but practically, try Nancy Whittemore... she used
           to help me with reliability (CSSE) metrics a few years ago.
           
           Steve

    I have a datatrieve report you could paste the numbers into 
    and run a report from the SPOC database that could pick out
    those fields.
    
    Let me know if you could use it.
    
    Lisa
    

I got what I needed and was amazed to learn how many people suck data
from somewhere and keep it locally. I'd prefer not to do this because
it adds work to keep the thing up to date.

I'm hoping that

a. there's a database that holds current data
b. I can get to it over the net using SQL without selling my children

although I suspect that perhaps (a) isn't true.

Thanks for all the offers,
Pete

Hi Tom...

Here is the scoop.. if you can get Option 237 SPOC II Report Facility
from spoc, you can go into that menu selection and then choose:
9.  Create Your Own Reports
which gives you a 1032> prompt

You then edit a report called whatever, ex. STD_COST.DMC

HERE IS THE REPORT:

set ds spmast
init 1 STD_COST.RPT
find part_num  363352068
print on 1 part_num part_desc STANDARD_COST
RELEASE 1

You can list multiple part numbers like this:
find part_num eq 363456548 363456549 363940804 364171101 364177801 364178301 -
364180601

OR like this:

find part_num bet 364310301 364310399 -
bet 364349501 364349599 -
bet 364363901 364363999

You also need to add the attribute for `mtbf'.. if I knew what it was
I could give it to you, but I don't know what it is representing.
Once you edit the report, you exit the file and at the 
1032> you will type USE STD_COST.DMC <return>

It should say:
2700 records found

Then you can type: STD_COST.RPT and should get something like this (plus
a column for the `mtbf':

PART_NUM                        PART_DESC                        STANDARD_COST
---------  ----------------------------------------------------  -------------
363352068  LABEL,FCC LN14X-AT                                               0

you can then type MAIL at the 1032>, you'll get a MAIL> where you
can say send STD_COST.RPT <return>
to: 7689::KOPEC
subj: report

just exit out and you are all set.

Also, I don't know how the parts file you have is printed, 225555522 or 
22-55555-22, but if it is 22-55555-22, you can use the EDD editor to
remove all the `-' in about 2 minutes.

Give me a call. 223-2619

This should take a total of 10-15 minutes, TOPS!!

Hope this helps, LIsa

PS. IF you need this right away I will help you out and get 
you your report until you get the 237 option and stuff.

LIsa

OH... ONE MORE THING,

at the >1032

type set ds spmast
then type show attribute (this is to find the proper attribute
for the `mt..' thing.

Lisa