{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Opérations","Information","Salle spectacle","15 déc 2019","8 janv 2020","27 mars 2020","réservation 15 déc 2019"],"not_rendered":{"charts":0,"images":5,"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":"Opérations","index":0,"n_rows":5,"n_cols":9,"rows_kept":5,"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 décembre 2019",null,"Josh Smith"]
[null,null,null,null,null,null,"Mercredi 8 janvier 2020",null,"Madona Tour"]
[null,null,null,null,null,null,"Vendredi 27 mars 2020",null,"Troupe \"Les joyeux comédiens\""]

{"sheet":"Information","index":1,"n_rows":48,"n_cols":1,"rows_kept":48,"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ènement(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. Dans ce cas, le bouton doit activer la feuille Opérations."]
["Private Sub BtnRetourOpérations_Click()"]
["    ThisWorkbook.Worksheets(NomFeuilleOpérations).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 vert."]
[]
["Les feuilles Évènement ont pour nom la date de l'évènement sous forme \"d mmm yyyy\", c’est-à-dire \"jour (1 ou 2 caractères) + espace + mois (3 ou 4 caractères) + espace + année (4 caractères)\""]
["Ne pas créer manuellement de feuille dont le nom serait une date quellequen soit le format. Sauf à dessein. Elle serait reconnue comme une feuille Évènement."]
[]
["Comment supprimer un évènement"]
[]
["Pour supprimer un évènement, supprimer simplement la feuille correspondante."]
[]
["Comment réserver ou libérer des sièges"]
[]
["Sur la feuille Évènement double-cliquer sur le siège."]
["S'il est disponible il sera réservé, s'il est déjà réservé, après un message de warning, il sera libéré."]

{"sheet":"Salle spectacle","index":2,"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":"15 déc 2019","index":3,"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":"8 janv 2020","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]]}
["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":"27 mars 2020","index":5,"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]]}
["Troupe \"Les joyeux comédiens\""]
["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éservation 15 déc 2019","index":6,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
[]
["Réservation Josh Smith"]
[]
["Date de réservation","Nom Spectateur","N°  place","Etat place","adresse (facultatif","Tél. (facultatif)","Mail (facultatif) "]
["2019-08-22","Durand",{"$f":"'15 déc 2019'!M18","v":"C4"},"Payé"]
["2019-08-22","Durand"]
["2019-08-22","Durand"]
["2019-08-28","Machin"]
["2019-08-28","Brunet"]