Complex Excel function needed

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

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

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/

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

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

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.

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

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

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.

Dear I am an EXCEL professional i will do your project by applying excel formulas including if statement. best regards humayoon

Bid Summary - Project Requirements - Relevant Skills and Experience = Proposed Milestones $100 AUD - - -

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.

Using excel macro this task can be done. 1 location can be used once ONLY................................

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

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

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/

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

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

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

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