{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["表紙※記載例","プロジェクトリスト(様式1-1)※記載例","事業計画①(様式1-2)※記載例","事業計画②(様式1-3)※記載例","KPI表(様式2)※記載例"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":19,"comments":1,"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":41,"n_cols":48,"rows_kept":41,"cut":false,"hidden":false,"merged":[[36,30,37,35],[36,36,37,49],[38,30,39,35],[38,36,39,49],[40,30,41,35],[40,36,41,49],[0,47,3,51],[6,0,12,51],[16,4,18,13],[19,4,24,47],[34,30,35,35],[34,36,35,49]]}
[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,null,null,null,null,null,"記載例"]
[]
[]
[]
[]
[]
["令和4年度 地域の観光資源を活用したプロモーション事業 提案書"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"プロジェクト名"]
[]
[]
[null,null,null,null,"Adventure Travel HOKKKAIDOプロモーション"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,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,null,null,null,null,null,null,null,null,null,"E-Mailアドレス",null,null,null,null,null,"０００＠０００"]

{"sheet":"プロジェクトリスト(様式1-1)※記載例","index":1,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,5,8],[4,3,4,4],[1,1,2,1],[1,2,2,2],[1,3,2,4],[1,6,2,6],[1,12,1,13],[0,11,0,13],[3,3,3,4],[0,1,0,6],[0,8,0,9],[1,7,1,8],[1,9,1,11]]}
[null,"【R4年度地域の観光資源を活用したプロモーション事業】　　プロジェクトリスト",null,null,null,null,null,"年度（西暦）",2022,null,"実施部署","北海道運輸局"]
[null,"事業\n番号","プロジェクト名       ","継続年",null,"主となる","対象市場（国名等）","実施期間",null,"事業費（千円）",null,null,"事業費の構成比（％）"]
[null,null,null,null,null,"エリア",null,"開始月","終了月","総額","国費","連携先負担","国費割合","連携先負担割合"]
[null,1,"Adventure Travel HOKKKAIDOプロモーション","3年目",null,"欧米豪","米、加、英、独、豪、仏、伊、西、露、台湾","2022-04-01","2023-03-01",{"$f":"K4+L4","v":12660},6330,6330,{"$f":"IF(K4>0,K4/J4,\"\")","v":0.5},{"$f":"IF(L4>0,L4/J4,\"\")","v":0.5}]
[null,null,null,null,null,null,null,null,null,0,null,null,"",""]
[null,"計",null,null,null,null,null,null,null,{"$f":"SUM(J4:J5)","v":12660},{"$f":"SUM(K4:K5)","v":6330},{"$f":"SUM(L4:L5)","v":6330},0.5,0.5]

