TRM: $2,025.75

Bienvenid@ a Laneros.com

¿Deseas interactuar con más de 375.000 Laneros?

¡Regístrate ahora!

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:
    912
    Me Gusta recibidos:
    962
    las encontre por ahi, tal vez les sean utiles

    Electrical Excel Tools

    Anuncio


    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.


    [​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:
    912
    Me Gusta recibidos:
    962
  3. 'Wayne

    'Wayne Lanero reconocido

    Registrado:
    26 Enero 2010
    Mensajes:
    912
    Me Gusta recibidos:
    962
    (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:
    912
    Me Gusta recibidos:
    962
    a ver son hojas de calculo, no programas.
     
    #4
  5. Mxuricio

    Mxuricio Lanero activo

    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:
    912
    Me Gusta recibidos:
    962
    aqui estan en los adjuntos, para que no usen todos esos links
     

    Adjuntos:

    #6
  7. Mxuricio

    Mxuricio Lanero activo

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

Compartir esta página