{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Comps","Wis_SPC","Wis_UTM","WisCRS_Conic","WisCRS_Cylindric","WCCS_Conic","WCCS_Cylindric","GRS80_&_Units"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":13,"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":"Comps","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Conversion Computations"]
[null,null,"Select from"]
[null,null,"dropdowns","Enter values to convert in the colored cells"]
[null,"Units","Survey Ft"]
[null,null,null,"Lat (DD.MMSSss)","Long (DD.MMSSss)",{"$f":" \"North (\"&C4&\")\"","v":"North (Survey Ft)"},{"$f":" \"East (\"&C4&\")\"","v":"East (Survey Ft)"},"Convergence","Grid Scale"]
[null,"State Plane","Central",44.15,88.46,{"$f":"Wis_SPC!C9","v":154354.5609293282},{"$f":"Wis_SPC!C10","v":2291664.9445946193},{"$f":"Wis_SPC!C11","v":"+0°52'12.760\""},{"$f":"Wis_SPC!C12","v":1}]
[null,null,null,{"$f":"Wis_SPC!F9","v":"+44°38'38.974204\""},{"$f":"Wis_SPC!F10","v":"+88°20'31.079858\""},300000,2400000,{"$f":"Wis_SPC!F11","v":"+1°10'11.530\""},{"$f":"Wis_SPC!F12","v":0.99994886269251371}]
[]
[null,"UTM / WTM","UTM 16N",44.15,88.46,{"$f":"Wis_UTM!C9","v":16079882.525738711},{"$f":"Wis_UTM!C10","v":1177670.0541070623},{"$f":"Wis_UTM!C11","v":"-1°13'58.677\""},{"$f":"Wis_UTM!C12","v":0.99984466512759351}]
[null,null,null,{"$f":"Wis_UTM!F9","v":"+13°46'16.364963\""},{"$f":"Wis_UTM!F10","v":"+89°39'03.059568\""},5000000,700000,{"$f":"Wis_UTM!F11","v":"-0°37'53.242\""},{"$f":"Wis_UTM!F12","v":1.0006164609363011}]
[]
[null,"WCCS Conic","Sawyer",45.4,90.43,{"$f":"WCCS_Conic!C9","v":311237.58245743066},{"$f":"WCCS_Conic!C10","v":813272.65383375448},{"$f":"WCCS_Conic!C11","v":"+0°17'14.104\""},{"$f":"WCCS_Conic!C12","v":1.000003311735}]
[null,"See Map",null,{"$f":"WCCS_Conic!F9","v":"+45°20'58.649597\""},{"$f":"WCCS_Conic!F10","v":"+92°48'44.722434\""},200000,275000,{"$f":"WCCS_Conic!F11","v":"-1°13'03.969\""},{"$f":"WCCS_Conic!F12","v":1.0000409025282542}]
[]
[null,"WCCS Cylindric","Polk",45.14,92.13,{"$f":"WCCS_Cylindric!C9","v":208919.2567664893},{"$f":"WCCS_Cylindric!C10","v":572350.9902556506},{"$f":"WCCS_Cylindric!C11","v":"+0°17'44.980\""},{"$f":"WCCS_Cylindric!C12","v":1.0000131574110278}]
[null,"See Map",null,{"$f":"WCCS_Cylindric!F9","v":"+44°50'26.723394\""},{"$f":"WCCS_Cylindric!F10","v":"+92°10'52.891669\""},65825.648000000001,582246.76899999997,{"$f":"WCCS_Cylindric!F11","v":"+0°19'07.349\""},{"$f":"WCCS_Cylindric!F12","v":1.0000156964067528}]
[]
[null,"WisCRS Conic","Pierce",44.35,92.11,{"$f":"WisCRS_Conic!C9","v":263007.19602946058},{"$f":"WisCRS_Conic!C10","v":561580.48306150141},{"$f":"WisCRS_Conic!C11","v":"+0°01'52.416\""},{"$f":"WisCRS_Conic!C37","v":1.0000367210009866}]
[null,"See Map",null,{"$f":"WisCRS_Conic!F9","v":"+44°10'51.897493\""},{"$f":"WisCRS_Conic!F10","v":"+93°21'53.364178\""},118430.0705,251695.2414,{"$f":"WisCRS_Conic!F11","v":"-0°47'56.006\""},{"$f":"WisCRS_Conic!G46","v":1.0000676493710769}]
[]
[null,"WisCRS Cylindric","Polk",45.14,92.13,{"$f":"WisCRS_Cylindric!C9","v":208919.26211938306},{"$f":"WisCRS_Cylindric!C10","v":572350.99525446212},{"$f":"WisCRS_Cylindric!C11","v":"+0°17'44.980\""},{"$f":"WisCRS_Cylindric!C12","v":1.0000565428837715}]
[null,"See Map",null,{"$f":"WisCRS_Cylindric!F9","v":"+44°59'05.708779\""},{"$f":"WisCRS_Cylindric!F10","v":"+91°31'54.973118\""},120000,750000,{"$f":"WisCRS_Cylindric!F11","v":"+0°46'43.134\""},{"$f":"WisCRS_Cylindric!F12","v":1.0001361314078705}]

{"sheet":"Wis_SPC","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Wis SPC -  Lambert Conic"]
[]
[null,"Units",{"$f":"Comps!C4","v":"Survey Ft"},null,{"$f":"VLOOKUP($C$3,Units,3,FALSE)","v":"survey feet"}]
[null,"Zone",{"$f":"Comps!C6","v":"Central"},null,{"$f":"HLOOKUP($C$4,ZoneInfo,2,FALSE)&\" Zone\"","v":"Central Zone"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Comps!D6","v":44.15},"d.ms","N",{"$f":"Comps!F7","v":300000},{"$f":"E3","v":"survey feet"}]
[null,"Long (l)",{"$f":"Comps!E6","v":88.46},"d.ms","E",{"$f":"Comps!G7","v":2400000},{"$f":"E3","v":"survey feet"}]
[null,"N",{"$f":"C41","v":154354.5609293282},{"$f":"E3","v":"survey feet"},"Lat (f)",{"$f":"H43","v":"+44°38'38.974204\""}]
[null,"E",{"$f":"C42","v":2291664.9445946193},{"$f":"E3","v":"survey feet"},"Long (l)",{"$f":"H42","v":"+88°20'31.079858\""}]
[null,"g",{"$f":"C39","v":"+0°52'12.760\""},null,"g",{"$f":"H44","v":"+1°10'11.530\""}]
[null,"k",{"$f":"C40","v":1},null,"k",{"$f":"H45","v":0.99994886269251371}]
[]
["Zone Parameters",null,null,null,null,null,null,null,null,"Wis SPC Parameters"]
[null,"Code",{"$f":"HLOOKUP($C$4,ZoneInfo,3,FALSE)","v":4802},null,null,null,null,null,null,null,"Zone","North","Central","South"]
["fs","Std Par S",{"$f":"HLOOKUP($C$4,ZoneInfo,4,FALSE)","v":44.15},{"$f":"RADIANS(DMStoDD(C16))","v":0.77230819400749073},"radians",null,"Ellipsoid",null,null,null,"Name","North","Central","South"]
["fn","Std Par N",{"$f":"HLOOKUP($C$4,[0]!ZoneInfo,5,FALSE)","v":45.3},{"$f":"RADIANS(DMStoDD(C17))","v":0.79412480965741983},"radians",null,"a",{"$f":"'GRS80_&_Units'!C5*VLOOKUP($C$3,Units,2,FALSE)","v":20925604.474166665},{"$f":"$E$3","v":"survey feet"},null,"Code",4801,4802,4803]
["lo","Origin Long",{"$f":"HLOOKUP($C$4,ZoneInfo,6,FALSE)","v":90},{"$f":"RADIANS(DMStoDD(C18))","v":1.5707963267948966},"radians",null,"b",{"$f":"'GRS80_&_Units'!C6*VLOOKUP($C$3,Units,2,FALSE)","v":20855444.883975454},{"$f":"$E$3","v":"survey feet"},"fs","Std Par S",45.34,44.15,42.44,"d.ms"]
["fb","Origin Lat",{"$f":"HLOOKUP($C$4,ZoneInfo,7,FALSE)","v":43.5},{"$f":"RADIANS(DMStoDD(C19))","v":0.76503598879084778},"radians",null,"f",{"$f":"'GRS80_&_Units'!C7","v":3.3528106811836675E-3},null,"fn","Std Par N",46.46,45.3,44.04,"d.ms"]
["Nb","Origin N",{"$f":"HLOOKUP($C$4,ZoneInfo,8,FALSE)","v":0},{"$f":"C20*VLOOKUP($C$3,Units,2,FALSE)","v":0},{"$f":"$E$3","v":"survey feet"},null,"e",{"$f":"SQRT('GRS80_&_Units'!C8)","v":8.1819191042832778E-2},null,"lo","Origin Long",{"$f":"90","v":90},90,90,"d.ms"]
["Eo","Origin E",{"$f":"HLOOKUP($C$4,ZoneInfo,9,FALSE)","v":600000},{"$f":"C21*VLOOKUP($C$3,Units,2,FALSE)","v":1968500},{"$f":"$E$3","v":"survey feet"},null,"e'",{"$f":"SQRT('GRS80_&_Units'!C9)","v":8.209443815193436E-2},null,"fb","Origin Lat",45.1,43.5,42,"d.ms"]
[null,null,null,null,null,null,null,null,null,"Nb","Origin N",0,0,0,"meters"]
["Zone Constants",null,null,null,null,null,null,null,null,"Eo","Origin E",600000,600000,600000,"meters"]
[null,null,"Q","W",null,null,"fo",{"$f":"ASIN((LN(D26*COS(D16)/(D25*COS(D17))))/(C26-C25))","v":0.78323651546388784},"radians"]
[null,"South (Qs)",{"$f":"Q(H20,D16)","v":0.85830480848428481},{"$f":"W(H20,D16)","v":0.99836888433507109},null,null,null,{"$f":"FormatAngle(DDtoDMS(DEGREES(H24)),3)","v":"+44°52'34.128\""},"Central Latitude"]
[null,"North (Qn)",{"$f":"Q(H20,D17)","v":0.88898905050244681},{"$f":"W(H20,D17)","v":0.9982957444906021},null,null,"K",{"$f":"(H17*COS(D16)*EXP(C25*SIN(H24)))/(D25*SIN(H24))","v":38989492.133731738},{"$f":"$E$3","v":"survey feet"}]
[null,"Grid Origin (Qb)",{"$f":"Q(H20,D19)","v":0.84822319073894925},null,null,null,"Rb",{"$f":"H26/(EXP(C27*SIN(H24)))","v":21430298.322417196},{"$f":"$E$3","v":"survey feet"}]
[null,"Central (Qo)",{"$f":"Q(H20,H24)","v":0.87359119641713889},{"$f":"W(H20,H24)","v":0.99833224972261225},null,null,"Ro",{"$f":"H26/(EXP(C28*SIN(H24)))","v":21050128.373484634},{"$f":"$E$3","v":"survey feet"}]
[null,null,null,null,null,null,"ko",{"$f":"(D28*TAN(H24)*H28)/(H17)","v":0.99994070490210196}]
[null,null,null,null,null,null,"No",{"$f":"H27+D20-H28","v":380169.94893256202},{"$f":"$E$3","v":"survey feet"}]
[]
[]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"C7","v":44.15},{"$f":"RADIANS(DMStoDD(C34))","v":0.77230819400749073},"radians",null,"N",{"$f":"F7","v":300000},{"$f":"$E$3","v":"survey feet"}]
[null,"Long (l)",{"$f":"C8","v":88.46},{"$f":"RADIANS(DMStoDD(C35))","v":1.5492705993536329},"radians",null,"E",{"$f":"F8","v":2400000},{"$f":"$E$3","v":"survey feet"}]
[null,"Q",{"$f":"Q(H20,D34)","v":0.85830480848428481},null,null,null,"R'",{"$f":"H27-H34+D20","v":21130298.322417196},{"$f":"$E$3","v":"survey feet"}]
[null,"R",{"$f":"H26/(EXP(C36*SIN(H24)))","v":21278397.931315444},null,null,null,"E'",{"$f":"H35-D21","v":431500},{"$f":"$E$3","v":"survey feet"}]
[null,"g",{"$f":"(D18-D35)*SIN(H24)","v":1.5188049890688884E-2},"radians",null,null,"g",{"$f":"ATAN(H37/H36)","v":2.0418075880743163E-2},"radians"]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C38)),3)","v":"+0°52'12.760\""},null,null,null,"R",{"$f":"SQRT(H36^2+H37^2)","v":21134703.675338034}]
[null,"k",{"$f":"SQRT((1-H20^2*SIN(D34)^2))*(C37*SIN(H24))/(H17*COS(D34))","v":1},null,null,null,"Q",{"$f":"(LN(H26/H39))/(SIN(H24))","v":0.86790824908020303}]
[null,"N",{"$f":"H27+D20-C37*COS(C38)","v":154354.5609293282},{"$f":"$E$3","v":"survey feet"},null,null,"Long",{"$f":"D18-(H38/SIN(H24))","v":1.5418581853318925},"radians"]
[null,"E",{"$f":"D21+C37*SIN(C38)","v":2291664.9445946193},{"$f":"$E$3","v":"survey feet"},null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H41)),6)","v":"+88°20'31.079858\""}]
[null,null,null,null,null,null,"Lat (f)",{"$f":"H58","v":"+44°38'38.974204\""}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H38)),3)","v":"+1°10'11.530\""}]
[null,null,null,null,null,null,"k",{"$f":"SQRT(1-H20^2*SIN(I52)^2)*(H39*SIN(H24)/(H17*COS(I52)))","v":0.99994886269251371}]
[]
[null,null,null,null,null,null,"Latitude comps - iterative"]
[null,null,null,null,null,null,null,"f","f (radians)","f1","f2","(-f1/f2)"]
[null,null,null,null,null,null,"initial",{"$f":"(EXP(2*H40)-1)/(EXP(2*H40)+1)","v":0.70030980607575222},{"$f":"ASIN(H49)","v":0.77583140417574037},{"$f":"Q($H$20,I49)-$H$40","v":-4.6932807290374079E-3},{"$f":"1/(1-H49^2)-$H$20^2/(1-$H$20^2*H49^2)","v":1.9557372168547864},{"$f":"-J49/K49","v":2.3997501753252591E-3}]
[null,null,null,null,null,null,1,{"$f":"H49+L49","v":0.70270955625107745},{"$f":"ASIN(H50)","v":0.77919872500309451},{"$f":"Q($H$20,I50)-$H$40","v":1.5618149545648663E-5},{"$f":"1/(1-H50^2)-$H$20^2/(1-$H$20^2*H50^2)","v":1.9687899821249708},{"$f":"-J50/K50","v":-7.9328672369571651E-6}]
[null,null,null,null,null,null,2,{"$f":"H50+L50","v":0.70270162338384046},{"$f":"ASIN(H51)","v":0.77918757520422044},{"$f":"Q($H$20,I51)-$H$40","v":1.7257573148299343E-10},{"$f":"1/(1-H51^2)-$H$20^2/(1-$H$20^2*H51^2)","v":1.9687464734398121},{"$f":"-J51/K51","v":-8.7657671422500389E-11}]
[null,null,null,null,null,null,3,{"$f":"H51+L51","v":0.7027016232961828},{"$f":"ASIN(H52)","v":0.77918757508101655}]
[]
[null,null,null,null,null,null,null,"f (D-M-S)"]
[null,null,null,null,null,null,"initial",{"$f":"FormatAngle(DDtoDMS(DEGREES(I49)),6)","v":"+44°27'06.714263\""}]
[null,null,null,null,null,null,1,{"$f":"FormatAngle(DDtoDMS(DEGREES(I50)),6)","v":"+44°38'41.274041\""}]
[null,null,null,null,null,null,2,{"$f":"FormatAngle(DDtoDMS(DEGREES(I51)),6)","v":"+44°38'38.974230\""}]
[null,null,null,null,null,null,3,{"$f":"FormatAngle(DDtoDMS(DEGREES(I52)),6)","v":"+44°38'38.974204\""},"final Lat"]

