{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["UDI builder","BD GTIN","Paramètres","Page de garde"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":4,"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":"UDI builder","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,4],[5,2,5,4]]}
[]
[null,"Enter SMAIO medical device reference \n(8 or 9 digits)"]
[]
[null,{"$f":"IF(COUNTIF('BD GTIN'!$A:$C,'UDI builder'!$C$2)=0,\"\",IF(VLOOKUP($C$2,'BD GTIN'!$A:$C,2,FALSE)=\"Par lot\",Paramètres!$B$5,IF(VLOOKUP($C$2,'BD GTIN'!$A:$C,2,FALSE)=\"Serialise\",Paramètres!$B$4,\"\")))","v":""},null,{"$f":"IF(B4=\"Enter Serial Number under XXXXXX-XXX format\",\"-\",\"\")","v":""}]
[]
[null,{"$f":"IF(COUNTIF('BD GTIN'!$A:$C,'UDI builder'!$C$2)=0,\"\",IF(LEN($C$2)=9,Paramètres!$B$7,IF(LEN($C$2)=8,Paramètres!B$6,\"\")))","v":""},{"$f":"IF($C$2=\"\",\"\",IF(COUNTIF('BD GTIN'!$A:$C,'UDI builder'!$C$2)=0,Paramètres!$B$3,IF(AND($B$4=Paramètres!$B$5,'UDI builder'!$C$4<>\"\",'UDI builder'!$E$4=\"\"),CONCATENATE(\"(01)0\",VLOOKUP($C$2,'BD GTIN'!$A:$C,3,FALSE),\"(20)\",'UDI builder'!$C$4),IF(AND($B$4=Paramètres!$B$4,'UDI builder'!$C$4<>\"\",'UDI builder'!$E$4<>\"\"),CONCATENATE(\"(01)0\",(VLOOKUP($C$2,'BD GTIN'!$A:$C,3,FALSE)),\"(21)\",$C$4,\"-\",IF($E$4>99,$E$4,IF($E$4>9,CONCATENATE(\"0\",$E$4),CONCATENATE(\"00\",$E$4)))),\"\"))))","v":""}]

