http://cmv.zftp.com/SilencerWTandVol3.xlsx
Making download available - otherwise I know nothing about how it works (ask him if there's questions )
Updated with version 3.0. Link above is to new file.
Ran B's weight & volume calculator
Ran B's weight & volume calculator
Last edited by CMV on Sat Jan 05, 2013 12:50 pm, edited 1 time in total.
--------------------------------------
"Sorry but you cannot use search at this time. Please try again in a few minutes"
"This board is currently disabled"
These things make me
"Sorry but you cannot use search at this time. Please try again in a few minutes"
"This board is currently disabled"
These things make me
Re: Ran B's weight & volume calculator
I sent the file out to those who asked me for it. But then a little while later I found a few mistakes in the file which I corrected and resent to those who had the first one.
To use the file you need MS Office Excel. By filling in several variables like tube outside and inside diameter, length, baffle size and material thickness, you can obtain an approximation of how much volume the parts take up in the tube and how much the final product will weigh. The blue cells on the spreadsheet are for the variables you enter, the red cells are the results of the data entries. It is only set up for 60 degree baffles.
For example a K baffle takes up a bit more room than a cone baffle and spacer. This is mostly due to the thicker front flange on the K baffle.
Please let me know if you have any suggestions or find any mistakes.
Ranb
To use the file you need MS Office Excel. By filling in several variables like tube outside and inside diameter, length, baffle size and material thickness, you can obtain an approximation of how much volume the parts take up in the tube and how much the final product will weigh. The blue cells on the spreadsheet are for the variables you enter, the red cells are the results of the data entries. It is only set up for 60 degree baffles.
For example a K baffle takes up a bit more room than a cone baffle and spacer. This is mostly due to the thicker front flange on the K baffle.
Please let me know if you have any suggestions or find any mistakes.
Ranb
SilencerTalk was a place I could disccuss making registered silencers without being told I was a criminal. That is no longer true. http://www.silencertalk.com/forum/viewtopic.php?f=132&t=99273
- Enfield577
- Silent But Deadly
- Posts: 805
- Joined: Mon Mar 28, 2011 6:29 pm
- Location: New Zealand
Re: Ran B's weight & volume calculator
That is excellent - thanks for that
Man you are the biz with XL
Man you are the biz with XL
Of all the things I've lost it's my mind I miss the most
Re: Ran B's weight & volume calculator
very nice, thank you for making it available to everyone.
- Bendersquint
- Industry Professional
- Posts: 11357
- Joined: Sat Jan 07, 2006 7:19 pm
- Location: North Carolina
- Contact:
Re: Ran B's weight & volume calculator
Will this work on a MAC? I haven't really played with numbers on it.
- chrismartin
- Silencertalk Goon Squad
- Posts: 4226
- Joined: Sun Mar 12, 2006 7:18 pm
- Location: Tidewater, VA
Re: Ran B's weight & volume calculator
It appears to work fine. I'm using Office 2011 for the Mac.Bendersquint wrote:Will this work on a MAC? I haven't really played with numbers on it.
- Bendersquint
- Industry Professional
- Posts: 11357
- Joined: Sat Jan 07, 2006 7:19 pm
- Location: North Carolina
- Contact:
Re: Ran B's weight & volume calculator
Is that the cross over for using Win stuff on a Mac? Did you use NUMBERS?chrismartin wrote:It appears to work fine. I'm using Office 2011 for the Mac.Bendersquint wrote:Will this work on a MAC? I haven't really played with numbers on it.
Re: Ran B's weight & volume calculator
AWESOME tool....TY for sharing
I.M.O.
Trooper E.A. Hill R.A.C.
10/10/41
Trooper E.A. Hill R.A.C.
10/10/41
- chrismartin
- Silencertalk Goon Squad
- Posts: 4226
- Joined: Sun Mar 12, 2006 7:18 pm
- Location: Tidewater, VA
Re: Ran B's weight & volume calculator
No, I'm using the native Mac OS X verison of Microsoft Office 2011.Bendersquint wrote:Is that the cross over for using Win stuff on a Mac? Did you use NUMBERS?chrismartin wrote:It appears to work fine. I'm using Office 2011 for the Mac.Bendersquint wrote:Will this work on a MAC? I haven't really played with numbers on it.
The formulas that are being used don't look too crazy though, just basic maths.
I opened it up in Numbers and it looks like all the formulas came over fine.
Re: Ran B's weight & volume calculator
The most advanced math I used was the trig function tangent of 60 degrees. The rest is your basic +-/* and squaring.chrismartin wrote:No, I'm using the native Mac OS X verison of Microsoft Office 2011.
The formulas that are being used don't look too crazy though, just basic maths.
I opened it up in Numbers and it looks like all the formulas came over fine.
Ranb
SilencerTalk was a place I could disccuss making registered silencers without being told I was a criminal. That is no longer true. http://www.silencertalk.com/forum/viewtopic.php?f=132&t=99273
- BeerWolf
- Silent Operator
- Posts: 69
- Joined: Sun Jun 24, 2007 3:40 pm
- Location: In the mountains of north-west Arkansas.
Re: Ran B's weight & volume calculator
Very nice, Ranb.
Thank you.
Thank you.
Don't it always seem to go, that you don't know what you got 'til it's gone?
Re: Ran B's weight & volume calculator
Ranb, please add my compliments for your generosity.
EXCEL + OSX 10.6.8 = EASY.
Glad you cleverly got away from having to also use Finite Element Method and
Non Linear Wave Propagation in Random Media calculations.
Best!
EXCEL + OSX 10.6.8 = EASY.
Glad you cleverly got away from having to also use Finite Element Method and
Non Linear Wave Propagation in Random Media calculations.
Best!
Re: Ran B's weight & volume calculator
updated with new version
--------------------------------------
"Sorry but you cannot use search at this time. Please try again in a few minutes"
"This board is currently disabled"
These things make me
"Sorry but you cannot use search at this time. Please try again in a few minutes"
"This board is currently disabled"
These things make me