NAT L INST. OF STAND & TECF REFERENCE

AlllOS T8351E

iMbbIK 84-28630w

NBS

Publications

Microcomputer- Based Software for

Management of Calibration Service

U.S. DEPARTMENT OF COMMERCE

National Bureau of Standards

National Engineering Laboratory

Center for Electronics and Electrical Engineering

Electrosystems Division

Washington, DC 20234

April 1984

U.S. DEPARTMENT OF COMMERCE

NATiONAL 3UPEAU Of STANDARDS

NBSIR 84-2863

MICROCOMPUTER-BASED SOFTWARE FOR

MANAGEMENT OF CALIBRATION SERVICE

William E. Anderson

U S. DEPARTMENT OF COMMERCE

National Bureau of Standards

National Engineering Laboratory

Center for Electronics and Electrical Engineering

Electrosystems Division

Washington, DC 20234

April 1984

U.S. DEPARTMENT OF COMMERCE, Malcolm Baldrige. Secretary

NATIONAL BUREAU OF STANDARDS. Ernest Ambler. Director

TABLE OF CONTENTS

Page

Abstract 1

1. INTRODUCTION 1

2. DESCRIPTION OF SOFTWARE 1

3. SUMMARY 5

APPENDIX A 6

LISTING A 8

DISPLAY A 10

LISTING B 11

DISPLAY B 12

LISTING C 13

DISPLAY C 1^

LISTING D 15

PRINTOUT D 16

LISTING E 17

PRINTOUT E 18

LISTING F 19

PRINTOUT F 20

LISTING G 21

PRINTOUT G 22

LISTING H 23

PRINTOUT H 24

LISTING 1 25

PRINTOUT I 26

LISTING J 27

LISTING K 28
.

.
MICROCOMPUTER-BASED SOFTWARE FOR

MANAGEMENT OF CALIBRATION SERVICE

William E. Anderson

Abstract

The majority of the calibration customers' concerns are directed

not to the technical details of the calibration service but to the

timely delivery of that service. It is therefore proper that the

calibration services be closely managed. For a Group or Division with

a large calibration load, this can be a difficult task. The Applied

Electrical Measurements Group of the Electrosystems Division has

developed microcomputer-based software to provide considerable

assistance to the calibration manager. With this database software,

complete information on the status of all the calibration jobs is

instantly available.

Key words: calibration management; calibrations; database management;

mi crocomputer; software

1. INTRODUCTION

In order to provide adequate service to calibration clients, good management

must be exercised at the Group and/or Division level. Most complaints

concerning a calibration service are not directed to the technical asDects of

the service but more often to the timely delivery of the service. Therefore, it

would be of considerable value if complete information as to the status of each

calibration job were instantly accessible.

In the past, the Applied Electrical Measurements Group of the Electrosystems

Division kept a calibration log book. The arrival of purchase orders, test

folders, and equipment prompted an entry into the log book. Also entered *ere

the device type, closing date and fees. While most of the information necessary

to maintain a calibration service was contained in the log, retrieval of the

information in real time was not always possible. The requests for additional

fiscal and statistical information (e.g., the income per quarter from a specific

calibration service), sometimes required excessive amount of time for response.

With the advent of microprocessor-based workstations and commercially available

database software, vast improvements could be made in providing the i nformat i or without a significant expenditure in resources. Such a system was developed in

the Electrosystems Division and has been in use for the past six months. T he

system has been able to meet all demands on it and also has served as a means

for checking the accuracy of the centralized accounting system. Further, the

availability of accurate information on the current financial status of the

calibration service permits better planning decisions to be made.

2. DESCRIPTION OF SOFTWARE

Relational database software is readily available for both 3 and 16-b ; t microcomputers . The database management system, dBase II [1], from Asht:n-’i*

was selected because it was the only such software available at that t

1
could be used on all the computers anticipated to be used by the Group. A

similar calibration management program could be designed using database

management software from other vendors.

While dBase II provides the command structure to create and manipulate

databases, the user must provide the programs (in dBase II 's language) to tailor

the software to the user's needs. (A listing of the various programs along with

sample output is provided in the appendix). In order to make it possible for

this calibration management software to be used without any knowledge of dBase

II, the software was written to be menu-driven. Assuming the operator has

turned on the computer, loaded in the operating system, and that the programs

and database reside on the default disk drive, entering 'dbase menu' should

provide the following onscreen menu:

NUMBER OF RECORDS IS —

CALIBRATION FILE MENU

0 - EXIT

1 - ENTER NEW RECORD

2 - AMEND OR CHECK CONTENTS OF DATABASE RECORD

3 - PRINT LIMITED

4 - PRINT ALL

5 - PRINT ACTIVE

6 - PRINT LATE JOBS

7 - PRINT BY DEVICE

8 - PRINT BY CUSTOMER

9 - DISPLAY ACTIVE

A - COPY DATABASE

ENTER DESIRED ACTION

WAITING

Menu choices '1' and '2' provide the user a method for changing the contents of

a database record. The program is designed in such a way that each record

corresponds to one instrument received for calibration. (For multiple

instruments attached to the same test folder, suffixes A,B,C, etc. are concatenated to the test number). Each record consists of the following

fourteen fields: test number, purchase order number, type of instrument, model name and number, serial number, staff member assigned to calibration, customer's

name, customer's city and state (and zip code), starting date for job, promised

date, finishing date, form letter information, number of manhours, and cost

(excluding OPMS surcharges). While the contents of most of these fields may be

apparent, the intended contents of the form letter information field may need

explaining. It is the policy of the Electrosystems Division to keep its

customers informed as to the status of their calibration job with the use of

form letters. For example, if a purchase order is received with no instrument,

the customer is so notified. The customer always receives at least one form

letter with the estimated cost of the calibration and the date the job should be

finished. The form letter information field is 50 characters wide, permitting

the entry of the dates the form letters have been sent out and, if necessary, a one or two letter code describing the form letter contents. The menu choices

allow either modification of the database or output of information contained in

the database to the user. Each of the choices is explained below.

