EZ-Calc for Microsoft Excel v.7.1

Advertisement
Advertisement

* The following applies to all Aged Date Excel Formula Fields * Knowledge of Excel Date Functions, Excel Text Functions and Excel Formulas is not required when creating Aged Date Fields with EZ-Format, EZ-Chart, EZ-Pivot and EZ-Stat. * Because Date Agings categorize data and reduce the number of data points, Aged Date fields are perfect for the X-axis and Z-axis in Excel Charts and as a column field in Excel PivotTables and Excel PivotCharts * Age Dates as of "Today" or as of a "Specific Date" * Calculate "To" or "From" the specified Aging Date o "From" is used to Age Dates predominently before the Aging Date + As in an Accounts Receivable Aging where "Invoice" dates are in the past * o To" is used to Age Dates predominently after the Aging Date + As in an Accounts Payable Aging where "Due" dates should be in the future * The calculated Aging Values can be left, center or right justified * The new Field Description for the Aged Date Excel Formula field is automatic or user specified * Aged Date Fields can be created in non-subtotaled and subtotaled Excel Lists beginning in cell A1 * The following applies to "Elapsed Number of Days between two Dates" * Specify a cut-off maximum number of Elapsed Days to calculate and display * Elapsed Days greater than the specified cut-off go into a separate displayed overflow value * Automatically append a default Description (Day / Days) onto the Number of Days Values * The appended "Description" can be user specified or suppressed * The following applies to "Elapsed Number of Weeks between two Dates" * Specify a cut-off maximum number of Elapsed Weeks to calculate and display * Elapsed Weeks greater than the specified cut-off go into a separate displayed overflow value * Round calculated Elapsed Weeks down, up or from the middle * Display the fractional number of Elapsed Weeks in 0-4 decimal positions * Automatically append a default Description (Week / Weeks) onto the Number of Weeks Values * The appended "Description" can be user specified or suppressed * The following applies to "Elapsed Number of Months between two Dates" * Specify a cut-off maximum number of Elapsed Months to calculate and display * Elapsed Months greater than the specified cut-off go into a separate displayed overflow value * Round calculated Elapsed Months down, up or from the middle * Display the fractional number of Elapsed Months in 0-4 decimal positions * Automatically append a default Description (Month / Months) onto the Number of Months Values * The appended "Description" can be user specified or suppressed * The following applies to the four "Accounting Type" Aged Date Fields * "Current, 31-60, 61-90 and 90+" with and without "Days" automatically appended * "Current, 31-60, 61-90, 91-120 120+" with and without "Days" automatically appended * "Days" is optionally appended onto the appropriate Accounting Type Date Aging Values * There is no cut-off maximum for Accounting Type Date Agings * The new Excel Formula Field Description can be automatic or user specified * Accounting Type Date Aging values sort ascending and descending as shown below: o "Future, Current, 31-60, 61-90, 90+" for "From" Date Agings o "Past, Current, 31-60, 61-90, 90+" for "To" Date Agings o "Future, Current, 31-60, 61-90, 91-120 120+" for "From" Date Agings o "Past, Current, 31-60, 61-90, 91-120 120+" for "To" Date Agings

* The following applies to all Aged Date Excel ...

 
  • Shareware
  • 2.1 Mb
  • 359
  • $29.95
 
 

Review EZ-Calc for Microsoft Excel

  • captcha
 

Other software of Data Presentation Products, Inc.
  • Xcelerator for Excel  v.6.1Format data and transparently create re-usable Xcelerator workbook formats in a fraction of the time it takes to format data using only Excel. Do nothing to raw data before using Xcelerator to format a set of fields for the first time or when ...
    
    New Project Management software
    • Exchange GroupCalendar  v.3.0Improve your team calendars in outlook by making them show only relevant information. What if you had company wide calendars: with only the items related to a certain client; with veryone's vacation time; Without ever double entering information?
    • GoalEnforcer Hyperfocus  v.2018r0Set and track your goals, subgoals, task and subtasks, improve your productivity and accomplish faster by using GoalEnforcer's innovative visual approach for goal setting and task management.
    • A VIP Project Management Solution  v.3.64Project and Document Management tool for company or team management. It allows planning, scheduling, sharing any appointments, projects and another company or employees' activities through Local Network and Low Speed Network ...
    • In-STEP BLUE  v.6.3in-STEP BLUE is a tool for IT project management. It offers project and multi-project management, requirements and change management, quality and test management, configuration management, risk management and process management.
    • CONSIDEO MODELER  v.4.5The MODELER allows to visualize, explore, evaluate, communicate and foresee intuitively the complex connections in any field. As easy to use as mindmapping though more powerful you can model you everyday's decisions. You can download a ...
    • Project Management Templates  v.1.1This project management process helps you manage projects of all sizes, from start to finish, It includes a suite of tools, templates and forms for delivering projects. Based on worldwide standards, this best practice approach guides you towards ...