IT Employment

Ask something
Discussion Locked

Timesheets Professional - Extraction of

0 helpful
2 replies

by mick @ lancscc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Does anyone have any tips for extracting quality management information from Timesheets Professional (V7)? I'm finding the summary reports and export facilities a bit unwieldy. I want to manipulate data in Excel pivot tables.

2 replies

by ttate

If you can generate a PRN file or something similar from this application (I am not familiar with this exact application), you can use a tool called MONARCH to convert/parse the file to EXCEL or other formats. Monarch is an outstanding tool for parsing reports and generating other formats.

by mick @ lancscc

Thanks TTate. We use Monarch quite a lot for parsing. I'd hoped to find a route that didn't involve an extra tool. Since posing the question I've found that sorting, filtering, sub-totalling in an Excel macro has helped.

This discussion is closed to new replies.