Find Jobs
Hire Freelancers

Database editing

£20-250 GBP

Completed
Posted over 8 years ago

£20-250 GBP

Paid on delivery
HELLO We are editing our database and we need your help to edit and delete some cells. Below is a detailed explanation. We have also made a video to make it even more clear on what to do. It might seem a bit confusing at first but it’s actually very easy once you see the video and done it a couple of times. WHAT WE ARE TRYING TO ACHIEVE The Excel spreadsheet has a list of products, but many products have a rule that needs to be edited for importing into our database program. FILE You will be editing an existing database Excel spreadsheet with 6454 rows. It is added to this project. STEP-BY-STEP INSTRUCTIONS 1) Identify the product which has rules. A product has a full number in cell B (e.g. 101, 1015, 1018). If it has a rule then the next product underneath will have the same number, but followed by another number after a hyphen (e.g. 1018-001, 1018-002, 1018-003 - a product has 3 rules) 2) After the rules rows for a product are identified, change cell A text from ‘Product’ to ‘Rule’. 3) Delete rule cells C - J, but not the product. 4) Cell K. Make sure that the number in the ‘Product’ row is the same as the number in first variant. e.g. If 1018 product number in cell K is 0, but the 1018-001 cell K number is 202, then change the product number in cell K to 202. 5) Cell K. Add [FIXED] in front of the ‘Rule’ rows number. e.g. Cell K is 202, change it to [FIXED]202 6) Delete ‘Rule’ cells L - U. 7) Delete ‘Rule’ cells Y - AX. 8) Delete cell BL. 9) Identify the next product with rules and repeat steps 2 - 9. Leave and don't touch the product rows as they are if they have no rules to them. VIDEO LINK VIMEO: [login to view URL] HD DOWNLOAD: [login to view URL]
Project ID: 8391901

About the project

49 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, Actually, I have processed all the 6454 rows using Excel formulas and functions as per the instructions with 100% accuracy. Please open a PMB so I can send you the file for your review. Regards Ravi
£25 GBP in 1 day
5.0 (211 reviews)
6.6
6.6
49 freelancers are bidding on average £135 GBP for this job
User Avatar
currently i am bidding without watching the video, but i would like to go through all details with you once you will pm, i can assure you will understand the task, and will deliver it, thanks
£263 GBP in 6 days
5.0 (1615 reviews)
9.3
9.3
User Avatar
A proposal has not yet been provided
£200 GBP in 2 days
4.9 (441 reviews)
8.6
8.6
User Avatar
Dear Sir/Ma'am, Price and duration will vary depending on actual project. I am a Web research and Data Entry expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
£150 GBP in 3 days
4.9 (456 reviews)
8.1
8.1
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
£200 GBP in 5 days
4.8 (364 reviews)
7.4
7.4
User Avatar
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here (https://www.freelancer.com/u/safiqulislam67.html). Best regards, Safiqul Islam
£150 GBP in 3 days
5.0 (242 reviews)
7.2
7.2
User Avatar
A proposal has not yet been provided
£50 GBP in 3 days
4.9 (510 reviews)
7.4
7.4
User Avatar
Hi, Thanks for the opportunity to bid on this project. I have done such data gathering and research in the past for various clients so that I will provide good service. Regards, Jai
£77 GBP in 7 days
4.9 (347 reviews)
7.0
7.0
User Avatar
Hello sir, After reading Your project description and steps along with Attached excel sheets are very clear. Only step 2 which is " After the rules rows for a product are identified, change cell A text from ‘Product’ to ‘Rule’." not clear to me. Rest is absolutely clear. It seems that it is CSV for website having all the details of products. We would love to discuss further . Thanks Swati
£66 GBP in 2 days
4.8 (97 reviews)
6.8
6.8
User Avatar
Hello Sir, I have 8 years experience of Quality Controller & Team Leader in an outsourcing company. During this period I have worked on many projects. My experience and knowledge will definately help you to complete your project. Please allow me to work with you. I will deliver great quality work. Thanks, Sandip
£100 GBP in 2 days
5.0 (87 reviews)
6.0
6.0
User Avatar
Hi, I’ve gone through your requirement; I am very much interested to work with you on this project. I do have expertise in the specified area. I can start the project right away and can complete as soon as possible. Please respond me so that we can discuss it in-detail. Look forward for your response and seeking a chance to work with you. Thanks Mahi
£150 GBP in 3 days
4.8 (34 reviews)
5.7
5.7
User Avatar
I am experienced with manipulating excel files, I can make automation using VBA or macros. Also I can double the working time if deadline is aggressive.
£150 GBP in 3 days
5.0 (9 reviews)
5.6
5.6
User Avatar
Hello We are running a small Company with our expert operators. We are providing cost effective and quality service to our clients since April 2015. We believe in quality work that meet the clients Expectations and satisfied the clients. Please have a look at the Feedback/Rating that we have got, which proves we are the best candidates for your project. We would like to work on this project, as we have understand your project requirement very well, we can do it easily as your Expectations. Let me know if you are interested so that we can discuss in more detail. Thanks Meena
£20 GBP in 0 day
4.7 (57 reviews)
5.7
5.7
User Avatar
Hi :) I"m very much interested in your project and I think you'll find I have the skills you are looking for. I promise you to provide BEST quality output within the deadline, exceeding your expectations. I'm ready to start work right now and waiting for your reply. Thank you!
£50 GBP in 2 days
4.9 (64 reviews)
5.3
5.3
User Avatar
Hello I am ready for the task. I have gone through the project description. I can complete the project perfectly on time. Pls contact with me. Thanks
£210 GBP in 7 days
4.9 (40 reviews)
5.0
5.0
User Avatar
Hello, I am a software and database developer. I did lots of programs for data import/export and other sorts of data manipulation. I am familiar with C#.Net, MSSQL, MySQL, Excel. Cheers. Ionut
£150 GBP in 3 days
5.0 (9 reviews)
4.3
4.3
User Avatar
Hi. I am sure I can do this. Regards.....................................................................................................
£100 GBP in 3 days
4.8 (11 reviews)
4.1
4.1
User Avatar
Will be delivered asap sir Will be delivered asap sir Will be delivered asap sir Will be delivered asap sir Will be delivered asap sir
£32 GBP in 0 day
4.9 (10 reviews)
4.3
4.3
User Avatar
Hello I am pleased to place bid on this project. I found myself feasible for this job. I will do this for you. I'll do this very fast. Hope to see your message. Thank You.
£23 GBP in 0 day
5.0 (1 review)
2.5
2.5
User Avatar
Hello Sir/Maam, I have seen your demo video and understood the work. I will do this task carefully and will send you complete work report. Looking forward to your reply. Thank You, Amit Tukrul
£100 GBP in 3 days
5.0 (4 reviews)
2.7
2.7
User Avatar
I am really interested in working for you. I have a lot of free time and I can work all day long on this project to finish it on time. I am a perfectionist and I pay special attention to detail because I know how important is this work for you. I graduated from the Faculty of Letters, I have a good understanding of the English language and that's why I consider myself prepared for your assignment. If you want your job to be done fast and flawlessly, please contact me.
£95 GBP in 5 days
5.0 (3 reviews)
2.1
2.1

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
16
Payment method verified
Member since May 5, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.