Create an applied report

The applied report adds up what your applications put on the land: how much of each product, and how much active ingredient. You group those figures whichever way you need them — per block, per product, per active ingredient, per month, per crop. You build the table by choosing what goes down the side and what goes across the top, then take it away as a PDF or a spreadsheet.

The same report also shows what the applications cost, for the roles that may see money.

Two things decide what there is to see:

• Only confirmed applications count. An application still sitting in instruction has not been applied yet.
• Everyone on the farm can open the report, but only an Administrator, Manager or Financial Officer sees cost. For every other role the cost figures are not on offer, and they are not in the PDF or the spreadsheet either.

Open it

On the Applications page, open the Actions menu and choose Pivot table under Applied & cost report. If your role does not see money, the heading reads Applied report.

The report opens with a period already filled in: your current season, from the day it started up to today. Everything below changes only what you are looking at — nothing here changes your records.

See what went onto each block

That is the question the report opens on, so there is nothing to set up.

Down the side is Production unit and then Block; across the top is Category. Each cell shows two lines:

• Product applied — the dosage you confirmed times the block's area, in the product's own unit. A cell with two products in different units shows both, such as 6.37 ℓ / 9.68 kg.
• Ingredient applied — the active ingredient in that product, added up across all ingredients into one figure in kilograms. In the example, A1's 10.925 kg is its copper and its sulphur together. An ingredient measured by volume is added up in litres on a second line, and a biological counted in spores or CFU keeps its own unit.

To see each active ingredient on its own, add Active ingredient across the top or down the side. Each ingredient's column then shows the product that carried it, and the total still counts each product once.

To change the grouping, use the + Add… boxes in the top-left (down the side) and top-right (across the top). Each dimension you add becomes a chip: the arrows move it in or out a level, the × takes it off again.

The table on screen is a preview. It shows at most three rows and three columns, and marks the rest with ⋯ and ⋮. On a farm with forty blocks you will see three of them here. The PDF and the spreadsheet carry everything.

Ask what each block cost

The Metrics at the top of the report are a row of tick boxes, one for each figure the report can show. Tick Cost and Cost/ha, then untick Product applied and Ingredient applied. The three cost metrics are only there if your role may see money. At least one box always stays ticked: untick the last one and Product applied comes back on.

Each cell now shows the cost and the cost per hectare. A row is one block's season. In the example, A1 and A2 come to about R 596/ha each and B1 to R 839,27/ha — B1 being the only block that also had an insecticide on it, the R 1 050,00 in the second column.

Only priced receipts carry money. If nothing you received was captured with a price, every cost comes out at R 0,00. See How chemical costs are worked out.

Ask what each product cost

Take Production unit and Block off the side and add Product. Across the top, swap Category for Month. Then, under Metrics, tick Product applied and Unit cost, and untick Cost/ha.

Now each cell carries three lines: what you spent, how much product went on, and what it worked out to per kilogram or per litre. Sulfaflow WG comes to R 3 919,15 for the season, 30.01 kg of it, at R 130,64/kg.

Three things to know about the unit cost:

• It is worked out on what left the store, not on what went onto the land. The store let out 30.00 kg of Sulfaflow WG, so R 3 919,15 over 30.00 kg is R 130,64/kg. The cost includes anything spilt or left in the tank; the product applied does not.
• It can only be ticked when Product is one of the row dimensions. Anywhere else a row would mix products, and a rand-per-kilogram across two different products means nothing.
• On the Total row it prints one figure per unit — R 303,88/L and R 232,97/kg. Those are the whole cost divided by each unit's quantity, not a price. Read the unit cost off a product's own row.

Narrow it down, or widen it out

Click Filters under the table. The panel holds the period and the filters together, because they do the same job: they decide which applications the figures are worked out from.

From and To take any two dates. The rest narrow by category, production unit, block, crop or cultivar, and you can pick more than one of each. The Block list holds the blocks this report has figures for, not every block on the farm — change the period and the list follows it.

Widen From back past the start of the season and last season's applications join the report — another month appears across the top, and Sulfaflow WG's unit cost moves from R 130,64/kg to R 130,00/kg.

That drop is not a rounding error and neither figure is wrong. The cost per unit is an average worked out over the period you asked for, so a different period is a different average — which is why every export prints the period on it. How chemical costs are worked out explains what goes into that average.

Take it away

Two buttons at the bottom of the report:

• Download PDF — the table exactly as you built it, with every row and column, and the period and filters printed on it. This is the one to send to someone.
• Download Excel — one flat sheet named Data, a row per figure, with each dimension in its own column. It is not a pivot table; it is what you build your own pivot on, so it ignores the rows and columns you chose here and gives you the lot. A product with two active ingredients takes two rows, one per ingredient, and its product quantity — and its cost — sits on the first of them only, so adding up a column counts each product once.

Both open in a new tab and both are named for the farm and today's date.

When there is nothing to see

• "No data found for the selected filters." Nothing confirmed falls in the period, or a filter has excluded everything. Widen the period first.
• Ingredient applied shows a dash. The product has no active ingredient on record, or its concentration cannot be turned into an amount — a weight per weight on a product measured in litres needs the product's specific gravity.
• Everything costs R 0,00. The applications are there but the money is not: the chemical has no receipt with a price on it, in the period or before it. Put the prices on the receipts and run the report again — nothing needs to be recaptured, because no cost is ever stored.