{"sheet":"BD GTIN","index":1,"n_rows":441,"n_cols":7,"rows_kept":441,"cut":false,"hidden":true,"merged":[]}
["Référence","Suivi de stock","GTIN",null,"Serialise","Par lot","Aucun"]
["01AS1010","Serialise","3701313002350"]
["01BC3010","Serialise","3701313002145"]
["01BC3015","Serialise","3701313002138"]
["01BC3610","Serialise","3701313003227"]
["01BC3615","Serialise","3701313003210"]
["01BF2010","Serialise","3701313002251"]
["01BK0001","Serialise","3701313007942"]
["01BP4010","Serialise","3701313002039"]
["01BP4015","Serialise","3701313002022"]
["01BS0001","Serialise","3701313001995"]
["01BS0002","Serialise",3701313007959]
["01BS0011","Serialise","3701313002633"]
["01BS0012","Serialise","3701313001988"]
["01BS0013","Serialise","3701313001971"]
["01BS0020","Serialise",3701313007966]
["01BS0021","Serialise",3701313007973]
["01BS0111","Serialise","3701313001964"]
["01BS0112","Serialise","3701313001957"]
["01BS0113","Serialise","3701313001940"]
["01BS0114","Serialise","3701313002640"]
["01BS0115","Serialise","3701313004989"]
["01BS3010","Serialise","3701313002121"]
["01BS3015","Serialise","3701313002114"]
["01BS3610","Serialise","3701313003203"]
["01BS3615","Serialise","3701313003197"]
["01BS4020","Serialise","3701313002626"]
["01CH3010","Serialise","3701313004910"]
["01CH4010","Serialise","3701313000394"]
["01CI1010","Serialise","3701313005009"]
["01CP4020","Serialise","3701313003166"]
["01CR3010","Serialise","3701313002107"]
["01CS4010","Serialise","3701313002015"]
["01DG1010","Serialise","3701313002848"]
["01DN2010","Serialise","3701313002244"]
["01DN2030","Serialise","3701313002770"]
["01DN3010","Serialise","3701313002664"]
["01DN3020","Serialise","3701313002657"]
["01DN5010","Serialise","3701313004903"]
["01DR3020","Serialise","3701313002091"]
["01DS1010","Serialise","3701313002831"]
["01DS2010","Serialise","3701313002787"]
["01DS2020","Serialise","3701313002237"]
["01DS2025","Serialise","3701313000356"]
["01DS2025_B","Serialise","3701313000356"]
["01DS2030","Serialise","3701313005016"]
["01FB1010","Serialise","3701313002824"]
["01FS1010","Serialise","3701313002343"]
["01FS1015","Serialise","3701313002336"]
["01GN2010","Serialise","3701313002763"]
["01GN2020","Serialise","3701313003159"]
["01GN2030","Serialise","3701313003142"]
["01GN2040","Serialise","3701313003135"]
["01GN2050","Serialise","3701313000349"]
["01GN2060","Serialise","3701313000332"]
["01GN2070","Serialise","3701313000325"]
["01GN2080","Serialise","3701313000318"]
["01GR3030","Serialise","3701313002084"]
["01HC2010","Serialise","3701313002701"]
["01HC2020","Serialise","3701313002695"]
["01HC2030","Serialise","3701313002688"]
["01HC2040","Serialise","3701313002794"]
["01HC2050","Serialise","3701313002220"]
["01HE2010","Serialise","3701313000400"]
["01HH2010","Serialise","3701313004958"]
["01HH2020","Serialise","3701313004941"]
["01HH2021","Serialise","3701313000301"]
["01HH2030","Serialise","3701313004934"]
["01HH2035","Serialise","3701313000417"]
["01HP2010","Serialise","3701313002817"]
["01HR2010","Serialise","3701313002213"]
["01HR2020","Serialise","3701313000295"]
["01HR2030","Serialise","3701313000288"]
["01HR2040","Serialise","3701313000271"]
["01HS2010","Serialise","3701313002206"]
["01HS2015","Serialise","3701313002862"]
["01HS2020","Serialise","3701313002800"]
["01HS2025","Serialise","3701313003067"]
["01HT2020","Serialise","3701313002190"]
["01HT2025","Serialise","3701313002855"]
["01MP1010","Serialise","3701313002329"]
["01PB1010","Serialise","3701313002312"]
["01PB1015","Serialise","3701313000424"]
["01PB1020","Serialise","3701313002305"]
["01PB1025","Serialise","3701313000431"]
["01PC2010","Serialise","3701313002671"]
["01PE2010","Serialise","3701313000448"]
["01PR2010","Serialise","3701313002183"]
["01PR2610","Serialise","3701313003180"]
["01PS3010","Serialise","3701313004927"]
["01RK0001","Serialise","3701313001933"]
["01RK0011","Serialise","3701313001926"]
["01RK0012","Serialise","3701313001919"]
["01RK0013","Serialise","3701313001902"]
["01RK0014","Serialise","3701313001896"]
["01RK0020","Serialise","3701313001889"]
["01RK0021","Serialise","3701313002619"]
["01RK0022","Serialise","3701313002602"]
["01RK0030","Serialise","3701313002749"]
["01RK0031","Serialise","3701313002732"]
["01RK0040","Serialise","3701313004996"]
["01RK0050","Serialise","3701313004897"]
["01RK0051","Serialise","3701313004880"]
["01RK0052","Serialise","3701313004873"]
["01RK0053","Serialise","3701313004866"]
["01RN5010","Serialise","3701313002756"]
["01RN5020","Serialise","3701313002008"]
["01RR3010","Serialise","3701313000264"]
["01SH1010","Serialise","3701313004972"]
["01SH1020","Serialise","3701313004965"]
["01ST1010","Serialise","3701313002725"]
["01ST1020","Serialise","3701313002718"]
["01TP1045","Serialise","3701313002299"]
["01TP1055","Serialise","3701313002282"]
["01TP1065","Serialise","3701313002275"]
["01TP1075","Serialise","3701313002268"]
["01TR2060","Par lot","3701313002176"]
["01TR2120","Par lot","3701313002169"]
["01TR2500","Par lot","3701313002152"]
["01WR3010","Serialise","3701313002060"]
["01XS3010","Serialise","3701313002053"]
["01XS3015","Serialise","3701313002046"]
["24BR55035","Par lot","3701313001872"]
["24BR55045","Par lot","3701313001865"]
["24BR55055","Par lot","3701313001858"]
["24BR55065","Par lot","3701313001841"]
["24BR55075","Par lot","3701313001834"]
["24BR55085","Par lot","3701313001827"]
["24BR55095","Par lot","3701313001810"]
["24BR55105","Par lot","3701313001803"]
["24BR55115","Par lot","3701313001797"]
["24BR60035","Par lot","3701313003548"]
["24BR60045","Par lot","3701313003531"]
["24BR60055","Par lot","3701313003524"]
["24BR60065","Par lot","3701313003517"]
["24BR60075","Par lot","3701313003500"]
["24BR60085","Par lot","3701313003494"]
["24BR60095","Par lot","3701313003487"]
["24BR60105","Par lot","3701313003470"]
["24BR60115","Par lot","3701313003463"]
["24CR55405","Par lot","3701313000103"]
["24CR55415","Par lot","3701313000073"]
["24CR55445","Par lot","3701313005023"]
["24CR55605","Par lot","3701313000110"]
["24CR55615","Par lot","3701313000080"]
["24CR55645","Par lot","3701313004057"]
["24CR55905","Par lot","3701313000127"]
["24CR55915","Par lot","3701313000097"]
["24CR55945","Par lot","3701313004033"]
["24CR60405","Par lot","3701313003456"]
["24CR60415","Par lot","3701313003449"]
["24CR60445","Par lot","3701313003999"]
["24CR60605","Par lot","3701313003432"]
["24CR60615","Par lot","3701313003425"]
["24CR60645","Par lot","3701313003975"]
["24CR60905","Par lot","3701313003418"]
["24CR60915","Par lot","3701313003401"]
["24CR60945","Par lot","3701313001308"]
["24ND2070","Serialise","3701313001490"]
["24PW45025","Par lot","3701313000745"]
["24PW45030","Par lot","3701313000752"]
["24PW45035","Par lot","3701313000769"]
["24PW45040","Par lot","3701313000776"]
["24PW45045","Par lot","3701313000783"]
["24PW45050","Par lot","3701313000790"]
["24PW45055","Par lot","3701313000806"]
["24PW45060","Par lot","3701313000813"]
["24PW55025","Par lot","3701313000837"]
["24PW55030","Par lot","3701313000844"]
["24PW55035","Par lot","3701313000851"]
["24PW55040","Par lot","3701313000868"]
["24PW55045","Par lot","3701313000875"]
["24PW55050","Par lot","3701313000882"]
["24PW55055","Par lot","3701313000899"]
["24PW55060","Par lot","3701313000905"]
["24PW55600","Par lot","3701313000004"]
["24PW55700","Par lot","3701313000011"]
["24PW56610","Par lot","3701313003562"]
["24PW56620","Par lot","3701313005160"]
["24PW56625","Par lot","3701313005153"]
["24PW56630","Par lot","3701313005146"]
["24PW56635","Par lot","3701313005139"]
["24PW60600","Par lot","3701313003234"]
["24PW65025","Par lot","3701313000929"]
["24PW65030","Par lot","3701313000936"]
["24PW65035","Par lot","3701313000943"]
["24PW65040","Par lot","3701313000950"]
["24PW65045","Par lot","3701313000967"]
["24PW65050","Par lot","3701313000974"]
["24PW65055","Par lot","3701313000981"]
["24PW65060","Par lot","3701313000998"]
["24PW65065","Par lot","3701313001001"]
["24PW65070","Par lot","3701313004170"]
["24PW65075","Par lot","3701313004163"]
["24PW65080","Par lot","3701313004156"]
["24PW65085","Par lot","3701313004149"]
["24PW65090","Par lot","3701313004132"]
["24PW65095","Par lot","3701313004125"]
["24PW65100","Par lot","3701313004118"]
["24PW65105","Par lot","3701313004101"]
["24PW65110","Par lot","3701313004095"]
["24PW75025","Par lot","3701313001018"]
["24PW75030","Par lot","3701313001025"]
["24PW75035","Par lot","3701313001032"]
["24PW75040","Par lot","3701313001049"]
["24PW75045","Par lot","3701313001056"]
["24PW75050","Par lot","3701313001063"]
["24PW75055","Par lot","3701313001070"]
["24PW75060","Par lot","3701313001087"]
["24PW75065","Par lot","3701313001094"]
["24PW75070","Par lot","3701313001100"]
["24PW75075","Par lot","3701313004088"]
["24PW75080","Par lot","3701313001117"]
["24PW75085","Par lot","3701313004071"]
["24PW75090","Par lot","3701313001124"]
["24PW75095","Par lot","3701313004064"]
["24PW75100","Par lot","3701313001131"]
["24PW75105","Par lot","3701313004040"]
["24PW75110","Par lot","3701313001148"]
["24PW85025","Par lot","3701313001162"]
["24PW85030","Par lot","3701313001179"]
["24PW85035","Par lot","3701313001186"]
["24PW85040","Par lot","3701313001193"]
["24PW85045","Par lot","3701313001209"]
["24PW85050","Par lot","3701313001216"]
["24PW85055","Par lot","3701313001223"]
["24PW85060","Par lot","3701313001230"]
["24PW85065","Par lot","3701313001247"]
["24PW85070","Par lot","3701313001254"]
["24PW85075","Par lot","3701313004026"]
["24PW85080","Par lot","3701313001261"]
["24PW85085","Par lot","3701313004019"]
["24PW85090","Par lot","3701313001278"]
["24PW85095","Par lot","3701313004002"]
["24PW85100","Par lot","3701313001285"]
["24PW85105","Par lot","3701313003982"]
["24PW85110","Par lot","3701313001292"]
["24PW95025","Par lot","3701313003968"]
["24PW95030","Par lot","3701313003951"]
["24PW95035","Par lot","3701313003944"]
["24PW95040","Par lot","3701313003937"]
["24PW95045","Par lot","3701313003920"]
["24PW95050","Par lot","3701313003913"]
["24PW95055","Par lot","3701313003906"]
["24PW95060","Par lot","3701313003890"]
["24PW95065","Par lot","3701313003883"]
["24PW95070","Par lot","3701313003876"]
["24PW95075","Par lot","3701313003869"]
["24PW95080","Par lot","3701313003852"]
["24PW95085","Par lot","3701313003845"]
["24PW95090","Par lot","3701313003838"]
["24PW95095","Par lot","3701313003821"]
["24PW95100","Par lot","3701313003814"]
["24PW95105","Par lot","3701313003807"]
["24PW95110","Par lot","3701313003791"]
["24SR55035","Par lot","3701313000189"]
["24SR55045","Par lot","3701313000196"]
["24SR55055","Par lot","3701313000219"]
["24SR55065","Par lot","3701313000226"]
["24SR55075","Par lot","3701313000233"]
["24SR55085","Par lot","3701313000240"]
["24SR55095","Par lot","3701313000257"]
["24SR55105","Par lot","3701313000134"]
["24SR55115","Par lot","3701313000141"]
["24SR55135","Par lot","3701313000158"]
["24SR55185","Par lot","3701313000165"]
["24SR55285","Par lot","3701313000172"]
["24SR55505","Par lot","3701313000202"]
["24SR60035","Par lot","3701313003395"]
["24SR60045","Par lot","3701313003388"]
["24SR60055","Par lot","3701313003371"]
["24SR60065","Par lot","3701313003364"]
["24SR60075","Par lot","3701313003357"]
["24SR60085","Par lot","3701313003340"]
["24SR60095","Par lot","3701313003333"]
["24SR60105","Par lot","3701313003326"]
["24SR60115","Par lot","3701313003319"]
["24SR60135","Par lot","3701313003302"]
["24SR60185","Par lot","3701313003296"]
["24SR60285","Par lot","3701313003289"]
["24SR60505","Par lot","3701313003272"]
["25SC55003","Par lot","3701313003081"]
["25SC55023","Par lot","3701313005122"]
["25SC60003","Par lot","3701313003173"]
["25SC60023","Par lot","3701313005115"]
["25SN55004","Par lot","3701313003074"]
["25SN55005","Par lot","3701313003050"]
["25SN55006","Par lot","3701313005092"]
["25SN55024","Par lot","3701313005108"]
["25SP55301","Par lot","3701313003104"]
["25SP55302","Par lot","3701313003098"]
["25SP55621","Par lot","3701313005085"]
["25SP55622","Par lot","3701313005078"]
["25SP55901","Par lot","3701313003128"]
["25SP55902","Par lot","3701313003111"]
["25SP55921","Par lot","3701313005061"]
["25SP55922","Par lot","3701313005054"]
["25SW65030","Par lot","3701313003043"]
["25SW65035","Par lot","3701313003036"]
["25SW65040","Par lot","3701313003029"]
["25SW65045","Par lot","3701313003012"]
["25SW65050","Par lot","3701313003005"]
["25SW65055","Par lot","3701313002992"]
["25SW65060","Par lot","3701313002985"]
["25SW65065","Par lot","3701313002978"]
["25SW65070","Par lot","3701313002961"]
["25SW65075","Par lot","3701313003784"]
["25SW65080","Par lot","3701313003777"]
["25SW65085","Par lot","3701313003760"]
["25SW65090","Par lot","3701313003753"]
["25SW65095","Par lot","3701313003746"]
["25SW65100","Par lot","3701313003739"]
["25SW65105","Par lot","3701313003722"]
["25SW65110","Par lot","3701313003715"]
["25SW75030","Par lot","3701313002954"]
["25SW75035","Par lot","3701313002947"]
["25SW75040","Par lot","3701313002930"]
["25SW75045","Par lot","3701313002923"]
["25SW75050","Par lot","3701313002916"]
["25SW75055","Par lot","3701313002909"]
["25SW75060","Par lot","3701313002893"]
["25SW75065","Par lot","3701313002886"]
["25SW75070","Par lot","3701313002879"]
["25SW75075","Par lot","3701313003708"]
["25SW75080","Par lot","3701313003692"]
["25SW75085","Par lot","3701313003685"]
["25SW75090","Par lot","3701313003678"]
["25SW75095","Par lot","3701313003661"]
["25SW75100","Par lot","3701313003654"]
["25SW75105","Par lot","3701313003647"]
["25SW75110","Par lot","3701313003630"]
["26PH00001","Par lot","3701313004811"]
["26PH45100","Par lot","3701313004859"]
["26PH45130","Par lot","3701313004842"]
["26PH67100","Par lot","3701313004835"]
["26PH67130","Par lot","3701313004828"]
["26SL00050","Par lot","3701313004699"]
["26SL00075","Par lot","3701313004682"]
["26SL00100","Par lot","3701313004675"]
["26SP45100","Par lot","3701313004736"]
["26SP45130","Par lot","3701313004729"]
["26SP67100","Par lot","3701313004712"]
["26SP67130","Par lot","3701313004705"]
["26TC00001","Par lot","3701313004743"]
["26TC10050","Par lot","3701313004804"]
["26TC10075","Par lot","3701313004798"]
["26TC10100","Par lot","3701313004781"]
["26TC20050","Par lot","3701313004774"]
["26TC20075","Par lot","3701313004767"]
["26TC20100","Par lot","3701313004750"]
["27AC51000","Par lot","3701313002596"]
["27PC52075","Par lot","3701313002589"]
["27PC52095","Par lot","3701313002572"]
["27PC52110","Par lot","3701313002565"]
["27PC52130","Par lot","3701313002558"]
["27PC52150","Par lot","3701313002541"]
["27PC52170","Par lot","3701313002534"]
["27PC53075","Par lot","3701313002527"]
["27PC53095","Par lot","3701313002510"]
["27PC53110","Par lot","3701313002503"]
["27PC53130","Par lot","3701313002497"]
["27PC53150","Par lot","3701313002480"]
["27PC53170","Par lot","3701313002473"]
["27PC54075","Par lot","3701313002466"]
["27PC54095","Par lot","3701313002459"]
["27PC54110","Par lot","3701313002442"]
["27PC54130","Par lot","3701313002435"]
["27PC54150","Par lot","3701313002428"]
["27PC54170","Par lot","3701313002411"]
["27PC55001","Par lot","3701313002367"]
["27PC55110","Par lot","3701313002404"]
["27PC55130","Par lot","3701313002398"]
["27PC55150","Par lot","3701313002381"]
["27PC55170","Par lot","3701313002374"]
["28IE56020","Par lot","3701313004668"]
["28IE56025","Par lot","3701313004651"]
["28IE56030","Par lot","3701313004644"]
["28IS00001","Par lot","3701313004637"]
["28IW15055","Par lot","3701313004262"]
["28IW15060","Par lot","3701313004255"]
["28IW15065","Par lot","3701313004248"]
["28IW15070","Par lot","3701313004231"]
["28IW15075","Par lot","3701313004224"]
["28IW15080","Par lot","3701313004217"]
["28IW15090","Par lot","3701313004200"]
["28IW15100","Par lot","3701313004194"]
["28IW15110","Par lot","3701313004187"]
["28IW65055","Par lot","3701313004620"]
["28IW65060","Par lot","3701313004613"]
["28IW65065","Par lot","3701313004606"]
["28IW65070","Par lot","3701313004590"]
["28IW65075","Par lot","3701313004583"]
["28IW65080","Par lot","3701313004576"]
["28IW65090","Par lot","3701313004569"]
["28IW65100","Par lot","3701313004552"]
["28IW65110","Par lot","3701313004545"]
["28IW75055","Par lot","3701313004538"]
["28IW75060","Par lot","3701313004521"]
["28IW75065","Par lot","3701313004514"]
["28IW75070","Par lot","3701313004507"]
["28IW75075","Par lot","3701313004491"]
["28IW75080","Par lot","3701313004484"]
["28IW75090","Par lot","3701313004477"]
["28IW75100","Par lot","3701313004460"]
["28IW75110","Par lot","3701313004453"]
["28IW85055","Par lot","3701313004446"]
["28IW85060","Par lot","3701313004439"]
["28IW85065","Par lot","3701313004422"]
["28IW85070","Par lot","3701313004415"]
["28IW85075","Par lot","3701313004408"]
["28IW85080","Par lot","3701313004392"]
["28IW85090","Par lot","3701313004385"]
["28IW85100","Par lot","3701313004378"]
["28IW85110","Par lot","3701313004361"]
["28IW95055","Par lot","3701313004354"]
["28IW95060","Par lot","3701313004347"]
["28IW95065","Par lot","3701313004330"]
["28IW95070","Par lot","3701313004323"]
["28IW95075","Par lot","3701313004316"]
["28IW95080","Par lot","3701313004309"]
["28IW95090","Par lot","3701313004293"]
["28IW95100","Par lot","3701313004286"]
["28IW95110","Par lot","3701313004279"]
["29TC55001","Par lot","3701313003623"]
["29TC55002","Par lot","3701313003616"]
["29TC55101","Par lot","3701313005283"]
["29TC55102","Par lot","3701313005276"]
["29TC55201","Par lot","3701313005269"]
["29TC55202","Par lot","3701313005252"]
["29TC55301","Par lot","3701313005245"]
["29TC55302","Par lot","3701313005238"]
["29TC60001","Par lot","3701313003609"]
["29TC60002","Par lot","3701313003593"]
["29TC60101","Par lot","3701313005221"]
["29TC60102","Par lot","3701313005214"]
["29TC60201","Par lot","3701313005207"]
["29TC60202","Par lot","3701313005191"]
["29TC60301","Par lot","3701313005184"]
["29TC60302","Par lot","3701313005177"]
["30KR55000","Serialise","3701313005047"]
["30KR60000","Serialise","3701313005030"]

