ANTE User Manual

Performance Data Load

More ▾ › Performance Settings › Data Load (on the cycle page) loads the information Performance needs from your files: theemployee's grade history and the filled CCFS workbooks (one per employee) into a cycle's sheets. Every import works in two steps: Preview shows exactly what would happen, row by row, and nothing is written until you press Apply. The files are read in your browser; Ante receives only the rows.

Info
Anyone with access can choose files and preview. Apply needs Performance configuration access; without it the page says "You can read files and preview; applying needs Performance configuration access."
Tip
Load in this order: set up Settings › Departments and the positions first, then the employees' grades, then the CCFS workbooks — each step needs the one before it.

What every import card has

Download Template
A CSV with the exact column headings and one example row (sections and employee grades; the workbooks have no template — HR uses the company's own CCFS file).
Choose file / Change file
Accepts .xlsx, .xls or .csv (workbooks: .xlsx, .xlsm, .xls). Ante then says how many rows it read and which columns it ignored. It stops with "Missing columns" when a required column is absent, or "The file has no data rows".
Preview
Checks every row against your live data and shows a result table. Nothing is written.
Apply (N row(s))
Writes what the preview showed. Disabled until a preview exists and at least one row can be applied. After applying, the table says what was created or updated.
Start Over
Clears the file and the preview.

Sections

There is nothing to import here any more. Performance reads its divisions, departments and sections from Settings › Departments (the one Ante tree). Each person's section comes from their position (role), and a section's head is the person who holds its top role. The card says so and has an Open Departments button.

Tip
Set up the departments and positions in Settings first; then load the employees' grades below.

Employees: grade and section

Builds each employee's grade history and places them in their section. The history is what years in grade, the selections and each employee's career history are read from. It is the company's one grade history, the same one as Job Grades, so applying needs the permission to change employee grades (the compensation permission) and authority over each employee; a row for an employee you may not change shows as a conflict. Payroll cut-offs from the earliest grade date are flagged for recomputation and grade-based allowances are updated once.

Employee No.*
The employee code. A code with no employee is shown as Not found; a code twice in the file is an error.
Job grade*
An existing job grade code.
Grade since*
The date the employee entered the grade, written YYYY-MM-DD.
Section code
An existing section code. Departments cannot be used: they follow the employee's position.
Previous grade / Previous since
Optional pair: the grade before, and when it started. Both are needed together, and Previous since must be earlier than Grade since. Ante ends that earlier grade the day before Grade since, so years in grade can be worked out.
Previous section
Optional; the section for the previous grade. Blank means the same section as now.
Replace existing history
Off (default): adds new rows; a row identical to what is stored is "already there", and a row that clashes with a different stored assignment shows as a conflict. On: deletes this person's history and rebuilds it from the file.
What each row produces
Row in the fileStatusAssignments created / message
EMP-0001 · GS2 since 2025-04-01 · SEC-A · previous GS1 since 2023-04-01OKGS1 from 2023-04-01 to 2025-03-31, then GS2 from 2025-04-01 (to date), both in SEC-A
EMP-9999 (no such employee)Not foundNo employee with code "EMP-9999"
EMP-0002 · ZZ9ErrorUnknown job grade "ZZ9"
EMP-0003 · grade since 01/04/2025ErrorGrade since "01/04/2025" is not a date (use YYYY-MM-DD)
EMP-0004 · section DEP-1Error"DEP-1" is a department — departments follow the employee's position; use a section code
EMP-0005 · GS2 since 2025-04-01 (already has GS1 from 2024-04-01), Replace offConflictOverlaps the existing assignment (GS1 in SEC-A from 2024-04-01); switch on "Replace history" to rebuild it
The same, Replace onOKExisting history will be replaced

CCFS workbooks

Loads your filled CCFS workbooks into the employees' sheets of a cycle: targets and their importance, half-year texts, section policy, remaining issues, advice from the manager, significant works and the ratings. The browser reads each workbook with the import profile (the map of which cell holds what), then Preview shows, per file, who it matched and what would be written.

Cycle*
Only open and draft cycles are offered; with none, "No open or draft cycle — create one on the Cycles page first."
Choose workbooks
One or many files, one per employee.
Agree on apply
Tick the stages to mark agreed on every imported sheet; each agreed stage gets a version "Imported from <file>". Target setting is always offered; 1st half only when first-half texts exist in the files; 2nd half and Evaluation only when ratings exist. A stage after the cycle's current one is disabled, and stages are agreed only in order (a later stage is not agreed while an earlier one is not), and Evaluation only when its required answers are there. Stages are agreed only on an open cycle.
Overwrite existing values
Off (default): only empty fields on the sheet are written. On: every field read replaces the sheet's value. A field with nothing in the file never clears anything.
Re-agree stages that are already agreed
Off: cells of an already-agreed stage are skipped. On: they are written and the stage gets a new version.
Add missing employees to the cycle
On by default: an employee with no sheet in the cycle is added when their job grade takes a CCFS.
Import Profile
Opens the cell map (sheet name, header cells, text blocks, each target's cells, significant works columns, SMART labels, importance words and Final Result markers). Changing it re-reads the files; Save to Form keeps it on the cycle's evaluation form, Reset to the Standard Cells returns to the standard cells and Discard Changes drops edits.

The first table, What the files hold, shows each file's employee, the year written on the workbook, how many targets it has, whether first-half texts and ratings exist, and warnings. The preview table then shows:

File / Employee
The workbook and the employee it was matched to (by employee number; by name only when the number is missing or unknown, with a warning).
Match
Matched, Will be added (to the cycle), Added, or Not found.
Fields
How many fields will be written, and how many were skipped.
Stages
The stages this import will agree.
Warnings
Anything unusual about the file.
What the Overwrite switch does (one field, existing advice from the manager)
OverwriteSheet has “Existing advice”, file has “Imported advice”Sheet field is empty, file has “Imported issue”
OffKept: “Existing advice” (listed as skipped)Written: “Imported issue”
OnReplaced by “Imported advice”Written: “Imported issue”
Off or On, stage already agreedSkipped “(stage agreed)” unless Re-agree is onSkipped “(stage agreed)” unless Re-agree is on

What is skipped or warned

Cases Preview reports
SituationResult
The employee is withdrawn from the cycleWarning “…was withdrawn from this cycle — undo the withdrawal first; this workbook is skipped”. Nothing is written and they are not re-added.
No employee matches the number or nameNot found; no sheet is touched
Two employees share the name and the sheet has no numberWarning “Several employees are named …”; add the employee code to the sheet
The file is the importing HR user’s own CCFSWarning: another HR user imports it
Two workbooks for the same employee in one importOnly the first is used; the other gets a warning
The employee is not in the cycle and Add missing is off, or has no job grade, or the grade does not take a CCFSWarning saying which; no sheet is created
The year on the workbook is neither the review period’s start year nor its end year (“FY2024” on a cycle reviewing Apr 1, 2026 – Mar 31, 2027)Warning only; the file is still imported
An importance word the form does not haveWarning; that importance is left empty
More targets in the workbook than the form takesWarning; the extra targets are ignored
Section policy not on the company’s Section Policies listWarning; not imported
A question the section already answers for everyoneSkipped “(shared by the section)”; set it on the Section set-up page
Example: importing 5 workbooks into the Apr 2026 – Mar 2027 evaluation cycle
Files read5
Employee 1, Employee 2, Employee 3matched, in the cycle
Employee 4withdrawn from the cycle → skipped with a warning
EMP-9999no such employee → Not found
Preview summarythe withdrawn employee still counts as matched=4 matched · 1 not found
Sheets actually written on Apply=3 (Employees 1, 2 and 3)
Read the warnings column before applying: the withdrawn employee is listed with a warning and nothing is written to their sheet.

After Apply

  1. Read the result
    The table switches from "Preview — nothing written yet" to "Result" with what was created, updated or written, and "Import applied".
  2. Fix the rows in error and import them again
    Rows that were not applied are untouched; correct the file and run Preview again.
  3. Check the cycle
    Open the cycle page to see the stage counts and the sheets (see Performance Cycles).

How It Connects

Set up first

  • Performance Cycles — the CCFS import needs an open or draft cycle with its evaluation form; the imported targets, ratings and agreed stages then appear on that cycle’s sheets.

Feeds into

  • Career Design Sheets — a round includes employees with a current assignment, and each sheet’s career history is built from the assignments loaded here.
  • Promotion — grade-since dates drive years in grade and the selection years used by the promotion counts.