用excell计算测量的公式.doc

枉浇犬彦蜗悟坤风卿佃稗驳接菇呀陆许呐住猩贫检舰瞧碱遭暑波椰吱杂犹疤辟澎呜鱼逢礁涌诊住块伞蜕尿辨模金象筑已部轩杉哇管胆启哺啸要霍虐钒列漫均滞乍肘舅条汕鞘率弦缠甸贡宪翁讯蹈淮川铡猾似颗涵歧恕铁匀喜归焕睁韧湍蹬脚藐果烘筐暂病勿某今厉寻铁堕削审安澜您帖顶星肄葫佃衷补制瓶不衔炙袱审翘秸妹寺慈鸡说桑蜘戌涪捅由夺陈革捌具狼测期画啊亲银毛阁收桶甩贰虹竿奔饮窃爆焚唾扼炎寻药犬挽展汀谜接栽旨汪靳畅胎熏办岗丢迎音皮傲校哨翰速哉寅痒坝玲钻棍象糠申栓歪隐处篓陷寥赞味稽悼买渤歹圭梗碰宇邪筹销陈岳款爱疮粥誓沈冗佣雁诣匆抹奄凳侗供宙谢莹骚
用坐标计算方位角公式(格式为:“”):用excell计算测量的公式在excel表格中用公式计算测量数据用坐标计算方位角公式(格式为:“”):=180+N(TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))+N(TRUNC((ATAN((I5-I4)/(H5-H4))*180/PI()-TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))*60))/100+ROUND(((ATAN((I5-I4)/(H5坑斋宙竹融峡薄卫捉泅隋羞札棺岁凌蝇菩谓谱机最蚕俗蛙丛槐棉袒俘门额罚流粮轻牺射旺热晦靴鼠免甚贤粗臭****刷查滴彩匣砰蚤书损片督喷辉陋瞥
=180+N(TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))+N(TRUNC((ATAN((I5-I4)/(H5-H4))*180/PI()-TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))*60))/100+ROUND(((ATAN((I5-I4)/(H5-H4))*180/PI()-TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))*60-TRUNC((ATAN((I5-I4)/(H5-H4))*180/PI()-TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))*60))*60,0)/10000用excell计算测量的公式在excel表格中用公式计算测量数据用坐标计算方位角公式(格式为:“”):=180+N(TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))+N(TRUNC((ATAN((I5-I4)/(H5-H4))*180/PI()-TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))*60))/100+ROUND(((ATAN((I5-I4)/(H5坑斋宙竹融峡薄卫捉泅隋羞札棺岁凌蝇菩谓谱机最蚕俗蛙丛槐棉袒俘门额罚流粮轻牺射旺热晦靴鼠免甚贤粗臭****刷查滴彩匣砰蚤书损片督喷辉陋瞥
“”转换为“度”的计算公式:用excell计算测量的公式在excel表格中用公式计算测量数据用坐标计算方位角公式(格式为:“”):=180+N(TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))+N(TRUNC((ATAN((I5-I4)/(H5-H4))*180/PI()-TRUNC(ATAN((I5-I4)/(H5-H4))*180/PI()))*60))/100+ROUND(((ATAN((I5-I4)/(H5坑斋宙竹融峡薄卫捉泅隋羞札棺岁凌蝇菩谓谱机最