Version Projects

Shopify web designer/developer

Hi, I’m looking for a Shopify developer to complete a handful of final tasks on our website. Main Menu STORIES * Already linked correctly. MAGAZINE * This should link to the magazine archive page (example attached). * Users should see available issues displayed vertically, with the newest issue always appearing at the top and older issues naturally moving down the page. * Each issue should have the option to purchase either the digital or print version, taking the user directly to the basket/checkout. * I have the templates designed already to make this faster LOS ANGELES * When clicked, this should take users to the Los Angeles section within Stories. * Los Angeles content must only appear within the Los Angeles section and should never appear in the main Stories feed. * The main Stories feed should only contain Liverpool-related content. SHOP everything is completed User Account * Please remove the account/profile icon, as we do not currently offer memberships or subscriptions. Footer * Network logos need linking to their respective websites (I can provide all URLs). * If possible, I’d also like some recommendations on improving the footer layout and navigation, although this isn’t urgent. General Testing * Please thoroughly test the website, including navigation, product links, checkout flow, automated emails and overall user experience. * I believe most of this is working, but I’d like confirmation everything has been checked properly. Priority Issue * I would like these changes done by today if possible Future Work (Please Quote Separately) * Homepage hero video replacement (Liverpool culture/music-focused video). I’m currently waiting on footage, so this will be in around a week’s time. * Embedding our Los Angeles radio station partner into the website and removing the current Shopify audio/list setup. This isn’t a priority right now and can be completed later. That’s pretty much everything for now. I’d love to get this sorted as quickly as possible. Ideally today if possible. Thanks, Amy

urgent

KeyShot Specialist – Plastic Material & Lighting Setup Expert

PROJECT DESCRIPTION We are an established sports equipment brand looking for a KeyShot expert to help us move a set of product renders from a flat, CAD-preview look to true photographic realism, suitable for front-of-pack hero imagery. This is not a standard production render job. We are specifically looking for someone who can develop and dial in the right material, texture, and lighting settings on one or two sample models, then hand over the complete settings package so our existing rendering supplier can apply the same look across our full product range in their own copy of KeyShot. The product is a small, moulded plastic item with subtle translucency. Getting that material quality right is the crux of the brief. We should also mention that our full product range is already set up and organised within KeyShot. Ideally, whatever material presets and lighting rig are developed through this engagement could be applied across that existing setup without having to rebuild or re-import each product individually. If you have experience structuring KeyShot material libraries and scene rigs in a way that makes them portable and easy to apply at scale, please mention this in your response. We will share full project details, reference images, and the CAD model (STEP format) with the shortlisted candidate under a mutual NDA before work begins. WHAT WE NEED FROM YOU BEFORE WE SHORTLIST Rather than a standard cover letter, please answer the following five questions. Your answers will carry more weight than your portfolio in our decision. Honest, specific answers are far more useful to us than vague ones. 1. Which version of KeyShot do you work in, and how long have you been using it professionally? 2. When rendering a soft, slightly translucent plastic (such as a sports mouthguard, silicone grip, or similar), which material type or shader do you use in KeyShot, and what are the two or three settings you pay most attention to in order to get that quality right? 3. How do you approach lighting a small plastic product for a front-of-pack hero shot? Describe your typical setup, including how you use (or choose not to use) an HDRI environment. 4. Once a look is approved, how would you package your settings so that another KeyShot user on a different machine could replicate the result? What files would you provide, and how would you structure those settings so they could be applied across a pre-existing library of models in KeyShot, rather than being tied to a single scene file? 5. Please share one or two examples of previous work involving plastic, rubber, or similarly translucent materials. Links are fine. BUDGET AND TIMELINE Fixed price preferred. To be agreed once we have shortlisted. This is a focused, bounded piece of work rather than an ongoing contract.

Junior Software Developer (Strong English Communication Skills)

