{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Title","Narrative Summary","Construction Impact Model","Capital Costs","Project Element Description","RIMS II Table 2.5","Full & Part-Time","FTE","Deflator"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":137,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[7,0,7,3],[8,0,8,3],[13,0,13,3]]}
[]
[]
[]
[]
[]
[]
[]
["US 27 PALMETTO Economic Impact Calculations"]
["US 27 Palmetto - US 27/SR 25 - SR 826 Improvements"]
[]
[]
[]
[]
["This Excel spreadsheet provides the backup calculations for the construction economic impact analysis of the US Palmetto Project. It contains 8 sheets or tabs as described below. "]
[]
["Sheet #","Name","Link to Sheet","Contents"]
[1,{"$f":"INDEX(SheetNames,A17)","v":"Title"},{"$f":"HYPERLINK(\"#'\"&B17&\"'!A1\",\"Go To Sheet\")","v":"Go To Sheet"},"Table of Contents"]
[{"$f":"A17+1","v":2},{"$f":"INDEX(SheetNames,A18)","v":"Sheet1"},{"$f":"HYPERLINK(\"#'\"&B18&\"'!A1\",\"Go To Sheet\")","v":"Go To Sheet"},"Calculation of construction period economic output, earnings, and jobs for study area"]
[{"$f":"A18+1","v":3},"Construction Impact Model",{"$f":"HYPERLINK(\"#'\"&B19&\"'!A1\",\"Go To Sheet\")","v":"Go To Sheet"},"Project capital cost summary for construction"]
[4,"Capital Costs","Go To Sheet","Project description"]
[5,"Project Element Description","Go To Sheet","RIMS II Table 2.5 Total Multipliers - industry aggregations for Miami-Dade & Broward counties"]
[6,"RIMS II Table 2.5","Go To Sheet","BEA Table 6.4D. Full-Time and Part-Time Employees by Industry"]
[7,"Full & Part-Time","Go To Sheet","BEA Table 6.5D. Full-Time Equivalent Employees by Industry"]
[8,"FTE","Go To Sheet","Implicit price deflators for GDP"]
[9,"Deflator","Go To Sheet","Summary of economic impacts"]
[10,{"$error":"#REF!"},{"$error":"#REF!"},"Summary of long-term economic output, earnings, and jobs from project"]
[11,{"$error":"#REF!"},{"$error":"#REF!"},"Calculation of long-term economic output, earnings, and jobs from project"]
[12,{"$error":"#REF!"},{"$error":"#REF!"},"Project description"]
[13,{"$error":"#REF!"},{"$error":"#REF!"},"Project capital cost summary for construction"]
[14,{"$error":"#REF!"},{"$error":"#REF!"},"Estimated build and no-build O&M cost in 2018 dollars"]
[15,{"$error":"#REF!"},{"$error":"#REF!"},"RIMS II Table 1.5 Total Multipliers - detailed industries for Miami-Dade & Broward counties"]
[16,{"$error":"#REF!"},{"$error":"#REF!"},"Implicit price deflators for GDP"]
[17,{"$error":"#REF!"},{"$error":"#REF!"}]
[18,{"$error":"#REF!"},{"$error":"#REF!"}]
[19,{"$error":"#REF!"},{"$error":"#REF!"}]
[20,{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"A36+1","v":21},{"$f":"INDEX(SheetNames,A37)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[22,{"$error":"#REF!"},{"$error":"#REF!"}]
[23,{"$f":"INDEX(SheetNames,A39)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[24,{"$error":"#REF!"},{"$error":"#REF!"}]
[25,{"$error":"#REF!"},{"$error":"#REF!"}]
[26,{"$error":"#REF!"},{"$error":"#REF!"}]
[27,{"$error":"#REF!"},{"$error":"#REF!"}]
[28,{"$error":"#REF!"},{"$error":"#REF!"}]
[29,{"$error":"#REF!"},{"$error":"#REF!"}]
[30,{"$error":"#REF!"},{"$error":"#REF!"}]
[31,{"$error":"#REF!"},{"$error":"#REF!"}]
[32,{"$error":"#REF!"},{"$error":"#REF!"}]
[33,{"$f":"INDEX(SheetNames,A49)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[34,{"$error":"#REF!"},{"$error":"#REF!"}]
[35,{"$error":"#REF!"},{"$error":"#REF!"}]
[36,{"$error":"#REF!"},{"$error":"#REF!"}]
[37,{"$error":"#REF!"},{"$error":"#REF!"}]
[38,{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Narrative Summary","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,0,10,4],[3,0,3,11],[4,0,4,11],[18,0,18,11],[19,0,19,11],[5,0,5,11],[7,0,7,11]]}
["US 27 PALMETTO Interchange Project"]
["Job Creation and Economic Stimulus "]
["Overview"]
["The economic impact analysis focused on the job creation and economic stimulus that would be created by the US 27 Palmetto Project. It addresses the effect of the expenditure of construction funds. and the resulting, ongoing commercial benefits for the project. These benefits are in addition to the user and public benefits estimated for the BCA. The economic analysis estimates the economic output, earnings, and jobs from design and construction spending in Miami-Dade and Broward counties, which would occur primarily during the assumed design and construction period of 2025 through 2028. "]
["This study uses RIMS II multipliers produced by the Bureau of Economic Analysis (BEA) Regional Input‐Output Modeling System (RIMS II). This analysis applies the multipliers to project costs and/or jobs to estimate the economic impacts. The BEA has provided regional input‐output multipliers since the early 1970s as a tool to help economists analyze the potential impacts of economic activities like the GGTTC on regional economies. Given spending such as capital costs or O&M costs as an input, the input-output multiplier estimates economic in terms of total economic output, earnings, and jobs for Miami-Dade and Broward counties. In this analysis, the multipliers for Miami-Dade and Broward counties were applied to the estimated final design and construction costs for the construction-related spending effects. \n\nThe methodology and detailed assumptions are described in the economic analysis spreadsheet that applies the RIMS II multipliers to costs. \n \nSummary of Results\nTable 1 summarizes the construction spending impacts which would occur roughly over the construction period of 2025 through 2028, although minor effects of planning and preliminary design costs occur earlier.  Costs of $196.1 million (excluding right-of-way and preliminary costs) are estimated to give rise to economic output of about $394 million in Miami-Dade and Broward counties. Earnings would total about $136 million, corresponding to about 2,800 full-time equivalent (FTE) job years. Each million dollars of construction expenditure would generate about $2 million in additional economic output and around 14 jobs in the local economy. The jobs include direct jobs, indirect jobs from suppliers, and induced jobs from increased household spending. \nOverview"]
["The methodology and detailed assumptions are described in the economic analysis spreadsheet that applies the RIMS II multipliers to costs.[1] "]
[]
["Table 1 summarizes the construction spending impacts which would occur roughly over the construction period of 2025 through 2028, although minor effects of planning and preliminary design costs occur earlier.[2] Costs of $196.1 million (excluding right-of-way and preliminary costs) are estimated to give rise to economic output of about $394 million in Miami-Dade and Broward counties. Earnings would total about $136 million, corresponding to about 2,800 full-time equivalent (FTE) job years. Each million dollars of construction expenditure would generate about $2 million in additional economic output and around 14 jobs in the local economy. The jobs include direct jobs, indirect jobs from suppliers, and induced jobs from increased household spending. "]
[]
["Table 1 - Construction Economic Impact in Miami-Dade and Broward Counties"]
["(Millions 2020 Dollars, FTE Job Years)"]
["Cost Category","Cost","Output","Earnings","Jobs"]
["Construction",196.1,393.92,135.52000000000001,2800]
["ROW",0,"-","-","-"]
["Total",196.1,393.9,135.5,2800]
["Source: Atkins 2022"]
[]
[]
["[1] US 27 Construction Economic Impact.xlsm, Atkins, 2022."]
["[2] An earlier $1.4 million in preliminary project costs would have already had their impact, and the construction-period spending impacts would take several quarters after the end of construction to complete their ripple through the local economy."]

{"sheet":"Construction Impact Model","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,1,7,3],[7,4,7,6],[15,0,15,4],[16,0,16,4],[6,0,6,3]]}
["Construction Economic Impact Model - Miami-Dade and Broward Counties"]
["2022-04-20"]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]
["The job multipliers are inflated to 2020 $ and adjusted to give full-time equivalent (FTE) employment."]
[]
[]
["RIMS II Multipliers"]
[null,"Construction"]
["Year","Output","Earnings","Jobs"]
[2017,{"$f":"'RIMS II Table 2.5'!C12","v":2.0091999999999999},{"$f":"'RIMS II Table 2.5'!D12","v":0.69120000000000004},{"$f":"'RIMS II Table 2.5'!E12","v":15.538600000000001}]
["2020*",{"$f":"B10","v":2.0091999999999999},{"$f":"C10","v":0.69120000000000004},{"$f":"D10/Deflator!B21","v":14.73178176650711}]
["Correction to FTE",{"$f":"B10","v":2.0091999999999999},{"$f":"C10","v":0.69120000000000004},{"$f":"D11*'Full & Part-Time'!M19","v":14.234153683595776}]
["Source: Bureau of Economic Analysis, US Department of Commerce, 2019 and 2022; Atkins, 2022. "]
["*Job multipliers are adjusted by GDP deflator"]
[]
["Short-Term Construction Economic Impact in Miami-Dade and Broward Counties"]
["(Millions 2020 Dollars, FTE Job Years)"]
["Cost Category","Cost","Output","Earnings","Jobs"]
["Construction",{"$f":"'Capital Costs'!D14/1000000","v":196.059721},{"$f":"B19*B12","v":393.92319143319997},{"$f":"B19*C12","v":135.51647915520002},{"$f":"ROUND(D12*B19,-2)","v":2800}]
["ROW",0,"-","-","-"]
["Total",{"$f":"SUM(B19:B20)","v":196.059721},{"$f":"SUM(C19:C19)","v":393.92319143319997},{"$f":"SUM(D19:D19)","v":135.51647915520002},{"$f":"SUM(E19:E19)","v":2800}]
["Source: Atkins, 2022."]
[]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]

{"sheet":"Capital Costs","index":3,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,1,18,3]]}
["Capital Costs - 2020 $"]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]
[]
[]
[null,"Planning & Design",1385442]
[null,"Right-of-Way",2773038]
["Construction"]
[null,"Construction",168059923]
[null,"Utilities",2512099,{"$f":"C8+C9","v":170572022}]
[null,"Contract Bonus",4200000]
[null,"Construction Engineering",21287699]
[null,"Mitigation",0]
[null,"Total Cost",{"$f":"SUM(C5:C12)","v":200218201},{"$f":"C13-C6","v":197445163},"w/o R/W"]
[null,null,null,{"$f":"C13-SUM(C5:C6)","v":196059721},"Costs without R/W and preliminary activities but including final design. "]
[]
[null,"Phase of Capital Costs (Year)"]
[null,"Capital Costs ($)"]
[]
[null,"Table ES-2. Capital (Eligible Project) Costs by Year (2020 $)"]
[null,"Year","Alternative"]
[null,2020,{"$f":"C5+C6","v":4158480},null,"Final Design and Right-of-way",null,4852508]
[null,2021,0]
[null,2022,0]
[null,2023,0]
[null,2024,0]
[null,2025,{"$f":"SUM($C$8:$C$11)*0.1","v":19605972.100000001}]
[null,2026,{"$f":"SUM($C$8:$C$11)*0.4","v":78423888.400000006}]
[null,2027,{"$f":"SUM($C$8:$C$11)*0.3","v":58817916.299999997}]
[null,2028,{"$f":"SUM($C$8:$C$11)*0.2","v":39211944.200000003}]
[null,"Total",{"$f":"SUM(C21:C29)","v":200218201}]

{"sheet":"Project Element Description","index":4,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Project Description Elements"]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]
[]
[]
["Summary of Geometric Changes – INTERCHANGE:"]
["SB Exit ramp at US 27:"]
["Existing lanes:   T   T/L   L   L"]
["Future lanes:     T    L      L   L"]
["Repave and restripe"]
["NB Exit ramp at US 27:      "]
["Existing lanes:   L   L   T/R   R"]
["Future lanes:     L   L   T    T/R   R/turbo (EB past N. 18th Ave. signal)"]
["Bridge widened for extra lane, turbo treatment B downstream of far right lane"]
["Three new directional ramps:"]
["Ramp A:"]
["NB 826 to WB US 27"]
["Elevated over both diamond ramp intersections and over NW 79th Ave. to west of interchange"]
["Ramp B:"]
["EB US 27 to SB 826 "]
["Elevated over NW 79th Ave. intersection and westernmost of the diamond ramp intersection"]
["Ramp C:"]
["NB 826 to WB US 27"]
["Elevated over NW 79th Ave. to west of interchange and both diamond ramp intersections "]
[]
["Summary of Geometric Changes – US 27 East:"]
["NW 18th Ave. intersection"]
["EB to NB left turn:"]
["Revised from 2 lane LT to 3 lane LT with added receiving lane."]
["Turbo lane from ramp signal to the west is extended EB through this intersection."]
["See attachment showing 3 lane LT EB (p 40)."]
["Summary of Geometric Changes – US 27 West:"]
["General:  US 27 EB and WB lanes are shifted to accept Ramp A and Ramp B terminals"]
["US 27/NW 79th Ave. intersection"]
["Same basic lane arrangement with turbo intersection on US 27."]
["NW South River Drive at NW 79th Ave. intersection"]
["SB to WB RT – new receiving lane for the RT"]
["WB to SB LT – goes from 1 lane to 2 LT lanes"]
["WB to NB RT – new RT only lane added"]
["US 27/Frontage Road intersection (near NW 95th St.)"]
["New inside lane for the WB end of new Ramp A."]
["US 27 EB through lanes through turbo increased from 2 lanes to 3 lanes."]
["SB approach from frontage road widened from 1 LT only lane to 2 LT only lanes"]
["N. Frontage Rd. Connection at N. Frontage Rd."]
["WB LT lane longer"]
["NB approach widened by one lane for 2 LT only lanes and 1 RT only lane"]
["Geometry improved to better accommodate trucks"]

{"sheet":"RIMS II Table 2.5","index":5,"n_rows":82,"n_cols":13,"rows_kept":82,"cut":false,"hidden":false,"merged":[[77,0,77,8],[72,0,72,8],[73,0,73,8],[74,0,74,8],[75,0,75,8],[76,0,76,8]]}
["Table 2.5 Total Multipliers - industry aggregations"]
["Region: Miami-Dade-Broward  (Type II)"]
["Series: 2012 U.S. Benchmark I-O data and 2017 Regional Data"]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]
[null,null,"Final-demand Output /1/ (dollars)","Final-demand Earnings /2/ (dollars)","Final-demand Employment /3/ (number of jobs)","Final-demand Value-added /4/ (dollars)","Direct-effect Earnings /5/ (dollars)","Direct-effect Employment /6/ (number of jobs)",null,"Final-demand/ direct effect","Final-demand output/ earnings","Final-demand earnings/ jobs","Final-demand output/ jobs"]
[1,"Farms",1.9427000000000001,0.62239999999999995,21.023900000000001,0.90810000000000002,1.8105,1.6160000000000001]
[2,"Forestry, fishing, and related activities",1.8832,0.79369999999999996,27.119299999999999,1.1802999999999999,1.4995000000000001,1.3511]
[3,"Oil and gas extraction",1.5770999999999999,0.44540000000000002,10.3781,0.96340000000000003,1.6532,1.7526999999999999]
[4,"Mining (except oil and gas)",1.6953,0.37240000000000001,8.8940000000000001,0.94540000000000002,2.3586,2.3578000000000001]
[5,"Support activities for mining",1.841,0.53839999999999999,12.613899999999999,1.0471999999999999,1.9614,2.0941000000000001]
[6,"Utilities*",1.4997,0.3029,5.5106000000000002,0.88439999999999996,2.0577999999999999,3.6425000000000001]
[7,"Construction",2.0091999999999999,0.69120000000000004,15.538600000000001,1.1048,1.7430000000000001,2.0124]
[8,"Wood product manufacturing",1.6472,0.36620000000000003,8.6595999999999993,0.69140000000000001,2.0232999999999999,2.1042000000000001]
[9,"Nonmetallic mineral product manufacturing",1.8171999999999999,0.42259999999999998,9.3010000000000002,0.89470000000000005,2.2153,2.5346000000000002]
[10,"Primary metal manufacturing",1.5722,0.31269999999999998,7.3737000000000004,0.56069999999999998,2.0390999999999999,2.1303999999999998]
[11,"Fabricated metal product manufacturing",1.6533,0.41449999999999998,9.4164999999999992,0.78320000000000001,1.8753,2.0964999999999998]
[12,"Machinery manufacturing",1.6141000000000001,0.33610000000000001,6.9884000000000004,0.73060000000000003,2.0931000000000002,2.4977]
[13,"Computer and electronic product manufacturing",1.5690999999999999,0.40310000000000001,6.9885999999999999,1.0261,1.7423999999999999,2.5106000000000002]
[14,"Electrical equipment, appliance, and component manufacturing",1.6063000000000001,0.3745,8.1258999999999997,0.77580000000000005,1.8698999999999999,2.1113]
[15,"Motor vehicles, bodies and trailers, and parts manufacturing",1.6914,0.3372,7.4135999999999997,0.60389999999999999,2.2970000000000002,2.5924999999999998]
[16,"Other transportation equipment manufacturing",1.6369,0.37930000000000003,7.0796999999999999,0.80330000000000001,1.9384999999999999,2.7143999999999999]
[17,"Furniture and related product manufacturing",1.7976000000000001,0.43969999999999998,10.560700000000001,0.79800000000000004,2.1027999999999998,2.1894]
[18,"Miscellaneous manufacturing",1.7039,0.43380000000000002,9.5952000000000002,0.93530000000000002,1.9305000000000001,2.2014]
[19,"Food and beverage and tobacco product manufacturing",1.5517000000000001,0.31140000000000001,7.3596000000000004,0.55269999999999997,1.9827999999999999,2.0611000000000002]
[20,"Textile mills and textile product mills",1.8049999999999999,0.44779999999999998,11.934900000000001,0.76680000000000004,2.0815999999999999,2.0203000000000002]
[21,"Apparel, leather, and allied product manufacturing",1.9757,0.72189999999999999,26.966999999999999,1.0946,1.6956,1.4169]
[22,"Paper manufacturing",1.5665,0.31909999999999999,6.2892000000000001,0.62009999999999998,1.9976,2.6461999999999999]
[23,"Printing and related support activities",1.7929999999999999,0.49330000000000002,12.8316,0.93120000000000003,1.9245000000000001,1.9712000000000001]
[24,"Petroleum and coal products manufacturing",1.4544999999999999,0.27879999999999999,5.3699000000000003,0.45390000000000003,1.8864000000000001,2.4582999999999999]
[25,"Chemical manufacturing",1.5538000000000001,0.32119999999999999,6.3555999999999999,0.70779999999999998,2.0144000000000002,2.6061999999999999]
[26,"Plastics and rubber products manufacturing",1.5497000000000001,0.3085,6.7008000000000001,0.63,2.0278999999999998,2.3321999999999998]
[27,"Wholesale trade",1.8811,0.51290000000000002,10.234500000000001,1.1354,2.129,3.0861000000000001]
[28,"Motor vehicle and parts dealers",1.8380000000000001,0.64170000000000005,14.2606,1.2325999999999999,1.6418999999999999,1.9198]
[29,"Food and beverage stores",1.9009,0.62619999999999998,22.710999999999999,1.1808000000000001,1.7251000000000001,1.4682999999999999]
[30,"General merchandise stores",1.8597999999999999,0.57499999999999996,20.254100000000001,1.1541999999999999,1.8154999999999999,1.5002]
[31,"Other retail",1.9408000000000001,0.60870000000000002,19.867899999999999,1.2084999999999999,1.8307,1.6117999999999999]
[32,"Air transportation",1.7164999999999999,0.38850000000000001,7.7606000000000002,0.86719999999999997,2.3555999999999999,4.0349000000000004]
[33,"Rail transportation",1.8118000000000001,0.44769999999999999,8.1335999999999995,0.9929,2.2498,3.9003000000000001]
[34,"Water transportation",2.0880000000000001,0.4965,11.42,0.9113,3.4645999999999999,4.6708999999999996]
[35,"Truck transportation",1.9935,0.61329999999999996,14.3446,1.0202,1.9918,2.2187000000000001]
[36,"Transit and ground passenger transportation*",1.9276,0.61799999999999999,31.015699999999999,0.92800000000000005,1.8099000000000001,1.2906]
[37,"Pipeline transportation",2.0691999999999999,0.85589999999999999,14.1328,1.3347,1.6409,2.6854]
[38,"Other transportation and support activities*",2.0838000000000001,0.70299999999999996,16.0382,1.1668000000000001,1.9263999999999999,2.2019000000000002]
[39,"Warehousing and storage",2.0116000000000001,0.53959999999999997,14.522500000000001,1.0486,2.0695000000000001,2.1787999999999998]
[40,"Publishing industries (except Internet)",1.7685,0.5272,9.9102999999999994,1.1485000000000001,1.8525,2.7336999999999998]
[41,"Motion picture and sound recording industries",1.6933,0.4098,10.9373,1.0523,2.0154000000000001,2.0371999999999999]
[42,"Broadcasting (except Internet) and telecommunications",1.9766999999999999,0.53100000000000003,11.1488,1.0876999999999999,2.2263000000000002,3.1099000000000001]
[43,"Data processing, hosting, and other information services",1.9553,0.46639999999999998,9.6303999999999998,1.048,2.8029999999999999,4.8631000000000002]
[44,"Monetary Authorities-central bank, credit intermediation, and related services",1.8194999999999999,0.51629999999999998,10.548,1.1826000000000001,1.9756,2.6983999999999999]
[45,"Securities, commodity contracts, and other financial investments and related activities",2.1919,0.77349999999999997,22.3688,1.2110000000000001,1.9350000000000001,1.7766999999999999]
[46,"Insurance carriers and related activities",2.1764000000000001,0.54410000000000003,11.071199999999999,1.1735,2.4276,3.1122000000000001]
[47,"Funds, trusts, and other financial vehicles",2.5609000000000002,0.65210000000000001,20.698399999999999,0.98160000000000003,4.4717000000000002,3.0146999999999999]
[48,"Real estate",1.5887,0.32750000000000001,13.9229,1.1015999999999999,2.1827000000000001,1.5104]
[49,"Rental and leasing services and lessors of nonfinancial intangible assets",1.9046000000000001,0.4929,11.764799999999999,1.1296999999999999,2.2391000000000001,2.4855]
[50,"Professional, scientific, and technical services",2.044,0.80079999999999996,16.6708,1.3039000000000001,1.6714,2.1004]
[51,"Management of companies and enterprises",1.9772000000000001,0.66690000000000005,12.3759,1.2310000000000001,1.8283,2.7646000000000002]
[52,"Administrative and support services",2.0577999999999999,0.78029999999999999,23.229500000000002,1.2925,1.7318,1.6069]
[53,"Waste management and remediation services",1.8492,0.49180000000000001,10.9048,1.0127999999999999,2.0628000000000002,2.4636999999999998]
[54,"Educational services",1.9662999999999999,0.72840000000000005,22.226199999999999,1.2865,1.6278999999999999,1.5646]
[55,"Ambulatory health care services",2.0670000000000002,0.81340000000000001,16.857099999999999,1.3111999999999999,1.665,2.0948000000000002]
[56,"Hospitals",2.1051000000000002,0.7329,15.729100000000001,1.2286999999999999,1.8676999999999999,2.3258000000000001]
[57,"Nursing and residential care facilities",2.0857000000000001,0.77170000000000005,23.5487,1.2696000000000001,1.714,1.6395]
[58,"Social assistance",2.0261,0.72099999999999997,26.024799999999999,1.1904999999999999,1.7047000000000001,1.4798]
[59,"Performing arts, spectator sports, museums, and related activities",2.0783,0.79390000000000005,28.88,1.3683000000000001,1.7755000000000001,1.5538000000000001]
[60,"Amusement, gambling, and recreation industries",1.9283999999999999,0.5736,18.641999999999999,1.1513,1.9174,1.6736]
[61,"Accommodation",1.8655999999999999,0.54239999999999999,14.3714,1.1194999999999999,1.9641,1.9303999999999999]
[62,"Food services and drinking places",1.9593,0.61099999999999999,22.913799999999998,1.1045,1.8628,1.4911000000000001]
[63,"Other services*",2.0209000000000001,0.71340000000000003,20.652000000000001,1.1722999999999999,1.762,1.6809000000000001]
[64,"Households",1.2043999999999999,0.3644,10.3117,0.72989999999999999,0,0]
[]
["Footnotes:"]
["*Includes Government enterprises"]
["1. Each entry in column 1 represents the total dollar change in output that occurs in all industries for each additional dollar of output delivered to final demand by the industry corresponding to the entry."]
["2. Each entry in column 2 represents the total dollar change in earnings of households employed by all industries for each additional dollar of output delivered to final demand by the industry corresponding to the entry."]
["3. Each entry in column 3 represents the total change in number of jobs that occurs in all industries for each additional 1 million dollars of output delivered to final demand by the industry corresponding to the entry.  Because the employment multipliers are based on regional data, the output delivered to final demand should be in regional year dollars."]
["4. Each entry in column 4 represents the total dollar change in value added that occurs in all industries for each additional dollar of output delivered to final demand by the industry corresponding to the entry."]
["5. Each entry in column 5 represents the total dollar change in earnings of households employed by all industries for each additional dollar of earnings paid directly to households employed by the industry corresponding to the entry."]
["6. Each entry in column 6 represents the total change in number of jobs in all industries for each additional job in the industry corresponding to the entry.industries corresponding to the entries."]
["NOTE.-  Industry List B identifies the industries corresponding to the entries."]
["SOURCE.--Regional Input-Output Modeling System (RIMS II), Regional Product Division, Bureau of Economic Analysis, 2019."]
[]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]

