Excel Work Allocation Matrix Designer

₹12500-37500 INR

Closed

Posted

13 days ago

₹12500-37500 INR

Paid on delivery

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or visually simple or appealing. We are looking for somebody to take the existing matrix and make it more user-friendly without losing any of its core functionality, as well as to create a database mechanism for data input and updates to the chart, and reporting functions. Work Tasks: - Redesigning an existing Excel matrix for teaching allocation to make it more user-friendly, flexible, and replicable. - Designing from scratch an associated database template to be used to input data for the Excel matrix - Meeting online with client (us) to review the existing model and understand needs, troubleshoot, etc.. Expected Duration: - Approximately 70 hours of work Key Qualifications - Extensive experience in developing excel worksheets - An aesthetic sensibility for designing complex Excel charts in user-friendly formats. - Expertise in converting client interests into manageable project designs. - Demonstrated success in delivering project results to clients in a timely and efficient manner - Good client relation skills in digital/online environments - Previous experience with designing workplace (especially academic) work allocation frameworks preferred but not essential. Time-Frame - Aiming for work to be completed and delivered by the end of May 2024 (flexible).

Project ID: 38076794

About the project

25 proposals

Remote project

Active 12 days ago

Looking to make some money?

Email address

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

25 freelancers are bidding on average ₹26,780 INR for this job

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

₹25,000 INR in 7 days

4.9

(623 reviews)

8.6

@snehamehta525

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh

₹20,000 INR in 3 days

4.8

(65 reviews)

5.9

@ammar3215

I am excited to submit my bid for the redesign and development of your university department's teaching allocation system. With over 10 years of experience in Excel worksheet development and a keen eye for user-friendly design, I am confident in my ability to enhance the functionality and visual appeal of your current system. My approach will involve: Redesigning the existing Excel matrix to prioritize user-friendliness while retaining core functionality. Creating a database template for seamless data input and updates. Conducting online meetings to ensure alignment with your needs and troubleshoot any issues. I have a proven track record of delivering projects efficiently and meeting client expectations. Additionally, my experience in designing workplace allocation frameworks, particularly in academic settings, positions me well to understand and address your unique requirements. I am committed to delivering high-quality results within the specified timeframe and look forward to the opportunity to contribute to your university department's success. Thank you for considering my proposal. I am eager to discuss further details and demonstrate how I can add value to your project.

₹25,000 INR in 15 days

5.0

(10 reviews)

4.9

@freelancer22to00

Dear Project Manager, Have gone through your requirements. Am happy to offer you, my support. If interested in availing my support, feel free to reach out and discuss. Regards I had the opportunity to create professional dissemination tool for some education institution Also note that fees and timeline are subject to our discussion on the actual requirements.

₹50,000 INR in 1 day

5.0

(6 reviews)

4.8

@Crayon1365

Hi there, I'm an expert developer with 10+ years of experience and already done a lot of ms excel project and developed many db based tools using ms excel. Please visit my portfolios in excel category to see some of my past projects. I can deliver a user friend and high quality work to you Warmest regards

₹75,000 INR in 15 days

5.0

(12 reviews)

4.3

@chintanshah97

* I will complete the project in one day with unlimited revisions* Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements, and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • Data Analysis • • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Chintan Shah

₹12,500 INR in 2 days

5.0

(6 reviews)

2.7

@syedalihassansh4

Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA

₹25,000 INR in 2 days

5.0

(11 reviews)

2.5

@Asadjutt111

With over a decade of experience as a data expert, my specialization in Excel, including Visual Basic and spreadsheet design, has given me the precise skills and aesthetic sense needed for your project. Through countless projects, I've refined the art of making complex data not just manageable but also visually appealing and user-friendly. This would prove absolutely vital for crafting your university's teaching allocation database. I understand that simplicity and ease-of-use are paramount in your university department as you handle multiple courses and staff members. My expertise not only in designing Excel worksheets but also in understanding client needs and troubleshooting will enable me to reimagine your existing matrix and construct an associated database with utmost care. Effortlessly converting complex data into readable yet meaningful information is something I thrive on. Your timeline is crucial to me, and I offer my continued availability for instant updates or anything else you may need via Freelancer Messenger We do have some flexibility with the final delivery date however, I assure you punctuality is one thing my work has consistently embodied throughout my career! Let's carve out the best space for your data together; reach out to me with any questions or messages you may have. Looking forward to embarking on this journey with you toward a more streamlined teaching allocation system at your esteemed institution!

₹12,500 INR in 1 day

5.0

(4 reviews)

1.9

@Sofb2h

I'm Sofiene, a seasoned Math Educator seeking to leverage my 20-years of experience and advanced Excel skills to deliver exceptional results on your University Work Allocation project. My deep analytical understanding and ability to think critically make me uniquely qualified for this task. I'm adept in transforming complex data structures into user-friendly, functional designs and have an eye for aesthetics that'll enhance your existing Excel matrix without compromising core functionality. My proficiency in Python, R, and Scala, combined with my expertise in big data and cloud technologies ensure I can create an efficient and replicable database mechanism for your unique allocation needs. Given the complexity of your task and the need for precise time allocation, my mathematical background stands advantageous. Not only am I well-acquainted with managing large data sets, but I also understand the value of accurate forecasts. Whether it's addressing multi-tasking demands or co-teaching courses, these insights will prove invaluable throughout our project. Throughout my career transition from Math Educator to Data Scientist, I've learnt the importance of delivering timely, efficient solutions that meet clients' needs. I look forward to bringing this same level of dedication to you as we work together through weekly online meetings, troubleshooting all aspects of the project until completion.

₹37,500 INR in 30 days

5.0

(2 reviews)

