{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Centre","Stagiaire","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Centre","index":0,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,1,17,8],[18,1,18,4],[18,5,18,8],[19,1,19,4],[19,5,19,8],[1,1,1,8],[2,1,2,2],[6,1,6,8],[3,1,3,8],[4,1,4,2],[5,1,5,2],[4,3,4,8],[5,3,5,8],[10,1,10,8],[11,1,11,2],[11,3,11,4],[11,6,11,8],[12,1,12,2],[12,3,12,4],[12,6,12,8],[13,1,13,2],[13,3,13,4],[13,6,13,8],[2,3,2,5],[2,6,2,7],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[14,1,14,2],[14,3,14,4],[14,6,14,8],[15,1,15,2],[15,3,15,4],[15,6,15,8],[16,1,16,2],[16,3,16,4],[16,6,16,8],[31,1,31,2],[31,3,31,4],[31,6,31,8],[32,1,32,2],[32,3,32,4],[32,6,32,8],[29,1,29,2],[29,3,29,4],[29,6,29,8],[30,1,30,2],[30,3,30,4],[30,6,30,8],[27,1,27,2],[27,3,27,4],[27,6,27,8],[28,1,28,2],[28,3,28,4],[28,6,28,8],[25,1,25,2],[25,3,25,4],[25,6,25,8],[26,1,26,2],[26,3,26,4],[26,6,26,8],[24,1,24,2],[24,3,24,4],[24,6,24,8],[20,1,20,4],[20,5,20,8],[21,1,21,4],[21,5,21,8],[22,1,22,4],[22,5,22,8],[23,1,23,8],[43,1,43,2],[43,3,43,4],[43,6,43,8],[44,1,44,2],[44,3,44,4],[44,6,44,8],[41,1,41,2],[41,3,41,4],[41,6,41,8],[42,1,42,2],[42,3,42,4],[42,6,42,8],[39,1,39,2],[39,3,39,4],[39,6,39,8],[40,1,40,2],[40,3,40,4],[40,6,40,8],[37,1,37,2],[37,3,37,4],[37,6,37,8],[38,1,38,2],[38,3,38,4],[38,6,38,8],[35,1,35,2],[35,3,35,4],[35,6,35,8],[36,1,36,2],[36,3,36,4],[36,6,36,8],[33,1,33,2],[33,3,33,4],[33,6,33,8],[34,1,34,2],[34,3,34,4],[34,6,34,8],[55,1,55,2],[55,3,55,4],[55,6,55,8],[56,1,56,2],[56,3,56,4],[56,6,56,8],[53,1,53,2],[53,3,53,4],[53,6,53,8],[54,1,54,2],[54,3,54,4],[54,6,54,8],[51,1,51,2],[51,3,51,4],[51,6,51,8],[52,1,52,2],[52,3,52,4],[52,6,52,8],[49,1,49,2],[49,3,49,4],[49,6,49,8],[50,1,50,2],[50,3,50,4],[50,6,50,8],[47,1,47,2],[47,3,47,4],[47,6,47,8],[48,1,48,2],[48,3,48,4],[48,6,48,8],[45,1,45,2],[45,3,45,4],[45,6,45,8],[46,1,46,2],[46,3,46,4],[46,6,46,8],[67,1,67,2],[67,3,67,4],[67,6,67,8],[68,1,68,2],[68,3,68,4],[68,6,68,8],[65,1,65,2],[65,3,65,4],[65,6,65,8],[66,1,66,2],[66,3,66,4],[66,6,66,8],[63,1,63,2],[63,3,63,4],[63,6,63,8],[64,1,64,2],[64,3,64,4],[64,6,64,8],[61,1,61,2],[61,3,61,4],[61,6,61,8],[62,1,62,2],[62,3,62,4],[62,6,62,8],[59,1,59,2],[59,3,59,4],[59,6,59,8],[60,1,60,2],[60,3,60,4],[60,6,60,8],[57,1,57,2],[57,3,57,4],[57,6,57,8],[58,1,58,2],[58,3,58,4],[58,6,58,8],[79,1,79,2],[79,3,79,4],[79,6,79,8],[80,1,80,2],[80,3,80,4],[80,6,80,8],[77,1,77,2],[77,3,77,4],[77,6,77,8],[78,1,78,2],[78,3,78,4],[78,6,78,8],[75,1,75,2],[75,3,75,4],[75,6,75,8],[76,1,76,2],[76,3,76,4],[76,6,76,8],[73,1,73,2],[73,3,73,4],[73,6,73,8],[74,1,74,2],[74,3,74,4],[74,6,74,8],[71,1,71,2],[71,3,71,4],[71,6,71,8],[72,1,72,2],[72,3,72,4],[72,6,72,8],[69,1,69,2],[69,3,69,4],[69,6,69,8],[70,1,70,2],[70,3,70,4],[70,6,70,8],[91,1,91,2],[91,3,91,4],[91,6,91,8],[92,1,92,2],[92,3,92,4],[92,6,92,8],[89,1,89,2],[89,3,89,4],[89,6,89,8],[90,1,90,2],[90,3,90,4],[90,6,90,8],[87,1,87,2],[87,3,87,4],[87,6,87,8],[88,1,88,2],[88,3,88,4],[88,6,88,8],[85,1,85,2],[85,3,85,4],[85,6,85,8],[86,1,86,2],[86,3,86,4],[86,6,86,8],[83,1,83,2],[83,3,83,4],[83,6,83,8],[84,1,84,2],[84,3,84,4],[84,6,84,8],[81,1,81,2],[81,3,81,4],[81,6,81,8],[82,1,82,2],[82,3,82,4],[82,6,82,8],[103,1,103,2],[103,3,103,4],[103,6,103,8],[104,1,104,2],[104,3,104,4],[104,6,104,8],[101,1,101,2],[101,3,101,4],[101,6,101,8],[102,1,102,2],[102,3,102,4],[102,6,102,8],[99,1,99,2],[99,3,99,4],[99,6,99,8],[100,1,100,2],[100,3,100,4],[100,6,100,8],[97,1,97,2],[97,3,97,4],[97,6,97,8],[98,1,98,2],[98,3,98,4],[98,6,98,8],[95,1,95,2],[95,3,95,4],[95,6,95,8],[96,1,96,2],[96,3,96,4],[96,6,96,8],[93,1,93,2],[93,3,93,4],[93,6,93,8],[94,1,94,2],[94,3,94,4],[94,6,94,8],[115,1,115,2],[115,3,115,4],[115,6,115,8],[116,1,116,2],[116,3,116,4],[116,6,116,8],[113,1,113,2],[113,3,113,4],[113,6,113,8],[114,1,114,2],[114,3,114,4],[114,6,114,8],[111,1,111,2],[111,3,111,4],[111,6,111,8],[112,1,112,2],[112,3,112,4],[112,6,112,8],[109,1,109,2],[109,3,109,4],[109,6,109,8],[110,1,110,2],[110,3,110,4],[110,6,110,8],[107,1,107,2],[107,3,107,4],[107,6,107,8],[108,1,108,2],[108,3,108,4],[108,6,108,8],[105,1,105,2],[105,3,105,4],[105,6,105,8],[106,1,106,2],[106,3,106,4],[106,6,106,8],[127,1,127,2],[127,3,127,4],[127,6,127,8],[128,1,128,2],[128,3,128,4],[128,6,128,8],[125,1,125,2],[125,3,125,4],[125,6,125,8],[126,1,126,2],[126,3,126,4],[126,6,126,8],[123,1,123,2],[123,3,123,4],[123,6,123,8],[124,1,124,2],[124,3,124,4],[124,6,124,8],[121,1,121,2],[121,3,121,4],[121,6,121,8],[122,1,122,2],[122,3,122,4],[122,6,122,8],[119,1,119,2],[119,3,119,4],[119,6,119,8],[120,1,120,2],[120,3,120,4],[120,6,120,8],[117,1,117,2],[117,3,117,4],[117,6,117,8],[118,1,118,2],[118,3,118,4],[118,6,118,8],[139,1,139,2],[139,3,139,4],[139,6,139,8],[140,1,140,2],[140,3,140,4],[140,6,140,8],[137,1,137,2],[137,3,137,4],[137,6,137,8],[138,1,138,2],[138,3,138,4],[138,6,138,8],[135,1,135,2],[135,3,135,4],[135,6,135,8],[136,1,136,2],[136,3,136,4],[136,6,136,8],[133,1,133,2],[133,3,133,4],[133,6,133,8],[134,1,134,2],[134,3,134,4],[134,6,134,8],[131,1,131,2],[131,3,131,4],[131,6,131,8],[132,1,132,2],[132,3,132,4],[132,6,132,8],[129,1,129,2],[129,3,129,4],[129,6,129,8],[130,1,130,2],[130,3,130,4],[130,6,130,8],[151,1,151,2],[151,3,151,4],[151,6,151,8],[152,1,152,2],[152,3,152,4],[152,6,152,8],[149,1,149,2],[149,3,149,4],[149,6,149,8],[150,1,150,2],[150,3,150,4],[150,6,150,8],[147,1,147,2],[147,3,147,4],[147,6,147,8],[148,1,148,2],[148,3,148,4],[148,6,148,8],[145,1,145,2],[145,3,145,4],[145,6,145,8],[146,1,146,2],[146,3,146,4],[146,6,146,8],[143,1,143,2],[143,3,143,4],[143,6,143,8],[144,1,144,2],[144,3,144,4],[144,6,144,8],[141,1,141,2],[141,3,141,4],[141,6,141,8],[142,1,142,2],[142,3,142,4],[142,6,142,8],[163,1,163,2],[163,3,163,4],[163,6,163,8],[164,1,164,2],[164,3,164,4],[164,6,164,8],[161,1,161,2],[161,3,161,4],[161,6,161,8],[162,1,162,2],[162,3,162,4],[162,6,162,8],[159,1,159,2],[159,3,159,4],[159,6,159,8],[160,1,160,2],[160,3,160,4],[160,6,160,8],[157,1,157,2],[157,3,157,4],[157,6,157,8],[158,1,158,2],[158,3,158,4],[158,6,158,8],[155,1,155,2],[155,3,155,4],[155,6,155,8],[156,1,156,2],[156,3,156,4],[156,6,156,8],[153,1,153,2],[153,3,153,4],[153,6,153,8],[154,1,154,2],[154,3,154,4],[154,6,154,8],[175,1,175,2],[175,3,175,4],[175,6,175,8],[176,1,176,2],[176,3,176,4],[176,6,176,8],[173,1,173,2],[173,3,173,4],[173,6,173,8],[174,1,174,2],[174,3,174,4],[174,6,174,8],[171,1,171,2],[171,3,171,4],[171,6,171,8],[172,1,172,2],[172,3,172,4],[172,6,172,8],[169,1,169,2],[169,3,169,4],[169,6,169,8],[170,1,170,2],[170,3,170,4],[170,6,170,8],[167,1,167,2],[167,3,167,4],[167,6,167,8],[168,1,168,2],[168,3,168,4],[168,6,168,8],[165,1,165,2],[165,3,165,4],[165,6,165,8],[166,1,166,2],[166,3,166,4],[166,6,166,8],[187,1,187,2],[187,3,187,4],[187,6,187,8],[188,1,188,2],[188,3,188,4],[188,6,188,8],[185,1,185,2],[185,3,185,4],[185,6,185,8],[186,1,186,2],[186,3,186,4],[186,6,186,8],[183,1,183,2],[183,3,183,4],[183,6,183,8],[184,1,184,2],[184,3,184,4],[184,6,184,8],[181,1,181,2],[181,3,181,4],[181,6,181,8],[182,1,182,2],[182,3,182,4],[182,6,182,8],[179,1,179,2],[179,3,179,4],[179,6,179,8],[180,1,180,2],[180,3,180,4],[180,6,180,8],[177,1,177,2],[177,3,177,4],[177,6,177,8],[178,1,178,2],[178,3,178,4],[178,6,178,8],[199,1,199,2],[199,3,199,4],[199,6,199,8],[200,1,200,2],[200,3,200,4],[200,6,200,8],[197,1,197,2],[197,3,197,4],[197,6,197,8],[198,1,198,2],[198,3,198,4],[198,6,198,8],[195,1,195,2],[195,3,195,4],[195,6,195,8],[196,1,196,2],[196,3,196,4],[196,6,196,8],[193,1,193,2],[193,3,193,4],[193,6,193,8],[194,1,194,2],[194,3,194,4],[194,6,194,8],[191,1,191,2],[191,3,191,4],[191,6,191,8],[192,1,192,2],[192,3,192,4],[192,6,192,8],[189,1,189,2],[189,3,189,4],[189,6,189,8],[190,1,190,2],[190,3,190,4],[190,6,190,8],[211,1,211,2],[211,3,211,4],[211,6,211,8],[212,1,212,2],[212,3,212,4],[212,6,212,8],[209,1,209,2],[209,3,209,4],[209,6,209,8],[210,1,210,2],[210,3,210,4],[210,6,210,8],[207,1,207,2],[207,3,207,4],[207,6,207,8],[208,1,208,2],[208,3,208,4],[208,6,208,8],[205,1,205,2],[205,3,205,4],[205,6,205,8],[206,1,206,2],[206,3,206,4],[206,6,206,8],[203,1,203,2],[203,3,203,4],[203,6,203,8],[204,1,204,2],[204,3,204,4],[204,6,204,8],[201,1,201,2],[201,3,201,4],[201,6,201,8],[202,1,202,2],[202,3,202,4],[202,6,202,8],[223,1,223,2],[223,3,223,4],[223,6,223,8],[224,1,224,2],[224,3,224,4],[224,6,224,8],[221,1,221,2],[221,3,221,4],[221,6,221,8],[222,1,222,2],[222,3,222,4],[222,6,222,8],[219,1,219,2],[219,3,219,4],[219,6,219,8],[220,1,220,2],[220,3,220,4],[220,6,220,8],[217,1,217,2],[217,3,217,4],[217,6,217,8],[218,1,218,2],[218,3,218,4],[218,6,218,8],[215,1,215,2],[215,3,215,4],[215,6,215,8],[216,1,216,2],[216,3,216,4],[216,6,216,8],[213,1,213,2],[213,3,213,4],[213,6,213,8],[214,1,214,2],[214,3,214,4],[214,6,214,8],[235,1,235,2],[235,3,235,4],[235,6,235,8],[236,1,236,2],[236,3,236,4],[236,6,236,8],[233,1,233,2],[233,3,233,4],[233,6,233,8],[234,1,234,2],[234,3,234,4],[234,6,234,8],[231,1,231,2],[231,3,231,4],[231,6,231,8],[232,1,232,2],[232,3,232,4],[232,6,232,8],[229,1,229,2],[229,3,229,4],[229,6,229,8],[230,1,230,2],[230,3,230,4],[230,6,230,8],[227,1,227,2],[227,3,227,4],[227,6,227,8],[228,1,228,2],[228,3,228,4],[228,6,228,8],[225,1,225,2],[225,3,225,4],[225,6,225,8],[226,1,226,2],[226,3,226,4],[226,6,226,8],[247,1,247,2],[247,3,247,4],[247,6,247,8],[248,1,248,2],[248,3,248,4],[248,6,248,8],[245,1,245,2],[245,3,245,4],[245,6,245,8],[246,1,246,2],[246,3,246,4],[246,6,246,8],[243,1,243,2],[243,3,243,4],[243,6,243,8],[244,1,244,2],[244,3,244,4],[244,6,244,8],[241,1,241,2],[241,3,241,4],[241,6,241,8],[242,1,242,2],[242,3,242,4],[242,6,242,8],[239,1,239,2],[239,3,239,4],[239,6,239,8],[240,1,240,2],[240,3,240,4],[240,6,240,8],[237,1,237,2],[237,3,237,4],[237,6,237,8],[238,1,238,2],[238,3,238,4],[238,6,238,8],[259,1,259,2],[259,3,259,4],[259,6,259,8],[260,1,260,2],[260,3,260,4],[260,6,260,8],[257,1,257,2],[257,3,257,4],[257,6,257,8],[258,1,258,2],[258,3,258,4],[258,6,258,8],[255,1,255,2],[255,3,255,4],[255,6,255,8],[256,1,256,2],[256,3,256,4],[256,6,256,8],[253,1,253,2],[253,3,253,4],[253,6,253,8],[254,1,254,2],[254,3,254,4],[254,6,254,8],[251,1,251,2],[251,3,251,4],[251,6,251,8],[252,1,252,2],[252,3,252,4],[252,6,252,8],[249,1,249,2],[249,3,249,4],[249,6,249,8],[250,1,250,2],[250,3,250,4],[250,6,250,8],[271,1,271,2],[271,3,271,4],[271,6,271,8],[272,1,272,2],[272,3,272,4],[272,6,272,8],[269,1,269,2],[269,3,269,4],[269,6,269,8],[270,1,270,2],[270,3,270,4],[270,6,270,8],[267,1,267,2],[267,3,267,4],[267,6,267,8],[268,1,268,2],[268,3,268,4],[268,6,268,8],[265,1,265,2],[265,3,265,4],[265,6,265,8],[266,1,266,2],[266,3,266,4],[266,6,266,8],[263,1,263,2],[263,3,263,4],[263,6,263,8],[264,1,264,2],[264,3,264,4],[264,6,264,8],[261,1,261,2],[261,3,261,4],[261,6,261,8],[262,1,262,2],[262,3,262,4],[262,6,262,8],[283,1,283,2],[283,3,283,4],[283,6,283,8],[284,1,284,2],[284,3,284,4],[284,6,284,8],[281,1,281,2],[281,3,281,4],[281,6,281,8],[282,1,282,2],[282,3,282,4],[282,6,282,8],[279,1,279,2],[279,3,279,4],[279,6,279,8],[280,1,280,2],[280,3,280,4],[280,6,280,8],[277,1,277,2],[277,3,277,4],[277,6,277,8],[278,1,278,2],[278,3,278,4],[278,6,278,8],[275,1,275,2],[275,3,275,4],[275,6,275,8],[276,1,276,2],[276,3,276,4],[276,6,276,8],[273,1,273,2],[273,3,273,4],[273,6,273,8],[274,1,274,2],[274,3,274,4],[274,6,274,8],[295,1,295,2],[295,3,295,4],[295,6,295,8],[296,1,296,2],[296,3,296,4],[296,6,296,8],[293,1,293,2],[293,3,293,4],[293,6,293,8],[294,1,294,2],[294,3,294,4],[294,6,294,8],[291,1,291,2],[291,3,291,4],[291,6,291,8],[292,1,292,2],[292,3,292,4],[292,6,292,8],[289,1,289,2],[289,3,289,4],[289,6,289,8],[290,1,290,2],[290,3,290,4],[290,6,290,8],[287,1,287,2],[287,3,287,4],[287,6,287,8],[288,1,288,2],[288,3,288,4],[288,6,288,8],[285,1,285,2],[285,3,285,4],[285,6,285,8],[286,1,286,2],[286,3,286,4],[286,6,286,8],[307,1,307,2],[307,3,307,4],[307,6,307,8],[308,1,308,2],[308,3,308,4],[308,6,308,8],[305,1,305,2],[305,3,305,4],[305,6,305,8],[306,1,306,2],[306,3,306,4],[306,6,306,8],[303,1,303,2],[303,3,303,4],[303,6,303,8],[304,1,304,2],[304,3,304,4],[304,6,304,8],[301,1,301,2],[301,3,301,4],[301,6,301,8],[302,1,302,2],[302,3,302,4],[302,6,302,8],[299,1,299,2],[299,3,299,4],[299,6,299,8],[300,1,300,2],[300,3,300,4],[300,6,300,8],[297,1,297,2],[297,3,297,4],[297,6,297,8],[298,1,298,2],[298,3,298,4],[298,6,298,8],[319,1,319,2],[319,3,319,4],[319,6,319,8],[320,1,320,2],[320,3,320,4],[320,6,320,8],[317,1,317,2],[317,3,317,4],[317,6,317,8],[318,1,318,2],[318,3,318,4],[318,6,318,8],[315,1,315,2],[315,3,315,4],[315,6,315,8],[316,1,316,2],[316,3,316,4],[316,6,316,8],[313,1,313,2],[313,3,313,4],[313,6,313,8],[314,1,314,2],[314,3,314,4],[314,6,314,8],[311,1,311,2],[311,3,311,4],[311,6,311,8],[312,1,312,2],[312,3,312,4],[312,6,312,8],[309,1,309,2],[309,3,309,4],[309,6,309,8],[310,1,310,2],[310,3,310,4],[310,6,310,8],[331,1,331,2],[331,3,331,4],[331,6,331,8],[332,1,332,2],[332,3,332,4],[332,6,332,8],[329,1,329,2],[329,3,329,4],[329,6,329,8],[330,1,330,2],[330,3,330,4],[330,6,330,8],[327,1,327,2],[327,3,327,4],[327,6,327,8],[328,1,328,2],[328,3,328,4],[328,6,328,8],[325,1,325,2],[325,3,325,4],[325,6,325,8],[326,1,326,2],[326,3,326,4],[326,6,326,8],[323,1,323,2],[323,3,323,4],[323,6,323,8],[324,1,324,2],[324,3,324,4],[324,6,324,8],[321,1,321,2],[321,3,321,4],[321,6,321,8],[322,1,322,2],[322,3,322,4],[322,6,322,8],[343,1,343,2],[343,3,343,4],[343,6,343,8],[344,1,344,2],[344,3,344,4],[344,6,344,8],[341,1,341,2],[341,3,341,4],[341,6,341,8],[342,1,342,2],[342,3,342,4],[342,6,342,8],[339,1,339,2],[339,3,339,4],[339,6,339,8],[340,1,340,2],[340,3,340,4],[340,6,340,8],[337,1,337,2],[337,3,337,4],[337,6,337,8],[338,1,338,2],[338,3,338,4],[338,6,338,8],[335,1,335,2],[335,3,335,4],[335,6,335,8],[336,1,336,2]],"merged_total":22740,"flags":["merged_cut"]}
[]
[null,"Identité du centre"]
[null,"Nom du centre :",null,{"$f":"IF(ISERROR(VLOOKUP(I3,Data!P3:Q15,2,FALSE)),\"\",VLOOKUP(I3,Data!P3:Q15,2,FALSE))","v":""},null,null,"Numéro d'agrément :"]
[null,"Informations générales"]
[null,"Trimestre du rapport :"]
[null,"Année du rapport :"]
[null,"Horaires du centre"]
[null,"Début de période :",null,null,null,"Fin de période :"]
[null,null,"Lundi","Mardi","Mercredi","Jeudi","Vendredi","Samedi","Dimanche"]
[null,"Heures :"]
[null,"Jours de fermeture"]
[null,"Date de début",null,"Date de fin",null,"Type","Description"]
[]
[]
[]
[]
[]
[null,"Stagiaires"]
[]
[]
[]
[]
[]
[null,"END_FORM"]

{"sheet":"Stagiaire","index":1,"n_rows":114,"n_cols":13,"rows_kept":114,"cut":false,"hidden":true,"merged":[[6,8,6,9],[6,10,6,11],[6,1,6,4],[7,10,7,11],[7,1,7,4],[7,8,7,9],[1,1,1,12],[2,1,2,2],[2,3,2,6],[2,7,2,8],[3,1,3,2],[4,9,4,12],[5,1,5,12],[4,1,4,2],[4,7,4,8],[4,3,4,6],[2,10,2,11],[3,3,3,12],[66,1,68,1],[69,1,71,1],[72,1,74,1],[75,1,77,1],[78,1,80,1],[81,1,83,1],[39,5,41,5],[39,9,41,9],[42,5,44,5],[42,9,44,9],[45,5,47,5],[63,5,65,5],[51,5,53,5],[51,9,53,9],[54,5,56,5],[54,9,56,9],[57,5,59,5],[57,9,59,9],[60,5,62,5],[60,9,62,9],[63,9,65,9],[57,1,59,1],[60,1,62,1],[63,1,65,1],[15,1,15,7],[15,8,15,9],[15,10,15,12],[17,9,17,12],[18,1,20,1],[16,1,16,12],[17,1,17,4],[17,5,17,8],[8,1,8,12],[18,5,20,5],[18,9,20,9],[11,1,11,3],[12,1,12,3],[11,11,11,12],[12,11,12,12],[9,1,9,3],[10,1,10,3],[13,1,13,3],[13,11,13,12],[14,1,14,3],[14,11,14,12],[9,11,9,12],[10,11,10,12],[84,1,86,1],[87,1,89,1],[90,1,92,1],[93,1,95,1],[96,1,98,1],[99,1,101,1],[45,9,47,9],[48,5,50,5],[21,5,23,5],[21,9,23,9],[24,5,26,5],[24,9,26,9],[27,5,29,5],[27,9,29,9],[30,5,32,5],[30,9,32,9],[33,5,35,5],[33,9,35,9],[48,9,50,9],[36,5,38,5],[36,9,38,9],[21,1,23,1],[24,1,26,1],[27,1,29,1],[93,5,95,5],[93,9,95,9],[96,5,98,5],[96,9,98,9],[111,1,111,11],[112,1,112,11],[113,1,113,11],[99,5,101,5],[99,9,101,9],[102,5,104,5],[102,9,104,9],[105,5,107,5],[105,9,107,9],[108,5,110,5],[108,9,110,9],[102,1,104,1],[105,1,107,1],[108,1,110,1],[84,5,86,5],[84,9,86,9],[87,5,89,5],[87,9,89,9],[90,5,92,5],[90,9,92,9],[66,5,68,5],[66,9,68,9],[69,5,71,5],[69,9,71,9],[72,5,74,5],[72,9,74,9],[75,5,77,5],[75,9,77,9],[78,5,80,5],[78,9,80,9],[81,5,83,5],[81,9,83,9],[30,1,32,1],[33,1,35,1],[36,1,38,1],[39,1,41,1],[42,1,44,1],[45,1,47,1],[48,1,50,1],[51,1,53,1],[54,1,56,1]]}
[]
[null,"Identité"]
[null,"Nom et prénom :",null,null,null,null,null,"Date de naissance :",null,null,"Horaire partiel :"]
[null,"Adresse :"]
[null,"Code postal :",null,null,null,null,null,"Localité :"]
[null,"Contrats"]
[null,"Type",null,null,null,"Forfait","Début","Fin","Heures valorisées",null,"Heures payées",null,"Montant"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F8*K8*24","v":0}]
[null,"Notes de frais"]
[null,"Catégorie",null,null,"Prix","Jours prestés","Jours ouvrables","Jours couverts","Jours du mois","Km aller-retour","Montant remboursement","Pièce justificative"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B11=Data!$F$3,E11-0.5*G11,0)+IF(B11=Data!$F$4,E11/I11*H11-0.5*G11,0)+IF(OR(B11=Data!$F$5,B11=Data!$F$6),(E11-0.5)*F11,0)+IF(B11=Data!$F$7,MIN(J11*Data!$N$8-0.5,Data!$K$10)*F11,0)+IF(B11=Data!$F$8,(E11/G11-0.5)*F11,0)+IF(B11=Data!$F$9,MIN(2*J11*Data!$N$8-0.5,Data!$K$10)*F11,0)+IF(B11=Data!$F$10,(J11*Data!$N$9-0.5)*F11,0)+IF(OR(B11=Data!$F$11,B11=Data!$F$14),E11,0)+IF(B11=Data!$F$12,MIN(E11/G11-0.5,Data!$K$10)*F11,0)+IF(B11=Data!$F$13,MIN(E11-0.5,Data!$K$10)*F11,0)+IF(B11=Data!$F$15,Data!$K$8*F11,0)+IF(B11=Data!$F$16,Data!$K$9*F11,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=Data!$F$3,E12-0.5*G12,0)+IF(B12=Data!$F$4,E12/I12*H12-0.5*G12,0)+IF(OR(B12=Data!$F$5,B12=Data!$F$6),(E12-0.5)*F12,0)+IF(B12=Data!$F$7,MIN(J12*Data!$N$8-0.5,Data!$K$10)*F12,0)+IF(B12=Data!$F$8,(E12/G12-0.5)*F12,0)+IF(B12=Data!$F$9,MIN(2*J12*Data!$N$8-0.5,Data!$K$10)*F12,0)+IF(B12=Data!$F$10,(J12*Data!$N$9-0.5)*F12,0)+IF(OR(B12=Data!$F$11,B12=Data!$F$14),E12,0)+IF(B12=Data!$F$12,MIN(E12/G12-0.5,Data!$K$10)*F12,0)+IF(B12=Data!$F$13,MIN(E12-0.5,Data!$K$10)*F12,0)+IF(B12=Data!$F$15,Data!$K$8*F12,0)+IF(B12=Data!$F$16,Data!$K$9*F12,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B13=Data!$F$3,E13-0.5*G13,0)+IF(B13=Data!$F$4,E13/I13*H13-0.5*G13,0)+IF(OR(B13=Data!$F$5,B13=Data!$F$6),(E13-0.5)*F13,0)+IF(B13=Data!$F$7,MIN(J13*Data!$N$8-0.5,Data!$K$10)*F13,0)+IF(B13=Data!$F$8,(E13/G13-0.5)*F13,0)+IF(B13=Data!$F$9,MIN(2*J13*Data!$N$8-0.5,Data!$K$10)*F13,0)+IF(B13=Data!$F$10,(J13*Data!$N$9-0.5)*F13,0)+IF(OR(B13=Data!$F$11,B13=Data!$F$14),E13,0)+IF(B13=Data!$F$12,MIN(E13/G13-0.5,Data!$K$10)*F13,0)+IF(B13=Data!$F$13,MIN(E13-0.5,Data!$K$10)*F13,0)+IF(B13=Data!$F$15,Data!$K$8*F13,0)+IF(B13=Data!$F$16,Data!$K$9*F13,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B14=Data!$F$3,E14-0.5*G14,0)+IF(B14=Data!$F$4,E14/I14*H14-0.5*G14,0)+IF(OR(B14=Data!$F$5,B14=Data!$F$6),(E14-0.5)*F14,0)+IF(B14=Data!$F$7,MIN(J14*Data!$N$8-0.5,Data!$K$10)*F14,0)+IF(B14=Data!$F$8,(E14/G14-0.5)*F14,0)+IF(B14=Data!$F$9,MIN(2*J14*Data!$N$8-0.5,Data!$K$10)*F14,0)+IF(B14=Data!$F$10,(J14*Data!$N$9-0.5)*F14,0)+IF(OR(B14=Data!$F$11,B14=Data!$F$14),E14,0)+IF(B14=Data!$F$12,MIN(E14/G14-0.5,Data!$K$10)*F14,0)+IF(B14=Data!$F$13,MIN(E14-0.5,Data!$K$10)*F14,0)+IF(B14=Data!$F$15,Data!$K$8*F14,0)+IF(B14=Data!$F$16,Data!$K$9*F14,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B15=Data!$F$3,E15-0.5*G15,0)+IF(B15=Data!$F$4,E15/I15*H15-0.5*G15,0)+IF(OR(B15=Data!$F$5,B15=Data!$F$6),(E15-0.5)*F15,0)+IF(B15=Data!$F$7,MIN(J15*Data!$N$8-0.5,Data!$K$10)*F15,0)+IF(B15=Data!$F$8,(E15/G15-0.5)*F15,0)+IF(B15=Data!$F$9,MIN(2*J15*Data!$N$8-0.5,Data!$K$10)*F15,0)+IF(B15=Data!$F$10,(J15*Data!$N$9-0.5)*F15,0)+IF(OR(B15=Data!$F$11,B15=Data!$F$14),E15,0)+IF(B15=Data!$F$12,MIN(E15/G15-0.5,Data!$K$10)*F15,0)+IF(B15=Data!$F$13,MIN(E15-0.5,Data!$K$10)*F15,0)+IF(B15=Data!$F$15,Data!$K$8*F15,0)+IF(B15=Data!$F$16,Data!$K$9*F15,0)","v":0}]
[null,"Montant total à rembourser :",null,null,null,null,null,null,{"$f":"SUM(I11:J11)","v":0}]
[null,"Calendrier"]
[null,"2024-07-01",null,null,null,{"$f":"EDATE(B18,1)","v":"2024-08-01"},null,null,null,{"$f":"EDATE(B18,2)","v":"2024-09-01"}]
[null,{"$f":"B18","v":"2024-07-01"},"Centre",null,{"$f":"IF($D$19=Data!$J$3,Centre!$C$10,IF(OR($D$19=Data!$J$4,$D$19=Data!$J$5),Centre!$C$10/2,$D$19))","v":0},{"$f":"F18","v":"2024-08-01"},"Centre",null,{"$f":"IF($H$19=Data!$J$3,Centre!$F$10,IF(OR($H$19=Data!$J$4,$H$19=Data!$J$5),Centre!$F$10/2,$H$19))","v":0},{"$f":"J18","v":"2024-09-01"},"Centre",null,{"$f":"IF($L$19=Data!$J$3,Centre!$H$10,IF(OR($L$19=Data!$J$4,$L$19=Data!$J$5),Centre!$H$10/2,$L$19))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D20=Data!$J$3,Data!$L$3,IF(OR(D20=Data!$J$4,D20=Data!$J$5),Data!$L$3/2,D20))","v":0},null,"Entreprise",null,{"$f":"IF(H20=Data!$J$3,Data!$L$3,IF(OR(H20=Data!$J$4,H20=Data!$J$5),Data!$L$3/2,H20))","v":0},null,"Entreprise",null,{"$f":"IF(L20=Data!$J$3,Data!$L$3,IF(OR(L20=Data!$J$4,L20=Data!$J$5),Data!$L$3/2,L20))","v":0}]
[null,null,"Non payées",null,{"$f":"D21","v":0},null,"Non payées",null,{"$f":"H21","v":0},null,"Non payées",null,{"$f":"L21","v":0}]
[null,{"$f":"B19+1","v":"2024-07-02"},"Centre",null,{"$f":"IF($D$22=Data!$J$3,Centre!$D$10,IF(OR($D$22=Data!$J$4,$D$22=Data!$J$5),Centre!$D$10/2,$D$22))","v":0},{"$f":"F19+1","v":"2024-08-02"},"Centre",null,{"$f":"IF($H$22=Data!$J$3,Centre!$G$10,IF(OR($H$22=Data!$J$4,$H$22=Data!$J$5),Centre!$G$10/2,$H$22))","v":0},{"$f":"J19+1","v":"2024-09-02"},"Centre",null,{"$f":"IF($L$22=Data!$J$3,Centre!$C$10,IF(OR($L$22=Data!$J$4,$L$22=Data!$J$5),Centre!$C$10/2,$L$22))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D23=Data!$J$3,Data!$L$3,IF(OR(D23=Data!$J$4,D23=Data!$J$5),Data!$L$3/2,D23))","v":0},null,"Entreprise",null,{"$f":"IF(H23=Data!$J$3,Data!$L$3,IF(OR(H23=Data!$J$4,H23=Data!$J$5),Data!$L$3/2,H23))","v":0},null,"Entreprise",null,{"$f":"IF(L23=Data!$J$3,Data!$L$3,IF(OR(L23=Data!$J$4,L23=Data!$J$5),Data!$L$3/2,L23))","v":0}]
[null,null,"Non payées",null,{"$f":"D24","v":0},null,"Non payées",null,{"$f":"H24","v":0},null,"Non payées",null,{"$f":"L24","v":0}]
[null,{"$f":"B22+1","v":"2024-07-03"},"Centre",null,{"$f":"IF($D$25=Data!$J$3,Centre!$E$10,IF(OR($D$25=Data!$J$4,$D$25=Data!$J$5),Centre!$E$10/2,$D$25))","v":0},{"$f":"F22+1","v":"2024-08-03"},"Centre",null,{"$f":"IF($H$25=Data!$J$3,Centre!$C$10,IF(OR($H$25=Data!$J$4,$H$25=Data!$J$5),Centre!$C$10/2,$H$25))","v":0},{"$f":"J22+1","v":"2024-09-03"},"Centre",null,{"$f":"IF($L$25=Data!$J$3,Centre!$D$10,IF(OR($L$25=Data!$J$4,$L$25=Data!$J$5),Centre!$D$10/2,$L$25))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D26=Data!$J$3,Data!$L$3,IF(OR(D26=Data!$J$4,D26=Data!$J$5),Data!$L$3/2,D26))","v":0},null,"Entreprise",null,{"$f":"IF(H26=Data!$J$3,Data!$L$3,IF(OR(H26=Data!$J$4,H26=Data!$J$5),Data!$L$3/2,H26))","v":0},null,"Entreprise",null,{"$f":"IF(L26=Data!$J$3,Data!$L$3,IF(OR(L26=Data!$J$4,L26=Data!$J$5),Data!$L$3/2,L26))","v":0}]
[null,null,"Non payées",null,{"$f":"D27","v":0},null,"Non payées",null,{"$f":"H27","v":0},null,"Non payées",null,{"$f":"L27","v":0}]
[null,{"$f":"B25+1","v":"2024-07-04"},"Centre",null,{"$f":"IF($D$28=Data!$J$3,Centre!$F$10,IF(OR($D$28=Data!$J$4,$D$28=Data!$J$5),Centre!$F$10/2,$D$28))","v":0},{"$f":"F25+1","v":"2024-08-04"},"Centre",null,{"$f":"IF($H$28=Data!$J$3,Centre!$D$10,IF(OR($H$28=Data!$J$4,$H$28=Data!$J$5),Centre!$D$10/2,$H$28))","v":0},{"$f":"J25+1","v":"2024-09-04"},"Centre",null,{"$f":"IF($L$28=Data!$J$3,Centre!$E$10,IF(OR($L$28=Data!$J$4,$L$28=Data!$J$5),Centre!$E$10/2,$L$28))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D29=Data!$J$3,Data!$L$3,IF(OR(D29=Data!$J$4,D29=Data!$J$5),Data!$L$3/2,D29))","v":0},null,"Entreprise",null,{"$f":"IF(H29=Data!$J$3,Data!$L$3,IF(OR(H29=Data!$J$4,H29=Data!$J$5),Data!$L$3/2,H29))","v":0},null,"Entreprise",null,{"$f":"IF(L29=Data!$J$3,Data!$L$3,IF(OR(L29=Data!$J$4,L29=Data!$J$5),Data!$L$3/2,L29))","v":0}]
[null,null,"Non payées",null,{"$f":"D30","v":0},null,"Non payées",null,{"$f":"H30","v":0},null,"Non payées",null,{"$f":"L30","v":0}]
[null,{"$f":"B28+1","v":"2024-07-05"},"Centre",null,{"$f":"IF($D$31=Data!$J$3,Centre!$G$10,IF(OR($D$31=Data!$J$4,$D$31=Data!$J$5),Centre!$G$10/2,$D$31))","v":0},{"$f":"F28+1","v":"2024-08-05"},"Centre",null,{"$f":"IF($H$31=Data!$J$3,Centre!$C$10,IF(OR($H$31=Data!$J$4,$H$31=Data!$J$5),Centre!$C$10/2,$H$31))","v":0},{"$f":"J28+1","v":"2024-09-05"},"Centre",null,{"$f":"IF($L$31=Data!$J$3,Centre!$F$10,IF(OR($L$31=Data!$J$4,$L$31=Data!$J$5),Centre!$F$10/2,$L$31))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D32=Data!$J$3,Data!$L$3,IF(OR(D32=Data!$J$4,D32=Data!$J$5),Data!$L$3/2,D32))","v":0},null,"Entreprise",null,{"$f":"IF(H32=Data!$J$3,Data!$L$3,IF(OR(H32=Data!$J$4,H32=Data!$J$5),Data!$L$3/2,H32))","v":0},null,"Entreprise",null,{"$f":"IF(L32=Data!$J$3,Data!$L$3,IF(OR(L32=Data!$J$4,L32=Data!$J$5),Data!$L$3/2,L32))","v":0}]
[null,null,"Non payées",null,{"$f":"D33","v":0},null,"Non payées",null,{"$f":"H33","v":0},null,"Non payées",null,{"$f":"L33","v":0}]
[null,{"$f":"B31+1","v":"2024-07-06"},"Centre",null,0,{"$f":"F31+1","v":"2024-08-06"},"Centre",null,{"$f":"IF($H$34=Data!$J$3,Centre!$D$10,IF(OR($H$34=Data!$J$4,$H$34=Data!$J$5),Centre!$D$10/2,$H$34))","v":0},{"$f":"J31+1","v":"2024-09-06"},"Centre",null,{"$f":"IF($L$34=Data!$J$3,Centre!$G$10,IF(OR($L$34=Data!$J$4,$L$34=Data!$J$5),Centre!$G$10/2,$L$34))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D35=Data!$J$3,Data!$L$3,IF(OR(D35=Data!$J$4,D35=Data!$J$5),Data!$L$3/2,D35))","v":0},null,"Entreprise",null,{"$f":"IF(H35=Data!$J$3,Data!$L$3,IF(OR(H35=Data!$J$4,H35=Data!$J$5),Data!$L$3/2,H35))","v":0},null,"Entreprise",null,{"$f":"IF(L35=Data!$J$3,Data!$L$3,IF(OR(L35=Data!$J$4,L35=Data!$J$5),Data!$L$3/2,L35))","v":0}]
[null,null,"Non payées",null,{"$f":"D36","v":0},null,"Non payées",null,{"$f":"H36","v":0},null,"Non payées",null,{"$f":"L36","v":0}]
[null,{"$f":"B34+1","v":"2024-07-07"},"Centre",null,0,{"$f":"F34+1","v":"2024-08-07"},"Centre",null,{"$f":"IF($H$37=Data!$J$3,Centre!$E$10,IF(OR($H$37=Data!$J$4,$H$37=Data!$J$5),Centre!$E$10/2,$H$37))","v":0},{"$f":"J34+1","v":"2024-09-07"},"Centre",null,{"$f":"IF($L$37=Data!$J$3,Centre!$G$10,IF(OR($L$37=Data!$J$4,$L$37=Data!$J$5),Centre!$G$10/2,$L$37))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D38=Data!$J$3,Data!$L$3,IF(OR(D38=Data!$J$4,D38=Data!$J$5),Data!$L$3/2,D38))","v":0},null,"Entreprise",null,{"$f":"IF(H38=Data!$J$3,Data!$L$3,IF(OR(H38=Data!$J$4,H38=Data!$J$5),Data!$L$3/2,H38))","v":0},null,"Entreprise",null,{"$f":"IF(L38=Data!$J$3,Data!$L$3,IF(OR(L38=Data!$J$4,L38=Data!$J$5),Data!$L$3/2,L38))","v":0}]
[null,null,"Non payées",null,{"$f":"D39","v":0},null,"Non payées",null,{"$f":"H39","v":0},null,"Non payées",null,{"$f":"L39","v":0}]
[null,{"$f":"B37+1","v":"2024-07-08"},"Centre",null,{"$f":"IF($D$40=Data!$J$3,Centre!$C$10,IF(OR($D$40=Data!$J$4,$D$40=Data!$J$5),Centre!$C$10/2,$D$40))","v":0},{"$f":"F37+1","v":"2024-08-08"},"Centre",null,{"$f":"IF($H$40=Data!$J$3,Centre!$F$10,IF(OR($H$40=Data!$J$4,$H$40=Data!$J$5),Centre!$F$10/2,$H$40))","v":0},{"$f":"J37+1","v":"2024-09-08"},"Centre",null,{"$f":"IF($L$40=Data!$J$3,Centre!$H$10,IF(OR($L$40=Data!$J$4,$L$40=Data!$J$5),Centre!$H$10/2,$L$40))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D41=Data!$J$3,Data!$L$3,IF(OR(D41=Data!$J$4,D41=Data!$J$5),Data!$L$3/2,D41))","v":0},null,"Entreprise",null,{"$f":"IF(H41=Data!$J$3,Data!$L$3,IF(OR(H41=Data!$J$4,H41=Data!$J$5),Data!$L$3/2,H41))","v":0},null,"Entreprise",null,{"$f":"IF(L41=Data!$J$3,Data!$L$3,IF(OR(L41=Data!$J$4,L41=Data!$J$5),Data!$L$3/2,L41))","v":0}]
[null,null,"Non payées",null,{"$f":"D42","v":0},null,"Non payées",null,{"$f":"H42","v":0},null,"Non payées",null,{"$f":"L42","v":0}]
[null,{"$f":"B40+1","v":"2024-07-09"},"Centre",null,{"$f":"IF($D$43=Data!$J$3,Centre!$D$10,IF(OR($D$43=Data!$J$4,$D$43=Data!$J$5),Centre!$D$10/2,$D$43))","v":0},{"$f":"F40+1","v":"2024-08-09"},"Centre",null,{"$f":"IF($H$43=Data!$J$3,Centre!$G$10,IF(OR($H$43=Data!$J$4,$H$43=Data!$J$5),Centre!$G$10/2,$H$43))","v":0},{"$f":"J40+1","v":"2024-09-09"},"Centre",null,{"$f":"IF($L$43=Data!$J$3,Centre!$C$10,IF(OR($L$43=Data!$J$4,$L$43=Data!$J$5),Centre!$C$10/2,$L$43))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D44=Data!$J$3,Data!$L$3,IF(OR(D44=Data!$J$4,D44=Data!$J$5),Data!$L$3/2,D44))","v":0},null,"Entreprise",null,{"$f":"IF(H44=Data!$J$3,Data!$L$3,IF(OR(H44=Data!$J$4,H44=Data!$J$5),Data!$L$3/2,H44))","v":0},null,"Entreprise",null,{"$f":"IF(L44=Data!$J$3,Data!$L$3,IF(OR(L44=Data!$J$4,L44=Data!$J$5),Data!$L$3/2,L44))","v":0}]
[null,null,"Non payées",null,{"$f":"D45","v":0},null,"Non payées",null,{"$f":"H45","v":0},null,"Non payées",null,{"$f":"L45","v":0}]
[null,{"$f":"B43+1","v":"2024-07-10"},"Centre",null,{"$f":"IF($D$46=Data!$J$3,Centre!$E$10,IF(OR($D$46=Data!$J$4,$D$46=Data!$J$5),Centre!$E$10/2,$D$46))","v":0},{"$f":"F43+1","v":"2024-08-10"},"Centre",null,{"$f":"IF($H$46=Data!$J$3,Centre!$C$10,IF(OR($H$46=Data!$J$4,$H$46=Data!$J$5),Centre!$C$10/2,$H$46))","v":0},{"$f":"J43+1","v":"2024-09-10"},"Centre",null,{"$f":"IF($L$46=Data!$J$3,Centre!$D$10,IF(OR($L$46=Data!$J$4,$L$46=Data!$J$5),Centre!$D$10/2,$L$46))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D47=Data!$J$3,Data!$L$3,IF(OR(D47=Data!$J$4,D47=Data!$J$5),Data!$L$3/2,D47))","v":0},null,"Entreprise",null,{"$f":"IF(H47=Data!$J$3,Data!$L$3,IF(OR(H47=Data!$J$4,H47=Data!$J$5),Data!$L$3/2,H47))","v":0},null,"Entreprise",null,{"$f":"IF(L47=Data!$J$3,Data!$L$3,IF(OR(L47=Data!$J$4,L47=Data!$J$5),Data!$L$3/2,L47))","v":0}]
[null,null,"Non payées",null,{"$f":"D48","v":0},null,"Non payées",null,{"$f":"H48","v":0},null,"Non payées",null,{"$f":"L48","v":0}]
[null,{"$f":"B46+1","v":"2024-07-11"},"Centre",null,{"$f":"IF($D$49=Data!$J$3,Centre!$F$10,IF(OR($D$49=Data!$J$4,$D$49=Data!$J$5),Centre!$F$10/2,$D$49))","v":0},{"$f":"F46+1","v":"2024-08-11"},"Centre",null,{"$f":"IF($H$49=Data!$J$3,Centre!$D$10,IF(OR($H$49=Data!$J$4,$H$49=Data!$J$5),Centre!$D$10/2,$H$49))","v":0},{"$f":"J46+1","v":"2024-09-11"},"Centre",null,{"$f":"IF($L$49=Data!$J$3,Centre!$E$10,IF(OR($L$49=Data!$J$4,$L$49=Data!$J$5),Centre!$E$10/2,$L$49))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D50=Data!$J$3,Data!$L$3,IF(OR(D50=Data!$J$4,D50=Data!$J$5),Data!$L$3/2,D50))","v":0},null,"Entreprise",null,{"$f":"IF(H50=Data!$J$3,Data!$L$3,IF(OR(H50=Data!$J$4,H50=Data!$J$5),Data!$L$3/2,H50))","v":0},null,"Entreprise",null,{"$f":"IF(L50=Data!$J$3,Data!$L$3,IF(OR(L50=Data!$J$4,L50=Data!$J$5),Data!$L$3/2,L50))","v":0}]
[null,null,"Non payées",null,{"$f":"D51","v":0},null,"Non payées",null,{"$f":"H51","v":0},null,"Non payées",null,{"$f":"L51","v":0}]
[null,{"$f":"B49+1","v":"2024-07-12"},"Centre",null,{"$f":"IF($D$52=Data!$J$3,Centre!$G$10,IF(OR($D$52=Data!$J$4,$D$52=Data!$J$5),Centre!$G$10/2,$D$52))","v":0},{"$f":"F49+1","v":"2024-08-12"},"Centre",null,{"$f":"IF($H$52=Data!$J$3,Centre!$C$10,IF(OR($H$52=Data!$J$4,$H$52=Data!$J$5),Centre!$C$10/2,$H$52))","v":0},{"$f":"J49+1","v":"2024-09-12"},"Centre",null,{"$f":"IF($L$52=Data!$J$3,Centre!$F$10,IF(OR($L$52=Data!$J$4,$L$52=Data!$J$5),Centre!$F$10/2,$L$52))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D53=Data!$J$3,Data!$L$3,IF(OR(D53=Data!$J$4,D53=Data!$J$5),Data!$L$3/2,D53))","v":0},null,"Entreprise",null,{"$f":"IF(H53=Data!$J$3,Data!$L$3,IF(OR(H53=Data!$J$4,H53=Data!$J$5),Data!$L$3/2,H53))","v":0},null,"Entreprise",null,{"$f":"IF(L53=Data!$J$3,Data!$L$3,IF(OR(L53=Data!$J$4,L53=Data!$J$5),Data!$L$3/2,L53))","v":0}]
[null,null,"Non payées",null,{"$f":"D54","v":0},null,"Non payées",null,{"$f":"H54","v":0},null,"Non payées",null,{"$f":"L54","v":0}]
[null,{"$f":"B52+1","v":"2024-07-13"},"Centre",null,0,{"$f":"F52+1","v":"2024-08-13"},"Centre",null,{"$f":"IF($H$55=Data!$J$3,Centre!$D$10,IF(OR($H$55=Data!$J$4,$H$55=Data!$J$5),Centre!$D$10/2,$H$55))","v":0},{"$f":"J52+1","v":"2024-09-13"},"Centre",null,{"$f":"IF($L$55=Data!$J$3,Centre!$G$10,IF(OR($L$55=Data!$J$4,$L$55=Data!$J$5),Centre!$G$10/2,$L$55))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D56=Data!$J$3,Data!$L$3,IF(OR(D56=Data!$J$4,D56=Data!$J$5),Data!$L$3/2,D56))","v":0},null,"Entreprise",null,{"$f":"IF(H56=Data!$J$3,Data!$L$3,IF(OR(H56=Data!$J$4,H56=Data!$J$5),Data!$L$3/2,H56))","v":0},null,"Entreprise",null,{"$f":"IF(L56=Data!$J$3,Data!$L$3,IF(OR(L56=Data!$J$4,L56=Data!$J$5),Data!$L$3/2,L56))","v":0}]
[null,null,"Non payées",null,{"$f":"D57","v":0},null,"Non payées",null,{"$f":"H57","v":0},null,"Non payées",null,{"$f":"L57","v":0}]
[null,{"$f":"B55+1","v":"2024-07-14"},"Centre",null,0,{"$f":"F55+1","v":"2024-08-14"},"Centre",null,{"$f":"IF($H$58=Data!$J$3,Centre!$E$10,IF(OR($H$58=Data!$J$4,$H$58=Data!$J$5),Centre!$E$10/2,$H$58))","v":0},{"$f":"J55+1","v":"2024-09-14"},"Centre",null,{"$f":"IF($L$58=Data!$J$3,Centre!$G$10,IF(OR($L$58=Data!$J$4,$L$58=Data!$J$5),Centre!$G$10/2,$L$58))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D59=Data!$J$3,Data!$L$3,IF(OR(D59=Data!$J$4,D59=Data!$J$5),Data!$L$3/2,D59))","v":0},null,"Entreprise",null,{"$f":"IF(H59=Data!$J$3,Data!$L$3,IF(OR(H59=Data!$J$4,H59=Data!$J$5),Data!$L$3/2,H59))","v":0},null,"Entreprise",null,{"$f":"IF(L59=Data!$J$3,Data!$L$3,IF(OR(L59=Data!$J$4,L59=Data!$J$5),Data!$L$3/2,L59))","v":0}]
[null,null,"Non payées",null,{"$f":"D60","v":0},null,"Non payées",null,{"$f":"H60","v":0},null,"Non payées",null,{"$f":"L60","v":0}]
[null,{"$f":"B58+1","v":"2024-07-15"},"Centre",null,{"$f":"IF($D$61=Data!$J$3,Centre!$C$10,IF(OR($D$61=Data!$J$4,$D$61=Data!$J$5),Centre!$C$10/2,$D$61))","v":0},{"$f":"F58+1","v":"2024-08-15"},"Centre",null,{"$f":"IF($H$61=Data!$J$3,Centre!$F$10,IF(OR($H$61=Data!$J$4,$H$61=Data!$J$5),Centre!$F$10/2,$H$61))","v":0},{"$f":"J58+1","v":"2024-09-15"},"Centre",null,{"$f":"IF($L$61=Data!$J$3,Centre!$H$10,IF(OR($L$61=Data!$J$4,$L$61=Data!$J$5),Centre!$H$10/2,$L$61))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D62=Data!$J$3,Data!$L$3,IF(OR(D62=Data!$J$4,D62=Data!$J$5),Data!$L$3/2,D62))","v":0},null,"Entreprise",null,{"$f":"IF(H62=Data!$J$3,Data!$L$3,IF(OR(H62=Data!$J$4,H62=Data!$J$5),Data!$L$3/2,H62))","v":0},null,"Entreprise",null,{"$f":"IF(L62=Data!$J$3,Data!$L$3,IF(OR(L62=Data!$J$4,L62=Data!$J$5),Data!$L$3/2,L62))","v":0}]
[null,null,"Non payées",null,{"$f":"D63","v":0},null,"Non payées",null,{"$f":"H63","v":0},null,"Non payées",null,{"$f":"L63","v":0}]
[null,{"$f":"B61+1","v":"2024-07-16"},"Centre",null,{"$f":"IF($D$64=Data!$J$3,Centre!$D$10,IF(OR($D$64=Data!$J$4,$D$64=Data!$J$5),Centre!$D$10/2,$D$64))","v":0},{"$f":"F61+1","v":"2024-08-16"},"Centre",null,{"$f":"IF($H$64=Data!$J$3,Centre!$G$10,IF(OR($H$64=Data!$J$4,$H$64=Data!$J$5),Centre!$G$10/2,$H$64))","v":0},{"$f":"J61+1","v":"2024-09-16"},"Centre",null,{"$f":"IF($L$64=Data!$J$3,Centre!$C$10,IF(OR($L$64=Data!$J$4,$L$64=Data!$J$5),Centre!$C$10/2,$L$64))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D65=Data!$J$3,Data!$L$3,IF(OR(D65=Data!$J$4,D65=Data!$J$5),Data!$L$3/2,D65))","v":0},null,"Entreprise",null,{"$f":"IF(H65=Data!$J$3,Data!$L$3,IF(OR(H65=Data!$J$4,H65=Data!$J$5),Data!$L$3/2,H65))","v":0},null,"Entreprise",null,{"$f":"IF(L65=Data!$J$3,Data!$L$3,IF(OR(L65=Data!$J$4,L65=Data!$J$5),Data!$L$3/2,L65))","v":0}]
[null,null,"Non payées",null,{"$f":"D66","v":0},null,"Non payées",null,{"$f":"H66","v":0},null,"Non payées",null,{"$f":"L66","v":0}]
[null,{"$f":"B64+1","v":"2024-07-17"},"Centre",null,{"$f":"IF($D$67=Data!$J$3,Centre!$E$10,IF(OR($D$67=Data!$J$4,$D$67=Data!$J$5),Centre!$E$10/2,$D$67))","v":0},{"$f":"F64+1","v":"2024-08-17"},"Centre",null,{"$f":"IF($H$67=Data!$J$3,Centre!$C$10,IF(OR($H$67=Data!$J$4,$H$67=Data!$J$5),Centre!$C$10/2,$H$67))","v":0},{"$f":"J64+1","v":"2024-09-17"},"Centre",null,{"$f":"IF($L$67=Data!$J$3,Centre!$D$10,IF(OR($L$67=Data!$J$4,$L$67=Data!$J$5),Centre!$D$10/2,$L$67))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D68=Data!$J$3,Data!$L$3,IF(OR(D68=Data!$J$4,D68=Data!$J$5),Data!$L$3/2,D68))","v":0},null,"Entreprise",null,{"$f":"IF(H68=Data!$J$3,Data!$L$3,IF(OR(H68=Data!$J$4,H68=Data!$J$5),Data!$L$3/2,H68))","v":0},null,"Entreprise",null,{"$f":"IF(L68=Data!$J$3,Data!$L$3,IF(OR(L68=Data!$J$4,L68=Data!$J$5),Data!$L$3/2,L68))","v":0}]
[null,null,"Non payées",null,{"$f":"D69","v":0},null,"Non payées",null,{"$f":"H69","v":0},null,"Non payées",null,{"$f":"L69","v":0}]
[null,{"$f":"B67+1","v":"2024-07-18"},"Centre",null,{"$f":"IF($D$70=Data!$J$3,Centre!$F$10,IF(OR($D$70=Data!$J$4,$D$70=Data!$J$5),Centre!$F$10/2,$D$70))","v":0},{"$f":"F67+1","v":"2024-08-18"},"Centre",null,{"$f":"IF($H$70=Data!$J$3,Centre!$D$10,IF(OR($H$70=Data!$J$4,$H$70=Data!$J$5),Centre!$D$10/2,$H$70))","v":0},{"$f":"J67+1","v":"2024-09-18"},"Centre",null,{"$f":"IF($L$70=Data!$J$3,Centre!$E$10,IF(OR($L$70=Data!$J$4,$L$70=Data!$J$5),Centre!$E$10/2,$L$70))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D71=Data!$J$3,Data!$L$3,IF(OR(D71=Data!$J$4,D71=Data!$J$5),Data!$L$3/2,D71))","v":0},null,"Entreprise",null,{"$f":"IF(H71=Data!$J$3,Data!$L$3,IF(OR(H71=Data!$J$4,H71=Data!$J$5),Data!$L$3/2,H71))","v":0},null,"Entreprise",null,{"$f":"IF(L71=Data!$J$3,Data!$L$3,IF(OR(L71=Data!$J$4,L71=Data!$J$5),Data!$L$3/2,L71))","v":0}]
[null,null,"Non payées",null,{"$f":"D72","v":0},null,"Non payées",null,{"$f":"H72","v":0},null,"Non payées",null,{"$f":"L72","v":0}]
[null,{"$f":"B70+1","v":"2024-07-19"},"Centre",null,{"$f":"IF($D$73=Data!$J$3,Centre!$G$10,IF(OR($D$73=Data!$J$4,$D$73=Data!$J$5),Centre!$G$10/2,$D$73))","v":0},{"$f":"F70+1","v":"2024-08-19"},"Centre",null,{"$f":"IF($H$73=Data!$J$3,Centre!$C$10,IF(OR($H$73=Data!$J$4,$H$73=Data!$J$5),Centre!$C$10/2,$H$73))","v":0},{"$f":"J70+1","v":"2024-09-19"},"Centre",null,{"$f":"IF($L$73=Data!$J$3,Centre!$F$10,IF(OR($L$73=Data!$J$4,$L$73=Data!$J$5),Centre!$F$10/2,$L$73))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D74=Data!$J$3,Data!$L$3,IF(OR(D74=Data!$J$4,D74=Data!$J$5),Data!$L$3/2,D74))","v":0},null,"Entreprise",null,{"$f":"IF(H74=Data!$J$3,Data!$L$3,IF(OR(H74=Data!$J$4,H74=Data!$J$5),Data!$L$3/2,H74))","v":0},null,"Entreprise",null,{"$f":"IF(L74=Data!$J$3,Data!$L$3,IF(OR(L74=Data!$J$4,L74=Data!$J$5),Data!$L$3/2,L74))","v":0}]
[null,null,"Non payées",null,{"$f":"D75","v":0},null,"Non payées",null,{"$f":"H75","v":0},null,"Non payées",null,{"$f":"L75","v":0}]
[null,{"$f":"B73+1","v":"2024-07-20"},"Centre",null,{"$f":"IF($D$76=Data!$J$3,Centre!$C$10,IF(OR($D$76=Data!$J$4,$D$76=Data!$J$5),Centre!$C$10/2,$D$76))","v":0},{"$f":"F73+1","v":"2024-08-20"},"Centre",null,{"$f":"IF($H$76=Data!$J$3,Centre!$D$10,IF(OR($H$76=Data!$J$4,$H$76=Data!$J$5),Centre!$D$10/2,$H$76))","v":0},{"$f":"J73+1","v":"2024-09-20"},"Centre",null,{"$f":"IF($L$76=Data!$J$3,Centre!$G$10,IF(OR($L$76=Data!$J$4,$L$76=Data!$J$5),Centre!$G$10/2,$L$76))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D77=Data!$J$3,Data!$L$3,IF(OR(D77=Data!$J$4,D77=Data!$J$5),Data!$L$3/2,D77))","v":0},null,"Entreprise",null,{"$f":"IF(H77=Data!$J$3,Data!$L$3,IF(OR(H77=Data!$J$4,H77=Data!$J$5),Data!$L$3/2,H77))","v":0},null,"Entreprise",null,{"$f":"IF(L77=Data!$J$3,Data!$L$3,IF(OR(L77=Data!$J$4,L77=Data!$J$5),Data!$L$3/2,L77))","v":0}]
[null,null,"Non payées",null,{"$f":"D78","v":0},null,"Non payées",null,{"$f":"H78","v":0},null,"Non payées",null,{"$f":"L78","v":0}]
[null,{"$f":"B76+1","v":"2024-07-21"},"Centre",null,{"$f":"IF($D$79=Data!$J$3,Centre!$D$10,IF(OR($D$79=Data!$J$4,$D$79=Data!$J$5),Centre!$D$10/2,$D$79))","v":0},{"$f":"F76+1","v":"2024-08-21"},"Centre",null,{"$f":"IF($H$79=Data!$J$3,Centre!$E$10,IF(OR($H$79=Data!$J$4,$H$79=Data!$J$5),Centre!$E$10/2,$H$79))","v":0},{"$f":"J76+1","v":"2024-09-21"},"Centre",null,{"$f":"IF($L$79=Data!$J$3,Centre!$G$10,IF(OR($L$79=Data!$J$4,$L$79=Data!$J$5),Centre!$G$10/2,$L$79))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D80=Data!$J$3,Data!$L$3,IF(OR(D80=Data!$J$4,D80=Data!$J$5),Data!$L$3/2,D80))","v":0},null,"Entreprise",null,{"$f":"IF(H80=Data!$J$3,Data!$L$3,IF(OR(H80=Data!$J$4,H80=Data!$J$5),Data!$L$3/2,H80))","v":0},null,"Entreprise",null,{"$f":"IF(L80=Data!$J$3,Data!$L$3,IF(OR(L80=Data!$J$4,L80=Data!$J$5),Data!$L$3/2,L80))","v":0}]
[null,null,"Non payées",null,{"$f":"D81","v":0},null,"Non payées",null,{"$f":"H81","v":0},null,"Non payées",null,{"$f":"L81","v":0}]
[null,{"$f":"B79+1","v":"2024-07-22"},"Centre",null,{"$f":"IF($D$82=Data!$J$3,Centre!$C$10,IF(OR($D$82=Data!$J$4,$D$82=Data!$J$5),Centre!$C$10/2,$D$82))","v":0},{"$f":"F79+1","v":"2024-08-22"},"Centre",null,{"$f":"IF($H$82=Data!$J$3,Centre!$F$10,IF(OR($H$82=Data!$J$4,$H$82=Data!$J$5),Centre!$F$10/2,$H$82))","v":0},{"$f":"J79+1","v":"2024-09-22"},"Centre",null,{"$f":"IF($L$82=Data!$J$3,Centre!$H$10,IF(OR($L$82=Data!$J$4,$L$82=Data!$J$5),Centre!$H$10/2,$L$82))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D83=Data!$J$3,Data!$L$3,IF(OR(D83=Data!$J$4,D83=Data!$J$5),Data!$L$3/2,D83))","v":0},null,"Entreprise",null,{"$f":"IF(H83=Data!$J$3,Data!$L$3,IF(OR(H83=Data!$J$4,H83=Data!$J$5),Data!$L$3/2,H83))","v":0},null,"Entreprise",null,{"$f":"IF(L83=Data!$J$3,Data!$L$3,IF(OR(L83=Data!$J$4,L83=Data!$J$5),Data!$L$3/2,L83))","v":0}]
[null,null,"Non payées",null,{"$f":"D84","v":0},null,"Non payées",null,{"$f":"H84","v":0},null,"Non payées",null,{"$f":"L84","v":0}]
[null,{"$f":"B82+1","v":"2024-07-23"},"Centre",null,{"$f":"IF($D$85=Data!$J$3,Centre!$D$10,IF(OR($D$85=Data!$J$4,$D$85=Data!$J$5),Centre!$D$10/2,$D$85))","v":0},{"$f":"F82+1","v":"2024-08-23"},"Centre",null,{"$f":"IF($H$85=Data!$J$3,Centre!$G$10,IF(OR($H$85=Data!$J$4,$H$85=Data!$J$5),Centre!$G$10/2,$H$85))","v":0},{"$f":"J82+1","v":"2024-09-23"},"Centre",null,{"$f":"IF($L$85=Data!$J$3,Centre!$C$10,IF(OR($L$85=Data!$J$4,$L$85=Data!$J$5),Centre!$C$10/2,$L$85))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D86=Data!$J$3,Data!$L$3,IF(OR(D86=Data!$J$4,D86=Data!$J$5),Data!$L$3/2,D86))","v":0},null,"Entreprise",null,{"$f":"IF(H86=Data!$J$3,Data!$L$3,IF(OR(H86=Data!$J$4,H86=Data!$J$5),Data!$L$3/2,H86))","v":0},null,"Entreprise",null,{"$f":"IF(L86=Data!$J$3,Data!$L$3,IF(OR(L86=Data!$J$4,L86=Data!$J$5),Data!$L$3/2,L86))","v":0}]
[null,null,"Non payées",null,{"$f":"D87","v":0},null,"Non payées",null,{"$f":"H87","v":0},null,"Non payées",null,{"$f":"L87","v":0}]
[null,{"$f":"B85+1","v":"2024-07-24"},"Centre",null,{"$f":"IF($D$88=Data!$J$3,Centre!$E$10,IF(OR($D$88=Data!$J$4,$D$88=Data!$J$5),Centre!$E$10/2,$D$88))","v":0},{"$f":"F85+1","v":"2024-08-24"},"Centre",null,{"$f":"IF($H$88=Data!$J$3,Centre!$C$10,IF(OR($H$88=Data!$J$4,$H$88=Data!$J$5),Centre!$C$10/2,$H$88))","v":0},{"$f":"J85+1","v":"2024-09-24"},"Centre",null,{"$f":"IF($L$88=Data!$J$3,Centre!$D$10,IF(OR($L$88=Data!$J$4,$L$88=Data!$J$5),Centre!$D$10/2,$L$88))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D89=Data!$J$3,Data!$L$3,IF(OR(D89=Data!$J$4,D89=Data!$J$5),Data!$L$3/2,D89))","v":0},null,"Entreprise",null,{"$f":"IF(H89=Data!$J$3,Data!$L$3,IF(OR(H89=Data!$J$4,H89=Data!$J$5),Data!$L$3/2,H89))","v":0},null,"Entreprise",null,{"$f":"IF(L89=Data!$J$3,Data!$L$3,IF(OR(L89=Data!$J$4,L89=Data!$J$5),Data!$L$3/2,L89))","v":0}]
[null,null,"Non payées",null,{"$f":"D90","v":0},null,"Non payées",null,{"$f":"H90","v":0},null,"Non payées",null,{"$f":"L90","v":0}]
[null,{"$f":"B88+1","v":"2024-07-25"},"Centre",null,{"$f":"IF($D$91=Data!$J$3,Centre!$F$10,IF(OR($D$91=Data!$J$4,$D$91=Data!$J$5),Centre!$F$10/2,$D$91))","v":0},{"$f":"F88+1","v":"2024-08-25"},"Centre",null,{"$f":"IF($H$91=Data!$J$3,Centre!$D$10,IF(OR($H$91=Data!$J$4,$H$91=Data!$J$5),Centre!$D$10/2,$H$91))","v":0},{"$f":"J88+1","v":"2024-09-25"},"Centre",null,{"$f":"IF($L$91=Data!$J$3,Centre!$E$10,IF(OR($L$91=Data!$J$4,$L$91=Data!$J$5),Centre!$E$10/2,$L$91))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D92=Data!$J$3,Data!$L$3,IF(OR(D92=Data!$J$4,D92=Data!$J$5),Data!$L$3/2,D92))","v":0},null,"Entreprise",null,{"$f":"IF(H92=Data!$J$3,Data!$L$3,IF(OR(H92=Data!$J$4,H92=Data!$J$5),Data!$L$3/2,H92))","v":0},null,"Entreprise",null,{"$f":"IF(L92=Data!$J$3,Data!$L$3,IF(OR(L92=Data!$J$4,L92=Data!$J$5),Data!$L$3/2,L92))","v":0}]
[null,null,"Non payées",null,{"$f":"D93","v":0},null,"Non payées",null,{"$f":"H93","v":0},null,"Non payées",null,{"$f":"L93","v":0}]
[null,{"$f":"B91+1","v":"2024-07-26"},"Centre",null,{"$f":"IF($D$94=Data!$J$3,Centre!$G$10,IF(OR($D$94=Data!$J$4,$D$94=Data!$J$5),Centre!$G$10/2,$D$94))","v":0},{"$f":"F91+1","v":"2024-08-26"},"Centre",null,{"$f":"IF($H$94=Data!$J$3,Centre!$C$10,IF(OR($H$94=Data!$J$4,$H$94=Data!$J$5),Centre!$C$10/2,$H$94))","v":0},{"$f":"J91+1","v":"2024-09-26"},"Centre",null,{"$f":"IF($L$94=Data!$J$3,Centre!$F$10,IF(OR($L$94=Data!$J$4,$L$94=Data!$J$5),Centre!$F$10/2,$L$94))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D95=Data!$J$3,Data!$L$3,IF(OR(D95=Data!$J$4,D95=Data!$J$5),Data!$L$3/2,D95))","v":0},null,"Entreprise",null,{"$f":"IF(H95=Data!$J$3,Data!$L$3,IF(OR(H95=Data!$J$4,H95=Data!$J$5),Data!$L$3/2,H95))","v":0},null,"Entreprise",null,{"$f":"IF(L95=Data!$J$3,Data!$L$3,IF(OR(L95=Data!$J$4,L95=Data!$J$5),Data!$L$3/2,L95))","v":0}]
[null,null,"Non payées",null,{"$f":"D96","v":0},null,"Non payées",null,{"$f":"H96","v":0},null,"Non payées",null,{"$f":"L96","v":0}]
[null,{"$f":"B94+1","v":"2024-07-27"},"Centre",null,{"$f":"IF($D$97=Data!$J$3,Centre!$C$10,IF(OR($D$97=Data!$J$4,$D$97=Data!$J$5),Centre!$C$10/2,$D$97))","v":0},{"$f":"F94+1","v":"2024-08-27"},"Centre",null,{"$f":"IF($H$97=Data!$J$3,Centre!$D$10,IF(OR($H$97=Data!$J$4,$H$97=Data!$J$5),Centre!$D$10/2,$H$97))","v":0},{"$f":"J94+1","v":"2024-09-27"},"Centre",null,{"$f":"IF($L$97=Data!$J$3,Centre!$G$10,IF(OR($L$97=Data!$J$4,$L$97=Data!$J$5),Centre!$G$10/2,$L$97))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D98=Data!$J$3,Data!$L$3,IF(OR(D98=Data!$J$4,D98=Data!$J$5),Data!$L$3/2,D98))","v":0},null,"Entreprise",null,{"$f":"IF(H98=Data!$J$3,Data!$L$3,IF(OR(H98=Data!$J$4,H98=Data!$J$5),Data!$L$3/2,H98))","v":0},null,"Entreprise",null,{"$f":"IF(L98=Data!$J$3,Data!$L$3,IF(OR(L98=Data!$J$4,L98=Data!$J$5),Data!$L$3/2,L98))","v":0}]
[null,null,"Non payées",null,{"$f":"D99","v":0},null,"Non payées",null,{"$f":"H99","v":0},null,"Non payées",null,{"$f":"L99","v":0}]
[null,{"$f":"B97+1","v":"2024-07-28"},"Centre",null,{"$f":"IF($D$100=Data!$J$3,Centre!$D$10,IF(OR($D$100=Data!$J$4,$D$100=Data!$J$5),Centre!$D$10/2,$D$100))","v":0},{"$f":"F97+1","v":"2024-08-28"},"Centre",null,{"$f":"IF($H$100=Data!$J$3,Centre!$E$10,IF(OR($H$100=Data!$J$4,$H$100=Data!$J$5),Centre!$E$10/2,$H$100))","v":0},{"$f":"J97+1","v":"2024-09-28"},"Centre",null,{"$f":"IF($L$100=Data!$J$3,Centre!$G$10,IF(OR($L$100=Data!$J$4,$L$100=Data!$J$5),Centre!$G$10/2,$L$100))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D101=Data!$J$3,Data!$L$3,IF(OR(D101=Data!$J$4,D101=Data!$J$5),Data!$L$3/2,D101))","v":0},null,"Entreprise",null,{"$f":"IF(H101=Data!$J$3,Data!$L$3,IF(OR(H101=Data!$J$4,H101=Data!$J$5),Data!$L$3/2,H101))","v":0},null,"Entreprise",null,{"$f":"IF(L101=Data!$J$3,Data!$L$3,IF(OR(L101=Data!$J$4,L101=Data!$J$5),Data!$L$3/2,L101))","v":0}]
[null,null,"Non payées",null,{"$f":"D102","v":0},null,"Non payées",null,{"$f":"H102","v":0},null,"Non payées",null,{"$f":"L102","v":0}]
[null,{"$f":"B100+1","v":"2024-07-29"},"Centre",null,{"$f":"IF($D$103=Data!$J$3,Centre!$C$10,IF(OR($D$103=Data!$J$4,$D$103=Data!$J$5),Centre!$C$10/2,$D$103))","v":0},{"$f":"F100+1","v":"2024-08-29"},"Centre",null,{"$f":"IF($H$103=Data!$J$3,Centre!$F$10,IF(OR($H$103=Data!$J$4,$H$103=Data!$J$5),Centre!$F$10/2,$H$103))","v":0},{"$f":"J100+1","v":"2024-09-29"},"Centre",null,{"$f":"IF($L$103=Data!$J$3,Centre!$H$10,IF(OR($L$103=Data!$J$4,$L$103=Data!$J$5),Centre!$H$10/2,$L$103))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D104=Data!$J$3,Data!$L$3,IF(OR(D104=Data!$J$4,D104=Data!$J$5),Data!$L$3/2,D104))","v":0},null,"Entreprise",null,{"$f":"IF(H104=Data!$J$3,Data!$L$3,IF(OR(H104=Data!$J$4,H104=Data!$J$5),Data!$L$3/2,H104))","v":0},null,"Entreprise",null,{"$f":"IF(L104=Data!$J$3,Data!$L$3,IF(OR(L104=Data!$J$4,L104=Data!$J$5),Data!$L$3/2,L104))","v":0}]
[null,null,"Non payées",null,{"$f":"D105","v":0},null,"Non payées",null,{"$f":"H105","v":0},null,"Non payées",null,{"$f":"L105","v":0}]
[null,{"$f":"B103+1","v":"2024-07-30"},"Centre",null,{"$f":"IF($D$106=Data!$J$3,Centre!$D$10,IF(OR($D$106=Data!$J$4,$D$106=Data!$J$5),Centre!$D$10/2,$D$106))","v":0},{"$f":"F103+1","v":"2024-08-30"},"Centre",null,{"$f":"IF($H$106=Data!$J$3,Centre!$G$10,IF(OR($H$106=Data!$J$4,$H$106=Data!$J$5),Centre!$G$10/2,$H$106))","v":0},{"$f":"J103+1","v":"2024-09-30"},"Centre",null,{"$f":"IF($L$106=Data!$J$3,Centre!$C$10,IF(OR($L$106=Data!$J$4,$L$106=Data!$J$5),Centre!$C$10/2,$L$106))","v":0}]
[null,null,"Entreprise",null,{"$f":"IF(D107=Data!$J$3,Data!$L$3,IF(OR(D107=Data!$J$4,D107=Data!$J$5),Data!$L$3/2,D107))","v":0},null,"Entreprise",null,{"$f":"IF(H107=Data!$J$3,Data!$L$3,IF(OR(H107=Data!$J$4,H107=Data!$J$5),Data!$L$3/2,H107))","v":0},null,"Entreprise",null,{"$f":"IF(L107=Data!$J$3,Data!$L$3,IF(OR(L107=Data!$J$4,L107=Data!$J$5),Data!$L$3/2,L107))","v":0}]
[null,null,"Non payées",null,{"$f":"D108","v":0},null,"Non payées",null,{"$f":"H108","v":0},null,"Non payées",null,{"$f":"L108","v":0}]
[null,{"$f":"B106+1","v":"2024-07-31"},"Centre",null,{"$f":"IF($D$109=Data!$J$3,Centre!$E$10,IF(OR($D$109=Data!$J$4,$D$109=Data!$J$5),Centre!$E$10/2,$D$109))","v":0},{"$f":"F106+1","v":"2024-08-31"},"Centre"]
[null,null,"Entreprise",null,{"$f":"IF(D110=Data!$J$3,Data!$L$3,IF(OR(D110=Data!$J$4,D110=Data!$J$5),Data!$L$3/2,D110))","v":0},null,"Entreprise",null,{"$f":"IF(H110=Data!$J$3,Data!$L$3,IF(OR(H110=Data!$J$4,H110=Data!$J$5),Data!$L$3/2,H110))","v":0}]
[null,null,"Non payées",null,{"$f":"D111","v":0},null,"Non payées",null,{"$f":"H111","v":0}]
[null,"Total d'heures payées :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(C31:C111,\"Centre\",E31:E111)+SUMIF(G31:G111,\"Centre\",I31:I111)+SUMIF(K19:K111,\"Centre\",M19:M111)+SUMIF(C31:C111,\"Entreprise\",E31:E111)+SUMIF(G31:G111,\"Entreprise\",I31:I111)+SUMIF(K19:K111,\"Entreprise\",M19:M111)","v":0}]
[null,"Total d'heures non-payées :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(C31:C111,\"Non payées\",E31:E111)+SUMIF(G31:G111,\"Non payées\",I31:I111)+SUMIF(K19:K111,\"Non payées\",M19:M111)","v":0}]
[null,"Total d'heures valorisées :",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E31:E111)+SUM(I31:I111)+SUM(M19:M111)","v":0}]