{"sheet":"Full & Part-Time","index":6,"n_rows":122,"n_cols":13,"rows_kept":122,"cut":false,"hidden":false,"merged":[[105,0,105,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[104,0,104,9],[5,6,5,6],[5,7,5,7],[5,8,5,8],[5,9,5,9],[5,2,5,2],[5,3,5,3],[5,4,5,4],[5,5,5,5],[112,0,112,9],[113,0,113,9],[114,0,114,9],[106,0,106,9],[107,0,107,9],[108,0,108,9],[109,0,109,9],[110,0,110,9],[111,0,111,9]]}
["Table 6.4D. Full-Time and Part-Time Employees by Industry"]
["[Thousands]"]
["Bureau of Economic Analysis"]
["Last Revised on: July 30, 2021"]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]
["Line","","2013","2014","2015","2016","2017","2018","2019","2020"]
["","","","","","","","","",""]
["1","            Full-time and part-time employees",141103,143758,146634,148735,150653,153175,155338,146528]
["2","Domestic industries",142215,145003,147942,150199,152179,154673,156872,147564]
["3","    Private industries",117880,120668,123521,125605,127457,129819,131804,123107]
["4","        Agriculture, forestry, fishing, and hunting",1356,1380,1439,1417,1418,1417,1420,1391]
["5","            Farms1",789,803,817,820,819,814,813,809]
["6","            Forestry, fishing, and related activities",567,577,623,597,599,603,607,581]
["7","        Mining",810,842,751,611,622,672,674,539]
["8","            Oil and gas extraction",197,200,196,175,144,143,142,127]
["9","            Mining, except oil and gas",210,205,197,180,185,191,192,176]
["10","            Support activities for mining",403,436,358,255,293,339,340,236,null,2019,2020]
["11","        Utilities",549,550,555,555,553,553,549,545]
["12","        Construction",5996,6282,6613,6883,7127,7419,7664,7401,"FTE/F&PT",{"$f":"1/(I19/FTE!I19)","v":0.9694676409185804},{"$f":"1/(J19/FTE!J19)","v":0.96622078097554387}]
["13","        Manufacturing",12023,12189,12332,12335,12440,12672,12806,12109]
["14","            Durable goods",7546,7670,7763,7702,7744,7943,8035,7544]
["15","                Wood products",355,371,381,391,398,406,407,396]
["16","                Nonmetallic mineral products",373,383,398,407,411,416,419,398]
["17","                Primary metals",398,398,393,374,370,380,387,351]
["18","                Fabricated metal products",1425,1453,1456,1419,1422,1466,1484,1374]
["19","                Machinery",1107,1123,1118,1073,1076,1113,1126,1047]
["20","                Computer and electronic products",1063,1050,1055,1048,1044,1059,1074,1060]
["21","                Electrical equipment, appliances, and components",376,379,382,382,386,398,401,381]
["22","                Motor vehicles, bodies and trailers, and parts",819,871,917,945,970,1002,999,891]
["23","                Other transportation equipment",689,683,693,682,678,700,734,702]
["24","                Furniture and related products",360,370,381,391,395,394,386,361]
["25","                Miscellaneous manufacturing",582,588,590,592,595,610,619,583]
["26","            Nondurable goods",4477,4519,4569,4633,4695,4729,4770,4565]
["27","                Food and beverage and tobacco products",1673,1703,1742,1798,1858,1888,1922,1876]
["28","                Textile mills and textile product mills",233,235,234,230,229,228,221,197]
["29","                Apparel and leather and allied products",174,170,166,159,149,142,137,114]
["30","                Paper products",377,373,372,370,368,364,371,354]
["31","                Printing and related support activities",455,453,450,448,441,431,425,376]
["32","                Petroleum and coal products",111,110,110,111,113,113,113,109]
["33","                Chemical products",795,802,808,813,823,832,850,846]
["34","                Plastics and rubber products",658,674,688,702,715,730,731,693]
["35","        Wholesale trade",5773,5847,5905,5897,5934,5882,5916,5650]
["36","            Durable goods",3330,3373,3412,3408,3443,3438,3476,3339]
["37","            Nondurable goods",2443,2474,2493,2489,2491,2445,2439,2311]
["38","        Retail trade",15200,15462,15777,15960,15989,15933,15751,14892]
["39","            Motor vehicle and parts dealers",1809,1875,1950,1996,2019,2033,2047,1907]
["40","            Food and beverage stores",2963,3024,3092,3110,3119,3103,3093,3119]
["41","            General merchandise stores",3083,3129,3188,3222,3130,3111,3033,2942]
["42","            Other retail2",7346,7434,7548,7632,7720,7686,7577,6924]
["43","        Transportation and warehousing",4506,4675,4891,5021,5198,5444,5741,5773]
["44","            Air transportation",451,452,464,478,497,506,509,465]
["45","            Rail transportation",199,204,207,190,183,182,176,156]
["46","            Water transportation",67,69,68,66,65,65,67,59]
["47","            Truck transportation",1400,1446,1480,1474,1481,1522,1558,1499]
["48","            Transit and ground passenger transportation",458,477,487,487,490,493,505,373]
["49","            Pipeline transportation",44,47,49,49,50,50,51,51]
["50","            Other transportation and support activities3",1173,1232,1302,1344,1401,1481,1623,1696]
["51","            Warehousing and storage",713,749,834,933,1031,1145,1251,1474]
["52","        Information",2719,2747,2772,2817,2804,2821,2856,2715]
["53","            Publishing industries (includes software)",842,848,862,874,884,903,941,961]
["54","            Motion picture and sound recording industries",385,388,412,448,428,424,437,296]
["55","            Broadcasting and telecommunications",1135,1134,1088,1073,1047,1018,980,933]
["56","            Information and data processing services",358,377,410,422,445,476,498,524]
["57","        Finance and insurance",5895,5949,6069,6153,6282,6328,6457,6506]
["58","            Federal Reserve banks, credit intermediation, and related activities",2633,2583,2585,2627,2677,2661,2678,2689]
["59","            Securities, commodity contracts, and investments",867,884,907,922,927,945,952,948]
["60","            Insurance carriers and related activities",2391,2477,2570,2594,2665,2708,2811,2851]
["61","            Funds, trusts, and other financial vehicles",4,6,7,10,13,15,17,18]
["62","        Real estate and rental and leasing",2043,2074,2137,2173,2230,2294,2373,2237]
["63","            Real estate",1499,1518,1568,1597,1648,1704,1767,1728]
["64","            Rental and leasing services and lessors of intangible assets4",544,556,569,575,583,591,606,509]
["65","        Professional, scientific, and technical services",8209,8442,8719,8932,9101,9384,9635,9547]
["66","            Legal services",1145,1134,1135,1140,1151,1158,1169,1147]
["67","            Computer systems design and related services",1713,1801,1919,1987,2059,2133,2200,2212]
["68","            Miscellaneous professional, scientific, and technical services5",5351,5507,5665,5804,5891,6093,6266,6188]
["69","        Management of companies and enterprises6",2090,2152,2195,2234,2284,2351,2411,2323]
["70","        Administrative and waste management services",8337,8633,8874,9046,9151,9315,9372,8625]
["71","            Administrative and support services",7961,8245,8474,8644,8734,8877,8920,8178]
["72","            Waste management and remediation services",377,388,400,402,417,437,452,446]
["73","        Educational services",3403,3467,3540,3606,3662,3722,3769,3493]
["74","        Health care and social assistance",17850,18154,18644,19204,19575,20019,20445,19829]
["75","            Ambulatory health care services",6501,6659,6880,7096,7295,7512,7720,7496]
["76","            Hospitals",4778,4762,4889,5009,5073,5125,5180,5117]
["77","            Nursing and residential care facilities",3261,3292,3311,3375,3350,3389,3382,3219]
["78","            Social assistance",3309,3441,3564,3724,3857,3993,4164,3998]
["79","        Arts, entertainment, and recreation",2066,2172,2192,2281,2335,2408,2470,1766]
["80","            Performing arts, spectator sports, museums, and related activities",580,613,619,641,660,683,700,478]
["81","            Amusements, gambling, and recreation industries",1486,1559,1573,1640,1675,1726,1770,1288]
["82","        Accommodation and food services",12242,12611,13033,13420,13711,13917,14126,11166]
["83","            Accommodation",1856,1891,1930,1951,1992,2025,2065,1406]
["84","            Food services and drinking places",10386,10720,11103,11469,11719,11892,12062,9760]
["85","        Other services, except government",6812,7041,7081,7061,7042,7268,7368,6600]
["86","    Government",24335,24336,24421,24594,24721,24854,25068,24457]
["87","        Federal",5138,5048,5039,5056,5070,5062,5118,5222]
["88","            General government",4442,4360,4352,4359,4368,4367,4428,4541]
["89","                Civilian",2184,2159,2180,2207,2211,2213,2246,2358]
["90","                Military7",2258,2202,2172,2152,2156,2155,2182,2183]
["91","            Government enterprises",696,687,687,697,703,695,690,681]
["92","        State and local",19197,19288,19382,19538,19651,19792,19949,19235]
["93","            General government",18037,18122,18215,18357,18468,18596,18745,18092]
["94","                Education",10274,10316,10371,10437,10507,10563,10644,10156]
["95","                Other8",7763,7806,7844,7920,7961,8033,8101,7936]
["96","            Government enterprises8",1160,1166,1167,1181,1183,1196,1204,1143]
["97","Rest of the world9",-1112,-1245,-1307,-1464,-1526,-1498,-1534,-1036]
["Legend / Footnotes:"]
["1. NAICS crop and animal production."]
["2. Consists of furniture and home furnishings stores; electronics and appliance stores; building material and garden equipment and supplies dealers; health and personal care stores; gasoline stations; clothing and clothing accessories stores; sporting goods, hobby, book, and music stores; miscellaneous store retailers; and nonstore retailers."]
["3. Consists of scenic and sightseeing transportation; transportation support activities; and couriers and messengers."]
["4. Intangible assets include patents, trademarks, and franchise agreements, but not copyrights."]
["5. Consists of accounting, tax preparation, bookkeeping, and payroll services; architectural, engineering, and related services; specialized design services; management, scientific, and technical consulting services; scientific research and development services; advertising and related services; and other professional, scientific, and technical services."]
["6. Consists of offices of bank and other holding companies and of corporate, subsidiary, and regional managing offices."]
["7. Includes Coast Guard."]
["8. Employees of Indian tribal governments are classified in state and local government."]
["9. Includes estimates of foreign professional workers and undocumented Mexican migratory workers employed temporarily in the United States."]
["Note. Estimates in this table are based on the 2012 North American Industry Classification System (NAICS)."]
[]
["Source:"]
["https://www.bea.gov/data/employment/employment-by-industry"]
["Accessed April 20, 2022"]
["Atkins 2022."]
[]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]

