Debugging Projects

Fix Formula Errors + Broken Links in Excel Budget Dashboard

I already have a complete Annual & Monthly Budget Dashboard in Excel. I do NOT need a new dashboard — I only need a freelancer to: - Fix formula errors - Repair broken links between sheets - Make sure calculations update correctly - Ensure all dashboard sections pull the right data The file includes sheets such as: • Setup • Transactions • Monthly Dashboard • Annual Dashboard • Comparative Dashboard Everything is already built — just needs fixing and cleanup. Requirements: • Strong Excel formula and debugging skills • Experience fixing broken dashboards • Ability to deliver clean and error free results • Good communication

opportunity

Azure Databricks - Set up CICD environment in Azure Databricks

I Need an experienced Databricks professional to set up Databricks environment , CICD pipeline with Azure repos and explain the process clearly. A Simple task to copy a simple csv file store, it in Raw layer, transform to bronze and gold layer. enable Bundling and deployment to 2 other environments. Also explain on Debugging process Will be an easy task for experienced freelancers.

GA4 UTM Attribution & WordPress Tracking Debugging

Overview We are restarting a direct mail campaign using QR codes and require clean, reliable Google Analytics 4 (GA4) attribution. Each QR code links to URLs containing UTM parameters, for example: https://justera.co.uk/?utm_source=direct_mail&utm_medium=qr&utm_campaign=test_campaign&utm_content=test_letter We need a developer to audit, diagnose, and ensure correct UTM tracking and GA4 attribution. Current Environment • WordPress (IONOS Managed WordPress hosting) • Site Kit by Google (GA4 connected) • GA4 Measurement ID active • Server-side caching previously active (IONOS Performance Level) • No Cloudflare • No MonsterInsights • No Complianz (currently deactivated) • Previously had a plugin stripping UTMs via JavaScript (now removed) Problems We Experienced 1. UTMs were previously being stripped from the URL via a JS file: /wp-content/plugins/wp-stats-manager/js/wsm_new.js (plugin now removed and cache flushed) 2. After resolving URL stripping: • GA4 does not consistently attribute session source/medium correctly. • In some tests, no g/collect requests fire. • Sessions sometimes appear as (direct) / (none) despite valid UTMs. • Realtime reporting is inconsistent. 3. Behaviour has varied between devices (likely due to server-side caching). Infrastructure has been partially cleaned up, but we need a full technical audit and clean implementation. What We Need Done 1. GA4 Audit & Correction • Confirm only one GA implementation is loading. • Confirm page_view is firing correctly. • Confirm g/collect requests include: • campaign source • campaign medium • campaign name • Ensure UTMs are captured on first page load (new session). • Confirm no duplicate tags or container conflicts. We are open to: • Removing Site Kit • Implementing clean manual GA4 (gtag.js) • Or implementing via GTM if preferable 2. JavaScript Review • Confirm no scripts are: • Calling history.replaceState • Cleaning query strings • Removing UTM parameters • Confirm no theme-level or plugin-level URL manipulation. 3. Caching Review • Confirm no server-side full page caching is serving stale HTML. • Confirm no service worker is registered. • Ensure consistent behaviour across devices/IPs. 4. Final Verification Provide proof that: • Fresh private session with UTM URL • Correct attribution appears in GA4: • Session source • Session medium • Session campaign • Realtime and Acquisition reports reflect correct traffic source. End Goal We need fully reliable attribution for: QR Code → Landing Page → Apply Click This is critical for measuring direct mail ROI. Requirements • Strong GA4 debugging experience • WordPress experience • Familiarity with IONOS hosting • Comfortable using DevTools and network inspection • Ability to explain findings clearly Deliverables • Clean, working GA4 attribution • Clear explanation of what was wrong • Confirmation that infrastructure is stable • Recommendation for simplified tracking stack (if needed) If you have experience debugging complex GA4 attribution and WordPress caching issues, please respond outlining: • Similar projects you’ve resolved • Your approach to diagnosing this • Estimated time required

