{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":[" Assumptions & Constraints","Mission Requirements","Calculations","HET","Drag","Scaling","Mass Budget"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":75,"comments":1,"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":" Assumptions & Constraints","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Electrical Power Subsystem",null,null,null,null,"Source"]
[null,"Solar panels GaAs UTJ","BOL",330,"W/m2","Spectrolab Tech Spec >2.5 m3"]
[null,null,"EOL",{"$f":"D2*0.9","v":297},"W/m2",0.9]
[null,null,"Mass",2.06,"kg/m2","Spectrolab Tech Spec"]
[null,"Li+ Batteries","BOL",{"$f":"240/24","v":10},"A-Hr","702HP"]
[null,null,"EOL",{"$f":"D5*0.9","v":9},"A-Hr",0.9]
[null,null,"Mass",4.8499999999999996,"kg/cell","702HP"]
["Thermal"]
[null,"Radiators","Dissipation",533,"W/m2","Thermal Management Inc"]
[]
["Propulsion"]
[null,"Hall-Effect Thrusters","Mass",25,"kg","Busek BHT8000 Tech Spec"]
[null,null,"size (h)",25,"cm","Literature"]
[null,null,"size (w)",25,"cm","Literature"]
[null,null,"size (d)",25,"cm","Literature"]
[null,null,"Isp","(select)",null,"Busek BHT8000 Tech Spec"]
[null,null,"Power","(select)",null,"Busek BHT8000 Tech Spec"]
[null,null,"Eff","(select)",null,"Busek BHT8000 Tech Spec"]
[null,null,"Thrust","(select)",null,"Busek BHT8000 Tech Spec"]
[null,"Xe Propellant","Triple Point",{"$f":"58 *14.5","v":841},"PSIA"]
[null,null,"Triple Point",19.8,"deg C"]
[null,null,"Triple Point",{"$f":"1720/58.46","v":29.421826890181322},"kg/m3"]
["Attitude Control System"]
[null,"Mono-prop thrusters","Thrust",5,"N"]
[null,"Pointing Accuracy",36,null,"arcseconds","Based on GMAT simulation of Edelbaum-Alfano control law"]
["Other Subsystems",null,"Mass","(See Mass Budget)",null,"SMAD Table 14-18, Centaur 4x2 Reference"]

{"sheet":"Mission Requirements","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Architectural assumptions"]
[null,"AA0001","Mission analysis using low constant thrust Alfano Transfer Orbits, where an Alfano orbit a minimum of 5 continuous thrust spirals with a constant rate of inclination change for each spiral"]
["Requirements"]
["Prefix","Type (R/H/C)","Number","Text"]
["SYS","H",1000,"System Requirements"]
["SYS","R",1001,"The system Initial Operating Capability (IOC) shall transfer payloads in the 4000 to 8000 kg range of mass to equatorial Geo-synchronous Equatorial Orbit (GEO)"]
["SYS","R",1002,"The system  Final Operating Capability (FOC) shall transfer payloads in the 4000 to 8000 kg range of mass to orbits in CIS-Lunar space, including Low Luna Orbit, High Lunar Orbit, and Lagrangian point orbits"]
["SYS","R",1003,"The system Final Operating Capability shall transfer payloads in the 4000 to 8000 kg range Aten and Apollo Group Asteroid transfer orbits."]
["SYS","R",1004,"The system shall transfer payloads from 0 to 60 degree inclined, circular Low Earth Orbit (LEO) to the IOC and FOC defined destination orbits."]
["SYS","R",1005,"The system nominal LEO departure orbit shall be defined as 500 km circular [TBR] with an eccentricity of 0.05 [TBR] or less."]
["SYS","R",1006,"The system shall be designed for propellant resupply of the orbit transfer vehicle in the departure orbit."]
["SYS","R",1007,"The system shall be designed for rendezvous with a cooperative client injected into departure orbit within the 3σ accuracies acheivable by Proton/Briz M launch vehicles"]
["SYS","R",1008,"The system FOC shall transfer payloads to destination orbits in CIS-Lunar space, including Geosynchronous Equatorial Orbit (GEO), High Lunar Orbit (HLO), and Lagrangian point orbits"]
["SYS","R",1009,"The system FOC shall  transfer client payloads to hyperbolic orbits with excess velocity from 0 to [TBD] km/sec."]
["SYS","R",1010,"The system IOC shall be sized to transfer a minimum of 6 client vehicles to GSO per year."]
["SYS","R",1011,"The system FOC shall be sized for 6 [TBR] missions to CIS-Lunar space per year to  space, plus 2 [TBR] missions to Aten or Apollo group Asteroids"]
[]
["MIS","H",2000,"Vehicle Requirements"]
["MIS","C",2001,"In the following requirements, a Cooperative Client Spacecraft (CCS) is defined to be a vehicle designed for at least 190 minutes of survival in LEO orbit and with 3-axis stabilization and accommodations to enable target aquisition, rendezvous, rigid robotic grapple, transfer of control, and berthing."]
["MIS","C",2002,"In the following requirements, an Electric Orbit Transfer Vehicle (EOTV) is defined to be a vehicle designed to accomplish the payload transfer requirements of section 1000 subject to the further requirements in this section."]
["MIS","R",2002,"The space tug shall maneuver from an initial parking orbit to rendezvous with a CCS that is injected into a circular LEO orbit of from 200 km to 800 km altitude."]
["MIS","R",2003,"The space tug shall rendezvous with a CCS from either -v or +v  direction along the orbit track"]
["MIS","R",2004,"The space tug shall rendezvous with a CCS from either -r or +r  direction along the Earth radius vector"]
["MIS","R",2005,"The space tug shall determine target rendezvous ephemeris upon initial sensor acquisition of the CCS from a 200 km distance."]
["MIS","R",2006,"The space tug shall open-loop manuever to within 10 km of last known ephemeris of a CCS."]
["MIS","R",2007,"The space tug shall transfer the CCS to any of the required destination orbits from circular orbit inclined at up to 67.3° [TBR] to Earth equator."]
["MIS","R",2008,"The space tug shall transfer client spacecraft to GEO that have an initial mass in LEO of up to 8000 kg"]
["MIS","C",2009,"The following requirement is based on the GEO injection capabilities of the Delta IV vehicle."]
["MIS","R",2010,"The space tug shall inject a client spacecraft into GEO with 3σ accuracies of ±0.10° in inclination,  ±150 km in perigee and ±150 km in apogee. "]
["MIS","R",2011,"The space tug roundtrip GEO mission time shall be less than 90 days."]
["MIS","C",2014,"The following requirement is based on the SSO injection capabilities of the Delta IV vehicle."]
["MIS","R",2015,"The space tug shall inject a client spacecraft into 1000 km SSO with 3σ accuracies of ±0.08° in inclination,  ±11 km in perigee and ±11 km in apogee. "]
["MIS","R",2016,"The space tug roundtrip SSO mission time shall be less than 120 days."]
[]
["MIS","H",3000,"Propellant Servicing Requirements"]

