{"title":"有效的最小二乘导线调整使用电子表格","authors":"T. W. Hu, Francis Tan, Alan Barnes","doi":"10.1080/00050357.2003.10558850","DOIUrl":null,"url":null,"abstract":"This paper establishes the theory and an efficient spreadsheet procedure for direct minimization of squared residuals using the idea of an expanding ellipsoid and Excel’s generalized reduced gradient (GRG) solver. Not requiring any series expansion or programming, the new approach makes least-squares traverse adjustment as easy to apply as the popular Bowditch method, yet restores full mathematical rigor.","PeriodicalId":119818,"journal":{"name":"Australian Surveyor","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2003-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Efficient Least Squares Traverse Adjustment Using Spreadsheets\",\"authors\":\"T. W. Hu, Francis Tan, Alan Barnes\",\"doi\":\"10.1080/00050357.2003.10558850\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This paper establishes the theory and an efficient spreadsheet procedure for direct minimization of squared residuals using the idea of an expanding ellipsoid and Excel’s generalized reduced gradient (GRG) solver. Not requiring any series expansion or programming, the new approach makes least-squares traverse adjustment as easy to apply as the popular Bowditch method, yet restores full mathematical rigor.\",\"PeriodicalId\":119818,\"journal\":{\"name\":\"Australian Surveyor\",\"volume\":null,\"pages\":null},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2003-06-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Australian Surveyor\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1080/00050357.2003.10558850\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Australian Surveyor","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1080/00050357.2003.10558850","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Efficient Least Squares Traverse Adjustment Using Spreadsheets
This paper establishes the theory and an efficient spreadsheet procedure for direct minimization of squared residuals using the idea of an expanding ellipsoid and Excel’s generalized reduced gradient (GRG) solver. Not requiring any series expansion or programming, the new approach makes least-squares traverse adjustment as easy to apply as the popular Bowditch method, yet restores full mathematical rigor.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
