Need a pricing tool developed that can search spreadsheets
$250-750 USD
Completato
Pubblicato più di 5 anni fa
$250-750 USD
Pagato al completamento
We are looking to streamline our pricing process by having a tool that we can upload spreadsheets to. These spreadsheets will contain several columns of information. What we are looking for the pricing tool to do is when we upload a new spreadsheet with the same column names, the tool will search for the most similar items we have previously uploaded and provide a base price. If you are awarded this project, we will send you around 20 spreadsheets of data that need to be uploaded for pricing. The tool must also be able to be updated with new spreadsheets with additional pricing. The sheets which need pricing pulled will be around 100 items per sheet. The tool will be able to match prices for each line item with one button press. These are mostly computer products so the fields will be Part Number, CPU, RAM, Storage, Graphics, Display, etc.
Hi, I've got quite some experience with C#, Google Sheets API, and databases in general so I'm sure I can help you out here.
May we discuss this further over the chat?
$500 USD in 3 giorni
5,0 (6 valutazioni)
4,1
4,1
18 freelance hanno fatto un'offerta media di $505 USD
Hello!
My name is Paris, and I was glad to see that you're looking for an Excel developer that will develop a tool to compare prices for similar items coming from different Excel spreadsheets. I am going to write the required VBA code that will bring all these spreadsheets in and will examine the items' prices. What I plan is to have all the source spreadsheets inside the same folder and let the code scan all of them in sequence.
I will charge you $450 for this task, and I will deliver in less than four or five days (a single milestone to release once you're happy with the final version).
I'm among the most experienced and skilled Excel and VBA developers on this platform. I've got completed more than 260 projects successfully, and I feel confident to deliver your project quickly and effectively!
You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I deliver to my clients.
I'm available from 8 am to 9 pm, Athens time. When does it work for you?
I'm looking forward to hearing from you.
Sincerely,
Paris Pallas
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months.
My bid is for the Excel VBA based solution.
Willing to take up your project. Thank you, Regards.
I have already created similar tools..
1- I will provide you with an executable to browse excel files.
a) button to start comparison..If item is already there we will pick the existing information (please provide some details about the base price stuff)
b)20 sheets will have same columns or different columns ?
c)All comparison will be done as per the details criteria (needs a discussion)
Looking forward to have a chat with you to discuss further.
Hi,
I have read very carefully your project details about building a pricing program or tool and uploading Excel spreadsheets to the pricing tool that will need to pull pricing data from the spreadsheet. I am absolutely sure that I can complete this project professionally.
I have vast experience working on similar projects and I am confident I can exceed your expectations. I am passionate about flawless results and I can assure you of a job well done. Please let my reviews do the talking.
Do you want me to start working on the sample right away?
Hi,
I am an expert in excel, access, VBA and power bi. I can create a database from all your worksheets and pricing tool.
I am ready to start your project immediately, please let me know more about the project details in chat.
Thanks
Hi,
I can create the pricing excel tool to upload new sheets with prices, compare prices with one click on a button.
If you will give me the opportunity to work on your project I am sure you will be satisfied by the quality of my work.
Best regards,
Florin Enache
Sir,
I am well versed in these kind of jobs and can do your project as per requirement..
**I am ready to start
Waiting to hear from you.
with thanks and regards
Relevant Skills and Experience
Excel, php
Hello! I would love to help you in this project. I already have this kind of program to get this results for you in VBA (excel sheets) or Python codes. Give me a chance to show you and I can deliver a working code in a couple of days.
We have developed literally tens of hundreds of Excel imports for purposes as varied as contact updates, to financial transaction entry and item price updates. In addition to the stated requirement, we would include options for search and download of historical prices based on import date, item, category other parameters, identifying import sourcesource
Hello Sir/Madam,
Greetings, I have read your description. Why are you not trying Search button on your excel Sheet. It is very easy to search any things just one click. If you want I can send you a sample.
Thanks & Regards,
San58
Hello,
I can develop this pricing tool as a Windows application. As you explained, you will be able to load any number of spreadsheets which contain items to be priced based on previously saved spreadsheets.
However, I think the best way to understand the details of this project is to walk through a few use cases (examples).
If you like, we can chat to see if I can help.
Thanks
Hello sir,
I am a Visual Basic developer and i have been developing my applications in real environments.
I have done this task of connecting multiple worksheets from multiple workbooks and shift data from one to another...
You can rest assure about your work. It will be done as you demand.