{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["ePermitting ROI Calculator Home","Time to Market Start","Time to Market Inputs","Time to Market Results","Time to Market Background Calcs","Trusted Transactions Start","Trusted Transactions Inputs","Trusted Transactions Results","Trusted Trans. Background Calcs","Right Info, Right Time Start","Right Info, Right Time Inputs","Right Info, Right Time Results","Right Info, Right Time Calcs","BEA1","BEA2","Text Options"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":32,"comments":0,"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":"ePermitting ROI Calculator Home","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,2,1,4],[17,1,19,5],[0,1,0,5],[11,1,12,5]]}
[null,"ePermitting ROI Metrics Calculator"]
[]
[null,null,null,"Primary Metric"]
[null,null,null,"TIME TO MARKET"]
[]
[]
[]
[]
[]
[]
[]
[null,"Estimate gains in economic activity associated with reduced permit processing times. "]
[]
[]
[]
[]
[null,null,null,"Additional Metrics"]
[null,"These metrics describe two types of economic benefits (and cost savings) to the regulated community and the public that often result from improved permitting systems. These metrics expand on traditional ROI measures because they are not typically considered in direct cost savings estimates, which tend to focus on immediate savings to agencies and applicants."]

{"sheet":"Time to Market Start","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,2,3,4],[4,2,16,4]]}
[]
[null,null,"ePERMITTING BENEFITS CALCULATOR:\n TIME TO MARKET METRIC"]
[]
[]
[null,null,"This tool allows states to estimate the benefits of reducing the processing time for environmental permits so that economic activity (construction, industrial, or commercial activity) can start sooner. \n\n\"Time to market\" refers to the schedule for starting business operations at a facility; permitting processes can increase the time to market (delay operations) for facilities. This delays economic activity. Reducing permit processing time can therefore: increase economic activity by ensuring that operations begin sooner, increase productivity and reduce permitting-related costs for permit applicants, and reduce scheduling uncertainty that can affect financing.  \n\nThis tool specifically measures the opportunity cost of lost economic activity associated with waiting for the final permit decision. Project benefits are measured as the dollar value of additional days of economic activity per year."]

{"sheet":"Time to Market Inputs","index":2,"n_rows":78,"n_cols":6,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,2,78,4],[75,2,75,3],[66,2,67,4],[68,2,74,4],[47,3,48,3],[57,2,63,4],[55,2,56,4],[64,2,64,3],[50,2,53,4],[44,5,46,5],[1,2,2,3],[8,2,9,3],[45,2,46,2],[10,2,13,4],[33,2,33,4],[38,2,39,4],[42,2,43,4],[40,2,41,4],[37,2,37,4],[44,3,45,3],[15,2,27,4],[3,2,5,3],[35,2,35,4],[28,2,32,4]]}
[]
[null,null,"In which state is your project being implemented?"]
[]
[null,null,"Select a state from the drop down list by clicking in the cell below. Select 'United States' to use national-level data."]
[]
[]
[null,null,"State:"]
[]
[null,null,"What industry does the permit in question affect?"]
[]
[null,null,"This tool assesses the time to market benefits associated with projects that reduce processing times for a given permit. Select the industry regulated by your permit from the dropdown list in the cell below."]
[]
[]
[]
[null,null,"Commercial Construction"]
[null,null,"If your permit addresses multiple sectors or if you are not sure which sector(s) is most applicable, the model recommends that you select \"commercial construction\" as a default proxy for economic activity. Commercial construction is a reasonable indicator of \"typical\" economic activity in this context because:\n\n     1) it is similar in scale (size, in percentage of GDP) to other key sectors that \n         require environmental permitting, such as the waste remediation sector; \n\n     2) it is present in all 50 states;\n\n     3) it explicitly requires permits to begin operation at most sites;\n\n     4) it is used by the World Bank as a consistent metric for the intersection\n         between economic activity and permitting."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"If you know that your permit affects a specific industry, select that industry from the dropdown list below to obtain an estimate of economic activity associated with that industry. If your permit does not affect a specific industry, or you would like to obtain a general estimate comparable to environmental permitting costs, select “commercial construction” from the dropdown list below."]
[]
[]
[]
[]
[]
[null,null,"Industry:"]
[null,null,"Select an industry from the drop-down list by clicking in the cell above"]
[]
[null,null,"How much of the industry is affected by the permit in question?"]
[null,null,"Most permit programs affect only a portion of commercial or industrial activity in any one year.  "]
[]
[null,null,{"$f":"IF(state_tm<>\"\",IFERROR(\"Note: There are \"&TEXT(INDEX('BEA2'!F2:F1037,MATCH(state_tm&industry_tm,'BEA2'!C2:C1037&'BEA2'!D2:D1037,0)),\"#,##0\")&\" total \"&TRIM(LOWER(industry_tm))&\" facilities in \"&CHAR(10)&IF(the_tm=1,\"the \",\"\")&state_tm&\", according to the latest County Business Patterns Data.\",\"\"),\"\")","v":""}]
[]
[null,null,"To measure the number of facilities affected by permitting each year:"]
[]
[null,null,"(A)","Enter the percent of the industry that is subject to permit requirements each year:",null,"Enter as a whole number (e.g., \"50\" for 50%)"]
[null,null,"OR:"]
[]
[null,null,"(B)","Enter the number of permit applications as a whole number you wish to analyze:"]
[]
[]
[null,null,{"$f":"IF(AND(perc_industry_tm<>\"\",permit_apps_tm<>\"\"),\"Please only enter a value in either (A) OR (B).\",IF(OR(perc_industry_tm>1,permit_apps_tm>tot_facilities_tm),\"WARNING: You have entered a number/percent of facilities greater than the total facilities in your state.  Benefits estimated will include economic activity GREATER than reported GDP for the entire \"&LOWER(industry_tm)&\" sector in \"&IF(the_tm=1,\"the \",\"\")&state_tm&\".\",\"\"))","v":""}]
[]
[]
[]
[]
[null,null,"What is (was) the initial average permit processing time for your permit program?"]
[]
[null,null,"Prior to your project being implemented, enter the TOTAL average time in days, starting with submission and ending with approval of a permit application. Include time related to typical correspondence and revisions.\n\nFor example: The average processing time for construction permits in the U.S. is 81 days from submission to approval, according to the World Bank's Doing Business report.  "]
[]
[]
[]
[]
[]
[]
[null,null,"Days for permit approval:"]
[]
[null,null,"What will be your new permit processing time, after you’ve streamlined the process?"]
[]
[null,null,"Estimate the total time (in days) to process a permit AFTER your process improvement is implemented, beginning with submission and ending with final approval. Include time associated with typical correspondence and revisions. \n\nFor example: If the average processing time for construction permits in the U.S. were reduced by 25%, the new permit processing time would be 61 days (81 - [25% × 81] = 61)."]
[]
[]
[]
[]
[]
[]
[null,null,"Days for permit approval:"]
[]
[null,null,{"$f":"IF(E76>E65,\"WARNING: You entered a post-process improvement time to market that exceeds your baseline time to market. Your results will show a loss in economic activity.\",\"\")","v":""}]

