Analysis Projects

Create report about Blockchain analysis / forensic investigation

Need someone to write a professional report about a hack from a few years ago in 2022 Need it to look professional tracing information If you know how to use tools like chanalysis and have access to this that would be good. It only involves a few addresses to trace on the terra blockchain / UST currency

Membership Growth

We seek an experienced growth strategist to research, advise and execute initiatives to expand membership for our football platform. Deliverables include market and competitor analysis, target-audience segmentation, user-acquisition channels, conversion-rate optimization, retention and referral programs, and measurable growth experiments. Provide a prioritized roadmap, implementation support, and regular performance reports to drive sustainable membership acquisition and engagement.

opportunity

Short-form video editor for a futures-trading analysis brand

We're Beneath The Book (@beneaththebook) a futures-trading analysis brand covering ES & NQ through order-flow and structural levels. We publish daily educational market analysis. Our voice is honest and no-hype: "levels, not predictions." We're not a get-rich-quick signals account, and our content reflects that. What we need: A short-form video editor to turn our daily raw material (chart screenshots, level cards, screen recordings, and a script/voiceover we provide) into engaging 20–40 second vertical videos for TikTok, Instagram Reels, and X. The work, per video: A scroll-stopping hook in the first 1–2 seconds (on-screen text) Motion that holds attention: draw-on annotations, zoom-into-the-level, marker drops timed to the narration Burned-in captions (most viewers watch muted) Clean branded end-card with handle and a soft call-to-action Platform-specific exports (9:16 for TikTok and Reels, plus a feed-friendly cut) We provide the script, voiceover, and the levels/branding you handle the edit, motion, captions, and exports. The trading voice stays with us. You're a fit if you: Edit short-form for retention, not just polish (CapCut/Premiere) Can make data or charts engaging please show examples where you made something analytical or "boring" hold attention Can deliver fast turnaround (ideally same-day, since this is daily content) Understand TikTok/Reels hook-and-retention mechanics To apply: Share a portfolio, ideally with finance, data, or explainer-style work Tell us how you'd hook a viewer in the first second of a trading video Note your turnaround time and per-video rate First step: a paid test piece one card + one script → one finished video before any ongoing arrangement. Note: This is educational market-analysis content. No performance or profit claims feature in the work.

SLR Screening Assistant Needed (Media/Linguistics PhD)

I'm a PhD candidate conducting a systematic literature review as part of my doctoral thesis, in Critical Discourse Analysis of English-language online news reporting. I'm looking for a freelancer to support the mechanical/administrative side of the SLR process. This is NOT a request to write or synthesise the literature review. All inclusion/exclusion decisions, quality appraisal, and synthesis are done by me. Tasks include: Running literature searches across specified databases (Scopus, Web of Science, Google Scholar and Elicit) using search strings I provide Exporting and organising search results into a shared spreadsheet Logging hit counts per database/string for PRISMA reporting Extracting basic bibliographic and methodological details from articles into a template I provide (author, year, method, findings summary) Applying my stated inclusion/exclusion criteria to flag candidates for my review (final decisions remain mine) Ideal candidate: Experience with systematic reviews or PRISMA methodology preferred Familiarity with Critical Discourse Analysis or discourse-based methods is a plus but not essential Comfortable reading academic abstracts in media/communication studies or applied linguistics Comfortable working from detailed instructions and templates Strong attention to detail and organisation Background in social sciences, media studies, or linguistics welcome but not required What I will provide: Search strings and database list Inclusion/exclusion criteria Quality appraisal template Data extraction template Timeline: 3–4 weeks from start date, with a brief check-in at the halfway point.

opportunity

Hospitality analyst — serviced-apartment feasibility & valuation

I have been commisdioned developer-sponsor of a consented, ready-to-build serviced-apartment resort in a UK island/coastal leisure market. An operating model and investor memorandum already exist — I need an experienced hospitality real-estate analyst to independently validate and deepen the numbers ahead of partner due diligence, and ideally put their name to the analysis. Full detail and data room shared under NDA only. **Scope** (hourly, or as fixed deliverables): - STR/CoStar competitive-set and achieved-performance benchmarking (RevPAR/ADR/occupancy) - Penetration / fair-share analysis vs the competitive set - USALI departmental P&L — fresh build or stress-test of my existing model - 10-year DCF to stabilisation, giving a DCF value alongside the existing cap-rate value - A short, citable written commentary for inclusion in the memorandum **You:** - 3+ years hospitality valuation/consulting (HVS, Savills, Colliers, CBRE Hotels, JLL or similar) - STR/CoStar access or a clear route to a custom market pull - Strong USALI and hotel/serviced-apartment DCF modelling - MRICS a plus — independent, named authorship is valued - UK experience essential; Scottish/leisure-resort exposure ideal **Engagement:** Remote, hourly. ~15–30 hours to start, scope to extend. **NDA required before any project detail is shared.** Please send a redacted sample of comparable work and your hourly rate

