{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["資料輸入"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":67,"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":105,"n_cols":12,"rows_kept":105,"cut":false,"hidden":false,"merged":[[90,2,90,3],[91,4,91,6],[82,4,82,6],[84,4,84,6],[86,4,86,6],[69,5,69,6],[66,7,66,11],[67,7,67,11],[68,7,68,11],[103,11,103,12],[84,10,86,11],[93,10,95,11],[93,4,93,6],[95,4,95,6],[104,1,106,1],[69,7,69,11],[70,7,70,11],[71,7,71,11],[70,5,70,6],[103,3,103,4],[103,8,103,9],[80,2,80,5],[83,7,83,8],[85,7,85,8],[87,7,87,8],[92,7,92,8],[94,7,94,8],[96,7,96,8],[81,2,81,3],[104,9,106,10],[1,1,1,5],[5,13,7,13],[54,1,54,5],[24,5,24,11],[30,5,30,11],[35,5,35,11],[63,4,63,7],[64,6,64,7],[65,6,65,7],[78,1,78,12],[59,7,59,8],[62,10,62,11],[65,4,65,5],[62,1,62,5],[62,6,62,7],[62,8,62,9],[64,4,64,5],[55,1,60,5],[66,1,66,3],[67,1,71,3],[67,5,67,6],[68,5,68,6]]}
[]
[null,"安達人壽美利紅美元分紅終身壽險_建議書 資料輸入頁"]
[]
[null,"客戶資料",null,null,null,null,null,null,null,null,null,"PSSD202504-002-BRSS"]
[]
[]
[]
[null,null,"被保險人",null,"XXX","先生","要保人","XXX","先生/小姐","繳費人","XXX","先生/小姐"]
[]
[null,null,"被保險人出生年月日",null,"74XXX","格式(yyymmdd)","要保人出生年月日","74XXXX","格式(yyymmdd)","繳費人出生年月日","74XXXX","格式(yyymmdd)"]
[]
[null,null,"性    別",null,"男性","下拉選單","性    別","男性","下拉選單","性    別","男性","下拉選單"]
[]
[null,null,"保險年齡",null,40,null,"保險年齡",23,null,"保險年齡",30]
[null,"投保內容"]
[]
[null,null,"商品名稱",null,"安達人壽美利紅美元分紅終身壽險"]
[]
[null,null,"商品幣別",null,"美元"]
[]
[null,null,"繳別",null,"年繳","下拉選單"]
[]
[null,null,"保險年期",null,"保險年齡達110歲"]
[]
[null,null,"繳費期間",null,"3年期"]
[]
[null,null,"繳費方式(首期)",null,"金融機構自動轉帳","下拉選單"]
[]
[null,null,"繳費方式(續期)",null,"金融機構自動轉帳","下拉選單"]
[]
[null,null,"保險金額(元）",null,100000,"15足歲以下:1萬美元~35萬美元；15足歲(含以上): 1萬美元~1000萬美元"]
[]
[]
[null,"分期保險金給付設定"]
[]
[null,null,"分期定期保險金給付期間",null,5,"請輸入5~20年"]
[]
[null,null,"一次給付比例",null,40,"%"]
[]
[null,null,"每期給付比例",null,60,"%"]
[]
[null,"保險費合計"]
[]
[]
[null,null,"首期保費",null,1000000,"元"]
[]
[null,null,"首期折扣後保費",null,1000000,{"$f":"\"元    (  \" & TEXT(#REF!*100, \"0.00\") & \"%  折扣）\"","v":{"$error":"#REF!"}}]
[]
[null,null,"續期保費",null,1000000,"元"]
[]
[null,null,"續期折扣後保費",null,1000000,{"$f":"\"元    (  \" & TEXT(#REF!*100, \"0.00\") & \"%  折扣）\"","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"錄音提示稿相關資料"]
[null,"保經代公司名稱：",null,null,"XX保經",null,null,null,"請輸入保經代公司名稱，例如: 安達保經"]
[null,"業務員姓名：",null,null,"XXX",null,"XXX"]
[null,"業務員登錄證字號：",null,null,"XXXXXXXXXX",null,"XXXXXXXXXX",null,"請輸入登錄證字號，共10碼"]
[]
[null,"投保目的(可複選)",null,null,null,"保障",null,"【適用投保目的】請輸入V，【取消】請空白"]
[null,null,null,null,null,"子女教育經費",null,"【適用投保目的】請輸入V，【取消】請空白"]
[null,null,null,null,null,"退休規劃",null,"【適用投保目的】請輸入V，【取消】請空白"]
[null,null,null,null,null,"房屋貸款",null,"【適用投保目的】請輸入V，【取消】請空白"]
[null,null,null,null,null,"其他\n(請於右方填入內容)",null,"【適用投保目的】請輸入V，【取消】請空白"]
[]
[]
[null,"※  提醒您，本試算表所提出之部份提領申請為繳費期滿後【減少保險金額】，保險金額減少均會減少保單保障、保單價值準備金及解約金等，客戶必須依照自身的財務及保障需求妥適規劃。"]
[null,"※  要保人在本契約有效期間內，得申請減少保險金額，但是減額後的基本保險金額，不得低於本保險最低承保金額，其減少部分依契約終止之約定處理。"]
[null,"※  下列【減少保險金額】之數值為預估值，如投保後需減少保險金額請自行提出契變辦理，詳細規則可參閱保全規則。"]
[null,"※  本公司辦理「減少保險金額」，係先減少基本保險金額。減額後的基本保險金額，不得低於本保險最低承保金額 10000 美元。"]
[null,"部分提領"]
[]
[null,null,"※減額後的「基本保險金額」不得低於本保險最低承保金額!"]
[null,null,"定額提領(減少保險金額)"]
[null,null,null,null,"建議提領試算年齡須至少大於投保年齡加6歲!"]
[null,null,"年齡一",null,null,"歲起","每年提領金額",null,null,"美元"]
[null,null,null,null,{"$f":"IF(E86=\"\",\"\",IF(定額提領年齡二<=定額提領年齡一,\"定額提領試算年齡二需大於定額提領試算年齡一\",\"\"))","v":""}]
[null,null,"年齡二",null,null,"歲起","每年提領金額",null,null,"美元"]
[null,null,null,null,{"$f":"IF(E88=\"\",\"\",IF(定額提領年齡三<=定額提領年齡二,\"定額提領試算年齡三需大於定額提領試算年齡一及年齡二\",\"\"))","v":""}]
[null,null,"年齡三",null,null,"歲起","每年提領金額",null,null,"美元"]
[]
[]
[null,null,"額外一次提領(減少保險金額)"]
[null,null,null,null,"建議提領試算年齡須至少大於投保年齡加6歲!"]
[null,null,"年齡一",null,null,"歲","當次提領金額",null,null,"美元"]
[null,null,null,null,{"$f":"IF($E95=\"\",\"\",IF($E95<=E93,\"定額提領試算年齡二需大於定額提領試算年齡一\",\"\"))","v":""}]
[null,null,"年齡二",null,null,"歲","當次提領金額",null,null,"美元"]
[null,null,null,null,{"$f":"IF(E97=\"\",\"\",IF(E97<=E95,\"定額提領試算年齡三需大於定額提領試算年齡一及年齡二\",\"\"))","v":""}]
[null,null,"年齡三",null,null,"歲","當次提領金額",null,null,"美元"]
[]
[]
[]
[]
[]
[]
[null,"建議書列印頁",null,"商品利益說明表\n(不含紅利部份)",null,null,"商品利益分析表",null,"減少保險金額",null,null,"分期定期保險金給付"]
[null,null,null,null,"建議書列印頁"]