{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Information","Salle Stella Moncoutant","Réservations","Opérations","28 déc 2019 18h00","Résa 28 déc 2019 18h00","20 oct 2019 21h00","Résa 20 oct 2019 21h00","15 sept 2019 20h30","Résa 15 sept 2019 20h30","16 déc 2019 20h45","Résa 16 déc 2019 20h45"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"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":"Information","index":0,"n_rows":86,"n_cols":1,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Comment créer un salle"]
[]
["Une salle est créée sur une feuille dédiée dont le nom représente par exemple le nom de la salle."]
["Le nom de cette feuille doit être connu des Macros. Pour ce faire, ouvrir le Module_Général du projet VBA et adapter la constante NomFeuilleSalle au nom donné à la feuille (ex. NomFeuilleSalle = \"Théatre Molière\")."]
[]
["La feuille Salle doit comporter une cellule réservée au titre de l'évènement qui sera valorisé au moment de la création de l'évènement."]
["De la même façon, cette cellule doit être connue des Macros. Pour ce faire, ouvrir le Module_Général du projet VBA et adapter la constante CelluleTitreFeuilleSalle pour indiquer cette cellule (ex. CelluleTitreFeuilleSalle = \"A1\")."]
[]
["Peu importe la présentation générale de la feuille à condition que les sièges réservables occupent chacun une cellule."]
["Les cellules des sièges réservables contiennent le numéro de siège et toute autre indication utile."]
[]
["Pour distinguer les cellules des sièges réservables des autres cellules de la feuille Salle, il faut procéder comme suit:"]
["- Sélectionner toute la feuille (clic coin haut gauche)"]
["- Sur la feuille, clic droit puis Format cellules"]
["- Sur l'onglet Protection, vérifier que la case Verrouillée est bien cochée. Si c'est un carré noir ou blanc, cocher cette case et faire <OK>"]
["- Sélectionner toutes les cellules de sièges réservables"]
["- Sur la sélection, clic droit puis Format cellules"]
["- Sur l'onglet Protection, décocher la case Verrouillée et faire <OK>"]
[]
["Les cellules non vérrouillées (propriété VBA .Locked = False) sont donc les cellules des sièges réservables."]
["Les cellules vérrouillées (propriété VBA .Locked = True) sont donc les cellules autres de description de la salle."]
[]
["La feuille Salle doit aussi contenir une Macro VBA pour que, lors d'un double-clic sur une cellule de siège, un fonction ad-hoc soit appelée pour faire la réservation ou la libération."]
["Private Sub Worksheet_BeforeDoubleClick(ByVal target As Range, Cancel As Boolean)"]
["    Call DoubleClickSurFeuilleÉvènementSalle(target, Cancel)"]
["End Sub"]
[]
["Il peut-être utile d'insérer un bouton sur la feuille Salle pour permettre un retour rapide d'un évènement sur la feuille Opérations."]
["Private Sub BtnRetourOpérations_Click()"]
["    ThisWorkbook.Worksheets(NomFeuilleOpérations).Activate"]
["End Sub"]
[]
["Il peut-être utile d'insérer un bouton sur la feuille Salle pour afficher la feuille Réservations correspondante et permettre un basculement rapide entre les 2 feuilles d'un évènement. "]
["Private Sub BtnRetourOpérations_Click()"]
["    ThisWorkbook.Worksheets(NomFeuilleOpérations).Activate"]
["End Sub"]
[]
[]
["Comment créer une liste des réservations"]
[]
["Une liste de réservations est créée sur une feuille dédiée."]
["Le nom de cette feuille doit être connu des Macros. Pour ce faire, ouvrir le Module_Général du projet VBA et adapter la constante NomFeuilleRéservation au nom donné à la feuille (ex. NomFeuilleRéservations = \"Réservations\")."]
[]
["La feuille Réservations doit comporter une cellule réservée au titre de l'évènement qui sera valorisé au moment de la création de l'évènement."]
["De la même façon, cette cellule doit être connue des Macros. Pour ce faire, ouvrir le Module_Général du projet VBA et adapter la constante CelluleTitreFeuilleRéservations pour indiquer cette cellule (ex. CelluleTitreFeuilleRéservations = \"A1\")."]
[]
["Le contenu de la feuille Réservations est un tableau qui comporte les colonnes suivantes:"]
["- Action (Réservation / Annulation)"]
["- Date"]
["-Nom du spectateur"]
["- Numéro de siège"]
["- État du paiement"]
["- Adresse"]
["- Téléphone"]
["- Adresse mail"]
["Les numéros de colonnes doivent être connus des Macros. Pour ce faire, ouvrir le Module_Général du projet VBA et adapter les constantes décrivant les numéros des colonnes des informations listées ci-dessus."]
[]
["Il peut-être utile d'insérer une fonction qui sur double-clic permet de revenir sur la feuille Salle de l'évènement pour permettre un basculement rapide entre les 2 feuilles d'un évènement."]
["Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)"]
["    'Double-clic en colonne \"A\" revient sur la feuille Évènement Salle"]
["    If Intersect(Target, Me.Range(\"A:A\")) Is Nothing Then Exit Sub"]
["    Cancel = True"]
["    ThisWorkbook.Worksheets(Me.Index - 1).Activate"]
["End Sub"]
[]
["Comment créer un évènement"]
[]
["Sur la feuille Opérations, cliquer sur le bouton Créer un Évènement."]
["Une copie de la feuille Salle sera réalisée et les cellules des sièges réservables seront colorées en bleu. Cette feuille est connue sous le nom de feuille Évènement Salle."]
["Une copie de la feuille Réservations sera réalisée, juxtaposée à la feuille Salle créée pour suivre les réservations liées à l'évènement. Cette feuille est connue sous le nom de feuille Évènement Réservations."]
[]
["Les feuilles Évènement Salle ont pour nom la date de l'évènement sous forme \"d mmm yyyy hh\\hnn\", c’est-à-dire:"]
["\"jour (1 ou 2 caractères) + espace + mois (3 à 5 caractères) + espace + année (4 caractères) + espace + heure (2 caractères) + 'h' + minutes (2 caractères)\""]
[]
["Les feuilles Évènement Réservations ont pour nom \"Résa + nom de la feuille Évènement Salle\"."]
[]
["Comment supprimer un évènement"]
[]
["Pour supprimer un évènement, supprimer simplement les 2 feuilles correspondantes."]
["ATTENTION: supprimer la feuille Évènement Réservations dans supprimer la feuille Évènement Salle est une situation anormale."]
[]
["Comment réserver ou libérer des sièges"]
[]
["Sur la feuille Évènement Salle double-cliquer sur le siège."]
["S'il est disponible il sera réservé en prenant la couleur rouge, s'il est déjà réservé, après un message de warning, il sera libéré en prenant la couleur bleue."]
["La feuille Évènement Réservation s'ouvrira pour pouvoir saisir les informations de réservation."]

