{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title","Country","ByState","ByCounty","Category","ByZipCode","PivotMap","Wrap Up"],"not_rendered":{"charts":6,"images":6,"macros":0,"external_links":1,"defined_names":43,"comments":0,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2061]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: pixel2013 / Pixabay"]

{"sheet":"Country","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Country","Oranges"]
[" Brazil",18279309]
[" China",2865000]
[" United States",7357000]
[" Mexico",4160000]
[" India",3900000]
[" Spain",2691400]
[" Iran",2300000]
[" Italy",2293466]
[" Turkey",1472454]

{"sheet":"ByState","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["State","Mileage"]
["Florida",186]
["Georgia",118]
["North Carolina",118]
["South Carolina",{"$f":"80+60+60","v":200}]
["Virginia",51]
["West Virginia",181]
["Ohio",118]

{"sheet":"ByCounty","index":3,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["County","Population","Seat","Established","Etymology","Density","Area"]
["Alachua",249365,"Gainesville",1824,"From a Seminole-Creek word meaning \"jug\", apparently in reference to the sinkholes common in the area",285.31,874]
["Baker",27154,"Macclenny",1861,"James McNair Baker (1821–1892), a Confederate senator and later a judge in the fourth judicial district",46.42,585]
["Bay",169856,"Panama City",1913,"St. Andrew's Bay, the central geographic feature of the county",222.32,764]
["Bradford",28255,"Starke",1858,"Richard Bradford, the first officer from Florida to die in the Civil War; he was killed during the Battle of Santa Rosa Island",96.43,293]
["Brevard",543566,"Titusville",1844,"Theodore Washington Brevard, early settler and later state comptroller from 1853 to 1861",533.95000000000005,1018]
["Broward",1780172,"Fort Lauderdale",1915,"Napoleon Bonaparte Broward (1857–1910), 19th Governor of Florida from 1905 to 1909",1472.43,1209]
["Calhoun",14750,"Blountstown",1838,"John C. Calhoun (1782–1850) leading Southern politician from South Carolina",26.01,567]
["Charlotte",160511,"Punta Gorda",1921,"Probably a corruption of the name of the Calusa, a group of Native Americans from the area",231.28,694]
["Citrus",140031,"Inverness",1887,"The county's citrus trees",239.78,584]
["Clay",192370,"Green Cove Springs",1858,"Henry Clay (1777–1852), Secretary of State from 1825 to 1829 under John Quincy Adams",320.08,601]
["Collier",328134,"East Naples",1923,"Barron Collier (1873–1939), an advertising entrepreneur who developed much of the land in southern Florida",161.96,2026]
["Columbia",67485,"Lake City",1832,"Christopher Columbus (c. 1451–1506), explorer of the Americas",84.67,797]
["DeSoto",34894,"Arcadia",1887,"Hernando de Soto (c. 1496/1497–1542), a Spanish explorer and conquistador",54.78,637]
["Dixie",16486,"Cross City",1921,"Dixie, the common nickname for the Southern United States",23.42,704]
["Duval",870709,"Jacksonville",1822,"William Pope Duval (1784–1854), the first governor of the Florida Territory",1124.95,774]
["Escambia",299114,"Pensacola",1821,"Disputed origin; possibly from the Native American word Shambia, meaning \"clear water\"",450.47,664]
["Flagler",97376,"Bunnell",1917,"Henry Morrison Flagler (1830–1913), founder of the Florida East Coast Railway",200.78,485]
["Franklin",11596,"Apalachicola",1832,"Benjamin Franklin (1706–1790), one of the Founding Fathers of the United States of America",21.72,534]
["Gadsden",46151,"Quincy",1823,"James Gadsden (1788–1858), American diplomat and namesake of the Gadsden Purchase",89.44,516]
["Gilchrist",17004,"Trenton",1925,"Albert W. Gilchrist (1858–1926), the 20th Governor of Florida",48.72,349]
["Glades",12635,"Moore Haven",1921,"The Florida Everglades",16.32,774]
["Gulf",15844,"Port St. Joe",1925,"The Gulf of Mexico",28.04,565]
["Hamilton",14671,"Jasper",1827,"Alexander Hamilton (1757–1804), the first United States Secretary of the Treasury and a Founding Father",28.49,515]
["Hardee",27887,"Wauchula",1921,"Cary A. Hardee (1876–1957), governor of Florida at the time of creation of Hardee County",43.78,637]
["Hendry",39089,"LaBelle",1923,"Francis A. Hendry (1833–1917), early Floridian pioneer and politician",33.9,1153]
["Hernando",173094,"Brooksville",1843,"Hernando de Soto (c.1496/1497–1542), a Spanish explorer and conquistador",362.12,478]
["Highlands",98630,"Sebring",1921,"Named for the county's hilly terrain",95.94,1028]
["Hillsborough",1267775,"Tampa",1834,"Marquess Wills Hill, Marquess of Downshire (1718–1793), former Secretary of State for the Colonies",1206.26,1051]
["Holmes",19873,"Bonifay",1848,"Holmes Creek, which forms the eastern boundary of the county",41.23,482]
["Indian River",138894,"Vero Beach",1925,"The Indian River Lagoon, which flows through the county",276.13,503]
["Jackson",49292,"Marianna",1822,"Andrew Jackson (1767–1845), the seventh President of the United States",53.81,916]
["Jefferson",14658,"Monticello",1827,"Thomas Jefferson (1743–1826), the third President of the United States and principal author of the Declaration of Independence",24.51,598]
["Lafayette",8942,"Mayo",1856,"Gilbert du Motier, marquis de La Fayette (1757–1834), French aristocrat and general in the American Revolutionary War",16.47,543]
["Lake",301019,"Tavares",1887,"Named for the many lakes in the region",315.86,953]
["Lee",631330,"Fort Myers",1887,"Robert E. Lee (1807–1870), commander of the Confederate Army of Northern Virginia in the American Civil War",785.24,804]
["Leon",277971,"Tallahassee",1824,"Juan Ponce de León (1474–1521), Spanish explorer who named Florida",416.75,667]
["Levy",40156,"Bronson",1845,"David Levy Yulee (1810–1886), one of the state's original United States Senators",35.92,1118]
["Liberty",8314,"Bristol",1855,"The patriotic ideal of liberty",9.94,836]
["Madison",19115,"Madison",1827,"James Madison (1751–1836), fourth President of the United States",27.62,692]
["Manatee",327142,"Bradenton",1855,"The manatee, or sea cow, is native to Florida waters.",441.49,741]
["Marion",332529,"Ocala",1844,"Francis Marion (c. 1732–1795), military officer during the American Revolution",210.59,1579]
["Martin",147495,"Stuart",1925,"John W. Martin (1884–1958), governor of Florida at time of creation of the county",265.27999999999997,556]
["Miami-Dade",2662874,"Miami",1836,"City of Miami and Francis L. Dade (c. 1793–1835), Major in the United States Army during the Second Seminole War",1313.5,1946]
["Monroe",73873,"Key West",1823,"James Monroe (1758–1831), fifth President of the United States",74.099999999999994,997]
["Nassau",74195,"Fernandina Beach",1824,"Duchy of Nassau in Germany",113.8,652]
["Okaloosa",183482,"Crestview",1915,"A native word meaning \"a pleasant place,\" \"black water\", or \"beautiful place\"",196.03,936]
["Okeechobee",40140,"Okeechobee",1917,"Lake Okeechobee, which was in turn is from the Hitchiti words for \"big water\"",51.86,774]
["Orange",1169107,"Orlando",1824,"The fruit that was the county's main product",1287.56,908]
["Osceola",276163,"Kissimmee",1887,"Osceola (1804–1838), a leader of the Seminole during the Second Seminole War",208.9,1322]
["Palm Beach",1335187,"West Palm Beach",1909,"The county's large amounts of palm trees The biggest county in Florida",656.43,2034]
["Pasco",466457,"Dade City",1887,"Samuel Pasco (1834–1917), United States Senator at the time of creation of the county",626.12,745]
["Pinellas",917398,"Clearwater",1912,"From the Spanish Punta Piñal, or \"Point of Pines\"",3276.42,280]
["Polk",609492,"Bartow",1861,"James K. Polk (1795–1849), the 11th President of the United States",325.06,1875]
["Putnam",74041,"Palatka",1849,"Benjamin A. Putnam (1801–1869), soldier during the Second Seminole War and Floridian legislator",102.55,722]
["St. Johns",195823,"St. Augustine",1821,"Name derived from the St. Johns River, which in turn derives its name from San Juan del Puerto",321.55,609]
["St. Lucie",280379,"Fort Pierce",1905,"Saint Lucy (283–304), the Christian martyr",490.17,572]
["Santa Rosa",154104,"Milton",1842,"Santa Rosa Island, which is in turn named for Saint Rosa de Viterbo (1235–1252), a saint born in Viterbo, Italy",151.68,1016]
["Sarasota",382213,"Sarasota",1921,"Native American word, of uncertain meaning, for the area",668.2,572]
["Seminole",425071,"Sanford",1913,"The Seminole Native American tribe",1380.1,308]
["Sumter",97756,"Bushnell",1853,"Thomas Sumter (1734–1832), general in the American Revolution",179.04,546]
["Suwannee",41972,"Live Oak",1858,"The Suwannee River, a 266-mile long river in northern Florida",61.01,688]
["Taylor",22691,"Perry",1856,"Zachary Taylor (1784–1850), 12th President of the United States",21.78,1042]
["Union",15388,"Lake Butler",1921,"Named for the area's residents united desire to split into a separate county",64.12,240]
["Volusia",494804,"DeLand",1854,"The port of Volusia, whose etymology is uncertain; possibly derived from the Native American word for \"Land of the Euchees,\" the term for the area's native inhabitants",447.38,1106]
["Wakulla",30978,"Crawfordville",1843,"The Wakulla River, itself named for a Spanish corruption of a Timucuan word used to describe the body of water, but that is of uncertain meaning",51.03,607]
["Walton",55793,"DeFuniak Springs",1824,"George Walton, first Secretary of Florida Territory",52.73,1058]
["Washington",24935,"Chipley",1825,"George Washington (1732–1799), first President of the United States",42.99,580]

{"sheet":"Category","index":4,"n_rows":68,"n_cols":2,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["County","Type"]
["Brevard","Atlantic"]
["Broward","Atlantic"]
["Duval","Atlantic"]
["Flagler","Atlantic"]
["Indian River","Atlantic"]
["Martin","Atlantic"]
["Miami-Dade","Atlantic"]
["Monroe","Atlantic"]
["Nassau","Atlantic"]
["Palm Beach","Atlantic"]
["St. Johns","Atlantic"]
["St. Lucie","Atlantic"]
["Volusia","Atlantic"]
["Charlotte","Gulf"]
["Citrus","Gulf"]
["Collier","Gulf"]
["Dixie","Gulf"]
["Hernando","Gulf"]
["Hillsborough","Gulf"]
["Lee","Gulf"]
["Levy","Gulf"]
["Manatee","Gulf"]
["Pasco","Gulf"]
["Pinellas","Gulf"]
["Sarasota","Gulf"]
["Calhoun","Landlocked"]
["Gadsden","Landlocked"]
["Hamilton","Landlocked"]
["Holmes","Landlocked"]
["Jackson","Landlocked"]
["Lafayette","Landlocked"]
["Leon","Landlocked"]
["Liberty","Landlocked"]
["Madison","Landlocked"]
["Suwannee","Landlocked"]
["Washington","Landlocked"]
["Bay","North Gulf"]
["Escambia","North Gulf"]
["Franklin","North Gulf"]
["Gulf","North Gulf"]
["Jefferson","North Gulf"]
["Okaloosa","North Gulf"]
["Santa Rosa","North Gulf"]
["Taylor","North Gulf"]
["Wakulla","North Gulf"]
["Walton","North Gulf"]
["Alachua","Landlocked"]
["Baker","Landlocked"]
["Bradford","Landlocked"]
["Clay","Landlocked"]
["Columbia","Landlocked"]
["DeSoto","Landlocked"]
["Gilchrist","Landlocked"]
["Glades","Landlocked"]
["Hardee","Landlocked"]
["Hendry","Landlocked"]
["Highlands","Landlocked"]
["Lake","Landlocked"]
["Marion","Landlocked"]
["Okeechobee","Landlocked"]
["Orange","Landlocked"]
["Osceola","Landlocked"]
["Polk","Landlocked"]
["Putnam","Landlocked"]
["Seminole","Landlocked"]
["Sumter","Landlocked"]
["Union","Landlocked"]

{"sheet":"ByZipCode","index":5,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Zip Code","Value","City","County"]
[32901,{"$f":"A2-32900","v":1},"Melbourne","Brevard County"]
[32902,{"$f":"A3-32900","v":2},"Melbourne","Brevard County"]
[32903,3,"Indialantic","Brevard County"]
[32903,3,"Melbourne","Brevard County"]
[32904,4,"Melbourne","Brevard County"]
[32904,4,"Melbourne Village","Brevard County"]
[32904,4,"West Melbourne","Brevard County"]
[32905,5,"Melbourne","Brevard County"]
[32905,5,"Palm Bay","Brevard County"]
[32906,6,"Melbourne","Brevard County"]
[32906,6,"Palm Bay","Brevard County"]
[32907,7,"Melbourne","Brevard County"]
[32907,7,"Palm Bay","Brevard County"]
[32908,8,"Melbourne","Brevard County"]
[32908,8,"Palm Bay","Brevard County"]
[32909,9,"Melbourne","Brevard County"]
[32909,9,"Palm Bay","Brevard County"]
[32910,10,"Melbourne","Brevard County"]
[32910,10,"Palm Bay","Brevard County"]
[32911,11,"Melbourne","Brevard County"]
[32911,11,"Palm Bay","Brevard County"]
[32912,12,"Melbourne","Brevard County"]
[32912,12,"West Melbourne","Brevard County"]
[32920,20,"Port Canaveral","Brevard County"]
[32920,20,"Cape Canaveral","Brevard County"]
[32922,22,"Cocoa","Brevard County"]
[32923,23,"Cocoa","Brevard County"]
[32924,24,"Cocoa","Brevard County"]
[32925,25,"Canaveral Air Station","Brevard County"]
[32925,25,"Patrick Afb","Brevard County"]
[32926,26,"Cocoa","Brevard County"]
[32927,27,"Port Saint John","Brevard County"]
[32927,27,"Cocoa","Brevard County"]
[32931,31,"Cocoa Beach","Brevard County"]
[32932,32,"Cocoa Beach","Brevard County"]
[32934,34,"Eau Gallie","Brevard County"]
[32934,34,"Melbourne","Brevard County"]
[32935,35,"Melbourne","Brevard County"]
[32936,36,"Melbourne","Brevard County"]
[32937,37,"Indian Harbor Beach","Brevard County"]
[32937,37,"Indian Harbour Beach","Brevard County"]
[32937,37,"Melbourne","Brevard County"]
[32937,37,"Satellite Beach","Brevard County"]
[32940,40,"Viera","Brevard County"]
[32940,40,"Melbourne","Brevard County"]
[32941,41,"Melbourne","Brevard County"]
[32948,48,"Fellsmere","Indian River County"]
[32949,49,"Grant","Brevard County"]
[32950,50,"Malabar","Brevard County"]
[32951,51,"Melbourne","Brevard County"]
[32951,51,"Melbourne Beach","Brevard County"]
[32952,52,"Merritt Island","Brevard County"]
[32953,53,"Merritt Island","Brevard County"]
[32954,54,"Merritt Island","Brevard County"]
[32955,55,"Viera","Brevard County"]
[32955,55,"Rockledge","Brevard County"]
[32956,56,"Rockledge","Brevard County"]
[32957,57,"Roseland","Indian River County"]
[32958,58,"Sebastian","Indian River County"]
[32959,59,"Sharpes","Brevard County"]
[32976,76,"Barefoot Bay","Brevard County"]
[32976,76,"Micco","Brevard County"]
[32976,76,"Sebastian","Brevard County"]

{"sheet":"PivotMap","index":6,"n_rows":331,"n_cols":16,"rows_kept":331,"cut":false,"hidden":false,"merged":[]}
["State","County","Crop","Value"]
["Florida","Brevard","All Citrus",382]
["Florida","Brevard","Grapefruit",12]
["Florida","Brevard","Grapefruit - Red",11]
["Florida","Brevard","Grapefruit - White",1]
["Florida","Brevard","Oranges",349]
["Florida","Brevard","Oranges - Early",208]
["Florida","Brevard","Oranges - Late",141]
["Florida","Brevard","Tangelos ",10]
["Florida","Brevard","Tangerines",11]
["Florida","Brevard","Tangerines - Early",11]
["Florida","Brevard","Tangerines - Honey",0]
["Florida","Charlotte","All Citrus",2827]
["Florida","Charlotte","Grapefruit",232]
["Florida","Charlotte","Grapefruit - Red",218]
["Florida","Charlotte","Grapefruit - White",14]
["Florida","Charlotte","Oranges",2471]
["Florida","Charlotte","Oranges - Early",906]
["Florida","Charlotte","Oranges - Late",1565]
["Florida","Charlotte","Tangelos ",14]
["Florida","Charlotte","Tangerines",110]
["Florida","Charlotte","Tangerines - Early",79]
["Florida","Charlotte","Tangerines - Honey",31]
["Florida","Collier","All Citrus",7549]
["Florida","Collier","Grapefruit",201]
["Florida","Collier","Grapefruit - Red",178]
["Florida","Collier","Grapefruit - White",23]
["Florida","Collier","Oranges",7267]
["Florida","Collier","Oranges - Early",3416]
["Florida","Collier","Oranges - Late",3851]
["Florida","Collier","Tangelos ",8]
["Florida","Collier","Tangerines",73]
["Florida","Collier","Tangerines - Early",35]
["Florida","Collier","Tangerines - Honey",38]
["Florida","De Soto","All Citrus",13735]
["Florida","De Soto","Grapefruit",128]
["Florida","De Soto","Grapefruit - Red",111]
["Florida","De Soto","Grapefruit - White",17]
["Florida","De Soto","Oranges",13501]
["Florida","De Soto","Oranges - Early",6081]
["Florida","De Soto","Oranges - Late",7420]
["Florida","De Soto","Tangelos ",5]
["Florida","De Soto","Tangerines",101]
["Florida","De Soto","Tangerines - Early",9]
["Florida","De Soto","Tangerines - Honey",92]
["Florida","Glades","All Citrus",1950]
["Florida","Glades","Grapefruit",4]
["Florida","Glades","Grapefruit - Red",4]
["Florida","Glades","Grapefruit - White",0]
["Florida","Glades","Oranges",1917]
["Florida","Glades","Oranges - Early",1094]
["Florida","Glades","Oranges - Late",823]
["Florida","Glades","Tangelos ",1]
["Florida","Glades","Tangerines",28]
["Florida","Glades","Tangerines - Early",10]
["Florida","Glades","Tangerines - Honey",18]
["Florida","Hardee","All Citrus",10079]
["Florida","Hardee","Grapefruit",142]
["Florida","Hardee","Grapefruit - Red",129]
["Florida","Hardee","Grapefruit - White",13]
["Florida","Hardee","Oranges",9743]
["Florida","Hardee","Oranges - Early",6789]
["Florida","Hardee","Oranges - Late",2954]
["Florida","Hardee","Tangelos ",33]
["Florida","Hardee","Tangerines",161]
["Florida","Hardee","Tangerines - Early",63]
["Florida","Hardee","Tangerines - Honey",98]
["Florida","Hendry","All Citrus",15773]
["Florida","Hendry","Grapefruit",344]
["Florida","Hendry","Grapefruit - Red",263]
["Florida","Hendry","Grapefruit - White",81]
["Florida","Hendry","Oranges",15266]
["Florida","Hendry","Oranges - Early",6295]
["Florida","Hendry","Oranges - Late",8971]
["Florida","Hendry","Tangelos ",53]
["Florida","Hendry","Tangerines",110]
["Florida","Hendry","Tangerines - Early",27]
["Florida","Hendry","Tangerines - Honey",83]
["Florida","Hernando","All Citrus",148]
["Florida","Hernando","Grapefruit",4]
["Florida","Hernando","Grapefruit - Red",4]
["Florida","Hernando","Grapefruit - White",0]
["Florida","Hernando","Oranges",136]
["Florida","Hernando","Oranges - Early",134]
["Florida","Hernando","Oranges - Late",2]
["Florida","Hernando","Tangelos ",1]
["Florida","Hernando","Tangerines",7]
["Florida","Hernando","Tangerines - Early",7]
["Florida","Hernando","Tangerines - Honey",0]
["Florida","Highlands","All Citrus",12665]
["Florida","Highlands","Grapefruit",307]
["Florida","Highlands","Grapefruit - Red",174]
["Florida","Highlands","Grapefruit - White",133]
["Florida","Highlands","Oranges",12126]
["Florida","Highlands","Oranges - Early",4279]
["Florida","Highlands","Oranges - Late",7847]
["Florida","Highlands","Tangelos ",29]
["Florida","Highlands","Tangerines",203]
["Florida","Highlands","Tangerines - Early",124]
["Florida","Highlands","Tangerines - Honey",79]
["Florida","Hillsborough","All Citrus",1239]
["Florida","Hillsborough","Grapefruit",15]
["Florida","Hillsborough","Grapefruit - Red",13]
["Florida","Hillsborough","Grapefruit - White",2]
["Florida","Hillsborough","Oranges",1143]
["Florida","Hillsborough","Oranges - Early",825]
["Florida","Hillsborough","Oranges - Late",318]
["Florida","Hillsborough","Tangelos ",8]
["Florida","Hillsborough","Tangerines",73]
["Florida","Hillsborough","Tangerines - Early",40]
["Florida","Hillsborough","Tangerines - Honey",33]
["Florida","Indian River","All Citrus",6870]
["Florida","Indian River","Grapefruit",4840]
["Florida","Indian River","Grapefruit - Red",3296]
["Florida","Indian River","Grapefruit - White",1544]
["Florida","Indian River","Oranges",1917]
["Florida","Indian River","Oranges - Early",1067]
["Florida","Indian River","Oranges - Late",850]
["Florida","Indian River","Tangelos ",36]
["Florida","Indian River","Tangerines",77]
["Florida","Indian River","Tangerines - Early",48]
["Florida","Indian River","Tangerines - Honey",29]
["Florida","Lake","All Citrus",2290]
["Florida","Lake","Grapefruit",296]
["Florida","Lake","Grapefruit - Red",272]
["Florida","Lake","Grapefruit - White",24]
["Florida","Lake","Oranges",1561]
["Florida","Lake","Oranges - Early",1144]
["Florida","Lake","Oranges - Late",417]
["Florida","Lake","Tangelos ",110]
["Florida","Lake","Tangerines",323]
["Florida","Lake","Tangerines - Early",298]
["Florida","Lake","Tangerines - Honey",25]
["Florida","Lee","All Citrus",2400]
["Florida","Lee","Grapefruit",138]
["Florida","Lee","Grapefruit - Red",122]
["Florida","Lee","Grapefruit - White",16]
["Florida","Lee","Oranges",2201]
["Florida","Lee","Oranges - Early",869]
["Florida","Lee","Oranges - Late",1332]
["Florida","Lee","Tangelos ",2]
["Florida","Lee","Tangerines",59]
["Florida","Lee","Tangerines - Early",37]
["Florida","Lee","Tangerines - Honey",22]
["Florida","Manatee","All Citrus",4002]
["Florida","Manatee","Grapefruit",39]
["Florida","Manatee","Grapefruit - Red",32]
["Florida","Manatee","Grapefruit - White",7]
["Florida","Manatee","Oranges",3917]
["Florida","Manatee","Oranges - Early",2211]
["Florida","Manatee","Oranges - Late",1706]
["Florida","Manatee","Tangelos ",21]
["Florida","Manatee","Tangerines",25]
["Florida","Manatee","Tangerines - Early",5]
["Florida","Manatee","Tangerines - Honey",20]
["Florida","Marion","All Citrus",219]
["Florida","Marion","Grapefruit",10]
["Florida","Marion","Grapefruit - Red",9]
["Florida","Marion","Grapefruit - White",1]
["Florida","Marion","Oranges",170]
["Florida","Marion","Oranges - Early",145]
["Florida","Marion","Oranges - Late",25]
["Florida","Marion","Tangelos ",6]
["Florida","Marion","Tangerines",33]
["Florida","Marion","Tangerines - Early",33]
["Florida","Marion","Tangerines - Honey",0]
["Florida","Martin","All Citrus",806]
["Florida","Martin","Grapefruit",18]
["Florida","Martin","Grapefruit - Red",7]
["Florida","Martin","Grapefruit - White",11]
["Florida","Martin","Oranges",782]
["Florida","Martin","Oranges - Early",127]
["Florida","Martin","Oranges - Late",655]
["Florida","Martin","Tangelos ",4]
["Florida","Martin","Tangerines",2]
["Florida","Martin","Tangerines - Early",1]
["Florida","Martin","Tangerines - Honey",1]
["Florida","Okeechobee","All Citrus",1304]
["Florida","Okeechobee","Grapefruit",159]
["Florida","Okeechobee","Grapefruit - Red",110]
["Florida","Okeechobee","Grapefruit - White",49]
["Florida","Okeechobee","Oranges",1082]
["Florida","Okeechobee","Oranges - Early",569]
["Florida","Okeechobee","Oranges - Late",513]
["Florida","Okeechobee","Tangelos ",24]
["Florida","Okeechobee","Tangerines",39]
["Florida","Okeechobee","Tangerines - Early",28]
["Florida","Okeechobee","Tangerines - Honey",11]
["Florida","Orange","All Citrus",468]
["Florida","Orange","Grapefruit",16]
["Florida","Orange","Grapefruit - Red",16]
["Florida","Orange","Grapefruit - White",0]
["Florida","Orange","Oranges",418]
["Florida","Orange","Oranges - Early",267]
["Florida","Orange","Oranges - Late",151]
["Florida","Orange","Tangelos ",13]
["Florida","Orange","Tangerines",21]
["Florida","Orange","Tangerines - Early",20]
["Florida","Orange","Tangerines - Honey",1]
["Florida","Osceola","All Citrus",1952]
["Florida","Osceola","Grapefruit",229]
["Florida","Osceola","Grapefruit - Red",96]
["Florida","Osceola","Grapefruit - White",133]
["Florida","Osceola","Oranges",1685]
["Florida","Osceola","Oranges - Early",1045]
["Florida","Osceola","Oranges - Late",640]
["Florida","Osceola","Tangelos ",12]
["Florida","Osceola","Tangerines",26]
["Florida","Osceola","Tangerines - Early",23]
["Florida","Osceola","Tangerines - Honey",3]
["Florida","Pasco","All Citrus",1374]
["Florida","Pasco","Grapefruit",17]
["Florida","Pasco","Grapefruit - Red",15]
["Florida","Pasco","Grapefruit - White",2]
["Florida","Pasco","Oranges",1312]
["Florida","Pasco","Oranges - Early",1028]
["Florida","Pasco","Oranges - Late",284]
["Florida","Pasco","Tangelos ",7]
["Florida","Pasco","Tangerines",38]
["Florida","Pasco","Tangerines - Early",34]
["Florida","Pasco","Tangerines - Honey",4]
["Florida","Polk","All Citrus",16832]
["Florida","Polk","Grapefruit",670]
["Florida","Polk","Grapefruit - Red",458]
["Florida","Polk","Grapefruit - White",212]
["Florida","Polk","Oranges",15247]
["Florida","Polk","Oranges - Early",8067]
["Florida","Polk","Oranges - Late",7180]
["Florida","Polk","Tangelos ",226]
["Florida","Polk","Tangerines",689]
["Florida","Polk","Tangerines - Early",481]
["Florida","Polk","Tangerines - Honey",208]
["Florida","Sarasota","All Citrus",242]
["Florida","Sarasota","Grapefruit",65]
["Florida","Sarasota","Grapefruit - Red",64]
["Florida","Sarasota","Grapefruit - White",1]
["Florida","Sarasota","Oranges",164]
["Florida","Sarasota","Oranges - Early",73]
["Florida","Sarasota","Oranges - Late",91]
["Florida","Sarasota","Tangelos ",8]
["Florida","Sarasota","Tangerines",5]
["Florida","Sarasota","Tangerines - Early",4]
["Florida","Sarasota","Tangerines - Honey",1]
["Florida","Seminole","All Citrus",57]
["Florida","Seminole","Grapefruit",3]
["Florida","Seminole","Grapefruit - Red",3]
["Florida","Seminole","Grapefruit - White",0]
["Florida","Seminole","Oranges",48]
["Florida","Seminole","Oranges - Early",39]
["Florida","Seminole","Oranges - Late",9]
["Florida","Seminole","Tangelos ",4]
["Florida","Seminole","Tangerines",2]
["Florida","Seminole","Tangerines - Early",2]
["Florida","Seminole","Tangerines - Honey",0]
["Florida","St Lucie","All Citrus",7286]
["Florida","St Lucie","Grapefruit",4983]
["Florida","St Lucie","Grapefruit - Red",4019]
["Florida","St Lucie","Grapefruit - White",964]
["Florida","St Lucie","Oranges",2219]
["Florida","St Lucie","Oranges - Early",587]
["Florida","St Lucie","Oranges - Late",1632]
["Florida","St Lucie","Tangelos ",42]
["Florida","St Lucie","Tangerines",42]
["Florida","St Lucie","Tangerines - Early",15]
["Florida","St Lucie","Tangerines - Honey",27]
["Florida","Volusia","All Citrus",141]
["Florida","Volusia","Grapefruit",20]
["Florida","Volusia","Grapefruit - Red",18]
["Florida","Volusia","Grapefruit - White",2]
["Florida","Volusia","Oranges",116]
["Florida","Volusia","Oranges - Early",99]
["Florida","Volusia","Oranges - Late",17]
["Florida","Volusia","Tangelos ",2]
["Florida","Volusia","Tangerines",3]
["Florida","Volusia","Tangerines - Early",3]
["Florida","Volusia","Tangerines - Honey",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Row Labels","Sum of Value",null,null,"Row Labels"]
[null,"County","State",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,P306:P316)","v":"Oranges - Early"},null,null,null,null,null,null,null,"Brevard",208,null,null,"Oranges - Early"]
[null,"Brevard","Florida",{"$f":"_xlfn.IFNA(VLOOKUP(B307,$L$306:$M$330,2,0),0)","v":208},null,null,null,null,null,null,null,"Charlotte",906]
[null,"Charlotte","Florida",906,null,null,null,null,null,null,null,"Collier",3416]
[null,"Collier","Florida",3416,null,null,null,null,null,null,null,"De Soto",6081]
[null,"De Soto","Florida",6081,null,null,null,null,null,null,null,"Glades",1094]
[null,"Glades","Florida",1094,null,null,null,null,null,null,null,"Hardee",6789]
[null,"Hardee","Florida",6789,null,null,null,null,null,null,null,"Hendry",6295]
[null,"Hendry","Florida",6295,null,null,null,null,null,null,null,"Hernando",134]
[null,"Hernando","Florida",134,null,null,null,null,null,null,null,"Highlands",4279]
[null,"Highlands","Florida",4279,null,null,null,null,null,null,null,"Hillsborough",825]
[null,"Hillsborough","Florida",825,null,null,null,null,null,null,null,"Indian River",1067]
[null,"Indian River","Florida",1067,null,null,null,null,null,null,null,"Lake",1144]
[null,"Lake","Florida",1144,null,null,null,null,null,null,null,"Lee",869]
[null,"Lee","Florida",869,null,null,null,null,null,null,null,"Manatee",2211]
[null,"Manatee","Florida",2211,null,null,null,null,null,null,null,"Marion",145]
[null,"Marion","Florida",145,null,null,null,null,null,null,null,"Martin",127]
[null,"Martin","Florida",127,null,null,null,null,null,null,null,"Okeechobee",569]
[null,"Okeechobee","Florida",569,null,null,null,null,null,null,null,"Orange",267]
[null,"Orange","Florida",267,null,null,null,null,null,null,null,"Osceola",1045]
[null,"Osceola","Florida",1045,null,null,null,null,null,null,null,"Pasco",1028]
[null,"Pasco","Florida",1028,null,null,null,null,null,null,null,"Polk",8067]
[null,"Polk","Florida",8067,null,null,null,null,null,null,null,"Sarasota",73]
[null,"Sarasota","Florida",73,null,null,null,null,null,null,null,"Seminole",39]
[null,"Seminole","Florida",39,null,null,null,null,null,null,null,"St Lucie",587]
[null,"St Lucie","Florida",587,null,null,null,null,null,null,null,"Volusia",99]
[null,"Volusia","Florida",99,null,null,null,null,null,null,null,"Grand Total",47364]

{"sheet":"Wrap Up","index":7,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"November 2016 brings a new Map Chart feature to Office 365"]
[null,"This feature is marketed as Office 365 Exclusive"]
[null,"Different than Power Map - because it can be embedded in your worksheet"]
[null,"Only a shape map! Not a point map…"]
[null,"Data can be plotted by Country, State, County, Zip Code"]
[null,"In other countries, use \"Regions\" instead of \"Region\""]
[null,"How to change the color for value charts"]
[null,"For Category charts, edit the legend entries to change the color."]
[null,"How to change the label"]
[null,"How to change the projection"]
[null,"Value maps versus Category Maps"]
[null,"Like the other new Ivy Charts - can not have the chart title come from a cell"]
[null,"Can not base a map directly on a pivot table - use VLOOKUP"]
[null,"TEXTJOIN function"]