{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":28,"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":28,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,1,6,9],[8,20,8,22],[8,23,8,24],[29,18,29,20],[24,18,24,20],[28,18,28,20],[8,16,8,18],[19,17,19,18],[29,16,29,17],[24,16,24,17],[16,0,16,9],[5,1,5,9],[0,0,0,13],[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,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\"),$S$18,IF(AND(A10=\"Maillot entrainement\",NOT(ISBLANK(G10))),$R$18,IF(A10=\"Chaussettes\",VLOOKUP(A10,$P$26:$R$27,MATCH(B10,$P$26:$R$26,0)),IF(A10=\"Sac de sport\",VLOOKUP(A10,$P$28:$R$29,MATCH(C10,$P$28:$R$28,0)),IF(A10=\"Sac à dos\",$Q$30,VLOOKUP(A10,$P$11:$S$20,MATCH(B10,$P$10:$S$10,0),0)))))),0)","v":0},null,null,{"$f":"E10*F10","v":0},{"$f":"IFERROR(IF(A10=\"Chaussettes\",VLOOKUP(A10,$S$26:$U$27,MATCH(B10,$S$26:$U$26,0)),IF(A10=\"Sac de sport\",$S$29,IF(A10=\"Sac à dos\",$S$30,VLOOKUP(A10,$T$11:$W$20,MATCH(B10,$T$10:$W$10,0),0)))),0)","v":0},{"$f":"IF(D10=$Y$11,$AA$11,IF(D10=$X$11,$Z$11,IF(D10=$X$14,$Z$14,IF(D10=$X$18,$Z$18,))))","v":0},null,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=$Y$11,$AA$11,IF(D11=$X$11,$Z$11,IF(D11=$X$14,$Z$14,IF(D11=$X$18,$Z$18,))))","v":0},null,null,null,null,null,"Maillot sport",18,18,16.5,"Maillot sport",203566,203440,203567,"Blanc","Rouge",9001,3062]
[null,null,null,null,0,null,null,0,0,{"$f":"IF(D12=$Y$11,$AA$11,IF(D12=$X$11,$Z$11,IF(D12=$X$14,$Z$14,IF(D12=$X$18,$Z$18,))))","v":0},null,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,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,null,"Sweat",40,40,36,"Sweat",203508,203510,203509,"Noir","Rouge",2001,3062]
[null,null,null,null,0,null,null,0,0,0,null,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,null,"Pantalon",32,32,30,"Pantalon",203530,204173,203521,"Noir",null,2001]
["Partie pour la commande de pack ci dessous ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Short",14,14,12.5,"Short",211466,211468,211467,"Noir","Rouge",2001,3062]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(A18,$P$21:$S$23,MATCH(B18,$P$10:$S$10,0),0),)","v":0},{"$f":"IF(COUNTBLANK(A18)<1,1,)","v":0},null,0,null,null,null,null,null,null,null,"Maillot entrainement + flocage",21,21,19,"Chaussettes",null,null,null,"Blanche/rouge",null,9402]
[{"$f":"IF(OR($A$18=$Z$36,$A$18=$AB$36),R36,IF($A$18=$AA$36,T36,\"\"))","v":""},{"$f":"IF(COUNTBLANK(A19)<1,B$18,)","v":0},null,null,null,{"$f":"IF(COUNTBLANK(A19)<1,1,)","v":0},null,0,{"$f":"IFERROR(IF(A19=\"Chaussettes\",VLOOKUP(A19,$S$26:$U$27,MATCH(B19,$S$26:$U$26,0)),IF(A19=\"Sac de sport\",$S$29,IF(A19=\"Sac à dos\",$S$30,VLOOKUP(A19,$T$11:$W$20,MATCH(B19,$T$10:$W$10,0),0)))),0)","v":0},0,null,null,null,null,null,"Sac de sport",null,null,null,"Sac de sport",null,null,null,"Noir",null,2001]
[{"$f":"IF(OR($A$18=$Z$36,$A$18=$AB$36),V36,IF($A$18=$AA$36,U36,\"\"))","v":""},{"$f":"IF(COUNTBLANK(A20)<1,B$18,)","v":0},null,null,null,{"$f":"IF(COUNTBLANK(A20)<1,1,)","v":0},null,0,0,0,null,null,null,null,null,"Sac à dos",null,null,null,"Sac à dos",null,null,null,"Noir","Rouge",2001,3062]
[{"$f":"IF(OR($A$18=$Z$36,$A$18=$AB$36),W36,\"\")","v":""},{"$f":"IF(COUNTBLANK(A21)<1,Q26,)","v":0},null,null,null,0,null,0,0,0,null,null,null,null,null,"Pack Essentiel",40,40,36.5]
[{"$f":"IF(OR($A$18=$AB$36),T36,\"\")","v":""},{"$f":"IF(COUNTBLANK(A22)<1,B$18,)","v":0},null,null,null,0,null,{"$f":"E22*F22","v":0},0,{"$f":"IF(D22=$Y$11,$AA$11,IF(D22=$X$11,$Z$11,IF(D22=$X$14,$Z$14,IF(D22=$X$18,$Z$18,))))","v":0},null,null,null,null,null,"Pack Jour de match",68,68,63.5]
[{"$f":"IF(OR($A$18=$AB$36),U36,\"\")","v":""},{"$f":"IF(COUNTBLANK(A23)<1,B$18,)","v":0},null,null,null,0,null,0,0,0,null,null,null,null,null,"Pack Ultimate",146,146,137.5]
[{"$f":"IF(OR($A$18=$AB$36),X36,\"\")","v":""},{"$f":"IF(COUNTBLANK(A24)<1,Sac_de_sport,)","v":0},null,null,{"$f":"IF(C24=U28,6,)","v":0},0,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:H24)","v":0},null,null,null,null,null,null,null,null,"Prix",null,"Ref. HUMMEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low","High",null,"Low","High"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chaussettes",7,10,"Chaussettes",204043,204044]
[null,null,null,null,null,null,null,null,null,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,null,"Sac de sport",32,38,204012]
[null,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,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"]
[null,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"]
[null,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"]
[null,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"]
[]
[null,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,null,"S","XS",116,null,"27-30","45 L"]
[null,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,null,"L","M",140,null,"35-38"]
[null,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,null,"2XL","XL",164,null,"43-45"]
[null,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,null,"4XL"]
[]
[null,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,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,null,"Rouge","Rouge","Rouge","Rouge","Rouge",null,"Rouge",null,null,"Rouge"]