2
0 - EXIT Menu choice 'O' causes the program to terminate and exit to the

operating system (DOS or CPM). It is important that the user select this

choice before removing the diskettes or turning off the computer as this

selection also guarantees that the actual database file is properly updated

from memory.

1 - ENTER NEW RECORD Menu choice '1' allows the user to enter initial

information concerning a calibration job. The user is prompted on each

data entry. The day's date is automatically entered as the job start

data. In the cases where the test number is not known, a temporary number

should be assigned in order to facilitate fast retrieval of the record.

2 - AMEND OR CHECK CONTENTS OF DATABASE RECORD Menu choice '2' allows the

user to observe or update the information in the database as the work

progresses. If the user selects menu choice '2', the user will be prompted

to give either the test number or purchase order number of the record to be

updated or checked. Since the database is indexed on test numbers, a typical search for a test number takes less than 2 seconds.

3 - PRINT LIMITED Menu choice '3' provides the user a means of getting a partial listing on the system printer of the database contents. The fields

printed are the test number, type of instrument, customer name, job closing

date, and cost. The total cost or income is also listed. The listing is

in order of test numbers.

4 - PRINT ALL Menu choice '4' results in a more complete listing of the

database contents than choice '3.' Specifically all the fields are printed

out except the purchase order, staff member, and form letter information

fields. The information is printed in compressed print (132 characters per

line on the IBM printer). The total cost or income along with the manhours

are also listed. Users can get hardcopy access to the three missing fields

by exercising choice '2' and a print screen command if their computer

supports it.

5 - PRINT ACTIVE Menu choice '5' permits the user to receive a hardcopy

listing of all the active jobs. Basically the database is searched for all

records without a closing date entry. This enables the user to check the

active jobs against the OPMS monthly statement of active jobs.

6 - PRINT LATE JOBS Menu choice '6' causes the database to be searched for

all records in which the promised date comes before the present date and

there is no closing date entry. These jobs demand immediate attention,

normally in the form of a letter to the customers informing them of a revised promised date.

7 - PRINT BY DEVICE Menu choice '7' provides the user with a hardcopy

summary of all the jobs to date of a particular type of instrument e.n.,

voltage transformers ) . The summary also includes the total income earner

for that type of instrument and the calibration manhours expenced.

8 - PRINT BY CUSTOMER Menu choice * 8

' yields a hardcopy listina f

jobs done or in progress for a particular customer. The total cost ' f ' customer is also presented. If a customer calls concerning a ca!

; tr>*

this command may be the quickest way to find the correspond' nc r»e'r- *

the test or purchase order number are not available.

3
9 - DISPLAY ACTIVE Menu choice '9' is identical to choice '5' except the

output is to the display screen and not the printer.

A - COPY DATABASE Menu choice 'A' permits the user to copy the database

onto another floppy diskette to serve as backup. It is assumed that the

default drive is the "A" drive and contains the database programs and the

database. A formatted diskette must be placed in drive "B" before

selecting this menu choice. Experience has shown two problems with this menu choice. The first is that the duplication process is relatively slow

in dBase II. The second is that if an error occurs during the duplication

process, one often ends up in the operating system. This could result in

the database not being updated since a proper exit from dBase II has not

taken place. This command has been left on the display screen as a reminder to the user to backup the database. The best way to do this,

however, is exiting via menu choice '0' and copying the database file in

the operating system, using operating system commands.

The above choices represent only a small fraction of the useful information

contained in the database. Unfortunately, the more choices presented on the

menu, the more cluttered the screen becomes. A programmer with some familiarity

with dBase II can extract a myriad of useful information from the database.

For example, if there is a need to know the number and income derived from

watthour standards calibrated in the third quarter from state governments, that

information can be extracted readily from the database. Also, it is possible

to modify the menu choices to better meet the needs of a particular group of users.

The software system described has a great amount of flexibility. If it becomes

apparent that additional fields of information need to be saved in the database,

they can be added. For example, in the future it may be important to keep track

of when and if an instrument has been calibrated by the National Bureau of

Standards previously. Also, field sizes can be modified. If it is found that

50 characters do not provide enough space to accommodate the form letter

information, the field can be expanded. The information contained in the

database can be communicated to files used by word processors or to other

computers. The software is portable in the sense that although it was developed

on the IBM PC [1], it runs perfectly on the 8-bit storeroom microcomputer after

modification of three program lines.

[1] Certain commercial hardware and software are identified in this report in

order to specify the procedure used to manage the calibration data. Such

identification does not imply recommendation or endorsement by the National

Bureau of Standards nor does it imply that the items identified are necessarily the best available for the purpose.

4
3. SUMMARY

We have developed a microcomputer-based software system for the management of a calibration service at the Group or Division level. The system has been

designed for user "friendliness." A Group secretary has demonstrated total success in using the software. The software has provided Group and Division

management with information on the status of calibrations far superior to that

currently available from other sources. It has allowed the Group to make better

estimates of the financial status concerning our calibration services. In fact, it

is a likely case that this software itself has justified the investments the

Group has made in the procurement of the microprocessor workstations.

5
APPENDIX A

The microcomputer-based software for the management of a calibration service is

presented. The software was written to be used on an IBM PC or XT using

dBase II version 2.4. A slight modification will be presented that enables the

software to be run on the 8-bit storeroom mi crocomputer. Comments are not

encouraged in dBase II in the sense that they must be on a separate program

line. Variable names have been chosen, however, that should help in

understanding the programs.

Listing A is the program entitled 'menu.' It can be run from the operating

system by typing 'dbase menu' or from dBase II by typing 'do menu.' This

program causes the menu shown in display A to appear on the screen. Users not

having a color monitor and users of the 8-bit storeroom microcomputer should

delete the second line (SET COLOR TO 4.2). The database in this listing has the

file name CALFY83. The software is designed so that a new database should be

used each fiscal year.

Selection of menu choice '1* causes the program ' NEWRCD ' (listing B) to be

called. Display B shows the resulting screen display. The user is prompted for

each of the possible fields of data entry.

