VBA在办公中的编程应用

职场中办公人员经常碰到使用Office套装软件难以处理的工作,通过VBA编程在不同的岗位上,根据需求编写出有用的代码生成各种功能模块,可以帮助他们解决这样的困难,更有助于工作自动化,提高工作效率.Office取得巨大成功的一个重要原因就是VBA,使用VBA可以完成很多事情.     

浅谈VBA在PowerPoint中的交互应用

很多老师面对VBA编程,都会觉得无从下手.本文就和大家一起来探讨一下PowerPoint中的VBA如何在Office应用程序中建立自动化的解决问题的方法,如何使PowerPoint课件具有一定的智能交互功能,提高PowerPoint课件的使用灵活性问题.     

用VBA开发基于Excel的数据统计

Excel是广泛应用的电子数据表格程序,如在Excel中使用VBA（Visual Basic for Application）编程将有很多机会开发出有价值的应用程序,本文介绍一种基于Excel的VBA编程方法,来扩展Excel的功能,以实现学生评优和奖学金评选的数据统计的计算功能。     

基于ExcelVBA的数据处理软件开发

Excel VBA编程通过对Excel自身功能的集成和扩展可以较为快捷高效地形成一个完整的数据处理软件,用于解决重复或复杂数据的处理。该文以财务预算数据处理软件开发为实例,简要论述了Excel VBA开发数据处理软件的设计思路、技术要点和方法,同时还列举了一些通用代码供大家参考和使用。     

基于ExcelVBA的数据处理软件开发

Excel VBA编程通过对Excel自身功能的集成和扩展可以较为快捷高效地形成一个完整的数据处理软件,用于解决重复或复杂数据的处理。该文以财务预算数据处理软件开发为实例,简要论述了Excel VBA开发数据处理软件的设计思路、技术要点和方法,同时还列举了一些通用代码供大家参考和使用。     

用VBA开发基于Excel的数据统计

Excel是广泛应用的电子数据表格程序,如在Excel中使用VBA(Visual Basic for Application)编程将有很多机会开发出有价值的应用程序,本文介绍一种基于Excel的VBA编程方法,来扩展Excel的功能,以实现学生评优和奖学金评选的数据统计的计算功能.     

借用录制宏的操作来帮助您学用VBA编程

OFFICE VBA（Visual Basic for Applications）在日常办公中可以帮助我们简化很多的操作，实现许多用菜单命令无法实现的功能。受到了电脑用户的喜爱。不少朋友都想熟练地掌握和使用VBA语言，但苦于身边没有高手指点，往往无功而返。实际上，OFFICE本身就是我们学习VBA编程的好老师，它就是“宏”代码。     

基于VBA的课程成绩单登记系统

本文介绍了利用Excel强大的宏功能实现课程成绩的自动计算与分析，利用Excel内嵌的VBA（Visual Basic for Applications）言实现对Excel功能的第二次开发，为广大Excel用户群更深层次地使用Excel实现办公自动化，提高工作效率提供有益的参考。     

宏在Excel2010中的应用

Excel电子表格软件是应用最广泛的软件之一,它的数据处理、图表功能及各种函数和工具深受广大用户的喜爱,通过使用Excel宏,不仅能使Excel的很多操作自动化,更能通过VBA编程对Excel进行二次开发,实现很多高级功能,提高工作效率。     

VBA技术在Excel表格数据统计中的应用

VBA是一种基于Basic的编程语言,在文本信息处理、数据统计分析等领域得到广泛应用,尤其是在Excel表格办公时,VBA作为一种宏编程语言,其可以嵌入到Excel表格数据处理过程中,将传统的Excel函数单个处理向批处理过渡,这样就可以改进Excel批处理的效率.详细地介绍了VBA技术及其应用实例,为VBA在Excel表格中应用提供参考.     

电子皮带秤的选型、安装与维护

电子皮带秤应用越来越广泛,但电子皮带秤的使用环境复杂,影响因素多,如何选好电子皮带秤及如何安装,并在使用中维护好它,确保其计量准确、可靠。当前,仍值得探讨。     

A Metrical Model of Prosody for Multilingual TTS

The model of prosody used in the Aculab TTS system is unusual in several respects. Firstly, it is based firmly on current metrical theories of prosody. Secondly, it is entirely knowledge-based: there are no stochastic components in the model. Thirdly, it makes use of a quasi-random element to avoid the predictability of conventional synthetic prosody. Fourthly, it is specifically designed for multilingual use: it currently handles several Germanic and Romance languages.     

