Approach Projects

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.

Long-Form to Short-Form Video Editor (Reels, Shorts & TikTok)

We are looking for a skilled video editor to join our team on a long-term basis. Your role will be to take short-form clips extracted from long-form YouTube videos and turn them into highly engaging content for Instagram Reels, TikTok, and YouTube Shorts. This is a long-term position with consistent monthly work. Responsibilities Edit 60 short-form videos per month Create engaging videos ranging from 30–60 seconds Improve pacing and retention through strong editing Add professional captions and text overlays Integrate relevant B-roll footage when appropriate Use light motion graphics to enhance viewer engagement Apply sound effects and audio enhancements Perform basic color correction and color grading Deliver content on time and communicate effectively Requirements ✅ Experience editing Instagram Reels, TikTok, and YouTube Shorts ✅ Strong understanding of pacing, storytelling, and viewer retention ✅ Excellent cutting and trimming skills ✅ Professional captions and text animations ✅ B-roll integration and light motion graphics ✅ Sound design and sound effect implementation ✅ Basic color correction and color grading ✅ Proficiency in Adobe Premiere Pro (preferred) ✅ Reliable communication and ability to meet deadlines ✅ Open to feedback and revisions Bonus Qualifications ⭐ Portfolio containing viral short-form content (10K+ views or more) ⭐ Understanding of Instagram and TikTok algorithms ⭐ Experience working with creators, personal brands, or business content ⭐ Ability to identify what makes a clip engaging and shareable ⭐ Experience extracting viral moments from long-form videos About Viral Clip Selection We strongly prefer editors who already understand how to identify and extract viral moments from long-form content. However, if you are a strong editor and do not yet have experience with clip selection, that's okay. We have an internal process and will teach you how to identify high-retention and viral-worthy clips over time. Trial Task Shortlisted candidates will be provided with a short-form video that was originally created from a long-form video. Your task will be to edit the clip in your own style while maintaining the core message. We will evaluate: Editing quality Pacing and retention techniques Caption design Sound effects and audio enhancement Motion graphics usage Color grading Overall creativity and attention to detail This sample helps us assess your editing skills and determine whether your style is a good fit for our content. Compensation $350–$450/month depending on experience and quality Long-term position Consistent workload of 60 videos per month To Apply Please send: Your portfolio Examples of short-form content you have edited Examples of videos that achieved strong performance (if available) Your preferred editing software A brief explanation of how you approach editing for viewer retention Important To confirm that you have read the entire job post, please begin your proposal with the word "WATER". Applications that do not start with WATER will not be considered. We are looking for an editor who understands how to keep viewers watching through strong cuts, sound design, pacing, captions, and clean editing—not someone who simply trims clips.

The coven - web development

