{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Traverse","Compass_Rule","Transit_Rule","Crandall_Method"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Traverse","index":0,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,4,6,5],[6,6,6,7],[1,2,1,5],[6,1,6,2],[19,1,19,3],[22,5,22,6],[22,3,22,4],[22,10,22,11],[22,12,22,13],[12,10,12,11],[22,7,22,8]]}
["Traverse Adjustment"]
[null,"Project:","Test Data"]
[]
[null,"Input Data"]
[null,null,null,null,"Distance scale:",1]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Coordiantes of \"&B9","v":"Coordiantes of A"}]
[null,"   Line",null,null,"Distance",null,"Unadjusted",null,null,"East",500]
[null,"From","To","    Azimuth","Unscaled","Scaled","Lat","Dep",null,"North",1000]
[null,"A","B","345 00 00",395.63,{"$f":"IF(E9<>\"\",E9*$F$5,\"\")","v":395.63},{"$f":"IF(E9,Lat(D9,F9),\"\")","v":382.14923465474408},{"$f":"IF(E9,dep(D9,F9),\"\")","v":-102.39657881391025}]
[null,"B","C","236 27 10",545.58000000000004,{"$f":"IF(E10<>\"\",E10*$F$5,\"\")","v":545.58000000000004},{"$f":"IF(E10,Lat(D10,F10),\"\")","v":-301.50064147916521},{"$f":"IF(E10,dep(D10,F10),\"\")","v":-454.70308948549268}]
[null,"C","D","138 51 38",366.21,366.21,{"$f":"IF(E11,Lat(D11,F11),\"\")","v":-275.79665236552472},240.92731402638827]
[null,"D","A","58 20 24",371.15,371.15,{"$f":"IF(E12,Lat(D12,F12),\"\")","v":194.80830077456187},315.91462208851271,null,"Closure Summary"]
[null,null,null,null,null,"",{"$f":"IF(E13,Lat(D13,F13),\"\")","v":""},"",null,null,"Closure Error"]
[null,null,null,null,null,"",{"$f":"IF(E14,Lat(D14,F14),\"\")","v":""},"",null,null,"Azimuth","Dist"]
[null,null,null,null,null,"",{"$f":"IF(E15,Lat(D15,F15),\"\")","v":""},"",null,null,{"$f":"IF(F20=0,\"\",InverseAz(G20,H20))","v":"217 10 58.94"},{"$f":"IF(AND(G20<>0,H20<>0),SQRT(G20^2+H20^2),\"\")","v":0.42645241206072459}]
[null,null,null,null,null,"",{"$f":"IF(E16,Lat(D16,F16),\"\")","v":""},"",null,null,"Precision:",{"$f":"IF(L15<>\"\",\"1/\"&TEXT(F20/L15,\"#,###,###\"),\"\")","v":"1/3,936"}]
[null,null,null,null,null,"",{"$f":"IF(E17,Lat(D17,F17),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(E18,Lat(D18,F18),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(E19,Lat(D19,F19),\"\")","v":""},""]
[null,null,null,null,"sums:",{"$f":"SUM(F9:F19)","v":1678.5700000000002},{"$f":"SUM(G9:G19)","v":-0.33975841538398299},{"$f":"SUM(H9:H19)","v":-0.25773218450200375}]
[]
[null,"Adjusted Values"]
[null,null,null,"Compass Rule",null,"Transit Rule",null,"Crandall Method",null,null,"Compass Rule",null,"Transit Rule",null,"Crandall Method"]
[null,null,"Line","Azimuth","Dist","Azimuth","Dist","Azimuth","Dist","Point","North","East","North","East","Northg","East"]
[null,null,{"$f":"IF(B9=\"\",\"\",B9&\"-\"&C9)","v":"A-B"},{"$f":"Compass_Rule!H5","v":"345 00 41.39"},{"$f":"Compass_Rule!I5","v":395.69163633160389},{"$f":"Transit_Rule!H5","v":"345 00 27.1"},{"$f":"Transit_Rule!I5","v":395.73252551096823},{"$f":"Crandall_Method!H5","v":"345 00 00"},{"$f":"Crandall_Method!I5","v":395.7424594157257},{"$f":"IF(B9=\"\",\"\",B9)","v":"A"},{"$f":"Compass_Rule!D22","v":1000},{"$f":"Compass_Rule!C22","v":500},{"$f":"Transit_Rule!D22","v":1000},{"$f":"Transit_Rule!C22","v":500},{"$f":"Crandall_Method!D22","v":1000},{"$f":"Crandall_Method!C22","v":500}]
[null,null,{"$f":"IF(B10=\"\",\"\",B10&\"-\"&C10)","v":"B-C"},{"$f":"Compass_Rule!H6","v":"236 27 27.29"},{"$f":"Compass_Rule!I6","v":545.44915899776367},{"$f":"Transit_Rule!H6","v":"236 27 15.98"},{"$f":"Transit_Rule!I6","v":545.44327553574533},{"$f":"Crandall_Method!H6","v":"236 27 10"},{"$f":"Crandall_Method!I6","v":545.35733162066879},"B",{"$f":"Compass_Rule!D23","v":1382.229313901888},{"$f":"Compass_Rule!C23","v":397.66416728792319},{"$f":"Transit_Rule!D23","v":1382.2617214428549},{"$f":"Transit_Rule!C23","v":397.6271126379923},{"$f":"Crandall_Method!D23","v":1382.2578621088028},{"$f":"Crandall_Method!C23","v":397.57431454749883}]
[null,null,"C-D",{"$f":"Compass_Rule!H7","v":"138 50 46.67"},{"$f":"Compass_Rule!I7","v":366.19118012107032},{"$f":"Transit_Rule!H7","v":"138 50 44.26"},{"$f":"Transit_Rule!I7","v":366.18554685074707},{"$f":"Crandall_Method!H7","v":"138 51 38"},{"$f":"Crandall_Method!I7","v":366.17061691844555},"C",{"$f":"Compass_Rule!D24","v":1080.839102965545},{"$f":"Compass_Rule!C24","v":-56.955152366570132},{"$f":"Transit_Rule!D24","v":1080.8498275934055},{"$f":"Transit_Rule!C24","v":-56.97077239146023},{"$f":"Crandall_Method!D24","v":1080.8802725362425},{"$f":"Crandall_Method!C24","v":-56.943196287726835}]
[null,null,"D-A",{"$f":"Compass_Rule!H8","v":"58 20 05.09"},{"$f":"Compass_Rule!I8","v":371.23793898599814},{"$f":"Transit_Rule!H8","v":"58 20 18.19"},{"$f":"Transit_Rule!I8","v":371.24231305271275},{"$f":"Crandall_Method!H8","v":"58 20 24"},{"$f":"Crandall_Method!I8","v":371.29940482252971},"D",{"$f":"Compass_Rule!D25","v":805.11657496140992},{"$f":"Compass_Rule!C25","v":184.02839053516232},{"$f":"Transit_Rule!D25","v":805.13435681031774},{"$f":"Transit_Rule!C25","v":184.01228488278247},{"$f":"Crandall_Method!D25","v":805.11327998899844},{"$f":"Crandall_Method!C25","v":183.95820785073647}]
[null,null,"",{"$f":"Compass_Rule!H9","v":""},{"$f":"Compass_Rule!I9","v":""},{"$f":"Transit_Rule!H9","v":""},{"$f":"Transit_Rule!I9","v":""},{"$f":"Crandall_Method!H9","v":""},{"$f":"Crandall_Method!I9","v":""},"",{"$f":"Compass_Rule!D26","v":1000},{"$f":"Compass_Rule!C26","v":500.00000000000006},{"$f":"Transit_Rule!D26","v":999.99999999999989},{"$f":"Transit_Rule!C26","v":500.00000000000006},{"$f":"Crandall_Method!D26","v":999.99999999999989},{"$f":"Crandall_Method!C26","v":500.00000000000006}]
[null,null,"",{"$f":"Compass_Rule!H10","v":""},{"$f":"Compass_Rule!I10","v":""},{"$f":"Transit_Rule!H10","v":""},{"$f":"Transit_Rule!I10","v":""},{"$f":"Crandall_Method!H10","v":""},{"$f":"Crandall_Method!I10","v":""},"",{"$f":"Compass_Rule!D27","v":""},{"$f":"Compass_Rule!C27","v":""},{"$f":"Transit_Rule!D27","v":""},{"$f":"Transit_Rule!C27","v":""},{"$f":"Crandall_Method!D27","v":""},{"$f":"Crandall_Method!C27","v":""}]
[null,null,"",{"$f":"Compass_Rule!H11","v":""},{"$f":"Compass_Rule!I11","v":""},{"$f":"Transit_Rule!H11","v":""},{"$f":"Transit_Rule!I11","v":""},{"$f":"Crandall_Method!H11","v":""},{"$f":"Crandall_Method!I11","v":""},"",{"$f":"Compass_Rule!D28","v":""},{"$f":"Compass_Rule!C28","v":""},{"$f":"Transit_Rule!D28","v":""},{"$f":"Transit_Rule!C28","v":""},{"$f":"Crandall_Method!D28","v":""},{"$f":"Crandall_Method!C28","v":""}]
[null,null,"",{"$f":"Compass_Rule!H12","v":""},{"$f":"Compass_Rule!I12","v":""},{"$f":"Transit_Rule!H12","v":""},{"$f":"Transit_Rule!I12","v":""},{"$f":"Crandall_Method!H12","v":""},{"$f":"Crandall_Method!I12","v":""},"",{"$f":"Compass_Rule!D29","v":""},{"$f":"Compass_Rule!C29","v":""},{"$f":"Transit_Rule!D29","v":""},{"$f":"Transit_Rule!C29","v":""},{"$f":"Crandall_Method!D29","v":""},{"$f":"Crandall_Method!C29","v":""}]
[null,null,"",{"$f":"Compass_Rule!H13","v":""},{"$f":"Compass_Rule!I13","v":""},{"$f":"Transit_Rule!H13","v":""},{"$f":"Transit_Rule!I13","v":""},{"$f":"Crandall_Method!H13","v":""},{"$f":"Crandall_Method!I13","v":""},"",{"$f":"Compass_Rule!D30","v":""},{"$f":"Compass_Rule!C30","v":""},{"$f":"Transit_Rule!D30","v":""},{"$f":"Transit_Rule!C30","v":""},{"$f":"Crandall_Method!D30","v":""},{"$f":"Crandall_Method!C30","v":""}]
[null,null,"",{"$f":"Compass_Rule!H14","v":""},{"$f":"Compass_Rule!I14","v":""},{"$f":"Transit_Rule!H14","v":""},{"$f":"Transit_Rule!I14","v":""},{"$f":"Crandall_Method!H14","v":""},{"$f":"Crandall_Method!I14","v":""},"",{"$f":"Compass_Rule!D31","v":""},{"$f":"Compass_Rule!C31","v":""},{"$f":"Transit_Rule!D31","v":""},{"$f":"Transit_Rule!C31","v":""},{"$f":"Crandall_Method!D31","v":""},{"$f":"Crandall_Method!C31","v":""}]
[]
[null,"Area By Adjustment"]
[null,null,"Rule","Area","Error"]
[null,null,"Comapss",{"$f":"Compass_Rule!F35","v":169348.01900166157},{"$f":"Compass_Rule!F36","v":60.845187917927007}]
[null,null,"Transit",{"$f":"Transit_Rule!F35","v":169356.89802151796},{"$f":"Transit_Rule!F36","v":60.848378068215588}]
[null,null,"Crandall",{"$f":"Crandall_Method!F35","v":169357.03860685683},{"$f":"Crandall_Method!F36","v":60.848428579236703}]

