Introduction:
One of my client wishes to make a database / inventory of items purchased by him over period of time. The items are numismatic items (old coins). He wishes to have a data base in order to know in details about the items in his inventory.
His aim is to have a database ready for-
1) To avoid repurchase of same / similar items from his database. To achieve this correct coin details are needed to be entered. He expects to have image of the items in the database. The image should be expandable, after clicking on the smaller image. In general there are 2 images of each item front and back. Some items have only one image .
2) To keep a track of his purchase cost, and hence the costing part including the taxes (GST/ VAT and service tax ) is important .
3) Grouping of the purchase from different vendors/ material, Category etc. Data should be exportable in other programme.
I will provide invoices containing the details of the items and the costing part. These invoices are from vendors. I will be providing the web address of the vendor. You have to take the image from the website. For rest of the data its up to you to copy paste from the website or typed by self from the invoices. In the course, initial 2-3 items you will find it difficult but once done it will be easy for you
It is expected that you should have a good knowledge of macro/xlxs development, and basic knowledge of search and data entering and photoshop
Attached;
1) Here I am attaching a template which is not perfect and need correction.
2) Invoice from todywalla auctions web site go in search put lot number and auction number you will find the details.
You only need to enter 1) vendor details , part 2) coin description part 3) costing part. Rest other part like remark extra disposable, will be added by me. 4) Less than 2% of coins have size and weight mentioned kindly enter it, or if you do not wish to enter leave it I will do it.
Corrections in this template are in red
Column :Source: ( A auction B dealer C other (presently all items are from auction, in future purchase will be from dealers and others) you can add the columns later also (if it is easy, and I will enter the data in it. If you think it will be difficult to enter the columns later kindly add it now, I will enter the data)
Column KM: add column for denomination, weight dimension, material: this can be done later also (same as above)
Description: in template there is link - I do not wish to have link
Image - when clicked on smaller image bigger image should come .
It is expected that the macro should not be rigid, for example if in future I wish to enter another Coolum to the macro with data base, I should be able to enter a column and enter information in future.
Sample work: you need to enter one invoice or 2-3 items from the invoice depending on satisfaction the current project will be awarded.
Cause of confidentiality: Please note that you will not copy or save the information, in any retrieval system or reproduce the Information provided or made available to you, in any means including but not limited to paper print electronic media, in any circumstances. You are not intended to contact the vendors by any means of communication. If you are not intended to maintain confidentiality kindly do not accept the project.
Please note: This current project is for if first lot of nearly 300 items. After success nearly 1500 items project will be awarded","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":337695},"skills":["Data Entry","IMacros"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-06-07T14:17:01+05:30","url":"https://www.toogit.com/freelance-jobs/MzM3Njk1"}
Remote Data Mining And Management Job In Data Science And Analytics
Find more Data Mining And Management remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$24.05
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
Need to categorize all my expenses from 2018 and balance my books between person and two corporate accounts
Looking for someone to skip trace lists of home owners to find current mailing addresses and phone numbers. There are many companies that offer this but very few are very accurate so im looking for top level data from the best sources.
Dat...read more
Hello, are you looking for a position to take your skills to the next level? Are you a self-starter? Are you system oriented? Do you love the opportunity to grow and love finding solutions rather than focusing on problems? Well, I have a position for...read more
Dear Candidate,
If youre looking for an interesting and challenging role, youre confident, willing to learn and grow, and willing to be apart of a growing company then you may just be the one to fill this exciting and unique position. read more
1. Looking for a simple license plate name generator to put on my website. Have a look at the website for an idea. I will share some example links with shortlisted candidates
2. I need to be able to upload a list of words that users will not...read more