|
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 ] | 