{"sheet":"Compass_Rule","index":1,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,3,2,4],[2,5,2,8],[19,4,19,5],[19,2,19,3]]}
["Compass Rule Adjustment"]
[]
[null,null,null,"Unadjusted",null,"Adjusted values"]
[null,"Line","Unadj Dist","Lat","Dep","Lat","Dep","Azimuth","Distance"]
[null,{"$f":"IF(Traverse!B9=\"\",\"\",Traverse!B9&\"-\"&Traverse!C9)","v":"A-B"},{"$f":"IF(Traverse!F9<>\"\",Traverse!F9,\"\")","v":395.63},{"$f":"Traverse!G9","v":382.14923465474408},{"$f":"Traverse!H9","v":-102.39657881391025},{"$f":"IF(C5<>\"\",+D5-($D$16*(C5/$C$16)),\"\")","v":382.22931390188802},{"$f":"IF(C5<>\"\",+E5-($E$16*(C5/$C$16)),\"\")","v":-102.33583271207684},{"$f":"IF(F5=\"\",\"\",InverseAz(F5,G5))","v":"345 00 41.39"},{"$f":"IF(C5<>\"\",SQRT(F5^2+G5^2),\"\")","v":395.69163633160389}]
[null,{"$f":"IF(Traverse!B10=\"\",\"\",Traverse!B10&\"-\"&Traverse!C10)","v":"B-C"},{"$f":"IF(Traverse!F10<>\"\",Traverse!F10,\"\")","v":545.58000000000004},{"$f":"Traverse!G10","v":-301.50064147916521},{"$f":"Traverse!H10","v":-454.70308948549268},{"$f":"IF(C6<>\"\",+D6-($D$16*(C6/$C$16)),\"\")","v":-301.39021093634295},{"$f":"IF(C6<>\"\",+E6-($E$16*(C6/$C$16)),\"\")","v":-454.61931965449332},{"$f":"IF(F6=\"\",\"\",InverseAz(F6,G6))","v":"236 27 27.29"},{"$f":"IF(C6<>\"\",SQRT(F6^2+G6^2),\"\")","v":545.44915899776367}]
[null,{"$f":"IF(Traverse!B11=\"\",\"\",Traverse!B11&\"-\"&Traverse!C11)","v":"C-D"},{"$f":"IF(Traverse!F11<>\"\",Traverse!F11,\"\")","v":366.21},{"$f":"Traverse!G11","v":-275.79665236552472},{"$f":"Traverse!H11","v":240.92731402638827},-275.72252800413509,240.98354290173245,"138 50 46.67",366.19118012107032]
[null,{"$f":"IF(Traverse!B12=\"\",\"\",Traverse!B12&\"-\"&Traverse!C12)","v":"D-A"},{"$f":"IF(Traverse!F12<>\"\",Traverse!F12,\"\")","v":371.15},{"$f":"Traverse!G12","v":194.80830077456187},{"$f":"Traverse!H12","v":315.91462208851271},194.88342503859005,315.97160946483774,"58 20 05.09",371.23793898599814]
[null,{"$f":"IF(Traverse!B13=\"\",\"\",Traverse!B13&\"-\"&Traverse!C13)","v":""},{"$f":"IF(Traverse!F13<>\"\",Traverse!F13,\"\")","v":""},{"$f":"Traverse!G13","v":""},{"$f":"Traverse!H13","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B14=\"\",\"\",Traverse!B14&\"-\"&Traverse!C14)","v":""},{"$f":"IF(Traverse!F14<>\"\",Traverse!F14,\"\")","v":""},{"$f":"Traverse!G14","v":""},{"$f":"Traverse!H14","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B15=\"\",\"\",Traverse!B15&\"-\"&Traverse!C15)","v":""},{"$f":"IF(Traverse!F15<>\"\",Traverse!F15,\"\")","v":""},{"$f":"Traverse!G15","v":""},{"$f":"Traverse!H15","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B16=\"\",\"\",Traverse!B16&\"-\"&Traverse!C16)","v":""},{"$f":"IF(Traverse!F16<>\"\",Traverse!F16,\"\")","v":""},{"$f":"Traverse!G16","v":""},{"$f":"Traverse!H16","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B17=\"\",\"\",Traverse!B17&\"-\"&Traverse!C17)","v":""},{"$f":"IF(Traverse!F17<>\"\",Traverse!F17,\"\")","v":""},{"$f":"Traverse!G17","v":""},{"$f":"Traverse!H17","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B18=\"\",\"\",Traverse!B18&\"-\"&Traverse!C18)","v":""},{"$f":"IF(Traverse!F18<>\"\",Traverse!F18,\"\")","v":""},{"$f":"Traverse!G18","v":""},{"$f":"Traverse!H18","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B19=\"\",\"\",Traverse!B19&\"-\"&Traverse!C19)","v":""},{"$f":"IF(Traverse!F19<>\"\",Traverse!F19,\"\")","v":""},{"$f":"Traverse!G19","v":""},{"$f":"Traverse!H19","v":""},"","","",""]
[null,null,{"$f":"SUM(C5:C15)","v":1678.5700000000002},{"$f":"SUM(D5:D15)","v":-0.33975841538398299},{"$f":"SUM(E5:E15)","v":-0.25773218450200375},{"$f":"SUM(F5:F15)","v":0},{"$f":"SUM(G5:G15)","v":0}]
[null,null,null,null,null,"Constants:"]
[null,null,null,null,null,{"$f":"IF(C16<>0,-D16/C16,\"\")","v":2.0240944100274815E-4},{"$f":"IF(C16<>0,-E16/C16,\"\")","v":1.5354270867583939E-4}]
[]
[null,null,"Coordinates",null,"Area Comps"]
[null,"Point","East","North","(/)","(\\)"]
[null,{"$f":"LEFT(B5,1)","v":"A"},{"$f":"Traverse!K7","v":500},{"$f":"Traverse!K8","v":1000},{"$f":"IF(C23=\"\",\"\",C23*D22)","v":397664.16728792316}]
[null,"B",{"$f":"IF(G5<>\"\",C22+G5,\"\")","v":397.66416728792319},{"$f":"IF(F5<>\"\",D22+F5,\"\")","v":1382.229313901888},-78725.081178821725,{"$f":"IF(D23=\"\",\"\",C22*D23)","v":691114.65695094399}]
[null,"C",-56.955152366570132,1080.839102965545,198905.08054621783,429810.98185301933]
[null,"D",184.02839053516232,805.11657496140992,402558.28748070501,-45855.537199778184]
[null,"",500.00000000000006,1000,"",184028.39053516233]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,null,"","",null,""]
[null,null,null,"sums:",{"$f":"SUM(E22:E32)","v":920402.45413602423},{"$f":"SUM(F22:F32)","v":1259098.4921393474}]
[null,null,null,null,"diff =",{"$f":"ABS(E33-F33)","v":338696.03800332313}]
[null,null,null,null,"Area =",{"$f":"F34/2","v":169348.01900166157}]
[null,null,null,null,"error =",{"$f":"IF(F35<0.01,\"0\",F35*Traverse!L15/Traverse!F20*SQRT(2))","v":60.845187917927007}]

