{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CLIENT","zanzibarwatersport2020","Tarifs2020"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"CLIENT","index":0,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[[20,3,20,5],[22,3,22,5],[22,7,22,9],[23,3,23,5],[24,3,24,5],[38,9,38,10],[39,7,39,8],[36,3,36,7],[25,3,25,7],[26,2,26,4],[31,3,31,5],[32,3,32,5],[33,3,33,5],[0,0,0,11],[11,1,11,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[19,9,19,10],[35,0,40,1],[38,3,38,4],[38,6,38,7],[39,3,39,5],[40,3,40,7],[35,3,35,7],[37,3,37,8],[16,0,25,1],[17,3,17,7],[19,3,19,4],[19,6,19,7],[21,3,21,5],[18,3,18,8],[21,7,21,8],[16,3,16,7]]}
[" BON DE COMMANDE ZANZIBAR GLISSE 2020"]
["ZANZIBAR PRODUCTION                                                                                                                                              "]
["ZA Maignon, 2 route de Pitoys"]
["64600 ANGLET "]
["T/ 05.59.23.19.33"]
["info@zanzibar.fr"]
[]
["Agent : "]
["Type de règlement : "]
["Date commande : "]
["Date livraison souhaitée :"]
["N° cde client : "]
[]
[]
[]
["Client :"]
["Facturation",null,"Société : "]
[null,null,"Client :"]
[null,null,"Adresse :                                                                                  "]
[null,null,"CP : ",null,null,"Ville : ",null,null,"Pays :"]
[null,null,"N° Tva intracom :"]
[null,null,"Tel :                                                                            ",null,null,null,"Port :"]
[null,null,"Siret :",null,null,null,"APE :"]
[null,null,"Site Web :"]
[null,null,"Contact :"]
[null,null,"Mail : "]
[null,null,"Banque (joindre un RIB) :"]
[]
[null,null,"Code Banque","Code Guichet","Numéro de compte ","Clé RIB","Domiciliation"]
[]
[]
[null,null,"IBAN :"]
[null,null,"BIC : "]
[null,null,"Titulaire :"]
[]
["Livraison",null,"Société : "]
[null,null,"Client :"]
[null,null,"Adresse :                                                                                  "]
[null,null,"CP : ",null,null,"Ville : ",null,null,"Pays :"]
[null,null,"Tel :                                                                            ",null,null,null,"Port : "]
[null,null,"Mail : "]
[]
["POLITIQUE COMMERCIALE "]
["1. Franco de port : à partir de 1500€ de commande ",null,null,null,null,"2. Réassort possible à partir d'un minimum de 100 pièces "]
["Si commande inférieur à 1500€, forfait port de 25€ HT",null,null,null,null,"3. Quantités minimum pour commander : pour le textile minimum   "]
[null,null,null,null,null,"5 pièces à la taille et pour les accessoires minimum 10 pièces"]
[]
["CONDITIONS GENERALES DE VENTE ET DE LIVRAISON"]
["1. Toute livraison est soumise à l'acceptation express des présentes conditions de vente.",null,null,null,null,"9. Toute somme non payée à l'échéance porte droit à une pénalité de retard "]
["2. Les marchandises ne sont ni reprises ni échangées, sauf en cas d'articles défectueux.",null,null,null,null,"équivalente à 1,5 fois le taux d'interêt légal, en application de la loi du 31.12.92."]
["3. Les réclamations concernant la qualité de la marchandise, à l'exclusion de tout litige de                                                          ",null,null,null,null,"10. En cas de prorogation des traites, les frais et interêts résultant de cette "]
["transport, devront être formulées par écrit et dans les 4 jours à partir de la livraison.",null,null,null,null,"prorogation seront à la charge de l'acheteur."]
["4. Délais de livraison: 4 à 5 semaines après validation de la commande.",null,null,null,null,"11. En cas de contestation, le tribunal de Bayonne sera seul compétent."]
["5. Toute commande prise ne pourra être annulée. Le délai de désistement est de 7 jours à ",null,null,null,null,"12. Lorsque le crédit de l'acheteur se déteriore, nous nous réservons le droit, "]
["compter du jour de la prise de commande. La société ZANZIBAR PRODUCTIONse réserve ",null,null,null,null,"même après expédition partielle d'une commande, d'exiger de l'acheteur  "]
["le droit d'éxiger une compensation financière de 50 % minimum du total de la commande.",null,null,null,null,"garanties que nous jugeons convenables en vue de la bonne exécution des "]
["6. Facturation et règlement:",null,null,null,null,"engagements pris. Le refus d'y satisfaire nous donne le droit d'annuler tout "]
["Nos factures sont payables à Anglet, quel que soit le mode d'expédition ou de règlement.",null,null,null,null,"ou partit du marché."]
["Règlement: si SFAC, 30 jours fin de mois (LCR ou chèque); ",null,null,null,null,"13. En cas de non-paiement, le vendeur pourra résilier la vente de plein droit et  "]
["sinon chèque à la commande, encaissable à 30 jours à partir de la livraison.",null,null,null,null,"sans sommation par l'envoid'une simple lettre recommandée."]
["7. Sauf convention express, le retard dans les délais de livraison ne peut donner lieu à ",null,null,null,null,"14. Clause de réserve de propriété : Par application de la loi 80.335 du 21 mai 1980, "]
["une indemnité, et notamment dans les cas suivants:",null,null,null,null,"les marchandises demeurent la propriété du vendeur jusqu'à complet "]
["Les conditions de paiement n'ont pas été observées,",null,null,null,null,"encaissement de leurs prix, d'où transferts des risques et de la charge des"]
["Force majeure ou évènement propre à retarder ou à suspendre la livraison des marchandises.",null,null,null,null," assurances s'opérant dès que les marchandises ont quittées les dépôts du"]
["8. Le client aura toute faculté de réceptionner au moment de la livraison. Il lui appartient à ",null,null,null,null," vendeur."]
["ce moment dès signature du bon de réception, et après contrôle d'en prendre ",null,null,null,null,"15. Le non-paiement d'une seule facture à son échéance rend exigible de plein "]
["l'entière responsabilité.",null,null,null,null,"droit le solde dû sur toutes les autres factures."]

{"sheet":"zanzibarwatersport2020","index":1,"n_rows":102,"n_cols":13,"rows_kept":102,"cut":false,"hidden":false,"merged":[[24,1,25,1],[95,0,95,5],[50,0,50,2],[10,13,10,14],[93,0,93,5],[79,4,79,9],[88,6,88,12],[64,12,76,12],[24,12,27,12],[62,0,62,2],[76,0,76,2],[65,0,69,0],[70,0,72,0],[20,1,21,1],[89,0,89,5],[90,0,90,5],[46,12,49,12],[31,12,38,12],[89,6,89,12],[94,6,94,12],[94,0,94,5],[85,0,85,5],[81,4,81,9],[80,8,80,9],[84,6,84,12],[80,4,80,6],[84,0,84,5],[87,0,87,5],[87,6,87,12],[88,0,88,5],[52,12,60,12],[0,0,0,12],[29,0,29,2],[41,12,43,12],[44,0,44,2],[39,0,39,2],[6,2,9,2],[5,0,5,12],[22,0,22,2],[11,12,21,12],[6,0,9,0],[6,12,9,12],[6,3,9,3],[1,0,1,12],[6,10,9,10],[6,11,9,11],[3,1,3,12],[2,0,2,12],[4,1,4,12],[6,1,9,1],[6,4,6,9],[20,0,21,0],[26,1,27,1],[65,1,69,1],[102,0,104,12],[101,6,101,12],[100,6,100,12],[93,6,93,12],[86,0,86,5],[99,0,99,5],[100,0,100,5],[101,0,101,5],[98,0,98,5],[92,0,92,5],[97,0,97,5],[86,6,86,12],[96,0,96,5],[91,0,91,5]]}
[" BON DE COMMANDE ZANZIBAR GLISSE 2020"]
["https://www.zanzibar.fr/catalogues/"]
["Tarif Euros HT, valider après étude du visuel, et confirmation de commande Zanzibar. Tarif indicatif, transport idem, hors frais fixes"]
["COMMENTAIRE INTERNE"]
["COMMENTAIRE EXTERNE"]
[]
["Désignation","Références","Coloris","PU €","Tailles",null,null,null,null,null,"Qté Totales","Prix Total €","PV conseillé"]
[null,null,null,null,"XS","S","M","L","XL","XXL"]
[null,null,null,null,4,6,8,10,12,14]
[null,null,null,null,"TU","T1",null,"T2"]
["LYCRA"]
["Manches courtes","#W001","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K12,Tarifs2020!D$6:I$39,2)),0,HLOOKUP(K12,Tarifs2020!D$6:I$39,2))","v":0},null,null,null,null,null,null,{"$f":"SUM(E12:J12)","v":0},{"$f":"D12*K12","v":0}]
["Manches courtes + option Kite","#W002","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K13,Tarifs2020!D$6:I$39,3)),0,HLOOKUP(K13,Tarifs2020!D$6:I$39,3))","v":0},null,null,null,null,null,null,{"$f":"SUM(E13:J13)","v":0},{"$f":"D13*K13","v":0}]
["Manches courtes matière recyclée","#W001-1","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K14,Tarifs2020!D$6:I$51,36)),0,HLOOKUP(K14,Tarifs2020!D$6:I$51,36))","v":0},null,null,null,null,null,null,{"$f":"SUM(E14:J14)","v":0},{"$f":"D14*K14","v":0}]
["Manches courtes matière recyclée + option Kite","#W002-1","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K15,Tarifs2020!D$6:I$51,37)),0,HLOOKUP(K15,Tarifs2020!D$6:I$51,37))","v":0},null,null,null,null,null,null,0,0]
["Manches longues","#W003","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K16,Tarifs2020!D$6:I$39,4)),0,HLOOKUP(K16,Tarifs2020!D$6:I$39,4))","v":0},null,null,null,null,null,null,{"$f":"SUM(E16:J16)","v":0},{"$f":"D16*K16","v":0}]
["Manches longues + option Kite","#W004","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K17,Tarifs2020!D$6:I$39,5)),0,HLOOKUP(K17,Tarifs2020!D$6:I$39,5))","v":0},null,null,null,null,null,null,0,0]
["Manches longues polaire",null,"100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K18,Tarifs2020!D$6:I$60,48)),0,HLOOKUP(K18,Tarifs2020!D$6:I$60,48))","v":0},null,null,null,null,null,null,{"$f":"SUM(E18:J18)","v":0},{"$f":"D18*K18","v":0}]
["Brassière \"sauvetage\" ou \"école\"","#W005","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K19,Tarifs2020!D$6:I$39,6)),0,HLOOKUP(K19,Tarifs2020!D$6:I$39,6))","v":0},null,null,null,null,null,null,0,{"$f":"D19*K19","v":0}]
["Brassière \"sauvetage\" ou \"école\" + Option Kite","#W006","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K20,Tarifs2020!D$6:I$39,7)),0,HLOOKUP(K20,Tarifs2020!D$6:I$39,7))","v":0},null,null,null,null,null,null,0,0]
["Chasuble multisport numérotable","#W008","Sans numérotation",{"$f":"IF(ISNA(HLOOKUP(K21,Tarifs2020!D$6:I$39,9)),0,HLOOKUP(K21,Tarifs2020!D$6:I$39,9))","v":0},null,null,null,null,null,null,0,{"$f":"D21*K21","v":0}]
[null,null,"Avec numérotation",{"$f":"IF(ISNA(HLOOKUP(K22,Tarifs2020!D$6:I$39,10)),0,HLOOKUP(K22,Tarifs2020!D$6:I$39,10))","v":0},null,null,null,null,null,null,0,0]
["L'ensemble des produits sont personnalisables avec nom et numérotation - sur devis",null,null,"TOTAL",{"$f":"SUM(E12:E22)","v":0},0,0,0,0,0,{"$f":"SUM(K12:K22)","v":0},{"$f":"SUM(L12:L22)","v":0}]
["SUR STOCK"]
["Lycra","#W009",null,{"$f":"IF(ISNA(HLOOKUP(K25,Tarifs2020!D$6:I$39,11)),0,HLOOKUP(K25,Tarifs2020!D$6:I$39,11))","v":0},null,null,null,null,null,null,{"$f":"SUM(E25:J25)","v":0},{"$f":"+D25*K25","v":0}]
["Lycra + Marquage 1 couleur",null,null,{"$f":"IF(ISNA(HLOOKUP(K26,Tarifs2020!D$6:I$39,12)),0,HLOOKUP(K26,Tarifs2020!D$6:I$39,12))","v":0},null,null,null,null,null,null,{"$f":"SUM(E26:J26)","v":0},0]
["Chasuble","#W010",null,{"$f":"IF(ISNA(HLOOKUP(K27,Tarifs2020!D$6:I$39,14)),0,HLOOKUP(K27,Tarifs2020!D$6:I$39,14))","v":0},null,null,null,null,null,null,0,0]
["Chasuble + Marquage 1 couleur",null,null,{"$f":"IF(ISNA(HLOOKUP(K28,Tarifs2020!D$6:I$39,15)),0,HLOOKUP(K28,Tarifs2020!D$6:I$39,15))","v":0},null,null,null,null,null,null,0,0]
["Chasuble stretch ","#W024","100% impression sans limitation de couleurs",{"$f":"IF(ISNA(HLOOKUP(K29,Tarifs2020!D$6:I$51,38)),0,HLOOKUP(K29,Tarifs2020!D$6:I$51,38))","v":0},null,null,null,null,null,null,{"$f":"SUM(E29:J29)","v":0},{"$f":"+D29*K29","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E25:E28)","v":0},0,0,0,0,0,{"$f":"SUM(K25:K29)","v":0},{"$f":"SUM(L25:L29)","v":0}]
["SERVIETTES"]
["Serviette de plage 100x180 cm","#142",null,{"$f":"IF(ISNA(HLOOKUP(K32,Tarifs2020!D$6:I$39,17)),0,HLOOKUP(K32,Tarifs2020!D$6:I$39,17))","v":0},null,null,null,null,null,null,{"$f":"SUM(E32:E32)","v":0},{"$f":"D32*K32","v":0}]
["Serviette de bain 70x140 cm","#140",null,{"$f":"IF(ISNA(HLOOKUP(K33,Tarifs2020!D$6:I$39,18)),0,HLOOKUP(K33,Tarifs2020!D$6:I$39,18))","v":0},null,null,null,null,null,null,{"$f":"SUM(E33:E33)","v":0},{"$f":"D33*K33","v":0}]
["Serviette de bain 50x100 cm","#141",null,{"$f":"IF(ISNA(HLOOKUP(K34,Tarifs2020!D$6:I$51,39)),0,HLOOKUP(K34,Tarifs2020!D$6:I$51,39))","v":0},null,null,null,null,null,null,{"$f":"SUM(E34:E34)","v":0},{"$f":"D34*K34","v":0}]
["Serviette de bain Modèle rond (diamètre 150 cm)","#144",null,{"$f":"IF(ISNA(HLOOKUP(K35,Tarifs2020!D$6:I$51,40)),0,HLOOKUP(K35,Tarifs2020!D$6:I$51,40))","v":0},null,null,null,null,null,null,0,0]
["Poncho polyester poche cœur","#W011",null,{"$f":"IF(ISNA(HLOOKUP(K36,Tarifs2020!D$6:I$40,35)),0,HLOOKUP(K36,Tarifs2020!D$6:I$40,35))","v":0},null,null,null,null,null,null,0,0]
["Poncho coton + poche avant","#W012",null,{"$f":"IF(ISNA(HLOOKUP(K37,Tarifs2020!D$6:I$39,20)),0,HLOOKUP(K37,Tarifs2020!D$6:I$39,20))","v":0},null,null,null,null,null,null,{"$f":"SUM(E37:E37)","v":0},{"$f":"D37*K37","v":0}]
["Poncho coton + Capuche ","#W013",null,{"$f":"IF(ISNA(HLOOKUP(K38,Tarifs2020!D$6:I$39,20)),0,HLOOKUP(K38,Tarifs2020!D$6:I$39,20))","v":0},null,null,null,null,null,null,{"$f":"SUM(E38:E38)","v":0},{"$f":"D38*K38","v":0}]
["Poncho coton + Capuche + Poche avant","#W014",null,{"$f":"IF(ISNA(HLOOKUP(K39,Tarifs2020!D$6:I$39,21)),0,HLOOKUP(K39,Tarifs2020!D$6:I$39,21))","v":0},null,null,null,null,null,null,0,0]
[null,null,null,"TOTAL",{"$f":"SUM(E32:E39)","v":0},null,null,null,null,null,{"$f":"SUM(K32:K39)","v":0},{"$f":"SUM(L32:L39)","v":0}]
["BAIN"]
["Boardshort","#W015",null,{"$f":"IF(ISNA(HLOOKUP(K42,Tarifs2020!D$6:I$39,22)),0,HLOOKUP(K42,Tarifs2020!D$6:I$39,22))","v":0},null,null,null,null,null,null,{"$f":"SUM(E42:J42)","v":0},{"$f":"+D42*K42","v":0}]
["Boxer de bain Homme","#075",null,{"$f":"IF(ISNA(HLOOKUP(K43,Tarifs2020!D$6:I$39,23)),0,HLOOKUP(K43,Tarifs2020!D$6:I$39,23))","v":0},null,null,null,null,null,null,{"$f":"SUM(E43:J43)","v":0},{"$f":"+D43*K43","v":0}]
["Bonnet de sauvetage","#W016",null,{"$f":"IF(ISNA(HLOOKUP(K44,Tarifs2020!D$6:I$39,25)),0,HLOOKUP(K44,Tarifs2020!D$6:I$39,25))","v":0},null,null,null,null,null,null,0,0]
[null,null,null,"TOTAL",{"$f":"SUM(E42:E44)","v":0},0,0,0,0,0,{"$f":"SUM(K42:K44)","v":0},{"$f":"SUM(L42:L44)","v":0}]
["UNDERWEAR"]
["Boxer Homme","#022",null,{"$f":"IF(ISNA(HLOOKUP(K47,Tarifs2020!D$6:I$39,26)),0,HLOOKUP(K47,Tarifs2020!D$6:I$39,26))","v":0},null,null,null,null,null,null,{"$f":"SUM(E47:J47)","v":0},{"$f":"+D47*K47","v":0}]
["Boxer Femme","#025",null,{"$f":"IF(ISNA(HLOOKUP(K48,Tarifs2020!D$6:I$39,27)),0,HLOOKUP(K48,Tarifs2020!D$6:I$39,27))","v":0},null,null,null,null,null,null,{"$f":"SUM(E48:J48)","v":0},{"$f":"+D48*K48","v":0}]
["Boxer coton","#020","Noir",{"$f":"IF(ISNA(HLOOKUP(K49,Tarifs2020!D$6:I$51,41)),0,HLOOKUP(K49,Tarifs2020!D$6:I$51,41))","v":0},null,null,null,null,null,null,{"$f":"SUM(E49:J49)","v":0},{"$f":"+D49*K49","v":0}]
["Boxer coton","#020","Gris",{"$f":"IF(ISNA(HLOOKUP(K50,Tarifs2020!D$6:I$51,41)),0,HLOOKUP(K50,Tarifs2020!D$6:I$51,41))","v":0},null,null,null,null,null,null,0,0]
[null,null,null,"TOTAL",{"$f":"SUM(E47:E50)","v":0},null,null,null,null,null,{"$f":"SUM(K47:K50)","v":0},{"$f":"SUM(L47:L50)","v":0}]
["ACCESSOIRES - MARCHANDISING"]
["Chaussettes","#110",null,{"$f":"IF(ISNA(HLOOKUP(K53,Tarifs2020!D$6:I$39,31)),0,HLOOKUP(K53,Tarifs2020!D$6:I$39,31))","v":0},null,null,null,null,null,null,{"$f":"SUM(E53:F53)","v":0},{"$f":"D53*K53","v":0}]
["Ceinture","#131",null,{"$f":"IF(ISNA(HLOOKUP(K54,Tarifs2020!D$6:I$39,32)),0,HLOOKUP(K54,Tarifs2020!D$6:I$39,32))","v":0},null,null,null,null,null,null,{"$f":"SUM(E54:E54)","v":0},{"$f":"D54*K54","v":0}]
["Mug céramique","#090",null,{"$f":"IF(ISNA(HLOOKUP(K55,Tarifs2020!D$6:I$39,33)),0,HLOOKUP(K55,Tarifs2020!D$6:I$39,33))","v":0},null,null,null,null,null,null,0,0]
["Lanyard 20 cm","#122",null,{"$f":"IF(ISNA(HLOOKUP(K56,Tarifs2020!D$6:I$51,42)),0,HLOOKUP(K56,Tarifs2020!D$6:I$51,42))","v":0},null,null,null,null,null,null,{"$f":"SUM(E56:E56)","v":0},{"$f":"D56*K56","v":0}]
["Lanyard 40 cm","#123",null,{"$f":"IF(ISNA(HLOOKUP(K57,Tarifs2020!D$6:I$51,43)),0,HLOOKUP(K57,Tarifs2020!D$6:I$51,43))","v":0},null,null,null,null,null,null,0,0]
["Pochette étanche","#W024",null,{"$f":"IF(ISNA(HLOOKUP(K58,Tarifs2020!D$6:I$51,44)),0,HLOOKUP(K58,Tarifs2020!D$6:I$51,44))","v":0},null,null,null,null,null,null,0,0]
["Pochette Armband ","#W026",null,{"$f":"IF(ISNA(HLOOKUP(K59,Tarifs2020!D$6:I$55,45)),0,HLOOKUP(K59,Tarifs2020!D$6:I$55,45))","v":0},null,null,null,null,null,null,{"$f":"SUM(E59:E59)","v":0},{"$f":"D59*K59","v":0}]
["Casquette Trucker + marquage  une couleur","#206","Autre possibilité de marquages nous contacter",{"$f":"IF(ISNA(HLOOKUP(K60,Tarifs2020!D$6:I$51,46)),0,HLOOKUP(K60,Tarifs2020!D$6:I$51,46))","v":0},null,null,null,null,null,null,{"$f":"SUM(E60:E60)","v":0},{"$f":"D60*K60","v":0}]
["Tour de cou 1",null,null,{"$f":"IF(ISNA(HLOOKUP(K61,Tarifs2020!D$6:I$60,47)),0,HLOOKUP(K61,Tarifs2020!D$6:I$60,47))","v":0},null,null,null,null,null,null,{"$f":"SUM(E61:E61)","v":0},{"$f":"D61*K61","v":0}]
["Gourde Aluminium",null,null,{"$f":"IF(ISNA(HLOOKUP(K62,Tarifs2020!D$6:I$60,49)),0,HLOOKUP(K62,Tarifs2020!D$6:I$60,49))","v":0},null,null,null,null,null,null,{"$f":"SUM(E62:E62)","v":0},{"$f":"D62*K62","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E53:E55)","v":0},{"$f":"SUM(F53)","v":0},null,null,null,null,{"$f":"SUM(K53:K62)","v":0},{"$f":"SUM(L53:L62)","v":0}]
["SIGNALETIQUE EVENEMENTIELLE"]
["Drapeau + Œillets + Sangle coté","Attention tarif indicatif","Au mètre carré (remplir surface H*L en M dans la case bleuté) * quantité de drapeaux souhaités",{"$f":"IF(ISNA(HLOOKUP(K65,Tarifs2020!P$3:U$4,2)),0,HLOOKUP(K65,Tarifs2020!P$3:U$4,2))","v":0},null,null,null,null,null,null,{"$f":"SUM(E65:E65)","v":0},{"$f":"D65*K65","v":0}]
["Windflag (Voile + Mats)","#W017","2,3 m ",{"$f":"IF(ISNA(HLOOKUP(K66,Tarifs2020!P$6:T$17,3)),0,HLOOKUP(K66,Tarifs2020!P$6:T$17,3))","v":0},null,null,null,null,null,null,0,{"$f":"D66*K66","v":0}]
[null,null,"3,5 m",{"$f":"IF(ISNA(HLOOKUP(K67,Tarifs2020!P$6:T$17,4)),0,HLOOKUP(K67,Tarifs2020!P$6:T$17,4))","v":0},null,null,null,null,null,null,0,0]
[null,null,"3,5 m eco",{"$f":"IF(ISNA(HLOOKUP(K68,Tarifs2020!P$6:T$17,5)),0,HLOOKUP(K68,Tarifs2020!P$6:T$17,5))","v":0},null,null,null,null,null,null,0,0]
[null,null,"4,8 m",{"$f":"IF(ISNA(HLOOKUP(K69,Tarifs2020!P$6:T$17,6)),0,HLOOKUP(K69,Tarifs2020!P$6:T$17,6))","v":0},null,null,null,null,null,null,0,0]
[null,null,"4,8 m eco",{"$f":"IF(ISNA(HLOOKUP(K70,Tarifs2020!P$6:T$17,7)),0,HLOOKUP(K70,Tarifs2020!P$6:T$17,7))","v":0},null,null,null,null,null,null,0,0]
["Pieds","#W018","Forant",{"$f":"Tarifs2020!P21","v":18},null,null,null,null,null,null,0,0]
[null,"#W019","Platine int + ext",{"$f":"Tarifs2020!P22","v":25.5},null,null,null,null,null,null,0,0]
[null,"#W020","Croisillon",{"$f":"Tarifs2020!P23","v":63},null,null,null,null,null,null,0,0]
["Transat","#W021",null,{"$f":"IF(ISNA(HLOOKUP(K74,Tarifs2020!P$6:T$17,9)),0,HLOOKUP(K74,Tarifs2020!P$6:T$17,9))","v":0},null,null,null,null,null,null,0,{"$f":"D74*K74","v":0}]
["Tente","#W022",null,{"$f":"IF(ISNA(HLOOKUP(K75,Tarifs2020!P$6:T$17,11)),0,HLOOKUP(K75,Tarifs2020!P$6:T$17,11))","v":0},null,null,null,null,null,null,0,0]
[null,"#W023","Mur 3x3",{"$f":"IF(ISNA(HLOOKUP(K76,Tarifs2020!P$6:T$17,12)),0,HLOOKUP(K76,Tarifs2020!P$6:T$17,12))","v":0},null,null,null,null,null,null,{"$f":"SUM(E76:E76)","v":0},{"$f":"D76*K76","v":0}]
[null,null,null,"TOTAL",{"$f":"SUM(E65:E75)","v":0},null,null,null,null,null,{"$f":"SUM(K65:K76)","v":0},{"$f":"SUM(L65:L76)","v":0}]
[]
[]
["POLITIQUE COMMERCIALE ",null,null,null,"TOTAL",null,null,null,null,null,{"$f":"K51+K23+K40+K45+K63+K30+K77","v":0},{"$f":"L51+L23+L40+L45+L30+L63+L77","v":0}]
["1. Franco de port : à partir de 1500€ de commande ",null,"Si commande inférieur à 1500€, forfait port de 25€ HT",null,"         PORT",null,null,25,null,null,{"$f":"IF(K80=0,0,1)","v":0},{"$f":"H81*K81","v":0}]
["2. Réassort possible à partir d'un minimum de 100 pièces ",null,null,null,"ARTICLES / TOTAL € HT",null,null,null,null,null,{"$f":"SUM(K80:K81)","v":0},{"$f":"SUM(L80:L81)","v":0}]
["3. Montant minimum de commande: 1000€ - pour le textile minimum 5 pièces à la taille/accessoires minimum 10 pièces"]
["4. Exclusivité : montant minimum de commande 2500€ - secteur à definir"]
["CONDITIONS GENERALES DE VENTE ET DE LIVRAISON",null,null,null,null,null,"9. Toute somme non payée à l'échéance porte droit à une pénalité de retard "]
["1. Toute livraison est soumise à l'acceptation express des présentes conditions de vente.",null,null,null,null,null,"équivalente à 1,5 fois le taux d'interêt légal, en application de la loi du 31.12.92."]
["2. Les marchandises ne sont ni reprises ni échangées, sauf en cas d'articles défectueux.",null,null,null,null,null,"10. En cas de prorogation des traites, les frais et interêts résultant de cette "]
["3. Les réclamations concernant la qualité de la marchandise, à l'exclusion de tout litige de                                                          ",null,null,null,null,null,"prorogation seront à la charge de l'acheteur."]
["transport, devront être formulées par écrit et dans les 4 jours à partir de la livraison.",null,null,null,null,null,"11. En cas de contestation, le tribunal de Bayonne sera seul compétent."]
["4. Délais de livraison: 4 à 5 semaines après validation de la commande.",null,null,null,null,null,"12. Lorsque le crédit de l'acheteur se déteriore, nous nous réservons le droit, "]
["5. Toute commande prise ne pourra être annulée. Le délai de désistement est de 7 jours à ",null,null,null,null,null,"même après expédition partielle d'une commande, d'exiger de l'acheteur  "]
["compter du jour de la prise de commande. La société ZANZIBAR PRODUCTIONse réserve ",null,null,null,null,null,"garanties que nous jugeons convenables en vue de la bonne exécution des "]
["le droit d'éxiger une compensation financière de 50 % minimum du total de la commande.",null,null,null,null,null,"engagements pris. Le refus d'y satisfaire nous donne le droit d'annuler tout "]
["6. Facturation et règlement:",null,null,null,null,null,"ou partit du marché."]
["Nos factures sont payables à Anglet, quel que soit le mode d'expédition ou de règlement.",null,null,null,null,null,"13. En cas de non-paiement, le vendeur pourra résilier la vente de plein droit et  "]
["Règlement: si SFAC, 30 jours fin de mois (LCR ou chèque); ",null,null,null,null,null,"sans sommation par l'envoid'une simple lettre recommandée."]
["sinon chèque à la commande, encaissable à 30 jours à partir de la livraison.",null,null,null,null,null,"14. Clause de réserve de propriété : Par application de la loi 80.335 du 21 mai 1980, "]
["7. Sauf convention express, le retard dans les délais de livraison ne peut donner lieu à une indemnité, et notamment dans les cas suivants:",null,null,null,null,null,"les marchandises demeurent la propriété du vendeur jusqu'à complet "]
["Les conditions de paiement n'ont pas été observées,",null,null,null,null,null,"encaissement de leurs prix, d'où transferts des risques et de la charge des"]
[" Force majeure ou évènement propre à retarder ou à suspendre la livraison des marchandises.",null,null,null,null,null," assurances s'opérant dès que les marchandises ont quittées les dépôts du vendeur,"]
["8. Le client aura toute faculté de réceptionner au moment de la livraison. Il lui appartient à ",null,null,null,null,null,"15. Le non-paiement d'une seule facture à son échéance rend exigible de plein "]
["ce moment dès signature du bon de réception, et après contrôle d'en prendre l'entière responsabilité.",null,null,null,null,null,"droit le solde dû sur toutes les autres factures."]