机动能力评估模型控件的设计与实现

用控件技术构建军事模拟系统可以随时进行组件的拆卸、更换、升级，实现新功能方便，是军事模拟系统发展的趋势。机动能力评估模型的建立采用了面向对象技术和控件技术，经历了OOA、OOD、OOP三个阶段完成，具有维护更新方便、用户操作方便、网络性能好的特点。     

Personalizing learning programs with X-Learn, an XML-based, “user-device” adaptive multi-agent system

In this paper we present X-Learn, an XML-based, multi-agent system for supporting “user-device” adaptive e-learning, i.e. e-learning activities which take into account the profile, past behaviour, preferences and needs of users, as well as the characteristics of the devices they use for these activities. X-Learn is characterized by the following features: (i) it is highly subjective, since it handles quite a rich and detailed user profile that plays a key role during the learning activities; (ii) it is dynamic and flexible, i.e. it is capable of reacting to variations in user exigencies and objectives; (iii) it is device-adaptive, since it decides the learning objects to present to the user on the basis of the device he is currently using; (iv) it is generic, i.e. it is capable of operating in a large variety of learning contexts; (v) it is XML based, since it exploits many facilities of XML technology for handling and exchanging information related to e-learning activities. The paper also reports various experimental results, as well as a comparison between X-Learn and other related e-learning management systems already presented in the literature.     

数据库加脱密引擎的设计与实现

数据库加脱密引擎是数据库加密系统的核心模块,该文讨论了如何设计数据库加脱密引擎,给出了具体的设计模型并说明了各个功能模块的功能和作用,提出了实现时要解决的几个关键问题并给出了解决办法,在此基础上,给出了实现数据库加脱密引擎的主要方法。     

基于遗传算法的模糊熵图像分割算法

图像阈值分割技术在图像分析和图像识别中具有重要的意义。图像分割的鲁棒性和自适应性一直是该技术的难点 ,该文运用模糊熵阈值分割技术 ,算法鲁棒性好 ,自适应性强 ,能够针对不同的图像 ,给出最佳的分割效果 ,在最优阈值的搜索中 ,引进了具有鲁棒性和自适应性的遗传算法 ,大大提高了算法效率 ,实验表明该方法的有效性     

2类故障系统的检测策略研究

研究具有2类故障的可修系统的一个模型,假定系统工作时可能直接发生第1类故障, 也可能经过异常后发生第2类故障.系统故障时不需检测,系统工作时必须经过检测才能知道 它是正常还是异常,并且检测时间是一个随机变量.系统开始工作后,每隔一段时间对它检测 一次,直到系统故障或者检测结果是系统处于异常状态为止.利用密度演化方法,求出了系统的 可靠性指标和最优检测策略.     

Is neglected heterogeneity really an issue in binary and fractional regression models? A simulation exercise for logit, probit and loglog models

Theoretical and simulation analysis is performed to examine whether unobserved heterogeneity independent of the included regressors is really an issue in logit, probit and loglog models with both binary and fractional data. It is found that unobserved heterogeneity has the following effects. First, it produces an attenuation bias in the estimation of regression coefficients. Second, although it is innocuous for logit estimation of average sample partial effects, it may generate biased estimation of those effects in the probit and loglog models. Third, it has much more deleterious effects on the estimation of population partial effects. Fourth, it is only for logit models that it does not substantially affect the prediction of outcomes. Fifth, it is innocuous for the size of Wald tests for the significance of observed regressors but, in small samples, it substantially reduces their power.     

基于改进的模拟退火算法及其在火炮控制系统中的应用

针对现有火炮控制系统与模拟退火算法优化存在的问题,提出了一种改进的模拟退火算法用于火炮控制系统PID参数寻优的方案,即基于变尺度法的模拟退火算法。该算法采用了全局优化和局部优化相结合的思想,能显著提高算法的执行效率,收敛性较好,而且不易陷入局部最优解。给出了具体实现过程和优化实例,并将该算法应用到火炮控制系统中,仿真实验表明,该算法是一种有效的全局优化算法。     

What software reality is really about

Software reality is more about people working together than it is about defined processes; it's more about science than it is about computer science; it's more about understanding than it is about documentation; it's more about inquiry than it is about metrics; it's more about skill than it is about methods; it's more about becoming better than it is about being good; and it's more about being good enough than it is about being right or wrong