{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["DECOMPTE 1","DECOMPTE 2","RESUME","LETTRE D'ENVOI","RECAPITULATION (1)","RECAPITULATION (2)","TOTALISER XX","TOTALISER B","TOTALISER A (2)","CALCULS","TOTAL CHARGES","COURRIER1","COURRIER2","COURRIER INDEPENDANT","JOINTES","MODE D'EMPLOI","DONNEES","Suggestion1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":32,"comments":4,"pivot_tables":1},"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":"DECOMPTE 1","index":0,"n_rows":70,"n_cols":28,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,8,0,9],[1,9,1,12],[1,15,1,16],[59,9,59,12]]}
[]
[null,null,null,null,"FRANCHISE ",{"$f":"DONNEES!D10","v":300},"TOTALISER XX","Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939",null,"Décompte du :",null,null,null,{"$f":"TODAY()","v":"2023-12-03"},"AIDE COLONNE\nO","CALCUL DU POURCENT",null,null,null,"AIDE COLONNE\n  S"]
[null,"Date de la consultation\nPrestation(s)","Date de \n\nla Facture","DATE D'ENVOI A L'ASSURANCE","TYPES DE SOINS","TYPE(S) DE PRESTATION(S) OU REMEDE(S)","No Décompte","DESCRIPTION(S)\nFOURNISSEURS","Montant \nFacture(s)","Mes \nAvances","Calcule du\n10 %","Montant Remboursé Moins le\n10 %","Date du\nRemboursement ou \n NON remboursement","SITUATION \n\nA CE JOUR","Montants  après DEDUCTIONS OU\nNON REMBOURSE\nOU FRANCHISE EN NEGATIF","Pourcentage de Participation\n10 %","Solde à payé\npar \nl'Assureur","CODES FACTURES AUTO","Numéro du Décompte Assura","Montants Réellement payé par l'Assurance","Montant des Factures Regroupées","Différence entre mes avances et leurs remboursement","Addition des montants pour Franchise & non payment Divers","Commentaires a reprendrent dans la colonne D qui s'affiche avec le petit triangle","Total des montants reconnu par l'assurance",null,"\nDATE DE MON PAYEMENT\nDES FACTURES \nOU DATE DE L'ECRITURE\n",0.1]
[null,null,null,null,null,null,null,null,{"$f":"I59","v":0},{"$f":"J59","v":0},{"$f":"K59","v":0},{"$f":"SUM(L5:L58)","v":0},null,null,{"$f":"O63","v":0},{"$f":"P59","v":0},{"$f":"Q59","v":0},null,null,{"$f":"T59","v":421.55000000000007},{"$f":"U59","v":0},{"$f":"V59","v":0},{"$f":"(W59)","v":0},null,{"$f":"Y59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G5","v":0},null,null,null,{"$f":"P5","v":0},{"$f":"IF(O5<0,O5,\"\")","v":""},"REGLEMENT DIRECT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"","DECOMPTE POUR FRANCHISE",{"$f":"ABS(O6)","v":0},{"$f":"R6","v":0},{"$f":"M6","v":"00:00:00"},{"$f":"P6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"","EN ATTENTE DE LA PARTICIPATION",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"","EN ATTENTE DE REGLEMENT",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"","ERREUR",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"","FACTURE PAYEE DIRECTEMENT PAR L'ASSURANCE",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"","MA PARTICIPATION 10 %  SUR AVANCE DE L'ASSURANCE",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"P12","v":0},"","PRELEVEMENT  ET/OU REMBOURSEMENT FRANCHISE",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G13","v":0},null,null,null,0,"","REMBOURSE SOUS DEDUCTION DU 10 %",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2231678607",19.100000000000001,null,0,"","REMBOURSEMENT DE L'ASSUREUR POUR TOP PAYE",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2232525578",6.95,null,{"$f":"P15","v":0},"","REMBOURSEMENT SANS PARTICIPATION",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2232865934",129.25,null,0,"","REMBOUSEMENT PARTIEL",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2232100125",104.15,null,0,"","SOLDE DE LA FACTURE APRES DEDUCTION FRANCHISE",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2236607454",0,null,0,"","SOLDE DE LA FACTURE APRES DEDUCTION FRANCHISE - 10%",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2236124045",13.95,null,0,"","NON REMBOURSE PAR L'ASSURANCE",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2236124045",31.3,null,0,"","OPTIONS CONDITIONNELLES",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"2236124045",5.3,null,{"$f":"P21","v":0},"","VOIR SUSPENDS",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"22336493772",111.55,null,0,"","FACTURE PAYEE DIRECTEMENT PAR L'ASSURANCE ",0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,"",null,0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I24*10%","v":0},{"$f":"I24-K24","v":0},null,null,null,{"$f":"IF(O24>0,O24*DONNEES!$D$13,IF(O24>=DONNEES!D29,AB75,\"\"))","v":0},{"$f":"IF(P24<>\"\",O24-P24,\"\")","v":0},0,null,null,null,0,"",null,0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O25>0,O25*DONNEES!$D$13,IF(O25>=DONNEES!D30,AB76,\"\"))","v":0},0,0,null,null,null,{"$f":"P25","v":0},"",null,0,0,"00:00:00",0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O26>0,O26*DONNEES!$D$13,IF(O26>=DONNEES!D31,AB77,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O27>0,O27*DONNEES!$D$13,IF(O27>=DONNEES!D32,AB78,\"\"))","v":0},0,0,null,null,null,{"$f":"P27","v":0},"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I28*10%","v":0},0,null,null,null,{"$f":"IF(O28>0,O28*DONNEES!$D$13,IF(O28>=DONNEES!D33,AB79,\"\"))","v":0},0,0,null,null,null,0,null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"I29-K29","v":0},null,null,null,{"$f":"IF(O29>0,O29*DONNEES!$D$13,IF(O29>=DONNEES!D34,AB80,\"\"))","v":0},0,0,null,null,null,0,null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O30>0,O30*DONNEES!$D$13,IF(O30>=DONNEES!D35,AB81,\"\"))","v":0},0,0,null,null,null,0,null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O31>0,O31*DONNEES!$D$13,IF(O31>=DONNEES!D36,AB82,\"\"))","v":0},0,0,null,null,null,0,null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O32>0,O32*DONNEES!$D$13,IF(O32>=DONNEES!D37,AB83,\"\"))","v":0},0,0,null,null,null,0,null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O33>0,O33*DONNEES!$D$13,IF(O33>=DONNEES!D38,AB84,\"\"))","v":0},{"$f":"IF(P33<>\"\",O33-P33,\"\")","v":0},0,null,null,null,{"$f":"P33","v":0},{"$f":"IF(O33<0,O33,\"\")","v":""},null,{"$f":"ABS(O33)","v":0},0,null,{"$f":"P33","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O34>0,O34*DONNEES!$D$13,IF(O34>=DONNEES!D39,AB85,\"\"))","v":0},0,0,null,null,null,0,{"$f":"IF(O34<0,O34,\"\")","v":""},null,{"$f":"ABS(O34)","v":0},0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O35>0,O35*DONNEES!$D$13,IF(O35>=DONNEES!D40,AB86,\"\"))","v":0},0,0,null,null,null,0,"",null,{"$f":"ABS(O35)","v":0},0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O36>0,O36*DONNEES!$D$13,IF(O36>=DONNEES!D41,AB87,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O37>0,O37*DONNEES!$D$13,IF(O37>=DONNEES!D42,AB88,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O38>0,O38*DONNEES!$D$13,IF(O38>=DONNEES!D43,AB89,\"\"))","v":0},0,{"$f":"G38","v":0},null,null,null,{"$f":"P38","v":0},"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O39>0,O39*DONNEES!$D$13,IF(O39>=DONNEES!D44,AB90,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,{"$f":"P39","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I40*10%","v":0},0,null,null,null,{"$f":"IF(O40>0,O40*DONNEES!$D$13,IF(O40>=DONNEES!D45,AB91,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"I41-K41","v":0},null,null,null,{"$f":"IF(O41>0,O41*DONNEES!$D$13,IF(O41>=DONNEES!D46,AB92,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O42>0,O42*DONNEES!$D$13,IF(O42>=DONNEES!D47,AB93,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O43>0,O43*DONNEES!$D$13,IF(O43>=DONNEES!D48,AB94,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O44>0,O44*DONNEES!$D$13,IF(O44>=DONNEES!D49,AB95,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O45>0,O45*DONNEES!$D$13,IF(O45>=DONNEES!D50,AB96,\"\"))","v":0},0,0,null,null,null,{"$f":"P45","v":0},"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O46>0,O46*DONNEES!$D$13,IF(O46>=DONNEES!D51,AB97,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O47>0,O47*DONNEES!$D$13,IF(O47>=DONNEES!D52,AB98,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O48>0,O48*DONNEES!$D$13,IF(O48>=DONNEES!D53,AB99,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,{"$f":"P48","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I49*10%","v":0},0,null,null,null,{"$f":"IF(O49>0,O49*DONNEES!$D$13,IF(O49>=DONNEES!D54,AB100,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O50>0,O50*DONNEES!$D$13,IF(O50>=DONNEES!D55,AB101,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O51>0,O51*DONNEES!$D$13,IF(O51>=DONNEES!D56,AB102,\"\"))","v":0},0,0,null,null,null,{"$f":"P51","v":0},"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O52>0,O52*DONNEES!$D$13,IF(O52>=DONNEES!D57,AB103,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"I53-K53","v":0},null,null,null,{"$f":"IF(O53>0,O53*DONNEES!$D$13,IF(O53>=DONNEES!D58,AB104,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O54>0,O54*DONNEES!$D$13,IF(O54>=DONNEES!D59,AB105,\"\"))","v":0},0,0,null,null,null,0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O55>0,O55*DONNEES!$D$13,IF(O55>=DONNEES!D60,AB106,\"\"))","v":0},0,0,null,null,null,0,"",null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O56>0,O56*DONNEES!$D$13,IF(O56>=DONNEES!D61,AB107,\"\"))","v":0},0,0,null,null,null,{"$f":"P56","v":0},"",null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(O57>0,O57*DONNEES!$D$13,IF(O57>=DONNEES!D62,AB108,\"\"))","v":0},0,0,null,null,null,0,"",null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"SOUS TOTAUX",{"$f":"SUM(I5:I58)","v":0},{"$f":"SUM(J5:J58)","v":0},{"$f":"SUM(K5:K58)","v":0},{"$f":"SUM(L5:L58)","v":0},null,null,{"$f":"SUM(O5:O58)","v":0},{"$f":"MIN(DONNEES!D12,SUM(P5:P33))","v":0},{"$f":"SUMIF(Q5:Q58,\">0\",Q5:Q58)","v":0},null,null,{"$f":"SUM(T5:T33)","v":421.55000000000007},{"$f":"SUM(U5:U33)","v":0},{"$f":"SUM(V5:V33)","v":0},{"$f":"SUM(W5:W33)","v":0},null,{"$f":"SUM(Y5:Y33)","v":0}]
[null,{"$f":"DONNEES!D10","v":300},null,null,null,null,null,{"$f":"\"SOLDE (APRES) DEDUCTION DE LA FRANCHISE \"&B60","v":"SOLDE (APRES) DEDUCTION DE LA FRANCHISE 300"},{"$f":"ABS(J59-F2)","v":300},"FRAI ANNEXES A MA CHARGE",null,null,null,{"$f":"IF(O60<0,\"TROP PERCU POUR LA FRANCHISE\",IF(O60>0,\"MONTANT A PERCEVOIR POUR LA FRANCHISE OU FRAIS ANNEXES\",\"\"))","v":"MONTANT A PERCEVOIR POUR LA FRANCHISE OU FRAIS ANNEXES"},{"$f":"SUM(B60-N64)","v":300},"PARTIEL\nOU REFUS",{"$f":"V59","v":0}]
[null,{"$f":"P59","v":0},null,null,null,null,null,"SOUS DEDUCTION DES PARTICIPATIONS",{"$f":"B61","v":0}]
[null,{"$f":"Q60","v":0},null,null,null,null,null,"MONTANTS NON PRIS EN CHARGE",{"$f":"Q60","v":0}]
[null,null,null,null,null,null,null,"SOLDE INTEMEDIAIRE",{"$f":"I60-I61-I62","v":300},null,null,null,null,"Solde calculé - Solde payé",{"$f":"O59","v":0},"-",{"$f":"T59","v":421.55000000000007}]
[null,null,null,null,null,null,null,{"$f":"IF(I64>0,\"SOLDE A MA CHARGE\",IF(I64<0,\"SOLDE EN MA FAVEUR OU DEFAVEUR\"))","v":"SOLDE EN MA FAVEUR OU DEFAVEUR"},{"$f":"J59-B60-B61-B62","v":-300},null,null,null,"MONTANTS RETENUS POUR LA FRANCHISE",{"$f":"ABS(W59)","v":0},"Mes avances sous déduction du montant réellement payé par l'assureur.",null,{"$f":"J59-Q59","v":0}]
[null,null,null,null,null,null,null,"Total des montants reconnu par l'assurance",{"$f":"Q64","v":0}]
[null,null,null,null,null,null,null,"Moins franchise",{"$f":"B60","v":300}]
[null,null,null,null,null,null,null,"Moins participation",{"$f":"B61","v":0}]
[null,null,null,null,null,null,null,"Montant à rembourser",{"$f":"I65-I66-I67","v":-300}]
[null,null,null,null,null,null,null,"- Remboursement de l'assurance",{"$f":"Q63","v":421.55000000000007}]
[null,null,null,null,null,null,null,"Solde actuel ",{"$f":"I68-I69","v":-721.55000000000007}]

{"sheet":"DECOMPTE 2","index":1,"n_rows":77,"n_cols":29,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,1,0,6],[4,6,4,7],[5,6,5,7],[3,6,3,7],[1,7,1,9]]}
[null,"MODE D''EMPLOI",null,null,null,null,null,null,null,"MODE REMBOURSE \n\nNON REMBOURSE",null,null,null,"DSK","TOTAL CHARGES","REMBOUSEMENT REFUSEE",{"$f":"DONNEES!B18","v":2024},null,null,"RECAPITULATION"]
[null,null,null,null,"FRANCHISE ",300,null,"Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939",null,null,"Décompte du :",null,null,{"$f":"TODAY()","v":"2023-12-03"},"ZONE DE CALCULS","AIDE COLONNE\n O","CALCUL DU POURCENT",null,null,null,"AIDE COLONNE\n  S"]
[null,"Date de la consultation \nou\nPrestation(s)","Date de la Facture","DATE D'ENVOI A L'ASSURANCE","TYPES \nDE\n SOINS","TYPE(S) DE PRESTATION(S) \nOU \nMEDICAMENT(S)","No \nFacture","DESCRIPTION(S)\n\nFOURNISSEURS\n\nPRESCRIPTEURS","TAPER \nQQC SI\nREMBOURSE\n\nSI NON RIEN","Montant \nFacture(s)","Mes \nAvances","Calcule du\n10 %","Montant Remboursé Moins le\n10 %","Date du\nRemboursement \nou  DU  NON remboursement","SITUATION \nA\n CE JOUR","Montants à ma charge\nOU NON REMBOURSE\n","Pourcentage de\n Participation\n10 %","Solde à payé\npar \nl'Assureur","CODES FACTURES","Numéro du Décompte Assura","Montants Réellement payé par l'Assurance","Montant des Factures Regroupées","Différence entre mes avances et leurs remboursement","Addition des montants négatifs retenus pour Franchise","Commentaires a reprendrent dans la colonne D qui s'affiche avec le petit triangle","Total des montants reconnu par l'assurance",null,"\nDATE DE MON PAYEMENT\nDES FACTURES \nOU DATE DE L'ECRITURE\n",0.1]
[null,null,null,null,null,null,"REPORT TOTAUX DECOMPTE 1",null,null,null,null,null,null,null," <<  1  >>",null,{"$f":"'DECOMPTE 1'!P4","v":0},{"$f":"'DECOMPTE 1'!Q4","v":0},null,null,{"$f":"'DECOMPTE 1'!T4","v":421.55000000000007},null,{"$f":"'DECOMPTE 1'!V4","v":0}]
[null,null,null,null,null,null,"REPORT TOTAUX DECOMPTE 2",null,null,{"$f":"J61","v":0},{"$f":"K61","v":0},null,{"$f":"SUM(M7:M60)","v":0},null," <<  2  >>",{"$f":"P61","v":0},{"$f":"Q61","v":0},{"$f":"R61","v":0},null,null,{"$f":"U61","v":0},{"$f":"V61","v":0},{"$f":"W61","v":0},{"$f":"X61","v":0},null,{"$f":"Z61","v":0}]
[null,null,null,null,null,null,"TOTAL DE 2",null,null,{"$f":"J4+J5","v":0},{"$f":"K4+K5","v":0},{"$f":"L4+L5","v":0},0,0," <<  1 + 2  >>",null,{"$f":"Q4+Q5","v":0},{"$f":"R4+R5","v":0},{"$f":"S4+S5","v":0},{"$f":"T4+T5","v":0},{"$f":"U4+U5","v":421.55000000000007},null,{"$f":"SUM(W4:W5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colonne1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DECOMPTE POUR FRANCHISE",{"$f":"ABS(P8)","v":0},{"$f":"S8","v":0},null,{"$f":"Q8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EN ATTENTE DE LA PARTICIPATION",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EN ATTENTE DE REGLEMENT",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERREUR",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACTURE PAYEE DIRECTEMENT PAR L'ASSURANCE",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MA PARTICIPATION 10 %  SUR AVANCE DE L'ASSURANCE",0,0,null,0]
[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,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REMBOURSE SOUS DEDUCTION DU 10 %",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REMBOURSEMENT DE L'ASSUREUR POUR TOP PAYE",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REMBOURSEMENT SANS PARTICIPATION",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G18","v":0},null,null,null,{"$f":"IF(P18>0,K18-U18,\"\")","v":""},{"$f":"IF(P18<0,P18,\"\")","v":""},"REMBOUSEMENT PARTIEL",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","","SOLDE DE LA FACTURE APRES DEDUCTION FRANCHISE",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",null,"SOLDE DE LA FACTURE APRES DEDUCTION FRANCHISE - 10%",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","","NON REMBOURSE ",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","","OPTIONS CONDITIONNELLES",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","","VOIR SUSPENDS",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","","FACTURE PAYEE DIRECTEMENT PAR L'ASSURANCE AVEC SOLDE DE PARTICIPATION",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","","REMBOURSEMENT NON PRIS EN CHARGE PAR L'ASSURANCE",0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",null,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",{"$f":"IF(P35<0,P35,\"\")","v":""},null,{"$f":"ABS(P35)","v":0},0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"",{"$f":"IF(P36<0,P36,\"\")","v":""},null,{"$f":"ABS(P36)","v":0},0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,{"$f":"ABS(P37)","v":0},0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,{"$f":"Q41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,{"$f":"Q50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"","",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!>0,K60-T60,\"\")","v":{"$error":"#REF!"}},"",null,null,0,null,{"$f":"O60","v":"00:00:00"},0]
[null,null,null,null,null,null,null,"SOUS TOTAUX",null,{"$f":"SUM(J7:J60)","v":0},{"$f":"SUM(K7:K60)","v":0},null,null,null,null,{"$f":"SUMIF(P7:P59,\">0\",P7:P59)","v":0},null,{"$f":"SUMIF(R7:R60,\">0\",R7:R60)","v":0},null,null,{"$f":"SUM(U7:U35)","v":0},{"$f":"SUM(V7:V35)","v":0},{"$f":"SUM(W7:W35)","v":0},{"$f":"SUM(X7:X35)","v":0},null,{"$f":"SUM(Z7:Z35)","v":0}]
[null,{"$f":"DONNEES!D10","v":300},null,null,null,null,null,{"$f":"\"SOUS (APRES) DEDUCTION DE LA FRANCHISE \"&B62","v":"SOUS (APRES) DEDUCTION DE LA FRANCHISE 300"},null,{"$f":"ABS(K61-F2)","v":300},{"$f":"K61+K4","v":0},null,null,"TOTAL PAGE UNE & DEUX",{"$f":"IF(P62<0,\"TROP PERCU POUR LA FRANCHISE\",IF(P62>0,\"ABSORTION DE LA FRANCHISE\",\"\"))","v":"ABSORTION DE LA FRANCHISE"},{"$f":"SUM(B62-O66)","v":300},{"$f":"P62*10%","v":30},{"$f":"W61","v":0}]
[null,{"$f":"Q61","v":0},null,null,null,null,null,"SOUS DEDUCTION DES PARTICIPATIONS",null,{"$f":"B63","v":0}]
[null,{"$f":"R62","v":0},null,null,null,null,null,"MONTANTS NON PRIS EN CHARGE",null,{"$f":"R62","v":0}]
[null,null,null,null,null,null,null,"SOLDE INTEMEDIAIRE ASSURA",null,{"$f":"J62-J63-J64","v":300},null,null,null,null,"Solde calculé - Solde payé",{"$f":"P61","v":0},"-",{"$f":"U61","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(J66>0,\"SOLDE A MA CHARGE\",IF(J66<0,\"SOLDE EN MA FAVEUR\"))","v":"SOLDE EN MA FAVEUR"},null,{"$f":"K61-B62-B63-B64","v":-300},null,null,null,"MONTANTS RETENUS POUR LA FRANCHISE",{"$f":"'DECOMPTE 1'!W4","v":0},"Mes avances sous déduction du montant réellement payé par l'assureur.",null,{"$f":"'RECAPITULATION (1)'!D80","v":0}]
[]
[null,null,null,null,null,null,null,"Total des montants reconnu par l'assurance",null,{"$f":"Z61","v":0}]
[null,null,null,null,null,null,null,"Moins franchise",null,{"$f":"B62","v":300}]
[]
[null,null,null,null,null,null,null,"Moins participation",null,{"$f":"B63","v":0}]
[null,null,null,null,null,null,null,"Montant à rembourser",null,{"$f":"J68-J69-J71","v":-300}]
[]
[null,null,null,null,null,null,null,"- Remboursement de l'assurance",null,{"$f":"R65","v":0}]
[null,null,null,null,null,null,null,"Solde actuel ",null,{"$f":"J72-J74","v":-300}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aucun"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pas de décompte"]

{"sheet":"RESUME","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,1,0,4],[11,1,11,3],[8,5,8,7],[4,5,4,7],[6,5,6,7],[9,5,9,8]]}
[null,"RESUME DES DIVERS CALCULS"]
[]
[null,"MONTANT RECCONU PAR L'ASSURANCE",null,null,{"$f":"'DECOMPTE 1'!Y59","v":0},"MONTANT TOTAL DES FACTURES ",null,null,{"$f":"'DECOMPTE 1'!I59","v":0}]
[]
[null,"SOUS DEDUCTION DE LA FRANCHISE",null,null,{"$f":"ABS('DECOMPTE 1'!W59)","v":0},"SOLDE DES FACTURES ENCORE A REMBOURSER",null,null,{"$f":"'DECOMPTE 1'!J59","v":0}]
[null,"SOUS TOTAL FRANCHISE DEDUITE",null,null,{"$f":"E3-E5","v":0}]
[null,null,null,null,null,"MONTANT DES FACTURES REMBOURSEES",null,null,{"$f":"'DECOMPTE 1'!T59","v":421.55000000000007}]
[null,"SOUS DEDUCTION DU POUCENTAGE DE PARTICIPATION",null,null,{"$f":"'DECOMPTE 1'!P59","v":0}]
[null,"MONTANT A REGLER PAR L'ASSURANCE",null,null,{"$f":"E6-E8","v":0},"SOLDE FACTURE EN SUSPEND :\n SANS DEDUCTION DU 10 %",null,null,{"$f":"I3-I7","v":-421.55000000000007}]
[null,null,null,null,null,"CECI EST UNE ESTIMATION PONCTUELLE A CE JOUR"]
[null,"PART REMBOURSEE PAR L'ASSURANCE",null,null,{"$f":"'DECOMPTE 1'!I69","v":421.55000000000007}]
[null,{"$f":"IF(E12>0,\"EXCEDENT DE L'ASSURANCE\",\"SOLDE ACTUEL EN MA FAVEUR \nDES MONTANTS EN ATTENTES\")","v":"SOLDE ACTUEL EN MA FAVEUR \nDES MONTANTS EN ATTENTES"},null,null,{"$f":"'DECOMPTE 1'!I70","v":-721.55000000000007}]

{"sheet":"LETTRE D'ENVOI","index":3,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[15,1,15,3],[36,1,36,7],[22,1,22,7],[24,1,24,7],[26,1,26,7],[34,1,34,7],[30,1,30,7],[31,1,31,7],[32,1,32,7],[18,1,19,3]]}
[]
[]
[null,{"$f":"'DECOMPTE 1'!H2","v":"Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939"}]
[]
[]
[null,{"$f":"IF(B3=DONNEES!F3,DONNEES!D18,IF(B3=DONNEES!F4,DONNEES!D19))","v":"Georges VOCAT"},null,null,null,"Nyon le",{"$f":"TODAY()","v":"2023-12-03"}]
[null,{"$f":"DONNEES!B10","v":"Rue de la Fléchère 17"}]
[null,{"$f":"DONNEES!B11","v":"CH-1260  NYON"}]
[]
[null,{"$f":"DONNEES!B14","v":"CCP - 12-56914-9"},null,null,null,{"$f":"DONNEES!D3","v":" ASSURA"}]
[null,"Mail : ghv1260@outlook.com",null,null,null,{"$f":"DONNEES!D4","v":"Assura-Basis SA"}]
[null,null,null,null,null,{"$f":"DONNEES!D5","v":"Case Postale 4"}]
[null,null,null,null,null,{"$f":"DONNEES!D6","v":"CH-1052  Le Mont-sur-Lausanne"}]
[]
[]
[null,"Concerne : TRAITEMENT(S)",null,null,{"$f":"DONNEES!B18","v":2024}]
[]
[]
[null,"G 18\n\nPHARMACIE SUN STORE\n\n34.80"]
[]
[]
[]
[]
[]
[]
[]
[null,"En vous remerciant de me faire parvenir votre participation."]
[]
[null,"-"]
[]
[]
[]
[]
[]
[null,"Avec l'expression de mes salutations les meilleures."]
[]
[null,"Georges Vocat"]

{"sheet":"RECAPITULATION (1)","index":4,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[[77,5,77,7],[80,1,80,2],[82,1,82,2],[83,1,83,2],[79,6,79,7],[81,1,81,4],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2]]}
[]
[]
[]
[]
[null,null,{"$f":"'DECOMPTE 1'!H2","v":"Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939"},"Facturation\ntotale décompte 1",null,{"$f":"'DECOMPTE 1'!T3","v":"Montants Réellement payé par l'Assurance"},"Montant non \npris en charge\npar l'assurance",{"$f":"'DECOMPTE 1'!W3","v":"Addition des montants pour Franchise & non payment Divers"}]
[null,{"$f":"'DECOMPTE 1'!G5","v":0},{"$f":"'DECOMPTE 1'!H5","v":0},{"$f":"'DECOMPTE 1'!I5","v":0},{"$f":"'DECOMPTE 1'!O5","v":0},{"$f":"'DECOMPTE 1'!T5","v":0},{"$f":"'DECOMPTE 1'!V5","v":0},{"$f":"'DECOMPTE 1'!W5","v":""}]
[null,{"$f":"'DECOMPTE 1'!G6","v":0},{"$f":"'DECOMPTE 1'!H6","v":0},{"$f":"'DECOMPTE 1'!I6","v":0},{"$f":"'DECOMPTE 1'!O6","v":0},{"$f":"'DECOMPTE 1'!T6","v":0},{"$f":"'DECOMPTE 1'!V6","v":0},{"$f":"'DECOMPTE 1'!W6","v":""}]
[null,{"$f":"'DECOMPTE 1'!G7","v":0},{"$f":"'DECOMPTE 1'!H7","v":0},{"$f":"'DECOMPTE 1'!I7","v":0},{"$f":"'DECOMPTE 1'!O7","v":0},{"$f":"'DECOMPTE 1'!T7","v":0},{"$f":"'DECOMPTE 1'!V7","v":0},{"$f":"'DECOMPTE 1'!W7","v":""}]
[null,{"$f":"'DECOMPTE 1'!G8","v":0},{"$f":"'DECOMPTE 1'!H8","v":0},{"$f":"'DECOMPTE 1'!I8","v":0},{"$f":"'DECOMPTE 1'!O8","v":0},{"$f":"'DECOMPTE 1'!T8","v":0},{"$f":"'DECOMPTE 1'!V8","v":0},{"$f":"'DECOMPTE 1'!W8","v":""}]
[null,{"$f":"'DECOMPTE 1'!G9","v":0},{"$f":"'DECOMPTE 1'!H9","v":0},{"$f":"'DECOMPTE 1'!I9","v":0},{"$f":"'DECOMPTE 1'!O9","v":0},{"$f":"'DECOMPTE 1'!T9","v":0},{"$f":"'DECOMPTE 1'!V9","v":0},{"$f":"'DECOMPTE 1'!W9","v":""}]
[null,{"$f":"'DECOMPTE 1'!G10","v":0},{"$f":"'DECOMPTE 1'!H10","v":0},{"$f":"'DECOMPTE 1'!I10","v":0},{"$f":"'DECOMPTE 1'!O10","v":0},{"$f":"'DECOMPTE 1'!T10","v":0},{"$f":"'DECOMPTE 1'!V10","v":0},{"$f":"'DECOMPTE 1'!W10","v":""}]
[null,{"$f":"'DECOMPTE 1'!G11","v":0},{"$f":"'DECOMPTE 1'!H11","v":0},{"$f":"'DECOMPTE 1'!I11","v":0},{"$f":"'DECOMPTE 1'!O11","v":0},{"$f":"'DECOMPTE 1'!T11","v":0},{"$f":"'DECOMPTE 1'!V11","v":0},{"$f":"'DECOMPTE 1'!W11","v":""}]
[null,{"$f":"'DECOMPTE 1'!G12","v":0},{"$f":"'DECOMPTE 1'!H12","v":0},{"$f":"'DECOMPTE 1'!I12","v":0},{"$f":"'DECOMPTE 1'!O12","v":0},{"$f":"'DECOMPTE 1'!T12","v":0},{"$f":"'DECOMPTE 1'!V12","v":0},{"$f":"'DECOMPTE 1'!W12","v":""}]
[null,{"$f":"'DECOMPTE 1'!G13","v":0},{"$f":"'DECOMPTE 1'!H13","v":0},{"$f":"'DECOMPTE 1'!I13","v":0},{"$f":"'DECOMPTE 1'!O13","v":0},{"$f":"'DECOMPTE 1'!T13","v":0},{"$f":"'DECOMPTE 1'!V13","v":0},{"$f":"'DECOMPTE 1'!W13","v":""}]
[null,{"$f":"'DECOMPTE 1'!G14","v":0},{"$f":"'DECOMPTE 1'!H14","v":0},{"$f":"'DECOMPTE 1'!I14","v":0},{"$f":"'DECOMPTE 1'!O14","v":0},{"$f":"'DECOMPTE 1'!T14","v":19.100000000000001},{"$f":"'DECOMPTE 1'!V14","v":0},{"$f":"'DECOMPTE 1'!W14","v":""}]
[null,{"$f":"'DECOMPTE 1'!G15","v":0},{"$f":"'DECOMPTE 1'!H15","v":0},{"$f":"'DECOMPTE 1'!I15","v":0},{"$f":"'DECOMPTE 1'!O15","v":0},{"$f":"'DECOMPTE 1'!T15","v":6.95},{"$f":"'DECOMPTE 1'!V15","v":0},{"$f":"'DECOMPTE 1'!W15","v":""}]
[null,{"$f":"'DECOMPTE 1'!G16","v":0},{"$f":"'DECOMPTE 1'!H16","v":0},{"$f":"'DECOMPTE 1'!I16","v":0},{"$f":"'DECOMPTE 1'!O16","v":0},{"$f":"'DECOMPTE 1'!T16","v":129.25},{"$f":"'DECOMPTE 1'!V16","v":0},{"$f":"'DECOMPTE 1'!W16","v":""}]
[null,{"$f":"'DECOMPTE 1'!G17","v":0},{"$f":"'DECOMPTE 1'!H17","v":0},{"$f":"'DECOMPTE 1'!I17","v":0},{"$f":"'DECOMPTE 1'!O17","v":0},{"$f":"'DECOMPTE 1'!T17","v":104.15},{"$f":"'DECOMPTE 1'!V17","v":0},{"$f":"'DECOMPTE 1'!W17","v":""}]
[null,{"$f":"'DECOMPTE 1'!G18","v":0},{"$f":"'DECOMPTE 1'!H18","v":0},{"$f":"'DECOMPTE 1'!I18","v":0},{"$f":"'DECOMPTE 1'!O18","v":0},{"$f":"'DECOMPTE 1'!T18","v":0},{"$f":"'DECOMPTE 1'!V18","v":0},{"$f":"'DECOMPTE 1'!W18","v":""}]
[null,{"$f":"'DECOMPTE 1'!G19","v":0},{"$f":"'DECOMPTE 1'!H19","v":0},{"$f":"'DECOMPTE 1'!I19","v":0},{"$f":"'DECOMPTE 1'!O19","v":0},{"$f":"'DECOMPTE 1'!T19","v":13.95},{"$f":"'DECOMPTE 1'!V19","v":0},{"$f":"'DECOMPTE 1'!W19","v":""}]
[null,{"$f":"'DECOMPTE 1'!G20","v":0},{"$f":"'DECOMPTE 1'!H20","v":0},{"$f":"'DECOMPTE 1'!I20","v":0},{"$f":"'DECOMPTE 1'!O20","v":0},{"$f":"'DECOMPTE 1'!T20","v":31.3},{"$f":"'DECOMPTE 1'!V20","v":0},{"$f":"'DECOMPTE 1'!W20","v":""}]
[null,{"$f":"'DECOMPTE 1'!G21","v":0},{"$f":"'DECOMPTE 1'!H21","v":0},{"$f":"'DECOMPTE 1'!I21","v":0},{"$f":"'DECOMPTE 1'!O21","v":0},{"$f":"'DECOMPTE 1'!T21","v":5.3},{"$f":"'DECOMPTE 1'!V21","v":0},{"$f":"'DECOMPTE 1'!W21","v":""}]
[null,{"$f":"'DECOMPTE 1'!G22","v":0},{"$f":"'DECOMPTE 1'!H22","v":0},{"$f":"'DECOMPTE 1'!I22","v":0},{"$f":"'DECOMPTE 1'!O22","v":0},{"$f":"'DECOMPTE 1'!T22","v":111.55},{"$f":"'DECOMPTE 1'!V22","v":0},{"$f":"'DECOMPTE 1'!W22","v":""}]
[null,{"$f":"'DECOMPTE 1'!G23","v":0},{"$f":"'DECOMPTE 1'!H23","v":0},{"$f":"'DECOMPTE 1'!I23","v":0},{"$f":"'DECOMPTE 1'!O23","v":0},{"$f":"'DECOMPTE 1'!T23","v":0},{"$f":"'DECOMPTE 1'!V23","v":0},{"$f":"'DECOMPTE 1'!W23","v":""}]
[null,{"$f":"'DECOMPTE 1'!G24","v":0},{"$f":"'DECOMPTE 1'!H24","v":0},{"$f":"'DECOMPTE 1'!I24","v":0},{"$f":"'DECOMPTE 1'!O24","v":0},{"$f":"'DECOMPTE 1'!T24","v":0},{"$f":"'DECOMPTE 1'!V24","v":0},{"$f":"'DECOMPTE 1'!W24","v":""}]
[null,{"$f":"'DECOMPTE 1'!G25","v":0},{"$f":"'DECOMPTE 1'!H25","v":0},{"$f":"'DECOMPTE 1'!I25","v":0},{"$f":"'DECOMPTE 1'!O25","v":0},{"$f":"'DECOMPTE 1'!T25","v":0},{"$f":"'DECOMPTE 1'!V25","v":0},{"$f":"'DECOMPTE 1'!W25","v":""}]
[null,{"$f":"'DECOMPTE 1'!G26","v":0},{"$f":"'DECOMPTE 1'!H26","v":0},{"$f":"'DECOMPTE 1'!I26","v":0},{"$f":"'DECOMPTE 1'!O26","v":0},{"$f":"'DECOMPTE 1'!T26","v":0},{"$f":"'DECOMPTE 1'!V26","v":0},{"$f":"'DECOMPTE 1'!W26","v":""}]
[null,{"$f":"'DECOMPTE 1'!G27","v":0},{"$f":"'DECOMPTE 1'!H27","v":0},{"$f":"'DECOMPTE 1'!I27","v":0},{"$f":"'DECOMPTE 1'!O27","v":0},{"$f":"'DECOMPTE 1'!T27","v":0},{"$f":"'DECOMPTE 1'!V27","v":0},{"$f":"'DECOMPTE 1'!W27","v":""}]
[null,{"$f":"'DECOMPTE 1'!G28","v":0},{"$f":"'DECOMPTE 1'!H28","v":0},{"$f":"'DECOMPTE 1'!I28","v":0},{"$f":"'DECOMPTE 1'!O28","v":0},{"$f":"'DECOMPTE 1'!T28","v":0},{"$f":"'DECOMPTE 1'!V28","v":0},{"$f":"'DECOMPTE 1'!W28","v":0}]
[null,{"$f":"'DECOMPTE 1'!G29","v":0},{"$f":"'DECOMPTE 1'!H29","v":0},{"$f":"'DECOMPTE 1'!I29","v":0},{"$f":"'DECOMPTE 1'!O29","v":0},{"$f":"'DECOMPTE 1'!T29","v":0},{"$f":"'DECOMPTE 1'!V29","v":0},{"$f":"'DECOMPTE 1'!W29","v":0}]
[null,{"$f":"'DECOMPTE 1'!G30","v":0},{"$f":"'DECOMPTE 1'!H30","v":0},{"$f":"'DECOMPTE 1'!I30","v":0},{"$f":"'DECOMPTE 1'!O30","v":0},{"$f":"'DECOMPTE 1'!T30","v":0},{"$f":"'DECOMPTE 1'!V30","v":0},{"$f":"'DECOMPTE 1'!W30","v":0}]
[null,{"$f":"'DECOMPTE 1'!G31","v":0},{"$f":"'DECOMPTE 1'!H31","v":0},{"$f":"'DECOMPTE 1'!I31","v":0},{"$f":"'DECOMPTE 1'!O31","v":0},{"$f":"'DECOMPTE 1'!T31","v":0},{"$f":"'DECOMPTE 1'!V31","v":0},{"$f":"'DECOMPTE 1'!W31","v":0}]
[null,{"$f":"'DECOMPTE 1'!G32","v":0},{"$f":"'DECOMPTE 1'!H32","v":0},{"$f":"'DECOMPTE 1'!I32","v":0},{"$f":"'DECOMPTE 1'!O32","v":0},{"$f":"'DECOMPTE 1'!T32","v":0},{"$f":"'DECOMPTE 1'!V32","v":0},{"$f":"'DECOMPTE 1'!W32","v":0}]
[null,{"$f":"'DECOMPTE 1'!G33","v":0},{"$f":"'DECOMPTE 1'!H33","v":0},{"$f":"'DECOMPTE 1'!I33","v":0},{"$f":"'DECOMPTE 1'!O33","v":0},{"$f":"'DECOMPTE 1'!T33","v":0},{"$f":"'DECOMPTE 1'!V33","v":0},{"$f":"'DECOMPTE 1'!W33","v":""}]
[null,{"$f":"'DECOMPTE 1'!G34","v":0},{"$f":"'DECOMPTE 1'!H34","v":0},{"$f":"'DECOMPTE 1'!I34","v":0},{"$f":"'DECOMPTE 1'!O34","v":0},{"$f":"'DECOMPTE 1'!T34","v":0},{"$f":"'DECOMPTE 1'!V34","v":0},{"$f":"'DECOMPTE 1'!W34","v":""}]
[null,{"$f":"'DECOMPTE 1'!G35","v":0},{"$f":"'DECOMPTE 1'!H35","v":0},{"$f":"'DECOMPTE 1'!I35","v":0},{"$f":"'DECOMPTE 1'!O35","v":0},{"$f":"'DECOMPTE 1'!T35","v":0},{"$f":"'DECOMPTE 1'!V35","v":0},{"$f":"'DECOMPTE 1'!W35","v":""}]
[null,{"$f":"'DECOMPTE 1'!G36","v":0},{"$f":"'DECOMPTE 1'!H36","v":0},{"$f":"'DECOMPTE 1'!I36","v":0},{"$f":"'DECOMPTE 1'!O36","v":0},{"$f":"'DECOMPTE 1'!T36","v":0},{"$f":"'DECOMPTE 1'!V36","v":0},{"$f":"'DECOMPTE 1'!W36","v":""}]
[null,{"$f":"'DECOMPTE 1'!G37","v":0},{"$f":"'DECOMPTE 1'!H37","v":0},{"$f":"'DECOMPTE 1'!I37","v":0},{"$f":"'DECOMPTE 1'!O37","v":0},{"$f":"'DECOMPTE 1'!T37","v":0},{"$f":"'DECOMPTE 1'!V37","v":0},{"$f":"'DECOMPTE 1'!W37","v":""}]
[null,{"$f":"'DECOMPTE 1'!G38","v":0},{"$f":"'DECOMPTE 1'!H38","v":0},{"$f":"'DECOMPTE 1'!I38","v":0},{"$f":"'DECOMPTE 1'!O38","v":0},{"$f":"'DECOMPTE 1'!T38","v":0},{"$f":"'DECOMPTE 1'!V38","v":0},{"$f":"'DECOMPTE 1'!W38","v":""}]
[null,{"$f":"'DECOMPTE 1'!G39","v":0},{"$f":"'DECOMPTE 1'!H39","v":0},{"$f":"'DECOMPTE 1'!I39","v":0},{"$f":"'DECOMPTE 1'!O39","v":0},{"$f":"'DECOMPTE 1'!T39","v":0},{"$f":"'DECOMPTE 1'!V39","v":0},{"$f":"'DECOMPTE 1'!W39","v":""}]
[null,{"$f":"'DECOMPTE 1'!G40","v":0},{"$f":"'DECOMPTE 1'!H40","v":0},{"$f":"'DECOMPTE 1'!I40","v":0},{"$f":"'DECOMPTE 1'!O40","v":0},{"$f":"'DECOMPTE 1'!T40","v":0},{"$f":"'DECOMPTE 1'!V40","v":0},{"$f":"'DECOMPTE 1'!W40","v":""}]
[null,{"$f":"'DECOMPTE 1'!G41","v":0},{"$f":"'DECOMPTE 1'!H41","v":0},{"$f":"'DECOMPTE 1'!I41","v":0},{"$f":"'DECOMPTE 1'!O41","v":0},{"$f":"'DECOMPTE 1'!T41","v":0},{"$f":"'DECOMPTE 1'!V41","v":0},{"$f":"'DECOMPTE 1'!W41","v":""}]
[null,{"$f":"'DECOMPTE 1'!G42","v":0},{"$f":"'DECOMPTE 1'!H42","v":0},{"$f":"'DECOMPTE 1'!I42","v":0},{"$f":"'DECOMPTE 1'!O42","v":0},{"$f":"'DECOMPTE 1'!T42","v":0},{"$f":"'DECOMPTE 1'!V42","v":0},{"$f":"'DECOMPTE 1'!W42","v":""}]
[null,{"$f":"'DECOMPTE 1'!G43","v":0},{"$f":"'DECOMPTE 1'!H43","v":0},{"$f":"'DECOMPTE 1'!I43","v":0},{"$f":"'DECOMPTE 1'!O43","v":0},{"$f":"'DECOMPTE 1'!T43","v":0},{"$f":"'DECOMPTE 1'!V43","v":0},{"$f":"'DECOMPTE 1'!W43","v":""}]
[null,{"$f":"'DECOMPTE 1'!G44","v":0},{"$f":"'DECOMPTE 1'!H44","v":0},{"$f":"'DECOMPTE 1'!I44","v":0},{"$f":"'DECOMPTE 1'!O44","v":0},{"$f":"'DECOMPTE 1'!T44","v":0},{"$f":"'DECOMPTE 1'!V44","v":0},{"$f":"'DECOMPTE 1'!W44","v":""}]
[null,{"$f":"'DECOMPTE 1'!G45","v":0},{"$f":"'DECOMPTE 1'!H45","v":0},{"$f":"'DECOMPTE 1'!I45","v":0},{"$f":"'DECOMPTE 1'!O45","v":0},{"$f":"'DECOMPTE 1'!T45","v":0},{"$f":"'DECOMPTE 1'!V45","v":0},{"$f":"'DECOMPTE 1'!W45","v":""}]
[null,{"$f":"'DECOMPTE 1'!G46","v":0},{"$f":"'DECOMPTE 1'!H46","v":0},{"$f":"'DECOMPTE 1'!I46","v":0},{"$f":"'DECOMPTE 1'!O46","v":0},{"$f":"'DECOMPTE 1'!T46","v":0},{"$f":"'DECOMPTE 1'!V46","v":0},{"$f":"'DECOMPTE 1'!W46","v":""}]
[null,{"$f":"'DECOMPTE 1'!G47","v":0},{"$f":"'DECOMPTE 1'!H47","v":0},{"$f":"'DECOMPTE 1'!I47","v":0},{"$f":"'DECOMPTE 1'!O47","v":0},{"$f":"'DECOMPTE 1'!T47","v":0},{"$f":"'DECOMPTE 1'!V47","v":0},{"$f":"'DECOMPTE 1'!W47","v":""}]
[null,{"$f":"'DECOMPTE 1'!G48","v":0},{"$f":"'DECOMPTE 1'!H48","v":0},{"$f":"'DECOMPTE 1'!I48","v":0},{"$f":"'DECOMPTE 1'!O48","v":0},{"$f":"'DECOMPTE 1'!T48","v":0},{"$f":"'DECOMPTE 1'!V48","v":0},{"$f":"'DECOMPTE 1'!W48","v":""}]
[null,{"$f":"'DECOMPTE 1'!G49","v":0},{"$f":"'DECOMPTE 1'!H49","v":0},{"$f":"'DECOMPTE 1'!I49","v":0},{"$f":"'DECOMPTE 1'!O49","v":0},{"$f":"'DECOMPTE 1'!T49","v":0},{"$f":"'DECOMPTE 1'!V49","v":0},{"$f":"'DECOMPTE 1'!W49","v":""}]
[null,{"$f":"'DECOMPTE 1'!G50","v":0},{"$f":"'DECOMPTE 1'!H50","v":0},{"$f":"'DECOMPTE 1'!I50","v":0},{"$f":"'DECOMPTE 1'!O50","v":0},{"$f":"'DECOMPTE 1'!T50","v":0},{"$f":"'DECOMPTE 1'!V50","v":0},{"$f":"'DECOMPTE 1'!W50","v":""}]
[null,{"$f":"'DECOMPTE 1'!G51","v":0},{"$f":"'DECOMPTE 1'!H51","v":0},{"$f":"'DECOMPTE 1'!I51","v":0},{"$f":"'DECOMPTE 1'!O51","v":0},{"$f":"'DECOMPTE 1'!T51","v":0},{"$f":"'DECOMPTE 1'!V51","v":0},{"$f":"'DECOMPTE 1'!W51","v":""}]
[null,{"$f":"'DECOMPTE 1'!G52","v":0},{"$f":"'DECOMPTE 1'!H52","v":0},{"$f":"'DECOMPTE 1'!I52","v":0},{"$f":"'DECOMPTE 1'!O52","v":0},{"$f":"'DECOMPTE 1'!T52","v":0},{"$f":"'DECOMPTE 1'!V52","v":0},{"$f":"'DECOMPTE 1'!W52","v":""}]
[null,{"$f":"'DECOMPTE 1'!G53","v":0},{"$f":"'DECOMPTE 1'!H53","v":0},{"$f":"'DECOMPTE 1'!I53","v":0},{"$f":"'DECOMPTE 1'!O53","v":0},{"$f":"'DECOMPTE 1'!T53","v":0},{"$f":"'DECOMPTE 1'!V53","v":0},{"$f":"'DECOMPTE 1'!W53","v":""}]
[null,{"$f":"'DECOMPTE 1'!G54","v":0},{"$f":"'DECOMPTE 1'!H54","v":0},{"$f":"'DECOMPTE 1'!I54","v":0},{"$f":"'DECOMPTE 1'!O54","v":0},{"$f":"'DECOMPTE 1'!T54","v":0},{"$f":"'DECOMPTE 1'!V54","v":0},{"$f":"'DECOMPTE 1'!W54","v":""}]
[null,{"$f":"'DECOMPTE 1'!G55","v":0},{"$f":"'DECOMPTE 1'!H55","v":0},{"$f":"'DECOMPTE 1'!I55","v":0},{"$f":"'DECOMPTE 1'!O55","v":0},{"$f":"'DECOMPTE 1'!T55","v":0},{"$f":"'DECOMPTE 1'!V55","v":0},{"$f":"'DECOMPTE 1'!W55","v":""}]
[null,{"$f":"'DECOMPTE 2'!G7","v":0},{"$f":"'DECOMPTE 1'!H56","v":0},{"$f":"'DECOMPTE 1'!I56","v":0},{"$f":"'DECOMPTE 1'!O56","v":0},{"$f":"'DECOMPTE 1'!T56","v":0},{"$f":"'DECOMPTE 1'!V56","v":0},{"$f":"'DECOMPTE 1'!W56","v":""}]
[null,{"$f":"'DECOMPTE 2'!G8","v":0},{"$f":"'DECOMPTE 1'!H57","v":0},{"$f":"'DECOMPTE 1'!I57","v":0},{"$f":"'DECOMPTE 1'!O57","v":0},{"$f":"'DECOMPTE 1'!T57","v":0},{"$f":"'DECOMPTE 1'!V57","v":0},{"$f":"'DECOMPTE 1'!W57","v":""}]
[null,{"$f":"'DECOMPTE 2'!G7","v":0},"='DECOMPTE 2'!H7",{"$f":"'DECOMPTE 2'!K7","v":0},{"$f":"'DECOMPTE 2'!K7","v":0},{"$f":"'DECOMPTE 2'!L7","v":0},{"$f":"'DECOMPTE 2'!M7","v":0},{"$f":"'DECOMPTE 2'!N7","v":0}]
[null,{"$f":"'DECOMPTE 2'!G8","v":0},"='DECOMPTE 2'!H8","='DECOMPTE 2'!H9","='DECOMPTE 2'!H10","='DECOMPTE 2'!H11","='DECOMPTE 2'!H12","='DECOMPTE 2'!H13"]
[null,{"$f":"'DECOMPTE 2'!G9","v":0},"='DECOMPTE 2'!H9"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'DECOMPTE 2'!G10","v":0},null,{"$f":"'DECOMPTE 1'!I58","v":0},{"$f":"'DECOMPTE 1'!O58","v":0},{"$f":"'DECOMPTE 1'!T58","v":0},{"$f":"'DECOMPTE 1'!V58","v":0},{"$f":"'DECOMPTE 1'!W58","v":0}]
[null,null,"OPERATIONS",{"$f":"'DECOMPTE 2'!J4","v":0},{"$f":"'DECOMPTE 2'!P6","v":0},{"$f":"'DECOMPTE 1'!L4","v":0},{"$f":"'DECOMPTE 2'!P5","v":0},{"$f":"(SUM(H6:H34))","v":0}]
[]
[]
[]
[null,"MONTANTS DES OPERATIONS : ",null,{"$f":"D72","v":0},null,{"$f":"'DECOMPTE 2'!U61+'DECOMPTE 1'!T4","v":421.55000000000007},{"$f":"'DECOMPTE 2'!W6","v":0},{"$f":"'DECOMPTE 2'!X6","v":0}]
[null,"MOINS DECOMPTE FRANCHISE\n Y C P  DIVERS FRAIS A MA CHARGE",null,{"$f":"ABS('DECOMPTE 1'!W59)","v":0}]
[null,"SOUS TOTAL ",null,{"$f":"D76-D77","v":0},{"$f":"D78-D79","v":0},{"$f":"G80","v":"MONTANT DEDUCTIBLE\n DES IMPOTS Y.C.P. 10 %"}]
[null," MA PARTICIPATION 10 %",null,{"$f":"'DECOMPTE 1'!P59","v":0}]
[null,"SOLDE DE DIFFERENCE ENTRE MES AVANCES ET LES REMBOURSEMENTS",null,{"$f":"'DECOMPTE 2'!W6+'DECOMPTE 1'!W4","v":0},"NON PRIS EN\nCHARGE PAR L'ASSUREUR","FRANCHISE\nPARTICIPATIONS\nNON PRIS EN CHARGE","MONTANT DEDUCTIBLE\n DES IMPOTS Y.C.P. 10 %"]
[]
[null,"MONTANT REELEMENT REMBOURSE PAR L'ASSURANCE",null,null,null,null,null,{"$f":"'DECOMPTE 1'!Q59","v":0}]

{"sheet":"RECAPITULATION (2)","index":5,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":false,"merged":[[81,1,81,2],[82,1,82,2],[83,1,83,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[77,5,77,6],[78,1,78,2],[79,1,79,2],[79,6,79,7],[80,1,80,2]]}
[]
[]
[]
[]
[null,null,{"$f":"'DECOMPTE 1'!H2","v":"Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939"},"Facturation\ntotale décompte 2",{"$f":"'DECOMPTE 1'!O3","v":"Montants  après DEDUCTIONS OU\nNON REMBOURSE\nOU FRANCHISE EN NEGATIF"},{"$f":"'DECOMPTE 1'!T3","v":"Montants Réellement payé par l'Assurance"},"Montant non \npris en charge\npar l'assurance",{"$f":"'DECOMPTE 1'!W3","v":"Addition des montants pour Franchise & non payment Divers"}]
[null,{"$f":"'DECOMPTE 1'!G5","v":0},{"$f":"'DECOMPTE 1'!H5","v":0},{"$f":"'DECOMPTE 1'!I5","v":0},{"$f":"'DECOMPTE 1'!O5","v":0},{"$f":"'DECOMPTE 1'!T5","v":0},{"$f":"'DECOMPTE 1'!V5","v":0},{"$f":"'DECOMPTE 1'!W5","v":""}]
[null,{"$f":"'DECOMPTE 1'!G6","v":0},{"$f":"'DECOMPTE 1'!H6","v":0},{"$f":"'DECOMPTE 1'!I6","v":0},{"$f":"'DECOMPTE 1'!O6","v":0},{"$f":"'DECOMPTE 1'!T6","v":0},{"$f":"'DECOMPTE 1'!V6","v":0},{"$f":"'DECOMPTE 1'!W6","v":""}]
[null,{"$f":"'DECOMPTE 1'!G7","v":0},{"$f":"'DECOMPTE 1'!H7","v":0},{"$f":"'DECOMPTE 1'!I7","v":0},{"$f":"'DECOMPTE 1'!O7","v":0},{"$f":"'DECOMPTE 1'!T7","v":0},{"$f":"'DECOMPTE 1'!V7","v":0},{"$f":"'DECOMPTE 1'!W7","v":""}]
[null,{"$f":"'DECOMPTE 1'!G8","v":0},{"$f":"'DECOMPTE 1'!H8","v":0},{"$f":"'DECOMPTE 1'!I8","v":0},{"$f":"'DECOMPTE 1'!O8","v":0},{"$f":"'DECOMPTE 1'!T8","v":0},{"$f":"'DECOMPTE 1'!V8","v":0},{"$f":"'DECOMPTE 1'!W8","v":""}]
[null,{"$f":"'DECOMPTE 1'!G9","v":0},{"$f":"'DECOMPTE 1'!H9","v":0},{"$f":"'DECOMPTE 1'!I9","v":0},{"$f":"'DECOMPTE 1'!O9","v":0},{"$f":"'DECOMPTE 1'!T9","v":0},{"$f":"'DECOMPTE 1'!V9","v":0},{"$f":"'DECOMPTE 1'!W9","v":""}]
[null,{"$f":"'DECOMPTE 1'!G10","v":0},{"$f":"'DECOMPTE 1'!H10","v":0},{"$f":"'DECOMPTE 1'!I10","v":0},{"$f":"'DECOMPTE 1'!O10","v":0},{"$f":"'DECOMPTE 1'!T10","v":0},{"$f":"'DECOMPTE 1'!V10","v":0},{"$f":"'DECOMPTE 1'!W10","v":""}]
[null,{"$f":"'DECOMPTE 1'!G11","v":0},{"$f":"'DECOMPTE 1'!H11","v":0},{"$f":"'DECOMPTE 1'!I11","v":0},{"$f":"'DECOMPTE 1'!O11","v":0},{"$f":"'DECOMPTE 1'!T11","v":0},{"$f":"'DECOMPTE 1'!V11","v":0},{"$f":"'DECOMPTE 1'!W11","v":""}]
[null,{"$f":"'DECOMPTE 1'!G12","v":0},{"$f":"'DECOMPTE 1'!H12","v":0},{"$f":"'DECOMPTE 1'!I12","v":0},{"$f":"'DECOMPTE 1'!O12","v":0},{"$f":"'DECOMPTE 1'!T12","v":0},{"$f":"'DECOMPTE 1'!V12","v":0},{"$f":"'DECOMPTE 1'!W12","v":""}]
[null,{"$f":"'DECOMPTE 1'!G13","v":0},{"$f":"'DECOMPTE 1'!H13","v":0},{"$f":"'DECOMPTE 1'!I13","v":0},{"$f":"'DECOMPTE 1'!O13","v":0},{"$f":"'DECOMPTE 1'!T13","v":0},{"$f":"'DECOMPTE 1'!V13","v":0},{"$f":"'DECOMPTE 1'!W13","v":""}]
[null,{"$f":"'DECOMPTE 1'!G14","v":0},{"$f":"'DECOMPTE 1'!H14","v":0},{"$f":"'DECOMPTE 1'!I14","v":0},{"$f":"'DECOMPTE 1'!O14","v":0},{"$f":"'DECOMPTE 1'!T14","v":19.100000000000001},{"$f":"'DECOMPTE 1'!V14","v":0},{"$f":"'DECOMPTE 1'!W14","v":""}]
[null,{"$f":"'DECOMPTE 1'!G15","v":0},{"$f":"'DECOMPTE 1'!H15","v":0},{"$f":"'DECOMPTE 1'!I15","v":0},{"$f":"'DECOMPTE 1'!O15","v":0},{"$f":"'DECOMPTE 1'!T15","v":6.95},{"$f":"'DECOMPTE 1'!V15","v":0},{"$f":"'DECOMPTE 1'!W15","v":""}]
[null,{"$f":"'DECOMPTE 1'!G16","v":0},{"$f":"'DECOMPTE 1'!H16","v":0},{"$f":"'DECOMPTE 1'!I16","v":0},{"$f":"'DECOMPTE 1'!O16","v":0},{"$f":"'DECOMPTE 1'!T16","v":129.25},{"$f":"'DECOMPTE 1'!V16","v":0},{"$f":"'DECOMPTE 1'!W16","v":""}]
[null,{"$f":"'DECOMPTE 1'!G17","v":0},{"$f":"'DECOMPTE 1'!H17","v":0},{"$f":"'DECOMPTE 1'!I17","v":0},{"$f":"'DECOMPTE 1'!O17","v":0},{"$f":"'DECOMPTE 1'!T17","v":104.15},{"$f":"'DECOMPTE 1'!V17","v":0},{"$f":"'DECOMPTE 1'!W17","v":""}]
[null,{"$f":"'DECOMPTE 1'!G18","v":0},{"$f":"'DECOMPTE 1'!H18","v":0},{"$f":"'DECOMPTE 1'!I18","v":0},{"$f":"'DECOMPTE 1'!O18","v":0},{"$f":"'DECOMPTE 1'!T18","v":0},{"$f":"'DECOMPTE 1'!V18","v":0},{"$f":"'DECOMPTE 1'!W18","v":""}]
[null,{"$f":"'DECOMPTE 1'!G19","v":0},{"$f":"'DECOMPTE 1'!H19","v":0},{"$f":"'DECOMPTE 1'!I19","v":0},{"$f":"'DECOMPTE 1'!O19","v":0},{"$f":"'DECOMPTE 1'!T19","v":13.95},{"$f":"'DECOMPTE 1'!V19","v":0},{"$f":"'DECOMPTE 1'!W19","v":""}]
[null,{"$f":"'DECOMPTE 1'!G20","v":0},{"$f":"'DECOMPTE 1'!H20","v":0},{"$f":"'DECOMPTE 1'!I20","v":0},{"$f":"'DECOMPTE 1'!O20","v":0},{"$f":"'DECOMPTE 1'!T20","v":31.3},{"$f":"'DECOMPTE 1'!V20","v":0},{"$f":"'DECOMPTE 1'!W20","v":""}]
[null,{"$f":"'DECOMPTE 1'!G21","v":0},{"$f":"'DECOMPTE 1'!H21","v":0},{"$f":"'DECOMPTE 1'!I21","v":0},{"$f":"'DECOMPTE 1'!O21","v":0},{"$f":"'DECOMPTE 1'!T21","v":5.3},{"$f":"'DECOMPTE 1'!V21","v":0},{"$f":"'DECOMPTE 1'!W21","v":""}]
[null,{"$f":"'DECOMPTE 1'!G22","v":0},{"$f":"'DECOMPTE 1'!H22","v":0},{"$f":"'DECOMPTE 1'!I22","v":0},{"$f":"'DECOMPTE 1'!O22","v":0},{"$f":"'DECOMPTE 1'!T22","v":111.55},{"$f":"'DECOMPTE 1'!V22","v":0},{"$f":"'DECOMPTE 1'!W22","v":""}]
[null,{"$f":"'DECOMPTE 1'!G23","v":0},{"$f":"'DECOMPTE 1'!H23","v":0},{"$f":"'DECOMPTE 1'!I23","v":0},{"$f":"'DECOMPTE 1'!O23","v":0},{"$f":"'DECOMPTE 1'!T23","v":0},{"$f":"'DECOMPTE 1'!V23","v":0},{"$f":"'DECOMPTE 1'!W23","v":""}]
[null,{"$f":"'DECOMPTE 1'!G24","v":0},{"$f":"'DECOMPTE 1'!H24","v":0},{"$f":"'DECOMPTE 1'!I24","v":0},{"$f":"'DECOMPTE 1'!O24","v":0},{"$f":"'DECOMPTE 1'!T24","v":0},{"$f":"'DECOMPTE 1'!V24","v":0},{"$f":"'DECOMPTE 1'!W24","v":""}]
[null,{"$f":"'DECOMPTE 1'!G25","v":0},{"$f":"'DECOMPTE 1'!H25","v":0},{"$f":"'DECOMPTE 1'!I25","v":0},{"$f":"'DECOMPTE 1'!O25","v":0},{"$f":"'DECOMPTE 1'!T25","v":0},{"$f":"'DECOMPTE 1'!V25","v":0},{"$f":"'DECOMPTE 1'!W25","v":""}]
[null,{"$f":"'DECOMPTE 1'!G26","v":0},{"$f":"'DECOMPTE 1'!H26","v":0},{"$f":"'DECOMPTE 1'!I26","v":0},{"$f":"'DECOMPTE 1'!O26","v":0},{"$f":"'DECOMPTE 1'!T26","v":0},{"$f":"'DECOMPTE 1'!V26","v":0},{"$f":"'DECOMPTE 1'!W26","v":""}]
[null,{"$f":"'DECOMPTE 1'!G27","v":0},{"$f":"'DECOMPTE 1'!H27","v":0},{"$f":"'DECOMPTE 1'!I27","v":0},{"$f":"'DECOMPTE 1'!O27","v":0},{"$f":"'DECOMPTE 1'!T27","v":0},{"$f":"'DECOMPTE 1'!V27","v":0},{"$f":"'DECOMPTE 1'!W27","v":""}]
[null,{"$f":"'DECOMPTE 1'!G28","v":0},{"$f":"'DECOMPTE 1'!H28","v":0},{"$f":"'DECOMPTE 1'!I28","v":0},{"$f":"'DECOMPTE 1'!O28","v":0},{"$f":"'DECOMPTE 1'!T28","v":0},{"$f":"'DECOMPTE 1'!V28","v":0},{"$f":"'DECOMPTE 1'!W28","v":0}]
[null,{"$f":"'DECOMPTE 1'!G29","v":0},{"$f":"'DECOMPTE 1'!H29","v":0},{"$f":"'DECOMPTE 1'!I29","v":0},{"$f":"'DECOMPTE 1'!O29","v":0},{"$f":"'DECOMPTE 1'!T29","v":0},{"$f":"'DECOMPTE 1'!V29","v":0},{"$f":"'DECOMPTE 1'!W29","v":0}]
[null,{"$f":"'DECOMPTE 1'!G30","v":0},{"$f":"'DECOMPTE 1'!H30","v":0},{"$f":"'DECOMPTE 1'!I30","v":0},{"$f":"'DECOMPTE 1'!O30","v":0},{"$f":"'DECOMPTE 1'!T30","v":0},{"$f":"'DECOMPTE 1'!V30","v":0},{"$f":"'DECOMPTE 1'!W30","v":0}]
[null,{"$f":"'DECOMPTE 1'!G31","v":0},{"$f":"'DECOMPTE 1'!H31","v":0},{"$f":"'DECOMPTE 1'!I31","v":0},{"$f":"'DECOMPTE 1'!O31","v":0},{"$f":"'DECOMPTE 1'!T31","v":0},{"$f":"'DECOMPTE 1'!V31","v":0},{"$f":"'DECOMPTE 1'!W31","v":0}]
[null,{"$f":"'DECOMPTE 1'!G32","v":0},{"$f":"'DECOMPTE 1'!H32","v":0},{"$f":"'DECOMPTE 1'!I32","v":0},{"$f":"'DECOMPTE 1'!O32","v":0},{"$f":"'DECOMPTE 1'!T32","v":0},{"$f":"'DECOMPTE 1'!V32","v":0},{"$f":"'DECOMPTE 1'!W32","v":0}]
[null,{"$f":"'DECOMPTE 1'!G33","v":0},{"$f":"'DECOMPTE 1'!H33","v":0},{"$f":"'DECOMPTE 1'!I33","v":0},{"$f":"'DECOMPTE 1'!O33","v":0},{"$f":"'DECOMPTE 1'!T33","v":0},{"$f":"'DECOMPTE 1'!V33","v":0},{"$f":"'DECOMPTE 1'!W33","v":""}]
[null,{"$f":"'DECOMPTE 1'!G34","v":0},{"$f":"'DECOMPTE 1'!H34","v":0},{"$f":"'DECOMPTE 1'!I34","v":0},{"$f":"'DECOMPTE 1'!O34","v":0},{"$f":"'DECOMPTE 1'!T34","v":0},{"$f":"'DECOMPTE 1'!V34","v":0},{"$f":"'DECOMPTE 1'!W34","v":""}]
[null,{"$f":"'DECOMPTE 1'!G35","v":0},{"$f":"'DECOMPTE 1'!H35","v":0},{"$f":"'DECOMPTE 1'!I35","v":0},{"$f":"'DECOMPTE 1'!O35","v":0},{"$f":"'DECOMPTE 1'!T35","v":0},{"$f":"'DECOMPTE 1'!V35","v":0},{"$f":"'DECOMPTE 1'!W35","v":""}]
[null,{"$f":"'DECOMPTE 1'!G36","v":0},{"$f":"'DECOMPTE 1'!H36","v":0},{"$f":"'DECOMPTE 1'!I36","v":0},{"$f":"'DECOMPTE 1'!O36","v":0},{"$f":"'DECOMPTE 1'!T36","v":0},{"$f":"'DECOMPTE 1'!V36","v":0},{"$f":"'DECOMPTE 1'!W36","v":""}]
[null,{"$f":"'DECOMPTE 1'!G37","v":0},{"$f":"'DECOMPTE 1'!H37","v":0},{"$f":"'DECOMPTE 1'!I37","v":0},{"$f":"'DECOMPTE 1'!O37","v":0},{"$f":"'DECOMPTE 1'!T37","v":0},{"$f":"'DECOMPTE 1'!V37","v":0},{"$f":"'DECOMPTE 1'!W37","v":""}]
[null,{"$f":"'DECOMPTE 1'!G38","v":0},{"$f":"'DECOMPTE 1'!H38","v":0},{"$f":"'DECOMPTE 1'!I38","v":0},{"$f":"'DECOMPTE 1'!O38","v":0},{"$f":"'DECOMPTE 1'!T38","v":0},{"$f":"'DECOMPTE 1'!V38","v":0},{"$f":"'DECOMPTE 1'!W38","v":""}]
[null,{"$f":"'DECOMPTE 1'!G39","v":0},{"$f":"'DECOMPTE 1'!H39","v":0},{"$f":"'DECOMPTE 1'!I39","v":0},{"$f":"'DECOMPTE 1'!O39","v":0},{"$f":"'DECOMPTE 1'!T39","v":0},{"$f":"'DECOMPTE 1'!V39","v":0},{"$f":"'DECOMPTE 1'!W39","v":""}]
[null,{"$f":"'DECOMPTE 1'!G40","v":0},{"$f":"'DECOMPTE 1'!H40","v":0},{"$f":"'DECOMPTE 1'!I40","v":0},{"$f":"'DECOMPTE 1'!O40","v":0},{"$f":"'DECOMPTE 1'!T40","v":0},{"$f":"'DECOMPTE 1'!V40","v":0},{"$f":"'DECOMPTE 1'!W40","v":""}]
[null,{"$f":"'DECOMPTE 1'!G41","v":0},{"$f":"'DECOMPTE 1'!H41","v":0},{"$f":"'DECOMPTE 1'!I41","v":0},{"$f":"'DECOMPTE 1'!O41","v":0},{"$f":"'DECOMPTE 1'!T41","v":0},{"$f":"'DECOMPTE 1'!V41","v":0},{"$f":"'DECOMPTE 1'!W41","v":""}]
[null,{"$f":"'DECOMPTE 1'!G42","v":0},{"$f":"'DECOMPTE 1'!H42","v":0},{"$f":"'DECOMPTE 1'!I42","v":0},{"$f":"'DECOMPTE 1'!O42","v":0},{"$f":"'DECOMPTE 1'!T42","v":0},{"$f":"'DECOMPTE 1'!V42","v":0},{"$f":"'DECOMPTE 1'!W42","v":""}]
[null,{"$f":"'DECOMPTE 1'!G43","v":0},{"$f":"'DECOMPTE 1'!H43","v":0},{"$f":"'DECOMPTE 1'!I43","v":0},{"$f":"'DECOMPTE 1'!O43","v":0},{"$f":"'DECOMPTE 1'!T43","v":0},{"$f":"'DECOMPTE 1'!V43","v":0},{"$f":"'DECOMPTE 1'!W43","v":""}]
[null,{"$f":"'DECOMPTE 1'!G44","v":0},{"$f":"'DECOMPTE 1'!H44","v":0},{"$f":"'DECOMPTE 1'!I44","v":0},{"$f":"'DECOMPTE 1'!O44","v":0},{"$f":"'DECOMPTE 1'!T44","v":0},{"$f":"'DECOMPTE 1'!V44","v":0},{"$f":"'DECOMPTE 1'!W44","v":""}]
[null,{"$f":"'DECOMPTE 1'!G45","v":0},{"$f":"'DECOMPTE 1'!H45","v":0},{"$f":"'DECOMPTE 1'!I45","v":0},{"$f":"'DECOMPTE 1'!O45","v":0},{"$f":"'DECOMPTE 1'!T45","v":0},{"$f":"'DECOMPTE 1'!V45","v":0},{"$f":"'DECOMPTE 1'!W45","v":""}]
[null,{"$f":"'DECOMPTE 1'!G46","v":0},{"$f":"'DECOMPTE 1'!H46","v":0},{"$f":"'DECOMPTE 1'!I46","v":0},{"$f":"'DECOMPTE 1'!O46","v":0},{"$f":"'DECOMPTE 1'!T46","v":0},{"$f":"'DECOMPTE 1'!V46","v":0},{"$f":"'DECOMPTE 1'!W46","v":""}]
[null,{"$f":"'DECOMPTE 1'!G47","v":0},{"$f":"'DECOMPTE 1'!H47","v":0},{"$f":"'DECOMPTE 1'!I47","v":0},{"$f":"'DECOMPTE 1'!O47","v":0},{"$f":"'DECOMPTE 1'!T47","v":0},{"$f":"'DECOMPTE 1'!V47","v":0},{"$f":"'DECOMPTE 1'!W47","v":""}]
[null,{"$f":"'DECOMPTE 1'!G48","v":0},{"$f":"'DECOMPTE 1'!H48","v":0},{"$f":"'DECOMPTE 1'!I48","v":0},{"$f":"'DECOMPTE 1'!O48","v":0},{"$f":"'DECOMPTE 1'!T48","v":0},{"$f":"'DECOMPTE 1'!V48","v":0},{"$f":"'DECOMPTE 1'!W48","v":""}]
[null,{"$f":"'DECOMPTE 1'!G49","v":0},{"$f":"'DECOMPTE 1'!H49","v":0},{"$f":"'DECOMPTE 1'!I49","v":0},{"$f":"'DECOMPTE 1'!O49","v":0},{"$f":"'DECOMPTE 1'!T49","v":0},{"$f":"'DECOMPTE 1'!V49","v":0},{"$f":"'DECOMPTE 1'!W49","v":""}]
[null,{"$f":"'DECOMPTE 1'!G50","v":0},{"$f":"'DECOMPTE 1'!H50","v":0},{"$f":"'DECOMPTE 1'!I50","v":0},{"$f":"'DECOMPTE 1'!O50","v":0},{"$f":"'DECOMPTE 1'!T50","v":0},{"$f":"'DECOMPTE 1'!V50","v":0},{"$f":"'DECOMPTE 1'!W50","v":""}]
[null,{"$f":"'DECOMPTE 1'!G51","v":0},{"$f":"'DECOMPTE 1'!H51","v":0},{"$f":"'DECOMPTE 1'!I51","v":0},{"$f":"'DECOMPTE 1'!O51","v":0},{"$f":"'DECOMPTE 1'!T51","v":0},{"$f":"'DECOMPTE 1'!V51","v":0},{"$f":"'DECOMPTE 1'!W51","v":""}]
[null,{"$f":"'DECOMPTE 1'!G52","v":0},{"$f":"'DECOMPTE 1'!H52","v":0},{"$f":"'DECOMPTE 1'!I52","v":0},{"$f":"'DECOMPTE 1'!O52","v":0},{"$f":"'DECOMPTE 1'!T52","v":0},{"$f":"'DECOMPTE 1'!V52","v":0},{"$f":"'DECOMPTE 1'!W52","v":""}]
[null,{"$f":"'DECOMPTE 1'!G53","v":0},{"$f":"'DECOMPTE 1'!H53","v":0},{"$f":"'DECOMPTE 1'!I53","v":0},{"$f":"'DECOMPTE 1'!O53","v":0},{"$f":"'DECOMPTE 1'!T53","v":0},{"$f":"'DECOMPTE 1'!V53","v":0},{"$f":"'DECOMPTE 1'!W53","v":""}]
[null,{"$f":"'DECOMPTE 1'!G54","v":0},{"$f":"'DECOMPTE 1'!H54","v":0},{"$f":"'DECOMPTE 1'!I54","v":0},{"$f":"'DECOMPTE 1'!O54","v":0},{"$f":"'DECOMPTE 1'!T54","v":0},{"$f":"'DECOMPTE 1'!V54","v":0},{"$f":"'DECOMPTE 1'!W54","v":""}]
[null,{"$f":"'DECOMPTE 1'!G55","v":0},{"$f":"'DECOMPTE 1'!H55","v":0},{"$f":"'DECOMPTE 1'!I55","v":0},{"$f":"'DECOMPTE 1'!O55","v":0},{"$f":"'DECOMPTE 1'!T55","v":0},{"$f":"'DECOMPTE 1'!V55","v":0},{"$f":"'DECOMPTE 1'!W55","v":""}]
[null,{"$f":"'DECOMPTE 2'!G7","v":0},{"$f":"'DECOMPTE 1'!H56","v":0},{"$f":"'DECOMPTE 1'!I56","v":0},{"$f":"'DECOMPTE 1'!O56","v":0},{"$f":"'DECOMPTE 1'!T56","v":0},{"$f":"'DECOMPTE 1'!V56","v":0},{"$f":"'DECOMPTE 1'!W56","v":""}]
[null,{"$f":"'DECOMPTE 2'!G8","v":0},{"$f":"'DECOMPTE 1'!H57","v":0},{"$f":"'DECOMPTE 1'!I57","v":0},{"$f":"'DECOMPTE 1'!O57","v":0},{"$f":"'DECOMPTE 1'!T57","v":0},{"$f":"'DECOMPTE 1'!V57","v":0},{"$f":"'DECOMPTE 1'!W57","v":""}]
[null,{"$f":"'DECOMPTE 2'!G7","v":0},"='DECOMPTE 2'!H7",{"$f":"'DECOMPTE 2'!K7","v":0},{"$f":"'DECOMPTE 2'!K7","v":0},{"$f":"'DECOMPTE 2'!L7","v":0},{"$f":"'DECOMPTE 2'!M7","v":0},{"$f":"'DECOMPTE 2'!N7","v":0}]
[null,{"$f":"'DECOMPTE 2'!G8","v":0},"='DECOMPTE 2'!H8","='DECOMPTE 2'!H9","='DECOMPTE 2'!H10","='DECOMPTE 2'!H11","='DECOMPTE 2'!H12","='DECOMPTE 2'!H13"]
[null,{"$f":"'DECOMPTE 2'!G9","v":0},"='DECOMPTE 2'!H9"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'DECOMPTE 2'!G10","v":0},null,{"$f":"'DECOMPTE 1'!I58","v":0},{"$f":"'DECOMPTE 1'!O58","v":0},{"$f":"'DECOMPTE 1'!T58","v":0},{"$f":"'DECOMPTE 1'!V58","v":0},{"$f":"'DECOMPTE 1'!W58","v":0}]
[null,null,"OPERATIONS",{"$f":"'DECOMPTE 2'!W5","v":0},{"$f":"'DECOMPTE 2'!P6","v":0},0,{"$f":"'DECOMPTE 2'!W5","v":0},{"$f":"(SUM(H6:H34))","v":0}]
[]
[]
[]
[null,"MONTANTS DES OPERATIONS :",null,{"$f":"D72","v":0},{"$f":"'DECOMPTE 2'!P5+'DECOMPTE 1'!O59","v":0},{"$f":"F72","v":0},{"$f":"'DECOMPTE 2'!W6","v":0},{"$f":"'DECOMPTE 2'!X6","v":0}]
[null,"MOINS DECOMPTE FRANCHISE",null,{"$f":"ABS('DECOMPTE 1'!W59)","v":0}]
[null,"SOUS TOTAL ",null,{"$f":"D76-D77","v":0},{"$f":"D78-D79","v":0},"MONTANT A REMBOURSER\nAPRES DEDUCTION DU 10 %"]
[null," MA PARTICIPATION 10 %",null,{"$f":"'DECOMPTE 1'!P59","v":0}]
[null,"SOLDE DE DIFFERENCE ENTRE MES AVANCES ET LES REMBOURSEMENTS",null,{"$f":"'DECOMPTE 2'!W6+'DECOMPTE 1'!W4","v":0},"NON PRIS EN\nCHARGE PAR L'ASSUREUR","FRANCHISE\nPARTICIPATIONS\nNON PRIS EN CHARGE","MONTANT DEDUCTIBLE\n DES IMPOTS"]
[]
[null,"MONTANT REELEMENT REMBOURSE PAR L'ASSURANCE",null,{"$f":"'DECOMPTE 2'!U6","v":421.55000000000007}]
[]
[null,"SOLDE DECOMPTE S.D.K",null,{"$f":"'TOTALISER XX'!G32","v":123.23499999999999}]

{"sheet":"TOTALISER XX","index":6,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,1,2,6],[3,1,3,3],[32,1,32,6],[33,1,33,6],[6,10,6,11]]}
[null,"FEUILLE TOTALISER A",null,"DECOMPTE 1","DECOMPTE 2",null,"REGLES JOINTES",null,"ALLER A TOTALISER B"]
[]
[]
[null,"XX"]
[]
[]
[null,"DATES","CODE %","Factures Payé par GHV à DSK ou MONTANT \nEN DEPÔT","Montants Déboursés OU Participation de GHV","Remboursement ou Avances\nde DSK","SOMME SOLDE\n en plus ou en moins",null,null,null,"calcul sous déduction des frais G.H.V"]
[null,"2022-10-25","1",213.65,{"$f":"IF(C8<>\"\",D8*10%,\"\")","v":21.365000000000002},42.35,{"$f":"D8-E8+F8","v":234.63499999999999},null,null,null,{"$f":"G8","v":234.63499999999999},"SOLDE"]
[null,"2023-01-18",null,-55.7,"",null,{"$f":"IF(C9<>\"\",D9-E9,D9)","v":-55.7},null,null,{"$f":"IF(F9<>\"\",F9,\"\")","v":""},{"$f":"G9","v":-55.7},"RITALINE"]
[null,"2023-08-23",null,-55.7,"",null,-55.7,null,null,null,-55.7,"RITALINE"]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,{"$f":"IF(C18<>\"\",D18-E18,D18)","v":0},null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,"",null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,{"$f":"D31-E31","v":0},null,null,null,0]
[null,"Totaux ",null,{"$f":"SUM(D8:D31)","v":102.24999999999999},{"$f":"SUM(E8:E31)","v":21.365000000000002},{"$f":"SUM(F8:F31)","v":42.35},{"$f":"D32-E32+F32","v":123.23499999999999},null,null,null,{"$f":"SUM(K9:K31)","v":-111.4},"SOUS TOTAL"]
[null,"Colonne montants Facturation - Colonne  Montants = Payé par G.H.V.",null,null,null,null,null,null,null,null,{"$f":"G32","v":123.23499999999999},"SOLDE FINAL"]
[null,"Colonne bleu = Avances DSK   -  Colnne Sommes = solde "]

{"sheet":"TOTALISER B","index":7,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9],[3,1,3,2],[3,6,3,7]]}
[null,"FEUILLE TOTALISER B","INDEX",null,"REGLES JOINTES",null,"ALLER A TOTALISER A"]
[]
[null,"Addition/Soustraction ",null,null,null,null,"Addition/Soustraction "]
[]
[]
[null,"Définition","Montants +","Montant -","Sommes +/-",null,"Définition","Montants +","Montant -","Sommes +/-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totaux ",{"$f":"SUM(C7:C30)","v":0},{"$f":"SUM(D7:D30)","v":0},{"$f":"C31-D31","v":0},null,"Totaux ",{"$f":"SUM(H7:H30)","v":0},{"$f":"SUM(I7:I30)","v":0},{"$f":"H31-I31","v":0}]
[null,null,null,null,{"$f":"SUM(E7:E30)","v":0}]
[null,null,null,null,{"$f":"IF(C33>0,E32+C33,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"003  CALCULETTE"]

{"sheet":"TOTALISER A (2)","index":8,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,1,2,6],[3,1,3,3],[6,10,6,11],[32,1,32,6],[33,1,33,6]]}
[null,"FEUILLE CHARGES REGROUPEES",null,"DECOMPTE 1","DECOMPTE 2",null,"REGLES JOINTES",null,"ALLER A TOTALISER B"]
[]
[]
[null,"XX"]
[]
[]
[null,"DATES","CODE %","Factures Payé par GHV à DSK ou MONTANT \nEN DEPÔT","Montants Déboursés OU Participation de GHV","Remboursement ou Avances\nde XX","SOMME SOLDE\n en plus ou en moins",null,null,null,"calcul sous déduction des frais G.H.V"]
[]
[null,"2023-03-17",0.1,319.25,{"$f":"IF(C9<>\"\",D9*10%,\"\")","v":31.925000000000001},null,{"$f":"IF(C9<>\"\",D9-E9,D9)","v":287.32499999999999},null,null,null,{"$f":"IF(C9<>\"\",G9,\"\")","v":287.32499999999999},{"$f":"IF(G9>0,\"prix achat ./.participation\",\"\")","v":"prix achat ./.participation"}]
[null,"2023-04-20",0.1,198.25,19.825000000000003,null,178.42500000000001,null,null,null,{"$f":"IF(C10<>\"\",G10,\"\")","v":178.42500000000001},{"$f":"IF(G10>0,\"prix achat ./.participation\",\"\")","v":"prix achat ./.participation"}]
[null,"2023-05-24",0.1,17.649999999999999,1.7649999999999999,null,15.884999999999998,null,null,null,{"$f":"IF(G11<>\"\",G11,\"\")","v":15.884999999999998},"prix achat ./.participation"]
[null,"2023-05-24",0.1,213.65,21.365000000000002,null,192.285,null,null,null,192.285,"prix achat ./.participation"]
[null,"2023-05-24",null,null,"",null,-192.29,null,null,null,-192.29,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,{"$f":"IF(C15<>\"\",D15-E15,D15)","v":0},null,null,null,0,{"$f":"IF(K15>0,\"prix achat ./.participation\",\"\")","v":""}]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,null,null,null,"",null,0,null,null,null,0,""]
[null,"Totaux ",null,{"$f":"SUM(D9:D31)","v":748.8},{"$f":"SUM(E8:E31)","v":74.88},{"$f":"SUM(F8:F31)","v":0},{"$f":"SUM(G9:G31)","v":481.63},null,null,null,{"$f":"SUM(K9:K31)","v":481.63},"total"]
[null,"Colonne montants Facturation - Colonne  Montants = Payé par G.H.V. (0U % PARTICIPATION)"]
[null,"Colonne bleu = Avances    -  Colnne Sommes = solde "]

{"sheet":"CALCULS","index":9,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,7,30,8],[32,7,32,8],[2,1,2,4],[2,7,2,11],[13,6,13,11],[16,8,16,9],[23,8,23,9],[28,7,28,10],[11,7,11,8],[31,1,31,4]]}
[null,null,"DECOMPTE 1",null,"DECOMPTE 2"]
[]
[null,"Addition/Soustraction ",null,null,null,null,null,"Calculation d'un pourcentage"]
[]
[null,"Définition","Montants +","Montant -","Sommes +/-",null,"Exemple","Si",350,"est égal à",100,"%"]
[]
[null,null,null,null,null,null,null,"Alors",25,"est égal à","X","%"]
[]
[null,null,null,null,null,null,null,"Si ",143.6,"=",100,"%"]
[null,null,null,null,null,null,null,"Alors",14.35,"=",{"$f":"IF(I9<>\"\",I10/I9*K9,\"\")","v":9.9930362116991649},"%"]
[]
[null,null,null,null,null,null,null,"RÉSULTAT ",null,"=",{"$f":"K10","v":9.9930362116991649},"%"]
[]
[null,null,null,null,null,null,"On peut calculer la somme y compris la TVA : expl. 108 %"]
[]
[]
[null,null,null,null,null,null,null,null,"DIVISION"]
[null,null,null,null,null,null,null,"Montant",100,"Divisé par",25]
[]
[null,null,null,null,null,null,null,"=",{"$f":"IF(I18<>\"\",I18/K18,\"\")","v":4}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"MULTIPLIER"]
[null,null,null,null,null,null,null,"Montant",100,"Multiplié par",25]
[]
[null,null,null,null,null,null,null,"=",{"$f":"IF(I25<>\"\",I25*K25,\"\")","v":2500}]
[]
[null,null,null,null,null,null,null,"CALCUL CHANGE DES DVISES"]
[null,"Totaux ",{"$f":"SUM(C6:C29)","v":0},{"$f":"SUM(D6:D29)","v":0},{"$f":"C30-D30","v":0}]
[null,null,null,null,{"$f":"SUM(E6:E29)","v":0},null,null,"Montant",null,"Cours","Devises"]
[null,"CALCULER LE POURCENTAGE A PARTIR DU"]
[null,"Montant Rembousé","Divisé par\n90",0.01,"X 100",null,null,100,null,"0.85",{"$f":"H33*J33/100","v":0.85}]
[null,55,90,{"$f":"B34/C34","v":0.61111111111111116},{"$f":"D34*100","v":61.111111111111114}]
[null,185,90,{"$f":"B35/90","v":2.0555555555555554},{"$f":"D35*100","v":205.55555555555554}]
[null,null,null,null,{"$f":"C36-D36","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"003  CALCULETTE"]

{"sheet":"TOTAL CHARGES","index":10,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,33,5],[2,1,2,5],[3,1,3,2],[3,3,3,5],[6,9,6,10],[32,1,32,5]]}
[null,"FEUILLE TOTALISER A","DECOMPTE 1","DECOMPTE 2",null,"REGLES JOINTES",null,"ALLER A TOTALISER B"]
[]
[]
[null,null,null,"MONTANTS MICHELINE A PAYER"]
[]
[]
[null,"DATES","Factures Payée  ou MONTANTS \nA PAYES","Montants Déboursés ","Remboursement \n","SOMME SOLDE\n en plus ou en moins",null,null,null,"calcul sous déduction des frais G.H.V"]
[null,null,0,0,null,{"$f":"C8-D8","v":0}]
[null,"2023-03-24",319.25,0,null,319.25,null,null,null,{"$f":"C9-D9","v":319.25},{"$f":"IF(J9>0,\"Franchise./.participation\",\"\")","v":"Franchise./.participation"}]
[null,"2023-04-26",214.4,0,null,214.4,null,null,null,{"$f":"C10-D10","v":214.4},{"$f":"IF(J10>0,\"Franchise./.participation\",\"\")","v":"Franchise./.participation"}]
[null,"2023-05-09",119,0,null,119,null,null,null,119,{"$f":"IF(J11>0,\"Franchise./.participation\",\"\")","v":"Franchise./.participation"}]
[null,"00:00:00",0,0,null,0,0,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,null,null,null,null,0,null,null,null,0,""]
[null,"Totaux ",{"$f":"SUM(C8:C31)","v":652.65},{"$f":"SUM(D8:D31)","v":0},{"$f":"SUM(E8:E31)","v":0},{"$f":"C32-D32+E32","v":652.65},null,null,null,{"$f":"SUM(J9:J31)","v":652.65},{"$f":"IF(J32>0,\"Total\",\"\")","v":"Total"}]
[null,"Colonne montants Facturation - Colonne  Montants = Payé par G.H.V."]
[null,"Colonne bleu = Avances DSK   -  Colnne Sommes = solde "]

{"sheet":"COURRIER1","index":11,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,1,29,7],[31,1,31,7],[33,1,33,7],[15,1,15,3],[19,1,19,7],[21,1,21,7],[23,1,23,7],[27,1,27,7],[28,1,28,7]]}
[]
[]
[null,{"$f":"'DECOMPTE 1'!H2","v":"Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939"}]
[]
[]
[null,{"$f":"'LETTRE D''ENVOI'!B6","v":"Georges VOCAT"},null,null,null,"Nyon le",{"$f":"TODAY()","v":"2023-12-03"}]
[null,{"$f":"DONNEES!B10","v":"Rue de la Fléchère 17"}]
[null,{"$f":"DONNEES!B11","v":"CH-1260  NYON"}]
[]
[null,{"$f":"DONNEES!B14","v":"CCP - 12-56914-9"},null,null,null,{"$f":"DONNEES!D3","v":" ASSURA"}]
[null,"Mail : ghv1260@outlook.com",null,null,null,{"$f":"DONNEES!D4","v":"Assura-Basis SA"}]
[null,null,null,null,null,{"$f":"DONNEES!D5","v":"Case Postale 4"}]
[null,null,null,null,null,{"$f":"DONNEES!D6","v":"CH-1052  Le Mont-sur-Lausanne"}]
[]
[]
[null,"Concerne : TRAITEMENT(S)",null,null,{"$f":"DONNEES!B18","v":2024}]
[]
[null,"Mesdames, Messieurs,"]
[]
[null,"Veuillez trouver ci-joint l'(es) original(aux)  ou copie(s) de(s) facture(s) dont j'ai effectué le(s) règlement(s) ou dont je demande le(s) remboursement(s) anticipé(s)."]
[]
[]
[]
[null,"En vous remerciant de me faire parvenir votre participation."]
[]
[null,"-"]
[]
[]
[]
[]
[]
[null,"Avec l'expression de mes salutations les meilleures."]
[]
[null,"Georges Vocat"]

{"sheet":"COURRIER2","index":12,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,1,31,7],[33,1,33,7],[19,1,19,7],[21,1,21,7],[23,1,23,7],[26,1,26,7],[27,1,27,7],[28,1,28,7]]}
[]
[]
[null,{"$f":"'DECOMPTE 1'!H2","v":"Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939"}]
[]
[]
[null,{"$f":"'LETTRE D''ENVOI'!B6","v":"Georges VOCAT"},null,null,null,"Nyon le",{"$f":"TODAY()","v":"2023-12-03"}]
[null,{"$f":"DONNEES!B10","v":"Rue de la Fléchère 17"}]
[null,{"$f":"DONNEES!B11","v":"CH-1260  NYON"}]
[]
[null,{"$f":"DONNEES!B14","v":"CCP - 12-56914-9"},null,null,null,{"$f":"DONNEES!D3","v":" ASSURA"}]
[null,"ghv1260@outlook.com",null,null,null,{"$f":"DONNEES!D4","v":"Assura-Basis SA"}]
[null,null,null,null,null,{"$f":"DONNEES!D5","v":"Case Postale 4"}]
[null,null,null,null,null,{"$f":"DONNEES!D6","v":"CH-1052  Le Mont-sur-Lausanne"}]
[]
[]
[null,"Concerne : TRAITEMENT(S)",{"$f":"DONNEES!B18","v":2024}]
[]
[null,"Mesdames, Messieurs,"]
[]
[]
[]
[null,"En vous souhaitant bonne réception de ce qui précède et en vous remerciant par avance de votre envoi."]
[]
[]
[]
[null,"-"]
[]
[]
[]
[]
[]
[null,"Avec l'expression de mes salutations distinguées."]
[]
[null,"Georges Vocat"]

