Your time, your data, automated

The program simplifies the registration of work hours and timesheets, using Outlook Calendar as the primary data source, connected via Exchange Server. Downloaded events are efficiently processed through the Event Handler, offering multiple customization options. The output is displayed in a detailed dashboard view, with data upload available manually to Excel or automatically to SharePoint Excel for seamless integration.

The application is designed exclusively for Konica Minolta

Quick operations

This is the standard process flow used to retrieve data from the exchange, process it efficiently, and seamlessly upload it to SharePoint.

Download

Choose a date source from Sharepoint or set dates manually, then download the data.

Process

The Event Handler will automatically process downloaded events based on the configured setup.

Check

Review the dashboard for a final visual check and verify the data in the integrated table.

Upload

Upload data to SharePoint Excel or export it locally for manual upload.

Download segments

Active reporting period

The user must specify a date range for data retrieval. This period can either be determined automatically by analyzing an existing TimeSheet stored in SharePoint or selected manually, ensuring flexibility in data selection.

Historical data

You can use the program to download historical periods by specifying a start and end year and month, ensuring precise data retrieval from history Sharepoint.

My team

If you’re a manager, you can set up your team and monitor their activity. This tool exclusively retrieves data from TimeSheets already stored in SharePoint, ensuring accurate and reliable reporting.

Event Handler

The Event Handler is a collection of distinct functions designed to facilitate the accurate transfer of calendar events into TimeSheets. Each function plays a specific role in ensuring that events are processed efficiently, preserving their original details while adapting them to the structured format of TimeSheets. Whether it’s splitting overnight events, managing overlapping entries, or filling gaps between scheduled times, the Event Handler works systematically to maintain precision. By applying predefined rules, it streamlines the transition of calendar data, optimizing scheduling accuracy and ensuring that all recorded events align seamlessly within the TimeSheets framework.

Overnight Event

Splits an overnight event into two separate events, one before and one after midnight

Skip Events

Filters out events with specified subjects, ensuring they are excluded from processing.

Fill Empty

Automatically detects gaps between scheduled events within working hours and fills them with predefined events to ensure to fill every inch of calendar.

Fill Empty Coverage

Optimizes scheduling by recalculating filled empty spaces based on the percentage of usage, ensuring efficient allocation of predefined events.

Special Events Handler

A special event handler allows certain events to be processed differently, such as handling parallel events like a lunch break separately.

Sickday

Lunch

Doctor

HomeOffice

Join Events

Consecutive events that follow one another seamlessly can be merged into a single event, ensuring a streamlined and efficient schedule.

Too Long Empty place

The application intelligently segments available space into multiple events when needed, ensuring optimal utilization based on predefined thresholds set within the system.

Paralel Events

Manages overlapping events by applying predefined rules to determine which event is recorded. If one event starts while another is ongoing, the ongoing event is split accordingly. When multiple events start at the same time, an additional setup defines priority for selection.

Keep Method

Parralel handler

Use Shorter Method

Events Scheduler

Effortlessly schedule events in Time Sheets based on your chosen day within the weekly timeline. The application then seamlessly creates events in the selected timeframe, ensuring a smooth and efficient scheduling experience.

AutoFill Rules

Enables automated assignment of project and activity categories in timesheets based on subject text, allowing for full or selective categorization as per predefined rules.

Activity Correction

If an incorrect activity is selected in Outlook, the Event Handler automatically processes and rewrites it based on predefined rules.

Dashboard

This dashboard presents download results and Event Handler outputs in a well-structured format, delivering a wealth of valuable insights.

Charts

The dashboard can display three insightful charts: Project Details, Activity Details, and Utilization Hours, all seamlessly powered by Bokeh for dynamic visualization. This how it can looks.