|
You can use MS Excel to build your own formulas, macros, charts, etc. These Excel documents need to be fed by the data. The easiest and most common way is by exporting the Agritec reports to Excel, then copy and paste the data to your Excel document. This procedure however has some inconveniences: it is tedious, sometimes you need to re-arrange the data, and it is limited to 65536 rows. The other way is to analyze the Agritec report consult to discover the columns and the view used and then to apply them to Excel Query to retrieve the data directly to your Excel document, without inter-medium steps.
|