Modelling with Spreadsheets - Revision history

Jpye at 02:13, 28 September 2014

2014-09-28T02:13:47Z

← Older revision		Revision as of 02:13, 28 September 2014
Line 12:		Line 12:
	* it is hard to build modular structures		* it is hard to build modular structures
	* it is hard to examine the nature of convergence problems in the Solver component (particular to Excel)		* it is hard to examine the nature of convergence problems in the Solver component (particular to Excel)
	* it is hard to build automated testing into a spreadsheet<~~sup id="_ref-0" class="reference"~~>~~<a href=~~"~~#_note-0~~" ~~title="">[1]</a>~~</~~sup~~>		* it is hard to build automated testing into a spreadsheet<ref>L Pryor, 2008. "When, why and how to test spreadsheets", {{arxiv\|0807.3187}}</ref>

	See also the article ~~"Spreadsheets Considered Harmful" at~~ [http://advosys.ca/viewpoints/2006/09/spreadsheet-risks/]		See also the article [http://advosys.ca/viewpoints/2006/09/spreadsheet-risks/ Spreadsheets Considered Harmful]

	See also [[Spreadsheet interface]] for some thoughts about how the benefits of spreadsheet-style programming could be merged with something like ASCEND.		See also [[Spreadsheet interface]] for some thoughts about how the benefits of spreadsheet-style programming could be merged with something like ASCEND.

	== References ==		== References ==
			<references/>

Jpye at 06:35, 24 May 2010

2010-05-24T06:35:46Z

← Older revision		Revision as of 06:35, 24 May 2010
Line 1:		Line 1:
	~~<div class="notice metadata" id="~~stub~~">''This article is a '''stub'''. You can help out by <span class="plainlinks">[http://ascendwiki.cheme.cmu.edu/index.php?title=Modelling_with_Spreadsheets&action=edit expanding it]</span>. ''</div>~~		{{missing}}
			{{stub}}

	Spreadsheets are an excellent tool for many quick-and-easy engineering calculations and even quite a lot of more complex calculations.		Spreadsheets are an excellent tool for many quick-and-easy engineering calculations and even quite a lot of more complex calculations.


	There are arguments against the use of spreadsheets though:		There are arguments against the use of spreadsheets though:


	* they don't support [[units of measurement]]!		* they don't support [[units of measurement]]!
Line 18:		Line 17:

	See also [[Spreadsheet interface]] for some thoughts about how the benefits of spreadsheet-style programming could be merged with something like ASCEND.		See also [[Spreadsheet interface]] for some thoughts about how the benefits of spreadsheet-style programming could be merged with something like ASCEND.


	== References ==		== References ==



	~~[[Category:Stubs]]~~

UploadBot: Restored page from Google Cache, uploaded by John Pye

2010-05-13T13:43:50Z

Restored page from Google Cache, uploaded by John Pye

New page

<div class="notice metadata" id="stub">''This article is a '''stub'''. You can help out by <span class="plainlinks">[http://ascendwiki.cheme.cmu.edu/index.php?title=Modelling_with_Spreadsheets&action=edit expanding it]</span>. ''</div>

Spreadsheets are an excellent tool for many quick-and-easy engineering calculations and even quite a lot of more complex calculations.

There are arguments against the use of spreadsheets though:

* they don't support [[units of measurement]]!
* you can't check your '''model''' 'at a view' because formulae are hidden and often written in terms of cryptic cell references such as 'H18' and 'AB23'
* they are saved in a binary format that makes reviewing changes difficult
* it is hard to reuse one small bit of an old spreadsheet that you previously made (without copying it or modifying it)
* it is hard to build modular structures
* it is hard to examine the nature of convergence problems in the Solver component (particular to Excel)
* it is hard to build automated testing into a spreadsheet<sup id="_ref-0" class="reference"><a href="#_note-0" title="">[1]</a></sup>

See also the article "Spreadsheets Considered Harmful" at [http://advosys.ca/viewpoints/2006/09/spreadsheet-risks/]

See also [[Spreadsheet interface]] for some thoughts about how the benefits of spreadsheet-style programming could be merged with something like ASCEND.

== References ==

[[Category:Stubs]]