Scaling a Dataflow Testing Methodology to the MultiparadigmWorld of Commercial Spreadsheets

Spreadsheets are widely used but often contain faults. Thus, in prior work we presented a data-flow testing methodology for use with spreadsheets, which studies have shown can be used cost-effectively by end-user programmers. To date, however, the methodology has been investigated across a limited set of spreadsheet language features. Commercial spreadsheet environments are multiparadigm languages, utilizing features not accommodated by our prior approaches. In addition, most spreadsheets contain large numbers of replicated formulas that severely limit the efficiency of data-flow testing approaches. We show how to handle these two issues with a new data-flow adequacy criterion and automated detection of areas of replicated formulas, and report results of a controlled experiment investigating the feasibility of our approach.

A METHODOLOGY TO EVALUATE OBSOLETE INVENTORY IN HEALTH CARE

Many organizations are currently facing inventory management problems such as distributing inventory on-time and maintain the correct inventory levels to satisfy the customer or end users. Organizations understand the need for maintaining the accurate inventory levels but sometimes fall short leading a wide performance gap in maintaining inventory accurately. The inventory inaccuracy can consume much of the investment on purchasing inventory and many times leads to excessive inventory. The research objective of thesis is to provide a decision making criteria to the management for closing or maintaining the warehouse based on basic purchasing and holding cost information. The specific objectives provide information regarding the impact of inventory carrying cost, obsolete inventory, inventory turns. The methodology section explains about the carrying cost ratio that would help inventory managers to adopt best practices to avoid obsolete inventory and also reduce excessive inventory levels. The research model was helpful in providing a decision making criteria based on the performance metric developed. This research model and performance metric had been validated by analysis of warehouse data and results indicated a shift from two-echelon inventory supply chain to a one-echelon or Just In Time (JIT) based inventory supply chain. The recommendations from the case study were used by a health care organization to reorganize the supply chain resulting in the reduction of excessive inventory.

Locus Amoenus vs. Locus Terribilis: The Spatial Dynamics of the Pastoral and the Urban in La Ceppède’s Théorèmes

The opening sonnets of Jean de La Ceppède’s Théorèmes (1613, 1622) present an urban vs. rural conflict that mirrors the dialectic between sin and salvation running throughout the work. La Ceppède’s focus for this struggle becomes the stark contrast between Jerusalem and the garden at the Mount of Olives. Jerusalem, as the place where Christ is persecuted and eventually tried, represents a Babylon-like enclave of transgression, while the garden is portrayed as a site of purity and tranquil reflection. From a literary standpoint, La Ceppède’s emphasis on the clash between dystopian and utopian settings comprises part of his adaptation of the pastoral, where this particular struggle becomes one of the genre’s principal motifs. In general, the contrast between Jerusalem and the Mount of Olives emerges as the point of departure for the poet’s figuration of nature, both human and physical. A human construct, the city of Jerusalem becomes a metaphor for human corruption. In view of humanity’s fall in paradise and the denaturation it symbolizes, the poet’s goal, on both intellectual and affective levels, is to place the reader/dévot in a position to lift her/himself from the depravity of human nature to the grace of divine nature.