Your browser doesn't support Javascript. USA Counties Information Basic Information (e.g. USA Counties™ data, Flag_reference, etc. Dvdfab Blu-ray Copy For Mac Crack more. ) (CenStats) I. Parts of Excel Spreadsheet Parts of the Excel Spreadsheet Part: Description: A, B, C, & D Four columns providing flag, datavalue, footnote1, and footnote2 data of original AFN110197D data source. Each additional data source will require four Excel columns, e.g. [Excel columns G, H, I, and J], or [Excel columns K, L, M, and N], etc.

Concordances-a description of the direct relationshp between classification systems - North American Industry Classification System (NAICS) - US Census Bureau.

(Excel spreadsheet columns C and continuing right) A Flag column header - e.g. AFN110197F - flag data stored in this column (Excel spreadsheet column C) from rows 2 to 3197. B DataValue column header - e.g. AFN110197D - data values stored in this column (Excel spreadsheet column D) from rows 2 to 3197. C Footnote1 column header - e.g. AFN110197N1 - footnote1 values stored in this column (Excel spreadsheet column E) from rows 2 to 3197. D Footnote2 column header - e.g.

AFN110197N2 - footnote2 values stored in this column (Excel spreadsheet column F) from rows 2 to 3197. E Column E header 'Areaname' located in cell A1 - Areaname values stored in Excel cells A2 to A3197. F Microsoft standard column references, e.g. A, B, C, D, etc. G Code column header - FIPS State and County Code stored in this column (Excel spreadhseet column B) from rows 2 to 3197. H Microsoft standard row numbers, e.g. 1, 2, 3, 4, 5.

I Sample of areaname values - values refer to 1) UNITED STATES, 2) a state name, or 3) a county name followed by comma and state abbreviation. (Excel spreadsheet column A) J Sample of STCOU values - text 5 positions - first two positions refer to state code and last three positions refer to county code.

It should be noted that all states have '000' in their last three positions, e.g. Moreover, the UNITED STATES code is always '00000'. (Excel spreadsheet column B) K Sample of FLAG values - integer value of 0, 1, 2, 3, 4, 5, 6, 7 or 8.(Excel spreadsheet column C) L Sample of Data values - long integer format e.g., 545068, 6955, 50, etc. (Excel spreadsheet column D) M Sample of Footnote1 values - text 4 positions - each unique footnote code has corresponding note which is available in the MASTFOOT table. (Excel spreadsheet column E) N Sample of Footnote2 values - text 4 positions - each unique footnote code has corresponding note which is available in the MASTFOOT table.

(Excel spreadsheet column F) NOTE: More detail about data source (Excel column) names is available at and more detail about table (column) groups is available at II. Four Excel Columns in Reference to One Data Source Deciphering data group names Data groups names have four components: • 3-letter abbreviation/acronymn • 3-digit subgroup-code • 3-digit year code • First number represents the century (1 = a year in the 20th century, ie. 1997; 2 = a year in the 21st century, ie. • Last two numbers represent the year. • data type: F = flag, D = data value, N1 = Footnote 1, N2 = Footnote 2 For example the data group, AFN110197D, would be: • AFN - Accommodation and Food Services - NAICS Only • 110 - subgroup 110 • 197 - 1997 • D - data value Explanation of data group names and table structure Part: Description: A The first three characters make up a three-character abbreviation (acronym) for a particular data group. In this case, 'AFN' stands for 'Accommodation and Food Services - NAICS Only.' All acronyms and their corresponding title are available in the Excel file MASTGROUPS.xls.