{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Immatriculation (2)","Résultat","vba","EXPLICATION AVEC  GV 001 AA"],"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":"Immatriculation (2)","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["A",1,null,null,null,null,null,null,null,1,"A"]
["B",2,{"$f":"Résultat!B3","v":"gz999zz"},null,null,null,null,{"$f":"C5*E5*F5","v":74461464},null,2,"B"]
["C",3,{"$f":"LEFT(C2,1)","v":"g"},{"$f":"MID(C2,2,1)","v":"z"},{"$f":"MID(C2,3,3)","v":"999"},{"$f":"MID(C2,6,1)","v":"z"},{"$f":"MID(C2,7,1)","v":"z"},null,null,3,"C"]
["D",4,{"$f":"VLOOKUP(C3,$A$1:$B$22,2,FALSE)","v":7},{"$f":"VLOOKUP(D3,$A$1:$B$22,2,FALSE)","v":22},null,{"$f":"VLOOKUP(F3,$A$1:$B$22,2,FALSE)","v":22},{"$f":"VLOOKUP(G3,$A$1:$B$22,2,FALSE)","v":22},null,null,4,"D"]
["E",5,{"$f":"22*(C4-1)+D4","v":154},null,{"$f":"E3","v":"999"},{"$f":"22*(F4-1)+G4","v":484},null,null,null,5,"E"]
["F",6,null,null,null,null,null,null,null,6,"F"]
["G",7,null,null,null,null,null,null,null,7,"G"]
["H",8,null,null,null,null,null,null,null,8,"H"]
["J",9,null,null,null,null,null,null,null,9,"J"]
["K",10,null,null,null,null,null,null,null,10,"K"]
["L",11,null,null,null,null,null,null,null,11,"L"]
["M",12,null,null,null,null,null,null,null,12,"M"]
["N",13,null,null,null,null,null,null,null,13,"N"]
["P",14,null,null,null,null,null,null,null,14,"P"]
["Q",15,null,null,null,null,null,null,null,15,"Q"]
["R",16,null,null,null,null,null,null,null,16,"R"]
["S",17,null,null,null,null,null,null,null,17,"S"]
["T",18,null,null,null,null,null,null,null,18,"T"]
["W",19,null,null,null,null,null,null,null,19,"W"]
["X",20,null,null,null,null,null,null,null,20,"X"]
["Y",21,null,null,null,null,null,null,null,21,"Y"]
["Z",22,null,null,null,null,null,null,null,22,"Z"]

{"sheet":"Résultat","index":1,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,1,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"B"]
[null,"gz999zz",null,null,{"$f":"'Immatriculation (2)'!H2","v":74461464},null,null,"IMMATRICULATIONS",null,null,null,null,null,null,null,null,null,null,null,3,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"D"]
[null,null,null,null,null,null,null,null,"Mets la valeur de la plaque recherchée",null,825123,null,null,null,null,null,null,null,null,5,"E"]
[null,null,null,null,null,null,null,null,null,null,"Plaque ",null,null,null,null,null,null,null,null,7,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"J"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"P"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Q"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"Z"]
[]
[]
[]
[]
["D"]

{"sheet":"vba","index":2,"n_rows":43,"n_cols":1,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Sub aaa()"]
["Z = 1: w = 1"]
["For a = 1 To 22"]
["For b = 1 To 22"]
["For c = 1 To 999"]
["For d = 1 To 22"]
["For e = 1 To 22"]
[]
["'For pp = 8 To 50"]
["'Cells(pp, 12) = \"\""]
["'Next pp"]
[]
["soluce = (a * 22 - 22 + b) * c * (d * 22 - 22 + e)"]
["Cells(15, 5) = soluce"]
["   "]
["    If soluce = Cells(5, 12) Then"]
["               "]
["        'plaque"]
["        For i = 1 To 22"]
["            If a = Cells(i, 20) Then lettrea = Cells(i, 21)"]
["            If b = Cells(i, 20) Then lettreb = Cells(i, 21)"]
["            If d = Cells(i, 20) Then lettred = Cells(i, 21)"]
["            If e = Cells(i, 20) Then lettree = Cells(i, 21)"]
["        Next i"]
["        "]
["        'ecriture de la plaque"]
["        Cells(7 + w, 22) = lettrea"]
["        Cells(7 + w, 23) = lettreb"]
["        Cells(7 + w, 24) = c"]
["        Cells(7 + w, 25) = lettred"]
["        Cells(7 + w, 26) = lettree"]
["        '--------------------------------------------"]
["        "]
["        Cells(7 + Z, 11) = Z"]
["        MsgBox (\"Plaque suivante\"): Z = Z + 1: w = w + 1"]
["    End If"]
["Next"]
["Next"]
["Next"]
["Next"]
["Next"]
[]
["End Sub"]

{"sheet":"EXPLICATION AVEC  GV 001 AA","index":3,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["A",null,"B",null,"C",null,"D",null,"E",null,"F",null,"G"]
["A","a","B","a","C","a","D","a","E","a","F","a","G","a",null,null,null,"Le tout premier numéro est le AA-001-AA suivi du AA-002-AA jusqu’à AA-999-AA puis AA-001-AB et ainsi de suite jusqu’à AA-999-ZZ. Ensuite c’est la même chose de AB-001-AA jusqu’à AB-999-ZZ et ainsi de suite jusqu’à ZZ-999-ZZ."]
["A","b","B","b","C","b","D","b","E","b","F","b","G","b"]
["A","c","B","c","C","c","D","c","E","c","F","c","G","c"]
["A","d","B","d","C","d","D","d","E","d","F","d","G","d"]
["A","e","B","e","C","e","D","e","E","e","F","e","G","e"]
["A","f","B","f","C","f","D","f","E","f","F","f","G","f"]
["A","g","B","g","C","g","D","g","E","g","F","g","G","g",null,null,null,null,null,"nota : il n'y a pas de i, pas de o, pas de u, pas de v"]
["A","h","B","h","C","h","D","h","E","h","F","h","G","h",null,null,null,null,null,"et pas de ss"]
["A","j","B","j","C","j","D","j","E","j","F","j","G","j",null,"GV001AA",null,null,null,"et pas de ww dans la première série"]
["A","k","B","k","C","k","D","k","E","k","F","k","G","k",null,"GV = 24*6+20",{"$f":"24*6+20","v":164}]
["A","l","B","l","C","l","D","l","E","l","F","l","G","l",null,"6 de a à z et 1 de a à v"]
["A","m","B","m","C","m","D","m","E","m","F","m","G","m",null,"donc 24*6 + 20"]
["A","n","B","n","C","n","D","n","E","n","F","n","G","n"]
["A","p","B","p","C","p","D","p","E","p","F","p","G","p",null,"et 001 AA, ça fait 1"]
["A","q","B","q","C","q","D","q","E","q","F","q","G","q"]
["A","r","B","r","C","r","D","r","E","r","F","r","G","r"]
["A","s","B","s","C","s","D","s","E","s","F","s","G","s"]
["A","t","B","t","C","t","D","t","E","t","F","t","G","t"]
["A","u","B","u","C","u","D","u","E","u","F","u","G","u"]
["A","v","B","v","C","v","D","v","E","v","F","v","G","V",20]
["A","w","B","w","C","w","D","w","E","w","F","w","G","w"]
["A","x","B","x","C","x","D","x","E","x","F","x","G","x"]
["A","y","B","y","C","y","D","y","E","y","F","y","G","y"]
["A","z","B","z","C","z","D","z","E","z","F","z","G","z"]
[null,24,null,48,null,72,null,96,null,120,null,144,null,168]