{"sheet":"Tarifs2020","index":2,"n_rows":54,"n_cols":21,"rows_kept":54,"cut":false,"hidden":false,"merged":[[51,0,51,1],[52,0,52,1],[53,0,53,1],[23,0,23,1],[2,12,2,13],[3,12,3,13],[15,12,15,13],[14,12,14,13],[5,12,5,13],[12,12,12,13],[13,12,13,13],[6,12,6,13],[33,0,33,1],[34,0,34,1],[31,0,31,1],[32,0,32,1],[1,0,1,6],[5,0,5,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[22,0,22,1],[26,0,26,1],[27,0,27,1],[6,0,6,1],[8,0,8,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[15,0,15,1],[18,0,18,1],[21,0,21,1],[35,0,35,1],[50,0,50,1],[36,0,36,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[40,0,40,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[39,0,39,1],[37,0,37,1],[38,0,38,1],[49,0,49,1]]}
[]
["Fiche Tarifs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inférieur à :","Inférieur à :","Inférieur à :","Inférieur à :","Inférieur à :","Supérieur à :"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nom du produit",null,"PRODUIT FINI (au m²)",5,10,25,50,100,101]
[null,null,null,null,null,null,null,null,null,null,null,"x","Drapeau",null,"Œillets + sangle coté",31.9,29.9,25.9,24.9,22.9,21.9]
[null,null,null,null,null,null,null,null,"Supérieur à :"]
["Nom du produit",null,"PRODUIT FINI ",10,50,100,250,500,501,null,null,null,"Nom du produit",null,"PRODUIT FINI ",1,5,10,25,50,"sur devis"]
["Lycra MC Subli",null,"Prix de vente",25.9,23.9,20.9,19.899999999999999,17.899999999999999,16.899999999999999,"x",null,null,"Windflag Voile + Mat"]
[null,null,"Option Kite",27.4,25.4,22.4,21.4,19.399999999999999,18.399999999999999,"x",null,"x",null,"2,3 m","Prix de vente",69,50,48,45,43]
["Lycra ML Subli",null,"Prix de vente",35.9,31.9,26.9,25.9,23.9,22.9,"x",null,"x",null,"3,5 m","Prix de vente",85,65,60,55,52]
[null,null,"Option Kite",37.4,33.4,28.4,27.4,25.4,24.4,"x",null,"x",null,"3,5 m éco","Prix de vente",80,60,55,50,47]
["Brassière Sauvetage",null,"Prix de vente",14.9,12.9,10.9,10.3,9.5,8.9,"x",null,"x",null,"4,8 m","Prix de vente",160,145,115,95,80]
[null,null,"Option Kite",16.399999999999999,14.4,12.4,11.8,11,9.4,"x",null,"x",null,"4,8 m éco","Prix de vente",155,140,110,90,75]
["Body Enfant",null,"Prix de vente",15,13.5,11.25,10.9,10.1,9.75,"x",null,null,"Manche à air",null,"Prix de vente"]
["Chasuble multisport",null,"Prix de vente",19.899999999999999,17.899999999999999,15.9,14.9,12.9,11.9,"x",null,"x","Transat",null,"Prix de vente",74.900000000000006,65.900000000000006,55.9,52.9,49.9]
[null,null,"Option Numérotation",21.4,19.399999999999999,17.399999999999999,16.399999999999999,14.4,13.4,"x",null,null,"Bouée",null,"Prix de vente"]
["Lycra promo",null,"Prix de vente",7.9,5.9,5.2,4.9000000000000004,4.5,4.2,"x",null,"x","Stand 3x3",null,"Prix de vente",1460,1250,985,920,"sur devis"]
[null,null,"Marquage 1 couleur",10.9,8.9,8.1999999999999993,7.9,7.5,7.2,"x",null,null,null,null,"MUR 3x3",570,510,425,415,385]
[null,null,"Marquage 2 couleur"]
["Chasuble promo",null,"Prix de vente",5,4.2,3,2.8,2.4,2.1,"x"]
[null,null,"Marquage 1 couleur",8,7.2,6,5.8,5.4,5.0999999999999996,"x",null,null,null,null,"PIEDS","PV"]
[null,null,"Marquage 2 couleur",null,null,null,null,null,null,null,null,null,null,null,"FORANT",18]
["Serviette 100x180",null,"Prix de vente",32.9,29.9,24.9,24.5,22.9,21.9,"x",null,null,null,null,"PLATINE INT + EXT",25.5]
["Serviette 70x140",null,"Prix de vente",17.899999999999999,15.9,12.9,12.5,11.9,11.596,"x",null,null,null,null,"CROISILLON",63]
["Poncho",null,"Prix de vente poncho seul",19.899999999999999,17.899999999999999,14.9,13.9,12.9,12.5,"x"]
[null,null,"Poncho + 1 Option",29.9,27.9,21.9,20.9,19.899999999999999,18.899999999999999,"x"]
[null,null,"Poncho + 2 Options",39.9,35.9,29.9,28.9,26.9,24.9,"x"]
["Boardshort",null,"Prix de vente",36.9,32.9,27.9,26.9,24.9,23.9,"x"]
["Boxer bain Homme",null,"Prix de vente",9.5,8.5,6.9,6.5,6.3,5.9,"x"]
["Maillot bain Femme",null,"Prix de vente",12.9,11.501999999999999,9.5,9.1999999999999993,8.5,8.1999999999999993,"x"]
["Bonnet de sauvetage",null,"Prix de vente",13.9,12.5,9.9,9.5,8.9,8.5,"x"]
["Boxer Homme",null,"Prix de vente",16.899999999999999,14.9,12.5,11.9,10.9,10.5,"x"]
["Boxer Femme",null,"Prix de vente",13.5,12.2,10.199999999999999,9.8000000000000007,9.1,8.8010000000000002,"x"]
["Culotte Femme",null,"Prix de vente",6.4,5.9,4.8000000000000007,4.5,4.3,4,"x"]
["Legging Femme",null,"Prix de vente",30.9,27.9,22.9,21.9,20.5,19.5,"x"]
["Brassière Femme",null,"Prix de vente",15.9,13.9,11.5,11,10.395000000000001,10,"x"]
["Chaussettes",null,"Prix de vente",7.1,6.5,5.5,5,4.7,4.5,"x"]
["Ceintures",null,"Prix de vente",5,4.5999999999999996,3.9,3.7,3.4,3.2,"x"]
["MUG",null,"Prix de vente",3.9,3.5,2.9463869999999996,2.8481740999999996,2.6517482999999999,2.5535353999999999,"x"]
["Sac Etanche",null,"Prix de vente"]
["Poncho poche subli",null,"Prix de vente",19.899999999999999,16.899999999999999,14.9,13.9,12.9,12.4,"x"]
["Lycra MC Subli Recyclé",null,"Prix de vente",26.9,24.9,21.9,20.9,18.899999999999999,17.899999999999999]
[null,null,"Option Kite",28.4,26.4,23.4,22.4,20.399999999999999,19.399999999999999]
["Chasuble Stretch",null,"Prix de vente",11.9,10.5,8.9,8.5,7.9,7.65]
["Serviette de bain 50x100 cm",null,"Prix de vente",16.5,14.9,12.5,11.9,11.2,10.9]
["Serviette de bain  rond (diam 150 cm)",null,"Prix de vente",24.6,21.9,18.899999999999999,17.899999999999999,16.899999999999999,16]
["Boxer Coton ",null,"Prix de vente",7.35,6.6,5.5,5.0999999999999996,4.9000000000000004,4.7]
["Lanyard 20 cm","Lanyard 20 cm","Prix de vente",2.2999999999999998,2,1.7,1.65,1.5,1.4]
["Lanyard 40 cm","Lanyard 40 cm","Prix de vente",3.1,2.8,2.2999999999999998,2.25,2.1,2]
["Pochette étanche","Pochette étanche","Prix de vente",4.95,4.45,3.75,3.6,3.35,3.2]
["Pochette Armband",null,"Prix de vente",12.8,11.5,9.6,9.25,8.65,8.5]
["Casquette","Casquette","Prix de vente",6.35,5.95,5.35,4.75,4.5,4.0999999999999996]
["Tour de cou ",null,"Prix de vente",null,3.54,3.42,3.18,3.07,2.95]
["Lycra polaire",null,"Prix de vente",29.9,27.9,24.9,23.9,21.9,20.9]
["Gourde Aluminium",null,"Prix de vente",null,7.9,6.5,6.2,5.9,5.55]