{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Satellite","Entry Elevator"],"read":"whole","date_system":"1900"}

{"sheet":"Satellite","index":0,"n_rows":54,"n_cols":6,"rows_kept":54}
[]
[]
["Mars","Deimos","Phobos","6/sol","12/sol"]
[59354294,109120,27554,{"$f":"A14/6","v":{"v":14773.6666666667,"d":"14773.67"}},{"$f":"A14/12","v":{"v":7386.83333333333,"d":"7386.83"}},"sec Sidereal orbit period"]
[{"v":227939200,"d":"2.28E+08"},23463,9376,{"$f":"($A$9*(D4/(2*PI()))^2)^(1/3)","v":{"v":6186.56338724264,"d":"6186.56"}},{"$f":"($A$9*(E4/(2*PI()))^2)^(1/3)","v":{"v":3897.29071904796,"d":"3897.29"}},"km Semimajor axis"]
[0.0934,0.00033,0.0151,0,0,"eccentricity"]
[24.077,1.3513,2.138,{"$f":"SQRT($A$9/D5)","v":{"v":2.63112232417983,"d":"2.6311"}},{"$f":"SQRT($A$9/E5)","v":{"v":3.3150064010825,"d":"3.3150"}},"km/s orbital speed"]
[{"v":6.4171e+23,"d":"6.417E+23"},1476000000000000,10659000000000000,"na","na","kg Estimated Mass"]
[42828.37,{"$f":"6.673E-020*B8","v":{"v":9.849348e-05,"d":"9.85E-05"}},{"$f":"6.673E-020*C8","v":{"v":0.00071127507,"d":"7.11E-04"}},"na","na","km3/s2 Standard Grav constant"]
[3396,6.2,11.3,"na","na","km Mean radius"]
[{"$f":"1000*A9/A10^2","v":{"v":3.71360906130818,"d":"3.714"}},{"$f":"1000*B9/B10^2","v":{"v":0.00256226534859521,"d":"0.003"}},{"$f":"1000*C9/C10^2","v":{"v":0.00557032712036964,"d":"0.006"}},"na","na"," m/s2 surface gravity"]
[3420,"na","na","na","na","km Entry radius WAG"]
[88775,{"$f":"A13","v":88775},{"$f":"A13","v":88775},"na","na"," sec day"]
[88642,"sync","sync","na","na","sec Sidereal rotation period"]
[0.241,"na","na","na","na","km/s surface rotation speed"]
[1.85,0.93,1.093,"na","na","deg inclination"]
[{"$nulls":4},299792.456,"  km/s speed of light"]
[]
["The View "]
["elevation",0,{"$f":"B20","v":0},{"$f":"B20","v":0},{"$f":"B20","v":0},"deg "]
["beamspread",{"$f":"DEGREES(ASIN(($A$10/B$5)*COS(RADIANS(B20))))","v":{"v":8.32213801827314,"d":"8.32"}},{"$f":"DEGREES(ASIN(($A$10/C$5)*COS(RADIANS(C20))))","v":{"v":21.2354510883116,"d":"21.24"}},{"$f":"DEGREES(ASIN(($A$10/D$5)*COS(RADIANS(D20))))","v":{"v":33.2937455646819,"d":"33.29"}},{"$f":"DEGREES(ASIN(($A$10/E$5)*COS(RADIANS(E20))))","v":{"v":60.6187676779786,"d":"60.62"}},"deg "]
["surface angle",{"$f":"90-(B21+B20)","v":{"v":81.6778619817269,"d":"81.68"}},{"$f":"90-(C21+C20)","v":{"v":68.7645489116885,"d":"68.76"}},{"$f":"90-(D21+D20)","v":{"v":56.7062544353181,"d":"56.71"}},{"$f":"90-(E21+E20)","v":{"v":29.3812323220214,"d":"29.38"}}," deg"]
["coverage",{"$f":"0.5*(1-COS(RADIANS(B22)))","v":{"v":0.42763073775732,"d":"0.4276"}},{"$f":"0.5*(1-COS(RADIANS(C22)))","v":{"v":0.318899317406143,"d":"0.3189"}},{"$f":"0.5*(1-COS(RADIANS(D22)))","v":{"v":0.225534211206587,"d":"0.2255"}},{"$f":"0.5*(1-COS(RADIANS(E22)))","v":{"v":0.0643127181400546,"d":"0.0643"}}," fraction"]
["surface dist",{"$f":"$A$10*RADIANS(B22)","v":{"v":4841.15970926987,"d":"4841"}},{"$f":"$A$10*RADIANS(C22)","v":{"v":4075.76980518737,"d":"4076"}},{"$f":"$A$10*RADIANS(D22)","v":{"v":3361.05803427231,"d":"3361"}},{"$f":"$A$10*RADIANS(E22)","v":{"v":1741.46622689377,"d":"1741"}}," km"]
["sat/gnd dist",{"$f":"$A$10*SIN(RADIANS(B22))/SIN(RADIANS(B21))","v":{"v":23215.9331709927,"d":"23216"}},{"$f":"$A$10*SIN(RADIANS(C22))/SIN(RADIANS(C21))","v":{"v":8739.36839823108,"d":"8739"}},{"$f":"$A$10*SIN(RADIANS(D22))/SIN(RADIANS(D21))","v":{"v":5171.14596045897,"d":"5171"}},{"$f":"$A$10*SIN(RADIANS(E22))/SIN(RADIANS(E21))","v":{"v":1912.08235930815,"d":"1912.08"}}," km"]
["sat/gnd time",{"$f":"2*B25/$E$17","v":{"v":0.154880035880507,"d":"0.155"}},{"$f":"2*C25/$E$17","v":{"v":0.0583027906361398,"d":"0.058"}},{"$f":"2*D25/$E$17","v":{"v":0.0344981726989085,"d":"0.034"}},{"$f":"2*E25/$E$17","v":{"v":0.0127560405276385,"d":"0.013"}}," sec"]
["6s hops",{"$f":"INT(1+(180-B22)/(2*D22))","v":{"v":1,"d":"1.000"}},{"$f":"INT(1+(180-C22)/(2*D22))","v":{"v":1,"d":"1.000"}},null,null," hopcount"]
["6s time",{"$f":"B26+2*B27*D26","v":{"v":0.223876381278324,"d":"0.224"}},{"$f":"C26+2*C27*D26","v":{"v":0.127299136033957,"d":"0.127"}},"ratio",{"$f":"B28/C28","v":{"v":1.7586637918627,"d":"1.76"}}," sec round trip ping time"]
["12s hops",{"$f":"INT(1+(180-B22)/(2*E22))","v":{"v":2,"d":"2.000"}},{"$f":"INT(1+(180-C22)/(2*E22))","v":{"v":2,"d":"2.000"}},null,null," hopcount"]
["12s time",{"$f":"B26+2*B29*E26","v":{"v":0.205904197991061,"d":"0.206"}},{"$f":"C$26+2*C29*E26","v":{"v":0.109326952746694,"d":"0.109"}},"ratio",{"$f":"B30/C30","v":{"v":1.88338001579659,"d":"1.88"}}," sec round trip ping time"]
[]
["elevation",10,{"$f":"B32","v":10},{"$f":"B32","v":10},{"$f":"B32","v":10},"deg "]
["beamspread",{"$f":"DEGREES(ASIN(($A$10/B$5)*COS(RADIANS(B32))))","v":{"v":8.19482993883542,"d":"8.19"}},{"$f":"DEGREES(ASIN(($A$10/C$5)*COS(RADIANS(C32))))","v":{"v":20.8975905212667,"d":"20.90"}},{"$f":"DEGREES(ASIN(($A$10/D$5)*COS(RADIANS(D32))))","v":{"v":32.7239529527543,"d":"32.72"}},{"$f":"DEGREES(ASIN(($A$10/E$5)*COS(RADIANS(E32))))","v":{"v":59.1079804577859,"d":"59.11"}},"deg "]
["surface angle",{"$f":"90-(B33+B32)","v":{"v":71.8051700611646,"d":"71.81"}},{"$f":"90-(C33+C32)","v":{"v":59.1024094787333,"d":"59.10"}},{"$f":"90-(D33+D32)","v":{"v":47.2760470472457,"d":"47.28"}},{"$f":"90-(E33+E32)","v":{"v":20.8920195422141,"d":"20.89"}}," deg"]
["coverage",{"$f":"0.5*(1-COS(RADIANS(B34)))","v":{"v":0.343875401548825,"d":"0.3439"}},{"$f":"0.5*(1-COS(RADIANS(C34)))","v":{"v":0.243247416444346,"d":"0.2432"}},{"$f":"0.5*(1-COS(RADIANS(D34)))","v":{"v":0.16076657627843,"d":"0.1608"}},{"$f":"0.5*(1-COS(RADIANS(E34)))","v":{"v":0.032872923197308,"d":"0.0329"}}," fraction"]
["surface dist",{"$f":"$A$10*RADIANS(B34)","v":{"v":4255.99162102396,"d":"4256"}},{"$f":"$A$10*RADIANS(C34)","v":{"v":3503.08145373866,"d":"3503"}},{"$f":"$A$10*RADIANS(D34)","v":{"v":2802.11661551421,"d":"2802"}},{"$f":"$A$10*RADIANS(E34)","v":{"v":1238.29885845535,"d":"1238"}}," km"]
["sat/gnd dist",{"$f":"$A$10*SIN(RADIANS(B34))/SIN(RADIANS(B33))","v":{"v":22633.7123701836,"d":"22634"}},{"$f":"$A$10*SIN(RADIANS(C34))/SIN(RADIANS(C33))","v":{"v":8169.5325911029,"d":"8170"}},{"$f":"$A$10*SIN(RADIANS(D34))/SIN(RADIANS(D33))","v":{"v":4614.95288126067,"d":"4615"}},{"$f":"$A$10*SIN(RADIANS(E34))/SIN(RADIANS(E33))","v":{"v":1411.24453691831,"d":"1411.24"}}," km"]
["sat/gnd time",{"$f":"2*B37/$E$17","v":{"v":0.150995876762046,"d":"0.151"}},{"$f":"2*C37/$E$17","v":{"v":0.0545012553024543,"d":"0.055"}},{"$f":"2*D37/$E$17","v":{"v":0.0307876518497895,"d":"0.031"}},{"$f":"2*E37/$E$17","v":{"v":0.00941481020401865,"d":"0.009"}}," sec"]
["6s hops",{"$f":"INT(1+(180-B34)/(2*D34))","v":{"v":2,"d":"2.000"}},{"$f":"INT(1+(180-C34)/(2*D34))","v":{"v":2,"d":"2.000"}},null,null," hopcount"]
["6s time",{"$f":"B38+2*B39*D38","v":{"v":0.274146484161204,"d":"0.274"}},{"$f":"C38+2*C39*D38","v":{"v":0.177651862701612,"d":"0.178"}},"ratio",{"$f":"B40/C40","v":{"v":1.54316695582115,"d":"1.54"}}," sec round trip ping time"]
["12s hops",{"$f":"INT(1+(180-B34)/(2*E34))","v":{"v":3,"d":"3.000"}},{"$f":"INT(1+(180-C34)/(2*E34))","v":{"v":3,"d":"3.000"}},null,null," hopcount"]
["12s time",{"$f":"B38+2*B41*E38","v":{"v":0.207484737986158,"d":"0.207"}},{"$f":"C$26+2*C41*E38","v":{"v":0.114791651860252,"d":"0.115"}},"ratio",{"$f":"B42/C42","v":{"v":1.80748978365388,"d":"1.81"}}," sec round trip ping time"]
[]
["elevation",20,{"$f":"B44","v":20},{"$f":"B44","v":20},{"$f":"B44","v":20},"deg "]
["beamspread",{"$f":"DEGREES(ASIN(($A$10/B$5)*COS(RADIANS(B44))))","v":{"v":7.81701134365234,"d":"7.82"}},{"$f":"DEGREES(ASIN(($A$10/C$5)*COS(RADIANS(C44))))","v":{"v":19.8986838184809,"d":"19.90"}},{"$f":"DEGREES(ASIN(($A$10/D$5)*COS(RADIANS(D44))))","v":{"v":31.0527456925644,"d":"31.05"}},{"$f":"DEGREES(ASIN(($A$10/E$5)*COS(RADIANS(E44))))","v":{"v":54.9672690230106,"d":"54.97"}},"deg "]
["surface angle",{"$f":"90-(B45+B44)","v":{"v":62.1829886563477,"d":"62.18"}},{"$f":"90-(C45+C44)","v":{"v":50.1013161815192,"d":"50.10"}},{"$f":"90-(D45+D44)","v":{"v":38.9472543074356,"d":"38.95"}},{"$f":"90-(E45+E44)","v":{"v":15.0327309769894,"d":"15.03"}}," deg"]
["coverage",{"$f":"0.5*(1-COS(RADIANS(B46)))","v":{"v":0.266675372314328,"d":"0.2667"}},{"$f":"0.5*(1-COS(RADIANS(C46)))","v":{"v":0.17928399584431,"d":"0.1793"}},{"$f":"0.5*(1-COS(RADIANS(D46)))","v":{"v":0.111137512194831,"d":"0.1111"}},{"$f":"0.5*(1-COS(RADIANS(E46)))","v":{"v":0.0171110925698866,"d":"0.0171"}}," fraction"]
["surface dist",{"$f":"$A$10*RADIANS(B46)","v":{"v":3685.67163710094,"d":"3686"}},{"$f":"$A$10*RADIANS(C46)","v":{"v":2969.57421992295,"d":"2970"}},{"$f":"$A$10*RADIANS(D46)","v":{"v":2308.4575644503,"d":"2308"}},{"$f":"$A$10*RADIANS(E46)","v":{"v":891.010731186571,"d":"891"}}," km"]
["sat/gnd dist",{"$f":"$A$10*SIN(RADIANS(B46))/SIN(RADIANS(B45))","v":{"v":22083.4697200449,"d":"22083"}},{"$f":"$A$10*SIN(RADIANS(C46))/SIN(RADIANS(C45))","v":{"v":7654.71438164563,"d":"7655"}},{"$f":"$A$10*SIN(RADIANS(D46))/SIN(RADIANS(D45))","v":{"v":4138.48390826304,"d":"4138"}},{"$f":"$A$10*SIN(RADIANS(E46))/SIN(RADIANS(E45))","v":{"v":1075.71709355977,"d":"1075.72"}}," km"]
["sat/gnd time",{"$f":"2*B49/$E$17","v":{"v":0.147325052902898,"d":"0.147"}},{"$f":"2*C49/$E$17","v":{"v":0.0510667578749589,"d":"0.051"}},{"$f":"2*D49/$E$17","v":{"v":0.0276089929912248,"d":"0.028"}},{"$f":"2*E49/$E$17","v":{"v":0.00717641202792489,"d":"0.007"}}," sec"]
["6s hops",{"$f":"INT(1+(180-B46)/(2*D46))","v":{"v":2,"d":"2.000"}},{"$f":"INT(1+(180-C46)/(2*D46))","v":{"v":2,"d":"2.000"}},null,null," hopcount"]
["6s time",{"$f":"B50+2*B51*D50","v":{"v":0.257761024867798,"d":"0.258"}},{"$f":"C50+2*C51*D50","v":{"v":0.161502729839858,"d":"0.162"}},"ratio",{"$f":"B52/C52","v":{"v":1.59601652011323,"d":"1.60"}}," sec round trip ping time"]
["12s hops",{"$f":"INT(1+(180-B46)/(2*E46))","v":{"v":4,"d":"4.000"}},{"$f":"INT(1+(180-C46)/(2*E46))","v":{"v":5,"d":"5.000"}},null,null," hopcount"]
["12s time",{"$f":"B50+2*B53*E50","v":{"v":0.204736349126297,"d":"0.205"}},{"$f":"C$26+2*C53*E50","v":{"v":0.130066910915389,"d":"0.130"}},"ratio",{"$f":"B54/C54","v":{"v":1.57408481285054,"d":"1.57"}}," sec round trip ping time"]

{"sheet":"Entry Elevator","index":1,"n_rows":29,"n_cols":4,"rows_kept":29}
["Deimos / Phobos loop elevators"]
[]
["Mars","Deimos","Phobos"]
[59354294,109120,27554,"sec Sidereal orbit period"]
[{"v":227939200,"d":"2.28E+08"},23463,9376,"km Semimajor axis"]
[0.0934,0.00033,0.0151,"eccentricity"]
[24.077,1.3513,2.138,"km/s orbital speed"]
[{"v":6.4171e+23,"d":"6.417E+23"},{"v":1476000000000000,"d":"1.476E+15"},{"v":10659000000000000,"d":"1.066E+16"},"kg Estimated Mass"]
[42828.37,"na","na","km3/s2 Standard Grav constant"]
[3396,6.2,11.3,"km Mean radius"]
[3420,"na","na","km Entry radius WAG"]
[88642,"sync","sync","sec Sidereal rotation period"]
[0.241,"na","na","km/s surface rotation speed"]
[1.85,0.93,1.093,"deg inclination"]
["na",{"$f":"B5-B17","v":{"v":7017.54077,"d":"7017.54"}},{"$f":"C5-C17","v":{"v":1455.957497,"d":"1455.96"}},"km drop elevator length"]
["na",{"$f":"$A$9*((1/B17)-(1/B5))+0.5*(B5^2-B17^2)*B21^2","v":{"v":1.24317973068752,"d":"1.24"}},{"$f":"$A$9*((1/C17)-(1/C5))+0.5*(C5^2-C17^2)*C21^2","v":{"v":1.49444162885233,"d":"1.49"}},"km2/s2 drop elevator strength"]
["na",{"$f":"B23","v":{"v":16445.45923,"d":"16445.46"}},{"$f":"C23","v":{"v":7920.042503,"d":"7920.04"}},"km drop radius to reentry"]
[]
["Compute drop radius to reentry "]
[]
[{"$f":"2*PI()/A4","v":{"v":1.05858984813796e-07,"d":"1.059E-07"}},{"$f":"2*PI()/B4","v":{"v":5.75805105130094e-05,"d":"5.758E-05"}},{"$f":"2*PI()/C4","v":{"v":0.000228031694388459,"d":"2.280E-04"}},"rad/s omega"]
[null,{"$f":"2*$A$9/B21^2","v":25835122165658.5},{"$f":"2*$A$9/C21^2","v":1647293986542.05}," 2mu/omega2"]
[null,16445.45923,7920.042503,"km test drop radius to reentry"]
[null,{"$f":"SQRT(SQRT(B$22/((1/B23)+(1/$A$11))))","v":16445.4592323063},{"$f":"SQRT(SQRT(C$22/((1/C23)+(1/$A$11))))","v":7920.04250323309},"iterate"]
[null,{"$f":"SQRT(SQRT(B$22/((1/B24)+(1/$A$11))))","v":16445.4592324055},{"$f":"SQRT(SQRT(C$22/((1/C24)+(1/$A$11))))","v":7920.04250325066},"iterate"]
[null,{"$f":"SQRT(SQRT(B$22/((1/B25)+(1/$A$11))))","v":16445.4592324098},{"$f":"SQRT(SQRT(C$22/((1/C25)+(1/$A$11))))","v":7920.04250325199},"iterate"]
[null,{"$f":"SQRT(SQRT(B$22/((1/B26)+(1/$A$11))))","v":16445.45923241},{"$f":"SQRT(SQRT(C$22/((1/C26)+(1/$A$11))))","v":7920.04250325209},"iterate"]
[null,{"$f":"SQRT(SQRT(B$22/((1/B27)+(1/$A$11))))","v":16445.45923241},{"$f":"SQRT(SQRT(C$22/((1/C27)+(1/$A$11))))","v":7920.0425032521},"iterate"]
[null,{"$f":"SQRT(SQRT(B$22/((1/B28)+(1/$A$11))))","v":16445.45923241},{"$f":"SQRT(SQRT(C$22/((1/C28)+(1/$A$11))))","v":7920.0425032521},"iterate"]