{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Table 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Table 2","index":0,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[38,0,38,14],[2,1,2,14]],"flags":["formulas_cached_only"]}
["Table x  Average public school teacher salary by locale grouping and years of experience, School year 2006-07"]
[]
[null,"  Locale grouping"]
["Years of experience","Total",null,"Large city",null,"Midsize city",null,"Fringe of large city",null,"Fringe of mid-size city",null,"Large town","Small town","Rural, outside metro area","Rural, inside metro area"]
["All teachers",40140,null,41306,5,42037,44284,44284,40069,40241,null,40069,38343,34856,37782]
[]
["Less than 1 year",26342,null,28674,null,27132,null,28339,null,25323,null,26114,24588,23411,24618]
["1 year",26868.84,null,29247.48,null,27674.64,null,28905.78,null,25829.46,null,26636.28,25079.760000000002,23879.22,25110.36]
["2 years",27406.216800000002,null,29832.4296,null,28228.1328,null,29483.8956,null,26346.0492,null,27169.0056,25581.3552,24356.8044,25612.5672]
["3 years",27954.341136000003,null,30429.078192,null,28792.695456,null,30073.573512,null,26872.970184,null,27712.385712,26092.982304,24843.940488,26124.818544]
["4 years",28513.427958720004,null,31037.659755840003,null,29368.54936512,null,30675.04498224,null,27410.429587680002,null,28266.63342624,26614.84195008,25340.81929776,26647.31491488]
[]
["5 years",29169.23680177056,null,31751.52593022432,null,30044.02600051776,null,31380.571016831516,null,28040.86946819664,null,28916.76599504352,27226.98331493184,25923.658141608477,27260.20315792224]
["6 years",29752.62153780597,null,32386.556448828807,null,30644.906520528115,null,32008.182437168147,null,28601.686857560573,null,29495.10131494439,27771.52298123048,26442.13130444065,27805.407221080684]
["7 years",30347.673968562092,null,33034.287577805386,null,31257.804650938677,null,32648.34608591151,null,29173.720594711784,null,30085.00334124328,28326.95344085509,26970.97393052946,28361.5153655023]
["8 years",30954.627447933333,null,33694.97332936149,null,31882.96074395745,null,33301.31300762974,null,29757.19500660602,null,30686.703408068144,28893.492509672193,27510.39340914005,28928.745672812343]
["9 years",31573.719996892,null,34368.87279594872,null,32520.6199588366,null,33967.339267782336,null,30352.33890673814,null,31300.43747622951,29471.362359865638,28060.601277322854,29507.32058626859]
[]
["10 years",32299.915556820513,null,35159.35687025554,null,33268.59421788984,null,34748.588070941325,null,31050.442701593114,null,32020.347538182785,30149.203694142543,28705.995106701277,30185.988959752765]
["11 yers",32945.91386795692,null,35862.544007660654,null,33933.966102247636,null,35443.55983236015,null,31671.451555624975,null,32660.75448894644,30752.187768025393,29280.115008835302,30789.708738947822]
["12 years",33604.83214531606,null,36579.79488781387,null,34612.64542429259,null,36152.431029007355,null,32304.880586737476,null,33313.96957872537,31367.2315233859,29865.71730901201,31405.502913726777]
["13 years",34276.92878822238,null,37311.39078557015,null,35304.898332778444,null,36875.479649587505,null,32950.97819847223,null,33980.24897029988,31994.57615385362,30463.031655192248,32033.612972001312]
["14 years",34962.46736398683,null,38057.61860128155,null,36010.99629943402,null,37612.98924257926,null,33609.99776244167,null,34659.85394970588,32634.467676930693,31072.292288296092,32674.28523144134]
[]
["15 years",35766.604113358524,null,38932.94382911103,null,36839.249214321,null,38478.087995158574,null,34383.027710977825,null,35457.03059054911,33385.0604335001,31786.9550109269,33425.79379176449]
["16 years",36481.9361956257,null,39711.60270569325,null,37576.03419860742,null,39247.64975506175,null,35070.68826519738,null,36166.17120236009,34052.7616421701,32422.69411114544,34094.30966759978]
["17 years ",37211.574919538216,null,40505.83475980712,null,38327.55488257957,null,40032.60275016299,null,35772.10203050133,null,36889.49462640729,34733.81687501351,33071.14799336835,34776.195860951775]
["18 years",37955.80641792898,null,41315.95145500326,null,39094.105980231165,null,40833.254805166245,null,36487.544071111355,null,37627.28451893544,35428.49321251378,33732.57095323572,35471.71977817081]
["19 years",38714.92254628756,null,42142.27048410333,null,39875.98809983579,null,41649.91990126957,null,37217.294952533586,null,38379.830209314154,36137.063076764054,34407.222372300435,36181.15417373423]
[]
["20 years ",39605.36576485217,null,43111.5427052377,null,40793.13582613201,null,42607.86805899876,null,38073.29273644186,null,39262.56630412838,36968.215527529625,35198.588486863344,37013.32071973011]
["21 to 24 years",40397.47308014921,null,43973.77355934245,null,41608.998542654655,null,43460.02542017874,null,38834.75859117069,null,40047.81763021094,37707.579838080215,35902.56025660061,37753.58713412471]
["25 years ",41205.422541752196,null,44853.2490305293,null,42441.17851350775,null,44329.22592858232,null,39611.453762994104,null,40848.77398281516,38461.73143484182,36620.611461732624,38508.6588768072]
["26 to 29 years",42029.53099258724,null,45750.31401113989,null,43290.00208377791,null,45215.81044715396,null,40403.68283825399,null,41665.74946247147,39230.96606353866,37353.023690967275,39278.83205434335]
["30 years",42870.12161243899,null,46665.32029136269,null,44155.80212545347,null,46120.12665609704,null,41211.75649501907,null,42499.0644517209,40015.585384809434,38100.08416478662,40064.40869543022]
["More than 30 years",43727.52404468777,null,47598.626697189946,null,45038.91816796254,null,47042.52918921898,null,42035.99162491946,null,43349.04574075532,40815.89709250562,38862.08584808235,40865.696869338826]
[]
["Note: Fake table.  Data are made up."]
["SOURCE: U.S. Department of Education, National Center for Education Statistics, Common Core of Data (CCD), \"Teacher Compensation Survey,\" School year 2006-07, Version 1a."]