17
METODO LINEAL EJERCICIO 1 TUBO 1 10 L/S 3.5 L/S TUBO 2 TUBO 5 TUBO 4 3 L/S 3.5 L/S TUBO 3 TUBO D[m] L[m] IQI f K' K 1 0.0552 100 0.001 0.02677433 432544.4014 432.544401 2 0.0552 100 0.001 0.02677433 432544.4014 432.544401 3 0.0552 100 0.001 0.02677433 432544.4014 432.544401 4 0.0552 141.42 0.001 0.02677433 611704.2925 611.704292 5 0.0552 100 0.001 0.02677433 432544.4014 432.544401 LINEALIZACION DEL SISTEMA 1 0 0 0 1 0.01 1 -1 0 1 0 0.0035 0 0 -1 -1 1 0.003 432.544401 0 0 -611.70429 -432.5444 0 0 432.544401 -432.5444 611.704292 0 0 Q1= 0.00507322 [m3/s] Q2= 0.00167678 [m3/s] Q3= 0.00182322 [m3/s] Q4= 0.00010355 [m3/s] Q5= 0.00492678 [m3/s] TUBO ENCONTRADO ANTERIOR PROMEDIO ESTIMACIÓN 1 0.00507322 0.001 0.00303661 0.00407322 2 0.00167678 0.001 0.00133839 0.00067678 3 0.00182322 0.001 0.00141161 0.00082322 4 0.00010355 0.001 0.00055178 -0.0008964 5 0.00492678 0.001 0.00296339 0.00392678 1RA ITERACIÓN 1 2 4 3 1 2 1

Metodo Lineal Farith-ejercicio1

Embed Size (px)

DESCRIPTION

archivo excel del diseño de una red de distribucion de agua metodo lineal

Citation preview

