{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["BON DE COMMANDE REPRO","Liste de Prix","3.0","4.0","5.0","6.0"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"BON DE COMMANDE REPRO","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[25,0,25,3],[19,0,19,1],[45,0,45,2],[45,3,45,9],[44,1,44,2],[44,5,44,6],[39,0,39,2],[37,5,37,6],[33,0,33,1],[41,1,41,2],[42,1,42,2],[44,3,44,4],[31,1,31,2],[32,3,32,9],[39,3,39,9],[36,0,36,1],[0,0,0,9],[3,0,3,2],[3,3,3,4],[3,5,3,6],[4,5,4,6],[1,0,1,2],[2,1,2,9],[1,6,1,7],[10,0,10,1],[10,8,10,9],[8,0,8,2],[4,1,4,2],[5,1,5,2],[9,5,9,7],[9,8,9,9],[9,3,9,4],[5,5,5,6],[10,5,10,6],[6,0,6,2],[6,3,6,9],[7,3,7,9],[7,0,7,2],[8,3,8,9],[9,0,9,2],[16,3,16,9],[24,3,24,4],[15,1,15,2],[15,6,15,7],[20,0,20,1],[21,0,21,1],[16,0,16,2],[17,0,17,1],[24,1,24,2],[24,5,24,6],[23,0,23,1],[22,0,22,1],[11,0,11,2],[11,3,11,9],[13,0,13,9],[30,5,30,6],[18,0,18,1],[12,0,12,9],[29,1,29,2],[25,4,25,9],[26,1,26,2],[26,5,26,6],[27,5,27,6],[28,5,28,6],[28,1,28,2],[14,0,14,2],[14,3,14,9],[27,1,27,2],[29,5,29,6],[30,1,30,2],[32,0,32,2],[31,3,31,4],[40,5,40,6],[31,5,31,6],[38,3,38,4],[33,5,33,6],[38,5,38,6],[34,5,34,6],[35,5,35,6],[38,1,38,2],[34,0,34,1],[40,1,40,2],[37,0,37,1],[36,5,36,6],[48,0,48,6],[50,1,50,2],[50,4,50,6],[47,0,47,6],[35,0,35,1],[46,3,46,9],[43,1,43,2],[43,5,43,6],[46,0,46,2],[50,8,51,9],[51,0,51,7],[49,3,49,9],[49,0,49,2],[41,5,41,6],[42,5,42,6]]}
["UNIL - Université de Lausanne - La Repro (Ci) - BON DE COMMANDE (v0522) - 1/2"]
["0.0 / A remplir par La Repro",null,null,"Traitée par","JB","No OTRS",null,null,"No facture"]
["1.0 / Client","Les champs ci-dessous sont obligatoires si le mode de paiement est 2.2 ou 2.3. Si le paiement est cash (2.1) : Nom, prénom + No de téléphone suffisent."]
["Vous",null,null,"Réf. Prof.",null,"Faculté",null,null,"Tél."]
["Nom",null,null,"Nom",null,"Institut",null,null,"Mobile"]
["Prénom",null,null,"Prénom",null,"Autres",null,null,"E-mail"]
["2.0 / Mode de paiement",null,null,"Une seule méthode de paiement est possible, cochez ce qui convient."]
["       2.1 - Cash / CampusCard",null,null,"Aucune carte de débit et de crédit n’est prise en charge."]
["       2.2 - Imputation interne",null,null,"Merci de remplir en bonne et due forme les trois premiers champs (obligatoires) ci-dessous:"]
["*Centre de coûts SAP (commence par 26)",null,null,"*Compte (commence par 3)",null,"*Fonds SAP (commence par 26)",null,null,"Ordre interne"]
[null,null,null,"automatique"]
["       2.3 - Facturation",null,null,"Pour les clients externes, merci d'insérer l'adresse de facturation complète."]
[]
["Le soussigné a pris connaissance des conditions de cette commande et s’engage dans le cas d’un financement hors UNIL à s’acquitter des montants dans les 30 jours dès réception des factures."]
["3.0 / Type de commande > à remplir",null,null,"Résumez votre commande ici s'il vous plaît."]
["Ma commande:","▼",null,"Impression:","▼","Quantité:",null,null,"Date / Délai:"]
["4.0 / Impressions numériques",null,null,"Ce tableau concerne l'impression. Si vous avez besoin de Finitions et de Reliures > Remplir le point 5.0. A* = Agrafage sur le coin"]
["Désignation",null,"BAT*","Format","Nb de pages","Recto, R-Verso?","*A","Quantité","Total feuilles","Prix"]
[null,null,"▼","▼",null,"▼","▼",null,{"$f":"IF(F19=\"Recto-Verso\",ROUNDUP(E19/2,0)*H19,IF(F19=\"Recto\",E19*H19,0))","v":0},{"$f":"MROUND(IF('4.0'!N2='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I19,IF('4.0'!N2='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I19,IF(AND(D19='4.0'!$S$11,'BON DE COMMANDE REPRO'!I19>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I19*'4.0'!$I$11,IF(AND(D19='4.0'!$S$12,'BON DE COMMANDE REPRO'!I19>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I19*'4.0'!$I$12,IF(AND(D19='4.0'!$S$13,'BON DE COMMANDE REPRO'!I19>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I19*'4.0'!$I$13,IF(AND(D19='4.0'!$S$14,'BON DE COMMANDE REPRO'!I19>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I19*'4.0'!$I$14,VLOOKUP(D19,'4.0'!$E:$F,2,FALSE)*I19)))))),0.05)","v":0}]
[null,null,"▼","▼",null,"▼","▼",null,0,{"$f":"MROUND(IF('4.0'!N3='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I20,IF('4.0'!N3='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I20,IF(AND(D20='4.0'!$S$11,'BON DE COMMANDE REPRO'!I20>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I20*'4.0'!$I$11,IF(AND(D20='4.0'!$S$12,'BON DE COMMANDE REPRO'!I20>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I20*'4.0'!$I$12,IF(AND(D20='4.0'!$S$13,'BON DE COMMANDE REPRO'!I20>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I20*'4.0'!$I$13,IF(AND(D20='4.0'!$S$14,'BON DE COMMANDE REPRO'!I20>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I20*'4.0'!$I$14,VLOOKUP(D20,'4.0'!$E:$F,2,FALSE)*I20)))))),0.05)","v":0}]
[null,null,"▼","▼",null,"▼","▼",null,0,{"$f":"MROUND(IF('4.0'!N4='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I21,IF('4.0'!N4='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I21,IF(AND(D21='4.0'!$S$11,'BON DE COMMANDE REPRO'!I21>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I21*'4.0'!$I$11,IF(AND(D21='4.0'!$S$12,'BON DE COMMANDE REPRO'!I21>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I21*'4.0'!$I$12,IF(AND(D21='4.0'!$S$13,'BON DE COMMANDE REPRO'!I21>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I21*'4.0'!$I$13,IF(AND(D21='4.0'!$S$14,'BON DE COMMANDE REPRO'!I21>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I21*'4.0'!$I$14,VLOOKUP(D21,'4.0'!$E:$F,2,FALSE)*I21)))))),0.05)","v":0}]
[null,null,"▼","▼",null,"▼","▼",null,0,{"$f":"MROUND(IF('4.0'!N5='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I22,IF('4.0'!N5='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I22,IF(AND(D22='4.0'!$S$11,'BON DE COMMANDE REPRO'!I22>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I22*'4.0'!$I$11,IF(AND(D22='4.0'!$S$12,'BON DE COMMANDE REPRO'!I22>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I22*'4.0'!$I$12,IF(AND(D22='4.0'!$S$13,'BON DE COMMANDE REPRO'!I22>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I22*'4.0'!$I$13,IF(AND(D22='4.0'!$S$14,'BON DE COMMANDE REPRO'!I22>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I22*'4.0'!$I$14,VLOOKUP(D22,'4.0'!$E:$F,2,FALSE)*I22)))))),0.05)","v":0}]
[null,null,"▼","▼",null,"▼","▼",null,0,{"$f":"MROUND(IF('4.0'!N6='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I23,IF('4.0'!N6='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I23,IF(AND(D23='4.0'!$S$11,'BON DE COMMANDE REPRO'!I23>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I23*'4.0'!$I$11,IF(AND(D23='4.0'!$S$12,'BON DE COMMANDE REPRO'!I23>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I23*'4.0'!$I$12,IF(AND(D23='4.0'!$S$13,'BON DE COMMANDE REPRO'!I23>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I23*'4.0'!$I$13,IF(AND(D23='4.0'!$S$14,'BON DE COMMANDE REPRO'!I23>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I23*'4.0'!$I$14,VLOOKUP(D23,'4.0'!$E:$F,2,FALSE)*I23)))))),0.05)","v":0}]
[null,null,"▼","▼",null,"▼","▼",null,0,{"$f":"MROUND(IF('4.0'!N7='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I24,IF('4.0'!N7='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I24,IF(AND(D24='4.0'!$S$11,'BON DE COMMANDE REPRO'!I24>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I24*'4.0'!$I$11,IF(AND(D24='4.0'!$S$12,'BON DE COMMANDE REPRO'!I24>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I24*'4.0'!$I$12,IF(AND(D24='4.0'!$S$13,'BON DE COMMANDE REPRO'!I24>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I24*'4.0'!$I$13,IF(AND(D24='4.0'!$S$14,'BON DE COMMANDE REPRO'!I24>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I24*'4.0'!$I$14,VLOOKUP(D24,'4.0'!$E:$F,2,FALSE)*I24)))))),0.05)","v":0}]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,null,{"$f":"SUM(I19:I24)","v":0},{"$f":"SUM(J19:J24)","v":0}]
["5.0 / Services, ventes, suppléments, finitions, reliures",null,null,null,"Le tableau ci-dessous est un complément de la partie 4.0 ou peut être rempli individuellement."]
["Désignation","PAO (à remplir par La Repro)",null,"Finitions","Reliures","Papier et grammage",null,"Quantité","Prix unitaire","Prix"]
[null,"▼",null,"▼","▼","▼",null,null,{"$f":"IF(AND(E28='5.0'!$K$2,'BON DE COMMANDE REPRO'!H28>='5.0'!$L$2),'5.0'!$M$2,IF(AND(D28='5.0'!$O$2,'BON DE COMMANDE REPRO'!H28>='5.0'!$P$2),'5.0'!$Q$2,VLOOKUP('5.0'!H2,'5.0'!$E:$F,2,FALSE)))","v":0},{"$f":"MROUND(SUM(H28*I28),0.05)","v":0}]
[null,"▼",null,"▼","▼","▼",null,null,{"$f":"IF(AND(E29='5.0'!$K$2,'BON DE COMMANDE REPRO'!H29>='5.0'!$L$2),'5.0'!$M$2,IF(AND(D29='5.0'!$O$2,'BON DE COMMANDE REPRO'!H29>='5.0'!$P$2),'5.0'!$Q$2,VLOOKUP('5.0'!H3,'5.0'!$E:$F,2,FALSE)))","v":0},{"$f":"MROUND(SUM(H29*I29),0.05)","v":0}]
[null,"▼",null,"▼","▼","▼",null,null,{"$f":"IF(AND(E30='5.0'!$K$2,'BON DE COMMANDE REPRO'!H30>='5.0'!$L$2),'5.0'!$M$2,IF(AND(D30='5.0'!$O$2,'BON DE COMMANDE REPRO'!H30>='5.0'!$P$2),'5.0'!$Q$2,VLOOKUP('5.0'!H4,'5.0'!$E:$F,2,FALSE)))","v":0},{"$f":"MROUND(SUM(H30*I30),0.05)","v":0}]
[null,"▼",null,"▼","▼","▼",null,null,{"$f":"IF(AND(E31='5.0'!$K$2,'BON DE COMMANDE REPRO'!H31>='5.0'!$L$2),'5.0'!$M$2,IF(AND(D31='5.0'!$O$2,'BON DE COMMANDE REPRO'!H31>='5.0'!$P$2),'5.0'!$Q$2,VLOOKUP('5.0'!H5,'5.0'!$E:$F,2,FALSE)))","v":0},{"$f":"MROUND(SUM(H31*I31),0.05)","v":0}]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,null,"Total:",{"$f":"SUM(J27:J31)","v":0}]
["6.0 / Posters et fournitures",null,null,"BAT = Bon-à-tirer / Épreuve"]
["Désignation",null,"BAT*","Format","Papier","Franc-bord",null,"Quantité","Prix unitaire","Prix"]
[null,null,"▼","▼","▼","▼",null,null,{"$f":"VLOOKUP('6.0'!J2,'6.0'!$G:$H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H35*I35),0.05)","v":0}]
[null,null,"▼","▼","▼","▼",null,null,{"$f":"VLOOKUP('6.0'!J3,'6.0'!$G:$H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H36*I36),0.05)","v":0}]
[null,null,"▼","▼","▼","▼",null,null,{"$f":"VLOOKUP('6.0'!J4,'6.0'!$G:$H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H37*I37),0.05)","v":0}]
[null,null,"▼","▼","▼","▼",null,null,{"$f":"VLOOKUP('6.0'!J5,'6.0'!$G:$H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H38*I38),0.05)","v":0}]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,null,"Total:",{"$f":"SUM(J34:J38)","v":0}]
["7.0 / Autres produits / Champs libres",null,null,"Ces champs peuvent être utilisés par La Repro pour des articles / produits / prestations, non répertoriés ou très spécifiques."]
["Désignation","Quantité",null,"Prix unitaire","Prix","Désignation",null,"Quantité","Prix unitaire","Prix"]
[null,null,null,null,{"$f":"MROUND(SUM(B42*D42),0.05)","v":0},null,null,null,null,{"$f":"MROUND(SUM(H42*I42),0.05)","v":0}]
[null,null,null,null,{"$f":"MROUND(SUM(B43*D43),0.05)","v":0},null,null,null,null,{"$f":"MROUND(SUM(H43*I43),0.05)","v":0}]
[null,null,null,null,0,null,null,null,null,0]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,null,"Total:",{"$f":"SUM(E42+E43+E44+J42+J43+J44)","v":0}]
["8.0 / Choix de la livraison",null,null,"Pour le retrait, merci de consulter nos horaires d'ouverture. Pour l'expédition: gratuit si interne du campus - si externe: frais de port en sus."]
["           Retrait à La Repro",null,null,"Expédier la commande à l'adresse ci-dessous (9.0)"]
["9.0 / Remarques, champ libre, adresse de livraison éventuelle si point 8.0 coché",null,null,null,null,null,null,null,"RABAIS:",0]
[null,null,null,null,null,null,null,null,"TOTAL:",{"$f":"SUM(J25+J32+J39+J45-J48)","v":0}]
["10.0 / Signature, Confirmation",null,null,"En remplissant les données ci-dessous, vous confirmez cette commande et avoir correctement rempli les informations de facturation 2.2 ou 2.3"]
["Date:",null,null,"Nom / Prénom:",null,null,null,"Signature:","Pas nécessaire si envoyé par e-mail"]
["La Repro |  UNIL-Chamberonne | Bât. Anthropole | Bur. 2088 | 1015 Lausanne | repro@unil.ch | unil.ch/repro"]