{"sheet":"Paramètres","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[1,6,1,8]]}
["Paramètres"]
["C2 = REF",null,null,null,null,"Enter SMAIO medical device reference \n(8 or 9 digits)",{"$f":"'UDI builder'!$C$2","v":0}]
["C6 si C2 n'existe pas dans la BD GTIN","not SMAIO reference"]
["B4 si C2 existe dans la BD GTIN  et qu'elle est gérée par SN \"Sérialisé\"","Enter Serial Number under XXXXXX-XXX format"]
["B4 si C2 existe dans la BD GTIN  et qu'elle est  gérée par BATCH \"Par lot\"","Enter batch number (6 digits)"]
["B6 si C2 existe et contient 8 digits","Instrument UDI"]
["B6 si C2 existe et contient 9 digits","Implant UDI"]
[]
[]
["Formules"]
["not SMAIO reference",{"$f":"IF(COUNTIF('BD GTIN'!$A:$C,'UDI builder'!$C$2)=0,\"Not SMAIO reference\",\"REF SMAIO\")","v":"Not SMAIO reference"}]
["UDI (01)0GTIN(21)SN",{"$f":"IF(OR($G$2=\"\",$C$5=\"\",$E$5=\"\",$B$5=Paramètres!$B$5),\"\",CONCATENATE(\"(01)0\",(VLOOKUP($G$2,'BD GTIN'!$A:$C,3,FALSE)),\"(21)\",$C$5,\"-\",IF($E$5>99,$E$5,IF($E$5>9,CONCATENATE(\"0\",$E$5),CONCATENATE(\"00\",$E$5)))))","v":""}]
["UDI (01)0GTIN(10)BATCH",{"$f":"IF(OR($G$2=\"\",$C$5=\"\",$B$5=Paramètres!$B$4),\"\",CONCATENATE(\"(01)0\",(VLOOKUP($G$2,'BD GTIN'!$A:$C,3,FALSE)),\"(10)\",$C$5))","v":""}]
["UDI",{"$f":"IF($G$2=\"\",\"\",IF(COUNTIF('BD GTIN'!$A:$C,'UDI builder'!$C$2)=0,Paramètres!$B$3,IF($B$5=Paramètres!$B$4,IF(OR($G$2=\"\",$C$5=\"\",$E$5=\"\"),\"\",CONCATENATE(\"(01)0\",(VLOOKUP($G$2,'BD GTIN'!$A:$C,3,FALSE)),\"(21)\",$C$5,\"-\",IF($E$5>99,$E$5,IF($E$5>9,CONCATENATE(\"0\",$E$5),CONCATENATE(\"00\",$E$5))))),IF(OR('UDI builder'!$C$2:$E$2=\"\",'UDI builder'!$C$4=\"\"),\"\",CONCATENATE(\"01\",VLOOKUP($G$2,'BD GTIN'!$A:$C,3,FALSE),\"(20)\",'UDI builder'!$C$4)))))","v":"not SMAIO reference"}]

{"sheet":"Page de garde","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[[13,0,13,5],[14,1,14,2],[14,3,14,4],[15,1,15,2],[15,3,15,4],[0,0,0,5],[5,0,5,5],[11,1,11,2],[11,3,11,4],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[9,0,9,5],[10,1,10,2],[10,3,10,4]]}
[]
[]
["Author","Rev","Date","Origin","Section","Nature of the modification "]
["S. ESCOFFIER","V01","2024-07-26","PCC_2024_021","All","Creation"]
[]
["Writer"]
["Date","Name",null,"Position",null,"Signature"]
["2024-08-06","S. ESCOFFIER",null,"Regulatory Affairs Officer",null,{"$error":"#VALUE!"}]
[]
["Validated by"]
["Date","Name",null,"Position",null,"Signature"]
["2024-09-12","K. BUI",null,"Industrialization director"]
[]
["Approver"]
["Date","Name",null,"Position",null,"Signature"]
["2024-09-12","JC. ROUSSOULY",null,"Director general deputy"]