[agibsonccc]

Exactly! It's a simple concept for a programmer to think about. (A 2d array? How hard could this be?) but really it's crazy how annoying it is to do certain things. Excel has math down pretty well, but encoding other kinds of data or even compiling the data to a spreadsheet is a significant problem for most people.

[bliti]

The biggest problem that company had was fetching the image for each product (it fed from one API). They had to manually insert the image for each one. Imagine a pallet with 200 different products in it! All I did was create a web GUI where they would upload their orders, then the program would fetch all the data, insert the images in the correct row, and generate the file for them. But the file would be sent off to a workstation that was operated as a printer server/queue station. After that, the spreadsheet was automatically printed and the shipping department would get the document in a nicely formatted manner. It weird, but I get excited talking about it. Its the little wins that really count.