Pole Data Trend Analysis Help - Monitoring the % of poles that we have to straighten

Q

QCAce

#1
Looking for some guidance from our statistical analysis experts...

My situation is my company has been monitoring the % of poles that we have had to straighten and we have had an increase lately. 30-40 ft length steel poles are dipped in a hot metal bath to be galvanized at one of our suppliers. I had a suspicion that things were getting worse when the weather turns colder, but was told that poles are allowed to reach ambient indoors and outside temperature is negligible. Regardless of the cause, looking at the %'s below or attached, statistically can I say that something in the process has changed?

month #bent #received %bent
May-04 18 1358 1.33%
Jun-04 30 2282 1.31%
Jul-04 31 2200 1.41%
Aug-04 10 1570 0.64%
Sep-04 13 1131 1.15%

Nov-04 53 1363 3.89%
 

Attachments

Elsmar Forum Sponsor
B

Bill Pflanz

#2
Andy,

I am not a statistician but if you do a t test, you will find that the two periods of production are statistically different. You had already suspected that but I think you were wanting more than just a mathematical proof of the difference. Just looking at your data, I have the following comments.

Not only is the % bent different in the warm and cold months but the average quantity run is about 600 higher during the warm months. I also noticed that 73% of the bent poles are Type 1T. Are you making the same products in the summer as the winter?

The histogram does show the beginning of a two hump process but there is not enough data to verify it. If you had another set of data from the prior year you may be able to draw a better conclusion.

Even if there is a winter temperature effect, you noted that the poles "are allowed to reach ambient indoors and outside temperature is negligible". Does that mean that someone is actually verifying the indoor ambient temperature is constant year round and that the poles have reached that ambient temperature before the dipping process?

Are the Type 1T poles more susceptible to bending if the temperatures are not at ambient before dipping?


Bill Pflanz
 

Tim Folkerts

Super Moderator
#4
Besides Steve's p-charts :agree1: and Bill's insightful comments about different size runs and potentially different types of poles in each month :agree1: , I tried a scatter plot of % bent vs average monthly temps for central Iowa this year. The correlation is R-Squared = 60%, which would also support the supposition that there is some correlation. The equation is
% bent = 4.71% - (0.0483%) x (monthly average temperature)

I just got ambitious and modified Steve's P-chart spreadsheet (by the way, nice spreadsheet) to predict each month's % bend based on the regression line. If you take as given that the temperature really does affect the % bent, then you can recalculate the baseline every month based on the changing prediction. With this, then no months are out of control (although March and August are close). I don't know that I have seen control charts done this way, but it seems to make sense.


Of course, you have to be careful about assigning a causal relationship. It you look at enough variables, there is a good chance of finding a correlation when none is truly present. There are also any number of factors that could be confounded with the seasonal change. As Bill suggests, if you had similar data back over the course of several years it would be much more convincing.

Tim F :agree1:
 

Attachments

Q

QCAce

#5
Thanks to all for the help.
I will take a crack at the t test tomorrow, but the P-chart helps show that something has changed.

I wish we did have more historical data, but that was my first task when I started last year, to get them to start collecting data. At that time all they could tell me was there seemed to be a bent pole problem.

As far as the 1T poles that Bill had asked about, yes 1T poles are the most suseptable. The are the thinnest poles. We also ship more 1T poles than any other size, so the Pareto wasn't too surprising. Summer is also our busiest time, it is a seasonal business so that is why I had to focus on % bent.

The supplier doesn't seem to think outdoor temperature is a factor. I'm not sure why, but they are the experts and so I can at least ask them to consider what other factors may have changed since the data is showing something has. The supplier seems to focus on stresses inherent to the steel when the poles are formed. The galvanization process then relieves those stresses, causing the poles to warp. Perhaps I'll ask them about the raw steel before the poles are formed, and maybe the colder raw steel will have more inherent stresses.

Thanks again.
 

bpritts

Involved - Posts
#6
Andy Nutt said:
The supplier seems to focus on stresses inherent to the steel when the poles are formed. The galvanization process then relieves those stresses, causing the poles to warp. Perhaps I'll ask them about the raw steel before the poles are formed, and maybe the colder raw steel will have more inherent stresses.

Thanks again.
Andy - two general areas of question.

1) What is the "form" of the pole? Is it asymmetrical? If so, then there may be some inherent distortions that happen from heating, even if the heating is very uniform.

