Nirvana
asked on
work allocation; web development; vba; access;
I download a report (to excel) from a website every half hour (by clicking on specific drop-down);
update the file into a master spreadsheet (shared workbook)
allocate work to team members (Example i receive 100 rows in excel allocate to 5 members manually by updating their name in column)
each individual open the master file update the status as "Completed", "WIP", "not started, "etc"
I want to automate the process by
1: automatically pull the data from website
2: auto updates to excel
3: allocate based on number (if i have 5 members and received 50 new rows should be allocated as 10 to everybody)
4: team should be able to update status
5: build a dashboard for status
current challenges: excel get crashed, if multiple team updates in the same row of shared workbook it takes last updated one, takes lot of times to open
Question:
what will be the best solution
1. Building a web app if so any resources would be of great help
2: MS access database with GUI and how can I do it?
3: Excel macro
or are there any tools which does the ask
thank you
update the file into a master spreadsheet (shared workbook)
allocate work to team members (Example i receive 100 rows in excel allocate to 5 members manually by updating their name in column)
each individual open the master file update the status as "Completed", "WIP", "not started, "etc"
I want to automate the process by
1: automatically pull the data from website
2: auto updates to excel
3: allocate based on number (if i have 5 members and received 50 new rows should be allocated as 10 to everybody)
4: team should be able to update status
5: build a dashboard for status
current challenges: excel get crashed, if multiple team updates in the same row of shared workbook it takes last updated one, takes lot of times to open
Question:
what will be the best solution
1. Building a web app if so any resources would be of great help
2: MS access database with GUI and how can I do it?
3: Excel macro
or are there any tools which does the ask
thank you
ASKER
Thanks a lot Jester. could you please help with some resource on webapp
what technology to use (.net,java,php etc;,)
are there any similar sites or apps which you are aware
Thank you
what technology to use (.net,java,php etc;,)
are there any similar sites or apps which you are aware
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think either option 1 or 2 is quite workable... option 3 is not likely to improve on your current situation.
Using Access would probably be the simplest, although maybe not the most robust, solution. If you have the ability I would recommend option 1. A small database with a simple web front end. You could then "pull" data from the db with any number of tools to create your dashboard.