About the Role We are looking for a motivated Junior Software Developer who has solid technical fundamentals and excellent English communication skills. You will work closely with our team to develop, test, and maintain software applications while collaborating with stakeholders, participating in technical discussions, and documenting your work clearly. This role is ideal for someone early in their career who is eager to learn, takes ownership of tasks, and can communicate effectively with both technical and non-technical team members. Responsibilities Develop, test, and maintain web and software applications. Write clean, maintainable, and well-documented code. Collaborate with senior developers on new features and improvements. Participate in code reviews and implement feedback. Debug and troubleshoot software issues. Communicate project progress, blockers, and technical solutions in English. Create and maintain technical documentation. Attend team meetings and contribute ideas and recommendations. Learn new technologies and best practices as required. Required Qualifications 1–3 years of software development experience (internships and freelance projects are acceptable). Strong proficiency in spoken and written English. Good understanding of programming fundamentals and software development principles. Experience with at least one modern programming language such as JavaScript, TypeScript, Python, Java, C#, or Go. Familiarity with Git and version control workflows. Understanding of APIs, databases, and web technologies. Ability to explain technical concepts clearly in English. Strong problem-solving skills and attention to detail. Preferred Qualifications Experience with modern frameworks (React, Next.js, Angular, Vue, Django, Laravel, etc.). Familiarity with cloud platforms such as AWS, Azure, or GCP. Experience working with Agile/Scrum teams. Experience using AI development tools such as GitHub Copilot, ChatGPT, Cursor, or similar. English Requirements The ideal candidate should be able to: Participate confidently in English-speaking meetings. Communicate directly with clients or stakeholders when needed. Write clear technical documentation and reports. Explain development decisions and technical issues in fluent English. What We're Looking For Fast learner with a growth mindset. Strong communication and collaboration skills. Self-motivated and dependable. Comfortable asking questions and seeking feedback. Professional attitude and willingness to take ownership. Application Process Please submit: Resume/CV. GitHub profile or portfolio (if available). A short introduction (2–3 paragraphs) in English describing: Your development experience. Technologies you have worked with. Why you are interested in this role. Screening Task (Recommended) To evaluate English communication skills, candidates will complete: A 30-minute English interview. A short coding exercise. A code walkthrough where they explain their solution in English.

Design & Develop a Custom AI SEO Agency Website – WordPress

