Disorganized or old or both?

@lordmarcovan Just think of yourself as as an older car odometer--you'll wind up starting over again from 00000.

 

Log in or Sign up to hide this ad.

That is the beauty of a simple "proper" spreadsheet that catalogs generally only the coin information found in numerous locations. Once the info is included in the spreadsheet, it never needs to be entered again, just the absolute info address. Think about your collection as you would a Library, with you being the Librarian.

I've many spreadsheets that are all linked, so that a specific coin can be readily located in a storage system of many containers, that was properly generated.

I don't believe I've ever lost a coin in my voluminous system. At least I can normally determine in a matter of hours if I've acquired a coin from past printed documents, and where it might be.

The biggest problem is locating a simple functional spreadsheet, as most have evolved for presentation rather than coin identification/location/values.

JMHO

 

Among my hand-me-downs are various series from The Franklin Mint. I don't think you were young and stupid, cause I really like 'em. They're all from the 1970's. They are really miniature works of art - extremely detailed, intricate designs, very stunning and captivating (for me at least). I can examine them for a long time. I googled the Franklin Mint last year. What happened to them? Nowadays, they just sell overpriced worn vintage coins. Here are two, to show the level of details. (I especially enjoy reading the stories behind each piece that always accompany the series.) (Sorry OP to go off-topic.)

 

After tiring of buying duplicate coins, I decided to use my limited computer skills to create spreadsheets of all my coins. Since I have several hundred, it took me about a month to track them all down, sort them, and then catalogue them. Now i have quite a few different spreadsheets, but only one master locator spreadsheet (by date). Every time i see a coin that interests me, I go to the master locator and can see at a glance if I already have that particular coin. When I do purchase a coin, I enter that info into several sub-sections, and then onto the master locator. The three sub-sections list coins by raw, slabbed, and mint sets. This has saved me many a time when I see an interesting coin and almost buy it before I remember about my master locator. The master locator, of course, indicates where a specific coin is stored, so it will save me time when I need to update or upgrade any coin. So far, so good. I just have to remember to update everything when I do purchase another coin!

 

Just wondering... Even if you can't print today, do you have an old hard copy? You can scan and create a pdf file. Then today's Excel can read and convert it to a workable file. Of course, formulas in a cell would be lost, but at least you get the cell entries.

 

The numismatical blunder of them all was forgetting which glass had the Ginger Ale.

https://www.numismaticnews.net/archive/drinking-and-coin-cleaning-a-deadly-mix

 

I don't know, I've had a few drinks in my day that made me feel like I was going to die.

 

Heck of a story, and sounds like something I might easily do. I do not use cyanide. I routinely drink beer or scotch and work on my coin inventory. Yes, I sometimes make mistakes. But then, later I find and correct them, so it is a form of job security.

 

Are the number of mistakes directly proportional to the volume of beer and scotch consumed? It sounds like a worthy scientific study.

 

I am not that analytical. If I am doing something simple, then I just go for it. If the job is more complicated, then I take notice of how loaded I might be and just knock off from the coin work.

 

Thank You! Yes, that would work, but I converted to QPro files which are no longer supported/un-printable, but I retain my complicated formulas, and capability to reformat the cells, etc,. I need to use an older version O.S. that will support Fat32 files, but retain the organizational capabilities that I haven't seen in excel/others.

You're correct that I could convert to Microsoft Excel XLS, etc. format, and then to PDF, etc. losing the calculating/file-integration capabilities that made Lotus such a desirable spreadsheet that Excel and other programs currently utilize in reduced formats.

I could still utilize your suggested capabilities, but lose the integration functions I've never found in other programs.

Thanks for your thoughtful input.

JMHO

 

I think I did, but can't remember. Seriously, getting old and having a failing memory is the worst ever.

 

I have been thinking about imrich's problem with the lotus and QPro...if you can still view the old files, how about just manually enter the data into a modern spreadsheet? I do work like that all the time. Sure is it tedious, and it can be done. I am right now editing every row in all my spreadsheets, so that will be more than 10,000 entries to do. I am constantly finding errors and correcting them.

 

http://www.differencebetween.net/te...nology/difference-between-excel-vs-lotus-123/

Unless you've studied/utilized the code for various firms accounting applications, even before the 5.25 single sided "floppy" IBM was available using hand-helds as the TI58, etc. for expedience of book-keeping, it's difficult to explain the difference. The aforementioned link, I believe, relatively explains some differences that generally eliminates errors in the individual cells/linked-spreadsheets.

An integral formula directory, although it takes great planning, really simplifies error reduction in spreadsheets, and readily facilitates locating of same.

JMHO

 

Apples and oranges. I am talking about manually typing the whole thing anew. I am retired and have plenty of time, and willingly take on such tasks. It does help that I can type fairly well and have great capacity for detail. In the past, when I worked for a living, I took care of the spare parts inventory, which included a lot of hand counting of parts and placing them in the proper bins or shelves. Most people did not like that kind of work and seldom did a really good job of it. They all seemed to expect to do a few clicks of a mouse and have it all happen by magic with no hand labor involved.

 

I haven't looked at this thread for a day or two, but I just thought of something that will or has affected the use of Microsoft products. A couple of months ago, I signed on to EXCEL and found it was frozen and I got a note from Microsoft, telling me that I would have to pay an annual usage fee of $99 to use their product. I tried to reboot, but got the same message. EXCEL was locked. I then check Word and got the same message. When I contacted Microsoft, I told them that I had "bought" the Microsoft package a few years ago. Why did I have to start paying ransom for the use of something I already paid for. I was told it did not give me the right of using Microsoft in Perpetuity. I was told that if I tried to modify a Microsoft product for use, I would be in violation of my license to use the product.
Anyone else go through this stuff by Microsoft?

 

Anyone who understands the history of Microsoft where an individual unrelated to the O.S. code development, after a contact by IBM wanting to develop an open-source computer, bought the code for a pittance and became a billionaire by selling use-licenses.

Yes, I've dealt with them numerous times to acquire a new altered license.

Your license has expired, and the company-originator-exwife? needs your money.

I believe you'll find that the Excel code originator was predecessor/Lotus.

JMHO

 

I feel no need to enrich some billionaire. I love using my free, open source OpenOffice software. For photo editing I use PhotoScape, another excellent and free program. Here are a couple of images edited with that program.

 

I should have kept my Lotus that I used for over 15 years. I do like EXCEL and Word, but $99 a year is crazy. Another thing that happened. When I bought my computer, it came with a security software (from Best Buy). I had forgotten and I knew that I needed one, so I bought McAfee's. After a few months, I was at Best Buy and I was talking to an employee and was told I already had a 3 year contract for their security software, so, I let the McAfee's expire. Now I get between 8 and 10 email from them. I've tried to get them to let them know I already had another security software, but to no avail. I just spam them. It's easier than trying to get a live person.

 

Oh hell no. I’ve found coins that I wanted to give to my grandbabbies on the weekends and misplace them more times then no. Have 13. A few I started books for cuz their to young. The rest I try to set aside. It’s has gotten sometimes to the point that I give it to the wrong child. After maybe 2 months I finally found me lucky @Kentucky Abe (AT toned ) cent. I was stepping on it the whole time in my office