{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["énoncé","tables","application","import","archive","recapitulatif salariés","recap salarié","recap chantiers"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"énoncé","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"questions :",null,null,null,null,null,null,"d'après dcg 2012"]
[null,"1) complétez la feuille de calcul application avec les formules manquantes"]
[null,"2) élaborez les récapitulatifs par salarié et par chantier (TCD/Somme.si)"]
[null,"3) en quoi cette application est elle mal structurée ?"]
[null,"4) modifiez l'application pour la rendre opérationnelle"]
[null,"5) sécurisez votre nouvelle application"]

{"sheet":"tables","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[36,0,36,3]]}
["ANNEXE 3"]
["Extrait de la feuille de calcul « salariés »"]
["A","B","C","D","E"]
["Matricule","Nom","Prénom","Qualification","Niveau"]
[221,"nom1","prenom1",2,2]
[222,"nom2","prenom2",5,1,null,"tabsal : $a$5:$e$35"]
[223,"nom3","prenom3",3,1]
[224,"nom4","prenom4",1,2,null,"tabqualif : $a$39:$d$44"]
[225,"nom5","prenom5",2,2]
[226,"nom6","prenom6",2,1]
[227,"nom7","prenom7",4,1]
[228,"nom8","prenom8",5,1]
[229,"nom9","prenom9",1,1]
[230,"nom10","prenom10",6,1]
[231,"nom11","prenom11",4,2]
[232,"nom12","prenom12",4,2]
[233,"nom13","prenom13",5,1]
[234,"nom14","prenom14",6,1]
[235,"nom15","prenom15",1,1]
[236,"nom16","prenom16",2,1]
[237,"nom17","prenom17",5,2]
[238,"nom18","prenom18",1,2]
[239,"nom19","prenom19",5,2]
[240,"nom20","prenom20",1,1]
[241,"nom21","prenom21",1,1]
[242,"nom22","prenom22",1,1]
[243,"nom23","prenom23",3,2]
[244,"nom24","prenom24",5,2]
[245,"nom25","prenom25",2,2]
[246,"nom26","prenom26",2,1]
[247,"nom27","prenom27",3,1]
[248,"nom28","prenom28",3,2]
[249,"nom29","prenom29",6,1]
[250,"nom30","prenom30",6,1]
[251,"nom31","prenom31",6,1]
[]
["qualifications"]
["Qualification","Désignation","Niveau 1","Niveau 2"]
[1,"Apprenti",5.55,6.28]
[2,"Ouvrier d’exécution",9.2100000000000009,9.43]
[3,"Ouvrier professionnel",9.99,10.25]
[4,"Compagnon",10.93,11.68]
[5,"Maître ouvrier",12.43,13.19]
[6,"Chef d’équipe",14.15,15.5]

{"sheet":"application","index":2,"n_rows":98,"n_cols":25,"rows_kept":98,"cut":false,"hidden":false,"merged":[[97,0,97,7],[1,0,1,24],[97,18,97,20],[0,0,0,24]]}
["RECAPITULATIF DES HEURES EFFECTUEES SUR UNE SEMAINE DONNEE"]
[]
["Année : ",null,null,null,2012,"Semaine 21","du",{"$f":"MIN(A5:A67)","v":"2012-05-21"},"au",null,null,null,null,null,null,null,null,null,{"$f":"MAX(A5:A67)","v":"2012-05-24"},null,null,null,null,"nblignes",{"$f":"COUNT(A4:A67)","v":50}]
["date","mois","annee","Numéro de semaine","Matricule","Nom","Prénom","Chantier","Temps","temps total pour tous le salariés","temps cumulé à la date\npar salarié"," 0-35"," 36-43"," >43","temps cumulé à la date-1\npar salarié"," 0-35"," 36-43"," >43",1,1.25,1.5,"qualif","niveau","taux horaire de base","Montant"]
["2012-05-21",{"$f":"IF(ISBLANK(A5),\"\",MONTH(A5))","v":5},{"$f":"IF(ISBLANK(A5),\"\",YEAR(A5))","v":2012},{"$f":"WEEKNUM(A5)","v":21},231,{"$f":"IF(ISBLANK($E5),\"\",VLOOKUP($E5,tabsal,2,0))","v":"nom11"},{"$f":"IF(ISBLANK($E5),\"\",VLOOKUP($E5,tabsal,3,0))","v":"prenom11"},"C120401",6,{"$f":"SUM($I$5:I5)","v":6},{"$f":"SUMIF($E$5:E5,E5,$I$5:I5)","v":6},{"$f":"MIN(K5,35)","v":6},{"$f":"MIN(K5-L5,8)","v":0},{"$f":"K5-L5-M5","v":0},0,{"$f":"MIN(O5,35)","v":0},{"$f":"MIN(O5-P5,8)","v":0},{"$f":"O5-P5-Q5","v":0},{"$f":"L5-P5","v":6},{"$f":"M5-Q5","v":0},0,{"$f":"VLOOKUP(E5,tabsal,4,0)","v":4},{"$f":"VLOOKUP(E5,tabsal,5,0)","v":2},{"$f":"VLOOKUP(VLOOKUP(application!E5,tabsal,4,0),tabqualif,VLOOKUP(application!E5,tabsal,5,0)+2,0)","v":11.68},{"$f":"CEILING((S5+T5*1.25+U5*1.5)*X5,0.01)","v":70.08}]
["2012-05-21",{"$f":"IF(ISBLANK(A6),\"\",MONTH(A6))","v":5},{"$f":"IF(ISBLANK(A6),\"\",YEAR(A6))","v":2012},{"$f":"WEEKNUM(A6)","v":21},245,"nom25","prenom25","C120401",4,{"$f":"SUM($I$5:I6)","v":10},{"$f":"SUMIF($E$5:E6,E6,$I$5:I6)","v":4},{"$f":"MIN(K6,35)","v":4},{"$f":"MIN(K6-L6,8)","v":0},0,{"$f":"SUMIF($E$5:E5,E6,$I$5:I5)","v":0},{"$f":"MIN(O6,35)","v":0},{"$f":"MIN(O6-P6,8)","v":0},{"$f":"O6-P6-Q6","v":0},{"$f":"L6-P6","v":4},{"$f":"M6-Q6","v":0},{"$f":"N6-R6","v":0},2,2,{"$f":"VLOOKUP(VLOOKUP(application!E6,tabsal,4,0),tabqualif,VLOOKUP(application!E6,tabsal,5,0)+2,0)","v":9.43},{"$f":"CEILING((S6+T6*1.25+U6*1.5)*X6,0.01)","v":37.72}]
["2012-05-21",5,2012,21,229,"nom9","prenom9","C120402",15,{"$f":"SUM($I$5:I7)","v":25},{"$f":"SUMIF($E$5:E7,E7,$I$5:I7)","v":15},15,0,0,{"$f":"SUMIF($E$5:E6,E7,$I$5:I6)","v":0},0,0,0,15,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E7,tabsal,4,0),tabqualif,VLOOKUP(application!E7,tabsal,5,0)+2,0)","v":5.55},83.25]
["2012-05-21",5,2012,21,249,"nom29","prenom29","C120403",5,null,{"$f":"SUMIF($E$5:E8,E8,$I$5:I8)","v":5},5,0,0,{"$f":"SUMIF($E$5:E7,E8,$I$5:I7)","v":0},0,0,0,5,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E8,tabsal,4,0),tabqualif,VLOOKUP(application!E8,tabsal,5,0)+2,0)","v":14.15},70.75]
["2012-05-21",5,2012,21,246,"nom26","prenom26","C120404",4,null,{"$f":"SUMIF($E$5:E9,E9,$I$5:I9)","v":4},4,0,0,{"$f":"SUMIF($E$5:E8,E9,$I$5:I8)","v":0},0,0,0,4,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E9,tabsal,4,0),tabqualif,VLOOKUP(application!E9,tabsal,5,0)+2,0)","v":9.2100000000000009},36.840000000000003]
["2012-05-21",5,2012,21,224,"nom4","prenom4","C120405",14,null,{"$f":"SUMIF($E$5:E10,E10,$I$5:I10)","v":14},14,0,0,{"$f":"SUMIF($E$5:E9,E10,$I$5:I9)","v":0},0,0,0,14,0,0,1,2,{"$f":"VLOOKUP(VLOOKUP(application!E10,tabsal,4,0),tabqualif,VLOOKUP(application!E10,tabsal,5,0)+2,0)","v":6.28},87.92]
["2012-05-21",5,2012,21,233,"nom13","prenom13","C120408",9,null,{"$f":"SUMIF($E$5:E11,E11,$I$5:I11)","v":9},9,0,0,{"$f":"SUMIF($E$5:E10,E11,$I$5:I10)","v":0},0,0,0,9,0,0,5,1,{"$f":"VLOOKUP(VLOOKUP(application!E11,tabsal,4,0),tabqualif,VLOOKUP(application!E11,tabsal,5,0)+2,0)","v":12.43},111.87]
["2012-05-21",5,2012,21,235,"nom15","prenom15","C120409",6,null,{"$f":"SUMIF($E$5:E12,E12,$I$5:I12)","v":6},6,0,0,{"$f":"SUMIF($E$5:E11,E12,$I$5:I11)","v":0},0,0,0,6,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E12,tabsal,4,0),tabqualif,VLOOKUP(application!E12,tabsal,5,0)+2,0)","v":5.55},33.299999999999997]
["2012-05-21",5,2012,21,222,"nom2","prenom2","C120410",13,null,{"$f":"SUMIF($E$5:E13,E13,$I$5:I13)","v":13},13,0,0,{"$f":"SUMIF($E$5:E12,E13,$I$5:I12)","v":0},0,0,0,13,0,0,5,1,{"$f":"VLOOKUP(VLOOKUP(application!E13,tabsal,4,0),tabqualif,VLOOKUP(application!E13,tabsal,5,0)+2,0)","v":12.43},161.59]
["2012-05-22",5,2012,21,227,"nom7","prenom7","C120401",5,null,{"$f":"SUMIF($E$5:E14,E14,$I$5:I14)","v":5},5,0,0,{"$f":"SUMIF($E$5:E13,E14,$I$5:I13)","v":0},0,0,0,5,0,0,4,1,{"$f":"VLOOKUP(VLOOKUP(application!E14,tabsal,4,0),tabqualif,VLOOKUP(application!E14,tabsal,5,0)+2,0)","v":10.93},54.65]
["2012-05-22",5,2012,21,223,"nom3","prenom3","C120401",7,null,{"$f":"SUMIF($E$5:E15,E15,$I$5:I15)","v":7},7,0,0,{"$f":"SUMIF($E$5:E14,E15,$I$5:I14)","v":0},0,0,0,7,0,0,3,1,{"$f":"VLOOKUP(VLOOKUP(application!E15,tabsal,4,0),tabqualif,VLOOKUP(application!E15,tabsal,5,0)+2,0)","v":9.99},69.930000000000007]
["2012-05-22",5,2012,21,221,"nom1","prenom1","C120402",6,null,{"$f":"SUMIF($E$5:E16,E16,$I$5:I16)","v":6},6,0,0,{"$f":"SUMIF($E$5:E15,E16,$I$5:I15)","v":0},0,0,0,6,0,0,2,2,{"$f":"VLOOKUP(VLOOKUP(application!E16,tabsal,4,0),tabqualif,VLOOKUP(application!E16,tabsal,5,0)+2,0)","v":9.43},56.58]
["2012-05-22",5,2012,21,246,"nom26","prenom26","C120402",4,null,{"$f":"SUMIF($E$5:E17,E17,$I$5:I17)","v":8},8,0,0,{"$f":"SUMIF($E$5:E16,E17,$I$5:I16)","v":4},4,0,0,4,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E17,tabsal,4,0),tabqualif,VLOOKUP(application!E17,tabsal,5,0)+2,0)","v":9.2100000000000009},36.840000000000003]
["2012-05-22",5,2012,21,238,"nom18","prenom18","C120402",5,null,{"$f":"SUMIF($E$5:E18,E18,$I$5:I18)","v":5},5,0,0,{"$f":"SUMIF($E$5:E17,E18,$I$5:I17)","v":0},0,0,0,5,0,0,1,2,{"$f":"VLOOKUP(VLOOKUP(application!E18,tabsal,4,0),tabqualif,VLOOKUP(application!E18,tabsal,5,0)+2,0)","v":6.28},31.400000000000002]
["2012-05-22",5,2012,21,222,"nom2","prenom2","C120403",9,null,{"$f":"SUMIF($E$5:E19,E19,$I$5:I19)","v":22},22,0,0,{"$f":"SUMIF($E$5:E18,E19,$I$5:I18)","v":13},13,0,0,9,0,0,5,1,{"$f":"VLOOKUP(VLOOKUP(application!E19,tabsal,4,0),tabqualif,VLOOKUP(application!E19,tabsal,5,0)+2,0)","v":12.43},111.87]
["2012-05-22",5,2012,21,246,"nom26","prenom26","C120403",14,null,{"$f":"SUMIF($E$5:E20,E20,$I$5:I20)","v":22},22,0,0,{"$f":"SUMIF($E$5:E19,E20,$I$5:I19)","v":8},8,0,0,14,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E20,tabsal,4,0),tabqualif,VLOOKUP(application!E20,tabsal,5,0)+2,0)","v":9.2100000000000009},128.94]
["2012-05-22",5,2012,21,243,"nom23","prenom23","C120403",14,null,{"$f":"SUMIF($E$5:E21,E21,$I$5:I21)","v":14},14,0,0,{"$f":"SUMIF($E$5:E20,E21,$I$5:I20)","v":0},0,0,0,14,0,0,3,2,{"$f":"VLOOKUP(VLOOKUP(application!E21,tabsal,4,0),tabqualif,VLOOKUP(application!E21,tabsal,5,0)+2,0)","v":10.25},143.5]
["2012-05-22",5,2012,21,227,"nom7","prenom7","C120403",9,null,{"$f":"SUMIF($E$5:E22,E22,$I$5:I22)","v":14},14,0,0,{"$f":"SUMIF($E$5:E21,E22,$I$5:I21)","v":5},5,0,0,9,0,0,4,1,{"$f":"VLOOKUP(VLOOKUP(application!E22,tabsal,4,0),tabqualif,VLOOKUP(application!E22,tabsal,5,0)+2,0)","v":10.93},98.37]
["2012-05-22",5,2012,21,240,"nom20","prenom20","C120404",10,null,{"$f":"SUMIF($E$5:E23,E23,$I$5:I23)","v":10},10,0,0,{"$f":"SUMIF($E$5:E22,E23,$I$5:I22)","v":0},0,0,0,10,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E23,tabsal,4,0),tabqualif,VLOOKUP(application!E23,tabsal,5,0)+2,0)","v":5.55},55.5]
["2012-05-22",5,2012,21,248,"nom28","prenom28","C120404",10,null,{"$f":"SUMIF($E$5:E24,E24,$I$5:I24)","v":10},10,0,0,{"$f":"SUMIF($E$5:E23,E24,$I$5:I23)","v":0},0,0,0,10,0,0,3,2,{"$f":"VLOOKUP(VLOOKUP(application!E24,tabsal,4,0),tabqualif,VLOOKUP(application!E24,tabsal,5,0)+2,0)","v":10.25},102.5]
["2012-05-22",5,2012,21,235,"nom15","prenom15","C120405",11,null,{"$f":"SUMIF($E$5:E25,E25,$I$5:I25)","v":17},17,0,0,{"$f":"SUMIF($E$5:E24,E25,$I$5:I24)","v":6},6,0,0,11,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E25,tabsal,4,0),tabqualif,VLOOKUP(application!E25,tabsal,5,0)+2,0)","v":5.55},61.050000000000004]
["2012-05-22",5,2012,21,249,"nom29","prenom29","C120405",15,null,{"$f":"SUMIF($E$5:E26,E26,$I$5:I26)","v":20},20,0,0,{"$f":"SUMIF($E$5:E25,E26,$I$5:I25)","v":5},5,0,0,15,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E26,tabsal,4,0),tabqualif,VLOOKUP(application!E26,tabsal,5,0)+2,0)","v":14.15},212.25]
["2012-05-22",5,2012,21,223,"nom3","prenom3","C120406",14,null,{"$f":"SUMIF($E$5:E27,E27,$I$5:I27)","v":21},21,0,0,{"$f":"SUMIF($E$5:E26,E27,$I$5:I26)","v":7},7,0,0,14,0,0,3,1,{"$f":"VLOOKUP(VLOOKUP(application!E27,tabsal,4,0),tabqualif,VLOOKUP(application!E27,tabsal,5,0)+2,0)","v":9.99},139.86000000000001]
["2012-05-22",5,2012,21,226,"nom6","prenom6","C120407",8,null,{"$f":"SUMIF($E$5:E28,E28,$I$5:I28)","v":8},8,0,0,{"$f":"SUMIF($E$5:E27,E28,$I$5:I27)","v":0},0,0,0,8,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E28,tabsal,4,0),tabqualif,VLOOKUP(application!E28,tabsal,5,0)+2,0)","v":9.2100000000000009},73.680000000000007]
["2012-05-22",5,2012,21,229,"nom9","prenom9","C120407",7,null,{"$f":"SUMIF($E$5:E29,E29,$I$5:I29)","v":22},22,0,0,{"$f":"SUMIF($E$5:E28,E29,$I$5:I28)","v":15},15,0,0,7,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E29,tabsal,4,0),tabqualif,VLOOKUP(application!E29,tabsal,5,0)+2,0)","v":5.55},38.85]
["2012-05-22",5,2012,21,236,"nom16","prenom16","C120408",8,null,{"$f":"SUMIF($E$5:E30,E30,$I$5:I30)","v":8},8,0,0,{"$f":"SUMIF($E$5:E29,E30,$I$5:I29)","v":0},0,0,0,8,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E30,tabsal,4,0),tabqualif,VLOOKUP(application!E30,tabsal,5,0)+2,0)","v":9.2100000000000009},73.680000000000007]
["2012-05-22",5,2012,21,238,"nom18","prenom18","C120409",8,null,{"$f":"SUMIF($E$5:E31,E31,$I$5:I31)","v":13},13,0,0,{"$f":"SUMIF($E$5:E30,E31,$I$5:I30)","v":5},5,0,0,8,0,0,1,2,{"$f":"VLOOKUP(VLOOKUP(application!E31,tabsal,4,0),tabqualif,VLOOKUP(application!E31,tabsal,5,0)+2,0)","v":6.28},50.24]
["2012-05-23",5,2012,21,250,"nom30","prenom30","C120402",2,null,{"$f":"SUMIF($E$5:E32,E32,$I$5:I32)","v":2},2,0,0,{"$f":"SUMIF($E$5:E31,E32,$I$5:I31)","v":0},0,0,0,2,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E32,tabsal,4,0),tabqualif,VLOOKUP(application!E32,tabsal,5,0)+2,0)","v":14.15},28.3]
["2012-05-23",5,2012,21,222,"nom2","prenom2","C120402",12,null,{"$f":"SUMIF($E$5:E33,E33,$I$5:I33)","v":34},34,0,0,{"$f":"SUMIF($E$5:E32,E33,$I$5:I32)","v":22},22,0,0,12,0,0,5,1,{"$f":"VLOOKUP(VLOOKUP(application!E33,tabsal,4,0),tabqualif,VLOOKUP(application!E33,tabsal,5,0)+2,0)","v":12.43},149.16]
["2012-05-23",5,2012,21,251,"nom31","prenom31","C120403",5,null,{"$f":"SUMIF($E$5:E34,E34,$I$5:I34)","v":5},5,0,0,{"$f":"SUMIF($E$5:E33,E34,$I$5:I33)","v":0},0,0,0,5,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E34,tabsal,4,0),tabqualif,VLOOKUP(application!E34,tabsal,5,0)+2,0)","v":14.15},70.75]
["2012-05-23",5,2012,21,221,"nom1","prenom1","C120403",13,null,{"$f":"SUMIF($E$5:E35,E35,$I$5:I35)","v":19},19,0,0,{"$f":"SUMIF($E$5:E34,E35,$I$5:I34)","v":6},6,0,0,13,0,0,2,2,{"$f":"VLOOKUP(VLOOKUP(application!E35,tabsal,4,0),tabqualif,VLOOKUP(application!E35,tabsal,5,0)+2,0)","v":9.43},122.59]
["2012-05-23",5,2012,21,245,"nom25","prenom25","C120405",14,null,{"$f":"SUMIF($E$5:E36,E36,$I$5:I36)","v":18},18,0,0,{"$f":"SUMIF($E$5:E35,E36,$I$5:I35)","v":4},4,0,0,14,0,0,2,2,{"$f":"VLOOKUP(VLOOKUP(application!E36,tabsal,4,0),tabqualif,VLOOKUP(application!E36,tabsal,5,0)+2,0)","v":9.43},132.02000000000001]
["2012-05-23",5,2012,21,225,{"$f":"IF(ISBLANK($E37),\"\",VLOOKUP($E37,tabsal,2,0))","v":"nom5"},{"$f":"IF(ISBLANK($E37),\"\",VLOOKUP($E37,tabsal,3,0))","v":"prenom5"},"C120405",13,null,{"$f":"SUMIF($E$5:E37,E37,$I$5:I37)","v":13},13,0,0,{"$f":"SUMIF($E$5:E36,E37,$I$5:I36)","v":0},0,0,0,13,0,0,{"$f":"VLOOKUP(E37,tabsal,4,0)","v":2},{"$f":"VLOOKUP(E37,tabsal,5,0)","v":2},{"$f":"VLOOKUP(VLOOKUP(application!E37,tabsal,4,0),tabqualif,VLOOKUP(application!E37,tabsal,5,0)+2,0)","v":9.43},122.59]
["2012-05-23",5,2012,21,232,"nom12","prenom12","C120406",9,null,{"$f":"SUMIF($E$5:E38,E38,$I$5:I38)","v":9},9,0,0,{"$f":"SUMIF($E$5:E37,E38,$I$5:I37)","v":0},0,0,0,9,0,0,4,2,{"$f":"VLOOKUP(VLOOKUP(application!E38,tabsal,4,0),tabqualif,VLOOKUP(application!E38,tabsal,5,0)+2,0)","v":11.68},105.12]
["2012-05-23",5,2012,21,236,"nom16","prenom16","C120407",9,null,{"$f":"SUMIF($E$5:E39,E39,$I$5:I39)","v":17},17,0,0,{"$f":"SUMIF($E$5:E38,E39,$I$5:I38)","v":8},8,0,0,9,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E39,tabsal,4,0),tabqualif,VLOOKUP(application!E39,tabsal,5,0)+2,0)","v":9.2100000000000009},82.89]
["2012-05-23",5,2012,21,222,"nom2","prenom2","C120408",14,null,{"$f":"SUMIF($E$5:E40,E40,$I$5:I40)","v":48},35,{"$f":"MIN(K40-L40,8)","v":8},5,{"$f":"SUMIF($E$5:E39,E40,$I$5:I39)","v":34},34,0,0,1,8,5,5,1,{"$f":"VLOOKUP(VLOOKUP(application!E40,tabsal,4,0),tabqualif,VLOOKUP(application!E40,tabsal,5,0)+2,0)","v":12.43},229.96]
["2012-05-23",5,2012,21,243,"nom23","prenom23","C120409",12,null,{"$f":"SUMIF($E$5:E41,E41,$I$5:I41)","v":26},26,{"$f":"MIN(K41-L41,8)","v":0},0,{"$f":"SUMIF($E$5:E40,E41,$I$5:I40)","v":14},14,0,0,12,0,0,3,2,{"$f":"VLOOKUP(VLOOKUP(application!E41,tabsal,4,0),tabqualif,VLOOKUP(application!E41,tabsal,5,0)+2,0)","v":10.25},123]
["2012-05-23",5,2012,21,230,"nom10","prenom10","C120409",3,null,{"$f":"SUMIF($E$5:E42,E42,$I$5:I42)","v":3},3,0,0,{"$f":"SUMIF($E$5:E41,E42,$I$5:I41)","v":0},0,0,0,3,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E42,tabsal,4,0),tabqualif,VLOOKUP(application!E42,tabsal,5,0)+2,0)","v":14.15},42.45]
["2012-05-23",5,2012,21,241,"nom21","prenom21","C120410",7,null,{"$f":"SUMIF($E$5:E43,E43,$I$5:I43)","v":7},7,0,0,{"$f":"SUMIF($E$5:E42,E43,$I$5:I42)","v":0},0,0,0,7,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E43,tabsal,4,0),tabqualif,VLOOKUP(application!E43,tabsal,5,0)+2,0)","v":5.55},38.85]
["2012-05-23",5,2012,21,241,"nom21","prenom21","C120410",6,null,{"$f":"SUMIF($E$5:E44,E44,$I$5:I44)","v":13},13,0,0,{"$f":"SUMIF($E$5:E43,E44,$I$5:I43)","v":7},7,0,0,6,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E44,tabsal,4,0),tabqualif,VLOOKUP(application!E44,tabsal,5,0)+2,0)","v":5.55},33.299999999999997]
["2012-05-24",5,2012,21,224,"nom4","prenom4","C120401",11,null,{"$f":"SUMIF($E$5:E45,E45,$I$5:I45)","v":25},25,0,0,{"$f":"SUMIF($E$5:E44,E45,$I$5:I44)","v":14},14,0,0,11,0,0,1,2,{"$f":"VLOOKUP(VLOOKUP(application!E45,tabsal,4,0),tabqualif,VLOOKUP(application!E45,tabsal,5,0)+2,0)","v":6.28},69.08]
["2012-05-24",5,2012,21,246,"nom26","prenom26","C120401",7,null,{"$f":"SUMIF($E$5:E46,E46,$I$5:I46)","v":29},29,0,0,{"$f":"SUMIF($E$5:E45,E46,$I$5:I45)","v":22},22,0,0,7,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E46,tabsal,4,0),tabqualif,VLOOKUP(application!E46,tabsal,5,0)+2,0)","v":9.2100000000000009},64.47]
["2012-05-24",5,2012,21,227,"nom7","prenom7","C120402",2,null,{"$f":"SUMIF($E$5:E47,E47,$I$5:I47)","v":16},16,0,0,{"$f":"SUMIF($E$5:E46,E47,$I$5:I46)","v":14},14,0,0,2,0,0,4,1,{"$f":"VLOOKUP(VLOOKUP(application!E47,tabsal,4,0),tabqualif,VLOOKUP(application!E47,tabsal,5,0)+2,0)","v":10.93},21.86]
["2012-05-24",5,2012,21,245,"nom25","prenom25","C120402",7,null,{"$f":"SUMIF($E$5:E48,E48,$I$5:I48)","v":25},25,0,0,{"$f":"SUMIF($E$5:E47,E48,$I$5:I47)","v":18},18,0,0,7,0,0,2,2,{"$f":"VLOOKUP(VLOOKUP(application!E48,tabsal,4,0),tabqualif,VLOOKUP(application!E48,tabsal,5,0)+2,0)","v":9.43},66.010000000000005]
["2012-05-24",5,2012,21,232,"nom12","prenom12","C120407",11,null,{"$f":"SUMIF($E$5:E49,E49,$I$5:I49)","v":20},20,0,0,{"$f":"SUMIF($E$5:E48,E49,$I$5:I48)","v":9},9,0,0,11,0,0,4,2,{"$f":"VLOOKUP(VLOOKUP(application!E49,tabsal,4,0),tabqualif,VLOOKUP(application!E49,tabsal,5,0)+2,0)","v":11.68},128.47999999999999]
["2012-05-24",5,2012,21,250,"nom30","prenom30","C120407",12,null,{"$f":"SUMIF($E$5:E50,E50,$I$5:I50)","v":14},14,0,0,{"$f":"SUMIF($E$5:E49,E50,$I$5:I49)","v":2},2,0,0,12,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E50,tabsal,4,0),tabqualif,VLOOKUP(application!E50,tabsal,5,0)+2,0)","v":14.15},169.8]
["2012-05-24",5,2012,21,228,"nom8","prenom8","C120408",11,null,{"$f":"SUMIF($E$5:E51,E51,$I$5:I51)","v":11},11,0,0,{"$f":"SUMIF($E$5:E50,E51,$I$5:I50)","v":0},0,0,0,11,0,0,5,1,{"$f":"VLOOKUP(VLOOKUP(application!E51,tabsal,4,0),tabqualif,VLOOKUP(application!E51,tabsal,5,0)+2,0)","v":12.43},136.72999999999999]
["2012-05-24",5,2012,21,248,"nom28","prenom28","C120408",7,null,{"$f":"SUMIF($E$5:E52,E52,$I$5:I52)","v":17},17,0,0,{"$f":"SUMIF($E$5:E51,E52,$I$5:I51)","v":10},10,0,0,7,0,0,3,2,{"$f":"VLOOKUP(VLOOKUP(application!E52,tabsal,4,0),tabqualif,VLOOKUP(application!E52,tabsal,5,0)+2,0)","v":10.25},71.75]
["2012-05-24",5,2012,21,244,"nom24","prenom24","C120409",12,null,{"$f":"SUMIF($E$5:E53,E53,$I$5:I53)","v":12},12,0,0,{"$f":"SUMIF($E$5:E52,E53,$I$5:I52)","v":0},0,0,0,12,0,0,5,2,{"$f":"VLOOKUP(VLOOKUP(application!E53,tabsal,4,0),tabqualif,VLOOKUP(application!E53,tabsal,5,0)+2,0)","v":13.19},158.28]
["2012-05-24",5,2012,21,242,"nom22","prenom22","C120409",1,null,{"$f":"SUMIF($E$5:E54,E54,$I$5:I54)","v":1},1,0,0,{"$f":"SUMIF($E$5:E53,E54,$I$5:I53)","v":0},0,0,0,1,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E54,tabsal,4,0),tabqualif,VLOOKUP(application!E54,tabsal,5,0)+2,0)","v":5.55},5.55]
[null,"","",0,242,"nom22","prenom22","C120401",null,null,{"$f":"SUMIF($E$5:E55,E55,$I$5:I55)","v":1},1,0,0,{"$f":"SUMIF($E$5:E54,E55,$I$5:I54)","v":1},1,0,0,0,0,0,1,1,{"$f":"VLOOKUP(VLOOKUP(application!E55,tabsal,4,0),tabqualif,VLOOKUP(application!E55,tabsal,5,0)+2,0)","v":5.55},0]
[null,"","",0,223,"nom3","prenom3","C120402",null,null,{"$f":"SUMIF($E$5:E56,E56,$I$5:I56)","v":21},21,0,0,{"$f":"SUMIF($E$5:E55,E56,$I$5:I55)","v":21},21,0,0,0,0,0,3,1,{"$f":"VLOOKUP(VLOOKUP(application!E56,tabsal,4,0),tabqualif,VLOOKUP(application!E56,tabsal,5,0)+2,0)","v":9.99},0]
[null,"","",0,243,"nom23","prenom23","C120402",null,null,{"$f":"SUMIF($E$5:E57,E57,$I$5:I57)","v":26},26,0,{"$f":"K57-L57-M57","v":0},{"$f":"SUMIF($E$5:E56,E57,$I$5:I56)","v":26},26,0,0,0,0,0,3,2,{"$f":"VLOOKUP(VLOOKUP(application!E57,tabsal,4,0),tabqualif,VLOOKUP(application!E57,tabsal,5,0)+2,0)","v":10.25},0]
[null,"","",0,245,"nom25","prenom25","C120402",null,null,{"$f":"SUMIF($E$5:E58,E58,$I$5:I58)","v":25},25,0,{"$f":"K58-L58-M58","v":0},{"$f":"SUMIF($E$5:E57,E58,$I$5:I57)","v":25},25,0,0,0,0,0,2,2,{"$f":"VLOOKUP(VLOOKUP(application!E58,tabsal,4,0),tabqualif,VLOOKUP(application!E58,tabsal,5,0)+2,0)","v":9.43},0]
[null,"","",0,250,"nom30","prenom30","C120404",null,null,{"$f":"SUMIF($E$5:E59,E59,$I$5:I59)","v":14},14,0,0,{"$f":"SUMIF($E$5:E58,E59,$I$5:I58)","v":14},14,0,0,0,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E59,tabsal,4,0),tabqualif,VLOOKUP(application!E59,tabsal,5,0)+2,0)","v":14.15},0]
[null,"","",0,250,"nom30","prenom30","C120404",null,null,{"$f":"SUMIF($E$5:E60,E60,$I$5:I60)","v":14},14,0,0,{"$f":"SUMIF($E$5:E59,E60,$I$5:I59)","v":14},14,0,0,0,0,0,6,1,{"$f":"VLOOKUP(VLOOKUP(application!E60,tabsal,4,0),tabqualif,VLOOKUP(application!E60,tabsal,5,0)+2,0)","v":14.15},0]
[null,"","",0,247,"nom27","prenom27","C120405",null,null,{"$f":"SUMIF($E$5:E61,E61,$I$5:I61)","v":0},0,0,0,{"$f":"SUMIF($E$5:E60,E61,$I$5:I60)","v":0},0,0,0,0,0,0,3,1,{"$f":"VLOOKUP(VLOOKUP(application!E61,tabsal,4,0),tabqualif,VLOOKUP(application!E61,tabsal,5,0)+2,0)","v":9.99},0]
[null,"","",0,246,"nom26","prenom26","C120407",null,null,{"$f":"SUMIF($E$5:E62,E62,$I$5:I62)","v":29},29,0,0,{"$f":"SUMIF($E$5:E61,E62,$I$5:I61)","v":29},29,0,0,0,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E62,tabsal,4,0),tabqualif,VLOOKUP(application!E62,tabsal,5,0)+2,0)","v":9.2100000000000009},0]
[null,"","",0,228,"nom8","prenom8","C120407",null,null,{"$f":"SUMIF($E$5:E63,E63,$I$5:I63)","v":11},11,0,0,{"$f":"SUMIF($E$5:E62,E63,$I$5:I62)","v":11},11,0,0,0,0,0,5,1,{"$f":"VLOOKUP(VLOOKUP(application!E63,tabsal,4,0),tabqualif,VLOOKUP(application!E63,tabsal,5,0)+2,0)","v":12.43},0]
[null,"","",0,243,"nom23","prenom23","C120408",null,null,{"$f":"SUMIF($E$5:E64,E64,$I$5:I64)","v":26},26,0,0,{"$f":"SUMIF($E$5:E63,E64,$I$5:I63)","v":26},26,0,0,0,0,0,3,2,{"$f":"VLOOKUP(VLOOKUP(application!E64,tabsal,4,0),tabqualif,VLOOKUP(application!E64,tabsal,5,0)+2,0)","v":10.25},{"$f":"CEILING(SUMPRODUCT($S$4:$U$4,S64:U64)*X64,0.01)","v":0}]
[null,"","",0,226,"nom6","prenom6","C120408",null,null,{"$f":"SUMIF($E$5:E65,E65,$I$5:I65)","v":8},8,0,0,{"$f":"SUMIF($E$5:E64,E65,$I$5:I64)","v":8},8,0,0,0,0,0,2,1,{"$f":"VLOOKUP(VLOOKUP(application!E65,tabsal,4,0),tabqualif,VLOOKUP(application!E65,tabsal,5,0)+2,0)","v":9.2100000000000009},0]
[null,"","",0,231,"nom11","prenom11","C120409",null,null,{"$f":"SUMIF($E$5:E66,E66,$I$5:I66)","v":6},6,0,0,{"$f":"SUMIF($E$5:E65,E66,$I$5:I65)","v":6},6,0,0,0,0,0,4,2,{"$f":"VLOOKUP(VLOOKUP(application!E66,tabsal,4,0),tabqualif,VLOOKUP(application!E66,tabsal,5,0)+2,0)","v":11.68},0]
[null,"","",0,248,"nom28","prenom28","C120410",null,null,{"$f":"SUMIF($E$5:E67,E67,$I$5:I67)","v":17},17,0,0,{"$f":"SUMIF($E$5:E66,E67,$I$5:I66)","v":17},17,0,0,0,0,0,3,2,{"$f":"VLOOKUP(VLOOKUP(application!E67,tabsal,4,0),tabqualif,VLOOKUP(application!E67,tabsal,5,0)+2,0)","v":10.25},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totaux",null,null,null,null,null,null,null,{"$f":"SUM(I5:I67)","v":440},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S5:U67)","v":440},null,null,null,null,null,{"$f":"SUM(Y5:Y67)","v":4405.9999999999991}]

