{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Spiral Comps","Graphics"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":6,"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":"Spiral Comps","index":0,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Spiral Computations, v1.2",null,null,null,null,null,null,null,null,null,"2023-12-16"]
["PI Station",6300,null,null,null,"Random comp"]
["Total ∆",38,"DD.MMSSs",null,null,"Spiral arc",180]
["R for Circular Arc",2500,null,null,null,"Defl ang",{"$f":"IF(G5=\"too long\",\"\",FormatAngle(ddtodms((G5/$B$5)^2*($B$9/3)),1))","v":"+0°27'00.1\""}]
["Spiral Length, Ls",275,null,null,null,"Chord",{"$f":"IF(G3>B5,\"too long\",G3)","v":180}]
[]
["Spiral Components",null,null,null,"Arc Components",null,null,null,null,"Stationing"]
["D change rate, k",{"$f":"G8/B5","v":8.3339345454545456E-3},"deg/linear unit",null,null,"Deg Curve",{"$f":"5729.58/B4","v":2.2918319999999999},"Dec deg",null,"Spiral Tangent, Ts",{"$f":"B12-B4*SIN(RADIANS(B9))+(B4+G16)*TAN(RADIANS(DMStoDD(B3)/2))","v":998.77631331602504}]
["Spiral Angle, ∆s",{"$f":"(B5*G8)/200","v":3.1512689999999997},"Dec Deg",null,null,null,{"$f":"FormatAngle(ddtodms(G8),1)","v":"+2°17'30.6\""},"DMS",null,"TS",{"$f":"B2-K8","v":5301.2236866839748}]
["Spiral Angle, ∆s",{"$f":"FormatAngle(ddtodms(B9),1)","v":"+3°09'04.6\""},null,null,null,"Central angle, ∆c",{"$f":"(DMStoDD(B3)-2*B9)","v":31.697462000000002},"Dec deg",null,"SC",{"$f":"K9+B5","v":5576.2236866839748}]
["Spiral Defl angle, A",{"$f":"FormatAngle(ddtodms(B9/3),1)","v":"+1°03'01.5\""},null,null,null,null,{"$f":"FormatAngle(ddtodms(G10),1)","v":"+31°41'50.9\""},"DMS",null,"CS",{"$f":"K10+G12","v":6959.2858832149595}]
["Tan dist to end, X",{"$f":"B5-B14^2/(2*B5)","v":274.95378986677053},"Approx Method",null,null,"Arc length, Lc",{"$f":"100*G10/G8","v":1383.0621965309849},null,null,"ST Bk",{"$f":"K11+B5","v":7234.2858832149595}]
[null,{"$f":"N25","v":274.91682414928806},"Power Series",null,null,"Long chord, LCC",{"$f":"2*B4*SIN(RADIANS(G10)/2)","v":1365.4926532143427},null,null,"ST Ah",{"$f":"B2+K8","v":7298.7763133160252}]
["Tan offset to end, Y",{"$f":"B5*SIN(RADIANS(B9/3))","v":5.0413860471318284},"Approx Method",null,null,"Tangent, TC",{"$f":"B4*TAN(RADIANS(G10/2))","v":709.72579565114881}]
[null,{"$f":"O25","v":5.0405774113929933},"Power Series",null,null,"Tan dist to OPC, xo",{"$f":"B12-B4*SIN(RADIANS(B9))","v":137.52305320837169}]
[null,null,null,null,null,"Tan offset to OPC, o",{"$f":"B14-B4*(1-COS(RADIANS(B9)))","v":1.261086438411323}]
["Five-chord Spiral"]
["Chord Length",{"$f":"$B$5/5","v":55}]
[null,"Entrance","Exit","Approx method",null,null,null,"Tangent Offset Method",null,null,null,null,"Power series"]
["Num","Sta","Sta","Arc dist, li","Radius, Ri","Defl ang, ai",null,"Dist, xi","Offset, yi","Chord, ci","Defl ang, ai",null,"δi, radians","Tan dist, xi","Tan offset, yi","Chord, ci","Defl ang, ai"]
[1,{"$f":"K9+$B$18","v":5356.2236866839748},{"$f":"C22-$B$18","v":6959.2858832149595},{"$f":"B18","v":55},{"$f":"$B$4*$B$5/D21","v":12500},{"$f":"FormatAngle(ddtodms((D21/$B$5)^2*($B$9/3)),1)","v":"+0°02'31.3\""},null,{"$f":"D21-I21^2/(2*D21)","v":54.99998521111111},{"$f":"D21^3/(6*$B$4*$B$5)","v":4.0333333333333332E-2},{"$f":"SQRT(H21^2+I21^2)","v":55.00000000000199},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I21/H21))),1)","v":"+0°02'31.3\""},null,{"$f":"(D21^2/(2*$B$4*$B$5))","v":2.2000000000000001E-3},{"$f":"D21*(1-M21^2/(5*FACT(2))+M21^4/(9*FACT(4))-M21^6/(13*FACT(6))+M21^8/(17*FACT(8)))","v":54.999973380005969},{"$f":"D21*(M21/3-M21^3/(7*FACT(3))+M21^5/(11*FACT(5))-M21^7/(15*FACT(7)))","v":4.033331938952596E-2},{"$f":"SQRT(N21^2+O21^2)","v":54.9999881688898},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O21/N21))),1)","v":"+0°02'31.3\""}]
[2,{"$f":"B21+$B$18","v":5411.2236866839748},7014.2858832149595,{"$f":"D21+$B$18","v":110},{"$f":"$B$4*$B$5/D22","v":6250},{"$f":"FormatAngle(ddtodms((D22/$B$5)^2*($B$9/3)),1)","v":"+0°10'05.0\""},null,{"$f":"D22-I22^2/(2*D22)","v":109.99952675555555},{"$f":"D22^3/(6*$B$4*$B$5)","v":0.32266666666666666},{"$f":"SQRT(H22^2+I22^2)","v":110.00000000101799},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I22/H22))),1)","v":"+0°10'05.0\""},null,{"$f":"(D22^2/(2*$B$4*$B$5))","v":8.8000000000000005E-3},{"$f":"D22*(1-M22^2/(5*FACT(2))+M22^4/(9*FACT(4))-M22^6/(13*FACT(6))+M22^8/(17*FACT(8)))","v":109.999148163054},{"$f":"D22*(M22/3-M22^3/(7*FACT(3))+M22^5/(11*FACT(5))-M22^7/(15*FACT(7)))","v":0.32266488186344539},{"$f":"SQRT(N22^2+O22^2)","v":109.99962140490982},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O22/N22))),1)","v":"+0°10'05.0\""}]
[3,{"$f":"B22+$B$18","v":5466.2236866839748},7069.2858832149595,{"$f":"D22+$B$18","v":165},{"$f":"$B$4*$B$5/D23","v":4166.666666666667},{"$f":"FormatAngle(ddtodms((D23/$B$5)^2*($B$9/3)),1)","v":"+0°22'41.3\""},null,{"$f":"D23-I23^2/(2*D23)","v":164.99640629999999},{"$f":"D23^3/(6*$B$4*$B$5)","v":1.089},165.00000003913539,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I23/H23))),1)","v":"+0°22'41.4\""},null,{"$f":"(D23^2/(2*$B$4*$B$5))","v":1.9800000000000002E-2},{"$f":"D23*(1-M23^2/(5*FACT(2))+M23^4/(9*FACT(4))-M23^6/(13*FACT(6))+M23^8/(17*FACT(8)))","v":164.99353145740511},{"$f":"D23*(M23/3-M23^3/(7*FACT(3))+M23^5/(11*FACT(5))-M23^7/(15*FACT(7)))","v":1.088969505268965},{"$f":"SQRT(N23^2+O23^2)","v":164.99712505789043},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O23/N23))),1)","v":"+0°22'41.3\""}]
[4,5521.2236866839748,{"$f":"C25-$B$18","v":7124.2858832149595},{"$f":"D23+$B$18","v":220},{"$f":"$B$4*$B$5/D24","v":3125},{"$f":"FormatAngle(ddtodms((D24/$B$5)^2*($B$9/3)),1)","v":"+0°40'20.2\""},null,{"$f":"D24-I24^2/(2*D24)","v":219.98485617777777},{"$f":"D24^3/(6*$B$4*$B$5)","v":2.5813333333333333},220.00000052121672,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I24/H24))),1)","v":"+0°40'20.2\""},null,{"$f":"(D24^2/(2*$B$4*$B$5))","v":3.5200000000000002E-2},{"$f":"D24*(1-M24^2/(5*FACT(2))+M24^4/(9*FACT(4))-M24^6/(13*FACT(6))+M24^8/(17*FACT(8)))","v":219.97274268360542},{"$f":"D24*(M24/3-M24^3/(7*FACT(3))+M24^5/(11*FACT(5))-M24^7/(15*FACT(7)))","v":2.5811048869645252},{"$f":"SQRT(N24^2+O24^2)","v":219.98788518049167},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O24/N24))),1)","v":"+0°40'20.1\""}]
[5,5576.2236866839748,{"$f":"K12-$B$18","v":7179.2858832149595},{"$f":"D24+$B$18","v":275},{"$f":"$B$4*$B$5/D25","v":2500},{"$f":"FormatAngle(ddtodms((D25/$B$5)^2*($B$9/3)),1)","v":"+1°03'01.5\""},null,{"$f":"D25-I25^2/(2*D25)","v":274.95378472222222},{"$f":"D25^3/(6*$B$4*$B$5)","v":5.041666666666667},275.00000388336707,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I25/H25))),1)","v":"+1°03'01.7\""},null,{"$f":"(D25^2/(2*$B$4*$B$5))","v":5.5E-2},{"$f":"D25*(1-M25^2/(5*FACT(2))+M25^4/(9*FACT(4))-M25^6/(13*FACT(6))+M25^8/(17*FACT(8)))","v":274.91682414928806},{"$f":"D25*(M25/3-M25^3/(7*FACT(3))+M25^5/(11*FACT(5))-M25^7/(15*FACT(7)))","v":5.0405774113929933},{"$f":"SQRT(N25^2+O25^2)","v":274.96302955301252},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O25/N25))),1)","v":"+1°03'01.4\""}]
[]
["Ten-chord Spiral"]
["Chord Length",{"$f":"$B$5/10","v":27.5}]
[null,"Entrance","Exit","Approx method",null,null,null,null,null,null,null,null,"Power series"]
["Num","Sta","Sta","Arc dist, li","Radius, ri","Defl ang, ai",null,"Dist, xi","Offset, yi","Chord, ci","Defl ang, ai",null,"δi, radians","Tan dist, xi","Tan offset, yi","Chord, ci","Defl ang, ai"]
[1,{"$f":"K9+$B$28","v":5328.7236866839748},{"$f":"C32-$B$28","v":6959.2858832149595},{"$f":"B28","v":27.5},{"$f":"$B$4*$B$5/D31","v":25000},{"$f":"FormatAngle(ddtodms((D31/$B$5)^2*($B$9/3)),1)","v":"+0°00'37.8\""},null,{"$f":"D31-I31^2/(2*D31)","v":27.499999537847224},{"$f":"D31^3/(6*$B$4*$B$5)","v":5.0416666666666665E-3},{"$f":"SQRT(H31^2+I31^2)","v":27.500000000000004},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I31/H31))),1)","v":"+0°00'37.8\""},null,{"$f":"(D31^2/(2*$B$4*$B$5))","v":5.5000000000000003E-4},{"$f":"D31*(1-M31^2/(5*FACT(2))+M31^4/(9*FACT(4))-M31^6/(13*FACT(6))+M31^8/(17*FACT(8)))","v":27.499999168125015},{"$f":"D31*(M31/3-M31^3/(7*FACT(3))+M31^5/(11*FACT(5))-M31^7/(15*FACT(7)))","v":5.0416665577306553E-3},{"$f":"SQRT(N31^2+O31^2)","v":27.499999630277784},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O31/N31))),1)","v":"+0°00'37.8\""}]
[2,{"$f":"B31+$B$28","v":5356.2236866839748},6986.7858832149595,{"$f":"D31+$B$28","v":55},12500,{"$f":"FormatAngle(ddtodms((D32/$B$5)^2*($B$9/3)),1)","v":"+0°02'31.3\""},null,54.99998521111111,4.0333333333333332E-2,{"$f":"SQRT(H32^2+I32^2)","v":55.00000000000199},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I32/H32))),1)","v":"+0°02'31.3\""},null,2.2000000000000001E-3,54.999973380005969,4.033331938952596E-2,{"$f":"SQRT(N32^2+O32^2)","v":54.9999881688898},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O32/N32))),1)","v":"+0°02'31.3\""}]
[3,{"$f":"B32+$B$28","v":5383.7236866839748},7014.2858832149595,{"$f":"D32+$B$28","v":82.5},8333.3333333333339,{"$f":"FormatAngle(ddtodms((D33/$B$5)^2*($B$9/3)),1)","v":"+0°05'40.3\""},null,82.499887696875007,0.136125,82.50000000007644,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I33/H33))),1)","v":"+0°05'40.3\""},null,4.9500000000000004E-3,82.49979785460431,0.1361247617571277,{"$f":"SQRT(N33^2+O33^2)","v":82.499910157534941},{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O33/N33))),1)","v":"+0°05'40.3\""}]
[4,5411.2236866839748,7041.7858832149595,110,6250,{"$f":"FormatAngle(ddtodms((D34/$B$5)^2*($B$9/3)),1)","v":"+0°10'05.0\""},null,109.99952675555555,0.32266666666666666,110.00000000101799,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I34/H34))),1)","v":"+0°10'05.0\""},null,8.8000000000000005E-3,109.999148163054,0.32266488186344539,109.99962140490982,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O34/N34))),1)","v":"+0°10'05.0\""}]
[5,5438.7236866839748,7069.2858832149595,137.5,5000,{"$f":"FormatAngle(ddtodms((D35/$B$5)^2*($B$9/3)),1)","v":"+0°15'45.4\""},null,137.49855577256943,0.63020833333333337,137.50000000758467,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I35/H35))),1)","v":"+0°15'45.4\""},null,1.375E-2,137.49740041337901,0.63019982275859998,137.49884462152284,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O35/N35))),1)","v":"+0°15'45.4\""}]
[6,5466.2236866839748,7096.7858832149595,165,4166.666666666667,{"$f":"FormatAngle(ddtodms((D36/$B$5)^2*($B$9/3)),1)","v":"+0°22'41.3\""},null,164.99640629999999,1.089,165.00000003913539,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I36/H36))),1)","v":"+0°22'41.4\""},null,1.9800000000000002E-2,164.99353145740511,1.088969505268965,164.99712505789043,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O36/N36))),1)","v":"+0°22'41.3\""}]
[7,5493.7236866839748,7124.2858832149595,192.5,3571.4285714285716,{"$f":"FormatAngle(ddtodms((D37/$B$5)^2*($B$9/3)),1)","v":"+0°30'52.9\""},null,192.49223259826388,1.7292916666666667,192.50000015670784,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I37/H37))),1)","v":"+0°30'53.0\""},null,2.6950000000000002E-2,192.48601914699071,1.7292019552498339,192.49378615024881,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O37/N37))),1)","v":"+0°30'52.9\""}]
[8,5521.2236866839748,7151.7858832149595,220,3125,{"$f":"FormatAngle(ddtodms((D38/$B$5)^2*($B$9/3)),1)","v":"+0°40'20.2\""},null,219.98485617777777,2.5813333333333333,220.00000052121672,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I38/H38))),1)","v":"+0°40'20.2\""},null,3.5200000000000002E-2,219.97274268360542,2.5811048869645252,219.98788518049167,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O38/N38))),1)","v":"+0°40'20.1\""}]
[9,5548.7236866839748,{"$f":"C40-$B$28","v":7179.2858832149595},247.5,2777.7777777777778,{"$f":"FormatAngle(ddtodms((D39/$B$5)^2*($B$9/3)),1)","v":"+0°51'03.0\""},null,247.47271034062501,3.6753749999999998,247.50000150449597,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I39/H39))),1)","v":"+0°51'03.1\""},null,4.4549999999999999E-2,247.45088312640624,3.6748539953342623,247.47816896026481,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O39/N39))),1)","v":"+0°51'03.0\""}]
[10,5576.2236866839748,{"$f":"K12-$B$28","v":7206.7858832149595},275,2500,{"$f":"FormatAngle(ddtodms((D40/$B$5)^2*($B$9/3)),1)","v":"+1°03'01.5\""},null,274.95378472222222,5.041666666666667,275.00000388336707,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(I40/H40))),1)","v":"+1°03'01.7\""},null,5.5E-2,274.91682414928806,5.0405774113929933,274.96302955301252,{"$f":"FormatAngle(ddtodms(DEGREES(ATAN(O40/N40))),1)","v":"+1°03'01.4\""}]

{"sheet":"Graphics","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}