{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["BON DE COMMANDE REPRO","Liste de Prix","3.0","4.0","5.0","6.0","8.0"],"not_rendered":{"charts":0,"images":0,"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":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,0,54,7],[53,4,53,6],[53,1,53,2],[53,8,54,9],[47,1,47,2],[47,5,47,6],[47,3,47,4],[50,0,50,6],[41,1,41,2],[41,5,41,6],[43,0,43,2],[48,0,48,2],[48,3,48,9],[42,1,42,2],[42,5,42,6],[42,3,42,4],[43,3,43,9],[44,1,44,2],[44,5,44,6],[45,1,45,2],[46,1,46,2],[46,5,46,6],[45,5,45,6],[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],[23,0,23,3],[17,0,17,1],[22,1,22,2],[22,5,22,6],[21,0,21,1],[20,0,20,1],[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],[11,0,11,2],[11,3,11,9],[13,0,13,9],[35,4,35,6],[30,0,30,2],[28,5,28,6],[16,0,16,1],[12,0,12,9],[27,1,27,2],[23,4,23,9],[24,1,24,2],[24,5,24,6],[25,5,25,6],[26,5,26,6],[26,1,26,2],[25,1,25,2],[14,3,14,9],[22,3,22,4],[18,0,18,1],[19,0,19,1],[14,0,14,2],[15,0,15,1],[27,5,27,6],[28,1,28,2],[39,5,39,6],[40,5,40,6],[39,1,39,2],[40,1,40,2],[29,3,29,4],[38,5,38,6],[29,5,29,6],[36,3,36,4],[36,5,36,6],[36,1,36,2],[32,0,32,1],[38,1,38,2],[35,0,35,1],[37,0,37,2],[31,0,31,1],[29,1,29,2],[30,3,30,9],[37,3,37,9],[34,0,34,1],[33,0,33,1],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6]]}
["UNIL - Université de Lausanne - La Repro (Ci) - LISTE DE PRIX (v0123) - 1/2"]
["0.0 / A remplir par La Repro",null,null,"Traitée par",null,"No de ticket",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,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 / 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(F17=\"Recto-Verso\",ROUNDUP(E17/2,0)*H17,IF(F17=\"Recto\",E17*H17,0))","v":0},{"$f":"MROUND(IF('4.0'!N2='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I17,IF('4.0'!N2='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I17,IF(AND(D17='4.0'!$S$11,'BON DE COMMANDE REPRO'!I17>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I17*'4.0'!$I$11,IF(AND(D17='4.0'!$S$12,'BON DE COMMANDE REPRO'!I17>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I17*'4.0'!$I$12,IF(AND(D17='4.0'!$S$13,'BON DE COMMANDE REPRO'!I17>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I17*'4.0'!$I$13,IF(AND(D17='4.0'!$S$14,'BON DE COMMANDE REPRO'!I17>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I17*'4.0'!$I$14,VLOOKUP(D17,'4.0'!$E:$F,2,FALSE)*I17)))))),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'!I18,IF('4.0'!N3='4.0'!$P$3,'4.0'!$F$18*'BON DE COMMANDE REPRO'!I18,IF(AND(D18='4.0'!$S$11,'BON DE COMMANDE REPRO'!I18>='4.0'!$T$11),'BON DE COMMANDE REPRO'!I18*'4.0'!$I$11,IF(AND(D18='4.0'!$S$12,'BON DE COMMANDE REPRO'!I18>='4.0'!$T$12),'BON DE COMMANDE REPRO'!I18*'4.0'!$I$12,IF(AND(D18='4.0'!$S$13,'BON DE COMMANDE REPRO'!I18>='4.0'!$T$13),'BON DE COMMANDE REPRO'!I18*'4.0'!$I$13,IF(AND(D18='4.0'!$S$14,'BON DE COMMANDE REPRO'!I18>='4.0'!$T$14),'BON DE COMMANDE REPRO'!I18*'4.0'!$I$14,VLOOKUP(D18,'4.0'!$E:$F,2,FALSE)*I18)))))),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'!I19,IF('4.0'!N4='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'!N5='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I20,IF('4.0'!N5='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'!N6='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I21,IF('4.0'!N6='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'!N7='4.0'!$P$2,'4.0'!$F$17*'BON DE COMMANDE REPRO'!I22,IF('4.0'!N7='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}]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,"Total:",{"$f":"SUM(I17:I22)","v":0},{"$f":"SUM(J17:J22)","v":0}]
["4.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(E26='5.0'!$K$2,'BON DE COMMANDE REPRO'!H26>='5.0'!$L$2),'5.0'!$M$2,IF(AND(D26='5.0'!$O$2,'BON DE COMMANDE REPRO'!H26>='5.0'!$P$2),'5.0'!$Q$2,VLOOKUP('5.0'!H2,'5.0'!$E:$F,2,FALSE)))","v":0},{"$f":"MROUND(SUM(H26*I26),0.05)","v":0}]
[null,"▼",null,"▼","▼","▼",null,null,{"$f":"IF(AND(E27='5.0'!$K$2,'BON DE COMMANDE REPRO'!H27>='5.0'!$L$2),'5.0'!$M$2,IF(AND(D27='5.0'!$O$2,'BON DE COMMANDE REPRO'!H27>='5.0'!$P$2),'5.0'!$Q$2,VLOOKUP('5.0'!H3,'5.0'!$E:$F,2,FALSE)))","v":0},{"$f":"MROUND(SUM(H27*I27),0.05)","v":0}]
[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'!H4,'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'!H5,'5.0'!$E:$F,2,FALSE)))","v":0},{"$f":"MROUND(SUM(H29*I29),0.05)","v":0}]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,null,"Total:",{"$f":"SUM(J25:J29)","v":0}]
["5.0 / Posters et fournitures",null,null,"BAT = Bon-à-tirer. Marges blanches de 5mm tout autour conservées en cas de: délais serrés, posters scientifiques et pour le U4"]
["Désignation",null,"BAT*","Format","Support (mat / toile)",null,null,"Quantité","Prix unitaire","Prix"]
[null,null,"▼","▼","▼",null,null,null,{"$f":"VLOOKUP('6.0'!J2,'6.0'!G:H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H33*I33),0.05)","v":0}]
[null,null,"▼","▼","▼",null,null,null,{"$f":"VLOOKUP('6.0'!J3,'6.0'!$G:$H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H34*I34),0.05)","v":0}]
[null,null,"▼","▼","▼",null,null,null,{"$f":"VLOOKUP('6.0'!J4,'6.0'!$G:$H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H35*I35),0.05)","v":0}]
[null,null,"▼","▼","▼",null,null,null,{"$f":"VLOOKUP('6.0'!J5,'6.0'!$G:$H,2,FALSE)","v":0},{"$f":"MROUND(SUM(H36*I36),0.05)","v":0}]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,null,"Total:",{"$f":"SUM(J32:J36)","v":0}]
["6.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(B40*D40),0.05)","v":0},null,null,null,null,{"$f":"MROUND(SUM(H40*I40),0.05)","v":0}]
[null,null,null,null,{"$f":"MROUND(SUM(B41*D41),0.05)","v":0},null,null,null,null,{"$f":"MROUND(SUM(H41*I41),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(E40+E41+E42+J40+J41+J42)","v":0}]
["7.0 / Produits prédéfinis par La Repro",null,null,"Pour les détails, vous pouvez consulter notre page au verso, dans l'onglet Liste de Prix."]
["Désignation","Quantité",null,"Prix unitaire","Prix","Désignation",null,"Quantité","Prix unitaire","Prix"]
["▼",null,null,{"$f":"VLOOKUP($A$46,'8.0'!$C$1:$D$29,2,FALSE)","v":0},{"$f":"MROUND(SUM(B46*D46),0.05)","v":0},"▼",null,null,{"$f":"VLOOKUP($F$46,'8.0'!$C$1:$D$29,2,FALSE)","v":0},{"$f":"IF(I46=\" \",\"-\",SUM(I46*H46))","v":0}]
["▼",null,null,{"$f":"VLOOKUP($A$47,'8.0'!$C$1:$D$29,2,FALSE)","v":0},{"$f":"IF(D47=\" \",\"-\",SUM(D47*B47))","v":0},"▼",null,null,{"$f":"VLOOKUP($F$47,'8.0'!$C$1:$D$29,2,FALSE)","v":0},{"$f":"IF(I47=\" \",\"-\",SUM(I47*H47))","v":0}]
["Délai:",null,null,"A remplir par La Repro, No OTRS:",null,null,null,null,"Total:",{"$f":"SUM(E46+E47+J46+J47)","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,"GRAND TOTAL ",{"$f":"SUM(J23+J30+J37+J43+J48-J51)","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":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,0,56,7],[14,0,14,4],[0,0,0,7],[6,4,6,5],[6,6,6,7],[13,6,13,7],[9,0,9,2],[13,0,13,4],[31,0,31,6],[37,3,37,5],[38,3,38,5],[39,3,39,5]]}
["UNIL - Université de Lausanne - La Repro (Ci) - LISTE DE PRIX (v0123) - 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 (4p)",200]
["A3 Recto/Verso","0.18 (>4000 flles)","0.72 (> 500 flles)",null,null,null,"Dépliant (6p)",300]
[]
["Produits prédéfinis par La Repro",null,null,null,null,null,"Reliures"]
["Des prises en charge peuvent s'ajouter de * 1.- / ** 2.- / *** 3.- / **** 4.- selon le type de fichier.",null,null,null,null,null,"Prestation","Prix"]
["Type","Format","Mode","Grammage","Prix unitaire",null,"Dos toilé écolo.",2]
["Affiche","A3","Recto","120gr. Mat",0.4,"*","Dos toilé classic",3]
["Affiche","A4","Recto","120gr. Mat",0.2,"*","Anneaux plast. Écolo.",3]
["Flyers","A5","Recto","200gr. Mat",0.25,"*","Anneaux plast.",4]
["Flyers","A6","Recto","250gr. Mat",0.15,"*","Anneaux Repro",5]
["Flyers","A5","Recto-Verso","200gr. Mat",0.3,"**","Cahier",0.5]
["Flyers","A6","Recto-Verso","250gr. Mat",0.2,"**","Dos-carré-collé",4]
["Flyers","A6","Recto-Verso","300gr. Mat",0.35,"**","Dos-carré-collé (> 50ex)",1]
["Carte de visite","85x55m","Recto","300gr. Mat",0.35,"*","Couv. Thèse/Mém.",6]
["Carte de visite","85x55m","Recto-Verso","300gr. Mat",0.35,"**"]
["Dépliant, 4p","A3 > A4","Recto-Verso","250gr. Mat",1.1499999999999999,"***"]
["Dépliant, 4p","A4 > A5","Recto-Verso","200(p) 250(o)",0.55000000000000004,"***"]
["Dépliant, 4p","A5 > A6","Recto-Verso","250gr. Mat",0.4,"***"]
["Dépliant, 6p, 3v.","A5","Recto-Verso","200gr. Mat",1.05,"****"]
["Dépliant, 3p, 6v.","A4 (99x210)","Recto-Verso","160gr. Mat",0.55000000000000004,"****"]
[]
["Posters | Grand format"]
["Format","Mat","Toile","La Repro imprimera avec 5mm de marges blanches dans les cas suivants:"]
["A2",4,10,"Délais serrés • Sujets allants trop proche du bord • Posters scientifiques • U4"]
["A1",8,20,"La Repro coupera vos posters francs-bords dans les cas suivants:"]
["A0",12,30,"Demandes internes UNIL • Délais raisonnables"]
["F4 (> 2ex. prix pce)",16,40]
["F4 (1ex., prix pce)",20,50,"Largeur maximum pour le mat et la toile: 1067mm",null,null,"Finitions et fournitures posters"]
["U4",24,60,"Longueur maximum de coupe pour la toile: 130cm",null,null,"Article","Prix"]
["Autre format","15,00 le m/lin.","35,00 le m/lin.","Longueur maximum de coupe pour le mat: 30m.",null,null,"Carton A4 / toile",5]
[]
["Papier suppléments feuilles + Achat",null,null,null,null,null,"Finitions"]
["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.05]
["200 SRA3",0.16,0.2,"-","-",null,"Rainage",0.05]
["250 SRA3",0.2,0.25,"-","-",null,"Rainage + Pliage",0.1]
["300 SRA3",0.24,0.3,"-",0.71,null,"Perforations",0.15]
["350 SRA3","-",0.35,"-","-",null,"Plastification A4",2]
["Rame A4 80gr",8,"-",15,"-",null,"Plastification A3",4]
["Carton A4 80gr",40,"-",75,"-",null,"Trous classeurs",2]
["Palette A4 80gr",1600,"-","-","-"]
["Rame A3 80gr",16,"-","-","-"]
["Carton A3 80gr",80,"-","-","-"]
[]
["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'!D17,'4.0'!O2,'BON DE COMMANDE REPRO'!F17)","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'!D18,'4.0'!O3,'BON DE COMMANDE REPRO'!F18)","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'!D19,'4.0'!O4,'BON DE COMMANDE REPRO'!F19)","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'!D20,'4.0'!O5,'BON DE COMMANDE REPRO'!F20)","v":"▼ ▼"}," "]
["-",null,null,null,"A7 - Couleur",0.05,null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D21,'4.0'!O6,'BON DE COMMANDE REPRO'!F21)","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'!D22,'4.0'!O7,'BON DE COMMANDE REPRO'!F22)","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":115,"n_cols":17,"rows_kept":115,"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$26,'5.0'!$I$2,'BON DE COMMANDE REPRO'!$D$26,'5.0'!$I$2,'BON DE COMMANDE REPRO'!$E$26,'5.0'!$I$2,'BON DE COMMANDE REPRO'!$F$26)","v":"▼ ▼ ▼ ▼"}," ",null,"Dos-carré-collé",50,1,null,"Coupe massicot",800,1]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!B27,'5.0'!I3,'BON DE COMMANDE REPRO'!D27,'5.0'!I3,'BON DE COMMANDE REPRO'!E27,'5.0'!I3,'BON DE COMMANDE REPRO'!F27)","v":"▼ ▼ ▼ ▼"}," "]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!B28,'5.0'!I4,'BON DE COMMANDE REPRO'!D28,'5.0'!I4,'BON DE COMMANDE REPRO'!E28,'5.0'!I4,'BON DE COMMANDE REPRO'!F28)","v":"▼ ▼ ▼ ▼"}," "]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!B29,'5.0'!I5,'BON DE COMMANDE REPRO'!D29,'5.0'!I5,'BON DE COMMANDE REPRO'!E29,'5.0'!I5,'BON DE COMMANDE REPRO'!F29)","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",2,null,null," "]
["SRA3 R Coul.",null,null,null,"Pliage / Rainage",0.05,null,null," "]
["SRA3 RV Coul.",null,null,null,"Rainage + Pliage",0.1,null,null," "]
[null,null,null,null,"Perforations",0.15,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 ▼ ▼",2,null,null," "]
["Rainage + Pliage",null,null,null,"▼ Pliage / Rainage ▼ ▼",0.05,null,null," "]
["Perforations",null,null,null,"▼ Rainage + Pliage ▼ ▼",0.1,null,null," "]
["Plastification A4",null,null,null,"▼ Perforations ▼ ▼",0.15,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. Vente",4,null,null," "]
["Pour menus déroulants Reliures",null,null,null,"Cahier",0.5,null,null," "]
["▼",null,null,null,"Dos-carré-collé",4,null,null," "]
["Dos toilé",null,null,null,"Dos-carré-collé (+50)",1,null,null," "]
["Dos toilé écolo",null,null,null,"▼ ▼ Dos toilé ▼",3]
["Dos-carré-collé",null,null,null,"▼ ▼ Anneaux plast. Vente ▼",4]
["Cahier",null,null,null,"▼ ▼ Cahier ▼",0.5]
["Couv. TM",null,null,null,"▼ ▼ Dos-carré-collé ▼",4]
["Anneaux plast. écolo",null,null,null,"▼ ▼ Dos-carré-collé (+50) ▼",1]
["Anneaux plast. Vente",null,null,null,"Mat 80",0.04]
["Anneaux plast. Repro",null,null,null,"Mat 120",0.08]
[null,null,null,null,"Mat 160",0.12]
[null,null,null,null,"Mat 200",0.16]
["Pour menus déroulants Services",null,null,null,"Mat 250",0.2]
["▼",null,null,null,"Mat 300",0.24]
["Prise en charge",null,null,null,"Satiné 90",0.05]
["Traitement / Prép.",null,null,null,"Satiné 120",0.1]
["Reprise",null,null,null,"Satiné 160",0.15]
["Conception Aff. / Fly.",null,null,null,"Satiné 200",0.2]
["Conception Dép.",null,null,null,"Satiné 250",0.25]
["Conception Rel.",null,null,null,"Satiné 300",0.3]
[null,null,null,null,"Rame A4 80gr",8]
[null,null,null,null,"Carton A4 80gr",40]
[null,null,null,null,"Palette A4 80gr",1600]
[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",8]
["Satiné 120",null,null,null,"▼ ▼ ▼ Carton A4 80gr",40]
["Satiné 160",null,null,null,"▼ ▼ ▼ Palette A4 80gr",1600]
["Satiné 200",null,null,null,"▼ ▼ ▼ Autre",0]
["Satiné 250",null,null,null,"▼ ▼ ▼ ▼",0]
["Satiné 300"]
["Satiné 350"]
["-",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",16]
["-",null,null,null,"Carton A3 80gr",80]
["Rame A3 80gr",null,null,null,"▼ ▼ ▼ Rame A3 80gr",16]
["Carton A3 80gr",null,null,null,"▼ ▼ ▼ Carton A3 80gr",80]
["-",null,null,null,"Plastification A4",2]
["Couleur A4 80gr",null,null,null,"Plastification A3",4]
["Couleur A4 160gr",null,null,null,"▼ Plastification A4 ▼ ▼",2]
["Couleur A3 160gr",null,null,null,"▼ Plastification A3 ▼ ▼",4]
["-",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 Plast. Repro",5]
[null,null,null,null,"▼ ▼ Anneaux Plast. Repro ▼",5]
[]
[null,null,null,null,"Couv. TM",6]
[null,null,null,null,"▼ ▼ Couv. TM ▼",6]
[]
[null,null,null,null,"Dos toilé écolo",2]
[null,null,null,null,"▼ ▼ Dos toilé écolo ▼",2]
[]
[null,null,null,null,"Anneaux plast. écolo",3]
[null,null,null,null,"▼ ▼ Anneaux plast. écolo ▼",3]

{"sheet":"6.0","index":5,"n_rows":29,"n_cols":11,"rows_kept":29,"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,null,null,null,null,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D33,'6.0'!K2,'BON DE COMMANDE REPRO'!E33)","v":"▼ ▼"}," "]
["▼",null,"▼",null,null,null,"A2 mat",4,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D34,'6.0'!K3,'BON DE COMMANDE REPRO'!E34)","v":"▼ ▼"}," "]
["A2",null,"mat",null,null,null,"A1 mat",8,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D35,'6.0'!K4,'BON DE COMMANDE REPRO'!E35)","v":"▼ ▼"}," "]
["A1",null,"toile",null,null,null,"A0 mat",12,null,{"$f":"CONCATENATE('BON DE COMMANDE REPRO'!D36,'6.0'!K5,'BON DE COMMANDE REPRO'!E36)","v":"▼ ▼"}," "]
["A0",null,null,null,null,null,"F4 (pour 1 ex.) mat",20,null,null," "]
["F4 (pour 1 ex.)",null,null,null,null,null,"F4 (dès 2 ex.) mat",16,null,null," "]
["F4 (dès 2 ex.)",null,null,null,null,null,"U4 mat",24,null,null," "]
["U4",null,null,null,null,null,null,null,null,null," "]
["Autre",null,null,null,null,null,"A2 toile",10,null,null," "]
["-",null,null,null,null,null,"A1 toile",20,null,null," "]
["Carton A4 / toile",null,null,null,null,null,"A0 toile",30,null,null," "]
["",null,null,null,null,null,"F4 (pour 1 ex.) toile",50,null,null," "]
[null,null,null,null,null,null,"F4 (dès 2 ex.) toile",40,null,null," "]
[null,null,null,null,null,null,"U4 toile",60,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Carton A4 / toile ▼ ▼",5,null,null," "]
[null,null,null,null,null,null,"▼ ▼",0,null,null," "]
[null,null,null,null,null,null,"▼",0,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"8.0","index":6,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Pour menus déroulants Format",null,"Matrice des Prix"]
["Sélectionner ici:"]
["▼",null,"▼",0]
["Affiche A3 - R.",null,"Affiche A3 - R.",0.4]
["Affiche A3 - R+V",null,"Affiche A3 - R+V",0.5]
["-",null,"-"]
["Affiche A4 - R.",null,"Affiche A4 - R.",0.2]
["Affiche A4 - R+V",null,"Affiche A4 - R+V",0.25]
["-",null,"-"]
["Flyers A5 - R",null,"Flyers A5 - R",0.25]
["Flyers A5 - R+V",null,"Flyers A5 - R+V",0.3]
["-",null,"-"]
["Flyers A6 - R",null,"Flyers A6 - R",0.15]
["Flyers A6 - R+V",null,"Flyers A6 - R+V",0.2]
["-",null,"-"]
["Carte de visite - R",null,"Carte de visite - R",0.35]
["Carte de visite - R+V",null,"Carte de visite - R+V",0.4]
["-",null,"-"]
["Dépliant A3/A4, 4p, 2v.",null,"Dépliant A3/A4, 4p, 2v.",1.1499999999999999]
["Dépliant A4/A5, 4p, 2v.",null,"Dépliant A4/A5, 4p, 2v.",0.55000000000000004]
["Dépliant A5/A6, 4p, 2v.",null,"Dépliant A5/A6, 4p, 2v.",0.4]
["-",null,"-"]
["Dépliant A5, P, 6p, 3v.",null,"Dépliant A5, P, 6p, 3v.",1.05]
["Dépliant A4 (99x210), 6p, 3v.",null,"Dépliant A4 (99x210), 6p, 3v.",0.55000000000000004]
["-",null,"-"]
["Prise en charge 1 face",null,"Prise en charge 1 face",1]
["Prise en charge 2 faces",null,"Prise en charge 2 faces",2]
["Prise en charge 4 faces",null,"Prise en charge 4 faces",3]
["Prise en charge 6 faces",null,"Prise en charge 6 faces",4]