Excel Brief Price Analysis

Job Description:

Compare two different excel files to know the price differences.

File 1 is Master data (2000 rows)

File 2 is price from plant A (800 rows)

File 1 Column A is item number, column B is standard cost.

File 2 Column A is part number, column B is unit cost.

Note: Item number is different in two sheets. Need to clean and process the common data.

Simply Compare the standard price or cost with the corresponding parts and provide a short analysis (bar chart or pivot table or pie chart as per your choice).

Keep the data in changable format so that if price changes the analysis should automatically change.

Please provide a draft copy of the work before submitting the final work.

Prefer early members who can deliver the work within next 12 hours.

Please feel free to ask any question.

Taidot: Excel, Excel VBA, Tietojenkäsittely

Tietoa asiakkaasta:
( 1 arvostelu ) Kolkata, India

Projektin tunnus: #33326990

Myönnetty käyttäjälle:


i can do that within 1 hour let us discuss some more about this project let me know when you are available best of luck

₹700 INR 1 päivässä
(14 Arvostelua)

5 freelanceria on tarjonnut keskimäärin ₹930 tähän työhön


Hi i am excel expert i know v look up,pivot and all formulas so easy to work & complete your project so give me a project will do success fully

₹650 INR 7 päivässä
(0 arvostelua)

I have 1 year experience in data analytics using python,R, Excel and Tableau tool. So i can finish this project easily.

₹650 INR 2 päivässä
(0 arvostelua)

Hi, I'm a Kenyan Trained Civil Engineer. My area of Speciality is Roadway and Building Structural Design. I'm Conversant in the following Software; Excel, Civil 3D and Revit. I'm well knowledgeable in Kenyan and ; Bri Lisää

₹650 INR 1 päivässä
(0 arvostelua)