Cover Story Smart Grid for industrial disciplines
Smart Grid is certainly a new buzzword in industrial circles. As with every previous initiative good and bad, it requires a bit of education to get to the point where you understand how you can implement it in a way that does more than go through the motions and creates immediate and sustainable improvement.
With Smart Grid, you hear terms like Smart Generation, Smart Storage, Cyber Security, Smart Distribution, Smart Consumption, Demand Response, Alternative Energy Sources, Meter Data Management, and Micro Grids. In industry, we tend to speak in terms like, Capital Equipment, Inventory, Labor Efficiency, Lean Manufacturing, Takt Time, Overtime Premium, Bottlenecks.
It is confusing. When I became involved in my first supervisory control and data acquisition (SCADA) applications, I was also confused and scared to death of the secret technology. After a short time, I remember telling one of my high-school buddies who was a computer programmer that it was not as complicated and magical as I had thought. I remember him saying: “Now that you are on the inside, you can’t tell anyone.”
Let me take some time to remove your fear of Smart Grid and bring you to the inside.
Line balancing and Takt time
For the readers that have assembly lines, you certainly practice line balancing. You don’t allow one station of the line to have 3-4 times the load of the other stations. When you find this, you move load from one station to another. I would equate each station to an hour in the utilities day.
You probably also have variability in the standard hours by product line. When you have non standard operations, you take them offline or add temporary capacity to that workstation. Similarly, the utility can either fire up expensive peaker plants or shed the load to another period. The challenge for them is they need you to cooperate if they want to shed load.
Some of the manufacturing people reading this will recall Eli Goldratt’s first book The Goal . One of his messages was improvement of $1 in a bottleneck was worth tens or hundreds of dollars of value through the entire system. We now realize the entire system for our energy delivery encompasses Generation and Consumption. If you try to sub-optimize one or the other, you do not get the synergy that is Smart Grid. The utility can not get access to the entire system benefits without your participation.
Eugene's Blog: How To...Create a Pareto Chart in Excel
I have added a new video to YouTube to describe how to create a Pareto chart in Excel 2003. For my Business Systems Analysis module in NCI I have a Pareto Analysis exercise, and I had previously created a Word document showing the steps using screen shots. Now I have a video doing the same - I will link to this from the course resources page on NCI's Moodle LCMS so that future students who prefer to watch rather than read can learn how to create a simple Pareto chart.
Create A Pareto Chart - Bookshelf
Project Management Communications Bible
We recommend that you review the Pareto Chart tool planning questions in Chapter 11. Creating a Pareto chart A Pareto chart is priceless in determining the ...Quality Control for Dummies
A Pareto chart can help him focus on the most critical issues that cause customers to be unhappy with their pizzas. Creating a Pareto chart Creating a ...Statistics for Health Care Professionals, Working With Excel
Working with Pivot Tables: Creating a Pareto Chart One chart that may be interesting to look at, based on the data pictured in Figure 4.31, ...Balanced Scorecards and Operational Dashboards with Microsoft Excel
To create a Pareto chart 1. Enter data as shown in B7:C16 of Figure 24.14. Notice that the data is sorted in descending order by Revenue ...Pareto Charts, Plain and Simple
Sometimes people create a Pareto chart based on opinions or votes rather than on data collected on the situation. While sometimes it is useful to understand ...Day-to-day Posts Directory
How to Make a Pareto Chart in Excel 2007/2010: Free Template ...
In addition to showing how to create a Pareto chart in Excel, we'll take a look at several types of modifications that can be made to the chart – such ...
How to Create a Pareto Chart in Excel | Excel & VBA – da Tab ...
A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line ... How to Create a Pareto Chart in Excel. Find out how to create a Pareto chart in Excel. ...
To create a Pareto Chart
To create a Pareto Chart. Note: In order to create an Attributes control chart, you must ... The Chart Options dialog box is a dynamic dialog box, since the options ...
Pareto Chart Template - Pareto Analysis in Excel with Pareto ...
Download a Pareto Chart template for Excel - set up to perform a quick Pareto Analysis. Default pareto chart or pareto diagram based on the pareto principle or 80-20 rule.
Excel Pareto Chart: Instructions & Template : Expert Program ...
Step-by-step instructions for creating an Excel Pareto Chart, plus a free template available for download.