{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["4人分配表","6人分配表","8人分配表","10人分配表"],"not_rendered":{"charts":0,"images":4,"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":"4人分配表","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,0,25,5],[0,1,0,2],[28,0,28,5],[6,0,6,5],[26,0,26,1],[26,3,26,5]]}
["價金總額"]
[]
["項目","人員A","人員B","人員C","人員D","合計"]
["持分",null,null,null,null,{"$f":"SUM(B4:E4)","v":0}]
["分配金額",{"$f":"IF(B4<>\"\", ROUND(B4*$B$1, 0), 0)","v":0},{"$f":"IF(C4<>\"\", ROUND(SUM(B4:C4)*$B$1, 0) - SUM(B5:B5), 0)","v":0},{"$f":"IF(D4<>\"\", ROUND(SUM(B4:D4)*$B$1, 0) - SUM(B5:C5), 0)","v":0},{"$f":"IF(E4<>\"\", ROUND(SUM(B4:E4)*$B$1, 0) - SUM(B5:D5), 0)","v":0},{"$f":"SUM(B5:E5)","v":0}]
[]
["--- 支出項目 ---"]
["仲介費",null,null,null,null,{"$f":"SUM(B8:E8)","v":0}]
["土增稅",null,null,null,null,0]
["繳稅匯費",null,null,null,null,0]
["地價稅",null,null,null,null,0]
["房屋稅",null,null,null,null,0]
["稅費分算",null,null,null,null,0]
["二胎",null,null,null,null,0]
["水電費",null,null,null,null,0]
["代書費",null,null,null,null,0]
["銀行貸款",null,null,null,null,0]
["其他(可自填)1",null,null,null,null,0]
["其他(可自填)2",null,null,null,null,0]
["其他(可自填)3",null,null,null,null,0]
[]
["支出項目合計",{"$f":"IF(B4<>\"\", SUM(B8:B20), 0)","v":0},{"$f":"IF(C4<>\"\", SUM(C8:C20), 0)","v":0},{"$f":"IF(D4<>\"\", SUM(D8:D20), 0)","v":0},{"$f":"IF(E4<>\"\", SUM(E8:E20), 0)","v":0},{"$f":"SUM(B22:E22)","v":0}]
[]
["履保結餘款",{"$f":"IF(B4<>\"\", B5-B22, 0)","v":0},{"$f":"IF(C4<>\"\", C5-C22, 0)","v":0},{"$f":"IF(D4<>\"\", D5-D22, 0)","v":0},{"$f":"IF(E4<>\"\", E5-E22, 0)","v":0},{"$f":"SUM(B24:E24)","v":0}]
[]
[]
["上述金額經各共有人確認無誤。",null,null,"簽名："]
[]
["中華民國        年        月        日"]

{"sheet":"6人分配表","index":1,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,0,6,7],[25,0,25,7],[0,1,0,3],[28,0,28,7],[26,0,26,1],[26,5,26,7]]}
["價金總額"]
[]
["項目","人員A","人員B","人員C","人員D","人員E","人員F","合計"]
["持分",null,null,null,null,null,null,{"$f":"SUM(B4:G4)","v":0}]
["分配金額",{"$f":"IF(B4<>\"\", ROUND(B4*$B$1, 0), 0)","v":0},{"$f":"IF(C4<>\"\", ROUND(SUM(B4:C4)*$B$1, 0) - SUM(B5:B5), 0)","v":0},{"$f":"IF(D4<>\"\", ROUND(SUM(B4:D4)*$B$1, 0) - SUM(B5:C5), 0)","v":0},{"$f":"IF(E4<>\"\", ROUND(SUM(B4:E4)*$B$1, 0) - SUM(B5:D5), 0)","v":0},{"$f":"IF(F4<>\"\", ROUND(SUM(B4:F4)*$B$1, 0) - SUM(B5:E5), 0)","v":0},{"$f":"IF(G4<>\"\", ROUND(SUM(B4:G4)*$B$1, 0) - SUM(B5:F5), 0)","v":0},{"$f":"SUM(B5:G5)","v":0}]
[]
["--- 支出項目 ---"]
["仲介費",null,null,null,null,null,null,{"$f":"SUM(B8:G8)","v":0}]
["土增稅",null,null,null,null,null,null,0]
["繳稅匯費",null,null,null,null,null,null,0]
["地價稅",null,null,null,null,null,null,0]
["房屋稅",null,null,null,null,null,null,0]
["稅費分算",null,null,null,null,null,null,0]
["二胎",null,null,null,null,null,null,0]
["水電費",null,null,null,null,null,null,0]
["代書費",null,null,null,null,null,null,0]
["銀行貸款",null,null,null,null,null,null,0]
["其他(可自填)1",null,null,null,null,null,null,0]
["其他(可自填)2",null,null,null,null,null,null,0]
["其他(可自填)3",null,null,null,null,null,null,0]
[]
["支出項目合計",{"$f":"IF(B4<>\"\", SUM(B8:B20), 0)","v":0},0,0,0,0,0,{"$f":"SUM(B22:G22)","v":0}]
[]
["履保結餘款",{"$f":"IF(B4<>\"\", B5-B22, 0)","v":0},0,0,0,0,0,{"$f":"SUM(B24:G24)","v":0}]
[]
[]
["上述金額經各共有人確認無誤。",null,null,null,null,"簽名："]
[]
["中華民國        年        月        日"]