2) what kind of fabrication processes are done in the manufacture of
the poles? It is true that you will get internal stresses from many processes; look in particular for operations that might heat the material asymmetrically,
e.g. welding. You won't be able to eliminate the internal stresses but
you can improve the situation by reducing the welding heat to the
minimum possible consistent with a good weld.

If you can explain more about the fabrication processes we may be
able to help specifically.

Regards,
Brad
 
B

Bill Pflanz

#7
Andy Nutt said:
The supplier doesn't seem to think outdoor temperature is a factor. I'm not sure why, but they are the experts and so I can at least ask them to consider what other factors may have changed since the data is showing something has. The supplier seems to focus on stresses inherent to the steel when the poles are formed. The galvanization process then relieves those stresses, causing the poles to warp. Perhaps I'll ask them about the raw steel before the poles are formed, and maybe the colder raw steel will have more inherent stresses.
The supplier may be the expert but thinking temperature is not a factor is not as good as knowing. It sounds like they could do some DOE work for you. I don't know what kind of analysis is done on your raw materials but you may want to check that data for the same time period to rule out any changes that may have caused the problem.

Based on your comments about T1 versus the other types, you may want to separate out the defect data and other analysis for T1. It may change the histogram and control chart analysis.

If you can be successful on your analysis on this problem, it will make it easier to get them to collect other data for you. The more data you can collect the more you can use it to identify problems that even they don't know exist by using control charting.

Good luck.

Bill Pflanz
 

Wes Bucey

Quite Involved in Discussions
#8
I tend to vote with Brad. My "gut" tells me if nothing is changing in your operation, something is different in the manufacture, handling, or storage of the bars before they get to you.

In the machining trade, I have seen 12 foot random length hex bars (cold drawn) have a 180 degree to 360 degree torsion twist from one end to the other as delivered from the mill. Sometimes a round bar will look like a strung bow because of bending. All are due from internal stress introduced during the bar forming process.

Are you buying from a distributor or a mill? This is a situation which should be referred back to mill metallurgist.

If these "poles" are welded tubing, certainly the forming and welding process can be causing this. If they are extruded, there are myriad opportunities for introducing stress.

I can't think of anything in your operation which would account for this condition.
 
Last edited:
Q

QCAce

#9
The poles start out as flat sheet, coiled steel. So one form of stress is in the raw coils. On the outside of the coils the steel is wound less tight. The steel is unrolled and cut into trapezoidal shapes. Two trapezoids are cut in opposite directions (end-to-end) from the same section of the coil. They do try to stay in the middle section of the coil and away from the outside ends.

Each trapezoid is then rolled around to form the tube, (one end will have a larger diameter than the other), the seam is welded along the length of the tube and then I believe the last operation is cold-working. The tube is slipped over a solid form and rotated as rollers work along the length.

So there a lot of opportunities for stress to be induced, and then relieved in the galvanization process. Wes is correct in that when the poles bend, the take the shape of a bow. However, we are only talking about .5" - 1.0" of bow across a 30 ft tube.

The process is the same throughout the year, so it still seems strange to me that the amount of bow would double during the winter months as the trend shows.

Thanks for the input.
 
Q

QCAce

#10
Interesting side note. I was informed that the Bismuth content of the galvanizing agent was increased from .080 to .100 around 10/01/04. I'm not a chemical engineer but I'm beginning to also wonder about the impact of the chemical make-up of the galvanizer.
I've asked for previous dates and chemical composition changes from our supplier.
 
