差积、累积曲线模板.xls

差积、累积曲线模板.xls

《差积、累积曲线模板.xls》由会员分享，可在线阅读，更多相关《差积、累积曲线模板.xls（14页珍藏版）》请在冰点文库上搜索。

差积图号图4-6统计年数52图4-6水库场址站枯水径流量模比系数差积曲线累积图号图4-9平均值701.9231图4-9水库场址站枯水径流量模比系数累积平均曲线站名水库场址项目枯水径流量ki年份（Ki-1）检验线年份模比系数累积平均值195118302.607119511.60712329020025.59311952624.50.889719521.49682192020014.20381953358.40.510619531.00741918020003.049919544150.591219540.59865205019993.19671955328.90.468619550.06722192019982.70641956495.40.70581956-0.2270027019972.4423195716722.382019571.15502466019962.2133195819002.706819582.86187397019952.033019591343.61.914219593.77604384019941.874719603020.430219603.20629041019931.777719613540.504319612.71061918019921.682319624350.619719622.33034521019911.632019634820.686719632.01703014019901.544219644230.602619641.61966027019891.495519652960.421719651.0413589019881.435219665100.726619660.76793425019871.397219672500.356219670.12409863019861.357219684540.64681968-0.2291068019851.302919693670.52281969-0.7062575019841.261219708691.23801970-0.4682301019831.238319717831.11551971-0.3527233019821.224519723620.51571972-0.8369973019811.189519733160.45021973-1.3868055019801.152919743150.44881974-1.9380384019791.130519755100.72661975-2.211463019781.106419768231.17251976-2.0389699019771.078419772660.37901977-2.660011019761.081919783700.52711978-3.1328877019751.069219794330.61691979-3.516011019741.047819802440.34761980-4.1683945019731.027919813180.45301981-4.7153534019721.011419826660.94881982-4.7665315019711.014619835640.80351983-4.9630247019701.021419843590.51151984-5.4515726019691.006719852660.37901985-6.0726137019680.996519865040.71801986-6.3545863019670.978719875800.82631987-6.5282849019660.971919884150.59121988-6.9370521019650.957419896050.86191989-7.0751342019640.948319903450.49151990-7.5836274019630.94171991756.91.07831991-7.5053041019620.93391992511.20.72831992-7.7770192019610.92371993635.000.90471993-7.87236160.000019600.91221994427.100.60851994-8.2638904019590.93501995541.000.77071995-8.4931507019580.97431996589.000.83911996-8.6540274019571.00491997787.601.12211997-8.5319671019560.99861998523.100.74521998-8.7867288019550.9875199925533.63721999-6.1495781019540.97942000520.80.74202000-6.4076164019530.970120011975.62.81462001-4.593063019520.968520023925.95.593120020019511.0000检验线注：

11、纯粹绘制差积、累计曲线1可以不运行“输入公式”。

12、“输入公式”是为检查1图形正确否，练习如何给单元1格输入公式。

111计算过程：

11、输入绘制差积、累计曲线的图号12、输入站名、计算项目13、输入年份、历年资料14、按“绘图存盘”按钮1至此，即完成了该站差积、累计曲线1的绘制，并已经按指定路径、指定文1件名存盘，且保存退出了该文件。

111111111111111111111111图4-6水库场址站枯水径流量模比系数差积曲线图4-9水库场址站枯水径流量模比系数累积平均曲线1111111111111图4-6水库场址站枯水径流量模比系数差积曲线19511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994-10-8-6-4-20246年份（Ki-1）图4-9水库场址站枯水径流量模比系数累积平均曲线200220001998199619941992199019881986198419821980197819761974197219701968196619641962196019581956195419520.90.920.940.960.9811.020.00001.00002.00003.00004.00005.00006.0000年份模比系数累积平均值