OzGrid Excel Plus Add-in

Eight Excel addins in one.

Description of OzGrid Excel Plus Add-in:

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.

Do On Time. This feature allows you to run a macro (recorded or written) at a set time, display a personal message or reminder 29.95

See Also: All products from OzGrid Business Applications

1. Model Assistant Suite
   Model Assistant Suite is the most useful collection of add-ins for people who use Excel as a decision making tool: to build, understand, communicate or audit more robust models, quicker.
2. Daily Multi Task Scheduler
   The Multiple Daily Tasks Excel spreadsheet assigns multiple tasks, shifts, or clients to your employees or multiple employees to your tasks, shifts, clients, or vehicles for one week.
3. OM-FORECASTING
   Excel Spreadsheet Templates for Forecasting.
4. ZRandom for Excel 1.2
   ZRandom implements high quality random number generation for Microsoft Excel using the Merssenne Twister algorithm : * Use higher quality pseudo-random numbers than the Excel RAND() and VBA Rnd() functions.
5. Upgrade Extended Accounting Medium to FULL
   MS Excel add-in 97/2000/XP. Data Entry Bug Tracker. Tracks entry bugs during an entry and later. Pivot Table Wizard. Quick Subtotals Adding to the spredsheet. Ararm-Clock.
6. DigDB Excel Add-in Toolkit for Excel97 6.3
   Use this Excel add-in toolkit to empower yourself. It removes duplicates - you can dedupe by matching one table against another, or filter, count, purge duplicates by key fields. You can do Access-like query, aggregation, and join.
7. OM-MULTIMON
   Excel Spreadsheet Template for Ratio-to-moving-average seasonal adjustment
8. DownloaderXL Package 5.8.6
   Free download real and historical stock quotes from USA, Europe, and Canada into Excel spreadsheets. Mutual funds, corporate bonds, Major USA Market Indices, Major World Indices are downloadable into Microsoft Excel spreadsheets.
9. PDAGraphiX2 2.0
   PDAGraphiX2 By PDA Advanced Ltda Pocket PC 2003 Supported!! Don't be frustrated because you can't graph on your Pocket Excel. PDAGraphiX2 makes it possible.
10. Investment & Business Valuation 1.0
    The Investment Valuation model by Excel Business Tools
11. Loki Diary
    Keeping a Diary of Journal has never been easier...
12. SN Person Book
    The phone, e-mail, web site book include plan maker and reminder.
13. IDautomation EZ Font Package
    An easy to install and use self-checking TrueType barcode font package.
14. TarcisSansUT Light PC
    TarcisSansUT Light PC
15. OM-TRENDSMOOTH
    Excel Template for smoothing linear, exponential, and damped trends.
16. TarcisSansUT HeavyItalic PC
    TarcisSansUT HeavyItalic PC
17. Data Loader for Microsoft Excel
    The Data Loader is a menu driven add-in for Microsoft Excel that makes loading data from one worksheet to another fast and easy.
18. AIRLOG PLUS
    The powerful, flexible and friendly logbook for the professional and recreational pilot.
19. AnalyzerXL 5.9.5
    Technical Analysis in Microsoft Excel. Free historical and real quotes into speadsheets.
20. True-Knowledge
    Provides customized knowledge database designer with powerful search engine, custom views, email support, replication, and HTMLHelp support.