{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Personnel","Cadets","Bénévoles","Export_Personnel","Export_Cadets","Export_Benevoles","Grades","Options"],"not_rendered":{"charts":0,"images":0,"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":"Instructions","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,11],[10,1,10,6],[10,7,10,9]]}
["Inscription d'une unité au système Moodle"]
[]
["1.  Remplir les listes d'utilisateurs dans les onglets ci-dessous."]
["2.  Faire parvenir la liste à moodle-support@cc376.ca."]
["3.  Lorsque les comptes seront créés, chaque usager recevra un courriel l'avisant de son nom d'utilisateur et de son mot de passe."]
[null,"a.  Les noms d'usager pour le personnel seront composés des 3 derniers chiffres du matricule et du nom de famille (comme sur le RÉOCC)"]
[null,"b.  Les noms d'usager pour les cadets seront composés de la lettre \"c\" et de leur NIC (ex. c2012345)"]
[null,"c.  Les noms d'usager pour les bénévoles seront composés de leur nom de famille suivi de leurs initiales  (ex. bloggins.j)"]
["4.  La création des comptes pourrait prendre jusqu'à 48 heures."]
[]
[null,"Veuillez sélectionner votre unité :",null,null,null,null,null,"CCMRC 08"]

{"sheet":"Personnel","index":1,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Liste du personnel"]
["3 derniers du NM","Nom","Prénom","Grade","Courriel"]

{"sheet":"Cadets","index":2,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Liste des cadets"]
["NIC","Nom","Prénom","Grade","Courriel"]

{"sheet":"Bénévoles","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Liste des bénévoles"]
["Nom","Prénom","Courriel"]

{"sheet":"Export_Personnel","index":4,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["username","email","firstname","lastname","department","city","country","profile_field_grade"]
[{"$f":"CONCATENATE(Personnel!A3,MajSansAccent(LOWER(Personnel!B3)))","v":""},{"$f":"Personnel!E3","v":0},{"$f":"Personnel!C3","v":0},{"$f":"Personnel!B3","v":0},{"$f":"Instructions!$H$11","v":"CCMRC 08"},"Québec","CA",{"$f":"INDIRECT(ADDRESS(MATCH(LOWER(Personnel!D3),Grades!A:A,0),2,1,1,\"Grades\"),1)","v":{"$error":"#N/A"}}]

{"sheet":"Export_Cadets","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["username","email","firstname","lastname","department","city","country","profile_field_grade"]
[{"$f":"CONCATENATE(\"c\",Cadets!A3)","v":"c"},{"$f":"Cadets!E3","v":0},{"$f":"Cadets!C3","v":0},{"$f":"Cadets!B3","v":0},{"$f":"Instructions!$H$11","v":"CCMRC 08"},"Québec","CA",{"$f":"INDIRECT(ADDRESS(MATCH(LOWER(Cadets!D3),Grades!A:A,0),2,1,1,\"Grades\"),1)","v":{"$error":"#N/A"}}]

{"sheet":"Export_Benevoles","index":6,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["username","email","firstname","lastname","department","city","country","profile_field_grade"]
[{"$f":"CONCATENATE(MajSansAccent(LOWER(Bénévoles!A3)),\".\",LEFT(MajSansAccent(LOWER(Bénévoles!B3)),1))","v":"."},{"$f":"Bénévoles!C3","v":0},{"$f":"Bénévoles!B3","v":0},{"$f":"Bénévoles!A3","v":0},{"$f":"Instructions!$H$11","v":"CCMRC 08"},"Québec","CA",{"$f":"INDIRECT(ADDRESS(MATCH(LOWER(\"Civ\"),Grades!A:A,0),2,1,1,\"Grades\"),1)","v":"Civ"}]

{"sheet":"Grades","index":7,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["Grade FR","Moodle"]
["cdt","cdt / cdt"]
["mat3","mat3 / OC"]
["lcpl","lcpl / lcpl"]
["cdt1","cdt1 / LAC"]
["mat2","mat2 / AB"]
["cpl","cpl / cpl"]
["mat1","mat1 / LC"]
["cplc","cplc / MCpl"]
["cpls","cpls / FCpl"]
["matc","matc / MC"]
["sgt","sgt / Sgt"]
["m2","m2 / PO2"]
["adj","adj / WO"]
["sgts","sgts / FSgt"]
["m1","m1 / PO1"]
["adjum","adjum / MWO"]
["adj2","adj2 / WO2"]
["pm2","pm2 / CPO2"]
["adjuc","adjuc / CWO"]
["adj1","adj1 / WO1"]
["pm1","pm1 / CPO1"]
["IC","IC / CI"]
["civ","Civ"]
["elof","elof / OCdt"]
["aspm","aspm / NCdt"]
["slt","slt / 2Lt"]
["ens2","ens2 / A/SLt"]
["lt","lt / Lt"]
["ens1","ens1 / SLt"]
["capt","capt / Capt"]
["ltv","ltv / Lt(N)"]
["maj","maj / Maj"]
["capc","capc / LCdt"]
["lcol","lcol / LCol"]
["capf","capf / Cdr"]
[null,"col / Col"]
[null,"capv / Capt(N)"]
[null,"bgen / BGen"]
[null,"cmdre / Cmdre"]
[null,"mgen / MGen"]
[null,"cam / RAdm"]
[null,"lgen / LGen"]
[null,"vam / VAdm"]
[null,"gen / Gen"]
[null,"am / Adm"]

{"sheet":"Options","index":8,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["Grades","Grades FR",null,"Unités"]
["cdt / cdt","cdt",null,"CCMRC 08"]
["mat3 / OC","mat3",null,"CCMRC 267"]
["lcpl / lcpl","lcpl",null,"CCMRC 287"]
["cdt1 / LAC","cdt1",null,"CCMRC 317"]
["mat2 / AB","mat2",null,"CC 376"]
["cpl / cpl","cpl",null,"CC 2600"]
["mat1 / LC","mat1",null,"CC 2628"]
["cplc / MCpl","cplc",null,"CC 2630"]
["cpls / FCpl","cpls",null,"CC 2772"]
["matc / MC","matc",null,"CC 2846"]
["sgt / Sgt","sgt",null,"CC 2847"]
["m2 / PO2","m2",null,"CC 2913"]
["adj / WO","adj",null,"ESC 629"]
["sgts / FSgt","sgts",null,"ESC 630"]
["m1 / PO1","m1",null,"ESC 798"]
["adjum / MWO","adjum",null,"ESC 894"]
["adj2 / WO2","adj2",null,"ESC 901"]
["pm2 / CPO2","pm2",null,"ESC 921"]
["adjuc / CWO","adjuc"]
["adj1 / WO1","adj1"]
["pm1 / CPO1","pm1"]
["Civ","civ"]
["IC / CI","IC"]
["elof / OCdt","elof"]
["aspm / NCdt","aspm"]
["slt / 2Lt","slt"]
["ens2 / A/SLt","ens2"]
["lt / Lt","lt"]
["ens1 / SLt","ens1"]
["capt / Capt","capt"]
["ltv / Lt(N)","ltv"]
["maj / Maj","maj"]
["capc / LCdt","capc"]
["lcol / LCol","lcol"]
["capf / Cdr","capf"]
["col / Col"]
["capv / Capt(N)"]
["bgen / BGen"]
["cmdre / Cmdre"]
["mgen / MGen"]
["cam / RAdm"]
["lgen / LGen"]
["vam / VAdm"]
["gen / Gen"]
["am / Adm"]