{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Synthèse","Détaillé","Paramètres"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":1,"defined_names":1,"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":"Synthèse","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,"REGLEMENTS EUROPEENS"]
[]
[]
[]
[null,"Paiements des prestations en espèces d'incapacité temporaire (assurances"]
[null,{"$f":"\"accident du travail-maladie professionnelle) en \"&Détaillé!$U$2","v":"accident du travail-maladie professionnelle) en 2016"}]
[]
[null,null,"Résidence hors de l'Etat compétent",null,null,"Séjour temporaire-Transfert de résidence autorisé",null,null,"Total des"]
[null,"Pays","Nombre de","Nombre de jours","Montant ","Nombre de","Nombre de jours","Montant ","montants"]
[null,null,"bénéficiaires","indemnisés","(euros)","bénéficiaires","indemnisés","(euros)","(euros)"]
[null,"Allemagne",16,1101,63578.93,53,600,31832.95,{"$f":"E11+H11","v":95411.88}]
[null,"Autriche",0,0,0,23,276,21216.25,{"$f":"E12+H12","v":21216.25}]
[null,"Belgique",136,10803,572881.78,24,280,13590.73,{"$f":"E13+H13","v":586472.51},null,1,{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K13),$I$11:$I$41,0),1)","v":"Portugal"},{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K13),$I$11:$I$41,0),8)","v":1692809.0100000002},{"$f":"MAX(I11:I41)*1.1","v":1862089.9110000003}]
[null,"Bulgarie",1,8,330.8,6,57,4247.28,4578.08,null,{"$f":"K13+1","v":2},{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K14),$I$11:$I$41,0),1)","v":"Belgique"},{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K14),$I$11:$I$41,0),8)","v":586472.51}]
[null,"Chypre",2,24,1155.5999999999999,1,7,597,1752.6,null,{"$f":"K14+1","v":3},{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K15),$I$11:$I$41,0),1)","v":"Espagne"},{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K15),$I$11:$I$41,0),8)","v":445665.61}]
[null,"Croatie",0,0,0,12,166,8739.83,8739.83,null,4,{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K16),$I$11:$I$41,0),1)","v":"Italie"},{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K16),$I$11:$I$41,0),8)","v":348394.63}]
[null,"Danemark",0,0,0,0,0,0,0,null,5,{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K17),$I$11:$I$41,0),1)","v":"Allemagne"},{"$f":"INDEX($B$11:$I$41,MATCH(LARGE($I$11:$I$41,$K17),$I$11:$I$41,0),8)","v":95411.88}]
[null,"Espagne",59,2798,125908.06,{"$f":"395+1","v":396},{"$f":"5832+8","v":5840},{"$f":"319369.07+388.48","v":319757.55},{"$f":"E18+H18","v":445665.61}]
[null,"Estonie",0,0,0,0,0,0,0]
[null,"Finlande",0,0,0,0,0,0,0]
[null,"Grèce",1,9,670.41,46,496,27651.93,28322.34]
[null,"Hongrie",27,1023,37711.08,4,58,2897.83,40608.910000000003]
[null,"Irlande",0,0,0,8,76,5267.25,5267.25]
[null,"Islande",1,23,1230,1,19,683.81,1913.81]
[null,"Italie",72,4132,188273.94,181,2802,160120.69,348394.63]
[null,"Lettonie",1,150,6496.72,0,0,0,6496.72]
[null,"Liechtenstein",0,0,0,0,0,0,0]
[null,"Lituanie",1,29,951.03,1,7,524.09,1475.12]
[null,"Luxembourg",2,12,775.66,4,64,3107.03,3882.69]
[null,"Malte",0,0,0,3,25,1211.5,1211.5]
[null,"Norvège",0,0,0,0,0,0,0]
[null,"Pays-Bas",1,81,5644.8,9,97,3875.41,9520.2099999999991]
[null,"Pologne",38,869,36492.879999999997,39,829,44247.509999999995,80740.389999999985]
[null,"Portugal",36,1341,54159.600000000006,1213,29528,1638649.4100000001,1692809.0100000002]
[null,"République tchèque",0,0,0,7,116,6306.99,6306.99]
[null,"Roumanie",1,20,943,21,464,24945.89,25888.89]
[null,"Royaume-Uni",1,392,20140.96,28,197,11411.49,31552.449999999997]
[null,"Slovaquie",3,139,5071.3999999999996,2,33,1702.52,6773.92]
[null,"Slovénie",0,0,0,1,23,1261.32,1261.32]
[null,"Suède",0,0,0,2,12,815.88,815.88]
[null,"Suisse",6,123,6550.55,15,110,4888.51,{"$f":"E41+H41","v":11439.060000000001}]
[null,{"$f":"\"Total \"&Détaillé!$U$2","v":"Total 2016"},{"$f":"SUM(C11:C41)","v":405},{"$f":"SUM(D11:D41)","v":23077},{"$f":"SUM(E11:E41)","v":1128967.2000000002},2100,42182,2339550.6500000004,{"$f":"IF(SUM(I11:I41)=E42+H42,SUM(I11:I41),\"Faux\")","v":3468517.85}]
[null,{"$f":"\"Total \"&Détaillé!$U$2-1","v":"Total 2015"},425,24602,1161642.1299999999,2252,48243,2601858.7299999995,{"$f":"E43+H43","v":3763500.8599999994}]
[null,"% évolution",{"$f":"IF(C43<>0,(C42-C43)/C43*100,\"-\")","v":-4.7058823529411766},{"$f":"IF(D43<>0,(D42-D43)/D43*100,\"-\")","v":-6.198683033899683},-2.8128223965155006,-6.74955595026643,-12.563480712227681,-10.081565035623559,{"$f":"IF(I43<>0,(I42-I43)/I43*100,\"-\")","v":-7.837995020412972}]
[]
[]
[]
[]
[]
[]
["Evolution sur 10 ans des prestations en espèces d'incapacité temporaire (assurances AT-MP)"]
[]
[null,"Résidence hors de l'Etat compétent",null,null,"Séjour temporaire / Transfert de résidence autorisé",null,null,"Total"]
[null,"Nombre de","Nombre","Montant","Nombre de","Nombre","Montant","Nombre de","Montant","%"]
["Année","béné","de jours","(euros)","béné","de jours","(euros)","béné","(euros)","évolu-"]
[null,"ficiaires","indemnisés",null,"ficiaires","indemnisés",null,"ficiaires",null,"tion"]
[2007,243,10897,454166.36,2325,62837,3168186.83,{"$f":"B57+E57","v":2568},{"$f":"G57+D57","v":3622353.19}]
[2008,313,16336,742938.42,2500,62206,3068767.38,{"$f":"B58+E58","v":2813},{"$f":"G58+D58","v":3811705.8},{"$f":"(I58-I57)/I57*100","v":5.2273370394342988}]
[2009,272,19277,875996.38,2497,61482,3077703.1,2769,{"$f":"G59+D59","v":3953699.48},3.7252004076495142]
[2010,280,21627,915794.11,2307,57673,2862705.38,2587,3778499.4899999998,-4.4312925371859633]
[2011,404,23275,1084726.47,2487,58955,3152487.52,2891,4237213.99,12.140123380035192]
[2012,324,19755,1037648.88,2150,48452,2593758.36,2474,3631407.2399999998,-14.297289479118341]
[2013,409,23818,1161712.9099999999,2070,45700,2368410.36,2479,3530123.2699999996,-2.7891107580652457]
[2014,487,26863,1141745.55,1950,39256,2242393.62,2437,3384139.17,-4.1353825018127388]
[2015,425,24602,1161642.1299999999,2252,48243,2601858.73,2677,3763500.86,11.209990811341248]
[2016,405,23077,1128967.2,2100,42182,2339550.65,2505,3468517.8499999996,-7.8379950204129951]