{"sheet":"8人分配表","index":2,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,9],[0,1,0,3],[25,0,25,9],[6,0,6,9],[26,0,26,1],[26,7,26,9]]}
["價金總額"]
[]
["項目","人員A","人員B","人員C","人員D","人員E","人員F","人員G","人員H","合計"]
["持分",null,null,null,null,null,null,null,null,{"$f":"SUM(B4:I4)","v":0}]
["分配金額",{"$f":"IF(B4<>\"\", ROUND(B4*$B$1, 0), 0)","v":0},{"$f":"IF(C4<>\"\", ROUND(SUM(B4:C4)*$B$1, 0) - SUM(B5:B5), 0)","v":0},{"$f":"IF(D4<>\"\", ROUND(SUM(B4:D4)*$B$1, 0) - SUM(B5:C5), 0)","v":0},{"$f":"IF(E4<>\"\", ROUND(SUM(B4:E4)*$B$1, 0) - SUM(B5:D5), 0)","v":0},{"$f":"IF(F4<>\"\", ROUND(SUM(B4:F4)*$B$1, 0) - SUM(B5:E5), 0)","v":0},{"$f":"IF(G4<>\"\", ROUND(SUM(B4:G4)*$B$1, 0) - SUM(B5:F5), 0)","v":0},{"$f":"IF(H4<>\"\", ROUND(SUM(B4:H4)*$B$1, 0) - SUM(B5:G5), 0)","v":0},{"$f":"IF(I4<>\"\", ROUND(SUM(B4:I4)*$B$1, 0) - SUM(B5:H5), 0)","v":0},{"$f":"SUM(B5:I5)","v":0}]
[]
["--- 支出項目 ---"]
["仲介費",null,null,null,null,null,null,null,null,{"$f":"SUM(B8:I8)","v":0}]
["土增稅",null,null,null,null,null,null,null,null,0]
["繳稅匯費",null,null,null,null,null,null,null,null,0]
["地價稅",null,null,null,null,null,null,null,null,0]
["房屋稅",null,null,null,null,null,null,null,null,0]
["稅費分算",null,null,null,null,null,null,null,null,0]
["二胎",null,null,null,null,null,null,null,null,0]
["水電費",null,null,null,null,null,null,null,null,0]
["代書費",null,null,null,null,null,null,null,null,0]
["銀行貸款",null,null,null,null,null,null,null,null,0]
["其他(可自填)1",null,null,null,null,null,null,null,null,0]
["其他(可自填)2",null,null,null,null,null,null,null,null,0]
["其他(可自填)3",null,null,null,null,null,null,null,null,0]
[]
["支出項目合計",{"$f":"IF(B4<>\"\", SUM(B8:B20), 0)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(B22:I22)","v":0}]
[]
["履保結餘款",{"$f":"IF(B4<>\"\", B5-B22, 0)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(B24:I24)","v":0}]
[]
[]
["上述金額經各共有人確認無誤。",null,null,null,null,null,null,"簽名："]
[]
["中華民國        年        月        日"]

