Product Design Projects

Urgent Requirement–Drainage / Wastewater Assessment (N.IRELAND)

We are seeking assistance from a suitably qualified Civil Engineer, Drainage Engineer or Water Engineer to prepare a short technical note in support of a live planning application in Northern Ireland. Background The planning application relates to an existing public house and adjoining retail unit. As part of the proposal, an existing hot food deli operation is being removed and the retail floorspace is being incorporated into the public house. A key issue has arisen regarding wastewater generation and the potential impact on the NI Water network. We require an independent professional assessment of whether the removal of the existing deli operation is likely to offset, or potentially exceed, any increase in wastewater generation associated with the proposed use. Scope The successful consultant would be required to: • Review photographs and information relating to the existing deli operation. • Assess the likely wastewater generation associated with the existing deli use. • Consider the proposed arrangement and likely wastewater generation following removal of the deli. • Provide an opinion on whether overall wastewater generation is likely to remain similar, reduce, or increase. • Prepare a short technical note on company headed paper suitable for submission to NI Water and the Planning Authority. Requirements • Relevant qualification in Civil Engineering, Drainage Engineering, Water Engineering or similar. • Experience of drainage design, wastewater assessments or NI Water applications. • Ability to provide a professional opinion on company headed paper. • Quick turnaround essential. Timescales This is an urgent commission and we would ideally require a draft note within 24–48 hours. Please contact Ryan Milligan at Planning Experts if interested

Seeking eCommerce Beta Testers

Beta Tester - Optagen Portal & Integrations What you’re testing The Optagen portal lets you manage multiple stores by bringing together data from your commerce, analytics, accounting, inventory, and CRM systems. It creates a single ranked action list, with each recommendation labeled for trust and checked against real results. We need beta testers to use the portal with real store data and identify what breaks, what’s slow, what’s missing, and what doesn’t match reality. Integration coverage required You will test syncing and data accuracy across these integrations: Commerce platforms: Shopify, BigCommerce, WooCommerce, Etsy Analytics: Google Analytics 4, Search Console Shipping/3PL: ShipBob, ShipStation, Easyship Inventory systems: Cin7, Katana Accounting: QuickBooks, Xero Marketing/CRM: Klaviyo You don’t need to use every integration—just test the ones you already use. We’re aiming for each tester to cover at least 3 or 4 integrations from different categories. What we’re asking 1. Sync completeness: Check if all the expected fields from each integration show up in the portal. Are SKU, pricing, margin, sales, traffic, inventory, and competitor data there? 2. Refresh latency: See how long it takes for changes in your source system (like a price update in Shopify or a GA4 event) to show up in the ranked plan. 3. Data accuracy: Choose 5 to 10 data points you can check in both your source system and Optagen. Do they match? 4. Signal read accuracy: The portal calculates metrics such as AI visibility, SKU margins, demand signals, returns concentration, pricing elasticity, and competitor share of voice. Check these against your store. Do they make sense? Can you find the data sources if you look for them? 5. Ranked plan stability: Run the same store scan twice in one week. Does the ranked plan update based on new data, or does it stay the same? Are the revenue-impact numbers realistic? What we’re not asking * Testing the governed execution agent (scheduled to ship later; currently in development) * Load testing or scale testing * Security testing or pen testing * UX/design feedback (we’ll gather that separately) Timeline and access * Beta runs from [DATE] to [DATE] * You’ll get portal access for your own stores, using your real data—not test data. * We’ll keep an eye on logs and collect diagnostics if something fails. Please report any issues as they happen via a feedback button. * We’ll have a weekly sync call to talk about any blockers or patterns you notice. Who should apply * You run 1-5 stores across 2+ of these platforms. * You can verify data accuracy (you know your actual margins, traffic, and sales numbers) * You’re willing to spend 2-4 hours per week auditing sync health and data correctness. * You’re okay with bugs and incomplete features since this is a beta test. When you apply, please indicate: * Which platforms you currently use (Shopify, BigCommerce, WooCommerce, Etsy etc.) * Rough store size (monthly revenue or annual, average order value, SKU count) * Any specific data quality concerns you have with your current setup

Faceless YouTube channel