{"sheet":"Liste de Prix","index":1,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,0,53,7],[24,0,24,3],[38,6,38,7],[38,0,38,4],[0,0,0,7],[6,4,6,5],[6,6,6,7],[13,6,13,7],[36,4,36,7],[9,0,9,2]]}
["UNIL - Université de Lausanne - La Repro (Ci) - LISTE DE PRIX (v-0522) - 2/2"]
[]
["Impressions numériques classiques",null,null,null,"Tarifs spéciaux (feuilles volantes, Flyers, Affiches)"]
["Format","NB","Couleur",null,"Format","NB","Couleur"]
["A4 Recto",0.1,0.4,null,"SRA3 recto",0.15,0.5]
["A3 Recto",0.2,0.8]
["A4 Recto/Verso",0.1,0.4,null,"PAO \"Repro\"",null,"PAO \"Conception\""]
["A3 Recto/Verso",0.2,0.8,null,"Prestation","Prix","Prestation","Prix"]
[null,null,null,null,"Prise en charge",5,"Aff./Fly (1p, R)",50]
["Rabais de quantités",null,null,null,"Traitement / Prép.",10,"Flyers (2p, RV)",100]
["A4 Recto/Verso","0.09 (>8000 flles)","0.36 (>1000 flles)",null,"Reprise de fichier",20,"Dépliant (4-6p)",200]
["A3 Recto/Verso","0.18 (>4000 flles)","0.72 (> 500 flles)"]
[]
["Liste de prix estimatifs (Multipliez votre quantité pour une fourchette de prix)",null,null,null,null,null,"Reliure"]
["Type","Format","Mode","Tonalité","Prix unitaire",null,"Prestation","Prix"]
["Flyers","A6","Recto","Couleur",0.10075000000000001,null,"Dos toilé",3]
["Flyers","A6","Recto/Verso","Couleur",0.13825000000000001,null,"Anneaux plast.",3]
["Flyers","A5","Recto","Couleur",0.19450000000000001,null,"Anneaux Repro",4]
["Flyers","A5","Recto/Verso","Couleur",0.26950000000000002,null,"Cahier (<80p.)",0.4]
["Affichettes","A4","Recto","Couleur",0.28199999999999997,null,"Cahier (>80p.)",1]
["Affiches","A3","Recto","Couleur",0.55700000000000005,null,"Dos-carré-collé","4.00 (1.00 dès 100x)"]
["Cartes de visite","85x54mm","R + Recto/Verso","Couleur",0.3,null,"Couv. Thèse/Mém.",6]
["Cartes de visite","85x54mm","R + Recto/Verso","Noir et Blanc",0.25]
[]
["Posters",null,null,null,null,null,"Finitions et fournitures posters"]
["Format","Mat","Satiné","Toile",null,null,"Article","Prix"]
["A2",5,5,14,null,null,"Carton A4 / toile",2]
["A1",12,16,28,null,null,"Franc-bord 1",1]
["A0",17,24,39,null,null,"Franc-bord 2",2]
["U4",30,40,70]
[]
[]
[null,null,null,"*Explication des abréviations:"]
[null,null,null,"BAT","Bon-à-tirer (Epreuve)"]
[null,null,null,"A","Agrafage 1x sur le coin"]
[null,null,null,"Franc-bord","Coupé au format, supprimer les marges blanches tout autour"]
[null,null,null,"R - RV","R = Recto, RV = Recto-Verso"]
[]
["Papier suppléments feuilles + Achat",null,null,null,null,null,"Finition"]
["GR / Format","Mat (blanc)","Satiné (blanc)","Couleur","Crème",null,"Prestation","Prix"]
["80 SRA3",0.04,0.05,"0.05 - A3","-",null,"Coupe",2]
["120 SRA3",0.08,0.1,"-","0.24 - 100gr",null,"Coupe (>8000flles)",1]
["160 SRA3",0.12,0.15,"0.10, A4 / 0.15, A3","-",null,"Pliage",0.1]
["200 SRA3",0.16,0.2,"-","-",null,"Rainage",0.1]
["250 SRA3",0.2,0.25,"-","-",null,"Rainage + Pliage",0.15]
["300 SRA3",0.24,0.3,"-",0.71,null,"Plastification A4",1]
["350 SRA3","-",0.35,"-","-",null,"Plastification A3",2]
["Rame A4 80gr",7.25,"-",15,"-",null,"Trous classeurs",1.5]
["Carton A4 80gr",36.25,"-",75,"-"]
["Palette A4 80gr",1450,"-","-","-"]
["Rame A3 80gr",14.5,"-","-","-"]
["Carton A3 80gr",72.5,"-","-","-"]
[]
["La Repro |  UNIL-Chamberonne | Bât. Anthropole | Bur. 2088 | 1015 Lausanne | repro@unil.ch | unil.ch/repro"]

