{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Feuil1","index":0,"n_rows":52,"n_cols":29,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,1,6,9],[8,19,8,21],[8,22,8,23],[29,17,29,19],[24,17,24,19],[28,17,28,19],[8,15,8,17],[19,16,19,17],[29,15,29,16],[24,15,24,16],[19,0,19,9],[16,0,16,9],[5,1,5,9],[0,0,0,12],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9]]}
["BON DE COMMANDE"]
["NOM"]
["Prénom"]
["Adresse"]
["Mail"]
["Téléphone"]
["Collectif"]
[]
["Produit","Genre","Taille","Couleur","Prix","Quantité","Flocage ","TOTAL","Reference Hummel","Couleur Hummel",null,null,null,null,null,"Prix",null,null,null,"Ref. HUMMEL",null,null,"Couleur",null,"Ref Couleur Humel"]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A10=\"Maillot entrainement\",NOT(ISBLANK(G10)),B10=\"Enfant\"),$R$18,IF(AND(A10=\"Maillot entrainement\",NOT(ISBLANK(G10))),$Q$18,IF(A10=\"Chaussettes\",VLOOKUP(A10,$O$26:$Q$27,MATCH(B10,$O$26:$Q$26,0)),IF(A10=\"Sac de sport\",VLOOKUP(A10,$O$28:$Q$29,MATCH(C10,$O$28:$Q$28,0)),IF(A10=\"Sac à dos\",$P$30,VLOOKUP(A10,$O$11:$R$20,MATCH(B10,$O$10:$R$10,0),0)))))),0)","v":0},null,null,{"$f":"E10*F10","v":0},{"$f":"IFERROR(IF(A10=\"Chaussettes\",VLOOKUP(A10,$R$26:$T$27,MATCH(B10,$R$26:$T$26,0)),IF(A10=\"Sac de sport\",$R$29,IF(A10=\"Sac à dos\",$R$30,VLOOKUP(A10,$S$11:$V$20,MATCH(B10,$S$10:$V$10,0),0)))),0)","v":0},{"$f":"IF(D10=$X$11,$Z$11,IF(D10=$W$11,$Y$11,IF(D10=$W$14,$Y$14,IF(D10=$W$18,$Y$18,))))","v":0},null,null,null,null,null,"Homme","Femme","Enfant",null,"Homme","Femme","Enfant"]
[null,null,null,null,0,null,null,{"$f":"E11*F11","v":0},0,{"$f":"IF(D11=$X$11,$Z$11,IF(D11=$W$11,$Y$11,IF(D11=$W$14,$Y$14,IF(D11=$W$18,$Y$18,))))","v":0},null,null,null,null,"Maillot sport",19,19,18,"Maillot sport",203566,203440,203567,"Blanc","Rouge",9001,3062]
[null,null,null,null,0,null,null,0,0,{"$f":"IF(D12=$X$11,$Z$11,IF(D12=$W$11,$Y$11,IF(D12=$W$14,$Y$14,IF(D12=$W$18,$Y$18,))))","v":0},null,null,null,null,"Polo",24,24,22,"Polo",203520,203522,203521,"Noir","Rouge",null,3062]
[null,null,null,null,0,null,null,0,0,0,null,null,null,null,"Maillot entrainement",19,19,17,"Maillot entrainement",211455,201457,211456,"Noir","Rouge",2001,3062]
[null,null,null,null,0,null,null,0,0,0,null,null,null,null,"Sweat",44,44,40,"Sweat",203508,203510,203509,"Noir","Rouge",2001,3062]
[null,null,null,null,0,null,null,0,0,0,null,null," ",null,"Veste echauffement",40,40,37,"Veste echauffement",211481,212653,212652,"Noir","Rouge",2001,3062]
[null,null,null,null,0,null,null,0,0,0,null,null,null,null,"Pantalon",35,35,32,"Pantalon",203530,204173,203521,"Noir",null,2001]
["Partie pour la commande de maillots match ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Short",14,14,12,"Short",211466,211468,211467,"Noir","Rouge",2001,3062]
[null,null,null,null,{"$f":"IF(ISBLANK(A18),0,60)","v":0},null,null,{"$f":"E18*F18","v":0},null,null,null,null,null,null,"Maillot entrainement + flocage",21,21,19,"Chaussettes",null,null,null,"Blanche/rouge",null,9402]
[null,null,null,null,{"$f":"IF(ISBLANK(A19),0,60)","v":0},null,null,{"$f":"E19*F19","v":0},null,null,null,null,null,null,"Sac de sport",null,null,null,"Sac de sport",null,null,null,"Noir",null,2001]
["Partie pour la commande de pack ci dessous ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sac à dos",null,null,null,"Sac à dos",null,null,null,"Noir","Rouge",2001,3062]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(A21,$O$21:$R$23,MATCH(B21,$O$10:$R$10,0),0),)","v":0},null,null,0,null,null,null,null,null,null,"Pack Essentiel",40,40,37]
[{"$f":"IF(OR($A$21=$Y$36,$A$21=$AA$36),Q36,IF($A$21=$Z$36,S36,\"\"))","v":""},{"$f":"IF(ISBLANK(A22),,$B$21)","v":0},null,null,null,{"$f":"IF(COUNTBLANK(A22)<1,1,)","v":0},null,0,{"$f":"IFERROR(IF(A22=\"Chaussettes\",VLOOKUP(A22,$R$26:$T$27,MATCH(B22,$R$26:$T$26,0)),IF(A22=\"Sac de sport\",$R$29,IF(A22=\"Sac à dos\",$R$30,VLOOKUP(A22,$S$11:$V$20,MATCH(B22,$S$10:$V$10,0),0)))),0)","v":0},0,null,null,null,null,"Pack Jour de match",74,74,69]
[{"$f":"IF(OR($A$21=$Y$36,$A$21=$AA$36),U36,IF($A$21=$Z$36,T36,\"\"))","v":""},{"$f":"IF(ISBLANK(A23),,$B$21)","v":0},null,null,null,{"$f":"IF(COUNTBLANK(A23)<1,1,)","v":0},null,0,0,0,null,null,null,null,"Pack Ultimate",147,147,137]
[{"$f":"IF(OR($A$21=$Y$36,$A$21=$AA$36),V36,\"\")","v":""},{"$f":"IF(A24=\"Chaussettes\",\"Low\",)","v":0},null,null,null,0,null,0,0,0]
[{"$f":"IF(OR($A$21=$AA$36),S36,\"\")","v":""},{"$f":"IF(OR($A$21=$AA$36),$B$21,)","v":0},null,null,null,0,null,{"$f":"E25*F25","v":0},0,{"$f":"IF(D25=$X$11,$Z$11,IF(D25=$W$11,$Y$11,IF(D25=$W$14,$Y$14,IF(D25=$W$18,$Y$18,))))","v":0},null,null,null,null,null,"Prix",null,"Ref. HUMMEL"]
[{"$f":"IF(OR($A$21=$AA$36),T36,\"\")","v":""},{"$f":"IF(OR($A$21=$AA$36),$B$21,)","v":0},null,null,null,0,null,0,0,0,null,null,null,null,null,"Low","High",null,"Low","High"]
[{"$f":"IF(OR($A$21=$AA$36),W36,\"\")","v":""},null,null,null,{"$f":"IF(C27=T28,4,)","v":0},0,null,{"$f":"E27*F27","v":0},0,0,null,null,null,null,"Chaussettes",7,10,"Chaussettes",204043,204044]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:H27)","v":0},null,null,null,null,null,null,null,"45 L","69 L",null,"45 L","69 L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sac de sport",34,38,204012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sac à dos",30,null,205881]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maillot sport","Polo","Maillot entrainement","Sweat","Veste echauffement","Pantalon","Short","Chaussettes","Sac de sport","Sac à dos","Pack Essentiel","Pack Jour de match","Pack Ultimate","Domicile","Away"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homme","Homme","Homme","Homme","Homme","Homme","Homme","Low","Unisexe","Unisexe","Homme","Homme","Homme","Homme","Homme"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Femme","Femme","Femme","Femme","Femme","Femme","Femme","High","Unisexe","Unisexe","Femme","Femme","Femme","Femme","Femme"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enfant","Enfant","Enfant","Enfant","Enfant","Enfant","Enfant","High","Unisexe","Unisexe","Enfant","Enfant","Enfant","Enfant","Enfant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homme","Femme ","Enfant",null,"Chaussettes_S","Sac de sport_S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","XS",116,null,"27-30","45 L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","S",128,null,"31-34","69 L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L","M",140,null,"35-38"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XL","L",152,null,"39-42"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2XL","XL",164,null,"43-45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3XL","2XL",176,null,"46-48"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4XL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maillot sport C","Polo C","Maillot entrainement C","Sweat C","Veste echauffement C","Pantalon C","Short C","Chaussettes C","Sac de sport C","Sac à dos C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blanc","Noir","Noir","Noir","Noir","Noir","Noir","Blanche/rouge","Noir","Noir"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rouge","Rouge","Rouge","Rouge","Rouge",null,"Rouge",null,null,"Rouge"]