Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for suggestion - data sharing
Hi all, I'm hoping someone can give me some solid, practical advice or suggest a solution to a work related problem. I am employed in a contact centre and am looking at developing some framework for a 'ticket of work' system. This would involve a consultant logging a job and a senior staff member then actioning the request. Currently, we use a paper based system to record the job. It is then logged on one of four spreadsheets by the senior staff member (one for each team). There is a need to keep a paper record for audit reasons. The workplace consists of around 80 people who will use the system, with a potential maximum of around 45 using at one time. Realistically, it is unlikely more than one person will need to 'log' a job at the same moment in time - but I need to consider the possibility. I have a couple of solutions..... 1. Develop an Access FE/BE database to perform the function of capturing and editing the jobs through a form. 2. Develop an Access FE/BE database and set up the spreadsheets with the DB linked as a datasource. However, I do not know how I can make the spreadsheets write updated data 'back' to the database. 3. Continue using the spreadsheets and improve the functionality. Has anyone here used either complaints management/ticket of work systems before - and what approach was adopted? Can anyone suggest strenths/weaknesses with excel V access to perform the function? Thank you...any advice or thoughts would be well received! Cheers Systematic :) -- systematic ------------------------------------------------------------------------ systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294 View this thread: http://www.excelforum.com/showthread...hreadid=530450 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for suggestion - data sharing
Have you considered getting one of the many many off-the-shelf packages that
do this type of thing? "systematic" wrote: Hi all, I'm hoping someone can give me some solid, practical advice or suggest a solution to a work related problem. I am employed in a contact centre and am looking at developing some framework for a 'ticket of work' system. This would involve a consultant logging a job and a senior staff member then actioning the request. Currently, we use a paper based system to record the job. It is then logged on one of four spreadsheets by the senior staff member (one for each team). There is a need to keep a paper record for audit reasons. The workplace consists of around 80 people who will use the system, with a potential maximum of around 45 using at one time. Realistically, it is unlikely more than one person will need to 'log' a job at the same moment in time - but I need to consider the possibility. I have a couple of solutions..... 1. Develop an Access FE/BE database to perform the function of capturing and editing the jobs through a form. 2. Develop an Access FE/BE database and set up the spreadsheets with the DB linked as a datasource. However, I do not know how I can make the spreadsheets write updated data 'back' to the database. 3. Continue using the spreadsheets and improve the functionality. Has anyone here used either complaints management/ticket of work systems before - and what approach was adopted? Can anyone suggest strenths/weaknesses with excel V access to perform the function? Thank you...any advice or thoughts would be well received! Cheers Systematic :) -- systematic ------------------------------------------------------------------------ systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294 View this thread: http://www.excelforum.com/showthread...hreadid=530450 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking for suggestion - data sharing
Yes! The easy solution is always the obvious one....but with the absence of funding in a Government department...any procurement is nigh on impossible! -- systematic ------------------------------------------------------------------------ systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294 View this thread: http://www.excelforum.com/showthread...hreadid=530450 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |