{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Données générales","Surface Géo","Assignation","Allotissement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":42,"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":"Données générales","index":0,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,12,11,16],[12,2,12,7],[11,8,11,9],[10,8,10,9],[11,10,11,11],[10,10,10,11]]}
["RDMàD pour 1 assignation = l x bf x lb x es x k1",null,null,null,null,null,"RDMàD pour 1 allotissement = l x bf x a x c x k1"]
["x2 si FH bidirectionnel (2 fréquences donc 2 assignations)"]
["RGestion = G x Nb assignations",null,null,null,null,null,"Rgestion = G' x l"]
["l =","Largeur de bande assignée",null,null,null,null,"l =","Largeur de bande totale allotie"]
["bf =","Spécificité des bandes de fréquences",null,null,null,null,"bf =","Spécificité des bandes de fréquences"]
["lb =","Adéquation de longueur de bond = Raciné carré de longueur mini sur longueur réelle",null,null,null,null,"a = ","coefficient d'allotissement"]
["es =","Efficacité spectrale",null,null,null,null,"c = ","Surface couverte pour l'allotissement"]
["K1 =",15.5,null,null,null,null,null,"Protata temporis"]
["G =",50]
["G' =",1575]
[null,null,null,null,null,null,null,null,"Métropole",null,"Outremer"]
[null,null,null,null,null,null,null,null,"lb",null,"lb",null,"es"]
["Bande Frqs","Coeff bf","Canalisations en MHz",null,null,null,null,null,"≤ 51 Mbits/s","> 51 Mbits/s","≤ 51 Mbits/s","> 51 Mbits/s","2 états & Analog","4 / 8 états","16 / 32 états","64 / 128 états","256 / 512 états","ModulAdapt","a"]
["1,5",8.6999999999999993,2.5000000000000001E-2,7.4999999999999997E-2,0.25,0.5,1,2,null,"Impossible",null,"Impossible",1.5,1,1,0.85,0.8,1,400]
["6A",2.2000000000000002,29.65,null,null,null,null,null,"Impossible",15,"Impossible",15,"Impossible","Impossible",1.2,1,0.8,1,{"$f":"S14","v":400}]
["6B",2.2000000000000002,20,40,null,null,null,null,"Impossible",15,"Impossible",15,"Impossible","Impossible",1.2,1,0.8,1,{"$f":"S15","v":400}]
[8,1.6,3.5,7,14,28,32.5,null,13,10,13,10,1.5,1.2,1,0.85,0.8,1,400]
[11,1.2,40,null,null,null,null,null,"Impossible",8,"Impossible",5,"Impossible","Impossible",1.2,1,0.8,1,400]
[13,1,1.75,3.5,7,14,28,null,8,5,5,3,"Impossible",1.2,1,0.85,0.8,1,400]
[18,0.7,7.5,13.75,27.5,55,null,null,3,2,2,2,"Impossible",1.4,1.2,1,0.8,1,400]
[23,0.6,3.5,7,14,28,56,null,3,2,null,null,1.5,1.2,1,0.85,0.8,1,1000]
[26,0.5,14,28,56,112,null,null,null,null,null,null,"Impossible",1.2,1,0.85,0.8,1,1000]
[32,0.5,28,56,112,null,null,null,null,null,null,null,"Impossible",1.2,1,0.85,0.8,1,1000]
[38,0.3,3.5,7,14,28,56,112,null,null,null,null,"Impossible",1.2,1,0.85,0.8,1,1000]
["70,80",7.0000000000000007E-2,250,500,750,1000,1250,null,null,null,null,null,1,0.85,0.8,0.8,0.8,1,1000]
[]
[]
[]
["année Ref","Ref IPC","Val IPC Ann","Var IPC / Sept 2007","Var IPC / Sept 2007 %"]
[2007,"2007-09-01",116.33,1,0]
[2008,"2007-09-01",{"$f":"$C$30+$C$30*E31","v":116.33},1,0]
[2009,"2008-09-01",119.8199,{"$f":"C32/$C$30","v":1.03},0.03]
[2010,"2009-09-01",119.35458,{"$f":"C33/$C$30","v":1.026},2.5999999999999999E-2]
[2011,"2010-09-01",121.21585999999999,1.042,4.2000000000000003E-2]
[2012,"2011-09-01",124.00778,1.0660000000000001,6.6000000000000003E-2]
[2013,"2012-09-01",126.33438,{"$f":"C36/$C$30","v":1.0860000000000001},8.5999999999999993E-2]
[2014,"2013-09-01",127.38135,{"$f":"C37/$C$30","v":1.095},9.5000000000000001E-2]
[2015,"2014-09-01",127.84667,1.099,9.9000000000000005E-2]
[2016,"2015-09-01",127.84667,1.099,9.9000000000000005E-2]
[2017,"2016-09-01",128.31199000000001,1.103,0.10299999999999999]
[]
[]
["Valeurs indicatives. Seuls les textes de référence font foi."]

{"sheet":"Surface Géo","index":1,"n_rows":125,"n_cols":4,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Code","Type","Désignation","Superficie\nkm ²"]
["D","Département","01 Ain",5762]
["D","Département","02 Aisne",7369]
["D","Département","03 Allier",7340]
["D","Département","04 Alpes-de-Hte-Provence",6925]
["D","Département","05 Alpes (Hautes-)",5549]
["D","Département","06 Alpes-Maritimes",4299]
["D","Département","07 Ardèche",5529]
["D","Département","08 Ardennes",5229]
["D","Département","09 Ariège",4890]
["D","Département","10 Aube",6004]
["D","Département","11 Aude",6139]
["D","Département","12 Aveyron",8735]
["D","Département","13 Bouches-du-Rhône",5087]
["D","Département","14 Calvados",5548]
["D","Département","15 Cantal",5726]
["D","Département","16 Charente",5956]
["D","Département","17 Charente-Maritime",6864]
["D","Département","18 Cher",7235]
["D","Département","19 Corrèze",5857]
["D","Département","21 Côte-d'Or",8763]
["D","Département","22 Côtes-d'Armor",6878]
["D","Département","23 Creuse",5565]
["D","Département","24 Dordogne",9060]
["D","Département","25 Doubs",5234]
["D","Département","26 Drôme",6530]
["D","Département","27 Eure",6040]
["D","Département","28 Eure-et-Loir",5880]
["D","Département","29 Finistère",6733]
["D","Département","2A Corse-du-Sud",4014]
["D","Département","2B Haute-Corse",4666]
["D","Département","30 Gard",5853]
["D","Département","31 Garonne (Haute-)",6309]
["D","Département","32 Gers",6257]
["D","Département","33 Gironde",10000]
["D","Département","34 Hérault",6101]
["D","Département","35 Ille-et-Vilaine",6775]
["D","Département","36 Indre",6791]
["D","Département","37 Indre-et-Loire",6127]
["D","Département","38 Isère",7431]
["D","Département","39 Jura",4999]
["D","Département","40 Landes",9243]
["D","Département","41 Loir-et-Cher",6343]
["D","Département","42 Loire",4781]
["D","Département","43 Loire (Haute-)",4977]
["D","Département","44 Loire-Atlantique",6815]
["D","Département","45 Loiret",6775]
["D","Département","46 Lot",5217]
["D","Département","47 Lot-et-Garonne",5361]
["D","Département","48 Lozère",5167]
["D","Département","49 Maine-et-Loire",7166]
["D","Département","50 Manche",5938]
["D","Département","51 Marne",8162]
["D","Département","52 Marne (Haute-)",6211]
["D","Département","53 Mayenne",5175]
["D","Département","54 Meurthe-et-Moselle",5246]
["D","Département","55 Meuse",6211]
["D","Département","56 Morbihan",6823]
["D","Département","57 Moselle",6216]
["D","Département","58 Nièvre",6817]
["D","Département","59 Nord",5743]
["D","Département","60 Oise",5860]
["D","Département","61 Orne",6103]
["D","Département","62 Pas-de-Calais",6671]
["D","Département","63 Puy-de-Dôme",7970]
["D","Département","64 Pyrénées-Atlantiques",7645]
["D","Département","65 Pyrénées (Hautes-)",4464]
["D","Département","66 Pyrénées-Orientales",4116]
["D","Département","67 Rhin (Bas-)",4755]
["D","Département","68 Rhin (Haut-)",3525]
["D","Département","69 Rhône",3249]
["D","Département","70 Saône (Haute-)",5360]
["D","Département","71 Saône-et-Loire",8575]
["D","Département","72 Sarthe",6206]
["D","Département","73 Savoie",6028]
["D","Département","74 Savoie (Haute-)",4388]
["D","Département","75 Paris",105]
["D","Département","76 Seine-Maritime",6278]
["D","Département","77 Seine-et-Marne",5915]
["D","Département","78 Yvelines",2284]
["D","Département","79 Sèvres (Deux-)",5999]
["D","Département","80 Somme",6170]
["D","Département","81 Tarn",5758]
["D","Département","82 Tarn-et-Garonne",3718]
["D","Département","83 Var",5973]
["D","Département","84 Vaucluse",3567]
["D","Département","85 Vendée",6720]
["D","Département","86 Vienne",6990]
["D","Département","87 Vienne (Haute-)",5520]
["D","Département","88 Vosges",5874]
["D","Département","89 Yonne",7427]
["D","Département","90 Belfort (Territoire de)",609]
["D","Département","91 Essonne",1804]
["D","Département","92 Hauts-de-Seine",176]
["D","Département","93 Seine-Saint-Denis",236]
["D","Département","94 Val-de-Marne",245]
["D","Département","95 Val-d'Oise",1246]
["D","Département","971 La Guadeloupe",1628.43]
["D","Département","972 La Martinique",1128]
["D","Département","973 La Guyane",83534]
["D","Département","974 La Réunion",2512]
["D","Département","975 St Pierre et Miquelon",242]
["D","Département","976 Mayotte",376]
["C","Collectivité d'outre-mer","977 St Bartlemy",24]
["C","Collectivité d'outre-mer","978 St Martin",53]
["M","Métropole","Métropole",543965]
["R","Région","Auvergne Rhône Aples",69711]
["R","Région","Bourgogne Franche-Comté",47784]
["R","Région","Bretagne",27208]
["R","Région","Centre Val de Loire",39151]
["R","Région","Corse",8680]
["R","Région","Ensemble DOM",88868]
["R","Région","Grand Est",57433]
["R","Région","Guadeloupe",1702]
["R","Région","Guyane",83534]
["R","Région","Hauts-de-France",31813]
["R","Région","Ile-de-France",12012]
["R","Région","Martinique",1128]
["R","Région","Mayotte",376]
["R","Région","Normandie",30100]
["R","Région","Nouvelle Aquitaine",84061]
["R","Région","Occitanie",72724]
["R","Région","Pays de la Loire",31082]
["R","Région","Provence-Alpes-Côte d'Azur",31400]
["R","Région","Réunion",2512]

{"sheet":"Assignation","index":2,"n_rows":36,"n_cols":23,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,17,31,19],[30,20,31,20],[30,16,31,16]]}
[]
[]
[]
["Année Réf","zone Géo","Unidir\nBidir","Débits","Modulation","Nb FH","Bande Frqs\nGHz","Long Bond\nkm","Nb jours","Canalisation\nMHz","Unidir / Bidir","Coeff\nbf","Coeff\nlb","Coeff\nes","Coeff\nK1","Var IPC\n2007 >>","Var IPC\n2007 >>","Sous-Total\nRDMàD","Coeff\nG","Sous-Total\nRGest","Total\nRDMàD + Rgest"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C5=\"\",\"Manque Type FH\",IF(C5=\"Unidirectionnel\",1,2))","v":"Manque Type FH"},{"$f":"IF(G5=\"\",\"Manque Bande\",INDEX(Liste_Coeff_bf,MATCH(G5,Liste_Bandes,0),1))","v":"Manque Bande"},{"$f":"IF(G5=\"\",\"Manque Bande\",IF(W5=0,1,IF(W5=\"Impossible\",\"Calcul Impossible\",IF(H5>=W5,1,ROUND(SQRT(W5/H5),2)))))","v":"Manque Bande"},{"$f":"IF(G5=\"\",\"Manque Bande\",INDEX(Liste_Coeff_es,MATCH(G5,Liste_Bandes,0),MATCH(E5,Liste_Modulations,0)))","v":"Manque Bande"},15.5,{"$f":"IF(A5=\"\",\"\",INDEX(Liste_Var_IPC,MATCH(A5,Liste_Annee,0)))","v":""},{"$f":"IF(A5=\"\",\"\",INDEX(Liste_Var_IPC_pourcent,MATCH(A5,Liste_Annee,0)))","v":""},{"$f":"IF(ISNUMBER(IF(I5<1,F5*J5*K5*L5*M5*N5*O5*(1/365)*P5,F5*J5*K5*L5*M5*N5*O5*(I5/365)*P5)),IF(I5<1,F5*J5*K5*L5*M5*N5*O5*(1/365)*P5,F5*J5*K5*L5*M5*N5*O5*(I5/365)*P5),0)","v":0},50,{"$f":"IF(ISNUMBER(IF(I5<1,(1/365)*F5*K5*S5,(I5/365)*F5*K5*S5)),IF(I5<1,(1/365)*F5*K5*S5,(I5/365)*F5*K5*S5),0)","v":0},{"$f":"R5+T5","v":0},null,{"$f":"IF(G5=\"\",\"\",INDEX(IF(B5=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(G5,Liste_Bandes,0),IF(D5=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"\",\"Manque Type FH\",IF(C6=\"Unidirectionnel\",1,2))","v":"Manque Type FH"},"Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H6=\"\",\" \",'Données générales'!$B$8)","v":" "},{"$f":"IF(A6=\"\",\"\",INDEX(Liste_Var_IPC,MATCH(A6,Liste_Annee,0)))","v":""},{"$f":"IF(A6=\"\",\"\",INDEX(Liste_Var_IPC_pourcent,MATCH(A6,Liste_Annee,0)))","v":""},{"$f":"IF(ISNUMBER(IF(I6<1,F6*J6*K6*L6*M6*N6*O6*(1/365)*P6,F6*J6*K6*L6*M6*N6*O6*(I6/365)*P6)),IF(I6<1,F6*J6*K6*L6*M6*N6*O6*(1/365)*P6,F6*J6*K6*L6*M6*N6*O6*(I6/365)*P6),0)","v":0},{"$f":"IF(H6=\"\",\" \",'Données générales'!$B$9)","v":" "},{"$f":"IF(ISNUMBER(IF(I6<1,(1/365)*F6*K6*S6,(I6/365)*F6*K6*S6)),IF(I6<1,(1/365)*F6*K6*S6,(I6/365)*F6*K6*S6),0)","v":0},{"$f":"R6+T6","v":0},null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H7=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H7=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H8=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H8=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H9=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H9=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H10=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H10=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H11=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H11=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H12=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H12=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H13=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H13=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H14=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H14=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H15=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H15=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H16=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H16=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H17=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H17=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H18=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H18=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H19=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H19=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H20=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H20=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C21=\"\",\"Manque Type FH\",IF(C21=\"Unidirectionnel\",1,2))","v":"Manque Type FH"},"Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H21=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H21=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,""]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H22=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H22=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H23=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H23=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H24=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H24=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H25=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H25=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H26=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H26=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H27=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H27=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,{"$f":"IF(G27=\"\",\"\",INDEX(IF(B27=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(G27,Liste_Bandes,0),IF(D27=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H28=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H28=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,{"$f":"IF(G28=\"\",\"\",INDEX(IF(B28=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(G28,Liste_Bandes,0),IF(D28=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H29=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H29=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,{"$f":"IF(G29=\"\",\"\",INDEX(IF(B29=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(G29,Liste_Bandes,0),IF(D29=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Manque Type FH","Manque Bande","Manque Bande","Manque Bande",{"$f":"IF(H30=\"\",\" \",'Données générales'!$B$8)","v":" "},"","",0,{"$f":"IF(H30=\"\",\" \",'Données générales'!$B$9)","v":" "},0,0,null,{"$f":"IF(G30=\"\",\"\",INDEX(IF(B30=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(G30,Liste_Bandes,0),IF(D30=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaux",{"$f":"SUM(R5:R30)","v":0},null,{"$f":"SUM(T5:T30)","v":0},{"$f":"SUM(U5:U30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R31+T31","v":0}]
[]
["Zone Géo = Métropole ou DOM."]
["VAR IPC 2007 >> = Variation de l'Indice des Prix à la Consommation (tabac inclus) par rapport à la référence de Sept 2007."]
["Montants donnés à titre indicatif."]

{"sheet":"Allotissement","index":3,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[31,12,31,14],[30,15,31,15],[30,11,31,11]]}
[]
[]
[]
["Année Ref","Zone Géo","Sous-zone Géo","Bande Frqs\nGHz","Largeur Totale\nBande Allotie\nMHz","Nb jours","Coeff\nbf","Coeff a","Coeff Surf\nc","Coeff\nK1","Var IPC\n2007 >>","Var IPC\n2007 >>","Sous-Total\nRDMàD","Coeff\nG'","Sous-Total\nRGest","Total\nRDMàD + Rgest"]
[null,null,null,null,null,null,{"$f":"IF(D5=\"\",\"Manque Bande\",INDEX(Liste_Coeff_bf,MATCH(D5,Liste_Bandes,0),1))","v":"Manque Bande"},{"$f":"IF(E5=\"\",\"\",INDEX(Liste_Coeff_a,MATCH(D5,Liste_Bandes,0)))","v":""},{"$f":"IF(C5=\"\",\"\",ROUND(INDEX(Superficie_sous_zone,MATCH(C5,Sous_zone,0))/Surface_metropole,4))","v":""},15.5,{"$f":"IF(A5=\"\",\"\",INDEX(Liste_Var_IPC,MATCH(A5,Liste_Annee,0)))","v":""},{"$f":"IF(A5=\"\",\"\",INDEX(Liste_Var_IPC_pourcent,MATCH(A5,Liste_Annee,0)))","v":""},{"$f":"IF(ISNUMBER(IF(F5<1,E5*G5*J5*H5*I5*(1/365)*K5,E5*G5*J5*H5*I5*(F5/365))*K5),IF(F5<1,E5*G5*J5*H5*I5*(1/365)*K5,E5*G5*J5*H5*I5*(F5/365)*K5),0)","v":0},1575,{"$f":"IF(ISNUMBER(IF(F5<1,(1/365)*E5*N5,(F5/365)*E5*N5)),IF(F5<1,(1/365)*E5*N5,(F5/365)*E5*N5),0)","v":0},{"$f":"M5+O5","v":0}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",{"$f":"IF(ISNUMBER(IF(F6<1,E6*G6*J6*H6*I6*(1/365)*K6,E6*G6*J6*H6*I6*(F6/365))*K6),IF(F6<1,E6*G6*J6*H6*I6*(1/365)*K6,E6*G6*J6*H6*I6*(F6/365)*K6),0)","v":0},null,{"$f":"IF(ISNUMBER(IF(F6<1,(1/365)*E6*N6,(F6/365)*E6*N6)),IF(F6<1,(1/365)*E6*N6,(F6/365)*E6*N6),0)","v":0},0,null,{"$f":"IF(D6=\"\",\"\",INDEX(IF(B6=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D6,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D7=\"\",\"\",INDEX(IF(B7=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D7,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D8=\"\",\"\",INDEX(IF(B8=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D8,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D9=\"\",\"\",INDEX(IF(B9=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D9,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D10=\"\",\"\",INDEX(IF(B10=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D10,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D11=\"\",\"\",INDEX(IF(B11=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D11,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D12=\"\",\"\",INDEX(IF(B12=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D12,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D13=\"\",\"\",INDEX(IF(B13=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D13,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D14=\"\",\"\",INDEX(IF(B14=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D14,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D15=\"\",\"\",INDEX(IF(B15=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D15,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D16=\"\",\"\",INDEX(IF(B16=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D16,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D17=\"\",\"\",INDEX(IF(B17=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D17,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D18=\"\",\"\",INDEX(IF(B18=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D18,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D19=\"\",\"\",INDEX(IF(B19=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D19,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D20=\"\",\"\",INDEX(IF(B20=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D20,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D21=\"\",\"\",INDEX(IF(B21=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D21,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D27=\"\",\"\",INDEX(IF(B27=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D27,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D28=\"\",\"\",INDEX(IF(B28=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D28,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D29=\"\",\"\",INDEX(IF(B29=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D29,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,"Manque Bande","","",null,"","",0,null,0,0,null,{"$f":"IF(D30=\"\",\"\",INDEX(IF(B30=\"Métropole\",Constante_lb_Métropole,Constante_lb_Outremer),MATCH(D30,Liste_Bandes,0),IF(#REF!=\"> 51 Mbits/s\",2,1)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Totaux",{"$f":"SUM(M5:M30)","v":0},null,{"$f":"SUM(O5:O30)","v":0},{"$f":"SUM(P5:P30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M31+O31","v":0}]
[]
["Zone Géo = Métropole, Régions, Départements."]
["Sous-Zone Géo = Détail des Régions et Départements + France Métropolitaine."]
["VAR IPC 2007 >> = Variation de l'Indice des Prix à la Consommation (tabac inclus) par rapport à la référence de Sept 2007."]
["Montants donnés à titre indicatif."]