Find Jobs
Hire Freelancers

An Excel File Which Calculates What Stock Can Be Shipped

€30-250 EUR

Completed
Posted about 4 years ago

€30-250 EUR

Paid on delivery
I need an Excel file where orders are entered into one tab and available stock are entered into another tab and excel calculates what orders can ship based on the supply available. Some orders have a ship together flag which means that if stock for both the items isn't available then the order won't ship. The order list will be in ascending order by date. If it's ship together then it checks if there's enough stock to support all lines on the order. If so it removes those volumes from tab B and adds a flag to indicate the order can ship, if not it skips to the next [login to view URL] is repeated until the remaining stock is 0.
Project ID: 24832734

About the project

38 proposals
Remote project
Active 4 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
Awarded to:
User Avatar
Hey there! This is Sourabh Gupta from New Delhi. I am an advanced spreadsheet developer currently at the post of Forum Expert at www.excelforum.com. I would like to provide my services for this project. I can write a fully automated VBA code for your file which would take in the available stock and the orders and would output what orders can be dispatched and if there's any stock left. Can write the script within both LibreOffice or MS Excel. I look forward to a positive and prompt response from your side. Regards Sourabh
€49 EUR in 1 day
5.0 (151 reviews)
6.1
6.1
38 freelancers are bidding on average €94 EUR for this job
User Avatar
Hello, I am an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
€100 EUR in 2 days
4.9 (418 reviews)
7.7
7.7
User Avatar
Hello, Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan
€100 EUR in 7 days
5.0 (254 reviews)
7.2
7.2
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am available to help you with your spreadsheet to manage the stock. Have you considered the use of MS Office?, the result should work in OpenOffice?. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. Contact me to discuss the details. Best regards
€100 EUR in 2 days
5.0 (283 reviews)
7.1
7.1
User Avatar
Hi, I will make order and shipping control sheet as per your requirement with good and professional quality without any error. I have completed more then 150 project within 11 months with 5 star review. You are gentle requested to see excel project sample in my portfolio here: https://www.freelancer.com/u/rashedkhanrubel. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! Rashed
€60 EUR in 1 day
5.0 (220 reviews)
6.5
6.5
User Avatar
Hi, Untitled spreadsheet (1).ods files within ship based on the supply available.. complete within 10 hours.... I will make Calculates with Visual Basic code in excel as per your requirement with good and professional quality without any error. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! champa
€50 EUR in 1 day
4.9 (278 reviews)
6.8
6.8
User Avatar
can make you that as I am a professional with all the skills and knowledge required for your project. Please review my profile as I am a preffered freelancer with excellent employer feedback and Satisfaction rate. Please send me a message and we can discuss further to start working on the project.
€30 EUR in 1 day
4.9 (106 reviews)
6.0
6.0
User Avatar
I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects of: • Excel Automation. • Excel Reports system. • KPI Dashboards. • Excel financial models. • Power Bi dashboards. • Data cleaning & filtration. • Excel dashboard designing. • Excel Solver. • Excel Optimization. • Email scraping. • Outlook. • Microsoft Access. • Excel calculators. • Excel vba. • Excel Tracker. • Mail merging. • Excel macro's. • Excel Inventory system. • word macro's. I have ability to do your project within your deadline, I need some discussion to make the things clear. Thanks.
€200 EUR in 3 days
4.7 (87 reviews)
6.3
6.3
User Avatar
Hello there! I have solutions for your project. I can do your project according to your description with the highest precision and quality. I would like to complete your project without error and with a full delivery. I have extensive experience in your project.
€110 EUR in 2 days
4.9 (153 reviews)
6.3
6.3
User Avatar
€39 Only ------- In just 12 Hours ------- I can the excel file to calculate what stock to be shipped by maintaining 100% accuracy of your data absolutely as you want ------- Excel VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting ------ I can start right now, please message me to discuss more.
€39 EUR in 1 day
5.0 (165 reviews)
5.9
5.9
User Avatar
Hello, I am a CPA and I can develop which can tell you the shipping quantity based on available inventory along with flags on items to be shipped together and perhaps may add some extra value to the result. Please do message if you would like to discuss this further. Best regards, Anjul
€89 EUR in 3 days
5.0 (34 reviews)
5.4
5.4
User Avatar
Hi There, I can develop order tracking and inventory available sheet for you on MS Excel.I am (Financial Modeling & Valuation Analyst) from CFI. Kindly visit my profile and see some samples of my work. Thanks
€150 EUR in 2 days
5.0 (13 reviews)
5.5
5.5
User Avatar
All you need is a nice VBA macro that will read both sheets, consider "shippable only together" criteria and if shippable remove stocks from tab B and add relevant flag. Very clear and easy task. I can do it in less than one day. Don't waste your money, one day and only 40 EUR will do the job. 13 years excellence in office automation and business application development. Responsible for what i deliver! Payment only after 100% satisfaction.
€40 EUR in 1 day
5.0 (19 reviews)
4.0
4.0
User Avatar
Hello, Dear Sir/Madam, I am Chartered Accountant(ACCA-UK) and expert in QB, Xero and Excel. You can see my profile I do have the relevant skill and can provide you up to the mark services. Thanks & Regards Muhammad Ilyas Saeed
€30 EUR in 7 days
5.0 (16 reviews)
3.7
3.7
User Avatar
Hello dear, I am a M.Sc. Engineer, I am expert in Excel and i can do your task in the required time. Thanks.
€30 EUR in 1 day
4.3 (4 reviews)
3.5
3.5
User Avatar
Thank you for given proposal
€156 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, i can do this job ASAP. I now I'm a beginner in freelancer. But I've been worked and expert in data entry and microsoft office to. I'm a hardworking and i'm sure that you're never disapointed with my job. So let me take this job for you.
€30 EUR in 48 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a professional accountant and I am very much experienced in excel. I am free and will complete the project before the deadline. Thanks
€140 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Yes I will do very honestly. I want to explore myself.
€156 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings! I have gone through your excel file and all job description. I’m a certified MS office expert and I can make this sheet more effectively and quickly. I assure you that you will definitely like my work. If interested, send me a message so that we can discuss further terms and timeframe. Regards, Engr. Zohaib Haider
€30 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
the days calculated on the basis of data .but I am give my best to complete the task .if required for long term task .I am ready for it .
€111 EUR in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of IRELAND
Bandon, Ireland
5.0
1
Payment method verified
Member since Apr 9, 2020

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.