{"sheet":"COURRIER INDEPENDANT","index":13,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,1,31,7],[33,1,33,7],[34,6,34,7],[16,1,16,6],[19,1,19,7],[21,1,21,7],[23,1,23,7],[26,1,26,7],[27,1,27,7],[28,1,28,7]]}
[]
[]
[null,"Assura Basis - VOCAT Micheline \n- 962 020 - 16.06.1941"]
[]
[]
[null,"Micheline & Georges VOCAT",null,null,null,"Nyon le",{"$f":"TODAY()","v":"2023-12-03"}]
[null,{"$f":"DONNEES!B10","v":"Rue de la Fléchère 17"}]
[null,{"$f":"DONNEES!B11","v":"CH-1260  NYON"}]
[null,null,null,null,null,"HOPITAL DE NYON"]
[null,{"$f":"DONNEES!B14","v":"CCP - 12-56914-9"},null,null,null,"Service Comptabilité"]
[]
[]
[null,null,null,null,null,"CH-1260 NYON"]
[]
[]
[null,"Concerne : TRAITEMENT(S)",{"$f":"DONNEES!B18","v":2024}]
[null,"DEMANDE DE COPIE DES FACTURES\nET DES RAPPORTS MALADIES ET/OU ACCIDENT.\nCONCERNANT M. GEORGES ET MME. MICHELINE VOCAT"]
[null,"Mesdames, Messieurs,"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Avec l'expression de mes salutations distinguées."]
[]
[null,"Micheline & Georges VOCAT"]

{"sheet":"JOINTES","index":14,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,2,15,9],[16,2,16,9],[17,2,17,9],[18,2,18,9],[11,1,11,3],[11,7,11,9],[12,1,12,3],[12,7,12,9],[13,1,13,3],[13,4,13,6],[13,7,13,9],[8,1,8,3],[8,7,8,9],[9,1,9,3],[9,7,9,9],[10,1,10,3],[10,7,10,9],[5,1,5,3],[5,7,5,9],[6,1,6,3],[6,7,6,9],[7,1,7,3],[7,7,7,9],[2,1,2,3],[2,7,2,9],[3,1,3,3],[3,7,3,9],[4,1,4,3],[4,7,4,9],[1,14,1,15],[0,8,0,9],[1,1,1,2],[1,3,1,7],[1,8,1,9],[1,11,1,12]]}
[null,null,null,null,"INDEX",null,null,null,"TOTALISER A"]
[null,"DENOMINATEUR",null,"REGLES DE TROIS CONJOINTES",null,null,null,null,"NUMERATEUR",null,null,"ANTECEDENTS",null,null,"CONSEQUENTS"]
[null,"CHF",null,null,"x",{"$f":"IF(E3<>\"\",\"=\",\"\")","v":"="},100,"KG",null,null,null,{"$f":"E3","v":"x"},null,null,{"$f":"G3","v":100},{"$f":"O3","v":100}]
[null,{"$f":"IF(H3<>\"\",H3,\"\")","v":"KG"},null,null,15.4,{"$f":"IF(E4<>\"\",\"=\",\"\")","v":"="},2.2000000000000002,"$ CAN",null,null,null,{"$f":"E4","v":15.4},{"$f":"L4","v":15.4},null,{"$f":"G4","v":2.2000000000000002},{"$f":"P3*O4","v":220.00000000000003}]
[null,"$ CAN",null,null,100,"=",98,"PAN 98 %",null,null,null,100,{"$f":"M4*L5","v":1540},null,98,{"$f":"P4*O5","v":21560.000000000004}]
[null,"PAN 98 %",null,null,100,"=",105,"PRA 105 %",null,null,null,100,{"$f":"M5*L6","v":154000},null,105,2263800.0000000005]
[null,"PRA 105 %",null,null,1,"=",3.85,"PRA EN CHF",null,null,null,1,154000,null,3.85,8715630.0000000019]
[null,"PRA EN CHF",null,null,90,"=",100,"PV  100 %EN CHF",null,null,null,90,{"$f":"M7*L8","v":13860000},null,100,{"$f":"P7*O8","v":871563000.00000024}]
[null,"PV  100 %EN CHF",null,null,null,"",null,null,null,null,null,0,{"$f":"M8*L9","v":0},null,0,{"$f":"P8*O9","v":0}]
[null,"",null,null,null,"",null,null,null,null,null,0,{"$f":"M9*L10","v":0},null,0,0]
[null,"",null,null,null,"",null,null,null,null,null,0,0,null,0,0]
[null,"",null,null,null,"",null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,{"$f":"M13","v":13860000},null,{"$f":"P13","v":871563000.00000024},null,null,null,null,null,{"$f":"MAX(IF(M3:M12>0,M3:M12))","v":13860000},null,null,{"$f":"MAX(IF(P3:P12>0,P3:P12))","v":871563000.00000024}]
[null,{"$f":"B3","v":"CHF"},null,null,{"$f":"G13/E13","v":62.883333333333347},null,null,{"$f":"H3","v":"KG"}]
[]
[null,null,"Importation d'avoine canadien au pris de 2.20 $ can, PAB le boisseau de 34 lb. On optien une remise de 2 % et les fais d'achat s'élèvent à 5 % du PAN. A quel prix"]
[null,null,"faut-il revendre le quintal en CHF pour que le B soit de 10 % du prix de vente."]
[]
[null,null,"32 m = 35 yards.    Change 9.60"]

