{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["利用目的選択","貸切項目入力","貸切印刷 ","貸切依頼内容","送迎項目入力","送迎印刷","送迎依頼内容 ","車種","貸切料金","貸切料金2","貸切料金計算 ","送迎料金計算","送迎料金","送迎料金2","各種"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":55,"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":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3],[20,9,20,11],[20,1,20,7]]}
["利用目的選択"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(貸切依頼内容!C38=各種!O5,\"貸切依頼作成済み\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('送迎依頼内容 '!C37=各種!O5,\"送迎依頼作成済み\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MK使用欄",null,null,null,null,null,null,"Ver.","1.1"]
[]
[null,null,"貸切","項目入力","印刷画面","予約依頼",null,"送迎","項目入力","印刷画面","予約依頼"]

{"sheet":"貸切項目入力","index":1,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[20,1,20,4],[27,7,28,12],[37,1,39,1],[34,11,34,12],[32,5,32,6],[37,5,37,6],[27,3,27,4],[38,5,38,6],[30,5,30,12],[22,1,25,2],[27,1,30,2],[28,3,28,4],[29,3,29,4],[30,3,30,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[22,5,22,6],[23,5,23,6],[27,5,27,6],[24,5,24,12],[25,5,25,12],[44,1,44,4],[29,5,29,12],[42,5,42,6],[43,5,43,6],[44,5,44,6],[42,7,42,8],[43,7,43,8],[44,7,44,8],[42,1,42,4],[43,1,43,4],[60,5,60,10],[61,5,61,10],[63,5,63,10],[42,10,42,11],[43,10,43,11],[44,10,44,11],[59,1,59,10],[51,1,57,2],[57,3,57,4],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,7],[56,5,56,7],[57,5,57,7],[0,0,0,3],[16,5,16,6],[17,5,17,6],[16,3,16,4],[17,3,17,4],[16,1,18,2],[18,3,18,4],[28,5,28,6],[39,5,39,6],[32,1,32,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[61,1,61,4],[63,1,63,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[60,1,60,4],[56,3,56,4]]}
["貸切項目入力",null,null,null,null,"利用目的","観光/時間貸切"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["簡易シュミレーション入力項目"]
[null,"車輛選択",null,"車輛クラス",null,"選択してください",null,{"$f":"IF(OR(F17=\"スタンダード\",F17=\"ハイグレードセダン\"),\"※17：00～19：00/AM5:00～7：00の時間帯をまたぐ手配はできない場合がある車種です。\",\"\")","v":""}]
[null,null,null,"車種",null,"選択してください",null,{"$f":"IF(OR(F17=\"スタンダード\",F17=\"ハイグレードセダン\"),\"※車両情報/ドライバー情報を事前にお知らせできない車輛クラスです。\",\"\")","v":""}]
[null,null,null,"台数",null,"選択してください",{"$f":"IF(F19=各種!H7,\"※４台以上のお手配は、京都エムケイ外商部に電話・メールにてお問い合わせください。\",\"\")","v":""}]
[]
[null,"乗車人数",null,null,null,"選択してください"]
[]
[null,"利用開始",null,"利用開始時間",null,"選択してください",null,"※30分単位での設定のみ可。予約依頼時は実際の利用開始時間を記載いただく欄がございます。"]
[null,null,null,"お迎え先都道府県",null,"選択してください"]
[null,null,null,"お迎え先エリア",null,"選択してください★",null,null,null,null,null,null,null,{"$f":"RIGHT(F25,1)","v":"★"}]
[null,null,null,"お迎え先詳細",null,{"$f":"N26","v":"施設名・住所など詳細をご記載下さい。"},null,null,null,null,null,null,null,"施設名・住所など詳細をご記載下さい。"]
[]
[null,"利用終了",null,"利用終了時間",null,"選択してください",null,{"$f":"IFERROR(IF(F33=\"区域外の為算出不可\",\"※都道府県：京都府　エリア：末尾に★の付いたエリアがお迎え場所かお供先に設定されていない場合、営業区域外での手配となるため、京都エムケイではお受けできません。\",\"\"),\"\")","v":""}]
[null,null,null,"お供先都道府県",null,"選択してください"]
[null,null,null,"お供先エリア",null,"選択してください★",null,null,null,null,null,null,null,{"$f":"RIGHT(F30,1)","v":"★"}]
[null,null,null,"お供先詳細",null,{"$f":"N31","v":"施設名・住所など詳細をご記載下さい。"},null,null,null,null,null,null,null,"施設名・住所など詳細をご記載下さい。"]
[]
[null,"利用時間",null,null,null,{"$f":"IF(N33=0,\"区域外の為算出不可\",VLOOKUP('貸切料金計算 '!F7,'貸切料金計算 '!C10:D58,2,FALSE))","v":0},null,0.41666666666666669,{"$f":"IFERROR(IF(F33>=H33,\"利用時間要確認\",\"\"),\"\")","v":""},null,null,null,null,{"$f":"COUNTIF(N25:N31,\"★\")","v":2}]
[null,null,null,{"$f":"IF(I33=\"利用時間要確認\",\"※京都市内での発着での利用が12時間を目安とし、それを超える場合は対応しておりません。\",\"\")","v":""}]
[null,null,null,{"$f":"IF(I33=\"利用時間要確認\",\"　京都市外発着分は、回送時間を考慮し、上記より短い時間を目安としてください。\",\"\")","v":""}]
[null,null,null,{"$f":"IF(I33=\"利用時間要確認\",\"　上記に該当する場合は、電話・メールにてお問い合わせ下さい。\",\"\")","v":""}]
[]
[null,"外国語対応","必要の有無",null,null,"選択してください"]
[null,null,"言必要な場合の言語",null,null,"選択してください"]
[null,null,"外国語レベル",null,null,"選択してください"]
[]
["お見積もり料金　(税込)"]
[null,null,null,null,null,"単価",null,"合計",null,null,"延長/30分毎"]
[null,"車輛代",null,null,null,{"$f":"IFERROR(IF(N33=0,\"区域外の為算出不可\",'貸切料金計算 '!O3),\"\")","v":""},null,{"$f":"IFERROR(F44*F19,\"\")","v":""},null,null,{"$f":"IFERROR('貸切料金計算 '!N3,\"\")","v":""}]
[null,"英会話料金",null,null,null,{"$f":"IFERROR('貸切料金計算 '!T3+IF(OR(F39=各種!E5,F39=各種!E6),2000,0),\"\")","v":0},null,{"$f":"IFERROR(F45*F19,\"\")","v":""},null,null,{"$f":"'貸切料金計算 '!U4","v":0}]
[null,null,null,"※2025年8月6日時点での料金体系での算出です。以降、料金変更があった場合は上記に限りません。"]
[null,null,null,"※拝観料、駐車料、通行料などは別途発生します。"]
[null,null,null,"※遠方（京都市内発着以外）回送料が含まれた金額でお見積もりしています。"]
[null,null,null,"　（公開料金表は京都市内発着時の料金ですので、本シミュレーションと差異がある場合があります。）　"]
[]
["シュミレーション結果への記載事項"]
[null,"依頼者情報",null,"利用日"]
[null,null,null,"（会社名）"]
[null,null,null,"（部署）"]
[null,null,null,"担当者名/依頼者名",null,null,null,"様"]
[null,null,null,"電話番号"]
[null,null,null,"FAX番号"]
[null,null,null,"メールアドレス"]
[]
[null,"その他経費（通行料・拝観料など必要事項記載可能）"]
[null,"内容"]
[null,"金額　（複数台手配時は合計金額を記載）"]
[]
[null,"シミュレーション備考欄"]

{"sheet":"貸切印刷 ","index":2,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,4],[3,1,4,7],[23,2,23,3],[26,6,26,7],[14,1,14,5],[32,1,32,7],[18,2,18,3],[19,2,19,3],[19,5,19,7],[20,2,20,3],[20,5,20,7],[18,5,18,7],[21,2,21,7]]}
[null,"シミュレーション結果印刷"]
[]
[null,null,null,null,null,null,"発行日",{"$f":"TODAY()","v":"2025-08-27"}]
[null,"シミュレーション結果",null,null,null,null,null,null,null,null,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":"貸切項目入力!F53&貸切項目入力!H53","v":""}]
[null,{"$f":"貸切項目入力!F54&貸切項目入力!H54","v":""}]
[null,{"$f":"貸切項目入力!F55&貸切項目入力!H55","v":"様"}]
[null,{"$f":"\"TEL:\"&貸切項目入力!F56&\"  FAX:\"&貸切項目入力!F57","v":"TEL:  FAX:"},null,null,null,"シミュレーション問合せ先"]
[null,{"$f":"\"Eメール:\"&貸切項目入力!F58","v":"Eメール:"},null,null,null,"〒 601-8432 京都市南区西九条東島町６３－１"]
[null,null,null,null,null,"エムケイ株式会社　外商部"]
[null,"シミュレーションをご利用いただきありがとうございます。",null,null,null,"Tel: 075-757-6212　　Fax: 075-693-9466"]
[null,"下記がシミュレーション結果となりますが、"]
[null,"行程や内容などににより実際とは違う料金になるの場合がございます。"]
[null,"ご理解いただいたうえ、ご予約依頼にお進みください。"]
[]
[null,"利用区内容"]
[null,"ご利用日",{"$f":"貸切項目入力!F52","v":"00:00:00"},null,"分類","ハイヤー貸切"]
[null,"配車時間",{"$f":"貸切項目入力!F23","v":"選択してください"},null,"配車場所",{"$f":"貸切項目入力!F26","v":"施設名・住所など詳細をご記載下さい。"}]
[null,"終了時間",{"$f":"貸切項目入力!F28","v":"選択してください"},null,"終了場所",{"$f":"貸切項目入力!F31","v":"施設名・住所など詳細をご記載下さい。"}]
[null,"車種",{"$f":"貸切項目入力!F18","v":"選択してください"}]
[]
[null,"合計金額",{"$f":"G27","v":{"$error":"#VALUE!"}},null,"（税込）"]
[null,"利用日付","利用時間","台数","車輛単価","外国語対応単価","料金合計","その他"]
[null,{"$f":"貸切項目入力!F52","v":"00:00:00"},{"$f":"貸切項目入力!F33","v":0},{"$f":"貸切項目入力!F19","v":"選択してください"},{"$f":"貸切項目入力!F44","v":""},{"$f":"貸切項目入力!F45","v":0},{"$f":"D26*(E26+F26)","v":{"$error":"#VALUE!"}},{"$f":"貸切項目入力!F62","v":0}]
[null,null,null,null,null,"総計",{"$f":"G26+H26","v":{"$error":"#VALUE!"}}]
[]
[null,"※2025年8月6日時点での料金体系での算出です。以降、料金変更があった場合は上記に限りません。"]
[null,"※拝観料、駐車料、通行料などは別途発生します。"]
[null,{"$f":"IFERROR(\"※延長時は「延長料(車両1台に付き)：車両代 \"&貸切項目入力!K44&\"円/30分毎　外国語対応料\"&貸切項目入力!K45&\"/円30分毎」\"&\"を追加請求いたします。\",\"\")","v":"※延長時は「延長料(車両1台に付き)：車両代 円/30分毎　外国語対応料0/円30分毎」を追加請求いたします。"}]
[null,{"$f":"IF(貸切項目入力!F61=\"\",\"\",\"※「その他」は、\"&貸切項目入力!F61&\"。\")","v":""}]
[null,{"$f":"IF(貸切項目入力!G64=\"\",\"\",\"※備考：\"&貸切項目入力!G64)","v":""}]

{"sheet":"貸切依頼内容","index":3,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[14,5,14,6],[6,2,6,4],[7,2,7,4],[21,2,21,4],[22,2,22,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[18,2,18,4],[16,2,16,4],[17,2,17,4],[23,2,23,4],[41,7,41,9],[42,7,42,9],[43,7,43,9],[34,1,36,1],[36,2,36,4],[28,2,28,4],[33,5,33,10],[32,5,32,14],[0,1,0,2],[19,2,19,4],[5,1,5,4],[38,2,38,4],[33,2,33,4],[37,2,37,4],[25,2,25,4],[26,2,26,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[35,2,35,4],[34,2,34,4],[24,2,24,4],[27,2,27,4]]}
[null,"ハイヤー貸切依頼"]
[]
[]
[null,"下記の空欄に必要事項を選択/記載して下さい。"]
[]
[null,{"$f":"B1&\"書\"","v":"ハイヤー貸切依頼書"}]
[null,"会社名or名前\n（会社名優先）",{"$f":"IF(貸切項目入力!F53=\"\",貸切項目入力!F55,貸切項目入力!F53)","v":0}]
[null,"部署",{"$f":"IF(貸切項目入力!F54=\"\",\"\",貸切項目入力!F54)","v":""}]
[null,"名前",{"$f":"IF(貸切項目入力!F55=\"\",各種!Q3,貸切項目入力!F55)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"TEL",{"$f":"IF(貸切項目入力!F56=\"\",各種!Q3,貸切項目入力!F56)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"FAX",{"$f":"IF(貸切項目入力!F57=\"\",各種!Q3,貸切項目入力!F57)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"メールアドレス",{"$f":"IF(貸切項目入力!F58=\"\",各種!Q3,貸切項目入力!F58)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"分類","選択してください"]
[null,"利用日",{"$f":"IF(貸切項目入力!F52=\"\",各種!Q3,貸切項目入力!F52)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"利用開始時間\n(シミュレーション時間）",{"$f":"IF(貸切項目入力!F23=各種!D3,各種!Q4,貸切項目入力!F23)","v":"「項目入力」ページの入力項目へ選択/入力してください"},"実際に手配したい開始時間",{"$f":"C15","v":"「項目入力」ページの入力項目へ選択/入力してください"},"※24時間表示で入力\n例（PM9:00＝21：00）"]
[null,"終了時間\n(シミュレーション時間)",{"$f":"IF(貸切項目入力!F28=各種!D3,各種!Q4,貸切項目入力!F28)","v":"「項目入力」ページの入力項目へ選択/入力してください"},"右記の時間まで利用可能",{"$f":"E15+C17","v":{"$error":"#VALUE!"}}]
[null,"貸切時間",{"$f":"貸切項目入力!$F$33","v":"00:00:00"}]
[null,"乗車人数",{"$f":"IF(貸切項目入力!F21=貸切料金2!B30,各種!Q4,貸切項目入力!F21)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"グレード",{"$f":"IF(貸切項目入力!F17=貸切料金2!B30,各種!Q4,貸切項目入力!F17)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"車種",{"$f":"IF(貸切項目入力!F18=各種!D3,各種!Q4,貸切項目入力!F18)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"言語",{"$f":"IF(貸切項目入力!F38=各種!D3,各種!Q4,貸切項目入力!F38)","v":"「項目入力」ページの入力項目へ選択/入力してください"},{"$f":"IF(貸切項目入力!F39=\"選択してください\",\"\",貸切項目入力!F39)","v":""},{"$f":"IF(貸切項目入力!F40=\"選択してください\",\"\",貸切項目入力!F40)","v":""}]
[null,"台数",{"$f":"IF(貸切項目入力!F19=各種!D3,各種!Q4,貸切項目入力!F19)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"区分","貸切"]
[null,"お迎え先(都道府県）",{"$f":"IF(貸切項目入力!F24=貸切料金2!B30,各種!Q4,貸切項目入力!F24)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お迎え先（エリア）",{"$f":"IF(貸切項目入力!F25=貸切料金2!F4,各種!Q4,貸切項目入力!F25)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お迎え先（詳細）",{"$f":"IF(貸切項目入力!F26=貸切項目入力!N26,各種!Q4,貸切項目入力!F247)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お供先(都道府県）",{"$f":"IF(貸切項目入力!F29=貸切料金2!B30,各種!Q4,貸切項目入力!F29)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お供先（エリア）",{"$f":"IF(貸切項目入力!F30=貸切料金2!F4,各種!Q4,貸切項目入力!F30)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お供先（詳細）",{"$f":"IF(貸切項目入力!F31=貸切項目入力!N31,各種!Q4,貸切項目入力!F31)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"請求方法","選択してください",null,null,{"$f":"IF(C30=各種!L9,\"☞会員No.が必要です。過去の請求書などで確認し、下記に記載ください。\",\"\")","v":""}]
[null,"乗客名/利用者名","（ご依頼者様と同じであっても）入力して下さい",null,null,{"$f":"IF(C30=各種!L9,\"　会員No.がの記載がない場合は現金支払いとします。\",\"\")","v":""}]
[null,"当日連絡先","ここに入力して下さい",null,null,null,{"$f":"IF(C30=各種!L9,\"7桁\",\"\")","v":""},{"$f":"IF(C30=各種!L9,\"-\",\"\")","v":""},{"$f":"IF(C30=各種!L9,\"4桁\",\"\")","v":""}]
[null,"備考\n（お手配に関し、その他ご希望などあればご記載ください）"]
[null,"車番情報連絡希望","必要ない",null,null,{"$f":"IF(C34=各種!M9,\"☞連絡はご利用日前日の夕方以降にメールでの連絡となります。\",\"\")","v":""}]
[null,"確認事項","選択してください"]
[null,null,{"$f":"IF(C35=各種!P6,\"①予約番号/受注番号をお持ちの場合は上記備考欄に記載下さい。\",\"\")","v":""}]
[null,null,{"$f":"IF(C35=各種!P6,\"②欄外右にある「注意事項」に準じないと判断した場合、本見積は適応されない場合がありあす。\",\"\")","v":""}]
[null,"確認","選択してください"]
[null,"依頼・メール送信日","ここに入力して下さい"]
[]
[null,"車輛単価",{"$f":"'貸切印刷 '!E26","v":""},null,null,null,"メールソフトが立ち上がらない場合は下記にお送りください。"]
[null,"外国語対応単価",{"$f":"'貸切印刷 '!F26","v":0},null,null,null,"メール","gaisyo@mk-group.co.jp"]
[null,"料金合計",{"$f":"'貸切印刷 '!G26","v":{"$error":"#VALUE!"}},null,null,null,"件名","新規貸切手配依頼【シミュレーションExcelより】"]
[null,"その他",{"$f":"'貸切印刷 '!H26","v":0},null,null,null,"添付データ","このシートを表示した状態で保存した本Excelデータ"]
[null,"総計",{"$f":"'貸切印刷 '!G27","v":{"$error":"#VALUE!"}}]
[null,{"$f":"'貸切印刷 '!B31","v":"※延長時は「延長料(車両1台に付き)：車両代 円/30分毎　外国語対応料0/円30分毎」を追加請求いたします。"}]
[null,{"$f":"'貸切印刷 '!B32","v":""}]

{"sheet":"送迎項目入力","index":4,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[[20,1,20,4],[27,7,28,12],[32,5,32,6],[54,3,54,4],[0,0,0,3],[16,1,18,2],[22,1,25,2],[27,1,30,2],[27,5,27,6],[28,5,28,6],[29,5,29,12],[30,5,30,12],[22,5,22,6],[23,5,23,6],[24,5,24,12],[25,5,25,12],[34,5,34,6],[35,5,35,6],[36,5,36,6],[34,2,34,4],[35,2,35,4],[36,2,36,4],[39,5,39,6],[40,5,40,6],[41,5,41,6],[39,1,39,4],[40,1,40,4],[41,1,41,4],[39,7,39,8],[40,7,40,8],[41,7,41,8],[39,10,39,11],[40,10,40,11],[41,10,41,11],[57,1,57,4],[58,1,58,4],[57,5,57,10],[58,5,58,10],[60,1,60,4],[60,5,60,10],[56,1,56,10],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[53,5,53,6],[54,5,54,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[16,5,16,6],[17,5,17,6],[16,3,16,4],[17,3,17,4],[18,3,18,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[32,1,32,4],[48,1,54,2],[34,1,36,1]]}
["送迎項目入力",null,null,null,null,"利用目的","送迎"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["簡易シュミレーション入力項目"]
[null,"車輛選択",null,"車輛クラス",null,"選択してください",null,{"$f":"IF(OR(F17=\"スタンダード\",F17=\"ハイグレードセダン\"),\"※17：00～19：00/AM5:00～7：00の時間帯をまたぐ手配はできない場合がある車種です。\",\"\")","v":""}]
[null,null,null,"車種",null,"選択してください",null,{"$f":"IF(OR(F17=\"スタンダード\",F17=\"ハイグレードセダン\"),\"※車両情報/ドライバー情報を事前にお知らせできない車輛クラスです。\",\"\")","v":""}]
[null,null,null,"台数",null,"選択してください",{"$f":"IF(F19=各種!H7,\"※４台以上のお手配は、京都エムケイ外商部に電話・メールにてお問い合わせください。\",\"\")","v":""}]
[]
[null,"乗車人数",null,null,null,"選択してください"]
[]
[null,"お迎え",null,"お迎え時間",null,"選択してください",null,"※30分単位での設定のみ可。予約依頼時は実際の利用開始時間を記載いただく欄がございます。"]
[null,null,null,"お迎え先都道府県",null,"選択してください"]
[null,null,null,"お迎え先エリア",null,"選択してください★",null,null,null,null,null,null,null,{"$f":"RIGHT(F25,1)","v":"★"}]
[null,null,null,"お迎え先詳細",null,"施設名・住所など詳細をご記載下さい。",null,null,null,null,null,null,null,"施設名・住所など詳細をご記載下さい。"]
[]
[null,"行先情報",null,"利用終了時間",null,{"$f":"IFERROR(F23+F33,\"算出不可\")","v":"算出不可"},null,{"$f":"IF(F33=\"区域外の為算出不可\",\"※都道府県：京都府　エリア：末尾に★の付いたエリアがお迎え場所かお供先に設定されていない場合、営業区域外での手配となるため、京都エムケイではお受けできません。\",\"\")","v":""}]
[null,null,null,"お供先都道府県",null,"選択してください"]
[null,null,null,"お供先エリア",null,"選択してください★",null,null,null,null,null,null,null,{"$f":"RIGHT(F30,1)","v":"★"}]
[null,null,null,"お供先詳細",null,{"$f":"N31","v":"施設名・住所など詳細をご記載下さい。"},null,null,null,null,null,null,null,"施設名・住所など詳細をご記載下さい。"]
[]
[null,"利用時間",null,null,null,{"$f":"IF(N33=0,\"区域外の為算出不可\",送迎料金計算!E12)","v":0},null,"以内",null,null,null,null,null,{"$f":"COUNTIF(N25:N31,\"★\")","v":2}]
[]
[null,"外国語対応","必要の有無",null,null,"選択してください"]
[null,null,"言必要な場合の言語",null,null,"選択してください"]
[null,null,"外国語レベル",null,null,"選択してください"]
[]
["お見積もり料金　(税込)"]
[null,null,null,null,null,"単価",null,"合計",null,null,"延長/30分毎"]
[null,"車輛代",null,null,null,{"$f":"IFERROR(IF(N33=0,\"区域外の為算出不可\",送迎料金計算!N11),\"\")","v":""},null,{"$f":"IFERROR(F41*F19,\"\")","v":""},null,null,{"$f":"IFERROR(送迎料金計算!M11,\"\")","v":""}]
[null,"英会話料金",null,null,null,{"$f":"IFERROR(送迎料金計算!S11+IF(OR(F36=各種!E5,F36=各種!E6),2000,0),\"\")","v":""},null,{"$f":"IFERROR(F42*F19,\"\")","v":""},null,null,{"$f":"送迎料金計算!T11","v":0}]
[null,null,null,"※2025年8月6日時点での料金体系での算出です。以降、料金変更があった場合は上記に限りません。"]
[null,null,null,"※拝観料、駐車料、通行料などは別途発生します。"]
[null,null,null,"※遠方（京都市内発着以外）回送料が含まれた金額でお見積もりしています。"]
[null,null,null,"　（公開料金表は京都市内発着時の料金ですので、本シミュレーションと差異がある場合があります。）　"]
[]
["シュミレーション結果への記載事項"]
[null,"依頼者情報",null,"利用日"]
[null,null,null,"（会社名）"]
[null,null,null,"（部署）"]
[null,null,null,"担当者名/依頼者名",null,null,null,"様"]
[null,null,null,"電話番号"]
[null,null,null,"FAX番号"]
[null,null,null,"メールアドレス"]
[]
[null,"その他経費（通行料・拝観料など必要事項記載可能）"]
[null,"内容"]
[null,"金額　（複数台手配時は合計金額を記載）"]
[]
[null,"シミュレーション備考欄"]

{"sheet":"送迎印刷","index":5,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,4],[3,1,4,7],[32,1,32,7],[18,2,18,3],[18,5,18,7],[26,6,26,7],[19,2,19,3],[20,2,20,3],[23,2,23,3],[19,5,19,7],[20,5,20,7],[21,2,21,7],[31,1,31,7],[14,1,14,5]]}
[null,"シミュレーション結果印刷"]
[]
[null,null,null,null,null,null,"発行日",{"$f":"TODAY()","v":"2025-08-27"}]
[null,"シミュレーション結果",null,null,null,null,null,null,null,null,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":"送迎項目入力!F50&送迎項目入力!H50","v":""}]
[null,{"$f":"送迎項目入力!F51&送迎項目入力!H51","v":""}]
[null,{"$f":"送迎項目入力!F52&送迎項目入力!H52","v":"様"}]
[null,{"$f":"\"TEL:\"&送迎項目入力!F53&\"  FAX:\"&送迎項目入力!F54","v":"TEL:  FAX:"},null,null,null,"お見積もり問合せ先"]
[null,{"$f":"\"Eメール:\"&送迎項目入力!F55","v":"Eメール:"},null,null,null,"〒 601-8432 京都市南区西九条東島町６３－１"]
[null,null,null,null,null,"エムケイ株式会社　外商部"]
[null,"シミュレーションをご利用いただきありがとうございます。",null,null,null,"Tel: 075-757-6212　　Fax: 075-693-9466"]
[null,"下記がシミュレーション結果となりますが、"]
[null,"行程や内容などににより実際とは違う料金になる場合がございます。"]
[null,"ご理解いただいたうえ、予約依頼にお進みください。"]
[]
[null,"利用区内容"]
[null,"ご利用日",{"$f":"送迎項目入力!F49","v":"00:00:00"},null,"分類","ハイヤー送迎"]
[null,"配車時間",{"$f":"送迎項目入力!F23","v":"選択してください"},null,"配車場所",{"$f":"送迎項目入力!F26","v":"施設名・住所など詳細をご記載下さい。"}]
[null,"終了時間",{"$f":"送迎項目入力!F28","v":"算出不可"},null,"終了場所",{"$f":"送迎項目入力!F31","v":"施設名・住所など詳細をご記載下さい。"}]
[null,"車種",{"$f":"送迎項目入力!F18","v":"選択してください"}]
[]
[null,"合計金額",{"$f":"G27","v":{"$error":"#VALUE!"}},null,"（税込）"]
[null,"利用日付","利用時間","台数","車輛単価","外国語対応単価","料金合計","その他"]
[null,{"$f":"送迎項目入力!F49","v":"00:00:00"},{"$f":"送迎項目入力!F33","v":0},{"$f":"送迎項目入力!F19","v":"選択してください"},{"$f":"送迎項目入力!F41","v":""},{"$f":"送迎項目入力!F42","v":""},{"$f":"D26*(E26+F26)","v":{"$error":"#VALUE!"}},{"$f":"送迎項目入力!F59","v":0}]
[null,null,null,null,null,"総計",{"$f":"G26+H26","v":{"$error":"#VALUE!"}}]
[]
[null,"※2025年8月6日時点での料金体系での算出です。以降、料金変更があった場合は上記に限りません。"]
[null,"※拝観料、駐車料、通行料などは別途発生します。"]
[null,{"$f":"IFERROR(\"※延長時は「延長料(車両1台に付き)：車両代 \"&送迎項目入力!K41&\"円/30分毎　外国語対応料\"&送迎項目入力!K42&\"/円30分毎」\"&\"を追加請求いたします。\",\"\")","v":"※延長時は「延長料(車両1台に付き)：車両代 円/30分毎　外国語対応料0/円30分毎」を追加請求いたします。"}]
[null,{"$f":"IF(送迎項目入力!F58=\"\",\"\",\"※「その他」は、\"&送迎項目入力!F58&\"。\")","v":""}]
[null,{"$f":"IF(送迎項目入力!F61=\"\",\"\",\"※備考：\"&送迎項目入力!F61)","v":""}]

{"sheet":"送迎依頼内容 ","index":6,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[14,5,14,6],[23,2,23,4],[24,2,24,4],[26,2,26,4],[27,2,27,4],[16,2,16,4],[42,7,42,9],[0,1,0,2],[40,7,40,9],[41,7,41,9],[31,5,31,14],[9,2,9,4],[10,2,10,4],[11,2,11,4],[18,2,18,4],[30,2,30,4],[31,2,31,4],[13,2,13,4],[17,2,17,4],[5,1,5,4],[37,2,37,4],[19,2,19,4],[36,2,36,4],[21,2,21,4],[22,2,22,4],[25,2,25,4],[28,2,28,4],[29,2,29,4],[33,1,35,1],[6,2,6,4],[7,2,7,4],[8,2,8,4],[12,2,12,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[32,2,32,4]]}
[null,"ハイヤー送迎依頼"]
[]
[]
[null,"下記の空欄に必要事項を選択/記載して下さい。"]
[]
[null,{"$f":"B1&\"書\"","v":"ハイヤー送迎依頼書"}]
[null,"会社名or名前\n（会社名優先）",{"$f":"IF(送迎項目入力!F50=\"\",送迎項目入力!F52,送迎項目入力!F50)","v":0}]
[null,"部署",{"$f":"IF(送迎項目入力!F51=\"\",\"\",送迎項目入力!F51)","v":""}]
[null,"依頼者名",{"$f":"IF(送迎項目入力!F52=\"\",各種!Q3,送迎項目入力!F52)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"TEL",{"$f":"IF(送迎項目入力!F53=\"\",各種!Q3,送迎項目入力!F53)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"FAX",{"$f":"IF(送迎項目入力!F54=\"\",各種!Q3,送迎項目入力!F54)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"メールアドレス",{"$f":"IF(送迎項目入力!F55=\"\",各種!Q3,送迎項目入力!F55)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"分類","選択してください"]
[null,"利用日",{"$f":"IF(送迎項目入力!F49=\"\",各種!Q3,送迎項目入力!F49)","v":"「項目入力」ページのシュミレーション結果記載事項に入力してください"}]
[null,"利用開始時間\n(シミュレーション時間）",{"$f":"IF(送迎項目入力!F23=各種!D3,各種!Q4,送迎項目入力!F23)","v":"「項目入力」ページの入力項目へ選択/入力してください"},"実際に手配したい\n利用開始時間",{"$f":"IF(送迎項目入力!F23=各種!B21,各種!Q4,送迎項目入力!F23)","v":"「項目入力」ページの入力項目へ選択/入力してください"},"※24時間表示で入力\n例（PM9:00＝21：00）"]
[null,"利用可能時間",{"$f":"送迎項目入力!F33","v":0},"以内"]
[null,"乗車人数",{"$f":"IF(送迎項目入力!F21=送迎料金2!B30,各種!Q4,送迎項目入力!F214)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"グレード",{"$f":"IF(送迎項目入力!F17=各種!D3,各種!Q4,送迎項目入力!F17)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"車種",{"$f":"IF(送迎項目入力!F18=各種!D3,各種!Q4,送迎項目入力!F18)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"台数",{"$f":"IF(送迎項目入力!F19=各種!D3,各種!Q4,送迎項目入力!F19)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"言語",{"$f":"IF(送迎項目入力!F35=各種!D3,各種!Q4,送迎項目入力!F35)","v":"「項目入力」ページの入力項目へ選択/入力してください"},{"$f":"IF(送迎項目入力!F36=\"選択してください\",\"\",送迎項目入力!F36)","v":""},{"$f":"IF(送迎項目入力!F37=\"選択してください\",\"\",送迎項目入力!F37)","v":""}]
[null,"区分","送迎"]
[null,"お迎え先(都道府県）",{"$f":"IF(送迎項目入力!F24=送迎料金2!B30,各種!Q4,送迎項目入力!F24)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お迎え先（エリア）",{"$f":"IF(送迎項目入力!F25=送迎料金2!F4,各種!Q4,送迎項目入力!F25)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お迎え先（詳細）",{"$f":"IF(送迎項目入力!F26=送迎項目入力!N26,各種!Q4,送迎項目入力!F26)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お供先(都道府県）",{"$f":"IF(送迎項目入力!F29=送迎料金2!B30,各種!Q4,送迎項目入力!F29)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お供先（エリア）",{"$f":"IF(送迎項目入力!F30=送迎料金2!N4,各種!Q4,送迎項目入力!F30)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"お供先（詳細）",{"$f":"IF(送迎項目入力!F31=送迎項目入力!N31,各種!Q4,送迎項目入力!F31)","v":"「項目入力」ページの入力項目へ選択/入力してください"}]
[null,"請求方法","選択してください",null,null,{"$f":"IF(C29=各種!L9,\"☞会員No.が必要です。過去の請求書などで確認し、下記に記載ください。\",\"\")","v":""}]
[null,"乗客名/利用者名","（ご依頼者様と同じであっても）入力して下さい",null,null,{"$f":"IF(C29=各種!L9,\"　会員No.がの記載がない場合は現金支払いとします。\",\"\")","v":""}]
[null,"当日連絡先","ここに入力して下さい",null,null,null,{"$f":"IF(C29=各種!L9,\"7桁\",\"\")","v":""},{"$f":"IF(C29=各種!L9,\"-\",\"\")","v":""},{"$f":"IF(C29=各種!L9,\"4桁\",\"\")","v":""}]
[null,"備考\n（お手配に関し、その他ご希望などあればご記載ください）"]
[null,"車番情報連絡希望","必要ない",null,null,{"$f":"IF(C33=各種!M9,\"☞連絡はご利用日前日の夕方以降にメールでの連絡となります。\",\"\")","v":""}]
[null,"確認事項","本依頼に関連する別日/別時間帯/別車両利用の依頼が別途ある"]
[null,null,{"$f":"IF(C34=各種!P6,\"①予約番号/受注番号をお持ちの場合は上記備考欄に記載下さい。\",\"\")","v":"①予約番号/受注番号をお持ちの場合は上記備考欄に記載下さい。"}]
[null,null,{"$f":"IF(C34=各種!P6,\"②欄外右にある「注意事項」に準じないと判断した場合、本見積は適応されない場合がありあす。\",\"\")","v":"②欄外右にある「注意事項」に準じないと判断した場合、本見積は適応されない場合がありあす。"}]
[null,"確認","選択してください"]
[null,"依頼・メール送信日","ここに入力して下さい"]
[]
[null,"車輛単価",{"$f":"送迎印刷!E26","v":""},null,null,null,"メールソフトが立ち上がらない場合は下記にお送りください。"]
[null,"外国語対応単価",{"$f":"送迎印刷!F26","v":""},null,null,null,"メール","gaisyo@mk-group.co.jp"]
[null,"料金合計",{"$f":"送迎印刷!G26","v":{"$error":"#VALUE!"}},null,null,null,"件名","新規送迎手配依頼【シミュレーションExcelより】"]
[null,"その他",{"$f":"送迎印刷!H26","v":0},null,null,null,"添付データ","このシートを表示した状態で保存した本Excelデータ"]
[null,"総計",{"$f":"送迎印刷!G27","v":{"$error":"#VALUE!"}}]
[null,{"$f":"送迎印刷!B31","v":"※延長時は「延長料(車両1台に付き)：車両代 円/30分毎　外国語対応料0/円30分毎」を追加請求いたします。"}]
[null,{"$f":"送迎印刷!B32","v":""}]

{"sheet":"車種","index":7,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
[]
["車種一覧"]
["車種",null,null,null,"1時間料金","30分料金","乗車定員"]
["スタンダード",{"$f":"COUNTIF(A$4:A4,A4)","v":1},{"$f":"A4&B4","v":"スタンダード1"},"普通車タクシー",9030,3010,4,null,"料金などの変更","①カラー枠を修正"]
["スタンダード",{"$f":"COUNTIF(A$4:A5,A5)","v":2},{"$f":"A5&B5","v":"スタンダード2"},"ミニバンタクシー",13040,3010,6]
[null,{"$f":"COUNTIF(A$4:A6,A6)","v":0},"0",null,null,null,null,null,"車種を増やす","①行の挿入"]
["ハイグレードセダン",{"$f":"COUNTIF(A$4:A7,A7)","v":1},"ハイグレードセダン1","ベンツEQS",17050,3010,4,null,null,"②カラーセルに項目追加"]
["ハイグレードセダン",{"$f":"COUNTIF(A$4:A8,A8)","v":2},"ハイグレードセダン2","ベンツEQE",17050,3010,4,null,null,"③BC列はうえのセルからダウンコピー"]
["ハイグレードセダン",{"$f":"COUNTIF(A$4:A9,A9)","v":3},"ハイグレードセダン3","BMW ix",17050,3010,4]
["ハイグレードセダン",{"$f":"COUNTIF(A$4:A10,A10)","v":4},"ハイグレードセダン4","BMW i7(TAXI)",20050,3010,4]
[null,{"$f":"COUNTIF(A$4:A11,A11)","v":0},"0"]
["ジャンボ",{"$f":"COUNTIF(A$4:A12,A12)","v":1},"ジャンボ1","ハイエース/キャラバン",15400,3850,9]
["ジャンボ",{"$f":"COUNTIF(A$4:A13,A13)","v":2},"ジャンボ2","ブラックシートハイエース",17400,3580,9]
["ジャンボ",{"$f":"COUNTIF(A$4:A14,A14)","v":3},"ジャンボ3","ラグジュラリーワゴン",20400,3850,9]
[null,{"$f":"COUNTIF(A$4:A15,A15)","v":0},"0"]
["ビジネス",{"$f":"COUNTIF(A$4:A16,A16)","v":1},"ビジネス1","クラウンHV",14800,3700,4]
["ビジネス",{"$f":"COUNTIF(A$4:A17,A17)","v":2},"ビジネス2","クラウンクロスオーバー",14800,3700,4]
["ビジネス",{"$f":"COUNTIF(A$4:A18,A18)","v":3},"ビジネス3","クラウンセダンFCEV",14800,3700,4]
[null,{"$f":"COUNTIF(A$4:A19,A19)","v":0},"0"]
["ハイグレード\nワゴン",{"$f":"COUNTIF(A$4:A20,A20)","v":1},"ハイグレード\nワゴン1","アルファード/ヴェルファイア",16800,3700,6]
["ハイグレード\nワゴン",{"$f":"COUNTIF(A$4:A21,A21)","v":2},"ハイグレード\nワゴン2","特別仕様アルファード",19800,3700,6]
[null,{"$f":"COUNTIF(A$4:A22,A22)","v":0},"0"]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A23,A23)","v":1},"エグゼクティブ1","ベンツV220ｄ",24800,3700,6]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A24,A24)","v":2},"エグゼクティブ2","レクサスLS500ｈ",23000,4500,4]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A25,A25)","v":3},"エグゼクティブ3","ベンツSクラス",23000,4500,4]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A26,A26)","v":4},"エグゼクティブ4","センチュリーHV",28000,4500,4]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A27,A27)","v":5},"エグゼクティブ5","BMW　i7",28000,4500,4]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A28,A28)","v":6},"エグゼクティブ6","レクサスLM",28000,4500,3]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A29,A29)","v":7},"エグゼクティブ7","ベントレー　ベンティガEWBアズール",74200,4500,3]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A30,A30)","v":8},"エグゼクティブ8","マイバッハSクラス",74200,4500,3]
["エグゼクティブ",{"$f":"COUNTIF(A$4:A31,A31)","v":9},"エグゼクティブ9","マイバッハSクラスGLS",74200,4500,3]
[]
[]
[null,"貸切車種選択プルダウン候補"]
[null,"選択してください",null,null,"選択してください","選択してください",null,"選択してください"]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},1,{"$f":"B36&C36","v":"選択してください1"},{"$f":"IFERROR(VLOOKUP(D36,C:D,2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP(貸切項目入力!F18,D:G,4,FALSE)<=0,\"\",VLOOKUP(貸切項目入力!F18,D:G,4,FALSE))","v":{"$error":"#N/A"}},null,"スタンダード"]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},2,{"$f":"B37&C37","v":"選択してください2"},{"$f":"IFERROR(VLOOKUP(D37,C:D,2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-1<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-1)","v":{"$error":"#N/A"}},null,"ハイグレードセダン"]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},3,"選択してください3","",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-2<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-2)","v":{"$error":"#N/A"}},null,"ジャンボ"]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},4,"選択してください4","",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-3<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-3)","v":{"$error":"#N/A"}},null,"ビジネス"]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},5,"選択してください5","",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-4<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-4)","v":{"$error":"#N/A"}},null,"ハイグレード\nワゴン"]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},6,"選択してください6","",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-5<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-5)","v":{"$error":"#N/A"}},null,"エグゼクティブ"]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},7,"選択してください7","",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-6<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-6)","v":{"$error":"#N/A"}}]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},8,"選択してください8","",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-7<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-7)","v":{"$error":"#N/A"}}]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},9,"選択してください9","",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-8<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-8)","v":{"$error":"#N/A"}}]
[null,{"$f":"貸切項目入力!F$17","v":"選択してください"},10,{"$f":"B45&C45","v":"選択してください10"},"",{"$f":"IF(VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-9<=0,\"\",VLOOKUP(貸切項目入力!F$18,D:G,4,FALSE)-9)","v":{"$error":"#N/A"}}]
[]
[null,"送迎車種選択プルダウン候補"]
[null,null,null,null,"選択してください","選択してください",null,"選択してください"]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},1,{"$f":"B49&C49","v":"選択してください1"},{"$f":"IFERROR(VLOOKUP(D49,C:D,2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE))","v":{"$error":"#N/A"}},null,"スタンダード"]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},2,{"$f":"B50&C50","v":"選択してください2"},{"$f":"IFERROR(VLOOKUP(D50,C:D,2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-1<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-1)","v":{"$error":"#N/A"}},null,"ハイグレードセダン"]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},3,"選択してください3","",{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-2<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-2)","v":{"$error":"#N/A"}},null,"ジャンボ"]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},4,"選択してください4","",{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-3<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-3)","v":{"$error":"#N/A"}},null,"ビジネス"]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},5,"選択してください5","",{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-4<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-4)","v":{"$error":"#N/A"}},null,"ハイグレード\nワゴン"]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},6,"選択してください6","",{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-5<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-5)","v":{"$error":"#N/A"}},null,"エグゼクティブ"]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},7,"選択してください7","",{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-6<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-6)","v":{"$error":"#N/A"}}]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},8,"選択してください8","",{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-7<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-7)","v":{"$error":"#N/A"}}]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},9,"選択してください9","",{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-8<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-8)","v":{"$error":"#N/A"}}]
[null,{"$f":"送迎項目入力!F$17","v":"選択してください"},10,{"$f":"B58&C58","v":"選択してください10"},{"$f":"IFERROR(VLOOKUP(D58,C:D,2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-9<=0,\"\",VLOOKUP(送迎項目入力!F$18,D:G,4,FALSE)-9)","v":{"$error":"#N/A"}}]

{"sheet":"貸切料金","index":8,"n_rows":98,"n_cols":8,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"迎車設定で選択されたエリア",{"$f":"貸切項目入力!F24&送迎項目入力!F25","v":"選択してください選択してください★"}]
[null,null,"返車設定で選択されたエリア",{"$f":"貸切項目入力!F29&送迎項目入力!F30","v":"選択してください選択してください★"}]
[null,null,null,null,null,"規定"]
["北海道",{"$f":"COUNTIF(A$2:A5,A5)","v":1},{"$f":"A5&B5","v":"北海道1"},"料金設定なし",{"$f":"D5&G5","v":"料金設定なし"},"-"]
["青森県",{"$f":"COUNTIF(A$2:A6,A6)","v":1},"青森県1","料金設定なし",{"$f":"D6&G6","v":"料金設定なし"},"-"]
["岩手県",{"$f":"COUNTIF(A$2:A7,A7)","v":1},"岩手県1","料金設定なし","料金設定なし","-"]
["宮城県",{"$f":"COUNTIF(A$2:A8,A8)","v":1},"宮城県1","料金設定なし","料金設定なし","-"]
["秋田県",{"$f":"COUNTIF(A$2:A9,A9)","v":1},"秋田県1","料金設定なし","料金設定なし","-"]
["山形県",{"$f":"COUNTIF(A$2:A10,A10)","v":1},"山形県1","料金設定なし","料金設定なし","-"]
["福島県",{"$f":"COUNTIF(A$2:A11,A11)","v":1},"福島県1","料金設定なし","料金設定なし","-"]
["茨城県",{"$f":"COUNTIF(A$2:A12,A12)","v":1},"茨城県1","全土","全土",8.5]
["栃木県",{"$f":"COUNTIF(A$2:A13,A13)","v":1},"栃木県1","全土","全土",8.5]
["群馬県",{"$f":"COUNTIF(A$2:A14,A14)","v":1},"群馬県1","全土","全土",8.5]
["埼玉県",{"$f":"COUNTIF(A$2:A15,A15)","v":1},"埼玉県1","全土","全土",8]
["千葉県",{"$f":"COUNTIF(A$2:A16,A16)","v":1},"千葉県1","全土","全土",8]
["東京都",{"$f":"COUNTIF(A$2:A17,A17)","v":1},"東京都1","全土","全土",7.5]
["神奈川県",{"$f":"COUNTIF(A$2:A18,A18)","v":1},"神奈川県1","全土","全土",7]
["新潟県",{"$f":"COUNTIF(A$2:A19,A19)","v":1},"新潟県1","全土","全土",7]
["富山県",{"$f":"COUNTIF(A$2:A20,A20)","v":1},"富山県1","全土","全土",5]
["石川県",{"$f":"COUNTIF(A$2:A21,A21)","v":1},"石川県1","金沢市より北","金沢市より北",4]
["石川県",{"$f":"COUNTIF(A$2:A22,A22)","v":2},"石川県2","金沢市より南（含む加賀/山中/片山津/山代/粟津温泉）","金沢市より南（含む加賀/山中/片山津/山代/粟津温泉）",3.5]
["石川県",{"$f":"COUNTIF(A$2:A23,A23)","v":3},"石川県3","金沢市","金沢市",3.5]
["福井県",{"$f":"COUNTIF(A$2:A24,A24)","v":1},"福井県1","福井市･三国・金津・芦原・東尋坊・越前","福井市･三国・金津・芦原・東尋坊・越前",3]
["福井県",{"$f":"COUNTIF(A$2:A25,A25)","v":2},null,"小浜・高浜・敦賀・三方(若狭・美浜)","小浜・高浜・敦賀・三方(若狭・美浜)",2.5]
["山梨県",{"$f":"COUNTIF(A$2:A26,A26)","v":1},"山梨県1","全土","全土",6.5]
["長野県",{"$f":"COUNTIF(A$2:A27,A27)","v":1},"長野県1","全土","全土",5]
["岐阜県",{"$f":"COUNTIF(A$2:A28,A28)","v":1},"岐阜県1","岐阜市・関ヶ原・羽島・大垣","岐阜市・関ヶ原・羽島・大垣",2]
["岐阜県",{"$f":"COUNTIF(A$2:A29,A29)","v":2},"岐阜県2","美濃・多治見・関","美濃・多治見・関",3]
["岐阜県",{"$f":"COUNTIF(A$2:A30,A30)","v":3},"岐阜県3","白川町・中津川・郡上・下呂・飛騨・高山・白川郷","白川町・中津川・郡上・下呂・飛騨・高山・白川郷",4]
["岐阜県",{"$f":"COUNTIF(A$2:A31,A31)","v":4},"岐阜県4",null,"",4]
["岐阜県",{"$f":"COUNTIF(A$2:A32,A32)","v":5},"岐阜県5",null,"",4]
["静岡県",{"$f":"COUNTIF(A$2:A33,A33)","v":1},"静岡県1","浜松","浜松",4.5]
["静岡県",{"$f":"COUNTIF(A$2:A34,A34)","v":2},"静岡県2","静岡市","静岡市",5.5]
["静岡県",{"$f":"COUNTIF(A$2:A35,A35)","v":3},"静岡県3","御殿場・伊豆・熱海・沼津","御殿場・伊豆・熱海・沼津",6.5]
["愛知県",{"$f":"COUNTIF(A$2:A36,A36)","v":1},"愛知県1","一宮・小牧・名古屋","一宮・小牧・名古屋",3]
["愛知県",{"$f":"COUNTIF(A$2:A37,A37)","v":2},"愛知県2","知多・岡崎・豊橋・豊田・常滑・中部国際空港(ｾﾝﾄﾚｱ)","知多・岡崎・豊橋・豊田・常滑・中部国際空港(ｾﾝﾄﾚｱ)",3.5]
["三重県",{"$f":"COUNTIF(A$2:A38,A38)","v":1},"三重県1","名張・伊賀・上野","名張・伊賀・上野",2.5]
["三重県",{"$f":"COUNTIF(A$2:A39,A39)","v":2},"三重県2","津(美杉除く)・松坂(一部除く)・鈴鹿・桑名・長島・四日市・亀山","津(美杉除く)・松坂(一部除く)・鈴鹿・桑名・長島・四日市・亀山",3]
["三重県",{"$f":"COUNTIF(A$2:A40,A40)","v":3},"三重県3","志摩・伊勢・鳥羽（アマネム）","志摩・伊勢・鳥羽（アマネム）",3.5]
["三重県",{"$f":"COUNTIF(A$2:A41,A41)","v":4},"三重県4","尾鷲/美杉/飯高/飯南","尾鷲/美杉/飯高/飯南",4]
["三重県",{"$f":"COUNTIF(A$2:A42,A42)","v":5},"三重県5","熊野・多気・紀北","熊野・多気・紀北",4.5]
["滋賀県",{"$f":"COUNTIF(A$2:A43,A43)","v":1},"滋賀県1","大津①(浜大津/堅田/瀬田)・比叡山","大津①(浜大津/堅田/瀬田)・比叡山",0.5]
["滋賀県",{"$f":"COUNTIF(A$2:A44,A44)","v":2},"滋賀県2","大津②(和邇)・草津・竜王・守山・栗東・野洲・近江八幡・湖南","大津②(和邇)・草津・竜王・守山・栗東・野洲・近江八幡・湖南",1]
["滋賀県",{"$f":"COUNTIF(A$2:A45,A45)","v":3},"滋賀県3","大津③(比良)・東近江①(八日市/能登川/湖東）・甲賀①（信楽）・日野","大津③(比良)・東近江①(八日市/能登川/湖東）・甲賀①（信楽）・日野",1.5]
["滋賀県",{"$f":"COUNTIF(A$2:A46,A46)","v":4},"滋賀県4","東近江②(永源寺)・甲賀②(甲賀)・高島①（高島）・長浜①(長浜/湖北)・彦根・米原","東近江②(永源寺)・甲賀②(甲賀)・高島①（高島）・長浜①(長浜/湖北)・彦根・米原",2]
["滋賀県",{"$f":"COUNTIF(A$2:A47,A47)","v":5},"滋賀県5","高島②（今津)・長浜②(木之本)","高島②（今津)・長浜②(木之本)",2.5]
["京都府",{"$f":"COUNTIF(A$2:A48,A48)","v":1},"京都府1","京都市(左京区/右京区一部除く)・宇治市(一部除く)・向日市・城陽市・八幡市(石清水八幡宮)・久御山町　","京都市(左京区/右京区一部除く)・宇治市(一部除く)・向日市・城陽市・八幡市(石清水八幡宮)・久御山町　★",0,"★","区域内"]
["京都府",{"$f":"COUNTIF(A$2:A49,A49)","v":2},"京都府2","左京区(比叡山一本杉)･宇治市（笠取/炭山）・長岡京市・京田辺市・宇治田原町・井手町・乙訓郡(大山崎)","左京区(比叡山一本杉)･宇治市（笠取/炭山）・長岡京市・京田辺市・宇治田原町・井手町・乙訓郡(大山崎)★",0.5,"★"]
["京都府",{"$f":"COUNTIF(A$2:A50,A50)","v":3},"京都府3","左京区(花背/美山荘/百井）・右京区（越畑）・木津川市・和束町・精華町・笠置町・南山城村","左京区(花背/美山荘/百井）・右京区（越畑）・木津川市・和束町・精華町・笠置町・南山城村★",1,"★"]
["京都府",{"$f":"COUNTIF(A$2:A51,A51)","v":4},"京都府4","左京区（久多/広河原）・右京区（京北/周山）","左京区（久多/広河原）・右京区（京北/周山）★",1.5,"★"]
["京都府",{"$f":"COUNTIF(A$2:A52,A52)","v":5},{"$f":"A52&B52","v":"京都府5"},"亀岡市","亀岡市",1]
["京都府",{"$f":"COUNTIF(A$2:A53,A53)","v":6},"京都府6","南丹市(日吉/八木/園部/美山/かやぶきの里）・京丹波町","南丹市(日吉/八木/園部/美山/かやぶきの里）・京丹波町",1.5]
["京都府",{"$f":"COUNTIF(A$2:A54,A54)","v":7},"京都府7","福知山市・綾部市","福知山市・綾部市",2]
["京都府",{"$f":"COUNTIF(A$2:A55,A55)","v":8},"京都府8","宮津市（天橋立）・与謝野町・舞鶴市　　","宮津市（天橋立）・与謝野町・舞鶴市　　",2.5]
["京都府",{"$f":"COUNTIF(A$2:A56,A56)","v":9},"京都府9","京丹後市(峰山/網野/久美浜/夕日ヶ浦/間人<ﾀｲｻﾞ>）・伊根町","京丹後市(峰山/網野/久美浜/夕日ヶ浦/間人<ﾀｲｻﾞ>）・伊根町",3]
["大阪府",{"$f":"COUNTIF(A$2:A57,A57)","v":1},"大阪府1","大阪市・東大阪","大阪市・東大阪",1.5]
["大阪府",{"$f":"COUNTIF(A$2:A58,A58)","v":2},"大阪府2","枚方・高槻・三島・寝屋川・交野","枚方・高槻・三島・寝屋川・交野",0.5]
["大阪府",{"$f":"COUNTIF(A$2:A59,A59)","v":3},"大阪府3","茨木・摂津・四条畷・吹田・守口・門真・大東・箕面・豊中・伊丹空港","茨木・摂津・四条畷・吹田・守口・門真・大東・箕面・豊中・伊丹空港",1]
["大阪府",{"$f":"COUNTIF(A$2:A60,A60)","v":4},"大阪府4","八尾・松原・富田林・堺・柏原・羽曳野・河内長野・狭山","八尾・松原・富田林・堺・柏原・羽曳野・河内長野・狭山",2]
["大阪府",{"$f":"COUNTIF(A$2:A61,A61)","v":5},"大阪府5","和泉・岸和田・泉佐野・泉南・泉大津・関空","和泉・岸和田・泉佐野・泉南・泉大津・関空",2.5]
["兵庫県",{"$f":"COUNTIF(A$2:A62,A62)","v":1},"兵庫県1","伊丹市・川西市","伊丹市・川西市",1]
["兵庫県",{"$f":"COUNTIF(A$2:A63,A63)","v":2},{"$f":"A63&B63","v":"兵庫県2"},"備考あり・尼崎市・宝塚市・\n西宮市（含む甲子園）","備考あり・尼崎市・宝塚市・\n西宮市（含む甲子園）",1.5]
["兵庫県",{"$f":"COUNTIF(A$2:A64,A64)","v":3},"兵庫県3","神戸市（有馬）・芦屋市・\n三田市・猪名川町","神戸市（有馬）・芦屋市・\n三田市・猪名川町",2]
["兵庫県",{"$f":"COUNTIF(A$2:A65,A65)","v":4},"兵庫県4","備考あり・明石市・丹波篠山市・\n丹波市・加東市(滝野社)・加古川市・\n小野市・高砂市・西脇市・加西市・\n三木市・加古郡(播磨/稲美)","備考あり・明石市・丹波篠山市・\n丹波市・加東市(滝野社)・加古川市・\n小野市・高砂市・西脇市・加西市・\n三木市・加古郡(播磨/稲美)",2.5]
["兵庫県",{"$f":"COUNTIF(A$2:A66,A66)","v":5},"兵庫県5","備考あり・穴粟市・佐用郡・赤穂市・\n相生市・たつの市・太子町・朝来市・\n姫路市・養父市・福崎町・多可郡・\n市川町・神河町・上郡町・淡路島\n(淡路市/洲本市/南あわじ市)","備考あり・穴粟市・佐用郡・赤穂市・\n相生市・たつの市・太子町・朝来市・\n姫路市・養父市・福崎町・多可郡・\n市川町・神河町・上郡町・淡路島\n(淡路市/洲本市/南あわじ市)",3]
["兵庫県",{"$f":"COUNTIF(A$2:A67,A67)","v":6},"兵庫県6","豊岡市(城崎/神鍋/出石)","豊岡市(城崎/神鍋/出石)",3.5]
["兵庫県",{"$f":"COUNTIF(A$2:A68,A68)","v":7},"兵庫県7","豊岡市(香住)・\n美方郡(湯村温泉/新温泉町/\n香美<ｶﾐ>/ハチ北高原/浜坂)","豊岡市(香住)・\n美方郡(湯村温泉/新温泉町/\n香美<ｶﾐ>/ハチ北高原/浜坂)",4]
["奈良県",{"$f":"COUNTIF(A$2:A69,A69)","v":1},"奈良県1","奈良市(月ヶ瀬除く)・生駒市","奈良市(月ヶ瀬除く)・生駒市",1]
["奈良県",{"$f":"COUNTIF(A$2:A70,A70)","v":2},{"$f":"A70&B70","v":"奈良県2"},"備考あり・大和郡山市・\n天理市・香芝市・\n生駒郡（信貴山/斑鳩/法隆寺)・\n磯城<ｼｷ>郡（川西/三宅/田原本)・\n北葛城郡(王寺/広陵/河合)",{"$f":"D70&G70","v":"備考あり・大和郡山市・\n天理市・香芝市・\n生駒郡（信貴山/斑鳩/法隆寺)・\n磯城<ｼｷ>郡（川西/三宅/田原本)・\n北葛城郡(王寺/広陵/河合)"},1.5]
["奈良県",{"$f":"COUNTIF(A$2:A71,A71)","v":3},"奈良県3","備考あり・橿原市・葛城市・\n大和高田市・大和八木市・\n桜井市(長谷寺)","備考あり・橿原市・葛城市・\n大和高田市・大和八木市・\n桜井市(長谷寺)",2]
["奈良県",{"$f":"COUNTIF(A$2:A72,A72)","v":4},"奈良県4","備考あり・明日香村（飛鳥）・\n高取町・大淀町・御所<ｺﾞｾ>市・\n奈良市月ヶ瀬","備考あり・明日香村（飛鳥）・\n高取町・大淀町・御所<ｺﾞｾ>市・\n奈良市月ヶ瀬",2.5]
["奈良県",{"$f":"COUNTIF(A$2:A73,A73)","v":5},"奈良県5","備考あり・吉野郡（吉野/下市）・\n五條市・宇陀市（室生寺<ﾑﾛｳｼﾞ>）","備考あり・吉野郡（吉野/下市）・\n五條市・宇陀市（室生寺<ﾑﾛｳｼﾞ>）",3]
["奈良県",{"$f":"COUNTIF(A$2:A74,A74)","v":6},"奈良県6","吉野郡(十津川村/十津川温泉)","吉野郡(十津川村/十津川温泉)",3.5]
["和歌山県",{"$f":"COUNTIF(A$2:A75,A75)","v":1},"和歌山県1","串本/勝浦","串本/勝浦",4.5]
["和歌山県",{"$f":"COUNTIF(A$2:A76,A76)","v":2},{"$f":"A76&B76","v":"和歌山県2"},"白浜/田辺","白浜/田辺",4]
["和歌山県",{"$f":"COUNTIF(A$2:A77,A77)","v":3},{"$f":"A77&B77","v":"和歌山県3"},"御坊","御坊",3.5]
["和歌山県",{"$f":"COUNTIF(A$2:A78,A78)","v":4},{"$f":"A78&B78","v":"和歌山県4"},"和歌山・海南・橋本","和歌山・海南・橋本",3]
["鳥取県",{"$f":"COUNTIF(A$2:A79,A79)","v":1},"鳥取県1","全土","全土",5]
["島根県",{"$f":"COUNTIF(A$2:A80,A80)","v":1},{"$f":"A80&B80","v":"島根県1"},"全土","全土",6]
["岡山県",{"$f":"COUNTIF(A$2:A81,A81)","v":1},"岡山県1","全土","全土",4]
["広島県",{"$f":"COUNTIF(A$2:A82,A82)","v":1},"広島県1","全土","全土",5.5]
["山口県",{"$f":"COUNTIF(A$2:A83,A83)","v":1},"山口県1","全土","全土",7.5]
["徳島県",{"$f":"COUNTIF(A$2:A84,A84)","v":1},"徳島県1","徳島市・鳴門市","徳島市・鳴門市",4]
["徳島県",{"$f":"COUNTIF(A$2:A85,A85)","v":2},{"$f":"A85&B85","v":"徳島県2"},"徳島市＆鳴門市除く","徳島市＆鳴門市除く",5.5]
["香川県",{"$f":"COUNTIF(A$2:A86,A86)","v":1},"香川県1","全土","全土",5]
["愛媛県",{"$f":"COUNTIF(A$2:A87,A87)","v":1},"愛媛県1","全土","全土",6]
["高知県",{"$f":"COUNTIF(A$2:A88,A88)","v":1},"高知県1","全土","全土",6.5]
["福岡県",{"$f":"COUNTIF(A$2:A89,A89)","v":1},"福岡県1","全土","全土",8]
["佐賀県",{"$f":"COUNTIF(A$2:A90,A90)","v":1},"佐賀県1","料金設定なし","料金設定なし","-"]
["長崎県",{"$f":"COUNTIF(A$2:A91,A91)","v":1},"長崎県1","料金設定なし","料金設定なし","-"]
["熊本県",{"$f":"COUNTIF(A$2:A92,A92)","v":1},"熊本県1","料金設定なし","料金設定なし","-"]
["大分県",{"$f":"COUNTIF(A$2:A93,A93)","v":1},"大分県1","料金設定なし","料金設定なし","-"]
["宮崎県",{"$f":"COUNTIF(A$2:A94,A94)","v":1},{"$f":"A94&B94","v":"宮崎県1"},"料金設定なし","料金設定なし","-"]
["鹿児島県",{"$f":"COUNTIF(A$2:A95,A95)","v":1},"鹿児島県1","料金設定なし","料金設定なし","-"]
["沖縄県",{"$f":"COUNTIF(A$2:A96,A96)","v":1},"沖縄県1","料金設定なし","料金設定なし","-"]
[null,{"$f":"COUNTIF(A$2:A97,A97)","v":0},"0",null,{"$f":"A97&D97","v":""}]
[null,{"$f":"COUNTIF(A$2:A98,A98)","v":0},"0",null,""]

{"sheet":"貸切料金2","index":9,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"貸切項目入力!F25","v":"選択してください★"},null,null,null,null,null,null,{"$f":"貸切項目入力!F30","v":"選択してください★"}]
[]
[null,null,null,null,null,"選択してください★",null,null,null,null,null,null,"選択してください★"]
[null,"北海道",{"$f":"貸切項目入力!F24","v":"選択してください"},1,{"$f":"C5&D5","v":"選択してください1"},{"$f":"IFERROR(VLOOKUP(E5,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E5,貸切料金!C37:F153,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},1,{"$f":"J5&K5","v":"選択してください1"},{"$f":"IFERROR(VLOOKUP(L5,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L5,貸切料金!C37:F153,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"青森県",{"$f":"貸切項目入力!F24","v":"選択してください"},2,{"$f":"C6&D6","v":"選択してください2"},{"$f":"IFERROR(VLOOKUP(E6,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E6,貸切料金!C38:F154,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},2,{"$f":"J6&K6","v":"選択してください2"},{"$f":"IFERROR(VLOOKUP(L6,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L6,貸切料金!C38:F154,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"岩手県",{"$f":"貸切項目入力!F24","v":"選択してください"},3,"選択してください3",{"$f":"IFERROR(VLOOKUP(E7,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E7,貸切料金!C38:F155,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},3,"選択してください3",{"$f":"IFERROR(VLOOKUP(L7,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L7,貸切料金!C38:F155,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"宮城県",{"$f":"貸切項目入力!F24","v":"選択してください"},4,"選択してください4",{"$f":"IFERROR(VLOOKUP(E8,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E8,貸切料金!C39:F156,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},4,"選択してください4",{"$f":"IFERROR(VLOOKUP(L8,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L8,貸切料金!C39:F156,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"秋田県",{"$f":"貸切項目入力!F24","v":"選択してください"},5,"選択してください5",{"$f":"IFERROR(VLOOKUP(E9,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E9,貸切料金!C40:F157,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},5,"選択してください5",{"$f":"IFERROR(VLOOKUP(L9,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L9,貸切料金!C40:F157,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"山形県",{"$f":"貸切項目入力!F24","v":"選択してください"},6,"選択してください6",{"$f":"IFERROR(VLOOKUP(E10,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E10,貸切料金!C41:F158,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},6,"選択してください6",{"$f":"IFERROR(VLOOKUP(L10,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L10,貸切料金!C41:F158,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"福島県",{"$f":"貸切項目入力!F24","v":"選択してください"},7,"選択してください7",{"$f":"IFERROR(VLOOKUP(E11,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E11,貸切料金!C42:F159,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},7,"選択してください7",{"$f":"IFERROR(VLOOKUP(L11,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L11,貸切料金!C42:F159,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"茨城県",{"$f":"貸切項目入力!F24","v":"選択してください"},8,"選択してください8",{"$f":"IFERROR(VLOOKUP(E12,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E12,貸切料金!C43:F160,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},8,"選択してください8",{"$f":"IFERROR(VLOOKUP(L12,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L12,貸切料金!C43:F160,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"栃木県",{"$f":"貸切項目入力!F24","v":"選択してください"},9,"選択してください9",{"$f":"IFERROR(VLOOKUP(E13,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E13,貸切料金!C44:F161,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},9,"選択してください9",{"$f":"IFERROR(VLOOKUP(L13,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L13,貸切料金!C44:F161,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"群馬県",{"$f":"貸切項目入力!F24","v":"選択してください"},10,"選択してください10",{"$f":"IFERROR(VLOOKUP(E14,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E14,貸切料金!C45:F162,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},10,"選択してください10",{"$f":"IFERROR(VLOOKUP(L14,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L14,貸切料金!C45:F162,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"埼玉県",{"$f":"貸切項目入力!F24","v":"選択してください"},11,"選択してください11",{"$f":"IFERROR(VLOOKUP(E15,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E15,貸切料金!C46:F163,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},11,"選択してください11",{"$f":"IFERROR(VLOOKUP(L15,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L15,貸切料金!C46:F163,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"千葉県",{"$f":"貸切項目入力!F24","v":"選択してください"},12,"選択してください12",{"$f":"IFERROR(VLOOKUP(E16,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E16,貸切料金!C47:F164,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},12,"選択してください12",{"$f":"IFERROR(VLOOKUP(L16,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L16,貸切料金!C47:F164,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"東京都",{"$f":"貸切項目入力!F24","v":"選択してください"},13,"選択してください13",{"$f":"IFERROR(VLOOKUP(E17,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E17,貸切料金!C48:F165,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},13,"選択してください13",{"$f":"IFERROR(VLOOKUP(L17,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L17,貸切料金!C48:F165,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"神奈川県",{"$f":"貸切項目入力!F24","v":"選択してください"},14,"選択してください14",{"$f":"IFERROR(VLOOKUP(E18,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(E18,貸切料金!C49:F166,4,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"貸切項目入力!F29","v":"選択してください"},14,"選択してください14",{"$f":"IFERROR(VLOOKUP(L18,貸切料金!C:E,3,FALSE),\"\")","v":""},{"$f":"VLOOKUP(L18,貸切料金!C49:F166,4,FALSE)","v":{"$error":"#N/A"}}]
[null,"新潟県"]
[null,"富山県"]
[null,"石川県"]
[null,"福井県"]
[null,"山梨県",null,null,"03:00:00"]
[null,"長野県",null,null,"02:00:00"]
[null,"岐阜県",null,null,"03:00:00"]
[null,"静岡県",null,null,{"$f":"IF(貸切項目入力!F33<=貸切料金2!E23,E25,貸切項目入力!F33)","v":"03:00:00"}]
[null,"愛知県"]
[null,"三重県"]
[null,"滋賀県"]
[null,"選択してください"]
[null,"京都府"]
[null,"大阪府"]
[null,"兵庫県"]
[null,"奈良県"]
[null,"和歌山県"]
[null,"鳥取県"]
[null,"島根県"]
[null,"岡山県"]
[null,"広島県"]
[null,"山口県"]
[null,"徳島県"]
[null,"香川県"]
[null,"愛媛県"]
[null,"高知県"]
[null,"福岡県"]
[null,"佐賀県"]
[null,"長崎県"]
[null,"熊本県"]
[null,"大分県"]
[null,"宮崎県"]
[null,"鹿児島県"]
[null,"沖縄県"]

{"sheet":"貸切料金計算 ","index":10,"n_rows":58,"n_cols":21,"rows_kept":58,"cut":false,"hidden":true,"merged":[[5,1,6,1],[1,1,2,1]]}
[]
[null,"送迎",null,"利用時間",null,null,"区域外規定迎え","区域外規定送り","元規定","30分分",null,null,"１時間料金","30分料金","料金",null,"英会話","30分料金","レベル","合計","延長"]
[null,null,null,{"$f":"貸切項目入力!F33","v":"00:00:00"},{"$f":"LOOKUP(D3,D10:E58)*2","v":0},null,{"$f":"VLOOKUP(貸切料金2!F2,貸切料金2!F5:G18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(貸切料金2!M2,貸切料金2!M5:N19,2,FALSE)","v":{"$error":"#N/A"}},2,{"$f":"E3-I3","v":-2},{"$f":"G3*2","v":{"$error":"#N/A"}},{"$f":"H3*2","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(貸切項目入力!F18,車種!D:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(貸切項目入力!F18,車種!D:F,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"M3+((J4+K3+L3)*N3)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"E3*Q4*R4*S4","v":0}]
[null,"エグゼクティブ",null,{"$f":"IF(貸切項目入力!F17=車種!A23,貸切料金2!E26,貸切項目入力!F33)","v":"00:00:00"},{"$f":"VLOOKUP(D4,D10:F58,3,FALSE)","v":0},null,null,null,2,{"$f":"E4-I4","v":-2},null,null,null,null,null,null,{"$f":"IF(貸切項目入力!F38=各種!D4,1,0)","v":0},1000,{"$f":"IF(OR(貸切項目入力!F40=各種!F4,貸切項目入力!F40=各種!F5),1,0)","v":0},{"$f":"E4*Q4*R4*S4","v":0},{"$f":"Q4*R4*S4","v":0}]
[]
[null,null,null,"01:30:00",{"$f":"VLOOKUP(D6,D10:E58,2,FALSE)","v":1.5},{"$f":"VLOOKUP(D6,D10:F58,3,FALSE)","v":3}]
[null,null,null,{"$f":"VLOOKUP(貸切項目入力!F23,'貸切料金計算 '!D10:E58,2,FALSE)","v":0},{"$f":"VLOOKUP(貸切項目入力!F28,'貸切料金計算 '!D10:E58,2,FALSE)","v":0},{"$f":"E7-D7","v":0}]
[]
[]
[null,null,0,"00:00:00",0,{"$f":"E10*2","v":0}]
[null,null,0.5,"00:30:00",0.5,1]
[null,null,1,"01:00:00",1,2]
[null,null,1.5,"01:30:00",1.5,3]
[null,null,2,"02:00:00",2,4]
[null,null,2.5,"02:30:00",2.5,5]
[null,null,3,"03:00:00",3,6]
[null,null,3.5,"03:30:00",3.5,7]
[null,null,4,"04:00:00",4,8]
[null,null,4.5,"04:30:00",4.5,9]
[null,null,5,"05:00:00",5,10]
[null,null,5.5,"05:30:00",5.5,11]
[null,null,6,"06:00:00",6,12]
[null,null,6.5,"06:30:00",6.5,13]
[null,null,7,"07:00:00",7,14]
[null,null,7.5,"07:30:00",7.5,15]
[null,null,8,"08:00:00",8,16]
[null,null,8.5,"08:30:00",8.5,17]
[null,null,null,"選択してください"]
[null,null,9,"09:00:00",9,18]
[null,null,9.5,"09:30:00",9.5,19]
[null,null,10,"10:00:00",10,20]
[null,null,10.5,"10:30:00",10.5,21]
[null,null,11,"11:00:00",11,22]
[null,null,11.5,"11:30:00",11.5,23]
[null,null,12,"12:00:00",12,24]
[null,null,12.5,"12:30:00",12.5,25]
[null,null,13,"13:00:00",13,26]
[null,null,13.5,"13:30:00",13.5,27]
[null,null,14,"14:00:00",14,28]
[null,null,14.5,"14:30:00",14.5,29]
[null,null,15,"15:00:00",15,30]
[null,null,15.5,"15:30:00",15.5,31]
[null,null,16,"16:00:00",16,{"$f":"E43*2","v":32}]
[null,null,16.5,"16:30:00",16.5,33]
[null,null,17,"17:00:00",17,34]
[null,null,17.5,"17:30:00",17.5,35]
[null,null,18,"18:00:00",18,36]
[null,null,18.5,"18:30:00",18.5,37]
[null,null,19,"19:00:00",19,38]
[null,null,19.5,"19:30:00",19.5,39]
[null,null,20,"20:00:00",20,40]
[null,null,20.5,"20:30:00",20.5,41]
[null,null,21,"21:00:00",21,42]
[null,null,21.5,"21:30:00",21.5,43]
[null,null,22,"22:00:00",22,44]
[null,null,22.5,"22:30:00",22.5,45]
[null,null,23,"23:00:00",23,46]
[null,null,23.5,"23:30:00",23.5,47]

{"sheet":"送迎料金計算","index":11,"n_rows":77,"n_cols":20,"rows_kept":77,"cut":false,"hidden":true,"merged":[[2,1,3,1],[6,1,7,1]]}
[]
[]
[null,"お迎え","区域外規定迎え","料金","利用可能時間",null,null,"区域外規定迎え","料金","利用可能時間",null,"１時間料金","30分料金","料金",null,"英会話","30分料金","レベル","合計","延長"]
[null,null,{"$f":"VLOOKUP(送迎料金2!F2,送迎料金2!F5:G14,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(送迎料金2!F2,送迎料金2!F5:H14,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(送迎料金2!F2,送迎料金2!F5:I14,4,FALSE)","v":{"$error":"#N/A"}},null,2,{"$f":"C$4*G4","v":{"$error":"#N/A"}},{"$f":"D$5*G4","v":{"$error":"#N/A"}},{"$f":"E$4*G4","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(送迎項目入力!F18,車種!D:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(送迎項目入力!F18,車種!D:F,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"L4+(I4-G4)*M4","v":{"$error":"#N/A"}},null,{"$f":"IF(送迎項目入力!F35=各種!D4,1,0)","v":0},1000,{"$f":"IF(OR(送迎項目入力!F37=各種!F4,送迎項目入力!F37=各種!F5),1,0)","v":0},{"$f":"Q4*J4*P4*R4","v":{"$error":"#N/A"}},{"$f":"P4*Q4*R4","v":0}]
[null,"エグゼ",null,{"$f":"IF(送迎項目入力!F17=車種!A23,IF(送迎料金計算!D4<=3,3,送迎料金計算!D4),D4)","v":{"$error":"#N/A"}}]
[]
[null,"送り","区域外規定送り","料金","利用可能時間",null,null,null,null,null,null,"１時間料金","30分料金","料金",null,"英会話","30分料金","レベル","合計","延長"]
[null,null,{"$f":"VLOOKUP(送迎料金2!N2,送迎料金2!N5:O14,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(送迎料金2!N2,送迎料金2!N5:P14,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(送迎料金2!N2,送迎料金2!N5:Q14,4,FALSE)","v":{"$error":"#N/A"}},null,2,{"$f":"C$8*G8","v":{"$error":"#N/A"}},{"$f":"D$9*G8","v":{"$error":"#N/A"}},{"$f":"E$8*G8","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(送迎項目入力!F18,車種!D:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(送迎項目入力!F18,車種!D:F,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"L8+(I8-G8)*M8","v":{"$error":"#N/A"}},null,{"$f":"IF(送迎項目入力!F35=各種!D4,1,0)","v":0},1000,{"$f":"IF(OR(送迎項目入力!F37=各種!F4,送迎項目入力!F37=各種!F5),1,0)","v":0},{"$f":"Q8*J8*P8*R8","v":{"$error":"#N/A"}},{"$f":"P8*Q8*R8","v":0}]
[null,"エグゼ",null,{"$f":"IF(送迎項目入力!F17=車種!A23,IF(送迎料金計算!D8<=3,3,送迎料金計算!D8),D8)","v":{"$error":"#N/A"}}]
[]
[null,null,{"$f":"MIN(C4,C8)","v":{"$error":"#N/A"}},{"$f":"MAX(D5,D9)","v":{"$error":"#N/A"}},{"$f":"E8+E4-1","v":{"$error":"#N/A"}},null,2,{"$f":"C$11*G11","v":{"$error":"#N/A"}},{"$f":"D$12*G11","v":{"$error":"#N/A"}},{"$f":"E$11*G11","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(送迎項目入力!F18,車種!D:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(送迎項目入力!F18,車種!D:F,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"L11+(I11-G11+H11)*M11","v":{"$error":"#N/A"}},null,{"$f":"IF(送迎項目入力!F35=各種!D4,1,0)","v":0},1000,{"$f":"IF(OR(送迎項目入力!F37=各種!F4,送迎項目入力!F37=各種!F5),1,0)","v":0},{"$f":"Q8*J11*P8*R8","v":{"$error":"#N/A"}},{"$f":"P8*Q8*R8","v":0}]
[null,null,null,{"$f":"IF(送迎項目入力!F17=車種!A23,IF(D11<=3,3,D11),D11)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(E11,D18:F77,3,FALSE),0)","v":0}]
[null,null,null,null,{"$f":"VLOOKUP(E12,B18:D773,3,FALSE)","v":0}]
[]
[]
[]
[]
[null,0,0,0,{"$f":"D18*2","v":0},0]
[null,2.0833333333333332E-2,2.0833333333333332E-2,0.5,1,2.0833333333333332E-2]
[null,4.1666666666666664E-2,4.1666666666666664E-2,1,2,4.1666666666666664E-2]
[null,6.25E-2,6.25E-2,1.5,3,6.25E-2]
[null,8.3333333333333301E-2,8.3333333333333301E-2,2,4,8.3333333333333301E-2]
[null,0.104166666666667,0.104166666666667,2.5,5,0.104166666666667]
[null,0.125,0.125,3,6,0.125]
[null,0.14583333333333301,0.14583333333333301,3.5,7,0.14583333333333301]
[null,0.16666666666666699,null,4,8,0.16666666666666699]
[null,0.1875,0.1875,4.5,9,0.1875]
[null,0.20833333333333301,0.20833333333333301,5,10,0.20833333333333301]
[null,0.22916666666666699,0.22916666666666699,5.5,11,0.22916666666666699]
[null,0.25,0.25,6,12,0.25]
[null,0.27083333333333298,0.27083333333333298,6.5,13,0.27083333333333298]
[null,0.29166666666666702,0.29166666666666702,7,14,0.29166666666666702]
[null,0.3125,0.3125,7.5,15,0.3125]
[null,0.33333333333333298,0.33333333333333298,8,16,0.33333333333333298]
[null,0.35416666666666702,0.35416666666666702,8.5,17,0.35416666666666702]
[null,0.375,0.375,9,18,0.375]
[null,0.39583333333333298,0.39583333333333298,9.5,19,0.39583333333333298]
[null,0.41666666666666702,0.41666666666666702,10,20,0.41666666666666702]
[null,0.4375,0.4375,10.5,21,0.4375]
[null,0.45833333333333298,0.45833333333333298,11,22,0.45833333333333298]
[null,0.47916666666666702,0.47916666666666702,11.5,23,0.47916666666666702]
[null,0.5,0.5,12,24,0.5]
[null,0.52083333333333304,0.52083333333333304,12.5,25,0.52083333333333304]
[null,0.54166666666666696,0.54166666666666696,13,26,0.54166666666666696]
[null,0.5625,0.5625,13.5,27,0.5625]
[null,0.58333333333333304,0.58333333333333304,14,28,0.58333333333333304]
[null,0.60416666666666696,0.60416666666666696,14.5,29,0.60416666666666696]
[null,0.625,0.625,15,30,0.625]
[null,0.64583333333333304,0.64583333333333304,15.5,31,0.64583333333333304]
[null,0.66666666666666696,0.66666666666666696,16,{"$f":"D50*2","v":32},0.66666666666666696]
[null,0.6875,0.6875,16.5,33,0.6875]
[null,0.70833333333333304,0.70833333333333304,17,34,0.70833333333333304]
[null,0.72916666666666696,0.72916666666666696,17.5,35,0.72916666666666696]
[null,0.75,0.75,18,36,0.75]
[null,0.77083333333333304,0.77083333333333304,18.5,37,0.77083333333333304]
[null,0.79166666666666696,0.79166666666666696,19,38,0.79166666666666696]
[null,0.8125,0.8125,19.5,39,0.8125]
[null,0.83333333333333304,0.83333333333333304,20,40,0.83333333333333304]
[null,0.85416666666666696,0.85416666666666696,20.5,41,0.85416666666666696]
[null,0.875,0.875,21,42,0.875]
[null,0.89583333333333304,0.89583333333333304,21.5,43,0.89583333333333304]
[null,0.91666666666666696,0.91666666666666696,22,44,0.91666666666666696]
[null,0.9375,0.9375,22.5,45,0.9375]
[null,0.95833333333333304,0.95833333333333304,23,46,0.95833333333333304]
[null,0.97916666666666696,0.97916666666666696,23.5,47,0.97916666666666696]
[null,1,1,24,48,1]
[null,1.0208333333333299,1.0208333333333299,24.5,49,1.0208333333333299]
[null,1.0416666666666701,1.0416666666666701,25,50,1.0416666666666701]
[null,1.0625,1.0625,25.5,51,1.0625]
[null,1.0833333333333299,1.0833333333333299,26,52,1.0833333333333299]
[null,1.1041666666666701,1.1041666666666701,26.5,53,1.1041666666666701]
[null,1.125,1.125,27,54,1.125]
[null,1.1458333333333299,1.1458333333333299,27.5,55,1.1458333333333299]
[null,1.1666666666666701,1.1666666666666701,28,56,1.1666666666666701]
[null,1.1875,1.1875,28.5,57,1.1875]
[null,1.2083333333333299,1.2083333333333299,29,58,1.2083333333333299]
[null,1.2291666666666701,1.2291666666666701,29.5,59,1.2291666666666701]

{"sheet":"送迎料金","index":12,"n_rows":103,"n_cols":9,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"規定","料金","利用可能時間"]
["北海道",{"$f":"COUNTIF(A$2:A2,A2)","v":1},{"$f":"A2&B2","v":"北海道1"},"全土",{"$f":"D2&I2","v":"全土"},12,59,{"$f":"G2-F2","v":47}]
["青森県",{"$f":"COUNTIF(A$2:A3,A3)","v":1},{"$f":"A3&B3","v":"青森県1"},"全土",{"$f":"D3&I3","v":"全土"},12,49,37]
["岩手県",{"$f":"COUNTIF(A$2:A4,A4)","v":1},"岩手県1","全土","全土",12,43,31]
["宮城県",{"$f":"COUNTIF(A$2:A5,A5)","v":1},"宮城県1","全土","全土",12,39,27]
["秋田県",{"$f":"COUNTIF(A$2:A6,A6)","v":1},"秋田県1","全土","全土",12,43,31]
["山形県",{"$f":"COUNTIF(A$2:A7,A7)","v":1},"山形県1","全土","全土",12,35,23]
["福島県",{"$f":"COUNTIF(A$2:A8,A8)","v":1},"福島県1","全土","全土",10,35,{"$f":"G8-F8","v":25}]
["茨城県",{"$f":"COUNTIF(A$2:A9,A9)","v":1},"茨城県1","全土","全土",10,27,17]
["栃木県",{"$f":"COUNTIF(A$2:A10,A10)","v":1},"栃木県1","全土","全土",10,27,17]
["群馬県",{"$f":"COUNTIF(A$2:A11,A11)","v":1},"群馬県1","全土","全土",10,23,13]
["埼玉県",{"$f":"COUNTIF(A$2:A12,A12)","v":1},"埼玉県1","全土","全土",8,23,15]
["千葉県",{"$f":"COUNTIF(A$2:A13,A13)","v":1},"千葉県1","全土","全土",8,27,19]
["東京都",{"$f":"COUNTIF(A$2:A14,A14)","v":1},"東京都1","全土","全土",7.5,23,15.5]
["神奈川県",{"$f":"COUNTIF(A$2:A15,A15)","v":1},"神奈川県1","全土","全土",7,19,12]
["新潟県",{"$f":"COUNTIF(A$2:A16,A16)","v":1},"新潟県1","全土","全土",7,23,16]
["富山県",{"$f":"COUNTIF(A$2:A17,A17)","v":1},"富山県1","富山市より東/北","富山市より東/北",5,15,10]
["富山県",{"$f":"COUNTIF(A$2:A18,A18)","v":2},"富山県2","富山市・富山市より南/西","富山市・富山市より南/西",5,13,8]
["石川県",{"$f":"COUNTIF(A$2:A19,A19)","v":1},"石川県1","金沢市より北","金沢市より北",4,13,9]
["石川県",{"$f":"COUNTIF(A$2:A20,A20)","v":2},"石川県2","金沢市より南（含む加賀/山中/片山津/山代/粟津温泉）","金沢市より南（含む加賀/山中/片山津/山代/粟津温泉）",3.5,9,5.5]
["石川県",{"$f":"COUNTIF(A$2:A21,A21)","v":3},"石川県3","金沢市","金沢市",3.5,11,7.5]
["福井県",{"$f":"COUNTIF(A$2:A22,A22)","v":1},"福井県1","福井市･三国・金津・芦原・東尋坊・越前","福井市･三国・金津・芦原・東尋坊・越前",3,8,5]
["福井県",{"$f":"COUNTIF(A$2:A23,A23)","v":2},"福井県2","小浜・高浜・敦賀・三方(若狭・美浜)","小浜・高浜・敦賀・三方(若狭・美浜)",2.5,6,3.5]
["山梨県",{"$f":"COUNTIF(A$2:A24,A24)","v":1},"山梨県1","全土","全土",6.5,19,12.5]
["長野県",{"$f":"COUNTIF(A$2:A25,A25)","v":1},"長野県1","全土","全土",5,15,10]
["岐阜県",{"$f":"COUNTIF(A$2:A26,A26)","v":1},null,"岐阜市・関ヶ原・羽島・大垣","岐阜市・関ヶ原・羽島・大垣",2.5,6,3.5]
["岐阜県",{"$f":"COUNTIF(A$2:A27,A27)","v":2},"岐阜県2","美濃・多治見・関","美濃・多治見・関",3,7,4]
["岐阜県",{"$f":"COUNTIF(A$2:A28,A28)","v":3},"岐阜県3","白川町・中津川","白川町・中津川",4,9,5]
["岐阜県",{"$f":"COUNTIF(A$2:A29,A29)","v":4},"岐阜県4","郡上・下呂","郡上・下呂",4,10,6]
["岐阜県",{"$f":"COUNTIF(A$2:A30,A30)","v":5},"岐阜県5","飛騨・高山・白川郷","飛騨・高山・白川郷",4,11,7]
["静岡県",{"$f":"COUNTIF(A$2:A31,A31)","v":1},"静岡県1","浜松","浜松",4.5,15,10.5]
["静岡県",{"$f":"COUNTIF(A$2:A32,A32)","v":2},"静岡県2","静岡市","静岡市",5.5,15,9.5]
["静岡県",{"$f":"COUNTIF(A$2:A33,A33)","v":3},"静岡県3","御殿場・伊豆・熱海・沼津","御殿場・伊豆・熱海・沼津",6.5,15,8.5]
["愛知県",{"$f":"COUNTIF(A$2:A34,A34)","v":1},"愛知県1","一宮・小牧・名古屋","一宮・小牧・名古屋",3,6,3]
["愛知県",{"$f":"COUNTIF(A$2:A35,A35)","v":2},"愛知県2","知多・岡崎・豊橋・豊田・常滑・中部国際空港(ｾﾝﾄﾚｱ)","知多・岡崎・豊橋・豊田・常滑・中部国際空港(ｾﾝﾄﾚｱ)",3.5,7,3.5]
["愛知県",{"$f":"COUNTIF(A$2:A36,A36)","v":3},"愛知県3","その他の村町","その他の村町",3.5,9,5.5]
["三重県",{"$f":"COUNTIF(A$2:A37,A37)","v":1},"三重県1","名張・伊賀・上野","名張・伊賀・上野",2.5,5,2.5]
["三重県",{"$f":"COUNTIF(A$2:A38,A38)","v":2},"三重県2","津(美杉除く)・松坂(一部除く)・鈴鹿・桑名・長島・四日市・亀山","津(美杉除く)・松坂(一部除く)・鈴鹿・桑名・長島・四日市・亀山",3,6,3]
["三重県",{"$f":"COUNTIF(A$2:A39,A39)","v":3},"三重県3","志摩・伊勢・鳥羽","志摩・伊勢・鳥羽",3.5,7,3.5]
["三重県",{"$f":"COUNTIF(A$2:A40,A40)","v":4},"三重県4","津(美杉)・松阪(飯高/飯南)・尾鷲","津(美杉)・松阪(飯高/飯南)・尾鷲",4,8,4]
["三重県",{"$f":"COUNTIF(A$2:A41,A41)","v":5},"三重県5","熊野・多気・紀北","熊野・多気・紀北",4.5,10,5.5]
["滋賀県",{"$f":"COUNTIF(A$2:A42,A42)","v":1},"滋賀県1","大津①(浜大津/堅田/瀬田)・比叡山","大津①(浜大津/堅田/瀬田)・比叡山",0.5,2,1.5]
["滋賀県",{"$f":"COUNTIF(A$2:A43,A43)","v":2},"滋賀県2","大津②(和邇)・草津・竜王・守山・栗東・野洲・近江八幡・湖南","大津②(和邇)・草津・竜王・守山・栗東・野洲・近江八幡・湖南",1,3,2]
["滋賀県",{"$f":"COUNTIF(A$2:A44,A44)","v":3},"滋賀県3","大津③(比良)・東近江①(八日市/能登川/湖東）・甲賀①（信楽）・日野","大津③(比良)・東近江①(八日市/能登川/湖東）・甲賀①（信楽）・日野",1.5,4,2.5]
["滋賀県",{"$f":"COUNTIF(A$2:A45,A45)","v":4},"滋賀県4","東近江②(永源寺)・甲賀②(甲賀)・高島①（高島）・長浜①(長浜/湖北)・彦根・米原","東近江②(永源寺)・甲賀②(甲賀)・高島①（高島）・長浜①(長浜/湖北)・彦根・米原",2,5,3]
["滋賀県",{"$f":"COUNTIF(A$2:A46,A46)","v":5},"滋賀県5","高島②（今津)・長浜②(木之本)","高島②（今津)・長浜②(木之本)",2.5,6,3.5]
["京都府",{"$f":"COUNTIF(A$2:A47,A47)","v":1},"京都府1","京都市・宇治市・八幡市","京都市・宇治市・八幡市★",0,1,{"$f":"G47-F47","v":1},"★"]
["京都府",{"$f":"COUNTIF(A$2:A48,A48)","v":2},"京都府2","長岡京・大山崎","長岡京・大山崎★",0.5,1.5,{"$f":"G48-F48","v":1},"★"]
["京都府",{"$f":"COUNTIF(A$2:A49,A49)","v":3},"京都府3","京田辺・宇治田原・井手・笠取","京田辺・宇治田原・井手・笠取★",0.5,2,{"$f":"G49-F49","v":1.5},"★"]
["京都府",{"$f":"COUNTIF(A$2:A50,A50)","v":4},"京都府4","花脊・越畑・木津川・南山城・和束・精華","花脊・越畑・木津川・南山城・和束・精華★",1,2.5,1.5,"★"]
["京都府",{"$f":"COUNTIF(A$2:A51,A51)","v":5},{"$f":"A51&B51","v":"京都府5"},"久多","久多★",1.5,3,1.5,"★"]
["京都府",{"$f":"COUNTIF(A$2:A52,A52)","v":6},"京都府6","亀岡","亀岡",1,2.5,1.5]
["京都府",{"$f":"COUNTIF(A$2:A53,A53)","v":7},"京都府7","京北･南丹","京北･南丹",1.5,3,1.5]
["京都府",{"$f":"COUNTIF(A$2:A54,A54)","v":8},"京都府8","京丹波","京丹波",1.5,3.5,2]
["京都府",{"$f":"COUNTIF(A$2:A55,A55)","v":9},"京都府9","福知山・綾部","福知山・綾部",2,5,3]
["京都府",{"$f":"COUNTIF(A$2:A56,A56)","v":10},"京都府10","宮津・与謝野・舞鶴","宮津・与謝野・舞鶴",2.5,6,3.5]
["京都府",{"$f":"COUNTIF(A$2:A57,A57)","v":11},"京都府11","京丹後・伊根","京丹後・伊根",3,7,4]
["大阪府",{"$f":"COUNTIF(A$2:A58,A58)","v":1},"大阪府1","大阪市・東大阪","大阪市・東大阪",1.5,4,2.5]
["大阪府",{"$f":"COUNTIF(A$2:A59,A59)","v":2},"大阪府2","枚方・高槻・三島・寝屋川・交野","枚方・高槻・三島・寝屋川・交野",0.5,2,1.5]
["大阪府",{"$f":"COUNTIF(A$2:A60,A60)","v":3},"大阪府3","茨木・摂津・四条畷・吹田・守口・門真・大東・箕面・豊中・伊丹空港","茨木・摂津・四条畷・吹田・守口・門真・大東・箕面・豊中・伊丹空港",1,3,2]
["大阪府",{"$f":"COUNTIF(A$2:A61,A61)","v":4},"大阪府4","八尾・松原・富田林・堺・柏原・羽曳野・河内長野・狭山","八尾・松原・富田林・堺・柏原・羽曳野・河内長野・狭山",2,5,3]
["大阪府",{"$f":"COUNTIF(A$2:A62,A62)","v":5},"大阪府5","和泉・岸和田・泉佐野・泉南・泉大津・関空","和泉・岸和田・泉佐野・泉南・泉大津・関空",2.5,6,3.5]
["兵庫県",{"$f":"COUNTIF(A$2:A63,A63)","v":1},"兵庫県1","神戸市・有馬・芦屋・三田・猪名川","神戸市・有馬・芦屋・三田・猪名川",2,4,2]
["兵庫県",{"$f":"COUNTIF(A$2:A64,A64)","v":2},{"$f":"A64&B64","v":"兵庫県2"},"三木","三木",2.5,4,1.5]
["兵庫県",{"$f":"COUNTIF(A$2:A65,A65)","v":3},"兵庫県3","伊丹・川西","伊丹・川西",1,3,2]
["兵庫県",{"$f":"COUNTIF(A$2:A66,A66)","v":4},"兵庫県4","尼崎・宝塚・西宮","尼崎・宝塚・西宮",1.5,3,1.5]
["兵庫県",{"$f":"COUNTIF(A$2:A67,A67)","v":5},"兵庫県5","明石・丹波篠山・丹波・加東・加古川・加西・加古",{"$f":"D67&I67","v":"明石・丹波篠山・丹波・加東・加古川・加西・加古"},2.5,5,2.5]
["兵庫県",{"$f":"COUNTIF(A$2:A68,A68)","v":6},"兵庫県6","姫路・朝来・福崎・多可・市川・神河・太子","姫路・朝来・福崎・多可・市川・神河・太子",3,6,3]
["兵庫県",{"$f":"COUNTIF(A$2:A69,A69)","v":7},{"$f":"A69&B69","v":"兵庫県7"},"穴粟・佐用・赤穂・相生・たつの・養父","穴粟・佐用・赤穂・相生・たつの・養父",3,7,{"$f":"G69-F69","v":4}]
["兵庫県",{"$f":"COUNTIF(A$2:A70,A70)","v":8},"兵庫県8","豊岡","豊岡",4,7,3]
["兵庫県",{"$f":"COUNTIF(A$2:A71,A71)","v":9},"兵庫県9","美方（ハチ北・湯村温泉）","美方（ハチ北・湯村温泉）",4,8,4]
["兵庫県",{"$f":"COUNTIF(A$2:A72,A72)","v":10},{"$f":"A72&B72","v":"兵庫県10"},"淡路島淡路市(一部除く)","淡路島淡路市(一部除く)",3,6,{"$f":"G72-F72","v":3}]
["兵庫県",{"$f":"COUNTIF(A$2:A73,A73)","v":11},"兵庫県11","淡路市(津名/一宮）・洲本市・南あわじ市","淡路市(津名/一宮）・洲本市・南あわじ市",3,6,3]
["奈良県",{"$f":"COUNTIF(A$2:A74,A74)","v":1},"奈良県1","奈良市(月ヶ瀬除く)・生駒市","奈良市(月ヶ瀬除く)・生駒市",1,3,2]
["奈良県",{"$f":"COUNTIF(A$2:A75,A75)","v":2},{"$f":"A75&B75","v":"奈良県2"},"大和郡山・天理・香芝・生駒郡・磯城・北葛城","大和郡山・天理・香芝・生駒郡・磯城・北葛城",1.5,4,{"$f":"G75-F75","v":2.5}]
["奈良県",{"$f":"COUNTIF(A$2:A76,A76)","v":3},"奈良県3","橿原・葛城・大和高田・大和八木・桜井","橿原・葛城・大和高田・大和八木・桜井",2,5,3]
["奈良県",{"$f":"COUNTIF(A$2:A77,A77)","v":4},"奈良県4","明日香・御所・月ヶ瀬","明日香・御所・月ヶ瀬",2.5,6,3.5]
["奈良県",{"$f":"COUNTIF(A$2:A78,A78)","v":5},"奈良県5","吉野・五條・宇陀","吉野・五條・宇陀",3,7,4]
["奈良県",{"$f":"COUNTIF(A$2:A79,A79)","v":6},"奈良県6","十津川","十津川",3.5,8,4.5]
["和歌山県",{"$f":"COUNTIF(A$2:A80,A80)","v":1},"和歌山県1","和歌山市・海南・橋本","和歌山市・海南・橋本",3,7,4]
["和歌山県",{"$f":"COUNTIF(A$2:A81,A81)","v":2},{"$f":"A81&B81","v":"和歌山県2"},"御坊・高野山","御坊・高野山",3.5,8,{"$f":"G81-F81","v":4.5}]
["和歌山県",{"$f":"COUNTIF(A$2:A82,A82)","v":3},"和歌山県3","白浜・田辺","白浜・田辺",4,9,5]
["和歌山県",{"$f":"COUNTIF(A$2:A83,A83)","v":4},"和歌山県4","串本","串本",4.5,11,6.5]
["和歌山県",{"$f":"COUNTIF(A$2:A84,A84)","v":5},"和歌山県5","勝浦","勝浦",4.5,12,7.5]
["鳥取県",{"$f":"COUNTIF(A$2:A85,A85)","v":1},"鳥取県1","全土","全土",5,11,6]
["島根県",{"$f":"COUNTIF(A$2:A86,A86)","v":1},"島根県1","全土","全土",6,15,9]
["岡山県",{"$f":"COUNTIF(A$2:A87,A87)","v":1},"岡山県1","全土","全土",4,9,5]
["広島県",{"$f":"COUNTIF(A$2:A88,A88)","v":1},{"$f":"A88&B88","v":"広島県1"},"全土","全土",5.5,13,7.5]
["山口県",{"$f":"COUNTIF(A$2:A89,A89)","v":1},"山口県1","全土","全土",7.5,19,11.5]
["徳島県",{"$f":"COUNTIF(A$2:A90,A90)","v":1},"徳島県1","鳴門・徳島市","鳴門・徳島市",4,11,7]
["徳島県",{"$f":"COUNTIF(A$2:A91,A91)","v":2},{"$f":"A91&B91","v":"徳島県2"},"鳴門・徳島市より西・南","鳴門・徳島市より西・南",5.5,11,{"$f":"G91-F91","v":5.5}]
["香川県",{"$f":"COUNTIF(A$2:A92,A92)","v":1},"香川県1","直島","直島",5,13,8]
["香川県",{"$f":"COUNTIF(A$2:A93,A93)","v":2},{"$f":"A93&B93","v":"香川県2"},"全土（直島除く）","全土（直島除く）",5,9,{"$f":"G93-F93","v":4}]
["愛媛県",{"$f":"COUNTIF(A$2:A94,A94)","v":1},"愛媛県1","全土","全土",6,13,7]
["高知県",{"$f":"COUNTIF(A$2:A95,A95)","v":1},"高知県1","全土","全土",6.5,13,6.5]
["福岡県",{"$f":"COUNTIF(A$2:A96,A96)","v":1},"福岡県1","全土","全土",12,27,15]
["佐賀県",{"$f":"COUNTIF(A$2:A97,A97)","v":1},"佐賀県1","全土","全土",12,31,19]
["長崎県",{"$f":"COUNTIF(A$2:A98,A98)","v":1},"長崎県1","全土","全土",12,35,23]
["熊本県",{"$f":"COUNTIF(A$2:A99,A99)","v":1},"熊本県1","全土","全土",12,33,21]
["大分県",{"$f":"COUNTIF(A$2:A100,A100)","v":1},"大分県1","全土","全土",12,31,19]
["宮崎県",{"$f":"COUNTIF(A$2:A101,A101)","v":1},"宮崎県1","全土","全土",12,35,23]
["鹿児島県",{"$f":"COUNTIF(A$2:A102,A102)","v":1},"鹿児島県1","全土","全土",12,39,27]
["沖縄県",{"$f":"COUNTIF(A$2:A103,A103)","v":1},"沖縄県1","料金設定なし","料金設定なし","-","-",{"$error":"#VALUE!"}]

{"sheet":"送迎料金2","index":13,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"送迎項目入力!F25","v":"選択してください★"},null,null,null,null,null,null,null,{"$f":"送迎項目入力!F30","v":"選択してください★"}]
[]
[null,null,null,null,null,"選択してください★",null,null,null,null,null,null,null,"選択してください★"]
[null,"北海道",{"$f":"送迎項目入力!F$24","v":"選択してください"},1,{"$f":"C5&D5","v":"選択してください1"},{"$f":"VLOOKUP(E5,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},1,{"$f":"K5&L5","v":"選択してください1"},{"$f":"VLOOKUP(M5,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M5,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M5,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M5,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"青森県",{"$f":"送迎項目入力!F$24","v":"選択してください"},2,{"$f":"C6&D6","v":"選択してください2"},{"$f":"VLOOKUP(E6,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E6,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E6,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E6,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},2,{"$f":"K6&L6","v":"選択してください2"},{"$f":"VLOOKUP(M6,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M6,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M6,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M6,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"岩手県",{"$f":"送迎項目入力!F$24","v":"選択してください"},3,"選択してください3",{"$f":"VLOOKUP(E7,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E7,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E7,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E7,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},3,"選択してください3",{"$f":"VLOOKUP(M7,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M7,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M7,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M7,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"宮城県",{"$f":"送迎項目入力!F$24","v":"選択してください"},4,"選択してください4",{"$f":"VLOOKUP(E8,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E8,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E8,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E8,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},4,"選択してください4",{"$f":"VLOOKUP(M8,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M8,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M8,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M8,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"秋田県",{"$f":"送迎項目入力!F$24","v":"選択してください"},5,"選択してください5",{"$f":"VLOOKUP(E9,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E9,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E9,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E9,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},5,"選択してください5",{"$f":"VLOOKUP(M9,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M9,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M9,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M9,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"山形県",{"$f":"送迎項目入力!F$24","v":"選択してください"},6,"選択してください6",{"$f":"VLOOKUP(E10,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E10,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E10,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E10,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},6,"選択してください6",{"$f":"VLOOKUP(M10,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M10,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M10,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M10,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"福島県",{"$f":"送迎項目入力!F$24","v":"選択してください"},7,"選択してください7",{"$f":"VLOOKUP(E11,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E11,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E11,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E11,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},7,"選択してください7",{"$f":"VLOOKUP(M11,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M11,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M11,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M11,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"茨城県",{"$f":"送迎項目入力!F$24","v":"選択してください"},8,"選択してください8",{"$f":"VLOOKUP(E12,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E12,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E12,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E12,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},8,"選択してください8",{"$f":"VLOOKUP(M12,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M12,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M12,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M12,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"栃木県",{"$f":"送迎項目入力!F$24","v":"選択してください"},9,"選択してください9",{"$f":"VLOOKUP(E13,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E13,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E13,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E13,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},9,"選択してください9",{"$f":"VLOOKUP(M13,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M13,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M13,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M13,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"群馬県",{"$f":"送迎項目入力!F$24","v":"選択してください"},10,"選択してください10",{"$f":"VLOOKUP(E14,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E14,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E14,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E14,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"送迎項目入力!F29","v":"選択してください"},10,"選択してください10",{"$f":"VLOOKUP(M14,送迎料金!C:E,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M14,送迎料金!C:F,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M14,送迎料金!C:G,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M14,送迎料金!C:H,6,FALSE)","v":{"$error":"#N/A"}}]
[null,"埼玉県"]
[null,"千葉県"]
[null,"東京都"]
[null,"神奈川県"]
[null,"新潟県"]
[null,"富山県"]
[null,"石川県"]
[null,"福井県"]
[null,"山梨県"]
[null,"長野県"]
[null,"岐阜県"]
[null,"静岡県"]
[null,"愛知県"]
[null,"三重県"]
[null,"滋賀県"]
[null,"選択してください"]
[null,"京都府"]
[null,"大阪府"]
[null,"兵庫県"]
[null,"奈良県"]
[null,"和歌山県"]
[null,"鳥取県"]
[null,"島根県"]
[null,"岡山県"]
[null,"広島県"]
[null,"山口県"]
[null,"徳島県"]
[null,"香川県"]
[null,"愛媛県"]
[null,"高知県"]
[null,"福岡県"]
[null,"佐賀県"]
[null,"長崎県"]
[null,"熊本県"]
[null,"大分県"]
[null,"宮崎県"]
[null,"鹿児島県"]
[null,"沖縄県"]

{"sheet":"各種","index":14,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
["送迎","00:00:00",null,"選択してください","選択してください","選択してください",null,"選択してください",null,null,"選択してください","選択してください",{"$f":"IF(貸切項目入力!F17=車種!H49,1,0)","v":0},null,null,null,"「項目入力」ページのシュミレーション結果記載事項に入力してください"]
["観光/時間貸切","00:30:00",null,"必要","英語","有料観光レベル",null,1,null,null,"一般貸切(法人以外の方のご依頼はこちらを選択してください）","現金（当日）",{"$f":"IF(貸切項目入力!F17=車種!H50,1,0)","v":0},null,"選択してください","選択してください","「項目入力」ページの入力項目へ選択/入力してください"]
[null,"01:00:00",null,"不要","中国語","無料観光レベル",null,2,null,"様","法人（企業等）","クレジットカード（当日）",{"$f":"M3+M4","v":0},null,"上記を確認し、依頼する","本依頼以外での関連依頼は無い"]
[null,"01:30:00",null,null,"韓国語","送迎レベル",null,3,null,"御中","法人（官公庁）","タクシーチケット（当日）",{"$f":"IF(M5=1,M8,M9)","v":"希望する"},null,null,"本依頼に関連する別日/別時間帯/別車両利用の依頼が別途ある"]
[null,"02:00:00",null,null,null,null,null,"未対応（４台以上）",null,null,"法人（医療）","事前カード決済（事前に決済用URLをMKよりお送ります）","必要ない"]
[null,"02:30:00",null,null,null,null,null,null,null,null,"法人（冠婚葬祭）","事前振込（事前に請求書をMKよりお送ります）","本車種は車番情報連絡には対応しておりません。"]
[null,"03:00:00",null,null,null,null,null,null,null,null,"旅行社","事後請求","希望する"]
[null,"03:30:00",null,null,null,null,null,null,null,null,"ホテル・旅館","クーポン（JTB/全旅/KNT/京旅協）"]
[null,"04:00:00",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(送迎項目入力!F17=車種!H49,1,0)","v":0}]
[null,"04:30:00",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(送迎項目入力!F17=車種!H50,1,0)","v":0}]
[null,"05:00:00",null,null,null,null,null,null,null,null,null,null,{"$f":"M11+M12","v":0}]
[null,"05:30:00",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M13=1,M16,M17)","v":"希望する"}]
[null,"06:00:00",null,null,null,null,null,null,null,null,null,null,"必要ない"]
[null,"06:30:00",null,null,null,null,null,null,null,null,null,null,"本車種は車番情報連絡には対応しておりません。"]
[null,"07:00:00",null,null,null,null,null,null,null,null,null,null,"希望する"]
[null,"07:30:00"]
[null,"08:00:00"]
[null,"08:30:00"]
[null,"選択してください"]
[null,"09:00:00"]
[null,"09:30:00"]
[null,"10:00:00"]
[null,"10:30:00"]
[null,"11:00:00"]
[null,"11:30:00"]
[null,"12:00:00"]
[null,"12:30:00"]
[null,"13:00:00"]
[null,"13:30:00"]
[null,"14:00:00"]
[null,"14:30:00"]
[null,"15:00:00"]
[null,"15:30:00"]
[null,"16:00:00"]
[null,"16:30:00"]
[null,"17:00:00"]
[null,"17:30:00"]
[null,"18:00:00"]
[null,"18:30:00"]
[null,"19:00:00"]
[null,"19:30:00"]
[null,"20:00:00"]
[null,"20:30:00"]
[null,"21:00:00"]
[null,"21:30:00"]
[null,"22:00:00"]
[null,"22:30:00"]
[null,"23:00:00"]
[null,"23:30:00"]