Drag and drop your employee allocation file, or click to browse. Only .xlsx and .xls files are accepted. The first sheet is read automatically.

Your file should contain header rows that describe the grant code dimensions, followed by one row per employee with their allocation percentages spread across columns.

After upload, tell the tool how your file is laid out:

• Number of Header Rows * — how many top rows form the column labels (1, 2, or 3). The labels across those rows are combined into a single composite header for each column (e.g. "Grant / Program / Code").
• Starting Allocation Column * — the first code/allocation column where percentages begin.
• Ending Allocation Column * — the last percentage column.

Every column between the start and end is treated as an allocation. For each percentage greater than zero, the tool creates one output row carrying the employee's identifying columns, the grant code values taken from the header rows for that column, and the percentage.

Click Process & Normalize. The tool shows how many input employees were processed and how many allocation rows were generated, plus a preview of the first 20 output rows.

The output columns include the employee's first identifying columns, one Code N column per header row (holding that header row's value for the allocation column), a Percentage column, and a Percentage x100 column.

The Percentage x100 values are adjusted so that each employee's allocations sum to exactly 100.0000 — any rounding difference is added to the largest allocation for that employee. Employees with no allocations produce a single blank row.

Click Download .xlsx to save a two-tab workbook:

• Distribution — the normalized one-row-per-allocation layout.
• Import — the same data with an HDIST marker row at the start of each employee, followed by DDIST rows for each allocation, ready for import.