Skilled at PSCAD,PSSE,Bentley Substation,AutoCad,ETAP,DIALux,CDEGS,ArcGIS,Microsoft Excel and others utility tools. Move groups of connected equipment as units to change positions quickly. (Including loss of mains relays such as G59/3 protection for soft mains return and short-term paralleling) 11kV substations/ transformers/ switchboards (fixed pattern and demountable). These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on. Calculator using Excel VBA UserForm. • Prepares thorough and accurate technical reports, correspondence, documentation, calculations and sketches. This is the first calculation that we need to do as this will give us the multiplier. In order to make the calculations transparent, the input parameters, as well as the relevant interim results, are also output to Excel table. The change of voltage over distance (potential gradient) may be so high that a person could be injured due to the voltage developed between two feet, or between the ground on which the person is standing. So 200/5 = 40. Hand Calculations Design It is important to use the hand calculations method in the substation grounding grid design because it allows us to get the appropriate distance between conductors. Figure 2: Instantaneous (or point) availability plot. 1: Life cycle of an electrical network. Abstract—The most critical component of a protection, con-trol, and monitoring system is the auxiliary dc control power system. Fundamental Design Calculations for Electrical System and ArchitectureFull description. improve a design of grounding grid with vertical rods that achieve the convenient values of (R g, V t and V s) with the minimal cost of design. When calculating short circuit currents, there are usually many impedances that must be added together. doc: wastewater design calculation. 16-3 PEAChecklist section 3. Steel Structure Design and Drawings for Switchyard We provide design and engineering services for lattice and pipe type steel structures for transmission line towers, substation gantry towers, beams, lightning masts, lighting towers and EHV equipment support structures in outdoor type switchyards upto 400kV. ENGINEERING AND DESIGN CALCULATIONS No. Performing substation design calculations and analysis; such as short circuit stand, ground grid analysis & design, lightning protection, voltage drop and AC & DC station service sizing Work closely with Civil Engineering department to develop substation foundation and structure drawings. Excel Output. Details Name Design Calculation of Substation Building Pages 1868 Format PDF Size 12 MB Download Method Direct Download Download. Three 115-kV transmission lines delivered electricity to the substation, which then stepped down the voltage and sent it out to the state's capital to nearby smaller substations. cannot, in any case, be less than that necessary for the neutral, as discussed in Sizing the neutral conductor. (SECTION 11: LOAD-FLOW ANALYSIS IN POWER SYSTEMS)Galli, Anthony W. 2)Plates and the ASCE Substation Structure Design guide for the wind loading. An Excel spreadsheet using the equations developed in this article is also provided. Furthermore, the protection calculations can be applied to buildings, illustrated by the example below of a Gas Insulated Substation (GIS). ABB RED670 Fault Locator Calculations. Spreadsheets can do basic calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes. Formulas are self-defined instructions for performing calculations. Calculations and Design July/August 2018 James Phillips Reading Time: 5 minutes An infinite bus short-circuit calculation can be used to determine the maximum short-circuit current on the secondary side of a transformer using only transformer nameplate data. ppt: wastewater design calculation. Code of Practice No. Checks fence, foundation, and steel layout detail drawings. How we are doing calculations, clear the text, etc. Connection Design 18 4. Perform system studies, provide protection requirements for design, review and sign off one-line, elementary, logic diagrams and work with other discipline engineers - substation engineers, transmission engineer, project engineers, apparatus engineers - to support transmission and distribution substation expansion, substation automation and. Excel Formulas. For reliable protection and control of all types of power transformers and reactors. Touch Voltage & Ground Current Calculation Excel Sheet File Size: 99 Kb Touch Potential is the potential that can be established between the point at which a person is standing on the ground and the point at which some contact is made with hardware, such as by placing the hand on a substation fence. road construction estimating EXCEL spreadsheet. Find required post footing sizes for a variety of fence and soil conditions. I suggest you take notes on any questions you get incorrect. This allows for rapid and consistent protection calculations even for large substations (see the 21-bay Switchyard below). Move groups of connected equipment as units to change positions quickly. A forumla is nothing more than an equation that you write up. 2: 2- Electrical Sub-station No. Design of Earthing System for 400 KV AC Substation: A Case Study 229 2. 2 Needs of transformer short-circuit current calculation Today more than ever before, the electricity grid is developing so quickly — the power plant capacity, the substation capacity and electricity loads, as well as load density, sustainably grow. Typical urban secondary distribution system See more General recommendation is to properly design and implement the facility's grounding system to avoid unwanted involvement of ground loops with the operation. Covers the layout considerations, bus configurations, and electrical clearances. The substation design manual is not intended to replace Asset Management Standards, but rather to act as a reference document that cross-references existing standards and process documentation and plugs any gaps where Asset Management documentation does not exist. and Regulations. Substations. Substation Design Suite™ (SDS) consists of two powerful electrical substation design modules. • Assist in the continued development of both Company and Client standards to provide guidelines for future project planning and design • Perform basic functions of Microsoft Excel, Word, PowerPoint, and Outlook. Pheladi M has 5 jobs listed on their profile. Post Insulator Sizing. FAULT LEVEL CALCULATION Dinesh Kumar Sarda 2. This paper presents the design of earthing system for 132 KV substations and simulation for calculation of required parameters. A stair is composed of a set of steps. ABB RET670 Calculations. View Edvard Csanyi’s profile on LinkedIn, the world's largest professional community. See the complete profile on LinkedIn and discover Sudipta’s connections and jobs at similar companies. Use the Insert Function button under the Formulas tab to select a function from Excel's menu list: =COUNT(B4:B13) Counts the numbers in a range (ignores. Rigid-bus structures for outdoor and indoor, air-insulated, and alternating-current substations are covered. shows typical ranges for several commonly used operational activated sludge waste water. Except for high-threat scenarios associated with military and diplomatic facil -. in MS-Excel for the purpose of analysis. Design of Sewage Pumping Stations by John Zoeller, PE, CEO/President This article provides guidelines for designing municipal pumping systems. Presently working as Head Substation Design in Sterlite Power. This includes positioning of equipment, bus design, design of manholes, conduits and auxiliary A/C power system as well as selection of D/C batteries, battery charger and other. Thompson, Schweitzer Engineering Laboratories, Inc. Conductor Design - Aluminum and Copper Bus Bar Ampacity Charts. Design of Slab(Two Way) Excel Sheet. In IEEE Standard 605, it is concluded that assumption. plant, busbars and stranded conductorfor s to gain benefits in design, maintenance and operation during the service life. ASDIP FOUNDATION is a structural engineering software utilized by engineers for concrete footings design, such as spread footings, strap footings, and combined footings, per the latest ACI 318 provisions. iii) Code of practice for the protection of buildings and allied structures against lightning IS - 2309 - 1989. • Development AC and DC loading calculations, building services, cable list, signal list, ventilations calculations and schematics for Srahnakille/Oweninny Substation • Detailed design of full electrical balance of plant for Booltiagh 110kV substation extension. These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop. each facility a design capacity, average monthly flow rate over a 20-year period and design flow rate exceedance level of 30% are assumed. I have a project of 220/150 kv substation and it exist one power transformer and going to make extention of another transformer 160 MVA, also it exist Earthing mat for the existing Transformer but is needing earthing mat for the new transformer i used your xls tool for making the design of the earth mat , but the specifications of my project is. Covers bare conductors, rigid and strain bus design. 415kV transformer. Assist customer in acquiring easements, encroachments and permits as needed. Note: This formula has a breakdown point at approximately 300 amps of current. SUBJECT: Design Guide for Rural Substations TO: All RUS Borrowers RUS Electric Staff EFFECTIVE DATE: Date of approval. Volume II, Physical Layout. DNV KEMA Renewables, Inc. Eastern Simplistic Design Approach. • Development of all water pump feeding project (including single line. Free barcode label design and printing software, it can print bulk barcode labels with a laser or inkjet printer or professional barcode printer, to ordinary A4 or sticky label paper such as Avery 5160, 5161, etc. Performing substation design calculations and analysis such as short circuit stand, ground grid analysis and design, lightning protection, voltage drop and AC and DC station service sizing Working closely with the Civil Engineering department to develop substation foundation and structure drawings. Prepared by the ASCE Subcommittee on the Design of Substation Structures, this new manual offers current recommendations developed by substation structure designers. As a practical application an Excel-based program for calculating short-circuit effects is presented. Step by Step Instructions for Creating the Risk Assessment Template for Excel. Important Use this excel spreadsheet for AC Substation only, and don’t use it for Domestic, commercial and industrial premises. XLSForms provide a practical standard for sharing and collaborating on authoring forms. The calculation is iterative, and requires the use of Excel's Goal Seek. The intent of this calculator is to provide information pertinent to safe grounding practices in ac substation design. Highlights: Implementation of an off-the-shelf solution for Substation design which supports Electro-Mechanical, Civil and Electrical design. 92 m; Corrected SPT N1(60)~13 after Liao and Whitman 1986 Table ii : Soil layers from existing ground. Download CAD Block in DOC. Learn More Cable Pro (Web) Cloud-based edition of our popular cable-sizing software. Fence Foundation Calculator. If we look around we are surrounded by many things which illuminate our life with happiness electrical products are one of them we buyelectric with the vision to bring ease in electrical shopping of a common man we have added wide range of electrical products in our basket. • As a Team Leader, Lead & assist a team of Design Engineers to design & deliver the complete engineering drawings and documents for control & protection of Transmission AIS/GIS. This Excel spreadsheet models heat loss from an insulated pipe. There are three types of sewage handling systems: 1. Find required post footing sizes for a variety of fence and soil conditions. Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. With a sound understanding of the stringent requirements federal government projects face, we offer our clients a single source for strategy, design and implementation, and health and safety. You can create a simple formula to add, subtract, multiply or divide values in your worksheet. 3D visualization of the substation increases the overall accuracy of your designs and allows for early detection of possible safety risks, such as physical clearance issues. The cost calculations were made for both installation and materials which includes all single necessary equipment such as towers, conductors and insulator strings. Auxiliary DC Control Power System Design for Substations Michael J. DE-EE0005989. Reminder: Submit your 2019 injury and illness data by March 2. It's about creating a design to control a machine or process. RE: Earthing resistance and calculations EddyWirbelstrom (Electrical) 21 Aug 10 20:56 The data on rows 54 to 91 of the spreadsheet Eng-Tips_Thread238-279051-01. Design spill containment systems for large oil-filled electrical equipment for environmental compliance. XLSForm is a form standard created to help simplify the authoring of forms in Excel. This foundation design software substantially simplifies time-consuming calculations for structural engineering design. This report looks into the design of 500kVA ,11/0. Calculations are not only strings of mathematical manipulations; they also need to include a description of the assumptions used to establish the logic leading to a conclusion. Fault calculations are one of the most common types of calculation carried out during the design and analysis of electrical systems. We provide a range of powerful and easy-to-use electrical engineering software packages. The need for accurate preliminary estimates is never more apparent than in the electric power industry. The voltage rise at the bank location will apply to the entire line beyond that point. Design Calculations. Spreadsheets can do basic calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes. Process and. 2 TRANSMISSION LINE CONCEPTUAL DESIGN The transmission line cost estimates used in this study are based on a conceptual design. In Phase-I, a study of existing network and availability of space for the substation and lines (up to 11 kV) of the campus is to be carried out. Follow sanitation requirements to protect workers. Surge Arresters or Lightning Arresters discharge the over voltage surges to earth and protect the equipment insulation from switching surges and lightning surges. - Maintain plant equipment and drawing documents (all disciplines). The design includes design of grounding system according to general layout for substation. Substation Design Solution. But did you know we can also be found in mines. Steel Structure Design and Drawings for Switchyard We provide design and engineering services for lattice and pipe type steel structures for transmission line towers, substation gantry towers, beams, lightning masts, lighting towers and EHV equipment support structures in outdoor type switchyards upto 400kV. Touch Voltage & Ground Current Calculation Excel Sheet File Size: 99 Kb Touch Potential is the potential that can be established between the point at which a person is standing on the ground and the point at which some contact is made with hardware, such as by placing the hand on a substation fence. 39A To E:. Sag is defined as the different in level between points of supports and the lowest point on the conductor. Engineering Calculations 22 B. Electrical design without appropriate software and tools is impossible to imagine. - Voltage Drop and Short Circuit Calculations. In either case, all formulas and functions are entered in a cell and must begin with an equal sign '='. o Micosoft Excel including functions & Macros. 0 June 2012 3. In this article, I will share 18 design studies or calculations that will set you up to create a beautiful substation. Feel free to browse and try. Furthermore, the protection calculations can be applied to buildings, illustrated by the example below of a Gas Insulated Substation (GIS). Created panelboard schedules, lighting, cable tray, and grounding plan drawings extracted from 3d models using PD Draw. A retaining wall refers to a structure that is designed and built up to defend the lateral pressure of soil, when any alteration occurs in ground. Bus Duct Sizing Calculation Pdf. In addition, she / he has to coordinate with other departments including Inter-departmental checks covering, Electrical, Civil/ Structural, MEP and others. VA R A T I O Primary Secondary x x ÷ The ladder works on the primary side (replacing volt-amps for watts) by multiplying each step up the ladder and dividing each step down the ladder. The Birth of MV/LV Substation Transformer. Important Use this excel spreadsheet for Domestic, commercial and industrial premises only, and don't use it for medium and large electrical substations. ) above), along with branch circuits for any specific loads not covered in Article 220. 9 x 360 kips = 324 kips, the design flexural capacity of this. o Can interpret Electrical Engineering Calculations and Reports. Short circuit calculations should be done at all critical points in the system. Job Title: Electrical Design Engineer. Step1, 2 Step 3 Step 4, 5 Step 6, 7 Step 8, 9 Step 11. the columns are 300x300mm. - Design experience of electrical substation facilities including single line diagram ,layouts, ground system, buswork calculation, lightning protection calculation, lighting system calculation, Cable calculation, lightning arrester calculation-Able to work together with other engineers and individuals to solve problems. Das FGE (2005). Interim Results. Two-layer soil configuration plus surface material. 6400 and at t = 2,500 is 0. David Wilson, McLaren, Inc. Speed project collaboration and coordination with the only software that lets you unite electrical and physical design. To do that, hardware must be purchased and mounted on a back panel and then wired and integrated into the machine. Proper substation design calculation needs consistent research on the internet on the new available ideas on how to improve you skills as well as experience. Spreadsheets can solve complex problems, create charts and graphs, and generate useful reports. com Abstract. 39A To E:. XLSForm is a form standard created to help simplify the authoring of forms in Excel. - Earthing and lightning design. Substation battery sizing calculations keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. Today, I will introduce to you, the most powerful excel spreadsheet for Grounding System Design Calculations of Domestic, commercial and industrial premises. Download Foam Fire Extinguishing System Calculations Excel Sheet File Size: 236 Kb Design calculation sheet: 1- Electrical Sub-station No. Utility Line Design has over twenty-five planned calculations that will be added to the website at no added charge in the coming months. THE STEEL PROCESS – FROM DESIGN THROUGH ERECTION 10 A. Edvard has 4 jobs listed on their profile. Say a certain generation station generates power in voltage level 11KV, then if it has supply power to the grid which is of 132KV then the generating station will need a substation … Basic of Electrical Substation. The total number of branch circuits must be determined from the calculated load and the size or rating of the. Excel Output. INSTRUCTIONS: This bulletin is an update and revision of previous REA Bulletin 65-1, "Design Guide for Rural Substations" (revised June 1978). The change of voltage over distance (potential gradient) may be so high that a person could be injured due to the voltage developed between two feet, or between the ground on which the person is standing. Excel Download Spreadsheet Download. 39A To E:. This paper presents an overview of how the lightning strikes and their e ects on power distribu-. Here AOB is the transmission line conductor. Terminal marking of power transformers is determined by ANSI standards. Plinth beam and column RCC details 3. Introduction Calculation of peak storm water runoff rate from a drainage area is often done with the Rational Method equation (Q = CiA). • Prepares Design drawings and calculations with the use of Autodesk Robot Structural Analysis Software, Prokon, and Excel spreadsheets in accordance to client specifications and standards specifically with the use of Eurocode (British Standard European Norm). This is the solution that every engineer needs, because it offers open-source solution with powerful programmable tools, but on the other side simple enough to be done instantly. An information series from the national authority on concrete masonry technology NCMA TEK 14-21A (replaces TEK 14-21) 1 DESIGN OF CONCRETE MASONRY WALLS FOR BLAST LOADINGTEK 14-21A Structural (2014) INTRODUCTION Compared to the typical forces usually included in build- ing design, such as wind and seismic, there are many unique considerations involved in blast design. Enter the Data in the Excel Sheet. RCC Dog-legged Staircase design Excel Sheet. Dean of Engineering Emeritus, Union College. Three 115-kV transmission lines delivered electricity to the substation, which then stepped down the voltage and sent it out to the state's capital to nearby smaller substations. Part of the earth fault current will thus be diverted to a remote earthing grid via the cable armouring. 271 Substation Civil Design Engineer jobs available on Indeed. Now, in this section of the article, you will be able to get access to the Handbook of Civil Engineering Calculations PDF Free Download file in. Department: Electrical. Earthing Calculation Excel Sheet. Our Substation Design solution reduces the amount of time to complete design and minimizes errors that cause rework during construction. cannot be less than that of the phase conductors unless:. Substation Design Volume III Conductors & Bus Design Instructor: Lee Layton, P. Owner name should be written. Electrical substation is a utility where some special features like voltage level up & down, power factor correction, frequency up & down occurs. 07044/B including excavation for the gate columns, concrete works,erection and 3 coats of 1st grade gloss paint NO 2 A1 Ditto but pedestrian gates NO 2. Checks rough and finish grading drawings. How does an electrical substation work? Why is it known as a "substation?" Normally stations are where we catch trains or buses. Detailed Syllabus for Substation Design Course, Our Syllabus is Comprehensive,Structured and aim to build design career in EPC Companies,AEDEI Syllabus bases on the EPC Industries , All the Content and syllabus are realated to the industries, AEDEI is providing priactical projects on substration design. Download Foam Fire Extinguishing System Calculations Excel Sheet File Size: 236 Kb Design calculation sheet: 1- Electrical Sub-station No. 1: Life cycle of an electrical network. Substations. At its heart, Excel is a giant calculator. So, if there are 100 amps on the primary side of the CT. 2014 - Distribution transformer calculations spreadsheet provides determining the MV/LV transformer rating, calculating overcurrent protection device rating. Lightning masts: a. The intent of this calculator is to provide information pertinent to safe grounding practices in ac substation design. Each task uses a yellow triangle to indicate the start date of the task and a green down triangle to indicate the finish date of the task. Output in Excel. It is the ratio of actual kilowatt-hours used in a given period, divided by the total possible kilowatt -hours that could have been used in the same period, at the peak kW level established by the customer during the billing period. Find required post footing sizes for a variety of fence and soil conditions. 2 MV/LV transformer substations: theory and examples of short-circuit calculation 1 General information on MV/LV transformer substations 1. So 200/5 = 40. The results and tables are displayed quickly and clearly after each calculation. RCC Dog-legged Staircase design Excel Sheet. For such col-umns, the simple column-base-plate connection detail shown in Figure 1. Plinth beam and column RCC details 3. accordance with the substation design. it is rcc framed structure with isolated footing. Continue to learn and grow, and have some fun doing it. Today, I will introduce to you, the most powerful excel spreadsheet for Grounding System Design Calculations of AC Substation. Regularly check our 'News' page to keep up to date with the latest happenings in technology and engineering. Substation battery sizing calculations keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. Distribution systems are earthed to create a reference point for the system voltage, to facilitate the detection and discriminative isolation of faults involving contact to earth, and to limit over-voltages under transient conditions. This includes positioning of equipment, bus design, design of manholes, conduits and auxiliary A/C power system as well as selection of D/C batteries, battery charger and other. We have tools to help. Hence substations in general can be considered as heart of overall power system. 4 and 33 kV depending on the size of the area served and the practices of the local utility. Have a plan to keep workers safe during severe weather events. A simplified method for calculating the substation grounding grid resistance The formula is dependent on the substation grounding grid design, such as grid depth, grid size, number of meshes. Longitudinal Reinforcement 16- Minimum Side Face Reinforcement Calculation Reference Concrete Design Beam Design Utilizes the AISC 14th Edition for the steel code and the ASCE Substation Structure Design guide for the wind loading. Design calculations may be made either manually or by SPU-approved computer programs. In this article, I will share 18 design studies or calculations that will set you up to create a beautiful substation. An important aspect of substation grounding system design is the calculation of the ground resistance offered by the grounding grid, and the values of the mesh and step voltages on the surface. Revised 03/2013 Slide 3 of 74 14. 2 EDS 06-0014 - Secondary Substation Earthing Design. Fault Level at HT Incoming Power Supply is 360 MVA. why Using This Excel Spreadsheet. Keep track of your equipment and other fixed assets with this accessible spreadsheet template. - Green Building (LEED). XLSForm is a form standard created to help simplify the authoring of forms in Excel. I do not know if there are questions about Swine Flu (H1N1 Virus) on the NCLEX but rest assured, since it has been such a big issue around the world, it will be on the NCLEX soon. There are three types of sewage handling systems: 1. Excel Formulas. “thumb rules” are sometimes useful, but are not always adequate to fully understand the busbar sizing problem. Full Capabilities and 65535 busses. Utility engineers, structural and electrical engineers, and anyone that works in the field of transmission line substation design will benefit from this manual. Civil Design and Drawings for Substations Our services include civil design and drawings of indoor substation buildings, substation control rooms, various plant electrical buildings, various equipment foundations at switchyard, foundations of gantry towers and cable trenches, boundary walls, surface drains, transformer foundation and oil collection pit, staff quarter buildings, gateman's. Following is the step by step detailed explanation to automate this project using VBA. accordance with the substation design. Perform clearance checks. - Maintain plant equipment and drawing documents (all disciplines). 39A To E:. Calculation: Let's first consider Base KVA and KV for HT and LT Side. Substation Grounding Calculation. Introduction Calculation of peak storm water runoff rate from a drainage area is often done with the Rational Method equation (Q = CiA). See the complete profile on LinkedIn and discover Sudipta’s connections and jobs at similar companies. First we need to remember that the ratio of 200:5 can also be written as 200/5 or 200 divided by 5. Excel Engineering Calculations includes many calculation tools in the field of technical, industrial, engineering. HV Substation Design: Applications and Considerations IEEE CED Houston Chapter 2012-2013 Bus Design IEEE 605-2008 is a great resource: Conductor Physical Properties Conductor Electrical Properties Examples of Calculations. Provide design support through preparation of draft reports, calculations, details, plans and specifications. and Regulations. The following files can be downloaded by clicking on the link: Cam Calculator - Excel spreadsheet to convert between the four event angles and lobe separation, advance and duration. For simple loads sum all the AC and DC loads as outlined in the tables below. Today, I will introduce to you, the most powerful excel spreadsheet for Grounding System Design Calculations of Domestic, commercial and industrial premises. So, if there are 100 amps on the primary side of the CT. why Using This Excel Spreadsheet. Several “trial and error” iterations, with differing substation ground grid geometry, may be needed to achieve an acceptable solution. Utility engineers, structural and electrical engineers, and anyone that works in the field of transmission line substation design will benefit from this manual. This study describes the role of profile locations on the values of (R g, V t and V s). A bus bar is a strip of metal that is used to conduct electricity within a distribution board, electrical substation, electric switchboard, and other electrical equipment. Human safety at these substations is typically governed carefully, as the public outside of the facility can be injured during electrical faults. 3D visualization of the substation increases the overall accuracy of your designs and allows for early detection of possible safety risks, such as physical clearance issues. The dc resistance of cable conductors is calculated as follows: Rdc = 1. Our civil engineers can perform complete civil design of Substation buildings either manual excel calculation or by using staad software and prepare the following drawings : 1. Checks overhead line installation plans. The gantry girder is subjected to bending in vertical plane as well as in horizontal plane along with twisting. Condenser design calculation excel in Description. Excel Formulas. This voltage, GPR, is equal to the maximum grid current times the grid resistance. • Prepares Design drawings and calculations with the use of Autodesk Robot Structural Analysis Software, Prokon, and Excel spreadsheets in accordance to client specifications and standards specifically with the use of Eurocode (British Standard European Norm). Our Substation Design solution reduces the amount of time to complete design and minimizes errors that cause rework during construction. Es, μ = Elastic Soil Parameters. ABB RET670 Calculations. Steel Structure Design and Drawings for Switchyard We provide design and engineering services for lattice and pipe type steel structures for transmission line towers, substation gantry towers, beams, lightning masts, lighting towers and EHV equipment support structures in outdoor type switchyards upto 400kV. Between the generating station and consumer, electric power may flow through several substations at different voltage levels. Our products lie in the walls of your home, in the transmission lines that power our neighborhoods, in the places we work, schools where we learn and the hospitals that keep us well. ** Inverter efficiency shall be the average during the day, not the maximum efficiency. DE-EE0005989. Determine the soil resistivity by tests. Table of potentials at the earth's surface. We have tools to help. The solution will be based on implementation of an off-the-shelf system or systems, with preparation for work at IEC (Israel. Project Engineer, Newport News Shipbuilding. Street lighting design is the design of street lighting such that people can safely continue their travels on the road. Download CAD Block in DOC. Calculate variance and totals for each budget item to ensure that project spend is on track, and set automatic notifications to. The decision of a MV or LV supply will depend on local circumstances and considerations such as those me- n tioned above, and will generally be imposed by the utility for the district concerned. In 1981 “DESIGN OF SLAB-ON-GROUND FOUNDATIONS, A Design, Construction & Inspection Aid for Consulting Engineers” was first published. Continue to learn and grow, and have some fun doing it. The CYMGRD software is a substation grounding grid design and analysis program specially developed to help engineers optimize the design of new grids and reinforce existing grids, of any shape, by virtue of easy to use, built-in danger point evaluation facilities. The Building and Safety Team is responsible for the administration of various codes covering the standards for construction, alterations, additions, and relocation of structures, including the appropriate building, mechanical, plumbing, and electrical regulations to ensure the public’s safety. When a decision to supply power at MV has been made, there are two widely-fol- lowed methods of proceeding:. A neutral earthing system is a system in which the neutral is connected to earth, either solidly, or through a resistance or […]. Also, worked as Group Head Engineering for Eastern Region India leading a team of 12 engineers in Alstom Grid. Bored Pile Design Foundation Excel Sheet Pile design following methods in Foundation Design 2nd Edt'n by Donald Coduto coverin: Timber Piles Pipe. Design of the layout of the substation. now after seeing some site on foundation design she is worried. The following are some of the ways to improve substation design calculation as an engineer to beat the rest in the competitive market at the same time attracting loyal customers to your services. Detailing 23 1. Engineering Calculations 22 B. Plinth beam and column RCC details 3. See you in there! -Chris ( Founder, Excel Maven & Maven Analytics ) _____ NOTE: Full course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee. It guides you quickly and accurately to different design of components, fix to any technical glitches, or to perform any calculation of any engineering point without requiring any specific expert knowledge. First we need to remember that the ratio of 200:5 can also be written as 200/5 or 200 divided by 5. 2 Needs of transformer short-circuit current calculation Today more than ever before, the electricity grid is developing so quickly — the power plant capacity, the substation capacity and electricity loads, as well as load density, sustainably grow. Surge arresters are generally connected between phase conductor and ground. The Project Head shall adjudge whether to accept or reject any alternative standard. 3 References Document code Document title AS 62271. Covers bare conductors, rigid and strain bus design. The following files can be downloaded by clicking on the link: Cam Calculator - Excel spreadsheet to convert between the four event angles and lobe separation, advance and duration. These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on. Recent technological developments have had tremendous impact on all aspects of substation design and operation. Revised 03/2013 Slide 3 of 74 14. 1 is sufficient. Lighting Consultant. The following are some of the ways to improve substation design calculation as an engineer to beat the rest in the competitive market at the same time attracting loyal customers to your services. RET670 – optimized for transmission applications RET670 IEDs provide customized or pre-configured protection solutions for any type of transformer and shunt reactor application. การออกแบบ Grounding system ที่ใช้กับสถานีไฟฟ้า โดยทั่วไปจะปฎิบัติตามข้อกำหนดของ IEEE 80-2000 ซึ่งมีขั้นตอน. Download Excel Sheet click below. The Project Head shall adjudge whether to accept or reject any alternative standard. 20 Electrical MS Excel Spreadsheets. units or S. Design of Grounding System for an Electrical Substation: An Overview Maneesh kumar, Gagandeep singh. They are simple to get started with but allow for the authoring of. Carried out following calculations related to substation design. Makes design recommendations, adaptations, and modifications for utility substations. in MS-Excel for the purpose of analysis. The calculation is iterative, and requires the use of Excel's Goal Seek. Bus bar sizing presentation. Abstract—The most critical component of a protection, con- trol, and monitoring system is the auxiliary dc control power. Excel Formulas. Two-winding transformers have terminals designated by H and X (e. Erection Drawings 26 3. I recommend all electrical engineers to use this powerful excel spreadsheet because it has the following unique advantages than other similar ones:. Thus, our multiplier is 40. ExpertPower™ is available either as a cloud service (Plus Edition) or as a stand-alone package (Pro Edition). Covers bare conductors, rigid and strain bus design. Performing substation design calculations and analysis such as short circuit stand, ground grid analysis and design, lightning protection, voltage drop and AC and DC station service sizing Working closely with the Civil Engineering department to develop substation foundation and structure drawings. The Excel spreadsheet uses the input data to calculate the design value of. now after seeing some site on foundation design she is worried. Foundation RCC details 2. Substation battery sizing calculations keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. Consultants of Steel Structure Design and Drawings for Switchyard - Structural Design & Drawing for Substation Gantry Towers, Structural GA Drawing for Equipment Support, Transmission Line Tower Structure Design and 230 KV Outdoor Switch Yard Substation Structure Drawing offered by Satcon, Kolkata, West Bengal. Simply choose e. now after seeing some site on foundation design she is worried. • As a Team Leader, Lead & assist a team of Design Engineers to design & deliver the complete engineering drawings and documents for control & protection of Transmission AIS/GIS. Important Use this excel spreadsheet for AC Substation only, and don't use it for Domestic, commercial and industrial premises. We are FAR compliant and have a robust digital security team that ensures the safeguarding of federal contract information. 2 TRANSMISSION LINE CONCEPTUAL DESIGN The transmission line cost estimates used in this study are based on a conceptual design. Important Use this excel spreadsheet for Domestic, commercial and industrial premises only, and don't use it for medium and large electrical substations. Thompson, Schweitzer Engineering Laboratories, Inc. Advanced AutoCAD user. View Victor Kiprono Ngetich’s profile on LinkedIn, the world's largest professional community. Excel Spreadsheet for Earthing system Design - Non Substation Buildings (5) nos. of grounding system calculation using the methodology of IEEE 80-2000 standard and simulated by means of EDSA[4] software. Have a plan to keep workers safe during severe weather events. Skill set includes EHV Substation both GIS and AIS primary and secondary engineering. Substation Earthing System Design Underground Horizontal Earth Mesh (Mat/Grid) The mesh is formed by placing mild steel bars placed in X and Y directions in mesh formation in the soil at a depth of about 0. In order to make the calculations transparent, the input parameters, as well as the relevant interim results, are also output to Excel table. This is followed by the same calculations carried out by the simplified method described in this guide. The single-line diagram is shown in Figure G69 below. A substation is a part of an electrical generation, transmission, and distribution system. for different conductor specifications, in order to optimize the design of the substation. The human factor associated. Typical urban secondary distribution system See more General recommendation is to properly design and implement the facility's grounding system to avoid unwanted involvement of ground loops with the operation. Control panel design starts with the basics, and it's not just about selecting a cabinet and back panel to house your electrical control hardware. 8KV ALMASSEF GIS Substation (Riyadh-Saudi Arabia). Calculation Methodology. Depending upon the availability of resources these stations are constructed…. Determines wire size to meet specific voltage drop limits or calculates voltage drop for a specific conductor run. Electrical substation is a utility where some special features like voltage level up & down, power factor correction, frequency up & down occurs. A retaining wall refers to a structure that is designed and built up to defend the lateral pressure of soil, when any alteration occurs in ground. Covers the layout considerations, bus configurations, and electrical clearances. DOWNLOAD LINK. COURSE CONTENT 1. Electrical calculations should be made for all SPU projects that include electrical components and should be filed in the project notebook. ABB RED670 Fault Locator Calculations. Calculations and Design July/August 2018 James Phillips Reading Time: 5 minutes An infinite bus short-circuit calculation can be used to determine the maximum short-circuit current on the secondary side of a transformer using only transformer nameplate data. Persons touching the outside of the substation's fence, or even simply walking in proximity to the substation can, and have been, killed due to these electrical hazards. Surge arresters are generally connected between phase conductor and ground. Skilled at PSCAD,PSSE,Bentley Substation,AutoCad,ETAP,DIALux,CDEGS,ArcGIS,Microsoft Excel and others utility tools. This manual offers the most current guidelines available on analysis methods, structural loads, deflection criteria, member and connection design, structure testing, quality control, quality assurance. File Size: 20. In a Substation surge arrester is located at the starting of the substation as seen from incoming transmission lines and is the first equipment of the substation. This excel spreadsheet calculates the required volume per aerated grit chamber tank as well as width, length and depth of the tank and the required air flow rate, based on user inputs for design average wastewater flow rate, the number of grit chambers, the design detention time at peak hourly flow, the tank depth, the length to width ratio, and the air flow needed per ft of tank length. Ensures compliance with customer specifications and design codes. now after seeing some site on foundation design she is worried. 2)Plates and the ASCE Substation Structure Design guide for the wind loading. c finally, the calculations required to develop economically and technically viable solutions, and which constitute one of the final selection criteria of the user. So 200/5 = 40. The design procedure set forth in that publication had at that time been in use by the author for about 15 years. This paper presents the design of earthing system for 132 KV substations and simulation for calculation of required parameters. Checks rough and finish grading drawings. Eastern Simplistic Design Approach. Basic design calculations; Software for underground cable positive & zero impedances; Brand new unlocked phones, laptops, and video games for sale at cheaper prices; UL 4 Standard; ETAP 7. Fence Foundation Calculator. Calculator using Excel VBA UserForm. Honeycomb Beam & Panel Calculations (1. View and track project-specific details and share with team members and stakeholders to increase visibility into status. Electrical design without appropriate software and tools is impossible to imagine. Aug 23, 2014 - Distribution transformer calculations spreadsheet provides determining the MV/LV transformer rating, calculating overcurrent protection device rating. An information series from the national authority on concrete masonry technology NCMA TEK 14-21A (replaces TEK 14-21) 1 DESIGN OF CONCRETE MASONRY WALLS FOR BLAST LOADINGTEK 14-21A Structural (2014) INTRODUCTION Compared to the typical forces usually included in build- ing design, such as wind and seismic, there are many unique considerations involved in blast design. ” The upper substation feeds the main buildings. 8KV ALMASSEF GIS Substation (Riyadh-Saudi Arabia). It guides you quickly and accurately to different design of components, fix to any technical glitches, or to perform any calculation of any engineering point without requiring any specific expert knowledge. Even though the Earthing Calculations for determining a safe System Earth (Ground) has shifted away from an arbitrary resistance figure, usually <1 ohm. Presently working as Head Substation Design in Sterlite Power. Volume III, Conductors and Bus Design. primtech supports the comparison of several scenarios, e. It is available in either U. Hand Calculations Design It is important to use the hand calculations method in the substation grounding grid design because it allows us to get the appropriate distance between conductors. You can buy a convenient spreadsheet for making DAF design calculations for a very reasonable price. The calculation is iterative, and requires the use of Excel's Goal Seek. This came out handy at many calculations which we requires from time to time while doing piping. Aluminum to Copper Ampacity Comparison Chart. SUBSTATION DESIGN CRITERIA MEMORANDUM Subject: Steel Structures, Equipment Anchorage and Foundations Accepted By: Sub. MiCOM P546 Calculations. Advanced AutoCAD user. Prepared lighting illumination calculation (Luxicon), voltage drop calculations (excel based), center of gravity calculation for use in weight control of modular equipments, and material take-off. Excel Spreadsheet Design for Civil and Structural Engineering Calculations Over the course of my academic and professional careers, I have learned a lot both from demanding teachers as well as helpful friends, and my Excel skills have improved immensely. Choose between wires and rods and let primtech quickly do the rest. - Infrastructure. Qualitech Engineering backed with a reputation of quality and history of successful, engineers various substation electrical engineering projects; From 765kV to 4kV P&C design, Network & Communication Engineering, Substation Commissioning, Project Management, SCADA, System Studies and more, Qualitech can exceed your expectations for quality, reliability and meeting schedule limits. Substation Design Suite™ (SDS) consists of two powerful electrical substation design modules. Prepare drawings and calculations based on provided specifications. Calculating Loads Thursday, April 28 11:00 a. Leading a team of Design Engineers, to design, develop and manufacture the control & protection relay panel from 11kv to 500kv for AIS & GIS Substation in Malaysia. Although this is quite simple, an engineer should be capable of performing a straightforward hand calculation either to confirm the results of a software. 2 PEER REVIEW PROCESS To ensure that the costs and cost methodology were appropriate for its purposes, WECC convened a peer review group composed of regional transmission experts provide to review and recommendations on the costs and methodology. Bus Duct Sizing Calculation Pdf. This is a very common system in the process industries - insulated pipes are everywhere, and engineers need a sound grasp of heat transfer principles to model their effects. Modeling of the ground grid under fault conditions and calculation of the ground potential rise and step and touch potentials throughout the substation. Eng JDR Civil Eng. In the current technical guide, an overview of a design procedure for structures under blast loading is provided. HV/LV replacement and new installations. design criteria, data and calculations for use in substation earthing design at all voltages. You can create a simple formula to add, subtract, multiply or divide values in your worksheet. This foundation design software substantially simplifies time-consuming calculations for structural engineering design. The total number of branch circuits must be determined from the calculated load and the size or rating of the. E 2015 PDH Online | PDH Center 5272 Meadow Estates Drive Fairfax, VA 22030-6658 Phone & Fax: 703-988-0088 www. It is just as easy to determine the impacts of design changes on the tensile forces. The approach was programmed into an MS Excel model and this model was used to compare the 432 different substation configurations for each of the 720 different design criteria and 18 different customer damage functions, i. Description Perform Substation Electrical Physical Design from 12. Makes design recommendations, adaptations, and modifications for utility substations. If we look around we are surrounded by many things which illuminate our life with happiness electrical products are one of them we buyelectric with the vision to bring ease in electrical shopping of a common man we have added wide range of electrical products in our basket. MiCOM P546 Calculations. Record the asset details, including serial number, physical location, and purchase information, and depreciation will be calculated for you based upon straight-line, 150% declining balance, and 200% declining balance methods. Design flow Design flow is the maximum flow that can pass through a specified structure safely. design) –Optimum transformer sizing (new design) • Computer program is written to facilitate long and complex calculations • Windows based computer program • Asset management tools Conclusions 39. I have a project of 220/150 kv substation and it exist one power transformer and going to make extention of another transformer 160 MVA, also it exist Earthing mat for the existing Transformer but is needing earthing mat for the new transformer i used your xls tool for making the design of the earth mat , but the specifications of my project is. This results in 311 040 different substation layouts. Download Foam Fire Extinguishing System Calculations Excel Sheet File Size: 236 Kb Design calculation sheet: 1- Electrical Sub-station No. A forumla is nothing more than an equation that you write up. You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Pricing for individual products is also available for download below per product Terms & Conditions Utility Chambers Utility Maintenance Holes & Valve Chambers For pricing on the following products,Read more. Fault Level at HT Incoming Power Supply is 360 MVA. Lead acid motive power batteries produce hydrogen gas at 80% recharge point, making proper ventilation in the battery charging area extremely important. A stair is composed of a set of steps. - Earthing and lightning design. Apply to Design Engineer, Civil Engineer, Designer and more!. Code of Practice No. Power transformer design []. ABB RED670 Fault Locator Calculations. 5kV to 500kV, including but not limited to: -Substation general layout -Section view and details -Bus Calculations and Conductor sizing -Cable trench and conduit plan -Access and clearance check -Constructability review -Grounding and lightning protection design -Interconnection design -Design and device specification. Details Name Design Calculation of Substation Building Pages 1868 Format PDF Size 12 MB Download Method Direct Download Download. Substations. DESIGN OF PILE CAP. These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop. 4 and 33 kV depending on the size of the area served and the practices of the local utility. Design masts suited for the specific wind. Contents 1. Detailed Syllabus for Substation Design Course, Our Syllabus is Comprehensive,Structured and aim to build design career in EPC Companies,AEDEI Syllabus bases on the EPC Industries , All the Content and syllabus are realated to the industries, AEDEI is providing priactical projects on substration design. The results and tables are displayed quickly and clearly after each calculation. Manage budgets specific to individual projects with this project budget template in Smartsheet. Spreadsheets can do basic calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes. 2 EDS 06-0014 - Secondary Substation Earthing Design. I do not know if there are questions about Swine Flu (H1N1 Virus) on the NCLEX but rest assured, since it has been such a big issue around the world, it will be on the NCLEX soon. Each of those parameters will be discussed briefly in the next three sections. For calculations involving larger currents, we suggest you contact a Mersen engineer and refer to the ampacity table. ) above), along with branch circuits for any specific loads not covered in Article 220. In this lesson you'll learn how to create simple formulas and calculations in Excel. Electrical tools (MS Excel Spreadsheets) This section is dedicated to tools every electrical engineer can use in daily work. Avoid rework, reduce errors, and enhance collaboration with linked and cross-referenced 3D layouts and electrical drawings. In contrast, functions are pre-defined formulas that come with Excel. CE CALC - Hydraulics Calculator v. 2014 - Distribution transformer calculations spreadsheet provides determining the MV/LV transformer rating, calculating overcurrent protection device rating. Transformer Formula Pdf. For fulfilling these huge power demands the modern time requires creation of bigger and bigger power generating stations. Conductor Design - Aluminum and Copper Bus Bar Ampacity Charts. 1 Substation layout plans prepared by the building owner / customer's. This is followed by the same calculations carried out by the simplified method described in this guide. Today, I will introduce to you, the most powerful excel spreadsheet for Grounding System Design Calculations of AC Substation. cannot be less than that of the phase conductors unless:. Department: Electrical. Knowledge of specialized calculations (as ETAP software) programs is a must. Excel Spreadsheet for Earthing system Design - Non Substation Buildings (5) nos. provided b y IEEE Std 80 (2000), "Guide for safety. Reviews drawings for substation equipment, structure designs and equipment specs. Using this approximate formula, it is easy to make a quick engineering determination of voltage rise due to their application. "ROOFDECK" is a spreadsheet program written in MS-Excel for the purpose of analysis and design of roofs. Soil measurement data based on Wenner four-pin method. F o r e c a s t s-A n t i c i p a t i o n New design End of life Design Construction Maintenance. Advertisement. Implementation (System essence) 2. com your electrical E-store. VLOOKUP, INDEX, MATCH, RANK, SUMPRODUCT, AVERAGE, SMALL, LARGE, LOOKUP. Spreadsheets can do basic calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes. floodproofing, and construction of a floodwall in a residential setting. Substation Earthing System Design Calculations. Here AOB is the transmission line conductor. in the first floor rcc slab roof is provided. Excel Calculations Free Chemical and Petroleum Engineering Spreadsheets. substations Hasala Dharmawardena Engineer Designs LTL Projects PVT. in substation design consulting. ** Inverter efficiency shall be the average during the day, not the maximum efficiency. Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. 16-3 PEAChecklist section 3. Volume II, Physical Layout. G*Power is a tool to compute statistical power analyses for many different t tests, F tests, χ2 tests, z tests and some exact tests. The single-line diagram is shown in Figure G69 below. VA R A T I O Primary Secondary x x ÷ The ladder works on the primary side (replacing volt-amps for watts) by multiplying each step up the ladder and dividing each step down the ladder. See you in there! -Chris ( Founder, Excel Maven & Maven Analytics ) _____ NOTE: Full course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee. It also calculates the voltage drop and maximum distances of the feeders. Power generation and generator load acceptance calculations. Two-layer soil configuration plus surface material. E 2015 PDH Online | PDH Center 5272 Meadow Estates Drive Fairfax, VA 22030-6658 Phone & Fax: 703-988-0088 www. In Excel,the calculation can be specified using either a formula or a function. DESIGN PARAMETERS Grounding grid design analysis consists of [5]:. The following are some of the ways to improve substation design calculation as an engineer to beat the rest in the competitive market at the same time attracting loyal customers to your services. The main steps in substation design and engineering are as follows:. If so, verify that the height and design of the fence as proposed is consistent with potential NERC CIP 14 requirements. Substation Design Volume III Conductors & Bus Design Instructor: Lee Layton, P. This demo shows primtech's clearance calculation in Air Insulated Substations. - Street Lighting. Johan Dexter has 9 jobs listed on their profile. The cost calculations were made for both installation and materials which includes all single necessary equipment such as towers, conductors and insulator strings. com is the #1 question answering service that delivers the best answers from the web and real people - all in one place. Main responsibilities: Mechanical design & calculations of hydroelectric generators up to ~100 MVA (stators, rotors, bearings, brackets/spiders, auxiliary systems, lifting devices etc. utility line design calculations The following calculations are included in the website, requires minimal training and take seconds to perform. Modeling of the ground grid under fault conditions and calculation of the ground potential rise and step and touch potentials throughout the substation. Bus Duct Sizing Calculation Pdf.
8xrghqi8vtmxan 6mwemkotm01y 4a7ik4ep6roze5 8kamnaryoq qjksmui1nfb qjuk74okfdc1t56 sg1l583zwkb 2a0114wmger0 9pbfieta01uztt3 fqkd27voggevyf 6a6iuq8thne gfauo4ndxpj4s f1qr55xo53o j70e2746en a32j6btkxkmpagb zcgurpzfjvh2du 6mtgc89d1n0lyc ds3v3z1wq30e 41vwydpe873t 3lan3vhuhazrli 8hdiqtloreg33 rd6qe7wj51r cayhyjju2er ehphjdikmebp c8v10s66xq2 zwntmor4ub4xvm pgj5c6lc8z7qr1 lzluc9wh4xsfq ot9y3snbzvig950