PARADIGM MANHOUR CENTRAL - 09 NOVEMBER 2026

AVAILABLE FTE AND HOURS
Available FTE = 0.9 x sum of productivity indices.
Manhour capacity = Available FTE x 8 x working days.
Required manhours = planned - delay + modifications.
Required FTE = required manhours / (8 x working days).
Planned FTE = planned manhours / (8 x working days).
Balance FTE = Available FTE - Required FTE, including negative values, highlighted light red.
The graphs and reports use the same calculations. Zero working days returns
zero for division-based FTE measures; Available FTE still uses productivity.

ARCH / CAD-SOS / SHEJINA
Arch appears with Design, CAD, Rebar and Steel in graphs, summaries, project
categories, Balance FTE and exports. CAD-RRN and CAD-SOS are classified as Arch.
New CAD-SOS project inputs default to CAD, as requested; employee inputs default to Arch. The automatic upgrade transfers Shejina O S's
current/future productivity to CAD-SOS while keeping prior weeks in her original
team. See UPDATE_EXISTING.txt for migration details.

RESPONSIBLE PERSONS
Project manhours now displays Responsible person as a table column.
Open Field lists, choose Responsible persons and select the team. Team editors
and management can add a name, paste/upload several names, or delete a name.
CSV/TXT/TSV uploads use a single column without a heading. Uploads add names to
existing team names; they do not replace the list. Team project dropdowns use
that team's list. Names already saved in project records remain visible.

FIELD-LIST DELETION
Management can delete items from any Field dropdown list. Team editors can
manage their responsible-person list. Delete removes the option from future
choices; existing input values and calculations are preserved. Retired project
categories still appear in historical reports. Status effects are kept for
existing rows. Existing saved choices may be retained while editing those rows.

EXCEL PASTE
Each row editor has exactly one Paste weekly values section. Project editors
also have one Paste project details and weekly hours section. Opening Add line
or another row resets that editor's paste controls without creating duplicates.
Select From/To week (13-week default), paste, Apply to form, review, then Save.
Only editable weeks in the selected range are pasted. Older weekly cells remain
locked. Last week, current week and future weeks remain editable.

Project details paste order, without headings:
Project | Client | Project category | Structure | Work type | Software |
Status | Responsible person | selected weekly values...
Copy the cells from Excel; do not type the | separators.
Blank weekly cells become zero; offscreen weeks stay unchanged.

Productivity index supports weekly-row paste and Paste team productivity column.
The column preview shows every active employee in the team and its mapped value.
The value repeats across selected weeks. The entire batch saves atomically;
if any row was edited concurrently, no part of that batch overwrites others.

HIDE - HISTORY IS KEPT
Actions > Hide opens a First excluded week choice. The default is next week,
so the current week and earlier weeks remain valid. Reports, graphs, selected
project totals, Balance FTE, drawing calculations and software outputs include
all weeks before the cutoff. Values on/after the cutoff are excluded but retained.
Show hidden rows to find a row; Unhide restores its saved future contributions.
A hidden row can remain visible when your displayed range includes valid history.
Delete is a separate whole-row removal and should not be used to stop future work.

MOVE
Choose destination team and From/To week. Only selected editable weeks transfer;
other weeks stay in the source. Work type stays unchanged unless edited separately.
The source and destination save together, with revision conflict protection.

SELECTED PROJECTS
Open Selected projects. Choose All work types or Design/CAD/Rebar/Steel/Arch,
and optionally a client-category filter. Select multiple projects.
Switch Required manhours / Required FTE. Every selected project has a separate
bar colour, plus an orange Total selected projects series. Values are weekly.
Projects are identified by client + project name, ignoring case/outer spaces.
All planned, delay and modification rows for that project are combined, including
rows in different teams. Different clients with the same project name stay separate.
View chart values opens the data table. Export selected projects downloads the
currently selected project's values and total. Main Excel export continues to
export the standard summaries and team inputs.

SWECO GRAPHS
Graphs - Sweco has Manhours / FTE and Drawings tabs.
SWECO manhour/FTE charts contain only Available and Required series.
Other graph tabs retain Planned. The series colours are consistent everywhere:
  Available / Possible: blue
  Planned: teal
  Required / selected-project total: orange
Individual selected projects use distinct colours, consistent across project views.

SWECO DRAWINGS
Enter manhours per drawing separately for CAD, Rebar, Steel and Arch. No rates
are assumed. Charts appear once a positive rate is entered. Unsaved edits provide
a preview; Save drawing rates shares the rates across the office. Conflicting
settings saves are rejected. Use saved rates discards local rate edits.
Required drawings = SWECO required manhours / work-type manhours per drawing.
Choose multiple project categories per work type. Required drawings stack in
one narrow bar each week in distinct colours, with the total above the stack.
There is no Possible drawings line or separate total bar in these charts.
Drawing estimates may be fractional; net negative hours retain their sign.
View chart values and Export drawings provide the corresponding numbers.