Project Title Faceless Kids YouTube Channel Creator (Long-Term Partnership) Project Description I’m looking for an experienced YouTube content creator or small creative team to help build a brand-new faceless children’s YouTube channel from the ground up. This is a long-term project with weekly work available for the right person. What I Need I’m creating a fun, educational, and entertaining animated channel for children ages 3–8 featuring original characters, positive life lessons, humor, adventure, and catchy storytelling. I need someone who can help create high-quality videos that keep children engaged while maintaining a consistent visual style across every episode. Responsibilities * Create engaging 8–10 minute YouTube episodes * Produce colorful, child-friendly animations * Edit videos with sound effects, music, and pacing that holds children’s attention * Generate AI visuals when needed while keeping all characters consistent * Add subtitles and polished transitions * Deliver videos ready for YouTube upload * Create eye-catching thumbnails * Maintain a consistent look and feel throughout the series Style I’m Looking For * Bright, colorful animation * Pixar/DreamWorks-inspired quality (using AI tools where appropriate) * Fast-paced storytelling * Educational without feeling like a classroom * Positive messages about kindness, friendship, teamwork, confidence, and problem-solving * Original content only (no copyrighted characters) Skills Preferred * YouTube content creation * Children’s animation * AI video workflows (Higgsfield, Veo, Runway, Kling, Pika, Sora, or similar) * Adobe Premiere Pro, After Effects, DaVinci Resolve, or equivalent * Motion graphics * Storytelling * Sound design * Thumbnail design Deliverables * Fully edited YouTube video (8–10 minutes) * Thumbnail * Intro and outro * Background music and sound effects * Editable project files (if applicable) * Final video in 4K or 1080p When Applying Please include: * Examples of children’s content you’ve created * Links to YouTube channels you’ve worked on * Your animation workflow * AI tools you use * Estimated turnaround time per episode * Your price per episode This is intended to become an ongoing weekly collaboration for someone who can consistently deliver engaging, high-quality content. I’m looking for creativity, strong communication, reliability, and a genuine passion for making entertaining educational videos for kids.

opportunity

Add functionality to app - Dart / Flutter app

Project Brief – App Development Overview This project involves adding new functionality across two existing checklist/reporting applications. Both apps allow users to complete food safety checklists which are then stored and generated into reports. Several features already exist in one application and now need to be duplicated into the other, alongside new functionality. Application 1 – GS App 1. Live Temperature Sensor Updates Implement live updating temperature readings from connected sensors. 2. Manual Label Printing Add a "Print Manual Label" screen. Users should be able to generate and print labels without selecting an existing food item. 3. Amazon Label Reordering Add an Order Labels button. When pressed: Customer's saved Stripe payment method is charged. Amazon Multi-Channel Fulfilment (MCF) automatically ships a new roll of labels to the customer's registered address. No manual intervention required. 4. Delivery Comments Add a comments field to Delivery records. Comments should also appear on generated reports. 5. Report History At the bottom of the Reports screen display the last 5 reports generated. Users should be able to download/view these reports again. 6. Compliance Improvements Add two new compliance sections: Pest Control Agreement Oil Disposal Agreement The documents will be uploaded through the dashboard and viewable from the mobile app. 7. Copy Compliance Allow compliance checklists to be copied/imported from the second application. Application 2 – SF 1. Duplicate Label Printing System Copy the complete label printing functionality already built into the GS App, including: Manual Label Printing screen Existing label printer functionality 2. Amazon Label Reordering Add an Order Labels button. When selected: Customer's Stripe payment method is charged. Amazon MCF automatically dispatches label rolls. Printer purchases remain available within the Owner Account section. 3. Delivery Comments Add comments to delivery records. Include these comments on generated reports. 4. Report History Display the last 5 generated reports at the bottom of the Reports screen with download capability. 5. Compliance Documents Add two new compliance sections: Pest Control Agreement Oil Disposal Agreement Documents are uploaded through the dashboard and viewable within the mobile application. SFBB Pro – Subscription & Multi-Site Upgrade Subscription Changes Remove the existing: Normal Plan Premium Plan Replace with: Standard Subscription Current application functionality. Label Printing Subscription Includes label printing functionality. Multiple Site Subscription Additional charge: £12.95 per additional location Multi-Site Management Create owner-level multi-site functionality. The account owner should be able to: Add new locations. Remove locations. View all locations from a dashboard. Be charged for each additional location. Assign a Location Administrator for each site. Each Location Administrator should: Only access their assigned location. Complete daily checklists. Manage staff for their location. View reports for their location only. The Owner should have visibility and reporting across every location. General Requirements The developer should: Reuse existing functionality wherever possible rather than rebuilding it. Maintain the current design style. Ensure all new features are fully integrated into reporting. Test all new functionality before completion. Deliverables GS App Live sensor updates Manual label printing Amazon MCF label ordering Delivery comments Report history Compliance document upload/view Compliance copy feature SFBB Pro Duplicate label printing system Amazon MCF label ordering Delivery comments Report history Compliance document upload/view Subscription restructuring Multi-site management Owner dashboard Location administrator functionality Agreement Please review the above scope carefully. If you are happy with everything listed, please confirm that you agree this represents the full scope of work before development begins.

