{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["－試算e"],"not_rendered":{"charts":0,"images":0,"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":"－試算e","index":0,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[45,16,45,17],[45,18,45,19],[46,16,46,17],[46,18,46,19],[42,16,42,17],[42,18,42,19],[43,16,43,17],[43,18,43,19],[44,16,44,17],[44,18,44,19],[41,0,41,14],[41,16,41,17],[41,18,41,19],[38,4,38,14],[38,16,38,17],[38,18,38,19],[39,4,39,14],[39,16,39,17],[39,18,39,19],[35,0,35,14],[35,16,35,17],[35,18,35,19],[36,0,40,3],[36,4,36,14],[36,16,36,17],[36,18,36,19],[37,4,37,14],[37,16,37,17],[37,18,37,19],[40,4,40,14],[40,16,40,17],[40,18,40,19],[33,4,33,14],[33,16,33,17],[33,18,33,19],[34,4,34,14],[34,16,34,17],[34,18,34,19],[30,0,34,3],[30,4,30,14],[30,16,30,17],[30,18,30,19],[31,4,31,14],[31,16,31,17],[31,18,31,19],[32,4,32,14],[32,16,32,17],[32,18,32,19],[28,0,28,14],[28,16,28,17],[28,18,28,19],[29,0,29,14],[29,16,29,17],[29,18,29,19],[26,0,26,14],[26,16,26,17],[26,18,26,19],[27,0,27,14],[27,16,27,17],[27,18,27,19],[24,0,24,14],[24,16,24,17],[24,18,24,19],[25,0,25,14],[25,16,25,17],[25,18,25,19],[22,0,22,14],[22,16,22,17],[22,18,22,19],[23,0,23,14],[23,16,23,17],[23,18,23,19],[20,0,20,14],[20,16,20,17],[20,18,20,19],[21,0,21,14],[21,16,21,17],[21,18,21,19],[18,0,18,14],[18,16,18,17],[18,18,18,19],[19,0,19,14],[19,16,19,17],[19,18,19,19],[16,0,16,14],[16,16,16,17],[16,18,16,19],[17,0,17,14],[17,16,17,17],[17,18,17,19],[14,0,14,1],[14,7,14,8],[14,14,14,15],[14,16,14,17],[14,18,14,19],[15,16,15,17],[15,18,15,19],[12,0,12,1],[12,7,12,8],[12,14,12,15],[12,16,12,17],[12,18,12,19],[13,0,13,1],[13,7,13,8],[13,14,13,15],[13,16,13,17],[13,18,13,19],[10,0,10,1],[10,7,10,8],[10,14,10,15],[10,16,10,17],[10,18,10,19],[11,0,11,1],[11,7,11,8],[11,14,11,15],[11,16,11,17],[11,18,11,19],[8,16,8,17],[8,18,8,19],[9,0,9,1],[9,7,9,8],[9,14,9,15],[9,16,9,17],[9,18,9,19],[7,0,8,1],[7,2,7,8],[7,9,7,15],[7,16,7,19],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,10,8,11],[8,12,8,13],[8,14,8,15],[3,0,3,1],[3,3,3,4],[3,9,3,10],[3,11,3,12],[3,13,3,15],[5,0,5,3],[5,5,5,19],[0,0,0,15],[0,16,0,19],[2,0,2,1],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,15]]}
["　　　　　共済使用有無による参考用掛金差額（特約、割引反映無しの概算）　ver.e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design by Mhosotan"]
[]
["現在契約",null,"等級","掛金",null,"事故有／係数",null,"優割／係数",null,"係数無し掛金",null,"次回6，7等級",null,"契約者"]
["現在契約",null,17,35000,null,0,{"$f":"IFERROR(VLOOKUP(C4, $P$18:$S$47,IF(F4>0,4,2),0),\"\")","v":-0.53},0,{"$f":"IF(H4=0,0,IF(H4=1,-0.02,IF(H4=2,-0.03,IF(H4=3,-0.04,IF(H4=4,-0.05,IF(H4=5,-0.06,0))))))","v":0},{"$f":"IFERROR(IF(D4=0,0,D4/(1+(G4+I4))),\"\")","v":74468.085106382976},null,"F　継続契約",null,"農協　太郎"]
[]
["事故での等級ダウン数",null,null,null,3,{"$f":"IF(E6<=1,\"(*^-^)ﾆｺ\",IF(AND(E6>1,E6<=3),\"(w＿－； ｳｩ･･\",\"Σ(￣ロ￣lll)　ｶﾞﾋﾞｰﾝ\"))","v":"(w＿－； ｳｩ･･"}]
[]
["年度",null,"共済使用",null,null,null,null,null,null,"共済使用せず",null,null,null,null,null,null,"掛金差額"]
[null,null,"等級","事故有／係数",null,"優割／係数",null,"掛金",null,"等級","事故有／係数",null,"優割／係数",null,"掛金",null,"年差額",null,"累積差額"]
["1年目",null,{"$f":"IF(LEFT(C4,1)=\"7\",7-E6,IF(LEFT(C4,1)=\"6\",IF(E6=6,1,6-E6),IF(OR(E6=0,C4=0),C4,IF(C4-E6<1,1,C4-E6))))","v":14},{"$f":"IF(E6+F4>6,6,IF(F4=0,E6,F4+E6-1))","v":3},{"$f":"IF(OR(LEFT(C10,1)=\"7\",(LEFT(C10,1)=\"6\")),IFERROR(VLOOKUP(C10&LEFT($L$4,1), $P$18:$S$47,IF(D10>0,4,2),0),\"\"),IFERROR(VLOOKUP(C10, $P$18:$S$47,IF(D10>0,4,2),0),\"\"))","v":-0.31},0,{"$f":"IF(F10=0,0,IF(F10=1,-0.02,IF(F10=2,-0.03,IF(F10=3,-0.04,IF(F10=4,-0.05,IF(F10=5,-0.06,0))))))","v":0},{"$f":"IFERROR(IF($D$4=0,0,$J$4*(1+(E10+G10))),\"\")","v":51382.978723404252},null,{"$f":"IF(LEFT(C4,1)=\"7\",8,IF(LEFT(C4,1)=\"6\",7,IF(OR(E6=0,C4=0),C4,IF(C4+1>=20,20,C4+1))))","v":18},{"$f":"IF(F4-1<=0,0,F4-1)","v":0},{"$f":"IF(OR(LEFT(J10,1)=\"7\",(LEFT(J10,1)=\"6\")),IFERROR(VLOOKUP(J10&LEFT($L$4,1), $P$18:$S$47,IF(K10>0,4,2),0),\"\"),IFERROR(VLOOKUP(J10, $P$18:$S$47,IF(K10>0,4,2),0),\"\"))","v":-0.54},{"$f":"IF(OR(F4>0,C4<>20),0,IF(H4=5,5,H4+1))","v":0},{"$f":"IF(M10=0,0,IF(M10=1,-0.02,IF(M10=2,-0.03,IF(M10=3,-0.04,IF(M10=4,-0.05,IF(M10=5,-0.06,0))))))","v":0},{"$f":"IFERROR(IF($D$4=0,0,$J$4*(1+(L10+N10))),\"\")","v":34255.319148936163},null,{"$f":"IFERROR(H10-O10,\"\")","v":17127.659574468089},null,{"$f":"Q10","v":17127.659574468089}]
["2年目",null,{"$f":"IF($C$10=0,\"\", IF(C10+1>=20,20,$C$10+1))","v":15},{"$f":"IF($D$10=0,0,IF(D10<=1,0,$D$10-1))","v":2},{"$f":"IF(OR(LEFT(C11,1)=\"7\",(LEFT(C11,1)=\"6\")),IFERROR(VLOOKUP(C11&LEFT($L$4,1), $P$18:$S$47,IF(D11>0,4,2),0),\"\"),IFERROR(VLOOKUP(C11, $P$18:$S$47,IF(D11>0,4,2),0),\"\"))","v":-0.33},{"$f":"IF(OR(C10<20,D10>0),0,IF(C11=20,F10+1))","v":0},{"$f":"IF(F11=0,0,IF(F11=1,-0.02,IF(F11=2,-0.03,IF(F11=3,-0.04,IF(F11=4,-0.05,IF(F11=5,-0.06,0))))))","v":0},{"$f":"IFERROR(IF($D$4=0,0,$J$4*(1+(E11+G11))),\"\")","v":49893.617021276586},null,{"$f":"IF($J$10=0,\"\", IF(J10+1>=20,20,$J$10+1))","v":19},{"$f":"IF($K$10=0,0,IF(K10<=1,0,$K$10-1))","v":0},{"$f":"IF(OR(LEFT(J11,1)=\"7\",(LEFT(J11,1)=\"6\")),IFERROR(VLOOKUP(J11&LEFT($L$4,1), $P$18:$S$47,IF(K11>0,4,2),0),\"\"),IFERROR(VLOOKUP(J11, $P$18:$S$47,IF(K11>0,4,2),0),\"\"))","v":-0.55000000000000004},{"$f":"IF(OR(K10>0,J10<20),0,IF($M$10>=5,5,IF(M10>=5,5,M10+1)))","v":0},{"$f":"IF(M11=0,0,IF(M11=1,-0.02,IF(M11=2,-0.03,IF(M11=3,-0.04,IF(M11=4,-0.05,IF(M11=5,-0.06,0))))))","v":0},{"$f":"IFERROR(IF($D$4=0,0,$J$4*(1+(L11+N11))),\"\")","v":33510.638297872334},null,{"$f":"IFERROR(H11-O11,\"\")","v":16382.978723404252},null,{"$f":"IFERROR(S10+Q11,\"\")","v":33510.638297872341}]
["3年目",null,{"$f":"IF($C$10=0,\"\", IF(C11+1>=20,20,$C$10+2))","v":16},{"$f":"IF($D$10=0,0,IF(D11<=1,0,$D$10-2))","v":1},-0.36,{"$f":"IF(OR(C11<20,D11>0),0,IF(C12=20,F11+1))","v":0},0,47659.574468085106,null,{"$f":"IF($J$10=0,\"\", IF(J11+1>=20,20,$J$10+2))","v":20},{"$f":"IF($K$10=0,0,IF(K11<=1,0,$K$10-2))","v":0},-0.63,{"$f":"IF(OR(K11>0,J11<20),0,IF($M$10>=5,5,IF(M11>=5,5,M11+1)))","v":0},0,27553.191489361699,null,20106.382978723406,null,{"$f":"IFERROR(S11+Q12,\"\")","v":53617.021276595748}]
["4年目",null,{"$f":"IF($C$10=0,\"\", IF(C12+1>=20,20,$C$10+3))","v":17},{"$f":"IF($D$10=0,0,IF(D12<=1,0,$D$10-3))","v":0},-0.53,0,0,35000,null,{"$f":"IF($J$10=0,\"\", IF(J12+1>=20,20,$J$10+3))","v":20},{"$f":"IF($K$10=0,0,IF(K12<=1,0,$K$10-3))","v":0},-0.63,1,-0.02,26063.829787234041,null,8936.1702127659591,null,62553.191489361707]
["5年目",null,{"$f":"IF($C$10=0,\"\", IF(C13+1>=20,20,$C$10+4))","v":18},{"$f":"IF($D$10=0,0,IF(D13<=1,0,$D$10-4))","v":0},-0.54,0,0,34255.319148936163,null,{"$f":"IF($J$10=0,\"\", IF(J13+1>=20,20,$J$10+4))","v":20},{"$f":"IF($K$10=0,0,IF(K13<=1,0,$K$10-4))","v":0},-0.63,2,-0.03,25319.148936170208,null,8936.1702127659555,null,71489.361702127659]
["6年目",null,{"$f":"IF($C$10=0,\"\", IF(C14+1>=20,20,$C$10+5))","v":19},{"$f":"IF($D$10=0,0,IF(D14<=1,0,$D$10-5))","v":0},-0.55000000000000004,0,0,33510.638297872334,null,{"$f":"IF($J$10=0,\"\", IF(J14+1>=20,20,$J$10+5))","v":20},{"$f":"IF($K$10=0,0,IF(K14<=1,0,$K$10-5))","v":0},-0.63,3,-0.04,24574.468085106379,null,8936.1702127659555,null,80425.531914893611]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"約款",null,"JID18A"]
["等級別割増・割引率表",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"等級","無事故係数",null,"事故有係数"]
["φ(..)メモメモ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,-0.63,null,-0.44]
["2年契約の試算",null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,-0.55000000000000004,null,-0.42]
["①　1事故の差額　2等級ダウンとし1年目の「共済使用」掛金から2等級アップの「共済使用せず」掛金を引く",null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,-0.54,null,-0.4]
["②　2事故の差額　5等級ダウンとし1年目の「共済使用」掛金から2等級アップの「共済使用せず」掛金を引く",null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,-0.53,null,-0.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,-0.52,null,-0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,-0.51,null,-0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,-0.5,null,-0.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,-0.49,null,-0.28999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,-0.48,null,-0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,-0.47,null,-0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,-0.45,null,-0.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,-0.43,null,-0.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,-0.4,null,-0.21]
["複数台所有者優遇措置適用契約",null,null,null,"年齢を問わず保証",null,null,null,null,null,null,null,null,null,null,"7A",0.11,null,0.11]
[null,null,null,null,"運転者年齢　21歳以上限定保証",null,null,null,null,null,null,null,null,null,null,"7B",-0.11,null,-0.11]
[null,null,null,null,"運転者年齢　26歳以上限定保証",null,null,null,null,null,null,null,null,null,null,"7C",-0.4,null,-0.4]
[null,null,null,null,"運転者年齢　35歳以上限定保証",null,null,null,null,null,null,null,null,null,null,"7G",-0.4,null,-0.4]
[null,null,null,null,"運転者年齢条件を適用できない用途車種の契約",null,null,null,null,null,null,null,null,null,null,"7D",-0.39,null,-0.39]
["継続契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7F",-0.3,null,-0.2]
["前契約のない純粋新規契約",null,null,null,"年齢を問わず保証",null,null,null,null,null,null,null,null,null,null,"6A",0.28000000000000003,null,0.28000000000000003]
[null,null,null,null,"運転者年齢　21歳以上限定保証",null,null,null,null,null,null,null,null,null,null,"6B",0.03,null,0.03]
[null,null,null,null,"運転者年齢　26歳以上限定保証",null,null,null,null,null,null,null,null,null,null,"6C",-0.09,null,-0.09]
[null,null,null,null,"運転者年齢　35歳以上限定保証",null,null,null,null,null,null,null,null,null,null,"6G",-0.09,null,-0.09]
[null,null,null,null,"運転者年齢条件を適用できない用途車種の契約",null,null,null,null,null,null,null,null,null,null,"6D",0,null,0]
["継続契約",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6F",-0.19,null,-0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0.1,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.35,null,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.51,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.62,null,0.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1.1499999999999999,null,1.1499999999999999]