三角高程测量自动计算6

Sheet1 三角高程测量记录表表二 观测日期：5.11_观测仪器：宾得R202N观测人员：__胡佑健__记录人员：___董浩宇_ 起算点 待定点 单向测斜距S1 竖直角a1'" 单向测斜距S2 竖直角a2-180°'" S*sina 曲率改正 两差改正f 高程m 测量时间 斜距均值 角度均值 O A 173.432 4 52 173.433 4 49 0.244 0.002 0.247 5.000 7:00 0.0014083833 173.4324362441 0.9999990082 仪器高i D 166.956 5 14 166.957 5 14 0.254 0.002 0.256 4.990 0.0015223144 166.9563826143 0.9999988413 1.570 C 111.367 7 52 111.368 7 54 0.255 0.001 0.256 4.990 0.0022931667 111.3676722646 0.9999973707 对中杆高v B 101.842 8 39 101.843 8 42 0.257 0.001 0.258 4.989 0.0025234525 101.8426433851 0.9999968161 1.647 A 173.434 4 52 173.432 4 53 0.246 0.002 0.248 5.000 7:30 0.0014180795 173.4330844521 0.9999989945 D 166.958 5 16 166.956 5 16 0.256 0.002 0.258 4.990 0.0015320106 166.9570439583 0.9999988265 C 111.368 7 51 111.367 7 55 0.255 0.001 0.256 4.992 0.0022931667 111.3676963661 0.9999973707 B 101.843 8 43 101.842 8 42 0.258 0.001 0.259 4.990 0.0025331488 101.8426368073 0.9999967916 A 173.432 4 52 173.432 4 53 0.246 0.002 0.248 5.000 8:00 0.0014180795 173.4323151588 0.9999989945 D 166.956 5 16 166.956 5 17 0.256 0.002 0.258 4.990 0.0015344347 166.9563033907 0.9999988228 C 111.367 7 53 111.367 7 50 0.255 0.001 0.256 4.993 0.0022858945 111.3672023749 0.9999973873 B 101.842 8 42 101.842 8 41 0.257 0.001 0.258 4.990 0.0025283007 101.8421850662 0.9999968038 A 173.432 4 53 173.433 4 54 0.247 0.002 0.249 5.000 9:00 0.0014229277 173.4322248617 0.9999989876 D 166.956 5 19 166.957 5 22 0.259 0.002 0.262 4.988 0.0015538272 166.9562164653 0.9999987928 C 111.367 7 55 111.367 7 57 0.257 0.001 0.258 4.991 0.0023077111 111.3671443919 0.9999973372 B 101.842 8 44 101.842 8 45 0.259 0.001 0.260 4.989 0.002542845 101.8421320423 0.999996767 A 173.433 5 0 173.434 5 1 0.253 0.002 0.255 5.000 10:00 0.0014568646 173.4333826335 0.9999989388 D 166.957 5 23 166.958 5 22 0.261 0.002 0.263 4.992 0.0015635235 166.9573310056 0.9999987777 C 111.368 8 3 111.368 8 4 0.261 0.001 0.262 4.993 0.002344072 111.3678878393 0.9999972527 B 101.842 8 55 101.843 8 56 0.264 0.001 0.265 4.990 0.0025961743 101.8428119041 0.9999966299 A 173.432 5 2 173.432 5 0 0.253 0.002 0.255 5.000 11:00 0.0014592887 173.432103732 0.9999989352 D 166.956 5 24 166.956 5 24 0.262 0.002 0.264 4.991 0.0015707957 166.9560998586 0.9999987663 C 111.367 8 4 111.367 8 6 0.262 0.001 0.263 4.993 0.0023513442 111.3670666101 0.9999972356 B 101.842 8 56 101.842 8 57 0.265 0.001 0.266 4.990 0.0026010225 101.842060913 0.9999966173 A 173.432 5 4 173.432 5 2 0.255 0.002 0.257 5.000 12:00 0.0014689849 173.4320272251 0.999998921 D 166.956 5 28 166.956 5 26 0.265 0.002 0.267 4.990 0.0015853401 166.9560262085 0.9999987433 C 111.367 8 8 111.367 8 9 0.264 0.001 0.265 4.992 0.0023683126 111.3670174822 0.9999971955 B 101.842 8 59 101.842 8 58 0.266 0.001 0.267 4.990 0.0026107187 101.842015987 0.9999965921 A 173.431 5 4 173.433 5 5 0.256 0.002 0.258 5.000 13:00 0.0014762571 173.4319906968 0.9999989103 D 166.955 5 28 166.957 5 27 0.265 0.002 0.267 4.991 0.0015877641 166.9559910442 0.9999987395 C 111.367 8 12 111.367 8 11 0.265 0.001 0.266 4.992 0.002382857 111.3669940261 0.999997161 B 101.842 9 2 101.842 9 3 0.268 0.001 0.269 4.990 0.0026301112 101.841994537 0.9999965413 注：a1、S1为盘左观测值，a2、S2为盘右观测值。假设A点高程为5.000 观测日期：5.11_观测仪器：宾得R202N观测人员：__胡佑健__记录人员：___董浩宇_ 起算点 待定点 单向测斜距S1 竖直角a1'" 单向测斜距S2 竖直角a2-180°'" S*sina 曲率改正 两差改正f 高程m 测量时间 0.9999992974 仪器高i A 166.805 4 3 166.806 4 6 0.198 0.002 0.200 5.000 14:00 0.0011853692 166.8055 0.9999992684 1.475 D 173.310 4 10 173.311 4 9 0.210 0.002 0.212 4.988 0.0012096098 173.3105 0.9999982353 对中杆高v C 111.271 6 28 111.272 6 27 0.209 0.001 0.210 4.990 0.0018786519 111.2715 0.999997827 1.645 B 101.715 7 9 101.715 7 11 0.212 0.001 0.213 4.987 0.0020846973 101.715 0.9999993003 A 166.805 4 3 166.804 4 5 0.197 0.002 0.200 5.000 15:00 0.0011829451 166.8045 0.9999992714 D 173.310 4 10 173.309 4 8 0.209 0.002 0.212 4.988 0.0012071858 173.3095 0.999998249 C 111.271 6 25 111.272 6 27 0.208 0.001 0.209 4.990 0.0018713797 111.2715 0.9999978522 B 101.715 7 8 101.715 7 7 0.211 0.001 0.212 4.988 0.002072577 101.715 0.9999993202 A 166.805 4 1 166.804 4 0 0.194 0.002 0.197 5.000 16:00 0.0011659766 166.8045 0.9999992917 D 173.309 4 5 173.310 4 6 0.206 0.002 0.209 4.988 0.0011902173 173.3095 0.9999982671 C 111.271 6 23 111.272 6 25 0.207 0.001 0.208 4.989 0.0018616835 111.2715 0.9999978822 B 101.714 7 4 101.715 7 5 0.209 0.001 0.210 4.987 0.0020580326 101.7145 0.9999993202 A 166.805 4 0 166.804 4 1 0.194 0.002 0.197 5.000 17:00 0.0011659766 166.8045 0.9999993032 D 173.310 4 3 173.310 4 4 0.205 0.002 0.207 4.990 0.001180521 173.31 0.9999982896 C 111.271 6 22 111.272 6 21 0.206 0.001 0.207 4.990 0.0018495631 111.2715 0.9999979022 B 101.714 7 3 101.715 7 2 0.208 0.001 0.209 4.988 0.0020483364 101.7145 0.9999993202 A 166.804 4 1 166.804 4 0 0.194 0.002 0.197 5.000 17:30 0.0011659766 166.804 0.9999993003 D 173.310 4 4 173.310 4 4 0.205 0.002 0.207 4.989 0.0011829451 173.31 0.9999982761 C 111.271 6 22 111.272 6 24 0.207 0.001 0.208 4.989 0.0018568353 111.2715 0.9999979121 B 101.715 7 1 101.714 7 2 0.208 0.001 0.209 4.988 0.0020434882 101.7145 0.9999993315 A 166.803 3 58 166.804 3 59 0.193 0.002 0.195 5.000 18:00 0.0011562804 166.8035 0.9999993032 D 173.308 4 3 173.309 4 4 0.205 0.002 0.207 4.988 0.001180521 173.3085 0.9999982985 C 111.270 6 21 111.269 6 20 0.205 0.001 0.206 4.989 0.001844715 111.2695 0.9999979121 B 101.713 7 2 101.712 7 1 0.208 0.001 0.209 4.986 0.0020434882 101.7125 0.9999993315 A 166.805 3 58 166.804 3 59 0.193 0.002 0.195 5.000 18:30 0.0011562804 166.8045 0.9999993032 D 173.308 4 4 173.308 4 3 0.205 0.002 0.207 4.988 0.001180521 173.308 0.9999982896 C 111.272 6 20 111.272 6 23 0.206 0.001 0.207 4.993 0.0018495631 111.272 0.999997917 B 101.714 7 0 101.713 7 2 0.208 0.001 0.208 4.991 0.0020410642 101.7135 注：a1、S1为盘左观测值，a2、S2为盘右观测值。假设A点高程为5.000Sheet2 Sheet3