{"sheet":"Transit_Rule","index":2,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,5,2,8],[19,4,19,5],[19,2,19,3],[2,3,2,4]]}
["Transit Rule Adjustment"]
[]
[null,null,null,"Unadjusted",null,"Adjusted values"]
[null,"Line","Unadj Dist","Lat","Dep","Lat","Dep","Azimuth","Distance"]
[null,{"$f":"IF(Traverse!B9=\"\",\"\",Traverse!B9&\"-\"&Traverse!C9)","v":"A-B"},{"$f":"IF(Traverse!F9<>\"\",Traverse!F9,\"\")","v":395.63},{"$f":"Traverse!G9","v":382.14923465474408},{"$f":"Traverse!H9","v":-102.39657881391025},{"$f":"IF(C5<>\"\",D5+ABS(D5)*$F$18,\"\")","v":382.26172144285493},{"$f":"IF(C5<>\"\",E5+ABS(E5)*$G$18,\"\")","v":-102.37288736200769},{"$f":"IF(F5=\"\",\"\",InverseAz(F5,G5))","v":"345 00 27.1"},{"$f":"IF(C5<>\"\",SQRT(F5^2+G5^2),\"\")","v":395.73252551096823}]
[null,{"$f":"IF(Traverse!B10=\"\",\"\",Traverse!B10&\"-\"&Traverse!C10)","v":"B-C"},{"$f":"IF(Traverse!F10<>\"\",Traverse!F10,\"\")","v":545.58000000000004},{"$f":"Traverse!G10","v":-301.50064147916521},{"$f":"Traverse!H10","v":-454.70308948549268},-301.41189384944931,-454.59788502945253,{"$f":"IF(F6=\"\",\"\",InverseAz(F6,G6))","v":"236 27 15.98"},{"$f":"IF(C6<>\"\",SQRT(F6^2+G6^2),\"\")","v":545.44327553574533}]
[null,{"$f":"IF(Traverse!B11=\"\",\"\",Traverse!B11&\"-\"&Traverse!C11)","v":"C-D"},{"$f":"IF(Traverse!F11<>\"\",Traverse!F11,\"\")","v":366.21},{"$f":"Traverse!G11","v":-275.79665236552472},{"$f":"Traverse!H11","v":240.92731402638827},-275.71547078308782,240.9830572742427,"138 50 44.26",366.18554685074707]
[null,{"$f":"IF(Traverse!B12=\"\",\"\",Traverse!B12&\"-\"&Traverse!C12)","v":"D-A"},{"$f":"IF(Traverse!F12<>\"\",Traverse!F12,\"\")","v":371.15},{"$f":"Traverse!G12","v":194.80830077456187},{"$f":"Traverse!H12","v":315.91462208851271},194.86564318968215,315.98771511721759,"58 20 18.19",371.24231305271275]
[null,{"$f":"IF(Traverse!B13=\"\",\"\",Traverse!B13&\"-\"&Traverse!C13)","v":""},{"$f":"IF(Traverse!F13<>\"\",Traverse!F13,\"\")","v":""},{"$f":"Traverse!G13","v":""},{"$f":"Traverse!H13","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B14=\"\",\"\",Traverse!B14&\"-\"&Traverse!C14)","v":""},{"$f":"IF(Traverse!F14<>\"\",Traverse!F14,\"\")","v":""},{"$f":"Traverse!G14","v":""},{"$f":"Traverse!H14","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B15=\"\",\"\",Traverse!B15&\"-\"&Traverse!C15)","v":""},{"$f":"IF(Traverse!F15<>\"\",Traverse!F15,\"\")","v":""},{"$f":"Traverse!G15","v":""},{"$f":"Traverse!H15","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B16=\"\",\"\",Traverse!B16&\"-\"&Traverse!C16)","v":""},{"$f":"IF(Traverse!F16<>\"\",Traverse!F16,\"\")","v":""},{"$f":"Traverse!G16","v":""},{"$f":"Traverse!H16","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B17=\"\",\"\",Traverse!B17&\"-\"&Traverse!C17)","v":""},{"$f":"IF(Traverse!F17<>\"\",Traverse!F17,\"\")","v":""},{"$f":"Traverse!G17","v":""},{"$f":"Traverse!H17","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B18=\"\",\"\",Traverse!B18&\"-\"&Traverse!C18)","v":""},{"$f":"IF(Traverse!F18<>\"\",Traverse!F18,\"\")","v":""},{"$f":"Traverse!G18","v":""},{"$f":"Traverse!H18","v":""},"","","",""]
[null,{"$f":"IF(Traverse!B19=\"\",\"\",Traverse!B19&\"-\"&Traverse!C19)","v":""},{"$f":"IF(Traverse!F19<>\"\",Traverse!F19,\"\")","v":""},{"$f":"Traverse!G19","v":""},{"$f":"Traverse!H19","v":""},"","","",""]
[null,null,{"$f":"SUM(C5:C15)","v":1678.5700000000002},{"$f":"SUM(D5:D15)","v":-0.33975841538398299},{"$f":"SUM(E5:E15)","v":-0.25773218450200375},{"$f":"SUM(F5:F15)","v":0},{"$f":"SUM(G5:G15)","v":0}]
[null,null,null,"Sum of absolute values",null,"Constants:"]
[null,null,null,{"$f":"SUMIF(D5:D15,\">0\")-SUMIF(D5:D15,\"<0\")","v":1154.2548292739957},{"$f":"SUMIF(E5:E15,\">0\")-SUMIF(E5:E15,\"<0\")","v":1113.941604414304},{"$f":"IF(C16<>0,-D16/D18,\"\")","v":2.9435303779294956E-4},{"$f":"IF(C16<>0,-E16/E18,\"\")","v":2.3136956504781592E-4}]
[]
[null,null,"Coordinates",null,"Area Comps"]
[null,"Point","East","North","(/)","(\\)"]
[null,{"$f":"LEFT(B5,1)","v":"A"},{"$f":"Traverse!K7","v":500},{"$f":"Traverse!K8","v":1000},{"$f":"IF(C23=\"\",\"\",C23*D22)","v":397627.11263799231}]
[null,"B",{"$f":"IF(G5<>\"\",C22+G5,\"\")","v":397.6271126379923},{"$f":"IF(F5<>\"\",D22+F5,\"\")","v":1382.2617214428549},-78748.51791774889,{"$f":"IF(D23=\"\",\"\",C22*D23)","v":691130.86072142748}]
[null,"C",-56.97077239146023,1080.8498275934055,198889.64639062405,429775.19614123763]
[null,"D",184.01228488278247,805.13435681031774,402567.17840515892,-45869.126186385336]
[null,"",500.00000000000006,999.99999999999989,"",184012.28488278243]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","",null,""]
[null,null,null,"sums:",{"$f":"SUM(E22:E32)","v":920335.41951602639},{"$f":"SUM(F22:F32)","v":1259049.2155590623}]
[null,null,null,null,"diff =",{"$f":"ABS(E33-F33)","v":338713.79604303592}]
[null,null,null,null,"Area =",{"$f":"F34/2","v":169356.89802151796}]
[null,null,null,null,"error =",{"$f":"IF(F35<0.01,\"0\",F35*Traverse!L15/Traverse!F20*SQRT(2))","v":60.848378068215588}]