RANGES AND DISPLAY
From/To week and Number of weeks control outputs; default 13 weeks.
Table headings stay visible inside the vertical table scroll area. The horizontal
scrollbar is above the headings. Notes remain on Field rather than printed reports.
The two project total columns cover all available weeks, split at current week.
Filtered subtotals deduct Delay and include valid history before Hide cutoffs.

SAVED DATA
Update the existing host folder using UPDATE_EXISTING.txt. Never replace the data
folder with this package or import seed data over live entries. Everyone continues
to use the same browser address, shared database, backups and conflict protection.

04 NOVEMBER CATEGORY UPDATE
SWECO > Drawings now selects project categories rather than projects. Choose
multiple categories per work type. Their required drawings stack in one bar
per week with a net total above it. There is no possible-drawings line.
SWECO > Manhours / FTE lets you select multiple categories for required work;
available capacity appears as a line only with Select all categories. Select all
or clear the checkboxes as needed. Excel export includes the selected result.
Balance FTE > Team-wise shows signed available-minus-required FTE by team.
Use the client category filter for SWECO, Enigmatix or Others, or all categories.

06 NOVEMBER TEAM UPDATE
- Select a team explicitly, then Set as my default team. This is browser-specific.
- Team inputs: enable Mark cells checked, then click a current/previous-week
  value to manually mark/unmark it. Green indicates checked. No reviewer name
  is displayed on the check. Disable that mode to edit values normally.
  Editing the checked value or calculation details clears the obsolete check.
- Productivity index: Sort names A-Z saves the order for the team. Each row's
  Actions menu also offers Move name up/down. Ordering includes hidden rows;
  clear filters/show hidden if an adjacent row is not visible. Paste employee
  values follows the saved order shown in its preview.
- New Rebar projects: Rebar / SWECO / Strakon (including DES-RPM).
- New CAD and Arch-team projects: CAD / SWECO / AutoCAD, as requested.
- New Steel projects: Steel / CaddAlta / Tekla.
- New Design projects: Design / SWECO / Plaxis.
  Defaults are editable; existing rows and copied additional lines keep values.
- SWECO graphs: Select all categories shows available capacity/FTE as a line.
  Custom category selections show required bars only, and selected category
  names appear above each work-type graph. Other graph tabs are unchanged.
- Team capacity: Table, FTE and Manhours tabs. Each team graph has available
  values as a line only with All categories, and required values as bars. Balance FTE is the table
  row after Employee count. The existing team-wise Balance FTE tab remains available.
- Current-week headings are highlighted in tables and Excel exports.
- Stacked drawing bars are one-third their former width and use the original bright category palette. Totals remain above the bars.

09 NOVEMBER PLANNING UPDATE
- Preferred team: Team inputs > select team > Set as my default team. Field
  lists opens the same team. The preference is saved per browser.
- Employee order: Sort names A-Z or use the visible up/down arrow buttons.
  The saved order is shared with the team. Clear filters/show hidden rows to
  see adjacent employees when rearranging; paste previews follow this order.
- Team Capacity first row: Employee count = distinct names per team/week with at least one nonzero
  productivity entry. Matching ignores case and extra spaces. Hide cutoffs apply. The FTE graph shows count
  as a green line only for All categories, alongside blue Available FTE and
  orange Required FTE bars. Manhours uses blue capacity and orange required.
  Specific client categories show required bars only in both graph tabs.
- Negative Balance FTE remains visible with a light bright red background and
  dark readable text in Team Capacity and both Balance FTE views/Excel exports.
- Expected projects: choose Expected · Design/CAD/Rebar/Steel/Arch under Team
  inputs. Enter projects using normal client/project categories and weekly
  hours. These teams have project inputs only, not employee capacity. Hours
  contribute to the corresponding work type, client/project summaries, FTE,
  graphs, drawings and team/combined totals.
- On confirmation choose Actions > Move to team, then the actual team. All
  rows with the same project, client, project category and work type transfer
  together, including planned/delay/modifications and historical weeks. Their
  IDs, details, hours and links are retained. Nothing is duplicated. Hidden
  cutoffs remain in force. Concurrent changes reject the entire transfer.
  Responsible names already on a row remain; add them in the destination
  team's Field list if they should be available for new rows too.
- A supplied Paradigm logo replaces the placeholder brand mark.
- GoDaddy PHP/MySQL conversion is deferred until approval of this app update.

COUNT AND LAYOUT CORRECTION - 09 NOVEMBER
Repeated employee names count once per team/week when at least one active row
has a nonzero productivity index. Case and extra spaces are ignored. Zero-only
and hidden/excluded entries do not count. Total count sums the team counts;
a person working in two teams is counted once in each team. FTE/productivity
sums are unchanged. This applies to Team Capacity tables, graphs and exports.
Actions controls occupy a dedicated aligned column. Up/down arrows are teal
with transparent backgrounds; employee order remains saved centrally.

OUTPUT LOGO UPDATE: Paradigm logo appears in every report header, each chart
header, Print / Save as PDF output, and every exported Excel worksheet.
Excel sheets reserve the first row for the logo and sheet title; existing
values and formats are retained and the table header stays frozen below it.
