support
Home- esCalc
esProc is more ease-of-use and capable script for statistical computing. It bridges the gap between business and IT with more powerful computing capability than SQL, delivering more convenience and flexibility to your complex business analytics.

esProc is a brand new script to simplify the complex database computation with step-by-step mode. It can deal with tentative and occasional problems without data-modeling beforehand, releasing you from heavy data process work. esProc can also integrate complex and various datasource as a database, keeping you away from tedious and complex SQL and stored procedure.

esProc runs as a desktop application, it can be utilized easily by business professionals without highly skilled technology background or extra training, which could greatly improve your productivity by minimizing the purchase and learning costs.
Professional developer tool for data computing
esProc is easy-to-use business computing script specialized in solving complex computing objects. It optimizes business data and has lower technical requirements.

esProc is cell style scripts, allowing complex business computing objects to be divided into small objects in the grids for solving final objects.

esProc is designed for business professionals, as its syntax is easy to use and understand with lower ...
More capable database computing script
esProc is more powerful on structured data computing, particular for complex computation in database as a script language.

esProc improves SQL computing ability with step by step computing, sequence computing, set-lization and object reference.

esProc can solve complex database problems by dividing into several simple computing steps. Each step result can be referenced directly for further ...
Data source development tool for reports
esProc allows report designers to combine esProc's excellent computation and analysis capability with the strong presentation function of reporting tools. It can organize the disorderly source data and directly delivery clear data to reporting tools through the JDBC interface.

Besides, esProc can also complete complex data analysis and give the analytical results ...
Ease-of-use desktop tool for business computing
With esProc, users can complete a series of computing independently, especially about complex analysis target. So it is a real desktop BI tool reflected in the following aspects: First, it does not require pre-data-modeling for your analysis goal relying on powerful computing capability and lower technical requirements. It allows users to conduct data analysis freely, therefore to meet the fast changing demands agilely with lowest cost ...
Intuitive Grid Codes
esProc provides a grid user interface similar to excel which enables users to perform codes in a grid from left to right, top to bottom. Each cell has unique and naturally named coordinates with column and row number, so users can reference the calculation results of other cells conveniently through the coordinates for further processing...
Complete Set-lizing
esProc realizes complete set-lizing, which differs from the simple and rough SQL sets. esProc sets are ubiquitous, and the members can be of any data type or another set. Complete set-lizing transforms the cumbersome and difficult lower-level calculations into high-level set operations, for example, the intersection...
Convenient Reference
esProc is more intuitive and easier than SQL to solve complex calculations with multi-table join. With "." for generic object reference in esProc, this expression is more straightforward and easy to understand, allowing users to easily organize the relationship between data from business perspective. esProc reference function tranforms...
Simple Steps for Sequence
When coming to serial number relational computations, esProc greatly simplifies the calculation difficulty and makes users without high technical capacity easily carry out the seemingly complex calculations. There are a large number of computational problems related to serial number actually, such as over the...
Real Sense Grouping
esProc grouping completely covers a variety of situations, which is more agile and easier to use than SQL to solve the grouping related problems. In esProc, grouping and summary can be divided into two steps. The grouping results can be reused or for secondary processing, such as sorting, query, and re-grouping...
What is esProc
esProc is a developer tool for business computing as well as a desktop analysis software. It is specialized in computation on massive structured data and complicated multistep computation to meet the fast-changing demands.esProc is a developer tool for data computing with higher development efficiency, better debugging features, easier codes maintenance,...
esProc Background
Data analysis and query are essential for data computing. Report data source preparation and data management & ETL also involve data computing. Most of the problems are complex and diverse, and the business computing is usually characterized with timeliness and the unpredication. The computation objects are changing constantly and oftentimes available at any time. Users hope to deal with the data computation conveniently...
esProc Innovation
esProc adopts the cellset-style script, the cells are natural ly located and formatted. The computation steps can be spreaded in the cells neatly and clearly. The results of previous computations can be referenced easily with the cell name.The structure of esProc syntax is simple and clear, with concise and rich expression....
Structure & Requirement
esProc is a developer tool for business computing.In esProc, the computing result can be accessed through standard JDBC interface.Able to act as the datasource for reporting tool. Able to act as the layer of data computation of Java application.Support any Java Web Server, and platform independently.System Requirements:...
esProc Screenshots
Here are some screen shots for you to have a deeper insight on our product, include Cellset-style Script , SQL Execution and Data Structure Display, Program Debugging ,Computation Presentation etc...
Case: Stock Rise for 10 Consecutive Days
From the closing prices of several stocks this month, you are to find the stocks that have been rising for 10 consecutive days. Let's see how esProc manage it...
Case: Average Interval Between Buying Jetta and Magotan
Based on the automobile sales data, calculate the average interval between buying the Jetta first and then the Magotan. Please note that a customer may buy the same model car for several times, and thus there may be several intervals. In this case, we will take the shortest in...
Case: Calculate Payroll According to Absenteeism and Performance
To make the payroll table of this month based on the basic information of employees, absenteeism and performance data. The basic algorithm is: Actual Pay = Base Pay*( 1-Absenteeism Factor+Performance Factor). Please note that, the basic information is based on all employees...
Contact us   today to  discuss  your esProc solution or  Download esProc  
esCalc leads to the computing capacity revolution for spreadsheets. It can easily solve problems which are difficult for traditional spreadsheets, such as: automatic formula copy in related cell, formula automatic migration between multi-layers tables, associated join between multiple tables.

