Report Desk

Calculate and format CSV reports

Data file · none

Delimiter Columns Line endings

Drop a data file or choose a file · CSV TSV PNEZD DAT TXT Drop a .rpt here to load a template

Change log · 0

Template · Staking report

Report scope

Columns, calculations, and an edit to try

{Col|2} two decimals · {Col} value · {Col|upper} |abs |trim · {Col|neg:LT|pos:RT} · {=N*0.3048} math · trailing %d3 %+d2 %sta %dms %z4 %k2

Calculation functions

Insert an example expression

Survey functions use northing/easting and bearings or azimuths. next() reads the next row; Adjacent pairs omits the final unpaired point. Totals and joinRows() use the entire file or current group, including rows beyond the preview limit.

sum() accepts a column or expression and an optional condition. sumIf() matches a category without case sensitivity. first(), last(), field(), lookup(), and group() expose values and group labels. Add numeric formats after the expression, such as {=sum("Amount")} %k2.

Live preview · no rows

Show

Example	Inputs and results
Original staking and supplied standard staking	PNEZD coordinates and elevations with editable formatting
Supplied full staking	PNEZD plus Station and Offset; station formatting and LT/RT labels
Supplied control	Six columns A–F; designation, point number, coordinates, elevation, and notes with legacy precision
Consecutive-point inverse	Ordinary point CSV; computed bearings, distances, and coordinate differences
Inverse by point ID	The same point CSV; edit two point IDs in the template to choose endpoints
Area from coordinates	Four actual boundary vertices; computes 120000 square units and perimeter 1400
Coordinate closure	Known start and measured end; computes endpoint gap and relative precision
Closure from bearings/distances	Four actual course rows; computes components, endpoint, misclosure, and precision
Coordinates from bearings/distances	The same courses; computes cumulative northing/easting for every destination
Circular curves	Radius and delta; computes arc, chord, and tangent
P&L from Amount	Transaction dates, categories, and amounts; monthly September net profit 1800 and October 2900
P&L from Debit/Credit	Ledger entries; derives the same monthly P&L from debit and credit expressions
Invoice summary	Line items grouped by invoice; calculates each extension and subtotal
Project hours	Time entries grouped by project; calculates hours, billing, and weighted rate

Report Desk

Data file · none

Template · Staking report

Live preview · no rows

Value

Find / replace in column