Selection of menu choice '2' calls the program ' AMERCD ' (listing C). The user

is requested to enter either the test number or purchase order number so the

software can find the record to be modified or checked. The resulting display

is shown in display C.

Selection of menu choice '3' calls the program 'PRINTLIM' (listing D). This

listing also includes the report format to be used for the printout. (M=l sets

the lefthand margin, N results in no page heading, N results in a single-spaced

report, Y allows numerical totalling, and N disallows subtotalling). A page of

the resulting printout is shown in printout D.

Selection of menu choice '4' calls the program ' PR I NTALL ' (listing E). The

second line of the program tells the IBM printer to use compressed type. For

the Prism printer used with the storeroom microcomputer, this line should be

changed from ' chr ( 15

)

' to 'chr(31).' A page of the resu‘

in printout E.

Selection of menu choice '5' calls the program ' PR I NTACT

'

of the printout is shown in printout F.

Selection of menu choice '6' calls the program 'PRINTDEL

of the printout is shown in printout G.

Selection of menu choice '7' calls the program 'PRINTDEV'

is prompted to enter the type of calibration instrument,

printout is shown in printout H.

:ing printout is shown

( 1 i sting F). A sample

(listing G)

.

A sample

(listing H). The user

A sample of the

Selection of menu choice '7' calls for the program ' PR I NT CUS ' (listing I). The

user is prompted to enter the customer's name. The second line of the program

tells the IBM printer to use compressed type. For the Prism printer used with

the storeroom microcomputer, this line should be changed from ' chr ( 15

)

' to

' chr ( 31 )

.

' A sample of the printout is shown in printout I.

6
Selection of menu choice '9' calls the program ' D I SPACT 1 (listing J). This menu choice is identical to choice '5' except the output is to the screen and not the

printer. The report format for this program ' PR I NTACT ‘ is shown in listing F.

Selection of menu choice 'A' calls the program ' DUP ' (listing K). As mentioned

in the main text, this command should only be used on a machine known to have

two well-running disk drives.

7
LISTING A

MENU

SET COLOR TO 4,2

ERASE

DO WHILE TRUE

USE CALFY83

GO BOTTOM

ERASE

?

?

1 USE

USE CALFY83 INDEX TESTNO

?

?

'

?

?

'

?

1

?

' DATABASE RECORD'

?

'

?

'

?

'

?

'

?

'

?

'

?

'

?

'

?

?

' WAIT TO ACTION

DO CASE

CASE ACTIONS O'

SET TALK ON

QUIT

CASE ACT I ON =' 1

'

DO NEWRCD

CASE ACT I ON =

' 2

'

DO AMERCD

CASE ACT ION =

' 3

'

DO PRINTLIM

CASE ACTION= ' 4

'

DO PRINTALL

CASE ACT I ON =

' 5

'

DO PRINTACT

CASE ACT I ON =

' 6

'

DO PRINTDEL

CASE ACT I ON =

' 7

'

DO PRINTDEV

CASE ACTION= ' 8

'

DO PRINTCUS

CASE ACT I ON =

' 9

'

DO DISPACT

NUMBER OF RECORDS IS', #

CALIBRATION FILE MENU'

0 - EXIT'

1 - ENTER NEW RECORD'

2 - AMEND OR CHECK CONTENTS OF

3 - PRINT LIMITED'

4 - PRINT ALL'

5 - PRINT ACTIVE'

6 - PRINT LATE JOBS'

7 - PRINT BY DEVICE'

8 - PRINT BY CUSTOMER'

9 - DISPLAY ACTIVE'

A - COPY DATABASE'

ENTERED DESIRED ACTION'

8
CASE ACTION 3 ' A

'

OTHERWISE

ENOCASE

' ‘ NVALID ENTRY ' RE ' ENTER '

ENOOO

RETURN

m*

9
DISPLAY A

NUMBER OF RECORDS IS 169

CALIBRATION FILE MENU

0 -

1 - 2 - 3 - 4 - 5

- 6 -

7 - 8 - 9

- A -

EXIT

ENTER NEW RECORD

AMEND OR CHECK CONTENTS OF DATABASE RECORD

PRINT LIMITED

PRINT ALL

PRINT ACTIVE

PRINT LATE JOBS

PRINT BY DEVICE

PRINT BY CUSTOMER

DISPLAY ACTIVE

COPY DATABASE

ENTER DESIRED ACTION

WAITING

10
LISTING B

NEWRCD

ERASE

GO BOTTOM

STORE ' Y

1 TO X DO WHILE X= ' Y

'

ERASE

STORE DATE() TO MrDATESTAR

STORE 'O / / 'TO Mr DATEPROM

STORE ' II 'TO M:DATECLOS

STORE ' ' TO MrTEST : NO

STORE ' ' TO M:PO:NO

CTHD C ' • TO M-' STORE '

' TO Mr MODEL

STORE '

' TO MrSERIALNO

STORE '

' TO MrCUSTNAM

STORE '

' TO Mr LOCATION

STORE '

' TO Mr STAFF

STORE ' TO M:FORMLET

STORE 0 TO M: MANHOURS

STORE 0 TO Mr COST

0 2,0 SAY "TODAY'S DATE" GET MiDATESTAR PICTURE '99/99/99'

0 3,0 SAY 'TEST NUMBER' GET MiTESTiNO

0 3,0 SAY 'PURCHASE ORDER NUMBER 1 GET MiPOiNO

0 5,0 SAY 'TYPE CHOICES ARE; MAP ,WATTHOUR STANDARD, CURRENT TRANSFORMER,'

0 6,0 SAY 'VOLTAGE TRANSFORMER, DC DIVIDER, AC DIVIDER, XRAY DIVIDER, DC & AC 1

0 7,0 SAY 'DIVIDER, IMPULSE DIVIDER, VT COMPARATOR , OR CT COMPARATOR' GET MiTYPE

0 8,0 SAY 'INSTRUMENT MODEL' GET MiMODEL

0 9,0 SAY 'INSTRUMENT SERIAL NUMBER' GET M: SERIALNO