esCalc realizes real visualization of data computation. Computations such as query, grouping, sorting, ranking, delete, table joins, filter for duplicates, which can only be completed previously by abstract scripts like SQL statements, R language, esProc scripts, can now be achieved by buttons/menus as long as concrete data is given.

With esCalc, business users can independently conduct a range of business intelligence computation on desktop, analyze data agilely in rapidly changing business opportunities and make quick decisions. esCalc is self-service professional reporting tool, more intelligent spreadsheet, data calculator for business users and secondary processing tool for reports.

Professional self-service reports

The traditional reporting tools usually need higher technical requirements, such as retrieving script, complex report expressions, and abstract logic. While with esCalc, the business users can complete the entire report independently without technical background.

First, esCalc provides retrieving data UI to guide static data extraction from the database, Excel or text files. Second, its ease-of-use and traditional Excel-style user interface allows users to build the report more quickly; third, it transforms the script writing functions of traditional reporting tools into visual operations, including filter, sort, group, hide, merge, join, union, etc; fourth, it overcomes difficulties facing by traditional reports with simple formula, which is easy to understand like a common spreadsheet. Finally, esCalc provides professional reporting functions, including rich landscaping styles, multiple charts, exporting to multiple data formats, page breaking and printing, etc.


Related Articles

Professional Reporting Software – Part I
Professional Reporting Software – Part II
Professional Reporting Software – Part III
Professional Reporting Software – Part IV
A Technical Obstacle to Traditional Reporting
Directly Retrieve Data from XLS/TXT file and DB
Capable to reference the data from database or external files such as txt and Excel. Capable to perform the copy, paste, and other operations to edit the cellset data. Intuitive interface for report preparation. Capable to be saved as various formats like txt, xls, and gex to facilitate the use and edit...
Multi-level Structure and Real Grouping
Through the level settings, rows are associated to each other. The multi-level structure can describe the data in the real business more completely. Free and convenient grouping operation with outstanding performance and the usage is quite simple. It is the real grouping that you can sort, filter, and perform other operations on each group and the data ...
Homorow and Homocell
The data with the same business priority will be set in the homorow. The appearance property of homocell in the homorow will be processed concurrently. Through the formula migration of homocell, calculations of the same business logic will be completed all at once. Given the below table of the technical data of pitchers of some baseball teams ...
Smart Resolution of Formula
Utilize the settings of homorow and level, recognize the true objective of computation smartly. The formula in homocell will be auto-migrated, no need to copy and paste. In the below table, given the statistics of the most frequently used surnames in some countries, calculate the proportion taken by the total population of people with this surname in each region ...
Support for Set Calculation All-roundly
Full support for sets, and capable to handle the sum, subtraction, intersection, union, and other operations on sets directly. The sets exist in the form of object, making the summarization more intuitive and easy to read and write. Given the score statistics for the last three games of a certain basketball team, make statistics on players whose scores are among ...
Calculator Style of Stepwise Operations
Stepwise operation to solve the complicated problem progressively. Instant presenting the result, intuitive, and easy-to-use. Given the payroll of a company below, select out the male employees of which the wage are higher than that of any female employee in their department. ...
Multi-level Join
Handle the multi-level join automatically according to the level and master cell settings. Operation style is similar to the copy & paste, convenient and intuitive. In the below table, there is the population data of some states and the abbreviations are set as the master cell ...
What is esCalc
As a desktop BI tool, esCalc is specialized in various data process from database, text, and Excel files. It is user friendly, easy to install and use, and does not require high technical background. esCalc can operation functions like locate, filter, sort, group, align, join and union through menu to complete various complex data analysis between multiple tables. ...
esCalc Background
Data analysis and report preparation are widely required practically in business for the management of inventory, sales, and human resources, etc.,like the statistics on the client and sales data. It's essencial for users to realize self-analyzing and self-reporting. Spreadsheet is the most widely used desktop data process software, but the traditional spreadsheet lacks the ability of computing the complex analysis...
esCalc Innovation
esCalc has implemented the complete set-lization for you to conveniently perform the set operations, such as intersection, complement, and union.With the multi-level structure, the practical business can be described in a better way to implement the real grouping. Based on the multi-level structure, various data file can be associated to implement the join and union ...
Structure & Requirement
Rich and perfect format setup and pagination features to support various charts.Excel-style interface for easier report design and more convenient operation.Rich data analysis features to complete various analysis operations like statistics, grouping, sorting, and filtering. System Requirements...
esCalc Screenshots
Here are some screen shots for you to have a deeper insight on our product, include Cellset-style Script , SQL Execution and Data Structure Display, Program Debugging ,Computation Presentation etc...
Case:Top 3 Clients by Order Value
Compute the top 3 clients by order value according to the detailed order data. The basic train of thought is to group the orders by clients firstly, secondly sum up...
Case:Compute Actual Salary Through Basic Salary, Attendance and Performance
Given a book of 3 Excel sheets in which there is the basic salary, attendance record, and performance data, we now need to compute the actual salary of employee. When computing, use the below formula: Payable weekly salary = standard weekly salary *(1+Performance...
Case:Compute Sales Value Compared on Year-on-year Monthly Basis and Link Relative Ratio
On the basis of a database of the sales data of a pharmaceutical company in the recent 2 years, make statistics on the year-on-year monthly and the link relative ratio comparisons for each product. In which, the link relative ration comparison refers to the monthly...
Contact us   today to  discuss  your esCalc solution or  Download esCalc