Avoiding,finding and fixing spreadsheet errors – A survey of automated approaches for spreadsheet QA

Spreadsheet programs can be found everywhere in organizations and they are used for a variety of purposes, including financial calculations, planning, data aggregation and decision making tasks. A number of research surveys have however shown that such programs are particularly prone to errors. Some reasons for the error-proneness of spreadsheets are that spreadsheets are developed by end users and that standard software quality assurance processes are mostly not applied. Correspondingly, during the last two decades, researchers have proposed a number of techniques and automated tools aimed at supporting the end user in the development of error-free spreadsheets. In this paper, we provide a review of the research literature and develop a classification of automated spreadsheet quality assurance (QA) approaches, which range from spreadsheet visualization, static analysis and quality reports, over testing and support to model-based spreadsheet development. Based on this review, we outline possible opportunities for future work in the area of automated spreadsheet QA.     

以硅胶为载体的茂金属催化剂研究进展

综述了近年来硅胶载体经甲基铝氧烷(MAO)化学处理后负载茂金属催化剂的一些研究进展，指出硅胶的化学活化是茂金属催化剂负载化的关键，单组分化学处理剂处理硅胶载体不能完全满足人们对负载型茂金属催化剂烯烃聚合的需求，采用含MAO的多组分化学处理剂化学活化硅胶后负载催化剂是该领域发展的趋势。     

New type of tin support for hydroprocessing catalyst

TiN supported molybdenum sulfide catalysts showed much higher activity for cleavage of C-C bonds than oxide supported molybdenum sulfide catalysts, indicating the possibility of a new generation of supports for hydroprocessing catalysts.     

基于KPCA-PSO-SVM的径流预测研究

为提高径流预测模型的准确性与稳定性,对KPCA-PSO-SVM的径流预测方法进行了研究。在分析径流影响因素的基础上,利用核主成分分析(KPCA)法对径流影响因子进行非线性特征提取,获得主成分作为支持向量机(SVM)的输入变量,建立了径流预测SVM模型,其中模型参数通过粒子群算法(PSO)进行优化。模型建立后,以新疆伊犁河雅马渡站中长期径流预测为例进行分析。预测分析结果表明,在拟合和检验阶段模型的平均相对误差分别为0.77%和7.64%,与其他预测模型比较,基于KPCA-PSO-SVM方法建立的径流预测模型有较好的预测和泛化能力,是一种行之有效的中长期径流预测方法。     

Investigating Modern‐Day Talaria: Mobile Phones and the Mobility‐Impaired in Singapore

Revisiting the medical and social models of disability, this study adopted the integrated biopsychosocial approach to examine experiences of 25 mobility‐impaired respondents in Singapore with using mobile phones. We found that mobile phones provided respondents a greater degree of mobility, a sense of control, and opportunities to escape the stigma of disability, thus challenging the boundaries between the able‐bodied and the disabled. Mobile phone appropriation allowed the management of personal identities and social networks, leading to a sense of empowerment. However, mobile phone usage might act as a double‐edged sword for disabled people, creating mobile dependencies and a spatial narrowing of social connections. Theoretical and practical implications are discussed.     

电信运营商运营支撑流程化管理研究

全业务运营时代给运营商带来了运营模式的巨大变革,从原有的产品化营销理念,逐步走向了市场化营销理念,传统的运营支撑手段已不能满足市场运营的发展需求。基于对实际问题的研究,本文提出一种新型的运营支撑流程化管理模式。     

基于LS-SVM逆系统的无轴承异步电机解耦控制

无轴承异步电机具有非线性、多变量和强耦合的特点,要实现电机稳定悬浮和旋转运行,必须对其进行非线性动态解耦控制。为了克服逆系统方法精确建模难的局限性,采用基于最小二乘支持向量机(LS-SVM)α阶逆系统方法对无轴承异步电机进行动态解耦控制的研究。首先利用最小二乘支持向量机辨识出无轴承异步电机的逆模型,然后将它串联在原系统前,将无轴承异步电机解耦成四个独立的伪线性子系统-2个径向位移子系统、一个速度子系统和一个磁链子系统。为保证鲁棒性能,最后对解耦后的系统采用非线性内模控制策略。研究表明,LS-SVMα阶逆系统方法能够实现无轴承异步电机径向悬浮力和旋转力之间的动态解耦控制,控制系统具有良好的静态和动态性能。     

基于作战实验的工程装备保障评估方法研究

为满足工程装备保障评估的要求和实现工程装备保障更为细致的仿真分析,提出了利用作战实验理论对工程装备保障评估方法研究的建设构想.在描述工程装备保障评估分析一般过程的基础上,从工程装备实体、保障要求等角度出发构建工程装备保障评估分析仿真模型,实现了对象间的交互作用、关系和消息传递,反映了“保障”作战任务、实体、功能、交互、活动等内在逻辑.用面向服务的高层体系结构（HLA）方法为工程装备保障评估分析仿真系统提供集成方法,为进一步仿真系统的论证、设计、开发提供了坚实基础.     

支持向量机算法在MOOC 课程答疑系统中的研究

随着互联网技术和近期MOOC课程的发展,智能答疑系统也受到了更多的关注,应用它能够及时给学生提供学生疑惑的问题答案。智能答疑系统通常包括问句理解、信息检索、答案抽取和选择三个主要部分,且问句分类是问句理解的关键,因为它的准确性将直接影响到最后答案的准确性。以高校计算机基础课程为实际背景,在已有基于支持向量机算法基础上,对该方法进行了改进,并通过训练集和测试集进行了验证。从实验结果看,该方法在高校计算机基础智能答疑系统中有比较好的应用效果。     

基于支持向量回归的动力电池参数辨识

根据铅酸蓄电池在放电过程中内部电化学反应导致外部电特性变化的特点,提出一种基于支持向量机原理的电解液密度辨识模型。利用支持向量机理论非线性回归的特性,简化测量电解液密度的过程,在恶劣环境下检测动力电池的电解液密度更显其优越性。预测实验表明,采用改进的交叉验证预测模型具有泛化能力强、稳定性好的特点,并且在小样本的条件下能达到预期的辨识精度。