{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dépenses","Présence"],"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":"Dépenses","index":0,"n_rows":28,"n_cols":29,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,6,9,10],[9,12,11,14],[11,6,11,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Date","Qui","Montant","Commerçant",null,"Du 1er au 31 mai 2021",null,null,null,null,null,{"$f":"G10","v":"Du 1er au 31 mai 2021"},null,null,"Personne1","Personne2","Personne3","Personne4","Personne5","Personne6","Personne7","Personne8","Personne9","Personne10","Personne11","Personne12","Personne13","Personne14"]
[null,null,null,null,null,null,"Qui","Dépensé","Nb. jours x pers.","Doit financer","Doit ou reçoit",null,null,null,null,"reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit","reçoit"]
[null,"2021-05-01","Personne1",137,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(VLOOKUP(P10,$G$13:$K$26,5,FALSE)>=0,VLOOKUP(P10,$G$13:$K$26,5,FALSE),0)","v":13.017241379310349},53,{"$f":"IF(VLOOKUP(R10,$G$13:$K$26,5,FALSE)>=0,VLOOKUP(R10,$G$13:$K$26,5,FALSE),0)","v":0},{"$f":"IF(VLOOKUP(S10,$G$13:$K$26,5,FALSE)>=0,VLOOKUP(S10,$G$13:$K$26,5,FALSE),0)","v":77.137931034482762},204,0,75,0,0,28,0,0,0,0]
[null,"2021-05-03","Personne2",53,null,null,"Personne1",{"$f":"SUMIF($C$12:$C$243,G13,$D$12:$D$243)","v":200},{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G13)*Présence!$C$11:$AG$24)","v":15},{"$f":"IF(ISERROR($H$28/$I$28*I13),\"\",$H$28/$I$28*I13)","v":186.98275862068965},{"$f":"IF(ISERROR(H13-J13),\"\",H13-J13)","v":13.017241379310349},null,"Personne1","doit",{"$f":"IF(VLOOKUP(M13,$G$13:$K$26,5,FALSE)<=0,VLOOKUP(M13,$G$13:$K$26,5,FALSE),0)","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:O13),P$12*2-SUM(P$12:P12)))),\"\",MAX(0,MIN(-SUM($O13:O13),P$12*2-SUM(P$12:P12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:P13),Q$12*2-SUM(Q$12:Q12)))),\"\",MAX(0,MIN(-SUM($O13:P13),Q$12*2-SUM(Q$12:Q12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:Q13),R$12*2-SUM(R$12:R12)))),\"\",MAX(0,MIN(-SUM($O13:Q13),R$12*2-SUM(R$12:R12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:R13),S$12*2-SUM(S$12:S12)))),\"\",MAX(0,MIN(-SUM($O13:R13),S$12*2-SUM(S$12:S12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:S13),T$12*2-SUM(T$12:T12)))),\"\",MAX(0,MIN(-SUM($O13:S13),T$12*2-SUM(T$12:T12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:T13),U$12*2-SUM(U$12:U12)))),\"\",MAX(0,MIN(-SUM($O13:T13),U$12*2-SUM(U$12:U12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:U13),V$12*2-SUM(V$12:V12)))),\"\",MAX(0,MIN(-SUM($O13:U13),V$12*2-SUM(V$12:V12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:V13),W$12*2-SUM(W$12:W12)))),\"\",MAX(0,MIN(-SUM($O13:V13),W$12*2-SUM(W$12:W12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:W13),X$12*2-SUM(X$12:X12)))),\"\",MAX(0,MIN(-SUM($O13:W13),X$12*2-SUM(X$12:X12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:X13),Y$12*2-SUM(Y$12:Y12)))),\"\",MAX(0,MIN(-SUM($O13:X13),Y$12*2-SUM(Y$12:Y12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:Y13),Z$12*2-SUM(Z$12:Z12)))),\"\",MAX(0,MIN(-SUM($O13:Y13),Z$12*2-SUM(Z$12:Z12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:Z13),AA$12*2-SUM(AA$12:AA12)))),\"\",MAX(0,MIN(-SUM($O13:Z13),AA$12*2-SUM(AA$12:AA12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:AA13),AB$12*2-SUM(AB$12:AB12)))),\"\",MAX(0,MIN(-SUM($O13:AA13),AB$12*2-SUM(AB$12:AB12))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O13:AB13),AC$12*2-SUM(AC$12:AC12)))),\"\",MAX(0,MIN(-SUM($O13:AB13),AC$12*2-SUM(AC$12:AC12))))","v":0}]
[null,"2021-05-03","Personne5",204,null,null,"Personne2",{"$f":"SUMIF($C$12:$C$243,G14,$D$12:$D$243)","v":53},{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G14)*Présence!$C$11:$AG$24)","v":0},{"$f":"IF(ISERROR($H$28/$I$28*I14),\"\",$H$28/$I$28*I14)","v":0},{"$f":"IF(ISERROR(H14-J14),\"\",H14-J14)","v":53},null,"Personne2","doit",{"$f":"IF(VLOOKUP(M14,$G$13:$K$26,5,FALSE)<=0,VLOOKUP(M14,$G$13:$K$26,5,FALSE),0)","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:O14),P$12*2-SUM(P$12:P13)))),\"\",MAX(0,MIN(-SUM($O14:O14),P$12*2-SUM(P$12:P13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:P14),Q$12*2-SUM(Q$12:Q13)))),\"\",MAX(0,MIN(-SUM($O14:P14),Q$12*2-SUM(Q$12:Q13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:Q14),R$12*2-SUM(R$12:R13)))),\"\",MAX(0,MIN(-SUM($O14:Q14),R$12*2-SUM(R$12:R13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:R14),S$12*2-SUM(S$12:S13)))),\"\",MAX(0,MIN(-SUM($O14:R14),S$12*2-SUM(S$12:S13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:S14),T$12*2-SUM(T$12:T13)))),\"\",MAX(0,MIN(-SUM($O14:S14),T$12*2-SUM(T$12:T13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:T14),U$12*2-SUM(U$12:U13)))),\"\",MAX(0,MIN(-SUM($O14:T14),U$12*2-SUM(U$12:U13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:U14),V$12*2-SUM(V$12:V13)))),\"\",MAX(0,MIN(-SUM($O14:U14),V$12*2-SUM(V$12:V13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:V14),W$12*2-SUM(W$12:W13)))),\"\",MAX(0,MIN(-SUM($O14:V14),W$12*2-SUM(W$12:W13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:W14),X$12*2-SUM(X$12:X13)))),\"\",MAX(0,MIN(-SUM($O14:W14),X$12*2-SUM(X$12:X13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:X14),Y$12*2-SUM(Y$12:Y13)))),\"\",MAX(0,MIN(-SUM($O14:X14),Y$12*2-SUM(Y$12:Y13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:Y14),Z$12*2-SUM(Z$12:Z13)))),\"\",MAX(0,MIN(-SUM($O14:Y14),Z$12*2-SUM(Z$12:Z13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:Z14),AA$12*2-SUM(AA$12:AA13)))),\"\",MAX(0,MIN(-SUM($O14:Z14),AA$12*2-SUM(AA$12:AA13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:AA14),AB$12*2-SUM(AB$12:AB13)))),\"\",MAX(0,MIN(-SUM($O14:AA14),AB$12*2-SUM(AB$12:AB13))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O14:AB14),AC$12*2-SUM(AC$12:AC13)))),\"\",MAX(0,MIN(-SUM($O14:AB14),AC$12*2-SUM(AC$12:AC13))))","v":0}]
[null,"2021-05-05","Personne7",75,null,null,"Personne3",36,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G15)*Présence!$C$11:$AG$24)","v":6},74.793103448275858,-38.793103448275858,null,"Personne3","doit",{"$f":"IF(VLOOKUP(M15,$G$13:$K$26,5,FALSE)<=0,VLOOKUP(M15,$G$13:$K$26,5,FALSE),0)","v":-38.793103448275858},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:O15),P$12*2-SUM(P$12:P14)))),\"\",MAX(0,MIN(-SUM($O15:O15),P$12*2-SUM(P$12:P14))))","v":13.017241379310349},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:P15),Q$12*2-SUM(Q$12:Q14)))),\"\",MAX(0,MIN(-SUM($O15:P15),Q$12*2-SUM(Q$12:Q14))))","v":25.775862068965509},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:Q15),R$12*2-SUM(R$12:R14)))),\"\",MAX(0,MIN(-SUM($O15:Q15),R$12*2-SUM(R$12:R14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:R15),S$12*2-SUM(S$12:S14)))),\"\",MAX(0,MIN(-SUM($O15:R15),S$12*2-SUM(S$12:S14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:S15),T$12*2-SUM(T$12:T14)))),\"\",MAX(0,MIN(-SUM($O15:S15),T$12*2-SUM(T$12:T14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:T15),U$12*2-SUM(U$12:U14)))),\"\",MAX(0,MIN(-SUM($O15:T15),U$12*2-SUM(U$12:U14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:U15),V$12*2-SUM(V$12:V14)))),\"\",MAX(0,MIN(-SUM($O15:U15),V$12*2-SUM(V$12:V14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:V15),W$12*2-SUM(W$12:W14)))),\"\",MAX(0,MIN(-SUM($O15:V15),W$12*2-SUM(W$12:W14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:W15),X$12*2-SUM(X$12:X14)))),\"\",MAX(0,MIN(-SUM($O15:W15),X$12*2-SUM(X$12:X14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:X15),Y$12*2-SUM(Y$12:Y14)))),\"\",MAX(0,MIN(-SUM($O15:X15),Y$12*2-SUM(Y$12:Y14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:Y15),Z$12*2-SUM(Z$12:Z14)))),\"\",MAX(0,MIN(-SUM($O15:Y15),Z$12*2-SUM(Z$12:Z14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:Z15),AA$12*2-SUM(AA$12:AA14)))),\"\",MAX(0,MIN(-SUM($O15:Z15),AA$12*2-SUM(AA$12:AA14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:AA15),AB$12*2-SUM(AB$12:AB14)))),\"\",MAX(0,MIN(-SUM($O15:AA15),AB$12*2-SUM(AB$12:AB14))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O15:AB15),AC$12*2-SUM(AC$12:AC14)))),\"\",MAX(0,MIN(-SUM($O15:AB15),AC$12*2-SUM(AC$12:AC14))))","v":0}]
[null,"2021-05-06","Personne3",36,null,null,"Personne4",127,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G16)*Présence!$C$11:$AG$24)","v":4},49.862068965517238,77.137931034482762,null,"Personne4","doit",{"$f":"IF(VLOOKUP(M16,$G$13:$K$26,5,FALSE)<=0,VLOOKUP(M16,$G$13:$K$26,5,FALSE),0)","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:O16),P$12*2-SUM(P$12:P15)))),\"\",MAX(0,MIN(-SUM($O16:O16),P$12*2-SUM(P$12:P15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:P16),Q$12*2-SUM(Q$12:Q15)))),\"\",MAX(0,MIN(-SUM($O16:P16),Q$12*2-SUM(Q$12:Q15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:Q16),R$12*2-SUM(R$12:R15)))),\"\",MAX(0,MIN(-SUM($O16:Q16),R$12*2-SUM(R$12:R15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:R16),S$12*2-SUM(S$12:S15)))),\"\",MAX(0,MIN(-SUM($O16:R16),S$12*2-SUM(S$12:S15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:S16),T$12*2-SUM(T$12:T15)))),\"\",MAX(0,MIN(-SUM($O16:S16),T$12*2-SUM(T$12:T15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:T16),U$12*2-SUM(U$12:U15)))),\"\",MAX(0,MIN(-SUM($O16:T16),U$12*2-SUM(U$12:U15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:U16),V$12*2-SUM(V$12:V15)))),\"\",MAX(0,MIN(-SUM($O16:U16),V$12*2-SUM(V$12:V15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:V16),W$12*2-SUM(W$12:W15)))),\"\",MAX(0,MIN(-SUM($O16:V16),W$12*2-SUM(W$12:W15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:W16),X$12*2-SUM(X$12:X15)))),\"\",MAX(0,MIN(-SUM($O16:W16),X$12*2-SUM(X$12:X15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:X16),Y$12*2-SUM(Y$12:Y15)))),\"\",MAX(0,MIN(-SUM($O16:X16),Y$12*2-SUM(Y$12:Y15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:Y16),Z$12*2-SUM(Z$12:Z15)))),\"\",MAX(0,MIN(-SUM($O16:Y16),Z$12*2-SUM(Z$12:Z15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:Z16),AA$12*2-SUM(AA$12:AA15)))),\"\",MAX(0,MIN(-SUM($O16:Z16),AA$12*2-SUM(AA$12:AA15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:AA16),AB$12*2-SUM(AB$12:AB15)))),\"\",MAX(0,MIN(-SUM($O16:AA16),AB$12*2-SUM(AB$12:AB15))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O16:AB16),AC$12*2-SUM(AC$12:AC15)))),\"\",MAX(0,MIN(-SUM($O16:AB16),AC$12*2-SUM(AC$12:AC15))))","v":0}]
[null,"2021-05-10","Personne4",127,null,null,"Personne5",204,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G17)*Présence!$C$11:$AG$24)","v":0},0,204,null,"Personne5","doit",{"$f":"IF(VLOOKUP(M17,$G$13:$K$26,5,FALSE)<=0,VLOOKUP(M17,$G$13:$K$26,5,FALSE),0)","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:O17),P$12*2-SUM(P$12:P16)))),\"\",MAX(0,MIN(-SUM($O17:O17),P$12*2-SUM(P$12:P16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:P17),Q$12*2-SUM(Q$12:Q16)))),\"\",MAX(0,MIN(-SUM($O17:P17),Q$12*2-SUM(Q$12:Q16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:Q17),R$12*2-SUM(R$12:R16)))),\"\",MAX(0,MIN(-SUM($O17:Q17),R$12*2-SUM(R$12:R16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:R17),S$12*2-SUM(S$12:S16)))),\"\",MAX(0,MIN(-SUM($O17:R17),S$12*2-SUM(S$12:S16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:S17),T$12*2-SUM(T$12:T16)))),\"\",MAX(0,MIN(-SUM($O17:S17),T$12*2-SUM(T$12:T16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:T17),U$12*2-SUM(U$12:U16)))),\"\",MAX(0,MIN(-SUM($O17:T17),U$12*2-SUM(U$12:U16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:U17),V$12*2-SUM(V$12:V16)))),\"\",MAX(0,MIN(-SUM($O17:U17),V$12*2-SUM(V$12:V16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:V17),W$12*2-SUM(W$12:W16)))),\"\",MAX(0,MIN(-SUM($O17:V17),W$12*2-SUM(W$12:W16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:W17),X$12*2-SUM(X$12:X16)))),\"\",MAX(0,MIN(-SUM($O17:W17),X$12*2-SUM(X$12:X16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:X17),Y$12*2-SUM(Y$12:Y16)))),\"\",MAX(0,MIN(-SUM($O17:X17),Y$12*2-SUM(Y$12:Y16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:Y17),Z$12*2-SUM(Z$12:Z16)))),\"\",MAX(0,MIN(-SUM($O17:Y17),Z$12*2-SUM(Z$12:Z16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:Z17),AA$12*2-SUM(AA$12:AA16)))),\"\",MAX(0,MIN(-SUM($O17:Z17),AA$12*2-SUM(AA$12:AA16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:AA17),AB$12*2-SUM(AB$12:AB16)))),\"\",MAX(0,MIN(-SUM($O17:AA17),AB$12*2-SUM(AB$12:AB16))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O17:AB17),AC$12*2-SUM(AC$12:AC16)))),\"\",MAX(0,MIN(-SUM($O17:AB17),AC$12*2-SUM(AC$12:AC16))))","v":0}]
[null,"2021-05-10","Personne1",63,null,null,"Personne6",0,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G18)*Présence!$C$11:$AG$24)","v":15},186.98275862068965,-186.98275862068965,null,"Personne6","doit",{"$f":"IF(VLOOKUP(M18,$G$13:$K$26,5,FALSE)<=0,VLOOKUP(M18,$G$13:$K$26,5,FALSE),0)","v":-186.98275862068965},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:O18),P$12*2-SUM(P$12:P17)))),\"\",MAX(0,MIN(-SUM($O18:O18),P$12*2-SUM(P$12:P17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:P18),Q$12*2-SUM(Q$12:Q17)))),\"\",MAX(0,MIN(-SUM($O18:P18),Q$12*2-SUM(Q$12:Q17))))","v":27.224137931034491},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:Q18),R$12*2-SUM(R$12:R17)))),\"\",MAX(0,MIN(-SUM($O18:Q18),R$12*2-SUM(R$12:R17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:R18),S$12*2-SUM(S$12:S17)))),\"\",MAX(0,MIN(-SUM($O18:R18),S$12*2-SUM(S$12:S17))))","v":77.137931034482762},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:S18),T$12*2-SUM(T$12:T17)))),\"\",MAX(0,MIN(-SUM($O18:S18),T$12*2-SUM(T$12:T17))))","v":82.620689655172413},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:T18),U$12*2-SUM(U$12:U17)))),\"\",MAX(0,MIN(-SUM($O18:T18),U$12*2-SUM(U$12:U17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:U18),V$12*2-SUM(V$12:V17)))),\"\",MAX(0,MIN(-SUM($O18:U18),V$12*2-SUM(V$12:V17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:V18),W$12*2-SUM(W$12:W17)))),\"\",MAX(0,MIN(-SUM($O18:V18),W$12*2-SUM(W$12:W17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:W18),X$12*2-SUM(X$12:X17)))),\"\",MAX(0,MIN(-SUM($O18:W18),X$12*2-SUM(X$12:X17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:X18),Y$12*2-SUM(Y$12:Y17)))),\"\",MAX(0,MIN(-SUM($O18:X18),Y$12*2-SUM(Y$12:Y17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:Y18),Z$12*2-SUM(Z$12:Z17)))),\"\",MAX(0,MIN(-SUM($O18:Y18),Z$12*2-SUM(Z$12:Z17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:Z18),AA$12*2-SUM(AA$12:AA17)))),\"\",MAX(0,MIN(-SUM($O18:Z18),AA$12*2-SUM(AA$12:AA17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:AA18),AB$12*2-SUM(AB$12:AB17)))),\"\",MAX(0,MIN(-SUM($O18:AA18),AB$12*2-SUM(AB$12:AB17))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O18:AB18),AC$12*2-SUM(AC$12:AC17)))),\"\",MAX(0,MIN(-SUM($O18:AB18),AC$12*2-SUM(AC$12:AC17))))","v":0}]
[null,"2021-05-12","Personne10",28,null,null,"Personne7",75,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G19)*Présence!$C$11:$AG$24)","v":0},0,75,null,"Personne7","doit",0,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:O19),P$12*2-SUM(P$12:P18)))),\"\",MAX(0,MIN(-SUM($O19:O19),P$12*2-SUM(P$12:P18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:P19),Q$12*2-SUM(Q$12:Q18)))),\"\",MAX(0,MIN(-SUM($O19:P19),Q$12*2-SUM(Q$12:Q18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:Q19),R$12*2-SUM(R$12:R18)))),\"\",MAX(0,MIN(-SUM($O19:Q19),R$12*2-SUM(R$12:R18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:R19),S$12*2-SUM(S$12:S18)))),\"\",MAX(0,MIN(-SUM($O19:R19),S$12*2-SUM(S$12:S18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:S19),T$12*2-SUM(T$12:T18)))),\"\",MAX(0,MIN(-SUM($O19:S19),T$12*2-SUM(T$12:T18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:T19),U$12*2-SUM(U$12:U18)))),\"\",MAX(0,MIN(-SUM($O19:T19),U$12*2-SUM(U$12:U18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:U19),V$12*2-SUM(V$12:V18)))),\"\",MAX(0,MIN(-SUM($O19:U19),V$12*2-SUM(V$12:V18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:V19),W$12*2-SUM(W$12:W18)))),\"\",MAX(0,MIN(-SUM($O19:V19),W$12*2-SUM(W$12:W18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:W19),X$12*2-SUM(X$12:X18)))),\"\",MAX(0,MIN(-SUM($O19:W19),X$12*2-SUM(X$12:X18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:X19),Y$12*2-SUM(Y$12:Y18)))),\"\",MAX(0,MIN(-SUM($O19:X19),Y$12*2-SUM(Y$12:Y18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:Y19),Z$12*2-SUM(Z$12:Z18)))),\"\",MAX(0,MIN(-SUM($O19:Y19),Z$12*2-SUM(Z$12:Z18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:Z19),AA$12*2-SUM(AA$12:AA18)))),\"\",MAX(0,MIN(-SUM($O19:Z19),AA$12*2-SUM(AA$12:AA18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:AA19),AB$12*2-SUM(AB$12:AB18)))),\"\",MAX(0,MIN(-SUM($O19:AA19),AB$12*2-SUM(AB$12:AB18))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O19:AB19),AC$12*2-SUM(AC$12:AC18)))),\"\",MAX(0,MIN(-SUM($O19:AB19),AC$12*2-SUM(AC$12:AC18))))","v":0}]
[null,null,null,null,null,null,"Personne8",0,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G20)*Présence!$C$11:$AG$24)","v":18},224.37931034482756,-224.37931034482756,null,"Personne8","doit",-224.37931034482756,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:O20),P$12*2-SUM(P$12:P19)))),\"\",MAX(0,MIN(-SUM($O20:O20),P$12*2-SUM(P$12:P19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:P20),Q$12*2-SUM(Q$12:Q19)))),\"\",MAX(0,MIN(-SUM($O20:P20),Q$12*2-SUM(Q$12:Q19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:Q20),R$12*2-SUM(R$12:R19)))),\"\",MAX(0,MIN(-SUM($O20:Q20),R$12*2-SUM(R$12:R19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:R20),S$12*2-SUM(S$12:S19)))),\"\",MAX(0,MIN(-SUM($O20:R20),S$12*2-SUM(S$12:S19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:S20),T$12*2-SUM(T$12:T19)))),\"\",MAX(0,MIN(-SUM($O20:S20),T$12*2-SUM(T$12:T19))))","v":121.37931034482756},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:T20),U$12*2-SUM(U$12:U19)))),\"\",MAX(0,MIN(-SUM($O20:T20),U$12*2-SUM(U$12:U19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:U20),V$12*2-SUM(V$12:V19)))),\"\",MAX(0,MIN(-SUM($O20:U20),V$12*2-SUM(V$12:V19))))","v":75},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:V20),W$12*2-SUM(W$12:W19)))),\"\",MAX(0,MIN(-SUM($O20:V20),W$12*2-SUM(W$12:W19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:W20),X$12*2-SUM(X$12:X19)))),\"\",MAX(0,MIN(-SUM($O20:W20),X$12*2-SUM(X$12:X19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:X20),Y$12*2-SUM(Y$12:Y19)))),\"\",MAX(0,MIN(-SUM($O20:X20),Y$12*2-SUM(Y$12:Y19))))","v":28},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:Y20),Z$12*2-SUM(Z$12:Z19)))),\"\",MAX(0,MIN(-SUM($O20:Y20),Z$12*2-SUM(Z$12:Z19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:Z20),AA$12*2-SUM(AA$12:AA19)))),\"\",MAX(0,MIN(-SUM($O20:Z20),AA$12*2-SUM(AA$12:AA19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:AA20),AB$12*2-SUM(AB$12:AB19)))),\"\",MAX(0,MIN(-SUM($O20:AA20),AB$12*2-SUM(AB$12:AB19))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O20:AB20),AC$12*2-SUM(AC$12:AC19)))),\"\",MAX(0,MIN(-SUM($O20:AB20),AC$12*2-SUM(AC$12:AC19))))","v":0}]
[null,null,null,null,null,null,"Personne9",0,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G21)*Présence!$C$11:$AG$24)","v":0},0,0,null,"Personne9","doit",0,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:O21),P$12*2-SUM(P$12:P20)))),\"\",MAX(0,MIN(-SUM($O21:O21),P$12*2-SUM(P$12:P20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:P21),Q$12*2-SUM(Q$12:Q20)))),\"\",MAX(0,MIN(-SUM($O21:P21),Q$12*2-SUM(Q$12:Q20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:Q21),R$12*2-SUM(R$12:R20)))),\"\",MAX(0,MIN(-SUM($O21:Q21),R$12*2-SUM(R$12:R20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:R21),S$12*2-SUM(S$12:S20)))),\"\",MAX(0,MIN(-SUM($O21:R21),S$12*2-SUM(S$12:S20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:S21),T$12*2-SUM(T$12:T20)))),\"\",MAX(0,MIN(-SUM($O21:S21),T$12*2-SUM(T$12:T20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:T21),U$12*2-SUM(U$12:U20)))),\"\",MAX(0,MIN(-SUM($O21:T21),U$12*2-SUM(U$12:U20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:U21),V$12*2-SUM(V$12:V20)))),\"\",MAX(0,MIN(-SUM($O21:U21),V$12*2-SUM(V$12:V20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:V21),W$12*2-SUM(W$12:W20)))),\"\",MAX(0,MIN(-SUM($O21:V21),W$12*2-SUM(W$12:W20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:W21),X$12*2-SUM(X$12:X20)))),\"\",MAX(0,MIN(-SUM($O21:W21),X$12*2-SUM(X$12:X20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:X21),Y$12*2-SUM(Y$12:Y20)))),\"\",MAX(0,MIN(-SUM($O21:X21),Y$12*2-SUM(Y$12:Y20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:Y21),Z$12*2-SUM(Z$12:Z20)))),\"\",MAX(0,MIN(-SUM($O21:Y21),Z$12*2-SUM(Z$12:Z20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:Z21),AA$12*2-SUM(AA$12:AA20)))),\"\",MAX(0,MIN(-SUM($O21:Z21),AA$12*2-SUM(AA$12:AA20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:AA21),AB$12*2-SUM(AB$12:AB20)))),\"\",MAX(0,MIN(-SUM($O21:AA21),AB$12*2-SUM(AB$12:AB20))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O21:AB21),AC$12*2-SUM(AC$12:AC20)))),\"\",MAX(0,MIN(-SUM($O21:AB21),AC$12*2-SUM(AC$12:AC20))))","v":0}]
[null,null,null,null,null,null,"Personne10",28,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G22)*Présence!$C$11:$AG$24)","v":0},0,28,null,"Personne10","doit",0,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:O22),P$12*2-SUM(P$12:P21)))),\"\",MAX(0,MIN(-SUM($O22:O22),P$12*2-SUM(P$12:P21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:P22),Q$12*2-SUM(Q$12:Q21)))),\"\",MAX(0,MIN(-SUM($O22:P22),Q$12*2-SUM(Q$12:Q21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:Q22),R$12*2-SUM(R$12:R21)))),\"\",MAX(0,MIN(-SUM($O22:Q22),R$12*2-SUM(R$12:R21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:R22),S$12*2-SUM(S$12:S21)))),\"\",MAX(0,MIN(-SUM($O22:R22),S$12*2-SUM(S$12:S21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:S22),T$12*2-SUM(T$12:T21)))),\"\",MAX(0,MIN(-SUM($O22:S22),T$12*2-SUM(T$12:T21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:T22),U$12*2-SUM(U$12:U21)))),\"\",MAX(0,MIN(-SUM($O22:T22),U$12*2-SUM(U$12:U21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:U22),V$12*2-SUM(V$12:V21)))),\"\",MAX(0,MIN(-SUM($O22:U22),V$12*2-SUM(V$12:V21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:V22),W$12*2-SUM(W$12:W21)))),\"\",MAX(0,MIN(-SUM($O22:V22),W$12*2-SUM(W$12:W21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:W22),X$12*2-SUM(X$12:X21)))),\"\",MAX(0,MIN(-SUM($O22:W22),X$12*2-SUM(X$12:X21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:X22),Y$12*2-SUM(Y$12:Y21)))),\"\",MAX(0,MIN(-SUM($O22:X22),Y$12*2-SUM(Y$12:Y21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:Y22),Z$12*2-SUM(Z$12:Z21)))),\"\",MAX(0,MIN(-SUM($O22:Y22),Z$12*2-SUM(Z$12:Z21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:Z22),AA$12*2-SUM(AA$12:AA21)))),\"\",MAX(0,MIN(-SUM($O22:Z22),AA$12*2-SUM(AA$12:AA21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:AA22),AB$12*2-SUM(AB$12:AB21)))),\"\",MAX(0,MIN(-SUM($O22:AA22),AB$12*2-SUM(AB$12:AB21))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O22:AB22),AC$12*2-SUM(AC$12:AC21)))),\"\",MAX(0,MIN(-SUM($O22:AB22),AC$12*2-SUM(AC$12:AC21))))","v":0}]
[null,null,null,null,null,null,"Personne11",0,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G23)*Présence!$C$11:$AG$24)","v":0},0,0,null,"Personne11","doit",0,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:O23),P$12*2-SUM(P$12:P22)))),\"\",MAX(0,MIN(-SUM($O23:O23),P$12*2-SUM(P$12:P22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:P23),Q$12*2-SUM(Q$12:Q22)))),\"\",MAX(0,MIN(-SUM($O23:P23),Q$12*2-SUM(Q$12:Q22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:Q23),R$12*2-SUM(R$12:R22)))),\"\",MAX(0,MIN(-SUM($O23:Q23),R$12*2-SUM(R$12:R22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:R23),S$12*2-SUM(S$12:S22)))),\"\",MAX(0,MIN(-SUM($O23:R23),S$12*2-SUM(S$12:S22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:S23),T$12*2-SUM(T$12:T22)))),\"\",MAX(0,MIN(-SUM($O23:S23),T$12*2-SUM(T$12:T22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:T23),U$12*2-SUM(U$12:U22)))),\"\",MAX(0,MIN(-SUM($O23:T23),U$12*2-SUM(U$12:U22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:U23),V$12*2-SUM(V$12:V22)))),\"\",MAX(0,MIN(-SUM($O23:U23),V$12*2-SUM(V$12:V22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:V23),W$12*2-SUM(W$12:W22)))),\"\",MAX(0,MIN(-SUM($O23:V23),W$12*2-SUM(W$12:W22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:W23),X$12*2-SUM(X$12:X22)))),\"\",MAX(0,MIN(-SUM($O23:W23),X$12*2-SUM(X$12:X22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:X23),Y$12*2-SUM(Y$12:Y22)))),\"\",MAX(0,MIN(-SUM($O23:X23),Y$12*2-SUM(Y$12:Y22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:Y23),Z$12*2-SUM(Z$12:Z22)))),\"\",MAX(0,MIN(-SUM($O23:Y23),Z$12*2-SUM(Z$12:Z22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:Z23),AA$12*2-SUM(AA$12:AA22)))),\"\",MAX(0,MIN(-SUM($O23:Z23),AA$12*2-SUM(AA$12:AA22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:AA23),AB$12*2-SUM(AB$12:AB22)))),\"\",MAX(0,MIN(-SUM($O23:AA23),AB$12*2-SUM(AB$12:AB22))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O23:AB23),AC$12*2-SUM(AC$12:AC22)))),\"\",MAX(0,MIN(-SUM($O23:AB23),AC$12*2-SUM(AC$12:AC22))))","v":0}]
[null,null,null,null,null,null,"Personne12",0,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G24)*Présence!$C$11:$AG$24)","v":0},0,0,null,"Personne12","doit",0,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:O24),P$12*2-SUM(P$12:P23)))),\"\",MAX(0,MIN(-SUM($O24:O24),P$12*2-SUM(P$12:P23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:P24),Q$12*2-SUM(Q$12:Q23)))),\"\",MAX(0,MIN(-SUM($O24:P24),Q$12*2-SUM(Q$12:Q23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:Q24),R$12*2-SUM(R$12:R23)))),\"\",MAX(0,MIN(-SUM($O24:Q24),R$12*2-SUM(R$12:R23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:R24),S$12*2-SUM(S$12:S23)))),\"\",MAX(0,MIN(-SUM($O24:R24),S$12*2-SUM(S$12:S23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:S24),T$12*2-SUM(T$12:T23)))),\"\",MAX(0,MIN(-SUM($O24:S24),T$12*2-SUM(T$12:T23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:T24),U$12*2-SUM(U$12:U23)))),\"\",MAX(0,MIN(-SUM($O24:T24),U$12*2-SUM(U$12:U23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:U24),V$12*2-SUM(V$12:V23)))),\"\",MAX(0,MIN(-SUM($O24:U24),V$12*2-SUM(V$12:V23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:V24),W$12*2-SUM(W$12:W23)))),\"\",MAX(0,MIN(-SUM($O24:V24),W$12*2-SUM(W$12:W23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:W24),X$12*2-SUM(X$12:X23)))),\"\",MAX(0,MIN(-SUM($O24:W24),X$12*2-SUM(X$12:X23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:X24),Y$12*2-SUM(Y$12:Y23)))),\"\",MAX(0,MIN(-SUM($O24:X24),Y$12*2-SUM(Y$12:Y23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:Y24),Z$12*2-SUM(Z$12:Z23)))),\"\",MAX(0,MIN(-SUM($O24:Y24),Z$12*2-SUM(Z$12:Z23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:Z24),AA$12*2-SUM(AA$12:AA23)))),\"\",MAX(0,MIN(-SUM($O24:Z24),AA$12*2-SUM(AA$12:AA23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:AA24),AB$12*2-SUM(AB$12:AB23)))),\"\",MAX(0,MIN(-SUM($O24:AA24),AB$12*2-SUM(AB$12:AB23))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O24:AB24),AC$12*2-SUM(AC$12:AC23)))),\"\",MAX(0,MIN(-SUM($O24:AB24),AC$12*2-SUM(AC$12:AC23))))","v":0}]
[null,null,null,null,null,null,"Personne13",0,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G25)*Présence!$C$11:$AG$24)","v":0},0,0,null,"Personne13","doit",0,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:O25),P$12*2-SUM(P$12:P24)))),\"\",MAX(0,MIN(-SUM($O25:O25),P$12*2-SUM(P$12:P24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:P25),Q$12*2-SUM(Q$12:Q24)))),\"\",MAX(0,MIN(-SUM($O25:P25),Q$12*2-SUM(Q$12:Q24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:Q25),R$12*2-SUM(R$12:R24)))),\"\",MAX(0,MIN(-SUM($O25:Q25),R$12*2-SUM(R$12:R24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:R25),S$12*2-SUM(S$12:S24)))),\"\",MAX(0,MIN(-SUM($O25:R25),S$12*2-SUM(S$12:S24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:S25),T$12*2-SUM(T$12:T24)))),\"\",MAX(0,MIN(-SUM($O25:S25),T$12*2-SUM(T$12:T24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:T25),U$12*2-SUM(U$12:U24)))),\"\",MAX(0,MIN(-SUM($O25:T25),U$12*2-SUM(U$12:U24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:U25),V$12*2-SUM(V$12:V24)))),\"\",MAX(0,MIN(-SUM($O25:U25),V$12*2-SUM(V$12:V24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:V25),W$12*2-SUM(W$12:W24)))),\"\",MAX(0,MIN(-SUM($O25:V25),W$12*2-SUM(W$12:W24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:W25),X$12*2-SUM(X$12:X24)))),\"\",MAX(0,MIN(-SUM($O25:W25),X$12*2-SUM(X$12:X24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:X25),Y$12*2-SUM(Y$12:Y24)))),\"\",MAX(0,MIN(-SUM($O25:X25),Y$12*2-SUM(Y$12:Y24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:Y25),Z$12*2-SUM(Z$12:Z24)))),\"\",MAX(0,MIN(-SUM($O25:Y25),Z$12*2-SUM(Z$12:Z24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:Z25),AA$12*2-SUM(AA$12:AA24)))),\"\",MAX(0,MIN(-SUM($O25:Z25),AA$12*2-SUM(AA$12:AA24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:AA25),AB$12*2-SUM(AB$12:AB24)))),\"\",MAX(0,MIN(-SUM($O25:AA25),AB$12*2-SUM(AB$12:AB24))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O25:AB25),AC$12*2-SUM(AC$12:AC24)))),\"\",MAX(0,MIN(-SUM($O25:AB25),AC$12*2-SUM(AC$12:AC24))))","v":0}]
[null,null,null,null,null,null,"Personne14",0,{"$f":"SUMPRODUCT((Présence!$B$11:$B$24=G26)*Présence!$C$11:$AG$24)","v":0},0,0,null,"Personne14","doit",0,{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:O26),P$12*2-SUM(P$12:P25)))),\"\",MAX(0,MIN(-SUM($O26:O26),P$12*2-SUM(P$12:P25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:P26),Q$12*2-SUM(Q$12:Q25)))),\"\",MAX(0,MIN(-SUM($O26:P26),Q$12*2-SUM(Q$12:Q25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:Q26),R$12*2-SUM(R$12:R25)))),\"\",MAX(0,MIN(-SUM($O26:Q26),R$12*2-SUM(R$12:R25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:R26),S$12*2-SUM(S$12:S25)))),\"\",MAX(0,MIN(-SUM($O26:R26),S$12*2-SUM(S$12:S25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:S26),T$12*2-SUM(T$12:T25)))),\"\",MAX(0,MIN(-SUM($O26:S26),T$12*2-SUM(T$12:T25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:T26),U$12*2-SUM(U$12:U25)))),\"\",MAX(0,MIN(-SUM($O26:T26),U$12*2-SUM(U$12:U25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:U26),V$12*2-SUM(V$12:V25)))),\"\",MAX(0,MIN(-SUM($O26:U26),V$12*2-SUM(V$12:V25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:V26),W$12*2-SUM(W$12:W25)))),\"\",MAX(0,MIN(-SUM($O26:V26),W$12*2-SUM(W$12:W25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:W26),X$12*2-SUM(X$12:X25)))),\"\",MAX(0,MIN(-SUM($O26:W26),X$12*2-SUM(X$12:X25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:X26),Y$12*2-SUM(Y$12:Y25)))),\"\",MAX(0,MIN(-SUM($O26:X26),Y$12*2-SUM(Y$12:Y25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:Y26),Z$12*2-SUM(Z$12:Z25)))),\"\",MAX(0,MIN(-SUM($O26:Y26),Z$12*2-SUM(Z$12:Z25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:Z26),AA$12*2-SUM(AA$12:AA25)))),\"\",MAX(0,MIN(-SUM($O26:Z26),AA$12*2-SUM(AA$12:AA25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:AA26),AB$12*2-SUM(AB$12:AB25)))),\"\",MAX(0,MIN(-SUM($O26:AA26),AB$12*2-SUM(AB$12:AB25))))","v":0},{"$f":"IF(ISERROR(MAX(0,MIN(-SUM($O26:AB26),AC$12*2-SUM(AC$12:AC25)))),\"\",MAX(0,MIN(-SUM($O26:AB26),AC$12*2-SUM(AC$12:AC25))))","v":0}]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H13:H26)","v":723},{"$f":"SUM(I13:I26)","v":58},null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(ROUND(P12,2)-ROUND(SUM(P13:P26),2)=0,\"OK\",\"Écart\")),\"\",IF(ROUND(P12,2)-ROUND(SUM(P13:P26),2)=0,\"OK\",\"Écart\"))","v":"OK"},{"$f":"IF(ISERROR(IF(ROUND(Q12,2)-ROUND(SUM(Q13:Q26),2)=0,\"OK\",\"Écart\")),\"\",IF(ROUND(Q12,2)-ROUND(SUM(Q13:Q26),2)=0,\"OK\",\"Écart\"))","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]

{"sheet":"Présence","index":1,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Date de début :","2021-05-01"]
["Date de fin :","2021-05-15"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2021-05-01","2021-05-02","2021-05-03","2021-05-04","2021-05-05","2021-05-06","2021-05-07","2021-05-08","2021-05-09","2021-05-10","2021-05-11","2021-05-12","2021-05-13","2021-05-14","2021-05-15"]
[null,"Personne1",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Personne2"]
[null,"Personne3",null,1.5,1.5,1.5,1.5]
[null,"Personne4",null,1,1,1,1]
[null,"Personne5"]
[null,"Personne6",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Personne7"]
[null,"Personne8",null,null,null,null,null,null,2,2,2,2,2,2,2,2,2]
[null,"Personne9"]
[null,"Personne10"]
[null,"Personne11"]
[null,"Personne12"]
[null,"Personne13"]
[null,"Personne14"]
[null,"Total"]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUMIF(B11:B24,B15,C11:K24)","v":0}]