Podcast Editing Projects

Operations Manager & Executive Assistant (High-Level Operator)

Overview: I run a marketing business and I’m looking for a highly capable operator to take ownership of multiple ongoing projects and act as my right-hand person. Some business related, some personal. This is not a basic VA role. I need someone who can think, organise, execute, and drive tasks to completion without needing constant direction. You will be responsible for managing projects, coordinating freelancers, handling admin tasks, and ensuring everything moves forward efficiently. As well as acting as my Executive Assistant. Your job is essentially to get things done to a high standard, or driving things to completion, that I can't or don't have the time to do. --- **Key Responsibilities:** **1. Project & Operations Management** * Take ownership of multiple business projects including: * Completing an online course (editing, structuring, uploading) * Managing website completion with developers * Coordinating legal/admin processes (UK company liquidation, insurance, etc.) * Setting up systems (payments, Stripe, workflows) * Break down tasks into clear steps and execute them * Hire and manage freelancers where needed * Ensure all projects are completed to a high standard and on time --- **2. Executive Assistant / Personal Support** * Manage day-to-day admin tasks * Arrange travel, bookings, and logistics * Organise schedules and appointments * Handle general life admin where required --- **3. Hiring & Team Coordination** * Post job listings (e.g. social media, personal brand roles) * Screen candidates and present top options * Coordinate onboarding and communication --- **4. Communication & Workflow** * Act as the central point of coordination across all tasks * Provide clear updates and next steps * Keep everything organised and moving forward --- **How We Will Work Together:** * I communicate heavily via **voice notes** - I am diagnosed ADD and this is part of the reason I require this type of assistance and structure. * You must be comfortable receiving instructions this way and converting them into actions * You should be available **7 days a week when needed** (not necessarily full days, but responsive) * You will only involve me for: * key decisions * approvals * completion of tasks that require my involvement --- **Requirements:** * Excellent written and spoken English (clear, neutral accent preferred) * Highly organised and proactive * Strong problem-solving ability * Able to take ownership and execute without hand-holding * Experience managing freelancers and projects * Comfortable with tools like Google Docs, Slack, Notion, etc. --- **Important:** * This role requires initiative — not just following instructions * You must be able to think ahead and anticipate what needs to be done * High standards are essential --- **To Apply:** Please include: 1. A brief introduction about your experience 2. Examples of similar roles you’ve handled 3. Your availability and time zone --- **Initial Engagement & Long-Term Opportunity** This role will begin with an initial 15–30 day project focused on organising and executing a defined list of tasks across the business. The goal of this initial phase is to: * get key projects completed efficiently * establish strong working processes * assess fit and performance For the right person, this has strong potential to become an ongoing, long-term role as my right-hand operator across the business. **Goal:** To have a right-hand operator who removes execution and admin from my plate, allowing me to focus only on high-level decisions and content.

opportunity

Discord Shop Bot + Merchant Control Panel Development

