Fill tsc jd lithan ccp

Fill the JD column on a Lithan CCP TSC Scoping Matrix

What this is

A CCP TSC Scoping Matrix is the SkillsFuture Career Conversion Programme (CCP) scoping workbook used with Lithan. Each sheet is one job role. Each sheet holds a table of TSCs (Technical Skills & Competencies) drawn from the Skills Framework, one skill per row.

Column layout (positions are stable; the header row number varies per sheet, so always locate columns by header text — the helper script does this):

Col	Header	Meaning
B	Technical Skills & Competencies	Skill name
C	Proficiency Level Attained	Level 1–6
D	Objectives	The framework objective for that skill
E	To be included in training plan?	Yes / No
F	Job responsibilities (aligned with JD)	← the JD column this skill fills
G	Specify tools and technologies	e.g. Salesforce, PowerBI
H	Number of training hours	e.g. 32
I	Mode of delivery	e.g. OJT

The task: for each skill row, write one line in Column F describing the job responsibility for that skill, aligned with the skill's Objective (Column D) and the specific job role, in the same style as a sheet that is already filled in.

Workflow

1. Locate the workbook and confirm the sheet

Files live under Tertiary Infotech/CCP/<Person Name>/ and are named like CCP TSC Scoping Matrix LOO6*.xlsx. Find it, then list sheets:

python3 scripts/tsc_jd.py sheets "<file.xlsx>"

Confirm with the user which sheet (job role) to fill if not stated.

2. Read the target sheet's objectives + an already-filled reference sheet

python3 scripts/tsc_jd.py read "<file.xlsx>" "<target sheet>"     # rows to fill
python3 scripts/tsc_jd.py read "<file.xlsx>" "<filled sheet>"     # style reference

read returns JSON per skill row: row, skill, proficiency, include (E), objective (D), tools (G), jd_current (F). Use it to:

• get the Objective text each JD line must align with,
• copy the one-line style from a sheet that already has Column F populated (in this client's files, "3.3 Software Eng Manager" is a good reference).

If the user names no reference sheet, pick any sheet in the same workbook whose jd_current values are already filled.

3. Write one JD line per skill row

Read references/jd_style.md before writing. In short: one sentence, starts with an action verb, restates the skill's Objective as a concrete responsibility for this role and the organisation's context, and stays consistent with sibling lines.

Only fill rows where Column E (include) is "Yes", unless the user says fill all. Skip rows already populated unless asked to overwrite.

Build a JSON map of {row: "JD text"} and apply it (formatting is auto-copied from each row's Objectives cell so font/wrap/alignment match):

python3 scripts/tsc_jd.py write "<file.xlsx>" "<target sheet>" '{"9":"...","10":"..."}'
# or, for many rows, write the map to a file and pass it with @:
python3 scripts/tsc_jd.py write "<file.xlsx>" "<target sheet>" @/tmp/jd_map.json

write saves the file and runs the xlsx skill's recalc.py to confirm zero formula errors. Verify the recalc line reports no errors.

4. Verify

Re-run read on the target sheet and confirm every intended row now has a JD line that reads naturally and aligns with its Objective.

Notes

• Do not touch columns B–E, the header rows, or the Mentor Assessment section at the bottom — the script already excludes them.
• These workbooks contain no formulas in the skills table; recalc is a safety check.
• The matched formatting is Calibri 12, wrapped, vertically centred (inherited from the Objectives cell). Don't override it.