2.0

@Vikash42020

Hi I completely understand the job and would love to provide my services to create an automated template for work allocation as per business needs I have extensive experience working with Excel Advanced Functions and VBA automation, ChatGPT, AI, Google Sheets, Power BI , MS Access. I look forward to providing my best services and building a long term partnership. Being a Top-Rated Freelancer, I take great pride in OVERDELIVERING. Client Satisfaction is my number one priority. I am also a Microsoft certified excel Specialist and a Professional Data Analyst. I have completed several projects based on Excel Advanced Functions and VBA Automation, Google sheet automation with app script and more. Would love to give my full support here. We may discuss more on the message and then I will start working on the same right away. Looking forward to interviewing with you once and then plan to start working together from there on. Thank you! Vikash “If I do a job in 10 minutes, It’s because I spent years learning how to do that in 10 minutes. You owe me for the years, not the minutes”.

₹35,000 INR in 5 days

4.5

(2 reviews)

1.9

@SmartOfficer

hi there. I can complete your project within the time frame. I am expert in Excel(macro and vba, pivot), power bi. Please contact me for more discussion.

₹18,000 INR in 15 days

5.0

(4 reviews)

1.2

@typingtapestry

Given my 4+ years of experience in writing content, and performing data entry and transcription for various multinational companies, I have developed valuable expertise in working with complex data structures, such as the one you describe. My proficiency in Excel goes beyond basic understanding; I am adept at re-designing charts, making them both more visually appealing and user-friendly without compromising core functionality. Throughout my career, I have consistently produced results for my clients in a timely and efficient manner; this has been possible largely due to my ability to convert clients' interests into manageable project designs – a key skill that will be invaluable in redesigning your teaching allocation matrix to match the desired specifications while enhancing its usability. Moreover, I maintain good client relations even in digital environments – a crucial aspect given that we'll be meeting online throughout the project. Needless to say, your timeline is also attainable as it is within my capacity to complete the work within 70 hours. With all these qualities combined, I am confident that I am the optimal choice for your Excel Work Allocation Matrix Designer position.

₹25,000 INR in 10 days

0.0

(0 reviews)

0.0

@Rohit7706

As an experienced data entry specialist with over 3 years under my belt, I have developed a deep understanding of Excel and its wide-ranging capabilities. I'm confident that I can excel in designing a user-friendly and efficient teaching allocation database for your university department. In fact, I've had hands-on experience developing similar structures for large-scale academic institutions before successfully. What sets me apart is my unique blend of data-oriented skills and an eye for aesthetics. I understand the complex nature of your information needs, but I'm also conscious of the value of simplicity in UX design, especially when it comes to Excel charts. My past clients have commended me for my ability to translate their interests into practical designs that simplify tasks while preserving core functionalities. Creating an efficient work allocation framework necessitates not only technical proficiency but also excellent communication skills. I pride myself on forging strong professional relationships, even in digital settings. Let's join forces to make your university's work allocation processes smoother, as we cater to the diverse demands

₹25,000 INR in 7 days

0.0

(0 reviews)

0.0

@SunnySony23

As a seasoned data entry professional with a comprehensive understanding of Excel and data processing, I am confident in my ability to meet the demands of your project. My proven track record in developing and redesigning intricate Excel worksheets gives me the edge to streamline your teaching allocation database effectively and efficiently. Combining advanced technical skills with an aesthetic eye for design, I can transform your current matrix into an intuitive, user-friendly interface without sacrificing its critical functionality. Moreover, my adaptability across various industries has honed my knack for translating diverse client requirements into feasible project designs. This aligns perfectly with your need for a freelancer who can understand your complex array of information and transform it into a manageable structure. In leveraging my skills, I will also create a database template from scratch that integrates seamlessly with your enhanced matrix, ensuring smooth input and update processes as well as robust reporting features.

₹12,500 INR in 4 days

0.0

(0 reviews)

0.0

@arooprooj

Hi I have gone through your requirement and Committed to delivering a tailored solution to meet your department's needs effectively. Looking forward to collaboration.

₹25,000 INR in 7 days

0.0

(0 reviews)

0.0

@ankitbhatt1755

Sir I am interested this project I will done this work your time period my whatapp number 8130949181 I hope send this project work please sir

₹14,000 INR in 7 days

0.0

(0 reviews)

0.0

@phanikumarbs

15+ years of Excel expertise, data science certifications in Michigan University and IIIT-B, and strong communication skills make me the ideal candidate to transform your complex university work allocation system into a user-friendly, visually appealing tool. With my experience with Clients, I can design a system tailored to your unique needs and utilize Python/SQL skills to build a robust database. I prioritize open communication throughout the project, ensuring a smooth and successful collaboration.

₹20,000 INR in 3 days

0.0

(0 reviews)

0.0

@wylgner

sou o profisional que voçe proucura ,me contrate e tenha em suas maos um exelente trabalho, sempre busco dar meu melhor em meus trabalhos.

₹25,000 INR in 9 days

0.0

(0 reviews)

0.0

@solg9x

Hello, sir? I have checked your description carefully. -------I have my work samples to show---------- I have many experiences in Excel VBA, Macro, Financial Calculation, Matrix design, Data Visualization, Data Modelling, Data processing. I can provide good result in time. I can START your project RIGHT NOW. I look for the opportunity to work with you. Thank you.

₹20,000 INR in 2 days

0.0

(0 reviews)

0.0

@freehosting00001

I'll redesign your Excel-based teaching allocation database for user-friendliness and create a new database template for data input. I've got extensive Excel development experience and an eye for aesthetic design. Let's streamline your system and deliver results efficiently.

₹25,000 INR in 7 days