Google Sheet Application tracker and Dashboard -- 2

$10-20 USD

Tamamlandı

İlan edilme: 3 ay önce

$10-20 USD

Teslimde ödenir

I'm looking for an Google Sheet expert to create a dashboard that visualizes our operational data. The main focus will be on performance efficiency metrics. We are an interpreting and translation company and want to create an application tracker using Google Forms and CRM data (copied manually). The dashboard should display language-level staffing information with tiles showing Language, Needed, Applied, Hired, and Active, along with a dropdown to filter by language. Needed is calculated as (total CRM appointments × 6) + total “No” in “Is This Interpreter Active?” and shows green above 95% coverage. Applied shows total Google Form submissions and turns yellow if below 75% of Needed. Hired counts all “Yes” entries from the form and turns red if below 50% of Needed. Active counts interpreters marked “Yes” in the active field. Conditional formatting should update automatically when a language is selected, and the dashboard must be read-only. Data from the Google Form populates the main page for recruiters to add payments and notes; if Hired is “Yes,” the record moves to the Hired tab, if “No” to Prospective, and if “Following Up,” it stays on the main page. The Hired tab should allow filtering by language, service type, and city. The company logo should be clearly visible in the dashboard header. Add our company logo and we mush have commercail right

Proje No: 40083927

Proje hakkında

11 teklifler

Uzaktan proje

Son aktiviteden bu yana geçen zaman 3 ay önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

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

Seçilen:

@anirudhat

Hi, I can help with this task. Ready to start immediately.

$10 USD 1 gün içinde

0,0

(0 değerlendirme)

0,0

11 freelancer bu proje için ortalama $20 USD teklif veriyor

@chraheelbhatti

As a Senior Machine Learning Engineer and PhD Researcher with a specialization in Computer Vision, Natural Language Processing, Generative AI and past experience in AI-powered processes for major organizations including Unilever Pakistan, State Bank of Pakistan and various State Institutions - I am the precise person you need to create the Google Sheet Application tracker and Dashboard your company requires. Through my career also worked on SaaS tools, I have gained extensive experience in Data Entry, Data Processing, Data Visualization, Excel Functions/Macros/VBA and other relevant skills needed for this project. Not only do I possess the technical aptitude to design comprehensive machine learning models for your data-driven dashboard, but I also offer strong academic research skills that would ensure accurate implementation of the visualized operational metrics. I assure you; the final product will not only provide valuable insights but be flawlessly aligned with your needs - ensuring significantly higher efficiency for your company in interpreting and translation services.

$10 USD 1 gün içinde

4,9

(24 değerlendirme)

4,9

@mehranriaz0

Greetings, It sounds like you're looking to create a comprehensive dashboard in Google Sheets to track your operational data for your interpreting and translation company. The goal is to visualize performance metrics clearly, focusing on language-level staffing information. I would approach this by setting up a structured dashboard that incorporates your specific metrics, like Needed, Applied, Hired, and Active interpreters. Each metric would have conditional formatting to signal performance effectively. I’ll ensure the dashboard integrates seamlessly with data from Google Forms, allowing recruiters to manage their entries efficiently. The design will also include your company logo prominently, ensuring it aligns with your branding. With my experience in Google Sheets and data visualization, I can create a solution that meets your needs and enhances your operational tracking. Best regards, Mehran Riaz

$15 USD 7 gün içinde

5,0

(4 değerlendirme)

4,3

@afshan2176

Hello Santi P. I'm afshan, a Brand Identity specialist with over a decade of experience. After reviewing your project and its description regarding Google Sheet Application tracker and Dashboard -- 2, I'm keen to take on this project. My Portfolio: https://www.freelancer.com/u/afshan2176 My process involves: Presenting multiple drafts (3-4) in the initial round. Incorporating feedback and iterating through subsequent rounds until we reach the final product. I'm open to unlimited revisions to ensure the end result meets your expectations. You can view my relevant work on this link: freelancer.com/u/arnicamaredia97 Let's discuss this further in the chatbox. Best regards, Afshan

$10 USD 1 gün içinde

5,0

(11 değerlendirme)

3,7

@zeeshanmomin722

Hi, I saw your job post and I'm up for the job. I rushed to take this opportunity. As I've extensive experience in this domain. I've more than 5 years of experience in Data Analysis, Excel Macros, Excel VBA, Data Processing, Visual Basic, Excel, Data Visualization, Google Sheets and Data Entry with many completed jobs on different freelance markets. I'm available to start working on this. -Why me or reason to consider me: ✅ Promise to manage UNLIMITED REVISIONS until your complete satisfaction. ✅ Deliver all necessary files with complete copyrights for the final design. ✅ Guaranteed On-Time delivery. ✅ 100% satisfaction guaranteed. Please contact me to discuss more regarding this project. PORTFOLIO: https://www.freelancer.com/u/zeeshanmomin722?w=f Thanks & regards Zeeshan M.

$15 USD 1 gün içinde

5,0

(4 değerlendirme)

3,9

@temciucv

Hello Santi P., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Visual Basic, Data Processing, Data Entry, Excel, Excel VBA, Excel Macros, Data Visualization, Data Analysis, Google Sheets Lets connect in chat so that We discuss further. Thank You

$15 USD 7 gün içinde

5,0

(1 değerlendirme)

1,7

@BlocKeyFi

Hi Santi, I understand that you are looking for a Google Sheet expert to create a dashboard that visualizes operational data, with a focus on performance efficiency metrics for your interpreting and translation company. I propose to design a comprehensive dashboard that integrates Google Forms and CRM data to track application status and staffing information by language. The dashboard will feature tiles displaying Language, Needed, Applied, Hired, and Active counts, with a dropdown filter for language selection. The dashboard will dynamically calculate Needed based on total CRM appointments and active interpreters, highlighting green for over 95% coverage. It will track Applied submissions, turning yellow if below 75% of Needed, and monitor Hired counts, alerting in red if below 50% of Needed. Active interpreters will be marked based on the active field. The dashboard will feature automatic conditional formatting updates based on language selection and be read-only for data integrity. Recruiters will be able to add payments and notes on the main page, with records moving to appropriate tabs based on status. The Hired tab will allow filtering by language, service type, and city, with clear visibility of your company logo throughout the dashboard. I'll send over my portfolio via direct message. Feel free to reach out there. My background in data visualization and Google Sheets ensures reliable results, professional standards, and seamless execution. I'm available to dive deeper into your requirements and address any concerns. Best regards, Taneem

$15 USD 7 gün içinde