{"sheet":"MODE D'EMPLOI","index":15,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"DECOMPTE 1","DECOMPTE 2"]
[null,null,null,"DONNEES"]
[null,null,null,"MODE D'EMPLOI DES FACTURES DE SANTÉ\n\n"]
[null,null,null,"Premièrement"]
[null,null,null,"Allez dans la feuille Données"]
[null,null,null,"Vérifier que les donnée sont correctes avant de commencer"]
[null,"COLONNE\nCELLULE",null,"DANS LA FEUILLE COMPTE 1"]
[null,"D2",null,"Sélectionner l'assuré et le type de couverture  (TRIANGLE SUR LA POINTE)"]
[null,"G2",null,"La date est affichée automatiquement"]
[null,"B",null,"A partir de B4 il s'agit de la saisie des éléments du décompte proprement dit : Saisir la date du RDV Médical"]
[null,"C",null,"Saisir la date de la facture du fournisseur de prestation"]
[null,"D",null,"No de facture ou document similaire"]
[null,"E",null,"Type de soins : Expl. ANALYSE / TRAITEMENT / MEDICAMENT / RADIO  etc…"]
[null,"F",null,"No attribué à la facture suivie de G pour Georges et de M pour Micheline"]
[null,"G",null,"Nom du Fournisseur de soins, d'analyse, médicaments etc…"]
[null,"H",null,"Taper le montant de la facture"]
[null,"I",null,"Les FRAIS avancés par l'assuré"]
[null,"J",null,"Colonne masquée pour calcul du 10 %"]
[null,"K",null,"Affichage automatique du 10 % si celui-ci est calculé dans les colonnes suivantes"]
[null,"L",null,"MONTANT DU REMBOURSEMENT"]
[null,"M",null,"Texte à sélectionner par la petite flèche"]
[null,"O",null,"Calcul du % de participation"]
[null,"p",null,"Affichage du solde a payé par l'assurance"]
[null,"O",null,"La colonne \"O\" est la colonne la plus importante de toutes car elle permet tout les calculs pour définir le total  LIRE ATTENTIVEMENT LA SUITE."]
[null,"DECOMPTE 1","a","Si le montant REMBOURSE correspond au montant de \"Mes Avances\" Alors taper ce montant. \n (S i NON lire attentivement la suite)"]
[null,null,"b","Si le montant inférieur au montant de \"Mes Avances\" OU partiellement Alors taper ce montant.  "]
[null,null,"c","Si une partie du montant est attribué à la couverture partielle de la franchise il faut OUVRIR UNE NOUVELLE LIGNE avec le même numéro de document et taper la partie (le montant) attribuée à la franchise en négatif  dans la colonne \"N\".\n  (Exemple : -182.00).\nSi le montant REMBOURSE est supérieur à la FRANCHISE SAISIR LE MONTANT DE LA FRANCHISE PUIS,\ncomme si dessus ouvrir une nouvelle ligne avec le même numéro de doc. et saisir le montant Comme part du remboursement."]
[null,null,"d","Si le montant de la facture est totalement (100%) refusé il faut alors taper la somme non remboursée, puis taper 0 dans les colonnes  P & Q."]
[null,null,"e","EN CAS DE REMBOURSEMENT COMPLEMENTAIRES :"]
[null,null,null,"LA RECAPITULATION ET LE RESUME : Affiche une syntèse des opérations"]
[null,"Col. R",null,"Saisir le numéro du décompte de remboursement"]
[null,"S",null,"Saisir le montant réellement remboursé par l'assureur (voir colonne S) ci-dessous."]
[null,"U",null,"\nMODIFIER UN TEXTE QUE L'ON VEUX FAIRE APPARAITRE DANS LA COLONNE \"M\"\n"]
[null,null,null,"Il suffit de le taper par-dessus celui que l'on veux remplacer dans la colonne \"M\", la dernière ligne n'est pas modifiable pour conserver une possibilté vide."]
[]
[null,"S",null,"COLONNE \"S\"  ENREGISTRER LE MONTANT REELLEMENT PAYE PAR L'ASSUREUR Y COMPRIS LES MONTANT CONCERNANT UNE DIFFERENCE DE LA PARTICIPATION"]
[null,"RETOUR AU DECOMPTE 1",null,"Entrer les dates > les textes éventuels > passer jusqu'à la colonne \" S \" et entrer le montant positif en notre faveur sur la participation."]
[]
[null,null,null,"             DECOMPTE \"2\"  (DEUX)"]
[null,"RETOUR AU DECOMPTE 2",null,"REMBOUSEMENT PAR L'ASSURANCE EXCLUSIVEMENT DECOMPTE \" 1\"\nNON REMBOURSEMENT EXCLUSIVEMENT DANS\n LE DECOMPTE \"2\""]
[null,null,null,"IL SUFFIT DE SAISIR QUEL QUE CHOSE POUR DECLANCHER LE REMBOUSEMENT DANS LA COLONNE \"I\".  DANS LA LIGNE CONCERNEE ET LAISSER VIDE POUR NON REMBOURSé."]

