{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TEST","SYNTHESE","TCD","BASE","LISTE"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":16,"comments":0,"pivot_tables":2},"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":"TEST","index":0,"n_rows":78,"n_cols":39,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,16,1,24],[1,27,1,29],[1,31,1,33],[1,34,1,36],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[1,4,1,12],[1,13,1,15]]}
["I",null,null,null,{"$f":"SUMPRODUCT((E5:E370=\"O\")+(E5:E370=\"U\"))","v":3},{"$f":"SUMPRODUCT((F5:F370=\"O\")+(F5:F370=\"U\"))","v":3},5,3,3,4,5,2,2,3,3,3,4,3,4,4,3,6,6,3,3,3,3,4,5,5,2,2,3,3,5,5,5,3,3]
["L",null,null,null,"AA",null,null,null,null,null,null,null,null,"BB",null,null,"CC",null,null,null,null,null,null,null,null,"DD","EE","FF",null,null,"GG","HH",null,null,"II",null,null,"JJ","KK"]
["Affectation","Lieu de travail","Poste principal","Prénom Nom - % temps affecté","PERIMETRE 1","PERIMETRE 2","PERIMETRE 3","PERIMETRE 4","PERIMETRE 5","PERIMETRE 6","PERIMETRE 7","PERIMETRE 8","PERIMETRE 9","PERIMETRE 10","PERIMETRE 11","PERIMETRE 12","PERIMETRE 13","PERIMETRE 14","PERIMETRE 15","PERIMETRE 16","PERIMETRE 17","PERIMETRE 18","PERIMETRE 19","PERIMETRE 20","PERIMETRE 21","PERIMETRE 22","PERIMETRE 23","PERIMETRE 24","PERIMETRE 25","PERIMETRE 26","PERIMETRE 27","PERIMETRE 28","PERIMETRE 29","PERIMETRE 30","PERIMETRE 31","PERIMETRE 32","PERIMETRE 33","PERIMETRE 34","PERIMETRE 35"]
[null,null,null,null,0.05,0.15,0.6,0.1,0.65,0.3,0.5,1,1,0.75,0.15,0.15,0.4,0.45,0.45,0.45,0.05,0.75,0.75,0.05,0.05,0.7,0.4,0.5,0.5,0.4,0.9,1,1,1,1,1,0.2,1,1]
[{"$f":"IF(ISNA(VLOOKUP(LEFT(D5,SEARCH(\"-\",D5)-2),PERSONNEL,2,0)),\"-\",VLOOKUP(LEFT(D5,SEARCH(\"-\",D5)-2),PERSONNEL,2,0))","v":"4-Service"},{"$f":"IF(ISNA(VLOOKUP(LEFT(D5,SEARCH(\"-\",D5)-2),PERSONNEL,3,0)),\"-\",VLOOKUP(LEFT(D5,SEARCH(\"-\",D5)-2),PERSONNEL,3,0))","v":"Marseille"},{"$f":"IF(ISNA(VLOOKUP(LEFT(D5,SEARCH(\"-\",D5)-2),PERSONNEL,4,0)),\"-\",VLOOKUP(LEFT(D5,SEARCH(\"-\",D5)-2),PERSONNEL,4,0))","v":"AB"},{"$f":"BASE!$A$5&\" - \"&(SUM(E6:BA6)*100)&\"%\"","v":"AAA - 35%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U","U","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AB",{"$f":"D5","v":"AAA - 35%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
["4-Service","Marseille","AC",{"$f":"BASE!$A$6&\" - \"&(SUM(E8:BA8)*100)&\"%\"","v":"BBB - 0%"},"O","O","O","O","O","O","O","I","I","I","I","I","O","I","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","I","I","I","I","I"]
["4-Service","Marseille","AC",{"$f":"D7","v":"BBB - 0%"}]
["4-Service","Marseille","AD",{"$f":"BASE!$A$7&\" - \"&(SUM(E10:BA10)*100)&\"%\"","v":"CCC - 80%"},"I","I","I","I","I","I","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U","U","I","I"]
["4-Service","Marseille","AD",{"$f":"D9","v":"CCC - 80%"},0.05,0.15,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
["4-Service","Marseille","AB",{"$f":"BASE!$A$8&\" - \"&(SUM(E12:BA12)*100)&\"%\"","v":"DDD - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U","U","U","U","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AB",{"$f":"D11","v":"DDD - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.4]
["4-Service","Paris","AC",{"$f":"BASE!$A$9&\" - \"&(SUM(E14:BA14)*100)&\"%\"","v":"EEE - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","O","O","O","I","O","I","I","I","I","I","I","I"]
["4-Service","Paris","AC",{"$f":"D13","v":"EEE - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,0.5]
["4-Service","Marseille","AD",{"$f":"BASE!$A$10&\" - \"&(SUM(E16:BA16)*100)&\"%\"","v":"FFF - 170%"},"U","U","U","U","U","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AD",{"$f":"D15","v":"FFF - 170%"},null,null,0.6,0.15,0.65,0.3]
["4-Service","Marseille","AB",{"$f":"BASE!$A$11&\" - \"&(SUM(E18:BA18)*100)&\"%\"","v":"GGG - 95%"},"I","I","U","I","I","I","I","I","I","I","I","I","U","U","U","U","I","I","I","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AB",{"$f":"D17","v":"GGG - 95%"},null,null,0.05,null,null,null,null,null,null,null,null,null,0.4,null,null,0.45,null,null,null,0.05]
["4-Service","Marseille","AC",{"$f":"BASE!$A$12&\" - \"&(SUM(E20:BA20)*100)&\"%\"","v":"HHH - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AC",{"$f":"D19","v":"HHH - 0%"}]
["4-Service","Paris","AD",{"$f":"BASE!$A$13&\" - \"&(SUM(E22:BA22)*100)&\"%\"","v":"III - 0%"},"O","O","I","I","I","O","O","I","I","O","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","O","O","O","I","I"]
["4-Service","Paris","AD",{"$f":"D21","v":"III - 0%"}]
["4-Service","Marseille","AB",{"$f":"BASE!$A$14&\" - \"&(SUM(E24:BA24)*100)&\"%\"","v":"JJJ - 100%"},"I","I","I","I","I","I","I","U","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AB",{"$f":"D23","v":"JJJ - 100%"},null,null,null,null,null,null,null,1]
["4-Service","Paris","AC",{"$f":"BASE!$A$15&\" - \"&(SUM(E26:BA26)*100)&\"%\"","v":"KKK - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","O","U","I","I"]
["4-Service","Paris","AC",{"$f":"D25","v":"KKK - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["4-Service","Marseille","AD",{"$f":"BASE!$A$16&\" - \"&(SUM(E28:BA28)*100)&\"%\"","v":"LLL - 50%"},"I","I","I","I","I","I","I","U","U","I","I","I","I","I","I","I","I","I","I","I","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AD",{"$f":"D27","v":"LLL - 50%"},null,null,null,null,null,null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,null,0.1]
["4-Service","Marseille","AB",{"$f":"BASE!$A$17&\" - \"&(SUM(E30:BA30)*100)&\"%\"","v":"MMM - 0%"},"I","I","I","I","I","I","I","I","I","I","U","U","I","I","I","I","I","U","U","I","I","I","I","I","I","I","I","I","I","I","O","O","O","O","O"]
["4-Service","Marseille","AB",{"$f":"D29","v":"MMM - 0%"}]
["4-Service","Marseille","AC",{"$f":"BASE!$A$18&\" - \"&(SUM(E32:BA32)*100)&\"%\"","v":"NNN - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U","I","I","I","I","I"]
["4-Service","Marseille","AC",{"$f":"D31","v":"NNN - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["4-Service","Marseille","AD",{"$f":"BASE!$A$19&\" - \"&(SUM(E34:BA34)*100)&\"%\"","v":"OOO - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","O","U","U","I","I"]
["4-Service","Marseille","AD",{"$f":"D33","v":"OOO - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["4-Service","Paris","AB",{"$f":"BASE!$A$20&\" - \"&(SUM(E36:BA36)*100)&\"%\"","v":"PPP - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Paris","AB",{"$f":"D35","v":"PPP - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"IF(ISNA(VLOOKUP(LEFT(D37,SEARCH(\"-\",D37)-2),PERSONNEL,2,0)),\"-\",VLOOKUP(LEFT(D37,SEARCH(\"-\",D37)-2),PERSONNEL,2,0))","v":"4-Service"},{"$f":"IF(ISNA(VLOOKUP(LEFT(D37,SEARCH(\"-\",D37)-2),PERSONNEL,3,0)),\"-\",VLOOKUP(LEFT(D37,SEARCH(\"-\",D37)-2),PERSONNEL,3,0))","v":"Marseille"},{"$f":"IF(ISNA(VLOOKUP(LEFT(D37,SEARCH(\"-\",D37)-2),PERSONNEL,4,0)),\"-\",VLOOKUP(LEFT(D37,SEARCH(\"-\",D37)-2),PERSONNEL,4,0))","v":"AC"},{"$f":"BASE!$A$21&\" - \"&(SUM(E38:BA38)*100)&\"%\"","v":"QQQ - 60%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U"]
["4-Service","Marseille","AC",{"$f":"D37","v":"QQQ - 60%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
["4-Service","Paris","AD",{"$f":"BASE!$A$22&\" - \"&(SUM(E40:BA40)*100)&\"%\"","v":"RRR - 90%"},"I","I","I","I","I","I","I","I","I","I","I","I","U","U","U","U","U","I","I","I","I","U","U","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Paris","AD",{"$f":"D39","v":"RRR - 90%"},null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,0.45]
["4-Service","Marseille","AB",{"$f":"BASE!$A$23&\" - \"&(SUM(E42:BA42)*100)&\"%\"","v":"SSS - 75%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","I","I","I","I","I","I","I","U","U","U","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AB",{"$f":"D41","v":"SSS - 75%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,null,null,null,null,null,null,0.5,null,0.2]
["4-Service","Marseille","AC",{"$f":"BASE!$A$24&\" - \"&(SUM(E44:BA44)*100)&\"%\"","v":"TTT - 0%"},"I","I","I","I","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AC",{"$f":"D43","v":"TTT - 0%"}]
["4-Service","Marseille","AD",{"$f":"BASE!$A$25&\" - \"&(SUM(E46:BA46)*100)&\"%\"","v":"UUU - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AD",{"$f":"D45","v":"UUU - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["4-Service","Paris","AB",{"$f":"BASE!$A$26&\" - \"&(SUM(E48:BA48)*100)&\"%\"","v":"VVV - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U","I","I","I","I","I"]
["4-Service","Paris","AB",{"$f":"D47","v":"VVV - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["4-Service","Marseille","AC",{"$f":"BASE!$A$27&\" - \"&(SUM(E50:BA50)*100)&\"%\"","v":"WWW - 0%"},"I","I","O","I","I","O","O","I","I","O","O","O","I","I","I","I","I","O","O","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AC",{"$f":"D49","v":"WWW - 0%"}]
["4-Service","Marseille","AD",{"$f":"BASE!$A$28&\" - \"&(SUM(E52:BA52)*100)&\"%\"","v":"XXX - 80%"},"I","I","I","I","I","I","I","I","I","U","U","U","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AD",{"$f":"D51","v":"XXX - 80%"},null,null,null,null,null,null,null,null,null,0.5,0.15,0.15]
["4-Service","Marseille","AB",{"$f":"BASE!$A$29&\" - \"&(SUM(E54:BA54)*100)&\"%\"","v":"YYY - 0%"},"I","I","O","O","I","I","O","I","I","I","I","I","U","U","O","O","I","O","O","O","O","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["4-Service","Marseille","AB",{"$f":"D53","v":"YYY - 0%"}]
["4-Service","Marseille","AC",{"$f":"BASE!$A$30&\" - \"&(SUM(E56:BA56)*100)&\"%\"","v":"ZZZ - 100%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","U","U"]
["4-Service","Marseille","AC",{"$f":"D55","v":"ZZZ - 100%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["-","-","-",{"$f":"BASE!$A$31&\" - \"&(SUM(E58:BA58)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D57","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$32&\" - \"&(SUM(E60:BA60)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D59","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$33&\" - \"&(SUM(E62:BA62)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D61","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$34&\" - \"&(SUM(E64:BA64)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D63","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$35&\" - \"&(SUM(E66:BA66)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D65","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$36&\" - \"&(SUM(E68:BA68)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D67","v":" - 0%"}]
[{"$f":"IF(ISNA(VLOOKUP(LEFT(D69,SEARCH(\"-\",D69)-2),PERSONNEL,2,0)),\"-\",VLOOKUP(LEFT(D69,SEARCH(\"-\",D69)-2),PERSONNEL,2,0))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(LEFT(D69,SEARCH(\"-\",D69)-2),PERSONNEL,3,0)),\"-\",VLOOKUP(LEFT(D69,SEARCH(\"-\",D69)-2),PERSONNEL,3,0))","v":"-"},{"$f":"IF(ISNA(VLOOKUP(LEFT(D69,SEARCH(\"-\",D69)-2),PERSONNEL,4,0)),\"-\",VLOOKUP(LEFT(D69,SEARCH(\"-\",D69)-2),PERSONNEL,4,0))","v":"-"},{"$f":"BASE!$A$37&\" - \"&(SUM(E70:BA70)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D69","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$38&\" - \"&(SUM(E72:BA72)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D71","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$39&\" - \"&(SUM(E74:BA74)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D73","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$40&\" - \"&(SUM(E76:BA76)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D75","v":" - 0%"}]
["-","-","-",{"$f":"BASE!$A$41&\" - \"&(SUM(E78:BA78)*100)&\"%\"","v":" - 0%"},"I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I","I"]
["-","-","-",{"$f":"D77","v":" - 0%"}]

{"sheet":"SYNTHESE","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[null,"Site",null,"Temps passé",null,"Manager"]
[null,{"$f":"IFERROR(VLOOKUP(LEFT(C2,SEARCH(\"-\",C2)-2),BASE,3,0),\" \")","v":" "},null,{"$f":"IF(ISNA(HLOOKUP(A2,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A2,TEST!$E$3:$AK$4,2,0))","v":"-"},null,{"$f":"IFERROR(VLOOKUP(LEFT(C2,SEARCH(\"-\",C2)-2),PERSONNEL,5,0),\" \")","v":" "}]
["TPO - SYNTHESE"]
["Clients ","Site","Gestionnaire principal","Temps passé","Gestionnaire secondaire","Manager","Managers2"]
["PERIMETRE 1",{"$f":"IFERROR(VLOOKUP(LEFT(C5,SEARCH(\"-\",C5)-2),BASE,3,0),\" \")","v":"Marseille"},"CCC - 80%",{"$f":"IF(ISNA(HLOOKUP(A5,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A5,TEST!$E$3:$AK$4,2,0))","v":0.05},"FFF - 170%",{"$f":"IFERROR(VLOOKUP(LEFT(C5,SEARCH(\"-\",C5)-2),PERSONNEL,5,0),\" \")","v":3},{"$f":"F5","v":3}]
["PERIMETRE 2","Marseille","CCC - 80%",{"$f":"IF(ISNA(HLOOKUP(A6,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A6,TEST!$E$3:$AK$4,2,0))","v":0.15},"FFF - 170%",3,{"$f":"F6","v":3}]
["PERIMETRE 3","Marseille","FFF - 170%",{"$f":"IF(ISNA(HLOOKUP(A7,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A7,TEST!$E$3:$AK$4,2,0))","v":0.6},"GGG - 95%",6,6]
["PERIMETRE 4","Marseille","FFF - 170%",{"$f":"IF(ISNA(HLOOKUP(A8,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A8,TEST!$E$3:$AK$4,2,0))","v":0.1},null,6,6]
["PERIMETRE 5","Marseille","FFF - 170%",{"$f":"IF(ISNA(HLOOKUP(A9,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A9,TEST!$E$3:$AK$4,2,0))","v":0.65},null,6,6]
["PERIMETRE 6","Marseille","FFF - 170%",{"$f":"IF(ISNA(HLOOKUP(A10,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A10,TEST!$E$3:$AK$4,2,0))","v":0.3},null,6,6]
["PERIMETRE 7","Marseille","CCC - 80%",{"$f":"IF(ISNA(HLOOKUP(A11,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A11,TEST!$E$3:$AK$4,2,0))","v":0.5},null,3,3]
["PERIMETRE 8","Marseille","JJJ - 100%",{"$f":"IF(ISNA(HLOOKUP(A12,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A12,TEST!$E$3:$AK$4,2,0))","v":1},"LLL - 50%",4,4]
["PERIMETRE 9","Marseille","LLL - 50%",{"$f":"IF(ISNA(HLOOKUP(A13,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A13,TEST!$E$3:$AK$4,2,0))","v":1},"JJJ - 100%",6,6]
["PERIMETRE 10","Marseille","XXX - 80%",{"$f":"IF(ISNA(HLOOKUP(A14,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A14,TEST!$E$3:$AK$4,2,0))","v":0.75},null,6,6]
["PERIMETRE 11","Marseille","XXX - 80%",{"$f":"IF(ISNA(HLOOKUP(A15,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A15,TEST!$E$3:$AK$4,2,0))","v":0.15},null,6,6]
["PERIMETRE 12","Marseille","XXX - 80%",{"$f":"IF(ISNA(HLOOKUP(A16,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A16,TEST!$E$3:$AK$4,2,0))","v":0.15},null,6,6]
["PERIMETRE 13","Marseille","GGG - 95%",{"$f":"IF(ISNA(HLOOKUP(A17,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A17,TEST!$E$3:$AK$4,2,0))","v":0.4},"RRR - 90%",1,1]
["PERIMETRE 14","Paris","RRR - 90%",{"$f":"IF(ISNA(HLOOKUP(A18,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A18,TEST!$E$3:$AK$4,2,0))","v":0.45},"GGG - 95%",6,6]
["PERIMETRE 15","Paris","RRR - 90%",{"$f":"IF(ISNA(HLOOKUP(A19,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A19,TEST!$E$3:$AK$4,2,0))","v":0.45},"GGG - 95%",6,6]
["PERIMETRE 16","Marseille","GGG - 95%",{"$f":"IF(ISNA(HLOOKUP(A20,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A20,TEST!$E$3:$AK$4,2,0))","v":0.45},"RRR - 90%",1,1]
["PERIMETRE 17","Marseille","SSS - 75%",{"$f":"IF(ISNA(HLOOKUP(A21,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A21,TEST!$E$3:$AK$4,2,0))","v":0.05},"RRR - 90%",1,1]
["PERIMETRE 18","Paris","PPP - 100%",{"$f":"IF(ISNA(HLOOKUP(A22,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A22,TEST!$E$3:$AK$4,2,0))","v":0.75},"UUU - 100%",4,4]
["PERIMETRE 19","Marseille","UUU - 100%",{"$f":"IF(ISNA(HLOOKUP(A23,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A23,TEST!$E$3:$AK$4,2,0))","v":0.75},"PPP - 100%",3,3]
["PERIMETRE 20","Marseille","GGG - 95%",{"$f":"IF(ISNA(HLOOKUP(A24,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A24,TEST!$E$3:$AK$4,2,0))","v":0.05},null,1,1]
["PERIMETRE 21","Marseille","LLL - 50%",{"$f":"IF(ISNA(HLOOKUP(A25,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A25,TEST!$E$3:$AK$4,2,0))","v":0.05},null,6,6]
["PERIMETRE 22","Marseille","DDD - 100%",{"$f":"IF(ISNA(HLOOKUP(A26,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A26,TEST!$E$3:$AK$4,2,0))","v":0.7},"RRR - 90%",4,4]
["PERIMETRE 23","Marseille","DDD - 100%",{"$f":"IF(ISNA(HLOOKUP(A27,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A27,TEST!$E$3:$AK$4,2,0))","v":0.4},"RRR - 90%",4,4]
["PERIMETRE 24","Marseille","AAA - 35%",{"$f":"IF(ISNA(HLOOKUP(A28,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A28,TEST!$E$3:$AK$4,2,0))","v":0.5},"EEE - 100%",1,1]
["PERIMETRE 25","Marseille","SSS - 75%",{"$f":"IF(ISNA(HLOOKUP(A29,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A29,TEST!$E$3:$AK$4,2,0))","v":0.5},"EEE - 100%",1,1]
["PERIMETRE 26","Paris","EEE - 100%",{"$f":"IF(ISNA(HLOOKUP(A30,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A30,TEST!$E$3:$AK$4,2,0))","v":0.4},"SSS - 75%",5,5]
["PERIMETRE 27","Marseille","SSS - 75%",{"$f":"IF(ISNA(HLOOKUP(A31,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A31,TEST!$E$3:$AK$4,2,0))","v":0.9},null,1,1]
["PERIMETRE 28","Paris","EEE - 100%",{"$f":"IF(ISNA(HLOOKUP(A32,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A32,TEST!$E$3:$AK$4,2,0))","v":1},null,5,5]
["PERIMETRE 29","Marseille","NNN - 100%",{"$f":"IF(ISNA(HLOOKUP(A33,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A33,TEST!$E$3:$AK$4,2,0))","v":1},"VVV - 100%",2,2]
["PERIMETRE 30","Paris","VVV - 100%",{"$f":"IF(ISNA(HLOOKUP(A34,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A34,TEST!$E$3:$AK$4,2,0))","v":1},"NNN - 100%",4,4]
["PERIMETRE 31","Marseille","OOO - 100%",{"$f":"IF(ISNA(HLOOKUP(A35,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A35,TEST!$E$3:$AK$4,2,0))","v":1},"KKK - 100%",3,3]
["PERIMETRE 32","Paris","KKK - 100%",{"$f":"IF(ISNA(HLOOKUP(A36,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A36,TEST!$E$3:$AK$4,2,0))","v":1},"OOO - 100%",5,5]
["PERIMETRE 33","Marseille","CCC - 80%",{"$f":"IF(ISNA(HLOOKUP(A37,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A37,TEST!$E$3:$AK$4,2,0))","v":0.2},"OOO - 100%",3,3]
["PERIMETRE 34","Marseille","QQQ - 60%",{"$f":"IF(ISNA(HLOOKUP(A38,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A38,TEST!$E$3:$AK$4,2,0))","v":"-"},"ZZZ - 100%",5,5]
["PERIMETRE 35","Marseille","ZZZ - 100%",{"$f":"IF(ISNA(HLOOKUP(A39,TEST!$E$3:$AK$4,2,0)),\"-\",HLOOKUP(A39,TEST!$E$3:$AK$4,2,0))","v":"-"},"QQQ - 60%",2,2]

{"sheet":"TCD","index":2,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Étiquettes de lignes","Gestionnaire principal","% d'occupation théorique"]
[3,"CCC - 80%",0.89999999999999991]
[null,"PERIMETRE 1",0.05]
[null,"PERIMETRE 2",0.15]
[null,"PERIMETRE 7",0.5]
[null,"PERIMETRE 33",0.2]
[null,"UUU - 100%",0.75]
[null,"PERIMETRE 19",0.75]
[null,"OOO - 100%",1]
[null,"PERIMETRE 31",1]
[6,"FFF - 170%",1.6500000000000001]
[null,"PERIMETRE 3",0.6]
[null,"PERIMETRE 4",0.1]
[null,"PERIMETRE 5",0.65]
[null,"PERIMETRE 6",0.3]
[null,"LLL - 50%",1.05]
[null,"PERIMETRE 9",1]
[null,"PERIMETRE 21",0.05]
[null,"XXX - 80%",1.05]
[null,"PERIMETRE 10",0.75]
[null,"PERIMETRE 11",0.15]
[null,"PERIMETRE 12",0.15]
[null,"RRR - 90%",0.9]
[null,"PERIMETRE 14",0.45]
[null,"PERIMETRE 15",0.45]
[4,"JJJ - 100%",1]
[null,"PERIMETRE 8",1]
[null,"PPP - 100%",0.75]
[null,"PERIMETRE 18",0.75]
[null,"DDD - 100%",1.1000000000000001]
[null,"PERIMETRE 22",0.7]
[null,"PERIMETRE 23",0.4]
[null,"VVV - 100%",1]
[null,"PERIMETRE 30",1]
[1,"GGG - 95%",0.90000000000000013]
[null,"PERIMETRE 13",0.4]
[null,"PERIMETRE 16",0.45]
[null,"PERIMETRE 20",0.05]
[null,"SSS - 75%",1.4500000000000002]
[null,"PERIMETRE 17",0.05]
[null,"PERIMETRE 25",0.5]
[null,"PERIMETRE 27",0.9]
[null,"AAA - 35%",0.5]
[null,"PERIMETRE 24",0.5]
[5,"EEE - 100%",1.4]
[null,"PERIMETRE 26",0.4]
[null,"PERIMETRE 28",1]
[null,"KKK - 100%",1]
[null,"PERIMETRE 32",1]
[null,"QQQ - 60%",0]
[null,"PERIMETRE 34",0]
[2,"NNN - 100%",1]
[null,"PERIMETRE 29",1]
[null,"ZZZ - 100%",0]
[null,"PERIMETRE 35",0]
["Total général",null,17.400000000000002]

{"sheet":"BASE","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Nom ","Affectation","Lieu de travail","Poste principal","Manager"]
["AAA","4-Service","Marseille","AB",1]
["BBB","4-Service","Marseille","AC",2]
["CCC","4-Service","Marseille","AD",3]
["DDD","4-Service","Marseille","AB",4]
["EEE","4-Service","Paris","AC",5]
["FFF","4-Service","Marseille","AD",6]
["GGG","4-Service","Marseille","AB",1]
["HHH","4-Service","Marseille","AC",2]
["III","4-Service","Paris","AD",3]
["JJJ","4-Service","Marseille","AB",4]
["KKK","4-Service","Paris","AC",5]
["LLL","4-Service","Marseille","AD",6]
["MMM","4-Service","Marseille","AB",1]
["NNN","4-Service","Marseille","AC",2]
["OOO","4-Service","Marseille","AD",3]
["PPP","4-Service","Paris","AB",4]
["QQQ","4-Service","Marseille","AC",5]
["RRR","4-Service","Paris","AD",6]
["SSS","4-Service","Marseille","AB",1]
["TTT","4-Service","Marseille","AC",2]
["UUU","4-Service","Marseille","AD",3]
["VVV","4-Service","Paris","AB",4]
["WWW","4-Service","Marseille","AC",5]
["XXX","4-Service","Marseille","AD",6]
["YYY","4-Service","Marseille","AB",1]
["ZZZ","4-Service","Marseille","AC",2]

{"sheet":"LISTE","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Sigle","Description",null,"Affectation",null,"Site",null,"Poste principal",null,"Manager"]
["I","Pas formé",null,"4-Service",null,"Marseille",null,"AB",null,1]
["L","En cours de formation",null,null,null,"Paris",null,"AC",null,2,null,"Étiquettes de lignes","% d'occupation théorique"]
["U","Formé",null,null,null,null,null,"AD",null,3,null,"CCC - 80%",0.89999999999999991]
["O","Formé et peut former",null,null,null,null,null,null,null,4,null,"FFF - 170%",1.6500000000000001]
[null,null,null,null,null,null,null,null,null,5,null,"JJJ - 100%",1]
[null,null,null,null,null,null,null,null,null,6,null,"LLL - 50%",1.05]
[null,null,null,null,null,null,null,null,null,null,null,"XXX - 80%",1.05]
[null,null,null,null,null,null,null,null,null,null,null,"GGG - 95%",0.90000000000000013]
[null,null,null,null,null,null,null,null,null,null,null,"RRR - 90%",0.9]
[null,null,null,null,null,null,null,null,null,null,null,"SSS - 75%",1.4500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"PPP - 100%",0.75]
[null,null,null,null,null,null,null,null,null,null,null,"UUU - 100%",0.75]
[null,null,null,null,null,null,null,null,null,null,null,"DDD - 100%",1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,"AAA - 35%",0.5]
[null,null,null,null,null,null,null,null,null,null,null,"EEE - 100%",1.4]
[null,null,null,null,null,null,null,null,null,null,null,"NNN - 100%",1]
[null,null,null,null,null,null,null,null,null,null,null,"VVV - 100%",1]
[null,null,null,null,null,null,null,null,null,null,null,"OOO - 100%",1]
[null,null,null,null,null,null,null,null,null,null,null,"KKK - 100%",1]
[null,null,null,null,null,null,null,null,null,null,null,"QQQ - 60%",0]
[null,null,null,null,null,null,null,null,null,null,null,"ZZZ - 100%",0]
[null,null,null,null,null,null,null,null,null,null,null,"Total général",17.399999999999999]