Need Help. New to excel

[tazpyro1]

Need help comimg up with a function that can get the wire size by using the wire type and amps					Wire types
				Wire Size	60°C (140°F)	75°C (167°F)	90°C (194°F)
Wire Type	Amps	Wire Size		AWG/ KCMIL	TW	UF	RHW	THHW	THW	THWN	XHHN	USE	ZW	TBS	SA	SIS	FEP	FEPB	MI	RHH	RHW-2	THHN	THHW	THW-2	THWN-2	USE-2	XHH	XHHW	XHHW-2	ZW-2
THHN	125			18										14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14	14
				16										18	18	18	18	18	18	18	18	18	18	18	18	18	18	18	18	18
				14	15	15	20	20	20	20	20	20	20	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25	25
				12	20	20	25	25	25	25	25	25	25	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30	30
				10	30	30	35	35	35	35	35	35	35	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40	40
				8	40	40	50	50	50	50	50	50	50	55	55	55	55	55	55	55	55	55	55	55	55	55	55	55	55	55
				6	55	55	65	65	65	65	65	65	65	75	75	75	75	75	75	75	75	75	75	75	75	75	75	75	75	75
				4	70	70	85	85	85	85	85	85	85	95	95	95	95	95	95	95	95	95	95	95	95	95	95	95	95	95
				3	85	85	100	100	100	100	100	100	100	115	115	115	115	115	115	115	115	115	115	115	115	115	115	115	115	115
				2	95	95	115	115	115	115	115	115	115	130	130	130	130	130	130	130	130	130	130	130	130	130	130	130	130	130
				1	110	110	130	130	130	130	130	130	130	145	145	145	145	145	145	145	145	145	145	145	145	145	145	145	145	145
				1/OT	125	125	150	150	150	150	150	150	150	170	170	170	170	170	170	170	170	170	170	170	170	170	170	170	170	170
				2/OT	145	145	175	175	175	175	175	175	175	195	195	195	195	195	195	195	195	195	195	195	195	195	195	195	195	195
				3/OT	165	165	200	200	200	200	200	200	200	225	225	225	225	225	225	225	225	225	225	225	225	225	225	225	225	225
				4/OT	195	195	230	230	230	230	230	230	230	260	260	260	260	260	260	260	260	260	260	260	260	260	260	260	260	260
				250	215	215	255	255	255	255	255	255	255	290	290	290	290	290	290	290	290	290	290	290	290	290	290	290	290	290
				300	240	240	285	285	285	285	285	285	285	320	320	320	320	320	320	320	320	320	320	320	320	320	320	320	320	320
				350	260	260	310	310	310	310	310	310	310	350	350	350	350	350	350	350	350	350	350	350	350	350	350	350	350	350
				400	280	280	335	335	335	335	335	335	335	380	380	380	380	380	380	380	380	380	380	380	380	380	380	380	380	380
				500	320	320	380	380	380	380	380	380	380	430	430	430	430	430	430	430	430	430	430	430	430	430	430	430	430	430
				600	350	350	420	420	420	420	420	420	420	475	475	475	475	475	475	475	475	475	475	475	475	475	475	475	475	475
				700	385	385	460	460	460	460	460	460	460	520	520	520	520	520	520	520	520	520	520	520	520	520	520	520	520	520
				750	400	400	475	475	475	475	475	475	475	535	535	535	535	535	535	535	535	535	535	535	535	535	535	535	535	535
				800	415	415	490	490	490	490	490	490	490	555	555	555	555	555	555	555	555	555	555	555	555	555	555	555	555	555
				900	435	435	520	520	520	520	520	520	520	585	585	585	585	585	585	585	585	585	585	585	585	585	585	585	585	585
				1000	455	455	545	545	545	545	545	545	545	615	615	615	615	615	615	615	615	615	615	615	615	615	615	615	615	615
				1250	495	495	590	590	590	590	590	590	590	665	665	665	665	665	665	665	665	665	665	665	665	665	665	665	665	665
				1500	525	525	625	625	625	625	625	625	625	705	705	705	705	705	705	705	705	705	705	705	705	705	705	705	705	705
				1750	545	545	650	650	650	650	650	650	650	735	735	735	735	735	735	735	735	735	735	735	735	735	735	735	735	735
				2000	555	555	665	665	665	665	665	665	665	750	750	750	750	750	750	750	750	750	750	750	750	750	750	750	750	750

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col span="24"></colgroup>

 

[tazpyro1]

Any suggestions?

 

[FDibbins]

the data you posted is confusing. Try posting a smaller sample that will fit onthe screen

 

[tazpyro1]

Wire Type	Amps	Wire Size		AWG/ KCMIL	TW	UF	RHW	THHW	THW	THWN	XHHN	USE	ZW	TBS	SA	SIS	FEP	FEPB
THHN	125			18										14	14	14	14	14
				16										18	18	18	18	18
				14	15	15	20	20	20	20	20	20	20	25	25	25	25	25
				12	20	20	25	25	25	25	25	25	25	30	30	30	30	30
				10	30	30	35	35	35	35	35	35	35	40	40	40	40	40
				8	40	40	50	50	50	50	50	50	50	55	55	55	55	55
				6	55	55	65	65	65	65	65	65	65	75	75	75	75	75
				4	70	70	85	85	85	85	85	85	85	95	95	95	95	95
				3	85	85	100	100	100	100	100	100	100	115	115	115	115	115
				2	95	95	115	115	115	115	115	115	115	130	130	130	130	130
				1	110	110	130	130	130	130	130	130	130	145	145	145	145	145
				1/OT	125	125	150	150	150	150	150	150	150	170	170	170	170	170
				2/OT	145	145	175	175	175	175	175	175	175	195	195	195	195	195

<colgroup><col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 48pt;" width="64"> <col style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;" width="72"> <col style="width: 48pt;" width="64"> <col style="width: 86pt; mso-width-source: userset; mso-width-alt: 4169;" width="114"> <col style="width: 48pt;" width="64"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 48pt;" span="12" width="64"> <tbody>
</tbody>

 

[farmerscott]

Hi,

1. can we assume that the amps will not vary from 125? Am I reading this correctly?
2. is 18,16,14 the wire size (1st column in main table)? or is the wire size in the body of your table?
3. are the wire types in the top rows?
4. is this to do with MIG wire and welding?

Farmerscott

 

[tazpyro1]

The amps will change. I am an Electrical student. If you look in the NEC2011 code book. Table 310.15b16. wire type are the top row. What I am looking for is something that will search wire types, go down to the amps (what ever they are under that wire type and then go back to the wire size column and pick the correct size. Also the 1/ot-4/ot in the code book reads this way 1/0,2/0,3/0,4/0 but when I put it in it comes as a date

 

[farmerscott]

So what you want is an input box where you can put in the 'amps' and 'wire type' and it will reference automatically the correct size? Yes/No
Can you write VBA code??

Is the column AWG/KCMIL a wire type or the wire size?
What does the 125amps represent (top left of your table)?? Are there multiple tables for each amp setting?? Or are the amp settings from 14-195 (as per the body of your table)??

Farmerscott

 

[tazpyro1]

You are correct. No I have no idea what vba code is. the AWG/KCMIL column is the wire size. 18- 4/0 would be worded as 18awg,16awg. The 250-2000 is kcmil 250kcmil. the 125amp is the maximum current that wire size is designed to take. The type in the wire type is actually the rating of the insulation. If you see there are 3 different degree columns 60deg.' 75deg, and 90deg. The currents each wire can take changes with the insulation type.
So if you look at #14awg in the 60° column it can take upto 15amps were as in the 90° column it can take upto 25amps.