Windows Error Code 0X80072F8F

Upgrading to Windows 10

I decided it was time to upgrade my Samsung Premium Ultrabook from Windows 8 to Windows 10.  From what I understand, the Windows 10 upgrade may not be free forever and upgrading to the new operating system was something I could do while I working on other things.

The dead battery suggested that a lot of time had passed since I last used this machine.  As it turns out, this was also warning sign that maybe things wouldn’t go as smoothly as I had originally planned.

When I loaded Internet Explorer, I was immediately greeted with a banner to Upgrade to Windows 10 through Microsoft’s website.  After following the instructions to download the update, I attempted to run the installer.

A message appeared on the screen stating the software “tool” could not be installed due to error code 0x80072F8F.  Error codes don’t bother me as much as they once did because they can easily be searched on the internet.

Internet to the Rescue

I used Google to search for “Error Code:  0X80072F8F” and discovered I wasn’t the only person who had this problem.  The solution simply required me to ensure the date and time were current on my computer.

As my computer’s battery was completely drained, the date and time were set to a date in May of 2009.  Changing the date and time to the current settings was the cure to resolving the error.

The answer and source for this solution appeared in a forum on Microsoft’s website at http://answers.microsoft.com/en-us/windows/forum/windows_7-update/error-code-0x80072f8f/d5006dbe-5946-4d68-8f08-8620eeb65efd?auth=1.

Two methods to resolve the error code are presented.  Method one (1) simply requires you to update the clock to reflect the current date and time.  This method works on Windows 8.1 though it is not specifically mentioned in the context of the solution.

  1. Click Start, and then click Run.
  2. In the Open box, type Timedate.cpl, and then click OK.
  3. On the Date and Time tab, make sure that the computer’s date and time are correct. If the settings are incorrect, adjust them to the correct date and time.
  4. Click OK to close the Date and Time Properties dialog box.
  5. Try to install updates again.

Full credit goes to the author of the solution as it appeared on the website cited above.

How is this Lean?

Sometimes the solution for the problem you are trying to solve already exists.  In this specific case, I would’ve had a very difficult time attempting to resolve the error code without having access to the internet.

Not all problems require exotic “in-house” solutions nor do they require the expertise of an IT staff member to resolve.  The scope of the problem and it’s inherent solution should be understood to ensure the concern is addressed in the most efficient and effective manner possible.

Your feedback matters

If you have any comments, questions, or topics you would like us to address, please feel free to leave your comment in the space below or email us at redge@versalytics.com.  We look forward to hearing from you and thank you for visiting.

Until Next Time – STAY lean!

Versalytics (64x64)

Advertisements

OEE and ERP

Implementing an ERP (Enterprise Resource Planning) system is a lot of work and happens to be where we’ve been spending most of our time and resources over the past few months.  The OEE reporting spreadsheet we planned to release some time ago is complete and we’ve been using it on some of our core production processes.  

Some have emailed, asking when the spreadsheet will be published.  We plan to make this spreadsheet available once we are satisfied that it serves the purpose we originally intended.  The tools we provide here are offered free of charge and the urgency of releasing them is offset by revenue driven opportunities that in turn support our site and make these “free” resources possible.

Since we are implementing a new ERP system, we also have the opportunity to create and generate customized OEE reports from data already being collected as part of the normal production reporting process.  As the lead for implementation, I am in the unique position of tailoring the data collection and reporting requirements in kind.  This of course is one of the few tasks of many currently under way.

As you may expect, the ERP system runs from a highly structured and more sophisticated database than that of a simple spreadsheet.  As mentioned in many past posts, a commitment to OEE will eventually require a database for more efficient and effective data processing.  Having the opportunity to incorporate OEE from current organic data is less disruptive and represents a significant step forward to real time OEE reporting.

Crystal Reports

We could generate database queries from Excel to further evolve the development of our spreadsheet, however, Crystal Reports integrates nicely with our database front end and the reports are available to everyone on the network.  In other words, the necessity for a spreadsheet is superseded by the need for customized reporting using Crystal Reports.  We can also use Crystal Reports with Excel and many other data sources.

Crystal Reports is a de facto standard in industry and a license is relatively inexpensive considering the powerful capabilities it brings to your data.  A mere mention here in this post does little to expose the merits of using Crystal Reports and we recommend that a little research of your own is warranted.

Your feedback matters

If you have any comments, questions, or topics you would like us to address, please feel free to leave your comment in the space below or email us at feedback@leanexecution.ca or feedback@versalytics.com.  We look forward to hearing from you and thank you for visiting.

Until Next Time – STAY lean

Versalytics >> Analytics

Happy Anniversary

Happy Anniversary

It’s hard to believe that today marks our 7th anniversary.  I still remember writing that first post and wondering who would be interested in what we had to offer.