Project Overview I'm looking for an experienced UI/UX designer and WordPress developer to design and build a premium digital marketing agency website for Sharp Edge SEO. The website should follow the overall structure, user experience, and navigation inspiration of SEO Discovery while maintaining a completely original design using our branding, colours, typography, layouts, icons, and imagery. I have already designed the homepage direction (attached images) and expect the remaining pages to follow the same premium style and consistency. Reference Website (Structure & Navigation Only): SEO Discovery Important Do NOT copy the design. Use it only for page hierarchy, navigation, content flow, and inspiration. The final website must be unique and premium. Scope of Work Phase 1 – UI/UX Design (Figma) Design all desktop, tablet, and mobile layouts. The design should be Modern Premium Clean Conversion-focused Fast-loading SEO-friendly AI-inspired Professional Website Pages Main Pages Home About Us Why Choose Us AI SEO Services SEO Services Local SEO Technical SEO Enterprise SEO Ecommerce SEO Link Building AI Content Writing GEO (Generative Engine Optimisation) Website Migration SEO Audit Digital Marketing PPC Social Media Marketing Content Marketing Case Studies Industries Blog Contact Industry Pages Plumbing Construction Healthcare Legal Real Estate Ecommerce Manufacturing Finance Resource Pages FAQs Glossary Privacy Policy Terms Sitemap Homepage The homepage has already been planned. Use the attached homepage design as the base style. Every internal page should follow the same visual language. Service Page Template Each service page should include Hero Banner Service Overview Benefits Our Process Features Why Choose Us Case Study Industries Served FAQs CTA Section Contact Form Footer About Page Company Story Mission Vision Core Values Our Team Why Choose Sharp Edge SEO Timeline CTA Case Study Page Client Overview Challenge Strategy Implementation Results Traffic Graphs Testimonials CTA Blog Blog Listing Blog Details Related Posts Author Box Categories Search Share Buttons CTA Contact Page Contact Form Google Map Office Information WhatsApp Phone Email FAQ CTA Navigation Structure Main Navigation Home Who We Are Services AI SEO Local SEO Technical SEO Ecommerce SEO Enterprise SEO Link Building Website Migration SEO Audit Digital Marketing PPC Social Media Content Marketing Industries Case Studies Resources Contact Homepage Sections Hero Trust Signals Awards Services Industries Why Choose Us Our Process Statistics Case Studies Testimonials Latest Blogs FAQs Final CTA Footer Design Style Use White backgrounds Dark navy sections Orange highlights Rounded cards Soft shadows Glassmorphism where suitable Premium icons Custom illustrations AI imagery Interactive hover effects Professional typography Generous spacing Features Required Responsive WordPress Elementor Pro compatible Fast loading Core Web Vitals optimised SEO ready Schema ready Google Reviews integration WhatsApp floating button Sticky CTA Sticky navigation Breadcrumbs Mega Menu Blog Case Studies Advanced Contact Forms Animations Lazy Loading Image Optimisation Security Best Practices Forms Homepage Audit Form Contact Form Free Strategy Form Book Consultation Newsletter SEO Requirements Proper Heading Structure Schema Breadcrumbs Internal Linking Optimised URLs Fast Performance Image Optimisation Meta Fields XML Sitemap Deliverables Complete Figma Design WordPress Website Responsive Design Elementor Templates Global Style Guide Icons & Assets Basic On-page SEO Speed Optimisation Training on Website Management What to Include in Your Proposal Portfolio of similar agency websites Figma examples WordPress examples Estimated timeline Total fixed price Technologies used Post-launch support period Attached Files Homepage Design (Latest Version) Service Page Design Brand Logo Brand Colours Website Content (to be provided) The goal is to build a high-end AI SEO agency website comparable in quality to leading digital marketing agencies, with a strong emphasis on conversions, clean UX, excellent SEO architecture, and premium visual design inspired by the attached mockups and the navigation structure of SEO Discovery.

opportunity

FULL TIME PODCAST EDITOR NEEDED- UK

Full-Time Podcast Editor (Remote – Europe Preferred) Storyhouse Studios is looking for a talented full-time Podcast Editor to join our growing team. We produce high-quality podcasts and video content for entrepreneurs, creators, founders, and industry leaders. We're looking for someone who can do more than simply cut between cameras—we need an editor who understands pacing, storytelling, audience retention, and how to create engaging content from long-form conversations. Requirements Expert knowledge of Adobe Premiere Pro (latest version) Strong understanding of multi-camera podcast editing Experience syncing and editing separate audio recordings Ability to work independently and manage a consistent editing schedule Strong storytelling instincts and editorial judgement Excellent attention to detail Reliable internet connection and communication skills Fluent English The Role You will be editing approximately 1–2 podcast episodes per day, social clips and trailers Typical projects include: 3-camera podcast setups Separate audio recordings requiring syncing and cleanup Tightening conversations by removing repetition, pauses, tangents, and sections that don't add value Creating the strongest possible narrative flow while maintaining the authenticity of the conversation Adding intro/outro graphics and basic branding elements where required Exporting episodes to our delivery specifications What We're Looking For We're not looking for someone who simply assembles footage. We want an editor who can: Identify the most engaging moments Improve pacing and flow Cut unnecessary content Make conversations feel sharper and more impactful Understand audience retention and what keeps viewers watching Preferred Experience editing business, interview, or conversational podcasts Experience creating short-form clips from long-form content Basic audio mixing and cleanup skills Knowledge of YouTube podcast formats and audience retention principles ### To Apply Please send: 1. Your CV or portfolio 2. Examples of podcast edits you've completed 3. Your expected monthly salary 4. Your location and timezone 5. A short explanation of your editing process We're ideally looking for someone based in Europe so working hours closely align with our team. One thing I'd add: include a short paid editing test (15–20 minutes of raw podcast footage). You'll learn more from that than from a portfolio, especially when evaluating whether someone can identify weak sections and improve storytelling rather than just edit technically.