Thread starter Similar threads Forum Replies Date
M Device mounted at IV pole - what about mechanical stability testing? IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
Sidney Vianna Honda Racing F1 Team takes environmental pole position World News 9
C Sunrise at the South Pole Coffee Break and Water Cooler Discussions 9
J Need Help with FPY Data in Assembly Process Manufacturing and Related Processes 7
Q AMS 2750 E or F Continuous Furnace TUS Data Collection AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
M Reduce occurrence rating based on the PMS data and customer complaint data ISO 14971 - Medical Device Risk Management 2
J Customer Complaint & SCAR, false data Nonconformance and Corrective Action 14
Brizilla Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
D Safety data sheets software REACH and RoHS Conversations 2
M Data Protection and Privacy Policy - looking for a template/example EU Medical Device Regulations 1
S Non parametric test for semi-quantitative data. Statistical Analysis Tools, Techniques and SPC 5
M Disabling measurement data during fault conditions IEC 60601 - Medical Electrical Equipment Safety Standards Series 5
C EU MDR - Annex II 6.1 Pre-clinical and clinical data EU Medical Device Regulations 4
P Ppk results shown as asterisk after the transformation of Non-normal data Using Minitab Software 4
lanley liao How to correctly understand the bullet list d) of 6.3 Analysis of Data for API Spec Q1 Oil and Gas Industry Standards and Regulations 7
Steve Prevette Informational I am presenting a webinar Thursday - "Data Driven Decision Making" - 19 November 2020 Statistical Analysis Tools, Techniques and SPC 5
qualprod Best practice to ensure inputting of data in production Lean in Manufacturing and Service Industries 19
D Preservation of Electronic Data / Information Technology ISO 13485:2016 - Medical Device Quality Management Systems 5
M Comparing data from destructive testing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7
DuncanGibbons Technical Data Package vs Digital Product Definition APQP and PPAP 0
Z Putting back excluded rows/data points in a control chart Using Minitab Software 0
F General Data Protection Regulation (GDRP) CE Marking (Conformité Européene) / CB Scheme 6
Z Minitab - Updating Graph with specific data points Using Minitab Software 2
E PEMS Hazards - IEC 60601 Clause 14.6 - Internal data use - Pressure sensor IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
K Transform variable data into attribute data Reliability Analysis - Predictions, Testing and Standards 24
R Clinical evaluation without clinical data - MDR Article 61(10) EU Medical Device Regulations 8
H Capability Data for Paint Thickness on Painted Parts Statistical Analysis Tools, Techniques and SPC 10
D BS EN 62304 - Medical-Relevant Data C.5 - Definition of IEC 62304 - Medical Device Software Life Cycle Processes 5
T Submitting MR Compatibility Data for 510(k) Cleared Device Other Medical Device and Orthopedic Related Topics 2
S Quality manager considering data science Quality Manager and Management Related Issues 19
A What are Practical data center best practices IEC 27001 - Information Security Management Systems (ISMS) 1
U Do we need clinical trial data for Class IIa medical device under MDR EU Medical Device Regulations 7
S Average and standard deviation of Cumulative Data Statistical Analysis Tools, Techniques and SPC 5
V IS/ISO/IEC 17025:2017 Clause 7, sub clause 7.11 Control of data and information management ISO 17025 related Discussions 1
Watchcat CERs Literature Databases - Searching for data to evaluate EU Medical Device Regulations 16
D Transformation of Data Normality Failed Using Minitab Software 11
J Sample size for creating a data base as a reference to a tested variable Other Medical Device and Orthopedic Related Topics 6
M GUDID data deficiency communication - IS THIS A SCAM? ISO 13485:2016 - Medical Device Quality Management Systems 29
H Question about implications of performing Firmware upgrade via MDDS - Medical Device Data Systems 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
R Demonstrate how sufficient levels of access to data is achieved - Claims of equivalence EU Medical Device Regulations 3
R Material safety data sheet (MSDS) related clause in IATF 16949 manual IATF 16949 - Automotive Quality Systems Standard 17
CPhelan Using clinical trial safety data for evidence for CE marking EU Medical Device Regulations 8
M Informational US FDA – MDR Data Files – Alternative Summary Report Data Since 1999 Available Medical Device and FDA Regulations and Standards News 0
CPhelan Do you require MDSAP for CE Marking of a Medical Device or is ISO13485:2016 with clinical data sufficient? CE Marking (Conformité Européene) / CB Scheme 6
M Data analysis Design of Experiments Using Minitab Software 3
silentmonkey Seeking efficient method to manage install base data Manufacturing and Related Processes 0
V Every good documentation practice observation is an data integrity issue US Food and Drug Administration (FDA) 7
M Informational US – National Evaluation System for Health Technology Coordinating Center (NESTcc) Solicits Public Comments for Data Quality and Methods Frameworks Medical Device and FDA Regulations and Standards News 0
M Informational Eudamed Data Exchange Guidelines Medical Device and FDA Regulations and Standards News 0
M Informational EU – Eudamed Data exchange services and entity models introductions Medical Device and FDA Regulations and Standards News 4

Similar threads

Top Bottom