{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["MOI"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"MOI","index":0,"n_rows":102,"n_cols":35,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,5,0,31],[2,0,2,4],[2,5,2,7],[2,8,2,9],[2,10,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,19],[2,23,2,32],[2,34,3,34],[50,10,50,11],[51,10,51,11],[71,1,71,2],[48,0,48,12],[48,13,48,24],[48,25,48,33]]}
[null,null,null,null,null,"COMMISSION  SUR  ENCAISSEMENTS  DE :  "]
[]
[{"$f":"TODAY()","v":"2021-04-26"},null,null,null,null,"ACOMPTE",null,null,"COM / AC",null,"SOLDE",null,null,"COM / S",null,"LEASING",null,"RÉCURRENTS  ANNUELS",null,null,"NE  PAS                                TOUCHER","DATE","NE  PAS  TOUCHER","RÉCURRENTS  MENSUELS",null,null,null,null,null,null,null,null,null,"NE  PAS          TOUCHER","CALCUL          après          correction          manuelle"]
["DATE          CONTRAT","AGENCE","DOSSIER",null,"SITE","MONTANT          TTC","MONTANT          HT","DATE","MONTANT ","DATE","MONTANT          TTC","MONTANT          HT","DATE","SOLDE          SITE","DATE","LEASING","PARFIP          DATE          ENC","DATE","TOTAL                         HT/AN                                  50%","TOTAL                         HT/AN                                 100%","CALCUL          des  50%","DÉMARRAGE          REC","CALCUL  de          l'ANCIENNETÉ","ANNOTATION","TOTAL          HT/MOIS","VV / WP / FORMATIONS /MAIL","SC / SVC","MOOVEO","HÉBERG.            LOC            SITE","RÉF.               NAT.","RÉF.                CLIC","HEKTOR","INTERKAB","CALCUL          des  100%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($U$6:U49)","v":1057.5},null,null,null,{"$f":"SUM($Y$6:Y49)","v":4097.5},null,null,null,null,null,null,null,null,{"$f":"SUM($AH$6:AH49)","v":206},{"$f":"SUM($AI$6:AI49)","v":206}]
[null,null,null,null,null,null,{"$f":"IF(F6=\"\",\"\",F6/1.2)","v":""},null,{"$f":"IF(H6=\"\",\"\",VLOOKUP(H6,$B$64:$C$70,2)*G6)","v":""},null,null,{"$f":"IF(K6=\"\",\"\",K6/1.2)","v":""},null,{"$f":"IF(M6=\"\",\"\",VLOOKUP(M6,$B$64:$C$70,2)*L6)","v":""},null,null,null,null,{"$f":"IF(R6=\"\",\"\",IF(R6<$A$3-365,T6/2,\"\"))","v":""},null,{"$f":"IF($V6=\"\",\"\",IF(Y6=\"\",0,IF($V6<$A$3-375,Y6/2,\"\")))","v":""},null,{"$f":"IF(V6=\"\",\"\",IF(V6>$A$3,\"\",DATEDIF(V6,$A$3,\"Y\")&IF(DATEDIF(V6,$A$3,\"Y\")>1,\" ans, \",\" an, \")&DATEDIF(V6,$A$3,\"YM\")&\" mois et \"&DATEDIF(V6,$A$3,\"MD\")&IF(DATEDIF(V6,$A$3,\"MD\")>1,\" jours\",\" jour\")))","v":""},null,{"$f":"IF(SUM(Z6:AG6)=0,\"\",SUM(Z6:AG6))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(V6=\"\",\"\",IF(V6>$A$3,\"\",IF(X6=\"ANNUEL\",0,IF(V6>$A$3-365,Y6,0))))","v":""},{"$f":"IF(AH6=\"\",\"\",AH6)","v":""}]
["2021-01-25","TOI",2563,"REPRISE",null,null,{"$f":"IF(F7=\"\",\"\",F7/1.2)","v":""},null,{"$f":"IF(H7=\"\",\"\",VLOOKUP(H7,$B$64:$C$70,2)*G7)","v":""},null,null,{"$f":"IF(K7=\"\",\"\",K7/1.2)","v":""},null,{"$f":"IF(M7=\"\",\"\",VLOOKUP(M7,$B$64:$C$70,2)*L7)","v":""},null,null,null,null,{"$f":"IF(R7=\"\",\"\",IF(R7<$A$3-365,T7/2,\"\"))","v":""},null,{"$f":"IF($V7=\"\",\"\",IF(Y7=\"\",0,IF($V7<$A$3-375,Y7/2,\"\")))","v":39.5},"2015-11-15",{"$f":"IF(V7=\"\",\"\",IF(V7>$A$3,\"\",DATEDIF(V7,$A$3,\"Y\")&IF(DATEDIF(V7,$A$3,\"Y\")>1,\" ans, \",\" an, \")&DATEDIF(V7,$A$3,\"YM\")&\" mois et \"&DATEDIF(V7,$A$3,\"MD\")&IF(DATEDIF(V7,$A$3,\"MD\")>1,\" jours\",\" jour\")))","v":"5 ans, 5 mois et 11 jours"},null,{"$f":"IF(SUM(Z7:AG7)=0,\"\",SUM(Z7:AG7))","v":79},null,null,null,null,null,null,79,null,{"$f":"IF(V7=\"\",\"\",IF(V7>$A$3,\"\",IF(X7=\"ANNUEL\",0,IF(V7>$A$3-365,Y7,0))))","v":0},0]
["2021-01-25","MOI",2563,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,45,"2017-04-15","4 ans, 0 mois et 11 jours",null,90,null,null,null,90,null,null,null,null,0,0]
["2021-01-25","LUI",8536,null,1200,720,600,"2021-02-22",39,"2021-02-01",720,600,"2021-03-10",39,"2021-03-01",null,null,null,"",null,"","2021-04-01","0 an, 0 mois et 25 jours",null,19,null,null,null,19,null,null,null,null,19,19]
["2021-01-31","NOUS",8570,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"","2021-05-01","",null,191,null,null,null,null,null,null,191,null,"",""]
["2021-02-01","VOUS",3456,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,44,"2019-06-01","1 an, 10 mois et 25 jours",null,88,null,null,null,null,null,null,88,null,0,0]
["2021-02-01","TOI",3456,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,29,"2019-06-01","1 an, 10 mois et 25 jours",null,58,null,29,null,29,null,null,null,null,0,0]
["2021-02-12","MOI",3838,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,39,"2017-03-01","4 ans, 1 mois et 25 jours",null,78,null,null,null,null,null,null,78,null,0,0]
["2021-02-12","LUI",3838,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,165.5,"2017-04-01","4 ans, 0 mois et 25 jours",null,331,null,null,null,112.5,218.5,null,null,null,0,0]
["2021-02-18","NOUS",8588,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"","2021-05-15","",null,149,null,null,null,null,null,null,149,null,"",""]
["2021-02-18","VOUS",8588,null,2200,1320,1100,"2021-02-18",71.5,"2021-02-01",null,"",null,"",null,null,null,null,"",null,"",null,"",null,19,null,null,null,19,null,null,null,null,"",""]
["2021-02-19","TOI",4564,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,85.75,"2017-12-01","3 ans, 4 mois et 25 jours",null,171.5,null,19,null,72.5,80,null,null,null,0,0]
["2021-02-19","MOI",4564,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,57,"2017-08-01","3 ans, 8 mois et 25 jours",null,114,null,null,null,null,null,null,114,null,0,0]
["2021-02-25","LUI",5603,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,62,"2018-07-01","2 ans, 9 mois et 25 jours",null,124,null,null,null,null,null,null,124,null,0,0]
["2021-02-25","NOUS",5603,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,56.25,"2020-04-01","1 an, 0 mois et 25 jours",null,112.5,null,null,null,112.5,null,null,null,null,0,0]
["2021-02-25","VOUS",5603,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"",null,"",null,188,39,null,null,10,139,null,null,null,"",""]
["2021-02-25","TOI",5603,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"","2022-03-01","",null,148,null,null,null,null,null,null,148,null,"",""]
["2021-02-28","MOI",4411,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,38.5,"2017-06-15","3 ans, 10 mois et 11 jours",null,77,null,null,null,null,null,null,77,null,0,0]
["2021-02-28","LUI",4411,null,null,331.2,276,null,"",null,null,"",null,"",null,null,null,null,"",null,12.5,"2017-06-15","3 ans, 10 mois et 11 jours","A SUPPRIMER A LA REFONTE",25,null,null,null,25,null,null,null,null,0,0]
["2021-02-28","NOUS",3455,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,44,"2016-04-01","5 ans, 0 mois et 25 jours",null,88,null,null,null,null,null,null,88,null,0,0]
["2021-02-28","VOUS",3455,null,2350,2820,2350,"2021-02-28",152.75,"2021-02-01",null,"",null,"",null,null,null,null,"",null,14.5,"2016-08-01","4 ans, 8 mois et 25 jours",null,29,null,null,null,29,null,null,null,null,0,0]
["2021-02-28","TOI",795,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,34.5,"2017-04-15","4 ans, 0 mois et 11 jours",null,69,null,null,null,null,null,null,69,null,0,0]
["2021-02-28","MOI",795,null,700,840,700,"2021-02-28",45.5,"2021-02-01",null,"",null,"",null,null,null,null,"",null,9.5,"2017-04-15","4 ans, 0 mois et 11 jours",null,19,null,null,null,19,null,null,null,null,0,0]
["2021-02-28","LUI",2656,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,44,"2017-01-15","4 ans, 3 mois et 11 jours",null,88,null,null,null,null,null,null,88,null,0,0]
["2021-02-28","NOUS",2656,null,2100,1260,1050,"2021-02-28",68.25,"2021-02-01",null,"",null,"",null,null,null,null,"",null,59.5,"2015-06-15","5 ans, 10 mois et 11 jours",null,119,null,null,null,29,90,null,null,null,0,0]
["2021-03-22","VOUS",4773,null,1750,1050,875,"2021-03-22",56.875,"2021-03-01",null,"",null,"",null,null,null,"2017-09-15",165,330,"",null,"",null,"",null,null,null,null,null,null,null,null,"",""]
["2021-03-22","TOI",8266,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"","2021-02-01","0 an, 2 mois et 25 jours","REF 118 AU 01/05/21",9,null,null,null,9,null,null,null,null,9,9]
["2021-03-22","MOI",8266,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"","2021-02-01","0 an, 2 mois et 25 jours",null,99,null,null,null,null,null,null,99,null,99,99]
["2021-03-25","LUI",4765,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,"2017-09-15",490,980,"","2020-08-15","0 an, 8 mois et 11 jours",null,79,79,null,null,null,null,null,null,null,79,79]
["2021-03-25","NOUS",4765,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"",null,"",null,132.5,null,null,null,132.5,null,null,null,null,"",""]
["2021-03-26","VOUS",754,"REPRISE",null,420,350,"2021-03-26",22.75,"2021-03-01",null,"",null,"",null,null,null,null,"",null,"","2021-07-15","",null,69,null,null,null,null,null,null,69,null,"",""]
["2021-03-26","TOI",754,null,3000,1800,1500,"2021-04-22",97.5,"2021-04-01",null,"",null,"",null,null,null,null,"",null,14.5,"2016-04-15","5 ans, 0 mois et 11 jours",null,29,null,null,null,29,null,null,null,null,0,0]
["2021-03-31","MOI",90778955,null,null,996,830,"2021-03-31",53.95,"2021-03-01",null,"",null,"",null,null,null,null,"",null,"",null,"","DEDUIRE 3 MOIS",165,null,null,null,165,null,null,null,null,"",""]
["2021-03-31","LUI",90778955,null,null,360,300,"2021-03-31",19.5,"2021-03-01",null,"",null,"",null,null,null,null,"",null,"","2022-07-01","",null,169,null,null,null,null,null,null,169,null,"",""]
["2021-04-01","NOUS",90420200,null,null,331.2,276,null,"",null,null,"",null,"",null,null,null,null,"",null,"",null,"",null,92,null,null,null,92,null,null,null,null,"",""]
["2021-04-14","VOUS",3149,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,44,"2015-11-15","5 ans, 5 mois et 11 jours",null,88,null,null,null,null,null,null,88,null,0,0]
["2021-04-14","TOI",3149,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"",null,"",null,92.5,null,null,null,92.5,null,null,null,null,"",""]
["2021-04-14","MOI",1724,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,80,"2018-01-15","3 ans, 3 mois et 11 jours",null,160,null,null,null,null,160,null,null,null,0,0]
["2021-04-14","LUI",1724,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"",null,"",null,94.5,null,null,null,94.5,null,null,null,null,"",""]
["2021-04-14","NOUS",1724,"REPRISE",null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,39,"2013-10-15","7 ans, 6 mois et 11 jours",null,78,null,null,null,null,null,null,78,null,0,0]
["2021-04-19","VOUS",90779043,null,null,null,"",null,"",null,null,"",null,"",null,null,null,null,"",null,"","2021-08-01","",null,99,null,null,null,null,null,null,99,null,"",""]
["2021-04-21","TOI",5366,null,null,604.79999999999995,504,null,"",null,null,"",null,"",null,null,null,null,"",null,"",null,"",null,168,5,null,null,163,null,null,null,null,"",""]
[null,null,null,null,null,null,{"$f":"IF(F48=\"\",\"\",F48/1.2)","v":""},null,{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,$B$64:$C$70,2)*G48)","v":""},null,null,{"$f":"IF(K48=\"\",\"\",K48/1.2)","v":""},null,{"$f":"IF(M48=\"\",\"\",VLOOKUP(M48,$B$64:$C$70,2)*L48)","v":""},null,null,null,null,{"$f":"IF(R48=\"\",\"\",IF(R48<$A$3-365,T48/2,\"\"))","v":""},null,{"$f":"IF($V48=\"\",\"\",IF(Y48=\"\",0,IF($V48<$A$3-375,Y48/2,\"\")))","v":""},null,{"$f":"IF(V48=\"\",\"\",IF(V48>$A$3,\"\",DATEDIF(V48,$A$3,\"Y\")&IF(DATEDIF(V48,$A$3,\"Y\")>1,\" ans, \",\" an, \")&DATEDIF(V48,$A$3,\"YM\")&\" mois et \"&DATEDIF(V48,$A$3,\"MD\")&IF(DATEDIF(V48,$A$3,\"MD\")>1,\" jours\",\" jour\")))","v":""},null,"",null,null,null,null,null,null,null,null,{"$f":"IF(V48=\"\",\"\",IF(V48>$A$3,\"\",IF(X48=\"ANNUEL\",0,IF(V48>$A$3-365,Y48,0))))","v":""},""]
["NE PAS MODIFIER, EFFACER OU SUPPRIMER CETTE DERNIÈRE LIGNE, C'EST ELLE QUI SERT DE REPÈRE POUR LA MACRO \" POUR ARCHIVER \"",null,null,null,null,null,null,null,null,null,null,null,null,"NE PAS MODIFIER, EFFACER OU SUPPRIMER CETTE DERNIÈRE LIGNE, C'EST ELLE QUI SERT DE REPÈRE POUR LA MACRO \" POUR ARCHIVER \"",null,null,null,null,null,null,null,null,null,null,null,"NE  PAS  MODIFIER,  EFFACER  OU  SUPPRIMER  CETTE  DERNIÈRE  LIGNE."]
[null,"DANY"]
[null,null,"SEULES  les  Cellules  Coloriées  en  VERT  sont  MODIFIABLES.",null,null,null,null,null,null,null,"POUR  ARCHIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH21:AH50)","v":187},{"$f":"IF(AH51=\"\",\"\",AH51)","v":187}]
[null,"RÉCAPITULATIF  DES  COMMISSIONS  VERSÉES :",null,null,null,null,null,null,null,null,"( ê CLIC  UNE  FOIS ê )"]
[null,"MARS 2021",null,{"$f":"I39+I38+I36+I31","v":153.07499999999999},null,"ACOMPTE"]
[null,null,null,{"$f":"IF($I$54=0,0,$I$54*$H$54)","v":68.737499999999997},null,"RÉCURRENTS 50",null,{"$f":"IF($C$64=\"\",\"\",VLOOKUP($A$3,$B$64:$C$70,2))","v":6.5000000000000002E-2},{"$f":"$U$5","v":1057.5}]
[null,null,null,{"$f":"IF($I$55=0,0,$I$55*$H$55)","v":13.39},null,"RÉCURRENTS 100",null,{"$f":"IF($C$64=\"\",\"\",VLOOKUP($A$3,$B$64:$C$70,2))","v":6.5000000000000002E-2},{"$f":"$AI$5","v":206}]
[null,null,null,{"$f":"N9","v":39},null,"SITES LIVRÉS ET PRESTATIONS ANNUELLES"]
[]
[null,null,null,{"$f":"IF($I$58=0,0,$I$58*$H$58)","v":0},null,"LEASING",null,{"$f":"IF($C$64=\"\",\"\",VLOOKUP($A$3,$B$64:$C$70,2))","v":6.5000000000000002E-2}]
[null,{"$f":"(\"TOTAL  \")&B53","v":"TOTAL  MARS 2021"},null,{"$f":"SUM(D53:D58)","v":274.20249999999999}]
[]
[null,"DATES  ET  POURCENTAGES  DES  COMMISSIONS  VERSÉES :"]
[]
[null,"DATES","%"]
[null,"2020-11-03",6.5000000000000002E-2]
[]
[]
[]
[]
[]
[]
[]
[null,"ê   ARCHIVAGE     ê"]
[]
[]
[null,"RÉCAPITULATIF  DES  COMMISSIONS  VERSÉES :"]
[null,"MARS 2021",null,153.07499999999999,null,"ACOMPTE"]
[null,null,null,68.737499999999997,null,"RÉCURRENTS 50",null,6.5000000000000002E-2,1057.5]
[null,null,null,13.39,null,"RÉCURRENTS 100",null,6.5000000000000002E-2,206]
[null,null,null,39,null,"SITES LIVRÉS ET PRESTATIONS ANNUELLES"]
[]
[null,null,null,0,null,"LEASING",null,6.5000000000000002E-2]
[null,"TOTAL  MARS 2021",null,274.20249999999999]
[]
[]
[null,"RÉCAPITULATIF  DES  COMMISSIONS  VERSÉES :"]
[null,"FEVRIER 2021",null,377,null,"ACOMPTE"]
[null,"6,5 DE 739,25 SOIT 48,05",null,0,null,"RÉCURRENTS 50",null,6.5000000000000002E-2,0]
[null,"6,5 DE 220,50 SOIT 14,33",null,7.0200000000000005,null,"RÉCURRENTS 100",null,6.5000000000000002E-2,108]
[null,null,null,0,null,"SITES LIVRÉS ET PRESTATIONS ANNUELLES"]
[]
[null,null,null,0,null,"LEASING",null,6.5000000000000002E-2]
[null,"TOTAL  FEVRIER 2021",null,384.02]
[]
[]
[null,"RÉCAPITULATIF  DES  COMMISSIONS  VERSÉES :"]
[null,"JANVIER 2021",null,null,null,"ACOMPTE"]
[null,null,null,9.2787500000000005,null,"RÉCURRENTS 50",null,6.5000000000000002E-2,142.75]
[null,null,null,0,null,"RÉCURRENTS 100",null,6.5000000000000002E-2,0]
[null,null,null,null,null,"SITES LIVRÉS ET PRESTATIONS ANNUELLES"]
[]
[null,null,null,0,null,"LEASING",null,6.5000000000000002E-2]
[null,"TOTAL  JANVIER 2021",null,9.2787500000000005]