{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["XY Scatter","Bar","Data","Tooltips"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":"XY Scatter","index":0,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tooltips on Charts - Chart Events",null,null,null,null,null,"www.clearlyandsimply.com"]
[]
[null,"Please note: click on the chart first to see the tooltips when hovering over data points"]

{"sheet":"Bar","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tooltips on Charts - Chart Events",null,null,null,null,null,"www.clearlyandsimply.com"]
[]
[null,"Please note: click on the chart first to see the tooltips when hovering over data points"]

{"sheet":"Data","index":2,"n_rows":205,"n_cols":11,"rows_kept":205,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data","Fertility and Life Expectancy 2013",null,null,"source: www.gapminder.org"]
[]
[null,"Country","Region","Fertility Rate","Life Expectancy","Population",null,"Region","Avg. Fertility Rate","Avg. Life Expectancy","Sum Population"]
[null,"Afghanistan","Asia + Pacific",4.9000000000000004,60.947000000000003,34499915,null,"Asia + Pacific",{"$f":"AVERAGEIF(tab_data[Region],$H5,tab_data[Fertility Rate])","v":2.5214347826086958},{"$f":"AVERAGEIF(tab_data[Region],$H5,tab_data[Life Expectancy])","v":72.451065217391303},{"$f":"SUMIF(tab_data[Region],$H5,tab_data[Population])","v":4084690449}]
[null,"Albania","Europe",1.7709999999999999,77.391999999999996,3238316,null,"Europe",{"$f":"AVERAGEIF(tab_data[Region],$H6,tab_data[Fertility Rate])","v":1.64695652173913},{"$f":"AVERAGEIF(tab_data[Region],$H6,tab_data[Life Expectancy])","v":77.321891304347815},{"$f":"SUMIF(tab_data[Region],$H6,tab_data[Population])","v":841769768}]
[null,"Algeria","Africa",2.7949999999999999,71,36983924,null,"Africa",{"$f":"AVERAGEIF(tab_data[Region],$H7,tab_data[Fertility Rate])","v":4.3679649122807023},{"$f":"AVERAGEIF(tab_data[Region],$H7,tab_data[Life Expectancy])","v":60.367245614035099},{"$f":"SUMIF(tab_data[Region],$H7,tab_data[Population])","v":1094732690}]
[null,"Angola","Africa",5.8630000000000004,51.899000000000001,20714494,null,"North America",{"$f":"AVERAGEIF(tab_data[Region],$H8,tab_data[Fertility Rate])","v":2.0554999999999999},{"$f":"AVERAGEIF(tab_data[Region],$H8,tab_data[Life Expectancy])","v":79.132249999999999},{"$f":"SUMIF(tab_data[Region],$H8,tab_data[Population])","v":353691081}]
[null,"Antigua and Barbuda","North America",2.089,75.953999999999994,91404,null,"Latin America + Caribbean",{"$f":"AVERAGEIF(tab_data[Region],$H9,tab_data[Fertility Rate])","v":2.2805277777777779},{"$f":"AVERAGEIF(tab_data[Region],$H9,tab_data[Life Expectancy])","v":74.637916666666655},{"$f":"SUMIF(tab_data[Region],$H9,tab_data[Population])","v":609217581}]
[null,"Argentina","Latin America + Caribbean",2.1749999999999998,76.305000000000007,41473982,null,"West Asia",{"$f":"AVERAGEIF(tab_data[Region],$H10,tab_data[Fertility Rate])","v":2.817166666666667},{"$f":"AVERAGEIF(tab_data[Region],$H10,tab_data[Life Expectancy])","v":74.060999999999993},{"$f":"SUMIF(tab_data[Region],$H10,tab_data[Population])","v":144691525}]
[null,"Armenia","Europe",1.74,74.561000000000007,3117722]
[null,"Aruba","Latin America + Caribbean",1.673,75.454999999999998,108883]
[null,"Australia","Asia + Pacific",1.8819999999999999,82.495999999999995,23213944]
[null,"Austria","Europe",1.4710000000000001,81.137,8441263]
[null,"Azerbaijan","Europe",1.9239999999999999,70.753,9533445]
[null,"Bahamas","Latin America + Caribbean",1.8879999999999999,75.236999999999995,355233]
[null,"Bahrain","West Asia",2.0750000000000002,76.608000000000004,1377273]
[null,"Bangladesh","Asia + Pacific",2.177,70.656999999999996,154393847]
[null,"Barbados","Latin America + Caribbean",1.849,75.37,275141]
[null,"Belarus","Europe",1.494,69.927999999999997,9498290]
[null,"Belgium","Europe",1.8540000000000001,80.548000000000002,10815599]
[null,"Belize","Latin America + Caribbean",2.6760000000000002,73.882000000000005,330721]
[null,"Benin","Africa",4.8449999999999998,59.33,9606534]
[null,"Bhutan","Asia + Pacific",2.2320000000000002,68.293999999999997,762313]
[null,"Bolivia","Latin America + Caribbean",3.2210000000000001,67.260000000000005,10409761]
[null,"Bosnia and Herzegovina","Europe",1.2829999999999999,76.37,3735880]
[null,"Botswana","Africa",2.6190000000000002,47.572000000000003,2074616]
[null,"Brazil","Latin America + Caribbean",1.8009999999999999,73.936999999999998,200050487]
[null,"Brunei","Asia + Pacific",1.994,78.546999999999997,419772]
[null,"Bulgaria","Europe",1.5409999999999999,73.549000000000007,7349462]
[null,"Burkina Faso","Africa",5.6050000000000004,56.344000000000001,18011507]
[null,"Burundi","Africa",6.0330000000000004,54.103999999999999,8911183]
[null,"Cambodia","Asia + Pacific",2.8610000000000002,71.915999999999997,14656016]
[null,"Cameroon","Africa",4.78,55.064999999999998,20913595]
[null,"Canada","North America",1.67,81.481999999999999,34993747]
[null,"Cape Verde","Africa",2.2919999999999998,75.093000000000004,510213]
[null,"Central African Republic","Africa",4.3650000000000002,50.179000000000002,4666833]
[null,"Chad","Africa",6.2629999999999999,51.182000000000002,12141876]
[null,"Channel Islands","Europe",1.4590000000000001,80.323999999999998,154432]
[null,"Chile","Latin America + Caribbean",1.82,79.954999999999998,17574464]
[null,"China","Asia + Pacific",1.6679999999999999,75.331000000000003,1359368470]
[null,"Colombia","Latin America + Caribbean",2.286,74.037999999999997,48165221]
[null,"Comoros","Africa",4.7140000000000004,60.874000000000002,792913]
[null,"Congo, Dem. Republic","Africa",5.9329999999999998,49.963000000000001,71419669]
[null,"Congo, Republic","Africa",4.9690000000000003,58.792999999999999,4324199]
[null,"Costa Rica","Latin America + Caribbean",1.7949999999999999,79.930000000000007,4859957]
[null,"Cote d'Ivoire","Africa",4.8659999999999997,50.722000000000001,21057316]
[null,"Croatia","Europe",1.5009999999999999,77.048000000000002,4378806]
[null,"Cuba","Latin America + Caribbean",1.4490000000000001,79.262,11244424]
[null,"Cyprus","Europe",1.4610000000000001,79.840999999999994,1141453]
[null,"Czech Republic","Europe",1.5660000000000001,77.69,10589806]
[null,"Denmark","Europe",1.88,79.388000000000005,5611187]
[null,"Djibouti","Africa",3.387,61.801000000000002,940090]
[null,"Dominican Republic","Latin America + Caribbean",2.484,73.402000000000001,10308609]
[null,"Ecuador","Latin America + Caribbean",2.5590000000000002,76.471000000000004,15061398]
[null,"Egypt","Africa",2.77,71.156999999999996,85378440]
[null,"El Salvador","Latin America + Caribbean",2.1840000000000002,72.599000000000004,6302723]
[null,"Equatorial Guinea","Africa",4.8449999999999998,53.061999999999998,761050]
[null,"Eritrea","Africa",4.6959999999999997,62.851999999999997,5748304]
[null,"Estonia","Europe",1.6040000000000001,74.441000000000003,1338832]
[null,"Ethiopia","Africa",4.5190000000000001,63.634999999999998,88356373]
[null,"Fiji","Asia + Pacific",2.5880000000000001,69.81,882863]
[null,"Finland","Europe",1.853,80.534999999999997,5418763]
[null,"France","Europe",1.98,81.81,63782963]
[null,"French Guiana","Latin America + Caribbean",3.0579999999999998,77.120999999999995,249408]
[null,"French Polynesia","Asia + Pacific",2.0579999999999998,76.257000000000005,279632]
[null,"Gabon","Africa",4.0869999999999997,63.48,1594205]
[null,"Gambia","Africa",5.7510000000000003,58.817999999999998,1874360]
[null,"Georgia","Europe",1.8169999999999999,74.301000000000002,4278410]
[null,"Germany","Europe",1.419,80.742999999999995,81804228]
[null,"Ghana","Africa",3.8570000000000002,61.131999999999998,26131336]
[null,"Greece","Europe",1.5289999999999999,80.77,11445691]
[null,"Grenada","Latin America + Caribbean",2.17,72.768000000000001,105719]
[null,"Guadeloupe","Latin America + Caribbean",2.08,80.947000000000003,467335]
[null,"Guam","Asia + Pacific",2.4049999999999998,78.853999999999999,186562]
[null,"Guatemala","Latin America + Caribbean",3.7829999999999999,72.099000000000004,15527502]
[null,"Guinea","Africa",4.915,56.112000000000002,10753680]
[null,"Guinea-Bissau","Africa",4.9269999999999996,54.290999999999997,1612913]
[null,"Guyana","Latin America + Caribbean",2.5459999999999998,66.295000000000002,759262]
[null,"Haiti","Latin America + Caribbean",3.1480000000000001,63.101999999999997,10388424]
[null,"Honduras","Latin America + Caribbean",3.0009999999999999,73.816999999999993,8071522]
[null,"Hong Kong, China","Asia + Pacific",1.135,83.378,7274125]
[null,"Hungary","Europe",1.411,74.62,9933795]
[null,"Iceland","Europe",2.0830000000000002,82.085999999999999,331996]
[null,"India","Asia + Pacific",2.4790000000000001,66.414000000000001,1275137828]
[null,"Indonesia","Asia + Pacific",2.3380000000000001,70.832999999999998,247188189]
[null,"Iran","Asia + Pacific",1.92,74.048000000000002,76407013]
[null,"Iraq","West Asia",4.0259999999999998,69.418999999999997,34776205]
[null,"Ireland","Europe",1.9970000000000001,80.706999999999994,4631391]
[null,"Israel","Europe",2.8980000000000001,81.801000000000002,7818860]
[null,"Italy","Europe",1.4870000000000001,82.385000000000005,61087395]
[null,"Jamaica","Latin America + Caribbean",2.2599999999999998,73.525000000000006,2771179]
[null,"Japan","Asia + Pacific",1.419,83.58,126345235]
[null,"Jordan","West Asia",3.2440000000000002,73.853999999999999,6572903]
[null,"Kazakhstan","Asia + Pacific",2.4550000000000001,66.536000000000001,16550975]
[null,"Kenya","Africa",4.3819999999999997,61.716000000000001,43923719]
[null,"Kiribati","Asia + Pacific",2.952,68.905000000000001,104251]
[null,"Korea, Dem. Republic","Asia + Pacific",1.988,69.998999999999995,24654358]
[null,"Korea, Republic","Asia + Pacific",1.321,81.534999999999997,48774767]
[null,"Kuwait","West Asia",2.6,74.287999999999997,2959015]
[null,"Kyrgyzstan","Asia + Pacific",3.0750000000000002,67.533000000000001,5503253]
[null,"Laos","Asia + Pacific",3.02,68.308999999999997,6458911]
[null,"Latvia","Europe",1.607,72.150000000000006,2226260]
[null,"Lebanon","West Asia",1.4950000000000001,80.007000000000005,4324060]
[null,"Lesotho","Africa",3.0379999999999998,49.445999999999998,2240126]
[null,"Liberia","Africa",4.7919999999999998,60.555999999999997,4348740]
[null,"Libya","Africa",2.3559999999999999,75.325000000000003,6506095]
[null,"Lithuania","Europe",1.5189999999999999,72.11,3278337]
[null,"Luxembourg","Europe",1.671,80.546999999999997,530018]
[null,"Macao, China","Asia + Pacific",1.083,80.400000000000006,578844]
[null,"Macedonia, FYR","Europe",1.431,75.197999999999993,2069219]
[null,"Madagascar","Africa",4.468,64.722999999999999,22555046]
[null,"Malawi","Africa",5.3890000000000002,55.311,16406945]
[null,"Malaysia","Asia + Pacific",1.964,75.016999999999996,29787203]
[null,"Maldives","Asia + Pacific",2.2559999999999998,77.918999999999997,328551]
[null,"Mali","Africa",6.8470000000000004,55.031999999999996,16808242]
[null,"Malta","Europe",1.3560000000000001,79.75,420557]
[null,"Martinique","Latin America + Caribbean",1.827,81.41,409366]
[null,"Mauritania","Africa",4.67,61.55,3704414]
[null,"Mauritius","Africa",1.5009999999999999,73.613,1320785]
[null,"Mayotte","Africa",3.802,79.19,223907]
[null,"Mexico","Latin America + Caribbean",2.1850000000000001,77.501000000000005,117478371]
[null,"Micronesia, Fed. Sts.","Asia + Pacific",3.294,68.992999999999995,112726]
[null,"Moldova","Europe",1.456,68.899000000000001,3495657]
[null,"Mongolia","Asia + Pacific",2.4359999999999999,67.503,2887863]
[null,"Montenegro","Europe",1.6659999999999999,74.820999999999998,633167]
[null,"Morocco","Africa",2.7349999999999999,70.941000000000003,32925553]
[null,"Mozambique","Africa",5.1879999999999997,50.25,25028313]
[null,"Myanmar","Asia + Pacific",1.9379999999999999,65.176000000000002,49119646]
[null,"Namibia","Africa",3.0510000000000002,64.483000000000004,2404477]
[null,"Nepal","Asia + Pacific",2.2999999999999998,68.41,31535507]
[null,"Netherlands","Europe",1.774,81.037999999999997,16761552]
[null,"Netherlands Antilles","Latin America + Caribbean",1.89,76.894000000000005,205860]
[null,"New Caledonia","Asia + Pacific",2.1269999999999998,76.305999999999997,262605]
[null,"New Zealand","Asia + Pacific",2.052,81.132000000000005,4508166]
[null,"Nicaragua","Latin America + Caribbean",2.4980000000000002,74.838999999999999,6041763]
[null,"Niger","Africa",7.5609999999999999,58.408999999999999,17239826]
[null,"Nigeria","Africa",5.976,52.506,170901148]
[null,"Norway","Europe",1.931,81.503,4991997]
[null,"Oman","West Asia",2.8530000000000002,76.552000000000007,2957333]
[null,"Pakistan","Asia + Pacific",3.1850000000000001,66.569999999999993,183188847]
[null,"Panama","Latin America + Caribbean",2.4660000000000002,77.555999999999997,3678264]
[null,"Papua New Guinea","Asia + Pacific",3.7810000000000001,62.420999999999999,7327281]
[null,"Paraguay","Latin America + Caribbean",2.8639999999999999,72.259,6798236]
[null,"Peru","Latin America + Caribbean",2.4169999999999998,74.825999999999993,30075185]
[null,"Philippines","Asia + Pacific",3.0430000000000001,68.703000000000003,98112780]
[null,"Poland","Europe",1.417,76.408000000000001,38331803]
[null,"Portugal","Europe",1.3149999999999999,79.944999999999993,10704534]
[null,"Puerto Rico","Latin America + Caribbean",1.6359999999999999,78.864000000000004,3742334]
[null,"Qatar","West Asia",2.0190000000000001,78.369,1976840]
[null,"Reunion","Africa",2.2320000000000002,79.646000000000001,874944]
[null,"Romania","Europe",1.417,73.831000000000003,21338815]
[null,"Russia","Europe",1.538,67.978999999999999,142557892]
[null,"Rwanda","Africa",4.508,64.066000000000003,11608439]
[null,"Saint Lucia","Latin America + Caribbean",1.9119999999999999,74.804000000000002,179515]
[null,"Saint Vincent and the Grenadines","Latin America + Caribbean",1.9970000000000001,72.488,109354]
[null,"Samoa","Asia + Pacific",4.1470000000000002,73.156000000000006,185727]
[null,"Sao Tome and Principe","Africa",4.0750000000000002,66.337000000000003,175383]
[null,"Saudi Arabia","West Asia",2.6440000000000001,75.478999999999999,29319402]
[null,"Senegal","Africa",4.9340000000000002,63.451000000000001,13454191]
[null,"Serbia","Europe",1.365,74.058999999999997,9835010]
[null,"Seychelles","Africa",2.1800000000000002,73.186999999999998,87417]
[null,"Sierra Leone","Africa",4.7050000000000001,45.561,6255163]
[null,"Singapore","Asia + Pacific",1.282,82.322000000000003,5300914]
[null,"Slovak Republic","Europe",1.3959999999999999,75.397000000000006,5488775]
[null,"Slovenia","Europe",1.5089999999999999,79.590999999999994,2044766]
[null,"Solomon Islands","Asia + Pacific",4.0309999999999997,67.674999999999997,580791]
[null,"Somalia","Africa",6.5629999999999997,55.05,10052842]
[null,"South Africa","Africa",2.387,56.915999999999997,50981076]
[null,"South Sudan","Africa",4.92,55.264000000000003,10881979]
[null,"Spain","Europe",1.5049999999999999,82.1,47042602]
[null,"Sri Lanka","Asia + Pacific",2.339,74.293000000000006,21393876]
[null,"Sudan","Africa",4.42,62.055,35940905]
[null,"Suriname","Latin America + Caribbean",2.2679999999999998,71.019000000000005,538882]
[null,"Swaziland","Africa",3.3340000000000001,49,1237166]
[null,"Sweden","Europe",1.9279999999999999,81.817999999999998,9545823]
[null,"Switzerland","Europe",1.5329999999999999,82.603999999999999,7761820]
[null,"Syria","West Asia",2.964,71,21468962]
[null,"Taiwan","Asia + Pacific",1.2649999999999999,79.45,23114000]
[null,"Tajikistan","Asia + Pacific",3.8149999999999999,67.248000000000005,7183529]
[null,"Tanzania","Africa",5.2140000000000004,61.53,49153002]
[null,"Thailand","Asia + Pacific",1.399,74.400999999999996,70243267]
[null,"Timor-Leste","Asia + Pacific",5.8550000000000004,67.537999999999997,1223665]
[null,"Togo","Africa",4.6390000000000002,56.536999999999999,6412560]
[null,"Tonga","Asia + Pacific",3.7669999999999999,72.673000000000002,105265]
[null,"Trinidad and Tobago","Latin America + Caribbean",1.7969999999999999,69.864999999999995,1355342]
[null,"Tunisia","Africa",2.008,75.873000000000005,10813680]
[null,"Turkey","Europe",2.0409999999999999,75.259,75359032]
[null,"Turkmenistan","Asia + Pacific",2.3260000000000001,65.451999999999998,5234640]
[null,"Uganda","Africa",5.867,59.209000000000003,36759274]
[null,"Ukraine","Europe",1.47,68.525000000000006,44696741]
[null,"United Arab Emirates","West Asia",1.8009999999999999,76.840999999999994,8207940]
[null,"United Kingdom","Europe",1.8919999999999999,80.546999999999997,63177406]
[null,"United States","North America",1.976,78.941000000000003,318497630]
[null,"Uruguay","Latin America + Caribbean",2.0459999999999998,77.23,3403117]
[null,"Uzbekistan","Asia + Pacific",2.3090000000000002,68.241,28398155]
[null,"Vanuatu","Asia + Pacific",3.3820000000000001,71.626000000000005,257812]
[null,"Venezuela","Latin America + Caribbean",2.39,74.632999999999996,30340637]
[null,"Vietnam","Asia + Pacific",1.7430000000000001,75.944999999999993,90656550]
[null,"Virgin Islands (U.S.)","North America",2.4870000000000001,80.152000000000001,108300]
[null,"West Bank and Gaza","West Asia",4.01,73.203000000000003,4393572]
[null,"Western Sahara","Africa",2.363,67.763999999999996,585270]
[null,"Yemen, Republic","West Asia",4.0750000000000002,63.112000000000002,26358020]
[null,"Zambia","Africa",5.6870000000000003,58.104999999999997,14314515]
[null,"Zimbabwe","Africa",3.4860000000000002,59.871000000000002,13327925]

{"sheet":"Tooltips","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tooltip"]
[]
[null,"Chart",1]
[null,"Point Index",4]
[]
[null,{"$f":"INDEX(tab_data[Country],Tooltips!$C$5)","v":"Angola"},null,null,{"$f":"IFERROR(INDEX(tab_continents[Region],myPointIndex),\"\")","v":"North America"}]
[null,{"$f":"INDEX(tab_data[Region],Tooltips!$C$5)","v":"Africa"},null,null,"-"]
[]
[null,"Fertility Rate",{"$f":"INDEX(tab_data[Fertility Rate],myPointIndex)","v":5.8630000000000004},null,"Average Fertility Rate",{"$f":"IFERROR(INDEX(tab_continents[Avg. Fertility Rate],myPointIndex),\"\")","v":2.0554999999999999}]
[null,"Life Expectancy",{"$f":"INDEX(tab_data[Life Expectancy],myPointIndex)","v":51.899000000000001},null,"Average Life Expectancy",{"$f":"IFERROR(INDEX(tab_continents[Avg. Life Expectancy],myPointIndex),\"\")","v":79.132249999999999}]
[null,"Population",{"$f":"INDEX(tab_data[Population],myPointIndex)","v":20714494},null,"Sum Population",{"$f":"IFERROR(INDEX(tab_continents[Sum Population],myPointIndex),\"\")","v":353691081}]
[]
[]
[null,{"$f":"CHOOSE(myChartIndex,B7,E7)","v":"Angola"}]
[null,{"$f":"CHOOSE(myChartIndex,B8,E8)","v":"Africa"}]
[]
[null,{"$f":"CHOOSE(myChartIndex,B10,E10)","v":"Fertility Rate"},5.8630000000000004]
[null,"Life Expectancy",51.899000000000001]
[null,"Population",20714494]