Opportunity: Probable alternative that can come in handy in various situatinos In computing parlance in spreadsheets,dbms functions scenario : Rouding of numerical figures , for ex : 45.5,55.5,99.5 given the scope ...for instance taking oracle into consideration , the functions abs,ceil,floor return different values for the same function. Requirement: many a times while rounding off in arithematical and accounting terms ...for instance using abs ...may either require rounding of the above values to eighter "largest integer value that is equal to or less than a number" or "smallest integer value that is greater than or equal to a number" ...depending on the situation or policy. Solution : given the requirement ...passing a flag to the ABS function to emulate one of the above ...proves or provides a handy solution terms & conditions: for more details refer to as detailed in http://uk.geocities.com/ravivenkatus/projects.pdf ----------------------------------------------------------------------------------------------- Terms & conditions: for more details refer to as detailed in http://uk.geocities.com/ravivenkatus/projects.pdf Opportunity: Integrate spread sheets(msoffice/openoffice/group ware) or DSS with RDBMS ....to leverage DSS on the data lying in the underlying schema of the Database scenario : Dataware housing requires providing analytical capacities to data from various data sources ...of which RDBMS or DBMS happens to be one of the source's. Problem Statement: It should be possible to import the data and its underlying relation ships from database into to various worksheets in a workbook viz. each or every entity(table or view) in the database to corressponding worksheet in the DSS and translating relationships on data present in various worksheets in the work book ....Thus giving the necessary capability to leverage the DSS capabilities on the data Solution : Given the requirement ...availability of various datamining solutions that undermine the E-R present in a database schema's .... It should be possible to write a provider or solution (ex : Ole db) that translates data in the Database into data in a DSS , to make or let the above a possibility. It would be a notable or worthy option ...to denote data or define schema while developing ERP solutions and other enterprise database solutions at the schema level , so that at later stage's this would or can be utilized for DATAMING or BI or DWH purposes. Similarly it would be good option on the above lines to denot or classify or publish table's as part of dictionary or similar such catalogs ...where data within the entities (tables or objects) are basis for interpretation ...where in tools , utilities, schema or catalogues can extract and interpret such data ...kind a XML at the relational level. Note: The above problem statement having been encountered in various scenarios and detailed in various 'Proof of concepts' as mentioned in 'http://uk.geocities.com/ravivenkatus/projects.pdf' ....apply appropriate 'use-case' modeling , rationalization to arrive at a workable and feasible solutions both commercially and techinically viable. -----------------------------------------------------------------------------------------------