How is the request deadline calculated?

The target deadline equals the registration date and time plus the priority time in hours. You set the times yourself on the Lists sheet.

Are the hours calendar or working hours?

Calendar hours: nights and weekends count too. If you need working time, set longer priority times.

How do I close a request?

Choose the status “Closed” and enter the closing date and time: the resolution time and a mark “on time” or “late” are calculated.

What does “due soon” mean?

No more than the set number of hours remain before the target deadline (4 by default). You can change the value in Lists.

← All templates

Request and Task Log — Excel Template

A request log with priorities and deadlines in hours, statuses, an overdue traffic light, average resolution time and share closed on time.

390 ₽

≈ 4 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Requests in chats and on scraps of paper get lost, and a manager cannot see who is late with what. Here each request is entered as a row: the target deadline is calculated from the priority, the traffic light shows overdue and “due soon” items, and the summary gives assignee workload, average resolution time and the share closed on time.

What is inside

“Lists”: priorities with deadlines in hours, assignees, departments, the “due soon” setting.
“Requests”: up to 1000 requests — registration, requester, department, subject, priority, assignee, status, closing, resolution time, overdue time and traffic light.
“Summary”: requests by status, assignee and priority, average resolution time, share closed on time, two charts.

Who it suits

Managers and staff of technical support, facilities, IT departments, service and property management companies, and small teams that receive requests from employees or customers.

Compatibility

Excel 2007 and newer, LibreOffice. No macros. The file is in English. Priority times and thresholds are set in the parameters; adjust them to your organization.

Questions and answers

How is the request deadline calculated?: The target deadline equals the registration date and time plus the priority time in hours. You set the times yourself on the Lists sheet.
Are the hours calendar or working hours?: Calendar hours: nights and weekends count too. If you need working time, set longer priority times.
How do I close a request?: Choose the status “Closed” and enter the closing date and time: the resolution time and a mark “on time” or “late” are calculated.
What does “due soon” mean?: No more than the set number of hours remain before the target deadline (4 by default). You can change the value in Lists.