Suit Projects

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

AI Video Expert for Photorealistic Skincare Product Reels

ChatGPT generated applications will be ignored - please write to me in your own words. We are looking for an experienced AI video generation specialist to create approximately 20 short, photorealistic video clips, each around 2–4 seconds long, for a professional skincare and post-treatment product range. These clips will later be edited together into short Instagram and TikTok reels. This role is focused on generating the individual cinematic clips rather than editing one complete reel from start to finish. This is not suitable for someone who has only experimented casually with AI video. We need a specialist who understands how to select and use different AI video models depending on the scene, achieve realistic human movement and skin texture, maintain accurate product proportions and create polished footage that does not look obviously AI-generated. The type of footage required The clips will include a mixture of: Cinematic skincare product reveals Luxury product shots using supplied reference images Realistic cream textures and application Clients resting after professional skin treatments Naturally flushed post-treatment skin Practitioners working in professional clinic environments Close-up treatment and aftercare moments Products being placed into aftercare bags or handed to clients Slow, premium camera movements suitable for luxury skincare advertising The overall aesthetic must feel: Photorealistic, cinematic, premium, professional and believable. We do not want plastic-looking skin, distorted hands, unrealistic anatomy, warped packaging, altered labels or generic “AI spa” footage. Branding and creative direction We will provide: Product images and packaging references Brand logos Website links Existing carousel graphics and AI-generated imagery for visual inspiration Colour palettes and brand direction A detailed description of each required clip Prompts and key instructions for the scenes You will be expected to follow the supplied branding closely and maintain visual consistency across all clips. The product packaging must remain recognisable and correctly proportioned. Bottle shapes must not be shortened, widened or distorted, and sachets must appear at an accurate scale beside larger products. All written overlays, logos and final captions will normally be added during editing, so the generated footage should be clean and suitable for text placement. Essential experience You must have strong practical experience using several leading AI video-generation models and understand which model is best suited to different types of footage. Experience with tools and models such as the following is highly desirable: Google Veo Kling Runway Adobe Firefly Sora Luma Hailuo Seedance Other photorealistic image-to-video and text-to-video models You should understand: Text-to-video and image-to-video workflows Reference-image consistency Product animation Realistic skin and facial detail Natural hand and body movement Cinematic lighting Camera movement and framing Vertical 9:16 social-media production Negative prompting and artefact reduction How to identify and reject visibly distorted generations How to create several variations and select the strongest result Experience producing content for skincare, cosmetics, beauty, aesthetics, PMU, tattooing or professional treatments would be particularly valuable. Need: Approximately 20 finished video clips Each clip approximately 2–4 seconds long Vertical 9:16 format High-resolution output suitable for Instagram Reels and TikTok Clean footage without added captions unless specifically requested Consistent colour grading and visual style Organised, clearly labelled files Reasonable revisions where anatomy, packaging or movement is visibly incorrect The final number of clips may change slightly as the project develops. Quality expectations The footage must not look obviously AI-generated. We will not accept clips containing: Distorted or changing product packaging Incorrect logos or altered labels Squashed or widened bottles Extra or fused fingers Unnatural hands or limbs Plastic-looking skin Strange eye or facial movement Overly dramatic or surreal movement Generic, fake-looking clinical environments Inconsistent products between clips Attention to detail is essential. When applying Include: Examples of your best photorealistic AI-generated videos Examples of skincare, beauty, product or human-focused work The AI video models you use most confidently Your preferred workflow for maintaining product consistency Confirmation that you can work from supplied reference images and detailed prompts Your estimated cost for approximately 20 clips of 2–4 seconds each Turnaround time Whether your price includes generation credits and revisions Please do not apply with generic AI showreels full of fantasy scenes, animation or dramatic visual effects. We specifically need someone who can produce subtle, realistic, premium commercial footage.

opportunity

Bespoke Online Booking System for External Assessors

OVERVIEW We're a care home group with 8 homes. We need a simple, self-service web booking tool for external assessors (DoLS Best Interests Assessors, CHC assessors, FNC reviewers, IMCAs, and others) to book their own visit slots to assess a resident. Currently done manually by phone/email — slow and time consuming. We want this replaced with a lightweight tool. WHO USES IT External assessors (primary users) — book their own slot, no account hassle. Our central Assessments and Contracts team (oversees all 8 homes) — configures settings and sees all bookings. CORE FEATURES Public booking page(s) — one per home or a single page with a home selector. Assessment type selection (DoLS, CHC, FNC Review, DST, IMCA, Best Interests Meeting, "Other" free text) — expandable later. Live availability & direct booking — no manual approval needed for MVP. Configurable minimum notice period per assessment type — e.g. DoLS bookable next day, CHC needs 2 weeks minimum, others TBC. Must be adjustable by our Assessments and Contracts team via a settings screen, not hardcoded. Outlook Calendar integration (Microsoft Graph API) — bookings sync with real per-home calendars and auto-create events. Automatic confirmation/reminder emails to assessor and home contact on booking, change, or cancellation. Microsoft Teams integration — auto-generate a Teams link for remote/hybrid visits. Booking form fields: assessor name/organisation/email/phone; resident's name; resident's DOB or NHS number; assessment type; "will staff time be required?" (Y/N); "will medical records be required?" (Y/N); "has NOK been notified?" (Y/N); free-text notes. Self-service reschedule/cancel via link in confirmation email. Central dashboard for the Assessments and Contracts team — view bookings across all homes, manage notice-period settings. NICE-TO-HAVES (not required for MVP) Per-home blackout dates; CSV/Excel export; SMS reminders. TECHNICAL PREFERENCES Must integrate with Microsoft 365 (Outlook + Teams) via Graph API or equivalent — no third-party calendar system. Freelancer's choice of platform/stack, as long as it integrates well with M365 and is easy for us to maintain (please explain your approach, e.g. Power Apps/Power Automate vs custom web app). Mobile-friendly, since assessors will often book from their phone. DATA PROTECTION Resident DOB/NHS number plus assessment type counts as special category health data under UK GDPR. Please address in your proposal: hosting/encryption (at rest & in transit); who can view resident-identifying records; retention/auto-purge policy; relevant experience with health-adjacent data in a UK/CQC-regulated context. No full medical records/care notes should be stored in the tool. DELIVERABLES Working system live across all 8 homes, link shareable with assessors. Outlook sync + Teams link generation, tested. Short (1-2 page) admin guide for the Assessments and Contracts team. Handover of admin credentials/access. BUDGET & TIMELINE Under £500 (MVP scope). A few weeks. Open to a phased approach — core booking + calendar sync first, nice-to-haves later if budget allows. PLEASE INCLUDE IN YOUR PROPOSAL Proposed tech approach and why it suits Microsoft 365; relevant experience with booking systems/Graph API/Outlook/Teams integrations; rough timeline and milestones; assumptions/questions given the budget.