What you can do with the Excel integration add-in
Overview of the Excel integration add-in
TimeTracker RX has an add-in that can be installed and used in Excel, and
Data entered in Excel forms can be linked with project information in TimeTracker RX.
This allows you to use the existing system as is, as follows, according to the site.
- Import TimeTracker RX data in the format you have been using until now.
- Reflect actual results from Excel to TimeTracker RX.
Users who do not have "Allow local authentication" checked in their user settings cannot use this function.
For details, please contact your TimeTracker RX administrator.
Installing the Excel Linkage Add-in
To use the Excel Linkage Add-in, you must install it on each client PC.
For instructions on how to install the Excel Linkage Add-in, see the content at the link below.
For details, see the following link: Install Excel Linkage Add-in
When you install the Excel Linkage Add-in, the following [TimeTracker RX] tab will appear on the Excel ribbon.
The Excel add-in can be used mainly as follows.
For details on the operation procedures for each purpose, please refer to the links.
Import data into Excel forms
You can import project information displayed in TimeTracker RX into Excel forms such as project reports that you have been using until now.
You can use TimeTracker RX data without changing the way you have been doing things.
Even if you are reporting regularly, such as monthly reports, you can use the saved import settings to update to the latest data in TimeTracker RX.
For details, please refer to the following link. : Reflect in Excel
Reflect data in Excel
You can reflect data in Excel forms in TimeTracker RX work items.
You can update the contents of progress reports received from teams that do not use TimeTracker RX with the push of a button in TimeTracker RX,
and manage the progress and costs of the entire project, including other teams.
For details, please refer to the following link. : "Update to TimeTracker RX"
Output Gantt table/Gantt chart
The Gantt table and Gantt chart displayed on the work item screen can be output directly to Excel.
After outputting the Gantt chart to Excel, you can use Excel's functions to print it in your preferred format, such as paper or PDF.
The following can be achieved based on Excel files and printed paper.
- Check schedules and progress with members who do not use TimeTracker.
- Post schedules and share information in places where PCs cannot be used.
For details, please refer to the following link. ： "Export Gantt table/Gantt chart"