The Coven - Architecture Review & Development Brief Purpose I am looking for an experienced development team to review the project, evaluate possible technical architectures, and provide recommendations before further development proceeds. I am not committed to a specific technical solution. I would like recommendations on the best approach for: scalability maintainability user experience SEO cost speed to market The outcome of this review should be a recommended architecture, estimated timeline, and estimated budget. Project Overview The Coven is a platform for sexuality facilitators. The platform serves two audiences: Facilitators Professionals working in: sexuality facilitation somatic practice tantra embodiment intimacy coaching relationship coaching related fields Seekers Individuals looking to find and connect with facilitators. The vision is to create a platform that combines: Professional directory Facilitator profiles Community Courses Resources Messaging Practice-building tools Existing Assets The following assets already exist: Brand identity Sitemap Domain and hosting WordPress installation BuddyBoss setup LearnDash setup Membership structure Replit prototype The Replit prototype currently contains much of the desired user experience and design direction. The WordPress ecosystem currently contains much of the desired backend functionality. What Needs To Be Built Public Marketplace Public-facing website including: Homepage About Pricing Facilitator directory Facilitator profiles Resource pages Course pages Facilitator Portal Authenticated member area including: Community Messaging Resources Courses Profile management Membership management Future Features Booking calendar Session payments Facilitator reviews Analytics Events Course publishing Facilitator Memberships Starter (Free) Profile creation Community access Resources Peer messaging Basic analytics Pay-per-course access Not publicly visible in directory. Pro ($39.95/month) Everything in Starter plus: Public directory visibility Client inquiries Client messaging Priority profile visibility Monthly course credit Studio ($59.95/month) Everything in Pro plus: Booking calendar Availability management Session scheduling Payment collection Practice management tools Facilitator Application Flow Facilitators complete an application form. Applications enter review status. Profiles become publicly visible only after approval. Core Directory Features Search by: Location Modality Session type Current modalities include: Somatic Intimacy Tantra Pleasure Education Consent & Boundaries Erotic Massage Sexual Trauma Support Couples Intimacy Embodiment Sacred Sexuality Kink & BDSM Non-Monogamy Breathwork Relationship Coaching Trust & Safety The platform should support: Facilitator review process Community standards Reporting system Profile approval workflow The Coven is a platform and does not mediate disputes between facilitators and clients. SEO Requirements The platform should support: Public facilitator profiles City pages Modality pages Search-friendly URLs Indexable directory content Examples: /facilitator/name /directory/city/london /directory/modality/tantra Architecture Review Request Please evaluate and provide recommendations for: Option 1 Continue with WordPress, BuddyBoss, and LearnDash as the primary platform. Option 2 Use WordPress/BuddyBoss/LearnDash as the backend with a custom frontend experience. Option 3 Rebuild the platform entirely using a modern custom stack. Option 4 Any alternative architecture you would recommend. Questions To Answer Please provide: Which architecture would you recommend and why? What are the advantages and disadvantages of each option? Estimated development cost for each option. Estimated timeline for each option. Long-term maintenance considerations. Scalability considerations. SEO considerations. Any risks or concerns you see with the project. Primary Goal The goal is to create the leading professional ecosystem for sexuality facilitators, combining community, education, visibility, and client discovery within a single platform. The priority is making the right long-term architectural decision before committing further development resources. I have attached a site map I have built a prototype of the site on replit and that can be found here: https://replit.com/join/nhhnkjvxpq-marc504

opportunity

PCB designer for CM4 carrier with isolated RS422/RS485

We need an experienced electronics/PCB designer to design a custom Raspberry Pi Compute Module 4 carrier board for an industrial field test tool. The board will be used for roadside electronic sign testing and needs robust isolated serial communications, Ethernet, WiFi support via the CM4 module, touchscreen display support and a connector for an address plug socket. We are developing a portable field tester for roadside electronic signs and controllers. The unit will run Linux on a Raspberry Pi CM4 and needs to communicate with equipment over isolated RS422/RS485 and Ethernet. It needs to be designed sensibly for field use, with proper isolation, protection, clear connectors and future small-batch manufacture in mind. Required board features: • Raspberry Pi Compute Module 4 socket. • Support for CM4 wireless variant for WiFi/Bluetooth. • Gigabit Ethernet port using the CM4 native Ethernet interface. • Two independent isolated serial ports. • Each serial port to support full-duplex 4-wire RS422: TX+, TX-, RX+, RX-. • Ideally allow RS485 configuration as well, if practical: 2-wire half-duplex RS485 or 4-wire RS485/RS422 mode. • Digital isolation on the serial ports. • Isolated DC/DC supply for the field side of the serial interfaces. • TVS/ESD protection on field connections. • Termination and bias options per port, preferably via jumpers or DIP switches. • TX/RX activity LEDs per port. • Connector for an external address plug socket. • MIPI DSI touchscreen display connector, similar to the Waveshare CM4 Nano B: 15-pin 1.0mm FPC connector, suitable for common Raspberry Pi DSI touchscreens such as 4.3 inch, 5 inch or 7 inch. • Allow for touchscreen/control lines where required. • Mechanical clearance and routing allowance for the screen ribbon cable. • WiFi/Bluetooth to be provided by the CM4 wireless module, not a separate WiFi chipset. • RF/mechanical allowance for CM4 onboard antenna or external antenna connection. • Protected power input suitable for field equipment. • Status LEDs for power, CM4 activity, Ethernet, serial activity and isolated power good. • Sensible mounting holes and enclosure-friendly layout. Preferred technical direction: The serial ports should probably be implemented using a dual UART interface from the CM4, for example an SPI-to-dual-UART device such as the SC16IS752/SC16IS762 family or equivalent, feeding isolated RS422/RS485 transceivers. We are open to the designer recommending exact parts, but the design must be supportable and manufacturable, not based on obscure parts with poor availability. Deliverables required: • Schematic design. • PCB layout. • Gerber files. • Pick-and-place / assembly outputs. • Bill of materials with manufacturer part numbers. • Any required configuration notes for CM4 interfaces used, especially DSI, SPI/UART and Ethernet. • Basic bring-up notes and test points. Useful reference board: The Waveshare CM4 Nano B is a useful reference for the compact CM4 carrier concept, particularly the CM4 socket, Ethernet, DSI touchscreen connector and general small carrier-board approach. Our board needs to add robust isolated dual RS422/RS485 and address plug support. Please only respond if you have experience designing Raspberry Pi CM4 carrier boards, isolated serial interfaces, or industrial communications hardware. We are happy to work iteratively, but need someone who can make sensible engineering decisions and produce files suitable for manufacture. We can provide more detail on the address plug wiring and preferred connectors once we have selected a designer.