Discord Shop Bot + Merchant Control Panel Development I am looking for an experienced developer to build a Discord shop bot with a web-based merchant control panel. The bot will allow merchants to sell products directly through Discord using an interactive checkout flow connected to my payment gateway APIs. CORE BOT FUNCTION Certain roles in Discord should be able to start a purchase session using a command such as: /pay @customer Once started, the customer will go through a guided shopping experience inside Discord. SHOPPING FLOW 1. Product Selection Customer sees product categories Then selects products Then selects product variations (each variation may have a different price) 2. Cart System Customer can add multiple items Customer can go back and add additional items before checkout 3. Order Questions Customers are asked questions related to the category or product Merchants can define these questions in the control panel 4. Coupon Codes Customer is asked if they have a coupon code Coupons are created in the merchant panel Coupons can apply to specific products or categories 5. Tips Customer is asked if they want to send a tip Merchant can enable or disable tips in the panel Customer can enter the tip amount 6. Payment Options Customer is given two payment options: Pay Pay with Crypto Both options will connect to my existing payment gateway API. PAYMENT CONFIRMATION Once payment is confirmed: Customer receives a message saying: "Thank you, we have received your payment." An order log message is sent to a merchant log channel containing: Customer details Items purchased Answers to order questions Payment details Under the order message there should be a button: RED: Needs Action When the merchant processes the order they click the button and it changes to: GREEN: Completed REWARDS / POINTS SYSTEM The bot should support a customer reward system. Customers earn 1 point for every £1 spent. Merchants can choose which categories or products earn points. Merchants can set the value of 1 point in the panel. During checkout the customer enters their email address. The bot checks if the email already has a points balance. If points exist the bot asks: "Would you like to use your points?" Customers can check their points balance anytime using: /points They will enter their email to see their current balance. Merchants must also be able to manually add, remove, or edit points from the panel. REFERRAL SYSTEM Customers can refer others using: /refer Flow: User enters their email User enters the new customer’s email Then: A thank you message is sent to the person who referred The message content can be customized in the merchant panel A log message is sent to a channel showing: Email A referred Email B When the referred customer makes a purchase, the referrer receives reward points. Merchants can set referral rewards in the panel. Rewards can apply to specific categories or products. The reward value is set as money but given as points. MERCHANT CONTROL PANEL A simple web-based panel is required where merchants can manage everything. Server Settings Enable or disable features Set admin roles Set log channels Set currency Payment Settings Enter crypto wallet address for payouts Enter wallet address for crypto payments Enable or disable payment methods Products Create categories Add products Add product variations Set prices Add order questions Edit or delete products Coupons Create coupon codes Set which categories or products they apply to Rewards Enable reward system Set point value Select which products or categories earn points Referral System Enable referrals Set reward amounts Choose which products or categories give referral rewards Customers View customer emails View points balances Manually edit or remove points CURRENCY Default currency should be GBP. Merchants should also be able to change currency to: EUR USD IMPORTANT The panel must be very simple and easy to use. Each section should include help text explaining what the feature does so merchants do not get confused. API I already have the payment gateway APIs for: Pay (https://documenter.getpostman.com/view/15018241/2sBXc7JiY7 will use Multi-provider Mode) Pay with Crypto (https://documenter.getpostman.com/view/52669564/2sBXcGDfCj) will use muiti hosted feature) These will be provided to the developer. WHAT I AM LOOKING FOR Experienced Discord bot developer Experience building admin panels or dashboards Clean and scalable code Good communication If you have built Discord shop bots, payment bots, or e-commerce bots before, please include examples in your proposal. DO NOT MESSAGE IF YOU CANNOT DO THIS. I LOOKING TO HAVE THIS CREATED WITHIN 7 DAYS AND I NEED THE PERSON TO LOAD THIS ONTO MY VPS SO ITS ALL WORKING. If you are David Olusanya on here do NOT send me a proposal you are a scammer

Brochure for International Tattoo Convention and Gathering

We are looking for a graphic designer (hourly) to help us turn an existing document into a professional brochure for an international tattoo artist trip and convention happening in Thailand in 2026. This brochure will be sent to pre-registered tattoo artists who are considering joining the trip. Project Overview We are hosting an International Tattoo Artist Trip in Thailand (July 1–13) where a group of artists will travel together across multiple cities and tattoo at a major festival.  The trip includes: • Bangkok arrival and city exploration • Travel to Ubon Ratchathani for the Artistic Ink Festival • Tattooing at the convention • A Pattaya artist retreat after the convention • Team travel, networking, and content creation with international artists.  Only 20 artist spots are available, so the brochure needs to look high-quality and professional.  We are looking for a high quality finish like shown in this example: https://fn.capzula.com/storage/v1/object/public/frontend-assets/seller-pdfs/Capzula%20For%20Sellers%20-%20English.pdf ⸻ What We Need Designed We already have the written content completed. We need a designer to turn it into a clean, visually appealing brochure. Expected deliverables: • 6–8 page brochure • PDF format for email distribution • Clean modern layout • Tattoo / travel aesthetic • Easy to read itinerary and pricing sections • Designed for mobile viewing and desktop Sections that will be included: 1. Trip introduction 2. Founding artist team concept 3. Trip overview 4. Full travel schedule 5. What’s included / not included 6. Artist package pricing 7. Proper artist credit program 8. Cost breakdown The brochure explains the $3,000 artist package, travel schedule, and the 1:1 Proper product credit program for artists.  ⸻ Style Direction We want something that feels: • Premium • Tattoo industry aesthetic • International travel vibe • Clean and modern Examples of visual elements we like: • Tattoo photography • Thailand imagery • Dark / premium color palettes • Strong typography ⸻ What We Will Provide • Full written document (already completed) • Brand assets (logos, colors) • Direction on sections and layout • Photos if needed ⸻ Deliverables • Final brochure PDF • Editable source file (Illustrator / InDesign / Canva) ⸻ Budget Open to hourly designers. This should likely take 3–6 hours for someone experienced with brochure design. ⸻ To Apply Please send: • Portfolio examples • Previous brochure / PDF work • Estimated hours Tattoo industry experience is a plus but not required.

opportunity

Illustrator and animator for TikTok content

We are looking for a freelance content creator to help us turn a bank of fun content ideas into engaging TikTok content. This is not just an illustration brief. We need someone who can take rough ideas and direction from our team, develop them into simple but effective cartoon-led content, create the assets, and help us manage the process through to post-ready delivery. Depending on the setup, this may also include uploading and posting content to TikTok with guidance from our side. The concept may sit under a standalone TikTok identity rather than an obvious agency brand, so we are looking for someone who understands how to create content that feels natural to the platform rather than overly polished or corporate. What the role involves You would be expected to: take rough ideas, prompts or loose scripts from us and shape them into short-form content concepts create cartoon-style visual assets, including static cartoon cells, character scenes and simple illustrated formats ideally animate those assets into short videos or light-motion content suitable for TikTok add captions, pacing and simple editing so the content feels native to the platform work with light creative and editorial guidance from our team help organise the content creation process from idea through to finished assets potentially support with scheduling or posting content to TikTok once agreed What we are looking for We are looking for one person who is: creatively strong and visually sharp tuned into TikTok and understands what performs on the platform able to work independently and take ownership of the process comfortable with humour, character-led content and repeatable content formats fast, practical and not prone to overcomplicating things affordable and open to ongoing freelance work ideally based in or near Surrey, UK, as there may be value in occasional in-person collaboration fluent in English, with strong written and spoken communication Nice to have experience creating content for TikTok or Instagram Reels character design skills simple 2D animation or motion graphics ability experience writing captions or shaping content for social confidence suggesting improvements to ideas rather than only executing briefs experience posting directly to TikTok Please include in your application examples of relevant cartoon, illustrated or animated content links to any TikTok or short-form social content you have created or managed your rates, whether per piece, per batch or per day a short note on how you would turn rough ideas into a repeatable TikTok content series your location and whether you are available for occasional in-person collaboration in Surrey. Additional notes We are not looking for a large studio or expensive production setup. We are looking for one reliable freelance creator who can think creatively, move quickly and help run the process end to end. There is potential for ongoing work for the right person.

opportunity

SurgeX Instagram Brand System

I am building a performance training brand called SurgeX. SurgeX focuses on a training philosophy called: Strength + Flow - •⁠ ⁠Kettlebell strength training •⁠ ⁠Mobility and movement systems •⁠ ⁠Endurance performance (running, swimming, cycling) •⁠ ⁠Breathwork and nervous system regulation The goal is to create a clean, premium Instagram visual system that positions SurgeX as a modern performance training method, not just a personal trainer page. The visual style should feel similar to: •⁠ ⁠endurance performance brands •⁠ ⁠running magazines •⁠ ⁠minimalist editorial fitness design - •⁠ ⁠The Purpose Company •⁠ ⁠endurance / running brands •⁠ ⁠modern performance brands The overall aesthetic should feel: •⁠ ⁠Premium •⁠ ⁠Athletic •⁠ ⁠Minimal •⁠ ⁠Intelligent •⁠ ⁠Performance focused Brand Philosophy SurgeX is built around the concept: Strength + Flow Meaning: Strength training + mobility integration = real performance. The method focuses on: •⁠ ⁠kettlebell strength •⁠ ⁠mobility and movement quality •⁠ ⁠endurance training •⁠ ⁠breathwork and recovery The goal is to build a recognizable visual identity for the SurgeX method. ⸻ Visual Identity Colour Palette The colour system should feel premium and minimal. Primary colours: •⁠ ⁠Deep Forest Green (primary background colour) •⁠ ⁠Soft Grey •⁠ ⁠White Accent colour: •⁠ ⁠Muted Gold The palette should feel: •⁠ ⁠calm •⁠ ⁠athletic •⁠ ⁠minimal •⁠ ⁠premium Avoid bright or typical fitness colours. ⸻ Typography Use two font styles. Headline Font Elegant editorial serif font. Used for: •⁠ ⁠headlines •⁠ ⁠statements •⁠ ⁠philosophy posts Examples of headline text: STRENGTH + FLOW RUN + BUILD STRENGTH MOBILITY IS PERFORMANCE ⸻ Body Font Clean sans-serif font. Used for: •⁠ ⁠explanations •⁠ ⁠bullet points •⁠ ⁠educational slides ⸻ Deliverables I need a reusable Instagram content system. This should include: 1.⁠ ⁠Hero Post Template This will be the center pinned post on Instagram. Example layout: SURGEX Strength + Flow Kettlebell Led Mobility Integrated Built for Real Performance Design notes: •⁠ ⁠deep green background •⁠ ⁠minimal layout •⁠ ⁠gold accents •⁠ ⁠premium look This post should feel like a brand statement. ⸻ 2.⁠ ⁠Educational Carousel Templates Create Instagram carousel templates for educational content. Example topic: Post Example 1 Slide 1 How Kettlebells Make You Run Faster Slide 2 Posterior chain strength Slide 3 Glutes and hip drive Slide 4 Power transfer to running stride Slide 5 Strength + Flow ⸻ Post Example 2 Slide 1 Why Mobility Improves Endurance Slide 2 Joint range of motion Slide 3 Movement efficiency Slide 4 Reduced injury risk Slide 5 Strength + Flow ⸻ 3.⁠ ⁠Training Philosophy Carousel Example structure: Slide 1 Most People Train Muscles Slide 2 We Train Movement Systems Slide 3 Hips Spine Shoulders Slide 4 Working Together Under Load Slide 5 SurgeX Method ⸻ Content Categories Templates should work for these recurring content types: 1️⃣ Strength (kettlebells) 2️⃣ Mobility / flow 3️⃣ Endurance performance 4️⃣ Breathwork / recovery 5️⃣ Training philosophy ⸻ Design Style Guidelines Design should follow these principles: •⁠ ⁠Minimal text •⁠ ⁠Strong headlines •⁠ ⁠Clean layouts •⁠ ⁠Large typography •⁠ ⁠Good spacing •⁠ ⁠Editorial / premium feel The Instagram page should look like a performance journal, not random fitness posts. ⸻ Layout Style Carousel slides should include: •⁠ ⁠large headline •⁠ ⁠minimal supporting text •⁠ ⁠simple icons or diagrams (optional) •⁠ ⁠balanced spacing Design must be optimized for Instagram carousel posts. ⸻ Final Deliverables Designer should provide: •⁠ ⁠6–8 Instagram carousel templates •⁠ ⁠1 hero template •⁠ ⁠Canva or Figma editable files •⁠ ⁠exported PNG example posts These templates should allow me to easily reuse the system for future content. ⸻ Instagram Grid Strategy The top pinned posts on the Instagram page will be: 1️⃣ Hero Video SurgeX Strength + Flow 2️⃣ Educational Post How Kettlebells Make You Run Faster 3️⃣ Educational Post Why Mobility Improves Endurance When someone lands on the page they should immediately understand that: SurgeX is a structured performance training system. ⸻ Hero Video Concept The hero video will introduce the SurgeX philosophy. Suggested video structure: Scene 1 Empty gym or calm training environment Scene 2 Slow kettlebell swing Scene 3 Mobility flow movement Scene 4 Running outdoors Scene 5 Breathing and stillness Final screen text: Strength + Flow Built for Real Performance SurgeX ⸻ Project Goal The goal of this project is to create a recognizable visual system so every post feels like part of the SurgeX brand. This will position SurgeX as: A modern performance training method.

SEO Specialist Needed

SEO SPECIALIST NEEDED - Shopify, UK Wellness Brand We've just completed a full independent SEO audit (Screaming Frog, GSC, GA4, Majestic, Ahrefs, Semrush). We know what's wrong. We need someone to have input but execute - not audit, not strategise from scratch. THE SITUATION: • DA 6 / Trust Flow 1 - starting from scratch • Zero commercial keyword rankings, all traffic is branded • Previous agency built 90+ spam backlinks that did nothing • 38 pages missing H1s, 33 collection H1s wasting keyword opportunity • Technical foundation is solid - authority and on-page is the problem WHAT WE NEED: 1. TECHNICAL FIXES (one-off) • Add H1s to 38 pages in Shopify Liquid templates • Remove "Collection:" prefix from 33 collection H1s (replacements provided) • Fix 7 broken 404 pages - remove 134 internal links from theme templates • Fix duplicate titles (7 pairs), duplicate metas (9 pairs), add 14 missing metas • Shorten 60 truncated titles (optimised versions provided) • Fix orphan pages, image alt text, heading structure • Re-crawl with Screaming Frog after each batch to verify 2. LINK BUILDING (ongoing) • Quality only - DA 25+, relevant wellness/health/nutrition sites etc • UK-focused outreach to nutritionists, health bloggers, wellness publications • No classified ads, web 2.0, profile links or link farms - we verify every link • 3-5 quality links/month minimum 3. KEYWORD STRATEGY (ongoing) • Map pages to target keywords, identify quick wins • Monthly GSC monitoring - non-branded growth is the metric that matters • UK commercial intent, supplements/wellness niche REQUIREMENTS: ✓ Own Screaming Frog licence ✓ Works directly in Shopify theme code (Liquid, theme.liquid, sections) ✓ Quality link outreach experience ✓ Reports from GSC data, not ranking tool screenshots TO APPLY: 1. Do you have your own Screaming Frog licence? 2. How many Shopify sites have you fixed technical SEO on? Share an example. 3. Describe your link building process - prospects, outreach, DA/TF targets. 4. Show a before/after using GSC data (not DA movement). DON'T APPLY IF: you use spam link methods, can't show Shopify work, have never edited Liquid, or only show DA as a result metric. Fixed fee for technical fixes, then ongoing monthly. Serious applicants only.

urgent

AI Marketing Implementation Specialist Thailand & UK Business

WHO WE ARE Peyton & Charmed Group is a multi-brand business operating between Thailand and the UK across 5 business units: - UK Student Accommodation (peytonandcharmedaccomm.co.uk) - UK Property Investment — integrated with Accommodation - Koh Chang Travel & Tours (kohchangthailandtours.com) - Private Land Transfers — currently Koh Chang to Bangkok route, growing nationwide - Bangkok City Stays (peytonandcharmedbkk.com) IMPORTANT — THIS IS NOT A SOCIAL MEDIA SETUP PROJECT We already have Facebook, Instagram and TikTok running across all business units. We do not need accounts created or basic profile work. We need an AI marketing implementation specialist to come in, build AI tools and workflows on top of what we already have, and hand everything over so our in-house team can run it themselves. WHAT YOU WILL IMPLEMENT - Audit our existing channels and identify gaps and opportunities - AI-powered content workflow — our team films, AI does the editing and posting - LLM-powered chatbots on Instagram, Facebook, LINE OA and WhatsApp — must understand natural language in English and Thai, not basic keyword bots - Scheduling and auto-posting across all platforms - Analytics dashboard so we can track what is working - Brand kit and video templates per business unit - Content calendar system our team fills in weekly - Filming guide per business unit for our team TRANSFERS NOTE Transfers currently runs as one route — Koh Chang to Bangkok — promoted through our Koh Chang channels. Phase 1 is to cross-promote this within Koh Chang content. A standalone Transfers setup is a future phase and not in scope for this project. TOOLS We are not fixed on specific tools. Recommend whatever AI tools you believe will work best for us and include the costs in your proposal. We own CapCut Pro and want it included where possible. TIMELINE — URGENT We need this completed within 2 weeks from start. Freelancers who can deliver faster will be given priority. WHEN APPLYING PLEASE INCLUDE - Examples of AI marketing systems you have implemented — not just social media management - Examples of LLM chatbots you have configured - Your recommended toolset with costs - Your fixed project rate - Your fastest realistic completion time We are two audiences — Thai families going to the UK, and international tourists coming to Thailand. Bilingual English and Thai strongly preferred. Need a quotation and road map - the follow a must DATA ANALYSIS & CUSTOMER PERSONA REPORTS This is a core requirement of the project, not an optional extra. We need the freelancer to conduct full data analysis across all our existing social media channels and customer data for each of our 5 business units. From this data analysis you must produce detailed customer persona reports that identify exactly who our customers are, what drives them to buy, what stops them buying, and how we can upsell and cross-sell our services across all business units. Data analysis deliverables required: - Full data analysis of existing social channels, audience insights and engagement patterns per BU - Customer persona report per BU based on data analysis findings - Buying trigger report — what motivates each customer type to purchase - Upsell and cross-sell opportunity map across all 5 BUs - Customer journey map per BU showing where we are losing potential customers - Ongoing data analysis system so our team can track and update this over time All data analysis and persona reports must be delivered by Day 3-5 of the project as they drive everything else — content, chatbots, strategy and messaging. Content without data analysis is just guesswork. When applying please include examples of data analysis reports and customer persona work you have completed for other businesses.

opportunity

Photorealistic Interior Design Renders from Existing Room Photos

I am seeking a skilled interior designer / interior CGI specialist to produce photorealistic interior design renders based on four-five existing photographs of real rooms (high-end residential property) - kitchen, living room, bedroom, ensuite, study or formal sitting room or formal dining room. This may expand to ongoing work for future development projects - I have several other properties developed over the years (residential & boutique hotel) that I wish to display updated interior concepts for. *Please only apply if you have portfolio examples of luxury residential interior visualisations. *Copy write for deliverables will be assigned to me - these images are of my projects and I do not want them displayed elsewhere. The task involves transforming the interiors within the photo (furniture, lighting, styling, FF&E etc.) while retaining the original architecture, camera angle, perspective, and external views. These renders will be used for high-end residential development website, so realism and material quality are critical. ⸻ Scope of Work The freelancer will receive: • Original room photographs • Design direction and references • Guidance on key furniture and layout changes to implement The freelancer will deliver photo-realistic design renders showing proposed interior schemes. Typical edits include: Interior modifications • Replace furniture layouts • Add dining tables / seating arrangements • Introduce luxury lighting fixtures • Add sideboards, artwork and styling • Modify interior décor • Adjust rugs, textures and colour palettes Architectural constraints The following elements must usually remain unchanged: • Camera angle / perspective • Windows and exterior views • Kitchen layouts and built-in cabinetry (unless specified) ⸻ The final result should look like a real professionally photographed interior. ⸻ Required Quality Level The renders must achieve true photorealism, including: • realistic lighting • natural shadows • accurate material textures (stone, wood, fabrics etc.) • correct reflections • landscaping alterations • correct scale and proportions The result should be comparable to renders produced for: • luxury residential marketing • high-end interior design studios • architectural visualisation portfolios ⸻ Design Style The aesthetic direction will typically reference high-end London interior design studios. Designs should feel luxury, refined and spatially balanced, not generic catalogue interiors. ⸻ Deliverables For each room: • 2 interior design scheme renders • Photorealistic quality • Landscape orientation • Minimum 3000px wide Formats: • JPG or PNG • High resolution suitable for presentations ⸻ Workflow 1. I provide original photo(s) 2. I provide design brief and references 3. Freelancer produces initial draft render 4. Minor revisions 5. Final high-resolution renders delivered ⸻ Ideal Freelancer Looking for someone with experience in: • Architectural visualisation • Interior design rendering • Luxury residential interiors • Photorealistic CGI ⸻ Important Please include in your proposal: • Examples of photorealistic interior renders • Examples where existing photos were transformed into new interior schemes (if available) ⸻ Project Scope Initial project: 3–5 room renders ⸻ Budget Open to proposals depending on experience and quality of portfolio.

Design Brief – Light Box Sign Designs

Project Overview I manufacture illuminated light boxes with removable front plates (sign panels). I am looking for a designer to create a series of sign designs that will be placed on the front of these light boxes. The signs will be backlit by LEDs, so the designs should be visually bold, simple, and suitable for illumination. The finished designs will be used on removable panels so customers can swap the design depending on the occasion. Design Size Each design must fit within: 280mm (width) x 180mm (height) Landscape orientation. Please keep important design elements away from the outer edges to allow for trimming and mounting tolerance. Background For the purposes of the design work, assume: Background colour: White (#FFFFFF) In some cases the panel may be produced in other colours, but the default design assumption should be white. Possible alternative panel colours include: * Black (#000000) * Red (#C00D1E) * Blue (#00358E) * Green (#00AE42) * Grey (#A6A9AA) * Yellow (#FCE300) Colour Palette Designs should only use colours from the following palette: * Black (#000000) * White (#FFFFFF) * Grey (#A6A9AA) * Yellow (#FCE300) * Red (#C00D1E) * Green (#00AE42) * Blue (#00358E) * Teal (#0086D6) Where possible please use a limited number of colours per design. Simpler designs are preferred. Fonts Text must only use fonts that are supported in the Make My Sign tool. Please use one of the following fonts: - Arial - Arial Black - Verdana - Helvetica - Trebuchet MS - Tahoma - Times New Roman - Georgia - Courier New - Impact - Comic Sans MS Fonts may be combined if appropriate, but designs should remain clear and easy to read when illuminated. Design Style Designs should combine text and simple graphic elements or icons where appropriate. Because the panels are backlit, designs should: * Be bold and readable from a distance * Avoid very thin lines * Avoid excessive detail * Work well when illuminated * Use simple vector graphics where helpful Examples of graphic elements could include balloons, stars, confetti, beer mugs, controllers, hearts, etc. Designs Required Please create one design for each of the following phrases/themes: Seasonal / Events 1. Merry Christmas 2. Happy New Year 3. Happy Birthday 4. Happy Anniversary 5. Let's Party Home Bar / Drinks 6. Cheers 7. Bar Open Games Room / Gaming 8. Game Room Home / Decor 9. Love 10. Home Sweet Home Each design should feel visually appropriate for the theme. Examples of optional imagery include: - Christmas: trees, snowflakes, stars, ornaments - New Year: fireworks, champagne, clocks - Birthday: balloons, cake, confetti - Anniversary: hearts, rings - Party: confetti, streamers - Bar: beer mugs, cocktail glasses - Games room: Pool balls, darts
 These are suggestions only — creative interpretation is welcome. File Deliverables Each design must be supplied as: - Editable SVG files Please ensure: * Text is converted to outlines * Colours use the specified hex codes * Files are clean vector artwork suitable for production Revisions Please include two revision rounds if required. What I Need From You Please let me know: 1. Any questions you have 2. Estimated cost for the project 3. Estimated turnaround time 4. Examples of similar vector or signage work if available When replying to this job post, please include the word LIGHTBOX so I know you have read the brief. There may be additional design work available in the future if this project goes well.

opportunity

Extract blood test data from PDF documents that have been OCR'd

The objective is to build a structured blood test database that allows pathology results to be viewed, edited, filtered, and exported to Excel via a web-based HTML interface. The system stores results in a clean, standardised format so trends can be analysed accurately over time. Using AI-assisted OCR, I have built a local Python extraction pipeline that converts PDF pathology reports into machine-readable text and inserts structured data into a SQLite database. The majority of blood tests extract correctly, including canonical test name, result value, unit, and reference range. However, I have reached a specific technical issue with three markers: • CRP (C-reactive protein) • ESR • GLU (Glucose) The OCR output clearly contains the correct lines, and debug logs confirm they are processed. Yet no rows are inserted for these markers. The failure appears to occur between canonical matching, numeric extraction, or validation logic. Current System Architecture The system runs locally and consists of: • extraction_core_2.py (main engine) • Supporting modules for OCR preprocessing, lab dictionary building, regex matching, and validation • SQLite backend • Schema-driven canonical lab dictionary • Controlled fuzzy fallback logic • HTML viewer for results display and Excel export Pipeline flow: Convert PDF to image (pdf2image) Preprocess Run Tesseract OCR Clean and normalise text Match against canonical lab dictionary Extract: canonical test name numeric result unit reference range Validate Insert into SQLite The engine is deterministic and rule-based. The Specific Problem Example OCR line: CRP H 5.2 mg/L 0-5 OCR text is correct. NUMBER_PATTERN matches. The canonical dictionary contains the test. Yet: Inserted 0 rows from 0126251OrderReport_23B00006604_CRP.pdf Likely failure points include: • Canonical containment match failing due to normalisation • Flag tokens (“H”, “L”) interfering with numeric capture • Numeric extraction anchored incorrectly • Validation rejecting due to strict range formatting • Unit pattern mismatch (e.g. mmol/L) • Dictionary indexing issue • Match overridden by another lab name • Guard conditions too strict If validation fails, the row is rejected silently. All other panels extract correctly. The issue appears isolated. What Is Required This is not a rebuild. We do not want: • Re-architecture • Experimental AI guessing logic • Large-scale changes • Expanded fuzzy matching We need: 1. Precise Diagnosis Identify exactly where CRP, ESR, and GLU are failing insertion and which rule is causing rejection. 2. Minimal Safe Fix Implement a targeted correction that: • Adjusts canonical matching if required • Anchors numeric extraction correctly • Allows flag tokens without blocking capture • Relaxes only necessary validation checks • Preserves deterministic behaviour 3. Zero Regression • No impact to currently working panels • No performance degradation • No uncontrolled fuzzy expansion 4. Modular Implementation If appropriate: • Implement as small isolated module or • Cleanly adjust matching block The existing architecture should remain intact. Constraints The system is designed to be: • Deterministic • Schema-driven • Reproducible • Forensic-grade We cannot introduce probabilistic or unpredictable behaviour. Longer-Term Goal After stabilising extraction: • Migrate to web deployment • Enable structured uploads • Add trend analysis • Later incorporate AI-assisted interpretation Immediate priority: Stabilise deterministic extraction for CRP, ESR, and GLU without breaking the existing engine. Materials Provided Uploaded: • Full extraction_core_2.py (text format) • Screenshot of HTML viewer • Sample PDF files • Export showing required output Additional materials available on request: • Sample OCR blocks • Canonical dictionary entries • Regex patterns • Validation logic • Database schema • Debug logs This is a focused debugging and refinement request. I have spent many hours attempting to isolate the issue and now require an experienced developer to identify the blocking condition and implement a practical fix. I have been advised this should take 1–2 hours for a senior developer. Looking for a swift turnaround.

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.