{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["校外人员劳务费发放表（样式）"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"校外人员劳务费发放表（样式）","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,8],[8,0,8,3],[9,0,9,11],[10,0,10,11],[11,0,11,11],[15,0,15,11],[21,1,21,6],[21,8,21,11],[22,1,22,6],[23,1,23,6],[24,1,24,7]],"flags":["formulas_cached_only"]}
["柳州职业技术大学   **技能大赛专家评审/培训费  发放表"]
["部门：机电工程学院                                    2020年 4 月 26 日                       经费项目名称：**项目经费"]
["发放依据：**文件或者**审批报告等"]
["序号","姓名","工作单位及职务或职称","标准\n（元/课时）","课时数","应发金额（元）","应缴税（元）","实发金额（元）","身份证号","开户行","银行账号","备注"]
[1,"张××","广西大学，副教授","1000元/天",1,{"v":1050,"d":"1,050.00"},{"v":50,"d":"50.00"},{"v":1000,"d":"1000.00"},"4502001110000","交行西江支行","622262058888888"]
[2,"李××","北京大学、院士","4000元/天",1,{"v":4761.904761904762,"d":"4,761.90"},{"v":761.9,"d":"761.90"},{"v":4000,"d":"4000.00"},"4502001111111","交行西江支行","622262059999999"]
[3,"……"]
[4,"……"]
["小计",{"$nulls":3},2,{"v":5811.904761904762,"d":"5,811.90"},{"v":811.9,"d":"811.90"},{"v":5000,"d":"5,000.00"}]
["实发金额合计: ⓧ 佰  ⓧ 拾  ⓧ 万  伍仟  零佰  零拾  零元  零角  零分         ￥5000.00"]
["经办人：王**          部门(项目)负责人： 李**          会计审核：                科长审核：                    财务审批："]
["出纳：                分管部门校领导：                        分管财务校领导：                       校长审批："]
[]
[]
[]
["此行以下无需打印出来："]
[]
[null,"1、如果发放的人数较多，可以分页制表，但\"合计及领导签字\"栏统一放在最后一页，其他页面无需保留。"]
[null,"2、若发现金，银行账号、开户行可以不填，“备注”栏改成“签收人”。"]
[null,"3、发放人"]
[null,"5.计税公式："]
[null,"（1）已知应发金额：",{"$nulls":6},"（2）已知实发金额:"]
[null,"    ①800元<应发金额≤4000元，应缴税=（应发金额-800）×20%",{"$nulls":6},"    ①实发金额≤3360元，应发金额=实发金额×1.25-200"]
[null,"    ②4000元<应发金额≤20000元，应缴税=应发金额×80%×20%",{"$nulls":6},"    ②实发金额>3360元，应发金额=实发金额÷0.84"]