S
srands
Hi, here are my two XL fusebox rcd: MCB & skt wire autocalc's. 
FUSEBOX CONSUMER UNIT with 1 RCD: MCB and SKT wire AUTOCALC
Stephan Rands' Website
FUSEBOX CONSUMER UNIT with 2+ RCDS: MCB and SKT wire AUTOCALC
Stephan Rands' Website
Edit to suit. Both have examples. The file sizes are a bit big at 0.8mb's each, so recommend, SAVE file, then OPEN.
Simply edit fusebox mcb amps/watts (R/H of spreadsheet, columns N and O), then add in list your lighting, skts/appliances (L/H of spreadsheet, columns A to F).
I like these, give me your comments if you like these XL spreadsheets. Or post your edits!
Functional note:
If MCB max NOT exceeded, but want to start next MCB, then calculate DIFFERENCE between the MAX WATTs of that MCB, and that MCB's running total, then enter misc line for that WATTs amount.
EG: 6 "a" running total = 1300. 6 "a" Watts Max = 1440 . 1440 - 1300 = 140 Watt's difference.
HENCE: misc line, 140 Watts (See included examples, very easy to follow)
I'm sure there are programs or other spreadsheets that do this as well, but I haven't seen any. Anybody know what computer program (A name of a program and software developer,would be great) is used by many electrical and/or building contactors? As imagine in huge buildings like sky scrapers or department stores, it won't be known what appliances will be used, and for how long. So how do they estimate MAX WATTs for each MCB circuit, per SOCKET? I guess they have SOCKET AVERAGE MAX per square metre of different type rooms, for example: kitchen, call centre, board room, offices, etc.
If you like those, let me know if you think they are great, or upload a copy, of how you've tweeked these to your liking.
Cheers
Stephan Rands
Also my other most excellent spreadsheets (etc) see the following:
MY COMPREHENSIVE ELEC WATER GAS NRG UTILITY METER COST CALC, 1ST TAB, SCROLL DOWN
Stephan Rands' Website 1st tab, scroll down
EXAMPLE OF SIMPLE ELEC/WATER/GAS CALCULATOR ON MONEY TIER SPREADSHEET 2ND/3RD/4TH TAB
FUSEBOX CONSUMER UNIT with 1 RCD: MCB and SKT wire AUTOCALC
FUSEBOX CONSUMER UNIT with 2+ RCDS: MCB and SKT wire AUTOCALC
LIGHTING CIRCUIT DIAGRAMS
RING & RADIAL SKT DIAGRAMS
MULTIMETER GUIDE
FUSEBOX CONSUMER UNIT with 1 RCD: MCB and SKT wire AUTOCALC
Stephan Rands' Website
FUSEBOX CONSUMER UNIT with 2+ RCDS: MCB and SKT wire AUTOCALC
Stephan Rands' Website
Edit to suit. Both have examples. The file sizes are a bit big at 0.8mb's each, so recommend, SAVE file, then OPEN.
Simply edit fusebox mcb amps/watts (R/H of spreadsheet, columns N and O), then add in list your lighting, skts/appliances (L/H of spreadsheet, columns A to F).
I like these, give me your comments if you like these XL spreadsheets.
Or post your edits!Functional note:
If MCB max NOT exceeded, but want to start next MCB, then calculate DIFFERENCE between the MAX WATTs of that MCB, and that MCB's running total, then enter misc line for that WATTs amount.
EG: 6 "a" running total = 1300. 6 "a" Watts Max = 1440 . 1440 - 1300 = 140 Watt's difference.
HENCE: misc line, 140 Watts (See included examples, very easy to follow)
I'm sure there are programs or other spreadsheets that do this as well, but I haven't seen any. Anybody know what computer program (A name of a program and software developer,would be great) is used by many electrical and/or building contactors? As imagine in huge buildings like sky scrapers or department stores, it won't be known what appliances will be used, and for how long. So how do they estimate MAX WATTs for each MCB circuit, per SOCKET? I guess they have SOCKET AVERAGE MAX per square metre of different type rooms, for example: kitchen, call centre, board room, offices, etc.
If you like those, let me know if you think they are great, or upload a copy, of how you've tweeked these to your liking.
Cheers
Stephan Rands
Also my other most excellent spreadsheets (etc) see the following:
MY COMPREHENSIVE ELEC WATER GAS NRG UTILITY METER COST CALC, 1ST TAB, SCROLL DOWN
Stephan Rands' Website 1st tab, scroll down
EXAMPLE OF SIMPLE ELEC/WATER/GAS CALCULATOR ON MONEY TIER SPREADSHEET 2ND/3RD/4TH TAB
FUSEBOX CONSUMER UNIT with 1 RCD: MCB and SKT wire AUTOCALC
FUSEBOX CONSUMER UNIT with 2+ RCDS: MCB and SKT wire AUTOCALC
LIGHTING CIRCUIT DIAGRAMS
RING & RADIAL SKT DIAGRAMS
MULTIMETER GUIDE
Last edited by a moderator:
