{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Consolidé","Fichier Freelance","Calendrier","Janvier 21","Fevrier 21","Mars 21","Avril 21","Mai 21","Juin 21","Juillet 21","Aout 21","Septembre 21","Octobre 21","Novembre 21","Décembre 21"],"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":"Consolidé","index":0,"n_rows":35,"n_cols":28,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,26,1,27],[1,14,1,15],[1,16,1,17],[1,18,1,19],[1,20,1,21],[1,22,1,23],[1,24,1,25]]}
[]
[null,"Facturés /mois","2021-01-01",null,"2021-02-01",null,"2021-03-01",null,"2021-04-01",null,"2021-05-01",null,"2021-06-01",null,"2021-07-01",null,"2021-08-01",null,"2021-09-01",null,"2021-10-01",null,"2021-11-01",null,"2021-12-01",null,"Total"]
[null,null,"CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge","CA","Marge"]
[null,"Freelance",{"$f":"'Janvier 21'!$AE27","v":11600},{"$f":"'Janvier 21'!$AF27","v":1600},{"$f":"'Fevrier 21'!$AG27","v":0},{"$f":"'Fevrier 21'!$AH27","v":0},{"$f":"'Mars 21'!$AE27","v":0},{"$f":"'Mars 21'!$AF27","v":0},{"$f":"'Avril 21'!$AE27","v":0},{"$f":"'Avril 21'!$AF27","v":0},{"$f":"'Mai 21'!$AE27","v":0},{"$f":"'Mai 21'!$AF27","v":0},{"$f":"'Juin 21'!$AE27","v":0},{"$f":"'Juin 21'!$AF27","v":0},{"$f":"'Juillet 21'!$AE27","v":0},{"$f":"'Juillet 21'!$AF27","v":0},{"$f":"'Aout 21'!$AE27","v":0},{"$f":"'Aout 21'!$AF27","v":0},{"$f":"'Septembre 21'!$AE27","v":0},{"$f":"'Septembre 21'!$AF27","v":0},{"$f":"'Octobre 21'!$AE27","v":0},{"$f":"'Octobre 21'!$AF27","v":0},{"$f":"'Novembre 21'!$AE27","v":0},{"$f":"'Novembre 21'!$AF27","v":0},{"$f":"'Décembre 21'!$AE27","v":0},{"$f":"'Décembre 21'!$AF27","v":0},{"$f":"SUM(C4,E4,G4,I4,K4,M4,O4,Q4,,S4,U4,W4,Y4)","v":11600},{"$f":"SUM(D4,F4,H4,J4,L4,N4,P4,R4,,T4,V4,X4,Z4)","v":1600}]
[null,"RECRUTEMENT",{"$f":"'Janvier 21'!$R37+'Janvier 21'!$S37","v":9000},{"$f":"'Janvier 21'!$R37","v":7200},{"$f":"'Fevrier 21'!$T37+'Fevrier 21'!$U37","v":0},{"$f":"'Fevrier 21'!$U37","v":0},{"$f":"'Mars 21'!$R37+'Mars 21'!$S37","v":0},{"$f":"'Mars 21'!$S37","v":0},{"$f":"'Avril 21'!$R37+'Avril 21'!$S37","v":0},{"$f":"'Avril 21'!$S37","v":0},{"$f":"'Mai 21'!$R37+'Mai 21'!$S37","v":0},{"$f":"'Mai 21'!$S37","v":0},{"$f":"'Juin 21'!$R37+'Juin 21'!$S37","v":0},{"$f":"'Juin 21'!$S37","v":0},{"$f":"'Juillet 21'!$R37+'Juillet 21'!$S37","v":0},{"$f":"'Juillet 21'!$S37","v":0},{"$f":"'Aout 21'!$R37+'Aout 21'!$S37","v":0},{"$f":"'Aout 21'!$S37","v":0},{"$f":"'Septembre 21'!$R37+'Septembre 21'!$S37","v":0},{"$f":"'Septembre 21'!$S37","v":0},{"$f":"'Octobre 21'!$R37+'Octobre 21'!$S37","v":0},{"$f":"'Octobre 21'!$S37","v":0},{"$f":"'Novembre 21'!$R37+'Novembre 21'!$S37","v":0},{"$f":"'Novembre 21'!$S37","v":0},{"$f":"'Décembre 21'!$R37+'Décembre 21'!$S37","v":0},{"$f":"'Décembre 21'!$S37","v":0},{"$f":"SUM(C5,E5,G5,I5,K5,M5,O5,Q5,,S5,U5,W5,Y5)","v":9000},{"$f":"SUM(D5,F5,H5,J5,L5,N5,P5,R5,,T5,V5,X5,Z5)","v":7200}]
[null,"CUMULE",{"$f":"C4+C5","v":20600},8800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20600,8800]
[]
[]
[]
[]
[]
[null,null,"Prévisionnel","En cours"]
[null,"Freelance",null,{"$f":"AA4","v":11600}]
[null,"CA/an",{"$f":"SUM('Janvier 21'!S27,'Fevrier 21'!U27,'Mars 21'!S27,'Avril 21'!S27,'Mai 21'!S27,'Juin 21'!S27,'Juillet 21'!S27,'Aout 21'!S27,'Septembre 21'!S27,'Octobre 21'!S27,'Novembre 21'!S27,'Décembre 21'!S27)","v":11600},{"$f":"IF(B15<=15000,\"Oui\",\"\")","v":""},{"$f":"IF(C15>=15000,IF(C15<=30000,\"Oui\",\"\"),\"\")","v":""},{"$f":"IF(C15>=30000,IF(C15<=60000,\"Oui\",\"\"),\"\")","v":""},{"$f":"IF(C15>=60000,IF(C15<=90000,\"Oui\",\"\"),\"\")","v":""},{"$f":"IF(C15>=90000,IF(C15<=120000,\"Oui\",\"\"),\"\")","v":""}]
[null,"Marge Cumulée /an/brut",{"$f":"SUM('Janvier 21'!T27,'Fevrier 21'!V27,'Mars 21'!T27,'Avril 21'!T27,'Mai 21'!T27,'Juin 21'!T27,'Juillet 21'!T27,'Aout 21'!T27,'Septembre 21'!T27,'Octobre 21'!T27,'Novembre 21'!T27,'Décembre 21'!T27)","v":1600},"0/15000€","15K€/30K€","30K€/60K€","60K€/90K€","90K€/120K€"]
[null,"Part WOF",{"$f":"C15-C17","v":640},{"$f":"1-D17","v":0.4},{"$f":"1-E17","v":0.38},{"$f":"1-F17","v":0.35},{"$f":"1-G17","v":0.30000000000000004},{"$f":"1-H17","v":0.25}]
[null,"Part Sandrine",{"$f":"IF(C15<=15000,PRODUCT(C15,D17),IF(C15<=30000,PRODUCT(C15,E17),IF(C15<=60000,PRODUCT(C15,F17),IF(C15<=90000,PRODUCT(C15,G17),IF(C15<=120000,PRODUCT(C15,H17),)))))","v":960},0.6,0.62,0.65,0.7,0.75]
[null,"Charge ",{"$f":"C17-(PRODUCT(C17,D18))","v":739.2},0.23]
[null,"Revenu Net mensuel hors IR",{"$f":"C18/12","v":61.6}]
[]
[]
[null,"RECRUTEMENT"]
[null,null,"Sandrine","WOF"]
[null,"Marge Cumulée total placements",{"$f":"SUM('Janvier 21'!R37,'Fevrier 21'!T37,'Mars 21'!R37,'Avril 21'!S37,'Mai 21'!R37,'Juin 21'!R37,'Juillet 21'!R37,'Aout 21'!R37,'Septembre 21'!R37,'Octobre 21'!R37,'Novembre 21'!R37,'Décembre 21'!R37)","v":7200},{"$f":"SUM('Janvier 21'!S37,'Fevrier 21'!U37,'Mars 21'!S37,'Avril 21'!S37,'Mai 21'!S37,'Juin 21'!S37,'Juillet 21'!S37,'Aout 21'!S37,'Septembre 21'!S37,'Octobre 21'!S37,'Novembre 21'!S37,'Décembre 21'!S37)","v":1800}]
[]
[null,"Revenu Net",{"$f":"C24-(PRODUCT(C24,D26))","v":5544},0.23]
[null,"Revenu Net mensuel hors IR",{"$f":"C26/8","v":693}]
[]
[null,"CUMULE","Prévisionnel","En cours"]
[]
[null,"Marge cumulée",{"$f":"SUM(C15,C24)","v":8800},{"$f":"D6","v":8800}]
[null,"Part WOF Cumulée",{"$f":"SUM(C16,D24)","v":2440}]
[null,"Part Sandrine",{"$f":"C31-C32","v":6360}]
[null,"Revenu Net",{"$f":"C33-(PRODUCT(C33,D34))","v":4897.2},0.23]
[null,"Revenu Net mensuel hors IR",{"$f":"C34/12","v":408.09999999999997}]

{"sheet":"Fichier Freelance","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calendrier","index":2,"n_rows":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[[25,0,26,0],[1,0,2,0],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[18,0,19,0],[21,0,22,0],[23,0,24,0],[52,0,53,0],[27,0,28,0],[30,0,31,0],[32,0,33,0],[34,0,35,0],[36,0,37,0],[39,0,40,0],[41,0,42,0],[43,0,44,0],[45,0,46,0],[48,0,49,0],[50,0,51,0],[79,0,80,0],[54,0,55,0],[57,0,58,0],[59,0,60,0],[61,0,62,0],[63,0,64,0],[66,0,67,0],[68,0,69,0],[70,0,71,0],[72,0,73,0],[75,0,76,0],[77,0,78,0],[106,0,107,0],[81,0,82,0],[84,0,85,0],[86,0,87,0],[88,0,89,0],[90,0,91,0],[93,0,94,0],[95,0,96,0],[97,0,98,0],[99,0,100,0],[102,0,103,0],[104,0,105,0],[108,0,109,0],[111,0,112,0],[113,0,114,0],[115,0,116,0],[117,0,118,0]]}
["S53","Lun","Mar.","Mer.","Jeu.","Ven.","Sam.","Dim.",null,null,"Jours feries si ouvrés","Jours feries "]
[1,null,null,null,null,"2021-01-01","2021-01-02","2021-01-03",null,null,{"$f":"IF(F3=1,L2,\"\")","v":"2020-01-01"},"2020-01-01"]
[null,null,null,null,null,1,0,0,null,null,{"$f":"IF(G41=1,L3,0)","v":"00:00:00"},"2020-05-01"]
[{"$f":"SUM(A2,1)","v":2},{"$f":"H2+1","v":"2021-01-04"},{"$f":"B4+1","v":"2021-01-05"},"2021-01-06","2021-01-07","2021-01-08","2021-01-09","2021-01-10",null,null,{"$f":"IF(G43=1,L4,0)","v":"00:00:00"},"2020-05-08"]
[null,1,1,1,1,1,0,0,null,null,{"$f":"IF(D65=1,L5,\"\")","v":"2020-07-14"},"2020-07-14"]
[{"$f":"SUM(A4,1)","v":3},{"$f":"H4+1","v":"2021-01-11"},{"$f":"B6+1","v":"2021-01-12"},"2021-01-13","2021-01-14","2021-01-15","2021-01-16","2021-01-17",null,null,{"$f":"IF(H73=1,L6,0)","v":"00:00:00"},"2020-08-15"]
[null,1,1,1,1,1,0,0,null,null,{"$f":"IF(B101=1,L7,\"\")","v":"2020-11-01"},"2020-11-01"]
[{"$f":"SUM(A6,1)","v":4},{"$f":"H6+1","v":"2021-01-18"},{"$f":"B8+1","v":"2021-01-19"},"2021-01-20","2021-01-21","2021-01-22","2021-01-23","2021-01-24",null,null,{"$f":"IF(E104=1,L8,\"\")","v":"2020-11-11"},"2020-11-11"]
[null,1,1,1,1,1,0,0,null,null,{"$f":"IF(G117=1,L9,0)","v":"00:00:00"},"2020-12-25"]
[{"$f":"SUM(A8,1)","v":5},{"$f":"H8+1","v":"2021-01-25"},{"$f":"B10+1","v":"2021-01-26"},"2021-01-27","2021-01-28","2021-01-29","2021-01-30","2021-01-31"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A10,1)","v":6},{"$f":"H10+1","v":"2021-02-01"},{"$f":"B13+1","v":"2021-02-02"},"2021-02-03","2021-02-04","2021-02-05","2021-02-06","2021-02-07"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A13,1)","v":7},{"$f":"H13+1","v":"2021-02-08"},{"$f":"B15+1","v":"2021-02-09"},"2021-02-10","2021-02-11","2021-02-12","2021-02-13","2021-02-14"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A15,1)","v":8},{"$f":"H15+1","v":"2021-02-15"},{"$f":"B17+1","v":"2021-02-16"},"2021-02-17","2021-02-18","2021-02-19","2021-02-20","2021-02-21"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A17,1)","v":9},{"$f":"H17+1","v":"2021-02-22"},{"$f":"B19+1","v":"2021-02-23"},"2021-02-24","2021-02-25","2021-02-26","2021-02-27","2021-02-28"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A19,1)","v":10},{"$f":"H19+1","v":"2021-03-01"},{"$f":"B22+1","v":"2021-03-02"},"2021-03-03","2021-03-04","2021-03-05","2021-03-06","2021-03-07"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A22,1)","v":11},{"$f":"H22+1","v":"2021-03-08"},{"$f":"B24+1","v":"2021-03-09"},"2021-03-10","2021-03-11","2021-03-12","2021-03-13","2021-03-14"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A24,1)","v":12},{"$f":"H24+1","v":"2021-03-15"},{"$f":"B26+1","v":"2021-03-16"},"2021-03-17","2021-03-18","2021-03-19","2021-03-20","2021-03-21"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A26,1)","v":13},{"$f":"H26+1","v":"2021-03-22"},{"$f":"B28+1","v":"2021-03-23"},"2021-03-24","2021-03-25","2021-03-26","2021-03-27","2021-03-28"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A28,1)","v":14},{"$f":"H28+1","v":"2021-03-29"},{"$f":"B31+1","v":"2021-03-30"},"2021-03-31","2021-04-01","2021-04-02","2021-04-03","2021-04-04"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A31,1)","v":15},{"$f":"H31+1","v":"2021-04-05"},{"$f":"B33+1","v":"2021-04-06"},"2021-04-07","2021-04-08","2021-04-09","2021-04-10","2021-04-11"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A33,1)","v":16},{"$f":"H33+1","v":"2021-04-12"},{"$f":"B35+1","v":"2021-04-13"},"2021-04-14","2021-04-15","2021-04-16","2021-04-17","2021-04-18"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A35,1)","v":17},{"$f":"H35+1","v":"2021-04-19"},{"$f":"B37+1","v":"2021-04-20"},"2021-04-21","2021-04-22","2021-04-23","2021-04-24","2021-04-25"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A37,1)","v":18},{"$f":"H37+1","v":"2021-04-26"},{"$f":"B40+1","v":"2021-04-27"},"2021-04-28","2021-04-29","2021-04-30","2021-05-01","2021-05-02"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A40,1)","v":19},{"$f":"H40+1","v":"2021-05-03"},{"$f":"B42+1","v":"2021-05-04"},"2021-05-05","2021-05-06","2021-05-07","2021-05-08","2021-05-09"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A42,1)","v":20},{"$f":"H42+1","v":"2021-05-10"},{"$f":"B44+1","v":"2021-05-11"},"2021-05-12","2021-05-13","2021-05-14","2021-05-15","2021-05-16"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A44,1)","v":21},{"$f":"H44+1","v":"2021-05-17"},{"$f":"B46+1","v":"2021-05-18"},"2021-05-19","2021-05-20","2021-05-21","2021-05-22","2021-05-23"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A46,1)","v":22},{"$f":"H46+1","v":"2021-05-24"},{"$f":"B49+1","v":"2021-05-25"},"2021-05-26","2021-05-27","2021-05-28","2021-05-29","2021-05-30"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A49,1)","v":23},{"$f":"H49+1","v":"2021-05-31"},{"$f":"B51+1","v":"2021-06-01"},"2021-06-02","2021-06-03","2021-06-04","2021-06-05","2021-06-06"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A51,1)","v":24},{"$f":"H51+1","v":"2021-06-07"},{"$f":"B53+1","v":"2021-06-08"},"2021-06-09","2021-06-10","2021-06-11","2021-06-12","2021-06-13"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A53,1)","v":25},{"$f":"H53+1","v":"2021-06-14"},{"$f":"B55+1","v":"2021-06-15"},"2021-06-16","2021-06-17","2021-06-18","2021-06-19","2021-06-20"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A55,1)","v":26},{"$f":"H55+1","v":"2021-06-21"},{"$f":"B58+1","v":"2021-06-22"},"2021-06-23","2021-06-24","2021-06-25","2021-06-26","2021-06-27"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A58,1)","v":27},{"$f":"H58+1","v":"2021-06-28"},{"$f":"B60+1","v":"2021-06-29"},"2021-06-30","2021-07-01","2021-07-02","2021-07-03","2021-07-04"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A60,1)","v":28},{"$f":"H60+1","v":"2021-07-05"},{"$f":"B62+1","v":"2021-07-06"},"2021-07-07","2021-07-08","2021-07-09","2021-07-10","2021-07-11"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A62,1)","v":29},{"$f":"H62+1","v":"2021-07-12"},{"$f":"B64+1","v":"2021-07-13"},"2021-07-14","2021-07-15","2021-07-16","2021-07-17","2021-07-18"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A64,1)","v":30},{"$f":"H64+1","v":"2021-07-19"},{"$f":"B67+1","v":"2021-07-20"},"2021-07-21","2021-07-22","2021-07-23","2021-07-24","2021-07-25"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A67,1)","v":31},{"$f":"H67+1","v":"2021-07-26"},{"$f":"B69+1","v":"2021-07-27"},"2021-07-28","2021-07-29","2021-07-30","2021-07-31","2021-08-01"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A69,1)","v":32},{"$f":"H69+1","v":"2021-08-02"},{"$f":"B71+1","v":"2021-08-03"},"2021-08-04","2021-08-05","2021-08-06","2021-08-07","2021-08-08"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A71,1)","v":33},{"$f":"H71+1","v":"2021-08-09"},{"$f":"B73+1","v":"2021-08-10"},"2021-08-11","2021-08-12","2021-08-13","2021-08-14","2021-08-15"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A73,1)","v":34},{"$f":"H73+1","v":"2021-08-16"},{"$f":"B76+1","v":"2021-08-17"},"2021-08-18","2021-08-19","2021-08-20","2021-08-21","2021-08-22"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A76,1)","v":35},{"$f":"H76+1","v":"2021-08-23"},{"$f":"B78+1","v":"2021-08-24"},"2021-08-25","2021-08-26","2021-08-27","2021-08-28","2021-08-29"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A78,1)","v":36},{"$f":"H78+1","v":"2021-08-30"},{"$f":"B80+1","v":"2021-08-31"},"2021-09-01","2021-09-02","2021-09-03","2021-09-04","2021-09-05"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A80,1)","v":37},{"$f":"H80+1","v":"2021-09-06"},{"$f":"B82+1","v":"2021-09-07"},"2021-09-08","2021-09-09","2021-09-10","2021-09-11","2021-09-12"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A82,1)","v":38},{"$f":"H82+1","v":"2021-09-13"},{"$f":"B85+1","v":"2021-09-14"},"2021-09-15","2021-09-16","2021-09-17","2021-09-18","2021-09-19"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A85,1)","v":39},{"$f":"H85+1","v":"2021-09-20"},{"$f":"B87+1","v":"2021-09-21"},"2021-09-22","2021-09-23","2021-09-24","2021-09-25","2021-09-26"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A87,1)","v":40},{"$f":"H87+1","v":"2021-09-27"},{"$f":"B89+1","v":"2021-09-28"},"2021-09-29","2021-09-30","2021-10-01","2021-10-02","2021-10-03"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A89,1)","v":41},{"$f":"H89+1","v":"2021-10-04"},{"$f":"B91+1","v":"2021-10-05"},"2021-10-06","2021-10-07","2021-10-08","2021-10-09","2021-10-10"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A91,1)","v":42},{"$f":"H91+1","v":"2021-10-11"},{"$f":"B94+1","v":"2021-10-12"},"2021-10-13","2021-10-14","2021-10-15","2021-10-16","2021-10-17"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A94,1)","v":43},{"$f":"H94+1","v":"2021-10-18"},{"$f":"B96+1","v":"2021-10-19"},"2021-10-20","2021-10-21","2021-10-22","2021-10-23","2021-10-24"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A96,1)","v":44},{"$f":"H96+1","v":"2021-10-25"},{"$f":"B98+1","v":"2021-10-26"},"2021-10-27","2021-10-28","2021-10-29","2021-10-30","2021-10-31"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A98,1)","v":45},{"$f":"H98+1","v":"2021-11-01"},{"$f":"B100+1","v":"2021-11-02"},"2021-11-03","2021-11-04","2021-11-05","2021-11-06","2021-11-07"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A100,1)","v":46},{"$f":"H100+1","v":"2021-11-08"},{"$f":"B103+1","v":"2021-11-09"},"2021-11-10","2021-11-11","2021-11-12","2021-11-13","2021-11-14"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A103,1)","v":47},{"$f":"H103+1","v":"2021-11-15"},{"$f":"B105+1","v":"2021-11-16"},"2021-11-17","2021-11-18","2021-11-19","2021-11-20","2021-11-21"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A105,1)","v":48},{"$f":"H105+1","v":"2021-11-22"},{"$f":"B107+1","v":"2021-11-23"},"2021-11-24","2021-11-25","2021-11-26","2021-11-27","2021-11-28"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A107,1)","v":49},{"$f":"H107+1","v":"2021-11-29"},{"$f":"B109+1","v":"2021-11-30"},"2021-12-01","2021-12-02","2021-12-03","2021-12-04","2021-12-05"]
[null,1,1,1,1,1,0,0]
[]
[{"$f":"SUM(A109,1)","v":50},{"$f":"H109+1","v":"2021-12-06"},{"$f":"B112+1","v":"2021-12-07"},"2021-12-08","2021-12-09","2021-12-10","2021-12-11","2021-12-12"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A112,1)","v":51},{"$f":"H112+1","v":"2021-12-13"},{"$f":"B114+1","v":"2021-12-14"},"2021-12-15","2021-12-16","2021-12-17","2021-12-18","2021-12-19"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A114,1)","v":52},{"$f":"H114+1","v":"2021-12-20"},{"$f":"B116+1","v":"2021-12-21"},"2021-12-22","2021-12-23","2021-12-24","2021-12-25","2021-12-26"]
[null,1,1,1,1,1,0,0]
[{"$f":"SUM(A116,1)","v":53},{"$f":"H116+1","v":"2021-12-27"},{"$f":"B118+1","v":"2021-12-28"},"2021-12-29","2021-12-30","2021-12-31","2022-01-01","2022-01-02"]
[null,1,1,1,1,1,0,0]

