Laboratory Name:
This file contains the inventory and template form for software quality assurance.
FileName: 'file:///conversion/tmp/scratch/370377947.xls'#$Revisions
Version Date Initials
1.0 1-Apr-09 GH
2 6/25/2010 GH
2.1 6/25/2010 TS
quality assurance.
0377947.xls'#$Revisions
Modifications
Basic Software Inventory - original file
Sheets added for Revisions, Computer Inventory, COTS,
and Assessment Form A; Codes removed from Software
Inventory; Measurement Parameters added to Inventory
Technical Assessment form modified and inserted as
Form A.
Laboratory Computer Inventory
Computer Model Service ID Tag No. Location Operating System
Processor Installed Status Maintenance Network
Commercial-off-the-Shelf (COTS) Software Used in the Laboratory
Software Program Source Date Implemented
Software Inventory and S
Laboratory:
File Name Description of Purpose Used for Procedure
Laboratory Operations
Uncertainty-Template-Apr2008.xls
Control Chart Template.xls
PMAP
Mass III
Wheelload Weigher/Weight C
Mass II
3-1Weigh_16Apr08.xls
air91co24-2.xls
Mass I
Lab Wizard 1.0
Masscode.DOS
IR5672-Equations-v1-00-1Mar05.xls
Gravimetric Volume I
GravCal_16Apr08-2.xls
Volume Transfer II
Volume Transfer LPG/SVP
Length
Temperature
Time and Frequency
Other Measurement Parameter
Software Inventory and Status
Authorized Users Program Source
Laboratory Operations
NIST
NIST
Mass III
Wheelload Weigher/Weight Carts
Mass II
NIST
NIST
Mass I
NIST
NIST
NIST
Gravimetric Volume I
NIST
Volume Transfer II
Volume Transfer LPG/SVP
Length
Temperature
Time and Frequency
Other Measurement Parameter - TBD
Validation File Name/Location
Not validated by NIST. Local modifications must be validated too.
Not validated by NIST.
Not validated by NIST.
Validation Tab/Worksheet in the File. Form A needed.
Compiled/provided by NIST. Data sets used on site.
Compiled/provided by NIST. Data sets used on site.
Not validated by NIST.
Technical Assessment
This form is completed for each software file used in the laboratory. The form may be added as a tab/worsheet to
a file/workbook or may be maintained in a separate electronic/paper file/location in the laboratory.
Codes Assessment
Spreadsheet is clear and makes sense
There are instructions for use
Instructions and data input appear on the visible portion of the first worksheet
Data-entry fields are labeled and color coded (it is recommended to avoid red and
A. Software Inspection
green)
The Standard Operating Procedure (SOP) used is clearly specified
The number of digits to be rounded to is specified
The user is warned/notified whenever data-entry fields are left blank
Data-entry fields are blank when opened, preventing loss of old data and ensuring
that old data is not used with the current calculations
The software opens at the right location within the file
Unused fields/cells are locked
Rows/columns that the operator need not see are hidden
Unused sheets are removed
Worksheets are named appropriately
The correct SOP is used
Mathematical
Specification
The formulae and methods chosen from that SOP are specified
Sources and references for formulae are specified
B.
The chosen SOP, its methods, and its formulae, are appropriate to the level of
precision/uncertainty
The formulae in the fields exactly match the SOP
C. Code
review
Repeated calculations appropriately reference the correct cells
Calculations, when tested using standard data or reference test data, show
appropriate
Rounding is accuracy
done at the appropriate locations in the file
Calculations are stable as determined by an evaluation that uses large numbers and
small differences
D. Numerical
Stability
Fields, therefore their content, are categorized as Number and not General when
appropriate, and vice versa
Number cells are locked to a limited number of decimal places; this limit is
appropriate to the values being used
Each macro used is functional
E. Component
Each command/button is functional
Testing
Combinations of interdependent macros are functional
Plotted graphs are accurate
Worksheets/reports print properly, if needed to
Conditional (color and non-color) formatting is functional
Look-up tables and lists match the latest calibration report.
F. Numerical
Reference
Uncertainties match the latest Scope
F. Numerical
Reference
Values that reference another workbook or spreadsheet are dated
When a master lists date is updated, the file references (A) an old value, (B) a
default value, (C) displays zero or (D) an error message, as desired by the user
Embedded data (conversion factors, reference values, etc) is correct
Embedded
Evaluation
Data
G.
The evaluation of the embedded data is dated and documented
Newer spreadsheets and older spreadsheets agree down to the level of intermediate
H. Back-
to-Back
Testing
calculations; this evaluation is dated and documented
Hand calculations agree with those generated by the spreadsheet, or if they
Assistance
I. Analysis
Computer
With Out
disagree, the differences are significantly smaller than the reported uncertainty
Equation and calculation cells are protected against inadvertent editing
Cells are locked in place; they cannot be moved/dragged
J. Security
Confidentiality of passwords is appropriate
Files are backed up automatically
Additional back-up is available at alternate facilities
Files on network drives cannot be accidentally deleted
ay be added as a tab/worsheet to
in the laboratory.
Pass/Fail Evidence
of the first worksheet
mmended to avoid red and
y specified
re left blank
ss of old data and ensuring
pecified
ropriate to the level of
ct cells
nce test data, show
hat uses large numbers and
ber and not General when
l places; this limit is
rt.
are dated
(A) an old value, (B) a
as desired by the user
tc) is correct
mented
n to the level of intermediate
eadsheet, or if they
e reported uncertainty
dvertent editing
d
Cells P69 through P72 are neces
Pass
Fail
N/A
Cells P69 through P72 are necessary for the drop-down menu in cells J8 through J60
