Kicker
08-28-2004, 10:14 AM
Just looking for ideas and comments.....
At work, we use several reports created with Report Writer. Many of the people who NEED to use the data from the reports never look at the reports because of the nature of the way the report is designed. I have been playing with an excel spreadsheet that people are starting to like and even USE.
Here is what I have so far:
1. I run the RW report and export it to a CVS (comma delimited) file.
2. I Load my SSR_Manning excel workbook and clear the contents of the Data worksheet
3. I get external data and anchor it in the Data worksheet at $A$1.
4. Through the use of a simple sub routine, I distribute the data into specific cells in the ManningLevels worksheet.
5. Through the use of a complex public function, I calculate values for 10 days worth of shifts. Through the use of conditional formating for these cells, I change the interior.colorindex to black and create a type of GANTT chart.
This is working well. However.....To make it simple enough for the Shift Supervisors to update the data themselves, I would like to
Automate the import/link/whatever to the CVS file so that the newest and greatest data is automatically displayed. If it can be linked, it would save a lot of time. I know I can automate getting the external data.
Remember, the Shift Supervisors are the BEST at what they do, however, it took most of them 6-months to learn how to turn-on their computers (granted the classroom instruction was only 2 hours a day for the 6-months LOL).
ttfn
Kicker
At work, we use several reports created with Report Writer. Many of the people who NEED to use the data from the reports never look at the reports because of the nature of the way the report is designed. I have been playing with an excel spreadsheet that people are starting to like and even USE.
Here is what I have so far:
1. I run the RW report and export it to a CVS (comma delimited) file.
2. I Load my SSR_Manning excel workbook and clear the contents of the Data worksheet
3. I get external data and anchor it in the Data worksheet at $A$1.
4. Through the use of a simple sub routine, I distribute the data into specific cells in the ManningLevels worksheet.
5. Through the use of a complex public function, I calculate values for 10 days worth of shifts. Through the use of conditional formating for these cells, I change the interior.colorindex to black and create a type of GANTT chart.
This is working well. However.....To make it simple enough for the Shift Supervisors to update the data themselves, I would like to
Automate the import/link/whatever to the CVS file so that the newest and greatest data is automatically displayed. If it can be linked, it would save a lot of time. I know I can automate getting the external data.
Remember, the Shift Supervisors are the BEST at what they do, however, it took most of them 6-months to learn how to turn-on their computers (granted the classroom instruction was only 2 hours a day for the 6-months LOL).
ttfn
Kicker