|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2010年09 期
| 標(biāo)題 |
| 非線性方程的Excel擬合及在沉降評(píng)估中的應(yīng)用(19 卷) |
| 英文標(biāo)題 |
| Non-linear equation抯 fitting by using Excel and its application in sedimentation evaluation |
| 摘要 |
| 曲線擬合是沉降評(píng)估的重要步驟，處理方法和過(guò)程比較復(fù)雜，需要編制專門程序進(jìn)行數(shù)據(jù)處理與計(jì)算。作者利用Excel中的規(guī)劃求解功能，分步實(shí)現(xiàn)沉降觀測(cè)中的曲線方程擬合；利用Excel的表格功能，可實(shí)現(xiàn)沉降預(yù)估指標(biāo)的計(jì)算。本文敘述的方法直接利用Excel的數(shù)據(jù)格式和功能，方便快捷 |
| 作者 |
| 新聞作者:張志新 |
| 關(guān)鍵字 |