{"sheet":"DONNEES","index":16,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,3,8,5]]}
[null,"MODE D''EMPLOI"]
[null,"NOM ASSURANCES",null,"ADRESSES ASSURANCES",null,"ASSURE(E) - NUMERO DE POLICE"]
[null,"ASSURA ASSURANCE MALADIE",null," ASSURA",null,"Assura Basis - VOCAT Micheline \n- 962 020 - 16.06.1941"]
[null,"GROUPE MUTUEL SA",null,"Assura-Basis SA",null,"Assura Basis \n- VOCAT Georges\n - 962 018 - 20.11.1939"]
[null,null,null,"Case Postale 4",null,"EsySana - VOCAT Micheline\n - 1013759 - 16.06.1941"]
[null,null,null,"CH-1052  Le Mont-sur-Lausanne",null,"EsySana - VOCAT Georges \n- 1022834 - 20.11.1939"]
[]
[]
[null,"DOMICILES + DIVERS",null,"MONTANTS A REPORTES SUR LE DECOMPTE"]
[null,"Rue de la Fléchère 17",null,300,null,"FRANCHISES - MICHELINE & GEORGES"]
[null,"CH-1260  NYON",null,0,null,"FRANCHISES - DIFFERENTES"]
[null,"Georges Vocat",null,700,null,"PARTICIPATION MAXIMUM"]
[null,"Micheline Vocat",null,0.1,null,"POURCENTAGE DE PARTICIPATION"]
[null,"CCP - 12-56914-9",null,242.7,null,"PRIME MENSUELLE"]
[null,"Micheline & Georges VOCAT"]
[]
[null,"DATES",null,"Micheline & Georges VOCAT"]
[null,2024,null,"Micheline VOCAT"]
[null,null,null,"Georges VOCAT"]

