首先，在测试量表的设计中，引入了时间维度、精神分析人格结构维度，采
用了自陈问卷法。
其次，以数据驱动、Access 的最小化代码设计思想为指导，大量采用逻辑视
图实现数据处理功能，从而使展示窗体的 VBA 代码减少。其中，还使用 SQL 语
言对心理问卷量表的非均值评分、复杂分值计算进行了实现。
最后，采用 Office Web Components 实现测评结果的图形化展示，丰富了计
算机技术在问卷测量中的应用方案。
Firstly, we introduce the time dimension and spiritual dimension of personality
structure ,and use a self-report in the design of the test scale.
Secondly, guided by the thinking of data-driven and the minimizing code design of
Access ,we apply a large number of logical view to data processing to decrease the
VBA code of the display window. In which we also use the SQL language to achieve
the non-mean score and the calculation of complex scores of the psychological
questionnaire.
Finally, make use of Office Web Components to show the graphical evaluation
results,which riches the applications of computer technology in questionnaire
measurement. (2021-03-29, VBA, 1764KB, 下载0次)
论文统计软件。CCR模型是DEA模型中的一种，是数据包络模型中的一种。1978年，著名运筹学家、美国德克萨斯大学教授A.Charnes及W.W.Cooper和E.Rhodes发表了一篇重要论文得出。BCC模型是评价技术效率的一种模型。相对效率是说DEA模型中的DEA有效是相对有效，即相对其他同类的DMU单元而言有效，并不是真正的技术有效和规模有效。
Paper statistics software. CCR model is a kind of DEA model and a kind of data envelope model. In 1978, a famous operational research scientist, professor A. Charnes and W. W. Cooper and E. Rhodes of the University of Texas published an important paper. BCC model is a model for evaluating technical efficiency. Relative efficiency means that DEA efficiency in DEA model is relatively effective, that is to say, it is effective compared with other similar DMU units, but not true technology efficiency and scale efficiency. (2019-02-10, VBA, 1950KB, 下载5次)
通过VBA写宏，进行文件读取及数据处理，最后将运算结果写入到excel中
Write macros through VBA, file read and data processing, and finally write the result to excel. (2018-06-22, VBA, 232KB, 下载4次)
RSA是被研究得最广泛的公钥算法，从提出到现在已近二十年，经历了各种攻击的考验，逐渐为人们接受，普遍认为是目前最优秀的公钥方案之一。rsa算法加解密在vb中的运用，其中有加密解密的方法。
RSA is the most widely studied of the public key algorithm, from the nearly two decades now, we have tested a variety of attacks, people gradually accepted, widely considered the best of the current public key, one of the options. (2017-11-14, VBA, 8KB, 下载2次)
康奈尔大学开发的GWLF模型的贝叶斯算法校准及不确定性分析模块，基于excel VBA平台开发
Bayesian algorithm developed by Cornell University GWLF calibration models and uncertainty analysis module, based on excel VBA platform (2016-06-20, VBA, 4KB, 下载5次)
Fisher判别法是历史上最早提出的判别方法之一，其基本思想是将n类m维数据集尽可能地投影到一个方向（一条直线），使得类与类之间尽可能分开。
This package include the training, testing and a demo of Fisher LDA. The testing code also uates precision, recall, accuracy and F1-measure. (2015-10-11, VBA, 3KB, 下载1次)
LED 二次光学设计中的透镜设计，根据非成像光学原理，利用matlab计算生成二维点坐标，可导入3维建模软件
LED optical design, lens design, according to the non-imaging optics principle, the use of matlab calculation to generate two-dimensional coordinates can import 3-D modeling software, the production model. The code has been tested and successfully completed the calculation. We can refe (2015-05-24, VBA, 3KB, 下载14次)
利用VBA在word中批量添加书签(适用于往dot模板中输出内容)
Using VBA to batch add bookmarks in the word (dot template to apply to the output) (2013-09-04, VBA, 2KB, 下载15次)
三(二)维坐标快速输入+出CAD图,+CAD取三维坐标，简便易懂，方便阅读，无密码
Three (two)-dimensional coordinate input fast+ CAD drawings,+CAD take a three-dimensional coordinates, simple and easy to understand, easy to read, no password (2012-06-13, VBA, 31KB, 下载13次)
采用Excel表格编制，用VBA编写程序，实现马斯京根法中参数x的试算过程。
Excel spreadsheet prepared with VBA programming, and spreadsheet process parameter x in the Muskingum method. (2012-02-12, VBA, 12KB, 下载44次)
本宏代码非常适合家长或小学教师为孩子出口算练习题，可在 Excel 电子表格中生成 10 以内加减法，100 以内加减法或乘除法等，可任意设置页数（试题总数）。
通过更改红色文字的数字，可选择加、减、乘、除一种或其中几种试题。可设置参加运算的最大数字，得数最大数字，横向或纵向试题个数，显示的总页数。
本宏代码非常适合家长或小学教师为孩子出口算练习题，可在 Excel 电子表格中生成 10 以内加减法，100 以内加减法或乘除法等，可任意设置页数（试题总数）。
通过更改红色文字的数字，可选择加、减、乘、除一种或其中几种试题。可设置参加运算的最大数字，得数最大数字，横向或纵向试题个数，显示的总页数。 (2010-06-17, VBA, 2KB, 下载7次)
主要用来在硬件模拟条件下进行自动K怪和加血定点等，配套在按键游侠中运行。
Mainly used to simulate the hardware auto-K under the conditions of fixed and other strange and processing of blood, and the supporting key Ranger in the running. (2009-11-01, VBA, 1KB, 下载3次)
简单实用的VBA代码。主要用于计算一维河床冲淤变形，适合于推移质河床变形的计算。里面包含了详细的解释说明。
VBA code simple and practical. Mainly used to calculate the one-dimensional deformation of river bed erosion, river bed is suitable for the calculation of the deformation. Which contains a detailed explanation. (2009-08-19, VBA, 78KB, 下载8次)
俄罗斯方块，和平时玩的一样的，打开后里面有说明怎样的玩法
Russian box, and usually play the same, and opened there on what' s playing (2009-04-09, VBA, 48KB, 下载4次)