Excel Sheet Manipulation
4255
£250(approx. $311)
- Posted:
- Proposals: 8
- Remote
- #163226
- Archived
Freelance Business Manager / Salesperson / Project Manager / Production Manager / R&D Manager
London
24640070729160902212139216999253433254162243182
Description
Experience Level: Expert
We have some monitoring software which outputs results showing number of keystrokes typed by users each day, and using which program (Word, Outlook, IE etc). This program doesn't have very good reporting tools however.
We are able to manually export the data into a TXT file, and then can import this into Excel - but we would like some kind of macro/script created which would take this excel sheet (or group of sheets if possible - 1 per user at present) and display the results in a more users friendly way.
For example, data in Excel sheet presently shows as:
DATE & TIME | PROGRAM | WINDOW TITLE | COUNT
DATE & TIME = date & time of recording
PROGRAM - Program used - Word, IE, Outlook etc
TITLE - Title of window e.g - Word Doc name, IE page open, Outlook email open etc
COUNT - total keystrokes done during that doc/page etc.
This lists EVERY program opened during the day, every page/doc of the program and how many keystrokes typed for that instance - whereas we would prefer a breakdown of total count for all Word instances, all IE instance etc during each day for each user. If possible, it would also be helpful to have it show as some kind of chart.
We might also be keen to have help in automating the exporting of the data to start with - save doing it manually, however as the software is 3rd party, this might not be possible.
We are able to manually export the data into a TXT file, and then can import this into Excel - but we would like some kind of macro/script created which would take this excel sheet (or group of sheets if possible - 1 per user at present) and display the results in a more users friendly way.
For example, data in Excel sheet presently shows as:
DATE & TIME | PROGRAM | WINDOW TITLE | COUNT
DATE & TIME = date & time of recording
PROGRAM - Program used - Word, IE, Outlook etc
TITLE - Title of window e.g - Word Doc name, IE page open, Outlook email open etc
COUNT - total keystrokes done during that doc/page etc.
This lists EVERY program opened during the day, every page/doc of the program and how many keystrokes typed for that instance - whereas we would prefer a breakdown of total count for all Word instances, all IE instance etc during each day for each user. If possible, it would also be helpful to have it show as some kind of chart.
We might also be keen to have help in automating the exporting of the data to start with - save doing it manually, however as the software is 3rd party, this might not be possible.
Tony W.
100% (38)Projects Completed
32
Freelancers worked with
29
Projects awarded
28%
Last project
2 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies