{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Metro BLS Data Capture","U.S. BLS Data Capture","Trend Analysis","ESRI_MAPINFO_SHEET"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"Metro BLS Data Capture","index":0,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,1,3,5],[4,0,4,5],[10,1,10,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5]]}
["State and Area Employment, Hours, and Earnings"]
["Original Data Value"]
[]
["Series Id:","SMU48191240000000001"]
["Not Seasonally Adjusted"]
["State:","Texas"]
["Area:","Dallas-Plano-Irving, TX Metropolitan Division"]
["Supersector:","Total Nonfarm"]
["Industry:","Total Nonfarm"]
["Data Type:","All Employees, In Thousands"]
["Years:","2011 to 2021"]
[]
["Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual"]
[2011,2057.1,2066.4,2084.6,2099.1999999999998,2106,2114,2103,2109.6999999999998,2119.4,2129.1,2135.6999999999998,2139.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B14:N14)","v":2105.3166666666666},{"$f":"AVERAGE(B14:N14)","v":2105.3166666666666}]
[2012,2104.5,2120.8000000000002,2136.5,2148,2161.3000000000002,2169.6,2147.9,2160.8000000000002,2167.4,2183.1999999999998,2198.5,2201.8000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2158.3583333333331,{"$f":"AVERAGE(B15:N15)","v":2158.3583333333331}]
[2013,2155.4,2174.6999999999998,2189.1,2200.6999999999998,2214.3000000000002,2229.4,2220.4,2235.3000000000002,2241.4,2257.9,2278.1,2278.1999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2222.9083333333333,2222.9083333333333]
[2014,2242.4,2258,2272.4,2290.5,2304.5,2317.9,2308.3000000000002,2322,2328,2351.6999999999998,2369.6999999999998,2379.3000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2312.0583333333334,2312.0583333333334]
[2015,2343.9,2362.6,2367.1999999999998,2388.4,2401.6,2417.1999999999998,2413.5,2422.1,2425.4,2448.3000000000002,2459.8000000000002,2467.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2409.7583333333332,2409.7583333333332]
[2016,2438.4,2457.5,2461.5,2482.4,2493.1,2499.6999999999998,2495.1999999999998,2506.4,2517.5,2535.3000000000002,2552.3000000000002,2558.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2499.7833333333333,2499.7833333333333]
[2017,2517.6,2534.4,2540.6999999999998,2552.6,2562.9,2574.3000000000002,2555.6999999999998,2565.4,2572.4,2595.8000000000002,2616.5,2615.3000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2566.9666666666667,2566.9666666666667]
[2018,2570.3000000000002,2587.6999999999998,2594.1,2600.9,2616.9,2631.9,2620.5,2631.8,2633,2656.5,2678.6,2680.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2625.2333333333331,2625.2333333333331]
[2019,2634.2,2650.8,2655.9,2672.3,2687.4,2699.6,2696,2708.5,2709.2,2740,2763.2,2762.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2698.2666666666669,2698.2666666666669]
[2020,2720.8,2735.4,2718.7,2436.1999999999998,2495.6,2548.4,2552.6999999999998,2583.9,2599.5,2636.4,2656.9,2677.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2613.4666666666667,2613.4666666666667]
[2021,2640.9,2641.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2641.3,2641.3]

{"sheet":"U.S. BLS Data Capture","index":1,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,1,3,5],[4,0,4,5],[10,1,10,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5]]}
["Employment, Hours, and Earnings from the Current Employment Statistics survey (National)"]
["Original Data Value"]
[]
["Series Id:","CES0000000001"]
["Seasonally Adjusted"]
["Series Title:","All employees, thousands, total nonfarm, seasonally adjusted"]
["Super Sector:","Total nonfarm"]
["Industry:","Total nonfarm"]
["NAICS Code:","-"]
["Data Type:","ALL EMPLOYEES, THOUSANDS"]
["Years:","2011 to 2021"]
[]
["Year","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual"]
[2011,130841,131053,131288,131602,131703,131939,131999,132125,132358,132562,132694,132896,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B14:N14)","v":131921.66666666666},{"$f":"AVERAGE(B14:N14)","v":131921.66666666666}]
[2012,133250,133512,133752,133834,133934,134007,134159,134331,134518,134677,134833,135072,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134156.58333333334,134156.58333333334]
[2013,135263,135541,135680,135871,136093,136274,136386,136628,136815,137040,137304,137373,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136355.66666666666,136355.66666666666]
[2014,137548,137714,137968,138293,138511,138837,139069,139257,139566,139818,140109,140377,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138922.25,138922.25]
[2015,140568,140839,140910,141194,141525,141699,142001,142126,142281,142587,142824,143097,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141804.25,141804.25]
[2016,143205,143417,143654,143851,143892,144150,144521,144664,144953,145071,145201,145415,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144332.83333333334,144332.83333333334]
[2017,145612,145795,145934,146154,146295,146506,146734,146924,146966,147215,147411,147590,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146594.66666666666,146594.66666666666]
[2018,147671,148049,148244,148397,148667,148881,149030,149259,149364,149576,149668,149908,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148892.83333333334,148892.83333333334]
[2019,150145,150095,150263,150482,150545,150720,150913,151108,151329,151524,151758,151919,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150900.08333333334,150900.08333333334]
[2020,152234,152523,150840,130161,132994,137840,139566,141149,141865,142545,142809,142503,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142252.41666666666,142252.41666666666]
[2021,142736,143204,144120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143353.33333333334,143353.33333333334]

