Abstract: The spreadsheet engine is exploited via a non-conventional mechanism to enable novel worksheet solver functions for computational calculus. The solver functions bypass inherent restrictions on built-in math and user defined functions by taking variable formulas as a new type of argument while retaining purity and recursion properties. The enabling mechanism permits integration of numerical algorithms into worksheet functions for solving virtually any computational problem that can be modelled by formulas and variables. Several examples are presented for computing integrals, derivatives, and systems of deferential-algebraic equations. Incorporation of the worksheet solver functions with the ubiquitous spreadsheet extend the utility of the latter as a powerful tool for computational mathematics.
Abstract: This study is used as a definition method to the value
and function in manufacturing sector. In concurrence of discussion
about present condition of modeling method, until now definition of
1D-CAE is ambiguity and not conceptual. Across all the physic fields,
those methods are defined with the formulation of differential
algebraic equation which only applied time derivation and simulation.
At the same time, we propose semi-acausal modeling concept and
differential algebraic equation method as a newly modeling method
which the efficiency has been verified through the comparison of
numerical analysis result between the semi-acausal modeling
calculation and FEM theory calculation.