Hoja1METODO LINEALEJERCICIO 1ECUACIONES DE NUDOSDATOSTUBO 1NUDO 1Q1+Q5= 0.010.002[mm]10 L/S3.5 L/SNUDO 2Q1-Q2+Q4=0.00351.308*10^-6[m2/s]NUDO 3Q5-Q4-Q3=0.003g=9.79[m/s2]NUDO 4Q2+Q3=0.0035NO SE UTILIZARA PARA NUESTRO CASO LA ECUACIN DE NUDO 4TUBO 2TUBO 5ECUACIONES DE CIRCUITOSTUBO 4CIRCUITO 1:h1-h4-h5=0CIRCUITO 2:h2-h3+h4=03 L/S3.5 L/STUBO 3n= nmero de circuitosTUBOD[m]L[m]IQIfK'K10.05521000.0010.0267743252432544.401426234432.544401426220.05521000.0010.0267743252432544.401426234432.544401426230.05521000.0010.0267743252432544.401426234432.544401426240.0552141.420.0010.0267743252611704.29249698611.70429249750.05521000.0010.0267743252432544.401426234432.5444014262LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.50.1464460277-0.14644602770.00081738190.00033856881-10100.00350.5-0.6464460277-0.35355397230.00033856880.000817381900-1-110.0030.5-0.3535539723-0.6464460277-0.0003385688-0.0008173819432.544401426200-611.704292497-432.5444014262000.2071079447-0.2071079447-0.00047881310.00047881310432.5444014262-432.5444014262611.704292497000.5-0.14644602770.1464460277-0.0008173819-0.0003385688Q1=0.005073223[m3/s]Q2=0.001676777[m3/s]Q3=0.001823223[m3/s]Q4=0.000103554[m3/s]Q5=0.004926777[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.0050732230.0010.00303661150.00407322320.0016767770.0010.00133838850.00067677730.0018232230.0010.00141161150.00082322340.0001035540.0010.000551777-0.00089644650.0049267770.0010.00296338850.0039267771RA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00303661150.020710665334584.7982590521016.004048433120.05521000.00133838850.0249485015403047.866461224539.434626633230.05521000.00141161150.0246348555397980.854676004561.794353993540.0552141.420.0005517770.0311628586711967.686569237392.847384342250.05521000.00296338850.0208205394336359.840439389996.7648806932LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49709858690.0616061063-0.0641596980.0004343440.0001142051-10100.00350.5067199049-0.6227525998-0.39288441830.0001142050.000699338500-1-110.0030.4932800951-0.3772474002-0.6071155817-0.000114205-0.00069933851016.004048433100-392.8473843422-996.764880693200.00962131810.3156412939-0.3287247203-0.00032013910.00058513350539.4346266332-561.7943539935392.8473843422000.5029014131-0.06160610630.064159698-0.000434344-0.000114205Q1=0.0049941281[m3/s]Q2=0.0017089117[m3/s]Q3=0.0017910883[m3/s]Q4=0.0002147835[m3/s]Q5=0.0050058719[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.00499412810.00303661150.00401536980.001957516620.00170891170.00133838850.00152365010.000370523230.00179108830.00141161150.00160134990.000379476840.00021478350.0005517770.0003832803-0.000336993450.00500587190.00296338850.00398463020.00204248342DA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00401536980.0195149976315268.5601849041265.919863929720.05521000.00152365010.0241952869390879.538935924595.563646260730.05521000.00160134990.0239152995386356.288342857618.691606002340.0552141.420.00038328030.0343878514785648.047298995301.123393469550.05521000.00398463020.0195464175315776.154745621258.2511941519LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49944441840.0427941583-0.04445601530.00036160380.00007185491-10100.00350.5075206822-0.5984832107-0.41710918520.00007185490.000674179500-1-110.0030.4924793178-0.4015167893-0.5828908148-0.0000718549-0.00067417951265.919863929700-301.1233934695-1258.251194151900.00807626380.358722631-0.3726531699-0.00028974890.00060232460595.5636462607-618.6916060023301.1233934695000.5005555816-0.04279415830.0444560153-0.0003616038-0.0000718549Q1=0.0050108557[m3/s]Q2=0.001729188[m3/s]Q3=0.001770812[m3/s]Q4=0.0002183323[m3/s]Q5=0.0049891443[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.00501085570.00401536980.00451311280.000995485920.0017291880.00152365010.00162641910.000205537930.0017708120.00160134990.00168608090.000169462140.00021833230.00038328030.0003008063-0.000164947950.00498914430.00398463020.00448688720.00100451413RA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00451311280.0190469853307707.7309706681388.719686924920.05521000.00162641910.0238288506384959.689645218626.105777236530.05521000.00168608090.0236301489381749.62525529643.660766334840.0552141.420.00030080630.0368059656840893.915302716252.946188998950.05521000.00448688720.0190698987308077.9013788331382.3108046922LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.4994143570.034878379-0.03585631210.00033535010.00005570681-10100.00350.5056670954-0.5830282911-0.42866291840.00005570680.000665976500-1-110.0030.4943329046-0.4169717089-0.5713370816-0.0000557068-0.00066597651388.719686924900-252.9461889989-1382.310804692200.00625273850.3820933299-0.3928066063-0.00027964320.00061026960626.1057772365-643.6607663348252.9461889989000.500585643-0.0348783790.0358563121-0.0003353501-0.0000557068Q1=0.005008649[m3/s]Q2=0.0017300832[m3/s]Q3=0.0017699168[m3/s]Q4=0.0002214342[m3/s]Q5=0.004991351[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.0050086490.00451311280.00476088090.000495536220.00173008320.00162641910.00167825110.000103664130.00176991680.00168608090.00172799890.000083835940.00022143420.00030080630.0002611203-0.000079372150.0049913510.00448688720.00473911910.00050446384TA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00476088090.0188389108304346.2471841571448.956222952120.05521000.00167825110.0236556818382162.114192535641.363996555230.05521000.00172799890.0234961261379584.461002954655.921523091240.0552141.420.00026112030.0383326233875772.966830169228.682065922950.05521000.00473911910.0188566033304632.0729431661443.6876876227LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49950001890.0311348605-0.03184155210.00032393330.00004854481-10100.00350.5046950057-0.575034236-0.43461153520.00004854480.000662596900-1-110.0030.4953049943-0.424965764-0.5653884648-0.0000485448-0.00066259691448.956222952100-228.6820659229-1443.687687622700.00519498680.3938309035-0.4027699831-0.00027538850.00061405210641.3639965552-655.9215230912228.6820659229000.5004999811-0.03113486050.0318415521-0.0003239333-0.0000485448Q1=0.0050084475[m3/s]Q2=0.0017304956[m3/s]Q3=0.0017695044[m3/s]Q4=0.0002220481[m3/s]Q5=0.0049915525[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.00500844750.00476088090.00488466420.000247566720.00173049560.00167825110.00170437340.000052244530.00176950440.00172799890.00174875160.000041505540.00022204810.00026112030.0002415842-0.000039072250.00499155250.00473911910.00486533580.00025243335TA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00488466420.0187402833302752.900848331478.846256818120.05521000.00170437340.0235711184380795.976112029649.018522340430.05521000.00174875160.023431384378538.53985714661.969887348540.0552141.420.00024158420.0392106967895834.023977088216.419320315650.05521000.00486533580.0187554629302998.1302218751474.1876497029LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49955022130.0292978711-0.02988251910.00031859420.00004514181-10100.00350.504175926-0.5709337233-0.43762842670.00004514180.000661100200-1-110.0030.495824074-0.4290662767-0.5623715733-0.0000451418-0.00066110021478.846256818100-216.4193203156-1474.187649702900.00462570470.3997684056-0.4077459076-0.00027345240.00061595840649.0185223404-661.9698873485216.4193203156000.5004497787-0.02929787110.0298825191-0.0003185942-0.0000451418Q1=0.0050083972[m3/s]Q2=0.0017306059[m3/s]Q3=0.0017693941[m3/s]Q4=0.0002222087[m3/s]Q5=0.0049916028[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.00500839720.00488466420.00494653070.00012373320.00173060590.00170437340.00171748970.000026232630.00176939410.00174875160.00175907280.000020642440.00022220870.00024158420.0002318965-0.000019375450.00499160280.00486533580.00492846930.0001262676TA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00494653070.0186922275301976.5501059381493.736276765620.05521000.00171748970.0235293115380120.577557596652.853161868730.05521000.00175907280.0233995703378024.583381268664.972777119940.0552141.420.00023189650.0396844778906658.346547651210.250858891550.05521000.00492846930.0187061743302201.8633570751489.3926049709LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49957716010.0283863623-0.02891332890.00031601060.00004348051-10100.00350.5039074641-0.5688558194-0.43914797360.00004348050.000660399900-1-110.0030.4960925359-0.4311441806-0.5608520264-0.0000434805-0.00066039991493.736276765600-210.2508588915-1489.392604970900.00433030390.4027578183-0.4102346448-0.00027253010.00061691950652.8531618687-664.9727771199210.2508588915000.5004228399-0.02838636230.0289133289-0.0003160106-0.0000434805Q1=0.0050083839[m3/s]Q2=0.0017306354[m3/s]Q3=0.0017693646[m3/s]Q4=0.0002222515[m3/s]Q5=0.0049916161[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.00500838390.00494653070.00497745730.000061853220.00173063540.00171748970.00172406250.000013145730.00176936460.00175907280.00176421870.000010291840.00022225150.00023189650.000227074-0.00000964550.00499161610.00492846930.00496004270.00006314687MA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00497745730.0186685043301593.2972221681501.167756806220.05521000.00172406250.0235085233379784.740166418654.772631034330.05521000.00176421870.0233838019377769.841829856666.468635712540.0552141.420.0002270740.0399309178912288.681008628207.15700650350.05521000.00496004270.0186818383301808.7105707971496.984093748LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49959109010.0279321782-0.02843112220.00031473950.00004265941-10100.00350.5037708063-0.5678096547-0.43991043020.00004265940.000660061700-1-110.0030.4962291937-0.4321903453-0.5600895698-0.0000426594-0.00066006171501.167756806200-207.157006503-1496.98409374800.00417971620.4042581671-0.411479308-0.00027208010.00061740240654.7726310343-666.4686357125207.157006503000.5004089099-0.02793217820.0284311222-0.0003147395-0.0000426594Q1=0.0050083802[m3/s]Q2=0.001730643[m3/s]Q3=0.001769357[m3/s]Q4=0.0002222628[m3/s]Q5=0.0049916198[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.00500838020.00497745730.00499291870.000030922920.0017306430.00172406250.00172735270.000006580530.0017693570.00176421870.00176678790.000005138340.00022226280.0002270740.0002246684-0.000004811150.00499161980.00496004270.00497583130.00003157718VA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00499291870.0186567169301402.8694956321504.880031013620.05521000.00172735270.0234981582379617.289971437655.732967317430.05521000.00176678790.0233759531377643.042947996667.215151808240.0552141.420.00022466840.0400566852915162.047857708205.607986671350.05521000.00497583130.0186697467301613.3684344321500.7772314739LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49959820490.0277054965-0.02819063240.0003141090.00004225121-10100.00350.5037018464-0.5672848146-0.44029222640.00004225120.000659895400-1-110.0030.4962981536-0.4327151854-0.5597077736-0.0000422512-0.00065989541504.880031013600-205.6079866713-1500.777231473900.00410364150.4050096889-0.412101594-0.00027185780.00061764420655.7329673174-667.2151518082205.6079866713000.5004017951-0.02770549650.0281906324-0.000314109-0.0000422512Q1=0.0050083794[m3/s]Q2=0.0017306449[m3/s]Q3=0.0017693551[m3/s]Q4=0.0002222655[m3/s]Q5=0.0049916206[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.00500837940.00499291870.00500064910.000015460720.00173064490.00172735270.00172899880.000003292230.00176935510.00176678790.00176807150.000002567240.00022226550.00022466840.000223467-0.000002402850.00499162060.00497583130.00498372590.00001578939NA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.00500064910.0186508422301307.9625810381506.735379116220.05521000.00172899880.0234929825379533.675537021656.213284265230.05521000.00176807150.023372039377579.809905558667.588090962840.0552141.420.0002234670.040120184916612.784271727204.832680351950.05521000.00498372590.0186637193301515.9946218081502.6730844573LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49960177810.0275922252-0.0280705090.0003137950.00004204761-10100.00350.5036672181-0.5670218969-0.44048334920.00004204760.000659813100-1-110.0030.4963327819-0.4329781031-0.5595166508-0.0000420476-0.00065981311506.735379116200-204.8326803519-1502.673084457300.004065440.4053858779-0.4124128402-0.00027174730.00061776540656.2132842652-667.5880909628204.8326803519000.5003982219-0.02759222520.028070509-0.000313795-0.0000420476Q1=0.005008379[m3/s]Q2=0.0017306455[m3/s]Q3=0.0017693545[m3/s]Q4=0.0002222665[m3/s]Q5=0.004991621[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACIN10.0050083790.00500064910.0050045140.0000077320.00173064550.00172899880.00172982220.000001646730.00176935450.00176807150.0017687130.00000128340.00022226650.0002234670.0002228667-0.000001200550.0049916210.00498372590.00498767350.00000789510MA ITERACINTUBOD[m]L[m]IQIfK'K10.05521000.0050045140.0186479094301260.5826298711507.662818413520.05521000.00172982220.0234903971379491.907900037656.453514275530.05521000.0017687130.0233700819377548.192576579667.774392484140.0552141.420.00022286670.0401520893917341.714275288204.444930203350.05521000.00498767350.0186607107301467.3901069831503.6208977463LINEALIZACION DEL SISTEMAMATRIZ INVERSA100010.010.49960358240.02753562-0.0280104860.00031363830.0000419461-10100.00350.5036498284-0.5668903011-0.44057889830.0000419460.000659772100-1-110.0030.4963501716-0.4331096989-0.5594211017-0.000041946-0.00065977211507.662818413500-204.4449302033-1503.620897746300.0040462460.4055740789-0.4125684123-0.00027169230.0006178260656.4535142755-667.7743924841204.4449302033000.5003964176-0.027535620.028010486-0.0003136383-0.000041946Q1=0.005008379[m3/s]Q2=0.0017306455[m3/s]Q3=0.0017693545[m3/s]Q4=0.0002222665[m3/s]Q5=0.004991621[m3/s]TUBOENCONTRADOANTERIORPROMEDIOESTIMACINSOLUCIN10.0050083790.0050045140.00500644650.000003865Q1=0.0050064465[m3/s]20.00173064550.00172982220.00173023390.0000008234Q2=0.0017302339[m3/s]30.00176935450.0017687130.00176903370.0000006415Q3=0.0017690337[m3/s]40.00022226650.00022286670.0002225666-0.0000006002Q4=0.0002225666[m3/s]50.0049916210.00498767350.00498964720.0000039475Q5=0.0049896472[m3/s]

1243121