Short-time Working Allowance Calculation

An Excel file that teaches how to perform Short-time Working Allowance Calculation operation.

Excel Template for Short-Time Working Allowance Calculation

Gross wages and number of days are entered into the table. The effect of missing days is modeled using formulas. Ceiling and floor controls are applied automatically. Net payment amounts are summarized item by item. The report page is formatted for sharing.

Hope it is useful.