[webdoodle]

Excel still is used heavily in government. I wrote a VBA macro for an Excel spreadsheet that would take a payroll flat text file, import it into SQL Server using OLE DB, do some data clean up, sort and then export to separate sheets in a different spreadsheet by employee name. Before I wrote this macro (which took a couple days), the payroll department of this government organization had dedicated an entire 40 hour per week person to doing this manually. They had been doing that job for years!

[wolverine876]

> Excel still is used heavily in government.

Are you implying that there is somewhere it's not used heavily?

[ourlordcaffeine]

The place I work at pretty much did away with it for all analysis and statistics

[wolverine876]

What industry? When? Is it common in your industry?

What replaced it?

[Rebelgecko]

When I sometimes interfaced with people in the government, it was astounding how often a higher-up told me they had a "database" that turned out to be an Excel spreadsheet maintained by some GS-8

[funstuff007]

Yes, I've long said don't fear the robot revolution, fear the VBA revolution.