Banned by my job and my home ~~fini on this topic. There is no reason to discuss excel, because only an idiot would create software with it or use it.
I refer you back to post #36. So without knowing me or anything about me you surmise I am an idiot. I don't think I have ever come across such a shallow, agenda driven, negative person. But, you seem to be well balanced, with a chip on both shoulders
Probably I would use these tools https://mariadb.com/kb/en/mariadb-connector-c/ https://www.gtkmm.org/en/ maybe https://projects.eclipse.org/projects/tools.cdt https://projects.eclipse.org/projects/modeling.mdt.papyrus https://pypi.org/project/labelImg/
MS has pretty good software. Their office suite includes a tool which checks spelling and grammar… but you don’t need that, write? :-D
https://www.tensorflow.org/ and xsane - ideally you would take an image of the coin and the AI can identify the coin or prompt you for an ID, and you can then scan in the receipt, and store everything on a mysql database back end with a GTK+, network enabled, front end. Maybe webdav can be pulled into it somehow.
I have used Coin Elite for at least 25 years. It seems to be as good as anything out there and is customizable.
I am a CPA (I'm retired now.) and I have been using some type of spreadsheet program since my first computer, the Osborne I. It looked like a sewing maching when it is folded up. It had a monochrome screen about 5" x 5" (maybe a little larger), one 180KB floppy disc drive, and no hard drive. We used a software package for a spreadsheet named Supercalc. Later, when we actually got a computer-like, it had a full size screen but was still had a monochrome, and a floppy 8"x8" (maybe different measurements. it was 1983.) disc drive. I took classes on the computer and I continued to upgrade it. Eventually, I had a color monitor, 2 flippy drives and a 10mg hard drive. I used a spreadsheet program named Lotus. It wasn't too much later that we got larger and faster hard drives and disk drives. They were no longer floppy. I was working for the state and they were coninually upgrading computers and software. Eventually, all desks had Compaq computers and the Microsoft package which included Word, Access, and finally Excel. Our computers and software packages were continually upgrading the Microsoft software. Currently, I have Microsoft 365. The only thing I don't like is that I have to pay licensing fees each year, where previously, when we bought Microsoft Office, upgrading was at our discretion. Anyway, Excel is stronger and faster than it ever was. There are some changes that users will have to learn, but I have been using Excel longer than many of you have been on the Earth. It's the process of keeping up with the upgrades that makes Excel difficult. I don't have as many coins most of you have, so it's not has hard for me to keep up with what I have. Best of Luck. Buy and Use what you find easier and the most complete for your use.
http://opennumismat.github.io/open-numismat/manual.html 1 Introduction 1.1 Description OpenNumismat is a handy and reliable application designed for collectors of coins and coin collectors, to create a numismatic collection. With OpenNumismat you will be able to create, organize, and manage your own catalogs of coins with detailed descriptions and photos for each item. OpenNumismat is distributed in full absolutely free. The source code is licensed under the GPL-3.0 and available at GitHub. Official website is located at http://opennumismat.github.io. 1.2 Features of the implementation OpenNumismat is based on the PyQt library with the SQLite database engine to store the data collection, which allowed to achieve lightness and responsiveness of the interface and cross-platform. A complete list of the used components and libraries is available here. Icons used in the interface, based on the LED Icon Set v1.0, Soft Scraps Icons by deleket and Flag icons. Translation of the interface implemented by enthusiasts using the service Transifex. Thank you for the help! 1.3 License OpenNumismat is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. OpenNumismat is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with OpenNumismat. If not, see https://www.gnu.org/licenses/. 2 General view When you first start the application, the main window opens with a demo collection: The main window consists of the following main elements: Table of coins Image panel Tree Info panel When you click on any coin in the Table of coins, detailed information is displayed: in the Image panel - coin photographs, the Tree unfolds to the element describing the coin, the Info panel displays all the entered coin data. You can create a new empty collection or edit a demo by entering new data. 3 Entering coins 3.1 Adding a coin Manage your collection by adding entries about every bought, sold or wished coin. To add a new coin, select the Coin->Add menu or press the Ins key. After that, the Edit dialog opens: The Edit dialog contains 6 tabs with the following fields: Coin - Main details: Name - a descriptive name of the coin (can be automatically created from the remaining fields by clicking the "Generate" button); Region; Country; Period - period in the history of the country; Ruler; Value; Unit; Year; Mint; Mint mark - a sign of the mint; Type; Series - a series of commemorative coins; Subject - an event or object to which a commemorative coin is dedicated.
I have (in the past) used Coin Collector's Assistant plus (Carlisle) BUT when it is time for upgrade you basically pay the same as purchasing it new. I found a programthrough "Trove Software called Collectors Assistant, around $35-$40, and it is extremely easy to use (it has to be in my case) you can download a sample version on line. (Windows Platform Only) JMO Semper Fi Phil
I was going to say Heritage My Collection, but I see Lehigh 96 beat me to it. You get updated wholesale and retail values and lots of places to put notes. I agree that the organization is sometimes a bit funky, but the price is right--Free! All you have to do is register on the site. Another free program I use is the PCGS site. I am working on several Registry Sets, and it's great for that. You can put in your whole inventory of coins, with obverse and reverse pictures. One feature I really like is the Virtual Album. You can have your coins in the PCGS slabs with enlarged photos of the obverse and reverse of each coin in what look like slots in a coin album. Really neat, IMO.
For now, I use Excel. I have tried Pro Coin, Coin Manage and Exact change, But I find the look and interface to be too umm.. 'Windows 3.11" looking..
Actually, I have had a chance now to work a little with OpenNumismat, and frankly, it is quite impressive. It runs locally so you don't need to sell your soul to the devil. It has not security issues that are currently known. It eats up images like a sponge and uses a solid sqlite back end. I would refer a more flexible back end, but it seems to work seemlessly. It imports everything and has excellent report functions. It has a lovely hierartical database access that lets you dig deep very quickly. If it had an AI that would be nice. Seems intuitive, but is highly adjustable and talks to several mainstream coin websites