{"sheet":"Détaillé","index":1,"n_rows":202,"n_cols":21,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["REGLEMENTS EUROPEENS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"INDEX(ListePays,$T$1,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aller directement vers :"]
[]
["Paiements des prestations en espèces d'incapacité temporaire"]
["(assurances AT-MP)"]
[]
[null,null,"Résidence hors de l'Etat compétent",null,null,"Séjour temporaire-Transfert autorisé",null,null,"Total des     "]
["Pays","Régime","Nombre de","Nombre de jours","Montant ","Nombre de","Nombre de jours","Montant ","montants"]
[null,null,"bénéficiaires","indemnisés","(euros)","bénéficiaires","indemnisés","(euros)","(euros)"]
[null,"Général",16,1101,63578.93,53,600,31832.95,{"$f":"E11+H11","v":95411.88}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E12+H12","v":0}]
["Allemagne","Minier",0,0,0,0,0,0,{"$f":"E13+H13","v":0}]
[null," Total 2016",{"$f":"SUM(C11:C13)","v":16},1101,63578.93,53,600,31832.95,{"$f":"IF($E14+$H14=SUM($I11:$I13), $E14+$H14,\"FAUX\")","v":95411.88}]
[null," Total 2015",18,1036,47030.239999999998,51,808,43597.89,{"$f":"E15+H15","v":90628.13}]
[null," %  d'évolution",{"$f":"IF(C15<> 0,((C14-C15)/C15*100),\"  -  \")","v":-11.111111111111111},{"$f":"IF(D15<>0,((D14-D15)/D15*100),\"  -  \")","v":6.2741312741312738},35.187339039732741,3.9215686274509802,-25.742574257425744,-26.985113270389917,5.2784383833143194]
[null,"Général",0,0,0,23,276,21216.25,{"$f":"E17+H17","v":21216.25}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E18+H18","v":0}]
["Autriche","Minier",0,0,0,0,0,0,{"$f":"E19+H19","v":0}]
[null," Total 2016",{"$f":"SUM(C17:C19)","v":0},0,0,23,276,21216.25,{"$f":"IF($E20+$H20=SUM($I17:$I19), $E20+$H20,\"FAUX\")","v":21216.25}]
[null," Total 2015",1,15,930,15,112,7171.7,{"$f":"E21+H21","v":8101.7}]
[null," %  d'évolution",{"$f":"IF(C21<> 0,((C20-C21)/C21*100),\"  -  \")","v":-100},{"$f":"IF(D21<>0,((D20-D21)/D21*100),\"  -  \")","v":-100},-100,53.333333333333336,146.42857142857142,195.83292664221872,161.87405112507253]
[null,"Général",129,10177,569949.18000000005,24,280,13590.73,{"$f":"E23+H23","v":583539.91}]
[null,"Agricole",7,626,2932.6,0,0,0,{"$f":"E24+H24","v":2932.6}]
["Belgique","Minier",0,0,0,0,0,0,{"$f":"E25+H25","v":0}]
[null," Total 2016",{"$f":"SUM(C23:C25)","v":136},10803,572881.78,24,280,13590.73,{"$f":"IF($E26+$H26=SUM($I23:$I25), $E26+$H26,\"FAUX\")","v":586472.51}]
[null," Total 2015",153,11302,558727.81000000006,40,551,28244.74,{"$f":"E27+H27","v":586972.55000000005}]
[null," %  d'évolution",{"$f":"IF(C27<> 0,((C26-C27)/C27*100),\"  -  \")","v":-11.111111111111111},{"$f":"IF(D27<>0,((D26-D27)/D27*100),\"  -  \")","v":-4.4151477614581491},2.5332495978676937,-40,-49.183303085299457,-51.882261971609587,-8.5189673690879958E-2]
[null,"Général",1,8,330.8,5,54,4117.38,{"$f":"E29+H29","v":4448.18}]
[null,"Agricole",0,0,0,1,3,129.9,{"$f":"E30+H30","v":129.9}]
["Bulgarie","Minier",0,0,0,0,0,0,{"$f":"E31+H31","v":0}]
[null," Total 2016",{"$f":"SUM(C29:C31)","v":1},8,330.8,6,57,4247.28,{"$f":"IF($E32+$H32=SUM($I29:$I31), $E32+$H32,\"FAUX\")","v":4578.08}]
[null," Total 2015",1,12,592.32000000000005,6,195,5624.1,{"$f":"E33+H33","v":6216.42}]
[null," %  d'évolution",{"$f":"IF(C33<> 0,((C32-C33)/C33*100),\"  -  \")","v":0},{"$f":"IF(D33<>0,((D32-D33)/D33*100),\"  -  \")","v":-33.333333333333329},-44.151809832522964,0,-70.769230769230774,-24.480716914706363,-26.355040360850779]
[null,"Général",2,24,1155.5999999999999,1,7,597,{"$f":"E35+H35","v":1752.6}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E36+H36","v":0}]
["Chypre","Minier",0,0,0,0,0,0,{"$f":"E37+H37","v":0}]
[null," Total 2016",{"$f":"SUM(C35:C37)","v":2},24,1155.5999999999999,1,7,597,{"$f":"IF($E38+$H38=SUM($I35:$I37), $E38+$H38,\"FAUX\")","v":1752.6}]
[null," Total 2015",0,0,0,1,4,116.76,{"$f":"E39+H39","v":116.76}]
[null," %  d'évolution",{"$f":"IF(C39<> 0,((C38-C39)/C39*100),\"  -  \")","v":"  -  "},{"$f":"IF(D39<>0,((D38-D39)/D39*100),\"  -  \")","v":"  -  "},"  -  ",0,75,411.30524152106887,1401.027749229188]
[null,"Général",0,0,0,12,166,8739.83,{"$f":"E41+H41","v":8739.83}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E42+H42","v":0}]
["Croatie","Minier",0,0,0,0,0,0,{"$f":"E43+H43","v":0}]
[null," Total 2016",{"$f":"SUM(C41:C43)","v":0},0,0,12,166,8739.83,{"$f":"IF($E44+$H44=SUM($I41:$I43), $E44+$H44,\"FAUX\")","v":8739.83}]
[null," Total 2015",0,0,0,24,404,19677.27,{"$f":"E45+H45","v":19677.27}]
[null," %  d'évolution",{"$f":"IF(C45<> 0,((C44-C45)/C45*100),\"  -  \")","v":"  -  "},{"$f":"IF(D45<>0,((D44-D45)/D45*100),\"  -  \")","v":"  -  "},"  -  ",-50,-58.910891089108908,-55.584133368094257,-55.584133368094257]
[null,"Général",0,0,0,0,0,0,{"$f":"E47+H47","v":0}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E48+H48","v":0}]
["Danemark","Minier",0,0,0,0,0,0,{"$f":"E49+H49","v":0}]
[null," Total 2016",{"$f":"SUM(C47:C49)","v":0},0,0,0,0,0,{"$f":"IF($E50+$H50=SUM($I47:$I49), $E50+$H50,\"FAUX\")","v":0}]
[null," Total 2015",0,0,0,4,82,4093.86,{"$f":"E51+H51","v":4093.86}]
[null," %  d'évolution",{"$f":"IF(C51<> 0,((C50-C51)/C51*100),\"  -  \")","v":"  -  "},{"$f":"IF(D51<>0,((D50-D51)/D51*100),\"  -  \")","v":"  -  "},"  -  ",-100,-100,-100,-100]
[null,"Général",21,367,16431.400000000001,{"$f":"385+1","v":386},{"$f":"5545+8","v":5553},{"$f":"310333.3+388.48","v":310721.77999999997},{"$f":"E53+H53","v":327153.18}]
[null,"Agricole",38,2431,109476.66,10,287,9035.77,{"$f":"E54+H54","v":118512.43000000001}]
["Espagne","Minier",0,0,0,0,0,0,{"$f":"E55+H55","v":0}]
[null," Total 2016",{"$f":"SUM(C53:C55)","v":59},2798,125908.06,396,5840,319757.55,{"$f":"IF($E56+$H56=SUM($I53:$I55), $E56+$H56,\"FAUX\")","v":445665.61}]
[null," Total 2015",55,2540,127036.21,438,7015,419164.17,{"$f":"E57+H57","v":546200.38}]
[null," %  d'évolution",{"$f":"IF(C57<> 0,((C56-C57)/C57*100),\"  -  \")","v":7.2727272727272725},{"$f":"IF(D57<>0,((D56-D57)/D57*100),\"  -  \")","v":10.15748031496063},-0.88805388636831084,-9.5890410958904102,-16.749821810406274,-23.715438273266535,-18.406206528087736]
[null,"Général",0,0,0,0,0,0,{"$f":"E59+H59","v":0}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E60+H60","v":0}]
["Estonie","Minier",0,0,0,0,0,0,{"$f":"E61+H61","v":0}]
[null," Total 2016",{"$f":"SUM(C59:C61)","v":0},0,0,0,0,0,{"$f":"IF($E62+$H62=SUM($I59:$I61), $E62+$H62,\"FAUX\")","v":0}]
[null," Total 2015",0,0,0,1,22,1373.02,{"$f":"E63+H63","v":1373.02}]
[null," %  d'évolution",{"$f":"IF(C63<> 0,((C62-C63)/C63*100),\"  -  \")","v":"  -  "},{"$f":"IF(D63<>0,((D62-D63)/D63*100),\"  -  \")","v":"  -  "},"  -  ",-100,-100,-100,-100]
[null,"Général",0,0,0,0,0,0,{"$f":"E65+H65","v":0}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E66+H66","v":0}]
["Finlande","Minier",0,0,0,0,0,0,{"$f":"E67+H67","v":0}]
[null," Total 2016",{"$f":"SUM(C65:C67)","v":0},0,0,0,0,0,{"$f":"IF($E68+$H68=SUM($I65:$I67), $E68+$H68,\"FAUX\")","v":0}]
[null," Total 2015",0,0,0,0,0,0,{"$f":"E69+H69","v":0}]
[null," %  d'évolution",{"$f":"IF(C69<> 0,((C68-C69)/C69*100),\"  -  \")","v":"  -  "},{"$f":"IF(D69<>0,((D68-D69)/D69*100),\"  -  \")","v":"  -  "},"  -  ","  -  ","  -  ","  -  ","  -  "]
[null,"Général",1,9,670.41,46,496,27651.93,{"$f":"E71+H71","v":28322.34}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E72+H72","v":0}]
["Grèce","Minier",0,0,0,0,0,0,{"$f":"E73+H73","v":0}]
[null," Total 2016",{"$f":"SUM(C71:C73)","v":1},9,670.41,46,496,27651.93,{"$f":"IF($E74+$H74=SUM($I71:$I73), $E74+$H74,\"FAUX\")","v":28322.34}]
[null," Total 2015",4,42,1922.56,70,787,43396,{"$f":"E75+H75","v":45318.559999999998}]
[null," %  d'évolution",{"$f":"IF(C75<> 0,((C74-C75)/C75*100),\"  -  \")","v":-75},{"$f":"IF(D75<>0,((D74-D75)/D75*100),\"  -  \")","v":-78.571428571428569},-65.129306757656465,-34.285714285714285,-36.975857687420586,-36.280002765231814,-37.503883618543924]
[null,"Général",27,1023,37711.08,4,58,2897.83,{"$f":"E77+H77","v":40608.910000000003}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E78+H78","v":0}]
["Hongrie","Minier",0,0,0,0,0,0,{"$f":"E79+H79","v":0}]
[null," Total 2016",{"$f":"SUM(C77:C79)","v":27},1023,37711.08,4,58,2897.83,{"$f":"IF($E80+$H80=SUM($I77:$I79), $E80+$H80,\"FAUX\")","v":40608.910000000003}]
[null," Total 2015",13,435,17300.34,10,175,6934.67,{"$f":"E81+H81","v":24235.010000000002}]
[null," %  d'évolution",{"$f":"IF(C81<> 0,((C80-C81)/C81*100),\"  -  \")","v":107.69230769230769},{"$f":"IF(D81<>0,((D80-D81)/D81*100),\"  -  \")","v":135.17241379310346},117.97883741013185,-60,-66.857142857142861,-58.21243116110788,67.56300079925694]
[null,"Général",0,0,0,8,76,5267.25,{"$f":"E83+H83","v":5267.25}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E84+H84","v":0}]
["Irlande","Minier",0,0,0,0,0,0,{"$f":"E85+H85","v":0}]
[null," Total 2016",{"$f":"SUM(C83:C85)","v":0},0,0,8,76,5267.25,{"$f":"IF($E86+$H86=SUM($I83:$I85), $E86+$H86,\"FAUX\")","v":5267.25}]
[null," Total 2015",0,0,0,5,37,1880.65,{"$f":"E87+H87","v":1880.65}]
[null," %  d'évolution",{"$f":"IF(C87<> 0,((C86-C87)/C87*100),\"  -  \")","v":"  -  "},{"$f":"IF(D87<>0,((D86-D87)/D87*100),\"  -  \")","v":"  -  "},"  -  ",60,105.40540540540539,180.07603754021216,180.07603754021216]
[null,"Général",1,23,1230,1,19,683.81,{"$f":"E89+H89","v":1913.81}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E90+H90","v":0}]
["Islande","Minier",0,0,0,0,0,0,{"$f":"E91+H91","v":0}]
[null," Total 2016",{"$f":"SUM(C89:C91)","v":1},23,1230,1,19,683.81,{"$f":"IF($E92+$H92=SUM($I89:$I91), $E92+$H92,\"FAUX\")","v":1913.81}]
[null,{"$f":"[1]Parametres!$C$2","v":" Total 2015"},0,0,0,0,0,0,{"$f":"E93+H93","v":0}]
[null," %  d'évolution",{"$f":"IF(C93<> 0,((C92-C93)/C93*100),\"  -  \")","v":"  -  "},{"$f":"IF(D93<>0,((D92-D93)/D93*100),\"  -  \")","v":"  -  "},"  -  ","  -  ","  -  ","  -  ","  -  "]
[null,"Général",71,4103,187528.12,181,2802,160120.69,{"$f":"E95+H95","v":347648.81}]
[null,"Agricole",1,29,745.82,0,0,0,{"$f":"E96+H96","v":745.82}]
["Italie","Minier",0,0,0,0,0,0,{"$f":"E97+H97","v":0}]
[null," Total 2016",{"$f":"SUM(C95:C97)","v":72},4132,188273.94,181,2802,160120.69,{"$f":"IF($E98+$H98=SUM($I95:$I97), $E98+$H98,\"FAUX\")","v":348394.63}]
[null," Total 2015",86,5712,254753.46,163,2464,143107.71,{"$f":"E99+H99","v":397861.17}]
[null," %  d'évolution",{"$f":"IF(C99<> 0,((C98-C99)/C99*100),\"  -  \")","v":-16.279069767441861},{"$f":"IF(D99<>0,((D98-D99)/D99*100),\"  -  \")","v":-27.661064425770309},-26.095629868972143,11.042944785276074,13.717532467532468,11.888234393520804,-12.433115802680614]
[null,"Général",1,150,6496.72,0,0,0,{"$f":"E101+H101","v":6496.72}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E102+H102","v":0}]
["Lettonie","Minier",0,0,0,0,0,0,{"$f":"E103+H103","v":0}]
[null," Total 2016",{"$f":"SUM(C101:C103)","v":1},150,6496.72,0,0,0,{"$f":"IF($E104+$H104=SUM($I101:$I103), $E104+$H104,\"FAUX\")","v":6496.72}]
[null," Total 2015",0,0,0,0,0,0,{"$f":"E105+H105","v":0}]
[null," %  d'évolution",{"$f":"IF(C105<> 0,((C104-C105)/C105*100),\"  -  \")","v":"  -  "},{"$f":"IF(D105<>0,((D104-D105)/D105*100),\"  -  \")","v":"  -  "},"  -  ","  -  ","  -  ","  -  ","  -  "]
[null,"Général",0,0,0,0,0,0,{"$f":"E107+H107","v":0}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E108+H108","v":0}]
["Liechtenstein","Minier",0,0,0,0,0,0,{"$f":"E109+H109","v":0}]
[null," Total 2016",{"$f":"SUM(C107:C109)","v":0},0,0,0,0,0,{"$f":"IF($E110+$H110=SUM($I107:$I109), $E110+$H110,\"FAUX\")","v":0}]
[null," Total 2015",0,0,0,0,0,0,{"$f":"E111+H111","v":0}]
[null," %  d'évolution",{"$f":"IF(C111<> 0,((C110-C111)/C111*100),\"  -  \")","v":"  -  "},{"$f":"IF(D111<>0,((D110-D111)/D111*100),\"  -  \")","v":"  -  "},"  -  ","  -  ","  -  ","  -  ","  -  "]
[null,"Général",1,29,951.03,1,7,524.09,{"$f":"E113+H113","v":1475.12}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E114+H114","v":0}]
["Lituanie","Minier",0,0,0,0,0,0,{"$f":"E115+H115","v":0}]
[null," Total 2016",{"$f":"SUM(C113:C115)","v":1},29,951.03,1,7,524.09,{"$f":"IF($E116+$H116=SUM($I113:$I115), $E116+$H116,\"FAUX\")","v":1475.12}]
[null," Total 2015",0,0,0,0,0,0,{"$f":"E117+H117","v":0}]
[null," %  d'évolution",{"$f":"IF(C117<> 0,((C116-C117)/C117*100),\"  -  \")","v":"  -  "},{"$f":"IF(D117<>0,((D116-D117)/D117*100),\"  -  \")","v":"  -  "},"  -  ","  -  ","  -  ","  -  ","  -  "]
[null,"Général",2,12,775.66,4,64,3107.03,{"$f":"E119+H119","v":3882.69}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E120+H120","v":0}]
["Luxembourg","Minier",0,0,0,0,0,0,{"$f":"E121+H121","v":0}]
[null," Total 2016",{"$f":"SUM(C119:C121)","v":2},12,775.66,4,64,3107.03,{"$f":"IF($E122+$H122=SUM($I119:$I121), $E122+$H122,\"FAUX\")","v":3882.69}]
[null," Total 2015",1,366,17890.78,4,38,2176,{"$f":"E123+H123","v":20066.78}]
[null," %  d'évolution",{"$f":"IF(C123<> 0,((C122-C123)/C123*100),\"  -  \")","v":100},{"$f":"IF(D123<>0,((D122-D123)/D123*100),\"  -  \")","v":-96.721311475409834},-95.664470749738129,0,68.421052631578945,42.786305147058833,-80.651155790814471]
[null,"Général",0,0,0,3,25,1211.5,{"$f":"E125+H125","v":1211.5}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E126+H126","v":0}]
["Malte","Minier",0,0,0,0,0,0,{"$f":"E127+H127","v":0}]
[null," Total 2016",{"$f":"SUM(C125:C127)","v":0},0,0,3,25,1211.5,{"$f":"IF($E128+$H128=SUM($I125:$I127), $E128+$H128,\"FAUX\")","v":1211.5}]
[null," Total 2015",0,0,0,3,24,1354.7,{"$f":"E129+H129","v":1354.7}]
[null," %  d'évolution",{"$f":"IF(C129<> 0,((C128-C129)/C129*100),\"  -  \")","v":"  -  "},{"$f":"IF(D129<>0,((D128-D129)/D129*100),\"  -  \")","v":"  -  "},"  -  ",0,4.1666666666666661,-10.570606038237251,-10.570606038237251]
[null,"Général",0,0,0,0,0,0,{"$f":"E131+H131","v":0}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E132+H132","v":0}]
["Norvège","Minier",0,0,0,0,0,0,{"$f":"E133+H133","v":0}]
[null," Total 2016",{"$f":"SUM(C131:C133)","v":0},0,0,0,0,0,{"$f":"IF($E134+$H134=SUM($I131:$I133), $E134+$H134,\"FAUX\")","v":0}]
[null," Total 2015",0,0,0,7,130,9677.2900000000009,{"$f":"E135+H135","v":9677.2900000000009}]
[null," %  d'évolution",{"$f":"IF(C135<> 0,((C134-C135)/C135*100),\"  -  \")","v":"  -  "},{"$f":"IF(D135<>0,((D134-D135)/D135*100),\"  -  \")","v":"  -  "},"  -  ",-100,-100,-100,-100]
[null,"Général",1,81,5644.8,9,97,3875.41,{"$f":"E137+H137","v":9520.2099999999991}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E138+H138","v":0}]
["Pays-Bas","Minier",0,0,0,0,0,0,{"$f":"E139+H139","v":0}]
[null," Total 2016",{"$f":"SUM(C137:C139)","v":1},81,5644.8,9,97,3875.41,{"$f":"IF($E140+$H140=SUM($I137:$I139), $E140+$H140,\"FAUX\")","v":9520.2099999999991}]
[null," Total 2015",2,13,578.78,7,90,7478.99,{"$f":"E141+H141","v":8057.7699999999995}]
[null," %  d'évolution",{"$f":"IF(C141<> 0,((C140-C141)/C141*100),\"  -  \")","v":-50},{"$f":"IF(D141<>0,((D140-D141)/D141*100),\"  -  \")","v":523.07692307692309},875.2928573896819,28.571428571428569,7.7777777777777777,-48.182709162600837,18.149438368183748]
[null,"Général",0,0,0,33,740,40430.74,{"$f":"E143+H143","v":40430.74}]
[null,"Agricole",38,869,36492.879999999997,6,89,3816.77,{"$f":"E144+H144","v":40309.649999999994}]
["Pologne","Minier",0,0,0,0,0,0,{"$f":"E145+H145","v":0}]
[null," Total 2016",{"$f":"SUM(C143:C145)","v":38},869,36492.879999999997,39,829,44247.509999999995,{"$f":"IF($E146+$H146=SUM($I143:$I145), $E146+$H146,\"FAUX\")","v":80740.389999999985}]
[null," Total 2015",42,1249,59477.919999999998,62,1607,78018.7,{"$f":"E147+H147","v":137496.62}]
[null," %  d'évolution",{"$f":"IF(C147<> 0,((C146-C147)/C147*100),\"  -  \")","v":-9.5238095238095237},{"$f":"IF(D147<>0,((D146-D147)/D147*100),\"  -  \")","v":-30.424339471577262},-38.644660068812094,-37.096774193548384,-48.413192283758555,-43.286019890103269,-41.278272876816906]
[null,"Général",19,480,24064.13,1211,29471,1635697.35,{"$f":"E149+H149","v":1659761.48}]
[null,"Agricole",17,861,30095.47,2,57,2952.06,{"$f":"E150+H150","v":33047.53}]
["Portugal","Minier",0,0,0,0,0,0,{"$f":"E151+H151","v":0}]
[null," Total 2016",{"$f":"SUM(C149:C151)","v":36},1341,54159.600000000006,1213,29528,1638649.4100000001,{"$f":"IF($E152+$H152=SUM($I149:$I151), $E152+$H152,\"FAUX\")","v":1692809.0100000002}]
[null," Total 2015",34,1480,58769.79,1269,32656,1716165.16,{"$f":"E153+H153","v":1774934.95}]
[null," %  d'évolution",{"$f":"IF(C153<> 0,((C152-C153)/C153*100),\"  -  \")","v":5.8823529411764701},{"$f":"IF(D153<>0,((D152-D153)/D153*100),\"  -  \")","v":-9.3918918918918912},-7.8444894902636122,-4.4129235618597322,-9.5786379225869673,-4.5168001196341603,-4.6269830902816871]
[null,"Général",0,0,0,7,116,6306.99,{"$f":"E155+H155","v":6306.99}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E156+H156","v":0}]
["République Tchèque","Minier",0,0,0,0,0,0,{"$f":"E157+H157","v":0}]
[null," Total 2016",{"$f":"SUM(C155:C157)","v":0},0,0,7,116,6306.99,{"$f":"IF($E158+$H158=SUM($I155:$I157), $E158+$H158,\"FAUX\")","v":6306.99}]
[null," Total 2015",0,0,0,5,38,1822.38,{"$f":"E159+H159","v":1822.38}]
[null," %  d'évolution",{"$f":"IF(C159<> 0,((C158-C159)/C159*100),\"  -  \")","v":"  -  "},{"$f":"IF(D159<>0,((D158-D159)/D159*100),\"  -  \")","v":"  -  "},"  -  ",40,205.26315789473685,246.08533895235897,246.08533895235897]
[null,"Général",0,0,0,20,447,24085.17,{"$f":"E161+H161","v":24085.17}]
[null,"Agricole",1,20,943,1,17,860.72,{"$f":"E162+H162","v":1803.72}]
["Roumanie","Minier",0,0,0,0,0,0,{"$f":"E163+H163","v":0}]
[null," Total 2016",{"$f":"SUM(C161:C163)","v":1},20,943,21,464,24945.89,{"$f":"IF($E164+$H164=SUM($I161:$I163), $E164+$H164,\"FAUX\")","v":25888.89}]
[null," Total 2015",1,45,1866.15,13,293,15523.23,{"$f":"E165+H165","v":17389.38}]
[null," %  d'évolution",{"$f":"IF(C165<> 0,((C164-C165)/C165*100),\"  -  \")","v":0},{"$f":"IF(D165<>0,((D164-D165)/D165*100),\"  -  \")","v":-55.555555555555557},-49.468156364708094,61.53846153846154,58.361774744027308,60.700382587902133,48.877590805422614]
[null,"Général",1,392,20140.96,28,197,11411.49,{"$f":"E167+H167","v":31552.449999999997}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E168+H168","v":0}]
["Royaume-Uni","Minier",0,0,0,0,0,0,{"$f":"E169+H169","v":0}]
[null," Total 2016",{"$f":"SUM(C167:C169)","v":1},392,20140.96,28,197,11411.49,{"$f":"IF($E170+$H170=SUM($I167:$I169), $E170+$H170,\"FAUX\")","v":31552.449999999997}]
[null," Total 2015",0,0,0,30,377,26970.76,{"$f":"E171+H171","v":26970.76}]
[null," %  d'évolution",{"$f":"IF(C171<> 0,((C170-C171)/C171*100),\"  -  \")","v":"  -  "},{"$f":"IF(D171<>0,((D170-D171)/D171*100),\"  -  \")","v":"  -  "},"  -  ",-6.666666666666667,-47.745358090185675,-57.689401411009555,16.987619184628088]
[null,"Général",2,109,4054.09,2,33,1702.52,{"$f":"E173+H173","v":5756.6100000000006}]
[null,"Agricole",1,30,1017.31,0,0,0,{"$f":"E174+H174","v":1017.31}]
["Slovaquie","Minier",0,0,0,0,0,0,{"$f":"E175+H175","v":0}]
[null," Total 2016",{"$f":"SUM(C173:C175)","v":3},139,5071.3999999999996,2,33,1702.52,{"$f":"IF($E176+$H176=SUM($I173:$I175), $E176+$H176,\"FAUX\")","v":6773.92}]
[null," Total 2015",3,213,7331.77,3,125,9092.8799999999992,{"$f":"E177+H177","v":16424.650000000001}]
[null," %  d'évolution",{"$f":"IF(C177<> 0,((C176-C177)/C177*100),\"  -  \")","v":0},{"$f":"IF(D177<>0,((D176-D177)/D177*100),\"  -  \")","v":-34.741784037558688},-30.829799625465622,-33.333333333333329,-73.599999999999994,-81.276339289641996,-58.757599096479986]
[null,"Général",0,0,0,1,23,1261.32,{"$f":"E179+H179","v":1261.32}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E180+H180","v":0}]
["Slovénie","Minier",0,0,0,0,0,0,{"$f":"E181+H181","v":0}]
[null," Total 2016",{"$f":"SUM(C179:C181)","v":0},0,0,1,23,1261.32,{"$f":"IF($E182+$H182=SUM($I179:$I181), $E182+$H182,\"FAUX\")","v":1261.32}]
[null," Total 2015",1,48,1734.84,0,0,0,{"$f":"E183+H183","v":1734.84}]
[null," %  d'évolution",{"$f":"IF(C183<> 0,((C182-C183)/C183*100),\"  -  \")","v":-100},{"$f":"IF(D183<>0,((D182-D183)/D183*100),\"  -  \")","v":-100},-100,"  -  ","  -  ","  -  ",-27.294736113993224]
[null,"Général",0,0,0,2,12,815.88,{"$f":"E185+H185","v":815.88}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E186+H186","v":0}]
["Suède","Minier",0,0,0,0,0,0,{"$f":"E187+H187","v":0}]
[null," Total 2016",{"$f":"SUM(C185:C187)","v":0},0,0,2,12,815.88,{"$f":"IF($E188+$H188=SUM($I185:$I187), $E188+$H188,\"FAUX\")","v":815.88}]
[null," Total 2015",0,0,0,2,24,1347.4,{"$f":"E189+H189","v":1347.4}]
[null," %  d'évolution",{"$f":"IF(C189<> 0,((C188-C189)/C189*100),\"  -  \")","v":"  -  "},{"$f":"IF(D189<>0,((D188-D189)/D189*100),\"  -  \")","v":"  -  "},"  -  ",0,-50,-39.447825441591213,-39.447825441591213]
[null,"Général",6,123,6550.55,15,110,4888.51,{"$f":"E191+H191","v":11439.060000000001}]
[null,"Agricole",0,0,0,0,0,0,{"$f":"E192+H192","v":0}]
["Suisse","Minier",0,0,0,0,0,0,{"$f":"E193+H193","v":0}]
[null," Total 2016",{"$f":"SUM(C191:C193)","v":6},123,6550.55,15,110,4888.51,{"$f":"IF($E194+$H194=SUM($I191:$I193), $E194+$H194,\"FAUX\")","v":11439.060000000001}]
[null," Total 2015",10,94,5699.16,19,185,7848.7,{"$f":"E195+H195","v":13547.86}]
[null," %  d'évolution",{"$f":"IF(C195<> 0,((C194-C195)/C195*100),\"  -  \")","v":-40},{"$f":"IF(D195<>0,((D194-D195)/D195*100),\"  -  \")","v":30.851063829787233},14.938868184083272,-21.052631578947366,-40.54054054054054,-37.715672659166479,-15.565557955278539]
[null,"Général",{"$f":"C11+C17+C23+C29+C35+C41+C47+C53+C59+C65+C71+C77+C83+C89+C95+C101+C107+C113+C119+C125+C131+C137+C143+C149+C155+C161+C167+C173+C179+C185+C191","v":302},18211,947263.4600000002,2080,41729,2322755.4299999997,{"$f":"IF(I11+I17+I23+I29+I35+I41+I47+I53+I59+I65+I71+I77+I83+I89+I95+I101+I107+I113+I119+I125+I131+I137+I143+I149+I155+I161+I167+I173+I179+I185+I191=E197+H197,E197+H197,\"faux\")","v":3270018.8899999997}]
[null,"Agricole",103,4866,181703.74000000002,20,453,16795.22,{"$f":"IF(I12+I18+I24+I30+I36+I42+I48+I54+I60+I66+I72+I78+I84+I90+I96+I102+I108+I114+I120+I126+I132+I138+I144+I150+I156+I162+I168+I174+I180+I186+I192=E198+H198,E198+H198,\"faux\")","v":198498.96000000002}]
["Total","Minier",0,0,0,0,0,{"$f":"H13+H19+H25+H31+H37+H43+H49+H55+H61+H67+H73+H79+H85+H91+H97+H103+H109+H115+H121+H127+H133+H139+H145+H151+H157+H163+H169+H175+H181+H187+H193","v":0},{"$f":"IF(I13+I19+I25+I31+I37+I43+I49+I55+I61+I67+I73+I79+I85+I91+I97+I103+I109+I115+I121+I127+I133+I139+I145+I151+I157+I163+I169+I175+I181+I187+I193=E199+H199,E199+H199,\"faux\")","v":0}]
["général"," Total 2016",{"$f":"SUM(C197:C199)","v":405},23077,1128967.2000000002,2100,42182,2339550.65,{"$f":"IF($E200+$H200=SUM($I197:$I199), $E200+$H200,\"FAUX\")","v":3468517.85}]
[null," Total 2015",{"$f":"C15+C21+C27+C33+C39+C45+C51+C57+C63+C69+C75+C81+C87+C93+C99+C105+C111+C117+C123+C129+C135+C141+C147+C153+C159+C165+C171+C177+C183+C189+C195","v":425},24602,1161642.1299999999,2252,{"$f":"G15+G21+G27+G33+G39+G45+G51+G57+G63+G69+G75+G81+G87+G93+G99+G105+G111+G117+G123+G129+G135+G141+G147+G153+G159+G165+G171+G177+G183+G189+G195","v":48243},2601858.7299999995,{"$f":"IF(I15+I21+I27+I33+I39+I45+I51+I57+I63+I69+I75+I81+I87+I93+I99+I105+I111+I117+I123+I129+I135+I141+I147+I153+I159+I165+I171+I177+I183+I189+I195=E201+H201,E201+H201,\"faux\")","v":3763500.8599999994}]
[null," %  d'évolution",{"$f":"IF(C201<> 0,((C200-C201)/C201*100),\"  -  \")","v":-4.7058823529411766},{"$f":"IF(D201<>0,((D200-D201)/D201*100),\"  -  \")","v":-6.198683033899683},-2.8128223965155006,-6.74955595026643,-12.563480712227681,-10.081565035623576,-7.837995020412972]

{"sheet":"Paramètres","index":2,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
["Allemagne","A11"]
["Autriche","A17"]
["Belgique","A23"]
["Bulgarie","A29"]
["Chypre","A35"]
["Croatie","A41"]
["Danemark","A47"]
["Espagne","A53"]
["Estonie","A59"]
["Finlande","A65"]
["Grèce","A71"]
["Hongrie","A77"]
["Irlande","A83"]
["Islande","A89"]
["Italie","A95"]
["Lettonie","A101"]
["Liechtenstein","A107"]
["Lituanie","A113"]
["Luxembourg","A119"]
["Malte","A125"]
["Norvège","A131"]
["Pays-Bas","A137"]
["Pologne","A143"]
["Portugal","A149"]
["République tchèque","A155"]
["Roumanie","A161"]
["Royaume-Uni","A167"]
["Slovaquie","A173"]
["Slovénie","A179"]
["Suède","A185"]
["Suisse","A191"]