{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Notes de frais"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Notes de frais","index":0,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,1],[2,11,3,11],[5,5,5,6],[6,5,6,6]]}
["Notes de frais"]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL à payer DES NOTES DE FRAIS",{"$f":"SUM(F20)","v":495}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL TTC","TOTAL TTC"]
["Nom :",null,null,"PERIODE",null,"2016-01-01",null,null,null,null,null,{"$f":"SUM(tblDepenses[HT/TTC])","v":495},{"$f":"SUM(tblDepenses[Analytique],tblDepenses[Colonne1])","v":240}]
["Code","428AUA",null,"Date de traitement",null,null,null,null,null,null,null,"TVA","AUTRES"]
[null,null,null,"Date de Virement",null,null,null,null,null,null,null,{"$f":"SUM(tblDepenses[TVA])","v":80},{"$f":"SUM(tblDepenses[Colonne2])","v":0}]
[]
["Date","Compte","Lieu","Description","Dépense","HT/TTC","TVA","Analytique","Colonne4","Colonne5","Colonne1","Colonne2","Colonne3"," "]
["2015-08-23",625200,null,"Trajet vers l’aéroport/vol",{"$f":"IF(B11=625200,\"voyage\",IF(B11=625300,\"Restaurant\",IF(B11=625400,\"Hôtel\",0)))","v":"voyage"},50,5,{"$f":"IF(G11=\"A\",F11*20,IF(F11=\"B\",G11*0.055,IF(G11=\"C\",F11*1,\"\")))","v":""}]
[null,625300,null,"Hôtel (2 nuits)","Restaurant",445,null,225,{"$f":"IF(PRODUCT($G12)=0,\"\",G12)","v":""}]
[null,null,null,"Frais d’inscription au congrès",0,null,null,null,""]
[null,null,null,"Repas",0,null,30,null,30]
[null,null,null,"Repas et taxi",0,null,30,15,30]
[null,null,null,"Repas",0,null,15,null,15]
[null,null,null,"Trajet à partir de l’aéroport",0,null,null,null,""]
["Totals des frais TTC",{"$f":"B7","v":"428AUA"},null,null,null,{"$f":"SUM(tblDepenses[HT/TTC])","v":495}]
["Acompte Versé"]
["Solde à payer",null,null,null,null,{"$f":"tblDepenses[[#Totals],[HT/TTC]]-F19","v":495}]
[]
[null,null,null,null,null,"  "]