{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["■仲介手数料計算"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":0,"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":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,21,4],[1,4,1,5],[14,2,14,4],[20,2,20,4],[8,5,9,5],[15,2,15,4]]}
[]
[null,"■仲介手数料計算",null,null,"EDUPORT"]
[]
[null,"売買価格",2100000,{"$f":"IF(C4=\"\",\"\",C4/10000)","v":210},"消 費 税",0.08]
[null,"加算額",null,{"$f":"IF(C5=\"\",\"\",C5/10000)","v":""},"免税業者",3.2000000000000001E-2]
[null,"加算額（最大値）",{"$f":"IF(F12=\"\",\"\",IF(180000-F12<0,0,180000-F12))","v":76000},{"$f":"IF(C6=\"\",\"\",C6/10000)","v":7.6}]
[null,"※売買価格が400万円以下の場合の手数料加算額（税抜き価格）"]
[]
[null,"価格幅","200万円まで","200万円超～\n400万円まで","400万円超～","合　計"]
[null,"料　率",0.05,0.04,0.03]
[null,"割　当",{"$f":"IF(C4=\"\",\"\",IF(C4>=2000000,2000000,C4))","v":2000000},{"$f":"IF(C4=\"\",\"\",IF(C4>=4000000,2000000,IF(AND(C4>2000000,C4<=4000000),C4-2000000,0)))","v":100000},{"$f":"IF(C4=\"\",\"\",IF(C4>4000000,C4-4000000,0))","v":0},{"$f":"IF(C4=\"\",\"\",SUM(C11:E11))","v":2100000}]
[null,"手数料",{"$f":"IF(C4=\"\",\"\",C10*C11)","v":100000},{"$f":"IF(C4=\"\",\"\",D10*D11)","v":4000},{"$f":"IF(C4=\"\",\"\",E10*E11)","v":0},{"$f":"IF(C4=\"\",\"\",SUM(C12:E12))","v":104000}]
[null,"消費税",{"$f":"IF(C4=\"\",\"\",C12*$F$4)","v":8000},{"$f":"IF(C4=\"\",\"\",D12*$F$4)","v":320},{"$f":"IF(C4=\"\",\"\",E12*$F$4)","v":0},{"$f":"IF(C4=\"\",\"\",F12*$F$4)","v":8320}]
[null,"仲介手数料（税込）",{"$f":"IF(C4=\"\",\"\",SUM(C12:C13))","v":108000},{"$f":"IF(C4=\"\",\"\",SUM(D12:D13))","v":4320},{"$f":"IF(C4=\"\",\"\",SUM(E12:E13))","v":0},{"$f":"IF(C4=\"\",\"\",SUM(F12:F13))","v":112320}]
[null,"速算式","※ 400万円超の場合、｛（売買代金×3％）＋6万円｝＋消費税",null,null,{"$f":"IF(C4>4000000,((C4*3%)+60000)*(1+F4),\"－\")","v":"－"},null,{"$f":"IF(F14=F15,\"上と同じ\",\"\")","v":""}]
[null,"仲介手数料（税込）","※ 400万円以下の場合の手数料加算額を含む",null,null,{"$f":"IF(F14=\"\",\"－\",IF((SUM(F12,C5))<=180000,SUM(F12,C5)+SUM(F12,C5)*F4,\"－\"))","v":112320}]
[]
[null,"▽免税業者"]
[null,"消費税",{"$f":"IF(C4=\"\",\"\",C12*$F$5)","v":3200},{"$f":"IF(C4=\"\",\"\",D12*$F$5)","v":128},{"$f":"IF(C4=\"\",\"\",E12*$F$5)","v":0},{"$f":"IF(C4=\"\",\"\",F12*$F$5)","v":3328}]
[null,"仲介手数料（税込）",{"$f":"IF(C4=\"\",\"\",SUM(C12,C19))","v":103200},{"$f":"IF(C4=\"\",\"\",SUM(D12,D19))","v":4128},{"$f":"IF(C4=\"\",\"\",SUM(E12,E19))","v":0},{"$f":"IF(C4=\"\",\"\",SUM(F12,F19))","v":107328}]
[null,"速算式","※ 400万円超の場合、｛（売買代金×3％）＋6万円｝＋消費税（免業用）",null,null,{"$f":"IF(C4>4000000,((C4*3%)+60000)*(1+F5),\"－\")","v":"－"},null,{"$f":"IF(F20=F21,\"上と同じ\",\"\")","v":""}]
[null,"仲介手数料（税込）","※ 400万円以下の場合の手数料加算額を含む",null,null,{"$f":"IF(F20=\"\",\"－\",IF((SUM(F12,C5))<=180000,SUM(F12,C5)+SUM(F12,C5)*F5,\"－\"))","v":107328}]