04 / PERSON-CENTRED SOFTWARE · TRANSFERABLE WORKFLOW

From an Excel log to an interactive application.

The starting point was simple: one person used a spreadsheet to record activities. I developed a more practical web-based workflow with structured entry, protected data and useful reports. The same engineering pattern can support an office.

Real starting problemPersonal spreadsheet-based record keeping
Implemented applicationGoogle OAuth · Apps Script · private Google Sheet
Practical resultOrganised entries · weekly summaries · exports

THE PROBLEM AND THE OPPORTUNITY

A spreadsheet is a starting point, not always the best interface.

Excel is valuable for tabular records, but a growing collection of activities can be difficult to explore consistently. A purpose-built interface can display relevant fields, support controlled entry and produce understandable summaries without forcing a user to navigate raw rows.

01 /

Before: spreadsheet entry

Dates, activities and results are recorded in cells. The person must interpret the layout and keep the structure consistent.

02 /

Engineering transformation

The data is modelled as records, with validation, an interface, access rules and reporting separated from the underlying spreadsheet.

03 /

After: usable information

A user can navigate records, inspect a selected item, review weekly totals and generate outputs through a dedicated application.

INTERACTIVE / FICTIONAL OFFICE EXAMPLE

See the difference.

This small demonstration uses invented office activities to illustrate how structured rows can become a more usable web experience. It does not connect to MyReintegration, load a real Excel workbook or write to a private spreadsheet.

SOURCE / SPREADSHEET VIEWSAMPLE RECORDS · NO PERSONAL DATA
Starting with rows and columns

A sheet is a good storage format, but an interface designed around the work helps a person find and act on information.

No imported files, real people or persistent data in this example.

THE ACTUAL SOFTWARE ENGINEERING

What MyReintegration really implements.

The original application is a private activity and application journal, not a generic office document-management package. Its implementation demonstrates reusable engineering methods.

01

Structured entry

Responsive forms capture activity descriptions, dates, status, duration and results. Records can be reviewed and edited by authorized users.

02

Private data connection

Google OAuth and an Apps Script API connect the interface to a private spreadsheet with service-side access controls and revision checks.

03

Reporting & portability

Weekly views and reports support Excel, PDF, CSV, JSON and editable email drafts. Exports preserve useful structured information.

04

Recovery & consistency

Draft recovery, guarded retries, backups and conflict detection help avoid losing work when connections are interrupted.

Portfolio scope: the office dataset above is hypothetical. The real MyReintegration app solves an individual record-keeping need. Adapting this approach to another organization would require its actual document types, permissions, retention rules and workflows. No automatic Excel-to-app conversion or production document storage is claimed.