Sql parentchild tree query jobs
...needs a quick but thorough tidy-up. The flower beds are showing weeds again and the hedge has some growth poking through that I’d like cleared out at the same time. The second part of the job is reducing the spread of one mature tree so it sits comfortably below the roofline and away from power lines. No branch removal for disease is required; this is strictly a height-and-shape reduction. Deliverables • Weed removal from all flower-bed sections and the hedge line, with roots pulled or spot-treated so they don’t bounce back immediately. • Tree trimmed back evenly, clean cuts made with proper equipment (hand saw, pole pruner, or chainsaw as needed) and all debris bundled or mulched for disposal. Everything must be completed in one ...
...management, form filing, and all types of new incorporations. Who the leads must fit • Client profile: small businesses and startups headquartered anywhere in India • Intent: demonstrably interested in the above services (e.g., asking questions online, searching specific terms, downloading related checklists) • Data fields required: contact name, direct phone, email, city/state, and the exact query or keyword that captured their interest Preferred acquisition channel Search Engine Optimization is my primary focus. You should already have proven tactics for ranking service pages, publishing keyword-rich content, and capturing high-intent visitors via landing pages or forms. If you can amplify results with supporting methods (content clusters, local SEO, lo...
...visitors and route qualified leads into HubSpot - Build the bridge between anonymous traffic and known contacts **AI-Native Reporting & Workflow** - We run lean and move fast because we use AI tools — particularly Claude — as a daily extension of our team. You'll be expected to do the same. - You should be fluent in using Claude with HubSpot's MCP (Model Context Protocol) connector to pull reports, query contact and deal data, and surface insights in minutes instead of building a report from scratch each time - You'll use Claude to draft workflow logic, debug tracking issues, summarize campaign performance, and accelerate the operational work — not to replace your judgment, but to multiply your output - If you've never used Claude with M...
...Should Provide A professional delivery usually includes: Final Excel File * Clean structure * Working macros * Dashboard * Scenario tools Documentation * Model guide * VBA explanation * Input instructions Optional * Short Loom/video walkthrough * PDF summary ⸻ Skills You’ll Need To complete this project well: Excel * INDEX/MATCH/XLOOKUP * SUMIFS * Dynamic arrays * Pivot tables * Power Query VBA * Loops * UserForms * Automation * Error handling Financial Modelling * Forecasting * DCF * Scenario analysis * Sensitivity testing ⸻ Recommended Workflow Week 1 * Review existing model * Clean structure * Identify problems Week 2 * Add scenarios * Improve formulas * Build dashboards Week 3 * VBA automation * Testing * Documentation * Final delivery ⸻ If You...
...Should Provide A professional delivery usually includes: Final Excel File * Clean structure * Working macros * Dashboard * Scenario tools Documentation * Model guide * VBA explanation * Input instructions Optional * Short Loom/video walkthrough * PDF summary ⸻ Skills You’ll Need To complete this project well: Excel * INDEX/MATCH/XLOOKUP * SUMIFS * Dynamic arrays * Pivot tables * Power Query VBA * Loops * UserForms * Automation * Error handling Financial Modelling * Forecasting * DCF * Scenario analysis * Sensitivity testing ⸻ Recommended Workflow Week 1 * Review existing model * Clean structure * Identify problems Week 2 * Add scenarios * Improve formulas * Build dashboards Week 3 * VBA automation * Testing * Documentation * Final delivery ⸻ If You...
I'm seeking an experienced Node.js backend developer for my multi-vendor Flutter project. Key Requirements: - Core Functionality: Product listing and management - Existing SQL-based database for product management Ideal Skills & Experience: - Strong expertise in Node.js - Experience with SQL databases - Background in building backend for multi-vendor applications - Familiarity with Flutter is a plus - Ability to create scalable and efficient APIs Please provide relevant experience in your bids.
...values, eliminated duplicates, and standardized data formats for downstream consumption. Scalable ETL Processing (PySpark): * Leveraged PySpark to process and transform large-scale datasets efficiently, optimizing partition strategies to reduce execution time. Executed complex business logic, aggregations, and data joins across massive distributed data frames. Hybrid Data Storage (PL/SQL & MongoDB): Relational (PL/SQL): Designed relational schemas, wrote optimized stored procedures, triggers, and complex analytical queries to manage structured transactional data. NoSQL (MongoDB): Handled semi-structured and unstructured data elements, managing high-throughput document storage with optimized indexing for fast retrieval. Business Intelligence & Insights (Power BI): *...
...document) the engineering calculations behind the design. This includes strength checks, bearing & shaft sizing, torque / motor sizing, and any other performance or safety factors required for a smooth, reliable index and tilt. I will review the calcs before sign-off. Deliverables (all digital): 1. Native SolidWorks assembly and part files (.sldasm / .sldprt) with a clean, editable feature tree. 2. A PDF report—or spreadsheet if you prefer—showing the supporting calculations, formulas, and assumptions. Acceptance criteria • Model opens error-free in SolidWorks 2022 or later. • All parts fit together with proper clearances; no interference detected. • Calculations reconcile with the 3D geometry and stated loads. I will share the exis...
...Should Provide A professional delivery usually includes: Final Excel File * Clean structure * Working macros * Dashboard * Scenario tools Documentation * Model guide * VBA explanation * Input instructions Optional * Short Loom/video walkthrough * PDF summary ⸻ Skills You’ll Need To complete this project well: Excel * INDEX/MATCH/XLOOKUP * SUMIFS * Dynamic arrays * Pivot tables * Power Query VBA * Loops * UserForms * Automation * Error handling Financial Modelling * Forecasting * DCF * Scenario analysis * Sensitivity testing ⸻ Recommended Workflow Week 1 * Review existing model * Clean structure * Identify problems Week 2 * Add scenarios * Improve formulas * Build dashboards Week 3 * VBA automation * Testing * Documentation * Final delivery ⸻ If You...
...Compliance / Industry Knowledge Developer should understand or research: Australian fuel industry SIRA methodology EPA compliance requirements Underground Petroleum Storage Systems (UPSS) Fuel inventory reconciliation Preferred Experience Experience building: Fuel management software Environmental compliance systems Data analytics dashboards SaaS platforms Experience with: React / Node.js / Python SQL databases Dashboard UI/UX API integrations Deliverables Full software platform Source code ownership Admin dashboard Reporting module Deployment assistance Ongoing support option To Apply Please Provide Examples of similar software/projects Proposed tech stack Estimated timeframe Estimated budget Team size Important Only apply if you have experience building business software, an...
...validation. Feel free to use Postman, JMeter, or another tool you prefer, but make sure assertions cover all status codes, payload structures, and edge-case parameters. • During each round of testing you will enter sample records that mirror real production data; part of the job is confirming that what goes in comes back out unchanged. • The USSD flow is almost final. I will share the current tree, you confirm all menu branches, timeouts, and fall-back prompts on the staging shortcode. Any wording or routing mismatches should be logged with screen captures. Deliverables I expect at the end of every cycle: 1. A reproducible test-case pack (steps, expected vs. actual, environment). 2. API test collection with assertions saved and exportable. 3. A signed-off data-...
I have a complete PHP website packaged in a set of .zip ...(Git) and concise change logs are important to me so I can track what was done and roll back if necessary. Deliverables for the first milestone • Deployed, fully functional website reachable by public URL • Any database set-up or import completed (if the code requires one) • Brief hand-off note outlining server settings, credentials kept secure, and where each core component lives in the file tree Acceptance criteria • No PHP errors or missing asset warnings in the browser console • Pages load in under three seconds on first view (baseline shared hosting metrics) • I can log in—or otherwise interact—exactly as the original site intended After that, we can schedule ...
...an upcoming paper. You’ll receive the cleaned, anonymised transcripts as Word files. I’d like you to: • Import and organise the sources in NVivo. • Develop an initial codebook (inductive or deductive—whichever best fits the material) and refine it as you progress. • Apply systematic coding throughout all 25 interviews, ensuring consistency across cases. • Generate clear visualisations or query outputs (e.g., word trees, matrix coding) that illuminate behavioural themes. • Provide a concise analytic memo summarising each major theme, illustrative quotes, and your interpretation of how these patterns interact. Deliverables 1. The complete NVivo project file with all nodes, classifications, and queries intact. 2. A short (&as...
...shortages instantly. No additional metrics are necessary for now; the focus is purely on accurate, real-time stock visibility. Deliverables: • One Excel workbook containing the finalized pivot table, formatted for quick reading • Clear, step-by-step notes (inside the file or in a short README) explaining how to refresh the data and expand or collapse product categories If you prefer Power Query, slicers, or any other native Excel tools to streamline the process, feel free to integrate them as long as the final result remains user-friendly....
...immediately after migration. Scope of Work: • Analyze the existing ASP.NET Framework 4.8 solution • Migrate the application to ASP.NET Core (Razor Views or Razor Pages as appropriate) • Rebuild controllers, routing, and UI structure • Update configuration files (appsettings, dependencies, etc.) • Replace or upgrade outdated third-party packages • Ensure database compatibility and data integrity (SQL Server) • Maintain all existing business logic and features • Improve performance and security where possible • Ensure full build, run, and publish readiness • Provide clean and structured codebase following best practices The goal is a production-ready solution that can be cloned, built, and deployed without errors. Timeline: Estim...
Project Title: Build TallyPrime Integration Bridge Application with SQL Server ERP Project Description: We are looking for an experienced developer to build a bi-directional bridge application between our SQL Server-based ERP software and TallyPrime. The application should enable seamless two-way data synchronization between our ERP database and Tally. Requirements: 1. ERP to Tally Sync The application should push data from our SQL Server ERP to Tally, including: Sales vouchers Purchase vouchers Credit notes / Debit notes Ledger creation Item master synchronization Customer/vendor master data 2. Tally to ERP Sync The application should fetch data from Tally into our software, including: Bank receipt entries Payment vouchers Journal entries Ledger updates Voucher update...
I need a clean Postfix installation configured to handle both outgoing and incoming mail. All account, alias, and domain information must live in PostgreSQL, so the build has to include the proper SQL maps and permissions from the start. My goals are straightforward: – Mail flows reliably in both directions. – TLS is enforced for all SMTP traffic. – Users authenticate against the PostgreSQL-backed tables. – Standard anti-spam and DKIM/SPF records are in place so messages land in the inbox, not junk. You are free to choose the Linux distribution you’re most comfortable with, but please document every package, file path, and command so I can replicate the setup later if needed. Once the server passes basic send/receive, DKIM/SPF, and relay-restriction t...
...requirements and translate them into technical solutions Enable and support advanced analytics or AI use cases (forecasting, predictive insights, etc.) Document processes, data models, and workflows Required Skills Strong experience with: Power BI (Data modelling, DAX, visualization) Power Automate (workflow automation, system integrations) Solid understanding of data warehousing concepts Experience with SQL and data transformation tools Ability to handle end-to-end data projects independently Strong analytical and problem-solving skills Preferred Qualifications Experience with Microsoft Dynamics 365 Business Central Exposure to: Azure Data Services (Data Factory, Synapse, etc.) AI/ML integration or advanced analytics layer Familiarity with APIs and system integrations Experien...
I need an all-in-one AI Agent that becomes the intelligent front line for my brand. Its primary function is exactly that—an AI Agent—capable of shifting seamlessly between customer support, sales and marketing conversations without feeling like three sep...• Training scripts / datasets aligned with my brand voice • Integration code and webhook/ API documentation • Admin dashboard or reports covering inquiry types, lead scores and user-data insights • A short video walkthrough plus written hand-off instructions so my team can adjust intents or flows without coding Acceptance criteria: live end-to-end demo showing the agent solving a support query, capturing a lead, and writing data back to the CRM; average response time under three seconds; anal...
...Should Provide A professional delivery usually includes: Final Excel File * Clean structure * Working macros * Dashboard * Scenario tools Documentation * Model guide * VBA explanation * Input instructions Optional * Short Loom/video walkthrough * PDF summary ⸻ Skills You’ll Need To complete this project well: Excel * INDEX/MATCH/XLOOKUP * SUMIFS * Dynamic arrays * Pivot tables * Power Query VBA * Loops * UserForms * Automation * Error handling Financial Modelling * Forecasting * DCF * Scenario analysis * Sensitivity testing ⸻ Recommended Workflow Week 1 * Review existing model * Clean structure * Identify problems Week 2 * Add scenarios * Improve formulas * Build dashboards Week 3 * VBA automation * Testing * Documentation * Final delivery ⸻ If You...
...AI-controlled traffic that obeys signals, yields and reacts believably to the player. • Introduce interactive NPCs specifically themed as other delivery drivers. These NPCs must follow their own delivery routes, compete for pickups, and trigger contextual dialogues or mini-events when players cross paths. • Provide hooks (JavaScript events or REST/WebSocket calls) so my existing gameplay code can query traffic density, spawn or despawn NPC drivers, and read basic state like location or speed. • Supply cleanly organised project files, commented source, and a short setup document so future updates—warehouses, seasonal events, city expansion—slot in smoothly. Acceptance criteria 1. Initial city scene loads in under 6 seconds on a typical 4G connec...
I want to launch a dedicated website that proclaims the message of Jesus Christ to all mankind, and I need it online as quickly as possible. The site has to let me publish frequent text reflections, high-quality images, and inspiring...and an SSL certificate should be in place from day one. Deliverables I’ll review for sign-off • Fully responsive website, live on my chosen domain • CMS credentials with clear instructions for posting text, images, and videos • Image sitemap submitted and indexed in Google Search Console • At least one sample post showing correctly optimised images that appear when I do a Google Images query for the file name If you have a proven track record in fast website roll-outs and SEO that gets images indexed quickly, I&rsqu...
I have been running my team’s data from a single Excel workbook for seasons now—minutes playe...new player is added, they should slot straight into the tables without manual tinkering. Once the data flows automatically, I’d like dynamic charts that reshape themselves on-the-fly. For example, selecting a player from a drop-down should redraw a trend line of their minutes per game; choosing a competition should flip the dashboard to that league’s standings. Slicers, pivot charts, or Power Query—whatever does the job cleanly inside Excel is fine. Because this is time-sensitive, I’m hoping to move quickly. If you can show past work where you’ve automated sports (or similarly stat-heavy) spreadsheets and built interactive dashboards in Exce...
... Charts and colour-coded heat maps are welcome if they stay clear and printable. • Document management: secure upload, OCR tagging, expiry reminders, and easy retrieval for audits (drag-and-drop interface preferred). Tech stack is your choice as long as it is mainstream, maintainable, and browser-based—think React, Vue, or Angular on the front end; Node, Django, or Laravel on the back; and a SQL database with proper indexing for speed. APIs and webhooks should be structured so I can integrate IoT sensors or municipal open-data feeds later. Acceptance criteria 1. Dashboard loads in under 3 seconds with 1,000 active property records. 2. New regulation categories can be added through an admin panel—no code changes. 3. All alerts, reports, and document meta...
I need an A5 flyer that presents my Landcare and tree-work services in a clean, professional style. The flyer must stay consistent with the colours already used in my logo, which I will provide in vector format. Core content to include: • A concise list of the services I offer (tree removal, pruning, hedge trimming, stump grinding and general land-care). • Clear, easy-to-read contact details (phone, email and website). No customer testimonials are required at this stage. The overall look should feel trustworthy and well-established rather than rustic or minimalist—think neat typography, structured layout, and subtle graphical accents that highlight the nature theme without clutter. Deliverables • Print-ready PDF in CMYK (3 mm bleed, 300 dpi). &bull...
...75-query taxonomy All six API keys, provisioned and shared via 1Password Sample completed scans for reference Direct Slack access to the project lead Timeline and process 10 business days from kickoff to delivery Fixed price, paid in three milestones (30% / 40% / 30%) $500 bonus if delivered on or before business day 8 Daily commits to the repo required Weekly Friday sync at 10am ET Mutual NDA signed before access to query taxonomy Required skills 5+ years Python with strong asyncio experience Hands-on experience with at least 3 of: OpenAI API, Anthropic API, Perplexity Sonar API, Google Gemini API, xAI Grok API, SerpAPI openpyxl for Excel manipulation Streamlit for UI Google Cloud OAuth for Drive integration Slack API for notifications Strong Git/GitHub workflow Out ...
...the 4 Seasons of Health—needs a fresh, memorable mark that people will recognize as quickly as they recognize the Nike swoosh. I’m leaning toward an abstract symbol that feels both professional and welcoming. What I have in mind • Visual cues: maybe weave together subtle nods to nature (leaf, tree, etc.), integrative medicine , and the four seasons (sun, snowflake, autumn leaf, spring bloom). None of these should dominate; they should merge into one clean, simple shape. We are liking the tree of life. Just not too much detail. • Colour palette: primary blues and pure white accented with natural tones. The logo must also hold its own in solid black or solid white. Season colours. • Style: creative, with a minimalist spirit—nothing o...
I want a clean, Excel-based MIS solution that turns raw inventory data into actionable insight. The report must surface: • Product movement (inbound, outbound, returns, ageing trends) • Supplier details (lead times, performance, cost variances) Everything should refresh with a single click, so feel free to rely on pivot tables, Power Query, dynamic arrays, or lightweight VBA if it streamlines the process. Formatting has to be clear enough for non-technical managers to read at a glance, yet detailed enough for the warehouse team to drill down when they need specifics. Your proposal should focus on your experience building similar inventory dashboards in Excel—screenshots or brief descriptions of past work are welcome. Once I share the raw data structure, I’...
...the last song of the night. I’m after a chill, classy, yet up-beat feel and will sit down with you beforehand to nail the exact look and pacing. Key focuses during the shoot will be the live DJ performance, behind-the-scenes preparation, and the flow of activities throughout the day. Please be ready to give a little extra attention when guests write greeting cards and hang them on the kiosk and tree (no faces); it’s a signature moment I’d like captured in detail. Deliverables I’m expecting: • A well-edited final video that reflects the agreed vibe • Separate highlights of the entertainment acts and the greeting-card segment • All usable raw footage for our archive You can shoot on whatever camera platform you prefer—just ensur...
...legibility. Editable fields: photo slot, headline text. --- ## 3. YouTube thumbnails **4a. Emotive story** — Full-bleed photography, 2–4 word bold headline with high-contrast text treatment, logo. References: "Transforming Tanzania", "Meals that make an impact." **4b. Explainer and process** — Split layout (photo + type) or presenter with text overlay, purple panel, logo. References: "One gift. One tree.", "How we're making impact easy." **4c. Thought leadership and talks** — Event or stage photography, bold topic title over purple overlay, optional event logo lockup, GiftTrees logo. Reference: "The power of purpose driven profit | TedTalk." **All thumbnails:** 1280 x 720 px. Text must read at 16...
I have a collection of PDFs with tables that need to end up in a clean, well-structured Excel workbo...• Accurate extraction of every table, regardless of layout changes. • A single Excel (.xlsx) file with each source PDF represented on a separate sheet, preserving numeric formats and basic styling where possible. • A quick note on any tables that cannot be captured automatically so I can review them manually. I’m open to whatever stack you prefer—Python (pandas, tabula-py, camelot), Power Query, or even a smart VBA solution—as long as the final workbook is reliable and reproducible. When you respond, please include a sample or brief clip from past work that shows you have already tackled inconsistent PDF tables. That reference will help me mov...
...months. We need to act fast. • Language: I do not speak local European languages. The preparation must focus strictly on international companies or tech hubs operating entirely in English. • Experience Level: I have very little professional job experience, but I am targeting entry-level Data Analyst roles. What I need from you: • Framework for Technical Interviews: Help me structure my answers for SQL, Excel, and data visualization (Tableau/Power BI) questions, even with limited experience. • Behavioral & Case Prep: Teach me how to handle business case studies and behavioral questions using the STAR method, tailored to European corporate culture. • Portfolio Review: Quickly review how I present my projects/skills to ensure they stand out to recruiter...
...training • FI & CO focus: General Ledger Accounting (FI-GL), Cost Center Accounting (CO-OM-CCA) and Internal Orders (CO-OM-OPA). Please walk me through the key tables, field meanings, and the joins typically used for each area. • SQL in Databricks: I can read and write basic queries, but I want to become confident writing production-grade statements, optimising them for performance, and—importantly—prompting Gen AI tools to generate correct SQL from everyday FI/CO terminology. • Dashboard build: show me, step by step, how to turn those queries into a Databricks SQL dashboard designed for financial analysis and reporting. I would like practical examples such as a P&L view, cost-centre variance, and internal-order tracking. De...
Hi, I am a Data Analyst / BI professional with experience in SQL, Power BI, ETL, dashboards, and analytics. I am planning to explore international career opportunities, especially in countries like Australia, Europe, or the Middle East from India I am looking for an experienced career counsellor or recruiter who can guide me with: * International job market for Data Analyst / BI roles * Resume and LinkedIn optimization for overseas jobs * How recruitment works abroad * Countries with better opportunities and visa options * Work visa / sponsorship process * Job application strategy and interview preparation * Networking and recruiter outreach guidance I am mainly looking for consultation and practical guidance from someone who has experience helping IT professionals secure jobs a...
I'm seeking a tree plantation plan of Mahogany Trees for an open land.
...works this way: using AI to write, scaffold, and review code as a matter of course, not as a novelty. If that's not how you work, this isn't the right contract. The work: Connect mock UIs to live API calls across multiple user dashboards Integrate Clerk authentication with correct role-based access (5+ distinct user personas) Work within an established 16 / TypeScript monorepo (Turborepo) Query and shape data from MongoDB Maintain existing component library (shadcn/ui, Radix UI) You must have: 3+ years writing strict TypeScript, naturally, not reluctantly App Router fluency: RSC, Server Actions, middleware MongoDB: schema design, aggregation pipelines, indexing Auth: JWT, session management, claims-based access control Genuine hands-on AI development experience, Cl...
Role Summary We are seeking a Principal AI Engineer with deep expertise in Generative AI, and Agentic AI systems to lead the design and delivery of scalable, production-grade AI systems. This role require...Gemini, Azure OpenAI). Cloud AI Platforms: Experience with AI/ML services on any major cloud platform (Vertex AI, SageMaker, Azure ML). Preferred Skills Cloud-Native Systems: Experience building scalable systems using Docker, serverless, and managed cloud services. API & Backend Engineering: Experience in API design, development, and lifecycle management. Data & Persistence: Working knowledge of SQL (e.g., PostgreSQL) and NoSQL (e.g., DynamoDB) databases. Technical Leadership: Experience mentoring engineers, reviewing complex designs, and operating in agile, fast-chan...
I have a few Excel workbooks that tracks touch-football match results and player statistics. Before I start deeper analysis, this file needs a thorough review. I have done most of the data cleaning and processing with scripts, but I need help to cross-check the processed data against the source files and fix obvious or hidden errors....franchise (ie. sports teams) files that serve as the source of person stats, which will need to be referenced occasionally for certain errors - Total data to be reviewed spans 5 tournaments Deliverables - Validated Excel files ready for analysis - Flagged rows that were unable to be resolved - A short change log that summarises the key corrections and the rules you applied Feel free to leverage Power Query, formulas, VBA, or AI tools if that speeds ...
...What I need back: • Clean, well-commented VBA modules that automate the full sequence • Error handling so the macro fails gracefully and tells the user what went wrong • A quick read-me inside the code or a short PDF explaining how to trigger and edit the macro I work exclusively in Microsoft 365, so please test on the same version to avoid library conflicts. If you like to leverage Power Query or other native Excel tools as part of the VBA flow, just flag it first—flexibility is fine as long as the final trigger remains VBA-based. Timing is flexible over the next week, but let me know earliest availability and a realistic turnaround once you’ve seen the workbook. If you’ve got examples of prior Excel automation, a quick screenshot or descri...
...app developmentNative and cross-platform solutionsSecond platform app developmentUI/UX designConsulting and prototypingAutomated QA and testingPower managementNotification and geofencingEmbedded Android customizationsMaintenancePost-warranty supportWe use the latest technologies to produce fully-fledged, stable, and scalable mobile applications, including Kotlin, Java, React Native, Flutter, .NET, SQL Server, Azure DevOps, and provide the first week of onboarding at no cost and all our packages can be customized to meet your specific us today to learn more about how we can help you build a cutting-edge, customized solution for your business....
...whether that is a free financial API, a paid endpoint, or a lightweight scrape of NSE/BSE data—whichever is stable and within fair usage limits. • Once prices are pulled, the tool writes them into the designated column, updates the P/L calculation for each row (₹ value and percentage), and optionally flags any position whose CMP is at or below the stop-loss. You are free to use VBA, Power Query, Python, or another method that works inside Excel 2016 on Windows. Please keep the code well commented and include a short read-me so I can adjust symbols or expand the spreadsheet later. Deliver the working file and the source code, along with brief setup instructions. After that I will test it with my live portfolio to confirm the CMPs and calculations update correctly....
...Should Provide A professional delivery usually includes: Final Excel File * Clean structure * Working macros * Dashboard * Scenario tools Documentation * Model guide * VBA explanation * Input instructions Optional * Short Loom/video walkthrough * PDF summary ⸻ Skills You’ll Need To complete this project well: Excel * INDEX/MATCH/XLOOKUP * SUMIFS * Dynamic arrays * Pivot tables * Power Query VBA * Loops * UserForms * Automation * Error handling Financial Modelling * Forecasting * DCF * Scenario analysis * Sensitivity testing ⸻ Recommended Workflow Week 1 * Review existing model * Clean structure * Identify problems Week 2 * Add scenarios * Improve formulas * Build dashboards Week 3 * VBA automation * Testing * Documentation * Final delivery ⸻ If You...
I have collected a batch of survey responses and now need clear, actionable insights extracted from them. You will receive the raw file in whatever format you prefer—Excel/CSV, a database export, or a Google Sheets link—so you can work in your tool of choice (Python, R, Excel Power Query, SPSS, etc.). What I need from you: • Clean and structure the data so it is analysis-ready. • Perform a thorough statistical review—frequencies, cross-tabs, correlations, or other techniques you feel reveal the most useful story. • Visualize key findings in easy-to-share charts or dashboards. • Summarize results in plain language, highlighting patterns, surprises, and any recommendations you can confidently draw from the numbers. If you see value in deep...
...small mice peeking out from inside a kangaroo's pouch, cozy and happy, storybook illustration, soft pastel watercolor* --- ### Scene 4 — The Snake in the Tree *"When just up ahead they saw a snake in a tree / The snake like a shadow lay quiet and still..."* - Mice peek out of pouch — spot the snake coiled in branches ahead - Snake's eyes slowly open, fixed on Kanga - Mice duck back down, terrified - Kanga notices — rears back on her powerful tail - Confrontation: *"I'll rear back on my tail and come down on your head!"* - Snake retreats into the grass - **Mood:** Tension → triumph - **Image prompt:** *A large snake coiled menacingly in a tree above a path, dramatic lighting, storybook illustration style, ...
...edge materials, textures/graphic overlays, and schedule assignments directly into the Cabinet Vision SQL database. The app should allow the user to enter a material name, board thickness, custom thickness, texture/swatch image, edge thickness, and select which Cabinet Vision schedules the material should be applied to, such as assembly schedules, door schedules, drawer box schedules, and rollout schedules. Once entered, the user clicks a Deploy button and the app writes the required data into SQL. The app must also track all materials it has deployed and include a cleanup function that can safely remove those materials, edge materials, textures, and schedule entries from SQL. Strong SQL Server and Windows desktop application experience is required. Cabinet...
...client-facing tools. What I’m after • Clean, well-documented code that slots straight into an existing Git repository • Short feedback loops—push small updates, open pull requests, and respond to review comments quickly • Clear communication on progress or roadblocks via Slack or similar Typical tech stack you’ll touch JavaScript (React or Vue), Python (Flask or Django), a sprinkling of SQL, and basic DevOps in GitHub Actions or similar. If you’re stronger in adjacent languages or frameworks, mention them; I’m flexible as long as you can prove efficiency. Deliverables & acceptance 1. A functioning feature or bug-fix branch merged each week 2. Related unit tests passing in CI 3. A brief Markdown note that explains what chan...
I use Chatwoot to route my WhatsApp messages and I want to layer an AI assistant on top, orchestrated in n8n. The goal is simple: every inbound WhatsApp query about our products should be answered instantly, guided through pricing, and steered all the way to a closed sale without human help unless the bot flags an edge-case. The flow I picture works like this 1. n8n listens to the WhatsApp webhook coming from Chatwoot. 2. A dedicated autonomous node fires a custom prompt to the LLM (OpenAI or similar) so the reply is fully tailored, not a canned template. 3. The agent checks Google Sheets for live inventory, pricing and discount rules, writes back any new leads, and updates order status. 4. When the prospect isn’t ready to buy immediately, the bot schedules a follow-u...
...responsive data dashboard deployed 24/7 on a Linux Hetzner VPS (Germany). Speed and long-term stability are our absolute business priorities. ### PROJECT COMPONENTS & ROADMAP: 1. Real-Time Data Engine & Architecture: * Target endpoints: Three major German web platforms. * The system must fetch lightweight JSON data embedded in page responses using asynchronous Python architecture (asyncio) to query all filters and platforms in parallel. * Anti-Bot Engineering: Use specialized HTTP clients (like curl_cffi) to emulate proper TLS profiles and rotate residential proxy connections to bypass platform protections. 2. Telephony Backend & Carrier Integration: * Configure Asterisk to bundle 3 independent German SIP Trunks (Deutsche Telekom, Vodafone, o2 Telefónica). *...
I’m building a community-focused website that will serve two purposes: a rich business directory and a steady revenue channel through on-site advertising. The entire solut...revenue versus featured-listing upsells – Expansion path for sponsored content and local coupons Acceptance criteria 1. Fully responsive pages validated in the latest Chrome, Firefox and Safari. 2. Search and filter return results under 500 ms on a 5k-item dataset. 3. AI expiry logic successfully disables test ads on schedule during demo. 4. Delivered assets: source code, database schema (SQL or JSON), setup guide and business model document. If questions arise about edge cases—such as map integration or payment gateways—flag them early so we can decide whether they belong in ...
...integrated rod storage and generous, watertight storage compartments. Dimensions: attached in image, thickness: aluminum hull 3/16 inch and upper floor 1/8inch Reference boat: Deliverables • Solidworks assembly files • DXF and bend files Note: no AI generated images or model, I will report directly. only genuine work (Solidworks file with proper function tree.) Duration: 3 Days....