Spreadsheet: 269646d1381240325-combining-a-spreadsheet-into-a-column-on-a-different-spreadsheet-pa_naic_5_lq-1
Sheet: Pa LQ5

NAICS-5 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
22112 | 1.02 | 0.98 | 1.13 | 1.12 | 1.24 | 0.93 | 0.92 | 0.96 | 0.95 | 0.71 | 0.73 | 0.76
23611
23721
23731
23811
23816
23821 | 0.8 | 0.82 | 0.83 | 0.79 | 0.78 | 0.77 | 0.78 | 0.78 | 0.79 | 0.81 | 0.8 | 0.8
23822 | 0.94 | 0.93 | 0.93 | 0.89 | 0.88 | 0.88 | 0.89 | 0.89 | 0.92 | 0.93 | 0.95 | 0.94
23839 | 0.66 | 0.68 | 0.56 | 0.56 | 0.57 | 0.6 | 0.64 | 0.69 | 0.73 | 0.81 | 0.88 | 0.95
23891 | 1.09 | 1.11 | 1.11 | 1.11 | 1.1 | 1.09 | 1.13 | 1.19 | 1.23 | 1.3 | 1.36 | 1.33
23899 | 0.91 | 0.9 | 0.85 | 0.84 | 0.81 | 0.79 | 0.8 | 0.82 | 0.84 | 0.88 | 0.91 | 0.95
31193 | 0.59 | 0.59 | 0.57 | 0.61 | 0.62 | 0.45 | 0.46 | ND | ND | 0.48 | 0.69 | 0.73
31521 | 1.51 | 1.36 | 1.24 | 1.16 | 1.03 | 0.9 | 0.49 | 0.46 | 0.34 | 0.33 | 0.32 | 0.3
31523 | 0.93 | 0.88 | 0.85 | 1 | 1.43 | 1.5 | 1.43 | 1.36 | 1.34 | 1.33 | NC | NC
32191 | 0.74 | 0.85 | 0.91 | 0.89 | 0.91 | 0.82 | 0.84 | 0.85 | 0.9 | 0.88 | 0.87 | 0.97
32221 | 1.2 | 1.22 | 1.21 | 1.21 | 1.15 | 1.19 | 1.21 | 1.2 | 1.22 | 1.25 | 1.22 | 1.23
32229 | 2.52 | 2.56 | 2.58 | 2.67 | 2.85 | 2.89 | 2.95 | 3.06 | 3.16 | 3.12 | 3.11 | 3.19
32311 | 1.29 | 1.29 | 1.3 | 1.29 | 1.3 | 1.3 | 1.29 | 1.29 | 1.29 | 1.3 | 1.29 | 1.28
32513 | 1.76 | 1.76 | 1.79 | 1.77 | 1.88 | 1.93 | 1.92 | 1.93 | 1.91 | 2 | 2.2 | 2.23
32541 | 2.07 | 2.08 | 2.08 | 1.84 | 1.73 | 1.77 | 1.73 | 1.77 | 1.73 | 1.71 | 1.69 | 1.61
33232 | 1.46 | 1.42 | 1.37 | 1.33 | 1.35 | 1.29 | 1.31 | 1.37 | 1.4 | 1.36 | 1.32 | 1.29
33281 | 0.93 | 0.99 | 1.02 | 1.08 | 1.07 | 1.07 | 0.98 | 1 | 1.02 | 1 | 0.96 | 0.95
33331 | 1.09 | 1.04 | 1.04 | 1.04 | 0.93 | 0.99 | 1.08 | 1.11 | 0.98 | 0.92 | 0.89 | 0.84
33341 | 0.98 | 0.97 | 0.91 | 0.94 | 0.99 | 0.92 | 0.88 | 0.94 | 0.95 | 0.87 | 0.85 | 0.91
33411 | 0.32 | ND | 0.35 | 0.33 | 0.34 | 0.3 | 0.29 | 0.26 | 0.22 | 0.23 | 0.2 | 0.21
33441 | 0.94 | 0.85 | 0.73 | 0.68 | 0.64 | 0.66 | 0.67 | 0.68 | 0.7 | 0.69 | 0.69 | 0.69
33631 | 0.33 | 0.28 | 0.22 | 0.2 | 0.15 | 0.17 | 0.14 | 0.1 | 0.12 | ND | 0.64 | 0.47
33651 | 7.19 | 7.43 | 6.74 | 6.45 | 6.21 | 5.95 | 5.98 | 6.33 | 6.79 | 7.12 | 7.34 | 7.02
33721 | 0.84 | 0.77 | 0.82 | 0.82 | 0.9 | 0.89 | 0.92 | 0.93 | 0.96 | 0.96 | 1.03 | 1.08
33911 | 1.34 | 1.37 | 1.39 | 1.33 | 1.32 | 1.3 | 1.27 | 1.2 | 1.13 | 1.1 | 1.08 | 1.07
33999 | 1.01 | 1.03 | 1.01 | 1.05 | 1.1 | 1.13 | 1.17 | 1.17 | 1.22 | 1.21 | 1.2 | 1.26
42331 | 1.15 | 1.15 | 1.08 | 1.04 | 1.04 | 1.07 | 1.06 | 1.11 | 1.15 | 1.17 | 1.18 | 1.19
42332 | 0.75 | 0.74 | 0.74 | 0.79 | 0.73 | 0.76 | 0.74 | 0.77 | 0.81 | 0.88 | 0.94 | 1.04
42333 | 1.23 | 1.26 | 1.22 | 1.23 | 1.22 | 1.22 | 1.27 | 1.27 | 1.27 | 1.27 | 1.3 | 1.27
42361 | 0.81 | 0.84 | 0.83 | 0.81 | 0.86 | 0.89 | 0.9 | 0.93 | 0.93 | 0.93 | 0.94 | 0.95
42362 | 0.95 | 0.97 | 0.95 | 1.04 | 1.01 | 0.92 | 0.97 | 0.89 | 0.91 | 0.79 | 0.87 | 0.93
42383 | 0.84 | 0.83 | 0.82 | 0.84 | 0.87 | 0.9 | 0.89 | 0.89 | 0.89 | 0.92 | 0.94 | 0.94
42391 | 0.67 | 0.67 | 0.69 | 0.69 | 0.67 | 0.63 | 0.72 | 0.74 | 0.76 | 0.77 | 0.73 | 0.69
42399 | 0.55 | 0.58 | 0.58 | 0.84 | 0.88 | 0.91 | 1 | 0.92 | 0.91 | 0.89 | 0.87 | 0.89
42413 | 0.83 | 0.8 | 0.8 | 1.07 | 1.1 | 1.11 | 1.14 | 1.16 | 1.18 | 1.16 | 1.19 | 1.14
42421 | 1.04 | 1.1 | 1.16 | 0.99 | 0.83 | 0.85 | 0.82 | 1 | 0.99 | 0.9 | 0.9 | 0.9
42433 | 0.29 | 0.28 | 0.27 | 0.21 | 0.18 | 0.18 | 0.19 | 0.27 | 0.25 | 0.26 | 0.22 | 0.21
42443 | 0.71 | 0.72 | 0.64 | 0.55 | 0.49 | 0.61 | 0.63 | 0.58 | 0.6 | 0.56 | 0.55 | 0.57
42447 | 0.93 | 1 | 1.01 | 0.95 | 0.98 | 0.91 | 0.86 | 0.86 | 0.84 | 0.83 | 0.83 | 0.87
42449 | 0.63 | 0.68 | 0.73 | 0.78 | 0.75 | 0.74 | 0.71 | 0.73 | 0.73 | 0.77 | 0.78 | 0.8
42459 | 0.31 | 0.29 | 0.29 | 0.33 | 0.51 | 0.66 | 0.68 | 0.47 | 0.44 | 0.42 | 0.44 | 0.53
42481 | 0.64 | 0.64 | 0.64 | 0.69 | 0.73 | 0.75 | 0.77 | 0.75 | 0.71 | 0.72 | 0.71 | 0.7
42499 | 0.74 | 0.87 | 0.65 | 0.6 | 0.54 | 0.54 | 0.51 | 0.42 | 0.48 | 0.49 | 0.45 | 0.43
44112 | 0.97 | 0.96 | 0.95 | 0.98 | 0.97 | 0.98 | 0.96 | 0.98 | 1.02 | 1.03 | 1.05 | 1.07
44419 | 0.71 | 0.71 | 0.71 | 0.71 | 0.71 | 0.64 | 0.65 | 0.68 | 0.69 | 0.69 | 0.68 | 0.67
44529 | 0.99 | 1.13 | 1.29 | 1.35 | 1.34 | 1.22 | 1.05 | 1.01 | 1 | 0.93 | 0.92 | 0.87
44599
44812 | 0.98 | 0.97 | 0.97 | 0.87 | 0.9 | 0.87 | 0.86 | 0.85 | 0.76 | 0.76 | 0.74 | 0.74
44814 | 0.77 | 0.82 | 0.85 | 0.89 | 0.85 | 0.88 | 0.92 | 0.9 | 0.98 | 0.97 | 1.1 | 1.07
44819 | 1.05 | 1.06 | 1.09 | 1.1 | 1.06 | 1.03 | 0.98 | 0.96 | 0.97 | 0.96 | 0.95 | 0.9
45321 | 0.81 | 0.79 | 0.78 | 0.74 | 0.76 | 0.77 | 0.78 | 0.76 | 0.76 | 0.75 | 0.71 | 0.7
45399 | 1.17 | 1.17 | 1.23 | 1.27 | 1.28 | 1.3 | 1.34 | 1.32 | 1.31 | 1.07 | 1.09 | 1.11
45439 | 0.7 | 0.78 | 1.1 | 1.1 | 1.14 | 1.1 | 1.04 | 1 | 0.99 | 1.02 | 1.09 | 1.06
48311 | 0.43 | 0.38 | 0.4 | 0.35 | 0.3 | 0.3 | 0.3 | 0.3 | 0.27 | 0.23 | 0.19 | 0.17
48412 | 1.23 | 1.24 | 1.19 | 1.12 | 1.08 | 1.08 | 1.1 | 1.1 | 1.06 | 1.05 | 1.03 | 1.02
48421 | 0.72 | 0.7 | 0.76 | 0.8 | 0.8 | 0.84 | 0.83 | 0.83 | 0.81 | 0.78 | 0.74 | 0.71
48711 | 0.42 | 0.64 | 0.75 | 0.98 | 1.11 | 1.08 | 1.11 | 1.1 | 1.02 | 1.05 | 1.1 | 1.03
48832 | 0.72 | 0.71 | 0.71 | 0.7 | 0.7 | 0.72 | 0.62 | 0.57 | 0.59 | 0.54 | 0.58 | 0.53
48839 | 0.36 | 0.38 | 0.42 | 0.49 | 0.24 | 0.27 | 0.32 | 0.31 | 0.33 | 0.33 | 0.19 | 0.17
48851 | 0.57 | 0.57 | 0.54 | 0.56 | 0.54 | 0.51 | 0.51 | 0.52 | 0.53 | 0.53 | 0.53 | 0.54
49311 | 1.37 | 1.44 | 1.58 | 1.65 | 1.76 | 2.01 | 2.13 | 2.16 | 2.19 | 2.2 | 2.23 | 2.18
49319 | 0.8 | 0.8 | 0.81 | 0.93 | 1.08 | 1.13 | 1.11 | 0.98 | 0.98 | 0.95 | 0.85 | 0.86
51121 | 0.4 | 0.42 | 0.44 | 0.4 | 0.36 | 0.4 | 0.38 | 0.4 | 0.46 | 0.46 | 0.45 | 0.39
51791 | 0.5 | 0.36 | 0.35 | 0.4 | 0.42 | 0.44 | 0.41 | 0.41 | 0.4 | 0.4 | 0.38 | 0.39
52229 | 0.65 | 0.64 | 0.6 | 0.58 | 0.54 | 0.5 | 0.48 | 0.45 | 0.44 | 0.46 | 0.47 | 0.59
52231 | 0.58 | 0.6 | 0.63 | 0.64 | 0.63 | 0.7 | 0.77 | 0.8 | 0.66 | 0.62 | 0.56 | 0.55
52239 | 0.72 | 0.78 | 1.02 | 0.98 | 0.99 | 0.92 | 0.89 | 0.82 | 0.66 | 0.65 | 0.84 | 0.41
52311 | 0.33 | 0.34 | 0.41 | 0.43 | 0.42 | 0.41 | 0.31 | 0.33 | 0.34 | 0.34 | 0.32 | 0.33
52312 | 0.83 | 0.85 | 0.92 | 0.9 | 0.86 | 0.75 | 0.75 | 0.76 | 0.75 | 0.73 | 0.72 | 0.61
52314 | 0.06 | 0.06 | 0.07 | 0.08 | 0.07 | 0.09 | ND | 0.09 | 0.07 | 0.1 | 0.08 | 0.08
52391 | 0.27 | ND | 0.24 | ND | ND | ND | 0.26 | 0.25 | 0.28 | 0.32 | 0.34 | 0.35
52392 | 1.05 | 1 | 0.95 | 1.24 | 1.17 | 1.16 | 1.24 | 1.21 | 1.39 | 1.33 | 1.29 | 1.48
52393 | 1.04 | 1.22 | 1.18 | 1.18 | 1.05 | 1.09 | 1 | 0.95 | 0.88 | 0.83 | 0.85 | 0.81
52399 | 0.85 | 0.73 | 0.39 | 0.4 | 0.38 | 0.31 | 0.81 | 0.86 | 0.9 | 0.91 | 0.93 | 1.02
52421 | 0.93 | 0.92 | 0.93 | 0.93 | 0.92 | 0.91 | 0.9 | 0.87 | 0.86 | 0.85 | 0.86 | 0.86
52429 | 1.57 | 1.56 | 1.55 | 1.67 | 1.59 | 1.63 | 1.56 | 1.5 | 1.54 | 1.52 | 1.47 | 1.42
52591 | ND | ND | ND | ND | ND | 10.17 | ND | 10.47 | ND | ND | ND | ND
52592 | 1.43 | 1.37 | 1.32 | 1.1 | 1.13 | 1.23 | 1.25 | 1.39 | 1.23 | 1.11 | 1.15 | 1.19
52593 | 0.38 | 0.25 | ND | ND | ND | 0.29 | NC | NC | NC | NC | NC | NC
52599 | 0.28 | 0.28 | 0.9 | 1.35 | 1.45 | 0.97 | ND | 0.37 | ND | ND | ND | ND
53111 | 0.8 | 0.78 | 0.7 | 0.71 | 0.75 | 0.74 | 0.76 | 0.73 | 0.71 | 0.71 | 0.73 | 0.73
53112 | 0.96 | 0.99 | 0.96 | 0.91 | 0.95 | 0.93 | 0.91 | 0.91 | 0.88 | 0.84 | 0.83 | 0.82
53113 | 0.45 | 0.41 | 0.39 | 0.36 | 0.37 | 0.39 | 0.41 | 0.4 | 0.48 | 0.49 | 0.44 | 0.43
53119 | 0.46 | 0.46 | 0.48 | 0.47 | 0.49 | 0.52 | 0.51 | 0.48 | 0.46 | 0.45 | 0.48 | 0.5
53121 | 0.75 | 0.74 | 0.74 | 0.73 | 0.7 | 0.69 | 0.65 | 0.66 | 0.65 | 0.65 | 0.63 | 0.63
53131 | 0.58 | 0.59 | 0.59 | 0.55 | 0.54 | 0.54 | 0.54 | 0.54 | 0.51 | 0.49 | 0.48 | 0.48
53139 | 0.77 | 0.7 | 0.73 | 1.06 | 1.03 | 1.04 | 1.11 | 1.13 | 1.11 | 0.92 | 0.94 | 0.84
53311 | 0.8 | 0.78 | 0.76 | 0.83 | 0.88 | 1.1 | 0.97 | 0.96 | 0.74 | 0.78 | 0.82 | 0.83
54111 | 1.02 | 1.01 | 1 | 1 | 1.01 | 1.01 | 1.01 | 0.99 | 0.97 | 0.96 | 0.96 | 0.97
54119 | 0.99 | 0.97 | 1.11 | 1.21 | 1.3 | 1.48 | 1.62 | 1.77 | 1.84 | 1.74 | 1.76 | 1.74
54133 | 0.96 | 0.94 | 0.92 | 0.92 | 0.91 | 0.91 | 0.91 | 0.92 | 0.93 | 0.94 | 0.96 | 0.97
54138 | 1.18 | 1.15 | 1.14 | 1.19 | 1.01 | 1.07 | 1.07 | 1.12 | 1.13 | 1.14 | 1.14 | 1.29
54143 | 0.95 | 1.02 | 1.04 | 0.95 | 0.92 | 0.91 | 0.82 | 0.8 | 0.83 | 0.82 | 0.75 | 0.68
54151 | 0.69 | 0.76 | 0.75 | 0.83 | 0.84 | 0.83 | 0.81 | 0.81 | 0.83 | 0.81 | 0.8 | 0.82
54161 | 1.27 | 1.32 | 1.34 | 1.14 | 1.14 | 1.14 | 1.1 | 1.04 | 1 | 0.98 | 0.97 | 0.99
54169 | 0.81 | 0.75 | 0.68 | 0.76 | 0.74 | 0.5 | 0.52 | 0.51 | 0.57 | 0.58 | 0.59 | 0.58
54171 | 0.93 | 0.97 | 0.96 | 1.07 | 1.24 | 1.29 | 1.28 | 1.21 | 1.17 | 1.15 | 1.09 | 1.08
54172 | 1.03 | 1.02 | 1.08 | 1.15 | 0.81 | 0.86 | 0.89 | 0.94 | 0.9 | 0.6 | 0.62 | 0.57
54181 | 0.79 | 0.76 | 0.74 | 0.74 | 0.73 | 0.74 | 0.75 | 0.73 | 0.72 | 0.69 | 0.67 | 0.68
54186 | 1.79 | 1.75 | 1.82 | 2.12 | 2.17 | 2.09 | 2.09 | 2.06 | 1.83 | 1.82 | 1.82 | 1.86
54189 | 0.56 | 0.61 | 0.66 | 0.64 | 0.68 | 0.66 | 0.68 | 0.77 | 0.77 | 0.69 | 0.64 | 0.66
54199 | 1.64 | 1.61 | 1.67 | 1.73 | 1.59 | 1.48 | 1.28 | 1.21 | 1.12 | 1.13 | 1.13 | 1.2
55111 | 0.73 | 0.78 | 0.87 | 0.99 | 1.11 | 1.21 | 1.34 | 1.35 | 1.38 | 1.42 | 1.44 | 1.46
56131 | 0.95 | 1.04 | 1.09 | 1.18 | 1.03 | 0.92 | 0.9 | 0.75 | 0.35 | 0.33 | 0.3 | 0.28
56144 | 1.04 | 1.08 | 1.07 | 1.05 | 1.08 | 1.2 | 1.22 | 1.18 | 1.08 | 1.04 | 1 | 0.91
56145 | 2.45 | 2.54 | 2.67 | 2.66 | 2.36 | 1.52 | 1.44 | 1.46 | 1.53 | 1.67 | 1.74 | 1.92
56149 | 0.99 | 1 | 0.93 | 0.99 | 0.89 | 0.96 | 0.88 | 0.76 | 0.85 | 0.83 | 0.81 | 0.82
56161 | 0.88 | 0.88 | 0.89 | 0.89 | 0.91 | 0.92 | 0.92 | 0.9 | 0.88 | 0.9 | 0.91 | 0.94
56173 | 0.88 | 0.87 | 0.9 | 0.9 | 0.86 | 0.88 | 0.84 | 0.85 | 0.85 | 0.89 | 0.9 | 0.91
56221 | 1.36 | 1.29 | 1.29 | 1.39 | 1.42 | 0.96 | 0.97 | 0.98 | 0.93 | 0.84 | 0.77 | 0.79
61131 | 2.35 | 2.34 | 2.29 | 2.25 | 2.27 | 2.25 | 2.22 | 2.2 | 2.15 | 2.13 | 2.09 | 2.08
62111 | 1.04 | 1.02 | 1.03 | 1.02 | 1.03 | 1.06 | 1.09 | 1.08 | 1.07 | 1.05 | 1.05 | 1.04
62141 | 1.99 | 1.97 | 2.19 | 1.73 | 1.87 | 1.7 | 1.73 | 1.62 | 1.55 | 1.44 | 0.94 | 0.77
62149 | 1.02 | 1.06 | 1.15 | 1.21 | 1.16 | 1.08 | 0.97 | 0.95 | 0.91 | 0.84 | 0.82 | 0.91
72211 | 0.92 | 0.93 | 0.93 | 0.93 | 0.94 | 0.91 | 0.92 | 0.9 | 0.88 | 0.87 | NC | NC
72232 | 0.89 | 0.99 | 1.07 | 1.05 | 1.05 | 1.06 | 1.08 | 1.03 | 0.99 | 0.99 | 0.97 | 0.95
81111 | 1.12 | 1.11 | 1.12 | 1.14 | 1.15 | 1.15 | 1.15 | 1.17 | 1.15 | 1.16 | 1.17 | 1.18
81121 | 0.81 | 0.86 | 0.92 | 0.88 | 0.95 | 0.83 | 0.83 | 0.86 | 0.93 | 0.92 | 0.86 | 0.92
81293 | 1.03 | 1.04 | 1.04 | 1.01 | 0.96 | 0.97 | 0.94 | 0.88 | 0.87 | 0.83 | 0.82 | 0.86
81299 | 0.9 | 1.34 | 1.38 | 1.19 | 1.03 | 1.01 | 0.69 | 0.7 | 0.65 | 0.58 | 0.54 | 0.51
81393 | 1.45 | 1.42 | 1.4 | 1.43 | 1.45 | 1.45 | 1.44 | 1.43 | 1.42 | 1.4 | 1.41 | 1.42