opportunity

Excel automate, Power Query, data mapping, dashboard development

I am looking for an experienced Excel and Power Query specialist to complete a multi-level governance and assurance system for a health and social care organisation. The organisation has five service divisions. The workbooks, registers and overall structure have already been designed; I am not looking for someone to start again. I need someone who can review the existing files, improve the formulas and functionality, make the registers smarter and create reliable connections across the system. The required reporting flow is: Service/Practice Observation → Regional Governance → Divisional Governance → Group Governance/Master Dashboard Each division requires its own governance workbook and dashboard. Service and regional information must feed into the relevant divisional workbook, with key information from all five divisions feeding into one Group-level Master Dashboard. Smart governance registers The project includes a suite of existing registers covering areas such as: Risk Safeguarding Incidents and serious incidents Complaints and compliments GDPR and data breaches Restrictive practice Governance actions Service user feedback Audits and improvement Regulatory actions Training and workforce compliance The exact number of files will be confirmed with the successful freelancer following an initial review. The registers need to become functional, consistent and easy to use, rather than simply formatted spreadsheets. Depending on the register, this may include: Unique reference numbers Automated status calculations Open, closed and overdue indicators Due-date and review alerts Automated risk ratings and RAG indicators Dropdown lists and controlled data entry Conditional formatting Automated totals and summary metrics Monthly, quarterly and annual reporting Filtering by service, region, division, category, status and reporting period Identification of themes, recurring issues and required escalations Formula protection without restricting data entry Summary pages or dashboards Connections to the appropriate regional, divisional and Group dashboards The registers will remain the source of truth for individual records. Only relevant totals, themes, trends, risk ratings and outstanding actions should feed into higher-level dashboards. Main requirements The successful freelancer will be required to: Review and inventory the existing workbooks and registers Produce a clear data map showing how information should move through the system Make the registers smarter, more automated and easier to maintain Add, correct and protect formulas across multiple files and tabs Standardise dropdowns, identifiers, categories and reporting periods where required Create calculated metrics, alerts and RAG indicators Link Practice Observation data to Regional Governance workbooks Link Regional Governance workbooks to the relevant Divisional Governance workbook Complete dashboards for each of the five divisions Link all five Divisional Governance workbooks to the Group Master Dashboard Link relevant register data to the correct reporting level Use Power Query or another reliable Excel-based method where appropriate Ensure files work reliably within Microsoft 365/SharePoint Reduce the risk of broken links when files are moved, updated or refreshed Test the complete data flow from source registers through to the Master Dashboard Ensure the system is straightforward for managers with varying levels of Excel experience Deliverables Smart, functioning governance registers Functional Practice Observation templates Regional Governance and Assurance workbooks Five Divisional Governance workbooks and dashboards One Group Governance workbook and Master Dashboard Reliable connections between all relevant files Working formulas, validation, dropdowns, alerts and RAG ratings A complete data map/data dictionary Testing of the full reporting flow Simple refresh and maintenance instructions Final handover and correction of any errors identified during testing Confidentiality The work relates to confidential organisational systems. A Non-Disclosure Agreement must be signed before any files are shared. Anonymised or test data will be used wherever possible. Please include in your proposal: Your experience of creating smart Excel registers and trackers Your experience of linking Excel files stored within SharePoint/Microsoft 365 Your Power Query experience How you would minimise broken connections How you would approach mapping and testing this system Examples of comparable work What you can deliver within the approximate £1,000 budget

Strategic Website Migration, Redesign & SEO Rebuild