{"sheet":"Calculations","index":2,"n_rows":125,"n_cols":29,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
[null,null,"GM","SQRT",null,null,null,null,null,null,null,null,null,"Validation data for of Macro EarHohmanXfer"]
["Moon GM (m^3/s^2)","Luna",4900000000000,{"$f":"SQRT(GM_Moon)","v":2213594.3621178656},null,0.08,{"$f":"12*12","v":144},"months",null,null,{"$f":"810000000","v":810000000},null,null,null,"Example, SMAD p.229: the total delta-V to transfer from a 250 km parking orbit at 28.5 degrees inclination to a geosynchronous equatoral orbit."]
["Earth GM (m^3/s^2)","Earth",398600000000000,{"$f":"SQRT(GM_Earth)","v":19964969.321288727},null,null,null,null,null,null,{"$f":"PMT(F2,12,K2)","v":-107482963.70882033},null,null,null,"ri (m)","rf (m)","ΔVapo","ΔVper",null,null,"aTx (m)","1/aTx"]
["Mars GM (m^3/s^2)","Mars",42800000000000,{"$f":"SQRT(GM_Mars)","v":6542170.8935184507},null,null,null,null,null,null,null,null,null,null,{"$f":"(250+Radius_Earth)*1000","v":6628137},42159000,1472.0537795373425,2440.0391143104125,"(macro)",null,{"$f":"0.5*(O4+P4)","v":24393568.5},{"$f":"1/U4","v":4.0994412113176468E-8}]
["Sun GM (m^3/s^2)","Sun",1.327E+20,{"$f":"SQRT(GM_Sun)","v":11519548602.267365}]
["g0",9.8065999999999995,"m/s^2",null,null,null,null,null,null,null,null,null,null,"ii",28.5,"deg"]
["TU",806.81112382429001,"sec",null,null,null,null,null,null,null,null,null,null,"if",0,"deg"]
["Solar Seconds per day",{"$f":"24*3600","v":86400},"sec"]
["Reference Vehicle",null,null,null,null,null,null,null,null,null,null,null,null,"Vi",7.75,"km/s"]
[null,"Mpl",4000,"kg",null,null,null,null,null,null,null,null,null,"Vf",3.07,"km/s",null,null,null,null,null,null,null,null,{"$f":"SUM(Y13:Y14)","v":3912.0369105350501},{"$f":"4270-Y10","v":357.96308946494992}]
[null,"Ms",2724,"kg","Based on Centaur 4x2",null,null,null,null,null,"Num Pnls","α",null,"ΔVa",2.44,"km/s","1/V","2/V",null,"1st term","Sqrt",null,"2nd term","Sqrt"]
[null,"Thrust",{"$f":"12*0.449","v":5.3879999999999999},"kg-m/s2","UJT 6 mil coverside",null,"Pnls/Wing","mass (kg)",null,null,{"$f":"E13/2.5","v":109.71428571428571},{"$f":"C13/(H13+8*200)","v":4.4341216216216214E-2}]
["8 x 14 Panel Wings, GaAs UTJ, 350 W/m2","Power",{"$f":"12*8","v":96},"kW",{"$f":"C13*1000/350","v":274.28571428571428},"sq m",{"$f":"K12/8","v":13.714285714285714},{"$f":"E13*2.06","v":565.02857142857147},null,null,null,null,null,"ΔVb",1.83,"km/s",{"$f":"1/O4","v":1.5087195693148769E-7},{"$f":"2/O4","v":3.0174391386297539E-7},null,{"$f":"R13-V4","v":2.607495017497989E-7},{"$f":"SQRT(T13)","v":5.1063636939587345E-4},null,{"$f":"Q13","v":1.5087195693148769E-7},{"$f":"SQRT(W13)","v":3.8842239499221426E-4},{"$f":"SQRT_GM_Earth*(U13-X13)","v":2439.9982496018215},"ΔVper (m/s)",null,null,"(is correct)"]
[null,"Isp",2020,"sec",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/P4","v":2.3719727697526033E-8},{"$f":"2/P4","v":4.7439455395052065E-8},null,{"$f":"Q14","v":2.3719727697526033E-8},{"$f":"SQRT(T14)","v":1.5401210243849681E-4},null,{"$f":"R14-V4","v":6.4450432818755973E-9},{"$f":"SQRT(W14)","v":8.0281026910943267E-5},{"$f":"SQRT_GM_Earth*(U14-X14)","v":1472.0386609332286},"ΔVapo (m/s)",null,null,"(is correct)"]
[null,"Acceleration, ",{"$f":"LowThrust/Mass_mb_Ref","v":2.6673267326732674E-3},"m/s2",null,null,null,null,null,null,null,null,null,"Vgeo",{"$f":"SQRT(GM_Earth/(P4))","v":3074.846900291765},null,null,null,null,null,null,null,null,null,{"$f":"2*O15*SIN(RADIANS(O6/2))","v":1513.7673801336196},"ΔVplane-change",null,null,"(is correct)"]
["Ecliptic Inclination (to equator)",null,3.2,"deg",null,null,null,null,null,null,null,null,null,"Vleo",{"$f":"SQRT(GM_Earth/(O4))","v":7754.8411997210487},null,null,null,null,null,"check",null,null,null,{"$f":"SUM(Y13:Y15)","v":5425.8042906686696},"ΔVtotal",null,null,"(is correct)"]
["Isp-low",null,320,"sec",null,null,null,null,null,null,null,null,null,"Vhi",{"$f":"SQRT_GM_Earth*SQRT(2/P4-V4)","v":1602.8082393585371},"m/s","Velocity at Transfer orbit Apoapsis",null,null,null,{"$f":"Y14+O17","v":3074.8469002917655},"(is correct)",null,null,{"$f":"SQRT(O17^2+O15^2-2*O17*O15*COS(RADIANS(O6)))","v":1833.4041743664513},"ΔVplane-change at apogee"]
["Isp-Hi",null,2020,"sec",null,null,null,null,null,null,null,null,null,"Vlo",{"$f":"SQRT_GM_Earth*SQRT(2/O4-V4)","v":10194.839449322872},"m/s","Velocity at Transfer orbit Periapsis",null,null,null,{"$f":"Y13+O16","v":10194.83944932287},"(is correct)",null,null,{"$f":"Y17+Y13","v":4273.4024239682731},"ΔVtotal",null,null,"(is correct)"]
["Drag Coefficient",null,0.75,"(Hill & Peterson, Figure10-4)"]
["250 km Burn time",null,90,"sec",null,null,null,null,null,null,null,null,null,null,"Perigee","Apogee","Anomaly","Velocity"]
["Gravity drag (m/s)",null,{"$f":"9.8*C20","v":882.00000000000011},"m/s",null,null,null,null,null,null,null,null,null,null,{"$f":"(250+Radius_Earth)*1000","v":6628137},42159000,1472.0537795373425,2440.0391143104125]
["Aerodynamic drag (approx)",null,{"$f":"C20*10/C19","v":1200},"m/s","(SMAD  p530)",null,null,null,null,null,null,null,null,null,{"$f":"(250+Radius_Earth)*1000","v":6628137},42159000,42159000,1602.7948008885719]
[null,null,"Altitude perigee (km)","Altitude apogee (km)","Semi-major a (km)","Orbit V (m/s)","Period (sec)","Period (min)","Mean Motion",null,null,null,null,null,{"$f":"(250+Radius_Earth)*1000","v":6628137},42159000,{"$f":"(250+Radius_Earth)*1000","v":6628137},10194.964696840872]
["Earth Radius",null,0,0,6378.1369999999997,{"$f":"SQRT(1/1000*GM_Earth/(Radius_Earth+C24))","v":7905.3613379460203}]
["LEO Circular",null,500,500,{"$f":"Radius_Earth+C25","v":6878.1369999999997},{"$f":"SQRT(1/1000*GM_Earth/(Radius_Earth+C25))","v":7612.6039543986117},{"$f":"2*PI()/I25","v":5676.9811746475316},{"$f":"G25/60","v":94.616352910792187},{"$f":"SQRT(GM_Earth/(SMA_LEO*1000)^3)","v":1.1067828329675044E-3}]
["1000 km SSO",null,1000,1000,1000,{"$f":"SQRT(1/1000*GM_Earth/(Radius_Earth+C26))","v":7350.1345562458455},null,null,null,null,null,{"$f":"SMA_GEO/Radius_Earth","v":6.6100206063306581},"R"]
["GEO",null,35781.480000000003,35781.480000000003,{"$f":"Radius_Earth+C27","v":42159.617000000006},{"$f":"SQRT(1/1000*GM_Earth/(Radius_Earth+C27))","v":3074.824400235861}]
[]
["Hohmann Transfers"]
["LEO Parking to 1000 km SSO","h-low (m)","h-high (m)","ΔVapo","ΔVperi","a-trans (m)","Period (sec)","Period (hr)","mean motion, n (rad/s)"]
["Hohman transfer ΔV (m/s)",{"$f":"SMA_LEO*1000","v":6878137},{"$f":"(SMA_LEO+1000)*1000","v":7878137},245.25312149907859,253.72395625099489,{"$f":"0.5*(B31+C31)","v":7378137},{"$f":"2*PI()/I31","v":6307.1229020378623},{"$f":"G31/3600","v":1.7519785838994062},{"$f":"SQRT(GM_Earth/(F31)^3)","v":9.9620467283893549E-4}]
["Initial inclination (deg)",67.3]
["Final inclination (deg)",99.4]
[]
[null,"perigee","apogee","r","Vr"]
["Elliptical Velocity",{"$f":"(Radius_Earth+500)*1000","v":6878137},{"$f":"(Radius_Earth+1000)*1000","v":7378137},{"$f":"(Radius_Earth+1000)*1000","v":7378137},7220.1596267973209]
[null,null,"initial i (deg)","final i (deg)","ΔV (m/s)"]
["Simple inclination change",null,67.3,99.4,{"$f":"2*V_SSO_1000*SIN(RADIANS(D38-C38)/2)","v":4064.2732177343291}]
[null,"perigee","apogee","ΔVapo","ΔVperi","ΔVapo+i",null,"ΔV tot"]
["Hohmann",{"$f":"(Radius_Earth+500)*1000","v":6878137},{"$f":"(Radius_Earth+1000)*1000","v":7378137},130.04718666013196,132.34917959127779,{"$f":"SQRT(E36^2 + V_SSO_1000^2- 2*E36*V_SSO_1000*COS(RADIANS(ABS(C38-D38))))","v":4030.2743400832051},null,{"$f":"E40+D40+E38","v":4326.6695839857384}]
[null,null,null,null,null,null,null,"ΔV tot"]
[null,null,null,null,null,null,null,{"$f":"F40 + E40","v":4162.6235196744828}]
["LEO 500 km to GSO"]
[null,"perigee","apogee","r","Vr"]
["Elliptical Velocity",{"$f":"(Radius_Earth+200)*1000","v":6578137},42159000,{"$f":"B45","v":6578137},10238.885865387654]
[null,"perigee","apogee","r","Vr"]
["Elliptical Velocity",{"$f":"(Radius_Earth+200)*1000","v":6578137},42159000,{"$f":"C47","v":42159000},1597.5566598477194]
[null,null,"initial i (deg)","final i (deg)","ΔV (m/s)"]
["Simple inclination change",null,28.5,0,{"$f":"2*V_GEO*SIN(RADIANS(0.5*ABS(D49-C49)))","v":1513.7563032079115}]
[null,"perigee","apogee","ΔVapo","ΔVperi","ΔVapo+i",null,"ΔV tot"]
["Hohman with inclination change",{"$f":"SMA_LEO*1000","v":6878137},42159000,1446.2731777357947,2369.7397983034189,{"$f":"SQRT(E47^2 + V_GEO^2- 2*E47*V_GEO*COS(RADIANS(ABS(C49-D49))))","v":1836.5376765668618},"m/sec",{"$f":"E51+D51+E49","v":5329.7692792471253}]
[null,null,null,null,null,null,null,"ΔV tot"]
[null,null,null,null,null,null,"m/sec",{"$f":"F51 + E51","v":4206.2774748702805}]
["LEO 500 km to Supersync"]
[null,"perigee","apogee","r","Vr","ΔV (km/s)",null,"Isp"]
["Elliptical Velocity",{"$f":"(Radius_Earth+200)*1000","v":6578137},{"$f":"2*42159000","v":84318000},{"$f":"B56","v":6578137},10602.90109059126,{"$f":"E56-V_LEO_500","v":2990.2971361926484},null,322]
[null,"perigee","apogee","r","Vr"]
["Elliptical Velocity",{"$f":"(Radius_Earth+200)*1000","v":6578137},{"$f":"2*42159000","v":84318000},{"$f":"C58","v":84318000},827.17668082626858]
[null,null,"initial i (deg)","final i (deg)","ΔV (m/s)"]
["Simple inclination change",null,7,0,{"$f":"2*V_GEO*SIN(RADIANS(0.5*ABS(D60-C60)))","v":375.42707792108308},null,"ΔV tot"]
[null,"perigee","apogee","ΔVapo","ΔVperi","ΔVapo+i",{"$f":"E62+D62+E60","v":4191.4400539602966},"m/sec"]
["Hohman with inclination change",{"$f":"SMA_LEO*1000","v":6878137},42159000,1446.2731777357947,2369.7397983034189,{"$f":"SQRT(E58^2 + V_GEO^2- 2*E58*V_GEO*COS(RADIANS(ABS(C60-D60))))","v":2256.0666767393905},"ΔV tot"]
[null,null,null,null,null,null,{"$f":"F62 + E62","v":4625.8064750428093},"m/sec"]
[]
["(Boxes denote entry values)"]
["Thrust computation for HET transfer to GEO",null,null,null,null,null,null,null,null,"Description"]
["LEO altitude",500,"km",null,null,null,null,null,null,"Enter from requirements"]
["ER",{"$f":"Radius_Earth","v":6378.1369999999997},"km"]
["DU*",{"$f":"B67+ER","v":6878.1369999999997},"km"]
["LEO in terms of DU*",{"$f":"B69/B68","v":1.0783927971443699}]
["GEO in terms of DU*",{"$f":"SMA_GEO/B68","v":6.6100206063306581}]
["1 GM*",{"$f":"GM_Earth","v":398600000000000},"m^2/s^2",null,null,null,null,null,null,"GM* = 1 and use this as a conversion to whichever central body we are using"]
["1 TU*",{"$f":"SQRT(B70^3)*TU","v":903.51911506397073},"sec",null,null,null,null,null,null,"1TU* = sqrt(ri^3/GM) using canonical coordinates (GM = 1) and ri in terms of DU*"]
["1 SU*",{"$f":"B68/B73","v":7.0592164500564181},"km/sec"]
["R - Orbit Ratio",{"$f":"B71/B70","v":6.1295110870865184},null,null,null,null,null,null,null,"Used to look-up ΔVacc and λ"]
["inclination",28.5,null,null,null,null,null,null,null,"Used to look-up ΔVacc and λ"]
["ΔVacc",0.7,"SU",null,null,null,null,null,null,"Look-up from solutions to equations of motion, Figure 6-24 for Alfano trajectories."]
["ΔVacc",{"$f":"ΔVacc_canonical*DU_local/1000*TU_local","v":4350.1697788701276},"m/sec",null,null,null,null,null,null,"Conversion: ΔVacc = ER/TU*"]
["λi",-0.36,null,null,null,null,null,null,null,"Look-up from solutions to equations of motion, Figure 6-24 for Alfano trajectories."]
["Isp",{"$f":"VLOOKUP(B98,HET!B2:E13,3)","v":2217},"sec",null,null,null,null,null,null,"Enter from data sheet"]
["Isp*g0",{"$f":"Isp*g0","v":21741.232199999999},"m/s",null,null,null,null,null,null,"Calculation"]
["Mpl (reference)",36000,"kg",{"$f":"B82/M0","v":0.27039529825570136},null,null,null,null,null,"Enter from requirements"]
["Ms (estimate)",{"$f":"'Mass Budget'!B4","v":5297.1849999999995},"kg",{"$f":"B83/M0","v":3.9787053277517428E-2},null,null,null,null,null,"Enter from mass budget (automatically copied)"]
["Mw",{"$f":"'Mass Budget'!B5","v":15720.53248102241},"kg",{"$f":"B84/M0","v":0.118076613026236}]
["Mbo",{"$f":"'Mass Budget'!B2","v":57017.71748102241},null,{"$f":"B85/M0","v":0.42825896455945478}]
["Mp (calculated)",{"$f":"B89*(SUM(B82:B84)+B84)/(1-B89)","v":19102.97473750672},"kg",{"$f":"B86/M0","v":0.1434820708810905},"kg","Mp + return",null,null,null,"Calculated from propellant fraction,"]
["M0",{"$f":"SUM(B82:B86)","v":133138.40969955153},"kg",null,null,null,null,null,null,"Calculated : sum of Mpl, Ms, Mp)"]
["specific power",{"$f":"(B84)/D99","v":30.179327632389864},"kg/kW",{"$f":"(1/B85-1/M0)","v":1.0027427625997862E-5},{"$f":"D94*B84","v":9526.64268349958},{"$f":"D88*E88","v":9.5527720027534097E-2},{"$f":"POWER(F88,2)","v":9.1255452936589397E-3},{"$f":"B88*G88/2","v":0.13770141062077326},{"$f":"1-H88","v":0.86229858937922677},"Melbourne & Sauer ETA per Eq. (38)"]
["propellant mass fraction",0.20799999999999999,null,null,null,null,null,null,null,"Enter from requirements - drives specific thrust (ai)"]
["Specific acceleration (ai)",{"$f":"Aggregate_Thrust/M0","v":2.1583553585210653E-4},"m/s^2",null,null,null,null,null,null,"Thrust/m0 (careful of conversion, m to km)"]
["tf (calculated)",{"$f":"-1/specific_mass_flow_rate*(1-EXP((specific_mass_flow_rate*ΔVacc_km)/Specific_acceleration))","v":18266646.405173372},"sec",{"$f":"B91/(24*3600)","v":211.41951857839553},"days",null,null,null,null,"The key calculation (validates against Example 6-13 in Vallado, beware the sign)"]
["specific mass flow rate",{"$f":"mass_flow_rate/M0","v":-9.9274748490155278E-9},"1/s",null,null,{"$f":"F93/Mp__calculated","v":-6.9189654066554668E-2},"1/s",null,null,"Calculation mass flow rate divided by propellant mass, sensitive to propellant mass fraction"]
["mass flow rate",{"$f":"-Aggregate_Thrust/Isp_g0","v":-1.3217282137302229E-3},"kg/sec",null,null,{"$f":"mass_flow_rate*1000000","v":-1321.7282137302229},"mg/sec",null,null,"Calculation dm/dt= T^2/2*Eta*P where T and P and Eta are taken from the thruster data sheet"]
["thruster efficiency ",{"$f":"VLOOKUP(B98,HET!B2:E13,4)","v":60.6},null,{"$f":"B94/100","v":0.60599999999999998},null,null,null,null,null,"Enter from data sheet, used to calculate mass flow rate"]
["thrust (per thruster)",{"$f":"VLOOKUP(B98,HET!B2:E13,2)","v":0.44900000000000001},"N",null,null,null,null,null,null,"Enter from data sheet"]
["Aggregate Thrust T",{"$f":"B95*B97","v":28.736000000000001},"N",{"$f":"B96*1000000","v":28736000},"mN",null,null,null,null,"Multiple of the number of thrusters"]
["Number of thrusters",64,null,null,null,null,null,null,null,"Enter from requirements"]
["Power per Thruster",8061,"W",null,null,null,null,null,null,"Enter from data sheet"]
["Total Power",{"$f":"B97*B98+5000","v":520904},"W",{"$f":"B99/1000","v":520.904},"kW",null,null,null,null,"Propulsion required power plus 5kW margin"]
["HET dissipation",{"$f":"B94*B99","v":31566782.400000002},"W"]
["HET standby power",{"$f":"D101*B97","v":12800},"W",200,"W cathode heater"]
["Power density (BOL) per Panel",366,"W/m^2",null,null,null,null,null,null,"From Spectrolab Space Solar Panels datasheet for XTJ Panels BOL"]
["Power density (EOL) per Panel",{"$f":"B102*D103","v":303.77999999999997},"W/m^2",{"$f":"1-F103","v":0.83},"EOL",0.17]
["Panel Area",5.76,"m^2","2.4 x 2.4m"]
["Power per Panel (EOL)",{"$f":"B104*B103","v":1749.7727999999997},"W"]
["Number panels required",{"$f":"B99/B105","v":297.69807828764971}]
["Density Solar Panels",2.06,"kg/m^2",null,null,null,null,null,null,"From Spectrolab Space Solar Panels datasheet for .6mil Ceria Doped Coverslide"]
["Solar Panel Mass",{"$f":"B104*B107","v":11.865600000000001},"kg",null,null,null,null,null,null,"Calculation including 20% margin"]
["Number of panels per wing",12,null,null,null,null,null,null,null,"Calculation"]
["Power per Wing",{"$f":"B109*B105","v":20997.273599999997},"W",null,null,null,null,null,null,"Number panels across by number of panels in length"]
["Mass per wing",{"$f":"B108*B109","v":142.38720000000001},"kg"]
["Number of SA wings Required",{"$f":"ROUNDUP(B99/B110,0)","v":25},null,null,null,null,null,null,null,"Calculation, note that there is one wing each side"]
["Length of Wing - Single Column",{"$f":"B109*SQRT(B104)","v":28.799999999999997},"m",null,null,null,null,null,null,"Calculation based on panel length, num cells in length, num of panels"]
["Length of W - Double Column",{"$f":"B113/2","v":14.399999999999999},"m"]
["Mass of Array",{"$f":"B112*B111","v":3559.6800000000003}]
["Area of Array",{"$f":"B106*B104","v":1714.7409309368622}]
["Cable Length",{"$f":"ROUND(1.05*B113*B112/2,0)","v":378},"m"]
["Actual Mp(tf)",{"$f":"ABS(B91*mass_flow_rate)","v":24143.541923951398},"kg",null,null,null,null,null,null,"Actual propellant mass used during time of flight, less 500 kg reserved for return"]
["Radiator Capacity",533,"W/m^2"]
["PPU Efficiency",0.94]
["Active PPU Channels",2]
["Max PPU Power",{"$f":"2*B98","v":16122},"W/m^2"]
["Max PPU Dissipation",{"$f":"B122*(1-B120)","v":967.32000000000085},"W"]
["Area PM Radiators",{"$f":"ROUNDUP(B123/B119,2)","v":1.82},"m^2"]
["Total Radiator Area",{"$f":"B124*2*B97","v":232.96},"m^2"]

{"sheet":"HET","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Voltage","Power","Thrust (N)","Isp","Efficiency","%Thrust","Sources:"]
[350,4063,0.245,1927,0.56999999999999995,1,"IEPC-13-317, 2013, Table 1. BHT-8000 Throttle Table."]
[400,4537,0.26,2077,58.4,0.5,"Revised 9/6/2018, Private Communications with Dan Williams"]
[600,4544,0.19800000000000001,2696,59.6,0.5,"Revised 9/6/2018, Private Communications with Dan Williams"]
[800,4563,0.17199999999999999,3203,59.2,0.5,"Revised 9/6/2018, Private Communications with Dan Williams"]
[350,5999,0.36499999999999999,1977,0.56999999999999995,0.75,"IEPC-13-317, 2013, Table 1. BHT-8000 Throttle Table."]
[400,6295,0.35899999999999999,2165,60.6,0.75,"Revised 9/6/2018, Private Communications with Dan Williams"]
[600,6327,0.29499999999999998,2583,59.1,0.75,"Revised 9/6/2018, Private Communications with Dan Williams"]
[800,6342,0.23799999999999999,3152,58,0.75,"Revised 9/6/2018, Private Communications with Dan Williams"]
[800,8047,0.32500000000000001,3068,60.7,1,"Revised 9/6/2018, Private Communications with Dan Williams"]
[600,8058,0.377,2637,60.5,1,"Revised 9/6/2018, Private Communications with Dan Williams"]
[350,8060,0.46500000000000002,1979,0.56000000000000005,0.5,"IEPC-13-317, 2013, Table 1. BHT-8000 Throttle Table."]
[400,8061,0.44900000000000001,2217,60.6,1,"Revised 9/6/2018, Private Communications with Dan Williams"]

{"sheet":"Drag","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["Mass",{"$f":"Calculations!B83+Calculations!B82","v":41297.184999999998},"kg","Calculations Sheet"]
["minXA",14.2,"m2","Hubble, Table 9.10 SMAD"]
["maxXA",112,"m2","Hubble, Table 9.10 SMAD"]
["Drag Coef",4,null,"Hubble, Table 9.10 SMAD"]
["Reflectivity",1.8,null,"GMAT default"]

{"sheet":"Scaling","index":5,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Time flt",80,"days",{"$f":"B1*Solar_s_per_d","v":6912000},"sec"]
["PMF",0.19]
["Payload:",{"$f":"Calculations!B82","v":36000},"kg"]
["HET","Unit Thrust (N)","Power (W)","Isp_g0 (m/s)","Mass (kg) per HET"]
["BHT8000",{"$f":"Calculations!B95","v":0.44900000000000001},{"$f":"Calculations!B98","v":8061},{"$f":"Isp_g0","v":21741.232199999999},25]
["Solar Arrays","Power Density (W/m^2)","Mass Density (kg/m^2)","System Specific Power (W/kg)"]
["UTJ GaAs",{"$f":"Calculations!B102","v":366},2.06,{"$f":"'Mass Budget'!D11","v":680}]
[]
["Scaling"]
["N. HET","T (N)","M0 (kg)","Power (W)","Required Area SA (m^2)","Num Panels","Mass SA (kg)","Mass HET (kg)","Mass Pwr Eq. (kg)","Mass (kg) Thermal Pnls","Dry Mass (kg)","Mass Pl (kg)","Mass Prop (kg"]
[16,{"$f":"A11*$B$5","v":7.1840000000000002},{"$f":"SUM(K11:M11)","v":{"$error":"#REF!"}},{"$f":"A11*$C$5*1.2","v":154771.19999999998},{"$f":"D11/$B$7","v":422.87213114754093},{"$f":"E11/Calculations!#REF!","v":{"$error":"#REF!"}},{"$f":"$C$7*E11","v":871.11659016393435},{"$f":"A11*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":656},{"$f":"D11/$D$7","v":227.6047058823529},{"$f":"D11*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":232.15679999999998},{"$f":"'Mass Budget'!#REF!+SUM(G11:J11)","v":{"$error":"#REF!"}},{"$f":"$B$3","v":36000},{"$f":"$B$2*(2*K11+L11)+500","v":{"$error":"#REF!"}}]
[20,{"$f":"A12*$B$5","v":8.98},{"$error":"#REF!"},193464,528.59016393442619,{"$f":"E12/Calculations!#REF!","v":{"$error":"#REF!"}},{"$f":"$C$7*E12","v":1088.895737704918},{"$f":"A12*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":820},{"$f":"D12/$D$7","v":284.50588235294117},{"$f":"D12*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":290.19599999999997},{"$f":"'Mass Budget'!#REF!+SUM(G12:J12)","v":{"$error":"#REF!"}},{"$f":"$B$3","v":36000},{"$f":"$B$2*(2*K12+L12)+500","v":{"$error":"#REF!"}}]
[24,10.776,{"$error":"#REF!"},232156.79999999999,634.30819672131145,{"$f":"E13/Calculations!#REF!","v":{"$error":"#REF!"}},1306.6748852459016,{"$f":"A13*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":984},341.40705882352938,{"$f":"D13*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":348.23519999999996},{"$f":"'Mass Budget'!#REF!+SUM(G13:J13)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[28,12.572000000000001,{"$error":"#REF!"},270849.59999999998,740.02622950819671,{"$f":"E14/Calculations!#REF!","v":{"$error":"#REF!"}},1524.4540327868854,{"$f":"A14*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":1148},398.30823529411759,{"$f":"D14*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":406.27439999999996},{"$f":"'Mass Budget'!#REF!+SUM(G14:J14)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[32,14.368,{"$error":"#REF!"},309542.39999999997,845.74426229508185,{"$f":"E15/Calculations!#REF!","v":{"$error":"#REF!"}},1742.2331803278687,{"$f":"A15*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":1312},455.20941176470581,{"$f":"D15*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":464.31359999999995},{"$f":"'Mass Budget'!#REF!+SUM(G15:J15)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[36,16.164000000000001,{"$error":"#REF!"},348235.2,951.46229508196723,{"$f":"E16/Calculations!#REF!","v":{"$error":"#REF!"}},1960.0123278688525,{"$f":"A16*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":1476},512.11058823529413,{"$f":"D16*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":522.3528},{"$f":"'Mass Budget'!#REF!+SUM(G16:J16)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[40,17.96,{"$error":"#REF!"},386928,1057.1803278688524,{"$f":"E17/Calculations!#REF!","v":{"$error":"#REF!"}},2177.791475409836,{"$f":"A17*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":1640},569.01176470588234,{"$f":"D17*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":580.39199999999994},{"$f":"'Mass Budget'!#REF!+SUM(G17:J17)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[44,19.756,{"$error":"#REF!"},425620.8,1162.8983606557376,{"$f":"E18/Calculations!#REF!","v":{"$error":"#REF!"}},2395.5706229508196,{"$f":"A18*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":1804},625.91294117647055,{"$f":"D18*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":638.43119999999999},{"$f":"'Mass Budget'!#REF!+SUM(G18:J18)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[48,21.552,{"$error":"#REF!"},464313.59999999998,1268.6163934426229,{"$f":"E19/Calculations!#REF!","v":{"$error":"#REF!"}},2613.3497704918032,{"$f":"A19*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":1968},682.81411764705877,{"$f":"D19*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":696.47039999999993},{"$f":"'Mass Budget'!#REF!+SUM(G19:J19)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[52,23.347999999999999,{"$error":"#REF!"},503006.39999999997,1374.3344262295082,{"$f":"E20/Calculations!#REF!","v":{"$error":"#REF!"}},2831.1289180327867,{"$f":"A20*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":2132},739.71529411764698,{"$f":"D20*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":754.50959999999986},{"$f":"'Mass Budget'!#REF!+SUM(G20:J20)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[56,25.144000000000002,{"$error":"#REF!"},541699.19999999995,1480.0524590163934,{"$f":"E21/Calculations!#REF!","v":{"$error":"#REF!"}},3048.9080655737707,{"$f":"A21*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":2296},796.61647058823519,{"$f":"D21*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":812.54879999999991},{"$f":"'Mass Budget'!#REF!+SUM(G21:J21)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[60,26.94,{"$error":"#REF!"},580392,1585.7704918032787,{"$f":"E22/Calculations!#REF!","v":{"$error":"#REF!"}},3266.6872131147543,{"$f":"A22*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":2460},853.51764705882351,{"$f":"D22*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":870.58800000000008},{"$f":"'Mass Budget'!#REF!+SUM(G22:J22)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[64,28.736000000000001,{"$error":"#REF!"},619084.79999999993,1691.4885245901637,{"$f":"E23/Calculations!#REF!","v":{"$error":"#REF!"}},3484.4663606557374,{"$f":"A23*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":2624},910.41882352941161,{"$f":"D23*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":928.6271999999999},{"$f":"'Mass Budget'!#REF!+SUM(G23:J23)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[68,30.532,{"$error":"#REF!"},657777.6,1797.2065573770492,{"$f":"E24/Calculations!#REF!","v":{"$error":"#REF!"}},3702.2455081967214,{"$f":"A24*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":2788},967.31999999999994,{"$f":"D24*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":986.66639999999995},{"$f":"'Mass Budget'!#REF!+SUM(G24:J24)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[72,32.328000000000003,{"$error":"#REF!"},696470.4,1902.9245901639345,{"$f":"E25/Calculations!#REF!","v":{"$error":"#REF!"}},3920.024655737705,{"$f":"A25*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":2952},1024.2211764705883,{"$f":"D25*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1044.7056},{"$f":"'Mass Budget'!#REF!+SUM(G25:J25)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[76,34.124000000000002,{"$error":"#REF!"},735163.2,2008.6426229508195,{"$f":"E26/Calculations!#REF!","v":{"$error":"#REF!"}},4137.8038032786881,{"$f":"A26*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":3116},1081.1223529411764,{"$f":"D26*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1102.7447999999999},{"$f":"'Mass Budget'!#REF!+SUM(G26:J26)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[80,35.92,{"$error":"#REF!"},773856,2114.3606557377047,{"$f":"E27/Calculations!#REF!","v":{"$error":"#REF!"}},4355.5829508196721,{"$f":"A27*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":3280},1138.0235294117647,{"$f":"D27*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1160.7839999999999},{"$f":"'Mass Budget'!#REF!+SUM(G27:J27)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[84,37.716000000000001,{"$error":"#REF!"},812548.79999999993,2220.0786885245898,{"$f":"E28/Calculations!#REF!","v":{"$error":"#REF!"}},4573.3620983606552,{"$f":"A28*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":3444},1194.9247058823528,{"$f":"D28*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1218.8231999999998},{"$f":"'Mass Budget'!#REF!+SUM(G28:J28)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[88,39.512,{"$error":"#REF!"},851241.6,2325.7967213114753,{"$f":"E29/Calculations!#REF!","v":{"$error":"#REF!"}},4791.1412459016392,{"$f":"A29*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":3608},1251.8258823529411,{"$f":"D29*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1276.8624},{"$f":"'Mass Budget'!#REF!+SUM(G29:J29)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[92,41.308,{"$error":"#REF!"},889934.4,2431.5147540983608,{"$f":"E30/Calculations!#REF!","v":{"$error":"#REF!"}},5008.9203934426232,{"$f":"A30*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":3772},1308.7270588235294,{"$f":"D30*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1334.9016000000001},{"$f":"'Mass Budget'!#REF!+SUM(G30:J30)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[96,43.103999999999999,{"$error":"#REF!"},928627.19999999995,2537.2327868852458,{"$f":"E31/Calculations!#REF!","v":{"$error":"#REF!"}},5226.6995409836063,{"$f":"A31*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":3936},1365.6282352941175,{"$f":"D31*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1392.9407999999999},{"$f":"'Mass Budget'!#REF!+SUM(G31:J31)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[100,44.9,{"$error":"#REF!"},967320,2642.9508196721313,{"$f":"E32/Calculations!#REF!","v":{"$error":"#REF!"}},5444.4786885245903,{"$f":"A32*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":4100},1422.5294117647059,{"$f":"D32*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1450.98},{"$f":"'Mass Budget'!#REF!+SUM(G32:J32)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[104,46.695999999999998,{"$error":"#REF!"},1006012.7999999999,2748.6688524590163,{"$f":"E33/Calculations!#REF!","v":{"$error":"#REF!"}},5662.2578360655734,{"$f":"A33*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":4264},1479.430588235294,{"$f":"D33*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1509.0191999999997},{"$f":"'Mass Budget'!#REF!+SUM(G33:J33)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[108,48.492000000000004,{"$error":"#REF!"},1044705.6,2854.3868852459018,{"$f":"E34/Calculations!#REF!","v":{"$error":"#REF!"}},5880.0369836065574,{"$f":"A34*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":4428},1536.3317647058823,{"$f":"D34*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1567.0583999999999},{"$f":"'Mass Budget'!#REF!+SUM(G34:J34)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[112,50.288000000000004,{"$error":"#REF!"},1083398.3999999999,2960.1049180327868,{"$f":"E35/Calculations!#REF!","v":{"$error":"#REF!"}},6097.8161311475415,{"$f":"A35*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":4592},1593.2329411764704,{"$f":"D35*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1625.0975999999998},{"$f":"'Mass Budget'!#REF!+SUM(G35:J35)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[116,52.084000000000003,{"$error":"#REF!"},1122091.2,3065.8229508196719,{"$f":"E36/Calculations!#REF!","v":{"$error":"#REF!"}},6315.5952786885246,{"$f":"A36*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":4756},1650.1341176470587,{"$f":"D36*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1683.1368},{"$f":"'Mass Budget'!#REF!+SUM(G36:J36)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[120,53.88,{"$error":"#REF!"},1160784,3171.5409836065573,{"$f":"E37/Calculations!#REF!","v":{"$error":"#REF!"}},6533.3744262295086,{"$f":"A37*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":4920},1707.035294117647,{"$f":"D37*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1741.1760000000002},{"$f":"'Mass Budget'!#REF!+SUM(G37:J37)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[124,55.676000000000002,{"$error":"#REF!"},1199476.8,3277.2590163934428,{"$f":"E38/Calculations!#REF!","v":{"$error":"#REF!"}},6751.1535737704926,{"$f":"A38*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":5084},1763.9364705882354,{"$f":"D38*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1799.2151999999999},{"$f":"'Mass Budget'!#REF!+SUM(G38:J38)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[128,57.472000000000001,{"$error":"#REF!"},1238169.5999999999,3382.9770491803274,{"$f":"E39/Calculations!#REF!","v":{"$error":"#REF!"}},6968.9327213114748,{"$f":"A39*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":5248},1820.8376470588232,{"$f":"D39*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1857.2543999999998},{"$f":"'Mass Budget'!#REF!+SUM(G39:J39)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[132,59.268000000000001,{"$error":"#REF!"},1276862.3999999999,3488.6950819672129,{"$f":"E40/Calculations!#REF!","v":{"$error":"#REF!"}},7186.7118688524588,{"$f":"A40*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":5412},1877.7388235294115,{"$f":"D40*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1915.2936},{"$f":"'Mass Budget'!#REF!+SUM(G40:J40)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[136,61.064,{"$error":"#REF!"},1315555.2,3594.4131147540984,{"$f":"E41/Calculations!#REF!","v":{"$error":"#REF!"}},7404.4910163934428,{"$f":"A41*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":5576},1934.6399999999999,{"$f":"D41*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":1973.3327999999999},{"$f":"'Mass Budget'!#REF!+SUM(G41:J41)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[140,62.86,{"$error":"#REF!"},1354248,3700.1311475409834,{"$f":"E42/Calculations!#REF!","v":{"$error":"#REF!"}},7622.2701639344259,{"$f":"A42*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":5740},1991.5411764705882,{"$f":"D42*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":2031.3719999999998},{"$f":"'Mass Budget'!#REF!+SUM(G42:J42)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[144,64.656000000000006,{"$error":"#REF!"},1392940.8,3805.8491803278689,{"$f":"E43/Calculations!#REF!","v":{"$error":"#REF!"}},7840.0493114754099,{"$f":"A43*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":5904},2048.4423529411765,{"$f":"D43*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":2089.4112},{"$f":"'Mass Budget'!#REF!+SUM(G43:J43)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[148,66.451999999999998,{"$error":"#REF!"},1431633.5999999999,3911.5672131147539,{"$f":"E44/Calculations!#REF!","v":{"$error":"#REF!"}},8057.828459016393,{"$f":"A44*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":6068},2105.3435294117644,{"$f":"D44*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":2147.4503999999997},{"$f":"'Mass Budget'!#REF!+SUM(G44:J44)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[152,68.248000000000005,{"$error":"#REF!"},1470326.4,4017.285245901639,{"$f":"E45/Calculations!#REF!","v":{"$error":"#REF!"}},8275.6076065573761,{"$f":"A45*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":6232},2162.2447058823527,{"$f":"D45*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":2205.4895999999999},{"$f":"'Mass Budget'!#REF!+SUM(G45:J45)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[156,70.043999999999997,{"$error":"#REF!"},1509019.2,4123.0032786885249,{"$f":"E46/Calculations!#REF!","v":{"$error":"#REF!"}},8493.3867540983611,{"$f":"A46*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":6396},2219.145882352941,{"$f":"D46*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":2263.5287999999996},{"$f":"'Mass Budget'!#REF!+SUM(G46:J46)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[160,71.84,{"$error":"#REF!"},1547712,4228.7213114754095,{"$f":"E47/Calculations!#REF!","v":{"$error":"#REF!"}},8711.1659016393442,{"$f":"A47*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":6560},2276.0470588235294,{"$f":"D47*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":2321.5679999999998},{"$f":"'Mass Budget'!#REF!+SUM(G47:J47)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]
[164,73.635999999999996,{"$error":"#REF!"},1586404.8,4334.439344262295,{"$f":"E48/Calculations!#REF!","v":{"$error":"#REF!"}},8928.9450491803273,{"$f":"A48*($E$5+'Mass Budget'!$D$25*'Mass Budget'!$H$25+'Mass Budget'!$D$26)","v":6724},2332.9482352941177,{"$f":"D48*'Mass Budget'!$D$21/'Mass Budget'!$D$20","v":2379.6071999999999},{"$f":"'Mass Budget'!#REF!+SUM(G48:J48)","v":{"$error":"#REF!"}},36000,{"$error":"#REF!"}]

{"sheet":"Mass Budget","index":6,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Subsystem","Total Estimates (kg)",null,"Qty","Units","Item","Manufacture","Unit Mult. ",null,"Mdry","Units","Comment"]
["Total Mbo",{"$f":"SUM(B3:B5)","v":57017.71748102241}]
["Reference P/L",{"$f":"Calculations!B82","v":36000}]
["Ms",{"$f":"SUM(B23:B32)","v":5297.1849999999995},null,null,"kg"]
["Mw",{"$f":"SUM(B8:B22)","v":15720.53248102241}]
[]
["Subsystems:"]
["Power",{"$f":"SUM(J9:J17)","v":14939.17648102241}]
[null,null,null,null,null,"Solar Wings from Calculations",null,null,null,{"$f":"Calculations!B115","v":3559.6800000000003},"kg"]
[]
[null,null,null,680,"W/kg","Power Electronics",null,null,null,{"$f":"Calculations!B99/'Mass Budget'!D11","v":766.03529411764703},"kg","AIAA 2009-4613"]
[null,null,null,null,null,"Allowed DoD",null,0.8]
[null,null,null,null,null,"max eclipse time",null,67,"min"]
[null,null,null,null,null,"Standby Power Required plus margin for DoD",null,{"$f":"Calculations!B101+1500/H12","v":14675},"W"]
[null,null,null,null,null,null,"SAFT",140,"Wh/kg",null,null,"SAFT  Lithium ION Cell"]
[null,null,null,4.8499999999999996,"kg/cell","li-IonBatteries 240 A-Hr",null,{"$f":"H14*H13/(60*H15)","v":117.05059523809524},"cells",{"$f":"H16*D16","v":567.6953869047619},"kg","Roughly a constant - 7.2 kW-hr"]
[null,null,null,null,null,"2 x1/1 conductors per HET, length 2* array section","Mil-W-22759",0.53152200000000005,"kg/m",{"$f":"2*Calculations!B117*Calculations!B112*H17","v":10045.765800000001},"kg"]
[null,null,null,null,null,null,"1/1 AWG",0.53152200000000005]
["Thermal",{"$f":"D22/D20","v":781.35599999999988},null,null,null,null,"1/0 AWG",0.64875300000000002]
[null,null,null,400,"W/kg","Alpha"]
[null,null,null,0.6,null,"Power Efficiency"]
[null,null,null,{"$f":"D21*Calculations!B99","v":312542.39999999997},"W","Thermal Rejection"]
["Propulsion",{"$f":"SUM(J24:J26)","v":3584},null,null,"kg"]
[null,null,null,{"$f":"Calculations!B97","v":64},null,"8 kW 25 cm Hall Effect Thrusters","Busek",25,"kg",{"$f":"D24*H24","v":1600},"kg"]
[null,null,null,30,"kg","Propulsion Power Processing Unit","Moog",0.5,null,{"$f":"2*D24*D25*H25","v":1920},"kg","assuming 2 PPU per 4 thrusters"]
[null,null,null,1,"kg","Lines & Valves, Regulators",null,null,null,{"$f":"D24*D26","v":64},"kg"]
["Structure & Mech",{"$f":"266+J27","v":988.625},null,0.47,"kg/m","High Modulus Carbon Composit, 10cm dia, 0.14cm wall",null,null,null,{"$f":"(Calculations!B117+Calculations!B97*3+18*2.5)*'Mass Budget'!D27*2.5","v":722.625},null,"Reference JPL SRO"]
["MMOD",207,null,null,null,"Whipple Shielding",null,null,null,null,null,"3 m^2 x 0.230 g/cm^2 Whipple Shield (Cherniav and Telichev, Journal of Spacecraft and Rockets, Jan-Feb 2017, p.86"]
["Comm",{"$f":"0.04*Reference_Ms","v":108.96000000000001},null,null,null,null,null,null,null,null,null,"SMAD Table 14-18, Centaur Reference"]
["ADCS",{"$f":"0.08*Reference_Ms","v":217.92000000000002},null,null,null,null,null,null,null,null,null,"SMAD Table 14-18, Centaur Reference"]
["C&DH",{"$f":"0.05*Reference_Ms","v":136.20000000000002},null,null,null,null,null,null,null,null,null,"SMAD Table 14-18, Centaur Reference"]
["Signal Harness",{"$f":"0.02*Reference_Ms","v":54.480000000000004},null,null,null,null,null,null,null,null,null,"Guestimate"]