{"sheet":"Janvier 21","index":3,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,5,35,6],[30,0,30,31],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!F2","v":"2021-01-01"},{"$f":"Calendrier!H10","v":"2021-01-31"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
["test","Thierry",6,"PORTAGE","OK","A faire","En attente","OK",20,500,500,580,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":0.15999999999999992},null,{"$f":"L8-N8","v":580},1,null,{"$f":"PRODUCT(I8,P8)","v":20},{"$f":"PRODUCT(O8,R8)","v":11600},{"$f":"PRODUCT(R8,(L8-J8))","v":1600},"2021-01-01",{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":"2021-01-28"},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":20},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":0},20,{"$f":"PRODUCT(O8,AD8)","v":11600},{"$f":"PRODUCT(O8-K8,AD8)","v":1600}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":11600},{"$f":"SUM(T8:T26)","v":1600},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":11600},{"$f":"SUM(AF8:AF26)","v":1600}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,45000,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":3600},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":900}]
[null,null,null,null,null,"Non",null,null,null,null,null,null,45000,0.1,50,20,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":3600},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":7200},{"$f":"SUM(S33:S36)","v":1800}]

{"sheet":"Fevrier 21","index":4,"n_rows":37,"n_cols":34,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,7,34,8],[35,7,35,8],[31,7,31,8],[0,2,0,31],[30,2,30,33],[32,7,32,8],[33,7,33,8],[0,32,0,33],[4,2,4,33],[5,2,5,11],[5,13,5,18],[5,19,5,23],[5,24,5,27],[5,28,5,33]]}
[null,null,{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!B13","v":"2021-02-01"},{"$f":"Calendrier!H19","v":"2021-02-28"}]
[]
[]
[null,null,"Free-lance "]
[null,null,"COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["Jours restants",null,"NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[{"$f":"'Janvier 21'!AC8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L8=\"\",\"\",(N8/L8)-1)","v":""},null,{"$f":"N8-P8","v":0},null,null,{"$f":"PRODUCT(K8,R8)","v":0},{"$f":"PRODUCT(Q8,T8)","v":0},{"$f":"PRODUCT(T8,(N8-L8))","v":0},null,{"$f":"IF(W8=\"\",\"\",WORKDAY(W8-1,T8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W8=\"\",\"\",IF(X8<=X2,NETWORKDAYS(W8,X8,Calendrier!K2:K9),NETWORKDAYS(W8,X2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AD8=\"\",\"\",T8-AD8)","v":""},null,{"$f":"PRODUCT(Q8,AF8)","v":0},{"$f":"PRODUCT(O8,AG8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L9=\"\",\"\",(N9/L9)-1)","v":""},null,{"$f":"N9-P9","v":0},null,null,{"$f":"PRODUCT(K9,R9)","v":0},{"$f":"PRODUCT(Q9,T9)","v":0},{"$f":"PRODUCT(T9,(N9-L9))","v":0},null,{"$f":"IF(W9=\"\",\"\",WORKDAY(W9-1,T9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W9=\"\",\"\",IF(X9<=$X2,NETWORKDAYS(W9,X9,Calendrier!K3:K10),NETWORKDAYS(W9,$X2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AD9=\"\",\"\",T9-AD9)","v":""},null,{"$f":"PRODUCT(Q9,AF9)","v":0},{"$f":"PRODUCT(O9,AG9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L10=\"\",\"\",(N10/L10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(Q10,T10)","v":0},0,null,{"$f":"IF(W10=\"\",\"\",WORKDAY(W10-1,T10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W10=\"\",\"\",IF(X10<=$X2,NETWORKDAYS(W10,X10,Calendrier!K4:K11),NETWORKDAYS(W10,$X2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W11=\"\",\"\",WORKDAY(W11-1,T11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W11=\"\",\"\",IF(X11<=$X2,NETWORKDAYS(W11,X11,Calendrier!K5:K12),NETWORKDAYS(W11,$X2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W12=\"\",\"\",WORKDAY(W12-1,T12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W12=\"\",\"\",IF(X12<=$X2,NETWORKDAYS(W12,X12,Calendrier!K6:K13),NETWORKDAYS(W12,$X2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W13=\"\",\"\",WORKDAY(W13-1,T13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W13=\"\",\"\",IF(X13<=$X2,NETWORKDAYS(W13,X13,Calendrier!K7:K14),NETWORKDAYS(W13,$X2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W14=\"\",\"\",WORKDAY(W14-1,T14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W14=\"\",\"\",IF(X14<=$X2,NETWORKDAYS(W14,X14,Calendrier!K8:K15),NETWORKDAYS(W14,$X2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(K15,R15)","v":0},0,0,null,{"$f":"IF(W15=\"\",\"\",WORKDAY(W15-1,T15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W15=\"\",\"\",IF(X15<=$X2,NETWORKDAYS(W15,X15,Calendrier!K9:K16),NETWORKDAYS(W15,$X2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W16=\"\",\"\",WORKDAY(W16-1,T16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W16=\"\",\"\",IF(X16<=$X2,NETWORKDAYS(W16,X16,Calendrier!K10:K17),NETWORKDAYS(W16,$X2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W17=\"\",\"\",WORKDAY(W17-1,T17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W17=\"\",\"\",IF(X17<=$X2,NETWORKDAYS(W17,X17,Calendrier!K11:K18),NETWORKDAYS(W17,$X2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W18=\"\",\"\",WORKDAY(W18-1,T18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W18=\"\",\"\",IF(X18<=$X2,NETWORKDAYS(W18,X18,Calendrier!K12:K19),NETWORKDAYS(W18,$X2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W19=\"\",\"\",WORKDAY(W19-1,T19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W19=\"\",\"\",IF(X19<=$X2,NETWORKDAYS(W19,X19,Calendrier!K13:K20),NETWORKDAYS(W19,$X2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W20=\"\",\"\",WORKDAY(W20-1,T20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W20=\"\",\"\",IF(X20<=$X2,NETWORKDAYS(W20,X20,Calendrier!K14:K21),NETWORKDAYS(W20,$X2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W21=\"\",\"\",WORKDAY(W21-1,T21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W21=\"\",\"\",IF(X21<=$X2,NETWORKDAYS(W21,X21,Calendrier!K15:K22),NETWORKDAYS(W21,$X2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W22=\"\",\"\",WORKDAY(W22-1,T22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W22=\"\",\"\",IF(X22<=$X2,NETWORKDAYS(W22,X22,Calendrier!K16:K23),NETWORKDAYS(W22,$X2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W23=\"\",\"\",WORKDAY(W23-1,T23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W23=\"\",\"\",IF(X23<=$X2,NETWORKDAYS(W23,X23,Calendrier!K17:K24),NETWORKDAYS(W23,$X2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W24=\"\",\"\",WORKDAY(W24-1,T24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W24=\"\",\"\",IF(X24<=$X2,NETWORKDAYS(W24,X24,Calendrier!K18:K25),NETWORKDAYS(W24,$X2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W25=\"\",\"\",WORKDAY(W25-1,T25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W25=\"\",\"\",IF(X25<=$X2,NETWORKDAYS(W25,X25,Calendrier!K19:K26),NETWORKDAYS(W25,$X2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(W26=\"\",\"\",WORKDAY(W26-1,T26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(W26=\"\",\"\",IF(X26<=$X2,NETWORKDAYS(W26,X26,Calendrier!K20:K27),NETWORKDAYS(W26,$X2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U8:U26)","v":0},{"$f":"SUM(V8:V26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG8:AG26)","v":0},{"$f":"SUM(AH8:AH26)","v":0}]
[]
[]
[]
[null,null,"Recrutement"]
[null,null,"Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(H33=\"Oui\",O33*P33/2,((O33*P33)/100)*(100-R33))","v":0},{"$f":"IF(H33=\"Oui\",((O33*P33)/100)*Q33,((O33*P33)/100)*R33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H34=\"Oui\",O34*P34/2,((O34*P34)/100)*(100-R34))","v":0},{"$f":"IF(H34=\"Oui\",((O34*P34)/100)*Q34,((O34*P34)/100)*R34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H35=\"Oui\",O35*P35/2,((O35*P35)/100)*(100-R35))","v":0},{"$f":"IF(H35=\"Oui\",((O35*P35)/100)*Q35,((O35*P35)/100)*R35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H36=\"Oui\",O36*P36/2,((O36*P36)/100)*(100-R36))","v":0},{"$f":"IF(H36=\"Oui\",((O36*P36)/100)*Q36,((O36*P36)/100)*R36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(T33:T36)","v":0},{"$f":"SUM(U33:U36)","v":0}]

{"sheet":"Mars 21","index":5,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!B22","v":"2021-03-01"},{"$f":"Calendrier!D31","v":"2021-03-31"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Avril 21","index":6,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,5,35,6],[5,22,5,25],[34,5,34,6],[0,0,0,29],[5,0,5,9],[5,17,5,21],[5,11,5,16],[33,5,33,6],[5,26,5,31],[0,30,0,31],[4,0,4,31],[30,0,30,31],[31,5,31,6],[32,5,32,6]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!E31","v":"2021-04-01"},{"$f":"Calendrier!F40","v":"2021-04-30"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Oui",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Mai 21","index":7,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!G40","v":"2021-05-01"},{"$f":"Calendrier!B51","v":"2021-05-31"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Juin 21","index":8,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!C51","v":"2021-06-01"},{"$f":"Calendrier!D60","v":"2021-06-30"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Juillet 21","index":9,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!E60","v":"2021-07-01"},{"$f":"Calendrier!G69","v":"2021-07-31"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Aout 21","index":10,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!H69","v":"2021-08-01"},{"$f":"Calendrier!C80","v":"2021-08-31"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Septembre 21","index":11,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!D80","v":"2021-09-01"},{"$f":"Calendrier!E89","v":"2021-09-30"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Octobre 21","index":12,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!F89","v":"2021-10-01"},{"$f":"Calendrier!H98","v":"2021-10-31"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Novembre 21","index":13,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!B100","v":"2021-11-01"},{"$f":"Calendrier!C109","v":"2021-11-30"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]

{"sheet":"Décembre 21","index":14,"n_rows":37,"n_cols":32,"rows_kept":37,"cut":false,"hidden":false,"merged":[[30,0,30,31],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[31,5,31,6],[0,30,0,31],[4,0,4,31],[5,0,5,9],[5,11,5,16],[5,17,5,21],[5,22,5,25],[5,26,5,31],[0,0,0,29]]}
[{"$f":"nomfeuille()","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,"OK","A faire","En attente",null,null,"PORTAGE",null,"EIRL","SARL","SASU","Micro",null,"RCO","Rclient","Oui","Non",{"$f":"Calendrier!D109","v":"2021-12-01"},{"$f":"Calendrier!F118","v":"2021-12-31"}]
[]
[]
["Free-lance "]
["COLLABORATEUR",null,null,null,null,null,null,null,null,null,null,"NEGOCIATION",null,null,null,null,null,"CONTRAT ",null,null,null,null,"CLIENT",null,null,null,"TIME SHEET"]
["NOM","Prénom","CONTACT","Statut","ID","RIB","K-BIS","ASS-PRO","Nb de jours","TJM achat","TJM contrat","TJM vente","Marge","Effort ","TJM Apres effort","Durée contrat","Facture","Nb Jours/contrat","CA total","Marge Contrat","Debut de contrat","Fin de contrat","CONTACT","FONCTION","TELEPHONE","MAIL","Time sheet","Nb jours prévus","Nb jours restants contrat",{"$f":"_xlfn.CONCAT(\"Nb jours/  \",nomfeuille(),\" / Facturés\")","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre / \",nomfeuille())","v":{"$error":"#NAME?"}},{"$f":"_xlfn.CONCAT(\"Chiffre Marge / \",nomfeuille())","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J8=\"\",\"\",(L8/J8)-1)","v":""},null,{"$f":"L8-N8","v":0},null,null,{"$f":"PRODUCT(I8,P8)","v":0},{"$f":"PRODUCT(O8,R8)","v":0},{"$f":"PRODUCT(R8,(L8-J8))","v":0},null,{"$f":"IF(U8=\"\",\"\",WORKDAY(U8-1,R8,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",IF(V8<=V2,NETWORKDAYS(U8,V8,Calendrier!K2:K9),NETWORKDAYS(U8,V2,Calendrier!K2:K9)))","v":""},{"$f":"IF(AB8=\"\",\"\",R8-AB8)","v":""},null,{"$f":"PRODUCT(O8,AD8)","v":0},{"$f":"PRODUCT(M8,AE8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(L9/J9)-1)","v":""},null,{"$f":"L9-N9","v":0},null,null,{"$f":"PRODUCT(I9,P9)","v":0},{"$f":"PRODUCT(O9,R9)","v":0},{"$f":"PRODUCT(R9,(L9-J9))","v":0},null,{"$f":"IF(U9=\"\",\"\",WORKDAY(U9-1,R9,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",IF(V9<=$V2,NETWORKDAYS(U9,V9,Calendrier!K3:K10),NETWORKDAYS(U9,$V2,Calendrier!K3:K10)))","v":""},{"$f":"IF(AB9=\"\",\"\",R9-AB9)","v":""},null,{"$f":"PRODUCT(O9,AD9)","v":0},{"$f":"PRODUCT(M9,AE9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J10=\"\",\"\",(L10/J10)-1)","v":""},null,0,null,null,0,{"$f":"PRODUCT(O10,R10)","v":0},0,null,{"$f":"IF(U10=\"\",\"\",WORKDAY(U10-1,R10,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U10=\"\",\"\",IF(V10<=$V2,NETWORKDAYS(U10,V10,Calendrier!K4:K11),NETWORKDAYS(U10,$V2,Calendrier!K4:K11)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U11=\"\",\"\",WORKDAY(U11-1,R11,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U11=\"\",\"\",IF(V11<=$V2,NETWORKDAYS(U11,V11,Calendrier!K5:K12),NETWORKDAYS(U11,$V2,Calendrier!K5:K12)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U12=\"\",\"\",WORKDAY(U12-1,R12,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U12=\"\",\"\",IF(V12<=$V2,NETWORKDAYS(U12,V12,Calendrier!K6:K13),NETWORKDAYS(U12,$V2,Calendrier!K6:K13)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U13=\"\",\"\",WORKDAY(U13-1,R13,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U13=\"\",\"\",IF(V13<=$V2,NETWORKDAYS(U13,V13,Calendrier!K7:K14),NETWORKDAYS(U13,$V2,Calendrier!K7:K14)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U14=\"\",\"\",WORKDAY(U14-1,R14,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U14=\"\",\"\",IF(V14<=$V2,NETWORKDAYS(U14,V14,Calendrier!K8:K15),NETWORKDAYS(U14,$V2,Calendrier!K8:K15)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,{"$f":"PRODUCT(I15,P15)","v":0},0,0,null,{"$f":"IF(U15=\"\",\"\",WORKDAY(U15-1,R15,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U15=\"\",\"\",IF(V15<=$V2,NETWORKDAYS(U15,V15,Calendrier!K9:K16),NETWORKDAYS(U15,$V2,Calendrier!K9:K16)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U16=\"\",\"\",WORKDAY(U16-1,R16,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U16=\"\",\"\",IF(V16<=$V2,NETWORKDAYS(U16,V16,Calendrier!K10:K17),NETWORKDAYS(U16,$V2,Calendrier!K10:K17)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U17=\"\",\"\",WORKDAY(U17-1,R17,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U17=\"\",\"\",IF(V17<=$V2,NETWORKDAYS(U17,V17,Calendrier!K11:K18),NETWORKDAYS(U17,$V2,Calendrier!K11:K18)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U18=\"\",\"\",WORKDAY(U18-1,R18,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U18=\"\",\"\",IF(V18<=$V2,NETWORKDAYS(U18,V18,Calendrier!K12:K19),NETWORKDAYS(U18,$V2,Calendrier!K12:K19)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U19=\"\",\"\",WORKDAY(U19-1,R19,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U19=\"\",\"\",IF(V19<=$V2,NETWORKDAYS(U19,V19,Calendrier!K13:K20),NETWORKDAYS(U19,$V2,Calendrier!K13:K20)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U20=\"\",\"\",WORKDAY(U20-1,R20,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U20=\"\",\"\",IF(V20<=$V2,NETWORKDAYS(U20,V20,Calendrier!K14:K21),NETWORKDAYS(U20,$V2,Calendrier!K14:K21)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U21=\"\",\"\",WORKDAY(U21-1,R21,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U21=\"\",\"\",IF(V21<=$V2,NETWORKDAYS(U21,V21,Calendrier!K15:K22),NETWORKDAYS(U21,$V2,Calendrier!K15:K22)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U22=\"\",\"\",WORKDAY(U22-1,R22,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U22=\"\",\"\",IF(V22<=$V2,NETWORKDAYS(U22,V22,Calendrier!K16:K23),NETWORKDAYS(U22,$V2,Calendrier!K16:K23)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U23=\"\",\"\",WORKDAY(U23-1,R23,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U23=\"\",\"\",IF(V23<=$V2,NETWORKDAYS(U23,V23,Calendrier!K17:K24),NETWORKDAYS(U23,$V2,Calendrier!K17:K24)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U24=\"\",\"\",WORKDAY(U24-1,R24,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U24=\"\",\"\",IF(V24<=$V2,NETWORKDAYS(U24,V24,Calendrier!K18:K25),NETWORKDAYS(U24,$V2,Calendrier!K18:K25)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U25=\"\",\"\",WORKDAY(U25-1,R25,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U25=\"\",\"\",IF(V25<=$V2,NETWORKDAYS(U25,V25,Calendrier!K19:K26),NETWORKDAYS(U25,$V2,Calendrier!K19:K26)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,null,null,0,0,0,null,{"$f":"IF(U26=\"\",\"\",WORKDAY(U26-1,R26,Calendrier!K2:K7))","v":""},null,null,null,null,null,{"$f":"IF(U26=\"\",\"\",IF(V26<=$V2,NETWORKDAYS(U26,V26,Calendrier!K20:K27),NETWORKDAYS(U26,$V2,Calendrier!K20:K27)))","v":""},"",null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S26)","v":0},{"$f":"SUM(T8:T26)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE8:AE26)","v":0},{"$f":"SUM(AF8:AF26)","v":0}]
[]
[]
[]
["Recrutement"]
["Nom","Prénom","Contact",null,null,"Apport WOF",null,null,"Préavis","Salaire actuel",null,"Prétentions","Salaire embauche","% honoraires","% WOF Oui","% WOF Non","Démarrage","Marge sur vente Sand","Part WOF"]
[null,null,null,null,null,"Non",null,null,null,null,null,null,null,0.1,50,20,null,{"$f":"IF(F33=\"Oui\",M33*N33/2,((M33*N33)/100)*(100-P33))","v":0},{"$f":"IF(F33=\"Oui\",((M33*N33)/100)*O33,((M33*N33)/100)*P33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"Oui\",M34*N34/2,((M34*N34)/100)*(100-P34))","v":0},{"$f":"IF(F34=\"Oui\",((M34*N34)/100)*O34,((M34*N34)/100)*P34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"Oui\",M35*N35/2,((M35*N35)/100)*(100-P35))","v":0},{"$f":"IF(F35=\"Oui\",((M35*N35)/100)*O35,((M35*N35)/100)*P35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F36=\"Oui\",M36*N36/2,((M36*N36)/100)*(100-P36))","v":0},{"$f":"IF(F36=\"Oui\",((M36*N36)/100)*O36,((M36*N36)/100)*P36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0}]