{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["利用方法","賞状","選手名簿","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":"利用方法","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["１．","事前準備"]
[null,"１）","選手名簿の入力"]
[null,null,"「選手名簿」シートに選手の所属、名前を入力してください"]
[null,null,"※200ペアまで、対応しております"]
[null,null,"※200ペアを超える場合、「賞状」シートのN4～Q4の"]
[null,null,"　VLOOKUPの$E$201の201を変更してください"]
[null,"２）","大会名入力"]
[null,null,"「賞状」シートのL1に大会名を入力してください"]
[null,"３）","種目入力"]
[null,null,"「賞状」シートのS1,T1に種目をを入力してください"]
[null,null,"※種目は、20種目まで、対応しております"]
[null,"４）","開催日入力"]
[null,null,"「賞状」シートのN5～P5に開催日をを入力してください"]
[null,"５）","プリンタープロパティーの用紙種類を「ビジネス用紙」に変更"]
[]
["２．","賞状印刷"]
[null,"１）","印刷する種目のNo.を、M2に入力する。N2の種目名を確認する"]
[null,"２）","印刷する入賞番号を、入力する"]
[null,"３）","印刷する入賞者のNo.を、入力する"]
[null,null,"N4～Q4の選手名、所属を確認する"]
[null,null,"※間違っている場合は、「選手名簿」シートを修正してください"]
[null,"４）","印刷ボタンを押すと、賞状が印刷されます"]
[null,null,"※賞状は、２枚、プリンターに設定してください"]
[null,null,"※通常使うプリンターに印刷されます"]

{"sheet":"賞状","index":1,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[7,0,10,10],[18,1,19,4],[18,6,19,9],[20,1,21,4],[20,6,21,9],[12,2,13,8],[15,4,17,6],[18,5,19,5],[20,5,21,5],[56,5,57,5],[64,4,65,4],[64,6,65,6],[64,7,65,8],[56,1,57,4],[56,6,57,9],[51,4,53,6],[54,5,55,5],[54,1,55,4],[54,6,55,9],[28,7,29,8],[28,4,29,4],[28,6,29,6],[43,0,46,10],[48,2,49,8]]}
[null,null,null,null,null,null,null,null,null,null,null,"大会名","第４９回　花崎春雄杯ソフトテニス大会",null,null,null,null,null,1,"一般男子"]
[null,null,null,null,null,null,null,null,null,null,null,"種目",2,{"$f":"VLOOKUP(M2,S1:T20,2,TRUE)","v":"男子３５"},null,null,null,null,2,"男子３５"]
[null,null,null,null,null,null,null,null,null,null,null,"入賞",1,null,null,null,null,null,3,"男子５０"]
[null,null,null,null,null,null,null,null,null,null,null,"入賞者","i-29",{"$f":"VLOOKUP($M$4,選手名簿!$A$2:$E$201,2,FALSE)","v":"惟村"},{"$f":"VLOOKUP($M$4,選手名簿!$A$2:$E$201,3,FALSE)","v":"星友会"},{"$f":"VLOOKUP($M$4,選手名簿!$A$2:$E$201,4,FALSE)","v":"惟村"},{"$f":"VLOOKUP($M$4,選手名簿!$A$2:$E$201,5,FALSE)","v":"星友会"},null,4,"男子６０"]
[null,null,null,null,null,null,null,null,null,null,null,"和暦年月日",null,5,2,18,null,null,5,"男子７０"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"一般女子"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"女子３５"]
[{"$f":"M$1","v":"第４９回　花崎春雄杯ソフトテニス大会"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"女子５０"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"女子６０"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"女子７０"]
[]
[]
[null,null,{"$f":"N$2","v":"男子３５"}]
[]
[]
[null,null,null,null,{"$f":"M$3","v":1}]
[]
[]
[null,{"$f":"N$4","v":"惟村"},null,null,null,"・",{"$f":"P$4","v":"惟村"}]
[]
[null,{"$f":"O$4","v":"星友会"},null,null,null,"・",{"$f":"Q$4","v":"星友会"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"N$5","v":5},null,{"$f":"O$5","v":2},{"$f":"P$5","v":18}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"M$1","v":"第４９回　花崎春雄杯ソフトテニス大会"}]
[]
[]
[]
[]
[null,null,{"$f":"N$2","v":"男子３５"}]
[]
[]
[null,null,null,null,{"$f":"M$3","v":1}]
[]
[]
[null,{"$f":"P$4","v":"惟村"},null,null,null,"・",{"$f":"N$4","v":"惟村"}]
[]
[null,{"$f":"Q$4","v":"星友会"},null,null,null,"・",{"$f":"O$4","v":"星友会"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"N$5","v":5},null,{"$f":"O$5","v":2},{"$f":"P$5","v":18}]

{"sheet":"選手名簿","index":2,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["No.","プレイヤーA","クラブA","プレイヤーB","クラブB"]
["A-1","渡邉","EAST","鈴木","特種東海製紙"]
["A-2","丸山","鷹岡STC","佐野","鷹岡STC"]
["A-3","杉浦","富士宮市役所","望月","明電舎"]
["B-4","小澤","鷹岡STC","佐野","鷹岡STC"]
["B-5","市川","Emmy's","遠藤","Emmy's"]
["B-6","久保","EASTC","芹沢","EASTC"]
["B-7","鈴木","TBTC","木内","ウルスブラン"]
["C-8","鍛冶","EAST","山口","ウルスブラン"]
["C-9","惟村","TBTC","國本","星友会"]
["C-10","飯塚","鷹岡STC","後藤","鷹岡STC"]
["C-11","佐野","Emmy's","渡邊","Emmy's"]
["D-12","矢田","鷹岡STC","鈴木","鷹岡STC"]
["D-13","望月","ウルスブラン","塩川","富士宮市役所"]
["D-14","秋山","星友会","片岡","富士宮"]
["D-15","矢板","全静クラブ","鎮守","全静クラブ"]
["E-16","嘉数","星友会","遠藤","星友会"]
["E-17","高田","EASTC","石田","EASTC"]
["E-18","渡井","ウルスブラン","後藤","ウルスブラン"]
["E-19","後藤","鷹岡STC","中川","鷹岡STC"]
["F-20","高村","球聖","鈴木","EASTC"]
["F-21","浦田","富士軟庭会","立元","球聖"]
["F-22","岩田","富士宮","鈴木","富士宮"]
["G-23","立元","星友会","鈴木","星友会"]
["G-24","小林","WTC","佐野","WTC"]
["G-25","小林","富士宮","菊川","富士宮"]
["H-26","宮崎","オレンジ","別符","あすなろ"]
["H-27","渡辺","球聖","梅原","富士宮市役所"]
["H-28","立元","星友会","渡辺","星友会"]
["I-29","惟村","星友会","惟村","星友会"]
["I-30","小川","星友会","深沢","星友会"]
["I-31","東山","球聖","勝又","球聖"]
["J-32","秋山","東芝キャリア","猪ノ原","裾野"]
["J-33","佐野","WTC","諏訪部","WTC"]
["J-34","梶原","大仁","北條","WTC"]
["K-35","稲葉","伊東","惟村","富士宮"]
["K-36","原","富士ファミリー","渡邊(健)","富士ファミリー"]
["K-37","鈴木","富士雁がね","小澤","富士ファミリー"]
["K-38","小澤","オレンジ","渡邊(睦)","吉原"]

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