{"sheet":"Trend Analysis","index":2,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Employment Trend Analysis"]
[]
[null,{"$f":"'Metro BLS Data Capture'!B7","v":"Dallas-Plano-Irving, TX Metropolitan Division"}]
[]
[null,"10-Year Annual Employment Change (x 1,000)"]
[]
[null,"Year","U.S. Emp.","Metro Emp.","U.S. % Chg.","Metro % Chg."]
[null,{"$f":"'U.S. BLS Data Capture'!A14","v":2011},{"$f":"'U.S. BLS Data Capture'!AC14","v":131921.66666666666},{"$f":"'Metro BLS Data Capture'!AC14","v":2105.3166666666666}]
[null,{"$f":"'U.S. BLS Data Capture'!A15","v":2012},{"$f":"'U.S. BLS Data Capture'!AC15","v":134156.58333333334},{"$f":"'Metro BLS Data Capture'!AC15","v":2158.3583333333331},{"$f":"(C10-C9)/C9","v":1.6941240382550397E-2},{"$f":"(D10-D9)/D9","v":2.5194151315320663E-2}]
[null,{"$f":"'U.S. BLS Data Capture'!A16","v":2013},{"$f":"'U.S. BLS Data Capture'!AC16","v":136355.66666666666},{"$f":"'Metro BLS Data Capture'!AC16","v":2222.9083333333333},1.6391915168779619E-2,2.990698949433027E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A17","v":2014},{"$f":"'U.S. BLS Data Capture'!AC17","v":138922.25},{"$f":"'Metro BLS Data Capture'!AC17","v":2312.0583333333334},1.8822711194009856E-2,4.0105117544958033E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A18","v":2015},{"$f":"'U.S. BLS Data Capture'!AC18","v":141804.25},{"$f":"'Metro BLS Data Capture'!AC18","v":2409.7583333333332},2.0745416950848406E-2,4.2256719301343962E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A19","v":2016},{"$f":"'U.S. BLS Data Capture'!AC19","v":144332.83333333334},{"$f":"'Metro BLS Data Capture'!AC19","v":2499.7833333333333},1.7831505990358845E-2,3.735851797033593E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A20","v":2017},{"$f":"'U.S. BLS Data Capture'!AC20","v":146594.66666666666},{"$f":"'Metro BLS Data Capture'!AC20","v":2566.9666666666667},1.5670954980213422E-2,2.6875662557421669E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A21","v":2018},{"$f":"'U.S. BLS Data Capture'!AC21","v":148892.83333333334},{"$f":"'Metro BLS Data Capture'!AC21","v":2625.2333333333331},1.567701417059297E-2,2.269864561285035E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A22","v":2019},{"$f":"'U.S. BLS Data Capture'!AC22","v":150900.08333333334},{"$f":"'Metro BLS Data Capture'!AC22","v":2698.2666666666669},1.3481172700275476E-2,2.7819749355612999E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A23","v":2020},{"$f":"'U.S. BLS Data Capture'!AC23","v":142252.41666666666},{"$f":"'Metro BLS Data Capture'!AC23","v":2613.4666666666667},-5.7307235858606344E-2,-3.1427583139793512E-2]
[null,{"$f":"'U.S. BLS Data Capture'!A24","v":2021},{"$f":"'U.S. BLS Data Capture'!AC24","v":143353.33333333334},{"$f":"'Metro BLS Data Capture'!AC24","v":2641.3},7.7391772488928038E-3,1.0649966838426669E-2]
[]
[null,null,null,"10-Year Growth Rate ",{"$f":"RATE(10,0,-C9,C19)","v":8.3450406485162248E-3},{"$f":"RATE(10,0,-D9,D19)","v":2.2939691756973777E-2}]
[null,null,null,"Standard Deviation ",{"$f":"STDEV(E10:E19)","v":2.3418746157827044E-2},{"$f":"STDEV(F10:F19)","v":2.1278873311130691E-2}]
[]
[]
[]
[null,"Year-to-Date Monthly Employment Change (x 1,000)"]
[]
[null,"Current Year","U.S. Emp.","Metro Emp.","U.S. % Chg.","Metro % Chg."]
[null,"Dec",{"$f":"IF('U.S. BLS Data Capture'!$M$23>0,'U.S. BLS Data Capture'!$M$23,0)","v":142503},{"$f":"IF('Metro BLS Data Capture'!M23>0,'Metro BLS Data Capture'!M23,0)","v":2677.1}]
[null,"Jan",{"$f":"IF('U.S. BLS Data Capture'!$B$24>0,'U.S. BLS Data Capture'!$B$24,0)","v":142736},{"$f":"IF('Metro BLS Data Capture'!B24>0,'Metro BLS Data Capture'!B24,0)","v":2640.9},{"$f":"IF(C30>0,(C30-C29)/C29,\" \")","v":1.6350532971235693E-3},{"$f":"IF(D30>0,(D30-D29)/D29,\" \")","v":-1.3522094804078974E-2}]
[null,"Feb",{"$f":"IF('U.S. BLS Data Capture'!$C$24>0,'U.S. BLS Data Capture'!$C$24,0)","v":143204},{"$f":"IF('Metro BLS Data Capture'!C24>0,'Metro BLS Data Capture'!C24,0)","v":2641.7},3.2787804057841049E-3,3.0292703245095504E-4]
[null,"Mar",{"$f":"IF('U.S. BLS Data Capture'!$D$24>0,'U.S. BLS Data Capture'!$D$24,0)","v":144120},{"$f":"IF('Metro BLS Data Capture'!D24>0,'Metro BLS Data Capture'!D24,0)","v":0},6.3964693723639002E-3," "]
[null,"Apr",{"$f":"IF('U.S. BLS Data Capture'!$E$24>0,'U.S. BLS Data Capture'!$E$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!E24>0,'Metro BLS Data Capture'!E24,0)","v":0}," "," "]
[null,"May",{"$f":"IF('U.S. BLS Data Capture'!$F$24>0,'U.S. BLS Data Capture'!$F$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!F24>0,'Metro BLS Data Capture'!F24,0)","v":0}," "," "]
[null,"June",{"$f":"IF('Metro BLS Data Capture'!G24>0,'U.S. BLS Data Capture'!$G$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!G24>0,'Metro BLS Data Capture'!G24,0)","v":0}," "," "]
[null,"July",{"$f":"IF('U.S. BLS Data Capture'!$H$24>0,'U.S. BLS Data Capture'!$H$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!H24>0,'Metro BLS Data Capture'!H24,0)","v":0}," "," "]
[null,"Aug",{"$f":"IF('U.S. BLS Data Capture'!$I$24>0,'U.S. BLS Data Capture'!$I$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!I24>0,'Metro BLS Data Capture'!I24,0)","v":0}," "," "]
[null,"Sep",{"$f":"IF('U.S. BLS Data Capture'!$J$24>0,'U.S. BLS Data Capture'!$J$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!J24>0,'Metro BLS Data Capture'!J24,0)","v":0}," "," "]
[null,"Oct",{"$f":"IF('U.S. BLS Data Capture'!$K$24>0,'U.S. BLS Data Capture'!$K$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!K24>0,'Metro BLS Data Capture'!K24,0)","v":0}," "," "]
[null,"Nov",{"$f":"IF('U.S. BLS Data Capture'!$L$24>0,'U.S. BLS Data Capture'!$L$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!L24>0,'Metro BLS Data Capture'!L24,0)","v":0}," "," "]
[null,"Dec",{"$f":"IF('U.S. BLS Data Capture'!$M$24>0,'U.S. BLS Data Capture'!$M$24,0)","v":0},{"$f":"IF('Metro BLS Data Capture'!M24>0,'Metro BLS Data Capture'!M24,0)","v":0}," "," "]

{"sheet":"ESRI_MAPINFO_SHEET","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}