Shrinkage percentage data from plastic part

I am working on some shrinkage study on plastics part. I got the customer numbers rows 1 and 2 and a 3 row with the Solidworks design numbers, and need to create the percentage with these 3 rows , can you help me with the rigth formula.

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thread will be moved to the correct sub-forum.

The title is better - thanks.

Where have you mocked up what you want? Your workbook does not seem to show what you are describing.

Ok the customer have a injection mold with 2 cavitys, and the one row you the parts specification nunbers , the next 2 are what they measure.
The 3erd row is what the design steel number.
And need to know the best formula to obtain b the se on steel numbers and plastic data the shrinkage percentage.

What do you mean by 'row'? Are you in fact referring to columns?

What is wrong with the formula you are already using?

What does this mean:

to obtain b the se on steel numbers and plastic data the shrinkage percentage

What is b? What is se?

Clear as mud ...

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H
1	Specification Number	Record Specification	1	2	Accept	Reject	Part Design	Shrinkcage rate %
2	20	.333+/-.005	0.33	0.331			0.329	-0.456%
3	21	.25+/-.001	0.2405	0.2505			0.2389	-2.763%
4	22	.25+/-.001	0.2505	0.2405			0.2389	-2.763%
5	23	.330+/-.005	0.33	0.33			0.329	-0.304%
6	24	.49+/-.001 x2	.49-.49	.49-.48			0.49	#VALUE!
7	25	2.923+/-.005	2.923	2.923			2.923	0.000%
8	26	3.104+/-.005	3.104	3.104			3.104	0.000%
9	27	4.854+/-.005	4.854	4.854			4.854	0.000%
10	28	.333+/-.005	0.332	0.333			0.329	-1.064%
11	29	.333+/-.005	0.332	0.332			0.329	-0.912%
12	30	2.632+/-.005	2.631	2.63			2.639	0.322%
13	31	4.897+/-..005	4.895	4.896			4.895	-0.010%

Sheet: Sheet1

b is the part should measure

se refering to ? Did not understand sorry

Still as clear as mud ...

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

Originally Posted by raulob72

se refering to ? Did not understand sorry

Well, you said it!

to obtain b the se on steel numbers and plastic data the shrinkage percentage

No bother - I just needed clarity. You didn't give it, so it was impossible for me to help you.