Conversion

I require an expert to diagnose and resolve a Google Ads conversion tracking issue. Current conversions are inconsistent or not recording properly. Tasks include auditing tag implementation, verifying Google Ads and Analytics linkage, troubleshooting GTM or global site tag deployment, checking event parameters and conversion actions, and recommending fixes to restore accurate reporting. Experience with Google Ads conversion tracking, GTM, Analytics 4/UA, and debugging tools is essential. Provide clear remediation steps and confirm successful resolution.

IOS AR Engineer

The work is technical and precise, we render directly onto a tracked face mesh at 60fps and every pixel matters. You need to have shipped something real with ARKit. Not a demo. A product where face tracking drove rendering decisions at the vertex level. The work involves: Face mesh geometry and UV mapping Real-time texture generation from geometric contours Sub-pixel optical edge detection against live camera frames Coordinate space transformations between 3D, image, and texture space Threading discipline across ARKit, Vision, CoreGraphics and SceneKit You are the right person if: You have debugged a rendering artifact by reasoning about coordinate spaces, not by guessing blend modes You know what happens to Vision landmark coordinates when you pass the wrong orientation to VNImageRequestHandler You can explain why the same ARKit vertex produces different UV values depending on head angle Working with raw pixel buffers feels normal to you You are not the right person if: Your ARKit experience stops at placing virtual objects in a room You have never read BGRA pixel values directly from a CVPixelBuffer Catmull-Rom splines and even-odd fill rules are unfamiliar

opportunity

Ongoing/ad hoc maintenance issues of a hybrid app

We seek a skilled professional to join our startup as an extended team member, addressing ongoing and ad hoc maintenance issues for our hybrid app. The ideal candidate will manage maintenance tasks and oversee future development of our WebView React application. We aim to establish a monthly retainer for consistent maintenance and debugging support, complemented by additional project-based work for new feature development. If you possess a strong background in app maintenance and development, we invite you to submit your proposal and become an integral part of our growing team.

I need SENIOR ANDROID SYSTEMS ENGINEER(Virtualization App)

Senior Android Systems Engineer (Virtualization) — Paid, Task-Based We’re looking for a senior Android systems engineer for a paid, task-based engagement on an Android virtualization / sandboxing project. This is not a standard Android app role. Work involves Android framework behavior, IPC, and multi-version compatibility. Required Android experience beyond the SDK Familiarity with Android framework internals (AOSP) Understanding of Binder IPC & system services Working knowledge of JNI / C++ for debugging Experience across multiple Android versions (8+) Experience with virtualization / sandboxing Plus Familiarity with engines like BCore / VirtualApp (or similar) Details Paid Not a full-time role

STAR-CCM+ + TAITherm Cabin HVAC Thermal Comfort Debug/Fix

