{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Contrôle 5.1.5","a_EditionConcentree 5.1.5","Contrôle 300092026","Contrôle 20082026"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"Contrôle 5.1.5","index":0,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[29,10,31,10],[45,10,48,10]]}
[]
[null,"[...]","Référence à la colonne du fichier"]
[null,"Saisir","Informations à saisir prise dans l'extraction du PCA-PAR Edition concentrée"]
[]
[null,null,null,"Date du PCA-PAR","[BZ]","2026-06-30"]
[]
[null,null,null," ","Référence",null,null,"Référence"]
[null,null,null,"Partie forfait"]
[]
[null,null,null,"Du","[AI]","2026-06-30","Terme","[N]","A échoir"]
[null,null,null,"Au","[AJ]","2026-08-20","Nbre de copies du forfait","[W]",3000]
[null,null,null,null,null,null,"Prorata temporis","[AN]",0.56520000000000004]
[null,null,null,"Date proch. Fact.","[AH] ","2026-08-21"]
[null,null,null,"Périodicité","[J]",3]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,"Début période précédente",null,{"$f":"EDATE(F19,-F14)","v":"2026-05-21"},"Nbre de jours période Précédente",null,{"$f":"F19-F16+J16","v":92},0]
[null,null,null,{"$f":"IF(AND(F5>F16,F5<F19),\"Date calcul ici\",\"\")","v":"Date calcul ici"},null,{"$f":"IF(D17<>\"\",F5,\"\")","v":"2026-06-30"},{"$f":"IF(D17<>\"\",\"Nbre de jours\",\"\")","v":"Nbre de jours"},null,{"$f":"IF(D17<>\"\",F19-F17+J17,)","v":52},0]
[null,null,null,"Fin de la période",null,{"$f":"F19-1","v":"2026-08-20"}]
[null,null,null,"Début prochaine période",null,{"$f":"IF(I10=\"A échoir\",F13,EOMONTH(F21,-F14)+1)","v":"2026-08-21"},"Nbre de jours prochaine période",null,{"$f":"F21-F19+J19","v":92},1]
[null,null,null,{"$f":"IF(AND(F5>F19,F5<F21),\"Date calcul ici\",\"\")","v":""},null,{"$f":"IF(D20<>\"\",F5,\"\")","v":""},{"$f":"IF(D20<>\"\",\"Nbre de jours\",\"\")","v":""},null,{"$f":"IF(D20<>\"\",F20-F19+J20,)","v":0},1]
[null,null,null,"Fin de la période",null,{"$f":"IF(I10=\"A échoir\",EDATE(F19,F14)-1,F13)","v":"2026-11-20"}]
[null,null,null,"Début période suivante",null,{"$f":"F21+1","v":"2026-11-21"},"Nbre de jours période suivante",null,{"$f":"F24-F22+J22","v":100},1]
[null,null,null,{"$f":"IF(AND(F5>F22,F8<F24),\"Date calcul ici\",\"\")","v":""},null,{"$f":"IF(D23<>\"\",F5,\"\")","v":""},{"$f":"IF(D23<>\"\",\"Nbre de jours\",\"\")","v":""},null,{"$f":"IF(D23<>\"\",F23-F22+J23,)","v":0},1]
[null,null,null,"Fin de la période",null,{"$f":"EOMONTH(F21,F14)","v":"2027-02-28"}]
[]
[null,null,null,null,null,null,"Nbre de jours à prendre en compte",null,{"$f":"I20+I17+I23","v":52}]
[null,null,null,null,null,null,"Nbre de jours période",null,{"$f":"IF(D17<>\"\",I16,IF(D20<>\"\",I19,I22))","v":92}]
[null,null,null,null,null,null,"Nature (PCA ou PAR)",null,{"$f":"IF(I10=\"A échoir\",IF(F19>F5,\"PCA\",\"PAR\"),\"\") &\nIF(I10=\"Echu\",IF(F5<F19,\"PCA\",\"PAR\"),\"\")","v":"PCA"}]
[null,null,null,null,null,null,{"$f":"IF(I28=\"PCA\",\"Prorata forfait non consommé\",\"Prorata forfait à facturer\")&\" re-calculé\"","v":"Prorata forfait non consommé re-calculé"},null,{"$f":"I11/I27*(I26)","v":1695.6521739130435}]
[null,null,null,null,null,null,"Quantité","[AO]",3000,null,"Contrôler"]
[null,null,null,null,null,null,"Prorata forfait de l'extraction","[AN]*[AO]",{"$f":"I30*I12","v":1695.6000000000001}]
[]
[null,null,null,"Partie régul."]
[null,null,null,"Du","[AI]","2026-05-21","Compteur à date du PCA-PAR","[AL]",6193]
[null,null,null,"Au","[AJ]",{"$f":"F5","v":"2026-06-30"},"Compteur de Dernière régularisation","[BA]",4561]
[]
[null,null,null,null,null,null,"Cumul des Forfaits facturés","[BB]",3033,{"$f":"I11/I27","v":32.608695652173914}]
[null,null,null,null,null,null,"Forfait non facturé",null,{"$f":"IF(F23<>\"\",I11,)","v":0}]
[null,null,null,null,null,null,{"$f":"\"Report du \" &G29","v":"Report du Prorata forfait non consommé re-calculé"},null,{"$f":"IF(I28=\"PCA\",-1,1) * I29","v":-1695.6521739130435}]
[null,null,null,null,null,null,"TOTAL (Cumul des Forfaits facturés)",null,{"$f":"I37+I38+I39","v":1337.3478260869565}]
[]
[null,null,null,null,null,null,"Sous total",null,{"$f":"I34-I35-I40","v":294.6521739130435}]
[null,null,null,null,null,null,"Remboursement des unités facturées non consommées","cf RFC","Non"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I45>0,\"PAR\",\"\")","v":"PAR"}]
[null,null,null,null,null,null,"PCA-PAR sur régularisation re-calculé",null,{"$f":"IF(AND(I42<0,I43=\"Non\"),0,I42)","v":294.6521739130435}]
[null,null,null,null,null,null,"Prorata temporis","[AN]",1,null,"Contrôler"]
[null,null,null,null,null,null,"Quantité","[AO]",295.04000000000002]
[null,null,null,null,null,null,"PCA-PAR sur régularisation de l'extraction","[AN]*[AO]",{"$f":"I46*I47","v":295.04000000000002}]

