Find Jobs
Hire Freelancers

Need to create a daily and weekly sale in a microsoft excel file

$30-250 USD

Closed
Posted over 8 years ago

$30-250 USD

Paid on delivery
Hi, Our daily and weekly sales report will show uniquie SKUs, Quantity on hand and Quantity sold. We want to be able to take these numbers and plug it into a spreadsheet template to generate information about sales for specific SKUs. We need someone to create a daily and weekly spreadsheet template with Mircosoft Excel that can show the following information once SKU, Quantity on Hold, and Quantity sold is plugged into the template: Top 20 Daily SKUs TOP 20 SKUs that sold the most Top 20 Daily % Gainers TOP 20 SKUs that has the biggest % increase in sale (Only look at SKU that sold more than 10 QTY) Top 20 Daily % Losers TOP 20 SKUs that has the biggest % decrease in sale (Only look at SKU that sold more than 10 QTY) Low Stock Inventory Items that are running out of stock (Find velocity, Total QTY / Sales today, list items that will sell out within 21 days ) Top 20 Weekly SKUs TOP 20 SKUs that sold the most Top 20 Weekly % GainerTOP 20 SKUs that has the biggest % increase in sale (Only look at SKU that sold more than 10 QTY) Top 20 Weekly % Losers TOP 20 SKUs that has the biggest % decrease in sale (Only look at SKU that sold more than 10 QTY) Low Stock Inventory Items that are running out of stock (Find velocity, Total QTY / Sales this week, list items that will sell out within 21 days )
Project ID: 8710747

About the project

41 proposals
Remote project
Active 8 yrs 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
41 freelancers are bidding on average $110 USD for this job
User Avatar
Hello, We highly recommend our team for your work. We have completed 900+ projects on freelancer alone, We have vast experience in data entry projects like data mining, data research, typing work, magneto data entry, and product add. We are capable to provide excellent work with sharp accuracy and on time delivery. We will be in touch with you throughout project. We will provide reports in your specified format. Please consider us for this project. Looking forward to hear from you. Best regards, Deepansh Pandeypriya E Solutions
$34 USD in 3 days
4.9 (581 reviews)
7.7
7.7
User Avatar
A proposal has not yet been provided
$100 USD in 1 day
4.9 (257 reviews)
7.7
7.7
User Avatar
I am mostly online. Just drop me a message so that we can discuss further about pricing and job details.
$105 USD in 3 days
5.0 (149 reviews)
7.3
7.3
User Avatar
I'm a computer science professional with extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$45 USD in 3 days
4.8 (203 reviews)
7.3
7.3
User Avatar
Hello, I am Excel and VBA expert. I can do this project If you have any questions I will be happy to answer. Best regards Jan Krzyzak
$50 USD in 3 days
5.0 (94 reviews)
6.1
6.1
User Avatar
hey there...please share your weekly and daily sale reports...we can design a small app to generate the excel sheet that has all the information in the required format...please reply...we can discuss and hopefully get it started...thank you...
$49 USD in 2 days
4.8 (166 reviews)
6.0
6.0
User Avatar
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. If you send me a sample input file, I'm ready to create a free draft pilot for you. Regards
$50 USD in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi, Approach: I worked on similar project like preparing costing module for a chef, pest control company etc. Please have a look at projects for reference: Pest control costing sheet: https://www.freelancer.com/jobs/Excel/Excel-spread-sheet-for-costing/?hash=fBUiG%2BuHaA%2FCabS%2BWT%2Fn6iYpb7mzF9RygmyxDZ3QJF4%3D Recipe costing sheet: https://www.freelancer.com/jobs/Excel/Excel-spreadsheet-created-for-menu/ I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on designing, implementing and analyzing ACBC (conjoint) surveys, pricing models, income statements, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$155 USD in 3 days
4.9 (39 reviews)
5.6
5.6
User Avatar
As-salamu alaykum, I will use the data at the worksheet and my macro will create worksheets with the information you listed. It would take about two hours of my time, and we may further need to discuss. But here is my offer. Best Regards,
$60 USD in 3 days
5.0 (25 reviews)
4.7
4.7
User Avatar
I have professional experience in building various reports in excel. I assure you to deliver quality work in less time. Thanks!
$120 USD in 3 days
4.7 (9 reviews)
4.1
4.1
User Avatar
La propuesta todavía no ha sido proveída
$50 USD in 7 days
5.0 (10 reviews)
4.0
4.0
User Avatar
Hi, I've been creating different types of dashboards in excel which uses vba/macro. I think if you can send a sample data and if we can discuss more, we can come up at an easy to use excel template. I can also send previous work so you can see how I work. Thanks
$55 USD in 1 day
5.0 (9 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
5.0 (3 reviews)
2.5
2.5
User Avatar
Hi, i can support you in excel data processing with VBA i have experience on it, to check my profile and professionalism you check my profile feel free to contact me, Eko Pambudi
$155 USD in 3 days
5.0 (4 reviews)
2.2
2.2
User Avatar
I have am an experienced Supply Chain Professional having ease of working on MS Office applications with excellent level of accuracy. This work can be completed in the desired fashion and within the scheduled time period.
$156 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
The task can easily be done with vba scripting dictionary which is what I intend using to complete this task.
$138 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will complete the project with dedication and submit the project within prescribed time limit without any delay.
$155 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I CAN HAVE THIS DONE AND BACK TO YOU ALL TO BEGIN USING AT COB TODAY IF YOUD LIKE. I AM A CERTIFIED MICROSOFT OFFICE SPECIALIST, GOING ON MY FIFTH CONSECUTIVE YEAR. I TRULY BELIEVE I AM THE BEST CANDIDATE FOR THIS PROJECT, AND I WOULD SINCERELY APPRECIATE THE WORK. I LOOK FORWARD TO A FAVORABLE RESPONSE. THANK YOU!
$233 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SAUDI ARABIA
Saudi Arabia
0.0
0
Member since Oct 18, 2015

Client Verification

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.