Overview PortfolioXD is an established UK executive leadership business providing C-Suite as a Service (C-SaaS™) to ambitious founder-led and investor-backed businesses. Over the past two years we have built our website using GoDaddy Website Builder. Unfortunately, we have now reached the limitations of the platform. Technical SEO issues (including duplicate homepage URLs, limited control over redirects, canonical tags and XML sitemaps) are affecting Google Search Console indexing. Rather than simply recreating the existing website, we are taking this opportunity to build PortfolioXD 2.0 on WordPress using Elementor. This is not a blank-sheet design project. The business, proposition and content already exist. We are looking for someone to migrate, improve and future-proof the site. Objectives The successful freelancer will help us: migrate the existing website from GoDaddy Website Builder to WordPress build the site using Elementor preserve existing SEO wherever possible implement best-practice technical SEO improve user experience and conversion create a platform that can grow over the next 3–5 years Existing Website Current website: https://portfolioxd.com Current platform: GoDaddy Website Builder The current site cannot be exported, therefore content will need to be recreated. Scope The project includes: Website architecture Review the existing structure and recommend improvements. Maintain SEO value by keeping existing URLs wherever practical. Page migration Recreate all key pages including: Home About Services Role pages Sector pages Contact Insights / Blog Landing pages Content will be provided. Blog migration Migrate all existing blog posts. Maintain: titles dates (where possible) featured images categories URLs Images Transfer all images and optimise for performance. Technical SEO This is a critical requirement. The successful freelancer must implement: XML sitemap Canonical URLs 301 redirects Robots.txt Schema markup Open Graph Meta descriptions Page titles Image ALT tags The new site should be fully compatible with: Google Search Console Google Analytics Google indexing Performance Optimise for: Core Web Vitals Page speed Mobile performance CMS We require an easy-to-manage WordPress site using Elementor. We do not want a bespoke theme requiring developers for every future change. PortfolioXD 2.0 This is more than a migration. The business has evolved considerably. The new site should better communicate our market positioning around: C-Suite as a Service™ Fractional Leadership Executive capability on demand Leadership capability rather than recruitment Leadership Gap Reviews Founder support Scale-up support Private Equity Venture Capital Investor-backed businesses We have significant amounts of copy already written. We welcome suggestions for improving structure and conversion. What success looks like At completion we should have: ✔ Modern professional website ✔ Excellent mobile experience ✔ Faster loading ✔ Better SEO ✔ Clean WordPress installation ✔ Easy editing through Elementor ✔ Google Search Console configured correctly ✔ Existing authority preserved ✔ Platform capable of supporting future growth What we will provide Existing website Brand assets Logos Images Existing copy New messaging New positioning Feedback throughout the project Ideal freelancer We're looking for someone with proven experience in: WordPress Elementor Technical SEO Website migrations Google Search Console Core Web Vitals Conversion optimisation Please provide examples of similar projects. Timescale Ideally completed within 3–4 weeks. Proposal Please include: examples of similar migrations estimated timescale fixed price recommendations you would make before starting any questions you have after reviewing the existing site This is an important strategic project for our business, not simply a website redesign. We have spent the last two years refining our proposition, developing thought leadership and building domain authority. We are looking for a long-term partner who can help us migrate those assets onto a platform that gives us complete control over SEO, performance and future growth. The successful freelancer may also become our ongoing WordPress and SEO partner. Please begin your proposal with the words "PortfolioXD 2.0" so I know you've read the brief. Generic AI-generated proposals will be ignored.

IT support Analyst M365/Google Workspace

