{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Conversion","SPC","UTM","Conic","Cylindric","GRS80_&_Units"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":14,"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":"Conversion","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Iowa NAD 83 Coordinate Conversions"]
["Version 0.5 - 1/07/26"]
[null,null,"Select units"]
[null,null,"from list",null,null,"This workbook DOES NOT not convert coordinates between datum realizations"]
[null,"Units","Survey Ft","Enter values to convert in the colored cells"]
[]
[null,null,null,"Lat (DD.MMSSss)","Long (DD.MMSSss)",{"$f":" \"North (\"&C5&\")\"","v":"North (Survey Ft)"},{"$f":" \"East (\"&C5&\")\"","v":"East (Survey Ft)"},"Convergence","Grid Scale"]
[null,"State Plane","North",43.19435,90.273700000000005,{"$f":"SPC!C9","v":3961840.2074806131},{"$f":"SPC!C10","v":5729930.0806082916},{"$f":"SPC!C11","v":"+2°03'36.559\""},{"$f":"SPC!C12","v":1.0000119345405813}]
[null,null,null,{"$f":"SPC!F9","v":"+33°01'25.951412\""},{"$f":"SPC!F10","v":"+101°37'40.658373\""},300000,2400000,{"$f":"SPC!F11","v":"-5°30'31.252\""},{"$f":"SPC!F12","v":1.0135431013363376}]
[]
[null,"UTM","14N",43.182016922999999,95.464457523999997,{"$f":"UTM!C9","v":15747316.012479769},{"$f":"UTM!C10","v":2497494.6875167191},{"$f":"UTM!C11","v":"+2°12'37.666\""},{"$f":"UTM!C12","v":1.0004395817774308}]
[null,null,null,{"$f":"UTM!F9","v":"+43°18'20.169230\""},{"$f":"UTM!F10","v":"+95°46'44.575240\""},15747316.012499999,2497494.6875,{"$f":"UTM!F11","v":"+2°12'37.666\""},{"$f":"UTM!F12","v":1.0004395813770384}]
[]
[null,"Conic","Spencer",43.182016922999999,95.464457523999997,{"$f":"Conic!C9","v":9638938.5122315139},{"$f":"Conic!C10","v":11359164.493505035},{"$f":"Conic!C11","v":"-0°21'43.771\""},{"$f":"Conic!C37","v":1.0000536935664828}]
[null,"See Map",null,{"$f":"Conic!F9","v":"+43°18'20.169230\""},{"$f":"Conic!F10","v":"+95°46'44.575240\""},9638938.5121999998,11359164.4935,{"$f":"Conic!F11","v":"-0°21'43.771\""},{"$f":"Conic!G46","v":1.0000536935664801}]
[]
[null,"Cylindric","Council Bluffs",41.132638362000002,95.511159336000006,{"$f":"Cylindric!C9","v":6954894.9804267846},{"$f":"Cylindric!C10","v":16467018.155491151},{"$f":"Cylindric!C11","v":"-0°04'44.422\""},{"$f":"Cylindric!C12","v":1.0000402431834046}]
[null,"See Map",null,{"$f":"Cylindric!F9","v":"+41°13'26.383620\""},{"$f":"Cylindric!F10","v":"+95°51'11.593360\""},6954894.9803999998,16467018.1555,{"$f":"Cylindric!F11","v":"-0°04'44.422\""},{"$f":"Cylindric!F12","v":1.0000402431834039}]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"SPC","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["SPC -  Lambert Conic"]
[]
[null,"Units",{"$f":"Conversion!C5","v":"Survey Ft"},null,{"$f":"VLOOKUP($C$3,Units,3,FALSE)","v":"to get survey feet"}]
[null,"Zone",{"$f":"Conversion!C8","v":"North"},null,{"$f":"HLOOKUP($C$4,ZoneInfo,2,FALSE)&\" Zone\"","v":"North Zone"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Conversion!D8","v":43.19435},"d.ms","N",{"$f":"Conversion!F9","v":300000},{"$f":"E3","v":"to get survey feet"}]
[null,"Long (l)",{"$f":"Conversion!E8","v":90.273700000000005},"d.ms","E",{"$f":"Conversion!G9","v":2400000},{"$f":"E3","v":"to get survey feet"}]
[null,"N",{"$f":"C41","v":3961840.2074806131},{"$f":"E3","v":"to get survey feet"},"Lat (f)",{"$f":"H43","v":"+33°01'25.951412\""}]
[null,"E",{"$f":"C42","v":5729930.0806082916},{"$f":"E3","v":"to get survey feet"},"Long (l)",{"$f":"H42","v":"+101°37'40.658373\""}]
[null,"g",{"$f":"C39","v":"+2°03'36.559\""},null,"g",{"$f":"H44","v":"-5°30'31.252\""}]
[null,"k",{"$f":"C40","v":1.0000119345405813},null,"k",{"$f":"H45","v":1.0135431013363376}]
[]
["Zone Parameters",null,null,null,null,null,null,null,null,null,"Wis SPC Parameters"]
[null,"Code",{"$f":"HLOOKUP($C$4,ZoneInfo,3,FALSE)","v":1401},null,null,null,null,null,null,null,null,"Zone","North","South"]
["fs","Std Par S",{"$f":"HLOOKUP($C$4,ZoneInfo,4,FALSE)","v":42.04},{"$f":"RADIANS(DMStoDD(C16))","v":0.73420183867228128},"radians",null,"Ellipsoid",null,null,null,null,"Name","North","South"]
["fn","Std Par N",{"$f":"HLOOKUP($C$4,[0]!ZoneInfo,5,FALSE)","v":43.16},{"$f":"RADIANS(DMStoDD(C17))","v":0.75514578969621315},"radians",null,"a",{"$f":"'GRS80_&_Units'!C4*VLOOKUP($C$3,Units,2,FALSE)","v":20925604.474166665},{"$f":"$E$3","v":"to get survey feet"},null,null,"Code",1401,1402]
["lo","Origin Long",{"$f":"HLOOKUP($C$4,ZoneInfo,6,FALSE)","v":93.3},{"$f":"RADIANS(DMStoDD(C18))","v":1.6318828506146978},"radians",null,"b",{"$f":"'GRS80_&_Units'!C5*VLOOKUP($C$3,Units,2,FALSE)","v":20855444.883975454},{"$f":"$E$3","v":"to get survey feet"},null,"fs","Std Par S",42.04,40.369999999999997,"d.ms"]
["fb","Origin Lat",{"$f":"HLOOKUP($C$4,ZoneInfo,7,FALSE)","v":41.3},{"$f":"RADIANS(DMStoDD(C19))","v":0.72431163957764666},"radians",null,"f",{"$f":"'GRS80_&_Units'!C6","v":3.3528106811836675E-3},null,null,"fn","Std Par N",43.16,41.47,"d.ms"]
["Nb","Origin N",{"$f":"HLOOKUP($C$4,ZoneInfo,8,FALSE)","v":1000000},{"$f":"C20*VLOOKUP($C$3,Units,2,FALSE)","v":3280833.3333333335},{"$f":"$E$3","v":"to get survey feet"},null,"e",{"$f":"SQRT('GRS80_&_Units'!C7)","v":8.1819191042832778E-2},null,null,"lo","Origin Long",93.3,93.3,"d.ms"]
["Eo","Origin E",{"$f":"HLOOKUP($C$4,ZoneInfo,9,FALSE)","v":1500000},{"$f":"C21*VLOOKUP($C$3,Units,2,FALSE)","v":4921250},{"$f":"$E$3","v":"to get survey feet"},null,"e'",{"$f":"SQRT('GRS80_&_Units'!C8)","v":8.209443815193436E-2},null,null,"fb","Origin Lat",41.3,40,"d.ms"]
[null,null,null,null,null,null,null,null,null,null,"Nb","Origin N",1000000,0,"meters"]
["Zone Constants",null,null,null,null,null,null,null,null,null,"Eo","Origin E",1500000,500000,"meters"]
[null,null,"Q","W",null,null,"fo",{"$f":"ASIN((LN(D26*COS(D16)/(D25*COS(D17))))/(C26-C25))","v":0.74469090597452936},"radians"]
[null,"South (Qs)",{"$f":"Q(H20,D16)","v":0.80624406415890937},{"$f":"W(H20,D16)","v":0.99849633904280977},null,null,null,{"$f":"FormatAngle(DDtoDMS(DEGREES(H24)),3)","v":"+42°40'03.525\""},"Central Latitude"]
[null,"North (Qn)",{"$f":"Q(H20,D17)","v":0.83462525459597214},{"$f":"W(H20,D17)","v":0.99842636550310804},null,null,"K",{"$f":"(H17*COS(D16)*EXP(C25*SIN(H24)))/(D25*SIN(H24))","v":39645498.45990859},{"$f":"$E$3","v":"to get survey feet"}]
[null,"Grid Origin (Qb)",{"$f":"Q(H20,D19)","v":0.79302993124926346},null,null,null,"Rb",{"$f":"H26/(EXP(C27*SIN(H24)))","v":23161830.40284441},{"$f":"$E$3","v":"to get survey feet"}]
[null,"Central (Qo)",{"$f":"Q(H20,H24)","v":0.82038883560817089},{"$f":"W(H20,H24)","v":0.99846132568665602},null,null,"Ro",{"$f":"H26/(EXP(C28*SIN(H24)))","v":22736312.903680231},{"$f":"$E$3","v":"to get survey feet"}]
[null,null,null,null,null,null,"ko",{"$f":"(D28*TAN(H24)*H28)/(H17)","v":0.99994536787025134}]
[null,null,null,null,null,null,"No",{"$f":"H27+D20-H28","v":3706350.8324975111},{"$f":"$E$3","v":"to get survey feet"}]
[]
[]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"C7","v":43.19435},{"$f":"RADIANS(DMStoDD(C34))","v":0.75622934827349308},"radians",null,"N",{"$f":"F7","v":300000},{"$f":"$E$3","v":"to get survey feet"}]
[null,"Long (l)",{"$f":"C8","v":90.273700000000005},{"$f":"RADIANS(DMStoDD(C35))","v":1.5788296894908818},"radians",null,"E",{"$f":"F8","v":2400000},{"$f":"$E$3","v":"to get survey feet"}]
[null,"Q",{"$f":"Q(H20,D34)","v":0.83610877211143619},null,null,null,"R'",{"$f":"H27-H34+D20","v":26142663.736177742},{"$f":"$E$3","v":"to get survey feet"}]
[null,"R",{"$f":"H26/(EXP(C36*SIN(H24)))","v":22495363.74458513},null,null,null,"E'",{"$f":"H35-D21","v":-2521250},{"$f":"$E$3","v":"to get survey feet"}]
[null,"g",{"$f":"(D18-D35)*SIN(H24)","v":3.5956491702918175E-2},"radians",null,null,"g",{"$f":"ATAN(H37/H36)","v":-9.614462396048111E-2},"radians"]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C38)),3)","v":"+2°03'36.559\""},null,null,null,"R",{"$f":"SQRT(H36^2+H37^2)","v":26263959.503193017}]
[null,"k",{"$f":"SQRT((1-H20^2*SIN(D34)^2))*(C37*SIN(H24))/(H17*COS(D34))","v":1.0000119345405813},null,null,null,"Q",{"$f":"(LN(H26/H39))/(SIN(H24))","v":0.60757369607848755}]
[null,"N",{"$f":"H27+D20-C37*COS(C38)","v":3961840.2074806131},{"$f":"$E$3","v":"to get survey feet"},null,null,"Long",{"$f":"D18-(H38/SIN(H24))","v":1.7737425255882198},"radians"]
[null,"E",{"$f":"D21+C37*SIN(C38)","v":5729930.0806082916},{"$f":"$E$3","v":"to get survey feet"},null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H41)),6)","v":"+101°37'40.658373\""}]
[null,null,null,null,null,null,"Lat (f)",{"$f":"H58","v":"+33°01'25.951412\""}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H38)),3)","v":"-5°30'31.252\""}]
[null,null,null,null,null,null,"k",{"$f":"SQRT(1-H20^2*SIN(I52)^2)*(H39*SIN(H24)/(H17*COS(I52)))","v":1.0135431013363376}]
[]
[null,null,null,null,null,null,"Latitude comps - iterative"]
[null,null,null,null,null,null,null,"f","f (radians)",null,"f1","f2","(-f1/f2)"]
[null,null,null,null,null,null,"initial",{"$f":"(EXP(2*H40)-1)/(EXP(2*H40)+1)","v":0.5424169066964506},{"$f":"ASIN(H49)","v":0.57331134143400775},null,{"$f":"Q($H$20,I49)-$H$40","v":-3.6335316863785883E-3},{"$f":"1/(1-H49^2)-$H$20^2/(1-$H$20^2*H49^2)","v":1.4101566939009806},{"$f":"-K49/L49","v":2.5766864789521964E-3}]
[null,null,null,null,null,null,1,{"$f":"H49+M49","v":0.54499359317540275},{"$f":"ASIN(H50)","v":0.57638147335587819},null,{"$f":"Q($H$20,I50)-$H$40","v":7.2600762566210619E-6},{"$f":"1/(1-H50^2)-$H$20^2/(1-$H$20^2*H50^2)","v":1.415803845728673},{"$f":"-K50/L50","v":-5.1278828479834448E-6}]
[null,null,null,null,null,null,2,{"$f":"H50+M50","v":0.54498846529255474},{"$f":"ASIN(H51)","v":0.57637535738886858},null,{"$f":"Q($H$20,I51)-$H$40","v":2.8997693135579539E-11},{"$f":"1/(1-H51^2)-$H$20^2/(1-$H$20^2*H51^2)","v":1.4157925359021137},{"$f":"-K51/L51","v":-2.0481597691926528E-11}]
[null,null,null,null,null,null,3,{"$f":"H51+M51","v":0.54498846527207312},{"$f":"ASIN(H52)","v":0.57637535736444057}]
[]
[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":"+32°50'53.952760\""}]
[null,null,null,null,null,null,1,{"$f":"FormatAngle(DDtoDMS(DEGREES(I50)),6)","v":"+33°01'27.212926\""}]
[null,null,null,null,null,null,2,{"$f":"FormatAngle(DDtoDMS(DEGREES(I51)),6)","v":"+33°01'25.951417\""}]
[null,null,null,null,null,null,3,{"$f":"FormatAngle(DDtoDMS(DEGREES(I52)),6)","v":"+33°01'25.951412\""},"final Lat"]

{"sheet":"UTM","index":2,"n_rows":66,"n_cols":15,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
["Transverse Mercator Cylindric"]
[]
[null,"Units",{"$f":"Conversion!C5","v":"Survey Ft"},"M, F, S",{"$f":"VLOOKUP($C$3,Units,3,FALSE)","v":"to get survey feet"}]
[null,"Zone",{"$f":"Conversion!C11","v":"14N"},"14, 15",{"$f":"HLOOKUP($C$4,TMZoneInfo,2,FALSE)&\" Zone\"","v":"14N Zone"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Conversion!D11","v":43.182016922999999},"d.ms","N",{"$f":"Conversion!F12","v":15747316.012499999},{"$f":"E3","v":"to get survey feet"}]
[null,"Long (l)",{"$f":"Conversion!E11","v":95.464457523999997},"d.ms","E",{"$f":"Conversion!G12","v":2497494.6875},{"$f":"E3","v":"to get survey feet"}]
[null,"N",{"$f":"C54","v":15747316.012479769},{"$f":"E3","v":"to get survey feet"},"Lat (f)",{"$f":"H56","v":"+43°18'20.169230\""}]
[null,"E",{"$f":"C55","v":2497494.6875167191},{"$f":"E3","v":"to get survey feet"},"Long (l)",{"$f":"H57","v":"+95°46'44.575240\""}]
[null,"g",{"$f":"C63","v":"+2°12'37.666\""},null,"g",{"$f":"H65","v":"+2°12'37.666\""}]
[null,"k",{"$f":"C64","v":1.0004395817774308},null,"k",{"$f":"H66","v":1.0004395813770384}]
[]
["Zone Parameters",null,null,null,null,null,null,null,null,null,"UTM Parameters"]
[null,"Code",{"$f":"HLOOKUP($C$4,TMZoneInfo,1,FALSE)","v":"14N"},null,null,null,null,null,null,null,null,"Code","15N","14N"]
[null,"Name",{"$f":"HLOOKUP($C$4,TMZoneInfo,2,FALSE)","v":"14N"},null,null,null,"Ellipsoid",null,null,null,null,"Name","15N","14N"]
["lo","Cen Mer",{"$f":"HLOOKUP($C$4,TMZoneInfo,3,FALSE)","v":99},{"$f":"RADIANS(DMStoDD(C17))","v":1.7278759594743862},"radians",null,"a",{"$f":"'GRS80_&_Units'!C4*VLOOKUP($C$3,Units,2,FALSE)","v":20925604.474166665},{"$f":"$E$3","v":"to get survey feet"},null,"lo","Cen Mer",93,99,"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'!C5*VLOOKUP($C$3,Units,2,FALSE)","v":20855444.883975454},{"$f":"$E$3","v":"to get survey feet"},null,null,"Scale- 1:",2500,2500]
["lo","Origin Long",{"$f":"HLOOKUP($C$4,TMZoneInfo,5,FALSE)","v":99},{"$f":"RADIANS(DMStoDD(C19))","v":1.7278759594743862},"radians",null,"f",{"$f":"'GRS80_&_Units'!C6","v":3.3528106811836675E-3},null,null,"lo","Origin Long",93,99,"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'!C7)","v":8.1819191042832778E-2},null,null,"fo","Origin Lat",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":"to get survey feet"},null,"e'",{"$f":"SQRT('GRS80_&_Units'!C8)","v":8.209443815193436E-2},null,null,"No","Origin N",0,0,"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":"to get survey feet"},null,null,null,null,null,"Eo","Origin E",500000,500000,"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":"to get 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":"to get survey feet"}]
[]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"DMStoDD(C7)","v":43.30560256388889},{"$f":"RADIANS(C39)","v":0.75582534929995915},"radians",null,"N",{"$f":"F7","v":15747316.012499999},{"$f":"$E$3","v":"to get survey feet"}]
[null,"Long (l)",{"$f":"DMStoDD(C8)","v":95.779048677777766},{"$f":"RADIANS(C40)","v":1.6716597538551434},"radians",null,"E",{"$f":"F8","v":2497494.6875},{"$f":"$E$3","v":"to get survey feet"}]
[null,"L",{"$f":"(D40-D17)*COS(D39)","v":-4.0908852849663412E-2},null,null,null,"w",{"$f":"(H39-D21+C36)/(D18*C26)","v":0.75410295318402953}]
[null,"w",{"$f":"D39+SIN(D39)*COS(D39)*(C31+C32*COS(D39)^2+C33*COS(D39)^4+C34*COS(D39)^6)","v":0.75331124115223869},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.75661730232098301}]
[null,"S",{"$f":"D18*C42*C26","v":15730783.336818427},{"$f":"$E$3","v":"to get survey feet"},null,null,"tf",{"$f":"TAN(H42)","v":0.94403358555739725}]
[null,"t",{"$f":"TAN(D39)","v":0.94253696307811585},null,null,null,"hf2",{"$f":"H21^2*COS(H42)^2","v":3.5636098115790576E-3}]
[null,"h2",{"$f":"H21^2*COS(D39)^2","v":3.56893809116426E-3},null,null,null,"Rf",{"$f":"(D18*H17)/SQRT(1-H20^2*SIN(H42)^2)","v":20950305.52801},{"$f":"$E$3","v":"to get survey feet"}]
[null,"R",{"$f":"(D18*H17)/SQRT(1-H20^2*SIN(D39)^2)","v":20950249.911883801},{"$f":"$E$3","v":"to get survey feet"},null,null,"Q",{"$f":"(H40-D22)/H45","v":4.0910048766947232E-2}]
[null,"A1",{"$f":"-C46","v":-20950249.911883801},null,null,null,"B2",{"$f":"-H43/2*(1+H44)","v":-0.47369887645267483}]
[null,"A2",{"$f":"C46*C44/2","v":9873192.4638372604},null,null,null,"B3",{"$f":"-(1+2*H43^2+H44)/6","v":-0.4643270718553818}]
[null,"A3",{"$f":"(1-C44^2+C45)/6","v":1.9198835220441125E-2},null,null,null,"B4",{"$f":"-(5+3*H43^2+H44*(1-9*H43^2)-4*H44^2)/12","v":-0.63737733848816369}]
[null,"A4",{"$f":"(5-C44^2+C45*(9+4*C45))/12","v":0.34531628877736287},null,null,null,"B5",{"$f":"(5+28*H43^2+24*H43^4+H44*(6+8*H43^2))/120","v":0.40885038002119523}]
[null,"A5",{"$f":"(5-18*C44^2+C44^4+C45*(14-58*C44^2))/120","v":-8.6129018041546754E-2},null,null,null,"B6",{"$f":"(61+90*H43^2+45*H43^4+H44*(46-252*H43^2-90*H43^4))/360","v":0.48904848792492428}]
[null,"A6",{"$f":"(61-58*C44^2+C44^4+C45*(270-330*C44^2))/360","v":2.8279824870770496E-2},null,null,null,"B7",{"$f":"-(61+662*H43^2+1320*H43^4+720*H43^6)/5040","v":-0.4382933741539024}]
[null,"A7",{"$f":"(61-479*C44^2+179*C44^4-C44^6)/5040","v":-4.4437356300630761E-2},null,null,null,"L",{"$f":"H46*(1+H46^2*(H48+H46^2*(H50+H52*H46^2)))","v":4.0878303815453557E-2}]
[null,"N",{"$f":"C43-C36+D21+C48*C41^2*(1+C41^2*(C50+C52*C41^2))","v":15747316.012479769},{"$f":"$E$3","v":"to get survey feet"},null,null,"Lat (f)",{"$f":"H42+H47*H46^2*(1+H46^2*(H49+H51*H46^2))","v":0.75582534929941358}]
[null,"E",{"$f":"D22+C47*C41*(1+C41^2*(C49+C41^2*(C51+C53*C41^2)))","v":2497494.6875167191},{"$f":"$E$3","v":"to get survey feet"},null,null,"Long (l)",{"$f":"D19-(H53/COS(H42))","v":1.6716597538553148}]
[null,null,null,null,null,null,"Lat (f)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H54)),6)","v":"+43°18'20.169230\""}]
[null,"C1",{"$f":"-C44","v":-0.94253696307811585},null,null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H55)),6)","v":"+95°46'44.575240\""}]
[null,"C3",{"$f":"(1+3*C45+2*C45^2)/3","v":0.33691076297056327}]
[null,"C5",{"$f":"(2-C44^2)/15","v":7.4108271548765509E-2},null,null,null,"D1",{"$f":"H43","v":0.94403358555739725}]
[null,"F2",{"$f":"(1+C45)/2","v":0.50178446904558216},null,null,null,"D3",{"$f":"-(1+H43^2-H44-2*H44^2)/3","v":-0.62920346740633282}]
[null,"F4",{"$f":"(5-4*C44^2+C45*(9-24*C44^2))/12","v":0.11687694394356567},null,null,null,"D5",{"$f":"(2+5*H43^2+3*H43^4)/15","v":0.58924708146572491}]
[null,"g",{"$f":"C57*C41*(1+C41^2*(C58+C59*C41^2))","v":3.8579854213251413E-2},"radians",null,null,"G2",{"$f":"(1+H44)/2","v":0.5017818049057895}]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C62)),3)","v":"+2°12'37.666\""},null,null,null,"G4",{"$f":"(1+5*H44)/12","v":8.4818170754824604E-2}]
[null,"k",{"$f":"D18*(1+C60*C41^2*(1+C61*C41^2))","v":1.0004395817774308},null,null,null,"g",{"$f":"H59*H46*(1+H46^2*(H60+H61*H46^2))","v":3.8579854293195201E-2}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H64)),3)","v":"+2°12'37.666\""}]
[null,null,null,null,null,null,"k",{"$f":"D18*(1+H62*H46^2*(1+H63*H46^2))","v":1.0004395813770384}]

