The spreadsheet can implement the visualized calculation to some extent, and the nontechnical people can perform some rather complex calculations without having to learn the SQL. However, as the core of SQL, the relational query is unable to be implemented through spreadsheet, which adds complexity to the apparently simple problems of multi-table join.



For example, the Finance department needs to calculate the salary, and the…

Continue

Continue

Continue

A standalone alternative for Excel on complex data computing, esCalc, will be offered for free to participants who write reviews or share their application cases (The application cases could be the usage of esCalc in a task or a function introduction of esCalc.), according to the announcement of Raqsoft. This campaign starts from March 6, 2013 and will end at May 6, 2013.



Participants will get various licenses of esCalc through different forms of participation, showing as…

Continue

Getting train tickets is always very difficult during holiday, especially in Spring Festival, the most important Chinese holiday for family reunions. The transport peak spans from Jan. 26, 2013 to March 6. During this period, buying tickets at railway station or from the official website of MOR (China’s Ministry of Railways) or through phones seem to become an extravagant expectation. What are the reasons? How to take effective measures?…

Continue

Continue

Continue

People like to predict what will happen in future especially in 2012. Nostradamus brought about massive destruction and mayhem thought there was comet in 2012. Even Mayans stopped their calendar on December 21st, 2012. If it’s true, human only has less than a week to live. But do you really convinced by this dire prediction? Is this prediction based on correct analysis? Some people who believe that because they are depressed at some bad phenomenon such war, natural disaster, resource…

Continue

Enterprises always have various data sources, for instance, CRM system may use SQL Server, sales reports adopt Excel, ERP applies Oracle database. When it comes to actual business analysis, enterprises usually need to conduct interactive computation, including filter, group, etc among various data environments. But data Interaction between multiple data sources are not easy to realize with some traditional statistical computing tools. In order to solve such kind of problems, esProc which…

Continue

In the actual business, data analysis and statistical computation as well as report preparation are required no matter for the management of inventory and human resources, or calculation of customer information and sales data. In this case, a tool which can handle different datasource like text, spreadsheet, database, etc. is needed in urgent. However, most of statistical computation software needs modeling before computation and analysis which reduces flexibility to meet analysts'…

Continue

Excel® is the most widely-used spreadsheet tool. The nontechnical persons like to use it for computation and analysis. But they usually find the formulas and functions available in Excel® are rather poor and the VBA® is just double Dutch to them for further analysis. Thus, a huge volume of data with valuable information has been wasted in vain.

Hereby introduce a better solution to realize the utmost value of Excel® by taking the esProc advantages of powerful computation ability,…

Continue

I am happy to announce the release of Inference for R version 3.5. This is a significant release for Inference that includes several major features requested by users:



• Inference in PowerPoint: Embed and run R code in PowerPoint presentations just as you can in Word and Excel.



• Run-in-Place: Execute R code inside of an Excel, Word, or PowerPoint document and see the code results immediately in the same document – “preview” how your document will execute without having to… Continue