{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Bestillingsliste","Oversigt"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Bestillingsliste","index":0,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,9],[5,3,5,9],[3,3,3,9],[7,3,7,9],[9,3,9,9]]}
["Bestilling af trænertøj"]
[]
[]
["Fulde navn på træner"]
[]
["Initialer (op til tre bogstaver)"]
[]
["Afdeling"]
[]
["Træner el. holdleder"]
[]
[]
["Stk. bestilling"]
["Nr. ","Lb. Nr.","Navn","UB pris","Initialer","HIF-logo","Hvidovre IF logo","Antal","Størrelse","Pris i alt"]
["1.","725932-451","T-shirt (Tee)",180,"JA","JA",null,null,null,{"$f":"(COUNTIF(E15,\"JA\")*$D$26*H15)+(COUNTIF(F15,\"JA\")*$D$27*H15)+(COUNTIF(G15,\"JA\")*$D$28)+(D15*H15)","v":0}]
["2.","631569-452","Træningstrøje",450,"JA","JA",null,null,null,{"$f":"(COUNTIF(E16,\"JA\")*$D$26*H16)+(COUNTIF(F16,\"JA\")*$D$27*H16)+(COUNTIF(G16,\"JA\")*$D$28)+(D16*H16)","v":0}]
["3.","725930-451","Træningstrøje",300,"JA","JA",null,null,null,0]
["4.","645550-451","Overgangsjakke",750,"JA","JA",null,null,null,0]
["5.","645480-451","Regnjakke",400,"JA","JA",null,null,null,0]
["6.","645484-451","Vinterjakke",1000,"JA","JA",null,null,null,0]
["7.","725935-451","Shorts",200,"JA",{"$nulls":4},0]
["8.","725931-451","Lange bukser",300,"JA",{"$nulls":4},0]
["9.","SX5728-411","Fodboldstrømper",80,{"$nulls":5},{"$f":"D23*H23","v":0}]
["10.","SX5729-451","Korte strømper",80,{"$nulls":5},{"$f":"D24*H24","v":0}]
["11.","GS0261-010","Handsker",190,{"$nulls":5},0]
[null,null,"Initial pr. stk.",40,null,null,null,{"$f":"SUM(H15:H22)","v":0}]
[null,null,"HIF logo pr. stk.",30,null,null,null,{"$f":"SUM(H15:H20)","v":0}]
[null,null,"Hvidovre logo pr. stk.",75,null,null,null,{"$f":"SUM(G15:G22)","v":0}]
["Samlet værdi",{"$nulls":8},{"$f":"SUM(J15:J25)","v":0}]
[]
["Træner startpakke, 1.000,-"]
["Nr. ","Lb. Nr.","Navn","UB pris","Initialer","HIF-logo","Hvidovre IF logo","Antal","Størrelse","Pris i alt"]
["1.",{"$f":"VLOOKUP($A33,$A$15:$D$25,2,FALSE)","v":"725932-451"},{"$f":"VLOOKUP($A33,$A$15:$D$25,3,FALSE)","v":"T-shirt (Tee)"},{"$f":"VLOOKUP($A33,$A$15:$D$25,4,FALSE)","v":180},"JA","JA",null,1,null,{"$f":"H33*D33","v":180}]
["3.",{"$f":"VLOOKUP($A34,$A$15:$D$25,2,FALSE)","v":"725930-451"},{"$f":"VLOOKUP($A34,$A$15:$D$25,3,FALSE)","v":"Træningstrøje"},{"$f":"VLOOKUP($A34,$A$15:$D$25,4,FALSE)","v":300},"JA","JA",null,1,null,{"$f":"H34*D34","v":300}]
["7.","725935-451","Shorts",200,"JA",null,null,1,null,200]
["8.","725931-451","Lange bukser",300,"JA",null,null,1,null,300]
["10.","SX5729-451","Korte strømper",80,null,null,null,1,null,80]
[null,null,"Initial pr. stk.",40,null,null,null,{"$f":"COUNTIF(E33:E37,\"JA\")","v":4},null,{"$f":"H38*D26","v":160}]
[null,null,"HIF logo pr. stk.",30,null,null,null,{"$f":"COUNTIF(F33:F37,\"JA\")","v":2},null,{"$f":"H39*D27","v":60}]
["Samlet værdi",{"$nulls":8},{"$f":"SUM(J33:J39)","v":1280}]
["Pakkeværdi",{"$nulls":8},1000]
[]
["Holdlederpakke, 500,-"]
["Nr. ","Lb. Nr.","Navn","UB pris","Initialer","HIF-logo","Hvidovre IF logo","Antal","Størrelse","Pris i alt"]
["1.",{"$f":"VLOOKUP($A45,$A$15:$D$25,2,FALSE)","v":"725932-451"},{"$f":"VLOOKUP($A45,$A$15:$D$25,3,FALSE)","v":"T-shirt (Tee)"},{"$f":"VLOOKUP($A45,$A$15:$D$25,4,FALSE)","v":180},"JA","JA",null,1,null,{"$f":"H45*D45","v":180}]
["7.",{"$f":"VLOOKUP($A46,$A$15:$D$25,2,FALSE)","v":"725935-451"},{"$f":"VLOOKUP($A46,$A$15:$D$25,3,FALSE)","v":"Shorts"},{"$f":"VLOOKUP($A46,$A$15:$D$25,4,FALSE)","v":200},"JA",null,null,1,null,200]
["10.","SX5729-451","Korte strømper",80,null,null,null,2,null,160]
[null,null,"Initial pr. stk.",40,null,null,null,{"$f":"COUNTIF(E45:E47,\"JA\")","v":2},null,{"$f":"H48*D26","v":80}]
[null,null,"HIF logo pr. stk.",30,null,null,null,{"$f":"COUNTIF(F45:F47,\"JA\")","v":1},null,{"$f":"H49*D27","v":30}]
["Samlet værdi",{"$nulls":8},{"$f":"SUM(J45:J49)","v":650}]
["Pakkeværdi",{"$nulls":8},500]
[]
["Shorts er med lomme. Der kan også fås shorts uden lomme for kr. 170,-. I givet fald noteres det i bemærkningerne"]
[]
["Bemærkninger"]

{"sheet":"Oversigt","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}