Social media set up plus canva & mailchimp with LinkedIn

Clear-Rec Ltd – Complete Digital Marketing & Social Media Setup Brief (Free Version) Objective Create a professional, consistent online presence for Clear-Rec Ltd that promotes our education recruitment services, generates candidate registrations and school enquiries, and allows all marketing channels to work together using free software wherever possible. ⸻ 1. Branding Use the same branding across every platform. Create: * Company logo * Profile picture * Cover/banner image * Brand colours * Brand fonts Create Canva templates for: * Job adverts * Candidate profiles * Client testimonials * Recruitment tips * School support information * Company updates * “We’re Hiring” graphics * Meet the Team * Candidate of the Week * School Vacancies * Success Stories Free software: * Canva Free ⸻ 2. Website Website: www.clear-rec.co.uk Check: * Contact forms * Mobile optimisation * SEO * Google Maps * Candidate registration * Employer enquiry form * CV upload * Privacy Policy * Cookie Policy Connect with: * Google Analytics * Google Search Console Free tools: * Google Analytics * Google Search Console ⸻ 3. Create & Optimise Social Media Create and fully optimise: * LinkedIn Company Page * Facebook Business Page * Instagram Business Account * TikTok Business Account * YouTube Channel * Google Business Profile Every account should include: * Company logo * Matching banner * Business description * Website: www.clear-rec.co.uk * Phone: 07920 480812 * Business email * Consistent branding * Call to Action * Keywords around Education Recruitment and School Support Recruitment ⸻ 4. Connect Everything Together Connect Facebook and Instagram through Meta Business Suite. Link: * Facebook ↔ Instagram * Instagram ↔ Threads (optional) * LinkedIn ↔ Website * TikTok ↔ Website * YouTube ↔ Website * Google Business ↔ Website ⸻ 5. Free Social Media Scheduling Use: Meta Business Suite (Free) Schedule: * Facebook * Instagram Use: LinkedIn Native Scheduler (Free) Schedule LinkedIn posts. Use: TikTok Scheduler (Free) Schedule TikTok videos. Use: YouTube Studio (Free) Schedule YouTube videos and Shorts. This means every platform can be scheduled for free without paying for Hootsuite or Buffer. ⸻ 6. Email Marketing Create: * Mailchimp Free Account Set up: * Candidate mailing list * School mailing list * Temporary staff list * Permanent recruitment list Create automated emails: * Welcome email * Candidate registration confirmation * School enquiry acknowledgement * Monthly newsletter * Job alerts ⸻ 7. Google Business Create a Google Business Profile. Include: * Services * Photos * Opening hours * Website * Phone number * Reviews * Regular updates ⸻ 8. Content Plan Create a monthly content calendar. Aim for: * 3–5 LinkedIn posts each week * 3 Facebook posts each week * 3 Instagram posts each week * 2 TikTok videos each week * 1 YouTube video or Short each week Content ideas: * Latest vacancies * Recruitment tips * School support roles * Candidate success stories * Testimonials * Interview advice * Compliance guidance * Behind the scenes * Meet the team * School business manager insights * Finance, HR and administration recruitment * Facilities, catering and cleaning recruitment * Education news ⸻ 9. Graphics Design branded templates for: * Drama vacancies * Teaching Assistant jobs * School Business Manager jobs * Finance vacancies * HR vacancies * Admin vacancies * Cleaning vacancies * Catering vacancies * Site Manager vacancies Use Canva Free. ⸻ 10. SEO Optimise your website for keywords such as: * Education Recruitment * School Support 13. Free Software to Use * Canva Free – graphics * Meta Business Suite – Facebook & Instagram scheduling * LinkedIn Scheduler – LinkedIn scheduling * TikTok Scheduler – TikTok scheduling * YouTube Studio – YouTube scheduling * Mailchimp Free – email marketing * Google Analytics – website analytics * Google Search Console – SEO monitoring * Google Business Profile – local visibility * Google Drive – document storage *

opportunity

