{"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":46,"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 to the private sector 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, as well as increasing productivity and reducing permitting-related costs for permit applicants, and reducing 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 and enable operations to start. Select the industry regulated by your permit from the drop-down 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 suggests 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 drop-down list below to obtain an estimate of economic activity associated with that industry. OR, 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 drop-down 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'!E2:E880,MATCH(state_tm&industry_tm,'BEA2'!B2:B880&'BEA2'!C2:C880,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 reported by the County Business Patterns for this state. Calculated benefits may therefore be overstated, and may even appear GREATER than the total reported GDP for the \"&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":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,23],[8,1,8,22],[10,1,11,1],[10,2,11,19],[14,9,14,17],[38,1,38,24],[22,5,22,8],[32,8,32,14],[27,19,31,23],[32,19,34,23],[16,17,17,23],[18,9,18,17],[29,8,30,18],[31,8,31,15],[27,5,27,14],[25,7,25,18]]}
[]
[]
[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,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,null,{"$f":"TRIM(LOWER(industry_tm))&\" sector in \"&IF(the_tm=1,\"the \",\"\")&state_tm","v":" sector in "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Time to Market Background Calcs'!E6","v":0}]
[null,null,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,null,null,null,null,null,null,null," in GDP.2"]
[]
[null,4,"A day of economic activity at an average facility in the ",null,null,null,null,null,null,null,null,null,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,null,null,null,"is worth",null,{"$f":"DOLLAR('Time to Market Background Calcs'!E13*1000000,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null," in GDP.3"]
[]
[]
[null,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,null,"by",{"$f":"IF(Change_permit_time<0,-1*Change_permit_time,Change_permit_time)","v":0},{"$f":"IF(D23<2,\"day for\",\"days for \")","v":"day for"},{"$f":"ROUND('Time to Market Background Calcs'!E14,0)","v":{"$error":"#VALUE!"}},null,null,null,"facilities seeking permits in the "]
[null,null,{"$f":"TRIM(LOWER(industry_tm))&\" sector:\"","v":" sector:"}]
[]
[null,4,"The benefits could be as high as",null,null,null,null,{"$f":"'Time to Market Background Calcs'!E20","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,"in additional economic activity each year."]
[]
[null,null,null,null,null,"Assumptions:",null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"State:",{"$f":"state_tm","v":0}]
[null,null,null,null,null,null,null,"Industry/Sector:",{"$f":"TRIM(industry_tm)","v":""}]
[]
[null,null,null,null,null,null,null,"# of Facilities Affected by Permit:",{"$f":"'Time to Market Background Calcs'!E14","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"% of Facilities in Industry Affected by Permit:",{"$f":"IF('Time to Market Background Calcs'!E18<0.01,\"<1%\",'Time to Market Background Calcs'!E18)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Time to Market Background Calcs'!C68*'Time to Market Background Calcs'!E8>='Time to Market Background Calcs'!E10/2, \"Warning: The result (\"&H26&\") 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,null,null,null,null,null,null,"Current Permit Processing Time:",{"$f":"'Time to Market Background Calcs'!E6&\" days\"","v":"0 days"}]
[null,null,null,null,null,null,null,"New, Shorter Permit Processing Time:",{"$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, Gross-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,"32015 Establishment data from U.S. County Business Patterns."]

{"sheet":"Time to Market Background Calcs","index":4,"n_rows":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[[55,1,57,1],[63,2,63,4],[64,1,67,1],[42,2,42,4],[43,1,45,1],[54,2,54,4],[43,2,44,4],[51,3,51,4],[60,3,60,4],[57,2,59,4],[55,2,56,4],[64,2,65,4],[67,3,68,4],[69,3,71,4],[5,2,5,3],[6,2,6,3],[21,2,22,4],[23,2,24,4],[25,3,26,4],[30,2,31,4],[33,2,34,4],[45,2,49,4],[32,2,32,4],[35,2,37,4],[27,3,29,4],[40,2,40,4],[38,2,39,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'!E2:E880,MATCH(E2&E3,'BEA2'!B2:B880&'BEA2'!C2:C880,0)),\"\")","v":""}]
[null,null,null,"Total GDP",{"$f":"INDEX('BEA2'!D2:D880,MATCH(E2&E3,'BEA2'!B2:B880&'BEA2'!C2:C880,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'!E2:E880,MATCH(E2&E3,'BEA2'!B2:B880&'BEA2'!C2:C880,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,null,"Total Benefits",{"$f":"IF(ABS('Time to Market Background Calcs'!C28)<10,\"< $0.1\",IF(ABS('Time to Market Background Calcs'!C28)<100,TEXT('Time to Market Background Calcs'!C28,\"$#,##0.0\"),TEXT('Time to Market Background Calcs'!C28,\"$#,##0\")))&\" million\"","v":{"$error":"#N/A"}}]
[]
[null,null,{"$f":"C64","v":"RESULTS"}]
[]
[null,null,{"$f":"C65","v":" time to market benefits from reductions in permit processing times for 0"}]
[]
[null,null,{"$f":"C68","v":{"$error":"#N/A"}},{"$f":"D68","v":"million in daily economic activity × 0 days of additional economic activity "}]
[]
[null,null,{"$f":"C70","v":{"$error":"#N/A"}},{"$f":"D70","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 2015 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 2015 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(C53,2)&\" \"&D53&\" in \"&TRIM(LOWER(E3))&\"  / 365 days per year\"","v":{"$error":"#N/A"}}]
[]
[]
[null,null,{"$f":"C53","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":"C62","v":{"$error":"#N/A"}},{"$f":"D62&\" × \"&C41&\" \"&D41","v":"million in daily economic activity × 0 days of additional economic activity "}]
[]
[null,null,{"$f":"IF(E15>100,DOLLAR(E15,0),DOLLAR(E15,2))","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 formal 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":50,"n_cols":4,"rows_kept":50,"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],[44,1,47,3],[49,1,49,2],[35,1,38,3],[21,0,21,2],[16,1,19,3],[33,1,34,3],[42,1,43,3],[40,1,40,2],[25,1,29,3],[31,1,31,2],[23,1,24,3]]}
[]
[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, particularly for smaller businesses. 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,"Time Period over which Benefits Accrue"]
[]
[null,"If you are considering a specific process or activity which requires increased compliance staff time during only part of the year (e.g., permit applications), adjust the number of weeks accordingly. For example, if your permit process requires 12 hours of compliance labor per week for two months (eight weeks), you should have entered 12 hours in the cell above, and 8 weeks in the cell below. This will appropriately consider only benefits associated with a two-month period, rather than benefits accruing over the entire year."]
[]
[]
[]
[]
[]
[null,"Time period over which benefits accrue (weeks/year):",null,52]
[]
[null,"Average Compliance Staff Cost"]
[]
[null,"The national average compliance staff cost is $48.48/hour, according to U.S. Census Bureau's 2014 Statistics of U.S. Businesses (SUSB). If your state has lower or higher average wage rates, you may want to adjust this number to reflect that. 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 the potential benefits of firms repurposing their compliance staff time 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)?\n"]
[]
[]
[]
[]
[null,"Enter the percent of firm compliance staff time repurposed:"]

{"sheet":"Trusted Transactions Results","index":7,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[[33,14,33,17],[39,3,40,28],[41,3,42,28],[37,14,37,17],[34,20,37,20],[35,14,35,16],[36,14,36,18],[34,14,34,18],[2,2,3,28],[12,2,13,2],[12,3,13,16],[4,2,9,28],[10,2,11,28],[28,13,29,22],[15,16,15,18],[28,3,29,12],[15,19,15,21],[25,5,25,7],[25,8,25,14],[25,15,25,17]]}
[]
[]
[null,null,"Beyond ROI Metrics: Trusted Transactions"]
[]
[null,null,"More efficient, transparent interfaces and systems can reduce the high cost of interactions between regulated firms and the regulating agency. An increase in trusted transactions can allow regulated firms to realign compliance staff time toward value-added use, improving economic efficiency and productivity."]
[]
[]
[]
[]
[]
[null,null,"Thomson Reuters estimates that each firm spends an average of 3.5 hours per week on compliance.1"]
[]
[null,null,"In",{"$f":"IF(the_tt=1,\"the \",\"\")&state_tt&\":\"","v":":"}]
[]
[]
[null,null,null,"4 Annual regulatory compliance labor costs for",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"num_firms_tt","v":0},null,null,"firms in",null,null,{"$f":"IF(the_tt=1,\"the \",\"\")&state_tt","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"are",{"$f":"DOLLAR('Trusted Trans. Background Calcs'!D9,0)","v":"$0"}]
[]
[null,null,null,"4 Annual regulatory compliance labor costs for a single firm in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(the_tt=1,\"the \",\"\")&state_tt","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"are",{"$f":"DOLLAR('Trusted Trans. Background Calcs'!D8,0)","v":"$8,823"}]
[]
[]
[null,null,null,"If a process improvement project in",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(the_tt=1,\"the \",\"\")&state_tt","v":""}]
[null,null,null,"allows",null,{"$f":"num_firms_tt","v":0},null,null,"firms to repurpose ",null,null,null,null,null,null,{"$f":"percent_tt","v":0},null,null,"of their compliance staff time"]
[null,null,null,"to other value-added use:"]
[]
[null,null,null,"4 The benefits could be as high as",null,null,null,null,null,null,null,null,null,{"$f":"DOLLAR('Trusted Trans. Background Calcs'!D11,0)","v":"$0"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Assumptions:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"State:",{"$f":"state_tt","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"# of Firms Affected by Permit:",{"$f":"num_firms_tt","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Compliance Labor Rate2 ($/hr):",{"$f":"DOLLAR('Trusted Trans. Background Calcs'!D7)","v":"$48.48"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time Period of Permit Application Process (weeks):",{"$f":"time_period_tt","v":52}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Compliance Staff Burden (hr/wk):",{"$f":"'Trusted Trans. Background Calcs'!D5","v":3.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time Repurposed to Value-Added Use (hr/wk):",{"$f":"percent_tt*O37","v":0}]
[]
[null,null,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,null,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*time_period_tt","v":182},null,182]
[null,"Average Compliance Staff Cost",null,{"$f":"'Trusted Transactions Inputs'!D41","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'!D50","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},{"$f":"\"hours in weekly compliance × \"&time_period_tt&\" weeks per year =\"","v":"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 environmental 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,16,4]]}
[]
[null,null,"ePERMITTING BENEFITS CALCULATOR:\n RIGHT INFO, RIGHT TIME METRIC"]
[]
[]
[null,null,"The \"right info, right time\" metric estimates the value of time saved by the public/industry when it becomes easier to access data and conduct transactions (e.g., online driver’s license renewals vs. in-person). This benefit captures the value of enabling 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 to make questions or needs known.  \n\nEnhanced access to information through electronic platforms reduces time users spend searching for information, and minimizes the need to file formal requests to obtain data (e.g., FOIA requests). Users also have the flexibility to conduct transactions outside of business hours (as electronic platforms feature round-the-clock access) and save time by receiving information quickly and electronically. \n\nAdditional benefits may accrue due to savings on travel time and costs, materials, and increased productivity, but these are not included in this analysis."]

{"sheet":"Right Info, Right Time Inputs","index":10,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,2],[36,1,36,2],[37,1,38,3],[39,1,42,3],[21,1,24,3],[29,1,30,3],[31,1,33,3],[25,1,27,2],[1,1,1,3],[13,1,13,2],[34,1,35,2],[9,1,11,3],[7,1,8,3],[19,1,20,3],[2,1,3,3],[17,2,17,3],[15,1,16,2]]}
[]
[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,"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 respond to from facilities/citizens considered in this analysis?"]
[]
[]
[]
[null,"Enter number of transactions/requests you respond to:"]
[]
[null,"Enter the time period over which this number of transactions/requests takes place:",null,null,null,null,"One day"]
[null,null,null,null,null,null,"One month"]
[null,null,"Choose one day/month/year from the drop-down by clicking in the cell",null,null,null,"One year"]
[]
[null,"Average Time of Each Information Request/Transaction"]
[]
[null,"The average time per interaction to make an information requests is 10 minutes (0.17 hours) from the Deloitte 2015 Doing Business Report. If your average requests take more (or less) time you should adjust this number. 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 across all sectors. If your request involves specific sectors or firm staff (e.g., legal or technical staff) you might want to adjust this number. 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 the benefits of reducing the time spent on formal/in-person transactions focused on requesting or transmitting information. How much time per transaction (percentage basis) does your ePermitting process improvement save?"]
[]
[]
[]
[]
[null,"Enter the percent reduction here:"]

{"sheet":"Right Info, Right Time Results","index":11,"n_rows":42,"n_cols":31,"rows_kept":42,"cut":false,"hidden":false,"merged":[[13,2,14,15],[2,1,3,32],[5,1,8,32],[9,1,12,32],[13,1,14,1],[18,14,18,19],[22,14,22,19],[39,1,40,32],[37,12,37,14],[35,12,35,15],[34,12,34,14],[36,12,36,17],[32,1,32,23],[29,1,30,11],[29,12,30,19],[29,20,30,23],[29,24,30,29],[29,30,30,32]]}
[]
[]
[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,null,"4 One year of transactions/requests for firms and citizens considered in this analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"in \"&IF(the_rr=1,\"the \",\"\")&state_rr","v":"in "}]
[]
[null,null,null,null,null,null,null,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,null,null,null,null,"to complete."]
[]
[null,null,"4 One year of transactions/requests for firms and citizens considered in this analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"in \"&IF(the_rr=1,\"the \",\"\")&state_rr","v":"in "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"is worth",{"$f":"DOLLAR('Right Info, Right Time Calcs'!D9,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"in total opportunity costs.2"]
[]
[]
[null,null,null,"If a process improvement project in",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(the_rr=1,\"the \",\"\")&state_rr","v":""}]
[null,null,null,"allows the regulated community/public to reduce the time spent"]
[null,null,null,"on information requests and/or transactions by ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*percent_rr&\"%:\"","v":"0%:"}]
[]
[null,"4 The time savings could be as high as",null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT('Right Info, Right Time Calcs'!D8*'Right Info, Right Time Calcs'!D6*percent_rr,\"#,##0\")&\" hours\"","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"with a value of",null,null,null,{"$f":"DOLLAR('Right Info, Right Time Calcs'!D11,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"per year."]
[]
[]
[null,"Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,"State:",{"$f":"state_rr","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Time per interaction (hours):",{"$f":"'Right Info, Right Time Calcs'!D8","v":0.17}]
[null,null,null,null,null,null,null,null,null,null,null,"Wage Rate ($/hour):",{"$f":"'Right Info, Right Time Calcs'!D7","v":17.809999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,"Current Number of Transactions Per Year:",{"$f":"'Right Info, Right Time Calcs'!D6","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Percent Reduction in Number/Time:",{"$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 Australian 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'!D17","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'!D36","v":17.809999999999999}]
[null,"Avg time of transaction",null,{"$f":"'Right Info, Right Time Inputs'!D28","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'!D45","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":880,"n_cols":5,"rows_kept":880,"cut":false,"hidden":false,"merged":[]}
["BEA code","State","Industry","GDP (mil $)","Establishments"]
["1","United States","All industry total",17925143,7663938]
["10","United States","Utilities",284331,17990]
["11","United States","All construction",732120,682390]
["11.1","United States","Commercial Construction",110049,38565]
["12","United States","All manufacturing",2170275,292825]
["16","United States","Primary metals manufacturing",55923,4533]
["3","United States","Agriculture, forestry, fishing, and hunting",175236,22368]
["32","United States","Chemical products manufacturing",377315,13182]
["34","United States","Wholesale trade",1093237,413437]
["35","United States","Retail trade",1056781,1070209]
["36","United States","Transportation and warehousing",542528,228382]
["6","United States","Mining",327796,29225]
["67","United States","Waste management and remediation",45059,23875]
["7","United States","Oil and gas extraction",206171,7906]
["70","United States","Health care and social assistance",1298901,876072]
["78","United States","Accommodation and food services",524179,687619]
["81","United States","Other services, except government",401652,746046]
["1","Alabama","All industry total",199980,98540]
["10","Alabama","Utilities",5289,426]
["11","Alabama","All construction",7216,7317]
["11.1","Alabama","Commercial Construction",1084.6768070808064,591]
["12","Alabama","All manufacturing",35233,4158]
["16","Alabama","Primary metals manufacturing",3342,107]
["3","Alabama","Agriculture, forestry, fishing, and hunting",2666,793]
["32","Alabama","Chemical products manufacturing",3793,186]
["34","Alabama","Wholesale trade",11419,5315]
["35","Alabama","Retail trade",14648,18043]
["36","Alabama","Transportation and warehousing",5230,2903]
["6","Alabama","Mining",3239,228]
["67","Alabama","Waste management and remediation",414,313]
["7","Alabama","Oil and gas extraction",426,30]
["70","Alabama","Health care and social assistance",14481,10594]
["78","Alabama","Accommodation and food services",5265,8551]
["81","Alabama","Other services, except government",5109,10925]
["1","Alaska","All industry total",53384,20907]
["10","Alaska","Utilities",804,100]
["11","Alaska","All construction",2231,2537]
["11.1","Alaska","Commercial Construction",335.35392968365841,256]
["12","Alaska","All manufacturing",1608,535]
["16","Alaska","Primary metals manufacturing",2,5]
["3","Alaska","Agriculture, forestry, fishing, and hunting",612,444]
["32","Alaska","Chemical products manufacturing",33,8]
["34","Alaska","Wholesale trade",1285,729]
["35","Alaska","Retail trade",2281,2514]
["36","Alaska","Transportation and warehousing",6034,1144]
["6","Alaska","Mining",10385,180]
["67","Alaska","Waste management and remediation",243,154]
["7","Alaska","Oil and gas extraction",7155,24]
["70","Alaska","Health care and social assistance",3525,2578]
["78","Alaska","Accommodation and food services",1497,2125]
["81","Alaska","Other services, except government",905,1795]
["1","Arizona","All industry total",291448,136352]
["10","Arizona","Utilities",5523,258]
["11","Arizona","All construction",11822,11615]
["11.1","Arizona","Commercial Construction",1777.0301016226849,689]
["12","Arizona","All manufacturing",24010,4268]
["16","Arizona","Primary metals manufacturing",855,73]
["3","Arizona","Agriculture, forestry, fishing, and hunting",2168,203]
["32","Arizona","Chemical products manufacturing",922,168]
["34","Arizona","Wholesale trade",16766,6488]
["35","Arizona","Retail trade",22941,18103]
["36","Arizona","Transportation and warehousing",9097,3318]
["6","Arizona","Mining",4884,237]
["67","Arizona","Waste management and remediation",678,398]
["7","Arizona","Oil and gas extraction",14,20]
["70","Arizona","Health care and social assistance",24093,17718]
["78","Arizona","Accommodation and food services",10119,12207]
["81","Arizona","Other services, except government",6352,10978]
["1","Arkansas","All industry total",118677,65175]
["10","Arkansas","Utilities",2918,327]
["11","Arkansas","All construction",4511,5198]
["11.1","Arkansas","Commercial Construction",678.07331994754963,359]
["12","Arkansas","All manufacturing",17433,2605]
["16","Arkansas","Primary metals manufacturing",1029,57]
["3","Arkansas","Agriculture, forestry, fishing, and hunting",3270,641]
["32","Arkansas","Chemical products manufacturing",1210,105]
["34","Arkansas","Wholesale trade",8782,3418]
["35","Arkansas","Retail trade",8415,10908]
["36","Arkansas","Transportation and warehousing",5092,2359]
["6","Arkansas","Mining",2585,398]
["67","Arkansas","Waste management and remediation",286,235]
["7","Arkansas","Oil and gas extraction",1658,111]
["70","Arkansas","Health care and social assistance",9523,7615]
["78","Arkansas","Accommodation and food services",3059,5600]
["81","Arkansas","Other services, except government",2670,6608]
["1","California","All industry total",2491619,908120]
["10","California","Utilities",28467,1219]
["11","California","All construction",92036,69900]
["11.1","California","Commercial Construction",13834.439386985741,4171]
["12","California","All manufacturing",281099,38532]
["16","California","Primary metals manufacturing",1666,398]
["3","California","Agriculture, forestry, fishing, and hunting",33928,1881]
["32","California","Chemical products manufacturing",54654,1592]
["34","California","Wholesale trade",138817,59353]
["35","California","Retail trade",142344,108542]
["36","California","Transportation and warehousing",58793,23153]
["6","California","Mining",11640,839]
["67","California","Waste management and remediation",5822,1918]
["7","California","Oil and gas extraction",8922,253]
["70","California","Health care and social assistance",153551,109285]
["78","California","Accommodation and food services",69263,83829]
["81","California","Other services, except government",54201,73293]
["1","Colorado","All industry total",313329,161737]
["10","Colorado","Utilities",4289,385]
["11","Colorado","All construction",17112,17083]
["11.1","Colorado","Commercial Construction",2572.1992132437308,782]
["12","Colorado","All manufacturing",22423,5040]
["16","Colorado","Primary metals manufacturing",281,42]
["3","Colorado","Agriculture, forestry, fishing, and hunting",2451,329]
["32","Colorado","Chemical products manufacturing",1887,212]
["34","Colorado","Wholesale trade",17738,7219]
["35","Colorado","Retail trade",17386,18734]
["36","Colorado","Transportation and warehousing",10935,3779]
["6","Colorado","Mining",13548,1355]
["67","Colorado","Waste management and remediation",800,593]
["7","Colorado","Oil and gas extraction",9300,435]
["70","Colorado","Health care and social assistance",19280,15731]
["78","Colorado","Accommodation and food services",10174,13262]
["81","Colorado","Other services, except government",7258,13992]
["1","Connecticut","All industry total",256306,89232]
["10","Connecticut","Utilities",4486,139]
["11","Connecticut","All construction",8023,7958]
["11.1","Connecticut","Commercial Construction",1205.9814333715785,366]
["12","Connecticut","All manufacturing",28551,4135]
["16","Connecticut","Primary metals manufacturing",346,65]
["3","Connecticut","Agriculture, forestry, fishing, and hunting",273,72]
["32","Connecticut","Chemical products manufacturing",4898,154]
["34","Connecticut","Wholesale trade",16638,4261]
["35","Connecticut","Retail trade",14057,12524]
["36","Connecticut","Transportation and warehousing",4583,1708]
["6","Connecticut","Mining",263,77]
["67","Connecticut","Waste management and remediation",720,374]
["7","Connecticut","Oil and gas extraction",0,5]
["70","Connecticut","Health care and social assistance",20537,10772]
["78","Connecticut","Accommodation and food services",5423,8459]
["81","Connecticut","Other services, except government",5119,9472]
["1","Delaware","All industry total",68864,24852]
["10","Delaware","Utilities",910,52]
["11","Delaware","All construction",2470,2194]
["11.1","Delaware","Commercial Construction",371.27933945254875,106]
["12","Delaware","All manufacturing",4342,583]
["16","Delaware","Primary metals manufacturing",32,4]
["3","Delaware","Agriculture, forestry, fishing, and hunting",494,38]
["32","Delaware","Chemical products manufacturing",1169,52]
["34","Delaware","Wholesale trade",2251,1117]
["35","Delaware","Retail trade",2895,3656]
["36","Delaware","Transportation and warehousing",1106,684]
["6","Delaware","Mining",3,15]
["67","Delaware","Waste management and remediation",136,79]
["7","Delaware","Oil and gas extraction",0,4]
["70","Delaware","Health care and social assistance",4808,2644]
["78","Delaware","Accommodation and food services",1469,2086]
["81","Delaware","Other services, except government",986,2174]
["1","District of Columbia","All industry total",121119,22553]
["10","District of Columbia","Utilities",1174,49]
["11","District of Columbia","All construction",1551,459]
["11.1","District of Columbia","Commercial Construction",233.13937469267336,104]
["12","District of Columbia","All manufacturing",261,101]
["3","District of Columbia","Agriculture, forestry, fishing, and hunting",null,1]
["32","District of Columbia","Chemical products manufacturing",105,6]
["34","District of Columbia","Wholesale trade",1097,419]
["35","District of Columbia","Retail trade",1449,1751]
["36","District of Columbia","Transportation and warehousing",456,164]
["6","District of Columbia","Mining",0,5]
["67","District of Columbia","Waste management and remediation",33,25]
["7","District of Columbia","Oil and gas extraction",0,4]
["70","District of Columbia","Health care and social assistance",5521,2106]
["78","District of Columbia","Accommodation and food services",3879,2504]
["81","District of Columbia","Other services, except government",7936,4153]
["1","Florida","All industry total",883861,532830]
["10","Florida","Utilities",14783,754]
["11","Florida","All construction",41118,48731]
["11.1","Florida","Commercial Construction",6180.6736354695959,2592]
["12","Florida","All manufacturing",45615,13112]
["16","Florida","Primary metals manufacturing",444,116]
["3","Florida","Agriculture, forestry, fishing, and hunting",6378,1018]
["32","Florida","Chemical products manufacturing",5997,597]
["34","Florida","Wholesale trade",60827,31221]
["35","Florida","Retail trade",67631,74533]
["36","Florida","Transportation and warehousing",29967,14576]
["6","Florida","Mining",1622,251]
["67","Florida","Waste management and remediation",2043,1163]
["7","Florida","Oil and gas extraction",38,28]
["70","Florida","Health care and social assistance",75734,59052]
["78","Florida","Accommodation and food services",38393,39324]
["81","Florida","Other services, except government",24950,46550]
["1","Georgia","All industry total",501522,224593]
["10","Georgia","Utilities",8477,602]
["11","Georgia","All construction",19185,16958]
["11.1","Georgia","Commercial Construction",2883.8032904441898,1289]
["12","Georgia","All manufacturing",55070,7432]
["16","Georgia","Primary metals manufacturing",689,71]
["3","Georgia","Agriculture, forestry, fishing, and hunting",4140,952]
["32","Georgia","Chemical products manufacturing",5485,479]
["34","Georgia","Wholesale trade",39426,12928]
["35","Georgia","Retail trade",30244,34041]
["36","Georgia","Transportation and warehousing",21097,6597]
["6","Georgia","Mining",1274,199]
["67","Georgia","Waste management and remediation",791,650]
["7","Georgia","Oil and gas extraction",0,5]
["70","Georgia","Health care and social assistance",31680,24207]
["78","Georgia","Accommodation and food services",13640,19704]
["81","Georgia","Other services, except government",10092,20994]
["1","Hawaii","All industry total",80599,31915]
["10","Hawaii","Utilities",1485,62]
["11","Hawaii","All construction",4744,2773]
["11.1","Hawaii","Commercial Construction",713.09683658416657,209]
["12","Hawaii","All manufacturing",1766,764]
["16","Hawaii","Primary metals manufacturing",1,3]
["3","Hawaii","Agriculture, forestry, fishing, and hunting",406,33]
["32","Hawaii","Chemical products manufacturing",99,20]
["34","Hawaii","Wholesale trade",2539,1661]
["35","Hawaii","Retail trade",5494,4602]
["36","Hawaii","Transportation and warehousing",3773,885]
["6","Hawaii","Mining",93,9]
["67","Hawaii","Waste management and remediation",208,133]
["7","Hawaii","Oil and gas extraction",1,2]
["70","Hawaii","Health care and social assistance",5292,3651]
["78","Hawaii","Accommodation and food services",6931,3627]
["81","Hawaii","Other services, except government",1895,3491]
["1","Idaho","All industry total",65460,44757]
["10","Idaho","Utilities",975,199]
["11","Idaho","All construction",3591,6184]
["11.1","Idaho","Commercial Construction",539.78303966562862,298]
["12","Idaho","All manufacturing",7551,1754]
["16","Idaho","Primary metals manufacturing",502,21]
["3","Idaho","Agriculture, forestry, fishing, and hunting",3468,443]
["32","Idaho","Chemical products manufacturing",352,61]
["34","Idaho","Wholesale trade",3959,2064]
["35","Idaho","Retail trade",5568,6004]
["36","Idaho","Transportation and warehousing",1941,1751]
["6","Idaho","Mining",1097,113]
["67","Idaho","Waste management and remediation",290,145]
["7","Idaho","Oil and gas extraction",20,2]
["70","Idaho","Health care and social assistance",5181,5077]
["78","Idaho","Accommodation and food services",1783,3605]
["81","Idaho","Other services, except government",1327,3390]
["1","Illinois","All industry total",772182,318266]
["10","Illinois","Utilities",12475,491]
["11","Illinois","All construction",28144,28676]
["11.1","Illinois","Commercial Construction",4230.480052450418,1326]
["12","Illinois","All manufacturing",101684,13470]
["16","Illinois","Primary metals manufacturing",1904,269]
["3","Illinois","Agriculture, forestry, fishing, and hunting",5245,334]
["32","Illinois","Chemical products manufacturing",19304,683]
["34","Illinois","Wholesale trade",59824,18539]
["35","Illinois","Retail trade",39760,39165]
["36","Illinois","Transportation and warehousing",30345,15486]
["6","Illinois","Mining",2124,546]
["67","Illinois","Waste management and remediation",1895,899]
["7","Illinois","Oil and gas extraction",146,165]
["70","Illinois","Health care and social assistance",53627,33880]
["78","Illinois","Accommodation and food services",21750,27731]
["81","Illinois","Other services, except government",18491,32087]
["1","Indiana","All industry total",333363,145116]
["10","Indiana","Utilities",5797,545]
["11","Indiana","All construction",12543,13035]
["11.1","Indiana","Commercial Construction",1885.4075930175381,690]
["12","Indiana","All manufacturing",98244,7991]
["16","Indiana","Primary metals manufacturing",8414,226]
["3","Indiana","Agriculture, forestry, fishing, and hunting",4050,264]
["32","Indiana","Chemical products manufacturing",26637,308]
["34","Indiana","Wholesale trade",18373,7668]
["35","Indiana","Retail trade",19638,21426]
["36","Indiana","Transportation and warehousing",11305,5294]
["6","Indiana","Mining",1805,287]
["67","Indiana","Waste management and remediation",932,516]
["7","Indiana","Oil and gas extraction",38,39]
["70","Indiana","Health care and social assistance",25849,16342]
["78","Indiana","Accommodation and food services",7937,13123]
["81","Indiana","Other services, except government",7525,16313]
["1","Iowa","All industry total",175809,80952]
["10","Iowa","Utilities",2785,275]
["11","Iowa","All construction",7787,8542]
["11.1","Iowa","Commercial Construction",1170.5069701688249,506]
["12","Iowa","All manufacturing",32971,3525]
["16","Iowa","Primary metals manufacturing",964,57]
["3","Iowa","Agriculture, forestry, fishing, and hunting",9537,351]
["32","Iowa","Chemical products manufacturing",6397,179]
["34","Iowa","Wholesale trade",10168,4974]
["35","Iowa","Retail trade",9545,11736]
["36","Iowa","Transportation and warehousing",5838,3535]
["6","Iowa","Mining",325,188]
["67","Iowa","Waste management and remediation",305,354]
["7","Iowa","Oil and gas extraction",0,2]
["70","Iowa","Health care and social assistance",11881,8489]
["78","Iowa","Accommodation and food services",3893,6933]
["81","Iowa","Other services, except government",3672,9090]
["1","Kansas","All industry total",151845,74526]
["10","Kansas","Utilities",2356,237]
["11","Kansas","All construction",6147,7014]
["11.1","Kansas","Commercial Construction",923.98951401409613,406]
["12","Kansas","All manufacturing",23932,2817]
["16","Kansas","Primary metals manufacturing",143,38]
["3","Kansas","Agriculture, forestry, fishing, and hunting",4547,192]
["32","Kansas","Chemical products manufacturing",2042,134]
["34","Kansas","Wholesale trade",10164,4459]
["35","Kansas","Retail trade",9660,10327]
["36","Kansas","Transportation and warehousing",5796,2554]
["6","Kansas","Mining",1490,1069]
["67","Kansas","Waste management and remediation",300,256]
["7","Kansas","Oil and gas extraction",978,409]
["70","Kansas","Health care and social assistance",11369,8103]
["78","Kansas","Accommodation and food services",3791,6034]
["81","Kansas","Other services, except government",3186,7869]
["1","Kentucky","All industry total",191897,91845]
["10","Kentucky","Utilities",2776,335]
["11","Kentucky","All construction",8150,7108]
["11.1","Kentucky","Commercial Construction",1225.0715046713653,485]
["12","Kentucky","All manufacturing",36936,3692]
["16","Kentucky","Primary metals manufacturing",2339,80]
["3","Kentucky","Agriculture, forestry, fishing, and hunting",2334,224]
["32","Kentucky","Chemical products manufacturing",2549,192]
["34","Kentucky","Wholesale trade",12842,4293]
["35","Kentucky","Retail trade",11318,15187]
["36","Kentucky","Transportation and warehousing",9082,2938]
["6","Kentucky","Mining",3240,487]
["67","Kentucky","Waste management and remediation",472,308]
["7","Kentucky","Oil and gas extraction",217,84]
["70","Kentucky","Health care and social assistance",15683,12875]
["78","Kentucky","Accommodation and food services",5886,7910]
["81","Kentucky","Other services, except government",4168,9371]
["1","Louisiana","All industry total",238075,105575]
["10","Louisiana","Utilities",3771,501]
["11","Louisiana","All construction",12711,8002]
["11.1","Louisiana","Commercial Construction",1910.6606007211933,679]
["12","Louisiana","All manufacturing",51074,3273]
["16","Louisiana","Primary metals manufacturing",474,29]
["3","Louisiana","Agriculture, forestry, fishing, and hunting",1605,600]
["32","Louisiana","Chemical products manufacturing",15181,226]
["34","Louisiana","Wholesale trade",12276,5463]
["35","Louisiana","Retail trade",15203,16525]
["36","Louisiana","Transportation and warehousing",10620,3924]
["6","Louisiana","Mining",11849,1644]
["67","Louisiana","Waste management and remediation",1000,420]
["7","Louisiana","Oil and gas extraction",7024,411]
["70","Louisiana","Health care and social assistance",16654,12143]
["78","Louisiana","Accommodation and food services",7998,9390]
["81","Louisiana","Other services, except government",5220,9718]
["1","Maine","All industry total",57332,40801]
["10","Maine","Utilities",940,89]
["11","Maine","All construction",2236,4834]
["11.1","Maine","Commercial Construction",336.10550729388626,145]
["12","Maine","All manufacturing",5326,1661]
["16","Maine","Primary metals manufacturing",16,11]
["3","Maine","Agriculture, forestry, fishing, and hunting",836,899]
["32","Maine","Chemical products manufacturing",468,54]
["34","Maine","Wholesale trade",3242,1581]
["35","Maine","Retail trade",4824,6281]
["36","Maine","Transportation and warehousing",1300,1209]
["6","Maine","Mining",32,21]
["67","Maine","Waste management and remediation",175,212]
["70","Maine","Health care and social assistance",6668,4817]
["78","Maine","Accommodation and food services",2222,4122]
["81","Maine","Other services, except government",1328,3634]
["1","Maryland","All industry total",366242,137204]
["10","Maryland","Utilities",6466,142]
["11","Maryland","All construction",16658,13970]
["11.1","Maryland","Commercial Construction",2503.9559662350434,849]
["12","Maryland","All manufacturing",20727,2968]
["16","Maryland","Primary metals manufacturing",87,27]
["3","Maryland","Agriculture, forestry, fishing, and hunting",791,195]
["32","Maryland","Chemical products manufacturing",6729,159]
["34","Maryland","Wholesale trade",16030,5581]
["35","Maryland","Retail trade",19428,18273]
["36","Maryland","Transportation and warehousing",7558,3499]
["6","Maryland","Mining",344,76]
["67","Maryland","Waste management and remediation",926,459]
["7","Maryland","Oil and gas extraction",2,2]
["70","Maryland","Health care and social assistance",27266,16349]
["78","Maryland","Accommodation and food services",9414,11656]
["81","Maryland","Other services, except government",8615,13727]
["1","Massachusetts","All industry total",488100,175225]
["10","Massachusetts","Utilities",5918,269]
["11","Massachusetts","All construction",17830,17934]
["11.1","Massachusetts","Commercial Construction",2680.1257580724473,749]
["12","Massachusetts","All manufacturing",47879,6544]
["16","Massachusetts","Primary metals manufacturing",316,90]
["3","Massachusetts","Agriculture, forestry, fishing, and hunting",785,336]
["32","Massachusetts","Chemical products manufacturing",9859,329]
["34","Massachusetts","Wholesale trade",24621,7763]
["35","Massachusetts","Retail trade",20576,24101]
["36","Massachusetts","Transportation and warehousing",8032,3779]
["6","Massachusetts","Mining",302,75]
["67","Massachusetts","Waste management and remediation",1380,633]
["7","Massachusetts","Oil and gas extraction",4,3]
["70","Massachusetts","Health care and social assistance",45334,18825]
["78","Massachusetts","Accommodation and food services",13434,17230]
["81","Massachusetts","Other services, except government",9412,17854]
["1","Michigan","All industry total",470611,219627]
["10","Michigan","Utilities",8132,376]
["11","Michigan","All construction",18335,18566]
["11.1","Michigan","Commercial Construction",2756.0350967054583,990]
["12","Michigan","All manufacturing",92140,12437]
["16","Michigan","Primary metals manufacturing",3017,255]
["3","Michigan","Agriculture, forestry, fishing, and hunting",3421,572]
["32","Michigan","Chemical products manufacturing",6856,374]
["34","Michigan","Wholesale trade",30742,11053]
["35","Michigan","Retail trade",30856,34711]
["36","Michigan","Transportation and warehousing",11650,6227]
["6","Michigan","Mining",2503,343]
["67","Michigan","Waste management and remediation",1206,716]
["7","Michigan","Oil and gas extraction",166,80]
["70","Michigan","Health care and social assistance",38375,26637]
["78","Michigan","Accommodation and food services",12621,19769]
["81","Michigan","Other services, except government",11212,23036]
["1","Minnesota","All industry total",326833,148666]
["10","Minnesota","Utilities",5328,336]
["11","Minnesota","All construction",13432,16246]
["11.1","Minnesota","Commercial Construction",2019.0380921160468,697]
["12","Minnesota","All manufacturing",48236,7311]
["16","Minnesota","Primary metals manufacturing",571,90]
["3","Minnesota","Agriculture, forestry, fishing, and hunting",6260,543]
["32","Minnesota","Chemical products manufacturing",2965,266]
["34","Minnesota","Wholesale trade",22558,8032]
["35","Minnesota","Retail trade",18286,18974]
["36","Minnesota","Transportation and warehousing",9695,4699]
["6","Minnesota","Mining",2812,157]
["67","Minnesota","Waste management and remediation",737,608]
["7","Minnesota","Oil and gas extraction",53,6]
["70","Minnesota","Health care and social assistance",29937,16320]
["78","Minnesota","Accommodation and food services",7571,11482]
["81","Minnesota","Other services, except government",7027,15503]
["1","Mississippi","All industry total",105871,58662]
["10","Mississippi","Utilities",2924,590]
["11","Mississippi","All construction",4544,3802]
["11.1","Mississippi","Commercial Construction",683.03373217505327,328]
["12","Mississippi","All manufacturing",16877,2117]
["16","Mississippi","Primary metals manufacturing",516,32]
["3","Mississippi","Agriculture, forestry, fishing, and hunting",2590,694]
["32","Mississippi","Chemical products manufacturing",1469,96]
["34","Mississippi","Wholesale trade",5485,2756]
["35","Mississippi","Retail trade",8784,11587]
["36","Mississippi","Transportation and warehousing",3641,2065]
["6","Mississippi","Mining",1102,373]
["67","Mississippi","Waste management and remediation",231,187]
["7","Mississippi","Oil and gas extraction",638,80]
["70","Mississippi","Health care and social assistance",7928,6200]
["78","Mississippi","Accommodation and food services",3976,5450]
["81","Mississippi","Other services, except government",2600,6354]
["1","Missouri","All industry total",292718,158191]
["10","Missouri","Utilities",5500,372]
["11","Missouri","All construction",10271,13052]
["11.1","Missouri","Commercial Construction",1543.8907269300116,890]
["12","Missouri","All manufacturing",39539,5907]
["16","Missouri","Primary metals manufacturing",730,101]
["3","Missouri","Agriculture, forestry, fishing, and hunting",3486,279]
["32","Missouri","Chemical products manufacturing",7832,302]
["34","Missouri","Wholesale trade",19690,7705]
["35","Missouri","Retail trade",18552,21177]
["36","Missouri","Transportation and warehousing",10353,4757]
["6","Missouri","Mining",966,265]
["67","Missouri","Waste management and remediation",594,467]
["7","Missouri","Oil and gas extraction",3,16]
["70","Missouri","Health care and social assistance",24750,29047]
["78","Missouri","Accommodation and food services",7999,12472]
["81","Missouri","Other services, except government",6992,15357]
["1","Montana","All industry total",45845,37270]
["10","Montana","Utilities",1004,215]
["11","Montana","All construction",2721,5291]
["11.1","Montana","Commercial Construction",409.00853548598593,184]
["12","Montana","All manufacturing",3571,1276]
["16","Montana","Primary metals manufacturing",17,20]
["3","Montana","Agriculture, forestry, fishing, and hunting",1888,360]
["32","Montana","Chemical products manufacturing",139,37]
["34","Montana","Wholesale trade",2582,1594]
["35","Montana","Retail trade",3003,4791]
["36","Montana","Transportation and warehousing",2183,1381]
["6","Montana","Mining",2092,397]
["67","Montana","Waste management and remediation",117,141]
["7","Montana","Oil and gas extraction",516,89]
["70","Montana","Health care and social assistance",4171,3575]
["78","Montana","Accommodation and food services",1699,3480]
["81","Montana","Other services, except government",1024,3141]
["1","Nebraska","All industry total",113458,53719]
["10","Nebraska","Utilities",2255,120]
["11","Nebraska","All construction",3932,6245]
["11.1","Nebraska","Commercial Construction",591.04063268316668,318]
["12","Nebraska","All manufacturing",13294,1785]
["16","Nebraska","Primary metals manufacturing",185,16]
["3","Nebraska","Agriculture, forestry, fishing, and hunting",7434,193]
["32","Nebraska","Chemical products manufacturing",2758,87]
["34","Nebraska","Wholesale trade",7643,3209]
["35","Nebraska","Retail trade",6152,7352]
["36","Nebraska","Transportation and warehousing",9308,2390]
["6","Nebraska","Mining",239,128]
["67","Nebraska","Waste management and remediation",226,208]
["7","Nebraska","Oil and gas extraction",8,21]
["70","Nebraska","Health care and social assistance",8104,5529]
["78","Nebraska","Accommodation and food services",2352,4426]
["81","Nebraska","Other services, except government",2317,5785]
["1","Nevada","All industry total",141070,63383]
["10","Nevada","Utilities",2049,129]
["11","Nevada","All construction",6401,4784]
["11.1","Nevada","Commercial Construction",962.16965661366999,408]
["12","Nevada","All manufacturing",5895,1794]
["16","Nevada","Primary metals manufacturing",134,12]
["3","Nevada","Agriculture, forestry, fishing, and hunting",305,53]
["32","Nevada","Chemical products manufacturing",322,77]
["34","Nevada","Wholesale trade",5854,2969]
["35","Nevada","Retail trade",10689,8682]
["36","Nevada","Transportation and warehousing",6116,1565]
["6","Nevada","Mining",4151,212]
["67","Nevada","Waste management and remediation",358,142]
["7","Nevada","Oil and gas extraction",2,18]
["70","Nevada","Health care and social assistance",8247,6933]
["78","Nevada","Accommodation and food services",20744,6306]
["81","Nevada","Other services, except government",2838,4390]
["1","New Hampshire","All industry total",74269,37669]
["10","New Hampshire","Utilities",960,121]
["11","New Hampshire","All construction",2433,3938]
["11.1","New Hampshire","Commercial Construction",365.71766513686282,143]
["12","New Hampshire","All manufacturing",8260,1788]
["16","New Hampshire","Primary metals manufacturing",216,30]
["3","New Hampshire","Agriculture, forestry, fishing, and hunting",215,142]
["32","New Hampshire","Chemical products manufacturing",355,68]
["34","New Hampshire","Wholesale trade",5021,1839]
["35","New Hampshire","Retail trade",5306,6050]
["36","New Hampshire","Transportation and warehousing",1038,804]
["6","New Hampshire","Mining",60,49]
["67","New Hampshire","Waste management and remediation",204,179]
["7","New Hampshire","Oil and gas extraction",0,2]
["70","New Hampshire","Health care and social assistance",6612,3714]
["78","New Hampshire","Accommodation and food services",2382,3684]
["81","New Hampshire","Other services, except government",1788,3667]
["1","New Jersey","All industry total",564360,230961]
["10","New Jersey","Utilities",11072,378]
["11","New Jersey","All construction",22629,21079]
["11.1","New Jersey","Commercial Construction",3401.4899483691202,1014]
["12","New Jersey","All manufacturing",44257,7413]
["16","New Jersey","Primary metals manufacturing",491,94]
["3","New Jersey","Agriculture, forestry, fishing, and hunting",737,202]
["32","New Jersey","Chemical products manufacturing",17777,590]
["34","New Jersey","Wholesale trade",46959,14060]
["35","New Jersey","Retail trade",33320,31557]
["36","New Jersey","Transportation and warehousing",18505,7482]
["6","New Jersey","Mining",343,78]
["67","New Jersey","Waste management and remediation",1708,721]
["70","New Jersey","Health care and social assistance",43496,27458]
["78","New Jersey","Accommodation and food services",12445,20610]
["81","New Jersey","Other services, except government",11675,23583]
["1","New Mexico","All industry total",93230,43793]
["10","New Mexico","Utilities",1334,221]
["11","New Mexico","All construction",3392,4282]
["11.1","New Mexico","Commercial Construction",509.87025077856094,349]
["12","New Mexico","All manufacturing",4050,1358]
["16","New Mexico","Primary metals manufacturing",51,21]
["3","New Mexico","Agriculture, forestry, fishing, and hunting",1172,91]
["32","New Mexico","Chemical products manufacturing",354,45]
["34","New Mexico","Wholesale trade",3015,1847]
["35","New Mexico","Retail trade",5589,6536]
["36","New Mexico","Transportation and warehousing",2584,1402]
["6","New Mexico","Mining",9279,784]
["67","New Mexico","Waste management and remediation",334,175]
["7","New Mexico","Oil and gas extraction",5652,173]
["70","New Mexico","Health care and social assistance",6740,5080]
["78","New Mexico","Accommodation and food services",2953,4247]
["81","New Mexico","Other services, except government",2034,4048]
["1","New York","All industry total",1445611,540298]
["10","New York","Utilities",18790,585]
["11","New York","All construction",45439,47471]
["11.1","New York","Commercial Construction",6830.187006228487,2276]
["12","New York","All manufacturing",73344,15963]
["16","New York","Primary metals manufacturing",1584,186]
["3","New York","Agriculture, forestry, fishing, and hunting",2369,592]
["32","New York","Chemical products manufacturing",16385,563]
["34","New York","Wholesale trade",69231,31785]
["35","New York","Retail trade",70143,78832]
["36","New York","Transportation and warehousing",27887,12811]
["6","New York","Mining",1015,313]
["67","New York","Waste management and remediation",2518,1489]
["7","New York","Oil and gas extraction",177,40]
["70","New York","Health care and social assistance",100147,57362]
["78","New York","Accommodation and food services",37649,52169]
["81","New York","Other services, except government",29829,57629]
["1","North Carolina","All industry total",499741,223209]
["10","North Carolina","Utilities",7614,569]
["11","North Carolina","All construction",18163,21698]
["11.1","North Carolina","Commercial Construction",2730.1808269136209,1073]
["12","North Carolina","All manufacturing",100023,8739]
["16","North Carolina","Primary metals manufacturing",678,89]
["3","North Carolina","Agriculture, forestry, fishing, and hunting",4999,793]
["32","North Carolina","Chemical products manufacturing",29938,441]
["34","North Carolina","Wholesale trade",28821,11602]
["35","North Carolina","Retail trade",26863,34527]
["36","North Carolina","Transportation and warehousing",11226,5766]
["6","North Carolina","Mining",598,207]
["67","North Carolina","Waste management and remediation",912,717]
["7","North Carolina","Oil and gas extraction",14,6]
["70","North Carolina","Health care and social assistance",33522,23283]
["78","North Carolina","Accommodation and food services",13439,20199]
["81","North Carolina","Other services, except government",10248,23147]
["1","North Dakota","All industry total",55927,24848]
["10","North Dakota","Utilities",1404,143]
["11","North Dakota","All construction",4299,3127]
["11.1","North Dakota","Commercial Construction",646.20642927388951,202]
["12","North Dakota","All manufacturing",3848,758]
["16","North Dakota","Primary metals manufacturing",9,10]
["3","North Dakota","Agriculture, forestry, fishing, and hunting",2445,111]
["32","North Dakota","Chemical products manufacturing",200,13]
["34","North Dakota","Wholesale trade",4840,1723]
["35","North Dakota","Retail trade",3333,3259]
["36","North Dakota","Transportation and warehousing",3290,1651]
["6","North Dakota","Mining",7254,550]
["67","North Dakota","Waste management and remediation",103,153]
["7","North Dakota","Oil and gas extraction",2792,71]
["70","North Dakota","Health care and social assistance",3759,1996]
["78","North Dakota","Accommodation and food services",1258,2077]
["81","North Dakota","Other services, except government",1007,2486]
["1","Ohio","All industry total",607326,251668]
["10","Ohio","Utilities",11362,667]
["11","Ohio","All construction",22068,19731]
["11.1","Ohio","Commercial Construction",3317.1629405015574,1264]
["12","Ohio","All manufacturing",105956,14139]
["16","Ohio","Primary metals manufacturing",6091,382]
["3","Ohio","Agriculture, forestry, fishing, and hunting",3432,269]
["32","Ohio","Chemical products manufacturing",15768,673]
["34","Ohio","Wholesale trade",37801,14035]
["35","Ohio","Retail trade",37500,36339]
["36","Ohio","Transportation and warehousing",18457,7448]
["6","Ohio","Mining",7598,743]
["67","Ohio","Waste management and remediation",1913,912]
["7","Ohio","Oil and gas extraction",5112,191]
["70","Ohio","Health care and social assistance",51095,28976]
["78","Ohio","Accommodation and food services",14574,23697]
["81","Ohio","Other services, except government",12968,27493]
["1","Oklahoma","All industry total",188011,93093]
["10","Oklahoma","Utilities",4502,363]
["11","Oklahoma","All construction",8030,8189]
["11.1","Oklahoma","Commercial Construction",1207.0336420258975,769]
["12","Oklahoma","All manufacturing",18516,3510]
["16","Oklahoma","Primary metals manufacturing",297,56]
["3","Oklahoma","Agriculture, forestry, fishing, and hunting",3065,164]
["32","Oklahoma","Chemical products manufacturing",1185,129]
["34","Oklahoma","Wholesale trade",10568,4626]
["35","Oklahoma","Retail trade",11248,13305]
["36","Oklahoma","Transportation and warehousing",10020,2758]
["6","Oklahoma","Mining",24458,3203]
["67","Oklahoma","Waste management and remediation",376,324]
["7","Oklahoma","Oil and gas extraction",20491,1213]
["70","Oklahoma","Health care and social assistance",12868,10925]
["78","Oklahoma","Accommodation and food services",5099,7781]
["81","Oklahoma","Other services, except government",3916,8959]
["1","Oregon","All industry total",216522,112393]
["10","Oregon","Utilities",3107,274]
["11","Oregon","All construction",8093,11802]
["11.1","Oregon","Commercial Construction",1216.503519914768,471]
["12","Oregon","All manufacturing",47759,5432]
["16","Oregon","Primary metals manufacturing",1253,60]
["3","Oregon","Agriculture, forestry, fishing, and hunting",4141,1332]
["32","Oregon","Chemical products manufacturing",829,194]
["34","Oregon","Wholesale trade",11283,5352]
["35","Oregon","Retail trade",10704,14159]
["36","Oregon","Transportation and warehousing",5683,3097]
["6","Oregon","Mining",274,140]
["67","Oregon","Waste management and remediation",528,375]
["7","Oregon","Oil and gas extraction",1,5]
["70","Oregon","Health care and social assistance",16913,13364]
["78","Oregon","Accommodation and food services",6265,11057]
["81","Oregon","Other services, except government",4535,10015]
["1","Pennsylvania","All industry total",708402,299695]
["10","Pennsylvania","Utilities",11548,834]
["11","Pennsylvania","All construction",29716,26428]
["11.1","Pennsylvania","Commercial Construction",4466.7760531060485,1651]
["12","Pennsylvania","All manufacturing",85836,13666]
["16","Pennsylvania","Primary metals manufacturing",5234,360]
["3","Pennsylvania","Agriculture, forestry, fishing, and hunting",3839,501]
["32","Pennsylvania","Chemical products manufacturing",17696,575]
["34","Pennsylvania","Wholesale trade",41562,14628]
["35","Pennsylvania","Retail trade",36174,43399]
["36","Pennsylvania","Transportation and warehousing",22222,8660]
["6","Pennsylvania","Mining",15931,1139]
["67","Pennsylvania","Waste management and remediation",1824,1136]
["7","Pennsylvania","Oil and gas extraction",9838,209]
["70","Pennsylvania","Health care and social assistance",66698,37252]
["78","Pennsylvania","Accommodation and food services",15726,27997]
["81","Pennsylvania","Other services, except government",15740,35973]
["1","Rhode Island","All industry total",55650,28387]
["10","Rhode Island","Utilities",615,39]
["11","Rhode Island","All construction",2195,3039]
["11.1","Rhode Island","Commercial Construction",329.94257089001803,123]
["12","Rhode Island","All manufacturing",4631,1397]
["16","Rhode Island","Primary metals manufacturing",173,50]
["3","Rhode Island","Agriculture, forestry, fishing, and hunting",104,38]
["32","Rhode Island","Chemical products manufacturing",931,54]
["34","Rhode Island","Wholesale trade",3272,1328]
["35","Rhode Island","Retail trade",3145,3748]
["36","Rhode Island","Transportation and warehousing",875,647]
["6","Rhode Island","Mining",56,19]
["67","Rhode Island","Waste management and remediation",177,104]
["7","Rhode Island","Oil and gas extraction",1,1]
["70","Rhode Island","Health care and social assistance",5663,3260]
["78","Rhode Island","Accommodation and food services",1863,3053]
["81","Rhode Island","Other services, except government",1216,2891]
["1","South Carolina","All industry total",201831,103973]
["10","South Carolina","Utilities",4539,344]
["11","South Carolina","All construction",9675,9082]
["11.1","South Carolina","Commercial Construction",1454.302675790854,499]
["12","South Carolina","All manufacturing",34824,3750]
["16","South Carolina","Primary metals manufacturing",997,69]
["3","South Carolina","Agriculture, forestry, fishing, and hunting",982,510]
["32","South Carolina","Chemical products manufacturing",5014,248]
["34","South Carolina","Wholesale trade",11680,4915]
["35","South Carolina","Retail trade",14253,17599]
["36","South Carolina","Transportation and warehousing",4801,2628]
["6","South Carolina","Mining",351,80]
["67","South Carolina","Waste management and remediation",1386,376]
["70","South Carolina","Health care and social assistance",13327,10147]
["78","South Carolina","Accommodation and food services",8224,10219]
["81","South Carolina","Other services, except government",4992,11274]
["1","South Dakota","All industry total",47073,26511]
["10","South Dakota","Utilities",763,157]
["11","South Dakota","All construction",1984,3363]
["11.1","South Dakota","Commercial Construction",298.22599573840353,235]
["12","South Dakota","All manufacturing",4496,1038]
["16","South Dakota","Primary metals manufacturing",55,11]
["3","South Dakota","Agriculture, forestry, fishing, and hunting",3719,148]
["32","South Dakota","Chemical products manufacturing",608,43]
["34","South Dakota","Wholesale trade",3414,1507]
["35","South Dakota","Retail trade",3528,3941]
["36","South Dakota","Transportation and warehousing",1128,1190]
["6","South Dakota","Mining",174,69]
["67","South Dakota","Waste management and remediation",70,115]
["7","South Dakota","Oil and gas extraction",21,6]
["70","South Dakota","Health care and social assistance",4176,2322]
["78","South Dakota","Accommodation and food services",1462,2421]
["81","South Dakota","Other services, except government",1014,2732]
["1","Tennessee","All industry total",316659,133344]
["10","Tennessee","Utilities",1806,140]
["11","Tennessee","All construction",12044,9464]
["11.1","Tennessee","Commercial Construction",1810.4001475168006,616]
["12","Tennessee","All manufacturing",51937,5645]
["16","Tennessee","Primary metals manufacturing",1457,104]
["3","Tennessee","Agriculture, forestry, fishing, and hunting",1576,240]
["32","Tennessee","Chemical products manufacturing",6667,255]
["34","Tennessee","Wholesale trade",22104,6779]
["35","Tennessee","Retail trade",22260,22643]
["36","Tennessee","Transportation and warehousing",14523,4146]
["6","Tennessee","Mining",901,192]
["67","Tennessee","Waste management and remediation",887,469]
["7","Tennessee","Oil and gas extraction",14,12]
["70","Tennessee","Health care and social assistance",30534,15543]
["78","Tennessee","Accommodation and food services",10416,12509]
["81","Tennessee","Other services, except government",7917,14138]
["1","Texas","All industry total",1611189,569091]
["10","Texas","Utilities",35021,1975]
["11","Texas","All construction",86935,42030]
["11.1","Texas","Commercial Construction",13067.679909031307,3186]
["12","Texas","All manufacturing",230514,19759]
["16","Texas","Primary metals manufacturing",3145,294]
["3","Texas","Agriculture, forestry, fishing, and hunting",10939,1058]
["32","Texas","Chemical products manufacturing",55530,1112]
["34","Texas","Wholesale trade",132670,33380]
["35","Texas","Retail trade",94472,80298]
["36","Texas","Transportation and warehousing",54617,19139]
["6","Texas","Mining",148942,8871]
["67","Texas","Waste management and remediation",4302,1690]
["7","Texas","Oil and gas extraction",117401,3192]
["70","Texas","Health care and social assistance",90770,66152]
["78","Texas","Accommodation and food services",46404,52086]
["81","Texas","Other services, except government",33127,50484]
["1","Utah","All industry total",149099,75463]
["10","Utah","Utilities",1600,221]
["11","Utah","All construction",8957,8855]
["11.1","Utah","Commercial Construction",1346.3761309621375,438]
["12","Utah","All manufacturing",17068,3286]
["16","Utah","Primary metals manufacturing",1183,58]
["3","Utah","Agriculture, forestry, fishing, and hunting",829,93]
["32","Utah","Chemical products manufacturing",1803,158]
["34","Utah","Wholesale trade",7547,3702]
["35","Utah","Retail trade",10302,9546]
["36","Utah","Transportation and warehousing",5184,2305]
["6","Utah","Mining",3089,475]
["67","Utah","Waste management and remediation",289,202]
["7","Utah","Oil and gas extraction",961,60]
["70","Utah","Health care and social assistance",8286,7774]
["78","Utah","Accommodation and food services",3560,5505]
["81","Utah","Other services, except government",4219,4909]
["1","Vermont","All industry total",30300,21121]
["10","Vermont","Utilities",679,59]
["11","Vermont","All construction",1123,2701]
["11.1","Vermont","Commercial Construction",168.80433125717096,84]
["12","Vermont","All manufacturing",2864,1000]
["16","Vermont","Primary metals manufacturing",19,4]
["3","Vermont","Agriculture, forestry, fishing, and hunting",355,142]
["32","Vermont","Chemical products manufacturing",174,34]
["34","Vermont","Wholesale trade",1519,824]
["35","Vermont","Retail trade",2315,3351]
["36","Vermont","Transportation and warehousing",517,485]
["6","Vermont","Mining",269,45]
["67","Vermont","Waste management and remediation",106,96]
["70","Vermont","Health care and social assistance",3167,2103]
["78","Vermont","Accommodation and food services",1456,1951]
["81","Vermont","Other services, except government",747,2021]
["1","Virginia","All industry total",481721,197384]
["10","Virginia","Utilities",5760,334]
["11","Virginia","All construction",20097,19389]
["11.1","Virginia","Commercial Construction",3020.8910465497461,994]
["12","Virginia","All manufacturing",43250,4984]
["16","Virginia","Primary metals manufacturing",508,46]
["3","Virginia","Agriculture, forestry, fishing, and hunting",1609,676]
["32","Virginia","Chemical products manufacturing",4159,169]
["34","Virginia","Wholesale trade",20218,7073]
["35","Virginia","Retail trade",25686,27188]
["36","Virginia","Transportation and warehousing",12500,4888]
["6","Virginia","Mining",1711,299]
["67","Virginia","Waste management and remediation",773,555]
["7","Virginia","Oil and gas extraction",126,22]
["70","Virginia","Health care and social assistance",29807,19646]
["78","Virginia","Accommodation and food services",11888,17398]
["81","Virginia","Other services, except government",12460,21669]
["1","Washington","All industry total",446417,182913]
["10","Washington","Utilities",3715,297]
["11","Washington","All construction",18877,21374]
["11.1","Washington","Commercial Construction",2837.5061096541554,853]
["12","Washington","All manufacturing",58681,7021]
["16","Washington","Primary metals manufacturing",890,81]
["3","Washington","Agriculture, forestry, fishing, and hunting",7489,1414]
["32","Washington","Chemical products manufacturing",1552,227]
["34","Washington","Wholesale trade",24851,9283]
["35","Washington","Retail trade",33915,21778]
["36","Washington","Transportation and warehousing",12584,5177]
["6","Washington","Mining",545,183]
["67","Washington","Waste management and remediation",2416,517]
["7","Washington","Oil and gas extraction",5,9]
["70","Washington","Health care and social assistance",27851,20534]
["78","Washington","Accommodation and food services",12112,16704]
["81","Washington","Other services, except government",9018,17155]
["1","West Virginia","All industry total",73384,36993]
["10","West Virginia","Utilities",1954,238]
["11","West Virginia","All construction",4017,3154]
["11.1","West Virginia","Commercial Construction",603.81745205703987,176]
["12","West Virginia","All manufacturing",7549,1196]
["16","West Virginia","Primary metals manufacturing",691,28]
["3","West Virginia","Agriculture, forestry, fishing, and hunting",311,272]
["32","West Virginia","Chemical products manufacturing",3054,73]
["34","West Virginia","Wholesale trade",3436,1486]
["35","West Virginia","Retail trade",5044,6150]
["36","West Virginia","Transportation and warehousing",2211,1196]
["6","West Virginia","Mining",8925,623]
["67","West Virginia","Waste management and remediation",222,189]
["7","West Virginia","Oil and gas extraction",2940,176]
["70","West Virginia","Health care and social assistance",7029,4878]
["78","West Virginia","Accommodation and food services",2460,3555]
["81","West Virginia","Other services, except government",1520,4354]
["1","Wisconsin","All industry total",301587,139500]
["10","Wisconsin","Utilities",5207,306]
["11","Wisconsin","All construction",12176,13521]
["11.1","Wisconsin","Commercial Construction",1830.2417964268154,567]
["12","Wisconsin","All manufacturing",57059,8821]
["16","Wisconsin","Primary metals manufacturing",1874,174]
["3","Wisconsin","Agriculture, forestry, fishing, and hunting",4930,553]
["32","Wisconsin","Chemical products manufacturing",4607,340]
["34","Wisconsin","Wholesale trade",17997,6987]
["35","Wisconsin","Retail trade",17858,19114]
["36","Wisconsin","Transportation and warehousing",8889,5415]
["6","Wisconsin","Mining",1359,177]
["67","Wisconsin","Waste management and remediation",600,564]
["7","Wisconsin","Oil and gas extraction",3,3]
["70","Wisconsin","Health care and social assistance",25799,15253]
["78","Wisconsin","Accommodation and food services",7104,14462]
["81","Wisconsin","Other services, except government",6615,14566]
["1","Wyoming","All industry total",39415,21040]
["10","Wyoming","Utilities",923,131]
["11","Wyoming","All construction",2325,2665]
["11.1","Wyoming","Commercial Construction",349.48358875594164,120]
["12","Wyoming","All manufacturing",2264,575]
["16","Wyoming","Primary metals manufacturing",8,11]
["3","Wyoming","Agriculture, forestry, fishing, and hunting",611,90]
["32","Wyoming","Chemical products manufacturing",618,35]
["34","Wyoming","Wholesale trade",1788,844]
["35","Wyoming","Retail trade",2195,2640]
["36","Wyoming","Transportation and warehousing",2862,964]
["6","Wyoming","Mining",8657,812]
["67","Wyoming","Waste management and remediation",95,111]
["7","Wyoming","Oil and gas extraction",3269,167]
["70","Wyoming","Health care and social assistance",1593,1956]
["78","Wyoming","Accommodation and food services",1255,1841]
["81","Wyoming","Other services, except government",641,1809]

{"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,"industry_list_2",null,"New States List"]
["TM",{"$f":"IF(state_tm=\"United States\",1,0)","v":0},{"$f":"state_tm","v":0},{"$f":"IF(OR(C2=$A$7,C2=$A$8,C2=$A$9,C2=$A$10),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=$A$7,C3=$A$8,C3=$A$9,C3=$A$10),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=$A$7,C4=$A$8,C4=$A$9,C4=$A$10),1,0)","v":0},null,null,null,"----------------------------------------------------",null,"Alaska"]
[null,null,null,null,null,null,null,"All industry total",null,"Arizona"]
["Regions needing a \"the\"",null,null,null,null,null,null,"Mining",null,"Arkansas"]
["District of Columbia",null,null,null,null,null,null,"Oil and gas extraction",null,"California"]
["United States",null,null,null,null,null,null,"Utilities",null,"Colorado"]
["Northern Mariana Islands",null,null,null,null,null,null,"Waste management and remediation",null,"Connecticut"]
["U.S. Virgin Islands",null,null,null,null,null,null,"All construction",null,"Delaware"]
[null,null,null,null,null,null,null,"All manufacturing",null,"District of Columbia"]
["default_time_tt",3.5,null,null,null,null,null,"Primary metals manufacturing",null,"Florida"]
["default_wage_tt",48.48,null,null,null,null,null,"Chemical products manufacturing",null,"Georgia"]
["default_period_tt",52,null,null,null,null,null,"Wholesale trade",null,"Hawaii"]
["default_time_rr",0.17,null,null,null,null,null,"Retail trade",null,"Idaho"]
["default_wage_rr",17.809999999999999,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"]
["BEA code","State","Industry","GDP (mil $)","Establishments",null,null,"Agriculture, forestry, fishing, and hunting",null,"Kansas"]
["7","Connecticut","Oil and gas extraction",0,5,null,null,"Other services, except government",null,"Kentucky"]
["7","Delaware","Oil and gas extraction",0,4,null,null,null,null,"Louisiana"]
["3","District of Columbia","Agriculture, forestry, fishing, and hunting",null,1,null,null,"No_Oil_Industries",null,"Maine"]
["6","District of Columbia","Mining",0,5,null,null,null,null,"Maryland"]
["7","District of Columbia","Oil and gas extraction",0,4,null,null,"Commercial construction",null,"Massachusetts"]
["7","Georgia","Oil and gas extraction",0,5,null,null,"----------------------------------------------------",null,"Michigan"]
["7","Iowa","Oil and gas extraction",0,2,null,null,"All industry total",null,"Minnesota"]
["7","New Hampshire","Oil and gas extraction",0,2,null,null,"Mining",null,"Mississippi"]
[null,null,null,null,null,null,null,"Utilities",null,"Missouri"]
[null,null,null,null,null,null,null,"Waste management and remediation",null,"Montana"]
[null,null,null,null,null,null,null,"All construction",null,"Nebraska"]
[null,null,null,null,null,null,null,"All manufacturing",null,"Nevada"]
["No_Oil_Industries",{"$f":"MAX(B33:B41)","v":0},null,null,null,null,null,"Primary metals manufacturing",null,"New Hampshire"]
["Connecticut",{"$f":"IF(state_tm=A33,1,0)","v":0},null,null,null,null,null,"Chemical products manufacturing",null,"New Jersey"]
["Delaware",{"$f":"IF(state_tm=A34,1,0)","v":0},null,null,null,null,null,"Wholesale trade",null,"New Mexico"]
["Georgia",{"$f":"IF(state_tm=A35,1,0)","v":0},null,null,null,null,null,"Retail trade",null,"New York"]
["Iowa",{"$f":"IF(state_tm=A36,1,0)","v":0},null,null,null,null,null,"Transportation and warehousing",null,"North Carolina"]
["New Hampshire",{"$f":"IF(state_tm=A37,1,0)","v":0},null,null,null,null,null,"Health care and social assistance",null,"North Dakota"]
["Maine",{"$f":"IF(state_tm=A38,1,0)","v":0},null,null,null,null,null,"Accommodation and food services",null,"Ohio"]
["New Jersey",{"$f":"IF(state_tm=A39,1,0)","v":0},null,null,null,null,null,"Agriculture, forestry, fishing, and hunting",null,"Oklahoma"]
["South Carolina",{"$f":"IF(state_tm=A40,1,0)","v":0},null,null,null,null,null,"Other services, except government",null,"Oregon"]
["Vermont",{"$f":"IF(state_tm=A41,1,0)","v":0},null,null,null,null,null,null,null,"Pennsylvania"]
[null,null,null,null,null,null,null,"DC_Industries",null,"Rhode Island"]
[null,null,null,null,null,null,null,null,null,"South Carolina"]
["DC_Industries",{"$f":"B45","v":0},null,null,null,null,null,"Commercial construction",null,"South Dakota"]
["District of Columbia",{"$f":"IF(state_tm=A45,1,0)","v":0},null,null,null,null,null,"----------------------------------------------------",null,"Tennessee"]
[null,null,null,null,null,null,null,"All industry total",null,"Texas"]
[null,null,null,null,null,null,null,"Utilities",null,"Utah"]
[null,null,null,null,null,null,null,"Waste management and remediation",null,"Vermont"]
[null,null,null,null,null,null,null,"All construction",null,"Virginia"]
[null,null,null,null,null,null,null,"All manufacturing",null,"Washington"]
[null,null,null,null,null,null,null,"Chemical products manufacturing",null,"West Virginia"]
[null,null,null,null,null,null,null,"Wholesale trade",null,"Wisconsin"]
[null,null,null,null,null,null,null,"Retail trade",null,"Wyoming"]
[null,null,null,null,null,null,null,"Transportation and warehousing",null,"American Samoa"]
[null,null,null,null,null,null,null,"Health care and social assistance",null,"Guam"]
[null,null,null,null,null,null,null,"Accommodation and food services",null,"Northern Mariana Islands"]
[null,null,null,null,null,null,null,"Other services, except government",null,"Puerto Rico"]
[null,null,null,null,null,null,null,null,null,"U.S. Virgin Islands"]