@ 10,0 SAY 'CUSTOMER NAME' GET MiCUSTNAM

0 11,0 SAY 'CUSTOMER LOCATION' GET MiLOCATION

0 12,0 SAY 'CALIBRATION STAFF MEMBER' GET MiSTAFF

0 13,0 SAY 'DATE PROMISED' GET MiDATEPROM PICTURE '99/99/99'

0 14,0 SAY 'FORM LETTER INFO' GET MiFORMLET

0 15,0 SAY 'CLOSING DATE' GET MiDATECLOS PICTURE '99/99/99*

0 16,0 SAY 'COST EXCLUDING OMS SURCHARGE' GET MiCOST PICTURE '######.##'

0 17,0 SAY 'CALIBRATION MANHOURS' GET MrMANHOURS PICTURE '#####.##'

READ

APPEND BLANK

REPLACE TEST : NO WITH MrTEST :NO,TYPE WITH ! (MrTYPE ), MODEL WITH ! ( M: MODEL

)

REPLACE SERIALNO WITH ! (MrSERIALNO) , STAFF WITH ! ( M: STAFF)

REPLACE LOCATION WITH ! (M: LOCATION ) ,DATESTAR WITH M: DATESTAR

REPLACE FORMLET WITH ! (MrFORMLET) ,DATECLOS WITH MrDATECLOS

REPLACE COST WITH MrCOST, MANHOURS WITH M: MANHOURS , DATEPROM WITH M: DATEPROM

REPLACE PO : NO WITH ! (MrPOrNO) ,CUSTNAM WITH !(M:CUSTNAM)

ACCEPT 'WANT TO CONTINUE ' Y

' OR ' N '" TO XI

STORE ! (XI) TO X ENDDO

RETURN

11
DISPLAY B

TODAY'S DATE; 12/15/83:

TEST NUMBER: : PURCHASE ORDER NUMBER: : TYPE CHOICES ARE: MAP ,WATTHOUR STANDARD, CURRENT TRANSFORMER, CAPACITOR,

VOLTAGE TRANSFORMER, DC DIVIDER, AC DIVIDER, XRAY DIVIDER, DC & AC

DIVIDER, IMPULSE DIVIDER, VT COMPARATOR, OR CT COMPARATOR:

INSTRUMENT MODEL: : INSTRUMENT SERIAL NUMBER: : CUSTOMER NAME : : CUSTOMER LOCATION: : CALIBRATION STAFF MEMBER: : DATE PR0MISED:0 / / : FORM LETER INFO: : CLOSING DATE: / / : COST EXCLUDING OMS SURCHARGE: O.OO:

CALIBRATION MANHOURS: 0.00:

12
LISTING C

AMERCD

STORE ' Y

' TO X DO WHILE X= '

Y

1 ERASE

STORE '

' TO M: TEST: NO

STORE '

' TO M: PO : NO

ACCEPT "ENTER TEST NUMBER IF KNOWN OTHERWISE 'RETURN'" TO M:TEST:NO

IF MrTEST :NO=' ' ACCEPT "ENTER PURCHASE ORDER NUMBER IF KNOWN OTHERWISE 'RETURN'" TO M:PO:NO

IF M: PO: NO= ' ' RETURN

ELSE

LOCATE FOR !(M:PO:NO) $ PO : NO

ENDIF

ELSE

FIND &M:TEST : NO

ENDIF

