Computer Simulation Using Excel without Programming
Defining Simulation in its broadest aspects as embodying a certain model to represent the behavior of a system, whether that may be an economic or an engineering one, with which conducting experiments is attainable. Such a technique enables the management, when studying models currently used, to take appropriate measures and make fitting decisions that would further complement today’’s growth sustainability efforts, apart from cost decrease, as well as service delivery assurance.
Read more
An Excel/Visual Basic for Applications (VBA) Programming Primer
In the past, even mildly complicated engineering calculations have not mixed well with spreadsheets because of the very strong tendency to wind up with nearly-impossible-to-debug “spaghetti code”. While most students seem to enjoy using spreadsheets, instructors recognize that other than by finding the “correct” answer printed somewhere, it is next to impossible to grade assignments or to help the occasional student debug them. However, by using Visual Basic for Applications (VBA) in conjunction with the Excel spreadsheet, the user has the convenience of a spreadsheet for neatly-formatted input/output and for graphical display of results, i.e., to function as a graphical user interface (GUI).
Read more
Working with Data in ASP.NET 2.0 - Efficiently Paging Through Large Amounts of Data
As we discussed in the preceding tutorial, paging can be implemented in one of two ways:
- Default Paging – can be implemented by simply checking the Enable Paging option in the data Web control’’s smart tag? however, whenever viewing a page of data, the ObjectDataSource retrieves all of the records, even though only a subset of them are displayed in the page
- Custom Paging – improves the performance of default paging by retrieving only those records from the database that need to be displayed for the particular page of data requested by the user? however, custom paging involves a bit more effort to implement than default paging
Read more
ADO.NET DataEntities and WCF Feeding a Silverlight DataGrid
Key to virtually every business application is the ability to move data from a database to the User Interface. While there are many issues to discuss in great detail, this tutorial will take a “drop line” approach – the shortest possible path using the simplest technology to demonstrate one way of moving data from there to here. This is not the only way, far from it, but it is a very easy way and all the parts fit together very nicely.
Read more
Facade Design Pattern
definition
Provide a unified interface to a set of interfaces in a subsystem. Façade defines a higher-level interface that makes the subsystem easier to use.
Read more