| Author |
 Topic  |
|
|
thedude
Penny Sorter Member
26 Posts |
 Posted - 04/20/2010 : 13:27:23
|
|
After learning how to use Excel yesterday I made two spreadsheets to help track copper percentages. The first spreadsheet calculates % per box based on three user inputs (# of pre-1981, 1982, wheat) PER ROLL. The second calculates % based on four user inputs (# of pennies searched, pre-1981, 1982, wheat). If anyone is interested I would be happy to send it to them. I can also change the inputs.
|
|
|
Country
1000+ Penny Miser Member
USA
3121 Posts |
Posted - 04/20/2010 : 14:49:19
|
Excel spreadsheets are nice. You should see the spreadsheets I maintain to keep track of the SILVER finds for RealCent.  |
---> Come to the new and improved realcent: http://realcent.org
The things that will destroy America are prosperity-at-any-price, peace-at-any-price, safety-first instead of duty-first, the love of soft living, and the get-rich-quick theory of life.
– Theodore Roosevelt
|
 |
|
|
thedude
Penny Sorter Member
26 Posts |
Posted - 04/20/2010 : 16:25:04
|
| I'd be interested in taking a peak. |
|
|
|
mingusdew
Penny Sorter Member
64 Posts |
Posted - 04/22/2010 : 15:56:44
|
Yeah, Excel can be an incredibly useful piece of software. I've been keeping up with a spreadsheet to track my finds ever since I started coin roll hunting 2 years ago, so it's packed with data for me to geek over by now! I even came up with a formula to estimate copper output based on the weight of the unopened box, so if it's light on copper I can just take it back unopened. I'd be happy to share the specifics of my spreadsheet later if I'm at my PC.
Out of curiosity, you mentioned entering data per roll - do you hand count the data you enter, or is it by weight? All of my numbers are calculated based on weight, so there's a degree of error involved. My numbers don't account for coins that are worn, covered in a foreign substance, or boxes which may have dimes or a few more/less pennies than the expected 2500.
|
If you could kick the person in the pants responsible for most of your trouble, you wouldn't sit for a month.
-Theodore Roosevelt
Fortune favors the informed. |
|
|
|
thedude
Penny Sorter Member
26 Posts |
Posted - 04/28/2010 : 16:09:49
|
Country: Your files appear to be incompatible with my mac.
Mingus: Hand count all the way! |
|
|
|
johnsonjohn2441
Penny Pincher Member
USA
102 Posts |
Posted - 04/28/2010 : 17:32:21
|
| wow you are quite the computer genious! |
|
|
|
johnsonjohn2441
Penny Pincher Member
USA
102 Posts |
Posted - 04/28/2010 : 17:32:40
|
| wow you are quite the computer genious! |
|
|
|
oktyabyr
Penny Sorter Member
USA
91 Posts |
Posted - 04/28/2010 : 17:58:56
|
| I'd be interested in both the copper and and silver one! :) |
|
|
| |
Topic |
|
Excel for Pennies
Forum Locked
