Budget: 1000 UAH Deadline: 1 day
Interested in your project, ready to carry it out after receiving a more detailed technical assignment in private. Contact me
There is a Google spreadsheet with data from specific football matches. It needs to be divided into separate blocks by teams. In the blocks, a formula should be used to calculate data from one row, but from different cells. For example, the percentage ratio of dependent values from two cells in the same row and another. It is also necessary to automatically add data to the blocks when data is added to the overall table.
Budget: 1000 UAH Deadline: 1 day
Interested in your project, ready to carry it out after receiving a more detailed technical assignment in private. Contact me
Budget: 1000 UAH Deadline: 2 days
Hello! I will create Google Sheets for your football data so that there are separate dynamic blocks with auto-updating and necessary formulas (% ratio between cells in a row and between rows, if needed) for each team, without manual work.
What you will receive
Auto blocks by teams: data is automatically pulled into the team block when a row is added to the “overall” table.
Calculations: percentages/coefficients between different cells of one row (and, if necessary, indicators vs the previous match of the team).
No duplication: filters are tied to unique IDs/date+opponents.
Flexibility: easy to add/change formulas and fields.
How I will implement it (for free/reliably)
Option A (only with formulas, no scripts):
UNIQUE + FLATTEN for the list of teams,
for each team — FILTER/QUERY on the main range,
calculations in an array through ARRAYFORMULA + protection from /0 (IFERROR).
Examples (I can insert them directly into your file):
List of teams:
=SORT(UNIQUE(FLATTEN({Data!B2:B;Data!C2:C}))) // if B=Home, C=Away
Team block in a separate sheet:
=QUERY(Data!A:Z;"select * where B='"&$A$1&"' or C='"&$A$1&"'",1)
Percentage in a column (e.g., shots on target / shots):
=ARRAYFORMULA(IF(ROW(Data!A:A)=1;"% SOT";IFERROR(Data!H2:H / Data!G2:G;)))
Option B (Apps Script, if “separate sheets for each team” is needed automatically):
The script goes through the list of teams, creates/updates sheets with the QUERY formula,
onChange trigger — everything updates after adding new matches.
Budget: 1000 UAH Deadline: 1 day
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 :)
Budget: 1000 UAH Deadline: 2 days
I will do it, contact me.
============================================================
Budget: 1000 UAH Deadline: 1 day
Good day
Ready to complete your project
I have extensive experience with spreadsheets
I will do everything quickly and efficiently
Contact me!
1. Choose a service 2. Configure the service 3. Create a template 4. Upload the database 5. Check functionality and deliverability (and avoid going to SPAM) 6. Send a one-time mailing to 1000+ subscribers please write your financial proposals and deadlines
We are looking for an effective Meta-targeting specialist who can work with complex projects and is responsible for the effectiveness of advertising, not just its launch. Project — recruitment for a vacancy. Direction: attracting quality targeted responses for an office vacancy in Kyiv. Tasks: • launching and managing advertising campaigns in Meta Ads • attracting quality targeted responses for an office vacancy in Kyiv • working with cold audiences and finding new sources of applications • testing creatives, audiences, and advertising combinations • scaling effective campaigns and disabling non-working ones • optimizing the cost of targeted responses and budget • controlling the quality of incoming applications (relevance of candidates, compliance with requirements) • adhering to moderation rules and finding stable solutions for working in complex advertising niches Important: • priority — quality targeted responses, not their quantity • irrelevant applications and non-target traffic are not considered results • systematic low quality of applications will result in termination of cooperation • looking for a specialist with practical experience who can bring quality candidates, not just test basic hypotheses at the expense of the advertising budget Requirements: • confident experience with Meta Ads • experience attracting candidates for vacancies through Meta Ads will be an advantage • ability to work with cold audiences and find new segments • focus on quality targeted responses, not on reach and clicks • experience optimizing advertising campaigns by cost and quality of applications • understanding the specifics of passing moderation and ability to create conversion advertising materials • analytical approach, independence, and responsibility for results Will be a big plus: • experience launching advertising campaigns in gray niches • successful experience attracting candidates for vacancies in Kyiv and the Kyiv region • having cases with quality responses at target cost • ability to quickly find and scale working advertising combinations Payment: • discussed individually
We are looking for a person who has time and is capable of analytical, structured thinking. It is necessary to manage and improve Notion and related documents (Google Docs) for a small marketing team, so that the knowledge base, processes, and important artifacts are not lost, ensuring structure and order. Employment for 2–3 months. It involves approximately 5 hours per week.
Description: We maintain a reporting system for trainings/courses, where each client has a separate Power BI report that retrieves course completion data via the Tovuti LMS API using Power Query (M). One of these reports has started returning a 429 Too Many Requests error, as the query reloads the entire data history each time, and the volume of this history has already exceeded the Tovuti API request limit. Requirements: Rewrite the Power Query so that only new/modified records are loaded during each refresh, using the timestampModifiedAfter parameter in the courseProgresses endpoint (this parameter has been confirmed to exist and work), instead of reloading the entire history. Add retry/backoff logic so that in case of a 429 error, the request pauses and continues working instead of failing with an error. Test the fixes on our actual Tovuti API and confirm that the updates are successful. Briefly document the changes (what and why was changed) so that we can maintain this in the future. Data model context: The report consists of 4 related tables: Teams, Courses, Users, and AssigmentsProgress (fact table pulled from the Tovuti courseProgresses endpoint, linked by teamId, courseId, userId). The AssigmentsProgress table hits the request limit as it grows every time someone starts, takes, or completes a course. Requirements: Confident practical experience with Power Query (M language) and incremental data refresh patterns in Power BI Experience with REST APIs (pagination, date filters, request limits, retry/backoff handling) Ability to read OpenAPI/schema documentation Clear communication in English Outcome: A working, tested Power Query fix integrated into the existing report, with a brief written explanation of the changes. Budget: Fixed price for this task (amount to be discussed based on the proposal)
It is necessary to quickly compile a database of contacts for cosmetologists and cosmetic clinics. Requirements for the result: Format: Excel or Google Sheets. Phone numbers must be in international format, as continuous digits WITHOUT plus signs, spaces, or hyphens (for example: 380**********). Structure: Column A — Clinic name / Name, Column B — Phone number. Volume: at least 200 fresh contacts, without duplicates and empty rows.