Excel Macro Code

175.0 GBP

175.0 GBP peopleperhour Technology & Programming Overseas
516 days ago

Description

I am looking for a skilled Excel macro developer to help me with formatting and organizing data. The ideal candidate should have experience in automating data entry and generating reports and analysis.
Specific requirements for this project include:
- Formatting and organizing data according to a general structure, with room for suggestions and adjustments
- Following some general rules for formatting and organizing the data, while being open to adjustments based on the specific data
Challenge: I have a table with 600-700 columns. Around 50-100 Rows get added everyday. For every row there are repeating columns, between 3 to 10 set of columns repeating for 3 to 10 times. Technically they are values of a 2 dimensional table converted to a single dimension in one row. Now for each lets say, 50 rows added, I want the macro to run and create separate sheets in the excel, convert all such column sets into tables. There are as many as 15 tables in a single row, ranging from 3x3 to 10x10 tables with or without valid entries.
If you have the necessary skills and experience to tackle this project, please submit your proposal.

关注公众号,不定期副业成功案例分享
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
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