The Allocation and Statistics of Quota of Teaching-Practicing Normal Graduates: Based on Excel Built-in Function and VBA

Hong Juan Wu; Jiao Guo

doi:10.4028/www.scientific.net/AMR.787.987

Paper Titles

Facial Diagnosis of Chinese Medical Syndromes of CHB and its Correlation with Liver Function
p.965

Rescheduling Problems with Deteriorating Jobs to Minimize the Tardiness Costs under Time Disruptions
p.973

Research and Implementation of Time Synchronization Protocol Based on the ZigBee
p.978

CANbus Hybrid Scheduling Algorithm Based on DMS and EDF
p.982

The Allocation and Statistics of Quota of Teaching-Practicing Normal Graduates: Based on Excel Built-in Function and VBA
p.987

Differences in the Usage of Information Systems Applied by the German and Hungarian Micro-Enterprises
p.991

Game Analysis on the Shareholders, the Manager and the Auditor in Equity Incentive Process
p.997

Selection of Engineering Management University Internship Projects Based on Fuzzy Analytic Hierarchy Process
p.1002

The (G'/G,1/G)-Expansion Method for Solving the (2+1)-Dimensional Breaking Soliton Equations
p.1006

HomeAdvanced Materials ResearchAdvanced Materials Research Vol. 787The Allocation and Statistics of Quota of...

The Allocation and Statistics of Quota of Teaching-Practicing Normal Graduates: Based on Excel Built-in Function and VBA

Abstract:

This paper proposes an VBA add in function for excel for a dynamic statistics and allocation table for the quota of teaching-practicing normal graduates. The add in function initially calls some built-in functions such as SUMPRODUCT to sum all interlaced and partition columns. Then it applies the "protection attribute" of cell and "protect worksheet function" to protect the worksheets layout and existing formulas. After added the menu design by VBA programming, it finishes the dynamic statistical sheet in form of the template. This add in function has been approved that the efficiency of allocating the quota of teaching-practicing graduates can be improved a lot through this powerful add in.

You might also be interested in these eBooks

Advanced Materials Researches, Engineering and Manufacturing Technologies in Industry

View Preview

Info:

Periodical:

Advanced Materials Research (Volume 787)

Pages:

987-990

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.787.987

Citation:

Cite this paper

Online since:

September 2013

Authors:

Hong Juan Wu, Jiao Guo

Keywords:

Allocation Table, Dynamic Statistics, Protect Worksheet, SUMPRODUCT, VBA

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Z. Li, H.Y. Liang H. Li and G.P. Lin: Course of VBA Fundamental Application and Case, National Defence of Industry Press, (2009).

Google Scholar

[2] Z.M. Li: Statistics and Inquary of The Test Sample Datas from Physical Health Standards of The National Students by The Use of EXCEL, Journal of Capital Normal University (NATURAL SCIENCE EDITION). Beijing, Vol. 32, No. 1, PP. 90-93, February (2011).

Google Scholar

[3] Chambers: Teaching Engineering Analysis Using VBA for Excel, Computers in Education Journal, Vol. 18, No. 2, PP. 71, (2008).

Google Scholar

[4] Information on http: /v. youku. com/v_show/id_XMjk1MDI4Njcy. html.

Google Scholar

[5] X.M. Li, X.P. Yang: VBA Program Design in Excel, Journal of Sichuan Normal University(Natural Science). Sichuan, Vol. 27, No. 4, PP. 423, July (2004).

Google Scholar

[6] J. Chen: Application of Excel Function Extension by VBA, Modern Computer. Guangdong, No. 2, PP. 147-148, February (2009).

Google Scholar