Mechanical design engineer

We are seeking a mechanical design engineer to develop and improve a mechanical lift system used for safe and reliable lifting and positioning. The role includes concept development, 3D CAD modeling, basic structural analysis, and creation of drawings and documentation for manufacturing. Ideal candidates have experience designing mechanical assemblies, linkages, and structural components, are comfortable working from concept to prototype, and can collaborate with engineering, manufacturing, and end‑users to refine the design.

opportunity

Shopify SEO Specialist Needed for UK E-commerce Store

We are looking for an experienced Shopify SEO specialist to improve organic traffic, keyword rankings and sales for a UK e-commerce business. This will begin as a paid trial project. The initial work should include: - Technical SEO audit - UK keyword research focused on buyer-intent keywords - Competitor SEO analysis - Optimisation of 5 priority product or collection pages - Improvement of titles, meta descriptions, headings, image alt text and internal links - Identification of indexing, crawling, site speed and structured data issues - A clear 30-day SEO action plan Requirements: - Proven Shopify SEO experience - Experience with UK e-commerce businesses - Strong knowledge of technical and on-page SEO - No spam backlinks, PBNs or automated link-building methods - Clear written communication Please include: 1. Two relevant Shopify SEO examples 2. The main issues you would check first 3. The SEO tools you use 4. Your fixed price and delivery time 5. What improvements can realistically be expected This is a trial project. Ongoing monthly work may be available if the results and quality are good.

Experienced Person Required For Sales & New Business

Seeking an experienced sales and new business professional to drive revenue growth and expand market presence. Responsibilities include identifying prospects, cultivating relationships, developing and executing strategic sales plans, negotiating contracts, and closing deals. Candidate must demonstrate strong communication, networking, and presentation skills, a proven track record in B2B sales, and the ability to work independently to meet ambitious targets. Prior experience in lead generation, CRM management, and market analysis is required.

Project Manager for London-based Client

