{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Encours","Original","ccm"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Encours","index":0,"n_rows":49,"n_cols":23,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,14,0,19]]}
[null,"Suivi",null,null,null,null,null,null,null,null,null,null,null,null,"Résultat attendu feuille Encours",null,null,null,null,null,null,"Résultat feuille Original"]
["Pays","Departement","Ville","Nom","Resultat","Montant",null,null,null,null,null,null,null,null,null,"Suivi",null,null,null,null,null,"Suivi"]
[null,null,"Paris",null,null,{"$f":"SUM(F4:F12)","v":5.3140000000000009},null,null,null,null,null,null,null,null,"Pays","Departement","Ville","Nom","Resultat","Montant"]
["France","Ile de France",null," P / Cont",null,0.90800000000000003,null,null,null,null,null,null,null,null,null,null,"Paris",null,null,{"$f":"SUM(T5:T13)","v":5.3140000000000009},null,"Nom","Montant"]
["France",null,null,"Paris / Support",null,0.6,"Nom OK / Somme KO",null,null,null,null,null,null,null,"France","Ile de France",null," P / Cont","Pas trouvé",0.90800000000000003,null,"Paris / Cont",0.90728324715615405]
["France",null,null,"Paris / V",null,0.44400000000000001,null,null,null,null,null,null,null,null,"France",null,null,"Paris / Support",0.56299999999999994,0.6,null,"Paris / Cont",0.90728324715615383]
["France",null,null,"Paris / Y",null,2.2330000000000001,null,null,null,null,null,null,null,null,"France",null,null,"Paris / V","Pas trouvé",0.44400000000000001,null,"Paris / M"]
[null,null,null,"Paris / R-M",null,0.33200000000000002,null,null,null,null,null,null,null,null,"France",null,null,"Paris / Y","Pas trouvé",2.2330000000000001,null,"Paris / Support",0.56283333333333296]
[null,null,null,"Paris / team",null,null,null,null,null,null,null,null,null,null,null,null,null,"Paris / R-M","Idem",0.33200000000000002,null,"Paris / P",0.49399999999999999]
[null,null,null,"Paris / RSP",null,2.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,"Paris / team","Pas trouvé",null,null,"Paris / R-M",0.33200000000000002]
["France",null,null,"Paris-1 / V",null,0.23799999999999999,"Nom OK / Somme KO",null,null,null,null,null,null,null,null,null,null,"Paris / RSP","Idem",2.5000000000000001E-2,null,"Paris / RSP",2.5000000000000001E-2]
["France",null,null,"Paris-1 / Y",null,0.53400000000000003,null,null,null,null,null,null,null,null,"France",null,null,"Paris-1 / V",0.13800000000000001,0.23799999999999999,null,"Paris / S",2.2328999999999999]
[null,null,"Lyon",null,null,{"$f":"SUM(F14:F19)","v":2.0010000000000003},null,null,null,null,null,null,null,null,"France",null,null,"Paris-1 / Y","Pas trouvé",0.53400000000000003,null,"Paris-1 / V",0.13800000000000001]
["France","Rhone Alpes",null,"Lyon / Cont",null,0.64300000000000002,"Nom OK / Somme KO",null,null,null,null,null,null,null,null,null,"Lyon",null,null,{"$f":"SUM(T15:T20)","v":2.0010000000000003},null,"Paris-1 / S",0.53400000000000003]
[null,null,null,"Lyon / Cont / M",null,0.32700000000000001,null,null,null,null,null,null,null,null,"France","Rhone Alpes",null,"Lyon / Cont",0.69099999999999995,0.64300000000000002,null,"Lyon / Cont",0.69100000000000006]
[null,null,null,"Lyon / NS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lyon / Cont / M","Idem",0.32700000000000001,null,"Lyon / Cont / M",0.327383807568843]
[null,null,null,"Lyon / Support",null,0.372,null,null,null,null,null,null,null,null,null,null,null,"Lyon / NS","Idem",null,null,"Lyon / Cont / MM",0.65872421600639997]
[null,null,null,"Lyon / N",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lyon / Support","Idem",0.372,null,"Lyon / NS",0]
[null,null,null,"Lyon / team",null,0.65900000000000003,null,null,null,null,null,null,null,null,null,null,null,"Lyon / N","Idem",null,null,"Lyon / N",0]
[null,null,null,"L1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lyon / team","Pas trouvé",0.65900000000000003,null,"Lyon / Support",0.37207078400509053]
[null,null,null,"L2",null,null,null,null,null,null,null,null,null,null,null,null,null,"L1","Pas trouvé",null,null,"Marseille"]
[null,null,null,"L3",null,null,null,null,null,null,null,null,null,null,null,null,null,"L2","Pas trouvé",null,null,"Marseille/C",2.26746761128679]
[null,null,null,"L4",null,null,null,null,null,null,null,null,null,null,null,null,null,"L3","Pas trouvé",null,null,"Marseille / U",0.51300000000000001]
[null,null,"Marseille",null,null,{"$f":"SUM(F25:F36)","v":2.871},null,null,null,null,null,null,null,null,null,null,null,"L4","Pas trouvé",null,null,"Marseille/A"]
["France","Bouche du rhone",null,"Marseille/C",null,2.2669999999999999,null,null,null,null,null,null,null,null,null,null,"Marseille",null,null,{"$f":"SUM(T26:T37)","v":2.871},null,"Marseille/B",0]
[null,null,null,"Marseille/CI",null,null,null,null,null,null,null,null,null,null,"France","Bouche du rhone",null,"Marseille/C","Idem",2.2669999999999999,null,"Marseille / Team",8.3906666666666671E-2]
[null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marseille/CI","Pas trouvé",null,null,"Marseille/T",5.7000000000000051E-2]
[null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Pas trouvé",null,null,"Team",8.9999999999999993E-3]
[null,null,null,"Marseille / U",null,0.46300000000000002,"Nom OK / Somme KO",null,null,null,null,null,null,null,null,null,null,2,"Pas trouvé",null,null,"Toulouse / N",3.6999999999999998E-2]
[null,null,null,"Marseille / UC",null,null,null,null,null,null,null,null,null,null,null,null,null,"Marseille / U",0.51300000000000001,0.46300000000000002,null,"Toulouse / O",8.3000000000000004E-2]
[null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marseille / UC","Pas trouvé",null,null,"Toulouse / Team",0]
[null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Pas trouvé",null,null,"IP /",0]
[null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Pas trouvé",null,null,"IP / Test"]
[null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Pas trouvé",null,null,"IP / Team",1]
[null,null,null,"Marseille/T",null,5.7000000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,8,"Pas trouvé",null,null,"LAR",0.64695241116751312]
[null,null,null,"Marseille / Team",null,8.4000000000000005E-2,null,null,null,null,null,null,null,null,null,null,null,"Marseille/T","Idem",5.7000000000000002E-2,null,"M&F",0]
[null,null,"Toulouse",null,null,{"$f":"SUM(F38:F42)","v":0.11},null,null,null,null,null,null,null,null,null,null,null,"Marseille / Team","Idem",8.4000000000000005E-2,null,"Total général",12.88]
["France","Midi Pyrenees",null,"Toulouse / m",null,null,null,null,null,null,null,null,null,null,null,null,"Toulouse",null,null,{"$f":"SUM(T39:T43)","v":0.11}]
[null,null,null,"Toulouse / N",null,null,"Nom OK / Somme KO",null,null,null,null,null,null,null,"France","Midi Pyrenees",null,"Toulouse / m","Pas trouvé"]
[null,null,null,"Toulouse / NT",null,2.7E-2,null,null,null,null,null,null,null,null,null,null,null,"Toulouse / N",3.6999999999999998E-2]
[null,null,null,"Toulouse / O",null,8.3000000000000004E-2,null,null,null,null,null,null,null,null,null,null,null,"Toulouse / NT","Pas trouvé",2.7E-2]
[null,null,null,"Toulouse / Team",null,null,null,null,null,null,null,null,null,null,null,null,null,"Toulouse / O","Idem",8.3000000000000004E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toulouse / Team","Idem"]
["Italie",null,"Rome",null,null,{"$f":"SUM(F45:F47)","v":0.12},null,null,null,null,null,null,null,null,null,null,null,null,"Pas trouvé"]
[null,null,null,"M&F",null,0.12,"Nom OK / Somme KO",null,null,null,null,null,null,null,"Italie",null,"Rome",null,null,{"$f":"SUM(T46:T48)","v":0.12}]
[null,null,null,"IP /",null,null,null,null,null,null,null,null,null,null,null,null,null,"M&F",0,0.12]
[null,null,null,"IP / Team",null,null,"Nom OK / Somme KO",null,null,null,null,null,null,null,null,null,null,"IP /","Idem"]
[null,null,null,"TOTAL",null,{"$f":"F44+F37+F24+F13+F3","v":10.416},null,null,null,null,null,null,null,null,null,null,null,"IP / Team",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","Pas trouvé",{"$f":"T45+T38+T25+T14+T4","v":10.416}]

{"sheet":"Original","index":1,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Suivi"]
[]
["Nom","Montant"]
["Paris / Cont",0.90728324715615405,1]
["Paris / Cont",0.90728324715615383,2]
["Paris / M",null,3]
["Paris / Support",0.56283333333333296,4]
["Paris / P",0.49399999999999999,5]
["Paris / R-M",0.33200000000000002,6]
["Paris / RSP",2.5000000000000001E-2,7]
["Paris / S",2.2328999999999999,8]
["Paris-1 / V",0.13800000000000001,9]
["Paris-1 / S",0.53400000000000003,10]
["Lyon / Cont",0.69100000000000006,11]
["Lyon / Cont / M",0.327383807568843,12]
["Lyon / Cont / MM",0.65872421600639997,13]
["Lyon / NS",0,14]
["Lyon / N",0,15]
["Lyon / Support",0.37207078400509053,16]
["Marseille",null,17]
["Marseille/C",2.26746761128679,18]
["Marseille / U",0.51300000000000001,19]
["Marseille/A",null,20]
["Marseille/B",0,21]
["Marseille / Team",8.3906666666666671E-2,22]
["Marseille/T",5.7000000000000051E-2,23,{"$f":"COUNTIF(A:A,\"ip /\")","v":1}]
["Team",8.9999999999999993E-3,24]
["Toulouse / N",3.6999999999999998E-2,25]
["Toulouse / O",8.3000000000000004E-2,26]
["Toulouse / Team",0,27]
["IP /",0,28]
["IP / Test",null,29]
["IP / Team",1,30]
["LAR",0.64695241116751312,31]
["M&F",0,32]
["Total général",12.88]

{"sheet":"ccm","index":2,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,"Suivi"]
["Pays","Departement","Ville","Nom","Resultat","Montant",null,"Comparer les contenus des  deux plages dans deux feuilles : "]
[null,null,"Paris",null,null,{"$f":"SUM(F4:F12)","v":5.3140000000000009},null,null,"colonnes D et F de la feuille\" Encours\" avec le contenu des "]
["France","Ile de France",null,"Paris / Cont",null,0.90800000000000003,null,null,"colonnes A et B de la feuille \"Original\"."]
["France",null,null,"Paris / Support",null,0.6,null,"En détail les étapes à effectuer :"]
["France",null,null,"Paris / V",null,0.44400000000000001,null,"1 - Si contenu de la colonne D (feuille  Encours) vide, passer à la valeur suivante "]
["France",null,null,"Paris / Y",null,2.2330000000000001,null,"2- Si contenu des colonnes D  (feuille Encours) et A (feuille Original) différent,  noter feuille Encours, colonne E \"Pas trouvé\" et passer à la valeur suivante."]
[null,null,null,"Paris / R-M",null,0.33200000000000002,null,"3 - Si contenu des colonnes D  (feuille Encours) et A (feuille Original) identique,  comparer les valeurs correspondantes des colonnes F (feuille Encours) et B (feuille Original),"]
[null,null,null,"Paris / team",null,null,null,"   Si valeurs identiques (colonnes D, F avec A,B), mettre \"Idem\" en colonne E (feuille encours)"]
[null,null,null,"Paris / RSP",null,2.5000000000000001E-2,null,"   Si valeurs identiques colonnes D et A, mais valeurs différentes pour colonnes F et B, noter le montant de la feuille Original dans la colonne E \"Result\" de la feuille \"Encours\"."]
["France",null,null,"Paris-1 / V",null,0.23799999999999999,null,"   Mettre le fonds de  la cellule en rouge."]
["France",null,null,"Paris-1 / Y",null,0.53400000000000003,null," 4 - Identifier (fonds de cellule  colonne A de couleur) dans la feuille \"Original\" les noms pas présents dans la feuille \"Encours\""]
[null,null,"Lyon",null,null,{"$f":"SUM(F14:F19)","v":2.0010000000000003},null,"PB. parfois dans la feuille \"Original\" nous pouvons avoir plusieurs lignes  avec le même nom et des montants différents et en regard dans la feuille \"Encours\"  une seule ligne,"]
["France","Rhone Alpes",null,"Lyon / Cont",null,0.64300000000000002,null,"Par conséquent si on trouve les même noms entre les deux feuilles, on doit ajouter les montants feuille Original avant comparaison et report de donnée dans la feuille Encours."]
[null,null,null,"Lyon / Cont / M",null,0.32700000000000001,null,"Avant de relancer, feuille Encours, effacer contenu de la colonne E, enlever les couleurs dans la colonne D "]
[null,null,null,"Lyon / NS"]
[null,null,null,"Lyon / Support",null,0.372]
[null,null,null,"Lyon / N"]
[null,null,null,"Lyon / team",null,0.65900000000000003]
[null,null,null,"L1"]
[null,null,null,"L2"]
[null,null,null,"L3"]
[null,null,null,"L4"]
[null,null,"Marseille",null,null,{"$f":"SUM(F25:F36)","v":2.871}]
["France","Bouche du rhone",null,"Marseille/C",null,2.2669999999999999]
[null,null,null,"Marseille/CI"]
[null,null,null,1]
[null,null,null,2]
[null,null,null,"Marseille / U",null,0.46300000000000002]
[null,null,null,"Marseille / UC"]
[null,null,null,3]
[null,null,null,5]
[null,null,null,4]
[null,null,null,8]
[null,null,null,"Marseille/T",null,5.7000000000000002E-2]
[null,null,null,"Marseille / Team",null,8.4000000000000005E-2]
[null,null,"Toulouse",null,null,{"$f":"SUM(F38:F42)","v":0.11}]
["France","Midi Pyrenees",null,"Toulouse / m"]
[null,null,null,"Toulouse / N"]
[null,null,null,"Toulouse / NT",null,2.7E-2]
[null,null,null,"Toulouse / O",null,8.3000000000000004E-2]
[null,null,null,"Toulouse / Team"]
[]
["Italie",null,"Rome",null,null,{"$f":"SUM(F45:F47)","v":0.12}]
[null,null,null,"M&F",null,0.12]
[null,null,null,"IP /"]
[null,null,null,"IP / Team"]
[null,null,null,"Total général",null,{"$f":"F44+F37+F24+F13+F3","v":10.416}]