GTA
All Springer/NP/PCP Air Gun Discussion General => "Bob and Lloyds Workshop" => Topic started by: lloyd-ss on March 13, 2018, 03:37:37 PM
-
Some of you are probably already familiar with these, but here are a couple of handy calculators.
First is for the air efficiency for a pcp shot string.
You need the starting pressure and ending pressure of the string; the volume of the gun's air reservoir, the number of shots in the string, the average fps for the string, and the pellet weight.
Air Efficiency Calculator
http://calc.sikes.us/1/
The second calculator is for how many times you can fill your gun from a high pressure air tank.
You need to know the volume of your gun's reservoir in cc's, and you need to know the volume of your high pressure air tank in Cubic Feet. There is a chart at the bottom to help convert the cubic inch bottles and the "minutes" scba tanks to cubic feet like regular scuba tanks. Be careful to enter the correct pressures in all of the blocks.
Airgun Fill Calculator
http://calc.sikes.us/2/
Lloyd
-
If I told you how many times Ive used those you wouldn't believe me. I wish I had those on and phone app so I could just pop it up.
-
If I told you how many times Ive used those you wouldn't believe me. I wish I had those on and phone app so I could just pop it up.
;) Do we have a volunteer in the room who writes phone apps? ;)
-
If You could put all your stuff on and app and Im talking ALL your stuff you could sell it easy and I would be the first customer. With your spread sheets and Calculators Id bet you could sell that app for $20 a pop and get lots of takers and the cool thing is it cant be copied as and app. JUST SAYING ;D
-
These pages by LLoyd are not longer working? That would be sad.
-
Airguns of Arizona has a fill calculator you can pin to your phone.
-
Thanks. Do you know where to get a pcp efficiency calculation formula, or app.? Lloyd's was the only one I was aware of.
-
If there is a way for the forum website to handle html/php code, the calculators could be moved there. The site these were on is no longer available and they need a new home.
I also have them in excel format but it's kind of clunky. Visual basic or something else like a phone app would be better. I just can't do the transfer and/or reprogramming myself.
Lloyd
-
Hopefully the administrators will know how to handle this. The forum can't let the calculators vanish in the air, imho...
-
Definitely a vote for the forum to take them over! :D
I've used Lloyd's calculator many times while doodling different designs-it would be a terrible waste for it to vanish; after he went to the trouble of making it available to us all.
(BTW, thanks Lloyd!)
Jesse
-
upwork.com/ab/profiles/search/?pt=independent&q=programmer%20php%20android
I'd tip
-
I have a calculator in my signature that does this and so much more fwiw. google sheets so its accessible via mobile or pc.
-
Thanks!
-
I have a calculator in my signature that does this and so much more fwiw. google sheets so its accessible via mobile or pc.
Hi there. When I tap on the link, is gives me a message about requesting access. I am guessing that with the amount of people who might want to want use this, perhaps you will want to change permissions. I would set it so it is publicly available to "anyone with the link" ... The access defaults to anyone having the link being only a viewer, so they can't actually change your file.
-
... The site these were on is no longer available and they need a new home ...
Hi Lloyd, I just tried infinityfree.net, which seems to fit your criteria. You could probably just upload your files there ...
http://appye.rf.gd/ (http://appye.rf.gd/)
I just created a simple hello world at the link above using my phone ... They give you several subdomains to choose from, and php is supposedly happy there.
-
... The site these were on is no longer available and they need a new home ...
Hi Lloyd, I just tried infinityfree.net, which seems to fit your criteria. You could probably just upload your files there ...
http://appye.rf.gd/ (http://appye.rf.gd/)
I just created a simple hello world at the link above using my phone ... They give you several subdomains to choose from, and php is supposedly happy there.
Patrick, Thanks very much for the info and link. I will talk to the IT team (my wife) and see if she is willing to make the transition. The new site might be helpful for her, too, so might have some leverage, LOL.
Thanks,
Lloyd
-
Well, hopefully the IT division will bring one of my favorite tools back to life!
-
HI Lloyd!.... Nice to see you again, buddy!....
Bob
-
HI Lloyd!.... Nice to see you again, buddy!....
Bob
Hi Bob,
Very good to say hello, and I hope you are doing well and staying busy. The airguns are more-or-less collecting dust as the OEM technology continues to make huge advances.
I do a little bit of lurking, but priorities have changed and the available hours in a day seem to be less. Or more like, what I get done in the available hours has become less. I am still building lots of things in my shop and outside.
Here is a pic of my latest machine. It helps with my motto of, "Learn something new every day."
Lloyd
-
HI Lloyd!.... Nice to see you again, buddy!....
Bob
Hi Bob,
Very good to say hello, and I hope you are doing well and staying busy. The airguns are more-or-less collecting dust as the OEM technology continues to make huge advances.
I do a little bit of lurking, but priorities have changed and the available hours in a day seem to be less. Or more like, what I get done in the available hours has become less. I am still building lots of things in my shop and outside.
Here is a pic of my latest machine. It helps with my motto of, "Learn something new every day."
Lloyd
booster pump?
-
Lloyd, you have me stumped on that one!.... ::)
We have a 7 month old Lab puppy that is at present stealing everything she can reach.... I haven't even stepped into the shop this year!.... :(
Bob
-
Bob,
All I can say is high speed double acting air cylinder. Notice the 4 shock absorbers in the middle? The whole cylinder assembly slides like field artillery, so it doesn't destroy itself.
Ah yes, lab puppies are so cute, when they are being cute, haha.
Our daughter and her family got a second lab that is just about the same age as yours...... and behaves like yours. From my experience, I think lab puppies come in 2 types: the sloppy friendly ones that roll on their backs and accidentally knock things over and want you to pet them, and, the mischievous ones where you are just hoping that the adolescent stage will end soon.
Lloyd
-
Bob,
All I can say is high speed double acting air cylinder. Notice the 4 shock absorbers in the middle? The whole cylinder assembly slides like field artillery, so it doesn't destroy itself.
Ah yes, lab puppies are so cute, when they are being cute, haha.
Our daughter and her family got a second lab that is just about the same age as yours...... and behaves like yours. From my experience, I think lab puppies come in 2 types: the sloppy friendly ones that roll on their backs and accidentally knock things over and want you to pet them, and, the mischievous ones where you are just hoping that the adolescent stage will end soon.
Lloyd
I have two lab puppies and your right. Female gets into everything and the male just falls over and wants his belly rubbed.
-
But I've never run into a lab that wasn't a wonderful dog...... eventually, ha ha.
-
Looks more like you are fatigue cycle testing something?
Marko
-
Looks more like you are fatigue cycle testing something?
Marko
Good guess. It does cycle, but it is a launcher. Like an over-engineered potato gun. It has to fire projectiles that vary in diameter and in mass, such that the kinetic energy repeatably falls within a narrow range. It replicates a real-world phenomenon.
-
Here is a basic PCP air efficiency calculator for Excel. Nothing fancy. It works for PCPs with, and without, regulators.
To download, right-click the file, and click "Save As", and it should show up as a .txt file. Save it.
If you are successful in downloading and saving the file, rename the file to change the .txt extension to .xlsx before opening it.
If the Excel file cannot be downloaded with a .txt extension, we'll have to try a different method for you to get access to it.
Lloyd
-
Here is a basic PCP air efficiency calculator for Excel. Nothing fancy. It works for PCPs with, and without, regulators.
To download, right-click the file, and click "Save As", and it should show up as a .txt file. Save it.
If you are successful in downloading and saving the file, rename the file to change the .txt extension to .xlsx before opening it.
If the Excel file cannot be downloaded with a .txt extension, we'll have to try a different method for you to get access to it.
Lloyd
Just downloaded it-worked for me; although I opened it slightly different-I opened the Properties menu, and selected Spreadsheets to open it (WPS Office in my case)-opened right up as the calculator...
Thanks Lloyd!!! :D
Jesse
-
This is Lloyd. I did post that file in reply #26, and it does have excel code in it for the PCP air efficiency calculator, but it contains no macros nor viruses. Just the file for the efficiency calculator. I don't think so, but I might have violated a GTA rule, and if so, I apologize. If I did, please delete the file in reply #26. If that is the case, anyone who wants the calculator can contact me via PM and I will send them the excel file.
Sorry for any violations or confusion.
Lloyd
-
Here is a basic PCP air efficiency calculator for Excel. Nothing fancy. It works for PCPs with, and without, regulators.
To download, right-click the file, and click "Save As", and it should show up as a .txt file. Save it.
If you are successful in downloading and saving the file, rename the file to change the .txt extension to .xlsx before opening it.
If the Excel file cannot be downloaded with a .txt extension, we'll have to try a different method for you to get access to it.
Lloyd
Just downloaded it-worked for me; although I opened it slightly different-I opened the Properties menu, and selected Spreadsheets to open it (WPS Office in my case)-opened right up as the calculator...
Thanks Llyod!!! :D
Jesse
Jesse, glad that it worked ok. Thanks for letting me know.
I had hoped to get the calculator re-posted to the web, but the IT department, ha ha, said the wait time is measured in months..... if I am lucky.
-
Just downloaded it-worked for me; although I opened it slightly different-I opened the Properties menu, and selected Spreadsheets to open it (WPS Office in my case)-opened right up as the calculator...
Thanks Llyod!!! :D
Jesse
Just realized that I transposed some letters in your name-apologies!! :-[
Haven't yet figured out how to get it saved as a .xlsx file; but it's working just fine as-is, makes a very handy tool to get a better grip on possible performance of different-size reservoirs-just in time for me to start getting back out in the shop too ;D
Thanks again Lloyd,
Jesse
-
Lloyd,
I don't think there is any problem with your attachment in this thread, because you explained exactly what it is. I raised a query about your test attachment in the backroom via email, not because I thought you were being naughty, but because I though someone might have hacked your GTA account.
If .XLSX files are not listed as an acceptable file type for attachment on GTA, but ZIP files are, then ZIP your Excel file and attach it. Usually I am weary of downloading ZIP files because it is easy to make them self extracting with malicious code. That was not my concern when I emailed you. Rather that someone else, posing as you might have done it.
-
Lloyd,
I don't think there is any problem with your attachment in this thread, because you explained exactly what it is. I raised a query about your test attachment in the backroom via email, not because I thought you were being naughty, but because I though someone might have hacked your GTA account.
If .XLSX files are not listed as an acceptable file type for attachment on GTA, but ZIP files are, then ZIP your Excel file and attach it. Usually I am weary of downloading ZIP files because it is easy to make them self extracting with malicious code. That was not my concern when I emailed you. Rather that someone else, posing as you might have done it.
Actually, I am glad you brought that to my attention. I uploaded that file rather casually, without thinking that it could be viewed as suspect, even though I knew it was clean. It's like having a close call in the shop: no harm is done, but it really wakes you up as to what MIGHT have happened.
-
Looks like a rail gun. But for potatoes?
The excel file downloaded and opened perfectly. Thanks.
P.S. In my perfect world, your project would be focused on figuring out what makes a batch of pellets great. I can sort a typical batch of JSB .177 13.4 MRDs to the nth degree but get wider spreads than a "great" shooting batch that isn't sorted and varies wildly in weight, head size, yrrah roll, head and skirt appearance, joker-device concentricity, etc.
-
I am sorry gentlemen, I am always terribly late in my respones as I don't follow the forum reguralry.
I downloaded the efficiency calculator and works fine in LibreOffice in Linux.
However, the last column I think it must be renamed "FPE per cuin" (not cuin per FPE). Hence, the higher the number the bigger the efficiency.
-
I am sorry gentlemen, I am always terribly late in my respones as I don't follow the forum reguralry.
I downloaded the efficiency calculator and works fine in LibreOffice in Linux.
However, the last column I think it must be renamed "FPE per cuin" (not cuin per FPE). Hence, the higher the number the bigger the efficiency.
Stavros,
You are correct. Thank you for catching that. I will make the change to the file and upload it again.
In the mean time, anyone can make the correction on their own copy, by enabling editing. The password to do that is in cell P1 of the spreadsheet.
-
Lloyd, Your Efficiency Calculator is still as good as ever. Thank you and Bob again for all you contribute. You both are a gem.
Patrick
-
If I told you how many times Ive used those you wouldn't believe me. I wish I had those on and phone app so I could just pop it up.
The ChairGun IOS App has those built in.
-
Hawke Chairgun and X-act
https://www.hawkeoptics.com/chairgun-and-x-act-end-of-life.html (https://www.hawkeoptics.com/chairgun-and-x-act-end-of-life.html)
-
I have Lloyd's spreadsheet and with his permission I'm working on getting it back online.
I'm also working on making it into an App you can download to your phone.
This is of course all FREE!
Once I get a bit further down the road I'd like a few testers.
-
I have Lloyd's spreadsheet and with his permission I'm working on getting it back online.
I'm also working on making it into an App you can download to your phone.
This is of course all FREE!
Once I get a bit further down the road I'd like a few testers.
Your a HERO in many eyes 8) 8)
-
Not a Hero. Lloyd and Bob did the hard work.
All I'm doing is trying to pay back the AG community for what I learned.
I'm a pretty slick programmer when I wanna be.
I've made good friends here in the AG forums so it's time to pay back in a way I know how.
-
8)
Just in time I have some recent builds I could run some numbers on sometime!
-
I've got a site setup and tests for working are great.
There's also those things you take a picture of and can go to the site on your phone.
That works great! Not ready for business but looking real good!
-
I have Lloyd's spreadsheet and with his permission I'm working on getting it back online.
I'm also working on making it into an App you can download to your phone.
This is of course all FREE!
Once I get a bit further down the road I'd like a few testers.
Thanks Jeff. I appreciate your taking the lead on this.
-
Whaddaya know, da boy got talent! ;D
Thanks Jeff!!!
-
Today I tested the App installation to my Android phone. That worked great!
Now I need to finish the stuff to get it to work properly.
When SWMBO is home I'll have her test on her phone since she has an IPhone.
Once I'm sure that the App stuff installs properly? I'll work on the final looks and math involved.
As it is right now? The App does work fine on my Android phone. Just need to get the fields to display properly and have a better interface.
-
Bob and lloyd make my head hurt, David
-
Bob and lloyd make my head hurt, David
You and me both.
I never was much good at gosindas.
-
gosindas?.... Even Google couldn't help me with that one!.... ???
Bob
-
gosindas?.... Even Google couldn't help me with that one!.... ???
Bob
You know... 12 gosinda 24 2 times.. I think.
-
gosindas?.... Even Google couldn't help me with that one!.... ???
Bob
That is the first math statement I've ever seen Bob confused by!
;D
-
Hey Guys,
So what are the obstacles to getting this up and running again? Then again I'm pretty naive on this one ........ :P
- Lloyd certainly knows how to do it as its been done ........... copy/paste?
- Has something expired costing $$$ to re-establish?
- I think Bob/Lloyd could send a rocket to the moon ..... ;)
- Gosindas ..... yeah, my immediate reaction was ???
-
Lloyd did post a download to his spreadsheet.
It won't work with Open Office but you can upload to Google Sheets and it works there.
-
Lloyd did post a download to his spreadsheet.
It won't work with Open Office but you can upload to Google Sheets and it works there.
I just opened Lloyd's spreadsheet in LibreOffice and it worked fine.
If you need help testing on iPhone/iPad let me know I have both.