For anyone interested, I’ve got a new, improved version up. It’s basically more organized, with the constants grouped together, and with no references to rows below the formula.
Category Archives: Mathematics
My Mars Spreadsheet
As a response to popular request (actually, no one asked except Jon Goff), I’ve cleaned up and uploaded my spreadsheet.
Other than the astonishing results themselves, the only thing that makes me suspicious is that the total delta V required for the mission with the stop for gas is less than that required for the direct trip (about seven km/s for the latter and about six for the former). But I’ve looked at it multiple times, and don’t see anything wrong with what I did. I’m guessing that, if this is right, it has something to do with the oddities of patched conics. But it would be nice to get some more eyes looking at the problem.
[Update a few minutes later]
Don’t waste too much time looking at that. I just noticed some problems. I’ll update when I’ve fixed.
[Update a few minutes later]
OK, I’ve uploaded a new version. The good news is that I found the problem, and the total delta V is now more for the trip with the gas stop than without (which it seemed it should have been). It’s now about four and a half kilometers per second for the direct case, and about six for the gas stop. The bad news is that the advantage has dropped significantly. The propellant ratio, rather than ten and more than twenty for the EML1 and LEO cases without refueling, is now more like three and five. Still, it’s a significant improvement.
I should note that this is an excellent example of a need to have a feel for the numbers, and not just trust what comes out of a computer (as I fear too many young people do these days). If you don’t know intuitively proper orders of magnitude, or recognize suspicious results, you’re likely to make a lot of errors when doing complex calculations, particularly if you are operating in an environment of confirmation bias (I really, really liked the first, incorrect results). I’m looking at you, climate modelers…
[Update a few minutes later]
One more update to the spreadsheet. I noticed that in fixing the calculations, my delta Vs had become unbalanced, so I adjusted the gas station orbit slightly to rebalance them. The new orbit is 1.256 AU.
ObamaCare Costs
This is an illustration of a pet peeve, though. I hate misleading scaling of graphs and bar charts. Because they chose to use $900 as a baseline, it makes it appear that the estimates have increased by more than an order of magnitude over two years, when in fact they have only doubled. It seems to me that doubling is bad enough without playing games with graphics.
Why Math Teachers Feel Unprepared
Perhaps because they are. Our educational system is a disaster on all levels, and unfortunately, too many are happy and get well paid to keep it that way.
Mastering The Heat-Wave Puzzle
Taking Jeff Masters to statistics school. While Jeff is a meteorologist, I really am starting to think that many of the “scientists” doing climate research are second raters. If not third.
Pirates
The Value Of Trial And Error
Jim Manzi has what looks to be an interesting new book out. David Brooks describes the premises.
Seventeen Equations
…that changed the world. One of the signs of the disaster that is modern academia is that it is not only acceptable, but for many a point of pride, that they don’t understand math.
[Via Geek Press]
Affirmative Action
…and radical politics. As he notes, let’s hope that SCOTUS slaps down this evil once and for all.
Bernard Beard
Some of you may recall numerous comments on statistics and physics here by commenter “bbbeard.” Sadly, I just received notification that he died over the weekend:
Where: Memphis Botanical Gardens (in the Japanese Garden)
750 Cherry RoadMemphis, TN 38117
Phone: 901.636.4106Date: Saturday, April 21, 2012
Time: Gathering at 10:00am with Service to begin at 10:30am. Lunch to follow, ending at 1:30pm
Donations can be made to either of the following:
Keystone School
119 E. Craig Place
San Antonio, TX 78212
Phone: 210.735.4022Donations Link: https://websvr.keystoneschool.org/cc/misc_fund.asp
Or
MIT Department of Physics
77 Massachusetts Ave., Bldg. 4-309
Cambridge, MA 02139-4307
Phone: 617.452.2807
Donations Link: https://giving.mit.edu/givenow/browse-designations.dyn?categoryId=DP,DPPH
He was a former colleague of mine at the ARES Corporation (though I never worked with him). The comments section here (as well, of course, as his friends and family) will miss him.