Login    Register
User Information
Username:
Password:
We are a free and open
community, all are welcome.
Click here to Register
Sponsored
Who is online

In total there are 53 users online :: 2 registered, 0 hidden and 51 guests


Most users ever online was 155 on Mon Aug 15, 2016 1:40 am

Registered users: Bing [Bot], Yahoo [Bot] based on users active over the past 5 minutes

The Team
Administrators
Global Moderators
global_moderators.png CS

C:B Ratio Calculator

A place to ask general spud cannon related questions.
Sponsored 
  • Author
    Message

C:B Ratio Calculator

Unread postAuthor: VooDooCC » Tue Jan 15, 2008 1:15 am

I put in the basic formulas for myself, and then I got to thinking that some other people may find it as a useful tool, so here is my Calculator made in Microsoft Excel.

Sheet 1 is for figuring out the length of barrel if you know the chamber's diameter and length, the ratio you are looking for and width of barrel

Sheet 2 is for figuring out the ratio if you know the diameter and length of the chamber and the barrel.

Hope you enjoy
  • 0


VooDooCC
Private
Private
 
Posts: 22
Joined: Tue Jan 08, 2008 10:01 am
Reputation: 0

Unread postAuthor: psycix » Tue Jan 15, 2008 6:04 am

Hmm yeah it seems to work just fine.
Good for lazy people who dont want to keep doing it by hand :)
  • 0

Till the day I'm dieing, I'll keep them spuddies flying, 'cause I can!

Spudfiles steam group, join!
User avatar
psycix
Donating Member
Donating Member
 
Posts: 3684
Joined: Mon Jun 25, 2007 7:12 am
Location: The Netherlands
Reputation: 0

Unread postAuthor: ralphd » Tue Jan 15, 2008 12:48 pm

Don't forget about Excel's "GOAL SEEK" tool
  • 0


ralphd
Sergeant Major
Sergeant Major
 
Posts: 192
Joined: Mon Dec 17, 2007 8:07 pm
Location: Niles Ohio
Reputation: 0

Unread postAuthor: VooDooCC » Tue Jan 15, 2008 4:08 pm

what is this goal seek tool of which you speak?
  • 0


VooDooCC
Private
Private
 
Posts: 22
Joined: Tue Jan 08, 2008 10:01 am
Reputation: 0

Unread postAuthor: DYI » Tue Jan 15, 2008 4:10 pm

In the time it takes to open that file, I could have already figured out the proper sizes of barrel and chamber with Windows Calculator. But for those who don't have a calculator, or basic knowledge of Grade 7 level mathematics, this may be a good idea.
  • 0

Spudfiles' resident expert on all things that sail through the air at improbable speeds, trailing an incandescent wake of ionized air, dissociated polymers and metal oxides.
User avatar
DYI
Lieutenant General
Lieutenant General
 
Posts: 2861
Joined: Sat Jul 07, 2007 8:18 pm
Location: The People's Republic of Canuckistan
Country: Turks and Caicos Islands (tc)
Reputation: 9

Unread postAuthor: ralphd » Tue Jan 15, 2008 7:19 pm

Goal seel is found under the Tools menu in excel. In a spread sheet where you are trying to tune your C/B Ratio by changing your diameter or length can take some time. With goal seek you can choose your "goal" in this example the ratio then select which input you want to change, either diameter or length. It will ask you to "SET CELL" then "TO VALUE" then select which to change. VooDooCC, I tried your tool and it works fine. It's basicly GOAL SEEK. By the way, it's not a matter of laziness but rather utilizing a tool.

Remember - There is no spoon -
  • 0


ralphd
Sergeant Major
Sergeant Major
 
Posts: 192
Joined: Mon Dec 17, 2007 8:07 pm
Location: Niles Ohio
Reputation: 0

Unread postAuthor: bigbob12345 » Tue Jan 15, 2008 7:31 pm

The first one doesnt work for me but the second one works very well.
  • 0

User avatar
bigbob12345
Major General
Major General
 
Posts: 1516
Joined: Sat Dec 01, 2007 9:13 am
Location: Mercer Island,Washington
Reputation: 0

Sponsored

Sponsor
 


Unread postAuthor: VooDooCC » Wed Jan 16, 2008 5:23 pm

I noticed one problem with it, when using 2" for the barrel, type in the true diameter which is more like 2.1 I saw a site once with the specs for all the different sizes and schedules.
  • 0


VooDooCC
Private
Private
 
Posts: 22
Joined: Tue Jan 08, 2008 10:01 am
Reputation: 0

Return to General Spud Cannon Related

Who is online

Registered users: Bing [Bot], Yahoo [Bot]

Reputation System ©'