{"sheet":"Wis_UTM","index":2,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Transverse Mercator Cylindric"]
[]
[null,"Units",{"$f":"Comps!C4","v":"Survey Ft"},"M, F, S",{"$f":"VLOOKUP($C$3,Units,3,FALSE)","v":"survey feet"}]
[null,"Zone",{"$f":"Comps!C9","v":"UTM 16N"},"15, 16, W",{"$f":"HLOOKUP($C$4,TMZoneInfo,2,FALSE)&\" Zone\"","v":"UTM 16N Zone"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Comps!D9","v":44.15},"d.ms","N",{"$f":"Comps!F10","v":5000000},{"$f":"E3","v":"survey feet"}]
[null,"Long (l)",{"$f":"Comps!E9","v":88.46},"d.ms","E",{"$f":"Comps!G10","v":700000},{"$f":"E3","v":"survey feet"}]
[null,"N",{"$f":"C54","v":16079882.525738711},{"$f":"E3","v":"survey feet"},"Lat (f)",{"$f":"H56","v":"+13°46'16.364963\""}]
[null,"E",{"$f":"C55","v":1177670.0541070623},{"$f":"E3","v":"survey feet"},"Long (l)",{"$f":"H57","v":"+89°39'03.059568\""}]
[null,"g",{"$f":"C63","v":"-1°13'58.677\""},null,"g",{"$f":"H65","v":"-0°37'53.242\""}]
[null,"k",{"$f":"C64","v":0.99984466512759351},null,"k",{"$f":"H66","v":1.0006164609363011}]
[]
["Zone Parameters",null,null,null,null,null,null,null,null,null,"Wis TM Parameters"]
[null,"Code",{"$f":"HLOOKUP($C$4,TMZoneInfo,1,FALSE)","v":"UTM 16N"},null,null,null,null,null,null,null,null,"Code","UTM 15N","UTM 16N","WTM"]
[null,"Name",{"$f":"HLOOKUP($C$4,TMZoneInfo,2,FALSE)","v":"UTM 16N"},null,null,null,"Ellipsoid",null,null,null,null,"Name","UTM 15N","UTM 16N","WTM"]
["lo","Cen Mer",{"$f":"HLOOKUP($C$4,TMZoneInfo,3,FALSE)","v":87},{"$f":"RADIANS(DMStoDD(C17))","v":1.5184364492350666},"radians",null,"a",{"$f":"'GRS80_&_Units'!C5*VLOOKUP($C$3,Units,2,FALSE)","v":20925604.474166665},{"$f":"$E$3","v":"survey feet"},null,"lo","Cen Mer",93,87,90,"d.ms"]
["ko","Scale- 1:",{"$f":"HLOOKUP($C$4,TMZoneInfo,4,FALSE)","v":2500},{"$f":"1-1/C18","v":0.99960000000000004},null,null,"b",{"$f":"'GRS80_&_Units'!C6*VLOOKUP($C$3,Units,2,FALSE)","v":20855444.883975454},{"$f":"$E$3","v":"survey feet"},null,null,"Scale- 1:",2500,2500,2500]
["lo","Origin Long",{"$f":"HLOOKUP($C$4,TMZoneInfo,5,FALSE)","v":87},{"$f":"RADIANS(DMStoDD(C19))","v":1.5184364492350666},"radians",null,"f",{"$f":"'GRS80_&_Units'!C7","v":3.3528106811836675E-3},null,null,"lo","Origin Long",93,87,90,"d.ms"]
["fo","Origin Lat",{"$f":"HLOOKUP($C$4,TMZoneInfo,6,FALSE)","v":0},{"$f":"RADIANS(DMStoDD(C20))","v":0},"radians",null,"e",{"$f":"SQRT('GRS80_&_Units'!C8)","v":8.1819191042832778E-2},null,null,"fo","Origin Lat",0,0,0,"d.ms"]
["No","Origin N",{"$f":"HLOOKUP($C$4,TMZoneInfo,7,FALSE)","v":0},{"$f":"C21*VLOOKUP($C$3,Units,2,FALSE)","v":0},{"$f":"$E$3","v":"survey feet"},null,"e'",{"$f":"SQRT('GRS80_&_Units'!C9)","v":8.209443815193436E-2},null,null,"No","Origin N",0,0,-4480000,"meters"]
["Eo","Origin E",{"$f":"HLOOKUP($C$4,TMZoneInfo,8,FALSE)","v":500000},{"$f":"C22*VLOOKUP($C$3,Units,2,FALSE)","v":1640416.6666666667},{"$f":"$E$3","v":"survey feet"},null,null,null,null,null,"Eo","Origin E",500000,500000,520000,"meters"]
[]
["Zone Constants"]
[null,"n",{"$f":"(H17-H18)/(H17+H18)","v":1.6792203946294406E-3}]
[null,"r",{"$f":"H17*(1-C25)*(1-C25^2)*(1+9*C25^2/4+225*C25^4/64)","v":20890539.405750498},{"$f":"$E$3","v":"survey feet"}]
[null,"u2",{"$f":"-3*C25/2+9*C25^3/16","v":-2.5188279284875425E-3},null,"v2",{"$f":"3*C25/2-27*C25^3/32","v":2.5188265967592332E-3}]
[null,"u4",{"$f":"15*C25^2/16-15*C25^4/32","v":2.643541085771844E-6},null,"v4",{"$f":"21*C25^2/16-55*C25^4/32","v":3.7009490719670861E-6}]
[null,"u6",{"$f":"-35*C25^3/48","v":-3.4526289497048255E-9},null,"v6",{"$f":"151*C25^3/96","v":7.4478138772204098E-9}]
[null,"u8",{"$f":"315*C25^4/512","v":4.8918304243960608E-12},null,"v8",{"$f":"1097*C25^4/512","v":1.7035993573214219E-11}]
[null,"U0",{"$f":"2*(C27-2*C28+3*C29-4*C30)","v":-5.0482507762265134E-3},null,"V0",{"$f":"2*(F27-2*F28+3*F29-4*F30)","v":5.0228939478259129E-3}]
[null,"U2",{"$f":"8*(C28-4*C29+10*C30)","v":2.1259204158999257E-5},null,"V2",{"$f":"8*(F28-4*F29+10*F30)","v":2.9370625411151495E-5}]
[null,"U4",{"$f":"32*(C29-6*C30)","v":-1.1142335783203845E-7},null,"V4",{"$f":"32*(F29-6*F30)","v":2.3505913330499599E-7}]
[null,"U6",{"$f":"128*C30","v":6.2615429432269579E-10},null,"V6",{"$f":"128*F30","v":2.18060717737142E-9}]
[null,"wo",{"$f":"D20+SIN(D20)*COS(D20)*(C31+C32*COS(D20)^2+C33*COS(D20)^4+C34*COS(D20)^6)","v":0}]
[null,"So",{"$f":"D18*C35*C26","v":0},{"$f":"$E$3","v":"survey feet"}]
[]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"DMStoDD(C7)","v":44.249999999999993},{"$f":"RADIANS(C39)","v":0.77230819400749073},"radians",null,"N",{"$f":"F7","v":5000000},{"$f":"$E$3","v":"survey feet"}]
[null,"Long (l)",{"$f":"DMStoDD(C8)","v":88.766666666666652},{"$f":"RADIANS(C40)","v":1.5492705993536329},"radians",null,"E",{"$f":"F8","v":700000},{"$f":"$E$3","v":"survey feet"}]
[null,"L",{"$f":"(D40-D17)*COS(D39)","v":2.2086561653776558E-2},null,null,null,"w",{"$f":"(H39-D21+C36)/(D18*C26)","v":0.2394385660976871}]
[null,"w",{"$f":"D39+SIN(D39)*COS(D39)*(C31+C32*COS(D39)^2+C33*COS(D39)^4+C34*COS(D39)^6)","v":0.76979037101215009},null,null,null,"ff",{"$f":"H41+(SIN(H41)*COS(H41))*(F31+F32*COS(H41)^2+F33*COS(H41)^4+F34*COS(H41)^6)","v":0.2406022327469767}]
[null,"S",{"$f":"D18*C42*C26","v":16074903.545364698},{"$f":"$E$3","v":"survey feet"},null,null,"tf",{"$f":"TAN(H42)","v":0.2453550950922268}]
[null,"t",{"$f":"TAN(D39)","v":0.9741568709216808},null,null,null,"hf2",{"$f":"H21^2*COS(H42)^2","v":6.3568216868510954E-3}]
[null,"h2",{"$f":"H21^2*COS(D39)^2","v":3.4579581170973211E-3},null,null,null,"Rf",{"$f":"(D18*H17)/SQRT(1-H20^2*SIN(H42)^2)","v":20921210.82571448},{"$f":"$E$3","v":"survey feet"}]
[null,"R",{"$f":"(D18*H17)/SQRT(1-H20^2*SIN(D39)^2)","v":20951408.402825173},{"$f":"$E$3","v":"survey feet"},null,null,"Q",{"$f":"(H40-D22)/H45","v":-4.4950393861085264E-2}]
[null,"A1",{"$f":"-C46","v":-20951408.402825173},null,null,null,"B2",{"$f":"-H43/2*(1+H44)","v":-0.12345738684084423}]
[null,"A2",{"$f":"C46*C44/2","v":10204979.225549189},null,null,null,"B3",{"$f":"-(1+2*H43^2+H44)/6","v":-0.18779251117704707}]
[null,"A3",{"$f":"(1-C44^2+C45)/6","v":9.0793914921961753E-3},null,null,null,"B4",{"$f":"-(5+3*H43^2+H44*(1-9*H43^2)-4*H44^2)/12","v":-0.431945706435374}]
[null,"A4",{"$f":"(5-C44^2+C45*(9+4*C45))/12","v":0.34018232031560952},null,null,null,"B5",{"$f":"(5+28*H43^2+24*H43^4+H44*(6+8*H43^2))/120","v":5.6781268258525711E-2}]
[null,"A5",{"$f":"(5-18*C44^2+C44^4+C45*(14-58*C44^2))/120","v":-9.4358505824717984E-2},null,null,null,"B6",{"$f":"(61+90*H43^2+45*H43^4+H44*(46-252*H43^2-90*H43^4))/360","v":0.18548584572360111}]
[null,"A6",{"$f":"(61-58*C44^2+C44^4+C45*(270-330*C44^2))/360","v":1.8639926937148259E-2},null,null,null,"B7",{"$f":"-(61+662*H43^2+1320*H43^4+720*H43^6)/5040","v":-2.0990572641492285E-2}]
[null,"A7",{"$f":"(61-479*C44^2+179*C44^4-C44^6)/5040","v":-4.627291280356232E-2},null,null,null,"L",{"$f":"H46*(1+H46^2*(H48+H46^2*(H50+H52*H46^2)))","v":-4.4933348211118572E-2}]
[null,"N",{"$f":"C43-C36+D21+C48*C41^2*(1+C41^2*(C50+C52*C41^2))","v":16079882.525738711},{"$f":"$E$3","v":"survey feet"},null,null,"Lat (f)",{"$f":"H42+H47*H46^2*(1+H46^2*(H49+H51*H46^2))","v":0.24035299993884782}]
[null,"E",{"$f":"D22+C47*C41*(1+C41^2*(C49+C41^2*(C51+C53*C41^2)))","v":1177670.0541070623},{"$f":"$E$3","v":"survey feet"},null,null,"Long (l)",{"$f":"D19-(H53/COS(H42))","v":1.5647025076170711}]
[null,null,null,null,null,null,"Lat (f)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H54)),6)","v":"+13°46'16.364963\""}]
[null,"C1",{"$f":"-C44","v":-0.9741568709216808},null,null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H55)),6)","v":"+89°39'03.059568\""}]
[null,"C3",{"$f":"(1+3*C45+2*C45^2)/3","v":0.33679926309999036}]
[null,"C5",{"$f":"(2-C44^2)/15","v":7.0067892722405309E-2},null,null,null,"D1",{"$f":"H43","v":0.2453550950922268}]
[null,"F2",{"$f":"(1+C45)/2","v":0.50172897905854863},null,null,null,"D3",{"$f":"-(1+H43^2-H44-2*H44^2)/3","v":-0.35125382754564921}]
[null,"F4",{"$f":"(5-4*C44^2+C45*(9-24*C44^2))/12","v":9.6369854883080655E-2},null,null,null,"D5",{"$f":"(2+5*H43^2+3*H43^4)/15","v":0.15412449443704601}]
[null,"g",{"$f":"C57*C41*(1+C41^2*(C58+C59*C41^2))","v":-2.1519311107690314E-2},"radians",null,null,"G2",{"$f":"(1+H44)/2","v":0.50317841084342552}]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C62)),3)","v":"-1°13'58.677\""},null,null,null,"G4",{"$f":"(1+5*H44)/12","v":8.5982009036187954E-2}]
[null,"k",{"$f":"D18*(1+C60*C41^2*(1+C61*C41^2))","v":0.99984466512759351},null,null,null,"g",{"$f":"H59*H46*(1+H46^2*(H60+H61*H46^2))","v":-1.1020987715627192E-2}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H64)),3)","v":"-0°37'53.242\""}]
[null,null,null,null,null,null,"k",{"$f":"D18*(1+H62*H46^2*(1+H63*H46^2))","v":1.0006164609363011}]

