buy cialis buy valium online buy viagra online

esProc Charts: The Sector Element

Used only in polar coordinates, the sector element is usually for plotting a pie chart. Here we’ll explain how it is employed and its properties. 1. Data properties Through the following pie chart for displaying vault results, we’ll discuss the basics of plotting the sector element.   A 1 =canvas() 2 =demo.query(“select * from GYMSCORE […]

esProc Solves Eight Queens Problem

Among lots of chess puzzles, the problem of the eight queens is the most well-known example. Eight queens must be placed on a 8×8 chessboard so that no queen attacks any others. Well, how many solutions are there?  A queen attacks any other queen that sits on the same row, column or diagonal. Thus a […]

esProc Charts: The Column Element

The column element is frequently used in plotting various charts. We’ve made some studies about it in esProc Charts: Coordinate Axes through examples. Here we’ll illustrate the setting of its properties and their roles. 1. Data properties The plotting algorithm below for plotting a clustered column chart of gym results will lead you to the […]

An esProc Code Example of Computing Link-Relative Ratio and Year-on-year Comparison

A link-relative ratio is a percentage got by comparing the data of current period and that of the previous period. Usually the interval between the two periods is a month (sometimes an hour, a day, a week and a quarter). The link-relative ratio of April is computed by dividing, for example, its sales amount by […]

Code Examples of esProc Foreign Key Function

If k (a single field or a combination of fields) is table M’s primary key, and k, at the same time, exists in table B, then k is regarded as B’s foreign key. The foreign key defines a relationship between two tables and is one of the most important concepts for structured data computing. Through […]

esProc Charts: The Line Element

We learned how to plot a dot chart element using logical coordinates in esProc Charts: The Dot Element. Here we’ll learn about plotting the line element. The line element is another one of the most basic chart elements, which is positioned by at least two pairs of logical coordinates. If there are more logical coordinates, […]

Performance Test of esProc Script Execution

Sometimes we may encounter computations too complicated to be handled solely using library functions. We need to hardcode the computational logic using scripts. In that case the interpretative and executional performance of the script becomes really important. Not a few traditional database tasks, being unable to be expressed directly in SQL, require stored procedure to […]

Importing Excel Data into Access with esProc

In daily work we have frequent use of text data or spreadsheets. We need to import data into database for further statistical analytics. For this task, esProc is a very handy tool. In the following example, we will import Excel data into an Access database, to demonstrate how to migrate text data into database with […]

esProc Charts: The Axis Element

In esProc Charts: Coordinate Axes, we learned the basic usages of different coordinate axes and the setting of their properties. Once a logical axis is properly defined, the logical coordinates on it can be transformed into corresponding physical coordinates, according to which a certain chart element can be plotted.  Besides the logical axis, esProc handles […]

Group MongoDB Collection and Find Top N members in esProc

Problem source:!topic/mongodb-user/Rjv6lyUCe1s . Collection last3 has two fields: variable and timestamp. You need to first group documents by variable and find from each group the top 3 ones with the latest timestamp, and then find from the three documents the one with the earliest timestamp. Below is the selection from last3: esProc code:   A […]

esProc Assists Java in Merging Text Files to Excel

Problem source: .  In this case, you need to merge data from all text files in a given directory and export it to an Excel file. Each of these text files has tab-seperated data with one row and three columns.  JAVA approaches the problem by running a loop to retrieve all files in the directory and […]

Find Differences between Text Files with esProc

Problem source: .  Compare the following two text files of the same format and write the differences (different records) into a text file. Content of 1.txt: Proto      Local Address Foreign Address     State TCP       ESTABLISHED   Content of 2.txt: Proto      Local Address Foreign Address     State TCP       ESTABLISHED TCP     ESTABLISHED   Content […]

esProc Charts: The Dot Element

We talked about different types of coordinate axis used in esProc in esProc Charts: Coordinate Axes and learned that a chart element can be plotted on the coordinate plane after defining a pair of axes. From this article, we’ll discuss how to plot a chart according to specified position starting from the simplest dot element. […]

esProc Charts: Coordinate Axes

In esProc Charts: Coordinate Systems and Coordinate Transformation, we discussed the relation between logical axes and physical axes in plotting a chart with esProc, as well as how to position an axis and a chart element on the canvas. esProc provides a variety of logical axes for plotting different styles of charts. Logical axes of […]

Combine Text Files Conditionally with esProc

Problem source: . There are multiple text files in a single directory which need to be combined according to specified conditions. The text files include, for example, 12345.txt, 12346.txt, 12347.txt, 2013070312345.txt, 2013070312346.txt, 2013070312347.txt and 2013070412347.txt. The combination result is shown by the following figure:  That is, you need to combine files with the same last […]

replica franck-muller watches  replica hublot watches  replica panerai watches  replica bvlgari watches  replica patek-philippe watches  replica montblanc watches  replica longines watches  replica hermes watches  replica audemars piguet watches  replica vacheron constantin watches