After more than 293,000 views, thousands of free downloads, and visitors from more than 120 countries, we can say that we’ve successfully helped more than a few people and companies get started with their OEE training and implementation.

We would like to thank all of our subscribers and visitors for your feedback, support, and many “thank you” notes over the years.

Your feedback matters

If you have any comments, questions, or topics you would like us to address, please feel free to leave your comment in the space below or email us at feedback@leanexecution.ca or feedback@versalytics.com.  We look forward to hearing from you and thank you for visiting.

Until Next Time – STAY lean

Versalytics >> Analytics

OEE – Reporting Live Part 1

How do you report Overall Equipment Effectiveness?

The next greatest challenge after learning how to calculate Overall Equipment Effectiveness (OEE) is reporting it.  This is often a topic of great debate and likely a reason why so many avoid discussing it at all.

Note that we have prepared several Excel spreadsheets to help you get started and they are available free of charge from our downloads page.

The question is, “What do we report?”  Some will argue that you can’t compare OEE between plants, departments, shifts, or processes. While we tend to agree with them in some respects, there is relevance to understanding the differences in the results.  In a comparative context, we would also add that we never intended to use OEE as competing metric, rather …

Our objective is to continually improve OEE over time.

Our objective is to provide a report that calculates OEE for multiple parts and processes such that a “summary OEE” can be determined from any combination of factors included in our production report.

Our report can be further extended to include other factors derived from the reporting system itself.

How to Report OEE

While technologies exist that offer instantaneous OEE reporting on the shop floor, they do little to help you in the boardroom.  Over the next few posts, we will create a relatively simple reporting structure using Excel as our development platform.

Before we get started with our spreadsheet, lets first understand what data we need to collect.  We can then decide what elements to add to our spreadsheet accordingly.

Data Collection

We need a method for collecting the minimum amount of data that will satisfy our requirement to establish a robust OEE reporting system.  For now we will consider collecting the following data using a very simple production shift report::

  • Date
  • Shift
  • Employee (Name / Number)
  • Start Time
  • Finish Time
  • Part Number
  • Work Order (Job Number)
  • Sequence (Step Number)
  • Work Center (Machine)
  • Quantity Good
  • Quantity Scrap

This basic report can easily be enhanced by adding columns for setup, material changes, breaks, or other events to better understand what transpired over the course of a given shift.  We recommend keeping it short and simple.  Only add more rigorous reporting requirements as needed and if the results demand it.  A simple format encourages people to complete the forms more readily.

Reporting OEE

In our next post, we will introduce a spreadsheet where we can input our data and generate our OEE report.  Our spreadsheet will allow you to calculate OEE for any combination of the above data entries.

Until Next Time – STAY lean!

Versalytics-Logo

OEE Short and Simple

OEE In Simple Terms

The more we know, the more complicated things get.  The same is true for OEE.  When the training is over and the data collection starts, it’s easy to get overwhelmed with information.  It gets even worse when the results are published – especially if the OEE is less than anyone ever expected it to be.  A word of warning – OEE is always less than anyone expected it to be.

That can’t be right

More often than not, “That can’t be right” is the first statement you’ll hear.  This is typically followed by a request to review all of the input data to make sure there are no entry errors.  Chasing errors soon becomes the daily ritual as you try to make sense of the results.

Why this happens …

The greatest source of confusion begins with the very formula that’s being used to calculate OEE. A quick search of the web will yield the formula for OEE as Availability x Performance x Quality, where the result is expressed as a percentage.

Though this formula apears to be simple enough, the reporting mechanisms to support this formula require an exceptional level of rigor and integrity. Is the downtime precise or estimated? Do we attribute the unaccounted downtime to the Performance factor? If so, was the machine really running at the ideal rate? How many minor “machine faults” occurred? Were they really minor faults or simply unreported downtime events of unknown duration? And there begins the source of errors and confusion.

While the formula is correct, the reporting methods are error prone and become the underlying source of so much confusion. There is a much easier way to calculate OEE that eliminates the “overhead” required to support the traditional formula and does not require significant investment in advanced hardware or software technologies to better track downtime events, machine faults, or machine cycle times.

We suggest …

By definition, OEE can be calculated using a very simple formula:

OEE = (Good Parts Produced x Ideal Cycle Time) / Net Operating Time

OEE = Ideal Operating Time / Net Operating Time

  • Remember, the units of measure for the cycle time and operating time must be the same

This is also known as the “Back of the Envelope calculation” and anyone on the shop floor can do the math at any time. Just remember to use the same base unit of measure for time; if the cycle time is stated in “minutes per part”, then the Net Operating Time must be expressed in minutes as well.

Simple OEE – Example

A CNC machine is scheduled to run for 1 complete shift from 6:00 am to 2:30 pm. There are three breaks over the course of the shift: two (2) 10 minute breaks and one (1) 30 minute break. The ideal cycle time for each part is 75 seconds or 1.25 minutes.

