Johnsons Hotel Linen – Reliability Portal (Grouped)

Carl Whelan – EngTech [Shift Engineer]

1) Select Area & Asset

Photos save to Drive and the sheet row contains links.

2) Component Readings

ΔT auto-calculates as Surface − Ambient. Status drives colour coding.

3) Submit to Spreadsheet

Data posts securely via HTTPS as multipart form-data. Photos are uploaded along with readings.

Setup Notes

  1. Edit the CONFIG block (inside this file) to tweak component lists for each asset.
  2. Deploy the Google Apps Script in the companion file, then paste the Web App URL above.
  3. On first submission, the backend creates Drive folders, a per-asset data tab, and a Dashboard with charts & STDEV.