Job Title: IT Support Specialist (Managed Services) Employment Type: Managed Service Location: Remote The analyst have to be available Monday-Friday 07:00–19:00 BST. About the Role We are seeking a customer-focused IT Support Specialist to deliver remote managed IT support services across Google Workspace and Microsoft 365 environments. This role is responsible for providing end-user support during extended business hours, managing identity and access requests, administering collaboration platforms, supporting mobile device management (MDM), and ensuring a consistent, high-quality user experience. The successful candidate will work within a managed services framework, adhering to agreed service level agreements (SLAs), maintaining accurate documentation, and proactively identifying opportunities for service improvement. Working Hours Provide remote support coverage during extended business hours. Participate in scheduled shift rotations to ensure continuous service availability. Support priority incidents and service requests in accordance with defined SLAs and escalation procedures. Provide occasional out-of-hours support for critical business incidents, as required. Key Responsibilities End-User Support Deliver Level 1 and Level 2 remote technical support for end users. Log, categorize, prioritize, and resolve incidents and service requests through the IT service management platform. Provide timely communication and status updates to users and stakeholders. Troubleshoot issues related to operating systems, productivity applications, collaboration tools, and endpoint devices. Escalate complex issues to specialized support teams when necessary. Identity and Access Management Manage user identities and access across Google Workspace and Microsoft 365. Execute Joiner, Mover, and Leaver (JML) processes, including: User account provisioning and deprovisioning Role and permission changes License allocation and recovery Group membership administration Support password resets, multi-factor authentication (MFA), and account recovery processes. Ensure compliance with security and access governance policies. Collaboration Platform Administration Administer and support Google Workspace and Microsoft 365 services, including: Gmail and Microsoft Outlook Google Drive and OneDrive Google Meet and Microsoft Teams Shared mailboxes and distribution lists SharePoint Online and Shared Drives Configure, maintain, and troubleshoot: Email forwarding Mail flow issues Inbox and transport rules Shared mailbox access Calendar permissions and delegation Mobile Device Management (MDM) Administer and support MDM solutions for corporate devices. Enroll, configure, and maintain Android, iOS, Windows, and macOS devices. Apply security policies, compliance settings, and conditional access controls. Troubleshoot device enrollment, synchronization, and application deployment issues. Perform remote device actions, including lock, wipe, and compliance remediation. Service Management Meet or exceed contractual SLAs and key performance indicators (KPIs). Maintain accurate ticket documentation, asset records, and support procedures. Develop and update knowledge base articles and standard operating procedures. Identify recurring issues and recommend service improvements. Collaborate with customer stakeholders and internal teams to ensure service excellence. Required Skills and Experience Minimum 3 years of experience in an IT support, service desk, or managed services environment. Hands-on administration experience with Google Workspace and Microsoft 365. Experience managing Joiner, Mover, and Leaver processes. Strong understanding of identity and access management principles. Experience troubleshooting email systems, forwarding rules, and mailbox configurations. Practical experience with MDM platforms such as Microsoft Intune, Google Endpoint Management, Jamf, or equivalent solutions. Familiarity with ITSM platforms such as ServiceNow, Jira Service Management, Zendesk, or Freshservice. Strong knowledge of Windows, macOS, Android, and iOS environments. Understanding of ITIL service management principles. Excellent verbal and written communication skills in English. Preferred Qualifications Microsoft 365 Certified: Endpoint Administrator Associate Google Workspace Administrator Certification ITIL Foundation Certification Experience supporting hybrid cloud environments Key Competencies Strong customer service orientation Excellent troubleshooting and analytical skills Ability to work independently in a remote environment Strong organizational and time management skills Attention to detail Ability to manage multiple priorities effectively Commitment to continuous improvement and service excellence

Corporate Solicitor - Pre-Seed Tech Startup

What we're building: Pre-seed digital health tech startup. UK-incorporated (imminent), with an independent investor committing capital in tranches. We're planning a UAE flip at Milestone 5 (Year 2), but keeping UK subsidiary + options scheme intact post-flip. What we need from you (starting now): 1. Incorporation (Weeks 1–2, urgent) — Companies House filing, baseline structure, entity sign-off 2. Founder documentation - Founder vesting deeds (for two co-founders, clawing back vesting from May 2024) - IP assignment deed (everything we've built before company exists transfers to the company) 3. Equity restructuring — we have three existing contractor agreements that need replacement with cleaner equity framework 4. Options scheme design — unapproved options (not EMI): - Strike price & valuation methodology - Growth shares for one team member - S.431 election support (HMRC filing within 14 days of share issue) 5. Investor structure — withholding tax, tranche documentation, milestone drawdown mechanics 6. UAE flip roadmap (Milestone 5) — don't execute yet, but map it now: - DIFC vs. ADGM vs. DMCC entity type - Controlled Foreign Company (CFC) implications - UK subsidiary retention strategy Who you're working with: - Two co-founders - Contractor CTO, clinical advisor, legal advisor (all taking equity) - One independent investor, UAE-based - External accountant (TBD) Your background (must have): ✓ 5+ years advising pre-seed/Series A startups (not corporate M&A) ✓ Deep expertise in founder agreements, vesting, equity schemes ✓ HMRC S.431 elections and shareholder agreement experience ✓ UK options law (unapproved schemes, growth shares) ✓ IR35 awareness (contractor equity holders) ✓ UAE entity familiarity (DIFC/ADGM at minimum; DMCC research willing) ✓ Can turn around quality work fast (weeks 1–2 is urgent) Your style: - Plain English (we work lean, no jargon) - Proactive (flag risks early, suggest solutions) - Written-first communication (we're async) - Comfortable pushing back on founder assumptions Red flags for us: - "I'll need to research this" on founder vesting or S.431 - Generalist solicitor dabbling in startup work - Slow turnaround or unavailable for 2-week sprint - Template-heavy approach How to apply: Tell us: 1. Your last 2 startup clients you've incorporated (stage, equity type, complexity) 2. One time you structured an options scheme (growth shares, unapproved, or similar) 3. Any UAE entity work you've done 4. Availability: Can you commit to weeks 1–2 urgently? When can you start?

