小区室内给水管径计算资料.xls

Sheet1住住宅宅 每每户户1套套卫卫生生间间 N4.51。10 q=0.2*N+k*N k=0.005户户 数数当当 量量流流 量量(l/s)管管 径径(mm)流流速速(m/s)14.50.49DN250.93249180.711.02DN320.741.085822.5361.161.50DN400.921.1991740.576.51.602.31DN500.751.09184181184.52.393.91DN700.681.1142701893153.975,48DN800.801.1171178319.5801 5.5310.23DN1000.631.17179805.510.271393DN150DN15018081010.31131DN150DN150181814.510.351178DN150DN15018281910.390999DN150DN150183823.510.430772DN150DN15018482810.470498DN150DN150185832.510.510177DN150DN15018683710.54981DN150DN150187841.510.589396DN150DN15018884610.628937DN150DN150189850.510.668433DN150DN15019085510.707884DN150DN150191859.510.747291DN150DN15019286410.786653DN150DN150193868.510.825971DN150DN15019487310.865246DN150DN150195877.510.904478DN150DN15019688210.943667DN150DN150197886.510.982813DN150DN15019889111.021917DN150DN150199895.511.060979DN150DN15020090011.1DN150DN150201904.511.138979DN150DN15020290911.177918DN150DN150203913.511.216816DN150DN15020491811.255673DN150DN150205922.511.294491DN150DN15020692711.333268DN150DN150207931.511.372007DN150DN15020893611.410706DN150DN150209940.511.449366DN150DN15021094511.487988DN150DN150211949.511.526571DN150DN15021295411.565116DN150DN150213958.511.603623DN150DN15021496311.642093DN150DN150第1页Sheet1215967.511.680526DN150DN15021697211.718921DN150DN150217976.511.75728DN150DN15021898111.795602DN150DN150219985.511.833888DN150DN15022099011.872138DN150DN150221994.511.910353DN150DN15022299911.948531DN150DN1502231003.511.986675DN150DN150179484805.52178 10.2721.2DN1500.541.12旅旅馆馆 q=0.2*2.5*N=0.5*N浴浴缸缸N1.00,面面盆盆N0.80,坐坐便便器器N=0.50,淋淋浴浴器器N0.50,净净身身盆盆N=0.35套套数数当当量量流流量量(l/s)冷冷水水管管管管径径(mm)冷冷水水管管流流速速(m/s)热热水水管管管管径径(mm)0.350.3DN200.93DN200.50.35DN201.09DN250.80.45DN250.85DN2510.5DN250.94DN25(DN32)240.711.00DN320.741.05DN32581.111.41DN400.871.11DN409231.502.40DN500.711.13DN5024642.454.00DN700.701.13DN70651214.035.50DN800.811.11DN801224005.5210.00DN1000.631.15DN1004011764 10.0121.00DN1500.531.11DN150办公,商场 q=0.2*1.5 N=0.3 N面盆N0.5,坐便器N=0.5,淋浴器N0.5,小便器N0.5,拖布盆N=1.0当当量量流流量量(l/s)管管径径(mm)流流速速(m/s)10.3DN200.93230.420.52DN250.780.984120.61.04DN320.631.1013191.081.31DN400.861.0420541.342.20DN500.631.04551442.233.6DN700.631.021452893.615.1DN800.721.0329010245.11-9.6DN1000.591.1110254900 9.6121.00DN1500.511.10厨厨房房第2页Sheet1当当量量（N N）管管径径（mmmm）1152320462571032111540162550203965406380第3页Sheet1流量Q管径D流速v1.460.041.16242生活给水管道 的水流速度管径流速15201.025401.250701.5801.8第4页Sheet1消火栓管道水流速度2.5喷淋管道水流速度5.0热热水水管管流流速速(m/s)1.090.740.951.06(0.58)0.811,210.941.200.761.220.741.210.861.170.661.200.551.18第5页Sheet2旅馆 =2.5当量流量管径流速10.5DN250.94240.711.00DN32 0.741.05581.111.41DN40 0.871.119231.502.40DN50 0.711.1324642.454.00DN70 0.701.13651214.035.50DN80 0.811.111224005.5210.00DN100 0.631.1540110.01DN1500.53第6页Sheet3办公,商场=1.5当量流量管径流速10.3DN200.93230.420.52DN25 0.780.984120.61.04DN32 0.631.1013191.081.31DN40 0.861.0420541.342.20DN50 0.631.04551442.233.6DN70 0.631.021452893.615.1DN80 0.721.0329010245.11-9.6DN100 0.591.11102526729.61DN1500.512672总总计计数数11901190第7页Sheet4办公,商场=1.5当量流量管径10.3DN201DN20 计计数数DN202 0.424264DN253 0.519615DN2523DN25 计计数数DN2540.6DN3250.67082DN326 0.734847DN327 0.793725DN328 0.848528DN3290.9DN3210 0.948683DN3211 0.994987DN32121.03923DN32412DN32 计计数数DN3213 1.081665DN4014 1.122497DN4015 1.161895DN40161.2DN4017 1.236932DN4018 1.272792DN40191.30767DN401319DN40 计计数数DN4020 1.341641DN5021 1.374773DN5022 1.407125DN5023 1.438749DN5024 1.469694DN50251.5DN5026 1.529706DN5027 1.558846DN5028 1.587451DN5029 1.615549DN5030 1.643168DN5031 1.670329DN5032 1.697056DN5033 1.723369DN5034 1.749286DN5035 1.774824DN50361.8DN5037 1.824829DN5038 1.849324DN5039 1.873499DN50第8页Sheet440 1.897367DN5041 1.920937DN5042 1.944222DN5043 1.967232DN5044 1.989975DN5045 2.012461DN5046 2.034699DN5047 2.056696DN5048 2.078461DN50492.1DN50502.12132DN5051 2.142429DN5052 2.163331DN5053 2.184033DN5054 2.204541DN502054DN50 计计数数DN50552.22486DN7056 2.244994DN70572.26495DN7058 2.284732DN7059 2.304344DN70602.32379DN7061 2.343075DN7062 2.362202DN7063 2.381176DN70642.4DN7065 2.418677DN7066 2.437212DN7067 2.455606DN7068 2.473863DN7069 2.491987DN70702.50998DN7071 2.527845DN7072 2.545584DN7073 2.563201DN7074 2.580698DN7075 2.598076DN7076 2.615339DN7077 2.632489DN7078 2.649528DN7079 2.666458DN7080 2.683282DN70812.7DN7082 2.716616DN70832.73313DN7084 2.749545DN70第9页Sheet485 2.765863DN7086 2.782086DN7087 2.798214DN7088 2.814249DN7089 2.830194DN70902.84605DN7091 2.861818DN7092 2.877499DN7093 2.893095DN7094 2.908608DN7095 2.924038DN7096 2.939388DN7097 2.954657DN7098 2.969848DN7099 2.984962DN701003DN70101 3.014963DN70102 3.029851DN70103 3.044667DN70104 3.059412DN70105 3.074085DN70106 3.088689DN70107 3.103224DN70108 3.117691DN70109 3.132092DN70110 3.146427DN70111 3.160696DN70112 3.174902DN70113 3.189044DN70114 3.203123DN70115 3.217142DN70116 3.231099DN70117 3.244996DN70118 3.258834DN70119 3.272614DN70120 3.286335DN701213.3DN70122 3.313608DN70123 3.327161DN70124 3.340659DN70125 3.354102DN70126 3.367492DN70127 3.380828DN70128 3.394113DN70129 3.407345DN70130 3.420526DN70第10页Sheet4131 3.433657DN70132 3.446738DN70133 3.459769DN70134 3.472751DN70135 3.485685DN70136 3.498571DN701373.51141DN70138 3.524202DN70139 3.536948DN70140 3.549648DN70141 3.562303DN70142 3.574913DN70143 3.587478DN701443.6DN7055144DN70 计计数数DN70145 3.612478DN80146 3.624914DN80147 3.637307DN80148 3.649658DN80149 3.661967DN80150 3.674235DN80151 3.686462DN80152 3.698648DN80153 3.710795DN80154 3.722902DN801553.73497DN80156 3.746999DN80157 3.758989DN80158 3.770942DN80159 3.782856DN80160 3.794733DN80161 3.806573DN80162 3.818377DN80163 3.830144DN80164 3.841875DN801653.85357DN801663.86523DN80167 3.876854DN80168 3.888444DN801693.9DN80170 3.911521DN80171 3.923009DN80172 3.934463DN80173 3.945884DN80174 3.957272DN80175 3.968627DN80第11页Sheet41763.97995DN801773.99124DN80178 4.002499DN80179 4.013726DN80180 4.024922DN80181 4.036087DN80182 4.047221DN80183 4.058325DN80184 4.069398DN80185 4.080441DN80186 4.091455DN80187 4.102438DN80188 4.113393DN80189 4.124318DN80190 4.135215DN80191 4.146082DN80192 4.156922DN80193 4.167733DN80194 4.178516DN80195 4.189272DN801964.2DN80197 4.210701DN80198 4.221374DN80199 4.232021DN80200 4.242641DN80201 4.253234DN80202 4.263801DN80203 4.274342DN80204 4.284857DN80205 4.295346DN802064.30581DN80207 4.316248DN80208 4.326662DN802094.33705DN80210 4.347413DN80211 4.357752DN80212 4.368066DN80213 4.378356DN80214 4.388622DN80215 4.398863DN80216 4.409082DN80217 4.419276DN80218 4.429447DN80219 4.439595DN80220 4.449719DN80221 4.459821DN80第12页Sheet4222 4.469899DN80223 4.479955DN80224 4.489989DN802254.5DN80226 4.509989DN80227 4.519956DN80228 4.529901DN80229 4.539824DN80230 4.549725DN80231 4.559605DN80232 4.569464DN80233 4.579301DN80234 4.589118DN80235 4.598913DN80236 4.608687DN80237 4.618441DN80238 4.628175DN80239 4.637887DN802404.64758DN80241 4.657252DN80242 4.666905DN80243 4.676537DN802444.68615DN80245 4.695743DN80246 4.705316DN802474.71487DN80248 4.724405DN802494.73392DN80250 4.743416DN80251 4.752894DN80252 4.762352DN80253 4.771792DN80254 4.781213DN80255 4.790616DN802564.8DN80257 4.809366DN80258 4.818714DN80259 4.828043DN80260 4.837355DN80261 4.846648DN80262 4.855924DN80263 4.865182DN80264 4.874423DN80265 4.883646DN80266 4.892852DN802674.90204DN80第13页Sheet4268 4.911212DN80269 4.920366DN80270 4.929503DN80271 4.938623DN80272 4.947727DN80273 4.956813DN80274 4.965884DN80275 4.974937DN80276 4.983974DN80277 4.992995DN802785.002DN80279 5.010988DN802805.01996DN80281 5.028916DN80282 5.037857DN80283 5.046781DN802845.05569DN80285 5.064583DN802865.07346DN80287 5.082322DN80288 5.091169DN802895.1DN80145289DN80 计计数数DN80290 5.108816DN100291 5.117617DN100292 5.126402DN100293 5.135173DN100294 5.143928DN100295 5.152669DN100296 5.161395DN100297 5.170106DN100298 5.178803DN100299 5.187485DN100300 5.196152DN100301 5.204805DN100302 5.213444DN100303 5.222069DN100304 5.230679DN100305 5.239275DN100306 5.247857DN100307 5.256425DN100308 5.264979DN100309 5.273519DN100310 5.282045DN100311 5.290558DN100312 5.299057DN100第14页Sheet4313 5.307542DN100314 5.316014DN100315 5.324472DN100316 5.332917DN100317 5.341348DN100318 5.349766DN100319 5.358171DN100320 5.366563DN100321 5.374942DN100322 5.383308DN1003235.39166DN1003245.4DN100325 5.408327DN100326 5.416641DN100327 5.424942DN100328 5.433231DN100329 5.441507DN100330 5.449771DN100331 5.458022DN1003325.46626DN100333 5.474486DN1003345.4827DN100335 5.490902DN100336 5.499091DN100337 5.507268DN100338 5.515433DN100339 5.523586DN100340 5.531727DN100341 5.539856DN100342 5.547973DN100343 5.556078DN100344 5.564171DN100345 5.572253DN100346 5.580323DN100347 5.588381DN100348 5.596427DN100349 5.604463DN100350 5.612486DN100351 5.620498DN100352 5.628499DN100353 5.636488DN100354 5.644466DN100355 5.652433DN100356 5.660389DN100357 5.668333DN100358 5.676266DN100第15页Sheet4359 5.684189DN1003605.6921DN1003615.7DN100362 5.707889DN100363 5.715768DN100364 5.723635DN100365 5.731492DN100366 5.739338DN100367 5.747173DN100368 5.754998DN100369 5.762812DN100370 5.770615DN100371 5.778408DN1003725.78619DN100373 5.793962DN100374 5.801724DN100375 5.809475DN100376 5.817216DN100377 5.824946DN100378 5.832667DN100379 5.840377DN100380 5.848077DN100381 5.855766DN100382 5.863446DN100383 5.871116DN100384 5.878775DN100385 5.886425DN100386 5.894065DN100387 5.901695DN100388 5.909315DN100389 5.916925DN100390 5.924525DN100391 5.932116DN100392 5.939697DN100393 5.947268DN1003945.95483DN100395 5.962382DN100396 5.969925DN100397 5.977458DN100398 5.984981DN100399 5.992495DN1004006DN100401 6.007495DN100402 6.014981DN100403 6.022458DN100404 6.029925DN100第16页Sheet4405 6.037384DN100406 6.044833DN100407 6.052272DN100408 6.059703DN100409 6.067125DN100410 6.074537DN1004116.08194DN100412 6.089335DN1004136.09672DN100414 6.104097DN100415 6.111465DN100416 6.118823DN100417 6.126173DN100418 6.133514DN100419 6.140847DN1004206.14817DN100421 6.155485DN100422 6.162792DN100423 6.170089DN100424 6.177378DN100425 6.184658DN1004266.19193DN100427 6.199193DN100428 6.206448DN100429 6.213695DN100430 6.220932DN100431 6.228162DN100432 6.235383DN100433 6.242596DN1004346.2498DN100435 6.256996DN100436 6.264184DN100437 6.271363DN100438 6.278535DN100439 6.285698DN100440 6.292853DN1004416.3DN100442 6.307139DN1004436.31427DN100444 6.321392DN100445 6.328507DN100446 6.335614DN100447 6.342712DN100448 6.349803DN100449 6.356886DN100450 6.363961DN100第17页Sheet4451 6.371028DN100452 6.378087DN100453 6.385139DN100454 6.392183DN100455 6.399219DN100456 6.406247DN100457 6.413267DN1004586.42028DN100459 6.427286DN100460 6.434283DN100461 6.441273DN100462 6.448256DN1004636.45523DN100464 6.462198DN100465 6.469158DN1004666.47611DN100467 6.483055DN100468 6.489992DN100469 6.496922DN100470 6.503845DN1004716.51076DN100472 6.517668DN100473 6.524569DN100474 6.531462DN100475 6.538348DN100476 6.545227DN100477 6.552099DN100478 6.558963DN100479 6.565821DN100480 6.572671DN100481 6.579514DN1004826.58635DN100483 6.593178DN1004846.6DN100485 6.606815DN100486 6.613622DN100487 6.620423DN100488 6.627217DN100489 6.634003DN100490 6.640783DN100491 6.647556DN100492 6.654322DN100493 6.661081DN100494 6.667833DN100495 6.674579DN100496 6.681317DN100第18页Sheet4497 6.688049DN100498 6.694774DN100499 6.701492DN100500 6.708204DN100501 6.714909DN100502 6.721607DN100503 6.728298DN100504 6.734983DN100505 6.741662DN100506 6.748333DN100507 6.754998DN100508 6.761657DN100509 6.768309DN100510 6.774954DN100511 6.781593DN100512 6.788225DN100513 6.794851DN1005146.80147DN100515 6.808083DN1005166.81469DN1005176.82129DN100518 6.827884DN100519 6.834471DN100520 6.841053DN100521 6.847627DN100522 6.854196DN100523 6.860758DN100524 6.867314DN100525 6.873864DN100526 6.880407DN100527 6.886944DN100528 6.893475DN1005296.9DN100530 6.906519DN100531 6.913031DN100532 6.919538DN100533 6.926038DN100534 6.932532DN1005356.93902DN100536 6.945502DN100537 6.951978DN100538 6.958448DN100539 6.964912DN1005406.97137DN100541 6.977822DN100542 6.984268DN100第19页Sheet4543 6.990708DN100544 6.997142DN100545 7.003571DN100546 7.009993DN100547 7.016409DN1005487.02282DN100549 7.029225DN100550 7.035624DN100551 7.042017DN100552 7.048404DN100553 7.054786DN100554 7.061161DN100555 7.067531DN100556 7.073896DN100557 7.080254DN100558 7.086607DN100559 7.092954DN100560 7.099296DN100561 7.105632DN100562 7.111962DN100563 7.118286DN100564 7.124605DN100565 7.130919DN100566 7.137226DN100567 7.143529DN100568 7.149825DN100569 7.156116DN100570 7.162402DN100571 7.168682DN100572 7.174956DN100573 7.181226DN100574 7.187489DN100575 7.193747DN1005767.2DN100577 7.206247DN100578 7.212489DN100579 7.218726DN100580 7.224957DN100581 7.231182DN100582 7.237403DN100583 7.243618DN100584 7.249828DN100585 7.256032DN100586 7.262231DN100587 7.268425DN100588 7.274613DN100第20页Sheet4589 7.280797DN100590 7.286975DN100591 7.293147DN100592 7.299315DN100593 7.305477DN100594 7.311635DN100595 7.317787DN100596 7.323933DN100597 7.330075DN100598 7.336212DN100599 7.342343DN100600 7.348469DN1006017.35459DN100602 7.360706DN100603 7.366817DN100604 7.372923DN100605 7.379024DN1006067.38512DN100607 7.391211DN100608 7.397297DN100609 7.403378DN100610 7.409453DN100611 7.415524DN1006127.42159DN100613 7.427651DN100614 7.433707DN100615 7.439758DN100616 7.445804DN100617 7.451845DN100618 7.457882DN100619 7.463913DN1006207.46994DN100621 7.475961DN100622 7.481978DN1006237.48799DN100624 7.493998DN1006257.5DN100626 7.505998DN1006277.51199DN100628 7.517978DN100629 7.523962DN1006307.52994DN100631 7.535914DN100632 7.541883DN100633 7.547847DN100634 7.553807DN100第21页Sheet4635 7.559762DN100636 7.565712DN100637 7.571658DN100638 7.577599DN100639 7.583535DN100640 7.589466DN100641 7.595393DN100642 7.601316DN100643 7.607233DN100644 7.613147DN100645 7.619055DN100646 7.624959DN100647 7.630858DN100648 7.636753DN100649 7.642644DN100650 7.648529DN1006517.65441DN100652 7.660287DN100653 7.666159DN100654 7.672027DN1006557.67789DN100656 7.683749DN100657 7.689603DN100658 7.695453DN100659 7.701299DN1006607.70714DN100661 7.712976DN100662 7.718808DN100663 7.724636DN100664 7.730459DN100665 7.736278DN100666 7.742093DN100667 7.747903DN100668 7.753709DN1006697.75951DN100670 7.765307DN1006717.7711DN100672 7.776889DN100673 7.782673DN100674 7.788453DN100675 7.794229DN1006767.8DN100677 7.805767DN1006787.81153DN100679 7.817289DN100680 7.823043DN100第22页Sheet4681 7.828793DN100682 7.834539DN100683 7.840281DN100684 7.846018DN100685 7.851751DN100686 7.857481DN100687 7.863205DN100688 7.868926DN100689 7.874643DN100690 7.880355DN100691 7.886064DN100692 7.891768DN100693 7.897468DN100694 7.903164DN100695 7.908856DN100696 7.914544DN100697 7.920227DN100698 7.925907DN100699 7.931582DN100700 7.937254DN100701 7.942921DN100702 7.948585DN100703 7.954244DN100704 7.959899DN100705 7.965551DN100706 7.971198DN100707 7.976841DN100708 7.982481DN100709 7.988116DN100710 7.993748DN100711 7.999375DN100712 8.004998DN100713 8.010618DN100714 8.016234DN100715 8.021845DN100716 8.027453DN100717 8.033057DN100718 8.038657DN100719 8.044253DN100720 8.049845DN100721 8.055433DN100722 8.061017DN100723 8.066598DN100724 8.072174DN100725 8.077747DN100726 8.083316DN100第23页Sheet4727 8.088881DN100728 8.094443DN1007298.1DN100730 8.105554DN100731 8.111104DN1007328.11665DN100