Nuevo Hoja de Cálculo de Microsoft Excel

download Nuevo Hoja de Cálculo de Microsoft Excel

of 28

description

AJASKSA

Transcript of Nuevo Hoja de Cálculo de Microsoft Excel

  • circuito elctrico N 1

    DATOS

    V (v)V1= 10 V R1= V2= 20 V R2= V3= 30 V R3= V4= 40 V R4=

    R()

    V1

    R1 V2

  • RESULTADOS

    Vm1= -4030 Vm2= 7030 30 30

    I1= -0.333333

    R2

    V3

    R3

    V4

    R4

  • I2= 0.6666667

  • R= 60 -30 = 4500 -30 90

    (R*) = 90 3030 60

    (R) = 0.02 0.00666670.0066667 0.0133333

    t

    -1

  • DATOS

    VA= 220 V

    L1= 5 m i1=L2= 5 m i2=L3= 5 m i3=L4= 5 m i4=L5= 5 m i5=L6= 5 m i6=

    Conductor Nro. 14_= 2.5 mm

    Resistividad= 0.0175 .mm2/m

    VL1 L2 L3 L4

    I1 I2 I3 I4

    2

    L5

  • RESULTADOS:

    Pto.0

    6 17 26 34 42 53 6

    I5 I6

    L6

  • RESULTADOS:

    L I I0 0 28 0 05 6 28 1.96 1.965 7 22 1.54 3.55 6 15 1.05 4.555 4 9 0.63 5.185 2 5 0.35 5.535 3 3 0.21 5.74

    V V

  • CALIBRE SECCION (mm2)16AWG 1.514AWG 2.512AWG 410AWG 68AWG 10

    14AWG 2.5

    14

  • DATOS

    VA= 220 V

    L1= 7 m i1=L2= 7 m i2=L3= 7 m i3=L4= 7 m i4=L5= 7 m i5=L6= 7 m i6=L7= 7 m i7=L8= 7 m i8=L9= 7 m

    Conductor Nro. 14_= 1.5 mm

    Resistividad= 0.0175 .mm2/m

    VL1 L2 L3

    I1 I2

    I3

    I4

    2

    2

  • CALIBRE SECCIN mm16AWG 1.514AWG 2.512AWG 410AWG 68AWG 10

    16AWG 1.5

    2

  • RESULTADOS:

    3 A Pto. L I3 A 0 0 03 A 1 7 33 A 2 7 33 A 3 7 93 A 4 7 33 A 5 7 33 A 6 7 3

    3.1 7 33.2 7 33.3 7 3

    L4

    I5

    I6

    L5 L6

    I7 I8

  • I V V24 0 024 3.92 3.9221 3.43 7.3518 2.94 10.299 1.47 11.766 0.98 12.743 0.49 13.239 1.47 1.476 0.98 2.453 0.49 2.94

  • L1 L2 L3P0 P1 P2

  • DATOS

    L1= 7 M I1=L2= 7 M I2=L3= 7 M I3=L4= 7 M I4=L5= 7 M I5=L6= 7 M I6=L7= 7 M I7=L8= 7 M I8=L9= 7 M I9=

    L10= 7 M I10=L11= 7 M I11=L12= 7 M I12=L3.1= 7 M I3.1=L3.2= 7 M I3.2=L3.3= 7 M I3.3=L7.1= 7 M I7.1=L7.2= 7 M I7.2=

    RESISTIVIDAD= 0.0175 .mm /m

    CONDUCTOR NMERO: 10AWG = 6

    CALIBRE SECCIN mm16AWG 1.514AWG 2.512AWG 410AWG 68AWG 10

    2

    2

  • L4 L5 L6

    L3.1

    L3.2

    L3.3

    P3 P4 P5

    P3.1

    P3.2

    P3.3

  • RESULTADOS

    3 A Pto. L3 A P0 09 A P1 73 A P2 73 A P3 73 A P4 76 A P5 73 A P6 73 A P7 73 A P8 73 A P9 73 A P10 73 A P11 73 A P12 73 A P3.1 73 A P3.2 73 A P3.2 7

    P7.1 7P7.2 7

    mm2

  • L7

    L8

    L9

    L10

    L11

    L12

    L7.1

    L7.2

    P6 P7

    P8

    P9

    P10

    P11

    P12

    P7.1

    P7.2

  • I I V V0 45 0 03 45 1.8375 1.83753 42 1.715 3.55259 39 1.5925 5.1453 30 1.225 6.373 27 1.1025 7.47253 24 0.98 8.45256 21 0.8575 9.313 15 0.6125 9.92253 12 0.49 10.41253 9 0.3675 10.783 6 0.245 11.0253 3 0.1225 11.14753 9 0.3675 0.36753 6 0.245 0.61253 3 0.1225 0.7353 6 0.245 0.2453 3 0.1225 0.3675

  • P10

  • S

    Hoja1Caida de TensinCT con Circuito DerivadoCT con Circuitos Derivados

    ComboBox1: ComboBox1_2: ComboBox1_3: ComboBox1_4: