Hellow guys, Welcome to my website, and you are watching Ishikawa-Fishbone Diagrams in Excel 2010-2019 and Office 365, with the QI Macros. and this vIdeo is uploaded by QIMacros at 2010-12-27T09:08:15-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Ishikawa-Fishbone Diagrams in Excel 2010-2019 and Office 365, with the QI Macros |
| Video Uploader | Video From QIMacros |
| Upload Date | This Video Uploaded At 27-12-2010 17:08:15 |
| Video Discription | We've automated this template to save you even more time. Watch the newest version at https://www.youtube.com/watch?v=1bLTc4Voepc Learn more at https://www.qimacros.com/fishbone-diagram-template/ No credit card required to download 30 day trial at https://www.qimacros.com/trial/30-day/ Fishbone or Ishikawa Diagrams are one way of capturing root causes in Six Sigma. So, after you've done your Control Chart and narrowed your focus with a Pareto Chart, the Fishbone Diagram is the way to capture the improvement. Now usually, we've come to this this process by some hooker crooks so we've gotten down to some data. Here you can see we have 3 big bars, folded flaps is the biggest. We could actually have teams work on each one of these bars. So, we'd like to insert a Fishbone Diagram. I click on improvement tools, Ishikawa or Fishbone Diagram in the QI Macros. Then, I can right click on Ishikawa and choose move or copy. I'm going to move that to Pareto, and I'm going to move it in here right before my other fishbone diagram. Here you can see we've got our Fishbone Diagram, and folded flaps was 26.8% of the total. So, let's say during December 2010, folded flaps accounted for 26.8% of total defects, which was higher than desired and caused customer dissatisfaction, rework, lost profit, or anything that you want to put in there. That’s the problem statement that came from our Pareto Chart. Now, we could make one of these for each one of the other bars, and then we would start asking why? Why did our process cause folded flap problems? Well, maybe it's a machine setup. There's a process for that—it's not the machine that is the problem. Then we go, why is it that way? Well, left prior set up. Well, why are we leaving prior setup? Shift change, I don't know what it is, but you can get the idea. Then if you need to duplicate any of these, you just click on the little square bars, select them, and you can choose copy. Then, we can just choose paste, and it'll stick one in here and we can drag or drop that wherever we want it to be. So, you can draw Fishbone Diagrams very easy using the QI Macros. If you go to qimacros.com you can download a free 30-day trial and try this out for yourself. That’s the next step in solving problems—Control Charts, Pareto Charts, Fishbones, and the next one is Countermeasures. |
| Category | Science & Technology |
| Tags | ishikawa | fishbone diagram | Six Sigma | QI Macros |
