{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Menu","Clients","Carte","Scénarios","Facture Scénarios","Produits","Facture Produits","Compilation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":22,"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":"Menu","index":0,"n_rows":17,"n_cols":28,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,7,8,8],[16,7,16,8]]}
[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,null,"Débutant",19.989999999999998]
[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,null,"Intermédiaire",24.99]
[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,null,"Avancé",29.99]
[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,null,"Expert"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Afficher les scénarios \npar difficulté"]
[]
[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,null,null,null,null,null,null,"Afficher les scénarios \npar prix"]

{"sheet":"Clients","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Numéro","Prénom","Nom","Adresse","Ville","Téléphone"]
[1,"Lyne","Julien,","100, rue Siguoin","St-Eustache","450 472-3561"]
[2,"Julien","Paul,","827, rue Gault","St-Eustache","450 430-3129"]
[3,"Jacques","Dussault,","716, Dr Letondal","Deux-Montagnes","450 472-0091",null,"Sélectionner le numéro du client pour imprimer sa carte"]
[4,"Réal","Dalpé,","8995, rue Lafond","Deux-Montagnes","450 472-0099"]
[5,"Chantal","Durand,","55, rue Joly","Deux-Montagnes","450 447-4870"]
[6,"Josée","Rouleau,","100, rue Duquet","Sainte-Thérèse","450 430-3120"]
[7,"Mélanie","Chartier,","22, 20e Avenue","Deux-Montagnes","450 477-0088"]
[8,"Léo","Bouchard,","1258, 8e Avenue","Deux-Montagnes","450 472-0558"]
[9,"Luc","Perrault,","987, rue Salois","Deux-Montagnes","450 477-0033"]
[10,"Sonia","Sultani","4105 rue guenette","Sainte-Thérèse","450 505-1680"]
[11,"Justin","Trudeau","24, promenade Sussex","Ottawa","613 992-4211"]

{"sheet":"Carte","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,1,4,6]]}
[]
[]
[]
[]
[null,"ÉnigmatiK"]
[]
[null,null,"No client : ",null,null,1]
[]
[null,null,"Nom :","Lyne",null,"Julien,"]

{"sheet":"Scénarios","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Numéro","Nom du scénario","Difficulté","Durée (min)","Prix (par pers.)"]
[1,"Chalet entre amis","Débutant",60,19.989999999999998]
[2,"Alaska","Débutant",45,19.989999999999998]
[3,"Égypte ancienne","Intermédiaire",90,19.989999999999998]
[4,"Casino","Débutant",60,24.99]
[5,"Bar rétro","Avancé",60,24.99]
[6,"Magiciens modernes","Expert",45,19.989999999999998]
[7,"Dinosaures vivants","Débutant",90,19.989999999999998]
[8,"Vol de voiture","Intermédiaire",90,29.99]
[9,"Trésor de pirates","Avancé",60,29.99]
[10,"Camping sauvage","Expert",45,19.989999999999998]
[11,"Superhéros","Avancé",45,19.989999999999998]
[12,"Balade en métro","Avancé",60,29.99]
[13,"Voleurs de banque","Expert",90,24.99]
[14,"Magasinage risqué","Débutant",45,19.989999999999998]
[15,"Île en île","Débutant",45,24.99]
[16,"Évadé de prison","Intermédiaire",45,29.99]
[17,"Virus","Intermédiaire",90,29.99]
[18,"Pyramide égyptienne","Intermédiaire",90,19.989999999999998]
[19,"Cabane","Avancé",60,19.989999999999998]
[20,"Métropole déchaînée","Avancé",45,24.99]
[21,"Noël sanglant","Expert",90,24.99]
[22,"Voyage en enfer","Débutant",60,29.99]
[23,"Plage nuptiale","Expert",60,24.99]

{"sheet":"Facture Scénarios","index":4,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,7,18,9],[1,7,2,9],[1,1,1,4]]}
[]
[null,"ÉnigmatiK",null,null,null,"S",null,"Insérez le no de client, le no de scénario et le nombre de personnes"]
[null,"No client :",null,null,"No de facture",10]
[null,null,null,null,"Date",{"$f":"TODAY()","v":"2023-05-15"}]
[null,"Nom :",{"$f":"IF(B4=\"\",\"\",VLOOKUP($B$4,ListesClients,2,FALSE) &\" \"&VLOOKUP($B$4,ListesClients,3,FALSE))","v":""}]
[null,null,{"$f":"IF(B4=\"\",\"\",VLOOKUP($B$4,ListesClients,4,FALSE)&\" \"&VLOOKUP($B$4,ListesClients,5,FALSE))","v":""}]
[null,null,{"$f":"IF(B4=\"\",\"\",VLOOKUP($B$4,ListesClients,6,FALSE))","v":""}]
[null,"No scénario","Nom du scénario","Nombre de pers.","Prix","Total"]
[null,null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,ListesScénarios,2,FALSE))","v":""},null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,ListesScénarios,5,FALSE))","v":""},{"$f":"IF(D9=\"\",0,D9*E9)","v":0}]
[null,null,"",null,"",{"$f":"IF(D10=\"\",0,D10*E10)","v":0}]
[null,null,"",null,"",0]
[null,null,"",null,"",0]
[null,null,"",null,"",0]
[null,null,"",null,"",0]
[null,null,"",null,"",0]
[null,null,null,null,"Sous-Total",{"$f":"SUM(F9:F15)","v":0},null,"Imprimer le reçu pour enregistrer la transaction (compilation)"]
[null,null,null,null,"TPS",{"$f":"F16*0.05","v":0}]
[null,null,null,null,"TVQ",{"$f":"F16*9.975%","v":0}]
[null,null,null,null,"Grand total",{"$f":"SUM(F16:F18)","v":0}]

