Find Jobs
Hire Freelancers

Excel Formula or Power Query for Task Assignment in Excel

$10-30 USD

Kapalı
İlan edilme: yaklaşık 2 ay önce

$10-30 USD

Teslimde ödenir
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.
Proje No: 37821355

Proje hakkında

30 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 12 gün önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
30 freelancers are bidding on average $26 USD for this job
Kullanıcı 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 1 gün içinde
4,9 (614 değerlendirme)
8,6
8,6
Kullanıcı 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 1 gün içinde
5,0 (515 değerlendirme)
8,1
8,1
Kullanıcı 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 1 gün içinde
5,0 (193 değerlendirme)
7,1
7,1
Kullanıcı 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 2 gün içinde
5,0 (27 değerlendirme)
4,8
4,8
Kullanıcı 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 1 gün içinde
5,0 (13 değerlendirme)
3,6
3,6
Kullanıcı 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 1 gün içinde
5,0 (15 değerlendirme)
3,6
3,6
Kullanıcı 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 1 gün içinde
4,7 (5 değerlendirme)
3,0
3,0
Kullanıcı 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 1 gün içinde
5,0 (6 değerlendirme)
3,0
3,0
Kullanıcı 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 5 gün içinde
4,5 (6 değerlendirme)
3,0
3,0
Kullanıcı 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 1 gün içinde
5,0 (1 değerlendirme)
2,3
2,3
Kullanıcı 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 2 gün içinde
5,0 (3 değerlendirme)
2,0
2,0
Kullanıcı 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 7 gün içinde
4,2 (5 değerlendirme)
1,7
1,7
Kullanıcı 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 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED STATES bayrağı
Fontana, United States
0,0
0
Ödeme yöntemi onaylandı
Ara 15, 2021 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.