Find Jobs
Hire Freelancers

Do some Excel Work

$10-30 USD

Closed
Posted over 9 years ago

$10-30 USD

Paid on delivery
I would like to have an excel small macro/program to complete the following task: This will be used to make decision about moving inventory from one company between it's plants, based on historically usages (weekly basis),and on hands inventory, which plant will be the best to pull the inventory from based on lower and higher user and based on inventory on hands, also region on the plant. Information will be pulled from SAP, usage will be input in weekly or monthly basis, inventory will be pulled from sap and injected to the spreadsheet. I would like to have a cover page where you can make the input of the material number, and with a click of a button will display the best option based on: inventory on hands (based on historical usage) and region where it's being pulled
Project ID: 6091596

About the project

21 proposals
Remote project
Active 10 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
21 freelancers are bidding on average $78 USD for this job
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$200 USD in 0 day
4.9 (348 reviews)
7.8
7.8
User Avatar
A proposal has not yet been provided
$111 USD in 1 day
4.9 (265 reviews)
7.7
7.7
User Avatar
Hi That is surely possible. With transaction MC.9, you can have the entire related information, while with the S0* inventory tables, you can get more relevant information from SAP. This information can be downloaded to your excel, and as per your algorithm of evaluating the inventory status, can pull out which plant is best to pull the inventory out for the usage. For that, I'm assuming your MM03 (master data) is correctly maintained at plant level, i.e. ROL, ROQ and other related information. I'm interested in doing your work and with past experience with SAP BI, can surely assist you in coming up with the best possible results. Cheers mate,
$277 USD in 7 days
5.0 (33 reviews)
6.1
6.1
User Avatar
Hi; I am an Excel / VBA coder professional with over ten years experience in developing automated productivity enhancing, time saving applications. Moreover I have hands on inventory management experience in a multi-location, distribution business. Your comments are welcomed. Regards
$90 USD in 1 day
4.9 (35 reviews)
5.7
5.7
User Avatar
Hi, I am a supply chain engineer, VBA expert. I fully understand your need of optimizing your stock dispatch. Provide me with sample of your extractions and I will be able to propose a mockup. Your can look at my past reviews employers like to work with me. Regards. Pierre
$166 USD in 3 days
4.9 (31 reviews)
5.5
5.5
User Avatar
Hello, I have read description carefully. We can start the work immediately. If you have any queries related to deadline of work or any other queries please let us know. Looking for healthy and long term business relationship with you. Please provide us further details. Let's start discuss... Thank you.
$20 USD in 1 day
4.9 (48 reviews)
5.1
5.1
User Avatar
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing code / debugging Excel VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$100 USD in 2 days
5.0 (38 reviews)
5.1
5.1
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
4.7 (19 reviews)
3.7
3.7
User Avatar
Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done these type of similar projects before. Thanks
$40 USD in 1 day
4.8 (11 reviews)
3.7
3.7
User Avatar
Đề xuất vẫn chưa được gửi
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is my first bid and I will make sure that this will be one of the BEST work I could keep. If there would be any clarification or adjustment needed, I will make it up to you in advance.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I believe I have the capacity to do that work for you perfectly and within reasonable time. consider my proposal
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir, I will ensure 100% accurate and satisfied work. If you are not satisfied I dont want the payment.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, A 10 years professional experience in Microsoft Excel ,Ms Access and computer experience,i have read your job and mastered every detail,i am ready to resume on your work and deliver to you a quality work that you expect.I look forward to communicate with you. Thank you.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I develop several complex system in my previous employee. I started as MS Excel VBA Macro programmer and Im expert with this. Currently I' am a full-time programmer, I can provide a 40 hrs/week work for this project. I am very much available to provide full support from requirement gathering to user testing to implementation and maintenance.I would be happy to have an opportunity to work with your firm.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am assuming you have a excel file that will have the data of Qty on hand from various plants as well as usage by date/month/year on one sheet In the other sheet, there will be a form with drop down for Inventory item, a text box for qty needed, and a submit button that on click will list all plants and their inventory sorted by least used.
$110 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! Thanks for taking the time to put together these details on the upcoming project. I've submitted my bid of $90 based on my assumption of using your SAP data 'injected' (pasted) into a pre-built Excel input worksheet, and then running off of the historical results from previous weeks (which I'd either load in directly first, or which would build up over time as successive weeks get put in). The major assumption behind my solution is that someone will be able to 'inject' (or 'paste') the SAP data into the spreadsheet on a monthly basis -- before starting on the project, I would want to walk through with you some more background on where/how you expect to get the information into the sheet. Definitely give me a buzz if you'd like to go through this in more detail -- I'd be happy to work on the Excel automation so that anyone can use the sheet (and, most especially, in a user-friendly way!). Take care, ~ Meg CC
$90 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, If you fed up with your monotonous, uninteresting, tedious and repetitive work on excel, we could provide you excel macros solution which could do your work within few seconds. Thus, you can utilize your time for more meaningful work. If you are collating many excel files into one fixed format, we can collate it through macros. If you are dividing one Master excel sheet into many excel files on the basis of some criteria like branches or groups, we could do it. If you need to send different files as attachments to different locations, we can send emails through macros. Recently, we designed a macro for a firm, which could send 180 different files to its 180 branches. It means, all 180 branches would receive their branch file only. If you want dynamic report, which reflects changes made in the data sheet, we can do it. You just need to update or feed data into one sheet and all report sheets will get updated without any effort dynamically. We are group of freelancers based in Mumbai, India and we have several years experience of using Excel and VBA to produce management and business information from underlying data. Rates are negotiable depending on the nature of the projects. These are some other solutions which we provide to the firms, which saves their substantial amount of effort, cost and time. Data reconciliation Data Collation Data Segregation Data formatting Data allocation Reporting macro Dynamic Pivot table modification Dashboard Any requirements let me
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working as a certified senior sap consultant in large multinational firms for several years now. I am also very proficient in using the different Microsoft applications in my work like excel. With these experiences, I believe I will be able to properly integrate and fulfill your complete requirements. I have made an initial estimate of 3 days to give time for matching and mapping, testing, and production deployment. To start with our communication, you can contact me at 0119156718915 from your US phone. If you are unable to contact me, just drop me a message here and I will respond as soon as I can.
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Irving, United States
0.0
0
Payment method verified
Member since Jun 19, 2014

Client Verification

Other jobs from this client

Inventory Allocation Report
$10-30 USD
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.