CALCULOS.xlsx

Embed Size (px)

Citation preview

DEMANDACARGAPOTENCIA [W]USO [Hora/Dia]ENERGIA [W-h]AEROGENERADOR DE 400WMOTOR TRIFASICO DE 4HP2982.8411931.2NROV [m/s]P [kW]OTROS120033600100ENERGA CONSUMIDA DIARIA [Ec]15531.2230.006340.013450.026560.044670.07780.105890.1499100.20510110.27311120.35412130.4513140.56214150.69115160.83916171.00617181.19418191.40519201.63820242.831

COSTOSESTIMACIN DE COSTOS EN CASO DE SOLO PANELES FOTOVOLTAICOSMATERIALESCANTIDADPU [S/]TOTAL [S/]Bateria Monoblock Akuval 250Ah 12v221,181.0525,983.10Placa solar fotovoltaica S 165-SPU 165W 24V191,106.0021,014.00Inversor Senoidal Trifasico 380V + Monofsico 220V ISC 3300 24V110,270.0010,270.00CONTROLADOR DE CARGA 24V/200A11,145.501,145.50TOTAL 58,412.60

ESTIMACIN DE COSTOS EN CASO DE UN SISTEMA HIBRIDOMATERIALESCANTIDADPU [S/]TOTAL [S/]Bateria Monoblock Akuval 250Ah 12v221,181.0525,983.10Placa solar fotovoltaica S 165-SPU 165W 24V191,106.0021,014.00Aerogenerador 400W 24V23,851.257,702.50Rectificador17,110.007,110.00Inversor Senoidal Trifasico 380V + Monofsico 220V ISC 3300 24V110,270.0010,270.00CONTROLADOR DE CARGA 24V/200A11,145.501,145.50TOTAL 73,225.10

ANOVAANRO.N (RPM)R (seg)C (Kg)EFICIENCIA (n)X1X2X3Y1220451279.222404512753220551270.5424055128552204524426240452481.237220552479.28240552491.6Resumen

Estadsticas de la regresinCoeficiente de correlacin mltiple0.7206285978Coeficiente de determinacin R^20.5193055759R^2 ajustado0.1587847579Error tpico13.6795463192Observaciones8

ANLISIS DE VARIANZAGrados de libertadSuma de cuadradosPromedio de los cuadradosFValor crtico de FRegresin3808.6438375269.54794583331.44043159210.3559406999Residuos4748.51995187.1299875Total71557.1637875

CoeficientesError tpicoEstadstico tProbabilidadInferior 95%Superior 95%Inferior 95.0%Superior 95.0%Intercepcin-157.79375122.2579557802-1.29066242760.2663688933-497.2362528975181.6487528975-497.2362528975181.6487528975X10.7741250.48364499831.60060582190.1847172782-0.56868878822.1169387882-0.56868878822.1169387882X21.221750.96728999661.26306485570.2751743172-1.46387757633.9073775763-1.46387757633.9073775763X3-0.32645833330.8060749972-0.40499746860.7062033198-2.56448131361.9115646469-2.56448131361.9115646469

TABLANRO.N (RPM)R (seg)C (Kg)EFICIENCIA (n)X1X2X3Y1220451279.222404512753220551270.5424055128552204524426240452481.237220552479.28240552491.6TABLA PARA EL ANALISIS DE DATOS DEL DISEOX0X1X2X3X1X2X1X3X2X3X1X2X3(y-Yp)^2NRO.X0X1X2X3X1X2X1X3X2X3X1X2X3YXij*Yi11-1-1-1111-179.279.2-79.2-79.2-79.279.279.279.2-79.213.9129211-1-1-1-111757575-75-75-75-7575750.220931-11-1-11-1170.570.5-70.570.5-70.5-70.570.5-70.570.524.70094111-11-1-1-185858585-8585-85-85-8590.820951-1-111-1-114242-42-424242-42-42421120.2409611-11-11-1-181.2381.2381.23-81.2381.23-81.2381.23-81.23-81.2333.177671-111-1-11-179.279.2-79.279.279.2-79.2-79.279.2-79.213.912981111111191.691.691.691.691.691.691.691.691.6260.1769X288888888603.7361.9348.87-15.67-8.1341.3346.27-45.531557.1639XY603.7361.9348.87-15.67-8.1341.3346.27-45.53SDCbij75.477.746.11-1.96-1.025.175.78-5.69Se27.9030813711Sbj9.8659.8659.8659.8659.8659.8659.8659.865Sb9.865tj7.650.7850.619-0.199-0.1030.5240.586-0.577SIGNIFI.SINONONONONONONO