🏢 SEP Automation BU — Overall Project Console
PO received → CLT completion · Design / FAT / Site stages · BU Head: Mr. Shankar
| 📌 | Project | 📐 Design | 🏭 FAT | 🚧 Site (OLT·CLT·Intlk·SAT) |
|---|
📐 Engineering Design
PO received → Production files released · Design Manager: Mr. Zeeshan
Portfolio Status Overview
Total Projects
0
in portfolio
Active
0
from latest weekly report
Inactive
0
from latest weekly report
Completed
0
from latest weekly report
Substation Technical Testing & Milestones Matrix
| Code / Project Asset | Type / Scope | Status | FAT | Open Loop | Close Loop | Interlock | Line Coloring | SAT Status |
|---|
Project Directory Management
Automation Engineering Pool
| Engineer Name | Designation | Specialization Scope | Hourly Rate | Project Assignment & Role | Last Attendance Status | Actions |
|---|
Engineer Attendance Sheet
Daily or weekly attendance — Site, Office (FAT / Idle / General Training), or Leave (7 types). Export monthly for salary reference.
Weekly Attendance Grid
Site → project + activity (Visit/Support/OLT/CLT/Training/Preparation) · Office → FAT (project + activity), Idle, or General Training · Leave → Short/Sick/Casual/Earned Leave, Emergency/Annual Vacation, or Others · Weekend for Friday (everyone) and Saturday (Managers) — pre-filled automatically and excluded from "Last Attendance" on the Engineer Pool, so the last real working day always shows there. All Training (Site, FAT, or General) is tallied separately as Resource Development, not counted against project hours. When you pick Office - FAT, the project list automatically narrows to projects whose FAT status is currently "Ongoing" — set that in the Weekly Logs milestone matrix. On today's column, each engineer shows their last working day as a suggestion with a one-click "↵ Apply to Today" button for fast daily entry.
Monthly Attendance Summary (for Salary Reference)
| Engineer | Site Days | Office-FAT | Office Idle | Training (Resource Dev) |
Leave (Total) | Total Logged |
|---|
Leave Type Breakdown (Selected Month)
Project Activity Breakdown
Consolidated days spent on Preparation, Internal Test, Visit, Support and Training for the selected project — useful at project closeout to see exactly where engineer time went.
Weekly Progress & Live Site Ledger Logger
Log Weekly Progress Data
Carries forward from the last update automatically — only change it if the project's status has actually changed.
Fills in automatically once you pick a project. Hours are counted from last Thursday through this Wednesday — the full reporting week.
Hours This Week (from Attendance)
Brief Weekly Status Remarks
NCR Registry Log
Milestone Status Matrix
FAT & Site T&C Hours (Cumulative, from Attendance)
Historical Sequence
Finance & Advances — Engineer Accounts
Track company advances received, distribution to engineers, bills returned, and outstanding settlements.
Received from Company
0.00 SAR
Distributed to Engineers
0.00 SAR
Bills Collected from Engineers
0.00 SAR
Bills Submitted to Finance
0.00 SAR
Expected Return from Engineers
0.00 SAR
Repayment Due to Engineers
0.00 SAR
Estimated Cash on Hand (with you)
0.00 SAR
Company advances received − distributed to engineers + amounts returned by engineers − repayments paid out
🏦 Company Ledger
🕘 Advance History
Consolidated invoices/bills your company has submitted to the client for reimbursement — separate from individual engineer bills below.
🕘 Bill Submission History
💸 Field Money Movements
Log Instant Field Expense
Includes 📐 pre-FAT and ✅ Completed projects — early-support & service visits are payable.
🕘 Recent Field Movements
🕘 Settlement History
Consolidated Balance with Company
Running reconciliation: advances received from the company against bills your company has submitted back to them.
Total Received
0.00 SAR
Total Billed
0.00 SAR
Net Balance
0.00 SAR
Engineer Accounts Ledger
Advance given vs bills returned, per engineer — net balance shows who owes whom.
| Engineer | Opening Balance | Advance Given | Bills Submitted | Settled (Net) | Outstanding Balance | Status | Action |
|---|
Consolidated Expense Report
Slice Advance / Bill / Returned / Payment totals by Engineer, Project, Month, or Year — including imported historical data.
⚠️ Remove Expense Records by Year
Permanently deletes all Advance / Bill / Returned / Payment records dated in the selected year. Other years and all other data (projects, attendance, etc.) are untouched. This cannot be undone — back up first with "Download DB" if unsure.
Browse & Delete Individual Transactions
Wrongly added an advance, bill, return, or payment? Filter it down below and remove just that one entry.
| Date | Engineer | Type | Project | Amount | Description | Action |
|---|
Executive Portfolio Intelligence Hub
Sift operational history across targeted substations, engineering pools, and custom formats.
This report only shows projects updated in the last 14 days — Active projects with no recent weekly report, and any Inactive/Completed project older than that, drop off automatically to keep the report current.
Executive Performance Report
Compiled Automation Engineering Portfolio Metrics and Fiscal Records
Section I — Consolidated Operations Table Matrix
| Set constraints and run Query Platform engine to compile consolidated records. |
SEP Automation Portfolio Data Integrity Protocol Verification Engine.
Executive Signature Validation Layer
📰 Project Feed
Project updates, achievements, and team posts — max 25 words per post.