{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Carte","Liste"],"not_rendered":{"charts":0,"images":1,"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":"Carte","index":0,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,"http://tatiak.canalblog.com/",null,null,"Fond de carte : openstreetmap.org",null,null,null,null,"Données géographiques :","https://data.opendatasoft.com/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ville","CADILLAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Insee",33081]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Population",2785]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F/H","1311/1474"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%pop/Total",3.3466719540478508E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CH "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La fue "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medville "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pohe"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Echelle couleurs"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I2","v":"<100"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I3","v":"100 - 500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I4","v":"500 - 1000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I5","v":"1000 - 1500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I6","v":"1500 - 2000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I7","v":"2000 - 2500"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I8","v":"2500 - 3000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I9","v":"3000 - 4000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I10","v":"4000 - 5000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Liste!I11","v":"5000 - 6000"}]

{"sheet":"Liste","index":1,"n_rows":74,"n_cols":20,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Ville","N° shape","INSEE","population","F/H","%pop/Total","N°Couleur",null,"Echelle","Couleur","Limite","Echelle de dégradé de couleur",null,"NbPh","Shape","Pharmacies liste","Pharmacie N°1","Pharmacie N°2","Pharmacie N°3","Pharmacie N°4"]
["BAIGNEAUX",130,33025,445,"228/217",{"$f":"D2/SUM($D$2:$D$73)","v":5.3474650612254709E-3},{"$f":"IFERROR(1+MATCH(D2,$K$2:$K$11,1),1)","v":2},1,"<100",8519679,100,"Couleur de départ",null,{"$f":"COUNTIF(Q2:U2,\"*\")","v":4},{"$f":"INDEX(B:B,MATCH(P2,A:A,0))","v":168},"Cadillac","CH ","La fue ","Medville ","Pohe"]
["BARON",256,30030,348,"171/177",{"$f":"D3/SUM($D$2:$D$73)","v":4.1818378456325031E-3},{"$f":"IFERROR(1+MATCH(D3,$K$2:$K$11,1),1)","v":2},{"$f":"H2+1","v":2},{"$f":"K2& \" - \" &K3","v":"100 - 500"},7602147,500,"Couleur de fin",null,{"$f":"COUNTIF(Q3:U3,\"*\")","v":2},{"$f":"INDEX(B:B,MATCH(P3,A:A,0))","v":525},"Créon","Bordages ","Entre 2 mers"]
["BAURECH",107,33033,965,"491/474",1.1596188278837257E-2,3,{"$f":"H3+1","v":3},{"$f":"K3& \" - \" &K4","v":"500 - 1000"},6684615,1000,null,null,1,155,"Sadirac","Langlade"]
["BELLEBAT",320,33043,323,"166/157",3.8814184601703981E-3,2,4,"1000 - 1500",5701547,{"$f":"K4+500","v":1500},"Couleur de la sélection",null,1,540,"La Sauve","Tournier Gondat"]
["BELLEFOND",67,33044,214,"107/107",2.5715899395556195E-3,2,5,"1500 - 2000",4784015,{"$f":"K5+500","v":2000},null,null,1,171,"Cénac","Sous lalet"]
["BLÉSIGNAC",49,33059,310,"155/155",3.7252003797301034E-3,2,6,"2000 - 2500",3866483,2500,"Modifiez les couleurs de M2,M3,M5",null,2,531,"Latresne","Bouvier Massabova","Lalou "]
["BONNETAN",321,33061,1024,"518/506",1.2305178028527824E-2,4,7,"2500 - 3000",2948951,3000,"Puis appuyez sur le bouton ci-dessous",null,1,202,"Carignan-De-Bordeaux","Simonnet"]
["BÉGUEY",66,33040,1208,"627/581",1.4516264705528919E-2,4,8,"3000 - 4000",2031419,4000,"pour définir les couleurs désirées.",null,1,268,"Paillet","Subra"]
["CADILLAC",168,33081,2785,"1311/1474",3.3466719540478508E-2,7,9,"4000 - 5000",1048351,5000,null,null,1,530,"Langoiran","Labussiere"]
["CAMARSAC",217,33083,1022,"525/497",1.2281144477690856E-2,4,{"$f":"H10+1","v":10},"5000 - 6000",130819,6000,null,null,1,541,"Tabanac","Labussiere"]
["CAMBES",485,33084,1810,"915/895",2.1750363507456408E-2,5,null,null,null,null,null,null,1,435,"Sallebœuf","Pharma de salleboeuf"]
["CAMBLANES-ET-MEYNAC",69,33085,3093,"1577/1516",3.7167886369371642E-2,8,null,null,null,null,null,null,2,516,"Tresses","Du poteau","Du centre"]
["CAMIAC-ET-SAINT-DENIS",261,33086,362,"188/174",4.3500727014912817E-3,2,null,null,null,null,null,null,1,7,"Fargues-Saint-Hilaire","Des bons enfants"]
["CAPIAN",377,33093,787,"379/408",9.4572022543470691E-3,3,null,null,null,null,null,null,1,515,"Sauveterre-De-Guyenne","Des arcades"]
["CARDAN",284,33098,515,"257/258",6.1886393405193654E-3,3,null,null,null,null,null,null,1,462,"Targon","Pharma de targon "]
["CARIGNAN-DE-BORDEAUX",202,33099,4237,"2183/2054",5.0915077448117574E-2,9,null,null,null,null,null,null,1,69,"Camblanes-Et-Meynac","Paharma de camblanes"]
["CASTELVIEL",487,33105,208,"103/105",2.4994892870447145E-3,2,null,null,null,null,null,null,1,92,"Quinsac","Lorenzi"]
["CESSAC",402,33121,195,"102/93",2.3432712066044198E-3,2,null,null,null,null,null,null,1,421,"Frontenac","Pharma de frontenac"]
["COURPIAC",263,33135,124,"60/64",1.4900801518920412E-3,2,null,null,null,null,null,null,1,153,"Pompignac","Dop merlin"]
["CROIGNON",467,33141,735,"346/389",8.8323299325858903E-3,3,null,null,null,null,null,null,2,485,"Cambes","Maison de santé H","di battista"]
["CRÉON",525,33140,4880,"2640/2240",5.8641864042202917E-2,9,null,null,null,null,null,null,1,156,"Saint-Caprais-De-Bordeaux","Baudin balere"]
["CURSAN",325,33145,664,"333/331",7.9791388778735119E-3,3,null,null,null,null,null,null,1,{"$f":"INDEX(B:B,MATCH(P23,A:A,0))","v":259},"Blazimon","Brodu jamet"]
["CÉNAC",171,33118,2131,"1077/1054",2.5607748416789838E-2,6]
["COIRAC",25,33131,215,"110/105",2.5836067149741038E-3,2]
["DARDENAC",87,33148,91,"43/48",1.0935265630820626E-3,1]
["DAUBÈZE",378,33149,151,"78/73",1.8145330881911149E-3,2]
["DONZAC",150,33152,119,"66/53",1.4299962747996203E-3,2]
["ESCOUSSANS",111,33156,279,"145/134",3.3526803417570929E-3,2]
["ESPIET",469,33157,764,"379/385",9.1808164197219322E-3,3]
["FALEYRAS",404,33163,426,"226/200",5.1191463282742712E-3,2]
["FARGUES-SAINT-HILAIRE",7,33165,3404,"1789/1624",4.0905103524520231E-2,8]
["FRONTENAC",421,33175,767,"378/389",9.2168667459773847E-3,3]
["GABARNAC",88,33176,356,"178/178",4.2779720489803767E-3,2]
["HAUX",509,33201,837,"435/402",1.0058041025271278E-2,3]
["LA SAUVE",540,33505,1586,"783/803",1.9058605813715948E-2,5]
["LADAUX",287,33215,190,"95/95",2.2831873295119987E-3,2]
["LANGOIRAN",530,33226,2191,"1072/119",2.6328754941898892E-2,6]
["LAROQUE",347,33231,288,"136/152",3.4608313205234508E-3,2]
["LATRESNE",531,33234,3639,"1892/1747",4.3729045747864015E-2,8]
["LE POUT",177,33335,619,"290/329",7.438383984041722E-3,3]
["LE TOURNE",505,33534,824,"416/408",9.9018229448309836E-3,3]
["LESTIAC-SUR-GARONNE",449,33241,584,"303/281",7.0177968443947752E-3,3]
["LIGNAN-DE-BORDEAUX",329,33245,836,"396/440",1.0046024249852795E-2,3]
["LOUPES",472,33252,916,"450/466",1.1007366283331531E-2,3]
["LOUPIAC",533,33253,1097,"561/536",1.3182402634077172E-2,4]
["LUGASSON",174,33258,317,"162/155",3.8093178076594927E-3,2]
["MADIRAC",243,33263,298,"158/140",3.5809990747082926E-3,2]
["MARTRES",141,33275,100,"47/53",1.2016775418484205E-3,2]
["MONPRIMBLANC",30,33288,280,"139/141",3.3646971171755772E-3,2]
["MONTIGNAC",222,33292,135,"63/72",1.6222646814953675E-3,2]
["OMET",209,33308,299,"149/150",3.5930158501267769E-3,2]
["PAILLET",268,33311,1207,"604/603",1.4504247930110434E-2,4]
["POMPIGNAC",153,33330,3393,"1714/1679",4.0772918994916904E-2,8]
["PORTE-DE-BENAUGE",319,33008,500,"263/237",6.0083877092421021E-3,3]
["QUINSAC",92,33349,2215,"1086/1129",2.6617157551942511E-2,6]
["RIONS",333,33355,1500,"754/746",1.8025163127726306E-2,5]
["ROMAGNE",211,33358,477,"230/247",5.7320018746169652E-3,2]
["SADIRAC",155,33363,4687,"2372/2315",5.6322626386435461E-2,9]
["SAINT-BRICE",58,33379,314,"163/151",3.7732674814040402E-3,2]
["SAINT-CAPRAIS-DE-BORDEAUX",156,33381,3440,"1779/1661",4.1337707439585661E-2,8]
["SAINT-GENIS-DU-BOIS",121,33409,86,"46/40",1.0334426859896415E-3,1]
["SAINT-GENÈS-DE-LOMBAUD",476,33408,384,"191/193",4.6144417606979347E-3,2]
["SAINT-LÉON",458,33431,312,"156/156",3.7492339305670716E-3,2]
["SAINT-SULPICE-DE-POMMIERS",82,33482,263,"135/128",3.1604119350613457E-3,2]
["SAINTE-CROIX-DU-MONT",157,33392,845,"428/417",1.0154175228619153E-2,3]
["SALLEBŒUF",435,33496,2728,"1418/1310",{"$f":"D67/SUM($D$2:$D$73)","v":3.2781763341624907E-2},{"$f":"IFERROR(1+MATCH(D67,$K$2:$K$11,1),1)","v":7}]
["SAUVETERRE-DE-GUYENNE",515,33506,1868,"968/900",2.2447336481728492E-2,5]
["SOULIGNAC",198,33515,417,"202/215",5.0109953495079129E-3,2]
["TABANAC",541,33518,1085,"545/540",1.3038201329055362E-2,4]
["TARGON",462,33523,2044,"1085/959",2.4562288955381713E-2,6]
["TRESSES",516,33535,5086,"2641/2445",6.1117319778410659E-2,10]
["VILLENAVE-DE-RIONS",164,33549,373,"196/177",4.4822572310946078E-3,2]
["BLAZIMON",259,33540,940,"470/470",1.1295768893375151E-2,3]