Electrical Design Calculations - based on IEC / IEEE Standards 1

[SK07]

Looking for some reliable website which provides ''Electrical Design Calculations - based on IEC / IEEE Standards'' in excel format preferably for: Earthing calculations, cable sizing calculations, Lighting calculations, Transformer sizing, etc.

Kindly help by providing web link.

 

[JezNZ]

You might find some things under Engineering Spreadsheets section. Electrical Engineering Portal has some useful stuff, but I suspect the common answer will be, research the applicable standards and write your own.

In my experience (limited as it may be) very few engineers write "universal" calculators, most are designed for a specific purpose in mind at the time they are needed, and as such those limitations will impact you in ways that you are unaware unless you rebuild it yourself from scratch, how else can you verify your calculations?

 

[Gr8blu]

As JezNZ noted, it will be (very) hard to find a universally-applicable reliable calculation format that is disseminated on the internet. You might find something that works over a fairly narrow range - which might or might not work for your specific project(s).

Most of us don't mind teaching younger engineers the practical "rules of thumb" we have accumulated over the course of our experience. We may (or may not) choose to teach you the physics behind the rules - often, we tend to assume you already know the science and math.

To that end, we are usually a bit leery of providing "one size fits all" answers such as universal calculators for public consumption - because most of the time, the determination of whether a particular result is "good enough" depends on engineering judgement and experience.

Converting energy to motion for more than half a century

 

[cherryg]

After working in the industry for 30 yrs, many of us have our own personal libraries of spreadsheets, which we unleash at the right time. Try to develop your own sheets based on your requirement. If you are working in consulting engineering, you should be having access to most of these spreadsheets.

 

[davidbeach]

Anybody else's spreadsheet that's complex enough that you couldn't build your own in an hour or less is probably full of unstated assumptions and other traps.

The spreadsheet could deal with various sets on inputs; say there are three things with three options each; call them a,b,c; d,e,f; and g,h,i. While all nine can be used in various combinations, the spreadsheet may only get 23 or 24 of the combinations right. The designer having decided that the rest are non-credible combinations, and them being so non-credible that there's no error trapping for them. But you start using it and you think that one of those heretofore non-credible combinations is a nifty solution to something. The results may be other than what's desired. You may have gotten so many good results for combinations that were anticipated that you entirely miss the mess-up made when you picked that combination.

And you own the results. The spreadsheet author has no liability, it's all on you. Far better to write your own. Debug it yourself. Understand what assumptions went into it. Know what cases produce rock solid results vs. what cases might need additional verification vs. what cases should just be completely avoided.

I’ll see your silver lining and raise you two black clouds. - Protection Operations