Compare two identical spreadsheets -> best sellers

$10-80 USD

Completed

Posted

over 6 years ago

$10-80 USD

Paid on delivery

Hello Each day I get an update product & quantity spreadsheet. Here quantity change on a daily basis. (also new products are sometimes added) I need you to create a solution where I can see which products sell the best. Example: Day 1: Product A - QTY 100, Product B - QTY 50 Day 2: Product A - QTY 90, Product B - QTY 50 Day 3: Product A - QTY 85, Product B - QTY 30 At any given point I would like to know how many units was sold. Example: "From day 1 to day 3": Product A sold 15, Product B sold 20 "From day 2 to day 3": Product A sold 5, Product B sold 20 The files are currently delivered in .CSV format. A file can contain up to 30.000 products. I run on Windows (Do not have linux). And need a program, script or similar where files or input easily can be compared. Note: Sometimes quantity also increase when stock is filled up again. So if this information also can be taken into account it would be great (the program will report to me when a re-stock is made). Contact me if any questions. If your from Indian then please dont bid on this project. Feedback needed.

Software Architecture

Project ID: 15472559

About the project

31 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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:

@someka

Hello. I can prepare you an Excel template in which you can put your raw data and analysis will be made automatically with Pivot Tables. You dont need to deal with formulas. Relevant Skills and Experience Once we setup the template and relations, your best selling products and comparisons will be updated as long as you keep adding new data. Proposed Milestones $120 USD - Will be paid when job is done and customer is 100% satisfied I'm available. Contact me if you wanna discuss further. Thanks!

$120 USD in 5 days

5.0

(148 reviews)

7.3

31 freelancers are bidding on average $59 USD for this job

@SBITServices

Hello , I have read your project description and understood your requirement. I have experience in this type of work and can complete the task with in time and with 100% accuracy. Relevant Skills and Experience Skills : Excel, Macros,VB.net, Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $30 USD - Project

$30 USD in 1 day

4.9

(485 reviews)

7.8

@priyal1997

Hi There, Its my pleasure to help you on this cost/qty modeling task. I can develop a suitable solution to match with your requirements mentioned in the project description. Relevant Skills and Experience CPA and Excel expert with more than 10 years of experiance Proposed Milestones $80 USD - Cost Please send me the current CSV file to have a quick look and provide you with a feedback Thanks Priyal

$80 USD in 2 days

5.0

(200 reviews)

6.7

@suyashdhoot

Hi I am a very experienced statistician and data analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. Relevant Skills and Experience I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour Proposed Milestones $150 USD - a and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA, TABLEAU and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash

$150 USD in 10 days

4.6

(103 reviews)

7.0

@shihan033010

Hi I am interested in your project. I can compete the functionality that you need using php script. I am ready to start the project. Regards SHIHAN

$70 USD in 2 days

4.8

(196 reviews)

6.2

@DanD

Hello, I can complete this within a few hours using python pandas on windows as requested. Please note that i have already done something very similar in the past. I hope to read from you soon, Best regards, Dan

$55 USD in 2 days

4.9

(204 reviews)

5.7

@cababay

Hello, i am a solutions architect. I am expert on Python. I usually develop data processing and big data projects. I will develop this project with python. You can execute it on windows. Thanks. İlgili Beceriler ve Deneyim python Önerilen Aşamalar $50 USD - project fee (on deliver)

$50 USD in 3 days

4.9

(41 reviews)

5.9

@imanomidvar

i can create a vb.net windows application for you that you can easily input your spreadsheet file and my program will create a local sqlite Database to save all the records and will report best seller Relevant Skills and Experience i'm expert on creating databases and writing sql queries to fetch the desired results. i have provided quality solutions for various businesses such as hotels bookings and Restaurants POS systems. Proposed Milestones $50 USD - VB.net app that will report best seller products and notifies in case of re-stocking. please let me know if there are any questions regarding my solution.

$50 USD in 10 days

5.0

(9 reviews)

5.2

@cheungkc

