Google Sheets Expert for Automated Calculations and Data Logging
4 hours ago
Job description
I am looking for a Google Sheets expert to build a 4-week specialized strength and conditioning tracker for a track cyclist.
The sheet needs to handle automated percentage-based calculations and data logging.Key Requirements:
Master Control Sheet:
A dashboard where I can input "Baseline 1RMs" (e.g., Squat, Clean, Deadlift) and a "Weekly Multiplier."
Dynamic Programming:
The training logs must automatically calculate weights based on the Master Control values, rounded to the nearest 2.5kg.
VBT Integration:
A column for "Actual Velocity" (Enode sensor data) with conditional formatting (e.g., cells turn Green if greater than 0.8m/s, Red if less than0.35m/s).
User Interface:Must be mobile-friendly for the athlete to use on the gym floor. Freeze headers and include clickable links to Catalyst Athletics exercise videos (links provided).
Logic: 4-week repeating block with a Deload week logic (50% reduction).
Skills Required:
Advanced Google Sheets formulas (MROUND, VLOOKUP/INDEX MATCH, Conditional Formatting).
Experience with fitness or performance tracking is a plus.
Clean, intuitive UI/UX design.
Contract duration of 1 to 3 months. with 30 hours per week.
Mandatory skills:
Google Sheets, Microsoft Excel, Visual Basic for Applications, Python
Similar jobs
I am seeking an experienced data analyst to process and analyze raw data logs from my iPhone, desktop, and laptop. · ...
1 month ago
LabVIEW Data Acquisition and Logging Program Development
Only for registered members
We are seeking an experienced LabVIEW developer to create a data acquisition and logging program. · ...
1 month ago
Data Entry from Handwritten Log Entries to Excel
Only for registered members
Job summary · We are looking for a detail-oriented freelancer to assist with data entry from handwritten log entries that have been scanned into PDF format.Your task will be to accurately input the data into a pre-formatted Excel sheet. · ...
1 month ago
Execute Python Script to retrieve data and log onto spreadsheet
Only for registered members
I need a developer to implement an extractor for Companies House Advanced Company Search. · Pick up an existing thread/spec · Implement chunking using incorporated_from / incorporated_to date ranges · Paginate with start_index · Merge results into a CSV file · ...
2 weeks ago
Need VA for assistance with making sales listings, sm posting, spreadsheet creation, data logging
Only for registered members
We are an online and physical retailer startup that will require for you to edit photos, do some light product research, post items for sale online, track everything in a spreadsheet and close out sales. · ...
1 week ago
Remote Data Entry Administrative Assistant Customer Service
beBee Professionals
Congratulations! We’re pleased to inform you that you’ve been shortlisted for the position of Remote Data Entry Administrative Assistant Customer Service at Trio Home Company. · Your application caught the attention of our hiring team, and we’re excited to invite you to a formal ...
1 month ago
Nous recherchons un Ingãnieur DevOps Sèni pour intervenir sur des plateformes cloud modernes orientées Data & AI, · pour concevoir · , opérer et gérer des infrastructures cloud sécurisés. · Expertise hands-on Google Cloud Platform (GCP) · Terraform (Infrastructure as Code) · ...
4 weeks ago
Nous recherchons un Senior DevOps Engineer pour intervenir sur des plateformes cloud modernes orientées Data & AI. · ...
4 weeks ago
We are seeking an experienced GCP Cloud Architect with strong expertise in designing and implementing scalable data solutions on Google Cloud Platform. · Develop and implement cloud-native architectures on GCP for data processing and analytics. · ...
1 month ago
Hello, · I have been using a visitor session replay app (sort of like a heatmap app) on Shopify for seeing what users are doing on the page. · I need to have some insight into what the top vehicle searches are. · ...
1 month ago
We are seeking an experienced GCP Cloud Architect with strong expertise in designing and implementing scalable data solutions on Google Cloud Platform. · Develop and implement cloud-native architectures on GCP for data processing and analytics. · Design ETL workflows leveraging S ...
1 month ago
We are looking for GCP Cloud Architect with strong expertise in designing and implementing scalable data solutions on Google Cloud Platform (GCP). We are seeking an experienced GCP Cloud Architect with strong expertise in designing and implementing scalable data solutions on Goog ...
1 month ago
Position Name – GCP Architect · Type of hiring – Fulltime/Subcon · Location – Toronto, ON (4 Days onsite/ Week) · Job Description: · We are seeking an experienced GCP Cloud Architect with strong expertise in designing and implementing scalable data solutions on Google Cloud Platf ...
15 hours ago
Seeking professional to create me scripts to scrape product info off 6 websites. Must be able to run these scripts from Windows computer at demand. · ...
1 month ago
Nous recherchons un(e) Ingénieur(e) Observabilité expérimenté(e) pour rejoindre notre équipe Observabilité. · L'objectif principal est la conception, la modernisation et le déploiement de plateformes d'observabilité dans des environnements cloud publics et privés. · Concevoir int ...
2 weeks ago
Microsoft Sentinel Expert Needed – Import Custom Webhook Data into Sentinel
Only for registered members
We are looking for an experienced Microsoft Sentinel / Azure Security engineer to help us ingest custom data from a webhook into Microsoft Sentinel. This is a focused, technical task and requires hands-on experience with modern Sentinel ingestion methods. · ...
3 weeks ago
We have a working Python script for scraping YouTube metadata from public pages. We need you to transform this into a production-ready, automated weekly pipeline.Your task is to create a symmetric function that runs on a schedule, manages state, handles errors and integrates with ...
2 weeks ago
Tool Development for Downloading GoHighLevel Audit Logs
Only for registered members
We are on the lookout for a skilled developer to design a tool that streamlines the process of downloading audit logs from the GoHighLevel platform, converting them into CSV or Excel formats. · Create automated solutions to enhance our report generation workflow. · ...
4 weeks ago
We are hiring a structured and detail-oriented Operations Data Administrator to manage daily operational and financial logging for a UK-based removals & logistics company. · This is a long-term remote position for someone accurate, disciplined, and process-driven. · Core Responsi ...
1 day ago
We need a backend developer for a 1-week sprint to build user authentication and multi-tenant data access for our energy management platform. · All device data exists - we need users to log in and see their own data. · Users log in, see only their building's energy data from mete ...
1 month ago