{"sheet":"Produits","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Numéro","Description","Prix"]
[1,"Escape the room",27]
[2,"ÉvaSion",32]
[3,"Énigmes scientifiques",28]
[4,"Saurez-vous trouver?",26]
[5,"Sortie express",40]
[6,"Cerveau logique",35]
[7,"Logicus",41]
[8,"Logix",36]
[9,"Focus Qi",25]

{"sheet":"Facture Produits","index":6,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,7,2,8],[15,7,18,9],[1,1,1,4]]}
[]
[null,"ÉnigmatiK",null,null,null,"P"]
[null,"No client :",null,null,"No de facture",6,null,"Sélectionner le produit"]
[null,null,null,null,"Date",{"$f":"TODAY()","v":"2023-05-15"}]
[null,"Nom :",{"$f":"_xlfn.XLOOKUP(B4,Numero,Prenom,\"\")&\"\"&_xlfn.XLOOKUP(B4,Numero,Nom,\"\")","v":""}]
[null,null,{"$f":"_xlfn.XLOOKUP(B4,Numero,Adresse,\"\")&\" \"&_xlfn.XLOOKUP(B4,Numero,Ville,\"\")","v":" "}]
[null,null,{"$f":"_xlfn.XLOOKUP(B4,Numero,Telephone,\"\")","v":""}]
[null,"No produit","Nom du produit","Quantité","Prix","Total"]
[null,null,{"$f":"_xlfn.XLOOKUP(B9,NumeroProduit,Description,\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(B9,NumeroProduit,Prix,\"\")","v":""},{"$f":"IF(D9=\"\",0,D9*E9)","v":0}]
[null,null,{"$f":"_xlfn.XLOOKUP(B10,NumeroProduit,Description,\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(B10,NumeroProduit,Prix,\"\")","v":""},{"$f":"IF(D10=\"\",0,D10*E10)","v":0}]
[null,null,{"$f":"_xlfn.XLOOKUP(B11,NumeroProduit,Description,\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(B11,NumeroProduit,Prix,\"\")","v":""},0]
[null,null,{"$f":"_xlfn.XLOOKUP(B12,NumeroProduit,Description,\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(B12,NumeroProduit,Prix,\"\")","v":""},0]
[null,null,{"$f":"_xlfn.XLOOKUP(B13,NumeroProduit,Description,\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(B13,NumeroProduit,Prix,\"\")","v":""},0]
[null,null,{"$f":"_xlfn.XLOOKUP(B14,NumeroProduit,Description,\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(B14,NumeroProduit,Prix,\"\")","v":""},0]
[null,null,{"$f":"_xlfn.XLOOKUP(B15,NumeroProduit,Description,\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(B15,NumeroProduit,Prix,\"\")","v":""},0]
[null,null,null,null,"Sous-Total",{"$f":"SUM(F9:F15)","v":0},null,"Imprimer le reçu pour enregistrer la transaction (compilation)"]
[null,null,null,null,"TPS",{"$f":"F16*0.05","v":0}]
[null,null,null,null,"TVQ",{"$f":"F16*9.975%","v":0}]
[null,null,null,null,"Grand total",{"$f":"SUM(F16:F18)","v":0}]

{"sheet":"Compilation","index":7,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["COMPILATION MENSUELLE DE LA FACTURATION"]
[null,null,null,null,"MOIS"]
["Code","Numéro ","Date ","Total",{"$f":"SUM(D4:D1048576)","v":0}]