{"sheet":"3.0","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Sélectionner ici:",null,null,"x","Sélectionner ici:",null,null,null,null,"x"]
["▼",null,null,null,"▼"]
["Achat d'anneaux plastiques",null,null,null,"Interne à l'UNIL (Imputation)"]
["Achat de papier en cartons",null,null,null,"Externe de l'UNIL (Facturation)"]
["Achat de papier en palettes",null,null,null,"-"]
["Achat de papier en rames",null,null,null,"Privée (académique)"]
["Affiche A3",null,null,null,"Privée (non-académique)"]
["Affichette A4",null,null,null,null,null,null,"Sélectionner ici:",null,null,"Sélectionner ici:"]
["Cahier agrafé (<80p.)",null,null,null,null,null,null,"▼",null,null,"▼"]
["Cahier agrafé (>80p à ~200p.)",null,null,null,null,null,null,"Basique",null,null,"Mat (Texte)"]
["Cartes de visite",null,null,null,null,null,null,"Standard",null,null,"Satiné (Images)"]
["Demande de mise en page",null,null,null,null,null,null,"Premium"]
["Dépliant 2 volets A3/A4",null,null,null,"Sélectionner ici:"]
["Dépliant 2 volets A4/A5",null,null,null,"▼"]
["Dépliant 2 volets A5/A6",null,null,null,"en 1 à 2 jours",null,null,"Sélectionner ici:"]
["Dépliant 3 volets A4",null,null,null,"en 2 à 3 jours",null,null,"▼"]
["Feuilles A4 agrafées sur le coin 1x",null,null,null,"en 3 à 4 jours",null,null,"Noir et blanc"]
["Feuilles volantes A4",null,null,null,"en 4 à 5 jours",null,null,"Couleur"]
["Flyers A5",null,null,null,"semaine proch.",null,null,"Mixes (NB+Coul.)"]
["Flyers A6"]
["Livre / Roman / Edition / Rapport",null,null,null,"BAT"]
["Mémoire (Impression+Reliures)",null,null,null,"Sélectionner ici:"]
["Mémoire (Reliures UNIQUEMENT)",null,null,null,"▼"]
["Polycopié",null,null,null,"oui"]
["Poster (Autre format)",null,null,null,"non"]
["Poster A0"]
["Poster A1",null,null,null,"Agrafage:"]
["Poster A2",null,null,null,"Sélectionner ici:"]
["Poster F4",null,null,null,"▼"]
["Poster U4",null,null,null,"oui"]
["Reliures uniquement",null,null,null,"non"]
["Thèse (Impressions+Reliure)"]
["Thèse (Reliure UNIQUEMENT)"]
["-",null,null,null,"▼"]
["Autre (spécifier partie 9.0)",null,null,null,"Noir que Recto"]
[null,null,null,null,"Noir en Recto/Verso"]
[null,null,null,null,"Couleur que recto"]
[null,null,null,null,"Couleur en Recto/Verso"]
[null,null,null,null,"Mixes que Recto"]
[null,null,null,null,"Mixes en Recto/Verso"]

