Excel Apoyo Partes 1-5 Del Enunciado y Solución

download Excel Apoyo Partes 1-5 Del Enunciado y Solución

of 220

Transcript of Excel Apoyo Partes 1-5 Del Enunciado y Solución

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    1/220

    Irradiancia @STC 1000 W/m²Temperatura @STC 25.0 ºCIsc1Voc1Pmpp1 152.3 WImpp1 8.09 A

    Vmpp1 18.813 VFF1 !" #DIV/0!

    9.3%

    10.4%

    Va#ores V$ I$ P" representados en tama%o &r12) 1*.*1+ V

    Punto ,r. Tensi-n V"1 -1.845 V2 -3.810 V3 -3.638 V4 -3.476 V5 -3.524 V6 -3.237 V7 -3.047 V8 -2.905 V9 -2.715 V10 -2.569 V

    (ciencia1 s/mod

    "

    (ciencia1 s/ce#

    "

    10.000 V 0.000 V 10.000 V1.00 /

    0.00 /

    1.00 /

    2.00 /

    +.00 /

    .00 /

    5.00 /

    3.00 /

    ).00 /

    *.00 /

    4.00 /  

    Cura caracter6stica 1 Sta

    Tensi

       I  n   t  e  n  s   i   d

      a   d      /   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    2/220

    11 -2.330 V12 -2.286 V13 -2.042 V14 -1.895 V15 -1.656 V16 -1.564 V

    17 -1.276 V18 -1.130 V19 -0.934 V20 -0.837 V21 -0.544 V22 -0.544 V23 -0.348 V24 -0.099 V25 0.047 V26 0.237 V

    27 0.384 V28 0.628 V29 0.726 V30 0.921 V31 1.068 V32 1.263 V33 1.458 V34 1.708 V35 1.854 V36 2.098 V37 2.250 V38 2.396 V39 2.592 V40 2.782 V41 3.026 V42 3.178 V43 3.422 V44 3.617 V45 3.812 V46 3.910 V47 4.154 V

    48 4.301 V49 4.496 V50 4.642 V51 4.935 V52 5.033 V53 5.180 V54 5.424 V55 5.570 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    3/220

    56 5.765 V57 5.961 V58 6.205 V59 6.357 V60 6.547 V61 6.698 V

    62 6.943 V63 6.991 V64 7.187 V65 7.382 V66 7.626 V67 7.773 V68 7.919 V69 8.163 V70 8.359 V71 8.603 V

    72 8.700 V73 8.945 V74 9.140 V75 9.335 V76 9.482 V77 9.726 V78 9.823 V79 10.068 V80 10.165 V81 10.409 V82 10.507 V83 10.702 V84 10.946 V85 11.093 V86 11.337 V87 11.484 V88 11.728 V89 11.825 V90 12.021 V91 12.221 V92 12.411 V

    93 12.509 V94 12.753 V95 12.900 V96 13.095 V97 13.247 V98 13.339 V99 13.486 V

    100 13.730 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    4/220

    101 13.974 V102 14.120 V103 14.370 V104 14.565 V105 14.760 V106 14.902 V

    107 15.151 V108 15.249 V109 15.493 V110 15.688 V111 15.932 V112 16.030 V113 16.225 V114 16.420 V115 16.567 V116 16.713 V

    117 16.909 V118 17.153 V119 17.348 V120 17.543 V121 17.739 V122 17.934 V123 18.081 V124 18.276 V125 18.374 V126 18.666 V127 18.813 V128 18.911 V129 19.155 V130 19.301 V131 19.497 V132 19.643 V133 19.838 V134 19.985 V135 20.180 V136 20.375 V137 20.620 V

    138 20.766 V139 21.010 V140 21.157 V141 21.401 V142 21.450 V143 21.645 V144 21.889 V145 22.036 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    5/220

    146 22.280 V147 22.475 V148 22.622 V149 22.768 V150 22.963 V151 23.110 V

    152 23.354 V153 23.452 V154 23.745 V155 23.891 V156 23.989 V157 24.184 V158 24.331 V159 24.526 V160 24.721 V161 24.965 V

    162 25.112 V163 25.307 V164 25.405 V165 25.649 V166 25.747 V167 25.942 V168 26.094 V169 26.284 V170 26.479 V171 26.674 V172 26.870 V173 27.065 V174 27.260 V175 27.456 V176 27.602 V177 27.846 V178 28.047 V179 28.193 V180 28.383 V181 28.579 V182 28.730 V

    183 28.872 V184 29.072 V185 29.219 V186 29.360 V187 29.609 V188 29.750 V189 29.951 V190 30.146 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    6/220

    191 30.336 V192 30.488 V193 30.683 V194 30.825 V195 31.025 V196 31.118 V

    197 31.313 V198 31.465 V199 31.660 V200 31.752 V201 31.899 V202 32.051 V203 32.246 V204 32.441 V205 32.588 V206 32.783 V

    207 32.978 V208 33.125 V209 33.266 V210 33.418 V211 33.564 V212 33.760 V213 33.906 V214 34.101 V215 34.248 V216 34.346 V217 34.536 V218 34.633 V219 34.829 V220 34.926 V221 35.170 V222 35.268 V223 35.463 V224 35.610 V225 35.756 V226 35.903 V227 36.044 V

    228 36.142 V229 36.332 V230 36.478 V231 36.625 V232 36.766 V233 36.956 V234 37.092 V235 37.136 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    7/220

    236 37.125 V237 37.120 V238 37.115 V239 37.109 V240 37.099 V241 37.093 V

    242 37.088 V243 37.088 V244 37.083 V245 37.077 V246 37.077 V247 37.072 V248 37.072 V249 37.067 V250 37.067 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    8/220

    Condiciones de medida de #a cura caracter6stica 1.

      nde en e# &r'(co desp#'cense con e# cursor"*.04 152.+ W

    Intensidad " Potencia W"8.20 A -15.1 W8.21 A -31.3 W8.17 A -29.7 W8.17 A -28.4 W8.19 A -28.8 W8.17 A -26.4 W8.16 A -24.9 W8.14 A -23.6 W8.14 A -22.1 W8.13 A -20.9 W

    , T787S 97S :;CICI7S$ ?,IC

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    9/220

    8.14 A -19.0 W8.13 A -18.6 W8.13 A -16.6 W8.13 A -15.4 W8.12 A -13.5 W8.13 A -12.7 W

    8.14 A -10.4 W8.14 A -9.2 W8.14 A -7.6 W8.14 A -6.8 W8.14 A -4.4 W8.15 A -4.4 W8.14 A -2.8 W8.13 A -0.8 W8.13 A 0.4 W8.14 A 1.9 W

    8.14 A 3.1 W8.14 A 5.1 W8.14 A 5.9 W8.14 A 7.5 W8.14 A 8.7 W8.14 A 10.3 W8.14 A 11.9 W8.13 A 13.9 W8.15 A 15.1 W8.13 A 17.1 W8.14 A 18.3 W8.12 A 19.5 W8.14 A 21.1 W8.13 A 22.6 W8.15 A 24.6 W8.12 A 25.8 W8.14 A 27.8 W8.14 A 29.4 W8.12 A 31.0 W8.14 A 31.8 W8.14 A 33.8 W

    8.14 A 35.0 W8.14 A 36.6 W8.14 A 37.8 W8.14 A 40.2 W8.14 A 41.0 W8.14 A 42.2 W8.14 A 44.1 W8.14 A 45.3 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    10/220

    8.14 A 46.9 W8.14 A 48.5 W8.14 A 50.5 W8.13 A 51.7 W8.14 A 53.3 W8.13 A 54.5 W

    8.13 A 56.4 W8.13 A 56.8 W8.13 A 58.4 W8.13 A 60.0 W8.13 A 62.0 W8.13 A 63.2 W8.13 A 64.4 W8.13 A 66.4 W8.13 A 68.0 W8.13 A 69.9 W

    8.13 A 70.7 W8.13 A 72.7 W8.13 A 74.3 W8.13 A 75.9 W8.13 A 77.1 W8.13 A 79.1 W8.13 A 79.9 W8.13 A 81.9 W8.13 A 82.6 W8.13 A 84.6 W8.13 A 85.4 W8.12 A 86.9 W8.12 A 88.8 W8.12 A 90.0 W8.12 A 92.0 W8.13 A 93.4 W8.13 A 95.3 W8.12 A 96.0 W8.13 A 97.7 W8.11 A 99.1 W8.12 A 100.7 W

    8.12 A 101.5 W8.13 A 103.7 W8.12 A 104.7 W8.12 A 106.3 W8.11 A 107.4 W8.12 A 108.3 W8.12 A 109.5 W8.12 A 111.4 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    11/220

    8.12 A 113.4 W8.12 A 114.6 W8.11 A 116.5 W8.11 A 118.1 W8.11 A 119.7 W8.12 A 120.9 W

    8.11 A 122.8 W8.11 A 123.6 W8.11 A 125.6 W8.11 A 127.2 W8.11 A 129.2 W8.11 A 130.0 W8.11 A 131.6 W8.11 A 133.1 W8.11 A 134.3 W8.11 A 135.5 W

    8.09 A 136.8 W8.11 A 139.1 W8.09 A 140.4 W8.09 A 142.0 W8.09 A 143.6 W8.09 A 145.1 W8.09 A 146.3 W8.09 A 147.9 W8.09 A 148.7 W8.09 A 151.1 W8.09 A 152.3 W8.09 A 153.0 W8.09 A 155.0 W8.09 A 156.2 W8.09 A 157.8 W8.09 A 159.0 W8.09 A 160.5 W8.09 A 161.7 W8.09 A 163.3 W8.08 A 164.6 W8.08 A 166.6 W

    8.08 A 167.8 W8.08 A 169.7 W8.08 A 170.9 W8.08 A 172.9 W8.08 A 173.3 W8.08 A 174.9 W8.08 A 176.8 W8.06 A 177.7 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    12/220

    8.08 A 180.0 W8.06 A 181.2 W8.08 A 182.8 W8.06 A 183.6 W8.06 A 185.2 W8.06 A 186.4 W

    8.06 A 188.3 W8.06 A 189.1 W8.05 A 191.1 W8.06 A 192.7 W8.05 A 193.1 W8.05 A 194.7 W8.05 A 195.8 W8.04 A 197.1 W8.04 A 198.6 W8.02 A 200.2 W

    8.02 A 201.4 W8.02 A 203.0 W8.01 A 203.4 W8.01 A 205.3 W7.99 A 205.7 W7.98 A 206.9 W7.97 A 207.9 W7.96 A 209.3 W7.95 A 210.4 W7.93 A 211.6 W7.92 A 212.8 W7.89 A 213.5 W7.86 A 214.2 W7.84 A 215.4 W7.82 A 215.7 W7.77 A 216.4 W7.72 A 216.5 W7.71 A 217.2 W7.65 A 217.2 W7.63 A 217.9 W7.57 A 217.6 W

    7.55 A 218.0 W7.49 A 217.6 W7.44 A 217.4 W7.39 A 217.0 W7.31 A 216.4 W7.26 A 215.9 W7.16 A 214.5 W7.09 A 213.7 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    13/220

    7.00 A 212.2 W6.93 A 211.2 W6.83 A 209.4 W6.78 A 208.8 W6.64 A 205.9 W6.57 A 204.4 W

    6.44 A 201.6 W6.36 A 200.0 W6.21 A 196.6 W6.15 A 195.1 W6.03 A 192.3 W5.92 A 189.7 W5.77 A 186.1 W5.60 A 181.5 W5.49 A 179.0 W5.27 A 172.9 W

    5.13 A 169.1 W4.95 A 164.0 W4.86 A 161.5 W4.64 A 155.2 W4.50 A 150.9 W4.31 A 145.4 W4.19 A 142.0 W3.94 A 134.4 W3.75 A 128.4 W3.60 A 123.7 W3.39 A 117.1 W3.26 A 112.9 W3.03 A 105.4 W2.85 A 99.5 W2.60 A 91.4 W2.42 A 85.5 W2.18 A 77.1 W1.97 A 70.2 W1.72 A 61.5 W1.56 A 56.0 W1.30 A 47.0 W

    1.10 A 39.7 W0.84 A 30.6 W0.67 A 24.4 W0.42 A 15.3 W0.16 A 6.0 W-0.08 A -2.9 W-0.36 A -13.2 W-0.41 A -15.1 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    14/220

    -0.41 A -15.0 W-0.41 A -15.3 W-0.40 A -15.0 W-0.40 A -14.7 W-0.38 A -14.1 W-0.40 A -14.9 W

    -0.39 A -14.6 W-0.41 A -15.1 W-0.40 A -14.8 W-0.39 A -14.5 W-0.39 A -14.5 W-0.38 A -14.2 W-0.38 A -14.2 W-0.38 A -13.9 W-0.38 A -13.9 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    15/220

    Caracter6sticas de# m-du#o Aotoo#taicoaro, 1.650 &Anco, 0.990 &r. ua), 60

    or&a ce)., ua"ra"a)a"o cua), 0.156 &

    7B:TIV7 89 :;CICI7 1. ob$eo "e e)e e$ercco e) "encar

    o) ar&ero) ecrco) :ce"a) +3,+10; "e a cur*a caracer

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    16/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    17/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    18/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    19/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    20/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    21/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    22/220

    Irradiancia @STC 1000 W/m²Temperatura @STC 25.0 ºCIsc1 8.13 AVoc1 36.900 VPmpp1 218.0 WImpp1 7.55 A

    Vmpp1 28.872 VFF1 !" 72.7%

    13.3%

    14.9%

    Va#ores V$ I$ P" representados en tama%o &r1*+ 2*.*)2 V

    Punto ,r. Tensi-n V"1 -1.845 V2 -3.810 V3 -3.638 V4 -3.476 V5 -3.524 V6 -3.237 V7 -3.047 V8 -2.905 V9 -2.715 V10 -2.569 V

    (ciencia1 s/mod

    "

    (ciencia1 s/ce#

    "

    10.000 V 0.000 V 10.000 V1.00 /

    0.00 /

    1.00 /

    2.00 /

    +.00 /

    .00 /

    5.00 /

    3.00 /

    ).00 /

    *.00 /

    4.00 / 

    Cura caracter6stica 1 Sta

    Tensi

       I  n   t  e  n  s   i   d

      a   d      /   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    23/220

    11 -2.330 V12 -2.286 V13 -2.042 V14 -1.895 V15 -1.656 V16 -1.564 V

    17 -1.276 V18 -1.130 V19 -0.934 V20 -0.837 V21 -0.544 V22 -0.544 V23 -0.348 V24 -0.099 V25 0.047 V26 0.237 V

    27 0.384 V28 0.628 V29 0.726 V30 0.921 V31 1.068 V32 1.263 V33 1.458 V34 1.708 V35 1.854 V36 2.098 V37 2.250 V38 2.396 V39 2.592 V40 2.782 V41 3.026 V42 3.178 V43 3.422 V44 3.617 V45 3.812 V46 3.910 V47 4.154 V

    48 4.301 V49 4.496 V50 4.642 V51 4.935 V52 5.033 V53 5.180 V54 5.424 V55 5.570 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    24/220

    56 5.765 V57 5.961 V58 6.205 V59 6.357 V60 6.547 V61 6.698 V

    62 6.943 V63 6.991 V64 7.187 V65 7.382 V66 7.626 V67 7.773 V68 7.919 V69 8.163 V70 8.359 V71 8.603 V

    72 8.700 V73 8.945 V74 9.140 V75 9.335 V76 9.482 V77 9.726 V78 9.823 V79 10.068 V80 10.165 V81 10.409 V82 10.507 V83 10.702 V84 10.946 V85 11.093 V86 11.337 V87 11.484 V88 11.728 V89 11.825 V90 12.021 V91 12.221 V92 12.411 V

    93 12.509 V94 12.753 V95 12.900 V96 13.095 V97 13.247 V98 13.339 V99 13.486 V

    100 13.730 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    25/220

    101 13.974 V102 14.120 V103 14.370 V104 14.565 V105 14.760 V106 14.902 V

    107 15.151 V108 15.249 V109 15.493 V110 15.688 V111 15.932 V112 16.030 V113 16.225 V114 16.420 V115 16.567 V116 16.713 V

    117 16.909 V118 17.153 V119 17.348 V120 17.543 V121 17.739 V122 17.934 V123 18.081 V124 18.276 V125 18.374 V126 18.666 V127 18.813 V128 18.911 V129 19.155 V130 19.301 V131 19.497 V132 19.643 V133 19.838 V134 19.985 V135 20.180 V136 20.375 V137 20.620 V

    138 20.766 V139 21.010 V140 21.157 V141 21.401 V142 21.450 V143 21.645 V144 21.889 V145 22.036 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    26/220

    146 22.280 V147 22.475 V148 22.622 V149 22.768 V150 22.963 V151 23.110 V

    152 23.354 V153 23.452 V154 23.745 V155 23.891 V156 23.989 V157 24.184 V158 24.331 V159 24.526 V160 24.721 V161 24.965 V

    162 25.112 V163 25.307 V164 25.405 V165 25.649 V166 25.747 V167 25.942 V168 26.094 V169 26.284 V170 26.479 V171 26.674 V172 26.870 V173 27.065 V174 27.260 V175 27.456 V176 27.602 V177 27.846 V178 28.047 V179 28.193 V180 28.383 V181 28.579 V182 28.730 V

    183 28.872 V184 29.072 V185 29.219 V186 29.360 V187 29.609 V188 29.750 V189 29.951 V190 30.146 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    27/220

    191 30.336 V192 30.488 V193 30.683 V194 30.825 V195 31.025 V196 31.118 V

    197 31.313 V198 31.465 V199 31.660 V200 31.752 V201 31.899 V202 32.051 V203 32.246 V204 32.441 V205 32.588 V206 32.783 V

    207 32.978 V208 33.125 V209 33.266 V210 33.418 V211 33.564 V212 33.760 V213 33.906 V214 34.101 V215 34.248 V216 34.346 V217 34.536 V218 34.633 V219 34.829 V220 34.926 V221 35.170 V222 35.268 V223 35.463 V224 35.610 V225 35.756 V226 35.903 V227 36.044 V

    228 36.142 V229 36.332 V230 36.478 V231 36.625 V232 36.766 V233 36.956 V234 37.092 V235 37.136 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    28/220

    236 37.125 V237 37.120 V238 37.115 V239 37.109 V240 37.099 V241 37.093 V

    242 37.088 V243 37.088 V244 37.083 V245 37.077 V246 37.077 V247 37.072 V248 37.072 V249 37.067 V250 37.067 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    29/220

    Condiciones de medida de #a cura caracter6stica 1.

      nde en e# &r'(co desp#'cense con e# cursor").55 21*.0 W

    Intensidad " Potencia W"8.20 A -15.1 W8.21 A -31.3 W8.17 A -29.7 W8.17 A -28.4 W8.19 A -28.8 W8.17 A -26.4 W8.16 A -24.9 W8.14 A -23.6 W8.14 A -22.1 W8.13 A -20.9 W

    , T787S 97S :;CICI7S$ ?,IC

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    30/220

    8.14 A -19.0 W8.13 A -18.6 W8.13 A -16.6 W8.13 A -15.4 W8.12 A -13.5 W8.13 A -12.7 W

    8.14 A -10.4 W8.14 A -9.2 W8.14 A -7.6 W8.14 A -6.8 W8.14 A -4.4 W8.15 A -4.4 W8.14 A -2.8 W8.13 A -0.8 W8.13 A 0.4 W8.14 A 1.9 W

    8.14 A 3.1 W8.14 A 5.1 W8.14 A 5.9 W8.14 A 7.5 W8.14 A 8.7 W8.14 A 10.3 W8.14 A 11.9 W8.13 A 13.9 W8.15 A 15.1 W8.13 A 17.1 W8.14 A 18.3 W8.12 A 19.5 W8.14 A 21.1 W8.13 A 22.6 W8.15 A 24.6 W8.12 A 25.8 W8.14 A 27.8 W8.14 A 29.4 W8.12 A 31.0 W8.14 A 31.8 W8.14 A 33.8 W

    8.14 A 35.0 W8.14 A 36.6 W8.14 A 37.8 W8.14 A 40.2 W8.14 A 41.0 W8.14 A 42.2 W8.14 A 44.1 W8.14 A 45.3 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    31/220

    8.14 A 46.9 W8.14 A 48.5 W8.14 A 50.5 W8.13 A 51.7 W8.14 A 53.3 W8.13 A 54.5 W

    8.13 A 56.4 W8.13 A 56.8 W8.13 A 58.4 W8.13 A 60.0 W8.13 A 62.0 W8.13 A 63.2 W8.13 A 64.4 W8.13 A 66.4 W8.13 A 68.0 W8.13 A 69.9 W

    8.13 A 70.7 W8.13 A 72.7 W8.13 A 74.3 W8.13 A 75.9 W8.13 A 77.1 W8.13 A 79.1 W8.13 A 79.9 W8.13 A 81.9 W8.13 A 82.6 W8.13 A 84.6 W8.13 A 85.4 W8.12 A 86.9 W8.12 A 88.8 W8.12 A 90.0 W8.12 A 92.0 W8.13 A 93.4 W8.13 A 95.3 W8.12 A 96.0 W8.13 A 97.7 W8.11 A 99.1 W8.12 A 100.7 W

    8.12 A 101.5 W8.13 A 103.7 W8.12 A 104.7 W8.12 A 106.3 W8.11 A 107.4 W8.12 A 108.3 W8.12 A 109.5 W8.12 A 111.4 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    32/220

    8.12 A 113.4 W8.12 A 114.6 W8.11 A 116.5 W8.11 A 118.1 W8.11 A 119.7 W8.12 A 120.9 W

    8.11 A 122.8 W8.11 A 123.6 W8.11 A 125.6 W8.11 A 127.2 W8.11 A 129.2 W8.11 A 130.0 W8.11 A 131.6 W8.11 A 133.1 W8.11 A 134.3 W8.11 A 135.5 W

    8.09 A 136.8 W8.11 A 139.1 W8.09 A 140.4 W8.09 A 142.0 W8.09 A 143.6 W8.09 A 145.1 W8.09 A 146.3 W8.09 A 147.9 W8.09 A 148.7 W8.09 A 151.1 W8.09 A 152.3 W8.09 A 153.0 W8.09 A 155.0 W8.09 A 156.2 W8.09 A 157.8 W8.09 A 159.0 W8.09 A 160.5 W8.09 A 161.7 W8.09 A 163.3 W8.08 A 164.6 W8.08 A 166.6 W

    8.08 A 167.8 W8.08 A 169.7 W8.08 A 170.9 W8.08 A 172.9 W8.08 A 173.3 W8.08 A 174.9 W8.08 A 176.8 W8.06 A 177.7 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    33/220

    8.08 A 180.0 W8.06 A 181.2 W8.08 A 182.8 W8.06 A 183.6 W8.06 A 185.2 W8.06 A 186.4 W

    8.06 A 188.3 W8.06 A 189.1 W8.05 A 191.1 W8.06 A 192.7 W8.05 A 193.1 W8.05 A 194.7 W8.05 A 195.8 W8.04 A 197.1 W8.04 A 198.6 W8.02 A 200.2 W

    8.02 A 201.4 W8.02 A 203.0 W8.01 A 203.4 W8.01 A 205.3 W7.99 A 205.7 W7.98 A 206.9 W7.97 A 207.9 W7.96 A 209.3 W7.95 A 210.4 W7.93 A 211.6 W7.92 A 212.8 W7.89 A 213.5 W7.86 A 214.2 W7.84 A 215.4 W7.82 A 215.7 W7.77 A 216.4 W7.72 A 216.5 W7.71 A 217.2 W7.65 A 217.2 W7.63 A 217.9 W7.57 A 217.6 W

    7.55 A 218.0 W7.49 A 217.6 W7.44 A 217.4 W7.39 A 217.0 W7.31 A 216.4 W7.26 A 215.9 W7.16 A 214.5 W7.09 A 213.7 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    34/220

    7.00 A 212.2 W6.93 A 211.2 W6.83 A 209.4 W6.78 A 208.8 W6.64 A 205.9 W6.57 A 204.4 W

    6.44 A 201.6 W6.36 A 200.0 W6.21 A 196.6 W6.15 A 195.1 W6.03 A 192.3 W5.92 A 189.7 W5.77 A 186.1 W5.60 A 181.5 W5.49 A 179.0 W5.27 A 172.9 W

    5.13 A 169.1 W4.95 A 164.0 W4.86 A 161.5 W4.64 A 155.2 W4.50 A 150.9 W4.31 A 145.4 W4.19 A 142.0 W3.94 A 134.4 W3.75 A 128.4 W3.60 A 123.7 W3.39 A 117.1 W3.26 A 112.9 W3.03 A 105.4 W2.85 A 99.5 W2.60 A 91.4 W2.42 A 85.5 W2.18 A 77.1 W1.97 A 70.2 W1.72 A 61.5 W1.56 A 56.0 W1.30 A 47.0 W

    1.10 A 39.7 W0.84 A 30.6 W0.67 A 24.4 W0.42 A 15.3 W0.16 A 6.0 W-0.08 A -2.9 W-0.36 A -13.2 W-0.41 A -15.1 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    35/220

    -0.41 A -15.0 W-0.41 A -15.3 W-0.40 A -15.0 W-0.40 A -14.7 W-0.38 A -14.1 W-0.40 A -14.9 W

    -0.39 A -14.6 W-0.41 A -15.1 W-0.40 A -14.8 W-0.39 A -14.5 W-0.39 A -14.5 W-0.38 A -14.2 W-0.38 A -14.2 W-0.38 A -13.9 W-0.38 A -13.9 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    36/220

    Caracter6sticas de# m-du#o Aotoo#taicoaro, 1.650 &Anco, 0.990 &r. ua), 60

    or&a ce)., ua"ra"a)a"o cua), 0.156 &

    7B:TIV7 89 :;CICI7 1. ob$eo "e e)e e$ercco e) "encar

    o) ar&ero) ecrco) :ce"a) +3,+10; "e a cur*a caracer

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    37/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    38/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    39/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    40/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    41/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    42/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    43/220

    Irradiancia 1000 W/m²Temperatura 50.0 ºCI)c2Voc2G&2 120.0 WI&2 8.24 A

    V&2 14.571 V2 :%; #DIV/0!

    7.3%

    8.2%

    10 1.5)1 V

    Punto ,r. Tensi-n V"1 -1.801 V2 -3.823 V3 -3.702 V4 -3.435 V5 -3.467 V6 -3.217 V7 -2.979 V8 -2.832 V

    cenca2 :)/A&o";

    cenca2 :)/Ace;

    P;7C8I

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    44/220

    9 -2.637 V10 -2.496 V11 -2.301 V12 -2.209 V13 -1.965 V14 -1.873 V

    15 -1.580 V16 -1.537 V17 -1.255 V18 -1.060 V19 -0.876 V20 -0.778 V21 -0.540 V22 -0.497 V23 -0.350 V24 -0.106 V

    25 -0.008 V26 0.285 V27 0.382 V28 0.626 V29 0.724 V30 0.925 V31 1.120 V32 1.316 V33 1.462 V34 1.706 V35 1.853 V36 2.103 V37 2.249 V38 2.396 V39 2.640 V40 2.835 V41 3.085 V42 3.232 V43 3.476 V44 3.622 V45 3.866 V

    46 3.915 V47 4.159 V48 4.306 V49 4.550 V50 4.648 V51 4.940 V52 5.087 V53 5.233 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    45/220

    54 5.478 V55 5.630 V56 5.825 V57 6.020 V58 6.265 V59 6.362 V

    60 6.606 V61 6.753 V62 6.948 V63 7.046 V64 7.241 V65 7.388 V66 7.632 V67 7.827 V68 7.974 V69 8.218 V

    70 8.413 V71 8.608 V72 8.755 V73 8.950 V74 9.194 V75 9.390 V76 9.536 V77 9.731 V78 9.878 V79 10.073 V80 10.220 V81 10.464 V82 10.513 V83 10.708 V84 10.952 V85 11.099 V86 11.348 V87 11.544 V88 11.733 V89 11.885 V90 12.075 V

    91 12.227 V92 12.471 V93 12.569 V94 12.764 V95 12.905 V96 13.155 V97 13.247 V98 13.350 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    46/220

    99 13.546 V100 13.741 V101 13.985 V102 14.180 V103 14.425 V104 14.571 V

    105 14.815 V106 14.962 V107 15.157 V108 15.303 V109 15.499 V110 15.694 V111 15.938 V112 16.085 V113 16.231 V114 16.427 V

    115 16.573 V116 16.768 V117 16.964 V118 17.208 V119 17.354 V120 17.598 V121 17.745 V122 17.989 V123 18.087 V124 18.282 V125 18.428 V126 18.673 V127 18.819 V128 18.966 V129 19.161 V130 19.307 V131 19.552 V132 19.649 V133 19.844 V134 19.991 V135 20.235 V

    136 20.382 V137 20.626 V138 20.821 V139 21.016 V140 21.163 V141 21.358 V142 21.505 V143 21.700 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    47/220

    144 21.944 V145 22.091 V146 22.286 V147 22.481 V148 22.677 V149 22.774 V

    150 22.969 V151 23.116 V152 23.360 V153 23.507 V154 23.702 V155 23.897 V156 24.044 V157 24.190 V158 24.337 V159 24.532 V

    160 24.678 V161 24.923 V162 25.069 V163 25.264 V164 25.411 V165 25.606 V166 25.704 V167 25.899 V168 25.997 V169 26.241 V170 26.387 V171 26.632 V172 26.778 V173 26.973 V174 27.169 V175 27.315 V176 27.510 V177 27.711 V178 27.901 V179 28.048 V180 28.249 V

    181 28.389 V182 28.536 V183 28.682 V184 28.878 V185 29.024 V186 29.176 V187 29.366 V188 29.518 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    48/220

    189 29.708 V190 29.854 V191 30.050 V192 30.196 V193 30.397 V194 30.538 V

    195 30.690 V196 30.831 V197 30.983 V198 31.129 V199 31.325 V200 31.422 V201 31.563 V202 31.715 V203 31.911 V204 32.100 V

    205 32.198 V206 32.399 V207 32.594 V208 32.741 V209 32.887 V210 33.034 V211 33.180 V212 33.327 V213 33.473 V214 33.669 V215 33.815 V216 33.961 V217 34.108 V218 34.206 V219 34.450 V220 34.547 V221 34.645 V222 34.645 V223 34.645 V224 34.645 V225 34.645 V

    226 34.645 V227 34.639 V228 34.639 V229 34.639 V230 34.639 V231 34.639 V232 34.639 V233 34.639 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    49/220

    234 34.634 V235 34.634 V236 34.634 V237 34.628 V238 34.622 V239 34.617 V

    240 34.611 V241 34.611 V242 34.605 V243 34.550 V244 34.588 V245 34.582 V246 34.576 V247 34.564 V248 34.516 V249 34.504 V

    250 34.498 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    50/220

    Condiciones de medida de #a cura caracter6stica 2.

    Ca#cu#e #os CoeAs. de T entre #as curas 1 G 2Isc2 Isc1 H 0.00Voc2 Voc1 H 0.0Pmpp2 Pmpp1 H +2.2

    T2 T1 H 25.0a#Aa !/ºC sore Isc1"J K8IV/0Leta !/ºC sore Voc1"J K8IV/0L

    &amma !/ºC sore Pmpp1"J 0.*3!

    *.2 120.0 W

    Intensidad " Potencia W"8.33 A -15.0 W8.35 A -31.9 W8.33 A -30.8 W8.30 A -28.5 W8.30 A -28.8 W8.31 A -26.7 W8.30 A -24.7 W8.32 A -23.6 W

    Ee e cur)or en e uno "e &&a oenca ara obener o) *aore) correco) en

    en a) ce"a) D4,D10.

    0.000 V +0.000 V 0.000 V50.0 W

    0.0 W

    50.0 W

    100.0 W

    150.0 W

    200.0 W

    250.0 W

    20.0 W

    er6stica 2

    i-n V"

       P  o   t  e  n  c   i  a      W   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    51/220

    8.32 A -21.9 W8.32 A -20.8 W8.31 A -19.1 W8.32 A -18.4 W8.29 A -16.3 W8.28 A -15.5 W

    8.28 A -13.1 W8.27 A -12.7 W8.29 A -10.4 W8.28 A -8.8 W8.29 A -7.3 W8.28 A -6.4 W8.29 A -4.5 W8.29 A -4.1 W8.31 A -2.9 W8.31 A -0.9 W

    8.31 A -0.1 W8.31 A 2.4 W8.31 A 3.2 W8.31 A 5.2 W8.31 A 6.0 W8.30 A 7.7 W8.29 A 9.3 W8.29 A 10.9 W8.29 A 12.1 W8.29 A 14.1 W8.29 A 15.4 W8.28 A 17.4 W8.28 A 18.6 W8.28 A 19.8 W8.28 A 21.9 W8.28 A 23.5 W8.27 A 25.5 W8.27 A 26.7 W8.27 A 28.7 W8.27 A 30.0 W8.27 A 32.0 W

    8.27 A 32.4 W8.27 A 34.4 W8.27 A 35.6 W8.27 A 37.6 W8.27 A 38.4 W8.27 A 40.9 W8.27 A 42.1 W8.28 A 43.4 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    52/220

    8.27 A 45.3 W8.26 A 46.5 W8.26 A 48.1 W8.26 A 49.7 W8.26 A 51.8 W8.26 A 52.6 W

    8.26 A 54.6 W8.26 A 55.8 W8.26 A 57.4 W8.26 A 58.2 W8.26 A 59.8 W8.26 A 61.0 W8.26 A 63.0 W8.26 A 64.7 W8.26 A 65.9 W8.26 A 67.9 W

    8.26 A 69.5 W8.26 A 71.1 W8.26 A 72.3 W8.26 A 73.9 W8.26 A 76.0 W8.26 A 77.6 W8.26 A 78.8 W8.26 A 80.4 W8.26 A 81.6 W8.26 A 83.2 W8.26 A 84.4 W8.26 A 86.4 W8.26 A 86.8 W8.26 A 88.5 W8.26 A 90.5 W8.26 A 91.7 W8.25 A 93.7 W8.25 A 95.3 W8.26 A 96.9 W8.25 A 98.1 W8.26 A 99.8 W

    8.25 A 100.9 W8.25 A 102.9 W8.25 A 103.7 W8.25 A 105.3 W8.26 A 106.6 W8.25 A 108.6 W8.26 A 109.4 W8.24 A 110.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    53/220

    8.24 A 111.6 W8.24 A 113.2 W8.24 A 115.2 W8.24 A 116.8 W8.24 A 118.8 W8.24 A 120.0 W

    8.24 A 122.1 W8.24 A 123.3 W8.24 A 124.9 W8.24 A 126.1 W8.24 A 127.7 W8.24 A 129.3 W8.24 A 131.3 W8.24 A 132.5 W8.24 A 133.7 W8.24 A 135.3 W

    8.24 A 136.5 W8.24 A 138.1 W8.22 A 139.5 W8.22 A 141.5 W8.22 A 142.7 W8.22 A 144.7 W8.22 A 145.9 W8.22 A 147.9 W8.22 A 148.7 W8.22 A 150.3 W8.22 A 151.5 W8.21 A 153.3 W8.21 A 154.5 W8.21 A 155.7 W8.21 A 157.3 W8.21 A 158.5 W8.21 A 160.5 W8.21 A 161.3 W8.21 A 162.9 W8.21 A 164.1 W8.19 A 165.8 W

    8.19 A 167.0 W8.19 A 169.0 W8.18 A 170.3 W8.18 A 171.9 W8.18 A 173.1 W8.18 A 174.7 W8.18 A 175.9 W8.17 A 177.2 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    54/220

    8.15 A 178.9 W8.15 A 180.0 W8.14 A 181.3 W8.14 A 182.9 W8.12 A 184.2 W8.12 A 184.9 W

    8.11 A 186.2 W8.09 A 187.0 W8.08 A 188.7 W8.06 A 189.5 W8.03 A 190.4 W8.02 A 191.6 W8.00 A 192.4 W7.98 A 192.9 W7.95 A 193.4 W7.93 A 194.6 W

    7.90 A 195.0 W7.86 A 195.8 W7.83 A 196.2 W7.78 A 196.7 W7.77 A 197.4 W7.71 A 197.4 W7.68 A 197.4 W7.62 A 197.4 W7.61 A 197.8 W7.52 A 197.3 W7.46 A 196.9 W7.40 A 197.2 W7.35 A 196.7 W7.26 A 195.7 W7.17 A 194.8 W7.11 A 194.2 W7.01 A 192.8 W6.91 A 191.5 W6.80 A 189.8 W6.74 A 189.2 W6.60 A 186.6 W

    6.52 A 185.2 W6.39 A 182.4 W6.33 A 181.7 W6.19 A 178.7 W6.10 A 177.0 W5.97 A 174.3 W5.82 A 170.9 W5.71 A 168.6 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    55/220

    5.53 A 164.2 W5.40 A 161.1 W5.22 A 156.9 W5.12 A 154.5 W4.92 A 149.5 W4.80 A 146.5 W

    4.61 A 141.5 W4.50 A 138.8 W4.29 A 132.9 W4.14 A 129.0 W3.94 A 123.4 W3.82 A 120.1 W3.65 A 115.3 W3.46 A 109.6 W3.28 A 104.6 W3.04 A 97.5 W

    2.91 A 93.6 W2.65 A 85.8 W2.43 A 79.2 W2.21 A 72.3 W2.09 A 68.8 W1.81 A 59.9 W1.62 A 53.9 W1.39 A 46.3 W1.26 A 42.1 W0.95 A 32.0 W0.73 A 24.7 W0.54 A 18.3 W0.29 A 9.9 W0.13 A 4.4 W-0.16 A -5.6 W-0.38 A -13.2 W-0.50 A -17.3 W-0.52 A -17.8 W-0.52 A -17.8 W-0.53 A -18.3 W-0.53 A -18.3 W

    -0.53 A -18.3 W-0.52 A -18.1 W-0.52 A -18.1 W-0.52 A -18.1 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    56/220

    -0.53 A -18.3 W-0.53 A -18.3 W-0.53 A -18.3 W-0.52 A -18.0 W-0.51 A -17.7 W-0.50 A -17.5 W

    -0.50 A -17.2 W-0.48 A -16.7 W-0.47 A -16.4 W-0.47 A -16.1 W-0.45 A -15.5 W-0.44 A -15.3 W-0.43 A -15.0 W-0.42 A -14.4 W-0.43 A -14.9 W-0.42 A -14.3 W

    -0.41 A -14.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    57/220

    Irradiancia 1000 W/m²Temperatura )0.0 ºCI)c3Voc3G&3 110.2 WI&3 8.32 A

    V&3 13.249 V3 :%; #DIV/0!

    6.7%

    7.5%

    4) 1+.24 V

    Punto ,r. Tensi-n V"1 -1.740 V2 -3.810 V3 -3.640 V4 -3.384 V5 -3.476 V6 -3.232 V7 -2.993 V8 -2.853 V

    cenca3 :)/A&o";

    cenca3 :)/Ace;

    P;7C8I

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    58/220

    9 -2.657 V10 -2.560 V11 -2.273 V12 -2.224 V13 -1.980 V14 -1.882 V

    15 -1.644 V16 -1.503 V17 -1.216 V18 -1.075 V19 -0.880 V20 -0.782 V21 -0.538 V22 -0.490 V23 -0.300 V24 -0.050 V

    25 0.048 V26 0.292 V27 0.438 V28 0.682 V29 0.780 V30 0.975 V31 1.171 V32 1.317 V33 1.512 V34 1.757 V35 1.909 V36 2.153 V37 2.300 V38 2.397 V39 2.641 V40 2.837 V41 3.087 V42 3.233 V43 3.471 V44 3.673 V45 3.819 V

    46 3.966 V47 4.161 V48 4.307 V49 4.552 V50 4.698 V51 4.942 V52 5.089 V53 5.284 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    59/220

    54 5.479 V55 5.626 V56 5.821 V57 6.016 V58 6.261 V59 6.407 V

    60 6.602 V61 6.755 V62 6.950 V63 7.097 V64 7.243 V65 7.389 V66 7.634 V67 7.829 V68 7.975 V69 8.220 V

    70 8.415 V71 8.610 V72 8.757 V73 9.001 V74 9.196 V75 9.391 V76 9.538 V77 9.782 V78 9.880 V79 10.075 V80 10.270 V81 10.466 V82 10.514 V83 10.710 V84 10.954 V85 11.149 V86 11.345 V87 11.540 V88 11.735 V89 11.882 V90 12.028 V

    91 12.223 V92 12.468 V93 12.565 V94 12.761 V95 12.907 V96 13.151 V97 13.249 V98 13.395 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    60/220

    99 13.542 V100 13.786 V101 14.030 V102 14.182 V103 14.427 V104 14.573 V

    105 14.817 V106 14.964 V107 15.208 V108 15.305 V109 15.550 V110 15.696 V111 15.940 V112 16.087 V113 16.282 V114 16.477 V

    115 16.624 V116 16.770 V117 16.966 V118 17.210 V119 17.356 V120 17.552 V121 17.747 V122 17.991 V123 18.089 V124 18.333 V125 18.479 V126 18.675 V127 18.821 V128 18.968 V129 19.163 V130 19.358 V131 19.554 V132 19.700 V133 19.847 V134 19.993 V135 20.237 V

    136 20.384 V137 20.677 V138 20.823 V139 21.018 V140 21.165 V141 21.409 V142 21.507 V143 21.702 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    61/220

    144 21.897 V145 22.044 V146 22.288 V147 22.434 V148 22.630 V149 22.727 V

    150 22.923 V151 23.069 V152 23.313 V153 23.460 V154 23.655 V155 23.802 V156 23.948 V157 24.143 V158 24.241 V159 24.436 V

    160 24.632 V161 24.827 V162 24.973 V163 25.169 V164 25.315 V165 25.511 V166 25.608 V167 25.804 V168 25.901 V169 26.097 V170 26.243 V171 26.438 V172 26.634 V173 26.829 V174 27.024 V175 27.128 V176 27.323 V177 27.518 V178 27.708 V179 27.860 V180 28.050 V

    181 28.196 V182 28.343 V183 28.489 V184 28.641 V185 28.782 V186 28.934 V187 29.130 V188 29.270 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    62/220

    189 29.472 V190 29.618 V191 29.764 V192 29.905 V193 30.100 V194 30.253 V

    195 30.448 V196 30.546 V197 30.741 V198 30.882 V199 31.034 V200 31.180 V201 31.327 V202 31.473 V203 31.620 V204 31.815 V

    205 31.913 V206 32.108 V207 32.255 V208 32.401 V209 32.548 V210 32.645 V211 32.694 V212 32.694 V213 32.694 V214 32.694 V215 32.694 V216 32.743 V217 32.694 V218 32.743 V219 32.737 V220 32.743 V221 32.737 V222 32.694 V223 32.737 V224 32.737 V225 32.737 V

    226 32.737 V227 32.737 V228 32.737 V229 32.737 V230 32.737 V231 32.731 V232 32.731 V233 32.725 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    63/220

    234 32.720 V235 32.714 V236 32.659 V237 32.653 V238 32.647 V239 32.641 V

    240 32.629 V241 32.623 V242 32.666 V243 32.605 V244 32.605 V245 32.544 V246 32.593 V247 32.587 V248 32.581 V249 32.532 V

    250 32.532 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    64/220

    Condiciones de medida de #a cura caracter6stica +.

    Ca#cu#e #os CoeAs. de T entre #as curas 1 G +Isc+ Isc1 H 0.00Voc+ Voc1 H 0.0Pmpp+ Pmpp1 H 2.0

    T+ T1 H 5.0a#Aa !/ºC sore Isc1"J K8IV/0Leta !/ºC sore Voc1"J K8IV/0L

    &amma !/ºC sore Pmpp1"J 0.31!

    *.+2 110.2 W

    Intensidad " Potencia W"8.41 A -14.6 W8.43 A -32.1 W8.38 A -30.5 W8.40 A -28.4 W8.40 A -29.2 W8.39 A -27.1 W8.40 A -25.1 W8.39 A -23.9 W

      e uno "e &&a oenca ara obener o) *aore) correco) en 5,10;."a) J4,J10.

    20.000 V +0.000 V 0.000 V

    50.0 W

    0.0 W

    50.0 W

    100.0 W

    150.0 W

    200.0 W 

    10.2 W

    ter6stica +

    si-n V"

       P  o   t  e  n  c   i  a      W   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    65/220

    8.39 A -22.3 W8.38 A -21.4 W8.37 A -19.0 W8.37 A -18.6 W8.37 A -16.6 W8.35 A -15.7 W

    8.35 A -13.7 W8.36 A -12.6 W8.36 A -10.2 W8.36 A -9.0 W8.36 A -7.4 W8.36 A -6.5 W8.36 A -4.5 W8.36 A -4.1 W8.37 A -2.5 W8.37 A -0.4 W

    8.36 A 0.4 W8.36 A 2.4 W8.36 A 3.7 W8.36 A 5.7 W8.36 A 6.5 W8.36 A 8.2 W8.36 A 9.8 W8.36 A 11.0 W8.36 A 12.6 W8.36 A 14.7 W8.35 A 15.9 W8.36 A 18.0 W8.36 A 19.2 W8.35 A 20.0 W8.36 A 22.1 W8.35 A 23.7 W8.36 A 25.8 W8.34 A 27.0 W8.36 A 29.0 W8.34 A 30.6 W8.34 A 31.9 W

    8.36 A 33.1 W8.36 A 34.8 W8.34 A 35.9 W8.36 A 38.0 W8.36 A 39.3 W8.36 A 41.3 W8.36 A 42.5 W8.36 A 44.2 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    66/220

    8.36 A 45.8 W8.34 A 46.9 W8.34 A 48.6 W8.36 A 50.3 W8.36 A 52.3 W8.34 A 53.4 W

    8.36 A 55.2 W8.35 A 56.4 W8.35 A 58.0 W8.35 A 59.2 W8.33 A 60.4 W8.35 A 61.7 W8.33 A 63.6 W8.33 A 65.2 W8.33 A 66.5 W8.33 A 68.5 W

    8.33 A 70.1 W8.33 A 71.8 W8.33 A 73.0 W8.33 A 75.0 W8.33 A 76.6 W8.33 A 78.3 W8.33 A 79.5 W8.33 A 81.5 W8.33 A 82.3 W8.33 A 84.0 W8.33 A 85.6 W8.33 A 87.2 W8.33 A 87.6 W8.33 A 89.2 W8.33 A 91.3 W8.33 A 92.9 W8.33 A 94.5 W8.32 A 96.0 W8.33 A 97.8 W8.33 A 99.0 W8.33 A 100.2 W

    8.32 A 101.7 W8.32 A 103.7 W8.32 A 104.5 W8.32 A 106.2 W8.32 A 107.4 W8.32 A 109.4 W8.32 A 110.2 W8.32 A 111.4 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    67/220

    8.32 A 112.6 W8.32 A 114.7 W8.32 A 116.7 W8.31 A 117.9 W8.31 A 119.9 W8.30 A 120.9 W

    8.30 A 122.9 W8.30 A 124.1 W8.30 A 126.2 W8.30 A 127.0 W8.30 A 129.0 W8.30 A 130.2 W8.30 A 132.2 W8.30 A 133.5 W8.30 A 135.1 W8.30 A 136.7 W

    8.28 A 137.7 W8.28 A 138.9 W8.27 A 140.2 W8.27 A 142.3 W8.28 A 143.7 W8.27 A 145.1 W8.27 A 146.7 W8.27 A 148.7 W8.27 A 149.5 W8.25 A 151.3 W8.25 A 152.5 W8.25 A 154.1 W8.24 A 155.0 W8.24 A 156.2 W8.24 A 157.9 W8.22 A 159.2 W8.22 A 160.8 W8.22 A 162.0 W8.21 A 162.9 W8.21 A 164.1 W8.19 A 165.8 W

    8.18 A 166.7 W8.16 A 168.8 W8.15 A 169.7 W8.14 A 171.0 W8.11 A 171.6 W8.09 A 173.2 W8.09 A 174.0 W8.06 A 175.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    68/220

    8.03 A 175.9 W8.00 A 176.4 W7.97 A 177.7 W7.94 A 178.2 W7.90 A 178.8 W7.89 A 179.2 W

    7.86 A 180.1 W7.81 A 180.2 W7.75 A 180.8 W7.73 A 181.2 W7.67 A 181.3 W7.61 A 181.1 W7.58 A 181.5 W7.52 A 181.5 W7.46 A 180.9 W7.40 A 180.9 W

    7.33 A 180.5 W7.24 A 179.8 W7.18 A 179.4 W7.10 A 178.6 W7.04 A 178.1 W6.93 A 176.9 W6.89 A 176.4 W6.79 A 175.1 W6.71 A 173.9 W6.58 A 171.8 W6.49 A 170.4 W6.38 A 168.6 W6.25 A 166.3 W6.11 A 164.0 W5.97 A 161.2 W5.89 A 159.7 W5.72 A 156.4 W5.61 A 154.3 W5.43 A 150.3 W5.33 A 148.5 W5.15 A 144.4 W

    5.02 A 141.4 W4.85 A 137.6 W4.77 A 135.8 W4.55 A 130.4 W4.43 A 127.5 W4.27 A 123.7 W4.07 A 118.5 W3.95 A 115.5 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    69/220

    3.70 A 109.1 W3.54 A 104.9 W3.32 A 98.9 W3.21 A 96.1 W2.98 A 89.7 W2.81 A 85.0 W

    2.59 A 78.8 W2.46 A 75.1 W2.22 A 68.4 W2.06 A 63.5 W1.81 A 56.3 W1.67 A 52.0 W1.46 A 45.8 W1.24 A 39.1 W1.04 A 32.8 W0.77 A 24.6 W

    0.63 A 20.0 W0.36 A 11.7 W0.13 A 4.2 W-0.09 A -3.0 W-0.22 A -7.3 W-0.50 A -16.4 W-0.52 A -16.9 W-0.52 A -16.9 W-0.52 A -16.9 W-0.53 A -17.3 W-0.53 A -17.3 W-0.53 A -17.4 W-0.53 A -17.3 W-0.53 A -17.4 W-0.54 A -17.6 W-0.55 A -17.9 W-0.54 A -17.6 W-0.55 A -17.8 W-0.55 A -18.1 W-0.54 A -17.6 W-0.54 A -17.6 W

    -0.54 A -17.6 W-0.55 A -18.1 W-0.55 A -18.1 W-0.54 A -17.6 W-0.54 A -17.6 W-0.53 A -17.3 W-0.53 A -17.3 W-0.52 A -17.1 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    70/220

    -0.51 A -16.8 W-0.51 A -16.5 W-0.50 A -16.2 W-0.47 A -15.5 W-0.47 A -15.2 W-0.46 A -14.9 W

    -0.44 A -14.4 W-0.43 A -14.1 W-0.43 A -13.9 W-0.41 A -13.3 W-0.42 A -13.8 W-0.41 A -13.2 W-0.42 A -13.7 W-0.40 A -13.0 W-0.39 A -12.7 W-0.39 A -12.7 W

    -0.39 A -12.7 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    71/220

    K8IV/0LK8IV/0L

    0.)+0!

    :;CICI7 8ICI7,9 P;7P>ST7. o&ruebe o) *aore) ro&e"o "e o)coecene) aa' bea a&&a oben"o)en a) ce"a) 8,10.

    P7; => ,7 S9, 97S

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    72/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    73/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    74/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    75/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    76/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    77/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    78/220

    Irradiancia 1000 W/m²Temperatura 50.0 ºCI)c2 8.30 AVoc2 34.300 VG&2 197.8 WI&2 7.61 A

    V&2 25.997 V2 :%; 69.5%

    12.1%

    13.5%

    13* 25.44) V

    Punto ,r. Tensi-n V"1 -1.801 V

    2 -3.823 V3 -3.702 V4 -3.435 V5 -3.467 V6 -3.217 V7 -2.979 V8 -2.832 V9 -2.637 V

    cenca2 :)/A&o";

    cenca2 :)/Ace;

    P;7C8I

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    79/220

    10 -2.496 V11 -2.301 V12 -2.209 V13 -1.965 V14 -1.873 V15 -1.580 V

    16 -1.537 V17 -1.255 V18 -1.060 V19 -0.876 V20 -0.778 V21 -0.540 V22 -0.497 V23 -0.350 V24 -0.106 V25 -0.008 V

    26 0.285 V27 0.382 V28 0.626 V29 0.724 V30 0.925 V31 1.120 V32 1.316 V33 1.462 V34 1.706 V35 1.853 V36 2.103 V37 2.249 V38 2.396 V39 2.640 V40 2.835 V41 3.085 V42 3.232 V43 3.476 V44 3.622 V45 3.866 V46 3.915 V

    47 4.159 V48 4.306 V49 4.550 V50 4.648 V51 4.940 V52 5.087 V53 5.233 V54 5.478 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    80/220

    55 5.630 V56 5.825 V57 6.020 V58 6.265 V59 6.362 V60 6.606 V

    61 6.753 V62 6.948 V63 7.046 V64 7.241 V65 7.388 V66 7.632 V67 7.827 V68 7.974 V69 8.218 V70 8.413 V

    71 8.608 V72 8.755 V73 8.950 V74 9.194 V75 9.390 V76 9.536 V77 9.731 V78 9.878 V79 10.073 V80 10.220 V81 10.464 V82 10.513 V83 10.708 V84 10.952 V85 11.099 V86 11.348 V87 11.544 V88 11.733 V89 11.885 V90 12.075 V91 12.227 V

    92 12.471 V93 12.569 V94 12.764 V95 12.905 V96 13.155 V97 13.247 V98 13.350 V99 13.546 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    81/220

    100 13.741 V101 13.985 V102 14.180 V103 14.425 V104 14.571 V105 14.815 V

    106 14.962 V107 15.157 V108 15.303 V109 15.499 V110 15.694 V111 15.938 V112 16.085 V113 16.231 V114 16.427 V115 16.573 V

    116 16.768 V117 16.964 V118 17.208 V119 17.354 V120 17.598 V121 17.745 V122 17.989 V123 18.087 V124 18.282 V125 18.428 V126 18.673 V127 18.819 V128 18.966 V129 19.161 V130 19.307 V131 19.552 V132 19.649 V133 19.844 V134 19.991 V135 20.235 V136 20.382 V

    137 20.626 V138 20.821 V139 21.016 V140 21.163 V141 21.358 V142 21.505 V143 21.700 V144 21.944 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    82/220

    145 22.091 V146 22.286 V147 22.481 V148 22.677 V149 22.774 V150 22.969 V

    151 23.116 V152 23.360 V153 23.507 V154 23.702 V155 23.897 V156 24.044 V157 24.190 V158 24.337 V159 24.532 V160 24.678 V

    161 24.923 V162 25.069 V163 25.264 V164 25.411 V165 25.606 V166 25.704 V167 25.899 V168 25.997 V169 26.241 V170 26.387 V171 26.632 V172 26.778 V173 26.973 V174 27.169 V175 27.315 V176 27.510 V177 27.711 V178 27.901 V179 28.048 V180 28.249 V181 28.389 V

    182 28.536 V183 28.682 V184 28.878 V185 29.024 V186 29.176 V187 29.366 V188 29.518 V189 29.708 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    83/220

    190 29.854 V191 30.050 V192 30.196 V193 30.397 V194 30.538 V195 30.690 V

    196 30.831 V197 30.983 V198 31.129 V199 31.325 V200 31.422 V201 31.563 V202 31.715 V203 31.911 V204 32.100 V205 32.198 V

    206 32.399 V207 32.594 V208 32.741 V209 32.887 V210 33.034 V211 33.180 V212 33.327 V213 33.473 V214 33.669 V215 33.815 V216 33.961 V217 34.108 V218 34.206 V219 34.450 V220 34.547 V221 34.645 V222 34.645 V223 34.645 V224 34.645 V225 34.645 V226 34.645 V

    227 34.639 V228 34.639 V229 34.639 V230 34.639 V231 34.639 V232 34.639 V233 34.639 V234 34.634 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    84/220

    235 34.634 V236 34.634 V237 34.628 V238 34.622 V239 34.617 V240 34.611 V

    241 34.611 V242 34.605 V243 34.550 V244 34.588 V245 34.582 V246 34.576 V247 34.564 V248 34.516 V249 34.504 V250 34.498 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    85/220

    Condiciones de medida de #a cura caracter6stica 2.

    Ca#cu#e #os CoeAs. de T entre #as curas 1 G 2Isc2 Isc1 H 0.1)

    Voc2 Voc1 H 2.3

    Pmpp2 Pmpp1 H 20.2

    T2 T1 H 25.0a#Aa !/ºC sore Isc1"J 0.0*!eta !/ºC sore Voc1"J 0.2*2!

    &amma !/ºC sore Pmpp1"J 0.+)1!

    ).31 14).* W

    Intensidad " Potencia W"8.33 A -15.0 W

    8.35 A -31.9 W8.33 A -30.8 W8.30 A -28.5 W8.30 A -28.8 W8.31 A -26.7 W8.30 A -24.7 W8.32 A -23.6 W8.32 A -21.9 W

    e uno "e &&a oenca ara obener o) *aore) correco) en +5,+10;.; o) re)ua"o) oben"o) en a) ce"a) D4,D10.

    0.000 V +0.000 V 0.000 V50.0 W

    0.0 W

    50.0 W

    100.0 W

    150.0 W

    200.0 W

    250.0 W).31 /

    1

    14).* W

    er6stica 2

    i-n V"

       P  o   t  e  n  c   i  a      W   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    86/220

    8.32 A -20.8 W8.31 A -19.1 W8.32 A -18.4 W8.29 A -16.3 W8.28 A -15.5 W8.28 A -13.1 W

    8.27 A -12.7 W8.29 A -10.4 W8.28 A -8.8 W8.29 A -7.3 W8.28 A -6.4 W8.29 A -4.5 W8.29 A -4.1 W8.31 A -2.9 W8.31 A -0.9 W8.31 A -0.1 W

    8.31 A 2.4 W8.31 A 3.2 W8.31 A 5.2 W8.31 A 6.0 W8.30 A 7.7 W8.29 A 9.3 W8.29 A 10.9 W8.29 A 12.1 W8.29 A 14.1 W8.29 A 15.4 W8.28 A 17.4 W8.28 A 18.6 W8.28 A 19.8 W8.28 A 21.9 W8.28 A 23.5 W8.27 A 25.5 W8.27 A 26.7 W8.27 A 28.7 W8.27 A 30.0 W8.27 A 32.0 W8.27 A 32.4 W

    8.27 A 34.4 W8.27 A 35.6 W8.27 A 37.6 W8.27 A 38.4 W8.27 A 40.9 W8.27 A 42.1 W8.28 A 43.4 W8.27 A 45.3 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    87/220

    8.26 A 46.5 W8.26 A 48.1 W8.26 A 49.7 W8.26 A 51.8 W8.26 A 52.6 W8.26 A 54.6 W

    8.26 A 55.8 W8.26 A 57.4 W8.26 A 58.2 W8.26 A 59.8 W8.26 A 61.0 W8.26 A 63.0 W8.26 A 64.7 W8.26 A 65.9 W8.26 A 67.9 W8.26 A 69.5 W

    8.26 A 71.1 W8.26 A 72.3 W8.26 A 73.9 W8.26 A 76.0 W8.26 A 77.6 W8.26 A 78.8 W8.26 A 80.4 W8.26 A 81.6 W8.26 A 83.2 W8.26 A 84.4 W8.26 A 86.4 W8.26 A 86.8 W8.26 A 88.5 W8.26 A 90.5 W8.26 A 91.7 W8.25 A 93.7 W8.25 A 95.3 W8.26 A 96.9 W8.25 A 98.1 W8.26 A 99.8 W8.25 A 100.9 W

    8.25 A 102.9 W8.25 A 103.7 W8.25 A 105.3 W8.26 A 106.6 W8.25 A 108.6 W8.26 A 109.4 W8.24 A 110.0 W8.24 A 111.6 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    88/220

    8.24 A 113.2 W8.24 A 115.2 W8.24 A 116.8 W8.24 A 118.8 W8.24 A 120.0 W8.24 A 122.1 W

    8.24 A 123.3 W8.24 A 124.9 W8.24 A 126.1 W8.24 A 127.7 W8.24 A 129.3 W8.24 A 131.3 W8.24 A 132.5 W8.24 A 133.7 W8.24 A 135.3 W8.24 A 136.5 W

    8.24 A 138.1 W8.22 A 139.5 W8.22 A 141.5 W8.22 A 142.7 W8.22 A 144.7 W8.22 A 145.9 W8.22 A 147.9 W8.22 A 148.7 W8.22 A 150.3 W8.22 A 151.5 W8.21 A 153.3 W8.21 A 154.5 W8.21 A 155.7 W8.21 A 157.3 W8.21 A 158.5 W8.21 A 160.5 W8.21 A 161.3 W8.21 A 162.9 W8.21 A 164.1 W8.19 A 165.8 W8.19 A 167.0 W

    8.19 A 169.0 W8.18 A 170.3 W8.18 A 171.9 W8.18 A 173.1 W8.18 A 174.7 W8.18 A 175.9 W8.17 A 177.2 W8.15 A 178.9 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    89/220

    8.15 A 180.0 W8.14 A 181.3 W8.14 A 182.9 W8.12 A 184.2 W8.12 A 184.9 W8.11 A 186.2 W

    8.09 A 187.0 W8.08 A 188.7 W8.06 A 189.5 W8.03 A 190.4 W8.02 A 191.6 W8.00 A 192.4 W7.98 A 192.9 W7.95 A 193.4 W7.93 A 194.6 W7.90 A 195.0 W

    7.86 A 195.8 W7.83 A 196.2 W7.78 A 196.7 W7.77 A 197.4 W7.71 A 197.4 W7.68 A 197.4 W7.62 A 197.4 W7.61 A 197.8 W7.52 A 197.3 W7.46 A 196.9 W7.40 A 197.2 W7.35 A 196.7 W7.26 A 195.7 W7.17 A 194.8 W7.11 A 194.2 W7.01 A 192.8 W6.91 A 191.5 W6.80 A 189.8 W6.74 A 189.2 W6.60 A 186.6 W6.52 A 185.2 W

    6.39 A 182.4 W6.33 A 181.7 W6.19 A 178.7 W6.10 A 177.0 W5.97 A 174.3 W5.82 A 170.9 W5.71 A 168.6 W5.53 A 164.2 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    90/220

    5.40 A 161.1 W5.22 A 156.9 W5.12 A 154.5 W4.92 A 149.5 W4.80 A 146.5 W4.61 A 141.5 W

    4.50 A 138.8 W4.29 A 132.9 W4.14 A 129.0 W3.94 A 123.4 W3.82 A 120.1 W3.65 A 115.3 W3.46 A 109.6 W3.28 A 104.6 W3.04 A 97.5 W2.91 A 93.6 W

    2.65 A 85.8 W2.43 A 79.2 W2.21 A 72.3 W2.09 A 68.8 W1.81 A 59.9 W1.62 A 53.9 W1.39 A 46.3 W1.26 A 42.1 W0.95 A 32.0 W0.73 A 24.7 W0.54 A 18.3 W0.29 A 9.9 W0.13 A 4.4 W-0.16 A -5.6 W-0.38 A -13.2 W-0.50 A -17.3 W-0.52 A -17.8 W-0.52 A -17.8 W-0.53 A -18.3 W-0.53 A -18.3 W-0.53 A -18.3 W

    -0.52 A -18.1 W-0.52 A -18.1 W-0.52 A -18.1 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W-0.53 A -18.3 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    91/220

    -0.53 A -18.3 W-0.53 A -18.3 W-0.52 A -18.0 W-0.51 A -17.7 W-0.50 A -17.5 W-0.50 A -17.2 W

    -0.48 A -16.7 W-0.47 A -16.4 W-0.47 A -16.1 W-0.45 A -15.5 W-0.44 A -15.3 W-0.43 A -15.0 W-0.42 A -14.4 W-0.43 A -14.9 W-0.42 A -14.3 W-0.41 A -14.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    92/220

    Irradiancia 1000 W/m²Temperatura )0.0 ºCI)c3 8.36 AVoc3 32.300 VG&3 181.3 WI&3 7.67 A

    V&3 23.655 V3 :%; 67.2%

    11.1%

    12.4%

    15 2+.355 V

    Punto ,r. Tensi-n V"1 -1.740 V

    2 -3.810 V3 -3.640 V4 -3.384 V5 -3.476 V6 -3.232 V7 -2.993 V8 -2.853 V9 -2.657 V

    cenca3 :)/A&o";

    cenca3 :)/Ace;

    P;7C8I

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    93/220

    10 -2.560 V11 -2.273 V12 -2.224 V13 -1.980 V14 -1.882 V15 -1.644 V

    16 -1.503 V17 -1.216 V18 -1.075 V19 -0.880 V20 -0.782 V21 -0.538 V22 -0.490 V23 -0.300 V24 -0.050 V25 0.048 V

    26 0.292 V27 0.438 V28 0.682 V29 0.780 V30 0.975 V31 1.171 V32 1.317 V33 1.512 V34 1.757 V35 1.909 V36 2.153 V37 2.300 V38 2.397 V39 2.641 V40 2.837 V41 3.087 V42 3.233 V43 3.471 V44 3.673 V45 3.819 V46 3.966 V

    47 4.161 V48 4.307 V49 4.552 V50 4.698 V51 4.942 V52 5.089 V53 5.284 V54 5.479 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    94/220

    55 5.626 V56 5.821 V57 6.016 V58 6.261 V59 6.407 V60 6.602 V

    61 6.755 V62 6.950 V63 7.097 V64 7.243 V65 7.389 V66 7.634 V67 7.829 V68 7.975 V69 8.220 V70 8.415 V

    71 8.610 V72 8.757 V73 9.001 V74 9.196 V75 9.391 V76 9.538 V77 9.782 V78 9.880 V79 10.075 V80 10.270 V81 10.466 V82 10.514 V83 10.710 V84 10.954 V85 11.149 V86 11.345 V87 11.540 V88 11.735 V89 11.882 V90 12.028 V91 12.223 V

    92 12.468 V93 12.565 V94 12.761 V95 12.907 V96 13.151 V97 13.249 V98 13.395 V99 13.542 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    95/220

    100 13.786 V101 14.030 V102 14.182 V103 14.427 V104 14.573 V105 14.817 V

    106 14.964 V107 15.208 V108 15.305 V109 15.550 V110 15.696 V111 15.940 V112 16.087 V113 16.282 V114 16.477 V115 16.624 V

    116 16.770 V117 16.966 V118 17.210 V119 17.356 V120 17.552 V121 17.747 V122 17.991 V123 18.089 V124 18.333 V125 18.479 V126 18.675 V127 18.821 V128 18.968 V129 19.163 V130 19.358 V131 19.554 V132 19.700 V133 19.847 V134 19.993 V135 20.237 V136 20.384 V

    137 20.677 V138 20.823 V139 21.018 V140 21.165 V141 21.409 V142 21.507 V143 21.702 V144 21.897 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    96/220

    145 22.044 V146 22.288 V147 22.434 V148 22.630 V149 22.727 V150 22.923 V

    151 23.069 V152 23.313 V153 23.460 V154 23.655 V155 23.802 V156 23.948 V157 24.143 V158 24.241 V159 24.436 V160 24.632 V

    161 24.827 V162 24.973 V163 25.169 V164 25.315 V165 25.511 V166 25.608 V167 25.804 V168 25.901 V169 26.097 V170 26.243 V171 26.438 V172 26.634 V173 26.829 V174 27.024 V175 27.128 V176 27.323 V177 27.518 V178 27.708 V179 27.860 V180 28.050 V181 28.196 V

    182 28.343 V183 28.489 V184 28.641 V185 28.782 V186 28.934 V187 29.130 V188 29.270 V189 29.472 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    97/220

    190 29.618 V191 29.764 V192 29.905 V193 30.100 V194 30.253 V195 30.448 V

    196 30.546 V197 30.741 V198 30.882 V199 31.034 V200 31.180 V201 31.327 V202 31.473 V203 31.620 V204 31.815 V205 31.913 V

    206 32.108 V207 32.255 V208 32.401 V209 32.548 V210 32.645 V211 32.694 V212 32.694 V213 32.694 V214 32.694 V215 32.694 V216 32.743 V217 32.694 V218 32.743 V219 32.737 V220 32.743 V221 32.737 V222 32.694 V223 32.737 V224 32.737 V225 32.737 V226 32.737 V

    227 32.737 V228 32.737 V229 32.737 V230 32.737 V231 32.731 V232 32.731 V233 32.725 V234 32.720 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    98/220

    235 32.714 V236 32.659 V237 32.653 V238 32.647 V239 32.641 V240 32.629 V

    241 32.623 V242 32.666 V243 32.605 V244 32.605 V245 32.544 V246 32.593 V247 32.587 V248 32.581 V249 32.532 V250 32.532 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    99/220

    Condiciones de medida de #a cura caracter6stica +.

    Ca#cu#e #os CoeAs. de T entre #as curas 1 G +Isc+ Isc1 H 0.2+

    Voc+ Voc1 H .3

    Pmpp+ Pmpp1 H +3.3)

    T+ T1 H 5.0a#Aa !/ºC sore Isc1"J 0.03+!eta !/ºC sore Voc1"J 0.2))!

    &amma !/ºC sore Pmpp1"J 0.+)!

    ).3) 1*1.+ W

    Intensidad " Potencia W"8.41 A -14.6 W

    8.43 A -32.1 W8.38 A -30.5 W8.40 A -28.4 W8.40 A -29.2 W8.39 A -27.1 W8.40 A -25.1 W8.39 A -23.9 W8.39 A -22.3 W

      e uno "e &&a oenca ara obener o) *aore) correco) en 5,10;."a) J4,J10.

    20.000 V +0.000 V 0.000 V

    50.0 W

    0.0 W

    50.0 W

    100.0 W

    150.0 W

    200.0 W

    ).3) /

    1

    1*1.+ W

    ter6stica +

    si-n V"

       P  o   t  e  n  c   i  a      W   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    100/220

    8.38 A -21.4 W8.37 A -19.0 W8.37 A -18.6 W8.37 A -16.6 W8.35 A -15.7 W8.35 A -13.7 W

    8.36 A -12.6 W8.36 A -10.2 W8.36 A -9.0 W8.36 A -7.4 W8.36 A -6.5 W8.36 A -4.5 W8.36 A -4.1 W8.37 A -2.5 W8.37 A -0.4 W8.36 A 0.4 W

    8.36 A 2.4 W8.36 A 3.7 W8.36 A 5.7 W8.36 A 6.5 W8.36 A 8.2 W8.36 A 9.8 W8.36 A 11.0 W8.36 A 12.6 W8.36 A 14.7 W8.35 A 15.9 W8.36 A 18.0 W8.36 A 19.2 W8.35 A 20.0 W8.36 A 22.1 W8.35 A 23.7 W8.36 A 25.8 W8.34 A 27.0 W8.36 A 29.0 W8.34 A 30.6 W8.34 A 31.9 W8.36 A 33.1 W

    8.36 A 34.8 W8.34 A 35.9 W8.36 A 38.0 W8.36 A 39.3 W8.36 A 41.3 W8.36 A 42.5 W8.36 A 44.2 W8.36 A 45.8 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    101/220

    8.34 A 46.9 W8.34 A 48.6 W8.36 A 50.3 W8.36 A 52.3 W8.34 A 53.4 W8.36 A 55.2 W

    8.35 A 56.4 W8.35 A 58.0 W8.35 A 59.2 W8.33 A 60.4 W8.35 A 61.7 W8.33 A 63.6 W8.33 A 65.2 W8.33 A 66.5 W8.33 A 68.5 W8.33 A 70.1 W

    8.33 A 71.8 W8.33 A 73.0 W8.33 A 75.0 W8.33 A 76.6 W8.33 A 78.3 W8.33 A 79.5 W8.33 A 81.5 W8.33 A 82.3 W8.33 A 84.0 W8.33 A 85.6 W8.33 A 87.2 W8.33 A 87.6 W8.33 A 89.2 W8.33 A 91.3 W8.33 A 92.9 W8.33 A 94.5 W8.32 A 96.0 W8.33 A 97.8 W8.33 A 99.0 W8.33 A 100.2 W8.32 A 101.7 W

    8.32 A 103.7 W8.32 A 104.5 W8.32 A 106.2 W8.32 A 107.4 W8.32 A 109.4 W8.32 A 110.2 W8.32 A 111.4 W8.32 A 112.6 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    102/220

    8.32 A 114.7 W8.32 A 116.7 W8.31 A 117.9 W8.31 A 119.9 W8.30 A 120.9 W8.30 A 122.9 W

    8.30 A 124.1 W8.30 A 126.2 W8.30 A 127.0 W8.30 A 129.0 W8.30 A 130.2 W8.30 A 132.2 W8.30 A 133.5 W8.30 A 135.1 W8.30 A 136.7 W8.28 A 137.7 W

    8.28 A 138.9 W8.27 A 140.2 W8.27 A 142.3 W8.28 A 143.7 W8.27 A 145.1 W8.27 A 146.7 W8.27 A 148.7 W8.27 A 149.5 W8.25 A 151.3 W8.25 A 152.5 W8.25 A 154.1 W8.24 A 155.0 W8.24 A 156.2 W8.24 A 157.9 W8.22 A 159.2 W8.22 A 160.8 W8.22 A 162.0 W8.21 A 162.9 W8.21 A 164.1 W8.19 A 165.8 W8.18 A 166.7 W

    8.16 A 168.8 W8.15 A 169.7 W8.14 A 171.0 W8.11 A 171.6 W8.09 A 173.2 W8.09 A 174.0 W8.06 A 175.0 W8.03 A 175.9 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    103/220

    8.00 A 176.4 W7.97 A 177.7 W7.94 A 178.2 W7.90 A 178.8 W7.89 A 179.2 W7.86 A 180.1 W

    7.81 A 180.2 W7.75 A 180.8 W7.73 A 181.2 W7.67 A 181.3 W7.61 A 181.1 W7.58 A 181.5 W7.52 A 181.5 W7.46 A 180.9 W7.40 A 180.9 W7.33 A 180.5 W

    7.24 A 179.8 W7.18 A 179.4 W7.10 A 178.6 W7.04 A 178.1 W6.93 A 176.9 W6.89 A 176.4 W6.79 A 175.1 W6.71 A 173.9 W6.58 A 171.8 W6.49 A 170.4 W6.38 A 168.6 W6.25 A 166.3 W6.11 A 164.0 W5.97 A 161.2 W5.89 A 159.7 W5.72 A 156.4 W5.61 A 154.3 W5.43 A 150.3 W5.33 A 148.5 W5.15 A 144.4 W5.02 A 141.4 W

    4.85 A 137.6 W4.77 A 135.8 W4.55 A 130.4 W4.43 A 127.5 W4.27 A 123.7 W4.07 A 118.5 W3.95 A 115.5 W3.70 A 109.1 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    104/220

    3.54 A 104.9 W3.32 A 98.9 W3.21 A 96.1 W2.98 A 89.7 W2.81 A 85.0 W2.59 A 78.8 W

    2.46 A 75.1 W2.22 A 68.4 W2.06 A 63.5 W1.81 A 56.3 W1.67 A 52.0 W1.46 A 45.8 W1.24 A 39.1 W1.04 A 32.8 W0.77 A 24.6 W0.63 A 20.0 W

    0.36 A 11.7 W0.13 A 4.2 W-0.09 A -3.0 W-0.22 A -7.3 W-0.50 A -16.4 W-0.52 A -16.9 W-0.52 A -16.9 W-0.52 A -16.9 W-0.53 A -17.3 W-0.53 A -17.3 W-0.53 A -17.4 W-0.53 A -17.3 W-0.53 A -17.4 W-0.54 A -17.6 W-0.55 A -17.9 W-0.54 A -17.6 W-0.55 A -17.8 W-0.55 A -18.1 W-0.54 A -17.6 W-0.54 A -17.6 W-0.54 A -17.6 W

    -0.55 A -18.1 W-0.55 A -18.1 W-0.54 A -17.6 W-0.54 A -17.6 W-0.53 A -17.3 W-0.53 A -17.3 W-0.52 A -17.1 W-0.51 A -16.8 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    105/220

    -0.51 A -16.5 W-0.50 A -16.2 W-0.47 A -15.5 W-0.47 A -15.2 W-0.46 A -14.9 W-0.44 A -14.4 W

    -0.43 A -14.1 W-0.43 A -13.9 W-0.41 A -13.3 W-0.42 A -13.8 W-0.41 A -13.2 W-0.42 A -13.7 W-0.40 A -13.0 W-0.39 A -12.7 W-0.39 A -12.7 W-0.39 A -12.7 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    106/220

    0.0)+!0.2)4!

    0.+)2!

    :;CICI7 8ICI7,9 P;7P>ST7. o&ruebe o) *aore) ro&e"o "e o)coecene) aa' bea a&&a oben"o)en a) ce"a) 8,10.

    P7; => ,7 S9, 97S

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    107/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    108/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    109/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    110/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    111/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    112/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    113/220

    Irradiancia 1000 W/m²Temperatura 50.0 ºCI)cLor.VocLor.G&Lor. 197.8 WI&Lor. 7.61 A

    V&Lor. 25.997 VLor. :%; #DIV/0!

    12.1%

    13.5%

    13* 25.44) V

    Punto ,r. Tensi-n V"1 -1.801 V2 -3.823 V3 -3.702 V4 -3.435 V5 -3.467 V6 -3.217 V7 -2.979 V8 -2.832 V9 -2.637 V10 -2.496 V

    cencaLor. :)/A&o";

    cencaLor. :)/Ace;

    10.000 V 0.000 V 10.000 V1.00 /

    0.00 /

    1.00 /

    2.00 /

    +.00 /

    .00 /

    5.00 /

    3.00 /

    ).00 /

    *.00 /

    4.00 / 

    Cura carac

    Ten

       I  n   t  e  n  s   i   d  a   d      /   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    114/220

    11 -2.301 V12 -2.209 V13 -1.965 V14 -1.873 V15 -1.580 V16 -1.537 V

    17 -1.255 V18 -1.060 V19 -0.876 V20 -0.778 V21 -0.540 V22 -0.497 V23 -0.350 V24 -0.106 V25 -0.008 V26 0.285 V

    27 0.382 V28 0.626 V29 0.724 V30 0.925 V31 1.120 V32 1.316 V33 1.462 V34 1.706 V35 1.853 V36 2.103 V37 2.249 V38 2.396 V39 2.640 V40 2.835 V41 3.085 V42 3.232 V43 3.476 V44 3.622 V45 3.866 V46 3.915 V47 4.159 V

    48 4.306 V49 4.550 V50 4.648 V51 4.940 V52 5.087 V53 5.233 V54 5.478 V55 5.630 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    115/220

    56 5.825 V57 6.020 V58 6.265 V59 6.362 V60 6.606 V61 6.753 V

    62 6.948 V63 7.046 V64 7.241 V65 7.388 V66 7.632 V67 7.827 V68 7.974 V69 8.218 V70 8.413 V71 8.608 V

    72 8.755 V73 8.950 V74 9.194 V75 9.390 V76 9.536 V77 9.731 V78 9.878 V79 10.073 V80 10.220 V81 10.464 V82 10.513 V83 10.708 V84 10.952 V85 11.099 V86 11.348 V87 11.544 V88 11.733 V89 11.885 V90 12.075 V91 12.227 V92 12.471 V

    93 12.569 V94 12.764 V95 12.905 V96 13.155 V97 13.247 V98 13.350 V99 13.546 V

    100 13.741 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    116/220

    101 13.985 V102 14.180 V103 14.425 V104 14.571 V105 14.815 V106 14.962 V

    107 15.157 V108 15.303 V109 15.499 V110 15.694 V111 15.938 V112 16.085 V113 16.231 V114 16.427 V115 16.573 V116 16.768 V

    117 16.964 V118 17.208 V119 17.354 V120 17.598 V121 17.745 V122 17.989 V123 18.087 V124 18.282 V125 18.428 V126 18.673 V127 18.819 V128 18.966 V129 19.161 V130 19.307 V131 19.552 V132 19.649 V133 19.844 V134 19.991 V135 20.235 V136 20.382 V137 20.626 V

    138 20.821 V139 21.016 V140 21.163 V141 21.358 V142 21.505 V143 21.700 V144 21.944 V145 22.091 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    117/220

    146 22.286 V147 22.481 V148 22.677 V149 22.774 V150 22.969 V151 23.116 V

    152 23.360 V153 23.507 V154 23.702 V155 23.897 V156 24.044 V157 24.190 V158 24.337 V159 24.532 V160 24.678 V161 24.923 V

    162 25.069 V163 25.264 V164 25.411 V165 25.606 V166 25.704 V167 25.899 V168 25.997 V169 26.241 V170 26.387 V171 26.632 V172 26.778 V173 26.973 V174 27.169 V175 27.315 V176 27.510 V177 27.711 V178 27.901 V179 28.048 V180 28.249 V181 28.389 V182 28.536 V

    183 28.682 V184 28.878 V185 29.024 V186 29.176 V187 29.366 V188 29.518 V189 29.708 V190 29.854 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    118/220

    191 30.050 V192 30.196 V193 30.397 V194 30.538 V195 30.690 V196 30.831 V

    197 30.983 V198 31.129 V199 31.325 V200 31.422 V201 31.563 V202 31.715 V203 31.911 V204 32.100 V205 32.198 V206 32.399 V

    207 32.594 V208 32.741 V209 32.887 V210 33.034 V211 33.180 V212 33.327 V213 33.473 V214 33.669 V215 33.815 V216 33.961 V217 34.108 V218 34.206 V219 34.450 V220 34.547 V221 34.645 V222 34.645 V223 34.645 V224 34.645 V225 34.645 V226 34.645 V227 34.639 V

    228 34.639 V229 34.639 V230 34.639 V231 34.639 V232 34.639 V233 34.639 V234 34.634 V235 34.634 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    119/220

    236 34.634 V237 34.628 V238 34.622 V239 34.617 V240 34.611 V241 34.611 V

    242 34.605 V243 34.550 V244 34.588 V245 34.582 V246 34.576 V247 34.564 V248 34.516 V249 34.504 V250 34.498 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    120/220

    8atos de# pro#ema de correcci-naa :A/M; :"e e$ercco 2; #DIV/0!bea :V/M; :"e e$ercco 2; #DIV/0!@) :&; 0.400N :&/M; 0.00275

    ).31 14).* W

    Intensidad " Potencia W"8.33 A -15.0 W8.35 A -31.9 W8.33 A -30.8 W8.30 A -28.5 W8.30 A -28.8 W8.31 A -26.7 W8.30 A -24.7 W8.32 A -23.6 W8.32 A -21.9 W8.32 A -20.8 W

    P;7C8I

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    121/220

    8.31 A -19.1 W8.32 A -18.4 W8.29 A -16.3 W8.28 A -15.5 W8.28 A -13.1 W8.27 A -12.7 W

    8.29 A -10.4 W8.28 A -8.8 W8.29 A -7.3 W8.28 A -6.4 W8.29 A -4.5 W8.29 A -4.1 W8.31 A -2.9 W8.31 A -0.9 W8.31 A -0.1 W8.31 A 2.4 W

    8.31 A 3.2 W8.31 A 5.2 W8.31 A 6.0 W8.30 A 7.7 W8.29 A 9.3 W8.29 A 10.9 W8.29 A 12.1 W8.29 A 14.1 W8.29 A 15.4 W8.28 A 17.4 W8.28 A 18.6 W8.28 A 19.8 W8.28 A 21.9 W8.28 A 23.5 W8.27 A 25.5 W8.27 A 26.7 W8.27 A 28.7 W8.27 A 30.0 W8.27 A 32.0 W8.27 A 32.4 W8.27 A 34.4 W

    8.27 A 35.6 W8.27 A 37.6 W8.27 A 38.4 W8.27 A 40.8 W8.27 A 42.1 W8.28 A 43.3 W8.27 A 45.3 W8.26 A 46.5 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    122/220

    8.26 A 48.1 W8.26 A 49.7 W8.26 A 51.8 W8.26 A 52.6 W8.26 A 54.6 W8.26 A 55.8 W

    8.26 A 57.4 W8.26 A 58.2 W8.26 A 59.8 W8.26 A 61.0 W8.26 A 63.0 W8.26 A 64.7 W8.26 A 65.9 W8.26 A 67.9 W8.26 A 69.5 W8.26 A 71.1 W

    8.26 A 72.3 W8.26 A 73.9 W8.26 A 76.0 W8.26 A 77.6 W8.26 A 78.8 W8.26 A 80.4 W8.26 A 81.6 W8.26 A 83.2 W8.26 A 84.4 W8.26 A 86.4 W8.26 A 86.8 W8.26 A 88.5 W8.26 A 90.5 W8.26 A 91.7 W8.25 A 93.7 W8.25 A 95.3 W8.26 A 96.9 W8.25 A 98.1 W8.26 A 99.8 W8.25 A 100.9 W8.25 A 102.9 W

    8.25 A 103.7 W8.25 A 105.3 W8.26 A 106.6 W8.25 A 108.6 W8.26 A 109.4 W8.24 A 110.0 W8.24 A 111.6 W8.24 A 113.2 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    123/220

    8.24 A 115.2 W8.24 A 116.8 W8.24 A 118.8 W8.24 A 120.0 W8.24 A 122.0 W8.24 A 123.3 W

    8.24 A 124.9 W8.24 A 126.1 W8.24 A 127.7 W8.24 A 129.3 W8.24 A 131.3 W8.24 A 132.5 W8.24 A 133.7 W8.24 A 135.3 W8.24 A 136.5 W8.24 A 138.1 W

    8.22 A 139.5 W8.22 A 141.5 W8.22 A 142.7 W8.22 A 144.7 W8.22 A 145.9 W8.22 A 147.9 W8.22 A 148.7 W8.22 A 150.4 W8.22 A 151.6 W8.21 A 153.3 W8.21 A 154.5 W8.21 A 155.7 W8.21 A 157.3 W8.21 A 158.5 W8.21 A 160.5 W8.21 A 161.3 W8.21 A 162.9 W8.21 A 164.1 W8.19 A 165.8 W8.19 A 167.0 W8.19 A 169.0 W

    8.18 A 170.3 W8.18 A 171.9 W8.18 A 173.1 W8.18 A 174.7 W8.18 A 175.9 W8.17 A 177.2 W8.15 A 178.8 W8.15 A 180.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    124/220

    8.14 A 181.3 W8.14 A 182.9 W8.12 A 184.2 W8.12 A 184.9 W8.11 A 186.2 W8.09 A 187.1 W

    8.08 A 188.7 W8.06 A 189.5 W8.03 A 190.4 W8.02 A 191.6 W8.00 A 192.4 W7.98 A 192.9 W7.95 A 193.4 W7.93 A 194.6 W7.90 A 195.0 W7.86 A 195.8 W

    7.83 A 196.2 W7.78 A 196.7 W7.77 A 197.4 W7.71 A 197.4 W7.68 A 197.5 W7.62 A 197.4 W7.61 A 197.8 W7.52 A 197.3 W7.46 A 196.9 W7.40 A 197.2 W7.35 A 196.7 W7.26 A 195.7 W7.17 A 194.8 W7.11 A 194.2 W7.01 A 192.8 W6.91 A 191.5 W6.80 A 189.8 W6.74 A 189.2 W6.60 A 186.6 W6.52 A 185.2 W6.39 A 182.4 W

    6.33 A 181.7 W6.19 A 178.7 W6.10 A 177.0 W5.97 A 174.3 W5.82 A 170.9 W5.71 A 168.6 W5.53 A 164.2 W5.40 A 161.1 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    125/220

    5.22 A 156.9 W5.12 A 154.5 W4.92 A 149.6 W4.80 A 146.5 W4.61 A 141.5 W4.50 A 138.8 W

    4.29 A 132.9 W4.14 A 129.0 W3.94 A 123.4 W3.82 A 120.1 W3.65 A 115.3 W3.46 A 109.6 W3.28 A 104.6 W3.04 A 97.5 W2.91 A 93.6 W2.65 A 85.8 W

    2.43 A 79.2 W2.21 A 72.4 W2.09 A 68.8 W1.81 A 59.9 W1.62 A 53.9 W1.39 A 46.3 W1.26 A 42.1 W0.95 A 32.0 W0.73 A 24.7 W0.54 A 18.3 W0.29 A 9.9 W0.13 A 4.4 W-0.16 A -5.6 W-0.38 A -13.2 W-0.50 A -17.3 W-0.52 A -17.8 W-0.52 A -17.8 W-0.53 A -18.4 W-0.53 A -18.4 W-0.53 A -18.4 W-0.52 A -18.1 W

    -0.52 A -18.1 W-0.52 A -18.1 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W-0.53 A -18.3 W-0.53 A -18.3 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    126/220

    -0.53 A -18.3 W-0.52 A -18.0 W-0.51 A -17.7 W-0.50 A -17.4 W-0.50 A -17.2 W-0.48 A -16.7 W

    -0.47 A -16.4 W-0.47 A -16.1 W-0.45 A -15.5 W-0.44 A -15.3 W-0.43 A -15.0 W-0.42 A -14.4 W-0.43 A -14.9 W-0.42 A -14.3 W-0.41 A -14.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    127/220

    Irradiancia 1000 W/m²Temperatura 25.0 ºCI)cLcorr.VocLcorr.G&Lcorr. #DIV/0!I&Lcorr. #DIV/0!

    V&Lcorr. #DIV/0!Lcorr. :%; #DIV/0!

    cencaLcorr. :)/A&o"; #DIV/0!

    cencaLcorr. :)/Ace; #DIV/0!

    33 K8IV/0L

    Punto ,r. Tensi-n V"1 #DIV/0!2 #DIV/0!3 #DIV/0!4 #DIV/0!5 #DIV/0!6 #DIV/0!7 #DIV/0!8 #DIV/0!9 #DIV/0!10 #DIV/0!

    10.000 V 40.000 V0.00 /

    2.00 /

    .00 /

    3.00 /

    *.00 /

    10.00 /

    12.00 /

    12+

    53)*4101112

    Cura caract

       I  n   t  e  n  s   i   d  a   d      /   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    128/220

    11 #DIV/0!12 #DIV/0!13 #DIV/0!14 #DIV/0!15 #DIV/0!16 #DIV/0!

    17 #DIV/0!18 #DIV/0!19 #DIV/0!20 #DIV/0!21 #DIV/0!22 #DIV/0!23 #DIV/0!24 #DIV/0!25 #DIV/0!26 #DIV/0!

    27 #DIV/0!28 #DIV/0!29 #DIV/0!30 #DIV/0!31 #DIV/0!32 #DIV/0!33 #DIV/0!34 #DIV/0!35 #DIV/0!36 #DIV/0!37 #DIV/0!38 #DIV/0!39 #DIV/0!40 #DIV/0!41 #DIV/0!42 #DIV/0!43 #DIV/0!44 #DIV/0!45 #DIV/0!46 #DIV/0!47 #DIV/0!

    48 #DIV/0!49 #DIV/0!50 #DIV/0!51 #DIV/0!52 #DIV/0!53 #DIV/0!54 #DIV/0!55 #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    129/220

    56 #DIV/0!57 #DIV/0!58 #DIV/0!59 #DIV/0!60 #DIV/0!61 #DIV/0!

    62 #DIV/0!63 #DIV/0!64 #DIV/0!65 #DIV/0!66 #DIV/0!67 #DIV/0!68 #DIV/0!69 #DIV/0!70 #DIV/0!71 #DIV/0!

    72 #DIV/0!73 #DIV/0!74 #DIV/0!75 #DIV/0!76 #DIV/0!77 #DIV/0!78 #DIV/0!79 #DIV/0!80 #DIV/0!81 #DIV/0!82 #DIV/0!83 #DIV/0!84 #DIV/0!85 #DIV/0!86 #DIV/0!87 #DIV/0!88 #DIV/0!89 #DIV/0!90 #DIV/0!91 #DIV/0!92 #DIV/0!

    93 #DIV/0!94 #DIV/0!95 #DIV/0!96 #DIV/0!97 #DIV/0!98 #DIV/0!99 #DIV/0!

    100 #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    130/220

    101 #DIV/0!102 #DIV/0!103 #DIV/0!104 #DIV/0!105 #DIV/0!106 #DIV/0!

    107 #DIV/0!108 #DIV/0!109 #DIV/0!110 #DIV/0!111 #DIV/0!112 #DIV/0!113 #DIV/0!114 #DIV/0!115 #DIV/0!116 #DIV/0!

    117 #DIV/0!118 #DIV/0!119 #DIV/0!120 #DIV/0!121 #DIV/0!122 #DIV/0!123 #DIV/0!124 #DIV/0!125 #DIV/0!126 #DIV/0!127 #DIV/0!128 #DIV/0!129 #DIV/0!130 #DIV/0!131 #DIV/0!132 #DIV/0!133 #DIV/0!134 #DIV/0!135 #DIV/0!136 #DIV/0!137 #DIV/0!

    138 #DIV/0!139 #DIV/0!140 #DIV/0!141 #DIV/0!142 #DIV/0!143 #DIV/0!144 #DIV/0!145 #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    131/220

    146 #DIV/0!147 #DIV/0!148 #DIV/0!149 #DIV/0!150 #DIV/0!151 #DIV/0!

    152 #DIV/0!153 #DIV/0!154 #DIV/0!155 #DIV/0!156 #DIV/0!157 #DIV/0!158 #DIV/0!159 #DIV/0!160 #DIV/0!161 #DIV/0!

    162 #DIV/0!163 #DIV/0!164 #DIV/0!165 #DIV/0!166 #DIV/0!167 #DIV/0!168 #DIV/0!169 #DIV/0!170 #DIV/0!171 #DIV/0!172 #DIV/0!173 #DIV/0!174 #DIV/0!175 #DIV/0!176 #DIV/0!177 #DIV/0!178 #DIV/0!179 #DIV/0!180 #DIV/0!181 #DIV/0!182 #DIV/0!

    183 #DIV/0!184 #DIV/0!185 #DIV/0!186 #DIV/0!187 #DIV/0!188 #DIV/0!189 #DIV/0!190 #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    132/220

    191 #DIV/0!192 #DIV/0!193 #DIV/0!194 #DIV/0!195 #DIV/0!196 #DIV/0!

    197 #DIV/0!198 #DIV/0!199 #DIV/0!200 #DIV/0!201 #DIV/0!202 #DIV/0!203 #DIV/0!204 #DIV/0!205 #DIV/0!206 #DIV/0!

    207 #DIV/0!208 #DIV/0!209 #DIV/0!210 #DIV/0!211 #DIV/0!212 #DIV/0!213 #DIV/0!214 #DIV/0!215 #DIV/0!216 #DIV/0!217 #DIV/0!218 #DIV/0!219 #DIV/0!220 #DIV/0!221 #DIV/0!222 #DIV/0!223 #DIV/0!224 #DIV/0!225 #DIV/0!226 #DIV/0!227 #DIV/0!

    228 #DIV/0!229 #DIV/0!230 #DIV/0!231 #DIV/0!232 #DIV/0!233 #DIV/0!234 #DIV/0!235 #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    133/220

    236 #DIV/0!237 #DIV/0!238 #DIV/0!239 #DIV/0!240 #DIV/0!241 #DIV/0!

    242 #DIV/0!243 #DIV/0!244 #DIV/0!245 #DIV/0!246 #DIV/0!247 #DIV/0!248 #DIV/0!249 #DIV/0!250 #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    134/220

    Procedimiento de correcci-n K1 de #a IC 30*41 d.2

    K8IV/0L K8IV/0L

    Intensidad " Potencia W"#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    140.000 V 240.000 V

    er6stica corre&ida

    Tensi-n V"

       P  o   t  e  n  c   i  a

          W   "

    ( )22 1 2 11

    1 sc

    G I I I T T 

    Gα 

    = + − + −

    ( ) ( ) ( )2 1 2 1 2 2 1 2 1 sV V R I I k I T T T T  β = − − − − + −

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    135/220

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    136/220

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    137/220

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    138/220

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    139/220

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    140/220

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

    #DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!#DIV/0! #DIV/0!

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    141/220

    Irradiancia 1000 W/m²Temperatura 50.0 ºCI)cLor. 8.30 AVocLor. 34.300 VG&Lor. 197.8 WI&Lor. 7.61 A

    V&Lor. 25.997 VLor. :%; 69.5%

    12.1%

    13.5%

    13* 25.44) V

    Punto ,r. Tensi-n V"1 -1.801 V2 -3.823 V3 -3.702 V4 -3.435 V5 -3.467 V6 -3.217 V7 -2.979 V8 -2.832 V9 -2.637 V10 -2.496 V

    cencaLor. :)/A&o";

    cencaLor. :)/Ace;

    10.000 V 0.000 V 10.000 V1.00 /

    0.00 /

    1.00 /

    2.00 /

    +.00 /

    .00 /

    5.00 /

    3.00 /

    ).00 /

    *.00 /

    4.00 / 

    Cura carac

    Ten

       I  n   t  e  n  s   i   d  a   d      /   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    142/220

    11 -2.301 V12 -2.209 V13 -1.965 V14 -1.873 V15 -1.580 V16 -1.537 V

    17 -1.255 V18 -1.060 V19 -0.876 V20 -0.778 V21 -0.540 V22 -0.497 V23 -0.350 V24 -0.106 V25 -0.008 V26 0.285 V

    27 0.382 V28 0.626 V29 0.724 V30 0.925 V31 1.120 V32 1.316 V33 1.462 V34 1.706 V35 1.853 V36 2.103 V37 2.249 V38 2.396 V39 2.640 V40 2.835 V41 3.085 V42 3.232 V43 3.476 V44 3.622 V45 3.866 V46 3.915 V47 4.159 V

    48 4.306 V49 4.550 V50 4.648 V51 4.940 V52 5.087 V53 5.233 V54 5.478 V55 5.630 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    143/220

    56 5.825 V57 6.020 V58 6.265 V59 6.362 V60 6.606 V61 6.753 V

    62 6.948 V63 7.046 V64 7.241 V65 7.388 V66 7.632 V67 7.827 V68 7.974 V69 8.218 V70 8.413 V71 8.608 V

    72 8.755 V73 8.950 V74 9.194 V75 9.390 V76 9.536 V77 9.731 V78 9.878 V79 10.073 V80 10.220 V81 10.464 V82 10.513 V83 10.708 V84 10.952 V85 11.099 V86 11.348 V87 11.544 V88 11.733 V89 11.885 V90 12.075 V91 12.227 V92 12.471 V

    93 12.569 V94 12.764 V95 12.905 V96 13.155 V97 13.247 V98 13.350 V99 13.546 V

    100 13.741 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    144/220

    101 13.985 V102 14.180 V103 14.425 V104 14.571 V105 14.815 V106 14.962 V

    107 15.157 V108 15.303 V109 15.499 V110 15.694 V111 15.938 V112 16.085 V113 16.231 V114 16.427 V115 16.573 V116 16.768 V

    117 16.964 V118 17.208 V119 17.354 V120 17.598 V121 17.745 V122 17.989 V123 18.087 V124 18.282 V125 18.428 V126 18.673 V127 18.819 V128 18.966 V129 19.161 V130 19.307 V131 19.552 V132 19.649 V133 19.844 V134 19.991 V135 20.235 V136 20.382 V137 20.626 V

    138 20.821 V139 21.016 V140 21.163 V141 21.358 V142 21.505 V143 21.700 V144 21.944 V145 22.091 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    145/220

    146 22.286 V147 22.481 V148 22.677 V149 22.774 V150 22.969 V151 23.116 V

    152 23.360 V153 23.507 V154 23.702 V155 23.897 V156 24.044 V157 24.190 V158 24.337 V159 24.532 V160 24.678 V161 24.923 V

    162 25.069 V163 25.264 V164 25.411 V165 25.606 V166 25.704 V167 25.899 V168 25.997 V169 26.241 V170 26.387 V171 26.632 V172 26.778 V173 26.973 V174 27.169 V175 27.315 V176 27.510 V177 27.711 V178 27.901 V179 28.048 V180 28.249 V181 28.389 V182 28.536 V

    183 28.682 V184 28.878 V185 29.024 V186 29.176 V187 29.366 V188 29.518 V189 29.708 V190 29.854 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    146/220

    191 30.050 V192 30.196 V193 30.397 V194 30.538 V195 30.690 V196 30.831 V

    197 30.983 V198 31.129 V199 31.325 V200 31.422 V201 31.563 V202 31.715 V203 31.911 V204 32.100 V205 32.198 V206 32.399 V

    207 32.594 V208 32.741 V209 32.887 V210 33.034 V211 33.180 V212 33.327 V213 33.473 V214 33.669 V215 33.815 V216 33.961 V217 34.108 V218 34.206 V219 34.450 V220 34.547 V221 34.645 V222 34.645 V223 34.645 V224 34.645 V225 34.645 V226 34.645 V227 34.639 V

    228 34.639 V229 34.639 V230 34.639 V231 34.639 V232 34.639 V233 34.639 V234 34.634 V235 34.634 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    147/220

    236 34.634 V237 34.628 V238 34.622 V239 34.617 V240 34.611 V241 34.611 V

    242 34.605 V243 34.550 V244 34.588 V245 34.582 V246 34.576 V247 34.564 V248 34.516 V249 34.504 V250 34.498 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    148/220

    8atos de# pro#ema de correcci-naa :A/M; :"e e$ercco 2; 0.00596bea :V/M; :"e e$ercco 2; -0.10311@) :&; 0.400N :&/M; 0.00275

    ).31 14).* W

    Intensidad " Potencia W"8.33 A -15.0 W8.35 A -31.9 W8.33 A -30.8 W8.30 A -28.5 W8.30 A -28.8 W8.31 A -26.7 W8.30 A -24.7 W8.32 A -23.6 W8.32 A -21.9 W8.32 A -20.8 W

    P;7C8I

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    149/220

    8.31 A -19.1 W8.32 A -18.4 W8.29 A -16.3 W8.28 A -15.5 W8.28 A -13.1 W8.27 A -12.7 W

    8.29 A -10.4 W8.28 A -8.8 W8.29 A -7.3 W8.28 A -6.4 W8.29 A -4.5 W8.29 A -4.1 W8.31 A -2.9 W8.31 A -0.9 W8.31 A -0.1 W8.31 A 2.4 W

    8.31 A 3.2 W8.31 A 5.2 W8.31 A 6.0 W8.30 A 7.7 W8.29 A 9.3 W8.29 A 10.9 W8.29 A 12.1 W8.29 A 14.1 W8.29 A 15.4 W8.28 A 17.4 W8.28 A 18.6 W8.28 A 19.8 W8.28 A 21.9 W8.28 A 23.5 W8.27 A 25.5 W8.27 A 26.7 W8.27 A 28.7 W8.27 A 30.0 W8.27 A 32.0 W8.27 A 32.4 W8.27 A 34.4 W

    8.27 A 35.6 W8.27 A 37.6 W8.27 A 38.4 W8.27 A 40.8 W8.27 A 42.1 W8.28 A 43.3 W8.27 A 45.3 W8.26 A 46.5 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    150/220

    8.26 A 48.1 W8.26 A 49.7 W8.26 A 51.8 W8.26 A 52.6 W8.26 A 54.6 W8.26 A 55.8 W

    8.26 A 57.4 W8.26 A 58.2 W8.26 A 59.8 W8.26 A 61.0 W8.26 A 63.0 W8.26 A 64.7 W8.26 A 65.9 W8.26 A 67.9 W8.26 A 69.5 W8.26 A 71.1 W

    8.26 A 72.3 W8.26 A 73.9 W8.26 A 76.0 W8.26 A 77.6 W8.26 A 78.8 W8.26 A 80.4 W8.26 A 81.6 W8.26 A 83.2 W8.26 A 84.4 W8.26 A 86.4 W8.26 A 86.8 W8.26 A 88.5 W8.26 A 90.5 W8.26 A 91.7 W8.25 A 93.7 W8.25 A 95.3 W8.26 A 96.9 W8.25 A 98.1 W8.26 A 99.8 W8.25 A 100.9 W8.25 A 102.9 W

    8.25 A 103.7 W8.25 A 105.3 W8.26 A 106.6 W8.25 A 108.6 W8.26 A 109.4 W8.24 A 110.0 W8.24 A 111.6 W8.24 A 113.2 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    151/220

    8.24 A 115.2 W8.24 A 116.8 W8.24 A 118.8 W8.24 A 120.0 W8.24 A 122.0 W8.24 A 123.3 W

    8.24 A 124.9 W8.24 A 126.1 W8.24 A 127.7 W8.24 A 129.3 W8.24 A 131.3 W8.24 A 132.5 W8.24 A 133.7 W8.24 A 135.3 W8.24 A 136.5 W8.24 A 138.1 W

    8.22 A 139.5 W8.22 A 141.5 W8.22 A 142.7 W8.22 A 144.7 W8.22 A 145.9 W8.22 A 147.9 W8.22 A 148.7 W8.22 A 150.4 W8.22 A 151.6 W8.21 A 153.3 W8.21 A 154.5 W8.21 A 155.7 W8.21 A 157.3 W8.21 A 158.5 W8.21 A 160.5 W8.21 A 161.3 W8.21 A 162.9 W8.21 A 164.1 W8.19 A 165.8 W8.19 A 167.0 W8.19 A 169.0 W

    8.18 A 170.3 W8.18 A 171.9 W8.18 A 173.1 W8.18 A 174.7 W8.18 A 175.9 W8.17 A 177.2 W8.15 A 178.8 W8.15 A 180.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    152/220

    8.14 A 181.3 W8.14 A 182.9 W8.12 A 184.2 W8.12 A 184.9 W8.11 A 186.2 W8.09 A 187.1 W

    8.08 A 188.7 W8.06 A 189.5 W8.03 A 190.4 W8.02 A 191.6 W8.00 A 192.4 W7.98 A 192.9 W7.95 A 193.4 W7.93 A 194.6 W7.90 A 195.0 W7.86 A 195.8 W

    7.83 A 196.2 W7.78 A 196.7 W7.77 A 197.4 W7.71 A 197.4 W7.68 A 197.5 W7.62 A 197.4 W7.61 A 197.8 W7.52 A 197.3 W7.46 A 196.9 W7.40 A 197.2 W7.35 A 196.7 W7.26 A 195.7 W7.17 A 194.8 W7.11 A 194.2 W7.01 A 192.8 W6.91 A 191.5 W6.80 A 189.8 W6.74 A 189.2 W6.60 A 186.6 W6.52 A 185.2 W6.39 A 182.4 W

    6.33 A 181.7 W6.19 A 178.7 W6.10 A 177.0 W5.97 A 174.3 W5.82 A 170.9 W5.71 A 168.6 W5.53 A 164.2 W5.40 A 161.1 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    153/220

    5.22 A 156.9 W5.12 A 154.5 W4.92 A 149.6 W4.80 A 146.5 W4.61 A 141.5 W4.50 A 138.8 W

    4.29 A 132.9 W4.14 A 129.0 W3.94 A 123.4 W3.82 A 120.1 W3.65 A 115.3 W3.46 A 109.6 W3.28 A 104.6 W3.04 A 97.5 W2.91 A 93.6 W2.65 A 85.8 W

    2.43 A 79.2 W2.21 A 72.4 W2.09 A 68.8 W1.81 A 59.9 W1.62 A 53.9 W1.39 A 46.3 W1.26 A 42.1 W0.95 A 32.0 W0.73 A 24.7 W0.54 A 18.3 W0.29 A 9.9 W0.13 A 4.4 W-0.16 A -5.6 W-0.38 A -13.2 W-0.50 A -17.3 W-0.52 A -17.8 W-0.52 A -17.8 W-0.53 A -18.4 W-0.53 A -18.4 W-0.53 A -18.4 W-0.52 A -18.1 W

    -0.52 A -18.1 W-0.52 A -18.1 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W-0.54 A -18.6 W-0.53 A -18.3 W-0.53 A -18.3 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    154/220

    -0.53 A -18.3 W-0.52 A -18.0 W-0.51 A -17.7 W-0.50 A -17.4 W-0.50 A -17.2 W-0.48 A -16.7 W

    -0.47 A -16.4 W-0.47 A -16.1 W-0.45 A -15.5 W-0.44 A -15.3 W-0.43 A -15.0 W-0.42 A -14.4 W-0.43 A -14.9 W-0.42 A -14.3 W-0.41 A -14.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    155/220

    Irradiancia 1000 W/m²Temperatura 25.0 ºCI)cLcorr. 8.14 AVocLcorr. 36.840 VG&Lcorr. 87.8 WI&Lcorr. 8.11 A

    V&Lcorr. 10.827 VLcorr. :%; 29.3%

    cencaLcorr. :)/A&o"; 5.4%

    cencaLcorr. :)/Ace; 6.0%

    33 10.*2) V

    Punto ,r. Tensi-n V"1 1.399 V2 -0.622 V3 -0.502 V4 -0.238 V5 -0.269 V6 -0.019 V7 0.219 V8 0.367 V9 0.562 V10 0.703 V

    10.000 V 0.000 V 10.000 V

    2.00 /

    0.00 /

    2.00 /

    .00 /

    3.00 /

    *.00 /

    10.00 /*.11 /

    1

    *).

    Cura caract

    Ten

       I  n   t  e  n  s   i   d  a   d      /   "

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    156/220

    11 0.897 V12 0.990 V13 1.232 V14 1.323 V15 1.616 V16 1.659 V

    17 1.942 V18 2.136 V19 2.321 V20 2.418 V21 2.657 V22 2.700 V23 2.848 V24 3.092 V25 3.190 V26 3.483 V

    27 3.580 V28 3.824 V29 3.922 V30 4.123 V31 4.317 V32 4.513 V33 4.659 V34 4.903 V35 5.050 V36 5.299 V37 5.445 V38 5.592 V39 5.836 V40 6.031 V41 6.281 V42 6.428 V43 6.672 V44 6.818 V45 7.062 V46 7.111 V47 7.355 V

    48 7.502 V49 7.746 V50 7.844 V51 8.136 V52 8.283 V53 8.430 V54 8.674 V55 8.825 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    157/220

    56 9.020 V57 9.215 V58 9.460 V59 9.557 V60 9.801 V61 9.948 V

    62 10.143 V63 10.241 V64 10.436 V65 10.583 V66 10.827 V67 11.022 V68 11.169 V69 11.413 V70 11.608 V71 11.803 V

    72 11.950 V73 12.145 V74 12.389 V75 12.585 V76 12.731 V77 12.926 V78 13.073 V79 13.268 V80 13.415 V81 13.659 V82 13.708 V83 13.903 V84 14.147 V85 14.294 V86 14.542 V87 14.738 V88 14.928 V89 15.079 V90 15.270 V91 15.421 V92 15.665 V

    93 15.763 V94 15.958 V95 16.100 V96 16.349 V97 16.442 V98 16.543 V99 16.739 V

    100 16.934 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    158/220

    101 17.178 V102 17.373 V103 17.618 V104 17.764 V105 18.008 V106 18.155 V

    107 18.350 V108 18.496 V109 18.692 V110 18.887 V111 19.131 V112 19.278 V113 19.424 V114 19.620 V115 19.766 V116 19.961 V

    117 20.156 V118 20.400 V119 20.546 V120 20.790 V121 20.937 V122 21.181 V123 21.279 V124 21.474 V125 21.620 V126 21.864 V127 22.010 V128 22.157 V129 22.352 V130 22.498 V131 22.743 V132 22.840 V133 23.035 V134 23.182 V135 23.425 V136 23.572 V137 23.816 V

    138 24.010 V139 24.205 V140 24.352 V141 24.547 V142 24.694 V143 24.888 V144 25.131 V145 25.278 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    159/220

    146 25.472 V147 25.667 V148 25.862 V149 25.959 V150 26.153 V151 26.299 V

    152 26.542 V153 26.688 V154 26.881 V155 27.075 V156 27.221 V157 27.365 V158 27.510 V159 27.704 V160 27.848 V161 28.090 V

    162 28.234 V163 28.426 V164 28.572 V165 28.763 V166 28.859 V167 29.050 V168 29.147 V169 29.385 V170 29.527 V171 29.768 V172 29.910 V173 30.099 V174 30.289 V175 30.431 V176 30.619 V177 30.813 V178 30.996 V179 31.139 V180 31.330 V181 31.465 V182 31.603 V

    183 31.745 V184 31.930 V185 32.070 V186 32.214 V187 32.393 V188 32.538 V189 32.715 V190 32.852 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    160/220

    191 33.036 V192 33.175 V193 33.362 V194 33.495 V195 33.634 V196 33.768 V

    197 33.905 V198 34.041 V199 34.223 V200 34.312 V201 34.441 V202 34.580 V203 34.764 V204 34.936 V205 35.025 V206 35.208 V

    207 35.388 V208 35.520 V209 35.658 V210 35.786 V211 35.919 V212 36.050 V213 36.187 V214 36.361 V215 36.492 V216 36.625 V217 36.755 V218 36.842 V219 37.066 V220 37.148 V221 37.238 V222 37.237 V223 37.237 V224 37.236 V225 37.236 V226 37.236 V227 37.230 V

    228 37.230 V229 37.230 V230 37.229 V231 37.229 V232 37.229 V233 37.229 V234 37.225 V235 37.225 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    161/220

    236 37.225 V237 37.219 V238 37.214 V239 37.209 V240 37.204 V241 37.205 V

    242 37.200 V243 37.145 V244 37.184 V245 37.179 V246 37.173 V247 37.162 V248 37.113 V249 37.103 V250 37.097 V

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    162/220

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    163/220

    8.16 A 7.3 W8.17 A 8.1 W8.14 A 10.0 W8.13 A 10.8 W8.13 A 13.1 W8.13 A 13.5 W

    8.14 A 15.8 W8.13 A 17.4 W8.14 A 18.9 W8.13 A 19.7 W8.14 A 21.6 W8.14 A 22.0 W8.16 A 23.2 W8.16 A 25.2 W8.16 A 26.0 W8.16 A 28.4 W

    8.16 A 29.2 W8.16 A 31.2 W8.16 A 32.0 W8.15 A 33.6 W8.14 A 35.1 W8.14 A 36.7 W8.14 A 37.9 W8.14 A 39.9 W8.14 A 41.1 W8.13 A 43.1 W8.13 A 44.3 W8.13 A 45.5 W8.13 A 47.4 W8.13 A 49.0 W8.12 A 51.0 W8.12 A 52.2 W8.12 A 54.2 W8.12 A 55.4 W8.12 A 57.3 W8.12 A 57.7 W8.12 A 59.7 W

    8.12 A 60.9 W8.12 A 62.9 W8.12 A 63.7 W8.12 A 66.1 W8.12 A 67.3 W8.13 A 68.6 W8.12 A 70.4 W8.11 A 71.6 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    164/220

    8.11 A 73.2 W8.11 A 74.8 W8.11 A 76.7 W8.11 A 77.5 W8.11 A 79.5 W8.11 A 80.7 W

    8.11 A 82.3 W8.11 A 83.1 W8.11 A 84.7 W8.11 A 85.9 W8.11 A 87.8 W8.11 A 89.4 W8.11 A 90.6 W8.11 A 92.6 W8.11 A 94.2 W8.11 A 95.7 W

    8.11 A 96.9 W8.11 A 98.5 W8.11 A 100.5 W8.11 A 102.1 W8.11 A 103.3 W8.11 A 104.9 W8.11 A 106.0 W8.11 A 107.6 W8.11 A 108.8 W8.11 A 110.8 W8.11 A 111.2 W8.11 A 112.8 W8.11 A 114.8 W8.11 A 116.0 W8.10 A 117.9 W8.10 A 119.4 W8.11 A 121.1 W8.10 A 122.2 W8.11 A 123.9 W8.10 A 125.0 W8.10 A 127.0 W

    8.10 A 127.7 W8.10 A 129.3 W8.11 A 130.6 W8.10 A 132.5 W8.11 A 133.4 W8.09 A 133.8 W8.09 A 135.4 W8.09 A 137.0 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    165/220

    8.09 A 139.0 W8.09 A 140.5 W8.09 A 142.5 W8.09 A 143.7 W8.09 A 145.7 W8.09 A 146.9 W

    8.09 A 148.4 W8.09 A 149.6 W8.09 A 151.2 W8.09 A 152.8 W8.09 A 154.8 W8.09 A 155.9 W8.09 A 157.1 W8.09 A 158.7 W8.09 A 159.9 W8.09 A 161.5 W

    8.08 A 162.8 W8.08 A 164.7 W8.08 A 165.9 W8.08 A 167.9 W8.08 A 169.1 W8.08 A 171.0 W8.08 A 171.8 W8.08 A 173.4 W8.08 A 174.6 W8.06 A 176.2 W8.06 A 177.4 W8.06 A 178.6 W8.06 A 180.2 W8.06 A 181.3 W8.06 A 183.3 W8.06 A 184.1 W8.06 A 185.7 W8.06 A 186.9 W8.05 A 188.5 W8.05 A 189.6 W8.05 A 191.6 W

    8.03 A 192.8 W8.03 A 194.4 W8.03 A 195.6 W8.03 A 197.1 W8.03 A 198.3 W8.02 A 199.5 W8.00 A 201.1 W8.00 A 202.3 W

  • 8/16/2019 Excel Apoyo Partes 1-5 Del Enunciado y Solución

    166/220

    7.99 A 203.5 W7.99 A 205.0 W7.97 A 206.2 W7.97 A 207.0 W7.96 A 208.1 W7.94 A 208.9 W

    7.93 A 210.4 W7.91 A 211.2 W7.88 A 211.9 W7.87 A 213.1 W7.86 A 213.8 W7.83 A 214.2 W7.80 A 214.5 W7.78 A 215.6 W7.75 A 215.9 W7.71 A 216.5 W

    7.68 A 216.8 W7.64 A 217.0 W7.62 A 217.7 W7.56 A 217.5 W7.53 A 217.4 W7.47 A 217.1 W7.46 A 217.4 W7.37 A 216.6 W7.31 A 215.9 W7.25 A 215.9 W7.20 A 215.2 W7.11 A 213.9 W7.02 A 212.6 W6.96 A 211.8 W6.86 A 210.0 W6.76 A 208.4 W6.65 A 206.2 W6.60 A 205.4 W6.46 A 202.2 W6.38 A 200.6 W6.24 A 19