{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Documentation","Accueil","Liste de fichiers","Facture","Liste de factures"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Documentation","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Ce classeur contient des macro-commandes VBA"]
["utilisées comme exemples dans la section Dialogues et formulaires"]
["d'un tutoriel sur VBA Excel"]
["par Michel Berthiaume"]
["Michel.Berthiaume@Usherbrooke.Ca"]

{"sheet":"Accueil","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[false]
[]
[null,"VBA - Introduction"]
[]
[null,null,"Auteur: Michel Berthiaume"]
[null,null,"Reproduction interdite sans autorisation"]

{"sheet":"Liste de fichiers","index":2,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Dossier:","C:\\Users\\Michel\\Desktop"]
["Nom","Taille","Date"]
["Caméra Canon.pdf",4088955,"2012-12-10T10:13:52"]
["CMC_Essai 2013 JRT.pdf",6713593,"2013-08-13T20:19:52"]
["Control Panel (3).lnk",405,"2013-04-19T15:01:41"]
["desktop.ini",794,"2014-06-16T09:06:53"]
["Doc1.txt",2,"2013-09-10T10:57:20"]
["Dropbox.lnk",1081,"2014-08-15T11:44:48"]
["Favoris - Raccourci.lnk",355,"2013-07-15T09:59:13"]
["Google Drive.lnk",1755,"2013-12-26T16:29:07"]
["Lenovo Documentationfr-FR.pdf",5591563,"2013-04-17T20:52:43"]
["Mallette magique.lnk",751,"2013-04-19T19:34:28"]
["OneNote 2013.lnk",2837,"2013-12-15T22:27:28"]
["Remote Desktop Connection.lnk",1215,"2013-04-19T13:34:00"]
["Snipping Tool.lnk",1134,"2013-08-22T08:45:39"]
["Suivi des stages I, TRS 106, AUTOMNE 2013, AVEC PROGRAMMATION.xlsm",79238,"2013-09-10T10:29:06"]
["Thumbs.db",60928,"2013-10-05T04:35:10"]
["Viivo.lnk",1562,"2013-12-14T13:21:22"]
["VoiceMessage.wav",141738,"2014-05-22T08:08:22"]
["XMind 2012.lnk",1000,"2013-08-09T10:00:07"]

{"sheet":"Facture","index":3,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,1,2,3],[3,1,3,3],[4,1,4,3]]}
[null,"Facture",null,null,null,null,null,null,null,"Méthode de calcul:",null,null,null,"Table de d'escompte"]
[null,null,null,null,null,"Sous-total",{"$f":"SUM(E7:E48)","v":0},null,null,null,"Brut",{"$f":"+G2","v":0}]
["Client :",null,null,null,"Référence","(Escompte)",{"$f":"+L3","v":0},null,null,{"$f":"VLOOKUP(L2,N3:O6,2)","v":0},"Escompte",{"$f":"-L2*J3","v":0},null,0,0]
[null,null,null,null,4,"TPS",{"$f":"+L5","v":0},null,null,null,"Net",{"$f":"L2+L3","v":0},null,100.01,0.05]
[null,null,null,null,{"$f":"TODAY()","v":"2016-01-29"},"TVQ",{"$f":"+L6","v":0},null,null,null,"TPS",{"$f":"L4*O11","v":0},null,200.01,0.1]
[null,"Item","Prix unitaire","Nombre",null,"Montant dû",{"$f":"+L7","v":0},"Utiliser la touche Tab",null,null,"TVQ",{"$f":"L4*O11","v":0},null,500.01,0.15]
[null,null,null,null,{"$f":"C7*D7","v":0},null,null,"pour déplacer le curseur",null,null,"Total",{"$f":"+L4+L5+L6","v":0}]
[null,null,null,null,{"$f":"C8*D8","v":0},null,null,null,null,null,null,null,null,"Taux de taxe"]
[null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,"TAUX"]
[null,null,null,null,0,null,null,null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,0,null,null,null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]

{"sheet":"Liste de factures","index":4,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Référence","Date","Ligne","Client","Adresse 1","Adresse 2","Item","Prix unitaire","Nombre","Montant"]
[1,"22/01/2016",1,1,2,3,4,6,5,30,null,"No.Facture:",4]
[1,"22/01/2016",2,1,2,3,2,4,3,12,null,"No.Ligne",1]
[1,"22/01/2016",3,1,2,3,3,5,4,20,null,"No.Ligne vide",{"$f":"MATCH(TRUE,ISBLANK(A1:A98),0)","v":19}]
[2,"22/01/2016",900,1,2,3,"Sous-total",null,null,62]
[2,"22/01/2016",901,1,2,3,"TPS",null,null,3,null,"Sous-total:",{"$f":"SUMIF(A:A,\"=\"&NoFacture,J:J)","v":97}]
[2,"22/01/2016",902,1,2,3,"TVQ",null,null,6,null,"TPS",{"$f":"ROUND(SousTotal*TauxTPS,2)","v":4.8499999999999996},0.05]
[2,"22/01/2016",999,1,2,3,"Total",null,null,71,null,"TVQ",{"$f":"ROUND(SousTotal*TauxTVQ,2)","v":9.68},9.9750000000000005E-2]
[3,"22/01/2016",1,3,3,3,3,3,3,9,null,"Total",{"$f":"+SousTotal+TPS+TVQ","v":111.53}]
[3,"22/01/2016",900,3,3,3,"Sous-total",null,null,71]
[3,"22/01/2016",901,3,3,3,"TPS",null,null,3]
[3,"22/01/2016",902,3,3,3,"TVQ",null,null,7]
[3,"22/01/2016",999,3,3,3,"Total",null,null,81]
[4,"29/01/2016",1,5,5,5,5,6,5,30]
[4,"29/01/2016",900,5,5,5,"Sous-total",null,null,30]
[4,"29/01/2016",901,5,5,5,"TPS",null,null,1]
[4,"29/01/2016",902,5,5,5,"TVQ",null,null,2]
[4,"29/01/2016",999,5,5,5,"Total",null,null,34]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Référence ","2016-01-06",2,"tT","t","t","t",1,1,1]