{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["map","data","control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"map","index":0,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Choropleth Map - Yemen by Governorates",null,null,null,null,null,null,null,null,null,null,null,"www.clearlyandsimply.com"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Measure"]
[null,null,null,null,null,null,null,null,null,null,null,"Colors"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"hover over the map with the mouse to see the region names and the values"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Legend"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D26","v":"no data"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D27","v":"7.000  to 11.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D28","v":"11.000 to 15.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D29","v":"15.000 to 19.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D30","v":"19.000 to 23.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D31","v":"23.000 to 27.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D32","v":"27.000 to 31.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D33","v":"31.000 to 35.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D34","v":"35.000 to 39.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D35","v":"39.000 to 43.000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"control!D36","v":"43.000 or more"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!E2","v":"Source: Dummy Data"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.clearlyandsimply.com"]

{"sheet":"data","index":1,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data",null,null,"Source: Dummy Data",null,null,null,null,null,"Selection / Shape Definition"]
[]
[null,"The source data: governorates",null,null,null,null,null,null,null,null,"Calculation of selected data, shape name definition and shape index"]
[null,"No.","Governorates English","Governorates Arabic","Random","First 5 only, no data in all others","2 Selected Governorates","Ascending % (source data order)","Descending value (source data order)",null,"Selection","Shape Names","Shape Index"]
[null,1,"Ibb","اب",19545,33260,1,0.01,100000,null,{"$f":"IF(ISBLANK(INDEX($E6:$I6,1,control!$C$18)),\"\",INDEX($E6:$I6,1,control!$C$18))","v":19545},"S_YE11",1]
[null,2,"Abyan","ابين",14166,43857,1,0.02,95000,null,{"$f":"IF(ISBLANK(INDEX($E7:$I7,1,control!$C$18)),\"\",INDEX($E7:$I7,1,control!$C$18))","v":14166},"S_YE12",2]
[null,3,"Sana'a City","امانة العاصمه",14375,18807,1,0.03,90000,null,{"$f":"IF(ISBLANK(INDEX($E8:$I8,1,control!$C$18)),\"\",INDEX($E8:$I8,1,control!$C$18))","v":14375},"S_YE13",3]
[null,4,"Al Bayda","البيضاء",20048,40596,1,0.04,85000,null,{"$f":"IF(ISBLANK(INDEX($E9:$I9,1,control!$C$18)),\"\",INDEX($E9:$I9,1,control!$C$18))","v":20048},"S_YE14",4]
[null,5,"Ta'iz","تعز",30138,34322,1,0.05,80000,null,{"$f":"IF(ISBLANK(INDEX($E10:$I10,1,control!$C$18)),\"\",INDEX($E10:$I10,1,control!$C$18))","v":30138},"S_YE15",5]
[null,6,"Al Jawf","الجوف",20391,null,1,0.06,75000,null,{"$f":"IF(ISBLANK(INDEX($E11:$I11,1,control!$C$18)),\"\",INDEX($E11:$I11,1,control!$C$18))","v":20391},"S_YE16",6]
[null,7,"Hajjah","حجه",49737,null,1,7.0000000000000007E-2,70000,null,{"$f":"IF(ISBLANK(INDEX($E12:$I12,1,control!$C$18)),\"\",INDEX($E12:$I12,1,control!$C$18))","v":49737},"S_YE17",7]
[null,8,"Al Hodeidah","الحديده",33780,null,1,0.08,65000,null,{"$f":"IF(ISBLANK(INDEX($E13:$I13,1,control!$C$18)),\"\",INDEX($E13:$I13,1,control!$C$18))","v":33780},"S_YE18",8]
[null,9,"Hadramawt","حضرموت",34751,null,100,0.09,60000,null,{"$f":"IF(ISBLANK(INDEX($E14:$I14,1,control!$C$18)),\"\",INDEX($E14:$I14,1,control!$C$18))","v":34751},"S_YE19",9]
[null,10,"Dhamar","ذمار",21532,null,1,0.1,55000,null,{"$f":"IF(ISBLANK(INDEX($E15:$I15,1,control!$C$18)),\"\",INDEX($E15:$I15,1,control!$C$18))","v":21532},"S_YE20",10]
[null,11,"Shabwah","شبوه",18374,null,1,0.11,50000,null,{"$f":"IF(ISBLANK(INDEX($E16:$I16,1,control!$C$18)),\"\",INDEX($E16:$I16,1,control!$C$18))","v":18374},"S_YE21",11]
[null,12,"Sa'dah","صعده",14142,null,1,0.12,45000,null,{"$f":"IF(ISBLANK(INDEX($E17:$I17,1,control!$C$18)),\"\",INDEX($E17:$I17,1,control!$C$18))","v":14142},"S_YE22",12]
[null,13,"Sana'a","صنعاء",25911,null,1,0.13,40000,null,{"$f":"IF(ISBLANK(INDEX($E18:$I18,1,control!$C$18)),\"\",INDEX($E18:$I18,1,control!$C$18))","v":25911},"S_YE23",13]
[null,14,"Aden","عدن",30917,null,1,0.14000000000000001,35000,null,{"$f":"IF(ISBLANK(INDEX($E19:$I19,1,control!$C$18)),\"\",INDEX($E19:$I19,1,control!$C$18))","v":30917},"S_YE24",14]
[null,15,"Lahj","لحج",39506,null,1,0.15,30000,null,{"$f":"IF(ISBLANK(INDEX($E20:$I20,1,control!$C$18)),\"\",INDEX($E20:$I20,1,control!$C$18))","v":39506},"S_YE25",15]
[null,16,"Ma'rib","مارب",49598,null,1,0.16,25000,null,{"$f":"IF(ISBLANK(INDEX($E21:$I21,1,control!$C$18)),\"\",INDEX($E21:$I21,1,control!$C$18))","v":49598},"S_YE26",16]
[null,17,"Al Mahwit","المحويت",44506,null,1,0.17,20000,null,{"$f":"IF(ISBLANK(INDEX($E22:$I22,1,control!$C$18)),\"\",INDEX($E22:$I22,1,control!$C$18))","v":44506},"S_YE27",17]
[null,18,"Al Maharah","المهره",21154,null,1,0.18,15000,null,{"$f":"IF(ISBLANK(INDEX($E23:$I23,1,control!$C$18)),\"\",INDEX($E23:$I23,1,control!$C$18))","v":21154},"S_YE28",18]
[null,19,"Amran","عمران",23556,null,100,0.19,10000,null,{"$f":"IF(ISBLANK(INDEX($E24:$I24,1,control!$C$18)),\"\",INDEX($E24:$I24,1,control!$C$18))","v":23556},"S_YE29",19]
[null,20,"Ad Dali'","الضالع",6843,null,1,0.2,5000,null,{"$f":"IF(ISBLANK(INDEX($E25:$I25,1,control!$C$18)),\"\",INDEX($E25:$I25,1,control!$C$18))","v":6843},"S_YE30",20]
[null,21,"Raymah","ريمه",27182,null,1,0.21,0,null,{"$f":"IF(ISBLANK(INDEX($E26:$I26,1,control!$C$18)),\"\",INDEX($E26:$I26,1,control!$C$18))","v":27182},"S_YE31",21]

{"sheet":"control","index":2,"n_rows":67,"n_cols":27,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,1,68,2]]}
[]
[null,"Control"]
[]
[null,"Worksheet and Code Parameters"]
[]
[null,"Sheet with map",1,"Sheet index of worksheet with the maps"]
[null,"Show Status Bar",false,"Status bar information during map update will be displayed (or not, if FALSE)"]
[]
[null,"Metrics"]
[]
[null,null,"Metrics","Format Values","Format Legend","Round factor",null,"Min","Max","Bin size","Start","Range"]
[null,null,{"$f":"data!$E$5","v":"Random"},"#,##0","#.##0",-3,null,{"$f":"MIN(data!$E$6:$E$26)","v":6843},{"$f":"MAX(data!$E$6:$E$26)","v":49737},{"$f":"ROUND((I12-H12)/COUNTA($C$27:$C$36),F12)","v":4000},{"$f":"ROUND(H12,F12)","v":7000},{"$f":"I12-K12","v":42737}]
[null,null,{"$f":"data!$F$5","v":"First 5 only, no data in all others"},"#,##0","#.##0",0,null,{"$f":"MIN(data!$F$6:$F$26)","v":18807},{"$f":"MAX(data!$F$6:$F$26)","v":43857},{"$f":"ROUND((I13-H13)/COUNTA($C$27:$C$36),F13)","v":2505},18807,{"$f":"I13-K13","v":25050}]
[null,null,{"$f":"data!$G$5","v":"2 Selected Governorates"},"#,##0","#.##0",0,null,{"$f":"MIN(data!$G$6:$G$26)","v":1},{"$f":"MAX(data!$G$6:$G$26)","v":100},{"$f":"ROUND((I14-H14)/COUNTA($C$27:$C$36),F14)","v":10},1,99]
[null,null,{"$f":"data!$H$5","v":"Ascending % (source data order)"},"0.0%","0%",2,null,{"$f":"MIN(data!$H$6:$H$26)","v":0.01},{"$f":"MAX(data!$H$6:$H$26)","v":0.21},{"$f":"ROUND((I15-H15)/COUNTA($C$27:$C$36),F15)","v":0.02},0.01,0.19999999999999998]
[null,null,{"$f":"data!$I$5","v":"Descending value (source data order)"},"#,##0","#.##0",-3,null,{"$f":"MIN(data!$I$6:$I$26)","v":0},{"$f":"MAX(data!$I$6:$I$26)","v":100000},{"$f":"ROUND((I16-H16)/COUNTA($C$27:$C$36),F16)","v":10000},0,100000]
[]
[null,"Selection",1,{"$f":"INDEX(D12:D16,$C$18)","v":"#,##0"},{"$f":"INDEX(E12:E16,$C$18)","v":"#.##0"},{"$f":"INDEX(F12:F16,$C$18)","v":-3},null,{"$f":"INDEX(H12:H16,$C$18)","v":6843},{"$f":"INDEX(I12:I16,$C$18)","v":49737},{"$f":"INDEX(J12:J16,$C$18)","v":4000},{"$f":"INDEX(K12:K16,$C$18)","v":7000},{"$f":"INDEX(L12:L16,$C$18)","v":42737}]
[]
[]
[null,"Bins, Color Scales and Legend"]
[]
[null,null,null,null,"Contrast",null,null,null,null,null,"No Scale","Highlight",null,"Focus",null,"Loaded",null,"Pairs, Triplets, Quads, Quints",null,null,null,"Stepped",null,null,null,"Smear"]
[null,null,null,null,1,{"$f":"E24+1","v":2},{"$f":"F24+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,{"$f":"Y24+1","v":22},{"$f":"Z24+1","v":23}]
[null,"Threshold","RGB","Legend",{"$f":"$C$39","v":"Green to Red Contrast"},{"$f":"$C$40","v":"Green to Pink Contrast"},{"$f":"$C$41","v":"Green to Purple Contrast"},{"$f":"$C$42","v":"Red to Blue Contrast"},{"$f":"$C$43","v":"Blue to Red Contrast"},{"$f":"$C$44","v":"Spectral"},{"$f":"$C$45","v":"Light, No Scale"},{"$f":"$C$46","v":"Brown Highlight High"},{"$f":"$C$47","v":"Brown Highlight Low"},{"$f":"$C$48","v":"High Focus"},{"$f":"$C$49","v":"Low Focus"},{"$f":"$C$50","v":"Center Loaded"},{"$f":"$C$51","v":"Outlier Loaded"},{"$f":"$C$52","v":"Pairs"},{"$f":"$C$53","v":"Triplets"},{"$f":"$C$54","v":"Quads"},{"$f":"$C$55","v":"Quints"},{"$f":"$C$56","v":"Blue Purple Stepped"},{"$f":"$C$57","v":"Blue Stepped Red Tips"},{"$f":"$C$58","v":"Blue Green Stepped"},{"$f":"$C$59","v":"Gray Stepped"},{"$f":"$C$60","v":"Blue Smear"},{"$f":"$C$61","v":"Green Smear"}]
[null,null,12566463,"no data"]
[null,{"$f":"$K$18+$J$18","v":11000},3631104,{"$f":"TEXT($K$18,$E$18)&\"  to \"&TEXT(B27,$E$18)","v":"7.000  to 11.000"}]
[null,{"$f":"B27+$J$18","v":15000},5281818,{"$f":"TEXT(B27,$E$18)&\" to \"&TEXT(B28,$E$18)","v":"11.000 to 15.000"}]
[null,{"$f":"B28+$J$18","v":19000},6536550,"15.000 to 19.000"]
[null,23000,7002534,"19.000 to 23.000"]
[null,27000,9170905,"23.000 to 27.000"]
[null,31000,9167102,"27.000 to 31.000"]
[null,35000,6401789,"31.000 to 35.000"]
[null,39000,4419060,"35.000 to 39.000"]
[null,43000,2568407,"39.000 to 43.000"]
[null,99999999999999.906,2490533,{"$f":"TEXT(B35,$E$18)&\" or more\"","v":"43.000 or more"}]
[]
[]
[null,"Color Scales","Green to Red Contrast"]
[null,null,"Green to Pink Contrast"]
[null,null,"Green to Purple Contrast"]
[null,null,"Red to Blue Contrast"]
[null,null,"Blue to Red Contrast"]
[null,null,"Spectral"]
[null,null,"Light, No Scale"]
[null,null,"Brown Highlight High"]
[null,null,"Brown Highlight Low"]
[null,null,"High Focus"]
[null,null,"Low Focus"]
[null,null,"Center Loaded"]
[null,null,"Outlier Loaded"]
[null,null,"Pairs"]
[null,null,"Triplets"]
[null,null,"Quads"]
[null,null,"Quints"]
[null,null,"Blue Purple Stepped"]
[null,null,"Blue Stepped Red Tips"]
[null,null,"Blue Green Stepped"]
[null,null,"Gray Stepped"]
[null,null,"Blue Smear"]
[null,null,"Green Smear"]
[]
[null,"Selection",1]
[]
[null,"Shape Index"]
[]
[null,"Recreate the shape index after you inserted a new map, added shapes or changed the shape order"]