{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Vorlage","Musterbeispiel"],"not_rendered":{"charts":0,"images":0,"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":"Vorlage","index":0,"n_rows":73,"n_cols":8,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,4,1,5],[1,6,1,7],[8,0,8,1],[9,0,9,1],[10,0,10,1],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[0,4,0,5],[0,6,0,7],[11,0,11,1],[11,2,11,3],[9,5,9,6],[10,5,10,6],[11,5,11,6],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1]]}
["Dress-Inventar FC Oftringen",null,null,null,"Datum Aktualisierung:"]
[{"$nulls":4},"Anschaffung (wenn bekannt):"]
[]
["Mannschaft:"]
["Auswärts/Heim:"]
["Sponsor auf Dress:"]
["Sponsor auf Dress:"]
["Sponsor auf Dress:"]
["Sponsor auf Dress:"]
["Artikel-Nr. Shirt Feldspieler:",null,null,null,"Farbe:"]
["Artikel-Nr. Hose Feldspieler:",null,null,null,"Farbe:"]
["Stulpen:",null,null,null,"Farbe:"]
[]
["Shirts Feldspieler"]
["Nummer","T-Shirt-Grösse",null,"Torhüter","Artikel","Nummer","Farbe","Grösse"]
[2,null,null,"Shirt:"]
[3,null,null,"Hosen:"]
[4,null,null,"Stulpen:"]
[5,null,null,"Shirt:"]
[6,null,null,"Hosen:"]
[7,null,null,"Stulpen:"]
[8,null,null,"Shirt:"]
[9,null,null,"Hosen:"]
[10,null,null,"Stulpen:"]
[11,null,null,"Shirt:"]
[12,null,null,"Hosen:"]
[13,null,null,"Stulpen:"]
[14]
[15]
[16,null,null,"Hosen Feldspieler","Anzahl"]
[17,null,null,152]
[18,null,null,164]
[19,null,null,"XS"]
[20,null,null,"S"]
[21,null,null,"M"]
[22,null,null,"L"]
[23,null,null,"XL"]
[24]
[25]
[26,null,null,"Stulpen Feldspieler","Anzahl"]
[27,null,null,"mit Socken","-"]
[28,null,null,"XS (1)"]
[29,null,null,"S (2)"]
[30,null,null,"M (3)"]
[31,null,null,"L (4)"]
[32,null,null,"XL (5)"]
[33,null,null,"ohne Socken","-"]
[34,null,null,"XS"]
[35,null,null,"S (SM)"]
[36,null,null,"M (MD)"]
[37,null,null,"L (LG)"]
[38,null,null,"XL"]
[]
[]
["Anzahl ohne TH","mit Nummer","+  Shirt ohne Nummer (Ersatz)"]
[116,{"$f":"IF(COUNTIF($B$16:$B$52,A56)=0,\"\",COUNTIF($B$16:$B$52,A56))","v":""}]
[122,{"$f":"IF(COUNTIF($B$16:$B$52,A57)=0,\"\",COUNTIF($B$16:$B$52,A57))","v":""}]
[128,""]
[134,""]
[140,""]
[146,""]
[152,""]
[158,""]
[164,""]
[170,""]
[176,""]
["XS",{"$f":"IF(COUNTIF($B$16:$B$52,A67)=0,\"\",COUNTIF($B$16:$B$52,A67))","v":""}]
["S",{"$f":"IF(COUNTIF($B$16:$B$52,A68)=0,\"\",COUNTIF($B$16:$B$52,A68))","v":""}]
["M",""]
["L",""]
["XL",{"$f":"IF(COUNTIF($B$16:$B$52,A71)=0,\"\",COUNTIF($B$16:$B$52,A71))","v":""}]
["XXL",""]
["XXXL",""]

{"sheet":"Musterbeispiel","index":1,"n_rows":73,"n_cols":8,"rows_kept":73,"cut":false,"hidden":false,"merged":[[11,0,11,1],[11,2,11,3],[11,5,11,6],[1,4,1,5],[1,6,1,7],[8,0,8,1],[8,2,8,3],[9,0,9,1],[9,2,9,3],[9,5,9,6],[10,0,10,1],[10,2,10,3],[10,5,10,6],[5,0,5,1],[5,2,5,3],[6,0,6,1],[6,2,6,3],[7,0,7,1],[7,2,7,3],[0,4,0,5],[0,6,0,7],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3]]}
["Dress-Inventar FC Oftringen",null,null,null,"Datum Aktualisierung:",null,"2021-01-02"]
[{"$nulls":4},"Anschaffung (wenn bekannt):",null,"01.2021"]
[]
["Mannschaft:",null,"Ba"]
["Auswärts/Heim:",null,"Heim"]
["Sponsor auf Dress:",null,"Franke"]
["Sponsor auf Dress:"]
["Sponsor auf Dress:"]
["Sponsor auf Dress:"]
["Artikel-Nr. Shirt Feldspieler:",null,"FI4554",null,"Farbe:","blau"]
["Artikel-Nr. Hose Feldspieler:",null,"DP3682",null,"Farbe:","blau"]
["Stulpen:",null,null,null,"Farbe:","blau"]
[]
["Shirts Feldspieler"]
["Nummer","T-Shirt-Grösse",null,"Torhüter","Artikel","Nummer","Farbe","Grösse"]
[2,"M",null,"Shirt:","FI4556 kurz",1,"gelb","M"]
[3,"M",null,"Hosen:","DP3246 kurz",null,"schwarz","M"]
[4,"M",null,"Stulpen:","CV7522",null,"schwarz","MD"]
[5,"M",null,"Shirt:","AZ5398 lang",12,"orange","L"]
[6,"M",null,"Hosen:","DP3246 kurz",null,"schwarz","L"]
[7,"M",null,"Stulpen:","CV7522",null,"schwarz","LG"]
[8,"M",null,"Shirt:"]
[9,"M",null,"Hosen:"]
[10,"M",null,"Stulpen:"]
[11,"M",null,"Shirt:"]
[12,null,null,"Hosen:"]
[13,"S",null,"Stulpen:"]
[14,"S"]
[15,"S"]
[16,"S",null,"Hosen Feldspieler","Anzahl"]
[17,"S",null,152]
[18,"L",null,164]
[19,"L",null,"XS"]
[20,"XL",null,"S",5]
[21,"XL",null,"M",10]
[22,null,null,"L",3]
[23,null,null,"XL",2]
[24]
[25]
[26,null,null,"Stulpen Feldspieler","Anzahl"]
[27,null,null,"mit Socken","-"]
[28,null,null,"XS (1)"]
[29,null,null,"S (2)"]
[30,null,null,"M (3)"]
[31,null,null,"L (4)"]
[32,null,null,"XL (5)"]
[33,null,null,"ohne Socken","CV7524"]
[34,null,null,"XS"]
[35,null,null,"S (SM)",5]
[36,null,null,"M (MD)",13]
[37,null,null,"L (LG)",2]
[38,null,null,"XL"]
[]
[]
["Anzahl ohne TH","mit Nummer","+  Shirt ohne Nummer (Ersatz)"]
[116,{"$f":"IF(COUNTIF($B$16:$B$52,A56)=0,\"\",COUNTIF($B$16:$B$52,A56))","v":""}]
[122,{"$f":"IF(COUNTIF($B$16:$B$52,A57)=0,\"\",COUNTIF($B$16:$B$52,A57))","v":""}]
[128,""]
[134,""]
[140,""]
[146,""]
[152,""]
[158,""]
[164,""]
[170,""]
[176,""]
["XS",{"$f":"IF(COUNTIF($B$16:$B$52,A67)=0,\"\",COUNTIF($B$16:$B$52,A67))","v":""}]
["S",{"$f":"IF(COUNTIF($B$16:$B$52,A68)=0,\"\",COUNTIF($B$16:$B$52,A68))","v":5},1]
["M",10,1]
["L",2]
["XL",2]
["XXL",""]
["XXXL",""]