Automotive Cabin Heating Thermal Comfort Simulation Fix (STAR-CCM+ .sim + TAITherm Human Thermal / Berkeley Comfort) We are looking for an engineer who can run and troubleshoot an automotive cabin heating thermal comfort simulation using: - Simcenter STAR-CCM+ (.sim) for cabin airflow/temperature fields - TAITherm Human Thermal / HTE + Berkeley Comfort for occupant comfort outputs Task goal (what you need to deliver) We have a simplified cabin model. Under a cold ambient heating scenario, the current results are abnormal: occupant thermal sensation/comfort improves briefly and then becomes colder again (e.g., TS drops toward -1 and continues decreasing). We need you to diagnose the root cause and correct the model setup/coupling/mapping so the outputs are physically reasonable. Target requirements (high level): - Transient duration: 1800 s (30 min) - Monitoring temperatures: foot/foot-vent zone around ~35°C, head point around ~20°C (exact monitor definitions will be shared privately) - Comfort trend: overall thermal sensation & comfort must be normal/stable (after heating ramps up, it should not “get colder again”) What we expect from you - Identify why comfort trend becomes colder (typical causes include MRT/radiation boundary, incorrect field-to-human mapping of Ta/Tr/velocity/RH, initialization/restart issues, boundary leakage on cut surfaces, etc.) - Provide corrected settings + clear explanation of what was wrong and what you changed - Provide plots/outputs for monitoring temperatures + comfort metrics (TS/PMV/PPD or equivalent) Required experience (please do NOT apply if you don’t have this) - Hands-on experience with STAR-CCM+ transient cabin HVAC/thermal - Hands-on experience with TAITherm Human Thermal / Berkeley Comfort (not only CFD) - Ability to actually run the case (access to software/licenses or a workable setup) Confidentiality Due to confidentiality, we will share the detailed model files and full requirement document after you confirm capability. Please answer these in your proposal: 1) Have you used TAITherm Human Thermal / HTE + Berkeley Comfort in real projects? Share 1–2 lines of what you did (no confidential details). 2) Do you have access to STAR-CCM+ and TAITherm comfort/human modules to run the model? (Yes/No) 3) List your top 3 likely causes when cabin heating comfort “gets colder again” (keywords are fine: MRT/radiation, mapping, restart/initialization, boundary condition, cut-surface leakage, etc.) 4) What is your estimated time (days) to deliver corrected results + explanation? 5）Tell me how much you would charge for my task. —————————— Keywords: STAR-CCM+ .sim, Simcenter, cabin HVAC heating, automotive thermal management, TAITherm 2020, ThermAnalytics, Human Thermal Model, Human Modeling Extension (HTE), Berkeley Comfort Model, thermal sensation (TS), PMV, PPD, MRT (mean radiant temperature), radiation boundary, coupling/mapping, transient 1800s, monitoring points, HDF5 .tdf, .vfs .slf .tlf - Simcenter STAR-CCM+ (Transient / CHT / Radiation) - TAITherm / RadTherm (Human Thermal / HTE) - Thermal Comfort / Berkeley Comfort / PMV-PPD - Automotive HVAC / Cabin Thermal Management - CFD Post-processing / Data analysis (HDF5)

I need SENIOR ANDROID SYSTEMS ENGINEER(Virtualization App)

We are seeking a highly skilled Senior Android Systems Engineer to engage in a paid, task-based project focused on Android virtualization and sandboxing. This role transcends standard Android app development, emphasizing expertise in Android framework behavior, inter-process communication (IPC), and multi-version compatibility. Candidates must possess extensive experience beyond the SDK, with a deep understanding of AOSP internals, Binder IPC, and system services. Proficiency in JNI and C++ for debugging is essential, alongside experience with Android versions 8 and above. Familiarity with virtualization engines like BCore or VirtualApp is a plus. Interested candidates should provide a brief overview of their relevant system-level Android experience.

opportunity

Extract blood test data from PDF documents that have been OCR'd