{"sheet":"4.0","index":3,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Pour menus déroulants Format",null,null,null,"Matrice des Prix",null,null,"Matrice des Prix - RABAIS 10%",null,null,"Recto, Recto-Verso?",null,null,"CONCATENER","ESPACE",null,null,null,"RABAIS 10%"]
["Sélectionner ici:",null,null,null,null,null,null,null,null,null,"Sélectionner ici:",null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D19,'4.0'!O2,'BON DE COMMANDE REPRO'!F19)","v":"▼ ▼"}," ","SRA3 - Couleur Recto"," "]
["▼",null,null,null,"A8 - noir et blanc",6.2500000000000003E-3,null,null,null,null,"▼",null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D20,'4.0'!O3,'BON DE COMMANDE REPRO'!F20)","v":"▼ ▼"}," ","SRA3 - noir/blanc Recto"]
["A4 - noir et blanc",null,null,null,"A8 - Couleur",2.5000000000000001E-2,null,null,null,null,"Recto",null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D21,'4.0'!O4,'BON DE COMMANDE REPRO'!F21)","v":"▼ ▼"}," "]
["A4 - Couleur",null,null,null,"A7 - noir et blanc",1.2500000000000001E-2,null,null,null,null,"Recto-Verso",null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D22,'4.0'!O5,'BON DE COMMANDE REPRO'!F22)","v":"▼ ▼"}," "]
["-",null,null,null,"A7 - Couleur",0.05,null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D23,'4.0'!O6,'BON DE COMMANDE REPRO'!F23)","v":"▼ ▼"}," "]
["A3 - noir et blanc",null,null,null,"A6 - noir et blanc",2.5000000000000001E-2,null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D24,'4.0'!O7,'BON DE COMMANDE REPRO'!F24)","v":"▼ ▼"}," "]
["A3 - Couleur",null,null,null,"A6 - Couleur",0.1]
["-",null,null,null,"A5 - noir et blanc",0.05]
["SRA3 - Couleur",null,null,null,"A5 - Couleur",0.2]
["SRA3 - noir/blanc",null,null,null,"A4 - noir et blanc",0.1,null,"A4 - noir et blanc",9.0000000000000011E-2,null,null,null,null,null,null,null,null,null,"A4 - noir et blanc",8000]
["-",null,null,null,"A4 - Couleur",0.4,null,"A4 - Couleur",0.36000000000000004,null,null,null,null,null,null,null,null,null,"A4 - Couleur",1000]
["A5 - noir et blanc",null,null,null,"A3 - noir et blanc",0.2,null,"A3 - noir et blanc",0.18000000000000002,null,null,null,null,null,null,null,null,null,"A3 - noir et blanc",4000]
["A5 - Couleur",null,null,null,"A3 - Couleur",0.8,null,"A3 - Couleur",0.72000000000000008,null,null,null,null,null,null,null,null,null,"A3 - Couleur",500]
["-",null,null,null,"SRA3 - Couleur",0.8]
["A6 - noir et blanc",null,null,null,"SRA3 - noir/blanc",0.2]
["A6 - Couleur",null,null,null,"SRA3 - Couleur",0.5]
["-",null,null,null,"SRA3 - noir/blanc",0.15]
["A7 - noir et blanc",null,null,null,"-","-"]
["A7 - Couleur",null,null,null,"▼"]
["-"]
["A8 - noir et blanc"]
["A8 - Couleur"]

{"sheet":"5.0","index":4,"n_rows":109,"n_cols":17,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"x","Matrice des Prix",null,null,"Sélection client","ATTENTION CONCATENER",null,"Prix rabais quantité",null,null,null,"Prix rabais coupe massicot"]
[null,null,null,null,"-",null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!$B$28,'5.0'!$I$2,'BON DE COMMANDE REPRO'!$D$28,'5.0'!$I$2,'BON DE COMMANDE REPRO'!$E$28,'5.0'!$I$2,'BON DE COMMANDE REPRO'!$F$28)","v":"▼ ▼ ▼ ▼"}," ",null,"Dos-carré-collé",100,1,null,"Coupe massicot",800,1]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!B29,'5.0'!I3,'BON DE COMMANDE REPRO'!D29,'5.0'!I3,'BON DE COMMANDE REPRO'!E29,'5.0'!I3,'BON DE COMMANDE REPRO'!F29)","v":"▼ ▼ ▼ ▼"}," "]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!B30,'5.0'!I4,'BON DE COMMANDE REPRO'!D30,'5.0'!I4,'BON DE COMMANDE REPRO'!E30,'5.0'!I4,'BON DE COMMANDE REPRO'!F30)","v":"▼ ▼ ▼ ▼"}," "]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!B31,'5.0'!I5,'BON DE COMMANDE REPRO'!D31,'5.0'!I5,'BON DE COMMANDE REPRO'!E31,'5.0'!I5,'BON DE COMMANDE REPRO'!F31)","v":"▼ ▼ ▼ ▼"}," "]
[null,null,null,null,null,null,null,null," "]
["Pour menus déroulants Impressions",null,null,null,null,null,null,null," "]
["▼",null,null,null,null,null,null,null," "]
["SRA3 R NB",null,null,null,"Agrafes",0,null,null," "]
["SRA3 RV NB",null,null,null,"Trous classeur",1.5,null,null," "]
["SRA3 R Coul.",null,null,null,"Pliage / Rainage",0.1,null,null," "]
["SRA3 RV Coul.",null,null,null,"Rainage + Pliage",0.15,null,null," "]
[null,null,null,null,"Perforations",0,null,null," "]
["Pour menus déroulants Finitions",null,null,null,null,null,null,null," "]
["▼",null,null,null,"Coupe massicot",2,null,null," "]
["Agrafes",null,null,null,"Autre",null,null,null," "]
["Trous classeur",null,null,null,"▼ Agrafes ▼ ▼",0,null,null," "]
["Pliage / Rainage",null,null,null,"▼ Trous classeur ▼ ▼",1.5,null,null," "]
["Rainage + Pliage",null,null,null,"▼ Pliage / Rainage ▼ ▼",0.1,null,null," "]
["Perforations",null,null,null,"▼ Rainage + Pliage ▼ ▼",0.15,null,null," "]
["Plastification A4",null,null,null,"▼ Perforations ▼ ▼",0,null,null," "]
["Plastification A3",null,null,null,null,null,null,null," "]
["Coupe massicot",null,null,null,"▼ Coupe massicot ▼ ▼",2,null,null," "]
["Autre",null,null,null,"▼ Autre ▼ ▼",null,null,null," "]
[null,null,null,null,"Dos toilé",3,null,null," "]
[null,null,null,null,"Anneaux plast.",3,null,null," "]
["Pour menus déroulants Reliures",null,null,null,"Cahier (<80p.)",0.4,null,null," "]
["▼",null,null,null,"Dos-carré-collé",4,null,null," "]
["Dos toilé",null,null,null,"Dos-carré-collé (+100)",3,null,null," "]
["Dos-carré-collé",null,null,null,"▼ ▼ Dos toilé ▼",3]
["Cahier (<80p.)",null,null,null,"▼ ▼ Anneaux plast. ▼",3]
["Cahier (>80p.)",null,null,null,"▼ ▼ Cahier (<80p.) ▼",0.4]
["Couv. TM",null,null,null,"▼ ▼ Dos-carré-collé ▼",4]
["Anneaux plast.",null,null,null,"▼ ▼ Dos-carré-collé (+100) ▼",3]
["Anneaux Repro",null,null,null,"Mat 80",0.04]
[null,null,null,null,"Mat 120",0.08]
["Pour menus déroulants Services",null,null,null,"Mat 160",0.12]
["▼",null,null,null,"Mat 200",0.16]
["Prise en charge",null,null,null,"Mat 250",0.2]
["Traitement / Prép.",null,null,null,"Mat 300",0.24]
["Reprise",null,null,null,"Satiné 90",0.05]
["Conception Aff. / Fly.",null,null,null,"Satiné 120",0.1]
["Conception Dép.",null,null,null,"Satiné 160",0.15]
["Conception Rel.",null,null,null,"Satiné 200",0.2]
[null,null,null,null,"Satiné 250",0.25]
[null,null,null,null,"Satiné 300",0.3]
[null,null,null,null,"Rame A4 80gr",7.25]
[null,null,null,null,"Carton A4 80gr",36.25]
[null,null,null,null,"Palette A4 80gr",1450]
[null,null,null,null,"Autre",0]
[null,null,null,null,"▼ ▼ ▼ Mat 80",0.04]
[null,null,null,null,"▼ ▼ ▼ Mat 120",0.08]
[null,null,null,null,"▼ ▼ ▼ Mat 160",0.12]
["Pour menus déroulants Papiers",null,null,null,"▼ ▼ ▼ Mat 200",0.16]
["▼",null,null,null,"▼ ▼ ▼ Mat 250",0.2]
["Mat 80",null,null,null,"▼ ▼ ▼ Mat 300",0.24]
["Mat 120",null,null,null,"▼ ▼ ▼ Satiné 90",0.05]
["Mat 160",null,null,null,"▼ ▼ ▼ Satiné 120",0.1]
["Mat 200",null,null,null,"▼ ▼ ▼ Satiné 160",0.15]
["Mat 250",null,null,null,"▼ ▼ ▼ Satiné 200",0.2]
["Mat 300",null,null,null,"▼ ▼ ▼ Satiné 250",0.25]
["-",null,null,null,"▼ ▼ ▼ Satiné 300",0.3]
["Satiné 90",null,null,null,"▼ ▼ ▼ Rame A4 80gr",7.25]
["Satiné 120",null,null,null,"▼ ▼ ▼ Carton A4 80gr",36.25]
["Satiné 160",null,null,null,"▼ ▼ ▼ Palette A4 80gr",1450]
["Satiné 200",null,null,null,"▼ ▼ ▼ Autre",0]
["Satiné 250",null,null,null,"▼ ▼ ▼ ▼",0]
["Satiné 300",null,null,null,"Cahier (>80p.)",1]
["Satiné 350",null,null,null,"▼ ▼ Cahier (>80p.) ▼",1]
["-",null,null,null,"Couleur A4 80gr",0.05]
["Crème 100",null,null,null,"Couleur A4 160gr",0.1]
["Crème 300",null,null,null,"Couleur A3 160gr",0.15]
["-",null,null,null,"▼ ▼ ▼ Couleur A4 80gr",0.05]
["Rame A4 80gr",null,null,null,"▼ ▼ ▼ Couleur A4 160gr",0.1]
["Carton A4 80gr",null,null,null,"▼ ▼ ▼ Couleur A3 160gr",0.15]
["Palette A4 80gr",null,null,null,"Rame A3 80gr",14.5]
["-",null,null,null,"Carton A3 80gr",72.5]
["Rame A3 80gr",null,null,null,"▼ ▼ ▼ Rame A3 80gr",14.5]
["Carton A3 80gr",null,null,null,"▼ ▼ ▼ Carton A3 80gr",72.5]
["-",null,null,null,"Plastification A4",1]
["Couleur A4 80gr",null,null,null,"Plastification A3",2]
["Couleur A4 160gr",null,null,null,"▼ Plastification A4 ▼ ▼",1]
["Couleur A3 160gr",null,null,null,"▼ Plastification A3 ▼ ▼",2]
["-",null,null,null,"Satiné 350",0.35]
["Autre",null,null,null,"▼ ▼ ▼ Satiné 350",0.35]
[null,null,null,null,"Crème 100",0.24]
[null,null,null,null,"▼ ▼ ▼ Crème 100",0.24]
[null,null,null,null,"Crème 300",0.71]
[null,null,null,null,"▼ ▼ ▼ Crème 300",0.71]
[]
[null,null,null,null,"Prise en charge",5]
[null,null,null,null,"Traitement / Prép.",10]
[null,null,null,null,"Reprise",20]
[null,null,null,null,"Conception Aff. / Fly.",50]
[null,null,null,null,"Conception Dép.",100]
[null,null,null,null,"Conception Rel.",200]
[]
[null,null,null,null,"Prise en charge ▼ ▼ ▼",5]
[null,null,null,null,"Traitement / Prép. ▼ ▼ ▼",10]
[null,null,null,null,"Reprise ▼ ▼ ▼",20]
[null,null,null,null,"Conception Aff. / Fly. ▼ ▼ ▼",50]
[null,null,null,null,"Conception Dép. ▼ ▼ ▼",100]
[null,null,null,null,"Conception Rel. ▼ ▼ ▼",200]
[]
[null,null,null,null,"Anneaux Repro",4]
[null,null,null,null,"▼ ▼ Anneaux Repro ▼",4]
[]
[null,null,null,null,"Couv. TM",6]
[null,null,null,null,"▼ ▼ Couv. TM ▼",6]