Email Copywriter for Warm Leads — Paid Test + Performance Bonus

We are looking for a sharp, conversion-focused email copywriter to help us write and optimize email campaigns for a large list of warm inbound creator leads. We currently have a database of 6,000+ people who have already shown interest in working with us, asking questions, getting started, or learning how to grow their online presence. A small percentage are already established creators who may be a fit for higher-level partnership conversations. This is not a generic newsletter role. We need someone who understands persuasive email copy, follow-up sequences, objection handling, and how to turn warm leads into replies, calls, and qualified opportunities. What You’ll Be Doing -You will help create and improve email campaigns that: -Re-engage old warm leads -Turn curious leads into booked calls -Educate new creators on how we can help them grow -Follow up with people who showed interest but never took action -Segment messaging based on lead quality and intent -Improve reply rates, booked-call rates, and overall conversion -Initial Paid Test Project For the first project, we will provide background on the offer, lead types, and current messaging. Your task will be to create: -1 main reactivation email -1 short follow-up email -1 objection-handling follow-up -1 higher-intent email for more established creators Suggested subject lines for each email A short explanation of your strategy behind the sequence If the test goes well, this can turn into an ongoing role where you help write, test, and optimize multiple email sequences across the full lead database. Who We’re Looking For The ideal person has experience with: -Email copywriting -Direct-response copy -Creator economy, influencer, coaching, agency, SaaS, or online business offers -Warm lead reactivation campaigns -Appointment-setting email funnels -High-ticket or partnership-based offers -Writing emails that sound human, not robotic or overly corporate -Improving campaigns based on reply rate and booked-call data -You do not need to be a designer. This is primarily a copywriting and strategy role. Important: We Care About Results We are not looking for pretty writing only. We want someone who understands conversion. You should be able to think through: -Why someone would reply -Why someone would ignore the email -What objections they may have -What angle makes the offer feel relevant -How to make the message feel personal without sounding fake -How to create curiosity without overpromising Compensation Structure This role starts with a paid fixed-price test project. For ongoing work, compensation may include: -Base pay per email sequence or campaign -Performance bonuses for campaigns that generate qualified replies, booked calls, or successful partnerships -Long-term monthly work for someone who proves they can consistently improve results -Strong performers can earn significantly more over time as we scale campaigns. We are looking for someone who wants to build a long-term partnership, not just complete a one-time project. This role will start with a paid starter project and performance-based bonuses so we can make sure it is a strong fit on both sides. If the partnership goes well and you are consistently producing results, we are open to adding a more stable base compensation structure after 3–6 months of successful work, while still keeping performance bonuses in place. Our goal is to work with people who are hungry, reliable, and results-driven. If you perform well, communicate clearly, and help generate real opportunities, there is room to grow with us long term. Please include: -Examples of email campaigns, outreach copy, or direct-response copy you’ve written -Your experience with warm lead reactivation or appointment-setting campaigns -A short explanation of how you would approach a 6,000-person warm lead list Any results you’ve helped generate, such as reply rates, booked calls, sales calls, conversions, or revenue Please do not send a generic AI-written proposal. We are looking for someone who can think strategically, write clearly, and improve based on real campaign performance. Best Fit This is a great fit for someone who enjoys performance-based copywriting and wants a long-term opportunity with upside based on results.

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.

Increase organic reach to my website https://maidenventures.co/

Hi, We are looking for help with three specific tasks increase traffic to www.maidenventures.co design update a general website optimisation to increase the speed When anyone in Sydney type the following words I would like the website to come up Technology in construction Energy saving Solar loans Building energy audits Electricity savings Gas Savings Utility bills