IF (.NOT. EOF) .AND. (#<>0)

0 5,0 SAY 'TEST NUMBER' GET TEST:NO

0 6,0 SAY 'PURCHASE ORDER NUMBER' GET PO: NO

0 7,0 SAY 'TYPE' GET TYPE

0 8,0 SAY 'INSTRUMENT MODEL' GET MODEL

@ 9,0 SAY 'SERIAL NUMBER' GET SERIALNO

0 10,0 SAY 'CUSTOMER NAME' GET CUSTNAM

0 11,0 SAY 'CUSTOMER LOCATION' GET LOCATION

0 12,0 SAY 'JOB START DATE' GET DATESTAR PICTURE '99/99/99'

0 13,0 SAY 'DATE PROMISED' GET DATEPROM PICTURE '99/99/99'

0 14,0 SAY 'FORM LETTER INFO' GET FORMLET

0 15,0 SAY 'STAFF NAME' GET STAFF

0 16,0 SAY 'CLOSING DATE' GET DATECLOS PICUTURE '99/99/99'

0 17,0 SAY 'COST' GET COST PICTURE '######.##'

0 18,0 SAY 'MANHOURS' GET MANHOURS PICTURE '#####.##'

0 19,0

0 20,0

ACCEPT "WANT TO MAKE CHANGES ' Y

' OR 'N'" TO Y1

STORE ! (Yl) TO Y IF Y= ' Y

'

READ

ENDIF

ELSE

0 21,0 SAY 'RECORD COULD NOT BE FOUND'

ENDIF

ACCEPT "WANT TO CHANGE OR OBSERVE ANOTHER RECORD ' Y

' OR 'N'" TO Xl

STORE ! (XI) TO X ENDDO

RETURN

13
DISPLAY C

ENTER TEST NUMBER IF KNOWN OTHERWISE 'RETURN 1 : 228554

TEST NUMBER: 228554 : PURCHASE ORDER NUMBER: : TYPE :WATTHOUR STANDARD : INSTRUMENT MODEL: SCIENTIFIC COLUMBUS SC-60

SERIAL NUMBER: : CUSTOMER NAME :RFL INDUSTRIES

CUSTOMER LOCATION :BOONTON, NJ 07005

JOB START DATE: / / : DATE PROMISED : 10/01/82

:

FORM LETTER INFO:

STAFF NAME :RAMBOZ : CLOSING DATE: 10/01/82:

COST: 262.50:

MANHOURS: 0.00:

WANT TO MAKE CHANGES ' Y

' OR ' N

'

:

14
LISTING D

PRINTLIM

REPORT FORM PRINTLIM TO PRINT

RETURN

PRINTLIM. FRM

M=1

N

N

Y

N

7,

TEST : NO

20, TYPE

30,CUSTNAM

8,

DATECL0S

9, COST

Y

15
PRINTOUT D

PAGE NO. 00002

12/15/83

229944 CURRENT TRANSFORMER

229948 WATTHOUR STANDARD

230019 MAP

230025 DC DIVIDER

230121A VOLTAGE TRANSFORMER

230121B VOLTAGE TRANSFORMER

230121C VOLTAGE TRANSFORMER

230121D VOLTAGE TRANSFORMER

230121E VOLTAGE TRANSFORMER

230121F VOLTAGE TRANSFORMER

230121G WATTHOUR STANDARD

230176 WATTHOUR STANDARD

230180 WATTHOUR STANDARD

230181 WATTHOUR STANDARD

230182 WATTHOUR STANDARD

230188 WATTHOUR STANDARD

230193 WATTHOUR STANDARD

230198 WATTHOUR STANDARD

230207 DC DIVIDER

230219 WATTHOUR STANDARD

230238 MAP

230241 WATTHOUR STANDARD

230254 WATTHOUR STANDARD

230261 CURRENT TRANSFORMER

230268 WATTHOUR STANDARD

230280 CURRENT TRANSFORMER

230285A WATTHOUR STANDARD

230285B WATTHOUR STANDARD

230285C WATTHOUR STANDARD

230308 WATTHOUR STANDARD

230345A WATTHOUR STANDARD

230345B WATTHOUR STANDARD

230435 DC DIVIDER

230455A VT COMPARATOR

230455B VOLTAGE TRANSFORMER

230471 VOLTAGE TRANSFORMER

230493A VOLTAGE TRANSFORMER

230493B CAPACITOR

230493C CAPACITOR

230493D CAPACITOR

230497 WATTHOUR STANDARD

230506 WATTHOUR STANDARD

230523 WATTHOUR STANDARD

230530A WATTHOUR STANDARD

230530B WATTHOUR STANDARD

230530C WATTHOUR STANDARD

230538 WATTHOUR STANDARD

230584 WATTHOUR STANDARD

230589 WATTHOUR STANDARD

230640 XRAY DIVIDER

LOCKHEED GEORGIA COMPANY

RFL INDUSTRIES

WEST TEXAS UTILITIES CO

GENERAL ELECTRIC

MILL-POWER SUPPLY COMPANY

MILL-POWER SUPPLY COMPANY

MILL-POWER SUPPLY

MILL-POWER SUPPLY

MILL-POWER SUPPLY

MILL-POWER SUPPLY

MILL-POWER SUPPLY

DALLAS POWER & LIGHT

STATE OF MARYLAND

PHILADELPHIA ELECTRIC

RFL INDUSTRIES

TEXAS POWER & LIGHT

CENTRAL POWER & LIGHT

UNION ELECTRIC

SANDIA NATIONAL LABORATORIES

GENERAL ELECTRIC COMPANY

SOUTH CAROLINA ELECTRIC & GAS

TRANSDATA

KOREAN STANDARDS RESEARCH INST

RAYTHEON

THE UNIV. OF WISCONSIN-MAD I SON

AVCO SYSTEMS DIVISION

GULF POWER

GULF POWER

GULF POWER

GENERAL ELECTRIC COMPANY

PUBLIC SERVICE ELECTRIC & GAS

PUBLIC SERVICE ELECTRIC & GAS

GENERAL ELECTRIC COMPANY

PACIFIC GAS & ELECTRIC

PACIFIC GAS & ELECTRIC

BOEING AEROSPACE COMPANY

GENERAL ELECTRIC COMPANY

GENERAL ELECTRIC COMPANY

GENERAL ELECTRIC COMPANY

GENERAL ELECTRIC COMPANY

HOUSTON LIGHTING & POWER

SCIENTIFIC COLUMBUS

VIRGINIA ELECTRIC & POWER

GENERAL ELECTRIC COMPANY

GENERAL ELECTRIC COMPANY

GENERAL ELECTRIC COMPANY

GENERAL ELECTRIC COMPANY

CORN BELT POWER CORP.

MCDONNELL DOUGLAS ASTRONAUTICS

TECHNICARE CORPORATION

05/10/83 645.00

03/25/83 1016.00

04/15/83 485.00

03/11/83 530.00

03/25/83 3879.00

03/25/83 0.00

03/01/83 0.00

03/01/83 0.00

03/01/83 0.00

03/01/83 0.00

03/01/83 1250.00

02/01/83 412.00

02/01/83 508.00

02/01/83 781.00

03/01/83 898.00

03/01/83 412.00

03/01/83 485.00

03/01/83 664.00

03/01/83 530.00

03/01/83 1288.00

03/01/83 641.00

03/01/83 1055.00

03/01/83 508.00

03/01/83 785.00

03/01/83 485.00

03/01/83 704.00

03/01/83 2090.00

03/01/83 0.00

03/01/83 0.00

03/01/83 586.00

04/01/83 984.00

04/01/83 0.00

04/01/83 430.00

04/01/83 772.00

04/01/83 1799.00

04/01/83 851.00

04/01/83 1578.00

04/01/83 760.00

04/01/83 0.00

04/01/83 0.00

04/01/83 1343.00

04/01/83 820.00

04/01/83 430.00

05/01/83 3925.00

05/01/83 0.00

05/01/83 0.00

05/01/83 742.00

05/01/83 549.00

05/01/83 634.00

05/01/83 630.00

16
LISTING E

PRINTALL

SET FORMAT TO PRINT

O 1,0 SAY CHR ( 15

)

SET FORMAT TO SCREEN

REPORT FORM PRINTALL TO PRINT

SET FORMAT TO PRINT

0 1,0 SAY CHR (18)

SET FORMAT TO SCREEN

RETURN

PRINTALL. FRM

M=0

NNY

N

7,

TEST :N0

11, TYPE

10,SERIALN0

15, MODEL

15 ,CUSTNAM

15, LOCATION

8,

DATE STAR

START

8,DATEPR0M

PROMISED

8,

DATECL0S

CLOSED

9,

COST

Y8, MANHOURS

Y

17
PRINTOUT E

PAGE NO. 00007

12/12/33

START PROMISED CLOSED

23 1204

A

CAPACITOR 3047 R. JfiHRE DOBLE WATERTOWN. MA 03/22/33 10 / 01/33 03/24/33 436.00 3.00 ENGINEERING

COMPANY

02172

231204S VOLTAGE 23053 BOSTON MULTIPLE DGBLE WATERTOWN, MA 03/22/33 10/01/33 03/24/83 930.00 0.00 TRANSFORMER RATIO ENGINEERING

COMPANY

02172

231212 VOLTAGE 3346602 TYPE VT-756 KNOPF INC. EMERYVILLE, CA 03/22/33 / / 03/25/33 386.00 0.00 TRANSFORMER 34603

231262 SATTH0UR HESTINGHOUSE RALEIGH, NC 03/31/33 10/03/33 / / 0.00 0.00 STANDARD 27603

231262A NATTHGUR D5-1 SINGLEPHASE SE3TINGHGUSE RALEIGH, NC 03/26/33 10/06/33 / / 0.00 0.00 STANDARD METER 27603

231262B NATTHGUR D5-2 SINGLE PHASE NESTINGKOUSE RALEIGH. NC 03/26; S3 10/06/33 / / 0.00 0.00 STANDARD METER 27603

231263 VOLTAGE 3346731 TYPE FIVES KNOPP INC. EMERYVILLE, CA 03/22/33 / / 09/16/33 2469.00 0.00 TRANSFORMER VOLTAGE ERROR

XFMR

34603

231267 MAP SC 10 CLEVELAND CLEVELAND, OH OS/31/33 11/07/33 / / 0.00 0.00 ELECTRIC

ILLUMINA7IN

44101

2317:9 HA77H0UR IS 14 SC 60 MODEL RFL INDUSTRIES SGCN7GN, NJ 09/14/33 10/14/33 09/29/33 503.00 0.00

'STANDARD G *. u-.‘ fl INC. 07005

“t • iwi-j/ j NATTHGUR SC MICROJOULE MARYLAND PUBLIC BALTIMORE, MD 09/16/33 10/03/33 09/29/33 503.00 0.00 STANDARD SERVICE CCMMI3

231377 MAP SC-60 NORTHERN STATES MINNEAPOLIS. MN 09/23/33 10/27 'S3 / / 0.00 0. 00 POWER COMPANY 55403

231373 HA7TH0UR 1737 SC-cO MODEL PORTLAND PORTLAND, OR 09/16/33 10/07/33 0.00 0.00 STANDARD 6253 GENERAL

ELECTRIC COMP

231423 MAP STATE OF SACRAMENTO. CA O

c 27/33 11. 04/33 j / 0.00 0.00 CALIFORNIA -5326

T J'U MAP Jd COLGRADO-UTE MONTROSE. CO ;j9 ..'27 3' 11/04/33 0.00 0. 00 ASSOCIATION

INC.

SI 401

;:i:50 H AP MICRO JOULE TAMPA ELECTRIC TAMPA, FL 03601 •’)- 2" S3 n/o: s: / / 0.00 0.00 231-33 CT -/*l ] cr nn KNGFP CONSOLIDATED NEW YORK, NY ;i g /

