{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DTR","Modele"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"DTR","index":0,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,4,4,6],[4,7,4,10]]}
[]
[]
[]
[]
[null,null,null,null,{"$f":"\"PFA 12/\"&[1]VBA!$P$8","v":"PFA 12/2021"},null,null,{"$f":"\"PFA 01/\"&[1]VBA!$Q$8","v":"PFA 01/2022"}]
[null,null,null,null,{"$f":"MONTH(RIGHT(E5,7))","v":12},null,null,{"$f":"MONTH(RIGHT(H5,7))","v":1},null,null,"Ecart"]
["OE",null,null,"Budget","Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP"]
["2200RISKS","R1 : Maintenance corrective sous-estimée",null,null,0,null,{"$f":"+E8+F8","v":0},0,50,{"$f":"+H8+I8","v":50}]
["2200RISKS","R3 : Pénalités sur maintenance corrective en régiments",null,null,null,null,{"$f":"+E9+F9","v":0},null,110,{"$f":"+H9+I9","v":110}]
["2200RISKS","R4 : Risques divers",null,null,0,null,{"$f":"+E10+F10","v":0},0,76,{"$f":"+H10+I10","v":76}]
[null,null,null,null,{"$f":"SUM(E8:E8)","v":0},{"$f":"SUM(F8:F10)","v":0},{"$f":"SUM(G8:G10)","v":0},{"$f":"SUM(H8:H8)","v":0},{"$f":"(SUM(I8:I10))/1000","v":0.23599999999999999},{"$f":"I11","v":0.23599999999999999},{"$f":"J11-G11","v":0.23599999999999999}]
[null,null,null,null,null,null,null,null,0,null,{"$f":"IF(SUM(K8:K8)=K11,\"ok\",\"A justifier CDP\")","v":"A justifier CDP"}]
[null,null,null,null,null,null,null,null,0]
["2200OPPOR","O1 : Calcul optimisé des rotations",null,null,0,null,{"$f":"+E14+F14","v":0},0,-7.6,{"$f":"+H14+I14","v":-7.6}]
["2200OPPOR","O3 : Numérisation des activités",null,null,null,null,{"$f":"+E15+F15","v":0},null,-40,{"$f":"+H15+I15","v":-40}]
["2200OPPOR","O5 : Optimisation Offre ECA",null,null,0,null,{"$f":"+E16+F16","v":0},0,-24,{"$f":"+H16+I16","v":-24}]
[null,null,null,null,{"$f":"SUM(E14:E14)","v":0},{"$f":"SUM(F14:F16)","v":0},{"$f":"SUM(G14:G16)","v":0},{"$f":"SUM(H14:H14)","v":0},{"$f":"(SUM(I14:I16))/1000","v":-7.1599999999999997E-2},{"$f":"I17","v":-7.1599999999999997E-2},{"$f":"J17-G17","v":-7.1599999999999997E-2}]
[null,null,null,null,null,null,null,null,0,null,{"$f":"IF(SUM(K14:K14)=K17,\"ok\",\"A justifier CDP\")","v":"A justifier CDP"}]

{"sheet":"Modele","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,13,2],[4,4,4,6],[4,7,4,10],[7,1,7,2],[8,1,8,2],[12,1,12,2]]}
[]
[]
[]
[]
[null,null,null,null,{"$f":"\"PFA 12/\"&[1]VBA!$P$8","v":"PFA 12/2021"},null,null,{"$f":"\"PFA 01/\"&[1]VBA!$Q$8","v":"PFA 01/2022"}]
[null,null,null,null,{"$f":"MONTH(RIGHT(E5,7))","v":12},null,null,{"$f":"MONTH(RIGHT(H5,7))","v":1},null,null,"Ecart"]
["OE",null,null,"Budget","Réalisé","RAF ","Total PFA","Réalisé","RAF ","Total PFA","PFA M-1","Commentaires CDP"]
["3300RISKS","R1 : Maintenance corrective sous-estimée",null,null,0,50,{"$f":"+E8+F8","v":50},0,50,{"$f":"+H8+I8","v":50}]
["3300RISKS","R2 : Maintenance ",null,null,0,50,{"$f":"+E9+F9","v":50},0,50,{"$f":"+H9+I9","v":50}]
[null,null,null,null,{"$f":"SUM(E8:E8)","v":0},{"$f":"SUM(F8:F9)","v":100},{"$f":"SUM(G8:G9)","v":100},{"$f":"SUM(H8:H8)","v":0},{"$f":"SUM(I8:I9)","v":100},{"$f":"I10","v":100},{"$f":"J10-G10","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K8:K8)=K10,\"ok\",\"A justifier CDP\")","v":"ok"}]
[]
["3300OPPOR","O1 : Calcul optimisé des rotations",null,null,0,-7.6,{"$f":"+E13+F13","v":-7.6},0,-7.6,{"$f":"+H13+I13","v":-7.6}]
["3300OPPOR","O2 : avantage optionnel",null,null,0,-7.6,{"$f":"+E14+F14","v":-7.6},0,-7.6,{"$f":"+H14+I14","v":-7.6}]
[null,null,null,null,{"$f":"SUM(E13:E13)","v":0},{"$f":"SUM(F13:F14)","v":-15.2},{"$f":"SUM(G13:G14)","v":-15.2},{"$f":"SUM(H13:H13)","v":0},{"$f":"SUM(I13:I14)","v":-15.2},{"$f":"I15","v":-15.2},{"$f":"J15-G15","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K13:K13)=K15,\"ok\",\"A justifier CDP\")","v":"ok"}]