å¨Excelä¸å¦ä½ç¼è¾ç¨åºè®¡ç®è·ç¦»åæ¹ä½è§
1 æ¹ä½è§è®¡ç®ç¨åº
2
æ¶ç«ç¹ å¾
æ±ç¹ â³Xå¢é â³Yå¢é è§åº¦ è§åº¦ æ¹ä½è§ è·ç¦»
3 N(X)åæ E(Y)åæ N(X)åæ E(Y)åæ m m ° ° ° â² ã m
4 527560.240 356531.589 527797.084 356095.150 236.844 -436.439 -61.51245 298.48755 298°29â²15ã 496.562
5 527560.240 356531.589 527785.084 356095.864 224.844 -435.725 -62.70521 297.29479 297°17â²41ã 490.317
6 527560.240 356531.589 527804.821 356125.819 244.581 -405.770 -58.92024 301.07976 301°04â²47ã 473.782
7 527560.240 356531.589 527794.912 356118.617 234.672 -412.972 -60.39259 299.60741 299°36â²27ã 474.992
8 527560.240 356531.589 527785.002 356111.415 224.762 -420.174 -61.8565 298.1435 298°08â²37ã 476.513
以ä¸è¡¨ä¸ºä¾ï¼æ°å»ºä¸ä¸ªExcelè¡¨æ ¼ï¼ç¨10个åå
æ ¼AãBãCãDãEãFãGãHãIãJãA4ãB4åå«è¾æ¶ç«ç¹çXãYåæ ï¼C4ãD4åå«è¾åè§ç¹ï¼æåè§ç¹ï¼çXãYåæ ãE4=C4-A4ï¼F4=D4-B4,G4=ATAN(F4/E4)*180/PI(),æè
G4=DEGREES(ATAN(F4/E4)) (ATANæ¯åæ£åå¼tan-1,PI()æ¯åå¨çÏ,ç´æ¥è¾ATANåPI(),DEGREESæ¯å¼§åº¦è½¬æ¢è§åº¦)H4=IFï¼E4*F4ï¼0ï¼IF(E4ï¼0,G4,180+G4ï¼,IF(E4ï¼0, 180+G4ï¼360+G4ï¼ï¼,ç¹I4å³å»é¼ æ éæ©è®¾ç½®åå
æ ¼è¿å
¥æ°åéæ©èªå®ä¹,å¨ç±»åä¸é¢æ¡å
ç¼è¾âãhã°mmâ²ssãâ, æç¡®å®ï¼ããå â符å·å¨çµèé®çä¸éæ©è¾ï¼Â°â²ã符å·å¨è¾å
¥æ³é®çåä½ç¬¦å·ä¸éæ©è¾ãI4=H4/24,æè
ç´æ¥I4=TEXT(H4/24, âãhã°mmâ²ssãâ),J4=SQRT(E4^2+ F4^2)æJ4=SQRT(E4* E4+ F4* F4)(SQRTè¡¨ç¤ºæ ¹å·)ãæ¶ç«ç¹åæ ä¸è¬ä¸åï¼åªä¸è¿åè§ç¹ï¼æåè§ç¹ï¼çåæ å¨ååï¼æ们å°æ¶ç«ç¹åæ A4ãB4éå®æ$A$4ã$B$4,å°EãFãGãHåå
æ ¼éèï¼åªæ¾ç¤º6个åå
æ ¼ã
温馨提示:答案为网友推荐,仅供参考