{"sheet":"Suggestion1","index":17,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["Colonne1","Nombre de Colonne1"]
["SOLDE DE LA FACTURE APRES DEDUCTION FRANCHISE - 10%",1]
["REMBOURSEMENT NON PRIS EN CHARGE PAR L'ASSURANCE",1]
["REMBOURSE SOUS DEDUCTION DU 10 %",1]
["EN ATTENTE DE LA PARTICIPATION",1]
["REMBOUSEMENT PARTIEL",1]
["EN ATTENTE DE REGLEMENT",1]
["DECOMPTE POUR FRANCHISE",1]
["ERREUR",1]
["REMBOURSEMENT DE L'ASSUREUR POUR TOP PAYE",1]
["FACTURE PAYEE DIRECTEMENT PAR L'ASSURANCE",1]
["REMBOURSEMENT SANS PARTICIPATION",1]
["FACTURE PAYEE DIRECTEMENT PAR L'ASSURANCE AVEC SOLDE DE PARTICIPATION",1]
["SOLDE DE LA FACTURE APRES DEDUCTION FRANCHISE",1]
["MA PARTICIPATION 10 %  SUR AVANCE DE L'ASSURANCE",1]
["VOIR SUSPENDS",1]
["NON REMBOURSE ",1]
["OPTIONS CONDITIONNELLES",1]
["(vide)"]
["Total général",17]