Yesterday I had the great opportunity to give a little presentation at the WWOA North Central Region Operator's meeting held in Arbor Vitae. My title? "Lost in data? Find your way out with Microsoft Excel." An integral part of what we do as a system integrator is setting up ways to automatically collect, store, access and use data. It's always really invigorating to put these data collection systems in place, but sometimes we put is an awesome systems and then the data doesn't get used. A SCADA system is so much more than an alarm system! It's even in the name - Supervisory-Control-And-Data-Aquisition!
Part of putting that system to work is getting the data out of the system so that it can be moved around. While there are reporting softwares that can create reports automatically from this data, the easiest entry into this is to have the data set up to automatically safe into txt and csv files. From there, we can import this data into Microsoft Excel and really use it.
I'm a huge fan of Microsoft Excel, but not everyone uses it every day. So in my presentation I wanted to just give a little primer on how to get csv/txt files into Microsoft Excel and then what can be done with it once it gets there.
The really great thing about using Microsoft Excel is that it's so universally used that there are a massive amount of resources available to learn. After covering some basics that I'll save for future posts, I left everyone with these three takeaways that I'll leave you with today:
Part of putting that system to work is getting the data out of the system so that it can be moved around. While there are reporting softwares that can create reports automatically from this data, the easiest entry into this is to have the data set up to automatically safe into txt and csv files. From there, we can import this data into Microsoft Excel and really use it.
I'm a huge fan of Microsoft Excel, but not everyone uses it every day. So in my presentation I wanted to just give a little primer on how to get csv/txt files into Microsoft Excel and then what can be done with it once it gets there.
The really great thing about using Microsoft Excel is that it's so universally used that there are a massive amount of resources available to learn. After covering some basics that I'll save for future posts, I left everyone with these three takeaways that I'll leave you with today:
- ALWAYS SAVE FIRST AND SAVE OFTEN. One day you're not going to do this, and you're going to kick yourself when your computer freezes up and you lose your workbook. Don't ask me how I know.
- If you’re repeating something over and over, you probably can do it automatically.
- Google is your best friend: just search “How can I _______ in Microsoft Excel" and she will tell you the answer.