{"sheet":"Data","index":2,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Trimestre",null,"Type jour fermeture",null,"Catégorie note de frais",null,null,null,"Période",null,"Durée jour entreprise",null,"Forfait",null,"Agrément","Nom"]
[null,"1e trimestre",null,"FROI",null,"Déplacement - Abonnement",null,null,null,"Journée",null,"08:00:00",null,0,null,11,"forma'Rive"]
[null,"2e trimestre",null,"JF",null,"Déplacement - Abonnement chevauchant",null,null,null,"Matin",null,null,null,2.67,null,18,"Centre de Réadaptation au Travail"]
[null,"3e trimestre",null,"VA",null,"Déplacement - Bus prix par ticket",null,null,null,"Après-midi",null,null,null,6.29,null,19,"Cerat"]
[null,"4e trimestre",null,null,null,"Déplacement - Train prix par ticket",null,null,null,null,null,null,null,null,null,23,"Prorienta"]
[null,null,null,null,null,"Déplacement - Voiture avec accord",null,null,null,null,"Indemnité",null,null,"Indemnité km",null,25,"Mosan"]
[null,"Oui/Non",null,"Type contrat",null,"Déplacement - Voiture sans accord",null,null,null,"Crèche",4,null,"Voiture",0.42649999999999999,null,26,"le Plope"]
[null,"Non",null,"Détermination",null,"Déplacement - Voiture tierce personne",null,null,null,"Garderie",2,null,"Vélo",0.35,null,27,"la Canopée"]
[null,"Oui",null,"Validation",null,"Déplacement - Vélo km parcourus",null,null,null,"Séjour",21.88,null,null,null,null,31,"le Tilleul"]
[null,null,null,"Formation qualifiante",null,"Déplacement - Autre: Prix",null,null,null,null,null,null,null,null,null,33,"AureLie"]
[null,null,null,"Avenant",null,"Séjour - Location mensuelle",null,null,null,null,null,null,null,null,null,35,"Polybat"]
[null,null,null,null,null,"Séjour - Location par nuit",null,null,null,null,null,null,null,null,null,38,"Camec"]
[null,null,null,null,null,"Pécule - Indemnisation",null,null,null,null,null,null,null,null,null,41,"Espace Formation Emploi"]
[null,null,null,null,null,"Crèche - Frais de crèche",null,null,null,null,null,null,null,null,null,48,"le Réseau"]
[null,null,null,null,null,"Garderie - Frais de garderie"]