support
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.
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 ...
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 ...
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 ...
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 ...
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...
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...
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...
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...
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...
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,...
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 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....
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:...
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...
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...
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...
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  
Smarter spreadsheet calculating

esCalc keeps the basic functions and using style of spreadsheet, but is completely beyond traditional spreadsheet on complex tabular data calculation. Traditional spreadsheet lacks the capacity of integral calculation on business data, for example, when pasting a formula, other spreadsheets only permit adjustment of relative position, resulting in a business rule violation, while adjustment with esCalc can be finished automatically and intelligently focusing on the business relevance; When writing a formula, traditional spreadsheet can’t realize automatic copy without recognition of the business relationship among cells, on the contrary, esCalc enables formula or filtering condition expressions copied to the related business cells automatically and realizes intelligent adjustment according to the business relationship.

Traditional spreadsheet‘s positional relationship is disrupted after data grouping, making it difficult for data sorting and filtering, processing of the computed columns or aggregate value, the cross-row computing etc., while the above all will not happen in esCalc. The unique overall table computation model in esCalc can realize advanced features such as join, merge and difference between multi-level groups of data.


Related Articles

A More Intelligent Tabular Data Computing Tool Overperforms Traditional Spreadsheet
esCalc vs Traditional Spreadsheet
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...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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. ...
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 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 ...
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...
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...
Find shares from the daily trading stocks which had risen on five consecutive days. The picture below is original data in Excel and final computing result...
Make a grouped report on link relative ratio and year-on-year basis according to the database of various cars' sales, and compare the car sales of each year with chart. There are car orders of the past 3 years in the original database...
Compute the real wages after joining the performance and attendance tables to StandardWages sheet by Employee ID. Original data is stored in 3 Excel sheets: standard, absence and performance as below....
Find the monthly top 5 outstanding salesmen according to the daily sales records in the database. Original daily sales records of each salesman in the year are shown below...

Contact us today to discuss your esCalc solution or Download esCalc