Quickly creates general purpose and business oriented calculated fields!

EZ-Calc for Microsoft Excel quickly creates general purpose and business oriented calculated fields!

EZ-Calc for Excel creates fields either too difficult or virtually impossible to create manually!

Here are some key features of "EZ Calc for Excel":

￭ Create "Current through 90 " Agings in as few as 3 clicks.
￭ Age as of "Today" or as of a "Specific Date".
￭ Age "From" or "To" the aging date.
￭ Use "From" when the dates are typically before the Aging Date as in Accounts Receivable agings.
￭ Use "To" when the dates are typically after the Aging Date as in Accounts Payable agings.
￭ Specify the number of decimals to display for number of Weeks and number of Months.
￭ Specify the rounding method for calculating number of Weeks and number of Months.
￭ Specify a cutoff to create an overflow period to limit the number of Days, Weeks and Months reported.
￭ "Current through 90 " and "Current through 120 " aging period descriptions sort correctly.
￭ Because they categorize data and reduce the number of data points, Aging Period fields are perfect for the X-axis in Charts and the column field in Pivot Tables.
￭ Create a Reformatted Date in 5 clicks.
￭ Month and Week-of-Year are leading zero filled to allow proper sorting.
￭ Because they categorize data and reduce the number of data points, Reformatted-Date fields are perfect for the X-axis in Charts and the column field in Pivot Tables.
￭ The new "Calendar to Fiscal" calculated field allows Year, Qtr, Month, Year-Qtr, Year-Month and the Week-of-Year variations to be expressed on a Fiscal Calendar basis.
￭ EZ-Calc applies formulas to only data rows, skipping subtotal rows.
￭ The User Guide contains tips for creating formulas that reference data in the previous row or the following row. The recommended formula syntax can be sorted without creating Excel errors.
￭ In EZ-Format subtotaled worksheets, subtotals can be added to any field in 2 clicks.
￭ As an alternative to using the Excel SUBTOTAL function, EZ-Format can create subtotals for an Excel formula field using the identical formula as used for the data. This allows meaningful subtotal values for Percent and Average calculated fields. There is also protection against divide by zero errors.
￭ EZ-Calc creates Running Totals for only data rows, skipping subtotal rows.
￭ In non-subtotaled worksheets Running Totals sort without creating Excel errors.
￭ In EZ-Format worksheets Running Totals can be restarted after each subtotal for any break field.
￭ EZ-Calc creates Percents for only data rows, skipping subtotal rows.
￭ EZ-Calc created Percents are protected against generating Excel divide by zero errors.
￭ In EZ-Format worksheets Percents can be restarted after each subtotal for any break field.
￭ In EZ-Format worksheets Percents can be subtotaled using the identical data formula with protection against generating Excel divide by zero errors.
￭ Extracted Text can be fixed or variable length.
￭ Extracted Text can be from a static or non-static position within the field.
￭ Knowledge of Excel text functions is not required.
￭ Change positive values to negative values based on the contents of another field.
￭ In the above example when Trans Code is "Credit Memo" or "Return" the Sales Amount in made negative.
￭ Testing can be case sensitive or insensitive.
￭ For testing purposes only, the Test Field and Test Values can be trimmed of leading, trailing and multiple embedded spaces.
￭ Designate the Test Values for positives with all other values being for negatives.


Limitations:

￭ 15 days evaluation trial