{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Test2","Feuil3"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":13,"n_cols":14,"rows_kept":13}
["Attribution d'une numérotation de PROCESSUS",{"$nulls":4},"Attribution d'une numérotation de PROCEDURE",{"$nulls":3},"Attribution d'une numérotation de DOCUMENT ASSOCIE à une procédure"]
["Type","N°","Version","Résultat",null,"Version","N° chrono journalier","Résultat",null,"Type de doc","Hiérarchie du doc","Version","N° du document associé","Résultat"]
[{"$nulls":3},{"$f":"IF(A3=\"\",\"\",IF(Feuil1!$A$3:$A$3=\"Management\",\"M\"&B3,IF(Feuil1!$A$3:$A$3=\"Production\",\"P\"&B3,IF(Feuil1!$A$3:$A$3=\"Support\",\"S\"&B3)))&\"-\"&C3)","v":""},null,"aa",{"$f":"IF(F3=\"\",\"\",MAX($G$2:G2)+1)","v":1},{"$f":"IF(F3=\"\",\"\",\"P-\" & YEAR(TODAY())-2000 & TODAY()-DATE(YEAR(TODAY()),1,0) & TEXT(G3,\"00\") & \"-\" & Feuil1!$F$3:$F$5)","v":"P-1629001-aa"},null,"Formulaire","02",15,"P-1628901-10",{"$f":"IF(J3=\"\",\"\",IF(Feuil1!$J$3:$J$4=\"Formulaire\",\"F\"&K3&\"-\"&RIGHT(LEFT(M3,9),7)&\"-\"&L3,IF(Feuil1!$J$3:$J$4=\"Guide\",\"G\"&K3&\"-\"&RIGHT(LEFT(M3,9),7)&\"-\"&L3,IF(Feuil1!$J$3:$J$4=\"Mode Opératoire\",\"M\"&K3&\"-\"&RIGHT(LEFT(M3,9),7)&\"-\"&L3))))","v":"F02-1628901-15"}]
[{"$nulls":5},"cc",{"$f":"IF(F4=\"\",\"\",MAX($G$2:G3)+1)","v":2},{"$f":"IF(F4=\"\",\"\",\"P-\" & YEAR(TODAY())-2000 & TODAY()-DATE(YEAR(TODAY()),1,0) & TEXT(G4,\"00\") & \"-\" & Feuil1!$F$3:$F$5)","v":"P-1629002-cc"},null,"Formulaire","02",null,null,{"$f":"IF(J4=\"\",\"\",IF(Feuil1!$J$3:$J$4=\"Formulaire\",\"F\"&K4&\"-\"&RIGHT(LEFT(M4,9),7)&\"-\"&L4,IF(Feuil1!$J$3:$J$4=\"Guide\",\"G\"&K4&\"-\"&RIGHT(LEFT(M4,9),7)&\"-\"&L4,IF(Feuil1!$J$3:$J$4=\"Mode Opératoire\",\"M\"&K4&\"-\"&RIGHT(LEFT(M4,9),7)&\"-\"&L4))))","v":"F02--"}]
[{"$nulls":5},"ff",{"$f":"IF(F5=\"\",\"\",MAX($G$2:G4)+1)","v":3},{"$f":"IF(F5=\"\",\"\",\"P-\" & YEAR(TODAY())-2000 & TODAY()-DATE(YEAR(TODAY()),1,0) & TEXT(G5,\"00\") & \"-\" & Feuil1!$F$3:$F$5)","v":"P-1629003-ff"}]
[{"$nulls":9},"Attribution d'une numérotation de DOCUMENT ASSOCIE à un formulaire"]
[{"$nulls":9},"Type de doc","Hiérarchie du doc","Version","N° du document associé","Résultat"]
[{"$nulls":9},"Guide","01",10,"F02-1628901-15",{"$f":"IF(J8=\"\",\"\",IF(Feuil1!$J$8:$J$9=\"Formulaire\",\"F\" & K8 & \"-\" & LEFT(M8,11) & \"-\"& L8,IF(Feuil1!$J$8:$J$9=\"Guide\",\"G\" & K8 & \"-\" & LEFT(M8,11) & \"-\"& L8,IF(Feuil1!$J$8:$J$9=\"Mode Opératoire\",\"M\" & K8 & \"-\" &  LEFT(M8,11) & \"-\"& L8))))","v":"G01-F02-1628901-10"}]
[]
[]
[{"$nulls":9},"Attribution d'une numérotation de DOCUMENT ASSOCIE à un Processus"]
[{"$nulls":9},"Type de doc","Hiérarchie du doc","Version","N° du document associé","Résultat"]
[{"$nulls":9},"Mode Opératoire","01",21,"P23-10",{"$f":"IF(J13=\"\",\"\",IF(Feuil1!$J$13:$J$14=\"Formulaire\",\"F\" & K13 & \"-\" & LEFT(M13,3) & \"-\"& L13,IF(Feuil1!$J$13:$J$14=\"Guide\",\"G\" & K13 & \"-\" & LEFT(M13,3) & \"-\"& L13,IF(Feuil1!$J$13:$J$14=\"Mode Opératoire\",\"M\" & K13 & \"-\" &  LEFT(M13,3) & \"-\"& L13))))","v":"M01-P23-21"}]

{"sheet":"Test2","index":1,"n_rows":4,"n_cols":3,"rows_kept":4}
["Titre1","Titre2","Titre3"]
["a",12,{"$f":"Tableau1[[#This Row],[Titre1]]&\"-\"&Tableau1[[#This Row],[Titre2]]","v":"a-12"}]
["b",12,{"$f":"Tableau1[[#This Row],[Titre1]]&\"-\"&Tableau1[[#This Row],[Titre2]]","v":"b-12"}]
["z",5,{"$f":"Tableau1[[#This Row],[Titre1]]&\"-\"&Tableau1[[#This Row],[Titre2]]","v":"z-5"}]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}