f

-

; 0 *

/ / 0.00 0.00 COMPARATOR COMPARATOR EDISON COMPANY 10003

•31:437 CURRENT 66224 GENERAL TENNESSEE CHATTANOOGA, *N 11/01/32 11/01/82 505.00 0.00 TRANSFORMER ELECTRIC JP7 VALLEY AUTHORITY

37401

344511 DC DIVIDER ES12617 PARK DEPARTMENT OF NEWARK AIR 11/01/32 11/01/32 740.00 0.00

THE AIR FORCE STATION. OH *****

3-431 7

A

CURRENT i:220 P.N 461 TYPE 5 DEPARTMENT OF

-* - ».* w NEWARK AIR 11/01/32 11/01/32 1397.00 0. 50 TRANSFORMER THE AIR FORCE STATION. OH

•?ACC

3445 17B CURRENT 6025 P'N 327

r v?E 2 DEPARTMENT OFv'r’j \rn

.’C.-ifi n.\ -Mir. 11; 01 , 32 11/01:32 0.00 Vi TRANSFORMER THE AIR FORCE STATION. OH

17; ;CS

244533 NATTHGUR 3331 SCIENTIFIC TENNESSEE

“vvwO CHATTANOOGA, TN 12/oi; s: 12/01/32 1992.00 J , J \j STANDARD COLUMBUS SC-60 VALLEY AUTHORITY

37401

18
LISTING F

PR INTACT

REPORT FORM PRINTACT FOR DATECLOS=" " TO PRINT

RETURN

PRINTACT. FRM

M=1

YACTIVE JOBS

N

N

7,

TEST : NO

20, TYPE

30,CUSTNAM

8,

DATESTAR

CTADT

8,DATEPR0M

PROMISED

19
PRINTOUT F

PAGE NO. OOOOl

12/15/83

ACTIVE JOBS

START PROMISED

0000001 XRAY DIVIDER KIETHLEY CORP. 09/28/83 / /

0000002 CURRENT TRANSFORMER PHILADELPHIA ELECTRIC COMPANY 09/12/83 / /

0000003 CURRENT TRANSFORMER PHILADELPHIA ELECTRIC COMPANY 09/12/83 / /

0000006 MAP UNIVERSITY OF WISCONSIN 09/27/83 / /

230988 CURRENT TRANSFORMER KNOPP INC. 06/16/83 09/23/83

231096 WATTHOUR STANDARD SCIENTIFIC COLUMBUS 00/00/00 00/00/00

231190 CURRENT TRANSFORMER GENERAL ELECTRIC COMPANY 00/00/83 09/23/83

231200 CURRENT TRANSFORMER YOKOGAWA CORP. 08/12/83 09/23/83

