Find Jobs
Hire Freelancers

Excel Formula or Power Query for Task Assignment in Excel

$10-30 USD

Closed
Posted 2 months ago

$10-30 USD

Paid on delivery
I need someone to create an Excel formula or power query for me. The purpose of this tool is to automatically assign tasks to staff members based on their spoken language and presence at work. Key Requirements: - The formula needs to consider the spoken languages of our staff, which include English, Spanish, and Vietnamese. - The tool must take into account whether a given staff member is present at work. I will provide this data through manual input. - The task assignment does not need to prioritize certain languages over others. Ideal Skills and Experience: - Proficiency in Excel formulas and power query - Experience with task assignment or scheduling systems Please see the attached document. The list of staff members is on tab 2. The idea is that once a new record is generated in the table in Tab 1, it should automatically assign equally among the staff.
Project ID: 37821355

About the project

30 proposals
Remote project
Active 27 days 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
30 freelancers are bidding on average $26 USD for this job
User Avatar
With expertise that spans over seven years in the field, I am confident in saying that this project is right up my alley. Working extensively on tasks involving Excel formulas and power queries, I'm comfortable with the core skills required to complete this job. This includes managing scheduling systems and even developing unique solutions tailored specifically to the needs of the client's businesses. Moreover, my experience in Data Entry, Web Scraping as well as building Web Automation tools will be incredibly valuable here. They allow me to understand complexities of data and turn out efficient solutions using an iterative process. I'm confident that I can create a sound solution for you. Finally, my approach towards problem solving aligns perfectly with your ideal expectation of a long term collaboration. My commitment towards clear communication and delivering satisfactory work within stipulated timeframe along with my competencies solidifies Digital Screencast as your ideal choice for this project.
$50 USD in 1 day
4.9 (614 reviews)
8.6
8.6
User Avatar
Hello, I am an Excel expert and I can write a formula for assigning tasks to staff members based on your criteria. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
5.0 (515 reviews)
8.1
8.1
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$35 USD in 1 day
5.0 (193 reviews)
7.1
7.1
User Avatar
Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). I successfully delivered Dashboard, Scorecard, KPI Tracker, heatmap & ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can support you to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics Excel | VBA | Power BI | SQL | OCR | GSheet
$30 USD in 2 days
5.0 (27 reviews)
4.8
4.8
User Avatar
As a full stack developer and data analyst, I have an extensive skillset directly aligned with your project's needs. My mastery of Excel, including formulas and power query, ensures that I can create a highly efficient task assignment system for you. In addition to Excel, I have experience working with task assignment and scheduling systems. This gives me perspective and understanding of the complexities you might encounter when implementing such a tool. I am confident in my ability to craft an algorithm that not only accounts for staff's spoken languages but also takes into account their presence at work. In my years within software development and data analysis, I've observed how tasks and assignments can make or break a team's productivity. That's why my emphasis is always on optimizing processes and driving growth through technology and data. With me on your project, you'll get the advantage of a detail-oriented problem-solver who is devoted to delivering high-quality solutions. Let's
$30 USD in 1 day
5.0 (13 reviews)
3.6
3.6
User Avatar
Hello I have done MBA in Finance with Excel specialistity I am right choice for this job, I have successfully completed many jobs on this platform you can check my profile Let's talk in chat
$20 USD in 1 day
5.0 (15 reviews)
3.6
3.6
User Avatar
With my extensive experience in data processing and Excel, I have developed a keen eye for detail in task assignments. Being proficient in not just Excel formulas but also power queries and Visual Basic coding, I can confidently say that creating the customized algorithm matching your project requirements is well within my capability. This will enable the assignment of tasks among staff members in accordance with their language proficiency for English, Spanish, and Vietnamese. An added asset that I bring to the table is my background in data entry as well. With this skillset, manual inputs such as staff presence at work can be efficiently handled and incorporated into the system design we create together. I think it's crucial to note that I don't prioritize languages based on any hierarchy, so our tool will balance Resources' workload fairly
$25 USD in 1 day
4.7 (5 reviews)
3.0
3.0
User Avatar
Hello, I am an Excel expert with years of experience working for different companies. I can provide assistance with data cleaning, visualization, data scrapping, database creation and management and many more. Feel free to contact me for anything. Best Regards Shishir
$20 USD in 1 day
5.0 (6 reviews)
3.0
3.0
User Avatar
I am Miguel, a data analyst specializing in Excel, Visual Basic, Power Query, and Power BI. With six years of experience in handling diverse data sets, including sales, purchases, and inventories, I bring a wealth of expertise to the table. My proficiency extends to crafting detailed analyses, creating customized reports, and implementing automations to meet your specific requirements. I have a strong background in VBA macros and have successfully completed numerous similar projects in the past. I approach my work with a high level of professionalism, paying close attention to detail, and ensuring complete customer satisfaction. Please feel free to reach out to me with more details about your project so we can initiate the next steps.
$15 USD in 5 days
4.5 (6 reviews)
3.0
3.0
User Avatar
Hi, as a skilled MS Excel expert, I'll create a formula or power query to automatically assign tasks to staff members based on their spoken language and work presence. With proficiency in Excel and experience in task assignment systems, I'll ensure efficient and fair distribution among the English, Spanish, and Vietnamese-speaking staff members. Excited to streamline your task assignment process. Thanks
$20 USD in 1 day
5.0 (1 review)
2.3
2.3
User Avatar
I read your project details, I have 13 years experience on your project. I can do it very easily Already i completed some projects like this. Just a Close your eyes and Trust me. I am sure, you will be happy
$11 USD in 2 days
5.0 (3 reviews)
2.0
2.0
User Avatar
I am an expert in python, c programming, excel and matlab as I am mechanical engineer by profession. I also have experience in report and research writing and have recently written two submitted master dissertations in English language. I have experience in latex writing as well. Also I have Presentation making and article writing experience, biology writing, Video editing and videography are also my add up skills.
$20 USD in 7 days
4.2 (5 reviews)
1.7
1.7
User Avatar
As an expert in Excel and Microsoft Access, I'm highly skilled at developing intricate spreadsheets and automating tasks to streamline data management. In your case, I can create a powerful formula or employ Power Query to implement the task assignment system based on spoken languages and staff presence that you need. Furthermore, my ability to write custom VBA macros and utilize APIs will ensure a seamless integration between your task assignment system and any other relevant systems that you use. In addition to my technical proficiency, I bring three years of experience—delivering innovative data-driven solutions and handling complex web development projects. My proven track record of meeting deadlines combined with my commitment to quality ensures that you will receive an accurate yet efficient solution for your needs. Above all, I value open communication and collaboration, understanding that the key to success lies in shared goals and clear expectations. And lastly, I offer budget-friendly pricing solutions that are tailored to your specific needs; because for me, client satisfaction is paramount. Let's discuss your project further, together we can turn your ideas into reality with my uncompromising skills in Excel Development and powerful Data Processing techniques .
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, I am Owala Amos with 5 years experience on Microsoft Excel, data processing, database and visual basic, given the opportunity to undertake this project, I will demonstrate my skills and capabilities.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Data analysis professional. Im a self motivated and hardworking individual. I believe in customer satisfaction, quality work and Ill complete the given task on time. I provide services all over the world
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a freelancer who has experience processing data, inputting data, and compiling data to form a report that is easy to understand. Starting from inputting data via MS Word, Excel
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
With a background in retail and business, coupled with strong Excel skills, I am confident in my ability to contribute effectively to your team. My experience in retail has honed my attention to detail and ability to manage data accurately. I am adept at handling large volumes of information efficiently and have a keen eye for identifying discrepancies or errors. Additionally, my proficiency in Excel enables me to manipulate data, create reports, and perform complex calculations with ease. I am highly motivated and committed to delivering high-quality work within designated timelines.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I can asist you to create the right formula to assign tasks automatically for your staff. So, if you are interested in the proporsal, you can contact me and let me know some more details to help you with your daily operations.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I'm well-equipped for this project due to my expertise in Excel formulas and power query, combined with experience in task assignment systems. I understand the need to automate task assignments based on staff members' spoken languages and presence at work. By leveraging Excel, I can create a formula or power query that considers both criteria and equally distributes tasks among available staff members. My proficiency in Excel allows me to efficiently manipulate data and create dynamic solutions. Additionally, my experience with task assignment systems ensures that I understand the complexities involved and can tailor the solution to meet your specific needs. With meticulous attention to detail and a commitment to delivering high-quality results, I am confident in my ability to successfully develop the required tool for your task assignment process.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Fontana, United States
0.0
0
Payment method verified
Member since Dec 15, 2021

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.