Posts tagged 'Excel'

Code Golf at Work

For the past three weeks, I have been at a suppliers factory testing a project prior to delivery to site. The other day, one of the managers of the other company came over to our group and gave a graduate a challenge, write an excel script to colour each cell …

Starting to Cleanup My Own Mess

At the start of the year, I hacked together a small spreadsheet that did many things that a spreadsheet is not meant to do. It was meant as a proof of concept however is started adding more and more to it. I had a few goes at tidying up the …

Glueing for the Future

I have been asked to help glue two separate programs together. The first program generates four different Excel files. The second program needs multiple XML files.

It is such a complex mess and I am not sure what the best way to tackle it is.

Part of me wants to …

Last Good Value from PI

Within our plant, we use the PI as our main plant historian. We can access process history using PI datalink to import the data into excel. There was a situation last week where I was attempting to create a dashboard view of the process.

Unfortunatly one of the tags I …