{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["IOWA MAP","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":40,"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":"IOWA MAP","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data","index":1,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[25,3,29,10],[31,3,38,10],[12,3,23,10]]}
["County","total rev per captia",null,null,null,"0-200",null,0,"LegCl0"]
["ADAIR",1175.5975593754101,null,null,null,"200-500",null,200,"LegCl1"]
["ADAMS",1954.0364749082007,null,null,null,"500-800",null,500,"LegCl2"]
["ALLAMAKEE",806.56920104870983,null,null,null,"800-1000",null,800,"LegCl3"]
["APPANOOSE",815.07315570614503,null,null,null,"1000-1500",null,1000,"LegCl4"]
["AUDUBON",1277.4456916474085,null,null,null,"1500-2000",null,1500,"LegCl5"]
["BENTON",719.40832421418065,null,null,null,"2000+",null,2000,"LegCl6"]
["BLACK HAWK",555.99724065280964,null,"# of Legend color",{"$f":"7","v":7}]
["BOONE",710.86237905520773,null,null,null,"activate Reg","WRIGHT","actCounty"]
["BREMER",720.69923702735741,null,null,null,"Value",{"$f":"VLOOKUP(actCounty,CountyData,2,FALSE)","v":1123.9320328699794},"actCountyValue"]
["BUCHANAN",1024.9486198153375,null,null,null,"Code",{"$f":"VLOOKUP(actCountyValue,LegClValues,2,TRUE)","v":"LegCl4"},"actCountyCode"]
["BUENA VISTA",780.56099055399545]
["BUTLER",892.67715299576912,null,"How to use: Data used in put into the green box. Insert the county numeric information in the B2:B100 region, counties are listed alphabetically. Decide the number and style of the partitions in the mapping in the red box. E8 determines the number of partitions that will be displayed on the legend during the mapping from top to bottom (note while it will not display the partitions in the legend if the omitted partitions are left feasible for the mapping program it will map the omitted partitions). E1:E7 determines the colors used in the partitions. F1:F7 are the ranges that will be displayed on the legend. H1:H7 are the minimum values for each partition used in determining the color for each of the counties (note for each of the counties to fall into a partition it must be strictly greater than the value used in H and that value must be the largest possible value). When you are ready to run switch to the map page and either run macro or hit the run it button. Note that after your done the image can be cut and pasted into almost application that is compatible with excel."]
["CALHOUN",1373.698554507127]
["CARROLL",739.18474624868588]
["CASS",1500.2070732587513]
["CEDAR",872.9841340533319]
["CERRO GORDO",745.20554949550046]
["CHEROKEE",896.68798698518708]
["CHICKASAW",932.66332895600783]
["CLARKE",976.08208040984516]
["CLAY",828.9926884813616]
["CLAYTON",940.49649162516971]
["CLINTON",569.46096298108284]
["CRAWFORD",1001.2549043351901]
["DALLAS",597.55287494973868,null,"Example: I have new data that I want mapped into four color partitions. I take that data alphabetize by county and paste in into B2:B100 I then put the value 4 into E7 and adjust the color for E1:E4 and the value range for F1:F4. I then put the minimum for each of the partitions in to H1:H4 and for H5:H7 I put an extremely large number in to ensure its omitted from the mapping like a million. I then change pages and run the program."]
["DAVIS",857.95128504672903]
["DECATUR",947.45517077798866]
["DELAWARE",831.72790830945564]
["DES MOINES",710.67354078892254]
["DICKINSON",1007.493670886076]
["DUBUQUE",597.36309265840339,null,"How it works:  The program works down the list of the data set in the green box from the top to the bottom.  Each set will have a name actCounty and a value actCountyValue. The program will then try to determine the code associated with its color due to its value. It does this with excels vlookup function looking through H1:H7 trying to find the largest number actCountyValue is larger than and then assigns it a corresponding actCountyCode this code corresponding to the coloring in E1:E7. It then uses actCounty to find the name of the county on the map and uses the actCountyCode to fill in the correct color. I then move on the next county and repeats."]
["EMMET",788.39107434836967]
["FAYETTE",835.9401872824435]
["FLOYD",815.6616264060483]
["FRANKLIN",1211.0480659840728]
["FREMONT",1205.07149477029]
["GREENE",1086.2974997362592]
["GRUNDY",905.53412365193049]
["GUTHRIE",1040.5053109396279]
["HAMILTON",1194.8720272528603,null,"This prgram is based off of a program that was found online so:"]
["HANCOCK",1167.572836030964,null,"Credit for a lot of the program goes to Jorge Cameos \"How to Create a Thermatic Map in Excel\""]
["HARDIN",962.87180220912262,null,"http://www.excelcharts.com/blog/how-to-create-thematic-map-excel/"]
["HARRISON",1069.8451600337596]
["HENRY",695.51945669954887]
["HOWARD",908.79707860445569]
["HUMBOLDT",946.30058467320941]
["IDA",864.55858585858584]
["IOWA",1002.9223203026481]
["JACKSON",637.79818163652715]
["JASPER",720.56932354626576]
["JEFFERSON",624.88971770304158]
["JOHNSON",794.65305211471934]
["JONES",749.92742014742009]
["KEOKUK",906.02204651162788]
["KOSSUTH",1086.6998717126362]
["LEE",655.32876827423968]
["LINN",561.79839607822157]
["LOUISA",1280.222552685248]
["LUCAS",951.03053111417364]
["LYON",1023.174268693874]
["MADISON",738.18274045652595]
["MAHASKA",886.36323192378552]
["MARION",638.32186278432698]
["MARSHALL",608.59274748814198]
["MILLS",911.91860080671825]
["MITCHELL",1034.3762680316427]
["MONONA",1197.6276044537537]
["MONROE",1060.2185150995649]
["MONTGOMERY",804.80205866278015]
["MUSCATINE",643.99503956537148]
["O'BRIEN",848.39445234708387]
["OSCEOLA",1052.6943109595411]
["PAGE",581.5177403120282]
["PALO ALTO",1861.6460167603691]
["PLYMOUTH",820.85056290574414]
["POCAHONTAS",1257.6082702843726]
["POLK",570.54977398316362]
["POTTAWATTAMIE",709.83796094230877]
["POWESHIEK",1064.4702078768771]
["RINGGOLD",2017.3242559813266]
["SAC",991.24990347490348]
["SCOTT",477.73792360491245]
["SHELBY",1050.9251827782291]
["SIOUX",606.13840344526272]
["STORY",413.40366445502076]
["TAMA",928.33179490065856]
["TAYLOR",1092.3795963073071]
["UNION",745.95993747943407]
["VAN BUREN",868.83498435870695]
["WAPELLO",538.71462816210271]
["WARREN",566.28677265357589]
["WASHINGTON",924.09446223394241]
["WAYNE",1634.0098899345987]
["WEBSTER",713.25825001295141]
["WINNEBAGO",958.27116317378966]
["WINNESHIEK",923.01216009191876]
["WOODBURY",536.70175645177119]
["WORTH",1183.0242914979758]
["WRIGHT",1123.9320328699794]