Find Jobs
Hire Freelancers

Complex Excel function needed

$30-250 AUD

Closed
Posted almost 7 years ago

$30-250 AUD

Paid on delivery
Here is the scenario for which you need to design a function or macro to accomplish: - There are 1200 values (locations), each equating to X number of hours (work). - Each location lists up to five nearby people who can complete the work. - Excel must allocate locations to the nearest person until their hours >=30 - If a person's hours >=30, the location is allocated to the 2nd closest, and so on. - Each location can only be used (allocated) once. - All 1200 locations must be assigned in full. In your application you must state how you intend to accomplish the above. In your response, answer this test question to ensure you understand the project: "How many times can a location be used?"
Project ID: 13763406

About the project

28 proposals
Remote project
Active 7 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
28 freelancers are bidding on average $138 AUD for this job
User Avatar
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$210 AUD in 5 days
4.8 (220 reviews)
6.8
6.8
User Avatar
1 times Hi there happy to help you on this task. Please send me the excel file to confirm. I assure you that I will go beyond your expectations. Best regards
$90 AUD in 2 days
5.0 (158 reviews)
6.5
6.5
User Avatar
Each location can only be used (allocated) once. I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$200 AUD in 3 days
4.8 (141 reviews)
6.8
6.8
User Avatar
Hi 1200 First I need to see file to see how all your data is displayed to think about the way how to complete your task But , as a first sight, I would go with macro, simple shortcut or a button which would loop through each location and do what you need
$185 AUD in 3 days
4.9 (58 reviews)
5.8
5.8
User Avatar
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$88 AUD in 1 day
5.0 (42 reviews)
5.4
5.4
User Avatar
Each location can be used only once. The macro can be written in VBA in Excel. I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$100 AUD in 2 days
4.5 (57 reviews)
5.1
5.1
User Avatar
Bid Summary Each location is allocated onnce. - Can build the Excel macro to have the 1200 allocations assigned with the closest people not exceeding the 30hr limit. Project Requirements - 1200 locations having 5 people assigned to the location, and based on the total works hours for the location assign the closest people(5) for the task such that their total work hours doesn not exceed 30 - Allocation of person should be done for all 1200 locations. Relevant Skills and Experience - Extensively used the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells Proposed Milestones $100 AUD - Day3 - Work allocation based on 30hr limit
$100 AUD in 3 days
5.0 (32 reviews)
4.7
4.7
User Avatar
Bid Summary Answer of your question: >=30. I have read your instructions carefully. It needs to have excellent knowledge of VBA Programming. Project Requirements I will accomplish this task with VBA Programming with applying conditions. I will go through all 1200 locations by using loop and access one by one. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating Data, Using Advanced Formulas, Critical Programming and Creating Reports. Proposed Milestones $100 AUD - initial $122 AUD - final
$222 AUD in 3 days
4.8 (37 reviews)
4.5
4.5
User Avatar
Hello, To solve we need to a recursive function using VBA macro. I can help you with this. Looking to hearing from you. Each location can only be used (allocated) once.
$177 AUD in 3 days
4.9 (18 reviews)
3.9
3.9
User Avatar
Dear I am an EXCEL professional i will do your project by applying excel formulas including if statement. best regards humayoon
$175 AUD in 3 days
4.7 (8 reviews)
3.9
3.9
User Avatar
Bid Summary - Project Requirements - Relevant Skills and Experience = Proposed Milestones $100 AUD - - -
$100 AUD in 2 days
5.0 (9 reviews)
3.5
3.5
User Avatar
Hi, Each location can only be alocated once. So basically what I need to do is alocate the location to a specific worker based on a criteria. As I can see this can be donr using either conditional function or macro. I can start working on the project right away.
$111 AUD in 1 day
4.9 (7 reviews)
3.2
3.2
User Avatar
Using excel macro this task can be done. 1 location can be used once ONLY................................
$277 AUD in 5 days
5.0 (3 reviews)
2.8
2.8
User Avatar
Bid Summary Answer: Once. My solution will utilize a search function in excel for all values that checks the 5 options and takes the one with the lowest hours if not >=30. Looking forward to hearing from you! Project Requirements 1200 values (locations) must be assigned to one out of five options given that these have not exceeded >= 30 hours of work. Relevant Skills and Experience Long experience in excel, python, algorithms and data analysis (check my profile) Proposed Milestones $111 AUD - Final Additional Services Offered $0.01 AUD - To be discussed
$111 AUD in 5 days
5.0 (1 review)
2.0
2.0
User Avatar
Bid Summary Hi, I am working as IT professional since more than 18 years. I am a very experienced developer with Excel including VBA, data conversion and automation in large projects. Kind regards, Oliver Glas Project Requirements The task can easily accomplished with VBA. Regarding the test question: the location can only be allocated once. I would write a macro tagging the local in a seperate column wheter it is allocated or not. Going over the locations it will assign the first persion with <= 30 hrs. Relevant Skills and Experience Very experienced VBA developer. Proposed Milestones $98 AUD - Milestone
$98 AUD in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
MD. SHERAZUL ISLAM Hellow, Dear Honorable Project Manager, I am Md. Sherazul Islam. I have been working as a Data Entry professional as well as SMM provider. But, now I am working as a Team member. They are professional. we have 3+ years work experience in online market place and 100% Client satisfaction Our intention and so on. My service details:- Graphic Design Service:- -------------------------------------------- Logo design. Flyer design. Illustator design. Background remove. Image editing. Banner design. Web-template design. Business Card design. Social Media Marketing Service:- ----------------------------------------------------- FB page like, post like, photo like, video view. Twitter followers, Retweet, Favorite, like. Instagram followers, photo like, video view. YouTube subscribe, video like,view, comment. Pinterest followers, likes, pin. G+ followers, shere. Soundcloud follower, like, play. Linkedin followers, like, shere Data Entry & Others Service:- ------------------------- Data Entry, Copy Paste, Excel, Research, Mailing List Development, Spreadsheet, Email Handling, Email Marketing, Word, Google Docs, CRM, Forum Posting, Content writing, Article writing, Rewriting. Regard Md. Sherazul Islam April 18/
$31 AUD in 1 day
5.0 (5 reviews)
1.3
1.3
User Avatar
EACH LOCATION CAN BE USED ONLY ONCE Dear sir, I have wide experience in the area of Software Engineering, Big Data, Data Analysis and Data Processing. So, I am pretty comfortable that my Data Processing knowledge will be sufficient to accomplish your job fast and with high quality. I am new as a freelancer here, but it should not be an issue. Since I need some feedbacks from employers at this stage, I am bidding a lower price. I will accomplish the task using VBA function. Thanks
$55 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, The location can be used 1200*5 times (1200 locations * 5 people) or we can try by using macros looping Little about myself: I have done MBA in Finance Management, Also I am Microsoft certified in Advance Excel & having excellent knowledge of VBA Macros In my job I have always worked on big data, made dashboards prepared lots of new reports given insights & foresight to the management I am not an individual who needs to be micro-managed. Rather, when given a specific task, I can figure out the best ways to solve the problem in an autonomous manner. I will assure you that your work will be done within your timelines with Accuracy Currently Working with Ferrero India Pvt. Ltd. as an MIS Analyst I have more than 9 years of experience with MNC Companies as below 1) Ferrero India Pvt Ltd. (3rd Largest Company in choclate in the World - Italian Company) 2) Wipro BPO for Origin Energy Australian Client (As an Team Leader - MIS) 3) EXL Services Pvt. Ltd. for British Gas Client (As MIS Executive) 4) Raj Oil Mills Ltd (Sr. Sales Coordinator) Looking forward to speaking with you Thanks & Regards, Mohammad Parvez
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
How many times can a location be used? ONCE I can set up an algorithm that checks for each line how many times a location has been used based on a cell value (so you can even change that value if specs change) and work accordingly. I already worked for a job with similar specs, so I'm fully confident about the requirements. Please feel free to contact me for any query. Ciao Ugo
$250 AUD in 3 days
0.0 (0 reviews)
0.8
0.8
User Avatar
I will use array and dicticonary to store data of location & people to solve this problem. Could be finished within one day. For optimizensolving , a location will be use many times untill get the optimization solution
$100 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Jan 20, 2016

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.