巧用Excel中VBA自定义函数统计教师超课时费  

作　　者：陈静[1] 

机构地区：[1]贵州省毕节职业技术学院,贵州毕节551700

出　　处：《科技创新与应用》2020年第21期130-131,共2页Technology Innovation and Application

摘　　要：文章主要利用excel中VBA编程功能的自定义教师职称系数函数、班级上课人数系数函数、上课门数系数函数、每轮次应减课时节数函数和FOR循环语句来统计教师超课时费,通过编程就能提高教学管理者统计教师超课时费的工作效率。This paper mainly uses the self-defined teacher's professional title coefficient function,the class number coefficient function,the class number coefficient function,the reduced class period function and the FOR cycle sentence of the VBA programming function in excel to count teachers'overtime fees.Through programming,we can improve the efficiency of teaching administrators in counting teachers'overtime fees.

关 键 词：EXCEL VBA编程 函数 超课时费 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]