{"sheet":"Salle Stella Moncoutant","index":1,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,24,14],[0,0,0,14],[1,0,1,14],[6,1,6,13],[1,15,1,16],[2,1,3,3]]}
["Titre de l'évènements"]
["SALLE SPECTACLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrée"]
[null,"REGIE",null,null,null,"Q10","Q9","Q8","Q7","Q6","Q5","Q4","Q3","Q2","Q1"]
[null,null,null,null,"P9","P8","P7","P6","P5","P4","P3","P2","P1","PG",null,"Strapontin"]
["X","O12","O11","O10","O9","O8","O7","O6","O5","O4","O3","O2","O1","OG",null,"Strapontin"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X",null,null,"Strapontin"]
["Strapontin","Allée"]
["MD","M15","M14","M13","M12","M11","M10","M9","M8","M7","M6","M5","M4","M3","M2","M1","MG"]
["LD","L15","L14","L13","L12","L11","L10","L9","L8","L7","L6","L5","L4","L3","L2","L1","LG"]
["KD","K15","K14","K13","K12","K11","K10","K9","K8","K7","K6","K5","K4","K3","K2","K1","KG"]
["JD","J15","J14","J13","J12","J11","J10","J9","J8","J7","J6","J5","J4","J3","J2","J1","JG"]
["ID","I15","I14","I13","I12","I11","I10","I9","I8","I7","I6","I5","I4","I3","I2","I1","IG"]
["HD","H15","H14","H13","H12","H11","H10","H9","H8","H7","H6","H5","H4","H3","H2","H1","HG"]
["GD","G15","G14","G13","G12","G11","G10","G9","G8","G7","G6","G5","G4","G3","G2","G1","GG"]
["FD","F15","F14","F13","F12","F11","F10","F9","F8","F7","F6","F5","F4","F3","F2","F1","FG"]
["ED","E15","E14","E13","E12","E11","E10","E9","E8","E7","E6","E5","E4","E3","E2","E1","EG"]
["DD","D15","D14","D13","D12","D11","D10","D9","D8","D7","D6","D5","D4","D3","D2","D1","DG"]
["CD","C15","C14","C13","C12","C11","C10","C9","C8","C7","C6","C5","C4","C3","C2","C1","CG"]
["BD","B15","B14","B13","B12","B11","B10","B9","B8","B7","B6","B5","B4","B3","B2","B1","BG"]
["AD","A15","A14","A13","A12","A11","A10","A9","A8","A7","A6","A5","A4","A3","A2","AG"]
[]
[]
["Strapontin","SCENE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strapontin"]

{"sheet":"Réservations","index":2,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Titre de l'évènements"]
["Action","Date","Nom Spectateur","N°  place","Paiement","Adresse (facultatif)","Tél. (facultatif)","Mail (facultatif) "]

{"sheet":"Opérations","index":3,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Pour choisir un évènement, cliquer dans la liste →",null,null,null,"Liste des évènements"]
[null,null,null,null,null,null,"Dimanche 15 septembre 2019 20h30",null,"Josh Smith"]
[null,null,null,null,null,null,"Dimanche 20 octobre 2019 21h00",null,"Madona Tour"]
[null,null,null,null,null,null,"Lundi 16 décembre 2019 20h45",null,"Le fil à la patte"]
[null,null,null,null,null,null,"Samedi 28 décembre 2019 18h00",null,"test"]

{"sheet":"28 déc 2019 18h00","index":4,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,24,14],[0,0,0,14],[1,0,1,14],[1,15,1,16],[2,1,3,3],[6,1,6,13]]}
["test"]
["SALLE SPECTACLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrée"]
[null,"REGIE",null,null,null,"Q10","Q9","Q8","Q7","Q6","Q5","Q4","Q3","Q2","Q1"]
[null,null,null,null,"P9","P8","P7","P6","P5","P4","P3","P2","P1","PG",null,"Strapontin"]
["X","O12","O11","O10","O9","O8","O7","O6","O5","O4","O3","O2","O1","OG",null,"Strapontin"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X",null,null,"Strapontin"]
["Strapontin","Allée"]
["MD","M15","M14","M13","M12","M11","M10","M9","M8","M7","M6","M5","M4","M3","M2","M1","MG"]
["LD","L15","L14","L13","L12","L11","L10","L9","L8","L7","L6","L5","L4","L3","L2","L1","LG"]
["KD","K15","K14","K13","K12","K11","K10","K9","K8","K7","K6","K5","K4","K3","K2","K1","KG"]
["JD","J15","J14","J13","J12","J11","J10","J9","J8","J7","J6","J5","J4","J3","J2","J1","JG"]
["ID","I15","I14","I13","I12","I11","I10","I9","I8","I7","I6","I5","I4","I3","I2","I1","IG"]
["HD","H15","H14","H13","H12","H11","H10","H9","H8","H7","H6","H5","H4","H3","H2","H1","HG"]
["GD","G15","G14","G13","G12","G11","G10","G9","G8","G7","G6","G5","G4","G3","G2","G1","GG"]
["FD","F15","F14","F13","F12","F11","F10","F9","F8","F7","F6","F5","F4","F3","F2","F1","FG"]
["ED","E15","E14","E13","E12","E11","E10","E9","E8","E7","E6","E5","E4","E3","E2","E1","EG"]
["DD","D15","D14","D13","D12","D11","D10","D9","D8","D7","D6","D5","D4","D3","D2","D1","DG"]
["CD","C15","C14","C13","C12","C11","C10","C9","C8","C7","C6","C5","C4","C3","C2","C1","CG"]
["BD","B15","B14","B13","B12","B11","B10","B9","B8","B7","B6","B5","B4","B3","B2","B1","BG"]
["AD","A15","A14","A13","A12","A11","A10","A9","A8","A7","A6","A5","A4","A3","A2","AG"]
[]
[]
["Strapontin","SCENE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strapontin"]

{"sheet":"Résa 28 déc 2019 18h00","index":5,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["test"]
["Action","Date","Nom Spectateur","N°  place","Paiement","Adresse (facultatif)","Tél. (facultatif)","Mail (facultatif) "]
["Réservation","2019-08-28T22:54:32",null,"G4"]

{"sheet":"20 oct 2019 21h00","index":6,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,24,14],[0,0,0,14],[1,0,1,14],[1,15,1,16],[2,1,3,3],[6,1,6,13]]}
["Madona Tour"]
["SALLE SPECTACLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrée"]
[null,"REGIE",null,null,null,"Q10","Q9","Q8","Q7","Q6","Q5","Q4","Q3","Q2","Q1"]
[null,null,null,null,"P9","P8","P7","P6","P5","P4","P3","P2","P1","PG",null,"Strapontin"]
["X","O12","O11","O10","O9","O8","O7","O6","O5","O4","O3","O2","O1","OG",null,"Strapontin"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X",null,null,"Strapontin"]
["Strapontin","Allée"]
["MD","M15","M14","M13","M12","M11","M10","M9","M8","M7","M6","M5","M4","M3","M2","M1","MG"]
["LD","L15","L14","L13","L12","L11","L10","L9","L8","L7","L6","L5","L4","L3","L2","L1","LG"]
["KD","K15","K14","K13","K12","K11","K10","K9","K8","K7","K6","K5","K4","K3","K2","K1","KG"]
["JD","J15","J14","J13","J12","J11","J10","J9","J8","J7","J6","J5","J4","J3","J2","J1","JG"]
["ID","I15","I14","I13","I12","I11","I10","I9","I8","I7","I6","I5","I4","I3","I2","I1","IG"]
["HD","H15","H14","H13","H12","H11","H10","H9","H8","H7","H6","H5","H4","H3","H2","H1","HG"]
["GD","G15","G14","G13","G12","G11","G10","G9","G8","G7","G6","G5","G4","G3","G2","G1","GG"]
["FD","F15","F14","F13","F12","F11","F10","F9","F8","F7","F6","F5","F4","F3","F2","F1","FG"]
["ED","E15","E14","E13","E12","E11","E10","E9","E8","E7","E6","E5","E4","E3","E2","E1","EG"]
["DD","D15","D14","D13","D12","D11","D10","D9","D8","D7","D6","D5","D4","D3","D2","D1","DG"]
["CD","C15","C14","C13","C12","C11","C10","C9","C8","C7","C6","C5","C4","C3","C2","C1","CG"]
["BD","B15","B14","B13","B12","B11","B10","B9","B8","B7","B6","B5","B4","B3","B2","B1","BG"]
["AD","A15","A14","A13","A12","A11","A10","A9","A8","A7","A6","A5","A4","A3","A2","AG"]
[]
[]
["Strapontin","SCENE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strapontin"]

{"sheet":"Résa 20 oct 2019 21h00","index":7,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Madona Tour"]
["Action","Date","Nom Spectateur","N°  place","Paiement","Adresse (facultatif)","Tél. (facultatif)","Mail (facultatif) "]
["Réservation","2019-08-28T22:54:57",null,"H8"]
["Réservation","2019-08-28T22:55:02",null,"H7"]

{"sheet":"15 sept 2019 20h30","index":8,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,24,14],[0,0,0,14],[1,0,1,14],[1,15,1,16],[2,1,3,3],[6,1,6,13]]}
["Josh Smith"]
["SALLE SPECTACLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrée"]
[null,"REGIE",null,null,null,"Q10","Q9","Q8","Q7","Q6","Q5","Q4","Q3","Q2","Q1"]
[null,null,null,null,"P9","P8","P7","P6","P5","P4","P3","P2","P1","PG",null,"Strapontin"]
["X","O12","O11","O10","O9","O8","O7","O6","O5","O4","O3","O2","O1","OG",null,"Strapontin"]
["X","X","X","X","X","X","X","X","X","X","X","X","X","X",null,null,"Strapontin"]
["Strapontin","Allée"]
["MD","M15","M14","M13","M12","M11","M10","M9","M8","M7","M6","M5","M4","M3","M2","M1","MG"]
["LD","L15","L14","L13","L12","L11","L10","L9","L8","L7","L6","L5","L4","L3","L2","L1","LG"]
["KD","K15","K14","K13","K12","K11","K10","K9","K8","K7","K6","K5","K4","K3","K2","K1","KG"]
["JD","J15","J14","J13","J12","J11","J10","J9","J8","J7","J6","J5","J4","J3","J2","J1","JG"]
["ID","I15","I14","I13","I12","I11","I10","I9","I8","I7","I6","I5","I4","I3","I2","I1","IG"]
["HD","H15","H14","H13","H12","H11","H10","H9","H8","H7","H6","H5","H4","H3","H2","H1","HG"]
["GD","G15","G14","G13","G12","G11","G10","G9","G8","G7","G6","G5","G4","G3","G2","G1","GG"]
["FD","F15","F14","F13","F12","F11","F10","F9","F8","F7","F6","F5","F4","F3","F2","F1","FG"]
["ED","E15","E14","E13","E12","E11","E10","E9","E8","E7","E6","E5","E4","E3","E2","E1","EG"]
["DD","D15","D14","D13","D12","D11","D10","D9","D8","D7","D6","D5","D4","D3","D2","D1","DG"]
["CD","C15","C14","C13","C12","C11","C10","C9","C8","C7","C6","C5","C4","C3","C2","C1","CG"]
["BD","B15","B14","B13","B12","B11","B10","B9","B8","B7","B6","B5","B4","B3","B2","B1","BG"]
["AD","A15","A14","A13","A12","A11","A10","A9","A8","A7","A6","A5","A4","A3","A2","AG"]
[]
[]
["Strapontin","SCENE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strapontin"]

{"sheet":"Résa 15 sept 2019 20h30","index":9,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Josh Smith"]
["Action","Date","Nom Spectateur","N°  place","Paiement","Adresse (facultatif)","Tél. (facultatif)","Mail (facultatif) "]
["Réservation","2019-08-28T22:12:18",null,"H4"]
["Réservation","2019-08-28T22:12:38",null,"H5"]
["Réservation","2019-08-28T22:12:43",null,"H6"]
["Annulation","2019-08-28T22:16:12",null,"H4"]
["Réservation","2019-08-28T22:27:05",null,"G7"]
["Réservation","2019-08-28T22:27:14",null,"G6"]
["Réservation","2019-08-28T22:27:17",null,"G5"]
["Réservation","2019-08-28T22:27:19",null,"G4"]
["Réservation","2019-08-28T22:27:22",null,"G3"]
["Réservation","2019-08-28T22:27:25",null,"F7"]
["Réservation","2019-08-28T22:27:42",null,"F6"]
["Réservation","2019-08-28T22:30:07",null,"F5"]
["Réservation","2019-08-28T22:30:11",null,"F4"]
["Réservation","2019-08-28T22:30:13",null,"F3"]
["Réservation","2019-08-28T22:30:15",null,"H4"]
["Réservation","2019-08-28T22:32:41",null,"H3"]
["Réservation","2019-08-28T22:32:50",null,"H7"]

{"sheet":"16 déc 2019 20h45","index":10,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,21,11],[3,0,3,4],[0,0,0,10],[1,0,1,10],[2,0,2,9],[3,5,16,5],[13,6,13,11],[13,0,13,4]]}
["Le fil à la patte"]
["Salle Jean"]
[]
["REGIE",null,null,null,null,null,"J6","J5","J4","J3","J2","J1"]
["i10","i9","i8","i7","i6b",null,"i6","i5","i4","i3","i2","i1"]
["H10","H9","H8","H7","H6b",null,"H6","H5","H4","H3","H2","H1"]
["G10","G9","G8","G7","G6b",null,"G6","G5","G4","G3","G2","G1"]
["F10","F9","F8","F7","F6b",null,"F6","F5","F4","F3","F2","F1"]
["E10","E9","E8","E7","E6b",null,"E6","E5","E4","E3","E2","E1"]
["D10","D9","D8","D7","D6b",null,"D6","D5","D4","D3","D2","D1"]
["C10","C9","C8","C7","C6b",null,"C6","C5","C4","C3","C2","C1"]
["B10","B9","B8","B7","B6b",null,"B6","B5","B4","B3","B2","B1"]
["A10","A9","A8","A7","A6b",null,"A6","A5","A4","A3","A2","A1"]
["ALLEE",null,null,null,null,null,"ALLEE"]
["CH30","CH29","CH28","CH27","CH26b",null,"CH26","CH25","CH24","CH23","CH22","CH21"]
["CH20","CH19","CH18","CH17","CH16b",null,"CH16","CH15","CH14","CH13","CH12","CH11"]
["CH10","CH9","CH8","CH7","CH6b",null,"CH6","CH5","CH4","CH3","CH2","CH1"]
[]
[]
["SCENE"]

{"sheet":"Résa 16 déc 2019 20h45","index":11,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Le fil à la patte"]
["Action","Date","Nom Spectateur","N°  place","Paiement","Adresse (facultatif)","Tél. (facultatif)","Mail (facultatif) "]
["Réservation","2019-08-29T14:30:48","Durant Laurent","C4",8]
["Réservation","2019-08-29T16:26:39","Machin Michel","H4",8]
["Réservation","2019-08-29T16:26:42","Machin Michel","H5",8]
["Réservation","2019-08-29T16:27:01","Bertin Antoine","CH14",8]
["Réservation","2019-08-29T16:27:04","Bertin Antoine","CH15",8]
["Réservation","2019-08-29T16:27:09","Bertin Antoine","CH16",4]
["Réservation","2019-08-29T16:27:12","Bertin Antoine","CH16b",8]