{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["銷售佣金計算工具"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"銷售佣金計算工具","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,3]]}
[null,"銷售佣金計算工具"]
[null,"佣金百分比","總銷售額","支付的佣金總計"]
[null,{"v":0.1,"d":"10.0%"},{"$f":"總_銷售額","v":{"v":689306,"d":"NT$689,306.00"}},{"$f":"總_佣金","v":{"v":68930.6,"d":"NT$68,930.60"}}]
[]
[null,"銷售人員","銷售總金額","佣金"]
[null,"人員 1",{"v":332456,"d":"NT$332,456.00"},{"$f":"IFERROR(IF(C6>0,C6*$B$3,\"\"), \"\")","v":{"v":33245.6,"d":"NT$33,245.60"}}]
[null,"人員 2",{"v":228960,"d":"NT$228,960.00"},{"$f":"IFERROR(IF(C7>0,C7*$B$3,\"\"), \"\")","v":{"v":22896,"d":"NT$22,896.00"}}]
[null,"人員 3",{"v":127890,"d":"NT$127,890.00"},{"v":12789,"d":"NT$12,789.00"}]
[{"$nulls":3},""]
[{"$nulls":3},""]
[null,"合計",{"$f":"SUBTOTAL(109,銷售[銷售總金額])","v":{"v":689306,"d":"NT$689,306.00"}},{"$f":"SUBTOTAL(109,銷售[佣金])","v":{"v":68930.6,"d":"NT$68,930.60"}}]