231262 WATTHOUR STANDARD WESTINGHOUSE 08/31/83 10/03/83

231262A WATTHOUR STANDARD WESTINGHOUSE 08/26/83 10/06/83

231262B WATTHOUR STANDARD WESTINGHOUSE 08/26/83 10/06/83

231267 MAP CLEVELAND ELECTRIC ILLUMI NATI

N

08/31/83 11/07/83

231377 MAP NORTHERN STATES POWER COMPANY 09/23/83 10/27/83

231378 WATTHOUR STANDARD PORTLAND GENERAL ELECTRIC COMP 09/16/83 10/07/83

231423 MAP STATE OF CALIFORNIA 09/27/83 11/04/83

231424 MAP COLORADO-UTE ASSOCIATION INC. 09/27/83 11/04/83

231450 MAP TAMPA ELECTRIC 09/27/83 11/07/83

231455 CT COMPARATOR CONSOLIDATED EDISON COMPANY 09/02/83 / /

G44691 MAP BONNEVILLE POWER ADMINISTRATE 09/02/83 10/13/83

G44700A VOLTAGE TRANSFORMER NAVAL AIR REWORK FACILITY 09/12/83 10/15/83

G44700B VOLTAGE TRANSFORMER NAVAL AIR REWORK FACILITY 09/12/83 / /

20
LISTING G

PRINTDEL

ERASE

STORE DATE() TO M:DATESTAR

REPORT FORM PRINTDEL FOR ( ( ( ( (M: DATESTAR > DATEPROM) .OR.

$ ( M : DATE STAR , 7 , 2 ) >$ ( DATEPROM, 7 , 2 ) ) .AND. ; DATECLOS=' ') .AND. DATEPROM <>'//') .AND.;

DATEPROM <> 'O / / ' ) TO PRINT

RETURN

PRINTDEL. FRM

M=1

YLATE JOBS

N

N

7,

TEST : NO

10, STAFF

20, TYPE

30,CUSTNAM

8,

DATEPROM

21
PRINTOUT G

PAGE NO. OOOOl

12/15/83

LATE JOBS

230988 RAMBOZ CURRENT TRANSFORMER KNOPP 09/23/83

231096 RAMBOZ WATTHOUR STANDARD SCIENTIFIC COLUMBUS 00/00/00

231190 RAMBOZ CURRENT TRANSFORMER GENERAL ELECTRIC COMPANY 09/23/83

231200 RAMBOZ CURRENT TRANSFORMER YOKOGAWA CORP. 09/23/83

231262 RAMBOZ WATTHOUR STANDARD WESTINGHOUSE 10/03/83

231262A RAMBOZ WATTHOUR STANDARD WESTINGHOUSE 10/06/83

231262B RAMBOZ WATTHOUR STANDARD WESTINGHOUSE 10/06/83

231267 RAMBOZ MAP CLEVELAND ELECTRIC ILLUMI NATI

N

11/07/83

231377 RAMBOZ MAP NORTHERN STATES POWER COMPANY 10/27/83

231378 RAMBOZ WATTHOUR STANDARD PORTLAND GENERAL ELECTRIC COMP 10/07/83

231423 RAMBOZ MAP STATE OF CALIFORNIA 11/04/83

231424 RAMBOZ MAP COLORADO-UTE ASSOCIATION INC. 11/07/83

231450 RAMBOZ MAP TAMPA ELECTRIC 11/07/83

G44691 RAMBOZ MAP BONNEVILLE POWER ADMINISTRATE 10/13/83

G44700A ANDERSON VOLTAGE TRANSFORMER NAVAL AIR REWORK FACILITY 10/15/83

22
LISTING H

PRINTDEV

STORE ' Y

' TO X DO WHILE X=' Y

'

ERASE

STORE '

' TO M:TYPE

@ 1,0 SAY 'DEVICE TYPE' GET M:TYPE

READ

SET HEADING TO &M:TYPE

REPORT FORM PRINTDEV FOR ! ( M : TYPE ) =TYPE TO PRINT

SET HEADING TO

ACCEPT "PRINTOUT FOR OTHER DEVICES ' Y' OR 'N'" TO XI

STORE ! (XI) TO X ENDDO

RETURN

PRINTDEV. FRM

M=1

N

N

Y

N

7,

TEST :N0

15, MODEL

15 ,CUSTNAM

15, LOCATION

9, COST

Y

8,

MANHOURS

Y

23
PRINTOUT H

PAGE NO. OOOOl DC DIVIDER

12/15/83

229529 PARK BIDDLE

INSTRUMENTS

229923 PARK ROCKWELL

INTERNATIONAL

230025 FLUKE MODEL GENERAL

80E-10 ELECTRIC

230207 PARK SANDIA NATIONAL

LABORATORIES

230435 SINGER MODEL GENERAL

PARK ELECTRIC

COMPANY

230751 HALLMARK WESTINGHOUSE

ELECTRIC

230771 HALLMARK MODEL BENDIX

PARK CORPORATION

230858 HALLMARK GENERAL

DYNAMICS

230905 MCDONNELL

DOUGLAS

230929 ROSS MODEL ROSS

VD240-6.2-J-K-D

M

HALLMARK

ENGINEERING

230947 RAYTHEON

COMPANY

G44511 PARK DEPARTMENT OF

THE AIR FORCE

G44568 SIEFERT NATIONAL BUREAU

OF STANDARDS

G44660 HALLMARK PVD DEPARTMENT OF

THE ARMY

** TOTAL **

BLUE BELL, PA

19422

430.00 0.00

DOWNEY, CA

90241

430.00 0.00

KING OF

PRUSSIA, PA

19406

530.00 0.00

ALBUQUERQUE, NM

87185

530.00 0.00

CHAMBLEE, GA

30341

430.00 0.00

BALTIMORE, MD

21203

430.00 0.00

SIDNEY, NY 430.00 0.00

13838

FORT WORTH, TX 430.00 0.00

76101

ST. LOUIS, MO

63166

840.00 0.00

CAMPBELL, CA

95008

430.00 0.00