{"sheet":"FTE","index":7,"n_rows":123,"n_cols":10,"rows_kept":123,"cut":false,"hidden":false,"merged":[[105,0,105,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[104,0,104,9],[5,6,5,6],[5,7,5,7],[5,8,5,8],[5,9,5,9],[5,2,5,2],[5,3,5,3],[5,4,5,4],[5,5,5,5],[3,0,3,9],[112,0,112,9],[113,0,113,9],[114,0,114,9],[115,0,115,9],[106,0,106,9],[107,0,107,9],[108,0,108,9],[109,0,109,9],[110,0,110,9],[111,0,111,9]]}
["Table 6.5D. Full-Time Equivalent Employees by Industry"]
["[Thousands]"]
["Bureau of Economic Analysis"]
["Last Revised on: July 30, 2021"]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]
["Line","","2013","2014","2015","2016","2017","2018","2019","2020"]
["","","","","","","","","",""]
["1","            Full-time equivalent employees1",125540,128130,131007,133022,135118,137598,139614,132167]
["2","Domestic industries",126606,129326,132262,134426,136581,139034,141085,133161]
["3","    Private industries",106686,109296,112269,114150,116189,118451,120457,113082]
["4","        Agriculture, forestry, fishing, and hunting",1167,1187,1239,1219,1220,1219,1222,1197]
["5","            Farms2",676,688,700,703,702,697,697,693]
["6","            Forestry, fishing, and related activities",490,499,539,516,518,522,525,503]
["7","        Mining",797,830,740,600,615,664,663,530]
["8","            Oil and gas extraction",193,197,193,172,143,141,140,124]
["9","            Mining, except oil and gas",207,203,194,177,183,189,188,173]
["10","            Support activities for mining",396,430,353,251,289,334,335,232]
["11","        Utilities",540,544,547,549,547,546,544,541]
["12","        Construction",5754,6043,6378,6640,6892,7176,7430,7151]
["13","        Manufacturing",11742,11917,12075,12039,12180,12389,12524,11840]
["14","            Durable goods",7403,7537,7626,7552,7600,7795,7891,7416]
["15","                Wood products",343,364,370,381,387,398,398,389]
["16","                Nonmetallic mineral products",365,375,389,396,402,411,413,389]
["17","                Primary metals",391,391,386,365,360,371,379,344]
["18","                Fabricated metal products",1399,1427,1429,1386,1386,1432,1453,1348]
["19","                Machinery",1086,1107,1100,1056,1059,1095,1105,1030]
["20","                Computer and electronic products",1048,1033,1042,1033,1029,1039,1059,1047]
["21","                Electrical equipment, appliances, and components",368,373,376,376,383,391,393,375]
["22","                Motor vehicles, bodies and trailers, and parts",810,863,906,934,959,990,987,881]
["23","                Other transportation equipment",681,677,685,674,670,692,726,694]
["24","                Furniture and related products",350,359,370,380,384,384,375,351]
["25","                Miscellaneous manufacturing",561,567,573,571,579,592,603,569]
["26","            Nondurable goods",4339,4380,4450,4487,4580,4594,4633,4423]
["27","                Food and beverage and tobacco products",1599,1626,1674,1719,1789,1812,1843,1789]
["28","                Textile mills and textile product mills",224,224,226,221,222,220,212,190]
["29","                Apparel and leather and allied products",167,162,160,153,145,137,131,109]
["30","                Paper products",367,362,364,361,360,354,359,346]
["31","                Printing and related support activities",443,440,441,438,431,419,412,367]
["32","                Petroleum and coal products",110,110,109,109,112,112,112,108]
["33","                Chemical products",786,791,797,798,815,820,838,832]
["34","                Plastics and rubber products",644,665,680,689,705,720,725,682]
["35","        Wholesale trade",5550,5633,5688,5681,5743,5707,5725,5477]
["36","            Durable goods",3201,3249,3286,3283,3332,3335,3364,3237]
["37","            Nondurable goods",2349,2383,2402,2398,2411,2372,2361,2240]
["38","        Retail trade",13034,13253,13598,13794,13852,13809,13721,13049]
["39","            Motor vehicle and parts dealers",1551,1607,1680,1725,1749,1762,1783,1671]
["40","            Food and beverage stores",2540,2592,2665,2688,2702,2689,2695,2733]
["41","            General merchandise stores",2643,2682,2748,2785,2712,2697,2643,2578]
["42","            Other retail3",6299,6372,6505,6596,6688,6661,6601,6066]
["43","        Transportation and warehousing",4249,4420,4635,4725,4902,5134,5414,5426]
["44","            Air transportation",426,427,439,450,468,477,480,437]
["45","            Rail transportation",188,193,196,179,173,172,166,147]
["46","            Water transportation",63,65,65,62,61,61,63,56]
["47","            Truck transportation",1320,1367,1402,1387,1397,1435,1470,1409]
["48","            Transit and ground passenger transportation",432,451,462,458,462,465,476,350]
["49","            Pipeline transportation",41,44,46,46,47,47,48,48]
["50","            Other transportation and support activities4",1106,1165,1234,1265,1322,1397,1531,1594]
["51","            Warehousing and storage",672,708,791,878,972,1080,1180,1385]
["52","        Information",2533,2569,2576,2632,2613,2628,2642,2534]
["53","            Publishing industries (includes software)",759,778,779,798,803,816,836,866]
["54","            Motion picture and sound recording industries",330,326,349,384,370,368,389,268]
["55","            Broadcasting and telecommunications",1107,1110,1064,1054,1026,1000,963,914]
["56","            Information and data processing services",337,355,384,396,414,444,454,486]
["57","        Finance and insurance",5714,5774,5897,5964,6103,6171,6296,6351]
["58","            Federal Reserve banks, credit intermediation, and related activities",2553,2510,2518,2547,2601,2598,2615,2631]
["59","            Securities, commodity contracts, and investments",841,859,883,893,901,922,929,928]
["60","            Insurance carriers and related activities",2316,2400,2490,2513,2588,2636,2736,2775]
["61","            Funds, trusts, and other financial vehicles",3,6,7,10,12,14,16,18]
["62","        Real estate and rental and leasing",1873,1906,1955,2000,2051,2106,2185,2067]
["63","            Real estate",1369,1394,1429,1462,1501,1552,1621,1590]
["64","            Rental and leasing services and lessors of intangible assets5",504,512,527,538,550,554,564,476]
["65","        Professional, scientific, and technical services",7794,7994,8273,8496,8655,8948,9233,9117]
["66","            Legal services",1088,1074,1077,1084,1095,1104,1120,1096]
["67","            Computer systems design and related services",1626,1705,1821,1891,1958,2034,2108,2113]
["68","            Miscellaneous professional, scientific, and technical services6",5080,5215,5375,5521,5602,5810,6005,5909]
["69","        Management of companies and enterprises7",1978,2004,2071,2130,2182,2243,2258,2263]
["70","        Administrative and waste management services",7607,7901,8183,8322,8459,8615,8671,8005]
["71","            Administrative and support services",7246,7525,7795,7933,8058,8193,8235,7573]
["72","            Waste management and remediation services",362,376,387,389,402,422,435,432]
["73","        Educational services",3043,3083,3153,3205,3278,3336,3368,3182]
["74","        Health care and social assistance",16129,16441,16901,17362,17822,18255,18614,18183]
["75","            Ambulatory health care services",5831,6004,6189,6388,6615,6826,7001,6839]
["76","            Hospitals",4502,4499,4630,4722,4806,4856,4907,4868]
["77","            Nursing and residential care facilities",2925,2968,2978,3038,3037,3079,3067,2937]
["78","            Social assistance",2871,2970,3104,3214,3364,3494,3638,3538]
["79","        Arts, entertainment, and recreation",1689,1784,1800,1866,1910,1993,2040,1466]
["80","            Performing arts, spectator sports, museums, and related activities",474,504,509,524,540,565,578,397]
["81","            Amusements, gambling, and recreation industries",1215,1280,1292,1342,1370,1428,1462,1069]
["82","        Accommodation and food services",9822,10115,10566,10920,11163,11342,11591,9001]
["83","            Accommodation",1686,1709,1753,1778,1804,1839,1890,1266]
["84","            Food services and drinking places",8135,8407,8813,9142,9358,9502,9701,7735]
["85","        Other services, except government",5670,5897,5993,6003,6004,6173,6315,5704]
["86","    Government",19920,20031,19993,20276,20392,20582,20628,20079]
["87","        Federal",4201,4135,4137,4167,4149,4165,4104,3904]
["88","            General government",3654,3590,3576,3574,3588,3608,3552,3359]
["89","                Civilian",2108,2091,2102,2114,2121,2132,2052,1854]
["90","                Military8",1546,1499,1474,1460,1467,1476,1499,1505]
["91","            Government enterprises",547,545,562,592,562,557,552,545]
["92","        State and local",15719,15896,15856,16109,16243,16417,16524,16175]
["93","            General government",14657,14812,14790,15025,15155,15311,15394,15066]
["94","                Education",8166,8252,8250,8392,8477,8531,8454,8066]
["95","                Other9",6491,6560,6540,6633,6678,6780,6940,7000]
["96","            Government enterprises9",1062,1084,1066,1084,1088,1106,1130,1109]
["97","Rest of the world10",-1066,-1196,-1255,-1404,-1463,-1436,-1471,-994]
["Legend / Footnotes:"]
["1. Full-time equivalent employees equals the number of employees on full-time schedules plus the number of employees on part-time schedules converted to a full-time basis. The number of full-time equivalent employees in each industry is the product of the total number of employees and the ratio of average weekly hours per employee for all employees to the average weekly hours per employee on full-time schedules."]
["2. NAICS crop and animal production."]
["3. Consists of furniture and home furnishings stores; electronics and appliance stores; building material and garden equipment and supplies dealers; health and personal care stores; gasoline stations; clothing and clothing accessories stores; sporting goods, hobby, book, and music stores; miscellaneous store retailers; and nonstore retailers."]
["4. Consists of scenic and sightseeing transportation; transportation support activities; and couriers and messengers."]
["5. Intangible assets include patents, trademarks, and franchise agreements, but not copyrights."]
["6. Consists of accounting, tax preparation, bookkeeping, and payroll services; architectural, engineering, and related services; specialized design services; management, scientific, and technical consulting services; scientific research and development services; advertising and related services; and other professional, scientific, and technical services."]
["7. Consists of offices of bank and other holding companies and of corporate, subsidiary, and regional managing offices."]
["8. Includes Coast Guard."]
["9. Employees of Indian tribal governments are classified in state and local government."]
["10. Includes estimates of foreign professional workers and undocumented Mexican migratory workers employed temporarily in the United States."]
["Note. Estimates in this table are based on the 2012 North American Industry Classification System (NAICS)."]
[]
["Source:"]
["https://www.bea.gov/data/employment/employment-by-industry"]
["Accessed April 20, 2022"]
[]
[]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]

