Are these good ideas for sizing Air-Tites? Is it correct to choose the next size smaller ring when a coin's diameter contains a fraction? I also wonder if you would recommend a ring for a 6 sided 31mm coin? (1992 Tanzania 20 Shilingi) Finally, I have a rectangular piece that I'd like to attempt to mount with the 16mm ring in the H holder. Dimensions are 16.6mm x 24.2mm. (1859-68 Japan BU) Taking an exacto knife to the ring to form the rectangular dimensions was my plan. What do you think?
Charlie - click on the link and print it out. Keep it ! http://www.jpscorner.com/Ring_Gauge.htm Then look at this - http://www.jpscorner.com/US_Coin_Sizes.htm And this - http://www.jpscorner.com/Gold_Platinum.htm Now that's about as much help as I can give you. But with that, you can probably figure out anything else.
Thanks for handling question #1 Doug. For question #2, I'm ordering one size smaller in addition to the specified diameter of any non-round coins. For question #3, I'll wing it and report back. I'm ordering them here: http://www.jpscorner.com/index.htm If any of you southern Wisconsin residents are interested, you can have free shipping on whatever you want from them since I've reached the maximum shipping charge. Let me know if you'd like me to order something for you.
Any Excel GURUs available? I have Airtite sizes needed ranging from 14 to 40 in a column. Is there a way to have the number of each size calculated? What's the formula!
Would try and find an exact size, But i know there are some odd sizes Out there that they just dont make, So would get as close as i could And get a bigger inner ring to make up the difference!
I'm not sure what you are asking here Charlie. For example- the size 14 you mention is 14mm in diameter - it fits a 3 cent silver. What else is there to know?
Sorry I wasn't more clear. All the coins that I'm ordering Air-tites for are listed in a spreadsheet. One columm of the spreadsheet lists the size to order. The values in that column range from 14 to 40mm. I'm hoping for a formula that will total and list the number of each individual size within that column. (Like: 3-14mm, 6-15mm, 4-16mm........2-39mm, 1-40mm)
Charlie: I use Excel 2008 on a Mac and I'm no guru with the application, but there's a function called Conditional Sum Wizard in the Tools menu that you can define which values to calculate. Give that a try and see if it does the trick.
Without knowing your exact cell coordinates for each we can't help you much. But it's a SUM formula and quite simple. You should be able to figure it out easily enough just by following the Excel prompts. If you can't, email me the spreadsheet and I'll do it for you.
It can be done but requires doing some programming in Excel. And that's a nightmare. I used to program in Fortran and I found Excel to be not intuitive. Plus the documentation is terrible. It is something I probably won't try again.
I had to load the conditional sum add-in but it works like a charm. Thank you Well, I ended up having to find this formula so that I was getting the number of occurences rather than a sum each value: =COUNTIF(E1:E100,"14") (Where the E column is the size column. The 14 is changed for each size 14mm through 40 mm.) Thanks Doug, I think I have it. I never used a spreadsheet before but it seems needed for the coin collecting thing.
