{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":72,"n_cols":35,"rows_kept":72,"cut":false,"hidden":false,"merged":[[28,8,28,17],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,14,5,14],[4,15,4,16],[2,7,2,9],[3,7,3,9],[4,9,5,9],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,20,5,20],[4,21,5,21],[4,22,5,22],[4,5,5,5],[4,6,4,7],[4,8,5,8]]}
[null,"黄門流中央競馬予想ソフト"]
["印籠"]
["場所","レース名","距離","芝ダ","馬場","頭数","条件","開催日時"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U4,$U$26:$V$31,2,FALSE),\"\")","v":""}]
["馬番","馬名","騎手","牡牝","年齢","負担\n重量","勝数",null,"近走\n着外","実績","力量","GAP","持ち\nタイム","馬体","人気","好走",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[17]
[18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"印籠"]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,2,"〇"]
[null,null,null,1,null,null,"データを取得する",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"▲"]
[null,null,null,null,null,null,"URL：",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"△",null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,"Copyright © 黄門さまの馬券人生 All Rights Reserved.",null,null,null,null,null,null,null,null,null,null,null,null,5,"×"]
[null,null,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,"　a.地方競馬の成績はG3以上のレースの勝鞍数のみを加算します。"]
[null,"⑤近走着外欄は直近の5レースの4着以下の回数を入力します。本来の意味の着外ではありません。"]
[null,"⑥上記までの入力が完了したら入力完了ボタンを押下します。するとこの時点での実績判定値等が表示されます。"]
[]
[null,"（入力処理を続行します）"]
[null,"⑦持ちタイム欄は同距離の良馬場の最速の持ちタイムを入力します。必須ではなく省略しても構いません。"]
[null,"⑧馬体欄はJRA発表後に場体重の増減を入力します。"]
[null,"⑨人気欄は当日の１０時以降（自分で決めた一定の時刻）の人気順全てを入力します。入力後に順位の変更があっても再入力の必要はありません。"]
[null,"⑩ここまでの入力が完了したら再度入力完了ボタンを押下します。"]
[null,"　※力量と人気の差を調整した数値がGAP欄に追加表示されます。"]
[]
[null,"⑪好走欄は直近の４レースを見て次のように設定します。"]
[null,"　a.格上欄は上のグレードでの好走（0.3秒以内）の回数を入力します。補正に3点が加算されます。"]
[null,"　b.適格欄には同一グレード（0.5秒以内）や下位グレードの勝利の回数を入力します。補正に1.5点が加算されます。"]
[null,"⑫独自評価欄は必須ではありませんが利用者の判断で加算や減算する点数を入力します。下記の例を参考にします。"]
[null,"　a.場体重に10ｋｇ以上の変動がある場合は減点材料にします。"]
[null,"　b.上位とのタイム差が１.5秒以上（個人の判断で決定）ある場合減点材料にします。"]
[null,"　c.騎乗する騎手が大いに信頼できると判断した場合は加点材料にします。"]
[null,"　d.馬券の狙い目と判断した馬は大きく加点材料にします。"]
[null,"　※その他に斤量差、距離適性、馬場状態条件、コース適正etcもありますが、上記例を含めて個人の判断で決定します。"]
[]
[null,"⑬再度入力完了ボタンを押下すれば、補正値の入力で総合ポイント、順位および予想は自動的に反映されて再表示されます。"]
[null,"　a.・順位に同点がある場合は優先したい馬の補正値に+0.2を加点して重複を避けます。"]
[]
[null,"※1：一時退避ボタンは押下された時点の予想表の状態をSeet1からSheet2へCOPYできます。"]
[null,"※2：実績、力量、GAP、総合、順位、補正、予想ボタンはマクロ組込ボタンです。数式が壊れた場合に押下すれば復旧できます。"]
[null,"※3：Sheet1、Sheet2およびSheet3の名称は変えないでください。"]
[null,"※4：マクロ等が操作できる人は改善して独自の予想ソフトに仕上げてください。"]
[null,"※5：予想結果のシートを別名で保存したい場合は別名保存ボタンを押下してください。同一のフォルダーに保存されます。"]
[null,"※パラメータ設定ボタンを押下すると、各種パラメータ値を個人の判断で変更できます。ソフトの判断基準が変わります。"]

{"sheet":"Sheet2","index":1,"n_rows":24,"n_cols":23,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,7,2,9],[3,7,3,9],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,4,7],[4,8,5,8],[4,9,5,9],[4,20,5,20],[4,21,5,21],[4,22,5,22],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,14,5,14],[4,15,4,16]]}
[null,"黄門流中央競馬予想ソフト"]
["印籠"]
["場所","レース名","距離","芝ダ","馬場","頭数","条件","開催日時"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U4,$U$26:$V$31,2,FALSE),\"\")","v":""}]
["馬番","馬名","騎手","牡牝","年齢","負担\n重量","勝数",null,"近走\n着外","実績","力量","GAP","持ち\nタイム","馬体","人気","好走",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,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(U7,$U$26:$V$31,2,FALSE),\"\")","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,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,null,null,""]
[7,null,null,null,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,null,null,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Sheet3","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"パラメータ設定画面"]
[null,null,null,null,null,"初期値"]
[null,1,"着外の減点",0.1,null,0.1]
[null,2,"格上好走の加点",3,null,3]
[null,3,"適格好走の加点",1.5,null,1.5]
[null,4,"10～12人気の減点",8,null,8]
[null,5,"13人気以下の減点",9,null,9]
[null,6,"芝⇔ダート違い勝利",0.5,null,0.5]
[null,"※着外の0.1は0.1勝分の減点の意味"]
[null,"※芝⇔ダート違い勝利は0.5勝扱いの意"]
[]
[null,"上記表の加減点は各人で変更できます。"]
[null,"予想ソフトの判断に反映されます。"]