Compare two identical spreadsheets -> best sellers

$10-80 USD

已完成

已发布

超过 6 年前

$10-80 USD

货到付款

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

项目 ID: 15472559

关于此项目

31提案

远程项目

活跃7 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 在5天之内

5.0

(148条评论)

7.3

31威客以平均价$59 USD来参与此工作竞价

@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 在1天之内

4.9

(485条评论)

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 在2天之内

5.0

(200条评论)

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 在10天之内

4.6

(103条评论)

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 在2天之内

4.8

(196条评论)

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 在2天之内

4.9

(204条评论)

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 在3天之内

4.9

(41条评论)

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 在10天之内

5.0

(9条评论)

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 在10天之内

5.0

(6条评论)

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 在1天之内

5.0

(3条评论)

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 在10天之内

0.0

(0条评论)

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 在5天之内

0.0

(0条评论)

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 在10天之内

0.0

(0条评论)

0.0

@ChaituDeepu3

A proposal has not yet been provided

$55 USD 在10天之内

0.0

(0条评论)

0.0

@diyana7

A proposal has not yet been provided

$50 USD 在5天之内

0.0

(0条评论)

0.0

@cjayants84

A proposal has not yet been provided

$61 USD 在3天之内

0.0

(0条评论)

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 在15天之内

0.0

(0条评论)

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 在2天之内

0.0

(0条评论)

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 在2天之内

0.0

(0条评论)

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 在2天之内

0.0

(0条评论)

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 在7天之内