Find Jobs
Hire Freelancers

EXCEL SOLUTION

$10-30 USD

In Progress
Posted 5 months ago

$10-30 USD

Paid on delivery
Project Title: EXCEL SOLUTION I need some help to create new price data according to additonal costs. Please review attached spreadsheet. Any solution (macro, formula, power query) is welcome. My base data is Table1 which shows units base prices. For example, the "DG-4X" price is 900 if it comes from Italy to Paris But, there is an additonal cost according to the POR city (Table2). For example, the "DG-4X" price will be 2040 if POR city is Milan Same way; the "DG-4X" price will be 1425 if POR city is Rome. Or "R-2X" price will be 1925 if it comes from Milan to Paris. I need macro or formula or any solution in order to create new table which sums prices for each model based on POR city. Final table should be like below and combinations (Por City, Destination City, Model Match) should be recognized
Project ID: 37473924

About the project

29 proposals
Remote project
Active 5 mos 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
Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the work. Will wait for your kind response ☺️ Thank You. Regards, UMAIR
$10 USD in 1 day
5.0 (51 reviews)
4.3
4.3
29 freelancers are bidding on average $22 USD for this job
User Avatar
Hi, i looked at the attach table and yes this is definitely possible, but i have to suggest one small change so this can be done properly and without mistakes. If you are interested, feel free to message me and i will try to help immediately. I am available right now. Thanks, Milan
$25 USD in 1 day
5.0 (797 reviews)
7.6
7.6
User Avatar
Hi There, I am reaching out to express my interest in your project (EXCEL SOLUTION) and would like to offer a 25% discount on all services. You need some help to create new price data according to additonal costs. I have extensive experience for over 5 years as a Web Scraper, Data Entry and Organization, Data Cleaning, and Validation Techniques. I believe I am the perfect fit for this project because of my skills in data entry and organization as well as data cleaning and validation techniques. Additionally, I have the attention to detail and accuracy needed to process the large volume of data involved in this project efficiently and meet deadlines. If you would like to discuss the project requirements in detail, please feel free to reach out to me at your convenience. I look forward to the opportunity to work with you and ensure the success of your project. Best regards, Sohail Jamil
$10 USD in 1 day
5.0 (30 reviews)
5.2
5.2
User Avatar
Hi there, I know how to do this. I am a VBA Macro Developer for 10 years now and PMO Analyst working with financial reporting and analysis at a company in Accenture. I understand you need help creating new price data according to additional costs, including macros, formulas and power queries. With my experience in Excel and Project, I am confident that I can provide the solution needed to create the required table. Specifically, I have strong knowledge in sharingpoint site maintenance and customization using Infopath, Powerapps and sharepoint designer which will be useful in this project. Additionally I have knowledge of photo editing using Adobe Photoshop which will be useful in creating the required table. I would be delighted if you could let me know if this project is something you are looking for? My communication skills as well as my expertise in data entry, data processing and Excel make me the perfect fit for this project. Please feel free to reach out if any other questions or concerns come up regarding my profile or the project description.
$20 USD in 1 day
4.8 (83 reviews)
5.6
5.6
User Avatar
Hello, I am an experienced Excel expert eager to assist you with your EXCEL SOLUTION project. I have carefully reviewed the attached spreadsheet and am confident in my ability to create a dynamic solution using macros, formulas, or Power Query. I will efficiently analyze the base data in Table1 and incorporate additional costs based on the POR city from Table2, providing you with a comprehensive table that sums prices for each model according to the POR city. My expertise in Excel and data manipulation ensures a precise and effective solution to meet your specific requirements. I look forward to delivering a seamless and automated Excel solution tailored to your needs. Best regards, Zafar
$30 USD in 7 days
4.9 (50 reviews)
5.0
5.0
User Avatar
Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). Successfully delivered Dashboard, Scorecard, Heatmap & Ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can give you support to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics EXCEL | VBA | POWER BI | SQL | OCR |
$30 USD in 1 day
5.0 (27 reviews)
4.8
4.8
User Avatar
Hello, my name is Basanta Kumar and I am a data entry expert with over 12+ years of experience in MNCs. I have worked on different projects related to Excel, VBA/Macro, Ms Access, Workflow Management, Power BI, Power Query, MySQL and option strategies of the stock market. I understand you need help creating new price data according to additional costs so I would be the best fit for this job. With my expertise in data entry and processing as well as Excel knowledge advanced formula and macros I can provide the solution you are looking for. I believe I am the right person for this project and look forward to discussing further how I can help you reach your goals for this project. Please let me know if you have any questions or would like further information on my skillset so we can get started on this exciting project!
$20 USD in 1 day
4.9 (64 reviews)
4.3
4.3
User Avatar
Hello! Greetings from Wilfred! After thoroughly reading the job description of your EXCEL SOLUTION project, I am thrilled to express my strong interest in being a part of it. With my years of experience working as a freelancer, I have honed my skills in Excel, Visual Basic, Data Processing, Visual Basic for Apps and Data Entry which you indicated are essential for this project. My goal is not just to complete the project, but to truly make a positive impact and exceed expectations. I am excited about the potential of this project and welcome the opportunity to contribute my expertise to its success. I am eager to learn more and discuss how I can contribute to its success. Thanks Soner Onur I. for your time. Let's work together to bring your vision to life.
$25 USD in 1 day
5.0 (2 reviews)
2.9
2.9
User Avatar
I understand that you are looking for someone to create new price data according to additional costs. This project requires macro, formula or any solution to create new table that sums prices for each model based on POR city. As a Data/Business Analyst and Digital Marketer with extensive expertise in Excel, I am confident that I can provide the best solution for this project. My background in data processing and experience with advanced Excel techniques make me an ideal candidate for this job. I would be delighted to discuss further how my skillset can benefit your project. Please let me know if you have any questions or would like me to provide more information about my services.
$20 USD in 7 days
5.0 (5 reviews)
2.6
2.6
User Avatar
Greetings, I have more than 10 years of experience in professional consultancy regarding Microsoft Excel and Power Bi. I am an expert in formulating scenarios, logic, and criteria outputs based on user requirements. I am also proficient in enabling automation through Macros and user forms to speed up the notch. I can cater to all your Ms Excel needs in a jiffy. My motto is “Whatever you think to do, I can formulate it.” I can better able to manage your task and assure you to deliver quality work. Please inbox me for more details and discussions. Looking forward to working with you. Regards,
$30 USD in 2 days
5.0 (4 reviews)
2.3
2.3
User Avatar
Hello again! My name is Asad and I am a dedicated data maestro with over a decade of experience in the field of data analysis. You need my help to create new price data according to additional costs. I understand how frustrating it can be when information isn't readily available or accurate enough to use. With my expertise in Excel, I am confident that I can provide the solution needed to create new price data according to additional costs. I am available 24/7 via Freelancer Messenger so we can discuss further how we can work together to solve this project together. Please feel free to reach out if you have any questions or would like me to provide additional information about my skillset or availability during the project timeframe. Best regards, Asad
$20 USD in 1 day
5.0 (2 reviews)
1.7
1.7
User Avatar
yes i am interested in doing this work project with in time limit with 100 percent accuracy and 100 percent productivity
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I am Shayan, a professional with strong background in web development and specifically in flutter for cross-platform app development. I understand you need help creating new price data according to additional costs so that you can create new tables that sum prices for each model based on the destination city's POR. I believe I am the best fit for this project due to my extensive experience in data entry, visual basic and excel solutions. My experience has taught me how to efficiently work with large amounts of data while ensuring accuracy and timely delivery of results. This would be especially important for this project as you need new tables created according to additional costs so that you can create new tables that sum prices for each model based on the destination city's POR. I would be delighted if you could join me in helping bring your vision for increased customer insight to life!
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I understand that you are looking for someone to create new price data according to additional costs. Specifically, you need help creating a new table that sums prices for each model based on the destination city. I have extensive experience in data entry, specifically Excel, and can confidentially provide the solution needed for this project. My skillset includes macros, formulas and other solutions necessary for creating new price data according to additional costs. Moreover, I have a proven track record of delivering high volume website development as well as other digital marketing services. This makes me the perfect fit for this project as I can deliver results quickly without compromising on quality. Shoot me a message; I'd love to work with you & discuss the project in detail. Cheers, Fahad Ahmed.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can help you with this excel solution project and can provide efficient work. Lets chat to discuss more. Regards!
$20 USD in 1 day
3.6 (1 review)
0.0
0.0
User Avatar
Hello, I'm eager to contribute to your project. I am available to commence work immediately and am confident in delivering a flawless result. If you could provide further details or initiate contact at your earliest convenience, I would be delighted to begin the work. Thank you, and I look forward to the opportunity to collaborate. Best regards, Ahtisham
$15 USD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
I can complete your project as quick as within your precious time.i can do these works any query , you can contacct to my profile.
$11 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience to create a budget and to create a timeline and I know to make a table and do calculations with it and I can do data calculations such as sums, averages, percentages with functions, criterias and tables and I love making elements such as charts and tables presentable with pictures, themes and styles.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I hope this message finds you well. I've reviewed the attached spreadsheet and understand the task at hand. I'm confident in my ability to help you create a solution that aligns with your requirements. I propose using a combination of Excel formulas and Power Query to create a new table that incorporates the additional costs based on the POR city. This solution will automatically sum the prices for each model, considering the POR city, destination city, and model match. Approach: Utilize Power Query to merge the base data (Table1) with the additional cost data (Table2) based on the POR city. Create a new column that calculates the total price by adding the base price and additional cost. Summarize the data to identify unique combinations of POR city, destination city, and model. Present the final table with the accurate pricing for each combination. Benefits: Automation: The solution will be automated, saving time and reducing the chance of errors. Flexibility: Easily adaptable for future updates or changes in the data. User-Friendly: You won't need to delve into complex coding; the solution will be user-friendly and easily understandable. I have experience in similar projects and can ensure a quick and efficient turnaround. Feel free to reach out if you have any questions or if you'd like to discuss this further. Looking forward to the opportunity to assist you. Best regards, Asma Khalid
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a software professional who has worked as a Data Analyst most of my career. As a Data Analyst I have immense experience in dealing with Excel because all our test cases used to be drafted first using excel sheets. I have experience in handling Excel with large amount of data too. I am confident that I can complete your task promptly well before the deadline. Skills i have data visualisation, MySQL , Excel Thanks
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I surely will do it completely as per your requiremnet.. As this will take a little bit time to arrange a excel sheet as per your requirement but i can do it precisely with in a 5 days
$80 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of TURKEY
Izmir, Turkey
5.0
2
Payment method verified
Member since Oct 3, 2019

Client Verification

Other jobs from this client

Data Analysis - Case Study
$10-11 USD
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.