Google Spreadsheet for KPI Managers + Penalties
21 USD Goal
Automated Google Spreadsheet for evaluating sales managers' KPIs. Main KPIs (60 points) are calculated automatically from other sheets. Operational KPIs (40 points) are entered manually based on comments. Additionally, penalties are accounted for.
Structure
1. Sheet “Data” (input)
Data pulled from order/CRM sheets:
Number of orders
Sales amount
Average check
Conversion rate
2. Sheet “KPI”
Automatic score calculation based on a scale
Operational KPIs entered manually from comments/observations
3. Sheet “Penalties”
| Date | Manager | Reason | Comment | Score/Amount | Deducted? (yes/no) |
4. Sheet “Dashboard”
Charts: total score, conversion rate, sales volume, average check
Filters by month and manager
🛠 Functions
IMPORTRANGE,QUERY,VLOOKUPfor data retrievalDropdown lists for ratings
Automatic score calculation
Ready for scaling
Client's review of cooperation with Dmytro Nikitchuk
Google Spreadsheet for KPI Managers + PenaltiesAll right) We will work more
Freelancer's review of cooperation with Nazar Puh
Google Spreadsheet for KPI Managers + PenaltiesThe client provided a clear technical assignment with requirements. Was constantly in touch and responded promptly to questions. I recommend the client for collaboration
-
1 day22 USD
154 1 day22 USD
Good day. Certified specialist in Excel and Google Sheets. I will quickly complete your task
-
Winning proposal3 days21 USD
982 30 0 Winning proposal3 days21 USD
Good afternoon. I have extensive work experience. I will create an automated report for KPI calculation in Google Sheets for you. The task is clear, I can complete the assignment.
-
1 day33 USD
202 1 day33 USD
Hello! 👋
Ready to create a smart Google Spreadsheet for you that automatically calculates KPIs (60 points from formulas), provides space for manual ratings (40 points from comments), and won't forget about penalties 😅
🔧 Automation through formulas, colors, convenience, transparency — everything will be included!
I can also add a dashboard or a form for collecting ratings.
Everything will be beautiful, clear, and will work like a Swiss watch ⏱️
Write to me — we will agree!
… Best regards,
Artem Belash
-
2 days22 USD
45 2 days22 USD
Good day, I am interested in your project, ready to help. I have extensive experience with Google Docs.
-
2 days22 USD
1026 15 0 2 days22 USD
Good afternoon.
Ready to implement. We can discuss in more detail in private messages.
-
1 day22 USD
154 16 0 1 day22 USD
Hello!
I am interested in your project and ready to complete it. I can start working on it right now. Waiting for your feedback.
-
1 day22 USD
853 48 0 1 day22 USD
Hello!
I am interested in your project and ready to complete it.
I have been working with Google Sheets for over 5 years and have extensive experience in:
• developing custom solutions,
• creating templates,
• automating processes,
• integrating with third-party services,
… • developing complex formulas and scripts (Google Apps Script).
I am ready to discuss the details and find the best solution for your task. Let's communicate :)
Current freelance projects in the category Information Gathering
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 1 day 12 hours back ∙ 14 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 1 day 13 hours back ∙ 16 proposals |
We are looking for a person with knowledge of the German language for a company presentation.
115 USD
For our company, which is engaged in industrial assembly in European countries, we are looking for a person with German language skills (B2 / C1) — remotely, part-time What needs to be done: Call potential clients in Germany from a prepared database. The goal of the call is to… Information Gathering, Lead Generation & Sales ∙ 20 hours 5 minutes back ∙ 1 proposal |
Parsing and inviting to my Telegram groupParsing and inviting to my Telegram group. You can start with 1000 participants, but generally, it is expected to reach up to 10,000 participants. Online Stores & E-commerce, Information Gathering ∙ 5 days 21 hours back ∙ 12 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 6 days 12 hours back ∙ 19 proposals |
Lvov