Website Development 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.

opportunity

HealthTech Market Validation & Pilot Recruitment Specialist

# Freelance Market Research & Pilot Recruitment Specialist (HealthTech) ## Overview We are looking for an experienced freelance researcher to help validate a new AI-powered health technology product aimed at private healthcare clinics. The goal is not to sell a product. The goal is to conduct structured customer discovery interviews and identify potential pilot partners. This is a short-term project focused on learning, validation and pilot recruitment. ## About the Product We are building an AI-powered health intelligence platform that helps clinicians review and explain blood test results more efficiently. The platform generates patient-friendly reports, highlights longitudinal trends, and supports clinician review before reports are shared with patients. Target customers include: * Longevity clinics * Functional medicine clinics * Thyroid and hormone clinics * Menopause clinics * Private GP practices ## Project Objectives The successful freelancer will: ### 1. Build a Target List Identify and create a database of: * UK longevity clinics * Functional medicine clinics * Thyroid/hormone clinics * Menopause clinics * Relevant private GP practices For each clinic provide: * Clinic name * Website * Contact details * Key decision makers * LinkedIn profiles (where available) ### 2. Conduct Discovery Outreach Reach out to clinics via: * Email * LinkedIn * Phone (where appropriate) The objective is to secure discovery conversations. No hard selling required. ### 3. Conduct Structured Interviews Interview clinicians and clinic owners to understand: * Current blood test interpretation workflows * Time spent reviewing results * Current reporting process * Pain points * Existing software used * Attitude towards AI-assisted reporting * Willingness to participate in pilots ### 4. Produce Research Findings Summarise: * Key themes * Common pain points * Feature requests * Objections * Buying signals * Recommended target segment ### 5. Recruit Pilot Clinics Goal: Secure interest from 3–5 clinics willing to evaluate a pilot programme. ## Deliverables ### Deliverable 1 Target clinic database Minimum: * 100 clinics ### Deliverable 2 Interview findings report Including: * Key insights * Market feedback * Adoption risks * Recommendations ### Deliverable 3 Pilot recruitment report Including: * Interested clinics * Contact details * Next steps * Level of interest ## Ideal Candidate Experience in one or more of: * HealthTech * Digital health * Healthcare consulting * Healthcare market research * B2B SaaS customer discovery * Pilot programme recruitment Experience speaking directly with clinicians is highly desirable. ## Success Criteria Success will be measured by: * Number of clinician conversations completed * Quality of insights gathered * Identification of common workflow pain points * Number of clinics expressing pilot interest ## Proposal Requirements Please include: 1. Relevant experience 2. Examples of similar projects 3. Proposed approach 4. Estimated timeline 5. Fixed-price quote This project is focused on learning and validation. We are looking for someone who can uncover genuine market insights rather than simply generate leads.

opportunity

Tidy the server from X-ransom attack

Hello, Our Wordpress website was attacked by x-ransom. We have a backup of the WP and the database dump. We have detected some corrupted files there but it seems that there are still some left that were not detected. It has to be tidy after the attack. It’s an internet shop with uploads files of around 100GB. It’s stored on a private hosting in LV. What is done do far: 1. Update WordPress Version 2. Use z’d updateSecure WP-Admin Login Credentials 3. Set Up Safelist and Blocklist for the Admin Page 4. Use Trusted WordPress Themes 5. Install SSL Certificate 6. Remove Unused WordPress Plugins and Themes 1. Enable Two-Factor Authentication for WP-Admin 2. Back Up WordPress 3. Limit Login Attempts 4. Change the WordPress Login Page URL 5. Log Idle Users Out Automatically 6. Monitor User Activity 7. Check for Malware - found several none-Wordpress specious files and plugins. Deleted them. 1. Disable PHP Error Reporting 3. Turn File Editing Off 4. Restrict Access Using the .htaccess File 5. Change the Default WordPress Database Prefix - not done 6. Disable XML-RPC 7. Hide the WordPress Version 8. Block Hotlinking - not done 9. Manage File Permissions not done After making the list, we received another x-ransome attack. I suspect he has a server level access not only wp level. If you apply, you need to be a server security and a Wordpress specialist. Please, quote for the job.

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

opportunity

Pattern maker and seamstress for athleisure wear

I am looking for a pattern maker who can create a sweatshirt pattern (I've got some rough ideas of having a slightly more curved and oversized sleeve), as well as a seamstress who can sew together the pattern pieces once they have been printed and dyed. (If you are both a pattern cutter and seamstress that would be amazing.) I need the final sweatshirts (5 in total) to be of high quality as I will be showing them at my postgrad degree show, my website and possibly to an independent boutique. Looking for a quick turnaround for both patterning and sewing. Many thanks Funmi