{"sheet":"WisCRS_Conic","index":3,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["WisCRS Conic Systems"]
[]
[null,"Units",{"$f":"Comps!C4","v":"Survey Ft"}]
[null,"County",{"$f":"Comps!C18","v":"Pierce"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Comps!D18","v":44.35},"d.ms","N",{"$f":"Comps!F19","v":118430.0705},{"$f":"C3","v":"Survey Ft"}]
[null,"Long (l)",{"$f":"Comps!E18","v":92.11},"d.ms","E",{"$f":"Comps!G19","v":251695.2414},{"$f":"C3","v":"Survey Ft"}]
[null,"N",{"$f":"C40","v":263007.19602946058},{"$f":"C3","v":"Survey Ft"},"Lat (f)",{"$f":"FormatAngle(DDtoDMS(DEGREES(G45)),6)","v":"+44°10'51.897493\""}]
[null,"E",{"$f":"C39","v":561580.48306150141},{"$f":"C3","v":"Survey Ft"},"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(-G26)),6)","v":"+93°21'53.364178\""}]
[null,"g",{"$f":"C36","v":"+0°01'52.416\""},null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(G25)),3)","v":"-0°47'56.006\""}]
[null,"k",null,null,"k"]
[]
["County Parameters",null,"from table","for computations",null,"Zone Constants"]
[null,"County",{"$f":"VLOOKUP($C$4,WisCone,1,FALSE)","v":"Pierce"},null,null," vo",{"$f":"J17/(SQRT(1-J20^2*SIN(D17)^2))","v":20960266.61283274},null,null,null,null,"County Parameters - WisCRS Conic"]
["lO","CM Long",{"$f":"VLOOKUP($C$4,WisCRS_Cone,2,FALSE)","v":"92.1340000000"},{"$f":"RADIANS(DMStoDD(C16))*(-1)","v":-1.6096783840198814},"radians"," ro",{"$f":"(J17*(1-J20^2))/((1-J20^2*SIN(D17)^2)^1.5)","v":20888982.006303642},null,"GRS80 Ellipsoid",null,null,null,"Long (Cen Mer)","False Easting","False Northing","Lat (Cen Par)","Scale"]
["fO","CP Lat",{"$f":"VLOOKUP($C$4,WisCRS_Cone,5,FALSE)","v":"44.3810135939"},{"$f":"RADIANS(DMStoDD(C17))","v":0.7790477632257834},"radians"," ro",{"$f":"(C20*G15)/TAN(D17)","v":21228954.291041095},null,"a",{"$f":"'GRS80_&_Units'!C5*VLOOKUP(C3,Units,2,FALSE)","v":20925604.474166665},{"$f":"C3","v":"Survey Ft"},"County","(d.ms)","(Meters)","(Meters)","(d.ms)","(Cen Par)"]
["EO","False E",{"$f":"VLOOKUP($C$4,WisCRS_Cone,3,FALSE)","v":167640.33543000001},{"$f":"C18*VLOOKUP(C3,Units,2,FALSE)","v":550000.00048992503},{"$f":"C3","v":"Survey Ft"}," A0",{"$f":"1-J20^2/4-3*J20^4/64-5*J20^6/256","v":0.99832429844458415},null,"b",{"$f":"'GRS80_&_Units'!C6*VLOOKUP(C3,Units,2,FALSE)","v":20855444.883975454},{"$f":"C3","v":"Survey Ft"},"Bayfield","91.0910000000",228600.45746999999,148551.48371999999,"46.4010734158",1.0000331195000001]
["NO","False N",{"$f":"VLOOKUP($C$4,WisCRS_Cone,4,FALSE)","v":86033.087589999996},{"$f":"C19*VLOOKUP(C3,Units,2,FALSE)","v":282260.22153485834},{"$f":"C3","v":"Survey Ft"}," A2",{"$f":"(3/8)*(J20^2+J20^4/4+15*J20^6/128)","v":2.5146070728458312E-3},null,"f",{"$f":"(J17-J18)/J17","v":3.3528106811837066E-3},null,"Burnett","92.2728000000",64008.127619999999,59445.904289999999,"45.5355373517",1.0000383841]
["kO","CP Scale",{"$f":"VLOOKUP($C$4,WisCRS_Cone,6,FALSE)","v":1.0000362976999999},null,null," A4",{"$f":"(15/256)*(J20^4+3*J20^6/4)","v":2.6390466202330245E-6},null,"e",{"$f":"SQRT((J17^2-J18^2)/J17^2)","v":8.1819191042832223E-2},null,"Chippewa","91.1740000000",60045.720020000001,44091.434560000002,"44.5840284835",1.0000391126999999]
[null,null,null,null,null," A6",{"$f":"(35/3072)*J20^6","v":3.418046136779333E-9},null,"e'",{"$f":"SQRT((J17^2-J18^2)/J18^2)","v":8.2094438151933805E-2},null,"Columbia","89.2340000000",169164.33812,111569.61335,"43.2745167925",1.0000349799999999]
[null,null,null,null,null," Mo",{"$f":"J17*(G18*D17-G19*SIN(2*D17)+G20*SIN(4*D17)-G21*SIN(6*D17))","v":16222114.042049143},null,null,null,null,"Crawford","90.5620000000",113690.62738999999,53703.120110000003,"43.1200200178",1.0000349151000001]
[null,null,null,null,null,null,null,null,null,null,null,"Dane","89.2520000000",247193.29438000001,146591.98957999999,"43.0410257735",1.0000384786000001]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion",null,null,null,null,null,"Eau Claire","91.1720000000",120091.44018999999,91687.923890000005,"44.5220212055",1.0000350790000001]
[null,"Lat (f)",{"$f":"C7","v":44.35},{"$f":"RADIANS(DMStoDD(C25))","v":0.77812595818080532},"radians","g",{"$f":"ATAN((F8-D18)/(G17-F7+D19))","v":-1.3943272696533242E-2},"radians",{"$f":"FormatAngle(DDtoDMS(DEGREES(G25)),3)","v":"-0°47'56.006\""},null,null,"Green","89.5020000000",170078.74028999999,45830.294719999998,"42.3815224197",1.0000390486999999]
[null,"Long (l)",{"$f":"C8*-1","v":-92.11},{"$f":"RADIANS(DMStoDD(C26))","v":-1.6089026821301062},"radians","Long (l)",{"$f":"(G25/SIN(D17))+D16","v":-1.6295235735721931},"radians",null,null,null,"Green Lake","89.1430000000",150876.30179,79170.779509999993,"43.4825200424",1.0000344056999999]
[null,"Mf",{"$f":"J17*(G18*D25-G19*SIN(2*D25)+G20*SIN(4*D25)-G21*SIN(6*D25))","v":16202858.562452156},null,null,"iterative comps for M",1,2,3,null,null,"Lafayette","89.5020000000",170078.74028999999,45830.294719999998,"42.3815224197",1.0000390486999999]
[null,"M",{"$f":"C27-G22","v":-19255.479596987367},null,null,"s",{"$f":"F7-D19-(F8-D18)*TAN(G25/2)","v":-165909.85703011113},null,null,null,null,"Langlade","89.0200000000",198425.19701999999,105279.78290000001,"45.0915253579",1.0000627023999999]
[null,"M3",{"$f":"C28^3/(6*G16*G15)","v":-2.7176760777620343E-3},null,null,"Ma",{"$f":"G28/C20","v":-165903.83510247574},{"$f":"G29+G37","v":-165902.10024690855},{"$f":"H29+H37","v":-165902.10024690797},null,null,"Marathon","89.4612000000",74676.149300000005,55049.266929999998,"44.5403255925",1.000053289]
[null,"M4",{"$f":"(C28^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":6.0786924414783463E-7},null,null,"M3a",{"$f":"G29^3/(6*G16*G15)","v":-1.7382168184396032},{"$f":"H29^3/(6*G16*G15)","v":-1.7381622894362976},{"$f":"I29^3/(6*G16*G15)","v":-1.7381622894362794},null,null,"Marquette","89.1430000000",150876.30179,79170.779509999993,"43.4825200424",1.0000344056999999]
[null,"M5",{"$f":"(C28^5*(5+3*TAN(D17)^2-3*J21^2-J21^2*COS(D17)^2))/(120*G16^2*G15^2)","v":-9.0918248156379585E-10},null,null,"M4a",{"$f":"(G29^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":3.3497971741315779E-3},{"$f":"(H29^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":3.3496570610806972E-3},{"$f":"(I29^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":3.3496570610806508E-3},null,null,"Monroe","90.3830000000",204521.20895,121923.98613,"44.0000266143",1.0000434121999999]
[null,"M6",{"$f":"(C28^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":5.6883613305134059E-13},null,null,"M5a",{"$f":"(G29^5*(5+3*TAN(D17)^2-3*J21^2-J21^2*COS(D17)^2))/(120*G16^2*G15^2)","v":-4.3167956062070219E-5},{"$f":"(H29^5*(5+3*TAN(D17)^2-3*J21^2-J21^2*COS(D17)^2))/(120*G16^2*G15^2)","v":-4.3165699073778883E-5},{"$f":"(I29^5*(5+3*TAN(D17)^2-3*J21^2-J21^2*COS(D17)^2))/(120*G16^2*G15^2)","v":-4.3165699073778131E-5},null,null,"Oneida","89.3240000000",70104.140090000001,57588.034630000002,"45.4215205573",1.0000686968000001]
[null,"M7",{"$f":"(C28^7*(60*TAN(D17)^4+180*TAN(D17)^2+61))/(5040*G16^3*G15^3)","v":-6.8098102187280912E-16},null,null,"M6a",{"$f":"(G29^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":2.3270177058566584E-7},{"$f":"(H29^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":2.3268717079989467E-7},{"$f":"(I29^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":2.3268717079988983E-7},null,null,"Pierce","92.1340000000",167640.33543000001,86033.087589999996,"44.3810135939",1.0000362976999999]
[null,"s",{"$f":"C20*(SUM(C28:C33))","v":-19256.181243776875},{"$f":"C3","v":"Survey Ft"},null,"M7a",{"$f":"(G29^7*(60*TAN(D17)^4+180*TAN(D17)^2+61))/(5040*G16^3*G15^3)","v":-2.4002120212664001E-9},{"$f":"(H29^7*(60*TAN(D17)^4+180*TAN(D17)^2+61))/(5040*G16^3*G15^3)","v":-2.4000363337429351E-9},{"$f":"(I29^7*(60*TAN(D17)^4+180*TAN(D17)^2+61))/(5040*G16^3*G15^3)","v":-2.4000363337428764E-9},null,null,"Pepin","92.1340000000",167640.33543000001,86033.087589999996,"44.3810135939",1.0000362976999999]
[null,"g",{"$f":"(D26-D16)*SIN(D17)","v":5.4500980964887252E-4},"radians",null,"-Fa",{"$f":"(G28/C20)-SUM(G29:G34)","v":1.7349099589046091},{"$f":"(G28/C20)-SUM(H29:H34)","v":5.8207660913467407E-10},{"$f":"(G28/C20)-SUM(I29:I34)","v":0},null,null,"Portage","89.3000000000",56388.112829999998,50022.187440000002,"44.2500566311",1.0000399360000001]
[null,null,{"$f":"FormatAngle(DDtoDMS(DEGREES(C35)),3)","v":"+0°01'52.416\""},null,null,"dF/dM",{"$f":"1+(3*G30+4*G31+5*G32+6*G33+7*G34)/G29","v":1.0000313522934765},{"$f":"1+(3*H30+4*H31+5*H32+6*H33+7*H34)/H29","v":1.0000313516385959},{"$f":"1+(3*I30+4*I31+5*I32+6*I33+7*I34)/I29","v":1.0000313516385959},null,null,"Richland","90.2550000000",202387.60477000001,134255.42529000001,"43.1920326539",1.0000375653]
[null,"k",{"$f":"$C$20*(1+(C28^2)/(2*$G$16*$G$15)+(C28^3*TAN($D$17))/(6*$G$16*$G$15^2)+(C28^4*(5+3*TAN($D$17)^2))/(24*$G$16^2*$G$15^2))","v":1.0000367210009866},null,null,"dM",{"$f":"G35/G36","v":1.7348555672037267},{"$f":"H35/H36","v":5.8205836065130918E-10},{"$f":"I35/I36","v":0},null,null,"Sawyer","91.0700000000",216713.23360000001,120734.16310000001,"45.5400356873",1.0000573461]
[null,"DE",{"$f":"(G17-C34)*SIN(C35)","v":11580.48257157636},null,null,"M",{"$f":"I29+I37","v":-165902.10024690797},null,null,null,null,"Taylor","90.2900000000",187147.57436,107746.7522,"45.1040159509",1.0000597566]
[null,"East",{"$f":"D18+C38","v":561580.48306150141},null,null,"Mf",{"$f":"G22+G38","v":16056211.941802235},null,null,null,null,"Vernon","90.4700000000",222504.44510000001,47532.0602,"43.3430118583",1.0000408158]
[null,"North",{"$f":"D19+C34+C38*TAN(C35/2)","v":263007.19602946058},null,null,"Iterative comps for latitude","fa (radians)","-Ga","dG/df","df",null,"Vilas","89.2920000000",134417.06891,50337.10916,"46.0440238726",1.0000730142000001]
[null,null,null,null,null,1,{"$f":"G39/(J17*G18)","v":0.76858771473540799},{"$f":"$G$39-$J$17*($G$18*G41-$G$19*SIN(2*G41)+$G$20*SIN(4*G41)-$G$21*SIN(6*G41))","v":52586.15440361388},{"$f":"$J$17*($G$18-2*$G$19*COS(2*G41)+4*$G$20*COS(4*G41)-6*$G$21*COS(6*G41))","v":20886781.47932357},{"$f":"H41/I41","v":2.5176762851505121E-3},null,"Walworth","88.3230000000",232562.8651,111088.22244,"42.4010063549",1.0000367191999999]
[null,null,null,null,null,2,{"$f":"G41+J41","v":0.77110539102055853},{"$f":"$G$39-$J$17*($G$18*G42-$G$19*SIN(2*G42)+$G$20*SIN(4*G42)-$G$21*SIN(6*G42))","v":-0.66655233688652515},{"$f":"$J$17*($G$18-2*$G$19*COS(2*G42)+4*$G$20*COS(4*G42)-6*$G$21*COS(6*G42))","v":20887310.994925614},{"$f":"H42/I42","v":-3.1911830922058758E-8},null,"Washburn","91.4700000000",234086.86817,188358.60574999999,"45.5740391400",1.0000475376]
[null,null,null,null,null,3,{"$f":"G42+J42","v":0.77110535910872757},{"$f":"$G$39-$J$17*($G$18*G43-$G$19*SIN(2*G43)+$G$20*SIN(4*G43)-$G$21*SIN(6*G43))","v":0},{"$f":"$J$17*($G$18-2*$G$19*COS(2*G43)+4*$G$20*COS(4*G43)-6*$G$21*COS(6*G43))","v":20887310.988213293},{"$f":"H43/I43","v":0},null,"Waushara","89.1430000000",120091.4402,45069.758730000001,"44.0650198565",1.0000392095999999]
[null,null,null,null,null,4,{"$f":"G43+J43","v":0.77110535910872757},{"$f":"$G$39-$J$17*($G$18*G44-$G$19*SIN(2*G44)+$G$20*SIN(4*G44)-$G$21*SIN(6*G44))","v":0},{"$f":"$J$17*($G$18-2*$G$19*COS(2*G44)+4*$G$20*COS(4*G44)-6*$G$21*COS(6*G44))","v":20887310.988213293},{"$f":"H44/I44","v":0},null,"Wood","90.0000000000",208483.61726999999,134589.75399999999,"44.2145343690",1.0000421209000001]
[null,null,null,null,null,"Lat (f)",{"$f":"G44+J44","v":0.77110535910872757},"radians",{"$f":"FormatAngle(DDtoDMS(DEGREES(G45)),6)","v":"+44°10'51.897493\""}]
[null,null,null,null,null,"k",{"$f":"$C$20*(1+(G38^2)/(2*$G$16*$G$15)+(G38^3*TAN($D$17))/(6*$G$16*$G$15^2)+(G38^4*(5+3*TAN($D$17)^2))/(24*$G$16^2*$G$15^2))","v":1.0000676493710769}]

{"sheet":"WisCRS_Cylindric","index":4,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["WCCS Transverse Mercator Cylindric Systems"]
[]
[null,"Units",{"$f":"Comps!C4","v":"Survey Ft"}]
[null,"County",{"$f":"Comps!C21","v":"Polk"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Comps!D21","v":45.14},"d.ms","N",{"$f":"Comps!F22","v":120000},{"$f":"C3","v":"Survey Ft"}]
[null,"Long (l)",{"$f":"Comps!E21","v":92.13},"d.ms","E",{"$f":"Comps!G22","v":750000},{"$f":"C3","v":"Survey Ft"}]
[null,"N",{"$f":"C53","v":208919.26211938306},{"$f":"C3","v":"Survey Ft"},"Lat (f)",{"$f":"H55","v":"+44°59'05.708779\""}]
[null,"E",{"$f":"C54","v":572350.99525446212},{"$f":"C3","v":"Survey Ft"},"Long (l)",{"$f":"H56","v":"+91°31'54.973118\""}]
[null,"g",{"$f":"C62","v":"+0°17'44.980\""},null,"g",{"$f":"H64","v":"+0°46'43.134\""}]
[null,"k",{"$f":"C63","v":1.0000565428837715},null,"k",{"$f":"H65","v":1.0001361314078705}]
[]
["Zone Parameters",null,null,null,null,null,null,"GRS80 Ellipsoid"]
[null,"County",{"$f":"VLOOKUP($C$4,WisCRS_Cyl,1,FALSE)","v":"Polk"},null,null,null,null,"a",{"$f":"'GRS80_&_Units'!C5*VLOOKUP(C3,Units,2,FALSE)","v":20925604.474166665},null,"County Parameters - WisCRS Cylindric"]
[null,"lo",{"$f":"VLOOKUP($C$4,WisCRS_Cyl,2,FALSE)","v":"92.3800000000"},{"$f":"RADIANS(DMStoDD(C16))","v":1.6167566637640804},"radians",null,null,"b",{"$f":"'GRS80_&_Units'!C6*VLOOKUP(C3,Units,2,FALSE)","v":20855444.883975454},null,null,"Long (Cen Mer)","Lat (Origin)","False Easting","False Northing","Scale"]
[null,"fo",{"$f":"VLOOKUP($C$4,WisCRS_Cyl,3,FALSE)","v":"44.3940000000"},{"$f":"RADIANS(DMStoDD(C17))","v":0.77948343648791185},"radians",null,null,"f",{"$f":"(I15-I16)/I15","v":3.3528106811837066E-3},null,"County","(d.ms)","(d.ms)","(Meters)","(Meters)","(Cen Mer)"]
[null,"ko",{"$f":"VLOOKUP($C$4,WisCRS_Cyl,6,FALSE)","v":1.0000433849000001},null,null,null,null,"e",{"$f":"SQRT((I15^2-I16^2)/I15^2)","v":8.1819191042832223E-2},null,"Adams","90.0000000000","43.2200000000",147218.6942,3.7000000000000002E-3,1.0000365284999999]
[null,"No",{"$f":"VLOOKUP($C$4,WisCRS_Cyl,5,FALSE)","v":5.8999999999999999E-3},{"$f":"C19*VLOOKUP(C3,Units,2,FALSE)","v":1.9356916666666665E-2},{"$f":"C3","v":"Survey Ft"},null,null,"e'",{"$f":"SQRT((I15^2-I16^2)/I16^2)","v":8.2094438151933805E-2},null,"Ashland","90.3720000000","45.4222000000",172821.9461,1.6999999999999999E-3,1.0000495682999999]
[null,"Eo",{"$f":"VLOOKUP($C$4,WisCRS_Cyl,4,FALSE)","v":141732.28229999999},{"$f":"C20*VLOOKUP(C3,Units,2,FALSE)","v":464999.99617924995},{"$f":"C3","v":"Survey Ft"},null,null,null,null,null,"Barron","91.5100000000","45.0800000000",93150,2.8999999999999998E-3,1.0000486664999999]
[null,null,null,null,null,null,null,null,null,null,"Brown","88.0000000000","43.0000000000",31600,4600,1.0000199999999999]
[null,null,null,null,null,null,null,null,null,null,"Buffalo","91.4750000000","43.2853000000",175260.35019999999,4.7999999999999996E-3,1.0000382778000001]
["Zone Constants",null,null,null,null,null,null,null,null,null,"Calumet","88.3000000000","42.4310000000",244754.88930000001,4.8999999999999998E-3,1.0000286569000001]
[null,"n",{"$f":"(I15-I16)/(I15+I16)","v":1.6792203946294406E-3},null,null,null,null,null,null,null,"Clark","90.4230000000","43.3600000000",199949.19889999999,8.6E-3,1.0000463003]
[null,"r",{"$f":"I15*(1-C24)*(1-C24^2)*(1+9*C24^2/4+225*C24^4/64)","v":20890539.405750498},{"$f":"C3","v":"Survey Ft"},null,null,null,null,null,null,"Dodge","88.4630000000","41.2820000000",263347.72629999998,7.6E-3,1.0000346417999999]
[null,"u2",{"$f":"-3*C24/2+9*C24^3/16","v":-2.5188279284875425E-3},null,"v2",{"$f":"3*C24/2-27*C24^3/32","v":2.5188265967592332E-3},null,null,null,null,"Door","87.1620000000","44.2400000000",158801.1176,2.3E-3,1.0000187520999999]
[null,"u4",{"$f":"15*C24^2/16-15*C24^4/32","v":2.643541085771844E-6},null,"v4",{"$f":"21*C24^2/16-55*C24^4/32","v":3.7009490719670861E-6},null,null,null,null,"Douglas","91.5500000000","45.5300000000",59131.318299999999,4.1000000000000003E-3,1.0000385418]
[null,"u6",{"$f":"-35*C24^3/48","v":-3.4526289497048255E-9},null,"v6",{"$f":"151*C24^3/96","v":7.4478138772204098E-9},null,null,null,null,"Dunn","91.5340000000","44.2430000000",51816.103999999999,3.0000000000000001E-3,1.0000410324]
[null,"u8",{"$f":"315*C24^4/512","v":4.8918304243960608E-12},null,"v8",{"$f":"1097*C24^4/512","v":1.7035993573214219E-11},null,null,null,null,"Florence","88.0830000000","45.2620000000",133502.66829999999,6.3E-3,1.0000552094999999]
[null,"U0",{"$f":"2*(C26-2*C27+3*C28-4*C29)","v":-5.0482507762265134E-3},null,"V0",{"$f":"2*(F26-2*F27+3*F28-4*F29)","v":5.0228939478259129E-3},null,null,null,null,"Fond du Lac","88.3000000000","42.4310000000",244754.88930000001,4.8999999999999998E-3,1.0000286569000001]
[null,"U2",{"$f":"8*(C27-4*C28+10*C29)","v":2.1259204158999257E-5},null,"V2",{"$f":"8*(F27-4*F28+10*F29)","v":2.9370625411151495E-5},null,null,null,null,"Forest","88.3800000000","44.0020000000",275844.55330000003,1.5699999999999999E-2,1.0000673004]
[null,"U4",{"$f":"32*(C28-6*C29)","v":-1.1142335783203845E-7},null,"V4",{"$f":"32*(F28-6*F29)","v":2.3505913330499599E-7},null,null,null,null,"Grant","90.4800000000","41.2440000000",242316.4841,0.01,1.0000349451999999]
[null,"U6",{"$f":"128*C29","v":6.2615429432269579E-10},null,"V6",{"$f":"128*F29","v":2.18060717737142E-9},null,null,null,null,"Iowa","90.0940000000","42.3220000000",113081.0261,4.4999999999999997E-3,1.0000394961000001]
[null,"wo",{"$f":"D17+SIN(D17)*COS(D17)*(C30+C31*COS(D17)^2+C32*COS(D17)^4+C33*COS(D17)^6)","v":0.77696485078237698},null,null,null,null,null,null,null,"Iron","90.1520000000","45.2600000000",220980.44190999999,8.5000000000000006E-3,1.0000677152999999]
[null,"So",{"$f":"C18*C34*C25","v":16231919.021784676},{"$f":"C3","v":"Survey Ft"},null,null,null,null,null,null,"Jackson","90.5039467470","44.1512006460",27000,25000,1.0000353]
[null,null,null,null,null,null,null,null,null,null,"Jefferson","88.4630000000","41.2820000000",263347.72629999998,7.6E-3,1.0000346417999999]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion",null,null,null,null,"Juneau","90.0000000000","43.2200000000",147218.6942,3.7000000000000002E-3,1.0000365284999999]
[null,"Lat (f)",{"$f":"C7","v":45.14},{"$f":"RADIANS(DMStoDD(C38))","v":0.78947059831876842},"radians",null,"N",{"$f":"F7","v":120000},{"$f":"C3","v":"Survey Ft"},null,"Kenosha","87.5340000000","42.1300000000",185928.37280000001,8.9999999999999998E-4,1.0000260648999999]
[null,"Long (l)",{"$f":"C8","v":92.13},{"$f":"RADIANS(DMStoDD(C39))","v":1.6094844585474373},"radians",null,"E",{"$f":"F8","v":750000},{"$f":"C3","v":"Survey Ft"},null,"Kewaunee","87.3300000000","43.1600000000",79857.761429999999,1.1999999999999999E-3,1.0000233703999999]
[null,"L",{"$f":"(D39-D16)*COS(D38)","v":-5.1212416604101158E-3},null,null,null,"w",{"$f":"(H38-D19+C35)/(C18*C25)","v":0.78270882763003813},null,null,"LaCrosse","91.1900000000","43.2704000000",130454.65979999999,3.3E-3,1.0000319984999999]
[null,"w",{"$f":"D38+SIN(D38)*COS(D38)*(C30+C31*COS(D38)^2+C32*COS(D38)^4+C33*COS(D38)^6)","v":0.78695181432902805},null,null,null,"ff",{"$f":"H40+(SIN(H40)*COS(H40))*(F30+F31*COS(H40)^2+F32*COS(H40)^4+F33*COS(H40)^6)","v":0.78522765015632334},null,null,"Lincoln","89.4400000000","44.5040000000",116129.03230000001,5.7999999999999996E-3,1.0000599002999999]
[null,"S",{"$f":"C18*C41*C25","v":16440561.128824033},{"$f":"C3","v":"Survey Ft"},null,null,"tf",{"$f":"TAN(H41)","v":0.99965903165406333},null,null,"Manitowoc","87.3300000000","43.1600000000",79857.761400000003,1.1999999999999999E-3,1.0000233703999999]
[null,"t",{"$f":"TAN(D38)","v":1.0081782203239131},null,null,null,"hf2",{"$f":"I19^2*COS(H41)^2","v":3.3708975611573058E-3},null,null,"Marinette","87.4240000000","44.4130000000",238658.87940000001,3.2000000000000002E-3,1.0000234982]
[null,"h2",{"$f":"I19^2*COS(D38)^2","v":3.3423025291772946E-3},null,null,null,"Rf",{"$f":"(C18*I15)/SQRT(1-I18^2*SIN(H41)^2)","v":20961610.99833275},{"$f":"C3","v":"Survey Ft"},null,"Menominee","88.2500000000","44.4300000000",105461.01210000001,2.3E-3,1.0000362499]
[null,"R",{"$f":"(C18*I15)/SQRT(1-I18^2*SIN(D38)^2)","v":20961909.696825143},{"$f":"C3","v":"Survey Ft"},null,null,"Q",{"$f":"(H39-D20)/H44","v":1.3596283407960316E-2},null,null,"Milwaukee","87.5340000000","42.1300000000",185928.37280000001,8.9999999999999998E-4,1.0000260648999999]
[null,"A1",{"$f":"-C45","v":-20961909.696825143},null,null,null,"B2",{"$f":"-H42/2*(1+H43)","v":-0.50151438992292741},null,null,"Oconto","87.5430000000","44.2350000000",182880.3676,3.3E-3,1.0000236869000001]
[null,"A2",{"$f":"C45*C43/2","v":10566670.406367876},null,null,null,"B3",{"$f":"-(1+2*H42^2+H43)/6","v":-0.50033454278270606},null,null,"Outagamie","88.3000000000","42.4310000000",244754.88930000001,4.8999999999999998E-3,1.0000286569000001]
[null,"A3",{"$f":"(1-C43^2+C44)/6","v":-2.1801702343859056E-3},null,null,null,"B4",{"$f":"-(5+3*H42^2+H43*(1-9*H42^2)-4*H43^2)/12","v":-0.66424688262778209},null,null,"Ozaukee","87.5340000000","42.1300000000",185928.37280000001,8.9999999999999998E-4,1.0000260648999999]
[null,"A4",{"$f":"(5-C43^2+C44*(9+4*C44))/12","v":0.3344751735643241},null,null,null,"B5",{"$f":"(5+28*H42^2+24*H42^4+H43*(6+8*H42^2))/120","v":0.4749613915276083},null,null,"Polk","92.3800000000","44.3940000000",141732.28229999999,5.8999999999999999E-3,1.0000433849000001]
[null,"A5",{"$f":"(5-18*C43^2+C43^4+C44*(14-58*C43^2))/120","v":-0.10343957073563306},null,null,null,"B6",{"$f":"(61+90*H42^2+45*H42^4+H43*(46-252*H42^2-90*H42^4))/360","v":0.54133472307891839},null,null,"Price","90.2920000000","44.3320000000",227990.85459999999,1.09E-2,1.0000649554000001]
[null,"A6",{"$f":"(61-58*C43^2+C43^4+C44*(270-330*C43^2))/360","v":7.9497532410525498E-3},null,null,null,"B7",{"$f":"-(61+662*H42^2+1320*H42^4+720*H42^6)/5040","v":-0.54747569729146095},null,null,"Racine","87.5340000000","42.1300000000",185928.37280000001,8.9999999999999998E-4,1.0000260648999999]
[null,"A7",{"$f":"(61-479*C43^2+179*C43^4-C43^6)/5040","v":-4.8013695416196746E-2},null,null,null,"L",{"$f":"H45*(1+H45^2*(H47+H45^2*(H49+H51*H45^2)))","v":1.3595026090603063E-2},null,null,"Rock","89.0420000000","41.5640000000",146304.29259999999,6.7999999999999996E-3,1.0000337311]
[null,"N",{"$f":"C42-C35+D19+C47*C40^2*(1+C40^2*(C49+C51*C40^2))","v":208919.26211938306},{"$f":"C3","v":"Survey Ft"},null,null,"Lat (f)",{"$f":"H41+H46*H45^2*(1+H45^2*(H48+H50*H45^2))","v":0.78513495212883455},null,null,"Rusk","91.0400000000","43.5510000000",250546.10130000001,2.3400000000000001E-2,1.0000495975999999]
[null,"E",{"$f":"D20+C46*C40*(1+C40^2*(C48+C40^2*(C50+C52*C40^2)))","v":572350.99525446212},{"$f":"C3","v":"Survey Ft"},null,null,"Long (l)",{"$f":"D16-(H52/COS(H41))","v":1.5975336709812691},null,null,"Sauk","89.5400000000","42.4910000000",185623.5716,5.1000000000000004E-3,1.0000373868000001]
[null,null,null,null,null,null,"Lat (f)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H53)),6)","v":"+44°59'05.708779\""},null,null,"Shawano","88.3620000000","44.0210000000",262433.32530000003,9.5999999999999992E-3,1.000032144]
[null,"C1",{"$f":"-C43","v":-1.0081782203239131},null,null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H54)),6)","v":"+91°31'54.973118\""},null,null,"Sheboygan","87.3300000000","43.1600000000",79857.761400000003,1.1999999999999999E-3,1.0000233703999999]
[null,"C3",{"$f":"(1+3*C44+2*C44^2)/3","v":0.33668308318664164},null,null,null,null,null,null,null,"St. Croix","92.3800000000","44.0210000000",165506.73019999999,1.03E-2,1.0000381803]
[null,"C5",{"$f":"(2-C43^2)/15","v":6.5571778404300479E-2},null,null,null,"D1",{"$f":"H42","v":0.99965903165406333},null,null,"Trempealeau","91.2200000000","43.0940000000",256946.91380000001,4.1000000000000003E-3,1.0000361538]
[null,"F2",{"$f":"(1+C44)/2","v":0.50167115126458861},null,null,null,"D3",{"$f":"-(1+H42^2-H43-2*H43^2)/3","v":-0.66530818536854885},null,null,"Washington","88.0350000000","42.5505000000",120091.4415,3.0000000000000001E-3,1.00003738]
[null,"F4",{"$f":"(5-4*C43^2+C44*(9-24*C43^2))/12","v":7.357123042577661E-2},null,null,null,"D5",{"$f":"(2+5*H42^2+3*H42^4)/15","v":0.66616675799201619},null,null,"Waukesha","88.1330000000","42.3410000000",208788.41800000001,3.3999999999999998E-3,1.0000346178999999]
[null,"g",{"$f":"C56*C40*(1+C40^2*(C57+C58*C40^2))","v":5.1631698948299797E-3},"radians",null,null,"G2",{"$f":"(1+H43)/2","v":0.50168544878057864},null,null,"Waupaca","88.4900000000","43.2513000000",185013.97089999999,7.0000000000000001E-3,1.0000333644999999]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C61)),3)","v":"+0°17'44.980\""},null,null,null,"G4",{"$f":"(1+5*H43)/12","v":8.4737873983815548E-2},null,null,"Winnebago","88.3000000000","42.4310000000",244754.88930000001,4.8999999999999998E-3,1.0000286569000001]
[null,"k",{"$f":"C18*(1+C59*C40^2*(1+C60*C40^2))","v":1.0000565428837715},null,null,null,"g",{"$f":"H58*H45*(1+H45^2*(H59+H60*H45^2))","v":1.3589976203466515E-2}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H63)),3)","v":"+0°46'43.134\""}]
[null,null,null,null,null,null,"k",{"$f":"C18*(1+H61*H45^2*(1+H62*H45^2))","v":1.0001361314078705}]

