Up Search Feedback

Tools and Tips

These are the Tools and Tips developed over time. These may be downloaded and used free of charge. However, please respect the copyright and acknowledge the source where appropriate. KnowTech Solutions Inc. does not take any responsibility for the product not performing although every effort has been made to thoroughly test the code.

Working Days

  • These set of Functions are written in Oracle PL/SQL. A Holiday Dates Table is expected in the form suggested. The Week End Days can be specified by adjusting the code appropriately. The current code assumes the Saturday-Sunday as the weekend. Canadian Holidays and Easter are calculated so a Table is not required.
Function         Purpose
TOTAL_DAYS Returns the Total Number of days between two dates
TOTAL_WORK_DAYS Returns the Total Work Days between two dates
TOTAL_WORK_HOURS Returns the Total Work Hours between two dates
TOTAL_NON_WORK_DAYS Returns the Total Number of Non Working Days between two dates
WEEKEND_DAYS Returns the Total Number of weekend days between two dates
HOLIDAY_DAYS Total Number of Holiday Days between two dates. All Canadian Holidays are accounted for without needing a Table.
BUSINESS_DAY The Next or Previous Business Day (Date) from a Date
FISCAL YEARS Fiscal Year (Current/Next) Start and End Dates from a Date
GET_EASTER Easter Sunday is calculated for a given Year

   Zip file size 5KB

Project Evaluation Spreadsheet

  • This is an Excel spreadsheet which helps to evaluate multiple projects based on the Cost and Return. Net Present Value should be used.

   Zip file size 7KB

Canadian Mortgage Calculator

  • This is an Excel spreadsheet which calculates the mortgage payments and balance outstanding based on the rules for Canadian mortgages. A 3 year payment listing is provided. The results are different than from the method used in general spreadsheet programs.

   Zip file size 5KB

Human Resource Generic Model

  • This is a Generic Business Model representing Human Resources in a generic manner. It provides the Functional Hierarchy Model and an Entity-Relation Model diagrams in a MS Word document.

   Zip file size 136KB

Business Party Generic Model

  • This is a Generic Business Model representation of a Business Party of interest to an Organization. The organization conducts its business with Business Parties such as Vendors, Customers, and Employees. It provides an Entity-Relation Model diagrams in a MS Word document.

   Zip file size 16KB

Location Dimension Model

  • This is a Location Dimension Model for Countries and Sub divisions within. The country list is based on the ISO-3166 model. At present there is no ISO standard for sub divisions. The zip file contains the Country List with ISO codes and Names, the data model and scripts for creating the views for the Location hierarchies.

   Zip file size 17KB

CASE Tool Evaluation Spreadsheet

  • This is an Excel spreadsheet which helps to evaluate CASE Tools based on the Cost and Points allocated to each of the features. The Evaluation Criteria are also described.

   Zip file size 19KB

 

Home ] Up ]

Send mail to webmaster with questions or comments about this web site.
Copyright 1998 KnowTech Solutions Inc.
Last modified: October 15, 2010