{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Etiquettes (à remplir)","Matières (à consulter)","Ressources (ne pas modifier)"],"not_rendered":{"images":14},"read":"whole","date_system":"1900"}

{"sheet":"Etiquettes (à remplir)","index":0,"n_rows":40,"n_cols":28,"rows_kept":40,"merged":[[0,2,1,3],[1,9,1,11],[1,21,1,23],[2,6,5,6],[2,7,5,13],[2,18,5,18],[2,19,5,25],[9,9,9,11],[9,21,9,23],[10,6,13,6],[10,7,13,13],[10,18,13,18],[10,19,13,25],[17,9,17,11],[17,21,17,23],[18,5,29,5],[18,6,19,6],[18,7,29,13],[18,17,21,17],[18,19,21,25],[19,18,20,18],[20,6,27,6],[23,0,25,3],[25,19,25,20],[25,21,25,23],[26,0,31,3],[26,18,29,18],[26,19,29,25],[28,6,29,6],[33,9,33,11],[33,12,33,13],[33,21,33,23],[33,24,33,25],[34,6,37,6],[34,7,35,11],[34,12,35,13],[34,18,37,18],[34,19,35,23],[34,24,35,25],[36,7,37,11],[36,12,37,13],[36,19,37,23],[36,24,37,25]]}
[null,null,"Gabarit de commande d'étiquettes"]
[{"$nulls":9},"FIXATION : Aucune",{"$nulls":5},{"$f":"IF($B$14=\"Aucune\",$B$13,\"\")","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF($B$14=\"2 trous (H)\",$B$15,\"\")","v":""},null,"FIXATION : 2 trous (H)",{"$nulls":5},{"$f":"IF($B$14=\"2 trous (H)\",$B$13,\"\")","v":""}]
[{"$nulls":3},"v1.3 - 10.10.2024",null,null,{"$f":"IF($B$14=\"Aucune\",$B$12,\"\")","v":{"v":25,"d":"25.0"}},{"$f":"IF($B$14=\"Aucune\",\"EXEMPLE\",\"\")","v":"EXEMPLE"},{"$nulls":10},{"$f":"IF($B$14=\"2 trous (H)\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"2 trous (H)\",\"EXEMPLE\",\"\")","v":""}]
["Eumeka Sàrl"]
["Rte de Lausanne 7",{"$nulls":14},{"$f":"IF($B$14=\"Aucune\",\"Ep.\",\"\")","v":"Ep."},{"$nulls":11},{"$f":"IF($B$14=\"2 trous (H)\",\"Ep.\",\"\")","v":""}]
["1053 Cugy VD","info@eumeka.ch",{"$nulls":13},{"$f":"IF($B$14=\"Aucune\",$D$9,\"\")","v":1.6},{"$nulls":11},{"$f":"IF($B$14=\"2 trous (H)\",$D$9,\"\")","v":""}]
["Suisse","www.eumeka.ch/laser",{"$nulls":17},{"$f":"IF($B$14=\"2 trous (H)\",($B$11-$B$16)/2,\"\")","v":""},null,null,{"$f":"IF($B$14=\"2 trous (H)\",$B$16,\"\")","v":""},null,null,{"$f":"IF($B$14=\"2 trous (H)\",($B$11-$B$16)/2,\"\")","v":""}]
[{"$nulls":10},{"$f":"IF($B$14=\"Aucune\",$B$11,\"\")","v":{"v":50,"d":"50.0"}},{"$nulls":11},{"$f":"IF($B$14=\"2 trous (H)\",$B$11,\"\")","v":""}]
["Réf. Matière","L512-206","Epaisseur",{"$f":"VLOOKUP($B$9,'Ressources (ne pas modifier)'!$A$2:$E$84,2,FALSE)","v":{"v":1.6,"d":"1.6 mm"}}]
["Adhésif","Sans","Couleur fond",{"$f":"VLOOKUP($B$9,'Ressources (ne pas modifier)'!$A$2:$E$84,3,FALSE)","v":"Bleu"},{"$nulls":3},{"$f":"IF($B$14=\"1 trou (G)\",$B$15,\"\")","v":""},null,"FIXATION : 1 trou (G)",{"$nulls":5},{"$f":"IF($B$14=\"1 trou (G)\",$B$13,\"\")","v":""},{"$nulls":5},"FIXATION : 1 trou (D)",{"$nulls":3},{"$f":"IF($B$14=\"1 trou (D)\",$B$15,\"\")","v":""},null,{"$f":"IF($B$14=\"1 trou (D)\",$B$13,\"\")","v":""}]
["Largeur [mm]",{"v":50,"d":"50.0"},"Couleur texte",{"$f":"VLOOKUP($B$9,'Ressources (ne pas modifier)'!$A$2:$E$84,4,FALSE)","v":"Blanc"},null,null,{"$f":"IF($B$14=\"1 trou (G)\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"1 trou (G)\",\"EXEMPLE\",\"\")","v":""},{"$nulls":10},{"$f":"IF($B$14=\"1 trou (D)\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"1 trou (D)\",\"EXEMPLE\",\"\")","v":""}]
["Hauteur [mm]",{"v":25,"d":"25.0"},"Stock",{"$f":"VLOOKUP($B$9,'Ressources (ne pas modifier)'!$A$2:$E$84,5,FALSE)","v":"Normal"}]
["Rayon de coins [mm]",{"v":0,"d":"0.0"},{"$nulls":13},{"$f":"IF($B$14=\"1 trou (G)\",\"Ep.\",\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"1 trou (D)\",\"Ep.\",\"\")","v":""}]
["Fixation","Aucune",{"$nulls":13},{"$f":"IF($B$14=\"1 trou (G)\",$D$9,\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"1 trou (D)\",$D$9,\"\")","v":""}]
["Ø trous / largeur encoches [mm]",3.5,{"$nulls":5},{"$f":"IF($B$14=\"1 trou (G)\",($B$11-$B$16)/2,\"\")","v":""},null,null,{"$f":"IF($B$14=\"1 trou (G)\",$B$16,\"\")","v":""},null,null,{"$f":"IF($B$14=\"1 trou (G)\",($B$11-$B$16)/2,\"\")","v":""},{"$nulls":5},{"$f":"IF($B$14=\"1 trou (D)\",($B$11-$B$16)/2,\"\")","v":""},null,null,{"$f":"IF($B$14=\"1 trou (D)\",$B$16,\"\")","v":""},null,null,{"$f":"IF($B$14=\"1 trou (D)\",($B$11-$B$16)/2,\"\")","v":""}]
["Entraxe des trous / encoches [mm]",{"v":40,"d":"40.0"},{"$nulls":8},{"$f":"IF($B$14=\"1 trou (G)\",$B$11,\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"1 trou (D)\",$B$11,\"\")","v":""}]
["Hauteur texte (1ère ligne) [mm]",{"v":5,"d":"5.0"}]
["Hauteur texte (autres lignes) [mm]",{"v":5,"d":"5.0"},{"$nulls":5},{"$f":"IF($B$14=\"4 trous\",$B$15,\"\")","v":""},null,"FIXATION : 4 trous",{"$nulls":5},{"$f":"IF($B$14=\"4 trous\",$B$13,\"\")","v":""},{"$nulls":3},{"$f":"IF($B$14=\"2 trous (V)\",$B$15,\"\")","v":""},null,"FIXATION : 2 trous (V)",{"$nulls":5},{"$f":"IF($B$14=\"2 trous (V)\",$B$13,\"\")","v":""}]
["Espace entre les lignes [mm]",2.5,{"$nulls":3},{"$f":"IF($B$14=\"4 trous\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"4 trous\",($B$11-$B$16)/2,\"\")","v":""},{"$f":"IF($B$14=\"4 trous\",\"EXEMPLE\",\"\")","v":""},{"$nulls":9},{"$f":"IF($B$14=\"2 trous (V)\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"2 trous (V)\",($B$12-$B$16)/2,\"\")","v":""},{"$f":"IF($B$14=\"2 trous (V)\",\"EXEMPLE\",\"\")","v":""}]
["Police","Arial Narrow",{"$nulls":16},{"$f":"IF($B$14=\"2 trous (V)\",$B$16,\"\")","v":""}]
["No d'affaire / Référence",{"$nulls":5},{"$f":"IF($B$14=\"4 trous\",$B$12-($B$11-$B$16),\"\")","v":""},{"$nulls":20},{"$f":"IF($B$14=\"2 trous (V)\",\"Ep.\",\"\")","v":""}]
["Délai souhaité",{"$nulls":17},{"$f":"IF($B$14=\"2 trous (V)\",($B$12-$B$16)/2,\"\")","v":""},{"$nulls":8},{"$f":"IF($B$14=\"2 trous (V)\",$D$9,\"\")","v":""}]
[]
["Utilisation",{"$nulls":21},{"$f":"IF($B$14=\"2 trous (V)\",$B$11,\"\")","v":""}]
[]
[{"$nulls":19},{"$f":"IF($B$14=\"Encoches\",$B$15,\"\")","v":""},null,"FIXATION : Encoches",{"$nulls":5},{"$f":"IF($B$14=\"Encoches\",$B$13,\"\")","v":""}]
["Remplir les informations dans les cases vertes ci-dessus, puis remplir une étiquette par ligne du tableau ci-dessous. Inscrire chaque ligne de l'étiquette dans une colonne séparée. Une étiquette qui doit être produite plusieurs fois doit simplement être dupliquée sur une autre ligne du tableau. Il est possible de laisser des lignes du tableau vides pour séparer des groupes d'étiquettes pour une meilleure lisibilité.",{"$nulls":17},{"$f":"IF($B$14=\"Encoches\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"Encoches\",\"EXEMPLE\",\"\")","v":""}]
[]
[{"$nulls":6},{"$f":"IF($B$14=\"4 trous\",($B$11-$B$16)/2,\"\")","v":""},{"$nulls":8},{"$f":"IF($B$14=\"4 trous\",\"Ep.\",\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"Encoches\",\"Ep.\",\"\")","v":""}]
[{"$nulls":15},{"$f":"IF($B$14=\"4 trous\",$D$9,\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"Encoches\",$D$9,\"\")","v":""}]
[{"$nulls":7},{"$f":"IF($B$14=\"4 trous\",($B$11-$B$16)/2,\"\")","v":""},null,null,{"$f":"IF($B$14=\"4 trous\",$B$16,\"\")","v":""},null,null,{"$f":"IF($B$14=\"4 trous\",($B$11-$B$16)/2,\"\")","v":""},{"$nulls":5},{"$f":"IF($B$14=\"Encoches\",($B$11-$B$16)/2,\"\")","v":""},null,null,{"$f":"IF($B$14=\"Encoches\",$B$16,\"\")","v":""},null,null,{"$f":"IF($B$14=\"Encoches\",($B$11-$B$16)/2,\"\")","v":""}]
[{"$nulls":10},{"$f":"IF($B$14=\"4 trous\",$B$11,\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"Encoches\",$B$11,\"\")","v":""}]
["Ligne 1","Ligne 2","Ligne 3","Ligne 4"]
[{"$nulls":7},{"$f":"IF($B$14=\"Military 1\",$B$15,\"\")","v":""},null,"FIXATION : Military 1",null,null,{"$f":"IF($B$14=\"Military 1\",$B$11/4,\"\")","v":""},null,null,{"$f":"IF($B$14=\"Military 1\",$B$13,\"\")","v":""},{"$nulls":3},{"$f":"IF($B$14=\"Military 2\",$B$15,\"\")","v":""},null,"FIXATION : Military 2",null,null,{"$f":"IF($B$14=\"Military 2\",$B$11/4,\"\")","v":""},null,null,{"$f":"IF($B$14=\"Military 2\",$B$13,\"\")","v":""}]
[{"$nulls":6},{"$f":"IF($B$14=\"Military 1\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"Military 1\",\"Ligne 1\",\"\")","v":""},{"$nulls":4},{"$f":"IF($B$14=\"Military 1\",\"Ligne 2\",\"\")","v":""},{"$nulls":5},{"$f":"IF($B$14=\"Military 2\",$B$12,\"\")","v":""},{"$f":"IF($B$14=\"Military 2\",\"Ligne 1\",\"\")","v":""},{"$nulls":4},{"$f":"IF($B$14=\"Military 2\",\"Ligne 2\",\"\")","v":""}]
[]
[{"$nulls":7},{"$f":"IF($B$14=\"Military 1\",\"Ligne 3\",\"\")","v":""},{"$nulls":4},{"$f":"IF($B$14=\"Military 1\",\"Ligne 4\",\"\")","v":""},null,null,{"$f":"IF($B$14=\"Military 1\",\"Ep.\",\"\")","v":""},{"$nulls":3},{"$f":"IF($B$14=\"Military 2\",\"Ligne 3\",\"\")","v":""},{"$nulls":4},{"$f":"IF($B$14=\"Military 2\",\"Ligne 4\",\"\")","v":""},null,null,{"$f":"IF($B$14=\"Military 2\",\"Ep.\",\"\")","v":""}]
[{"$nulls":15},{"$f":"IF($B$14=\"Military 1\",$D$9,\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"Military 2\",$D$9,\"\")","v":""}]
[{"$nulls":7},{"$f":"IF($B$14=\"1 trou (G)\",($B$11-$B$16)/2,\"\")","v":""},null,null,{"$f":"IF($B$14=\"Military 1\",$B$16,\"\")","v":""},null,null,{"$f":"IF($B$14=\"1 trou (G)\",($B$11-$B$16)/2,\"\")","v":""},{"$nulls":5},{"$f":"IF($B$14=\"1 trou (G)\",($B$11-$B$16)/2,\"\")","v":""},null,null,{"$f":"IF($B$14=\"Military 2\",$B$16,\"\")","v":""},null,null,{"$f":"IF($B$14=\"1 trou (G)\",($B$11-$B$16)/2,\"\")","v":""}]
[{"$nulls":10},{"$f":"IF($B$14=\"Military 1\",$B$11,\"\")","v":""},{"$nulls":11},{"$f":"IF($B$14=\"Military 2\",$B$11,\"\")","v":""}]

{"sheet":"Matières (à consulter)","index":1,"n_rows":47,"n_cols":4,"rows_kept":47,"merged":[[0,1,0,3],[32,1,32,3],[40,1,40,3]]}
[null,"Trolase"]
["Epaisseur","0.8mm","1.6mm","3.2mm"]
["Noir/Blanc","L402-203","L402-206","L402-209"]
["Orange/Blanc","L612-203","L612-206"]
["Rouge/Blanc","L602-203","L602-206","L602-209"]
["Bordeaux/Blanc",null,"L622-206"]
["Rose/Blanc",null,"L662-206"]
["Violet/Blanc",null,"L582-206"]
["Bleu clair/Blanc","L562-203","L562-206"]
["Saphir/Blanc","L502-203","L502-206"]
["Bleu/Blanc","L512-203","L512-206","L512-209"]
["Bleu océan/Blanc",null,"L552-206"]
["Vert/Blanc","L932-203","L932-206","L932-209"]
["Vert foncé/Blanc","L912-203","L912-206","L912-209"]
["Gris/Blanc","L312-203","L312-206"]
["Marron foncé/Blanc","L842-203","L842-206"]
["Noir Brillant/Blanc",null,"L422-206"]
["Jaune/Noir","L704-203","L704-206","L704-209"]
["Orange/Noir","L614-203","L614-206"]
["Rouge/Noir",null,"L604-206"]
["Rose/Noir",null,"L664-206"]
["Beige/Noir",null,"L854-206"]
["Blanc/Noir","L204-203","L204-206","L204-209"]
["Blanc/Bleu","L205-203","L205-206"]
["Blanc/Rouge","L206-203","L206-206","L206-209"]
["Noir/Rouge",null,"L406-206"]
["Jaune/Rouge","L706-203","L706-206"]
["Noir/Gris",null,"L413-206"]
["Noir/Or",null,"L417-206"]
["Noir Brillant/Or",null,"L427-206"]
["Azur/Jaune",null,"L517-206"]
[]
[null,"Trolase Metallic"]
[null,"0.8mm","1.6mm","3.2mm"]
["Argent brossé/Noir","LMT334-203","LMT334-206","LMT334-209"]
["Argent/Noir","LMT344-203","LMT344-206","LMT344-209"]
["Alu brossé/Noir","LMT354-203","LMT354-206","LMT354-209"]
["Or satiné/Noir","LMT714-203","LMT714-206","LMT714-209"]
["Or Brossé/Noir","LMT734-203","LMT734-206","LMT734-209"]
[]
[null,"Trolase Metallic plus"]
[null,"0.8mm","1.6mm","3.2mm"]
["Acier brossé/Noir","LMT+314-203","LMT+314-206","LMT+314-209"]
["Acier brossé/Bleu","LMT+315-203","LMT+315-206","LMT+315-209"]
["Acier brossé/Rouge","LMT+316-203","LMT+316-206","LMT+316-209"]
["Or antique brossé/Noir","LMT+764-203","LMT+764-206","LMT+764-209"]
["Cuivre brossé/Noir","LMT+864-203","LMT+864-206","LMT+864-209"]

{"sheet":"Ressources (ne pas modifier)","index":2,"n_rows":84,"n_cols":8,"rows_kept":84}
["Réf. Matière","Epaisseur","Couleur fond","Couleur texte","Stock","Adhésif","Fixation","Police"]
["L204-203",0.8,"Blanc","Noir","Normal","Avec","Aucune","Arial Narrow"]
["L204-206",1.6,"Blanc","Noir","Normal","Sans","2 trous (H)","Arial"]
["L204-209",3.2,"Blanc","Noir","Sur demande",null,"1 trou (G)","Agency FB"]
["L205-203",0.8,"Blanc","Bleu","Sur demande",null,"1 trou (D)","Calibri"]
["L205-206",1.6,"Blanc","Bleu","Sur demande",null,"4 trous","Helvetica"]
["L206-203",0.8,"Blanc","Rouge","Normal",null,"2 trous (V)","Verdana"]
["L206-206",1.6,"Blanc","Rouge","Normal",null,"Encoches"]
["L206-209",3.2,"Blanc","Rouge","Sur demande",null,"Military 1"]
["L312-203",0.8,"Gris","Blanc","Normal",null,"Military 2"]
["L312-206",1.6,"Gris","Blanc","Normal"]
["L402-203",0.8,"Noir","Blanc","Normal"]
["L402-206",1.6,"Noir","Blanc","Normal"]
["L402-209",3.2,"Noir","Blanc","Sur demande"]
["L406-206",1.6,"Noir","Rouge","Sur demande"]
["L413-206",1.6,"Noir","Gris","Sur demande"]
["L417-206",1.6,"Noir","Or","Sur demande"]
["L422-206",1.6,"Noir brillant","Blanc","Sur demande"]
["L427-206",1.6,"Noir brillant","Or","Sur demande"]
["L502-203",0.8,"Saphir","Blanc","Sur demande"]
["L502-206",1.6,"Saphir","Blanc","Sur demande"]
["L512-203",0.8,"Bleu","Blanc","Normal"]
["L512-206",1.6,"Bleu","Blanc","Normal"]
["L512-209",3.2,"Bleu","Blanc","Sur demande"]
["L517-206",1.6,"Azur","Jaune","Sur demande"]
["L552-206",1.6,"Bleu océan","Blanc","Sur demande"]
["L562-203",0.8,"Bleu clair","Blanc","Normal"]
["L562-206",1.6,"Bleu clair","Blanc","Normal"]
["L582-206",1.6,"Violet","Blanc","Normal"]
["L602-203",0.8,"Rouge","Blanc","Normal"]
["L602-206",1.6,"Rouge","Blanc","Normal"]
["L602-209",3.2,"Rouge","Blanc","Sur demande"]
["L604-206",1.6,"Rouge","Noir","Sur demande"]
["L612-203",0.8,"Orange","Blanc","Normal"]
["L612-206",1.6,"Orange","Blanc","Normal"]
["L614-203",0.8,"Orange","Noir","Normal"]
["L614-206",1.6,"Orange","Noir","Normal"]
["L622-206",1.6,"Bordeaux","Blanc","Sur demande"]
["L662-206",1.6,"Rose","Blanc","Sur demande"]
["L664-206",1.6,"Rose","Noir","Sur demande"]
["L704-203",0.8,"Jaune","Noir","Normal"]
["L704-206",1.6,"Jaune","Noir","Normal"]
["L704-209",3.2,"Jaune","Noir","Sur demande"]
["L706-203",0.8,"Jaune","Rouge","Sur demande"]
["L706-206",1.6,"Jaune","Rouge","Sur demande"]
["L842-203",0.8,"Marron foncé","Blanc","Sur demande"]
["L842-206",1.6,"Marron foncé","Blanc","Sur demande"]
["L854-206",1.6,"Beige","Noir","Sur demande"]
["L912-203",0.8,"Vert foncé","Blanc","Sur demande"]
["L912-206",1.6,"Vert foncé","Blanc","Sur demande"]
["L912-209",3.2,"Vert foncé","Blanc","Sur demande"]
["L932-203",0.8,"Vert","Blanc","Normal"]
["L932-206",1.6,"Vert","Blanc","Normal"]
["L932-209",3.2,"Vert","Blanc","Sur demande"]
["LMT+314-203",0.8,"Acier brossé","Noir","Sur demande"]
["LMT+314-206",1.6,"Acier brossé","Noir","Sur demande"]
["LMT+314-209",3.2,"Acier brossé","Noir","Sur demande"]
["LMT+315-203",0.8,"Acier brossé","Bleu","Sur demande"]
["LMT+315-206",1.6,"Acier brossé","Bleu","Sur demande"]
["LMT+315-209",3.2,"Acier brossé","Bleu","Sur demande"]
["LMT+316-203",0.8,"Acier brossé","Rouge","Sur demande"]
["LMT+316-206",1.6,"Acier brossé","Rouge","Sur demande"]
["LMT+316-209",3.2,"Acier brossé","Rouge","Sur demande"]
["LMT+764-203",0.8,"Or antique brossé","Noir","Sur demande"]
["LMT+764-206",1.6,"Or antique brossé","Noir","Sur demande"]
["LMT+764-209",3.2,"Or antique brossé","Noir","Sur demande"]
["LMT+864-203",0.8,"Cuivre brossé","Noir","Sur demande"]
["LMT+864-206",1.6,"Cuivre brossé","Noir","Sur demande"]
["LMT+864-209",3.2,"Cuivre brossé","Noir","Sur demande"]
["LMT334-203",0.8,"Argent brossé","Noir","Normal"]
["LMT334-206",1.6,"Argent brossé","Noir","Sur demande"]
["LMT334-209",3.2,"Argent brossé","Noir","Sur demande"]
["LMT344-203",0.8,"Argent","Noir","Normal"]
["LMT344-206",1.6,"Argent","Noir","Sur demande"]
["LMT344-209",3.2,"Argent","Noir","Sur demande"]
["LMT354-203",0.8,"Alu brossé","Noir","Sur demande"]
["LMT354-206",1.6,"Alu brossé","Noir","Sur demande"]
["LMT354-209",3.2,"Alu brossé","Noir","Sur demande"]
["LMT714-203",0.8,"Or satiné","Noir","Normal"]
["LMT714-206",1.6,"Or satiné","Noir","Sur demande"]
["LMT714-209",3.2,"Or satiné","Noir","Sur demande"]
["LMT734-203",0.8,"Or brossé","Noir","Sur demande"]
["LMT734-206",1.6,"Or brossé","Noir","Sur demande"]
["LMT734-209",3.2,"Or brossé","Noir","Sur demande"]