OzGrid excel Addins Collection

Excel add-ins Collection

Description of OzGrid excel Addins Collection:

Formula Report Generator:
Allows you to very easily create a report showing formulas within your Workbook that are either external references, internal references or both. You can also nominate which Worksheet(s) to use to base your report on.

Dynamic Range Namer:
This will allow you to very quickly and easily create any one of eight different types of dynamic ranges that will expand down rows or across columns. You can even nominate the column or row to use as the criteria. It can also expand automatically each day month or week.

Real Calendar:
This one will create a live calendar in an instant using real dates, so you can reference it if needed. The current day is always highlighted and updates automatically.

Sheet Creator and Sorter:
This option will create any number of pre-named worksheets which can be Financial Years (1901-2050), Weekdays (Monday-Sunday), Months (January-December), Years (1901-2050), Quarters (Quart1-Quart4), Days (Day1-Day1460) and Weeks (Week1-Week208). It also has an option that allows you to Sort (ascending or descending) any Worksheets in any Workbook.

A Random Number Generator:
This can produce up to 1000 non repeating random numbers that meet a criteria you specify.

Conditional Row Deletion:
This one will save many hours of repetitive work when you need to quickly and easily delete rows in a Worksheet that meet any criteria. There is an option that allows you to easily nominate any one of Excels six Error Types, or all of them. There is also a simple option that allows you to nominate the criteria.

Duplication Report:
Will produce a statistical table of your data. Including a Count of occurrences of each item, the total number of duplicates and a total of all entries. It will also produce a list of your data containing only unique entries. Better than a Pivot Table in a single click.

Excel Duplication Manager Add-in: This very handy add-in will make your management of lists a 54.95

See Also: All products from OzGrid Business Applications

1. OM-SIMPLE
   Excel Template for Simple exponential smoothing forecasting
2. ModernValue
   Includes 1 hour of value modeling or consulting help by Stuart Haxton! Investment commercial real estate total valuation, in Excel. Stand-alone or use with Argus exported data. The most educational, intuitive and visual valuation model.
3. Sales Leads 2008 for Excel 2007
   Our Sales Leads 2008 CD for Excel 2007 supplies over 10 million sales contacts and addresses sorted in to 51 States.
4. Quick Charts for Microsoft Excel
   Quick Charts for Excel is a menu driven Excel workbook that allows you to construct a graph of one row of data and then to easily change from one row of data to another using the Quick Charts tool bar.
5. Categorizing Data for Excel
   If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then Categorizing Data for Excel is the solution.
6. Spreadsheet Basic
   Spreadsheet Basic (spBasic) is a computer language designed to be used in Microsoft's Excel spreadsheets. It is modeled after the easy to use 'Basic' language which has been around for 40+ years and is familiar to many people.
7. Measurements to Excel
   The objective of this application is to facilitate the management of data generated by measurement applications of three-dimensional pieces such as Metrolog, PcDmis or Tutor...
8. Time Sheet Advanced
   This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily basis.
9. Filter Assistant for Microsoft Excel
   The Filter Assistant for Microsoft Excel makes filtering data easy! And, it eliminates many of the annoying features of Excel's data filter feature.
10. Lookup Assistant for Microsoft Excel
    The Lookup Assistant is designed to find matching data in one list and load in another.
11. OM-ACCEPTSA
    Excel Spreadsheet Templates for Quality Control, Acceptance sampling.
12. CharTTool
    Stock charting internet browser
13. Advanced Stock Bar
    An advanced Internet Explorer plugin that makes stock market research easy
14. Personal Finances+ for Windows 95 or higher
    Pfinance.EXE - A collection of 8 personal finance programs.
15. Stock Sector Monitor 2.1
    Monitor stock market quotes with this personal financial software.
16. TrigleUT Family PC
    TrigleUT Family PC
17. TorniaiSansOsfUT LightItalic PC
    TorniaiSansOsfUT LightItalic PC
18. Excel VBA Level 1 and Excel UserForms
    Excel VBA Training Level 1 and Excel UserForms and Controls
19. TrigleUT RegularItalic PC
    TrigleUT RegularItalic PC
20. Excel Duplication Manager Add-in
    Manage duplicate data in your Workbook with ease.