I am proposing an Excel VBA solution with 30,000+ product down in column A and Dates across in row 1 please Relevant Skills and Experience 15 years Excel VBA data processing practice Proposed Milestones $88 USD - Completion of work Excel across has 16,000+ columns, so products which are more than 30,000 must be listed vertically down. I assume the product descriptions between the 2 CSV files are consistent so at import of both files, quantities of each product can be matched. Products in file 2 not found in file 1 are new items. Quantities in file 2 bigger than in file 1 indicate restock. To loop through 30,000+ items, we need to avoid working directly off the worksheet. Use of arrays is essential for speed.

$88 USD in 10 days

5.0

(6 reviews)

3.1

@HasnaHaris

Hi. I noticed your project and would like to discuss further details in the chat Relevant Skills and Experience Big Data, Big Data, Data Analytics, Data Processing, Excel, Proposed Milestones $5 USD - Data Analytics $35 USD - data entry

$40 USD in 1 day

5.0

(3 reviews)

1.6

@whiteash75

Highly organized, flexible and reliable. Handles stress and works around the clock Relevant Skills and Experience Effectively meets data processing goals and production standards. Proficient in MS Word, Excel and software database Proposed Milestones $50 USD - can complete the work before deadlines

$50 USD in 10 days

0.0

(0 reviews)

0.0

@KimzeyMarie

I believe I can do the tasks. Accuracy and efficiency is my utmost priority in doing any project. Relevant Skills and Experience Data Analytics, Microsoft Excel, Data Processing Proposed Milestones $40 USD - Upon Completion of Task I will use the Pivot Function of the Microsoft Excel for this task.

$40 USD in 5 days

0.0

(0 reviews)

0.0

@Lalit678

Give me a chance to help you out in this project and i promise that I won't let you down. Relevant Skills and Experience I've done this type of work for MNC for 3 years in india

$50 USD in 10 days

0.0

(0 reviews)

0.0

@ChaituDeepu3

A proposal has not yet been provided

$55 USD in 10 days

0.0

(0 reviews)

0.0

@diyana7

A proposal has not yet been provided

$50 USD in 5 days

0.0

(0 reviews)

0.0

@cjayants84

A proposal has not yet been provided

$61 USD in 3 days

0.0

(0 reviews)

0.0

@Adrian0348

Hello, I think I can help you with your issue. Contact me if you wish to work with me. Greetings Relevant Skills and Experience java, python, c# Stay tuned, I'm still working on this proposal.

$111 USD in 15 days

0.0

(0 reviews)

0.0

@maghanem97

I can use Excel to make you a chart that represent the products quantities sold per day as bar chart or line chart which will be connected to the source , any required calculated column can be added. Relevant Skills and Experience I am working as a data analyst using excel, power bi and power query, also as business analyst, I created so many dashboards by the previously mentioned tools Proposed Milestones $10 USD - Data analysis and organization $20 USD - Data transformation (Formats, blank values, data types....etc) $15 USD - Visual chart creation and connection to data source $21 USD - Data validation Additional Services Offered $10 USD - Data analysis & business analysis for your business environment $7 USD - process automation analysis for business processes If you have a long process with many waiting time and bottlenecks i can create you a chart that can visually help you track the pending time and who is responsible for the waiting time

$66 USD in 2 days

0.0

(0 reviews)

0.0

@ErzhanAmreev

Please consider my offer for this project. Соответствующие навыки и опыт You can find examples of my work in my profile. Предлагаемые промежуточные платежи $15 USD - I will wait for an answer and more details on task.

$15 USD in 2 days

0.0

(0 reviews)

0.0

@rohitjmcprojects

Will be completed in 2 days only with 100 % requirements Relevant Skills and Experience Excel Expert Proposed Milestones $12 USD - Vlookup and logical formulas

$12 USD in 2 days

0.0

(0 reviews)

0.0

@magyessam

Because I am passionate about accounting, sales and Excel. Relevant Skills and Experience I am an Excel and Visual Basic Expert with over 5 years of experience Proposed Milestones $25 USD - start $25 USD - End

$50 USD in 7 days