{"sheet":"import","index":3,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["RECAPITULATIF DES HEURES EFFECTUEES"]
[]
["Année : ",null,null,null,2012,"Semaine 21","du",41050,"au",41053,null,null,null,null,"nblignes",50]
["date","mois","annee","Numéro de semaine","Matricule","Nom","Prénom","Chantier","Temps",1,1.25,1.5,"qualif","niveau","taux horaire de base","Montant"]
[null,"","",0,242,"nom22","prenom22","C120401",null,0,0,0,1,1,5.55,0]
[null,"","",0,223,"nom3","prenom3","C120402",null,0,0,0,3,1,9.99,0]
[null,"","",0,243,"nom23","prenom23","C120402",null,0,0,0,3,2,10.25,0]
[null,"","",0,245,"nom25","prenom25","C120402",null,0,0,0,2,2,9.43,0]
[null,"","",0,250,"nom30","prenom30","C120404",null,0,0,0,6,1,14.15,0]
[null,"","",0,250,"nom30","prenom30","C120404",null,0,0,0,6,1,14.15,0]
[null,"","",0,247,"nom27","prenom27","C120405",null,0,0,0,3,1,9.99,0]
[null,"","",0,246,"nom26","prenom26","C120407",null,0,0,0,2,1,9.2100000000000009,0]
[null,"","",0,228,"nom8","prenom8","C120407",null,0,0,0,5,1,12.43,0]
[null,"","",0,243,"nom23","prenom23","C120408",null,0,0,0,3,2,10.25,0]
[null,"","",0,226,"nom6","prenom6","C120408",null,0,0,0,2,1,9.2100000000000009,0]
[null,"","",0,231,"nom11","prenom11","C120409",null,0,0,0,4,2,11.68,0]
[null,"","",0,248,"nom28","prenom28","C120410",null,0,0,0,3,2,10.25,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totaux",null,null,null,null,null,null,null,440,440,null,null,null,null,null,4405.9999999999991]

{"sheet":"archive","index":4,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["date","mois","annee","Numéro de semaine","Matricule","Nom","Prénom","Chantier","Temps","p100%","p125%","p150%","qualif","niveau","taux horaire de base","Montant"]
[41053,5,2012,21,242,"nom22","prenom22","C120409",1,1,0,0,1,1,5.55,5.55]
[41053,5,2012,21,244,"nom24","prenom24","C120409",12,12,0,0,5,2,13.19,158.28]
[41053,5,2012,21,248,"nom28","prenom28","C120408",7,7,0,0,3,2,10.25,71.75]
[41053,5,2012,21,228,"nom8","prenom8","C120408",11,11,0,0,5,1,12.43,136.72999999999999]
[41053,5,2012,21,250,"nom30","prenom30","C120407",12,12,0,0,6,1,14.15,169.8]
[41053,5,2012,21,232,"nom12","prenom12","C120407",11,11,0,0,4,2,11.68,128.47999999999999]
[41053,5,2012,21,245,"nom25","prenom25","C120402",7,7,0,0,2,2,9.43,66.010000000000005]
[41053,5,2012,21,227,"nom7","prenom7","C120402",2,2,0,0,4,1,10.93,21.86]
[41053,5,2012,21,246,"nom26","prenom26","C120401",7,7,0,0,2,1,9.2100000000000009,64.47]
[41053,5,2012,21,224,"nom4","prenom4","C120401",11,11,0,0,1,2,6.28,69.08]
[41052,5,2012,21,241,"nom21","prenom21","C120410",6,6,0,0,1,1,5.55,33.299999999999997]
[41052,5,2012,21,241,"nom21","prenom21","C120410",7,7,0,0,1,1,5.55,38.85]
[41052,5,2012,21,230,"nom10","prenom10","C120409",3,3,0,0,6,1,14.15,42.45]
[41052,5,2012,21,243,"nom23","prenom23","C120409",12,12,0,0,3,2,10.25,123]
[41052,5,2012,21,222,"nom2","prenom2","C120408",14,1,8,5,5,1,12.43,229.96]
[41052,5,2012,21,236,"nom16","prenom16","C120407",9,9,0,0,2,1,9.2100000000000009,82.89]
[41052,5,2012,21,232,"nom12","prenom12","C120406",9,9,0,0,4,2,11.68,105.12]
[41052,5,2012,21,225,"nom5","prenom5","C120405",13,13,0,0,2,2,9.43,122.59]
[41052,5,2012,21,245,"nom25","prenom25","C120405",14,14,0,0,2,2,9.43,132.02000000000001]
[41052,5,2012,21,221,"nom1","prenom1","C120403",13,13,0,0,2,2,9.43,122.59]
[41052,5,2012,21,251,"nom31","prenom31","C120403",5,5,0,0,6,1,14.15,70.75]
[41052,5,2012,21,222,"nom2","prenom2","C120402",12,12,0,0,5,1,12.43,149.16]
[41052,5,2012,21,250,"nom30","prenom30","C120402",2,2,0,0,6,1,14.15,28.3]
[41051,5,2012,21,238,"nom18","prenom18","C120409",8,8,0,0,1,2,6.28,50.24]
[41051,5,2012,21,236,"nom16","prenom16","C120408",8,8,0,0,2,1,9.2100000000000009,73.680000000000007]
[41051,5,2012,21,229,"nom9","prenom9","C120407",7,7,0,0,1,1,5.55,38.85]
[41051,5,2012,21,226,"nom6","prenom6","C120407",8,8,0,0,2,1,9.2100000000000009,73.680000000000007]
[41051,5,2012,21,223,"nom3","prenom3","C120406",14,14,0,0,3,1,9.99,139.86000000000001]
[41051,5,2012,21,249,"nom29","prenom29","C120405",15,15,0,0,6,1,14.15,212.25]
[41051,5,2012,21,235,"nom15","prenom15","C120405",11,11,0,0,1,1,5.55,61.050000000000004]
[41051,5,2012,21,248,"nom28","prenom28","C120404",10,10,0,0,3,2,10.25,102.5]
[41051,5,2012,21,240,"nom20","prenom20","C120404",10,10,0,0,1,1,5.55,55.5]
[41051,5,2012,21,227,"nom7","prenom7","C120403",9,9,0,0,4,1,10.93,98.37]
[41051,5,2012,21,243,"nom23","prenom23","C120403",14,14,0,0,3,2,10.25,143.5]
[41051,5,2012,21,246,"nom26","prenom26","C120403",14,14,0,0,2,1,9.2100000000000009,128.94]
[41051,5,2012,21,222,"nom2","prenom2","C120403",9,9,0,0,5,1,12.43,111.87]
[41051,5,2012,21,238,"nom18","prenom18","C120402",5,5,0,0,1,2,6.28,31.400000000000002]
[41051,5,2012,21,246,"nom26","prenom26","C120402",4,4,0,0,2,1,9.2100000000000009,36.840000000000003]
[41051,5,2012,21,221,"nom1","prenom1","C120402",6,6,0,0,2,2,9.43,56.58]
[41051,5,2012,21,223,"nom3","prenom3","C120401",7,7,0,0,3,1,9.99,69.930000000000007]
[41051,5,2012,21,227,"nom7","prenom7","C120401",5,5,0,0,4,1,10.93,54.65]
[41050,5,2012,21,222,"nom2","prenom2","C120410",13,13,0,0,5,1,12.43,161.59]
[41050,5,2012,21,235,"nom15","prenom15","C120409",6,6,0,0,1,1,5.55,33.299999999999997]
[41050,5,2012,21,233,"nom13","prenom13","C120408",9,9,0,0,5,1,12.43,111.87]
[41050,5,2012,21,224,"nom4","prenom4","C120405",14,14,0,0,1,2,6.28,87.92]
[41050,5,2012,21,246,"nom26","prenom26","C120404",4,4,0,0,2,1,9.2100000000000009,36.840000000000003]
[41050,5,2012,21,249,"nom29","prenom29","C120403",5,5,0,0,6,1,14.15,70.75]
[41050,5,2012,21,229,"nom9","prenom9","C120402",15,15,0,0,1,1,5.55,83.25]
[41050,5,2012,21,245,"nom25","prenom25","C120401",4,4,0,0,2,2,9.43,37.72]
[41050,5,2012,21,231,"nom11","prenom11","C120401",6,6,0,0,4,2,11.68,70.08]

{"sheet":"recapitulatif salariés","index":5,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,4,1,4],[0,5,1,5]]}
["Salarié","Heures","Heures sup","Heures","temps","coût"]
[null,null,0.25,"sup 50%"]

{"sheet":"recap salarié","index":6,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["annee",2012]
["mois",5]
[]
[null,"Étiquettes de colonnes"]
[null,21,null,null,null,null,"Total Somme de Temps","Total Somme de p100%","Total Somme de p125%","Total Somme de p150%","Total Somme de Montant"]
["Étiquettes de lignes","Somme de Temps","Somme de p100%","Somme de p125%","Somme de p150%","Somme de Montant"]
[221,19,19,0,0,179.17000000000002,19,19,0,0,179.17000000000002]
["nom1",19,19,0,0,179.17000000000002,19,19,0,0,179.17000000000002]
[222,48,35,8,5,652.58000000000004,48,35,8,5,652.58000000000004]
["nom2",48,35,8,5,652.58000000000004,48,35,8,5,652.58000000000004]
[223,21,21,0,0,209.79000000000002,21,21,0,0,209.79000000000002]
["nom3",21,21,0,0,209.79000000000002,21,21,0,0,209.79000000000002]
[224,25,25,0,0,157,25,25,0,0,157]
["nom4",25,25,0,0,157,25,25,0,0,157]
[225,13,13,0,0,122.59,13,13,0,0,122.59]
["nom5",13,13,0,0,122.59,13,13,0,0,122.59]
[226,8,8,0,0,73.680000000000007,8,8,0,0,73.680000000000007]
["nom6",8,8,0,0,73.680000000000007,8,8,0,0,73.680000000000007]
[227,16,16,0,0,174.88,16,16,0,0,174.88]
["nom7",16,16,0,0,174.88,16,16,0,0,174.88]
[228,11,11,0,0,136.72999999999999,11,11,0,0,136.72999999999999]
["nom8",11,11,0,0,136.72999999999999,11,11,0,0,136.72999999999999]
[229,22,22,0,0,122.1,22,22,0,0,122.1]
["nom9",22,22,0,0,122.1,22,22,0,0,122.1]
[230,3,3,0,0,42.45,3,3,0,0,42.45]
["nom10",3,3,0,0,42.45,3,3,0,0,42.45]
[231,6,6,0,0,70.08,6,6,0,0,70.08]
["nom11",6,6,0,0,70.08,6,6,0,0,70.08]
[232,20,20,0,0,233.6,20,20,0,0,233.6]
["nom12",20,20,0,0,233.6,20,20,0,0,233.6]
[233,9,9,0,0,111.87,9,9,0,0,111.87]
["nom13",9,9,0,0,111.87,9,9,0,0,111.87]
[235,17,17,0,0,94.35,17,17,0,0,94.35]
["nom15",17,17,0,0,94.35,17,17,0,0,94.35]
[236,17,17,0,0,156.57,17,17,0,0,156.57]
["nom16",17,17,0,0,156.57,17,17,0,0,156.57]
[238,13,13,0,0,81.64,13,13,0,0,81.64]
["nom18",13,13,0,0,81.64,13,13,0,0,81.64]
[240,10,10,0,0,55.5,10,10,0,0,55.5]
["nom20",10,10,0,0,55.5,10,10,0,0,55.5]
[241,13,13,0,0,72.150000000000006,13,13,0,0,72.150000000000006]
["nom21",13,13,0,0,72.150000000000006,13,13,0,0,72.150000000000006]
[242,1,1,0,0,5.55,1,1,0,0,5.55]
["nom22",1,1,0,0,5.55,1,1,0,0,5.55]
[243,26,26,0,0,266.5,26,26,0,0,266.5]
["nom23",26,26,0,0,266.5,26,26,0,0,266.5]
[244,12,12,0,0,158.28,12,12,0,0,158.28]
["nom24",12,12,0,0,158.28,12,12,0,0,158.28]
[245,25,25,0,0,235.75000000000003,25,25,0,0,235.75000000000003]
["nom25",25,25,0,0,235.75000000000003,25,25,0,0,235.75000000000003]
[246,29,29,0,0,267.09000000000003,29,29,0,0,267.09000000000003]
["nom26",29,29,0,0,267.09000000000003,29,29,0,0,267.09000000000003]
[248,17,17,0,0,174.25,17,17,0,0,174.25]
["nom28",17,17,0,0,174.25,17,17,0,0,174.25]
[249,20,20,0,0,283,20,20,0,0,283]
["nom29",20,20,0,0,283,20,20,0,0,283]
[250,14,14,0,0,198.10000000000002,14,14,0,0,198.10000000000002]
["nom30",14,14,0,0,198.10000000000002,14,14,0,0,198.10000000000002]
[251,5,5,0,0,70.75,5,5,0,0,70.75]
["nom31",5,5,0,0,70.75,5,5,0,0,70.75]
["Total général",440,427,8,5,4406.0000000000009,440,427,8,5,4406.0000000000009]

{"sheet":"recap chantiers","index":7,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["annee",2012]
[]
["Somme de Montant","Étiquettes de colonnes"]
["Étiquettes de lignes",5,"Total général"]
["C120401",365.93,365.93]
["C120402",473.39999999999992,473.39999999999992]
["C120403",746.7700000000001,746.7700000000001]
["C120404",194.84,194.84]
["C120405",615.82999999999993,615.82999999999993]
["C120406",244.98000000000002,244.98000000000002]
["C120407",493.7,493.7]
["C120408",623.99,623.99]
["C120409",412.82000000000005,412.82000000000005]
["C120410",233.74,233.74]
["Total général",4405.9999999999991,4405.9999999999991]