{"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":31,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,30,39,35],[38,36,39,49],[40,30,41,35],[40,36,41,49],[6,0,12,51],[16,4,18,13],[19,4,24,47],[34,30,35,35],[34,36,35,49],[36,30,37,35],[36,36,37,49]]}
[]
[]
[]
[]
[]
[]
["令和4年度 地域の観光資源を活用したプロモーション事業 提案書"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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アドレス"]

{"sheet":"プロジェクトリスト(様式1-1)","index":1,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,3,2,4],[1,6,2,6],[5,1,5,8],[3,3,3,4],[4,3,4,4],[0,1,0,6],[0,8,0,9],[1,7,1,8],[1,9,1,11],[1,12,1,13],[0,11,0,13]]}
[null,"【R4年度地域の観光資源を活用したプロモーション事業】　　プロジェクトリスト",null,null,null,null,null,"年度（西暦）",2022,null,"実施部署","関東運輸局"]
[null,"事業\n番号","プロジェクト名       ","継続年",null,"主となる","対象市場（国名等）","実施期間",null,"事業費（千円）",null,null,"事業費の構成比（％）"]
[null,null,null,null,null,"エリア",null,"開始月","終了月","総額","国費","連携先負担","国費割合","連携先負担割合"]
[null,1,null,null,null,null,null,null,null,{"$f":"K4+L4","v":0},null,null,{"$f":"IF(K4>0,K4/J4,\"\")","v":""},{"$f":"IF(L4>0,L4/J4,\"\")","v":""}]
[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":0},{"$f":"SUM(K4:K5)","v":0},{"$f":"SUM(L4:L5)","v":0},"",""]

{"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],[3,1,6,2],[3,6,4,7],[3,8,4,12],[3,13,6,13],[5,6,6,7],[5,8,6,12],[8,1,9,3],[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],[9,4,9,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],[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],[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]]}
[null,"事業計画",null,null,"年度\n（西暦）",2022,"実施部署",null,{"$f":"IF('プロジェクトリスト(様式1-1)'!L1=\"\",\"\",'プロジェクトリスト(様式1-1)'!L1)","v":"関東運輸局"},null,null,"プロジェクト名",null,{"$f":"IF($I$2=\"\",\"\",VLOOKUP($I$2,'プロジェクトリスト(様式1-1)'!$B$4:$I$5,2,FALSE))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"更新日"]
[null,null,null,null,null,null,"事業番号",null,1,null,null,"継続年",null,{"$f":"IF($I$2=\"\",\"\",VLOOKUP($I$2,'プロジェクトリスト(様式1-1)'!$B$4:$I$5,3,FALSE))","v":0},"実施期間",null,null,null,"～",null,null,"担当者"]
[]
[null,"事業費",null,null,"金額(千円)","率（％）","対象市場\n（国名等）",null,{"$f":"IF($I$2=\"\",\"\",VLOOKUP($I$2,'プロジェクトリスト(様式1-1)'!$B$4:$I$5,6,FALSE))","v":0},null,null,null,null,"事業主体\n（連携先等）","広域組織\n（DMO、協議会等）"]
[null,null,null,"総事業費",{"$f":"IFERROR(E6+E7,\"\")","v":0},{"$f":"IFERROR((IF(E5,E5/E5,\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,"地方自治体"]
[null,null,null,"国費",{"$f":"IF($I$2=\"\",\"\",VLOOKUP($I$2,'プロジェクトリスト(様式1-1)'!$B$4:$L$5,10,FALSE))","v":0},{"$f":"IFERROR((IF(E5>0,E6/E5,\"\")),\"\")","v":""},"国内対象地域\n（都道府県）",null,null,null,null,null,null,null,"観光団体(観光協会等)"]
[null,null,null,"連携先",{"$f":"IF($I$2=\"\",\"\",VLOOKUP($I$2,'プロジェクトリスト(様式1-1)'!$B$4:$L$5,11,FALSE))","v":0},{"$f":"IFERROR((IF(E5>0,E7/E5,\"\")),\"\")","v":""},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,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,null,null,null,"JNTOによる\n助言の反映状況"]
[null,"目的"]
[null,"期待される効果",null,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,"過年度事業からの改善点\n※外部有識者による\n評価の反映状況を含む"]

{"sheet":"事業計画②(様式1-3)","index":3,"n_rows":15,"n_cols":36,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,15,8,18],[8,22,8,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],[7,3,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,18],[7,31,7,34],[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,1,"プロジェクト名",null,{"$f":"IF($D$1=\"\",\"\",VLOOKUP($D$1,'プロジェクトリスト(様式1-1)'!$B$4:$E$5,2,FALSE))","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U4+V4","v":0}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,5,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:T8)","v":0},{"$f":"SUM(U4:U8)","v":0},{"$f":"SUM(V4:V8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"チェック用：様式1-1事業費計",{"$f":"IF($D$1=\"\",0,VLOOKUP($D$1,'プロジェクトリスト(様式1-1)'!$B$4:$L$23,9,FALSE))","v":0},{"$f":"IF($D$1=\"\",0,VLOOKUP($D$1,'プロジェクトリスト(様式1-1)'!$B$4:$L$23,10,FALSE))","v":0},{"$f":"IF($D$1=\"\",0,VLOOKUP($D$1,'プロジェクトリスト(様式1-1)'!$B$4:$L$23,11,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T9=T10,\"OK\",\"×\")","v":"OK"},{"$f":"IF(U9=U10,\"OK\",\"×\")","v":"OK"},{"$f":"IF(V9=V10,\"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,0,7,0],[4,1,7,1],[3,8,3,10],[3,13,3,17],[3,19,3,21],[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]]}
["令和４年度　地域の観光資源を活用したプロモーション事業",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":""},1]
[null,null,2]
[null,null,3]
[null,null,4]