Linkedin Content Strategist & Daily Engagement Partner

I’m the Retail Director at a UK-based freight forwarding company. I want to build a strong, authentic personal brand on LinkedIn in the freight, logistics and supply chain space — with a particular focus on retail sector challenges and solutions. My goals: • Become a recognised voice and thought leader • Grow my follower base with the right people (retailers, supply chain/procurement professionals, logistics peers, decision-makers) • Increase meaningful engagement and inbound opportunities • Stay super active and visible in a smart, sustainable way I already create my own posts and graphics. I’m looking for a strategic partner who will guide the “what” and “when”, while also handling the heavy lifting on daily engagement. What you’ll be responsible for: 1. Content Strategy & Storyboarding Develop clear content pillars tailored to a Retail Director in freight forwarding. Create weekly/bi-weekly content calendars with post ideas, recommended formats (carousels, text, polls, short video, documents, etc.), strong hooks, and calls-to-action. Provide outlines or suggested copy (I will write the final versions and create all graphics). 2. Posting Schedule & Activations Recommend the best days/times for a UK B2B audience in 2026. Advise on LinkedIn algorithm best practices, what “activations” actually move the needle (polls, carousels, series, commenting strategies, etc.), and how to maximise reach and engagement. 3. Daily Niche Engagement (core part of the role) Thoughtfully comment on 20–50 relevant LinkedIn posts per day in the freight, logistics, supply chain, retail, and import/export space. Comments must be high-quality, value-adding and non-spammy (sharing insights, asking smart questions, adding perspective). This is manual work only. The goal is visibility, relationship-building and algorithm love. You’ll report on activity and results. 4. Follower Growth & Overall Strategy Give ongoing advice on profile optimisation, networking, content repurposing, and how to best use my current Botdog automation tool alongside organic activity. Help me market myself effectively and accelerate follower growth in a compliant way. 5. Reporting & Collaboration Weekly or fortnightly check-ins (Zoom or async) to review LinkedIn analytics, discuss what’s working, refine the strategy, and plan ahead. Track progress against clear KPIs (follower growth, engagement, profile views, quality of comments, etc.). What I will handle: • Writing and publishing all final posts + creating graphics • Day-to-day posting on my profile • Giving you any sector-specific insights you need Ideal freelancer: • Proven experience helping B2B executives or professionals grow their LinkedIn presence through content strategy + daily engagement (please share real results or case studies). • Strong understanding of current LinkedIn best practices (2026 algorithm, personal branding, what actually works for B2B service/industry profiles). • Excellent at crafting professional yet conversational B2B content ideas — especially in freight, logistics, supply chain or retail (prior experience in these sectors is a big plus). • Reliable and disciplined with daily engagement work. You enjoy being active on LinkedIn and know how to comment in a way that builds genuine connections. • Comfortable working with or advising on tools like Botdog. • UK/EU timezone preferred (or very flexible). • 100% committed to staying within LinkedIn’s Terms of Service (manual, high-quality commenting only — no automation for comments). How we’ll work: This is an ongoing role. I’d like to start with a 4-week trial, then move to a monthly retainer if it’s a good fit. Please include in your proposal: • Why you’re the right person for this (and any relevant niche experience) • Your approach to daily commenting (include 2–3 examples of strong vs weak comments in a B2B context) • 3–5 suggested content pillar/theme ideas specifically for a Retail Director in freight forwarding • A sample 1-week content idea list (5–7 post concepts) • Your proposed weekly time commitment and rate (hourly or monthly package) • Links to relevant work, portfolio, or your own LinkedIn profile so I can see your style and results Indicative budget: £800 – £1,100 per month (depending on experience, hours and results). Quality and reliability are more important than the lowest price. Realistic proposals welcome. I’m looking for a long-term partner who is proactive, strategic, and excited about helping me become consistently visible and valuable on LinkedIn. Looking forward to your proposals

3D Printable Wall-Mounted Vertical Ant Farm Model Design Needed

