Silva PerpetuaGuides

Switch from spreadsheets

Move years of tally sheets and inventory spreadsheets into the app stand by stand, so your history becomes the first points of each stand’s trend — without retyping.

For
Consultant foresters
Time
6 minutes, then about 15 minutes per stand
Where
Web app
Updated
On this page

A plan that works

  1. Set up the woodland first — client, property, compartments and stands with boundaries (Set up woodlands), and the stand’s methods (Methods & targets). Imports land on a stand.
  2. Lay out or recreate the plots with the same references your spreadsheets use (P01, P02…). Unknown references become a question; you can let the import create them.
  3. Start with your most recent inventory of one stand. Upload it with Import anything, answer the questions, check the preview, confirm.
  4. Save the mapping as a format. Earlier years with the same headers are then read the same way, without AI.
  5. Import older inventories one by one. Each dated inventory becomes a visit; tagged trees measured twice give growth, recruitment and mortality.
  6. Check Results. With three visits the trend to target gets its 90 % interval.
Web appThe preview: original cells beside converted values, with questions.
Tips from the preview
  • Say whether a column is a girth or a diameter, and its unit — the app will not guess.
  • Day/month dates that cannot be months are read correctly; ambiguous ones become a question.
  • Totals rows are left out and reported.
  • Rows with errors can be left out on confirm; fix them in the file and import them later.

Not tree tallies?

  • Deer cull returns, bird or flora records, habitat maps become datasets — context beside the results.
  • Interventions (thinnings with dates and basal area removed) can be imported or entered under Work done (Planned work).
  • Boundaries from GIS: a zipped Shapefile, KML or GeoJSON.
What it doesn’t do (yet)
  • No bulk import of a whole estate in one step: imports are per property or stand, so each can be reviewed.
  • Old visits are scored with the method versions in force on their dates; there is no back-dating of objectives other than their effective from date.
Import anythingBring in a spreadsheet, CSV, Word or PDF file, a photo of a field sheet or a map file. The app proposes how to read it, converts every value itself, shows you the result beside the original, and stores nothing until you confirm.8 minutesSet up clients, properties, compartments and standsAdd a woodland owner, their property with its boundary, the compartments and the stands you will measure — drawing boundaries on the map or importing them.15 minutes per propertyPlan a field visitCheck the stand is ready, let the layout generator propose plots with the precision to expect, accept them, and add relocation details so the crew can re-find each plot for years.10 minutes per standRead your resultsHow a stand is doing at a glance, each topic over time against its target, the trend and when it might reach the target, and the full evaluation behind every number.7 minutes