{"sheet":"WCCS_Conic","index":5,"n_rows":58,"n_cols":21,"rows_kept":58,"cut":false,"hidden":false,"merged":[[13,19,13,20]]}
["WCCS Conic Systems"]
[]
[null,"Units",{"$f":"Comps!C4","v":"Survey Ft"}]
[null,"County",{"$f":"Comps!C12","v":"Sawyer"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Comps!D12","v":45.4},"d.ms","N",{"$f":"Comps!F13","v":200000},{"$f":"C3","v":"Survey Ft"}]
[null,"Long (l)",{"$f":"Comps!E12","v":90.43},"d.ms","E",{"$f":"Comps!G13","v":275000},{"$f":"C3","v":"Survey Ft"}]
[null,"N",{"$f":"C41","v":311237.58245743066},{"$f":"E3","v":0},"Lat (f)",{"$f":"H43","v":"+45°20'58.649597\""}]
[null,"E",{"$f":"C42","v":813272.65383375448},{"$f":"E3","v":0},"Long (l)",{"$f":"H42","v":"+92°48'44.722434\""}]
[null,"g",{"$f":"C39","v":"+0°17'14.104\""},null,"g",{"$f":"H44","v":"-1°13'03.969\""}]
[null,"k",{"$f":"C40","v":1.000003311735},null,"k",{"$f":"H45","v":1.0000409025282542}]
[]
["Zone Parameters",null,null,null,null,null,null,null,null,null,"County Parameters - Conic",null,null,null,null,null,null,null,null,"Enlarged Ellipsoid"]
[null,"County",{"$f":"VLOOKUP($C$4,WisCone,1,FALSE)","v":"Sawyer"},null,null,null,null,null,null,null,null,"Elev","Geoid Ht","Long O","Lat b","False E","False N","N Std Par","S Std Par","a","b"]
["fs","Std Par S",{"$f":"VLOOKUP($C$4,WisCone,9,FALSE)","v":45.431001000000002},{"$f":"RADIANS(DMStoDD(C16))","v":0.79795488621955346},"radians",null,"Enlarged Ellipsoid",null,null,null,"County","(m)","(m)","(d.ms)","(d.ms)","(m)","(m)","(d.ms)","(d.ms)","(m)","(m)"]
["fn","Std Par N",{"$f":"VLOOKUP($C$4,WisCone,8,FALSE)","v":46.045000000000002},{"$f":"RADIANS(DMStoDD(C17))","v":0.80425741559260933},"radians",null,"a",{"$f":"VLOOKUP($C$4,WisCone,10,FALSE)*VLOOKUP(C3,Units,2,FALSE)","v":20926908.444655836},{"$f":"C3","v":"Survey Ft"},null,"Bayfield",304.80099999999999,-30.45,91.090999999999994,45.2,228600.4572,0,46.552999999999997,46.244999999999997,{"$f":"'GRS80_&_Units'!$C$5+L17+M17","v":6378411.3509999998},{"$f":"'GRS80_&_Units'!$C$6+L17+M17","v":6357026.6651403466}]
["lo","Origin Long",{"$f":"VLOOKUP($C$4,WisCone,4,FALSE)","v":91.07},{"$f":"RADIANS(DMStoDD(C18))","v":1.5902858367754995},"radians",null,"b",{"$f":"VLOOKUP($C$4,WisCone,11,FALSE)*VLOOKUP(C3,Units,2,FALSE)","v":20856748.85446462},{"$f":"C3","v":"Survey Ft"},null,"Burnett",304.8,-26.84,92.272800000000004,45.215000000000003,64008.128019999996,0,46.05,45.424999999999997,{"$f":"'GRS80_&_Units'!$C$5+L18+M18","v":6378414.96},{"$f":"'GRS80_&_Units'!$C$6+L18+M18","v":6357030.2741403468}]
["fb","Origin Lat",{"$f":"VLOOKUP($C$4,WisCone,5,FALSE)","v":44.484999999999999},{"$f":"RADIANS(DMStoDD(C19))","v":0.78214991173401438},"radians",null,"f",{"$f":"(H17-H18)/H17","v":3.3526017651753109E-3},null,null,"Chippewa",304.8,-29.26,91.174000000000007,44.345199999999998,60045.720090000003,0,45.082999999999998,44.485000999999997,{"$f":"'GRS80_&_Units'!$C$5+L19+M19","v":6378412.54},{"$f":"'GRS80_&_Units'!$C$6+L19+M19","v":6357027.8541403469}]
["Nb","Origin N",{"$f":"VLOOKUP($C$4,WisCone,7,FALSE)","v":0},{"$f":"C20*VLOOKUP(C3,Units,2,FALSE)","v":0},{"$f":"C3","v":"Survey Ft"},null,"e",{"$f":"SQRT((H17^2-H18^2)/H17^2)","v":8.1816646177625907E-2},null,null,"Columbia",274.32100000000003,-34.99,89.233999999999995,42.273000000000003,169164.3383,0,43.353000000000002,43.200001,{"$f":"'GRS80_&_Units'!$C$5+L20+M20","v":6378376.3310000002},{"$f":"'GRS80_&_Units'!$C$6+L20+M20","v":6356991.6451403471}]
["Eo","Origin E",{"$f":"VLOOKUP($C$4,WisCone,6,FALSE)","v":216713.2334},{"$f":"C21*VLOOKUP(C3,Units,2,FALSE)","v":710999.99991316663},{"$f":"C3","v":"Survey Ft"},null,"e'",{"$f":"SQRT((H17^2-H18^2)/H18^2)","v":8.2091867517571859E-2},null,null,"Crawford",274.32100000000003,-32.29,90.561999999999998,42.43,113690.6274,0,43.203000000000003,43.033000000000001,{"$f":"'GRS80_&_Units'!$C$5+L21+M21","v":6378379.0310000004},{"$f":"'GRS80_&_Units'!$C$6+L21+M21","v":6356994.3451403473}]
[null,null,null,null,null,null,null,null,null,null,"Dane",304.80099999999999,-34.18,89.251999999999995,41.45,247193.29440000001,0,43.134999999999998,42.542999999999999,{"$f":"'GRS80_&_Units'!$C$5+L22+M22","v":6378407.6210000003},{"$f":"'GRS80_&_Units'!$C$6+L22+M22","v":6357022.9351403471}]
["Zone Constants",null,null,null,null,null,null,null,null,null,"Eau Claire",274.32100000000003,-30.94,91.171999999999997,44.024999999999999,120091.4402,0,45.005000000000003,44.435000000000002,{"$f":"'GRS80_&_Units'!$C$5+L23+M23","v":6378380.3810000001},{"$f":"'GRS80_&_Units'!$C$6+L23+M23","v":6356995.6951403469}]
[null,null,"Q","W",null,null,"fo",{"$f":"ASIN((LN(D26*COS(D16)/(D25*COS(D17))))/(C26-C25))","v":0.80110788105095754},"radians",null,"Green",304.80099999999999,-33.32,89.501999999999995,42.133000000000003,170078.7402,0,42.472000000000001,42.291001000000001,{"$f":"'GRS80_&_Units'!$C$5+L24+M24","v":6378408.4809999997},{"$f":"'GRS80_&_Units'!$C$6+L24+M24","v":6357023.7951403465}]
[null,"South (Qs)",{"$f":"Q(H20,D16)","v":0.89444648151794104},{"$f":"W(H20,D16)","v":0.99828301237361294},null,null,null,{"$f":"FormatAngle(DDtoDMS(DEGREES(H24)),3)","v":"+45°54'00.362\""},"Central Latitude",null,"Green Lake",274.32100000000003,-35.72,89.143000000000001,43.054000000000002,150876.30179999999,0,43.564999999999998,43.400001000000003,{"$f":"'GRS80_&_Units'!$C$5+L25+M25","v":6378375.6010000007},{"$f":"'GRS80_&_Units'!$C$6+L25+M25","v":6356990.9151403476}]
[null,"North (Qn)",{"$f":"Q(H20,D17)","v":0.90347356020881864},{"$f":"W(H20,D17)","v":0.99826189198450421},null,null,"K",{"$f":"(H17*COS(D16)*EXP(C25*SIN(H24)))/(D25*SIN(H24))","v":38741048.164281122},{"$f":"C3","v":"Survey Ft"},null,"Jackson",304.81,-32.65,90.441999999999993,43.473999999999997,125882.65180000001,0,44.250999999999998,44.095001000000003,{"$f":"'GRS80_&_Units'!$C$5+L26+M26","v":6378409.1599999992},{"$f":"'GRS80_&_Units'!$C$6+L26+M26","v":6357024.4741403461}]
[null,"Grid Origin (Qb)",{"$f":"Q(H20,D19)","v":0.87206411518914406},null,null,null,"Rb",{"$f":"H26/(EXP(C27*SIN(H24)))","v":20710617.155472841},{"$f":"C3","v":"Survey Ft"},null,"Lafayette",304.80099999999999,-33.32,89.501999999999995,42.133000000000003,170078.7402,0,42.472000000000001,42.291001000000001,{"$f":"'GRS80_&_Units'!$C$5+L27+M27","v":6378408.4809999997},{"$f":"'GRS80_&_Units'!$C$6+L27+M27","v":6357023.7951403465}]
[null,"Central (Qo)",{"$f":"Q(H20,H24)","v":0.89895511246889925},{"$f":"W(H20,H24)","v":0.99827244539118465},null,null,"Ro",{"$f":"H26/(EXP(C28*SIN(H24)))","v":20314507.981755886},{"$f":"C3","v":"Survey Ft"},null,"Langlade",457.20100000000002,-34.08,89.02,44.122500000000002,198425.19680000001,0,45.183,45,{"$f":"'GRS80_&_Units'!$C$5+L28+M28","v":6378560.1210000003},{"$f":"'GRS80_&_Units'!$C$6+L28+M28","v":6357175.4351403471}]
[null,null,null,null,null,null,"ko",{"$f":"(D28*TAN(H24)*H28)/(H17)","v":0.99999505091603746},null,null,"Marathon",396.24,-32.64,89.461200000000005,44.241999999999997,74676.149350000007,0,45.032299999999999,44.444301000000003,{"$f":"'GRS80_&_Units'!$C$5+L29+M29","v":6378500.6000000006},{"$f":"'GRS80_&_Units'!$C$6+L29+M29","v":6357115.9141403474}]
[null,null,null,null,null,null,"No",{"$f":"H27+D20-H28","v":396109.17371695489},{"$f":"C3","v":"Survey Ft"},null,"Marquette",274.32100000000003,-35.72,89.143000000000001,43.054000000000002,150876.30179999999,0,43.564999999999998,43.400001000000003,{"$f":"'GRS80_&_Units'!$C$5+L30+M30","v":6378375.6010000007},{"$f":"'GRS80_&_Units'!$C$6+L30+M30","v":6356990.9151403476}]
[null,null,null,null,null,null,null,null,null,null,"Monroe",335.28100000000001,-33.29,90.382999999999996,42.540999999999997,204521.20910000001,0,44.094000000000001,43.502000000000002,{"$f":"'GRS80_&_Units'!$C$5+L31+M31","v":6378438.9910000004},{"$f":"'GRS80_&_Units'!$C$6+L31+M31","v":6357054.3051403472}]
[null,null,null,null,null,null,null,null,null,null,"Oneida",487.7,-30.84,89.323999999999998,45.110999999999997,70104.140209999998,0,45.503,45.340001000000001,{"$f":"'GRS80_&_Units'!$C$5+L32+M32","v":6378593.8600000003},{"$f":"'GRS80_&_Units'!$C$6+L32+M32","v":6357209.1741403472}]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion",null,null,null,null,"Pepin",274.32100000000003,-30.05,92.134,43.514299999999999,167640.33530000001,0,44.45,44.312001000000002,{"$f":"'GRS80_&_Units'!$C$5+L33+M33","v":6378381.2710000006},{"$f":"'GRS80_&_Units'!$C$6+L33+M33","v":6356996.5851403475}]
[null,"Lat (f)",{"$f":"C7","v":45.4},{"$f":"RADIANS(DMStoDD(C34))","v":0.79703369174407712},"radians",null,"N",{"$f":"F7","v":200000},{"$f":"C3","v":"Survey Ft"},null,"Pierce",274.32100000000003,-30.05,92.134,43.514299999999999,167640.33530000001,0,44.45,44.312001000000002,{"$f":"'GRS80_&_Units'!$C$5+L34+M34","v":6378381.2710000006},{"$f":"'GRS80_&_Units'!$C$6+L34+M34","v":6356996.5851403475}]
[null,"Long (l)",{"$f":"C8","v":90.43},{"$f":"RADIANS(DMStoDD(C35))","v":1.5833045197675228},"radians",null,"E",{"$f":"F8","v":275000},{"$f":"C3","v":"Survey Ft"},null,"Portage",341.37700000000001,-34,89.3,43.58,56388.112800000003,0,44.36,44.110000999999997,{"$f":"'GRS80_&_Units'!$C$5+L35+M35","v":6378444.3770000003},{"$f":"'GRS80_&_Units'!$C$6+L35+M35","v":6357059.6911403472}]
[null,"Q",{"$f":"Q(H20,D34)","v":0.89313198910478198},null,null,null,"R'",{"$f":"H27-H34+D20","v":20510617.155472841},{"$f":"C3","v":"Survey Ft"},null,"Richland",304.80099999999999,-33.71,90.254999999999995,42.064999999999998,202387.6048,0,43.301000000000002,43.083001000000003,{"$f":"'GRS80_&_Units'!$C$5+L36+M36","v":6378408.091},{"$f":"'GRS80_&_Units'!$C$6+L36+M36","v":6357023.4051403468}]
[null,"R",{"$f":"H26/(EXP(C36*SIN(H24)))","v":20399635.944293182},null,null,null,"E'",{"$f":"H35-D21","v":-435999.99991316663},{"$f":"C3","v":"Survey Ft"},null,"Sawyer",426.721,-29.27,91.07,44.484999999999999,216713.2334,0,46.045000000000002,45.431001000000002,{"$f":"'GRS80_&_Units'!$C$5+L37+M37","v":6378534.4510000004},{"$f":"'GRS80_&_Units'!$C$6+L37+M37","v":6357149.7651403472}]
[null,"g",{"$f":"(D18-D35)*SIN(H24)","v":5.0134758599272248E-3},"radians",null,null,"g",{"$f":"ATAN(H37/H36)","v":-2.1254082328705948E-2},"radians",null,"Taylor",426.721,-30.8,90.29,44.122999999999998,187147.57430000001,0,45.18,45.031999999999996,{"$f":"'GRS80_&_Units'!$C$5+L38+M38","v":6378532.9210000001},{"$f":"'GRS80_&_Units'!$C$6+L38+M38","v":6357148.2351403469}]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C38)),3)","v":"+0°17'14.104\""},null,null,null,"R",{"$f":"SQRT(H36^2+H37^2)","v":20515250.719849881},null,null,"Vernon",304.80099999999999,-32.86,90.47,43.085000000000001,222504.44500000001,0,43.41,43.280000999999999,{"$f":"'GRS80_&_Units'!$C$5+L39+M39","v":6378408.9409999996},{"$f":"'GRS80_&_Units'!$C$6+L39+M39","v":6357024.2551403465}]
[null,"k",{"$f":"SQRT((1-H20^2*SIN(D34)^2))*(C37*SIN(H24))/(H17*COS(D34))","v":1.000003311735},null,null,null,"Q",{"$f":"(LN(H26/H39))/(SIN(H24))","v":0.88526222761559248},null,null,"Vilas",518.16099999999994,-30.99,89.292000000000002,45.372999999999998,134417.06880000001,0,46.133000000000003,45.555000999999997,{"$f":"'GRS80_&_Units'!$C$5+L40+M40","v":6378624.1710000001},{"$f":"'GRS80_&_Units'!$C$6+L40+M40","v":6357239.4851403469}]
[null,"N",{"$f":"H27+D20-C37*COS(C38)","v":311237.58245743066},{"$f":"C3","v":"Survey Ft"},null,null,"Long",{"$f":"D18-(H38/SIN(H24))","v":1.6198823663282487},"radians",null,"Walworth",274.32100000000003,-33.909999999999997,88.322999999999993,41.401000000000003,232562.8651,0,42.45,42.352001000000001,{"$f":"'GRS80_&_Units'!$C$5+L41+M41","v":6378377.4110000003},{"$f":"'GRS80_&_Units'!$C$6+L41+M41","v":6356992.7251403471}]
[null,"E",{"$f":"D21+C37*SIN(C38)","v":813272.65383375448},{"$f":"C3","v":"Survey Ft"},null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H41)),6)","v":"+92°48'44.722434\""},null,null,"Washbum",365.76100000000002,-28.17,91.47,44.16,234086.86809999999,0,46.09,45.462001000000001,{"$f":"'GRS80_&_Units'!$C$5+L42+M42","v":6378474.591},{"$f":"'GRS80_&_Units'!$C$6+L42+M42","v":6357089.9051403468}]
[null,null,null,null,null,null,"Lat (f)",{"$f":"H58","v":"+45°20'58.649597\""},null,null,"Waushara",304.80099999999999,-35.83,89.143000000000001,43.423000000000002,120091.4402,0,44.151000000000003,43.582999999999998,{"$f":"'GRS80_&_Units'!$C$5+L43+M43","v":6378405.9709999999},{"$f":"'GRS80_&_Units'!$C$6+L43+M43","v":6357021.2851403467}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H38)),3)","v":"-1°13'03.969\""},null,null,"Wood",335.28100000000001,-34.630000000000003,90,43.090499999999999,208483.617,0,44.323999999999998,44.104999999999997,{"$f":"'GRS80_&_Units'!$C$5+L44+M44","v":6378437.6510000005},{"$f":"'GRS80_&_Units'!$C$6+L44+M44","v":6357052.9651403474}]
[null,null,null,null,null,null,"k",{"$f":"SQRT(1-H20^2*SIN(I52)^2)*(H39*SIN(H24)/(H17*COS(I52)))","v":1.0000409025282542}]
[]
[null,null,null,null,null,null,"Latitude comps - iterative"]
[null,null,null,null,null,null,null,"f","f (radians)","f1","f2","(-f1/f2)"]
[null,null,null,null,null,null,"initial",{"$f":"(EXP(2*H40)-1)/(EXP(2*H40)+1)","v":0.709045760131499},{"$f":"ASIN(H49)","v":0.7881440671606027},{"$f":"Q($H$20,I49)-$H$40","v":-4.7516616502139009E-3},{"$f":"1/(1-H49^2)-$H$20^2/(1-$H$20^2*H49^2)","v":2.0043276449481318},{"$f":"-J49/K49","v":2.3707010488980534E-3}]
[null,null,null,null,null,null,1,{"$f":"H49+L49","v":0.71141646118039703},{"$f":"ASIN(H50)","v":0.79151169696481993},{"$f":"Q($H$20,I50)-$H$40","v":1.6207490241892941E-5},{"$f":"1/(1-H50^2)-$H$20^2/(1-$H$20^2*H50^2)","v":2.0180394940982653},{"$f":"-J50/K50","v":-8.0313047833263776E-6}]
[null,null,null,null,null,null,2,{"$f":"H50+L50","v":0.7114084298756137},{"$f":"ASIN(H51)","v":0.79150026897182368},{"$f":"Q($H$20,I51)-$H$40","v":1.8811696644860376E-10},{"$f":"1/(1-H51^2)-$H$20^2/(1-$H$20^2*H51^2)","v":2.0179926485620161},{"$f":"-J51/K51","v":-9.3219847249023626E-11}]
[null,null,null,null,null,null,3,{"$f":"H51+L51","v":0.71140842978239383},{"$f":"ASIN(H52)","v":0.79150026883917912}]
[]
[null,null,null,null,null,null,null,"f (D-M-S)"]
[null,null,null,null,null,null,"initial",{"$f":"FormatAngle(DDtoDMS(DEGREES(I49)),6)","v":"+45°09'26.383308\""}]
[null,null,null,null,null,null,1,{"$f":"FormatAngle(DDtoDMS(DEGREES(I50)),6)","v":"+45°21'01.006817\""}]
[null,null,null,null,null,null,2,{"$f":"FormatAngle(DDtoDMS(DEGREES(I51)),6)","v":"+45°20'58.649624\""}]
[null,null,null,null,null,null,"3  - Final",{"$f":"FormatAngle(DDtoDMS(DEGREES(I52)),6)","v":"+45°20'58.649597\""}]

