On the desktop: Reports, Excel export and import

Sign in at sapspyapp.com/log for the same log on a bigger screen, plus the things that are easier with a keyboard: reports across every season, an Excel export, and an Excel import.

1. Deliveries: log and edit loads. Click a load to open it.
2. Sources: suppliers and your woods. Click one to edit it.
3. Barrels: pack, print, sell, move, edit.
4. Reports: trends, export, import.
5. Settings.

Loads and barrels#

Click any load to open it. Everything about it can be changed in one place, and it can be marked paid, printed, voided or deleted.

1. When, site, gallons, Brix and the rest.
2. Mark paid.
3. Save changes.

The Supplier filter above the loads shows one supplier at a time, with what is owed in the Paid column.

Barrels work the same way: click one to change it, print its label, move it, sell it, or remove it.

Reports and Trends#

1. Show: sap gallons, syrup packed, loads, value, average Brix or gallons per tap.
2. Split by: source, site, own or bought, or grade for syrup.
3. Each bar is a: season, month, week or day. Click a bar to open it; Reset view goes back to every season.
4. Export to Excel.
5. Import from Excel.

Export to Excel#

One workbook, every season: a Summary tab with a row per season, Sap loads, Barrels and Suppliers. Each tab is a table with filters and a totals row that follows the filters.

Import from Excel#

Use the import to bring in past seasons, to enter a stack of barrels at once, or to change many rows at once.

1. Download the template. It has a Sap loads sheet and a Barrels sheet, with your suppliers, sites and grades as drop-downs, and a How to sheet.
2. Choose your file once it is filled in. Any season works; each row goes into the season of its date.

Nothing is saved until you approve. Every row is shown first with what will happen to it.

1. A name the Log does not know is asked about: add it as a new supplier, or say which supplier it is. The answer holds for every row with that name.
2. Can't import rows say why, in plain words. Fix the row in the file and upload again, or leave it out.
3. Import goes live once every name is answered.

Every import can be undone for a week, from the same window.

To change many rows at once: export, change the rows in Excel, and upload the export. Rows that already exist show what changed, and each one can be updated or left as it is.

FAQs