Grfico1

Grfico2

Hoja1calcular el volumen de regulacin si se cuenta con el siguiente registro de dotacin de agua Poblacion7,500HABDotacion180L/HAB/DIA

HORAVOL ACUMVOL ACUM HORARIOPROMVOL ACUM PROMVOLUMEN ALMACENAMQP =Poblacion * DotacionVOL REGULACION337.5M3 /DIA1,0000:00000.001:0058.8158.8198.68098.68039.87QP =1350M3 /DIA2:00117.4358.6298.680197.36179.93PARA VOLUMEN CONTRA INCENDIO3:00179.7262.2998.680296.041116.32VOL TOTAL =V reg + V inc + V resgR (M3)4:00244.8465.1298.680394.722149.88VOL RESERVA =0.33 * (V reg + V inc )0.11425:00321.847798.680493.402171.56VOL REGULACION263M30.51706:00407.0985.2598.680592.083184.99VOL CONTRA INC192M30.92007:00521.69114.698.680690.763169.07VOL RESERVA150.00M38:00647.02125.3398.680789.443142.429:00773.16126.1498.680888.124114.96VOL ALMACENAMIENTO604.5M310:00898.42125.2698.680986.80488.3811:001023.65125.2398.6801085.48561.8312:001152.12128.4798.6801184.16532.0513:001277.63125.5198.6801282.8455.2214:001402.88125.2598.6801381.526-21.3515:001518.24115.3698.6801480.206-38.0316:001625.28107.0498.6801578.887-46.3917:001726.05100.7798.6801677.567-48.4818:001821.3895.3398.6801776.248-45.13 19:001928.66107.2898.6801874.928-53.7320:002041.1112.4498.6801973.608-67.4921:002149.83108.7398.6802072.289-77.5422:002222.8673.0398.6802170.969-51.8923:002294.571.6498.6802269.650-24.850:002368.3373.8398.6802368.3300.00PROMEDIO98.680SUM2368.330SUM881.59

M3/HL/S12:00MAX128.4735.6862:00MIN58.6216.283Consumo promedio durante el daCPDCPD98.680M3/HCPD27.411L/S

%CONSUMO MXIMO1.30%%CONSUMO MNIMO0.59%