I am looking for someone to design a vertical wall-mounted ant farm model that can be 3D printed. The model needs to be practical, secure, and designed properly for printing. It should be suitable for ants, with natural-looking tunnels and chambers visible from the front. The design will need to be supplied as printable STL/STEP files. ⸻ Main Design Requirements The ant farm should be designed as a vertical wall-mounted unit. It needs to: * Be easy and secure to wall mount. * Have a strong rear body/frame. * Include mounting holes or keyhole-style wall fixings. * Be stable once fitted to a wall. * Be suitable for 3D printing without unnecessary supports where possible. ⸻ Front Perspex Panel The front needs a recessed area to hold an A4 sheet of 3 mm Perspex. The Perspex size will be: 297 mm wide x 210 mm tall x 3 mm thick Please note: the Perspex must sit neatly into the front recess. The model also needs screw holes around the front so the Perspex can be fixed securely using M3 screws. I would like the screw holes positioned neatly around the Perspex, with enough support around them so the print does not crack when tightened. ⸻ Magnet Slots The model also needs small recesses for magnets to be glued into place. Magnet size: 4 mm wide x 2 mm deep These should be placed in sensible positions to help secure interchangeable side parts, covers, or connection pieces. The magnet holes should be slightly oversized to allow for glue and tolerance. ⸻ Natural Tunnel System The main visible section needs to include a natural-looking tunnel system, similar to the example image supplied. The tunnels should not look too geometric or artificial. I want: * Natural burrow-style tunnels. * Wider cave areas/chambers. * Larger voids for breeding, resting, or storing food. * Multiple routes up, down, left, and right. * Interconnecting tunnels. * Tunnels and chambers fully visible from the front through the Perspex. * Enough depth for ants to move comfortably. The tunnels should feel organic, but still printable and easy to clean where possible. ⸻ Side Connection System The design needs interchangeable side sections on both sides. These side sections should allow the user to either: 1. Connect multiple ant farm units together, or 2. Block the side opening if only using one unit. So I need: * Left and right side connection points. * Removable connector parts. * Removable blanking/blocking parts. * Secure fitting using magnets, screws, or a simple mechanical slot system. * The ability to expand the ant farm in the future by adding more printed units. ⸻ Foraging Area The design needs a foraging area built into it. This should be separate from the main tunnel section but connected so ants can access it. The foraging area needs to be large enough for: * Ants to explore. * Food to be placed inside. * Easy access for maintenance. * Good visibility. ⸻ Water / Sweet Water Area The model also needs a dedicated area large enough to place water or sweet water. This could be designed as: * A small removable tray area. * A recess for a small test tube/water tube. * A space to place a small feeding dish. I am open to suggestions on the best option, as long as it is practical, safe for ants, and easy to refill. ⸻ Printing Requirements The model must be designed for FDM 3D printing. Please design with the following in mind: * Printable on a standard large-format 3D printer. * Strong walls. * Minimal supports where possible. * Sensible tolerances for Perspex, magnets, screws, and connectors. * Parts should be split if needed to make printing easier. * The design should not rely on very fragile details. * Wall-mounted strength is important. Ideally, I would like files supplied in: * STL * STEP, if possible * Separate files for the main body, side connectors, blanking plates, and any removable parts ⸻ Style Reference I have attached an image showing the style I like. The tunnel system should be visible from the front and have a natural cave/burrow look, rather than straight lines or basic grids. I want the final design to look clean, modern, and functional, while still feeling like a natural ant habitat. ⸻ Final Deliverables Please provide: * Full 3D printable model files. * Separate printable parts where needed. * A version with the A4 Perspex recess. * Side connector pieces. * Side blanking/blocking pieces. * Magnet recesses. * M3 screw holes for the Perspex. * Wall mounting points. * Any notes on print orientation and assembly. ⸻ Important Notes The design must be practical, not just visually nice. This will be printed and used, so tolerances, strength, Perspex fitting, wall mounting, and ant access all matter. Please include examples of previous 3D printable product designs or functional models you have created. Designs for enclosures, terrariums, aquariums, modular systems, or mechanical parts would be helpful.

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.