{"sheet":"a_EditionConcentree 5.1.5","index":1,"n_rows":17,"n_cols":78,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Date de calcul du PCA-PAR",{"$f":"IF(BZ4<>\"\", BZ4,BY4)","v":"2026-06-30"},null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"x",null,"x","x",null,null,null,null,null,null,null,null,null,"x",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["Code client","Raison sociale du client","Code SSC","Libellé de la SSC","Statut SSC","Code MSC","Libellé de la MSC","Code RFC","Libellé de la RFC","Infos sur la fréquence de facturation","Fréquence de facturation","Périodicité de facturation","Jour de facturation","Terme de la RFC","Libellé du modèle","Identifiant fabricant","Activité du modèle","Famille du modèle","Sous famille du modèle","Quantité forfaitaire","Montant forfaitaire","Montant forfaitaire proratisé","Forfait copies","Tranche copies","Libellé de la grandeur","VMM","Origine vol. moy.","Date dernier relevé prest","Dernier relevé prest","Date dernier relevé client","Dernier relevé client","Date dernier compteur facturé","Dernier compteur facturé","Date prochaine facture théorique","Du","Au","Compteur PCA / PAR pour un bien","Somme compteurs estimés pour PCA PAR pour la RFC","Somme des derniers compteurs facturés","Prorata temporis","Quantité","P.U.","Montant PCA","Montant PCA proratisé (bien/grandeur)","Montant PAR","Montant PAR proratisé (bien/grandeur)","Montant CCA","Montant CCA proratisé (bien/grandeur)","Montant FNP","Montant FNP proratisé (bien/grandeur)","Type ligne","Date de dernière régularisation","Compteur de dernière régularisation","Cumul des forfaits facturés depuis la dernière régularisation","Infos sur la fréquence de facturation de la régularisation","Fréquence de facturation de la régularisation","Périodicité de facturation de la régularisation","Jour de facturation de la régularisation","Tranche à atteindre","Consommé réel","N° dernière facture","Date de dernière facture","Nombre de copies offertes","Commentaires","Code article de la RFC","Libellé article de la RFC","Marque article de la RFC","Compte comptable de l'article de la RFC","Organisation interne","Type de RFC","Agence du client","Agence du site","Agence du bien","Classement client","Chargé d'affaire","Id RFC","Activité","Date calcul"]
["109445","GIE MONDE DE LA PROPRETE","106945","Bureautique classique","Validée","FORNB - 2","FORFAIT  Régularisation NB","53-1","FORFAIT TRIMEST REGUL COPIES  NB","le 21 tous les 3 mois","3","Mensuelle","21","A échoir","Epson WorkForce WF-100W","UTJK089333","SYSTÈME IMPRESSION","MULTIFONCTIONS","MULTIFONCTIONS COULEUR",null,null,null,3000,null,null,null,null,null,null,null,null,null,null,"2026-08-21","2026-06-30","2026-08-20",null,null,null,0.56521739130434778,3000,8.0000000000000002E-3,13.57,13.57,null,null,null,null,null,null,"Vente",null,null,null,null,null,null,null,null,null,"106369","2026-05-31",null,"FORFAIT - Facture 106369 du 31/05/2026","FCN","Forfait Copies noires",null,"70610000","01 Impression A","Forfait et régularisation","MARCOUSSIS",null,null,null,null,"68950","Informatique","2026-06-30"]
["109445","GIE MONDE DE LA PROPRETE","106945","Bureautique classique","Validée","FORNB - 2","FORFAIT  Régularisation NB","53-1","FORFAIT TRIMEST REGUL COPIES  NB","le 21 tous les 3 mois","3","Mensuelle","21","Echu","Epson WorkForce WF-100W","UTJK089333","SYSTÈME IMPRESSION","MULTIFONCTIONS","MULTIFONCTIONS COULEUR",null,null,null,3000,null,"Totalisateur Noir (ou 109)",1460,"VMM","2026-05-27T18:46:00",4561,null,null,"2026-05-27T18:46:00",4561,"2026-08-21","2026-05-21","2026-06-30",6193,6193,4561,1,295.04347826086973,8.0000000000000002E-3,null,null,2.36,2.3603478260869579,null,null,null,null,"Vente","2026-05-21",4561,3033,"le 21 tous les 3 mois",3,"Mensuelle",21,null,null,"106369","2026-05-31",null,"REGULARISATION - ","CSN","Copies supplémentaires noires",null,"70610000","01 Impression A","Forfait et régularisation","MARCOUSSIS",null,null,null,null,"68950","Informatique","2026-06-30"]
[]
[]
["Date de calcul du PCA-PAR",{"$f":"IF(BZ10<>\"\", BZ10,BY10)","v":"2026-08-20"},null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"x",null,"x","x",null,null,null,null,null,null,null,null,null,"x",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["Code client","Raison sociale du client","Code SSC","Libellé de la SSC","Statut SSC","Code MSC","Libellé de la MSC","Code RFC","Libellé de la RFC","Infos sur la fréquence de facturation","Fréquence de facturation","Périodicité de facturation","Jour de facturation","Terme de la RFC","Libellé du modèle","Identifiant fabricant","Activité du modèle","Famille du modèle","Sous famille du modèle","Quantité forfaitaire","Montant forfaitaire","Montant forfaitaire proratisé","Forfait copies","Tranche copies","Libellé de la grandeur","VMM","Origine vol. moy.","Date dernier relevé prest","Dernier relevé prest","Date dernier relevé client","Dernier relevé client","Date dernier compteur facturé","Dernier compteur facturé","Date prochaine facture théorique","Du","Au","Compteur PCA / PAR pour un bien","Somme compteurs estimés pour PCA PAR pour la RFC","Somme des derniers compteurs facturés","Prorata temporis","Quantité","P.U.","Montant PCA","Montant PCA proratisé (bien/grandeur)","Montant PAR","Montant PAR proratisé (bien/grandeur)","Montant CCA","Montant CCA proratisé (bien/grandeur)","Montant FNP","Montant FNP proratisé (bien/grandeur)","Type ligne","Date de dernière régularisation","Compteur de dernière régularisation","Cumul des forfaits facturés depuis la dernière régularisation","Infos sur la fréquence de facturation de la régularisation","Fréquence de facturation de la régularisation","Périodicité de facturation de la régularisation","Jour de facturation de la régularisation","Tranche à atteindre","Consommé réel","N° dernière facture","Date de dernière facture","Nombre de copies offertes","Commentaires","Code article de la RFC","Libellé article de la RFC","Marque article de la RFC","Compte comptable de l'article de la RFC","Organisation interne","Type de RFC","Agence du client","Agence du site","Agence du bien","Classement client","Chargé d'affaire","Id RFC","Activité","Date calcul"]
["109445","GIE MONDE DE LA PROPRETE","106945","Bureautique classique","Validée","FORNB - 2","FORFAIT  Régularisation NB","53-1","FORFAIT TRIMEST REGUL COPIES  NB","le 21 tous les 3 mois","3","Mensuelle","21","Echu","Epson WorkForce WF-100W","UTJK089333","SYSTÈME IMPRESSION","MULTIFONCTIONS","MULTIFONCTIONS COULEUR",null,null,null,3000,null,"Totalisateur Noir (ou 109)",1460,"VMM","2026-05-27T18:46:00",4561,null,null,"2026-05-27T18:46:00",4561,"2026-08-21","2026-05-21","2026-08-20",8641,8641,4561,1,1080,8.0000000000000002E-3,null,null,8.64,8.64,null,null,null,null,"Vente","2026-05-21",4561,3000,"le 21 tous les 3 mois",3,"Mensuelle",21,null,null,"106369","2026-05-31",null,"REGULARISATION - ","CSN","Copies supplémentaires noires",null,"70610000","01 Impression A","Forfait et régularisation","MARCOUSSIS",null,null,null,null,"68950","Informatique","2026-08-20"]
[]
[]
["Date de calcul du PCA-PAR",{"$f":"IF(BZ15<>\"\", BZ15,BY15)","v":"2026-09-30"},null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,"x",null,"x","x",null,null,null,null,null,null,null,null,null,"x",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
["Code client","Raison sociale du client","Code SSC","Libellé de la SSC","Statut SSC","Code MSC","Libellé de la MSC","Code RFC","Libellé de la RFC","Infos sur la fréquence de facturation","Fréquence de facturation","Périodicité de facturation","Jour de facturation","Terme de la RFC","Libellé du modèle","Identifiant fabricant","Activité du modèle","Famille du modèle","Sous famille du modèle","Quantité forfaitaire","Montant forfaitaire","Montant forfaitaire proratisé","Forfait copies","Tranche copies","Libellé de la grandeur","VMM","Origine vol. moy.","Date dernier relevé prest","Dernier relevé prest","Date dernier relevé client","Dernier relevé client","Date dernier compteur facturé","Dernier compteur facturé","Date prochaine facture théorique","Du","Au","Compteur PCA / PAR pour un bien","Somme compteurs estimés pour PCA PAR pour la RFC","Somme des derniers compteurs facturés","Prorata temporis","Quantité","P.U.","Montant PCA","Montant PCA proratisé (bien/grandeur)","Montant PAR","Montant PAR proratisé (bien/grandeur)","Montant CCA","Montant CCA proratisé (bien/grandeur)","Montant FNP","Montant FNP proratisé (bien/grandeur)","Type ligne","Date de dernière régularisation","Compteur de dernière régularisation","Cumul des forfaits facturés depuis la dernière régularisation","Infos sur la fréquence de facturation de la régularisation","Fréquence de facturation de la régularisation","Périodicité de facturation de la régularisation","Jour de facturation de la régularisation","Tranche à atteindre","Consommé réel","N° dernière facture","Date de dernière facture","Nombre de copies offertes","Commentaires","Code article de la RFC","Libellé article de la RFC","Marque article de la RFC","Compte comptable de l'article de la RFC","Organisation interne","Type de RFC","Agence du client","Agence du site","Agence du bien","Classement client","Chargé d'affaire","Id RFC","Activité","Date calcul"]
["109445","GIE MONDE DE LA PROPRETE","106945","Bureautique classique","Validée","FORNB - 2","FORFAIT  Régularisation NB","53-1","FORFAIT TRIMEST REGUL COPIES  NB","le 21 tous les 3 mois","3","Mensuelle","21","Echu","Epson WorkForce WF-100W","UTJK089333","SYSTÈME IMPRESSION","MULTIFONCTIONS","MULTIFONCTIONS COULEUR",null,null,null,3000,null,"Totalisateur Noir (ou 109)",1460,"VMM","2026-05-27T18:46:00",4561,null,null,"2026-05-27T18:46:00",4561,"2026-08-21","2026-05-21","2026-08-20",8641,8641,4561,1,1080,8.0000000000000002E-3,null,null,8.64,8.64,null,null,null,null,"Vente","2026-05-21",4561,3000,"le 21 tous les 3 mois",3,"Mensuelle",21,null,null,"106369","2026-05-31",null,"REGULARISATION - ","CSN","Copies supplémentaires noires",null,"70610000","01 Impression A","Forfait et régularisation","MARCOUSSIS",null,null,null,null,"68950","Informatique","2026-09-30"]
["109445","GIE MONDE DE LA PROPRETE","106945","Bureautique classique","Validée","FORNB - 2","FORFAIT  Régularisation NB","53-1","FORFAIT TRIMEST REGUL COPIES  NB","le 21 tous les 3 mois","3","Mensuelle","21","A échoir","Epson WorkForce WF-100W","UTJK089333","SYSTÈME IMPRESSION","MULTIFONCTIONS","MULTIFONCTIONS COULEUR",null,null,null,3000,null,null,null,null,null,null,null,null,null,null,"2026-08-21","2026-08-21","2026-09-30",null,null,null,0.44565217391304346,3000,8.0000000000000002E-3,null,null,10.7,10.7,null,null,null,null,"Vente",null,null,null,null,null,null,null,null,null,"106369","2026-05-31",null,"FORFAIT - Facture 106369 du 31/05/2026","FCN","Forfait Copies noires",null,"70610000","01 Impression A","Forfait et régularisation","MARCOUSSIS",null,null,null,null,"68950","Informatique","2026-09-30"]
["109445","GIE MONDE DE LA PROPRETE","106945","Bureautique classique","Validée","FORNB - 2","FORFAIT  Régularisation NB","53-1","FORFAIT TRIMEST REGUL COPIES  NB","le 21 tous les 3 mois","3","Mensuelle","21","Echu","Epson WorkForce WF-100W","UTJK089333","SYSTÈME IMPRESSION","MULTIFONCTIONS","MULTIFONCTIONS COULEUR",null,null,null,3000,null,"Totalisateur Noir (ou 109)",1460,"VMM","2026-05-27T18:46:00",4561,null,null,"2026-08-20",8641,"2026-08-21","2026-08-21","2026-09-30",10610,10610,8641,1,632.04347826086973,8.0000000000000002E-3,null,null,5.0599999999999996,5.0563478260869577,null,null,null,null,"Vente","2026-05-21",8641,3000,"le 21 tous les 3 mois",3,"Mensuelle",21,null,null,"106369","2026-05-31",null,"REGULARISATION - ","CSN","Copies supplémentaires noires",null,"70610000","01 Impression A","Forfait et régularisation","MARCOUSSIS",null,null,null,null,"68950","Informatique","2026-09-30"]

{"sheet":"Contrôle 300092026","index":2,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[25,10,26,10],[39,10,42,10]]}
[]
[null,"[...]","Référence à la colonne du fichier"]
[null,"Saisir","Informations à saisir prise dans l'extraction du PCA-PAR Edition concentrée"]
[]
[null,null,null,"Date du PCA-PAR","[BY]","2026-09-30"]
[]
[null,null,null," ","Référence","Période","Détail","Référence","RFC 1"]
[null,null,null,"Partie forfait"]
[]
[null,null,null,"Du","[AI]","2026-08-21","Nbre de copies du forfait","[W]",3000]
[null,null,null,"Au","[AJ]","30/09/20269","Prorata temporis","[AN]",0.44569999999999999]
[]
[null,null,null,"Date proch. Fact.","[AH] ","2026-08-21"]
[null,null,null,"Périodicité","[J]",3]
[]
[null,null,null,"Début période précédente",null,{"$f":"EDATE(F19,-F14)","v":"2026-05-21"},"Nbre de jours période Précédente",null,{"$f":"F19-F16","v":92}]
[null,null,null,{"$f":"IF(AND(F5>F16,F5<F19),\"Date calc. PCA ici\",\"\")","v":""},null,{"$f":"IF(D17<>\"\",F5,\"\")","v":""},{"$f":"IF(D17<>\"\",\"Nbre de jours\",\"\")","v":""},null,{"$f":"IF(D17<>\"\",F19-F17,)","v":0}]
[null,null,null,"Fin de la période",null,{"$f":"F19-1","v":"2026-08-20"}]
[null,null,null,"Début prochaine période",null,{"$f":"F13","v":"2026-08-21"},"Nbre de jours prochaine période",null,{"$f":"F21-F19+1","v":92}]
[null,null,null,{"$f":"IF(AND(F5>F19,F5<F21),\"Date calc. PAR ici\",\"\")","v":"Date calc. PAR ici"},null,{"$f":"IF(D20<>\"\",F5,\"\")","v":"2026-09-30"},{"$f":"IF(D20<>\"\",\"Nbre de jours\",\"\")","v":"Nbre de jours"},null,{"$f":"IF(D20<>\"\",F20-F19+1,)","v":41}]
[null,null,null,"Fin de la période",null,{"$f":"EDATE(F19,F14)-1","v":"2026-11-20"}]
[]
[null,null,null,null,null,null,"Nbre de jours à prendre en compte",null,{"$f":"I20+I17","v":41}]
[null,null,null,null,null,null,"Nbre de jours période",null,{"$f":"IF(D17<>\"\",I16,I19)","v":92}]
[null,null,null,null,null,null,"Nature (PCA ou PAR)",null,{"$f":"IF(F19>F5,\"PCA\",\"PAR\")","v":"PAR"}]
[null,null,null,null,null,null,{"$f":"IF(I25=\"PCA\",\"Prorata forfait non consommé\",\"Prorata forfait à facturer\")&\" re-calculé\"","v":"Prorata forfait à facturer re-calculé"},null,{"$f":"I10/I24*I23","v":1336.9565217391305},null,"Contrôler"]
[null,null,null,null,null,null,"Prorata forfait de l'extraction","[AN]*[W]",{"$f":"I10*I11","v":1337.1}]
[]
[null,null,null,"Partie régul."]
[null,null,null,"Du","[AI]","2026-08-21","Compteur à date du PCA-PAR","[AL]",10160]
[null,null,null,"Au","[AJ]","2026-09-30","Compteur de Dernière régularisation","[BA]",8641]
[]
[null,null,null,null,null,null,"Cumul des Forfaits facturés","[BB]",3000]
[null,null,null,null,null,null,{"$f":"\"Report du \" &G26","v":"Report du Prorata forfait à facturer re-calculé"},null,{"$f":"IF(I25=\"PCA\",-1,1) * I26","v":1336.9565217391305}]
[null,null,null,null,null,null,"TOTAL (Cumul des Forfaits facturés)",null,{"$f":"I33+I34","v":4336.95652173913}]
[]
[null,null,null,null,null,null,"Sous total",null,{"$f":"I30-I31-I35","v":-2817.95652173913}]
[null,null,null,null,null,null,"Remboursement des unités facturées non consommées","cf RFC","Non"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I40>0,\"PAR\",\"\")","v":""}]
[null,null,null,null,null,null,"PCA-PAR sur régularisation re-calculé",null,{"$f":"IF(AND(I37<0,I38=\"Non\"),0,I37)","v":0},null,"Contrôler"]
[null,null,null,null,null,null,"Prorata temporis","[AN]",1]
[null,null,null,null,null,null,"Quantité","[AO]",632]
[null,null,null,null,null,null,"PCA-PAR sur régularisation de l'extraction","[AN]*[AO]",{"$f":"I41*I42","v":632}]

{"sheet":"Contrôle 20082026","index":3,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[25,10,26,10],[39,10,42,10]]}
[]
[null,"[...]","Référence à la colonne du fichier"]
[null,"Saisir","Informations à saisir prise dans l'extraction du PCA-PAR Edition concentrée"]
[]
[null,null,null,"Date du PCA-PAR","[BY]","2026-08-21"]
[]
[null,null,null," ","Référence","Période","Détail","Référence","RFC 1"]
[null,null,null,"Partie forfait"]
[]
[null,null,null,"Du","[AI]","2026-08-20","Nbre de copies du forfait","[W]",3000]
[null,null,null,"Au","[AJ]","2026-08-20","Prorata temporis","[AN]",0]
[]
[null,null,null,"Date proch. Fact.","[AH] ","2026-08-21"]
[null,null,null,"Périodicité","[J]",3]
[]
[null,null,null,"Début période précédente",null,{"$f":"EDATE(F19,-F14)","v":"2026-05-21"},"Nbre de jours période Précédente",null,{"$f":"F19-F16","v":92}]
[null,null,null,{"$f":"IF(AND(F5>F16,F5<F19),\"Date calc. PCA ici\",\"\")","v":""},null,{"$f":"IF(D17<>\"\",F5,\"\")","v":""},{"$f":"IF(D17<>\"\",\"Nbre de jours\",\"\")","v":""},null,{"$f":"IF(D17<>\"\",F19-F17,)","v":0}]
[null,null,null,"Fin de la période",null,{"$f":"F19-1","v":"2026-08-20"}]
[null,null,null,"Début prochaine période",null,{"$f":"F13","v":"2026-08-21"},"Nbre de jours prochaine période",null,{"$f":"F21-F19+1","v":92}]
[null,null,null,{"$f":"IF(AND(F5>F19,F5<F21),\"Date calc. PAR ici\",\"\")","v":""},null,{"$f":"IF(D20<>\"\",F5,\"\")","v":""},{"$f":"IF(D20<>\"\",\"Nbre de jours\",\"\")","v":""},null,{"$f":"IF(D20<>\"\",F20-F19+1,)","v":0}]
[null,null,null,"Fin de la période",null,{"$f":"EDATE(F19,F14)-1","v":"2026-11-20"}]
[]
[null,null,null,null,null,null,"Nbre de jours à prendre en compte",null,{"$f":"I20+I17","v":0}]
[null,null,null,null,null,null,"Nbre de jours période",null,{"$f":"IF(D17<>\"\",I16,I19)","v":92}]
[null,null,null,null,null,null,"Nature (PCA ou PAR)",null,{"$f":"IF(F19>F5,\"PCA\",\"PAR\")","v":"PAR"}]
[null,null,null,null,null,null,{"$f":"IF(I25=\"PCA\",\"Prorata forfait non consommé\",\"Prorata forfait à facturer\")&\" re-calculé\"","v":"Prorata forfait à facturer re-calculé"},null,{"$f":"I10/I24*I23","v":0},null,"Contrôler"]
[null,null,null,null,null,null,"Prorata forfait de l'extraction","[AN]*[W]",{"$f":"I10*I11","v":0}]
[]
[null,null,null,"Partie régul."]
[null,null,null,"Du","[AI]","2026-05-21","Compteur à date du PCA-PAR","[AL]",8641]
[null,null,null,"Au","[AJ]","2026-08-20","Compteur de Dernière régularisation","[BA]",4561]
[]
[null,null,null,null,null,null,"Cumul des Forfaits facturés","[BB]",3000]
[null,null,null,null,null,null,{"$f":"\"Report du \" &G26","v":"Report du Prorata forfait à facturer re-calculé"},null,{"$f":"IF(I25=\"PCA\",-1,1) * I26","v":0}]
[null,null,null,null,null,null,"TOTAL (Cumul des Forfaits facturés)",null,{"$f":"I33+I34","v":3000}]
[]
[null,null,null,null,null,null,"Sous total",null,{"$f":"I30-I31-I35","v":1080}]
[null,null,null,null,null,null,"Remboursement des unités facturées non consommées","cf RFC","Non"]
[null,null,null,null,null,null,null,null,{"$f":"IF(I40>0,\"PAR\",\"\")","v":"PAR"}]
[null,null,null,null,null,null,"PCA-PAR sur régularisation re-calculé",null,{"$f":"IF(AND(I37<0,I38=\"Non\"),0,I37)","v":1080},null,"Contrôler"]
[null,null,null,null,null,null,"Prorata temporis","[AN]",1]
[null,null,null,null,null,null,"Quantité","[AO]",1080]
[null,null,null,null,null,null,"PCA-PAR sur régularisation de l'extraction","[AN]*[AO]",{"$f":"I41*I42","v":1080}]