ANDOVER, MA

01810

430.00 0.00

NEWARK AIR

STATION, OH

740.00 0.00

43055

WASHINGTON, DC 430.00 0.00

20234

FT. MONMOUTH,

NJ 07703

430.00 0.00

6940.00 0.00

24
LISTING I

PRINTCUS

ERASE

SET FORMAT TO PRINT

@ 1,0 SAY CHR ( 15

)

SET FORMAT TO SCREEN

ACCEPT 'CUSTOMER NAME' TO CUSTSET HEADING TO &CUST

REPORT FORM PRINTCUS FOR I (CUST) = $(CUSTNAM, l.LEN(CUST) ) TO

PRINT

SET HEADING TO

SET FORMAT TO PRINT

@ 1,0 SAY CHR (18)

SET FORMAT TO SCREEN

RETURN

PRINTCUS. FRM

M=1 ,W=132

N

N

Y

N

7,

TEST :N0

20, TYPE

15, MODEL

30, LOCATION

10, STAFF

8,

DATEPR0M

PROMISED

9,

COST

Y

25
PRINTOUT I

PAGE NO. OOOOl general electric

12/15/33

PROMISES

230025 SC DIVIDER FLUKE MODEL 30E-10

KINS OF PRUSSIA, RA 19406 MISAK I AN 04/10/83 530.00

23021? hATTHOUR standard GENERAL

ELECTRIC 18-10

COMPTON, Cfl ?0220 FAMBQZ 03/01/33 1233.00

230308 NA7THGUR STANDARD GENERAL ELECTRIC TYRE

18-10

SCHENECTADY, NY 12345 RAMSG2 03/01 / S3 536.00

230433 DC DIVIDER SINGER MODEL

•ARK

OHAMBLES, SA 30341 MISAK IAN 04/01/83 430,00

2 . 0 4 9 i-A -0LTA8E TRANSFORMER GENERAL

ELECTRIC

L : NCH3URS, VA 24502 ANDERSON 04/01/83 1573.00

2304=73 CAPACITOR GENERAL RADIO

1404

L • NCH3URS, VA 24502 ANDERSON 04/01/83 760.00

23C493C CAFACITOR GENERAL RADIO

1404

LYNCHBURG, VA 24502 -NOERSGN 04/01/33 0.00

::o4=:d CAPACITOR LYNCHBURS, VA 24502 ANDERSON 04/01/33 0.00 230530A AA77HGUR STANDARD SANGAMG 13-10 SGMESShORTH. NH 03373 RAMBOI 05/ 1 i 3w 3=25.00

230530B 4AT”HCliR STANDARD SCIENTIFIC

COLUMBUS SC-30

SOMERSsuRTH, NH 03873 9AMS0I 05/01/33 0.00

2305302 l TH uUS i T AND A R D SCIENTIFIC COLUMBUS SC -30SOMERGNGRTH, NH 03873 FAMBQZ 05/01/ S3 0. DO

- 7 r**n NAT7H0UR STANDARD SCIENTIFIC

CCLUMSU3 SC-jO

SOMERSHORTH. NJ 03S73 RAMEOZ 05/01/83 ’42. DO

* CA CURRENT TRANSFORMER ASSIGN 027 COMPTON, DA 90220 mMBO. j'li £s.‘ o.co

li 'DIAL it

26
LISTING J

DISPACT

REPORT FORM PRINTACT FOR DATECLOS=" "

?

' '

?

' HIT RETURN FOR MENU'

WAIT TO CHOICE

RETURN

27
LISTING K

DUP

COPY TO B:CALFY83

RETURN

28
S0S-U4A g £ • I -it _.s. ;e»t. o p comm. BIBLIOGRAPHIC DATA

SHEET See -s:%c: c-s

1. Pj = _ CATION OR

REPORT NO.

NBSIR 84-2863

2. Perfoi— ing Organ. Reocr: No. 3. p-jc cation 0 are

ADril 1984

4. ^ AND SUE"i w —

MICROCOMPUTER- BASED SOFTWARE FOR

MANAGEMENT OF CALIBRATION SERVICE

5. Ac i HO Ri S > William E. Anderson

S. =>ERFCRViNG ORGANIZATION * ;o<‘nt or oner man N 55, see -.structioos

NATIONAL BUREAU OF STANDARDS

DEPARTMENT OF COMMERCE

WASHINGTON. D.C. 20234

7. Contracr/Gran: No.

8. Type of Report i Per cc Cove-ec

9. SPONSOR NG ORGAN ;a~ ON NAVE ANO G0V = _E~= AOORoSS Street, C.ty. State, _ =

10. 5LP c LEvENTARY NO~E:

Ooc„ — e-r tesc- ces a comouter c'cg'a— ; S--S5, - PS Sot . —'ary, s attachea.

11. a =3 =\AC a S3C-AC r a or ess -'cct_c. sjrrmary of —os: sign ' com -for

r t c":cr c' te-ct^-e survey, —ent on cere

j

e-t -c.jces c s g- • cc-

”he majority of the calibration customers 1 concerns are directed

not to the technical details of the calibration service but to the

timely delivery of that service. It is therefore proDer that the

calibration services be closely managed. For a GrouD or Division with

a large calibration load, this can be a difficult task. ~he Applied

Electrical Measurements Group of the Electrosystems Division ras developed microcomputer-based software to provide consiaeraDle

assistance to the calibration manager. With this database software,

complete information on the status of all the calibration joos is

instantly available.

ore oe- cc.-ces; z-c sepo'Cte <e. calibration management; calibrations; database management; mi crocomDuter ; sc**..

13. AVA _A5._

_ - — :s:

i :4. no: of

_X

“ 2r C'cs' = 'z~ 5_rs" r:ercer: s~ erts, _.S. Go.s e

"

: • ~;.rg 0* f ce, '’•as- - g' - . Z.Z.

15. P'

C~oe~ r-rc~ Nat or.ai ec~~ ca. -ror—‘at:on Serv ce N S . 5a* -g* e r. . 1 1

-

C Omu*