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的多组分化学处理剂化学活化硅胶后负载催化剂是该领域发展的趋势。     

Ionic liquids as electrolytes

Salts having a low melting point are liquid at room temperature, or even below, and form a new class of liquids usually called room temperature ionic liquids (RTIL). Information about RTILs can be found in the literature with such key words as: room temperature molten salt, low-temperature molten salt, ambient-temperature molten salt, liquid organic salt or simply ionic liquid. Their physicochemical properties are the same as high temperature ionic liquids, but the practical aspects of their maintenance or handling are different enough to merit a distinction. The class of ionic liquids, based on tetraalkylammonium cation and chloroaluminate anion, has been extensively studied since late 1970s of the XX century, following the works of Osteryoung. Systematic research on the application of chloroaluminate ionic liquids as solvents was performed in 1980s. However, ionic liquids based on aluminium halides are moisture sensitive. During the last decade an increasing number of new ionic liquids have been prepared and used as solvents. The general aim of this paper was to review the physical and chemical properties of RTILs from the point of view of their possible application as electrolytes in electrochemical processes and devices. The following points are discussed: melting and freezing, conductivity, viscosity, temperature dependence of conductivity, transport and transference numbers, electrochemical stability, possible application in aluminium electroplating, lithium batteries and in electrochemical capacitors.     

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方法建立的径流预测模型有较好的预测和泛化能力,是一种行之有效的中长期径流预测方法。     

The role of clay network on macromolecular chain mobility and relaxation in isotactic polypropylene/organoclay nanocomposites

It is well known that a so-called “three-dimensional filler network structure” will be constructed in the polymer/layered silicate nanocomposites when the content of layered clay reaches a threshold value, at which the silicate sheets are incapable of freely rotating, due to physical jamming and connecting of the nanodispersed layered silicate. In this article, the effect of such clay network on the mobility and relaxation of macromolecular chains in isotactic polypropylene(iPP)/organoclay nanocomposites was investigated in detail with a combination of DMTA, DSC, TGA, TEM, rheometry and melt flow index measurements. The main aim is to establish a relationship between the mesoscopic filler network structure and the macroscopic properties of the polymer nanocomposites, particularly to explore the role of the clay network on the mobility and relaxation of macromolecular chains. It was found that the nanodispersed clay tactoids and layers play less important or dominant roles on the mobility of iPP chains depending on the formation of percolating filler network. The turning point of macroscopic properties appeared at 1 wt% organoclay content. Before this point, the effect of organoclay can be negligible, and the increase of chain mobility was ascribed to the decrease of molecular weight of polymer chains, as commonly occurs during dynamic melt processing; after this point, however, a reduced mobility of chains and a retarded chain relaxation were observed and attributed to the formation of a mesoscopic filler network. The essential features of such a mesoscopic organoclay network were estimated and discussed on the basis of stress relaxation and structural reversion measurements. A schematic model was proposed to describe the different relaxation and motion behaviors of macromolecular chains in the unfilled polymer and the filled hybrids with partial and percolated organoclay networks, respectively.     

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.     

Context-aware adaptive IP mobility anchoring

The novel distributed mobility management trend is a promising direction to cope with the increasing mobile data traffic and flatten network architectures. Most of the novel mobility approaches distribute the mobility anchors through the access level, as opposed to the centralized mobility anchoring model. Other recent approaches argue that mobility anchors closer to the content servers may be the solution to optimize the mobility performance. However, none of the mobility anchoring models is ideal for all scenarios, since it depends on the user, the session and the network. Hence, we propose an IP mobility approach driven by the context of the user, sessions and the network, where the mobility anchors for IP address allocation and for routing/forwarding are distributed through the network nodes, while the mobility context is managed by the mobile devices. Although each session is properly anchored in the establishment phase, the routing/forwarding is adapted over time, according to the user, the session and the network context: the proposed approach is able to signal different mobility anchors to optimize the routing path to new and ongoing sessions of the user. The outcome of the evaluation shows that the proposed approach overall reduces the data cost, the data delay, the tunneled packets and the tunnel length, when compared with other anchoring models.     

Creature grammar for creative modeling of 3D monsters

Monsters and strange creatures are frequently demanded in 3D games and movies. Modeling such kind of objects calls for creativity and imagination. Especially in a scenario where a large number of monsters with various shapes and styles are required, the designing and modeling process becomes even more challenging. We present a system to assist artists in the creative design of a large collection of various 3D monsters. Starting with a small set of shapes manually selected from different categories, our system iteratively generates sets of monster models serving as the artist’s reference and inspiration. The key component of our system is a so-called creature grammar, which is a shape grammar tailored for the generation of 3D monsters. Creature grammar governs the evolution from creatures with regular structures gradually into monsters with more and more abnormal structures through evolving the arrangement and number of shape parts, while preserving the semantics prescribed as prior knowledge. Experiments show that even starting with a small set of shapes from a few categories of common creatures (e.g., humanoids, bird-like creatures and quadrupeds), our system can produce a large set of unexpected monsters with both shape diversity and visual plausibility, thus providing great support for the user’s creative design.