ez r excel 1.61
ez r excel 1.61
EZ-R Excel is a stand-alone product for the analysis of data in Excel worksheets This is a stand-alone product for the analysis of data in Excel worksheets. In order to use it, both Excel and EZ-R Excel must be opened. Data is selected from the worksheet and copied to the Windows clip board.
Then this same data is pasted into EZ-R Excel for further analysis and charting. Reports and charts in EZ-R Excel can then be viewed or copied to the clipboard for pasting back into other applications.
Key features: fraud detection using Benfords, histograms, univariate statistics, gap detection, frequency distributions, outliers, summarization.
EZ-R Excel is a Windows based menu driven system This facilitates access to the functions without having to remember special key strokes.
A variety of analytical tools are offered, classified as follows:
- Work With Ranges - Basic Statistcis
- Classify and stratify data
- Benfords Law analysis
- Descriptive Statistics
- Histogram
- Univariate Statistics
- Obtain Crosstabs
- Check for Gaps in Sequence Numbers
- Frequency Distributions
- Telephone Area Code Validation
Enhancements: Working with data on Excel worksheets
Requirements:
- Windows,
- Excel 2000,
- 15 MB of disk space
WareSeeker Editor
EZ-R Excel is a Windows based menu driven system This facilitates access to the functions without having to remember special key strokes.
A variety of analytical tools are offered, classified as follows:
Work With Ranges - Basic Statistcis
Classify and stratify data
Benfords Law analysis
Descriptive Statistics
Histogram
Univariate Statistics
Obtain Crosstabs
Check for Gaps in Sequence Numbers
Frequency Distributions
Telephone Area Code Validation
The routine also provides analytical review functions based upon the Kolmogorv-Smirnov test which can compare two Balance Sheets or Income Statements at different periods and easily identify the most material item contributing to the difference and the extent of that difference. This assists the auditor in deciding which accounts should be reviewed further.
EZ-R Stats for Excel - Excel Add-in for statistical analysis EZ-R Stats is an analytical tool which is script and Windows based. It is available at no charge.
The primary objective of EZ-R Stats? for Windows is to make a difference in the analysts work
Here are some key features of "EZ R Stats for Excel":
Menu driven from within Excel
Compatible with Other Microsoft Office Products
Many powerful analytical functions
Detailed documentation (View PDF)
Free for commercial and personal use
EZ-R Stats for Excel 1.2 is an effective software which provides you statistical analysis.
The routine facilitates and supports data analysis by providing numerous tools and charts, leveraging the facilities within MS-Excel.EZ-R Excel has been tested with Excel 2003 and Windows XP.
This routine is available at no charge, and may be used for any purpose, including personal and commercial.
EZ-R Excel is a Windows based menu driven system This facilitates access to the functions without having to remember special key strokes.
Major Features:
- A variety of analytical tools are offered, classified as follows:
- Work With Ranges - Basic Statistcis
- Classify and stratify data
- Benfords Law analysis
- Descriptive Statistics
- Histogram
- Univariate Statistics
- Obtain Crosstabs
- Check for Gaps in Sequence Numbers
- Frequency Distributions
- Telephone Area Code Validation
- The routine also provides analytical review functions based upon the Kolmogorv-Smirnov test which can compare two Balance Sheets or Income Statements at different periods and easily identify the most material item contributing to the difference and the extent of that difference. This assists the auditor in deciding which accounts should be reviewed further.
Enhancements: Integrate with EZ-R Stats for Windows
Requirements:
- Windows,
- Excel 2003,
- 20 MB of disk space
R-Excel is a tool designed to recover corrupted Microsoft Excel Sheets R-Excel is a program created to recover corrupted Microsoft Excel Sheets. New improvements of file reconstruction technology IntelligentRebuild allow the users to reconstruct damaged *.xls files and to restore lost Excel sheets quickly and easily.
R-Excel safely performs any operation, including Microsoft Excel sheet recovery and never deletes from disk, writes to, or modifies in any way, the original Excel files.
Requirements:
Excel
R-Excel is a tool designed to recover corrupted Microsoft Excel Sheets. New improvements of file reconstruction technology IntelligentRebuild allow the users to reconstruct damaged *.xls files and to restore lost Excel sheets quickly and easily.
R-Excel safely performs any operation, including Microsoft Excel sheet recovery and never deletes from disk, writes to, or modifies in any way, the original Excel files.
Features:
-Standard Windows Explorer - style interface.
-Host OS: Windows 98, ME, NT, 2000, XP, 2003, Vista.
-Supported *.xls file formats: Microsoft Excel 97/2000/XP/2003.
-Automatic or manual search for Excel sheets. R-Excel searches for Excel sheets on all (including network) disks visible by the host operating system.
EZ-R Stats is an analytical package which is script and Windows based EZ-R Stats for Windows is an analytical package which is script and Windows based. It is available free of charge.
The primary objective of EZ-R Stats for Windows is to make a difference in the analysts work. Download EZ-R Stats for Windows product and documentation. Or see Overview of EZ-R Stats for Windows.
Key features: fraud detection using Benfords, histograms, univariate statistics, crosstabs, Benfords analysis, random sampling, cma sampling, SQlite, SQLite extensions, gaph analysis, frequency distributions, outliers, cross tabs, summarization, domain.
R-Excel safely performs any operation, including Microsoft Excel sheet recovery and never deletes from disk, writes to, or modifies in any way, the original Excel files.
A MS Excel sheet can be recovered by double clicking the selected *.xls file. The file content is displayed in the right tab as an MS Excel sheet (installed MS Excel required) and can be saved by an R-Excel registered version either as an MS Excel file.
R-Excel Demo displays recovered/reconstructed *.xls files but you cannot save them on a hard drive, CD, floppy, etc.
Automatically Summarize Data and Reuse Customized Excel Chart Types
Save Custom Formatted Excel Charts and re-use with new Automatically Summarized Data.
No other Excel Add-in automatically summarizes data when creating an Excel Chart.
Easily Create Excel Charts without modifying the formatting of the Excel List Data.
Key Features:
Automatic summarization allows creation of multiple charts using different fields from the same data
The Excel source data can include subtotals, column totals, no totals, hidden rows and hidden columns
EZ-Chart created Chart Data and Excel Charts are independent of the format of the original Excel data
EZ-Chart saves the time normally spent manually summarizing data for charting
EZ-Chart eliminates having to always customize the selected Chart Type each time a chart is created
EZ-Chart assigns the automatically summarized data to the selected customized chart formats
EZ-Chart extracts and summarizes only visible data rows to create the Chart Data and Excel Charts
Excel subtotal rows are automatically excluded from the summarized Chart Data
Chart formats contain customized embedded and separate Charts, preset fields and additional settings
To create charts specify the source data and select an EZ-Chart format with its preset fields and settings
When charting new data EZ-Chart shows all formats using fields exactly matching fields in the data
When re-using a matching EZ-Chart format the Excel charts, preset fields and settings are re-used
Four clicks creates identical Excel charts from any data containing the EZ-Chart formats preset fields
When re-using a non-matching EZ-Chart format the Excel charts are re-used with new fields and sttings
Chart titles are constructed using the field names unless over-ridden in a matching EZ-Chart format
Re-using EZ-Chart formats eliminates adjusting Excels chart formats each time a chart is created
Time-Saving Ad Hoc Formatting of Excel Data.Saving Worksheet Formats for Re-use with New Data.Automatically Formatting New Data Using Saved Formats.Making Excel Subtotals Mixing Excel Subtotal Types.Splitting Worksheets into Multiple Worksheets, into One or Multiple New Workbooks for Values in any Field.Over three dozen Excel Formatting and Excel Data Analysis enhancements too time consuming to perform manually!
EZ-Chart creates 100% identically formatted printer-ready Excel charts from virtually any Excel data. In seconds EZ-Chart creates 100% identically formatted printer-ready Excel charts from virtually any Excel data.
Limit the chart data to records containing specific values in one or more fields. For data not already summarized, EZ-Chart summarizes the visible data before creating the charts. Easily center data and charts for viewing and printing.
Pre-summarizing data is not required. Simply pick the data and the re-usable EZ-Chart format.
Then modify or select the fields to chart, number of points to chart, whether to chart overflow totals and the sort order; settings that are part of every EZ-Chart format.
Change chart types, customize charts, modify EZ-Charts additional settings and save everything for re-use with new data for either the same fields or different fields. Easily export charts.
Use the separate EZ-Calc product to create accounting type Aged Dates, Reformatted Dates and additional custom fields for use in charts.
Here are some key features of "EZ Chart for Excel":
NEW! (11/30) Use with EZ-Pivot and "Drill" into the detail data for any Chart amount
NEW! (11/08) Create Charts using data that is already perfectly summarized for charting
NEW! (11/08) Create re-usable EZ-Chart formats from any user-customized Excel chart
NEW! Automatically summarizes Excel data to create XY and XYZ Charts
NEW! Dynamically set the number of X values to chart and whether to chart the overflow totals
NEW! Chart Legends auto-size to the width of the data when using Excels Legend Placement setting
NEW! Easily Chart subsets of data using the powerful multi-field / multi-value per field selection feature
NEW! Create charts from a contiguous range of cells within a larger data set
NEW! Chart Data is always visible above or below an automatically positioned Embedded Chart
NEW! Chart Data is horizontally centered within the width of the Embedded Chart
NEW! Chart Data and Embedded Charts are horizontally centered for printing
Automatic summarization allows creation of multiple charts using different fields from the same data
The Excel source data can include subtotals, column totals, no totals, hidden rows and hidden columns
EZ-Chart created Chart Data and Excel Charts are independent of the format of the original Excel data
EZ-Chart saves the time normally spent manually summarizing data for charting
EZ-Chart eliminates having to always customize the selected Chart Type each time a chart is created
EZ-Chart assigns the automatically summarized data to the selected customized chart formats
EZ-Chart extracts and summarizes only visible data rows to create the Chart Data and Excel Charts
Excel subtotal rows are automatically excluded from the summarized Chart Data
Chart formats contain customized embedded and separate Charts, preset fields and additional settings
To create charts specify the source data and select an EZ-Chart format with its preset fields and settings
When charting new data EZ-Chart shows all formats using fields exactly matching fields in the data
When re-using a matching EZ-Chart format the Excel charts, preset fields and settings are re-used
Four clicks creates identical Excel charts from any data containing the EZ-Chart formats preset fields
When re-using a non-matching EZ-Chart format the Excel charts are re-used with new fields and settings
Chart titles are constructed using the field names unless over-ridden in a matching EZ-Chart format
Re-using EZ-Chart formats eliminates adjusting Excels chart formats each time a chart is created
Use Excels charting tools to customize the two Excel charts created by an EZ-Chart re-useable format
Update and create EZ-Chart formats to save the chart formatting, chart fields and additional settings
View and maintain the formats of all embedded and separate charts in all EZ-Chart formats at one time
Dynamically set the number of X values to chart and whether to chart the overflow totals
View the X and Y values making up the overflow totals
Limit the total number of charted Z values to a specific number of high or low values
Switch between EZ-Chart formats for the same Chart Data
The Separate Chart worksheet, Chart Data worksheet and the Embedded Chart are each printer-ready
Except for hiding and unhiding rows of data there are no modifications to the Excel data being charted
Two clicks recalculates the Chart Data and updates the Charts using the currently visible source data
Two clicks exports Charts and Chart Data to a new or existing workbook without exporting the source data
Works with Microsoft Excel 2000 / XP / 2003 on Microsoft Windows 2000 / XP / 2003 Server
Use EZ-Calc to create eight useful types of calculated fields including Accounting-Type "Date Aging" and "Re-formatted Date" fields
All products install in seconds, and completely uninstall as separate products
EZ-Format, EZ-Chart, EZ-Pivot and EZ-Calc are included in the EZ-Deluxe product
EZ-Deluxe is the economical way to purchase all four EZ products
Upgrade to EZ-Deluxe from any one EZ product without a price penalty
All products self-register upon purchase if software is currently installed or is subsequently installed
All products include life-time free updates for product enhancements and bug fixes
Limitations:
15 days trial
EZ-Deluxe combines EZ-Total, EZ-Chart, EZ-Pivot and EZ-Calc into one economical solution for the ad-hoc formatting of data. EZ-Deluxe combines EZ-Total, EZ-Chart, EZ-Pivot and EZ-Calc into one economical solution for the ad-hoc formatting of data.
Quickly create better formatted printer-ready Worksheets, Subtotals, Charts, PivotTables and Drills.
Create eight types of calculated fields including accounting type Date Agings. Use automatically created and applied Styles. For any field view the records for each data value including subtotal rows hidden by Excel.
At any time export only the visible records. Split data into multiple worksheets by the values in any field. Walk PivotTable page and row values.
Each EZ-Deluxe component contains dozens of practical enhancements to Excels formatting and analysis capabilities.
If you periodically format new data for the same fields, use multiple formats for the same fields, or change field descriptions, then save even more time with Xcelerator for Excels exclusive ability to create re-usable formats.
Limitations:
15 days evaluation trial
========
Key Features
========
. Import Excel spreadsheet into AutoCAD LT and keep it updated.
. Be able to import part of an Excel spreadsheet.
. What you see in Excel is what you get in AutoCAD LT.
. Full control of font type/style/size/color.
. Support for Border style (double-line, dashed line, diagonal and etc)
. Vertical/Wrap text, merged cells, Center across selection.
. All elements of the imported table are AutoCAD Entities.
. Update table to its original Excel spreadsheet.
. Support for local area network (LAN).
. AutoTable can be plotted perfectly.
. More versatile Table Solutions. Ideal for:
o Panel Schedules
o Equipment Schedules
o Room Finish Schedules
o Door and Window Schedules
o Bills of Materials (BOM)
o Parts lists
o Notes
=================
Unique Selling Points (USP)
=================
. The fastest Excel to AutoCAD import tools in the world.
. Import Excel spreadsheet with One-Click button.
. Edit the imported table with Excel.
. Support for Unicode Encoding (Multi-language character sets, such as East Asian languages).
. Support for Cell shading & patterns.
. Support for Math symbols etc.
. Support for basic Excel AutoShapes (line, rectangle, oval, arrows and etc).
. Update all imported tables at one time.
. Import several spreadsheets from different worksheets within a workbook and keep them updated.
In seconds EZ-Chart creates 100% identically formatted printer-ready Excel charts from virtually any Excel data.
Limit the chart data to records containing specific values in one or more fields. For data not already summarized, EZ-Chart summarizes the visible data before creating the charts. Easily center data and charts for viewing and printing.
Pre-summarizing data is not required. Simply pick the data and the re-usable EZ-Chart format.
Then modify or select the fields to chart, number of points to chart, whether to chart overflow totals and the sort order; settings that are part of every EZ-Chart format.
Change chart types, customize charts, modify EZ-Charts additional settings and save everything for re-use with new data for either the same fields or different fields. Easily export charts.
Use the separate EZ-Calc product to create accounting type Aged Dates, Reformatted Dates and additional custom fields for use in charts.
Features of "EZ Chart for Excel":
NEW! (11/30) Use with EZ-Pivot and "Drill" into the detail data for any Chart amount
NEW! (11/08) Create Charts using data that is already perfectly summarized for charting
NEW! (11/08) Create re-usable EZ-Chart formats from any user-customized Excel chart
NEW! Automatically summarizes Excel data to create XY and XYZ Charts
NEW! Dynamically set the number of X values to chart and whether to chart the overflow totals
NEW! Chart Legends auto-size to the width of the data when using Excels Legend Placement setting
NEW! Easily Chart subsets of data using the powerful multi-field / multi-value per field selection feature
NEW! Create charts from a contiguous range of cells within a larger data set
NEW! Chart Data is always visible above or below an automatically positioned Embedded Chart
NEW! Chart Data is horizontally centered within the width of the Embedded Chart
NEW! Chart Data and Embedded Charts are horizontally centered for printing
Automatic summarization allows creation of multiple charts using different fields from the same data
The Excel source data can include subtotals, column totals, no totals, hidden rows and hidden columns
EZ-Chart created Chart Data and Excel Charts are independent of the format of the original Excel data
EZ-Chart saves the time normally spent manually summarizing data for charting
EZ-Chart eliminates having to always customize the selected Chart Type each time a chart is created
EZ-Chart assigns the automatically summarized data to the selected customized chart formats
EZ-Chart extracts and summarizes only visible data rows to create the Chart Data and Excel Charts
Excel subtotal rows are automatically excluded from the summarized Chart Data
Chart formats contain customized embedded and separate Charts, preset fields and additional settings
To create charts specify the source data and select an EZ-Chart format with its preset fields and settings
When charting new data EZ-Chart shows all formats using fields exactly matching fields in the data
When re-using a matching EZ-Chart format the Excel charts, preset fields and settings are re-used
Four clicks creates identical Excel charts from any data containing the EZ-Chart formats preset fields
When re-using a non-matching EZ-Chart format the Excel charts are re-used with new fields and settings
Chart titles are constructed using the field names unless over-ridden in a matching EZ-Chart format
Re-using EZ-Chart formats eliminates adjusting Excels chart formats each time a chart is created
Use Excels charting tools to customize the two Excel charts created by an EZ-Chart re-useable format
Update and create EZ-Chart formats to save the chart formatting, chart fields and additional settings
View and maintain the formats of all embedded and separate charts in all EZ-Chart formats at one time
Dynamically set the number of X values to chart and whether to chart the overflow totals
View the X and Y values making up the overflow totals
Limit the total number of charted Z values to a specific number of high or low values
Switch between EZ-Chart formats for the same Chart Data
The Separate Chart worksheet, Chart Data worksheet and the Embedded Chart are each printer-ready
Except for hiding and unhiding rows of data there are no modifications to the Excel data being charted
Two clicks recalculates the Chart Data and updates the Charts using the currently visible source data
Two clicks exports Charts and Chart Data to a new or existing workbook without exporting the source data
Works with Microsoft Excel 2000 / XP / 2003 on Microsoft? Windows? 2000 / XP / 2003 Server
Use EZ-Calc to create eight useful types of calculated fields including Accounting-Type "Date Aging" and "Re-formatted Date" fields
All products install in seconds, and completely uninstall as separate products
EZ-Format, EZ-Chart, EZ-Pivot and EZ-Calc are included in the EZ-Deluxe product
EZ-Deluxe is the economical way to purchase all four EZ products
Upgrade to EZ-Deluxe from any one EZ product without a price penalty
All products self-register upon purchase if software is currently installed or is subsequently installed
All products include life-time free updates for product enhancements and bug fixes
Limitations:
15 days trial
Want to place your software product here?
Please contact us for consideration.
Contact WareSeeker.com
