{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ENCODAGE","Relevé encodage","Suivi budgétaire","Feuil4","BDD","Listes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ENCODAGE","index":0,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Encodage SWDE"]
[]
[]
[]
[null,"Type de document :",null,"Régularisation + (à payer)",null,"REF :"]
[null,null,null,""]
[null,"Compte de contrat :",null,"1000 0395 1740",null,"Remarque :"]
[]
[null,"Article budgétaire :",null,null,null,"Dénomination :",null,null,null,null,null,null,null,null,null,null,"CHECK"]
[null,null,null,null,null,"Adresse de consommation :"]
[null,"N° Facture :",null,null,null,"N° d'installation :"]
[null,null,null,null,null,"N° compteur :"]
[null,"Montant :"]

{"sheet":"Relevé encodage","index":1,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["REF","Doc","N°","Compte de contrat","Article budgétaire","Montant"]

{"sheet":"Suivi budgétaire","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BDD","index":4,"n_rows":242,"n_cols":11,"rows_kept":242,"cut":false,"hidden":false,"merged":[]}
["Compte de contrat","REF","Article budgétaire","Dénomination","Adresse de consommation","N° d'installation","N° compteur","Remarque"]
["1000 0135 3502",1,"104/125-15",null,null,null,null,null,null,null,{"$f":"INDEX(A:A,_xlfn.AGGREGATE(15,6,ROW($A$2:$A$241)/(RIGHT($A$2:$A$241,4)=FIXED(ENCODAGE!D7,0,1)),ROW(A1)))","v":{"$error":"#NUM!"}}]
["1000 0135 3512",2,"722/125-15"]
["1000 0135 3500",3,"878/125-15"]
["1000 0135 3538",4,"721/125-15"]
["1000 0135 3540",5,"722/125-15"]
["1000 0135 3536",6,"722/125-15"]
["1000 0134 5823",7,"878/125-15",null,null,1001149523,"F07445544"]
["1000 0134 5863",8,"722/125-15"]
["1000 0135 3534",10,"878/125-15"]
["1000 0134 5948",11,"104/125-15"]
["1000 0134 5923",12,"766/125-15"]
["1000 0134 8788",13,"721/125-15"]
["1000 0134 6020",14,"104/125-15"]
["1000 0336 7761","14/Bis","104/125-15"]
["1000 0134 5997","14/Ter","878/125-15"]
["1000 0397 9427","14/Quater","124/125-15"]
["1000 0134 8815",15,"104/125-15"]
["1000 0395 1743","15 Bis","104/125-15",null,null,null,"A09149248"]
["1000 0134 6045",16,"722/125-15"]
["1000 0134 6038",17,"421/125-15"]
["1000 0134 6049",18,"7622/125-15"]
["1000 0134 6051",19,"878/125-15"]
["1000 0290 8197",21,"722/125-15"]
["1000 0290 8305","21/Bis","722/125-15"]
["1000 0353 7413",22,"104/125-15"]
["1000 0135 3578",23,"104/125-15"]
["1000 0297 0068",24,"878/125-15"]
["1000 0135 3626",25,"104/125-15"]
["1000 0135 3624",26,"104/125-15"]
["1000 0395 1724",27,"421/125-15",null,null,null,"M16253916"]
["1000 0397 9430",28,"421/125-15"]
["1000 0135 3643",30,"722/125-15"]
["1000 0135 3645",31,"722/125-15"]
["1000 0135 3660",32,"761/125-15"]
["1000 0318 8633",33,"7642/125-15"]
["1000 0312 9876",34,"878/125-15"]
["1000 0135 3638","34/Bis","878/125-15"]
["1000 0342 1556","34/Ter","7642/125-15"]
["1000 0252 9911",35,"7622/125-15"]
["1000 0152 5805","35 Bis","722/125-15"]
["1000 0133 3288",36,"722/125-15"]
["1000 0327 0363",37,"124/125-15"]
["1000 0134 6256",38,"878/125-15"]
["1000 0134 6495",39,"104/125-15"]
["1000 0126 6483",40,"421/125-15"]
["1000 0397 9428",41,"124/125-15"]
["1000 0361 3650","41 - 1","124/125-15"]
["1000 0134 6488",42,"721/125-15"]
["1000 0307 9830",43,"721/125-15"]
["1000 0134 6543","43/Bis","722/125-15"]
["1000 0134 6586",44,"7622/125-15"]
["1000 0184 8605",45,"124/125-15"]
["1000 0134 6588","45 Bis","7641/124-13",null,null,null,null,"Copie Manuela"]
["1000 0397 9423",46,"7622/125-15"]
["1000 0267 0288","46 - 1","7622/125-15"]
["1000 0134 6516",47,"878/125-15"]
["1000 0134 6644",48,"104/125-15"]
["1000 0134 9012",49,"878/125-15"]
["1000 0134 6693",50,"721/125-15"]
["1000 0134 9014",51,"722/125-15"]
["1000 0134 6691",52,"722/125-15"]
["1000 0395 1763",53,"878/125-15",null,null,null,"DH20B022781"]
["1000 0135 3685",54,"7622/125-15"]
["1000 0395 1718","54/Bis","7622/125-15"]
["1000 0135 3686",55,"7622/125-15"]
["1000 0135 3683",56,"878/125-15"]
["1000 0133 3455",57,"104/125-15"]
["1000 0133 3459",58,"104/125-15"]
["1000 0133 3331","59/Bis","104/125-15"]
["1000 0133 3328",60,"878/125-15"]
["1000 0134 6723",61,"878/125-15"]
["1000 0134 6882",65,"878/125-15"]
["1000 0372 3080","65/BIS","766/125-15"]
["1000 0134 6900",66,"104/125-15"]
["1000 0133 1284",67,"104/125-15"]
["1000 0395 1757",68,"104/125-15",null,null,null,"M14111019"]
["1000 0134 5386",69,"124/125-15"]
["1000 0389 5092","69/Bis","124/125-15"]
["1000 0390 1995","69/Ter","104/125-15"]
["4000 0004 2520",70,"766/125-15"]
["1000 0222 5029",71,"561/125-15"]
["1000 0395 1734",72,"124/125-15",null,null,null,"E12709789"]
["1000 0133 1424",74,"722/125-15"]
["1000 0133 1221",75,"722/125-15"]
["1000 0133 1245",76,"878/125-15"]
["1000 0395 1746",77,"421/125-15",null,null,null,"D18000660"]
["1000 0395 1747","77/Bis","421/125-15",null,null,null,"H21IE000740"]
["1000 0397 9432","77/Ter","104/125-15"]
["1000 0135 3690",78,"104/125-15"]
["1000 0135 3692",79,"878/125-15"]
["1000 0134 8938",80,"104/125-15"]
["1000 0134 8731",81,"104/125-15"]
["1000 0134 8732",82,"104/125-15"]
["1000 0134 8725",83,"104/125-15"]
["1000 0134 8729",84,"104/125-15"]
["1000 0134 8722",85,"104/125-15"]
["1000 0134 8720",86,"104/125-15"]
["1000 0134 8719",87,"104/125-15"]
["1000 0134 8724",88,"104/125-15"]
["1000 0134 8727",89,"104/125-15"]
["1000 0134 8717",90,"104/125-15"]
["1000 0303 4910",91,"124/125-15"]
["1000 0134 7667",92,"773/125-15"]
["1000 0134 7669",93,"773/125-15"]
["1000 0287 0596",94,"124/125-15"]
["1000 0395 1750","94/Bis","124/125-15"]
["4000 0004 2521",95,"766/125-15"]
["1000 0297 5284",96,"93014/125-15"]
["1000 0394 2427",97,"124/125-15"]
["1000 0394 2430","97/Ter","124/125-15"]
["1000 0391 3160","97/Se","124/125-15"]
["1000 0240 2369",99,"561/125-15"]
["1000 0395 1761",100,"421/125-15",null,null,null,"D20001754"]
["1000 0134 7778",101,"561/125-15"]
["1000 0395 1722","101 - 1","561/125-15"]
["1000 0134 7780",102,"561/125-15"]
["1000 0134 8947",103,"561/125-15"]
["1000 0395 1736",104,"561/124-13",null,null,null,"DH20B012433"]
["1000 0134 8755",105,"561/125-15"]
["1000 0134 8998",106,"763/125-15"]
["1000 0134 8795",107,"763/125-15"]
["1000 0134 8229",108,"561/125-15"]
["1000 0134 8139",109,"563/125-15"]
["1000 0379 8852","109/BIS","563/125-15"]
["1000 0255 5741",112,"721/125-15"]
["1000 0134 8493",113,"721/125-15"]
["1000 0255 5743","113/bis","721/125-15"]
["1000 0134 7310","114/bis","721/125-15"]
["1000 0134 8519",116,"721/125-15"]
["1000 0134 7074",117,"721/125-15"]
["1000 0134 8495",118,"721/125-15"]
["1000 0134 7242",119,"722/125-15"]
["1000 0134 8169",120,"722/125-15"]
["1000 0134 8171",121,"722/125-15"]
["1000 0134 7105",122,"722/125-15"]
["1000 0134 8663",123,"722/125-15"]
["1000 0134 7943",124,"722/125-15"]
["1000 0395 1753",126,"741/125-15"]
["1000 0395 1751",127,"741/125-15",null,null,null,"D18000623"]
["1000 0134 7902",128,"741/125-15"]
["1000 0395 1755",129,"741/125-15",null,null,null,"D18000622"]
["1000 0134 8496",130,"7341/125-15"]
["1000 0341 9333",131,"7343/125-15"]
["1000 0287 4032","132 Bis","7343/125-15"]
["1000 0286 5241",133,"7343/125-15"]
["1000 0134 8599","133/Bis","735/125-15"]
["1000 0134 7096","133/Ter","761/125-15"]
["1000 0134 7400",134,"7621/125-15"]
["1000 0134 8669",135,"763/124-13"]
["1000 0380 4874",136,"421/125-15"]
["1000 0134 8144","136/Bis","7641/124-13",null,null,null,null,"Copie Manuela"]
["1000 0395 1719",137,"421/125-15",null,null,null,"DH20B030722"]
["1000 0400 0297",138,"802/125-15"]
["1000 0381 7233","138 - 1","802/125-15"]
["1000 0394 2427","138/Bis","802/125-15"]
["1000 0394 2430","138/Ter","802/125-15"]
["1000 0134 7947",139,"7642/125-15"]
["1000 0278 9021",140,"7642/125-15"]
["1000 0397 9435",141,"7642/125-15"]
["1000 0305 0293","141 - 1","7642/125-15"]
["1000 0134 7110","141/Bis","7643/125-15"]
["1000 0134 7681","141/Ter","766/125-15"]
["1000 0395 1727",142,"766/125-15",null,null,null,"DH20B009607"]
["1000 0134 8140","142/Bis","766/125-15"]
["1000 0134 7706",143,"766/125-15"]
["1000 0134 7245",145,"766/125-15"]
["1000 0134 8544",147,"766/125-15"]
["1000 0134 7748",148,"766/125-15"]
["1000 0134 7945",149,"766/125-15"]
["1000 0134 8543",150,"766/125-15"]
["1000 0134 7750",151,"766/125-15"]
["1000 0378 0004",152,"766/125-15"]
["1000 0250 4597","152/Bis","766/125-15"]
["1000 0134 7937",153,"77103/125-15"]
["1000 0134 7935","153 Bis","77103/125-15"]
["1000 0377 6540",154,"766/125-15"]
["1000 0397 9426",155,"77103/125-15"]
["1000 0134 8327",156,"771/125-15"]
["1000 0134 8329","156/bis","771/125-15"]
["1000 0134 8688",157,"771/125-15"]
["1000 0134 7664",158,"77101/125-15"]
["1000 0134 7662",159,"77101/125-15"]
["1000 0381 6030",160,"421/125-15"]
["1000 0134 8734",162,"771/125-15"]
["1000 0134 8728",163,"77102/125-15"]
["1000 0388 5557","163/Bis","773/125-15"]
["1000 0388 5559","163/Ter","773/125-15"]
["1000 0134 8984",164,"773/125-15"]
["1000 0216 8661",166,"124/125-15"]
["1000 0134 8709",167,"84010/125-15"]
["1000 0134 8752",168,"84010/125-15"]
["1000 0397 3728",169,"84010/125-15"]
["1000 0134 8754",170,"84010/125-15"]
["1000 0397 3823","170/Bis","84010/125-15"]
["1000 0397 3908","170/Ter","84010/125-15"]
["1000 0134 8072",171,"835/125-15"]
["1000 0134 8064",172,"835/125-15"]
["1000 0170 0216",173,"835/125-15"]
["1000 0134 9100",174,"835/125-15"]
["1000 0218 8805",175,"7621/125-15"]
["1000 0134 7651",176,"878/125-15"]
["1000 0134 8333",177,"878/125-15"]
["1000 0134 7640",178,"878/125-15"]
["1000 0393 0241",179,"104/125-15",null,null,1001377503,"E11613361"]
["1000 0393 0243",180,"104/125-15",null,null,1001377508,"E09065714"]
["1000 0393 8148","180/Bis","104/125-15",null,null,1001377505,"E09065891"]
["1000 0134 6938",181,"104/125-15"]
["1000 0202 2200",182,"878/125-15"]
["1000 0134 6952",183,"722/125-15"]
["1000 0134 6955",184,"7622/125-15"]
["1000 0134 6923",185,"766/125-15"]
["1000 0134 6962",186,"878/125-15"]
["1000 0135 3704",187,"721/125-15"]
["1000 0135 3703",188,"878/125-15"]
["1000 0305 7520",189,"721/125-15"]
["1000 0134 7008",190,"104/125-15"]
["1000 0133 3285","190/Bis","878/125-15"]
["1000 0134 7011",191,"722/125-15"]
["1000 0395 1770",192,"124/125-15",null,null,null,"A11209115"]
["1000 0134 6994",193,"878/125-15"]
["1000 0134 7063","193/Bis","104/125-15"]
["1000 0134 7066",194,"721/125-15"]
["1000 0134 7068",195,"878/125-15"]
["1000 0249 9650",197,"878/125-15"]
["1000 0395 1731",199,"766/125-15",null,null,null,"A11213138"]
["1000 0280 6902",200,"7621/125-15"]
["1000 0394 2911",201,"124/125-15"]
["1000 0394 2912",202,"124/125-15"]
["1000 0394 2913",203,"124/125-15"]
["1000 0394 2914",204,"124/125-15"]
["1000 0394 2915",205,"124/125-15"]
["1000 0402 7248",206,"124/125-15"]
["1000 0336 2870",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
["1000 0395 1740",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
["1000 0371 7962",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
["1000 0134 5365",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
["1000 0363 9978",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
["1000 0359 3279",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
["1000 0305 2354",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
["1000 0352 4091",null,null,"Régie Foncière",null,null,null,"Pour MIKA"]
[null,null,"7621/125-15"]

{"sheet":"Listes","index":5,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Acompte"]
["Régularisation + (à payer)"]
["Régularisation - (RMB)"]
["Note de crédit"]