{"sheet":"Deflator","index":8,"n_rows":108,"n_cols":21,"rows_kept":108,"cut":false,"hidden":false,"merged":[[68,0,68,18],[4,0,5,0],[4,1,4,3],[26,0,26,3],[65,0,65,18],[66,0,66,18],[67,0,67,18]]}
["Inflation Adjustment Values"]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]
[]
[]
["Base Year of Nominal Dollar","Multiplier to Adjust to Real $"]
[null,"$2020","$2021","$2022"]
[2003,1.3754674735249621,1.4326172465960667,{"$f":"C7*$D$25","v":1.4921415553250073}]
[2004,1.3395094468606719,1.3951651874639039,1.4531333876540047]
[2005,1.2987749131468274,1.3527381605412323,1.4089435455376749]
[2006,1.2598997827147356,1.3122477938894064,1.3667708306586042]
[2007,1.226743809503249,1.2777142116966387,1.3308024007332389]
[2008,1.2036560438047428,1.2536671644478337,1.3057562144137167]
[2009,1.1959925913453442,1.2456853005556492,1.297442709302163]
[2010,1.1817898217665288,1.2308924151987191,1.2820351892428585]
[2011,1.1577360335764639,1.2058392078562405,1.2559410375364566]
[2012,1.1364799999999999,1.1837,1.2328819600872871]
[2013,1.1169226838065474,1.1633300901219643,1.2116656937890411]
[2014,1.0964169255407412,1.1419723310243697,1.1894205337828616]
[2015,1.0855565425872329,1.1306607062689247,1.1776389184240166]
[2016,1.0747872139209382,1.1194439190467185,1.1659560810358307,null,"Comparison of 2017-2019 adjustments"]
[2017,1.0547671860933483,1.0985920721690627,1.1442378535711317,null,{"$f":"1.010181^3","v":1.0308550135717598},"FDOT old"]
[2018,1.0301574496242782,1.0729598172605397,1.117540595251391,null,{"$f":"1.01081^2*1.026","v":1.0483020143585999},"FDOT newer"]
[2019,1.0120576344239229,1.0541079665877073,1.0979054625245226,null,1.0548,"FHWA--use since more conservative"]
[2020,1,1.0415493453470366,1.0848250387928404]
[2021,"-",1,1.0415493453470366]
[2022,"-","-",1]
["Source: Benefit-Cost Analysis Guidance for Discretionary Grant Programs, U.S. DOT, March 2022, Table A-7, for $2020. Atkins $2021 update per 2021 BEA data from Table 1.1.9 below (revised March 30, 2022); Atkins $2022 estimate per assumption of same factor in 2022 as 2021."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Source: Atkins, 2022, and","https://apps.bea.gov/iTable/iTable.cfm?reqid=19&step=3&isuri=1&1921=survey&1903=11#reqid=19&step=3&isuri=1&1921=survey&1903=11",null,null,null,null,null,null,null,null,"(April 19, 2022)"]
[]
["Table 1.1.9. Implicit Price Deflators for Gross Domestic Product"]
["[Index numbers, 2012=100]"]
["Bureau of Economic Analysis"]
["Last Revised on: March 30, 2022 - Next Release Date April 28, 2022"]
[]
["Cumulative  to 2020",null,{"$f":"$T$76/C76","v":1.3754674735249621},1.3395094468606719,1.2987749131468274,1.2598997827147356,1.226743809503249,1.2036560438047428,1.1959925913453442,1.1817898217665288,1.1577360335764639,1.1364799999999999,1.1169226838065474,1.0964169255407412,1.0855565425872329,1.0747872139209382,1.0547671860933483,1.0301574496242782,1.0120576344239229,{"$f":"$T$76/T76","v":1}]
["Cumulative to 2021",null,{"$f":"$U$76/C76","v":1.4326172465960667},1.3951651874639039,1.3527381605412323,1.3122477938894064,1.2777142116966387,1.2536671644478337,1.2456853005556492,1.2308924151987191,1.2058392078562405,1.1837,1.1633300901219643,1.1419723310243697,1.1306607062689247,1.1194439190467185,1.0985920721690627,1.0729598172605397,1.0541079665877073,1.0415493453470366,{"$f":"$U$76/U76","v":1}]
["Year by Year",null,null,{"$f":"D76/C76","v":1.0268441754916793},{"$f":"E76/D76","v":1.0313638131607794},1.0308557323093801,1.027027626269345,1.01918136482373,1.006407608638092,1.0120180165010944,1.0207765738410666,1.0187033943197099,1.0175100000000001,1.0187025188941632,1.0100044378412798,1.0100199635116676,1.0189805182523171,1.0238892962217045,1.0178841743639018,1.0120576344239229,1.0415493453470366]
["Line","","2003","2004","2005","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020","2021"]
["Line","","","","","","","","","","","","","","","","","","","",""]
["1","        Gross domestic product",82.625,84.843000000000004,87.504000000000005,90.203999999999994,92.641999999999996,94.418999999999997,95.024000000000001,96.165999999999997,98.164000000000001,100,101.751,103.654,104.691,105.74,107.747,110.321,112.294,113.648,118.37]
["2","Personal consumption expenditures",82.397999999999996,84.442999999999998,86.876000000000005,89.322000000000003,91.614000000000004,94.325000000000003,94.061999999999998,95.747,98.17,100,101.354,102.887,103.116,104.148,106.051,108.318,109.922,111.22499999999999,115.536]
["3","    Goods",88.054000000000002,89.292000000000002,91.084000000000003,92.305999999999997,93.331000000000003,96.122,93.811999999999998,95.183000000000007,98.772999999999996,100,99.406999999999996,98.92,95.896000000000001,94.331999999999994,94.614999999999995,95.281000000000006,94.831999999999994,94.16,98.873999999999995]
["4","        Durable goods",115.752,113.488,112.309,110.38800000000001,108.038,106.012,104.02,102.107,101.28,100,97.968000000000004,95.429000000000002,93.358000000000004,91.141000000000005,89.05,87.543999999999997,86.488,85.784000000000006,91.063999999999993]
["5","        Nondurable goods",76.326999999999998,78.97,81.998000000000005,84.552999999999997,87.040999999999997,91.903999999999996,89.466999999999999,92.182000000000002,97.652000000000001,100,100.08199999999999,100.599,97.091999999999999,95.876000000000005,97.450999999999993,99.343000000000004,99.248999999999995,98.602000000000004,102.852]
["6","    Services",79.573999999999998,82.018000000000001,84.774000000000001,87.843999999999994,90.786000000000001,93.457999999999998,94.182000000000002,96.016999999999996,97.875,100,102.322,104.88,106.79600000000001,109.197,111.965,115.1,117.836,120.30200000000001,124.24299999999999]
["7","Gross private domestic investment",88.503,91.156999999999996,94.912999999999997,98.13,99.584999999999994,100.59699999999999,99.366,97.698999999999998,98.748000000000005,100,100.876,102.872,103.697,103.726,105.258,107.15600000000001,108.991,109.69799999999999,113.185]
["8","    Fixed investment",88.265000000000001,90.843000000000004,94.596999999999994,97.957999999999998,99.456000000000003,100.29600000000001,99.075999999999993,97.567999999999998,98.641000000000005,100,101.09099999999999,103.172,104.075,104.202,105.928,107.925,109.684,111.05200000000001,115.386]
["9","        Nonresidential",91.156000000000006,92.055000000000007,94.442999999999998,96.745000000000005,98.31,99.831999999999994,99.183999999999997,97.415999999999997,98.558999999999997,100,100.251,101.46899999999999,101.90900000000001,101.119,101.977,102.815,104.137,104.813,106.45699999999999]
["10","            Structures",62.768999999999998,67.415999999999997,75.733000000000004,84.748999999999995,89.748000000000005,94.334999999999994,92.613,92.006,95.361999999999995,100,101.455,107.19799999999999,109.40300000000001,109.67,112.545,114.39100000000001,119.05800000000001,120.852,127.617]
["11","            Equipment",105.72499999999999,104.84099999999999,104.598,103.56,103.191,102.542,103.16800000000001,99.471000000000004,99.447000000000003,100,99.787000000000006,99.168999999999997,98.671000000000006,97.593000000000004,97.543000000000006,97.683000000000007,97.816000000000003,97.388000000000005,97.712000000000003]
["12","            Intellectual property products",95.647000000000006,95.334999999999994,95.951999999999998,97.087999999999994,98.284000000000006,99.834000000000003,98.588999999999999,98.305999999999997,99.516999999999996,100,100.081,100.791,101.374,100.30200000000001,101.125,102.26600000000001,103.172,104.574,105.6]
["13","        Residential",84.325000000000003,90.242999999999995,96.706000000000003,102.355,103.708,102.249,98.671000000000006,98.316999999999993,99.049000000000007,100,105.054,111.11799999999999,114.114,118.127,123.45399999999999,130.417,134.14500000000001,138.541,153.46600000000001]
["14","    Change in private inventories","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["15","Net exports of goods and services","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---","---"]
["16","    Exports",79.531000000000006,82.435000000000002,85.289000000000001,88.006,91.328000000000003,95.492999999999995,89.802999999999997,93.35,99.236999999999995,100,100.148,100.21599999999999,95.373000000000005,93.457999999999998,95.897000000000006,99.135000000000005,98.66,96.188000000000002,107.4]
["17","        Goods",79.497,82.298000000000002,84.917000000000002,87.55,90.977999999999994,95.67,88.908000000000001,92.951999999999998,99.793000000000006,100,99.32,98.311999999999998,91.322999999999993,87.772000000000006,90.058000000000007,93.274000000000001,91.792000000000002,88.162000000000006,100.685]
["18","        Services",79.599000000000004,82.75,86.171000000000006,89.094999999999999,92.16,95.082999999999998,91.745000000000005,94.23,98.001000000000005,100,101.98699999999999,104.46599999999999,104.431,106.155,108.934,112.212,114.08199999999999,114.517,121.414]
["19","    Imports",75.378,78.971000000000004,83.617999999999995,86.853999999999999,89.885000000000005,98.796000000000006,87.852000000000004,92.656000000000006,99.715999999999994,100,98.697000000000003,97.960999999999999,90.144000000000005,87.058000000000007,88.995999999999995,91.515000000000001,90.078000000000003,88.075000000000003,94.56]
["20","        Goods",74.483000000000004,78.037999999999997,82.992000000000004,86.317999999999998,89.231999999999999,98.971999999999994,86.54,91.960999999999999,99.869,100,98.058999999999997,96.751999999999995,87.644000000000005,83.998999999999995,85.882999999999996,88.266999999999996,86.388999999999996,83.962999999999994,90.472999999999999]
["21","        Services",80.204999999999998,84.009,86.933999999999997,89.653999999999996,93.320999999999998,97.962999999999994,93.763000000000005,95.891000000000005,98.986999999999995,100,101.84099999999999,104.018,102.98099999999999,102.85599999999999,105.069,108.3,109.262,109.82,115.613]
["22","Government consumption expenditures and gross investment",75.043999999999997,78.168999999999997,82.132000000000005,85.694999999999993,89.53,93.343000000000004,92.921000000000006,95.391000000000005,98.289000000000001,100,102.363,104.47,104.63800000000001,104.899,107.389,111.319,113.246,114.861,120.03400000000001]
["23","    Federal",80.025000000000006,82.777000000000001,86.221999999999994,88.968999999999994,91.61,94.42,94.192999999999998,96.424999999999997,99.069000000000003,100,100.93300000000001,102.643,103.143,103.69499999999999,105.702,108.776,110.78100000000001,112.018,116.02500000000001]
["24","        National defense",79.504999999999995,82.263000000000005,86.010999999999996,89.022000000000006,91.75,94.801000000000002,94.126000000000005,96.128,98.945999999999998,100,100.60899999999999,102.056,102.334,102.65,104.306,107.149,108.86499999999999,110.039,114.086]
["25","        Nondefense",80.945999999999998,83.688999999999993,86.585999999999999,88.858000000000004,91.341999999999999,93.712999999999994,94.308000000000007,96.950999999999993,99.284000000000006,100,101.48099999999999,103.621,104.46599999999999,105.37,107.902,111.325,113.77500000000001,115.108,119.063]
["26","    State and local",72.063000000000002,75.382000000000005,79.631,83.659000000000006,88.180999999999997,92.59,92.045000000000002,94.674000000000007,97.747,100,103.33199999999999,105.69799999999999,105.65600000000001,105.739,108.524,112.98399999999999,114.863,116.72499999999999,122.68300000000001]
["","Addendum:","","","","","","","","","","","","","","","","","","",""]
["27","    Gross national product",82.619,84.835999999999999,87.498999999999995,90.198999999999998,92.64,94.421000000000006,95.018000000000001,96.162000000000006,98.165000000000006,100,101.747,103.652,104.681,105.727,107.73399999999999,110.31399999999999,112.283,113.636,118.349]
[]
["Source: Atkins, 2022, and","https://apps.bea.gov/iTable/iTable.cfm?reqid=19&step=3&isuri=1&1921=survey&1903=11#reqid=19&step=3&isuri=1&1921=survey&1903=11",null,null,null,null,null,null,null,null,"(April 19, 2022)"]
[]
[]
[{"$f":"HYPERLINK(\"#'\"&Title!$B$17&\"'!A27\",\"Go To Title Page\")","v":"Go To Title Page"}]