The objective is to build a structured blood test database that allows pathology results to be viewed, edited, filtered, and exported to Excel via a web-based HTML interface. The system stores results in a clean, standardised format so trends can be analysed accurately over time. Using AI-assisted OCR, I have built a local Python extraction pipeline that converts PDF pathology reports into machine-readable text and inserts structured data into a SQLite database. The majority of blood tests extract correctly, including canonical test name, result value, unit, and reference range. However, I have reached a specific technical issue with three markers: • CRP (C-reactive protein) • ESR • GLU (Glucose) The OCR output clearly contains the correct lines, and debug logs confirm they are processed. Yet no rows are inserted for these markers. The failure appears to occur between canonical matching, numeric extraction, or validation logic. Current System Architecture The system runs locally and consists of: • extraction_core_2.py (main engine) • Supporting modules for OCR preprocessing, lab dictionary building, regex matching, and validation • SQLite backend • Schema-driven canonical lab dictionary • Controlled fuzzy fallback logic • HTML viewer for results display and Excel export Pipeline flow: Convert PDF to image (pdf2image) Preprocess Run Tesseract OCR Clean and normalise text Match against canonical lab dictionary Extract: canonical test name numeric result unit reference range Validate Insert into SQLite The engine is deterministic and rule-based. The Specific Problem Example OCR line: CRP H 5.2 mg/L 0-5 OCR text is correct. NUMBER_PATTERN matches. The canonical dictionary contains the test. Yet: Inserted 0 rows from 0126251OrderReport_23B00006604_CRP.pdf Likely failure points include: • Canonical containment match failing due to normalisation • Flag tokens (“H”, “L”) interfering with numeric capture • Numeric extraction anchored incorrectly • Validation rejecting due to strict range formatting • Unit pattern mismatch (e.g. mmol/L) • Dictionary indexing issue • Match overridden by another lab name • Guard conditions too strict If validation fails, the row is rejected silently. All other panels extract correctly. The issue appears isolated. What Is Required This is not a rebuild. We do not want: • Re-architecture • Experimental AI guessing logic • Large-scale changes • Expanded fuzzy matching We need: 1. Precise Diagnosis Identify exactly where CRP, ESR, and GLU are failing insertion and which rule is causing rejection. 2. Minimal Safe Fix Implement a targeted correction that: • Adjusts canonical matching if required • Anchors numeric extraction correctly • Allows flag tokens without blocking capture • Relaxes only necessary validation checks • Preserves deterministic behaviour 3. Zero Regression • No impact to currently working panels • No performance degradation • No uncontrolled fuzzy expansion 4. Modular Implementation If appropriate: • Implement as small isolated module or • Cleanly adjust matching block The existing architecture should remain intact. Constraints The system is designed to be: • Deterministic • Schema-driven • Reproducible • Forensic-grade We cannot introduce probabilistic or unpredictable behaviour. Longer-Term Goal After stabilising extraction: • Migrate to web deployment • Enable structured uploads • Add trend analysis • Later incorporate AI-assisted interpretation Immediate priority: Stabilise deterministic extraction for CRP, ESR, and GLU without breaking the existing engine. Materials Provided Uploaded: • Full extraction_core_2.py (text format) • Screenshot of HTML viewer • Sample PDF files • Export showing required output Additional materials available on request: • Sample OCR blocks • Canonical dictionary entries • Regex patterns • Validation logic • Database schema • Debug logs This is a focused debugging and refinement request. I have spent many hours attempting to isolate the issue and now require an experienced developer to identify the blocking condition and implement a practical fix. I have been advised this should take 1–2 hours for a senior developer. Looking for a swift turnaround.

Python Developer / Browser Automation / Playwright

We operate a Python-based automation system that interfaces with a platform. The system is stable and actively in use, but requires ongoing maintenance, occasional bug fixes, and new feature development as the platform evolves. We're looking for a reliable freelance developer to join us on a flexible, ongoing basis and take ownership of the automation layer. Tech Stack – Python – Playwright (async, browserless) – FastAPI – MongoDB – Docker What You'll Work On – Writing, updating, and refining browser automation scripts that interact with third-party web applications – Handling session management, cookie persistence, and authentication flows to keep automations running reliably – Building and maintaining API integrations between our system and external services – Diagnosing and resolving issues when target platforms change their UI or behavior – Proposing and implementing improvements to make the system more robust, faster, or easier to maintain – Working within a Dockerized environment and following existing code conventions Ideal Candidate – Strong hands-on experience with Playwright in Python, particularly using the async API – Comfortable working with headless browsers, managing browser contexts, and debugging flaky or timing-sensitive automation – Familiar with FastAPI and RESTful API design – Experience with MongoDB or similar document-based databases – Able to read, understand, and contribute to an existing codebase without extensive onboarding – Self-directed and comfortable working independently with minimal supervision – Communicative, responsive, and dependable — we value people who flag issues early and keep things moving