{"sheet":"事業計画①(様式1-2)※記載例","index":2,"n_rows":16,"n_cols":28,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,1,3],[0,4,1,4],[0,5,1,5],[0,27,1,28],[0,29,1,30],[0,6,0,7],[0,8,0,10],[0,11,0,12],[0,13,0,26],[1,6,1,7],[1,8,1,10],[1,11,1,12],[1,15,1,17],[1,19,1,20],[1,21,1,22],[1,23,1,26],[3,1,6,2],[3,6,4,7],[3,8,4,12],[3,13,6,13],[5,6,6,7],[5,8,6,12],[11,14,12,16],[11,17,12,30],[13,14,14,16],[13,17,14,30],[14,1,15,3],[14,4,15,13],[15,14,15,16],[15,17,15,30],[11,1,11,3],[11,4,11,13],[12,1,12,3],[12,4,12,13],[13,1,13,3],[13,4,13,13],[10,1,10,3],[10,4,10,13],[10,14,10,16],[10,17,10,30],[8,14,9,16],[8,17,9,30],[8,1,9,3],[9,4,9,13],[6,14,6,16],[6,17,6,22],[6,23,6,25],[6,26,6,30],[8,4,8,13],[3,14,3,16],[3,17,3,30],[4,14,4,16],[4,17,4,30],[5,14,5,16],[5,17,5,30]]}
[null,"事業計画",null,null,"年度\n（西暦）",2022,"実施部署",null,{"$f":"IF('プロジェクトリスト(様式1-1)※記載例'!L1=\"\",\"\",'プロジェクトリスト(様式1-1)※記載例'!L1)","v":"北海道運輸局"},null,null,"プロジェクト名",null,{"$f":"'プロジェクトリスト(様式1-1)※記載例'!C4","v":"Adventure Travel HOKKKAIDOプロモーション"},null,null,null,null,null,null,null,null,null,null,null,null,null,"更新日"]
[null,null,null,null,null,null,"事業番号",null,null,null,null,"継続年",null,{"$f":"'プロジェクトリスト(様式1-1)※記載例'!D4","v":"3年目"},"実施期間","2022-04-01",null,null,"～","2023-03-01",null,"担当者"]
[]
[null,"事業費",null,null,"金額(千円)","率（％）","対象市場\n（国名等）",null,{"$f":"'プロジェクトリスト(様式1-1)※記載例'!G4","v":"米、加、英、独、豪、仏、伊、西、露、台湾"},null,null,null,null,"事業主体\n（連携先等）","広域組織\n（DMO、協議会等）",null,null,"北海道アドベンチャートラベル協議会"]
[null,null,null,"総事業費",{"$f":"IFERROR(E6+E7,\"\")","v":12660},{"$f":"IFERROR((IF(E5,E5/E5,\"\")),\"\")","v":1},null,null,null,null,null,null,null,null,"地方自治体",null,null,"札幌市、富良野市、釧路市、弟子屈町、斜里町、羅臼町、千歳市、小樽市、恵庭市、苫小牧市、長沼町、由仁町、安平町"]
[null,null,null,"国費",{"$f":"'プロジェクトリスト(様式1-1)※記載例'!K4","v":6330},{"$f":"IFERROR((IF(E5>0,E6/E5,\"\")),\"\")","v":0.5},"国内対象地域\n（都道府県）",null,"北海道",null,null,null,null,null,"観光団体(観光協会等)",null,null,"千歳の観光を考える会、一般社団法人千歳観光連盟、ひがしかわ観光協会、"]
[null,null,null,"連携先",{"$f":"'プロジェクトリスト(様式1-1)※記載例'!L4","v":6330},{"$f":"IFERROR((IF(E5>0,E7/E5,\"\")),\"\")","v":0.5},null,null,null,null,null,null,null,null,"その他の団体、民間等",null,null,"北海道中央バス、支笏湖温泉旅館組合、北海道エアポート",null,null,null,null,null,"交通事業者　【必須】",null,null,"北海道中央バス"]
[]
[null,"事業採択要件\nに該当する\n観光資源",null,null,"②国立公園関連",null,null,null,null,null,null,null,null,null,"対象市場\n（ターゲット層）",null,null,"イギリス、豪州（スポーツ愛好者層、特に25～34歳男性、FIT）/米国（アウトドア・アクティビティ特定関心層、特に25～34歳男性、FIT）/カナダ（アウトドア・アクティビティ特定関心層）/ドイツ（20～30代個人旅行層、訪日無関心層）/フランス(スポーツ愛好者層)/ロシア(極東ロシア高所得者)/台湾（FIT、アウトドア関心層、リピーター層）"]
[null,null,null,null,"（具体的な観光資源の名称をご記載下さい）例②道内各国立公園、③世界遺産知床、民族共生象徴空間「ウポポイ」"]
[null,"事業テーマ",null,null,"アドベンチャートラベル＜各種アクティビティ、文化体験（和文化、縄文文化、アイヌ文化）、自然＞",null,null,null,null,null,null,null,null,null,"個別事業類型",null,null,"イベント・旅行博（B2B）、旅行会社招請"]
[null,"背景",null,null,"アドベンチャートラベル市場は、新型コロナ収束後の新たな旅行トレンドになる可能性が高く市場規模も拡大しつつあり、2021年にはATTA主催のアジア初の国際会議ATWS北海道開催が内定している。",null,null,null,null,null,null,null,null,null,"JNTOによる\n助言の反映状況"]
[null,"目的",null,null,"アドベンチャートラベル市場を獲得し、欧米比率の向上、地域経済への好影響、北海道の観光産業の高付加価値化を測る"]
[null,"期待される効果",null,null,"北海道のＡＴ情報を提供し、相手側参加者との関係構築。\n質の高いＡＴ旅行者への認知度向上、誘客促進。",null,null,null,null,null,null,null,null,null,"デジタルマーケティング等による\n分析結果の反映状況"]
[null,"事業戦略",null,null,"ATWS開催地としてAT市場から注目が集まる好機に旅行商品が流通するようATWS開催前に海外旅行会社を招請すると共に、ATWSへ出展しAT訪問先としての北海道の魅力PR及びAT関係者との関係構築による海外への販売ルートを確保を図る。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"過年度事業からの改善点\n※外部有識者による\n評価の反映状況を含む",null,null,"AT旅行者は比較的高所得者で長期滞在者が多い傾向にあることから、今年度はターゲットのニーズに合った、オーダーメイドの旅行商品の造成を促すこととする。"]

{"sheet":"事業計画②(様式1-3)※記載例","index":3,"n_rows":14,"n_cols":36,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,15,7,18],[7,22,7,35],[1,1,2,1],[1,2,2,2],[1,3,2,8],[1,9,2,11],[1,12,2,14],[1,15,2,18],[1,19,2,19],[1,20,2,20],[1,21,2,21],[1,31,2,34],[1,35,2,35],[6,3,6,8],[6,9,6,11],[6,12,6,14],[6,15,6,18],[6,31,6,34],[5,3,5,8],[5,9,5,11],[5,12,5,14],[5,15,5,18],[5,31,5,34],[4,3,4,8],[4,9,4,11],[4,12,4,14],[4,15,4,18],[4,31,4,34],[3,3,3,8],[3,9,3,11],[3,12,3,14],[3,15,3,18],[3,31,3,34],[0,1,0,2],[0,4,0,5],[0,6,0,19],[0,33,0,35],[1,22,1,30]]}
[null,"事業番号",null,null,"プロジェクト名",null,{"$f":"'プロジェクトリスト(様式1-1)※記載例'!C4","v":"Adventure Travel HOKKKAIDOプロモーション"},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,"内容\n番号","個別\n事業\n類型","個別事業内容",null,null,null,null,null,"個別事業連携先\n（実施主体/幹事）",null,null,"事業採択要件\nに該当する\n観光資源",null,null,"対象市場",null,null,null,"総事業費\n（千円）","国費\n（千円）","連携先\n負担\n（千円）","事業の重点化（①～⑦,ⅰⅱ）",null,null,null,null,null,null,null,null,"関連自治体",null,null,null,"個別事業\n継続年数"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"①","②","③","④","⑤","⑥","⑦","ⅰ","ⅱ"]
[null,1,"旅行会社招請","グリーンシーズンにアウトドアアクティビティ・ウォーキング専門旅行会社3社3名を6泊7日の行程で招請",null,null,null,null,null,"●●",null,null,"●●",null,null,"米国",null,null,null,{"$f":"U4+V4","v":600},300,300,"－","－","○","－","○","－","○","○","－","●●市\n●●町",null,null,null,"2年目"]
[null,2,"イベント・旅行博等出展","豪州 Snow Travel Expo（5月）、英国 Ski & Snowboard Show（10月）に出展",null,null,null,null,null,null,null,null,null,null,null,"豪州、英国",null,null,null,400,200,200]
[null,3,"印刷物・画像・映像","【グリーンシーズン】\nパンフレット●,●●●●部、マウンテンリゾート広域マップの作成\n【スノーシーズン】\nパンフレット●,●●●●部、スキーマップ",null,null,null,null,null,null,null,null,null,null,null,"●●",null,null,null,200,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"事業費計",null,null,null,{"$f":"SUM(T4:T7)","v":1200},{"$f":"SUM(U4:U7)","v":600},{"$f":"SUM(V4:V7)","v":600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"チェック用：様式1-1事業費計",1200,600,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T8=T9,\"OK\",\"×\")","v":"OK"},{"$f":"IF(U8=U9,\"OK\",\"×\")","v":"OK"},{"$f":"IF(V8=V9,\"OK\",\"×\")","v":"OK"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"KPI表(様式2)※記載例","index":4,"n_rows":8,"n_cols":34,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,24,3,28],[3,29,3,33],[0,0,0,7],[1,2,1,7],[1,8,1,12],[1,13,1,17],[1,19,1,23],[1,24,1,28],[1,29,1,33],[3,0,7,0],[4,1,7,1],[3,8,3,10],[3,13,3,17],[3,19,3,21]]}
["令和４年度　地域の観光資源を活用したプロモーション事業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"成果指標+L2:U7"]
[null,"運輸局名",{"$f":"IF('プロジェクトリスト(様式1-1)※記載例'!L1=\"\",\"\",'プロジェクトリスト(様式1-1)※記載例'!L1)","v":"北海道運輸局"},null,null,null,null,null,"アウトプット①",null,null,null,null,"アウトプット②",null,null,null,null,null,"アウトカム①",null,null,null,null,"アウトカム②",null,null,null,null,"アウトカム③"]
["事業番号","プロジェクト名","内容\n番号","個別事業類型","対象市場","総事業費\n（千円）","国費\n（千円）","継続年","成果指標","目標値","実績値","自己\n評価","評価理由","成果指標","目標値","実績値","自己\n評価","評価理由",null,"成果指標","目標値","実績値","自己\n評価","評価理由","成果指標","目標値","実績値","自己\n評価","評価理由","成果指標","目標値","実績値","自己\n評価","評価理由"]
[1,"事業総括評価"]
[null,{"$f":"IF('プロジェクトリスト(様式1-1)※記載例'!C4=\"\",\"\",VLOOKUP($A$4,'プロジェクトリスト(様式1-1)※記載例'!$B$4:$E$5,2,FALSE))","v":"Adventure Travel HOKKKAIDOプロモーション"},1,"メディア・インフルエンサー招請","米国",null,null,"2年目","招請人数","●●",null,null,null,null,null,null,null,null,null,"造成ツアー送客数","●●",null,null,null,"造成ツアー本数","●●"]
[null,null,2,"イベント・旅行博等出展",null,null,null,null,"ブース来場者数"]
[null,null,3,"印刷物・画像・映像",null,null,null,null,"部数・枚数・本数"]
[null,null,4]