A company is only as good as its clients and at HMS, this is no exception. We received a letter a few weeks ago which we’re delighted to have now put on our website in the Testimonials area.
The letter is from Mark Simpson a Project Manager at RN Engineering and talks about how they have been able to blend 3 separate business processes into one much more effective process using TimeControl. You can read the letter in its entirety at RN Engineering Letter.
To Mark and his entire team at RN Engineer, we say a big Thank you! We appreciate our partnership with the RN Engineering team and we look forward to many more years of working together.
We often get questions here at HMS about how TimeControl and Excel. Answering appropriately requires knowing why people are asking. For those who are interested in knowing if they should migrate from an Excel timesheet to TimeControl, there are numerous resources on the TimeControl website identifying the benefits of going to a centralized data-driven timesheet model. But, there are so many other ways that the two systems are tied, we’ve created a special solutions portal to help
Let’s take a look at some of the different ways you might be thinking that TimeControl and Excel are related:
Migrate from an Excel timesheet to TimeControl
Many organizations create their first timesheet using Excel. It’s a natural fit. The Excel format is infinitely flexible and perfect for designing a grid that has to use calculations to total up the week’s time and even costs. But, as an organization grows, the need for the functionality of a full timesheet system grows also. Maintenance and the management of an Excel timesheet when an organization is a handful of employees is relatively simple. When the number of people grows, that maintenance becomes more complex, more costly and a bigger challenge. That’s where TimeControl’s centralized data structure becomes much more attractive.
Importing and Exporting data between TimeControl and Excel
TimeControl includes complete support for importing and exporting data in an Excel format. If you maintain some data now in Excel, then moving that into TimeControl is a matter of moments. If you use Excel for analysis of data, then sending TimeControl’s source data to Excel is very simple. You can even schedule exports to Excel or imports from Excel to happen automatically on a schedule you determine.
Integrating Excel Services dashboards into TimeControl
Some people like using Excel’s server-based charting capabilities to create analysis of timesheet or project management data. TimeControl supports displaying Excel views in the dashboard. Need an Excel pivot report? No problem. Need an Excel traffic light dashboard? No problem.
Displaying Reports in Excel
Every TimeControl report including those created in our TimeControl Report Designer or with the TimeControl Drill Down Analyzer can be saved as Excel files so you can do more extensive analysis and reporting in the tools you are familiar with.
You can find out more about how TimeControl and Excel can work together to help your organization become more efficient on our TimeControl/Excel Use-Case portal at: www.timecontrol.com/use-cases/excel-to-timecontrol. On the portal you’ll find webcasts, factsheets and slide presentations explaining some of your options and potential benefits.
We’ll be on the road next week at the PMI Westchester’s Professional Development Day which takes place April 2nd at the Holiday Inn in Mt. Kisco, NY.
HMS is this year’s Platinum sponsor so attendees will get a chance to talk to HMS personnel about their timesheet needs and see the latest of TimeControl, TimeControlOnline and TimeControl Industrial.
For more information on the conference, see pmiwestchester.org and if you’d like to make an appointment to speak to HMS personnel while you’re at the conference, contact firstname.lastname@example.org.