Telecoms Design Tracker

Activity History

All changes you have made

Supplier Lead Times

Used to auto-calculate forecast dates when a PO or order is detected in comments

Supplier	Service / Dep type	Days

💡 All lead times are in working days (weekends excluded). Applied automatically when a comment contains a PO/order referencing the supplier name. Changes save instantly.

Project Info

Reference guide — data sources, status logic, dependency detection, and key behaviours

What it is

Standalone single-file HTML tracker for Cornerstone Beacon 4 A&D. Tracks 848 sites through the GA → DD design workflow with dependency management, action dates, and comment logging. No server — all data stored in localStorage key tdv3. Bumping VER reseeds from embedded JSON.

Data Sources (Beacon 4 DesignFlow exports — sheet: Milestones)

1 · Design Tracker

848 rows × 168 cols. Key cols: CTIL ID, VF ID, Site type, DG160 GA Client Approved Actual/Remarks, DD140 DD Client Approved Actual/Forecast/Remarks, DD020 DD Status Remarks, DP380 Site Design Review Status Forecast/Remarks, DD040 DD Comment Remarks

2 · Outstanding Deps

177 rows. Key cols: VF ID, Site name, DD040 DD Comment Remarks, DP390 Site Design Review Comments Remarks, DP380 Site Design Review Status Remarks/Forecast

3 · Dependency Management

848 rows. Formal dep fields DP700–DP1010 (Structural Calcs, Foundation Calcs, GDC, Trial Hole, GPR, Structural Survey). Also DP380 status.

Site Status Logic (derived — not stored in DesignFlow)

Complete DP380 Remarks = "Complete" — OR — DD140 Actual has date AND DD140 Remarks = "Approved" — OR — DD020 = "Complete" — unless latest comment contains amendment/rework keywords

In Progress DG160 Remarks = "Approved" or "STRAIGHT TO DD" (GA truly approved) — OR — DP380 = "Required" / "Failed"

Not Started Neither of the above

DD140 Remarks values meaning NOT approved: CS FC Date · CS FC Date-DC280 · Review · CR OUT LIST · CR OUT-ICSS · CS REJECTION · REJECTED-DTR

Dependency Detection

Deps are detected from DD040 comment text — not formal DesignFlow dep fields (which lag). DP390 sets which deps are required (comma-separated).

Dep types: Structural Calcs · LoC · GDC Lvl 1 · GDC Lvl 2 · GDC Lvl 3 · Foundation Calcs · Structural Survey · Trial Hole · Base Depth Check · GPR Scan · DNO Quote · Other

Rooftop
GPR Scan (Roof)
structural/slab investigation

Streetworks
GPR Scan (Services)
locate services before/after trial hole

Greenfield
GPR Scan (Ground)

Key Behaviours

▸Next Action date = DP380 Site Design Review Status Forecast — the date next action is needed

▸GA truly approved = DG160 Actual has a date AND DG160 Remarks = "Approved" or "STRAIGHT TO DD" — this is when deps start being ordered

▸Auto FC — Trylon structural calcs = comment matches "PO raised/sent + Trylon + structural/calcs" (not foundation, not survey) → FC = comment date + 6 working days

▸Copy to SiteLive — modal after posting comment or marking dep done; user comments newest first, then Excel history below

▸Import modes — "Add/update only" skips duplicates by CTIL/VF ID; "Replace all" replaces everything (with confirmation)

▸Marking dep done — auto-adds comment "DD.MM - [Dep name] complete" and opens copy modal

▸Site type normalisation — GF/Greenfield → Greenfield · RT/Rooftop → Rooftop · SW/Streetworks/Streetwork → Streetworks

Suppliers & Default Lead Times (working days)

Supplier	Service	WD
Trylon	Structural Calcs	6
Trylon	Foundation Calcs	6
Trylon	Structural Survey	10
Swann	Structural Calcs	10
Swann	Foundation Calcs	10
Swann	GDC Lvl 2	10
Hutchinson	Structural Survey	20
Hutchinson	Structural Calcs	20
CU Phosco	GDC Lvl 2	14
KK	Trial Hole	14
Ground Up Solutions	Trial Hole	7
UDS Surveyors	GPR Scan	7
Circet	GDC Lvl 2	14
Circet	Foundation Calcs	14

Live lead times are editable on the Lead Times tab — the values above are the seeded defaults.

No sites found

No sites

No sites