{"sheet":"Time to Market Results","index":3,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,1,37,12],[38,1,38,12],[39,1,39,12],[2,1,2,11],[8,1,8,10],[16,2,17,7],[14,7,14,8],[18,7,18,8],[16,8,17,11],[22,10,23,12],[10,1,11,1],[10,2,11,6],[24,5,24,8],[26,8,33,11],[35,1,35,5],[31,1,31,5],[34,7,36,12],[28,1,28,2],[29,3,30,6],[29,0,29,2],[32,0,32,5],[34,1,34,5],[31,6,31,7]]}
[]
[]
[null,"Beyond ROI Metrics: Time to Market"]
[]
[null,"Processing times for permit approvals can prevent facilities from engaging in economic activity."]
[null,"This tool calculates additional economic activity from reduced permit processing time."]
[]
[null,"The World Bank estimates that the average U.S. permit processing time for commercial construction is 81 days.1"]
[]
[]
[null,"In",{"$f":"IF(the_tm=1,\"the \",\"\")&state_tm&\":\"","v":":"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Time to Market Background Calcs'!E7","v":0}]
[null,4,"A day of economic activity in the",null,null,null,{"$f":"TRIM(LOWER(industry_tm))&\" sector in \"&IF(the_tm=1,\"the \",\"\")&state_tm","v":" sector in "},null,null,null,null,null,null,{"$f":"'Time to Market Background Calcs'!E6","v":0}]
[null,null,null,null,null,null,"is worth",{"$f":"IF('Time to Market Background Calcs'!E19<100,DOLLAR('Time to Market Background Calcs'!E19,1),DOLLAR('Time to Market Background Calcs'!E19,0))&\" million\"","v":{"$error":"#N/A"}},null," in GDP.2",null,null,null,81]
[]
[null,4,"A day of economic activity at an average facility in the ",null,null,null,null,null,{"$f":"TRIM(LOWER(industry_tm))&\" sector in \"&IF(the_tm=1,\"the \",\"\")&state_tm","v":" sector in "},null,null,null,null,{"$f":"(N15-N14)*'Time to Market Background Calcs'!E13*'Time to Market Background Calcs'!E14","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,"is worth",{"$f":"DOLLAR('Time to Market Background Calcs'!E13*1000000,0)","v":{"$error":"#N/A"}},null," in GDP.3"]
[]
[]
[null,{"$f":"\" If \"&IF(the_tm=1,\"the \",\"\")&state_tm&IF(Change_permit_time<0,\" increases\",\" reduces\")&\" the processing time for permits\"","v":" If  reduces the processing time for permits"}]
[null,"by",{"$f":"IF(Change_permit_time<0,-1*Change_permit_time,Change_permit_time)","v":0},{"$f":"IF(C23<2,\"day for\",\"days for \")","v":"day for"},{"$f":"ROUND('Time to Market Background Calcs'!E14,0)","v":{"$error":"#VALUE!"}},"facilities seeking permits in the ",null,null,null,null,{"$f":"TRIM(LOWER(industry_tm))&\" sector:\"","v":" sector:"}]
[]
[null,4,"The benefits could be as high as",null,null,{"$f":"IF(ABS('Time to Market Background Calcs'!C26)<100,DOLLAR('Time to Market Background Calcs'!C26,1),DOLLAR('Time to Market Background Calcs'!C26,0))&\" million\"","v":{"$error":"#N/A"}},null,null,null,"in economic activity each year."]
[]
[null,null,null,"Assumptions:",null,null,null,null,{"$f":"IF(Change_permit_time<0,\"Warning: the additional economic activity figure displayed here is negative, because the post-process improvement time to market exceeds\"&\" (is slower than) the baseline time to market. Therefore, this permit processing change resulted in a loss of economic activity relative to the baseline.\",\"\")","v":""}]
[]
[null,"State:",null,{"$f":"state_tm","v":0}]
["Industry/Sector:",null,null,{"$f":"TRIM(industry_tm)","v":""}]
[]
[null,"# of Facilities Affected by Permit:",null,null,null,null,{"$f":"'Time to Market Background Calcs'!E14","v":{"$error":"#VALUE!"}}]
["% of Facilities in Industry Affected by Permit:",null,null,null,null,null,{"$f":"IF('Time to Market Background Calcs'!E18<0.01,\"<1%\",'Time to Market Background Calcs'!E18)","v":{"$error":"#VALUE!"}}]
[]
[null,"Current Permit Processing Time:",null,null,null,null,{"$f":"'Time to Market Background Calcs'!E6&\" days\"","v":"0 days"},{"$f":"IF('Time to Market Background Calcs'!C66*'Time to Market Background Calcs'!E8>='Time to Market Background Calcs'!E10/2, \"Warning: The result (\"&'Time to Market Background Calcs'!C68&\" million) represents more than 50% of the annual economic activity in the sector you are permitting.\"&\"Please review your inputs to make sure you are not over-counting potentially affected facilities, and that your changes in permit timing are accurate.\", \"\")","v":{"$error":"#N/A"}}]
[null,"New, Shorter Permit Processing Time:",null,null,null,null,{"$f":"'Time to Market Background Calcs'!E7&\" days\"","v":"0 days"}]
[]
[null,"1World Bank (2015). Doing Business 2016."]
[null,"2See U.S. Department of Commerce, Bureau of Economic Analysis, Grosss-Domestic-Product-(GDP)-by-State Data 2015. Also see Gross-Domestic-Product-(GDP)-by-Industry Data, Gross Output, 1947-2015. Commercial construction scaled to state level from national proportion of total construction GDP."]
[null,"3Establishment data from U.S. County Business Patterns (2014)."]

{"sheet":"Time to Market Background Calcs","index":4,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[[53,1,55,1],[61,2,61,4],[62,1,65,1],[40,2,40,4],[41,1,43,1],[52,2,52,4],[41,2,42,4],[49,3,49,4],[58,3,58,4],[55,2,57,4],[53,2,54,4],[62,2,63,4],[65,3,66,4],[67,3,69,4],[5,2,5,3],[6,2,6,3],[19,2,20,4],[21,2,22,4],[23,3,24,4],[28,2,29,4],[31,2,32,4],[43,2,47,4],[30,2,30,4],[33,2,35,4],[25,3,27,4],[38,2,38,4],[36,2,37,4]]}
[]
[null,null,null,"State:",{"$f":"IF('Time to Market Inputs'!D7=\"\",\"\",'Time to Market Inputs'!D7)","v":""}]
[null,null,null,"Industry:",{"$f":"industry_tm","v":0}]
[null,null,"(A)",{"$f":"IF(ISBLANK(E3)=TRUE,\"\",\"  Percent of \"&TRIM(LOWER(E3))&\" in \"&E2&\":\")","v":"  Percent of 0 in :"},{"$f":"IF('Time to Market Inputs'!E46=\"\",\"\",'Time to Market Inputs'!E46)","v":""}]
[null,null,"(B)",{"$f":"\" \"&TRIM(E3)&\" establishments in \"&E2&\":\"","v":" 0 establishments in :"},{"$f":"IF('Time to Market Inputs'!E49=\"\",\"\",'Time to Market Inputs'!E49)","v":""}]
[null,null,"Days for permit approval:",null,{"$f":"'Time to Market Inputs'!E65","v":0}]
[null,"user inputs","Days for permit approval:",null,{"$f":"'Time to Market Inputs'!E76","v":0}]
[null,"outputs",null,"Change in days",{"$f":"E6-E7","v":0}]
[null,null,null,"Total establishments in state:",{"$f":"IFERROR(INDEX('BEA2'!F2:F1037,MATCH(E2&E3,'BEA2'!C2:C1037&'BEA2'!D2:D1037,0)),\"\")","v":""}]
[null,null,null,"Total GDP",{"$f":"INDEX('BEA2'!E2:E1037,MATCH(E2&E3,'BEA2'!C2:C1037&'BEA2'!D2:D1037,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"E10*E17","v":{"$error":"#N/A"}}]
[null,null,null,"One-Facility GDP",{"$f":"E10/E9","v":{"$error":"#N/A"}}]
[null,null,null,"One-facility-day",{"$f":"E12/365","v":{"$error":"#N/A"}}]
[null,null,null,"Total facilities in calculation",{"$f":"IF(E5=\"\",(E4*E9),E5)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,{"$f":"E16*Change_permit_time","v":{"$error":"#N/A"}}]
[null,null,null,"Total GDP per day",{"$f":"E11/365","v":{"$error":"#N/A"}}]
[null,null,null,"Percent of industry",{"$f":"IF(E4<>\"\",E4,IF(E5<>\"\",(E5/INDEX('BEA2'!F2:F1037,MATCH(E2&E3,'BEA2'!C2:C1037&'BEA2'!D2:D1037,0))),\"\"))","v":""}]
[null,null,null,"Percent of industry",{"$f":"IF(E4=\"\",E5/E9,E4)","v":{"$error":"#VALUE!"}}]
[null,null,null,"Daily whole industry gdp",{"$f":"E10/365","v":{"$error":"#N/A"}}]
[null,null,{"$f":"C62","v":"RESULTS"}]
[]
[null,null,{"$f":"C63","v":" time to market benefits from reductions in permit processing times for 0"}]
[]
[null,null,{"$f":"C66","v":{"$error":"#N/A"}},{"$f":"D66","v":"million in daily economic activity × 0 days of additional economic activity "}]
[]
[null,null,{"$f":"C68","v":{"$error":"#N/A"}},{"$f":"D68","v":"million in annual time to market benefits from reduced permit processing times for  0"}]
[]
[]
[null,null,"BACKGROUND CALCULATIONS"]
[]
[null,null,"Step 1"]
[null,null,{"$f":"\"Change in permit processing time for \"&LOWER(industry_tm)&\" in \"&IF(the_tm=1,\"the \",\"\")&state_tm","v":"Change in permit processing time for  in "}]
[]
[null,null,"Change = current permit processing time - old permit processing time.  The benefits calculated depend on the number of additional days of economic activity."]
[]
[]
[null,null,{"$f":"E6&\" days for permit approval pre-project - \"&E7&\" days for permit approval post-project = \"","v":"0 days for permit approval pre-project - 0 days for permit approval post-project = "}]
[]
[null,null,{"$f":"Change_permit_time&\" days of additional economic activity\"","v":"0 days of additional economic activity"}]
[]
[null,null,"Step 2"]
[null,null,{"$f":"\"Annual \"&E2&\" economic activity for \"&TRIM(LOWER(E3))","v":"Annual  economic activity for 0"}]
[]
[null,null,"From Bureau of Economic Analysis 2014 data. If you selected a percentage of the total industry, then this tool calculates the estimated economic activity by multiplying the total industry economic activity by the percent of the industry affected. If you selected a number of establishments, then this tool calculates a percentage of the industry by first dividing by the total number of establishments from the County Business Patterns 2014 data."]
[]
[]
[]
[]
[]
[null,null,{"$f":"E10","v":{"$error":"#N/A"}},{"$f":"\"million in annual economic activity × \"&ROUND(E17,4)*100&\" percent of the industry affected = \"","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"E11","v":{"$error":"#N/A"}},"million in annual economic activity"]
[]
[null,null,"Step 3"]
[null,null,{"$f":"\"Daily \"& E2& \" economic activity for \"&TRIM(LOWER(E3))","v":"Daily  economic activity for 0"}]
[]
[null,null,{"$f":"\"Annual economic activity divided by 365 days. This daily value is multiplied by the number of additional days per year of economic activity to estimate the total time to market benefits.\"&CHAR(10)&CHAR(10)&DOLLAR(C51,2)&\" \"&D51&\" in \"&TRIM(LOWER(E3))&\"  / 365 days per year\"","v":{"$error":"#N/A"}}]
[]
[]
[null,null,{"$f":"C51","v":{"$error":"#N/A"}},"million in annual economic activity / 365 days per year"]
[null,null,{"$f":"E16","v":{"$error":"#N/A"}},"million in daily economic activity"]
[]
[null,null,"RESULTS"]
[null,null,{"$f":"E2&\" time to market benefits from reductions in permit processing times for \"&TRIM(LOWER(E3))","v":" time to market benefits from reductions in permit processing times for 0"}]
[]
[]
[null,null,{"$f":"C60","v":{"$error":"#N/A"}},{"$f":"D60&\" × \"&C39&\" \"&D39","v":"million in daily economic activity × 0 days of additional economic activity "}]
[]
[null,null,{"$f":"IF(E15>100,DOLLAR(E15,0),DOLLAR(E15,1))","v":{"$error":"#N/A"}},{"$f":"\"million in annual time to market benefits from reduced permit processing times for \"&E2&\" \"&TRIM(LOWER(E3))","v":"million in annual time to market benefits from reduced permit processing times for  0"}]

{"sheet":"Trusted Transactions Start","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,2,3],[4,1,8,3],[9,1,14,3]]}
[]
[null,"ePERMITTING BENEFITS CALCULATOR:\nTRUSTED TRANSACTIONS METRIC"]
[]
[]
[null,"Trusted transactions include more efficient, transparent interfaces and systems, which can reduce the high cost of negative and/or defensive interactions between the regulated community and the regulating agency. The benefits to the regulated community include increased certainty by the applicant that interactions will result in positive, productive outcomes with high confidence in the process, rather than protracted exchanges with uncertain timing and/or results. "]
[]
[]
[]
[]
[null,"This metric quantifies the value to regulated entities of realigning compliance staff to additional value-added use. This tool includes several national averages for compliance staff time and wages, which can be used or customized by the user. The only inputs required are the number of firms affected by the relevant permit/requirement and the estimated percent of compliance staff time that can be repurposed to value-added use due to the permit process improvement.  "]

{"sheet":"Trusted Transactions Inputs","index":6,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[14,1,15,3],[12,1,12,2],[1,1,2,3],[10,1,11,3],[3,1,4,3],[5,1,6,3],[33,1,35,3],[37,1,37,2],[25,1,27,3],[21,0,21,2],[16,1,19,3],[23,1,24,3],[31,1,32,3],[29,1,29,2]]}
[]
[null,"TRUSTED TRANSACTIONS"]
[]
[null,"In which state is your project being implemented?"]
[]
[null,"Select a state from the drop down list by clicking in the cell below. Select 'United States' to use national-level data."]
[]
[]
[null,"State:"]
[]
[null,"How many firms are affected by your ePermitting streamlining?"]
[]
[null,"Enter number of firms affected:"]
[]
[null,"Weekly Compliance Time Before Process Improvement"]
[]
[null,"The average weekly per-firm compliance time spent is 3.5 hours, according to the Thomson Reuters Cost of Compliance 2015. This is the average for all firms, and all compliance, so there may be a difference in environmental compliance for the applicable firms. This tool uses this average of 3.5 hours/week unless you choose to enter a new number in the cell below."]
[]
[]
[]
[]
["Time spent on environmental compliance (hours/week):",null,null,3.5]
[]
[null,"Average Compliance Staff Cost"]
[]
[null,"The average compliance staff cost is $48.48/hour, according to U.S. Census Bureau's 2014 Statistics of U.S. Businesses (SUSB). This tool uses this average of $48.48 unless you choose to enter a new number in the cell below."]
[]
[]
[]
[null,"Average compliance staff wage (hourly):",null,48.48]
[]
[null,"Repurposing of Compliance Staff"]
[]
[null,"This metric estimates benefits of repurposing compliance staff to additional value-added use. How much time do you estimate your ePermitting project will save regulated firms in transactions related to compliance (percentage savings)?"]
[]
[]
[]
[null,"Enter the percent of compliance labor time repurposed:"]

{"sheet":"Trusted Transactions Results","index":7,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,1,33,12],[34,1,39,12],[11,7,11,10],[15,7,15,10],[21,6,21,8],[2,1,2,11],[9,1,10,1],[11,1,14,1],[3,1,6,11],[27,12,30,12],[26,1,26,5],[24,12,25,12],[27,1,27,5],[29,1,29,5],[24,1,24,5],[30,0,30,5]]}
[]
[]
[null,"Beyond ROI Metrics: Trusted Transactions"]
[null,"More efficient, transparent interfaces and systems can reduce the high cost of interactions between the regulated firms and the regulating agency. An increase in trusted transactions can allow regulated firms to realign compliance staff towards additional value-added use, improving economic efficiency."]
[]
[]
[]
[null,"Thomson Reuters estimates that each firm spends an average of 3.5 hours per week on compliance.1"]
[null,"In",{"$f":"IF(the_tt=1,\"the \",\"\")&state_tt&\":\"","v":":"}]
[]
[null,null,"One year of regulatory compliance for firms considered in the analysis",null,null,null,null,null,null,{"$f":"\"in \"&IF(the_tt=1,\"the \",\"\")&state_tt","v":"in "},null,null,null,{"$f":"G31*52","v":0}]
[null,null,null,null,null,null,"costs",{"$f":"DOLLAR('Trusted Trans. Background Calcs'!F9,0)","v":"$0"},null,null,null,"in compliance labor.2",null,{"$f":"G30*52","v":182}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,182]
[null,null,"One year of regulatory compliance for one firm considered in the analysis",null,null,null,null,null,null,null,{"$f":"\"in \"&IF(the_tt=1,\"the \",\"\")&state_tt","v":"in "},null,null,{"$f":"(3.5-G30)*G28*G27*52","v":0}]
[]
[null,null,null,null,null,null,"costs",{"$f":"DOLLAR('Trusted Trans. Background Calcs'!F8,0)","v":"$8,823"},null,null,null,"in compliance labor."]
[]
[]
[null,{"$f":"\" If \"&IF(the_tt=1,\"the \",\"\")&state_tt&\" repurposes regulatory compliance labor to additional value-added use\"","v":" If  repurposes regulatory compliance labor to additional value-added use"}]
[null,"by",{"$f":"'Trusted Trans. Background Calcs'!F10","v":0},"for",{"$f":"'Trusted Trans. Background Calcs'!F4","v":0},"firms considered in the analysis: "]
[]
[null,4,"The benefits could be as high as",null,null,null,{"$f":"DOLLAR('Trusted Trans. Background Calcs'!F11,0)","v":"$0"},null,null,"in repurposed compliance staff."]
[]
[null,null,null,null,null,"Assumptions:"]
[null,"State:",null,null,null,null,{"$f":"state_tt","v":0}]
[]
[null,"# of Firms Affected by Permit:",null,null,null,null,{"$f":"'Trusted Trans. Background Calcs'!F4","v":0}]
[null,"Compliance Labor Rate ($/hr):",null,null,null,null,{"$f":"DOLLAR('Trusted Trans. Background Calcs'!F7)","v":"$48.48"}]
[]
[null,"Current Compliance Staff Burden (hr/wk):",null,null,null,null,{"$f":"'Trusted Trans. Background Calcs'!F5","v":3.5}]
["Time Repurposed to Value-Added Use (hr/wk):",null,null,null,null,null,{"$f":"C20*G30","v":0}]
[]
[null,"13.5 hours is calculated as a weighted average  of all weekly compliance time associated with legal, internal audit, and risk activities. Stacey English and Susannah Hammond, Thomson Reuters, Cost of Compliance 2015."]
[]
[null,"2$48.48 is the average fully-loaded wage rate for compliance offices in the U.S.  See U.S. Department of Commerce, U.S. Census Bureau, 2014 Statistics of U.S. Businesses (SUSB) Annual Data Tables by Establishment Industry."]

{"sheet":"Trusted Trans. Background Calcs","index":8,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[12,1,13,3],[21,1,22,3],[24,1,24,3],[36,2,36,3],[41,2,41,3],[43,2,43,3],[14,1,14,3],[30,1,30,3],[38,1,38,3],[16,2,18,3],[33,2,34,3],[28,2,28,3],[26,2,26,3]]}
[]
[null,"Inputs",null,null,null,"Output Sheet"]
[null,"State",null,{"$f":"'Trusted Transactions Inputs'!C9","v":0},null,{"$f":"D3","v":0}]
[null,"Total Regulated Firms (number of permits)",null,{"$f":"'Trusted Transactions Inputs'!D13","v":0},null,{"$f":"D4","v":0}]
[null,"Weekly Compliance Time",null,{"$f":"'Trusted Transactions Inputs'!D22","v":3.5},null,3.5]
[null,"Annual Compliance Time",null,{"$f":"D5*52","v":182},null,182]
[null,"Average Compliance Staff Cost",null,{"$f":"'Trusted Transactions Inputs'!D30","v":48.48},null,48.48]
[null,"per Firm Annual Compliance cost",null,{"$f":"D7*D6","v":8823.3599999999988},null,8823.3599999999988]
[null,"Total Colorado Compliance costs",null,{"$f":"D8*D4","v":0},null,0]
[null,"Reduction in time",null,{"$f":"'Trusted Transactions Inputs'!D38","v":0},null,0]
[null,"Reduction in Compliance costs",null,{"$f":"D10*D9","v":0},null,0]
[]
[null,"RESULTS"]
[]
[null,"Trusted Transactions Benefits from Repurposing Compliance Staff"]
[]
[null,{"$f":"D9","v":0},{"$f":"\"in annual costs associated with regulatory compliance staffing in \"&IF(the_tt=1,\"the \",\"\")&state_tt&\" for the facilities considered x \"&D10*100&\" percent repurposing of compliance labor\"","v":"in annual costs associated with regulatory compliance staffing in  for the facilities considered x 0 percent repurposing of compliance labor"}]
[]
[]
[null,{"$f":"D11","v":0},"in total compliance staff repurposed to value-added use"]
[]
[null,"BACKGROUND CALCULATIONS"]
[]
[null,null,"Step 1"]
[null,"Annual Compliance Labor Time per Firm"]
[]
[null,{"$f":"D5","v":3.5},"hours in weekly compliance × 52 weeks per year ="]
[]
[null,{"$f":"D6","v":182},"hours in annual compliance time"]
[]
[null,"Step 2"]
[null,"Annual Compliance Labor Cost per Firm"]
[]
[null,{"$f":"D6","v":182},{"$f":"\"hours in annual time spent on environmental compliance × $\"&D7&\" in hourly wages for compliance staff = \"","v":"hours in annual time spent on environmental compliance × $48.48 in hourly wages for compliance staff = "}]
[]
[]
[null,{"$f":"D9/D4","v":{"$error":"#DIV/0!"}},"in total environmenal compliance costs per firm per year"]
[]
[null,"Step 3"]
[null,{"$f":"\"Total Annual Compliance Labor Costs in \"&IF(the_tt=1,\"the \",\"\")&state_tt","v":"Total Annual Compliance Labor Costs in "}]
[]
[null,{"$f":"B37","v":{"$error":"#DIV/0!"}},{"$f":"\"compliance labor costs per firm × \"&D4&\" regulated firms \"","v":"compliance labor costs per firm × 0 regulated firms "}]
[]
[null,{"$f":"D9","v":0},"in total compliance labor costs across all regulated firms"]

{"sheet":"Right Info, Right Time Start","index":9,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,2,2,4],[4,2,15,4]]}
[]
[null,null,"ePERMITTING BENEFITS CALCULATOR:\n RIGHT INFO, RIGHT TIME METRIC"]
[]
[]
[null,null,"The right info, right time metric estimates benefits of reducing time spent by the public/industry on searching for/accessing data (e.g., online driver’s license renewals vs. in-person). This benefit results from the ability of the regulated community or public to pull high-quality information from a platform, rather than having to directly request information or otherwise interface with agency staff in order to make questions or needs known.  \n\nEase of use and enhanced access to information through electronic platforms reduces the time users spend searching for information, and minimizes the need to file formal requests to obtain data. Users have the flexibility to conduct transactions outside of business hours (as electronic platforms feature round-the-clock access) and save time by receiving information electronically. \n\n"]

{"sheet":"Right Info, Right Time Inputs","index":10,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,1,41,2],[33,1,33,2],[34,1,35,3],[36,1,39,3],[20,1,22,3],[27,1,28,3],[29,1,30,3],[23,1,25,2],[1,1,1,3],[13,1,13,2],[31,1,32,2],[9,1,11,3],[7,1,8,3],[18,1,19,3],[15,1,15,2],[2,1,3,3],[16,2,16,3]]}
[]
[null,"In which state is your project being implemented?"]
[null,"Select a staten from the drop down list by clicking in the cell below. Select 'United States' to use national-level data."]
[]
[]
[null,"State:"]
[]
[null,"Total Information Requests/Transactions Affected by Streamlining ePermitting Processes"]
[]
[null,"This metric uses the number of transactions affected by the ePermitting process improvements to determine the overall cost savings to the public and firms in your state. How many information requests or transactions do you conduct for the facilities/citizens considered in this analysis?"]
[]
[]
[]
[null,"Enter number of transactions/requests:"]
[null,null,null,null,null,null,"One day"]
[null,"Time period of transactions/requests:",null,null,null,null,"One month"]
[null,null,"Choose one day/month/year from the dropdown by clicking in the cell",null,null,null,"One year"]
[]
[null,"Average Time of Each Information Request/Transaction"]
[]
[null,"The average time per interaction is 10 minutes (0.17 hours) from the Deloitte 2015 Doing Business Report. This tool uses this average of 0.17 hours per information request/transaction unless you choose to enter a new number."]
[]
[]
[null,"If you want to enter a different average time, enter it here in hours (e.g., 30 minutes would be 0.50 hours; 60 minutes would be 1.00 hours; 90 minutes would be 1.50 hours):"]
[null,null,null,0.17]
[]
[]
[null,"Median U.S. Wage Rate"]
[]
[null,"The median U.S. wage rate is $17.81/hour. This tool uses this median of $17.81 unless you choose to enter a new number."]
[]
[null,"If you want to enter a different wage rate,\nenter it here in $/hr:"]
[null,null,null,17.809999999999999]
[]
[null,"Reduction in Number/Time of Transactions"]
[]
[null,"This metric estimates benefits of reducing the time spent on in-person transactions. By how much does your ePermitting process improvement reduce the time spent on requesting information or conducting transactions (percentage basis)?"]
[]
[]
[]
[]
[null,"Enter the percent reduction here:"]

{"sheet":"Right Info, Right Time Results","index":11,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,1,35,11],[36,1,36,11],[24,11,27,11],[29,11,32,11],[32,0,32,5],[31,0,31,5],[27,6,27,8],[24,5,24,6],[2,1,2,10],[14,1,15,1],[4,1,6,10],[16,7,16,8],[22,6,22,7],[7,1,8,10],[12,7,12,8]]}
[]
[]
[null,"                 Beyond ROI Metrics: Right Info, Right Time"]
[]
[null,"It takes time for the public and/or firms to conduct transactions and request information from the government in-person. Providing the right information at the right time can increase economic efficiency."]
[]
[]
[null,"Deloitte estimates that the average time to request information or conduct a transaction with the government is 10 minutes (0.17 hours), extrapolating Deloitte's findings to the national population suggests that there are 1.16 billion such requests in the United States each year.1"]
[]
[null,"In",{"$f":"IF(the_rr=1,\"the \",\"\")&state_rr&\":\"","v":":"}]
[]
[null,4,"One year of transactions/requests for firms and citizens considered in this analysis",null,null,null,null,null,null,null,{"$f":"\"in \"&IF(the_rr=1,\"the \",\"\")&state_rr","v":"in "}]
[null,null,null,null,null,null,"takes",{"$f":"TEXT('Right Info, Right Time Calcs'!D8*'Right Info, Right Time Calcs'!D6,\"#,##0\")&\" hours\"","v":{"$error":"#VALUE!"}},null,"to complete.",null,null,{"$f":"G33*G29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G32*G29","v":{"$error":"#VALUE!"}}]
[null,"4\n\n","One year of transactions/requests for firms and citizens considered in this analysis",null,null,null,null,null,null,null,{"$f":"\"in \"&IF(the_rr=1,\"the \",\"\")&state_rr","v":"in "},null,{"$f":"0.17*G32","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(0.17*17.4*G32)-(G29*G32*G30)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"is worth",{"$f":"DOLLAR('Right Info, Right Time Calcs'!D9,0)","v":{"$error":"#VALUE!"}},null,"in total opportunity costs.2",null,null,{"$f":"G23","v":{"$error":"#VALUE!"}}]
[]
[]
[null,{"$f":"\" If \"&IF(the_rr=1,\"the \",\"\")&state_rr&\" reduces the number of in-person information requests and transactions\"","v":" If  reduces the number of in-person information requests and transactions"}]
[null,"by",{"$f":"'Right Info, Right Time Calcs'!D10","v":0},"for firms and citizens considered in this analysis:"]
[]
[null,4,"The benefits could be as high as",null,null,null,{"$f":"DOLLAR('Right Info, Right Time Calcs'!D11,0)","v":{"$error":"#VALUE!"}},null,"in economic activity each year."]
[]
[null,null,null,null,null,"Assumptions:"]
[]
[null,null,null,null,null,"State:",{"$f":"state_rr","v":0}]
[]
[null,null,null,null,null,"Time per interaction (hours):",{"$f":"'Right Info, Right Time Calcs'!D8","v":0.17}]
[null,null,null,null,null,"Wage Rate ($/hour):",{"$f":"'Right Info, Right Time Calcs'!D7","v":17.809999999999999}]
[]
["Current Number of Transactions Per Year:",null,null,null,null,null,{"$f":"'Right Info, Right Time Calcs'!D6","v":""}]
["Percent Reduction in Number/Time:",null,null,null,null,null,{"$f":"percent_rr","v":0}]
[]
[null,"110 minutes is estimated by Deloitte for Australia. The total number of U.S. transactions is scaled from the Austrailian estimate based on population. See Deloitte, 2015. Digital Government Transformation."]
[]
[null,"2See Bureau of Labor Statistics, National Occupational Employment and Wage Estimates 2016."]

{"sheet":"Right Info, Right Time Calcs","index":12,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,1,13,3],[28,2,28,3],[29,1,29,3],[38,2,39,3],[41,2,42,3],[22,1,22,3],[25,1,27,3],[14,2,16,3],[34,1,34,3],[31,2,32,3],[18,2,18,3],[20,1,21,3],[23,1,24,3],[35,1,36,3]]}
[]
[null,"Inputs"]
[null,"State",null,{"$f":"'Right Info, Right Time Inputs'!C6","v":0}]
[null,"State transactions",null,{"$f":"'Right Info, Right Time Inputs'!D14","v":0}]
[null,"Time period",null,{"$f":"'Right Info, Right Time Inputs'!D16","v":0}]
[null,"Total transactions",null,{"$f":"IF(D5=\"One day\",D4*365,IF(D5=\"One month\",D4*12,IF(D5=\"One year\",D4,\"\")))","v":""}]
[null,"Wage Rate",null,{"$f":"'Right Info, Right Time Inputs'!D33","v":17.809999999999999}]
[null,"Avg time of transaction",null,{"$f":"'Right Info, Right Time Inputs'!D25","v":0.17}]
[null,"Total cost",null,{"$f":"D8*D7*D6","v":{"$error":"#VALUE!"}}]
[null,"Reduction in time",null,{"$f":"'Right Info, Right Time Inputs'!D42","v":0}]
[null,"Total benefits",null,{"$f":"D10*D9","v":{"$error":"#VALUE!"}}]
[]
[null,"RESULTS"]
[]
[null,{"$f":"D9","v":{"$error":"#VALUE!"}},{"$f":"\"in annual costs associated with requesting information and conducting transactions in \"&IF(the_rr=1,\"the \",\"\")&state_rr&\" × \"&D10*100&\" percent reduction in total time\"","v":"in annual costs associated with requesting information and conducting transactions in  × 0 percent reduction in total time"}]
[]
[]
[]
[null,{"$f":"D11","v":{"$error":"#VALUE!"}},"in savings associated with ePermitting process improvements"]
[]
[null,"BACKGROUND CALCULATIONS"]
[]
[null,"Step 1"]
[null,{"$f":"\"Time Spent Conducting Transactions / Requesting Information in \"&IF(the_rr=1,\"the \",\"\")&state_rr","v":"Time Spent Conducting Transactions / Requesting Information in "}]
[]
[null,"According to the Deloitte 2015 Doing Business Survey, each request or transaction takes 0.17 hours to complete.  "]
[]
[]
[null,{"$f":"D6","v":""},{"$f":"\"total transactions × \"&D8&\" hours per request/transaction\"","v":"total transactions × 0.17 hours per request/transaction"}]
[null,{"$f":"\"(\"&D4&\" transactions per \"&RIGHT(D5,LEN(D5)-4)&IF(D5=\"One day\",\" × 365 days per year) \",IF(D5=\"One month\",\" × 12 months per year)\",\")\"))","v":{"$error":"#VALUE!"}}]
[]
[null,{"$f":"D6*D8","v":{"$error":"#VALUE!"}},"total hours per year spent requesting information or conducting transactions"]
[]
[]
[null,"Step 2"]
[null,{"$f":"\"Cost of Time Conducting Transactions / Requesting Information in \"&IF(the_rr=1,\"the \",\"\")&state_rr","v":"Cost of Time Conducting Transactions / Requesting Information in "}]
[]
[]
[null,{"$f":"B32","v":{"$error":"#VALUE!"}},{"$f":"\"hours spent per year requesting information / conducting transactions × $\"&ROUND(D7,2)&\" hourly wage rate \"","v":"hours spent per year requesting information / conducting transactions × $17.81 hourly wage rate "}]
[]
[]
[null,{"$f":"D9","v":{"$error":"#VALUE!"}},"in total costs to citizens/firms to request information or conduct transactions"]

{"sheet":"BEA1","index":13,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Area","State","Fips","Proportion of All Industry Total GDP 2015"]
["United States","US","00",1]
["Alabama","AL","01",1.1000000000000001E-2]
["Alaska","AK","02",3.0000000000000001E-3]
["Arizona","AZ","04",1.6E-2]
["Arkansas","AR","05",6.9999999999999993E-3]
["California","CA","06",0.13800000000000001]
["Colorado","CO","08",1.8000000000000002E-2]
["Connecticut","CT","09",1.3999999999999999E-2]
["Delaware","DE","10",4.0000000000000001E-3]
["District of Columbia","DC","11",6.9999999999999993E-3]
["Florida","FL","12",0.05]
["Georgia","GA","13",2.7999999999999997E-2]
["Hawaii","HI","15",4.0000000000000001E-3]
["Idaho","ID","16",4.0000000000000001E-3]
["Illinois","IL","17",4.2999999999999997E-2]
["Indiana","IN","18",1.9E-2]
["Iowa","IA","19",0.01]
["Kansas","KS","20",8.0000000000000002E-3]
["Kentucky","KY","21",1.1000000000000001E-2]
["Louisiana","LA","22",1.3000000000000001E-2]
["Maine","ME","23",3.0000000000000001E-3]
["Maryland","MD","24",0.02]
["Massachusetts","MA","25",2.7000000000000003E-2]
["Michigan","MI","26",2.6000000000000002E-2]
["Minnesota","MN","27",1.8000000000000002E-2]
["Mississippi","MS","28",6.0000000000000001E-3]
["Missouri","MO","29",1.6E-2]
["Montana","MT","30",3.0000000000000001E-3]
["Nebraska","NE","31",6.0000000000000001E-3]
["Nevada","NV","32",7.999999999999674E-3]
["New Hampshire","NH","33",4.0000000000000001E-3]
["New Jersey","NJ","34",3.2000000000000001E-2]
["New Mexico","NM","35",5.0000000000000001E-3]
["New York","NY","36",0.08]
["North Carolina","NC","37",2.7999999999999997E-2]
["North Dakota","ND","38",3.0000000000000001E-3]
["Ohio","OH","39",3.4000000000000002E-2]
["Oklahoma","OK","40",0.01]
["Oregon","OR","41",1.2E-2]
["Pennsylvania","PA","42",0.04]
["Rhode Island","RI","44",3.0000000000000001E-3]
["South Carolina","SC","45",1.1000000000000001E-2]
["South Dakota","SD","46",3.0000000000000001E-3]
["Tennessee","TN","47",1.8000000000000002E-2]
["Texas","TX","48",9.0999999999999998E-2]
["Utah","UT","49",8.0000000000000002E-3]
["Vermont","VT","50",2E-3]
["Virginia","VA","51",2.7000000000000003E-2]
["Washington","WA","53",2.5000000000000001E-2]
["West Virginia","WV","54",4.0000000000000001E-3]
["Wisconsin","WI","55",1.7000000000000001E-2]
["Wyoming","WY","56",2E-3]

{"sheet":"BEA2","index":14,"n_rows":1037,"n_cols":6,"rows_kept":1037,"cut":false,"hidden":false,"merged":[]}
["BEA code","ST","State","Industry","GDP (mil $)","Establishments"]
["1","US","United States","All industry total",17277550,7563085]
["3","US","United States","Agriculture, forestry, fishing, and hunting",203186,21844]
["6","US","United States","Mining",482710,29754]
["7","US","United States","Oil and gas extraction",338224,8256]
["10","US","United States","Utilities",283102,17962]
["11","US","United States","All construction",672052,667099]
["11.1","US","United States","Commercial construction",117213,37921]
["11.2","US","United States","Highway, street, and bridge construction",36568,9920]
["11.5","US","United States","Residential building construction",283590,159792]
["12","US","United States","All manufacturing",2099426,292543]
["16","US","United States","Primary metals manufacturing",58621,4558]
["26","US","United States","Food/beverage manufacturing",246305,26947]
["32","US","United States","Chemical products manufacturing",364589,13079]
["34","US","United States","Wholesale trade",1047883,416593]
["35","US","United States","Retail trade",1003628,1065368]
["36","US","United States","Transportation and warehousing",510191,220565]
["67","US","United States","Waste management and remediation",43216,23743]
["70","US","United States","Health care and social assistance",1223154,855253]
["78","US","United States","Accommodation and food services",486721,679296]
["81","US","United States","Other services, except government",381169,739945]
["1","AL","Alabama","All industry total",194421,97714]
["3","AL","Alabama","Agriculture, forestry, fishing, and hunting",2909,799]
["6","AL","Alabama","Mining",3142,238]
["7","AL","Alabama","Oil and gas extraction",795,35]
["10","AL","Alabama","Utilities",5326,436]
["11","AL","Alabama","All construction",7083,7282]
["11.1","AL","Alabama","Commercial construction",1235,599]
["11.2","AL","Alabama","Highway, street, and bridge construction",385,181]
["11.5","AL","Alabama","Residential building construction",2989,1319]
["12","AL","Alabama","All manufacturing",34343,4179]
["16","AL","Alabama","Primary metals manufacturing",3775,105]
["26","AL","Alabama","Food/beverage manufacturing",2482,285]
["32","AL","Alabama","Chemical products manufacturing",4078,183]
["34","AL","Alabama","Wholesale trade",11095,5348]
["35","AL","Alabama","Retail trade",13921,18029]
["36","AL","Alabama","Transportation and warehousing",5153,2893]
["67","AL","Alabama","Waste management and remediation",447,321]
["70","AL","Alabama","Health care and social assistance",13711,10313]
["78","AL","Alabama","Accommodation and food services",5200,8395]
["81","AL","Alabama","Other services, except government",4950,10913]
["1","AK","Alaska","All industry total",58253,20752]
["3","AK","Alaska","Agriculture, forestry, fishing, and hunting",618,440]
["6","AK","Alaska","Mining",16793,178]
["7","AK","Alaska","Oil and gas extraction",12867,28]
["10","AK","Alaska","Utilities",715,100]
["11","AK","Alaska","All construction",2144,2511]
["11.1","AK","Alaska","Commercial construction",374,247]
["11.2","AK","Alaska","Highway, street, and bridge construction",117,96]
["11.5","AK","Alaska","Residential building construction",905,538]
["12","AK","Alaska","All manufacturing",1522,529]
["16","AK","Alaska","Primary metals manufacturing",2,5]
["26","AK","Alaska","Food/beverage manufacturing",711,155]
["32","AK","Alaska","Chemical products manufacturing",32,3]
["34","AK","Alaska","Wholesale trade",1259,745]
["35","AK","Alaska","Retail trade",2198,2496]
["36","AK","Alaska","Transportation and warehousing",5800,1141]
["67","AK","Alaska","Waste management and remediation",210,152]
["70","AK","Alaska","Health care and social assistance",3310,2506]
["78","AK","Alaska","Accommodation and food services",1412,2120]
["81","AK","Alaska","Other services, except government",868,1815]
["1","AZ","Arizona","All industry total",280166,134434]
["3","AZ","Arizona","Agriculture, forestry, fishing, and hunting",2352,194]
["6","AZ","Arizona","Mining",7186,234]
["7","AZ","Arizona","Oil and gas extraction",38,19]
["10","AZ","Arizona","Utilities",5596,256]
["11","AZ","Arizona","All construction",11468,11438]
["11.1","AZ","Arizona","Commercial construction",2000,679]
["11.2","AZ","Arizona","Highway, street, and bridge construction",624,151]
["11.5","AZ","Arizona","Residential building construction",4839,2324]
["12","AZ","Arizona","All manufacturing",22768,4224]
["16","AZ","Arizona","Primary metals manufacturing",884,72]
["26","AZ","Arizona","Food/beverage manufacturing",1710,259]
["32","AZ","Arizona","Chemical products manufacturing",758,170]
["34","AZ","Arizona","Wholesale trade",16232,6607]
["35","AZ","Arizona","Retail trade",21718,17944]
["36","AZ","Arizona","Transportation and warehousing",8542,3206]
["67","AZ","Arizona","Waste management and remediation",744,398]
["70","AZ","Arizona","Health care and social assistance",22803,17397]
["78","AZ","Arizona","Accommodation and food services",9321,11955]
["81","AZ","Arizona","Other services, except government",6096,10886]
["1","AR","Arkansas","All industry total",117854,64670]
["3","AR","Arkansas","Agriculture, forestry, fishing, and hunting",4103,648]
["6","AR","Arkansas","Mining",4035,405]
["7","AR","Arkansas","Oil and gas extraction",3128,112]
["10","AR","Arkansas","Utilities",2927,328]
["11","AR","Arkansas","All construction",4229,5130]
["11.1","AR","Arkansas","Commercial construction",738,349]
["11.2","AR","Arkansas","Highway, street, and bridge construction",230,115]
["11.5","AR","Arkansas","Residential building construction",1785,904]
["12","AR","Arkansas","All manufacturing",17608,2615]
["16","AR","Arkansas","Primary metals manufacturing",1321,57]
["26","AR","Arkansas","Food/beverage manufacturing",3865,261]
["32","AR","Arkansas","Chemical products manufacturing",1068,107]
["34","AR","Arkansas","Wholesale trade",8418,3439]
["35","AR","Arkansas","Retail trade",8109,10866]
["36","AR","Arkansas","Transportation and warehousing",4968,2362]
["67","AR","Arkansas","Waste management and remediation",276,236]
["70","AR","Arkansas","Health care and social assistance",9168,7536]
["78","AR","Arkansas","Accommodation and food services",2842,5454]
["81","AR","Arkansas","Other services, except government",2586,6592]
["1","CA","California","All industry total",2350807,889646]
["3","CA","California","Agriculture, forestry, fishing, and hunting",38247,1861]
["6","CA","California","Mining",20637,839]
["7","CA","California","Oil and gas extraction",17308,234]
["10","CA","California","Utilities",28116,1213]
["11","CA","California","All construction",82162,67545]
["11.1","CA","California","Commercial construction",14330,4122]
["11.2","CA","California","Highway, street, and bridge construction",4471,781]
["11.5","CA","California","Residential building construction",34670,18250]
["12","CA","California","All manufacturing",266364,38293]
["16","CA","California","Primary metals manufacturing",1750,402]
["26","CA","California","Food/beverage manufacturing",26115,3608]
["32","CA","California","Chemical products manufacturing",52433,1552]
["34","CA","California","Wholesale trade",130325,59379]
["35","CA","California","Retail trade",134069,107469]
["36","CA","California","Transportation and warehousing",53984,22057]
["67","CA","California","Waste management and remediation",5594,1894]
["70","CA","California","Health care and social assistance",142656,106503]
["78","CA","California","Accommodation and food services",62008,81819]
["81","CA","California","Other services, except government",51055,72217]
["1","CO","Colorado","All industry total",304943,158064]
["3","CO","Colorado","Agriculture, forestry, fishing, and hunting",2686,310]
["6","CO","Colorado","Mining",19575,1380]
["7","CO","Colorado","Oil and gas extraction",14178,455]
["10","CO","Colorado","Utilities",4025,388]
["11","CO","Colorado","All construction",15559,16388]
["11.1","CO","Colorado","Commercial construction",2714,794]
["11.2","CO","Colorado","Highway, street, and bridge construction",847,218]
["11.5","CO","Colorado","Residential building construction",6565,3691]
["12","CO","Colorado","All manufacturing",21814,4958]
["16","CO","Colorado","Primary metals manufacturing",305,39]
["26","CO","Colorado","Food/beverage manufacturing",4042,527]
["32","CO","Colorado","Chemical products manufacturing",1815,205]
["34","CO","Colorado","Wholesale trade",16980,7206]
["35","CO","Colorado","Retail trade",16367,18643]
["36","CO","Colorado","Transportation and warehousing",10171,3621]
["67","CO","Colorado","Waste management and remediation",761,565]
["70","CO","Colorado","Health care and social assistance",18146,15355]
["78","CO","Colorado","Accommodation and food services",9437,13094]
["81","CO","Colorado","Other services, except government",6916,13626]
["1","CT","Connecticut","All industry total",245160,88555]
["3","CT","Connecticut","Agriculture, forestry, fishing, and hunting",325,72]
["6","CT","Connecticut","Mining",200,74]
["7","CT","Connecticut","Oil and gas extraction",0,3]
["10","CT","Connecticut","Utilities",4525,139]
["11","CT","Connecticut","All construction",7290,7845]
["11.1","CT","Connecticut","Commercial construction",1271,367]
["11.2","CT","Connecticut","Highway, street, and bridge construction",397,120]
["11.5","CT","Connecticut","Residential building construction",3076,1630]
["12","CT","Connecticut","All manufacturing",27340,4198]
["16","CT","Connecticut","Primary metals manufacturing",400,72]
["26","CT","Connecticut","Food/beverage manufacturing",1373,293]
["32","CT","Connecticut","Chemical products manufacturing",4544,156]
["34","CT","Connecticut","Wholesale trade",15953,4324]
["35","CT","Connecticut","Retail trade",13597,12542]
["36","CT","Connecticut","Transportation and warehousing",4128,1620]
["67","CT","Connecticut","Waste management and remediation",713,375]
["70","CT","Connecticut","Health care and social assistance",20089,10504]
["78","CT","Connecticut","Accommodation and food services",5045,8454]
["81","CT","Connecticut","Other services, except government",4919,9301]
["1","DE","Delaware","All industry total",65419,24312]
["3","DE","Delaware","Agriculture, forestry, fishing, and hunting",651,36]
["6","DE","Delaware","Mining",3,19]
["7","DE","Delaware","Oil and gas extraction",0,5]
["10","DE","Delaware","Utilities",830,55]
["11","DE","Delaware","All construction",2197,2172]
["11.1","DE","Delaware","Commercial construction",383,99]
["11.2","DE","Delaware","Highway, street, and bridge construction",120,31]
["11.5","DE","Delaware","Residential building construction",927,567]
["12","DE","Delaware","All manufacturing",4301,592]
["16","DE","Delaware","Primary metals manufacturing",33,4]
["26","DE","Delaware","Food/beverage manufacturing",1055,65]
["32","DE","Delaware","Chemical products manufacturing",952,53]
["34","DE","Delaware","Wholesale trade",2296,1083]
["35","DE","Delaware","Retail trade",2880,3627]
["36","DE","Delaware","Transportation and warehousing",999,640]
["67","DE","Delaware","Waste management and remediation",128,76]
["70","DE","Delaware","Health care and social assistance",4521,2544]
["78","DE","Delaware","Accommodation and food services",1350,2000]
["81","DE","Delaware","Other services, except government",932,2166]
["1","DC","District of Columbia","All industry total",116446,22210]
["3","DC","District of Columbia","Agriculture, forestry, fishing, and hunting",1,1]
["6","DC","District of Columbia","Mining",0,6]
["7","DC","District of Columbia","Oil and gas extraction",0,4]
["10","DC","District of Columbia","Utilities",1149,49]
["11","DC","District of Columbia","All construction",1553,449]
["11.1","DC","District of Columbia","Commercial construction",271,97]
["11.2","DC","District of Columbia","Highway, street, and bridge construction",85,9]
["11.5","DC","District of Columbia","Residential building construction",655,139]
["12","DC","District of Columbia","All manufacturing",243,98]
["26","DC","District of Columbia","Food/beverage manufacturing",22,18]
["32","DC","District of Columbia","Chemical products manufacturing",100,5]
["34","DC","District of Columbia","Wholesale trade",1123,452]
["35","DC","District of Columbia","Retail trade",1360,1740]
["36","DC","District of Columbia","Transportation and warehousing",392,160]
["67","DC","District of Columbia","Waste management and remediation",35,26]
["70","DC","District of Columbia","Health care and social assistance",5208,2084]
["78","DC","District of Columbia","Accommodation and food services",3674,2506]
["81","DC","District of Columbia","Other services, except government",7501,4152]
["1","FL","Florida","All industry total",833369,519875]
["3","FL","Florida","Agriculture, forestry, fishing, and hunting",6376,997]
["6","FL","Florida","Mining",1583,268]
["7","FL","Florida","Oil and gas extraction",78,30]
["10","FL","Florida","Utilities",14900,738]
["11","FL","Florida","All construction",35636,46585]
["11.1","FL","Florida","Commercial construction",6215,2561]
["11.2","FL","Florida","Highway, street, and bridge construction",1939,458]
["11.5","FL","Florida","Residential building construction",15037,9714]
["12","FL","Florida","All manufacturing",42246,12912]
["16","FL","Florida","Primary metals manufacturing",531,116]
["26","FL","Florida","Food/beverage manufacturing",5827,986]
["32","FL","Florida","Chemical products manufacturing",5616,578]
["34","FL","Florida","Wholesale trade",58197,31443]
["35","FL","Florida","Retail trade",63954,73200]
["36","FL","Florida","Transportation and warehousing",27484,13870]
["67","FL","Florida","Waste management and remediation",1826,1151]
["70","FL","Florida","Health care and social assistance",70115,57662]
["78","FL","Florida","Accommodation and food services",35843,38280]
["81","FL","Florida","Other services, except government",23403,45723]
["1","GA","Georgia","All industry total",473562,220605]
["3","GA","Georgia","Agriculture, forestry, fishing, and hunting",4321,933]
["6","GA","Georgia","Mining",1181,191]
["7","GA","Georgia","Oil and gas extraction",0,3]
["10","GA","Georgia","Utilities",8406,597]
["11","GA","Georgia","All construction",16056,16367]
["11.1","GA","Georgia","Commercial construction",2800,1230]
["11.2","GA","Georgia","Highway, street, and bridge construction",874,245]
["11.5","GA","Georgia","Residential building construction",6775,3395]
["12","GA","Georgia","All manufacturing",53081,7351]
["16","GA","Georgia","Primary metals manufacturing",711,72]
["26","GA","Georgia","Food/beverage manufacturing",12034,574]
["32","GA","Georgia","Chemical products manufacturing",4794,458]
["34","GA","Georgia","Wholesale trade",37214,13058]
["35","GA","Georgia","Retail trade",28271,33666]
["36","GA","Georgia","Transportation and warehousing",19547,6262]
["67","GA","Georgia","Waste management and remediation",778,622]
["70","GA","Georgia","Health care and social assistance",29741,23660]
["78","GA","Georgia","Accommodation and food services",13271,19409]
["81","GA","Georgia","Other services, except government",9562,20799]
["1","HI","Hawaii","All industry total",76588,31801]
["3","HI","Hawaii","Agriculture, forestry, fishing, and hunting",419,29]
["6","HI","Hawaii","Mining",78,8]
["7","HI","Hawaii","Oil and gas extraction",1,1]
["10","HI","Hawaii","Utilities",1573,60]
["11","HI","Hawaii","All construction",4198,2735]
["11.1","HI","Hawaii","Commercial construction",732,208]
["11.2","HI","Hawaii","Highway, street, and bridge construction",228,42]
["11.5","HI","Hawaii","Residential building construction",1771,673]
["12","HI","Hawaii","All manufacturing",1651,760]
["16","HI","Hawaii","Primary metals manufacturing",1,2]
["26","HI","Hawaii","Food/beverage manufacturing",400,231]
["32","HI","Hawaii","Chemical products manufacturing",108,21]
["34","HI","Hawaii","Wholesale trade",2436,1674]
["35","HI","Hawaii","Retail trade",5242,4639]
["36","HI","Hawaii","Transportation and warehousing",3422,867]
["67","HI","Hawaii","Waste management and remediation",214,130]
["70","HI","Hawaii","Health care and social assistance",4933,3629]
["78","HI","Hawaii","Accommodation and food services",6421,3579]
["81","HI","Hawaii","Other services, except government",1799,3478]
["1","ID","Idaho","All industry total",63050,43816]
["3","ID","Idaho","Agriculture, forestry, fishing, and hunting",4158,441]
["6","ID","Idaho","Mining",1275,132]
["7","ID","Idaho","Oil and gas extraction",18,3]
["10","ID","Idaho","Utilities",960,204]
["11","ID","Idaho","All construction",3203,5958]
["11.1","ID","Idaho","Commercial construction",559,278]
["11.2","ID","Idaho","Highway, street, and bridge construction",174,101]
["11.5","ID","Idaho","Residential building construction",1352,1379]
["12","ID","Idaho","All manufacturing",7379,1753]
["16","ID","Idaho","Primary metals manufacturing",488,21]
["26","ID","Idaho","Food/beverage manufacturing",1787,215]
["32","ID","Idaho","Chemical products manufacturing",282,62]
["34","ID","Idaho","Wholesale trade",3696,2050]
["35","ID","Idaho","Retail trade",5110,5818]
["36","ID","Idaho","Transportation and warehousing",1841,1731]
["67","ID","Idaho","Waste management and remediation",336,146]
["70","ID","Idaho","Health care and social assistance",4806,5017]
["78","ID","Idaho","Accommodation and food services",1616,3543]
["81","ID","Idaho","Other services, except government",1224,3379]
["1","IL","Illinois","All industry total",745810,316120]
["3","IL","Illinois","Agriculture, forestry, fishing, and hunting",7517,328]
["6","IL","Illinois","Mining",2438,564]
["7","IL","Illinois","Oil and gas extraction",276,174]
["10","IL","Illinois","Utilities",12641,492]
["11","IL","Illinois","All construction",26186,28286]
["11.1","IL","Illinois","Commercial construction",4567,1300]
["11.2","IL","Illinois","Highway, street, and bridge construction",1425,441]
["11.5","IL","Illinois","Residential building construction",11050,7591]
["12","IL","Illinois","All manufacturing",99802,13531]
["16","IL","Illinois","Primary metals manufacturing",2372,265]
["26","IL","Illinois","Food/beverage manufacturing",12193,1185]
["32","IL","Illinois","Chemical products manufacturing",15750,666]
["34","IL","Illinois","Wholesale trade",57590,18893]
["35","IL","Illinois","Retail trade",38118,39252]
["36","IL","Illinois","Transportation and warehousing",28897,14439]
["67","IL","Illinois","Waste management and remediation",1914,886]
["70","IL","Illinois","Health care and social assistance",50812,33454]
["78","IL","Illinois","Accommodation and food services",19586,27571]
["81","IL","Illinois","Other services, except government",17950,31817]
["1","IN","Indiana","All industry total",324901,143826]
["3","IN","Indiana","Agriculture, forestry, fishing, and hunting",5585,259]
["6","IN","Indiana","Mining",2085,290]
["7","IN","Indiana","Oil and gas extraction",76,45]
["10","IN","Indiana","Utilities",5614,509]
["11","IN","Indiana","All construction",12135,12971]
["11.1","IN","Indiana","Commercial construction",2116,701]
["11.2","IN","Indiana","Highway, street, and bridge construction",660,187]
["11.5","IN","Indiana","Residential building construction",5121,2976]
["12","IN","Indiana","All manufacturing",96584,8036]
["16","IN","Indiana","Primary metals manufacturing",8252,231]
["26","IN","Indiana","Food/beverage manufacturing",5852,486]
["32","IN","Indiana","Chemical products manufacturing",29825,306]
["34","IN","Indiana","Wholesale trade",17730,7684]
["35","IN","Indiana","Retail trade",18603,21431]
["36","IN","Indiana","Transportation and warehousing",10914,5143]
["67","IN","Indiana","Waste management and remediation",902,520]
["70","IN","Indiana","Health care and social assistance",24610,15414]
["78","IN","Indiana","Accommodation and food services",7360,13143]
["81","IN","Indiana","Other services, except government",7236,16396]
["1","IA","Iowa","All industry total",169661,80466]
["3","IA","Iowa","Agriculture, forestry, fishing, and hunting",11466,346]
["6","IA","Iowa","Mining",393,197]
["7","IA","Iowa","Oil and gas extraction",0,1]
["10","IA","Iowa","Utilities",2814,271]
["11","IA","Iowa","All construction",7209,8461]
["11.1","IA","Iowa","Commercial construction",1257,497]
["11.2","IA","Iowa","Highway, street, and bridge construction",392,149]
["11.5","IA","Iowa","Residential building construction",3042,1915]
["12","IA","Iowa","All manufacturing",31311,3542]
["16","IA","Iowa","Primary metals manufacturing",837,62]
["26","IA","Iowa","Food/beverage manufacturing",6191,489]
["32","IA","Iowa","Chemical products manufacturing",6104,186]
["34","IA","Iowa","Wholesale trade",10087,4914]
["35","IA","Iowa","Retail trade",9268,11828]
["36","IA","Iowa","Transportation and warehousing",5667,3537]
["67","IA","Iowa","Waste management and remediation",279,362]
["70","IA","Iowa","Health care and social assistance",11340,8219]
["78","IA","Iowa","Accommodation and food services",3692,6970]
["81","IA","Iowa","Other services, except government",3468,9060]
["1","KS","Kansas","All industry total",147493,74055]
["3","KS","Kansas","Agriculture, forestry, fishing, and hunting",5569,194]
["6","KS","Kansas","Mining",2689,1102]
["7","KS","Kansas","Oil and gas extraction",1908,425]
["10","KS","Kansas","Utilities",2682,232]
["11","KS","Kansas","All construction",5804,6920]
["11.1","KS","Kansas","Commercial construction",1012,397]
["11.2","KS","Kansas","Highway, street, and bridge construction",316,146]
["11.5","KS","Kansas","Residential building construction",2449,1456]
["12","KS","Kansas","All manufacturing",21910,2831]
["16","KS","Kansas","Primary metals manufacturing",176,39]
["26","KS","Kansas","Food/beverage manufacturing",3877,288]
["32","KS","Kansas","Chemical products manufacturing",1632,133]
["34","KS","Kansas","Wholesale trade",10024,4497]
["35","KS","Kansas","Retail trade",9196,10391]
["36","KS","Kansas","Transportation and warehousing",5652,2518]
["67","KS","Kansas","Waste management and remediation",279,255]
["70","KS","Kansas","Health care and social assistance",10630,7809]
["78","KS","Kansas","Accommodation and food services",3509,5985]
["81","KS","Kansas","Other services, except government",3168,7943]
["1","KY","Kentucky","All industry total",186344,91418]
["3","KY","Kentucky","Agriculture, forestry, fishing, and hunting",2686,224]
["6","KY","Kentucky","Mining",4519,519]
["7","KY","Kentucky","Oil and gas extraction",378,88]
["10","KY","Kentucky","Utilities",2879,329]
["11","KY","Kentucky","All construction",7604,7139]
["11.1","KY","Kentucky","Commercial construction",1326,482]
["11.2","KY","Kentucky","Highway, street, and bridge construction",414,133]
["11.5","KY","Kentucky","Residential building construction",3209,1276]
["12","KY","Kentucky","All manufacturing",36392,3755]
["16","KY","Kentucky","Primary metals manufacturing",2388,86]
["26","KY","Kentucky","Food/beverage manufacturing",7389,267]
["32","KY","Kentucky","Chemical products manufacturing",3497,195]
["34","KY","Kentucky","Wholesale trade",12155,4315]
["35","KY","Kentucky","Retail trade",10706,15223]
["36","KY","Kentucky","Transportation and warehousing",8402,2843]
["67","KY","Kentucky","Waste management and remediation",457,313]
["70","KY","Kentucky","Health care and social assistance",14620,12703]
["78","KY","Kentucky","Accommodation and food services",5517,7858]
["81","KY","Kentucky","Other services, except government",3992,9401]
["1","LA","Louisiana","All industry total",242785,104976]
["3","LA","Louisiana","Agriculture, forestry, fishing, and hunting",2114,599]
["6","LA","Louisiana","Mining",19075,1712]
["7","LA","Louisiana","Oil and gas extraction",13353,431]
["10","LA","Louisiana","Utilities",4061,506]
["11","LA","Louisiana","All construction",12330,7876]
["11.1","LA","Louisiana","Commercial construction",2150,675]
["11.2","LA","Louisiana","Highway, street, and bridge construction",671,190]
["11.5","LA","Louisiana","Residential building construction",5203,1314]
["12","LA","Louisiana","All manufacturing",52794,3255]
["16","LA","Louisiana","Primary metals manufacturing",333,28]
["26","LA","Louisiana","Food/beverage manufacturing",2135,340]
["32","LA","Louisiana","Chemical products manufacturing",15587,216]
["34","LA","Louisiana","Wholesale trade",12199,5482]
["35","LA","Louisiana","Retail trade",14809,16596]
["36","LA","Louisiana","Transportation and warehousing",10828,3929]
["67","LA","Louisiana","Waste management and remediation",909,420]
["70","LA","Louisiana","Health care and social assistance",15620,11968]
["78","LA","Louisiana","Accommodation and food services",7530,9276]
["81","LA","Louisiana","Other services, except government",4971,9572]
["1","ME","Maine","All industry total",55250,40369]
["3","ME","Maine","Agriculture, forestry, fishing, and hunting",866,837]
["6","ME","Maine","Mining",26,20]
["10","ME","Maine","Utilities",947,98]
["11","ME","Maine","All construction",2127,4729]
["11.1","ME","Maine","Commercial construction",371,140]
["11.2","ME","Maine","Highway, street, and bridge construction",116,80]
["11.5","ME","Maine","Residential building construction",898,1314]
["12","ME","Maine","All manufacturing",5481,1645]
["16","ME","Maine","Primary metals manufacturing",19,11]
["26","ME","Maine","Food/beverage manufacturing",775,206]
["32","ME","Maine","Chemical products manufacturing",502,54]
["34","ME","Maine","Wholesale trade",3081,1575]
["35","ME","Maine","Retail trade",4670,6304]
["36","ME","Maine","Transportation and warehousing",1259,1218]
["67","ME","Maine","Waste management and remediation",163,215]
["70","ME","Maine","Health care and social assistance",6342,4732]
["78","ME","Maine","Accommodation and food services",2110,4099]
["81","ME","Maine","Other services, except government",1254,3656]
["1","MD","Maryland","All industry total",349605,136501]
["3","MD","Maryland","Agriculture, forestry, fishing, and hunting",1039,193]
["6","MD","Maryland","Mining",291,72]
["7","MD","Maryland","Oil and gas extraction",2,2]
["10","MD","Maryland","Utilities",6466,138]
["11","MD","Maryland","All construction",16029,13883]
["11.1","MD","Maryland","Commercial construction",2796,857]
["11.2","MD","Maryland","Highway, street, and bridge construction",872,163]
["11.5","MD","Maryland","Residential building construction",6764,3829]
["12","MD","Maryland","All manufacturing",19524,3001]
["16","MD","Maryland","Primary metals manufacturing",75,28]
["26","MD","Maryland","Food/beverage manufacturing",3502,349]
["32","MD","Maryland","Chemical products manufacturing",5169,157]
["34","MD","Maryland","Wholesale trade",15379,5678]
["35","MD","Maryland","Retail trade",18408,18171]
["36","MD","Maryland","Transportation and warehousing",6897,3396]
["67","MD","Maryland","Waste management and remediation",894,467]
["70","MD","Maryland","Health care and social assistance",25688,16155]
["78","MD","Maryland","Accommodation and food services",8706,11516]
["81","MD","Maryland","Other services, except government",8263,13644]
["1","MA","Massachusetts","All industry total",455979,173575]
["3","MA","Massachusetts","Agriculture, forestry, fishing, and hunting",792,336]
["6","MA","Massachusetts","Mining",246,79]
["7","MA","Massachusetts","Oil and gas extraction",3,4]
["10","MA","Massachusetts","Utilities",5771,276]
["11","MA","Massachusetts","All construction",16195,17308]
["11.1","MA","Massachusetts","Commercial construction",2825,766]
["11.2","MA","Massachusetts","Highway, street, and bridge construction",881,240]
["11.5","MA","Massachusetts","Residential building construction",6834,4503]
["12","MA","Massachusetts","All manufacturing",46100,6654]
["16","MA","Massachusetts","Primary metals manufacturing",400,88]
["26","MA","Massachusetts","Food/beverage manufacturing",2886,658]
["32","MA","Massachusetts","Chemical products manufacturing",8398,323]
["34","MA","Massachusetts","Wholesale trade",23551,7875]
["35","MA","Massachusetts","Retail trade",19465,24136]
["36","MA","Massachusetts","Transportation and warehousing",7489,3626]
["67","MA","Massachusetts","Waste management and remediation",1311,635]
["70","MA","Massachusetts","Health care and social assistance",42578,18581]
["78","MA","Massachusetts","Accommodation and food services",12334,17269]
["81","MA","Massachusetts","Other services, except government",8889,17622]
["1","MI","Michigan","All industry total",447961,218282]
["3","MI","Michigan","Agriculture, forestry, fishing, and hunting",3779,533]
["6","MI","Michigan","Mining",2453,350]
["7","MI","Michigan","Oil and gas extraction",323,80]
["10","MI","Michigan","Utilities",8495,382]
["11","MI","Michigan","All construction",16918,18341]
["11.1","MI","Michigan","Commercial construction",2951,954]
["11.2","MI","Michigan","Highway, street, and bridge construction",921,249]
["11.5","MI","Michigan","Residential building construction",7139,4546]
["12","MI","Michigan","All manufacturing",86435,12361]
["16","MI","Michigan","Primary metals manufacturing",3492,255]
["26","MI","Michigan","Food/beverage manufacturing",5122,809]
["32","MI","Michigan","Chemical products manufacturing",5893,379]
["34","MI","Michigan","Wholesale trade",29715,11234]
["35","MI","Michigan","Retail trade",28757,34686]
["36","MI","Michigan","Transportation and warehousing",10820,5880]
["67","MI","Michigan","Waste management and remediation",1223,742]
["70","MI","Michigan","Health care and social assistance",36325,26380]
["78","MI","Michigan","Accommodation and food services",12261,19656]
["81","MI","Michigan","Other services, except government",10694,22939]
["1","MN","Minnesota","All industry total",316578,147483]
["3","MN","Minnesota","Agriculture, forestry, fishing, and hunting",7235,508]
["6","MN","Minnesota","Mining",3345,161]
["7","MN","Minnesota","Oil and gas extraction",50,7]
["10","MN","Minnesota","Utilities",5542,335]
["11","MN","Minnesota","All construction",12271,16124]
["11.1","MN","Minnesota","Commercial construction",2140,693]
["11.2","MN","Minnesota","Highway, street, and bridge construction",668,292]
["11.5","MN","Minnesota","Residential building construction",5178,3960]
["12","MN","Minnesota","All manufacturing",45807,7275]
["16","MN","Minnesota","Primary metals manufacturing",594,95]
["26","MN","Minnesota","Food/beverage manufacturing",4916,673]
["32","MN","Minnesota","Chemical products manufacturing",3002,263]
["34","MN","Minnesota","Wholesale trade",21714,8152]
["35","MN","Minnesota","Retail trade",17720,18993]
["36","MN","Minnesota","Transportation and warehousing",9194,4599]
["67","MN","Minnesota","Waste management and remediation",696,604]
["70","MN","Minnesota","Health care and social assistance",28428,15838]
["78","MN","Minnesota","Accommodation and food services",7196,11395]
["81","MN","Minnesota","Other services, except government",6720,15453]
["1","MS","Mississippi","All industry total",103828,58541]
["3","MS","Mississippi","Agriculture, forestry, fishing, and hunting",3127,667]
["6","MS","Mississippi","Mining",1712,386]
["7","MS","Mississippi","Oil and gas extraction",1122,84]
["10","MS","Mississippi","Utilities",2985,593]
["11","MS","Mississippi","All construction",4635,3807]
["11.1","MS","Mississippi","Commercial construction",808,340]
["11.2","MS","Mississippi","Highway, street, and bridge construction",252,130]
["11.5","MS","Mississippi","Residential building construction",1956,585]
["12","MS","Mississippi","All manufacturing",16103,2167]
["16","MS","Mississippi","Primary metals manufacturing",485,33]
["26","MS","Mississippi","Food/beverage manufacturing",1942,184]
["32","MS","Mississippi","Chemical products manufacturing",1937,103]
["34","MS","Mississippi","Wholesale trade",5313,2788]
["35","MS","Mississippi","Retail trade",8411,11555]
["36","MS","Mississippi","Transportation and warehousing",3440,2048]
["67","MS","Mississippi","Waste management and remediation",226,183]
["70","MS","Mississippi","Health care and social assistance",7645,6140]
["78","MS","Mississippi","Accommodation and food services",3871,5371]
["81","MS","Mississippi","Other services, except government",2510,6383]
["1","MO","Missouri","All industry total",282874,153945]
["3","MO","Missouri","Agriculture, forestry, fishing, and hunting",5189,264]
["6","MO","Missouri","Mining",1012,272]
["7","MO","Missouri","Oil and gas extraction",6,14]
["10","MO","Missouri","Utilities",5399,364]
["11","MO","Missouri","All construction",9855,12966]
["11.1","MO","Missouri","Commercial construction",1719,884]
["11.2","MO","Missouri","Highway, street, and bridge construction",536,203]
["11.5","MO","Missouri","Residential building construction",4159,2846]
["12","MO","Missouri","All manufacturing",37169,5946]
["16","MO","Missouri","Primary metals manufacturing",783,91]
["26","MO","Missouri","Food/beverage manufacturing",7494,528]
["32","MO","Missouri","Chemical products manufacturing",7277,310]
["34","MO","Missouri","Wholesale trade",19072,7789]
["35","MO","Missouri","Retail trade",17621,21228]
["36","MO","Missouri","Transportation and warehousing",9813,4537]
["67","MO","Missouri","Waste management and remediation",563,473]
["70","MO","Missouri","Health care and social assistance",23270,25902]
["78","MO","Missouri","Accommodation and food services",7321,12483]
["81","MO","Missouri","Other services, except government",6606,15324]
["1","MT","Montana","All industry total",44448,36791]
["3","MT","Montana","Agriculture, forestry, fishing, and hunting",2109,348]
["6","MT","Montana","Mining",2978,427]
["7","MT","Montana","Oil and gas extraction",900,104]
["10","MT","Montana","Utilities",973,209]
["11","MT","Montana","All construction",2481,5087]
["11.1","MT","Montana","Commercial construction",433,181]
["11.2","MT","Montana","Highway, street, and bridge construction",135,95]
["11.5","MT","Montana","Residential building construction",1047,1438]
["12","MT","Montana","All manufacturing",3030,1251]
["16","MT","Montana","Primary metals manufacturing",27,19]
["26","MT","Montana","Food/beverage manufacturing",300,155]
["32","MT","Montana","Chemical products manufacturing",96,36]
["34","MT","Montana","Wholesale trade",2465,1580]
["35","MT","Montana","Retail trade",2878,4757]
["36","MT","Montana","Transportation and warehousing",2203,1395]
["67","MT","Montana","Waste management and remediation",105,147]
["70","MT","Montana","Health care and social assistance",3890,3529]
["78","MT","Montana","Accommodation and food services",1579,3471]
["81","MT","Montana","Other services, except government",964,3163]
["1","NE","Nebraska","All industry total",111297,52991]
["3","NE","Nebraska","Agriculture, forestry, fishing, and hunting",9163,187]
["6","NE","Nebraska","Mining",276,130]
["7","NE","Nebraska","Oil and gas extraction",17,21]
["10","NE","Nebraska","Utilities",2327,119]
["11","NE","Nebraska","All construction",3765,6138]
["11.1","NE","Nebraska","Commercial construction",657,316]
["11.2","NE","Nebraska","Highway, street, and bridge construction",205,89]
["11.5","NE","Nebraska","Residential building construction",1589,1310]
["12","NE","Nebraska","All manufacturing",13541,1795]
["16","NE","Nebraska","Primary metals manufacturing",195,16]
["26","NE","Nebraska","Food/beverage manufacturing",3600,284]
["32","NE","Nebraska","Chemical products manufacturing",3088,89]
["34","NE","Nebraska","Wholesale trade",7102,3162]
["35","NE","Nebraska","Retail trade",6011,7240]
["36","NE","Nebraska","Transportation and warehousing",9416,2351]
["67","NE","Nebraska","Waste management and remediation",232,209]
["70","NE","Nebraska","Health care and social assistance",7711,5412]
["78","NE","Nebraska","Accommodation and food services",2196,4424]
["81","NE","Nebraska","Other services, except government",2235,5756]
["1","NV","Nevada","All industry total",133784,61625]
["3","NV","Nevada","Agriculture, forestry, fishing, and hunting",397,47]
["6","NV","Nevada","Mining",4219,213]
["7","NV","Nevada","Oil and gas extraction",3,20]
["10","NV","Nevada","Utilities",1955,130]
["11","NV","Nevada","All construction",5700,4629]
["11.1","NV","Nevada","Commercial construction",994,398]
["11.2","NV","Nevada","Highway, street, and bridge construction",310,52]
["11.5","NV","Nevada","Residential building construction",2405,802]
["12","NV","Nevada","All manufacturing",6114,1750]
["16","NV","Nevada","Primary metals manufacturing",152,12]
["26","NV","Nevada","Food/beverage manufacturing",647,187]
["32","NV","Nevada","Chemical products manufacturing",334,78]
["34","NV","Nevada","Wholesale trade",5585,2984]
["35","NV","Nevada","Retail trade",10222,8512]
["36","NV","Nevada","Transportation and warehousing",5600,1497]
["67","NV","Nevada","Waste management and remediation",336,136]
["70","NV","Nevada","Health care and social assistance",7561,6593]
["78","NV","Nevada","Accommodation and food services",20064,6145]
["81","NV","Nevada","Other services, except government",2677,4257]
["1","NH","New Hampshire","All industry total",71153,37396]
["3","NH","New Hampshire","Agriculture, forestry, fishing, and hunting",215,140]
["6","NH","New Hampshire","Mining",54,47]
["7","NH","New Hampshire","Oil and gas extraction",0,3]
["10","NH","New Hampshire","Utilities",993,128]
["11","NH","New Hampshire","All construction",2238,3835]
["11.1","NH","New Hampshire","Commercial construction",390,149]
["11.2","NH","New Hampshire","Highway, street, and bridge construction",122,73]
["11.5","NH","New Hampshire","Residential building construction",944,805]
["12","NH","New Hampshire","All manufacturing",7726,1806]
["16","NH","New Hampshire","Primary metals manufacturing",194,29]
["26","NH","New Hampshire","Food/beverage manufacturing",631,110]
["32","NH","New Hampshire","Chemical products manufacturing",293,64]
["34","NH","New Hampshire","Wholesale trade",4640,1847]
["35","NH","New Hampshire","Retail trade",5385,6044]
["36","NH","New Hampshire","Transportation and warehousing",1068,798]
["67","NH","New Hampshire","Waste management and remediation",190,183]
["70","NH","New Hampshire","Health care and social assistance",6240,3613]
["78","NH","New Hampshire","Accommodation and food services",2290,3642]
["81","NH","New Hampshire","Other services, except government",1678,3671]
["1","NJ","New Jersey","All industry total",543787,230600]
["3","NJ","New Jersey","Agriculture, forestry, fishing, and hunting",769,205]
["6","NJ","New Jersey","Mining",305,78]
["10","NJ","New Jersey","Utilities",11026,384]
["11","NJ","New Jersey","All construction",20843,20933]
["11.1","NJ","New Jersey","Commercial construction",3635,1004]
["11.2","NJ","New Jersey","Highway, street, and bridge construction",1134,317]
["11.5","NJ","New Jersey","Residential building construction",8795,5388]
["12","NJ","New Jersey","All manufacturing",46391,7537]
["16","NJ","New Jersey","Primary metals manufacturing",547,98]
["26","NJ","New Jersey","Food/beverage manufacturing",3910,937]
["32","NJ","New Jersey","Chemical products manufacturing",21152,594]
["34","NJ","New Jersey","Wholesale trade",45592,14236]
["35","NJ","New Jersey","Retail trade",32014,31685]
["36","NJ","New Jersey","Transportation and warehousing",17219,7240]
["67","NJ","New Jersey","Waste management and remediation",1714,740]
["70","NJ","New Jersey","Health care and social assistance",41859,27089]
["78","NJ","New Jersey","Accommodation and food services",12483,20590]
["81","NJ","New Jersey","Other services, except government",11242,23426]
["1","NM","New Mexico","All industry total",94731,43748]
["3","NM","New Mexico","Agriculture, forestry, fishing, and hunting",1607,87]
["6","NM","New Mexico","Mining",13195,788]
["7","NM","New Mexico","Oil and gas extraction",8628,184]
["10","NM","New Mexico","Utilities",1417,226]
["11","NM","New Mexico","All construction",3237,4291]
["11.1","NM","New Mexico","Commercial construction",565,359]
["11.2","NM","New Mexico","Highway, street, and bridge construction",176,74]
["11.5","NM","New Mexico","Residential building construction",1366,1003]
["12","NM","New Mexico","All manufacturing",4236,1350]
["16","NM","New Mexico","Primary metals manufacturing",49,22]
["26","NM","New Mexico","Food/beverage manufacturing",470,150]
["32","NM","New Mexico","Chemical products manufacturing",324,44]
["34","NM","New Mexico","Wholesale trade",2996,1855]
["35","NM","New Mexico","Retail trade",5518,6557]
["36","NM","New Mexico","Transportation and warehousing",2539,1390]
["67","NM","New Mexico","Waste management and remediation",304,181]
["70","NM","New Mexico","Health care and social assistance",6346,4953]
["78","NM","New Mexico","Accommodation and food services",2817,4189]
["81","NM","New Mexico","Other services, except government",2022,4086]
["1","NY","New York","All industry total",1382933,536890]
["3","NY","New York","Agriculture, forestry, fishing, and hunting",3305,578]
["6","NY","New York","Mining",1081,307]
["7","NY","New York","Oil and gas extraction",316,42]
["10","NY","New York","Utilities",18839,616]
["11","NY","New York","All construction",41699,46446]
["11.1","NY","New York","Commercial construction",7273,2235]
["11.2","NY","New York","Highway, street, and bridge construction",2269,465]
["11.5","NY","New York","Residential building construction",17596,13960]
["12","NY","New York","All manufacturing",70187,16076]
["16","NY","New York","Primary metals manufacturing",1602,180]
["26","NY","New York","Food/beverage manufacturing",10848,2095]
["32","NY","New York","Chemical products manufacturing",15796,563]
["34","NY","New York","Wholesale trade",66649,32438]
["35","NY","New York","Retail trade",66896,78763]
["36","NY","New York","Transportation and warehousing",26398,12618]
["67","NY","New York","Waste management and remediation",2406,1500]
["70","NY","New York","Health care and social assistance",95706,56985]
["78","NY","New York","Accommodation and food services",33912,51682]
["81","NY","New York","Other services, except government",28062,56938]
["1","NC","North Carolina","All industry total",473471,219897]
["3","NC","North Carolina","Agriculture, forestry, fishing, and hunting",6155,790]
["6","NC","North Carolina","Mining",548,206]
["7","NC","North Carolina","Oil and gas extraction",13,5]
["10","NC","North Carolina","Utilities",7307,562]
["11","NC","North Carolina","All construction",16384,21086]
["11.1","NC","North Carolina","Commercial construction",2858,1019]
["11.2","NC","North Carolina","Highway, street, and bridge construction",891,339]
["11.5","NC","North Carolina","Residential building construction",6914,5413]
["12","NC","North Carolina","All manufacturing",95108,8721]
["16","NC","North Carolina","Primary metals manufacturing",982,92]
["26","NC","North Carolina","Food/beverage manufacturing",18947,584]
["32","NC","North Carolina","Chemical products manufacturing",28125,433]
["34","NC","North Carolina","Wholesale trade",27493,11674]
["35","NC","North Carolina","Retail trade",25321,34246]
["36","NC","North Carolina","Transportation and warehousing",10629,5509]
["67","NC","North Carolina","Waste management and remediation",867,701]
["70","NC","North Carolina","Health care and social assistance",32051,23053]
["78","NC","North Carolina","Accommodation and food services",12064,19923]
["81","NC","North Carolina","Other services, except government",9707,22796]
["1","ND","North Dakota","All industry total",59308,24698]
["3","ND","North Dakota","Agriculture, forestry, fishing, and hunting",3076,115]
["6","ND","North Dakota","Mining",11199,583]
["7","ND","North Dakota","Oil and gas extraction",4751,78]
["10","ND","North Dakota","Utilities",1356,139]
["11","ND","North Dakota","All construction",4315,3087]
["11.1","ND","North Dakota","Commercial construction",753,198]
["11.2","ND","North Dakota","Highway, street, and bridge construction",235,82]
["11.5","ND","North Dakota","Residential building construction",1821,660]
["12","ND","North Dakota","All manufacturing",3736,762]
["16","ND","North Dakota","Primary metals manufacturing",9,5]
["26","ND","North Dakota","Food/beverage manufacturing",790,129]
["32","ND","North Dakota","Chemical products manufacturing",192,12]
["34","ND","North Dakota","Wholesale trade",4815,1705]
["35","ND","North Dakota","Retail trade",3184,3242]
["36","ND","North Dakota","Transportation and warehousing",3535,1709]
["67","ND","North Dakota","Waste management and remediation",114,142]
["70","ND","North Dakota","Health care and social assistance",3466,1972]
["78","ND","North Dakota","Accommodation and food services",1289,2040]
["81","ND","North Dakota","Other services, except government",962,2529]
["1","OH","Ohio","All industry total",591333,250535]
["3","OH","Ohio","Agriculture, forestry, fishing, and hunting",4529,268]
["6","OH","Ohio","Mining",7308,738]
["7","OH","Ohio","Oil and gas extraction",4718,202]
["10","OH","Ohio","Utilities",12358,630]
["11","OH","Ohio","All construction",20677,19603]
["11.1","OH","Ohio","Commercial construction",3606,1253]
["11.2","OH","Ohio","Highway, street, and bridge construction",1125,336]
["11.5","OH","Ohio","Residential building construction",8725,4046]
["12","OH","Ohio","All manufacturing",105979,14208]
["16","OH","Ohio","Primary metals manufacturing",5605,391]
["26","OH","Ohio","Food/beverage manufacturing",11684,919]
["32","OH","Ohio","Chemical products manufacturing",13455,694]
["34","OH","Ohio","Wholesale trade",35983,14217]
["35","OH","Ohio","Retail trade",35045,36260]
["36","OH","Ohio","Transportation and warehousing",17092,7075]
["67","OH","Ohio","Waste management and remediation",1821,923]
["70","OH","Ohio","Health care and social assistance",48898,28595]
["78","OH","Ohio","Accommodation and food services",13676,23800]
["81","OH","Ohio","Other services, except government",12266,27583]
["1","OK","Oklahoma","All industry total",194466,92430]
["3","OK","Oklahoma","Agriculture, forestry, fishing, and hunting",3103,152]
["6","OK","Oklahoma","Mining",35716,3267]
["7","OK","Oklahoma","Oil and gas extraction",30557,1255]
["10","OK","Oklahoma","Utilities",4904,369]
["11","OK","Oklahoma","All construction",7600,8198]
["11.1","OK","Oklahoma","Commercial construction",1326,751]
["11.2","OK","Oklahoma","Highway, street, and bridge construction",414,142]
["11.5","OK","Oklahoma","Residential building construction",3207,1110]
["12","OK","Oklahoma","All manufacturing",18052,3554]
["16","OK","Oklahoma","Primary metals manufacturing",359,58]
["26","OK","Oklahoma","Food/beverage manufacturing",1671,271]
["32","OK","Oklahoma","Chemical products manufacturing",1105,137]
["34","OK","Oklahoma","Wholesale trade",10746,4699]
["35","OK","Oklahoma","Retail trade",10901,13237]
["36","OK","Oklahoma","Transportation and warehousing",9097,2686]
["67","OK","Oklahoma","Waste management and remediation",356,334]
["70","OK","Oklahoma","Health care and social assistance",12087,10712]
["78","OK","Oklahoma","Accommodation and food services",4772,7617]
["81","OK","Oklahoma","Other services, except government",3765,8936]
["1","OR","Oregon","All industry total",203606,109875]
["3","OR","Oregon","Agriculture, forestry, fishing, and hunting",4324,1308]
["6","OR","Oregon","Mining",240,138]
["7","OR","Oregon","Oil and gas extraction",3,2]
["10","OR","Oregon","Utilities",3297,279]
["11","OR","Oregon","All construction",7625,11361]
["11.1","OR","Oregon","Commercial construction",1330,480]
["11.2","OR","Oregon","Highway, street, and bridge construction",415,200]
["11.5","OR","Oregon","Residential building construction",3218,3488]
["12","OR","Oregon","All manufacturing",46433,5314]
["16","OR","Oregon","Primary metals manufacturing",1310,63]
["26","OR","Oregon","Food/beverage manufacturing",2823,588]
["32","OR","Oregon","Chemical products manufacturing",718,173]
["34","OR","Oregon","Wholesale trade",10659,5345]
["35","OR","Oregon","Retail trade",10062,13994]
["36","OR","Oregon","Transportation and warehousing",5344,2997]
["67","OR","Oregon","Waste management and remediation",546,373]
["70","OR","Oregon","Health care and social assistance",15413,12959]
["78","OR","Oregon","Accommodation and food services",5601,10831]
["81","OR","Oregon","Other services, except government",4212,9869]
["1","PA","Pennsylvania","All industry total",685420,298297]
["3","PA","Pennsylvania","Agriculture, forestry, fishing, and hunting",4521,478]
["6","PA","Pennsylvania","Mining",21306,1164]
["7","PA","Pennsylvania","Oil and gas extraction",14142,224]
["10","PA","Pennsylvania","Utilities",10742,798]
["11","PA","Pennsylvania","All construction",27674,26209]
["11.1","PA","Pennsylvania","Commercial construction",4827,1594]
["11.2","PA","Pennsylvania","Highway, street, and bridge construction",1506,396]
["11.5","PA","Pennsylvania","Residential building construction",11678,6690]
["12","PA","Pennsylvania","All manufacturing",83490,13684]
["16","PA","Pennsylvania","Primary metals manufacturing",5735,364]
["26","PA","Pennsylvania","Food/beverage manufacturing",10097,1207]
["32","PA","Pennsylvania","Chemical products manufacturing",17089,578]
["34","PA","Pennsylvania","Wholesale trade",40995,14832]
["35","PA","Pennsylvania","Retail trade",34999,43598]
["36","PA","Pennsylvania","Transportation and warehousing",20274,8403]
["67","PA","Pennsylvania","Waste management and remediation",1756,1111]
["70","PA","Pennsylvania","Health care and social assistance",62794,36534]
["78","PA","Pennsylvania","Accommodation and food services",14918,28371]
["81","PA","Pennsylvania","Other services, except government",14494,35966]
["1","RI","Rhode Island","All industry total",53898,28132]
["3","RI","Rhode Island","Agriculture, forestry, fishing, and hunting",100,39]
["6","RI","Rhode Island","Mining",46,20]
["7","RI","Rhode Island","Oil and gas extraction",2,1]
["10","RI","Rhode Island","Utilities",594,41]
["11","RI","Rhode Island","All construction",2063,2953]
["11.1","RI","Rhode Island","Commercial construction",360,121]
["11.2","RI","Rhode Island","Highway, street, and bridge construction",112,23]
["11.5","RI","Rhode Island","Residential building construction",871,762]
["12","RI","Rhode Island","All manufacturing",4404,1432]
["16","RI","Rhode Island","Primary metals manufacturing",164,46]
["26","RI","Rhode Island","Food/beverage manufacturing",216,151]
["32","RI","Rhode Island","Chemical products manufacturing",854,62]
["34","RI","Rhode Island","Wholesale trade",3140,1337]
["35","RI","Rhode Island","Retail trade",3012,3744]
["36","RI","Rhode Island","Transportation and warehousing",841,605]
["67","RI","Rhode Island","Waste management and remediation",168,107]
["70","RI","Rhode Island","Health care and social assistance",5421,3229]
["78","RI","Rhode Island","Accommodation and food services",1745,3039]
["81","RI","Rhode Island","Other services, except government",1152,2900]
["1","SC","South Carolina","All industry total",190773,102297]
["3","SC","South Carolina","Agriculture, forestry, fishing, and hunting",1156,499]
["6","SC","South Carolina","Mining",258,79]
["7","SC","South Carolina","Oil and gas extraction",1,1]
["10","SC","South Carolina","Utilities",4566,352]
["11","SC","South Carolina","All construction",8843,8880]
["11.1","SC","South Carolina","Commercial construction",1542,491]
["11.2","SC","South Carolina","Highway, street, and bridge construction",481,124]
["11.5","SC","South Carolina","Residential building construction",3731,1903]
["12","SC","South Carolina","All manufacturing",32056,3770]
["16","SC","South Carolina","Primary metals manufacturing",939,74]
["26","SC","South Carolina","Food/beverage manufacturing",1926,228]
["32","SC","South Carolina","Chemical products manufacturing",4205,238]
["34","SC","South Carolina","Wholesale trade",11070,4975]
["35","SC","South Carolina","Retail trade",13797,17567]
["36","SC","South Carolina","Transportation and warehousing",4410,2526]
["67","SC","South Carolina","Waste management and remediation",1288,363]
["70","SC","South Carolina","Health care and social assistance",12502,9931]
["78","SC","South Carolina","Accommodation and food services",7619,10007]
["81","SC","South Carolina","Other services, except government",4722,11212]
["1","SD","South Dakota","All industry total",45588,26198]
["3","SD","South Dakota","Agriculture, forestry, fishing, and hunting",4199,134]
["6","SD","South Dakota","Mining",176,67]
["7","SD","South Dakota","Oil and gas extraction",40,7]
["10","SD","South Dakota","Utilities",789,160]
["11","SD","South Dakota","All construction",1821,3268]
["11.1","SD","South Dakota","Commercial construction",318,226]
["11.2","SD","South Dakota","Highway, street, and bridge construction",99,82]
["11.5","SD","South Dakota","Residential building construction",768,825]
["12","SD","South Dakota","All manufacturing",4178,1028]
["16","SD","South Dakota","Primary metals manufacturing",46,12]
["26","SD","South Dakota","Food/beverage manufacturing",503,122]
["32","SD","South Dakota","Chemical products manufacturing",453,41]
["34","SD","South Dakota","Wholesale trade",3242,1522]
["35","SD","South Dakota","Retail trade",3341,3866]
["36","SD","South Dakota","Transportation and warehousing",1087,1170]
["67","SD","South Dakota","Waste management and remediation",62,118]
["70","SD","South Dakota","Health care and social assistance",3906,2306]
["78","SD","South Dakota","Accommodation and food services",1366,2406]
["81","SD","South Dakota","Other services, except government",949,2744]
["1","TN","Tennessee","All industry total",299158,131504]
["3","TN","Tennessee","Agriculture, forestry, fishing, and hunting",1837,234]
["6","TN","Tennessee","Mining",854,204]
["7","TN","Tennessee","Oil and gas extraction",30,13]
["10","TN","Tennessee","Utilities",1827,146]
["11","TN","Tennessee","All construction",10942,9279]
["11.1","TN","Tennessee","Commercial construction",1908,607]
["11.2","TN","Tennessee","Highway, street, and bridge construction",595,178]
["11.5","TN","Tennessee","Residential building construction",4617,1882]
["12","TN","Tennessee","All manufacturing",50173,5632]
["16","TN","Tennessee","Primary metals manufacturing",1506,102]
["26","TN","Tennessee","Food/beverage manufacturing",7022,333]
["32","TN","Tennessee","Chemical products manufacturing",6784,249]
["34","TN","Tennessee","Wholesale trade",21331,6858]
["35","TN","Tennessee","Retail trade",21020,22533]
["36","TN","Tennessee","Transportation and warehousing",13577,4095]
["67","TN","Tennessee","Waste management and remediation",830,468]
["70","TN","Tennessee","Health care and social assistance",28214,15180]
["78","TN","Tennessee","Accommodation and food services",9634,12238]
["81","TN","Tennessee","Other services, except government",7548,14063]
["1","TX","Texas","All industry total",1627865,557721]
["3","TX","Texas","Agriculture, forestry, fishing, and hunting",10986,1023]
["6","TX","Texas","Mining",235375,8911]
["7","TX","Texas","Oil and gas extraction",196701,3336]
["10","TX","Texas","Utilities",32816,1995]
["11","TX","Texas","All construction",79672,40525]
["11.1","TX","Texas","Commercial construction",13896,3057]
["11.2","TX","Texas","Highway, street, and bridge construction",4335,699]
["11.5","TX","Texas","Residential building construction",33619,7195]
["12","TX","Texas","All manufacturing",223658,19681]
["16","TX","Texas","Primary metals manufacturing",3509,296]
["26","TX","Texas","Food/beverage manufacturing",12250,1760]
["32","TX","Texas","Chemical products manufacturing",53299,1119]
["34","TX","Texas","Wholesale trade",126109,33235]
["35","TX","Texas","Retail trade",90837,79814]
["36","TX","Texas","Transportation and warehousing",51838,18244]
["67","TX","Texas","Waste management and remediation",4034,1658]
["70","TX","Texas","Health care and social assistance",83890,63935]
["78","TX","Texas","Accommodation and food services",43202,50755]
["81","TX","Texas","Other services, except government",31521,49899]
["1","UT","Utah","All industry total",140296,73375]
["3","UT","Utah","Agriculture, forestry, fishing, and hunting",956,83]
["6","UT","Utah","Mining",5142,520]
["7","UT","Utah","Oil and gas extraction",1851,73]
["10","UT","Utah","Utilities",1554,216]
["11","UT","Utah","All construction",7983,8597]
["11.1","UT","Utah","Commercial construction",1392,416]
["11.2","UT","Utah","Highway, street, and bridge construction",434,85]
["11.5","UT","Utah","Residential building construction",3369,1872]
["12","UT","Utah","All manufacturing",16398,3201]
["16","UT","Utah","Primary metals manufacturing",1422,59]
["26","UT","Utah","Food/beverage manufacturing",1778,305]
["32","UT","Utah","Chemical products manufacturing",1381,147]
["34","UT","Utah","Wholesale trade",7085,3743]
["35","UT","Utah","Retail trade",9679,9224]
["36","UT","Utah","Transportation and warehousing",4723,2248]
["67","UT","Utah","Waste management and remediation",341,202]
["70","UT","Utah","Health care and social assistance",7775,7550]
["78","UT","Utah","Accommodation and food services",3298,5359]
["81","UT","Utah","Other services, except government",4001,4832]
["1","VT","Vermont","All industry total",29259,21041]
["3","VT","Vermont","Agriculture, forestry, fishing, and hunting",514,140]
["6","VT","Vermont","Mining",232,47]
["10","VT","Vermont","Utilities",673,58]
["11","VT","Vermont","All construction",1097,2647]
["11.1","VT","Vermont","Commercial construction",191,83]
["11.2","VT","Vermont","Highway, street, and bridge construction",60,32]
["11.5","VT","Vermont","Residential building construction",463,765]
["12","VT","Vermont","All manufacturing",2728,989]
["16","VT","Vermont","Primary metals manufacturing",20,3]
["26","VT","Vermont","Food/beverage manufacturing",477,178]
["32","VT","Vermont","Chemical products manufacturing",142,34]
["34","VT","Vermont","Wholesale trade",1462,813]
["35","VT","Vermont","Retail trade",2228,3400]
["36","VT","Vermont","Transportation and warehousing",524,501]
["67","VT","Vermont","Waste management and remediation",95,99]
["70","VT","Vermont","Health care and social assistance",2988,2090]
["78","VT","Vermont","Accommodation and food services",1359,1945]
["81","VT","Vermont","Other services, except government",697,2023]
["1","VA","Virginia","All industry total",460151,195639]
["3","VA","Virginia","Agriculture, forestry, fishing, and hunting",1909,655]
["6","VA","Virginia","Mining",2132,287]
["7","VA","Virginia","Oil and gas extraction",219,22]
["10","VA","Virginia","Utilities",5978,331]
["11","VA","Virginia","All construction",18835,19137]
["11.1","VA","Virginia","Commercial construction",3285,992]
["11.2","VA","Virginia","Highway, street, and bridge construction",1025,342]
["11.5","VA","Virginia","Residential building construction",7948,5101]
["12","VA","Virginia","All manufacturing",42458,4986]
["16","VA","Virginia","Primary metals manufacturing",455,44]
["26","VA","Virginia","Food/beverage manufacturing",16824,394]
["32","VA","Virginia","Chemical products manufacturing",4954,164]
["34","VA","Virginia","Wholesale trade",19587,7204]
["35","VA","Virginia","Retail trade",24073,27059]
["36","VA","Virginia","Transportation and warehousing",11548,4858]
["67","VA","Virginia","Waste management and remediation",713,537]
["70","VA","Virginia","Health care and social assistance",27984,19205]
["78","VA","Virginia","Accommodation and food services",10924,17344]
["81","VA","Virginia","Other services, except government",11736,21432]
["1","WA","Washington","All industry total",423795,179012]
["3","WA","Washington","Agriculture, forestry, fishing, and hunting",7232,1429]
["6","WA","Washington","Mining",516,176]
["7","WA","Washington","Oil and gas extraction",1,7]
["10","WA","Washington","Utilities",3524,300]
["11","WA","Washington","All construction",16929,20473]
["11.1","WA","Washington","Commercial construction",2953,839]
["11.2","WA","Washington","Highway, street, and bridge construction",921,272]
["11.5","WA","Washington","Residential building construction",7144,6155]
["12","WA","Washington","All manufacturing",57278,6929]
["16","WA","Washington","Primary metals manufacturing",853,78]
["26","WA","Washington","Food/beverage manufacturing",4602,792]
["32","WA","Washington","Chemical products manufacturing",1504,226]
["34","WA","Washington","Wholesale trade",23854,9288]
["35","WA","Washington","Retail trade",30685,21586]
["36","WA","Washington","Transportation and warehousing",11796,5010]
["67","WA","Washington","Waste management and remediation",2163,507]
["70","WA","Washington","Health care and social assistance",26322,20039]
["78","WA","Washington","Accommodation and food services",11242,16505]
["81","WA","Washington","Other services, except government",8577,16809]
["1","WV","West Virginia","All industry total",74148,37354]
["3","WV","West Virginia","Agriculture, forestry, fishing, and hunting",350,248]
["6","WV","West Virginia","Mining",11053,648]
["7","WV","West Virginia","Oil and gas extraction",4067,184]
["10","WV","West Virginia","Utilities",1975,236]
["11","WV","West Virginia","All construction",3992,3230]
["11.1","WV","West Virginia","Commercial construction",696,183]
["11.2","WV","West Virginia","Highway, street, and bridge construction",217,60]
["11.5","WV","West Virginia","Residential building construction",1685,936]
["12","WV","West Virginia","All manufacturing",7407,1204]
["16","WV","West Virginia","Primary metals manufacturing",728,28]
["26","WV","West Virginia","Food/beverage manufacturing",227,92]
["32","WV","West Virginia","Chemical products manufacturing",2886,75]
["34","WV","West Virginia","Wholesale trade",3345,1530]
["35","WV","West Virginia","Retail trade",4874,6214]
["36","WV","West Virginia","Transportation and warehousing",2190,1212]
["67","WV","West Virginia","Waste management and remediation",217,189]
["70","WV","West Virginia","Health care and social assistance",6653,4911]
["78","WV","West Virginia","Accommodation and food services",2352,3639]
["81","WV","West Virginia","Other services, except government",1487,4414]
["1","WI","Wisconsin","All industry total",291754,138221]
["3","WI","Wisconsin","Agriculture, forestry, fishing, and hunting",5798,521]
["6","WI","Wisconsin","Mining",1056,167]
["7","WI","Wisconsin","Oil and gas extraction",13,3]
["10","WI","Wisconsin","Utilities",5065,313]
["11","WI","Wisconsin","All construction",11165,13379]
["11.1","WI","Wisconsin","Commercial construction",1947,540]
["11.2","WI","Wisconsin","Highway, street, and bridge construction",607,162]
["11.5","WI","Wisconsin","Residential building construction",4711,3009]
["12","WI","Wisconsin","All manufacturing",56459,8858]
["16","WI","Wisconsin","Primary metals manufacturing",1798,177]
["26","WI","Wisconsin","Food/beverage manufacturing",8282,973]
["32","WI","Wisconsin","Chemical products manufacturing",4632,352]
["34","WI","Wisconsin","Wholesale trade",17322,6985]
["35","WI","Wisconsin","Retail trade",16979,19143]
["36","WI","Wisconsin","Transportation and warehousing",8579,5263]
["67","WI","Wisconsin","Waste management and remediation",584,551]
["70","WI","Wisconsin","Health care and social assistance",24821,14963]
["78","WI","Wisconsin","Accommodation and food services",6679,14325]
["81","WI","Wisconsin","Other services, except government",6323,14585]
["1","WY","Wyoming","All industry total",42021,20807]
["3","WY","Wyoming","Agriculture, forestry, fishing, and hunting",746,87]
["6","WY","Wyoming","Mining",11473,846]
["7","WY","Wyoming","Oil and gas extraction",5343,182]
["10","WY","Wyoming","Utilities",903,137]
["11","WY","Wyoming","All construction",2396,2612]
["11.1","WY","Wyoming","Commercial construction",418,113]
["11.2","WY","Wyoming","Highway, street, and bridge construction",130,50]
["11.5","WY","Wyoming","Residential building construction",1011,640]
["12","WY","Wyoming","All manufacturing",2134,564]
["16","WY","Wyoming","Primary metals manufacturing",8,11]
["26","WY","Wyoming","Food/beverage manufacturing",83,64]
["32","WY","Wyoming","Chemical products manufacturing",575,33]
["34","WY","Wyoming","Wholesale trade",1782,845]
["35","WY","Wyoming","Retail trade",2119,2610]
["36","WY","Wyoming","Transportation and warehousing",2961,1022]
["67","WY","Wyoming","Waste management and remediation",96,97]
["70","WY","Wyoming","Health care and social assistance",1541,1910]
["78","WY","Wyoming","Accommodation and food services",1207,1809]
["81","WY","Wyoming","Other services, except government",638,1799]

{"sheet":"Text Options","index":15,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Tool","National:","state selected","Needs a \"the\"",null,null,null,"New Industry List",null,"New States List"]
["TM",{"$f":"IF(state_tm=\"United States\",1,0)","v":0},{"$f":"state_tm","v":0},{"$f":"IF(OR(C2=$C$9,C2=$C$10,C2=$C$11,C2=$C$12),1,0)","v":0},null,null,null,null,null,"United States"]
["TT",{"$f":"IF(state_tt=\"United States\",1,0)","v":0},{"$f":"state_tt","v":0},{"$f":"IF(OR(C3=$C$9,C3=$C$10,C3=$C$11,C3=$C$12),1,0)","v":0},null,null,null,"Commercial construction",null,"Alabama"]
["RR",{"$f":"IF(state_rr=\"United States\",1,0)","v":0},{"$f":"state_rr","v":0},{"$f":"IF(OR(C4=$C$9,C4=$C$10,C4=$C$11,C4=$C$12),1,0)","v":0},null,null,null,"----------------------------------------------------",null,"Alaska"]
[null,null,null,null,null,null,null,"All industry total",null,"Arizona"]
[null,null,null,null,null,null,null,"Mining",null,"Arkansas"]
[null,null,null,null,null,null,null,"Oil and gas extraction",null,"California"]
[null,null,"Regions needing a \"the\"",null,null,null,null,"Utilities",null,"Colorado"]
[null,null,"District of Columbia",null,null,null,null,"Waste management and remediation",null,"Connecticut"]
[null,null,"United States",null,null,null,null,"All construction",null,"Delaware"]
[null,null,"Northern Mariana Islands",null,null,null,null,"All manufacturing",null,"District of Columbia"]
[null,null,"U.S. Virgin Islands",null,null,null,null,"Primary metals manufacturing",null,"Florida"]
[null,null,null,null,null,null,null,"Chemical products manufacturing",null,"Georgia"]
[null,null,null,null,null,null,null,"Wholesale trade",null,"Hawaii"]
[null,null,null,null,null,null,null,"Retail trade",null,"Idaho"]
[null,null,null,null,null,null,null,"Transportation and warehousing",null,"Illinois"]
[null,null,null,null,null,null,null,"Health care and social assistance",null,"Indiana"]
[null,null,null,null,null,null,null,"Accommodation and food services",null,"Iowa"]
[null,null,null,null,null,null,null,"Agriculture, forestry, fishing, and hunting",null,"Kansas"]
[null,null,null,null,null,null,null,"Other services, except government",null,"Kentucky"]
[null,null,null,null,null,null,null,null,null,"Louisiana"]
[null,null,null,null,null,null,null,null,null,"Maine"]
[null,null,null,null,null,null,null,null,null,"Maryland"]
[null,null,null,null,null,null,null,null,null,"Massachusetts"]
[null,null,null,null,null,null,null,null,null,"Michigan"]
[null,null,null,null,null,null,null,null,null,"Minnesota"]
[null,null,null,null,null,null,null,null,null,"Mississippi"]
[null,null,null,null,null,null,null,null,null,"Missouri"]
[null,null,null,null,null,null,null,null,null,"Montana"]
[null,null,null,null,null,null,null,null,null,"Nebraska"]
[null,null,null,null,null,null,null,null,null,"Nevada"]
[null,null,null,null,null,null,null,null,null,"New Hampshire"]
[null,null,null,null,null,null,null,null,null,"New Jersey"]
[null,null,null,null,null,null,null,null,null,"New Mexico"]
[null,null,null,null,null,null,null,null,null,"New York"]
[null,null,null,null,null,null,null,null,null,"North Carolina"]
[null,null,null,null,null,null,null,null,null,"North Dakota"]
[null,null,null,null,null,null,null,null,null,"Ohio"]
[null,null,null,null,null,null,null,null,null,"Oklahoma"]
[null,null,null,null,null,null,null,null,null,"Oregon"]
[null,null,null,null,null,null,null,null,null,"Pennsylvania"]
[null,null,null,null,null,null,null,null,null,"Rhode Island"]
[null,null,null,null,null,null,null,null,null,"South Carolina"]
[null,null,null,null,null,null,null,null,null,"South Dakota"]
[null,null,null,null,null,null,null,null,null,"Tennessee"]
[null,null,null,null,null,null,null,null,null,"Texas"]
[null,null,null,null,null,null,null,null,null,"Utah"]
[null,null,null,null,null,null,null,null,null,"Vermont"]
[null,null,null,null,null,null,null,null,null,"Virginia"]
[null,null,null,null,null,null,null,null,null,"Washington"]
[null,null,null,null,null,null,null,null,null,"West Virginia"]
[null,null,null,null,null,null,null,null,null,"Wisconsin"]
[null,null,null,null,null,null,null,null,null,"Wyoming"]
[null,null,null,null,null,null,null,null,null,"American Samoa"]
[null,null,null,null,null,null,null,null,null,"Guam"]
[null,null,null,null,null,null,null,null,null,"Northern Mariana Islands"]
[null,null,null,null,null,null,null,null,null,"Puerto Rico"]
[null,null,null,null,null,null,null,null,null,"U.S. Virgin Islands"]