Excel Adapter

This adapter is about enabling good reporting for an organization.

Good reporting is both an art and a science. Mostly when organizations try to report off their data the results are underwhelming. The issue is you need to coach a team to agree on what is important to collect data on.

Then you need good feedback mechanisms for the team to see what is going on and refine what they pay attention to.

The Excel Adapter makes it simple set up a webservice in Iguana which can both serve and receive data from Microsoft Excel which is an excellent tool for implementing reporting using “Pivot Tables”.

Excel is great for data analysis using tools like Pivot tables.

This makes it useful to be able to feed data from Iguana into Excel.

Why build reports from first principles instead of using built in reporting tools in applications

I prefer not to use built-in reporting tools from applications. While they’re quicker for getting initial results, they often hit limits and can’t cross-reference data from different systems, like a customer management system and an accounting application.

It more powerful to build reports from scratch by extracting data from the source systems and storing it in ‘shadow’ database tables that mirror the source data for easy querying.

This is a first principles approach more effective to build reports from scratch by extracting data from the source systems and storing it in ‘shadow’ database tables that mirror the source data for easy querying.

This is a first principles approach.

Creative approaches to coding data using #hash_tags

Getting data is all about making stories map to codes. Coding stories is difficult because it essentially means getting a team to negotiate and create a shared language to see common trends in the conversations they are having.

The same idea applies whether you are a medical team dealing with patients or company dealing with customers.

Over formalized traditional IT systems often make it difficult for a team to evolve a language to talk about the problems they are seeing.

One clever ‘hack’ is to use the practice of putting #hash_tags into notes. Almost all applications support free form text and thus you put hash tags into this text as a simple fast way to ‘code’ data.

How do we put the VBA code into Excel?

Excel .xlsm files are essentially zipped bundles of XML files. You can unzip them, modify the content programmatically, and zip them back up.

They also include a vbaProject.bin file, which stores VBA code. The adapter uses this approach to add my VBA code for the adaptor.