Sql server xml query null jobs
...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): *...
...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...
Fix my WordPress website. I can't access the admin - getting login errors - not sending password (or reset passw...access the admin - getting login errors - not sending password (or reset password) when requested. It is hosted on DreamHost. I do have recent WP Staging backup (just over a gig), but haven't used it, since I can't access the WP admin anyway. I suppose I could just reinstall WP, install that plugin, then restore, but not sure if I should try that. I also have an xml file. Need someone who doesn't ask me to release payment the second they say the work is done. Usually, I've seen, fixes work for a couple days, THEN break again. So be patient before you ask me for release and review. If you really believe in your work, you'll wait a ...
...2 pages or blogs optimized for AI answer visibility 5 long-tail question-based content ideas 1 AI visibility improvement recommendation report 6. Technical SEO You should identify and help fix technical SEO issues affecting crawlability, indexing, speed, and performance. Tasks include: Crawl error review Indexing checks Broken link checks Redirect review Canonical tag review review XML sitemap review Duplicate content checks Thin content checks Page speed review Mobile usability review Core Web Vitals review Schema recommendations 404 review Orphan page identification Weekly minimum deliverables: 1 technical SEO health check Broken link review Indexing issue review 3 to 5 technical recommendations 1 page speed or Core Web Vitals review 7. Off-page SEO and authority building...
I have a fresh Ubuntu/Linux server online and need it turned into a fully functioning web platform running Nginx. Your task is to install and configure Nginx, secure the system, and leave it ready for me to deploy sites straight away. Deliverables • Nginx installed and serving a test page over HTTP (and HTTPS if you choose to include a simple Let’s Encrypt or self-signed certificate). • Core security in place—firewall rules applied and the service set to start automatically after reboot. • A concise log or script of every command or config change so I can reproduce or edit the setup later. If you’ve handled production Ubuntu web servers before, this should be quick work; let me know your estimated turnaround and any questions you need answere...
...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...
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 u...
I need a clean Postfix installation configured to h...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-re...
...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...
...props, LODs, lightings, crashes, and map conflicts Optimize server performance, resource usage, and client FPS Review and clean up map files where needed Edit map where needed Ensure assets are compatible and stable across the server Troubleshoot bugs related to MLOs, YMAPs, collisions, LODs, portals, interiors, and streaming Merge MLOs into groups assets, eg. x6-dealershipmaps, x6-mechanicmaps, x6-bankmaps Strong experience with FiveM map development Advanced knowledge of MLOs, YMAPs, YTYPs, collisions, portals, and streaming Proven experience optimizing large FiveM servers Ability to handle a city with a high number of custom interiors and assets Experience fixing conflicts between maps and resources Good understanding of server/client performance impact Reliable...
...professional symbology and a reusable style library - Configure a QGIS print layout template suitable for inclusion in proposals and briefings - Light Python/PyQGIS scripting for repeatable CSV imports (nice to have, not essential for v1) Deliverables - QGIS project file (.qgz) - GeoPackage (.gpkg) containing all layers - Documented layer structure and naming conventions - Style library (.qml or .xml) - Print layout template - Short written user guide for updating and adding data - One recorded handover session (Teams or Zoom, ~1–2 hours) Constraints - Must be QGIS-native — no ArcGIS dependencies, no proprietary platforms, no cloud hosting - All files must remain fully editable and owned by me after handover - Open-source stack only About you - Strong QGIS exper...
I wil...optimization for your website to improve search visibility, organic traffic, and overall website performance. The work will include a detailed website SEO audit, on-page SEO fixes, meta title and description optimization, heading structure improvements, image optimization, internal linking enhancements, keyword research and mapping, URL optimization, technical SEO recommendations, indexing checks, XML sitemap and review, Google Search Console setup/review, performance monitoring, and competitor analysis. I will also identify growth opportunities and provide recommendations to improve rankings, user experience, and conversions. Progress updates and implementation status will be shared throughout the project to ensure measurable SEO improvements and long-term website growth.
...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 ...
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’...
...Implement a comprehensive backup and restore feature using local storage for my self-hosted movie platform. This system should create automated backups of the entire application stack, including the database with user accounts and movie metadata, all media files (movies, posters, thumbnails), configuration files, and any custom themes or scripts. Please set up a backup directory structure on my server with organized subdirectories for different backup types and timestamps, utilizing incremental backup technology to save storage space while maintaining complete data integrity. The solution should include scheduled daily, weekly, and monthly backups with configurable retention periods to automatically remove older backups and prevent storage issues. For restoration, please develop ...
...Implement a comprehensive backup and restore feature using local storage for my self-hosted movie platform. This system should create automated backups of the entire application stack, including the database with user accounts and movie metadata, all media files (movies, posters, thumbnails), configuration files, and any custom themes or scripts. Please set up a backup directory structure on my server with organized subdirectories for different backup types and timestamps, utilizing incremental backup technology to save storage space while maintaining complete data integrity. The solution should include scheduled daily, weekly, and monthly backups with configurable retention periods to automatically remove older backups and prevent storage issues. For restoration, please develop ...
...streaming—Firebase, AWS or a comparable stack is fine as long as latency stays low • Secure payment flow for subscriptions (Google Play Billing) • Push notifications, basic analytics hooks and an admin dashboard for content moderation Deliverables 1. Gradle-based Android Studio project with commented source code 2. Deployed backend (API + database + media storage) and infra scripts 3. Design assets (XML layouts or Jetpack Compose) and finalized UI prototypes 4. End-to-end test APK plus install guide 5. Short video demo and README covering setup, key modules and future extension points Acceptance will be based on smooth real-time audio, reliable chat with <200 ms delay, error-free profile/messaging flows, and successful subscription purchase ...
My production servers require dedicated, ongoing management to stay fast, stable, and secure. I need a professional who can take full ownership of the server layer—from provisioning new instances to applying critical patches and monitoring performance around the clock. Typical work will involve: • Planning and executing clean server builds or migrations when growth demands it • Hardening the OS and services with timely updates, backups, and disaster-recovery checks • Tracking resource usage, tuning services, and troubleshooting incidents before they affect end-users Success means zero-downtime deployments, predictable performance under load, and clear hand-off documentation for every change you make. If you are comfortable living in the shell, aut...
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...
...behaviour must feel authentic. In-game integration Once the model and scripts are complete, you will package and submit the mod to the official FS25 ModHub for console approval, handling any XML, i3D, or LUA tweaks the submission process demands. I will supply the reference files and test the build, but final publication to the hub is part of your task. Budget & timeline The entire job—including any ModHub resubmissions—needs to stay under the AUD 200 dollars wont go above and be wrapped up within a mutually agreed schedule. Deliverables 1. Finished i3D model, textures (PBR), and all supporting XML/LUA files. 2. Packaged zip ready for FS25 console release. 3. Proof of successful ModHub submission (screenshot or link). 4. Brief PDF/User guide covering con...
...behaviour must feel authentic. In-game integration Once the model and scripts are complete, you will package and submit the mod to the official FS25 ModHub for console approval, handling any XML, i3D, or LUA tweaks the submission process demands. I will supply the reference files and test the build, but final publication to the hub is part of your task. Budget & timeline The entire job—including any ModHub resubmissions—needs to stay under the AUD 200 dollars wont go above and be wrapped up within a mutually agreed schedule. Deliverables 1. Finished i3D model, textures (PBR), and all supporting XML/LUA files. 2. Packaged zip ready for FS25 console release. 3. Proof of successful ModHub submission (screenshot or link). 4. Brief PDF/User guid...
...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, Claude Code specifically preferred Self-directed: you will be working closely with a solo founder, n...
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...
...filters) • Inquiry / Booking form that routes to both email and WhatsApp • Testimonials carousel • Contact page featuring an embedded Google Map and quick-contact details Essential functionality • Fully responsive design for mobile, tablet and desktop • Lightweight code and image optimisation for rapid load times • Clean semantic markup and on-page SEO best practices (H-tags, meta, XML sitemap, ALT tags) • Admin dashboard (WordPress, Webflow, or similar CMS—open to your recommendation) so I can update text, fleet photos and pricing in-house • Facebook and Instagram integration for live feeds or social icons; LinkedIn can remain optional for future expansion • Guidance on selecting and connecting a domain, hos...
...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....
...infrastructure to replace the deprecated SSL VPN for 600 concurrent users. Deploy seamlessly alongside the legacy VPN for zero downtime. Include Geo-fencing Local-In policies. Authentication Integration (NPS Build Required): Address the IKEv2 EAP-MSCHAPv2 requirement for Active Directory. The client does not currently have a RADIUS server. You will be required to install and configure the Windows Network Policy Server (NPS) role on their existing on-premise AD server, configure the RADIUS clients/policies, and integrate it with the FortiGate to support the new IKEv2 dial-up users. Phase 4: High Availability (HA) Management Remediation OOB Management: Configure dedicated Out-of-Band (OOB) HA Management interfaces on both the primary and secondary units using the M...
...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...
...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. ...
...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...
