Zorba
Lifer
- Oct 22, 1999
- 15,613
- 11,255
- 136
Or take advantage of its built-in graphing capabilities: Someone at work created an external program to slice up a text file containing data to analyze, then it spits out a multi-megabyte CSV file, and finally it instructs Excel to open that file and generate a bunch of easily-editable graphs of the data.
I did a job for a while that I had to create a lot of reliability data monthly. Since many of the reports were standard reports, I automated a ton of it in Excel with VBA. I wrote a VBA program to suck in raw data, format it, setup some pivot tables, then create a powerpoint file for each fleet and then create graph and copy/format it into power point. The VBA program did all of the text and formatting in PP also. The guy who was doing it before me took 8 days each month to create these charts, I spent ~3 on the program and then could make a full set in about 5 minutes run time.
Needless to say, after I did this a few times my manager decided I was too good for his group and helped me move on to a better group
