S

srands

Anybody got an EXCEL spreadsheet to calculate the est. approx AMPAGE of the RING CIRCUIT socket wire from just the following?:

~ SKT WIRE lengths from skt to skt, and last skt to fusebox
~ MAXIMUM AMPAGE of each skt


Eg:
Skt A to B = 10M's
Skt B to C = 5M's
Skt C to D = 3M's
Skt D to A = 7M's

Skt A ampage = 5A
Skt B ampage = 3A
Skt C ampage = 10A
Skt D ampage = 7A


I'm aware of Kirchoff (http://www.voltimum.co.uk/files/gb/others/0/20100106819Kirchoff-Ring.pdf See Pgs 2-4), but I can't be bothered to do that everytime.

I want just a simple spreadsheet :cool: to enter:
the METRES OF SOCKET WIRE and
the AMPAGE MAXIMUM AT EACH SOCKET,
to calc the RING CIRCUIT AMPAGE of the SKT WIRE.

I know there is software to do this, but surely this can be sorted into XL formulas easily.

Cheers


Stephan
 
Last edited by a moderator:

Similar threads

S
Replies
41
Views
5K
P
S
Replies
52
Views
12K
Australia
ecclescake
E
S
Replies
34
Views
8K
Australia
Silly Sausage
S

OFFICIAL SPONSORS

Electrical Goods - Electrical Tools - Brand Names Electrician Courses Green Electrical Goods PCB Way Electric Underfloor Heating Electrician Courses Heating 2 Go Electrician Workwear Supplier
These Official Forum Sponsors May Provide Discounts to Regular Forum Members - If you would like to sponsor us then CLICK HERE and post a thread with who you are, and we'll send you some stats etc

Advert

Daily, weekly or monthly email

Thread Information

Title
RING AMPAGE xl AUTOCALC for maximum estimated ampage of skt wire
Prefix
N/A
Forum
Australia
Start date
Last reply date
Replies
20
Unsolved
--

Advert

Thread statistics

Created
srands,
Last reply from
SMB,
Replies
20
Views
3,547

Advert