{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["EB","でんさい導入効果検証 ","各種手数料","入力項目","グラフ作成 "],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"EB","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["受付済み",0,0]
["ビジネスIB［スタンダード］",5500,22000]
["ビジネスIB［リアル］",3300,22000]
["ほっと君Web Jr.［スタンダード］",3300,0]
["ほっと君Web Jr.［リアル］",1650,0]

{"sheet":"でんさい導入効果検証 ","index":1,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[10,1,10,10],[10,11,10,17],[2,0,2,1],[3,11,3,13],[11,0,20,0],[15,5,15,9],[18,5,18,9],[15,15,15,16],[16,5,16,9],[16,15,16,16],[17,5,17,9],[17,15,17,16],[28,0,30,0],[28,4,28,9],[28,15,28,16],[26,2,27,4],[26,12,27,14],[21,0,27,0],[24,5,24,9],[26,15,27,16],[26,5,27,9],[29,11,30,16],[29,1,30,9],[24,15,24,16],[25,5,25,9],[26,17,27,17],[26,10,27,10],[29,17,30,17],[29,10,30,10],[11,5,11,9],[12,5,12,9],[13,5,13,9],[21,5,21,9],[22,5,22,9],[23,5,23,9],[18,15,18,16],[19,6,19,9],[20,4,20,9],[20,13,20,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,0,null,null,null,null,"枚",null,"債権発生件数（支払）",null,null,null,{"$f":"F12","v":0},"件",null,"・手形",null,null,null,"・でんさい","※当行所定手数料"]
[null,null,"受取手形",null,null,0,null,null,null,null,"枚",null,"債権受取件数（受取）",null,null,null,{"$f":"F13","v":0},"件",null,"①手形代",66,"（50枚綴り3,300円）",null,"❶発生記録手数料　　※４"]
[null,null,"裏書手形",null,null,0,null,null,null,null,"枚",null,"債権譲渡件数（裏書）",null,null,null,{"$f":"F14","v":0},"件",null,"②印紙代",null,null,null,"・北陸銀行宛",null,330]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・手形",440,"　※１",null,"・他行宛",null,660]
[null,null,"①手形代",null,null,0,null,null,null,null,"円",null,"❶発生記録",null,null,{"$f":"各種手数料!I2+各種手数料!J2","v":0},null,"円",null,"・領収書",440,"　※２",null,"❷決済手数料",null,220]
[null,null,"②印紙代",null,null,0,null,null,null,null,"円",null,"❷決済手数料",null,null,{"$f":"各種手数料!I4","v":0},null,"円",null,"③郵送費",null,null,null,"❸譲渡記録手数料　　※４"]
[null,null,"③郵送費",null,null,0,null,null,null,null,"円",null,"❸譲渡記録",null,null,{"$f":"各種手数料!I3+各種手数料!J3","v":0},null,"円",null,"・手形",519,"（一般書留）",null,"・北陸銀行宛",null,165]
[null,null,"④取立手数料",null,null,0,null,null,null,null,"円",null,"❹EB手数料",null,null,{"$f":"VLOOKUP(入力項目!B5,EB!A1:C5,2,FALSE)*12","v":0},null,"円",null,"・領収書",84,"（普通）",null,"・他行宛",null,330]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"④代金取立手数料",330,"　※３",null,"❹EB手数料（月額）",null,{"$f":"P19","v":0}]
[null,null,"計",null,{"$f":"SUM(F16:J19)","v":0},null,null,null,null,null,"円",null,"計",{"$f":"SUM(P16:Q19)","v":0},null,null,null,"円"]
[" 人件費（年）",null,"⑤支払手形",null,null,0,null,null,null,null,"分",null,"➎でんさい発行",null,null,null,{"$f":"$V$28*F12","v":0},"分"]
[null,null,"⑥受取手形",null,null,0,null,null,null,null,"分",null,"➏でんさい受取",null,null,null,{"$f":"$V$28*F13","v":0},"分"]
[null,null,"⑦裏書譲渡",null,null,0,null,null,null,null,"分",null,"❼でんさい譲渡",null,null,null,{"$f":"$V$28*F14","v":0},"分",null,"人件費　算出条件（/件）"]
[null,null,"計",null,null,{"$f":"SUM(F22:J24)","v":0},null,null,null,null,"分",null,"計",null,null,{"$f":"SUM(Q22:Q24)","v":0},null,"分",null,"⑤支払手形",null,10,"（手形作成5分、郵送作業5分）\n"]
[null,null,"時間単価※",null,null,2500,null,null,null,null,"円",null,null,null,null,null,null,null,null,"⑥受取手形",null,8,"（確認・消込作業2分、取受作業1分、領収書作成・発送5分）"]
[null,null,"人件費",null,null,{"$f":"F25*F26/60","v":0},null,null,null,null,"円",null,"人件費",null,null,{"$f":"P25*F26/60","v":0},null,"円",null,"⑦裏書手形",null,6,"（裏書作業1分、郵送作業5分）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"➎➏❼でんさい",null,3,"（入力作業3分）"]
["合計"]
[null,{"$f":"E21+F27","v":0},null,null,null,null,null,null,null,null,"円",{"$f":"N21+P27","v":0},null,null,null,null,null,"円"]
[]
["※ 厚生労働省 産業別月間実労働時間数・現金給与総額より算出（2015～2019年）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※１ 手形振出し金額10万円以上100万円以下（200円）40％、100万円超200万円以下（400円）40％、"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"300万円越500万円以下（1,000円）20％と仮定"]
["♦本シミュレーションは、当行が設定する独自の算出委条件に基づいて試算する"]
["簡易的なシミュレーションです。実際のコストをお約束するものではございません。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※２ 領収書記載金額5万円以上100万円以下（200円）40％、100万円超200万円以下（400円）40％、"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"300万円越500万円以下（1,000円）20％と仮定"]
["♦でんさいのご利用には当行所定の審査がございます。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※３ 同地交換（220円）50％、遠隔地交換（440円）50％と仮定"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※４ 北陸銀行宛50％、他行宛50％で試算"]

{"sheet":"各種手数料","index":2,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["支払手形","金額","受取手形","金額2","裏書手形","金額3",null,"でんさい","北陸","他行"]
["印紙代",{"$f":"'でんさい導入効果検証 '!$F$12*'でんさい導入効果検証 '!$U15","v":0},"印紙代",{"$f":"'でんさい導入効果検証 '!F13*'でんさい導入効果検証 '!U16","v":0},"印紙代",{"$f":"'でんさい導入効果検証 '!F14*'でんさい導入効果検証 '!U16","v":0},null,"支払",{"$f":"'でんさい導入効果検証 '!F12*入力項目!B4*'でんさい導入効果検証 '!Z14","v":0},{"$f":"'でんさい導入効果検証 '!F12*入力項目!C4*'でんさい導入効果検証 '!Z15","v":0}]
["手形用紙代単価",{"$f":"'でんさい導入効果検証 '!$F$12*'でんさい導入効果検証 '!U13","v":0},"取立手数料",{"$f":"'でんさい導入効果検証 '!F13*'でんさい導入効果検証 '!U20","v":0},"譲渡手形郵送費",{"$f":"'でんさい導入効果検証 '!F14*'でんさい導入効果検証 '!U18","v":0},null,"裏書",{"$f":"'でんさい導入効果検証 '!F14*入力項目!B4*'でんさい導入効果検証 '!Z18","v":0},{"$f":"'でんさい導入効果検証 '!F14*入力項目!C4*'でんさい導入効果検証 '!Z19","v":0}]
["手形郵送費",{"$f":"'でんさい導入効果検証 '!$F$12*'でんさい導入効果検証 '!U18","v":0},"領収書郵送費",{"$f":"'でんさい導入効果検証 '!U19*'でんさい導入効果検証 '!F13","v":0},"領収書郵送費",{"$f":"'でんさい導入効果検証 '!F14*'でんさい導入効果検証 '!U19","v":0},null,"決済手数料",{"$f":"'でんさい導入効果検証 '!F13*'でんさい導入効果検証 '!Z16","v":0}]

{"sheet":"入力項目","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["支払",0]
["受取",0]
["裏書",0]
["割合",0.5,{"$f":"1-B4","v":0.5}]
["EB","受付済み"]

{"sheet":"グラフ作成 ","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["でんさい",{"$f":"'でんさい導入効果検証 '!L30","v":0},{"$f":"IF(B2-B1<0,0,B2-B1)","v":0},{"$f":"B2-B1","v":0}]
["手形",{"$f":"'でんさい導入効果検証 '!B30","v":0},0]
[]
[]
["削減コスト",{"$f":"IF(B2=0,\"\",TEXT(1-B1/B2,\"0.0%\"))","v":""}]
[{"$f":"TEXT(B5,\"0.0%\")&\"の削減\"","v":"の削減"}]