Existing VB Excel Sheet needs to be flixed and improved

30.0 GBP

30.0 GBP peopleperhour Technology & Programming Overseas
1 days ago

Description

I had an XLSM sheet built some years ago but it is buggy and I need to have it looked at and fixed, and also improved.
It has constant errors when it tries to create new files based on the data within the sheet. This could be the VB or could be security policies within the folder structures.
Your role is to understand the code, find issues, fix issues, and recommend additional changes to the code.
If these are accepted there will be additional work to configure these sheets which will require multiple versions for different work type

Go Now
关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Description: Sanphire Design (www.sanphire.co.uk) is seeking an experienced WordPress developer to help transition our current website and content to the Elementor framework. We are a long-established design and web development studio, and this project is part of a broader evolution to streamline our workflow and enable easier ongoing updates. Scope of Work: Review the current Sanphire Design website and replicate the layout, styling, and content using Elementor (Pro license available if needed). Rebuild key page templates and custom sections to be editable within Elementor. Maintain responsive design and performance optimizations throughout. Ensure existing SEO settings and meta data are preserved. Migrate blog posts and ensure any custom post types or widgets are correctly handled or rebuilt. Implement clean, well-organized structure for ease of future edits by non-technical team members. Advise on any limitations or opportunities to enhance UX/UI during the transition. Requirements: Proven experience with Elementor (portfolio required) Deep understanding of WordPress core, themes, and plugins Clean, efficient coding practices and attention to accessibility and device compatibility Ability to communicate clearly and meet agreed deadlines Familiarity with the existing Sanphire brand and aesthetic is a plus Deliverables: Fully functional Elementor-based version of the Sanphire Design site Admin walkthrough or brief documentation for content updates Final check to ensure all functionality (contact forms, blog, links, navigation) is retained Timeline: Looking to begin within the next 1–2 weeks. Project ideally completed within 3–4 weeks, but flexible for the right developer.
275.0 GBP Technology & Programming peopleperhour Overseas
2 days ago
TowDispatch is a full-featured platform designed to streamline operations for car towing agencies. The system supports both web and mobile environments and enables seamless coordination between dispatch administrators and field drivers. Tech Stack Web Frontend: React.js + Tailwind CSS Backend & Realtime DB: Supabase (PostgreSQL, Auth, Edge Functions) Mobile Application: Capacitor (for native app packaging), integrated via Android Studio for Android and planned iOS deployment Core Functionality Admin Dashboard Job Management: Create, assign, update, and delete tow jobs Driver Management: Add, edit, and monitor driver status and activities Reporting Module: Generate operational and performance reports Notification System: Real-time job status feedback via toast messages (web) and push notifications (mobile) Driver App Job Inbox: View assigned jobs with real-time updates Job Workflow: Update job progress (e.g., en route, job complete) Profile: Manage driver-specific settings and preferences Current Challenge: Push Notification Implementation With the mobile app version now fully operational through Capacitor and Android Studio, the primary challenge lies in implementing a reliable and scalable push notification system to replicate and extend the existing toast-based web notification model. Existing Web Notification Flow Notifications are triggered via toast messages, displayed in-app for real-time user feedback All notification events (e.g., job assignment, completion) are stored in Supabase for traceability
50.0 USD Technology & Programming peopleperhour Overseas
22 hour ago
1. Project Objective Design, build and deploy an AI‑driven LinkedIn workflow that automatically generates and delivers personalised lead magnets to three Ideal Customer Profiles (ICPs)—law‑firm owners, IT consultants, and accountancy‑practice partners—so you increase qualified conversations and booked calls. 2. Business Context Current outreach: Heyreach.io Campaign #1 – re‑engage 1st‑degree connections Heyreach.io Campaign #2 – nurture post reactors Existing lead magnets: Business Growth Quiz, “Create Clarity” Playbook, podcast episodes, case study, ChatGPT‑powered Exit Blueprint. Other tools in stack: LinkedIn Sales Navigator, Apollo.io, Clay, Trigify. Strategic hook: Each ICP advises founders who want to scale and exit but lack a structured exit strategy; lead magnets must surface that pain and position your “scale‑to‑exit framework.” 3. Desired Future Workflow (high‑level) Detection Trigger on new 1st‑degree connection, post reaction, or saved search match. Enrichment & ICP Classification Pull firmographics via Apollo / Clay API (industry, headcount, role). Classify into ICP‑Law, ICP‑IT, ICP‑Accountancy (fallback = “Other”). Personalised Lead‑Magnet Generation Use OpenAI API (GPT‑4o) + prompt templates to create: A bespoke 2‑page PDF mini‑playbook (pain points + quick wins). A unique share‑link to your tailored ChatGPT Exit Blueprint (pre‑loaded with their context). Asset Production Render PDF via serverless doc generator (e.g., Documint, PDFLib, or HTML‑>Puppeteer). Store in S3 / CloudFront; capture public URL. Delivery Sequencing (via Heyreach) Day 0 DM: pattern‑interrupt hook + quiz link. Day 2 Auto‑follow‑up: drop personalised PDF link. Day 5 Nudge: invite to 15‑min “Exit Readiness Review” call. Feedback Loop Sync engagement data back to Airtable/CRM; score lead; auto‑stop on meeting booked. 4. Functional Requirements # Requirement Notes F1 Identify contact ICP via enrichment API and keywords in LinkedIn headline < 300 ms per contact F2 Generate PDF lead magnet with dynamic sections: intro, pain diagnostic, 90‑day action plan, CTA Template must support variable brand colours F3 Create custom GPT blueprint link pre‑seeded with firm name + challenges Use OpenAI “file‑based” system prompt F4 Push asset links + personalised copy back into Heyreach via webhook Must merge‑tag into existing campaign templates F5 Log all events to central datastore (Postgres or Airtable) For reporting & A/B testing 5. Non‑Functional Requirements Security & GDPR: No PII stored outside EU data centres without encryption at rest & TLS 1.2+. Scalability: 2 000 contacts/day with 80 % coverage) Prompt Engineering Library (YAML/JSON templates) CI/CD Pipeline (GitHub Actions) incl. lint, tests, security scan, deploy Admin Dashboard (low‑code Retool) showing pipeline stats & lead downloads Playbook (PDF/Notion) for Marketing Ops: how to create/edit templates 30‑day Hypercare Support 8. Success Metrics (90‑day post‑go‑live) 30 % ↑ in qualified meetings booked from LinkedIn. ≥25 % click‑through on personalised PDFs. Lead magnet production cost ≤ $0.45 per contact (compute + API). System uptime ≥ 99.5 %. 9. Timeline & Milestones Week Milestone 1 Requirements finalised, access to APIs provisioned 2 MVP pipeline: enrichment → content generation → asset storage 3 Heyreach integration & DM templates wired 4 PDF branding polish + dashboard 5 End‑to‑end QA, GDPR review 6 Pilot on 200 contacts 7 Iterate, performance tuning 8 Full launch + hand‑off 10. Risks & Mitigations LinkedIn API/ToS changes: Use headless browser fallback script; monitor rate limits. OpenAI pricing spikes: Add Claude Sonnet or open‑source fallback in abstraction layer. Personalisation fatigue: Rotate prompt templates quarterly; A/B test offers. 11. Next Steps Confirm or adjust scope & KPIs. Provide dev with API keys & brand assets (logo, colours, fonts). Schedule weekly stand‑up cadence and shared Slack channel (doesn't necessarily have to be slack) Must have experience in multiple LLMs
363.0 GBP Technology & Programming peopleperhour Overseas
1 days ago

HuntsBot,a one-stop outsourcing task, remote job, product ideas sharing and subscription platform, which supports DingTalk, Lark, WeCom, Email and Telegram robot subscription. The platform will push outsourcing task requirements, remote work opportunities, product ideas to every subscribed user with timely, stable and reliable.

简体中文 English

Platform

Support

Links

Contact US

Any questions or suggestions during use, you can contact us in the following ways:

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.