Skip to content
Testaroo

Trades Property · Synthetic business data

Pine Property Services

Six fictional properties with estimates, scheduled/completed work orders, maintenance checks and reconciled job costs.

ZIP with instructions and SHA-256 checksums. Files stay in your browser.

Create from this data

Choose a starting template, then follow its table and field mapping. Studio imports add a table to your project; they do not automatically replace the template’s sample content.

Guided source import

Inspect and edit the source data

Source table: job_costs in the linked operating model.

work_order_id
work_order_id
labor_hours
labor_hours
labor_rate
labor_rate
materials
materials
total
total
  1. Open the linked operating model in the text and data editor. Find tables.job_costs.rows to inspect the records and exact field names.
  2. Keep identifiers as quoted text, retain the other tables and compare edits with the linked schema and expected results. Save a local copy before changing records.
Open text and data editorDownload source JSON

Guided source import

Job cost review

Source table: job_costs in the linked operating model.

work_order_id
work_order_id
labor_hours
labor_hours
labor_rate
labor_rate
materials
materials
total
total
  1. Download operating-model.json, then open this Document Studio template. Choose Import business data, select the JSON file, choose job_costs in Business data table and click Use table.
  2. The import appends a new typed table with all source columns. Use the listed fields for your report, edit its heading and remove unrelated sample blocks. Transfer any values needed by the original template into its fields explicitly; imported records do not replace or bind its sample line items.
  3. Save editable source to preserve the document project. Use the kit workbook in a spreadsheet application when you need its existing formulas, worksheets and chart layout.
Open Document StudioDownload source JSON

Start with blank input tables

The ZIP contains a header-only CSV for every source table. Fill the fields using the kit schema, then open the CSV in the text and data editor or import it into a Studio. Open the completed operating workbook in a spreadsheet application to retain its native worksheets, formulas and chart layout.

Download blank CSV templates

Start with the expected results

Read the kit guide, follow each input’s import order, then compare your output with the reconciliation checks. Planning datasets do not imply that a platform can import them.

Platform compatibility

Example data

Generic business records

Profile 2026-09-08.1 · reviewed 2026-09-08

  1. Map fields to your application schema and retain stable relationships.

Generic records are not native imports for unnamed platforms.

Inputs, templates and references

Linked operating model

Download JSON

Input · 16.8 KB · Valid

57 records across 6 linked tables; no duplicate primary keys or missing references. Estimated work=3,858.00 USD; Recorded job costs=2,838.00 USD; Work orders=12.00 records.

Operating model JSON Schema

Download JSON

Schema · 15.5 KB · Reference

Draft 2020-12 schema accepts the paired operating model. Relational rules additionally require unique keys and existing foreign references.

Numeric expected results

Download JSON

Expected Results · 2.4 KB · Reference

Exact table counts, metric formulas, 12 chart points and three negative-test outcomes. Estimated work=3,858.00 USD; Recorded job costs=2,838.00 USD; Work orders=12.00 records.

Operating report PDF

Download PDF

Reference · 63.7 KB · Valid

Three readable pages summarize the same model, chart, source tables and usage instructions. Estimated work=3,858.00 USD; Recorded job costs=2,838.00 USD; Work orders=12.00 records.

Editable operating workbook

Download XLSX

Template · 18.4 KB · Valid

Native sheets preserve 57 source records, 3 calculated headline metrics and one editable chart. Estimated work=3,858.00 USD; Recorded job costs=2,838.00 USD; Work orders=12.00 records.

Deliberately invalid tests