{"sheet":"10人分配表","index":3,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,0,25,11],[0,1,0,3],[28,0,28,11],[6,0,6,11],[26,0,26,1],[26,10,26,11]]}
["價金總額"]
[]
["項目","人員A","人員B","人員C","人員D","人員E","人員F","人員G","人員H","人員I","人員J","合計"]
["持分",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:K4)","v":0}]
["分配金額",{"$f":"IF(B4<>\"\", ROUND(B4*$B$1, 0), 0)","v":0},{"$f":"IF(C4<>\"\", ROUND(SUM(B4:C4)*$B$1, 0) - SUM(B5:B5), 0)","v":0},{"$f":"IF(D4<>\"\", ROUND(SUM(B4:D4)*$B$1, 0) - SUM(B5:C5), 0)","v":0},{"$f":"IF(E4<>\"\", ROUND(SUM(B4:E4)*$B$1, 0) - SUM(B5:D5), 0)","v":0},{"$f":"IF(F4<>\"\", ROUND(SUM(B4:F4)*$B$1, 0) - SUM(B5:E5), 0)","v":0},{"$f":"IF(G4<>\"\", ROUND(SUM(B4:G4)*$B$1, 0) - SUM(B5:F5), 0)","v":0},{"$f":"IF(H4<>\"\", ROUND(SUM(B4:H4)*$B$1, 0) - SUM(B5:G5), 0)","v":0},{"$f":"IF(I4<>\"\", ROUND(SUM(B4:I4)*$B$1, 0) - SUM(B5:H5), 0)","v":0},{"$f":"IF(J4<>\"\", ROUND(SUM(B4:J4)*$B$1, 0) - SUM(B5:I5), 0)","v":0},{"$f":"IF(K4<>\"\", ROUND(SUM(B4:K4)*$B$1, 0) - SUM(B5:J5), 0)","v":0},{"$f":"SUM(B5:K5)","v":0}]
[]
["--- 支出項目 ---"]
["仲介費",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B8:K8)","v":0}]
["土增稅",null,null,null,null,null,null,null,null,null,null,0]
["繳稅匯費",null,null,null,null,null,null,null,null,null,null,0]
["地價稅",null,null,null,null,null,null,null,null,null,null,0]
["房屋稅",null,null,null,null,null,null,null,null,null,null,0]
["稅費分算",null,null,null,null,null,null,null,null,null,null,0]
["二胎",null,null,null,null,null,null,null,null,null,null,0]
["水電費",null,null,null,null,null,null,null,null,null,null,0]
["代書費",null,null,null,null,null,null,null,null,null,null,0]
["銀行貸款",null,null,null,null,null,null,null,null,null,null,0]
["其他(可自填)1",null,null,null,null,null,null,null,null,null,null,0]
["其他(可自填)2",null,null,null,null,null,null,null,null,null,null,0]
["其他(可自填)3",null,null,null,null,null,null,null,null,null,null,0]
[]
["支出項目合計",{"$f":"IF(B4<>\"\", SUM(B8:B20), 0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B22:K22)","v":0}]
[]
["履保結餘款",{"$f":"IF(B4<>\"\", B5-B22, 0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(B24:K24)","v":0}]
[]
[]
["上述金額經各共有人確認無誤。",null,null,null,null,null,null,null,null,"簽名："]
[]
["中華民國        年        月        日"]