![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Excel Program for data conversion and duplication check
- or -
Post a project like this1105
£50(approx. $64)
- Posted:
- Proposals: 24
- Remote
- #3312142
- Awarded
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
20827022748046068869328493060696251264463387349126277543602736133143960487201114128
![Robert A.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/208270_70x70.jpg)
![MUHAMMAD Kashif M.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/f981574739dc1a7143168aea431b1393_70x70.jpg)
![Nikola T.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/ee6032106291dbdf202a5e8c5596d708_70x70.jpg)
![Saad K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/2d6315cc33d681e65cf59602c0d9c181_70x70.jpg)
![Sadiq T.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/f49fb4e0612de7992cac2810ffcf376e_70x70.jpg)
Description
Experience Level: Entry
Hi
I am a bookseller and want to find out a fast way to convert my book data, which I get in various excel formats, to a standard format, the fields of which are defined in the Masterdata attached.
We get various formats of Excel files from our Publishers/ Distributors, and as such the program would need to enable us to define/ match the different columns to be imported to the specified column. The program should be capable of appending data from more than one excel file so as to create one Master file from various excel files.
The other requirement we want is to give us the option of checking and deleting the duplication, both by default as well as giving us the option of which of the record of the duplicates we want to delete ( or maybe the data with lesser information of fields to be deleted by default. This duplication will need to be checked with ISBN field.
Another option we would require in this data is that once we have added various data and finalised the set of data, we should be able to transfer it into a master data file, and then, in the next round of data extraction, we should have the option of deleting from the new data the iSBNs which have already been stored in the previous master file. We should be able to extract the data of the books that we not in the earlier master data, and then we also need an option to transfer the new data in the master, to enable us to check the duplication of the subsequent data files from previously extracted data stored in the master.
If possible, we would also like to have a provision to convert the price of the book, generally given in Indian Rupees as per the attached formula, entered into a new field called price in GBP
Markup
=801 Taka/RS
=3001 Taka / RS
Book Value*2
Examples
Books Priced Rs 500= £ 15.75
Book Priced Rs 1000 = £ 27.22
Book Priced 3000= £ 81.66
Book Priced Rs 3500= £ 81.66
Book Priced R 4000= 88.89
Book Priced Rs 5000 = £ 111.11
Book Priced Rs 10000= £ 199.99
I am a bookseller and want to find out a fast way to convert my book data, which I get in various excel formats, to a standard format, the fields of which are defined in the Masterdata attached.
We get various formats of Excel files from our Publishers/ Distributors, and as such the program would need to enable us to define/ match the different columns to be imported to the specified column. The program should be capable of appending data from more than one excel file so as to create one Master file from various excel files.
The other requirement we want is to give us the option of checking and deleting the duplication, both by default as well as giving us the option of which of the record of the duplicates we want to delete ( or maybe the data with lesser information of fields to be deleted by default. This duplication will need to be checked with ISBN field.
Another option we would require in this data is that once we have added various data and finalised the set of data, we should be able to transfer it into a master data file, and then, in the next round of data extraction, we should have the option of deleting from the new data the iSBNs which have already been stored in the previous master file. We should be able to extract the data of the books that we not in the earlier master data, and then we also need an option to transfer the new data in the master, to enable us to check the duplication of the subsequent data files from previously extracted data stored in the master.
If possible, we would also like to have a provision to convert the price of the book, generally given in Indian Rupees as per the attached formula, entered into a new field called price in GBP
Markup
=801 Taka/RS
=3001 Taka / RS
Book Value*2
Examples
Books Priced Rs 500= £ 15.75
Book Priced Rs 1000 = £ 27.22
Book Priced 3000= £ 81.66
Book Priced Rs 3500= £ 81.66
Book Priced R 4000= 88.89
Book Priced Rs 5000 = £ 111.11
Book Priced Rs 10000= £ 199.99
![Sunil V.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/5c930b20c97c7587e1368de4c28ce2a8_150x150.jpg)
Sunil V.
96% (163)Projects Completed
223
Freelancers worked with
198
Projects awarded
31%
Last project
23 Jul 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies