File Processing and Quality Control

Title: Residential energy consumption survey [electronic resource]

Original diskette files: All diskettes were mounted on a 5 1/4" drive of a Windows 98 PC and the diskette files were copied to the PC hard drive. To preserve the original file content, all files were transferred to a UNIX server in binary format and retain their original time and date stamps.

Compressed files: All DOS compressed document and data files were extracted using the file extraction software (ARCE.COM) included on the original diskettes. ARCE.COM will only run on Windows OS versions that use the DOS (rather than NT) kernel. The decompressed files were transferred to a UNIX server in binary format and retain their original time and date stamps.

Processed documentation files: The DOS ASCII decompressed documentation files (user's guide and appendices) were concatenated with Unix "vi". This document was opened in Windows "V" file viewer software and printed to PDF format with Adobe Acrobat. Bookmarks were added to the PDF file. PDF output was checked to ensure that all original DOS documents and their formats were preserved in the PDF output.

Processed data files: The decompressed dBase III data files were translated to ASCII comma separated value (ASCII CSV) data file format with Windows DBMS/COPY. DBMS/COPY translation logs were checked for data translation error messages. No comparisons were made on the actual translated data cell values. The DBMS/COPY data dictionary follows:

DATA DICTIONARY (note: variable list changes according to the variable
names associated with each individual dBase III data file):

names=y
separator=,
mustsurround=n
surroundchar="
quotechar='
extension=csv
missing=.
numeric=n
fixed=n
dictionary=dct
date=mm/dd/yyyy
parmfile=ascii
variables
     1      4 c HHID
     6      6 R NWEIGHT
    13      1 c REGIONC
    15      1 c DIVISION
    17      1 c CORDONE
    19      1 c WOODAMT
    21      3 R CORDPLUS
    25      2 R NLPGDELV
    28      1 c KLPGSUPP
    30      1 c NLPGSUPP
    32      2 R NFODELV
    35      1 c NUMFOCO
    37      1 c NUMFOSUP
    39      1 c QUANTFO
    41      1 c BUYKERO
    43      1 c NUMKRDEL
    45      4 R TOTPAYKR
    50      2 R TOTDELKR
    53      3 R NUMKRGAL
    57      4 R TOTKRGAL
    62      1 c TOTKRUSE
    64      6 R GALLONKR
    71      7 R BTUKER
    79      6 R KWH
    86      7 R BTUEL
    94      6 R THERMNG
   101      7 R BTUNG
   109      6 R GALLONFO
   116      7 R BTUFO
   124      6 R THERMLP
   131      7 R BTULP
   139      7 R BTUELAPL
   147      7 R BTUELCOL
   155      7 R BTUELSPH
   163      7 R BTUELWTH
   171      7 R BTUFOAPL
   179      7 R BTUFOSPH
   187      7 R BTUFOWTH
   195      7 R BTUKRAPL
   203      7 R BTUKRSPH
   211      7 R BTUKRWTH
   219      7 R BTULPAPL
   227      7 R BTULPSPH
   235      7 R BTULPWTH
   243      7 R BTUNGAPL
   251      7 R BTUNGCOL
   259      7 R BTUNGSPH
   267      7 R BTUNGWTH
endvars