Quantcast

Barrowman by hand!!!

The Rocketry Forum

Help Support The Rocketry Forum:

graylensman

Well-Known Member
Joined
Feb 24, 2009
Messages
949
Reaction score
1
Well, I did it. Working up a design for a D egglofter based on some other plans I've seen kicking around (most notably George Gassaway's TwoMinuteEgg). Sat down at the Mac, cracked open my <i>Handbook</i>, fired up Excel, and started pounding away at the keys.

One hour later, I had my CP!!!

My brain was buzzing for an hour afterward! :p
 

powderburner

Well-Known Member
Joined
Jan 18, 2009
Messages
7,356
Reaction score
4
Now the secret is out. Everyone will want to try it.
And it's not hard to do.

Do you want to add a matching spreadsheet calculation for center of gravity?
 

powderburner

Well-Known Member
Joined
Jan 18, 2009
Messages
7,356
Reaction score
4
may not be as satisfying as using a paper and pencil (and chopping down another forest?) but you still have to know what the equations are doing
 

graylensman

Well-Known Member
Joined
Feb 24, 2009
Messages
949
Reaction score
1
Originally posted by powderburner
Now the secret is out. Everyone will want to try it.
And it's not hard to do.

Do you want to add a matching spreadsheet calculation for center of gravity?
The hardest thing to do was keeping track of what portion of the formula I was doing at any given time. I'm sure an Excel expert could find easier/quicker ways to do this; and I'll probably take a stab at it for future use.

Do you *have* a spreadsheet for CG calculations? That would be handy too!
 

rstaff3

Oddroc-eteer
Joined
Jan 18, 2009
Messages
11,716
Reaction score
8
I think everyone should go through this exercise at least once. I even made a spreadsheet prior to getting vcp and then RockSim. There was a fair amount of reconfiguration for each design, but it still helped.
 

Mike

Well-Known Member
Joined
Jun 3, 2011
Messages
1,319
Reaction score
0
Little problem...where can I get the formula???
 

graylensman

Well-Known Member
Joined
Feb 24, 2009
Messages
949
Reaction score
1
powderburner

your spreadsheet is perfect for my needs. I'm not designing anything exotic - just sport models. Thanks for posting that.
 

powderburner

Well-Known Member
Joined
Jan 18, 2009
Messages
7,356
Reaction score
4
Originally posted by Mike
Little problem...where can I get the formula???
If you are looking for the fabled Barrowman eqns, do a quick google and you will find sites like this one:

http://my.execpc.com/~culp/rockets/Barrowman.html
where the eqns are presented in summarized form

Or, go look at our Apogee friend's website for the complete original report:
http://www.apogeerockets.com/education/downloads/Barrowman_report.pdf

And come on back here to TRF if you have qstns


Update:
Oops----just saw that someone already posted one of those sites.
 

BlueNinja

Well-Known Member
Joined
Jan 18, 2009
Messages
2,690
Reaction score
1
I did it for teh Tethys by hand and on a TI-30XIIS calc, came within .8 inches of the PML recommendation of 41 inches.
 

GL-P

Well-Known Member
Joined
Jul 15, 2004
Messages
1,617
Reaction score
0
I did it for teh Tethys by hand and on a TI-30XIIS calc, came within .8 inches of the PML recommendation of 41 inches.
What does PML use for its calculations?
 

rstaff3

Oddroc-eteer
Joined
Jan 18, 2009
Messages
11,716
Reaction score
8
Since they provide Rsims for all their designs, I assume that's what they use. Thie file for the Tethys says 41.276 using the Barrowman method.
 

BlueNinja

Well-Known Member
Joined
Jan 18, 2009
Messages
2,690
Reaction score
1
ok, then I was within .6" :) I rounded some of teh numbers however.
 

graylensman

Well-Known Member
Joined
Feb 24, 2009
Messages
949
Reaction score
1
Originally posted by rstaff3
...You can laso examine the spreadsheet that graylensman mentioned.
Well, the only thing I used a spreadsheet for was the actual CP calculations... and to hold results of one part ready to mix with the results of another.

I don't have one set up where you can plug in your variables and spit out the answer. I'm intending to consult with the company Excel Expert to try to get a sheet set up that way.

Powderburner's CG sheet with attendant explanation was quite useful. Looking forward to testing the results empirically.
 

rstaff3

Oddroc-eteer
Joined
Jan 18, 2009
Messages
11,716
Reaction score
8
Mine wasn't that snazzy either but it automated the acutal math. Now I'd much rather play with cuter toys.
 
Top