For quick shift calculations, we first determine our Net Operating Time as follows:

  • Shift Time: 6:00 am – 2:30 pm = 8.5 hours = 510 minutes
  • Scheduled Breaks: (2 x 10) + (1 x 30) = 50 minutes
  • Net Operating Time = 510 – 50 = 460 minutes

If 340 good parts were produced on the machine over the complete shift, we can easily calculate our OEE as follows:

Calculate the Ideal Operating Time based on the quantity of good parts produced:

  • Ideal Operating Time = Quantity of Good Parts Produced x Ideal Cycle Time per Part
  • Ideal Operating Time = 340 parts x 1.25 minutes / part = 425 minutes

OEE = Ideal Operating Time / Net Operating Time

OEE = 425 / 460 = 92.39%

Short and Simple

Lost Time

We can quickly determine the total time lost during the shift with the following formula:

  • Lost Time = Net Operating Time – Ideal Operating Time

From our example above, the total lost time is  460 minutes – 425 minutes = 35 minutes.

Where did the time go?

Now that we’ve established how much time was lost over the course of the shift, we can review our production reports to determine when the lost time event occurred and how much downtime was incurred.  The reasons may be many but they are typically classified as follows:

  • Availability
    1. Setup and Adjustments
    2. Breakdowns
  • Performance
    1. Minor Stops
    2. Speed Losses – Running at less than Ideal Rate
  • Quality
    1. Start up / setup defects
    2. Production defects

These categories form the baseline for the more familiar OEE formula:

OEE = Availability x Performance x Quality

While this formula “works”, it is seldom possible for any given event to timed to the precision required to provide a truly accurate OEE result.  No matter what formula you choose to calculate OEE, the simple formula given earlier allows the real downtime to be determined.  How the downtime is allocated to each of the categories (Availability, Performance, or Quality) may not be so simple or easily monitored and managed.

In Conclusion …

The objective of OEE is to help direct your efforts and focus on those opportunities where the greatest improvements can be realized.  Unfortunately, many plants seem to think of OEE as a means of measuring “How good we are!” as opposed to “How much better can we get?”

We strongly suggest using the simple formula to calculate OEE, then drill down through the  various reports available to better understand the results  and inherent downtime losses.  This approach will enable you to “reverse engineer” your reporting infrastructure to identify the real opportunities for improvement. 

Your Feedback Matters

Thank you for reading and as always, we appreciate your feedback.  Please feel free to leave a comment or suggestions for future topics.

Until next time – STAY lean!

  

Lean Execution – Time for Change

It’s Time for Change

We’ve been operating our website under the same theme for several years and decided that it’s time for a new look.  So, we’re upgrading with new features and capabilities.  With these changes, we hope to make it easier for you to navigate and access our content.

You can also reach this site through our new domain name:  http://www.versalytics.org

As always, we appreciate your feedback.

Until Next Time – STAY lean!

Versalytics-Logo

SQLite Database Tools / Resources

SQLite is powerful, fast, and supported by a number of languages including a few of our favorites Python, Tcl/Tk, C/C++, Java, Ruby, and more.  This post serves as a baseline for some of the resources that are freely available on the web:

Getting Started:

SQLite Official Site – Follow this link to learn more about SQLite and how to get started.

SQLDatabase Tools:

Although the Command Line Shell for SQLite can be used to create and work with your SQLite database, there are some fairly powerful (and free) tools that provide a more intuitive Graphical User Interface (GUI).

  • SQLite Expert:  As of this writing, version 3.5.83 is available as well as a 4.0 beta version.  The Personal versions are free, however, a professional version is available for a nominal fee.
  • SQLite Browser:  This SQLite utility can be used to create, design, edit, search and so much more.  Working with SQLite databases doesn’t get much easier than this.  (Windows / Mac / Linux).  Freeware.
  • SQLite Studio:  An SQLite database manager that runs on Windows / Mac OSx / Linux and also supports Exporting to, and importing from, a variety of file formats. This free utility also offers extra plugins for a nominal fee.
  • Mozilla Firefox:  If you’re running Mozilla Firefox, an extension, SQLite Manager 0.8.3.1, can be used to manage any database on your computer.

C/C++, Python, Java, and Tcl/Tk are the primary languages we use to work with SQLite databases.  However, it’s always good to have these tools at hand when things just don’t seem to be working as they should.

SQLite Tutorials / Information

This should be more than enough to get you started to begin exploring data solutions for your own applications.  One of the most significant challenges that programmer face is data structure.  An SQLite database may just be the efficient and effective solution you need to manage your data.

Using Tcl/Tk and SQLite – Solution for creating a database and entering basic data.

Until Next TimeSTAY lean!

Vergence Analytics