{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2D Conformal"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"2D Conformal","index":0,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,3,4,4],[21,1,21,2],[21,3,21,4]]}
["Two-Dimension Conformal Transformation v1.1"]
[null,"J. Mahun 09 Sep 2020"]
[]
["Control Data:",null,"Two points known in both systems.",null,null,null,null,null,"mm"]
[null,"From Coordinates",null,"To Coordinates",null,null,null,null,"cm"]
["Point","Y","X","N","E",null,null,null,"meters"]
["A",2319.94,2848.28,99760.22,194683.5,null,null,null,"inches"]
["B",3561.68,5720.05,102367.61,196412.79999999999,null,null,null,"Survey Ft"]
["units","Survey Ft","units","Survey Ft",null,null,null,null,"Intl Ft"]
["Differences",{"$f":"B8-B7","v":1241.7399999999998},{"$f":"C8-C7","v":2871.77},{"$f":"D8-D7","v":2607.3899999999994},{"$f":"E8-E7","v":1729.2999999999884},null,null,null,"chains"]
[{"$f":"\"L \"&A7&\"-\"&A8","v":"L A-B"},{"$f":"SQRT(B10^2+C10^2)","v":3128.7347539380835},null,{"$f":"SQRT(D10^2+E10^2)","v":3128.7315484234114},null,null,null,null,"rods"]
[{"$f":"\"Az \"&A7&\"-\"&A8","v":"Az A-B"},{"$f":"inverseAz(B10,C10)","v":"66 36 59.64"},"d-m-s",{"$f":"inverseAz(D10,E10)","v":"33 33 12.75"},"d-m-s",null,null,null,"miles"]
[]
["Transformation parameters:"]
["Rotation, ρ",{"$f":"dmstodeg(B12)-dmstodeg(D12)","v":33.063025000000003},"decimal deg"]
[null,{"$f":"degtodms(B15)","v":"33 03 46.88"},"d-m-s"]
["Scale, S",{"$f":"D11/B11","v":0.9999989754597548},{"$f":"IF(B9=\"\",\"\",B9&\" / \"&D9)","v":"Survey Ft / Survey Ft"}]
["East Trans, TE",{"$f":"E7-B17*(+C7*COS(RADIANS(B15))-B7*SIN(RADIANS(B15)))","v":193562.10972955934},{"$f":"IF(D9=\"\",\"\",D9)","v":"Survey Ft"}]
["North Trans, TN",{"$f":"D7-B17*(+C7*SIN(RADIANS(B15))+B7*COS(RADIANS(B15)))","v":96262.03807628568},{"$f":"IF(D9=\"\",\"\",D9)","v":"Survey Ft"}]
[]
["Transform Coordinates:",null,"Enter points to transform."]
[null,"From System",null,"To System"]
["Point","Y","X","N","E"]
["C",897.03,3541.72,{"$f":"IF(B24=\"\",\"\",+$B$17*(+C24*SIN(RADIANS($B$15))+B24*COS(RADIANS($B$15)))+$B$19)","v":98946.035267539643},{"$f":"IF(C24=\"\",\"\",+$B$17*(+C24*COS(RADIANS($B$15))-B24*SIN(RADIANS($B$15)))+$B$18)","v":196040.9350773037}]
[null,1941.26,6160.31,{"$f":"IF(B25=\"\",\"\",+$B$17*(+C25*SIN(RADIANS($B$15))+B25*COS(RADIANS($B$15)))+$B$19)","v":101249.77294848931},{"$f":"IF(C25=\"\",\"\",+$B$17*(+C25*COS(RADIANS($B$15))-B25*SIN(RADIANS($B$15)))+$B$18)","v":197665.80623941394}]
[null,null,null,{"$f":"IF(B26=\"\",\"\",+$B$17*(+C26*SIN(RADIANS($B$15))+B26*COS(RADIANS($B$15)))+$B$19)","v":""},{"$f":"IF(C26=\"\",\"\",+$B$17*(+C26*COS(RADIANS($B$15))-B26*SIN(RADIANS($B$15)))+$B$18)","v":""}]
[null,null,null,{"$f":"IF(B27=\"\",\"\",+$B$17*(+C27*SIN(RADIANS($B$15))+B27*COS(RADIANS($B$15)))+$B$19)","v":""},{"$f":"IF(C27=\"\",\"\",+$B$17*(+C27*COS(RADIANS($B$15))-B27*SIN(RADIANS($B$15)))+$B$18)","v":""}]
[null,null,null,"",{"$f":"IF(C28=\"\",\"\",+$B$17*(+C28*COS(RADIANS($B$15))-B28*SIN(RADIANS($B$15)))+$B$18)","v":""}]