Hojas de Calculo en Excel para diseños electricos

Tema en 'Electrónica' iniciado por 'Wayne, 11 Mayo 2011.

  1. 'Wayne

    'Wayne Lanero reconocido

    Registrado:
    26 Enero 2010
    Mensajes:
    925
    Me Gusta recibidos:
    978
    las encontre por ahi, tal vez les sean utiles

    Electrical Excel Tools

    Posted: March 22, 2011 by Jignesh.Parmar in Uncategorized

    Excel base Programs (Electrical Engineering): Designed by: Jignesh.Parmar
    Cable Designing Program

    [​IMG] FREE DOWNLOAD
    • Calculate Voltage drop of Cable.
    • Calculate Size of Cable.
    • Calculate Current Capacity of Cable.
    Conduit Size Selection Program

    [​IMG] FREE DOWNLOAD
    • Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.
    Selection of MCCB,ELCB For Main /Branch Circuit.

    [​IMG] FREE DOWNLOAD
    • Calculate Size and Type of Main MCCB/RCCB/ELCB for Continious and Non Continious Load
    • Calculate Sensitivity of MCCB/RCCB/ELCB.
    • Calculate Size of Cable.
    • Calculate Size and Type of Sub Circuit MCCB/MCB for Continious and Non Continious Load
    • Calculate Total Load .
    • Calculate Main and Branch Circuit Current.
    Selection of Fuses

    [​IMG] FREE DOWNLOAD
    • Calculate Size of Fuse for Electrical Circuit.
    Size of Capacitor For Power Factor Improvements

    [​IMG] FREE DOWNLOAD
    • Calculate Size of Capacitor for Power Factor Improvements.
    • Calculate Annual Saving by selection of Capacitor.
    • Calculate Active and Reactive Power.
    Short Circuit Current Calculation at Various Point of Electrical Curcuits(Isc).

    [​IMG]FREE DOWNLOAD
    • Calculate Short Circuit Current at Substation.
    • Calculate Short Circuit Current at Distribution point.
    • Calculate Short Circuit Current at Transformer.
    • Calculate Short Circuit Current at Main Panel.
    • Calculate Short Circuit Current at Sub Distribution Board.
    Circuit Breaker Tripping Settings.

    [​IMG] FREE DOWNLOAD
    • Calculate Tripping Setting of Circuit Breaker.
    Motor Specifications

    [​IMG] FREE DOWNLOAD
    • Calculate Various Specification of Motor.
    Calculate Home Electrical Load & Electrical Bill.

    [​IMG] FREE DOWNLOAD
    • Calculate Electrical Bill of Home
    • Calculate Size of MCCB/MCB for Domestic Load
    • Calculate Electrical Load of Home.
    Calculate Insulation Resistance Value and PI value

    [​IMG] FREE DOWNLOAD
    • Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
    • Calculate IR Value of Electrical Equipments.
    • Graph of IR Value
    • Calculate Polarization Index Value with Graph
    • Calculate Earth Resistivity.
    Calculate Electrical Load and Energy Consumption of Panel.


    [​IMG] FREE DOWNLOAD
    • Calculate Continuous and non Continuous Electrical Load of Panel.
    • Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
    • Calculate Size of MCB of each branch circuit of Panel.
    • Calculate Voltage / Voltage Difference of Each Phase
    • Calculate Unbalanced Load in Neutral Wire.
    • Calculate Expected Temperature rise in Each Phase.
    • Calculate Load in Each Phase.
    • Calculate Starting/Full Load/Continuous/Non Continuous Load
    • Calculate Size/Type/Tripping setting of Main MCCB.
    Calculate Electrical Load of Panel.


    [​IMG] FREE DOWNLOAD
    • Calculate Voltage / Voltage Difference of Each Phase
    • Calculate Unbalanced Load in Neutral Wire.
    • Calculate Expected Temperature rise in Each Phase.
    • Calculate Load in Each Phase and Outgoing Feeders.
    • Calculate Starting/Full Load/Continuous/Non Continuous Load
    • Calculate Size of Cables for Each Outgoing Feeder.
    Calculate Size of Battery Bank and Inverter.

    Anuncio



    [​IMG] FREE DOWNLOAD
    • Calculate Total Demand Load
    • Calculate Size of Battery Bank in Amp.Hr.
    • Select Type of Connection of Batteries in Battery Bank
    • Select Rating of Each Battery in Battery Bank
    • Calculate Size of Inverter.
    • Calculate Size/Type/Tripping setting of Main MCCB.
    Calculate Size of Solar Panel / Battery Bank / Inverter.


    [​IMG] FREE DOWNLOAD
    • Calculate Total Demand Load
    • Calculate Size of Solar Panel.
    • Select Type of Connection of Solar Panel.
    • Select Rating of Each Solar Panel.
    • Calculate Energy from Solar Panel as per Daily Sun lights.
    • Calculate Size Battery Bank.
    • Select Type of connection of Batteries in Battery Bank
    • Calculate size of Inverter
    Calculate No of Lighting Fittings and Lumen Output.


    [​IMG] FREE DOWNLOAD
    • Calculate Total Lumen Output for particular Area.
    • Calculate Total No of Lighting Lamps.
    • Calculate Total No of Lighting Fixtures.
    • Calculate No of Fittings along with the Length and Width of Room.
    Calculate Bus Bar Size and Voltage Drop.


    [​IMG] FREE DOWNLOAD
    • Calculate Voltage Drop for Bus Bar.
    • Select Size of Bus Bar for particular Load.
    • Enter Your Sub Panel Details like Load,Line Length.
    Design of Earthing Mat for Sub-Station:

    [​IMG] FREE DOWNLOAD
    • Program is design as per ANSI/IEEE 80-1986 Code.
    • Calculate Step Potential of Switch yard.
    • Calculate Touch Potential of Switch yard.
    • Calculate Total Length of Earthing Mat Conductor.
    • Calculate Size of Earthing Mat Conductor.
    • Calculate Total No of Earthing Rods.
    Calculate Touch Voltage and Ground Current.

    [​IMG] FREE DOWNLOAD
    • Calculate Resistance of Each Phase.
    • Calculate Resistance of neutral/Ground.
    • Calculate Neutral Current and Load.
    • Calculate Touch Voltage for Metal part to Earth.
    • Calculate Body Resistance and Body Current.
     
    #1
    A 2 personas les gusta esto.
  2. 'Wayne

    'Wayne Lanero reconocido

    Registrado:
    26 Enero 2010
    Mensajes:
    925
    Me Gusta recibidos:
    978
  3. 'Wayne

    'Wayne Lanero reconocido

    Registrado:
    26 Enero 2010
    Mensajes:
    925
    Me Gusta recibidos:
    978
    (1) Cable Designing Program
    [​IMG] FREE DOWNLOAD
    • Calculate Voltage drop of Cable.
    • Calculate Size of Cable.
    • Calculate Current Capacity of Cable.
    (2) Conduit Size Selection Program
    [​IMG] FREE DOWNLOAD
    • Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.
    (3) Selection of MCCB, ELCB For Main /Branch Circuit.
    [​IMG] FREE DOWNLOAD
    • Calculate Size and Type of Main MCCB/RCCB/ELCB for Continuous and Non Continuous Load
    • Calculate Sensitivity of MCCB/RCCB/ELCB.
    • Calculate Size of Cable.
    • Calculate Size and Type of Sub Circuit MCCB/MCB for Continuous and Non Continuous Load
    • Calculate Total Load .
    • Calculate Main and Branch Circuit Current.
    (4) Selection of Fuse

    [​IMG]FREE DOWNLOAD

    • Calculate Size of Fuse for Electrical Circuit.
    (5) Size of Capacitor For Power Factor Improvements
    [​IMG] FREE DOWNLOAD
    • Calculate Size of Capacitor for Power Factor Improvements.
    • Calculate Annual Saving by selection of Capacitor.
    • Calculate Active and Reactive Power.
    (6) Short Circuit Current Calculation at Various Point of Electrical Circuits(Isc).
    [​IMG]FREE DOWNLOAD
    • Calculate Short Circuit Current at Substation.
    • Calculate Short Circuit Current at Distribution point.
    • Calculate Short Circuit Current at Transformer.
    • Calculate Short Circuit Current at Main Panel.
    • Calculate Short Circuit Current at Sub Distribution Board.
    (7) Circuit Breaker Tripping Settings.
    [​IMG] FREE DOWNLOAD
      • Calculate Tripping Setting of Circuit Breaker.
    (8) Motor Specifications
    [​IMG] FREE DOWNLOAD
      • Calculate Various Specification of Motor.
    (9) Calculate Home Electrical Load & Electrical Bill.
    [​IMG] FREE DOWNLOAD
    • Calculate Electrical Bill of Home
    • Calculate Size of MCCB/MCB for Domestic Load
    • Calculate Electrical Load of Home.
    (10) Calculate Insulation Resistance Value and PI value
    [​IMG] FREE DOWNLOAD
    • Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
    • Calculate IR Value of Electrical Equipments.
    • Graph of IR Value
    • Calculate Polarization Index Value with Graph
    • Calculate Earth Resistivity.
    (11) Calculate Electrical Load and Energy Consumption of Panel.
    [​IMG] FREE DOWNLOAD
      • Calculate Continuous and non Continuous Electrical Load of Panel.
      • Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
      • Calculate Size of MCB of each branch circuit of Panel.
      • Calculate Voltage / Voltage Difference of Each Phase
      • Calculate Unbalanced Load in Neutral Wire.
      • Calculate Expected Temperature rise in Each Phase.
      • Calculate Load in Each Phase.
      • Calculate Starting/Full Load/Continuous/Non Continuous Load
      • Calculate Size/Type/Tripping setting of Main MCCB.
    (12) Calculate Electrical Load of Panel.
    [​IMG] FREE DOWNLOAD
    • Calculate Voltage / Voltage Difference of Each Phase
    • Calculate Unbalanced Load in Neutral Wire.
    • Calculate Expected Temperature rise in Each Phase.
    • Calculate Load in Each Phase and Outgoing Feeders.
    • Calculate Starting/Full Load/Continuous/Non Continuous Load
    • Calculate Size of Cables for Each Outgoing Feeder.
    (13) Calculate Size of Battery Bank and Inverter.
    [​IMG] FREE DOWNLOAD
    • Calculate Total Demand Load
    • Calculate Size of Battery Bank in Amp.Hr.
    • Select Type of Connection of Batteries in Battery Bank
    • Select Rating of Each Battery in Battery Bank
    • Calculate Size of Inverter.
    • Calculate Size/Type/Tripping setting of Main MCCB.
    (14) Calculate Size of Solar Panel / Battery Bank / Inverter.
    [​IMG] FREE DOWNLOAD
    • Calculate Total Demand Load
    • Calculate Size of Solar Panel.
    • Select Type of Connection of Solar Panel.
    • Select Rating of Each Solar Panel.
    • Calculate Energy from Solar Panel as per Daily Sun lights.
    • Calculate Size Battery Bank.
    • Select Type of connection of Batteries in Battery Bank
    • Calculate size of Inverter
    (15) Calculate No of Lighting Fittings and Lumen Output.
    [​IMG] FREE DOWNLOAD
    • Calculate Total Lumen Output for particular Area.
    • Calculate Total No of Lighting Lamps.
    • Calculate Total No of Lighting Fixtures.
    • Calculate No of Fittings along with the Length and Width of Room.
    Calculate Bus Bar Size and Voltage Drop.
    [​IMG] FREE DOWNLOAD
      • Calculate Voltage Drop for Bus Bar.
      • Select Size of Bus Bar for particular Load.
      • Enter Your Sub Panel Details like Load,Line Length.
    (16) Design of Earthing Mat for Sub-Station:
    [​IMG] FREE DOWNLOAD
      • Program is design as per ANSI/IEEE 80-1986 Code.
      • Calculate Step Potential of Switch yard.
      • Calculate Touch Potential of Switch yard.
      • Calculate Total Length of Earthing Mat Conductor.
      • Calculate Size of Earthing Mat Conductor.
      • Calculate Total No of Earthing Rods.
    (17) Calculate Touch Voltage and Ground Current.
    [​IMG] FREE DOWNLOAD
    • Calculate Resistance of Each Phase.
    • Calculate Resistance of neutral/Ground.
    • Calculate Neutral Current and Load.
    • Calculate Touch Voltage for Metal part to Earth.
    • Calculate Body Resistance and Body Current.
    (18) Calculate Size of Diesel Generator.
    [​IMG] FREE DOWNLOAD
    • Calculate Size of D.G Set for Linear,Non-Linear Load
    • Calculate Size of D.G Set for Motor Load
    • Calculate D.G Set Efficiency.
    • Calculate UPL (Unit per Liter) of D.G Set
    • Calculate Unit Power Cost of D.G Set
    • Calculate Approximate Fuel Consumption.
    (19) Calculate Size of air conditioning for room.

    [​IMG] FREE DOWNLOAD
    • Calculate Size of Air Conditioning for Your Room.
    • Calculate AC Size in BTU/Hr.
    • Calculate AC size in Tone.
    • Calculate Heating and Cooling BTU.
     
    #3
  4. 'Wayne

    'Wayne Lanero reconocido

    Registrado:
    26 Enero 2010
    Mensajes:
    925
    Me Gusta recibidos:
    978
    a ver son hojas de calculo, no programas.
     
    #4
  5. Mxuricio

    Mxuricio Lanero reconocido

    Registrado:
    17 Junio 2011
    Mensajes:
    140
    Me Gusta recibidos:
    24
    Viejo me sale este mensaje:
    The file You are looking for... may be deleted by the user or by the Adminstrator !
    Sera que los puedes subir de nuevo.
     
    #5
  6. 'Wayne

    'Wayne Lanero reconocido

    Registrado:
    26 Enero 2010
    Mensajes:
    925
    Me Gusta recibidos:
    978
    aqui estan en los adjuntos, para que no usen todos esos links
     

    Adjuntos:

    #6
  7. Mxuricio

    Mxuricio Lanero reconocido

    Registrado:
    17 Junio 2011
    Mensajes:
    140
    Me Gusta recibidos:
    24
    Gracias, si ya me di cuenta jjaja.
     
    #7

Compartir esta página