{"sheet":"WCCS_Cylindric","index":6,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":false,"merged":[[13,18,13,19]]}
["WCCS Transverse Mercator Cylindric Systems"]
[]
[null,"Units",{"$f":"Comps!C4","v":"Survey Ft"},"M, F, S",{"$f":"VLOOKUP($C$3,Units,3,FALSE)","v":"survey feet"}]
[null,"County",{"$f":"Comps!C15","v":"Polk"},null,{"$f":"VLOOKUP($C$4,WisCylin,1,FALSE)&\" County\"","v":"Polk County"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Comps!D15","v":45.14},"d.ms","N",{"$f":"Comps!F16","v":65825.648000000001},{"$f":"E3","v":"survey feet"}]
[null,"Long (l)",{"$f":"Comps!E15","v":92.13},"d.ms","E",{"$f":"Comps!G16","v":582246.76899999997},{"$f":"E3","v":"survey feet"}]
[null,"N",{"$f":"C53","v":208919.2567664893},{"$f":"E3","v":"survey feet"},"Lat (f)",{"$f":"H55","v":"+44°50'26.723394\""}]
[null,"E",{"$f":"C54","v":572350.9902556506},{"$f":"E3","v":"survey feet"},"Long (l)",{"$f":"H56","v":"+92°10'52.891669\""}]
[null,"g",{"$f":"C62","v":"+0°17'44.980\""},null,"g",{"$f":"H64","v":"+0°19'07.349\""}]
[null,"k",{"$f":"C63","v":1.0000131574110278},null,"k",{"$f":"H65","v":1.0000156964067528}]
[]
["Zone Parameters",null,null,null,null,null,null,null,null,null,"County Parameters - Conic",null,null,null,null,null,null,null,"Enlarged Ellipsoid"]
[null,"County",{"$f":"VLOOKUP($C$4,WisCylin,1,FALSE)","v":"Polk"},null,null,null,null,null,null,null,null,"Elev","Geoid Ht","Long O","Lat O","False E","False N","Scale factor","a","b"]
["lo","Cen Mer",{"$f":"VLOOKUP($C$4,WisCylin,4,FALSE)","v":92.38},{"$f":"RADIANS(DMStoDD(C16))","v":1.6167566637640804},"radians",null,"Enlarged Ellipsoid",null,null,null," ","(m)","(m)","(d.ms)","(d.ms)","(m)","(m)",null,"(m)","(m)"]
["ko","Scale- 1:",{"$f":"IF(D17=1,\" infinity\",ABS(1/(1-D17)))","v":" infinity"},{"$f":"VLOOKUP($C$4,WisCylin,8,FALSE)","v":1},null,null,"a",{"$f":"VLOOKUP($C$4,WisCylin,9,FALSE)*VLOOKUP($C$3,Units,2,FALSE)","v":20926512.185605831},{"$f":"$E$3","v":"survey feet"},null,"Adams",274.32100000000003,-35.049999999999997,90,43.22,147218.69450000001,0,0.99999899999999997,{"$f":"'GRS80_&_Units'!$C$5+L17+M17","v":6378376.2710000006},{"$f":"'GRS80_&_Units'!$C$6+L17+M17","v":6356991.5851403475}]
["lo","Origin Long",{"$f":"VLOOKUP($C$4,WisCylin,4,FALSE)","v":92.38},{"$f":"RADIANS(DMStoDD(C18))","v":1.6167566637640804},"radians",null,"b",{"$f":"VLOOKUP($C$4,WisCylin,10,FALSE)*VLOOKUP($C$3,Units,2,FALSE)","v":20856352.59541462},{"$f":"$E$3","v":"survey feet"},null,"Ashland",365.76,-30.84,90.372,45.422199999999997,172821.94560000001,0,0.99999700000000002,{"$f":"'GRS80_&_Units'!$C$5+L18+M18","v":6378471.9199999999},{"$f":"'GRS80_&_Units'!$C$6+L18+M18","v":6357087.2341403468}]
["fo","Origin Lat",{"$f":"VLOOKUP($C$4,WisCylin,5,FALSE)","v":44.393999999999998},{"$f":"RADIANS(DMStoDD(C19))","v":0.77948343648791185},"radians",null,"f",{"$f":"(H17-H18)/H17","v":3.3526652491794777E-3},null,null,"Barron",365.76100000000002,-29.83,91.51,45.08,93150,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L19+M19","v":6378472.9309999999},{"$f":"'GRS80_&_Units'!$C$6+L19+M19","v":6357088.2451403467}]
["No","Origin N",{"$f":"VLOOKUP($C$4,WisCylin,7,FALSE)","v":0},{"$f":"C20*VLOOKUP($C$3,Units,2,FALSE)","v":0},{"$f":"$E$3","v":"survey feet"},null,"e",{"$f":"SQRT((H17^2-H18^2)/H17^2)","v":8.1817419502731886E-2},null,null,"Brown",35.799999999999997,-35.799999999999997,88,43,31600,4600,1.0000199999999999,{"$f":"'GRS80_&_Units'!$C$5+L20+M20","v":6378137},{"$f":"'GRS80_&_Units'!$C$6+L20+M20","v":6356752.3141403468}]
["Eo","Origin E",{"$f":"VLOOKUP($C$4,WisCylin,6,FALSE)","v":141732.28339999999},{"$f":"C21*VLOOKUP($C$3,Units,2,FALSE)","v":464999.99978816661},{"$f":"$E$3","v":"survey feet"},null,"e'",{"$f":"SQRT((H17^2-H18^2)/H18^2)","v":8.2092648673151455E-2},null,null,"Buffalo",274.32100000000003,-30.33,91.474999999999994,43.285299999999999,175260.3505,0,1,{"$f":"'GRS80_&_Units'!$C$5+L21+M21","v":6378380.9910000004},{"$f":"'GRS80_&_Units'!$C$6+L21+M21","v":6356996.3051403472}]
[null,null,null,null,null,null,null,null,null,null,"Calumet",243.84,-35.75,88.3,42.430999999999997,244754.88949999999,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L22+M22","v":6378345.0899999999},{"$f":"'GRS80_&_Units'!$C$6+L22+M22","v":6356960.4041403467}]
["Zone Constants",null,null,null,null,null,null,null,null,null,"Clark",365.76100000000002,-32.36,90.423000000000002,43.36,199949.1998,0,0.99999400000000005,{"$f":"'GRS80_&_Units'!$C$5+L23+M23","v":6378470.4009999996},{"$f":"'GRS80_&_Units'!$C$6+L23+M23","v":6357085.7151403464}]
[null,"n",{"$f":"(H17-H18)/(H17+H18)","v":1.6791474342152102E-3},null,null,null,null,null,null,null,"Dodge",274.32100000000003,-34.51,88.462999999999994,41.281999999999996,263347.7267,0,0.99999700000000002,{"$f":"'GRS80_&_Units'!$C$5+L24+M24","v":6378376.8110000007},{"$f":"'GRS80_&_Units'!$C$6+L24+M24","v":6356992.1251403475}]
[null,"r",{"$f":"H17*(1-C24)*(1-C24^2)*(1+9*C24^2/4+225*C24^4/64)","v":20891447.116549805},{"$f":"$E$3","v":"survey feet"},null,null,null,null,null,null,"Door",213.36,-36.44,87.162000000000006,44.24,158801.1176,0,0.99999099999999996,{"$f":"'GRS80_&_Units'!$C$5+L25+M25","v":6378313.9199999999},{"$f":"'GRS80_&_Units'!$C$6+L25+M25","v":6356929.2341403468}]
[null,"u2",{"$f":"-3*C24/2+9*C24^3/16","v":-2.5187184882133552E-3},null,"v2",{"$f":"3*C24/2-27*C24^3/32","v":2.5187171566586251E-3},null,null,null,null,"Douglas",304.8,-26.87,91.55,45.53,59131.31826,0,0.99999496799999998,{"$f":"'GRS80_&_Units'!$C$5+L26+M26","v":6378414.9299999997},{"$f":"'GRS80_&_Units'!$C$6+L26+M26","v":6357030.2441403465}]
[null,"u4",{"$f":"15*C24^2/16-15*C24^4/32","v":2.6433113727558726E-6},null,"v4",{"$f":"21*C24^2/16-55*C24^4/32","v":3.7006274752128793E-6},null,null,null,null,"Dunn",304.80099999999999,-28.78,91.534000000000006,44.243000000000002,51816.103999999999,0,0.99999773000000003,{"$f":"'GRS80_&_Units'!$C$5+L27+M27","v":6378413.0209999997},{"$f":"'GRS80_&_Units'!$C$6+L27+M27","v":6357028.3351403465}]
[null,"u6",{"$f":"-35*C24^3/48","v":-3.4521789296342745E-9},null,"v6",{"$f":"151*C24^3/96","v":7.4468431196396493E-9},null,null,null,null,"Florence",426.721,-32.869999999999997,88.082999999999998,45.262,133502.66699999999,0,0.99999349999999998,{"$f":"'GRS80_&_Units'!$C$5+L28+M28","v":6378530.8509999998},{"$f":"'GRS80_&_Units'!$C$6+L28+M28","v":6357146.1651403466}]
[null,"u8",{"$f":"315*C24^4/512","v":4.8909802996242023E-12},null,"v8",{"$f":"1097*C24^4/512","v":1.7033032979961111E-11},null,null,null,null,"Fond du Lac",243.84,-35.75,88.3,42.430999999999997,244754.88949999999,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L29+M29","v":6378345.0899999999},{"$f":"'GRS80_&_Units'!$C$6+L29+M29","v":6356960.4041403467}]
[null,"U0",{"$f":"2*(C26-2*C27+3*C28-4*C29)","v":-5.0480309741191536E-3},null,"V0",{"$f":"2*(F26-2*F27+3*F28-4*F29)","v":5.0226763482108527E-3},null,null,null,null,"Forest",487.68099999999998,-33.159999999999997,88.38,44.002000000000002,275844.55160000001,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L30+M30","v":6378591.5209999997},{"$f":"'GRS80_&_Units'!$C$6+L30+M30","v":6357206.8351403465}]
[null,"U2",{"$f":"8*(C27-4*C28+10*C29)","v":2.1257351986219248E-5},null,"V2",{"$f":"8*(F27-4*F28+10*F29)","v":2.9368083464512964E-5},null,null,null,null,"Grant",274.32100000000003,-32.44,90.48,41.244,242316.4847,0,0.99999700000000002,{"$f":"'GRS80_&_Units'!$C$5+L31+M31","v":6378378.8810000001},{"$f":"'GRS80_&_Units'!$C$6+L31+M31","v":6356994.1951403469}]
[null,"U4",{"$f":"32*(C28-6*C29)","v":-1.1140879396582463E-7},null,"V4",{"$f":"32*(F28-6*F29)","v":2.3502863749631624E-7},null,null,null,null,"Iowa",304.80099999999999,-33.76,90.093999999999994,42.322000000000003,113081.02619999999,0,0.99999700000000002,{"$f":"'GRS80_&_Units'!$C$5+L32+M32","v":6378408.0410000002},{"$f":"'GRS80_&_Units'!$C$6+L32+M32","v":6357023.355140347}]
[null,"U6",{"$f":"128*C29","v":6.260454783518979E-10},null,"V6",{"$f":"128*F29","v":2.1802282214350222E-9},null,null,null,null,"Iron",487.68099999999998,-30.39,90.152000000000001,45.26,220980.44200000001,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L33+M33","v":6378594.2910000002},{"$f":"'GRS80_&_Units'!$C$6+L33+M33","v":6357209.605140347}]
[null,"wo",{"$f":"D19+SIN(D19)*COS(D19)*(C30+C31*COS(D19)^2+C32*COS(D19)^4+C33*COS(D19)^6)","v":0.77696496020910999},null,null,null,null,null,null,null,"Jefferson",274.32100000000003,-34.51,88.462999999999994,41.281999999999996,263347.7267,0,0.99999700000000002,{"$f":"'GRS80_&_Units'!$C$5+L34+M34","v":6378376.8110000007},{"$f":"'GRS80_&_Units'!$C$6+L34+M34","v":6356992.1251403475}]
[null,"So",{"$f":"D17*C34*C25","v":16231922.377620844},{"$f":"$E$3","v":"survey feet"},null,null,null,null,null,null,"Juneau",274.32100000000003,-35.049999999999997,90,43.22,147218.69450000001,0,0.99999899999999997,{"$f":"'GRS80_&_Units'!$C$5+L35+M35","v":6378376.2710000006},{"$f":"'GRS80_&_Units'!$C$6+L35+M35","v":6356991.5851403475}]
[null,null,null,null,null,null,null,null,null,null,"Kenosha",213.36,-34.659999999999997,87.534000000000006,42.13,185928.3719,0,0.99999800000000005,{"$f":"'GRS80_&_Units'!$C$5+L36+M36","v":6378315.7000000002},{"$f":"'GRS80_&_Units'!$C$6+L36+M36","v":6356931.014140347}]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion",null,null,null,null,"Kewaunee",182.88,-34.020000000000003,87.33,43.16,79857.759999999995,0,1,{"$f":"'GRS80_&_Units'!$C$5+L37+M37","v":6378285.8600000003},{"$f":"'GRS80_&_Units'!$C$6+L37+M37","v":6356901.1741403472}]
[null,"Lat (f)",{"$f":"C7","v":45.14},{"$f":"RADIANS(DMStoDD(C38))","v":0.78947059831876842},"radians",null,"N",{"$f":"F7","v":65825.648000000001},{"$f":"$E$3","v":"survey feet"},null,"LaCrosse",274.32100000000003,-32.020000000000003,91.19,43.270400000000002,130454.6609,0,0.99999400000000005,{"$f":"'GRS80_&_Units'!$C$5+L38+M38","v":6378379.3010000009},{"$f":"'GRS80_&_Units'!$C$6+L38+M38","v":6356994.6151403477}]
[null,"Long (l)",{"$f":"C8","v":92.13},{"$f":"RADIANS(DMStoDD(C39))","v":1.6094844585474373},"radians",null,"E",{"$f":"F8","v":582246.76899999997},{"$f":"$E$3","v":"survey feet"},null,"Lincoln",426.721,-31.9,89.44,44.503999999999998,116129.03230000001,0,0.99999800000000005,{"$f":"'GRS80_&_Units'!$C$5+L39+M39","v":6378531.8209999995},{"$f":"'GRS80_&_Units'!$C$6+L39+M39","v":6357147.1351403464}]
[null,"L",{"$f":"(D39-D16)*COS(D38)","v":-5.1212416604101158E-3},null,null,null,"w",{"$f":"(H38-D20+C35)/(D17*C25)","v":0.78011580216049659},null,null,"Manitowoc",182.88,-34.020000000000003,87.33,43.16,79857.759999999995,0,1,{"$f":"'GRS80_&_Units'!$C$5+L40+M40","v":6378285.8600000003},{"$f":"'GRS80_&_Units'!$C$6+L40+M40","v":6356901.1741403472}]
[null,"w",{"$f":"D38+SIN(D38)*COS(D38)*(C30+C31*COS(D38)^2+C32*COS(D38)^4+C33*COS(D38)^6)","v":0.78695192376896406},null,null,null,"ff",{"$f":"H40+(SIN(H40)*COS(H40))*(F30+F31*COS(H40)^2+F32*COS(H40)^4+F33*COS(H40)^6)","v":0.78263444949978267},null,null,"Marinette",274.32100000000003,-35.28,87.424000000000007,44.412999999999997,238658.8774,0,0.99998600000000004,{"$f":"'GRS80_&_Units'!$C$5+L41+M41","v":6378376.0410000002},{"$f":"'GRS80_&_Units'!$C$6+L41+M41","v":6356991.355140347}]
[null,"S",{"$f":"D17*C41*C25","v":16440564.498686446},{"$f":"$E$3","v":"survey feet"},null,null,"tf",{"$f":"TAN(H41)","v":0.99448779233530016},null,null,"Menominee",304.80099999999999,-35.200000000000003,88.25,44.43,105461.01089999999,0,0.99999400000000005,{"$f":"'GRS80_&_Units'!$C$5+L42+M42","v":6378406.6009999998},{"$f":"'GRS80_&_Units'!$C$6+L42+M42","v":6357021.9151403466}]
[null,"t",{"$f":"TAN(D38)","v":1.0081782203239131},null,null,null,"hf2",{"$f":"H21^2*COS(H41)^2","v":3.3882266171425981E-3},null,null,"Milwaukee",213.36,-34.659999999999997,87.534000000000006,42.13,185928.3719,0,0.99999800000000005,{"$f":"'GRS80_&_Units'!$C$5+L43+M43","v":6378315.7000000002},{"$f":"'GRS80_&_Units'!$C$6+L43+M43","v":6356931.014140347}]
[null,"h2",{"$f":"H21^2*COS(D38)^2","v":3.3421568210292478E-3},null,null,null,"Rf",{"$f":"(D17*H17)/SQRT(1-H20^2*SIN(H41)^2)","v":20961426.78561005},{"$f":"$E$3","v":"survey feet"},null,"Oconto",243.84,-35.42,87.543000000000006,44.234999999999999,182880.3658,0,0.99999099999999996,{"$f":"'GRS80_&_Units'!$C$5+L44+M44","v":6378345.4199999999},{"$f":"'GRS80_&_Units'!$C$6+L44+M44","v":6356960.7341403468}]
[null,"R",{"$f":"(D17*H17)/SQRT(1-H20^2*SIN(D38)^2)","v":20961908.016049102},{"$f":"$E$3","v":"survey feet"},null,null,"Q",{"$f":"(H39-D21)/H44","v":5.593453652321171E-3},null,null,"Outagamie",243.84,-35.75,88.3,42.430999999999997,244754.88949999999,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L45+M45","v":6378345.0899999999},{"$f":"'GRS80_&_Units'!$C$6+L45+M45","v":6356960.4041403467}]
[null,"A1",{"$f":"-C45","v":-20961908.016049102},null,null,null,"B2",{"$f":"-H42/2*(1+H43)","v":-0.49892867117185696},null,null,"Ozaukee",213.36,-34.659999999999997,87.534000000000006,42.13,185928.3719,0,0.99999800000000005,{"$f":"'GRS80_&_Units'!$C$5+L46+M46","v":6378315.7000000002},{"$f":"'GRS80_&_Units'!$C$6+L46+M46","v":6356931.014140347}]
[null,"A2",{"$f":"C45*C43/2","v":10566669.559106976},null,null,null,"B3",{"$f":"-(1+2*H42^2+H43)/6","v":-0.49690002747083678},null,null,"Polk",304.80099999999999,-28.13,92.38,44.393999999999998,141732.28339999999,0,1,{"$f":"'GRS80_&_Units'!$C$5+L47+M47","v":6378413.6710000001},{"$f":"'GRS80_&_Units'!$C$6+L47+M47","v":6357028.9851403469}]
[null,"A3",{"$f":"(1-C43^2+C44)/6","v":-2.1801945190772468E-3},null,null,null,"B4",{"$f":"-(5+3*H42^2+H43*(1-9*H42^2)-4*H43^2)/12","v":-0.66168345220577041},null,null,"Price",457.20100000000002,-30.31,90.292000000000002,44.332000000000001,227990.856,0,0.99999800000000005,{"$f":"'GRS80_&_Units'!$C$5+L48+M48","v":6378563.8910000008},{"$f":"'GRS80_&_Units'!$C$6+L48+M48","v":6357179.2051403476}]
[null,"A4",{"$f":"(5-C43^2+C44*(9+4*C44))/12","v":0.33447506395855298},null,null,null,"B5",{"$f":"(5+28*H42^2+24*H42^4+H43*(6+8*H42^2))/120","v":0.46845409726302267},null,null,"Racine",213.36,-34.659999999999997,87.534000000000006,42.13,185928.3719,0,0.99999800000000005,{"$f":"'GRS80_&_Units'!$C$5+L49+M49","v":6378315.7000000002},{"$f":"'GRS80_&_Units'!$C$6+L49+M49","v":6356931.014140347}]
[null,"A5",{"$f":"(5-18*C43^2+C43^4+C44*(14-58*C43^2))/120","v":-0.10343951615268959},null,null,null,"B6",{"$f":"(61+90*H42^2+45*H42^4+H43*(46-252*H42^2-90*H42^4))/360","v":0.53622126030637696},null,null,"Rock",274.32100000000003,-33.65,89.042000000000002,41.564,146304.29259999999,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L50+M50","v":6378377.6710000001},{"$f":"'GRS80_&_Units'!$C$6+L50+M50","v":6356992.9851403469}]
[null,"A6",{"$f":"(61-58*C43^2+C43^4+C44*(270-330*C43^2))/360","v":7.9497797193383291E-3},null,null,null,"B7",{"$f":"-(61+662*H42^2+1320*H42^4+720*H42^6)/5040","v":-0.53638299000284717},null,null,"Rusk",365.76100000000002,-30.01,91.04,43.551000000000002,250546.1011,0,0.99999700000000002,{"$f":"'GRS80_&_Units'!$C$5+L51+M51","v":6378472.7510000002},{"$f":"'GRS80_&_Units'!$C$6+L51+M51","v":6357088.065140347}]
[null,"A7",{"$f":"(61-479*C43^2+179*C43^4-C43^6)/5040","v":-4.8013695416196746E-2},null,null,null,"L",{"$f":"H45*(1+H45^2*(H47+H45^2*(H49+H51*H45^2)))","v":5.5933666969641103E-3},null,null,"Sauk",304.80099999999999,-34.520000000000003,89.54,42.491,185623.57130000001,0,0.99999499999999997,{"$f":"'GRS80_&_Units'!$C$5+L52+M52","v":6378407.2810000004},{"$f":"'GRS80_&_Units'!$C$6+L52+M52","v":6357022.5951403473}]
[null,"N",{"$f":"C42-C35+D20+C47*C40^2*(1+C40^2*(C49+C51*C40^2))","v":208919.2567664893},{"$f":"$E$3","v":"survey feet"},null,null,"Lat (f)",{"$f":"H41+H46*H45^2*(1+H45^2*(H48+H50*H45^2))","v":0.78261883997941684},null,null,"Shawano",304.80099999999999,-35.75,88.361999999999995,44.021000000000001,262433.32490000001,0,0.99999000000000005,{"$f":"'GRS80_&_Units'!$C$5+L53+M53","v":6378406.051},{"$f":"'GRS80_&_Units'!$C$6+L53+M53","v":6357021.3651403468}]
[null,"E",{"$f":"D21+C46*C40*(1+C40^2*(C48+C40^2*(C50+C52*C40^2)))","v":572350.9902556506},{"$f":"$E$3","v":"survey feet"},null,null,"Long (l)",{"$f":"D18-(H52/COS(H41))","v":1.608868219969501},null,null,"Sheboygan",182.88,-34.020000000000003,87.33,43.16,79857.759999999995,0,1,{"$f":"'GRS80_&_Units'!$C$5+L54+M54","v":6378285.8600000003},{"$f":"'GRS80_&_Units'!$C$6+L54+M54","v":6356901.1741403472}]
[null,null,null,null,null,null,"Lat (f)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H53)),6)","v":"+44°50'26.723394\""},null,null,"St. Croix",304.80099999999999,-29.29,92.38,44.021000000000001,165506.731,0,0.99999499999999997,{"$f":"'GRS80_&_Units'!$C$5+L55+M55","v":6378412.5109999999},{"$f":"'GRS80_&_Units'!$C$6+L55+M55","v":6357027.8251403468}]
[null,"C1",{"$f":"-C43","v":-1.0081782203239131},null,null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H54)),6)","v":"+92°10'52.891669\""},null,null,"Trempealeau",274.32100000000003,-31.23,91.22,43.094000000000001,256946.91380000001,0,0.99999800000000005,{"$f":"'GRS80_&_Units'!$C$5+L56+M56","v":6378380.091},{"$f":"'GRS80_&_Units'!$C$6+L56+M56","v":6356995.4051403468}]
[null,"C3",{"$f":"(1+3*C44+2*C44^2)/3","v":0.3366829368291735},null,null,null,null,null,null,null,"Washington",304.80099999999999,-34.659999999999997,88.034999999999997,42.5505,120091.4402,0,0.99999499999999997,{"$f":"'GRS80_&_Units'!$C$5+L57+M57","v":6378407.1409999998},{"$f":"'GRS80_&_Units'!$C$6+L57+M57","v":6357022.4551403467}]
[null,"C5",{"$f":"(2-C43^2)/15","v":6.5571778404300479E-2},null,null,null,"D1",{"$f":"H42","v":0.99448779233530016},null,null,"Waukesha",274.32100000000003,-34.450000000000003,88.132999999999996,42.341000000000001,208788.41759999999,0,0.99999700000000002,{"$f":"'GRS80_&_Units'!$C$5+L58+M58","v":6378376.8710000003},{"$f":"'GRS80_&_Units'!$C$6+L58+M58","v":6356992.1851403471}]
[null,"F2",{"$f":"(1+C44)/2","v":0.50167107841051461},null,null,null,"D3",{"$f":"-(1+H42^2-H43-2*H43^2)/3","v":-0.66186492744252601},null,null,"Waupaca",274.32100000000003,-36.07,88.49,43.251300000000001,185013.97010000001,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L59+M59","v":6378375.2510000002},{"$f":"'GRS80_&_Units'!$C$6+L59+M59","v":6356990.565140347}]
[null,"F4",{"$f":"(5-4*C43^2+C44*(9-24*C43^2))/12","v":7.3571417346985898E-2},null,null,null,"D5",{"$f":"(2+5*H42^2+3*H42^4)/15","v":0.65862855108595741},null,null,"Winnebago",243.84,-35.75,88.3,42.430999999999997,244754.88949999999,0,0.999996,{"$f":"'GRS80_&_Units'!$C$5+L60+M60","v":6378345.0899999999},{"$f":"'GRS80_&_Units'!$C$6+L60+M60","v":6356960.4041403467}]
[null,"g",{"$f":"C56*C40*(1+C40^2*(C57+C58*C40^2))","v":5.1631698948101604E-3},"radians",null,null,"G2",{"$f":"(1+H43)/2","v":0.50169411330857128}]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C61)),3)","v":"+0°17'44.980\""},null,null,null,"G4",{"$f":"(1+5*H43)/12","v":8.4745094423809411E-2}]
[null,"k",{"$f":"D17*(1+C59*C40^2*(1+C60*C40^2))","v":1.0000131574110278},null,null,null,"g",{"$f":"H58*H45*(1+H45^2*(H59+H60*H45^2))","v":5.5625061893571767E-3}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H63)),3)","v":"+0°19'07.349\""}]
[null,null,null,null,null,null,"k",{"$f":"D17*(1+H61*H45^2*(1+H62*H45^2))","v":1.0000156964067528}]

{"sheet":"GRS80_&_Units","index":7,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Ellipsoid and Units"]
[]
["GRS 80 Ellipsoid Parameters"]
[]
[null,"a",6378137,"semimajor axis, meters","fixed"]
[null,"b",{"$f":"C5-C5*C7","v":6356752.3141403468},"semiminor axis; meters","computed"]
[null,"f",{"$f":"1/298.25722210088","v":3.3528106811836675E-3},"flattening","fixed"]
[null,"e2",{"$f":"(C5^2-C6^2)/C5^2","v":6.6943800229035668E-3},"first eccentricity squared","computed"]
[null,"e' 2",{"$f":"(C5^2-C6^2)/C6^2","v":6.7394967754817754E-3},"second eccentricity squared","computed"]
[]
["Unit Conversion Constants"]
[null,"Unit","Multiply units by:"]
[null,"Meters",1,"meters"]
[null,"Int'l Ft",{"$f":"1000/(25.4*12)","v":3.2808398950131239},"int'l feet"]
[null,"Survey Ft",{"$f":"39.37/12","v":3.2808333333333333},"survey feet"]
[]
[null,"Note - Base units are meters."]
[null,null," The above conversions are multipiers"]