Find Jobs
Hire Freelancers

spreadsheet conversion for new system

£250-750 GBP

Închis
Data postării: circa 5 ani în urmă

£250-750 GBP

Plata la predare
we are currently implementing a new computer system, and need to import our supplier spreadsheets into the format the system can load We get 8 different spreadsheets from 8 different suppliers every 6 months with details of their product list (description, price, size, colour etc). We need to upload the data from each into our stock management system via a pre-set template. This requires each supplier spreadsheet to be manipulated to extract the data in the right format. In particular, we need: 1. One tab showing each type of product (regardless of variations); and 2. One tab showing the variations available per attribute (colour, size, etc). Supplier spreadsheets can have anywhere between 500 and 7,000 products. The format of the supplier spreadsheets will not change, and our template will not change, so the solution needs to be capable of applying to each new supplier spreadsheet we receive.
ID-ul proiectului: 18825945

Despre proiect

24 propuneri
Proiect la distanță
Activ: 5 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
24 freelanceri plasează o ofertă medie de £380 GBP pentru proiect
Avatarul utilizatorului
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
£350 GBP în 4 zile
4,9 (329 recenzii)
7,9
7,9
Avatarul utilizatorului
Hi there, I can import your supplier spreadsheets into the format the system can load. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
£400 GBP în 10 zile
4,9 (379 recenzii)
7,8
7,8
Avatarul utilizatorului
Greetings! I understand your requirements. I can develop a configurable solution wherein the Supplier Template to your pre-set template can be mapped using a configuration table. With every new supplier addition, this mapping in Configuration table can be updated thereby providing the flexibility when it comes to supporting new suppliers over time. Being a full time freelancer working exclusively on Excel based projects, I work on developing such Excel based solutions every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
£250 GBP în 4 zile
5,0 (181 recenzii)
6,8
6,8
Avatarul utilizatorului
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. I can create a tool that allows you to process each one of the files (all at once, or the one you have selected) and get some files ready to be uploaded in the new system. Check my reviews, they speak for themselves. Best regards
£600 GBP în 10 zile
5,0 (225 recenzii)
6,9
6,9
Avatarul utilizatorului
Hello Sir Im excel VBA macro and formula Expert :) i can do make macro to convert your existing spreadsheet to spesific spreadsheet that have fix format so u can load this spreadsheet into your new system please ping me now and im free now to discuss more and if everything is clear im able to start working today Thank you Galih
£250 GBP în 3 zile
4,9 (360 recenzii)
7,1
7,1
Avatarul utilizatorului
Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi
£250 GBP în 10 zile
4,9 (118 recenzii)
6,3
6,3
Avatarul utilizatorului
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Excel, of course, familiar. Give me a chance to show what I can do!
£250 GBP în 3 zile
4,9 (89 recenzii)
6,0
6,0
Avatarul utilizatorului
Hello, I can build the functionality you want and automate it in excel as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work. Thanks!
£300 GBP în 3 zile
4,9 (29 recenzii)
6,0
6,0
Avatarul utilizatorului
Hello! Well, I think this would be better to handle with the database like Microsoft Access. For many reasons. If you like the idea and want to discuss details of how this can be achieved, let me know. Regards, Branislav Mihaljev
£555 GBP în 10 zile
5,0 (38 recenzii)
5,9
5,9
Avatarul utilizatorului
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully, I can write the macro to extract data into template as requested. You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, Would be great if you can provide a sample of your workbook for more context. Kindly get back to me if you wish to proceed, I am available to start your project immediately, looking forward to discuss further and work on your project.
£250 GBP în 10 zile
5,0 (75 recenzii)
5,6
5,6
Avatarul utilizatorului
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I am a full-time freelancer, I can start working on the project immediately. If you send me a sample of your template file and a supplier file, I'm ready to create a free draft pilot for you. Regards
£250 GBP în 2 zile
4,9 (62 recenzii)
5,7
5,7
Avatarul utilizatorului
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
£350 GBP în 3 zile
5,0 (31 recenzii)
5,4
5,4
Avatarul utilizatorului
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a Macro to automate the whole processes. Macro will extract data from supplier worksheets and put into specific template that you use to upload into your system. I have excellent knowledge and experience of manipulating data from multiple sheets through macro. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
£250 GBP în 10 zile
4,8 (80 recenzii)
5,5
5,5
Avatarul utilizatorului
Hello there I am available to convert the data from the different manufacturers and convert them into the same new data format required. I have expertise in Excel/VBA/Formulas, which I have used in past projects for data processing, analysis, and automation of tasks. I will provide you with a VBA based application, that you will be able to run with your various inputs and automatically convert the data into the required format. I look forward to your response. Moosa
£250 GBP în 5 zile
5,0 (40 recenzii)
5,0
5,0
Avatarul utilizatorului
hi there, I could develop a Windows .NET application to convert you Excel files. Any good? I have many similiar projects before and my apps can convert thousand of records per seconds Cheers
£250 GBP în 3 zile
5,0 (6 recenzii)
3,7
3,7
Avatarul utilizatorului
Hi, I am interested. I have considerable expertise in data management including MS Excel and MS Access. I would be happy to discuss about your requirement. Regards.
£250 GBP în 4 zile
5,0 (5 recenzii)
3,4
3,4
Avatarul utilizatorului
Hi; I'm an expert full stacj developer over 25+ years of coding knowledge. I parse Excel sheets almost on daily basis, export data to various DB's, and built interfaces around data with required business logic. I can handle the task. No upfront payments, you just pay once the project is completed to your satisfaction. I'll be available and happy to discuss the project in detail. Best regards, Baris Atasoy
£250 GBP în 10 zile
4,7 (3 recenzii)
3,6
3,6
Avatarul utilizatorului
Hey there, I have good exposure in building custom solutions in excel and accounts / financials automated reporting. After looking at your basic requirement, I can develop a automated solution to extract the information out from supplier sheets to your form (including bifurcation in tabs requirement) per supplier, given that your supplier data is in a fixed (semi-variable) pattern. PS: No of rows wont be a problem. I would love to work on your project and willing to negotiate on the price. Also, do note, I am very capable of providing a sound service..just looking for my first opportunity here on freelance work. Regards, Manpreet Juneja
£250 GBP în 10 zile
5,0 (1 recenzie)
2,0
2,0
Avatarul utilizatorului
I am confident I am the right candidate for this project as I have done many similar projects in the past. With years of experience in this field, I believe this project will be very easy for me.
£1.262 GBP în 5 zile
5,0 (5 recenzii)
1,7
1,7
Avatarul utilizatorului
Hi there, I understand you are implementing a new system, for which you want a process to be developed that can processes and consolidates all 8 different formats into a standard database to be uploaded in to Stock Management System. The process has to be dynamic so it accommodates varied entries in input. My name is Ajay, I have 11+ years of experience as a Business Analyst and a Project Manager. I have worked on multiple such projects in past and completed on time with good feedback. I am very good with Excel, VBA, Data Processing, Data Integration, Data Management, Processing Automation, etc. I have a few questions on Input/output format and details on variations. Let me know if you wish to continue with me. With me you will get 1. Hassle free experience 2. Timely project update 3. SOP for the process 4. QC Process and Best quality Thanks Ajay
£250 GBP în 10 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED KINGDOM
Banbridge, United Kingdom
0,0
0
Membru din feb. 27, 2019

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.