Technical Funnel & CRM Systems Specialist (GoHighLevel - GHL)

GoHighLevel (GHL) expert required — specialising in funnels, automation systems, deliverability, and CRM optimisation. We work with individuals navigating complex emotional and psychological challenges. Many appear high-functioning on the outside, yet are struggling beneath the surface. Because of this, clarity, consistency, and trust in our communication is critical. When our systems work properly, clients feel supported, informed, and safe — receiving the right message at the right time so they can move forward with confidence. When they don’t, messages are missed, trust is reduced, and the client experience is compromised. We hold this area of our business to a high standard of care and precision. Where We Are Now As we scale, we are refining and rebuilding our technical ecosystem to match the standard our clients deserve. This includes: Strengthening email deliverability and reliability Improving membership communication flows Optimising funnel journeys for clarity and consistency Ensuring systems are structured, compliant, and scalable We prioritise structured, reputation-safe systems that protect deliverability and build long-term trust. What We Need Now This is not a VA role. This is a systems-critical position within a growing, premium, neuroscience-based business. We are looking for a trusted specialist to: Audit current systems with an expert lens Stabilise and refine existing systems Optimise performance and user journeys Maintain system integrity Support future scale, automation, and AI integration Why This Role Matters This role ensures: The right people receive the right support Communication is clear, consistent, and timely Our systems reflect the quality of our work We are building a high-trust, high-performance environment where communication is part of the care we provide. Responsibilities Phase 1: Audit & Stabilisation Audit GHL setup (funnels, workflows, automations) Support email system stability (domains, SMTP, reputation) Identify deliverability risks Optimise membership communication flows Phase 2: Optimisation Improve funnel performance and journeys Ensure clean, compliant automation systems Align systems for consistency Phase 3: Ongoing Support Provide part-time technical support Troubleshoot proactively Document actions and improvements Phase 4: Build & Scale Support AI agents (Apex, Lindy or similar) Assist funnel expansion (incl. licensing model) Improve tracking (Meta / Google / GHL) Required Expertise (Non-Negotiable) Advanced GoHighLevel (GHL) experience Funnel building and automation systems Email deliverability (DNS, SMTP, warming, reputation) WhatsApp CRM integration Tracking (Meta / Google / attribution basics) Highly Desirable Healthcare / coaching / regulated industry experience Compliance-aware marketing understanding Membership platforms in GHL AI automation tools Systems thinking mindset How You Work Calm, structured, and methodical Reliable and trustworthy Proactive and solution-focused Clear communicator (excellent English) Efficient, no over-complication Working Setup Part-time ongoing Initial 2-week paid trial UK / GMT timezone (or close) This Role Is Not Suitable If… You prioritise volume over strategy You cannot explain email deliverability and reputation You lack deep GHL expertise You need constant direction You do not document or communicate clearly We are looking for someone who values precision, structure, and long-term system integrity. Application Requirement (Mandatory) Include a 2-minute video covering: Your GHL experience (specific examples) Your approach to deliverability A system or funnel you’ve built or fixed Why you’re the right fit **Applications without video will not be reviewed. Final Note We are building a high-integrity system that supports real transformation. We take our work, and our systems — seriously. If you are a true specialist who values precision, structure, and long-term thinking, we would like to hear from you.