{"sheet":"Crandall_Method","index":3,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[19,2,19,3],[2,3,2,4],[22,14,22,19],[23,14,23,15],[23,16,23,18],[23,19,24,19],[2,10,2,12],[2,5,2,8],[19,4,19,5]]}
["Crandall Method Adjustment"]
[]
[null,null,null,"Unadjusted",null,"Adjusted values",null,null,null,null,"Crandall intermmediate comps"]
[null,"Line","Scaled","Lat","Dep","Lat","Dep","Azimuth","Distance",null,"(Lat*Dep)/L","Lat2/L","Dep2/L","cLat","cDep"]
[null,{"$f":"IF(Traverse!B9=\"\",\"\",Traverse!B9&\"-\"&Traverse!C9)","v":"A-B"},{"$f":"IF(Traverse!F9<>\"\",Traverse!F9,\"\")","v":395.63},{"$f":"Traverse!G9","v":382.14923465474408},{"$f":"Traverse!H9","v":-102.39657881391025},{"$f":"IF(C5<>\"\",D5+N5,\"\")","v":382.2578621088029},{"$f":"IF(C5<>\"\",E5+O5,\"\")","v":-102.42568545250117},{"$f":"IF(C5<>\"\",InverseAz(F5,G5),\"\")","v":"345 00 00"},{"$f":"IF(C5<>\"\",SQRT(F5^2+G5^2),\"\")","v":395.7424594157257},null,{"$f":"IF(C5<>\"\",(D5*E5)/C5,\"\")","v":-98.90749999999997},{"$f":"IF(C5<>\"\",D5^2/C5,\"\")","v":369.12781524961872},{"$f":"IF(C5<>\"\",E5^2/C5,\"\")","v":26.50218475038125},{"$f":"IF(C5<>\"\",D5*(D5*$F$18+E5*$G$18)/C5,\"\")","v":0.10862745405883605},{"$f":"IF(C5<>\"\",E5*(D5*$F$18+E5*$G$18)/C5,\"\")","v":-2.9106638590913989E-2}]
[null,{"$f":"IF(Traverse!B10=\"\",\"\",Traverse!B10&\"-\"&Traverse!C10)","v":"B-C"},{"$f":"IF(Traverse!F10<>\"\",Traverse!F10,\"\")","v":545.58000000000004},{"$f":"Traverse!G10","v":-301.50064147916521},{"$f":"Traverse!H10","v":-454.70308948549268},{"$f":"IF(C6<>\"\",D6+N6,\"\")","v":-301.37758957256028},{"$f":"IF(C6<>\"\",E6+O6,\"\")","v":-454.51751083522566},"236 27 10",{"$f":"IF(C6<>\"\",SQRT(F6^2+G6^2),\"\")","v":545.35733162066879},null,{"$f":"IF(C6<>\"\",(D6*E6)/C6,\"\")","v":251.27987309365136},{"$f":"IF(C6<>\"\",D6^2/C6,\"\")","v":166.61651235812917},378.96348764187098,0.12305190660492707,0.18557865026700823]
[null,{"$f":"IF(Traverse!B11=\"\",\"\",Traverse!B11&\"-\"&Traverse!C11)","v":"C-D"},{"$f":"IF(Traverse!F11<>\"\",Traverse!F11,\"\")","v":366.21},{"$f":"Traverse!G11","v":-275.79665236552472},{"$f":"Traverse!H11","v":240.92731402638827},-275.76699254724406,240.90140413846331,"138 51 38",366.17061691844555,null,-181.44492687773524,207.70539705641599,158.50460294358405,2.9659818280656752E-2,-2.5909887924958186E-2]
[null,{"$f":"IF(Traverse!B12=\"\",\"\",Traverse!B12&\"-\"&Traverse!C12)","v":"D-A"},{"$f":"IF(Traverse!F12<>\"\",Traverse!F12,\"\")","v":371.15},{"$f":"Traverse!G12","v":194.80830077456187},{"$f":"Traverse!H12","v":315.91462208851271},194.88672001100144,316.04179214926359,"58 20 24",371.29940482252971,null,165.81649122699994,102.25050262878125,268.89949737121867,7.8419236439563236E-2,0.12717006075086773]
[null,{"$f":"IF(Traverse!B13=\"\",\"\",Traverse!B13&\"-\"&Traverse!C13)","v":""},{"$f":"IF(Traverse!F13<>\"\",Traverse!F13,\"\")","v":""},{"$f":"Traverse!G13","v":""},{"$f":"Traverse!H13","v":""},"","","","",null,"","","","",""]
[null,{"$f":"IF(Traverse!B14=\"\",\"\",Traverse!B14&\"-\"&Traverse!C14)","v":""},{"$f":"IF(Traverse!F14<>\"\",Traverse!F14,\"\")","v":""},{"$f":"Traverse!G14","v":""},{"$f":"Traverse!H14","v":""},"","","","",null,"","","","",""]
[null,{"$f":"IF(Traverse!B15=\"\",\"\",Traverse!B15&\"-\"&Traverse!C15)","v":""},{"$f":"IF(Traverse!F15<>\"\",Traverse!F15,\"\")","v":""},{"$f":"Traverse!G15","v":""},{"$f":"Traverse!H15","v":""},"","","","",null,"","","","",""]
[null,{"$f":"IF(Traverse!B16=\"\",\"\",Traverse!B16&\"-\"&Traverse!C16)","v":""},{"$f":"IF(Traverse!F16<>\"\",Traverse!F16,\"\")","v":""},{"$f":"Traverse!G16","v":""},{"$f":"Traverse!H16","v":""},"","","","",null,"","","","",""]
[null,{"$f":"IF(Traverse!B17=\"\",\"\",Traverse!B17&\"-\"&Traverse!C17)","v":""},{"$f":"IF(Traverse!F17<>\"\",Traverse!F17,\"\")","v":""},{"$f":"Traverse!G17","v":""},{"$f":"Traverse!H17","v":""},"","","","",null,"","","","",""]
[null,{"$f":"IF(Traverse!B18=\"\",\"\",Traverse!B18&\"-\"&Traverse!C18)","v":""},{"$f":"IF(Traverse!F18<>\"\",Traverse!F18,\"\")","v":""},{"$f":"Traverse!G18","v":""},{"$f":"Traverse!H18","v":""},"","","","",null,"","","","",""]
[null,{"$f":"IF(Traverse!B19=\"\",\"\",Traverse!B19&\"-\"&Traverse!C19)","v":""},{"$f":"IF(Traverse!F19<>\"\",Traverse!F19,\"\")","v":""},{"$f":"Traverse!G19","v":""},{"$f":"Traverse!H19","v":""},"","","","",null,"","","","",""]
[null,"sums:",{"$f":"SUM(C5:C15)","v":1678.5700000000002},{"$f":"SUM(D5:D15)","v":-0.33975841538398299},{"$f":"SUM(E5:E15)","v":-0.25773218450200375},{"$f":"SUM(F5:F15)","v":0},{"$f":"SUM(G5:G15)","v":0},null,null,null,{"$f":"SUM(K5:K15)","v":136.74393744291609},845.7002272929451,832.86977270705495]
[null,null,null,null,"Constants","k1","k2"]
[null,null,null,null,null,{"$f":"IF(C16<>0,(E16*K16-D16*M16)/(L16*M16-K16^2),\"\")","v":3.6130366487893229E-4},{"$f":"IF(C16<>0,(D16*K16-E16*L16)/(L16*M16-K16^2),\"\")","v":2.5013045926350027E-4}]
[]
[null,null,"Coordinates",null,"Area Comps"]
[null,"Point","East","North","(/)","(\\)"]
[null,{"$f":"LEFT(B5,1)","v":"A"},{"$f":"Traverse!K7","v":500},{"$f":"Traverse!K8","v":1000},{"$f":"IF(C23=\"\",\"\",C23*D22)","v":397574.31454749883}]
[null,"B",{"$f":"IF(G5<>\"\",C22+G5,\"\")","v":397.57431454749883},{"$f":"IF(F5<>\"\",D22+F5,\"\")","v":1382.2578621088028},-78710.180762315213,{"$f":"IF(D23=\"\",\"\",C22*D23)","v":691128.93105440144}]
[null,"C",-56.943196287726835,1080.8802725362425,198836.79783698279,429730.23346151033]
[null,"D",183.95820785073647,805.11327998899844,402556.63999449927,-45845.723536269114]
[null,"",500.00000000000006,999.99999999999989,"",183958.20785073645]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","","",""]
[null,"","","",null,""]
[null,null,null,"sums:",{"$f":"SUM(E22:E32)","v":920257.57161666569},{"$f":"SUM(F22:F32)","v":1258971.6488303794}]
[null,null,null,null,"diff =",{"$f":"ABS(E33-F33)","v":338714.07721371367}]
[null,null,null,null,"Area =",{"$f":"F34/2","v":169357.03860685683}]
[null,null,null,null,"error =",{"$f":"IF(F35<0.01,\"0\",F35*Traverse!L15/Traverse!F20*SQRT(2))","v":60.848428579236703}]