Can you use call horizon and shift factors in multiple counter plan?

1108

We have drive feeding an output contactor for a 5000 hp motor @ 5kV application. The motor FLA is 629amps x 1.25% service factor = 786.25 amps The cable that we current have in place between the drive and the output contactor is 350kcmil- MV-105 (parallel cables). Per the NEC table 310.60 (C) (69). This show the cable ampacity is at 615 amps per cable for a rating of 1230 amps. We have derated the cable for the cable tray and the multiple cables application and our calculations show that after the correction factor factor we are at 922amps. 1230 amps x .75% correction factor factor = 922.5 amps. The customer is driving us to then use another safety factor of .25% off of the already derated cable. Can you please provide a longhand calculation for your solution on this application?

2198

Hi, I am new in oracle(SQL), could anyone help me in writing a correct SQL. Below is the table structure. Table: Subsc Fields: 1. Sub_no (this field will hold values of subscriber nos, for e.g. S111111, S222222, S333333, S444444, etc.) 2. s_status (this field will hold values for different status of subscriber, for e.g. 'A', 'S', 'C', etc.) 3. cus_id (this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) Table: Bill Fields: 1. Bill_no this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) 2. b_status = (this field will hold values for different status of bill for e.g. 'O', 'C', 'S', etc.) Note: 1. The Sub_no is a Primary key of Subsc table. 2. The cus_id is a foreign in Subsc table (referred from Bill_no field of Bill table) 3. The Bill_no field is the Primary key of Bill table. Query A --> I wrote a query to select cus_id/Bill_no which is in status open (b_status = 'O') and having more than two active subscriber (i.e. S_status = 'A') in it ( i.e. more the two subscribers in same bill). select s.cus_id from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id having count(sub_no) = 2 Problem : The above query will give the cus_id (or rather bill_no) which are in open status (b_status ='O) and which are having TWO ACTIVE Subscribers (s_status ='A') in it. However, this query will also lists the cus_id/bill_no which are having more than TWO subscribers in it (but only two subscriber will be in Active status (s_status = 'A') and the others will be in s_status = 'C' or s_status = 'S'. Help needed: I want to write a query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it. B--> If I include the sub_no in the above query then NO row are returned. select s.cus_id, s.sub_no from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id, s.sub_no having count(sub_no) = 2 Help needed: I want to modify the above query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it ALONG with the sub_no. Thanks a lot in advance. Regards, Nitin

2407

What is NEFT?

1116

What do know about sap hana?

97

Tell me how to verify tooltip text using selenium?

933

What is the different between brass and bronze ?

1156

Explain the netscalar one-arm mode deployment model.

1041

What is the maximum zoom size in powerpoint?

399

What is difference between for and foreach in c#?

1053

What is database replication? What are the different types of replication you can set up in sql server?

1017

Can you cancel chkdsk?

890

Where is the microsoft edge executable located?

1078

Explain how the system can automatically determine the item category in the sales order.

1182

What file type is the safest to open?

1004