opportunity

Booth design for an event

Exhibition Booth Designer Required We are seeking an experienced exhibition booth designer to develop a premium large-scale exhibition stand for a corporate client. Project Overview * Booth Size: 432 sqm * Double-decker structure required * Rigging and suspended elements are permitted * Three sides of the booth are open to visitors * Rear side must be enclosed * Up to three design concepts to be presented The objective is to create a premium, visually impactful booth that balances creativity with practicality. We are looking for a design that is elegant, memorable, and engaging, while remaining functional, buildable, and operationally efficient. Concepts should avoid unnecessary complexity and focus on delivering a seamless visitor experience. Design Direction * Premium, gallery-style environment * Modern, clean, and refined aesthetic * Strong visual presence without clutter * Focus on quality, precision, and attention to detail * Clear presentation of projects, content, and brand messaging * Creative yet practical design approach Scope of Work The selected designer will be responsible for: * Developing up to three creative booth concepts * Designing the overall visitor journey and experience * Creating high-quality 3D renders and visualizations * Producing detailed technical and production drawings * Recommending materials, finishes, and lighting solutions * Preparing all design files and technical documentation required for organizer approvals Booth Requirements Each design must include: * Double-decker structure * Reception and welcome area * Private meeting room with a minimum capacity of 10 people * Dedicated media area suitable for interviews and signing ceremonies * Catering and hospitality corner for refreshments and finger food * Storage area for giveaways and operational materials * Multiple integrated screens throughout the booth * Electrical outlets and charging stations for phones and laptops * Accessibility ramps and compliance with accessibility requirements * Comfortable, premium-quality furniture Project Showcase Areas A key feature of the booth will be the display of physical project models (maquettes). Designs should include: * Dedicated and prominent maquette display areas * Integrated lighting to highlight the models * Strategic placement to attract attention without disrupting visitor flow * Premium presentation that enhances the visitor experience Technology & Content Integration Screen placements should support: * Portfolio showcases * Corporate messaging * Project highlights * Video and visual content Design Considerations * White or light-toned premium flooring preferred * Strong visibility from all open sides * Efficient visitor circulation and crowd flow * Balanced allocation of space between hospitality, meetings, media engagement, project displays, and visitor interaction * Practical construction and operational efficiency Deliverables Concept Stage For each design concept, provide: * 3D renders * Material palette * Layout and zoning plan * Visitor flow plan * Five-side views Final Stage Provide: * Final approved booth design * Detailed technical and production drawings * Material and finish specifications * Submission-ready files for organizer approvals Qualifications Applicants should demonstrate: * Proven experience designing large-scale exhibition stands and experiential spaces * Experience delivering exhibition booths exceeding 200 sqm * Strong portfolio of corporate, real estate, government, or premium brand projects * Ability to translate business objectives into impactful visitor experiences Submission Requirements Please submit: * Portfolio of relevant work * Examples of similar large-scale projects * Proposed approach and methodology * Estimated timeline * Commercial proposal * Confirmation whether you provide design services only or design-and-build services through production partners