{"sheet":"6.0","index":5,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Pour menus déroulants posters",null,null,null,null,null,"Matrice des Prix",null,null,"Sélection client","ATTENTION CONCATENER"]
["Sélectionner ici:",null,"Sélectionner ici:",null,"Sélectionner ici:",null,"A2 mat non",5,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D35,'6.0'!K2,'BON DE COMMANDE REPRO'!E35,'6.0'!K2,'BON DE COMMANDE REPRO'!F35)","v":"▼ ▼ ▼"}," "]
["▼",null,"▼",null,"▼",null,"A1 mat non",12,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D36,'6.0'!K3,'BON DE COMMANDE REPRO'!E36,'6.0'!K3,'BON DE COMMANDE REPRO'!F36)","v":"▼ ▼ ▼"}," "]
["A2",null,"mat",null,"non",null,"A0 mat non",17,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D37,'6.0'!K4,'BON DE COMMANDE REPRO'!E37,'6.0'!K4,'BON DE COMMANDE REPRO'!F37)","v":"▼ ▼ ▼"}," "]
["A1",null,"satiné",null,"oui (FB2, unique)",null,"F4 mat non",24,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D38,'6.0'!K5,'BON DE COMMANDE REPRO'!E38,'6.0'!K5,'BON DE COMMANDE REPRO'!F38)","v":"▼ ▼ ▼"}," "]
["A0",null,"toile",null,"oui (FB1, multiples)",null,"U4 mat non",30,null,null," "]
["F4",null,null,null,null,null,"A2 satiné non",5,null,null," "]
["U4",null,null,null,null,null,"A1 satiné non",16,null,null," "]
["Autre",null,null,null,null,null,"A0 satiné non",24,null,null," "]
["-",null,null,null,null,null,"F4 satiné non",32,null,null," "]
["Carton A4 / toile",null,null,null,null,null,"U4 satiné non",40,null,null," "]
["Tube carton",null,null,null,null,null,"A2 toile non",14,null,null," "]
["Tube plastique",null,null,null,null,null,"A1 toile non",28,null,null," "]
[null,null,null,null,null,null,"A0 toile non",39,null,null," "]
[null,null,null,null,null,null,"F4 toile non",56,null,null," "]
[null,null,null,null,null,null,"U4 toile non",70,null,null," "]
[null,null,null,null,null,null,"A2 mat oui (FB2, unique)",7,null,null," "]
[null,null,null,null,null,null,"A1 mat oui (FB2, unique)",14,null,null," "]
[null,null,null,null,null,null,"A0 mat oui (FB2, unique)",19,null,null," "]
[null,null,null,null,null,null,"F4 mat oui (FB2, unique)",26,null,null," "]
[null,null,null,null,null,null,"U4 mat oui (FB2, unique)",32,null,null," "]
[null,null,null,null,null,null,"A2 satiné oui (FB2, unique)",7,null,null," "]
[null,null,null,null,null,null,"A1 satiné oui (FB2, unique)",18,null,null," "]
[null,null,null,null,null,null,"A0 satiné oui (FB2, unique)",26,null,null," "]
[null,null,null,null,null,null,"F4 satiné oui (FB2, unique)",34,null,null," "]
[null,null,null,null,null,null,"U4 satiné oui (FB2, unique)",42,null,null," "]
[null,null,null,null,null,null,"A2 toile oui (FB2, unique)",16,null,null," "]
[null,null,null,null,null,null,"A1 toile oui (FB2, unique)",30,null,null," "]
[null,null,null,null,null,null,"A0 toile oui (FB2, unique)",41,null,null," "]
[null,null,null,null,null,null,"F4 toile oui (FB2, unique)",58]
[null,null,null,null,null,null,"U4 toile oui (FB2, unique)",72]
[null,null,null,null,null,null,"Autre mat oui (FB2, unique)"]
[null,null,null,null,null,null,"Autre mat non"]
[null,null,null,null,null,null,"Autre satiné oui (FB2, unique)"]
[null,null,null,null,null,null,"Autre satiné non"]
[null,null,null,null,null,null,"Autre toile oui (FB2, unique)"]
[null,null,null,null,null,null,"Autre toile non"]
[null,null,null,null,null,null,"Tube carton ▼ ▼",9]
[null,null,null,null,null,null,"Tube plastique ▼ ▼",20]
[null,null,null,null,null,null,"▼ ▼ ▼",0]
[]
[null,null,null,null,null,null,"A2 mat oui (FB1, multiples)",6]
[null,null,null,null,null,null,"A1 mat oui (FB1, multiples)",13]
[null,null,null,null,null,null,"A0 mat oui (FB1, multiples)",18]
[null,null,null,null,null,null,"F4 mat oui (FB1, multiples)",25]
[null,null,null,null,null,null,"U4 mat oui (FB1, multiples)",31]
[null,null,null,null,null,null,"A2 satiné oui (FB1, multiples)",6]
[null,null,null,null,null,null,"A1 satiné oui (FB1, multiples)",17]
[null,null,null,null,null,null,"A0 satiné oui (FB1, multiples)",25]
[null,null,null,null,null,null,"F4 satiné oui (FB1, multiples)",33]
[null,null,null,null,null,null,"U4 satiné oui (FB1, multiples)",41]
[null,null,null,null,null,null,"A2 toile oui (FB1, multiples)",15]
[null,null,null,null,null,null,"A1 toile oui (FB1, multiples)",29]
[null,null,null,null,null,null,"A0 toile oui (FB1, multiples)",40]
[null,null,null,null,null,null,"F4 toile oui (FB1, multiples)",57]
[null,null,null,null,null,null,"U4 toile oui (FB1, multiples)",71]
[null,null,null,null,null,null,"Autre mat oui (FB1, multiples)"]
[null,null,null,null,null,null,"Autre satiné oui (FB1, multiples)"]
[null,null,null,null,null,null,"Autre toile oui (FB1, multiples)"]
[]
[null,null,null,null,null,null,"Carton A4 / toile ▼ ▼",2]