BDW

One of the complexities in this project is due to file size. The data set is 7,000 rows but over 500 columns are necessary to provide data for all the reports, calculations, including multiple historical periods. The client has a strong understanding of his customers and doesn’t want to sacrifice on content. Our Excel macro file we use to create the 800 files is about 1 gb in size. Using a powerful system, we can generate the reports in a few hours.

We developed a custom process we call “zip/unzip”. As you may be aware, XLSX files are compressed files, so they don’t zip down much. But to compress an .xlsx file, you can rename the extension from .xlsx to .zip, extract all the elements of the file (the .xml files, etc), then zip them back to a .zip file, then finally rename the extension again from .zip to .xlsx. The largest files that come out of this production are about 80 mb, and we use our “zip/unzip” process to get them down below 50 mb.

We work with large companies, but we have special love for small companies. We develop long last partnerships and love to celebrate their success as they utilize our technology projects to improve their competitive position.

“I have used Infodatix with great satisfaction for many years and continue to use their services. Their ability to efficiently and effectively devise elegant solutions to complex problems is unsurpassed in this space. I could not recommend Infodatix more highly.”

Justin Barr, Managing Principal, Loan Workout Advisers, LLC.