The Technology Factor in Industrialization: Indicators Explanatory Notes re Computer Files [READ-ME.TXT file] Larry E. Westphal, Howard Pack, and Carl J. Dahlman with assistance from Suzanne M. Buckley, Karan S. Madan, and Esther Parker February 1996; Final Revision, June 1996 Project Sponsor and Principal Funder: United Nations University, Institute for New Technologies Additional Funding: Joel Dean Foundation, funds provided to Swarthmore College for student summer research stipend; Swarthmore College Research Fund. Copyright 1996 by Larry E. Westphal, Howard Pack and Carl J. Dahlman. NOTICE: Data are not to be cited in any form without explicit written permission from L. E. Westphal Disclaimer: Notwithstanding that every effort has been made to assure the accuracy of the explanatory notes and of the indicators themselves (the latter with respect to retrieval, computation, and the like), those involved in their preparation make no guarantees, either implicit or explicit, of accuracy in any regard in either case. Users of both notes and indicators accordingly assume any and all risks associated with their use. These files are made available for the convenience of those who wish to access the indicators in computer readable form. The following should provide all of the information needed to access and comprehend their contents. FILE ACCESS The files may be obtained over the InterNet using a Web browser. Go to http://www.swarthmore.edu/SocSci/lwestph1/westphal.html and click on Obtain Download Files, which brings up the Web page from which they can be accessed. [An ascii, text only file (named read-me.txt) containing a copy of this document also resides in the directory.] The files are contained in three PK-Zip archive files, the contents of which are as follows (see further below for the distinction between table and text files): - bsc-stuf.zip, 134K: NTS-BNDC.WRD, 1_-B_NDC.EXL, NTS-OTHR.WRD; - otr-tbls.zip, 150K: all other table files (8 files in all); - data-fls.zip, 189K: all ascii, text only data files (7 files in all). NotaBene: NTS-OTHR.WRD contains a complete indication of the full contents of all indicators other than the Basic indicators, which are provided in 1_- B_NDC.EXL and documented in NTS-BNDC.WRD. OVERVIEW OF CONTENTS Indicators are provided for 25 industrialized and industrializing countries: Korea, Taiwan, Hong Kong, Singapore, China, Indonesia, Malaysia, Thailand, Philippines, Argentina, Brazil, Chile, Mexico, India, Pakistan, Turkey, Israel, Algeria, Egypt, Morocco, Britain, France, Germany, Japan, and United States. The data cover the period 1960 through 1990. Indicators typically involve annual averages over three year periods at roughly ten year intervals -- 1960- 62, 1969-71, 1979-81, and 1988-90 where feasible. With one exception, all indicators are the result of computations using generally available data; technology payment indicators (item 6 below) reflect original data assembly effort. Also original are the aggregation schemes used for production and trade indicators (item 3), as well as for capital goods trade indicators (item 5). An overview of the contents of the indicator files follows. 0. Explanatory Notes: Basic indicators; Other indicators - Computer Files: NTS-BNDC.WRD; NTS-OTHR.WRD. Explanatory notes -- definitions, sources, methods, etcetera -- for Basic and all other indicators respectively. "Other" indicators provide either additional overview data (Diverse indicators, item 2) or supplementary -- to the Basic indicators -- data in considerable detail (items 3 through 6). 1. Basic indicators - Computer File: 1_-B_NDC.EXL. Individual comparative tables include: 1, Growth performance; 2a&b, Macro indicators, 1&2; 3, Production and trade; 4, Structural change (3-digit); 5a, Technology acquisition; 5b, Direct foreign investment; 6, Capital goods (5-digit SITC,1); 7a, Local technological manpower; 7b, R&D expenditures; 8, Human capital formation; 9, Tertiary education; 10, Vocational education. 2. Diverse indicators: Comparative table - Computer Files: 2_-D_NDC.TXT/WRD. Miscellaneous indicators compiled on the way to the basic indicators. 3. Production and trade indicators, 3\4-digit ISIC: Country tables - Computer Files: 3A\B-P&T-3\4.TXT/WRD. Structure (i.e. composition) of gross output, value added, imports, and exports plus import to total supply and export to production ratios (or export to import ratios); for twelve\eleven sector aggregation (of 3\4-digit ISIC sectors), using matched production and trade data. The eleven sector aggregation scheme is premised on judgements of technological capability differences among sectors. 4. Structural change indicators, 3\4-digit ISIC: Comparative table - Computer Files: 4A\B-STC-3\4.TXT/WRD. Average absolute change and square root of average squared changes in sectoral shares of apparent consumption, gross output, imports, and exports; for 3\4 digit ISIC sectors (no aggregation), using matched production and trade data; includes sectoral details for growing and declining (relatively) sectors. 5. Capital goods trade indicators: Country tables - Computer Files: 5_-K_GDS.TXT/WRD. Composition of durable goods imports and exports classified as follows: end products -- agricultural machinery, plant equipment, electronic equipment, industrial machinery, transport equipment, consumer durables; (sub-) assemblies -- electronic, other; parts and components. Separate compilations are given for data under SITC,1 and SITC,2. 6. Technology payment indicators: A. Comparative table; B. Country tables - Computer Files: 6A-T_PAY.TXT/WRD; 6B-T_PAY.WRD. Aggregate technology payments made to France, Germany, Japan, the United Kingdom, and the United States; using data obtained from source countries (i.e., those receiving payment). FILE TYPES MS Word files: The following files are Macintosh MS Word files; they should be readily accessible using MS Word either for the Macintosh or for the IBM- compatible PC. [They may also be similarly accessible using other word processor programs with translators.] If necessary, they can be made available as WordPerfect 5.0 or 5.1 files, or (but not without perhaps considerable loss in formatting clarity) as ascii, text only files. - Explanatory notes re Basic indicators: Mac Word file name: NTS-BNDC.WRD; - Explanatory notes re (all) Other indicators: Mac Word file name: NTS-OTHR.WRD. - Table files from which the hardcopy, printed forms of the indicator tables were generated: Mac Word file names: na-text_.WRD, where "na-text_" identifies the particular indicator dataset). Microsoft Excel file: The following table cum data file is a Macintosh Excel 5.0 Workbook file; it should be readily accessible using Excel either for the Macintosh or for the IBM-compatible PC. [It may also be similarly accessible using other spreadsheet programs with translators.] - 1. Basic indicators: Comparative table -- Mac Excel file name: 1_-B_NDC.EXL. The Basic indicator tables (similarly, data) are contained in Sheets 1 through 13, respectively, of the Workbook, as indicated by the corresponding tab labels; Sheets 14,15,&16 are blank. All cells in the workbook are protected (or locked) against inadvertent changes in their contents; with Excel, the protection can be undone using the Protection command under Tools if desired. NotaBene: This is the ONLY data file which precisely matches the corresponding table. Ascii, text only files: Data (distinct from corresponding table) files for all other indicators are ascii, text only files which should be readily accessible using a word processor. These files diverge in format and, in some cases, content from the corresponding tables (refers both to hardcopy, printed form and corresponding ....WRD files). Nonetheless, they are formatted cum organized so that their correspondence (in row and column contents) to the corresponding tables can be discerned more or less readily with hardcopy in hand. All data in these files are provided in scientific notation; there is thus no loss of information due to rounding (as there is in the tables). [Note: These files can, without change, be printed (for example, by using the DOS copy command to copy them <individually> to a printer) in a well formatted form (use Courier font) if a small enough font is used. However, as pure ascii files, they do NOT include cum specify page formatting of any kind.] EXPLANATORY NOTES RE DATA FILES FOR OTHER INDICATORS The data files do NOT contain complete verbal labels sufficient to identify particular elements of the data. To identify data appearing in a particular data file, one must use the corresponding hardcopy and match data file values with those appearing in the hardcopy. Once done for any part of one file, the matching becomes a really quite simple task. One of the factors making it rather simple is the numbering of data blocks within the data files. Each data block is given a several digit number corresponding to the order of indicator (major and minor) groupings or divisions within the tables. The underlying logic of the numbering should become quickly apparent from an initial, quick perusal of the data files. For several files, the numbering scheme is identified below. Also to be noted is that lines of values appearing within blocks in the data files are labeled according to the pertinent year or period where appropriate. CAVEAT: Country-table information (i.e., effectively, country tables) are NOT in the same order, by country, in the data files as in the corresponding tables; however, the country labels provided in the data files are sufficient to readily identify individual countries to which data pertains. Values stated as percentages in tables are generally stated as shares or simple ratios (i.e., percentages divided by 100.0) in the data files. In turn, values stated in billions of US dollars in tables are typically stated as thousands of, or simply, U.S. dollars in the data files. In most cases, the units used in the data files are indicated by the labels. However, where they are not so indicated, one can (must) infer the units used in the data file by comparing values against corresponding values in the tables. The data files were generated independently and prior to the tables; accordingly, where there are discrepancies between corresponding values (as opposed to units) in a data file and the associated table, the value shown in the table is to be considered the correct value. [While every effort has been taken to assure that all discrepancies are noted below, there is no explicit or implicit guarantee that such is indeed the case.] 2. Diverse indicators: Comparative table -- Mac/DOS file name: 2_-D_NDC.TXT. All data are provided in three clusters: the first gives data for USA through HongKong; the second, Singapore through Israel; the third, Morocco through Thailand. Not present in this file, but present in the corresponding table, are the following: o Overall performance indicators -- - Annual growth rate of GDP per capita (at 1987 domestic prices): 1965-1980 values; - Annual growth rate of population: all values; - Incremental capital output ratio: 1961-1980; 1970-1990; - Annual inflation rate: all values. o Educational attainment indicators -- - Tertiary students studying abroad per 100,000 population: all values. 3. Production and trade indicators, 3/4-digit ISIC: Country tables -- Mac/DOS file names: 3A/B-P&T-3/4.TXT. There is nothing about these data files that warrants particular mention here. 4. Structural change indicators: 3/4-digit ISIC: Comparative table -- Mac/DOS file names: 4A/B-STC-3/4.TXT. All data are provided in two clusters: the first gives data for USA through Mexico; the second, Algeria through Thailand. Labels for each block of data are given by a 3-digit code (x.y.z): - x = 3,4: indicators derived from 3,4-digit ISIC data; - y = 1, domestic supply; 2, production; 3, imports; 4, exports. - z = 1, average absolute change in sectoral shares; 2, square root of average squared change; 3, growing sectors; 4, shrinking sectors. 5. Capital goods trade indicators: Country tables -- Mac/DOS file name: 5_- K_GDS.TXT. There is nothing about this data file that warrants particular mention here. 6. Technology payment indicators: Comparative table -- Mac/DOS file name: 6A-T-PAY.TXT. Labels for each block of data are given by a 2-digit code (x.y): - x = 1, manufacturing; 2, industry; - y = 1, unadjusted average contemporaneous ratios of licensing payments to value added; 2, adjusted ratios, 5-year intervals; 3, adjusted ratios, 10-year intervals; 4, adjusted ratios, 25-year interval; 5, adjusted ratios, benchmark intervals. Note: No data file corresponding to table 6B (Country tables) is provided.