{"sheet":"Conic","index":3,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["IARS Single Parallel Conic Systems"]
[]
[null,"Units",{"$f":"Conversion!C5","v":"Survey Ft"}]
[null,"County",{"$f":"Conversion!C14","v":"Spencer"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Conversion!D14","v":43.182016922999999},"d.ms","N",{"$f":"Conversion!F15","v":9638938.5121999998},{"$f":"C3","v":"Survey Ft"}]
[null,"Long (l)",{"$f":"Conversion!E14","v":95.464457523999997},"d.ms","E",{"$f":"Conversion!G15","v":11359164.4935},{"$f":"C3","v":"Survey Ft"}]
[null,"N",{"$f":"C40","v":9638938.5122315139},{"$f":"C3","v":"Survey Ft"},"Lat (f)",{"$f":"FormatAngle(DDtoDMS(DEGREES(G45)),6)","v":"+43°18'20.169230\""}]
[null,"E",{"$f":"C39","v":11359164.493505035},{"$f":"C3","v":"Survey Ft"},"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(-G26)),6)","v":"+95°46'44.575240\""}]
[null,"g",{"$f":"C36","v":"-0°21'43.771\""},null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(G25)),3)","v":"-0°21'43.771\""}]
[null,"k",{"$f":"C37","v":1.0000536935664828},null,"k",{"$f":"G46","v":1.0000536935664801}]
[]
["County Parameters",null,"from table","for computations",null,"Zone Constants"]
[null,"County",{"$f":"VLOOKUP($C$4,IARS_Cone,1,FALSE)","v":"Spencer"},null,null," vo",{"$f":"J17/(SQRT(1-J20^2*SIN(D17)^2))","v":20958503.900170151},null,null,null,null,"County Parameters - WisCRS Conic"]
["lO","CM Long",{"$f":"VLOOKUP($C$4,IARS_Cone,2,FALSE)","v":95.15},{"$f":"RADIANS(DMStoDD(C16))*(-1)","v":-1.6624261125245992},"radians"," ro",{"$f":"(J17*(1-J20^2))/((1-J20^2*SIN(D17)^2)^1.5)","v":20883712.296151198},null,"GRS80 Ellipsoid",null,null,null,"Long (Cen Mer)","False Easting","False Northing","Lat (Cen Par)","Scale"]
["fO","CP Lat",{"$f":"VLOOKUP($C$4,IARS_Cone,5,FALSE)","v":43.12},{"$f":"RADIANS(DMStoDD(C17))","v":0.7539822368615503},"radians"," ro",{"$f":"(C20*G15)/TAN(D17)","v":22319700.352775536},null,"a",{"$f":"'GRS80_&_Units'!C4*VLOOKUP(C3,Units,2,FALSE)","v":20925604.474166665},{"$f":"C3","v":"Survey Ft"},"Zone","(d.ms)","(Meters)","(Meters)","(d.ms)","(Cen Par)"]
["EO","False E",{"$f":"VLOOKUP($C$4,IARS_Cone,3,FALSE)","v":3505207.0104140211},{"$f":"C18*VLOOKUP(C3,Units,2,FALSE)","v":11500000},{"$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'!C5*VLOOKUP(C3,Units,2,FALSE)","v":20855444.883975454},{"$f":"C3","v":"Survey Ft"},"Spencer",95.15,{"$f":"N27*12/39.37","v":3505207.0104140211},{"$f":"O27*12/39.37","v":2926085.8521717046},43.12,1.0000519999999999]
["NO","False N",{"$f":"VLOOKUP($C$4,IARS_Cone,4,FALSE)","v":2926085.8521717046},{"$f":"C19*VLOOKUP(C3,Units,2,FALSE)","v":9600000},{"$f":"C3","v":"Survey Ft"}," A2",{"$f":"(3/8)*(J20^2+J20^4/4+15*J20^6/128)","v":2.5146070728458659E-3},null,"f",{"$f":"'GRS80_&_Units'!C6","v":3.3528106811836675E-3},null,"Mason City",92.45,{"$f":"N28*12/39.37","v":3810007.6200152403},2987045.9740919485,43.1,1.000043]
["kO","CP Scale",{"$f":"VLOOKUP($C$4,IARS_Cone,6,FALSE)","v":1.0000519999999999},null,null," A4",{"$f":"(15/256)*(J20^4+3*J20^6/4)","v":2.639046620233096E-6},null,"e",{"$f":"SQRT('GRS80_&_Units'!C7)","v":8.1819191042832778E-2},null,"Iowa",94.5,{"$f":"N29*12/39.37","v":4419608.8392176786},2621285.2425704855,42.32,1.0000450000000001]
[null,null,null,null,null," A6",{"$f":"(35/3072)*J20^6","v":3.4180461367794719E-9},null,"e'",{"$f":"SQRT('GRS80_&_Units'!C8)","v":8.209443815193436E-2},null,"Warerloo",92.25,{"$f":"N30*12/39.37","v":4724409.4488188978},2712725.4254508512,42.39,1.000032]
[null,null,null,null,null," Mo",{"$f":"J17*(G18*D17-G19*SIN(2*D17)+G20*SIN(4*D17)-G21*SIN(6*D17))","v":15698586.782238444},null,null,null,null,"Cedar Rapids",91.4,{"$f":"N31*12/39.37","v":6248412.4968249938},2438404.8768097539,41.5,1.0000199999999999]
[null,null,null,null,null,null,null,null,null,null,null,"Red Oak-Ottumwa",93.45,{"$f":"N32*12/39.37","v":6858013.7160274321},1889763.7795275592,40.549999999999997,1.0000370000000001]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"C7","v":43.182016922999999},{"$f":"RADIANS(DMStoDD(C25))","v":0.75582534929995915},"radians","g",{"$f":"ATAN((F8-D18)/(G17-F7+D19))","v":-6.3208624502246015E-3},"radians",{"$f":"FormatAngle(DDtoDMS(DEGREES(G25)),3)","v":"-0°21'43.771\""}]
[null,"Long (l)",{"$f":"C8*-1","v":-95.464457523999997},{"$f":"RADIANS(DMStoDD(C26))","v":-1.6716597538551434},"radians","Long (l)",{"$f":"(G25/SIN(D17))+D16","v":-1.6716597538554605},"radians",null,null,null,null,null,"(SFeet)","(SFeet)"]
[null,"Mf",{"$f":"J17*(G18*D25-G19*SIN(2*D25)+G20*SIN(4*D25)-G21*SIN(6*D25))","v":15737078.168777632},null,null,"iterative comps for M",1,2,3,null,null,"Spencer",null,11500000,9600000]
[null,"M",{"$f":"C27-G22","v":38491.386539187282},null,null,"s",{"$f":"F7-D19-(F8-D18)*TAN(G25/2)","v":38493.409785709067},null,null,null,null,"Mason City",null,12500000,9800000]
[null,"M3",{"$f":"C28^3/(6*G16*G15)","v":2.171558017915827E-2},null,null,"Ma",{"$f":"G28/C20","v":38491.408232480979},{"$f":"G29+G37","v":38491.386507644056},{"$f":"H29+H37","v":38491.386507644056},null,null,"Iowa",null,14500000,8600000]
[null,"M4",{"$f":"(C28^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":9.228748545465933E-6},null,null,"M3a",{"$f":"G29^3/(6*G16*G15)","v":2.1715616895117324E-2},{"$f":"H29^3/(6*G16*G15)","v":2.1715580125771298E-2},{"$f":"I29^3/(6*G16*G15)","v":2.1715580125771298E-2},null,null,"Warerloo",null,15500000,8900000]
[null,"M5",{"$f":"(C28^5*(5+3*TAN(D17)^2-3*J21^2-J21^2*COS(D17)^2))/(120*G16^2*G15^2)","v":2.801259212003999E-8},null,null,"M4a",{"$f":"(G29^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":9.2287693503409846E-6},{"$f":"(H29^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":9.2287485152145409E-6},{"$f":"(I29^4*TAN(D17)*(1-4*J21^2*COS(D17)^2))/(24*G16*G15^2)","v":9.2287485152145409E-6},null,null,"Cedar Rapids",null,20500000,8000000]
[null,"M6",{"$f":"(C28^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":3.3364726166322391E-11},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":2.8012671057969693E-8},{"$f":"(H29^5*(5+3*TAN(D17)^2-3*J21^2-J21^2*COS(D17)^2))/(120*G16^2*G15^2)","v":2.8012592005260081E-8},{"$f":"(I29^5*(5+3*TAN(D17)^2-3*J21^2-J21^2*COS(D17)^2))/(120*G16^2*G15^2)","v":2.8012592005260081E-8},null,null,"Red Oak-Ottumwa",null,22500000,6200000]
[null,"M7",{"$f":"(C28^7*(60*TAN(D17)^4+180*TAN(D17)^2+61))/(5040*G16^3*G15^3)","v":7.8909102646725852E-14},null,null,"M6a",{"$f":"(G29^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":3.3364838990289827E-11},{"$f":"(H29^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":3.3364726002270445E-11},{"$f":"(I29^6*TAN(D17)*(7+4*TAN(D17)^2))/(240*G16^2*G15^3)","v":3.3364726002270445E-11}]
[null,"s",{"$f":"C20*(SUM(C28:C33))","v":38493.409817253989},{"$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":7.8909413952961089E-14},{"$f":"(H29^7*(60*TAN(D17)^4+180*TAN(D17)^2+61))/(5040*G16^3*G15^3)","v":7.8909102194070447E-14},{"$f":"(I29^7*(60*TAN(D17)^4+180*TAN(D17)^2+61))/(5040*G16^3*G15^3)","v":7.8909102194070447E-14}]
[null,"g",{"$f":"(D26-D16)*SIN(D17)","v":-6.3208624500076076E-3},"radians",null,"-Fa",{"$f":"(G28/C20)-SUM(G29:G34)","v":-2.1724873709899839E-2},{"$f":"(G28/C20)-SUM(H29:H34)","v":0},{"$f":"(G28/C20)-SUM(I29:I34)","v":0}]
[null,null,{"$f":"FormatAngle(DDtoDMS(DEGREES(C35)),3)","v":"-0°21'43.771\""},null,null,"dF/dM",{"$f":"1+(3*G30+4*G31+5*G32+6*G33+7*G34)/G29","v":1.0000016934663869},{"$f":"1+(3*H30+4*H31+5*H32+6*H33+7*H34)/H29","v":1.0000016934644749},{"$f":"1+(3*I30+4*I31+5*I32+6*I33+7*I34)/I29","v":1.0000016934644749}]
[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.0000536935664828},null,null,"dM",{"$f":"G35/G36","v":-2.1724836919618754E-2},{"$f":"H35/H36","v":0},{"$f":"I35/I36","v":0}]
[null,"DE",{"$f":"(G17-C34)*SIN(C35)","v":-140835.50649496596},null,null,"M",{"$f":"I29+I37","v":38491.386507644056}]
[null,"East",{"$f":"D18+C38","v":11359164.493505035},null,null,"Mf",{"$f":"G22+G38","v":15737078.168746088}]
[null,"North",{"$f":"D19+C34+C38*TAN(C35/2)","v":9638938.5122315139},null,null,"Iterative comps for latitude","fa (radians)","-Ga","dG/df","df"]
[null,null,null,null,null,1,{"$f":"G39/(J17*G18)","v":0.75331124116759707},{"$f":"$G$39-$J$17*($G$18*G41-$G$19*SIN(2*G41)+$G$20*SIN(4*G41)-$G$21*SIN(6*G41))","v":52504.220273185521},{"$f":"$J$17*($G$18-2*$G$19*COS(2*G41)+4*$G$20*COS(4*G41)-6*$G$21*COS(6*G41))","v":20883571.431815576},{"$f":"H41/I41","v":2.5141399039245132E-3}]
[null,null,null,null,null,2,{"$f":"G41+J41","v":0.75582538107152153},{"$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.66355200856924057},{"$f":"$J$17*($G$18-2*$G$19*COS(2*G42)+4*$G$20*COS(4*G42)-6*$G$21*COS(6*G42))","v":20884099.318905432},{"$f":"H42/I42","v":-3.1773072826203089E-8}]
[null,null,null,null,null,3,{"$f":"G42+J42","v":0.75582534929844869},{"$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":20884099.312232964},{"$f":"H43/I43","v":0}]
[null,null,null,null,null,4,{"$f":"G43+J43","v":0.75582534929844869},{"$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":20884099.312232964},{"$f":"H44/I44","v":0}]
[null,null,null,null,null,"Lat (f)",{"$f":"G44+J44","v":0.75582534929844869},"radians",{"$f":"FormatAngle(DDtoDMS(DEGREES(G45)),6)","v":"+43°18'20.169230\""}]
[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.0000536935664801}]

{"sheet":"Cylindric","index":4,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["IARS Transverse Mercator Cylindric Systems"]
[]
[null,"Units",{"$f":"Conversion!C5","v":"Survey Ft"}]
[null,"County",{"$f":"Conversion!C17","v":"Council Bluffs"}]
[]
[null,"Direct Conversion",null,null,"Inverse Conversion"]
[null,"Lat (f)",{"$f":"Conversion!D17","v":41.132638362000002},"d.ms","N",{"$f":"Conversion!F18","v":6954894.9803999998},{"$f":"C3","v":"Survey Ft"}]
[null,"Long (l)",{"$f":"Conversion!E17","v":95.511159336000006},"d.ms","E",{"$f":"Conversion!G18","v":16467018.1555},{"$f":"C3","v":"Survey Ft"}]
[null,"N",{"$f":"C53","v":6954894.9804267846},{"$f":"C3","v":"Survey Ft"},"Lat (f)",{"$f":"H55","v":"+41°13'26.383620\""}]
[null,"E",{"$f":"C54","v":16467018.155491151},{"$f":"C3","v":"Survey Ft"},"Long (l)",{"$f":"H56","v":"+95°51'11.593360\""}]
[null,"g",{"$f":"C62","v":"-0°04'44.422\""},null,"g",{"$f":"H64","v":"-0°04'44.422\""}]
[null,"k",{"$f":"C63","v":1.0000402431834046},null,"k",{"$f":"H65","v":1.0000402431834039}]
[]
["Zone Parameters",null,null,null,null,null,null,"GRS80 Ellipsoid"]
[null,"County",{"$f":"VLOOKUP($C$4,IARS_Cyl,1,FALSE)","v":"Council Bluffs"},null,null,null,null,"a",{"$f":"'GRS80_&_Units'!C4*VLOOKUP(C3,Units,2,FALSE)","v":20925604.474166665},{"$f":"C3","v":"Survey Ft"},"County Parameters - WisCRS Cylindric"]
[null,"lo",{"$f":"VLOOKUP($C$4,IARS_Cyl,2,FALSE)","v":95.44},{"$f":"RADIANS(DMStoDD(C16))","v":1.6708618705759046},"radians",null,null,"b",{"$f":"'GRS80_&_Units'!C5*VLOOKUP(C3,Units,2,FALSE)","v":20855444.883975454},{"$f":"C3","v":"Survey Ft"},null,"Long (Cen Mer)","Lat (Origin)","False Easting","False Northing","Scale"]
[null,"fo",{"$f":"VLOOKUP($C$4,IARS_Cyl,3,FALSE)","v":40.15},{"$f":"RADIANS(DMStoDD(C17))","v":0.70249502392771757},"radians",null,null,"f",{"$f":"'GRS80_&_Units'!C6","v":3.3528106811836675E-3},null,"Zone","(d.ms)","(d.ms)","(meters)","(meters)","(Cen Mer)"]
[null,"ko",{"$f":"VLOOKUP($C$4,IARS_Cyl,6,FALSE)","v":1.0000389999999999},null,null,null,null,"e",{"$f":"Conic!J20","v":8.1819191042832778E-2},null,"Elkader",91.12,40.15,{"$f":"N30*12/39.37","v":4114808.2296164595},{"$f":"O30*12/39.37","v":2529845.0596901197},1.000035]
[null,"No",{"$f":"VLOOKUP($C$4,IARS_Cyl,5,FALSE)","v":2011684.0233680469},{"$f":"C19*VLOOKUP(C3,Units,2,FALSE)","v":6600000},{"$f":"C3","v":"Survey Ft"},null,null,"e'",{"$f":"SQRT('GRS80_&_Units'!C8)","v":8.209443815193436E-2},null,"Council Bluffs",95.44,40.15,{"$f":"N31*12/39.37","v":5029210.058420117},2011684.0233680469,1.0000389999999999]
[null,"Eo",{"$f":"VLOOKUP($C$4,IARS_Cyl,4,FALSE)","v":5029210.058420117},{"$f":"C20*VLOOKUP(C3,Units,2,FALSE)","v":16500000},{"$f":"C3","v":"Survey Ft"},null,null,null,null,null,"Carrol-Atlantic",94.38,40.15,{"$f":"N32*12/39.37","v":5334010.6680213362},2072644.1452882907,1.0000450000000001]
[null,null,null,null,null,null,null,null,null,null,"Ames-Des Moines",93.43,40.15,{"$f":"N33*12/39.37","v":5638811.2776225554},2133604.2672085348,1.0000329999999999]
[null,null,null,null,null,null,null,null,null,null,"Newton",92.49,40.15,{"$f":"N34*12/39.37","v":5943611.8872237746},2194564.3891287786,1.000027]
["Zone Constants",null,null,null,null,null,null,null,null,null,"Dubuque-Davenport",90.32,40.15,{"$f":"N35*12/39.37","v":6553213.1064262129},2316484.6329692663,1.000027]
[null,"n",{"$f":"(I15-I16)/(I15+I16)","v":1.6792203946294406E-3},null,null,null,null,null,null,null,"Fairfield",91.55,40.15,{"$f":"N36*12/39.37","v":7162814.3256286513},1950723.901447803,1.0002]
[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,"Burlington",91.25,40.15,{"$f":"N37*12/39.37","v":7467614.9352298705},1889763.7795275592,1.0000180000000001]
[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,"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,"u6",{"$f":"-35*C24^3/48","v":-3.4526289497048255E-9},null,"v6",{"$f":"151*C24^3/96","v":7.4478138772204098E-9}]
[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,null,null,null,"(SFeet)","(SFeet)"]
[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,"Elkader",null,null,13500000,8300000]
[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,"Council Bluffs",null,null,16500000,6600000]
[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,"Carrol-Atlantic",null,null,17500000,6800000]
[null,"U6",{"$f":"128*C29","v":6.2615429432269579E-10},null,"V6",{"$f":"128*F29","v":2.18060717737142E-9},null,null,null,null,"Ames-Des Moines",null,null,18500000,7000000]
[null,"wo",{"$f":"D17+SIN(D17)*COS(D17)*(C30+C31*COS(D17)^2+C32*COS(D17)^4+C33*COS(D17)^6)","v":0.70001160389311068},null,null,null,null,null,null,null,"Newton",null,null,19500000,7200000]
[null,"So",{"$f":"C18*C34*C25","v":14624190.316791464},{"$f":"C3","v":"Survey Ft"},null,null,null,null,null,null,"Dubuque-Davenport",null,null,21500000,7600000]
[null,null,null,null,null,null,null,null,null,null,"Fairfield",null,null,23500000,6400000]
["Direct Conversion",null,"d.ms",null,null,"Inverse Conversion",null,null,null,null,"Burlington",null,null,24500000,6200000]
[null,"Lat (f)",{"$f":"C7","v":41.132638362000002},{"$f":"RADIANS(DMStoDD(C38))","v":0.71949445142966151},"radians",null,"N",{"$f":"F7","v":6954894.9803999998},{"$f":"C3","v":"Survey Ft"}]
[null,"Long (l)",{"$f":"C8","v":95.511159336000006},{"$f":"RADIANS(DMStoDD(C39))","v":1.6729542942319453},"radians",null,"E",{"$f":"F8","v":16467018.1555},{"$f":"C3","v":"Survey Ft"}]
[null,"L",{"$f":"(D39-D16)*COS(D38)","v":1.5737934028187547E-3},null,null,null,"w",{"$f":"(H38-D19+C35)/(C18*C25)","v":0.71699925237565054}]
[null,"w",{"$f":"D38+SIN(D38)*COS(D38)*(C30+C31*COS(D38)^2+C32*COS(D38)^4+C33*COS(D38)^6)","v":0.7169981639063312},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.71949554063115628}]
[null,"S",{"$f":"C18*C41*C25","v":14979062.557593444},{"$f":"C3","v":"Survey Ft"},null,null,"tf",{"$f":"TAN(H41)","v":0.8761757807325653}]
[null,"t",{"$f":"TAN(D38)","v":0.87617385537034909},null,null,null,"hf2",{"$f":"I19^2*COS(H41)^2","v":3.8126140080901459E-3}]
[null,"h2",{"$f":"I19^2*COS(D38)^2","v":3.8126212850879697E-3},null,null,null,"Rf",{"$f":"(C18*I15)/SQRT(1-I18^2*SIN(H41)^2)","v":20956906.639963828},{"$f":"C3","v":"Survey Ft"}]
[null,"R",{"$f":"(C18*I15)/SQRT(1-I18^2*SIN(D38)^2)","v":20956906.564001761},{"$f":"C3","v":"Survey Ft"},null,null,"Q",{"$f":"(H39-D20)/H44","v":-1.5737935500988892E-3}]
[null,"A1",{"$f":"-C45","v":-20956906.564001761},null,null,null,"B2",{"$f":"-H42/2*(1+H43)","v":-0.43975815039386779}]
[null,"A2",{"$f":"C45*C43/2","v":9180946.810408799},null,null,null,"B3",{"$f":"-(1+2*H42^2+H43)/6","v":-0.4231967685821218}]
[null,"A3",{"$f":"(1-C43^2+C44)/6","v":3.9355332741757766E-2},null,null,null,"B4",{"$f":"-(5+3*H42^2+H43*(1-9*H42^2)-4*H43^2)/12","v":-0.60670537676885228}]
[null,"A4",{"$f":"(5-C43^2+C44*(9+4*C44))/12","v":0.35555759258795866},null,null,null,"B5",{"$f":"(5+28*H42^2+24*H42^4+H43*(6+8*H42^2))/120","v":0.33904643364310511}]
[null,"A5",{"$f":"(5-18*C43^2+C43^4+C44*(14-58*C43^2))/120","v":-6.9544164881058357E-2},null,null,null,"B6",{"$f":"(61+90*H42^2+45*H42^4+H43*(46-252*H42^2-90*H42^4))/360","v":0.43290940351227308}]
[null,"A6",{"$f":"(61-58*C43^2+C43^4+C44*(270-330*C43^2))/360","v":4.7576100379129856E-2},null,null,null,"B7",{"$f":"-(61+662*H42^2+1320*H42^4+720*H42^6)/5040","v":-0.33192074859214005}]
[null,"A7",{"$f":"(61-479*C43^2+179*C43^4-C43^6)/5040","v":-4.0016018901728588E-2},null,null,null,"L",{"$f":"H45*(1+H45^2*(H47+H45^2*(H49+H51*H45^2)))","v":-1.5737919004756564E-3}]
[null,"N",{"$f":"C42-C35+D19+C47*C40^2*(1+C40^2*(C49+C51*C40^2))","v":6954894.9804267846},{"$f":"C3","v":"Survey Ft"},null,null,"Lat (f)",{"$f":"H41+H46*H45^2*(1+H45^2*(H48+H50*H45^2))","v":0.71949445142831159}]
[null,"E",{"$f":"D20+C46*C40*(1+C40^2*(C48+C40^2*(C50+C52*C40^2)))","v":16467018.155491151},{"$f":"C3","v":"Survey Ft"},null,null,"Long (l)",{"$f":"D16-(H52/COS(H41))","v":1.6729542942313815}]
[null,null,null,null,null,null,"Lat (f)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H53)),6)","v":"+41°13'26.383620\""}]
[null,"C1",{"$f":"-C43","v":-0.87617385537034909},null,null,null,"Long (l)",{"$f":"FormatAngle(DDtoDMS(DEGREES(H54)),6)","v":"+95°51'11.593360\""}]
[null,"C3",{"$f":"(1+3*C44+2*C44^2)/3","v":0.33715564533913028}]
[null,"C5",{"$f":"(2-C43^2)/15","v":8.2154625011030574E-2},null,null,null,"D1",{"$f":"H42","v":0.8761757807325653}]
[null,"F2",{"$f":"(1+C44)/2","v":0.50190631064254398},null,null,null,"D3",{"$f":"-(1+H42^2-H43-2*H43^2)/3","v":-0.58794743756102696}]
[null,"F4",{"$f":"(5-4*C43^2+C44*(9-24*C43^2))/12","v":0.15777884003818124},null,null,null,"D5",{"$f":"(2+5*H42^2+3*H42^4)/15","v":0.50709574396577328}]
[null,"g",{"$f":"C56*C40*(1+C40^2*(C57+C58*C40^2))","v":-1.378917784804678E-3},"radians",null,null,"G2",{"$f":"(1+H43)/2","v":0.50190630700404504}]
[null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(C61)),3)","v":"-0°04'44.422\""},null,null,null,"G4",{"$f":"(1+5*H43)/12","v":8.4921922503370897E-2}]
[null,"k",{"$f":"C18*(1+C59*C40^2*(1+C60*C40^2))","v":1.0000402431834046},null,null,null,"g",{"$f":"H58*H45*(1+H45^2*(H59+H60*H45^2))","v":-1.3789177844309626E-3}]
[null,null,null,null,null,null,"g",{"$f":"FormatAngle(DDtoDMS(DEGREES(H63)),3)","v":"-0°04'44.422\""}]
[null,null,null,null,null,null,"k",{"$f":"C18*(1+H61*H45^2*(1+H62*H45^2))","v":1.0000402431834039}]

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