Toward Reverse Engineering of VBA Based Excel Spreadsheet Applications

Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language. These applications are often developed by practitioners that do not follow any software engineering practice and do not produce any design documentation. Thus, spreadsheet applications may be very difficult to be maintained or restructured. In this position paper we present in a nutshell two reverse engineering techniques and a tool that we are currently realizing for the abstraction of conceptual data models and business logic models.Comment: In Proceedings of the 2nd Workshop on Software Engineering Methods in Spreadsheets (http://spreadsheetlab.org/sems15/

Interaction of nanoparticles with biological systems

Nanoparticles (NPs) are literally and figuratively infiltrating all fields of biological research. They are sophisticated tools that can be customized, either by smart engineering or by the attachment of specific ligands, to match the requirements of a particular task. Through their inherent and functionalized properties they are the basis for new developments while enhancing the efficiency of already existing techniques or rendering methods to be more specific. They provide new approaches for therapeutic applications and brand new platforms for diagnostic processes. In this review we provide an insight into the practical applications of NPs, emphasizing their use in biosensing, bioimaging, biomolecule delivery systems and enzyme immobilization. Since the interest in the interactions of NPs and biological systems is fairly new, we also elaborate on the drawbacks of their practical applications by reporting their potential toxicity in in vitro and in vivo systems

Quantitative imaging of the complexity in liquid bubbles’ evolution reveals the dynamics of film retraction

Thin liquid films: Seeing bubbles in a better light A procedure for imaging the complex fluid dynamics in bubbles could greatly assist efforts to understand and exploit thin liquid films in applications ranging through medicine, industrial chemistry and engineering. Thin liquid films are ubiquitous in nature, found in such varied systems as soap bubbles, biological membranes, detergents, oils, insulation, foods and geological magma. Researchers in Italy led by Biagio Mandracchia at the Institute of Applied Science and Intelligent Systems in Naples, devised a novel holographic phase imaging technique to watch bubbles as they form, develop, burst and retract. The researchers built customized apparatus to create and manipulate the bubbles. The unprecedented level of detail being revealed offers deeper understanding of the physics underlying thin film behavior. Insights into the complex fluid dynamics within bubbles could advance thin film technology for many applications

Recombinant Collagenlike Proteins

A group of collagenlike recombinant proteins containing high densities of biologically active sites has been invented. The method used to express these proteins is similar to a method of expressing recombinant procollagens and collagens described in U. S. Patent 5,593,859, "Synthesis of human procollagens and collagens in recombinant DNA systems." Customized collagenous proteins are needed for biomedical applications. In particular, fibrillar collagens are attractive for production of matrices needed for tissue engineering and drug delivery. Prior to this invention, there was no way of producing customized collagenous proteins for these and other applications. Heretofore, collagenous proteins have been produced by use of such biological systems as yeasts, bacteria, and transgenic animals and plants. These products are normal collagens that can also be extracted from such sources as tendons, bones, and hides. These products cannot be made to consist only of biologically active, specific amino acid sequences that may be needed for specific applications. Prior to this invention, it had been established that fibrillar collagens consist of domains that are responsible for such processes as interaction with cells, binding of growth factors, and interaction with a number of structural proteins present in the extracellular matrix. A normal collagen consists of a sequence of domains that can be represented by a corresponding sequence of labels, e.g., D1D2D3D4. A collagenlike protein of the present invention contains regions of collagen II that contain multiples of a single domain (e.g., D1D1D1D1 or D4D4D4D4) chosen for its specific biological activity. By virtue of the multiplicity of the chosen domain, the density of sites having that specific biological activity is greater than it is in a normal collagen. A collagenlike protein according to this invention can thus be made to have properties that are necessary for tissue engineering

Cloud-based manufacturing-as-a-service environment for customized products

This paper describes the paradigm of cloud-based services which are used to envisage a new generation of configurable manufacturing systems. Unlike previous approaches to mass customization (that simply reprogram individual machines to produce specific shapes) the system reported here is intended to enable the customized production of technologically complex products by dynamically configuring a manufacturing supply chain. In order to realize such a system, the resources (i.e. production capabilities) have to be designed to support collaboration throughout the whole production network, including their adaption to customer-specific production. The flexible service composition as well as the appropriate IT services required for its realization show many analogies with common cloud computing approaches. For this reason, this paper describes the motivation and challenges that are related to cloud-based manufacturing and illustrates emerging technologies supporting this vision byestablishing an appropriate Manufacturing-as-a-Service environment based on manufacturing service descriptions

An eCommerce platform for customized page design and content delivery

Thesis (M. Eng. and S.B.)--Massachusetts Institute of Technology, Dept. of Electrical Engineering and Computer Science, 2006.Includes bibliographical references (leaf 52).As eCommerce becomes more prevalent, good site design that can cater to users with different backgrounds and experience becomes increasingly important. While many web based applications provide customized content, these systems do not adapt and provide a customized user experience as one navigates the site. Our research investigates customizing web applications to fit individual decision styles by morphing user experience based on revealed clicks, search history, and the navigation path through the site. By using a Bayesian update algorithm to update our assessment of a user's preferred interface, our application creates a customized user experience that is best suited for their personality and learning style.by Aman Narang.M.Eng.and S.B

Operation of a Controllable Force-sensing Industrial Pneumatic Parallel Gripper System

As part of the advanced programmable logic controllers (PLC) course at Michigan Tech, this class project was performed on a mechatronics system gifted by Donald Engineering, a Michigan-based supplier of industrial automation systems and components. This paper explores the functionality and application of a force-programmable and sensing pneumatic parallel gripper system. Force sensing is a critical part of many systems in modern automation systems. Applications such as prosthetics, robotic surgery, or basic manufacturing systems may rely on the ability to properly read and control forces applied to an object. This work evaluates the basic operation of the pneumatic force-sensing gripper system, through a human machine interface (HMI), and presents two demonstrations using programmable logic controllers to open the door for future customized developments. Different gripper force-time and pressure-time responses are presented to demonstrate the control and visualization of the grippers force

Computer-Aided Conceptual Design Through TRIZ-based Manipulation of Topological Optimizations

Organised by: Cranfield UniversityIn a recent project the authors proposed the adoption of Optimization Systems [1] as a bridging element between Computer-Aided Innovation (CAI) and PLM to identify geometrical contradictions [2], a particular case of the TRIZ physical contradiction [3]. A further development of the research has revealed that the solutions obtained from several topological optimizations can be considered as elementary customized modeling features for a specific design task. The topology overcoming the arising geometrical contradiction can be obtained through a manipulation of the density distributions constituting the conflicting pair. Already two strategies of density combination have been identified as capable to solve geometrical contradictions.Mori Seiki – The Machine Tool Compan