 |
Web Hosting by Netfirms | Free Domain Names by Netfirms |
|
|
|
OzGrid Excel Addins Collection
Awarsds : 4 Stars
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.
Do On Time. This feature allows you to run a macro (recorded or
written) at a set time, display a personal message or reminder at a specified time or even
open a nominated Workbook at a set time.
Formula Reference Changer. This handy little Excel Add-in can very
quickly change thousands of formula references to your specified type. It has 3 levels of
areas to effect:
Selection only;
Entire Active Sheet;
Entire Workbook.
Sheet Index Creator. Have a workbook with a large number of Worksheets?
Find it hard and too time consuming navigating through all the sheets? This option allows
you to easily create an Index Sheet that has click-able links to all sheets. It also has
the option of placing a "Back to Index" link on all the sheets.
Duplication Manager. This very handy add-in will make your management
of lists a breeze. It is designed to assist you when you have duplicates in 1 or more
lists. You can create a list of uniques, hide all duplicates, create a summary report,
color code all duplicates, up to 3 levels and even prevent users from adding duplicates to
a list or table! There is also the option to compare 2 lists for matching entries.
File Size Reducer. It's a common problem with Excel Workbooks to
increase in size unrealistically, even after you think you have cleared out all the data.
The File Size Reducer has become extremely popular as it can reduce unrealistic file size
by 50% or more! All you need to do is install the add-in and click the button.