{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Détail des risques","BDGT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":3,"comments":1,"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":"Détail des risques","index":0,"n_rows":21,"n_cols":111,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,1,14,2],[15,1,15,2],[4,103,4,105],[4,106,4,109],[7,1,7,2],[8,1,8,2],[9,1,9,2],[13,1,13,2],[4,76,4,78],[4,79,4,82],[4,85,4,87],[4,88,4,91],[4,94,4,96],[4,97,4,100],[4,49,4,51],[4,52,4,55],[4,58,4,60],[4,61,4,64],[4,67,4,69],[4,70,4,73],[4,22,4,24],[4,25,4,28],[4,31,4,33],[4,34,4,37],[4,40,4,42],[4,43,4,46],[0,0,0,1],[1,8,1,14],[4,4,4,6],[4,7,4,10],[4,13,4,15],[4,16,4,19]]}
[{"$f":"[1]Paramètres!$A$2","v":"2200A1"}]
[null,null,null,null,null,null,null,null,"Détail des risques"]
[]
[]
[null,null,null,null,{"$f":"\"PFA 12/\"&[2]VBA!$P$8","v":"PFA 12/2021"},null,null,{"$f":"\"PFA 01/\"&[2]VBA!$Q$8","v":"PFA 01/2022"},null,null,null,null,null,{"$f":"H5","v":"PFA 01/2022"},null,null,{"$f":"\"PFA 02/\"&[2]VBA!$Q$8","v":"PFA 02/2022"},null,null,null,null,null,{"$f":"Q5","v":"PFA 02/2022"},null,null,{"$f":"\"PFA 03/\"&[2]VBA!$Q$8","v":"PFA 03/2022"},null,null,null,null,null,{"$f":"Z5","v":"PFA 03/2022"},null,null,{"$f":"\"PFA 04/\"&[2]VBA!$Q$8","v":"PFA 04/2022"},null,null,null,null,null,{"$f":"AI5","v":"PFA 04/2022"},null,null,{"$f":"\"PFA 05/\"&[2]VBA!$Q$8","v":"PFA 05/2022"},null,null,null,null,null,{"$f":"AR5","v":"PFA 05/2022"},null,null,{"$f":"\"PFA 06/\"&[2]VBA!$Q$8","v":"PFA 06/2022"},null,null,null,null,null,{"$f":"BA5","v":"PFA 06/2022"},null,null,{"$f":"\"PFA 07/\"&[2]VBA!$Q$8","v":"PFA 07/2022"},null,null,null,null,null,{"$f":"BJ5","v":"PFA 07/2022"},null,null,{"$f":"\"PFA 08/\"&[2]VBA!$Q$8","v":"PFA 08/2022"},null,null,null,null,null,{"$f":"BS5","v":"PFA 08/2022"},null,null,{"$f":"\"PFA 09/\"&[2]VBA!$Q$8","v":"PFA 09/2022"},null,null,null,null,null,{"$f":"CB5","v":"PFA 09/2022"},null,null,{"$f":"\"PFA 10/\"&[2]VBA!$Q$8","v":"PFA 10/2022"},null,null,null,null,null,{"$f":"CK5","v":"PFA 10/2022"},null,null,{"$f":"\"PFA 11/\"&[2]VBA!$Q$8","v":"PFA 11/2022"},null,null,null,null,null,{"$f":"CT5","v":"PFA 11/2022"},null,null,{"$f":"\"PFA 12/\"&[2]VBA!$Q$8","v":"PFA 12/2022"}]
[null,null,null,null,{"$f":"MONTH(RIGHT(E5,7))","v":12},null,null,{"$f":"MONTH(RIGHT(H5,7))","v":1},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(N5,7))","v":1},null,null,{"$f":"MONTH(RIGHT(Q5,7))","v":2},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(W5,7))","v":2},null,null,{"$f":"MONTH(RIGHT(Z5,7))","v":3},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(AF5,7))","v":3},null,null,{"$f":"MONTH(RIGHT(AI5,7))","v":4},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(AO5,7))","v":4},null,null,{"$f":"MONTH(RIGHT(AR5,7))","v":5},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(AX5,7))","v":5},null,null,{"$f":"MONTH(RIGHT(BA5,7))","v":6},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(BG5,7))","v":6},null,null,{"$f":"MONTH(RIGHT(BJ5,7))","v":7},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(BP5,7))","v":7},null,null,{"$f":"MONTH(RIGHT(BS5,7))","v":8},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(BY5,7))","v":8},null,null,{"$f":"MONTH(RIGHT(CB5,7))","v":9},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(CH5,7))","v":9},null,null,{"$f":"MONTH(RIGHT(CK5,7))","v":10},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(CQ5,7))","v":10},null,null,{"$f":"MONTH(RIGHT(CT5,7))","v":11},null,null,"Ecart",null,null,{"$f":"MONTH(RIGHT(CZ5,7))","v":11},null,null,{"$f":"MONTH(RIGHT(DC5,7))","v":12},null,null,"Ecart"]
["OE",null,null,"Budget","Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP",null,"Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP"]
[{"$f":"LEFT($A$1,4)&\"RISK\"","v":"2200RISK"},"R1 : Maintenance corrective sous-estimée",null,null,0,50,{"$f":"+E8+F8","v":50},0,50,{"$f":"+H8+I8","v":50},null,null,null,{"$f":"H8","v":0},50,50,0,50,{"$f":"+Q8+R8","v":50},null,null,null,{"$f":"Q8","v":0},50,50,0,null,{"$f":"+Z8+AA8","v":0},null,null,null,{"$f":"Z8","v":0},0,0,0,null,{"$f":"+AI8+AJ8","v":0},null,null,null,{"$f":"AI8","v":0},0,0,0,null,{"$f":"+AR8+AS8","v":0},null,null,null,{"$f":"AR8","v":0},0,0,0,null,{"$f":"+BA8+BB8","v":0},null,null,null,{"$f":"BA8","v":0},0,0,0,null,{"$f":"+BJ8+BK8","v":0},null,null,null,{"$f":"BJ8","v":0},0,0,0,null,{"$f":"+BS8+BT8","v":0},null,null,null,{"$f":"BS8","v":0},0,0,0,null,{"$f":"+CB8+CC8","v":0},null,null,null,{"$f":"CB8","v":0},0,0,0,null,{"$f":"+CK8+CL8","v":0},null,null,null,{"$f":"CK8","v":0},0,0,0,null,{"$f":"+CT8+CU8","v":0},null,null,null,{"$f":"CT8","v":0},0,0,0,null,{"$f":"+DC8+DD8","v":0}]
[{"$f":"LEFT($A$1,4)&\"RISK\"","v":"2200RISK"},"R3 : Pénalités sur maintenance corrective en régiments",null,null,0,110,{"$f":"+E9+F9","v":110},0,110,{"$f":"+H9+I9","v":110},null,null,null,0,110,110,0,110,{"$f":"+Q9+R9","v":110},null,null,null,0,110,110,0,null,{"$f":"+Z9+AA9","v":0},null,null,null,0,0,0,0,null,{"$f":"+AI9+AJ9","v":0},null,null,null,0,0,0,0,null,{"$f":"+AR9+AS9","v":0},null,null,null,0,0,0,0,null,{"$f":"+BA9+BB9","v":0},null,null,null,0,0,0,0,null,{"$f":"+BJ9+BK9","v":0},null,null,null,0,0,0,0,null,{"$f":"+BS9+BT9","v":0},null,null,null,0,0,0,0,null,{"$f":"+CB9+CC9","v":0},null,null,null,0,0,0,0,null,{"$f":"+CK9+CL9","v":0},null,null,null,0,0,0,0,null,{"$f":"+CT9+CU9","v":0},null,null,null,0,0,0,0,null,{"$f":"+DC9+DD9","v":0}]
["2200RISK","R4 : Risques divers",null,null,0,76,{"$f":"+E10+F10","v":76},0,76,{"$f":"+H10+I10","v":76},null,null,null,0,76,76,0,76,{"$f":"+Q10+R10","v":76},null,null,null,0,76,76,0,null,{"$f":"+Z10+AA10","v":0},null,null,null,0,0,0,0,null,{"$f":"+AI10+AJ10","v":0},null,null,null,0,0,0,0,null,{"$f":"+AR10+AS10","v":0},null,null,null,0,0,0,0,null,{"$f":"+BA10+BB10","v":0},null,null,null,0,0,0,0,null,{"$f":"+BJ10+BK10","v":0},null,null,null,0,0,0,0,null,{"$f":"+BS10+BT10","v":0},null,null,null,0,0,0,0,null,{"$f":"+CB10+CC10","v":0},null,null,null,0,0,0,0,null,{"$f":"+CK10+CL10","v":0},null,null,null,0,0,0,0,null,{"$f":"+CT10+CU10","v":0},null,null,null,0,0,0,0,null,{"$f":"+DC10+DD10","v":0}]
[null,null,null,null,{"$f":"SUM(E8:E10)","v":0},{"$f":"SUM(F8:F10)","v":236},{"$f":"+E11+F11","v":236},{"$f":"SUM(H8:H10)","v":0},{"$f":"SUMIFS('[1]PFA 01'!$BX:$BX,'[1]PFA 01'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 01'!$BX:$BX,'[1]PFA 01'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+H11+I11","v":0},{"$f":"J11-G11","v":-236},null,null,0,0,0,{"$f":"SUM(Q8:Q10)","v":0},{"$f":"SUMIFS('[1]PFA 02'!$BX:$BX,'[1]PFA 02'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 02'!$BX:$BX,'[1]PFA 02'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+Q11+R11","v":0},{"$f":"S11-P11","v":0},null,null,0,0,0,{"$f":"SUM(Z8:Z10)","v":0},{"$f":"SUMIFS('[1]PFA 03'!$BX:$BX,'[1]PFA 03'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 03'!$BX:$BX,'[1]PFA 03'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+Z11+AA11","v":0},{"$f":"AB11-Y11","v":0},null,null,0,0,0,{"$f":"SUM(AI8:AI10)","v":0},{"$f":"SUMIFS('[1]PFA 04'!$BX:$BX,'[1]PFA 04'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 04'!$BX:$BX,'[1]PFA 04'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+AI11+AJ11","v":0},{"$f":"AK11-AH11","v":0},null,null,0,0,0,{"$f":"SUM(AR8:AR10)","v":0},{"$f":"SUMIFS('[1]PFA 05'!$BX:$BX,'[1]PFA 05'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 05'!$BX:$BX,'[1]PFA 05'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+AR11+AS11","v":0},{"$f":"AT11-AQ11","v":0},null,null,0,0,0,{"$f":"SUM(BA8:BA10)","v":0},{"$f":"SUMIFS('[1]PFA 06'!$BX:$BX,'[1]PFA 06'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 06'!$BX:$BX,'[1]PFA 06'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+BA11+BB11","v":0},{"$f":"BC11-AZ11","v":0},null,null,0,0,0,{"$f":"SUM(BJ8:BJ10)","v":0},{"$f":"SUMIFS('[1]PFA 07'!$BX:$BX,'[1]PFA 07'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 07'!$BX:$BX,'[1]PFA 07'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+BJ11+BK11","v":0},{"$f":"BL11-BI11","v":0},null,null,0,0,0,{"$f":"SUM(BS8:BS10)","v":0},{"$f":"SUMIFS('[1]PFA 08'!$BX:$BX,'[1]PFA 08'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 08'!$BX:$BX,'[1]PFA 08'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+BS11+BT11","v":0},{"$f":"BU11-BR11","v":0},null,null,0,0,0,{"$f":"SUM(CB8:CB10)","v":0},{"$f":"SUMIFS('[1]PFA 09'!$BX:$BX,'[1]PFA 09'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 09'!$BX:$BX,'[1]PFA 09'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+CB11+CC11","v":0},{"$f":"CD11-CA11","v":0},null,null,0,0,0,{"$f":"SUM(CK8:CK10)","v":0},{"$f":"SUMIFS('[1]PFA 10'!$BX:$BX,'[1]PFA 10'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 10'!$BX:$BX,'[1]PFA 10'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+CK11+CL11","v":0},{"$f":"CM11-CJ11","v":0},null,null,0,0,0,{"$f":"SUM(CT8:CT10)","v":0},{"$f":"SUMIFS('[1]PFA 11'!$BX:$BX,'[1]PFA 11'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 11'!$BX:$BX,'[1]PFA 11'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+CT11+CU11","v":0},{"$f":"CV11-CS11","v":0},null,null,0,0,0,{"$f":"SUM(DC8:DC10)","v":0},{"$f":"SUMIFS('[1]PFA 12'!$BX:$BX,'[1]PFA 12'!$B:$B,\"RAF RISK\")+SUMIFS('[1]PFA 12'!$BX:$BX,'[1]PFA 12'!$B:$B,\"RAF RISKS\")","v":0},{"$f":"+DC11+DD11","v":0},{"$f":"DE11-DB11","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K8:K10)=K11,\"ok\",\"A justifier CDP\")","v":"A justifier CDP"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T8:T10)=T11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AC8:AC10)=AC11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AL8:AL10)=AL11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AU8:AU10)=AU11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD8:BD10)=BD11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BM8:BM10)=BM11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BV8:BV10)=BV11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CE8:CE10)=CE11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CN8:CN10)=CN11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CW8:CW10)=CW11,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(DF8:DF10)=DF11,\"ok\",\"A justifier CDP\")","v":"ok"}]
[]
[{"$f":"LEFT($A$1,4)&\"OPPOR\"","v":"2200OPPOR"},"O1 : Calcul optimisé des rotations",null,null,0,-7.6,{"$f":"+E14+F14","v":-7.6},0,-7.6,{"$f":"+H14+I14","v":-7.6},null,null,null,0,-7.6,-7.6,0,-7.6,{"$f":"+Q14+R14","v":-7.6},null,null,null,0,-7.6,-7.6,0,null,{"$f":"+Z14+AA14","v":0},null,null,null,{"$f":"Z14","v":0},0,0,0,null,{"$f":"+AI14+AJ14","v":0},null,null,null,{"$f":"AI14","v":0},0,0,0,null,{"$f":"+AR14+AS14","v":0},null,null,null,{"$f":"AR14","v":0},0,0,0,null,{"$f":"+BA14+BB14","v":0},null,null,null,{"$f":"BA14","v":0},0,0,0,null,{"$f":"+BJ14+BK14","v":0},null,null,null,{"$f":"BJ14","v":0},0,0,0,null,{"$f":"+BS14+BT14","v":0},null,null,null,{"$f":"BS14","v":0},0,0,0,null,{"$f":"+CB14+CC14","v":0},null,null,null,{"$f":"CB14","v":0},0,0,0,null,{"$f":"+CK14+CL14","v":0},null,null,null,{"$f":"CK14","v":0},0,0,0,null,{"$f":"+CT14+CU14","v":0},null,null,null,{"$f":"CT14","v":0},0,0,0,null,{"$f":"+DC14+DD14","v":0}]
[{"$f":"LEFT($A$1,4)&\"OPPOR\"","v":"2200OPPOR"},"O3 : Numérisation des activités",null,null,0,-40,{"$f":"+E15+F15","v":-40},0,-40,{"$f":"+H15+I15","v":-40},null,null,null,0,-40,-40,0,-40,{"$f":"+Q15+R15","v":-40},null,null,null,0,-40,-40,0,null,{"$f":"+Z15+AA15","v":0},null,null,null,0,0,0,0,null,{"$f":"+AI15+AJ15","v":0},null,null,null,0,0,0,0,null,{"$f":"+AR15+AS15","v":0},null,null,null,0,0,0,0,null,{"$f":"+BA15+BB15","v":0},null,null,null,0,0,0,0,null,{"$f":"+BJ15+BK15","v":0},null,null,null,0,0,0,0,null,{"$f":"+BS15+BT15","v":0},null,null,null,0,0,0,0,null,{"$f":"+CB15+CC15","v":0},null,null,null,0,0,0,0,null,{"$f":"+CK15+CL15","v":0},null,null,null,0,0,0,0,null,{"$f":"+CT15+CU15","v":0},null,null,null,0,0,0,0,null,{"$f":"+DC15+DD15","v":0}]
[{"$f":"LEFT($A$1,4)&\"OPPOR\"","v":"2200OPPOR"},"O5 : Optimisation Offre ECA",null,null,0,-24,{"$f":"+E16+F16","v":-24},0,-24,{"$f":"+H16+I16","v":-24},null,null,null,0,-24,-24,0,-24,{"$f":"+Q16+R16","v":-24},null,null,null,0,-24,-24,0,null,{"$f":"+Z16+AA16","v":0},null,null,null,0,0,0,0,null,{"$f":"+AI16+AJ16","v":0},null,null,null,0,0,0,0,null,{"$f":"+AR16+AS16","v":0},null,null,null,0,0,0,0,null,{"$f":"+BA16+BB16","v":0},null,null,null,0,0,0,0,null,{"$f":"+BJ16+BK16","v":0},null,null,null,0,0,0,0,null,{"$f":"+BS16+BT16","v":0},null,null,null,0,0,0,0,null,{"$f":"+CB16+CC16","v":0},null,null,null,0,0,0,0,null,{"$f":"+CK16+CL16","v":0},null,null,null,0,0,0,0,null,{"$f":"+CT16+CU16","v":0},null,null,null,0,0,0,0,null,{"$f":"+DC16+DD16","v":0}]
[null,null,null,null,{"$f":"SUM(E14:E16)","v":0},{"$f":"SUM(F14:F16)","v":-71.599999999999994},{"$f":"SUM(G14:G16)","v":-71.599999999999994},{"$f":"SUM(H14:H16)","v":0},50000,{"$f":"+H17+I17","v":50000},{"$f":"J17-G17","v":50071.6},null,null,0,50000,50000,{"$f":"SUM(Q14:Q16)","v":0},{"$f":"SUMIFS('[1]PFA 02'!$BX:$BX,'[1]PFA 02'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+Q17+R17","v":0},{"$f":"S17-P17","v":-50000},null,null,0,0,0,{"$f":"SUM(Z14:Z16)","v":0},{"$f":"SUMIFS('[1]PFA 03'!$BX:$BX,'[1]PFA 03'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+Z17+AA17","v":0},{"$f":"AB17-Y17","v":0},null,null,0,0,0,{"$f":"SUM(AI14:AI16)","v":0},{"$f":"SUMIFS('[1]PFA 04'!$BX:$BX,'[1]PFA 04'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+AI17+AJ17","v":0},{"$f":"AK17-AH17","v":0},null,null,0,0,0,{"$f":"SUM(AR14:AR16)","v":0},{"$f":"SUMIFS('[1]PFA 05'!$BX:$BX,'[1]PFA 05'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+AR17+AS17","v":0},{"$f":"AT17-AQ17","v":0},null,null,0,0,0,{"$f":"SUM(BA14:BA16)","v":0},{"$f":"SUMIFS('[1]PFA 06'!$BX:$BX,'[1]PFA 06'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+BA17+BB17","v":0},{"$f":"BC17-AZ17","v":0},null,null,0,0,0,{"$f":"SUM(BJ14:BJ16)","v":0},{"$f":"SUMIFS('[1]PFA 07'!$BX:$BX,'[1]PFA 07'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+BJ17+BK17","v":0},{"$f":"BL17-BI17","v":0},null,null,0,0,0,{"$f":"SUM(BS14:BS16)","v":0},{"$f":"SUMIFS('[1]PFA 08'!$BX:$BX,'[1]PFA 08'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+BS17+BT17","v":0},{"$f":"BU17-BR17","v":0},null,null,0,0,0,{"$f":"SUM(CB14:CB16)","v":0},{"$f":"SUMIFS('[1]PFA 09'!$BX:$BX,'[1]PFA 09'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+CB17+CC17","v":0},{"$f":"CD17-CA17","v":0},null,null,0,0,0,{"$f":"SUM(CK14:CK16)","v":0},{"$f":"SUMIFS('[1]PFA 10'!$BX:$BX,'[1]PFA 10'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+CK17+CL17","v":0},{"$f":"CM17-CJ17","v":0},null,null,0,0,0,{"$f":"SUM(CT14:CT16)","v":0},{"$f":"SUMIFS('[1]PFA 11'!$BX:$BX,'[1]PFA 11'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+CT17+CU17","v":0},{"$f":"CV17-CS17","v":0},null,null,0,0,0,{"$f":"SUM(DC14:DC16)","v":0},{"$f":"SUMIFS('[1]PFA 12'!$BX:$BX,'[1]PFA 12'!$B:$B,\"RAF OPPOR\")","v":0},{"$f":"+DC17+DD17","v":0},{"$f":"DE17-DB17","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K14:K16)=K17,\"ok\",\"A justifier CDP\")","v":"A justifier CDP"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T14:T16)=T17,\"ok\",\"A justifier CDP\")","v":"A justifier CDP"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AC14:AC16)=AC17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AL14:AL16)=AL17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AU14:AU16)=AU17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BD14:BD16)=BD17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BM14:BM16)=BM17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BV14:BV16)=BV17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CE14:CE16)=CE17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CN14:CN16)=CN17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CW14:CW16)=CW17,\"ok\",\"A justifier CDP\")","v":"ok"},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(DF14:DF16)=DF17,\"ok\",\"A justifier CDP\")","v":"ok"}]
[]
[]
["OE",null,null,"Budget","Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP"]

{"sheet":"BDGT","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
["Projet :"]
["Type de coûts :","BUD"]
["Révision de coûts :","00","Suppression :","Y"]
["Taux achat :",1]
["Taux ST :",1,null,null,"PROJET_20220209161937.xml"]
["Taux ST coop. :",1]
["Taux frais :",1]
["Taux transport :",1]
[]
["Type","Code projet","Nom de la tâche","Code centre de coûts","Heures","Taux","Montant","Date de début","Date de fin","Code MSP"]
["FD1","2200RISKS","R1 : Maintenance corrective sous-estimée",null,null,null,50000,"2021-01-03","2022-12-31"]
["FD1","2200RISKS","R3 : Pénalités sur maintenance corrective en régiments",null,null,null,110000]
["FD1","2200RISKS","R4 : Risques divers",null,null,null,76000]
[null,null,null,null,null,null,{"$f":"SUM(G11:G13)","v":236000}]
[]
[]
[]
["FD1","2200OPPOR","O1 : Calcul optimisé des rotations",null,null,null,-7600]
["FD1","2200OPPOR","O3 : Numérisation des activités",null,null,null,-40000]
["FD1","2200OPPOR","O5 : Optimisation Offre ECA",null,null,null,-24000]