Android App Developer – Login & Payment System Debugging.

We are in search of a proficient Android app developer to diagnose and rectify issues related to our application's login system, payment processing, and data synchronization. The ideal candidate will possess substantial expertise in Android development and demonstrate a strong aptitude for troubleshooting intricate authentication and transaction workflows. Key responsibilities include identifying and resolving errors in user authentication, optimizing in-app payment processes, ensuring secure user experiences, and addressing synchronization challenges in Calendar and Kanban views. The developer will also validate fixes for performance and stability, document all enhancements, and support final deployment on the Google Play platform and our website. Required skills encompass extensive experience in Android development (Kotlin/Java), familiarity with authentication methods such as OAuth and Firebase, and hands-on knowledge of payment gateways like Google Play Billing and Stripe. Exceptional debugging and problem-solving abilities are essential. This project aims to deliver a fully operational login system, seamless payment processing, synchronized views, and smooth deployment across platforms.

urgent

Hub Dynamic PD

We are developing a premium smart power hub (USB-C PD, multi-port, real-time power monitoring) and are looking for an embedded firmware engineer to lead the MCU firmware layer. The electronic hardware and PCB are already designed. This role focuses on firmware architecture, implementation, and testing. This is not a beginner role. We are looking for someone comfortable working close to hardware and making pragmatic engineering decisions. Responsibilities: - Develop MCU firmware for USB-C PD power management - Implement real-time power monitoring and reporting - Interface with PD controllers, current sensors, and displays (OLED/LCD) - Define safe fallback states and edge-case handling - Collaborate with existing hardware engineer - Prepare firmware for EVT/DVT prototypes Requirements: - Strong experience in embedded C / C++ - MCU firmware (STM32, ESP32, or similar) - USB-C Power Delivery concepts - I2C / SPI / UART - Debugging on real hardware Nice to have: - Power electronics familiarity - Display/UI firmware - EVT → DVT → PVT experience - Consumer electronics background Engagement: - Contract, milestone-based - Remote - Compensation open and based on scope and experience

Technical Interview Coach + English Speaking Practice (SWE)

I’m an experienced software engineer targeting the UK/EU job market. I’m getting rejected after initial recruiter intro calls, mainly because my spoken English is not smooth and my answers may not be structured clearly under time pressure. I’m looking for a technical professional (ideally 1+ years experience as a software engineer, tech lead, or technical recruiter with engineering background) who can help me improve my performance in these intro calls. What I need help with: Run mock recruiter intro calls (30–45 minutes) and give direct feedback Improve my 60–90 second “Tell me about yourself” to be clear and confident Help me structure answers for common screening questions (role fit, strengths/weaknesses, project impact, conflict, availability, salary expectations) Polish my English phrasing so it sounds natural and concise Optional: create a short “answer bank” I can practice (bullet notes + sample responses) Requirements: Strong spoken English 3–5+ years technical background (software engineering or highly technical recruiting) Comfortable discussing real engineering topics at a high level (APIs, databases, cloud, debugging, system design basics) Please include: - A short note about your technical background - Your rate per 1 interview with me I prefer to start with a paid 30-minute trial mock call, then continue weekly if it’s a good fit. Cheers

CRM Automation Specialist

I am seeking a CRM Automation Specialist to assist in the reconstruction and optimisation of email workflows and automations connecting Membervault, Zapier, Stripe, and MailerLite Classic for effective customer account management. The objective is to finish a partially created system that seamlessly automates membership cancellations, pauses, and downgrades while ensuring member status synchronisation and efficient billing adjustments. Additionally, I aim to enhance email automations within MailerLite to elevate member communications. The ideal candidate possesses expertise in API integrations, workflow automation, and email marketing, particularly with MailerLite Classic, and has experience in debugging automations and managing subscription billing. Please share relevant project examples in your application. The ultimate goal is to minimise manual tasks through comprehensive automation of membership and email workflows.