We are looking for a skilled Project Manager to join our team to manage a key client based in London. Our agency, Bandwidth Ninth, specialises in development solutions (https://www.bandwidth-ninth.com/). In this role, you will be instrumental in guiding the client through product evaluation and development processes. Key responsibilities: • Manage the end-to-end project lifecycle, ensuring deliverables meet client expectations. • Conduct thorough analysis and provide critical feedback on client product and user experience. • Coordinate with development teams to ensure timely and on-budget delivery of projects. • Facilitate in-person meetings and ongoing communication with clients in London. • Identify and mitigate project risks, adapting to changing requirements. Role requirements: • Proven experience in project management, preferably within the design or software development sectors. • Strong analytical skills with the ability to critique product design and user experience. • Excellent communication and stakeholder management skills. • Ability to travel within London for in-person client meetings. • Flexibility and adaptability in a fast-paced environment.

Paid Search Specialist Google Ads

We are a digital marketing company looking to outsource the setup and management of paid ads accounts This is a hands-on specialist role for someone passionate about campaign optimisation, creative testing, performance analysis, and scaling profitable acquisition through Google Ads. WHAT WE’RE LOOKING FOR Strong experience across Search Campaigns, Performance Max and App Campaigns (UAC) Proven track record improving acquisition performance and campaign efficiency at scale Strong understanding of paid search optimisation, bidding strategies and auction dynamics Excellent analytical skills with strong attention to detail Experience with Google Ads, GA4, Google Tag Manager and Looker Studio Strong copywriting instincts and a passion for performance-driven creative Comfortable working across both the analytical and creative sides of paid search Highly organised with the ability to manage multiple priorities across fast-moving campaigns Clear communicator who collaborates effectively across cross-functional teams Interest in leveraging AI tools and automation platforms to improve marketing workflows and campaign performance

opportunity

React, Node Postgress Developer

We have a software project that is almost complete, but unfortunately the original developer has become unresponsive, leaving us unable to launch. The project is based around the board game **Backgammon**, which is also played online. Serious players analyse their matches using software called **Extreme Gammon (XG)**. Currently, every move from a match must be entered manually into XG, which is extremely time-consuming. Our platform, 'BackgammonAnalyst.com', aims to automate this process. Users upload a completed match, the software reads and reconstructs the game, and generates an output that can be imported into XG for analysis, dramatically reducing the time and effort required. You can view the current website at **BackgammonAnalyst.com**. From our assessment, there are relatively few changes remaining on the desktop version, with a little more work required on the mobile web version. However, we have not yet seen the software fully working, either via a live demonstration or a comprehensive video. We have our own server infrastructure and a dedicated server administrator. The first task would be to assess whether all source code has been deployed correctly, review the current state of the project, and thoroughly test the application to identify any remaining issues before completing the outstanding work. The product was scheduled to launch this coming Friday/Saturday. We appreciate this is ambitious, but if the remaining work is genuinely limited, there may still be an opportunity to meet, or come very close to, that target. If this is a project you would be interested in reviewing, we would be happy to provide further information, access to the codebase, and discuss the next steps. You can view the amends: https://docs.google.com/document/d/1eMHSHC_IXyfQxUNWQkAYAjGRW8hwMIRKh--Zwk37aPI/edit?tab=t.0 The project fee can be a place holding initially.

Article writing

I am looking for an experienced journalist or feature writer to produce a well researched, balanced, and engaging magazine article (1,500–2,000 words) on the controversy surrounding former Meta executive Sarah Wynn-Williams' memoir, Careless People, and the legal actions taken by Meta to limit its promotion and dissemination. The article should go beyond reporting the events and examine the broader implications for freedom of speech, whistleblower protections, corporate accountability, and the public's right to information. It should explore whether attempts by powerful corporations to restrict publications create a chilling effect on free expression, while also presenting Meta's justification for protecting confidential information and contractual obligations. The piece should include: - Background on Sarah Wynn-Williams and her memoir, Careless People. - An overview of Meta's legal response and the reasons behind it. - An analysis of what this case means for freedom of speech and corporate transparency. - Discussion of the wider implications for whistleblowers, investigative journalism, and public trust. - Relevant comparisons with similar cases where corporations attempted to restrict books or public disclosures. - A balanced conclusion that considers both corporate rights and the importance of open public discourse. The article should be original, thoroughly researched, factually accurate, and supported by credible sources. The writing style should be analytical, objective, and suitable for publication in an international current affairs magazine. Please avoid AI generated clichés and unsupported opinions, and ensure the article presents multiple perspectives fairly. Deadline:5 days

opportunity

Google Ads Specialist Needed for UK Shopify E-commerce Store

We are looking for an experienced Google Ads specialist to improve the performance and sales of a UK Shopify e-commerce store. This will begin as a paid trial project. The initial work should include: - Full Google Ads account audit - Review of Shopping, Performance Max and Search campaigns - Google Merchant Center and product feed review - Conversion tracking and GA4 check - Campaign structure, bidding and budget analysis - Search term and negative keyword review - Identification of wasted ad spend - Clear recommendations for improving ROAS and conversions - A practical 30-day optimisation plan Requirements: - Proven experience with Shopify e-commerce Google Ads - Experience managing UK Shopping and Performance Max campaigns - Strong knowledge of Google Merchant Center - Able to analyse conversion tracking and campaign data - No automated or low-quality campaign setup - Communication must be through written messages only; no calls are required Please include: 1. Two relevant e-commerce Google Ads examples 2. Previous results, including ROAS or conversion improvements 3. The main issues you would check first 4. The tools you use 5. Your fixed price and delivery time 6. What is included in your service This is a paid trial. Ongoing monthly Google Ads management may be available if the work is professional and effective.

Complete SaaS Web App UI/UX Design for an AI Startup

Complete UI/UX Design for an AI SaaS Platform We are looking for an experienced UI/UX designer to create a complete design for a modern AI-powered SaaS platform. The project covers the entire design process, from initial research and UX planning to high-fidelity interfaces, responsive layouts, and a production-ready design system. The objective is to design a scalable, intuitive, and visually engaging web application that helps teams manage projects, collaborate efficiently, automate workflows, and gain insights through AI-driven analytics. The final product should deliver a premium user experience while maintaining consistency, accessibility, and ease of development. The scope of work includes user research, competitor analysis, information architecture, user flows, wireframing, high-fidelity UI design for desktop and mobile, responsive layouts, reusable components, interactive prototyping, and a complete design system. The designer will also prepare all assets and documentation required for a seamless developer handoff. The final deliverables include more than 30 unique application screens, responsive desktop and mobile designs, a comprehensive design system with reusable components and variables, interactive prototypes, organized Figma files, and developer-ready assets. Project Duration: 8 Weeks Budget: $6,800–8,000 Required Skills: UI Design UX Design Figma SaaS Design Dashboard Design Responsive Web Design Mobile Design Design Systems Prototyping User Experience

Luxury Treatment Menu Design for High-End Aesthetic Clinic

I am looking for a talented graphic designer to create a premium treatment menu for my luxury aesthetics clinic, The Hurst Clinic. The overall feel should be understated, elegant and contemporary, similar to a luxury hotel or private medical clinic rather than a beauty salon. The design should feel timeless, spacious and expensive, with excellent typography and attention to detail. The menu will be used both digitally and in print within the clinic. Brand Style • Luxury • Minimal • Contemporary • Premium • Clean • Medical-led rather than beauty-led • Soft neutral colour palette (stone, taupe, warm white, with subtle gold accents) • Plenty of white space • Elegant typography • No busy layouts or stock beauty imagery What I Need Design a treatment menu that includes: • Front cover • Contents (if appropriate) • Individual treatment sections • Pricing presented clearly and professionally • Contact details • QR code placement for online booking • Back cover I would like the layout to be designed so I can easily edit treatment names and prices in the future. Treatments Include • Regenerative Aesthetics • Skin Consultation & Analysis • Microneedling • Polynucleotides • Exosomes • Radiofrequency Microneedling • Non-Surgical Facelift • Skin Tightening • HIFU • Dermalux LED • Hydrofacial • Chemical Peels • Thread Vein Removal • Cryotherapy • Hair Restoration • Body Contouring • Cellulite Reduction • Skin Rejuvenation Design Inspiration Think of brands such as: • Luxury private medical clinics • High-end cosmetic surgery practices The design should feel calm, refined and trustworthy rather than overly feminine or trend-driven. Deliverables • Print-ready PDF • Editable Adobe InDesign or Illustrator files (preferred) • Fonts supplied or commercially available • High-resolution files • Bleed included for professional printing Important Please include examples of previous luxury branding, brochures, magazines or treatment menus you have designed. I am looking for someone with a strong eye for typography, layout and premium branding rather than someone who specialises in bright beauty salon marketing. This project may lead to additional work including brochures, consultation guides, patient information leaflets and marketing materials for the clinic.

opportunity

AI-Powered Deal Origination & Opportunity Intelligence Platform

Overview Build an MVP AI-powered deal origination and opportunity intelligence platform to identify UK private company acquisition, succession, refinancing and distressed opportunities. The platform should analyse public company data, identify high-probability opportunities, enrich decision-maker information, generate AI reports and support targeted outreach. This is an MVP validation project requiring a fast, practical build with scalable foundations, not an enterprise solution. Core Objectives The platform must: • Collect company/director data • Analyse and score opportunities • Identify decision makers • Enrich contacts • Generate AI intelligence reports • Create outreach recommendations • Store opportunities in CRM • Maintain continuously updated pipelines Data Sources Required: • Companies House API • Gazette Insolvency Feed • Company websites • Public web research Preferred: • LinkedIn enrichment • Contact providers • News feeds • Business directories Future: Planning data, Land Registry/property ownership, email automation, workflows, dashboards, additional providers and AI agents. Functional Requirements 1. Company Intelligence Engine Retrieve, store and update: • Company name, number, address and SIC codes • Filing history, accounts and charges/mortgages • Directors and shareholders where available • Insolvency notices and Gazette events • Website and content summaries Maintain structured profiles for each company. 2. Opportunity Scoring Engine Core IP component. Must be configurable, AI-independent and adjustable without code changes. Required: • Weighted and rule-based scoring • Score explanations • Confidence ratings Scores: Acquisition: revenue, EBITDA/profitability, growth, recurring income, sector attractiveness, leverage. Succession: director age, ownership length, ownership concentration, management depth, succession indicators. Refinancing: lender charges, debt profile, leverage, property ownership, maturity indicators. Distress: insolvency notices, winding-up petitions, director resignations, overdue filings, negative trends. Probability of Sale: founder age, ownership duration, succession indicators, growth plateau, market conditions. Example: Sale Score: 86/100 Reasons: • Founder age estimated 67 • Sole shareholder • 24 years ownership • Stable profitability • No succession structure identified AI explains scores; scoring remains framework-driven. 3. Contact Enrichment Identify/store: • Founder, CEO, Managing Director, shareholders • Email, telephone, website, LinkedIn • Decision-maker information Supports future outreach and relationship development. 4. AI Intelligence Briefs Generate for high-ranking opportunities: Company Summary: Business description, financial overview, strengths. Opportunity Summary: Selection rationale, engagement potential, strategic rationale. Engagement Angle: Succession planning, growth capital, partnership, acquisition or refinancing 5. CRM MVP CRM must support: • Opportunity storage • Search/filtering • Notes and comments • Status tracking • Outreach tracking • Score history Workflow: Identified → Qualified → Contacted → Conversation Started → Active → Mandated → Closed 6. Outreach Intelligence Generate/store: • Personalised emails • LinkedIn messages • Telephone briefs No automated sending required AI Architecture Use model-agnostic architecture that remains operational if providers change Support: OpenAI, Anthropic Claude, Google Gemini, Meta Llama, DeepSeek, Qwen and future providers Admin controls: • Select AI provider • Change providers without code changes • Configure API keys • Add models Scoring must remain independent of AI Technology Backend: Python, FastAPI Database: PostgreSQL, Supabase Frontend: React, Next.js Infrastructure: AWS, Vercel, Supabase AI: Provider-agnostic APIs with future agent support Scalability Support future: • Multi-agent workflows • AI orchestration/MCP • Additional APIs • Email and workflow automation • Large-scale analysis • Advanced reporting Future integrations: CRM systems, enrichment providers, email systems, Land Registry, planning/property/commercial intelligence sources Dashboard Provide a simple user-friendly dashboard for non-technical sales/outreach users with navigation, opportunity views, filtering, pipeline management and AI insight access Deliverables • Working MVP • Source code • Deployment instructions • Technical documentation • Configurable scoring engine • CRM • Company intelligence engine • Contact enrichment • AI opportunity reports • Outreach generation • User administration • Large-scale UK company analysis capability Proposal Requirements Include: • Relevant examples • Architecture • Technology stack • Cost estimate • Delivery timeframe • Support options • MVP improvements Budget Open to proposals. Preference for developers experienced in AI intelligence platforms, CRM systems, API integrations and scalable MVP delivery rather than enterprise builds

Machine Learning Research Proposal Specialist

Overview We are looking for a Machine Learning Research Proposal Specialist to create a polished, professional research-style write-up for an ML evaluation task. The submission should propose a machine learning problem within the writer’s domain of expertise and must be directly related to machine learning. The final deliverable should be written in markdown format, follow the provided template exactly, and be no longer than 1–2 pages with a maximum of 8 paragraphs. Project Goal The goal of this project is to design a machine learning benchmark or problem that is complex enough to challenge a strong state-of-the-art LLM. The problem should not be a simple generic ML pipeline task. It should require deep domain expertise, advanced reasoning, and layered technical understanding that would be difficult for a general-purpose model to solve without specialized knowledge. Responsibilities The selected specialist will write a complete research proposal-style submission using the required sections: Domain and Motivation, Task Design, Data and Data Generation, Sources of Difficulty, Reference Solution and Scoring, and Citations. Each section should be concise, polished, and limited to one paragraph. The proposal should clearly explain the ML domain, why the task is meaningful, what is being predicted, how the data would be generated or adapted, why the task requires extrapolation, and why naive approaches would fail. Ideal Candidate The ideal candidate has strong experience in machine learning, applied AI, data science, or ML research, with expertise in at least one technical or scientific domain such as healthcare, finance, robotics, cybersecurity, biology, materials science, geospatial analysis, NLP, computer vision, or another complex field. They should be able to design a creative ML task that rewards real domain knowledge rather than basic textbook ML skills. Required Skills Strong understanding of machine learning problem formulation, benchmark design, data generation strategies, train/test split methodology, model evaluation, and scoring metrics is required. The candidate should also be comfortable explaining why a task is difficult, what domain-specific insights are needed, and how an expert would approach solving the problem. Clear technical writing and the ability to produce concise markdown-formatted documentation are essential. Deliverable The final deliverable will be a markdown-formatted research proposal following the provided template. It should be professional, concise, and no more than 8 paragraphs total. The proposal must involve machine learning directly and should include citations where applicable, such as relevant research papers, datasets, GitHub repositories, or other credible references that support the proposed task. Important Notes This is a machine learning evaluation project, so proposals that are not directly related to ML will not be accepted. The model output should be ignored during the evaluation process, and once the prompt has been entered and the model generates a response, the evaluator should select “Done Chatting.”

Create automated planning application spreadsheet

I am looking for someone to create an automated spreadsheet/report that pulls the previous week’s UK planning applications from the UK PlanIt data/API. The purpose of the report is to help identify potential trade opportunities for builders, loft conversion companies, kitchen/renovation firms, roofers and other home improvement trades. I need the spreadsheet to be refreshable each week, so I can update it with the latest planning applications and then export or share the data with ChatGPT for analysis. What I need is a spreadsheet system, ideally in Google Sheets or Excel, that can: 1. Pull planning application data from UK PlanIt. 2. Refresh the report weekly to show the previous 7 days of applications. 3. Cover all UK counties / planning areas, not just one local authority. 4. Handle multiple planning authorities within each county where needed. 5. Pull clean, structured data into a spreadsheet. 6. Allow me to filter by county, planning authority, date, application type and likely trade opportunity. 7. Create summary tabs that make the data easy to review. 8. Be simple enough for a non-technical user to refresh each week. **Important functionality required:** The spreadsheet should include: * A refresh button or clear refresh process. * A date range selector, ideally defaulting to the last 7 days. * County / area filtering. * Planning authority filtering. * Keyword filtering for relevant trade opportunities. * Automatic categorisation where possible, for example: * Extensions * Loft conversions * Garage conversions * Renovations/refurbishments * Kitchens * Roofing * Outbuildings * Commercial fit-outs * Other building works * A clean export tab that can be copied into ChatGPT for analysis. * Basic error handling if the API limit is reached or if a request fails. * A simple instruction tab explaining how I refresh and use the report. **Suggested spreadsheet tabs:** 1. **Instructions** Simple user guide explaining how to refresh the data and use the spreadsheet. 2. **Settings / Control Panel** Date range, counties/areas to include, keywords, refresh controls and any API settings. 3. **Raw Planning Applications** The unedited data pulled from PlanIt. 4. **Cleaned Applications** Clean version of the data with standardised columns. 5. **Trade Categorisation** Applications categorised by likely trade relevance. 6. **County Summary** Number of opportunities by county and trade type. 7. **Planning Authority Summary** Number of opportunities by local authority. 8. **ChatGPT Export** A clean tab designed specifically so I can copy/export the data and ask ChatGPT to analyse it. **Required data fields:** Where available from PlanIt, I would like the spreadsheet to include: * Application name/reference * Planning authority * County / area * Application start date * Address * Description * Application type * Development type * Status * Decision, if available * Applicant / agent details, if available * Link to planning application * Latitude / longitude, if available * Last scraped / last changed date * Suggested trade category * Opportunity score, if possible **Trade opportunity scoring:** Ideally, I would like a simple scoring system to highlight the best opportunities. For example: * High relevance: extension, loft conversion, conversion, major renovation * Medium relevance: alterations, outbuildings, roof works, garage conversion * Low relevance: tree works, signage, minor admin applications, discharge of conditions I am happy for the freelancer to suggest the best scoring approach. **Technical requirements:** The freelancer should be comfortable working with: * APIs * Google Sheets Apps Script and/or Excel Power Query * CSV/JSON data imports * Pagination * Rate limits * Data cleaning * Building refreshable dashboards/reports The PlanIt API has paging and request limits, so the system must be built responsibly and should not rely on one huge request. **End goal:** Each week I want to be able to refresh the spreadsheet, see the latest planning applications across all counties, identify the best trade opportunities, and then ask ChatGPT to analyse the data by county, trade type and opportunity quality. **Deliverables:** 1. A working Google Sheet or Excel workbook. 2. Automated or semi-automated weekly refresh process. 3. All required tabs and filters. 4. Clean data structure ready for ChatGPT analysis. 5. Simple instructions for use. 6. A short handover call or written walkthrough. 7. Notes on any limitations of the PlanIt API or recommended future improvements. **Please include in your response:** * Whether you recommend Google Sheets or Excel for this. * Examples of similar API/spreadsheet automation work. * How you would handle all counties and multiple planning authorities. * How you would manage API limits and pagination. * Estimated delivery time. * Fixed price quote.